{ "info": { "author": "Jon McClure", "author_email": "jmcclure@politico.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "Intended Audience :: Science/Research", "License :: OSI Approved :: GNU General Public License v3 (GPLv3)", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Topic :: Sociology" ], "description": "![POLITICO](https://rawgithub.com/The-Politico/src/master/images/logo/badge.png)\n\n# census_pgeoloader\n\nCommand 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.\n\n# Requirements\n\nUses [shp2pgsql](http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg). Assumes PostgreSQL + PostGIS.\n\n# To install\n\n```bash\n$ pip install census_pgeoloader\n```\n\n# To use\n\nPass 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.\n\n```bash\n$ pgeoloader postgres://postgres@localhost:5432/database KS MO TX VA ...\n```\n\nValid values for states are FIPS codes, postal abbreviations or names. Pass `+` to collect all states.\n\n# Options\n\n```bash\nOptions:\n -t, --table TEXT Name of table to create in DB. Default is\n \"census_shapes\".\n -p, --temp TEXT Directory to download files to. Default is\n \"./shapefiles\"\n -y, --year TEXT Year. Default is \"2016\".\n -g, --geo [tract|group|block] Geographic unit. Default is \"tract\".\n -s, --srid TEXT Specify an SRID transform, e.g., \"4269:4326\".\n Default is \"4269\".\n --help Show this message and exit.\n```\n\n#### Notes:\n\n- `--table` Drops any existing table by that name in the database.\n- `--geo` Can pull tracts, block groups or blocks.\n- `--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).\n\n\u00a92017 POLITICO\n\n\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/The-Politico/census_pgeoloader/", "keywords": "", "license": "GPLv3", "maintainer": "", "maintainer_email": "", "name": "census-pgeoloader", "package_url": "https://pypi.org/project/census-pgeoloader/", "platform": "", "project_url": "https://pypi.org/project/census-pgeoloader/", "project_urls": { "Homepage": "https://github.com/The-Politico/census_pgeoloader/" }, "release_url": "https://pypi.org/project/census-pgeoloader/0.2.0/", "requires_dist": [ "click", "idna", "psycopg2", "pyOpenSSL", "requests", "us" ], "requires_python": "", "summary": "Load Census shapefiles into PostGIS", "version": "0.2.0" }, "last_serial": 3021627, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "5fe40ff077f139b60069896c3dd5dbe4", "sha256": "2955444e88387b7a7471496d235a548bd99fbf5d8a38035723808c7b983260c3" }, "downloads": -1, "filename": "census_pgeoloader-0.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "5fe40ff077f139b60069896c3dd5dbe4", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 4234, "upload_time": "2017-07-13T21:39:09", "url": "https://files.pythonhosted.org/packages/8a/bc/f89111b264ab463d4b86f3b060a537ccb10e317e8d8d80bb0293e01383be/census_pgeoloader-0.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "be2315933e891f9b221d68a1617b689a", "sha256": "28f4177bfd6e52dc40dcf4505b38e7681ab5b12a304d972b827cb39526b98ab6" }, "downloads": -1, "filename": "census_pgeoloader-0.1.0.tar.gz", "has_sig": false, "md5_digest": "be2315933e891f9b221d68a1617b689a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2692, "upload_time": "2017-07-13T21:39:10", "url": "https://files.pythonhosted.org/packages/fd/34/3a886a146b1e04a6b66aa04a6416be093b75f1a387ec3acca6d174a5d4bd/census_pgeoloader-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "3c193b0f7fb5b691fe20f929bc5894fd", "sha256": "489b8667f8094ad2fc36ef894e5d6edb049c59e3c0c5d5b5d9ed05815646963a" }, "downloads": -1, "filename": "census_pgeoloader-0.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3c193b0f7fb5b691fe20f929bc5894fd", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5950, "upload_time": "2017-07-13T21:42:36", "url": "https://files.pythonhosted.org/packages/18/86/8362c212708fed8a92343086cb77873657a8ed93cf1592d616edbe7d6f00/census_pgeoloader-0.1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2f1537dcf7b1bc5783a89a25ac58d1e8", "sha256": "2ff87cc2bdc7b46ae97bace63497bdcda3409bbe9e53c631fb9ba7846769b2f3" }, "downloads": -1, "filename": "census_pgeoloader-0.1.1.tar.gz", "has_sig": false, "md5_digest": "2f1537dcf7b1bc5783a89a25ac58d1e8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3475, "upload_time": "2017-07-13T21:42:39", "url": "https://files.pythonhosted.org/packages/4b/00/717d6cc1726796ffe73cb52f470ef540a825e8df14c561a700bcc4ae1e16/census_pgeoloader-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "9506a35d0363086c9eee0756de4f7155", "sha256": "5ac6853b7fbc33addf26c3ac237ca5204b7b4588fbcd6d1f04e93352720b1945" }, "downloads": -1, "filename": "census_pgeoloader-0.1.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "9506a35d0363086c9eee0756de4f7155", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6010, "upload_time": "2017-07-13T21:50:53", "url": "https://files.pythonhosted.org/packages/c4/00/bb968673304f99d29830d1e5adf6bf5e3aa86486907b00d64b79a4fcb4e6/census_pgeoloader-0.1.2-py2.py3-none-any.whl" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "491af19c852673f477731052c8bfef08", "sha256": "f290b028d9756e560e28062d074994d099bd0c605905ffac0faea07338ed1c9d" }, "downloads": -1, "filename": "census_pgeoloader-0.1.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "491af19c852673f477731052c8bfef08", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6011, "upload_time": "2017-07-13T21:57:12", "url": "https://files.pythonhosted.org/packages/49/de/dc26983af5009c23b700eb27490ef36f0cd647227ab349904f59dddf04e7/census_pgeoloader-0.1.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c32c7b8ad1d3e8e996c3a8a315f2fc09", "sha256": "40a5a58ab1fea4d2dbb919a35572b428ed15e6174561cc80194cd71b082cd2cc" }, "downloads": -1, "filename": "census_pgeoloader-0.1.3.tar.gz", "has_sig": false, "md5_digest": "c32c7b8ad1d3e8e996c3a8a315f2fc09", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3542, "upload_time": "2017-07-13T21:57:13", "url": "https://files.pythonhosted.org/packages/c1/44/de1b95dbb0ed1456bac2fa8a40f702b9d60b7b11d2b0600cb9d9fb496a7d/census_pgeoloader-0.1.3.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "e1ad9ddc4c9c2e55559acb66304c8d6f", "sha256": "325c748212ec62a6e01d46475b714a75f7b11817de884bec574cef2a697703e7" }, "downloads": -1, "filename": "census_pgeoloader-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "e1ad9ddc4c9c2e55559acb66304c8d6f", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6034, "upload_time": "2017-07-13T22:03:21", "url": "https://files.pythonhosted.org/packages/ca/0c/a12501cdfff0fca1c950bc289e95aa79f2e7f8af5d640976513e7158f08f/census_pgeoloader-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5b9d52f93f464b4135667bb1b74b1d7b", "sha256": "89ddbb81ad7703804be7b0d1c99f10165fd71e3084b74024ed9d2d453b918886" }, "downloads": -1, "filename": "census_pgeoloader-0.2.0.tar.gz", "has_sig": false, "md5_digest": "5b9d52f93f464b4135667bb1b74b1d7b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3561, "upload_time": "2017-07-13T22:03:23", "url": "https://files.pythonhosted.org/packages/b1/d7/69f6a4b583fdcec6a789b3439298b03e61cc80a04e2bacb05a199a76bd2c/census_pgeoloader-0.2.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "e1ad9ddc4c9c2e55559acb66304c8d6f", "sha256": "325c748212ec62a6e01d46475b714a75f7b11817de884bec574cef2a697703e7" }, "downloads": -1, "filename": "census_pgeoloader-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "e1ad9ddc4c9c2e55559acb66304c8d6f", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6034, "upload_time": "2017-07-13T22:03:21", "url": "https://files.pythonhosted.org/packages/ca/0c/a12501cdfff0fca1c950bc289e95aa79f2e7f8af5d640976513e7158f08f/census_pgeoloader-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5b9d52f93f464b4135667bb1b74b1d7b", "sha256": "89ddbb81ad7703804be7b0d1c99f10165fd71e3084b74024ed9d2d453b918886" }, "downloads": -1, "filename": "census_pgeoloader-0.2.0.tar.gz", "has_sig": false, "md5_digest": "5b9d52f93f464b4135667bb1b74b1d7b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3561, "upload_time": "2017-07-13T22:03:23", "url": "https://files.pythonhosted.org/packages/b1/d7/69f6a4b583fdcec6a789b3439298b03e61cc80a04e2bacb05a199a76bd2c/census_pgeoloader-0.2.0.tar.gz" } ] }