{"repo":"geographyclub/postgis-cookbook","free":true,"listed":false,"github":"https://github.com/geographyclub/postgis-cookbook","clone":"git clone https://github.com/geographyclub/postgis-cookbook.git","description":"Cooking with geospatial SQL","language":null,"stars":63,"topics":["bash","postgis"],"license":null,"category":"cli-tools","readme_excerpt":"postgis-cookbook Useful commands for working with spatial data in psql and bash. TABLE OF CONTENTS 1. Starting out 2. Importing 3. Exporting 4. Basic operations 5. Spatial operations 6. Dataset examples Starting out Sign in for the first time Create db Add pgrouting Add user and password Set backend Restart server Change versions (collation version mismatch) Importing Import vector Import raster Import json Copy db to db Copy table to table Remove style info Exporting Export to svg, one file per feature Export to svg, one file per table Export to csv Export to ogr Export to json Export to geojson HTML table Markdown Basic operations Print from shell without formatting List tables List columns Drop tables with wildcard Add important columns Vacuum Save to external file Cast with mixed column Column to row List json keys Export json keys convert to hstore Convert from hstore List hstore keys Select hstore keys Select boolean type Random select Distinct select Create table from select Replace string Concat strings Split part Split + replace Count Group and count Rank by variable Aggregate Calculate stats Look up dictionary Generate series Edit field Spatial operations Print available epsg/srid Add missing epsg/srid (see spatialreference.org) Create geometry column Change geometry type Extract geometry collection Reproject Update SRID Translate Make 3d Make valid Get angle of line from start and end points (degrees) Get road angle from closest point (degrees) Label angle epsg:432","default_branch":null,"files":null,"tree":[],"storefront":"/r/geographyclub","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/geographyclub/postgis-cookbook/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}