Hi Simon
A GeoFence Table is a table that list all the GeoFences that have been created each record represents a different geo fence each with its own set of co ordinates that make up the GeoFence area Thanks for your response I will look into the reference you have provided Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: [email protected] [mailto:[email protected]] On Behalf Of Simon Haddon Sent: Tuesday, 4 June 2013 10:25 PM To: [email protected] Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality I am not sure what the Geo Fence table actually is but either way to find if a location is inside or outside your fence it is simple if you have a closed polygon. You are looking to performa point-in-polygon test where an even result means the location is outside and an odd result means it is inside. Have a look at http://en.wikipedia.org/wiki/Point_in_polygon and in particular the ray-casting method. I have used this before and it is fast. Cheers, Simon On 4 June 2013 19:58, <[email protected]> wrote: I have the Tracking Server with listener set up so the listener captures the data (long / lat) sent from the mobile tracking devices to the server, which is then stored into an sql table I have the Bing Maps API set up so the locations stored in the above database table correctly display on the bing map The challenge is trying to figure out how to create Geo Fence functionality combining SQL 2008, using Bing Maps API and using CF application to manage and display the Geo Fences I am wanting to be able to create circular zones so the co ordinates are saved in the geo fence table assigned to a specific device id, Once the geo fences are created and stored in the geo fence table each new location sent to the tracking server then needs to be validated against existing geo fences to determine if the new location is inside or outside of geo fences listed in the geo fence table If anyone can assist to direct me to a resource or example code that deal with the above I would appreciate the advise Kind Regards Claude Raiola -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:cfaussie%[email protected]> . To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
