Re: [AFMUG] Google Maps

[Jaime Solorza]

Ha...

On Mar 31, 2017 12:20 PM, "Mike Hammett" <af...@ics-il.net> wrote:

> Ms. Pacman.
>
>
>
> -
> Mike Hammett
> Intelligent Computing Solutions <http://www.ics-il.com/>
> <https://www.facebook.com/ICSIL>
> <https://plus.google.com/+IntelligentComputingSolutionsDeKalb>
> <https://www.linkedin.com/company/intelligent-computing-solutions>
> <https://twitter.com/ICSIL>
> Midwest Internet Exchange <http://www.midwest-ix.com/>
> <https://www.facebook.com/mdwestix>
> <https://www.linkedin.com/company/midwest-internet-exchange>
> <https://twitter.com/mdwestix>
> The Brothers WISP <http://www.thebrotherswisp.com/>
> <https://www.facebook.com/thebrotherswisp>
>
>
> <https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>
> --
> *From: *"Jaime Solorza" <losguyswirel...@gmail.com>
> *To: *"Animal Farm" <af@afmug.com>
> *Sent: *Friday, March 31, 2017 1:13:35 PM
> *Subject: *Re: [AFMUG] Google Maps
>
> What is supposed to happen?
>
> On Mar 31, 2017 12:01 PM, "Mike Hammett" <af...@ics-il.net> wrote:
>
>> maps.google.com  Check it out.
>>
>>
>>
>> -
>> Mike Hammett
>> Intelligent Computing Solutions <http://www.ics-il.com/>
>> <https://www.facebook.com/ICSIL>
>> <https://plus.google.com/+IntelligentComputingSolutionsDeKalb>
>> <https://www.linkedin.com/company/intelligent-computing-solutions>
>> <https://twitter.com/ICSIL>
>> Midwest Internet Exchange <http://www.midwest-ix.com/>
>> <https://www.facebook.com/mdwestix>
>> <https://www.linkedin.com/company/midwest-internet-exchange>
>> <https://twitter.com/mdwestix>
>> The Brothers WISP <http://www.thebrotherswisp.com/>
>> <https://www.facebook.com/thebrotherswisp>
>>
>>
>> <https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>
>>
>
>

Re: [AFMUG] Google Maps

[Mike Hammett]

Ms. Pacman. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -

From: "Jaime Solorza" <losguyswirel...@gmail.com> 
To: "Animal Farm" <af@afmug.com> 
Sent: Friday, March 31, 2017 1:13:35 PM 
Subject: Re: [AFMUG] Google Maps 


What is supposed to happen? 


On Mar 31, 2017 12:01 PM, "Mike Hammett" < af...@ics-il.net > wrote: 




maps.google.com Check it out. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 

Re: [AFMUG] Google Maps

[Jaime Solorza]

What is supposed to happen?

On Mar 31, 2017 12:01 PM, "Mike Hammett"  wrote:

> maps.google.com  Check it out.
>
>
>
> -
> Mike Hammett
> Intelligent Computing Solutions 
> 
> 
> 
> 
> Midwest Internet Exchange 
> 
> 
> 
> The Brothers WISP 
> 
>
>
> 
>

Re: [AFMUG] Google Maps

[David Coudron]

Already wasted 10 minutes of my day…. 

David Coudron
david.coud...@advantenon.com<mailto:david.coud...@advantenon.com>  |  Mobile: 
612-991-7474

Advantenon, Inc. [cid:image001.png@01CEE562.60FF8FC0] 
<http://www.linkedin.com/company/Advantenon>   
[cid:image002.png@01CEE562.60FF8FC0] <http://www.twitter.com/Advantenon>   
[cid:image003.png@01CEE562.60FF8FC0] <http://www.facebook.com/Advantenon>   
[cid:image004.png@01CEE562.60FF8FC0] <http://blog.advantenon.com/>
i...@advantenon.com<mailto:i...@advantenon.com>  |  3500 Vicksburg Lane N, 
Suite 315, Plymouth, MN 55447  |  
www.advantenon.com<http://www.advantenon.com/>  |  Phone: 800-704-4720  |  
Local: 612-454-1545

