188 reputation
11
bio website
location Auckland, New Zealand
age
visits member for 1 year, 9 months
seen 2 days ago

GIS Analyst at Shore/Whariki Research Centre, Massey University, Auckland, NZ.


2d
asked PostGIS syntax (function()).*
Sep
25
comment How to fix “Raster layer: Provider is not valid” error when loading PostGIS rasters?
I'm on QGIS 2.4 with Xubuntu 14.04, PostgreSQL 9.1 and PostGIS 2.X and I get the same issue. Need some solutions, or means tosome solutions.
Sep
24
asked What do pixeltypes in PostGIS raster mean?
Sep
24
awarded  Autobiographer
Sep
23
comment Collecting multipolygons into a single multipolygon with ST_Collect() in PostGIS
I didn't require the ST_Buffer but thanks for the heads up. A good answer.
Sep
23
accepted Collecting multipolygons into a single multipolygon with ST_Collect() in PostGIS
Sep
23
comment Collecting multipolygons into a single multipolygon with ST_Collect() in PostGIS
The ST_Union worked but I'd really like an answer to a ST_Collect! I will mark it as correct for now :-)
Sep
23
asked Collecting multipolygons into a single multipolygon with ST_Collect() in PostGIS
Sep
23
comment PostGIS query losing geometry column information
It's just for viewing purposes and involves 50,000 odd geometries so it'd be great to be able to collect the multipolygons in one unified multipolygon without having to actually break down the geometry. Regardless, this is probably another question. You have solved the issue I had.
Sep
23
comment PostGIS query losing geometry column information
Yeah I tried that. Just took me back to where I started with an uncollected geometry.
Sep
23
comment PostGIS query losing geometry column information
This solves the issue per se but unfortunately I cannot cast the output as MultiPolygonZ but only as a GeometryCollectionZ which is not able to be plotted in QGIS. How does one cast to as multipolygonz instead of the collection?
Sep
23
revised PostGIS query losing geometry column information
deleted 8 characters in body
Sep
23
accepted PostGIS query losing geometry column information
Sep
23
asked PostGIS query losing geometry column information
Sep
10
awarded  Commentator
Sep
10
comment Split lines into non-overlapping subsets based on points
Can you post this answer as an answer in code please? I'd like to look at that option as well as I'm a bit of a newbie to SQL.
Aug
20
revised Add locations to pgRouting network
edited body
Aug
20
accepted Moving SpatiaLite Table into PostgreSQL using ogr2ogr?
Aug
20
accepted Add locations to pgRouting network
Aug
20
answered Add locations to pgRouting network