Name: s123_CulvertInsp

Display Field: RoadName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 121fdbb265ae4a579ac3d6ac21361178

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

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 )
• CountyMaint ( type: esriFieldTypeString, alias: County Maint, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CountyMaint , Coded Values: [Yes: Yes] , [No: No] )
• MultiplierGasb ( type: esriFieldTypeDouble, alias: MultiplierGasb, editable: true, nullable: true, defaultValue: null, modelName: MultiplierGasb )
• CostToConstruct ( type: esriFieldTypeDouble, alias: CostToConstruct, editable: true, nullable: true, defaultValue: null, modelName: CostToConstruct )
• CommentsGIS ( type: esriFieldTypeString, alias: CommentsGIS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CommentsGIS )
• ID_SEARCH ( type: esriFieldTypeString, alias: ID_SEARCH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_SEARCH )
• SEGID ( type: esriFieldTypeDouble, alias: SEGID, editable: true, nullable: true, defaultValue: null, modelName: SEGID )
• GISStatus ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GISStatus , Coded Values: [IS: In Service] , [NIS: Not in Service] )
• CulvertID ( type: esriFieldTypeDouble, alias: CulvertID, editable: true, nullable: true, defaultValue: null, modelName: CulvertID )
• RoadNumber ( type: esriFieldTypeInteger, alias: Road Number, editable: true, nullable: true, defaultValue: null, modelName: RoadNumber )
• RoadName ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: RoadName )
• StationFeet ( type: esriFieldTypeDouble, alias: Station Feet, editable: true, nullable: true, defaultValue: null, modelName: StationFeet )
• StationMiles ( type: esriFieldTypeDouble, alias: Station Miles, editable: true, nullable: true, defaultValue: null, modelName: StationMiles )
• OPN ( type: esriFieldTypeString, alias: OPN, editable: true, nullable: true, length: 2, defaultValue: null, modelName: OPN , Coded Values: [1: Continuous] , [2: Non-Continuous] )
• PavementWidth ( type: esriFieldTypeDouble, alias: Pavement Width, editable: true, nullable: true, defaultValue: null, modelName: CulvertWidth )
• Length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• FL ( type: esriFieldTypeDouble, alias: FL, editable: true, nullable: true, defaultValue: null, modelName: FL )
• DateBuilt ( type: esriFieldTypeDate, alias: Date Built, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateBuilt )
• RightType ( type: esriFieldTypeString, alias: Right Type, editable: true, nullable: true, length: 128, defaultValue: null, modelName: RightType , Coded Values: [Pipe: Pipe] , [Arch: Arch] , [Box: Box] , ...2 more... )
• RightHeight ( type: esriFieldTypeDouble, alias: Right Height, editable: true, nullable: true, defaultValue: null, modelName: RightHeight )
• RightWidth ( type: esriFieldTypeDouble, alias: Right Width, editable: true, nullable: true, defaultValue: null, modelName: RightWidth )
• RightCulvertMaterial ( type: esriFieldTypeString, alias: Right Culvert Material, editable: true, nullable: true, length: 128, defaultValue: null, modelName: RightCulvertMaterial , Coded Values: [BLCKCONC: Concrete Block] , [CMP: Corrugated Metal Pipe] , [CONCRETE: Concrete] , ...8 more... )
• RightHeadwallMaterial ( type: esriFieldTypeString, alias: Right Headwall Material, editable: true, nullable: true, length: 128, defaultValue: null, modelName: RightHeadwallMaterial , Coded Values: [BLCKCONC: Concrete Block] , [BLOCK: Block] , [CATCHBSN: Catch Basin] , ...6 more... )
• RightWingwallMaterialNE ( type: esriFieldTypeString, alias: Right Wingwall Material NE, editable: true, nullable: true, length: 128, defaultValue: null, modelName: RightWingwallMaterialNE , Coded Values: [BLCKCONC: Concrete Block] , [BLOCK: Block] , [CATCHBSN: Catch Basin] , ...6 more... )
• RightWingwallMaterialSW ( type: esriFieldTypeString, alias: Right Wingwall Material SW, editable: true, nullable: true, length: 128, defaultValue: null, modelName: RightWingwallMaterialSW , Coded Values: [BLCKCONC: Concrete Block] , [BLOCK: Block] , [CATCHBSN: Catch Basin] , ...6 more... )
• LeftType ( type: esriFieldTypeString, alias: Left Type, editable: true, nullable: true, length: 128, defaultValue: null, modelName: LeftType )
• LeftHeight ( type: esriFieldTypeDouble, alias: Left Height, editable: true, nullable: true, defaultValue: null, modelName: LeftHeight )
• LeftWidth ( type: esriFieldTypeDouble, alias: Left Width, editable: true, nullable: true, defaultValue: null, modelName: LeftWidth )
• LeftCulvertMaterial ( type: esriFieldTypeString, alias: Left Culvert Material, editable: true, nullable: true, length: 128, defaultValue: null, modelName: LeftCulvertMaterial , Coded Values: [BLCKCONC: Concrete Block] , [CMP: Corrugated Metal Pipe] , [CONCRETE: Concrete] , ...8 more... )
• LeftHeadwallMaterial ( type: esriFieldTypeString, alias: Left Headwall Material, editable: true, nullable: true, length: 128, defaultValue: null, modelName: LeftHeadwallMaterial , Coded Values: [BLCKCONC: Concrete Block] , [BLOCK: Block] , [CATCHBSN: Catch Basin] , ...6 more... )
• LeftWingwallMaterialNE ( type: esriFieldTypeString, alias: Left Wingwall Material NE, editable: true, nullable: true, length: 128, defaultValue: null, modelName: LeftWingwallMaterialNE , Coded Values: [BLCKCONC: Concrete Block] , [BLOCK: Block] , [CATCHBSN: Catch Basin] , ...6 more... )
• LeftWingwallMaterialSW ( type: esriFieldTypeString, alias: Left Wingwall Material SW, editable: true, nullable: true, length: 128, defaultValue: null, modelName: LeftWingwallMaterialSW , Coded Values: [BLCKCONC: Concrete Block] , [BLOCK: Block] , [CATCHBSN: Catch Basin] , ...6 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• InspectionRating ( type: esriFieldTypeSmallInteger, alias: Rating, editable: true, nullable: true, defaultValue: null, modelName: InspectionRating , Coded Values: [1: 1 = New] , [2: 2 = Good] , [3: 3 = Replace Prior to Paving] , ...3 more... )
• InspectionComments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectionComments )
• InspectionInspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspectionInspector )
• InspectionMnt ( type: esriFieldTypeString, alias: Inspection Maint, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionMnt , Coded Values: [Yes: Yes] , [No: No] )
• InspectionChn ( type: esriFieldTypeString, alias: Inspection Channel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionChn , Coded Values: [Yes: Yes] , [No: No] )
• InpsectionHdw ( type: esriFieldTypeString, alias: Inpsection Headwall, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InpsectionHdw , Coded Values: [Yes: Yes] , [No: No] )
• InspectionPav ( type: esriFieldTypeString, alias: Inspection Pavement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionPav , Coded Values: [Yes: Yes] , [No: No] )
• InspectionGdr ( type: esriFieldTypeString, alias: Inspection Guardrail, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionGdr , Coded Values: [Yes: Yes] , [No: No] )
• InspectionOther ( type: esriFieldTypeString, alias: Inspection Other, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionOther , Coded Values: [Yes: Yes] , [No: No] )
• CardinalOpening ( type: esriFieldTypeDouble, alias: Cardinal Opening, editable: true, nullable: true, defaultValue: null, modelName: CardinalOpening )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• picture ( type: esriFieldTypeString, alias: picture, editable: true, nullable: true, length: 255, defaultValue: null, modelName: picture )
• MaintenanceItems ( type: esriFieldTypeString, alias: MaintenanceItems, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenanceItems , Coded Values: [N: NONE] , [C: CAMERA PIPE] , [D: DITCH WORK] , ...9 more... )
• MaintenanceDate ( type: esriFieldTypeDate, alias: MaintenanceDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintenanceDate )
• MaintenancePerson ( type: esriFieldTypeString, alias: MaintenancePerson, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenancePerson )
• oldstateid ( type: esriFieldTypeDouble, alias: oldstateid, editable: true, nullable: true, defaultValue: null, modelName: oldstateid )
• NEWStationMiles ( type: esriFieldTypeDouble, alias: NEWStationMiles, editable: true, nullable: true, defaultValue: null, modelName: NEWStationMiles )

Templates:

• Name: s123_CulvertInsp
  Description:
  Prototype:
  oldstateid: null
  MaintenancePerson: null
  CountyMaint: null
  MultiplierGasb: null
  CostToConstruct: null
  CommentsGIS: null
  ID_SEARCH: null
  SEGID: null
  GISStatus: null
  CulvertID: null
  RoadNumber: null
  RoadName: null
  StationFeet: null
  StationMiles: null
  OPN: null
  PavementWidth: null
  Length: null
  FL: null
  DateBuilt: null
  RightType: null
  RightHeight: null
  RightWidth: null
  RightCulvertMaterial: null
  RightHeadwallMaterial: null
  RightWingwallMaterialNE: null
  RightWingwallMaterialSW: null
  LeftType: null
  LeftHeight: null
  LeftWidth: null
  LeftCulvertMaterial: null
  LeftHeadwallMaterial: null
  LeftWingwallMaterialNE: null
  LeftWingwallMaterialSW: null
  InspectionDate: null
  InspectionRating: null
  InspectionComments: null
  InspectionInspector: null
  InspectionMnt: null
  InspectionChn: null
  InpsectionHdw: null
  InspectionPav: null
  InspectionGdr: null
  InspectionOther: null
  CardinalOpening: null
  NEWStationMiles: null
  REL_GLOBALID: null
  MaintenanceDate: null
  MaintenanceItems: null
  picture: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• gis.DBO.fc_CulvertLocation (1) -- Related To: CulvertLocation (0)

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

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

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

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