{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1786038808227}, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "survey_sample_information", "relatedTableId": 0, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 7, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "timeInfo": null, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "sample_information", "displayField": null, "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_188", "alias": "Sample Number", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "sample_depth_ft", "length": 256, "alias": "Sample Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_sample_type", "type": "codedValue", "codedValues": [ { "code": "Standard Penetration Test (SPT)", "name": "Standard Penetration Test (SPT)" }, { "code": "Shelby Tube", "name": "Shelby Tube" }, { "code": "Grab Sample", "name": "Grab Sample" }, { "code": "Rock Core", "name": "Rock Core" }, { "code": "Bulk Sample", "name": "Bulk Sample" }, { "code": "CPT Sample", "name": "CPT Sample" }, { "code": "Other", "name": "Other" } ] }, "name": "sample_type", "length": 255, "alias": "Sample Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_190", "length": 256, "alias": "Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "recovery_length_ft", "length": 256, "alias": "Recovery Length (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_storage_container", "type": "codedValue", "codedValues": [ { "code": "Plastic Bag", "name": "Plastic Bag" }, { "code": "Sample Jar", "name": "Sample Jar" }, { "code": "Shelby Tube", "name": "Shelby Tube" }, { "code": "Core Box", "name": "Core Box" }, { "code": "Bulk Container", "name": "Bulk Container" }, { "code": "Other", "name": "Other" } ] }, "name": "storage_container", "length": 255, "alias": "Storage / Container", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_193", "length": 256, "alias": "Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_remarks", "length": 1000, "alias": "Field Remarks", "type": "esriFieldTypeString" }, { "nullable": true, "defaultValue": null, "editable": true, "domain": null, "length": 38, "name": "parentglobalid", "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "r31644_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_31644", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "17bb0a78d1f6421dafb74c66e810cf06", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1786038866194}, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "survey_spt_data", "relatedTableId": 0, "id": 7, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 8, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "timeInfo": null, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "spt_data", "displayField": null, "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "spt_test_number", "length": 256, "alias": "SPT Test Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "test_depth_ft", "length": 256, "alias": "Test Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "drive_increment", "length": 256, "alias": "Drive Increment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_199", "alias": "SPT N-Value", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_sampler_type", "type": "codedValue", "codedValues": [ { "code": "Standard Split Spoon", "name": "Standard Split Spoon" }, { "code": "Modified Split Spoon", "name": "Modified Split Spoon" }, { "code": "Shelby Tube", "name": "Shelby Tube" }, { "code": "Other", "name": "Other" } ] }, "name": "sampler_type", "length": 255, "alias": "Sampler Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_201", "length": 256, "alias": "Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_hammer_type", "type": "codedValue", "codedValues": [ { "code": "Automatic Hammer", "name": "Automatic Hammer" }, { "code": "Safety Hammer", "name": "Safety Hammer" }, { "code": "Donut Hammer", "name": "Donut Hammer" }, { "code": "Trip Hammer", "name": "Trip Hammer" } ] }, "name": "hammer_type", "length": 255, "alias": "Hammer Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hammer_efficiency", "length": 256, "alias": "Hammer Efficiency (%)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_refusal_encountered", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "refusal_encountered", "length": 255, "alias": "Refusal Encountered?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "refusal_notes", "length": 1000, "alias": "Refusal Notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "recovery_length_in", "length": 256, "alias": "Recovery Length (in)", "type": "esriFieldTypeString" }, { "nullable": true, "defaultValue": null, "editable": true, "domain": null, "length": 38, "name": "parentglobalid", "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "r31646_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_31646", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "17bb0a78d1f6421dafb74c66e810cf06", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1786038928477}, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "survey_rock_core_data", "relatedTableId": 0, "id": 8, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "rock_core_data_groundwater_information", "relatedTableId": 10, "id": 9, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 9, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "timeInfo": null, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "rock_core_data", "displayField": null, "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "core_run_number", "length": 256, "alias": "Core Run Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "core_to_depth_ft", "length": 256, "alias": "Core To Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "core_recovery", "length": 256, "alias": "Core Recovery (%)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "rock_quality_designation", "length": 256, "alias": "Rock Quality Designation (%)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_field_214", "type": "codedValue", "codedValues": [ { "code": "Basalt", "name": "Basalt" }, { "code": "Andesite", "name": "Andesite" }, { "code": "Granite", "name": "Granite" }, { "code": "Diorite", "name": "Diorite" }, { "code": "Sandstone", "name": "Sandstone" }, { "code": "Siltstone", "name": "Siltstone" }, { "code": "Shale", "name": "Shale" }, { "code": "Gneiss", "name": "Gneiss" }, { "code": "Schist", "name": "Schist" }, { "code": "Other", "name": "Other" } ] }, "name": "field_214", "length": 255, "alias": "Rock Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_215", "length": 256, "alias": "Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_fracture_spacing", "type": "codedValue", "codedValues": [ { "code": "Very Close (<2 in)", "name": "Very Close (<2 in)" }, { "code": "Close (2-8 in)", "name": "Close (2-8 in)" }, { "code": "Moderate (8-24 in)", "name": "Moderate (8-24 in)" }, { "code": "Wide (2-6 ft)", "name": "Wide (2-6 ft)" }, { "code": "Very Wide (>6 ft)", "name": "Very Wide (>6 ft)" } ] }, "name": "fracture_spacing", "length": 255, "alias": "Fracture Spacing", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_field_217", "type": "codedValue", "codedValues": [ { "code": "Fresh", "name": "Fresh" }, { "code": "Slightly Weathered", "name": "Slightly Weathered" }, { "code": "Moderately Weathered", "name": "Moderately Weathered" }, { "code": "Highly Weathered", "name": "Highly Weathered" }, { "code": "Completely Weathered", "name": "Completely Weathered" } ] }, "name": "field_217", "length": 255, "alias": "Weathering", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_rock_strength", "type": "codedValue", "codedValues": [ { "code": "Very Weak", "name": "Very Weak" }, { "code": "Weak", "name": "Weak" }, { "code": "Moderate", "name": "Moderate" }, { "code": "Strong", "name": "Strong" }, { "code": "Very Strong", "name": "Very Strong" }, { "code": "Extremely Strong", "name": "Extremely Strong" } ] }, "name": "rock_strength", "length": 255, "alias": "Rock Strength", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_discontinuities", "type": "codedValue", "codedValues": [ { "code": "Joint", "name": "Joint" }, { "code": "Fault", "name": "Fault" }, { "code": "Shear Zone", "name": "Shear Zone" }, { "code": "Bedding Plane", "name": "Bedding Plane" }, { "code": "Fracture", "name": "Fracture" }, { "code": "Contact", "name": "Contact" }, { "code": "None", "name": "None" } ] }, "name": "discontinuities", "length": 255, "alias": "Discontinuities", "type": "esriFieldTypeString" }, { "nullable": true, "defaultValue": null, "editable": true, "domain": null, "length": 38, "name": "parentglobalid", "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "r31648_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_31648", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "17bb0a78d1f6421dafb74c66e810cf06", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1786038954361}, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "rock_core_data_groundwater_information", "relatedTableId": 9, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "groundwater_information_field_test_results", "relatedTableId": 11, "id": 10, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 10, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "timeInfo": null, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "groundwater_information", "displayField": null, "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_observation_type", "type": "codedValue", "codedValues": [ { "code": "During Drilling", "name": "During Drilling" }, { "code": "End of Boring", "name": "End of Boring" }, { "code": "Stabilized Reading", "name": "Stabilized Reading" }, { "code": "24-Hour Reading", "name": "24-Hour Reading" }, { "code": "Other", "name": "Other" } ] }, "name": "observation_type", "length": 255, "alias": "Observation Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_221", "length": 256, "alias": "Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_depth_while_drilling_ft", "length": 256, "alias": "Water Depth While Drilling (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_depth_at_completion_ft", "length": 256, "alias": "Water Depth at Completion (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_level_depth_ft", "length": 256, "alias": "Water Level Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "stabilized_water_depth", "length": 256, "alias": "Stabilized Water Depth", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "measurement_datetime", "length": 29, "alias": "Measurement Date/Time", "type": "esriFieldTypeDate" }, { "nullable": true, "defaultValue": null, "editable": true, "domain": null, "length": 38, "name": "parentglobalid", "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "r31677_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_31677", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "17bb0a78d1f6421dafb74c66e810cf06", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1786038954361}, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "groundwater_information_field_test_results", "relatedTableId": 10, "id": 10, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 11, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "timeInfo": null, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "field_test_results", "displayField": null, "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_field_229", "type": "codedValue", "codedValues": [ { "code": "Pocket Penetrometer", "name": "Pocket Penetrometer" }, { "code": "Hand Shear Vane", "name": "Hand Shear Vane" }, { "code": "Dynamic Cone", "name": "Dynamic Cone" }, { "code": "CPT Reading", "name": "CPT Reading" }, { "code": "Permeability Test", "name": "Permeability Test" }, { "code": "Lugeon Test", "name": "Lugeon Test" }, { "code": "Pressuremeter Test", "name": "Pressuremeter Test" } ] }, "name": "field_229", "length": 255, "alias": "Test Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_230", "length": 256, "alias": "Test Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "field_231", "length": 29, "alias": "Test Date", "type": "esriFieldTypeDate" }, { "nullable": true, "defaultValue": null, "editable": true, "domain": null, "length": 38, "name": "parentglobalid", "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "r31679_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_31679", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "17bb0a78d1f6421dafb74c66e810cf06", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [ { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Feature Layer", "hasStaticData": false, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1786038743439}, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "survey_sample_information", "relatedTableId": 7, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "survey_spt_data", "relatedTableId": 8, "id": 7, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "survey_rock_core_data", "relatedTableId": 9, "id": 8, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 0, "spatialReference": {"wkid": 4326}, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "timeInfo": null, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "survey", "displayField": null, "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "ObjectID" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "project_id", "length": 256, "alias": "Project_ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "organization", "length": 256, "alias": "Organization", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "collector_name", "length": 256, "alias": "Collector Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "collection_date", "length": 29, "alias": "Collection Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "stage_number", "alias": "Stage Number", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_28", "length": 256, "alias": "Start Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_29", "length": 256, "alias": "End Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "stage_length_ft", "length": 256, "alias": "Stage Length (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_31", "length": 256, "alias": "Stage ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_20", "length": 256, "alias": "Hole ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_21", "length": 256, "alias": "Stage ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "test_id", "length": 256, "alias": "Test ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "test_date", "length": 29, "alias": "Test Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_23", "length": 256, "alias": "Test Pressure (psi)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_take_gpm", "length": 256, "alias": "Water Take (gpm)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "test_duration_minutes", "length": 256, "alias": "Test Duration (minutes)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lugeon_value", "length": 256, "alias": "Lugeon Value", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_32", "length": 256, "alias": "Hole ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_33", "length": 256, "alias": "Stage ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "grout_volume_gal", "length": 256, "alias": "Grout Volume (gal)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "injection_pressure_psi", "length": 256, "alias": "Injection Pressure (psi)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "pump_rate_gpm", "length": 256, "alias": "Pump Rate (GPM)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "grout_start_time", "length": 29, "alias": "Grout Start Time", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "grout_end_time", "length": 29, "alias": "Grout End Time", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_stage_status", "type": "codedValue", "codedValues": [ { "code": "Not Started", "name": "Not Started" }, { "code": "In Progress", "name": "In Progress" }, { "code": "Complete", "name": "Complete" }, { "code": "Regrouted", "name": "Regrouted" } ] }, "name": "stage_status", "length": 255, "alias": "Stage Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_issue_type", "type": "codedValue", "codedValues": [ { "code": "Cross Hole Communication", "name": "Cross Hole Communication" }, { "code": "Leaky Packer", "name": "Leaky Packer" }, { "code": "Lost Tooling", "name": "Lost Tooling" }, { "code": "Verification Hole Failure", "name": "Verification Hole Failure" }, { "code": "Excess Grout Take", "name": "Excess Grout Take" }, { "code": "Unexpected Water Loss", "name": "Unexpected Water Loss" }, { "code": "Choice 7", "name": "Choice 7" } ] }, "name": "issue_type", "length": 255, "alias": "Issue Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "issue_description", "length": 256, "alias": "Issue Description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "corrective_action", "length": 256, "alias": "Corrective Action", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_issue_status", "type": "codedValue", "codedValues": [ { "code": "Open", "name": "Open" }, { "code": "Under Review", "name": "Under Review" }, { "code": "Resolved", "name": "Resolved" } ] }, "name": "issue_status", "length": 255, "alias": "Issue Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "verification_hole_id", "length": 256, "alias": "Verification Hole ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "related_hole_id", "length": 256, "alias": "Related Hole ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "field_46", "length": 256, "alias": "Lugeon Value", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_verification_status", "type": "codedValue", "codedValues": [ { "code": "Pass", "name": "Pass" }, { "code": "Fail", "name": "Fail" }, { "code": "Pending Review", "name": "Pending Review" } ] }, "name": "verification_status", "length": 255, "alias": "Verification Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "reviewed_by", "length": 256, "alias": "Reviewed By", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "review_date", "length": 256, "alias": "Review Date", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "pile_id", "length": 256, "alias": "Pile ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_pile_installation_status", "type": "codedValue", "codedValues": [ { "code": "Planned", "name": "Planned" }, { "code": "Drilled", "name": "Drilled" }, { "code": "Steel Installed", "name": "Steel Installed" }, { "code": "Concrete Placed", "name": "Concrete Placed" }, { "code": "Completed", "name": "Completed" } ] }, "name": "pile_installation_status", "length": 255, "alias": "Pile Installation Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "installation_date", "length": 29, "alias": "Installation Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "pile_collar_elevation_ft", "length": 256, "alias": "Pile Collar Elevation (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "borehole_diameter_in", "length": 256, "alias": "Borehole Diameter (in)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "borehole_depth_ft", "length": 256, "alias": "Borehole Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_field_66", "type": "codedValue", "codedValues": [ { "code": "Pipe Pile", "name": "Pipe Pile" }, { "code": "H-Pile", "name": "H-Pile" }, { "code": "Drilled Pile", "name": "Drilled Pile" } ] }, "name": "field_66", "length": 255, "alias": "Steel Pile Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "steel_pile_length_ft", "length": 256, "alias": "Steel Pile Length (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "concrete_backfill_volume", "length": 256, "alias": "Concrete Backfill Volume", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "borehole_id", "length": 256, "alias": "Borehole ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "project_name", "length": 256, "alias": "Project Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "ground_elevation_ft", "length": 256, "alias": "Ground Elevation (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_hole_type", "type": "codedValue", "codedValues": [ { "code": "Soil boring", "name": "Soil boring" }, { "code": "Rock core", "name": "Rock core" }, { "code": "CPT", "name": "CPT" }, { "code": "Test pit", "name": "Test pit" }, { "code": "Monitoring well", "name": "Monitoring well" } ] }, "name": "hole_type", "length": 255, "alias": "Hole Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "start_date", "length": 29, "alias": "Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "completion_date", "length": 29, "alias": "Completion Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "final_depth_ft", "length": 256, "alias": "Final Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "drilling_contractor", "length": 256, "alias": "Drilling Contractor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "rig_number", "length": 256, "alias": "Rig Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_drilling_method", "type": "codedValue", "codedValues": [ { "code": "Hollow Stem Auger", "name": "Hollow Stem Auger" }, { "code": "Mud Rotary", "name": "Mud Rotary" }, { "code": "Sonic", "name": "Sonic" }, { "code": "Air Rotary", "name": "Air Rotary" }, { "code": "Wash Boring", "name": "Wash Boring" }, { "code": "Core Drilling", "name": "Core Drilling" } ] }, "name": "drilling_method", "length": 255, "alias": "Drilling Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "bit_type", "length": 256, "alias": "Bit Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "borehole_diameter", "length": 256, "alias": "Borehole Diameter", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "casing_depth", "length": 256, "alias": "Casing Depth", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "drilling_fluid", "length": 256, "alias": "Drilling Fluid", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "refusal_depth", "length": 256, "alias": "Refusal Depth", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "obstructions_encountered", "length": 1000, "alias": "Obstructions Encountered", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "top_depth_ft", "length": 256, "alias": "Top Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "bottom_depth_ft", "length": 256, "alias": "Bottom Depth (ft)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "material_description", "length": 256, "alias": "Material Description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_uscs_classification", "type": "codedValue", "codedValues": [ { "code": "GW - Well-Graded Gravel", "name": "GW - Well-Graded Gravel" }, { "code": "GP - Poorly Graded Gravel", "name": "GP - Poorly Graded Gravel" }, { "code": "GM - Silty Gravel", "name": "GM - Silty Gravel" }, { "code": "SW - Well-Graded Sand", "name": "SW - Well-Graded Sand" }, { "code": "SP - Poorly Graded Sand", "name": "SP - Poorly Graded Sand" }, { "code": "SM - Silty Sand", "name": "SM - Silty Sand" }, { "code": "SC - Clayey Sand", "name": "SC - Clayey Sand" }, { "code": "ML - Low Plasticity Silt", "name": "ML - Low Plasticity Silt" }, { "code": "MH - High Plasticity Silt", "name": "MH - High Plasticity Silt" }, { "code": "CL - Lean Clay", "name": "CL - Lean Clay" }, { "code": "CH - Fat Clay", "name": "CH - Fat Clay" }, { "code": "OL - Organic Silt/Clay (Low Pla", "name": "OL - Organic Silt/Clay (Low Plasticity)" }, { "code": "OH - Organic Silt/Clay (High Pl", "name": "OH - Organic Silt/Clay (High Plasticity)" }, { "code": "PT - Peat", "name": "PT - Peat" } ] }, "name": "uscs_classification", "length": 255, "alias": "USCS Classification", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_colour", "type": "codedValue", "codedValues": [ { "code": "Brown", "name": "Brown" }, { "code": "Dark Brown", "name": "Dark Brown" }, { "code": "Gray", "name": "Gray" }, { "code": "Dark Gray", "name": "Dark Gray" }, { "code": "Black", "name": "Black" }, { "code": "Red", "name": "Red" }, { "code": "Orange", "name": "Orange" }, { "code": "Yellow", "name": "Yellow" }, { "code": "Green", "name": "Green" }, { "code": "White", "name": "White" }, { "code": "Other", "name": "Other" } ] }, "name": "colour", "length": 255, "alias": "Colour", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "other", "length": 256, "alias": "Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_moisture_condition", "type": "codedValue", "codedValues": [ { "code": "Dry", "name": "Dry" }, { "code": "Moist", "name": "Moist" }, { "code": "Wet", "name": "Wet" }, { "code": "Saturated", "name": "Saturated" } ] }, "name": "moisture_condition", "length": 255, "alias": "Moisture Condition", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_density_granular_soils", "type": "codedValue", "codedValues": [ { "code": "Very Loose", "name": "Very Loose" }, { "code": "Loose", "name": "Loose" }, { "code": "Medium Dense", "name": "Medium Dense" }, { "code": "Dense", "name": "Dense" }, { "code": "Very Dense", "name": "Very Dense" } ] }, "name": "density_granular_soils", "length": 255, "alias": "Density (Granular Soils)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_consistency_fine_grained_soils", "type": "codedValue", "codedValues": [ { "code": "Very Soft", "name": "Very Soft" }, { "code": "Soft", "name": "Soft" }, { "code": "Firm", "name": "Firm" }, { "code": "Stiff", "name": "Stiff" }, { "code": "Very Stiff", "name": "Very Stiff" }, { "code": "Hard", "name": "Hard" } ] }, "name": "consistency_fine_grained_soils", "length": 255, "alias": "Consistency (Fine-Grained Soils)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_grain_size", "type": "codedValue", "codedValues": [ { "code": "Clay", "name": "Clay" }, { "code": "Silt", "name": "Silt" }, { "code": "Sand", "name": "Sand" }, { "code": "Gravel", "name": "Gravel" }, { "code": "Cobble", "name": "Cobble" }, { "code": "Boulder", "name": "Boulder" }, { "code": "Mixed", "name": "Mixed" } ] }, "name": "grain_size", "length": 255, "alias": "Grain Size", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_gravel_content", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Trace", "name": "Trace" }, { "code": "Little", "name": "Little" }, { "code": "Some", "name": "Some" }, { "code": "And Gravel", "name": "And Gravel" }, { "code": "Gravelly", "name": "Gravelly" }, { "code": "Very Gravelly", "name": "Very Gravelly" } ] }, "name": "gravel_content", "length": 255, "alias": "Gravel Content", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_organics", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Trace", "name": "Trace" }, { "code": "Present", "name": "Present" }, { "code": "Abundant", "name": "Abundant" } ] }, "name": "organics", "length": 255, "alias": "Organics", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_cementation", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Weak", "name": "Weak" }, { "code": "Moderate", "name": "Moderate" }, { "code": "Strong", "name": "Strong" } ] }, "name": "cementation", "length": 255, "alias": "Cementation", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_weathering", "type": "codedValue", "codedValues": [ { "code": "Fresh", "name": "Fresh" }, { "code": "Slightly Weathered", "name": "Slightly Weathered" }, { "code": "Moderately Weathered", "name": "Moderately Weathered" }, { "code": "Highly Weathered", "name": "Highly Weathered" }, { "code": "Completely Weathered", "name": "Completely Weathered" } ] }, "name": "weathering", "length": 255, "alias": "Weathering", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_relative_density_sand", "type": "codedValue", "codedValues": [ { "code": "Very Loose", "name": "Very Loose" }, { "code": "Loose", "name": "Loose" }, { "code": "Medium Dense", "name": "Medium Dense" }, { "code": "Dense", "name": "Dense" }, { "code": "Very Dense", "name": "Very Dense" } ] }, "name": "relative_density_sand", "length": 255, "alias": "Relative Density (Sand)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "survey123_0a0b6ece686b4e5c97a13cafc67f777b_cvd_consistency_clay", "type": "codedValue", "codedValues": [ { "code": "Very Soft", "name": "Very Soft" }, { "code": "Soft", "name": "Soft" }, { "code": "Firm", "name": "Firm" }, { "code": "Stiff", "name": "Stiff" }, { "code": "Very Stiff", "name": "Very Stiff" }, { "code": "Hard", "name": "Hard" } ] }, "name": "consistency_clay", "length": 255, "alias": "Consistency (Clay)", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]]", "wkid": 4326 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "a27145_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r31599_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_31599", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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 }, "serviceItemId": "17bb0a78d1f6421dafb74c66e810cf06", "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Survey Point", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }