[MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?

[Nolte, Tim]

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 - tnolte at ilpcs.com
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: mapserver-users-bounces at lists.osgeo.org 
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of 
> Bill Wordsworth
> Sent: Monday, August 04, 2008 12:28 PM
> To: mapserver-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
>