{
    "info": {
        "author": "Felix Rhett",
        "author_email": "felix.rhett@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.7"
        ],
        "description": "postgis-toolkit\n===============\n\nPostGIS commands.\n\nDescription\n~~~~~~~~~~~\n\n-  Wraps cli operations into a single interface\n\n   -  ``psql``, ``shp2pgsql``, ``\\copy``, ``ogr2ogr``, etc.\n\n-  Import/export to desired format\n-  Tested on MacOS\n\nUsage\n~~~~~\n\n::\n\n    $ pgtk\n    Usage: pgtk [OPTIONS] COMMAND [ARGS]...\n\n      PostGIS Command Line Tool\n\n    Options:\n      -h, --host TEXT    hostname\n      -p, --port TEXT    port number\n      -d, --dbname TEXT  database\n      -u, --user TEXT    user\n      -s, --schema TEXT  database schema\n      -c, --crs TEXT     EPSG code\n      --help             Show this message and exit.\n\n    Commands:\n      export  Export PostGIS data\n      import  Import data to PostgreSQL\n      layers  Layer commands\n\n\n\nViewing data:\n\n::\n\n    $ pgtk -h suffolk.geoserver.org -d boundary_data -s public_works layers list\n    --- public_works.boundary_data ---\n     * zip_codes\n     * suffolk_boundary\n     * fire_districts\n     * landmark_historic_districts\n     * waterfront\n     * zongin_district\n     * boston_neighborhoods\n     * land_use\n     * planning_districts\n     * water\n     * parcels\n     * downtown\n     * airports\n     * harbor_islands\n    $\n    $ pgtk -h suffolk.geoserver.org -d boundary_data -s public_works layers preview boston_neighborhoods\n    --- preview boston_neighborhoods ---\n    gid        name    acres    neighborho    sqmiles    shapestare    shapestlen  geom\n      1  Roslindale  1605.57            15       2.51   6.99383e+07       53563.9  01060000...\n\nExport PostGIS data:\n\n::\n\n    $ pgtk -h suffolk.geoserver.org -d boundary_data -s public_works \\\n    > export -o ~/Downloads --driver csv boston_neighborhoods suffolk_boundary\n    --- export csv ---\n    >> boston_neighborhoods\n    COPY 26\n    >> suffolk_boundary\n    COPY 1\n    $\n    $ head -5 ~/Downloads/boston_neighborhoods.csv | column -t -s,\n    gid  name           acres                 neighborho  sqmiles  shapestare                shapestlen             coordinate_y      coordinate_x\n    1    Roslindale     1605.568237499999896  15          2.510    69938272.925570487976074  53563.912597056623781  42.2825239371116  -71.1266625924454\n    2    Jamaica Plain  2519.245393770000192  11          3.940    109737890.75433960556983  56349.937161410227418  42.3077695033488  -71.1150969429541\n    3    Bay Village    26.539839160000000    33          0.040    1156070.765868443064392   4650.635493295902052   42.3491032446921  -71.0690319987556\n    4    Roxbury        2108.469071760000134  16          3.290    91844545.974815726280212  49488.800484731051256  42.3185185721262  -71.0866432257429\n\n\nInstall\n~~~~~~~\n\n::\n\n    $ pip install postgis-toolkit\n\n-  Python 3.7+\n-  Requires postgis tools installed on your computer - ``shp2pgsql`` &\n   ``pgsql`` should be on your path.\n\n   -  easiest way is through `Postgres.app <https://postgresapp.com>`__\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/felixink/postgis-toolkit",
        "keywords": "postgis,postgres,gis,shapefile,pgsql2shp",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "postgis-toolkit",
        "package_url": "https://pypi.org/project/postgis-toolkit/",
        "platform": "",
        "project_url": "https://pypi.org/project/postgis-toolkit/",
        "project_urls": {
            "Homepage": "https://github.com/felixink/postgis-toolkit"
        },
        "release_url": "https://pypi.org/project/postgis-toolkit/0.0.1/",
        "requires_dist": [
            "Click",
            "psycopg2-binary",
            "tabulate"
        ],
        "requires_python": ">=3.7*",
        "summary": "PostGIS Commands",
        "version": "0.0.1"
    },
    "last_serial": 4565993,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f9f44aef1c6e44c95d9d14a281279208",
                    "sha256": "d62dad7663e348eb3a17331c8a69d35bc9a5ccd6cf4053273c14bb56c160d67b"
                },
                "downloads": -1,
                "filename": "postgis_toolkit-0.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f9f44aef1c6e44c95d9d14a281279208",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.7*",
                "size": 5954,
                "upload_time": "2018-12-05T23:56:04",
                "url": "https://files.pythonhosted.org/packages/16/07/9dae71a6f48c49feca1922aa2b72c503e6a9a63b40399524f7c0aaf53c36/postgis_toolkit-0.0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "f59326eb02907f310d5a311b7d4f0914",
                    "sha256": "acb4be24f9826281a403da17598067c7140fadf479787791e3acdd6a34074a64"
                },
                "downloads": -1,
                "filename": "postgis-toolkit-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "f59326eb02907f310d5a311b7d4f0914",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.7*",
                "size": 5657,
                "upload_time": "2018-12-05T23:56:05",
                "url": "https://files.pythonhosted.org/packages/c7/e1/cc5de4abd45fdf76b8b719c35b7875461689c5a61a3010658142b8b633cc/postgis-toolkit-0.0.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "f9f44aef1c6e44c95d9d14a281279208",
                "sha256": "d62dad7663e348eb3a17331c8a69d35bc9a5ccd6cf4053273c14bb56c160d67b"
            },
            "downloads": -1,
            "filename": "postgis_toolkit-0.0.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f9f44aef1c6e44c95d9d14a281279208",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.7*",
            "size": 5954,
            "upload_time": "2018-12-05T23:56:04",
            "url": "https://files.pythonhosted.org/packages/16/07/9dae71a6f48c49feca1922aa2b72c503e6a9a63b40399524f7c0aaf53c36/postgis_toolkit-0.0.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "f59326eb02907f310d5a311b7d4f0914",
                "sha256": "acb4be24f9826281a403da17598067c7140fadf479787791e3acdd6a34074a64"
            },
            "downloads": -1,
            "filename": "postgis-toolkit-0.0.1.tar.gz",
            "has_sig": false,
            "md5_digest": "f59326eb02907f310d5a311b7d4f0914",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.7*",
            "size": 5657,
            "upload_time": "2018-12-05T23:56:05",
            "url": "https://files.pythonhosted.org/packages/c7/e1/cc5de4abd45fdf76b8b719c35b7875461689c5a61a3010658142b8b633cc/postgis-toolkit-0.0.1.tar.gz"
        }
    ]
}