Name: Inspections

Display Field: DISCOVERED

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

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 )
• INSPDATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPDATE )
• DISCOVERED ( type: esriFieldTypeString, alias: Structure Found?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DISCOVERED , Coded Values: [1: Yes] , [2: No] )
• ACTION ( type: esriFieldTypeString, alias: Action Performed, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTION , Coded Values: [1: None] , [2: Inspection] , [3: Repair] , ...2 more... )
• ACCESS ( type: esriFieldTypeString, alias: Access, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ACCESS )
• EROSION ( type: esriFieldTypeString, alias: Streambed/Bank Erosion, editable: true, nullable: true, length: 30, defaultValue: null, modelName: EROSION , Coded Values: [1: None - No Material Loss] , [2: Low - Minor Material Loss] , [3: Moderate - Major Material Loss] , ...1 more... )
• SCOUR ( type: esriFieldTypeString, alias: Structure Scour, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SCOUR , Coded Values: [1: No structure exposure] , [2: Some structure exposure] , [3: Significant structure exposure] , ...1 more... )
• SEDIMENT ( type: esriFieldTypeString, alias: Sediment/debris accummulation, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SEDIMENT , Coded Values: [Unknown: Unknown] , [None: None] , [Trace: Trace] , ...2 more... )
• OUTLETCONDITION ( type: esriFieldTypeString, alias: Outlet Condition, editable: true, nullable: false, length: 30, defaultValue: null, modelName: OUTLETCONDITION , Coded Values: [1: At-grade with stream (passable)] , [2: Above Stream (free fall)] , [3: Below Stream (submerged)] , ...1 more... )
• CUVLERTCONDITION ( type: esriFieldTypeString, alias: Structural condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CUVLERTCONDITION , Coded Values: [1: Good] , [2: Fair] , [3: Poor] , ...1 more... )
• ALIGNMENT ( type: esriFieldTypeString, alias: Culvert alignment with water, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALIGNMENT , Coded Values: [1: Straight] , [2: Armored, Straight] , [3: Mild Bend] , ...1 more... )
• ARMOR ( type: esriFieldTypeString, alias: Is the bed/bank armored?, editable: true, nullable: false, length: 50, defaultValue: null, modelName: ARMOR , Coded Values: [1: Yes] , [2: No] )
• CONDITION ( type: esriFieldTypeString, alias: Overall condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [1: Good] , [2: Fair] , [3: Poor] , ...1 more... )
• CULVERTACTION ( type: esriFieldTypeString, alias: Action Needed, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CULVERTACTION , Coded Values: [1: None] , [2: Repair] , [3: Replacement] , ...2 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTOR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• CulvertGUID ( type: esriFieldTypeGUID, alias: CulvertGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CulvertGUID )

Templates:

• Name: Inspections
  Description:
  Prototype:
  INSPECTOR: null
  CulvertGUID: null
  INSPDATE: null
  DISCOVERED: null
  ACTION: null
  ACCESS: null
  EROSION: null
  SCOUR: null
  SEDIMENT: null
  OUTLETCONDITION:
  CUVLERTCONDITION: null
  ALIGNMENT: null
  ARMOR:
  CONDITION: null
  CULVERTACTION: null
  NOTES: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Culverts (0) -- Related To: Culverts (0)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata