{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "WELL_MEASUREMENT", "type": "Table", "description": "The Well Measurement table represents the result of monitoring activities and includes groundwater elevations, quality and levels, quality data for the San Pasqual Valley basin. The table is used to populate ground water levels visualized through the San Pasqual Valley Subbasin Data Management System (DMS), which is a public facing application hosted by the City of San Diego. ", "copyrightText": "The City of San Diego and The County of San Diego San Pasqual Valley Groundwater Sustainability Plan", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SITE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "SITE_NAME", "type": "esriFieldTypeString", "alias": "SITE_NAME", "length": 255, "domain": null }, { "name": "MEASUREMENT_DATE", "type": "esriFieldTypeDate", "alias": "MEASUREMENT_DATE", "length": 8, "domain": null }, { "name": "DEPTH_TO_GROUNDWATER", "type": "esriFieldTypeDouble", "alias": "Depth to Groundwater (ft BGS)", "domain": null }, { "name": "FLOW_VOLUME", "type": "esriFieldTypeInteger", "alias": "Flow Volume (CF/day)", "domain": null }, { "name": "GROUNDWATER_ELEVATION", "type": "esriFieldTypeDouble", "alias": "Groundwater Elevation (ft above MSL)", "domain": null }, { "name": "NITRATE", "type": "esriFieldTypeDouble", "alias": "Nitrate as N03-N (MG/L)", "domain": null }, { "name": "STREAMFLOW", "type": "esriFieldTypeDouble", "alias": "Streamflow (Mean Daily CFS)", "domain": null }, { "name": "TDS", "type": "esriFieldTypeDouble", "alias": "Total Dissolved Solids (MG/L)", "domain": null }, { "name": "MEASUREMENT_ISSUE", "type": "esriFieldTypeString", "alias": "MEASUREMENT_ISSUE", "length": 255, "domain": null }, { "name": "MEASUREMENT_METHOD", "type": "esriFieldTypeString", "alias": "MEASUREMENT_METHOD", "length": 255, "domain": null }, { "name": "MEASUREMENT_ACCURACY", "type": "esriFieldTypeString", "alias": "MEASUREMENT_ACCURACY", "length": 255, "domain": null }, { "name": "WATER_SURFACE", "type": "esriFieldTypeDouble", "alias": "WATER_SURFACE", "domain": null }, { "name": "REFERENCE_POINT", "type": "esriFieldTypeDouble", "alias": "REFERENCE_POINT", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "DATA_COLLECTOR", "type": "esriFieldTypeString", "alias": "DATA_COLLECTOR", "length": 255, "domain": null }, { "name": "DATA_SOURCE", "type": "esriFieldTypeString", "alias": "DATA_SOURCE", "length": 255, "domain": null }, { "name": "GROUNDWATER_MEASURABLE_OBJ", "type": "esriFieldTypeDouble", "alias": "Groundwater Elevation Measurable Objective", "domain": null }, { "name": "GROUNDWATER_MINIMUM_TH", "type": "esriFieldTypeDouble", "alias": "Groundwater Elevation Minimum Threshold", "domain": null }, { "name": "DEPTH_MEASURABLE_OBJ", "type": "esriFieldTypeDouble", "alias": "Depth to Groundwater Measurable Objective", "domain": null }, { "name": "DEPTH_MINIMUM_TH", "type": "esriFieldTypeDouble", "alias": "Depth to Groundwater Minimum Threshold", "domain": null }, { "name": "NITRATE_MEASURABLE_OBJ", "type": "esriFieldTypeDouble", "alias": "Nitrate Measurable Objective", "domain": null }, { "name": "NITRATE_MINIMUM_TH", "type": "esriFieldTypeDouble", "alias": "Nitrate Minimum Threshold", "domain": null }, { "name": "DEPTH_TO_GROUNDWATER_GRAPH", "type": "esriFieldTypeDouble", "alias": "Depth to Groundwater (ft BGS)", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R2834_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2834", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G98230ID", "fields": "ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_2834", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PUD.WELL_SITE", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D4270418-67F4-4C27-82B6-962A9AAE6B80}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "d65e163a2c6c4e8291b135465df524db" }