Lab #8: Database Management & Queries

1. What are the primary functions of a database management system?
    They increase data quality and independence, prevent redundancy, create centralized control,
    and allow multiple users so that data can be shared.
2. What is a one-to-one relationship between tables? A many-to-one?
    A one-to-one relationship between tables is when, for example, table 1 has a column of country
    names and table 2 has records of the names of the capitals; every country has only one capital that
    means that if the tables are joined every country will be joined to only one capital. Tha is a one-to-
    one relationship.

    In a one-to-many or many-to-one relationship is when one table has records for types of government
    and a second table has records for country names. In this case the tables can only be related because
    more than one country might have the same type of government. One record on table one may apply to
    more than one record on table two.

3. Why are relational databases so popular (i.e. what are the benefits)?
    Tables can be joined together using common row or column values, they allow for query flexibility,
    they coordinate data stored in a network database. 
  4.a. What is the Data Type of the LAND_USE field in the Landuse feature class? Text.

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

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)? LU_DESCRIP; LU_GENERAL; LU_TYPE; and, SqMiles.

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

F.

Lab #7: Map Design & Text

Chapter 7:

1.  Layer attribute tables

2. The most efficient way is by using the Label tool under the New Text Tool on the drawing toolbox.

3. No

4. Select Elements

5. Map and Database

Chapter 18:

1. True

2.  Yes.

3. ArcMap dialog box or File Menu and click New.

Q3: A map layer and its data contents can be saved and shared using a 'layer package'. A layer package is saved as a special file (.lpk) that contains the map layer, a copy of its data, and an XML file that has a brief description of the layer. Layer packages contain all the information necessary for users to put them to work in their own ArcGIS software installation. They are supported by ArcMap, ArcGlobe, and ArcGIS Explorer.

Layer packages make it easy to share a map layer display. For example, users of ArcGIS Explorer can add a new layer to their maps and use the information that you shared with them as a layer package.

Q4: 46,1522

Q5: 3,694,820

Q6: Hyperlinks have to be defined before using the Hyperlink tool, they can be one of three types:

a. Document: When you click a feature with the hyperlink tool, a document or file is launched using the application with which that file type is currently associated.

b. Uniform resource locator (URL): When you click a feature with the Hyperlink tool, a Web page is launched in the default Web browser.

c. Macro: When you click a feature with the Hyperlink tool, a value is sent to a macro. This option lets you create customized hyperlink behavior.

4. Double click on the symbol then select the Star symbol and change the size/color.

5. Double click the symbol and change color or right-click on the symbol.

Chapter 19

1. Set up page size.

2. Because the layout view had scaled up to the page size.

3. Scale and Units, Numbers and Marks, and Format.

4. To avoid confusion since it gives the accurate clear view of the layout page.

5. It's because the data view views only one layer at a time; on the layout view, you could customize the page as you want it to look. The data view does not show the legend, title, nor the scale bar.

Part 2: Creating Thematic Maps

Q1: Numerical data is classified into categories, the categories are shaded. Polygons are often based on politically defined features.

Q2: Use ArcGIS Desktop Help. Describe their benefits.

Layer files include all map display properties for symbolization and labeling. Layers usually do not contain the actual datasets. Instead, they reference a data source that resides in another location.

Lab #6: Symbolization and Classification

1. Symbology can be influenced by scale in a couple of ways, if you are using a map of large scale you may want to lable important details but if you use the same map on a small scale, those specific details will not matter as much because you are now viewing a much larger strech of land. On the other hand, if you are labeling a small scale map you will not need those labels if you zoom in to a specific location.

2. A layer's symbol color can be changed by clicking on the colored box that displays underneath the layer title on the TOC, or it can be changed by right clicking on the layer and selecting properties and then clicking on the symbology tab.

3. Graduaded symbols can be accessed by right clicking on the layer that you wish to modify and selecting properties, then you select the symbology tab. On the 'show' box to the left you select 'quantities' and then 'graduated symbols.'

4. 5 symbology styles:

    a  Environmental

    b Caves

    c Petrolium

    d Survey

    e Weather

5. You can save the symbology as a layer file and you must also save the data source it references.

6. According to Ormsby, pyramids are versions of a raster data set. They improve the drawing speed of a raster layer as you zoom in and out.

7. You can temporarily change a layer name by right clicking on it and renaming it.

8. Normalization: dividing one attribute by another to find the ratio between them.

9. Dot density maps can be misleading because dots are randomly paced on the map so they don't truly show where exactly the density is.