{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Development Sites", "type": "Feature Layer", "description": "<DIV STYLE=\"text-align:Left;\"><DIV><DIV><P><SPAN>Development sites is an inventory based on known building and landuse permits issued within the unincorporated areas of Chelan County. This is specifically for Public Works to track the conditions of approval and completed stormwater requirements as defined by the department.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102748, "latestWkid": 2285, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 2, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "Schema provided by Lori Beidler at Chelan County Public Works", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ProjType", "defaultSymbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 104, 104, 104, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 52, 52, 52, 255 ], "width": 2 } }, "defaultLabel": "<all other values>", "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 255, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 122, 142, 245, 255 ], "width": 2 } }, "value": "BPC", "label": "BPC" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 255, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 127, 255 ], "width": 2 } }, "value": "BPR", "label": "BPR" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 255, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 } }, "value": "CUP", "label": "CUP" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 255, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 2 } }, "value": "PD", "label": "PD" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 115, 0, 76, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 0, 76, 255 ], "width": 2 } }, "value": "PLAT", "label": "PLAT" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 0, 76, 115, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 76, 115, 255 ], "width": 1 } }, "value": "SPA", "label": "SP or SPA" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 0, 76, 115, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 76, 115, 255 ], "width": 1 } }, "value": "SP", "label": "SP or SPA" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 255, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 170, 255, 0, 255 ], "width": 0.7 } }, "value": "BSP", "label": "BSP" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 192, 255, 179, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 85, 255, 0, 255 ], "width": 1 } }, "value": "Enviromental Review", "label": "Enviromental Review" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 0, 38, 115, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 38, 115, 255 ], "width": 2 } }, "value": "MPR", "label": "MPR" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 233, 252, 255 ], "toColor": [ 197, 233, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 251, 255 ], "toColor": [ 252, 179, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 205, 252, 179, 255 ], "toColor": [ 205, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 187, 255 ], "toColor": [ 252, 215, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 189, 252, 255 ], "toColor": [ 179, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 239, 255 ], "toColor": [ 252, 212, 239, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 235, 255 ], "toColor": [ 182, 252, 235, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 179, 255 ], "toColor": [ 252, 244, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 199, 255 ], "toColor": [ 252, 179, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 212, 252, 255 ], "toColor": [ 215, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 252, 215, 255 ], "toColor": [ 242, 252, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 225, 189, 252, 255 ], "toColor": [ 225, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 207, 252, 208, 255 ], "toColor": [ 207, 252, 208, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 53, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.ProjNumber"}, "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "multiPart": "labelPerPart", "allowOverrun": false, "deconflictionStrategy": "dynamic", "repeatLabel": false, "allowOverlapOfFeatureBoundary": "avoid", "stackLabel": true, "stackRowLength": 24, "stackAlignment": "dynamic", "removeDuplicates": "none", "allowOverlapOfLabel": "allow", "where": "ProjType = 'BPC' Or ProjType = 'BPR' Or ProjType = 'BP'", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 2", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 38, 115, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Cambria", "size": 8, "style": "italic", "weight": "bold", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 1577906.1915433109, "ymin": 104276.20495922863, "xmax": 1878587.8165568113, "ymax": 486241.0689807236, "spatialReference": { "wkid": 102748, "latestWkid": 2285, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ProjNumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Id", "type": "esriFieldTypeInteger", "alias": "Id", "domain": null }, { "name": "ProjType", "type": "esriFieldTypeString", "alias": "ProjType", "length": 50, "domain": null }, { "name": "ProjNumber", "type": "esriFieldTypeString", "alias": "ProjNumber", "length": 50, "domain": null }, { "name": "ProjectNam", "type": "esriFieldTypeString", "alias": "ProjectNam", "length": 50, "domain": null }, { "name": "ProjYear", "type": "esriFieldTypeInteger", "alias": "ProjYear", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 254, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 50, "domain": null }, { "name": "OwnEmail", "type": "esriFieldTypeString", "alias": "OwnEmail", "length": 50, "domain": null }, { "name": "OwnPhone", "type": "esriFieldTypeString", "alias": "OwnPhone", "length": 50, "domain": null }, { "name": "Agent", "type": "esriFieldTypeString", "alias": "Agent", "length": 50, "domain": { "type": "codedValue", "name": "DevelopmentAgents", "description": "A person in charge of the development", "codedValues": [ { "name": "Wes Potridge", "code": "Wes Potridge" }, { "name": "Tim Hollingsworth", "code": "Tim Hollingsworth" }, { "name": "Shawn Fitzpatrick", "code": "Shawn Fitzpatrick" }, { "name": "Scott Volrath", "code": "Scott Volrath" }, { "name": "Paul Coppock", "code": "Paul Coppock" }, { "name": "Norm Nelson", "code": "Norm Nelson" }, { "name": "Michelle Taylor", "code": "Michelle Taylor" }, { "name": "Martin Davy", "code": "Martin Davy" }, { "name": "Larry Weinert", "code": "Larry Weinert" }, { "name": "Jesse Redell, PLS", "code": "Jesse Redell" }, { "name": "Heather Ostenson, PE", "code": "Heather Ostenson" }, { "name": "Erik Gahringer", "code": "Erik Gahringer" }, { "name": "Don Phelps, PE", "code": "Don Phelps" }, { "name": "Dan Beardslee, PLS", "code": "Dan Beardslee" }, { "name": "Chris D'Orazio", "code": "Chris D'Orazio" }, { "name": "Bruce Dawson", "code": "Bruce Dawson" }, { "name": "Bruce Darling", "code": "Bruce Darling" }, { "name": "Brian Hinthorne, PE, PLS", "code": "Brian Hinthorne" }, { "name": "Brian Baker, PLS", "code": "Brian Baker" }, { "name": "Bob Culp", "code": "Bob Culp" }, { "name": "Morgan Picton", "code": "Morgan Picton" }, { "name": "Washington Pacific Homes, Inc.", "code": "Washington Pacific Homes" }, { "name": "Thad Schutt, Manager", "code": "Thad Schutt" }, { "name": "SCJ Alliance", "code": "SCJ Alliance" }, { "name": "Paul Milan, Northland Communications", "code": "Paul Milan" }, { "name": "Munson Engineers", "code": "Munson Engineers" }, { "name": "Loren Stocker", "code": "Loren Stocker" }, { "name": "Kevin Aguilar", "code": "Kevin Aguilar" }, { "name": "Karen Peele", "code": "Karen Peele" }, { "name": "Jonna Valdez", "code": "Jonna Valdez" }, { "name": "Forsgren Associates", "code": "Forsgren Associates" }, { "name": "Erlandsen & Associates", "code": "Erlandsen & Associates" }, { "name": "Jeff at Erlandsen & Associates", "code": "Jeff" }, { "name": "Kris at Erlandsen & Associates", "code": "Kris" }, { "name": "Eco Plan & Design", "code": "Eco Plan & Design" }, { "name": "David Walters", "code": "David Walters" }, { "name": "Danny Gildehaus", "code": "Danny Gildehaus" }, { "name": "Dan Beardslee at Erlandsen & Associates", "code": "Dan" }, { "name": "Coulter Architects, PLLC", "code": "Coulter Architects" }, { "name": "Charles Steinberg", "code": "Charles Steinberg" }, { "name": "Brian McNeill", "code": "Brian McNeill" }, { "name": "Ryan Peterson", "code": "Ryan Peterson" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AgntEmail", "type": "esriFieldTypeString", "alias": "AgntEmail", "length": 50, "domain": { "type": "codedValue", "name": "DevelopmentAgentEmail", "description": "Email addresses for agents", "codedValues": [ { "name": "wesp@erlandsen.com", "code": "wesp@erlandsen.com" }, { "name": "tim@pinnacle-surveying.com", "code": "tim@pinnacle-surveying.com" }, { "name": "landline@tumwater.net", "code": "landline@tumwater.net" }, { "name": "paul@doharchitects.com", "code": "paul@doharchitects.com" }, { "name": "nnelson@nwgsurveys.com", "code": "nnelson@nwgsurveys.com" }, { "name": "morganpicton@windermere.com", "code": "morganpicton@windermere.com" }, { "name": "mtaylor@nwgsurveys.com", "code": "mtaylor@nwgsurveys.com" }, { "name": "martin@pacificengineering.net", "code": "martin@pacificengineering.net" }, { "name": "weinert@munsonengineers.com", "code": "weinert@munsonengineers.com" }, { "name": "jesser@erlandsen.com", "code": "jesser@erlandsen.com" }, { "name": "hostenson@projectgroundwork.com", "code": "hostenson@projectgroundwork.com" }, { "name": "erikg@48north.com", "code": "erikg@48north.com" }, { "name": "donphelps@aol.com", "code": "donphelps@aol.com" }, { "name": "dan.beardslee@gmail.com", "code": "dan.beardslee@gmail.com" }, { "name": "chrisd@erlandsen.com", "code": "chrisd@erlandsen.com" }, { "name": "dawson.survey@nwi.net", "code": "dawson.survey@nwi.net" }, { "name": "brucekdarling@gmail.com", "code": "brucekdarling@gmail.com" }, { "name": "email@eaglecreekconsulting.net", "code": "email@eaglecreekconsulting.net" }, { "name": "brianb@munsonengineers.com", "code": "brianb@munsonengineers.com" }, { "name": "rculp@munsonengineers.com", "code": "rculp@munsonengineers.com" }, { "name": "brian@mcneillsurveys.com", "code": "brian@mcneillsurveys.com" }, { "name": "charles@ncwlaw.com", "code": "charles@ncwlaw.com" }, { "name": "coulterarchitects@msn.com", "code": "coulterarchitects@msn.com" }, { "name": "danb@erlandsen.com", "code": "danb@erlandsen.com" }, { "name": "dannyg@erlandsen.com", "code": "dannyg@erlandsen.com" }, { "name": "dwalters@nwi.net", "code": "dwalters@nwi.net" }, { "name": "thom@ecoplan.us", "code": "thom@ecoplan.us" }, { "name": "krise@erlandsen.com", "code": "krise@erlandsen.com" }, { "name": "jeff@erlandsen.com", "code": "jeff@erlandsen.com" }, { "name": "jonnababe@gmail.com", "code": "jonnababe@gmail.com" }, { "name": "karenpeele@gmail.com", "code": "karenpeele@gmail.com" }, { "name": "bvtowing@hotmail.com", "code": "bvtowing@hotmail.com" }, { "name": "rpeterson@rh2.com", "code": "rpeterson@rh2.com" }, { "name": "thads.winton@outlook.com", "code": "thads.winton@outlook.com" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AgntPhone", "type": "esriFieldTypeString", "alias": "AgntPhone", "length": 50, "domain": { "type": "codedValue", "name": "DevelopmentAgentPhone", "description": "Phone numbers for agents", "codedValues": [ { "name": "509-884-2562", "code": "509-884-2562" }, { "name": "509-679-3506", "code": "509-679-3506" }, { "name": "509-782-2441", "code": "509-782-2441" }, { "name": "509-548-5290", "code": "509-548-5290" }, { "name": "509-662-4781", "code": "509-662-4781" }, { "name": "509-687-6360", "code": "509-687-6360" }, { "name": "509-663-8660", "code": "509-663-8660" }, { "name": "509-669-2454", "code": "509-669-2454" }, { "name": "509-860-8749", "code": "509-860-8749" }, { "name": "509-689-2529", "code": "509-689-2529" }, { "name": "509-682-4189", "code": "509-682-4189" }, { "name": "509-888-3556", "code": "509-888-3556" }, { "name": "509-436-1640", "code": "509.436.1640" }, { "name": "509-679-3116", "code": "509.679.3116" }, { "name": "509-670-4318", "code": "509-670-4318" }, { "name": "509-433-4358", "code": "509-433-4358" }, { "name": "509-670-3529", "code": "509-670-3529" }, { "name": "509-548-4733", "code": "509-548-4733" }, { "name": "509-548-5228", "code": "509-548-5228" }, { "name": "509-663-0544", "code": "509-663-0544" }, { "name": "509-884-6563", "code": "509-884-6563" }, { "name": "509-662-3202", "code": "509-662-3202" }, { "name": "509-630-5518", "code": "509-630-5518" }, { "name": "509-470-1960", "code": "509-470-1960" }, { "name": "509-670-0503", "code": "509-670-0503" }, { "name": "509-433-4607", "code": "509-433-4607" }, { "name": "509-630-6061", "code": "509-630-6061" }, { "name": "509-630-6309", "code": "509-630-6309" }, { "name": "509-682-1600", "code": "509-682-1600" }, { "name": "509-886-6770", "code": "509-886-6770" }, { "name": "360-352-1465", "code": "360-352-1465" }, { "name": "509-554-3885", "code": "509-554-3885" }, { "name": "425-956-4668", "code": "425-956.4668" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lots", "type": "esriFieldTypeInteger", "alias": "Lots", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "ExpireYear", "type": "esriFieldTypeInteger", "alias": "ExpireYear", "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": "Asbuilts", "type": "esriFieldTypeString", "alias": "Asbuilt Plans", "length": 255, "domain": null }, { "name": "ProposedPlat", "type": "esriFieldTypeString", "alias": "Proposed Plat", "length": 255, "domain": null }, { "name": "ParcelNo", "type": "esriFieldTypeString", "alias": "Parcel Number", "length": 12, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "COA", "type": "esriFieldTypeString", "alias": "COA", "length": 255, "domain": null }, { "name": "Book", "type": "esriFieldTypeString", "alias": "Book", "length": 10, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page", "length": 10, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "ConstPlans", "type": "esriFieldTypeString", "alias": "Construction Plans", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R963_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_7696_ParcelN", "fields": "ParcelNo", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_963", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_963", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S677_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PWSDE.SDE.DevelopmentConditions", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 0, "name": "PWSDE.SDE.StormwaterRequirements", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "6eb9d208d9b541b7b793acb2a4eacb8e" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Stormwater Requirements", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ReqType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "approvalyear", "type": "esriFieldTypeString", "alias": "Approval Year", "length": 10, "domain": null }, { "name": "LotStatus", "type": "esriFieldTypeString", "alias": "Lot Status", "length": 25, "domain": { "type": "codedValue", "name": "StormwaterLotSystem_Status", "description": "The stormwater requirements of individual lot owners", "codedValues": [ { "name": "With Drainage Plan", "code": "2" }, { "name": "Without Drainage Plan", "code": "3" }, { "name": "Nothing Submitted", "code": "4" }, { "name": "Nothing Further Required", "code": "5" }, { "name": "Lot Requirements", "code": "1" }, { "name": "Unknown", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DesignType", "type": "esriFieldTypeString", "alias": "Type of design", "length": 50, "domain": { "type": "codedValue", "name": "StormwaterLotSystemType", "description": "The type of stormwater required", "codedValues": [ { "name": "Unknown", "code": "0" }, { "name": "Natural Dispersion", "code": "1" }, { "name": "Drainage Structure", "code": "2" }, { "name": "Other", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "AFN", "type": "esriFieldTypeString", "alias": "AFN", "length": 25, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "Mapped", "type": "esriFieldTypeString", "alias": "SW Mapped?", "length": 255, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes, No or N/A domain", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" }, { "name": "N/A", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ProjName", "type": "esriFieldTypeString", "alias": "Project Name", "length": 255, "domain": null }, { "name": "ProjType", "type": "esriFieldTypeString", "alias": "Project Type", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeGUID", "alias": "ParentID", "length": 38, "domain": null }, { "name": "ReqType", "type": "esriFieldTypeString", "alias": "Requirement Type", "length": 255, "domain": { "type": "codedValue", "name": "StormwaterReqType", "description": "The type of stormwater requirement for project completion", "codedValues": [ { "name": "Unknown", "code": "0" }, { "name": "Drainage Report", "code": "1" }, { "name": "PW Approval Letter", "code": "2" }, { "name": "O & M Agreement", "code": "3" }, { "name": "Notice to Title", "code": "4" }, { "name": "Engineer's Certification", "code": "5" }, { "name": "Other", "code": "6" }, { "name": "TESC", "code": "7" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProjNumb", "type": "esriFieldTypeString", "alias": "Project Number", "length": 50, "domain": null } ], "indexes": [ { "name": "R1059_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1059", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_19925_Parent", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1059", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PWSDE.SDE.DevelopmentSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Dev Inspection Notes", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ConditionMet", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ConditionMet", "type": "esriFieldTypeString", "alias": "Was this condition satisfied?", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SiteVisited", "type": "esriFieldTypeString", "alias": "Was this a site visit?", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes:", "length": 255, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeGUID", "alias": "Parent ID", "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 } ], "indexes": [ { "name": "R1057_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1057", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1057", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_14692_Parent", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PWSDE.SDE.DevelopmentConditions", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "Dev Conditions", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "DevelopmentConditionType1", "description": "Type of condition of approval for development", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Road Naming", "code": "Road Naming" }, { "name": "Pre-Construction Meeting", "code": "Pre-Construction Meeting" }, { "name": "Compaction Tests", "code": "Compaction Tests" }, { "name": "Monumentation", "code": "Monumentation" }, { "name": "Joint Access Maintenance Agreement", "code": "Joint Access Maintenance Agreement" }, { "name": "Construction Asbuilts", "code": "Construction Asbuilts" }, { "name": "Individual Lot Drainage Plans", "code": "Individual Lot Drainage Plans" }, { "name": "Lot Closure Calculations", "code": "Lot Closure Calculations" }, { "name": "Install Street Signs", "code": "Install Street Signs" }, { "name": "Blueline Review - 1st", "code": "Blueline Review - 1st" }, { "name": "Final Mylar", "code": "Final Mylar" }, { "name": "PW Fees", "code": "PW Fees" }, { "name": "Traffic Impact Study", "code": "Traffic Impact Study" }, { "name": "Sight Distance Analysis", "code": "Sight Distance Analysis" }, { "name": "Work in the ROW Permit", "code": "Work in ROW Permit" }, { "name": "Blueline Review - 2nd", "code": "Blueline Review - 2nd" }, { "name": "Blueline Review - 3rd", "code": "Blueline Review - 3rd" }, { "name": "Permit Access(es)", "code": "Permit Access(es)" }, { "name": "Additional ROW", "code": "Additional ROW" }, { "name": "Development Agreement", "code": "Development Agreement" }, { "name": "Bridge", "code": "Bridge" }, { "name": "Construction", "code": "Construction" }, { "name": "Notice to Title", "code": "Notice to Title" }, { "name": "Deviation Request", "code": "Deviation Request" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "City", "code": "City" }, { "name": "Lot Access Plans", "code": "Lot Access Plans" }, { "name": "Address Assignments", "code": "Address Assignments" }, { "name": "Off Site Improvements or Road Development Agreement", "code": "Off Site Improvements or Road Development Agreement" }, { "name": "Deed for Additional ROW", "code": "Deed for Additional ROW" }, { "name": "Mitigation Agreement", "code": "Mitigation Agreement" }, { "name": "Preliminary Construction Plans", "code": "Preliminary Construction Plans" }, { "name": "Drainage Plan Required", "code": "Drainage Plan Required" }, { "name": "Drainage Plan Not Required", "code": "Drainage Plan Not Required" }, { "name": "Drainage Plan Undetermined", "code": "Drainage Plan Undetermined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Received", "type": "esriFieldTypeDate", "alias": "Date Condition Documents Received", "length": 8, "domain": null }, { "name": "Approval", "type": "esriFieldTypeDate", "alias": "Condition Approval Date", "length": 8, "domain": null }, { "name": "ProjNumb", "type": "esriFieldTypeString", "alias": "Project Number", "length": 50, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeGUID", "alias": "Parent ID", "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": "AFN", "type": "esriFieldTypeString", "alias": "AFN", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R996_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_14639_Parent", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_996", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_996", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PWSDE.SDE.DevelopmentInspectionNotes", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 1, "name": "PWSDE.SDE.DevelopmentSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "TESC Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_BMPType", "description": "Type of BMP Inspection", "codedValues": [ { "name": "Construction", "code": "1" }, { "name": "Post-Construction", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_BMPDevelopmentSite", "description": "Structural BMP Condition", "codedValues": [ { "name": "Unknown", "code": "1" }, { "name": "Needs Work", "code": "2" }, { "name": "Good", "code": "3" }, { "name": "Excellent", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TESC_Utilized", "type": "esriFieldTypeString", "alias": "TESC_Utilized", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TESC_Cond", "type": "esriFieldTypeString", "alias": "TESC_Cond", "length": 255, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_BMPDevelopmentSite", "description": "Structural BMP Condition", "codedValues": [ { "name": "Unknown", "code": "1" }, { "name": "Needs Work", "code": "2" }, { "name": "Good", "code": "3" }, { "name": "Excellent", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ParcelNO", "type": "esriFieldTypeString", "alias": "Parcel No", "length": 20, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeGUID", "alias": "ParentID", "length": 38, "domain": null } ], "indexes": [ { "name": "R904_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_904", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_904", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_7597_ParcelN", "fields": "ParcelNO", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }