Dear Jorge, Seems to work for me. I'm not sure if I did it correctly, here is what I did:
1) download the raster2pgsql.py file at http://trac.osgeo.org/postgis/browser/trunk/raster/scripts/python/raster2pgsql.py?rev=6815 2) place it in /usr/lib/postgresql/8.4/bin/ for convenience (this is where shp2pgsql lives) and create a link in /usr/bin/ 3) convert my GeoTiff again: raster2pgsql -r RoadDensity_2002_2006_CV_UTM19_25m.tif -t roaddensity_2002_2006_cv_utm19_25m -s 26919 -k 50x50 -I > RoadDensity_2002_2006_CV_UTM19_25m.sql I noticed that I had to use the -t option now (it was absent in my gdal2raster.py loader). 4) load it in the DB as usual, using the postgres user: psql -f RoadDensity_2002_2006_CV_UTM19_25m.sql geodb And it proceeded without any error or warnings. I haven't tested it thoroughly though, but it seems to work fine now! Thanks a lot for the correction! Mathieu. Le 2011-02-14 07:20, Jorge Arévalo a écrit : > 2011/2/14 Jorge Arévalo <[email protected]>: >> 2011/2/12 Mathieu Basille <[email protected]>: >>> Dear Jorge, >>> >>> Thx for this. Shall I do anything about it? I uploaded the problematic >>> raster for Pierre here: >>> >>> http://ase-research.org/tmp/postgis/ >>> >>> Pierre, are you working on this? >>> >>> Sorry if I'm a bit confused, I'm not quite sure what's the best to do as I'm >>> not familiar with the PostGIS Raster organisation... >>> And I don't want to add more work for the people involved in PostGIS Raster >>> than required. >>> >>> All the best, >>> Mathieu. >>> >>> >>> >> >> Hi Mathieu, >> >> I think is enough. The loader should know how to deal with that. >> >> About PostGIS Raster, basically there's a roadmap >> (http://trac.osgeo.org/postgis/wiki/WKTRaster/PlanningAndFunding) and >> a list of known bugs and new required features >> (http://trac.osgeo.org/postgis/report/17). >> >> So, if you found a new problem (like your case) or a lack of >> something, you can use the list to ask for it, and a new ticket will >> be created when needed (like your case, again). >> >> Apart from this, the only thing you need is patience :-) >> >> Thanks again for reporting this, and best regards, >> >> -- >> Jorge Arévalo >> Internet & Mobilty Division, DEIMOS >> [email protected] >> http://es.linkedin.com/in/jorgearevalo80 >> http://mobility.grupodeimos.com/ >> http://gis4free.wordpress.com >> http://geohash.org/ezjqgrgzz0g >> > > > Hello again, > > I think the loader problem is solved in r6815. Mathieu, could you > please update your working copy of PostGIS? You don't need to rebuild. > Just execute the loader again, and test the generated SQL, please. > > Best regards, > -- ~$ whoami Mathieu Basille, Post-Doc ~$ locate Laboratoire d'Écologie Comportementale et de Conservation de la Faune + Centre d'Étude de la Forêt Département de Biologie Université Laval, Québec ~$ info http://ase-research.org/basille ~$ fortune ``If you can't win by reason, go for volume.'' Calvin, by Bill Watterson. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
