{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Storm Gravity Mains", "type": "Feature Layer", "description": "This dataset contains a collection of features that represent the stormwater network in a community.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2913, "latestWkid": 2913, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111333600, "falseY": -98152500, "xyUnits": 3048, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": { "id": 0, "name": "Storm Network" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "sdeProd.GIS.swGravityMain.STATUS", "field2": "sdeProd.GIS.swGravityMain.OWNEDBY", "field3": "sdeProd.GIS.swGravityMain.MAIN_TYPE", "uniqueValueGroups": [ { "heading": "STATUS,Owned By,Main Type", "classes": [ { "label": "Planned", "description": "Planned", "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "values": [ [ "1", "10", "Culvert" ], [ "1", "10", "Gravity" ], [ "1", "15", "Gravity" ], [ "1", "50", "Gravity" ], [ "1", "100", "Gravity" ], [ "1", "110", "Detention" ], [ "1", "110", "Gravity" ], [ "1", "130", "Gravity" ], [ "1", "150", "Gravity" ], [ "1", "10", "Detention" ] ] }, { "label": "Existing, COB", "description": "Existing, COB", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "values": [ [ "2", "10", "Culvert" ], [ "2", "10", "Gravity" ], [ "2", "15", "Gravity" ] ] }, { "label": "Existing, COB - Detention", "description": "Existing, COB - Detention", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "values": [ [ "2", "10", "Detention" ], [ "2", "15", "Detention" ] ] }, { "label": "Existing, Other", "description": "Existing, Other", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "values": [ [ "2", "20", "Culvert" ], [ "2", "20", "Gravity" ], [ "2", "40", "Culvert" ], [ "2", "50", "Gravity" ], [ "2", "60", "Culvert" ], [ "2", "60", "Gravity" ], [ "2", "80", "Culvert" ], [ "2", "80", "Gravity" ], [ "2", "100", "Culvert" ], [ "2", "100", "Gravity" ], [ "2", "110", "Culvert" ], [ "2", "110", "Detention" ], [ "2", "110", "Gravity" ], [ "2", "120", "Culvert" ], [ "2", "130", "Detention" ], [ "2", "130", "Gravity" ], [ "2", "140", "Detention" ], [ "2", "140", "Gravity" ], [ "2", "150", "Culvert" ], [ "2", "150", "Gravity" ], [ "2", "160", "Gravity" ], [ "2", "170", "Culvert" ], [ "2", "170", "Gravity" ], [ "2", "40", "Gravity" ], [ "2", "999", "Culvert" ] ] }, { "label": "Abandoned", "description": "Abandoned", "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "values": [ [ "3", "10", "Culvert" ], [ "3", "10", "Gravity" ], [ "3", "50", "Gravity" ], [ "3", "100", "Gravity" ], [ "3", "110", "Culvert" ], [ "3", "110", "Gravity" ], [ "3", "140", "Gravity" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,10,Culvert", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,10,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,15,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,50,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,100,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,110,Detention", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,110,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,130,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,150,Gravity", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 255, 115, 255 ], "width": 2 }, "value": "1,10,Detention", "label": "Planned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "value": "2,10,Culvert", "label": "Existing, COB" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "value": "2,10,Gravity", "label": "Existing, COB" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "value": "2,15,Gravity", "label": "Existing, COB" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "value": "2,10,Detention", "label": "Existing, COB - Detention" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 8 }, "value": "2,15,Detention", "label": "Existing, COB - Detention" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,20,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,20,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,40,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,50,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,60,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,60,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,80,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,80,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,100,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,100,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,110,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,110,Detention", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,110,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,120,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,130,Detention", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,130,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,140,Detention", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,140,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,150,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,150,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,160,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,170,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,170,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,40,Gravity", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3 }, "value": "2,999,Culvert", "label": "Existing, Other" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,10,Culvert", "label": "Abandoned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,10,Gravity", "label": "Abandoned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,50,Gravity", "label": "Abandoned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,100,Gravity", "label": "Abandoned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,110,Culvert", "label": "Abandoned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,110,Gravity", "label": "Abandoned" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDashDot", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "3,140,Gravity", "label": "Abandoned" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 203, 194, 252, 255 ], "toColor": [ 203, 194, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 252, 179, 255 ], "toColor": [ 194, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 206, 184, 255 ], "toColor": [ 252, 206, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 250, 252, 255 ], "toColor": [ 187, 250, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 216, 255 ], "toColor": [ 252, 182, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 252, 187, 255 ], "toColor": [ 252, 252, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 179, 252, 255 ], "toColor": [ 250, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 218, 255 ], "toColor": [ 184, 252, 218, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 246, 215, 252, 255 ], "toColor": [ 246, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 235, 252, 255 ], "toColor": [ 215, 235, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 215, 255 ], "toColor": [ 252, 240, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 220, 255 ], "toColor": [ 252, 212, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 218, 252, 204, 255 ], "toColor": [ 218, 252, 204, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 7591682.954724416, "ymin": 650074.3031496108, "xmax": 7626734.917322829, "ymax": 691172.1587926447, "spatialReference": { "wkid": 2913, "latestWkid": 2913, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111333600, "falseY": -98152500, "xyUnits": 3048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "sdeProd.GIS.swGravityMain.sdeProd.GIS.swGravityMain.sdeProd.GIS.swGravityMain.sdeProd.GIS.swGravityMain.sdeProd.GIS.swGravityMain.BASINNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "sdeProd.GIS.swGravityMain.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.MAIN_TYPE", "type": "esriFieldTypeString", "alias": "Main Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_swMainType", "description": "Storm Main Type", "codedValues": [ { "name": "Gravity", "code": "Gravity" }, { "name": "Detention", "code": "Detention" }, { "name": "Culvert", "code": "Culvert" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of Beaverton pipe materials types", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Corrugated Polyethylene Pipe", "code": "ADS N-12" }, { "name": "Ameron", "code": "AME" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Brass", "code": "BRA" }, { "name": "C-900", "code": "C900" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Concrete Cylinder Pipe", "code": "CCP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Concrete", "code": "CP" }, { "name": "Corrugated Plastic", "code": "CPP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Corrugated Steel", "code": "CSP" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Iron", "code": "GIP" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Galvanized Steel", "code": "GSP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Perforated Metal Pipe", "code": "PMP" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Unknown", "code": "UNK" }, { "name": "URIB", "code": "URIB" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Bronze", "code": "BRO" }, { "name": "Transite", "code": "TTE" }, { "name": "Perforated Plastic Pipe", "code": "PPP" }, { "name": "Felt", "code": "FEL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.NASSCOMAT", "type": "esriFieldTypeString", "alias": "NASSCO Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piMaterialNASSCO", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Asbestos cement", "code": "AC" }, { "name": "Brick", "code": "BR" }, { "name": "Cast iron", "code": "CAS" }, { "name": "Clay-lined Concrete Pipe", "code": "CLC" }, { "name": "Corrugated metal pipe", "code": "CMP" }, { "name": "Concrete pipe (non-reinforced)", "code": "CP" }, { "name": "Concrete segments (bolted)", "code": "CSB" }, { "name": "Concrete segments (unbolted)", "code": "CSU" }, { "name": "Clay tile (not vetrified clay)", "code": "CT" }, { "name": "Ductile iron", "code": "DIP" }, { "name": "Felt", "code": "FELT" }, { "name": "Fiberglass reinforced pipe", "code": "FRP" }, { "name": "Pitch fiber (Orangeburg)", "code": "OB" }, { "name": "Pre-stressed Concrete Cylinder Pipe", "code": "PCCP" }, { "name": "Polymer Concrete Cylinder Pipe", "code": "PCP" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/steel composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced concrete pipe", "code": "RCP" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel pipe", "code": "SP" }, { "name": "Vitrified clay pipe", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Not known", "code": "XXX" }, { "name": "Other", "code": "ZZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.HEIGHT", "type": "esriFieldTypeDouble", "alias": "HEIGHT", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Arched with flat bottom", "code": "A" }, { "name": "Barrel(e.g. beer barrel shape)", "code": "B" }, { "name": "Circular", "code": "C" }, { "name": "Egg Shaped", "code": "E" }, { "name": "horseshoe(I.e. inverted U)", "code": "H" }, { "name": "Oval", "code": "O" }, { "name": "Rectangular", "code": "R" }, { "name": "Square", "code": "S" }, { "name": "Trapezoidal", "code": "T" }, { "name": "U-shaped with flat top", "code": "U" }, { "name": "Other", "code": "Z" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.WATERTYPE", "type": "esriFieldTypeString", "alias": "WATERTYPE", "length": 50, "domain": { "type": "codedValue", "name": "WS2_WaterTypeNASSCO", "description": "NASSCO Water Type", "codedValues": [ { "name": "Combined", "code": "CB" }, { "name": "Force Main", "code": "FM" }, { "name": "Process", "code": "PR" }, { "name": "Sanitary", "code": "SS" }, { "name": "Stormwater", "code": "SW" }, { "name": "Other", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.LINERMAT", "type": "esriFieldTypeString", "alias": "Liner Material", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piMaterialNASSCO", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Asbestos cement", "code": "AC" }, { "name": "Brick", "code": "BR" }, { "name": "Cast iron", "code": "CAS" }, { "name": "Clay-lined Concrete Pipe", "code": "CLC" }, { "name": "Corrugated metal pipe", "code": "CMP" }, { "name": "Concrete pipe (non-reinforced)", "code": "CP" }, { "name": "Concrete segments (bolted)", "code": "CSB" }, { "name": "Concrete segments (unbolted)", "code": "CSU" }, { "name": "Clay tile (not vetrified clay)", "code": "CT" }, { "name": "Ductile iron", "code": "DIP" }, { "name": "Felt", "code": "FELT" }, { "name": "Fiberglass reinforced pipe", "code": "FRP" }, { "name": "Pitch fiber (Orangeburg)", "code": "OB" }, { "name": "Pre-stressed Concrete Cylinder Pipe", "code": "PCCP" }, { "name": "Polymer Concrete Cylinder Pipe", "code": "PCP" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/steel composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced concrete pipe", "code": "RCP" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel pipe", "code": "SP" }, { "name": "Vitrified clay pipe", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Not known", "code": "XXX" }, { "name": "Other", "code": "ZZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.LINERMETHOD", "type": "esriFieldTypeString", "alias": "LINERMETHOD", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piLinerMethodNASSCO", "description": "NASSCO pipe rehab liner method", "codedValues": [ { "name": "CEMENT MORTAR", "code": "CEMENT MORTAR" }, { "name": "CURED-IN-PLACE PIPE", "code": "CIPP" }, { "name": "DEFORMED PIPE LINING", "code": "DEFORMED PIPE LINING" }, { "name": "EPOXY SPRAY LINING", "code": "EPOXY SPRAY LINING" }, { "name": "NONE", "code": "NONE" }, { "name": "OTHER", "code": "OTHER" }, { "name": "SLIP LINING", "code": "SLIP LINING" }, { "name": "SPIRALLY WOUND LINING", "code": "SPIRALLY WOUND LINING" }, { "name": "SWAGE & DIE DRAW LINING", "code": "SWAGE & DIE DRAW LINING" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.REHABDATE", "type": "esriFieldTypeDate", "alias": "Rehab Date", "length": 8, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.CLEANINGAREA", "type": "esriFieldTypeSmallInteger", "alias": "Cleaning Area", "domain": { "type": "codedValue", "name": "WS2_piCleaningArea", "description": "Type of Cleaning Area", "codedValues": [ { "name": "Grease", "code": 1 }, { "name": "Root", "code": 2 }, { "name": "Special", "code": 3 }, { "name": "NA", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 20, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 50, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.ASBUILT", "type": "esriFieldTypeString", "alias": "ASBUILT", "length": 250, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.AbandonDate", "type": "esriFieldTypeDate", "alias": "Abandoned Date", "length": 8, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.QTRSEC", "type": "esriFieldTypeString", "alias": "QTRSEC", "length": 10, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.QTRQTRSEC", "type": "esriFieldTypeString", "alias": "QtrQtrSec", "length": 10, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.BASINNAME", "type": "esriFieldTypeString", "alias": "BASINNAME", "length": 50, "domain": { "type": "codedValue", "name": "WS2_StormBasinName", "description": "Name of storm basin", "codedValues": [ { "name": "Ash Creek", "code": "AC" }, { "name": "Bel Aire", "code": "BL" }, { "name": "Butternut Creek", "code": "BN" }, { "name": "Bronson Creek", "code": "BR" }, { "name": "Beaverton Creek", "code": "BV" }, { "name": "Cedar Mill Creek", "code": "CM" }, { "name": "Downing", "code": "DN" }, { "name": "Erickson Creek", "code": "ER" }, { "name": "Fanno Creek", "code": "FN" }, { "name": "Hall Creek", "code": "HC" }, { "name": "Hiteon", "code": "HI" }, { "name": "Johnson Creek North", "code": "JN" }, { "name": "Johnson Creek South", "code": "JS" }, { "name": "Messinger Creek", "code": "MC" }, { "name": "Nimbus", "code": "NM" }, { "name": "South Cooper", "code": "SC" }, { "name": "Sylvania Creek", "code": "SL" }, { "name": "Summer Creek", "code": "SQ" }, { "name": "Upper Beaverton", "code": "UB" }, { "name": "Vermont", "code": "VR" }, { "name": "Wood Creek", "code": "WD" }, { "name": "Waterhouse", "code": "WH" }, { "name": "Willow Creek", "code": "WL" }, { "name": "Weir", "code": "WR" }, { "name": "Golf Creek", "code": "GF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.STATUS", "type": "esriFieldTypeSmallInteger", "alias": "STATUS", "domain": { "type": "codedValue", "name": "WS2_Status", "description": "", "codedValues": [ { "name": "Planned", "code": 1 }, { "name": "Existing", "code": 2 }, { "name": "Abandoned", "code": 3 }, { "name": "Removed", "code": 4 }, { "name": "Proposed", "code": 5 }, { "name": "Unknown", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.SOURCE", "type": "esriFieldTypeSmallInteger", "alias": "SOURCE", "domain": { "type": "codedValue", "name": "WS2_Source", "description": "Where the GIS data was derived", "codedValues": [ { "name": "Survey", "code": 1 }, { "name": "Field Check", "code": 2 }, { "name": "Asbuilt", "code": 3 }, { "name": "Plan", "code": 4 }, { "name": "Ortho", "code": 5 }, { "name": "Unknown", "code": 6 }, { "name": "Plat", "code": 7 }, { "name": "COB Document", "code": 8 }, { "name": "OPS Redline", "code": 9 }, { "name": "ENG Redline", "code": 10 }, { "name": "Scan", "code": 11 }, { "name": "GPS", "code": 12 }, { "name": "Outside", "code": 13 }, { "name": "Springbrook", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "COB", "code": 10 }, { "name": "Tigard", "code": 20 }, { "name": "Hillsboro", "code": 30 }, { "name": "Portland", "code": 40 }, { "name": "Trimet", "code": 50 }, { "name": "THPRD", "code": 60 }, { "name": "MultCO", "code": 70 }, { "name": "WashCO", "code": 80 }, { "name": "Metro", "code": 90 }, { "name": "State", "code": 100 }, { "name": "Private", "code": 110 }, { "name": "Other", "code": 120 }, { "name": "BSD", "code": 130 }, { "name": "TVWD", "code": 140 }, { "name": "CWS", "code": 150 }, { "name": "TVFR", "code": 160 }, { "name": "PGE", "code": 170 }, { "name": "HMA", "code": 180 }, { "name": "RxR Authority", "code": 190 }, { "name": "COB Facilities", "code": 15 }, { "name": "Unknown", "code": 999 }, { "name": "Raleigh", "code": 200 }, { "name": "West Slope", "code": 210 }, { "name": "WWSP", "code": 220 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "COB", "code": 10 }, { "name": "Tigard", "code": 20 }, { "name": "Hillsboro", "code": 30 }, { "name": "Portland", "code": 40 }, { "name": "Trimet", "code": 50 }, { "name": "THPRD", "code": 60 }, { "name": "MultCO", "code": 70 }, { "name": "WashCO", "code": 80 }, { "name": "Metro", "code": 90 }, { "name": "State", "code": 100 }, { "name": "Private", "code": 110 }, { "name": "Other", "code": 120 }, { "name": "BSD", "code": 130 }, { "name": "TVWD", "code": 140 }, { "name": "CWS", "code": 150 }, { "name": "TVFR", "code": 160 }, { "name": "PGE", "code": 170 }, { "name": "HMA", "code": 180 }, { "name": "RxR Authority", "code": 190 }, { "name": "COB Facilities", "code": 15 }, { "name": "Unknown", "code": 999 }, { "name": "WWSP", "code": 220 }, { "name": "Raleigh", "code": 200 }, { "name": "West Slope", "code": 210 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.CWCONDITION", "type": "esriFieldTypeSmallInteger", "alias": "CWCONDITION", "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "Condition", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Very Poor", "code": 5 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.SURVEY", "type": "esriFieldTypeSmallInteger", "alias": "SURVEY", "domain": { "type": "codedValue", "name": "WS2_YesNoBinary", "description": "Binary True/False Yes/No", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.DATE_CREATED", "type": "esriFieldTypeDate", "alias": "DATE_CREATED", "length": 8, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "length": 255, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.TempFromMH", "type": "esriFieldTypeString", "alias": "TempFromMH", "length": 50, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.TempToMH", "type": "esriFieldTypeString", "alias": "TempToMH", "length": 50, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.OUTDIAMETER", "type": "esriFieldTypeDouble", "alias": "Outside Diameter", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.AB_FLAG", "type": "esriFieldTypeString", "alias": "AB_FLAG", "length": 5, "domain": { "type": "codedValue", "name": "WS2_AB_FLAG", "description": "Indicates if the feature has received an As-built", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdeProd.GIS.swGravityMain.SCANLENGTH", "type": "esriFieldTypeDouble", "alias": "SCANLENGTH", "domain": null }, { "name": "sdeProd.GIS.swGravityMain.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.ASBUILTPAGE", "type": "esriFieldTypeString", "alias": "Asbuilt Page Number", "length": 10, "domain": null }, { "name": "sdeProd.GIS.swGravityMain.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "dbo.CCTV_Scoring.PIPE_ID", "type": "esriFieldTypeString", "alias": "PIPE_ID", "length": 50, "domain": null }, { "name": "dbo.CCTV_Scoring.VIDEO", "type": "esriFieldTypeString", "alias": "VIDEO", "length": 2147483647, "domain": null }, { "name": "dbo.CCTV_Scoring.CCTV_DATE", "type": "esriFieldTypeDate", "alias": "CCTV_DATE", "length": 8, "precision": 1, "domain": null }, { "name": "dbo.CCTV_Scoring.SCORE", "type": "esriFieldTypeInteger", "alias": "SCORE", "domain": null }, { "name": "dbo.CCTV_Scoring.AVERAGE", "type": "esriFieldTypeDouble", "alias": "AVERAGE", "domain": null }, { "name": "dbo.CCTV_Scoring.COUNT", "type": "esriFieldTypeInteger", "alias": "COUNT", "domain": null }, { "name": "dbo.CCTV_Scoring.OM_SCORE", "type": "esriFieldTypeInteger", "alias": "OM_SCORE", "domain": null }, { "name": "dbo.CCTV_Scoring.OM_AVG", "type": "esriFieldTypeDouble", "alias": "OM_AVG", "domain": null }, { "name": "dbo.CCTV_Scoring.OM_COUNT", "type": "esriFieldTypeInteger", "alias": "OM_COUNT", "domain": null }, { "name": "dbo.CCTV_Scoring.STRUCT_SCORE", "type": "esriFieldTypeInteger", "alias": "STRUCT_SCORE", "domain": null }, { "name": "dbo.CCTV_Scoring.STRUCT_AVG", "type": "esriFieldTypeDouble", "alias": "STRUCT_AVG", "domain": null }, { "name": "dbo.CCTV_Scoring.STRUCT_COUNT", "type": "esriFieldTypeInteger", "alias": "STRUCT_COUNT", "domain": null }, { "name": "dbo.CCTV_Scoring.ROOT_SCORE", "type": "esriFieldTypeInteger", "alias": "ROOT_SCORE", "domain": null }, { "name": "dbo.CCTV_Scoring.ROOT_MAX", "type": "esriFieldTypeInteger", "alias": "ROOT_MAX", "domain": null }, { "name": "dbo.CCTV_Scoring.ROOT_COUNT", "type": "esriFieldTypeInteger", "alias": "ROOT_COUNT", "domain": null }, { "name": "dbo.CCTV_Scoring.GREASE_SCORE", "type": "esriFieldTypeInteger", "alias": "GREASE_SCORE", "domain": null }, { "name": "dbo.CCTV_Scoring.GREASE_MAX", "type": "esriFieldTypeInteger", "alias": "GREASE_MAX", "domain": null }, { "name": "dbo.CCTV_Scoring.GREASE_COUNT", "type": "esriFieldTypeInteger", "alias": "GREASE_COUNT", "domain": null }, { "name": "dbo.CCTV_Scoring.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "sdeProd.GIS.swGravityMain.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R13101_pk", "fields": "sdeProd.GIS.swGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_13101", "fields": "sdeProd.GIS.swGravityMain.GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_13101", "fields": "sdeProd.GIS.swGravityMain.GlobalID,sdeProd.GIS.swGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FID_INDEX", "fields": "sdeProd.GIS.swGravityMain.FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S11195_idx", "fields": "sdeProd.GIS.swGravityMain.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ClusteredIndex-20191217-145358", "fields": "dbo.CCTV_Scoring.PIPE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "76cf921513b14a14acf1dcf55ec899a1" }