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