Tim, I didn't know you could do "geom from..." without Oracle Spatial, so this is great!
This is my current compilation: MapServer version 4.8.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG I don't see any Oracle support. Could you shed some light on how to enable that? And how do you insert geom into Oracle Locator without Oracle Spatial- what tools? So as I understand, Oracle Spatial allows geoprocessing type queries (buffer, nearest, shortest) while Oracle Locator doesn't allow any thing that but does display geom (point, line, polygon, (raster)). Correct?? I just want to take a shapefile, insert it and then display its filtered set. Cheers, Bill On Tue, Aug 5, 2008 at 10:38 AM, Nolte, Tim <[EMAIL PROTECTED]> wrote: > Bill, > > Here is a layer definition I am using for Oracle Spatial(Locator) data. > > LAYER > GROUP "Cell Sites" > NAME "On-Air" > TYPE POINT > STATUS ON > CONNECTIONTYPE oraclespatial > CONNECTION "username/[EMAIL PROTECTED]" > PROCESSING "CLOSE_CONNECTION=DEFER" > DATA "geom FROM (SELECT st.bts_nbr, sgt.geom FROM site_tab st, > site_geom_tab sgt WHERE st.site_id = sgt.site_id AND st.site_status_id > IN (4,7)) USING SRID 8307" > LABELITEM "bts_nbr" > METADATA > "static_legend" "1" > END > DUMP true > CLASS > NAME "On-Air Large Scale" > MINSCALE 0 > MAXSCALE 1200000 > STYLE > SYMBOL "circle" > COLOR 22 129 17 > OUTLINECOLOR 255 255 255 > SIZE 12 > END > LABEL > TYPE TRUETYPE > FONT "sans" > SIZE 7 > POSITION CR > OFFSET 0 2 > ANGLE AUTO > BUFFER 3 > MINDISTANCE 30 > MINFEATURESIZE 10 > COLOR 0 0 0 > OUTLINECOLOR 245 245 231 > SHADOWSIZE 3 3 > BACKGROUNDSHADOWSIZE 1 -1 > END > END > CLASS > NAME "On-Air Small Scale" > MINSCALE 1200000 > MAXSCALE 6000000 > STYLE > SYMBOL "circle" > COLOR 22 129 17 > OUTLINECOLOR 255 255 255 > SIZE 8 > END > END > END > > The key here is that you need to have MapServer compiled with Oracle > Spatial support. And you can see from my data line that that I do > standard Oracle SQL statements for building my spatial results. I'm not > using any shapefiles in this instance. The spatial data is actually > stored right in the database table. There are tools to import shapefiles > into Oracle. If your data is points you can build insert statements to > populated your geometry columns. You're probably going to want to do > some reading up on Oracle spatial. > > - Tim > > ---- > Timothy J Nolte - [EMAIL PROTECTED] > Network Planning Engineer > > iPCS Wireless, Inc. > 4717 Broadmoor Ave, Suite G > Kentwood, MI 49512 > > Office: 616-656-5163 > PCS: 616-706-2438 > Fax: 616-554-6484 > Web: www.ipcswirelessinc.com > >> -----Original Message----- >> From: Bill Wordsworth [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, August 05, 2008 10:25 AM >> To: Nolte, Tim; mapserver-users@lists.osgeo.org >> Subject: Re: [MAPSERVER-USERS] How to map attribute data >> (non-geom) from Oracle(not Spatial)? >> >> This is exciting news! I am using Oracle 10g and get Oracle Locator >> free but how do I map data from Oracle Locator? Are you doing a >> JOIN+FILTER? Can you share a LAYER snippet from your MAP file? >> Cheers, Bill > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users