Hi Zack
Thanks for that But if I do not use Bing or Google apis with their associated maps where do I source the mapping information from and also have confidence that the mapping information / reverse geo coding results etc are accurate and kept up to date The entry level Bing mapping license for fixed assets for example is around $6,000 pa where as the Google equivalent is closer to $12,000 pa Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Thursday, 6 June 2013 12:01 PM To: CFAussie Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality re vendors api's yes... also be aware of the strict usage and licensing restrictions with those vendor api's/services using STContains is really simple, it just goes in the where clause and returns a normal query, if you are returning the spatial objects use .STAsText() to return WKT which you can then pass into your javascript stuff On Thu, Jun 6, 2013 at 11:47 AM, <rai...@ozemail.com.au> wrote: Are your concerns re vendors api's only to give you the flexibility of changing backend at some later date with less hassle Also the STContains is that something I can use within my CF query, only every written very standard cf queries in the past so excuse me for asking the question if it appear a little novice Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Wednesday, 5 June 2013 5:22 PM To: CFAussie Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality you just need to create a table with the polygons, then you can use a built in function like STContains http://technet.microsoft.com/en-us/library/bb933904.aspx also, I would recommend considering avoiding using propriety vendor apis like google maps or bing, stick with something like flexible like openlayers or leafletJS so that you can easily swap backends On Wed, Jun 5, 2013 at 5:11 PM, <rai...@ozemail.com.au> wrote: Hi Zac Thanks for your reply If you have any suggestions on the best way to record geo fence zones with z radius so that the system can then detect whenever a given reported location is inside / outside of a given zone I would appreciate it I am using the Bing mapping api and I am developing the tracking portal app in CF Kind Regards Claude Raiola SAMARIS Software Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Zac Spitzer Sent: Wednesday, 5 June 2013 3:07 PM To: CFAussie Subject: Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality SQL Server 2008 also supports proper spatial? On Wed, Jun 5, 2013 at 2:19 PM, Robin Hilliard <ro...@rocketboots.com.au> wrote: Hi Claude, Funny, happened to have some CF code to check for polygon containment open when I saw your post: function polyContains(poly, lon, lat) { var j = 1; var oddNodes = false; var lenPoly = arrayLen(poly); for (var i = 1; i < lenPoly; i += 2) { j = i + 2; if (j > lenPoly - 2) j = 1; if (((poly[i + 1] > lat) != (poly[j + 1] > lat)) // the polygon edge passes through the lattitude lat and ((((lat - poly[i + 1]) * (poly[j] - poly[i])) / (poly[j + 1] - poly[i + 1])) < lon)) // at lattitude lat, polygon edge is west of lon oddNodes = !oddNodes; } return oddNodes; }; I'm using this because MySQL spatial polygon containment only compares bounding boxes (on the version supported by Redhat). MySQL whittles the list down to a few polygons and I use this to do the rest, based on the odd/even polygon containment test. Note that poly is a flat array containing lon lat pairs. I'm currently running some tests on a database of about 5,000 polygons covering SE Australia, sampling every one km grid. There are a few anomalies I'm investigating, hopefully it's the data and not an algorithm glitch but you have been warned. Robin ROBIN HILLIARD Chief Technology Officer ro...@rocketboots.com.au RocketBoots Pty Ltd Level 11 189 Kent Street Sydney NSW 2001 Australia Phone +61 2 9323 2507 Facsimile +61 2 9323 2501 Mobile +61 418 414 341 www.rocketboots.com.au <http://www.rocketboots.com.au/> On 04/06/2013, at 7:58 PM, 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 <mailto:cfaussie+unsubscr...@googlegroups.com> cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to <mailto:cfaussie@googlegroups.com> cfaussie@googlegroups.com. Visit this group at <http://groups.google.com/group/cfaussie?hl=en> http://groups.google.com/group/cfaussie?hl=en. For more options, visit <https://groups.google.com/groups/opt_out> 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 <mailto:cfaussie%2bunsubscr...@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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- 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 <mailto:cfaussie%2bunsubscr...@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 <mailto:cfaussie%2bunsubscr...@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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- 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 <mailto:cfaussie%2bunsubscr...@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 <mailto:cfaussie%2bunsubscr...@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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168 -- 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.