Name: Site

Display Field: sitename

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 87732.7169000003
YMin: 8389.91330000013
XMax: 655217
YMax: 654864.140000001
Spatial Reference: 27700 (27700)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,92,230,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,77,168,255],"width":0.7}}},"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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• activepartnershipcode (type: esriFieldTypeString, alias: Active Partnership Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• activepartnershipname (type: esriFieldTypeString, alias: Active Partnership Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• bikehireflag (type: esriFieldTypeSmallInteger, alias: Cycle Hire?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• buildingname (type: esriFieldTypeString, alias: Building Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• buildingnumber (type: esriFieldTypeInteger, alias: Building Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• carparkcapacity (type: esriFieldTypeInteger, alias: Car Park Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 5000])
• carparkflag (type: esriFieldTypeSmallInteger, alias: Car Park Exists?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• changingplacestoiletsflag (type: esriFieldTypeSmallInteger, alias: Changing Place Toilets, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• closurereason (type: esriFieldTypeSmallInteger, alias: Closure Reason, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [201: Financial - insolvency, facilities uneconomic etc], [502: Not Disclosed], [302: Redevelopment - loss due to development project], ... 8 more ...)
• corecityname (type: esriFieldTypeString, alias: Core City Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• countycode (type: esriFieldTypeString, alias: County Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• countyname (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• cricketbowlingmachineflag (type: esriFieldTypeSmallInteger, alias: Has Cricket Bowling Machine(s)?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• cycleparkflag (type: esriFieldTypeSmallInteger, alias: Cycle Park?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• dependentlocality (type: esriFieldTypeString, alias: Dependent Locality, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• dependentthoroughfare (type: esriFieldTypeString, alias: Dependent Thorough Fare, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• disabilityactivityarea (type: esriFieldTypeSmallInteger, alias: Disability: Activity Area, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilitychangingfacilities (type: esriFieldTypeSmallInteger, alias: Disability: Changing Facilities, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilitydoorways (type: esriFieldTypeSmallInteger, alias: Disability: Doorways, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilityemergencyexits (type: esriFieldTypeSmallInteger, alias: Disability: Emergency Exits, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilityfindreachentrance (type: esriFieldTypeSmallInteger, alias: Disability: Finding and reaching the entrance, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilitynotes (type: esriFieldTypeString, alias: Disability Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• disabilityparking (type: esriFieldTypeSmallInteger, alias: Disability: Parking, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilityreceptionarea (type: esriFieldTypeSmallInteger, alias: Disability: Reception Area, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilitysocialareas (type: esriFieldTypeSmallInteger, alias: Disability: Social Areas, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilityspectatorareas (type: esriFieldTypeSmallInteger, alias: Disability: Spectator Areas, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• disabilitytoilets (type: esriFieldTypeSmallInteger, alias: Disability: Toilets, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• doubledependentlocality (type: esriFieldTypeString, alias: Double Dependent Locality, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• educationphase (type: esriFieldTypeSmallInteger, alias: Education Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [7: 16 plus], [1: All through], [4: Middle deemed Primary], ... 6 more ...)
• email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• facebook (type: esriFieldTypeString, alias: Facebook, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• firstaidflag (type: esriFieldTypeSmallInteger, alias: Has First Aid Room?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• firstname (type: esriFieldTypeString, alias: Forename, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• jobtitle (type: esriFieldTypeString, alias: Job Title, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ldpcode (type: esriFieldTypeString, alias: LDP Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ldpname (type: esriFieldTypeString, alias: LDP Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• localauthoritycode (type: esriFieldTypeString, alias: Local Authority Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• localauthorityname (type: esriFieldTypeString, alias: Local Authority Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• lowersuperoutputarea (type: esriFieldTypeString, alias: Lower Super Output Area Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• managementtype (type: esriFieldTypeInteger, alias: Management Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• middlesuperoutputarea (type: esriFieldTypeString, alias: Middle Super Output Area Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• nurseryflag (type: esriFieldTypeSmallInteger, alias: Has Nursery?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• operatorname (type: esriFieldTypeString, alias: Operator Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• outputareacode (type: esriFieldTypeString, alias: Output Area Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ownertype (type: esriFieldTypeInteger, alias: Owner Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parliamentaryconstituencycode (type: esriFieldTypeString, alias: Parliamentary Constituency Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• parliamentaryconstituencyname (type: esriFieldTypeString, alias: Parliamentary Constituency Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• postcode (type: esriFieldTypeString, alias: Postcode, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• posttown (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• publicnotes (type: esriFieldTypeString, alias: Public Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• recauditdate (type: esriFieldTypeDate, alias: Last Audit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• recenddate (type: esriFieldTypeDate, alias: Closed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• recentrydate (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• reclastchkddate (type: esriFieldTypeDate, alias: Last Updated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• regioncode (type: esriFieldTypeString, alias: Region Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• regionname (type: esriFieldTypeString, alias: Region Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• repairworkshopflag (type: esriFieldTypeSmallInteger, alias: Cycle Repair Workshop?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• siteid (type: esriFieldTypeInteger, alias: Site ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sitename (type: esriFieldTypeString, alias: Site Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• startdate (type: esriFieldTypeDate, alias: Management Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• subbuildingname (type: esriFieldTypeString, alias: Sub-Building Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• surname (type: esriFieldTypeString, alias: Surname, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• tabletennistableflag (type: esriFieldTypeSmallInteger, alias: Has Table Tennis Table(s)?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• telnumber (type: esriFieldTypeString, alias: Telephone Number, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• thoroughfarename (type: esriFieldTypeString, alias: Thoroughfare Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• title (type: esriFieldTypeSmallInteger, alias: Title, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Dr], [2: Mr], [1: Mrs], ... 1 more ...)
• toid (type: esriFieldTypeString, alias: TOID, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• twitter (type: esriFieldTypeString, alias: Twitter/X, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• uprn (type: esriFieldTypeString, alias: UPRN, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• wardcode (type: esriFieldTypeString, alias: Ward Code, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• wardname (type: esriFieldTypeString, alias: Ward Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• easting (type: esriFieldTypeInteger, alias: Easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
• northing (type: esriFieldTypeInteger, alias: Northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• athletics (type: esriFieldTypeString, alias: Athletics, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• healthfitness (type: esriFieldTypeString, alias: Health and Fitness, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• indoorbowls (type: esriFieldTypeString, alias: Indoor Bowls, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• indoortennis (type: esriFieldTypeString, alias: Indoor Tennis, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• grasspitches (type: esriFieldTypeString, alias: Grass Pitches, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sportshall (type: esriFieldTypeString, alias: Sports Hall, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• swimmingpool (type: esriFieldTypeString, alias: Swimming Pool, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• agp (type: esriFieldTypeString, alias: Artificial Grass Pitch, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• golf (type: esriFieldTypeString, alias: Golf, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• icerink (type: esriFieldTypeString, alias: Ice Rink, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• skislopes (type: esriFieldTypeString, alias: Ski Slopes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• studio (type: esriFieldTypeString, alias: Studio, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• squashcourt (type: esriFieldTypeString, alias: Squash Court, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• outdoortennis (type: esriFieldTypeString, alias: Outdoor Tennis, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• cycling (type: esriFieldTypeString, alias: Cycling, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sitealias (type: esriFieldTypeString, alias: Site Alias, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ownertypestr (type: esriFieldTypeString, alias: Ownership Type (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• managementtypestr (type: esriFieldTypeString, alias: Management Type (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ownergroupstr (type: esriFieldTypeString, alias: Ownership Type Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• managementgroupstr (type: esriFieldTypeString, alias: Management Type Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• siteidstr (type: esriFieldTypeString, alias: Site ID (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• eastingstr (type: esriFieldTypeString, alias: Easting (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• northingstr (type: esriFieldTypeString, alias: Northing (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lat (type: esriFieldTypeSingle, alias: lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• long (type: esriFieldTypeSingle, alias: long, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Site
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• cricketbowlingmachineflag: 2

Relationships:

• SiteQuality (0) -- Related To: SiteQuality (18)
• SiteAlias (1) -- Related To: SiteAlias (17)
• Facility (2) -- Related To: Facility (19)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2025 4:12:23 AM

Schema Last Edit Date: 7/27/2025 4:12:23 AM

Data Last Edit Date: 7/27/2025 4:12:23 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat