826 reputation
24
bio website
location
age
visits member for 2 years, 4 months
seen Jun 25 at 6:02

I develop for the PostGIS project, specifically the raster component. Besides general PostGIS raster development, I also work on the raster2pgsql loader. I also poke at the PostGIS raster driver found in GDAL.


Sep
24
awarded  Autobiographer
Jul
6
awarded  Yearling
Feb
27
answered Is rid=2 significant in PostGIS raster structure?
Feb
21
comment how to specify -t critical dowloading raster with raster2pgsql
If the raster was broken down into smaller rectangles, each rectangle would be a tile. Hence why the values for the -t parameter is in the number pixels width and height. The value 463.313x463.313 is not the dimension but rather the scale of the each pixel. What this means for SRID 3006 is that each pixel's width and height is equivalent to 463.313 metres on Earth's surface.
Feb
12
answered how to specify -t critical dowloading raster with raster2pgsql
Jul
6
awarded  Yearling
Jun
4
comment It seems there is a bug in St_Clip function of PostGIS
What version of PostGIS are your running? {{{ SELECT postgis_full_version(); }}}
Jun
3
answered It seems there is a bug in St_Clip function of PostGIS
May
6
answered Raster Tile Merge Performance of PostGIS 2.0
Apr
11
answered Difference in raster size using raster2pgsql
Nov
21
answered Is it possible to export raster data from PostGIS or MapServer as a base64 string?
Oct
22
answered raster2pgsql part of PostGIS?
Oct
12
answered Error when using pgsql2shp
Oct
12
answered Error when starting up Postgis Manager plugin in Quantum GIS
Oct
12
comment Error when using pgsql2shp
You'll want to provide more information before anyone can give an informed answer. What is the output from: SELECT postgis_full_version();
Oct
4
comment Update PostGIS after updating GDAL?
Yes. Rebuild PostGIS again as that is always the safest option. If you're running GDAL trunk, things should work. It works far better for my projects than 1.9.x
Oct
3
awarded  Commentator
Oct
3
comment Why won't this PostGIS query display in QGIS
The error makes sense. I'm guessing DB Manager is only using read-only transactions but nextval() will change the database (increments the sequence). You'll want to remove the nextval() and try again.
Oct
3
answered Access PostGIS Raster layer through mapserver
Sep
28
answered Loading geotiffs into PostGIS using raster2pgsql