16,915 reputation
14179
bio website sites.google.com/site/mwtoews
location Wellington, New Zealand
age 34
visits member for 4 years, 2 months
seen 22 mins ago

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


2d
comment Why don't shapefiles online contain the coastline (country borders)?
See: gis.stackexchange.com/q/13285/1872
2d
revised Clipping rasters
using arcpy
Apr
15
answered Postgis 2.1 Inconsistent with spatialreference.org
Apr
15
revised Store a GeoJSON FeatureCollection to postgres with postgis
added 1409 characters in body
Apr
14
revised Store a GeoJSON FeatureCollection to postgres with postgis
added 598 characters in body
Apr
14
revised Store a GeoJSON FeatureCollection to postgres with postgis
use operators
Apr
14
answered Store a GeoJSON FeatureCollection to postgres with postgis
Apr
14
revised Store a GeoJSON FeatureCollection to postgres with postgis
added 240 characters in body
Apr
13
awarded  Announcer
Apr
13
reviewed Approve Adding shapefile names in message to progress window/dialog of ArcGIS for Desktop from ArcPy?
Apr
12
answered Problem with a PostGIS trigger
Apr
11
comment geometry_column table not automatically exist
Check the versions (SELECT PostGIS_version()). Until PostGIS 1.5, geometry_columns was a TABLE, but in 2.0 it was changed to a VIEW.
Apr
10
answered Why doesn't my spatial index work?
Apr
9
comment Translate coordinates between different CRS
If the relative positions are preserved, then you can derive an affine transformation to do forward / inverse mapping of coordinates, which can be solved with a few pairs of points from each coordinate system. A 2D affine transformation matrix has 6 coefficients, so you need a minimum of 6 points to solve it.
Apr
9
comment Convert multiline to polygon
The polygon result was made available, not the input polylines.
Apr
8
comment How to add “0” to multiple parts of text value in Field Calculator with Python
or as a simple expression for ArcGIS: '_'.join(s.zfill(4) for s in !field!.split('_'))
Apr
8
comment Misalignment of EPSG:4326 and EPSG:3399 coordinates
The 7par transform from EPSG:31469 are +towgs84=598.1,73.7,418.2,0.202,0.045,-2.455,6.7
Apr
8
reviewed Approve Using GDAL inside MATLAB in Ubuntu
Apr
8
comment Translate coordinates between different CRS
Is pt1 always (e.g.) to the right of pt2, or is the position scrambled? Does the output grid pattern visually match the input grid pattern, like the image in the question?
Apr
7
comment ST_MakePoint returns an error when using Python
From Python, add the return from SELECT postgis_full_version() to your question.