Re: [Qgis-user] Why polygons created with Avoid intersections over lap their neighbors in Postgis?
Dear Paolo, I just notice this behavior a few days ago. Right now I can reproduce this problem: Using Qgis to draw polygons on a clean Postgis layer with Avoid Intersections turned on and check every time I create a new polygon, this is the number of polygons until an over-lap is detected: 4, 7, 6, 15, 7 My postgis layer creation sql: CREATE TABLE polygon_layer ( id serial primary key, geom geometry(MultiPolygon,3857), ); CREATE INDEX polygon_layer_idx ON polygon_layer USING gist (geom); Over lap detecting sql: select a.id, b.id from polygon_layer as a inner join polygon_layer as b on st_overlaps(a.geom, b.geom) where a.id b.id; My system versions: Client: Qgis 1.8 on Debian 7 64 bit Server: Postgis 2.0 on PosgreSQL 9.2, Ubuntu 12.04 64 bit Thanks. 2013/6/26 Paolo Cavallini cavall...@faunalia.it Il 26/06/2013 05:04, Cao Minh Tu ha scritto: My question is: Is there an easier way to make Qgis Avoid intersections plays well with Postgis st_overlaps so I can avoid the other dreaded way? Dear Cao, I did not notice this problem for PostGIS layers. Could you please be more specific (which version of qgis? when exactly do you encounter this issue?). If confirmed, better solve it upstream, in qgis code, than fix it with ad hoc solutions (pg triggers). All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Why polygons created with Avoid intersections over lap their neighbors in Postgis?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 26/06/2013 09:16, Cao Minh Tu ha scritto: My system versions: Client: Qgis 1.8 on Debian 7 64 bit Server: Postgis 2.0 on PosgreSQL 9.2, Ubuntu 12.04 64 bit Could you please check if you have the same problem with the development version of QGIS? Thanks. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlHKlo8ACgkQ/NedwLUzIr4zPQCeImy1cbcegP53SQNgHsd+zLUz 9j4AoJfoFnLRZwBMjvGHeDITgJC2yGo5 =oxru -END PGP SIGNATURE- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS and Oracle native connection
Hi everybody, I’ve installed Qgis-dev yesterday in order to test Oracle connection. I work in a french local government. 95% of our data are stored into Oracle. So this new connection looks very interesting for us. The main things is definitively slowness at scanning DB. We have more than 20 schema and users can’t wait that Qgis scans all schemas until they can load their data. I know you can stop scan BUT if unfortunatly you are interest in the last one schema, you have to wait… Is it possible to only list all schema in the UI and only scan data on demand when user select a schema ? Sylvain → Sylvain PIERRE Ingénieur Géographe Adjoint au chef du service Direction de l’Agriculture, de l’Espace Rural et de l’Environnement Service Administration Générale Conseil Général du Bas-Rhin [cid:image003.jpg@01CE7250.EFEE8720]http://www.bas-rhin.fr/ Passerelle 67 20 rue Livio / 67000 Strasbourg Tél : +33 3 88 76 68 88 – mobile : Fax : 03 88 76 68 71 Email : sylvain.pie...@cg67.frmailto:sylvain.pie...@cg67.fr De : qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] De la part de Jonathan Moules Envoyé : mardi 14 mai 2013 18:05 À : Jürgen E.; qgis-user@lists.osgeo.org Objet : Re: [Qgis-user] QGIS and Oracle native connection Hi Jürgen, I've updated to the newest nightly build (1.9.0-19 - yesterday) and note it has a couple of fixes. Its also faster, in part because its not listing the recycling tables now. We have 551 rows in our all_sdo_geom_metadata table - seems we've had a clean-up. Can you work out which queries take particularly long (I added some progress messages recently)? I'm now using only look in meta data table, use estimated table metadata and only existing geometry types as my defaults. In the bottom left there's something that says Scanning column ... and then shows the column. The speed this cycles through tables seems to vary - it goes blur-fast if I've just done it a minute ago (despite restarting QGIS), so I guess in those cases Oracle caches - it only takes 5 seconds. But if I do it for the first time, some of them take a significant time, though it doesn't seem to be entirely related to their size (the vast majority of the tables are only in the thousands of rows or smaller - the millions are the exception (probably 5)). You can stop the detection and then pick what's already there. I completely missed the fact that connect turns into stop. Even took me a minute after reading your email to find it. Do you have numeric primary keys? Otherwise QGIS must build a map that assigns numeric keys to the primary keys (or ROWID if there isn't any primary key) on the client side. Yes and no. Each table has a column with a unique number that is set by ArcSDE to be unique and not-nullable, but its not set as a primary key in Oracle. MapInfo and ArcSDE use this column as their index (MapInfo because its called MI_PRINX, and ArcSDE because we tell it to when we register the table). I don't know how normal this setup is, but the only other thing that's ever hinted at wanting an explicit primary key is GeoServer, and then only as a WARN event in the logs. A thought - if it can't find a primary key, how about testing to see if there's a column called MI_PRINX? Anywhere with MapInfo will have it. http://testdrive.mapinfo.com/TECHSUPP/MIPROD.NSF/5c41496d5951a49c852562b5004f3a44/fcb3edc86ce9460b80256ae7004ee597 Jonathan On 14 May 2013 10:31, Jürgen E. j...@norbit.demailto:j...@norbit.de wrote: Hi Jonathan, On Mon, 13. May 2013 at 13:06:49 +0100, Jonathan Moules wrote: The first and most obvious thing is that it's incredibly slow to list the tables. I don't know how many tables were used in the test setup, but we have over a thousand spatial tables ranging from one row to 20 million on an Oracle Locator 10g setup that has about 50 concurrent users. In the best case scenario (Only look in meta data table and Use estimated table metadata both checked), it still takes a full two minutes to list all of the tables. If I don't have those checkboxes checked it takes much longer (scanning the table that has ~20million features alone takes about a minute!). Can you work out which queries take particularly long (I added some progress messages recently)? Does QGIS need to do all of the checks it does when actually listing the tables? Well, QGIS needs to know which geometry types are present. And that might take long to determine. It might be possible to do that lazy - ie. on demand (introduce another level to the tree where the types in the geometry column are. Its also impossible to add a table while the list is being generated so the user has to wait until its finished before being able to continue. You can stop the detection and then pick what's already there. Panning. Again, fine with smaller datasets, but the larger ones cause issues. Do you
Re: [Qgis-user] Why polygons created with Avoid intersections over lap their neighbors in Postgis?
I'll try and report back. 2013/6/26 Paolo Cavallini cavall...@faunalia.it -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 26/06/2013 09:16, Cao Minh Tu ha scritto: My system versions: Client: Qgis 1.8 on Debian 7 64 bit Server: Postgis 2.0 on PosgreSQL 9.2, Ubuntu 12.04 64 bit Could you please check if you have the same problem with the development version of QGIS? Thanks. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlHKlo8ACgkQ/NedwLUzIr4zPQCeImy1cbcegP53SQNgHsd+zLUz 9j4AoJfoFnLRZwBMjvGHeDITgJC2yGo5 =oxru -END PGP SIGNATURE- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS and Oracle native connection
Hi, I think this would be a very useful addition also for other database providers (Postgis, SQL server, etc.) The problem is that we are in feature freeze now. Only bugfixes allowed at this time. New features (like this two-step scanning will have to wait for QGIS 2.0x or 2.1. Andreas On Wed, 26 Jun 2013 09:38:38 +0200, PIERRE Sylvain wrote: Hi everybody, I’ve installed Qgis-dev yesterday in order to test Oracle connection. I work in a french local government. 95% of our data are stored into Oracle. So this new connection looks very interesting for us. The main things is definitively slowness at scanning DB. We have more than 20 schema and users can’t wait that Qgis scans all schemas until they can load their data. I know you can stop scan BUT if unfortunatly you are interest in the last one schema, you have to wait… Is it possible to only list all schema in the UI and only scan data on demand when user select a schema ? Sylvain → SYLVAIN PIERRE Ingénieur Géographe Adjoint au chef du service Direction de l’Agriculture, de l’Espace Rural et de l’Environnement Service Administration Générale CONSEIL GÉNÉRAL DU BAS-RHIN [1] Passerelle 67 20 rue Livio / 67000 Strasbourg Tél : +33 3 88 76 68 88 – mobile : Fax : 03 88 76 68 71 Email : sylvain.pie...@cg67.fr [2] DE : qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] DE LA PART DE Jonathan Moules ENVOYÉ : mardi 14 mai 2013 18:05 À : Jürgen E.; qgis-user@lists.osgeo.org OBJET : Re: [Qgis-user] QGIS and Oracle native connection Hi Jürgen, I've updated to the newest nightly build (1.9.0-19 - yesterday) and note it has a couple of fixes. Its also faster, in part because its not listing the recycling tables now. We have 551 rows in our all_sdo_geom_metadata table - seems we've had a clean-up. Can you work out which queries take particularly long (I added some progress messages recently)? I'm now using only look in meta data table, use estimated table metadata and only existing geometry types as my defaults. In the bottom left there's something that says Scanning column ... and then shows the column. The speed this cycles through tables seems to vary - it goes blur-fast if I've just done it a minute ago (despite restarting QGIS), so I guess in those cases Oracle caches - it only takes 5 seconds. But if I do it for the first time, some of them take a significant time, though it doesn't seem to be entirely related to their size (the vast majority of the tables are only in the thousands of rows or smaller - the millions are the exception (probably 5)). You can stop the detection and then pick what's already there. I completely missed the fact that connect turns into stop. Even took me a minute after reading your email to find it. Do you have re isn't any primary key) on the client side. Yes and no. Each table has a column with a unique number that is set be unique and not-nullable, but its not set as a primary key in Oracle. MapInfo and ArcSDE use this column as their index (MapInfo because its called MI_PRINX, and ArcSDE because we tell it to when we register the table). I don't know how normal this setup is, but the only other thing that's ever hinted at wanting an explicit primary key is GeoServer, and then only as a WARN event in the logs. A thought - if it can't find a primary key, how about testing to see if there's a column called MI_PRINX? Anywhere with MapInfo will have it. http://testdrive.mapinfo.com/TECHSUPP/MIPROD.NSF/5c41496d5951a49c852562b5004f3a44/fcb3edc86ce9460b80256ae7004ee597 [3] Jonathan On 14 May 2013 10:31, Jürgen E. wrote: Hi Jonathan, On Mon, 13. May 2013 at 13:06:49 +0100, Jonathan Moules wrote: The first and most obvious thing is that it's incredibly slow to list the tables. I don't know how many tables were used in the test setup, but we have over a thousand spatial tables ranging from one row to 20 million on an Oracle Locator 10g setup that has about 50 concurrent users. In the best case scenario (Only look in meta data table and Use estimated table metadata both checked), it still takes a full two minutes to list all of the tables. If I don't have those checkboxes checked it takes much longer (scanning the table that has ~20million features alone takes about a minute!). Can you work out which queries take particularly long (I added some progress messages recently)? Does QGIS need to do all of the checks it does when actually listing the tables? Well, QGIS needs to know which geometry types are present. And that might take long to determine. It might be possible to do that lazy - ie. on demand (introduce another level to the tree where the types in the geometry column are. Its also impossible to add a table while the list is being generated so the user has to wait until its finished before being able to continue. You can stop the
[Qgis-user] Georeferencer plugin report
Dear QGIS users, I'd like to know if is there a way of configuring the report generated by the georeferencer plugin. Because it produces only one pdf page, most of my ground control points (GCP) are omitted from the report. Notice that I'm using n = 168 GCP, which is a very large number of GCP required only to comply with my research objectives. I hope someone have an idea. Many thanks in advance. Alessandro Samuel-Rosa Postgraduate Course in Agronomy - Soil Science Federal Rural University of Rio de Janeiro Seropédica, Rio de Janeiro, Brazil soil-scientist.net___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Analysing cluster sampled data
Hullo QGIS family I have data about pregnant mothers, those that delivered, pregnancy outcomes and health facilities they went to and administrative boundaries of villages. This data was collected using 2-stage sampling like selecting a village from each subcounty and from villages 30 households were interviewed. I want to develop catchment areas of these health facilities, measure distances to these facilities and do hot-spot mapping of pregnancy outcomes to see where are abortions most, miscarriages and live births. Which methods and plugins can i use in QGIS? -- KAJJO DARIOUS Iganga/Mayuge Demographic Surveillance Site Equip - Improving Maternal and Newborn Health in Africa. School of Public Health- College of Health Sciences Makerere University P.O.BOX 111 Iganga Uganda Mob: +256774971952, 0700438568 kjjdar...@yahoo.co.uk, kjjdar...@gmail.com Visit: http://igangamayuge-hdss.mak.ac.ug/ https://sites.google.com/a/aag.org/mycoe-servir/the-team/uganda?pli=1 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Plugin DataDrivenInputMask updated to QGIS 2.0
Hi all, I have updated my plugin DataDrivenInputMask to run with current QGIS Master (sip and api changes). If you want to use the plugin in current master please download version 0.2.1 (0.2.0 available earlier today had some minor issues). Please report any issues with version 0.2.1 in the bug tracker. have fun Bernhard __ Information from ESET Mail Security, version of virus signature database 8492 (20130626) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Linear (Affine) transformationin Raster/Georeferencing
I have the impression that the Linear option in the Raster Georeferencing plugin is always calculating a 0 for the Rotation. Am I wrong? Could other people test? In such a case, I think there has to be some error in the code (if Linear refers to Affine). Agus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Fetch plugins missing
Hi list, I uninstalled qgis 1.9 to switch back to qgis 1.8, and 'fetch plugins' has gone missing from the extension menu. I use ubuntu 13.04. I did install python-qgis. I installed qgis from the ubuntu-unstable repository. Do you have an idea on what may be causing this problem? I tried uninstalling and reinstalling qgis, to no avail. I wonder if it's do with python, since the python console is present in the extension menu, but doesn't show when I click on it. Thanks a lot for your help, Julie. Le 26/06/2013 16:52, qgis-user-requ...@lists.osgeo.org a écrit : Send Qgis-user mailing list submissions to qgis-user@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/qgis-user or, via email, send a message with subject or body 'help' to qgis-user-requ...@lists.osgeo.org You can reach the person managing the list at qgis-user-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of Qgis-user digest... Today's Topics: 1. Re: Why polygons created with Avoid intersections over lap their neighbors in Postgis? (Cao Minh Tu) 2. Re: QGIS and Oracle native connection (Andreas Neumann) 3. Georeferencer plugin report (Alessandro Samuel Rosa) 4. Analysing cluster sampled data (kajjo Darious) 5. Plugin DataDrivenInputMask updated to QGIS 2.0 (Bernhard Str?bl) 6. Linear (Affine) transformationin Raster/Georeferencing (Agustin Lobo) -- Message: 1 Date: Wed, 26 Jun 2013 15:12:49 +0700 From: Cao Minh Tu caominht...@gmail.com To: cavall...@faunalia.it Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Why polygons created with Avoid intersections over lap their neighbors in Postgis? Message-ID: CAHTTaU0R2e=uL-D2Abw1TtNoaeMQxjsK2W=jegu2djjfakn...@mail.gmail.com Content-Type: text/plain; charset=utf-8 I'll try and report back. 2013/6/26 Paolo Cavallini cavall...@faunalia.it -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 26/06/2013 09:16, Cao Minh Tu ha scritto: My system versions: Client: Qgis 1.8 on Debian 7 64 bit Server: Postgis 2.0 on PosgreSQL 9.2, Ubuntu 12.04 64 bit Could you please check if you have the same problem with the development version of QGIS? Thanks. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlHKlo8ACgkQ/NedwLUzIr4zPQCeImy1cbcegP53SQNgHsd+zLUz 9j4AoJfoFnLRZwBMjvGHeDITgJC2yGo5 =oxru -END PGP SIGNATURE- -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20130626/5649a861/attachment-0001.html -- Message: 2 Date: Wed, 26 Jun 2013 13:23:01 +0200 From: Andreas Neumann a.neum...@carto.net To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS and Oracle native connection Message-ID: 37386edb81986ddde09c18c92f683...@carto.net Content-Type: text/plain; charset=UTF-8; format=flowed Hi, I think this would be a very useful addition also for other database providers (Postgis, SQL server, etc.) The problem is that we are in feature freeze now. Only bugfixes allowed at this time. New features (like this two-step scanning will have to wait for QGIS 2.0x or 2.1. Andreas On Wed, 26 Jun 2013 09:38:38 +0200, PIERRE Sylvain wrote: Hi everybody, I?ve installed Qgis-dev yesterday in order to test Oracle connection. I work in a french local government. 95% of our data? are stored into Oracle. So this new connection looks very interesting for us. The main things is definitively slowness at scanning DB. We have more than 20 schema and users can?t wait that Qgis scans all schemas until they can load their data. I know you can stop scan BUT if unfortunatly you are interest in the last one schema, you have to wait? Is it possible to only list all schema in the UI and only scan data on demand when user select a schema ? Sylvain ?? SYLVAIN PIERRE Ing?nieur G?ographe Adjoint au chef du service Direction de l?Agriculture, de l?Espace Rural et de l?Environnement Service Administration G?n?rale ?? CONSEIL G?N?RAL DU BAS-RHIN [1] Passerelle 67 20 rue Livio / 67000 Strasbourg T?l : +33 3 88 76 68 88 ? mobile : Fax : 03 88 76 68 71 Email : sylvain.pie...@cg67.fr [2] DE : qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] DE LA PART DE Jonathan Moules ENVOY? : mardi 14 mai 2013 18:05 ? : J?rgen E.; qgis-user@lists.osgeo.org OBJET : Re: [Qgis-user] QGIS and Oracle native connection Hi J?rgen, I've updated
Re: [Qgis-user] Fetch plugins missing
AFAIK the plugin installer is in python-qgis-common package rather than python-qgis. You should install both (if available in the repository). If it's installed and you still can't see it, it can be disabled in the plugin manager. Go to Plugins - Manage plugin and make sure the Plugin Installer plugin is enabled. B. Dnia środa, 26 czerwca 2013 o 18:01:18 Julie Pierson napisał(a): Hi list, I uninstalled qgis 1.9 to switch back to qgis 1.8, and 'fetch plugins' has gone missing from the extension menu. I use ubuntu 13.04. I did install python-qgis. I installed qgis from the ubuntu-unstable repository. Do you have an idea on what may be causing this problem? I tried uninstalling and reinstalling qgis, to no avail. I wonder if it's do with python, since the python console is present in the extension menu, but doesn't show when I click on it. Thanks a lot for your help, Julie. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user