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.

Have you ever wanted to create your own maps, or integrate and visualize spatial datasets to examine changes in trends between locations and over time? Follow along with these training tutorials on QGIS, an open source geographic information system (GIS) and learn key concepts, procedures and skills for performing common GIS tasks – such as creating maps, as well as joining, overlaying and visualizing spatial datasets. These tutorials are geared towards new GIS users. We’ll start with foundational concepts, and build towards more advanced topics throughout – demonstrating how with a few relatively easy steps you can get quite a lot out of GIS. You can then extend these skills to datasets of thematic relevance to you in addressing tasks faced in your day-to-day work.

This dataset is OBSOLETE as of 11/18/2024 and will be removed from ArcGIS Online on 11/18/2025.An updated version of this dataset is available at Certified Sustainable Buildings | Open Data Portal | City of Cambridge.A map of the updated data can be found in two places:Certified Sustainable Buildings Map | Open Data Portal | City of CambridgeSustainable Buildings Map - City of Cambridge, MAThis point layer shows the location of sustainable buildings in Cambridge. For inclusion in this layer, a building must do at least one of the following: qualify for the City’s Article 22 regulatory process; be certified by Passive House; be certified by Enterprise Green Communities; or be certified by LEEDunder a LEED version that requires the whole building to meet sustainability standards. Some buildings meet two or more of these criteria. Additionally, this layer contains information about other certifications (Energy Star, Fitwel, and WELL) that may apply to the included buildings. If an included building participates in the City’s BEUDO regulatory process, this layer provides two key emissions figures for the building. Information provided about the applicable sustainable building programs for qualifying buildings includes certification levels, certification types, ratings, or scores. This layer includes data from City and non-City sources.Explore all our data on the Cambridge GIS Data Dictionary.Attributes NameType DetailsDescription BldgID type: Stringwidth: 50precision: 0 Unique ID for database from GIS.

Latitude type: Doublewidth: 8precision: 38 Geographic coordinate from GIS Bldg ID centroid file.

Longitude type: Doublewidth: 8precision: 38 Geographic coordinate from GIS Bldg ID centroid file.

Article22_SystemLevelEquivalenc type: Stringwidth: 150precision: 0

Article22 type: Stringwidth: 3precision: 0 "Yes" indicates Article 22 building.

BEUDO_TotalGHGEmissionsIntensit type: Doublewidth: 8precision: 38

BEUDO type: Stringwidth: 3precision: 0 "Yes" indicates BUEDO building.

BEUDO_SourceEUI type: Doublewidth: 8precision: 38 A critical variable for reporting about BEUDO.

EnergyStar type: Stringwidth: 3precision: 0 "Yes" indicates EnergyStar building.

EnergyStar_CountYearsCert type: SmallIntegerwidth: 2precision: 5 Number of years certified. EnergyStar certification may be renewed annually.

EnergyStar_LastYearCert type: Stringwidth: 4precision: 0 Year of last certification.

EnergyStar_LastCertScore type: SmallIntegerwidth: 2precision: 5 Most recent EnergyStar score.

EnterpriseGC type: Stringwidth: 3precision: 0 "Yes" indicates Enterprise Green Communities building.

EnterpriseGC_CertTemplate type: Stringwidth: 100precision: 0 Certification version.

EnterpriseGC_PointsAchieved type: SmallIntegerwidth: 2precision: 5 Enterprise Green Communities score.

Fitwel type: Stringwidth: 3precision: 0 "Yes" indicates Fitwel building.

Fitwel_StarRating type: SmallIntegerwidth: 2precision: 5 Numerical Fitwel rating.

LEED type: Stringwidth: 3precision: 0 "Yes" indicates LEED building.

LEED_TotalCerts type: SmallIntegerwidth: 2precision: 5 Number of certifications applying to the whole building. The LEED fields contain details about certifications that are "whole-building," not referring to one part of the building only or or to building operations.

LEED_LastCertDate type: Datewidth: 8precision: 0 Date of last certification applying to the whole building.

LEED_LastSystemVersion type: Stringwidth: 100precision: 0 Certification version and rating system.

LEED_LastCertLevel type: Stringwidth: 50precision: 0 LEED certifictation level at which whole building is certified. Certified/Silver/Gold/Platinum: Does not not include "registered" buildings.

PassiveHouse type: Stringwidth: 3precision: 0 "Yes" indicates Passive House building.

PassiveHouse_CertVersion type: Stringwidth: 100precision: 0 Certification version.

WELL type: Stringwidth: 3precision: 0 "Yes" indicates WELL building.

WELL_Version type: Stringwidth: 50precision: 0 Certification version.

WELL_ProjectType type: Stringwidth: 150precision: 0 WELL project type.

WELL_CertLevel type: Stringwidth: 50precision: 0 Certification level. Certified Pilot/Compliance/Bronze/Silver/Gold/Platinum or Health-Safety Rated: Does not include "registered" or "precertified" buildings.

created_date type: Datewidth: 8precision: 0

last_edited_date type: Datewidth: 8precision: 0

This GIS layer represents the geographic locations of properties in Durham County, North Carolina, that have been issued a Certificate of Occupancy (CO). A Certificate of Occupancy is a legal document certifying that a building has been inspected and complies with local building codes and zoning regulations, making it fit for occupancy. The data is updated regularly to reflect newly issued certificates, providing a current overview of habitable structures in Durham County.

This geospatial vector data set represents as described in solid waste collection companies Certificate of Public Convenience and Necessity issued to regulated Solid Waste Transportation Company by the Washington Utilities and Transportation Commission.

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.

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.

Web Map illustration of Garbage Service Area Boundary described in the certificated authority issued to Solid Waste Companies by Utilities and Transportation Commission (UTC). For additional information and questions pertaining to solid waste certificate coverage and issuance please, contact the UTC Licensing Section, 360-664-1223,

The Environmental Lab Accreditation Program (ELAP) of the Division of Drinking Water, California State Water Resources Control Board certifies laboratories for the testing of drinking water in a number of pollutant categories. The ELAP program's mission is to implement a sustainable accreditation program that ensures laboratories generate environmental and public health data of known, consistent, and documented quality to meet stakeholder needs. Through effective program implementation and continuous improvement of ELAP, California will utilize the highest quality scientific data as a foundation for its environmental and public health programs and decisions.This layer is updated nightly to provide the public a monthly update of lab locations along with their current testing certifications licensed by the program. More information can be found at https://www.waterboards.ca.gov/drinking_water/certlic/labs/Email elapca@waterboards.ca.gov for questions or concerns

The Minnesota Department of Agriculture’s “Minnesota Agricultural Water Quality Certification Program” (MAWQCP) launched an assessment tool online application to provide program participants a common online format in which to streamline the certification process.
The intended application audience includes the producer, licensed certifier, crop advisor, or other agronomic and conservation professionals. The assessment tool, one of three steps necessary to obtain certification, is a risk assessment tool which aggregates factors relating to nutrient management, tillage, soil properties, pest management and conservation practices into a unitless index score on a 1 thru 10 scores. Each field and cropping scenario is assessed.
The online application increases the efficiency of information gathering necessary to run the assessment tool. Features include mapping queries, data organization into field libraries, summary report generation and data packaging into small, easily transmittable formats. The application uses GIS map and geoprocessing services to calculate some of the summary data.
The online application ensures producer privacy by requiring users to store the information on a local drive; the hosting website and server does not store any information.

This dataset is a collection of records that communicate the locations of child care, family child care and certified child care centers in Minnesota. It was created by downloading licensing information from the Minnesota Department of Human Services (DHS), geocoding the spreadsheet records and converting them to a spatial format.

The following license types are represented:
Child Care Centers: Programs licensed to provide care to children for less than 24 hours a day in a commercial setting.
Family Child Care: Programs licensed to provide care to children for less than 24 hours a day, typically in the provider’s home or a local space, including a church.
Certified Child Care Center: Child care providers that are not required to be licensed, but are certified by DHS to be eligible to accept Child Care Assistance Program payments.

The approximately 10,000 records are combined into one layer, which can be queried to separate by license type. This version focuses on a smaller set of core attributes than can be found on DHS's Licensing Information Lookup Page; see that page for all the attributes: https://licensinglookup.dhs.state.mn.us/

Records represent licenses active as of the date shown in the Time Period of Content field. The official current status of licenses can be checked at the DHS licensing information lookup page.

