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.

This dataset holds all materials for the Inform E-learning GIS course

Through the Department of the Interior-Bureau of Indian Affairs Enterprise License Agreement (DOI-BIA ELA) program, BIA employees and employees of federally-recognized Tribes may access a variety of geographic information systems (GIS) online courses and instructor-led training events throughout the year at no cost to them. These online GIS courses and instructor-led training events are hosted by the Branch of Geospatial Support (BOGS) or offered by BOGS in partnership with other organizations and federal agencies. Online courses are self-paced and available year-round, while instructor-led training events have limited capacity and require registration and attendance on specific dates. This dataset does not any training where the course was not completed by the participant or where training was cancelled or otherwise not able to be completed. Point locations depict BIA Office locations or Tribal Office Headquarters. For completed trainings where a participant location was not provided a point locations may not be available. For more information on the Branch of Geospatial Support Geospatial training program, please visit:https://www.bia.gov/service/geospatial-training.

As one of the cornerstones of the U.S. Geological Survey's (USGS) National Geospatial Program, The National Map is a collaborative effort among the USGS and other Federal, State, and local partners to improve and deliver topographic information for the United States. It has many uses ranging from recreation to scientific analysis to emergency response. This technical and trade school point-feature dataset was developed for The National Structures Dataset.A Technical / Trade School is an educational institution that students attend to acquire skills necessary for careers in a specific trade. Upon completion of the program, students receive certificates verifying the skills acquired. Technical / Trade Schools do not offer any type of academic degrees. The National Center for Education Statistics (NCES) maintains a list of institutions that includes trade schools under colleges. Only those listed as offering certificates (vs. degrees) should be mapped as trade schools.

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 resource contains data inputs and a Jupyter Notebook that is used to introduce Hydrologic Analysis using Terrain Analysis Using Digital Elevation Models (TauDEM) and Python. TauDEM is a free and open-source set of Digital Elevation Model (DEM) tools developed at Utah State University for the extraction and analysis of hydrologic information from topography. This resource is part of a HydroLearn Physical Hydrology learning module available at https://edx.hydrolearn.org/courses/course-v1:Utah_State_University+CEE6400+2019_Fall/about

In this activity, the student learns how to (1) derive hydrologically useful information from Digital Elevation Models (DEMs); (2) describe the sequence of steps involved in mapping stream networks, catchments, and watersheds; and (3) compute an approximate water balance for a watershed-based on publicly available data.

Please note that this exercise is designed for the Logan River watershed, which drains to USGS streamflow gauge 10109000 located just east of Logan, Utah. However, this Jupyter Notebook and the analysis can readily be applied to other locations of interest. If running the terrain analysis for other study sites, you need to prepare a DEM TIF file, an outlet shapefile for the area of interest, and the average annual streamflow and precipitation data. - There are several sources to obtain DEM data. In the U.S., the DEM data (with different spatial resolutions) can be obtained from the National Elevation Dataset available from the national map (http://viewer.nationalmap.gov/viewer/). Another DEM data source is the Shuttle Radar Topography Mission (https://www2.jpl.nasa.gov/srtm/), an international research effort that obtained digital elevation models on a near-global scale (search for Digital Elevation at https://www.usgs.gov/centers/eros/science/usgs-eros-archive-products-overview?qt-science_center_objects=0#qt-science_center_objects). - If not already available, you can generate the outlet shapefile by applying basic terrain analysis steps in geospatial information system models such as ArcGIS or QGIS. - You also need to obtain average annual streamflow and precipitation data for the watershed of interest to assess the annual water balance and calculate the runoff ratio in this exercise. In the U.S., the streamflow data can be obtained from the USGS NWIS website (https://waterdata.usgs.gov/nwis) and the precipitation from PRISM (https://prism.oregonstate.edu/normals/). Note that using other datasets may require preprocessing steps to make data ready to use for this exercise.

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)

Dropout rates for Alaska public school districts. The dropout rate is defined by state regulation 4 AAC 06.895(i)(3) as a fraction of students grades 7-12 who have dropped out during the current school year out of the total students in grades 7-12 enrolled as of October 1st of the school year for which the data is reported.A student is considered to be a dropout when they have discontinued schooling for a reason other than graduation, transfer to another diploma-track program, emigration, or death unless the student is enrolled and in attendance at the same school or at another diploma-track program prior to the end of the school year (June 30).Students who depart a diploma track program in pursuit of GED certification, credit recovery, or non-diploma track vocational training are considered to have dropped out.This data set includes historic data from 1991 to present.GIS layers for individual years can be accessed using the Build Your Own Map application.Source: Alaska Department of Education & Early Development

This data has been visualized in a Geographic Information Systems (GIS) format and is provided as a service in the DCRA Information Portal by the Alaska Department of Commerce, Community, and Economic Development Division of Community and Regional Affairs (SOA DCCED DCRA), Research and Analysis section. SOA DCCED DCRA Research and Analysis is not the authoritative source for this data. For more information and for questions about this data, see: Alaska Department of Education & Early Development Data Center

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

