15,956 reputation
13573
bio website sites.google.com/site/mwtoews
location Wellington, New Zealand
age 34
visits member for 3 years, 11 months
seen 5 hours ago

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


1d
answered Can you do aggregate functions among nearby geometry in PostGIS?
1d
awarded  gdal
2d
answered Adding Origin to Geotiff using Python GDAL?
2d
answered GeoTiff to ndarray
2d
awarded  Revival
Jan
22
comment postgis - get nth point of a polygon
This is a feature for PostGIS 2.1. For older versions a more complicated method needs to be done...
Jan
22
revised postgis - get nth point of a polygon
this works for PostGIS 2.1
Jan
22
awarded  Nice Answer
Jan
22
answered postgis - get nth point of a polygon
Jan
21
comment Postgis don't use spacial-index with st_intersects
Cool, looks like the query planner did indeed rewrite the query, similar to the example in the manual.
Jan
21
comment Postgis don't use spacial-index with st_intersects
The way this statement is structured, the planner rewrites the subquery into the main query. Compare the last two SQL queries in the manual, which is the same as your answer to mine. They are the same to the planner.
Jan
21
answered Postgis don't use spacial-index with st_intersects
Jan
21
answered How to convert float raster to vector with python GDAL
Jan
21
revised How to convert float raster to vector with python GDAL
edited tags
Jan
15
answered Help interpret GeoTif pixel value python gdal: connection between pixel value, RGB values and physical concentration?
Jan
14
answered Is there an open standard for raster information?
Jan
14
revised Downloading raster data into python from postgis using psycopg2
retag
Jan
14
revised Downloading raster data into python from postgis using psycopg2
expand answer for enable driver
Jan
14
comment Downloading raster data into python from postgis using psycopg2
@MayankAgarwal updated answer for the rt_raster_to_gdal error.
Jan
14
revised Downloading raster data into python from postgis using psycopg2
expand answer for enable driver