{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Catch Basins", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.3190188946348049E8, "falseY": -1.0361850231172058E8, "xyUnits": 3.397454488130369E7, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 45, 83, 147, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7927842.192861478, "ymin": 5192442.235838851, "xmax": -7918978.591240199, "ymax": 5202318.991321468, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "INLETTYPE", "type": "esriFieldTypeString", "alias": "Inlet Type", "length": 50, "domain": { "type": "codedValue", "name": "piInletTypes", "description": "List of inlet types", "codedValues": [ { "name": "Catchbasin", "code": "Catchbasin" }, { "name": "Rear Yard", "code": "Rear Yard" }, { "name": "Roof", "code": "Roof" }, { "name": "Open Lid Manhole", "code": "Open Lid Manhole" }, { "name": "Closed Lid Manhole", "code": "Closed Lid Manhole" }, { "name": "Standard", "code": "Standard" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Pipe", "code": "Pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSDIAM", "type": "esriFieldTypeDouble", "alias": "Access Diameter", "domain": { "type": "range", "name": "piAccessDiameter", "description": "Valid range of infrastructure access diameters", "range": [ 0, 72 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSMAT", "type": "esriFieldTypeString", "alias": "Access Material", "length": 20, "domain": { "type": "codedValue", "name": "swInlet_AccessMat", "description": "Stormwater inlet access materials", "codedValues": [ { "name": "Block", "code": "BL" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Vitrified Clay", "code": "VCP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSTYPE", "type": "esriFieldTypeString", "alias": "Access Type", "length": 20, "domain": { "type": "codedValue", "name": "piAccessType", "description": "List of infrastructure access types", "codedValues": [ { "name": "Door", "code": "Door" }, { "name": "Grate", "code": "Grate" }, { "name": "Cover", "code": "Cover" }, { "name": "Hand", "code": "Hand" }, { "name": "Lid", "code": "Lid" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "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" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureSize", "type": "esriFieldTypeDouble", "alias": "StructureSize", "domain": null }, { "name": "PhotoID", "type": "esriFieldTypeString", "alias": "PhotoID", "length": 20, "domain": null }, { "name": "Submerged", "type": "esriFieldTypeSmallInteger", "alias": "Submerged", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Depth", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "EditSource", "type": "esriFieldTypeString", "alias": "Edit Source", "length": 35, "domain": { "type": "codedValue", "name": "swEditSource", "description": "Stormwater Infrastructure Source Material", "codedValues": [ { "name": "As Built", "code": "As Built" }, { "name": "Field Observation", "code": "Field Observation" }, { "name": "Aaberg Survey Data", "code": "Aaberg" }, { "name": "TV Inspection", "code": "TV Inspection" }, { "name": "Aerial Photo", "code": "Aerial Photo" }, { "name": "Field Survey", "code": "Field Survey" }, { "name": "GPS", "code": "GPS" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Recorded Plan", "code": "Recorded Plan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EditSourceDate", "type": "esriFieldTypeDate", "alias": "Edit Source Date", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "Repairs", "type": "esriFieldTypeString", "alias": "Repairs", "length": 200, "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "swInlet_Material", "description": "Stormwater inlet materials", "codedValues": [ { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureType", "type": "esriFieldTypeString", "alias": "StructureType", "length": 20, "domain": { "type": "codedValue", "name": "swStructureType", "description": "Describes Inlet/Dischage Structure", "codedValues": [ { "name": "Flared End Section", "code": "Flared" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Stone Headwall", "code": "Stone" }, { "name": "Concrete Headwall", "code": "Concrete" }, { "name": "None", "code": "None" }, { "name": "Pipe", "code": "Pipe" }, { "name": "Access Manhole", "code": "Access Manhole" }, { "name": "Box", "code": "Box" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GrateType", "type": "esriFieldTypeString", "alias": "Grate Type", "length": 15, "domain": { "type": "codedValue", "name": "swGrateType", "description": "Type of Access Grate", "codedValues": [ { "name": "Bar", "code": "BAR" }, { "name": "Checker", "code": "CHECKER" }, { "name": "Circular", "code": "CIRCULAR" }, { "name": "D-Shape", "code": "D-SHAPE" }, { "name": "Other", "code": "OTHER" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Beehive", "code": "BEEHIVE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "CurbInletType", "type": "esriFieldTypeString", "alias": "CurbInletType", "length": 10, "domain": { "type": "codedValue", "name": "swInlet_CurbInletType", "description": "Curb Inlet Materials", "codedValues": [ { "name": "Asphalt", "code": "ASP" }, { "name": "Block", "code": "BL" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Other", "code": "OTH" }, { "name": "Stone", "code": "ST" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "SUMPDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth to sump (ft)", "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "HASSUMP", "type": "esriFieldTypeString", "alias": "HASSUMP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R129_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_129", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1290", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S100_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "production.DBO.swInlet_Cleaning", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Drain Manholes", "type": "Feature Layer", "description": "Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.0032808333333333335, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.3190188946348049E8, "falseY": -1.0361850231172058E8, "xyUnits": 3.397454488130369E7, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 98, 56, 135, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7927763.593179465, "ymin": 5192633.667208632, "xmax": -7919282.49873029, "ymax": 5202319.30946285, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 25, "domain": { "type": "codedValue", "name": "swManhole_WallMaterial", "description": "Stormwater manhole wall materials", "codedValues": [ { "name": "Brick & Block", "code": "BB" }, { "name": "Brick & Concrete", "code": "BC" }, { "name": "Block", "code": "BL" }, { "name": "Block & Stone", "code": "BLST" }, { "name": "Brick", "code": "BR" }, { "name": "Brick & Stone", "code": "BRST" }, { "name": "Concrete & Block", "code": "CB" }, { "name": "Cobblestone", "code": "COB" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Precast Concrete", "code": "PCC" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Stone", "code": "ST" }, { "name": "Stone & Concrete", "code": "STC" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VCP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 15, "domain": { "type": "codedValue", "name": "piManholeType", "description": "List of infrastructure Manhole Types", "codedValues": [ { "name": "Access", "code": "Access" }, { "name": "Inside Drop", "code": "Inside Drop" }, { "name": "PTO", "code": "PTO" }, { "name": "Up Side BWG", "code": "Up Side BWG" }, { "name": "Down Side BWG", "code": "Down Side BWG" }, { "name": "Up Side SG", "code": "Up Side SG" }, { "name": "Down Side SG", "code": "Down Side SG" }, { "name": "Control", "code": "Control" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Pavement Cut Depth", "domain": null }, { "name": "FLOWDIR", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 5, "domain": { "type": "codedValue", "name": "Direction", "description": "The direction the sign is facing", "codedValues": [ { "name": "East", "code": "East" }, { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Northwest", "code": "Northwest" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "North/South", "code": "North/South" }, { "name": "East/West", "code": "East/West" }, { "name": "Northeast/Northwest", "code": "Northeast/Northwest" }, { "name": "Southeast/Southwest", "code": "Southeast/Southwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GPSDATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "length": 8, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "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" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Dedham", "code": 1 }, { "name": "Westwood", "code": -3 }, { "name": "Boston", "code": -4 }, { "name": "Needham", "code": -5 }, { "name": "State", "code": -6 }, { "name": "MBTA", "code": -7 }, { "name": "DCR", "code": -8 }, { "name": "Parks and Recreation", "code": 2 }, { "name": "Facilities", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "StructureSize", "type": "esriFieldTypeDouble", "alias": "Structure Size", "domain": null }, { "name": "CoverSize", "type": "esriFieldTypeDouble", "alias": "Cover Size", "domain": null }, { "name": "Submerged", "type": "esriFieldTypeSmallInteger", "alias": "Submerged", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EditSource", "type": "esriFieldTypeString", "alias": "Edit Source", "length": 35, "domain": null }, { "name": "EditSourceDate", "type": "esriFieldTypeDate", "alias": "Edit Source Date", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "Repairs", "type": "esriFieldTypeString", "alias": "Repairs", "length": 200, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 20, "domain": { "type": "codedValue", "name": "piManholeCoverType", "description": "List of infrastructure Manhole Cover Types", "codedValues": [ { "name": "Standard W/ Lock", "code": "Standard W/ Lock" }, { "name": "Standard W/ Ears", "code": "Standard W/ Ears" }, { "name": "Non-District", "code": "Non-District" }, { "name": "Water Tight", "code": "Water Tight" }, { "name": "27\" Diameter", "code": "27\" Diameter" }, { "name": "42\" Diameter", "code": "42\" Diameter" }, { "name": "Large - Water Tight", "code": "Large - Water Tight" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "HASSUMP", "type": "esriFieldTypeString", "alias": "Has Sump?", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R126_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_126", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S97_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "production.DBO.swInlet_Cleaning", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Stormwater Inlet Cleaning Records", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "Weather", "type": "esriFieldTypeString", "alias": "Weather", "length": 50, "domain": { "type": "codedValue", "name": "swInlet_Clean_Weather", "description": "swInlet Cleaning: Weather Condition", "codedValues": [ { "name": "Sunny", "code": "Sunny" }, { "name": "Mostly Sunny", "code": "Mostly Sunny" }, { "name": "Mostly Cloudy", "code": "Mostly Cloudy" }, { "name": "Rain", "code": "Rain" }, { "name": "Snow", "code": "Snow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 50, "domain": null }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "Location", "length": 100, "domain": null }, { "name": "OverallCondition", "type": "esriFieldTypeString", "alias": "Overall Condition", "length": 50, "domain": { "type": "codedValue", "name": "swInlet_Clean_OverallCondition", "description": "swInlet Cleaning: Overall Condition", "codedValues": [ { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Average", "code": "Average" }, { "name": "Above Average", "code": "Above Average" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DepthBeforeClean", "type": "esriFieldTypeDouble", "alias": "Depth Before Cleaning", "domain": null }, { "name": "DepthAfterClean", "type": "esriFieldTypeDouble", "alias": "Depth After Cleaning", "domain": null }, { "name": "SumpToOut", "type": "esriFieldTypeDouble", "alias": "SumpToOut", "domain": null }, { "name": "Pollutants", "type": "esriFieldTypeString", "alias": "Pollutants", "length": 100, "domain": { "type": "codedValue", "name": "swInlet_Clean_Pollutants", "description": "swInlet Cleaning: Pollutants", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Sewage Odor", "code": "Sewage Odor" }, { "name": "Foam", "code": "Foam" }, { "name": "Trash", "code": "Trash" }, { "name": "Oilly Sheen", "code": "Oilly Sheen" }, { "name": "Pet Waste", "code": "Pet Waste" }, { "name": "Algae or Bacteria", "code": "Algae or Bacteria" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OtherPollutant", "type": "esriFieldTypeString", "alias": "Other Pollutant", "length": 100, "domain": null }, { "name": "AdditionalNotes", "type": "esriFieldTypeString", "alias": "Additional Notes", "length": 500, "domain": null }, { "name": "RequiresFollowUp", "type": "esriFieldTypeString", "alias": "Requires Follow Up", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FollowUpNotes", "type": "esriFieldTypeString", "alias": "Follow Up Notes", "length": 500, "domain": null }, { "name": "CleaningStatus", "type": "esriFieldTypeString", "alias": "Cleaning Status", "length": 5, "domain": { "type": "codedValue", "name": "swInlet_Clean_CleaningStatus", "description": "swInlet Cleaning: CleaningStatus", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Could Not Access", "code": "CNA" }, { "name": "Could Not Locate", "code": "CNL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleaned_Date", "type": "esriFieldTypeDate", "alias": "Cleaned Date", "length": 8, "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "PetWaste", "type": "esriFieldTypeString", "alias": "PetWaste", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PetWaste_Significant", "type": "esriFieldTypeString", "alias": "PetWaste_Significant", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R50_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_50", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G242ParentGUID", "fields": "ParentGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GlobalID_Index", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "production.DBO.swManhole", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "production.DBO.swInlet", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }