Convert CSV files containing columns with defined geographies into GeoJSON files. Detecting geography requires us to spot column headings in your CSV file. That means your CSV will need one or two of the following columns:
- latitude/longitude (WGS84) - two columns titled
Latitude/Longitude,lat/lonorgeox/geoy. - OS Grid References - two columns titled
Easting/Northing. - LSOA - a column titled
LSOA11CD,LSOA01CDorLSOA(interpreted as 2011 codes) and that column will need to contain valid ONS LSOA codes e.g. E01012334. - MSOA - a column titled
MSOA11CDorMSOA(interpreted as 2011 codes) and that column will need to contain valid ONS MSOA codes e.g. E02002273. - Ward - a column titled
WD20CD,WD19CDorWard(interpreted as 2020 wards) and that column will need to contain valid ONS 2020 Ward codes e.g. E05000026. - Constituency - a column titled
PCON17CDor Constituency (interpreted as 2017 Westminster Constituencies) and that column will need to contain valid ONS 2017 Constituency codes e.g. E14000530. - Local Authority Districts - a column titled
LAD20CD,LAD19CDor Local Authority (interpreted as 2020 Local Authority Boundaries) and that column will need to contain valid ONS 2020 Local Authority codes e.g. E06000001.
WGS84 and OSGB86 will result in a GeoJSON file containing points. LSOA-based data will add polygons derived from the ONS Lower Layer Super Output Areas (December 2011) Boundaries EW BGC (OGL). MSOA-based data will add polygons derived from the ONS Middle Layer Super Output Areas (December 2011) Boundaries EW BGC (OGL). Ward-based data will add polygons derived from the ONS Wards (December 2020) Boundaries UK BGC V2 and ONS Wards (December 2019) Boundaries EW BGC (OGL). Constituency-based data will add polygons derived from the ONS Westminster Parliamentary Constituencies (December 2017) UK BGC (OGL). Local-Authority-based data will add polygons derived from the ONS Local Authority Districts (2020) Boundaries UK BGC and ONS Local Authority Districts (April 2019) Boundaries UK BGC (OGL). Other columns in the CSV file will be added as properties to each feature in the GeoJSON.