{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 23, "name": "springsSampling", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "DBO.springsSites", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "siteNumber", "composite": false, "catalogID": "{E1B1FFFB-226F-4D57-9E2B-13EC9E1D7E7E}" } ], "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, "supportsReturningGeometryEnvelope": 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,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "analyteName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "siteNumber", "type": "esriFieldTypeString", "alias": "siteNumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "siteNumber" }, { "name": "samplingType", "type": "esriFieldTypeString", "alias": "samplingType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "samplingType" }, { "name": "collectionMethod", "type": "esriFieldTypeString", "alias": "collectionMethod", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "collectionMethod" }, { "name": "samplingMedia", "type": "esriFieldTypeString", "alias": "samplingMedia", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "samplingMedia" }, { "name": "samplingDate", "type": "esriFieldTypeDate", "alias": "samplingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "samplingDate" }, { "name": "samplingTime", "type": "esriFieldTypeString", "alias": "samplingTime", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "samplingTime" }, { "name": "analyteName", "type": "esriFieldTypeString", "alias": "analyteName", "domain": { "type": "codedValue", "name": "analyte", "description": "analyte", "codedValues": [ { "name": "Velocity-discharge", "code": "Discharge" }, { "name": "Temperature, water", "code": "Temperature" }, { "name": "Specific conductance", "code": "SpC" }, { "name": "Dissolved oxygen (DO)", "code": "DO" }, { "name": "pH", "code": "pH" }, { "name": "Eh", "code": "Eh" }, { "name": "Alkalinity, carbonate", "code": "Alkalinity" }, { "name": "Bicarbonate", "code": "HCO3" }, { "name": "Carbonate", "code": "CO3" }, { "name": "Fluoride", "code": "F" }, { "name": "Chloride", "code": "Cl" }, { "name": "Nitrate", "code": "NO3" }, { "name": "Sulfate", "code": "SO4" }, { "name": "Calcium", "code": "Ca" }, { "name": "Magnesium", "code": "Mg" }, { "name": "Potassium", "code": "K" }, { "name": "Sodium", "code": "Na" }, { "name": "Iron", "code": "Fe" }, { "name": "Manganese", "code": "Mn" }, { "name": "Zinc", "code": "Zn" }, { "name": "Barium", "code": "Ba" }, { "name": "Strontium", "code": "Sr" }, { "name": "Aluminum", "code": "Al" }, { "name": "Silicon", "code": "Si" }, { "name": "Total dissolved solids", "code": "TDS" }, { "name": "Oxidation reduction potential (ORP)", "code": "ORP" }, { "name": "Sum of anions", "code": "SumAnions" }, { "name": "Sum of cations", "code": "SumCations" }, { "name": "Anion/cation ratio", "code": "EPMBalance" }, { "name": "Hardness, carbonate", "code": "HardnessCarbonate" }, { "name": "Ammonia", "code": "NH3" }, { "name": "Orthophosphate", "code": "PO4" }, { "name": "Escherichia coli", "code": "Ecoli" }, { "name": "Total nonfecal coliform", "code": "OtherColiform" }, { "name": "AsTotal", "code": "AsTotal" }, { "name": "Arsenic", "code": "As" }, { "name": "Cadmium", "code": "Cd" }, { "name": "Chromium", "code": "Cr" }, { "name": "Lithium", "code": "Li" }, { "name": "Lead", "code": "Pb" }, { "name": "Bromine", "code": "Br" }, { "name": "Boron", "code": "B" }, { "name": "Carbon, isotope of mass 13", "code": "Carbon13" }, { "name": "Deuterium", "code": "Deuterium" }, { "name": "Oxygen-18", "code": "Oxygen18" }, { "name": "Sulfur-34", "code": "Sulfur34" }, { "name": "Nickel", "code": "Ni" }, { "name": "Nitrite", "code": "NO2" }, { "name": "Dissolved Organic Carbon", "code": "DOC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "analyteName" }, { "name": "analyteValue", "type": "esriFieldTypeDouble", "alias": "analyteValue", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "analyteValue" }, { "name": "measureUnit", "type": "esriFieldTypeString", "alias": "measureUnit", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "measureUnit" }, { "name": "sampleFraction", "type": "esriFieldTypeString", "alias": "sampleFraction", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sampleFraction" }, { "name": "detectionLimit", "type": "esriFieldTypeDouble", "alias": "detectionLimit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "detectionLimit" }, { "name": "detectionLimitUnit", "type": "esriFieldTypeString", "alias": "detectionLimitUnit", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "detectionLimitUnit" }, { "name": "method", "type": "esriFieldTypeString", "alias": "method", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "method" }, { "name": "analyticalMethodSystem", "type": "esriFieldTypeString", "alias": "analyticalMethodSystem", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "analyticalMethodSystem" }, { "name": "projectId", "type": "esriFieldTypeString", "alias": "projectId", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projectId" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R415_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2991siteNumber", "fields": "siteNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_415", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "springsSampling", "description": "", "prototype": { "attributes": { "projectId": null, "siteNumber": null, "samplingType": null, "collectionMethod": null, "samplingMedia": null, "samplingDate": null, "samplingTime": null, "analyteName": null, "analyteValue": null, "measureUnit": null, "sampleFraction": null, "detectionLimit": null, "detectionLimitUnit": null, "method": null, "analyticalMethodSystem": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 700000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 700000, "maxRecordCountFactor": 1, "serviceItemId": "9a222ea13ffb4ec285ebcfc5f50d076d" }