561 reputation
3
bio website
location
age
visits member for 10 months
seen yesterday
stats profile views 17

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.


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
Sep
19
comment Postgis error on select all intersetcs of a polygon
Your POLYGON WKT is improperly structured. postgis.refractions.net/documentation/manual-svn/…
Sep
14
answered Why are Postgis sequences not automatically updating in QGIS?
Sep
14
comment Why does ST_Transform fail?
What versions of PostGIS and PROJ.4 are you using? Testing the suggested SRID 32647 works with PostGIS -trunk and PROJ.4 4.8.0
Aug
31
answered ST_Intersects returns “incomplete” results
Aug
31
comment What are the advantages/disadvantages of populating a PostGIS database with Raster information?
in-db is where the source raster (tile) is stored in PostgreSQL. out-db only stores metadata describing the source raster in PostgreSQL and any functions in PostGIS will call the source raster files as needed. In my testing, out-db is slower than in-db. As to why out-db is slower, my suspicion is that PostgreSQL is able to cache the in-db data in its shared buffers while out-db requires calling the source file every time.
Aug
31
answered How to speed up Postgis raster layer display in QGIS?
Aug
28
answered How to create a point table from a remote csv file?
Aug
28
answered What are the advantages/disadvantages of populating a PostGIS database with Raster information?