logo for rowmaps web site rowmaps

these web pages
are being produced by
Barry Cornelius

rowmaps@gmail.com
Follow me at http://twitter.com/rowmaps

home

maps
preferences

original data
missing data
KMLs
GPXs
CSVs
GeoJSONs

using Organic Maps
app on a phone 
and getting it to
display rights of way


tweets
blog
contact
privacy

CSV files containing the public rights of way of Kingston upon Thames

This web page explains how public rights of way data for Kingston upon Thames has been obtained and how the data has been released with a licence that enables you to use this data. It also explains how I've produced a KML file from this data. This KML file is called "original.kml".

There are two other KML files that have been derived from the authority's data. I have converted the KML that is in the file "original.kml" into the basic format that is used by this web site for all authorities. For each public right of way, this basic format has the code of the authority (KG), a unique number within the authority for the public right of way, the name or number of the parish/community, the name or number of the public right of way, the type of the public right of way (i.e., footpath, bridleway, ...) and any additional information about the public right of way that I've obtained from the data supplied by the authority. This KML file is called "converted.kml".

Finally, the KML in the file "converted.kml" has been augmented with additional information. For each public right of way, the augmented format also includes its length (in miles), the longitude and latitude of its first point, the longitude and latitude of its last point, the eastings and northings of its first point, the eastings and northings of its last point and a bounding box. This KML file is called "augmented.kml".

From each of these KML files, I have created a CSV file that has a column for each element of the KML file. The first line of each CSV file has details of the licence with which the file has been released. The second line has names for each column of the CSV file that describes the contents of that column. Each of the other lines of the CSV file describes one section of a public right of way. The columns of the line are separated by the "|" character.

These CSV files can be obtained by using one of the links given below.

Depending on which link you use, there may be an extra two columns added to the end of each line. The first of these columns has a link to a map centred on the first point of the public right of way and the second has the coordinates of the route of the public right of way.

without the extra columns          with coordinates expressed as lon-lats   with coordinates expressed as lat-lons
original.csv   original.kml with no-coordinates original.kml with lon-lats original.kml with lat-lons
converted.csv   converted.kml with no-coordinates converted.kml with lon-lats converted.kml with lat-lons
augmented.csv   augmented.kml with no-coordinates augmented.kml with lon-lats augmented.kml with lat-lons

Notes:

  1. The lon-lats variants have the coordinates in the format lon,lat which is what is used in KML. If the authority provides elevations as well as longitudes and latitudes, the lon-lats variants also have the elevations, i.e., lon,lat,ele. Elevations are never included in the lat-lons variants which uses the format lat,lon.
  2. The original CSV files also have an extra column added to the start of each line: the first column of each line has the string "KG" which is the code that rowmaps uses for Kingston upon Thames.
  3. A column in a CSV file has the value ---absent--- if the KML for a public right of way does not have this element.

As explained on this web page, the data for Kingston upon Thames is released under license. So it's possible for you to use the data in these CSV files provided you give an attribution.

An authority's Definitive Map is the authoritative source of their rights of way. The details of the public rights of way network contained in an authority's data are for information only, and are an interpretation of the Definitive Map, not the Definitive Map itself, and should not be relied on for determining the position or alignment of any public right of way. For legal purposes, an authority's data does not replace their Definitive Map. And changes may have been made to the Definitive Map that are not included in their data. The authority's data contains Ordnance Survey data © Crown copyright and database right 2024.

This web site also provides information about the public rights of way of Kingston upon Thames in KML format, in GPX format and in GeoJSON format.