Where do we find data for our GIS applications? This lesson will focus on the data sources needed to conduct GIS analysis for siting of electric transmission lines. Data is available from many sources including federal, state, and local government data, open source data, free data made available by private companies, and fee-based data sources. Though data is available from these sources, it may not be easy to find or the data quality may not be appropriate for use in a particular siting project. We will explore data sources in the public domain, what types of data are available and how to obtain this data for use in GIS applications. You will apply what you learned about metadata in Lesson 7 to determine the data type, the coordinate system used, the scale, the accuracy and the source of the data.
The goal of this lesson is to give you practical experience finding and downloading data specific to evaluating the environmental components of the transmission line siting process. By the time you complete this lesson, you should be able to:
identify the types of data that are available;
identify sources of this information;
choose appropriate data for a given location;
assess the quality of data by reviewing metadata.
This lesson will take us one week to complete. Please refer to the Calendar for specific time frames and due dates. Specific directions for the assignment below can be found in this lesson.
If you have any questions, please post them to our Questions? discussion forum. I will check that discussion forum daily to respond. While you are there, feel free to post your own responses if you, too, are able to help out a classmate.
Siting projects use the full spectrum of GIS data, including vector date, raster data, attribute data, and imagery. As you learned in Lesson 3, vector data is represented by points, lines, or polygons, while raster data can consist of gridded data, such as topographical maps and digital elevation models, attribute data, which describes characteristics of the spatial features, and, finally, aerial and satellite imagery.
There are many sources for obtaining data for siting projects. Many sources of data are available for download, and I would encourage you to explore on your own to find additional sources. A good summary of the topic of GIS data sources can be found at Maps & Geospatial: Geographic Information Systems (GIS) .
The USGS Center for Excellence for Geospatial Information Sciences is a good place to start finding data on the national level. This is a gateway to the National Map, a collaborative effort among the USGS and other federal, state, and local partners to improve and deliver topographic information for the Nation. Raw GIS data can also be accessed and downloaded from the USGS National Atlas Raw Data Download site. Another good starting point for nationwide data is data.gov: geospatial. This is the federal government's "one-stop shop" for finding and using geographic data. The data categories important to siting projects that you can browse and download include:
Why we need it
Soils information plays an important role in both the engineering and the environmental aspects of siting. From an engineering perspective, soils data provides information about soil stability, depth to groundwater, depth to bedrock, and other characteristics that impact the construction of transmission towers. From an environmental perspective, soils information provides information about runoff and erosion potential, wetlands, and groundwater.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
Topographic maps provide much more information than just showing the physical characteristics of the land. In this section of a USGS Topo Quad, not only are the land contours visible, but this map also shows the major roads leading into and out of Bellefonte, PA, the Bellefonte street system, the major structures present, individual residences, railroad tracks, power lines, and much more. Topo maps play a major part in siting electric transmission lines.
Topographic data shows the lay of the land, and topography is a critical criterion in the selection of a proposed route or alternate routes. By reviewing topographical data, siting planners and engineers can identify slope and stability issues, wetlands, stream crossings, etc., to select the most cost-effective route while minimizing impacts to the environment. This data also allows engineers to develop plans to mitigate the environmental impact during the construction phase. For example, in the United States, each stream crossing for temporary roads requires obtaining a state permit. In addition, erosion and sedimentation control plans are required for construction activities that will impact streams.
Do you have any suggestions for additional data sources? Do you know of any international sources? Use the Discussion Forum share your suggestions with the class!
Geologic data provides siting engineers with the information they need to determine earthquake and foundation design requirements for towers. Geologists and environmental scientists use the geologic data to determine what type of rock underlays the route and whether this rock has characteristics that could cause environmental concerns if exposed or disturbed.
Two examples come to mind. The first is an overhead electric transmission line constructed by a major electric utility through Panther Valley in western North Carolina. During the construction of the transmission line, acidic rock was exposed. When exposed to air and water, this rock created acidic runoff impacting otherwise pristine streams. Action by the utility company to mitigate this rock exposure prevented widespread surface water degradation. A second, and more costly, example is the construction of Interstate I-99 through Central Pennsylvania. During I-99 construction in 2003, Pennsylvania Department of Transportation (PennDOT) crews first dug into the sulfur-bearing rock material (pyrite) in the Skytop section, near State College, and then continued to dig, using some of the million cubic yards of pyrite-laced sandstone as fill under the new highway and leaving the rest in spoil piles along the road. Seven years later, in 2010, after I-99 excavation exposed a massive amount of sulfur-bearing rocks, officials said the cost to undo the environmental damage totaled $100 million! Here is just one link to the I-99 problem: NY Times article
Do you have any suggestions for additional data sources, either national or international? Do you have examples similar to the I-99 scenario above? Use the Discussion Forum to share your suggestions with the class!
This aerial photo shows how Dominion Resources use aerial photography to overlay proposed transmission lines. It provides the transmission line siting team with a visual picture of where to position transmission lines to minimize the impact on people and the environment. There are times when the optimum route does have an impact, such as the corridor route depicted in the above aerial.
Aerial and satellite imagery give us a picture in time of what the landscape of the project areas looks like. This imagery provides much more detail than a topographical map. By overlaying planned routes on aerial images, siting planners can readily visualize obstacles that can hinder permitting and construction. For example, population density, structure density, wetlands, water bodies, forest land, agriculture operations, and existing transmission lines are easily identified through an analysis of the aerial imagery. In addition, by comparing current and historical imagery, siting planners can identify projected commercial and residential growth areas and plan alternate routes to circumvent them.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
The impact on water quality from siting corridors is a major concern during construction, and identifying streams and wetlands to be crossed or encroached on during construction is a an important factor in siting decisions. The location of wild and scenic rivers, special stream designations, such as cold water fisheries or trout streams, or impaired streams may require additional permitting during the planning phase of siting and increased monitoring during and after the construction phase. The location of waters used as sources for public drinking water may require additional erosion and sedimentation control permitting and monitoring. The construction of power lines through wetlands or constructing road crossings through wetlands requires a wetlands identification and assessment, and a permit issued by the US Army Corps of Engineers. The permit will outline the mitigation steps to minimize the impact to the wetland.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
The Endangered Species Act of 1973 required the identification and protection of endangered species' critical habitats. As a result, assessments and mitigation plans must be created and approved prior to the construction of transmission lines.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
The map above depicts some of the 21 categories of land use and land cover (LULC) used by the United States Geological Survey. These LULC categories may be used at the state, regional, or local levels. This land use and land cover data was derived from 1970s and 1980s aerial photography.
Land Use and Land Cover (LULC) designations provide general descriptions of the natural and cultural activities taking place within a project area. LULC designations provide the siting planners with information on what type of land use may be in the proposed transmission right-of-way. This information assists the planners in route selection. By comparing current land-use patterns with historic land use patterns, and combining this information with aerial photography, the planners can identify preferred and alternate routes for the transmission lines. Prior to GIS, planners had to manually evaluate this data and the results were subjective. These individual layers of data can be combined easily in GIS and spatially analyzed to arrive at a better understanding of how LULC will impact a proposed transmission line without the uncertainty of manual analysis.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
The picture above shows the Crossrail Tunnel archaeology dig in London, England, where archaeologists, surveying the ground at Liverpool Street station in preparation for Crossrail tunneling, have unearthed hundreds of skeletons on the site of a historic mental health hospital. Opened in 1247, St. Bethlehem hospital was the first institution dedicated to mental health patients and is believed to have led to the coining of the word "bedlam." The site now lies beneath what will be Liverpool Street's new Crossrail ticket hall. There are 20 archaeological digs along the Crossrail route and they have to be completed as part of the planning regulations.
Designated historic sites, burial grounds, and archeological sites are windows into our past. As such, the Federal government passed the Historic Sites Act of 1935 to document and preserve sites of national significance. Many states enacted similar legislation. As a result, this information is incorporated into the siting process to avoid impacting these designated sites.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
Visual resources include such things as national parks, monuments and battlegrounds, Native American burial grounds, historical sites and buildings, cemeteries and even local neighborhoods, just to name a few.
An example of the visual impacts on National Park lands from proposed transmission lines follows, and taken from National Parks Conservation Association:
But views throughout much of the park unit could change substantially if a power company gets its way. Two energy companies—Public Service Electric & Gas (PSE&G) and PPL Electric Utilities—are proposing a serious upgrade to a smaller power line that predates the park, and winds its way through its southern half, crossing the river near the current visitor center. Eighty-foot towers that only occasionally rise above the canopy of maple, ash, and dogwood could soon be replaced by 200-foot towers that would dwarf them. A narrow right-of-way would expand to 300 feet to accommodate the two 500-kilovolt lines, which might require special lighting or bright orange balls for visibility. Asphalt roads would be constructed to provide constant access to what would become a main artery for coal- and nuclear power delivered to New York."
For obvious reasons, the power company’s preferred alternative is to simply traverse the corridor already established in the park—to cover the shortest distance between two points (see map), and to remove the need to purchase privately owned land or claim eminent domain."
The location of a transmission line can impair the line of sight to the visual resources mentioned, or in the instances of local neighborhoods can be a source of unsightly encroachment on neighborhood aesthetics. Transmission lines crossing over or near Federal lands requires a NEPA (National Environmental Policy Act) environmental impact analysis or assessment that includes a visual impact assessment on the Federal lands.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
Here we see protesters outside a Bonneville Power Administration office in Van Mall, Oregon. BPA proposed a new high-voltage transmission line between new substations in Clarke Rock and Troutdale, Oregon. Residents contend BPA should find less populated areas. Current demographic data is essential in minimizing the impact transmission lines have on neighborhoods, and, at times, the best data may still not be good enough.
Demographic data is essential for planning new transmission lines. It is used to make population projections to identify significant growth areas within a utility's service area. Planners then identify locations for the expansion of transmission lines and electric substations. In addition, both current and future projections of population density in a proposed transmission line project area provide the planner with another source of information on where to propose primary and alternate transmission line routes. In many instances, populated areas are the most significant challenge to siting a transmission line. Residents do not want unsightly overhead transmission lines running through or close to their neighborhoods for fear of property devaluation or concerns about the health implications of electromagnetic fields.
Do you have a suggestion or two for additional data sources? Do you know of any international sources? Use the Discussion Forum to share your suggestions with the class!
The two links above take you to Pennsylvania and North Carolina GIS data portals. Once in a state GIS data portal, you have access to many types of GIS information, from simple vector data, such as roadways, to complex raster data in the form of detailed aerial photography. In addition to individual state GIS data portals, make sure you check other state and local sources such as the Department of Transportation, Department of Environmental Protection, and local government GIS data portals.
Sometimes local GIS information is not available from Federal GIS databases, so we need to look elsewhere to find data. Sources for this information can be found on most state, county, and municipal GIS websites. Depending on the level of government accessed, the type and amount of GIS information available will vary, with state GIS websites having the most available data and municipalities having the least, depending on size. Many times, local GIS data may be more up-to-date and more specific to the area you want to study. The combination of federal, state, county, and municipal GIS data sources gives the best opportunity to find the data you need for a specific project.
Do you have a suggestion or two for additional data sources? Use the Discussion Forum to share your suggestions with the class!
This activity will give you the skills to find Internet-based data and information, specifically data that can be downloaded and used for siting projects. The activity will focus on identifying and locating data for your state or region and compiling the data into a spreadsheet.
For this assignment, you will need to record your work in the given Excel Spreadsheet. Your work must be submitted in Microsoft Excel (.xls or .xlsx) or PDF (.pdf) format so I can open it.
If you are having problems, post your questions to "General Questions and Comments: Lesson 8".
Please submit your work to the Lesson 8 - GIS Data Sources drop box no later than Sunday at midnight of Lesson 8 (see our course calendar for specific due date).
This activity is graded out of 10 points
CRITERIA | 5 | 4 | 3 | 2 | 1 | 0 |
---|---|---|---|---|---|---|
Sources | At least 1 source found for each of the 5 categories | At least 1 source found for 4 of the 5 categories | At least 1 source found for 3 of the 5 categories | At least 1 source found for 2 of the 5 categories | At least 1 source found for 1 of the 5 categories | No Internet sources listed |
Required Elements | All 13 required elements provided | 10-12 of the required elements are provided | 6-9 of the required elements are provided | 2-5 of the required elements are provided | 1 of the required elements is provided | None of the required elements are provided |
The siting of overhead electric transmission lines, underground pipeline, new power plants, and even new highways require many types of information for the analysis in selecting a final corridor or site. Historically, this data had to be gathered manually if it was available. With the advent of computers, GIS software, and the Internet, this data is abundant and readily available. This lesson identified data needs, why it is needed, and where to find it. The exercise of finding data for your particular needs laid the foundation for how to acquire data and catalog those data sources for your future reference and use.
You have finished Lesson 8. Double-check the list of requirements on the first page of this lesson to make sure you have completed all of the activities listed there before beginning the next lesson.
If you have anything you'd like to comment on, or add to, the lesson materials, feel free to post your thoughts in the Questions? Discussion Forum.