696 reputation
413
bio website libregis.org
location Spain
age 34
visits member for 3 years, 4 months
seen Jul 21 at 21:22

I'm a software developer, focused on GIS. PostGIS and GDAL committer. I'd love to add 'where' to people's lives.


Nov
27
asked min function not found compiling osrm
Nov
25
comment How to export raster from PostGIS enabled DB as GTiff with gdal_translate
Ok. So, you stick with ogr2ogr. If you installed GDAL properly (and looks that you did, because PostGIS found it), ogr2ogr is installed. Probably at /usr/local/bin. Check if that path is added to your system's path. And ensure where ogr2ogr is with: sudo find / -name ogr2ogr
Nov
25
comment How to export raster from PostGIS enabled DB as GTiff with gdal_translate
You don't need FWTools to use ogr2ogr if you compiled GDAL. It's included. You may need to add the path where the new GDAL installed the binaries (gdalinfo, gdal_translate, ogr2ogr...) to system path, if your problem is those commands are not found. About pgsql2shp, is not related with GDAL, and as long as I know, it's not packed with FWTools. It's a PostGIS tool. Which version of PostGIS are you using?
Nov
22
comment How to export raster from PostGIS enabled DB as GTiff with gdal_translate
'gdal-config --prefix' tells you the PATH where default GDAL library (1.6 in your case) is installed. Probably, $HOME/FWTools. You can get rid of that folder. Once done, the default GDAL should be 1.9. You may need to update your PATH variable, to ensure it doesn't contain references to the deleted FWTools folder.
Nov
21
comment How to export raster from PostGIS enabled DB as GTiff with gdal_translate
OMG, absolutely. I've just fixed it. That was a silly and annoying mistake. Sorry for that.
Nov
21
comment How to export raster from PostGIS enabled DB as GTiff with gdal_translate
As afalciano said, you can't use QGIS 2.0 yet. I didn't port the plugin to QGIS 2.0. I want to do it before the end of this year. And yes, you should use the last version of GDAL from trunk. It contains some improvements to PostGIS Raster driver.
Nov
21
answered How to export raster from PostGIS enabled DB as GTiff with gdal_translate
Nov
20
revised PostGIS: Calculate the length of just the portion of linestring that intersect with a polygon
Added more details
Nov
20
comment PostGIS: Calculate the length of just the portion of linestring that intersect with a polygon
Mmm... same problems. I've added my real data and the queries I've executed. So, if you want to try...
Nov
20
revised PostGIS: Calculate the length of just the portion of linestring that intersect with a polygon
Added the results of more tries
Nov
19
comment PostGIS: Calculate the length of just the portion of linestring that intersect with a polygon
Thanks! I've updated the question. I'm closer now.
Nov
19
revised PostGIS: Calculate the length of just the portion of linestring that intersect with a polygon
added 597 characters in body
Nov
19
asked PostGIS: Calculate the length of just the portion of linestring that intersect with a polygon
Nov
19
awarded  Popular Question
Nov
1
comment Create a band mask based on pixel locations, not in pixel values
Well, I guess it's time to learn how to use GRASS. BTW, many thanks!
Nov
1
comment Create a band mask based on pixel locations, not in pixel values
I'm a novice in GRASS, but this looks like similar: grass.osgeo.org/grass64/manuals/r.clump.html
Nov
1
comment Create a band mask based on pixel locations, not in pixel values
Wow! That looks exactly what I'm looking for. With which tool are you able to do it? QGIS? I assume that, but I can't see the option in QGIS 2.0.
Nov
1
asked Create a band mask based on pixel locations, not in pixel values
Oct
31
revised Good algorithm to detect “wrong” features in a vectorial coverage
Important missing part
Oct
31
comment What is a good way to retrieve geographic data along with imgs and mp3 files?
Ok, probably the mobile devices can handle a 100MB file as SQLite blob. My problem, as the backend guy, is that I don't want a 'dirty' solution. Currently, I create a json with relative links to mp3 and imgs, and this json, along with them, is zipped and sent to the user. It works, but I don't like it. I was thinking about an elegant format to store and retrieve img/audio/video files to a mobile client (MBTiles sounds elegant, for example)