Lab #8: Database Management & Queries

I. Read Bolstad Chapter 8 and answer the following questions. 


1. What are the primary functions of a database management system? 
Prevent redundancy, increase data quality and independence, create centralized control and allow multiple users.


2. What is a one-to-one relationship between tables? A many-to-one? 
One-to-one is when one row in one table is linked to only one row from another table and one-to-many is when one row in one table is linked to many rows in another table.


3. Why are relational databases so popular (i.e. what are the benefits)?
They allow ad hoc requests/queries of the database, links are not preset, data is stored in separate tables and combined when needed for a query or report.


II. AFTER completing Ormsby Chapters 8 & 9, complete the following exercise.

4. 
a. What is the Data Type of the LAND_USE field in the Landuse feature class?
Text/String

b. What is the Data Type of the LAND_USE field in the LanduseInfo.dbf table?

Text/String

5.

a. Join the LanduseInfo.dbf file TO the Landuse feature class. Explore the table. What are the new fields that have been joined (appended)?

objectid1, Land_use, LU_DESCRIP, LU_GENERAL, LU_TYPE, SqMiles, Acres, Shape_Leng, Shape_Area.

e. How many total acres of Open Lands (including Open Land Uses) exist in this new feature class? 92236.77acres

Due: Wednesday, October 27th, 2010

Lab #7: Map Design & Text

Part 1: Complete Ormsby Chapters 7, 18 & 19 and answer the following questions.

I. Chapter 7

1. The information used for dynamic labels comes from where?

The layer Information

2. You are making a map of Los Angeles and have a point layer that shows all the cities in the region. However, you want to show city names for only 3 cities. What is the most efficient way to achieve this?

Clicking on the A in the drawing toolbar and selecting the label button. Then click on what you want labeled and the label will pop up.

3. Can you manually adjust the position of dynamic labels?

Yes, click on the label and drag.

4. Which tool needs to be selected to adjust graphics?

The select elements arrow from the drawing toolbar.

5. What are the two annotation types?

Geodatabase Annotation and Map Document Annotation

II. Chapter 18

1. You can create your own ArcMap templates.

a. True
b. False

2. If you create a map based on an ArcMap template file (.mxt), can you save it as an .mxd file?
Yes

3. Describe two different ways you can access map templates.
One way is when ArcMap opens select the 'A template' option and click OK. The other way is to select the change layout which is the far right button in the Layout toolbox.

4. You are adding five point graphics to your map. Instead of having to change the properties for each one after you add it, you want to set the default point symbol to a size 12 purple star. How do you do this?

Double click on the symbol and select the star icon and change the color in the color box to purple.

5. Describe two different ways you can change the color of a graphic circle.

One way is to go to properties in the layer and in teh sybols tab select the symbol and change the color or double click on the circle in the table of contents and change the color there.

III. Chapter 19

1. What is the first thing you should always do before setting up your map layout?

First thing to do is set the orientation of the paper to either landscape or letter by selecting File>Page Setup

2. Why is the scale different in the data view versus the layout view?

The data view is used to edit so it lets you zoom in and out without changing it in the final product (data view).

3. What are three customization options available for the scale bar?

1. Division Value 2. Number of divisions 3. Division Units

4. Why is it important to use the 1:1(Zoom to 100%) button?

It makes it possible to always view the whole picture instead which makes it easier to evaluate and edit the layout view.

5. Explain how a graphic added to your data view would respond differently compared to a graphic added to the layout view when navigating around your map.
It is connected to the map in data view so when you go to layout view the graphic will not move seperately; it is connected to the map you put it in in data view. Where if you add a picture in layout view it is able to move around by itself.

Part 2.

Q1: Choropleth maps are a type of thematic map. Define what we mean by a choropleth map.
 Data with numeric data is put into groups and shaded to show the differences and to the eye can show the larger numbered data compared to the smaller numbered data through differnet color shades.

Q2: Read about layer files in the ArcGIS Desktop Help. Describe their benefits.

References geographic data stored on disk and references data supported by ArcCatalog. This is one of the main benefits because layer files can read almost any source which is very helpful. Layer files are said to be "cartographic view of your geographic data."

Q3: How do layer files differ from layer packages?
Layer files reference geographic data stored on disk and reference most data sources. Where  Layer packages is a ready-to-use file containing one map and its data.

 Q4: What is the population of City of Long Beach for the year 2000?
461,522

Q5: What is the population for the City of Los Angeles in 2000?
3,694,820

Q6: Using the ArcGIS Desktop Help, describe the three types of hyperlinks that can be created. 　
Document-this kind will send you to a document, Univorm Resource Locator (URL)-will launch a browser and send you to a web site, and Macro-lets you customize hyperlink behavior.

Lab #6: Symbolization and Classification

I. Complete Ormsby Chapters 5 & 6 and answer the following questions.


1. In your own words, describe how symbology can be influenced by scale.
Symbology is only effective depending on the scale. A small scale map can't contain every detail so if there is lots of symbology used it will keep just clutter the map which makes a useless map.

2. What are two ways (one direct and one indirect) to access a layers symbol colors so that they can be changed?
One way is to right click to open a color scheme table. The other way is to left click which opens the symbol selector window.

3. How would you access the graduated symbols classification option?
Double click on the layer wanted for accessing the Graduated Symbols and select the Symbology tab and under the Show box select Quantities and that is where you will find Graduated Symbols.

4. What are 5 other symbology styles (in addition to ‘Conservation’) that are available to customize your features?
3D Buildings, 3D Trees, Civic, Public Signs and Weather

5. How could you permanently save layer symbology for use later on?
Right click on the layer and select the Save As Layer File and then choose a place and name the file.

6. How can pyramids help raster data display faster?
Pyramids make raster data display faster by using less resolution when zoomed out and more resolution as you zoom in which makes it much easier for ArcGIS to draw.

7. How could you quickly and temporarily change a layer name to aid display in the Table of Contents?
Double click on the layer and click the Generals tab and type the new name in the Layer Name box.
8. What is normalization? Give an example of when it would be used. "Dividing one attribute by another to find the ratio between them. If you normalize the population by income it gives you income per capita." 

9. How could dot density maps be misleading?
The distribution of dots can be random which gives the impression of where something (whatever the dot's representing) is located when that might not be the actual location.
II. AFTER

Due Wednesday, October 6th, 2010.