At WHC, we believe that every act of conservation matters. Whether it’s a small pollinator garden or a complex wetlands restoration, each and every conservation action contributes to the collective positive outcome for the environment. WHC’s certification program, Conservation Certification®, provides third-party credibility and an objective evaluation to help companies demonstrate a voluntary long-term commitment to managing quality habitat for wildlife, conservation education and community outreach initiatives. This dataset illustrates programs that hold Conservation Certification. Each program represents a site-based collection of efforts to enhance or manage wildlife and wildlife habitat or to educate about these topics.

This web map shows the cumulative data of certificate of compliance issued from 2018 onwards in Hong Kong. It is a set of data made available by the Lands Department under the Government of Hong Kong Special Administrative Region (the "Government") at https://portal.csdi.gov.hk ("CSDI Portal"). The source data has been processed and converted into Esri File Geodatabase format and uploaded to Esri's ArcGIS Online platform for sharing and reference purpose. The objectives are to facilitate our Hong Kong ArcGIS Online users to use the data in a spatial ready format and save their data conversion effort.For details about the data, source format and terms of conditions of usage, please refer to the website of Hong Kong CSDI Portal at https://portal.csdi.gov.hk.

Updated Continually

This web map shows the location of Police Offices Providing Services on Matters related to Licensing, Permit, Certificate Application in Hong Kong. It is a set of data made available by the Hong Kong Police Force under the Government of Hong Kong Special Administrative Region (the "Government") at https://GEODATA.GOV.HK/ ("Hong Kong Geodata Store"). The source data is in GEOJSON format and has been processed and converted into Esri File Geodatabase format and uploaded to Esri's ArcGIS Online platform for sharing and reference purpose. The objectives are to facilitate our Hong Kong ArcGIS Online users to use the data in a spatial ready format and save their data conversion effort.For details about the data, source format and terms of conditions of usage, please refer to the website of Hong Kong Geodata Store at https://geodata.gov.hk/.

This layer shows the locations of Offices of Fire Safety Command and Licensing and Certification Command in Hong Kong. It is a set of data made available by the Fire Services Department under the Government of Hong Kong Special Administrative Region (the "Government") at https://portal.csdi.gov.hk ("CSDI Portal"). The source data is processed and converted to Esri File Geodatabase format and then uploaded to Esri’s ArcGIS Online platform for sharing and reference purpose. The objectives are to facilitate our Hong Kong ArcGIS Online users to use the data in a spatial ready format and save their data conversion effort. For details about the data, source format and terms of conditions of usage, please refer to the website of Hong Kong CSDI Portal at https://portal.csdi.gov.hk.

Access the file geodatabase source data in SC State Plane coordinate system

This layer shows the location of Clubs with Certificate of Compliance in Hong Kong. It is a set of data made available by the Home Affairs Department under the Government of Hong Kong Special Administrative Region (the "Government") at https://GEODATA.GOV.HK/ ("Hong Kong Geodata Store"). The source data is in CSV format and has been processed and converted into Esri File Geodatabase format and uploaded to Esri's ArcGIS Online platform for sharing and reference purpose. The objectives are to facilitate our Hong Kong ArcGIS Online users to use the data in a spatial ready format and save their data conversion effort.For details about the data, source format and terms of conditions of usage, please refer to the website of Hong Kong Geodata Store at https://geodata.gov.hk/.

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).

The City of Detroit’s Civil Rights, Inclusion & Opportunity Department (CRIO) runs the Detroit Business Opportunity Program (DBOP). It processes applications, maintains an online register, and annually certifies and recertifies Detroit Based Businesses (DBB), Detroit Headquartered Businesses (DHB), Detroit Resident Businesses (DRB), Detroit Small Businesses (DSB), Detroit Based Micro Businesses (DBMB), Detroit Start-Ups (DSU), Minority-Owned Business Enterprises (MBE), and Woman-Owned Business Enterprises (WBE). Depending on the certification, businesses qualify for the following benefits: appreciation events, networking and capacity building opportunities, equalization credits, and visibility on the register. This dataset is updated weekly and is limited to certifications that were active as of the time when the dataset was last updated.The City of Detroit website provides more information about the Detroit Business Opportunity Program. A list the subset of 3-Digit NIGP Commodity codes that applicants may select to describe their business in the NIGP Code field is available from CRIO.