Data Extraction and Analysis Using Free and Available Software
Introduction and Purpose
The use and manipulation of raster data is an integral part of GIS, and can play an important role within urban planning. This tutorial will demonstrate how to extract and utilize available raster data for all areas where data may not already be available (eg: rural towns). The tutorial will demonstrate the capabilities of open source software, and the many possibilities from the perspective of a planner.
Software
The links and descriptions for the software used for this tutorial are as follows:
- QGIS
- Version 3.4.2 'Madeira'
- QGIS is a free and open source GIS. This means that is a powerful tool that allows for the manipulation and analysis of spatial data, and can be downloaded by everyone.
- Download available here.
- Download QGIS version 3.4.3, 64bit.
- Google Earth Pro
- Software by Google that allows geospatial data to be extracted and manipulated.
- Available for download here.
- Google Sheets or Microsoft Excel
- Both Google and Microsoft have excellent software for spreadsheets. While Google Sheets is free, the majority of people have access to Microsoft Excel, and as such was used for this tutorial. Instructions in this tutorial apply for both Sheets and Excel.
- 1. Google Sheets is available here. Google account is required (free), and there is no download necessary.
- 2. Microsoft Office is available here. Must be a student at Carleton University to qualify. If you do not have access this is not a problem, as Sheets functions very similarly.
- TCX Converter
- Free conversion software that allows for the rendering of altitude data from Google Earth data (.kml). This allows us to create a point cloud within QGIS.
- Download TCX converter here.
Getting Started
To begin, you must ensure that all software is downloaded and functional. Try running everything at least once before continuing. Once this is done, open up Google Earth Pro and locate Ottawa, or the area you would like to work with. The tutorial will be completed in the Lowertown/Sandy Hill neighbourhoods of Ottawa, found at the coordinates: 45°25'45.88"N, 75°41'7.40"W. This can be copied and pasted into the Google Earth search bar, and will put you between the two neighborhoods.
(Image)
