Re: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?
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 120 >> 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 120 >> MAXSCALE 600 >> 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
Re: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?
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 120 > 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 120 > MAXSCALE 600 > 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
RE: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?
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 120 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 120 MAXSCALE 600 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
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 On Mon, Aug 4, 2008 at 1:15 PM, Nolte, Tim <[EMAIL PROTECTED]> wrote: > What version of Oracle are you using? If you are using 10g or higher it > comes with Oracle Locator free. Oracle Locator is like Oracle Spatial > Lite. We are using this for point data and polygons for our MapServer. > > - 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: Monday, August 04, 2008 12:28 PM >> To: mapserver-users@lists.osgeo.org >> Subject: [MAPSERVER-USERS] How to map attribute data >> (non-geom) from Oracle(not Spatial)? >> >> What is the best way to map attribute data (non-geom) from Oracle (not >> Spatial) using MapServer? >> >> Can I do this? >> LAYER >> NAME "states_shapefile" >> DATA "path/states_shapefile" >> ... >> JOIN >> NAME "oracle" >> CONNECTIONTYPE ogr >> CONNECTION "..." >> TABLE "oracle_states_table" >> FROM "oracle_name" >> TO "shapefile_name" >> TYPE ONE-TO-ONE >> END >> # FILTERITEM "" >> FILTER "governor='Arnold'" >> END >> http://mapserver.gis.umn.edu/docs/reference/mapfile/join#examp >> le-2-join-from-shp-file-to-postgresql-table >> >> If not, what is the best way around? >> * Spend $$$ for Oracle Spatial >> * Nightly convert attribute data to shapefile >> * Nightly convert attribute data to PostGIS >> >> Any thoughts on the maintenance cost for each? >> 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
RE: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?
What version of Oracle are you using? If you are using 10g or higher it comes with Oracle Locator free. Oracle Locator is like Oracle Spatial Lite. We are using this for point data and polygons for our MapServer. - 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: Monday, August 04, 2008 12:28 PM > To: mapserver-users@lists.osgeo.org > Subject: [MAPSERVER-USERS] How to map attribute data > (non-geom) from Oracle(not Spatial)? > > What is the best way to map attribute data (non-geom) from Oracle (not > Spatial) using MapServer? > > Can I do this? > LAYER > NAME "states_shapefile" > DATA "path/states_shapefile" > ... > JOIN > NAME "oracle" > CONNECTIONTYPE ogr > CONNECTION "..." > TABLE "oracle_states_table" > FROM "oracle_name" > TO "shapefile_name" > TYPE ONE-TO-ONE > END > # FILTERITEM "" > FILTER "governor='Arnold'" > END > http://mapserver.gis.umn.edu/docs/reference/mapfile/join#examp > le-2-join-from-shp-file-to-postgresql-table > > If not, what is the best way around? > * Spend $$$ for Oracle Spatial > * Nightly convert attribute data to shapefile > * Nightly convert attribute data to PostGIS > > Any thoughts on the maintenance cost for each? > 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