Name: SignalizedIntersectionInspections

Display Field: Intersection

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: 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)
• Intersection (type: esriFieldTypeString, alias: Intersection, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PermitPlan (type: esriFieldTypeString, alias: Matches Permit Plan, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• PermitPlanDetails (type: esriFieldTypeString, alias: If No, Describe, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PavementMarkings (type: esriFieldTypeString, alias: Faded Pavement Markings, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• PavementMarkingsDetails (type: esriFieldTypeString, alias: If Yes, Identify Needed Action(s), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Signs (type: esriFieldTypeString, alias: Sign(s) Deficiencies, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• SignsDetails (type: esriFieldTypeString, alias: If Yes, Identify Needed Action(s), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• VLightsOut (type: esriFieldTypeString, alias: Vehicular Light(s) Out, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• VLightsOutDetails (type: esriFieldTypeString, alias: If Yes, Note Location(s)/Direction(s), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PLightsOut (type: esriFieldTypeString, alias: Pedestrian Light(s) Out, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• PLightsOutDetails (type: esriFieldTypeString, alias: If Yes, Note Location(s)/Direction(s), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LightsVisIssue (type: esriFieldTypeString, alias: Light(s): Visibility Issue(s), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• LightsVisDetails (type: esriFieldTypeString, alias: If Yes, Describe, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Pushbuttons (type: esriFieldTypeString, alias: Pushbuttons Working, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• PushbuttonsDetails (type: esriFieldTypeString, alias: If No, Note Location(s)/Direction(s), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PoleDamage (type: esriFieldTypeString, alias: Pole(s) Damaged, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• PoleDamageDetails (type: esriFieldTypeString, alias: If Yes, Describe/Note Degree (see PennDOT pub 191), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CabinetDamage (type: esriFieldTypeString, alias: Cabinet(s) Damage, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• CabinetDamageDetails (type: esriFieldTypeString, alias: If Yes, Describe, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• OtherObservations (type: esriFieldTypeString, alias: Other Observations/Concerns, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Intersection_ID (type: esriFieldTypeGUID, alias: Intersection Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Heading (type: esriFieldTypeString, alias: Heading, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Preemptions (type: esriFieldTypeString, alias: Preemption(s), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• PreemptionDetails (type: esriFieldTypeString, alias: Preemption(s) Details, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: SignalizedIntersectionInspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Intersection (0) -- Related To: Intersections (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/9/2020 6:05:12 PM

Schema Last Edit Date: 7/9/2020 6:05:12 PM

Data Last Edit Date: 7/9/2020 6:05:12 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