RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-05 Thread raiola
: 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 simpl

Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-05 Thread Zac Spitzer
> 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

RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-05 Thread raiola
s.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,

Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-05 Thread Zac Spitzer
; ** ** > > 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 > > *S

RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-05 Thread raiola
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 wrote: Hi Claude, Funny, happened to have some CF code to check for polygon containment open when I saw your post: function polyContains

Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-04 Thread Zac Spitzer
SQL Server 2008 also supports proper spatial? On Wed, Jun 5, 2013 at 2:19 PM, Robin Hilliard 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*

Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-04 Thread Robin Hilliard
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 =

Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-04 Thread Simon Haddon
> ** ** > > 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

RE: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-04 Thread raiola
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

Re: [cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-04 Thread Simon Haddon
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 insid

[cfaussie] Cold Fusion with SQL and Geo Spatial Mapping Geo Fence Functionality

2013-06-04 Thread raiola
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