Name: OA
Display Field: objectid
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Max Record Count: 1000
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:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
- oa_map (type: esriFieldTypeString, alias: Active Notification?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- oa_status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Update: Access Update], [Access: Open Access], [Restricted: Restricted Access], ... 6 more ...)
- oa_note (type: esriFieldTypeString, alias: OAR Note, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- oa_reason (type: esriFieldTypeString, alias: Reason for status change, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Maintenance: Maintenance and repairs directly related to public access (e.g. access road, boat ramp, dock, parking)], [Indirect Maintenance: Maintenance and repairs indirectly related to public access (e.g. road, bridge, structure)], [Construction: Construction directly related to public access (e.g. access road, boat ramp, dock, parking)], ... 8 more ...)
- oa_closuredt (type: esriFieldTypeDate, alias: OAR Closure Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- oa_antopendt (type: esriFieldTypeDate, alias: OAR Anticipated Open Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- oa_actopendt (type: esriFieldTypeDate, alias: OAR Actual Open Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- oa_mapsdt (type: esriFieldTypeDate, alias: Map Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- oa_mapedt (type: esriFieldTypeDate, alias: Map End Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- oa_hb2549 (type: esriFieldTypeString, alias: Does this qualify for HB 2549, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/18/2025 10:48:31 PM
Schema Last Edit Date: 7/18/2025 10:48:31 PM
Data Last Edit Date: 7/20/2025 12:36:53 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat