Home - NYCPlanning/db-factfinder GitHub Wiki

Welcome to the db-factfinder wiki!

In the following pages, you will find documentation about the methodology used to create the data driving the Population Fact Finder application. The package we've created for this purpose serves other purposes, too, such as calculating ACS data for various community district geographies for the community profiles dataset.

• Calculating Estimates, MOEs, and CVs, which relies on:
  • Parsing metadata
  • Downloading raw data from the API
  • Transforming census variables into PFF variables
    • Which in some cases requires computing medians from binned data
  • Aggregating smaller geographies into larger geographies
    • Occasionally with the additional step of converting 2010 geographies into 2020 geographies
• Calculating Percent Estimates and Percent MOEs
• Cleaning, formatting, and rounding the results