Name: Facility

Display Field: facilityid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• accessibilitytype (type: esriFieldTypeInteger, alias: Accessibility Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• changingfacilitiesflag (type: esriFieldTypeSmallInteger, alias: Has changing rooms?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• changingfacilitiesrefurbflag (type: esriFieldTypeSmallInteger, alias: Are changing rooms refurbished?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• changingfacilitiesrefurbyear (type: esriFieldTypeInteger, alias: Year changing rooms refurbished, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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 ...)
• 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])
• facilityid (type: esriFieldTypeInteger, alias: Facility ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• facilitysubtype (type: esriFieldTypeInteger, alias: Facility Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [6002: Activity Hall], [5001: Adult Football], [4001: Airhall], ... 66 more ...)
• facilitytype (type: esriFieldTypeSmallInteger, alias: Facility Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [8: Artificial Grass Pitch], [1: Athletics], [20: Cycling], ... 13 more ...)
• facstatus (type: esriFieldTypeSmallInteger, alias: Operational Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Closed], [7: No Grass Pitches Currently Marked Out], [8: Not Known], ... 4 more ...)
• facstatusnotes (type: esriFieldTypeString, alias: Operational Status Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• managementtype (type: esriFieldTypeInteger, alias: Management Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• meetsapcriteria (type: esriFieldTypeSmallInteger, alias: Meets Active Places Criteria, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• openingdate (type: esriFieldTypeDate, alias: Date Opened, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• openingdateexpected (type: esriFieldTypeDate, alias: Expected Opening Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• operatorname (type: esriFieldTypeString, alias: Operator Name, SQL Type: sqlTypeOther, length: 2000, 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)
• recupdateddate (type: esriFieldTypeDate, alias: Last Updated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• refurbflag (type: esriFieldTypeSmallInteger, alias: Is Refurbished?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [2: Not Known], [1: Yes])
• seasonalityend (type: esriFieldTypeSmallInteger, alias: End Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: April], [8: August], [12: December], ... 9 more ...)
• seasonalitystart (type: esriFieldTypeSmallInteger, alias: Start Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: April], [8: August], [12: December], ... 9 more ...)
• seasonalitytype (type: esriFieldTypeSmallInteger, alias: Seasonality Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: All Year], [2: Seasonal])
• siteid (type: esriFieldTypeInteger, alias: Site ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• timingstype (type: esriFieldTypeSmallInteger, alias: Timing Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dawn To Dusk], [2: Detailed Timings], [3: Not Known])
• yearbuilt (type: esriFieldTypeInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• yearbuiltestimated (type: esriFieldTypeSmallInteger, alias: Year Built Estimated?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• yearrefurbished (type: esriFieldTypeInteger, alias: Year Refurbished, SQL Type: sqlTypeOther, 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)
• lat (type: esriFieldTypeSingle, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• long (type: esriFieldTypeSingle, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• facilitytypeid (type: esriFieldTypeSmallInteger, alias: Facility Type ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• facilityidstr (type: esriFieldTypeString, alias: Facility ID (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• managementtypestr (type: esriFieldTypeString, alias: Management Type (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• managementgroupstr (type: esriFieldTypeString, alias: Management Type Group (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accessibilitytypestr (type: esriFieldTypeString, alias: Accessibility Type (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accessibilitygroupstr (type: esriFieldTypeString, alias: Accessibility Type Group (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• iconurl (type: esriFieldTypeString, alias: Icon URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• yearbuiltstr (type: esriFieldTypeString, alias: Year Built (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• yearrefurbishedstr (type: esriFieldTypeString, alias: Year Refurbished (Text), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• changingfacilitiesrefurbyearstr (type: esriFieldTypeString, alias: Changing Facilities Rerfurbished Year (Text), 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)

Templates:

Name: Facility
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• seasonalityend: 12
• seasonalitystart: 1
• yearbuiltestimated: 0

Relationships:

• FacilityOpeningTime (4) -- Related To: FacilityOpeningTime (24)
• FacilitySpecifics (5) -- Related To: FacilitySpecifics (20)
• Site (2) -- Related To: Site (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2025 4:17:58 AM

Schema Last Edit Date: 7/27/2025 4:17:58 AM

Data Last Edit Date: 7/27/2025 4:17:58 AM

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