Thanks Paul, lots of good info there!
Just to be clear, there would not be any visualization or anything fancy....just checking to see if the point is in the box/shape or not - the end ;-) I'd hope to have the shapes stored in whatever manner they need to be stored in (8 in total) the DB and my inputs would be the shape and the lat/long of the point....wanting an output of in or out. Cheers On Thu, 2011-03-17 at 01:23 +0700, Paul Hastings wrote: > 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:343077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm