Re: Google API for Geocoding ... Again

enty. -Original Message- From: ProfoxTech On Behalf Of M Jarvis Sent: Monday, 28 January 2019 19:27 To: profoxt...@leafe.com Subject: Re: Google API for Geocoding ... Again On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail wrote: Ok - yes, I'm dredging up a VERY Old thread here! So, he

RE: Google API for Geocoding ... Again

On Behalf Of M Jarvis Sent: Monday, 28 January 2019 19:27 To: profoxt...@leafe.com Subject: Re: Google API for Geocoding ... Again On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail wrote: > Ok - yes, I'm dredging up a VERY Old thread here! > > So, here's the deal. A woman I worked with for th

Re: Google API for Geocoding ... Again

On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail wrote: > Ok - yes, I'm dredging up a VERY Old thread here! > > So, here's the deal. A woman I worked with for this Jewish Holiday > Pop-up shop here in SF this past late Nov./early Dec. - she wants me to > do a kind of Admin task for her. She's going

Re: Google API for Geocoding ... Again

Ok - yes, I'm dredging up a VERY Old thread here! So, here's the deal. A woman I worked with for this Jewish Holiday Pop-up shop here in SF this past late Nov./early Dec. - she wants me to do a kind of Admin task for her. She's going to give me a spreadsheet of locations - and wants me to use

Re: Google API for Geocoding ... Again

-Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Chris Davis > Sent: 13 September 2016 16:33 > To: profox@leafe.com > Subject: RE: Google API for Geocoding ... Again > > FUNCTION geocode > LPARAMETERS lcpostcode > > lcurl="http://

RE: Google API for Geocoding ... Again

ssage- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 13 September 2016 16:26 To: profoxt...@leafe.com Subject: RE: Google API for Geocoding ... Again Alan, Your solution worked like a dream, thanks. Just knocking it into a useable class now to allow inpu

Re: Google API for Geocoding ... Again

On Tue, Sep 13, 2016 at 11:14 AM, Alan Bourke wrote: > Or you can just use the WinHTTP library in Windows as per the Gist I > linked earlier, and get a string back straight into VFP. The hardest > part of all this is going to be parsing the JSON to be honest. > Missed

RE: Google API for Geocoding ... Again

rofoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 13 September 2016 16:26 To: profoxt...@leafe.com Subject: RE: Google API for Geocoding ... Again Alan, Your solution worked like a dream, thanks. Just knocking it into a useable class now to allow input and output from our s

RE: Google API for Geocoding ... Again

ave (& Tom) -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 13 September 2016 16:15 To: profoxt...@leafe.com Subject: Re: Google API for Geocoding ... Again Or you can just use the WinHTTP library in Windows as per the Gist I linked earlier, an

Re: Google API for Geocoding ... Again

Or you can just use the WinHTTP library in Windows as per the Gist I linked earlier, and get a string back straight into VFP. The hardest part of all this is going to be parsing the JSON to be honest. -- Alan Bourke alanpbourke (at) fastmail (dot) fm

Re: Google API for Geocoding ... Again

ave > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche > Sent: 13 September 2016 14:58 > To: profox@leafe.com > Subject: Re: Google API for Geocoding ... Again > > Well, perhaps I'm missing something; I'll recheck my wor

RE: Google API for Geocoding ... Again

September 2016 14:58 To: profox@leafe.com Subject: Re: Google API for Geocoding ... Again Well, perhaps I'm missing something; I'll recheck my work. I just registered for an API key and used the Google examples and my new API key to get results that show up in my browser. Of course, I'm

Re: Google API for Geocoding ... Again

ailto:profox-boun...@leafe.com] On Behalf Of Ted Roche > Sent: 13 September 2016 14:46 > To: profox@leafe.com > Subject: Re: Google API for Geocoding ... Again > > A hideously-ugly hack that might do the trick would be to automate an IE > browser session, feed it the URL, and parse th

RE: Google API for Geocoding ... Again

Tried that Ted but Google never actually return the Lat/Long and the API call is the only way to retrieve it. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 13 September 2016 14:46 To: profox@leafe.com Subject: Re: Google API

Re: Google API for Geocoding ... Again

A hideously-ugly hack that might do the trick would be to automate an IE browser session, feed it the URL, and parse the source result searching first for "location" then for the nearest "lat" and "long" in the resultant source. On Tue, Sep 13, 2016 at 6:44 AM, Dave Crozier

Re: Google API for Geocoding ... Again

Make the service and call it as needed from your app. var address = "123 something st, somewhere"; var requestUri = string.Format(" http://maps.googleapis.com/maps/api/geocode/xml?address={0}=false;, Uri.EscapeDataString(address)); var request = WebRequest.Create(requestUri); var response =

Re: Google API for Geocoding ... Again

Dave The VFP code at the link below will work assuming you have Rick Strahl's Web Connect installed. I tried it with the SPS Weblog JSON class but the JSON is too complex for it to handle. You need .NET 4.0 or above installed. You won't use .NET directly (Web Connection does internally) however

RE: Google API for Geocoding ... Again

Thanks Al, I'd forgotten that you had a lot of early "tribulations" with Soap! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen Pollard Sent: 13 September 2016 13:27 To: profox@leafe.com Subject: RE: Google API for Geocoding ... Agai

RE: Google API for Geocoding ... Again

-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: 13 September 2016 13:00 To: profox@leafe.com Subject: Re: Google API for Geocoding ... Again Dave, Web calls from VFP require a COM object, or Rick's WestWind tool for C# DLL interaction. I am working with a COM control which has both http

RE: Google API for Geocoding ... Again

Sent: 13 September 2016 13:27 To: profox@leafe.com Subject: RE: Google API for Geocoding ... Again I could send you some code which uses the vfpconnection from sweet potato, it builds a URL to pass the parameters in (in my case just a uk postcode) and then uses the JSON project from VFPX

RE: Google API for Geocoding ... Again

to what is required and I will dig it out this evening. Regards Chris. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 13 September 2016 11:44 To: profoxt...@leafe.com Subject: Google API for Geocoding ... Again Fellow Gentlemen, I

RE: Google API for Geocoding ... Again

Hi Dave Not tried Google stuff but does it work as soap? The following is what I use to talk to one of my own web services. LPARAMETERS cSeason LOCAL loStationData AS "XML Web Service" LOCAL loException, lcErrorMsg, loWSHandler, oResult coord.displaymethod = PROGRAM() TRY loWSHandler =

Re: Google API for Geocoding ... Again

Dave, Web calls from VFP require a COM object, or Rick's WestWind tool for C# DLL interaction. I am working with a COM control which has both http and JSON built into it. The full suite has many things, including pop, SMTP, IMAPI, and more. You can find it inexpensive at http://chilkatsoft.com

Google API for Geocoding ... Again

Fellow Gentlemen, I posted a request about doing geocoding requests to receive back a Lat/Long dataset for various addresses a few weeks ago and now find that Google do in fact provide a Geocoding service: https://developers.google.com/maps/documentation/geocoding/start The responses back