NYCPlanning / ae-data-flow

Data pipelines to populate Application Engineering databases
1 stars 0 forks source link

load source data for Zoning API DB #14

Closed damonmcc closed 3 months ago

damonmcc commented 3 months ago

resolves #3

This uses a sql script to create tables for source data and populate them using csv files downloaded from Digital Ocean.

An unfortunate consequence of this approach is that we list all of the columns in the csv files and they must be listed in the same order as in the file.

screenshots

Running the terminal command documented in the README:

Screenshot 2024-03-14 at 5 39 27 PM

Populated pluto table in the database:

Screenshot 2024-03-14 at 5 40 37 PM