Name: Inspection_and_Maintenance_Records

Display Field: GISID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GISID ( type: esriFieldTypeInteger, alias: GISID )
• WORK_TYPE ( type: esriFieldTypeString, alias: WORK_TYPE, length: 50 , Coded Values: [INSPECT: Inspection] , [REPAIR: Repair] , [MAINT: Maintenance] )
• SSJUMPS_GISID ( type: esriFieldTypeInteger, alias: SSJUMPS_GISID )
• NODE ( type: esriFieldTypeString, alias: NODE, length: 15 )
• DIST_FROM_NODE ( type: esriFieldTypeInteger, alias: DIST_FROM_NODE )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 30 , Coded Values: [AC: AC] , [BRICK: BRICK] , [CAM: CAM] , ...30 more... )
• SHAPE_OVALITY ( type: esriFieldTypeString, alias: SHAPE_OVALITY, length: 4 , Coded Values: [GOOD: Good] , [OKAY: Okay] , [POOR: Poor] )
• PIPE_CONDITION ( type: esriFieldTypeSmallInteger, alias: PIPE_CONDITION , Coded Values: [1: 1-NoDefect] , [2: 2-MinorDefect] , [3: 3-PipeDamage] , ...2 more... )
• DEFECT_TYPE ( type: esriFieldTypeString, alias: DEFECT_TYPE, length: 50 , Coded Values: [CRACK: Cracking] , [MIN_DEFORM: Deformed (Minor)] , [MAJ_DEFORM: Deformed (Major)] , ...3 more... )
• FROM_ ( type: esriFieldTypeSmallInteger, alias: FROM , Coded Values: [1: One O'clock] , [2: Two O'clock] , [3: Three O'clock] , ...9 more... )
• TO_ ( type: esriFieldTypeSmallInteger, alias: TO , Coded Values: [1: One O'clock] , [2: Two O'clock] , [3: Three O'clock] , ...9 more... )
• RIPRAP_MATERIAL ( type: esriFieldTypeString, alias: RIPRAP_MATERIAL, length: 30 , Coded Values: [1: Broken Concrete] , [2: Concrete] , [3: Dirt] , ...1 more... )
• WATER_LEVEL ( type: esriFieldTypeSmallInteger, alias: WATER_LEVEL , Coded Values: [0: 0%] , [1: 10%] , [2: 20%] , ...8 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 75 )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, length: 8 )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, length: 8 )
• PARENT_GUID_SR ( type: esriFieldTypeGUID, alias: PARENT_GUID_SR, length: 38 )
• DEBRIS_LEVEL ( type: esriFieldTypeSmallInteger, alias: DEBRIS_LEVEL , Coded Values: [0: 0%] , [1: 10%] , [2: 20%] , ...9 more... )
• PARENT_GUID_LINE_SR ( type: esriFieldTypeGUID, alias: PARENT_GUID_LINE_SR, length: 38 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• JUMP_GISID_TYP ( type: esriFieldTypeInteger, alias: JUMP_GISID_TYP )

Relationships:

• GIS.SSCULVERTINSPECTIONMAINTENANCE_SR (0) -- Related To: Observed_Condition (0)

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

  Iteminfo   Thumbnail   Metadata