Question 1
What are ways to add tables and layers?
- Layers and tables can be dragged directly from the table of contents of ArcCatalog to the map display of ArcMap.
- Layers and tables can be added via the “Add Data” button in ArcMap.
- Layers and tables can be added by right-clicking the topmost “Layers” icon and selecting the “Add Data” symbol.
- Layers and tables can be added by selecting the “File” menu then selecting the phrase “Add Data” option.
What is the best way to make all features in both the files of ArlingtonBND.shp and the Census2000_BlkGrp_Tarrant.shp visible?
- I placed the “ArlingtonBND.shp” layer above the “Census2000_BlkGrp_Tarrant.shp” layer, made the “ArlingtonBND.shp” layer 50% transparent, and shaded the “ArlingtonBND.shp” layer a little darker than the “Census2000_BlkGrp_Tarrant.shp” layer.
What would you use as the common attriburte to associate the non-spatial table with the shape file attribute table?
- I used the “LongBlkGrp*” in the “Tarrant_BlkGrp90_10.dbf” table and the “LBLKGRP_ID2” in the “Census2000_BlkGrp_Tarrant.shp”as the common attribute because they are the same data type and have the same length.
How many people were in Tarrant County and in the City of Arlington in 2000? (Note: make good use of the Statistics tool and the Selection tool)
- In 2000, the city of Arlington had 390,692 Texans while Tarrant County had 1,446,219 Texans. (The intersect method was used to derive the above numbers). Figures 1 and 2 show the statistics window for the City of Arlington and for Tarrant County in the year 2000; respectively.
Figure 1: Population statistics for the city of Arlington, Texas in 2000
Figure 2: Population statistics for Tarrant County, Texas in 2000
Question 5
How many people will be in Tarrant county and in the City of Arlington in 2010?
- In 2010, the city of Arlington is expected to have 482,204 Texans, while Tarrant County’s population is estimated at 1,785,752 Texans. (The intersect method was used to derive the above numbers). Figures 3 and 4 show the statistics window for the City of Arlington and for Tarrant County in the year 2010; respectively.
Figure 3: Population statistics for the city of Arlington, Texas in 2010
Figure 4: Population statistics for Tarrant County, Texas in 2010
Step 6
Calculate the population growth rates of Tarrant county and Arlington between 2000 and 2010 and compare the growth rates.
The population growth rate, from 2000 to 2010, for the city of Arlington is 23.423 % [482,204-390,692)/390,692].
The population growth rate from, 2000 to 2010, for Tarrant County is 23.477 % [(1,785,752-1,446,219)/1,446,219]
Step 7
Create a thematic map showing the spatial pattern of population distribution in Tarrant County in 2000 and another one in 2010. Discuss the change in spatial pattersns if there is any.
- The two thematic maps are identified by data layers, “Tarrant POP 2000” and “Tarrant POP 2010” and shown in Figures 5 and 6; respectively. By activating one layer and then the other, it is observed that the population is growing West of Fort Worth along interstate 30, North of Fort Worth along interstate 35-W, and Southeast of Fort Worth along US 287.
- Another way of determining the spatial growth pattern is to take the Tarrant POP 2010 and divide it by POP00 (normalization). This will show quite clearly the growth patterns…See Figure 7.
Figure 5: Population of Tarrant County, Texas in 2000
Figure 6: Population of Tarrant County, Texas in 2010
Figure 7: Population of Tarrant County, Texas in 2010 normalized against its population in 2000
Question 6
How many hotels are physically located in Tarrant County in the address table?
By right-clicking on the “Tarrant_Hotels.dbf” table, selecting “open”, and observing the number of records, I determined that there are 172 hotels physically located in Tarrant County.
How many hotels are physically located in the city of Arlington in the address table?
- By right-clicking on the “Tarrant_Hotels.dbf” table, selecting “open”, right-clicking on the “LOC_CITY” field heading, selecting “Sort Ascending”, and then selecting all the records which show “Arlington” as the city; I determined that there are 35 hotels in the city of Arlington.
How many hotels have been geo-coded in Arlington and Tarrant County, respectively? Manually geo-code the rest of the unmatched hotels in Arlington.
- I created an address locator which uses the “US Streets with Zone” template (style). Table 1 shows the results of applying this address locator to the “Tarrant_Hotels.dbf” file.
Table 1: Initial geo-coding matching results.
Matched 98 (57%)
Tied 1 (1%)
Unmatched 73 (42%)
Out of the 98 matched hotels in Tarrant County, only 20 were matched hotels in Arlington. I continued to manually rematch the data until reaching a 99% match rate. The remaining, unmatched hotel address corresponded to a hotel outside the Tarrant County boundary. See Figure 8.
Figure 8: Final re-matching results
Question 9
How many geo-coded hotels have the room capacity of equal or greater than 50 rooms in Tarrant County?
- I made sure that the map display showed the Tarrant County layer, the Arlington boundary layer, the major highway layer, the roads layer, and the hotel locations. In addition, I made sure that nothing was selected. I then clicked on the “Selection” menu, then “Select by Attributes”. This brought up the “Select by Attributes” window. I then typed in the following equation in the bottom window.
- "LOC_RM_CAP" >= 50 (See Figure 9)
- The above equation selects all hotels in Tarrant County which have a room capacity (LOC_RM_CAP) equal to or greater than (>=) 50 occupants. I then go to the table of contents and right click the “geo-coding results” layer and select “Open Attribute Table”. The number of hotels which meet the criteria in the equation is shown at the bottom of the table. The number is 93 hotels. See Figure 10.
Figure 9: “Select by Attribure” window showing equation used.
Figure 10: Attribute table showing equation results.
Question 10
How many hotels with a room capacity of 100 rooms or more are within the city of Arlington?
- I made sure that the map display showed the Tarrant County layer, the Arlington boundary layer, the major highway layer, the roads layer, and the hotel locations. In addition, I made sure that nothing was selected. I then clicked on the “Selection” menu, then “Select by Attributes”. This brought up the “Select by Attributes” window. I then typed in the following equation in the bottom window.
- "LOC_RM_CAP" >= 100 AND "LOC_CITY" = 'ARLINGTON' (See Figure 11)
- The above equation selects all hotels in Tarrant County which have a room capacity (LOC_RM_CAP) equal to or greater than (>=) 100 occupants AND the “LOC_CITY” term is equivalent to “Arlington”. I then go to the table of contents and right click the “geo-coding results” layer and select “Open Attribute Table”. The number of hotels which meet the criteria in the equation is shown at the bottom of the table. The number is 11 hotels. See Figure 12.
Figure 11: "Select by Attribute" window showing equation used.
Figure 12: Attribute table showing equation results.
Question 11
How many hotels selected in Question 10 are within 0.5 miles from major highways?
- With the above results still showing on the display panel, I clicked on “Selection” from the menu bar, then clicked on “Select by location”. The select by location window appears. In this window, I chose the following configuration:
Figure 13: "Select by Location" window showing options used to determine the number of hotels within the city of Arlington which are 0.5 miles from a highway.
Select from the currently selected features in
Geocoding Result: Geocoding_Result_4
- Are within a distance of
- Tarrant_Highways_2009
- Apply a buffer to the features in Tarrant_Highways_2009
- 0.500000 Miles
Figure 14: Results for Question 11.
Question 12
What does “select features from” mean?
- “Select features from” means that the program will take into account ALL features in the layer when processing the request.
What does “select from currently selected features from” mean?
- “Select from currently selected features from” means that the program will take into account only the features which are currently selected in the layer when processing the request.
Report created, saved as a PDF, and printed.
Posts
No comments:
Post a Comment