Name: CulvertPoint

Display Field: INSPECTOR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1410777.57114057
YMin: 581158.789647222
XMax: 1514556.50531457
YMax: 704932.689736724
Spatial Reference: 102723 (3735)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[59,0,176,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• CRS (type: esriFieldTypeString, alias: CRS, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ROUTE_TYPE (type: esriFieldTypeString, alias: Route Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [IR: Interstate], [US: United States Route], [SR: State Route], ... 4 more ...)
• ROUTE_NBR (type: esriFieldTypeString, alias: Route Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CTL_BEGIN_NBR (type: esriFieldTypeDouble, alias: CTL Begin Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STL_BEGIN_NBR (type: esriFieldTypeDouble, alias: STL Begin Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE_DD_BEGIN (type: esriFieldTypeDouble, alias: Latitude DD Begin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE_DD_BEGIN (type: esriFieldTypeDouble, alias: Longitude DD Begin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: Active], [R: Retired], [P: Proposed], ... 1 more ...)
• INSTALLATION_DATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CULVERT_FILE_NUMBER (type: esriFieldTypeInteger, alias: Culvert File Number (CFN), SQL Type: sqlTypeOther, nullable: true, editable: true)
• OLD_CULVERT_FILE_NBR (type: esriFieldTypeString, alias: Old Culvert File Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CULVERT_OWNER (type: esriFieldTypeString, alias: R-Culvert Owner, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [S: S - State Department of Transportation], [C: C - County Agency], [M: M - City], ... 4 more ...)
• MAINTAIN_RESPONSIBLE (type: esriFieldTypeString, alias: R-Maintenance Responsibility, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [S: S - State Department of Transportation], [C: C - County Agency], [M: M - City], ... 4 more ...)
• ENTRY_CLASS (type: esriFieldTypeString, alias: R-Entry Class, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: Class A (Non-Entry Inspection)], [B: Class B (Non-Permit Required Entry)], [C: Class C (Alternate Entry Permit Required)], ... 1 more ...)
• FEATURE_INTERSECTED (type: esriFieldTypeString, alias: O-Feature Intersected, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• NUMBER_OF_CELLS (type: esriFieldTypeInteger, alias: R-Number of Cells, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• CULVERT_SHAPE (type: esriFieldTypeString, alias: R-Culvert Shape, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: 1 - Circular], [2: 2 - Elliptical - Horizontal], [3: 3 - Elliptical - Vertical], ... 6 more ...)
• MATERIAL (type: esriFieldTypeString, alias: R-Culvert Material, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: 1 - Plain or Reinforced Concrete], [2: 2 - Corrugated Metal, Pipe (Shape Code 1)], [3: 3 - Corrugated Metal, Non-Sectional Plate (Shape Code 4)], ... 18 more ...)
• SPAN_INCHES (type: esriFieldTypeInteger, alias: R-Span (Inches), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [6 - 119])
• RISE_INCHES (type: esriFieldTypeInteger, alias: R-Rise (Inches) (Leave blank if Shape is Circular), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [6 - 119])
• LENGTH_FEET (type: esriFieldTypeInteger, alias: R-Length (Feet) (Include extensions), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 9999])
• SKEW_DEGREES (type: esriFieldTypeInteger, alias: R-Skew (Degrees), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 89])
• INLET_END_TREATMENT (type: esriFieldTypeString, alias: R-Inlet End Treatment, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: 1 - Full Height Concrete Headwall], [2: 2 - Half Height Concrete Headwall], [3: 3 - Third Height Concrete Headwall], ... 10 more ...)
• OUTLET_END_TREATMENT (type: esriFieldTypeString, alias: R-Outlet End Treatment, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: 1 - Full Height Concrete Headwall], [2: 2 - Half Height Concrete Headwall], [3: 3 - Third Height Concrete Headwall], ... 10 more ...)
• MAX_HEIGHT_COVER_FT (type: esriFieldTypeInteger, alias: R-Maximum Height of Cover (Feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 999])
• COMMENT (type: esriFieldTypeString, alias: O-Inventory Comments, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• INVENTORIED_BY (type: esriFieldTypeString, alias: O-Inventoried By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [EM: Eric Moody], [JP: James Poston], [MS: Mark Schaub], ... 2 more ...)
• INVENTORY_DATE (type: esriFieldTypeDate, alias: R-Inventory Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• LEVEL_OF_INSPECTION (type: esriFieldTypeString, alias: R-Level of Inspection, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [X: X - Inspection from ends of culvert. (Non-entry)], [M: M - Manned Entry inspection], [R: R - Remote Inspection], ... 2 more ...)
• MATERIAL_CONDITION (type: esriFieldTypeInteger, alias: R-Culvert Material Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• CULVERT_ALIGNMENT (type: esriFieldTypeInteger, alias: R-Culvert Alignment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• SHAPE_RATING (type: esriFieldTypeInteger, alias: R-Culvert Shape Rating (Leave blank if Rigid), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• SEAMS_OR_JOINTS (type: esriFieldTypeInteger, alias: R-Seams or Joints (Leave blank if N/A), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• SLAB (type: esriFieldTypeInteger, alias: R-Slab (Only rate if Shape is Slab), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• ABUTMENTS (type: esriFieldTypeInteger, alias: R-Abutments (Leave blank if N/A), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• HEADWALLS (type: esriFieldTypeInteger, alias: R-Headwalls (Leave blank if N/A), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• END_STRUCTURE (type: esriFieldTypeInteger, alias: R-End Structure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• CHANNEL_ALIGNMENT (type: esriFieldTypeInteger, alias: R-Channel Alignment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• CHANNEL_PROTECTION (type: esriFieldTypeInteger, alias: R-Channel Protection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• WATERWAY_BLOCKAGE (type: esriFieldTypeInteger, alias: R-Culvert Waterway Blockage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• SCOUR (type: esriFieldTypeInteger, alias: R-Scour, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• PAVEMENT (type: esriFieldTypeInteger, alias: R-Pavement, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• GUARDRAIL (type: esriFieldTypeInteger, alias: R-Guardrail (Leave blank if N/A), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• EMBANKMENT (type: esriFieldTypeInteger, alias: R-Embankment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9-Excellent], [8: 8-Very Good], [7: 7-Good], ... 7 more ...)
• GENERAL_APPRAISAL (type: esriFieldTypeInteger, alias: R-General Appraisal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [9: 9 - As built condition], [8: 8 - Very good condition - no problems noted], [7: 7 - Good condition - some minor problems], ... 7 more ...)
• OPERATIONAL_STATUS (type: esriFieldTypeString, alias: R-Operational Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A - Open, no restriction], [B: B - Open, posting recommended but not legally implemented (all signs not in place).], [C: C - Under construction, half of the existing culvert is open to traffic (half-width construction).], ... 7 more ...)
• COMMENT_INSP (type: esriFieldTypeString, alias: O-Inspection comments, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• INSPECTOR_NAME (type: esriFieldTypeString, alias: O-Inspected By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [EM: Eric Moody], [JP: James Poston], [MS: Mark Schaub], ... 2 more ...)
• INSPECTION_DATE (type: esriFieldTypeDate, alias: R-Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RECOMMEND_PREVENT_MAINT (type: esriFieldTypeString, alias: O-Recommend Preventive Maintenance, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Nothing], [2: Minor Maintenance Recommended], [3: Major Maintenance Reccommended])

Templates:

Name: CulvertPoint
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• STATUS: A
• ENTRY_CLASS: A
• NUMBER_OF_CELLS: 1
• CULVERT_SHAPE: 1
• MATERIAL: 1
• SKEW_DEGREES: 0
• INLET_END_TREATMENT: 2
• OUTLET_END_TREATMENT: 2
• LEVEL_OF_INSPECTION: X

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/7/2019 5:33:37 PM

Schema Last Edit Date: 8/7/2019 5:33:37 PM

Data Last Edit Date: 8/7/2019 5:33:37 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat