Geography Reference
In-Depth Information
pipes of diameter 60 inches. Right-click the Shape_Length column heading and pick Statistics.
From the Selection Statistics of Sewers window, determine the total length, to one decimal place,
of 60-inch pipe. ________ meters. Dismiss the window. On the table window using ToolTips, find
the Switch Selection icon. Press it. What is the total length of 45-inch pipe? _______________.
Let's examine how you can get this information into a report and then onto the map.
30.
Clear all selections using the Clear Selection button on the table menu. Right-click the
DIAMETER heading and pick Summarize. In Box 1 the field to summarize should read
DIAMETER. Skip box 2. Accept the default output table name, Sum_Output.dbf, but double-
check that the output location path is your Map_Making folder.
18
Click OK. When asked if you
want to add the results table in the map, choose Yes. Open the table.
31.
The new table, Attributes of Sum_Output (the Sum refers to summary, not to sum, as in total), tells you
the numbers of segments but little else. Let's try again. Close the table and remove it from the T/C.
32.
Make sure the Sewers attribute table is open. Again, right-click over the DIAMETER heading
and pick Summarize. This time, in box 2, expand Shape_Length and check Sum. Continue as
before, add the table to the map, and open it. This time you see that you get an additional field:
Sum_Shape_Length. Check to see that the numbers you wrote above are the same as those in
the table. Write the name of the table here: _______________________________.
33.
Notice that the sum (total) of the Shape_Length column numbers gives the value of the lengths
to thousandths of a meter. While quite precise, this seems unlikely to be accurate and is
certainly useless. We can fix that by chopping off the decimal part with something called the
Field calculator. Right-click the Sum_Shape_Length column and pick Field Calculator. Ignore the
warning (since you can always reproduce the table if you make a mistake). In the Field Calculator
window click INT(). The expression INT() should appear in the codeblock box at the bottom of
the dialog. Your cursor should be inside the brackets of the INT expression. (The INT function
produces integers by removing the decimal fractions of the argument.) Double-click Sum_Shape_
in the Fields box. When you click OK, the numbers in that column will become integers.
Now that you have a table that contains the needed information in a reasonable form, you may make
a report. ArcMap has considerable report making capability. We will create only the most elementary
example. When you finish this section, you will at least know that report generation capabilities exist.
34.
Click View > Reports > Create Report to bring up a Report Wizard. As the wizard progresses you
will be presented with a series of six questions:
Which fields do you want on your report?
❏
Do you want to add any grouping levels?
❏
Which fields do you want sorted on your report?
❏
How would you like to layout your report?
❏
What style would you like?
❏
What title do you want for your report?
❏
18
Note: if you have to change the path, be sure to Save as type “dBase Table.” The default is a “File and Personal
Geodatabase table” and since you're outputting to a folder, a File and Personal GDB table won't work.
Search WWH ::
Custom Search