2. Datasets
  3. UPRN to school catchment seedcode lookup tables
Dundee City Council logo

Dundee City Council

Local authority for the Dundee City Council area
Open in GitHub

UPRN to school catchment seedcode lookup tables Edit

WARNING
This data is provided here for specialist users only. The same information is available in a much more user-friendly format in the Services near me page on the main council website, and anyone interested in enrolling a child in school should see the page on Enrolment in Primary and Secondary Schools in Dundee


Purpose
These files are intended to be downloaded and used within systems such as SEEMIS that have access to a separate source of address information such as the Council's Corporate Address Gazetteer (CAG), One Scotland Gazetteer (OSG) or Ordnance Survey AddressBase.

Description
This collection includes the following files:
  1. Dundee_UPRN_SEED_lookup_all.csv
  2. Dundee_UPRN_SEED_lookup_all_primary.csv - required for use in SEEMIS
  3. Dundee_UPRN_SEED_lookup_all_secondary.csv - required for use in SEEMIS
  4. Dundee_UPRN_SEED_lookup_denom_primary.csv
  5. Dundee_UPRN_SEED_lookup_denom_secondary.csv
  6. Dundee_UPRN_SEED_lookup_non_denom_primary.csv
  7. Dundee_UPRN_SEED_lookup_non_denom_secondary.csv
  8. Schema.ini - explicitly sets UPRN datatype to text (with preceding zeroes) for use in excel
Only files 2 & 3 are required for use in SEEMIS. The other files are produced by the same process and are provided here in case they are useful. The combined files (1-3) will contain multiple records for each address. The remaining files (4-7) contain just one record for each address. 

Each file contains just two columns
  1. UPRN - the Unique Property Reference Number of each address in Dundee
  2. SEED - the seedcode of the school catchment that the address is within 
Both columns are qualified with double quotes and separated with a comma. 

UPRNs are Unique Property Reference Numbers, as used in the Council's Corporate Address Gazetteer (CAG), the One Scotland Gazetteer (OSG) Or the Ordnance Survey AddressBase products.. For more information please see www.osg.scot

Seedcodes are unique identifiers for Scottish Schools. A full list can be found at https://www.gov.scot/publications/school-contact-details/

This collection is updated each night with the latest UPRNs from the Council's Corporate Address Gazetteer (CAG). SEED codes are taken from the Council's current catchment boundaries layer ("SchoolsAndCatchments - Current") which is updated as required. This typically happens around October or November before enrolment starts for the next school year each year. The data may therefore reflect the catchments that are due to take effect at the start of the next school year. For more details on the catchment data please see the the Council's current catchment boundaries layer ("SchoolsAndCatchments - Current")
 
This data can be combined with Ordnance Survey OpenUPRN data to visualise it on a map in GIS software such as ArcGIS or QGIS. Or alternatively see the separate "UPRNs with school catchments" layer.

Resources

Additional Info

License UK Open Government Licence v3.0
Category Arts / Culture / History, Council and Government, Education, Housing and Estates, Planning and Development
Maintainer Dundee City Council
Date Created 2024-11-08
Date Updated 2024-11-18
Original dataset link https://data.dundeecity.gov.uk/datasets/dundeecity::uprn-to-school-catchment-seedcode-lookup-tables