{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 85042.09448818862, "xmin": 1.3183481818569556E7, "ymax": 611603.0643044561, "xmax": 1.3643101182086617E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808398950131233, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2898, "zTolerance": 0.001, "wkid": 2898, "xyUnits": 3048, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "bridges_risk_final_clean", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "bridges_risk_final_clean", "allowTrueCurvesUpdates": false, "displayField": "strc_num", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "strc_num", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strc_num", "alias": "Structure Number", "type": "esriFieldTypeInteger" }, { "modelName": "change_in_days_with_3inches_of_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "change_in_days_with_3inches_of_", "alias": "Change in Days with Precip > 3in", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_changedaysprecip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_changedaysprecip", "alias": "Change in Precip Score", "type": "esriFieldTypeDouble" }, { "modelName": "impervious_per", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "impervious_per", "alias": "Impervious Surface Percentage in Basin", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_imperv", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_imperv", "alias": "Impervious Surface Percentage Score", "type": "esriFieldTypeDouble" }, { "modelName": "floodplain", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "floodplain", "length": 255, "alias": "FEMA Flood Zone", "type": "esriFieldTypeString" }, { "modelName": "perrank_floodprox", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_floodprox", "alias": "FEMA Flood Zone Score", "type": "esriFieldTypeDouble" }, { "modelName": "rastervalu", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rastervalu", "alias": "Flow Accumulation Value", "type": "esriFieldTypeDouble" }, { "modelName": "near_dist", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "near_dist", "alias": "Distance to Culvert (m)", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_ponding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_ponding", "alias": "Flow Accumulation and Ponding Score", "type": "esriFieldTypeDouble" }, { "modelName": "pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pastflooding", "length": 255, "alias": "Past Flooding Experience", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooding", "alias": "Past Flooding Experience Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_exposure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_exposure", "alias": "Exposure Score", "type": "esriFieldTypeDouble" }, { "modelName": "response1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "response1", "length": 8000, "alias": "Flood Survey Grouping", "type": "esriFieldTypeString" }, { "modelName": "comment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment", "length": 8000, "alias": "Flood Survey Comment", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooddamage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooddamage", "alias": "Past Flood Damage Score", "type": "esriFieldTypeDouble" }, { "modelName": "item_113", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "item_113", "length": 255, "alias": "Scour Criticality", "type": "esriFieldTypeString" }, { "modelName": "perrank_scourcriticality", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_scourcriticality", "alias": "Scour Criticality Score", "type": "esriFieldTypeDouble" }, { "modelName": "chanrating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chanrating", "length": 8000, "alias": "Channel Condition", "type": "esriFieldTypeString" }, { "modelName": "perrank_chanrating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_chanrating", "alias": "Channel Condition Score", "type": "esriFieldTypeDouble" }, { "modelName": "fracturecritical", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fracturecritical", "length": 8000, "alias": "Fracture Critical", "type": "esriFieldTypeString" }, { "modelName": "perrank_fracturecritical", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_fracturecritical", "alias": "Fracture Critical Score", "type": "esriFieldTypeDouble" }, { "modelName": "spans", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spans", "length": 8000, "alias": "Single or Multi-Span", "type": "esriFieldTypeString" }, { "modelName": "perrank_span", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_span", "alias": "Single or Multi-Span Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_sensitivity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_sensitivity", "alias": "Sensitivity Score", "type": "esriFieldTypeDouble" }, { "modelName": "spatialjoin_all_roads_aadt_pr_a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_aadt_pr_a", "alias": "Traffic Volume", "type": "esriFieldTypeInteger" }, { "modelName": "perrank_trafficvolume", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_trafficvolume", "alias": "Traffic Volume Score", "type": "esriFieldTypeDouble" }, { "modelName": "spatialjoin_all_roads_aadt_pr_c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_aadt_pr_c", "alias": "Truck Traffic Volume", "type": "esriFieldTypeInteger" }, { "modelName": "perrank_commercial", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_commercial", "alias": "Truck Traffic Volume Score", "type": "esriFieldTypeDouble" }, { "modelName": "funcclass", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funcclass", "length": 255, "alias": "Functional Classification", "type": "esriFieldTypeString" }, { "modelName": "perrank_nfc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_nfc", "alias": "Functional Classification Score", "type": "esriFieldTypeDouble" }, { "modelName": "detourlength", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "detourlength", "alias": "Detour Length", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_detourlength", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_detourlength", "alias": "Detour Length Score", "type": "esriFieldTypeDouble" }, { "modelName": "est_rplc_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "est_rplc_cost", "alias": "Replacement Cost", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_costofreplace", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_costofreplace", "alias": "Replacement Cost Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_criticality", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_criticality", "alias": "Criticality Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_vulnerability", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_vulnerability", "alias": "Vulnerability Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_risk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_risk", "alias": "Risk Score", "type": "esriFieldTypeDouble" }, { "modelName": "completed_flood_resilience_proj", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completed_flood_resilience_proj", "length": 255, "alias": "Completed Flood Resilience Project?", "type": "esriFieldTypeString" }, { "modelName": "owner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner", "length": 8000, "alias": "OWNER", "type": "esriFieldTypeString" }, { "modelName": "region", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region", "length": 8000, "alias": "REGION", "type": "esriFieldTypeString" }, { "modelName": "facility", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facility", "length": 8000, "alias": "FACILITY", "type": "esriFieldTypeString" }, { "modelName": "featint", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "featint", "length": 8000, "alias": "FEATINT", "type": "esriFieldTypeString" }, { "modelName": "risk_level", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "risk_level", "length": 25, "alias": "Risk_Level", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r241_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a185_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "change_in_days_with_3inches_of__index", "isUnique": false, "description": "change_in_days_with_3inches_of__Index", "fields": "change_in_days_with_3inches_of_", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4c83d73a79e0491f890d69b5752204ad", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "valueExpression": "// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\nvar per = $feature[\"PerRank_risk\"]\n\nwhen(\nper <= 4 && per >=3, '<4',\nper <=3.0001 && per >= 2, '2-3',\nper <=2.0001 && per >= 0, '1-2',\n'0%'\n)", "valueExpressionTitle": "Risk Score", "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75 }, "color": [ 255, 0, 0, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "<4", "value": "<4" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75 }, "color": [ 255, 170, 0, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "<3", "value": "2-3" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75 }, "color": [ 56, 168, 0, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "<2", "value": "1-2" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 83273.39927820861, "xmin": 1.3182955208333328E7, "ymax": 613260.2214566916, "xmax": 1.3638432893700793E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808398950131233, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2898, "zTolerance": 0.001, "wkid": 2898, "xyUnits": 3048, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "culverts_risk_final_clean", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "culverts_risk_final_clean", "allowTrueCurvesUpdates": false, "displayField": "pr", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "PR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pr", "length": 14, "alias": "Physical Road ID", "type": "esriFieldTypeString" }, { "modelName": "Route", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route", "length": 50, "alias": "Route", "type": "esriFieldTypeString" }, { "modelName": "Beneath", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "beneath", "length": 20, "alias": "Beneath", "type": "esriFieldTypeString" }, { "modelName": "change_in_days_with_3inches_of_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "change_in_days_with_3inches_of_", "alias": "Change in Days with Precip > 3in", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_changedaysprecip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_changedaysprecip", "alias": "Change in Precip Score", "type": "esriFieldTypeDouble" }, { "modelName": "impervious_per", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "impervious_per", "alias": "Impervious Surface Percentage in Basin", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_imperv", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_imperv", "alias": "Impervious Surface Percentage Score", "type": "esriFieldTypeDouble" }, { "modelName": "floodplain", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "floodplain", "length": 255, "alias": "FEMA Flood Zone", "type": "esriFieldTypeString" }, { "modelName": "perrank_floodprox", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_floodprox", "alias": "FEMA Flood Zone Score", "type": "esriFieldTypeDouble" }, { "modelName": "max_rastervalu", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "max_rastervalu", "alias": "Flow Accumulation Value", "type": "esriFieldTypeDouble" }, { "modelName": "near_dist", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "near_dist", "alias": "Distance to Culvert (m)", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_ponding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_ponding", "alias": "Flow Accumulation and Ponding Score", "type": "esriFieldTypeDouble" }, { "modelName": "pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pastflooding", "length": 255, "alias": "Past Flooding Experience", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooding", "alias": "Past Flooding Experience Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_exposure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_exposure", "alias": "Exposure Score", "type": "esriFieldTypeDouble" }, { "modelName": "Response1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "response1", "length": 8000, "alias": "Flood Survey Grouping", "type": "esriFieldTypeString" }, { "modelName": "Comment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment", "length": 8000, "alias": "Flood Survey Comment", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooddamage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooddamage", "alias": "Past Flood Damage Score", "type": "esriFieldTypeDouble" }, { "modelName": "ConditionIndex", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditionindex", "alias": "Condition Index", "type": "esriFieldTypeSmallInteger" }, { "modelName": "perrank_conditionindex", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_conditionindex", "alias": "Condition Index Score", "type": "esriFieldTypeDouble" }, { "modelName": "CulvertInstallationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "culvertinstallationdate", "length": 29, "alias": "Culvert Installation Date", "type": "esriFieldTypeDate" }, { "modelName": "perrank_culvertage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_culvertage", "alias": "Culvert Age Score", "type": "esriFieldTypeDouble" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Inspection Comments", "type": "esriFieldTypeString" }, { "modelName": "perrank_inspectioncomment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_inspectioncomment", "alias": "Inspection Comments Score", "type": "esriFieldTypeDouble" }, { "modelName": "WaterDepth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterdepth", "alias": "Water Depth", "type": "esriFieldTypeDouble" }, { "modelName": "CulvertHeight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "culvertheight", "alias": "Culvert Height", "type": "esriFieldTypeSmallInteger" }, { "modelName": "perrank_culvertproportion", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_culvertproportion", "alias": "Proportion of Height Filled with Water Score", "type": "esriFieldTypeDouble" }, { "modelName": "StreamSubstrate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streamsubstrate", "length": 15, "alias": "Stream Substrate", "type": "esriFieldTypeString" }, { "modelName": "perrank_streamsubstrate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_streamsubstrate", "alias": "Stream Substrate Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_sensitivity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_sensitivity", "alias": "Sensitivity Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_criticality", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_criticality", "alias": "Criticality Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_vulnerability", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_vulnerability", "alias": "Vulnerability Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_risk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_risk", "alias": "Risk Score", "type": "esriFieldTypeDouble" }, { "modelName": "completed_flood_resilience_proj", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completed_flood_resilience_proj", "length": 255, "alias": "Completed Flood Resilience Project?", "type": "esriFieldTypeString" }, { "modelName": "risk_level", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "risk_level", "length": 25, "alias": "Risk_Level", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "

The Culvert Guide book detailing the collection efforts can be found on the TAMS Sharepoint page:<\/SPAN><\/P>

https://stateofmichigan.sharepoint.com/sites/mdot/Organizational/field_services/ops/maintenance/SitePages/TAMS.aspx<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r242_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a186_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4c83d73a79e0491f890d69b5752204ad", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "valueExpression": "var per = $feature[\"PerRank_risk\"]\n\nwhen(\nper <= 4 && per >=3, '<4',\nper <=3.0001 && per >= 2, '2-3',\nper <=2.0001 && per >= 0, '1-2',\n'0%'\n)", "valueExpressionTitle": "Risk Score", "uniqueValueInfos": [ { "symbol": { "color": [ 255, 0, 0, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "<4", "value": "<4" }, { "symbol": { "color": [ 255, 170, 0, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "<3", "value": "2-3" }, { "symbol": { "color": [ 56, 168, 0, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "<2", "value": "1-2" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "Contacts/Business Owners:\n \nJustin Droste\nBureau of Field Services\ndrostej@michigan.gov\n \nDan Belcher\nBureau of Development\nbelcherd@michigan.gov \n \nCory Johnson\nBureau of Transportation Planning\njohnsonC45@michigan.gov", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 164872.7687007934, "xmin": 1.3245730507217854E7, "ymax": 412894.2001312375, "xmax": 1.351452542158793E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808398950131233, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2898, "zTolerance": 0.001, "wkid": 2898, "xyUnits": 3048, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "pumpstation_risk_final_clean", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "pumpstation_risk_final_clean", "allowTrueCurvesUpdates": false, "displayField": "pumpid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "PumpID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pumpid", "length": 10, "alias": "Pump ID", "type": "esriFieldTypeString" }, { "modelName": "Region", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region", "length": 50, "alias": "Region", "type": "esriFieldTypeString" }, { "modelName": "Route", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route", "length": 10, "alias": "Route", "type": "esriFieldTypeString" }, { "modelName": "ServiceAddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "serviceaddress", "length": 100, "alias": "Service Address", "type": "esriFieldTypeString" }, { "modelName": "CrossRoad", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crossroad", "length": 100, "alias": "Cross Road", "type": "esriFieldTypeString" }, { "modelName": "PowerCompany", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "powercompany", "length": 5, "alias": "Power Company", "type": "esriFieldTypeString" }, { "modelName": "AccountNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accountnumber", "length": 50, "alias": "Account Number", "type": "esriFieldTypeString" }, { "modelName": "MeterNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meternumber", "length": 50, "alias": "Meter Number", "type": "esriFieldTypeString" }, { "modelName": "change_in_days_with_3inches_of_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "change_in_days_with_3inches_of_", "alias": "Change in Days with Precip > 3in", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_changedaysprecip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_changedaysprecip", "alias": "Change in Precip Score", "type": "esriFieldTypeDouble" }, { "modelName": "impervious_per", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "impervious_per", "alias": "Impervious Surface Percentage in Basin", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_imperv", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_imperv", "alias": "Impervious Surface Percentage Score", "type": "esriFieldTypeDouble" }, { "modelName": "floodplain", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "floodplain", "length": 255, "alias": "FEMA Flood Zone", "type": "esriFieldTypeString" }, { "modelName": "perrank_floodprox", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_floodprox", "alias": "FEMA Flood Zone Score", "type": "esriFieldTypeDouble" }, { "modelName": "rastervalu", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rastervalu", "alias": "Flow Accumulation Value", "type": "esriFieldTypeDouble" }, { "modelName": "near_dist", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "near_dist", "alias": "Distance to Culvert (m)", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_ponding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_ponding", "alias": "Flow Accumulation and Ponding Score", "type": "esriFieldTypeDouble" }, { "modelName": "pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pastflooding", "length": 255, "alias": "Past Flooding Experience", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooding", "alias": "Past Flooding Experience Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_exposure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_exposure", "alias": "Exposure Score", "type": "esriFieldTypeDouble" }, { "modelName": "Response1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "response1", "length": 8000, "alias": "Flood Survey Grouping", "type": "esriFieldTypeString" }, { "modelName": "Comment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment", "length": 8000, "alias": "Flood Survey Comment", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooddamage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooddamage", "alias": "Past Flood Damage Score", "type": "esriFieldTypeDouble" }, { "modelName": "Rating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rating", "alias": "Rating", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_pumprating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pumprating", "alias": "Rating Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_sensitivity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_sensitivity", "alias": "Sensitivity Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_criticality", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_criticality", "alias": "Criticality Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_vulnerability", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_vulnerability", "alias": "Vulnerability Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_risk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_risk", "alias": "Risk Score", "type": "esriFieldTypeDouble" }, { "modelName": "completed_flood_resilience_proj", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completed_flood_resilience_proj", "length": 255, "alias": "Completed Flood Resilience Project?", "type": "esriFieldTypeString" }, { "modelName": "risk_level", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "risk_level", "length": 25, "alias": "Risk_Level", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r243_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a187_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4c83d73a79e0491f890d69b5752204ad", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "valueExpression": "var per = $feature[\"PerRank_risk\"]\n\nwhen(\nper <= 4 && per >=3, '<4',\nper <=3.0001 && per >= 2, '<3',\nper <=2.0001 && per >= 0, '<2',\n'0%'\n)", "valueExpressionTitle": "Risk Score", "uniqueValueInfos": [ { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAkElEQVQ4ja3Uyw2EMAxF0YuUJqaOoQ6apQ2mjVAGbBKEJ7bzgbeyLOvI3jjwUkJt4IAvsE8Qh6GErKmePcyEbsgntTYPUyEFIdUmVkAGUsUEVEFc7IIaERMLA4iK5Y32DuAeedoE8YAZ2Dq2+gGLOG0AE4iAOrACKaAGTEVUyMFMxIQULHqIC/1hPHojLUDOCdISSNiSxki8AAAAAElFTkSuQmCC", "yoffset": 0, "width": 13, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "286e28852d3c9c54fa346422b9e5eacc", "height": 13 }, "label": "<4", "value": "<4" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAoklEQVQ4ja3UwQ2DMAyF4R8lSzAHzNE7EyJx7Rp0jTBFlB5oqawkNon6Tj5Yn54v9vwp3lpIGxORY1gI3VDamIAnDtLKrGFV6EJgBMCxa1gRypAzo4ZlUAUxMQEZiIpd0E2kivkOpIidjSIHroH4RZ42LIS0MuPYG1q9iDzEaR2YQATUgGVIBt3AikgRUrAqUoUKWNAQFRLYZ9Z2zX9kAd+8AQmAZ1sww++7AAAAAElFTkSuQmCC", "yoffset": 0, "width": 13, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "e3cabf304c2054efa6c0501818e5cdab", "height": 13 }, "label": "<3", "value": "<3" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBUlEQVQ4ja3SIQoCQRQG4F92PMFcwGj1Bh7Ats36EMvMBUwTxAu4ZcMDkxewWdQkCDaTRcEomxbUIhhkZVd3Zwb1j4/HB4//CfwxwmcpiiKplEp+xtQkDFdBPDKstaHx/GtMTcLwUN/ESXCSt1o6Nay7NrASy0MAcBZHucXMCpZi71AWF/iBVUE+YAFzQS7whflCNlAAzz9aBfHIF8qDOywMM6+JKBUAoJRKDGt9q6XTszh6g/Le2Dev7QH1KC2caWg8N6y7W8y8QHlv7FuXTn/Yi5bZrFCAL1gGfWA+YBVUitlAG1SJlYEuyIrlwR0WpnltD2yQE8tAZl5n9f+EAQCRGwKAB5g/1c8LRRJ5AAAAAElFTkSuQmCC", "yoffset": 0, "width": 14, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "258c4706c90c46816283349ddcd11899", "height": 14 }, "label": "<2", "value": "<2" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 82330.84547244012, "xmin": 1.3181831868766397E7, "ymax": 613669.0259186327, "xmax": 1.3644222299868762E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808398950131233, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2898, "zTolerance": 0.001, "wkid": 2898, "xyUnits": 3048, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "roads_risk_final_clean", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": {} } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "roads_risk_final_clean", "allowTrueCurvesUpdates": false, "displayField": "all_roads_clip_12345_rdname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "OBJECTID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_objectid", "alias": "Road Segment ID", "type": "esriFieldTypeInteger" }, { "modelName": "PR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_pr", "alias": "Physical Road ID", "type": "esriFieldTypeInteger" }, { "modelName": "LRS_LINK", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_lrs_link", "length": 80, "alias": "Linear Referencing System Link ID (LRS Link)", "type": "esriFieldTypeString" }, { "modelName": "FETYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_fetype", "length": 80, "alias": "Feature Type", "type": "esriFieldTypeString" }, { "modelName": "RDNAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_rdname", "length": 80, "alias": "Road Name", "type": "esriFieldTypeString" }, { "modelName": "BMP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_bmp", "alias": "Beginning Mile Point", "type": "esriFieldTypeDouble" }, { "modelName": "EMP", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_emp", "alias": "Ending Mile Point", "type": "esriFieldTypeDouble" }, { "modelName": "COUNTYR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_countyr", "alias": "County Number", "type": "esriFieldTypeInteger" }, { "modelName": "spatialjoin_all_roads_pavement_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_pavement_", "length": 254, "alias": "From Description", "type": "esriFieldTypeString" }, { "modelName": "change_in_days_with_3inches_of_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "change_in_days_with_3inches_of_", "alias": "Change in Days with Precip > 3in", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_changedaysprecip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_changedaysprecip", "alias": "Change in Precip Score", "type": "esriFieldTypeDouble" }, { "modelName": "impervious_per", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "impervious_per", "alias": "Impervious Surface Percentage in Basin", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_imperv", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_imperv", "alias": "Impervious Surface Percentage Score", "type": "esriFieldTypeDouble" }, { "modelName": "floodplain", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "floodplain", "length": 255, "alias": "FEMA Flood Zone", "type": "esriFieldTypeString" }, { "modelName": "perrank_floodprox", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_floodprox", "alias": "FEMA Flood Zone Score", "type": "esriFieldTypeDouble" }, { "modelName": "max_rastervalu", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "max_rastervalu", "alias": "Flow Accumulation Value", "type": "esriFieldTypeDouble" }, { "modelName": "near_dist", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "near_dist", "alias": "Distance to Culvert (m)", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_ponding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_ponding", "alias": "Flow Accumulation and Ponding Score", "type": "esriFieldTypeDouble" }, { "modelName": "pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pastflooding", "length": 255, "alias": "Past Flooding Experience", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooding", "alias": "Past Flooding Experience Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_exposure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_exposure", "alias": "Exposure Score", "type": "esriFieldTypeDouble" }, { "modelName": "Response1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "response1", "length": 8000, "alias": "Flood Survey Grouping", "type": "esriFieldTypeString" }, { "modelName": "Comment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment", "length": 8000, "alias": "Flood Survey Comment", "type": "esriFieldTypeString" }, { "modelName": "perrank_pastflooddamage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pastflooddamage", "alias": "Past Flood Damage Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_pavementcondition", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_pavementcondition", "alias": "Pavement Condition Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_sensitivity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_sensitivity", "alias": "Sensitivity Score", "type": "esriFieldTypeDouble" }, { "modelName": "spatialjoin_all_roads_aadt_pr_a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_aadt_pr_a", "alias": "Traffic Volume", "type": "esriFieldTypeInteger" }, { "modelName": "perrank_trafficvolume", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_trafficvolume", "alias": "Traffic Volume Score", "type": "esriFieldTypeDouble" }, { "modelName": "spatialjoin_all_roads_aadt_pr_c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_aadt_pr_c", "alias": "Truck Traffic Volume", "type": "esriFieldTypeInteger" }, { "modelName": "perrank_commercial", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_commercial", "alias": "Truck Traffic Volume Score", "type": "esriFieldTypeDouble" }, { "modelName": "NFC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "all_roads_clip_12345_nfc", "alias": "Functional Classification", "type": "esriFieldTypeInteger" }, { "modelName": "perrank_nfc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_nfc", "alias": "Functional Classification Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_criticality", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_criticality", "alias": "Criticality Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_vulnerability", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_vulnerability", "alias": "Vulnerability Score", "type": "esriFieldTypeDouble" }, { "modelName": "perrank_risk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "perrank_risk", "alias": "Risk Score", "type": "esriFieldTypeDouble" }, { "modelName": "TampNum_New", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tampnum_new", "alias": "TAMP", "type": "esriFieldTypeInteger" }, { "modelName": "ramp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ramp", "length": 255, "alias": "Ramp?", "type": "esriFieldTypeString" }, { "modelName": "completed_flood_resilience_proj", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completed_flood_resilience_proj", "length": 255, "alias": "Completed Flood Resilience Project?", "type": "esriFieldTypeString" }, { "modelName": "risk_level", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "risk_level", "length": 25, "alias": "Risk_Level", "type": "esriFieldTypeString" }, { "modelName": "spatialjoin_all_roads_pavement1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_pavement1", "length": 254, "alias": "To Description", "type": "esriFieldTypeString" }, { "modelName": "spatialjoin_all_roads_pavemen_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialjoin_all_roads_pavemen_1", "length": 512, "alias": "Pavement Condition (PASER Rating)", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r244_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a188_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "all_roads_clip_12345_objectid_index", "isUnique": false, "description": "all_roads_clip_12345_objectid_Index", "fields": "all_roads_clip_12345_objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4c83d73a79e0491f890d69b5752204ad", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "valueExpression": "// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\nvar per = $feature[\"PerRank_risk\"]\n\nwhen(\nper <= 4 && per >=3, '<4',\nper <=3.0001 && per >= 2, '2-3',\nper <=2.0001 && per >= 0, '1-2',\n'0%'\n)", "valueExpressionTitle": "Risk Score", "uniqueValueInfos": [ { "symbol": { "color": [ 255, 0, 0, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "<4", "value": "<4" }, { "symbol": { "color": [ 255, 170, 0, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "<3", "value": "2-3" }, { "symbol": { "color": [ 56, 168, 0, 255 ], "width": 1.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "<2", "value": "1-2" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true } ] }