[postgis-users] St_intersects using GeometryCollection

2017-04-11 Thread Nick Ward
Hello, I need to be able to perform an ST_intersects with a geometry that could be a GeometryCollection. I understand this is not supported from the PostGis documentation so I have written this query: select t.geometry from schema.table t where (st_intersects(t.geometry, st_collectionextract(

Re: [postgis-users] Raster2pgsql - preserving number of decimal places

2016-09-26 Thread Nick Ward
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Mateusz Loskot Sent: 24 September 2016 22:11 To: PostGIS Users Discussion Subject: Re: [postgis-users] Raster2pgsql - preserving number of decimal places On 24 Sep 2016 22:56, "Nick Ward" mailto:nick.w...@landmark.co.

[postgis-users] Raster2pgsql - preserving number of decimal places

2016-09-24 Thread Nick Ward
Hello, I'm investigating loading some height data into Postgis as type Raster. It comes in .asc files and I am using raster2pgsql and psql to load it. I'm running with PostgreSQL 9.5.2 and POSTGIS="2.2.2 r14797". I've tried the following raster2pgsql combinations: raster2pgsql -s 27700 -I -C -M