topic Geocoding with QlikView and MapQuest in QlikView https://community.qlik.com/t5/QlikView/Geocoding-with-QlikView-and-MapQuest/m-p/1086665#M361770 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.33px;">I've recently had cause to dust off an application I built several years ago to extract geocodes (longitude and latitude) from address data. The application uses the MapQuest <SPAN style="font-size: 13.33px;">API to take a list of addresses or postcodes and return the relevant coordinates, which you can then output to CSV or Excel. I haven't seen a recent version of the API code on Qlikcommunity recently so I thought I'd share mine.</SPAN></P><P></P><H2>Step-by-step guide</H2><P style="font-size: 13.33px;">All these instructions can also be found on the home screen of the QlikView app</P><P></P><OL style="font-size: 13.33px;"><LI>Open the attached file in QlikView desktop (note that you will need a licence)</LI><LI>Obtain a key for the MapQuest API More details can be found here: <A class="jive-link-external-small" href="https://developer.mapquest.com/" rel="nofollow" target="_blank"><SPAN style="color: #0066cc; text-decoration: underline;">MapQuest Developer Network</SPAN></A> . Paste your key into the box</LI><LI>Create a single column CSV file with the column header "Address" listing all your address or postcode strings Type the name of this file into the relevant box</LI><LI>Run the reload script whilst connected to the internet</LI><LI>The results can be found on the "Data" tab, where you can export them to Excel or CSV</LI></OL><P></P><P style="font-size: 13.33px;"><SPAN style="text-decoration: underline;">Note that each MapQuest account has a monthly limit for the number of requests it can submit (circa 10,000)</SPAN>, so you may need to run the query in batches to get all your addresses.</P></BODY></HTML> Tue, 29 Mar 2016 08:57:01 GMT mrbowlesdwf 2016-03-29T08:57:01Z Geocoding with QlikView and MapQuest https://community.qlik.com/t5/QlikView/Geocoding-with-QlikView-and-MapQuest/m-p/1086665#M361770 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.33px;">I've recently had cause to dust off an application I built several years ago to extract geocodes (longitude and latitude) from address data. The application uses the MapQuest <SPAN style="font-size: 13.33px;">API to take a list of addresses or postcodes and return the relevant coordinates, which you can then output to CSV or Excel. I haven't seen a recent version of the API code on Qlikcommunity recently so I thought I'd share mine.</SPAN></P><P></P><H2>Step-by-step guide</H2><P style="font-size: 13.33px;">All these instructions can also be found on the home screen of the QlikView app</P><P></P><OL style="font-size: 13.33px;"><LI>Open the attached file in QlikView desktop (note that you will need a licence)</LI><LI>Obtain a key for the MapQuest API More details can be found here: <A class="jive-link-external-small" href="https://developer.mapquest.com/" rel="nofollow" target="_blank"><SPAN style="color: #0066cc; text-decoration: underline;">MapQuest Developer Network</SPAN></A> . Paste your key into the box</LI><LI>Create a single column CSV file with the column header "Address" listing all your address or postcode strings Type the name of this file into the relevant box</LI><LI>Run the reload script whilst connected to the internet</LI><LI>The results can be found on the "Data" tab, where you can export them to Excel or CSV</LI></OL><P></P><P style="font-size: 13.33px;"><SPAN style="text-decoration: underline;">Note that each MapQuest account has a monthly limit for the number of requests it can submit (circa 10,000)</SPAN>, so you may need to run the query in batches to get all your addresses.</P></BODY></HTML> Tue, 29 Mar 2016 08:57:01 GMT https://community.qlik.com/t5/QlikView/Geocoding-with-QlikView-and-MapQuest/m-p/1086665#M361770 mrbowlesdwf 2016-03-29T08:57:01Z