Geocoding UK Addresses using Post Codes for i2 скачать в хорошем качестве

Geocoding UK Addresses using Post Codes for i2

This videos shows how to geocode UK addresses using their Post Codes. This is of course less precise that geocoding the addresses themselves, but this generally requires to be online. Use the website https://www.getthedata.com/open-postc... to get the CSV files that geocode UK Post Codes, and then process the data in Excel, using Power Queries. You can then import UK addresses in i2 (Analyst's Notebook or iBase) to get the Lat-Long coordinates. The website GetTheData.com offers extracts for the following regions : North East North West Yorkshire and The Humber East Midlands West Midlands East of England London South East South West Wales Scotland Please note that i2 is not affiliated with this website, and we cannot guarantee the validity of the data they provide. 00:00 Intro 01:29 Downloading Geocoding data for the UK Postcodes 02:36 Processing the file in Excel 05:42 Transform Data (Power Query) 09:40 Create the 3 tables for Latitude, Longitude and Boroughs 12:10 Exporting the 3 tables as CSV files 14:44 Importing in ANB 20:43 Sending the ANB chart entities to the ESRI map. 21:41 Importing in iBase 25:55 Outro.