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.

  • easiest way is through Postgres.app