{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "sw_Ctrl_Facilities", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103180, "latestWkid": 6597, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 102748, "latestWkid": 2285, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.006096012192, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "9e405b7a9d5bde93e347c3c198d05592", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABFElEQVQYlW2RL0gDcRTHP+GKKBO5MMQZdMEh+CcYzmITxGCwmGxDMQmCFpuCiM1LawsLDiyWi4YlFyacCMfhxhj6g9059fSYbGiRuzlxv923PHh83uP7vk8hWglAyE1Fhkbm2VSXSItLsu06OuBHwdrYOkdT+yyrGiS3Ob47YNUx2AOKXTjcNrpGenyDydh0ZzKoCxkWH3Suni44aQl0ZXiG1MQOh8ktBmWPAwmYOyMeS3FunyKUj3vsrwZN6Ie7atdxm2XswIZ4N3GBeBT47cNbCROwwgM/K+Rfi8wGh8nyLWjVKPyl4Znknq/ZVbX+7V4J1zO5/R+deLmh+phnSIYbhdCi1ZOzY7DiGPwG16MADB/zAys+VPak80lzAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 8, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1209335.7609819479, "ymin": 214399.5048577972, "xmax": 1231259.9307098466, "ymax": 263234.723445959, "spatialReference": { "wkid": 102748, "latestWkid": 2285, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.006096012192, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "FID", "domain": null }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "Entity who owns asset", "length": 25, "domain": { "type": "codedValue", "name": "SW_OwnerEntity", "description": "Owner or Agency that owns the asset", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "City of Bainbridge Island", "code": "COBI" }, { "name": "NOT City of Bainbridge Island", "code": "NOT COBI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 1000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "MaintainedBy", "type": "esriFieldTypeString", "alias": "Entity who maintains asset", "length": 254, "domain": { "type": "codedValue", "name": "SW_OwnerEntity", "description": "Owner or Agency that owns the asset", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "City of Bainbridge Island", "code": "COBI" }, { "name": "NOT City of Bainbridge Island", "code": "NOT COBI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Unique identifier for asset based on location in watershed (2 alpha-digits), type of service component (four alpha-digits), and old ID or random number (four numeric-digits)", "length": 10, "domain": null }, { "name": "Component", "type": "esriFieldTypeString", "alias": "Primary structure component for connection", "length": 255, "domain": { "type": "codedValue", "name": "SW_CtrlComponent", "description": "Storm and Surface Water Utility_Component primaily providing this type of flow or water quality control", "codedValues": [ { "name": "Bioretention", "code": "BIOR" }, { "name": "Flow Control", "code": "CTRL" }, { "name": "Proprietary Device", "code": "DEVC" }, { "name": "Dispersion", "code": "DISP" }, { "name": "Infiltration", "code": "INFL" }, { "name": "Other", "code": "OTHR" }, { "name": "Pavement", "code": "PAVE" }, { "name": "Pond", "code": "POND" }, { "name": "Tank", "code": "TANK" }, { "name": "Unknown", "code": "UNKN" }, { "name": "Vault", "code": "VALT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ComponentType", "type": "esriFieldTypeString", "alias": "Within the Puget Sound Stormwater Infrastructure Framework, Component Type is the finest classification for a structure. ", "length": 255, "domain": { "type": "codedValue", "name": "SW_CtrlComponentType", "description": "Storm and Surface Water Utility_Component type providing control of flow and or water quality", "codedValues": [ { "name": "Baffle", "code": "BAFL" }, { "name": "Bubble-up", "code": "BUBL" }, { "name": "Dispersal Trench", "code": "DITR" }, { "name": "Dispersion", "code": "DISP" }, { "name": "Dry Well", "code": "DWEL" }, { "name": "Flow Splitter", "code": "SPLT" }, { "name": "Infiltration", "code": "INFL" }, { "name": "Infiltration Trench", "code": "INTR" }, { "name": "Injection Well", "code": "INWL" }, { "name": "Modular Wetland", "code": "WETL" }, { "name": "None", "code": "NONE" }, { "name": "Other", "code": "OTHR" }, { "name": "Permeable Pavement", "code": "PAVE" }, { "name": "Pond", "code": "POND" }, { "name": "Sand Filter", "code": "SAND" }, { "name": "Settling Area", "code": "SETL" }, { "name": "Storm Chamber", "code": "CHBR" }, { "name": "StormTech", "code": "TECH" }, { "name": "Tank Detention Pipe", "code": "TANK" }, { "name": "Unknown", "code": "UNKN" }, { "name": "Vault", "code": "VALT" }, { "name": "Wet Well", "code": "WWEL" }, { "name": "Swale", "code": "SWAL" }, { "name": "Flow Control", "code": "CTRL" }, { "name": "Contech Stormfilter", "code": "CNTC" }, { "name": "Filterra", "code": "FTRA" }, { "name": "Oil/Water Separator", "code": "OWSP" }, { "name": "Stormceptor", "code": "STCP" }, { "name": "Vortech", "code": "VORT" }, { "name": "Bioswale", "code": "BSWL" }, { "name": "Bioretention", "code": "BIOR" }, { "name": "Rain Garden", "code": "RAIN" }, { "name": "Stormwater Planter Box", "code": "PBOX" }, { "name": "FROP-T", "code": "FROP" }, { "name": "Weir", "code": "WEIR" }, { "name": "Pollution Elbow", "code": "ELBO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataConfidence", "type": "esriFieldTypeString", "alias": "Data confidence based on data stage", "length": 255, "domain": { "type": "codedValue", "name": "SW_DataConfidence", "description": "Confidence of data quality", "codedValues": [ { "name": "Zero", "code": "Zero" }, { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LidCoverStyle", "type": "esriFieldTypeString", "alias": "Lid cover type style", "length": 20, "domain": { "type": "codedValue", "name": "SW_LidCoverStyle", "description": "Lid cover type style for all features", "codedValues": [ { "name": "Beehive", "code": "Beehive" }, { "name": "Birdcage", "code": "Birdcage" }, { "name": "Grate", "code": "Grate" }, { "name": "Solid", "code": "Solid" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ServiceStatus", "type": "esriFieldTypeString", "alias": "Current service status of component", "length": 25, "domain": { "type": "codedValue", "name": "SW_ServiceStatus", "description": "Current status of component", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Removed", "code": "Removed" }, { "name": "Pending", "code": "Pending" }, { "name": "Never Installed", "code": "Never Installed" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Data Entry Error", "code": "Data Entry Error" }, { "name": "Abandoned in Place", "code": "Abandoned in Place" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "Source of data", "length": 25, "domain": { "type": "codedValue", "name": "SW_DataSource", "description": "Source of Data", "codedValues": [ { "name": "CAD", "code": "CAD" }, { "name": "CCTV", "code": "CCTV" }, { "name": "Field", "code": "Field" }, { "name": "GPS", "code": "GPS" }, { "name": "Picked from aerial", "code": "Picked from aerial" }, { "name": "Plans", "code": "Plans" }, { "name": "Sketch", "code": "Sketch" }, { "name": "Survey", "code": "Survey" }, { "name": "LIDAR", "code": "LIDAR" }, { "name": "GIS Data", "code": "GIS Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "As-built plans", "code": "As-built Plans" }, { "name": "Approved Plans", "code": "Approved Plans" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataStage", "type": "esriFieldTypeString", "alias": "Stage of data record from unknown to verified", "length": 25, "domain": { "type": "codedValue", "name": "SW_DataStage", "description": "Stage of data record from unknown to verified", "codedValues": [ { "name": "Attributes are missing or incomplete", "code": "Needs attribution" }, { "name": "Location or attributes are in doubt, needs field verification", "code": "Needs field verification" }, { "name": "Feature is retired, and removed from QA/QC cycle", "code": "Archived" }, { "name": "Unknown data stage", "code": "Unknown" }, { "name": "Feature has been attributed and/or field verified, ready for QA-QC review and approval", "code": "QAQC" }, { "name": "Feature has been QA-QC'd and accepted as up-to-date", "code": "Accepted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateRemoved", "type": "esriFieldTypeDate", "alias": "Date component was removed from service", "length": 8, "domain": null }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "Date component was installed for service", "length": 8, "domain": null }, { "name": "LastInspectDate", "type": "esriFieldTypeDate", "alias": "Date when component was most recently inspected", "length": 8, "domain": null }, { "name": "LastInspectBy", "type": "esriFieldTypeString", "alias": "Who completed most recent component inspection", "length": 255, "domain": null }, { "name": "NumberOfCartridges", "type": "esriFieldTypeSmallInteger", "alias": "Number of cartridges", "domain": null }, { "name": "NumberOfCells", "type": "esriFieldTypeSmallInteger", "alias": "Number of cells", "domain": null }, { "name": "Underdrain", "type": "esriFieldTypeString", "alias": "Underdrain", "length": 255, "domain": { "type": "codedValue", "name": "SW_Boolean", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConfinedSpace", "type": "esriFieldTypeString", "alias": "ConfinedSpace", "length": 255, "domain": { "type": "codedValue", "name": "SW_Boolean", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 50, "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": 50, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "DataSourceLink", "type": "esriFieldTypeString", "alias": "Link to data source if any exsists", "length": 1000, "domain": null }, { "name": "Asset_ID_Manual", "type": "esriFieldTypeString", "alias": "Asset ID assigned by hand by Stormwater Management Program Coordinator starting in 2018 through present - Unique identifier for asset based on location in watershed (2 alpha-digits), type of service component-type for control facilities (four alpha-digit", "length": 75, "domain": null }, { "name": "MS4", "type": "esriFieldTypeString", "alias": "MS4", "length": 50, "domain": { "type": "codedValue", "name": "SW_Boolean", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlDevice", "type": "esriFieldTypeString", "alias": "Additional flow or water quality control device present", "length": 50, "domain": { "type": "codedValue", "name": "SW_CtrlDevice", "description": "Storm and Surface Water Utility_Device providing flow or water quality control in basin or facility", "codedValues": [ { "name": "Baffle", "code": "Baffle" }, { "name": "PollutionElbow", "code": "PollutionElbow" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "FlowSplitter", "code": "FlowSplitter" }, { "name": "Weir", "code": "Weir" }, { "name": "BubbleUp", "code": "BubbleUp" }, { "name": "Flow Restrictor Orifice PLate", "code": "FROP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Watershed", "type": "esriFieldTypeString", "alias": "Which of the twelve COBI watersheds is this physically located in?", "length": 255, "domain": { "type": "codedValue", "name": "SW_Watersheds", "description": "12 COBI Watersheds", "codedValues": [ { "name": "Agate Passage", "code": "AP" }, { "name": "Blakely Harbor", "code": "BH" }, { "name": "Eagledale", "code": "ED" }, { "name": "Fletcher Bay", "code": "FB" }, { "name": "Gazzam Lake", "code": "GL" }, { "name": "Manzanita Bay", "code": "MZ" }, { "name": "Murden Cove", "code": "MC" }, { "name": "North Eagle Harbor", "code": "EH" }, { "name": "Pleasant Beach", "code": "PB" }, { "name": "Port Madison", "code": "PM" }, { "name": "South Beach", "code": "SB" }, { "name": "Sunrise", "code": "SR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlowLink", "type": "esriFieldTypeString", "alias": "Identifying flow link connection between storm systems or receiving waters", "length": 255, "domain": { "type": "codedValue", "name": "SW_FlowLink", "description": "Identifying flow link connection between storm systems or receiving waters", "codedValues": [ { "name": "MS4 to MS4", "code": "MS4 to MS4" }, { "name": "NonMS4 to NonMS4", "code": "NonMS4 to NonMS4" }, { "name": "MS4 to nonMS4", "code": "MS4 to nonMS4" }, { "name": "Discharge to Infiltration", "code": "Discharge to Infiltration" }, { "name": "Receiving Water into MS4", "code": "Receiving Water into MS4" }, { "name": "MS4 to Receiving Water", "code": "MS4 to Receiving Water" }, { "name": "Receiving Water into nonMS4", "code": "Receiving Water into nonMS4" }, { "name": "nonMS4 to Receiving Water", "code": "nonMS4 to Receiving Water" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "nonMS4 to MS4", "code": "nonMS4 to MS4" }, { "name": "Receiving Water to Receiving Water", "code": "Receiving Water to Receiving Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateServiceActivated", "type": "esriFieldTypeDate", "alias": "Date facility was activated into service if known", "length": 8, "domain": null }, { "name": "CartridgeMediaType", "type": "esriFieldTypeString", "alias": "Type of filter media used in device", "length": 255, "domain": { "type": "codedValue", "name": "SW_CtrlCartridgeMediaType", "description": "Storm and Surface Water Utility_Type of filter media used in device", "codedValues": [ { "name": "PhosphoSorb", "code": "PhosphoSorb" }, { "name": "Perlite", "code": "Perlite" }, { "name": "Zeolite", "code": "Zeolite" }, { "name": "CFS Leaf Media", "code": "CFS" }, { "name": "Granular Activated Carbon", "code": "GAC" }, { "name": "Zeolite, Perlite, GAC", "code": "ZPG" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OverflowWindow", "type": "esriFieldTypeString", "alias": "Jail house window or other type of overflow in basin wall", "length": 3, "domain": { "type": "codedValue", "name": "SW_Boolean", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OutletDepth_inch", "type": "esriFieldTypeDouble", "alias": "Depth of outlet measured in inches", "domain": null }, { "name": "OutletElevation_feet", "type": "esriFieldTypeDouble", "alias": "Outlet Elevation measured in feet", "domain": null }, { "name": "SumpDepth_inch", "type": "esriFieldTypeDouble", "alias": "Measurement at lowest pipe invert to bottom of basin in inches", "domain": null }, { "name": "TotalDepth_inch", "type": "esriFieldTypeDouble", "alias": "Calculated measurement from top of basin to bottom of basin in inches", "domain": null }, { "name": "LidCoverElevation_feet", "type": "esriFieldTypeDouble", "alias": "Measurement of elevation above sea level of lid cover location in feet", "domain": null }, { "name": "LockingCover", "type": "esriFieldTypeString", "alias": "Lid or cover locking feature present or not present?", "length": 3, "domain": { "type": "codedValue", "name": "SW_Boolean", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WidthorDiameter_A_inch", "type": "esriFieldTypeDouble", "alias": "Width or Diameter \"A\" measured in inches", "domain": null }, { "name": "WidthorDiameter_B_inch", "type": "esriFieldTypeDouble", "alias": "Width or Diameter \"B\" measured in inches", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "LidCoverSize_inch", "type": "esriFieldTypeString", "alias": "Lid Cover Size measured in inches", "length": 255, "domain": { "type": "codedValue", "name": "SW_LidCoverSize_Inches", "description": "Lid cover size in inches for all features", "codedValues": [ { "name": "<8 round", "code": "<8 round" }, { "name": "8 round", "code": "8 round" }, { "name": "18 round", "code": "18 round" }, { "name": "21 round", "code": "21 round" }, { "name": "24 round", "code": "24 round" }, { "name": "36 round", "code": "36 round" }, { "name": "48 round", "code": "48 round" }, { "name": ">48 round", "code": ">48 round" }, { "name": "18x24 rectangle", "code": "18x24" }, { "name": "20x24 rectangle", "code": "20x24" }, { "name": "24x47 rectangle", "code": "24x47" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MinimumRequirement", "type": "esriFieldTypeString", "alias": "SWMMWW Minimum Requirement", "length": 255, "domain": null }, { "name": "FlaggerCountNeed", "type": "esriFieldTypeSmallInteger", "alias": "Number of certified flaggers for traffic control needed for inspections or maintenance", "domain": null }, { "name": "Vegetation_Maintenance_Req", "type": "esriFieldTypeString", "alias": "Routine vetegation maintenance is required", "length": 50, "domain": { "type": "codedValue", "name": "SW_VegMaintReq", "description": "Storm and Surface Water Utility_Routine vegetation maintenance is required", "codedValues": [ { "name": "No", "code": "NO" }, { "name": "Yes", "code": "YES" }, { "name": "No - Unless necessary", "code": "NO - Unless necessary" }, { "name": "Yes - But home owner may do", "code": "YES - But home owner may do" }, { "name": "Yes - First must inform property owner", "code": "YES - First must inform property owner" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "OM_Name - Common name used to refer to a facility", "length": 100, "domain": null }, { "name": "flag_cleaning", "type": "esriFieldTypeString", "alias": "flag_cleaning", "length": 255, "domain": null }, { "name": "flag_deferred", "type": "esriFieldTypeString", "alias": "flag_deferred", "length": 255, "domain": null }, { "name": "flag_location", "type": "esriFieldTypeString", "alias": "flag_location", "length": 255, "domain": null }, { "name": "flag_lock", "type": "esriFieldTypeString", "alias": "flag_lock", "length": 255, "domain": null }, { "name": "flag_ownership", "type": "esriFieldTypeString", "alias": "flag_ownership", "length": 255, "domain": null }, { "name": "flag_repair", "type": "esriFieldTypeString", "alias": "flag_repair", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_520", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R520_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S426_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GIS.DBO.sw_Conn_Ctrl_inspection_maintenance", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A1A1A3A-656A-4922-9E15-03CD5E772FC0}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746705542000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "dcbd867db0214958be9cfa5bf7ef57ab" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "sw_Ctrl_Facilities_ATTACH", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "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": "GDB_28057_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_521", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R521_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746706277000 }, "serviceItemId": "dcbd867db0214958be9cfa5bf7ef57ab" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "sw_Conn_Ctrl_inspection_maintenance", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inspection_AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 10, "domain": null }, { "name": "StructureType", "type": "esriFieldTypeString", "alias": "StructureType", "length": 255, "domain": null }, { "name": "GrateLidType", "type": "esriFieldTypeString", "alias": "GrateLidType", "length": 255, "domain": { "type": "codedValue", "name": "SW_LidCoverStyle", "description": "Lid cover type style for all features", "codedValues": [ { "name": "Beehive", "code": "Beehive" }, { "name": "Birdcage", "code": "Birdcage" }, { "name": "Grate", "code": "Grate" }, { "name": "Solid", "code": "Solid" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AccessOpen", "type": "esriFieldTypeString", "alias": "AccessOpen", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AccessLidLock", "type": "esriFieldTypeString", "alias": "AccessLidLock", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AccessLadder", "type": "esriFieldTypeString", "alias": "AccessLadder", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureGap", "type": "esriFieldTypeString", "alias": "StructureGap", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureDefectsTopside", "type": "esriFieldTypeString", "alias": "StructureDefectsTopside", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureDefectsInside", "type": "esriFieldTypeString", "alias": "StructureDefectsInside", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureSediment", "type": "esriFieldTypeString", "alias": "StructureSediment", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureDebris", "type": "esriFieldTypeString", "alias": "StructureDebris", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InletOutletDebris", "type": "esriFieldTypeString", "alias": "InletOutletDebris", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InletOutletImpairment", "type": "esriFieldTypeString", "alias": "InletOutletImpairment", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IllicitDischarge", "type": "esriFieldTypeString", "alias": "IllicitDischarge", "length": 255, "domain": { "type": "codedValue", "name": "SW_Boolean", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspection_Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1000, "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "insp_flag_location", "type": "esriFieldTypeString", "alias": "Flagged issue with feature location during inspection", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "insp_flag_deferred", "type": "esriFieldTypeString", "alias": "Flagged asset for deferred maintenance", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "insp_flag_ownership", "type": "esriFieldTypeString", "alias": "Flagged feature because asset ownership is in question", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "insp_flag_lock", "type": "esriFieldTypeString", "alias": "Flagged asset as having a locking mechanism", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "insp_flag_cleaning", "type": "esriFieldTypeString", "alias": "Flagged asset for cleaning during inspection", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "insp_flag_repair", "type": "esriFieldTypeString", "alias": "Flagged asset for repair during inspection", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FROP_T_secured", "type": "esriFieldTypeString", "alias": "Generic field for FROP-T questions about upright/secure/watertight", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FROP_T_orifice", "type": "esriFieldTypeString", "alias": "Generic field for FROP-T questions about orifice plate", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FROP_T_overflow", "type": "esriFieldTypeString", "alias": "Generic field for FROP-T questions about overflow pope", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FROP_T_rodchain", "type": "esriFieldTypeString", "alias": "Generic field for FROP-T questions about cleanout gate rod/chain pull", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FROP_T_gate", "type": "esriFieldTypeString", "alias": "Generic field for FROP-T questions about cleanout gate", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignEducationOutreach", "type": "esriFieldTypeString", "alias": "Generic field for 'Site' section signage question", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Fence", "type": "esriFieldTypeString", "alias": "Generic field for 'Site' section fence question", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bior_flowpath", "type": "esriFieldTypeString", "alias": "Bioretention-specific field for vegetation blocking flowpath", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bior_bare", "type": "esriFieldTypeString", "alias": "Bioretention-specific field for poor/bare groundcover", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bior_shade", "type": "esriFieldTypeString", "alias": "Bioretention-specific field for growth hindered by shade", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StandingWater", "type": "esriFieldTypeString", "alias": "Generic field for questions related to standing/slow-draining water", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bior_flowspread", "type": "esriFieldTypeString", "alias": "Bioretention-specific field for flow spread question", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Erosion", "type": "esriFieldTypeString", "alias": "Generic field for erosion-related questions", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VegetationOvergrown", "type": "esriFieldTypeString", "alias": "Generic field for questions related to overgrown vegetation", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureBaffle", "type": "esriFieldTypeString", "alias": "Generic field for 'Structure' section baffle questions", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "media_scum", "type": "esriFieldTypeString", "alias": "Media filter vault-specific field for question regarding scum on media filters", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "media_bypassed", "type": "esriFieldTypeString", "alias": "Media filter vault-specific field for question regarding bypass condition", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "owsp_oil", "type": "esriFieldTypeString", "alias": "Baffle/Coalescing Plate OWSP-specific 'Structure' section question on oil accumuilation", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Vent", "type": "esriFieldTypeString", "alias": "Generic field for 'Structure' section ventilation question", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "owsp_coalescing_plate", "type": "esriFieldTypeString", "alias": "Baffle/Coalescing Plate OWSP-specific 'Structure' section question on coaslescing plates", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "owsp_shutoff", "type": "esriFieldTypeString", "alias": "Baffle/Coalescing Plate OWSP-specific 'Structure' section question on shutoff valve", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "owsp_discharge", "type": "esriFieldTypeString", "alias": "Baffle/Coalescing Plate OWSP-specific 'Discharge' section question on discharged water quality", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pond_critters", "type": "esriFieldTypeString", "alias": "Pond-specific question to capture presence of hazardous insects, rodents, and beavers", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VegNoxious", "type": "esriFieldTypeString", "alias": "Generic question for presence of noxious vegetation", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pond_wall", "type": "esriFieldTypeString", "alias": "Pond-specific field for retaining wall damage", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pond_berm_settling", "type": "esriFieldTypeString", "alias": "Pond-specific field for settling of berms", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspection_date", "type": "esriFieldTypeDate", "alias": "date", "length": 8, "domain": null }, { "name": "StructureSpillway", "type": "esriFieldTypeString", "alias": "Spillway", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "media_sediment", "type": "esriFieldTypeString", "alias": "media_sediment", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pond_spillway", "type": "esriFieldTypeString", "alias": "pond_spillway", "length": 255, "domain": { "type": "codedValue", "name": "SW_InspectionFlags", "description": "Status flags from inspection data", "codedValues": [ { "name": "Deferred", "code": "Deferred" }, { "name": "Complete", "code": "Complete" }, { "name": "Satisfactory", "code": "Satisfactory" }, { "name": "Unsatisfactory", "code": "Unsatisfactory" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "GDB_35821_guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_546", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R546_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GIS.DBO.sw_Ctrl_Facilities", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A1A1A3A-656A-4922-9E15-03CD5E772FC0}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1751289955000 }, "serviceItemId": "dcbd867db0214958be9cfa5bf7ef57ab" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "sw_Conn_Ctrl_inspection_maintenance__ATTACH", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "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": "GDB_35826_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_550", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R550_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1751294394000 }, "serviceItemId": "dcbd867db0214958be9cfa5bf7ef57ab" } ] }