{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 52, "name": "Input Total", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inputTotalType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inputYearPeriod", "type": "esriFieldTypeSmallInteger", "alias": "Input Year Period", "domain": null }, { "name": "inputTotalType", "type": "esriFieldTypeString", "alias": "Input Total Type", "length": 31, "domain": { "type": "codedValue", "name": "InputTotalType_Enum", "description": "Input Total Type", "codedValues": [ { "name": "Total point sources", "code": "Total point sources" }, { "name": "Total diffuse sources", "code": "Total diffuse sources" }, { "name": "Total point and diffuse sources", "code": "Total point and diffuse sources" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inputDataQuality", "type": "esriFieldTypeString", "alias": "Input Data Quality", "length": 14, "domain": { "type": "codedValue", "name": "InputDataQuality_Enum", "description": "Input Data Quality", "codedValues": [ { "name": "Very good", "code": "Very good" }, { "name": "Good", "code": "Good" }, { "name": "Medium", "code": "Medium" }, { "name": "Uncertain", "code": "Uncertain" }, { "name": "Very uncertain", "code": "Very uncertain" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inputTotalValue", "type": "esriFieldTypeDouble", "alias": "Input Total Value", "domain": null }, { "name": "inputTotalUnit", "type": "esriFieldTypeString", "alias": "Input Total Unit", "length": 19, "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": "inputTotalID", "type": "esriFieldTypeDouble", "alias": "Input Total ID", "domain": null }, { "name": "inputPollutantID", "type": "esriFieldTypeDouble", "alias": "Input Pollutant ID", "domain": null } ], "indexes": [ { "name": "R189_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G404inputTotalID", "fields": "inputTotalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 53, "name": "InputCategory", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "inputTotalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 59, "name": "InputPollutant", "relatedTableId": 51, "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" }