Re: [MAPSERVER-USERS] How to map attribute data (non-geom) fromOracle(not Spatial)?
msDrawMap(): Image handling error. Failed to draw layer named 'ora'. msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not supported Upgrade or perish? Can I compile support into my existing setup (4.8.3)? I've heard Hobu is great at this :). I am afraid with all the syntax changes in 5.2.x my map files will throw bigger errors. Cheers, Bill On Wed, Aug 6, 2008 at 3:20 PM, Nolte, Tim [EMAIL PROTECTED] wrote: 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 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
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
[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] upload/stream data from GPS unit?
Please let's not hijack my poor thread :)! Anyway, here's my original question: How can I upload/stream near-real-time GPS data from on-site to webserver/MapServer (MapServer 5.x can read *.gpx)? I've been referred to http://franson.com/gpsgate/ from the usenet groups. I am looking for something with WPA. Cheers, Bill On Wed, Mar 26, 2008 at 11:39 AM, Carlos Pinto [EMAIL PROTECTED] wrote: Hi all, I'm new in MapServer and I'm using Openlayers that can be a client of MapServer. What I'm trying to set-up is a grid that is in GML file. And I want MapServer to build the layer reading the GML file and give it to OpenLayers (javascript API) would read it as WMS. I have instaled MapServer in C# so I'm using MapScript. Is this possible? Thanks Carlos ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users On Wed, Mar 26, 2008 at 11:25 AM, Bill Wordsworth [EMAIL PROTECTED] wrote: How can I upload/stream near-real-time GPS data from on-site to webserver/MapServer (MapServer 5.x can read *.gpx)? Cheers, Bill ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] upload/stream data from GPS unit?
Thanks Steve. I am clear about the mapping part. I am not so sure about streaming/uploading near-real-time GPS data from on-site to webserver across WPA? Cheers, Bill On Thu, Mar 27, 2008 at 3:10 PM, Stephen Woodbridge [EMAIL PROTECTED] wrote: Bill, There are probably many solutions available depending on the various technical components that you might have in the solution. One possible solution might be something along these lines: 1) stream data to some service that you probably have to build 2) have said service load the points into a postgres/postgis database 3) create a mapfile with a LAYER to disply the data from postgis 4) Use a client like OpenLayers to render you map from mapserver 5) add a timer event to refresh your map every X secs -Steve W http://imaptools.com/ Bill Wordsworth wrote: Please let's not hijack my poor thread :)! Anyway, here's my original question: How can I upload/stream near-real-time GPS data from on-site to webserver/MapServer (MapServer 5.x can read *.gpx)? I've been referred to http://franson.com/gpsgate/ from the usenet groups. I am looking for something with WPA. Cheers, Bill On Wed, Mar 26, 2008 at 11:39 AM, Carlos Pinto [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi all, I'm new in MapServer and I'm using Openlayers that can be a client of MapServer. What I'm trying to set-up is a grid that is in GML file. And I want MapServer to build the layer reading the GML file and give it to OpenLayers (javascript API) would read it as WMS. I have instaled MapServer in C# so I'm using MapScript. Is this possible? Thanks Carlos ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto: mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users On Wed, Mar 26, 2008 at 11:25 AM, Bill Wordsworth [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: How can I upload/stream near-real-time GPS data from on-site to webserver/MapServer (MapServer 5.x can read *.gpx)? 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
