{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 62, "name": "Chemical Monitoring", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CHEM_MON_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CHEM_MON_ID", "type": "esriFieldTypeString", "alias": "CHEM_MON_ID", "domain": null, "editable": true, "nullable": false, "length": 13, "defaultValue": null, "modelName": "CHEM_MON_ID" }, { "name": "MON_STATION_ID", "type": "esriFieldTypeString", "alias": "MON_STATION_ID", "domain": null, "editable": true, "nullable": false, "length": 13, "defaultValue": null, "modelName": "MDE_STATION_ID" }, { "name": "LOCAL_STATION_ID", "type": "esriFieldTypeString", "alias": "LOCAL_STATION_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LOCAL_STATION_ID" }, { "name": "MDE_OUTFALL_ID", "type": "esriFieldTypeString", "alias": "MDE_OUTFALL_ID", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "MD_OUTFALL_ID" }, { "name": "LOCAL_OUTFALL_ID", "type": "esriFieldTypeString", "alias": "LOCAL_OUTFALL_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LOCAL_OUTFALL_ID" }, { "name": "EVENT_DATE", "type": "esriFieldTypeDate", "alias": "EVENT_DATE", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "EVENT_DATE" }, { "name": "EVENT_TIME", "type": "esriFieldTypeString", "alias": "EVENT_TIME", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "EVENT_TIME" }, { "name": "STORM_BASEFLOW", "type": "esriFieldTypeString", "alias": "STORM_BASEFLOW", "domain": { "type": "codedValue", "name": "dStormBaseflow", "description": "Is Sample Storm or Base Flow", "codedValues": [ { "name": "Base Flow", "code": "BF" }, { "name": "Storm", "code": "S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "STORM_OR_BASEFLOW" }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "DEPTH", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DEPTH" }, { "name": "DURATION", "type": "esriFieldTypeDouble", "alias": "DURATION", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DURATION" }, { "name": "INTENSITY", "type": "esriFieldTypeDouble", "alias": "INTENSITY", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "INTENSITY" }, { "name": "TOTAL_STORM_FLOW_VOL", "type": "esriFieldTypeDouble", "alias": "TOTAL_STORM_FLOW_VOL", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TOTAL_STORM_FLOW_VOL" }, { "name": "DISCHARGE_OUTFALL", "type": "esriFieldTypeDouble", "alias": "DISCHARGE_OUTFALL", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DISCHARGE_OUTFALL" }, { "name": "DISCHARGE_INSTREAM", "type": "esriFieldTypeDouble", "alias": "DISCHARGE_INSTREAM", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DISCHARGE_INSTREAM" }, { "name": "WATER_TEMP", "type": "esriFieldTypeDouble", "alias": "WATER_TEMP", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "WATER_TEMP" }, { "name": "pH", "type": "esriFieldTypeDouble", "alias": "pH", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "pH" }, { "name": "BOD_dt", "type": "esriFieldTypeDouble", "alias": "BOD_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "BOD_dt" }, { "name": "BOD_EMC", "type": "esriFieldTypeString", "alias": "BOD_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "BOD_EMC0" }, { "name": "TN_dt", "type": "esriFieldTypeDouble", "alias": "TN_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TN_dt" }, { "name": "TN_EMC", "type": "esriFieldTypeString", "alias": "TN_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TN_EMC" }, { "name": "CL_dt", "type": "esriFieldTypeDouble", "alias": "CL_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "CL_dt" }, { "name": "CL_EMC", "type": "esriFieldTypeString", "alias": "CL_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "CL_EMC" }, { "name": "PO4_dt", "type": "esriFieldTypeDouble", "alias": "PO4_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "PO4_dt" }, { "name": "PO4_EMC", "type": "esriFieldTypeString", "alias": "PO4_EMC\n", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "PO4_EMC" }, { "name": "TOC_dt", "type": "esriFieldTypeDouble", "alias": "TOC_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TOC_dt" }, { "name": "TOC_EMC", "type": "esriFieldTypeString", "alias": "TOC_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TOC_EMC" }, { "name": "NH3_NH4_dt", "type": "esriFieldTypeDouble", "alias": "NH3_NH4_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "NH3_NH4_dt" }, { "name": "NH3_NH4_EMC", "type": "esriFieldTypeString", "alias": "NH3_NH4_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "NH3_NH4_EMC" }, { "name": "TKN_dt", "type": "esriFieldTypeDouble", "alias": "TKN_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TKN_dt" }, { "name": "TKN_EMC", "type": "esriFieldTypeString", "alias": "TKN_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TKN_EMC0" }, { "name": "NITRATE_NITRITE_dt", "type": "esriFieldTypeDouble", "alias": "NITRATE_NITRITE_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "NITRATE_NITRITE_dt" }, { "name": "NITRATE_NITRITE_EMC", "type": "esriFieldTypeString", "alias": "NITRATE_NITRITE_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "NITRATE_NITRITE_EMC0" }, { "name": "TOTAL_PHOSPHORUS_dt", "type": "esriFieldTypeDouble", "alias": "TOTAL_PHOSPHORUS_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TOTAL_PHOSPHORUS_dt" }, { "name": "TOTAL_PHOSPHORUS_EMC", "type": "esriFieldTypeString", "alias": "TOTAL_PHOSPHORUS_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TOTAL_PHOSPHORUS_EMC0" }, { "name": "TSS_dt", "type": "esriFieldTypeDouble", "alias": "TSS_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TSS_dt" }, { "name": "TSS_EMC", "type": "esriFieldTypeString", "alias": "TSS_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TSS_EMC0" }, { "name": "TOTAL_COPPER_dt", "type": "esriFieldTypeDouble", "alias": "TOTAL_COPPER_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TOTAL_COPPER_dt" }, { "name": "TOTAL_COPPER_EMC", "type": "esriFieldTypeString", "alias": "TOTAL_COPPER_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TOTAL_COPPER_EMC0" }, { "name": "TOTAL_LEAD_dt", "type": "esriFieldTypeDouble", "alias": "TOTAL_LEAD_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TOTAL_LEAD_dt" }, { "name": "TOTAL_LEAD_EMC", "type": "esriFieldTypeString", "alias": "TOTAL_LEAD_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TOTAL_LEAD_EMC0" }, { "name": "TOTAL_ZINC_dt", "type": "esriFieldTypeDouble", "alias": "TOTAL_ZINC_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TOTAL_ZINC_dt" }, { "name": "TOTAL_ZINC_EMC", "type": "esriFieldTypeString", "alias": "TOTAL_ZINC_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TOTAL_ZINC_EMC0" }, { "name": "HARDNESS_dt", "type": "esriFieldTypeDouble", "alias": "HARDNESS_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "HARDNESS_dt" }, { "name": "HARDNESS_EMC", "type": "esriFieldTypeString", "alias": "HARDNESS_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "HARDNESS_EMC0" }, { "name": "TPH_dt", "type": "esriFieldTypeDouble", "alias": "TPH_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TPH_dt" }, { "name": "TPH_EMC", "type": "esriFieldTypeString", "alias": "TPH_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "TPH_EMC0" }, { "name": "ENTEROCOCCI_dt", "type": "esriFieldTypeDouble", "alias": "ENTEROCOCCI_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ENTEROCOCCI_dt" }, { "name": "ENTEROCOCCI_EMC", "type": "esriFieldTypeString", "alias": "ENTEROCOCCI_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "ENTEROCOCCI_EMC0" }, { "name": "ECOLI_dt", "type": "esriFieldTypeDouble", "alias": "ECOLI_dt", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ECOLI_dt" }, { "name": "ECOLI_EMC", "type": "esriFieldTypeString", "alias": "ECOLI_EMC", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "ECOLI_EMC0" }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "GEN_COMMENTS", "domain": null, "editable": true, "nullable": false, "length": 255, "defaultValue": null, "modelName": "GEN_COMMENT" } ], "indexes": [ { "name": "R563_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Chemical Monitoring", "description": "", "prototype": { "attributes": { "ECOLI_EMC": " ", "CHEM_MON_ID": " ", "MON_STATION_ID": " ", "LOCAL_STATION_ID": null, "MDE_OUTFALL_ID": null, "LOCAL_OUTFALL_ID": null, "EVENT_DATE": -2209161600000, "EVENT_TIME": " ", "STORM_BASEFLOW": " ", "DEPTH": 0, "DURATION": 0, "INTENSITY": 0, "TOTAL_STORM_FLOW_VOL": 0, "DISCHARGE_OUTFALL": 0, "DISCHARGE_INSTREAM": 0, "WATER_TEMP": 0, "pH": 0, "BOD_dt": 0, "BOD_EMC": " ", "TN_dt": 0, "TN_EMC": " ", "CL_dt": 0, "CL_EMC": " ", "PO4_dt": 0, "PO4_EMC": " ", "TOC_dt": 0, "TOC_EMC": " ", "NH3_NH4_dt": 0, "NH3_NH4_EMC": " ", "TKN_dt": 0, "TKN_EMC": " ", "NITRATE_NITRITE_dt": 0, "NITRATE_NITRITE_EMC": " ", "TOTAL_PHOSPHORUS_dt": 0, "TOTAL_PHOSPHORUS_EMC": " ", "TSS_dt": 0, "TSS_EMC": " ", "TOTAL_COPPER_dt": 0, "TOTAL_COPPER_EMC": " ", "TOTAL_LEAD_dt": 0, "TOTAL_LEAD_EMC": " ", "TOTAL_ZINC_dt": 0, "TOTAL_ZINC_EMC": " ", "HARDNESS_dt": 0, "HARDNESS_EMC": " ", "TPH_dt": 0, "TPH_EMC": " ", "ENTEROCOCCI_dt": 0, "ENTEROCOCCI_EMC": " ", "ECOLI_dt": 0, "GEN_COMMENTS": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }