There is a separate thread dealing with the technical aspects. We're using Google as the geocoding data source because Bing is not available currently.
We have ten tables of between 100 and 1,000 real Australian addresses. One is included in the MXB. They all need to be geocoded.
The query "Geocode Query" is for that purpose, it requires a new geocoding data source - named "google_geo" in the screenshot. Note: Adding a Google geocoding API key (free version) fails - all geoms "NULL"
- First run of query of 248 records, 184 return a point, 64 return a null
- Second run of 64 failed records, 51 return a point, 13 again return null
- Third run of 13 failed records, 10 return a point, 3 again return null
- Fourth run of 3 failed records, all 3 return a point.
It's necessary to select all the Nulls from each run, copy and paste as a new table, then edit the query to reflect the new table and a new output table. It would be nice if the status bar displayed the number of selected records, currently we have to invoke the Contents pane / Component to get this information.
To get a composite table of all 248 records with a populated Geom, Select / Template / Is not Null / Value: Geom, Replace Selection, Table window copy, give result table from run 3 focus Menu Edit / Paste (Ctrl V). Repeat for other runs. Sure could be done via SQL, probably a little quicker for a quick keyboarder!
All in all, an unsatisfactory experience and not one that I could charge a normal commercial rate for. I've included the actual data in case anyone else wishes to have a go. I've performed this exercise three times and the only difference is the actual number of Null results for each run. I don't think this is Manifold issue per-se, Google have obviously done something their end. However, if this is as good as it's going to get using a "free" geocoding data source (I notice Google want $10,000 for an annual fee, couldn't claw a fraction of that back commercially) and Bing remain inaccessible, looks as though we may have to develop a local file based geocoding database.
Geocode with Google real data example.mxb
Google API key screenshot.PNG
New Geocoding data source.PNG