[Qgis-user] opening multitable postgis view is slow
Hi all, When loading multi table views in QGis it always starts with determining the extent of the result set. With pg_stat_activity you can see the following query running for a long time: SELECT st_extent(geom) FROM bag.vw_bag_pand_functie Does anyone has ideas of how to speed up the loading this dataset in QGis. The view is as efficient as can be, it will normally returns something like 9 million rows for the whole of the Netherlands, but normally I zoom in to a region of interest and then there is no need of first establishing the extent of the whole data set. All suggestions are welcome Ronnie ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] opening multitable postgis view is slow
Hi Ronnie, do you have a spatial index on the geometry columns of the tables contained in the view? (just guessing) Bernhard Am 17.04.2013 10:26, schrieb Lassche, M.R.: Hi all, When loading multi table views in QGis it always starts with determining the extent of the result set. With pg_stat_activity you can see the following query running for a long time: SELECT st_extent(geom) FROM bag.vw_bag_pand_functie Does anyone has ideas of how to speed up the loading this dataset in QGis. The view is as efficient as can be, it will normally returns something like 9 million rows for the whole of the Netherlands, but normally I zoom in to a region of interest and then there is no need of first establishing the extent of the whole data set. All suggestions are welcome Ronnie __ Information from ESET Mail Security, version of virus signature database 8236 (20130417) __ 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
Re: [Qgis-user] opening multitable postgis view is slow
Bernard, Yes there are spatial indexes in place. The get extent is slow because building the result set for the whole table (9 million rows with point geometry) is slow. What I do now is a multi step approach 1 - alter the query in such a way that no rows are returned - simple by adding a where condition that is never true e.g where 1=2 2- opening the layer in QGis, gives me no results 4 - zoom in to the desired region 5 - alter the view so the query does return rows 6 - refresh the data layer. This does work, but is kind of a hassle. Ronnie -Oorspronkelijk bericht- Van: Bernhard Ströbl [mailto:bernhard.stro...@jena.de] Verzonden: woensdag 17 april 2013 10:29 Aan: qgis-user@lists.osgeo.org Onderwerp: Re: [Qgis-user] opening multitable postgis view is slow Hi Ronnie, do you have a spatial index on the geometry columns of the tables contained in the view? (just guessing) Bernhard Am 17.04.2013 10:26, schrieb Lassche, M.R.: Hi all, When loading multi table views in QGis it always starts with determining the extent of the result set. With pg_stat_activity you can see the following query running for a long time: SELECT st_extent(geom) FROM bag.vw_bag_pand_functie Does anyone has ideas of how to speed up the loading this dataset in QGis. The view is as efficient as can be, it will normally returns something like 9 million rows for the whole of the Netherlands, but normally I zoom in to a region of interest and then there is no need of first establishing the extent of the whole data set. All suggestions are welcome Ronnie __ Information from ESET Mail Security, version of virus signature database 8236 (20130417) __ 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
Re: [Qgis-user] opening multitable postgis view is slow
Just a hunch, Ronnie, would it hel to use PostGIS inheritance: creating master and child tables and using the ones you need for particular zoom levels? http://www.postgresql.org/docs/9.1/static/tutorial-inheritance.html Jan On 04/17/2013 10:41 AM, Lassche, M.R. wrote: Bernard, Yes there are spatial indexes in place. The get extent is slow because building the result set for the whole table (9 million rows with point geometry) is slow. What I do now is a multi step approach 1 - alter the query in such a way that no rows are returned - simple by adding a where condition that is never true e.g where 1=2 2- opening the layer in QGis, gives me no results 4 - zoom in to the desired region 5 - alter the view so the query does return rows 6 - refresh the data layer. This does work, but is kind of a hassle. Ronnie -Oorspronkelijk bericht- Van: Bernhard Ströbl [mailto:bernhard.stro...@jena.de] Verzonden: woensdag 17 april 2013 10:29 Aan: qgis-user@lists.osgeo.org Onderwerp: Re: [Qgis-user] opening multitable postgis view is slow Hi Ronnie, do you have a spatial index on the geometry columns of the tables contained in the view? (just guessing) Bernhard Am 17.04.2013 10:26, schrieb Lassche, M.R.: Hi all, When loading multi table views in QGis it always starts with determining the extent of the result set. With pg_stat_activity you can see the following query running for a long time: SELECT st_extent(geom) FROM bag.vw_bag_pand_functie Does anyone has ideas of how to speed up the loading this dataset in QGis. The view is as efficient as can be, it will normally returns something like 9 million rows for the whole of the Netherlands, but normally I zoom in to a region of interest and then there is no need of first establishing the extent of the whole data set. All suggestions are welcome Ronnie __ Information from ESET Mail Security, version of virus signature database 8236 (20130417) __ 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] opening multitable postgis view is slow
Hi, would be nice to have an option like try to use Estimated extent. http://postgis.net/docs/ST_Estimated_Extent.html Fred On Wed, Apr 17, 2013 at 9:26 AM, Lassche, M.R. m.r.lass...@vu.nl wrote: Hi all, When loading multi table views in QGis it always starts with determining the extent of the result set. With pg_stat_activity you can see the following query running for a long time: SELECT st_extent(geom) FROM bag.vw_bag_pand_functie Does anyone has ideas of how to speed up the loading this dataset in QGis. The view is as efficient as can be, it will normally returns something like 9 million rows for the whole of the Netherlands, but normally I zoom in to a region of interest and then there is no need of first establishing the extent of the whole data set. All suggestions are welcome Ronnie ___ 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] How define the other condition on a classification render
You should be. I tested myself and I believe you found a bug. You should be able to add a new class without any value, and all values outside the existing categories should be rendered with that symbology. Thats how it works in 1.8. I'm not being able to open qgis.org (probably is under maintenance), but if there is no issue ticket for this problem, we should create one. Alexandre Neto On Tue, Apr 16, 2013 at 10:15 PM, Andrea Peri aperi2...@gmail.com wrote: Hi, I'm using the qgis-dev version of qgis. Is possible to define the 'other values' condition in the categorized style ? Thx -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ 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] How define the other condition on a classification render
Hi, I have fill a ticket with a sample to show how a map of qgis 1.8.0 if lost on a qgis 1.9.0 after an import. http://hub.qgis.org/issues/7630 2013/4/17 Alexandre Neto senhor.n...@gmail.com You should be. I tested myself and I believe you found a bug. You should be able to add a new class without any value, and all values outside the existing categories should be rendered with that symbology. Thats how it works in 1.8. I'm not being able to open qgis.org (probably is under maintenance), but if there is no issue ticket for this problem, we should create one. Alexandre Neto On Tue, Apr 16, 2013 at 10:15 PM, Andrea Peri aperi2...@gmail.com wrote: Hi, I'm using the qgis-dev version of qgis. Is possible to define the 'other values' condition in the categorized style ? Thx -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [Qgis-developer] How define the other condition on a classification render
Wouldn't it make sense to translate the old style into a rule-based renderer? There it's easy to define a style for other. Best wishes, Anita On Wed, Apr 17, 2013 at 11:42 AM, Andrea Peri aperi2...@gmail.com wrote: Hi, I have fill a ticket with a sample to show how a map of qgis 1.8.0 if lost on a qgis 1.9.0 after an import. http://hub.qgis.org/issues/7630 2013/4/17 Alexandre Neto senhor.n...@gmail.com You should be. I tested myself and I believe you found a bug. You should be able to add a new class without any value, and all values outside the existing categories should be rendered with that symbology. Thats how it works in 1.8. I'm not being able to open qgis.org (probably is under maintenance), but if there is no issue ticket for this problem, we should create one. Alexandre Neto On Tue, Apr 16, 2013 at 10:15 PM, Andrea Peri aperi2...@gmail.comwrote: Hi, I'm using the qgis-dev version of qgis. Is possible to define the 'other values' condition in the categorized style ? Thx -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ Qgis-developer mailing list qgis-develo...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Problem with georeferencer
HiYesterday I was trying to georeference a jpg image. I invoked gereferencer, it loads but when I tried to load the image it asked me for the crs, I chose the crs and then the image did not display. I closed Qgis and run it again this time as and administrator and the image load it. I was able to georeference the image. I am using Qgis standallone 1.8-02 with Gdal 1.92 on Win7 64 and 16gb of RAM. The lisboa standallone version with gdal 1.91 did not present this problem. Doe anybody has experencied the same thing? Gerardo Jiménez Delgado Instituto de Investigaciones Antropológicas Universidad Nacional Autónoma de México Ciudad Universitaria s/n Coyoacan 04510 Mexico City Mexico 56 22 95 16 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] can't connect Qgis to PostGreSql
You can also uploade shape file data with pgAdmin plugin 'PostGIS shape filer and DBF loader'. Then you can test your connection settings by loading to QGIS (and not uploading data). -- View this message in context: http://osgeo-org.1560.x6.nabble.com/can-t-connect-Qgis-to-PostGreSql-tp5047585p5047644.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS Master, Wrong Plugin Path shown
Hello! Probably just a smal detail, but installing a plugin on QGIS master today on Win7, rev. 268c037 (OSGeo4W), I saw that the plugin installer shows at the bottom that the plugin will be installed to ~/.qgis/python/plugins Shouldn't that be ...qgis2... in the meantime? The plugin seems to be installed correctly, but maybe somebody will be confused... regards, Albin -- | Albin Blaschka, Mag.rer.nat. | Etrichstrasse 26, A-5020 Salzburg | * www.albinblaschka.info * www.thinkanimal.info * | - It's hard to live in the mountains, hard but not hopeless! ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] How to create a local (LAN) plugin repository
I'm developing a toolbar with several python tools for one of our projects. They are very data especific tools, and therefore not interesting to realease as plugins in the official repository. Yet, I would like that my working colleagues could install (and update) it using the Python plugin manager. Is it possible to create a local repository (on our local network)? how? Thanks, Alexandre Neto ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS Master, Wrong Plugin Path shown
Dnia środa, 17 kwietnia 2013 o 15:59:35 Albin Blaschka napisał(a): Hello! Probably just a smal detail, but installing a plugin on QGIS master today on Win7, rev. 268c037 (OSGeo4W), I saw that the plugin installer shows at the bottom that the plugin will be installed to ~/.qgis/python/plugins Shouldn't that be ...qgis2... in the meantime? The plugin seems to be installed correctly, but maybe somebody will be confused... The label is obsolete and will be removed in 2.0. Don't trust what it says, plugins are correctly in .qgis2 :) ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How to create a local (LAN) plugin repository
It's simple to set up a repo on your network. First create an XML file that describes your plugin(s) and the download location. Here is an example: ?xml version = '1.0' encoding = 'UTF-8'? ?xml-stylesheet type='text/xsl' href='/contributed.xsl' ? plugins pyqgis_plugin name='ScriptRunner' version='0.71' descriptionRun Python scripts /description version0.71/version qgis_minimum_version1.8/qgis_minimum_version homepage/homepage file_namescriptrunner.zip/file_name author_nameGary Sherman/author_name download_urlhttp://geoapt.com/qgis_plugins/scriptrunner.zip /download_url uploaded_bygsherman/uploaded_by create_date2013-03-16/create_date update_dateNone/update_date experimentalTrue/experimental /pyqgis_plugin /plugins Put this on your web server somewhere, then make sure you put the plugin package in the download_url location. Last step is to add your repo to the plugin installer, using the URL to your plugins.xml. Please consider contributing any plugins you create that may have broader interest to the the community. Thanks, -gary On Wed, Apr 17, 2013 at 6:30 AM, Alexandre Neto senhor.n...@gmail.comwrote: I'm developing a toolbar with several python tools for one of our projects. They are very data especific tools, and therefore not interesting to realease as plugins in the official repository. Yet, I would like that my working colleagues could install (and update) it using the Python plugin manager. Is it possible to create a local repository (on our local network)? how? Thanks, Alexandre Neto ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Gary Sherman Chair, QGIS Project Steering Committee -Desktop GIS Book: *http://desktopgisbook.com -Alaska Novel: *http://alaskana.co -Geospatial Consulting Hosting: *http://geoapt.com We work virtually everywhere -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Adding PostGIS views to the map
As I recall, QGIS used to treat any unique int field as a suitable key for adding a layer, so that views that were registered in the PostGIS geometry_columns table could be added to the map. Now that geometry_columns is a view rather than a table, spatial views are registered automatically. They appear in the tables list in QGIS, but the primary key has to be selected manually (even if they underlying table column is a suitable primary key). Perhaps I am misremembering that this step was necessary previously, but I wonder if there is any way to avoid it, e.g. by making sure the key column has a specific name, data type, etc? Regards, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How to create a local (LAN) plugin repository
Hello Gary, Thank you for your answer. I see that you mention my webserver. But, we don't have one, and I don't have administration rights for setting one. I was trying to use the regular paths to both plugin.xml and zip files, but qgis is not able to read the xml. I was also tried another approach putting both xml and zips in a dropbox folder, and get their public web links. (Using ?dl=1 in the end, one can make those files downloadable) In that case I'm able to connect to my repository, but no plugins are listed. Thanks, Alexandre Neto PS: My xml looks like this: ?xml version = '1.0' encoding = 'UTF-8'? ?xml-stylesheet type = text/xsl href = plugins.xsl ? plugins pyqgis_plugin name = AdicionaAccoes version = 0.1 description Adiciona accoes / description homepage/ homepage qgis_minimum_version 1.8 / qgis_minimum_version file_name AdicionaAccoes.zip / file_name author_name Alexandre Neto / author_name download_url https://www.dropbox.com/s/y73eickb4qqpfic/AdicionaAccoes.zip?dl=1 / download_url / Pyqgis_plugin / Plugins On Wed, Apr 17, 2013 at 4:17 PM, Gary Sherman gsher...@geoapt.com wrote: It's simple to set up a repo on your network. First create an XML file that describes your plugin(s) and the download location. Here is an example: ?xml version = '1.0' encoding = 'UTF-8'? ?xml-stylesheet type='text/xsl' href='/contributed.xsl' ? plugins pyqgis_plugin name='ScriptRunner' version='0.71' descriptionRun Python scripts /description version0.71/version qgis_minimum_version1.8/qgis_minimum_version homepage/homepage file_namescriptrunner.zip/file_name author_nameGary Sherman/author_name download_urlhttp://geoapt.com/qgis_plugins/scriptrunner.zip /download_url uploaded_bygsherman/uploaded_by create_date2013-03-16/create_date update_dateNone/update_date experimentalTrue/experimental /pyqgis_plugin /plugins Put this on your web server somewhere, then make sure you put the plugin package in the download_url location. Last step is to add your repo to the plugin installer, using the URL to your plugins.xml. Please consider contributing any plugins you create that may have broader interest to the the community. Thanks, -gary On Wed, Apr 17, 2013 at 6:30 AM, Alexandre Neto senhor.n...@gmail.comwrote: I'm developing a toolbar with several python tools for one of our projects. They are very data especific tools, and therefore not interesting to realease as plugins in the official repository. Yet, I would like that my working colleagues could install (and update) it using the Python plugin manager. Is it possible to create a local repository (on our local network)? how? Thanks, Alexandre Neto ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Gary Sherman Chair, QGIS Project Steering Committee -Desktop GIS Book: *http://desktopgisbook.com -Alaska Novel: *http://alaskana.co -Geospatial Consulting Hosting: *http://geoapt.com We work virtually everywhere -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How to create a local (LAN) plugin repository
I'm pretty sure it expects to pull the repo data over an http connection (Port 80). So you will need an internal web server. There is a version of apache called XAMP that will run from a usb stick or hard drive, and doesn't take an install. But you're better off just talking to your IT people and getting a small internal only website from them. Thanks, Alex On 04/17/2013 09:22 AM, Alexandre Neto wrote: Hello Gary, Thank you for your answer. I see that you mention my webserver. But, we don't have one, and I don't have administration rights for setting one. I was trying to use the regular paths to both plugin.xml and zip files, but qgis is not able to read the xml. I was also tried another approach putting both xml and zips in a dropbox folder, and get their public web links. (Using ?dl=1 in the end, one can make those files downloadable) In that case I'm able to connect to my repository, but no plugins are listed. Thanks, Alexandre Neto PS: My xml looks like this: ?xml version = '1.0' encoding = 'UTF-8'? ?xml-stylesheet type = text/xsl href = plugins.xsl ? plugins pyqgis_plugin name = AdicionaAccoes version = 0.1 description Adiciona accoes / description homepage/ homepage qgis_minimum_version 1.8 / qgis_minimum_version file_name AdicionaAccoes.zip / file_name author_name Alexandre Neto / author_name download_url https://www.dropbox.com/s/y73eickb4qqpfic/AdicionaAccoes.zip?dl=1 / download_url / Pyqgis_plugin / Plugins On Wed, Apr 17, 2013 at 4:17 PM, Gary Sherman gsher...@geoapt.com wrote: It's simple to set up a repo on your network. First create an XML file that describes your plugin(s) and the download location. Here is an example: ?xml version = '1.0' encoding = 'UTF-8'? ?xml-stylesheet type='text/xsl' href='/contributed.xsl' ? plugins pyqgis_plugin name='ScriptRunner' version='0.71' descriptionRun Python scripts /description version0.71/version qgis_minimum_version1.8/qgis_minimum_version homepage/homepage file_namescriptrunner.zip/file_name author_nameGary Sherman/author_name download_urlhttp://geoapt.com/qgis_plugins/scriptrunner.zip /download_url uploaded_bygsherman/uploaded_by create_date2013-03-16/create_date update_dateNone/update_date experimentalTrue/experimental /pyqgis_plugin /plugins Put this on your web server somewhere, then make sure you put the plugin package in the download_url location. Last step is to add your repo to the plugin installer, using the URL to your plugins.xml. Please consider contributing any plugins you create that may have broader interest to the the community. Thanks, -gary On Wed, Apr 17, 2013 at 6:30 AM, Alexandre Neto senhor.n...@gmail.comwrote: I'm developing a toolbar with several python tools for one of our projects. They are very data especific tools, and therefore not interesting to realease as plugins in the official repository. Yet, I would like that my working colleagues could install (and update) it using the Python plugin manager. Is it possible to create a local repository (on our local network)? how? Thanks, Alexandre Neto ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- Gary Sherman Chair, QGIS Project Steering Committee -Desktop GIS Book: *http://desktopgisbook.com -Alaska Novel: *http://alaskana.co -Geospatial Consulting Hosting: *http://geoapt.com We work virtually everywhere -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- ___ 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] can't connect Qgis to PostGreSql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 17/04/2013 15:41, Jakob Lanstorp ha scritto: You can also uploade shape file data with pgAdmin plugin 'PostGIS shape filer and DBF loader'. Then you can test your connection settings by loading to QGIS (and not uploading data). Sorry I may have missed previous emails, but dragging and dropping from DB Manager should be the easiest way to import shp to pg. 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 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlFuzsAACgkQ/NedwLUzIr58GgCeMSKS9WnekbaQzHKvtotp2UaS ZkMAn2hflHWgAfiQ3LuV4T8BEMPa5q/8 =cgHh -END PGP SIGNATURE- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Adding PostGIS views to the map
Hi Lee, On Wed, 17. Apr 2013 at 12:14:01 -0400, Lee Hachadoorian wrote: As I recall, QGIS used to treat any unique int field as a suitable key for adding a layer, so that views that were registered in the PostGIS geometry_columns table could be added to the map. Now that geometry_columns is a view rather than a table, spatial views are registered automatically. They appear in the tables list in QGIS, but the primary key has to be selected manually (even if they underlying table column is a suitable primary key). Perhaps I am misremembering that this step was necessary previously, but I wonder if there is any way to avoid it, e.g. by making sure the key column has a specific name, data type, etc? There's no specific name or data type required for a key column and a view is also not required to have just one (or any) underlying tables - so guessing which column might be a unique is not that easy. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de committ(ed|ing) to Quantum GIS IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Editing PostGIS geometries with M data
Within Qgis, I am finding myself unable to edit the nodes of a MultilinestringM geometry stored in a PostGIS database. When I copy the data to a new table with a simple a Multilinestring column (forcing 2d linestrings) I can successfully make my edits. Is this a known issue? The only related info that I could find was an old posthttp://lists.osgeo.org/pipermail/qgis-user/2011-January/010795.html from a few years ago that mentioned an error after saving edits, but there's no response. Perhaps this is more appropriate for the developer list, but I thought I'd check here first. Thanks, Spencer -- This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are NOT the intended recipient and receive this communication, please delete this message and any attachments. Thank you. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
