Name: CTDOT Park And Ride Lot Inspections

Display Field: InspectionDate

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: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true, Coded Values: [On Site: On Site], [Off Site: Off Site])
• SpacesOccupied (type: esriFieldTypeSmallInteger, alias: Spaces Occupied, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [0 - 1400])
• OccupancyRate (type: esriFieldTypeSingle, alias: Occupancy Rate (%), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 200])
• PavementCondition (type: esriFieldTypeString, alias: Pavement Condition, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true, Coded Values: [Excellent: Excellent], [Good: Good], [Fair: Fair], ... 3 more ...)
• StripingCondition (type: esriFieldTypeString, alias: Striping Condition, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true, Coded Values: [Excellent: Excellent], [Good: Good], [Fair: Fair], ... 3 more ...)
• MaintenancePerformed (type: esriFieldTypeString, alias: Maintenance Performed, SQL Type: sqlTypeOther, length: 3, nullable: false, editable: true, Coded Values: [Yes: Yes], [No: No])
• Comments (type: esriFieldTypeString, alias: Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ParentGUID (type: esriFieldTypeGUID, alias: ParentGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• BrokenCurbing (type: esriFieldTypeString, alias: Broken Curbing, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• BrokenGlass (type: esriFieldTypeString, alias: Broken Glass, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CrackSealingNeeded (type: esriFieldTypeString, alias: Crack(s) - Sealing Needed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GarbageDebrisNeedsToBeRemoved (type: esriFieldTypeString, alias: Garbage/Debris Needs To Be Removed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• LightpoleDamaged (type: esriFieldTypeString, alias: Lightpole Damaged, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Potholes (type: esriFieldTypeString, alias: Potholes, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• RepairDamagedFencing (type: esriFieldTypeString, alias: Repair Damaged Fencing, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• RestripingNeeded (type: esriFieldTypeString, alias: Restriping Needed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SignageBlocked (type: esriFieldTypeString, alias: Signage Blocked/Illegible, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MowingNeeded (type: esriFieldTypeString, alias: Mowing Needed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MaintenanceComments (type: esriFieldTypeString, alias: Maintenance Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CommercialVehiclesPresent (type: esriFieldTypeString, alias: Commercial Vehicle(s) Present, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: CTDOT Park And Ride Lot Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MowingNeeded: No
• InspectionType: On Site
• SpacesOccupied: 0
• OccupancyRate: 0
• PavementCondition:
• StripingCondition:
• MaintenancePerformed: No
• Comments:
• SignageBlocked: No
• RestripingNeeded: No
• RepairDamagedFencing: No
• Potholes: No
• CommercialVehiclesPresent: No
• BrokenCurbing: No
• BrokenGlass: No
• CrackSealingNeeded: No
• GarbageDebrisNeedsToBeRemoved: No
• LightpoleDamaged: No

Relationships:

• (1) -- Related To: CTDOT Park And Ride Lots (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/4/2024 2:50:47 PM

Schema Last Edit Date: 9/4/2024 2:50:47 PM

Data Last Edit Date: 9/4/2024 2:50:47 PM

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