[cid:image010.jpg@01D2AA1F.613D6F90]

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Mike Hammett
Sent: Friday, March 31, 2017 1:01 PM
To: af@afmug.com
Subject: [AFMUG] Google Maps

maps.google.com  Check it out.


-
Mike Hammett
Intelligent Computing Solutions<http://www.ics-il.com/>
[http://www.ics-il.com/images/fbicon.png]<https://www.facebook.com/ICSIL>[http://www.ics-il.com/images/googleicon.png]<https://plus.google.com/+IntelligentComputingSolutionsDeKalb>[http://www.ics-il.com/images/linkedinicon.png]<https://www.linkedin.com/company/intelligent-computing-solutions>[http://www.ics-il.com/images/twittericon.png]<https://twitter.com/ICSIL>
Midwest Internet Exchange<http://www.midwest-ix.com/>
[http://www.ics-il.com/images/fbicon.png]<https://www.facebook.com/mdwestix>[http://www.ics-il.com/images/linkedinicon.png]<https://www.linkedin.com/company/midwest-internet-exchange>[http://www.ics-il.com/images/twittericon.png]<https://twitter.com/mdwestix>
The Brothers WISP<http://www.thebrotherswisp.com/>
[http://www.ics-il.com/images/fbicon.png]<https://www.facebook.com/thebrotherswisp>[http://www.ics-il.com/images/youtubeicon.png]


<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>

[AFMUG] Google Maps

[Mike Hammett]

maps.google.com Check it out. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 

Re: [AFMUG] Google Maps

[Rory Conaway]

The developers came up with a couple ideas.  One was to define the corners 
using lat/long and convert the address to see if it’s within that zone.  It 
gets a little more complicated depending on number of vertices but  then it’s 
just how much you want to automate.

Rory


From: Af [mailto:af-boun...@afmug.com] On Behalf Of Jerry Richardson
Sent: Tuesday, March 31, 2015 2:04 PM
To: af@afmug.com
Subject: Re: [AFMUG] Google Maps

Don't know if this helps:

https://developers.google.com/maps/documentation/

Jerry

On Mar 31, 2015, at 9:39 AM, Sterling Jacobson 
sterl...@avative.netmailto:sterl...@avative.net wrote:
Rory, let me know if they work out for you, I might also hire them if the price 
is right.

I have a couple of projects requiring this, one for internal viewing, status 
etc. on sort of a live view of network status maybe.

The other for external use to overlay a percentage and color block/polygon on a 
 few neighborhoods.

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Rory Conaway
Sent: Tuesday, March 31, 2015 9:47 AM
To: af@afmug.commailto:af@afmug.com
Subject: Re: [AFMUG] Google Maps

We would like to do the same thing.  I have a couple of programmers looking at 
it now.

Rory

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck Hogg
Sent: Tuesday, March 31, 2015 8:40 AM
To: af@afmug.commailto:af@afmug.com
Subject: Re: [AFMUG] Google Maps

Sounds like we are thinking along the same lines...I haven't gotten anywhere 
yet though.
https://storage.googleapis.com/support-kms-prod/BB0864B3FF4593A5424C90DB5B23B59E2255

Regards,
Chuck

On Tue, Mar 31, 2015 at 9:22 AM, Chuck McCown 
ch...@wbmfg.commailto:ch...@wbmfg.com wrote:
I interfaced a spreadsheet with Google Earth Pro a while back.  Can't remember 
exactly how I did it but it was pretty easy.

-Original Message- From: Sterling Jacobson
Sent: Monday, March 30, 2015 4:50 PM
To: 'af@afmug.commailto:af@afmug.com'
Subject: [AFMUG] Google Maps


Anyone ever tied in a database to google maps and earth?

I want to define a boundary area on the map and then take address fields from a 
database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Jon Auer]

Have you looked at the Spatial extensions for SQL Server?
https://msdn.microsoft.com/en-us/library/bb933790.aspx?f=255MSPPError=-2147217396

That should take care of all the querying once you get the shape/polygon
from Google Maps API.

Plat uses lat+lon columns of (iirc) float instead of the proper point type
in one column so I ended up adding a point column and populating it from
the lat/lon.



On Mon, Mar 30, 2015 at 6:06 PM, Sterling Jacobson sterl...@avative.net
wrote:

  I’m sticking it in Microsoft SQL as additional tables to my Platypus SQL
 stuff.





 *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *D. Ryan Spott
 *Sent:* Monday, March 30, 2015 5:05 PM
 *To:* af@afmug.com
 *Subject:* Re: [AFMUG] Google Maps



 What is your database? I have some PHP code I wrote a while ago that maps
 things.

 ryan

 On 3/30/15 3:50 PM, Sterling Jacobson wrote:

 Anyone ever tied in a database to google maps and earth?



 I want to define a boundary area on the map and then take address fields from 
 a database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Chuck Hogg]

Sounds like we are thinking along the same lines...I haven't gotten
anywhere yet though.
https://storage.googleapis.com/support-kms-prod/BB0864B3FF4593A5424C90DB5B23B59E2255

Regards,
Chuck

On Tue, Mar 31, 2015 at 9:22 AM, Chuck McCown ch...@wbmfg.com wrote:

 I interfaced a spreadsheet with Google Earth Pro a while back.  Can't
 remember exactly how I did it but it was pretty easy.

 -Original Message- From: Sterling Jacobson
 Sent: Monday, March 30, 2015 4:50 PM
 To: 'af@afmug.com'
 Subject: [AFMUG] Google Maps


 Anyone ever tied in a database to google maps and earth?

 I want to define a boundary area on the map and then take address fields
 from a database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Sterling Jacobson]

Rory, let me know if they work out for you, I might also hire them if the price 
is right.

I have a couple of projects requiring this, one for internal viewing, status 
etc. on sort of a live view of network status maybe.

The other for external use to overlay a percentage and color block/polygon on a 
 few neighborhoods.

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Rory Conaway
Sent: Tuesday, March 31, 2015 9:47 AM
To: af@afmug.com
Subject: Re: [AFMUG] Google Maps

We would like to do the same thing.  I have a couple of programmers looking at 
it now.

Rory

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck Hogg
Sent: Tuesday, March 31, 2015 8:40 AM
To: af@afmug.commailto:af@afmug.com
Subject: Re: [AFMUG] Google Maps

Sounds like we are thinking along the same lines...I haven't gotten anywhere 
yet though.
https://storage.googleapis.com/support-kms-prod/BB0864B3FF4593A5424C90DB5B23B59E2255

Regards,
Chuck

On Tue, Mar 31, 2015 at 9:22 AM, Chuck McCown 
ch...@wbmfg.commailto:ch...@wbmfg.com wrote:
I interfaced a spreadsheet with Google Earth Pro a while back.  Can't remember 
exactly how I did it but it was pretty easy.

-Original Message- From: Sterling Jacobson
Sent: Monday, March 30, 2015 4:50 PM
To: 'af@afmug.commailto:af@afmug.com'
Subject: [AFMUG] Google Maps


Anyone ever tied in a database to google maps and earth?

I want to define a boundary area on the map and then take address fields from a 
database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Jerry Richardson]

Don't know if this helps:

https://developers.google.com/maps/documentation/

Jerry 

 On Mar 31, 2015, at 9:39 AM, Sterling Jacobson sterl...@avative.net wrote:
 
 Rory, let me know if they work out for you, I might also hire them if the 
 price is right.
  
 I have a couple of projects requiring this, one for internal viewing, status 
 etc. on sort of a live view of network status maybe.
  
 The other for external use to overlay a percentage and color block/polygon on 
 a  few neighborhoods.
  
 From: Af [mailto:af-boun...@afmug.com] On Behalf Of Rory Conaway
 Sent: Tuesday, March 31, 2015 9:47 AM
 To: af@afmug.com
 Subject: Re: [AFMUG] Google Maps
  
 We would like to do the same thing.  I have a couple of programmers looking 
 at it now.
  
 Rory
  
 From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck Hogg
 Sent: Tuesday, March 31, 2015 8:40 AM
 To: af@afmug.com
 Subject: Re: [AFMUG] Google Maps
  
 Sounds like we are thinking along the same lines...I haven't gotten anywhere 
 yet though.
 https://storage.googleapis.com/support-kms-prod/BB0864B3FF4593A5424C90DB5B23B59E2255
 
 Regards,
 Chuck
  
 On Tue, Mar 31, 2015 at 9:22 AM, Chuck McCown ch...@wbmfg.com wrote:
 I interfaced a spreadsheet with Google Earth Pro a while back.  Can't 
 remember exactly how I did it but it was pretty easy.
 
 -Original Message- From: Sterling Jacobson
 Sent: Monday, March 30, 2015 4:50 PM
 To: 'af@afmug.com'
 Subject: [AFMUG] Google Maps
 
 
 Anyone ever tied in a database to google maps and earth?
 
 I want to define a boundary area on the map and then take address fields from 
 a database and put them in there, on the map as I'm viewing it.
 
  

Re: [AFMUG] Google Maps

[Chuck McCown]

I interfaced a spreadsheet with Google Earth Pro a while back.  Can't 
remember exactly how I did it but it was pretty easy.


-Original Message- 
From: Sterling Jacobson

Sent: Monday, March 30, 2015 4:50 PM
To: 'af@afmug.com'
Subject: [AFMUG] Google Maps

Anyone ever tied in a database to google maps and earth?

I want to define a boundary area on the map and then take address fields 
from a database and put them in there, on the map as I'm viewing it.

[AFMUG] Google Maps

[Sterling Jacobson]

Anyone ever tied in a database to google maps and earth?

I want to define a boundary area on the map and then take address fields from a 
database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[D. Ryan Spott]

What is your database? I have some PHP code I wrote a while ago that 
maps things.


ryan

On 3/30/15 3:50 PM, Sterling Jacobson wrote:

Anyone ever tied in a database to google maps and earth?

I want to define a boundary area on the map and then take address fields from a 
database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Sterling Jacobson]

I'm sticking it in Microsoft SQL as additional tables to my Platypus SQL stuff.


From: Af [mailto:af-boun...@afmug.com] On Behalf Of D. Ryan Spott
Sent: Monday, March 30, 2015 5:05 PM
To: af@afmug.com
Subject: Re: [AFMUG] Google Maps

What is your database? I have some PHP code I wrote a while ago that maps 
things.

ryan
On 3/30/15 3:50 PM, Sterling Jacobson wrote:

Anyone ever tied in a database to google maps and earth?



I want to define a boundary area on the map and then take address fields from a 
database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Cameron Crum]

Yes.
On Mar 30, 2015 5:50 PM, Sterling Jacobson sterl...@avative.net wrote:

 Anyone ever tied in a database to google maps and earth?

 I want to define a boundary area on the map and then take address fields
 from a database and put them in there, on the map as I'm viewing it.

Re: [AFMUG] Google Maps

[Mike Hammett]

ArcMap? 




- 
Mike Hammett 
Intelligent Computing Solutions 
http://www.ics-il.com 

- Original Message -

From: Sterling Jacobson sterl...@avative.net 
To: af@afmug.com af@afmug.com 
Sent: Monday, March 30, 2015 5:50:00 PM 
Subject: [AFMUG] Google Maps 

Anyone ever tied in a database to google maps and earth? 

I want to define a boundary area on the map and then take address fields from a 
database and put them in there, on the map as I'm viewing it.