9,944 reputation
11750
bio website linkedin.com/in/mwtoews
location Wellington, New Zealand
age 33
visits member for 2 years, 3 months
seen 10 hours ago
stats profile views 343

I'm a hydrogeologist. An expert of many random things.


May
6
answered How to find lat/lon values for every pixel in a GeoTIFF file?
Apr
30
comment operator does not exist: geometry <#> geometry
also box, circle, polygon are not PostGIS types.
Apr
30
comment operator does not exist: geometry <#> geometry
There is a problem with your installation, since the operator for geometry is not there. How did you install PostGIS to this database? Did you use the EXTENSION, etc.?
Apr
30
comment operator does not exist: geometry <#> geometry
With psql, do you see it with \do <#>? And/or with pgAdmin, do you see it in the list of operators?
Apr
29
comment Are there strategies for dealing with TopologyException errors in PostGIS 2?
@DylanHettinger It is possible that this is a bug, however it is difficult to isolate the offending geometry(ies). If you can, post the WKT/WKB in your question.
Apr
29
answered Postgis 2: Polygon/MultiPolygon in a single column
Apr
29
answered Are there strategies for dealing with TopologyException errors in PostGIS 2?
Apr
28
revised Python, shapely library: is it possible to do an affine operation on shape polygon?
update
Apr
28
comment Python, shapely library: is it possible to do an affine operation on shape polygon?
@AlexL type help(shapely.affinity). Actually I'm nearly done preparing the manual update for the module.
Apr
27
comment Problem reading attribute with Python using osgeo.ogr
sometimes osgeo.ogr.UseExceptions() exposes more details
Apr
26
answered Get the total distance from a point to the end of a linestring
Apr
25
answered Unable to install the PostGIS extension to PostgreSQL on Ubuntu 12.04 LTS
Apr
24
comment How to determine the longest side of a polygon in QGIS?
Two geometries is actually one geometry when you reference the same geometry twice, as I have described. Did you try it?
Apr
23
revised How to create TINs in ArcGIS from triangular elements
wrap up
Apr
23
comment How to create TINs in ArcGIS from triangular elements
This round-about method works perfectly, thanks!
Apr
23
accepted How to create TINs in ArcGIS from triangular elements
Apr
22
awarded  Constituent
Apr
22
answered How to determine the longest side of a polygon in QGIS?
Apr
21
comment Which function for creating a POINT in PostGIS?
@djq yup, it's just a placeholder for the actual SQL code in 1, 2 and 3.
Apr
21
answered Use Python to parse string