In this course, you will explore a variety of open-source technologies for working with geosptial data, performing spatial analysis, and undertaking general data science. The first component of the class focuses on the use of QGIS and associated technologies (GDAL, PROJ, GRASS, SAGA, and Orfeo Toolbox). The second component of the class introduces Python and associated open-source libraries and modules (NumPy, Pandas, Matplotlib, Seaborn, GeoPandas, Rasterio, WhiteboxTools, and Scikit-Learn) used by geospatial scientists and data scientists. We also provide an introduction to Structured Query Language (SQL) for performing table and spatial queries. This course is designed for individuals that have a background in GIS, such as working in the ArcGIS environment, but no prior experience using open-source software and/or coding. You will be asked to work through a series of lecture modules and videos broken into several topic areas, as outlined below. Fourteen assignments and the required data have been provided as hands-on opportunites to work with data and the discussed technologies and methods. If you have any questions or suggestions, feel free to contact us. We hope to continue to update and improve this course. This course was produced by West Virginia View (http://www.wvview.org/) with support from AmericaView (https://americaview.org/). This material is based upon work supported by the U.S. Geological Survey under Grant/Cooperative Agreement No. G18AP00077. The views and conclusions contained in this document are those of the authors and should not be interpreted as representing the opinions or policies of the U.S. Geological Survey. Mention of trade names or commercial products does not constitute their endorsement by the U.S. Geological Survey. After completing this course you will be able to: apply QGIS to visualize, query, and analyze vector and raster spatial data. use available resources to further expand your knowledge of open-source technologies. describe and use a variety of open data formats. code in Python at an intermediate-level. read, summarize, visualize, and analyze data using open Python libraries. create spatial predictive models using Python and associated libraries. use SQL to perform table and spatial queries at an intermediate-level.

Certified businesses enterprises in the District of Columbia as identified by the DC Department of Small and Local Business. A Certified Business Enterprise (CBE) is a business that is headquartered in the District of Columbia and has been certified by the Department of Small and Local Business Development (DSLBD). Businesses with CBE certification receive preferred procurement and contracting opportunities.

The goal of the Lead Safe Certificate program is to prevent lead poisoning by ensuring that all rental homes built prior to 1978 are compliant with the city's Lead Safe Ordinance and maintained free of lead hazards.Any home built before 1978 is reasonably presumed to contain lead-based paint. Residential rental units built before 1978 must have a Lead Safe Certification from the City of Cleveland’s Department of Building and Housing.The Lead Safe Certification is only valid for two years, after which rental property owners must re-apply for certification.For more information about the City's Lead Safe Certification program, please visit this Building & Housing page.RelatedLead Safe Certificate ExplorerData GlossaryCOLUMN | DESCRIPTIONRECORD_ID | Unique ID produced by the Accela system.STATUS | Status of the certificate. IS_ACTIVE | Flag that is true if the certificate has a status of Certified, Active, About to Expire, or Exempt, all of which indicate that the associated property is lead safe. All other statuses are coded as false.RECORD_FILE_DATE | Date when the certificate was originally filed.RENTAL_REG_ID | ID of the associated rental registration record in Accela.RENEWAL_RECORD_ID | ID of an associated renewal record in Accela, if applicable.RENEWAL_RECORD_FILE_DATE | File date of the renewal, if applicable.STATUS_DATE | Time of last status update for the certificate.EXPIRATION_DATE | Date on which the certificate will expire.PrimaryAddress | Primary address associated with the certificate.PrimaryAddressZip | Zip code in the primary address.YEAR_BUILT | Year the associated building was constructed.TOTAL_UNITS | Total units in the building associated with the certificate.TOTAL_UNITS_INSPECTED | Total units inspected.INSPECTION_TYPE | Type of inspection.INSPECTION_DATE | Date of inspection. INVESTIGATOR_CERTIFICATION_ID | ID of the investigator who conducted the inspection.REVIEW_DATE | Date of last review.ACCELA_CITIZEN_ACCESS_URL | Link to the record in the Accela Citizen Access portal.DW_Parcel | Associated parcel number. DW_Ward | Associated ward (pre-2025 boundaries).DW_Tract2020 | 2020 Census tract.DW_Neighborhood | Neighborhood.IS_GEOLOCATED | True if the City's geocoder could locate the address. False otherwise.ContactCity of Cleveland, Building and Housing Lead Compliance ProgramUpdate FrequencyWeekly on Sundays at 7 AM EST (6 AM during daylight savings)

Note: This web page provides data on health facilities only. To file a complaint against a facility, please see: https://www.cdph.ca.gov/Programs/CHCQ/LCP/Pages/FileAComplaint.aspxThe California Department of Public Health (CDPH), Center for Health Care Quality, Licensing and Certification (L&C) Program licenses and certifies more than 30 types of healthcare facilities. The Electronic Licensing Management System (ELMS) is a CDPH data system created to manage state licensing-related data and enforcement actions. This file includes California healthcare facilities that are operational and have a current license issued by the CDPH and/or a current U.S. Department of Health and Human Services’ Centers for Medicare and Medicaid Services (CMS) certification.To link the CDPH facility IDs with those from other Departments, like HCAI, please reference the "Licensed Facility Cross-Walk" Open Data table at https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk. Facility geographic variables are updated monthly, if latitude/longitude information is missing at any point in time, it should be available when the next time the Open Data facility file is refreshed.Please note that the file contains the data from ELMS as of the 11th business day of the month. See DATA_DATE variable for the specific date of when the data was extracted.

In the fall of 2013, the Detroit Blight Removal Task Force commissioned Data Driven Detroit, the Michigan Nonprofit Association, and LOVELAND Technologies to conduct a survey of every parcel in the City of Detroit. The goal of the survey was to collect data on property condition and vacancy. The effort, called Motor City Mapping, leveraged relationships with the Rock Ventures family of companies and the Detroit Employment Solutions Corporation to assemble a dedicated team of over 200 resident surveyors, drivers, and quality control associates. Data collection occurred from December 4, 2013 until February 16, 2014, and the initiative resulted in survey information for over 370,000 parcels of land in the city of Detroit, identifying condition, occupancy, and use. The data were then extensively reviewed by the Motor City Mapping quality control team, a process that concluded on September 30, 2014. This file contains the official certified results from the Winter 2013/2014 survey, aggregated to 2010 Census Tracts for easy mapping and analysis. The topics covered in the dataset include totals and calculated percentages for parcels in the categories of illegal dumping, fire damage, structural condition, existence of a structure or accessory structure, and improvements on lots without structures.Metadata associated with this file includes field description metadata and a narrative summary documenting the process of creating the dataset.

This data set combines information from eight sustainable building certification programs, including two City regulatory programs, to show the extent and location of sustainable buildings in Cambridge.

For inclusion in this data set, a building must meet at least one of the following criteria: receive approval from the City’s Article 22 regulatory process; receive certification from the Passive House program; receive certification from Enterprise Green Communities; or receive LEED certification under a LEED system that requires the whole building to meet sustainability standards.

Some buildings meet two or more of these criteria. Information provided about the applicable sustainable building programs for qualifying buildings includes certification levels, certification types, ratings, or scores. Additionally, this data set contains information about other certifications (ENERGY STAR, Fitwel, and WELL) that may apply to covered buildings. If a covered building participates in the City’s BEUDO regulatory process, this data set indicates that. More specific information about BEUDO building energy usage can be found in the separate BUEDO data set.

In this dataset, we use Cambridge GIS Building IDs as unique identifiers for certified sustainable buildings. Building IDs refer to one physical structure, even if there are multiple street addresses associated with that structure.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

The Soils datalayer has been automated from published soils surveys as provided on various media by the United States Department of Agriculture (USDA) Natural Resources Conservation Service (NRCS). All soils data released by MassGIS have been "SSURGO-certified," which means they have been reviewed and approved by the NRCS and meet all standards and requirements for inclusion in the national SSURGO (Soil Survey Geographic database) release of county-level digital soils data. Soil survey areas are roughly based on county boundaries.More details...Feature service also available

All applicants for a Basic Business License operating from a commercial location in the District of Columbia must provide a Certificate of Occupancy (C of O) for the premise address from which the business activity is conducted in order to demonstrate the activity does not conflict with building and zoning codes. A certificate of occupancy is needed to occupy any structure other than a single family dwelling. To include the following uses: two family flat, apartment house, and all commercial uses.

This geospatial dataset is a hydrologic unit boundary layer for the Sub-basin (8-digit) level. The dataset is a subset of the 4th level (8-digit) hydrologic unit boundaries of the Watershed Boundary Dataset (WBD) layer for Oregon. It was created by dissolving boundaries from the finer resolution hydrologic units (those of the 5th or 10-digit level) to create these broader boundaries. Boundaries within the this data set were delineated by Pacific Northwest (PNW) Hydrography Framework Partners and Natural Resources Conservation Service (NRCS) to meet state requirements and to contribute to the national WBD repository. To meet these goals, the WBD must adhere to the "Federal Standards for Delineation of Hydrologic Unit Boundaries", dated October, 2004. These boundaries were made from the Oregon and Washington datasets that have been nationally certified by Natural Resources Conservation Service (NRCS) Prior to submission the dataset was subjected to an iterative review and edit process to ensure that the hydrologic boundaries fully satisfy the federal standards. This work was completed under a Memorandum of Understanding between the Pacific Northwest Hydrography Framework Partnership, NRCS and the US Geological Survey (USGS). The current dataset includes the entire 4th level (8-digit) subbasins that fall within or the four county Metro region. This data was originally downloaded from the PNW Hydrography Framework Clearinghouse (http://hydro.reo.gov/hu.html). Date of last data update: 2009-01-31 This is official RLIS data. Contact Person: Christine Rutan christine.rutan@oregonmetro.gov 503-797-1669 RLIS Metadata Viewer: https://gis.oregonmetro.gov/rlis-metadata/#/details/2100 RLIS Terms of Use: https://rlisdiscovery.oregonmetro.gov/pages/terms-of-use

DCCED certified population counts annually from 2011 to present for communities in the State of Alaska. Population counts are noted as DCCED Certified or DOWLD Estimates.Note on use for analysis: This data set mixes scale. It includes rows for boroughs, which contain multiple CDP's and cities from this same data set in many cases. The current naming conventions reflect the most recent data. Boundaries and names for boroughs and CDP's have changed over time. Contact dcraresearchandanalysis@alaska.gov with questions.Source: State of Alaska, Department of Commerce, Community, and Economic Development/Department of Labor and Workforce Development

Certified Local Districts are historic districts established by state or local governments that have been certified by the Secretary of the Interior as substantially meeting the National Register Criteria for Evaluation. Such certification may be used as a basis for applying for federal historic preservation related income tax credits.

Note: The above "Item updated" date is the date that this page was last updated. NHESP updates the data as needed, and the data served here is refreshed nightly by MassGIS.This service contains points for all vernal pools that have been certified by the Natural Heritage and Endangered Species Program (NHESP) according to the Guidelines for the Certification of Vernal Pool Habitat (PDF) (MA Division of Fisheries & Wildlife, 2009).

Vernal pools are small, shallow ponds characterized by lack of fish and by periods of dryness. Vernal pool habitat is extremely important to a variety of wildlife species including some amphibians that breed exclusively in vernal pools, and other organisms such as fairy shrimp, which spend their entire life cycles confined to vernal pool habitat. Many additional wildlife species utilize vernal pools for breeding, feeding and other important functions. Certified vernal pools are protected if they fall under the jurisdiction of the Massachusetts Wetlands Protection Act Regulations (310 CMR 10.00). However, the certification of a pool only establishes that it functions biologically as a vernal pool. Certification does not determine that the pool is within a resource area protected by the Wetlands Protection Act. Certified vernal pools are also afforded protection under the state Water Quality Certification regulations (401 Program), the state Title 5 regulations, and the Forest Cutting Practices Act regulations.Please see layer metadata for more details.Feature service also available.

EGLE administers the statewide Michigan Green Schools certification program. The program is dedicated to assisting all Michigan schools public and private achieve environmental goals that include protecting the air, land, water and animals of our state along with world outreach through good ecological practices and the teaching of educational stewardship of students pre-kindergarten through high school.A school is eligible to receive a Green School, Emerald School, or Evergreen School Environmental Stewardship Designation if the school or students perform the required number of activities, with a minimum of two activities from each of the four categories. The activity requirements for each level of environmental stewardship designation are as follows:Fields included in this dataset are:SchoolName: The name of the school.SchoolCity: The city that the school is in.SchoolCounty: The county that the school is in.CountyCoordName: The name of the county coordinator that approved the schoolCertificationLevel: The Green Schools certification level achieved based on number of activities achieved.Green: 10 total activities with at least two activities from each of the four categories.Emerald: 15 total activities with at least two activities from each of the four categories.Evergreen: 20 total activities with at least two activities from each of the four categories.Awaiting Final Result: Macomb County has not sent the final certification levels to the State of Michigan.Please visit EGLE's Green School site for more information and direct questions to Eileen Boekestein, EGLE's Environmental Education Coordinator at BoekesteinE@Michigan.gov.

The dataset provides location, contact information, and amenities at Indiana Marinas. The dataset highlights the Clean Marian program. Clean Marinas have voluntarily implemented storm water management, fueling, and cleaning practices to reduce impacts to water quality and the environment. They must meet minimum requirements to achieve certification, have a positive environmental history, and pass an IDEM compliance review, which includes an onsite visit. They must reapply every two years to maintain certification.

EGLE administers the statewide Michigan Green Schools certification program. The program is dedicated to assisting all Michigan schools public and private achieve environmental goals that include protecting the air, land, water and animals of our state along with world outreach through good ecological practices and the teaching of educational stewardship of students pre-kindergarten through high school.A school is eligible to receive a Green School, Emerald School, or Evergreen School Environmental Stewardship Designation if the school or students perform the required number of activities, with a minimum of two activities from each of the four categories. The activity requirements for each level of environmental stewardship designation are as follows:Fields included in this dataset are:SchoolName: The name of the school.SchoolCity: The city that the school is in.SchoolCounty: The county that the school is in.CountyCoordName: The name of the county coordinator that approved the schoolCertificationLevel: The Green Schools certification level achieved based on number of activities achieved.Green: 10 total activities with at least two activities from each of the four categories.Emerald: 15 total activities with at least two activities from each of the four categories.Evergreen: 20 total activities with at least two activities from each of the four categories.Awaiting Final Result: Macomb County has not sent the final certification levels to the State of Michigan.Please visit EGLE's Green School site for more information and direct questions to Sam Lichtenwald, EGLE's Michigan Green Schools Coordinator, at LichtenwaldS@Michigan.gov.

DCCED certified population counts annually from 2011 to present for communities in the State of Alaska. Population counts are noted as DCCED Certified or DOWLD Estimates.Note on use for analysis: This data set mixes scale. It includes rows for boroughs, which contain multiple CDP's and cities from this same data set in many cases. The current naming conventions reflect the most recent data. Boundaries and names for boroughs and CDP's have changed over time. Contact dcraresearchandanalysis@alaska.gov with questions.Source: State of Alaska, Department of Commerce, Community, and Economic Development/Department of Labor and Workforce Development

A community's permit file must have an official record that shows new buildings and substantial improvements in all identified Special Flood Hazard Areas (SFHAs)are properly elevated. This elevation information is needed to show compliance with the floodplain management ordinance. FEMA encourages communities to use the Elevation Certificate developed by FEMA to fulfill this requirement since it also can be used by the property owner to obtain flood insurance. Communities participating in the Community Rating System (CRS) are required to use the FEMA Online Elevation Certificate, FEMA Form FF-206-FY-22-152 (formerly 086-0-33).

This service contains points for all vernal pools that have been certified by the Natural Heritage and Endangered Species Program (NHESP) according to the Guidelines for the Certification of Vernal Pool Habitat pdf format of Vernal Pool Certification Guidelines (MA Division of Fisheries & Wildlife, 2009).

Certified Local Government (CLG) communities are those that have shown a commitment to historic preservation. They have done this by adopting a local ordinance and creating a historic preservation commission. The program is a dynamic partnership between local governments, the Idaho State Historic Preservation Office (SHPO), and the National Park Service (NPS). It assists local communities in preserving their unique historic character. The Certified Local Government program also provides technical assistance and small grants to local governments. Most importantly, communities use the grants to preserve their historic resources for future generations. The CLG program gives local communities a more active level of participation in the National Register of Historic Places program and a greater say in any federally funded projects in their area.On of the biggest benefits of the program is the CLG Grant program. Communities use these grants for a wide range of projects: surveys, National Register nominations, tour flyers, historic preservation plans, and even some bricks-and-mortar projects. In recent years, the Idaho SHPO has distributed over $77,000 annually to CLGs. Because of the CLG program, over $2 million dollars have been injected directly into local communities since 1983.Idaho currently has 39 communities who participate in the program.

This data resource is a layer in a map service. To download it, please go to the "Layers" section of this page and click the name of the dataset. This will open a new page that features a download button. Open the Map Service: https://gis.chesapeakebay.net/ags/rest/services/ChesapeakeProgress/cpSustainable_Schools_2021/MapServer This Chesapeake Bay Program indicator of progress toward the Sustainable Schools Outcome shows certified sustainable public and charter schools in the Chesapeake Bay watershed. Certified sustainable schools include public and charter schools that have been recognized as sustainable by the following programs: U.S. Green Ribbon Schools, National Wildlife Federation Eco-Schools USA (Bronze, Silver and Green Flag status), Maryland Green Schools, Pennsylvania Pathways to Green Schools and Virginia Naturally Schools.