{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "SWMFAC", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "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": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 197, 255, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1301872.4733707607, "ymin": 351807.0689480901, "xmax": 1394454.0388634205, "ymax": 527076.0209029168, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.006096012192, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "BMP_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SWMFAC_ID", "type": "esriFieldTypeString", "alias": "SWMFAC ID", "length": 50, "domain": null }, { "name": "BMP_NAME", "type": "esriFieldTypeString", "alias": "BMP Name", "length": 100, "domain": null }, { "name": "BMP_TYPE", "type": "esriFieldTypeString", "alias": "BMP Type", "length": 5, "domain": { "type": "codedValue", "name": "dBMPType", "description": "Type of BMP", "codedValues": [ { "name": "Green Roof - Extensive", "code": "AGRE" }, { "name": "Green Roof - Intensive", "code": "AGRI" }, { "name": "Permeable Pavements", "code": "APRP" }, { "name": "Reinforced Turf", "code": "ARTF" }, { "name": "Bio-Reactor Carbon Filter", "code": "BRCT" }, { "name": "Disconnection of Illicit Discharges", "code": "DID" }, { "name": "Education", "code": "EDU" }, { "name": "Bioretention", "code": "FBIO" }, { "name": "Organic Filter (Peat Filter)", "code": "FORG" }, { "name": "Perimeter (Sand) Filter", "code": "FPER" }, { "name": "Floodplain Restoration", "code": "FPRES" }, { "name": "Sand Filter", "code": "FSND" }, { "name": "Underground Filter", "code": "FUND" }, { "name": "Infiltration Basin", "code": "IBAS" }, { "name": "Infiltration Trench", "code": "ITRN" }, { "name": "Enhanced Filters", "code": "MENF" }, { "name": "Infiltration Berms", "code": "MIBR" }, { "name": "Dry Well", "code": "MIDW" }, { "name": "Landscape infiltration", "code": "MILS" }, { "name": "Micro-Bioretention", "code": "MMBR" }, { "name": "Rain Gardens", "code": "MRNG" }, { "name": "Rainwater Harvesting", "code": "MRWH" }, { "name": "Submerged Gravel Wetlands", "code": "MSGW" }, { "name": "Bio-Swale", "code": "MSWB" }, { "name": "Grass Swale", "code": "MSWG" }, { "name": "Wet Swale", "code": "MSWW" }, { "name": "Disconnection of Non-Rooftop Runoff", "code": "NDNR" }, { "name": "Disconnection of Rooftop Runoff", "code": "NDRR" }, { "name": "Sheetflow to Conservation Areas", "code": "NSCA" }, { "name": "Dry Swale", "code": "ODSW" }, { "name": "Pet Waste Management", "code": "PET" }, { "name": "Micropool Extended Detention Pond", "code": "PMED" }, { "name": "Multiple Pond System", "code": "PMPS" }, { "name": "Pocket Pond", "code": "PPKT" }, { "name": "Extended Detention Structure, Wet", "code": "PWED" }, { "name": "Retention Pond (Wet Pond)", "code": "PWET" }, { "name": "River Bank Stabilization", "code": "RBS" }, { "name": "Step Pool Storm Conveyance", "code": "SPSC" }, { "name": "Sub-Soiling", "code": "SUB" }, { "name": "Trash Removal", "code": "TRA" }, { "name": "Extended Detention - Wetland", "code": "WEDW" }, { "name": "Pocket Wetland", "code": "WPKT" }, { "name": "Wet Pond - Wetland", "code": "WPWS" }, { "name": "Shallow Marsh", "code": "WSHW" }, { "name": "Extended Detention Structure, Dry", "code": "XDED" }, { "name": "Detention Structure (Dry Pond)", "code": "XDPD" }, { "name": "Flood Management Area", "code": "XFLD" }, { "name": "Oil Grit separator", "code": "XOGS" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MD_NORTH", "type": "esriFieldTypeDouble", "alias": "MD North", "domain": null }, { "name": "MD_EAST", "type": "esriFieldTypeDouble", "alias": "MD East", "domain": null }, { "name": "WATERSHED8DGT", "type": "esriFieldTypeString", "alias": "Watershed 8DGT", "length": 8, "domain": { "type": "codedValue", "name": "dMD8digit", "description": "Maryland 8 digit hydrologic unit code", "codedValues": [ { "name": "Anacostia River", "code": "02140205" }, { "name": "Mattawoman Creek", "code": "02140111" }, { "name": "Oxon Creek", "code": "02140204" }, { "name": "Patuxent River lower", "code": "02131101" }, { "name": "Patuxent River middle", "code": "02131102" }, { "name": "Patuxent River upper", "code": "02131104" }, { "name": "Piscataway Creek", "code": "02140203" }, { "name": "Potomac River M tidal", "code": "02140102" }, { "name": "Potomac River U tidal", "code": "02140201" }, { "name": "Rocky Gorge Dam", "code": "02131107" }, { "name": "Western Branch", "code": "02131103" }, { "name": "Zekiah Swamp", "code": "02140108" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IMP_ACRES", "type": "esriFieldTypeDouble", "alias": "Impervious Acres", "domain": null }, { "name": "APPR_DATE", "type": "esriFieldTypeDate", "alias": "Approval Date", "length": 8, "domain": null }, { "name": "BUILT_DATE", "type": "esriFieldTypeDate", "alias": "Built Date", "length": 8, "domain": null }, { "name": "BMP_CLASS", "type": "esriFieldTypeString", "alias": "BMP Classification", "length": 1, "domain": { "type": "codedValue", "name": "dBMPClass", "description": "Class of BMP", "codedValues": [ { "name": "Alternative BMP", "code": "A" }, { "name": "ESD", "code": "E" }, { "name": "Structural BMP", "code": "S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 75, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 5, "domain": null }, { "name": "BMP_INSP_STATUS", "type": "esriFieldTypeString", "alias": "BMP Inspection Status", "length": 1, "domain": { "type": "codedValue", "name": "dPassFail_2", "description": "BMP Status Pass/Fail", "codedValues": [ { "name": "Fail", "code": "F" }, { "name": "Pass", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAST_INSP_DATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "MAINTENANCE_DIST", "type": "esriFieldTypeString", "alias": "Maintenance District", "length": 50, "domain": { "type": "codedValue", "name": "D_Maintenance", "description": "Maintenance Districts", "codedValues": [ { "name": "Maintenance District 1", "code": "1" }, { "name": "Maintenance District 2", "code": "2" }, { "name": "Maintenance District 3", "code": "3" }, { "name": "Maintenance District 4", "code": "4" }, { "name": "Maintenance District 5N", "code": "5N" }, { "name": "Maintenance District 5S", "code": "5S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNCIL_DISTRICT", "type": "esriFieldTypeString", "alias": "Council District", "length": 50, "domain": { "type": "codedValue", "name": "D_District_Council", "description": "Councilmanic District", "codedValues": [ { "name": "District 1", "code": "1" }, { "name": "District 2", "code": "2" }, { "name": "District 3", "code": "3" }, { "name": "District 4", "code": "4" }, { "name": "District 5", "code": "5" }, { "name": "District 6", "code": "6" }, { "name": "District 7", "code": "7" }, { "name": "District 8", "code": "8" }, { "name": "District 9", "code": "9" }, { "name": "District 10", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MOWED_BY", "type": "esriFieldTypeString", "alias": "Mowed By", "length": 50, "domain": { "type": "codedValue", "name": "dOSDM_Maintenance", "description": "Who maintains the OSDM ponds", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3 " }, { "name": "In-House", "code": "IH " }, { "name": "Clean Water Partnership", "code": "CWP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IN_STREAM", "type": "esriFieldTypeString", "alias": "In Stream", "length": 1, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FENCE_MAT", "type": "esriFieldTypeString", "alias": "Fence Material", "length": 8, "domain": { "type": "codedValue", "name": "D_Fence", "description": "Fence Material", "codedValues": [ { "name": "Primarily Composed of Wood", "code": "Wood" }, { "name": "Primarily Metal with no other Treatment", "code": "Metal" }, { "name": "Metal with Plastic Coating", "code": "Coated" }, { "name": "Primarily Composed of PVC", "code": "PVC" }, { "name": "Other", "code": "Other" }, { "name": "No Fence", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DAM_HEIGHT", "type": "esriFieldTypeDouble", "alias": "Dam Height", "domain": null }, { "name": "SEEP_CONT", "type": "esriFieldTypeString", "alias": "Seepage Condition", "length": 1, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEEP_CONT_COMMENTS", "type": "esriFieldTypeString", "alias": "Seepage Condition Comments", "length": 200, "domain": null }, { "name": "FILTER_DIA", "type": "esriFieldTypeString", "alias": "Filter DIA", "length": 50, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HAZ_CLASS", "type": "esriFieldTypeString", "alias": "High Hazard Pond Classifications", "length": 50, "domain": { "type": "codedValue", "name": "D_Haz_Class", "description": "Classification of pond if it is High Hazard", "codedValues": [ { "name": "Class A", "code": "A" }, { "name": "Class B", "code": "B" }, { "name": "Class C", "code": "C" }, { "name": "MD 378 SWMF", "code": "MD 378" }, { "name": "Null", "code": "NULL" }, { "name": "MD 378 SWMF - Low Hazard", "code": "MD 378 - Low" }, { "name": "MD 378 SWMF - Significant Hazard", "code": "MD 378 - Sig" }, { "name": "MD 378 SWMF - High Hazard", "code": "MD 378 - High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS_OVERALL", "type": "esriFieldTypeString", "alias": "Comments - Overall", "length": 120, "domain": null }, { "name": "Q_1YR", "type": "esriFieldTypeDouble", "alias": "1 Year Discharge in cfs", "domain": null }, { "name": "Q_2YR", "type": "esriFieldTypeDouble", "alias": "2 Year Discharge in cfs", "domain": null }, { "name": "Q_10YR", "type": "esriFieldTypeDouble", "alias": "10 Year Discharge in cfs", "domain": null }, { "name": "Q_100YR", "type": "esriFieldTypeDouble", "alias": "100 Year Discharge in cfs", "domain": null }, { "name": "WS_ELEV_WQv", "type": "esriFieldTypeDouble", "alias": "Water Quality Volume (Cubic Feet)", "domain": null }, { "name": "WSELEV_1_CPv", "type": "esriFieldTypeDouble", "alias": "24 Hour Extended Detention Elevation for the 1 Year Event", "domain": null }, { "name": "WSELEV_2_CPv", "type": "esriFieldTypeDouble", "alias": "24 Hour Extended Detention Elevation for the 2 Year Event", "domain": null }, { "name": "WSELEV_10_CPv", "type": "esriFieldTypeDouble", "alias": "24 Hour Extended Detention Elevation for the 10 Year Event", "domain": null }, { "name": "WSELEV_100_CPv", "type": "esriFieldTypeDouble", "alias": "24 Hour Extended Detention Elevation for the 100 Year Event", "domain": null }, { "name": "FOUR_MI_VICINITY_AIRPORT", "type": "esriFieldTypeString", "alias": "BMP is within 4 Miles of Airport", "length": 1, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited User", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "length": 8, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "LAST_INSP_RATING", "type": "esriFieldTypeString", "alias": "Last Inspection Rating", "length": 50, "domain": { "type": "codedValue", "name": "d_Pond_Perform_Rating", "description": "Pond Performance Rating", "codedValues": [ { "name": "0 - NOT part of design ", "code": "0" }, { "name": "A - Functioning as designed - NO problems.", "code": "A" }, { "name": "B - Minor issues - Functioning, may require annual inspection", "code": "B" }, { "name": "C - Moderate issues - Functioning, performance compromised. Sched. Maint", "code": "C" }, { "name": "D - Major issues - NOT Functioning. Failure Possible. Maint. immed.", "code": "D" }, { "name": "E - Severe issues - NOT Functioning. Impending failure. Maint. immed.", "code": "E" }, { "name": "NR - Insuff. Inspect./ No Access", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ReInspectFY", "type": "esriFieldTypeSmallInteger", "alias": "Reinspecting Fiscal Year", "domain": null }, { "name": "InspectingFirm", "type": "esriFieldTypeString", "alias": "Inspecting Firm", "length": 75, "domain": { "type": "codedValue", "name": "dInspectingFirm", "description": "Inspecting Firm", "codedValues": [ { "name": "DPW&T", "code": "DPW" }, { "name": "Consultant 1", "code": "C1" }, { "name": "Consultant 2", "code": "C2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionStatus", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 10, "domain": { "type": "codedValue", "name": "dInspectionStatus", "description": "Inspection Status for current task", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "T" }, { "name": "NA", "code": "N" }, { "name": "Re-Inspect", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Current_Insp_Type", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 25, "domain": { "type": "codedValue", "name": "dInspectionType_1", "description": "Type of Inspection", "codedValues": [ { "name": "New Inspection", "code": "N" }, { "name": "Re-Inspection", "code": "R" }, { "name": "Maintenance Re-Inspection", "code": "M" }, { "name": "Do Not Inspect", "code": "D" }, { "name": "NR Re-Inspection", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "responsibility", "type": "esriFieldTypeString", "alias": "Responsibility", "length": 25, "domain": { "type": "codedValue", "name": "dResponsibility", "description": "Organization responsible for facitlity", "codedValues": [ { "name": "Corvias", "code": "Corvias" }, { "name": "Other", "code": "Other" }, { "name": "PG County Public Works and Transportation", "code": "DPWT" }, { "name": "Maryland State Highway Administration", "code": "SHA" }, { "name": "Maryland Department of the Environment", "code": "DOE" }, { "name": "Unknown", "code": "Unknown" }, { "name": "State", "code": "State" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MS4_Report", "type": "esriFieldTypeString", "alias": "MS4 Report", "length": 50, "domain": { "type": "codedValue", "name": "dMS4", "description": "MS4 Permit", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAST_MAINT_DATE", "type": "esriFieldTypeDate", "alias": "Last Maintenance Date", "length": 8, "domain": null }, { "name": "FY_Maint_Status", "type": "esriFieldTypeString", "alias": "Present FY Maintenance Status", "length": 255, "domain": { "type": "codedValue", "name": "dMaintStatus", "description": "Maintenance Status", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "TD" }, { "name": "In-Progress", "code": "IP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRU_NO", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 8, "domain": null }, { "name": "ConsentDecree", "type": "esriFieldTypeString", "alias": "Consent Decree BMP", "length": 255, "domain": { "type": "codedValue", "name": "dCD", "description": "Consent Decree", "codedValues": [ { "name": "II6a", "code": "a" }, { "name": "II6c Restoration BMPs", "code": "c" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 255, "domain": null }, { "name": "SWMFAC_GUID", "type": "esriFieldTypeGUID", "alias": "SWMFAC_GUID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "LAST_MOW_DATE", "type": "esriFieldTypeDate", "alias": "Last Mow Date", "length": 8, "domain": null }, { "name": "ProjectedMaintStatus", "type": "esriFieldTypeString", "alias": "Projected Maintenance Status", "length": 255, "domain": { "type": "codedValue", "name": "dMaintStatus", "description": "Maintenance Status", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "TD" }, { "name": "In-Progress", "code": "IP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintInspStatus", "type": "esriFieldTypeString", "alias": "Maintenance Inspection Status", "length": 255, "domain": { "type": "codedValue", "name": "dInspectionStatus", "description": "Inspection Status for current task", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "T" }, { "name": "NA", "code": "N" }, { "name": "Re-Inspect", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintResp", "type": "esriFieldTypeString", "alias": "Maintenance Responsibility", "length": 255, "domain": { "type": "codedValue", "name": "dOSDM_Maintenance", "description": "Who maintains the OSDM ponds", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3 " }, { "name": "In-House", "code": "IH " }, { "name": "Clean Water Partnership", "code": "CWP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MowingAcres", "type": "esriFieldTypeDouble", "alias": "Acres to Mow", "domain": null }, { "name": "ETL_Run", "type": "esriFieldTypeDate", "alias": "ETL Run Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R677_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_677", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I5334SWMFAC_ID", "fields": "SWMFAC_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5334SWMFAC_GUID", "fields": "SWMFAC_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S336_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SWMFAC_FOOTPRINT", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{E665C48C-DA7A-4D3F-BEDE-656BD19CAAF2}" }, { "id": 3, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F621B05E-A5D6-4F61-9A8B-8058CC3DB1F5}" }, { "id": 1, "name": "SWMFAC_AS_BUILTS", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{983D5450-060F-4B93-B29F-E201F2CE92B6}" }, { "id": 2, "name": "SWMFAC_MAINTENANCE", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{6101526F-FDE0-490D-AACC-F09221B63C4D}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "SWMFAC_Footprint", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "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": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 223, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 43.67816091954023, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1301658.798273176, "ymin": 351581.0428253412, "xmax": 1394498.167384088, "ymax": 527108.135668084, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.006096012192, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ACRES", "type": "esriFieldTypeDouble", "alias": "Acres", "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": "STRU_NOd", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 8, "domain": null }, { "name": "SWMFAC_GUID", "type": "esriFieldTypeGUID", "alias": "SWMFAC_GUID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R679_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_679", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5336SWMFAC_GUID", "fields": "SWMFAC_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S338_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SWMFAC", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SWMFAC_GUID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{E665C48C-DA7A-4D3F-BEDE-656BD19CAAF2}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "SWMFAC_Districts_Maintenance", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "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": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 242, 214, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 255, 255 ], "width": 2 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1290286.6251514256, "ymin": 317373.1699682623, "xmax": 1406405.4956035018, "ymax": 533632.9999149293, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.006096012192, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "District_n", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ESMGDB.PGCSW.SWMFAC_DISTRICTS_MAINTENANCE.AREA", "type": "esriFieldTypeDouble", "alias": "ESMGDB.PGCSW.SWMFAC_DISTRICTS_MAINTENANCE.AREA", "domain": null }, { "name": "PERIMETER", "type": "esriFieldTypeDouble", "alias": "PERIMETER", "domain": null }, { "name": "DISTRICT_", "type": "esriFieldTypeInteger", "alias": "DISTRICT_", "domain": null }, { "name": "DISTRICT_I", "type": "esriFieldTypeInteger", "alias": "DISTRICT_I", "domain": null }, { "name": "District_n", "type": "esriFieldTypeString", "alias": "District_n", "length": 16, "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": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R678_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_678", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S337_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "SWMFAC_As_Builts", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AS_BUILT_PLAN_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "AS_BUILT_PLAN_ID", "type": "esriFieldTypeString", "alias": "Contract ID", "length": 50, "domain": null }, { "name": "TITLE", "type": "esriFieldTypeString", "alias": "Title", "length": 120, "domain": null }, { "name": "YEAR_BUILT", "type": "esriFieldTypeInteger", "alias": "Year Built", "domain": null }, { "name": "PLAN_DATE", "type": "esriFieldTypeDate", "alias": "Plan Date", "length": 8, "domain": null }, { "name": "COM_AS_BUILTS", "type": "esriFieldTypeString", "alias": "Completed As Builts", "length": 200, "domain": null }, { "name": "V_DATUM", "type": "esriFieldTypeString", "alias": "V Datum", "length": 12, "domain": { "type": "codedValue", "name": "d_V_Datum", "description": "Vertical Datum", "codedValues": [ { "name": "NGVD 29", "code": "1929" }, { "name": "NAVD 88", "code": "1988" }, { "name": "Other", "code": "OTHER" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FILE_LOCATION", "type": "esriFieldTypeString", "alias": "File Location", "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": "STRU_NOc", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 8, "domain": null }, { "name": "SWMFAC_GUID", "type": "esriFieldTypeGUID", "alias": "SWMFAC_GUID", "length": 38, "domain": null } ], "indexes": [ { "name": "R667_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_667", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5323SWMFAC_GUID", "fields": "SWMFAC_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SWMFAC", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SWMFAC_GUID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{983D5450-060F-4B93-B29F-E201F2CE92B6}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Maintenance", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Maintenance_Status", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SWMFAC_GUID", "type": "esriFieldTypeGUID", "alias": "SWMFAC_GUID", "length": 38, "domain": null }, { "name": "Maintenance_Date", "type": "esriFieldTypeDate", "alias": "Maintenance Date", "length": 8, "domain": null }, { "name": "Maintenance_Status", "type": "esriFieldTypeString", "alias": "Maintenance Status", "length": 255, "domain": { "type": "codedValue", "name": "dMaintStatus", "description": "Maintenance Status", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "TD" }, { "name": "In-Progress", "code": "IP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 255, "domain": { "type": "codedValue", "name": "dOSDM_Maintenance", "description": "Who maintains the OSDM ponds", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3 " }, { "name": "In-House", "code": "IH " }, { "name": "Clean Water Partnership", "code": "CWP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "STRU_NOb", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 8, "domain": null }, { "name": "Inspection_Status", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 255, "domain": { "type": "codedValue", "name": "dInspectStat", "description": "Inspection Status", "codedValues": [ { "name": "Inspected", "code": "I" }, { "name": "Needs Inspection", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "Cost_Maintenance", "type": "esriFieldTypeDouble", "alias": "Cost of Maintenance", "domain": null } ], "indexes": [ { "name": "R665_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_665", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5321SWMFAC_GUID", "fields": "SWMFAC_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "SWMFAC", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SWMFAC_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{6101526F-FDE0-490D-AACC-F09221B63C4D}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECTR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SWMFAC_GUID", "type": "esriFieldTypeGUID", "alias": "SWMFAC_GUID", "length": 38, "domain": null }, { "name": "DATE_INSP", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "INSPECTR", "type": "esriFieldTypeString", "alias": "Inspector Name(s)", "length": 255, "domain": null }, { "name": "DATE_STORM", "type": "esriFieldTypeDate", "alias": "Date of Last Storm Event", "length": 8, "domain": null }, { "name": "MOW", "type": "esriFieldTypeString", "alias": "Ability to mow designation areas", "length": 255, "domain": { "type": "codedValue", "name": "d_Mowability_Rating", "description": "Mowability Note side slopes in comments", "codedValues": [ { "name": "0 - NO Mowing Required", "code": "0" }, { "name": "1 - Slopes 4:1 or flatter or tractor.", "code": "1" }, { "name": "2 - Emb./Spillway/Outfall flat. Other components are too steep.", "code": "2" }, { "name": "3 - Same as above but too steep to be kept clear w/o hand equipment.", "code": "3" }, { "name": "4 - All components are too steep.", "code": "4" }, { "name": "5 - All components are too steep. Large Specialized equipment required.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MOW_COM", "type": "esriFieldTypeString", "alias": "Comment - Mowing", "length": 255, "domain": null }, { "name": "ACCESS_FACILITY", "type": "esriFieldTypeString", "alias": "Access to and around the facility", "length": 255, "domain": { "type": "codedValue", "name": "d_Access_Rating", "description": "Vegetation is an obstruction for ALL", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - 5 Criteria Met", "code": "1" }, { "name": "2 - 4 Criteria Met", "code": "2" }, { "name": "3 - 3 Criteria Met", "code": "3" }, { "name": "4 - 1 or 2 Criteria Met", "code": "4" }, { "name": "5 - 0 Criteria Met", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COM_ACCESS", "type": "esriFieldTypeString", "alias": "Comment - Access", "length": 255, "domain": null }, { "name": "WILDLIFE_EXISTS", "type": "esriFieldTypeString", "alias": "Signs of Wildlife Activity", "length": 255, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WILDLIFE_COMMENT", "type": "esriFieldTypeString", "alias": "Comment - Wildlife", "length": 255, "domain": null }, { "name": "OUTFALL", "type": "esriFieldTypeString", "alias": "Outfall of the principal spillway", "length": 255, "domain": { "type": "codedValue", "name": "d_Spillway_Outfall_Rating", "description": "Blockage at Outfall plus 25\u2019", "codedValues": [ { "name": "1 - No stream erosion. Stable channel invert/slopes. No debris.", "code": "1" }, { "name": "2 - 0 to 25%; Minor erosion. Stable channel invert/ slopes.", "code": "2" }, { "name": "3 - 26 to 50%; Moderate/Active erosion bottom/slopes. RRP Minor relocation.", "code": "3" }, { "name": "4 - 51 to 75%; Major/Unstable. RRP Major relocation. Maint. Immediately", "code": "4" }, { "name": "5 - 75 to 100%; Severe/NO veg. w/ Major RRP relocation. Maint. Immediately", "code": "5" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTFALL_COM", "type": "esriFieldTypeString", "alias": "Comment - Outfall", "length": 255, "domain": null }, { "name": "DS_CONDITION", "type": "esriFieldTypeString", "alias": "Overall condition downstream of outfall", "length": 255, "domain": { "type": "codedValue", "name": "d_DS_Condition", "description": "Downstream Channel Condition", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Absent of erosion.", "code": "1" }, { "name": "2 - Minor - Stable. No headcutting", "code": "2" }, { "name": "3 - Major but not affecting veg and unstable. Headcut forming", "code": "3" }, { "name": "4 - Major with veg loss and unstable. Fallen trees and major headcut", "code": "4" }, { "name": "5 - Completely eroded and unstable. Major headcut. Maint Immediately", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DS_CONDITION_COM", "type": "esriFieldTypeString", "alias": "Comment - Downstream Condition", "length": 255, "domain": null }, { "name": "RED_FLAG", "type": "esriFieldTypeString", "alias": "Does the site require immediate attention?", "length": 50, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RED_FLAG_COM", "type": "esriFieldTypeString", "alias": "Comment - Red Flag", "length": 255, "domain": null }, { "name": "RATING", "type": "esriFieldTypeString", "alias": "Rating", "length": 255, "domain": { "type": "codedValue", "name": "d_Pond_Perform_Rating", "description": "Pond Performance Rating", "codedValues": [ { "name": "0 - NOT part of design ", "code": "0" }, { "name": "A - Functioning as designed - NO problems.", "code": "A" }, { "name": "B - Minor issues - Functioning, may require annual inspection", "code": "B" }, { "name": "C - Moderate issues - Functioning, performance compromised. Sched. Maint", "code": "C" }, { "name": "D - Major issues - NOT Functioning. Failure Possible. Maint. immed.", "code": "D" }, { "name": "E - Severe issues - NOT Functioning. Impending failure. Maint. immed.", "code": "E" }, { "name": "NR - Insuff. Inspect./ No Access", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "Comments - General", "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": "QC_Complete", "type": "esriFieldTypeString", "alias": "QC Complete", "length": 50, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QC_initials", "type": "esriFieldTypeString", "alias": "QC Initials", "length": 32, "domain": null }, { "name": "inspection_type", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 50, "domain": { "type": "codedValue", "name": "dInspectionType_1", "description": "Type of Inspection", "codedValues": [ { "name": "New Inspection", "code": "N" }, { "name": "Re-Inspection", "code": "R" }, { "name": "Maintenance Re-Inspection", "code": "M" }, { "name": "Do Not Inspect", "code": "D" }, { "name": "NR Re-Inspection", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fiscal_year", "type": "esriFieldTypeSmallInteger", "alias": "Fiscal Year", "domain": null }, { "name": "STRU_NOa", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 8, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "BMP_TYPE2", "type": "esriFieldTypeString", "alias": "BMP Type", "length": 255, "domain": { "type": "codedValue", "name": "dBMPType_1", "description": "MDE BMP Type", "codedValues": [ { "name": "Green Roof - Extensive", "code": "AGRE" }, { "name": "Green Roof - Intensive", "code": "AGRI" }, { "name": "Permeable Pavements", "code": "APRP" }, { "name": "Reinforced Turf", "code": "ARTF" }, { "name": "Bio-Reactor Carbon Filter", "code": "BRCT" }, { "name": "Disconnection of Illicit Discharges", "code": "DID" }, { "name": "Education", "code": "EDU" }, { "name": "Bioretention", "code": "FBIO" }, { "name": "Organic Filter (Peat Filter)", "code": "FORG" }, { "name": "Perimeter (Sand) Filter", "code": "FPER" }, { "name": "Floodplain Restoration", "code": "FPRES" }, { "name": "Sand Filter", "code": "FSND" }, { "name": "Underground Filter", "code": "FUND" }, { "name": "Infiltration Basin", "code": "IBAS" }, { "name": "Infiltration Trench", "code": "ITRN" }, { "name": "Enhanced Filters", "code": "MENF" }, { "name": "Infiltration Berms", "code": "MIBR" }, { "name": "Dry Well", "code": "MIDW" }, { "name": "Landscape infiltration", "code": "MILS" }, { "name": "Micro-Bioretention", "code": "MMBR" }, { "name": "Rain Gardens", "code": "MRNG" }, { "name": "Rainwater Harvesting", "code": "MRWH" }, { "name": "Submerged Gravel Wetlands", "code": "MSGW" }, { "name": "Bio-Swale", "code": "MSWB" }, { "name": "Grass Swale", "code": "MSWG" }, { "name": "Wet Swale", "code": "MSWW" }, { "name": "Disconnection of Non-Rooftop Runoff", "code": "NDNR" }, { "name": "Disconnection of Rooftop Runoff", "code": "NDRR" }, { "name": "Sheetflow to Conservation Areas", "code": "NSCA" }, { "name": "Dry Swale", "code": "ODSW" }, { "name": "Pet Waste Management", "code": "PET" }, { "name": "Micropool Extended Detention Pond", "code": "PMED" }, { "name": "Multiple Pond System", "code": "PMPS" }, { "name": "Pocket Pond", "code": "PPKT" }, { "name": "Extended Detention Structure, Wet", "code": "PWED" }, { "name": "Retention Pond (Wet Pond)", "code": "PWET" }, { "name": "River Bank Stabilization", "code": "RBS" }, { "name": "Step Pool Storm Conveyance", "code": "SPSC" }, { "name": "Sub-Soiling", "code": "SUB" }, { "name": "Trash Removal", "code": "TRA" }, { "name": "Extended Detention - Wetland", "code": "WEDW" }, { "name": "Pocket Wetland", "code": "WPKT" }, { "name": "Wet Pond - Wetland", "code": "WPWS" }, { "name": "Shallow Marsh", "code": "WSHW" }, { "name": "Extended Detention Structure, Dry", "code": "XDED" }, { "name": "Detention Structure (Dry Pond)", "code": "XDPD" }, { "name": "Flood Management Area", "code": "XFLD" }, { "name": "Oil Grit separator", "code": "XOGS" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DNE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R666_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_666", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5322SWMFAC_GUID", "fields": "SWMFAC_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5322INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "SWMFAC_INSPECTIONS_ACTIONS", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{50E1B0EB-0D98-4AF8-849B-1061223A0F48}" }, { "id": 8, "name": "SWMFAC_INSPECTIONS_OBSERVATIONWELLS", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{661AFA17-D1ED-4420-9FC1-192872AB955B}" }, { "id": 11, "name": "SWMFAC_SUB_INSP_SWALES", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9B1C4A23-601E-43AF-B34C-34D2923F991C}" }, { "id": 9, "name": "SWMFAC_SUB_INSP_UNDERGROUND", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{0CB5E96D-804C-4CE2-B8D1-6E4AFD389440}" }, { "id": 6, "name": "SWMFAC_SUB_INSP_PONDS", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{03979293-D72A-4B3B-AEB4-898CC6F10DCD}" }, { "id": 7, "name": "SWMFAC_INSPECTIONS_INFLOWS", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F2167004-84FF-40FF-B64C-8CCCB1A3D34D}" }, { "id": 4, "name": "SWMFAC_SUB_INSP_FILTERINGSYSTEMS", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{A6EE4DEB-508D-4421-B157-9DCFF6FEEA0B}" }, { "id": 5, "name": "SWMFAC_SUB_INSP_INFILTRATIONFACILITY", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{432811FB-A9F0-4970-B5D8-E133AF308FD3}" }, { "id": 3, "name": "SWMFAC", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SWMFAC_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F621B05E-A5D6-4F61-9A8B-8058CC3DB1F5}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Ponds", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DEBRIS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "DEBRIS", "type": "esriFieldTypeString", "alias": "Debris in or near facility", "length": 255, "domain": { "type": "codedValue", "name": "dRatingDebris", "description": "Debris Rating", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Absent or accumulations \u2013 see above.", "code": "1" }, { "name": "2 - 0 to 25% of surface, Minor.", "code": "2" }, { "name": "3 - 26 to 50% of surface, Moderate. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75% of surface, Major. Maint. immediately.", "code": "4" }, { "name": "5 - Overwhelming. Maint. immediately.", "code": "5" }, { "name": "NR - Could not inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEBRIS_COM", "type": "esriFieldTypeString", "alias": "Comment - Debris", "length": 255, "domain": null }, { "name": "SEDIMENT", "type": "esriFieldTypeString", "alias": "Quantify sedimentation in pond", "length": 255, "domain": { "type": "codedValue", "name": "dRatingSediment", "description": "Sediment Rating", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Absent.", "code": "1" }, { "name": "2 - 10%, Minor. Doesn\u2019t block low flow.", "code": "2" }, { "name": "3 - 10 to 30%, Moderate. Fully blocks the low flow. Schedule Maint.", "code": "3" }, { "name": "4 - 30 to 50%, Major. Fully blocks the low flow. Maint. immediately", "code": "4" }, { "name": "5 - 50% plus, Severe. Maint. immediately.", "code": "5" }, { "name": "NR - Could not inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEDIMENT_COM", "type": "esriFieldTypeString", "alias": "Comment - Sedimentation", "length": 255, "domain": null }, { "name": "INFLOW_COND", "type": "esriFieldTypeString", "alias": "Overall Condition of Inflows (see Inflows table for evaluation of each inflow)", "length": 255, "domain": { "type": "codedValue", "name": "d_Inflow_Con_Rating", "description": "outfall POINT from ditch/Struct. and last SD joint", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - No problems.", "code": "1" }, { "name": "2 - Minor sedimentation/structural damage. No Maint. required.", "code": "2" }, { "name": "3 - Moderate (undermining ect.). Schedule Maint.", "code": "3" }, { "name": "4 - Major. Schedule Maint.", "code": "4" }, { "name": "5 - Complete blockage. Immediate Maint.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLOW_COND_COM", "type": "esriFieldTypeString", "alias": "Comment - Inflow Condition", "length": 255, "domain": null }, { "name": "IN_FLOW_STABILITY", "type": "esriFieldTypeString", "alias": "Stability of discharges into pond (ditches and outfalls)", "length": 255, "domain": { "type": "codedValue", "name": "d_Inflow_Stability_Rating", "description": "Full swale or pipe LENGTH and sheet flow", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Functioning properly.", "code": "1" }, { "name": "2 - Minor erosion. Monitored.", "code": "2" }, { "name": "3 - Moderate erosion - actively occurring. Schedule Maint.", "code": "3" }, { "name": "4 - Major erosion - Integrity compromised. Immediate Maint.", "code": "4" }, { "name": "5 - Severe erosion - Embankment failure anticipated. Immediate Maint.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IN_FLOW_STABILITY_COM", "type": "esriFieldTypeString", "alias": "Comment - Inflow Stability", "length": 255, "domain": null }, { "name": "PONDING", "type": "esriFieldTypeString", "alias": "Unwanted or extended ponding in pond", "length": 255, "domain": { "type": "codedValue", "name": "d_Ponding_Rating", "description": "DRY BMP after 72-HR. Measure OW if exists.", "codedValues": [ { "name": "0 - BMP is a WET Facility or \u201cOW\u201d not installed as required.", "code": "0" }, { "name": "1 - As designed. (%) = [measured OW water depth ÷ OW Full depth] x 100", "code": "1" }, { "name": "2 - Minor; 0 to 25% volume.", "code": "2" }, { "name": "3 - Moderate; 26 to 50% volume.", "code": "3" }, { "name": "4 - Major; 51 to 75% volume.", "code": "4" }, { "name": "5 - Major plus EM Spwy utilized", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PONDING_COM", "type": "esriFieldTypeString", "alias": "Comment - Ponding", "length": 255, "domain": null }, { "name": "WATER_DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of standing water", "domain": null }, { "name": "WATER_DEPTH_COM", "type": "esriFieldTypeString", "alias": "Comment - Water Depth", "length": 255, "domain": null }, { "name": "PERMPOOL", "type": "esriFieldTypeString", "alias": "Condition of pond with permanent standing water", "length": 255, "domain": { "type": "codedValue", "name": "d_Perm_Pool_Rating", "description": "identifies volume loss", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "2 - 100 to 75% design. Note reasons for issues.", "code": "2" }, { "name": "3 - 75 to <50% design OR Moderate fluctuations.", "code": "3" }, { "name": "4 - 50 to <25% design OR Significant fluctuations.", "code": "4" }, { "name": "5 - <25% design OR Major fluctuations.", "code": "5" }, { "name": "1 - 100% Wet Storage as designed (or Greater).", "code": "1" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PERMPOOL_COM", "type": "esriFieldTypeString", "alias": "Comment - Permanent Pool", "length": 255, "domain": null }, { "name": "FOREBAY", "type": "esriFieldTypeString", "alias": "Overall Condition of any pre-treatment device", "length": 255, "domain": { "type": "codedValue", "name": "d_Forebays_Rating", "description": "forebay, diaphragm, filter strip, bioret. mulch layer, ect.", "codedValues": [ { "name": "0 - Designed with NO Pretreatment.", "code": "0" }, { "name": "1 - Absent of vegetation, woody/leafy debris, garbage, &/or sediment.", "code": "1" }, { "name": "2 - 0 to 25%; Minor accumulations.", "code": "2" }, { "name": "3 - 26 to 50%; Moderate. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%; Major. Maint. immediately.", "code": "4" }, { "name": "5 - 75 to 100%; Maint. immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FOREBAY_COM", "type": "esriFieldTypeString", "alias": "Comment - Forebay", "length": 255, "domain": null }, { "name": "CS_OPEN", "type": "esriFieldTypeString", "alias": "Riser/Control Structure Openings", "length": 255, "domain": { "type": "codedValue", "name": "d_Control_Struct_Rating", "description": "ALL openings/Single Pipe/\u201dCombo\" ", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Absent of woody/leafy, sedimentation, & garbage debris.", "code": "1" }, { "name": "2 - 0 to 25%", "code": "2" }, { "name": "3 - 26 to 50%. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%. Schedule Maint.", "code": "4" }, { "name": "5 - >75%. Embankment compromised. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CS_OPEN_COM", "type": "esriFieldTypeString", "alias": "Comment - Riser/Control Structure Openings", "length": 255, "domain": null }, { "name": "CS_TRSH", "type": "esriFieldTypeString", "alias": "Riser/Control Structure Trashrack", "length": 255, "domain": { "type": "codedValue", "name": "d_Control_Struct_Trash_Rack_Rating", "description": "damage/debris", "codedValues": [ { "name": "0 - if N/A", "code": "0" }, { "name": "1 - Absent of garbage/woody/leafy debris. Functioning properly.", "code": "1" }, { "name": "2 - 0 t 25% blocked; functioning properly w/ Minor damage.", "code": "2" }, { "name": "3 - 26 to 50%; partly functioning w/ Mod. damage. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%; compromised w/ Major damage. Maint. Immediately.", "code": "4" }, { "name": "5 - 75 to 100%; same as above \u2013 Compromised. Maint. Immediately", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CS_TRSH_COM", "type": "esriFieldTypeString", "alias": "Comment - Riser/Control Structure Trashrack", "length": 255, "domain": null }, { "name": "CS_SEDI", "type": "esriFieldTypeString", "alias": "Riser/Control Structure Sediment or Debris", "length": 255, "domain": { "type": "codedValue", "name": "d_Control_Struct_Sediment_Rating", "description": "Riser Floor", "codedValues": [ { "name": "0 - 0 if Weir", "code": "0" }, { "name": "1 - Absent of woody/leafy, sedimentation, & garbage debris.", "code": "1" }, { "name": "2 - 0 to 25% of outlet.", "code": "2" }, { "name": "3 - 26 to 50%. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%. Maint. Immediately.", "code": "4" }, { "name": "5 - 75 to 100%. Emb. Compromised. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CS_SEDI_COM", "type": "esriFieldTypeString", "alias": "Comment - Riser/Control Structure Sediment or Debris", "length": 255, "domain": null }, { "name": "CS_STRC", "type": "esriFieldTypeString", "alias": "Riser/Control Structure Cracks, Spalling, Joints", "length": 255, "domain": { "type": "codedValue", "name": "d_Control_Struct_Rating", "description": "ALL openings/Single Pipe/\u201dCombo\" ", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Absent of woody/leafy, sedimentation, & garbage debris.", "code": "1" }, { "name": "2 - 0 to 25%", "code": "2" }, { "name": "3 - 26 to 50%. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%. Schedule Maint.", "code": "4" }, { "name": "5 - >75%. Embankment compromised. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CS_STRC_COM", "type": "esriFieldTypeString", "alias": "Comment - Riser/Control Structure Cracks, Spalling, Joints", "length": 255, "domain": null }, { "name": "CS_VALV", "type": "esriFieldTypeString", "alias": "Riser/Control Structure Valve", "length": 255, "domain": { "type": "codedValue", "name": "d_Control_Struct_Value_Rating", "description": "chain/lock Req\u2019d", "codedValues": [ { "name": "0 - No valve.", "code": "0" }, { "name": "1 - Valve is functional & is chained & locked.", "code": "1" }, { "name": "2 - Same as above but debris may start to compromise functionality.", "code": "2" }, { "name": "3 - Chained & locked but NOT functioning properly.", "code": "3" }, { "name": "4 - No chain & lock or damaged. Maint. suggested.", "code": "4" }, { "name": "5 - Failed. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CS_VALV_COM", "type": "esriFieldTypeString", "alias": "Comment - Riser/Control Structure Valve", "length": 255, "domain": null }, { "name": "ORF_OPEN", "type": "esriFieldTypeString", "alias": "Low-flow orifice opening", "length": 255, "domain": { "type": "codedValue", "name": "d_Orifice_Open_Rating", "description": "OPENING \u2013 veg./debris blockage ", "codedValues": [ { "name": "0 - If N/A", "code": "0" }, { "name": "1 - Absent of blockages.", "code": "1" }, { "name": "2 - 0 to 25% blocked.", "code": "2" }, { "name": "3 - 25 to 50%. Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%. Maint. Immediately.", "code": "4" }, { "name": "5 - 75 to 100%. Embankment compromised. Maint. Immediately", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ORF_OPEN_COM", "type": "esriFieldTypeString", "alias": "Comment - Low-flow orifice opening", "length": 255, "domain": null }, { "name": "ORF_TRSH", "type": "esriFieldTypeString", "alias": "Low-flow orifice trashrack", "length": 255, "domain": { "type": "codedValue", "name": "d_Orifice_Trash_Rack_Rating", "description": "OPENING \u2013 Trash Rack or 2\u201d Stone. Damage/debris ", "codedValues": [ { "name": "0 - If N/A", "code": "0" }, { "name": "1 - Absent of garbage/woody/leafy debris. Functioning properly.", "code": "1" }, { "name": "2 - 0 t 25% blocked; functioning properly w/ minor damage.", "code": "2" }, { "name": "3 - 26 to 50%; partly functioning w/ Moderate damage. Sched. Maint.", "code": "3" }, { "name": "4 - 51 to 75%; Compromised w/ Major damage. Maint. Immediately.", "code": "4" }, { "name": "5 - 75 to 100%; same as above \u2013 Compromised. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ORF_TRSH_COM", "type": "esriFieldTypeString", "alias": "Comment - Low-flow orifice trashrack", "length": 255, "domain": null }, { "name": "EMGYSPW_PRESENT", "type": "esriFieldTypeString", "alias": "Emergency Spillway Present?", "length": 255, "domain": { "type": "codedValue", "name": "D_BooleanValues", "description": "Numeric Value 1 = True, 2 = False", "codedValues": [ { "name": "True", "code": "1" }, { "name": "False", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMGYSPW_STAB", "type": "esriFieldTypeString", "alias": "Emergency Spillway Stability", "length": 255, "domain": { "type": "codedValue", "name": "d_Emergency_SPWY_Stability_Rating", "description": "Erosion concern", "codedValues": [ { "name": "0 - NA or \u201cPrincipal/Emergency Spwy Combo\u201d", "code": "0" }, { "name": "1 - Stable & functioning properly.", "code": "1" }, { "name": "2 - Minor erosion but Stable.", "code": "2" }, { "name": "3 - Moderate erosion & crest invert remains stable. Schedule Maint.", "code": "3" }, { "name": "5 - Severe erosion - actively eroding. BMP compromised. Maint. Immed.", "code": "5" }, { "name": "4 - Major erosion. RRP Relocated. Potentially compromised. Maint. Immed.", "code": "4" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMGYSPW_STAB_COM", "type": "esriFieldTypeString", "alias": "Comment - Emergency Spillway Stability", "length": 255, "domain": null }, { "name": "EMGYSPW_OPEN", "type": "esriFieldTypeString", "alias": "Emergency Spillway Opening", "length": 255, "domain": { "type": "codedValue", "name": "d_Emergency_SPWY_Opening_Rating", "description": "Blockage concern", "codedValues": [ { "name": "0 - NA or \u201cPrincipal/Emergency Spwy Combo\u201d", "code": "0" }, { "name": "1 - Absent of garbage/woody/leafy debris. Functioning properly.", "code": "1" }, { "name": "2 - Minor blockage.", "code": "2" }, { "name": "3 - Moderate blockage. Schedule Maint.", "code": "3" }, { "name": "4 - Major blockage. Maint. Immediately.", "code": "4" }, { "name": "5 - Severe \u2013 Embankment Compromised. Maint. Immediately", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMGYSPW_OPEN_COM", "type": "esriFieldTypeString", "alias": "Comment - Emergency Spillway Opening", "length": 255, "domain": null }, { "name": "EMBUP_CVR", "type": "esriFieldTypeString", "alias": "Upstream Embankment - Cover/Vegetation", "length": 255, "domain": { "type": "codedValue", "name": "d_Upstream_Cover_Rating", "description": "Trees or Veg. cond., plus 25\u2019 radius at Riser", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Densely vegetated. (100% herbaceous cover \u2013 no woody vegetation)", "code": "1" }, { "name": "2 - 76 to 100% cover w/ minor sapling < 0.5\u201d dia.", "code": "2" }, { "name": "3 - 51 to 75% or woody veg. 0.5\u201d to 1.5\u201d. Schedule Maint.", "code": "3" }, { "name": "4 - 26 to 50% or major woody veg. > 1.5\u201d. Maint. Immediately.", "code": "4" }, { "name": "5 - 0 to 25% or severe woody veg. >1.5\u201d. Compromised. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBUP_CVR_COM", "type": "esriFieldTypeString", "alias": "Comment - Upstream Embankment - Cover/Vegetation", "length": 255, "domain": null }, { "name": "EMBUP_ERO", "type": "esriFieldTypeString", "alias": "Upstream Embankment - Erosion", "length": 255, "domain": { "type": "codedValue", "name": "d_Upstream_Emb_Stability_Rating", "description": "Erosion (settlement/cracking)", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Stable & absent of erosion.", "code": "1" }, { "name": "3 - Stable & Moderate erosion. Schedule Maint.", "code": "3" }, { "name": "4 - Major erosion. Integrity potentially compromised. Maint. Immediately.", "code": "4" }, { "name": "5 - Major erosion. BMP Integrity is compromised. Maint. Immediately", "code": "5" }, { "name": "2 - Stable & Minor Isolated erosion", "code": "2" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBUP_ERO_COM", "type": "esriFieldTypeString", "alias": "Comment - Upstream Embankment - Erosion", "length": 255, "domain": null }, { "name": "EMBUP_TOE", "type": "esriFieldTypeString", "alias": "Upstream Embankment - Toe Condition", "length": 255, "domain": { "type": "codedValue", "name": "d_Upstream_Emb_Toe_Rating", "description": "voids or settlement within 15\u2019", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - UPSTREAM Toe is stable.", "code": "1" }, { "name": "2 - Minor settling but Stable.", "code": "2" }, { "name": "3 - Moderate settlement or holes. Schedule Maint.", "code": "3" }, { "name": "4 - Major settlement or holes & Unstable. Maint. Immediately.", "code": "4" }, { "name": "5 - Severe settlement \u2013 Integrity compromised. Maint. Immediately", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBUP_TOE_COM", "type": "esriFieldTypeString", "alias": "Comment - Upstream Embankment - Toe Condition", "length": 255, "domain": null }, { "name": "EMBDS_CVR", "type": "esriFieldTypeString", "alias": "Downstream Embankment - Cover/Vegetation", "length": 255, "domain": { "type": "codedValue", "name": "d_Downstream_Cover_Rating", "description": "Trees or Veg. cond. on slope plus 15\u2019", "codedValues": [ { "name": "1 - Densely vegetated. (100% herbaceous cover \u2013 no woody vegetation)", "code": "1" }, { "name": "2 - 76 to 100% cover w/ minor sapling < 0.5\u201d dia.", "code": "2" }, { "name": "3 - 51 to 75% or woody veg. 0.5\u201d to 1.5\u201d. Schedule Maint.", "code": "3" }, { "name": "4 - 26 to 50% or major woody veg. > 1.5\u201d. Maint. Immediately.", "code": "4" }, { "name": "5 - 0 to 25% or severe woody veg. >1.5\u201d. Compromised. Maint. Immediately.", "code": "5" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBDS_CVR_COM", "type": "esriFieldTypeString", "alias": "Comment - Downstream Embankment - Cover/Vegetation", "length": 255, "domain": null }, { "name": "EMBDS_ERO", "type": "esriFieldTypeString", "alias": "Downstream Embankment - Erosion", "length": 255, "domain": { "type": "codedValue", "name": "d_Downstream_EMB_Stability_Rating", "description": "Pond Performance Rating", "codedValues": [ { "name": "1 - Stable & absent of erosion.", "code": "1" }, { "name": "3 - Stable & Moderate erosion. Schedule Maint.", "code": "3" }, { "name": "4 - Major erosion. Integrity potentially compromised. Maint. Immediately.", "code": "4" }, { "name": "5 - Major erosion. BMP Integrity is compromised. Maint. Immediately.", "code": "5" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "2 - Stable & Minor Isolated erosion", "code": "2" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBDS_ERO_COM", "type": "esriFieldTypeString", "alias": "Comment - Downstream Embankment - Erosion", "length": 255, "domain": null }, { "name": "EMBDS_TOE", "type": "esriFieldTypeString", "alias": "Downstream Embankment - Toe Condition", "length": 255, "domain": { "type": "codedValue", "name": "d_Downstream_EMB_Toe_Rating", "description": "voids or settlement within 15\u2019", "codedValues": [ { "name": "1 - DOWNSTREAM Toe is stable.", "code": "1" }, { "name": "2 - Minor settling but Stable.", "code": "2" }, { "name": "3 - Moderate settlement or holes. Schedule Maint.", "code": "3" }, { "name": "4 - Major settlement or holes & Unstable. Maint. Immediately.", "code": "4" }, { "name": "5 - Severe settlement \u2013 Integrity compromised. Maint. Immediately", "code": "5" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBDS_TOE_COM", "type": "esriFieldTypeString", "alias": "Comment - Downstream Embankment - Toe Condition", "length": 255, "domain": null }, { "name": "EMBDS_SEEP", "type": "esriFieldTypeString", "alias": "Downstream Embankment - Seepage condition (include filter)", "length": 255, "domain": { "type": "codedValue", "name": "d_Downstream_EMB_Seepage_Rating", "description": "Downstream Embankment Seepage", "codedValues": [ { "name": "1 - Stable & NO seepage.", "code": "1" }, { "name": "2 - Stable w/ Minor Saturation @ toe.", "code": "2" }, { "name": "3 - Moderate Saturation. Should be inspected/ monitored.", "code": "3" }, { "name": "4 - Major Saturation & Conc. flow. Compromised. Maint. Immediately.", "code": "4" }, { "name": "5 - Severe Saturation & Conc. flow. Compromised. Maint. Immediately.", "code": "5" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMBDS_SEEP_COM", "type": "esriFieldTypeString", "alias": "Comment \u2013 Downstream Embankment - Seepage condition", "length": 255, "domain": null }, { "name": "PRIN_SPWY", "type": "esriFieldTypeString", "alias": "Principal Spillway", "length": 255, "domain": { "type": "codedValue", "name": "d_Principal_Spillway_Rating", "description": "\u201cBarrel\u201d integrity/shape/gaps/blockages ", "codedValues": [ { "name": "2 - 0 to 25%, Minor (shape)", "code": "2" }, { "name": "3 - 26 to 50%, Moderate (corrosion/deflection). Schedule Maint.", "code": "3" }, { "name": "4 - 51 to 75%, Significant. Compromised. Maint. Immediately", "code": "4" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Absent of blockages (sediment or debris).", "code": "1" }, { "name": "5 - 75 to 100%, Critical thru full length. Compromised. Maint. Immediately.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRIN_SPWY_COM", "type": "esriFieldTypeString", "alias": "Comment - Principal Spillway", "length": 255, "domain": null }, { "name": "CONVEY_STABILITY", "type": "esriFieldTypeString", "alias": "Conveyance Stability", "length": 255, "domain": { "type": "codedValue", "name": "d_Conveyance_Stability_Rating", "description": "thru BMP Erosion (pilot channel/berm)", "codedValues": [ { "name": "1 - Stable.", "code": "1" }, { "name": "2 - Minor erosion & Stable.", "code": "2" }, { "name": "4 - Major erosion & signs of deterioration. Schedule Maint.", "code": "4" }, { "name": "0 - NOT part of design", "code": "0" }, { "name": "3 - Minor erosion & loss of ground cover, but feature is intact.", "code": "3" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONVEY_STABILITY_COM", "type": "esriFieldTypeString", "alias": "Comment - Conveyance Stability", "length": 255, "domain": null }, { "name": "SITE_VEGETATION", "type": "esriFieldTypeString", "alias": "Unwanted vegetation impacting site", "length": 255, "domain": { "type": "codedValue", "name": "d_Site_Vegetation_Rating", "description": "May to October; Excludes Routine Maint. & #36", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Well managed. No fallen trees. Access is clear. NO Maintenance.", "code": "1" }, { "name": "3 - 26 to 50% overgrown - access is difficult. Maint. Recommended.", "code": "3" }, { "name": "4 - 51 to 75% Very Difficult Access. Heavy Veg. @ Inflows. Schedule Maint.", "code": "4" }, { "name": "5 - 76 to 100% Impossible to Access & gate is sealed. Maint. Immediately.", "code": "5" }, { "name": "2 - 0 to 25% overgrown - access is clear.", "code": "2" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SITE_VEGETATION_COM", "type": "esriFieldTypeString", "alias": "Comment - Unwanted vegetation", "length": 255, "domain": null }, { "name": "POND_VEG", "type": "esriFieldTypeString", "alias": "Vegetation Condition specific to water quality", "length": 255, "domain": { "type": "codedValue", "name": "d_Pond_Vegetation_Rating", "description": "May to October; Excludes \u201cSite Veg.\u201d", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - 80 to 100% cover (ex: Bioretention/Wetlands/Wet Swale)", "code": "1" }, { "name": "2 - 60 to 80% cover; 10 to 30% invasive.", "code": "2" }, { "name": "4 - 20 to 40% cover; 51 to 70% invasive.", "code": "4" }, { "name": "3 - 40 to 60% cover; 31 to 50% invasive.", "code": "3" }, { "name": "5 - 0 to 20% cover.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POND_VEG_COM", "type": "esriFieldTypeString", "alias": "Comment - Vegetation Condition", "length": 255, "domain": null }, { "name": "POND_CONTAMINATION", "type": "esriFieldTypeString", "alias": "Pond Contamination", "length": 255, "domain": { "type": "codedValue", "name": "d_Pond_Contamination_Rating", "description": "heavy algae, chemical waste, & dumping ", "codedValues": [ { "name": "0 - NOT part of design", "code": "0" }, { "name": "1 - Absent of items in #39", "code": "1" }, { "name": "2 - Minor accumulations \u2013 no contamination.", "code": "2" }, { "name": "3 - Moderate - potential for minor contamination.", "code": "3" }, { "name": "4 - Major - potential for significant contamination.", "code": "4" }, { "name": "5 - Major - major contamination.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POND_CONTAMINATION_COM", "type": "esriFieldTypeString", "alias": "Comment - Pond Contamination", "length": 255, "domain": null }, { "name": "POND_C_CONC_INV", "type": "esriFieldTypeString", "alias": "Overall Concern Rating (contamination or invasives) - Use Concerns table", "length": 255, "domain": { "type": "codedValue", "name": "d_Pond_Concerns_Rating", "description": "C= Contamination; I= Invasive species; B= Both", "codedValues": [ { "name": "Contamination", "code": "C" }, { "name": "Invasive species", "code": "I" }, { "name": "Both", "code": "B" }, { "name": "Could NOT Inspect", "code": "NR" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE_C_CONC_INV", "type": "esriFieldTypeString", "alias": "Comment - Overall Concern Rating", "length": 255, "domain": null }, { "name": "FENCES", "type": "esriFieldTypeString", "alias": "Fence Condition", "length": 255, "domain": { "type": "codedValue", "name": "d_Fencing_Rating", "description": "fence/gate cond. (excludes R/W fencing)", "codedValues": [ { "name": "0 - 0 if N/A", "code": "0" }, { "name": "1 - Good condition.", "code": "1" }, { "name": "2 - Wear but NO security breaches.", "code": "2" }, { "name": "3 - Damaged but NO security breaches. Problems w/ Gate. Possibly Maint.", "code": "3" }, { "name": "4 - Openings < 1\u2019 May allow animals. Possible Repair Req\u2019d. Schedule Maint.", "code": "4" }, { "name": "5 - Fence is down. Repair Immediately", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FENCES_COM", "type": "esriFieldTypeString", "alias": "Comment - Fence Condition", "length": 255, "domain": null }, { "name": "SAFE_WATER_DEPTH", "type": "esriFieldTypeString", "alias": "Safe Water Depth", "length": 255, "domain": { "type": "codedValue", "name": "d_Safe_Water_Depth_Rating", "description": "potential safety risk", "codedValues": [ { "name": "0 - 0 if DRY design", "code": "0" }, { "name": "2 - Depth >2\u2019, NOT Fenced w/ \u201cNo Trespassing\u201d Sign, and \u201cBenches\u201d, <4:1.", "code": "2" }, { "name": "3 - Depth >2\u2019 & fence encircles BMP.", "code": "3" }, { "name": "1 - Depth <2\u2019 per design.", "code": "1" }, { "name": "4 - Not Fenced & doesn\u2019t meet Rating=\u201d2\u201d criteria but is in a remote location.", "code": "4" }, { "name": "5 - Same as above but is in an inhabited area.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAFE_WATER_DEPTH_COM", "type": "esriFieldTypeString", "alias": "Comment - Safe Water Depth", "length": 255, "domain": null }, { "name": "GEN_COMMENTSa", "type": "esriFieldTypeString", "alias": "Comments - General", "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": "Type_Concern", "type": "esriFieldTypeString", "alias": "Type of Concern 1", "length": 25, "domain": { "type": "codedValue", "name": "dTypeConcern", "description": "Type of Concern", "codedValues": [ { "name": "Algae", "code": "AL" }, { "name": "Construction Sediment", "code": "CS" }, { "name": "Chemical Waste", "code": "CW" }, { "name": "Detergents/Foam", "code": "DF" }, { "name": "Fecal Matter", "code": "FE" }, { "name": "Organic Debris", "code": "OD" }, { "name": "Oil Sheens", "code": "OS" }, { "name": "Suspend Sediment", "code": "SS" }, { "name": "Trash", "code": "TR" }, { "name": "Other", "code": "OT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Concern_Comment", "type": "esriFieldTypeString", "alias": "Comment - Concern", "length": 255, "domain": null }, { "name": "Type_Concern2", "type": "esriFieldTypeString", "alias": "Type of Concern 2", "length": 25, "domain": { "type": "codedValue", "name": "dTypeConcern", "description": "Type of Concern", "codedValues": [ { "name": "Algae", "code": "AL" }, { "name": "Construction Sediment", "code": "CS" }, { "name": "Chemical Waste", "code": "CW" }, { "name": "Detergents/Foam", "code": "DF" }, { "name": "Fecal Matter", "code": "FE" }, { "name": "Organic Debris", "code": "OD" }, { "name": "Oil Sheens", "code": "OS" }, { "name": "Suspend Sediment", "code": "SS" }, { "name": "Trash", "code": "TR" }, { "name": "Other", "code": "OT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Type_Concern3", "type": "esriFieldTypeString", "alias": "Type of Concern 3", "length": 25, "domain": { "type": "codedValue", "name": "dTypeConcern", "description": "Type of Concern", "codedValues": [ { "name": "Algae", "code": "AL" }, { "name": "Construction Sediment", "code": "CS" }, { "name": "Chemical Waste", "code": "CW" }, { "name": "Detergents/Foam", "code": "DF" }, { "name": "Fecal Matter", "code": "FE" }, { "name": "Organic Debris", "code": "OD" }, { "name": "Oil Sheens", "code": "OS" }, { "name": "Suspend Sediment", "code": "SS" }, { "name": "Trash", "code": "TR" }, { "name": "Other", "code": "OT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R671_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_671", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5327INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{03979293-D72A-4B3B-AEB4-898CC6F10DCD}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Swale", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "VEG_MOW", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "VEG_MOW", "type": "esriFieldTypeString", "alias": "Veg Mow height adequate", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_SEED", "type": "esriFieldTypeString", "alias": "Veg Seeding necessary", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_O", "type": "esriFieldTypeString", "alias": "Veg other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_COM", "type": "esriFieldTypeString", "alias": "Veg Comments", "length": 255, "domain": null }, { "name": "GEN_COMMENTSb", "type": "esriFieldTypeString", "alias": "Comments - General", "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 } ], "indexes": [ { "name": "R675_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_675", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5331INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9B1C4A23-601E-43AF-B34C-34D2923F991C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Infiltration_Facility", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Inlet_Opening", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "Inlet_Opening", "type": "esriFieldTypeString", "alias": "Inlet Opening", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inlet_Opening_Com", "type": "esriFieldTypeString", "alias": "Inlet Opening Comments", "length": 255, "domain": null }, { "name": "Sediment_Trash", "type": "esriFieldTypeString", "alias": "Sediment and/or Trash in Structure", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sed_Trash_Com", "type": "esriFieldTypeString", "alias": "Sediment and/or Trash in Structure Comments", "length": 255, "domain": null }, { "name": "Struct_Cond", "type": "esriFieldTypeString", "alias": "Structural Condition of Inlet", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Struct_Cond_Com", "type": "esriFieldTypeString", "alias": "Structural Condition of Inlet Comments", "length": 255, "domain": null }, { "name": "Outfall_Cond", "type": "esriFieldTypeString", "alias": "Outfall Condition", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Dia", "type": "esriFieldTypeDouble", "alias": "Outfall Pipe Diameter (Inches)", "domain": null }, { "name": "Outfall_Type", "type": "esriFieldTypeString", "alias": "Outfall Pipe Type", "length": 50, "domain": { "type": "codedValue", "name": "d_PipeType", "description": "Pipe Type", "codedValues": [ { "name": "RCP", "code": "RCP" }, { "name": "PVC", "code": "PVC" }, { "name": "HDPE", "code": "HDPE" }, { "name": "CMP", "code": "CMP" }, { "name": "DIP", "code": "DIP" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Coma", "type": "esriFieldTypeString", "alias": "Outfall Comments", "length": 255, "domain": null }, { "name": "Underdrain_Cond", "type": "esriFieldTypeString", "alias": "Underdrain Condition", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Underdrain_Com", "type": "esriFieldTypeString", "alias": "Underdrain Comments", "length": 255, "domain": null }, { "name": "Site_Stability", "type": "esriFieldTypeString", "alias": "Site Stability", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site_Stability_Com", "type": "esriFieldTypeString", "alias": "Site Stability Comments", "length": 255, "domain": null }, { "name": "Vegetation", "type": "esriFieldTypeString", "alias": "Vegetation", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Vegetation_Com", "type": "esriFieldTypeString", "alias": "Vegetation Comments", "length": 255, "domain": null }, { "name": "Access", "type": "esriFieldTypeString", "alias": "Access", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Access_Com", "type": "esriFieldTypeString", "alias": "Access Comments", "length": 255, "domain": null }, { "name": "Water_Depth", "type": "esriFieldTypeDouble", "alias": "Water Depth (Inches)", "domain": null }, { "name": "Dist_Water_Sur_Pipe", "type": "esriFieldTypeDouble", "alias": "Distance from water surface to pipe inverts", "domain": null }, { "name": "Sediment_Accu_Inlet", "type": "esriFieldTypeString", "alias": "Sediment Accumulation in Inlet", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Debris_Accu_Inlet", "type": "esriFieldTypeString", "alias": "Debris Accumulation in Inlet", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Obs_Well_Found", "type": "esriFieldTypeString", "alias": "Observation Well Found", "length": 5, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Width_Inlet", "type": "esriFieldTypeDouble", "alias": "Width of Inlet (Inches)", "domain": null }, { "name": "GEN_COMMENTSc", "type": "esriFieldTypeString", "alias": "Comments - General", "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 } ], "indexes": [ { "name": "R674_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_674", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5330INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{432811FB-A9F0-4970-B5D8-E133AF308FD3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Filtering_Systems", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MLCH_EX", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "MLCH_EX", "type": "esriFieldTypeString", "alias": "Does Mulch Exist?", "length": 5, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SOIL_EX", "type": "esriFieldTypeString", "alias": "Does Soil Exist?", "length": 5, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAND_EX", "type": "esriFieldTypeString", "alias": "Does Sand Exist?", "length": 5, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRVL_EX", "type": "esriFieldTypeString", "alias": "Does Gravel Exist?", "length": 5, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BUILT_TO_PLANS", "type": "esriFieldTypeString", "alias": "Depth and material built to plans", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FILTER_MAT", "type": "esriFieldTypeString", "alias": "Condition of filter material", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TRASH_DEBRIS", "type": "esriFieldTypeString", "alias": "Filter material free of trash/debris", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OIL_CHEM", "type": "esriFieldTypeString", "alias": "Filter material free of oil/chemicals", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FABRIC", "type": "esriFieldTypeString", "alias": "Filter fabric acceptable and intact", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEDIMENT", "type": "esriFieldTypeString", "alias": "Accumulation of sediment", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PONDING", "type": "esriFieldTypeString", "alias": "Flooding/ponding of water", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PONDING_DEPTH", "type": "esriFieldTypeString", "alias": "Flooding/ponding of water depth", "length": 255, "domain": null }, { "name": "VEG_COND", "type": "esriFieldTypeString", "alias": "Vegetation - Condition of vegetation", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_PLNTRP", "type": "esriFieldTypeString", "alias": "Vegetation - Replacement of plants", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_AREAS", "type": "esriFieldTypeString", "alias": "Vegetation - Sparsely vegetated areas", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_INV", "type": "esriFieldTypeString", "alias": "Vegetation - Growth of undesirable or invasive plants", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEG_COM", "type": "esriFieldTypeString", "alias": "Vegetation - Comments", "length": 255, "domain": null }, { "name": "UD_OP", "type": "esriFieldTypeString", "alias": "Underdrains Operational", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UD_OB", "type": "esriFieldTypeString", "alias": "Underdrains Obstructed", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UD_DL", "type": "esriFieldTypeString", "alias": "Underdrains Daylighted", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UD_COM", "type": "esriFieldTypeString", "alias": "Underdrain Comments", "length": 255, "domain": null }, { "name": "MISC_ENCR", "type": "esriFieldTypeString", "alias": "Miscellaneous Encroachment into facility or outfall area", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MISC_COMP", "type": "esriFieldTypeString", "alias": "Miscellaneous Complaints from local residents", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MISC_PUMP", "type": "esriFieldTypeString", "alias": "Miscellaneous Pump function", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MISC_GRAF", "type": "esriFieldTypeString", "alias": "Miscellaneous Graffiti removal required", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MISC_HAZ", "type": "esriFieldTypeString", "alias": "Miscellaneous Public hazards", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MISC_COM", "type": "esriFieldTypeString", "alias": "Miscellaneous Comment", "length": 255, "domain": null }, { "name": "GEN_COMMENTSd", "type": "esriFieldTypeString", "alias": "Comments - General", "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 } ], "indexes": [ { "name": "R672_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_672", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5328INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{A6EE4DEB-508D-4421-B157-9DCFF6FEEA0B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Underground", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CL_ACC", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "CL_ACC", "type": "esriFieldTypeString", "alias": "Cleanout Accessibility", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CL_CAP", "type": "esriFieldTypeString", "alias": "Cleanout Cap in place", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CL_O", "type": "esriFieldTypeString", "alias": "Cleanout Other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CL_COM", "type": "esriFieldTypeString", "alias": "Cleanout Comment", "length": 255, "domain": null }, { "name": "ChamA_Manhole", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Manhole spacing rings okay", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Manhole_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Manhole spacing rings okay Comments", "length": 255, "domain": null }, { "name": "ChamA_Throat", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Throat opening support block at least 6 inch", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Throat_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Throat opening support block at least 6 inch Comments", "length": 255, "domain": null }, { "name": "ChamA_Accu_Sed", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Accumulation of sediment, debris, oil, or trash", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Accu_Sed_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Accumulation of sediment, debris, oil, or trash Comments", "length": 255, "domain": null }, { "name": "ChamA_Cracks_Displace", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Cracks and/or displacements", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Cracks_Displace_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Cracks and/or displacements Comments", "length": 255, "domain": null }, { "name": "ChamA_Joint", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Joint Failure", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Joint_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Joint Failure Comments", "length": 255, "domain": null }, { "name": "ChamA_Watertight", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Watertight", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Watertight_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Watertight Comments", "length": 255, "domain": null }, { "name": "ChamA_Lug", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Lug lifts to be removed", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Lug_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Lug lifts to be removed Comments", "length": 255, "domain": null }, { "name": "ChamA_Influ_Efflu", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Influent/Effluent pipe condition", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Influ_Efflu_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Influent/Effluent pipe condition Comments", "length": 255, "domain": null }, { "name": "ChamA_Gutterpan", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Gutterpan spalling present", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Gutterpan_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Gutterpan spalling present Comments", "length": 255, "domain": null }, { "name": "ChamA_Baffles", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Baffles functioning", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Baffles_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Baffles functioning Comments", "length": 255, "domain": null }, { "name": "ChamA_Other", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamA_Other_Com", "type": "esriFieldTypeString", "alias": "Chamber \"A\" Other Comments", "length": 255, "domain": null }, { "name": "ChamB_Manhole", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Manhole spacing rings okay", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Manhole_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Manhole spacing rings okay Comments", "length": 255, "domain": null }, { "name": "ChamB_Throat", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Throat opening support block at least 6 inch", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Throat_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Throat opening support block at least 6 inch Comments", "length": 255, "domain": null }, { "name": "ChamB_Accu_Sed", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Accumulation of sediment, debris, oil, or trash", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Accu_Sed_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Accumulation of sediment, debris, oil, or trash Comments", "length": 255, "domain": null }, { "name": "ChamB_Cracks_Displace", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Cracks and/or displacements", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Cracks_Displace_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Cracks and/or displacements Comments", "length": 255, "domain": null }, { "name": "ChamB_Joint", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Joint Failure", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Joint_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Joint Failure Comments", "length": 255, "domain": null }, { "name": "ChamB_Watertight", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Watertight", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Watertight_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Watertight Comments", "length": 255, "domain": null }, { "name": "ChamB_Lug", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Lug lifts to be removed", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Lug_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Lug lifts to be removed Comments", "length": 255, "domain": null }, { "name": "ChamB_Influ_Efflu", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Influent/Effluent pipe condition", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Influ_Efflu_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Influent/Effluent pipe condition Comments", "length": 255, "domain": null }, { "name": "ChamB_Gutterpan", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Gutterpan spalling present", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Gutterpan_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Gutterpan spalling present Comments", "length": 255, "domain": null }, { "name": "ChamB_Baffles", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Baffles functioning", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Baffles_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Baffles functioning Comments", "length": 255, "domain": null }, { "name": "ChamB_Other", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChamB_Other_Com", "type": "esriFieldTypeString", "alias": "Chamber \"B\" Other Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Concrete", "type": "esriFieldTypeString", "alias": "Outfall Chamber Concrete/Masonry Condition", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Concrete_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Concrete/Masonry Condition Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Cracks", "type": "esriFieldTypeString", "alias": "Outfall Chamber Cracks and/or displacements", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Cracks_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Cracks and/or displacements Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Min_Spall", "type": "esriFieldTypeString", "alias": "Outfall Chamber Minor spalling (1 in or less)", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Min_Spall_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Minor spalling (1 in or less) Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Maj_Spall", "type": "esriFieldTypeString", "alias": "Outfall Chamber Major spalling (exposed re-bar)", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Maj_Spall_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Major spalling (exposed re-bar) Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Watertight", "type": "esriFieldTypeString", "alias": "Outfall Chamber Watertight", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Watertight_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Watertight Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Lug", "type": "esriFieldTypeString", "alias": "Outfall Chamber Lug lifts to be removed", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Lug_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Lug lifts to be removed Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Accum", "type": "esriFieldTypeString", "alias": "Outfall Chamber Accumulation of sediment, trash, or debris", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Accum_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Accumulation of sediment, trash, or debris Comments", "length": 255, "domain": null }, { "name": "Outfall_Chamber_Other", "type": "esriFieldTypeString", "alias": "Outfall Chamber Other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Chamber_Other_Com", "type": "esriFieldTypeString", "alias": "Outfall Chamber Other Comments", "length": 255, "domain": null }, { "name": "Cleanout_Accessibility", "type": "esriFieldTypeString", "alias": "Cleanout Accessibility", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleanout_Accessibility_Com", "type": "esriFieldTypeString", "alias": "Cleanout Accessibility Comments", "length": 255, "domain": null }, { "name": "Cleanout_Cap", "type": "esriFieldTypeString", "alias": "Cleanout Cap in place", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleanout_Cap_Com", "type": "esriFieldTypeString", "alias": "Cleanout Cap in place Comments", "length": 255, "domain": null }, { "name": "Cleanout_Other", "type": "esriFieldTypeString", "alias": "Cleanout Other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleanout_Other_Com", "type": "esriFieldTypeString", "alias": "Cleanout Other Comments", "length": 255, "domain": null }, { "name": "GEN_COMMENTSe", "type": "esriFieldTypeString", "alias": "Comments - General", "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 } ], "indexes": [ { "name": "R676_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_676", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5332INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{0CB5E96D-804C-4CE2-B8D1-6E4AFD389440}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Inspection_Observation_Wells", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OW_WLDPTH", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "OW_WLDPTH", "type": "esriFieldTypeString", "alias": "Observation Well total depth of well from bottom to top (ft)", "length": 5, "domain": null }, { "name": "OW_WTRDPTH", "type": "esriFieldTypeString", "alias": "Observation Well total water depth from bottom of well to top of water (ft)", "length": 5, "domain": null }, { "name": "OW_WLSRFDPTH", "type": "esriFieldTypeString", "alias": "Observation Well total depth from top of well to ground surface (ft)", "length": 5, "domain": null }, { "name": "OW_CAP", "type": "esriFieldTypeString", "alias": "Observation Well roperly capped", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OW_CRK", "type": "esriFieldTypeString", "alias": "Observation Well cracked or broken", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OW_DEB", "type": "esriFieldTypeString", "alias": "Observation Well free of debris", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OW_SEC", "type": "esriFieldTypeString", "alias": "Observation Well well secured", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OW_WTR", "type": "esriFieldTypeString", "alias": "Observation Well presence of water in well", "length": 5, "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OW_O", "type": "esriFieldTypeString", "alias": "Observation Well other", "length": 5, "domain": { "type": "codedValue", "name": "d_Score", "description": "Score", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Not a Problem", "code": "1" }, { "name": "2 - Monitor (Potential for future problem)", "code": "2" }, { "name": "3 - Routine/Scheduled Maintenance Required", "code": "3" }, { "name": "4 - Major Immediate Repair Necessary", "code": "4" }, { "name": "5 - Severe Immediate Repair Necessary", "code": "5" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Not Inspected", "code": "NI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_COMMENTSf", "type": "esriFieldTypeString", "alias": "Comments - General", "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 } ], "indexes": [ { "name": "R669_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_669", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5325INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{661AFA17-D1ED-4420-9FC1-192872AB955B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Inspection_Actions", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "COM_ACTION", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "COM_ACTION", "type": "esriFieldTypeString", "alias": "Action", "length": 50, "domain": { "type": "codedValue", "name": "dComAction", "description": "Action at the BMP", "codedValues": [ { "name": "Rebuild Embankment to Provide Required Freeboard", "code": "BE" }, { "name": "Install Pond Bench/Shelves", "code": "BN" }, { "name": "Construct Emergency Spillway Opening", "code": "CO" }, { "name": "Construct Pull-off at Access Road", "code": "CP" }, { "name": "Construct Access Road", "code": "CR" }, { "name": "Clear Sediment", "code": "CS" }, { "name": "Repair Banks or Side Slopes", "code": "RB" }, { "name": "Repair Roadway Damage", "code": "RD" }, { "name": "Repair Earth Spillway", "code": "ES" }, { "name": "Add Gate to Fence", "code": "AG" }, { "name": "Repair or Replace Gate", "code": "RG" }, { "name": "Install Fence", "code": "IF" }, { "name": "Repair Fence", "code": "RF" }, { "name": "Remove Fence", "code": "XF" }, { "name": "Post No Trespassing Sign(s)", "code": "PS" }, { "name": "Replace Lock", "code": "RL" }, { "name": "Perform Illicit Discharge Inspection", "code": "DI" }, { "name": "Could Not Inspect, Submerged", "code": "IS" }, { "name": "Re-inspect Ponding/Infiltration Rates", "code": "RI" }, { "name": "Test Valve", "code": "VT" }, { "name": "Remove Trash and Debris", "code": "CD" }, { "name": "Remove Chemical Containers", "code": "CH" }, { "name": "Remove Downed Trees", "code": "DT" }, { "name": "Remove Hazardous Waste", "code": "HW" }, { "name": "Contain and Remove Oil Sheen", "code": "RO" }, { "name": "Construct Concrete Apron at Access Road Entrance", "code": "CA" }, { "name": "Construct Depressed Curb at Access Road Entrance", "code": "CC" }, { "name": "Provide Opening in Traffic Barrier at Access Road", "code": "PO" }, { "name": "Construct Orifice Opening", "code": "BO" }, { "name": "Repair or Replace Orifice Plate", "code": "OP" }, { "name": "Repair or Replace Top Slab", "code": "RT" }, { "name": "Repair Cracks", "code": "FC" }, { "name": "Repair Spalling", "code": "FS" }, { "name": "Repair Ladder Rungs", "code": "LD" }, { "name": "Replace Manhole", "code": "ML" }, { "name": "Repair/Replace Manhole Frame", "code": "RM" }, { "name": "Repair Pipe", "code": "RP" }, { "name": "Replace Pipe", "code": "NP" }, { "name": "Repair Pipe Deflection", "code": "PD" }, { "name": "Reset Pipe to Convey Water", "code": "CV" }, { "name": "Repair or Replace Outfall Stabilization/Structure", "code": "OS" }, { "name": "Replace CMP Riser with Concrete", "code": "RC" }, { "name": "Repair Structure", "code": "RS" }, { "name": "Replace Structure", "code": "SF" }, { "name": "Install Trash Rack", "code": "TR" }, { "name": "Repair or Replace Trash Rack", "code": "TK" }, { "name": "Repair or Replace Under-drains", "code": "RU" }, { "name": "Repair or Replace Valve", "code": "RV" }, { "name": "Remove Valve", "code": "VG" }, { "name": "Repair or Replace Perforated Pipe", "code": "PP" }, { "name": "Repair or Replace Pipe Connection", "code": "PC" }, { "name": "Cover Backfill Material", "code": "CB" }, { "name": "Repair Erosion", "code": "ER" }, { "name": "Replace Rip-Rap", "code": "RR" }, { "name": "Repair Seepage", "code": "SC" }, { "name": "Repair Sinkhole", "code": "SH" }, { "name": "Stabilize Saturated Areas", "code": "SS" }, { "name": "Repair Undercutting", "code": "UC" }, { "name": "Brush Hogging", "code": "BH" }, { "name": "Cut/Remove Trees", "code": "CT" }, { "name": "Brush Control", "code": "BC" }, { "name": "Plant Growth Regulator Application", "code": "GR" }, { "name": "Planting \u2013 Ground Cover", "code": "GC" }, { "name": "Planting\u2013 General Site", "code": "LS" }, { "name": "Selective Tree Felling", "code": "TF" }, { "name": "Selective Tree Trimming", "code": "TT" }, { "name": "Mow Meadow", "code": "MM" }, { "name": "Mow Turf", "code": "MO" }, { "name": "Mulch - Shredded hardwood", "code": "MH" }, { "name": "Mulch \u2013 Straw or Wood Cellulose Fiber", "code": "MS" }, { "name": "Nutrient Management Plan Needed", "code": "NM" }, { "name": "Turf Seeding", "code": "TS" }, { "name": "Invasive Species Control \u2013 Cattail Control", "code": "CI" }, { "name": "Invasive Species Control \u2013 Thistle Control", "code": "TI" }, { "name": "Invasive Species Control \u2013 Meadow", "code": "MI" }, { "name": "Invasive Species Control \u2013 Phragmites Control", "code": "PI" }, { "name": "Invasive Species Control \u2013 Poison Ivy Control", "code": "II" }, { "name": "Planting \u2013 Treatment Area", "code": "TP" }, { "name": "Planting \u2013 Treatment Area Shading", "code": "SP" }, { "name": "Trim Vegetation", "code": "TV" }, { "name": "Weed Control in Shrub Beds", "code": "SB" }, { "name": "Invasive Species Control \u2013 General", "code": "IV" }, { "name": "Invasive Species Control - General", "code": "SI" }, { "name": "Regrade Pipe to Convey Water", "code": "RW" }, { "name": "Repair or Replace Aggregate Filter Blanket", "code": "FA" }, { "name": "Fill Animal Burrows", "code": "FB" }, { "name": "Lay Sod/ Grass on Bare Areas", "code": "SG" }, { "name": "Place Gate in Fence at Spillway", "code": "PG" }, { "name": "Remove Trees From SWM Embankment", "code": "TB" }, { "name": "Remove Emb. Trees < 4\" DBH", "code": "TA" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_COMMENTSh", "type": "esriFieldTypeString", "alias": "Comments - General", "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": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "Inspection GUID", "length": 38, "domain": null }, { "name": "LOC_ACTION", "type": "esriFieldTypeString", "alias": "Action Location", "length": 5, "domain": { "type": "codedValue", "name": "d_Loc_Action", "description": "Location for Action to be carried out", "codedValues": [ { "name": "Aquatic Bench", "code": "AB" }, { "name": "Adjacent Property", "code": "AP" }, { "name": "Access Road", "code": "AR" }, { "name": "Basin", "code": "BA" }, { "name": "Clean Outs", "code": "CO" }, { "name": "Entire Drainage Area", "code": "DA" }, { "name": "Downstream Embankment", "code": "DE" }, { "name": "Downstream Toe", "code": "DT" }, { "name": "Embankment SWM", "code": "EM" }, { "name": "Non SWM Embankment", "code": "EN" }, { "name": "Emergency Spillway", "code": "ES" }, { "name": "Forebay", "code": "FB" }, { "name": "Fence", "code": "FN" }, { "name": "Facility Perimeter", "code": "FP" }, { "name": "Forebay Weir", "code": "FW" }, { "name": "Groundwater Monitoring Wells", "code": "GW" }, { "name": "Inflow into BMP", "code": "IF" }, { "name": "Level Spreader", "code": "LS" }, { "name": "Micropool", "code": "MP" }, { "name": "Outflow Channel", "code": "OC" }, { "name": "Orifice", "code": "OF" }, { "name": "Observation Well", "code": "OW" }, { "name": "Principal Spillway", "code": "PS" }, { "name": "Riser Interior", "code": "RI" }, { "name": "Safety Bench", "code": "SB" }, { "name": "Upstream Embankment", "code": "UE" }, { "name": "Upstream Toe", "code": "UT" }, { "name": "Valve", "code": "VE" }, { "name": "General BMP", "code": "GB" }, { "name": "Control Structure", "code": "CS" }, { "name": "Entire Facility", "code": "EF" }, { "name": "Algae", "code": "AL" }, { "name": "Low flow pipe", "code": "LF" }, { "name": "Pond Side Slopes", "code": "SS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R668_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_668", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5324INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{50E1B0EB-0D98-4AF8-849B-1061223A0F48}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Inspection_Inflows", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INFLOW_TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "INSPECTION_GUID", "length": 38, "domain": null }, { "name": "INFLOW_TYPE", "type": "esriFieldTypeString", "alias": "Inflow Type", "length": 10, "domain": { "type": "codedValue", "name": "d_PipeType", "description": "Pipe Type", "codedValues": [ { "name": "RCP", "code": "RCP" }, { "name": "PVC", "code": "PVC" }, { "name": "HDPE", "code": "HDPE" }, { "name": "CMP", "code": "CMP" }, { "name": "DIP", "code": "DIP" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLOW_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Inflow Diameter (Inches)", "domain": null }, { "name": "INFLOW_COND", "type": "esriFieldTypeString", "alias": "Inflow Condition Rating", "length": 100, "domain": { "type": "codedValue", "name": "d_Inflow_Con_Rating", "description": "outfall POINT from ditch/Struct. and last SD joint", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - No problems.", "code": "1" }, { "name": "2 - Minor sedimentation/structural damage. No Maint. required.", "code": "2" }, { "name": "3 - Moderate (undermining ect.). Schedule Maint.", "code": "3" }, { "name": "4 - Major. Schedule Maint.", "code": "4" }, { "name": "5 - Complete blockage. Immediate Maint.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFLOW_COND_COM", "type": "esriFieldTypeString", "alias": "In Flow Condition Comment", "length": 255, "domain": null }, { "name": "IN_FLOW_STABILITY", "type": "esriFieldTypeString", "alias": "In Flow Stability Rating", "length": 100, "domain": { "type": "codedValue", "name": "d_Inflow_Stability_Rating", "description": "Full swale or pipe LENGTH and sheet flow", "codedValues": [ { "name": "0 - Not part of design", "code": "0" }, { "name": "1 - Functioning properly.", "code": "1" }, { "name": "2 - Minor erosion. Monitored.", "code": "2" }, { "name": "3 - Moderate erosion - actively occurring. Schedule Maint.", "code": "3" }, { "name": "4 - Major erosion - Integrity compromised. Immediate Maint.", "code": "4" }, { "name": "5 - Severe erosion - Embankment failure anticipated. Immediate Maint.", "code": "5" }, { "name": "NR - Could NOT Inspect", "code": "NR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IN_FLOW_STABILITY_COM", "type": "esriFieldTypeString", "alias": "In Flow Stability Comments", "length": 255, "domain": null }, { "name": "GEN_COMMENTSg", "type": "esriFieldTypeString", "alias": "Comments - General", "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 } ], "indexes": [ { "name": "R673_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_673", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5329INSPECTION_", "fields": "INSPECTION_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F2167004-84FF-40FF-B64C-8CCCB1A3D34D}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "SWMFAC_INSPECTIONS__ATTACH", "type": "Table", "description": 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": "SWMFAC_GID", "type": "esriFieldTypeString", "alias": "SWMFAC_GID", "length": 255, "domain": null }, { "name": "STRU_NO", "type": "esriFieldTypeString", "alias": "STRU_NO", "length": 255, "domain": null } ], "indexes": [ { "name": "R682_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_682", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5354_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e56c8123e4b84bc382817a49aa247c06" } ] }