{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Sewer Taps", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "activeflag", "uniqueValueGroups": [ { "heading": "Active Flag", "classes": [ { "label": "False", "description": "False", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 0, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": null }, "values": [ [ "0" ] ] }, { "label": "True", "description": "True", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 38, 115, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": null }, "values": [ [ "1" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 0, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": null }, "value": "0", "label": "False" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 38, 115, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": null }, "value": "1", "label": "True" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 192, 227, 255 ], "toColor": [ 252, 192, 227, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 191, 252, 179, 255 ], "toColor": [ 191, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 239, 252, 255 ], "toColor": [ 182, 239, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 223, 184, 255 ], "toColor": [ 252, 223, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 184, 252, 255 ], "toColor": [ 182, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 252, 210, 255 ], "toColor": [ 235, 252, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 216, 252, 255 ], "toColor": [ 212, 216, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 224, 255 ], "toColor": [ 182, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 188, 187, 255 ], "toColor": [ 252, 188, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 179, 252, 255 ], "toColor": [ 238, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 252, 179, 255 ], "toColor": [ 230, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 240, 204, 252, 255 ], "toColor": [ 240, 204, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 225, 212, 255 ], "toColor": [ 252, 225, 212, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 732927.9763309658, "ymin": 2904106.403658971, "xmax": 754362.9633165598, "ymax": 2925505.7637473047, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "locdesc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "critical", "type": "esriFieldTypeSmallInteger", "alias": "Critical Customer", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "activeflag", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Dedham", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "editsource", "type": "esriFieldTypeString", "alias": "EditSource", "length": 35, "domain": { "type": "codedValue", "name": "ssEditSource", "description": "Sewer Infrastructure Source Material", "codedValues": [ { "name": "TV Inspection", "code": "TV Inspection" }, { "name": "As Built", "code": "As Built" }, { "name": "Recorded Plan", "code": "Recorded Plan" }, { "name": "Field Observation", "code": "Field Observation" }, { "name": "MH Inspection Log", "code": "MH Inspection" }, { "name": "Aerial Photo", "code": "Aerial Photo" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Field Survey", "code": "Field Survey" }, { "name": "GPS", "code": "GPS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "editsourcedate", "type": "esriFieldTypeDate", "alias": "EditSourceDate", "length": 8, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "Description", "length": 200, "domain": null }, { "name": "tvdistance", "type": "esriFieldTypeDouble", "alias": "TVDistance", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "a142_ix1", "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": 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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Sewer Network Structures", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Town of Dedham, MA Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "structtype", "uniqueValueGroups": [ { "heading": "Structure Type", "classes": [ { "label": "Discharge Structure", "description": "Discharge Structure", "symbol": { "type": "esriPMS", "url": "d0855672d161f87c340fbf5c327fc726", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABH0lEQVQ4jbXSMUvDQBjG8f8l0aZaraiI2YpjdZCKgk4iBPRDKLi7OShFCp3F2UkQBQutm4Or+AHcXFSwQ6DFouAg1jZNC2YQbC/ES32mF+69Hw/cGfQxxn9iKQXDAdxuzNCfmLFeQjPP1SRNdxYod2PT4zo3R1ZobHW3woPz00W6+PkFh0V/NgfBmoCNRZhMSq8EYA04uYbCAdQbcPcI9h6c78NcSuE1hQYraX9em/db5c+glFPAfsfOQO4UvDZoIiI2lgC3BR91GIlHxGrvEI9Bwux5/Dfs8hbsBRBCAfM8OL6Cpgv3Zb7/1EVWui7Hhk3Ib/nz6BBs2rCcBl1TwGIDsL0eWDwYq7zC0g6hU32bkmMtT+DUwmOBzSKmr1gHmv4/4UWqaTMAAAAASUVORK5CYII=", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Discharge Structure" ] ] }, { "label": "Grease Separator", "description": "Grease Separator", "symbol": { "type": "esriPMS", "url": "836449a2e2cba7c3c1a4828177962378", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABHUlEQVQ4jb3UPSiFYRQA4CeumGRnYKBMLEY/m8XEZMaCYpIslEwsEhO7QoSUMklJEpkM4m5I8lPX4ufqq0/dbp97P7o529s5Pb3vOac3oUCR+E+oEiVI/hUKgFG04B2nmMJ1XOgbaMU0hvGJLqziLASvfoIqMIk2zITAR0Y+QNbQiRWcYww32VAjqtCOctTiCbcZNWls4ShEglsvRz3tDiNowj3q0Yf9jJo6TIRPzNmjIMaxh2psoz8L+/X4k+iIg8XZo2SI7eAVZbjIB9WgG88RWANKw3Mx5nAZBR3jAIdYwjxSGfk3FKEHg9jEbhSUCvdoFkM4wSIWwn3qxQA20IyHfD16iQDTWI8CckFRYNCTxxy1saYWgHmjYP/RF5v7RiEH18aRAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Grease Separator" ] ] }, { "label": "Pump Station", "description": "Pump Station", "symbol": { "type": "esriPMS", "url": "e0d3361a2f242ba8536ad8062ea232b2", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAATCAYAAACORR0GAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABDElEQVQ4jc2SPwtBURiHn+EmZVFmklEsshiuyaIrpfgCStH1Fe4nsF2Did1OWZQsJplEKQOLRWKSSae7UK6O7gnPdk69v6f3j8aX0H4lCgEZRdlHYOYmSgKGbVPyYjif2VgWJ6DoJhLMy2XqXkTA2rK4/cWOXOn3YbUCw4BEAlotSKWgUECt6HCAahW6XdhuoVKBwQByOfD7FYp8PohEIBh0gpdLaDScfxmkRaIL0ZEYmxhXpwOmCb2eYlEs5uxFMB5DswmjEez3EI0qFD1yvUK7Dbsd6LpcjbTo8brE5U2nkM9DIKBYFA4/v7NZ2coPRV7RXvzVazVvoZcLcWDxTjQB0sMhytHUR/5YdAel4TyuZF0rCQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 19, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Pump Station" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "d0855672d161f87c340fbf5c327fc726", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABH0lEQVQ4jbXSMUvDQBjG8f8l0aZaraiI2YpjdZCKgk4iBPRDKLi7OShFCp3F2UkQBQutm4Or+AHcXFSwQ6DFouAg1jZNC2YQbC/ES32mF+69Hw/cGfQxxn9iKQXDAdxuzNCfmLFeQjPP1SRNdxYod2PT4zo3R1ZobHW3woPz00W6+PkFh0V/NgfBmoCNRZhMSq8EYA04uYbCAdQbcPcI9h6c78NcSuE1hQYraX9em/db5c+glFPAfsfOQO4UvDZoIiI2lgC3BR91GIlHxGrvEI9Bwux5/Dfs8hbsBRBCAfM8OL6Cpgv3Zb7/1EVWui7Hhk3Ib/nz6BBs2rCcBl1TwGIDsL0eWDwYq7zC0g6hU32bkmMtT+DUwmOBzSKmr1gHmv4/4UWqaTMAAAAASUVORK5CYII=", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Discharge Structure", "label": "Discharge Structure" }, { "symbol": { "type": "esriPMS", "url": "836449a2e2cba7c3c1a4828177962378", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABHUlEQVQ4jb3UPSiFYRQA4CeumGRnYKBMLEY/m8XEZMaCYpIslEwsEhO7QoSUMklJEpkM4m5I8lPX4ufqq0/dbp97P7o529s5Pb3vOac3oUCR+E+oEiVI/hUKgFG04B2nmMJ1XOgbaMU0hvGJLqziLASvfoIqMIk2zITAR0Y+QNbQiRWcYww32VAjqtCOctTiCbcZNWls4ShEglsvRz3tDiNowj3q0Yf9jJo6TIRPzNmjIMaxh2psoz8L+/X4k+iIg8XZo2SI7eAVZbjIB9WgG88RWANKw3Mx5nAZBR3jAIdYwjxSGfk3FKEHg9jEbhSUCvdoFkM4wSIWwn3qxQA20IyHfD16iQDTWI8CckFRYNCTxxy1saYWgHmjYP/RF5v7RiEH18aRAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Grease Separator", "label": "Grease Separator" }, { "symbol": { "type": "esriPMS", "url": "e0d3361a2f242ba8536ad8062ea232b2", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAATCAYAAACORR0GAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABDElEQVQ4jc2SPwtBURiHn+EmZVFmklEsshiuyaIrpfgCStH1Fe4nsF2Did1OWZQsJplEKQOLRWKSSae7UK6O7gnPdk69v6f3j8aX0H4lCgEZRdlHYOYmSgKGbVPyYjif2VgWJ6DoJhLMy2XqXkTA2rK4/cWOXOn3YbUCw4BEAlotSKWgUECt6HCAahW6XdhuoVKBwQByOfD7FYp8PohEIBh0gpdLaDScfxmkRaIL0ZEYmxhXpwOmCb2eYlEs5uxFMB5DswmjEez3EI0qFD1yvUK7Dbsd6LpcjbTo8brE5U2nkM9DIKBYFA4/v7NZ2coPRV7RXvzVazVvoZcLcWDxTjQB0sMhytHUR/5YdAel4TyuZF0rCQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 19, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Pump Station", "label": "Pump Station" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 145, 58, 109, 255 ], "toColor": [ 145, 58, 109, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 100, 232, 128, 255 ], "toColor": [ 100, 232, 128, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 167, 93, 255 ], "toColor": [ 227, 167, 93, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 113, 192, 245, 255 ], "toColor": [ 113, 192, 245, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 88, 91, 232, 255 ], "toColor": [ 88, 91, 232, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 82, 128, 97, 255 ], "toColor": [ 82, 128, 97, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 87, 97, 255 ], "toColor": [ 235, 87, 97, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 233, 98, 245, 255 ], "toColor": [ 233, 98, 245, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 50, 89, 128, 255 ], "toColor": [ 50, 89, 128, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 234, 250, 87, 255 ], "toColor": [ 234, 250, 87, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 133, 76, 56, 255 ], "toColor": [ 133, 76, 56, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 170, 144, 232, 255 ], "toColor": [ 170, 144, 232, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 117, 230, 207, 255 ], "toColor": [ 117, 230, 207, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 729321.9192386419, "ymin": 2907073.6641286463, "xmax": 753750.5032553822, "ymax": 2924975.5584428906, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "structtype", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 30, "domain": { "type": "codedValue", "name": "ssNetworkStructureType", "description": "Sanitary network structure types", "codedValues": [ { "name": "Diversion Chamber", "code": "Diversion Chamber" }, { "name": "Diversion Point", "code": "Diversion Point" }, { "name": "Junction Chamber", "code": "Junction Chamber" }, { "name": "Production Well", "code": "Production Well" }, { "name": "Pump Station", "code": "Pump Station" }, { "name": "Split Manhole", "code": "Split Manhole" }, { "name": "Storage Basin", "code": "Storage Basin" }, { "name": "Tide Chamber", "code": "Tide Chamber" }, { "name": "Treatment Plant", "code": "Treatment Plant" }, { "name": "Lift Station", "code": "Lift Station" }, { "name": "Discharge Structure", "code": "Discharge Structure" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Virtual Junction", "code": "Virtual Junction" }, { "name": "Flow Meter", "code": "Flow Meter" }, { "name": "Monitoring Well", "code": "Monitoring Well" }, { "name": "Pump", "code": "Pump" }, { "name": "Backflow Prevention", "code": "Backflow Prevention" }, { "name": "Grease Separator", "code": "Grease Separator" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "name", "type": "esriFieldTypeString", "alias": "Name", "length": 20, "domain": null }, { "name": "locdesc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "opdate", "type": "esriFieldTypeDate", "alias": "Operational Date", "length": 8, "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Dedham", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "r162_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a140_ix1", "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": 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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Sewer Manholes", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Town of Dedham, MA Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "409a3baf778a62918198a604d6050b0f", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACZElEQVQ4jb3UXUiTURjA8f++bWtmDkwvJoN9MBVBxSIGg5CIhEGmUCiSMOmiBUO88CKMIFIUr8KLAi+6DXHmwCAS/MIJYkWCF2HKRETf2HT2TonN1y02FbLGUJCeq/P5O4fzPBwl5xjK/43ZgCuACHwDYmfFVGVldG1u8livRx0KoTQa2V9bI2kw8H59HQ8gnAa7VFzMJ7MZs9+PzGwGiwUmJ1HpdNDXx93+fm7s7HAT+JINkxmNTKvVWBwOSEF/hl4PdXUwOMjlRIKPokg5sJkRy8uj2WTCPjYG9fWg0UBNjRxRlDE1BTbbAU1NMDwMPh8Xe3vp3dvjQUZMp6O9sxN1CvH5oLJSiyC48fnuMT8/jcfznImJOKWlYDSi6e6mHnh4nJQTWCSCzWoFQYBwWI7DcYeenv70nNPpTL0CKysvKCj4lR4rKuJXMIgdWPgHi8fR1NYetmMxOV7v1RNvVlFxneZmidzcw/7GBnnAUe8vLCeHn4EA+QYDRKPQ2PgBr9eLQqFIzw8NvWV29gIm0/7xzcKCwI+MmEzG+OgodS0tKJeXJZaWArhct6mqusbi4gLBYIDqahG3G1ZXSYbD6W1LGbFolJ6ODmosFvJbW1NJ2MNun8NqnWZ8PIfCQhGXC1QqGBggKEm8zlZnn7e3eeV08mRmBll5qoqIolSCVhtHqwW/P13Esa2tdH29zIYhSTyVyzlwuXjU1YWioYH81PjuLoyMsN3ezk4oxPdkkvupnGXFgGQiwbNIhHceD962Nm5JEoaSEnYliTngDeDLsC/rr/EVcMePzk4ksqw8BXbmOFfsN85dzEkVbITtAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[FACILITYID]", "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 2000, "name": "Default", "priority": 6, "symbol": { "type": "esriTS", "color": [ 52, 52, 52, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 245, 245, 122, 255 ], "haloSize": 1.75, "font": { "family": "Calibri", "size": 9, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 729317.3270562142, "ymin": 2904100.550980389, "xmax": 754366.9606838822, "ymax": 2925508.2968787253, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "locdesc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "mhtype", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 15, "domain": { "type": "codedValue", "name": "piManholeType", "description": "List of infrastructure Manhole Types", "codedValues": [ { "name": "Access", "code": "Access" }, { "name": "Inside Drop", "code": "Inside Drop" }, { "name": "PTO", "code": "PTO" }, { "name": "Up Side BWG", "code": "Up Side BWG" }, { "name": "Down Side BWG", "code": "Down Side BWG" }, { "name": "Up Side SG", "code": "Up Side SG" }, { "name": "Down Side SG", "code": "Down Side SG" }, { "name": "Control", "code": "Control" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mhdiameter", "type": "esriFieldTypeSmallInteger", "alias": "Access Diameter", "domain": null }, { "name": "buried", "type": "esriFieldTypeSmallInteger", "alias": "Buried", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "wallmat", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 25, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Cementitious Lining", "code": "CL" }, { "name": "Cobblestone", "code": "COB" }, { "name": "Brick & Block", "code": "BB" }, { "name": "Brick & Concrete", "code": "BC" }, { "name": "Concrete & Block", "code": "CB" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Stone", "code": "ST" }, { "name": "Block", "code": "BL" }, { "name": "Block & Stone", "code": "BLST" }, { "name": "Brick & Stone", "code": "BRST" }, { "name": "Stone & Concrete", "code": "STC" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "lined", "type": "esriFieldTypeString", "alias": "Lined", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "invert", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "invertelev", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "rimelev", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "highelev", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "condition", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Dedham", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "yearlastinspected", "type": "esriFieldTypeString", "alias": "Year Last Inspected", "length": 4, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "cvtype", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 20, "domain": { "type": "codedValue", "name": "piManholeCoverType", "description": "List of infrastructure Manhole Cover Types", "codedValues": [ { "name": "Standard W/ Lock", "code": "Standard W/ Lock" }, { "name": "Standard W/ Ears", "code": "Standard W/ Ears" }, { "name": "Non-District", "code": "Non-District" }, { "name": "Water Tight", "code": "Water Tight" }, { "name": "27\" Diameter", "code": "27\" Diameter" }, { "name": "42\" Diameter", "code": "42\" Diameter" }, { "name": "Large - Water Tight", "code": "Large - Water Tight" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maxhistoricalii", "type": "esriFieldTypeSingle", "alias": "Max Historical II", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "i643facilityid", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r163_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a141_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "geobase.DBO.ssManholeInspection", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2AD02B24-5A94-4CD4-9320-6F2E0BB31DF4}" }, { "id": 0, "name": "SewerManholeRepair", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BB2A2178-52E5-4C2D-9559-D3A7E78779C9}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "Sewer Gravity Mains", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Town of Dedham, MA Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 14999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 88, 230, 0, 255 ], "width": 8 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[DIAMETER] CONCAT \"\"\" \" CONCAT [MATERIAL]", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "followFeature", "deconflictionStrategy": "dynamic", "allowOverrun": false, "repeatLabel": false, "removeDuplicates": "all", "removeDuplicatesDistance": 216, "lineConnection": "none", "multiPart": "labelPerFeature", "lineOrientation": "direction", "allowOverlapOfFeatureInterior": "exclude", "stackLabel": false, "useCodedValues": false, "maxScale": 0, "minScale": 2000, "name": "Default", "priority": 4, "symbol": { "type": "esriTS", "color": [ 76, 115, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 233, 255, 190, 255 ], "haloSize": 1, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 732898.9028983116, "ymin": 2904100.550980389, "xmax": 754366.9606838822, "ymax": 2925508.2968787253, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Cementitious Lining", "code": "CL" }, { "name": "Cobblestone", "code": "COB" }, { "name": "Brick & Block", "code": "BB" }, { "name": "Brick & Concrete", "code": "BC" }, { "name": "Concrete & Block", "code": "CB" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Stone", "code": "ST" }, { "name": "Block", "code": "BL" }, { "name": "Block & Stone", "code": "BLST" }, { "name": "Brick & Stone", "code": "BRST" }, { "name": "Stone & Concrete", "code": "STC" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "5\"", "code": 5 }, { "name": "21\"", "code": 21 }, { "name": "25\"", "code": 25 }, { "name": "27\"", "code": 27 }, { "name": "33\"", "code": 33 }, { "name": "35\"", "code": 35 }, { "name": "84\"", "code": 84 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "mainshape", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Horseshoe", "code": "Horseshoe" }, { "name": "Oblong", "code": "Oblong" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Trapezoidal", "code": "Trapezoidal" }, { "name": "Triangular", "code": "Triangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "linedyear", "type": "esriFieldTypeString", "alias": "Year Lined", "length": 4, "domain": null }, { "name": "linertype", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "Spiral Wound", "code": "SW" }, { "name": "Other", "code": "OTH" }, { "name": "None", "code": "NONE" }, { "name": "Cured in Place", "code": "CP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "frommh", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "tomh", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "watertype", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "activeflag", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Dedham", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sumflow", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "downelev", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "upelev", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "slope", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "locdesc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "condition", "type": "esriFieldTypeString", "alias": "Pipe Condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "tv_inspected", "type": "esriFieldTypeSmallInteger", "alias": "TV Inspected", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ii", "type": "esriFieldTypeSmallInteger", "alias": "II", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "yearlastinspected", "type": "esriFieldTypeString", "alias": "Year Last Inspected", "length": 4, "domain": null }, { "name": "metered", "type": "esriFieldTypeSmallInteger", "alias": "Metered", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "meternumber", "type": "esriFieldTypeString", "alias": "Meter Number", "length": 12, "domain": null }, { "name": "repaired", "type": "esriFieldTypeSmallInteger", "alias": "Repaired", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "depthavg", "type": "esriFieldTypeDouble", "alias": "Average Depth", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "length", "type": "esriFieldTypeSingle", "alias": "Length", "domain": null }, { "name": "maxhistoricalii", "type": "esriFieldTypeSingle", "alias": "MaxHistoricalII", "domain": null }, { "name": "pipelength", "type": "esriFieldTypeDouble", "alias": "Pipe Length", "domain": null }, { "name": "st_length(shape)", "type": "esriFieldTypeDouble", "alias": "st_length(shape)", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "i640facilityid", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r160_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a138_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "SewerPipeRepair", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B3E15017-D901-4E66-BDCD-2A0E9C680610}" }, { "id": 2, "name": "SewerPipeMaintenance", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A3832AD-AD17-441C-8100-CCACE478EBC8}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "st_length(shape)", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 4, "name": "Sewer Pressurized Mains", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Town of Dedham, MA Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 14999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 88, 230, 0, 255 ], "width": 3 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 737645.5079063922, "ymin": 2904567.263629645, "xmax": 751346.7436272204, "ymax": 2920769.083916232, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Cementitious Lining", "code": "CL" }, { "name": "Cobblestone", "code": "COB" }, { "name": "Brick & Block", "code": "BB" }, { "name": "Brick & Concrete", "code": "BC" }, { "name": "Concrete & Block", "code": "CB" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Stone", "code": "ST" }, { "name": "Block", "code": "BL" }, { "name": "Block & Stone", "code": "BLST" }, { "name": "Brick & Stone", "code": "BRST" }, { "name": "Stone & Concrete", "code": "STC" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "5\"", "code": 5 }, { "name": "21\"", "code": 21 }, { "name": "25\"", "code": 25 }, { "name": "27\"", "code": 27 }, { "name": "33\"", "code": 33 }, { "name": "35\"", "code": 35 }, { "name": "84\"", "code": 84 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "watertype", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "activeflag", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Dedham", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "downdepth", "type": "esriFieldTypeDouble", "alias": "DownDepth", "domain": null }, { "name": "updepth", "type": "esriFieldTypeDouble", "alias": "UpDepth", "domain": null }, { "name": "metered", "type": "esriFieldTypeSmallInteger", "alias": "Metered", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "meternumber", "type": "esriFieldTypeString", "alias": "MeterNumber", "length": 12, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "downelev", "type": "esriFieldTypeDouble", "alias": "DownElev", "domain": null }, { "name": "upelev", "type": "esriFieldTypeDouble", "alias": "UpElev", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Length", "domain": null }, { "name": "st_length(shape)", "type": "esriFieldTypeDouble", "alias": "st_length(shape)", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Length" }, "indexes": [ { "name": "r166_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a144_ix1", "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": 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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "st_length(shape)", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 5, "name": "Sewer Lateral Lines", "type": "Feature Layer", "description": "Separated and combined lateral lines.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "qaqc_rating", "uniqueValueGroups": [ { "heading": "QAQC Rating", "classes": [ { "label": "Good", "description": "Good", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 7 }, "values": [ [ "Good" ] ] }, { "label": "Poor", "description": "Poor", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 7 }, "values": [ [ "Poor" ] ] }, { "label": "Not Checked", "description": "Not Checked", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 78, 78, 78, 255 ], "width": 7 }, "values": [ [ "Not Checked" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 7 }, "value": "Good", "label": "Good" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 7 }, "value": "Poor", "label": "Poor" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 78, 78, 78, 255 ], "width": 7 }, "value": "Not Checked", "label": "Not Checked" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 192, 227, 255 ], "toColor": [ 252, 192, 227, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 191, 252, 179, 255 ], "toColor": [ 191, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 239, 252, 255 ], "toColor": [ 182, 239, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 223, 184, 255 ], "toColor": [ 252, 223, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 184, 252, 255 ], "toColor": [ 182, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 252, 210, 255 ], "toColor": [ 235, 252, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 216, 252, 255 ], "toColor": [ 212, 216, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 224, 255 ], "toColor": [ 182, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 188, 187, 255 ], "toColor": [ 252, 188, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 179, 252, 255 ], "toColor": [ 238, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 252, 179, 255 ], "toColor": [ 230, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 240, 204, 252, 255 ], "toColor": [ 240, 204, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 225, 212, 255 ], "toColor": [ 252, 225, 212, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 729317.3270562142, "ymin": 2904029.234850064, "xmax": 754400.9232143909, "ymax": 2925548.3578222245, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Cementitious Lining", "code": "CL" }, { "name": "Cobblestone", "code": "COB" }, { "name": "Brick & Block", "code": "BB" }, { "name": "Brick & Concrete", "code": "BC" }, { "name": "Concrete & Block", "code": "CB" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Stone", "code": "ST" }, { "name": "Block", "code": "BL" }, { "name": "Block & Stone", "code": "BLST" }, { "name": "Brick & Stone", "code": "BRST" }, { "name": "Stone & Concrete", "code": "STC" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "linetype", "type": "esriFieldTypeString", "alias": "Line Type", "length": 30, "domain": { "type": "codedValue", "name": "piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "Spiral Wound", "code": "SW" }, { "name": "Other", "code": "OTH" }, { "name": "None", "code": "NONE" }, { "name": "Cured in Place", "code": "CP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "locdesc", "type": "esriFieldTypeString", "alias": "Location Description", "length": 50, "domain": null }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "5\"", "code": 5 }, { "name": "21\"", "code": 21 }, { "name": "25\"", "code": 25 }, { "name": "27\"", "code": 27 }, { "name": "33\"", "code": 33 }, { "name": "35\"", "code": 35 }, { "name": "84\"", "code": 84 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "distance", "type": "esriFieldTypeInteger", "alias": "Distance", "domain": null }, { "name": "watertype", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "activeflag", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Dedham", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "tv_clockpos", "type": "esriFieldTypeSmallInteger", "alias": "TV_ClockPos", "domain": null }, { "name": "editsource", "type": "esriFieldTypeString", "alias": "EditSource", "length": 35, "domain": { "type": "codedValue", "name": "ssEditSource", "description": "Sewer Infrastructure Source Material", "codedValues": [ { "name": "TV Inspection", "code": "TV Inspection" }, { "name": "As Built", "code": "As Built" }, { "name": "Recorded Plan", "code": "Recorded Plan" }, { "name": "Field Observation", "code": "Field Observation" }, { "name": "MH Inspection Log", "code": "MH Inspection" }, { "name": "Aerial Photo", "code": "Aerial Photo" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Field Survey", "code": "Field Survey" }, { "name": "GPS", "code": "GPS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "editsourcedate", "type": "esriFieldTypeDate", "alias": "EditSourceDate", "length": 8, "domain": null }, { "name": "qaqc_rating", "type": "esriFieldTypeString", "alias": "QAQC Rating", "length": 15, "domain": { "type": "codedValue", "name": "QAQC_Rating", "description": "QA QC Rating Indicator", "codedValues": [ { "name": "Not Checked", "code": "Not Checked" }, { "name": "Poor", "code": "Poor" }, { "name": "Good", "code": "Good" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "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": "st_length(shape)", "type": "esriFieldTypeDouble", "alias": "st_length(shape)", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "r159_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_159", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a137_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "ssLateral_Inspections", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{433A1151-7670-4D49-9FE0-0A6B1993EC51}" }, { "id": 5, "name": "ssLateral_Repairs", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6E4DF0BF-8E8E-44D1-90D7-25939B11692F}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "st_length(shape)", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "Sewer Stubs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Town of Dedham, MA Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 88, 230, 0, 255 ], "width": 8 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 737507.8136279732, "ymin": 2904947.540100053, "xmax": 753651.5100150555, "ymax": 2925442.124438897, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 20, "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 20, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Cementitious Lining", "code": "CL" }, { "name": "Cobblestone", "code": "COB" }, { "name": "Brick & Block", "code": "BB" }, { "name": "Brick & Concrete", "code": "BC" }, { "name": "Concrete & Block", "code": "CB" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Stone", "code": "ST" }, { "name": "Block", "code": "BL" }, { "name": "Block & Stone", "code": "BLST" }, { "name": "Brick & Stone", "code": "BRST" }, { "name": "Stone & Concrete", "code": "STC" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "DIAMETER", "domain": null }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "OWNEDBY", "domain": null }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "MAINTBY", "domain": null }, { "name": "downelev", "type": "esriFieldTypeDouble", "alias": "DOWNELEV", "domain": null }, { "name": "upelev", "type": "esriFieldTypeDouble", "alias": "UPELEV", "domain": null }, { "name": "slope", "type": "esriFieldTypeDouble", "alias": "SLOPE", "domain": null }, { "name": "downdepth", "type": "esriFieldTypeDouble", "alias": "DOWNDEPTH", "domain": null }, { "name": "updepth", "type": "esriFieldTypeDouble", "alias": "UPDEPTH", "domain": null }, { "name": "enabled", "type": "esriFieldTypeSmallInteger", "alias": "ENABLED", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "metered", "type": "esriFieldTypeSmallInteger", "alias": "METERED", "domain": null }, { "name": "meternum", "type": "esriFieldTypeString", "alias": "METERNUM", "length": 15, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Length", "domain": null }, { "name": "st_length(shape)", "type": "esriFieldTypeDouble", "alias": "st_length(shape)", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Length" }, "indexes": [ { "name": "r158_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a136_ix1", "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": 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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "st_length(shape)", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 7, "name": "production.DBO.SewerManholeRepair", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "contractor", "type": "esriFieldTypeInteger", "alias": "Contractor", "domain": { "type": "codedValue", "name": "Sewer_Contractors", "description": "Sewer Tables", "codedValues": [ { "name": "National Water Main Cleaning Company", "code": 1 }, { "name": "Seven Trent Services", "code": 2 }, { "name": "New England Pipe Cleaning Service", "code": 3 }, { "name": "Pipeline Rehabilitation Services", "code": 4 }, { "name": "Podgurski Corporation", "code": 5 }, { "name": "EST", "code": 6 }, { "name": "Sewer Tech, Inc.", "code": 7 }, { "name": "Insituform", "code": 8 }, { "name": "Advanced Pipe Inspection", "code": 9 }, { "name": "Dedham DPW", "code": 10 }, { "name": "Municipal Sales", "code": 11 }, { "name": "T.J. Blume & Sons", "code": 12 }, { "name": "Green Mountain Pipeline Services", "code": 13 }, { "name": "Joseph DeFilippo Co., Inc.", "code": 14 }, { "name": "PJ Hayes Excavating Inc", "code": 15 }, { "name": "A. DiMartino", "code": 16 }, { "name": "RJV Construction", "code": 17 }, { "name": "After Hours Drain Service", "code": 18 }, { "name": "Arruda Trenchless Construction", "code": 19 }, { "name": "Rapid Flow", "code": 20 }, { "name": "Weston & Sampson", "code": 21 }, { "name": "P. Gioioso & Sons Inc.", "code": 22 }, { "name": "Duke's Root Control, Inc.", "code": 23 }, { "name": "Underground Testing and Service", "code": 24 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "contract", "type": "esriFieldTypeInteger", "alias": "Contract", "domain": { "type": "codedValue", "name": "Sewer_Repair_Contract", "description": "Sewer_Repair_Contract", "codedValues": [ { "name": "Infiltration Rehabilitatin Project Phase I, Contract 08-1", "code": 1 }, { "name": "Misc. Repair", "code": 2 }, { "name": "On-Call Sewer System Inspection & Maintenance Services, Contract #2", "code": 3 }, { "name": "2009 Sewer On-Call Services", "code": 4 }, { "name": "2012 Sewer On-Call Services", "code": 5 }, { "name": "2015 Sewer On-Call Services", "code": 6 }, { "name": "2018 Sewer On-Call Services", "code": 7 }, { "name": "2020 Sewer On-Call Services", "code": 8 }, { "name": "2021 Sewer On-Call Services", "code": 9 }, { "name": "2024 Sewer On-Call Services", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "repair", "type": "esriFieldTypeInteger", "alias": "Repair", "domain": { "type": "codedValue", "name": "Manhole_Repair", "description": "Sewer Manhole Repair", "codedValues": [ { "name": "Exterior Chemical Grout & Cementitious Lining", "code": 1 }, { "name": "Interior Cementitious Lining Only", "code": 3 }, { "name": "Repair Bench", "code": 4 }, { "name": "Repair Grade Adjustment", "code": 5 }, { "name": "Repair/Replace Casting", "code": 6 }, { "name": "Chemical Root Treatment", "code": 7 }, { "name": "Exterior Chemical Grout Only", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ii_removed", "type": "esriFieldTypeString", "alias": "II_Removed", "length": 50, "domain": null }, { "name": "all_ii_removed", "type": "esriFieldTypeSmallInteger", "alias": "All_II_Removed", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "repair_vertical_feet", "type": "esriFieldTypeInteger", "alias": "Repair_Vertical_Feet", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "newcondition", "type": "esriFieldTypeString", "alias": "NewCondition", "length": 20, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "manhole_id", "type": "esriFieldTypeString", "alias": "Manhole Identifier", "length": 50, "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 } ], "indexes": [ { "name": "i627manhole_id", "fields": "manhole_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r148_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_148", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ssManhole", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "Manhole_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BB2A2178-52E5-4C2D-9559-D3A7E78779C9}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 8, "name": "production.DBO.SewerPipeMaintenance", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "contractor", "type": "esriFieldTypeInteger", "alias": "Contractor", "domain": { "type": "codedValue", "name": "Sewer_Contractors", "description": "Sewer Tables", "codedValues": [ { "name": "National Water Main Cleaning Company", "code": 1 }, { "name": "Seven Trent Services", "code": 2 }, { "name": "New England Pipe Cleaning Service", "code": 3 }, { "name": "Pipeline Rehabilitation Services", "code": 4 }, { "name": "Podgurski Corporation", "code": 5 }, { "name": "EST", "code": 6 }, { "name": "Sewer Tech, Inc.", "code": 7 }, { "name": "Insituform", "code": 8 }, { "name": "Advanced Pipe Inspection", "code": 9 }, { "name": "Dedham DPW", "code": 10 }, { "name": "Municipal Sales", "code": 11 }, { "name": "T.J. Blume & Sons", "code": 12 }, { "name": "Green Mountain Pipeline Services", "code": 13 }, { "name": "Joseph DeFilippo Co., Inc.", "code": 14 }, { "name": "PJ Hayes Excavating Inc", "code": 15 }, { "name": "A. DiMartino", "code": 16 }, { "name": "RJV Construction", "code": 17 }, { "name": "After Hours Drain Service", "code": 18 }, { "name": "Arruda Trenchless Construction", "code": 19 }, { "name": "Rapid Flow", "code": 20 }, { "name": "Weston & Sampson", "code": 21 }, { "name": "P. Gioioso & Sons Inc.", "code": 22 }, { "name": "Duke's Root Control, Inc.", "code": 23 }, { "name": "Underground Testing and Service", "code": 24 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintenance_type", "type": "esriFieldTypeInteger", "alias": "Maintenance_Type", "domain": { "type": "codedValue", "name": "Sewer_Maintenance_Type", "description": "Sewer_Maintenance_Type", "codedValues": [ { "name": "Routine Cleaning", "code": 1 }, { "name": "Cleaning to Clear Blockage", "code": 2 }, { "name": "Root Cutting to Clear Blockage", "code": 3 }, { "name": "Other", "code": 4 }, { "name": "Pigging", "code": 5 }, { "name": "F.O.G. Cleaning", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintenance_reason", "type": "esriFieldTypeInteger", "alias": "Maintenance_Reason", "domain": { "type": "codedValue", "name": "Sewer_Maintenance_Reason", "description": "Sewer_Maintenance_Reason", "codedValues": [ { "name": "Private Property Backup", "code": 1 }, { "name": "Observed Main Line Backup", "code": 2 }, { "name": "Scheduled Maintenace", "code": 3 }, { "name": "Sewer Overflow (Public SSO)", "code": 4 }, { "name": "Other", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintenance_problem", "type": "esriFieldTypeInteger", "alias": "Maintenance_Problem", "domain": { "type": "codedValue", "name": "Sewer_Maintenance_Problem", "description": "Sewer_Maintenance_Problem", "codedValues": [ { "name": "Main Line Blockage (Roots)", "code": 1 }, { "name": "Main Line Blockage (Grease)", "code": 2 }, { "name": "Main Line Blockage (Collapse)", "code": 3 }, { "name": "Main Line Overflow (Wet Weather)", "code": 4 }, { "name": "Private Service Blockage", "code": 5 }, { "name": "Other", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "weather", "type": "esriFieldTypeInteger", "alias": "Weather", "domain": { "type": "codedValue", "name": "Weather", "description": "Weather", "codedValues": [ { "name": "Dry", "code": 1 }, { "name": "Light Rain/Melting", "code": 2 }, { "name": "Heavy Rain/Melting", "code": 3 }, { "name": "Unknown", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "pipe_id", "type": "esriFieldTypeString", "alias": "Pipe Identifier", "length": 50, "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 } ], "indexes": [ { "name": "i628pipe_id", "fields": "pipe_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r149_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_149", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "ssGravityMain", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Pipe_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A3832AD-AD17-441C-8100-CCACE478EBC8}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 9, "name": "production.DBO.SewerPipeRepair", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "contractor", "type": "esriFieldTypeInteger", "alias": "Contractor", "domain": { "type": "codedValue", "name": "Sewer_Contractors", "description": "Sewer Tables", "codedValues": [ { "name": "National Water Main Cleaning Company", "code": 1 }, { "name": "Seven Trent Services", "code": 2 }, { "name": "New England Pipe Cleaning Service", "code": 3 }, { "name": "Pipeline Rehabilitation Services", "code": 4 }, { "name": "Podgurski Corporation", "code": 5 }, { "name": "EST", "code": 6 }, { "name": "Sewer Tech, Inc.", "code": 7 }, { "name": "Insituform", "code": 8 }, { "name": "Advanced Pipe Inspection", "code": 9 }, { "name": "Dedham DPW", "code": 10 }, { "name": "Municipal Sales", "code": 11 }, { "name": "T.J. Blume & Sons", "code": 12 }, { "name": "Green Mountain Pipeline Services", "code": 13 }, { "name": "Joseph DeFilippo Co., Inc.", "code": 14 }, { "name": "PJ Hayes Excavating Inc", "code": 15 }, { "name": "A. DiMartino", "code": 16 }, { "name": "RJV Construction", "code": 17 }, { "name": "After Hours Drain Service", "code": 18 }, { "name": "Arruda Trenchless Construction", "code": 19 }, { "name": "Rapid Flow", "code": 20 }, { "name": "Weston & Sampson", "code": 21 }, { "name": "P. Gioioso & Sons Inc.", "code": 22 }, { "name": "Duke's Root Control, Inc.", "code": 23 }, { "name": "Underground Testing and Service", "code": 24 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "contract", "type": "esriFieldTypeInteger", "alias": "Contract", "domain": { "type": "codedValue", "name": "Sewer_Repair_Contract", "description": "Sewer_Repair_Contract", "codedValues": [ { "name": "Infiltration Rehabilitatin Project Phase I, Contract 08-1", "code": 1 }, { "name": "Misc. Repair", "code": 2 }, { "name": "On-Call Sewer System Inspection & Maintenance Services, Contract #2", "code": 3 }, { "name": "2009 Sewer On-Call Services", "code": 4 }, { "name": "2012 Sewer On-Call Services", "code": 5 }, { "name": "2015 Sewer On-Call Services", "code": 6 }, { "name": "2018 Sewer On-Call Services", "code": 7 }, { "name": "2020 Sewer On-Call Services", "code": 8 }, { "name": "2021 Sewer On-Call Services", "code": 9 }, { "name": "2024 Sewer On-Call Services", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "repair", "type": "esriFieldTypeInteger", "alias": "Repair", "domain": { "type": "codedValue", "name": "Sewer_Repair", "description": "Sewer_Repair", "codedValues": [ { "name": "CIPP", "code": 1 }, { "name": "Open Cut Replacement", "code": 2 }, { "name": "Open Cut Spot Repair", "code": 3 }, { "name": "Short Liner", "code": 4 }, { "name": "CITS", "code": 5 }, { "name": "Root Treatment", "code": 6 }, { "name": "Replace Wye or Chimney", "code": 7 }, { "name": "Cut Protruding Service", "code": 8 }, { "name": "Full Wrap Lateral Liner", "code": 9 }, { "name": "Top Hat Lateral Liner", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "entire_line_repaired", "type": "esriFieldTypeSmallInteger", "alias": "Entire_Line_Repaired", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ii_removed", "type": "esriFieldTypeString", "alias": "II_Removed", "length": 50, "domain": null }, { "name": "all_ii_removed", "type": "esriFieldTypeSmallInteger", "alias": "All_II_Removed", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "from_station", "type": "esriFieldTypeInteger", "alias": "From_Station", "domain": null }, { "name": "to_station", "type": "esriFieldTypeInteger", "alias": "To_Station", "domain": null }, { "name": "repair_length", "type": "esriFieldTypeInteger", "alias": "Repair_Length", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "newcondition", "type": "esriFieldTypeString", "alias": "NewCondition", "length": 20, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "pipe_id", "type": "esriFieldTypeString", "alias": "Pipe Identifier", "length": 50, "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 } ], "indexes": [ { "name": "i631pipe_id", "fields": "pipe_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r152_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_152", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "ssGravityMain", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Pipe_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B3E15017-D901-4E66-BDCD-2A0E9C680610}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 10, "name": "production.DBO.ssLateral_Inspections", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 35, "domain": null }, { "name": "inspectiondate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "addressstreet", "type": "esriFieldTypeString", "alias": "Address - Street", "length": 50, "domain": null }, { "name": "dsstation", "type": "esriFieldTypeSmallInteger", "alias": "Downstream Station", "domain": null }, { "name": "clockposds", "type": "esriFieldTypeSmallInteger", "alias": "Clock Position (downstream)", "domain": null }, { "name": "unconfirmedflow", "type": "esriFieldTypeInteger", "alias": "Unconfirmed Flow", "domain": null }, { "name": "confirmedii", "type": "esriFieldTypeInteger", "alias": "Confirmed I/I", "domain": null }, { "name": "needsdig", "type": "esriFieldTypeString", "alias": "Needs Dig Repair?", "length": 10, "domain": null }, { "name": "needsaddinv", "type": "esriFieldTypeString", "alias": "Needs Additional Investigation?", "length": 10, "domain": null }, { "name": "sewermainid", "type": "esriFieldTypeString", "alias": "Sewer Main ID", "length": 20, "domain": null }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter (in)", "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": null }, { "name": "esttotallength", "type": "esriFieldTypeSmallInteger", "alias": "Estimated Total Length (ft)", "domain": null }, { "name": "iicomment", "type": "esriFieldTypeString", "alias": "I/I Comments", "length": 250, "domain": null }, { "name": "strcomment", "type": "esriFieldTypeString", "alias": "Structural Comments", "length": 250, "domain": null }, { "name": "roots", "type": "esriFieldTypeSmallInteger", "alias": "Roots Observed?", "domain": null }, { "name": "letter", "type": "esriFieldTypeSmallInteger", "alias": "Send Structural Letter?", "domain": null }, { "name": "condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": null }, { "name": "spr", "type": "esriFieldTypeSmallInteger", "alias": "SPR", "domain": null }, { "name": "mpr", "type": "esriFieldTypeSmallInteger", "alias": "MPR", "domain": null }, { "name": "opr", "type": "esriFieldTypeSmallInteger", "alias": "OPR", "domain": null }, { "name": "pacp_opri", "type": "esriFieldTypeDouble", "alias": "PACP OPRI", "domain": null }, { "name": "opri_plf", "type": "esriFieldTypeDouble", "alias": "OPRI PLF", "domain": null }, { "name": "has90", "type": "esriFieldTypeSmallInteger", "alias": "Has 90?", "domain": null }, { "name": "sump", "type": "esriFieldTypeString", "alias": "Sump?", "length": 10, "domain": null }, { "name": "relatefield", "type": "esriFieldTypeString", "alias": "RELATEFIELD", "length": 50, "domain": null }, { "name": "reportnumber", "type": "esriFieldTypeString", "alias": "Report Number", "length": 15, "domain": null }, { "name": "projectid", "type": "esriFieldTypeString", "alias": "PROJECTID", "length": 20, "domain": null }, { "name": "gishyperlink", "type": "esriFieldTypeString", "alias": "GISHYPERLINK", "length": 250, "domain": null }, { "name": "fieldhyperlink", "type": "esriFieldTypeString", "alias": "FIELDHYPERLINK", "length": 250, "domain": null }, { "name": "parentgui", "type": "esriFieldTypeGUID", "alias": "PARENTGUI", "length": 38, "domain": null }, { "name": "comm_res4", "type": "esriFieldTypeString", "alias": "Commercial vs Residential <4", "length": 20, "domain": null }, { "name": "addressno", "type": "esriFieldTypeString", "alias": "Address - Number", "length": 30, "domain": null }, { "name": "yearlastpaved", "type": "esriFieldTypeString", "alias": "Year Last Paved", "length": 25, "domain": null }, { "name": "futurepaving", "type": "esriFieldTypeString", "alias": "Future Planned Paving", "length": 25, "domain": null }, { "name": "lengthinspected", "type": "esriFieldTypeDouble", "alias": "Length Inspected (ft)", "domain": null }, { "name": "videofolder", "type": "esriFieldTypeString", "alias": "VIDEO FOLDER", "length": 15, "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 } ], "indexes": [ { "name": "i633facilityid", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r154_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "ssLateralLine", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{433A1151-7670-4D49-9FE0-0A6B1993EC51}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 11, "name": "production.DBO.ssLateral_Repairs", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 35, "domain": null }, { "name": "date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 50, "domain": null }, { "name": "contract", "type": "esriFieldTypeString", "alias": "Contract", "length": 50, "domain": null }, { "name": "repair", "type": "esriFieldTypeString", "alias": "Repair", "length": 50, "domain": null }, { "name": "repair_length", "type": "esriFieldTypeInteger", "alias": "Repair_Length", "domain": null }, { "name": "from_station_start_main", "type": "esriFieldTypeInteger", "alias": "From Station (main to bldg)", "domain": null }, { "name": "to_station_start_main", "type": "esriFieldTypeInteger", "alias": "To Station (main to bldg)", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "ii_removed", "type": "esriFieldTypeInteger", "alias": "II_Removed", "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 } ], "indexes": [ { "name": "i632facilityid", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r153_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "ssLateralLine", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6E4DF0BF-8E8E-44D1-90D7-25939B11692F}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 12, "name": "production.DBO.ssManholeInspection", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "reportnum", "type": "esriFieldTypeString", "alias": "Report Number", "length": 20, "domain": null }, { "name": "structdefect", "type": "esriFieldTypeString", "alias": "Structural Defects", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ii", "type": "esriFieldTypeString", "alias": "II", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ii_amount", "type": "esriFieldTypeDouble", "alias": "II Amount", "domain": null }, { "name": "inspectdate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeInteger", "alias": "Inspector", "domain": { "type": "codedValue", "name": "Sewer_Contractors", "description": "Sewer Tables", "codedValues": [ { "name": "National Water Main Cleaning Company", "code": 1 }, { "name": "Seven Trent Services", "code": 2 }, { "name": "New England Pipe Cleaning Service", "code": 3 }, { "name": "Pipeline Rehabilitation Services", "code": 4 }, { "name": "Podgurski Corporation", "code": 5 }, { "name": "EST", "code": 6 }, { "name": "Sewer Tech, Inc.", "code": 7 }, { "name": "Insituform", "code": 8 }, { "name": "Advanced Pipe Inspection", "code": 9 }, { "name": "Dedham DPW", "code": 10 }, { "name": "Municipal Sales", "code": 11 }, { "name": "T.J. Blume & Sons", "code": 12 }, { "name": "Green Mountain Pipeline Services", "code": 13 }, { "name": "Joseph DeFilippo Co., Inc.", "code": 14 }, { "name": "PJ Hayes Excavating Inc", "code": 15 }, { "name": "A. DiMartino", "code": 16 }, { "name": "RJV Construction", "code": 17 }, { "name": "After Hours Drain Service", "code": 18 }, { "name": "Arruda Trenchless Construction", "code": 19 }, { "name": "Rapid Flow", "code": 20 }, { "name": "Weston & Sampson", "code": 21 }, { "name": "P. Gioioso & Sons Inc.", "code": 22 }, { "name": "Duke's Root Control, Inc.", "code": 23 }, { "name": "Underground Testing and Service", "code": 24 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "reportlink", "type": "esriFieldTypeString", "alias": "Report Link", "length": 250, "domain": null }, { "name": "fieldlink", "type": "esriFieldTypeString", "alias": "Field Link", "length": 250, "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": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "i629facilityid", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r150_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_150", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "geobase.DBO.ssManhole", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2AD02B24-5A94-4CD4-9320-6F2E0BB31DF4}" } ], "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }