Skip to main content

Load Census shapefiles into PostGIS

Project description

![POLITICO](https://rawgithub.com/The-Politico/src/master/images/logo/badge.png)

# census_pgeoloader

Command line utility to download Census TIGER/Line shapefiles by state from the U.S. Census Bureau and aggregate them into a single table in a PostGIS-enabled database.

# Requirements

Uses [shp2pgsql](http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg). Assumes PostgreSQL + PostGIS.

# To install

```bash
$ pip install census_pgeoloader
```

# To use

Pass a connection URI to your PostgreSQL database as well as the states you'd like to aggregate. This will dowload tract-level shapefiles by default.

```bash
$ pgeoloader postgres://postgres@localhost:5432/database KS MO TX VA ...
```

Valid values for states are FIPS codes, postal abbreviations or names. Pass `+` to collect all states.

# Options

```bash
Options:
-t, --table TEXT Name of table to create in DB. Default is
"census_shapes".
-p, --temp TEXT Directory to download files to. Default is
"./shapefiles"
-y, --year TEXT Year. Default is "2016".
-g, --geo [tract|group|block] Geographic unit. Default is "tract".
-s, --srid TEXT Specify an SRID transform, e.g., "4269:4326".
Default is "4269".
--help Show this message and exit.
```

#### Notes:

- `--table` Drops any existing table by that name in the database.
- `--geo` Can pull tracts, block groups or blocks.
- `--srid` Default SRID should be 4269, but you can specify a transform with this option as available in [shp2pgsql](http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg).

©2017 POLITICO


Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

census_pgeoloader-0.2.0.tar.gz (3.6 kB view details)

Uploaded Source

Built Distribution

census_pgeoloader-0.2.0-py2.py3-none-any.whl (6.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file census_pgeoloader-0.2.0.tar.gz.

File metadata

File hashes

Hashes for census_pgeoloader-0.2.0.tar.gz
Algorithm Hash digest
SHA256 89ddbb81ad7703804be7b0d1c99f10165fd71e3084b74024ed9d2d453b918886
MD5 5b9d52f93f464b4135667bb1b74b1d7b
BLAKE2b-256 b1d769f6a4b583fdcec6a789b3439298b03e61cc80a04e2bacb05a199a76bd2c

See more details on using hashes here.

File details

Details for the file census_pgeoloader-0.2.0-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for census_pgeoloader-0.2.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 325c748212ec62a6e01d46475b714a75f7b11817de884bec574cef2a697703e7
MD5 e1ad9ddc4c9c2e55559acb66304c8d6f
BLAKE2b-256 ca0ca12501cdfff0fca1c950bc289e95aa79f2e7f8af5d640976513e7158f08f

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page