Clipping Data from Postgis. Sutton, T. In linfiniti.com Open Source Geospatial Solutions.
Paper abstract bibtex So you have moved your spatial data into PostGIS and everything is great….until you start wanting to clip it out again. Luckily clipping data within the postgres environment is trivial with the little help of SQL. However I wanted something a little more fancy - a way to iterate through all my spatial tables and clip out an arbitary polygon, saving the result to a shapefile. To achieve this I wrote a little bash script that does just that. The script will also optionally make sql dumps of the data and clean up after itself when it is done. [...]
@incollection{suttonClippingDataPostgis2009,
title = {Clipping Data from {{Postgis}}},
author = {Sutton, Tim},
date = {2009},
publisher = {{linfiniti.com Open Source Geospatial Solutions}},
url = {https://archive.today/N6vyX},
abstract = {So you have moved your spatial data into PostGIS and everything is great….until you start wanting to clip it out again. Luckily clipping data within the postgres environment is trivial with the little help of SQL. However I wanted something a little more fancy - a way to iterate through all my spatial tables and clip out an arbitary polygon, saving the result to a shapefile. To achieve this I wrote a little bash script that does just that. The script will also optionally make sql dumps of the data and clean up after itself when it is done. [...]},
keywords = {*imported-from-citeulike-INRMM,~INRMM-MiD:c-11893145,codelet,command-line,data,data-transformation-codelets,geospatial,gnu-bash,postgis}
}
Downloads: 0
{"_id":"6Jo5xmxc9qvhBSWLk","bibbaseid":"sutton-clippingdatafrompostgis","authorIDs":[],"author_short":["Sutton, T."],"bibdata":{"bibtype":"incollection","type":"incollection","title":"Clipping Data from Postgis","author":[{"propositions":[],"lastnames":["Sutton"],"firstnames":["Tim"],"suffixes":[]}],"date":"2009","publisher":"linfiniti.com Open Source Geospatial Solutions","url":"https://archive.today/N6vyX","abstract":"So you have moved your spatial data into PostGIS and everything is great….until you start wanting to clip it out again. Luckily clipping data within the postgres environment is trivial with the little help of SQL. However I wanted something a little more fancy - a way to iterate through all my spatial tables and clip out an arbitary polygon, saving the result to a shapefile. To achieve this I wrote a little bash script that does just that. The script will also optionally make sql dumps of the data and clean up after itself when it is done. [...]","keywords":"*imported-from-citeulike-INRMM,~INRMM-MiD:c-11893145,codelet,command-line,data,data-transformation-codelets,geospatial,gnu-bash,postgis","bibtex":"@incollection{suttonClippingDataPostgis2009,\n title = {Clipping Data from {{Postgis}}},\n author = {Sutton, Tim},\n date = {2009},\n publisher = {{linfiniti.com Open Source Geospatial Solutions}},\n url = {https://archive.today/N6vyX},\n abstract = {So you have moved your spatial data into PostGIS and everything is great….until you start wanting to clip it out again. Luckily clipping data within the postgres environment is trivial with the little help of SQL. However I wanted something a little more fancy - a way to iterate through all my spatial tables and clip out an arbitary polygon, saving the result to a shapefile. To achieve this I wrote a little bash script that does just that. The script will also optionally make sql dumps of the data and clean up after itself when it is done. [...]},\n keywords = {*imported-from-citeulike-INRMM,~INRMM-MiD:c-11893145,codelet,command-line,data,data-transformation-codelets,geospatial,gnu-bash,postgis}\n}\n\n","author_short":["Sutton, T."],"key":"suttonClippingDataPostgis2009","id":"suttonClippingDataPostgis2009","bibbaseid":"sutton-clippingdatafrompostgis","role":"author","urls":{"Paper":"https://archive.today/N6vyX"},"keyword":["*imported-from-citeulike-INRMM","~INRMM-MiD:c-11893145","codelet","command-line","data","data-transformation-codelets","geospatial","gnu-bash","postgis"],"downloads":0},"bibtype":"incollection","biburl":"https://tmpfiles.org/dl/58794/INRMM.bib","creationDate":"2020-07-02T22:41:30.304Z","downloads":0,"keywords":["*imported-from-citeulike-inrmm","~inrmm-mid:c-11893145","codelet","command-line","data","data-transformation-codelets","geospatial","gnu-bash","postgis"],"search_terms":["clipping","data","postgis","sutton"],"title":"Clipping Data from Postgis","year":null,"dataSources":["DXuKbcZTirdigFKPF"]}