{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "POSM Observations", "type": "Feature Layer", "description": "POSM Observations", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",BASEGEOGCRS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],AXIS[\"Latitude (lat)\",north,ORDER[1]],AXIS[\"Longitude (lon)\",east,ORDER[2]],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Transverse_Mercator\",METHOD[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",100004.5319459167,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Central_Meridian\",-96.7,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Scale_Factor\",1.000045317862,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Latitude_Of_Origin\",46.63,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Meter\",1.0]]]]", "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 }, "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 }, "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": "5f3b90a9bef10582b5c52e36f65b23e4", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAgAAAAOCAYAAAASVl2WAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABAElEQVQYlWNhIABY0PgGDAwMHxgYGB5gU6DAp8MwDcT4dIXBCkMBrxpDsEICgwEjCwPnxQKGBAYGhgXIChSELBjSJH0YOFn5GBiermWofHOY4QDIKrACHkWGZCk/BjWQJAio5jOofXvAUPztMUMuSIGBqDNDgjDcVgYGEFvSlyHy7jSGuSAFH/58Y+DE4csPIAUPXm5nmPc2iKEUZsrbYwwMzzczLIe74dd7hmkPFzH4C1sxqP3+xMDwbBPDrW+PGeYi++LB2xMME1/sYJjKwsPw/d0JhlkMDAwXUMLh5yuGZXenM6Sx8jL8/HyLYS22kPzw/jQ4gMAm4ooLsLHIAAAz7kmvUQ4qggAAAABJRU5ErkJggg==", "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, "maxSelectionCount": 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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 24, "name": "Last Inspected Manhole", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",BASEGEOGCRS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],AXIS[\"Latitude (lat)\",north,ORDER[1]],AXIS[\"Longitude (lon)\",east,ORDER[2]],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Transverse_Mercator\",METHOD[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",100004.5319459167,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Central_Meridian\",-96.7,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Scale_Factor\",1.000045317862,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Latitude_Of_Origin\",46.63,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Meter\",1.0]]]]", "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 }, "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 }, "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", "uniqueValueGroups": [ { "heading": "Last Inspected", "classes": [ { "label": "Inspected in Last Year", "description": "Inspected in Last Year", "symbol": { "type": "esriPMS", "url": "cdbf3cdbf6d0976eb7596be8ab99527d", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABPUlEQVQ4jaWTsU7DQBBEX+EufZBdpqeyi/RQOqGnJ3yGzWcQenpwPoKCq+jdYST36dHcecNhnCgSK51k3e3M7uysE/4ZyZH7fDgZkAI7wAHdOQQ1ULFYwSyFWQZts6EXnofh/ShBwzwvWdawKH9ulxWe4GVdse/0UEwR1B58+z4tap7D3Sc8Fzm9q62TJNJccf34GxTaDmCLmwaesgrYaibJgUCa48TXtbSH78sNXA3kmoty20ZStkaQ+Ye4soEVH9tAYgVCbhZLSP20z42Qm8YEO2+Vpm2aVVGVFWN5obuvmMD5tnUsUZpFMh6i5cnyiKDzSyKfZZVFDLR40y55B9zfPdh3pfdZVsVDtcoCt42A93Y93sTCL4l8VvWL3FbZ2lblA3iKIHSixN6V9M5+Jg1MmofNOk1gMxksOB3fEC9mPsrpknAAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Inspected in Last Year" ] ] }, { "label": "Inspected in Last 2 Years", "description": "Inspected in Last 2 Years", "symbol": { "type": "esriPMS", "url": "0c54b47d94f91716567d3c4247e99596", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQUlEQVQ4jaWTwW2DQBBF34ESfIEGnDvc3AKxe7AlpwNyBF/TgS0lPVi4BPsWCqCAkEuKiP4uQ9bIyJYyEgjtzv8z/88Q8c+IJs7T/kmAGDgBDdA9QlABJc8LiGeQzKA+b2la3e36+0mCmnSeU20gX/ydlmscwbIo6X5yILtFUDnw58eEqDl8HSFbpzRtZZ1EgeaS/es1yLftwUOPb5CsSuAgT6KBQJrDxGUB9cV/b1ewL/y3fFFufZGUgxEk7iKsbGDF4ehJrIDPTUIJsXP70fC5cUhwcqOS26ZZFVVZMZZXn/X+Dgka17YeS5RmkYxNtDyNPCDo3JJozhqVRQi02L07V/rN5HoPtCSas0YVmmqVBa4vAr7Y8XgTM7ckmrOqp0+2yta2Kg/gWwS+EyU2bU7T2s8kw6TZtX2PwDxRtbvxC5lnZqNkI3VcAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Inspected in Last 2 Years" ] ] }, { "label": "Inspected in Last 3 Years", "description": "Inspected in Last 3 Years", "symbol": { "type": "esriPMS", "url": "49d71d1869400f708dbbadb7369491f5", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNklEQVQ4jaWTsW3DMBBFX6EFXIqlV6BGSKm48wryCEknuYtHsFZIKZcZIVxBXZQyKwSf5gm0YCEGcgAb8u7/+/+OBf+MYuXep+OAErgAAZgeAeiA9tlDuQG3gSHQhDG+HdP7KsDgt9TdHmrxp2j3IIDdiXb6oQaqewCdij/fVjRt4esM1Ss+jLGLLgfwIjo3t0Wp7Vg8t/gC7kAL9PKkMABpzhN3p6g9RvMEBi5flDuEKKU3AKeHnNmKFf3HFcQIUq7LJZRy+9FIuWUOcNGo5LZpFqOYFUt5qbvvHCCobR1LlGaBLE20POHkAJOWRHPWqCzyQovj+9WWtJnc7IGWRHPWqHJTjVnFQ4iFB7tfbmKlJdGcxa6TVtnaFvNcfA8gdqLEMFKHcf5MMkyas+GuA5gnYvszfgEWLmaElHKvDwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Inspected in Last 3 Years" ] ] }, { "label": "Not inspected in Last 3 Years", "description": "Not inspected in Last 3 Years", "symbol": { "type": "esriPMS", "url": "a8ff055ce3a4fdbb7594fb58e04665f1", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABB0lEQVQ4jaWT7a2CQBBFz49tAtrAMtAysAywDG0Dy3DLENsw153RyT4kJm8SEpide+ZrSfzT0hd/Z08LNMAVyMDyC2ACxr0pRZhhkBo42flXwNxBr4g+OEdLf4BxKUe7NcAk8W2jp3tRdrlUMUVAp0TnSpTD4bvE0paKumgmyWP2VeDBgmUD4HDNRbFzaeXigLapMrsYSzWEBBbbxhaa19eP1gZOMt9VqxpDz4NlltXtWXWPCMgqO4fAs0EcGNvLgZPMrxt20p61KlaEbrpJVlz+cw8W6LVnoeNQPbPEc3k9ur++iTtdEu05/gwCWtnK/BavAV6VKDBDnz8/kwYWONsAn4kvYdOejbFCuJV9UzUAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Not inspected in Last 3 Years" ] ] }, { "label": "None of these conditions", "description": "None of these conditions", "symbol": { "type": "esriPMS", "url": "601061b7cf794ca9269b26521e9a3b71", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABO0lEQVQ4jaVTy22EMBScA1cKwA1QwNIAd0QD3BMa4Aw50wDauyvI3mkACnADLwW4gdVYfpFDWBEpI1nCMDPvS4Z/Invx/haPAVAAeADYAchfDCYAY1mWyPM8HOfcm0jQfsTvLw0+jTFNXdeggYJ3GlhrR+99A6A6M5go7vv+tCZjDIZhwLIsNxGZNJMsqXls2/aHKKYdxIqu6zDP8wjgTkqmBkw5JVprWXt4rqoKas6ekOucYyl3NTD8kEZWMbFtWzDRAJEbLlnkFKnBFSK3SA0eHBW7rTUzIiMTx/Jidl+pwc60eZTImmlybKLyOPLUQLgknDNHpUiFinVdESew/9oD733DOXNUx54wKsXOOQrf9f1xEysuCefM6DxxlTVtRv4WnxmETEgUkUZE9Gdiw1hzSPvKQHvCaJd4Al63iV1GJJ2qAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "None of these conditions" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "cdbf3cdbf6d0976eb7596be8ab99527d", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABPUlEQVQ4jaWTsU7DQBBEX+EufZBdpqeyi/RQOqGnJ3yGzWcQenpwPoKCq+jdYST36dHcecNhnCgSK51k3e3M7uysE/4ZyZH7fDgZkAI7wAHdOQQ1ULFYwSyFWQZts6EXnofh/ShBwzwvWdawKH9ulxWe4GVdse/0UEwR1B58+z4tap7D3Sc8Fzm9q62TJNJccf34GxTaDmCLmwaesgrYaibJgUCa48TXtbSH78sNXA3kmoty20ZStkaQ+Ye4soEVH9tAYgVCbhZLSP20z42Qm8YEO2+Vpm2aVVGVFWN5obuvmMD5tnUsUZpFMh6i5cnyiKDzSyKfZZVFDLR40y55B9zfPdh3pfdZVsVDtcoCt42A93Y93sTCL4l8VvWL3FbZ2lblA3iKIHSixN6V9M5+Jg1MmofNOk1gMxksOB3fEC9mPsrpknAAAAAASUVORK5CYII=", "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": "0c54b47d94f91716567d3c4247e99596", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQUlEQVQ4jaWTwW2DQBBF34ESfIEGnDvc3AKxe7AlpwNyBF/TgS0lPVi4BPsWCqCAkEuKiP4uQ9bIyJYyEgjtzv8z/88Q8c+IJs7T/kmAGDgBDdA9QlABJc8LiGeQzKA+b2la3e36+0mCmnSeU20gX/ydlmscwbIo6X5yILtFUDnw58eEqDl8HSFbpzRtZZ1EgeaS/es1yLftwUOPb5CsSuAgT6KBQJrDxGUB9cV/b1ewL/y3fFFufZGUgxEk7iKsbGDF4ehJrIDPTUIJsXP70fC5cUhwcqOS26ZZFVVZMZZXn/X+Dgka17YeS5RmkYxNtDyNPCDo3JJozhqVRQi02L07V/rN5HoPtCSas0YVmmqVBa4vAr7Y8XgTM7ckmrOqp0+2yta2Kg/gWwS+EyU2bU7T2s8kw6TZtX2PwDxRtbvxC5lnZqNkI3VcAAAAAElFTkSuQmCC", "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": "49d71d1869400f708dbbadb7369491f5", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNklEQVQ4jaWTsW3DMBBFX6EFXIqlV6BGSKm48wryCEknuYtHsFZIKZcZIVxBXZQyKwSf5gm0YCEGcgAb8u7/+/+OBf+MYuXep+OAErgAAZgeAeiA9tlDuQG3gSHQhDG+HdP7KsDgt9TdHmrxp2j3IIDdiXb6oQaqewCdij/fVjRt4esM1Ss+jLGLLgfwIjo3t0Wp7Vg8t/gC7kAL9PKkMABpzhN3p6g9RvMEBi5flDuEKKU3AKeHnNmKFf3HFcQIUq7LJZRy+9FIuWUOcNGo5LZpFqOYFUt5qbvvHCCobR1LlGaBLE20POHkAJOWRHPWqCzyQovj+9WWtJnc7IGWRHPWqHJTjVnFQ4iFB7tfbmKlJdGcxa6TVtnaFvNcfA8gdqLEMFKHcf5MMkyas+GuA5gnYvszfgEWLmaElHKvDwAAAABJRU5ErkJggg==", "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": "a8ff055ce3a4fdbb7594fb58e04665f1", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABB0lEQVQ4jaWT7a2CQBBFz49tAtrAMtAysAywDG0Dy3DLENsw153RyT4kJm8SEpide+ZrSfzT0hd/Z08LNMAVyMDyC2ACxr0pRZhhkBo42flXwNxBr4g+OEdLf4BxKUe7NcAk8W2jp3tRdrlUMUVAp0TnSpTD4bvE0paKumgmyWP2VeDBgmUD4HDNRbFzaeXigLapMrsYSzWEBBbbxhaa19eP1gZOMt9VqxpDz4NlltXtWXWPCMgqO4fAs0EcGNvLgZPMrxt20p61KlaEbrpJVlz+cw8W6LVnoeNQPbPEc3k9ur++iTtdEu05/gwCWtnK/BavAV6VKDBDnz8/kwYWONsAn4kvYdOejbFCuJV9UzUAAAAASUVORK5CYII=", "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": "601061b7cf794ca9269b26521e9a3b71", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABO0lEQVQ4jaVTy22EMBScA1cKwA1QwNIAd0QD3BMa4Aw50wDauyvI3mkACnADLwW4gdVYfpFDWBEpI1nCMDPvS4Z/Invx/haPAVAAeADYAchfDCYAY1mWyPM8HOfcm0jQfsTvLw0+jTFNXdeggYJ3GlhrR+99A6A6M5go7vv+tCZjDIZhwLIsNxGZNJMsqXls2/aHKKYdxIqu6zDP8wjgTkqmBkw5JVprWXt4rqoKas6ekOucYyl3NTD8kEZWMbFtWzDRAJEbLlnkFKnBFSK3SA0eHBW7rTUzIiMTx/Jidl+pwc60eZTImmlybKLyOPLUQLgknDNHpUiFinVdESew/9oD733DOXNUx54wKsXOOQrf9f1xEysuCefM6DxxlTVtRv4WnxmETEgUkUZE9Gdiw1hzSPvKQHvCaJd4Al63iV1GJJ2qAAAAAElFTkSuQmCC", "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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "UUID_974", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "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, "maxSelectionCount": 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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1695240662000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 23, "name": "Last TV'd Sanitary Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",BASEGEOGCRS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],AXIS[\"Latitude (lat)\",north,ORDER[1]],AXIS[\"Longitude (lon)\",east,ORDER[2]],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Transverse_Mercator\",METHOD[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",100004.5319459167,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Central_Meridian\",-96.7,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Scale_Factor\",1.000045317862,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Latitude_Of_Origin\",46.63,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Meter\",1.0]]]]", "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 }, "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 }, "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", "uniqueValueGroups": [ { "heading": "Last TVd", "classes": [ { "label": "TV in Last 5 Years", "description": "TV in Last 5 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 197, 0, 255, 255 ], "width": 2 }, "values": [ [ "TV in Last Five Years" ] ] }, { "label": "TV in Last 10 Years", "description": "TV in Last 10 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 178, 255, 255 ], "width": 2 }, "values": [ [ "TV in Last 10 Years" ] ] }, { "label": "TV in Last 20 Years", "description": "TV in Last 20 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 56, 168, 0, 255 ], "width": 2 }, "values": [ [ "TV in Last 20 Years" ] ] }, { "label": "No TV in Last 20 Years", "description": "No TV in Last 20 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 2 }, "values": [ [ "No TV in Last 20 Years" ] ] }, { "label": "None of these conditions", "description": "None of these conditions", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 2 }, "values": [ [ "None of these conditions" ] ] } ] } ], "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": [ 210, 242, 252, 255 ], "toColor": [ 210, 242, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 249, 255 ], "toColor": [ 252, 184, 249, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 179, 255 ], "toColor": [ 252, 240, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 199, 199, 255 ], "toColor": [ 252, 199, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 202, 255 ], "toColor": [ 179, 252, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 189, 252, 255 ], "toColor": [ 179, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 246, 215, 252, 255 ], "toColor": [ 246, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 222, 189, 255 ], "toColor": [ 252, 222, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 192, 252, 238, 255 ], "toColor": [ 192, 252, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 237, 252, 212, 255 ], "toColor": [ 237, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 219, 252, 255 ], "toColor": [ 189, 219, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 222, 252, 179, 255 ], "toColor": [ 222, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 187, 212, 255 ], "toColor": [ 252, 187, 212, 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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "UUID_978", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "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, "maxSelectionCount": 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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1695240688000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 22, "name": "Last Jetted Sanitary Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkt2": "COMPOUNDCRS[\"\",PROJCRS[\"NAD_1983_HARN_Adj_MN_Clay_Feet\",BASEGEOGCRS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",ELLIPSOID[\"GRS_1980\",6378137.0,298.257222101,LENGTHUNIT[\"Meter\",1.0]]],PRIMEM[\"Greenwich\",0.0,ANGLEUNIT[\"Degree\",0.0174532925199433]],CS[ellipsoidal,2],AXIS[\"Latitude (lat)\",north,ORDER[1]],AXIS[\"Longitude (lon)\",east,ORDER[2]],ANGLEUNIT[\"Degree\",0.0174532925199433]],CONVERSION[\"Transverse_Mercator\",METHOD[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",500022.6580891667,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"False_Northing\",100004.5319459167,LENGTHUNIT[\"Foot_US\",0.3048006096012192]],PARAMETER[\"Central_Meridian\",-96.7,ANGLEUNIT[\"Degree\",0.0174532925199433]],PARAMETER[\"Scale_Factor\",1.000045317862,SCALEUNIT[\"Unity\",1.0]],PARAMETER[\"Latitude_Of_Origin\",46.63,ANGLEUNIT[\"Degree\",0.0174532925199433]]],CS[Cartesian,2],AXIS[\"Easting (X)\",east,ORDER[1]],AXIS[\"Northing (Y)\",north,ORDER[2]],LENGTHUNIT[\"Foot_US\",0.3048006096012192]],VERTCRS[\"NAVD_1988\",VDATUM[\"North_American_Vertical_Datum_1988\"],CS[vertical,1],AXIS[\"Gravity-related height (H)\",up,LENGTHUNIT[\"Meter\",1.0]]]]", "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 }, "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 }, "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", "uniqueValueGroups": [ { "heading": "Last Jetted", "classes": [ { "label": "Cleaned in Last Year", "description": "Cleaned in Last Year", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 2 }, "values": [ [ "Cleaned in Last Year" ] ] }, { "label": "Cleaned in Last 2 Years", "description": "Cleaned in Last 2 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 255, 197, 255 ], "width": 2 }, "values": [ [ "Cleaned in Last Two Years" ] ] }, { "label": "Cleaned in Last 3 Years", "description": "Cleaned in Last 3 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "values": [ [ "Cleaned in Last Three Years" ] ] }, { "label": "Not Cleaned in Last 3 Years", "description": "Not Cleaned in Last 3 Years", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 2 }, "values": [ [ "Not Cleaned in Last Three Years" ] ] }, { "label": "None of these conditions", "description": "None of these conditions", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 2 }, "values": [ [ "None of these conditions" ] ] } ] } ], "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": [ 210, 242, 252, 255 ], "toColor": [ 210, 242, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 249, 255 ], "toColor": [ 252, 184, 249, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 179, 255 ], "toColor": [ 252, 240, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 199, 199, 255 ], "toColor": [ 252, 199, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 202, 255 ], "toColor": [ 179, 252, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 189, 252, 255 ], "toColor": [ 179, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 246, 215, 252, 255 ], "toColor": [ 246, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 222, 189, 255 ], "toColor": [ 252, 222, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 192, 252, 238, 255 ], "toColor": [ 192, 252, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 237, 252, 212, 255 ], "toColor": [ 237, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 219, 252, 255 ], "toColor": [ 189, 219, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 222, 252, 179, 255 ], "toColor": [ 222, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 187, 212, 255 ], "toColor": [ 252, 187, 212, 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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "WS1_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": "UUID_978", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "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, "maxSelectionCount": 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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1695240688000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 25, "name": "POSM_GIS_Obs", "type": "Table", "description": null, "copyrightText": 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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "DataID" ], "OIDFieldContainsHashValue": false }, "maxUniqueIDCount": 100000, "serviceItemId": "d7b675cfe6114380850b1bd88f9494a2" } ] }