Bill, You got it.
- 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Bill Wordsworth > Sent: Wednesday, August 06, 2008 2:47 PM > To: mapserver-users@lists.osgeo.org > Subject: Re: [MAPSERVER-USERS] How to map attribute data > (non-geom) fromOracle(not Spatial)? > > http://www.oracle.com/technology/products/spatial/spatial_loca > tor_features.html > > Shapefile Converter > SQL*Loader > MapServer Query? Is that > all it takes? > > On Tue, Aug 5, 2008 at 4:01 PM, Bill Wordsworth > <[EMAIL PROTECTED]> wrote: > > 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 > > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users