{ "layers": [ { "currentVersion": 10.71, "id": 0, "name": "Culvert_Location", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2036, "latestWkid": 2953 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 72, 0, 166, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2332437.83, "ymin": 7289037.83, "xmax": 2652324.09, "ymax": 7768867.22, "spatialReference": { "wkid": 2036, "latestWkid": 2953 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "WATERCOURSENAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "DATERECORDED", "type": "esriFieldTypeDate", "alias": "Date Recorded", "length": 8, "domain": null }, { "name": "RECORDEDBY", "type": "esriFieldTypeString", "alias": "Recorded By", "length": 25, "domain": null }, { "name": "STRUCTUREID", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 10, "domain": null }, { "name": "WATERCOURSENAME", "type": "esriFieldTypeString", "alias": "Watercourse Name", "length": 50, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "owner", "length": 3, "domain": { "type": "codedValue", "name": "roadStructOwners", "description": "Property owner of which the culvert is located on (general indicator)", "codedValues": [ { "name": "DNR", "code": "DNR" }, { "name": "DTI", "code": "DTI" }, { "name": "Industrial Freehold", "code": "IFH" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNEROTHER", "type": "esriFieldTypeString", "alias": "Owner Other", "length": 50, "domain": null }, { "name": "YEARINSTALLED", "type": "esriFieldTypeInteger", "alias": "Year Installed", "domain": null }, { "name": "CULVERTTYPE", "type": "esriFieldTypeString", "alias": "Culvert Type", "length": 2, "domain": { "type": "codedValue", "name": "culvertType_", "description": "The type of culvert observed", "codedValues": [ { "name": "Single Round Pipe", "code": "SR" }, { "name": "Multiple Round Pipe", "code": "MR" }, { "name": "Elliptical Round", "code": "EP" }, { "name": "Overflow Culvert", "code": "OF" }, { "name": "Fording Site/No Structure Present", "code": "NS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCTURESTATUS", "type": "esriFieldTypeString", "alias": "structureStatus", "length": 2, "domain": { "type": "codedValue", "name": "structureStatus_", "description": "Status of the structure", "codedValues": [ { "name": "Permanent", "code": "PC" }, { "name": "Temporary", "code": "TC" }, { "name": "Replacement", "code": "RC" }, { "name": "Removed", "code": "DC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULVERTMATERIAL", "type": "esriFieldTypeInteger", "alias": "Culvert Material", "domain": { "type": "codedValue", "name": "culvertMaterials_", "description": "The material the headwall of the culvert is constructed from", "codedValues": [ { "name": "Concrete / rock riprap", "code": 1 }, { "name": "Metal / rock riprap", "code": 2 }, { "name": "Metal / concrete wings", "code": 3 }, { "name": "Plastic / rock riprap", "code": 4 }, { "name": "Plastic / concrete wings", "code": 5 }, { "name": "Other", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULVERTMATERIALOTHER", "type": "esriFieldTypeString", "alias": "culvertMaterialOther", "length": 50, "domain": null }, { "name": "CULVERTDIAMETER", "type": "esriFieldTypeInteger", "alias": "Culvert Diameter", "domain": { "type": "codedValue", "name": "culvertDiameter_", "description": "Diameter of the culvert in mm", "codedValues": [ { "name": "450 mm", "code": 450 }, { "name": "525 mm", "code": 525 }, { "name": "600 mm", "code": 600 }, { "name": "750 mm", "code": 750 }, { "name": "900 mm", "code": 900 }, { "name": "1050 mm", "code": 1050 }, { "name": "1200 mm", "code": 1200 }, { "name": "1500 mm", "code": 1500 }, { "name": "1600 mm", "code": 1600 }, { "name": "1800 mm", "code": 1800 }, { "name": "2000 mm", "code": 2000 }, { "name": "2200 mm", "code": 2200 }, { "name": "2700 mm", "code": 2700 }, { "name": "3000 mm", "code": 3000 }, { "name": "3300 mm", "code": 3300 }, { "name": "3600 mm", "code": 3600 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULVERTDIAMETEROTHER", "type": "esriFieldTypeInteger", "alias": "Culvert Diameter Other", "domain": { "type": "range", "name": "culvertOtherDiameter", "description": "Diameters of culverts not within the standard range, in millimeters", "range": [ 300, 5000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULVERTLENGTH", "type": "esriFieldTypeInteger", "alias": "Culvert Length", "domain": { "type": "range", "name": "culvertLength_", "description": "Length of the culvert, ranging from 30-90 meters", "range": [ 5, 90 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FISHPASSAGEPOSSIBLE", "type": "esriFieldTypeInteger", "alias": "Fish Passage Possible", "domain": { "type": "codedValue", "name": "fishPassagePossible_", "description": "Possibility of fish passage (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "FISHPOSSIBLECOMMENTS", "type": "esriFieldTypeString", "alias": "FISHPOSSIBLECOMMENTS", "length": 255, "domain": null }, { "name": "WETLANDEQUALIZE", "type": "esriFieldTypeInteger", "alias": "Wetland Equalize", "domain": { "type": "codedValue", "name": "WetlandEqualize", "description": "Flag for whether the culvert was installed to perform wetland equalization rather than llow passage of a watercourse", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R838022_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_838022", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A1763_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CFP_Inspection", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.71, "id": 1, "name": "CFP_Inspections", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2036, "latestWkid": 2953 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 119, 128, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2306878.81, "ymin": 7277789.59, "xmax": 2711277.25, "ymax": 7674859.8100000005, "spatialReference": { "wkid": 2036, "latestWkid": 2953 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "INSPECTEDBY", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PARENTID", "type": "esriFieldTypeGUID", "alias": "PARENTID", "length": 38, "domain": null }, { "name": "DATEINSPECTED", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "INSPECTEDBY", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 25, "domain": null }, { "name": "CULVERTINSPECTION", "type": "esriFieldTypeInteger", "alias": "Culvert Inspection", "domain": { "type": "codedValue", "name": "performInspection", "description": "Completed inspection (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FISHPASSAGEASSESS", "type": "esriFieldTypeInteger", "alias": "Fish Passage Assess", "domain": { "type": "codedValue", "name": "performInspection", "description": "Completed inspection (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CROWNLICENSE", "type": "esriFieldTypeInteger", "alias": "Crown License", "domain": { "type": "codedValue", "name": "crownLicense", "description": "Which crown license the culvert is located in", "codedValues": [ { "name": "1", "code": 1 }, { "name": "3", "code": 3 }, { "name": "5", "code": 5 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOWSTATUS", "type": "esriFieldTypeInteger", "alias": "Flow Status", "domain": { "type": "codedValue", "name": "culvertFlowCondition_", "description": "The status of waterflow through the culvert at time of inspection\nThe status of waterflow through the culvert at time of inspection\nThe status of waterflow through the culvert at time of inspection\nStatus of waterflow through the culvert", "codedValues": [ { "name": "Low", "code": 1 }, { "name": "Normal", "code": 2 }, { "name": "High", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DITCHES", "type": "esriFieldTypeInteger", "alias": "Ditches", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DITCHESCOMMENTS", "type": "esriFieldTypeString", "alias": "Ditches Comments", "length": 255, "domain": null }, { "name": "TOPFILL", "type": "esriFieldTypeInteger", "alias": "Top Fill", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TOPFILLCOMMENTS", "type": "esriFieldTypeString", "alias": "Top Fill Comments", "length": 255, "domain": null }, { "name": "ROADEMBANK", "type": "esriFieldTypeInteger", "alias": "Road Embankment", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROADEMBANKCOMMENTS", "type": "esriFieldTypeString", "alias": "Road Embankment Comments", "length": 255, "domain": null }, { "name": "WINGWALL", "type": "esriFieldTypeInteger", "alias": "Wingwall", "domain": { "type": "codedValue", "name": "culvertStatus_NA_", "description": "Condition of the culvert with N/A option", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 }, { "name": "N/A", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WINGWALLCOMMENTS", "type": "esriFieldTypeString", "alias": "Wingwall Comments", "length": 255, "domain": null }, { "name": "RIPRAP", "type": "esriFieldTypeInteger", "alias": "Riprap", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RIPRAPCOMMENTS", "type": "esriFieldTypeString", "alias": "Riprap Comments", "length": 255, "domain": null }, { "name": "IODEBRIS", "type": "esriFieldTypeInteger", "alias": "IODebris", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IODEBRISCOMMENTS", "type": "esriFieldTypeString", "alias": "IODebrisComments", "length": 255, "domain": null }, { "name": "DENTS", "type": "esriFieldTypeInteger", "alias": "Dents", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DENTSCOMMENTS", "type": "esriFieldTypeString", "alias": "Dents Comments", "length": 255, "domain": null }, { "name": "BARRELDEBRIS", "type": "esriFieldTypeInteger", "alias": "Barrel Debris", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRELDEBRISCOMMENTS", "type": "esriFieldTypeString", "alias": "Barrel Debris Comments", "length": 255, "domain": null }, { "name": "VISIBLERUST", "type": "esriFieldTypeInteger", "alias": "Visible Rust", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VISIBLERUSTCOMMENTS", "type": "esriFieldTypeString", "alias": "Visible Rust Comments", "length": 255, "domain": null }, { "name": "ADEQUATESIZE", "type": "esriFieldTypeInteger", "alias": "Adequate Size", "domain": { "type": "codedValue", "name": "culvertStatus_", "description": "Condition of the culvert", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADEQUATESIZECOMMENTS", "type": "esriFieldTypeString", "alias": "Adequate Size Comments", "length": 255, "domain": null }, { "name": "JOINTDAMAGE", "type": "esriFieldTypeInteger", "alias": "Joint Damage", "domain": { "type": "codedValue", "name": "culvertStatus_NA_", "description": "Condition of the culvert with N/A option", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Good", "code": 75 }, { "name": "Fair", "code": 40 }, { "name": "Poor", "code": 0 }, { "name": "N/A", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "JOINTDAMAGECOMMENTS", "type": "esriFieldTypeString", "alias": "Joint Damage Comments", "length": 255, "domain": null }, { "name": "CULVERTCONDITION", "type": "esriFieldTypeInteger", "alias": "Culvert Condition", "domain": null }, { "name": "CULVERTREVIEW", "type": "esriFieldTypeInteger", "alias": "Culvert Review", "domain": { "type": "codedValue", "name": "culvertUsable_", "description": "Usability of the culvert (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULVERTREVIEWCOMMENTS", "type": "esriFieldTypeString", "alias": "Culvert Review Comments", "length": 255, "domain": null }, { "name": "CULVERTREPAIRREQUIRED", "type": "esriFieldTypeInteger", "alias": "Culvert Repair Required", "domain": { "type": "codedValue", "name": "performInspection", "description": "Completed inspection (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REMOVESEDIMENTS", "type": "esriFieldTypeInteger", "alias": "Remove Sediments", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REMOVESEDIMENTSCOMMENTS", "type": "esriFieldTypeString", "alias": "Remove Sediments Comments", "length": 255, "domain": null }, { "name": "REPAIR", "type": "esriFieldTypeInteger", "alias": "Repair", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIRCOMMENTS", "type": "esriFieldTypeString", "alias": "Repair Comments", "length": 255, "domain": null }, { "name": "OTHERAPPROACH", "type": "esriFieldTypeInteger", "alias": "Other Approach", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHERAPPROACHCOMMENTS", "type": "esriFieldTypeString", "alias": "Other Approach Comments", "length": 255, "domain": null }, { "name": "RIPRAPREQUIRED", "type": "esriFieldTypeInteger", "alias": "Riprap Required", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RIPRAPREQCOMMENTS", "type": "esriFieldTypeString", "alias": "Riprap Required Comments", "length": 255, "domain": null }, { "name": "OTHEREMBANKMENT", "type": "esriFieldTypeInteger", "alias": "Other Embankment", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHEREMBANKCOMMENTS", "type": "esriFieldTypeString", "alias": "Other Embankment Comments", "length": 255, "domain": null }, { "name": "DEBRISREPAIR", "type": "esriFieldTypeInteger", "alias": "Debris Repair", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEBRISREPAIRCOMMENTS", "type": "esriFieldTypeString", "alias": "Debris Repair Comments", "length": 255, "domain": null }, { "name": "REPAIRWINGWALL", "type": "esriFieldTypeInteger", "alias": "Repair Wingwall", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIRWINGWALLCOMMENTS", "type": "esriFieldTypeString", "alias": "Repair Wingwall Comments", "length": 255, "domain": null }, { "name": "OTHERIO", "type": "esriFieldTypeInteger", "alias": "Other IO", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHERIOCOMMENTS", "type": "esriFieldTypeString", "alias": "Other IO Comments", "length": 255, "domain": null }, { "name": "REPLACECULVERT", "type": "esriFieldTypeInteger", "alias": "Replace Culvert", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPLACECULVERTCOMMENTS", "type": "esriFieldTypeString", "alias": "Replace Culvert Comments", "length": 255, "domain": null }, { "name": "CLEARDEBRIS", "type": "esriFieldTypeInteger", "alias": "Clear Debris", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLEARDEBRISCOMMENTS", "type": "esriFieldTypeString", "alias": "Clear Debris Comments", "length": 255, "domain": null }, { "name": "OTHERREPAIR", "type": "esriFieldTypeInteger", "alias": "Other Repair", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHERREPAIRCOMMENTS", "type": "esriFieldTypeString", "alias": "Other Repair Comments", "length": 255, "domain": null }, { "name": "CULVERTREPAIRSDONE", "type": "esriFieldTypeDate", "alias": "Culvert Repairs Done", "length": 8, "domain": null }, { "name": "FISHPASSAGEDROP", "type": "esriFieldTypeInteger", "alias": "Fish Passage Drop", "domain": { "type": "codedValue", "name": "fishPassageDrop_", "description": "Acceptability of the drop to the stream at low water", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Fair", "code": 50 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OULETPOOL", "type": "esriFieldTypeInteger", "alias": "Oulet Pool", "domain": { "type": "codedValue", "name": "fishPassageScour_", "description": "Condition of the scour", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Fair", "code": 80 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTLETPOOLCOMMENTS", "type": "esriFieldTypeString", "alias": "Outlet Pool Comments", "length": 255, "domain": null }, { "name": "OUTLETDROP", "type": "esriFieldTypeInteger", "alias": "Outlet Drop", "domain": { "type": "codedValue", "name": "fishPassageDrop_", "description": "Acceptability of the drop to the stream at low water", "codedValues": [ { "name": "Excellent", "code": 100 }, { "name": "Fair", "code": 50 }, { "name": "Poor", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTLETDROPCOMMENTS", "type": "esriFieldTypeString", "alias": "Outlet Drop Comments", "length": 255, "domain": null }, { "name": "BARRIERS", "type": "esriFieldTypeInteger", "alias": "Barriers", "domain": { "type": "codedValue", "name": "fishPassageBarrier_", "description": "Amount of physical barriers present within the fish passage", "codedValues": [ { "name": "None", "code": 100 }, { "name": "Minor", "code": 80 }, { "name": "Moderate", "code": 50 }, { "name": "Severe", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BARRIERSCOMMENTS", "type": "esriFieldTypeString", "alias": "Barriers Comments", "length": 255, "domain": null }, { "name": "CONSTRICTION", "type": "esriFieldTypeInteger", "alias": "Constriction", "domain": { "type": "codedValue", "name": "fishPassageBarrier_", "description": "Amount of physical barriers present within the fish passage", "codedValues": [ { "name": "None", "code": 100 }, { "name": "Minor", "code": 80 }, { "name": "Moderate", "code": 50 }, { "name": "Severe", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONSTRICTIONCOMMENTS", "type": "esriFieldTypeString", "alias": "Constriction Comments", "length": 255, "domain": null }, { "name": "INLETGRADE", "type": "esriFieldTypeInteger", "alias": "Inlet Grade", "domain": { "type": "codedValue", "name": "fishPassageGrade_", "description": "Position of the structure relative to the stream bottom at the inlet", "codedValues": [ { "name": "At stream grade or embedded", "code": 100 }, { "name": "Inlet drop or perched", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INLETGRADECOMMENTS", "type": "esriFieldTypeString", "alias": "Inlet Grade Comments", "length": 255, "domain": null }, { "name": "WATERDEPTH", "type": "esriFieldTypeInteger", "alias": "Water Depth", "domain": { "type": "codedValue", "name": "fishPassageWater_", "description": "Comparison of water depth in the structure to natural water depth", "codedValues": [ { "name": "Significantly less", "code": 0 }, { "name": "Comparable or More", "code": 100 }, { "name": "Somewhat less", "code": 50 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATERDEPTHCOMMENTS", "type": "esriFieldTypeString", "alias": "Water Depth Comments", "length": 255, "domain": null }, { "name": "WATERVELOCITY", "type": "esriFieldTypeInteger", "alias": "Water Velocity", "domain": { "type": "codedValue", "name": "fishPassageWater_", "description": "Comparison of water depth in the structure to natural water depth", "codedValues": [ { "name": "Significantly less", "code": 0 }, { "name": "Comparable or More", "code": 100 }, { "name": "Somewhat less", "code": 50 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATERVELOCITYCOMMENTS", "type": "esriFieldTypeString", "alias": "Water Velocity Comments", "length": 255, "domain": null }, { "name": "FISHPASSAGECONDITION", "type": "esriFieldTypeInteger", "alias": "Fish Passage Condition", "domain": null }, { "name": "FISHREVIEW", "type": "esriFieldTypeInteger", "alias": "Fish Review", "domain": { "type": "codedValue", "name": "culvertUsable_", "description": "Usability of the culvert (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FISHREVIEWCOMMENTS", "type": "esriFieldTypeString", "alias": "Fish Review Comments", "length": 255, "domain": null }, { "name": "FISHREPAIRREQUIRED", "type": "esriFieldTypeInteger", "alias": "Fish Repair Required", "domain": { "type": "codedValue", "name": "repairsRequired", "description": "Required repairs (yes/no)", "codedValues": [ { "name": "Yes", "code": 2 }, { "name": "No", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REMOVESCOUR", "type": "esriFieldTypeInteger", "alias": "Remove Scour", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REMOVESCOURCOMMENTS", "type": "esriFieldTypeString", "alias": "Remove Scour Comments", "length": 255, "domain": null }, { "name": "PASSABLE", "type": "esriFieldTypeInteger", "alias": "Passable", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PASSABLECOMMENTS", "type": "esriFieldTypeString", "alias": "Passable Comments", "length": 255, "domain": null }, { "name": "REPLACEFISH", "type": "esriFieldTypeInteger", "alias": "Replace Fish", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPLACEFISHCOMMENTS", "type": "esriFieldTypeString", "alias": "Replace Fish Comments", "length": 255, "domain": null }, { "name": "OTHERFISH", "type": "esriFieldTypeInteger", "alias": "Other Fish", "domain": { "type": "codedValue", "name": "repairUrgency_", "description": "Timeframe for repairs", "codedValues": [ { "name": "Urgent", "code": 3 }, { "name": "1-5 years", "code": 2 }, { "name": "6-10 years", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTHERFISHCOMMENTS", "type": "esriFieldTypeString", "alias": "Other Fish Comments", "length": 255, "domain": null }, { "name": "FISHREPAIRDONE", "type": "esriFieldTypeDate", "alias": "Fish Repair Done", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "BEAVER", "type": "esriFieldTypeInteger", "alias": "Beaver", "domain": { "type": "codedValue", "name": "beaverActivity", "description": "Indicates presence of beaver activity around the structure", "codedValues": [ { "name": "No Activity", "code": 1 }, { "name": "Recent Activity", "code": 2 }, { "name": "On-going Activity", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROADCATEGORY", "type": "esriFieldTypeInteger", "alias": "roadCategory", "domain": { "type": "codedValue", "name": "roadCategories", "description": "", "codedValues": [ { "name": "Critical Resource Access (main road)", "code": 1 }, { "name": "Logging road", "code": 2 }, { "name": "Crown Reserve Access", "code": 3 }, { "name": "Fisheries Management Access", "code": 4 }, { "name": "Infrastructure (tower, dam, etc.) Access", "code": 5 }, { "name": "Other required access", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "G134116PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R838021_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_838021", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A1762_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "CFP_Picture", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 0, "name": "CFP_Location", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.71, "id": 2, "name": "SDEOWNER.CFP_Picture", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "PARENTGLOBALID", "type": "esriFieldTypeGUID", "alias": "PARENTGLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "G134113PARENTGLO", "fields": "PARENTGLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R838019_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_838019", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "CFP_Inspection", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PARENTGLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } } ] }