[postgis-users] Fwd: geos_3.3.3-1_i386.changes ACCEPTED into unstable
Done. Thanks Francesco Lovergine, and the Debian staff. Could someone update the howto? All the best. Messaggio originale Oggetto: geos_3.3.3-1_i386.changes ACCEPTED into unstable Data: Wed, 23 May 2012 21:47:24 + Mittente: Debian FTP Masters ftpmas...@ftp-master.debian.org A: Francesco Paolo Lovergine fran...@debian.org, Debian GIS Project pkg-grass-de...@lists.alioth.debian.org Accepted: geos_3.3.3-1.debian.tar.gz to main/g/geos/geos_3.3.3-1.debian.tar.gz geos_3.3.3-1.dsc to main/g/geos/geos_3.3.3-1.dsc geos_3.3.3.orig.tar.gz to main/g/geos/geos_3.3.3.orig.tar.gz libgeos++-dev_3.3.3-1_i386.deb to main/g/geos/libgeos++-dev_3.3.3-1_i386.deb libgeos-3.3.3_3.3.3-1_i386.deb to main/g/geos/libgeos-3.3.3_3.3.3-1_i386.deb libgeos-c1_3.3.3-1_i386.deb to main/g/geos/libgeos-c1_3.3.3-1_i386.deb libgeos-dbg_3.3.3-1_i386.deb to main/g/geos/libgeos-dbg_3.3.3-1_i386.deb libgeos-dev_3.3.3-1_i386.deb to main/g/geos/libgeos-dev_3.3.3-1_i386.deb libgeos-doc_3.3.3-1_all.deb to main/g/geos/libgeos-doc_3.3.3-1_all.deb libgeos-ruby1.8_3.3.3-1_i386.deb to main/g/geos/libgeos-ruby1.8_3.3.3-1_i386.deb Changes: geos (3.3.3-1) unstable; urgency=low . * New upstream bugfixing version. This is useful because correctly support new topology-enabled for Postgis 2.0. * Policy bumped to 3.9.3, no changes required. * Debhelper level set to 9. * Patch geos-config revised, partially merged upstream. Override entries for your package: geos_3.3.3-1.dsc - source science libgeos++-dev_3.3.3-1_i386.deb - optional libdevel libgeos-3.3.3_3.3.3-1_i386.deb - optional libs libgeos-c1_3.3.3-1_i386.deb - optional libs libgeos-dbg_3.3.3-1_i386.deb - extra debug libgeos-dev_3.3.3-1_i386.deb - optional libdevel libgeos-doc_3.3.3-1_all.deb - optional doc libgeos-ruby1.8_3.3.3-1_i386.deb - optional ruby Announcing to debian-devel-chan...@lists.debian.org Thank you for your contribution to Debian. ___ Pkg-grass-devel mailing list pkg-grass-de...@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Fwd: geos_3.3.3-1_i386.changes ACCEPTED into unstable
On 24 May 2012 20:10, Paolo Cavallini cavall...@faunalia.it wrote: Done. Thanks Francesco Lovergine, and the Debian staff. Could someone update the howto? All the best. I've added a wiki page: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Debian70src and updated the series: install PostGIS version X on your distro Y: http://trac.osgeo.org/postgis/wiki/UsersWikiInstall however, I haven't had a chance to test this method yet (bandwidth is limited where I'm at .. have to wait until next month to download the Debian 7.0 ISO). Basically, the instructions are identical as to the Debian 6.0 source installation, but the geos compile step is removed, and the version of PostgreSQL is adjusted. -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] rt_resample test fails on PostGIS 2.0, Debian 6 amd64
The subject line says everything. I try to compile PostGIS 2.0 on an amd64 Debian 6 (squeeze). ./configure works ok, and so does make, but here's part of the output of make test: rt_resample .. failed (diff expected obtained: /tmp/pgis_reg/test_51_diff) I attach the test_51_diff file. The problem occurs both on 2.0.0, and on the latest 2.0-branch svn. Am I doing something wrong? Could someone help me get past this problem? Thanks! --- rt_resample_expected2012-05-24 09:21:33.0 + +++ /tmp/pgis_reg/test_51_out 2012-05-24 10:34:40.562455574 + @@ -11,35 +11,35 @@ 1.14|992163|11|11|1|1000.000|-1000.000|0.000|0.000|-500100.000|600950.000|t|t|t 1.15|992163|201|201|1|50.000|50.000|0.000|0.000|-500040.000|589957.000|t|t|t 1.16|992163|84|84|1|121.000|121.000|0.000|0.000|-500093.000|589875.000|t|t|t -1.17|993310|243|243|1|50.000|50.000|0.000|0.000|950710.000|1397157.000|t|t|t -1.18|993309|243|243|1|50.000|50.000|0.000|0.000|950760.000|1396957.000|t|t|t +1.17|993310|248|235|1|50.000|50.000|0.000|0.000|950710.000|1397557.000|t|t|t +1.18|993309|248|235|1|50.000|50.000|0.000|0.000|950760.000|1397357.000|t|t|t 1.19|992163|10|10|1|1000.000|-1000.000|3.000|3.000|-500030.000|60.000|t|t|t 1.2|993310|12|12|1|1009.894|-1009.894|0.000|0.000|950732.188|1409281.783|t|t|t 1.20|993310|12|12|1|1009.894|-1009.894|3.000|3.000|950691.792|1409281.783|t|t|t 1.21|993309|12|12|1|1009.916|-1009.916|1.000|3.000|950742.107|1409088.896|t|t|t -1.22|993310|24|24|1|500.000|500.000|3.000|3.000|950657.188|1397356.783|t|t|t -1.23|993310|26|26|1|500.000|500.000|0.000|6.000|950452.000|1396632.000|t|t|t +1.22|993310|25|24|1|500.000|500.000|3.000|3.000|950657.188|1397356.783|t|t|t +1.23|993310|26|25|1|500.000|500.000|0.000|6.000|950452.000|1397132.000|t|t|t 1.24|992163|207|101|1|50.000|-100.000|3.000|0.000|-500319.000|600056.000|t|t|t 1.25|992163|207|101|1|50.000|-100.000|3.000|0.000|-500319.000|600056.000|t|t|t 1.26|992163|150|150|1|66.667|-66.667|0.000|0.000|-50.000|60.000|t|t|t -1.27|993310|150|150|1|80.792|-80.792|0.000|0.000|950732.188|1409281.783|t|t|t +1.27|993310|150|150|1|82.219|-78.090|0.000|0.000|950732.188|1409281.783|t|t|t 1.28|992163|5|5|1|2064.200|-2291.200|0.000|0.000|-500321.000|601456.000|t|t|t 1.29| 1.3|993309|12|12|1|1009.916|-1009.916|0.000|0.000|950762.305|1409088.896|t|t|t 1.30|984269|12|8|1|0.012|-0.012|0.000|0.000|-107.029|50.206|t|t|t 1.31|974269|12|8|1|0.012|-0.012|0.000|0.000|-107.029|50.206|t|t|t 1.4|994269|12|8|1|0.012|-0.012|0.000|0.000|-107.029|50.206|t|t|t -1.5|993310|24|24|1|500.000|500.000|0.000|0.000|950732.188|1397281.783|t|t|t +1.5|993310|25|23|1|500.000|500.000|0.000|0.000|950732.188|1397781.783|t|t|t 1.6|992163|10|10|1|1000.000|-1000.000|0.000|0.000|-50.000|60.000|t|t|t 1.7|992163|10|10|1|1000.000|-1000.000|0.000|0.000|-50.000|60.000|t|t|t 1.8|992163|20|20|1|500.000|500.000|0.000|0.000|-50.000|59.000|t|t|t 1.9|992163|40|40|1|250.000|250.000|0.000|0.000|-50.000|59.000|t|t|t 2.1|993310|12|12|1|1009.894|-1009.894|0.000|0.000|950732.188|1409281.783|t|t|t -2.10|993310|24|24|1|500.000|500.000|0.000|0.000|950732.188|1397281.783|t|t|t -2.11|993309|121|121|1|100.000|100.000|0.000|0.000|950762.305|1396988.896|t|t|t +2.10|993310|25|23|1|500.000|500.000|0.000|0.000|950732.188|1397781.783|t|t|t +2.11|993309|123|117|1|100.000|100.000|0.000|0.000|950762.305|1397388.896|t|t|t 2.12|993310|6|6|1|2000.000|2000.000|0.000|0.000|950732.188|1397281.783|t|t|t 2.13|993310|8|8|1|1500.000|1500.000|0.000|0.000|950732.188|1397281.783|t|t|t -2.14|993310|24|24|1|500.000|500.000|0.000|0.000|950732.188|1397281.783|t|t|t +2.14|993310|25|23|1|500.000|500.000|0.000|0.000|950732.188|1397781.783|t|t|t 2.15|993310|16|16|1|750.000|750.000|0.000|0.000|950732.188|1397281.783|t|t|t 2.2|993309|12|12|1|1009.916|-1009.916|0.000|0.000|950762.305|1409088.896|t|t|t 2.3|994269|12|8|1|0.012|-0.012|0.000|0.000|-107.029|50.206|t|t|t ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] rt_resample test fails on PostGIS 2.0, Debian 6 amd64
I forgot to mention that I'm using PostgreSQL 9.1 (from backports) and geos-3.3.3 (custom Debian packaged by me). On 2012-05-24 14:44, Antonis Christofides wrote: The subject line says everything. I try to compile PostGIS 2.0 on an amd64 Debian 6 (squeeze). ./configure works ok, and so does make, but here's part of the output of make test: rt_resample .. failed (diff expected obtained: /tmp/pgis_reg/test_51_diff) I attach the test_51_diff file. The problem occurs both on 2.0.0, and on the latest 2.0-branch svn. Am I doing something wrong? Could someone help me get past this problem? Thanks! ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
I understand all steps I have to following to get the installation, but: Do we know if someone installed PostGIS 2 with PostgreSQL 9.1.3-2 in Ubuntu 12_04 LTS Thanks 2012/5/24 Jeff Meyer j...@gwhat.org Hi Samran - I'm relatively new to these parts, but I think the answer depends on how much data you're trying to migrate from prior versions of Postgres. If you're just getting started with PostGIS, I'd remove all of those packages and follow the instructions linked below. After that, go ahead and reinstall GeoServer. It should see that you've already install Postgres and PostGIS and be just fine. (I think...) If you need to migrate data, SQL scripts, etc., I'd suggest you read up on migration or get some other advice. I'd like to help, but don't have any experience in those areas. Good luck! ; ) Thanks, Jeff -- *From:* Smaran Harihar smaran.hari...@gmail.com *To:* Jeff Meyer j...@gwhat.org; PostGIS Users Discussion postgis-users@postgis.refractions.net *Sent:* Wednesday, May 23, 2012 2:13 PM *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2 Thanks for the reply Jeff. The extensions in my database is only plpgsql. Nothing else. Also I did not separately install PostGIS. I installed it along with GeoServer using the Synaptic. The complete list of installed packages are as follows, 1. postgresql 9.1 + postgis 1.5.3 2. postgis 1.5.3 3. postgresql 8.4 + postgis 1.5.3 4. opengeo-postgis 2.4.4 I did not install any from the source as in the wiki link you gave. So If I remove, which ones should I remove?? Also since I need it to be connected to Geoserver will removing the package affect the opengeo suite? Thanks Regards, Smaran Harihar On Wed, May 23, 2012 at 12:45 PM, Jeff Meyer j...@gwhat.org wrote: Mean to add this before - it's an image of the Extensions folder in pgAdmin III: http://s1064.photobucket.com/albums/u361/jeffmegwhat/?action=viewcurrent=postgisextensions.png -- *From:* Jeff Meyer j...@gwhat.org *To:* PostGIS Users Discussion postgis-users@postgis.refractions.net *Sent:* Wednesday, May 23, 2012 12:42 PM *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2 Hi Smaran - I can't speak to what went wrong during your install, but have you double-checked your ability to add extensions through pgAdmin III? You should be able to open your db, navigate to extensions, right click on the extensions label, and then click New Extension. If PostGIS isn't listed as a possible extension, then something went wrong in the PostGIS install. You may want to then do an 'apt-get remove postgis' and then follow the instructions at: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204. Thanks, Jeff -- *From:* Smaran Harihar smaran.hari...@gmail.com *To:* PostGIS Users Discussion postgis-users@postgis.refractions.net *Sent:* Wednesday, May 23, 2012 10:09 AM *Subject:* Re: [postgis-users] Ubuntu and Postgresql9.1.3-2 Hi, I have already installed PostGIS 2.0 and Postgres 9.3.1 using synaptic package manager. Now when I run your commands in psql console, shpRepo=# CREATE EXTENSION postgis; I am receiving an error, ERROR: could not open extension control file /usr/share/postgres/9.1/extension/postgis.control: No such file or directory Where did I go wrong? On Wed, May 23, 2012 at 9:58 AM, Brian H Wilson br...@wildsong.bizwrote: On 5/23/2012 8:08 AM, José María Amuedo wrote: Someone know how can linstall postgresql-9.1.3-2-linux.run in Ubuntu 12.04? I installed it but I can not to launch stackbuilder to configure new tools like postgis. As Jeff said, installing on Ubuntu 12.04 using apt-get is easy, and I've only used stackbuilder once. You don't really need it. I like to experiment with the latest so currently I do install PostGIS from sources. The version in the official Ubuntu repository is still at 1.5.3 There are instructions here for PostGIS 2 packages that look pretty promising: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204 My own grueling details are here: http://wildsong.biz/index.php/PostGIS Feedback welcome. Hope this helps, Brian __**_ postgis-users mailing list postgis-users@postgis.**refractions.netpostgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Thanks Regards Smaran Harihar ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net
Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
On Thu, May 24, 2012 at 07:27:38AM -0700, Brian H Wilson wrote: On 05/24/2012 05:13 AM, José María Amuedo wrote: I understand all steps I have to following to get the installation, but: Do we know if someone installed PostGIS 2 with PostgreSQL 9.1.3-2 in Ubuntu 12_04 LTS Thanks It happens my new desktop has a recent Ubuntu 12.04 install (AWESOME new computer! :-), and I don't usually run PostGIS on it (I keep it on a server in the other room) so I removed the postgres client previously installed on the desktop like this sudo apt-get -f remove postgresql-client postgresql-client-common Next I tried these instructions on the computer I am sitting at, from the first link I sent yesterday sudo apt-get install python-software-properties sudo apt-add-repository ppa:sharpie/for-science sudo apt-get update sudo apt-get install postgresql-9.1-postgis Now I have psql --version psql (PostgreSQL) 9.1.3 contains support for command-line editing I also have two versions of GDAL installed now, for what it's worth, postgres@laysan:~$ /usr/bin/gdalinfo --version GDAL 1.7.3, released 2010/11/10 postgres@laysan:~$ /usr/local/bin/gdalinfo --version GDAL 2.0dev, released 2011/12/29 I have found having different versions of things can be a problem, hence I usually just install things from sources to get all the features and most up tp date gdal possible. But for now I press on... In the past I have always used the procedure outlined on my wiki to add PostGIS to PostgreSQL. Therefore creating a geodatabase meant using a template. Today I try the command you suggested. This is where I have a problem -- using EXTENSION postgres@laysan:~$ createdb test postgres@laysan:~$ psql test psql (9.1.3) Type help for help. test=# CREATE EXTENSION postgis; ERROR: function st_asgml(integer, geography, integer, integer, text, text) does not exist test=# Seems like I got further than you José but still encountered a problem. It's a recent bug. Someone packaged a broken revision of PostGIS. Current trunk is fine, if you mail the package maintainer he'll know what to do. --strk; ,--o-. | __/ |Delivering high quality PostGIS 2.0 ! | / 2.0 |http://strk.keybit.net - http://vizzuality.com `-o--' ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Ubuntu and Postgresql9.1.3-2
The instructions at http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204 should address all of these issues. Be sure to read the The bad news:about using the existing packages. The later section explains how to build PostGIS from source, so you shouldn't hit the bug in the current package. I'm not sure when 9.1.3-2 dropped, but if it hasn't been in the last 2-3 weeks, then, yes the instructions at that link work with Ubuntu 12.04. From: Sandro Santilli s...@keybit.net To: PostGIS Users Discussion postgis-users@postgis.refractions.net Sent: Thursday, May 24, 2012 7:37 AM Subject: Re: [postgis-users] Ubuntu and Postgresql9.1.3-2 On Thu, May 24, 2012 at 07:27:38AM -0700, Brian H Wilson wrote: On 05/24/2012 05:13 AM, José María Amuedo wrote: I understand all steps I have to following to get the installation, but: Do we know if someone installed PostGIS 2 with PostgreSQL 9.1.3-2 in Ubuntu 12_04 LTS Thanks It happens my new desktop has a recent Ubuntu 12.04 install (AWESOME new computer! :-), and I don't usually run PostGIS on it (I keep it on a server in the other room) so I removed the postgres client previously installed on the desktop like this sudo apt-get -f remove postgresql-client postgresql-client-common Next I tried these instructions on the computer I am sitting at, from the first link I sent yesterday sudo apt-get install python-software-properties sudo apt-add-repository ppa:sharpie/for-science sudo apt-get update sudo apt-get install postgresql-9.1-postgis Now I have psql --version psql (PostgreSQL) 9.1.3 contains support for command-line editing I also have two versions of GDAL installed now, for what it's worth, postgres@laysan:~$ /usr/bin/gdalinfo --version GDAL 1.7.3, released 2010/11/10 postgres@laysan:~$ /usr/local/bin/gdalinfo --version GDAL 2.0dev, released 2011/12/29 I have found having different versions of things can be a problem, hence I usually just install things from sources to get all the features and most up tp date gdal possible. But for now I press on... In the past I have always used the procedure outlined on my wiki to add PostGIS to PostgreSQL. Therefore creating a geodatabase meant using a template. Today I try the command you suggested. This is where I have a problem -- using EXTENSION postgres@laysan:~$ createdb test postgres@laysan:~$ psql test psql (9.1.3) Type help for help. test=# CREATE EXTENSION postgis; ERROR: function st_asgml(integer, geography, integer, integer, text, text) does not exist test=# Seems like I got further than you José but still encountered a problem. It's a recent bug. Someone packaged a broken revision of PostGIS. Current trunk is fine, if you mail the package maintainer he'll know what to do. --strk; ,--o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o--' ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Error browsing database
Hi all. A simple CREATE TABLE dtm AS SELECT ST_Transform(rast,4326, 'Bilinear') AS rast FROM hdr; results in gdalinfo PG:host=localhost dbname=postgis2 user=corso table=dtm mode=2 password=*** ERROR 1: Error browsing database for PostGIS Raster properties Similar tables are read without issues. Any hint? All the best. -- Paolo Cavallini See: http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] rt_resample test fails on PostGIS 2.0, Debian 6 amd64
Strange. GDAL 1.6 should work. Have you tried upgrading your GDAL to 1.9? 1.9 is highly recommended due to features only available in 1.9. -bborie On 05/24/2012 08:51 AM, Antonis Christofides wrote: On 2012-05-24 18:19, Bborie Park wrote: Antonis, What verson of GDAL are you running? The Debian-packaged one, 1.6.3. PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit Postgis 2.0.1SVN - r9815 - 2012-05-24 11:47:54 GEOS: 3.3.3-CAPI-1.7.4 PROJ: Rel. 4.7.1, 23 September 2009 GDAL: GDAL 1.6.3, released 2009/11/19 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error browsing database
Which version of GDAL are you using? I'm assuming the CREATE TABLE statement runs successfully? -bborie On 05/24/2012 09:32 AM, Paolo Cavallini wrote: Hi all. A simple CREATE TABLE dtm AS SELECT ST_Transform(rast,4326, 'Bilinear') AS rast FROM hdr; results in gdalinfo PG:host=localhost dbname=postgis2 user=corso table=dtm mode=2 password=*** ERROR 1: Error browsing database for PostGIS Raster properties Similar tables are read without issues. Any hint? All the best. -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error browsing database
Il 24/05/2012 19:21, Bborie Park ha scritto: Which version of GDAL are you using? 1.9.0-2 on Debian I'm assuming the CREATE TABLE statement runs successfully? yes. thanks. -- Paolo Cavallini See: http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error browsing database
On 05/24/2012 10:26 AM, Paolo Cavallini wrote: Il 24/05/2012 19:21, Bborie Park ha scritto: Which version of GDAL are you using? 1.9.0-2 on Debian I'm assuming the CREATE TABLE statement runs successfully? yes. thanks. I just tested that gdalinfo (from gdal-trunk) on one of my rasters and it doesn't have any issues. Could there be privilege issues with corso not having access? -bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error browsing database
Double checking your query, the table created doesn't have an rid column and the raster column must be called rast. These are limitations of the GDAL PostGIS Raster driver... -bborie On 05/24/2012 11:14 AM, Paolo Cavallini wrote: Il 24/05/2012 20:07, Bborie Park ha scritto: I just tested that gdalinfo (from gdal-trunk) on one of my rasters and it doesn't have any issues. Could there be privilege issues with corso not having access? I'm also fine with most of my rasters - just an issue with the ones produced with ST_Transform and ST_Resample. Permissions are ok. Thanks. -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error browsing database
Il 24/05/2012 20:28, Bborie Park ha scritto: Double checking your query, the table created doesn't have an rid column and the raster column must be called rast. These are limitations of the GDAL PostGIS Raster driver... OK, so now: CREATE TABLE dtm_wgs84c AS SELECT rid, ST_Transform(rast,4326, 'Bilinear') AS rast FROM hdr; results in: ERROR 1: Error, the table public.dtm_wgs84c contains tiles with different size, and irregular blocking is not supported yet I suppose the transformation stretches the geometries. All the best. -- Paolo Cavallini See: http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error browsing database
On 05/24/2012 01:08 PM, Paolo Cavallini wrote: Il 24/05/2012 20:28, Bborie Park ha scritto: Double checking your query, the table created doesn't have an rid column and the raster column must be called rast. These are limitations of the GDAL PostGIS Raster driver... OK, so now: CREATE TABLE dtm_wgs84c AS SELECT rid, ST_Transform(rast,4326, 'Bilinear') AS rast FROM hdr; results in: ERROR 1: Error, the table public.dtm_wgs84c contains tiles with different size, and irregular blocking is not supported yet I suppose the transformation stretches the geometries. All the best. Correct. That and when each tile is transformed, the output isn't aligned with the rest of the transformed tiles. There has been discussion about adding a reference raster to ensure the transformed tiles are aligned. -bborie -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] rt_resample test fails on PostGIS 2.0, Debian 6 amd64
On 2012-05-24 19:34, Bborie Park wrote: Strange. GDAL 1.6 should work. Have you tried upgrading your GDAL to 1.9? 1.9 is highly recommended due to features only available in 1.9. I tried 1.9.1 and the error went away, thanks. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Difference between ST_Union and ST_Collect
Folks, after seeing some polygons disappear during the generalization process, I found out that ST_Union and ST_Collect are different beasts when dealing with intersecting lines. I did generalization by: breaking original polygons into lines, generalizing them and them assembling back lines into (multi) polygons. At first I used ST_Collect for the last step: ST_Multi(ST_BuildArea(ST_Collect(r2.wkb_geometry))) ...but some of the lines intersected, especially over intricate coastlines, causing big polygons to be silently dropped. But when I switched to ST_union: ST_Multi(ST_BuildArea(ST_Union(r2.wkb_geometry))) all polygons where built (except for the ones that had to be dropped because their area was 0, usually islets). Is this by design (I wasn't able to find documentation on the different behaviour of these two functions) ? Regards, P.S. Sandro, I did not forget to help speeding up the topology construction routines, it is just that next week we have a deadline, hence I gave a lower priority to the task of setting up a machine with the configuration you requested... stay tuned. Luca Morandini Data Architect - AURIN project Department of Computing and Information Systems University of Melbourne ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users