{
"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"
}