Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/censusreporter/census-postgres-scripts

Scripts used to set up census-postgres on an Amazon EC2 instance.
https://github.com/censusreporter/census-postgres-scripts

fixes after learning that Census sneakily issued newer UAC shapefiles

c50bbe874d8d94e333c9738c53e8c9614e5ff77f authored about 1 year ago by Joe Germuska <[email protected]>
make sure CBSAs get indexed

5706e8fea4adcbe17f0643addfe764105f4c8de5 authored about 1 year ago by Joe Germuska <[email protected]>
update to reflect the fact that Census should have distributed CSA and METDIV geographies for 2022

df7139c17fad45118113ecf59008641d82e17650 authored about 1 year ago by Joe Germuska <[email protected]>
Don't use the _tables suffix

5bb9811125b844043eacb1c994f2a5e762c5f3ab authored about 1 year ago by Ian Dees <[email protected]>
Add acs2022 5yr scripts

5c47048edf39289d44f8e2e435f1b098b8dc3663 authored about 1 year ago by Ian Dees <[email protected]>
prepare CBSA containment for 2022

9b55912c59da1eead8163c3df52b8926f8445d9c authored about 1 year ago by Joe Germuska <[email protected]>
Use 2021 5yr data for AIANNH data index script

48ca19ede7e81d2a997efebc30a21d9a53fb0d6f authored over 1 year ago by Ian Dees <[email protected]>
The PUMA columns all have 20 suffix instead of 10 now

1a82d27f32d37f6e29ce1853a7deed1b445be7af authored over 1 year ago by Ian Dees <[email protected]>
The PUMA geoid columns is geoid20 now

8fd6f08abe3dd38d84f080d5f3be17bb32ad626a authored over 1 year ago by Ian Dees <[email protected]>
Removing containment operations for geos that don't seem to exist in TIGER 2022

b78f5ad2258e31ad5cab799a48f37ca269f03309 authored over 1 year ago by Ian Dees <[email protected]>
Removing containment operations for geos that don't seem to exist in TIGER 2022

fce831126026af2fb0676dfa067979a1c9678780 authored over 1 year ago by Ian Dees <[email protected]>
Use 2021 5yr data for TIGER 2022 data index script

f79a6de7b9cd0425b9125551951e3631d0ee78d3 authored over 1 year ago by Ian Dees <[email protected]>
Fix bug in shp2pgsql generated SQL

7c169de59e62a6a852bf52dc9b26bd95f80d94ee authored over 1 year ago by Ian Dees <[email protected]>
Fix path to the fix_geoids script in both spots

44211a36cb2367cbbfad6369cc4ea9d4daa78039 authored over 1 year ago by Ian Dees <[email protected]>
Fix path to the fix_geoids script

6f10d124d015f9589675e2311b35a0920d18170c authored over 1 year ago by Ian Dees <[email protected]>
Don't try to download the stuff that isn't in TIGER 2022. Also it seems to be in UTF8 now.

ec30b30cbf99eb6dc38721a9605319998c3ab5e8 authored over 1 year ago by Ian Dees <[email protected]>
Add scripts for TIGER 2022

fce10c42ac3088fe88abcd197d431e4cdbb21766 authored over 1 year ago by Ian Dees <[email protected]>
Add scripts for 2022 1yr ACS

bd6a005178810ff6bdb824e3468938e0cbd6f1d4 authored over 1 year ago by Ian Dees <[email protected]>
prepare for new table-only data.

89df4e66b728c31d96a7b3a08f049e4ee20b7ae0 authored over 1 year ago by Joe Germuska <[email protected]>
Not sure where I got 189 from

34e9510045ea77aa7d2fdda3c7ba63a388efb769 authored about 2 years ago by Ian Dees <[email protected]>
Adjust import scripts to match new non-EC2 instance we're using

c330c76fd176d761594551a0cafcd9ccf5a17a1d authored about 2 years ago by Ian Dees <[email protected]>
Add in the sequence-based-SF/ part of the URL

a7bbfbd4bea77244b2db5d285c852c86b2db445e authored about 2 years ago by Ian Dees <[email protected]>
Forgot to fix copy/paste error for 2020->2021

cfe4d6735894cef4e04115455e3f72ae7a4af5bd authored about 2 years ago by Ian Dees <[email protected]>
Add scripts for 2021 5yr ACS

4ba7815b6341fbeae6b74a4c03489bd70e5caed7 authored about 2 years ago by Ian Dees <[email protected]>
prevent Island Areas UACs from going into census_name_lookup. fixes censusreporter/censusreporter#244

7a66993eac38c19f8bda381c01f9c31de777bfc4 authored about 2 years ago by Joe Germuska <[email protected]>
AIANNH containment should use 2020 5yr population

1328ab4ba509339ca611b7df75b7fbc87d8726b7 authored over 2 years ago by Ian Dees <[email protected]>
UAC and PUMA don't have 20-suffix column names

5225b5d6cea736fbe3d339975455abd77cd26762 authored over 2 years ago by Ian Dees <[email protected]>
zcta520, not zcta5

fcb9d136a77d2f8cd88e9e97c116b37be2d6dae9 authored over 2 years ago by Ian Dees <[email protected]>
Use 2020 5yr for states too

c5682fd250e6280642de4d5eb4a3e3c12fa5110e authored over 2 years ago by Ian Dees <[email protected]>
Fix ACS join for tiger 2021

ab6d20e299fd130b895c22adf6bf7887ea9cad72 authored over 2 years ago by Ian Dees <[email protected]>
zcta5 to zcta520

1de77655b2e3a59200bad05cf24e9ab679198042 authored over 2 years ago by Ian Dees <[email protected]>
Add TIGER 2021 scripts

d383660f77b6e5bd2ce93a888867637c0bc92003 authored over 2 years ago by Ian Dees <[email protected]>
Add 2021 1yr download/import scripts

987eefb123ab96a4c17c7672ede3464bd848054f authored over 2 years ago by Ian Dees <[email protected]>
improve display name for sumlevel 251 and add some clarifying notes about how to handle AIANNH geography

18cdae85300cbcca8fd30753372fd07bf3d423f0 authored over 2 years ago by Joe Germuska <[email protected]>
apply more clear names to block groups

841c21e3ad4edcf962ccdbb7bc6e0bf9a1ad6216 authored over 2 years ago by Joe Germuska <[email protected]>
fix acs year for pop

67bcf1bb42697176da765c2e5d6a19b54df24a96 authored over 2 years ago by Joe Germuska <[email protected]>
update with new CBSA delineation file

d160d06cb256ed9faf5625a17f972c68755c5ad5 authored almost 3 years ago by Joe Germuska <[email protected]>
fix summary level for CONCITY

4ed8b8329399c21ea75a3eb3c94caabed668fbb4 authored almost 3 years ago by Joe Germuska <[email protected]>
fix assignment of Indiana to ENC Division

872858f5969ebf4e5576314c7561f71257666c3d authored almost 3 years ago by Joe Germuska <[email protected]>
Drop the containment table if it exists

b659192019ba1bde067f124abd70b81cef1c7c4d authored almost 3 years ago by Ian Dees <[email protected]>
Do the whole thing in a transaction

aacc1b8557e970ec4ad954ed10cf6a48562d1c1c authored almost 3 years ago by Ian Dees <[email protected]>
TIGER 2020 doesn't seem to have submcd

caba6e35d7488446eced32953b0065ca69d9b287 authored almost 3 years ago by Ian Dees <[email protected]>
Grab population from 2020 5yr

63446fb831d07ee2111ab8373bad5d75af3999ce authored almost 3 years ago by Ian Dees <[email protected]>
Update tiger2020 scripts to work on OSUOSL instance

09fdb333fd4cc8214e6266b4bd84027efddde264 authored almost 3 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-postgres-scripts into master

208ffe673220dbe2ec6e7d04ed28fe1183978fbd authored almost 3 years ago by Joe Germuska <[email protected]>
late commit -- adjust indexing

f263422e28ebe924eeb2564841b42a23a16ce55b authored almost 3 years ago by Joe Germuska <[email protected]>
Add 2020 data download and TIGER scripts

c62f7415106f379dee05d0230326fcde914f5b95 authored almost 3 years ago by Ian Dees <[email protected]>
update with real URL root

3066dc50f4afe6a66658249df5c3886010686d8b authored over 3 years ago by Joe Germuska <[email protected]>
fix delimiters

e924936de8775ce9421fe851f910d2fa1c636f02 authored over 3 years ago by Joe Germuska <[email protected]>
testing 2020

e0542f79ec20f1130ae449390c19e9dfbed3ad8e authored over 3 years ago by Joe Germuska <[email protected]>
add some to .gitignore

5913039c22185edf7c85701a4e3f16023e93ce12 authored over 3 years ago by Joe Germuska <[email protected]>
fix column name on create index

5ced83d874ab24cecbf5b06289d48fc5783f60e1 authored over 3 years ago by Joe Germuska <[email protected]>
add some logging

020cae874b1bf0feaa019315c75e555a63aa036d authored over 3 years ago by Joe Germuska <[email protected]>
process 2020 blocks

39c5be27ed3ee413470807e49eef2e74600216fb authored over 3 years ago by Joe Germuska <[email protected]>
deal with extra directory in tabblock download

568f4865c1337f92961f2d6042f36077c379bf6b authored over 3 years ago by Joe Germuska <[email protected]>
tweaky

daebab56a1619137a34994a63b41c0f69992eb47 authored over 3 years ago by Joe Germuska <[email protected]>
incremental improvements

8f3993aec44e3a55d8e030c2091959a893a5d62a authored over 3 years ago by Joe Germuska <[email protected]>
tweaking

974150bb714eec9a053bda507ee95f5357e591ea authored over 3 years ago by Joe Germuska <[email protected]>
more work on 2010

87b8dc849181b5522070ed53e67f4776f5391453 authored over 3 years ago by Joe Germuska <[email protected]>
add 2010 PL94 downloader

d6db47f63196fa23c9fa8d90d06ff4ce16d4507a authored over 3 years ago by Joe Germuska <[email protected]>
add comma to fake a list of layers

fbf97e59043bf5b5d6018915aaa8220c20da03dc authored over 3 years ago by Joe Germuska <[email protected]>
remove obsolete psql connection details

025ef39a02e0b7e435e314ea9df78cb1a2c548e3 authored over 3 years ago by Joe Germuska <[email protected]>
import 2010 blocks only

1981b7e6112ce271c26fc092399a3e25485b8c44 authored over 3 years ago by Joe Germuska <[email protected]>
Merge pull request #26 from censusreporter/region-division-fix

Use TIGER data on state regions and divisions when populating census_name_lookup

ab1f66fbe24333fe8d2575804674c641c72d6924 authored over 3 years ago by Joe Germuska <[email protected]>
fix munged region 2 SQL

e434bfbcd6fe9092202449392b20c08537226f65 authored over 3 years ago by Joe Germuska <[email protected]>
Use TIGER data on state regions and divisions instead of hardcoding geoids when populating census_name_lookup

7753d4055763d082e6aaad6b3d91f2ff6a682514 authored over 3 years ago by Joe Germuska <[email protected]>
Merge branch 'concity-sumlevel-fix' into master

47f11b52a50e5b6542a203abd6afd4a32bb71d5f authored almost 4 years ago by Joe Germuska <[email protected]>
geoid prefix bug for sumlevel 170 concit

cc93a34bbe8318613522aa576f74f761e70399a7 authored almost 4 years ago by Joe Germuska <[email protected]>
Add 2019 5yr ACS scripts

731998b2e46399a6a08f2cb11ea9e2832b72af4a authored about 4 years ago by Ian Dees <[email protected]>
Fix summary level for Consolidated Cities (concit): 170, not 190

085e15a24f0e28eea96430ef916086ddda872732 authored about 4 years ago by Joe Germuska <[email protected]>
update CBSA containment for 2019 and run it

ad509ea4507fd4eefd14a485e63b05c1195ba45f authored about 4 years ago by Joe Germuska <[email protected]>
MakeValid the invalid TIGER geoms + clean up afterwards

d953c05d7172756ad09ff345b7aa8babeaa8b719 authored about 4 years ago by Ian Dees <[email protected]>
Switch to using my census backup CDN to avoid their broken CDN

e40811599c4667a812e78a671606567a28a4835f authored over 4 years ago by Ian Dees <[email protected]>
VTD doesn't seem to be in the TIGER release anymore

ed3ef3cc1e518c23096b69bd2e16198a44bfa3e9 authored over 4 years ago by Ian Dees <[email protected]>
Forgot to add import tiger 2019

b7822fdb633b8da16178f010ae114834edaa1819 authored over 4 years ago by Ian Dees <[email protected]>
Adding 2019 1yr scripts

e8e3f44b3edec66068a82b60225bc0db3d05d186 authored over 4 years ago by Ian Dees <[email protected]>
bump priority of concity since there are few and otherwise they'd get lost behind places with similar names

fe1c53a191ba46d6cb438960ad3b8f05296f89a1 authored over 4 years ago by Joe Germuska <[email protected]>
add sumlevel 170 to census_name_lookup

c1801b375651e87dc1af782e630fc72451aa90bf authored over 4 years ago by Joe Germuska <[email protected]>
fix duplicate IN to restore IL to 'East North Central Division' and, by derivation, 'Midwest Region'

f2e243f977eedf00e86d53aa3349b890d137fd74 authored over 4 years ago by Joe Germuska <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-postgres-scripts

a5673c308f9f909516e479dead77f0ef48e219a3 authored almost 5 years ago by Joe Germuska <[email protected]>
redo CBSA/CSA/County geocontainment re censusreporter/censusreporter#271

8cd263ab0b6eda573b643c77cb7f70c4b8179a6b authored almost 5 years ago by Joe Germuska <[email protected]>
Modify the download script to handle zipped zips

484f8eddf23f7132c18816d270cdc143c9d90b99 authored about 5 years ago by Ian Dees <[email protected]>
Add 2018 5yr download/import scripts

debdc63fc85c81c689d61065455f7253f0465747 authored about 5 years ago by Ian Dees <[email protected]>
fix the deletes

8254c808186bd347d0074c7fa886d788635559a6 authored about 5 years ago by Joe Germuska <[email protected]>
ensure no duplicate inserts in CBSA/CSA geocontainment

41fa9b25ad53dbb77e42fddd5e7317e66d0e0125 authored about 5 years ago by Joe Germuska <[email protected]>
Filter out footer rows on delineation file

2df2ea4587793b1f1d0ea26029facfe62e334731 authored over 5 years ago by Ian Dees <[email protected]>
Add 2018 aiannh tables

2e779e4a36be71385e966f802eea0d64bf4e4d08 authored over 5 years ago by Ian Dees <[email protected]>
Adjust the download script for 2018 as aria2c seems to get blocked

2b5612b1ff8d98a0d1970170e41f7b91b2ccb81b authored over 5 years ago by Ian Dees <[email protected]>
New stuff for 2018 1-year

c522c9e411b3bd444b5f4a81b4b2423ada31e42b authored over 5 years ago by Ian Dees <[email protected]>
document some geographic refinements

4802fe4e18cb84de890c9b7ca4723d7367f84825 authored over 5 years ago by Joe Germuska <[email protected]>
Trying to handle the differences in the 2017 5-year release

6f64337261e82e941a2713ea5b1aa87c184a033f authored about 6 years ago by Ian Dees <[email protected]>
Add '17 5yr download and import scripts

0020ee085a9f945d6bf809f8a889bbd42dbdacd2 authored about 6 years ago by Ian Dees <[email protected]>
add MIT license. Fixes #18

097b79660d4eecc8fc2dd6038e9646d9810bb6ce authored about 6 years ago by Joe Germuska <[email protected]>
update for 2017 cf #12 censusreporter/censusreporter#34

11e10a87802d339c7d58919ea1168f1eebba4865 authored about 6 years ago by Joe Germuska <[email protected]>
Merge pull request #12 from censusreporter/fix-sumlevel-250

Proper handling of sumlevels 250, 252, and 254

8100fe3dc98564eefef77cf8b5fc8f3d440adf2b authored about 6 years ago by Joe Germuska <[email protected]>
Add download/import/index steps for 2017 1yr + tiger

894da6761cfd5749d7b9e2002e8940171982da93 authored over 6 years ago by Ian Dees <[email protected]>
Fixing URLs for 2015/2016 5yr downloads

264d6913b35cbe7cae1fc5a5aff57b9582472ad7 authored over 6 years ago by Ian Dees <[email protected]>
Merge pull request #16 from peterwang998/patch-1

Updated the file path for acs2009_5yr

56b66133df00ca02efd76e03aa1bbeaecfb45bbc authored almost 7 years ago by Ian Dees <[email protected]>
Update for 2016 table names

0ee1439ab651841c453f4d344e623dd0a0e1b340 authored almost 7 years ago by Joe Germuska <[email protected]>
Pull population in from 2016 acs

1af2a602e1f5ceb13a8b5d99722cb8f7a24fab6d authored about 7 years ago by Ian Dees <[email protected]>