The percentage of persons that have completed, graduated, or received a high school diploma or GED and also have taken some college courses or completed their Associate's degree. This is a standard indicator used to measure the portion of the population with a basic level of skills needed for the workplace. Persons under the age of 25 are not included in this analysis since many of these persons are still attending various levels of schooling. Source: American Community Survey Years Available: 2007-2011, 2008-2012, 2009-2013, 2010-2014, 2011-2015, 2012-2016, 2013-2017, 2014-2018, 2015-2019, 2016-2020, 2017-2021, 2018-2022, 2019-2023

To operate an ambulance service and ambulances in Arizona, an application must be filed with the Department of Health Services, Bureau of Emergency Medical Services & Trauma System, and a Certificate of Necessity (CON) granted by the Director. This dataset contains a representation of the CON service boundaries. While this dataset is complete for Arizona, there are known issues with intra & inter-polygon topology (gaps/slivers) and alignment with features used to create the CON boundaries. Please refer to the service area boundary described in the CON certificate, which can be found on this website. The data was last updated January 2024. For more information visit AZ the Dept. of Health Services Ground Ambulance Program Certificate of Necessity (CON) Holders.

March 2024

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.

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 Texas Voluntary Cleanup Program (VCP) was established by the Texas Legislature in 1995. It provides administrative, technical, and legal incentives to encourage the cleanup of contaminated sites in Texas. The VCP is a brownfields program designed to address sites that are burdened by real or reasonably perceived environmental issues that may hamper real estate transactions or redevelopment. Since all non-responsible parties, including future lenders and landowners, receive protection from liability to the state of Texas for cleanup of sites under the VCP, most of the constraints for completing real estate transactions at those sites are eliminated once a VCP certificate of completion is issued. The Voluntary Cleanup Program web URL is: (https://www.tceq.texas.gov/remediation/vcp/vcp.html).

Alaska school district boundaries and addresses. Replacing former School District geometries (as of Nov 3, 2022). Each school district boundary (geometry, not attributes) is derived from one of three sources. 1. Borough and Census Area Boundaries (as a proxy for school districts in the organized borough). https://dcra-cdo-dcced.opendata.arcgis.com/datasets/DCCED::alaska-borough-and-census-area-boundaries/about2. Regional Educational Attendance Area Boundaries (school districts in the unorganized borough). A Regional Educational Attendance Area (REAA) is an educational area that is established in an unorganized borough of the state established by AS 14.08.031(a). REAA elections administered by the Division of Elections. This dataset is revised for recasting of REAA sections using 2020 Census data. The 2020 version is the first time REAA boundaries were fully created using Geographic Information System (GIS) technology. Revised for the 2022 move of the city of Rampart from Yukon Flats to Yukon-Koyukuk. 3. City Boundaries - Boundaries are based on the actual certificates issued by the Local Boundary Commission. https://dcra-cdo-dcced.opendata.arcgis.com/datasets/DCCED::city-boundaries/aboutFor more information, see https://education.alaska.gov/DOE_Rolodex/SchoolCalendar/DistrictAndSchoolInfo/DistrictDetails

Includes:Locations of Degree Granting Institutions with Associates and Certificates Locations of Non Degree Granting InstitutionsLocations of Institutions with Bachelor's Degree and AboveLocations of Career and Technical InstitutesLocations of Primary and Secondary Elementary SchoolsLocations of Child Care ProvidersNumber of Degree Granting Institutions with Associates and Certificates by CountyNumber of Non Degree Granting Institutions by CountyNumber of Institutions with Bachelor's Degree and Above by CountyNumber of Career and Technical Institutes by CountyNumber of Primary and Secondary Elementary Schools by CountyNumber of Child Care Providers by CountyPA County Layer

Alaska City Boundaries with Certificates as attachments. Boundaries are based on the actual certificates issued by the Local Boundary Commission.

The map is for providing a visual, geographic relationship to Land Corner Records collected by the department, both through design survey activities and monument preservation activities. It is made available to act as a repository and access point for these records.This dataset is comprised of records collected from MDOT’s project files during the course of a project. Corner certificates are not available for all corners. Surveyors completing research on PLSS records should use this to supplement research conducted at the local county register of deeds office.

This industry comprises establishments primarily engaged in furnishing academic courses and granting degrees at baccalaureate or graduate levels. The requirement for admission is at least a high school diploma or equivalent general academic training. Instruction may be provided in diverse settings, such as the establishment's or client's training facilities, educational institutions, the workplace, or the home, and through diverse means, such as correspondence, television, the internet, or other electronic and distance-learning methods. The training provided by these establishments may include the use of simulators and simulation methods.