Problem 2 IS 380
You work for the NYC planning office. You have gotten the green light to start building a new library. Your question for
this assignment – what community districts/PUMA are in need of a library?
To an
...
Problem 2 IS 380
You work for the NYC planning office. You have gotten the green light to start building a new library. Your question for
this assignment – what community districts/PUMA are in need of a library?
To answer this question you will want to calculate the library density in each community district.
In a field you will divide the number of libraries per community district/PUMA by the total population of the community
district/PUMA. Please use the field Race01_E in b_pumas_2013acs2 as the total population of the community
district/PUMA.
Tasks
a) Find how out how many libraries are in each community district
b) Join the attribute data to shapefile with amount of libraries per community district
c) Calculate the density of each community district using the total population – IMPORTANT – MAKE SURE TO
MULTIPLY BY 100 in your Field Calculation
d) Find the Community districts that are library rich and library poor.
Tools you will use:
a) Join Attributes based on a location
b) Attribute Join in Properties
c) Edit
d) Field Calculator
e) Sorting Fields
Layers you will need: (Please find this in the geo-database we used in the tutorial)
a) b_pumas_2013acs2
b) a_libraries
c) b_2013acs_lookup
d) a_pumas2010
Trouble Shooting:
a) 1Make sure the field you create in field calculator ‘output field type,’ is ‘decimal number (double),’ and the
‘output field width,’ is at least 10.
b) Please remember to multiply by 100 when you use the field calculator to make density – or else it won’t
work!
c) Mind your order – you should be joining the libraries to your community districts before you join the
attribute table.
Final Answer: a) A snip of the attribute table that contains the density of libraries in community districts. Open
your attribute table, make sure this category is accurate and take a snip.
b) List the 5 most needy community districts in terms of library density and 5 least needy community districts in
terms of library densit
[Show More]