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)?
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)?
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
[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#example-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
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
