{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Boreholes (WA DNR)", "type": "Feature Layer", "description": "These data contain point locations of boreholes in Washington State along with detailed attribution conerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 2, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "2373bb42f076fa08622c9839ff4bdecc", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAXElEQVQokWNhIBOwUKxRWVnZiZOTUwCf4i9fvpx78ODBAxSN8fHx5V5eXm74NLa1tWU/ePBgGnWcSipgIVnHSNT4+PHj1/v27buET/Hfv3/fYmicPXt2DFk2kgoAhQQc1RRf/YMAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 687727.7324586362, "ymin": 92247.91470523179, "xmax": 2545440.177787468, "ymax": 1351359.1392598897, "spatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.002, "falseX": -117498300, "falseY": -98850300, "xyUnits": 3.780131583918991E7, "falseZ": -200000, "zUnits": 8192, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Borehole_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Borehole_Name", "type": "esriFieldTypeString", "alias": "Borehole Name", "length": 50, "domain": null }, { "name": "Borehole_Type", "type": "esriFieldTypeString", "alias": "Borehole Type", "length": 50, "domain": null }, { "name": "Borehole_Depth", "type": "esriFieldTypeDouble", "alias": "Borehole Depth (ft)", "domain": null }, { "name": "Borehole_Diameter", "type": "esriFieldTypeSingle", "alias": "Borehole Diameter (inches)", "domain": null }, { "name": "Borehole_Date", "type": "esriFieldTypeDate", "alias": "Borehole Date", "length": 8, "domain": null }, { "name": "Elevation", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "Elevation_Method", "type": "esriFieldTypeString", "alias": "Elevation Method", "length": 50, "domain": null }, { "name": "Contractor_Name", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 100, "domain": null }, { "name": "Boring_Method", "type": "esriFieldTypeString", "alias": "Boring Method", "length": 50, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Location_Confidence", "type": "esriFieldTypeString", "alias": "Location Confidence", "length": 50, "domain": null }, { "name": "Data_Confidence", "type": "esriFieldTypeString", "alias": "Data Confidence", "length": 20, "domain": null }, { "name": "Source_DB_Code", "type": "esriFieldTypeSmallInteger", "alias": "Source Database Code", "domain": null }, { "name": "Source_DB_ID", "type": "esriFieldTypeString", "alias": "Source Database ID", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "County_Name", "type": "esriFieldTypeString", "alias": "County Name", "length": 20, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_SHAPE", "fields": "SHAPE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Subsurface Layers", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Borehole_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8F2F694B-F4FA-4621-A2A8-2499502BAEB7}" }, { "id": 1, "name": "Subsurface Documents", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Document_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D691E529-EEF2-491A-9B27-52BEDA8EE10A}" }, { "id": 2, "name": "Subsurface Comments", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "Borehole_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{36D105A9-B347-4A8A-B465-B33C0A66752A}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "ba5aec556efd4072894f2a94ee74f851" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Wells (WA DNR)", "type": "Feature Layer", "description": "These data contain point locations of boreholes in Washington State along with detailed attribution conerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 2, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "22641ee9da4de00100acce73f0105d34", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAMCAYAAABSgIzaAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA20lEQVQokWNhIBOwUF2jmkeA8/vHt0++vnr1CykaGSWN7Tr4ZJRAGnOI1qgdFF+qG55k8vLKOfnXl870Pjx16D5hjUJCfAp2bqnsvPwMcpaOoo+O7W19eOpQFEGN+p7hneq+ESowvoZPhM+z8ydsHx/dexinRnE9Ex0N3/BgRiYmuJiIug6vvKVj1eOjez1xapS1cGyWMbcXRXeFTliK8+NTh6MeHtq5DEMjl4i4Dzsvv8rt7WsvYfibgYGBiYk5kYGBYTUDA8NvFI3f3rzccrS3Zgs2TdgA2SkHAPawRGpDHt6sAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 687727.7324586362, "ymin": 92247.91470523179, "xmax": 2545440.177787468, "ymax": 1351359.1392598897, "spatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.002, "falseX": -117498300, "falseY": -98850300, "xyUnits": 3.780131583918991E7, "falseZ": -200000, "zUnits": 8192, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Borehole_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Borehole_Name", "type": "esriFieldTypeString", "alias": "Borehole Name", "length": 50, "domain": null }, { "name": "Borehole_Type", "type": "esriFieldTypeString", "alias": "Borehole Type", "length": 50, "domain": null }, { "name": "Borehole_Depth", "type": "esriFieldTypeDouble", "alias": "Borehole Depth (ft)", "domain": null }, { "name": "Borehole_Diameter", "type": "esriFieldTypeSingle", "alias": "Borehole Diameter (inches)", "domain": null }, { "name": "Borehole_Date", "type": "esriFieldTypeDate", "alias": "Borehole Date", "length": 8, "domain": null }, { "name": "Elevation", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "Elevation_Method", "type": "esriFieldTypeString", "alias": "Elevation Method", "length": 50, "domain": null }, { "name": "Contractor_Name", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 100, "domain": null }, { "name": "Boring_Method", "type": "esriFieldTypeString", "alias": "Boring Method", "length": 50, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Location_Confidence", "type": "esriFieldTypeString", "alias": "Location Confidence", "length": 50, "domain": null }, { "name": "Data_Confidence", "type": "esriFieldTypeString", "alias": "Data Confidence", "length": 20, "domain": null }, { "name": "Source_DB_Code", "type": "esriFieldTypeSmallInteger", "alias": "Source Database Code", "domain": null }, { "name": "Source_DB_ID", "type": "esriFieldTypeString", "alias": "Source Database ID", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "County_Name", "type": "esriFieldTypeString", "alias": "County Name", "length": 20, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_SHAPE", "fields": "SHAPE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Subsurface Layers", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Borehole_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8F2F694B-F4FA-4621-A2A8-2499502BAEB7}" }, { "id": 4, "name": "Subsurface Documents", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Document_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D691E529-EEF2-491A-9B27-52BEDA8EE10A}" }, { "id": 5, "name": "Subsurface Comments", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "Borehole_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{36D105A9-B347-4A8A-B465-B33C0A66752A}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "ba5aec556efd4072894f2a94ee74f851" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "WA DNR Comments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "COMMENTS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "COMMENT_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "Comment Number", "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth (ft)", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_16_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Boreholes", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{36D105A9-B347-4A8A-B465-B33C0A66752A}" }, { "id": 5, "name": "Boreholes", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{36D105A9-B347-4A8A-B465-B33C0A66752A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ba5aec556efd4072894f2a94ee74f851" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "WA DNR Documents", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DOCUMENT_AUTHOR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DOCUMENT_ID", "type": "esriFieldTypeInteger", "alias": "Document ID", "domain": null }, { "name": "DOCUMENT_AUTHOR", "type": "esriFieldTypeString", "alias": "Document Author", "length": 100, "domain": null }, { "name": "DOCUMENT_SOURCE", "type": "esriFieldTypeString", "alias": "Document Source", "length": 100, "domain": null }, { "name": "DOCUMENT_TYPE", "type": "esriFieldTypeString", "alias": "Document Type", "length": 20, "domain": null }, { "name": "DOCUMENT_TITLE", "type": "esriFieldTypeString", "alias": "Document Title", "length": 255, "domain": null }, { "name": "DOCUMENT_DATE", "type": "esriFieldTypeDate", "alias": "Document Date", "length": 8, "domain": null }, { "name": "PROJECT_TYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 30, "domain": null }, { "name": "PROJECT_ADDRESS", "type": "esriFieldTypeString", "alias": "Project Address", "length": 100, "domain": null }, { "name": "BOREHOLE_COUNT", "type": "esriFieldTypeSmallInteger", "alias": "Borehole Count", "domain": null }, { "name": "DOCUMENT_LINK", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17_DOCUMENT_ID", "fields": "DOCUMENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Boreholes", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D691E529-EEF2-491A-9B27-52BEDA8EE10A}" }, { "id": 4, "name": "Boreholes", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D691E529-EEF2-491A-9B27-52BEDA8EE10A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ba5aec556efd4072894f2a94ee74f851" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "WA DNR Lithology", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DESCRIPTION", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "LAYER_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "Layer Number", "domain": null }, { "name": "TOP_DEPTH", "type": "esriFieldTypeDouble", "alias": "Top Depth (ft)", "domain": null }, { "name": "BOTTOM_DEPTH", "type": "esriFieldTypeDouble", "alias": "Bottom Depth (ft)", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "length": 500, "domain": null }, { "name": "LAYER_TYPE", "type": "esriFieldTypeString", "alias": "Layer Type", "length": 10, "domain": null }, { "name": "USCS", "type": "esriFieldTypeString", "alias": "Soil Type (USCS)", "length": 20, "domain": null }, { "name": "GEOLOGIC_UNIT", "type": "esriFieldTypeString", "alias": "Geologic Unit", "length": 12, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_18_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Boreholes", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8F2F694B-F4FA-4621-A2A8-2499502BAEB7}" }, { "id": 3, "name": "Boreholes", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8F2F694B-F4FA-4621-A2A8-2499502BAEB7}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ba5aec556efd4072894f2a94ee74f851" } ] }