Name: Small_Culvert_Inventory___Stone_Field_Data_Collection

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 4622325

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8174633.35361762
YMin: 5349845.14969857
XMax: -8037856.67313997
YMax: 5624081.87356817
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[110,207,252,255],"width":1}},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• DELETE_RECORD (type: esriFieldTypeString, alias: DELETE RECORD, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeSmallInteger, alias: DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNIT_NAME (type: esriFieldTypeString, alias: UNIT NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UNIT_ID (type: esriFieldTypeDouble, alias: UNIT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOWN (type: esriFieldTypeString, alias: TOWN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: ROUTE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TWN_LR (type: esriFieldTypeString, alias: TWN_LR, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• TWN_MM (type: esriFieldTypeDouble, alias: TWN_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ETE_LR (type: esriFieldTypeString, alias: ETE_LR, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• ETE_MM (type: esriFieldTypeDouble, alias: ETE_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MS4 (type: esriFieldTypeString, alias: MS4, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LAST_INSPECTION_DATE (type: esriFieldTypeDate, alias: LAST INSPECTION DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: INSTALL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IN_TREATMENT (type: esriFieldTypeString, alias: INLET TREATMENT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IN_TIE (type: esriFieldTypeString, alias: INLET TIE-IN, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IN_EXTENSION (type: esriFieldTypeString, alias: INLET EXTENSION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IN_MARKER_POST (type: esriFieldTypeString, alias: INLET MARKER POST, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IN_SEPARATION (type: esriFieldTypeString, alias: INLET SEPARATION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IN_CONDITION (type: esriFieldTypeString, alias: INLET CONDITION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: GOOD], [3: FAIR], [0: UNKWN], ... 2 more ...)
• IN_SEDIMENT (type: esriFieldTypeString, alias: INLET SEDIMENT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: NONE], [2: LIGHT], [3: MOD], ... 3 more ...)
• IN_EROSION (type: esriFieldTypeString, alias: INLET EROSION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: NONE], [3: LIGHT], [0: UNKWN], ... 2 more ...)
• IN_PIPING (type: esriFieldTypeString, alias: INLET PIPING, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IN_COMMENT (type: esriFieldTypeString, alias: INLET COMMENT, SQL Type: sqlTypeOther, length: 230, nullable: true, editable: true)
• DRAIN_TYPE (type: esriFieldTypeString, alias: DRAIN TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SYS_TYPE (type: esriFieldTypeString, alias: SYSTEM TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STRUC_TYPE (type: esriFieldTypeString, alias: STRUCTURE TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SIZE (type: esriFieldTypeSmallInteger, alias: SIZE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEIGHT (type: esriFieldTypeSmallInteger, alias: OTHER HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeSmallInteger, alias: OTHER WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FILL_DEPTH (type: esriFieldTypeSmallInteger, alias: FILL DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ELBOWS (type: esriFieldTypeString, alias: ELBOWS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• MODS (type: esriFieldTypeString, alias: MODIFICATIONS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• BARL_SEPARATION (type: esriFieldTypeString, alias: BARREL SEPARATION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• BARL_CONDITION (type: esriFieldTypeString, alias: BARREL CONDITION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: GOOD], [0: UNKNWN], [3: FAIR], ... 2 more ...)
• BARL_SEDIMENT (type: esriFieldTypeString, alias: BARREL SEDIMENT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [0: UNKNW], [1: NONE], [2: LIGHT], ... 3 more ...)
• BARL_COMMENT (type: esriFieldTypeString, alias: BARREL COMMENT, SQL Type: sqlTypeOther, length: 230, nullable: true, editable: true)
• OUT_TREATMENT (type: esriFieldTypeString, alias: OUTLET TREATMENT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• OUT_EXTENSION (type: esriFieldTypeString, alias: OUTLET EXTENSION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• OUT_TIE (type: esriFieldTypeString, alias: OUTLET TIE-IN, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• OUT_MARKER_POST (type: esriFieldTypeString, alias: OUTLET MARKER POST, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OUT_SEPARATION (type: esriFieldTypeString, alias: OUTLET SEPARATION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• OUT_CONDITION (type: esriFieldTypeString, alias: OUTLET CONDITION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: GOOD], [3: FAIR], [0: UNKNW], ... 2 more ...)
• OUT_SEDIMENT (type: esriFieldTypeString, alias: OUTLET SEDIMENT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: NONE], [2: LIGHT], [3: MOD], ... 3 more ...)
• OUT_EROSION (type: esriFieldTypeString, alias: OUTLET EROSION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: NONE], [3: LIGHT], [0: UNKNW], ... 2 more ...)
• OUT_PIPING (type: esriFieldTypeString, alias: OUTLET PIPING, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• OUT_COMMENT (type: esriFieldTypeString, alias: OUTLET COMMENT, SQL Type: sqlTypeOther, length: 230, nullable: true, editable: true)
• PROJECTED_END (type: esriFieldTypeString, alias: PROJECTED END, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STONE_PAD (type: esriFieldTypeString, alias: STONE PAD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ROAD_SETTLING (type: esriFieldTypeString, alias: ROAD SETTLING, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: NONE], [5: GRADE], [3: REPAIR], ... 1 more ...)
• SINK_HOLES (type: esriFieldTypeString, alias: SINK HOLES, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1: NONE], [0: UNKNW], [3: MOD], ... 3 more ...)
• GEN_COMMENT (type: esriFieldTypeString, alias: GENERAL COMMENT, SQL Type: sqlTypeOther, length: 230, nullable: true, editable: true)
• NEW_DATA_TYPE (type: esriFieldTypeString, alias: NEW DATA TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSPECTOR (type: esriFieldTypeString, alias: INSPECTOR, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LENGTH_FT (type: esriFieldTypeDouble, alias: CULVERT LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_XLOCATION (type: esriFieldTypeDouble, alias: IN_XLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_YLOCATION (type: esriFieldTypeDouble, alias: IN_YLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_ZLOCATION (type: esriFieldTypeDouble, alias: IN_ZLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_ZFEET (type: esriFieldTypeDouble, alias: IN_ZFEET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_LAT (type: esriFieldTypeDouble, alias: IN_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_LONG (type: esriFieldTypeDouble, alias: IN_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUT_XLOCATION (type: esriFieldTypeDouble, alias: OUT_XLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUT_YLOCATION (type: esriFieldTypeDouble, alias: OUT_YLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUT_ZLOCATION (type: esriFieldTypeDouble, alias: OUT_ZLOCATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUT_ZFEET (type: esriFieldTypeDouble, alias: OUT_ZFEET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUT_LAT (type: esriFieldTypeDouble, alias: OUT_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUT_LONG (type: esriFieldTypeDouble, alias: OUT_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYMBOL (type: esriFieldTypeString, alias: SYMBOL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RoadSeg_UniqueID (type: esriFieldTypeInteger, alias: RoadSeg_UniqueID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• Stone_Inspection_Status (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FullCulvertReplacement (type: esriFieldTypeInteger, alias: Full Culvert Replacement Needed?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PartialCulvertReplacement (type: esriFieldTypeInteger, alias: Partial Culvert Replacement Needed?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UpsizeCulverts (type: esriFieldTypeInteger, alias: Upsize Culvert?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SlipLineCulvert (type: esriFieldTypeInteger, alias: Slip-Line Culvert?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExtendCulvertPipe (type: esriFieldTypeInteger, alias: Extend Culvert Pipe?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExtendCulvertEnd (type: esriFieldTypeInteger, alias: Extend Culvert End Section?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstallHeadwall (type: esriFieldTypeInteger, alias: Install Headwall(s)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstallWingWalls (type: esriFieldTypeInteger, alias: Install Wing Wall(s)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstllConcApron (type: esriFieldTypeInteger, alias: Install Concrete Apron at Outlet?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StabilizeTypeI_Stone (type: esriFieldTypeInteger, alias: Stabilize Inlet/Outlet with Type I Stone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StabilizeTypeII_Stone (type: esriFieldTypeInteger, alias: Stabilize Inlet/Outlet with Type II Stone?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Repaving (type: esriFieldTypeInteger, alias: Repaving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClearDebris_Cogging (type: esriFieldTypeInteger, alias: Clear Debris/Clogging, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherBMP_Needed (type: esriFieldTypeString, alias: Other BMP Needed? (Describe), SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• GeneralComment_Stone (type: esriFieldTypeString, alias: General Comment by Stone, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• MeetsStandards (type: esriFieldTypeString, alias: Meets Standards?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• IN_CONDITION_1 (type: esriFieldTypeString, alias: INLET CONDITION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IN_CONDITION_12 (type: esriFieldTypeString, alias: INLET CONDITION, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Inspector1 (type: esriFieldTypeString, alias: Inspector #1, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Inspector2 (type: esriFieldTypeString, alias: Inspector #2, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• MeetsStandards_FieldCheck (type: esriFieldTypeString, alias: Meets Standards? (Field Check), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• RoadSeg_UniqueID_1 (type: esriFieldTypeInteger, alias: RoadSeg_UniqueID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletCondition_int (type: esriFieldTypeInteger, alias: InletCondition_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletSediment_int (type: esriFieldTypeInteger, alias: InletSediment_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletErosion_int (type: esriFieldTypeInteger, alias: InletErosion_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BarrelCondition_int (type: esriFieldTypeInteger, alias: BarrelCondition_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BarrelSediment_in (type: esriFieldTypeInteger, alias: BarrelSediment_in, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletCondition_int (type: esriFieldTypeInteger, alias: OutletCondition_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletSediment_int (type: esriFieldTypeInteger, alias: OutletSediment_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletErosion_int (type: esriFieldTypeInteger, alias: OutletErosion_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RdSettling_int (type: esriFieldTypeInteger, alias: RdSettling_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SinkHoles_int (type: esriFieldTypeInteger, alias: SinkHoles_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CulvertCondition_Meets (type: esriFieldTypeString, alias: Culvert Conditions Meets?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CulvertSediment_Meets (type: esriFieldTypeString, alias: Culvert Sediment Meets?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CulvertErosion_Meets (type: esriFieldTypeString, alias: Culvert Erosion Meets, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CulvertRdSettling_Meets (type: esriFieldTypeString, alias: Culvert Road Settling Meets?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CulvertSinkHoles_Meet (type: esriFieldTypeString, alias: Culver Sink Holes Meets?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MeetsStandards_revised (type: esriFieldTypeString, alias: Meets Standards Revised, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate_12 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_12 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_12 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_12 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• SHAPE__Length (type: esriFieldTypeDouble, alias: SHAPE__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Total_Fix_Cost (type: esriFieldTypeInteger, alias: Estimated Cost to Bring Culvert Up to Standards, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• PID: 0
• DISTRICT: 0
• UNIT_ID: 0
• TWN_MM: 0
• ETE_MM: 0
• SIZE: 0
• HEIGHT: 0
• WIDTH: 0
• FILL_DEPTH: 0
• LENGTH_FT: 0
• IN_XLOCATION: 0
• IN_YLOCATION: 0
• IN_ZLOCATION: 0
• IN_ZFEET: 0
• IN_LAT: 0
• IN_LONG: 0
• OUT_XLOCATION: 0
• OUT_YLOCATION: 0
• OUT_ZLOCATION: 0
• OUT_ZFEET: 0
• OUT_LAT: 0
• OUT_LONG: 0
• RoadSeg_UniqueID: 0
• FullCulvertReplacement: 0
• PartialCulvertReplacement: 0
• UpsizeCulverts: 0
• SlipLineCulvert: 0
• ExtendCulvertPipe: 0
• ExtendCulvertEnd: 0
• InstallHeadwall: 0
• InstallWingWalls: 0
• InstllConcApron: 0
• StabilizeTypeI_Stone: 0
• StabilizeTypeII_Stone: 0
• Repaving: 0
• ClearDebris_Cogging: 0
• RoadSeg_UniqueID_1: 0

Relationships:

• RoadSeg_Culvert_REL (0) -- Related To: VTransRdSeg_for_Collector (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/29/2022 1:45:17 PM

Schema Last Edit Date: 3/29/2022 1:45:17 PM

Data Last Edit Date: 3/29/2022 1:45:17 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat