issues
search
NYCPlanning
/
db-safegraph
SafeGraph ETL
4
stars
1
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Format year week as IYYY-IW for all weekly datasets
#47
mgraber
closed
3 years ago
0
Split weekly state by qtr and move qtr to helper in weekly county
#46
mgraber
closed
3 years ago
0
Add devices tables for all trips tables
#45
SPTKL
closed
3 years ago
0
41 patch
#44
SPTKL
closed
3 years ago
1
MSCK REPAIR TABLE after new partition added for all tables
#43
SPTKL
closed
3 years ago
0
partition core_poi by month
#42
SPTKL
closed
3 years ago
0
Split POI tables by quarter
#41
mgraber
closed
3 years ago
2
WIP: Partition inputs
#40
mgraber
closed
3 years ago
0
adding dt partition for weekly patterns
#39
SPTKL
closed
3 years ago
0
Client Code Sample
#38
SPTKL
closed
3 years ago
0
Loop through quarters
#37
mgraber
closed
3 years ago
0
adding partition to social distancing by date
#36
SPTKL
closed
3 years ago
0
adding compression and upload
#35
SPTKL
closed
3 years ago
0
lookup tables
#34
SPTKL
closed
3 years ago
2
Limit sectors
#33
mgraber
closed
3 years ago
1
Remove limits
#32
mgraber
closed
3 years ago
0
Document Athena queries
#31
mgraber
closed
3 years ago
0
Cli rewrite
#30
SPTKL
closed
3 years ago
0
Add daily_zip_poivisits_by_sector
#29
mgraber
closed
3 years ago
0
Add scripts to create initial social distancing tables
#28
mgraber
closed
3 years ago
0
Add python scripts to create initial POI tables
#27
mgraber
closed
3 years ago
0
Request: daily county level, US counties -> NYC counties -- Dara
#26
SPTKL
closed
3 years ago
2
Adding a python function that calls athena and generates output
#25
SPTKL
closed
3 years ago
1
Use a single version of core_poi
#24
mgraber
closed
3 years ago
1
Table: patterns/safegraph_daily_borough_poivisits_by_sector
#23
mgraber
closed
3 years ago
1
Table: social_distancing/weekly_state_trips
#22
mgraber
closed
3 years ago
1
Table: social_distancing/safegraph_weekly_county_trips
#21
mgraber
closed
3 years ago
4
Table: patterns/safegraph_daily_nyc_poivisits
#20
mgraber
closed
3 years ago
1
Python helper functions in recipes/_helper to standardize Athena processes
#19
SPTKL
closed
3 years ago
1
Table: patterns/safegraph_weekly_nyc_poivisits
#18
mgraber
closed
3 years ago
1
Create a dockerfile to standardize execution environment
#17
SPTKL
closed
3 years ago
1
setting up project folder structure
#16
SPTKL
closed
3 years ago
0
Add weekly patterns init and sync
#15
mgraber
closed
3 years ago
1
Move pre-Athena queries/runners out of master
#14
mgraber
closed
3 years ago
0
Source: Point of interest
#13
AmandaDoyle
closed
3 years ago
1
code snippet for athena
#12
SPTKL
closed
3 years ago
5
adding s3 sync script
#11
SPTKL
closed
3 years ago
0
WIP: load core poi data
#10
mgraber
closed
3 years ago
0
adding script for running big table
#9
SPTKL
closed
3 years ago
0
Write ETL for core-poi
#8
mgraber
closed
3 years ago
1
Create a pivoted table of to-from trip counts
#7
mgraber
closed
4 years ago
0
Potential enhancement: split by weekday and weekend
#6
mgraber
closed
3 years ago
0
Create social distancing aggregate tables
#5
mgraber
closed
4 years ago
0
Old weekly patterns
#4
mgraber
closed
4 years ago
0
Source: Core places
#3
mgraber
closed
4 years ago
0
Source: Weekly places patterns
#2
mgraber
closed
3 years ago
1
Source: Social distancing
#1
mgraber
closed
3 years ago
2
Previous