Name: GIS.DBO.GravityMain_InspectionTable

Display Field: PIPE_NO

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PIPE_NO ( type: esriFieldTypeString, alias: PIPE_NO, length: 20 )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 50 , Coded Values: [PVC: Polyvinyl Chloride] , [RPM: Reinforced Plastic (Truss)] , [SDR35: SDR 35] , ...6 more... )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: Others] , [0.75: .75"] , [1: 1"] , ...7 more... )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, length: 50 , Coded Values: [Very Good: Very Good] , [Good: Good] , [Average: Average] , ...4 more... )
• ISSUE ( type: esriFieldTypeString, alias: ISSUE, length: 25 , Coded Values: [Broken: Broken] , [I + I: I + I] , [Joint: Joint] , ...7 more... )
• CLEANSTATU ( type: esriFieldTypeString, alias: CLEANSTATU, length: 25 , Coded Values: [Cleaned: Cleaned] , [Uncleaned: Uncleaned] , [N/A: N/A] )
• DATECLEANE ( type: esriFieldTypeDate, alias: DATECLEANE, length: 8 )
• TypeOfInspection ( type: esriFieldTypeString, alias: Type Of Inspection, length: 255 , Coded Values: [Routine Maintenance: Routine Maintenance] , [Repair: Repair] , [Emergency Response: Emergency Response] , ...1 more... )
• AreRepairsNeeded ( type: esriFieldTypeString, alias: Are Repairs Needed, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• URGENT ( type: esriFieldTypeString, alias: URGENT, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• MH1_LOC ( type: esriFieldTypeString, alias: MH1_LOC, length: 50 )
• MH2_LOC ( type: esriFieldTypeString, alias: MH2_LOC, length: 50 )
• SUBDIVISIO ( type: esriFieldTypeString, alias: SUBDIVISIO, length: 50 )
• LINED ( type: esriFieldTypeString, alias: LINED, length: 5 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• MOD_DATE ( type: esriFieldTypeDate, alias: MOD_DATE, length: 8 )
• VIDEO_LINK ( type: esriFieldTypeString, alias: VIDEO_LINK, length: 100 )
• REPORT_LIN ( type: esriFieldTypeString, alias: REPORT_LIN, length: 100 )
• VIDEO_LI_1 ( type: esriFieldTypeString, alias: VIDEO_LI_1, length: 100 )
• ACCELERATE ( type: esriFieldTypeString, alias: ACCELERATE, length: 5 )
• Intercepto ( type: esriFieldTypeString, alias: Intercepto, length: 10 )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, length: 38 )
• FIELDNOTES ( type: esriFieldTypeString, alias: FIELDNOTES, length: 150 )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )
• RGUID ( type: esriFieldTypeGUID, alias: RGUID, length: 38 )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 , Coded Values: [Backlot: Backlot] , [Other: Other] )
• Operator_ ( type: esriFieldTypeString, alias: Operator_, length: 255 , Coded Values: [DRC: DRC] , [Snow Bridge: Snow Bridge] , [TOS Operator: TOS Operator] , ...1 more... )

Relationships:

• GIS.DBO.ssGravityMain (1) -- Related To: ssGravityMain_New (2)

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

  Iteminfo   Thumbnail   Metadata