Name: Culvert End Inventory

Display Field: Bound

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Bound ( type: esriFieldTypeSmallInteger, alias: Bound, editable: true, nullable: true, defaultValue: null, modelName: Bound , Coded Values: [1: NB] , [2: SB] , [3: WB] , ...1 more... )
• ConditionIndex ( type: esriFieldTypeSmallInteger, alias: Condition Index, editable: true, nullable: true, defaultValue: null, modelName: ConditionIndex , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• CulvertEndID ( type: esriFieldTypeGUID, alias: CulvertEndID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CulvertEndID )
• CulvertID ( type: esriFieldTypeGUID, alias: CulvertID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CulvertID )
• EmbankmentCondition ( type: esriFieldTypeSmallInteger, alias: Embankment Condition, editable: true, nullable: true, defaultValue: null, modelName: EmbankmentCondition )
• EndExtension ( type: esriFieldTypeSmallInteger, alias: End Extension, editable: true, nullable: true, defaultValue: null, modelName: EndExtension , Coded Values: [1: Yes] , [2: No] )
• EndLocation ( type: esriFieldTypeSmallInteger, alias: End Location, editable: true, nullable: true, defaultValue: null, modelName: EndLocation , Coded Values: [1: North] , [2: South] , [3: East] , ...1 more... )
• EndSection ( type: esriFieldTypeSmallInteger, alias: End Section, editable: true, nullable: true, defaultValue: null, modelName: EndSection , Coded Values: [1: None] , [2: Headwall] , [3: Headwall W/ Wingwalls] , ...5 more... )
• EndSectionDetached ( type: esriFieldTypeSmallInteger, alias: End Section Detached, editable: true, nullable: true, defaultValue: null, modelName: EndSectionDetached , Coded Values: [1: Yes] , [2: No] )
• EndSectionMaterial ( type: esriFieldTypeSmallInteger, alias: End Section Material, editable: true, nullable: true, defaultValue: null, modelName: EndSectionMaterial , Coded Values: [1: Metal] , [2: Concrete] , [3: Clay] , ...2 more... )
• ExtensionDimeSameAsCulvert ( type: esriFieldTypeSmallInteger, alias: Extension Dime Same As Culvert, editable: true, nullable: true, defaultValue: null, modelName: ExtensionDimeSameAsCulvert , Coded Values: [1: Yes] , [2: No] )
• ExtensionMaterialSameAsCulvert ( type: esriFieldTypeSmallInteger, alias: Extension Material Same As Culvert, editable: true, nullable: true, defaultValue: null, modelName: ExtensionMaterialSameAsCulvert , Coded Values: [1: Yes] , [2: No] )
• ExtensionShapeSameAsCulvert ( type: esriFieldTypeSmallInteger, alias: Extension Shape Same As Culvert, editable: true, nullable: true, defaultValue: null, modelName: ExtensionShapeSameAsCulvert , Coded Values: [1: Yes] , [2: No] )
• FootingExposed ( type: esriFieldTypeSmallInteger, alias: Footing Exposed, editable: true, nullable: true, defaultValue: null, modelName: FootingExposed , Coded Values: [1: Yes] , [2: No] )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: Install Year, editable: true, nullable: true, defaultValue: null, modelName: InstallYear )
• InvertAboveChannelBottom ( type: esriFieldTypeSmallInteger, alias: Invert Above Channel Bottom, editable: true, nullable: true, defaultValue: null, modelName: InvertAboveChannelBottom , Coded Values: [1: Yes] , [2: No] )
• scour_prot_type_cd ( type: esriFieldTypeSmallInteger, alias: Scour Protection Type, editable: true, nullable: true, defaultValue: null, modelName: scour_prot_type_cd , Coded Values: [1: Plain Riprap] , [2: Heavy Riprap] , [3: Field Stone] , ...7 more... )
• Riprap ( type: esriFieldTypeSmallInteger, alias: Riprap, editable: true, nullable: true, defaultValue: null, modelName: Riprap , Coded Values: [1: Yes] , [2: No] )
• RiprapCondition ( type: esriFieldTypeSmallInteger, alias: Riprap Condition, editable: true, nullable: true, defaultValue: null, modelName: RiprapCondition )
• SafetyGrate ( type: esriFieldTypeSmallInteger, alias: Safety Grate, editable: true, nullable: true, defaultValue: null, modelName: SafetyGrate , Coded Values: [1: Yes] , [2: No] )
• ScourPresent ( type: esriFieldTypeSmallInteger, alias: Scour Present, editable: true, nullable: true, defaultValue: null, modelName: ScourPresent , Coded Values: [1: Yes] , [2: No] )
• SedimentDepthGreater20 ( type: esriFieldTypeSmallInteger, alias: Sediment Depth Greater 20, editable: true, nullable: true, defaultValue: null, modelName: SedimentDepthGreater20 , Coded Values: [1: Yes] , [2: No] )
• EndSectionExtLength_ft ( type: esriFieldTypeDouble, alias: End Section Extension Length (ft), editable: true, nullable: true, defaultValue: null, modelName: EndSectionExtLength_ft )
• EndSectionRemarks ( type: esriFieldTypeString, alias: End Section Remarks, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: EndSectionRemarks )
• invt_field_vrfy_date ( type: esriFieldTypeDate, alias: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: invt_field_vrfy_date )
• invt_field_vrfy_user ( type: esriFieldTypeString, alias: Inventory Field Verification User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: invt_field_vrfy_user )
• invt_field_vrfy_cmpy_cd ( type: esriFieldTypeSmallInteger, alias: Field Verification Company, editable: true, nullable: true, defaultValue: null, modelName: invt_field_vrfy_cmpy_cd , Coded Values: [1: MDOT] , [2: HNTB] , [3: Collins] , ...6 more... )
• UserCreate ( type: esriFieldTypeString, alias: User Create, editable: false, nullable: true, length: 255, defaultValue: null, modelName: UserCreate )
• SystemCreateDate ( type: esriFieldTypeDate, alias: System Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: SystemCreateDate )
• UserModified ( type: esriFieldTypeString, alias: User Modified, editable: false, nullable: true, length: 255, defaultValue: null, modelName: UserModified )
• SystemModifiedDate ( type: esriFieldTypeDate, alias: System Modified Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: SystemModifiedDate )

Templates:

• Name: Culvert End Inventory
  Description:
  Prototype:
  invt_field_vrfy_cmpy_cd: null
  invt_field_vrfy_user: null
  Bound: null
  ConditionIndex: null
  CulvertEndID: null
  CulvertID: null
  EmbankmentCondition: null
  EndExtension: null
  EndLocation: null
  EndSection: null
  EndSectionDetached: null
  EndSectionMaterial: null
  ExtensionDimeSameAsCulvert: null
  ExtensionMaterialSameAsCulvert: null
  ExtensionShapeSameAsCulvert: null
  FootingExposed: null
  InstallYear: null
  InvertAboveChannelBottom: null
  scour_prot_type_cd: null
  Riprap: null
  RiprapCondition: null
  SafetyGrate: null
  ScourPresent: null
  SedimentDepthGreater20: null
  EndSectionExtLength_ft: null
  EndSectionRemarks: null
  invt_field_vrfy_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (4) -- Related To: Culvert Inventory (11)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: SystemCreateDate
• Creator Field: UserCreate
• Edit Date Field: SystemModifiedDate
• Editor Field: UserModified

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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