{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 7, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database bedrock table", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "bedrock_type": null, "depth_to_bedrock_ft": null, "borehole_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database bedrock table", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "Object ID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth_to_bedrock_ft", "alias": "Depth to Bedrock (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bedrock_type", "length": 30, "alias": "Bedrock Type", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g344borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r180_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 10, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database hydrologic data", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "artesian_pressure_psi": null, "comments": null, "water_temperature_c": null, "drawdown_time_hours": null, "depth_to_water_ft": null, "drawdown_yield_gpm": null, "test_date": null, "chemical_test_flag": null, "drawdown_distance_ft": null, "borehole_id": null, "airtest_stem_ft": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database hydrologic data", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "Object ID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth_to_water_ft", "alias": "Depth to Water (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "artesian_pressure_psi", "alias": "Artesian Pressure (psi)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawdown_yield_gpm", "alias": "Drawdown Yield (gpm)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawdown_distance_ft", "alias": "Drawdown Distance (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "airtest_stem_ft", "alias": "Airtest Stem (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawdown_time_hours", "alias": "Drawdown Time (hrs)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "test_date", "length": 29, "alias": "Test Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "water_temperature_c", "alias": "Water Temperature (c)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "chemical_test_flag", "length": 5, "alias": "Chemical Test Flag", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g345borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r181_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_181", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 8, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database in-situ test data", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "n_number": null, "count_comment": null, "comments": null, "start_depth_ft": null, "calibrated_n_flag": null, "test_date": null, "borehole_id": null, "test_type": null, "sampler": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database in-situ test data", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "Object ID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_depth_ft", "alias": "Start Depth (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "n_number", "alias": "N Number", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Flag field_2", "description": "Identifies if the item of interest exists in the data entry.", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" }, { "code": "U", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "calibrated_n_flag", "length": 10, "alias": "Calibrated N Flag", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "count_comment", "length": 10, "alias": "Count Comment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "test_date", "length": 29, "alias": "Test Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "test_type", "length": 100, "alias": "Test Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sampler", "length": 50, "alias": "Sampler", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g346borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r182_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_182", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 9, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database layer comments", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "comments": null, "comment_depth_ft": null, "comment_number": null, "borehole_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database layer comments", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "Object ID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_number", "alias": "Comment Number", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_depth_ft", "alias": "Comment Depth (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 400, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g347borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r183_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_183", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 11, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database layer data", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "geologic_unit_confidence": null, "comments": null, "symbol_lithology": null, "layer_number": null, "bottom_depth_ft": null, "description": null, "layer_type": null, "geologic_unit": null, "interpreted_lithology": null, "top_depth_ft": null, "uscs": null, "geologist": null, "borehole_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database layer data", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "Object ID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "layer_number", "alias": "Layer Number", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "top_depth_ft", "alias": "Top Depth (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bottom_depth_ft", "alias": "Bottom Depth (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 500, "alias": "Description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Layer type", "description": "Nature of the contact with the described layer and it's surroundings.", "type": "codedValue", "codedValues": [ { "code": "Single", "name": "Single" }, { "code": "Gradational", "name": "Gradational" }, { "code": "Interbedded", "name": "Interbedded" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "layer_type", "length": 15, "alias": "Layer Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uscs", "length": 20, "alias": "USCS", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Symbol lithology", "description": "General classification of the layer's lithology.", "type": "codedValue", "codedValues": [ { "code": "Asphalt / concrete", "name": "Asphalt / concrete" }, { "code": "Topsoil / vegetation", "name": "Topsoil / vegetation" }, { "code": "Debris", "name": "Debris" }, { "code": "Fill", "name": "Fill" }, { "code": "Gravel", "name": "Gravel" }, { "code": "Gravelly sand", "name": "Gravelly sand" }, { "code": "Gravelly silt", "name": "Gravelly silt" }, { "code": "Gravelly clay", "name": "Gravelly clay" }, { "code": "Sand", "name": "Sand" }, { "code": "Sandy gravel", "name": "Sandy gravel" }, { "code": "Sandy silt", "name": "Sandy silt" }, { "code": "Sandy clay", "name": "Sandy clay" }, { "code": "Silt", "name": "Silt" }, { "code": "Silty gravel", "name": "Silty gravel" }, { "code": "Silty sand", "name": "Silty sand" }, { "code": "Silty clay", "name": "Silty clay" }, { "code": "Clay", "name": "Clay" }, { "code": "Clayey gravel", "name": "Clayey gravel" }, { "code": "Clayey sand", "name": "Clayey sand" }, { "code": "Clayey silt", "name": "Clayey silt" }, { "code": "Peat", "name": "Peat" }, { "code": "Volcanic ash", "name": "Volcanic ash" }, { "code": "Sedimentary bedrock", "name": "Sedimentary bedrock" }, { "code": "Metamophic bedrock", "name": "Metamophic bedrock" }, { "code": "Plutonic bedrock", "name": "Plutonic bedrock" }, { "code": "Volcanic bedrock", "name": "Volcanic bedrock" }, { "code": "Cobbles / boulders", "name": "Cobbles / boulders" }, { "code": "Undifferentiated rock", "name": "Undifferentiated rock" }, { "code": "Undefined", "name": "Undefined" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "symbol_lithology", "length": 30, "alias": "Symbol Lithology", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "interpreted_lithology", "length": 30, "alias": "Interpreted Lithology", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geologic_unit", "length": 12, "alias": "Geologic Unit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Geologic unit confidence", "description": "Certainty estimate for the selected geologic unit and contact depth.", "type": "codedValue", "codedValues": [ { "code": "Low", "name": "Low" }, { "code": "Medium", "name": "Medium" }, { "code": "High", "name": "High" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "geologic_unit_confidence", "length": 20, "alias": "Geologic Unit Confidence", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geologist", "length": 30, "alias": "Geologist", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g348borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r184_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_184", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 12, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database lithology logs", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "borehole_id": null, "url": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database lithology logs", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "url", "length": 255, "alias": "Hyperlink", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g350borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r186_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_186", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "document_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 1, "id": 13, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "document_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 0, "id": 5, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Subsurface database documents", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "document_title": null, "document_link": null, "project_type": null, "comments": null, "project_address": null, "document_date": null, "document_id": null, "document_author": null, "borehole_count": null, "geoprofile_flag": null, "document_source": null, "slope_stability_flag": null, "document_type": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database documents", "displayField": "document_id", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_id", "alias": "Document ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_author", "length": 100, "alias": "Document Author", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_source", "length": 100, "alias": "Document Source", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Document Type", "description": "The type of scanned document the record is linked to.", "type": "codedValue", "codedValues": [ { "code": "Report", "name": "Report" }, { "code": "Other", "name": "Other" }, { "code": "Boring Log", "name": "Boring log" }, { "code": "Field Notes", "name": "Field notes" }, { "code": "Geologic Map", "name": "Geologic map" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "document_type", "length": 20, "alias": "Document Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_title", "length": 255, "alias": "Document Title", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "document_date", "length": 29, "alias": "Document Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Project type", "description": "Primary subsequent use of land or design intent.", "type": "codedValue", "codedValues": [ { "code": "Transportation - non-roadway", "name": "Transportation - non-roadway" }, { "code": "Residential", "name": "Residential" }, { "code": "Retail / commercial building", "name": "Retail / commercial building" }, { "code": "Automotive / fueling depot", "name": "Automotive / fueling depot" }, { "code": "Water well", "name": "Water well" }, { "code": "Industrial", "name": "Industrial" }, { "code": "Landfill", "name": "Landfill" }, { "code": "Landslide", "name": "Landslide" }, { "code": "Dry cleaner / laundry", "name": "Dry cleaner / laundry" }, { "code": "Military", "name": "Military" }, { "code": "Mine", "name": "Mine" }, { "code": "Park / recreation", "name": "Park / recreation" }, { "code": "Railroad", "name": "Railroad" }, { "code": "Retaining wall", "name": "Retaining wall" }, { "code": "Roadway", "name": "Roadway" }, { "code": "Utility", "name": "Utility" }, { "code": "Tunnel", "name": "Tunnel" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Bridge", "name": "Bridge" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "project_type", "length": 50, "alias": "Project Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_address", "length": 100, "alias": "Project Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_count", "alias": "Borehole Count", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_link", "length": 255, "alias": "Document Link", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "geoprofile_flag", "length": 5, "alias": "Geoprofile Flag", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "type": "codedValue", "codedValues": [ { "code": "Y", "name": "Yes" }, { "code": "N", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "slope_stability_flag", "length": 5, "alias": "Slope Stability Flag", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "g349document_id", "isUnique": false, "description": "", "fields": "document_id", "isAscending": true }, { "name": "r185_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_185", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 97682.68994140625, "xmin": 687727.732421875, "ymax": 1345776.1469726562, "xmax": 2505476.8657226562, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2927, "zTolerance": 0.001, "wkid": 2927, "xyUnits": 2048, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "lithology_logs", "relatedTableId": 7, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "bedrock", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "in_situ_test_data", "relatedTableId": 4, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "hydrologic", "relatedTableId": 3, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_comments", "relatedTableId": 5, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "document_id", "role": "esriRelRoleOrigin", "composite": false, "name": "subsurface_documents", "relatedTableId": 8, "id": 5, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_data", "relatedTableId": 6, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Borehole information", "allowTrueCurvesUpdates": false, "displayField": "borehole_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "Object ID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_id", "alias": "Document ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_name", "length": 50, "alias": "Borehole Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Borehole class", "description": "Primary category for the borehole.", "type": "codedValue", "codedValues": [ { "code": "Geotechnical", "name": "Geotechnical" }, { "code": "Water well", "name": "Water well" }, { "code": "Test pit", "name": "Test pit" }, { "code": "Lithologic boring", "name": "Lithologic boring" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "borehole_class", "length": 25, "alias": "Borehole Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Borehole type_1", "description": "Purpose for which the borehole was created.", "type": "codedValue", "codedValues": [ { "code": "Exposure", "name": "Exposure" }, { "code": "Geotechnical", "name": "Geotechnical" }, { "code": "Other", "name": "Other" }, { "code": "Carbon sequestration", "name": "Carbon sequestration" }, { "code": "Cone penetrometer", "name": "Cone penetrometer" }, { "code": "Earthquake monitoring", "name": "Earthquake monitoring" }, { "code": "Mineral exploration", "name": "Mineral exploration" }, { "code": "Monitoring well", "name": "Monitoring well" }, { "code": "Oil and gas", "name": "Oil and gas" }, { "code": "Test pit", "name": "Test pit" }, { "code": "Water well", "name": "Water well" }, { "code": "Boring / probe", "name": "Boring / probe" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "borehole_type", "length": 50, "alias": "Borehole Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_depth_ft", "alias": "Borehole Depth (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_diameter_in", "alias": "Borehole Diameter (in)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "borehole_date", "length": 29, "alias": "Borehole Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation_ft", "alias": "Elevation (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Elevation Method", "description": "How the surface elevation values for the boreholes were determined.", "type": "codedValue", "codedValues": [ { "code": "Altimeter", "name": "Altimeter" }, { "code": "DEM", "name": "DEM" }, { "code": "GPS", "name": "GPS" }, { "code": "LiDAR", "name": "LiDAR" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Estimated from Topo", "name": "Estimated from topo" }, { "code": "Land Survey", "name": "Land survey" }, { "code": "Report Text", "name": "Report text" }, { "code": "Site Plan", "name": "Site plan" }, { "code": "Well Log", "name": "Well log" }, { "code": "Not Applicable", "name": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "elevation_method", "length": 50, "alias": "Elevation Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_name", "length": 100, "alias": "Contractor Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Boring method_1", "description": "Technique used to construct the borehole.", "type": "codedValue", "codedValues": [ { "code": "Coring", "name": "Coring" }, { "code": "Odex", "name": "Odex" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Shallow pit", "name": "Shallow pit dug by hand or mechanical means" }, { "code": "Air rotary", "name": "Air rotary" }, { "code": "Becker hammer", "name": "Becker hammer" }, { "code": "Cable tool", "name": "Cable tool" }, { "code": "Direct push", "name": "Direct push" }, { "code": "Hand auger", "name": "Hand auger" }, { "code": "Hollow stem auger", "name": "Hollow stem auger" }, { "code": "Mud rotary", "name": "Mud rotary" }, { "code": "Sonic core", "name": "Sonic core" }, { "code": "Vactor truck", "name": "Vactor truck" }, { "code": "Wash boring", "name": "Wash boring" }, { "code": "Not applicable", "name": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "boring_method", "length": 50, "alias": "Boring Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Location Confidence", "description": "Accuracy of the point location for the borehole.", "type": "codedValue", "codedValues": [ { "code": "Survey", "name": "Surveyed" }, { "code": "High", "name": "Less than 20 feet" }, { "code": "Medium", "name": "Between 20 and 100 feet" }, { "code": "Low", "name": "Greater than 100 feet" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "location_confidence", "length": 50, "alias": "Location Confidence", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Data Confidence", "description": "Usefuleness of the information on the well log.", "type": "codedValue", "codedValues": [ { "code": "High", "name": "High" }, { "code": "Medium", "name": "Medium" }, { "code": "Low", "name": "Low" }, { "code": "Not applicable", "name": "Not applicable" }, { "code": "Medium high", "name": "Medium high" }, { "code": "Medium low", "name": "Medium low" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "data_confidence", "length": 20, "alias": "Data Confidence", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "County name", "description": "County in which the borehole was drilled", "type": "codedValue", "codedValues": [ { "code": "Adams", "name": "Adams" }, { "code": "Asotin", "name": "Asotin" }, { "code": "Benton", "name": "Benton" }, { "code": "Chelan", "name": "Chelan" }, { "code": "Clallam", "name": "Clallam" }, { "code": "Clark", "name": "Clark" }, { "code": "Columbia", "name": "Columbia" }, { "code": "Cowlitz", "name": "Cowlitz" }, { "code": "Douglas", "name": "Douglas" }, { "code": "Ferry", "name": "Ferry" }, { "code": "Franklin", "name": "Franklin" }, { "code": "Garfield", "name": "Garfield" }, { "code": "Grant", "name": "Grant" }, { "code": "Grays Harbor", "name": "Grays Harbor" }, { "code": "Island", "name": "Island" }, { "code": "Jefferson", "name": "Jefferson" }, { "code": "King", "name": "King" }, { "code": "Kitsap", "name": "Kitsap" }, { "code": "Kittitas", "name": "Kittitas" }, { "code": "Klickitat", "name": "Klickitat" }, { "code": "Lewis", "name": "Lewis" }, { "code": "Lincoln", "name": "Lincoln" }, { "code": "Mason", "name": "Mason" }, { "code": "Okanogan", "name": "Okanogan" }, { "code": "Pacific", "name": "Pacific" }, { "code": "Pend Oreille", "name": "Pend Oreille" }, { "code": "Pierce", "name": "Pierce" }, { "code": "San Juan", "name": "San Juan" }, { "code": "Skagit", "name": "Skagit" }, { "code": "Skamania", "name": "Skamania" }, { "code": "Snohomish", "name": "Snohomish" }, { "code": "Spokane", "name": "Spokane" }, { "code": "Stevens", "name": "Stevens" }, { "code": "Thurston", "name": "Thurston" }, { "code": "Wahkiakum", "name": "Wahkiakum" }, { "code": "Walla Walla", "name": "Walla Walla" }, { "code": "Whatcom", "name": "Whatcom" }, { "code": "Whitman", "name": "Whitman" }, { "code": "Yakima", "name": "Yakima" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "county_name", "length": 20, "alias": "County Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_db_code", "alias": "Source Database Code", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source_db_id", "length": 50, "alias": "Source Database ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ecyid", "alias": "Ecology ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reported_elevation", "alias": "Reported Elevation (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reported_elevation_method", "length": 50, "alias": "Reported Elevation Method", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.003280833333333333, "mUnits": 1, "zUnits": 1, "latestWkid": 2927, "zTolerance": 0.001, "wkid": 2927, "xyUnits": 2048, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "falseZ": 0 }, "globalIdField": "globalid", "description": "

Records in the subsurface database are classified into one of three categories that best characterizes the data contained within the borehole record. The classifications are:<\/SPAN><\/P>

Geotechnical: Boreholes and pits created with the intent to gain a detailed understanding of the subsurface lithology and soil or rock properties therein. These records have additional data beyond lithologic descriptions, including penetrometer resistance, shear and strength tests, and density measurements. The additional materials testing allows for a more detailed understanding of subsurface material properties.<\/SPAN><\/P>

Lithologic borings: These boreholes are drilled solely for the purpose of identifying subsurface lithology. Unlike geotechnical borings, material testing techniques were not used (or the results are not provided) for lithologic borings.<\/SPAN><\/P>

Test pits: Generally shallow excavations with either hand tools or mechanical equipment that are typically less than 20 feet in depth though may expose a greater area or \"working face\" to observe the subsurface lithology. Material testing techniques were not used on these pits, or the results are not provided.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 1000000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Geotechnical", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "borehole_type": null, "comments": null, "data_confidence": null, "elevation_ft": null, "ecyid": null, "source_db_code": null, "borehole_diameter_in": null, "document_id": null, "county_name": null, "reported_elevation": null, "source_db_id": null, "contractor_name": null, "borehole_name": null, "elevation_method": null, "location_confidence": null, "borehole_date": null, "reported_elevation_method": null, "borehole_class": "Geotechnical", "borehole_id": null, "borehole_depth_ft": null, "boring_method": null } } } ], "name": "Geotechnical", "domains": { "borehole_type": {"type": "inherited"}, "elevation_method": {"type": "inherited"}, "data_confidence": {"type": "inherited"}, "location_confidence": {"type": "inherited"}, "borehole_class": {"type": "inherited"}, "county_name": {"type": "inherited"}, "boring_method": {"type": "inherited"} }, "id": "Geotechnical" }, { "templates": [ { "name": "Lithologic boring", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "borehole_type": null, "comments": null, "data_confidence": null, "elevation_ft": null, "ecyid": null, "source_db_code": null, "borehole_diameter_in": null, "document_id": null, "county_name": null, "reported_elevation": null, "source_db_id": null, "contractor_name": null, "borehole_name": null, "elevation_method": null, "location_confidence": null, "borehole_date": null, "reported_elevation_method": null, "borehole_class": "Lithologic boring", "borehole_id": null, "borehole_depth_ft": null, "boring_method": null } } } ], "name": "Lithologic boring", "domains": { "borehole_type": {"type": "inherited"}, "elevation_method": {"type": "inherited"}, "data_confidence": {"type": "inherited"}, "location_confidence": {"type": "inherited"}, "borehole_class": {"type": "inherited"}, "county_name": {"type": "inherited"}, "boring_method": {"type": "inherited"} }, "id": "Lithologic boring" }, { "templates": [ { "name": "Test pit", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "borehole_type": null, "comments": null, "data_confidence": null, "elevation_ft": null, "ecyid": null, "source_db_code": null, "borehole_diameter_in": null, "document_id": null, "county_name": null, "reported_elevation": null, "source_db_id": null, "contractor_name": null, "borehole_name": null, "elevation_method": null, "location_confidence": null, "borehole_date": null, "reported_elevation_method": null, "borehole_class": "Test pit", "borehole_id": null, "borehole_depth_ft": null, "boring_method": null } } } ], "name": "Test pit", "domains": { "borehole_type": {"type": "inherited"}, "elevation_method": {"type": "inherited"}, "data_confidence": {"type": "inherited"}, "location_confidence": {"type": "inherited"}, "borehole_class": {"type": "inherited"}, "county_name": {"type": "inherited"}, "boring_method": {"type": "inherited"} }, "id": "Test pit" } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "borehole_class", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "field1": "borehole_class", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 69, 163, 42, 255 ], "fromColor": [ 69, 163, 42, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 133, 60, 189, 255 ], "fromColor": [ 133, 60, 189, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 196, 43, 48, 255 ], "fromColor": [ 196, 43, 48, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 44, 141, 168, 255 ], "fromColor": [ 44, 141, 168, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 196, 162, 69, 255 ], "fromColor": [ 196, 162, 69, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 161, 64, 108, 255 ], "fromColor": [ 161, 64, 108, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 73, 191, 150, 255 ], "fromColor": [ 73, 191, 150, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 77, 109, 191, 255 ], "fromColor": [ 77, 109, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 161, 95, 64, 255 ], "fromColor": [ 161, 95, 64, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 199, 68, 175, 255 ], "fromColor": [ 199, 68, 175, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 191, 201, 44, 255 ], "fromColor": [ 191, 201, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 53, 47, 153, 255 ], "fromColor": [ 53, 47, 153, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 43, 191, 194, 255 ], "fromColor": [ 43, 191, 194, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 }, "color": [ 96, 161, 61, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Geotechnical", "value": "Geotechnical" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 }, "color": [ 96, 47, 161, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Lithologic boring", "value": "Lithologic boring" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 }, "color": [ 191, 54, 50, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Test pit", "value": "Test pit" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "symbol": { "backgroundColor": null, "kerning": true, "color": [ 0, 0, 0, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": null, "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": null, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 10, "weight": "normal", "style": "normal", "family": "Arial", "decoration": "none" } }, "stackLabel": true, "stackRowLength": 24, "maxScale": 0, "allowOverrun": true, "lineConnection": "unambiguousLabels", "allowOverlapOfFeatureInterior": "avoid", "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerLinePlacementAboveAlong", "removeDuplicates": "none", "textLayout": "straight", "stackSeparators": [], "name": "Class 1", "repeatLabel": false, "minScale": 500000, "stackAlignment": "dynamic", "useCodedValues": true } ] }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 92247.91455078125, "xmin": 692235.7651367188, "ymax": 1351359.1391601562, "xmax": 2545440.177734375, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2927, "zTolerance": 0.001, "wkid": 2927, "xyUnits": 2048, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "bedrock", "relatedTableId": 2, "id": 7, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "in_situ_test_data", "relatedTableId": 4, "id": 8, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_comments", "relatedTableId": 5, "id": 9, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "hydrologic", "relatedTableId": 3, "id": 10, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_data", "relatedTableId": 6, "id": 11, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "lithology_logs", "relatedTableId": 7, "id": 12, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "document_id", "role": "esriRelRoleOrigin", "composite": false, "name": "subsurface_documents", "relatedTableId": 8, "id": 13, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Water wells", "allowTrueCurvesUpdates": false, "displayField": "borehole_name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_id", "alias": "Document ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_name", "length": 50, "alias": "Borehole Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Borehole class", "description": "Primary category for the borehole.", "type": "codedValue", "codedValues": [ { "code": "Geotechnical", "name": "Geotechnical" }, { "code": "Water well", "name": "Water well" }, { "code": "Test pit", "name": "Test pit" }, { "code": "Lithologic boring", "name": "Lithologic boring" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "borehole_class", "length": 25, "alias": "Borehole Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Borehole type_1", "description": "Purpose for which the borehole was created.", "type": "codedValue", "codedValues": [ { "code": "Exposure", "name": "Exposure" }, { "code": "Geotechnical", "name": "Geotechnical" }, { "code": "Other", "name": "Other" }, { "code": "Carbon sequestration", "name": "Carbon sequestration" }, { "code": "Cone penetrometer", "name": "Cone penetrometer" }, { "code": "Earthquake monitoring", "name": "Earthquake monitoring" }, { "code": "Mineral exploration", "name": "Mineral exploration" }, { "code": "Monitoring well", "name": "Monitoring well" }, { "code": "Oil and gas", "name": "Oil and gas" }, { "code": "Test pit", "name": "Test pit" }, { "code": "Water well", "name": "Water well" }, { "code": "Boring / probe", "name": "Boring / probe" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "borehole_type", "length": 50, "alias": "Borehole Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_depth_ft", "alias": "Borehole Depth (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_diameter_in", "alias": "Borehole Diameter (in)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "borehole_date", "length": 29, "alias": "Borehole Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation_ft", "alias": "Elevation (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Elevation Method", "description": "How the surface elevation values for the boreholes were determined.", "type": "codedValue", "codedValues": [ { "code": "Altimeter", "name": "Altimeter" }, { "code": "DEM", "name": "DEM" }, { "code": "GPS", "name": "GPS" }, { "code": "LiDAR", "name": "LiDAR" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Estimated from Topo", "name": "Estimated from topo" }, { "code": "Land Survey", "name": "Land survey" }, { "code": "Report Text", "name": "Report text" }, { "code": "Site Plan", "name": "Site plan" }, { "code": "Well Log", "name": "Well log" }, { "code": "Not Applicable", "name": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "elevation_method", "length": 50, "alias": "Elevation Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_name", "length": 100, "alias": "Contractor Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Boring method_1", "description": "Technique used to construct the borehole.", "type": "codedValue", "codedValues": [ { "code": "Coring", "name": "Coring" }, { "code": "Odex", "name": "Odex" }, { "code": "Unknown", "name": "Unknown" }, { "code": "Shallow pit", "name": "Shallow pit dug by hand or mechanical means" }, { "code": "Air rotary", "name": "Air rotary" }, { "code": "Becker hammer", "name": "Becker hammer" }, { "code": "Cable tool", "name": "Cable tool" }, { "code": "Direct push", "name": "Direct push" }, { "code": "Hand auger", "name": "Hand auger" }, { "code": "Hollow stem auger", "name": "Hollow stem auger" }, { "code": "Mud rotary", "name": "Mud rotary" }, { "code": "Sonic core", "name": "Sonic core" }, { "code": "Vactor truck", "name": "Vactor truck" }, { "code": "Wash boring", "name": "Wash boring" }, { "code": "Not applicable", "name": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "boring_method", "length": 50, "alias": "Boring Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Location Confidence", "description": "Accuracy of the point location for the borehole.", "type": "codedValue", "codedValues": [ { "code": "Survey", "name": "Surveyed" }, { "code": "High", "name": "Less than 20 feet" }, { "code": "Medium", "name": "Between 20 and 100 feet" }, { "code": "Low", "name": "Greater than 100 feet" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "location_confidence", "length": 50, "alias": "Location Confidence", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Data Confidence", "description": "Usefuleness of the information on the well log.", "type": "codedValue", "codedValues": [ { "code": "High", "name": "High" }, { "code": "Medium", "name": "Medium" }, { "code": "Low", "name": "Low" }, { "code": "Not applicable", "name": "Not applicable" }, { "code": "Medium high", "name": "Medium high" }, { "code": "Medium low", "name": "Medium low" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "data_confidence", "length": 20, "alias": "Data Confidence", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "County name", "description": "County in which the borehole was drilled", "type": "codedValue", "codedValues": [ { "code": "Adams", "name": "Adams" }, { "code": "Asotin", "name": "Asotin" }, { "code": "Benton", "name": "Benton" }, { "code": "Chelan", "name": "Chelan" }, { "code": "Clallam", "name": "Clallam" }, { "code": "Clark", "name": "Clark" }, { "code": "Columbia", "name": "Columbia" }, { "code": "Cowlitz", "name": "Cowlitz" }, { "code": "Douglas", "name": "Douglas" }, { "code": "Ferry", "name": "Ferry" }, { "code": "Franklin", "name": "Franklin" }, { "code": "Garfield", "name": "Garfield" }, { "code": "Grant", "name": "Grant" }, { "code": "Grays Harbor", "name": "Grays Harbor" }, { "code": "Island", "name": "Island" }, { "code": "Jefferson", "name": "Jefferson" }, { "code": "King", "name": "King" }, { "code": "Kitsap", "name": "Kitsap" }, { "code": "Kittitas", "name": "Kittitas" }, { "code": "Klickitat", "name": "Klickitat" }, { "code": "Lewis", "name": "Lewis" }, { "code": "Lincoln", "name": "Lincoln" }, { "code": "Mason", "name": "Mason" }, { "code": "Okanogan", "name": "Okanogan" }, { "code": "Pacific", "name": "Pacific" }, { "code": "Pend Oreille", "name": "Pend Oreille" }, { "code": "Pierce", "name": "Pierce" }, { "code": "San Juan", "name": "San Juan" }, { "code": "Skagit", "name": "Skagit" }, { "code": "Skamania", "name": "Skamania" }, { "code": "Snohomish", "name": "Snohomish" }, { "code": "Spokane", "name": "Spokane" }, { "code": "Stevens", "name": "Stevens" }, { "code": "Thurston", "name": "Thurston" }, { "code": "Wahkiakum", "name": "Wahkiakum" }, { "code": "Walla Walla", "name": "Walla Walla" }, { "code": "Whatcom", "name": "Whatcom" }, { "code": "Whitman", "name": "Whitman" }, { "code": "Yakima", "name": "Yakima" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "county_name", "length": 20, "alias": "County Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ecyid", "alias": "ECY ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reported_elevation", "alias": "Reported Elevation", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reported_elevation_method", "length": 50, "alias": "Reported Elevation Method", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.003280833333333333, "mUnits": 1, "zUnits": 1, "latestWkid": 2927, "zTolerance": 0.001, "wkid": 2927, "xyUnits": 2048, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "falseZ": 0 }, "globalIdField": "globalid", "description": "

Water wells have been compiled from various sources, mostly from the Washington Department of Ecology. The selection of wells shown in this dataset have been used in published geologic research by the Washington Geological Survey and were determined to be of high quality. The locations of these wells may have been refined from their original source. For the complete database, visit the Department of Ecology\u2019s website.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 1000000, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fc240cdfaef940ce85377d49802894d6", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Water well", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "borehole_type": null, "comments": null, "data_confidence": null, "elevation_ft": null, "ecyid": null, "borehole_diameter_in": null, "document_id": null, "county_name": null, "reported_elevation": null, "contractor_name": null, "borehole_name": null, "elevation_method": null, "location_confidence": null, "borehole_date": null, "reported_elevation_method": null, "borehole_class": "Water well", "borehole_id": null, "borehole_depth_ft": null, "boring_method": null } } } ], "name": "Water well", "domains": { "borehole_type": {"type": "inherited"}, "elevation_method": {"type": "inherited"}, "data_confidence": {"type": "inherited"}, "location_confidence": {"type": "inherited"}, "borehole_class": {"type": "inherited"}, "county_name": {"type": "inherited"}, "boring_method": {"type": "inherited"} }, "id": "Water well" } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": false, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "borehole_class", "modelName": "GP_102529278", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "field1": "borehole_class", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 69, 163, 42, 255 ], "fromColor": [ 69, 163, 42, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 133, 60, 189, 255 ], "fromColor": [ 133, 60, 189, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 196, 43, 48, 255 ], "fromColor": [ 196, 43, 48, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 44, 141, 168, 255 ], "fromColor": [ 44, 141, 168, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 196, 162, 69, 255 ], "fromColor": [ 196, 162, 69, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 161, 64, 108, 255 ], "fromColor": [ 161, 64, 108, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 73, 191, 150, 255 ], "fromColor": [ 73, 191, 150, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 77, 109, 191, 255 ], "fromColor": [ 77, 109, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 161, 95, 64, 255 ], "fromColor": [ 161, 95, 64, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 199, 68, 175, 255 ], "fromColor": [ 199, 68, 175, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 191, 201, 44, 255 ], "fromColor": [ 191, 201, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 53, 47, 153, 255 ], "fromColor": [ 53, 47, 153, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 43, 191, 194, 255 ], "fromColor": [ 43, 191, 194, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 }, "color": [ 0, 132, 168, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Water well", "value": "Water well" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "symbol": { "backgroundColor": null, "kerning": true, "color": [ 0, 0, 0, 255 ], "yoffset": 0, "xoffset": 0, "haloColor": null, "type": "esriTS", "borderLineColor": null, "borderLineSize": null, "horizontalAlignment": "left", "haloSize": null, "angle": 0, "rightToLeft": false, "verticalAlignment": "bottom", "font": { "size": 10, "weight": "normal", "style": "normal", "family": "Arial", "decoration": "none" } }, "stackLabel": true, "stackRowLength": 24, "maxScale": 0, "allowOverrun": true, "lineConnection": "unambiguousLabels", "allowOverlapOfFeatureInterior": "avoid", "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerLinePlacementAboveAlong", "removeDuplicates": "none", "textLayout": "straight", "stackSeparators": [], "name": "Class 1", "repeatLabel": false, "minScale": 500000, "stackAlignment": "dynamic", "useCodedValues": true } ] }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }