{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Borehole information", "type": "Feature Layer", "description": "Records in the subsurface database are classified into one of three categories that best characterizes the data contained within the borehole record. The classifications are:Geotechnical: Boreholes and pits created with the intent to gain a detailed understanding of the subsurface lithology and soil or rock properties therein. These records have additional data beyond lithologic descriptions, including penetrometer resistance, shear and strength tests, and density measurements. The additional materials testing allows for a more detailed understanding of subsurface material properties.Lithologic borings: These boreholes are drilled solely for the purpose of identifying subsurface lithology. Unlike geotechnical borings, material testing techniques were not used (or the results are not provided) for lithologic borings.Test pits: Generally shallow excavations with either hand tools or mechanical equipment that are typically less than 20 feet in depth though may expose a greater area or \"working face\" to observe the subsurface lithology. Material testing techniques were not used on these pits, or the results are not provided.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 2, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 2048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "BOREHOLE_CLASS", "uniqueValueGroups": [ { "heading": "Borehole class", "classes": [ { "label": "Geotechnical", "description": "Geotechnical", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 161, 61, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Geotechnical" ] ] }, { "label": "Lithologic boring", "description": "Lithologic boring", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 47, 161, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Lithologic boring" ] ] }, { "label": "Test pit", "description": "Test pit", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 191, 54, 50, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Test pit" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 161, 61, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Geotechnical", "label": "Geotechnical" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 47, 161, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Lithologic boring", "label": "Lithologic boring" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 191, 54, 50, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Test pit", "label": "Test pit" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 66, 179, 90, 255 ], "toColor": [ 66, 179, 90, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 124, 52, 168, 255 ], "toColor": [ 124, 52, 168, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 43, 41, 255 ], "toColor": [ 194, 43, 41, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 50, 149, 191, 255 ], "toColor": [ 50, 149, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 164, 43, 255 ], "toColor": [ 194, 164, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 38, 104, 255 ], "toColor": [ 173, 38, 104, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 176, 158, 255 ], "toColor": [ 56, 176, 158, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 101, 60, 255 ], "toColor": [ 158, 101, 60, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 79, 161, 255 ], "toColor": [ 56, 79, 161, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 59, 41, 194, 255 ], "toColor": [ 59, 41, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 201, 48, 255 ], "toColor": [ 158, 201, 48, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 75, 170, 255 ], "toColor": [ 189, 75, 170, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 63, 191, 40, 255 ], "toColor": [ 63, 191, 40, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "lineOrientation": "unconstrained", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "followFeature", "deconflictionStrategy": "dynamic", "allowOverrun": true, "repeatLabel": false, "lineConnection": "unambiguousLabels", "useClippedGeometry": true, "allowOverlapOfFeatureInterior": "avoid", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "stackSeparators": [], "useCodedValues": true, "maxScale": 0, "minScale": 500000, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "featureReduction": { "type": "cluster", "clusterRadius": 120, "fields": [ { "name": "cluster_count", "alias": "Point Count", "isAutoGenerated": true, "statisticType": "count" }, { "name": "MODE_BOREHOLE_CLASS", "onStatisticField": "BOREHOLE_CLASS", "alias": "Mode BOREHOLE_CLASS", "isAutoGenerated": false, "statisticType": "mode" } ], "clusterMinSize": 12, "clusterMaxSize": 70, "showLabels": true, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "MODE_BOREHOLE_CLASS", "uniqueValueGroups": [ { "heading": "Borehole class", "classes": [ { "label": "Geotechnical", "description": "Geotechnical", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 161, 61, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Geotechnical" ] ] }, { "label": "Lithologic boring", "description": "Lithologic boring", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 47, 161, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Lithologic boring" ] ] }, { "label": "Test pit", "description": "Test pit", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 191, 54, 50, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Test pit" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 161, 61, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Geotechnical", "label": "Geotechnical" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 47, 161, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Lithologic boring", "label": "Lithologic boring" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 191, 54, 50, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Test pit", "label": "Test pit" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 66, 179, 90, 255 ], "toColor": [ 66, 179, 90, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 124, 52, 168, 255 ], "toColor": [ 124, 52, 168, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 43, 41, 255 ], "toColor": [ 194, 43, 41, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 50, 149, 191, 255 ], "toColor": [ 50, 149, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 164, 43, 255 ], "toColor": [ 194, 164, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 38, 104, 255 ], "toColor": [ 173, 38, 104, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 176, 158, 255 ], "toColor": [ 56, 176, 158, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 101, 60, 255 ], "toColor": [ 158, 101, 60, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 79, 161, 255 ], "toColor": [ 56, 79, 161, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 59, 41, 194, 255 ], "toColor": [ 59, 41, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 201, 48, 255 ], "toColor": [ 158, 201, 48, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 75, 170, 255 ], "toColor": [ 189, 75, 170, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 63, 191, 40, 255 ], "toColor": [ 63, 191, 40, 255 ] } ] } } }, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.cluster_count", "title": "Custom" }, "labelPlacement": "esriServerPointLabelPlacementCenterCenter", "deconflictionStrategy": "static", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 255, 255, 255, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "middle", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 52, 52, 52, 242 ], "haloSize": 0.8, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "visibilityInfo": { "type": "scale", "maxScale": 100000 }, "popupInfo": { "popupElements": [ { "type": "fields", "fieldInfos": [ { "fieldName": "cluster_count", "label": "Point Count", "visible": true }, { "fieldName": "MODE_BOREHOLE_CLASS", "label": "Mode BOREHOLE_CLASS", "visible": true } ] } ] } }, "defaultVisibility": true, "extent": { "xmin": 687727.732421875, "ymin": 92247.91455078125, "xmax": 2545440.177734375, "ymax": 1351359.1391601562, "spatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 2048, "falseZ": -100000, "zUnits": 10000, "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": "Object ID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "DOCUMENT_ID", "type": "esriFieldTypeInteger", "alias": "Document ID", "domain": null }, { "name": "BOREHOLE_NAME", "type": "esriFieldTypeString", "alias": "Borehole Name", "length": 50, "domain": null }, { "name": "BOREHOLE_CLASS", "type": "esriFieldTypeString", "alias": "Borehole Class", "length": 25, "domain": { "type": "codedValue", "name": "Borehole class", "description": "Primary category for the borehole.", "codedValues": [ { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Water well", "code": "Water well" }, { "name": "Test pit", "code": "Test pit" }, { "name": "Lithologic boring", "code": "Lithologic boring" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BOREHOLE_TYPE", "type": "esriFieldTypeString", "alias": "Borehole Type", "length": 50, "domain": { "type": "codedValue", "name": "Borehole type_1", "description": "Purpose for which the borehole was created.", "codedValues": [ { "name": "Exposure", "code": "Exposure" }, { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Other", "code": "Other" }, { "name": "Carbon sequestration", "code": "Carbon sequestration" }, { "name": "Cone penetrometer", "code": "Cone penetrometer" }, { "name": "Earthquake monitoring", "code": "Earthquake monitoring" }, { "name": "Mineral exploration", "code": "Mineral exploration" }, { "name": "Monitoring well", "code": "Monitoring well" }, { "name": "Oil and gas", "code": "Oil and gas" }, { "name": "Test pit", "code": "Test pit" }, { "name": "Water well", "code": "Water well" }, { "name": "Boring / probe", "code": "Boring / probe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BOREHOLE_DEPTH_FT", "type": "esriFieldTypeDouble", "alias": "Borehole Depth (ft)", "domain": null }, { "name": "BOREHOLE_DIAMETER_IN", "type": "esriFieldTypeSingle", "alias": "Borehole Diameter (in)", "domain": null }, { "name": "BOREHOLE_DATE", "type": "esriFieldTypeDate", "alias": "Borehole Date", "length": 8, "domain": null }, { "name": "ELEVATION_FT", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "ELEVATION_METHOD", "type": "esriFieldTypeString", "alias": "Elevation Method", "length": 50, "domain": { "type": "codedValue", "name": "Elevation method", "description": "How the surface elevation for the borehole was determined.", "codedValues": [ { "name": "Altimeter", "code": "Altimeter" }, { "name": "DEM", "code": "DEM" }, { "name": "GPS", "code": "GPS" }, { "name": "LiDAR", "code": "LiDAR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Report text", "code": "Report text" }, { "name": "Site plan", "code": "Site plan" }, { "name": "Borehole log", "code": "Borehole log" }, { "name": "Not applicable", "code": "Not applicable" }, { "name": "Estimated from topo", "code": "Estimated from topo" }, { "name": "Land survey", "code": "Land survey" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTRACTOR_NAME", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 100, "domain": null }, { "name": "BORING_METHOD", "type": "esriFieldTypeString", "alias": "Boring Method", "length": 50, "domain": { "type": "codedValue", "name": "Boring method_1", "description": "Technique used to construct the borehole.", "codedValues": [ { "name": "Coring", "code": "Coring" }, { "name": "Odex", "code": "Odex" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Shallow pit dug by hand or mechanical means", "code": "Shallow pit" }, { "name": "Air rotary", "code": "Air rotary" }, { "name": "Becker hammer", "code": "Becker hammer" }, { "name": "Cable tool", "code": "Cable tool" }, { "name": "Direct push", "code": "Direct push" }, { "name": "Hand auger", "code": "Hand auger" }, { "name": "Hollow stem auger", "code": "Hollow stem auger" }, { "name": "Mud rotary", "code": "Mud rotary" }, { "name": "Sonic core", "code": "Sonic core" }, { "name": "Vactor truck", "code": "Vactor truck" }, { "name": "Wash boring", "code": "Wash boring" }, { "name": "Not applicable", "code": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Location Confidence", "length": 50, "domain": { "type": "codedValue", "name": "Location confidence", "description": "Accuracy of the point location for the borehole.", "codedValues": [ { "name": "Surveyed", "code": "Survey" }, { "name": "Less than 20 feet", "code": "Less than 20 feet" }, { "name": "Between 20 and 100 feet", "code": "Between 20 and 100 feet" }, { "name": "Greater than 100 feet", "code": "Greater than 100 feet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATA_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Data Confidence", "length": 20, "domain": { "type": "codedValue", "name": "Data confidence", "description": "Estimate on the quality of the the boring log's detail and lithologic accuracy", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium high", "code": "Medium high" }, { "name": "Medium", "code": "Medium" }, { "name": "Medium low", "code": "Medium low" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_NAME", "type": "esriFieldTypeString", "alias": "County Name", "length": 20, "domain": { "type": "codedValue", "name": "County name", "description": "County in which the borehole was drilled", "codedValues": [ { "name": "Adams", "code": "Adams" }, { "name": "Asotin", "code": "Asotin" }, { "name": "Benton", "code": "Benton" }, { "name": "Chelan", "code": "Chelan" }, { "name": "Clallam", "code": "Clallam" }, { "name": "Clark", "code": "Clark" }, { "name": "Columbia", "code": "Columbia" }, { "name": "Cowlitz", "code": "Cowlitz" }, { "name": "Douglas", "code": "Douglas" }, { "name": "Ferry", "code": "Ferry" }, { "name": "Franklin", "code": "Franklin" }, { "name": "Garfield", "code": "Garfield" }, { "name": "Grant", "code": "Grant" }, { "name": "Grays Harbor", "code": "Grays Harbor" }, { "name": "Island", "code": "Island" }, { "name": "Jefferson", "code": "Jefferson" }, { "name": "King", "code": "King" }, { "name": "Kitsap", "code": "Kitsap" }, { "name": "Kittitas", "code": "Kittitas" }, { "name": "Klickitat", "code": "Klickitat" }, { "name": "Lewis", "code": "Lewis" }, { "name": "Lincoln", "code": "Lincoln" }, { "name": "Mason", "code": "Mason" }, { "name": "Okanogan", "code": "Okanogan" }, { "name": "Pacific", "code": "Pacific" }, { "name": "Pend Oreille", "code": "Pend Oreille" }, { "name": "Pierce", "code": "Pierce" }, { "name": "San Juan", "code": "San Juan" }, { "name": "Skagit", "code": "Skagit" }, { "name": "Skamania", "code": "Skamania" }, { "name": "Snohomish", "code": "Snohomish" }, { "name": "Spokane", "code": "Spokane" }, { "name": "Stevens", "code": "Stevens" }, { "name": "Thurston", "code": "Thurston" }, { "name": "Wahkiakum", "code": "Wahkiakum" }, { "name": "Walla Walla", "code": "Walla Walla" }, { "name": "Whatcom", "code": "Whatcom" }, { "name": "Whitman", "code": "Whitman" }, { "name": "Yakima", "code": "Yakima" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "ECYID", "type": "esriFieldTypeInteger", "alias": "Ecology ID", "domain": null }, { "name": "REPORTED_ELEVATION", "type": "esriFieldTypeDouble", "alias": "Reported Elevation (ft)", "domain": null }, { "name": "REPORTED_ELEVATION_METHOD", "type": "esriFieldTypeString", "alias": "Reported Elevation Method", "length": 50, "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": "" }, { "name": "GDB_102_DOCUMENT_ID", "fields": "DOCUMENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_102_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "lithology_logs", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6EAC91F4-D2D1-4F4A-B860-70D574FFD768}" }, { "id": 1, "name": "bedrock", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9484C85-D169-4DF3-838E-D1983F46D445}" }, { "id": 2, "name": "layer_data", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AAE36098-5B51-4D42-8255-435BA85F81BF}" }, { "id": 3, "name": "hydrologic", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{90FE31C6-FE90-4E1D-AC79-304F30AF9C75}" }, { "id": 4, "name": "subsurface_documents", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{3AEB0249-DD02-4997-AAA0-6F7B2AD68DFD}" }, { "id": 5, "name": "in_situ_test_data", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{16E7D5FF-471D-4632-B539-E80846924B8E}" }, { "id": 6, "name": "layer_comments", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8D1BD00E-ADC4-4F67-AB8B-BC0CAEC51E85}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Water wells", "type": "Feature Layer", "description": "Water wells have been compiled from various sources, mostly from the Washington Department of Ecology. The selection of wells shown in this dataset have been used in published geologic research by the Washington Geological Survey and were determined to be of high quality. The locations of these wells may have been refined from their original source. For the complete database, visit the Department of Ecology\u2019s website.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 2, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 2048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "BOREHOLE_CLASS", "uniqueValueGroups": [ { "heading": "Borehole class", "classes": [ { "label": "Water well", "description": "Water well", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 132, 168, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Water well" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 132, 168, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Water well", "label": "Water well" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 66, 179, 90, 255 ], "toColor": [ 66, 179, 90, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 124, 52, 168, 255 ], "toColor": [ 124, 52, 168, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 43, 41, 255 ], "toColor": [ 194, 43, 41, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 50, 149, 191, 255 ], "toColor": [ 50, 149, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 164, 43, 255 ], "toColor": [ 194, 164, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 38, 104, 255 ], "toColor": [ 173, 38, 104, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 176, 158, 255 ], "toColor": [ 56, 176, 158, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 101, 60, 255 ], "toColor": [ 158, 101, 60, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 79, 161, 255 ], "toColor": [ 56, 79, 161, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 59, 41, 194, 255 ], "toColor": [ 59, 41, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 201, 48, 255 ], "toColor": [ 158, 201, 48, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 75, 170, 255 ], "toColor": [ 189, 75, 170, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 63, 191, 40, 255 ], "toColor": [ 63, 191, 40, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "lineOrientation": "unconstrained", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "followFeature", "deconflictionStrategy": "dynamic", "allowOverrun": true, "repeatLabel": false, "lineConnection": "unambiguousLabels", "useClippedGeometry": true, "allowOverlapOfFeatureInterior": "avoid", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "stackSeparators": [], "useCodedValues": true, "maxScale": 0, "minScale": 500000, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "featureReduction": { "type": "cluster", "clusterRadius": 120, "fields": [ { "name": "cluster_count", "alias": "Point Count", "isAutoGenerated": true, "statisticType": "count" }, { "name": "MODE_BOREHOLE_CLASS", "onStatisticField": "BOREHOLE_CLASS", "alias": "Mode BOREHOLE_CLASS", "isAutoGenerated": false, "statisticType": "mode" } ], "clusterMinSize": 12, "clusterMaxSize": 70, "showLabels": true, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "MODE_BOREHOLE_CLASS", "uniqueValueGroups": [ { "heading": "Borehole class", "classes": [ { "label": "Water well", "description": "Water well", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 132, 168, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Water well" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 132, 168, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Water well", "label": "Water well" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 66, 179, 90, 255 ], "toColor": [ 66, 179, 90, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 124, 52, 168, 255 ], "toColor": [ 124, 52, 168, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 43, 41, 255 ], "toColor": [ 194, 43, 41, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 50, 149, 191, 255 ], "toColor": [ 50, 149, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 164, 43, 255 ], "toColor": [ 194, 164, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 38, 104, 255 ], "toColor": [ 173, 38, 104, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 176, 158, 255 ], "toColor": [ 56, 176, 158, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 101, 60, 255 ], "toColor": [ 158, 101, 60, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 56, 79, 161, 255 ], "toColor": [ 56, 79, 161, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 59, 41, 194, 255 ], "toColor": [ 59, 41, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 201, 48, 255 ], "toColor": [ 158, 201, 48, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 75, 170, 255 ], "toColor": [ 189, 75, 170, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 63, 191, 40, 255 ], "toColor": [ 63, 191, 40, 255 ] } ] } } }, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.cluster_count", "title": "Custom" }, "labelPlacement": "esriServerPointLabelPlacementCenterCenter", "deconflictionStrategy": "static", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 255, 255, 255, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "middle", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 52, 52, 52, 242 ], "haloSize": 0.8, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "visibilityInfo": { "type": "scale", "maxScale": 100000 }, "popupInfo": { "popupElements": [ { "type": "fields", "fieldInfos": [ { "fieldName": "cluster_count", "label": "Point Count", "visible": true }, { "fieldName": "MODE_BOREHOLE_CLASS", "label": "Mode BOREHOLE_CLASS", "visible": true } ] } ] } }, "defaultVisibility": false, "extent": { "xmin": 692235.7651367188, "ymin": 92247.91455078125, "xmax": 2545440.177734375, "ymax": 1351359.1391601562, "spatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 2048, "falseZ": -100000, "zUnits": 10000, "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": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "DOCUMENT_ID", "type": "esriFieldTypeInteger", "alias": "Document ID", "domain": null }, { "name": "BOREHOLE_NAME", "type": "esriFieldTypeString", "alias": "Borehole Name", "length": 50, "domain": null }, { "name": "BOREHOLE_CLASS", "type": "esriFieldTypeString", "alias": "Borehole Class", "length": 25, "domain": { "type": "codedValue", "name": "Borehole class", "description": "Primary category for the borehole.", "codedValues": [ { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Water well", "code": "Water well" }, { "name": "Test pit", "code": "Test pit" }, { "name": "Lithologic boring", "code": "Lithologic boring" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BOREHOLE_TYPE", "type": "esriFieldTypeString", "alias": "Borehole Type", "length": 50, "domain": { "type": "codedValue", "name": "Borehole type_1", "description": "Purpose for which the borehole was created.", "codedValues": [ { "name": "Exposure", "code": "Exposure" }, { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Other", "code": "Other" }, { "name": "Carbon sequestration", "code": "Carbon sequestration" }, { "name": "Cone penetrometer", "code": "Cone penetrometer" }, { "name": "Earthquake monitoring", "code": "Earthquake monitoring" }, { "name": "Mineral exploration", "code": "Mineral exploration" }, { "name": "Monitoring well", "code": "Monitoring well" }, { "name": "Oil and gas", "code": "Oil and gas" }, { "name": "Test pit", "code": "Test pit" }, { "name": "Water well", "code": "Water well" }, { "name": "Boring / probe", "code": "Boring / probe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BOREHOLE_DEPTH_FT", "type": "esriFieldTypeDouble", "alias": "Borehole Depth (ft)", "domain": null }, { "name": "BOREHOLE_DIAMETER_IN", "type": "esriFieldTypeSingle", "alias": "Borehole Diameter (in)", "domain": null }, { "name": "BOREHOLE_DATE", "type": "esriFieldTypeDate", "alias": "Borehole Date", "length": 8, "domain": null }, { "name": "ELEVATION_FT", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "ELEVATION_METHOD", "type": "esriFieldTypeString", "alias": "Elevation Method", "length": 50, "domain": { "type": "codedValue", "name": "Elevation method", "description": "How the surface elevation for the borehole was determined.", "codedValues": [ { "name": "Altimeter", "code": "Altimeter" }, { "name": "DEM", "code": "DEM" }, { "name": "GPS", "code": "GPS" }, { "name": "LiDAR", "code": "LiDAR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Report text", "code": "Report text" }, { "name": "Site plan", "code": "Site plan" }, { "name": "Borehole log", "code": "Borehole log" }, { "name": "Not applicable", "code": "Not applicable" }, { "name": "Estimated from topo", "code": "Estimated from topo" }, { "name": "Land survey", "code": "Land survey" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTRACTOR_NAME", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 100, "domain": null }, { "name": "BORING_METHOD", "type": "esriFieldTypeString", "alias": "Boring Method", "length": 50, "domain": { "type": "codedValue", "name": "Boring method_1", "description": "Technique used to construct the borehole.", "codedValues": [ { "name": "Coring", "code": "Coring" }, { "name": "Odex", "code": "Odex" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Shallow pit dug by hand or mechanical means", "code": "Shallow pit" }, { "name": "Air rotary", "code": "Air rotary" }, { "name": "Becker hammer", "code": "Becker hammer" }, { "name": "Cable tool", "code": "Cable tool" }, { "name": "Direct push", "code": "Direct push" }, { "name": "Hand auger", "code": "Hand auger" }, { "name": "Hollow stem auger", "code": "Hollow stem auger" }, { "name": "Mud rotary", "code": "Mud rotary" }, { "name": "Sonic core", "code": "Sonic core" }, { "name": "Vactor truck", "code": "Vactor truck" }, { "name": "Wash boring", "code": "Wash boring" }, { "name": "Not applicable", "code": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Location Confidence", "length": 50, "domain": { "type": "codedValue", "name": "Location confidence", "description": "Accuracy of the point location for the borehole.", "codedValues": [ { "name": "Surveyed", "code": "Survey" }, { "name": "Less than 20 feet", "code": "Less than 20 feet" }, { "name": "Between 20 and 100 feet", "code": "Between 20 and 100 feet" }, { "name": "Greater than 100 feet", "code": "Greater than 100 feet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATA_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Data Confidence", "length": 20, "domain": { "type": "codedValue", "name": "Data confidence", "description": "Estimate on the quality of the the boring log's detail and lithologic accuracy", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium high", "code": "Medium high" }, { "name": "Medium", "code": "Medium" }, { "name": "Medium low", "code": "Medium low" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_NAME", "type": "esriFieldTypeString", "alias": "County Name", "length": 20, "domain": { "type": "codedValue", "name": "County name", "description": "County in which the borehole was drilled", "codedValues": [ { "name": "Adams", "code": "Adams" }, { "name": "Asotin", "code": "Asotin" }, { "name": "Benton", "code": "Benton" }, { "name": "Chelan", "code": "Chelan" }, { "name": "Clallam", "code": "Clallam" }, { "name": "Clark", "code": "Clark" }, { "name": "Columbia", "code": "Columbia" }, { "name": "Cowlitz", "code": "Cowlitz" }, { "name": "Douglas", "code": "Douglas" }, { "name": "Ferry", "code": "Ferry" }, { "name": "Franklin", "code": "Franklin" }, { "name": "Garfield", "code": "Garfield" }, { "name": "Grant", "code": "Grant" }, { "name": "Grays Harbor", "code": "Grays Harbor" }, { "name": "Island", "code": "Island" }, { "name": "Jefferson", "code": "Jefferson" }, { "name": "King", "code": "King" }, { "name": "Kitsap", "code": "Kitsap" }, { "name": "Kittitas", "code": "Kittitas" }, { "name": "Klickitat", "code": "Klickitat" }, { "name": "Lewis", "code": "Lewis" }, { "name": "Lincoln", "code": "Lincoln" }, { "name": "Mason", "code": "Mason" }, { "name": "Okanogan", "code": "Okanogan" }, { "name": "Pacific", "code": "Pacific" }, { "name": "Pend Oreille", "code": "Pend Oreille" }, { "name": "Pierce", "code": "Pierce" }, { "name": "San Juan", "code": "San Juan" }, { "name": "Skagit", "code": "Skagit" }, { "name": "Skamania", "code": "Skamania" }, { "name": "Snohomish", "code": "Snohomish" }, { "name": "Spokane", "code": "Spokane" }, { "name": "Stevens", "code": "Stevens" }, { "name": "Thurston", "code": "Thurston" }, { "name": "Wahkiakum", "code": "Wahkiakum" }, { "name": "Walla Walla", "code": "Walla Walla" }, { "name": "Whatcom", "code": "Whatcom" }, { "name": "Whitman", "code": "Whitman" }, { "name": "Yakima", "code": "Yakima" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "ECYID", "type": "esriFieldTypeInteger", "alias": "ECY ID", "domain": null }, { "name": "REPORTED_ELEVATION", "type": "esriFieldTypeDouble", "alias": "Reported Elevation", "domain": null }, { "name": "REPORTED_ELEVATION_METHOD", "type": "esriFieldTypeString", "alias": "Reported Elevation Method", "length": 50, "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": "" }, { "name": "GDB_173_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_173_DOCUMENT_ID", "fields": "DOCUMENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "subsurface_documents", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C95BA720-CAB9-4330-86B0-AADB02135556}" }, { "id": 8, "name": "in_situ_test_data", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{BC12080B-5F39-4EED-B669-9728757C0B61}" }, { "id": 9, "name": "hydrologic", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{CA16FEF6-E53D-46A2-BA01-07382D23EF68}" }, { "id": 10, "name": "bedrock", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{5B3D7C8D-B188-4281-913D-D4DFDCAC01EE}" }, { "id": 11, "name": "layer_comments", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C68F52B0-53E0-4607-BDE6-784926E56053}" }, { "id": 12, "name": "layer_data", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{6DA5E95C-82F5-4546-9BD1-7577AFE849C2}" }, { "id": 13, "name": "lithology_logs", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{9DD5FB7A-55FE-402F-BA3B-849C4C65546C}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Subsurface database bedrock table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "DEPTH_TO_BEDROCK_FT", "type": "esriFieldTypeSingle", "alias": "Depth to Bedrock (ft)", "domain": null }, { "name": "BEDROCK_TYPE", "type": "esriFieldTypeString", "alias": "Bedrock Type", "length": 30, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_59_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9484C85-D169-4DF3-838E-D1983F46D445}" }, { "id": 10, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{5B3D7C8D-B188-4281-913D-D4DFDCAC01EE}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Subsurface database hydrologic data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "DEPTH_TO_WATER_FT", "type": "esriFieldTypeDouble", "alias": "Depth to Water (ft)", "domain": null }, { "name": "ARTESIAN_PRESSURE_PSI", "type": "esriFieldTypeSingle", "alias": "Artesian Pressure (psi)", "domain": null }, { "name": "DRAWDOWN_YIELD_GPM", "type": "esriFieldTypeSingle", "alias": "Drawdown Yield (gpm)", "domain": null }, { "name": "DRAWDOWN_DISTANCE_FT", "type": "esriFieldTypeSingle", "alias": "Drawdown Distance (ft)", "domain": null }, { "name": "AIRTEST_STEM_FT", "type": "esriFieldTypeSingle", "alias": "Airtest Stem (ft)", "domain": null }, { "name": "DRAWDOWN_TIME_HOURS", "type": "esriFieldTypeSingle", "alias": "Drawdown Time (hrs)", "domain": null }, { "name": "TEST_DATE", "type": "esriFieldTypeDate", "alias": "Test Date", "length": 8, "domain": null }, { "name": "WATER_TEMPERATURE_C", "type": "esriFieldTypeSingle", "alias": "Water Temperature (c)", "domain": null }, { "name": "CHEMICAL_TEST_FLAG", "type": "esriFieldTypeString", "alias": "Chemical Test Flag", "length": 5, "domain": { "type": "codedValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_62_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{90FE31C6-FE90-4E1D-AC79-304F30AF9C75}" }, { "id": 9, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{CA16FEF6-E53D-46A2-BA01-07382D23EF68}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Subsurface database in-situ test data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "START_DEPTH_FT", "type": "esriFieldTypeSingle", "alias": "Start Depth (ft)", "domain": null }, { "name": "N_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "N Number", "domain": null }, { "name": "CALIBRATED_N_FLAG", "type": "esriFieldTypeString", "alias": "Calibrated N Flag", "length": 10, "domain": { "type": "codedValue", "name": "Flag field_2", "description": "Identifies if the item of interest exists in the data entry.", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNT_COMMENT", "type": "esriFieldTypeString", "alias": "Count Comment", "length": 10, "domain": null }, { "name": "TEST_DATE", "type": "esriFieldTypeDate", "alias": "Test Date", "length": 8, "domain": null }, { "name": "TEST_TYPE", "type": "esriFieldTypeString", "alias": "Test Type", "length": 100, "domain": null }, { "name": "SAMPLER", "type": "esriFieldTypeString", "alias": "Sampler", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_89_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{16E7D5FF-471D-4632-B539-E80846924B8E}" }, { "id": 8, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{BC12080B-5F39-4EED-B669-9728757C0B61}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Subsurface database layer comments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "COMMENT_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "Comment Number", "domain": null }, { "name": "COMMENT_DEPTH_FT", "type": "esriFieldTypeSingle", "alias": "Comment Depth (ft)", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 400, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_64_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C68F52B0-53E0-4607-BDE6-784926E56053}" }, { "id": 6, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8D1BD00E-ADC4-4F67-AB8B-BC0CAEC51E85}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Subsurface database layer data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "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_FT", "type": "esriFieldTypeSingle", "alias": "Top Depth (ft)", "domain": null }, { "name": "BOTTOM_DEPTH_FT", "type": "esriFieldTypeSingle", "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": 15, "domain": { "type": "codedValue", "name": "Layer type", "description": "Nature of the contact with the described layer and it's surroundings.", "codedValues": [ { "name": "Single", "code": "Single" }, { "name": "Gradational", "code": "Gradational" }, { "name": "Interbedded", "code": "Interbedded" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "USCS", "type": "esriFieldTypeString", "alias": "USCS", "length": 20, "domain": null }, { "name": "SYMBOL_LITHOLOGY", "type": "esriFieldTypeString", "alias": "Symbol Lithology", "length": 30, "domain": { "type": "codedValue", "name": "Symbol lithology", "description": "General classification of the layer's lithology.", "codedValues": [ { "name": "Asphalt / concrete", "code": "Asphalt / concrete" }, { "name": "Topsoil / vegetation", "code": "Topsoil / vegetation" }, { "name": "Debris", "code": "Debris" }, { "name": "Fill", "code": "Fill" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Gravelly sand", "code": "Gravelly sand" }, { "name": "Gravelly silt", "code": "Gravelly silt" }, { "name": "Gravelly clay", "code": "Gravelly clay" }, { "name": "Sand", "code": "Sand" }, { "name": "Sandy gravel", "code": "Sandy gravel" }, { "name": "Sandy silt", "code": "Sandy silt" }, { "name": "Sandy clay", "code": "Sandy clay" }, { "name": "Silt", "code": "Silt" }, { "name": "Silty gravel", "code": "Silty gravel" }, { "name": "Silty sand", "code": "Silty sand" }, { "name": "Silty clay", "code": "Silty clay" }, { "name": "Clay", "code": "Clay" }, { "name": "Clayey gravel", "code": "Clayey gravel" }, { "name": "Clayey sand", "code": "Clayey sand" }, { "name": "Clayey silt", "code": "Clayey silt" }, { "name": "Peat", "code": "Peat" }, { "name": "Volcanic ash", "code": "Volcanic ash" }, { "name": "Sedimentary bedrock", "code": "Sedimentary bedrock" }, { "name": "Metamophic bedrock", "code": "Metamophic bedrock" }, { "name": "Plutonic bedrock", "code": "Plutonic bedrock" }, { "name": "Volcanic bedrock", "code": "Volcanic bedrock" }, { "name": "Cobbles / boulders", "code": "Cobbles / boulders" }, { "name": "Undifferentiated rock", "code": "Undifferentiated rock" }, { "name": "Undefined", "code": "Undefined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INTERPRETED_LITHOLOGY", "type": "esriFieldTypeString", "alias": "Interpreted Lithology", "length": 30, "domain": null }, { "name": "GEOLOGIC_UNIT", "type": "esriFieldTypeString", "alias": "Geologic Unit", "length": 12, "domain": null }, { "name": "GEOLOGIC_UNIT_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Geologic Unit Confidence", "length": 20, "domain": { "type": "codedValue", "name": "Geologic unit confidence", "description": "Certainty estimate for the selected geologic unit and contact depth.", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEOLOGIST", "type": "esriFieldTypeString", "alias": "Geologist", "length": 30, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_109_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{6DA5E95C-82F5-4546-9BD1-7577AFE849C2}" }, { "id": 2, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AAE36098-5B51-4D42-8255-435BA85F81BF}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Subsurface database lithology logs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "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": "URL", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G163BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{9DD5FB7A-55FE-402F-BA3B-849C4C65546C}" }, { "id": 0, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6EAC91F4-D2D1-4F4A-B860-70D574FFD768}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Subsurface database documents", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DOCUMENT_ID", "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": { "type": "codedValue", "name": "Document type", "description": "The type of scanned document that the record is linked to.", "codedValues": [ { "name": "Report", "code": "Report" }, { "name": "Other", "code": "Other" }, { "name": "Boring log", "code": "Boring log" }, { "name": "Field notes", "code": "Field notes" }, { "name": "Geologic map", "code": "Geologic Map" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": 50, "domain": { "type": "codedValue", "name": "Project type", "description": "Primary subsequent use of land or design intent.", "codedValues": [ { "name": "Transportation - non-roadway", "code": "Transportation - non-roadway" }, { "name": "Residential", "code": "Residential" }, { "name": "Retail / commercial building", "code": "Retail / commercial building" }, { "name": "Automotive / fueling depot", "code": "Automotive / fueling depot" }, { "name": "Water well", "code": "Water well" }, { "name": "Industrial", "code": "Industrial" }, { "name": "Landfill", "code": "Landfill" }, { "name": "Landslide", "code": "Landslide" }, { "name": "Dry cleaner / laundry", "code": "Dry cleaner / laundry" }, { "name": "Military", "code": "Military" }, { "name": "Mine", "code": "Mine" }, { "name": "Park / recreation", "code": "Park / recreation" }, { "name": "Railroad", "code": "Railroad" }, { "name": "Retaining wall", "code": "Retaining wall" }, { "name": "Roadway", "code": "Roadway" }, { "name": "Utility", "code": "Utility" }, { "name": "Tunnel", "code": "Tunnel" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Bridge", "code": "Bridge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "Document Link", "length": 255, "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_181_DOCUMENT_ID", "fields": "DOCUMENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "water_wells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C95BA720-CAB9-4330-86B0-AADB02135556}" }, { "id": 4, "name": "borehole_info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{3AEB0249-DD02-4997-AAA0-6F7B2AD68DFD}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" } ] }