AndreaBozzo/ceres-open-data-index huggingface dataset:
Cinnamon Teal Range - CWHR B083 [ds1421]

<div style='text-align:Left;'><div><div><p><span>Vector datasets of CWHR range maps are one component of California Wildlife Habitat Relationships (CWHR), a comprehensive information system and predictive model for California's wildlife. The CWHR System was developed to support habitat conservation and management, land use planning, impact assessment, education, and research involving terrestrial vertebrates in California. CWHR contains information on life history, management status, geographic distribution, and habitat relationships for 712 species of amphibians, reptiles, birds, and mammals known to occur regularly in the state. Range maps represent the maximum, current geographic extent of each species within California. They were originally delineated at a scale of 1:5,000,000 by species-level experts and have gradually been revised at a scale of 1:1,000,000. For more information about CWHR, visit the CWHR webpage (</span><a href='https://www.wildlife.ca.gov/Data/CWHR' style='text-decoration:underline;' rel='nofollow ugc'><span>https://www.wildlife.ca.gov/Data/CWHR</span></a><span>). The webpage provides links to download CWHR data and user documents such as a look up table of available range maps including species code, species name, and range map revision history; a full set of CWHR GIS data; .pdf files of each range map or species life history accounts; and a User Guide.</span></p></div></div></div>
Rocky Intertidal Ecosystems, California North Coast MPA Baseline Study

The objectives of this baseline study of rocky intertidal habitats along the North Coast Study Region (NCSR) are to (1) produce a quantitative baseline characterization of the structure of rocky intertidal ecosystems in Marine Protected Areas (MPAs) established by the Marine Life Protection Act (MLPA), (2) provide an initial comparison between rocky intertidal ecosystems inside MPAs and nearby associated (unprotected) reference areas, (3) analytically explore baseline characterizations for potential indicators of the state of rocky intertidal ecosystems, (4) generate a fish biodiversity baseline within rocky tide pools at a few sites inside and outside of MPAs (for the first time) as well as (5) examine rockfish recruitment into these tide pools, and (6) integrate these assessments with other components of the baseline survey, including (7) high resolution topographic geological surveys, to inform the role and design of these programs for future monitoring and evaluation of MPAs.
Terrestrial Native Game Species - ACE [ds2702]

<div style='text-align:Left;'><div><div><p style='margin:7 10 7 0;'><span>Terrestrial Game Species is a subset of Native Species Richness based on status or management. </span><span>For more information, see the Native Species Richness Factsheet at </span><a href='https://nrm.dfg.ca.gov/FileHandler.ashx?DocumentID=150681' style='text-decoration:underline;' rel='nofollow ugc'><span><span>https://nrm.dfg.ca.gov/FileHandler.ashx?DocumentID=150681</span></span></a><span>. </span></p><p style='margin:7 10 7 0;'><span><span>The user can view a list of species potentially present in each hexagon, including game species, in the ACE Online Viewer </span></span><a href='https://apps.wildlife.ca.gov/ace/' style='text-decoration:underline;' rel='nofollow ugc'><span>https://apps.wildlife.ca.gov/ace/</span></a><span>. The </span><span>California Department of Fish and Wildlifes (CDFW) Areas of Conservation Emphasis (ACE) is a compilation and analysis of the best-available statewide spatial information in California on biodiversity, rarity and endemism, harvested species, significant habitats, connectivity and wildlife movement, climate vulnerability, climate refugia, and other relevant data (e.g., other conservation priorities such as those identified in the State Wildlife Action Plan (SWAP), stressors, land ownership). ACE addresses both terrestrial and aquatic data. The ACE model combines and analyzes terrestrial information in a 2.5 square mile hexagon grid and aquatic information at the HUC12 watershed level across the state to produce a series of maps for use in non-regulatory evaluation of conservation priorities in California. The model addresses as many of CDFWs statewide conservation and recreational mandates as feasible using high quality data sources. High value areas statewide and in each USDA Ecoregion were identified. The ACE maps and data can be viewed in the ACE online map viewer, or downloaded for use in ArcGIS. For more detailed information see </span><a href='https://www.wildlife.ca.gov/Data/Analysis/ACE' style='text-decoration:underline;' rel='nofollow ugc'><span><span>https://www.wildlife.ca.gov/Data/Analysis/ACE</span></span></a><span><span> and </span></span><a href='https://nrm.dfg.ca.gov/FileHandler.ashx?DocumentID=24326' style='text-decoration:underline;' rel='nofollow ugc'><span><span>https://nrm.dfg.ca.gov/FileHandler.ashx?DocumentID=24326</span></span></a><span>. </span></p></div></div></div>
CalEnviroScreen 3.0 Results

<p>CalEnviroScreen is a mapping tool that helps identify California communities that are most affected by many sources of pollution, and where people are often especially vulnerable to pollution’s effects.<br />
CalEnviroScreen uses environmental, health, and socioeconomic information to produce scores for every census tract in the state.<br />
The scores are mapped so that different communities can be compared. An area with a high score is one that experiences a much higher pollution burden than areas with low scores.<br />
CalEnviroScreen ranks communities based on data that are available from state and federal government sources.</p>
2019 California Water Quality Status Report

<p>The California Water Quality Status Report is an annual data-driven snapshot of the Water Board’s water quality and ecosystem data. This third edition of the report is organized around the watershed from land to sea. Each theme-specific story includes a brief background, a data analysis summary, an overview of management actions, and access to the raw data.</p>
<p>View the <a href="https://www.waterboards.ca.gov/resources/data_databases/wq_status_report.html">2019 California Water Quality Status Report.</a></p>
<ul>
<li>Data for Fig. 2 1,2,3,-Trichloropropane is provided as a download below. The data can also be downloaded from the <a href="https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/123TCP_page.html">State Water Resources Control Board (SWRCB) website</a>.</li>
<li>Data for Fig. 6 Statewide Water Bodies Toxicity can be downloaded from the <a href="https://data.ca.gov/dataset/surface-water-toxicity-results">California Open Data Portal</a>.</li>
<li>Sediment load data for Fig. 7 Elk River is provided as a download below. Landslide susceptibility data is available on the <a href="https://spatialservices.conservation.ca.gov/arcgis/rest/services/CGS/MS58_LandslideSusceptibility_Classes/MapServer">California Geological Survey GIS server</a>.</li>
<li>Data for Fig. 8 Central Valley Water Board <em>E. coli</em> Monitoring Results can be downloaded from <a href="https://docs.google.com/spreadsheets/d/1W5JdX6gx07uTsK_i_sFVXSftlNql-dLurXI4v3A9zKA/edit?usp=sharing">Google Sheets</a>.</li>
<li>Data for Fig. 9 Harmful Algal Bloom Incident Reports Map can be downloaded from the <a href="https://data.ca.gov/dataset/surface-water-freshwater-harmful-algal-blooms">California Open Data Portal</a>.</li>
<li>Data for Fig. 19 Industrial Stormwater Assessment Tool can be downloaded from the California Open Data Portal (<a href="https://data.ca.gov/dataset/stormwater-%E2%80%93-regulatory-and-enforcement-actions-%E2%80%93-smarts/resource/fe4712db-015a-4e92-a13f">Monitoring Data</a>, <a href="https://data.ca.gov/dataset/stormwater-%E2%80%93-regulatory-and-enforcement-actions-%E2%80%93-smarts/resource/a5f001af-abbb-4bc7-9196">Facility Information</a>), Office of Environmental Health Hazard Assessment <a href="https://oehha.ca.gov/calenviroscreen/report/calenviroscreen-30">CalEnviroScreen 3.0 webpage</a>, and the <a href="https://www.waterboards.ca.gov/water_issues/programs/tmdl/integrated2012.shtml">SWRCB 2012 Integrated Report webpage</a>.</li>
<li>Data for Fig. 20 is provided as a download below and is also available on the <a href="https://sccwrp.shinyapps.io/sqi_shiny/">Stream Quality Index dashboard</a>. Download the file from the dashboard for the most current data.</li>
</ul>
DMUG Newsletter 2019

The DMUG Newsletter 2019 is here!!! Please see the attached PDF file. 

As promised, this edition is a more condensed version comparing with the previous ones. Each write-up is shorter and more focused. If you would like to have additional information on a particular project, please contact the writer for further details. 

Also new to this edition is the Delta Trivia section.  Test your Delta knowledge for some fun. 😊

As always, my sincere appreciation and utmost gratitude to this year’s amazing contributing authors: Brad, Edward, Eli, John, Joey, Kevin, Kijin, Lan, Liheng, Nicky, Rusty, Sophie, and Sujoy. THANK YOU for taking the time from your busy schedule to make this issue of the newsletter possible!  

Happy Reading!
Min
CalEnviroScreen 2.0

<p>The Office of Environmental Health Hazard Assessment (OEHHA), on behalf of the California Environmental Protection Agency (CalEPA), developed California Communities Environmental Health Screening Tool: CalEnviroScreen Version 2.0 (CalEnviroScreen 2.0). CalEnviroScreen is a screening methodology that can be used to help identify California communities that are disproportionately burdened by multiple sources of pollution.CalEPA has used the tool to designate California communities as disadvantaged (link is external) pursuant to Senate Bill 535.</p>
State Buildings Sustainability Metrics

<p>This data set lists sustainability metric data for state-owned buildings.  These data are used to track state departments’ progress toward the goals mandated in Executive Order B-18-12.  The metrics tracked in this set are total water use, total energy use, renewable energy generation and LEED certifications.  The data set also includes building information for the 1722 buildings listed including, building name, address, total square footage and use type.  These data are entered by property owners from each state department into the database Energy Star Portfolio Manager.  Most data are obtained by property owner using the utility bill; however, some of the information is automatically fed into the database by the utility company.</p>
Purchase Order Data

<p>The State Contract and Procurement Registration System (SCPRS) was established in 2003, as a centralized database of information on State contracts and purchases over $5000.  eSCPRS represents the data captured in the State's eProcurement (eP) system, Bidsync, as of March 16, 2009.  The data provided is an extract from that system for fiscal years 2012-2013, 2013-2014, and 2014-2015</p>
<p><strong>Data Limitations:</strong><br />
Some purchase orders have multiple UNSPSC numbers, however only first was used to identify the purchase order. Multiple UNSPSC numbers were included to provide additional data for a DGS special event however this affects the formatting of the file. The source system Bidsync is being deprecated and these issues will be resolved in the future as state systems transition to Fi$cal.</p>
<p><strong>Data Collection Methodology:</strong></p>
<p>The data collection process starts with a data file from eSCPRS that is scrubbed and standardized prior to being uploaded into a SQL Server database. There are four primary tables. The Supplier, Department and United Nations Standard Products and Services Code (UNSPSC) tables are reference tables. The Supplier and Department tables are updated and mapped to the appropriate numbering schema and naming conventions. The UNSPSC table is used to categorize line item information and requires no further manipulation.  The Purchase Order table contains raw data that requires conversion to the correct data format and mapping to the corresponding data fields. A stacking method is applied to the table to eliminate blanks where needed. Extraneous characters are removed from fields.  The four tables are joined together and queries are executed to update the final Purchase Order Dataset table. Once the scrubbing and standardization process is complete the data is then uploaded into the SQL Server database.</p>
<p><strong>Secondary/Related Resources:</strong></p>
<ul>
<li>State Contract Manual (SCM) vol. 2 <a href="http://www.dgs.ca.gov/pd/Resources/publications/SCM2.aspx">http://www.dgs.ca.gov/pd/Resources/publications/SCM2.aspx</a></li>
<li>State Contract Manual (SCM) vol. 3 <a href="http://www.dgs.ca.gov/pd/Resources/publications/SCM3.aspx">http://www.dgs.ca.gov/pd/Resources/publications/SCM3.aspx</a></li>
<li>Buying Green <a href="http://www.dgs.ca.gov/buyinggreen/Home.aspx">http://www.dgs.ca.gov/buyinggreen/Home.aspx</a></li>
<li>United Nations Standard Products and Services Code, <a href="http://www.unspsc.org/">http://www.unspsc.org/</a></li>
</ul>
SB 535 Disadvantaged Communities 2017

<p>The California Environmental Protection Agency (CalEPA) is responsible for identifying disadvantaged communities for purposes of the Cap-and-Trade funding program.  After reviewing the updated results from CalEnviroScreen 3.0 and taking into consideration previous comments and input received over the past two years, including workshops held in February 2017, CalEPA is designating the highest scoring 25% of census tracts from CalEnviroScreen 3.0 as disadvantaged communities.  Additionally, 22 census tracts that score in the highest 5% of CalEnviroScreen’s Pollution Burden, but do not have an overall CalEnviroScreen score because of unreliable socioeconomic or health data, are also designated as disadvantaged communities.</p>
<p>For more information, including maps and data, see <a href="http://www.calepa.ca.gov/envjustice/ghginvest/">http://www.calepa.ca.gov/envjustice/ghginvest/</a></p>
<p>For OEHHA’s page on SB535, see: <a href="https://oehha.ca.gov/calenviroscreen/sb535">https://oehha.ca.gov/calenviroscreen/sb535</a></p>
Surface Water - 2017 California Water Quality Status Report

<p>The California Water Boards’ Water Data Center is proud to present the CA Water Quality Status Report.  This report is an annual data-driven snapshot of the Water Board's water quality and environmental data. This inaugural version of the report is based solely on the surface water datasets available via the [Surface Water Ambient Monitoring Program (SWAMP)] (<a href="http://www.waterboards.ca.gov/swamp/">http://www.waterboards.ca.gov/swamp/</a>) and in future years we hope to expand this to include the groundwater, drinking water and water resource datasets available in our state.  Our goal is to use data to inform both data storytelling (as in this inaugural report) and water quality indicators, including watershed report cards.</p>
<p>The 2017 Water Quality Status Report is organized around seven major themes that our team thought both individually and collectively tell important stories about the overall health of our state’s surface waters.  Each theme-specific story includes a brief background, a data analysis summary, an overview of management actions, and access to the raw data.</p>
<p>For more information please contact the <a href="mailto:OIMA-Helpdesk@waterboards.ca.gov">Office of Information Management and Analysis (OIMA)</a>.</p>
<p><img src="http://www.waterboards.ca.gov/water_issues/programs/swamp/images/swamp_logo_rgb_new_125x150.jpg" alt="Pict" /></p>
<p>Data for the section “Setting Flow Targets to Support Biological Integrity in Southern California Streams” can be found on the <a href="https://data.ca.gov/dataset/flow-targets-southern-california-streams">California open data portal</a>.<br />
Data for the section “Nutrients and Algae in Aquatic Ecosystems” can be found <a href="https://cfpub.epa.gov/si/si_public_record_report.cfm?dirEntryID=274010">here</a>.</p>
Drinking Water - Laboratory Water Quality Results

<p>The Division of Drinking Water requires laboratories to submit water quality data directly. The data is received, and published twice monthly on the Division's water quality <a href="https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/EDTlibrary.html">portal</a>. The resource here now is just a data dictionary for the laboratory analysis data available from that portal, and in the near future we plan to add curated data resources that include laboratory water quality results.</p>
Surface Water - 2018 California Water Quality Status Report

<p>The California Water Quality Status Report is an annual data-driven snapshot of the Water Board’s water quality and ecosystem data. This second edition of the report is organized around the watershed from land to sea. Each theme-specific story includes a brief background, a data analysis summary, an overview of management actions, and access to the raw data.</p>
<p>View the <a href="https://www.waterboards.ca.gov/resources/data_databases/wq_status_report.html">2018 California Water Quality Status Report</a>.</p>
<ul>
<li>Data for Fig. 8  Landscape Constraints on Stream Biological Integrity in the San Gabriel River Watershed can be downloaded from <a href="https://zenodo.org/record/1218121">Zenodo</a>.</li>
<li>Data for Fig. 13 HAB Incident Reports Map can be downloaded from the <a href="https://data.ca.gov/dataset/surface-water-%E2%80%93-freshwater-harmful-algal-blooms">California Open Data Portal</a>.</li>
</ul>
<p>For more information please contact the <a href="mailto:OIMA-Helpdesk@waterboards.ca.gov">Office of Information Management and Analysis (OIMA)</a>.</p>
Drinking Water - Public Water Systems Rates Information

<p>Public Water Systems (PWS) submit their annual reports with rate information using the Electronic Annual Report (EAR) submission process on the Drinking Water Information Clearinghouse (DRINC) portal, which is reviewed, and manually updated into the Safe Drinking Water Information System (SDWIS). This includes the water rates reported by PWS in the EAR for years 2014 and 2015.</p>
DGS Conference Rooms

<p>The Real Estate Services Division, Building and Property Management Branch, has provided a directory of conference rooms available in DGS-owned buildings for use by state agencies. The DGS has also included conference rooms and auditorium information for DGS' headquarters (Ziggurat Building) located at 707 3rd Street, West Sacramento. This dataset provides conference room information such as capacity, video conferencing availability, as well as various audio/visual equipment available at each site.</p>
Characterization of Seabirds, California North Coast MPA Baseline Study, 2014 to 2015

