search

DataKind-DC / audubon-cbc

For the bird counters
MIT License
11 stars 18 forks source link

Add Ecological Data to Working Data #53

Closed rectheworld closed 4 years ago

rectheworld commented 4 years ago

name: Add Ecological Data to Working Data about: Complete items in issue 48

High Level Changes

Added new notebook 1.3-rec-connecting-fips-ecosystem-data.ipynb

The steps done in this notebook are: Steps or Proceedures in the notebook

  1. Load in the cleaned data
  2. Identify the unique Lat Lons present in the cbc circle locations OPTION 1: Send the unique lat lons though a census API to find the block and county fips OPTION 2: Load in the saved census FIPS data
  3. Load in Ecological Data from Nathan
  4. Create a key to based on the lat long of the cbc circles to merge the station matched data with the ecological data
  5. Merge in the census FIPS data, the cbc ecological data, and the noaa station ecological data
review-notebook-app[bot] commented 4 years ago

Check out this pull request on  ReviewNB

Review Jupyter notebook visual diffs & provide feedback on notebooks.

Powered by ReviewNB

rectheworld commented 4 years ago

@ijd5004

I have made the changes you suggested in the last comment. On the data input, the file notebook uses two files as inputs:

PATH_TO_CLEAN_CBC_DATA = "../data/Cloud_Data/1.0-rec-initial-data-cleaning.txt" PATH_TO_WORKING_DATA = "../data/Cloud_Data/1.2-ijd-fetch-circle-elevations_20200502155633.csv"

The output data in 1.3-rec-connecting-fips-ecosystem-data.csv (which should be in the cloud) comes from working off of the 1.2 data contains the elevation data. Can you confirm that the 1.3 data has the elevation and other fields you expect?