Re: [Qgis-user] QGIS Webclient PostgreSQL search table
On Mon, Jun 25, 2012 at 01:11:56PM +0200, Dennis Ströer wrote:
ERROR: function to_tsvector() does not exist
I'm using PostgreSQL 8.4, so I think the tsearch package is already
included?! And when I add a new column to a table I can select the
data type tsvector...
If I can remember well, I installed QGIS Webclient on Debian
Squeeze, postgresql-8.4.
I used statements like this to populate the searchtable (notice:
no to_tsvector() function):
INSERT INTO searchtable
(searchstring, displaytext, search_category, the_geom, geometry_type)
VALUES (
'colonne leopoldine, colonna del grillo, siena',
'Colonna del Grillo (Siena)',
'01_poi',
ST_GeometryFromText('POINT(11.552823242 43.330441145)', 4326),
'ST_Point');
--
Niccolo Rigacci - http://www.rigacci.net/
Firenze - Italy
Tel. ufficio: 055-9331021
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: [Qgis-developer] Critical problems with 1.7.2 from ubuntu binaries
On Tue, Nov 29, 2011 at 07:12:24AM +0100, Agustin Lobo wrote: After updating to 1.7.2 in ubuntu 10.4 LTS using the ubuntugis-unstable repo, the CRS cannot be set: Could not open CRS database /resources/srs.dbbrError(14): unable to open database file! I got a similar problem with a self-make Debian package: it was a package not correctly updated (strange enough it was qgis-plugin-grass, if I remember well). I removed the stale old package and reinstalled the new one to fix. Check what you have with: dpkg --list | grep qgis -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Debian Wheezy packages for QGIS 1.7.1
On Sat, Oct 22, 2011 at 10:43:41AM -0400, Jerry Bond wrote: I tried to install QGIS 1.7 on Squeeze (MEPIS 11), but Synaptic refused, and when I downloaded it from your repo to install with gdebi a dependency problem was revealed: libgeos-c1 3.2.2 May be you downloaded the wrong version, or you pointed to the wrong dist suite in the repository. QGIS 1.7.1 for Wheezy depends upon libgeos-c1 (= 3.2.2) which is in Wheezy, QGIS 1.7 for Squeeze depends upon libgeos-c1 (= 3.2.0), which is in Squeeze. Look at: http://debian.gfoss.it/dists/wheezy/main/binary-i386/Packages http://debian.gfoss.it/dists/squeeze/main/binary-i386/Packages -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Debian Wheezy packages for QGIS 1.7.1
Hi to all, there are QGIS 1.7.1 packages for Debian Wheezy (testing), i386 and amd64 architectures. The repository is apt-gettable: deb http://debian.gfoss.it/ wheezy main On the same repository packages for Debian Squeeze are just for QGIS 1.7, I'm sorry for that. Thanks to developers which mantains the Debian files and all the other required packages. -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] qgis-web-client: Problem with web client and server on different hosts
Hi, I tried to install a QGIS Web Client onto a web server (say http://www.domain.org/). The QGIS Server is onto another server (say http://gis.domain.org/cgi-bin/...). I was unable to make the webapp to work. In other words, the serverAndCGI parameter must point to the same host serving the web pages. Is there some known limitation which prevents that? Thank you. -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] GRASS plugin on Debian Lenny
On Tue, Jul 05, 2011 at 04:25:14PM +0300, Micha Silver wrote: I've upgraded a Debian Lenny machine to qgis 1.7 and the GRASS plugin is not available in the Plugin Manager. I'm using the debian.gfoss.it repository. GRASS itself works fine. And the plugin was there on 1.6.br I think you have mixed non-compatible repositories. debian.gfoss.it has QGIS 1.7 only for Debian Squeeze, not for Lenny. If you are running Lenny, please remove any GFOSS package and install only from http://qgis.org/debian. May be you will get an older version of GRASS in this way. Consider to upgrade to Squeeze, which is now the Stable Debian. -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Debian Squeeze packages for QGIS 1.7.0, with GDAL and GRASS backports
Hi to all, I made some Debian packages for QGIS 1.7.0, the target is Debian Squeeze (stable), architectures are i386 and amd64: http://debian.gfoss.it/ The official download site [1] is already providing QGIS packages for Debian Lenny (oldstable) and Squeeze (stable). The GFOSS.it repository has only Squeeze, but it also provides backports for the following packages (end their dependencies): * gdal 1.7.3 * grass 6.4.1 [1] http://www.qgis.org/wiki/Download#Debian -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Google map in QGIS
On Sat, May 21, 2011 at 08:58:25PM +0300, ahmet temiz wrote: hello I was wondering if you could give me an information about how I could get google map in qgis using EPSG:4326. There is an utility called twms (tiny web map service) which connects to tile services like Gmaps and serves them as a WMS, allowing on-the-fly reprojection. However I think that this use breaks the Google terms of use. -- Niccolo Rigacci Firenze - Italy Tel. ufficio: 055-0118525 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS 1.6.0 packages for Debian Lenny and Squeeze
Hello, I just uploaded new unofficial packages for QGIS 1.6.0 compiled on Debian Lenny (stable) and Debian Squeeze (freezed testing), architectures i386 and amd64. The apt-gettable repository is at: http://debian.gfoss.it/ The apt key is also changed, read instructions at http://debian.gfoss.it/README Please, can someone update the page at http://www.qgis.org/wiki/Download#Debian changing the Qgis version and adding the squeeze suite? -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS 1.5 packages available for Debian Squeeze
Finally I packaged QGIS 1.5 for Debian Squeeze too, architectures are i386 and amd64. The **unofficial** apt-gettable repository is: deb http://debian.gfoss.it/ lenny main Please report any problem with the packaging to me, not to the innocent official Debian mantainers. Due Squeeze frozen status, the packages should remain installable for a long time. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS 1.5 packages available for Debian Squeeze
On Sat, Aug 07, 2010 at 04:45:41PM +0200, Niccolo Rigacci wrote: deb http://debian.gfoss.it/ lenny main Errata corrige!!! The repository is squeeze, not lenny: deb http://debian.gfoss.it/ squeeze main A tip: Please remove all the Qgis and Grass you have installed from the Gfoss repository, before doing the update. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Installing QGIS 1.5 on Debian Squeeze
On Fri, Aug 06, 2010 at 09:21:21AM +0200, Guy Roussin wrote: dpkg-buildpackage -rfakeroot -b I fear that a plain build will fail in squeeze. On my box I had to: cp debian/control.sid debian/control.squeeze cp debian/compat.sid debian/compat.squeeze By the way, my building is proceeding, despite I just had a crash due low memory... Be patient. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Installing QGIS 1.5 on Debian Squeeze
On Wed, Aug 04, 2010 at 08:35:04PM +0200, Gary Smith wrote: Immediately after sending the previous mail I realised that the installed version was not Tethys. It seems that the Lenny Squeeze repositories on http://debian.gfoss.it/ are not synchronised. Yes, Squeeze on debian.gfoss.it did not get QGIS 1.5 jet. I'm upgrading the Squeeze build box, I hope to finish in a day or two. Unfortunately Lenny packages cannot work into a Squeeze box. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Installing QGIS 1.5 on Debian Lenny
On Tue, Aug 03, 2010 at 07:25:01PM +0200, Gary Smith wrote: Nicollo, I get a segmentation fault. This occurs immediately the Starting Python message is displayed on the Splash screen. Also, there also appears to be a dependency problem with the grass plugin. Check all the old packages/libraries you have installed and remove them manually: dpk --list | grep qgis dpkg --purge package_name package_name ... Then re-do the apt-get install. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS version 1.5 packaged for Debian Lenny
On Sun, Aug 01, 2010 at 06:43:47PM +0200, Gary Smith wrote: It doesn't look like the Debian repository listed in the download page has 1.5 available. Anywhere else I can get it? Today I uploaded QGIS 1.5 packaged for Debian Lenny (i386 and amd64 architectures) to the **unofficial** repository: deb http://debian.gfoss.it/ lenny main Please report any problem with the packaging to me, not to the innocent official Debian mantainers. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Postgis speed with QGIS
On Wed, Jun 09, 2010 at 04:55:39PM -0600, John Abraham wrote: Any suggestions on PostgreSQL configuration? Anything else I should try? If I remember well default connection is with SSL encryption on, have you tried to disable it? -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] qgis 1.5 lenny
On Mon, May 10, 2010 at 09:11:45PM +0200, tla...@gwdg.de wrote: I just tried to install the Qgis64 packages from http://debian.gfoss.it/ on my Debian Lenny. By the way Qgis download page says it's version 1.4, but gfoss.it already hosts 1.5. On Gfoss.it you find a Qgis compiled from SVN source code (will be version 1.5) not the stable one (1.4). Notes about gfoss.it are a bit outdated here: http://qgis.org/en/download/current-software.html However, Synaptic package manager insists to remove my Debian Postgis 1.3.3-3 (packaged for PostgreSQL 8.3.9). This should not happen, at least this should not be caused by the Gfoss.it repository. What is the conflict with PostGIS 1.3.3-3? Q2: If I would create a Postgis template database, could I let it be removed by Synaptic without breaking my GIS-database? If you remove the postgis package, you loose just two binaries: pgsql2shp and shp2pgsql. The spatial database needs the postgresql-8.3-postgis package actually. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] qgis 1.5 lenny
On Tue, May 11, 2010 at 12:02:29AM +0200, tla...@gwdg.de wrote: Hmm, not sure. The only conflict I saw was package postgresql-8.3-postgis depends on libgeos-c1(=3.0.0) and qgis depends on libgeos-c1(=3.2.0). I upgraded libgeos-c1 from 3.0.0 to 3.2.0 but Synaptic still wants to remove Postgis. It is very strange, because postgis has very few dependency requests, not involving geos or other packages available on gfoss.it: http://packages.debian.org/lenny/postgis So I suspect that synaptic is somewhat confused. I use dselect or aptitude which are more hard to use than synaptic, but they are more powerful on managing conflicts. You can try to remove postgis an reinstall it afterwards. The postgis package does not affect your existing geo-databases. Removing postgresql-8.3-postgis instead, will leave yuor geo-database unusable (may be not corrupted, but I don't assure that). -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: GDAL Tools and QGIS 1.5 segmentation fault
On Sun, Apr 18, 2010 at 09:53:14PM +0200, Gary Smith wrote: All, A false fix. I apologise for the error. The fix that I stated below is not valid. The seg fault occurs when no raster is loaded and one tries to invoke any of the tools. Ok, so the problem is reproducible. Is there a ticket already opened? https://trac.osgeo.org/qgis/report -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS svn packaged for Debian Stable and Debian Testing (Lenny and Squeeze)
For whom interested in the latest QGIS build, I packaged an SVN snapshot for Debian Lenny and Debian Squeeze, i386 and amd64 architectures. This is particuraly interesting for Lenny, where several packages were backported: * proj 4.7.0 * geos 3.2.0 * gdal 1.6.3 * grass 6.4.0~rc6 * libgdal-grass 1.6.3 * qgis 1.5.0~svn20100406 * mapserver 5.6.3 For Squeeze, only QGIS was packaged, because all the other packages are already in there, thanks to the Debian Mantainers! The repository is apt-gettable here: http://debian.gfoss.it/ Please note that the repository was completely rebuild, so if you notice some problem report it to me. Thanks -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Errors in Italian new spatial ref sys?
Hello yesterday I downloaded the srs.db from Qgis SVN, I was looking for the new Italian srs added some days ago. It seems to me that there are errors into the proj parameters: *) For Italy Sardinia the towgs84 is repeated twice. *) Somewhere there are spaces after the decimal dot and after the minus sign *) For Sicily I have a different towgs84 formula, which is: +towgs84=-50.2,-50.4,84.8,-0.690,-2.012,0.459,-28.08 Please can someone confirm that before I open a ticket? Here it is what I read from the srs.db: SELECT srs_id, description, parameters, epsg FROM tbl_srs WHERE srs_id = 3640 AND srs_id = 3643; 3640|Italy mainland zone 1 GB Roma40|+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=150 +y_0=0 +ellps=intl +units=m +towgs84=-104.1,-49. 1,-9.9,0.971,-2.917,0.714,-11.68 +no_defs|4 3641|Italy mainland zone 2 GB Roma40|+proj=tmerc +lat_0=0 +lon_0=15 +k=0.9996 +x_0=252 +y_0=0 +ellps=intl +units=m +towgs84=-104. 1,- 49.1,-9.9,0.971,-2.917,0.714,-11.68 +no_def|40001 3642|Italy Sardinia GB Roma40|+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=150 +y_0=0 +ellps=intl +units=m +towgs84=-104.1,-49.1,- 9.9 ,0.971,-2.917,0.714,-11.68 +towgs84=-168.6,-34.0,38.6,-0.374,-0.679,-1.379,-9.48 +no_defs|40002 3643|Italy Sicily GB Roma40|+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=150 +y_0=0 +ellps=intl +units=m +towgs84=-168.6,-34.0,38.6,-0 .374,-0.679,-1.379,-9.48 +no_defs|40003 -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] gpx files with wron scale in projects
On Sat, Oct 24, 2009 at 12:30:46AM -0200, Mario Alberto Cozzuol wrote: Is the gps data in lat/long perhaps? Yes, the data were in lat/long, but I converted it to UTM after the first attempt failed As far I know, GPX files must be in lat/lon WGS84, otherwise they don't comply with GPX DDT. I opened a bug against GPX file distributed with QGIS: https://trac.osgeo.org/qgis/ticket/1956 -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] RE: [Qgis-developer] New snapshot of OpenStreetMap plugin
On Tue, Jun 09, 2009 at 12:25:42PM +0200, Standaert Arnout wrote: Is there a 1.1 unstable build somewhere that does have it? If you use Debian Lenny i386 or amd64, you can use the repository debian.gfoss.it, there is a QGIS 1.1 compiled with OSM provider. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS 1.1 for Debian Lenny i386 and amd64
I'm pleased to announce a new build for QGIS 1.1 on Debian Lenny. This involved the backport of some packages from Debian Squeeze (Testing). QGIS 1.1 includes the new spatialite provider. I also included the new experimental OpenStreetMap provider, announced by Martin Dobias some days ago [1]. The apt-gettable repository is http://debian.gfoss.it/ Packages version: * proj 4.6.1 * geos 3.1.0 * gdal 1.5.4 * grass 6.4.0~rc4 * libgdal-grass 1.5.4 * spatialite 2.3.0 * qgis 1.1.0 [1] http://lists.osgeo.org/pipermail/qgis-user/2009-June/005514.html -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Preview of QGIS + Spatialite for Debian Lenny
On Mon, Mar 30, 2009 at 05:58:51PM +0200, Paolo Cavallini wrote: Guy Roussin ha scritto: Thank you Niccolo. Fine for me ... Perhaps you have a script to compile all this stuff with debian lenny ? This script will be very usefull to me, because i need to add libecw support to qgis/gdal ... You can rebuild it the debian way using the src packages (also available from the same site). I did not wet uploaded srouces for qgis, wait a few minutes to complete (look into http://debian.gfoss.it/qgis_spatialite/src/). By the way I don't know if you need to change some Debian rules to compile Qgis with ecw. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Preview of QGIS + Spatialite for Debian Lenny
Hi, thanks to the work of QGIS developers, Alessandro Furieri (mr. spatialite) and Francesco P. Lovergine (Debian mantainer), I built a preview of QGIS svn with Spatialite provider for Debian Lenny i386. The archive is NOT apt-gettable, just download the packages and install them with dpkg -i. Read the README. http://debian.gfoss.it/qgis_spatialite/ -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Ideas for QGIS plugin?
On Fri, Jan 30, 2009 at 10:12:39PM +0100, G. Allegri wrote: This is forbidden by the Google user licence. Are you sure? Why should it be forbidden? From The Google Maps/Google Earth APIs Terms of Service http://code.google.com/apis/maps/terms.html Read specially 10.8: ... you must not (nor may you permit anyone else to): ... 10.1 access or use the Service or any Content through any technology or means other than those provided in the Service, or through other explicitly authorized means Google may designate; ... 10.3 pre-fetch, cache, or store any Content, except that you may store limited amounts of Content for the purpose of improving the performance of your Maps API Implementation if you do so temporarily, securely, and in a manner that does not permit use of the Content outside of the Service; ... 10.8 use the Static Maps API other than in an implementation in a web browser; -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS 0.10.0 packaged for Debian Lenny
A bit late, but I made unofficial Debian Testing (Lenny) packages for Grass 6.3 and QGIS 0.10.0. Arch is i386. Source code from: - https://svn.osgeo.org/grass/grass/branches/releasebranch_6_3 - https://svn.osgeo.org/qgis/branches/Release-0.10.0 apt-gettable repository is: deb http://debian.gfoss.it/ lenny main Please, can someone update this page? http://wiki.qgis.org/qgiswiki/ReleaseChecklist0.10.0 Thanks and happy (free) mapping. -- Niccolo Rigacci Firenze - Italy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
