{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Stormwater - Decentralized BMP", "type": "Feature Layer", "description": "

Stormwater decentralized BMP is an inventory based on known construction asbuilt data and field inspections.<\/SPAN><\/P><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "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 }, "copyrightText": "Schema provided by ESRI's small stormwater system", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "assettype", "defaultSymbol": { "type": "esriPMS", "url": "e660b9b6bfe41c73f98b26e50d018bb3", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABZElEQVQokY2TsWrCUBSG/yE4iiHDHbxgEgyCg4NThz5A6WpXhxZx6dClQ7v0FVoKpdDFBygIvkLpIE6lgZKgYAInqUEwQe2iDl3URnvT5ow/fN9/D5cj4fdwAFlBDgAEYBoPpH3YMIw7xtihiHYc55WIzuKSHYGiKHVN02q6rgvrc7lcLYqil/l8fi8ScFVVG0kwAHDOoWnahWma7fU6PwJFUerFYjGZXk+5XNaJ6DwMw+u44EBV1YYsy//xkGUZhmGc9nq9DoCuBCBbKBSaado3UyqVmO/7l0R0IgGYLpdLnslk0vIAgNVq9bldwff9G9u2K9VqlaWBh8NhMBqNHrcCAN1+v9/K5/NXjP3tCIIAg8HgGcBHXIAwDB8syzpmjFWS4MViAcdx3jftOwIARES3RNTinAsFk8nki4ieNu37Asxms7Zpms0oioQ/4nne23g87sSz/VuYuq575Lqu+AmCY/oGKPOK9xI2pP0AAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "2f94fc8f76e77ee9085ec341e024491e", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABf0lEQVQokY2TvUsCARjGn+FaAj9Q0uxOLRVKgiIcbLDAIYhosylwKMSloaWhlv6FIoigxT8gkNyCBiFKxEpUUCG09FDP7lDRyz5IoUXt1LN8xwd+v4eXl5dA/1AApCI5AOQA1IQB0QsbKPuxWjlrE6NpJnCbZ8PbQkmXQCkzOadIm2OSXBatl0koR5XP3rx9lE7EBJRWY3UNggGAVFmgn1jajacvva11fgVKmclp1NoNA+nWzBjWDQU2slPhMwdCwaJWY3XJJfr/eMglehh19q2HuMcHIEgAkGrHre5h2ttj0q2oGS66l2fDGwSAWqP5SY0Qo8PyAIBm84vprMBw0cMUfT03P72pHgbOFgKvxVL8rCMAEEzTfo9mbGFfpTD/CbPlJF5y/gsACaEAFT5z+pS9WlMpzHOD4O/GO7KFu1i7vUsAIFdg74/y7KOHVFlEBeXqc53hYuft9l4B+DrnTaS87iqfE70Iw4UjXCXpE2a9v1Cji6FVuhiiBmzR90w/M36Koy0Wk/UAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "127", "label": "Sediment Trap" }, { "symbol": { "type": "esriPMS", "url": "9d7c682bf67511c2d866aa3f403859ec", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABgUlEQVQokWNhwAQyDAwMfFjEGRgYGJ4wMDB8QhZgQdccbqgxwUpR0gab7k1X7x7Ze/NRErIhKAYYSIvGBuqpBAfrq2K1XlVUMPj683eHnn36MgmbATLeWkopuDQzMDAwuKrLMwTqq+RPPXxhHdQ7CAMMpEVjw43UlXDqhoJ0Kz2lA3ceZ199/rYS2QALby2lFE1xYUL6GTTFhRnCDdUT654f28jAwHCChYGBgc9TSyGNGNthINZEW/zg3Scle28+CmFhYGD49PXXbxlednZi9TMwMDAw/Pj15zncC4fuPK1bfOaqXqWLuTgxmjddufPy6P1n0+EGMDAwnFh5/uZ8J1W5CnN5SbyaTz58zrDq/M3VDAwM15ANYLj6/O3UBSevepnLS+rh0vzpxy+GDZfvXILZjmIAAwPDk503HvTvvvlwvqu6PFYDrjx/8/Xw3SezYLajG8Dw+MPndZMPnU+7/fo91hjZd+vxhZMPX2xEFkPPC5+2X7/vsf36fRkcvsDITAAULIoJRimttAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "128", "label": "Settling Basin" }, { "symbol": { "type": "esriPMS", "url": "2a0cc3ec92cb0d0fd0181a898cdb9ecd", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABSklEQVQokY2Tv0sCARiGn+FmV5ebHBpukBsPaRMkHG5QQRxECtGhoaWhUPoXioMIGhQnwcAfwy16gpcN5xbJhTg5HETrgYNbQ2mn3pXv+MHzvHx8fAL7EYGQzxzAAVzvQNiFcznuYjGO/ehejxfD4Mwr2RLIMvlUinQm419/dER6NuPZcdD8BKKqUgyCARIJSKW40DTaP+v8CmSZfDZLJBj/TrlMZDjk3La59goUVaUoSf/hIEmQy3FardIDLAEIJZOUDmlfp1AgPBpxaRhkBMBdLhFDQYcLyGrFx2YF0+Sm0SBaqRA+BO52+RyPedgIAKvZpB6Pc6Uof8OWBa0WT8C7V4Btc1+rkVQUokGw60Knw9u6fUsAOIMBt/0+9UTCXzCdsjRNHtftuwIWC9qaRmk+97/IcMjrZELPO9v9BVfXOdF1xIAt9p7pC4pLZsu5p0iWAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "129", "label": "Oil/Water Separator" }, { "symbol": { "type": "esriPMS", "url": "8712404adf220195ccd0f8c3016c224d", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABgElEQVQokWNhwAQyDAwMfFjEGRgYGJ4wMDB8QhZgQdccJGM9wURI3Qab7h3PTx059PpKErIhKAbo8CvEekmZBftKWWC1XplHMvjOl+eHnn1/OwmbATJuEsYpuDQzMDAwOIjpMXhKmeXPvbt9HdQ7CAN0+BViA2WslHDqhoIEBRelo68uZ9/4/KQS2QALNwnjFDVeGUL6GdR4ZRgCZa0T26+t3MjAwHCChYGBgc9F3CCNGNthIEzWXvzo66slh15fCWFhYGD49O3PTxkeFk5i9TMwMDAw/Pr35zncC8feXq9b9figXoFakDgxmrc/P/PyxNsb0+EGMDAwnFj/+Oh8WxHdCmMhVbyaz767zbDp6bHVDAwM15ANYLjx+cnU5Y/2exkLqerh0vz5z3eG7c9PXYLZjmIAAwPDkwOvL/UfeHVpvoMYdjOuf3r09eiba7NgtqMbwPD46+t1s+9uS7v75TnWGDn8+vKFc+/vbEQWQ88Ln/a8PO+x5+V5XAkCIzMBADxMifrT2jWlAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "130", "label": "Hydrodynamic Separator" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 97, 184, 138, 255 ], "toColor": [ 97, 184, 138, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 232, 88, 230, 255 ], "toColor": [ 232, 88, 230, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 237, 116, 95, 255 ], "toColor": [ 237, 116, 95, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 86, 119, 186, 255 ], "toColor": [ 86, 119, 186, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 238, 109, 255 ], "toColor": [ 247, 238, 109, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 161, 71, 120, 255 ], "toColor": [ 161, 71, 120, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 128, 109, 52, 255 ], "toColor": [ 128, 109, 52, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 92, 87, 242, 255 ], "toColor": [ 92, 87, 242, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 109, 242, 94, 255 ], "toColor": [ 109, 242, 94, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 197, 162, 255 ], "toColor": [ 242, 197, 162, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 94, 50, 135, 255 ], "toColor": [ 94, 50, 135, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 110, 204, 235, 255 ], "toColor": [ 110, 204, 235, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 145, 242, 255 ], "toColor": [ 202, 145, 242, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1669192.0903359652, "ymin": 132981.52746972442, "xmax": 1807846.4449164718, "ymax": 329516.8030335605, "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": "assettype", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "assetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "assettype", "type": "esriFieldTypeSmallInteger", "alias": "Asset Type", "domain": { "type": "codedValue", "name": "Stormwater_Asset_Type_Structure_Junction_Decentralized_BMP", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Bio-Filtration", "code": 121 }, { "name": "Bio-Retention", "code": 122 }, { "name": "Bioswale", "code": 123 }, { "name": "Filtration Device", "code": 124 }, { "name": "Infiltration Feature", "code": 125 }, { "name": "Pervious Pavement", "code": 126 }, { "name": "Sediment Trap", "code": 127 }, { "name": "Settling Basin", "code": 128 }, { "name": "Oil/Water Separator", "code": 129 }, { "name": "Hydrodynamic Separator", "code": 130 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "Stormwater_Asset_Owner", "description": "", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": 2 }, { "name": "Other", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "Maintained By", "domain": { "type": "codedValue", "name": "Stormwater_Asset_Manager", "description": "", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": 2 }, { "name": "Other", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "areatreated", "type": "esriFieldTypeDouble", "alias": "Impervious Area Treated (acres)", "domain": null }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "Stormwater_Pipe_Diameter", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "1/2\"", "code": 0.5 }, { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "capacity", "type": "esriFieldTypeDouble", "alias": "Treatment Capacity (cubic feet)", "domain": null }, { "name": "footprint", "type": "esriFieldTypeDouble", "alias": "Footprint (sq ft)", "domain": null }, { "name": "confinedspace", "type": "esriFieldTypeSmallInteger", "alias": "Confined Space", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "standingwater", "type": "esriFieldTypeSmallInteger", "alias": "Observation Port Standing Water", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "maintinterval", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Interval (months)", "domain": null }, { "name": "lowflowbypass", "type": "esriFieldTypeSmallInteger", "alias": "Low Flow Bypass", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dryweatherdiversion", "type": "esriFieldTypeSmallInteger", "alias": "Dry Weather Diversion", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "capturereuse", "type": "esriFieldTypeSmallInteger", "alias": "Capture and Reuse", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "assetcondition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": { "type": "codedValue", "name": "Stormwater_Structure_Junction_Decentralized_BMP_Condition", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "More Data Needed", "code": 1 }, { "name": "Inspection Due", "code": 2 }, { "name": "Inspected >4", "code": 3 }, { "name": "Inspected 3-4", "code": 4 }, { "name": "Inspected 2-3", "code": 5 }, { "name": "Inspected <2", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "obsaccumulation", "type": "esriFieldTypeSmallInteger", "alias": "Observation Port Accumulation", "domain": { "type": "codedValue", "name": "Stormwater_Yes_No", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "lifecyclestatus", "type": "esriFieldTypeSmallInteger", "alias": "Life Cycle Status", "domain": { "type": "codedValue", "name": "Stormwater_Lifecycle_Status", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Proposed", "code": 1 }, { "name": "Proposed - Approved", "code": 2 }, { "name": "Under Construction", "code": 4 }, { "name": "In Service", "code": 8 }, { "name": "In Service - To Be Retired", "code": 16 }, { "name": "Abandoned", "code": 32 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited User", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "length": 38, "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R912_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_912", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_912", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "DecentBMPIndex", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S653_idx", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PWSDE.SDE.DecentralizedBMPInspection", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "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": 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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "127bcc4bb12c45ec95aaf03cd9021bc4" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Decentralized BMP Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspectPerf", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "InspectPerf", "type": "esriFieldTypeString", "alias": "Was an inspection performed?", "length": 10, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Performed_Inspection", "description": "Was an inspection performed", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OverallCond", "type": "esriFieldTypeString", "alias": "What is the overall condition?", "length": 50, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Overall_Condition", "description": "What is the overall condition", "codedValues": [ { "name": "Unknown", "code": "1" }, { "name": "Poor", "code": "2" }, { "name": "Fair", "code": "3" }, { "name": "Good", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintPerf", "type": "esriFieldTypeString", "alias": "What maintenance was done?", "length": 50, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Maintenance_Performed", "description": "Was maintenance performed", "codedValues": [ { "name": "None", "code": "5" }, { "name": "Cleaned", "code": "6" }, { "name": "Repaired", "code": "7" }, { "name": "Replaced", "code": "8" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintNeed", "type": "esriFieldTypeString", "alias": "What maintenance is still needed?", "length": 50, "domain": { "type": "codedValue", "name": "Stormwater_Inspection_Maintenance_Needed", "description": "What additional maintenance is still needed", "codedValues": [ { "name": "None", "code": "9" }, { "name": "Clean", "code": "10" }, { "name": "Repair", "code": "11" }, { "name": "Replace", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Inspector Notes", "length": 255, "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "Parent GUID", "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R980_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_14212_Parent", "fields": "ParentGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_980", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_980", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PWSDE.SDE.Decentralized_BMP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,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 }, "serviceItemId": "127bcc4bb12c45ec95aaf03cd9021bc4" } ] }