{
"layers": [
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 0,
"name": "DEQ_SDE.D_WATER.dw_enterprise_data",
"type": "Feature Layer",
"parentLayer": null,
"defaultVisibility": true,
"minScale": 0,
"maxScale": 0,
"canScaleSymbols": false,
"geometryType": "esriGeometryPoint",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [
{
"id": 0,
"name": "dw_enterprise_program_IDs",
"relatedTableId": 2,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "Location",
"composite": false,
"catalogID": "{57CBCF51-51C3-40EB-BADE-4CCB6D1B44C5}"
},
{
"id": 1,
"name": "dw_enterprise_lab_related",
"relatedTableId": 1,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "Location",
"composite": false,
"catalogID": "{3C5F1F92-E6B3-4C17-B0F9-2C9CDA933255}"
}
],
"isDataVersioned": false,
"isDataArchived": true,
"infoInEstimates": [
"extent",
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1596487642000
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": true,
"supportsQuantizationEditMode": true,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"supportsDatumTransformation": 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,
"supportsQueryWithDatumTransformation": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": true,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": false,
"extent": {
"xmin": -90.16489199999995,
"ymin": 41.719017000000065,
"xmax": -82.42600999999996,
"ymax": 47.46511600000008,
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 2,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 1.125899906842624E13,
"falseZ": 0,
"zUnits": 1,
"falseM": -100000,
"mUnits": 10000
}
},
"sourceSpatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
0,
171,
173,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"hasM": false,
"hasZ": false,
"allowGeometryUpdates": false,
"allowTrueCurvesUpdates": false,
"onlyAllowTrueCurveUpdatesByTrueCurveClients": false,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "site_name",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "unique_id",
"type": "esriFieldTypeString",
"alias": "unique_id",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "unique_id"
},
{
"name": "Location",
"type": "esriFieldTypeString",
"alias": "Location",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "Location"
},
{
"name": "WSSN",
"type": "esriFieldTypeInteger",
"alias": "WSSN",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "WSSN"
},
{
"name": "site_name",
"type": "esriFieldTypeString",
"alias": "site_name",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "site_name"
},
{
"name": "site_code",
"type": "esriFieldTypeString",
"alias": "site_code",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "site_code"
},
{
"name": "street_num",
"type": "esriFieldTypeInteger",
"alias": "street_num",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "street_num"
},
{
"name": "street_dir",
"type": "esriFieldTypeString",
"alias": "street_dir",
"domain": null,
"editable": true,
"nullable": true,
"length": 4,
"defaultValue": null,
"modelName": "street_dir"
},
{
"name": "street_name",
"type": "esriFieldTypeString",
"alias": "street_name",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "street_name"
},
{
"name": "street_type",
"type": "esriFieldTypeString",
"alias": "street_type",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "street_type"
},
{
"name": "street_quad",
"type": "esriFieldTypeString",
"alias": "street_quad",
"domain": null,
"editable": true,
"nullable": true,
"length": 4,
"defaultValue": null,
"modelName": "street_quad"
},
{
"name": "zip_code",
"type": "esriFieldTypeInteger",
"alias": "zip_code",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "zip_code"
},
{
"name": "City",
"type": "esriFieldTypeString",
"alias": "City",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "City"
},
{
"name": "full_address",
"type": "esriFieldTypeString",
"alias": "full_address",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "full_address"
},
{
"name": "County",
"type": "esriFieldTypeString",
"alias": "County",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "County"
},
{
"name": "Latitude",
"type": "esriFieldTypeDouble",
"alias": "Latitude",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Latitude"
},
{
"name": "Longitude",
"type": "esriFieldTypeDouble",
"alias": "Longitude",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Longitude"
},
{
"name": "EGLE_District",
"type": "esriFieldTypeString",
"alias": "EGLE_District",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "EGLE_District"
},
{
"name": "Senate_District",
"type": "esriFieldTypeString",
"alias": "Senate_District",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "Senate_District"
},
{
"name": "Congress_District",
"type": "esriFieldTypeString",
"alias": "Congress_District",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "Congress_District"
},
{
"name": "House_District",
"type": "esriFieldTypeString",
"alias": "House_District",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "House_District"
},
{
"name": "Watershed_huc8",
"type": "esriFieldTypeString",
"alias": "Watershed_huc8",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "Watershed_huc8"
},
{
"name": "Watershed_huc10",
"type": "esriFieldTypeString",
"alias": "Watershed_huc10",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "Watershed_huc10"
},
{
"name": "watershed_huc12",
"type": "esriFieldTypeString",
"alias": "watershed_huc12",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "watershed_huc12"
},
{
"name": "county_num",
"type": "esriFieldTypeSmallInteger",
"alias": "county_num",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "county_num"
},
{
"name": "local_health_department",
"type": "esriFieldTypeString",
"alias": "local_health_department",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "local_health_department"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null,
"editable": false,
"nullable": true,
"defaultValue": null,
"modelName": "Shape"
},
"indexes": [
{
"name": "UUID_982",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_11491_Locati",
"fields": "Location",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_982",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S752_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "DEQ_SDE.D_WATER.dw_enterprise_data",
"description": "",
"prototype": {
"attributes": {
"local_health_department": null,
"county_num": null,
"unique_id": null,
"Location": null,
"WSSN": null,
"site_name": null,
"site_code": null,
"street_num": null,
"street_dir": null,
"street_name": null,
"street_type": null,
"street_quad": null,
"zip_code": null,
"City": null,
"full_address": null,
"County": null,
"Latitude": null,
"Longitude": null,
"EGLE_District": null,
"Senate_District": null,
"Congress_District": null,
"House_District": null,
"Watershed_huc8": null,
"Watershed_huc10": null,
"watershed_huc12": null
}
},
"drawingTool": "esriFeatureEditToolPoint"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 8000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1
}
],
"tables": [
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 1,
"name": "DEQ_SDE.D_WATER.dw_enterprise_lab_related",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [
{
"id": 1,
"name": "dw_enterprise_data",
"relatedTableId": 0,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "Location",
"composite": false,
"catalogID": "{3C5F1F92-E6B3-4C17-B0F9-2C9CDA933255}"
},
{
"id": 2,
"name": "dw_enterprise_sample_collection",
"relatedTableId": 4,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "sample_kit_num",
"composite": false,
"catalogID": "{E54DC0BB-FDFB-45C0-BACD-3DF4DB9AC397}"
}
],
"isDataVersioned": false,
"isDataArchived": true,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1596487692000
},
"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": false,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "Analyte_name",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "sample_kit_num",
"type": "esriFieldTypeString",
"alias": "sample_kit_num",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "sample_kit_num"
},
{
"name": "Lab_ID",
"type": "esriFieldTypeString",
"alias": "Lab_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "Lab_ID"
},
{
"name": "Analyte_name",
"type": "esriFieldTypeString",
"alias": "Analyte_name",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "Analyte_name"
},
{
"name": "cas_rn",
"type": "esriFieldTypeString",
"alias": "cas_rn",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "cas_rn"
},
{
"name": "result_value",
"type": "esriFieldTypeInteger",
"alias": "result_value",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "result_value"
},
{
"name": "non_detect",
"type": "esriFieldTypeString",
"alias": "non_detect",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "non_detect"
},
{
"name": "Units",
"type": "esriFieldTypeString",
"alias": "Units",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "Units"
},
{
"name": "Method",
"type": "esriFieldTypeString",
"alias": "Method",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "Method"
},
{
"name": "unique_ID",
"type": "esriFieldTypeString",
"alias": "unique_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "unique_ID"
},
{
"name": "Location",
"type": "esriFieldTypeString",
"alias": "Location",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "Location"
},
{
"name": "analysis_date",
"type": "esriFieldTypeDate",
"alias": "analysis_date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "analysis_date"
},
{
"name": "flag",
"type": "esriFieldTypeString",
"alias": "flag",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "flag"
},
{
"name": "GUID",
"type": "esriFieldTypeGUID",
"alias": "GUID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "GUID"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
}
],
"indexes": [
{
"name": "UUID_984",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_11493_Locati",
"fields": "Location",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "GDB_11493_sample",
"fields": "sample_kit_num",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_984",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "DEQ_SDE.D_WATER.dw_enterprise_lab_related",
"description": "",
"prototype": {
"attributes": {
"GUID": null,
"flag": null,
"sample_kit_num": null,
"Lab_ID": null,
"Analyte_name": null,
"cas_rn": null,
"result_value": null,
"non_detect": null,
"Units": null,
"Method": null,
"unique_ID": null,
"Location": null,
"analysis_date": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 2,
"name": "DEQ_SDE.D_WATER.dw_enterprise_program_IDs",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [
{
"id": 0,
"name": "dw_enterprise_data",
"relatedTableId": 0,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "location",
"composite": false,
"catalogID": "{57CBCF51-51C3-40EB-BADE-4CCB6D1B44C5}"
}
],
"isDataVersioned": false,
"isDataArchived": true,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1596487727000
},
"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": false,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "unique_id",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "unique_id",
"type": "esriFieldTypeString",
"alias": "unique_id",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "unique_id"
},
{
"name": "location",
"type": "esriFieldTypeString",
"alias": "location",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "location"
},
{
"name": "program_id",
"type": "esriFieldTypeString",
"alias": "program_id",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "program_id"
},
{
"name": "program_database",
"type": "esriFieldTypeString",
"alias": "program_database",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "program_database"
},
{
"name": "GUID",
"type": "esriFieldTypeGUID",
"alias": "GUID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "GUID"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
}
],
"indexes": [
{
"name": "UUID_985",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_11494_locati",
"fields": "location",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_985",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "DEQ_SDE.D_WATER.dw_enterprise_program_IDs",
"description": "",
"prototype": {
"attributes": {
"GUID": null,
"program_database": null,
"unique_id": null,
"location": null,
"program_id": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 3,
"name": "DEQ_SDE.D_WATER.dw_enterprise_report_data_relate",
"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": false,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "unique_ID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "unique_ID",
"type": "esriFieldTypeString",
"alias": "unique_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "unique_ID"
},
{
"name": "staff_notes",
"type": "esriFieldTypeString",
"alias": "staff_notes",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "staff_notes"
},
{
"name": "date_letter_sent",
"type": "esriFieldTypeDate",
"alias": "date_letter_sent",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "date_letter_sent"
},
{
"name": "date_reported",
"type": "esriFieldTypeDate",
"alias": "date_reported",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "date_reported"
},
{
"name": "contractor_comments",
"type": "esriFieldTypeString",
"alias": "contractor_comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "contractor_comments"
},
{
"name": "WSSN",
"type": "esriFieldTypeInteger",
"alias": "WSSN",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "WSSN"
},
{
"name": "LHD",
"type": "esriFieldTypeString",
"alias": "LHD",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "LHD"
},
{
"name": "Letter_needed",
"type": "esriFieldTypeString",
"alias": "Letter_needed",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "Letter_needed"
},
{
"name": "GUID",
"type": "esriFieldTypeGUID",
"alias": "GUID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "GUID"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
}
],
"indexes": [
{
"name": "R986_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_986",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "DEQ_SDE.D_WATER.dw_enterprise_report_data_relate",
"description": "",
"prototype": {
"attributes": {
"GUID": null,
"Letter_needed": null,
"unique_ID": null,
"staff_notes": null,
"date_letter_sent": null,
"date_reported": null,
"contractor_comments": null,
"WSSN": null,
"LHD": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 4,
"name": "DEQ_SDE.D_WATER.dw_enterprise_sample_collection",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 2,
"name": "dw_enterprise_lab_related",
"relatedTableId": 1,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleOrigin",
"keyField": "sample",
"composite": false,
"catalogID": "{E54DC0BB-FDFB-45C0-BACD-3DF4DB9AC397}"
}
],
"isDataVersioned": false,
"isDataArchived": true,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1596487861000
},
"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": false,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "feature_name",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "unique_id",
"type": "esriFieldTypeString",
"alias": "unique_id",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "unique_id"
},
{
"name": "location",
"type": "esriFieldTypeString",
"alias": "location",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "location"
},
{
"name": "sample",
"type": "esriFieldTypeString",
"alias": "sample",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "sample"
},
{
"name": "sample_contract",
"type": "esriFieldTypeString",
"alias": "sample_contract",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "sample_contract"
},
{
"name": "sample_staff",
"type": "esriFieldTypeString",
"alias": "sample_staff",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "sample_staff"
},
{
"name": "sample_kit_ID",
"type": "esriFieldTypeString",
"alias": "sample_kit_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "sample_kit_ID"
},
{
"name": "sample_date",
"type": "esriFieldTypeDate",
"alias": "sample_date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "sample_date"
},
{
"name": "division",
"type": "esriFieldTypeString",
"alias": "division",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "division"
},
{
"name": "program",
"type": "esriFieldTypeString",
"alias": "program",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "program"
},
{
"name": "feature_name",
"type": "esriFieldTypeString",
"alias": "feature_name",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "feature_name"
},
{
"name": "feature_type",
"type": "esriFieldTypeString",
"alias": "feature_type",
"domain": null,
"editable": true,
"nullable": true,
"length": 30,
"defaultValue": null,
"modelName": "feature_type"
},
{
"name": "matrix",
"type": "esriFieldTypeString",
"alias": "matrix",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "matrix"
},
{
"name": "sample_comments",
"type": "esriFieldTypeString",
"alias": "sample_comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 4000,
"defaultValue": null,
"modelName": "sample_comments"
},
{
"name": "feature_comments",
"type": "esriFieldTypeString",
"alias": "feature_comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 4000,
"defaultValue": null,
"modelName": "feature_comments"
},
{
"name": "GUID",
"type": "esriFieldTypeGUID",
"alias": "GUID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "GUID"
}
],
"indexes": [
{
"name": "GDB_11496_sample",
"fields": "sample",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_987",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "DEQ_SDE.D_WATER.dw_enterprise_sample_collection",
"description": "",
"prototype": {
"attributes": {
"feature_comments": null,
"GUID": null,
"unique_id": null,
"location": null,
"sample": null,
"sample_contract": null,
"sample_staff": null,
"sample_kit_ID": null,
"sample_date": null,
"division": null,
"program": null,
"feature_name": null,
"feature_type": null,
"matrix": null,
"sample_comments": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
}
]
}