We completed four distinct projects to collect baseline data at varying spatial and temporal scales. First, we used data from aerial photographic surveys conducted from 1989-2014 to investigate region-wide trends in the populations of Common Murres and Brandt’s Cormorants. We used 173 observations of Common Murre colony abundance at 14 colonies and 123 observations of Brandt’s Cormorant nest abundance at 10 colonies over the 26-year study period. Additionally, aerial photographic surveys conducted in 2014 were used to document location and abundance of Common Murre, Brandt’s Cormorant, and Double-crested Cormorant across the NCSR.

Second, at a more localized scale, we monitored Common Murre reproduction, foraging effort, and diet in 2014 at Castle Rock National Wildlife Refuge using a robotic, remotely-controlled video recording system. Although this is only one of the seabird colonies in the NCSR, it the largest and served to inform our understanding of the mechanisms of population change across the region. Common Murre are very visible and thus ideal for monitoring fine scale patterns in reproduction and changing diet. We measured date of nest initiation, hatching success, fledging success, overall reproductive success, time allocation, provisioning rate, and diet composition via the video. Information gained from these surveys were combined with comparable data from 2007-2013 at Castle Rock to assess baseline condition and variability of these metrics over an 8-year period.

Third, in 2014-2015 we conducted ground-based surveys of coastally breeding seabirds inside and outside of six MPAs to establish a framework for continued MPA monitoring. For this, we conducted intensive monitoring of six species likely to benefit from MPA establishment: Pigeon Guillemot, Brandt’s Cormorant, Pelagic Cormorant, Double-crested Cormorant, Western Gull, and Black Oystercatcher. We collected data on breeding population size, breeding productivity, foraging rates and rates of human-caused disturbance inside and outside of each MPA. We monitored productivity by following individual nests visible from land and calculated annual breeding productivity as number of fledglings produced per breeding pair. We monitored foraging from land-based observation points, recording all birds foraging within a 1 km radius of an observation point. We calculated foraging rates as number of birds foraging per hour of observation. We recorded all human-caused disturbances observed during any land-based survey and calculated disturbance rates as number of disturbances per hour of observation.
Traditional Ecological Knowledge of Keystone Marine Species and Ecosystems, California North Coast MPA Baseline Study, 2014 to 2015

This project, Informing the North Coast MPA Baseline: Traditional Ecological Knowledge of Keystone Marine Species and Ecosystems, applies Tribal/Indigenous Traditional Knowledge (T/ITK) to inform the baseline characterization for State Marine Protected Area (MPA) monitoring. This project represents the first time that T/ITK has been gathered under the State MPA Baseline Monitoring Program. It contributes a highly relevant and groundbreaking study that utilizes T/ITK to develop a baseline characterization for key nearshore marine habitats, and provides significant historical context for that baseline. The project also provides information on essential consumptive and non-consumptive uses by several North Coast Tribes, as well as areas where Tribal citizens are concerned about a particular threat to marine resources and/or habitats. This information is critically important because Tribal citizens constitute a vital “front line” user group with extensive marine knowledge and stewardship practices that span countless generations.
Northern Shoveler Range - CWHR B084 [ds1422]

<div style='text-align:Left;'><div><div><p style='margin:0 0 14 0;'><span><span>Vector datasets of CWHR range maps are one component of California Wildlife Habitat Relationships (CWHR), a comprehensive information system and predictive model for California's wildlife. The CWHR System was developed to support habitat conservation and management, land use planning, impact assessment, education, and research involving terrestrial vertebrates in California. CWHR contains information on life history, management status, geographic distribution, and habitat relationships for wildlife species known to occur regularly in California. Range maps represent the maximum, current geographic extent of each species within California. They were originally delineated at a scale of 1:5,000,000 by species-level experts and have gradually been revised at a scale of 1:1,000,000. For more information about CWHR, visit the CWHR webpage (</span><a href='https://www.wildlife.ca.gov/Data/CWHR' style='text-decoration:underline;' rel='nofollow ugc'><span>https://www.wildlife.ca.gov/Data/CWHR</span></a><span>). The webpage provides links to download CWHR data and user documents such as a look up table of available range maps including species code, species name, and range map revision history; a full set of CWHR GIS data; .pdf files of each range map or species life history accounts; and a User Guide.</span></span></p></div></div></div>