Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Durham North Carolina, has an online GIS mapping utility that allows the user to do a variety of spatial analyses with the city's data. Including

image text in transcribed

Durham North Carolina, has an online GIS mapping utility that allows the user to do a variety of spatial analyses with the city's data. Including performing queries. To work with this tool, go to http//maps2.roktech.net/in the upper left-hand corner there are several tools (such as zooming and panning) to get oriented to the GIS data. The tool with the hammer icon allows you to build SQL queries of the data. Click on this icon and a new set of options will appear on the right-by choosing the lab for Query Builder, these will allow you to construct SQL queries of the GLS. First, select an available layer (for instance, select streamwater watersheds). Second, select an attribution query for instance, double-click on River). Third select as operator (for instance, choose equals "=" Click on the Get Unique Values button and you the available values appear to fish the SQL statement (for instance, choose CAPE FEAR). Your SQL statement will appear in the box (in this example, it should read: RIVER - CAPE FEAR). To run the SQL query, click on the Execute button. All records meeting your query will be retrieved (in this case, all streamwater water watersheds related to the Cape Fear river). The selected watersheds will be highlighted on the map. While the records (and the attributes that go along with them) will be displayed in a spreadsheet at the bottom of the screen. Investigate some of the other available data layers and the types of queries that can be built with them. Durham North Carolina, has an online GIS mapping utility that allows the user to do a variety of spatial analyses with the city's data. Including performing queries. To work with this tool, go to http//maps2.roktech.net/in the upper left-hand corner there are several tools (such as zooming and panning) to get oriented to the GIS data. The tool with the hammer icon allows you to build SQL queries of the data. Click on this icon and a new set of options will appear on the right-by choosing the lab for Query Builder, these will allow you to construct SQL queries of the GLS. First, select an available layer (for instance, select streamwater watersheds). Second, select an attribution query for instance, double-click on River). Third select as operator (for instance, choose equals "=" Click on the Get Unique Values button and you the available values appear to fish the SQL statement (for instance, choose CAPE FEAR). Your SQL statement will appear in the box (in this example, it should read: RIVER - CAPE FEAR). To run the SQL query, click on the Execute button. All records meeting your query will be retrieved (in this case, all streamwater water watersheds related to the Cape Fear river). The selected watersheds will be highlighted on the map. While the records (and the attributes that go along with them) will be displayed in a spreadsheet at the bottom of the screen. Investigate some of the other available data layers and the types of queries that can be built with them

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems A Practical Approach To Design Implementation And Management

Authors: THOMAS CONNOLLY

6th Edition

9353438918, 978-9353438913

More Books

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago