{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 34, "name": "BMP Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ObjectID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ObjectID", "type": "esriFieldTypeDouble", "alias": "ObjectID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeString", "alias": "GlobalID", "length": 255, "domain": null }, { "name": "Structure_Number", "type": "esriFieldTypeString", "alias": "Structure Number", "length": 255, "domain": null }, { "name": "Inspection_ID", "type": "esriFieldTypeString", "alias": "Inspection ID", "length": 255, "domain": null }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "Site_Address", "type": "esriFieldTypeString", "alias": "Site Address", "length": 255, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 255, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 255, "domain": null }, { "name": "Current_Occupant", "type": "esriFieldTypeString", "alias": "Current Occupant", "length": 255, "domain": null }, { "name": "Inspection_Type", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 255, "domain": { "type": "codedValue", "name": "dIC_InvestigationType", "description": "BMP Inspection Investigation Type", "codedValues": [ { "name": "Initial", "code": "1" }, { "name": "Triennial", "code": "2" }, { "name": "Complaint", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Re_Inspection_ID", "type": "esriFieldTypeString", "alias": "Re-Inspection ID", "length": 255, "domain": null }, { "name": "Type_of_Facility", "type": "esriFieldTypeString", "alias": "Type of Facility", "length": 255, "domain": null }, { "name": "Other_issues", "type": "esriFieldTypeString", "alias": "Other issues", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 255, "domain": null }, { "name": "Phone_No_", "type": "esriFieldTypeString", "alias": "Phone No#", "length": 255, "domain": null }, { "name": "InspEmail", "type": "esriFieldTypeString", "alias": "InspEmail", "length": 255, "domain": null }, { "name": "INSP_RES", "type": "esriFieldTypeString", "alias": "Select one of the following:", "length": 255, "domain": { "type": "codedValue", "name": "dIC_InspectionResult", "description": "BMP Inspection Result", "codedValues": [ { "name": "Provide access to the SWMF so it may be inspected. Please contact the inspector to schedule a re-inspection.", "code": "Access_ReInsp " }, { "name": "Perform maintenance/repairs identified below in the comments section to address the issues noted on page 2. Contact the inspector for re-inspection when work is completed.", "code": "Maint_Req" }, { "name": "Our records incorrectly identified this facility on your property. No action is required.", "code": "No_Action_NA" }, { "name": "SWMF is in compliance. Please continue routine maintenance.", "code": "No_Issues" }, { "name": "Facility requires maintenance by a qualified/licensed underground stormwater maintenance contractor. Please forward a copy of the receipt/invoice to the email below when maintenance is complete.", "code": "Prof_Action" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Compliance_Violation_", "type": "esriFieldTypeString", "alias": "Compliance Violation:", "length": 255, "domain": { "type": "codedValue", "name": "dIC_ComplianceViolation", "description": "Major, Minor, or None", "codedValues": [ { "name": "Major", "code": "Maj" }, { "name": "Minor", "code": "Min" }, { "name": "None", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 255, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 255, "domain": null }, { "name": "x", "type": "esriFieldTypeDouble", "alias": "x", "domain": null }, { "name": "y", "type": "esriFieldTypeDouble", "alias": "y", "domain": null }, { "name": "FacDesRem", "type": "esriFieldTypeString", "alias": "Facility destroyed or removed", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AccFacObs", "type": "esriFieldTypeString", "alias": "Access to facility is obstructed or limited", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DefDamFenGat", "type": "esriFieldTypeString", "alias": "Defective or damaged fence, gate or lock", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DamMisDet", "type": "esriFieldTypeString", "alias": "Damaged, misaligned, or deteriorated structure", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AccCovDam", "type": "esriFieldTypeString", "alias": "Access cover damaged or could not be opened", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ObsMisIno", "type": "esriFieldTypeString", "alias": "Observation well missing or inoperable", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SoiSetSin", "type": "esriFieldTypeString", "alias": "Soil settlement and/or sink holes observed", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GraNotMow", "type": "esriFieldTypeString", "alias": "Grassy areas are not mowed as required", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreStakRem", "type": "esriFieldTypeString", "alias": "Tree stakes have not been removed", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreShrOve", "type": "esriFieldTypeString", "alias": "Trees and/or shrubs are overgrown", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PreNuiVeg", "type": "esriFieldTypeString", "alias": "Predominance of nuisance vegetation, weeds, invasive species, or", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LanBufPon", "type": "esriFieldTypeString", "alias": "Landscape buffer around the pond is missing or inadequate", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DeaDisDyi", "type": "esriFieldTypeString", "alias": "Dead, diseased, or dying trees", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EscAgaGro", "type": "esriFieldTypeString", "alias": "Excessive agal growth in the permanent pool of wet pond", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MulMisIns", "type": "esriFieldTypeString", "alias": "Mulch layer missing or insufficient", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VegSedBlo", "type": "esriFieldTypeString", "alias": "Vegetation and/or sediment is blocking flow from entering, exiti", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StaWatClo", "type": "esriFieldTypeString", "alias": "Standing water indicated facility may be clogged", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FacHolWat", "type": "esriFieldTypeString", "alias": "Facility does not hold water", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WatFloFac", "type": "esriFieldTypeString", "alias": "Stormwater does not flow to the facility", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PerPooDep", "type": "esriFieldTypeString", "alias": "Permanent pool depth is at less than designed minimum", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GrasCovIns", "type": "esriFieldTypeString", "alias": "Grass cover insufficient for erosion control", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MisInaRip", "type": "esriFieldTypeString", "alias": "Missing or inadequate rip-rap protection", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EviSloFai", "type": "esriFieldTypeString", "alias": "Evidence of slope failure", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EviPetCon", "type": "esriFieldTypeString", "alias": "Evidence of petroleum contamination was observed in facility (oi", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FouUnpOdo", "type": "esriFieldTypeString", "alias": "Foul and/or unpleasant odors were detected", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ExcAccSed", "type": "esriFieldTypeString", "alias": "Excessive accumulation of sediment observed", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ExcAccTra", "type": "esriFieldTypeString", "alias": "Excessive accumulation of trash and debris observed", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreShrEmb", "type": "esriFieldTypeString", "alias": "Trees and/or shrubs located on dam embankment", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WatSeeDam", "type": "esriFieldTypeString", "alias": "Water leaking / seeping from dam embankment", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CraBulDam", "type": "esriFieldTypeString", "alias": "Settlement, cracking, sliding, or bulging of dam embankment", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AniBurEmb", "type": "esriFieldTypeString", "alias": "Animal burrows on embankment", "length": 4, "domain": { "type": "codedValue", "name": "dIC_BMP_SurveyAnswers", "description": "Answers to BMP Inspection Survey", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MDE_GDB_ID", "type": "esriFieldTypeString", "alias": "MDE GDB ID", "length": 13, "domain": null }, { "name": "GlobalID_1", "type": "esriFieldTypeGlobalID", "alias": "GlobalID_1", "length": 38, "domain": null }, { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID_1", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID_1", "fields": "GlobalID_1", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G55Structure_Num", "fields": "Structure_Number", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "ESD_Structural_BMP", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Structure_Number", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{954AB595-19EC-4950-9909-DF4BAE9686F2}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }