Skip to content

Instantly share code, notes, and snippets.

@jef-n
Created January 22, 2015 22:09
Show Gist options
  • Save jef-n/f8a80edd53cc7428572b to your computer and use it in GitHub Desktop.
Save jef-n/f8a80edd53cc7428572b to your computer and use it in GitHub Desktop.
qgis=> select st_astext( st_offsetcurve( st_geomfromtext( 'LINESTRING(436533.041 5755061.11,436420.979 5755061.071,436372.505 5755061.054,436346.382 5755061.045)' ), -0.17 ) );
st_astext
-------------------------------------------------------------------------------------------------------------------------------------------------------------
MULTILINESTRING((436420.97894038 5755061.24099999,436533.040940836 5755061.27999999),(436346.381941431 5755061.21499999,436372.504941431 5755061.22399999))
(1 row)
qgis=> select postgis_full_version();
NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed?
postgis_full_version
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" (core procs from "2.1.2 r12389" need upgrade) RASTER (raster procs from "2.1.2 r12389" need upgrade)
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment