Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>There isn't any way for the geocoder to let you know if it thinks you had a typo. I agree with Saul's answer, that your best bet is to check your query against the response. </p> <p>I just wanted to point out that you'll have to check several elements of your input against several of the response values, in order to find the elements that should match up. In this case, "Beaverton" was found inside of "DependentLocalityName".</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8" ?&gt; &lt;kml xmlns="http://earth.google.com/kml/2.0"&gt;&lt;Response&gt; &lt;name&gt;Beverton, Ontario, Canada&lt;/name&gt; &lt;Status&gt; &lt;code&gt;200&lt;/code&gt; &lt;request&gt;geocode&lt;/request&gt; &lt;/Status&gt; &lt;Placemark id="p1"&gt; &lt;address&gt;Beaverton, Brock, ON, Canada&lt;/address&gt; &lt;AddressDetails Accuracy="4" xmlns="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0"&gt;&lt;Country&gt;&lt;CountryNameCode&gt;CA&lt;/CountryNameCode&gt;&lt;CountryName&gt;Canada&lt;/CountryName&gt;&lt;AdministrativeArea&gt;&lt;AdministrativeAreaName&gt;ON&lt;/AdministrativeAreaName&gt;&lt;SubAdministrativeArea&gt;&lt;SubAdministrativeAreaName&gt;Durham Regional Municipality&lt;/SubAdministrativeAreaName&gt;&lt;Locality&gt;&lt;LocalityName&gt;Brock&lt;/LocalityName&gt;&lt;DependentLocality&gt;&lt;DependentLocalityName&gt;Beaverton&lt;/DependentLocalityName&gt;&lt;/DependentLocality&gt;&lt;/Locality&gt;&lt;/SubAdministrativeArea&gt;&lt;/AdministrativeArea&gt;&lt;/Country&gt;&lt;/AddressDetails&gt; &lt;ExtendedData&gt; &lt;LatLonBox north="44.4502166" south="44.4183470" east="-79.1199562" west="-79.1839858" /&gt; &lt;/ExtendedData&gt; &lt;Point&gt;&lt;coordinates&gt;-79.1519710,44.4342840,0&lt;/coordinates&gt;&lt;/Point&gt; &lt;/Placemark&gt; &lt;/Response&gt;&lt;/kml&gt; </code></pre> <p><strong>Update:</strong></p> <p>This may be impossible to actually implement. If your input is "Beverton, Ontario, Canada", how do you know which of those three words to check for? Two of them will match up just fine. What if they're entered in a different order?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload