{ "info": { "author": "Matthew Kenny", "author_email": "matthewkenny AT gmail DOT com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: GNU Lesser General Public License v2 or later (LGPLv2+)", "Topic :: Scientific/Engineering :: GIS" ], "description": "==========\npgsql2gist\n==========\n\nCreate maps using the Github Gist API as GeoJSON or TopoJSON, directly from PostGIS.\n\ndev-branch\n\n.. image:: https://travis-ci.org/mattmakesmaps/pgsql2gist.png?branch=development\n\nmaster\n\n.. image:: https://travis-ci.org/mattmakesmaps/pgsql2gist.png?branch=master\n\nObjective\n=========\n\nCreate a command line utility similar to pgsql2shp, but the output of which should be\na link to an anonymous private gist. The gist link should leverage Github\u2019s\nrendering of GeoJSON/TopoJSON, e.g. render a map.\n\nSee issues for additional features to be implemented.\n\nCurrent Usage / Caveats\n=======================\n\nListed below is the --help usage information.::\n\n POST GeoJSON or TopoJSON features from PostGIS to a Github Gist.\n\n Example usage: pgsql2gist --host localhost --user matt tilestache \\\n \"SELECT name, ST_AsGeoJSON(geom) AS geometry FROM neighborhoods LIMIT 5;\"\n\n Current SELECT Statement Requirements:\n - Geometry must be in EPSG:4326 WGS84 coordinate system\n - Geometry must be wrapped in ST_AsGeoJSON(), ST_AsTopoJSON()\n\n usage: pgsql2gist [-f FILE] [-d DESCRIPTION] [-h HOST] [-p PORT] [-P PASSWORD]\n [-u USER] [-g GEOM_COL] [-t TOPOLOGY_LAYER] [-v] [-?]\n database SELECT\n\n positional arguments:\n database PostGIS database name.\n SELECT SELECT Statement. NOTE: Geometry must be WGS84;\n wrapped in ST_AsGeoJSON() or AsTopoJSON().\n\n optional arguments:\n -f FILE, --file FILE Filename. NOTE: Must end in 'geojson' or 'topojson'\n extension. (default: upload.geojson)\n -d DESCRIPTION, --description DESCRIPTION\n Description of upload (default: File uploaded using\n pgsql2gist.)\n -h HOST, --host HOST PostGIS database hostname. (default: None)\n -p PORT, --port PORT PostGIS database port. (default: 5432)\n -P PASSWORD, --password PASSWORD\n PostGIS user password. (default: None)\n -u USER, --user USER PostGIS database user. (default: postgres)\n -g GEOM_COL, --geom-col GEOM_COL\n Geometry column name as defined in SELECT statement.\n (default: geometry)\n -t TOPOLOGY_LAYER, --topology-layer TOPOLOGY_LAYER\n For TopoJSON Queries; Name of Topology Layer (default:\n None)\n -v, --verbose Verbose output. (default: False)\n -?, --help\n\nResources\n=========\n\nGist API: (http://developer.github.com/v3/gists/)\n\nThanks\n======\n\nThe spiffy idea behind a db context manager comes from Migurski's awesome TileStache\nmap server. http://tilestache.org", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/mattmakesmaps/pgsql2gist", "keywords": "gis gists postgis postgresql geojson", "license": "GNU LESSER GENERAL PUBLIC LICENSE", "maintainer": null, "maintainer_email": null, "name": "pgsql2gist", "package_url": "https://pypi.org/project/pgsql2gist/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/pgsql2gist/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/mattmakesmaps/pgsql2gist" }, "release_url": "https://pypi.org/project/pgsql2gist/0.3.0/", "requires_dist": null, "requires_python": null, "summary": "Create maps using the Github Gist API as GeoJSON or TopoJSON, directly from PostGIS.", "version": "0.3.0" }, "last_serial": 973646, "releases": { "0.2.0": [ { "comment_text": "", "digests": { "md5": "cf40f058b123ceec4bb2f6f40c3be8c2", "sha256": "ffff8f0dac4295cc6e370fd06a031ec38ed4b28667d07f78a622c88d850c0639" }, "downloads": -1, "filename": "pgsql2gist-0.2.0.tar.gz", "has_sig": false, "md5_digest": "cf40f058b123ceec4bb2f6f40c3be8c2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5961, "upload_time": "2013-12-04T06:55:38", "url": "https://files.pythonhosted.org/packages/02/ba/42599f96ff827237c08d32f6d4fa8e67630d54abfd1997efc289455e1186/pgsql2gist-0.2.0.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "bd7d68fbdabfb902be9a131c8bf8ec75", "sha256": "75d76f1224f2c02b79b22a62bf4ca418fa57824f6697eb02f10e8915f6c841cd" }, "downloads": -1, "filename": "pgsql2gist-0.2.1.tar.gz", "has_sig": false, "md5_digest": "bd7d68fbdabfb902be9a131c8bf8ec75", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6855, "upload_time": "2013-12-08T08:07:40", "url": "https://files.pythonhosted.org/packages/54/82/70134d0fc6fed7e184ab68fcce6286ab79f33966d49c74bc99570888977c/pgsql2gist-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "858f6f4768dc0e60e515124d73e2f509", "sha256": "402a0b215d97cb762bc1ef44003f00295a45ac2484d406c9c4a2c96267ea2d8e" }, "downloads": -1, "filename": "pgsql2gist-0.2.2.tar.gz", "has_sig": false, "md5_digest": "858f6f4768dc0e60e515124d73e2f509", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7500, "upload_time": "2013-12-08T19:18:17", "url": "https://files.pythonhosted.org/packages/99/59/c57b6bafaf6d8319c7cae1c5686ac22dd40d4625d533c594d987e51b5954/pgsql2gist-0.2.2.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "bb8cb646f2a0496d57ce380827bfb598", "sha256": "232e4ee66d509aee6fb20871bb89f99fdd0d9de00298150b58de8d6d2b52b054" }, "downloads": -1, "filename": "pgsql2gist-0.3.0.tar.gz", "has_sig": false, "md5_digest": "bb8cb646f2a0496d57ce380827bfb598", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9187, "upload_time": "2014-01-18T22:48:09", "url": "https://files.pythonhosted.org/packages/f6/7e/0ff6d4362a15ec81a04366890c30c7b292f4c413c20b000d969def269d1b/pgsql2gist-0.3.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "bb8cb646f2a0496d57ce380827bfb598", "sha256": "232e4ee66d509aee6fb20871bb89f99fdd0d9de00298150b58de8d6d2b52b054" }, "downloads": -1, "filename": "pgsql2gist-0.3.0.tar.gz", "has_sig": false, "md5_digest": "bb8cb646f2a0496d57ce380827bfb598", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9187, "upload_time": "2014-01-18T22:48:09", "url": "https://files.pythonhosted.org/packages/f6/7e/0ff6d4362a15ec81a04366890c30c7b292f4c413c20b000d969def269d1b/pgsql2gist-0.3.0.tar.gz" } ] }