http://www.oracle.com/technology/products/spatial/spatial_locator_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
