Clipping Data from Postgis. Sutton, T. In linfiniti.com Open Source Geospatial Solutions.
Clipping Data from Postgis [link]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