14,162 reputation
13366
bio website sites.google.com/site/mwtoews
location Wellington, New Zealand
age 34
visits member for 3 years, 7 months
seen 6 hours ago

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


10h
awarded  Explainer
1d
revised Calculate min distance between points in PostGIS
formatting
2d
comment Polygon from CSV ∂x-∂y values
Scripting with what? If you only have one of these files, you should just use a spreadsheet to find the coordinates, since this will take a fraction of the time than learning and debugging a script in any language.
Sep
27
reviewed Approve suggested edit on Geoserver to PostGres database using a hostname
Sep
26
revised How to validate OpenLayers area calculation using PostGIS?
added 324 characters in body
Sep
24
revised How to find all distinct values from a single column of an attribute table with GDAL (Python)?
last fix
Sep
24
revised How to find all distinct values from a single column of an attribute table with GDAL (Python)?
deleted 24 characters in body
Sep
24
revised How to find all distinct values from a single column of an attribute table with GDAL (Python)?
added 283 characters in body
Sep
24
answered How to find all distinct values from a single column of an attribute table with GDAL (Python)?
Sep
24
answered Import xyz data from csv into gdal
Sep
23
comment How to validate OpenLayers area calculation using PostGIS?
The documentation for GeographicLib is far from "poor". Look again. Furthermore, here is an example.
Sep
23
revised How to validate OpenLayers area calculation using PostGIS?
added 60 characters in body
Sep
23
revised How to validate OpenLayers area calculation using PostGIS?
added 416 characters in body
Sep
23
comment PostGIS query losing geometry column information
Maybe you intend to use ST_Union
Sep
23
revised PostGIS query losing geometry column information
added 125 characters in body
Sep
23
comment PostGIS query losing geometry column information
Try ST_CollectionExtract
Sep
23
answered PostGIS query losing geometry column information
Sep
23
comment How to validate OpenLayers area calculation using PostGIS?
Edit 1 has a different start/end point, with a Cartesian area 17100864718054.7 m², which is closer but still different. Double-check your inputs.
Sep
23
answered How to validate OpenLayers area calculation using PostGIS?
Sep
22
comment R PostGIS convert SpatialPolygon to PostGIS table
Is this going to a new PostGIS table, or updating to an existing table?