Name: ScottishSchoolRoll

Display Field: schoolname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset represents the geo-locations for Scottish schools recorded in the following publication: https://www.gov.scot/publications/school-contact-details/. The dataset has been improved by including additional information (e.g. pupil roll, FTE teachers, proportion of pupils from an minority ethnic background, proportion of pupils from the 20% most deprived datazones) from this publication: https://www.gov.scot/publications/school-level-summary-statistics/.The school UPRN (Unique Property Reference Number) is used to source grid reference information for each school. The source for the majority of these grid references is the National Records of Scotland Scottish Address Directory (NRS SAD). In a small number of cases, the UPRNs in the SG School Roll & Locations dataset and the School Contact Details dataset will differ. The reasons for the difference, and the source of the replacement UPRN, will be described in the ‘Notes’ column of the SG School Roll & Locations attribute table.The dataset includes the SEED code for each school, which is a 7-digit number assigned by the Scottish Government for each school. A field called SchUID has also been added which adds a ‘P’, ‘S’ or ‘SP’ suffix to each SEED code to indicate primary, secondary or special schools respectively. This is because a primary and secondary school that operate at the same campus will both be assigned the same SEED code. The SchUID code should be used as the unique field for the dataset. Note that a point has been created for each SchUID, so a single SEED code or 'campus' may have multiple points. As a result this dataset has more instances than the school contact details spreadsheet.Schools have also been assigned a deprivation ranking based on the Scottish Index of Multiple Deprivation (SIMD) 2020. The rank number indicates the rank of the data zone which the school is located in. The vigintile of the data zone is provided as well as whether it falls within the 15 percent most deprived data zones or the 16 to 25 percent most deprived (indicated by ‘Y’ or ‘N’). The 15 percent most deprived data zones equate to vigintiles 1, 2 and 3, whereas the 16 to 25 percent most deprived equate to vigintiles 4 and 5.Schools have also been assigned an urban rural code based on the 6 and 8 fold version of the Scottish Government's Urban Rural Classification. Note that the urban rural assignments are given for the geocoded location and also for the data zone in which the school falls. Assignments may be different for the address/data zone in about 2.5% of cases. Discretion is required when considering which assignment should be used for a given project.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 66013
YMin: 536563
XMax: 460854
YMax: 1208995
Spatial Reference: 27700  (27700)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid )
• seedcode ( type: esriFieldTypeDouble, alias: SeedCode )
• schuid ( type: esriFieldTypeString, alias: SchUID, length: 255 )
• schooltype ( type: esriFieldTypeString, alias: SchoolType, length: 255 )
• centretype ( type: esriFieldTypeString, alias: CentreType, length: 255 )
• schoolname ( type: esriFieldTypeString, alias: SchoolName, length: 255 )
• addressline1 ( type: esriFieldTypeString, alias: AddressLine1, length: 255 )
• addressline2 ( type: esriFieldTypeString, alias: AddressLine2, length: 255 )
• addressline3 ( type: esriFieldTypeString, alias: AddressLine3, length: 255 )
• postcode ( type: esriFieldTypeString, alias: PostCode, length: 255 )
• laname ( type: esriFieldTypeString, alias: LAName, length: 255 )
• lacode ( type: esriFieldTypeString, alias: LACode, length: 255 )
• datazone ( type: esriFieldTypeString, alias: DataZone, length: 255 )
• uprn ( type: esriFieldTypeDouble, alias: UPRN )
• email ( type: esriFieldTypeString, alias: Email, length: 255 )
• phone ( type: esriFieldTypeString, alias: Phone, length: 255 )
• website ( type: esriFieldTypeString, alias: Website, length: 255 )
• denomination ( type: esriFieldTypeString, alias: Denomination, length: 255 )
• fteteacher ( type: esriFieldTypeDouble, alias: FTETeacher )
• pupilroll ( type: esriFieldTypeDouble, alias: PupilRoll )
• proppupilsminorityethnic ( type: esriFieldTypeString, alias: PropPupilsMinorityEthnic, length: 255 )
• proppupils20pcmostdeprived ( type: esriFieldTypeString, alias: PropPupils20PCMostDeprived, length: 255 )
• dzsimdpercentile ( type: esriFieldTypeDouble, alias: DZSIMDPercentile )
• dzsimdmostdep15pct ( type: esriFieldTypeString, alias: DZSIMDMostDep15Pct, length: 255 )
• dzsimdmostdep16_25pct ( type: esriFieldTypeString, alias: DZSIMDMostDep16_25Pct, length: 255 )
• dzsimdmostdep25pct ( type: esriFieldTypeString, alias: DZSIMDMostDep25Pct, length: 255 )
• addrur8 ( type: esriFieldTypeDouble, alias: AddrUR8 )
• addrur6 ( type: esriFieldTypeDouble, alias: AddrUR6 )
• addrur8desc ( type: esriFieldTypeString, alias: AddrUR8Desc, length: 255 )
• addrur6desc ( type: esriFieldTypeString, alias: AddrUR6Desc, length: 255 )
• dzur8 ( type: esriFieldTypeDouble, alias: DZUR8 )
• dzur6 ( type: esriFieldTypeDouble, alias: DZUR6 )
• dzur8desc ( type: esriFieldTypeString, alias: DZUR8Desc, length: 255 )
• dzur6desc ( type: esriFieldTypeString, alias: DZUR6Desc, length: 255 )
• gridrefeasting ( type: esriFieldTypeDouble, alias: GridRefEasting )
• gridrefnorthing ( type: esriFieldTypeDouble, alias: GridRefNorthing )
• latitude ( type: esriFieldTypeDouble, alias: Latitude )
• longitude ( type: esriFieldTypeDouble, alias: Longitude )
• notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• shape ( type: esriFieldTypeGeometry, alias: shape )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata