On 3/17/2011 12:07 AM, Bryan Stevenson wrote: > Rob, you confirmed what I thought.....this shouldn't be rocket science.
no, but it can hurt like the dickens. > 1) No data structure defined as of yet > 2) May not have access to the GIS system just use postGIS/postgreSQL. has tools to load shapefiles into it, you can do PiP & other spatial functions w/fairly simple SQL, vibrant & helpful community and cf talks to it just swell. when you come to visualize this, geoserver is pretty good & also talks to postGIS just fine. then there's google fusion tables. its spatial functionality is pretty dumb compared to postGIS but it can so some spatial querying (like PiP), its hosted by google & so far free. i use it to store planned bike routes for an app i'm tinkering with. works ok. if your data or application products are very valuable & enterprisey then you might consider ESRI's tools like gisServer, arcSDE, etc. which i think would make rob happy ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm