Creating a map of Grade I listed buildings

  1. Open the list of datasets available from the Environment Agency.
  2. Find the English Heritage “Listed Buildings” layer; select “Shapefile”, click “Download”.
  3. Unzip the data archive:
    unzip Listed_Buidings.zip && cd Listed_Buidings_shape
  4. If ogr2ogr is not already installed, install it:
    brew install gdal
  5. Filter the data to select certain columns and rows:
    ogr2ogr -select "NAME,GRADE" -where "GRADE IN ('I')" listed_buildings_grade_one.shp listed_buildings.shp
  6. Create a new zip archive:
    zip listed_buildings_grade_one.zip listed_buildings_grade_one.*
  7. Upload the zip file to CartoDB, to create a new table.