Name: ProdGeoDB.STREETLIGHTS.StreetLighting_Inspections

Display Field: GIS_FeatureKey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GIS_ID ( type: esriFieldTypeInteger, alias: Streetlight GIS ID )
• GIS_FeatureKey ( type: esriFieldTypeString, alias: Unique Inspection ID, length: 20 )
• DateOfInspection ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Inspector ( type: esriFieldTypeString, alias: Name of Inspector, length: 50 )
• Deficiency_HandHoleCoverMissing ( type: esriFieldTypeString, alias: Deficiency - Hand Hole Cover Missing, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deficiency_HeadTilted ( type: esriFieldTypeString, alias: Deficiency - Head Tilted, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deficiency_TreeBlocking ( type: esriFieldTypeString, alias: Deficiency - Tree Blocking, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deficiency_LensBroken ( type: esriFieldTypeString, alias: Deficiency - Lens Broken, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deficiency_HeadMissing ( type: esriFieldTypeString, alias: Deficiency - Head Missing, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deficiency_Leaning ( type: esriFieldTypeString, alias: Deficiency - Leaning, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Deficiency_LightOn ( type: esriFieldTypeString, alias: Deficiency - Light On, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Damage_RustCondition ( type: esriFieldTypeString, alias: Damage - Rusting Condition, length: 9 , Coded Values: [Y: Yes] , [N: No] )
• Damage_HolesCracks ( type: esriFieldTypeString, alias: Damage Condition - Holes or Cracks, length: 6 , Coded Values: [Y: Yes] , [N: No] )
• Damage_Dents ( type: esriFieldTypeString, alias: Damage Condition - Dents, length: 6 , Coded Values: [Y: Yes] , [N: No] )
• Replace ( type: esriFieldTypeString, alias: Replacement Required, length: 12 , Coded Values: [Not Required: Not Required] , [Near Future: Near Future] , [Immediately: Immediately] )
• Comments_Recommendations ( type: esriFieldTypeString, alias: Provide Comments/Recommendations, length: 1073741822 )
• Deficiency_PoleBase ( type: esriFieldTypeString, alias: Provide Pole Base Condition, length: 255 , Coded Values: [Good: Good] , [Needs Monitoring: Needs Monitoring] , [Requires Replacement: Requires Replacement] )

Relationships:

• StreetLight Feature (2) -- Related To: Street Lighting - Streetlight Features (5)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata