Name: Secondary Schools (Scotland)
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:
Min. Scale: 0
Max. Scale: 0
Default Visibility: false
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 66013
YMin: 536563
XMax: 460854
YMax: 1208995
Spatial Reference: 27700 (27700)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,115,223,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- SchUID (type: esriFieldTypeString, alias: SchUID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- SeedCode (type: esriFieldTypeDouble, alias: SeedCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SchoolType (type: esriFieldTypeString, alias: SchoolType, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- CentreType (type: esriFieldTypeString, alias: CentreType, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- SchoolName (type: esriFieldTypeString, alias: SchoolName, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- AddressLin (type: esriFieldTypeString, alias: AddressLin, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- AddressL_1 (type: esriFieldTypeString, alias: AddressL_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- AddressL_2 (type: esriFieldTypeString, alias: AddressL_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- PostCode (type: esriFieldTypeString, alias: PostCode, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- LAName (type: esriFieldTypeString, alias: LAName, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- LACode (type: esriFieldTypeString, alias: LACode, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- DataZone (type: esriFieldTypeString, alias: DataZone, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- UPRN (type: esriFieldTypeDouble, alias: UPRN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- PhoneNumbe (type: esriFieldTypeString, alias: PhoneNumbe, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- WebsiteAdd (type: esriFieldTypeString, alias: WebsiteAdd, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- Denominati (type: esriFieldTypeString, alias: Denominati, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- PupilRoll (type: esriFieldTypeDouble, alias: PupilRoll, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FTETeacher (type: esriFieldTypeDouble, alias: FTETeacher, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PropPupils (type: esriFieldTypeString, alias: PropPupils, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- PropPupi_1 (type: esriFieldTypeString, alias: PropPupi_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- DZSIMDRank (type: esriFieldTypeDouble, alias: DZSIMDRank, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZSIMDQuin (type: esriFieldTypeDouble, alias: DZSIMDQuin, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZSIMDDeci (type: esriFieldTypeDouble, alias: DZSIMDDeci, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZSIMDVigi (type: esriFieldTypeDouble, alias: DZSIMDVigi, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZSIMDPerc (type: esriFieldTypeDouble, alias: DZSIMDPerc, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZSIMDMost (type: esriFieldTypeString, alias: DZSIMDMost, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- DZSIMDMo_1 (type: esriFieldTypeString, alias: DZSIMDMo_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- DZSIMDMo_2 (type: esriFieldTypeString, alias: DZSIMDMo_2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- AddrUR8 (type: esriFieldTypeDouble, alias: AddrUR8, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AddrUR6 (type: esriFieldTypeDouble, alias: AddrUR6, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AddrUR8Des (type: esriFieldTypeString, alias: AddrUR8Des, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- AddrUR6Des (type: esriFieldTypeString, alias: AddrUR6Des, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- DZUR8 (type: esriFieldTypeDouble, alias: DZUR8, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZUR6 (type: esriFieldTypeDouble, alias: DZUR6, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DZUR8Desc (type: esriFieldTypeString, alias: DZUR8Desc, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- DZUR6Desc (type: esriFieldTypeString, alias: DZUR6Desc, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- GridRefEas (type: esriFieldTypeDouble, alias: GridRefEas, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GridRefNor (type: esriFieldTypeDouble, alias: GridRefNor, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Templates:
Name: Secondary Schools (Scotland)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/17/2024 2:38:54 PM
Schema Last Edit Date: 10/17/2024 2:38:54 PM
Data Last Edit Date: 10/17/2024 2:38:54 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat