{
"currentVersion": 10.81,
"id": 27,
"name": "publish.PADMIN.Outfall_Inspection",
"type": "Table",
"description": null,
"hasAttachments": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "inspector",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "inspector",
"type": "esriFieldTypeString",
"alias": "Inspector",
"length": 50,
"domain": null
},
{
"name": "inspectdt",
"type": "esriFieldTypeDate",
"alias": "Inspection Date",
"length": 8,
"domain": null
},
{
"name": "dryweather",
"type": "esriFieldTypeSmallInteger",
"alias": "Dry Weather Inspection?",
"domain": {
"type": "codedValue",
"name": "WS4_Yes_No",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Yes",
"code": 1
},
{
"name": "No",
"code": 2
},
{
"name": "Revisit",
"code": 3
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "dateprecip",
"type": "esriFieldTypeDate",
"alias": "Date of Last Precipitation",
"length": 8,
"domain": null
},
{
"name": "amountprecip",
"type": "esriFieldTypeSmallInteger",
"alias": "Amount of Last Precipitation",
"domain": {
"type": "codedValue",
"name": "WS4_Rainfall_Intensity",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Dry",
"code": 1
},
{
"name": "Light Rain I",
"code": 2
},
{
"name": "Light Rain II",
"code": 3
},
{
"name": "Moderate Rain I",
"code": 4
},
{
"name": "Moderate Rain II",
"code": 5
},
{
"name": "Heavy Rain I",
"code": 6
},
{
"name": "Heavy Rain II",
"code": 7
},
{
"name": "Violent Rain I",
"code": 8
},
{
"name": "Violent Rain II",
"code": 9
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "flow",
"type": "esriFieldTypeSmallInteger",
"alias": "Flow Present?",
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_flow_dc84ed6d26a44b8c8bbed15988c47949",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Yes",
"code": 1
},
{
"name": "No",
"code": 2
},
{
"name": "Revisit",
"code": 3
},
{
"name": "NA",
"code": 4
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "flowrate",
"type": "esriFieldTypeString",
"alias": "Flow Description",
"length": 20,
"domain": {
"type": "codedValue",
"name": "WS4_dFlow",
"description": "",
"codedValues": [
{
"name": "None",
"code": "1"
},
{
"name": "Trickle",
"code": "2"
},
{
"name": "Moderate",
"code": "3"
},
{
"name": "Substantial",
"code": "4"
},
{
"name": "NA",
"code": "5"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "flowcolor",
"type": "esriFieldTypeSmallInteger",
"alias": "Flow contains color?",
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_flowcolor_02f217434a7c4542b4d4882ece616c12",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Yes",
"code": 1
},
{
"name": "No",
"code": 2
},
{
"name": "Revisit",
"code": 3
},
{
"name": "NA",
"code": 4
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "colordesc",
"type": "esriFieldTypeString",
"alias": "Color Description",
"length": 50,
"domain": {
"type": "codedValue",
"name": "WS4_dColor",
"description": "",
"codedValues": [
{
"name": "Brown",
"code": "1"
},
{
"name": "Gray",
"code": "2"
},
{
"name": "Yellow",
"code": "3"
},
{
"name": "Green",
"code": "4"
},
{
"name": "Orange",
"code": "5"
},
{
"name": "Red",
"code": "6"
},
{
"name": "Rust",
"code": "7"
},
{
"name": "Other",
"code": "8"
},
{
"name": "Clear",
"code": "9"
},
{
"name": "NA",
"code": "10"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "colordesc_other",
"type": "esriFieldTypeString",
"alias": "Specify other Color",
"length": 50,
"domain": null
},
{
"name": "flowodor",
"type": "esriFieldTypeSmallInteger",
"alias": "Flow contains odor?",
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_flowodor_5a8374005d67450f903815b05c86b031",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Yes",
"code": 1
},
{
"name": "No",
"code": 2
},
{
"name": "Revisit",
"code": 3
},
{
"name": "NA",
"code": 4
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "odordesc",
"type": "esriFieldTypeString",
"alias": "Odor Description",
"length": 25,
"domain": {
"type": "codedValue",
"name": "WS4_dOdor",
"description": "",
"codedValues": [
{
"name": "Sewage",
"code": "1"
},
{
"name": "Petroleum",
"code": "2"
},
{
"name": "Other",
"code": "3"
},
{
"name": "None",
"code": "4"
},
{
"name": "NA",
"code": "5"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "odordesc_other",
"type": "esriFieldTypeString",
"alias": "Specify other Odor",
"length": 50,
"domain": null
},
{
"name": "flowfloatable",
"type": "esriFieldTypeSmallInteger",
"alias": "Flow contains floatables?",
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_flowfloatable_87cce719d66246b999a99484bbcc4fd8",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Yes",
"code": 1
},
{
"name": "No",
"code": 2
},
{
"name": "Revisit",
"code": 3
},
{
"name": "NA",
"code": 4
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "floatabledesc_other",
"type": "esriFieldTypeString",
"alias": "Specify other Floatable",
"length": 50,
"domain": null
},
{
"name": "recievingwater",
"type": "esriFieldTypeSmallInteger",
"alias": "Change in recieving water?",
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_recievingwater_17f1456989d7458f9df99bc766b9147a",
"description": "",
"codedValues": [
{
"name": "Unknown",
"code": 0
},
{
"name": "Yes",
"code": 1
},
{
"name": "No",
"code": 2
},
{
"name": "Revisit",
"code": 3
},
{
"name": "NA",
"code": 4
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "recievingwaterdesc",
"type": "esriFieldTypeString",
"alias": "Description of Change",
"length": 250,
"domain": null
},
{
"name": "illicitdischarge",
"type": "esriFieldTypeString",
"alias": "Is Flow Illicit Discharge?",
"length": 50,
"domain": {
"type": "codedValue",
"name": "WS4_Overall_Outfall_Rating",
"description": "",
"codedValues": [
{
"name": "No Indicators of illicit discharge",
"code": "1"
},
{
"name": "Some likelihood of illicit discharge",
"code": "2"
},
{
"name": "Almost certain a discharge exisits",
"code": "3"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "illicitdischargesource",
"type": "esriFieldTypeString",
"alias": "Efforts to determine source",
"length": 150,
"domain": null
},
{
"name": "illicitdischargeaction",
"type": "esriFieldTypeString",
"alias": "Corrective Action Taken",
"length": 150,
"domain": null
},
{
"name": "notes",
"type": "esriFieldTypeString",
"alias": "Notes",
"length": 2000,
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "assetID",
"type": "esriFieldTypeGUID",
"alias": "assetID",
"length": 38,
"domain": null
},
{
"name": "CreationDate",
"type": "esriFieldTypeDate",
"alias": "CreationDate",
"length": 8,
"domain": null
},
{
"name": "Creator",
"type": "esriFieldTypeString",
"alias": "Creator",
"length": 128,
"domain": null
},
{
"name": "EditDate",
"type": "esriFieldTypeDate",
"alias": "EditDate",
"length": 8,
"domain": null
},
{
"name": "Editor",
"type": "esriFieldTypeString",
"alias": "Editor",
"length": 128,
"domain": null
},
{
"name": "Inspection_Tide",
"type": "esriFieldTypeString",
"alias": "Tide at Inspection",
"length": 20,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_Inspection_Tide_258c9d2e-6052-45af-8aea-09de0575d99f",
"description": "",
"codedValues": [
{
"name": "Low",
"code": "1"
},
{
"name": "Mid",
"code": "2"
},
{
"name": "High",
"code": "3"
},
{
"name": "NA",
"code": "4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "subm_sed",
"type": "esriFieldTypeString",
"alias": "Submerged in Sediment",
"length": 50,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_subm_sed_e1e7e303-f8b2-4794-83f8-5175a64f79fa",
"description": "",
"codedValues": [
{
"name": "No",
"code": "1"
},
{
"name": "Partially",
"code": "2"
},
{
"name": "Fully",
"code": "3"
},
{
"name": "NA",
"code": "4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "subm_water",
"type": "esriFieldTypeString",
"alias": "Submerged in Water",
"length": 50,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_subm_water_be46ba9e-ad3d-41d0-8584-3eed9743cabf",
"description": "",
"codedValues": [
{
"name": "No",
"code": "1"
},
{
"name": "Partially",
"code": "2"
},
{
"name": "Fully",
"code": "3"
},
{
"name": "NA",
"code": "4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "odor_severity",
"type": "esriFieldTypeString",
"alias": "Odor Severity",
"length": 25,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_odor_severity_7ccc7efb-58f7-4273-8665-b2922da559e7",
"description": "",
"codedValues": [
{
"name": "None",
"code": "0"
},
{
"name": "Faint",
"code": "1"
},
{
"name": "Easily Detected",
"code": "2"
},
{
"name": "NA",
"code": "3"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "color_severity",
"type": "esriFieldTypeString",
"alias": "Color Severity",
"length": 25,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_color_severity_70057fa7-0c5c-4dc3-8af7-a90d358ce986",
"description": "",
"codedValues": [
{
"name": "No Color",
"code": "0"
},
{
"name": "Faint in Sample",
"code": "1"
},
{
"name": "Clear in Outflow",
"code": "3"
},
{
"name": "NA",
"code": "4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "turbidity",
"type": "esriFieldTypeString",
"alias": "Turbidity",
"length": 25,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_turbidity_77c0222c-5ddf-42b8-89a4-b9a714559160",
"description": "",
"codedValues": [
{
"name": "Clear",
"code": "0"
},
{
"name": "Slightly Cloudy",
"code": "1"
},
{
"name": "Cloudy",
"code": "2"
},
{
"name": "NA",
"code": "4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "non_reportable_discharge_ob",
"type": "esriFieldTypeString",
"alias": "Non Reportable Discharge Observation",
"length": 100,
"domain": null
},
{
"name": "sample_col",
"type": "esriFieldTypeString",
"alias": "Sample Collected",
"length": 10,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_sample_col_f1b3086e-3ffa-43b3-87e4-44b31679c37c",
"description": "",
"codedValues": [
{
"name": "Yes",
"code": "1"
},
{
"name": "No",
"code": "2"
},
{
"name": "Revisit",
"code": "3"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "damage",
"type": "esriFieldTypeString",
"alias": "Outfall Damage",
"length": 50,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_damage_89d10a7e-1136-429a-8104-b7d35a8d4275",
"description": "",
"codedValues": [
{
"name": "No Damage",
"code": "0"
},
{
"name": "Good - Some Cracking and/or Chipping",
"code": "1"
},
{
"name": "Fair - Corrosion",
"code": "2"
},
{
"name": "Poor - Crushed",
"code": "3"
},
{
"name": "Other",
"code": "4"
},
{
"name": "NA",
"code": "5"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Abnorm_veg",
"type": "esriFieldTypeString",
"alias": "Abnormal Vegetation",
"length": 50,
"domain": {
"type": "codedValue",
"name": "WS4_Outfall_Inspection_Abnorm_veg_569d7cf7-82b0-44ac-8762-65e6a08bb00a",
"description": "",
"codedValues": [
{
"name": "None",
"code": "0"
},
{
"name": "Inhibited",
"code": "1"
},
{
"name": "Excessive",
"code": "2"
},
{
"name": "Other",
"code": "3"
},
{
"name": "NA",
"code": "4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OF_size",
"type": "esriFieldTypeString",
"alias": "Outfall Size",
"length": 20,
"domain": null
},
{
"name": "OF_Material",
"type": "esriFieldTypeString",
"alias": "Outfall Material",
"length": 30,
"domain": null
},
{
"name": "OF_Type",
"type": "esriFieldTypeString",
"alias": "Outfall Type",
"length": 30,
"domain": null
},
{
"name": "ASSET_ID_JOIN",
"type": "esriFieldTypeString",
"alias": "ASSET_ID_JOIN",
"length": 256,
"domain": null
},
{
"name": "ID_Join_Short",
"type": "esriFieldTypeInteger",
"alias": "ID_Join_Short",
"domain": null
},
{
"name": "floatabledesc",
"type": "esriFieldTypeString",
"alias": "Floatable Description",
"length": 256,
"domain": null
}
],
"indexes": [
{
"name": "R151_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_151",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G206assetID",
"fields": "assetID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I206CreationDate",
"fields": "CreationDate",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I206Creator",
"fields": "Creator",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I206EditDate",
"fields": "EditDate",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I206Editor",
"fields": "Editor",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "",
"relatedTableId": 16,
"role": "esriRelRoleDestination",
"keyField": "assetID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON",
"isDataVersioned": false,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsHavingClause": true,
"supportsCountDistinct": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"dateFieldsTimeReference": null
}