Extract Features from Population Data

[eclee25]

Start with the Population data in the /Data Sets/Population by Census Block/ folder in Dropbox.

Write a script that cleans and aggregates this data to produce feature data tables for population at the census block, ANC, and ward levels.

For reference, you can read about the GEOID field here.

You can find examples on the Feature Dataset Format tab in this document

Note that this issue depends upon the spatial crosswalk from Issue #23

Input: CSV files with data for each given year and spatial scale (census block, ANC, and ward)

Output: A CSV file with

-1 row for each feature id, year, and spatial unit -The census block dataset should include the following columns:

feature_id: The ID for the feature, in this case, "population" feature_type: Leave blank feature_subtype: Leave blank year: The ISO-8601 year of the feature value week: Leave blank census_block_2010: The 2010 Census Block of the feature value value: The value of the feature, i.e. population

• For the ANC and ward datasets, replace the census_block_2010 column with anc_2013 or ward_2012

When you are finished Submit a pull request on GitHub (or upload your scripts) Upload any files to Dropbox

Need more information? Flag Jason or Elizabeth, or ask your question in the comments below and we'll respond as soon as we can!

[catalinalupu]

Completed - Uploaded to Dropbox by Tim Martin.