Skip to content

Latest commit

 

History

History
13 lines (10 loc) · 2.81 KB

README.md

File metadata and controls

13 lines (10 loc) · 2.81 KB
Raw

CSV2GeoJSON

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/lon or geox/geoy.
  • OS Grid References - two columns titled Easting/Northing.
  • LSOA - a column titled LSOA11CD, LSOA01CD or LSOA (interpreted as 2011 codes) and that column will need to contain valid ONS LSOA codes e.g. E01012334.
  • MSOA - a column titled MSOA11CD or MSOA (interpreted as 2011 codes) and that column will need to contain valid ONS MSOA codes e.g. E02002273.
  • Ward - a column titled WD20CD, WD19CD or Ward (interpreted as 2020 wards) and that column will need to contain valid ONS 2020 Ward codes e.g. E05000026.
  • Constituency - a column titled PCON17CD or 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, LAD19CD or 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.