{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 0, "id": 7, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 18, "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, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database bedrock table", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "DEPTH_TO_BEDROCK_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth_to_bedrock_ft", "alias": "Depth to Bedrock (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "BEDROCK_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bedrock_type", "length": 30, "alias": "Bedrock Type", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2825borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r672_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_672", "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 0, "id": 11, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 19, "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, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database hydrologic data", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "DEPTH_TO_WATER_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depth_to_water_ft", "alias": "Depth to Water (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "ARTESIAN_PRESSURE_PSI", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "artesian_pressure_psi", "alias": "Artesian Pressure (psi)", "type": "esriFieldTypeDouble" }, { "modelName": "DRAWDOWN_YIELD_GPM", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawdown_yield_gpm", "alias": "Drawdown Yield (gpm)", "type": "esriFieldTypeDouble" }, { "modelName": "DRAWDOWN_DISTANCE_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawdown_distance_ft", "alias": "Drawdown Distance (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "AIRTEST_STEM_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "airtest_stem_ft", "alias": "Airtest Stem (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "DRAWDOWN_TIME_HOURS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawdown_time_hours", "alias": "Drawdown Time (hrs)", "type": "esriFieldTypeDouble" }, { "modelName": "TEST_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "test_date", "length": 29, "alias": "Test Date", "type": "esriFieldTypeDate" }, { "modelName": "WATER_TEMPERATURE_C", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "water_temperature_c", "alias": "Water Temperature (c)", "type": "esriFieldTypeDouble" }, { "modelName": "CHEMICAL_TEST_FLAG", "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" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2826borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r673_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_673", "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 0, "id": 12, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 20, "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, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database in-situ test data", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "BLOW_DEPTH_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_depth_ft", "alias": "Start Depth (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "N_NUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "n_number", "alias": "N Number", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CALIBRATED_N_FLAG", "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" }, { "modelName": "REFUSAL_FLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "count_comment", "length": 10, "alias": "Count Comment", "type": "esriFieldTypeString" }, { "modelName": "LOG_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "test_date", "length": 29, "alias": "Test Date", "type": "esriFieldTypeDate" }, { "modelName": "TEST_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "test_type", "length": 100, "alias": "Test Type", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sampler", "length": 50, "alias": "Sampler", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2827borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r674_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_674", "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 0, "id": 8, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 21, "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_number": null, "comment_depth_ft": null, "borehole_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database layer comments", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "COMMENT_NUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_number", "alias": "Comment Number", "type": "esriFieldTypeSmallInteger" }, { "modelName": "COMMENT_DEPTH_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comment_depth_ft", "alias": "Comment Depth (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 400, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2828borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r675_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_675", "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 22, "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, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database layer data", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "Object ID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "LAYER_NUMBER", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "layer_number", "alias": "Layer Number", "type": "esriFieldTypeSmallInteger" }, { "modelName": "TOP_DEPTH_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "top_depth_ft", "alias": "Top Depth (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "BOTTOM_DEPTH_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bottom_depth_ft", "alias": "Bottom Depth (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "DESCRIPTION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 500, "alias": "Description", "type": "esriFieldTypeString" }, { "modelName": "LAYER_TYPE", "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" }, { "modelName": "USCS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uscs", "length": 20, "alias": "USCS", "type": "esriFieldTypeString" }, { "modelName": "LITHOLOGY", "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" }, { "modelName": "INTERPRETED_LITHOLOGY", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "interpreted_lithology", "length": 30, "alias": "Interpreted Lithology", "type": "esriFieldTypeString" }, { "modelName": "GEOLOGIC_UNIT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geologic_unit", "length": 12, "alias": "Geologic Unit", "type": "esriFieldTypeString" }, { "modelName": "GEOLOGIC_UNIT_CONFIDENCE", "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" }, { "modelName": "GEOLOGIST", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geologist", "length": 30, "alias": "Geologist", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2829borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r676_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_676", "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 0, "id": 10, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 23, "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, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database lithology logs", "displayField": "borehole_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "URL", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "url", "length": 255, "alias": "Hyperlink", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2830borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r677_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_677", "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "document_id", "role": "esriRelRoleDestination", "composite": false, "name": "borehole_info", "relatedTableId": 1, "id": 3, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "document_id", "role": "esriRelRoleDestination", "composite": false, "name": "water_wells", "relatedTableId": 0, "id": 9, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 24, "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, "borehole_count": null, "document_date": null, "document_source": null, "document_id": null, "document_author": null, "document_type": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Subsurface database documents", "displayField": "document_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "DOCUMENT_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_id", "alias": "Document ID", "type": "esriFieldTypeInteger" }, { "modelName": "DOCUMENT_AUTHOR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_author", "length": 100, "alias": "Document Author", "type": "esriFieldTypeString" }, { "modelName": "DOCUMENT_SOURCE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_source", "length": 100, "alias": "Document Source", "type": "esriFieldTypeString" }, { "modelName": "DOCUMENT_TYPE", "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" }, { "modelName": "DOCUMENT_TITLE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_title", "length": 255, "alias": "Document Title", "type": "esriFieldTypeString" }, { "modelName": "DOCUMENT_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "document_date", "length": 29, "alias": "Document Date", "type": "esriFieldTypeDate" }, { "modelName": "PROJECT_TYPE", "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" }, { "modelName": "PROJECT_ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_address", "length": 100, "alias": "Project Address", "type": "esriFieldTypeString" }, { "modelName": "BOREHOLE_COUNT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_count", "alias": "Borehole Count", "type": "esriFieldTypeSmallInteger" }, { "modelName": "DOCUMENT_LINK", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "document_link", "length": 255, "alias": "Document Link", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "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, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "g2831document_id", "isUnique": false, "description": "", "fields": "document_id", "isAscending": true }, { "name": "r678_sde_rowid_uk", "isUnique": false, "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Sync,Extract", "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.68992498517, "xmin": 687727.7324587405, "ymax": 1345776.1468170583, "xmax": 2505476.8656539917, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2927, "zTolerance": 0.001, "wkid": 2927, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_data", "relatedTableId": 22, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "lithology_logs", "relatedTableId": 23, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "hydrologic", "relatedTableId": 19, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_comments", "relatedTableId": 21, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "bedrock", "relatedTableId": 18, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "in_situ_test_data", "relatedTableId": 20, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Borehole information", "allowTrueCurvesUpdates": false, "displayField": "borehole_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "BOREHOLE_NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_name", "length": 50, "alias": "Borehole Name", "type": "esriFieldTypeString" }, { "modelName": "BOREHOLE_CLASS", "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" }, { "modelName": "BOREHOLE_TYPE", "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" }, { "modelName": "BOREHOLE_DEPTH_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_depth_ft", "alias": "Borehole Depth (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "BOREHOLE_DIAMETER_IN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_diameter_in", "alias": "Borehole Diameter (in.)", "type": "esriFieldTypeDouble" }, { "modelName": "BOREHOLE_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "borehole_date", "length": 29, "alias": "Borehole Date", "type": "esriFieldTypeDate" }, { "modelName": "ELEVATION_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation_ft", "alias": "Elevation (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVATION_METHOD", "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" }, { "modelName": "CONTRACTOR_NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_name", "length": 100, "alias": "Contractor Name", "type": "esriFieldTypeString" }, { "modelName": "BORING_METHOD", "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" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "ECYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ecyid", "alias": "ECY ID", "type": "esriFieldTypeInteger" }, { "modelName": "REPORTED_ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reported_elevation", "alias": "Reported Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "REPORTED_ELEVATION_METHOD", "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, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "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, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "g2823borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r670_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a460_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Geotechnical", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "borehole_type": null, "comments": null, "elevation_ft": null, "ecyid": null, "borehole_diameter_in": null, "reported_elevation": null, "contractor_name": null, "borehole_name": null, "elevation_method": 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, "elevation_ft": null, "ecyid": null, "borehole_diameter_in": null, "reported_elevation": null, "contractor_name": null, "borehole_name": null, "elevation_method": 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, "elevation_ft": null, "ecyid": null, "borehole_diameter_in": null, "reported_elevation": null, "contractor_name": null, "borehole_name": null, "elevation_method": 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,Sync,Extract", "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": [ 38, 167, 173, 255 ], "fromColor": [ 38, 167, 173, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 186, 40, 191, 255 ], "fromColor": [ 186, 40, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 181, 59, 38, 255 ], "fromColor": [ 181, 59, 38, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 151, 201, 50, 255 ], "fromColor": [ 151, 201, 50, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 51, 84, 163, 255 ], "fromColor": [ 51, 84, 163, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 168, 67, 114, 255 ], "fromColor": [ 168, 67, 114, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 46, 41, 186, 255 ], "fromColor": [ 46, 41, 186, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 147, 58, 255 ], "fromColor": [ 189, 147, 58, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 59, 196, 125, 255 ], "fromColor": [ 59, 196, 125, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 48, 134, 191, 255 ], "fromColor": [ 48, 134, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 196, 43, 79, 255 ], "fromColor": [ 196, 43, 79, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 133, 68, 171, 255 ], "fromColor": [ 133, 68, 171, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 71, 153, 34, 255 ], "fromColor": [ 71, 153, 34, 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": [ { "removeDuplicates": "none", "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": false, "maxScale": 0, "name": "Class 1", "minScale": 1000000, "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "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.9147053212, "xmin": 692235.7651093304, "ymax": 1351359.1392599791, "xmax": 2545440.177787572, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2927, "zTolerance": 0.001, "wkid": 2927, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "bedrock", "relatedTableId": 18, "id": 7, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "layer_comments", "relatedTableId": 21, "id": 8, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "lithology_logs", "relatedTableId": 23, "id": 10, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "hydrologic", "relatedTableId": 19, "id": 11, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "borehole_id", "role": "esriRelRoleOrigin", "composite": false, "name": "in_situ_test_data", "relatedTableId": 20, "id": 12, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Water wells", "allowTrueCurvesUpdates": false, "displayField": "borehole_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "BOREHOLE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_id", "alias": "Borehole ID", "type": "esriFieldTypeInteger" }, { "modelName": "BOREHOLE_NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_name", "length": 50, "alias": "Borehole Name", "type": "esriFieldTypeString" }, { "modelName": "BOREHOLE_CLASS", "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" }, { "modelName": "BOREHOLE_TYPE", "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" }, { "modelName": "BOREHOLE_DEPTH_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_depth_ft", "alias": "Borehole Depth (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "BOREHOLE_DIAMETER_IN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "borehole_diameter_in", "alias": "Borehole Diameter (in)", "type": "esriFieldTypeDouble" }, { "modelName": "BOREHOLE_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "borehole_date", "length": 29, "alias": "Borehole Date", "type": "esriFieldTypeDate" }, { "modelName": "ELEVATION_FT", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevation_ft", "alias": "Elevation (ft)", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVATION_METHOD", "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" }, { "modelName": "CONTRACTOR_NAME", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractor_name", "length": 100, "alias": "Contractor Name", "type": "esriFieldTypeString" }, { "modelName": "BORING_METHOD", "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" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "ECYID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ecyid", "alias": "ECY ID", "type": "esriFieldTypeInteger" }, { "modelName": "REPORTED_ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reported_elevation", "alias": "Reported Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "REPORTED_ELEVATION_METHOD", "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, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "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, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "g2824borehole_id", "isUnique": false, "description": "", "fields": "borehole_id", "isAscending": true }, { "name": "r671_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a461_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "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": "6b15771a89704ed2a0b87df97c2807c8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Water well", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "borehole_type": null, "comments": null, "elevation_ft": null, "ecyid": null, "borehole_diameter_in": null, "reported_elevation": null, "contractor_name": null, "borehole_name": null, "elevation_method": 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,Sync,Extract", "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": [ 38, 167, 173, 255 ], "fromColor": [ 38, 167, 173, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 186, 40, 191, 255 ], "fromColor": [ 186, 40, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 181, 59, 38, 255 ], "fromColor": [ 181, 59, 38, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 151, 201, 50, 255 ], "fromColor": [ 151, 201, 50, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 51, 84, 163, 255 ], "fromColor": [ 51, 84, 163, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 168, 67, 114, 255 ], "fromColor": [ 168, 67, 114, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 46, 41, 186, 255 ], "fromColor": [ 46, 41, 186, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 189, 147, 58, 255 ], "fromColor": [ 189, 147, 58, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 59, 196, 125, 255 ], "fromColor": [ 59, 196, 125, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 48, 134, 191, 255 ], "fromColor": [ 48, 134, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 196, 43, 79, 255 ], "fromColor": [ 196, 43, 79, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 133, 68, 171, 255 ], "fromColor": [ 133, 68, 171, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 71, 153, 34, 255 ], "fromColor": [ 71, 153, 34, 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": [ { "removeDuplicates": "none", "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": false, "maxScale": 0, "name": "Class 1", "minScale": 1000000, "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "deconflictionStrategy": "dynamic", "priority": -1, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "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 } ] }