{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "POSM Observations", "type": "Feature Layer", "description": "POSM Observations", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",GEOGCS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667],PARAMETER[\"False_Northing\",100004.5319459167],PARAMETER[\"Central_Meridian\",-96.7],PARAMETER[\"Scale_Factor\",1.000045317862],PARAMETER[\"Latitude_Of_Origin\",46.63],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Meter\",1.0]]", "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17949400, "falseY": -49666600, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 10000, "falseM": 0, "mUnits": 10000 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "fef2b64dbb25bf90d622132c816df253", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAgAAAAOCAYAAAASVl2WAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA/UlEQVQYlYWQsUsCcRzFP8LvhgO9ocPBpmvwpoYb49ZWK6jJ7SBwi4Jo6M9o6AJBEQebXGqoMQhCcDFoEoRfiGnR5WFwoTU4yMmlF73tCx/e+74n+Edi4bYAH5BxgKGt4wKMnrCXgJTJnuFgJQTq4xEOUIkCxsoGhUwOVdGgV+f0/Z47QAqA5Br7q9uYijajs4eYgeQ46HIgACu9iaPPU0G3IbNFvuNSEoD/E6D+0dIXgHy9oeztchK6eA/Qv+Zy/sNkiPtcZUe3Mb9H8HJFO+hSiraQXoOzwS3nIsnXR4Mi0Pq1w/iNWueCgpJi/NmmHrekP2zihI5xAKFtVFMz7kmvANNXOgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 6, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.0987373556882275E7, "ymin": 5834788.948240993, "xmax": -1.0765076681411108E7, "ymax": 5933690.019653155, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayFieldExpressionInfo": { "expression": "\"POSM: \" + $feature.FaultName", "title": "Custom" }, "displayField": "FaultName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "DataID", "type": "esriFieldTypeOID", "alias": "DataID", "domain": null }, { "name": "FaultName", "type": "esriFieldTypeString", "alias": "FaultName", "length": 100, "domain": null }, { "name": "Distance", "type": "esriFieldTypeDouble", "alias": "Distance", "domain": null }, { "name": "TimeStamp", "type": "esriFieldTypeDate", "alias": "TimeStamp", "length": 8, "domain": null }, { "name": "PictureLocation", "type": "esriFieldTypeString", "alias": "PictureLocation", "length": 100, "domain": null }, { "name": "VideoLocation", "type": "esriFieldTypeString", "alias": "VideoLocation", "length": 100, "domain": null }, { "name": "FaultStartPosition", "type": "esriFieldTypeString", "alias": "FaultStartPosition", "length": 50, "domain": null }, { "name": "FaultEndPosition", "type": "esriFieldTypeString", "alias": "FaultEndPosition", "length": 50, "domain": null }, { "name": "Value_1st_Dimension", "type": "esriFieldTypeString", "alias": "Value_1st_Dimension", "length": 50, "domain": null }, { "name": "Value_2nd_Dimension", "type": "esriFieldTypeString", "alias": "Value_2nd_Dimension", "length": 50, "domain": null }, { "name": "Value_Percent", "type": "esriFieldTypeString", "alias": "Value_Percent", "length": 50, "domain": null }, { "name": "Joint", "type": "esriFieldTypeSmallInteger", "alias": "Joint", "domain": null }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null }, { "name": "MediaFolder", "type": "esriFieldTypeString", "alias": "MediaFolder", "length": 100, "domain": null }, { "name": "WebPathtoReportIndex", "type": "esriFieldTypeString", "alias": "WebPathtoReportIndex", "length": 255, "domain": null }, { "name": "IsLatestInspection", "type": "esriFieldTypeSmallInteger", "alias": "IsLatestInspection", "domain": null }, { "name": "HTML_Pic_Loc", "type": "esriFieldTypeString", "alias": "HTML_Pic_Loc", "length": 232, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 100, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 24, "name": "Last Inspected Manhole", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",GEOGCS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667],PARAMETER[\"False_Northing\",100004.5319459167],PARAMETER[\"Central_Meridian\",-96.7],PARAMETER[\"Scale_Factor\",1.000045317862],PARAMETER[\"Latitude_Of_Origin\",46.63],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Meter\",1.0]]", "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17949400, "falseY": -49666600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 30000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "//Inspected within last year\nif (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') <= 1) {\n return \"Inspected in Last Year\" }\n//Inspected within 2 years\nelse if (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') > 1 &&\nDateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') < 2) {\n return \"Inspected in Last 2 Years\" }\n//Inspected Last 3 Years \nelse if (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') > 2 &&\nDateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') < 3) {\n return \"Inspected in Last 3 Years\" }\n//not cleaned in last 3 years\nelse if (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') >= 3) {\n return \"Not inspected in Last 3 Years\" }\n//areas which do not satisfy any of the given conditions belong in the fourth group\nelse {\n return \"None of these conditions\" }", "valueExpressionTitle": "Last Inspected", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "10dc8cf2a476cf7b2cf25ac841cfef5b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQUlEQVQ4jaWToW7DMBRFDygLzxTD8CIHlHfQafl4s89w8hlNeXnnfkTBjMbDmkrm5QOOFadLtUl7UqTIue+8ex17wT9r8WRdDo8AMuAMWKD/C6AGNHkJSQaJgM5UOAvQDN+fAgypVKxqyNW4utLgLJw2mnuvgGIOUJNKxdvnfKhUwu4Kx0LibB2cBIAENK/7aZO37ZtDbQ0chAZaoB8BeTkVfmygM/59WcF6gCcZ5CV0RgFtAAiSbDo5NAN8tR4SBnitiCNkJGI++1x5bRYDznSmYqXHzMvKTwZ+xPPubjHA4qy3HoTrvYcEYBzPb66JAT3QcNpodtdRHDeGujTg/4CNAQA1915xLCRbw2RTw+RLA52xwHtYfjyJBc7WHIQmlfAiw1EOttu4eQ7gnUCLswpnw2W6DZnto/jZbeyHab/WNxAvZj7jLnyTAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Inspected in Last Year", "label": "Inspected in Last Year" }, { "symbol": { "type": "esriPMS", "url": "170088c235cc245e9c6bd55d846afc18", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQ0lEQVQ4jaWTwW2DMBSGv0NG4IIXoHdzYwUn7EAkugE9Gq7ZIEjpDpEzQnKrB/AAIZcM0YNxMWlQKvVJSNbz/773fmOv+GesFvJy/ASQAifAAsNfAC2gWReQJiASMOca6wC6cX8RYJCZot2CKqasrsA62DSa4a6A/BmgRWaKr88FUxlcj5BXEuvaMEkASECz/5gX+bF98c+MOxClBnpgmADrYi7cNGAufl2XsG/8Ok1gXYC5KKAPAEGazDuHYoD+6CGhgdeK2EKKiACvwmvTGHDCnGt0NXmuS98Z+GXPnAFuMcBinR89CPeNhwRgbM8frokBA9CxaTTX4ySOC0N0B/B/wMYAgJbhrsgridkxO9TQuTuAuVjgPaQfb2KOdS2i1MgM5Fu4ymHsPi5+BvCTQI91CuvCY7qNnu2jeOk1DmO3l/ENmWdmo4OQqpQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Inspected in Last 2 Years", "label": "Inspected in Last 2 Years" }, { "symbol": { "type": "esriPMS", "url": "c1f11ed9bfea237473c945feb9187b7e", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABOklEQVQ4jaWTsZGDMBBFX+AGCFFIC6IEhzIZLeAS7EyQnUuAFhzK4ZVw24Iy49AtXCDJFh4zvpnbGWaY5e/bv4u04Z+xWcnr+CigBC6AAPNfAD1gdxrKAlQBTujEAzDE76sApytM34LRz6RtQTw0J+x8xwD1O0CvK8zP18pMFVxHqI9o8fTJSQJowI7dsijaRleZxQOoPRaYgPkB2OmlsDmBk/DebSHBywJ2GpxggCkBVFksO6digOk7QFKDqFX5CKXKAJ8iassccHFCZ9vnzN02dIZgebGH4O6WA0R8sJ6EYxcgCZiPF5frcsAMDM0Jex2f4rwwxXAGwh+QHADQz3dMfUS7w2NRi87DGZwgwD7lX09iLZ5e7bG6Cg7iUU62p7z4HQDCCZvEY8Q/LtMtziyv4rXbOMduH+MXFi5mhKQQYekAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Inspected in Last 3 Years", "label": "Inspected in Last 3 Years" }, { "symbol": { "type": "esriPMS", "url": "733451bd36c07db047fc0b9d14e6f5ec", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABAElEQVQ4jaWT0a3DIAxFz0eXCGuQMUjGSMeAjFHWoGM8xmi6Rj+wUxM1VaVnKYqwfY9tZC780y4nfi+fAwbgDlRg+wWQgDiJ0gEFltpiq8RPAcVDSEAwzijlZ4hbC42fAMlD+Psy06MpfW1dJAvwQLwdRNUE9xbbWBHIwLYDpkPiLMkAC6DwAZhaLABZAW44VC7mnAWiBSTX2REGx+/mDEcB9wJL1HmkYpbzcTzp7mkBtUrrmngTCPRizVOOAjZgnSE+TLIVqq3tl5XT7cEGYQRf2C+qq7y2shW4qv+4iWOF5CDax1DebWcr/gSAtmG5Qqjvx/TsOd8B0O4kn8Q6ewGNsUK4a6HzuwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Not inspected in Last 3 Years", "label": "Not inspected in Last 3 Years" }, { "symbol": { "type": "esriPMS", "url": "45826085d9155b93d49ce33d2b7bae02", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABUElEQVQ4jaWTsY3DMAxFX5FWA4QLaIBoAfWGF3CfywKu7dRewEivCZLeC9gDaAFmAC9wRSRDCRLkgCPghvp85JepHf+M3Yf8IX0C7IEbsAD6F0APdNZajDEYY4gxHlUV4JzOPwKuIlJ577HWbknvPapKCKFb17UC3DtALyLV6XR660lEaNuWcRwPqtrnSTLgAHR1XT8VpbERkS3XNA3DMHTABdANYK19EoYQiDEC4Jwjw40xWGuJMVbAJQPEGPPUORcDzPOMc25rkLRSWtiXgG+RtPsScIsxHr33m2fnHPM8A/BqL013LwGLqqKqm7Cua5xzG7C0ly73WgIUOIcQurZtN3FZmGOaJnj8gaUEAPTrulbjOB6apuH1TlSVaZqIMS7AT86/bqJT1X4Yhk5EEJG8ynnsS1n8DgCPDbuoaqWq+THdk+flVfzpNWrq9jV+AV63iV3gVlOEAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "None of these conditions", "label": "None of these conditions" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 25, 28, 255 ], "toColor": [ 227, 25, 28, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 55, 126, 184, 255 ], "toColor": [ 55, 126, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 77, 176, 74, 255 ], "toColor": [ 77, 176, 74, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 152, 78, 163, 255 ], "toColor": [ 152, 78, 163, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 128, 0, 255 ], "toColor": [ 255, 128, 0, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.0775404680980526E7, "ymin": 5912351.886509904, "xmax": -1.0764381765277565E7, "ymax": 5933689.600581891, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSET_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "Asset Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_AssetManholeType", "description": "Asset Manhole Type", "codedValues": [ { "name": "Diversion Manhole", "code": "Diversion Manhole" }, { "name": "Drop Manhole", "code": "Drop Manhole" }, { "name": "Drop Trap", "code": "Drop Trap" }, { "name": "Flush Manhole", "code": "Flush Manhole" }, { "name": "Junction Manhole", "code": "Junction Manhole" }, { "name": "Offset Manhole", "code": "Offset Manhole" }, { "name": "Shallow Manhole", "code": "Shallow Manhole" }, { "name": "Siphon Manhole", "code": "Siphon Manhole" }, { "name": "Manhole", "code": "Manhole" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVER_TYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_AssetCoverType", "description": "Asset Cover Type", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Grated", "code": "Grated" }, { "name": "Solid", "code": "Solid" }, { "name": "Vented/Slotted", "code": "Vented/Slotted" }, { "name": "Gasketed", "code": "Gasketed" }, { "name": "Bolted", "code": "Bolted" }, { "name": "Inner Cover", "code": "Inner Cover" }, { "name": "Locking", "code": "Locking" }, { "name": "Combination Grate", "code": "Combination Grate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVER_SHAPE", "type": "esriFieldTypeString", "alias": "Cover Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_AssetCoverShape", "description": "Asset Cover Shape", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Round", "code": "Round" }, { "name": "Square", "code": "Square" }, { "name": "Rectangle", "code": "Rectangle" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "WS2_AssetMaterial", "description": "Storm and Sanitary Manhole Material", "codedValues": [ { "name": "Precast", "code": "Precast" }, { "name": "Brick", "code": "Brick" }, { "name": "Block", "code": "Block" }, { "name": "Concrete Rings", "code": "Concrete Rings" }, { "name": "Other", "code": "Other" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "PVC", "code": "PVC" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CASTING_SIZE", "type": "esriFieldTypeString", "alias": "Casting Size", "length": 50, "domain": null }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "Project", "length": 36, "domain": null }, { "name": "PROJECT2", "type": "esriFieldTypeString", "alias": "Project 2", "length": 36, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 60, "domain": null }, { "name": "SECTION", "type": "esriFieldTypeString", "alias": "Section", "length": 8, "domain": null }, { "name": "SERVICE_AREA", "type": "esriFieldTypeString", "alias": "Service Area", "length": 100, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Ownership", "length": 24, "domain": { "type": "codedValue", "name": "WS2_Owner", "description": "Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "State", "code": "State" }, { "name": "Township", "code": "Township" }, { "name": "Private", "code": "Private" }, { "name": "MnDOT", "code": "MnDOT" }, { "name": "Concordia", "code": "Concordia" }, { "name": "MSUM", "code": "MSUM" }, { "name": "Watershed District", "code": "Watershed District" }, { "name": "Other", "code": "Other" }, { "name": "Moorhead Public Service", "code": "Moorhead Public Service" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Dilworth", "code": "Dilworth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 120, "domain": null }, { "name": "RIM_ELEVATION", "type": "esriFieldTypeDouble", "alias": "RIM Elevation", "domain": null }, { "name": "N_INVERT", "type": "esriFieldTypeDouble", "alias": "N Invert", "domain": null }, { "name": "NE_INVERT", "type": "esriFieldTypeDouble", "alias": "NE Invert", "domain": null }, { "name": "E_INVERT", "type": "esriFieldTypeDouble", "alias": "E Invert", "domain": null }, { "name": "SE_INVERT", "type": "esriFieldTypeDouble", "alias": "SE Invert", "domain": null }, { "name": "S_INVERT", "type": "esriFieldTypeDouble", "alias": "S Invert", "domain": null }, { "name": "SW_INVERT", "type": "esriFieldTypeDouble", "alias": "SW Invert", "domain": null }, { "name": "W_INVERT", "type": "esriFieldTypeDouble", "alias": "W Invert", "domain": null }, { "name": "NW_INVERT", "type": "esriFieldTypeDouble", "alias": "NW Invert", "domain": null }, { "name": "RAINSTOPPER", "type": "esriFieldTypeString", "alias": "Rain Stopper", "length": 8, "domain": { "type": "codedValue", "name": "WS2_YesNo", "description": "Yes or No Text-String Domain", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Hold", "code": "Hol" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ANNO", "type": "esriFieldTypeString", "alias": "Annotation", "length": 50, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "INSPECT_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Year", "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "REHAB_REMARKS", "type": "esriFieldTypeString", "alias": "Rehab Remarks", "length": 120, "domain": null }, { "name": "REHAB_DATE", "type": "esriFieldTypeDate", "alias": "Rehab Date", "length": 8, "domain": null }, { "name": "REHAB_YEAR_1", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 1", "domain": null }, { "name": "REHAB_YEAR_2", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 2", "domain": null }, { "name": "REHAB_YEAR_3", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 3", "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 12, "domain": { "type": "codedValue", "name": "WS2_DATUM", "description": "Vertical Datum", "codedValues": [ { "name": "NAVD 1988", "code": "88" }, { "name": "NGVD 1929", "code": "29" }, { "name": "LiDAR Derived", "code": "44" }, { "name": "Mixed", "code": "46" }, { "name": "Unknown", "code": "48" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANS_PATH", "type": "esriFieldTypeString", "alias": "Path to Plans", "length": 500, "domain": null }, { "name": "VIDEO_ID", "type": "esriFieldTypeString", "alias": "Video ID", "length": 120, "domain": null }, { "name": "IMAGE_ID", "type": "esriFieldTypeString", "alias": "Image ID", "length": 120, "domain": null }, { "name": "LIFECYCLE_STATUS", "type": "esriFieldTypeSmallInteger", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "WS2_LifecycleStatus", "description": "Life Cycle Status - more options", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Proposed", "code": 1 }, { "name": "In Service", "code": 8 }, { "name": "Abandoned", "code": 32 }, { "name": "Retired", "code": 64 }, { "name": "Removed", "code": 128 }, { "name": "Out of Service", "code": 256 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "RETIRE_DATE", "type": "esriFieldTypeDate", "alias": "Retire Date", "length": 8, "domain": null }, { "name": "LIFE_EXPECTANCY", "type": "esriFieldTypeInteger", "alias": "Life Expectancy", "domain": null }, { "name": "AGE", "type": "esriFieldTypeInteger", "alias": "Age", "domain": null }, { "name": "SERVICE_LIFE", "type": "esriFieldTypeInteger", "alias": "Service Life", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "REACH", "type": "esriFieldTypeString", "alias": "Reach", "length": 50, "domain": null }, { "name": "CLEAN_DATE", "type": "esriFieldTypeDate", "alias": "Clean Date", "length": 8, "domain": null }, { "name": "MAINTINTERVAL", "type": "esriFieldTypeString", "alias": "Maintenance Interval", "length": 25, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R974_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_974", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_974", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S914_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 23, "name": "Last TV'd Sanitary Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",GEOGCS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667],PARAMETER[\"False_Northing\",100004.5319459167],PARAMETER[\"Central_Meridian\",-96.7],PARAMETER[\"Scale_Factor\",1.000045317862],PARAMETER[\"Latitude_Of_Origin\",46.63],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Meter\",1.0]]", "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17949400, "falseY": -49666600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "//TVd within last year\nif (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') <= 5) {\n return \"TV in Last Five Years\" }\n//TVd within five years\nelse if (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') > 5 &&\nDateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') < 10) {\n return \"TV in Last 10 Years\" }\n//TVd within 10 years\nelse if (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') > 10 &&\nDateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') < 20) {\n return \"TV in Last 20 Years\" }\n//no TV in last 20 years\nelse if (DateDiff(Now(), Date($feature.INSPECTION_DATE), 'years') >= 20) {\n return \"No TV in Last 20 Years\" }\n//areas which do not satisfy any of the given conditions belong in the fourth group\nelse {\n return \"None of these conditions\" }", "valueExpressionTitle": "Last TVd", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 197, 0, 255, 255 ], "width": 2 }, "value": "TV in Last Five Years", "label": "TV in Last 5 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 2 }, "value": "TV in Last 10 Years", "label": "TV in Last 10 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "TV in Last 20 Years", "label": "TV in Last 20 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 2 }, "value": "No TV in Last 20 Years", "label": "No TV in Last 20 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 2 }, "value": "None of these conditions", "label": "None of these conditions" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 213, 207, 255 ], "toColor": [ 252, 213, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 184, 255 ], "toColor": [ 184, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 179, 252, 255 ], "toColor": [ 179, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 244, 252, 255 ], "toColor": [ 179, 244, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 179, 255 ], "toColor": [ 252, 244, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 234, 255 ], "toColor": [ 252, 179, 234, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 212, 252, 255 ], "toColor": [ 230, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 252, 220, 255 ], "toColor": [ 210, 252, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 194, 255 ], "toColor": [ 252, 179, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 223, 252, 255 ], "toColor": [ 199, 223, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 179, 252, 255 ], "toColor": [ 227, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 237, 207, 255 ], "toColor": [ 252, 237, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 223, 252, 194, 255 ], "toColor": [ 223, 252, 194, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -1.0775404680980526E7, "ymin": 5912320.839741715, "xmax": -1.0764363938328883E7, "ymax": 5933689.600446165, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSET_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "Asset Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_SanMainType", "description": "Sanitary Gravity Main Type", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Collector Gravity Main", "code": "Collector Gravity Main" }, { "name": "Interceptor Gravity Main", "code": "Interceptor Gravity Main" }, { "name": "Major Collector Gravity Main", "code": "Major Collector Gravity Main" }, { "name": "Outlet Gravity Main", "code": "Outlet Gravity Main" }, { "name": "Service Gravity Main", "code": "Service Gravity Main" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 36, "domain": { "type": "codedValue", "name": "WS2_SanPipeMaterialEAM", "description": "Sanitary Pipe Material", "codedValues": [ { "name": "Abandoned", "code": "Abandoned" }, { "name": "PVC Ribbed", "code": "PVC Ribbed" }, { "name": "Brick", "code": "Brick" }, { "name": "Steel", "code": "Steel" }, { "name": "CIPP Brick", "code": "CIPP Brick" }, { "name": "CIPP RCP", "code": "CIPP RCP" }, { "name": "CIPP VCP", "code": "CIPP VCP" }, { "name": "CIPP PVC", "code": "CIPP PVC" }, { "name": "Other", "code": "Other" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Vitrified Clay Pipe", "code": "VCP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Ductile Iron Pipe", "code": "DIP" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Acrylonitrile Butadiene Styrene Truss", "code": "ABS Truss" }, { "name": "Cured In Place Pipe", "code": "CIPP" }, { "name": "Fiberglass Reinforced, Polymer Mortar", "code": "HOBAS" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeSmallInteger", "alias": "Diameter", "domain": null }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "Project", "length": 36, "domain": null }, { "name": "PROJECT2", "type": "esriFieldTypeString", "alias": "Project 2", "length": 36, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 60, "domain": null }, { "name": "SECTION", "type": "esriFieldTypeString", "alias": "Section", "length": 8, "domain": null }, { "name": "SERVICE_AREA", "type": "esriFieldTypeString", "alias": "Service Area", "length": 75, "domain": null }, { "name": "WYE_ID", "type": "esriFieldTypeSmallInteger", "alias": "WYE ID", "domain": null }, { "name": "FROM_MH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 12, "domain": null }, { "name": "TO_MH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 12, "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 254, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Ownership", "length": 24, "domain": { "type": "codedValue", "name": "WS2_Owner", "description": "Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "State", "code": "State" }, { "name": "Township", "code": "Township" }, { "name": "Private", "code": "Private" }, { "name": "MnDOT", "code": "MnDOT" }, { "name": "Concordia", "code": "Concordia" }, { "name": "MSUM", "code": "MSUM" }, { "name": "Watershed District", "code": "Watershed District" }, { "name": "Other", "code": "Other" }, { "name": "Moorhead Public Service", "code": "Moorhead Public Service" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Dilworth", "code": "Dilworth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDITION_COMMENTS", "type": "esriFieldTypeString", "alias": "Condition - Comments", "length": 254, "domain": null }, { "name": "JET_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "Jet Order", "domain": null }, { "name": "JET_REMARKS", "type": "esriFieldTypeString", "alias": "Jet Remarks", "length": 120, "domain": null }, { "name": "CLEANED_DATE", "type": "esriFieldTypeDate", "alias": "Cleaned Date", "length": 8, "domain": null }, { "name": "MAINTENANCEINTERVAL", "type": "esriFieldTypeString", "alias": "Maintenance Interval", "length": 18, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "TV_YEAR_1", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 1", "domain": null }, { "name": "TV_YEAR_2", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 2", "domain": null }, { "name": "TV_YEAR_3", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 3", "domain": null }, { "name": "TV_YEAR_4", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 4", "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "REHAB_TYPE", "type": "esriFieldTypeString", "alias": "Rehab Type", "length": 18, "domain": { "type": "codedValue", "name": "WS2_RehabType", "description": "Rehab Project Type", "codedValues": [ { "name": "Relined", "code": "Relined" }, { "name": "Replaced", "code": "Replaced" }, { "name": "Spot Repaired", "code": "Spot Repaired" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Sleeve", "code": "Sleeve" }, { "name": "Future Reline", "code": "Future Reline" }, { "name": "Future Replace", "code": "Future Replace" }, { "name": "Future Repair", "code": "Future Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHAB_REMARKS", "type": "esriFieldTypeString", "alias": "Rehab Remarks", "length": 120, "domain": null }, { "name": "REHAB_LENGTH", "type": "esriFieldTypeString", "alias": "Rehab Length", "length": 36, "domain": null }, { "name": "REHAB_DATE", "type": "esriFieldTypeDate", "alias": "Rehab Date", "length": 8, "domain": null }, { "name": "REHAB_YEAR_1", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 1", "domain": null }, { "name": "REHAB_YEAR_2", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 2", "domain": null }, { "name": "REHAB_YEAR_3", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 3", "domain": null }, { "name": "PIPE_RATING", "type": "esriFieldTypeSmallInteger", "alias": "Pipe Rating", "domain": null }, { "name": "PIPE_ASSESSMENT", "type": "esriFieldTypeDouble", "alias": "Pipe Assessment", "domain": null }, { "name": "UPSTRM_INVERT", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null }, { "name": "DNSTRM_INVERT", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 12, "domain": { "type": "codedValue", "name": "WS2_DATUM", "description": "Vertical Datum", "codedValues": [ { "name": "NAVD 1988", "code": "88" }, { "name": "NGVD 1929", "code": "29" }, { "name": "LiDAR Derived", "code": "44" }, { "name": "Mixed", "code": "46" }, { "name": "Unknown", "code": "48" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANS_PATH", "type": "esriFieldTypeString", "alias": "Path to Plans", "length": 500, "domain": null }, { "name": "ANNO", "type": "esriFieldTypeString", "alias": "Annotation", "length": 50, "domain": null }, { "name": "LIFECYCLE_STATUS", "type": "esriFieldTypeSmallInteger", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "WS2_LifecycleStatus", "description": "Life Cycle Status - more options", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Proposed", "code": 1 }, { "name": "In Service", "code": 8 }, { "name": "Abandoned", "code": 32 }, { "name": "Retired", "code": 64 }, { "name": "Removed", "code": 128 }, { "name": "Out of Service", "code": 256 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "RETIRE_DATE", "type": "esriFieldTypeDate", "alias": "Retire Date", "length": 8, "domain": null }, { "name": "LIFE_EXPECTANCY", "type": "esriFieldTypeInteger", "alias": "Life Expectancy", "domain": null }, { "name": "AGE", "type": "esriFieldTypeInteger", "alias": "Age", "domain": null }, { "name": "SERVICE_LIFE", "type": "esriFieldTypeInteger", "alias": "Service Life", "domain": null }, { "name": "WYE_PATH", "type": "esriFieldTypeString", "alias": "WYE Card Path", "length": 120, "domain": null }, { "name": "VIDEO_ID", "type": "esriFieldTypeString", "alias": "Video ID", "length": 120, "domain": null }, { "name": "IMAGE_ID", "type": "esriFieldTypeString", "alias": "Image ID", "length": 120, "domain": null }, { "name": "CALC_LENGTH", "type": "esriFieldTypeInteger", "alias": "Non Decimal Length", "domain": null }, { "name": "CALC_TEXT", "type": "esriFieldTypeString", "alias": "Calc Text Field", "length": 80, "domain": null }, { "name": "LENGHTPOSM", "type": "esriFieldTypeInteger", "alias": "Length Posm", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeInteger", "alias": "Capacity", "domain": null }, { "name": "REACH", "type": "esriFieldTypeString", "alias": "Reach", "length": 50, "domain": null }, { "name": "WYE_ABPage_ID", "type": "esriFieldTypeString", "alias": "WYE - AB Page ID", "length": 50, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeInteger", "alias": "Depth", "domain": null }, { "name": "RISK_SCORE", "type": "esriFieldTypeDouble", "alias": "Risk Score", "domain": null }, { "name": "RISK_LEVEL", "type": "esriFieldTypeInteger", "alias": "Risk Level", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R978_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_978", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_978", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S918_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 22, "name": "Last Jetted Sanitary Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",GEOGCS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667],PARAMETER[\"False_Northing\",100004.5319459167],PARAMETER[\"Central_Meridian\",-96.7],PARAMETER[\"Scale_Factor\",1.000045317862],PARAMETER[\"Latitude_Of_Origin\",46.63],UNIT[\"Foot_US\",0.3048006096012192]],VERTCS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],PARAMETER[\"Vertical_Shift\",0.0],PARAMETER[\"Direction\",1.0],UNIT[\"Meter\",1.0]]", "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17949400, "falseY": -49666600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "//cleaned within last year\nif (DateDiff(Now(), Date($feature.CLEANED_DATE), 'years') <= 1) {\n return \"Cleaned in Last Year\" }\n//cleaned in last two years\nelse if (DateDiff(Now(), Date($feature.CLEANED_DATE), 'years') > 1 &&\nDateDiff(Now(), Date($feature.CLEANED_DATE), 'years') < 2) {\n return \"Cleaned in Last Two Years\" }\n//cleaned in last three years\nelse if (DateDiff(Now(), Date($feature.CLEANED_DATE), 'years') > 2 &&\nDateDiff(Now(), Date($feature.CLEANED_DATE), 'years') < 3) {\n return \"Cleaned in Last Three Years\" }\n//not cleaned in last 3 years\nelse if (DateDiff(Now(), Date($feature.CLEANED_DATE), 'years') >= 3) {\n return \"Not Cleaned in Last Three Years\" }\n//areas which do not satisfy any of the given conditions belong in the fourth group\nelse {\n return \"None of these conditions\" }", "valueExpressionTitle": "Last Jetted", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "Cleaned in Last Year", "label": "Cleaned in Last Year" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 255, 197, 255 ], "width": 2 }, "value": "Cleaned in Last Two Years", "label": "Cleaned in Last 2 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "value": "Cleaned in Last Three Years", "label": "Cleaned in Last 3 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 2 }, "value": "Not Cleaned in Last Three Years", "label": "Not Cleaned in Last 3 Years" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 2 }, "value": "None of these conditions", "label": "None of these conditions" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 213, 207, 255 ], "toColor": [ 252, 213, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 184, 255 ], "toColor": [ 184, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 179, 252, 255 ], "toColor": [ 179, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 244, 252, 255 ], "toColor": [ 179, 244, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 179, 255 ], "toColor": [ 252, 244, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 234, 255 ], "toColor": [ 252, 179, 234, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 212, 252, 255 ], "toColor": [ 230, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 252, 220, 255 ], "toColor": [ 210, 252, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 194, 255 ], "toColor": [ 252, 179, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 223, 252, 255 ], "toColor": [ 199, 223, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 179, 252, 255 ], "toColor": [ 227, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 237, 207, 255 ], "toColor": [ 252, 237, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 223, 252, 194, 255 ], "toColor": [ 223, 252, 194, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.0775404680980526E7, "ymin": 5912320.839741715, "xmax": -1.0764363938328883E7, "ymax": 5933689.600446165, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSET_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "Asset Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_SanMainType", "description": "Sanitary Gravity Main Type", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Collector Gravity Main", "code": "Collector Gravity Main" }, { "name": "Interceptor Gravity Main", "code": "Interceptor Gravity Main" }, { "name": "Major Collector Gravity Main", "code": "Major Collector Gravity Main" }, { "name": "Outlet Gravity Main", "code": "Outlet Gravity Main" }, { "name": "Service Gravity Main", "code": "Service Gravity Main" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 36, "domain": { "type": "codedValue", "name": "WS2_SanPipeMaterialEAM", "description": "Sanitary Pipe Material", "codedValues": [ { "name": "Abandoned", "code": "Abandoned" }, { "name": "PVC Ribbed", "code": "PVC Ribbed" }, { "name": "Brick", "code": "Brick" }, { "name": "Steel", "code": "Steel" }, { "name": "CIPP Brick", "code": "CIPP Brick" }, { "name": "CIPP RCP", "code": "CIPP RCP" }, { "name": "CIPP VCP", "code": "CIPP VCP" }, { "name": "CIPP PVC", "code": "CIPP PVC" }, { "name": "Other", "code": "Other" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Vitrified Clay Pipe", "code": "VCP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Ductile Iron Pipe", "code": "DIP" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Acrylonitrile Butadiene Styrene Truss", "code": "ABS Truss" }, { "name": "Cured In Place Pipe", "code": "CIPP" }, { "name": "Fiberglass Reinforced, Polymer Mortar", "code": "HOBAS" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeSmallInteger", "alias": "Diameter", "domain": null }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "Project", "length": 36, "domain": null }, { "name": "PROJECT2", "type": "esriFieldTypeString", "alias": "Project 2", "length": 36, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 60, "domain": null }, { "name": "SECTION", "type": "esriFieldTypeString", "alias": "Section", "length": 8, "domain": null }, { "name": "SERVICE_AREA", "type": "esriFieldTypeString", "alias": "Service Area", "length": 75, "domain": null }, { "name": "WYE_ID", "type": "esriFieldTypeSmallInteger", "alias": "WYE ID", "domain": null }, { "name": "FROM_MH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 12, "domain": null }, { "name": "TO_MH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 12, "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 254, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Ownership", "length": 24, "domain": { "type": "codedValue", "name": "WS2_Owner", "description": "Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "County", "code": "County" }, { "name": "State", "code": "State" }, { "name": "Township", "code": "Township" }, { "name": "Private", "code": "Private" }, { "name": "MnDOT", "code": "MnDOT" }, { "name": "Concordia", "code": "Concordia" }, { "name": "MSUM", "code": "MSUM" }, { "name": "Watershed District", "code": "Watershed District" }, { "name": "Other", "code": "Other" }, { "name": "Moorhead Public Service", "code": "Moorhead Public Service" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Dilworth", "code": "Dilworth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDITION_COMMENTS", "type": "esriFieldTypeString", "alias": "Condition - Comments", "length": 254, "domain": null }, { "name": "JET_ORDER", "type": "esriFieldTypeSmallInteger", "alias": "Jet Order", "domain": null }, { "name": "JET_REMARKS", "type": "esriFieldTypeString", "alias": "Jet Remarks", "length": 120, "domain": null }, { "name": "CLEANED_DATE", "type": "esriFieldTypeDate", "alias": "Cleaned Date", "length": 8, "domain": null }, { "name": "MAINTENANCEINTERVAL", "type": "esriFieldTypeString", "alias": "Maintenance Interval", "length": 18, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "TV_YEAR_1", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 1", "domain": null }, { "name": "TV_YEAR_2", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 2", "domain": null }, { "name": "TV_YEAR_3", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 3", "domain": null }, { "name": "TV_YEAR_4", "type": "esriFieldTypeSmallInteger", "alias": "TV Year 4", "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "REHAB_TYPE", "type": "esriFieldTypeString", "alias": "Rehab Type", "length": 18, "domain": { "type": "codedValue", "name": "WS2_RehabType", "description": "Rehab Project Type", "codedValues": [ { "name": "Relined", "code": "Relined" }, { "name": "Replaced", "code": "Replaced" }, { "name": "Spot Repaired", "code": "Spot Repaired" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Sleeve", "code": "Sleeve" }, { "name": "Future Reline", "code": "Future Reline" }, { "name": "Future Replace", "code": "Future Replace" }, { "name": "Future Repair", "code": "Future Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REHAB_REMARKS", "type": "esriFieldTypeString", "alias": "Rehab Remarks", "length": 120, "domain": null }, { "name": "REHAB_LENGTH", "type": "esriFieldTypeString", "alias": "Rehab Length", "length": 36, "domain": null }, { "name": "REHAB_DATE", "type": "esriFieldTypeDate", "alias": "Rehab Date", "length": 8, "domain": null }, { "name": "REHAB_YEAR_1", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 1", "domain": null }, { "name": "REHAB_YEAR_2", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 2", "domain": null }, { "name": "REHAB_YEAR_3", "type": "esriFieldTypeSmallInteger", "alias": "Rehab Year 3", "domain": null }, { "name": "PIPE_RATING", "type": "esriFieldTypeSmallInteger", "alias": "Pipe Rating", "domain": null }, { "name": "PIPE_ASSESSMENT", "type": "esriFieldTypeDouble", "alias": "Pipe Assessment", "domain": null }, { "name": "UPSTRM_INVERT", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null }, { "name": "DNSTRM_INVERT", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 12, "domain": { "type": "codedValue", "name": "WS2_DATUM", "description": "Vertical Datum", "codedValues": [ { "name": "NAVD 1988", "code": "88" }, { "name": "NGVD 1929", "code": "29" }, { "name": "LiDAR Derived", "code": "44" }, { "name": "Mixed", "code": "46" }, { "name": "Unknown", "code": "48" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PLANS_PATH", "type": "esriFieldTypeString", "alias": "Path to Plans", "length": 500, "domain": null }, { "name": "ANNO", "type": "esriFieldTypeString", "alias": "Annotation", "length": 50, "domain": null }, { "name": "LIFECYCLE_STATUS", "type": "esriFieldTypeSmallInteger", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "WS2_LifecycleStatus", "description": "Life Cycle Status - more options", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Proposed", "code": 1 }, { "name": "In Service", "code": 8 }, { "name": "Abandoned", "code": 32 }, { "name": "Retired", "code": 64 }, { "name": "Removed", "code": 128 }, { "name": "Out of Service", "code": 256 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "RETIRE_DATE", "type": "esriFieldTypeDate", "alias": "Retire Date", "length": 8, "domain": null }, { "name": "LIFE_EXPECTANCY", "type": "esriFieldTypeInteger", "alias": "Life Expectancy", "domain": null }, { "name": "AGE", "type": "esriFieldTypeInteger", "alias": "Age", "domain": null }, { "name": "SERVICE_LIFE", "type": "esriFieldTypeInteger", "alias": "Service Life", "domain": null }, { "name": "WYE_PATH", "type": "esriFieldTypeString", "alias": "WYE Card Path", "length": 120, "domain": null }, { "name": "VIDEO_ID", "type": "esriFieldTypeString", "alias": "Video ID", "length": 120, "domain": null }, { "name": "IMAGE_ID", "type": "esriFieldTypeString", "alias": "Image ID", "length": 120, "domain": null }, { "name": "CALC_LENGTH", "type": "esriFieldTypeInteger", "alias": "Non Decimal Length", "domain": null }, { "name": "CALC_TEXT", "type": "esriFieldTypeString", "alias": "Calc Text Field", "length": 80, "domain": null }, { "name": "LENGHTPOSM", "type": "esriFieldTypeInteger", "alias": "Length Posm", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeInteger", "alias": "Capacity", "domain": null }, { "name": "REACH", "type": "esriFieldTypeString", "alias": "Reach", "length": 50, "domain": null }, { "name": "WYE_ABPage_ID", "type": "esriFieldTypeString", "alias": "WYE - AB Page ID", "length": 50, "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeInteger", "alias": "Depth", "domain": null }, { "name": "RISK_SCORE", "type": "esriFieldTypeDouble", "alias": "Risk Score", "domain": null }, { "name": "RISK_LEVEL", "type": "esriFieldTypeInteger", "alias": "Risk Level", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R978_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_978", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_978", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S918_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 25, "name": "POSM_GIS_Obs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FaultName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "DataID", "type": "esriFieldTypeOID", "alias": "DataID", "domain": null }, { "name": "FaultName", "type": "esriFieldTypeString", "alias": "FaultName", "length": 100, "domain": null }, { "name": "Distance", "type": "esriFieldTypeDouble", "alias": "Distance", "domain": null }, { "name": "TimeStamp", "type": "esriFieldTypeDate", "alias": "TimeStamp", "length": 8, "domain": null }, { "name": "PictureLocation", "type": "esriFieldTypeString", "alias": "PictureLocation", "length": 100, "domain": null }, { "name": "VideoLocation", "type": "esriFieldTypeString", "alias": "VideoLocation", "length": 100, "domain": null }, { "name": "FaultStartPosition", "type": "esriFieldTypeString", "alias": "FaultStartPosition", "length": 50, "domain": null }, { "name": "FaultEndPosition", "type": "esriFieldTypeString", "alias": "FaultEndPosition", "length": 50, "domain": null }, { "name": "Value_1st_Dimension", "type": "esriFieldTypeString", "alias": "Value_1st_Dimension", "length": 50, "domain": null }, { "name": "Value_2nd_Dimension", "type": "esriFieldTypeString", "alias": "Value_2nd_Dimension", "length": 50, "domain": null }, { "name": "Value_Percent", "type": "esriFieldTypeString", "alias": "Value_Percent", "length": 50, "domain": null }, { "name": "Joint", "type": "esriFieldTypeSmallInteger", "alias": "Joint", "domain": null }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null }, { "name": "MediaFolder", "type": "esriFieldTypeString", "alias": "MediaFolder", "length": 100, "domain": null }, { "name": "WebPathtoReportIndex", "type": "esriFieldTypeString", "alias": "WebPathtoReportIndex", "length": 255, "domain": null }, { "name": "IsLatestInspection", "type": "esriFieldTypeSmallInteger", "alias": "IsLatestInspection", "domain": null }, { "name": "HTML_Pic_Loc", "type": "esriFieldTypeString", "alias": "HTML_Pic_Loc", "length": 232, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 100, "domain": null } ], "indexes": [ { "name": "FDO_DataID", "fields": "DataID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" } ] }