{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Inspection_Actions", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 12, "name": "SWMFAC_INSPECTIONS", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "INSPECTION_GUID", "composite": true, "catalogID": "{50E1B0EB-0D98-4AF8-849B-1061223A0F48}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "COM_ACTION", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "COM_ACTION", "type": "esriFieldTypeString", "alias": "Action", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COM_ACTION" }, { "name": "GEN_COMMENTSh", "type": "esriFieldTypeString", "alias": "Comments - General", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GEN_COMMENTS" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "INSPECTION_GUID", "type": "esriFieldTypeGUID", "alias": "Inspection GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "INSPECTION_GUID" }, { "name": "LOC_ACTION", "type": "esriFieldTypeString", "alias": "Action Location", "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" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "LOC_ACTION" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Inspection_Actions", "description": "", "prototype": { "attributes": { "INSPECTION_GUID": null, "GEN_COMMENTSh": null, "LOC_ACTION": null, "COM_ACTION": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "16337b0eee2f431face4379ca289d798" }