Skip to main content

PostGIS Commands

Project description

PostGIS commands.

Description

  • Wraps cli operations into a single interface
    • psql, shp2pgsql, \copy, ogr2ogr, etc.
  • Import/export to desired format
  • Tested on MacOS

Usage

$ pgtk
Usage: pgtk [OPTIONS] COMMAND [ARGS]...

  PostGIS Command Line Tool

Options:
  -h, --host TEXT    hostname
  -p, --port TEXT    port number
  -d, --dbname TEXT  database
  -u, --user TEXT    user
  -s, --schema TEXT  database schema
  -c, --crs TEXT     EPSG code
  --help             Show this message and exit.

Commands:
  export  Export PostGIS data
  import  Import data to PostgreSQL
  layers  Layer commands

Viewing data:

$ pgtk -h suffolk.geoserver.org -d boundary_data -s public_works layers list
--- public_works.boundary_data ---
 * zip_codes
 * suffolk_boundary
 * fire_districts
 * landmark_historic_districts
 * waterfront
 * zongin_district
 * boston_neighborhoods
 * land_use
 * planning_districts
 * water
 * parcels
 * downtown
 * airports
 * harbor_islands
$
$ pgtk -h suffolk.geoserver.org -d boundary_data -s public_works layers preview boston_neighborhoods
--- preview boston_neighborhoods ---
gid        name    acres    neighborho    sqmiles    shapestare    shapestlen  geom
  1  Roslindale  1605.57            15       2.51   6.99383e+07       53563.9  01060000...

Export PostGIS data:

$ pgtk -h suffolk.geoserver.org -d boundary_data -s public_works \
> export -o ~/Downloads --driver csv boston_neighborhoods suffolk_boundary
--- export csv ---
>> boston_neighborhoods
COPY 26
>> suffolk_boundary
COPY 1
$
$ head -5 ~/Downloads/boston_neighborhoods.csv | column -t -s,
gid  name           acres                 neighborho  sqmiles  shapestare                shapestlen             coordinate_y      coordinate_x
1    Roslindale     1605.568237499999896  15          2.510    69938272.925570487976074  53563.912597056623781  42.2825239371116  -71.1266625924454
2    Jamaica Plain  2519.245393770000192  11          3.940    109737890.75433960556983  56349.937161410227418  42.3077695033488  -71.1150969429541
3    Bay Village    26.539839160000000    33          0.040    1156070.765868443064392   4650.635493295902052   42.3491032446921  -71.0690319987556
4    Roxbury        2108.469071760000134  16          3.290    91844545.974815726280212  49488.800484731051256  42.3185185721262  -71.0866432257429

Install

$ pip install postgis-toolkit
  • Python 3.7+
  • Requires postgis tools installed on your computer - shp2pgsql & pgsql should be on your path.

Project details


Release history Release notifications

This version

0.0.1

Download files

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

Files for postgis-toolkit, version 0.0.1
Filename, size & hash File type Python version Upload date
postgis_toolkit-0.0.1-py3-none-any.whl (6.0 kB) View hashes Wheel py3
postgis-toolkit-0.0.1.tar.gz (5.7 kB) View hashes Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page