Skip to content

Product: TDB

Damon McCullough edited this page Oct 2, 2023 · 17 revisions

Template Database (TDB)

[ADD OVERVIEW]

[ADD MINIMAL DATAFLOW DIAGRAM]

Build outputs

Shapefiles have and separate file for each geometry type and may have shorter column names.

Primary tables and files

templatedb - .csv, .shp

Each row is an interesting place to go to.

Other tables

templatedb_boroughs - .csv

Each row is a Borough.

Source data

See product's recipe file.

Data Dictionary

Table Name A

column_a

  • Display Name: Column A
  • Description: Description of the values in this column and their meaning.

column_b

  • Display Name: Column B
  • Description: Description of the values in this column and their meaning.

Table Name B

column_a

  • Display Name: Column A
  • Description: Description of the values in this column and their meaning.

Product design

product themes

  • interesting places to go to
  • leisure
  • nature
  • history

outputs of interest

  • where is it all?
  • counts and density by neighborhood
  • calculations/metrics like
    • how far is the place from the shoreline?
    • is the place in a ___ area?
    • how much green space area is in my Borough/Community District?

source data of interest

  • geometry types: Point, Polygons, maybe Lines
  • things: libraries, landmarks, gardens, shoreline
  • areas: ???
  • neighborhood geographies
    • Boroughs
    • Community Boards