{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 47, "name": "Input Category", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inputCategoryScheme", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inputCategoryScheme", "type": "esriFieldTypeString", "alias": "Input Category Scheme", "length": 40, "domain": { "type": "codedValue", "name": "InputCategoryScheme_Enum", "description": "Input Category Scheme", "codedValues": [ { "name": "CIS Inventory Guidance Principal Source", "code": "CIS Inventory Guidance Principal Source" }, { "name": "CIS Inventory Guidance Pathways", "code": "CIS Inventory Guidance Pathways" }, { "name": "CIS Inventory Guidance Riverine Loads", "code": "CIS Inventory Guidance Riverine Loads" }, { "name": "WFD Pressures", "code": "WFD Pressures" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inputCategoryCode", "type": "esriFieldTypeString", "alias": "Input Category Code", "length": 8, "domain": { "type": "codedValue", "name": "InputCategory_Union_Enum", "description": "Input Category Union", "codedValues": [ { "name": "1.1 \u2013 Point - Urban waste water", "code": "1.1" }, { "name": "1.2 \u2013 Point - Storm overflows", "code": "1.2" }, { "name": "1.3 \u2013 Point - IED plants", "code": "1.3" }, { "name": "1.4 \u2013 Point - Non IED plants", "code": "1.4" }, { "name": "1.5 \u2013 Point - Contaminated sites or abandoned industrial sites", "code": "1.5" }, { "name": "1.6 \u2013 Point - Waste disposal sites", "code": "1.6" }, { "name": "1.7 \u2013 Point - Mine waters", "code": "1.7" }, { "name": "1.8 \u2013 Point - Aquaculture", "code": "1.8" }, { "name": "1.9 \u2013 Point - Other", "code": "1.9" }, { "name": "2.1 \u2013 Diffuse - Urban run-off", "code": "2" }, { "name": "2.10 \u2013 Diffuse - Other", "code": "2.1" }, { "name": "2.2 \u2013 Diffuse - Agricultural", "code": "2.2" }, { "name": "2.3 \u2013 Diffuse - Forestry", "code": "2.3" }, { "name": "2.4 \u2013 Diffuse - Transport", "code": "2.4" }, { "name": "2.5 \u2013 Diffuse - Contaminated sites or abandoned industrial sites", "code": "2.5" }, { "name": "2.6 \u2013 Diffuse - Discharges not connected to sewerage network", "code": "2.6" }, { "name": "2.7 \u2013 Diffuse - Atmospheric deposition", "code": "2.7" }, { "name": "2.8 \u2013 Diffuse - Mining", "code": "2.8" }, { "name": "2.9 \u2013 Diffuse - Aquaculture", "code": "2.9" }, { "name": "P1 \u2013 Air emissions - atmospheric deposition to surface waters", "code": "P1" }, { "name": "P2 \u2013 Soil - erosion to surface waters", "code": "P2" }, { "name": "P3 \u2013 Soil - surface run off from unsealed areas to surface waters", "code": "P3" }, { "name": "P4 \u2013 Soil - interflow, tile drainage and groundwater flow to surface waters", "code": "P4" }, { "name": "P5 \u2013 Agriculture - discharges and drifting directly to surface waters", "code": "P5" }, { "name": "P6 \u2013 Impermeable surfaces - surface run off from sealed areas directly to surface waters", "code": "P6" }, { "name": "P7 \u2013 Sewer system - storm water outlets, combined sewer overflows and unconnected sewers", "code": "P7" }, { "name": "P8 \u2013 Urban waste water - treated", "code": "P8" }, { "name": "P9 \u2013 Households - Individual discharges treated and untreated", "code": "P9" }, { "name": "P10 \u2013 Industrial waste water - treated", "code": "P10" }, { "name": "P12 \u2013 Inland navigation - direct discharge", "code": "P12" }, { "name": "P13 \u2013 Natural background", "code": "P13" }, { "name": "RLin \u2013 Riverine load into RBD or SU", "code": "Rlin" }, { "name": "RLout \u2013 Riverine load out of RBD or SU", "code": "RLout" }, { "name": "S1 \u2013 Air emissions", "code": "S1" }, { "name": "S2 \u2013 Soil", "code": "S2" }, { "name": "S3 \u2013 Groundwater", "code": "S3" }, { "name": "S4 \u2013 Agriculture", "code": "S4" }, { "name": "S5 \u2013 Transportation and infrastructure", "code": "S5" }, { "name": "S6 \u2013 Construction material", "code": "S6" }, { "name": "S7 \u2013 Households", "code": "S7" }, { "name": "S8 \u2013 Industry", "code": "S8" }, { "name": "S9 \u2013 Abandoned mines and historic mines", "code": "S9" }, { "name": "S10 \u2013 Inland navigation", "code": "S10" }, { "name": "S11 \u2013 Natural background", "code": "S11" }, { "name": "S12 \u2013 Impermeable surfaces", "code": "S12" }, { "name": "S13 \u2013 Sewer system", "code": "S13" }, { "name": "S14 \u2013 Urban waste water treatment plants", "code": "S14" }, { "name": "S15 \u2013 Industrial waste treatment plants", "code": "S15" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inputCategoryValue", "type": "esriFieldTypeDouble", "alias": "Input Category Value", "domain": null }, { "name": "inputCategoryUnit", "type": "esriFieldTypeString", "alias": "Input Category Unit", "length": 40, "domain": { "type": "codedValue", "name": "UnitOfMeasure_Enum", "description": "Unit Of Measure", "codedValues": [ { "name": "percent", "code": "%" }, { "name": "percent Oxygen saturation", "code": "%{oxygenSaturation}" }, { "name": "pH", "code": "[pH]" }, { "name": "Ecological Quality Ratio", "code": "{EQR}" }, { "name": "Nephelometric Turbidity Unit", "code": "{NTU}" }, { "name": "presence or absence", "code": "{presence}" }, { "name": "Practical Salinity Unit", "code": "{PSU}" }, { "name": "ratio", "code": "{ratio}" }, { "name": "degree Celsius", "code": "Cel" }, { "name": "degree Kelvin", "code": "K" }, { "name": "kilogram per year", "code": "kg/a" }, { "name": "metre", "code": "m" }, { "name": "milligram per kilogram", "code": "mg/kg" }, { "name": "milligram per litre", "code": "mg/L" }, { "name": "milligram of Carbon per litre", "code": "mg{C}/L" }, { "name": "milligram of Calcium per litre", "code": "mg{Ca}/L" }, { "name": "milligram of Calcium Carbonate per litre", "code": "mg{CaCO3}/L" }, { "name": "milligram of Chlorine per litre", "code": "mg{Cl}/L" }, { "name": "milligram of Magnesium per litre", "code": "mg{Mg}/L" }, { "name": "milligram of Nitrogen per litre", "code": "mg{N}/L" }, { "name": "milligram of Ammonia per litre", "code": "mg{NH3}/L" }, { "name": "milligram of Ammonium per litre", "code": "mg{NH4}/L" }, { "name": "milligram of Nitrite per litre", "code": "mg{NO2}/L" }, { "name": "milligram of Nitrate per litre", "code": "mg{NO3}/L" }, { "name": "milligram of Oxygen per litre", "code": "mg{O2}/L" }, { "name": "milligram of Phosphorus per litre", "code": "mg{P}/L" }, { "name": "milligram of Phosphate per litre", "code": "mg{PO4}/L" }, { "name": "milligram of Sulphur per litre", "code": "mg{S}/L" }, { "name": "milligram of Silicon per litre", "code": "mg{Si}/L" }, { "name": "milligram of Silicate per litre", "code": "mg{SiO3}/L" }, { "name": "milligram of Sulphate per litre", "code": "mg{SO4}/L" }, { "name": "tonne per year", "code": "t/a" }, { "name": "microgram per kilogram", "code": "ug/kg" }, { "name": "microgram per litre", "code": "ug/L" }, { "name": "microgram of Nitrogen per litre", "code": "ug{N}/L" }, { "name": "microgram of Phosphorus per litre", "code": "ug{P}/L" }, { "name": "microgram TEQ per kilogram", "code": "ug{TEQ}/kg" }, { "name": "micromole per litre", "code": "umol/L" }, { "name": "microsiemens per centimetre", "code": "uS/cm" }, { "name": "Colony Forming Unit per deciliter", "code": "[CFU]/dL" }, { "name": "Formazin Nephelometric Unit", "code": "{FNU}" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inputUWWTPCoverage", "type": "esriFieldTypeString", "alias": "Input UWWTP Coverage", "length": 21, "domain": { "type": "codedValue", "name": "InputUWWTPCoverage_Enum", "description": "Input UWWTP Coverage", "codedValues": [ { "name": "U100 (> 100,000 p.e.)", "code": "U100 (> 100,000 p.e.)" }, { "name": "U10 (> 10,000 p.e.)", "code": "U10 (> 10,000 p.e.)" }, { "name": "U2 (> 2,000 p.e.)", "code": "U2 (> 2,000 p.e.)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inputIndustryCoverage", "type": "esriFieldTypeString", "alias": "Input Industry Coverage", "length": 28, "domain": { "type": "codedValue", "name": "InputIndustryCoverage_Enum", "description": "Input Industry Coverage", "codedValues": [ { "name": "E-PRTR", "code": "E-PRTR" }, { "name": "National business registers", "code": "National business registers" }, { "name": "All manufacturing industries", "code": "All manufacturing industries" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "riverineLoadMonitoringSite", "type": "esriFieldTypeString", "alias": "Riverine Load Monitoring Site", "length": 42, "domain": null }, { "name": "inputCategoryID", "type": "esriFieldTypeDouble", "alias": "Input Category ID", "domain": null }, { "name": "inputTotalID", "type": "esriFieldTypeDouble", "alias": "Input Total ID", "domain": null } ], "indexes": [ { "name": "R190_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G405inputTotalID", "fields": "inputTotalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 53, "name": "InputTotal", "relatedTableId": 52, "role": "esriRelRoleDestination", "keyField": "inputTotalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "730675cccb964c548dbb4f181faa4a6c" }