Name: Inspection_and_Maintenance_Records

Display Field: GISID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

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

Templates:

• Name: Inspection_and_Maintenance_Records
  Description:
  Prototype:
  JUMP_GISID_TYP: null
  PARENT_GUID_LINE_SR: null
  GISID: null
  WORK_TYPE: null
  SSJUMPS_GISID: null
  NODE: null
  DIST_FROM_NODE: null
  MATERIAL: null
  SHAPE_OVALITY: null
  PIPE_CONDITION: 1
  DEFECT_TYPE: null
  FROM_: null
  TO_: null
  RIPRAP_MATERIAL: null
  WATER_LEVEL: null
  COMMENTS: null
  UPDATE_DATE: null
  UPDATE_USER: null
  PARENT_GUID_SR: null
  DEBRIS_LEVEL: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata