Appendix 6a: Questionnaire Data Schema
This database contains responses to the national geological mapping questionnaire. Below metadata describe the tables and columns of questionnaire_responses.db (DuckDB), which supplements the Economic Analysis of the Costs and Benefits of Geological Mapping (2024) report. The accompanying Microsoft Access (.accdb) database adheres to the below schema, however, column data types may differ where incompatible with DuckDB. Apache Parquet (.parquet) and Comma Separated Value (.csv) flat files consist of a join of all data tables within the database. Data dictionaries and one-to-many derivative tables have been exported separately for the flat file formats and are located in csv/other_tables/.
License:
This database is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/
Database metadata:
responder_info_public
- shape: 4779 rows, 11 columns
- description: general information on survey response
responder_info_public.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
responder_info_public.start_time
dtype: TIMESTAMP
domain: None
description: time survey was started
responder_info_public.submit_time
dtype: TIMESTAMP
domain: None
description: time survey was submitted
responder_info_public.completion_status
dtype: VARCHAR
domain: None
description: survey completion status
responder_info_public.language
dtype: VARCHAR
domain: None
description: survey language
responder_info_public.country
dtype: VARCHAR
domain: None
description: country of responder
responder_info_public.city
dtype: VARCHAR
domain: None
description: city of responder
responder_info_public.state_region
dtype: VARCHAR
domain: None
description: state/region of responder
responder_info_public.postal
dtype: VARCHAR
domain: None
description: postal code of responder
responder_info_public.states_operational
dtype: VARCHAR[]
domain: ['AK', 'AL', 'AR', 'AS', 'AZ', 'Australia', 'Baja California', 'Bangladesh', 'Bihar', 'CA', 'CO', 'CT', 'Canada', 'Caribbean', 'DC', 'DE', 'Durango', 'FL', 'Finland', 'GA', 'GU', 'HI', 'IA', 'ID', 'IL', 'IN', 'Italy', 'Jharkhand', 'KS', 'KY', 'Katanga', 'LA', 'MA', 'MD', 'ME', 'MI', 'MN', 'MO', 'MP', 'MS', 'MT', 'Madrid', 'Mariana Islands', 'Mexico', 'NC', 'ND', 'NE', 'NH', 'NJ', 'NM', 'NV', 'NY', 'New Zealand', 'Nigeria', 'Nova Scotia', 'OH', 'OK', 'OR', 'Ontario', 'Otario', 'PA', 'PN', 'PR', 'Pakistan', 'Paramaribo', 'Peru', 'RI', 'SC', 'SD', 'Saudi Arabia', 'Serbia', 'Shouvik Mandal', 'South Africa', 'South America', 'Suriname', 'TN', 'TX', 'Tanzania', 'UT', 'VA', 'VI', 'VT', 'Vorarlberg', 'WA', 'WI', 'WV', 'WY', 'West Bengal', 'Yukon']
description: controlled vocab: states in which responder operates
responder_info_public.states_operational_other
dtype: VARCHAR[]
domain: ['AS', 'Australia', 'Baja California', 'Bangladesh', 'Bihar', 'Canada', 'Caribbean', 'Durango', 'Finland', 'GU', 'Italy', 'Jharkhand', 'Katanga', 'MP', 'Madrid', 'Mariana Islands', 'Mexico', 'New Zealand', 'Nigeria', 'Nova Scotia', 'Ontario', 'Otario', 'PN', 'PR', 'Pakistan', 'Paramaribo', 'Peru', 'Saudi Arabia', 'Serbia', 'Shouvik Mandal', 'South Africa', 'South America', 'Suriname', 'Tanzania', 'VI', 'Vorarlberg', 'West Bengal', 'Yukon']
description: non-us state portion of states_operational
regions
- shape: 4717 rows, 2 columns
- description: regional classification of responses based on responder_info_public.states_operational
regions.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
regions.region
dtype: VARCHAR[]
domain: ['Great Lakes/Great Plains', 'Intermountain West', 'International', 'Northeast', 'Pacific Rim', 'South-Central', 'Southeast']
description: regional classification of responses based on responder_info_public.states_operational
exclusions
- shape: 187 rows, 3 columns
- description: responses excluded from analyses
exclusions.row_id
dtype: INTEGER
domain: None
description: auto-number primary key
exclusions.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
exclusions.exclusion_basis
dtype: VARCHAR
domain: None
description: reason for exclusion
org_size_bins
- shape: 4779 rows, 3 columns
- description: assigned bins for organization size based on question_1.1c_organization_size
org_size_bins.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
org_size_bins.org_size
dtype: INTEGER
domain: None
description: organization size copied from question_1.1c_organization_size
org_size_bins.org_size_bin
dtype: VARCHAR
domain: None
description: assigned bin for organization size
question_1
- shape: 4779 rows, 7 columns
- description: question 1 responses
question_1.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_1.1_organization_type
dtype: VARCHAR
domain: None
description: 1. which best describes your organization?
question_1.1a_private_sector_type
dtype: VARCHAR[]
domain: ['construction', 'energy_lg', 'energy_sm', 'geo_technical', 'independent_geo', 'mineral_lg', 'mineral_sm', 'nfp_organization', 'other', 'public_utility', 'real_estate', 'tourism', 'transportation', 'water']
description: 1(a). check all that apply as private sector (including not-for-profit)
question_1.1a_other
dtype: VARCHAR
domain: None
description: other (specify): 1(a). check all that apply as private sector (including not-for-profit)
question_1.1b_public_sector_type
dtype: VARCHAR[]
domain: ['city_gov', 'county_gov', 'edu', 'fed_agency', 'general_public', 'nfp_organization', 'other', 'state_gov', 'state_survey', 'usgs']
description: 1(b). check all that apply as public sector (federal, state, local, or regional)
question_1.1b_other
dtype: VARCHAR
domain: None
description: other (specify): 1(b). check all that apply as public sector (federal, state, local, or regional)
question_1.1c_organization_size
dtype: INTEGER
domain: None
description: 1(c). how many employees in your organization?
question_2
- shape: 4779 rows, 18 columns
- description: question 2 responses
question_2.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_2.2a_resource_activity
dtype: VARCHAR[]
domain: ['coal', 'critical_minerals', 'geothermal', 'groundwater', 'industrial_minerals', 'metals', 'oil_gas', 'other']
description: 2(a). which activities in your organization require geologic maps? resource exploration, assessment, delineation, development, and production (check all that apply.)
question_2.2a_other
dtype: VARCHAR
domain: None
description: other (specify): 2(a). which activities in your organization require geologic maps? resource exploration, assessment, delineation, development, and production (check all that apply.)
question_2.2b_environmental_activity
dtype: VARCHAR[]
domain: ['conservation', 'eia', 'other', 'pollution', 'remediation']
description: 2(b). which activities in your organization require geologic maps? environmental consulting, including economic consulting (check all that apply)
question_2.2b_other
dtype: VARCHAR
domain: None
description: other (specify): 2(b). which activities in your organization require geologic maps? environmental consulting, including economic consulting (check all that apply)
question_2.2c_hazard_activity
dtype: VARCHAR[]
domain: ['earthquake', 'erosion', 'flood', 'landslide', 'other', 'rockslide', 'sinkhole_karst', 'soil', 'subsidence', 'volcano']
description: 2(c). which activities in your organization require geologic maps? hazard assessment, mitigation, or prevention (check all that apply)
question_2.2c_other
dtype: VARCHAR
domain: None
description: other (specify): 2(c). which activities in your organization require geologic maps? hazard assessment, mitigation, or prevention (check all that apply)
question_2.2d_engineering_activity
dtype: VARCHAR[]
domain: ['bldg_foundation', 'dam_dike', 'electric_utility', 'irrigation', 'other', 'pipeline', 'port', 'railroad', 'road_bridge', 'waste']
description: 2(d). which activities in your organization require geologic maps? engineering applications (check all that apply)
question_2.2d_other
dtype: VARCHAR
domain: None
description: other (specify): 2(d). which activities in your organization require geologic maps? engineering applications (check all that apply)
question_2.2e_city_activity
dtype: VARCHAR[]
domain: ['bldg_code', 'landscape', 'other', 'zoning']
description: 2(e). which activities in your organization require geologic maps? city planning (check all that apply)
question_2.2e_other
dtype: VARCHAR
domain: None
description: other (specify): 2(e). which activities in your organization require geologic maps? city planning (check all that apply)
question_2.2f_regional_activity
dtype: VARCHAR[]
domain: ['industrial', 'land_use', 'military', 'other', 'transportation', 'utility', 'waste']
description: 2(f). which activities in your organization require geologic maps? regional planning (check all that apply)
question_2.2f_other
dtype: VARCHAR
domain: None
description: other (specify): 2(f). which activities in your organization require geologic maps? regional planning (check all that apply)
question_2.2g_property_activity
dtype: VARCHAR[]
domain: ['banking', 'conservation_easement', 'geothermal_lease', 'hazard_id', 'insurance', 'land_acquisition', 'mining_claims', 'oil_gas_lease', 'other', 'tax_est']
description: 2(g). which activities in your organization require geologic maps? property valuation (check all that apply)
question_2.2g_other
dtype: VARCHAR
domain: None
description: other (specify): 2(g). which activities in your organization require geologic maps? property valuation (check all that apply)
question_2.2h_academic_activity
dtype: VARCHAR[]
domain: ['edu_higher', 'edu_k12', 'research_applied', 'research_basic']
description: 2(h). which activities in your organization require geologic maps? research and education (check all that apply)
question_2.2i_public_activity
dtype: VARCHAR[]
domain: ['field_trip', 'geocaching', 'other', 'outdoor_rec', 'parks_rec', 'rockhounding', 'weekend_prospecting']
description: 2(i). which activities in your organization require geologic maps? general public (check all that apply)
question_2.2i_other
dtype: VARCHAR
domain: None
description: other (specify): 2(i). which activities in your organization require geologic maps? general public (check all that apply)
question_3
- shape: 4779 rows, 4 columns
- description: question 3 responses
question_3.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_3.3a_total_cost_percent_savings
dtype: VARCHAR
domain: None
description: 3(a). savings of total project costs (%): in your estimate, how much time and money did you save in the last five years because geological maps were available?
question_3.3b_project_dollar_percent_savings
dtype: VARCHAR
domain: None
description: 3(b). by dollar value of a typical project (%): in your estimate, how much time and money did you save in the last five years because geological maps were available?
question_3.3c_time_percent_savings
dtype: INTEGER
domain: None
description: 3(c). by time saved (%): in your estimate, how much time and money did you save in the last five years because geological maps were available?
question_4
- shape: 4779 rows, 2 columns
- description: question 4 responses
question_4.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_4.4_map_format
dtype: VARCHAR[]
domain: ['aerial_photo', 'cuttings_core', 'digital_map', 'digital_rpt', 'drill_logs', 'field_notes', 'general_data', 'geochem_data', 'geochron_data', 'geophys_data', 'gis_data', 'lidar', 'paper_map', 'paper_rpt']
description: 4. in what form do you use geologic maps? (check all that apply.)
question_5
- shape: 4779 rows, 3 columns
- description: question 5 responses
question_5.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_5.5_derivative_map_format
dtype: VARCHAR[]
domain: ['aquifer_delineation', 'aquifer_recharge', 'aquifer_sensitivity', 'coal', 'construction', 'critical_minerals', 'drift_thickness', 'earthquake', 'flood', 'geothermal', 'industrial_minerals', 'land_cover', 'landslide', 'metals', 'mined_out', 'oil_gas', 'other', 'research_basic', 'sinkhole_karst', 'slope_stability', 'soil_drainage', 'soil_engineering', 'surface_topo', 'tsunami', 'water']
description: 5. what types of derivative maps do you use? (check all that apply.)
question_5.5_other
dtype: VARCHAR
domain: None
description: other (specify): 5. what types of derivative maps do you use? (check all that apply.)
question_6
- shape: 4779 rows, 2 columns
- description: question 6 responses
question_6.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_6.6_benefit_example
dtype: VARCHAR
domain: None
description: 6. how do geologic maps and information benefit your organization or industry?(please provide specific examples)
question_6_coded_narratives
- shape: 2802 rows, 3 columns
- description: thematic binning of free-text responses to question 6
question_6_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_6_coded_narratives.6_code
dtype: VARCHAR[]
domain: ['0', '1', '2', '3', '4', '5', '6', '7']
description: encoding alias value
question_6_coded_narratives.6_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_7
- shape: 4779 rows, 6 columns
- description: question 7 responses
question_7.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_7.7a_project_example
dtype: VARCHAR
domain: None
description: 7(a). if you use geologic maps and the accompanying reports or data, please provide the following information in enough detail to fully explain the project. describe a specific project for which geologic maps and the accompanying reports or data were used, including the total project cost.
question_7.7b_self_dev_cost_percent
dtype: VARCHAR
domain: None
description: 7(b). if the geologic maps and reports were not available from publicly funded institutions (e.g., federal, state, or academic) for the above project and you had to develop or acquire the geologic data yourself, approximately how much more (in %) would your project cost?
question_7.7c_project_maps_used
dtype: VARCHAR
domain: None
description: 7(c). for the above project, how many geologic maps did you use? (enter the number)
question_7.7_11_like_note
dtype: VARCHAR
domain: None
description: likenote: questions #7 through #11 refer to a project you chose to report about. realizing that projects may differ in nature and complexity, you may want to provide the same information about multiple projects. if you choose to do so, please do so in a separate email.
question_7.7_11_dislike_note
dtype: VARCHAR
domain: None
description: dislikenote: questions #7 through #11 refer to a project you chose to report about. realizing that projects may differ in nature and complexity, you may want to provide the same information about multiple projects. if you choose to do so, please do so in a separate email
question_7_coded_narratives
- shape: 2069 rows, 3 columns
- description: thematic binning of free-text responses to question 7
question_7_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_7_coded_narratives.7_code
dtype: VARCHAR[]
domain: ['0', '1', '10', '11', '2', '3', '4', '5', '6', '7', '8', '9']
description: encoding alias value
question_7_coded_narratives.7_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_7_usd_extraction
- shape: 2179 rows, 8 columns
- description: results of pattern-matching analysis used to extract dollar amount figures from question 7 free-text responses
question_7_usd_extraction.7_row_id
dtype: INTEGER
domain: None
description: auto-number primary key
question_7_usd_extraction.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_7_usd_extraction.7_code
dtype: INTEGER
domain: None
description: encoding alias value (response theme)
question_7_usd_extraction.7_usd
dtype: INTEGER
domain: None
description: (boolean) whether or not a USD figure for project was found in response
question_7_usd_extraction.7_maps
dtype: INTEGER
domain: None
description: (boolean) whether or not a number of maps used in project was indicated in response
question_7_usd_extraction.7_usd_n_max
dtype: FLOAT
domain: None
description: value of USD figure extracted from text (maximum if range or multiple values presented)
question_7_usd_extraction.7_usd_n_min
dtype: FLOAT
domain: None
description: value of USD figure extracted from text (minimum if range or multiple values presented)
question_7_usd_extraction.7_maps_n
dtype: INTEGER
domain: None
description: number of maps indicated
question_8
- shape: 4779 rows, 3 columns
- description: question 8 responses
question_8.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_8.8_wtp_per_map
dtype: VARCHAR
domain: None
description: 8. many public and some private agencies provide geologic maps and data at no cost or a nominal cost. if these maps had not been available from these sources, how much (in $) would you willingly have paid to construct one project-specific geologic map?
question_8.8_other
dtype: VARCHAR
domain: None
description: other (specify dollar amount): 8. many public and some private agencies provide geologic maps and data at no cost or a nominal cost. if these maps had not been available from these sources, how much (in $) would you willingly have paid to construct one project-specific geologic map?
question_9
- shape: 4779 rows, 2 columns
- description: question 9 responses
question_9.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_9.9_wtp_certainty
dtype: INTEGER
domain: None
description: 9. how certain do you feel about your choice in question #8 on a scale of 1 to 10? (rate on the below scale – choose 10 for highest certainty, 1 for not at all certain)
question_10
- shape: 4779 rows, 2 columns
- description: question 10 responses
question_10.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_10.10_wtp_long_value
dtype: VARCHAR
domain: None
description: 10. considering that your willingness to pay (wtp) for geologic maps for a project may be different from their value over a longer period of time, in your judgment, what would be this long-term value of those geologic maps used for the above-described project?
question_11
- shape: 4779 rows, 2 columns
- description: question 11 responses
question_11.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_11.11_wtp_long_certainty
dtype: INTEGER
domain: None
description: 11. how certain do you feel about your choice in question #10 on a scale of 1 to 10? (rate on the below scale – choose 10 for highest certainty, 1 for not at all certain)
question_12
- shape: 4779 rows, 3 columns
- description: question 12 responses
question_12.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_12.12_scale_preference
dtype: VARCHAR[]
domain: ['100k', '10k', '24k', '250k', '50k', '5k', 'other']
description: 12. what mapping scale best serves your needs? (check all that apply.)
question_12.12_other
dtype: VARCHAR
domain: None
description: other (specify): 12. what mapping scale best serves your needs? (check all that apply.)
question_13
- shape: 4779 rows, 2 columns
- description: question 13 responses
question_13.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_13.13_visit_frequency
dtype: VARCHAR
domain: None
description: 13. how often do you visit the offices, facilities, or websites of agencies and organizations that provide geologic information to obtain geologic maps? (select one)
question_14
- shape: 4779 rows, 2 columns
- description: question 14 responses
question_14.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_14.14_visit_usefulness
dtype: VARCHAR
domain: None
description: 14. how useful or productive are your visits? (select one)
question_15
- shape: 4779 rows, 6 columns
- description: question 15 responses
question_15.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_15.15a_online_scanned_map_importance
dtype: VARCHAR
domain: None
description: 15(a). scanned maps: rate the importance of having digital online access to the following products. (click on "please select" below to see choices in the drop-down menu.)
question_15.15b_online_gis_data_importance
dtype: VARCHAR
domain: None
description: 15(b). geologic map data, such as gis: rate the importance of having digital online access to the following products. (click on "please select" below to see choices in the drop-down menu.)
question_15.15c_online_report_importance
dtype: VARCHAR
domain: None
description: 15(c). accompanying reports: rate the importance of having digital online access to the following products. (click on "please select" below to see choices in the drop-down menu.)
question_15.15d_online_seamless_map_importance
dtype: VARCHAR
domain: None
description: 15(d). seamless maps: rate the importance of having digital online access to the following products. (click on "please select" below to see choices in the drop-down menu.)
question_15.15e_online_3d_map_importance
dtype: VARCHAR
domain: None
description: 15(e). 3-d geologic maps: rate the importance of having digital online access to the following products. (click on "please select" below to see choices in the drop-down menu.)
question_16
- shape: 4779 rows, 3 columns
- description: question 16 responses
question_16.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_16.16_self_dev_method
dtype: VARCHAR[]
domain: ['contract_dev', 'none', 'other', 'private_consultant', 'self_dev']
description: 16. how do you obtain geologic maps if these are not available from public or private institutions?
question_16.16_other
dtype: VARCHAR
domain: None
description: other (specify): 16. how do you obtain geologic maps if these are not available from public or private institutions?
question_17
- shape: 4779 rows, 4 columns
- description: question 17 responses
question_17.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_17.17a_self_dev_max_dollar
dtype: VARCHAR
domain: None
description: 17(a). maximum: how much would you typically spend for a map in the above case? (please estimate as best you can in the dollar amount, $)
question_17.17b_self_dev_min_dollar
dtype: VARCHAR
domain: None
description: 17(b). minimum: how much would you typically spend for a map in the above case? (please estimate as best you can in the dollar amount, $)
question_17.17c_self_dev_best_est_dollar
dtype: VARCHAR
domain: None
description: 17(c). best estimate: how much would you typically spend for a map in the above case? (please estimate as best you can in the dollar amount, $)
question_18
- shape: 4779 rows, 9 columns
- description: question 18 responses
question_18.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_18.18a_value_from_geo_surveys
dtype: INTEGER
domain: None
description: 18(a). us geological survey and state geological surveys: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18b_value_from_nps
dtype: INTEGER
domain: None
description: 18(b). national park service: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18c_value_from_other_federal
dtype: INTEGER
domain: None
description: 18(c). other federal agencies: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18d_value_from_other_state
dtype: INTEGER
domain: None
description: 18(d). other state and local agencies: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18e_value_from_academic
dtype: INTEGER
domain: None
description: 18(e). academic departments: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18f_value_from_mineral_industry
dtype: INTEGER
domain: None
description: 18(f). minerals and fuel industries: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18g_value_from_infrastructure_industry
dtype: INTEGER
domain: None
description: 18(g). infrastructure industries: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_18.18h_value_from_nfp_organizations
dtype: INTEGER
domain: None
description: 18(h). not-for-profit organizations: in your view, how would you rate the value of geologic maps and accompanying reports from the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_19
- shape: 4779 rows, 3 columns
- description: question 19 responses
question_19.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_19.19_decision_improvement
dtype: VARCHAR
domain: None
description: 19. how do geologic maps and the accompanying reports obtained from public institutions improve the quality and accuracy of your decisions? (select one)
question_19.19a_explanation
dtype: VARCHAR
domain: None
description: 19(a). explain your choice briefly in question #19 question.
question_19_coded_narratives
- shape: 1857 rows, 3 columns
- description: thematic binning of free-text responses to question 19
question_19_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_19_coded_narratives.19_code
dtype: VARCHAR[]
domain: ['0', '1', '2', '3', '4', '5', '6', '7']
description: encoding alias value
question_19_coded_narratives.19_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_20
- shape: 4779 rows, 3 columns
- description: question 20 responses
question_20.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_20.20_credibility_improvement
dtype: VARCHAR
domain: None
description: 20. how does reference to the federal, state, or academic institution as the source of geologic maps and reports substantiate the credibility of your work, in the view of your audience?
question_20.20a_explanation
dtype: VARCHAR
domain: None
description: 20(a). explain your choice briefly in question #20.
question_20_coded_narratives
- shape: 1677 rows, 3 columns
- description: thematic binning of free-text responses to question 20
question_20_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_20_coded_narratives.20_code
dtype: VARCHAR[]
domain: ['1', '2', '3', '4']
description: encoding alias value
question_20_coded_narratives.20_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_21
- shape: 4779 rows, 2 columns
- description: question 21 responses
question_21.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_21.21_quality_example
dtype: VARCHAR
domain: None
description: 21. give an example of how the quality of your project is affected when geologic mapping is not available.
question_21_coded_narratives
- shape: 1749 rows, 3 columns
- description: thematic binning of free-text responses to question 21
question_21_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_21_coded_narratives.21_code
dtype: VARCHAR[]
domain: ['0', '1', '2', '3', '4', '5', '6', '7', '8']
description: encoding alias value
question_21_coded_narratives.21_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_22
- shape: 4779 rows, 22 columns
- description: question 22 responses
question_22.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_22.22a_value_for_national_parks
dtype: FLOAT
domain: None
description: 22(a). national parks: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22b_value_for_other_federal
dtype: FLOAT
domain: None
description: 22(b). other federal agencies: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22c_value_for_state_parks
dtype: FLOAT
domain: None
description: 22(c). state parks and recreation areas: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22d_value_for_other_state
dtype: FLOAT
domain: None
description: 22(d). other state and local agencies: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22e_value_for_universities
dtype: FLOAT
domain: None
description: 22(e). universities (research and education): in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22f_value_for_metal_industry
dtype: FLOAT
domain: None
description: 22(f). metals industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22g_value_for_uranium_industry
dtype: FLOAT
domain: None
description: 22(g). uranium industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22h_value_for_critical_mineral_industry
dtype: FLOAT
domain: None
description: 22(h). critical minerals industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22i_value_for_stone_industry
dtype: FLOAT
domain: None
description: 22(i). sand & gravel and stone industries: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22j_value_for_frac_industry
dtype: FLOAT
domain: None
description: 22(j). frac sands industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22k_value_for_oil_gas_industry
dtype: FLOAT
domain: None
description: 22(k). oil and gas industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22l_value_for_coal_industry
dtype: FLOAT
domain: None
description: 22(l). coal industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22m_value_for_geothermal_industry
dtype: FLOAT
domain: None
description: 22(m). geothermal industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22n_value_for_geotechnical_industry
dtype: FLOAT
domain: None
description: 22(n). geotechnical industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22o_value_for_agriculture_industry
dtype: FLOAT
domain: None
description: 22(o). agriculture industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22p_value_for_forestry_industry
dtype: FLOAT
domain: None
description: 22(p). forestry industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22q_value_for_public_utilities
dtype: FLOAT
domain: None
description: 22(q). public utilities: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22r_value_for_groundwater_industry
dtype: FLOAT
domain: None
description: 22(r). groundwater industry: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22s_value_for_public_safety
dtype: FLOAT
domain: None
description: 22(s). public safety and information organizations: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22t_value_for_nfp_organizations
dtype: FLOAT
domain: None
description: 22(t). not-for-profit organizations: in your view, how would you rate the value of geologic maps and the accompanying reports for the following institutions? (use 10 for the highest value, 1 for the lowest value)
question_22.22_other
dtype: VARCHAR
domain: None
description: other specify: 22. (limit your response to 300 words)
question_23
- shape: 4779 rows, 2 columns
- description: question 23 responses
question_23.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_23.23_priority_applications
dtype: VARCHAR
domain: None
description: 23. help us prioritize geographical areas for future geologic mapping work. list states, counties, urban areas, growth corridors, regions, or specific areas of the united states. list specific derivative maps, if applicable.
question_23_coded_narratives
- shape: 1475 rows, 3 columns
- description: thematic binning of free-text responses to question 23
question_23_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_23_coded_narratives.23_code
dtype: VARCHAR[]
domain: ['0', '1', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2', '20', '21', '22', '23', '24', '3', '4', '5', '6', '7', '8', '9']
description: encoding alias value
question_23_coded_narratives.23_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_24
- shape: 4779 rows, 2 columns
- description: question 24 responses
question_24.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_24.24_mapping_progression
dtype: VARCHAR
domain: None
description: 24. to meet the needs of society (and your own interests), how should geologic mapping progress or evolve in the future?
question_24_coded_narratives
- shape: 1623 rows, 3 columns
- description: thematic binning of free-text responses to question 24
question_24_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_24_coded_narratives.24_code
dtype: VARCHAR[]
domain: ['0', '1', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2', '20', '21', '22', '3', '4', '5', '6', '7', '8', '9']
description: encoding alias value
question_24_coded_narratives.24_response
dtype: VARCHAR
domain: None
description: free-text narrative response
question_25
- shape: 4779 rows, 2 columns
- description: question 25 responses
question_25.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_25.25_additional_comments
dtype: VARCHAR
domain: None
description: 25. any additional comments?
question_25_coded_narratives
- shape: 606 rows, 3 columns
- description: thematic binning of free-text responses to question 25
question_25_coded_narratives.responder_id
dtype: INTEGER
domain: None
description: unique identifier for survey response; serves as a relational and grouping key throughout the database
question_25_coded_narratives.25_code
dtype: VARCHAR[]
domain: ['0', '1', '2', '3', '4', '5', '6', '7']
description: encoding alias value
question_25_coded_narratives.25_response
dtype: VARCHAR
domain: None
description: free-text narrative response
data_dictionary_questions
- shape: 102 rows, 5 columns
- description: long descriptions for column aliasses used througout database
data_dictionary_questions.question_id
dtype: INTEGER
domain: None
description: auto-number primary key
data_dictionary_questions.table_id
dtype: VARCHAR
domain: None
description: table
data_dictionary_questions.question_alias
dtype: VARCHAR
domain: None
description: column name
data_dictionary_questions.question_full
dtype: VARCHAR
domain: None
description: full questionnaire item corresponding to column
data_dictionary_questions.response_options
dtype: VARCHAR
domain: None
description: domain of multi-select responses
data_dictionary_responses
- shape: 148 rows, 4 columns
- description: long descriptions for domain response aliasses used througout database
data_dictionary_responses.response_id
dtype: INTEGER
domain: None
description: auto-number primary key
data_dictionary_responses.question_alias
dtype: VARCHAR
domain: None
description: column name
data_dictionary_responses.response_alias
dtype: VARCHAR
domain: None
description: alias used to shorten/encode multi-select responses
data_dictionary_responses.response_full
dtype: VARCHAR
domain: None
description: full description of muli-select response
data_dictionary_regions
- shape: 6 rows, 2 columns
- description: definition of regional bins used in region table
data_dictionary_regions.region
dtype: VARCHAR
domain: None
description: region name
data_dictionary_regions.states
dtype: VARCHAR[]
domain: ['AK', 'AL', 'AR', 'AZ', 'CA', 'CO', 'CT', 'DCDE', 'FL', 'GA', 'HI', 'IA', 'ID', 'IL', 'IN', 'KS', 'KY', 'LA', 'MA', 'MD', 'ME', 'MI', 'MN', 'MO', 'MS', 'MT', 'NB', 'NC', 'ND', 'NH', 'NJ', 'NM', 'NV', 'NY', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC', 'SD', 'TN', 'TX', 'UT', 'VA', 'VT', 'WA', 'WI', 'WV', 'WY']
description: states included in regional bin
data_dictionary_6_narrative_codes
- shape: 7 rows, 2 columns
- description: narrative theme encoding for question 6
data_dictionary_6_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_6_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
data_dictionary_7_narrative_codes
- shape: 11 rows, 2 columns
- description: narrative theme encoding for question 7
data_dictionary_7_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_7_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
data_dictionary_20_narrative_codes
- shape: 4 rows, 2 columns
- description: narrative theme encoding for question 20
data_dictionary_20_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_20_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
data_dictionary_21_narrative_codes
- shape: 8 rows, 2 columns
- description: narrative theme encoding for question 21
data_dictionary_21_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_21_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
data_dictionary_23_narrative_codes
- shape: 24 rows, 2 columns
- description: narrative theme encoding for question 23
data_dictionary_23_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_23_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
data_dictionary_24_narrative_codes
- shape: 22 rows, 2 columns
- description: narrative theme encoding for question 24
data_dictionary_24_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_24_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
data_dictionary_25_narrative_codes
- shape: 7 rows, 2 columns
- description: narrative theme encoding for question 25
data_dictionary_25_narrative_codes.code
dtype: INTEGER
domain: None
description: encoding alias value
data_dictionary_25_narrative_codes.description
dtype: VARCHAR
domain: None
description: description of alias value (free-text response theme)
Table of Contents
- Abstract
- Acknowledgements
- Executive Summary
- Chapter 1: Introduction
- Chapter 2: Study Objectives and Methodology
- Chapter 3: Stakeholder Assessment of Map Producing Agencies
- Chapter 4: Cost for Geological Mapping
- Chapter 5: Geological Mapping Program Activities — Critical Components
- Chapter 6: Benefits of Geological Mapping: Quantitative Assessment of Responses to Stakeholder Questionnaire
- Chapter 7: Geological Map Demand and Economic Estimates of Costs and Benefits
- Chapter 8: Regional Variations in Costs and Benefits of Geological Mapping
- Chapter 9: Quantitative Value Assessment from Independent EPA Data
- Chapter 10: Qualitative Assessment of Value of Geological Maps by Stakeholders
- Chapter 11: An Economic Model of General Geological Mapping Applications
- Chapter 12: Stakeholder Input about Future Geological Mapping
- Chapter 13: Lessons Learned and Suggestions for Future Analyses
- Chapter 14: Summary and Conclusions
- Appendix 1: Cost Sheet Template
- Appendix 2: Questionnaire to Stakeholders
- Appendix 3: Example Solication Letter Requesting Stakeholders to Participate in National Cost-Benefit Assessment
- Appendix 4: Summary Statistics, Outliers, and Confidence Intervals
- Appendix 5: Annual State Geological Survey Map Views
- Appendix 6: Regional Cost-Benefit Analysis Datasets
- Appendix 6a: Questionnaire Data Schema
- Appendix 6b: State Geological Survey Reporting Schema
- Appendix 7: Chapter 8 Supplemental Figures and Tables