{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Sewer Taps", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": -7927798.848946623, "ymin": 5193457.976287248, "xmax": -7918952.8939064825, "ymax": 5202321.952921316, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ACTIVEFLAG", "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": [ 219, 252, 207, 255 ], "toColor": [ 219, 252, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 244, 179, 252, 255 ], "toColor": [ 244, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 188, 182, 255 ], "toColor": [ 252, 188, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 216, 252, 255 ], "toColor": [ 179, 216, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 252, 250, 255 ], "toColor": [ 189, 252, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 215, 252, 255 ], "toColor": [ 247, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 232, 212, 255 ], "toColor": [ 252, 232, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 187, 252, 255 ], "toColor": [ 197, 187, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 252, 179, 255 ], "toColor": [ 188, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 211, 255 ], "toColor": [ 252, 179, 211, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 233, 179, 255 ], "toColor": [ 252, 233, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 204, 220, 255 ], "toColor": [ 252, 204, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 236, 252, 255 ], "toColor": [ 210, 236, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "ACTIVEFLAG", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROTATION" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "CRITICAL" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ACTIVEFLAG" }, { "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": "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "EditSource", "type": "esriFieldTypeString", "alias": "EditSource", "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" }, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "EditSource" }, { "name": "EditSourceDate", "type": "esriFieldTypeDate", "alias": "EditSourceDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditSourceDate" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Description" }, { "name": "TVDistance", "type": "esriFieldTypeDouble", "alias": "TVDistance", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TVDistance" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "S91_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [ { "id": 0, "name": "False", "domains": { "CRITICAL": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "EditSource": {"type": "inherited"} }, "templates": [ { "name": "0", "description": "", "prototype": { "attributes": { "TVDistance": null, "Description": null, "FACILITYID": null, "INSTALLDATE": null, "LOCDESC": null, "ROTATION": null, "CRITICAL": 0, "ENABLED": 1, "ACTIVEFLAG": 0, "OWNEDBY": 1, "MAINTBY": 1, "EditSource": null, "EditSourceDate": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": 1, "name": "True", "domains": { "CRITICAL": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "EditSource": {"type": "inherited"} }, "templates": [ { "name": "1", "description": "", "prototype": { "attributes": { "TVDistance": null, "Description": null, "FACILITYID": null, "INSTALLDATE": null, "LOCDESC": null, "ROTATION": null, "CRITICAL": 0, "ENABLED": 1, "ACTIVEFLAG": 1, "OWNEDBY": 1, "MAINTBY": 1, "EditSource": null, "EditSourceDate": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Sewer Network Structures", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 7999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "Town of Dedham, MA Engineering Department", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": -7929266.4197655115, "ymin": 5194794.226668649, "xmax": -7919205.73354983, "ymax": 5202107.865883154, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "STRUCTTYPE", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "ee76774cc0e4b1ff17756ecd5d117ba6", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABH0lEQVQ4jbXPPUvDcBDH8W8etKlWKypituJYHURQqJMIAX0RFdzdHBSRQmdxdhJEQUHdHLpKX0C3LlWwQ6DFotBBrG0aHf6DYPzHPNSbDu7uw+90Blj6f2KZCIYNOF5M1x6ZM58DM0/NND1nHqh7sdlJjftjMzC2ttugZn9nkS6+f8DRteiNYTCnYHMZptPSEx+sC6cluDqEThcqD2DtwcU+LGRCYgCKCqtZ0a8vilTFc7gpRMB+lrUEhTNwP0FVYmITKXD68NaBsWRMrNWGZAJSxq/jcNhtWbyqeF/8G3NdOLmDngPVOtRsuDyQrsuxUQOKW6IfH4G8BbksaGoELDEE2xu+wf2xxgus7AS/br7OyLG+q2C3QqWRYzFroNgXmMk/4GsuK4sAAAAASUVORK5CYII=", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Discharge Structure", "label": "Discharge Structure" }, { "symbol": { "type": "esriPMS", "url": "12053e7266e873f7c7e738d5acfe0593", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABHklEQVQ4jb3UMSjEURgA8F/uxKTMtzBQJhYjRouJyUwWYlMYKExMlIldOiEMyiKlJJHJIG6TJLm6DJwz3P/qOn93/3T5ttf7+r33fd/rxVUp4v8JJVCL1F+hBKbQhU9cYREPUaEC0I0lTOALA0jiOgDvf4MaMY8eLAdAtmg/iW30Yws3mMFjKdQe3KYXDWjBWyExiBz2cY7p4NDNsNKeMIlOPKMNIzgpymnFXFBiaGnFMYtjNOEAoyXYj6g0/hT6omBR3lEBO8Q76nFbCWrGoHyTS7EO1AXrGFZxFwZd4BRn2MAaMkX7H6jBEMawh6MwKIMFrGAcl1gPwCyG5fu0K//aX8qVBukQMIedMKAcFAbG8FomN9LU0hFyqvcffQOQbkYgd1R7LQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Grease Separator", "label": "Grease Separator" }, { "symbol": { "type": "esriPMS", "url": "319bf0a832a0087916efa17998e81e3a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAATCAYAAACORR0GAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABFklEQVQ4jc3UMWvCQBjG8f8gIrgIzoo4lnSRLg5xcpGTQkG/QEAQ41fIJ3AzQybdnUVwEcSlU+kipFDIoEuWIjpJpw63pGDkyh3VZ7uD9/1x9x6X4Z+SuRVUBOqGen8Br2nQIyDGY150hOORT8/jADynQQBvnQ59HQj48Dy+kxs3m1FqZjMIQxACLAtGI6jVoN02DMUxOA5MJhBF0O3CfA7NJuRyBqFsFsplKBRk4+0WBgO5rxJlKIrkiSxLXlcQgOvCdGoYqlblXABWKxgOYbmE/R4qFYNQMucz+D7sdmDbajXKUPJ1CQGbDbRakM8bhkql3+tGQ7Xyj5BuLkH9Xk+v6enEA/B+DVoDT4uFHnQp9/fX6eYHnHw8rP8R8YgAAAAASUVORK5CYII=", "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": [ 118, 176, 97, 255 ], "toColor": [ 118, 176, 97, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 148, 74, 189, 255 ], "toColor": [ 148, 74, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 88, 82, 255 ], "toColor": [ 204, 88, 82, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 93, 186, 240, 255 ], "toColor": [ 93, 186, 240, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 194, 94, 255 ], "toColor": [ 247, 194, 94, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 132, 250, 232, 255 ], "toColor": [ 132, 250, 232, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 186, 125, 162, 255 ], "toColor": [ 186, 125, 162, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 86, 140, 130, 255 ], "toColor": [ 86, 140, 130, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 140, 113, 66, 255 ], "toColor": [ 140, 113, 66, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 61, 91, 145, 255 ], "toColor": [ 61, 91, 145, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 237, 85, 255 ], "toColor": [ 194, 237, 85, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 98, 245, 125, 255 ], "toColor": [ 98, 245, 125, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 97, 102, 242, 255 ], "toColor": [ 97, 102, 242, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "STRUCTTYPE", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "STRUCTTYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STRUCTTYPE" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "NAME" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "OPDATE", "type": "esriFieldTypeDate", "alias": "Operational Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OPDATE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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": "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R119_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S90_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [ { "id": "Discharge Structure", "name": "Discharge Structure", "domains": { "STRUCTTYPE": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "AncillaryRole": {"type": "inherited"}, "EditSource": {"type": "inherited"} }, "templates": [ { "name": "Discharge Structure", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "OPDATE": null, "OWNEDBY": 1, "NAME": null, "STRUCTTYPE": "Discharge Structure", "LOCDESC": null, "MAINTBY": 1 } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "Grease Separator", "name": "Grease Separator", "domains": { "STRUCTTYPE": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "AncillaryRole": {"type": "inherited"}, "EditSource": {"type": "inherited"} }, "templates": [ { "name": "Grease Separator", "description": "", "prototype": { "attributes": { "MAINTBY": 1, "OWNEDBY": 1, "INSTALLDATE": null, "STRUCTTYPE": "Grease Separator", "NAME": null, "LOCDESC": null, "OPDATE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "Pump Station", "name": "Pump Station", "domains": { "STRUCTTYPE": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "AncillaryRole": {"type": "inherited"}, "EditSource": {"type": "inherited"} }, "templates": [ { "name": "Pump Station", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "OPDATE": null, "OWNEDBY": 1, "NAME": null, "STRUCTTYPE": "Pump Station", "LOCDESC": null, "MAINTBY": 1 } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Sewer Manholes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 7999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "Town of Dedham, MA Engineering Department", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "production.DBO.ssManholeToInspection", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": -7928145.404591568, "ymin": 5193455.555283901, "xmax": -7918951.245269182, "ymax": 5202324.15003426, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "6e47c6627d6c3f68581de40fe3918b47", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACZElEQVQ4jb3UTUjTYRzA8e9/r7Y1Uwemh8lgL0xFRBFDYRASkTjCFApFEgYdWjDEg4cwgkJRPIUHDx66hvg3FYNI8A0niBUJHsKUiZhbbDr7T4vNv1sHDbLGUJB+p+fheX6f3/PGo+ICQ/W/MTtwFZCAz0DsvJi6uJiuQIBHBgOaUAiVycTh5iZJo5E3W1t4gOBZsCsFBby3WLCMjSFYLGC1wswMar0e+vq409/P9b09bgAf02GCycScRoO1uhosltODBgPU18PQENmJBO8kiRIgkBLLyqLFbMYxOQkNDaDVQk2NAkkSmJ0Fu/2I5mYYGQFR5HJvL70HB9xPien1tHd2otFqQRShrExHMOhGFO+ytDSHx/OM6ek4RUVgMqHt7qYBeMDJpZzCIhHsNhsEgxAOK6iquk1PTz8ATqcTQVCwvv6c3NyfAOTn88PvxwEs/4PF42hra4/bsZgCr7fy1JmVll6jpUUmM/O4v71NNpCZcpsZGXz3+cgxGiEahaamt3i9XpRKJQDDw69YWLiE2Xz4e2XhYJBvKTFBYGpigvrWVlRrazKrqz5crluUl1eysrKM3++jokLC7YaNDZLhMACrKbFolJ6ODmqsVnLcbhDFAxyORWy2OaamMsjLk6irA7UaBgfZkGUG/sz/+5192N1lwOnk8fw8QkkJQBSVCnS6ODodjI+D1UpsZ4evwIt0GLLME4WCI5eLh11dKBsbyQHY34fRUXbb29kLhfiSTHIPiKfFgGQiwdNIhNceD962Nm7KMsbCQvZlmUXgJSCmyEv7a3wC3PGT2olEmplnwM4dF4r9Ar1uzELbm/6iAAAAAElFTkSuQmCC", "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" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "domain": null, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MHTYPE" }, { "name": "MHDiameter", "type": "esriFieldTypeSmallInteger", "alias": "Access Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MHDiameter" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Buried" }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "WALLMAT" }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LINED" }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT" }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERTELEV" }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIMELEV" }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HIGHELEV" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Manhole Condition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CONDITION" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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": "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "YearLastInspected", "type": "esriFieldTypeString", "alias": "Year Last Inspected", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "YearLastInspected" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CVTYPE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R115_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G319FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S86_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Manhole", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "Comments": null, "OWNEDBY": 1, "YearLastInspected": null, "CVTYPE": null, "MAINTBY": 1, "LOCDESC": null, "MHTYPE": null, "MHDiameter": null, "Buried": null, "WALLMAT": null, "LINED": null, "INVERT": null, "INVERTELEV": null, "RIMELEV": null, "HIGHELEV": null, "CONDITION": null } }, "drawingTool": "esriFeatureEditToolPoint" }, { "name": "Manhole and Connect to Closest", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "Comments": null, "OWNEDBY": 1, "YearLastInspected": null, "CVTYPE": null, "MAINTBY": 1, "LOCDESC": null, "MHTYPE": null, "MHDiameter": null, "Buried": null, "WALLMAT": null, "LINED": null, "INVERT": null, "INVERTELEV": null, "RIMELEV": null, "HIGHELEV": null, "CONDITION": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Sewer Gravity Mains", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 14999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "Town of Dedham, MA Engineering Department", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "production.DBO.ssManholeToInspection", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "composite": false }, { "id": 2, "name": "production.DBO.ssManholeToInspection", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -7927810.804483583, "ymin": 5193455.555283901, "xmax": -7918951.245269182, "ymax": 5202323.0386105385, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "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", "allowOverrun": false, "repeatLabel": false, "deconflictionStrategy": "dynamic", "removeDuplicates": "all", "removeDuplicatesDistance": 216, "lineConnection": "none", "multiPart": "labelPerFeature", "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" } } } ] }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINSHAPE" }, { "name": "LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "LINEDYEAR" }, { "name": "LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "NONE", "modelName": "LINERTYPE" }, { "name": "FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "FROMMH" }, { "name": "TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "TOMH" }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WATERTYPE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ACTIVEFLAG" }, { "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": "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUMFLOW" }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNELEV" }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPELEV" }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SLOPE" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Pipe Condition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CONDITION" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TV_Inspected" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "II" }, { "name": "YearLastInspected", "type": "esriFieldTypeString", "alias": "Year Last Inspected", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "YearLastInspected" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Metered" }, { "name": "MeterNumber", "type": "esriFieldTypeString", "alias": "Meter Number", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "MeterNumber" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Repaired" }, { "name": "DepthAvg", "type": "esriFieldTypeDouble", "alias": "Average Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DepthAvg" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R125_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G329FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S96_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Ductile Iron Sewer", "description": "A Ductile Iron Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MATERIAL": "DIP", "DIAMETER": null, "MAINSHAPE": null, "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "8\" PVC Sewer", "description": "A 8\" PVC Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "DIAMETER": 8, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "12\" PVC Sewer", "description": "A 12\" PVC Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "DIAMETER": 12, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "18\" PVC Sewer", "description": "A 18\" PVC Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "DIAMETER": 18, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "24\" PVC Sewer", "description": "A 24\" PVC Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "DIAMETER": 24, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "27\" PVC Sewer", "description": "A 27\" PVC Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "DIAMETER": 27, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "12\" Ductile Iron Sewer", "description": "A 12\" PVC Ductile Iron Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "DIAMETER": 12, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "18\" Ductile Iron Sewer", "description": "A 18\" Ductile Iron Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "DIAMETER": 18, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "24\" Ductile Iron Sewer", "description": "A 24\" Ductile Iron Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "DIAMETER": 24, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "27\" Ductile Iron Sewer", "description": "A 27\" Ductile Iron Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "DIAMETER": 27, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "8\" Ductile Iron Sewer", "description": "A 8\" Ductile Iron Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "DIAMETER": 8, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "12\" Reinforced Conrete Sewer", "description": "A 12\" Reinforced Conrete Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "RCP", "DIAMETER": 12, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "18\" Reinforced Conrete Sewer", "description": "A 18\" Reinforced Conrete Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "RCP", "DIAMETER": 18, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "24\" Reinforced Conrete Sewer", "description": "A 24\" Reinforced Conrete Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "RCP", "DIAMETER": 24, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "27\" Reinforced Conrete Sewer", "description": "A 27\" Reinforced Conrete Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "RCP", "DIAMETER": 27, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "8\" Reinforced Conrete Sewer", "description": "A 8\" Reinforced Conrete Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "MATERIAL": "RCP", "DIAMETER": 8, "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MAINSHAPE": "Circular", "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "PVC Sewer", "description": "A PVC Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MATERIAL": "PVC", "DIAMETER": null, "MAINSHAPE": null, "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "Reinforced Concrete Sewer", "description": "A Reinforced Concrete Sewer Gravity Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "TOMH": null, "WATERTYPE": "Sewage", "LINEDYEAR": null, "MeterNumber": null, "II": null, "Metered": null, "Repaired": null, "YearLastInspected": null, "DepthAvg": null, "FACILITYID": null, "MATERIAL": "RCP", "DIAMETER": null, "MAINSHAPE": null, "LINERTYPE": "NONE", "FROMMH": null, "MAINTBY": 1, "SUMFLOW": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "Comments": null, "LOCDESC": null, "CONDITION": null, "TV_Inspected": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "Sewer Pressurized Mains", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 14999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "Town of Dedham, MA Engineering Department", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -7925859.481978259, "ymin": 5193670.247394567, "xmax": -7920201.563475916, "ymax": 5200359.976603842, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 88, 230, 0, 255 ], "width": 3 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WATERTYPE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ACTIVEFLAG" }, { "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": "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "DownDepth", "type": "esriFieldTypeDouble", "alias": "DownDepth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DownDepth" }, { "name": "UpDepth", "type": "esriFieldTypeDouble", "alias": "UpDepth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UpDepth" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Metered" }, { "name": "MeterNumber", "type": "esriFieldTypeString", "alias": "MeterNumber", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "MeterNumber" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" }, { "name": "DownElev", "type": "esriFieldTypeDouble", "alias": "DownElev", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DownElev" }, { "name": "UpElev", "type": "esriFieldTypeDouble", "alias": "UpElev", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UpElev" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R123_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S94_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "(Empty Values)", "description": "A Pressurized Sewer Main with no values set.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "WATERTYPE": null, "UpElev": null, "FACILITYID": null, "INSTALLDATE": null, "MATERIAL": null, "DIAMETER": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "8\" PVC Sewer", "description": "A 8\" PVC Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 8, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "12\" PVC Sewer", "description": "A 12\" PVC Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 12, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "18\" PVC Sewer", "description": "A 18\" PVC Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 18, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "24\" PVC Sewer", "description": "A 24\" PVC Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 24, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "27\" PVC Sewer", "description": "A 27\" PVC Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 27, "WATERTYPE": "Sewage", "MATERIAL": "PVC", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "12\" Ductile Iron Sewer", "description": "A 12\" Ductile Iron Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 12, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "18\" Ductile Iron Sewer", "description": "A 18\" Ductile Iron Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 18, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "24\" Ductile Iron Sewer", "description": "A 24\" Ductile Iron Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 24, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "27\" Ductile Iron Sewer", "description": "A 27\" Ductile Iron Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 27, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "8\" Ductile Iron Sewer", "description": "A 8\" Ductile Iron Pressurized Sewer Main.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "INSTALLDATE": null, "DIAMETER": 8, "WATERTYPE": "Sewage", "MATERIAL": "DIP", "UpElev": null, "FACILITYID": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "Sewer", "description": "A Pressurized Sewer Main with no values set.", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": 1, "DIAMETER": 0.75, "WATERTYPE": "Sewage", "MATERIAL": null, "UpElev": null, "FACILITYID": null, "INSTALLDATE": null, "MAINTBY": 1, "DownDepth": null, "UpDepth": null, "Metered": null, "MeterNumber": null, "Comments": null, "DownElev": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "Sewer Lateral Lines", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "Separated and combined lateral lines.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "production.DBO.ssLateral_Inspections", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -7929270.73371456, "ymin": 5193426.080731459, "xmax": -7918937.2056119535, "ymax": 5202344.339585253, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "QAQC_Rating", "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": [ 219, 252, 207, 255 ], "toColor": [ 219, 252, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 244, 179, 252, 255 ], "toColor": [ 244, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 188, 182, 255 ], "toColor": [ 252, 188, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 216, 252, 255 ], "toColor": [ 179, 216, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 252, 250, 255 ], "toColor": [ 189, 252, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 215, 252, 255 ], "toColor": [ 247, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 232, 212, 255 ], "toColor": [ 252, 232, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 187, 252, 255 ], "toColor": [ 197, 187, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 252, 179, 255 ], "toColor": [ 188, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 211, 255 ], "toColor": [ 252, 179, 211, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 233, 179, 255 ], "toColor": [ 252, 233, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 204, 220, 255 ], "toColor": [ 252, 204, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 236, 252, 255 ], "toColor": [ 210, 236, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "QAQC_Rating", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "LINETYPE", "type": "esriFieldTypeString", "alias": "Line Type", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LINETYPE" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCDESC" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "DISTANCE", "type": "esriFieldTypeInteger", "alias": "Distance", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISTANCE" }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WATERTYPE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ACTIVEFLAG" }, { "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": "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": -1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": -1, "modelName": "MAINTBY" }, { "name": "TV_ClockPos", "type": "esriFieldTypeSmallInteger", "alias": "TV_ClockPos", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TV_ClockPos" }, { "name": "EditSource", "type": "esriFieldTypeString", "alias": "EditSource", "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" }, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "EditSource" }, { "name": "EditSourceDate", "type": "esriFieldTypeDate", "alias": "EditSourceDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditSourceDate" }, { "name": "QAQC_Rating", "type": "esriFieldTypeString", "alias": "QAQC Rating", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "Not Checked", "modelName": "QAQC_Rating" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R118_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_118", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S89_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [ { "id": "Good", "name": "Good", "domains": { "MATERIAL": {"type": "inherited"}, "LINETYPE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "WATERTYPE": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "EditSource": {"type": "inherited"}, "QAQC_Rating": {"type": "inherited"} }, "templates": [ { "name": "Good", "description": "", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": -1, "WATERTYPE": null, "EditSourceDate": null, "Comments": null, "FACILITYID": null, "INSTALLDATE": null, "MATERIAL": null, "LINETYPE": null, "LOCDESC": null, "DIAMETER": null, "DISTANCE": null, "MAINTBY": -1, "TV_ClockPos": null, "EditSource": null, "QAQC_Rating": "Good" } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "Poor", "name": "Poor", "domains": { "MATERIAL": {"type": "inherited"}, "LINETYPE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "WATERTYPE": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "EditSource": {"type": "inherited"}, "QAQC_Rating": {"type": "inherited"} }, "templates": [ { "name": "Poor", "description": "", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": -1, "WATERTYPE": null, "EditSourceDate": null, "Comments": null, "FACILITYID": null, "INSTALLDATE": null, "MATERIAL": null, "LINETYPE": null, "LOCDESC": null, "DIAMETER": null, "DISTANCE": null, "MAINTBY": -1, "TV_ClockPos": null, "EditSource": null, "QAQC_Rating": "Poor" } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "Not Checked", "name": "Not Checked", "domains": { "MATERIAL": {"type": "inherited"}, "LINETYPE": {"type": "inherited"}, "DIAMETER": {"type": "inherited"}, "WATERTYPE": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "ACTIVEFLAG": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "MAINTBY": {"type": "inherited"}, "EditSource": {"type": "inherited"}, "QAQC_Rating": {"type": "inherited"} }, "templates": [ { "name": "Not Checked", "description": "", "prototype": { "attributes": { "ACTIVEFLAG": 1, "ENABLED": 1, "OWNEDBY": -1, "WATERTYPE": null, "EditSourceDate": null, "Comments": null, "FACILITYID": null, "INSTALLDATE": null, "MATERIAL": null, "LINETYPE": null, "LOCDESC": null, "DIAMETER": null, "DISTANCE": null, "MAINTBY": -1, "TV_ClockPos": null, "EditSource": null, "QAQC_Rating": "Not Checked" } }, "drawingTool": "esriFeatureEditToolLine" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "Sewer Stubs", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "Town of Dedham, MA Engineering Department", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -7925915.577127606, "ymin": 5193806.160475547, "xmax": -7919245.640843978, "ymax": 5202289.205170782, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 88, 230, 0, 255 ], "width": 8 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "DIAMETER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "OWNEDBY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OWNEDBY" }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "MAINTBY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAINTBY" }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "DOWNELEV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNELEV" }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "UPELEV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPELEV" }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "SLOPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SLOPE" }, { "name": "DOWNDEPTH", "type": "esriFieldTypeDouble", "alias": "DOWNDEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNDEPTH" }, { "name": "UPDEPTH", "type": "esriFieldTypeDouble", "alias": "UPDEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPDEPTH" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "name": "METERED", "type": "esriFieldTypeSmallInteger", "alias": "METERED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERED" }, { "name": "METERNUM", "type": "esriFieldTypeString", "alias": "METERNUM", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "METERNUM" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R124_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S95_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Sewer Stubs", "description": "", "prototype": { "attributes": { "METERED": null, "METERNUM": null, "FACILITYID": null, "MATERIAL": null, "DIAMETER": null, "OWNEDBY": null, "MAINTBY": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "DOWNDEPTH": null, "UPDEPTH": null, "ENABLED": 1 } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 7, "name": "production.DBO.SewerManholeRepair", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Contractor", "type": "esriFieldTypeInteger", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Contractor" }, { "name": "Contract", "type": "esriFieldTypeInteger", "alias": "Contract", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Contract" }, { "name": "Repair", "type": "esriFieldTypeInteger", "alias": "Repair", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Repair" }, { "name": "II_Removed", "type": "esriFieldTypeString", "alias": "II_Removed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "II_Removed" }, { "name": "All_II_Removed", "type": "esriFieldTypeSmallInteger", "alias": "All_II_Removed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "All_II_Removed" }, { "name": "Repair_Vertical_Feet", "type": "esriFieldTypeInteger", "alias": "Repair_Vertical_Feet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Repair_Vertical_Feet" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "NewCondition", "type": "esriFieldTypeString", "alias": "NewCondition", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "NewCondition" }, { "name": "Manhole_ID", "type": "esriFieldTypeString", "alias": "Manhole Identifier", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "Manhole_ID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R225_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "production.DBO.SewerManholeRepair", "description": "", "prototype": { "attributes": { "last_edited_user": null, "last_edited_date": null, "Date": null, "Contractor": null, "Contract": null, "Repair": null, "II_Removed": null, "All_II_Removed": null, "Repair_Vertical_Feet": null, "Comments": null, "NewCondition": null, "Manhole_ID": " ", "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 8, "name": "production.DBO.SewerPipeMaintenance", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "production.DBO.ssGravityMain", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Pipe_ID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Contractor", "type": "esriFieldTypeInteger", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Contractor" }, { "name": "Maintenance_Type", "type": "esriFieldTypeInteger", "alias": "Maintenance_Type", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Maintenance_Type" }, { "name": "Maintenance_Reason", "type": "esriFieldTypeInteger", "alias": "Maintenance_Reason", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Maintenance_Reason" }, { "name": "Maintenance_Problem", "type": "esriFieldTypeInteger", "alias": "Maintenance_Problem", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Maintenance_Problem" }, { "name": "Weather", "type": "esriFieldTypeInteger", "alias": "Weather", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Weather" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "Pipe_ID", "type": "esriFieldTypeString", "alias": "Pipe Identifier", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "Pipe_ID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R226_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_491_Pipe_ID", "fields": "Pipe_ID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "production.DBO.SewerPipeMaintenance", "description": "", "prototype": { "attributes": { "last_edited_user": null, "last_edited_date": null, "Date": null, "Contractor": null, "Maintenance_Type": null, "Maintenance_Reason": null, "Maintenance_Problem": null, "Weather": null, "Comments": null, "Pipe_ID": " ", "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 9, "name": "production.DBO.SewerPipeRepair", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "production.DBO.ssGravityMain", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Pipe_ID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Contractor", "type": "esriFieldTypeInteger", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Contractor" }, { "name": "Contract", "type": "esriFieldTypeInteger", "alias": "Contract", "domain": null, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "Contract" }, { "name": "Repair", "type": "esriFieldTypeInteger", "alias": "Repair", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Repair" }, { "name": "Entire_Line_Repaired", "type": "esriFieldTypeSmallInteger", "alias": "Entire_Line_Repaired", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Entire_Line_Repaired" }, { "name": "II_Removed", "type": "esriFieldTypeString", "alias": "II_Removed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "II_Removed" }, { "name": "All_II_Removed", "type": "esriFieldTypeSmallInteger", "alias": "All_II_Removed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "All_II_Removed" }, { "name": "From_Station", "type": "esriFieldTypeInteger", "alias": "From_Station", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "From_Station" }, { "name": "To_Station", "type": "esriFieldTypeInteger", "alias": "To_Station", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "To_Station" }, { "name": "Repair_Length", "type": "esriFieldTypeInteger", "alias": "Repair_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Repair_Length" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "NewCondition", "type": "esriFieldTypeString", "alias": "NewCondition", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "NewCondition" }, { "name": "Pipe_ID", "type": "esriFieldTypeString", "alias": "Pipe Identifier", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "Pipe_ID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R227_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_492_Pipe_ID", "fields": "Pipe_ID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "production.DBO.SewerPipeRepair", "description": "", "prototype": { "attributes": { "last_edited_user": null, "last_edited_date": null, "Date": null, "Contractor": null, "Contract": 10, "Repair": null, "Entire_Line_Repaired": null, "II_Removed": null, "All_II_Removed": null, "From_Station": null, "To_Station": null, "Repair_Length": null, "Comments": null, "NewCondition": null, "Pipe_ID": " ", "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 10, "name": "production.DBO.ssLateral_Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "production.DBO.ssLateralLine", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTIONDATE" }, { "name": "ADDRESSSTREET", "type": "esriFieldTypeString", "alias": "Address - Street", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ADDRESSSTREET" }, { "name": "DSSTATION", "type": "esriFieldTypeSmallInteger", "alias": "Downstream Station", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DSSTATION" }, { "name": "CLOCKPOSDS", "type": "esriFieldTypeSmallInteger", "alias": "Clock Position (downstream)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CLOCKPOSDS" }, { "name": "UNCONFIRMEDFLOW", "type": "esriFieldTypeInteger", "alias": "Unconfirmed Flow", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UNCONFIRMEDFLOW" }, { "name": "CONFIRMEDII", "type": "esriFieldTypeInteger", "alias": "Confirmed I/I", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CONFIRMEDII" }, { "name": "NEEDSDIG", "type": "esriFieldTypeString", "alias": "Needs Dig Repair?", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NEEDSDIG" }, { "name": "NEEDSADDINV", "type": "esriFieldTypeString", "alias": "Needs Additional Investigation?", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NEEDSADDINV" }, { "name": "SEWERMAINID", "type": "esriFieldTypeString", "alias": "Sewer Main ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SEWERMAINID" }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter (in)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "ESTTOTALLENGTH", "type": "esriFieldTypeSmallInteger", "alias": "Estimated Total Length (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESTTOTALLENGTH" }, { "name": "IICOMMENT", "type": "esriFieldTypeString", "alias": "I/I Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "IICOMMENT" }, { "name": "STRCOMMENT", "type": "esriFieldTypeString", "alias": "Structural Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "STRCOMMENT" }, { "name": "ROOTS", "type": "esriFieldTypeSmallInteger", "alias": "Roots Observed?", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROOTS" }, { "name": "LETTER", "type": "esriFieldTypeSmallInteger", "alias": "Send Structural Letter?", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LETTER" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CONDITION" }, { "name": "SPR", "type": "esriFieldTypeSmallInteger", "alias": "SPR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SPR" }, { "name": "MPR", "type": "esriFieldTypeSmallInteger", "alias": "MPR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MPR" }, { "name": "OPR", "type": "esriFieldTypeSmallInteger", "alias": "OPR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPR" }, { "name": "PACP_OPRI", "type": "esriFieldTypeDouble", "alias": "PACP OPRI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PACP_OPRI" }, { "name": "OPRI_PLF", "type": "esriFieldTypeDouble", "alias": "OPRI PLF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPRI_PLF" }, { "name": "HAS90", "type": "esriFieldTypeSmallInteger", "alias": "Has 90?", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HAS90" }, { "name": "SUMP", "type": "esriFieldTypeString", "alias": "Sump?", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SUMP" }, { "name": "RELATEFIELD", "type": "esriFieldTypeString", "alias": "RELATEFIELD", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RELATEFIELD" }, { "name": "REPORTNUMBER", "type": "esriFieldTypeString", "alias": "Report Number", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "REPORTNUMBER" }, { "name": "PROJECTID", "type": "esriFieldTypeString", "alias": "PROJECTID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PROJECTID" }, { "name": "GISHYPERLINK", "type": "esriFieldTypeString", "alias": "GISHYPERLINK", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "GISHYPERLINK" }, { "name": "FIELDHYPERLINK", "type": "esriFieldTypeString", "alias": "FIELDHYPERLINK", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "FIELDHYPERLINK" }, { "name": "PARENTGUI", "type": "esriFieldTypeGUID", "alias": "PARENTGUI", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "PARENTGUI" }, { "name": "COMM_RES4", "type": "esriFieldTypeString", "alias": "Commercial vs Residential <4", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "COMM_RES4" }, { "name": "ADDRESSNO", "type": "esriFieldTypeString", "alias": "Address - Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ADDRESSNO" }, { "name": "YEARLASTPAVED", "type": "esriFieldTypeString", "alias": "Year Last Paved", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "YEARLASTPAVED" }, { "name": "FUTUREPAVING", "type": "esriFieldTypeString", "alias": "Future Planned Paving", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "FUTUREPAVING" }, { "name": "LENGTHINSPECTED", "type": "esriFieldTypeDouble", "alias": "Length Inspected (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTHINSPECTED" }, { "name": "VIDEOFOLDER", "type": "esriFieldTypeString", "alias": "VIDEO FOLDER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "VIDEOFOLDER" } ], "indexes": [ { "name": "R228_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_493_FACILITY", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "production.DBO.ssLateral_Inspections", "description": "", "prototype": { "attributes": { "LENGTHINSPECTED": null, "VIDEOFOLDER": null, "FACILITYID": null, "INSPECTIONDATE": null, "ADDRESSSTREET": null, "DSSTATION": null, "CLOCKPOSDS": null, "UNCONFIRMEDFLOW": null, "CONFIRMEDII": null, "NEEDSDIG": null, "NEEDSADDINV": null, "SEWERMAINID": null, "DIAMETER": null, "MATERIAL": null, "ESTTOTALLENGTH": null, "IICOMMENT": null, "STRCOMMENT": null, "ROOTS": null, "LETTER": null, "CONDITION": null, "SPR": null, "MPR": null, "OPR": null, "PACP_OPRI": null, "OPRI_PLF": null, "HAS90": null, "SUMP": null, "RELATEFIELD": null, "REPORTNUMBER": null, "PROJECTID": null, "GISHYPERLINK": null, "FIELDHYPERLINK": null, "PARENTGUI": null, "COMM_RES4": null, "ADDRESSNO": null, "YEARLASTPAVED": null, "FUTUREPAVING": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 11, "name": "production.DBO.ssLateral_Repairs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Contractor" }, { "name": "Contract", "type": "esriFieldTypeString", "alias": "Contract", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Contract" }, { "name": "Repair", "type": "esriFieldTypeString", "alias": "Repair", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Repair" }, { "name": "Repair_Length", "type": "esriFieldTypeInteger", "alias": "Repair_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Repair_Length" }, { "name": "From_Station_start_main", "type": "esriFieldTypeInteger", "alias": "From Station (main to bldg)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "From_Station_start_main" }, { "name": "To_Station_start_main", "type": "esriFieldTypeInteger", "alias": "To Station (main to bldg)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "To_Station_start_main" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "II_Removed", "type": "esriFieldTypeInteger", "alias": "II_Removed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "II_Removed" } ], "indexes": [ { "name": "R229_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_494_FACILITY", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "production.DBO.ssLateral_Repairs", "description": "", "prototype": { "attributes": { "Comments": null, "II_Removed": null, "FACILITYID": null, "Date": null, "Contractor": null, "Contract": null, "Repair": null, "Repair_Length": null, "From_Station_start_main": null, "To_Station_start_main": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 12, "name": "production.DBO.ssManholeInspection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "production.DBO.ssManhole", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FACILITYID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "REPORTNUM", "type": "esriFieldTypeString", "alias": "Report Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Report_No" }, { "name": "STRUCTDEFECT", "type": "esriFieldTypeString", "alias": "Structural Defects", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "STRUCTDEFECT" }, { "name": "II", "type": "esriFieldTypeString", "alias": "II", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "II" }, { "name": "II_AMOUNT", "type": "esriFieldTypeDouble", "alias": "II Amount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "II_Amount" }, { "name": "INSPECTDATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "INSPECTOR", "type": "esriFieldTypeInteger", "alias": "Inspector", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Inspection_By" }, { "name": "REPORTLINK", "type": "esriFieldTypeString", "alias": "Report Link", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "GIS_Open_Image" }, { "name": "FIELDLINK", "type": "esriFieldTypeString", "alias": "Field Link", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "FIELDLINK" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R230_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_495_FACILITY", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "production.DBO.ssManholeInspection", "description": "", "prototype": { "attributes": { "last_edited_user": null, "last_edited_date": null, "FACILITYID": null, "REPORTNUM": null, "STRUCTDEFECT": null, "II": null, "II_AMOUNT": null, "INSPECTDATE": null, "INSPECTOR": null, "REPORTLINK": null, "FIELDLINK": null, "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }