4 ms·
I am modelling with American Community Survey complete raw data, physically in Berkeley, California.. using PostGIS, python and an SEIR model; Urban Planning ba
by coderthrow 7y ago
I am modelling with American Community Survey complete raw data, physically in Berkeley, California.. using PostGIS, python and an SEIR model; Urban Planning background.. suggestions welcome
- deleted 7y ago[deleted]
- coderthrow 7y agoexample output, US Persons by Age-Sex 50+ by Census Tract, nationwide.. exec. time 1230 ms. local, no clouds -[ RECORD 221408 ]----+ mtable_2_pkey | 18744349 geoid | 08000US361198400084000000900 geo_name | Census Tract 9, Yonkers city, Yonkers city, Westchester County, New York Total_Population | 2307 Male | 1085 male over 50 est. | 285 Female | 1222 female over 50 est. | 272 -[ RECORD 221409 ]----+ mtable_2_pkey | 18754394 geoid | 08000US421338704887048000900 geo_name | Census Tract 9, York city, York city, York County, Pennsylvania Total_Population | 7100 Male | 3934 male over 50 est. | 1453 Female | 3166 female over 50 est. | 1347 -[ RECORD 221410 ]----+ mtable_2_pkey | 18776479 geoid | 14000US42133000900 geo_name | Census Tract 9, York County, Pennsylvania Total_Population | 1169 Male | 667 male over 50 est. | 226 Female | 502 female over 50 est. | 240