Name: Abbotsford_Culverts_SA

Display Field: INSPECTOR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 546692.5189
YMin: 5431692.1963
XMax: 552168.4055
YMax: 5436196.041
Spatial Reference: 26910 (26910)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[42,145,133,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSET_ID (type: esriFieldTypeInteger, alias: ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CULVERT_TY (type: esriFieldTypeSmallInteger, alias: CULVERT_TY, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Arched], [1: Box], [2: Round], ... 2 more ...)
• LIFECYCLE_ (type: esriFieldTypeSmallInteger, alias: LIFECYCLE_, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Active], [1: Abandoned], [2: Inactive], ... 6 more ...)
• INLET_GRIL (type: esriFieldTypeSmallInteger, alias: INLET_GRIL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• OUTLET_GRI (type: esriFieldTypeSmallInteger, alias: OUTLET_GRI, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• CONTROL_DE (type: esriFieldTypeSmallInteger, alias: CONTROL_DE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Weir], [1: Slide Gate], [2: Flap Gate], ... 3 more ...)
• INLET_WALL (type: esriFieldTypeSmallInteger, alias: INLET_WALL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Sandbag], [1: Concrete Bag], [2: Concrete], ... 6 more ...)
• OUTLET_WAL (type: esriFieldTypeSmallInteger, alias: OUTLET_WAL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Sandbag], [1: Concrete Bag], [2: Concrete], ... 6 more ...)
• DIAMETER (type: esriFieldTypeSmallInteger, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [150: 150], [200: 200], [250: 250], ... 41 more ...)
• DIAMETER_A (type: esriFieldTypeSmallInteger, alias: DIAMETER_A, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• HEIGHT (type: esriFieldTypeSmallInteger, alias: HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [200: 200], [250: 250], ... 19 more ...)
• MATERIAL (type: esriFieldTypeSmallInteger, alias: MATERIAL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [7: CIPP], [0: Concrete], [1: Corrugated Steel], ... 9 more ...)
• OWNER (type: esriFieldTypeSmallInteger, alias: OWNER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Municipal], [1: Private], [2: Provincial], ... 6 more ...)
• CREEK (type: esriFieldTypeSmallInteger, alias: CREEK, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• STREET_NAM (type: esriFieldTypeString, alias: STREET_NAM, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FUNCTION_ (type: esriFieldTypeSmallInteger, alias: FUNCTION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Driveway], [3: Field], [5: Hydrant], ... 4 more ...)
• UPSTREAM_I (type: esriFieldTypeDouble, alias: UPSTREAM_I, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNSTREAM (type: esriFieldTypeDouble, alias: DOWNSTREAM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAPITALIZA (type: esriFieldTypeDate, alias: CAPITALIZA, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SAP_ORDER (type: esriFieldTypeString, alias: SAP_ORDER, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• SHAPE_Leng (type: esriFieldTypeDouble, alias: SHAPE_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TNB (type: esriFieldTypeSingle, alias: TNB_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EROSION (type: esriFieldTypeString, alias: EROSION, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [2: Yes], [1: No], [0: NA])
• INVERT_DETER (type: esriFieldTypeString, alias: INVERT_DETER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• JOINTS_SEAMS (type: esriFieldTypeString, alias: JOINTS_SEAMS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• STRUT_INTEG (type: esriFieldTypeString, alias: STRUT_INTEG, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• HW_WALL_INTEG (type: esriFieldTypeString, alias: HEADWALL_INTEG, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• APRON_INTEG (type: esriFieldTypeString, alias: APRON_INTEG, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• STRUCT_ALIGN (type: esriFieldTypeString, alias: STRUCT_ALIGN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• BLOCKAGE (type: esriFieldTypeString, alias: BLOCKAGE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [3: Adequate], [1: Critical], [2: Poor], ... 2 more ...)
• STRM_BED_MAT (type: esriFieldTypeString, alias: STRM_BED_MAT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [NA: NA], [Bedrock: Bedrock], [Boudler: Boulder], ... 4 more ...)
• FILL_HEIGHT (type: esriFieldTypeString, alias: FILL_HEIGHT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SOIL_TYPE (type: esriFieldTypeString, alias: SOIL_TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [CLAY: CLAY], [SAND: SAND], [SILT: SILT], ... 2 more ...)
• ROAD_MAT (type: esriFieldTypeString, alias: ROAD_MAT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [ASH: Asphalt], [CONCR: Concrete], [DIRT: Dirt])
• INSPECTION_DATE (type: esriFieldTypeDate, alias: INSPECTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTOR_NAME (type: esriFieldTypeString, alias: INSPECTOR_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PIPE_NUM (type: esriFieldTypeSmallInteger, alias: PIPE_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VULN_SCORE (type: esriFieldTypeInteger, alias: VULN_SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OVERALL_COND (type: esriFieldTypeString, alias: OVERALL_COND, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [GRN: Green], [YLW: Yellow], [RED: Red])
• High_Water (type: esriFieldTypeString, alias: High_Water, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2: Yes], [1: No], [0: NA])
• Scour (type: esriFieldTypeString, alias: Scour, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2: Yes], [1: No], [0: NA])
• Ice (type: esriFieldTypeString, alias: Ice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2: Yes], [1: No], [0: NA])
• Aggradation (type: esriFieldTypeString, alias: Aggradation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2: Yes], [1: No], [0: NA])
• BANKFULL_WIDTH (type: esriFieldTypeSmallInteger, alias: BANKFULL_WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUT_GEO_COMP (type: esriFieldTypeSingle, alias: STRUCT_GEO_COMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ORIGINAL_COST (type: esriFieldTypeSingle, alias: ORIGINAL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Est_Water_Clearance (type: esriFieldTypeDouble, alias: Est. High Water Level Clearance (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_Water_Width (type: esriFieldTypeDouble, alias: Est. Present Water Level Width (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Est_Depth (type: esriFieldTypeDouble, alias: Est. Present Water Level Depth (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Additional_Comments (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AsBuilt_Checked (type: esriFieldTypeString, alias: As-Built Drawings Checked?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PengComments (type: esriFieldTypeString, alias: Professional Engineer Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Peng_Name (type: esriFieldTypeString, alias: Professional Engineer Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Date_Reviewed_peng (type: esriFieldTypeDate, alias: Date Reviewed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NextInspection_date (type: esriFieldTypeDate, alias: Date of Next Planned Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Crnt_load_rate (type: esriFieldTypeInteger, alias: Current Load Rating(GVW)(Tonnes), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Eng_InsptReq (type: esriFieldTypeInteger, alias: Engineer Inspection Required, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])

Templates:

Name: Abbotsford_Culverts_SA
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• AsBuilt_Checked: Yes
• Eng_InsptReq: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/20/2023 1:12:28 PM

Schema Last Edit Date: 3/20/2023 1:12:28 PM

Data Last Edit Date: 3/23/2022 5:15:42 PM

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