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