topic Batch convert Open Location Codes Plus Codes to Geographic Coordinates in Addressing Questions https://community.esri.com/t5/addressing-questions/batch-convert-open-location-codes-plus-codes-to/m-p/806340#M201 <HTML><HEAD></HEAD><BODY><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">I will be extracting a number of businesses with location codes from Google Places API and they will be in a spreadsheet.</DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">I read from the Google website that I can obtain geolocations (addresses) or Plus Codes for location. I would like to batch convert the Open Location Codes (Plus Codes) to latitude longitude geographic coordinates so they can be used in a GIS.</DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;"> </DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">How would one proceed?</DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;"> </DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">It seems there are a few websites allowing me to convert one Plus Code at a time however this is inefficient given the number of records I have to convert.</DIV></BODY></HTML> Thu, 27 Sep 2018 01:47:36 GMT ColinMurray 2018-09-27T01:47:36Z Batch convert Open Location Codes Plus Codes to Geographic Coordinates https://community.esri.com/t5/addressing-questions/batch-convert-open-location-codes-plus-codes-to/m-p/806340#M201 <HTML><HEAD></HEAD><BODY><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">I will be extracting a number of businesses with location codes from Google Places API and they will be in a spreadsheet.</DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">I read from the Google website that I can obtain geolocations (addresses) or Plus Codes for location. I would like to batch convert the Open Location Codes (Plus Codes) to latitude longitude geographic coordinates so they can be used in a GIS.</DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;"> </DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">How would one proceed?</DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;"> </DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #222222; font-family: &amp;quot; roboto&amp;quot;,arial,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px; border: 0px none #222222;">It seems there are a few websites allowing me to convert one Plus Code at a time however this is inefficient given the number of records I have to convert.</DIV></BODY></HTML> Thu, 27 Sep 2018 01:47:36 GMT https://community.esri.com/t5/addressing-questions/batch-convert-open-location-codes-plus-codes-to/m-p/806340#M201 ColinMurray 2018-09-27T01:47:36Z