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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
