Ah, I took my own advise as to what a GeoFence is. It is a virtual boundary. Makes more sense now. I thought you might have been mapping real boundaries. Either way. I have some code I wrote in C years ago somewhere that does a point-in-polygon check. It was easy. The main trick is to shift the coordinates so are all positive numbers. It probably doesn't matter for longitude as you would have 0-360 but shift any latitude numbers up if any are negative. Then you can easily extrapolate if either the x or y axis are crossed a positive or negative number of times. It also handles geographic donuts if you have any.
Another option might be to move your data into PostgreSQL with PostGIS extensions. Then you have all the geospatial tools you need . Cheers, Simon On 4 June 2013 23:52, <rai...@ozemail.com.au> wrote: > *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:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On > Behalf Of *Simon Haddon > *Sent:* Tuesday, 4 June 2013 10:25 PM > *To:* cfaussie@googlegroups.com > *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, <rai...@ozemail.com.au> 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 cfaussie+unsubscr...@googlegroups.com. > To post to this group, send email to cfaussie@googlegroups.com. > 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 cfaussie+unsubscr...@googlegroups.com. > To post to this group, send email to cfaussie@googlegroups.com. > 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 cfaussie+unsubscr...@googlegroups.com. > To post to this group, send email to cfaussie@googlegroups.com. > 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 cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
