[Qgis-user] Atlas wont export a table when there are too few records
Hi, I have a composer and I use the atlas functionality to create PDFs. I have point features, and these are contained within different zones. I use atlas to create a map of each zone. The layout is 2 pages, the first page is the map, the 2nd page is a table, made up of 5 frames so I have space for around 250 features in the table. The table displays correctly when I preview the composers in QGIS, but when I try to export to PDF, it refuses to export some of the pages with the tables on (about 5 out of 20 zones). It seems like the pages it wont export are where there is under a certain number of points within the atlas feature. I can get around this if I make the frames smaller in height, but then I cant get all the features in the table for some of my zones. Is anyone else getting this problem? I cant share my actual data, and I dont have time at the moment to see if this happens with other random data. I can try to recreate next week, but just wondered if anyone else is struggling with this problem too. James ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS is chosing the wrong projection when opening shapefiles
QGIS is reporting that a layer that I know is in EPSG 25833 (ETRS89 / UTM zone 33N) is in EPSG 3006 (SWEREF99 TM). The website I download the Shapefile from says it is in 25833, the prj file contains the following: PROJCS[ETRS_1989_UTM_Zone_33N,GEOGCS[GCS_ETRS_1989,DATUM[D_ETRS_1989,SPHEROID[GRS_1980,6378137.0,298.257222101]],PRIMEM[Greenwich,0.0],UNIT[Degree,0.0174532925199433]],PROJECTION[Transverse_Mercator],PARAMETER[False_Easting,50.0],PARAMETER[False_Northing,0.0],PARAMETER[Central_Meridian,15.0],PARAMETER[Scale_Factor,0.9996],PARAMETER[Latitude_Of_Origin,0.0],UNIT[Meter,1.0]] The output from ogrinfo : C:\Users\fmrojst\Desktop\boundariesogrinfo -so -al problem_layer.shp INFO: Open of `problem_layer.shp' using driver `ESRI Shapefile' successful. Layer name: problem_layer Geometry: Polygon Feature Count: 21 Extent: (-99551.21, 6426048.44) - (1121940.59, 7962743.58) Layer SRS WKT: PROJCS[ETRS_1989_UTM_Zone_33N, GEOGCS[GCS_ETRS_1989, DATUM[European_Terrestrial_Reference_System_1989, SPHEROID[GRS_1980,6378137.0,298.257222101]], PRIMEM[Greenwich,0.0], UNIT[Degree,0.0174532925199433]], PROJECTION[Transverse_Mercator], PARAMETER[False_Easting,50.0], PARAMETER[False_Northing,0.0], PARAMETER[Central_Meridian,15.0], PARAMETER[Scale_Factor,0.9996], PARAMETER[Latitude_Of_Origin,0.0], UNIT[Meter,1.0]] Does anyone know why it could be doing this? The shapefile opens with the correct projection in ArcMap. I have found this issue (http://trac.osgeo.org/gdal/ticket/4931) for EPSG 25832... ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Create a polygon of a certain area
Hi all, Does anyone know of a method to quickly create a polygon (square or circle) that is of a given size (I want a polygon of say 12 hectares) and the plugin or whatever works out the length the sides of the square need to be to make the polygon 12 hectares)? Many thanks, James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Copy and paste styles between layers - minor issue
I find that I have to pan the map for the style to be applied rather than open the layer properties. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of magerlin Sent: 01 November 2012 21:37 To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Copy and paste styles between layers - minor issue Copy and paste styles between layers is a cool thing - I often save a subset of a larger shape file and like to adapt the symbology from the major shape file to the subset and copy paste is very easy. But to make the paste procedure work I have to do this after pasting: * Open layer properties * Clicking the Apply button Anybody else experience this? Not a big issue but probably an easy thing to fix in next version? - Regards Morten Qgis 1.8.0 Stand alone installer in Win7 64 bit -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Copy-and-paste-styles-between-layers -minor-issue-tp5013419.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 http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Customisation Menu
Hi all, There is a user on GIS stackexchange who wants to be able to remove all of the menus. I suggested they use the Settings Customisation dialog to do this. They have noticed that there is not the option to remove the following menus: Vector Database Web I have also noticed that Analysis cannot be selected from the customisation dialog too. Is it able to turn this menus off somehow through the gui? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] SVG Fill
That would be great if you could release it if you manage to work something out. It must be a lot easier to get the point styles sorted as SVG files or just a QGIS styles. I may try and create the point symbol ones in QGIS anyway without using the SVGs for them. From: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Sent: 16 August 2012 14:51 To: James Stott Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] SVG Fill Hi James, Yes, that's the general consensus I've had from the off-list replies so far. However, having now played around with some generously supplied symbols, I'm not convinced QGIS could symbolise them neatly anyway without tweaking the SVG itself (i.e. there's no way to specify distance between symbols for instance). I'm going to see if I can come up with something anyway and release it back to the community to augment Lutra's releases (I'm using different columns). Thanks though, Jonathan On 16 August 2012 14:38, James Stott james.st...@npaconsult.co.uk wrote: I believe you need to split the OS svg file into multiple svg files for each symbol. I tried this a while ago and gave up in the end. There are examples of QGIS styling for MasterMap on this website but it only colours the polygons different colours. http://www.lutraconsulting.co.uk/resources/ostranslator James. From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Jonathan Moules Sent: 16 August 2012 13:44 To: qgis-user@lists.osgeo.org Subject: [Qgis-user] SVG Fill Hi List, I'm trying to symbolise Ordnance Survey MasterMap. The OS are nice enough to provide a single SVG file (here: https://www.ordnancesurvey.co.uk/xml/resource/OSMasterMapStyles.svg) with most/all of their symbology in. My question is simple: How do I use these symbols in QGIS? I've found SVG fill, which is the one I'm trying to use (i.e., with nonconiferousTreesAndConiferousTreesPattern) and while it does allow me to specify the SVG file, that seems to be all I can do. QGIS seems to assume that the entire contents of the file should be used for styling, while the file has multiple stylings in. I'm guessing mutliple geometries in a single file is valid SVG (it passes the WGC validator), so is this something QGIS can handle, or will I need to source split files? Thanks, Jonathan This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - www.npaconsult.co.uk http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/ Information and Registered Address http://www.npaconsult.co.uk/ This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. http://www.npaconsult.co.uk/ Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. http://www.npaconsult.co.uk/ Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk http://www.npaconsult.co.uk/ This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. http://www.npaconsult.co.uk/ James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Python Plugin utilising SOAP
I am trying to utilise data from this web service: http://www.nbnws.net/ws_3_5/GatewayWebService?wsdl The site says they are soap web services, which is why I am trying to use suds or another python library. I have had more joy with SOAPpy but still having issues. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp From: Noli Sicad [mailto:nsi...@gmail.com] Sent: 02 August 2012 01:45 To: James Stott Cc: Alexandre Badez; t...@wildintellect.com; qgis-user@lists.osgeo.org; qgis-developer Subject: Re: [Qgis-user] Python Plugin utilising SOAP I don't know what sort of data you want to post and get in web server. SOAP is a bit old. REST API is the way to go now. Bottle http://blog.webspecies.co.uk/2011-06-15/restful-web-services-with-python -the-easy-way.html Noli On 8/2/12, James Stott james.st...@npaconsult.co.uk wrote: Thanks for the responses. I will concentrate on telling the users they need it for now and let them decide how best to manage that. I am having problems with suds though. I point it to the wsdl and all I get back is an error as below: RuntimeError: maximum recursion depth exceeded while pickling an object May try one of the other libraries that are out there. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Alexandre Badez Sent: 31 July 2012 18:36 To: t...@wildintellect.com Cc: qgis-user@lists.osgeo.org; qgis-developer Subject: Re: [Qgis-user] Python Plugin utilising SOAP James, I'm using suds in my plugin on windows 7 64bits. The problem as you mention it, is how to include it in your plugin. For my self I didn't bother because I made a setup.exe that install suds and the plugin where they need to be. I suppose you can copy it in your plugin dir and do something like: from my_plugin import suds suds.blabla It should work. On Tue, Jul 31, 2012 at 6:25 PM, Alex Mandel tech_...@wildintellect.com wrote: James, This discussion would be better for the qgis-developer mailing list. To get started, are you talking about a C++ or a python plugin, and what language is the Suds library in? Thanks, Alex On 07/31/2012 07:12 AM, James Stott wrote: I would like to write a plugin which retrieves data using web services. It would appear I need to use SOAP to send and receive requests. How would I go about setting up soap? I have OSGeo4W installed on Windows 7 64 bit. Could anyone advise me on what the best method to go about this would be? I am using OSGEO4W but I cannot find a SOAP library in the package listing. I have found the Suds library which looks promising. How would I go about making sure this would be usable in a plugin in QGIS on all platforms - is there a way to include the suds library with my plugin? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.a s p http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ 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 -- Alex ___ 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 http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information
Re: [Qgis-user] Python Plugin utilising SOAP
Thanks for the responses. I will concentrate on telling the users they need it for now and let them decide how best to manage that. I am having problems with suds though. I point it to the wsdl and all I get back is an error as below: RuntimeError: maximum recursion depth exceeded while pickling an object May try one of the other libraries that are out there. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Alexandre Badez Sent: 31 July 2012 18:36 To: t...@wildintellect.com Cc: qgis-user@lists.osgeo.org; qgis-developer Subject: Re: [Qgis-user] Python Plugin utilising SOAP James, I'm using suds in my plugin on windows 7 64bits. The problem as you mention it, is how to include it in your plugin. For my self I didn't bother because I made a setup.exe that install suds and the plugin where they need to be. I suppose you can copy it in your plugin dir and do something like: from my_plugin import suds suds.blabla It should work. On Tue, Jul 31, 2012 at 6:25 PM, Alex Mandel tech_...@wildintellect.com wrote: James, This discussion would be better for the qgis-developer mailing list. To get started, are you talking about a C++ or a python plugin, and what language is the Suds library in? Thanks, Alex On 07/31/2012 07:12 AM, James Stott wrote: I would like to write a plugin which retrieves data using web services. It would appear I need to use SOAP to send and receive requests. How would I go about setting up soap? I have OSGeo4W installed on Windows 7 64 bit. Could anyone advise me on what the best method to go about this would be? I am using OSGEO4W but I cannot find a SOAP library in the package listing. I have found the Suds library which looks promising. How would I go about making sure this would be usable in a plugin in QGIS on all platforms - is there a way to include the suds library with my plugin? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.as p http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ 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 -- Alex ___ 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
[Qgis-user] Python Plugin utilising SOAP
I would like to write a plugin which retrieves data using web services. It would appear I need to use SOAP to send and receive requests. How would I go about setting up soap? I have OSGeo4W installed on Windows 7 64 bit. Could anyone advise me on what the best method to go about this would be? I am using OSGEO4W but I cannot find a SOAP library in the package listing. I have found the Suds library which looks promising. How would I go about making sure this would be usable in a plugin in QGIS on all platforms - is there a way to include the suds library with my plugin? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Tool button on composer window
It is called Composer Plugin (its in Marco Hugentobler's repository). Thanks Nathan - exactly what I was after. From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 04 July 2012 15:42 To: James Stott Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Tool button on composer window Hey James, There should be a old plugin that did that extact thing, I think it was called Composer example. Not sure where it is though. If I find it I will let you know. - Nathan On Thu, Jul 5, 2012 at 12:33 AM, James Stott james.st...@npaconsult.co.uk wrote: I would like to create a button on the toolbar of composer window - is this possible. I can't seem to find any information about how to do this. Thanks, James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - www.npaconsult.co.uk http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/ Information and Registered Address http://www.npaconsult.co.uk/ This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. http://www.npaconsult.co.uk/ Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. http://www.npaconsult.co.uk/ Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk http://www.npaconsult.co.uk/ James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Problem with adding a PostGIS query using Python
I cannot seem to get this query to work. The python code I am using is:
db_conn = dbname=database' host=SERVER port=5432
user='postgres' password=''
id_field = gid
table=(SELECT * FROM \designations\.\table\ WHERE
ST_DWithin(ST_GeomFromText('POINT(451583 129144)',27700),
\table\.\geom\, 2000))
uri = %s key=%s table=%s (geom) sql= %
(db_conn,id_field,table,)
layer = QgsVectorLayer(uri, testlayer, postgres)
QgsMapLayerRegistry.instance().addMapLayer(layer)
QGIS keeps telling me the following:
Unable to access the (SELECT relation. The error message from the
database was: ERROR: relation (SELECT does not exist LINE 1: SELECT *
FROM (SELECT LIMIT 1
It's almost as if something is automatically putting another SELECT
statement in front of my SELECT statement.
I can get this query to load using the DB manager plugin SQL window.
I have read this article and it still errors.
http://www.carsonfarmer.com/?p=713
Does anyone know why this doesn't work?
Using QGIS 1.8 on Windows 7 64bit, data is in a PostGIS 2.0 database.
James Stott BSc (Hons) MSc | Senior Professional
Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN
T: 01225 445548 | M: -
http://www.npaconsult.co.uk/
http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp
http://www.npaconsult.co.uk/terms.asp
This Electronic Transmission is intended only for the attention of the
addressee. It may contain privileged and confidential information. If you are
not the person for whom it is intended, you must not copy, distribute or take
any action in reliance on it. If you have received this electronic transmission
in error please notify us immediately by telephone, delete the transmission and
destroy any hard copies.
Nicholas Pearson Associates has used all reasonable efforts to ensure that this
message and any attachments are free from viruses.
Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0)
01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Updating composer label text
I am writing a plugin that replaces the text of a composer label based on its itemID. When I try to change the text of the label using: item.setText(Hello World) The label changes on the composer but the text in the Item Properties panel for the label doesn't, it stays as what it was originally. If I call item.displayText() before and after I change the label text this returns the correct information. How do I get the text to change in the Item Properties panel? Using qgis 1.8. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS Master and Rasters to grayscale
You can still do that by selecting singleband gray, and choose the default contrast enhancement in the options. This just turns the raster into 1 gray colour: 127, 127, 127 can you share a bit sample of your raster? Technically I don’t think I supposed to share the data as it is Ordnance Survey data. I have included the metadata below if this helps: Driver: GDAL provider VRT Virtual Raster Dataset Description N:\Projects\10499 BP\Reference\Base Mapping\Raster\1\OS 1.vrt Band 1 STATISTICS_MAXIMUM=9 STATISTICS_MEAN=3.2746921074487 STATISTICS_MINIMUM=0 STATISTICS_STDDEV=3.9133672791329 Dimensions: X: 39370 Y: 31496 Bands: 1 Origin: 385000,95000 Pixel Size: 0.635001,-0.635001 No Data Value -32768 Data Type: GDT_Byte - Eight bit unsigned integer Pyramid overviews: Layer Spatial Reference System: +proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=40 +y_0=-10 +ellps=airy +towgs84=375,-111,431,0,0,0,0 +units=m +no_defs Layer Extent (layer original source projection): 385000.,75000. : 41.,95000. Band Band 1 Band No 1 No Stats No stats collected yet James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Salvatore Larosa Sent: 19 June 2012 13:02 To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS Master and Rasters to grayscale Il giorno mar, 19/06/2012 alle 12.42 +0100, James Stott ha scritto: This does make what was a very simple thing to do in 1.8 more time consuming in 1.9 doesn’t it? All I want to do is just turn it grayscale for display purposes. In 1.8, all I do is select grayscale from the colormap drop down and push OK and QGIS does it for me. Am I missing something? Hi James, can you share a bit sample of your raster? Regards, -SL -- Salvatore Larosa linkedIn: http://linkedin.com/in/larosasalvatore twitter: @lrssvt skype: s.larosa IRC: lrssvt on freenode ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS Master and Rasters to grayscale
Yes. It still turns into one colour. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: Etienne Tourigny [mailto:etourigny@gmail.com] Sent: 19 June 2012 14:33 To: James Stott Cc: Salvatore Larosa; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS Master and Rasters to grayscale DId you click on Load Button? On Tue, Jun 19, 2012 at 10:22 AM, James Stott james.st...@npaconsult.co.uk wrote: You can still do that by selecting singleband gray, and choose the default contrast enhancement in the options. This just turns the raster into 1 gray colour: 127, 127, 127 can you share a bit sample of your raster? Technically I don't think I supposed to share the data as it is Ordnance Survey data. I have included the metadata below if this helps: Driver: GDAL provider VRT Virtual Raster Dataset Description N:\Projects\10499 BP\Reference\Base Mapping\Raster\1\OS 1.vrt Band 1 STATISTICS_MAXIMUM=9 STATISTICS_MEAN=3.2746921074487 STATISTICS_MINIMUM=0 STATISTICS_STDDEV=3.9133672791329 Dimensions: X: 39370 Y: 31496 Bands: 1 Origin: 385000,95000 Pixel Size: 0.635001,-0.635001 No Data Value -32768 Data Type: GDT_Byte - Eight bit unsigned integer Pyramid overviews: Layer Spatial Reference System: +proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=40 ++y_0=-10 +ellps=airy +towgs84=375,-111,431,0,0,0,0 +units=m ++no_defs Layer Extent (layer original source projection): 385000.,75000. : 41.,95000. Band Band 1 Band No 1 No Stats No stats collected yet James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Salvatore Larosa Sent: 19 June 2012 13:02 To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS Master and Rasters to grayscale Il giorno mar, 19/06/2012 alle 12.42 +0100, James Stott ha scritto: This does make what was a very simple thing to do in 1.8 more time consuming in 1.9 doesn't it? All I want to do is just turn it grayscale for display purposes. In 1.8, all I do is select grayscale from the colormap drop down and push OK and QGIS does it for me. Am I missing something? Hi James, can you share a bit sample of your raster? Regards, -SL -- Salvatore Larosa linkedIn: http://linkedin.com/in/larosasalvatore twitter: @lrssvt skype: s.larosa IRC: lrssvt on freenode ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ 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] Query Layer / Rule Based Rendering Problem
To update this post, I have compared the project file code for both the layer that works and the layer that doesn't and I have found differences in the customproperties section. This section does not exist in the layer that works - it only exists for the layer that I copied the style for. Removing it makes the layer show on the map. customproperties property key=labeling value=pal/ property key=labeling/addDirectionSymbol value=false/ property key=labeling/bufferColorB value=255/ property key=labeling/bufferColorG value=255/ property key=labeling/bufferColorR value=255/ property key=labeling/bufferSize value=1/ property key=labeling/dataDefinedProperty0 value=/ property key=labeling/dataDefinedProperty1 value=/ property key=labeling/dataDefinedProperty10 value=16/ property key=labeling/dataDefinedProperty11 value=/ property key=labeling/dataDefinedProperty12 value=/ property key=labeling/dataDefinedProperty13 value=/ property key=labeling/dataDefinedProperty14 value=/ property key=labeling/dataDefinedProperty2 value=/ property key=labeling/dataDefinedProperty3 value=/ property key=labeling/dataDefinedProperty4 value=/ property key=labeling/dataDefinedProperty5 value=/ property key=labeling/dataDefinedProperty6 value=/ property key=labeling/dataDefinedProperty7 value=/ property key=labeling/dataDefinedProperty8 value=/ property key=labeling/dataDefinedProperty9 value=15/ property key=labeling/decimals value=0/ property key=labeling/dist value=0/ property key=labeling/distInMapUnits value=false/ property key=labeling/enabled value=true/ property key=labeling/fieldName value=number/ property key=labeling/fontFamily value=MS Shell Dlg 2/ property key=labeling/fontItalic value=false/ property key=labeling/fontSize value=8.25/ property key=labeling/fontSizeInMapUnits value=false/ property key=labeling/fontStrikeout value=false/ property key=labeling/fontUnderline value=false/ property key=labeling/fontWeight value=50/ property key=labeling/formatNumbers value=false/ property key=labeling/isExpression value=false/ property key=labeling/labelPerPart value=false/ property key=labeling/mergeLines value=false/ property key=labeling/minFeatureSize value=0/ property key=labeling/obstacle value=true/ property key=labeling/placement value=1/ property key=labeling/placementFlags value=0/ property key=labeling/plussign value=true/ property key=labeling/priority value=5/ property key=labeling/scaleMax value=0/ property key=labeling/scaleMin value=0/ property key=labeling/textColorB value=0/ property key=labeling/textColorG value=0/ property key=labeling/textColorR value=0/ property key=labeling/wrapChar value=/ Using QGIS 1.8.0 on Windows 7 James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of James Stott Sent: 31 May 2012 16:22 To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Query Layer / Rule Based Rendering Problem I have created a query in the DB Manager SQL Window (data is in a PostGIS database). The query is then added to the map as a layer. I copy the style from another layer (rule based style), paste it to my query layer and the polygons disappear from the map and QGIS gives a nextFeature() without select() error. This also happens if I apply a qml style file to the layer. If I change the styles back to Single Symbol they do not come back. I can see the records in the Attribute table, and I can select them and zoom to them on the map, I just cannot see them. I have to re-add the query layer using the DB Manager SQL window again. It only seems to be the polygon layers that cause problems at the moment. Does anyone know the cause of this? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention
[Qgis-user] Query Layer / Rule Based Rendering Problem
I have created a query in the DB Manager SQL Window (data is in a PostGIS database). The query is then added to the map as a layer. I copy the style from another layer (rule based style), paste it to my query layer and the polygons disappear from the map and QGIS gives a nextFeature() without select() error. This also happens if I apply a qml style file to the layer. If I change the styles back to Single Symbol they do not come back. I can see the records in the Attribute table, and I can select them and zoom to them on the map, I just cannot see them. I have to re-add the query layer using the DB Manager SQL window again. It only seems to be the polygon layers that cause problems at the moment. Does anyone know the cause of this? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Save as... CSV Error
Is it just a windows thing then? Anyone on windows able to test? James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp From: Giovanni Manghi [mailto:giovanni.man...@faunalia.pt] Sent: 27 May 2012 22:01 To: James Stott Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Save as... CSV Error Hi, The CSV file listed in the error is the csv that I have previously saved and then opened. If I close this csv QGIS does not error. cannot confirm here on master/ubuntu. cheers -- Giovanni -- http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Save as... CSV Error
Before I file a bug report, just wanted to check whether others have experienced this. Steps to reproduce 1) Save a layer to csv using right click menu Save As.. or Layer menu Save As... 2) Open this csv 3) Save another csv When I try and save the 2nd csv, QGIS errors with the following message: Export to vector file failed. Error: creation of data source failed (OGR error:Failed to open C:/Users/username/Desktop/tmp\LMA_Ramsar.csv, No error.) The CSV file listed in the error is the csv that I have previously saved and then opened. If I close this csv QGIS does not error. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Raster Layers obscuring other layers using master
Hi all, Is anyone else getting strange behaviour with Raster Layers? I have had a few instances this morning where raster layers added to a project do not show vector data or other raster data above them. However the labels from the vector layers are drawing above the raster layer. In my current project, the vrt I have added of tifs is working fine, but the tif file I have added does not. I am using QGIS master. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-developer] Re: [Qgis-user] Raster Layers obscuring other layers using master
That was the problem. I never set QGIS to change from rendering using the legend. Is there a reason this might have changed on its own? James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: Tim Sutton [mailto:li...@linfiniti.com] Sent: 03 May 2012 14:59 To: giovanni.man...@faunalia.pt Cc: John Callahan; qgis-user@lists.osgeo.org; qgis-develo...@lists.osgeo.org; James Stott Subject: Re: [Qgis-developer] Re: [Qgis-user] Raster Layers obscuring other layers using master Hi On Thu, May 3, 2012 at 2:41 PM, Giovanni Manghi giovanni.man...@faunalia.pt wrote: On Thu, 2012-05-03 at 08:38 -0400, John Callahan wrote: I have exactly the same problem. The rasters I used were both TIF and sid images. They covered the rasters, regardless of its layer positioning. Works fine with the latest stable build (1.7.x). Can you check that you are indeed using the legend to manage render order? Regards Tim Someone can test if this issue affects also the code freezed for 1.8? If yes please file a ticket and -as it is a regression- tag it as blocker. cheers -- Giovanni -- ___ Qgis-developer mailing list qgis-develo...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Tim Sutton - QGIS Project Steering Committee Member (Release Manager) == Please do not email me off-list with technical support questions. Using the lists will gain more exposure for your issues and the knowledge surrounding your issue will be shared with all. Visit http://linfiniti.com to find out about: * QGIS programming and support services * Mapserver and PostGIS based hosting plans * FOSS Consulting Services Skype: timlinux Irc: timlinux on #qgis at freenode.net == http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] PostGIS query running in 1.7.4 but not 1.9
I am trying to run a query in QGIS. The query below works in QGIS 1.7.4 but I cannot get it to open in 1.9 (Windows 7). SELECT units.gid, units.name, pipe.section, units.the_geom FROM data.units, data. pipe WHERE pipe.section = 'W' and ST_DWithin(pipe.the_geom, units.the_geom, 500); Does anyone know what I am doing wrong? James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] PostGIS query running in 1.7.4 but not 1.9
Hi Salvatore, I think that has just appeared from my editing the table names for including the query in this email. DB manager will execute the query and give me the results in the Result section, it just won't add it to the map in 1.9. It will add it to the map in 1.7.4. If I save the project in 1.7.4 with the query in it, it will not open in 1.9. I think I have worked it out. The query returns the same polygon multiple times, and as such the gid column isn’t unique for each record. I guess I just need to only return each polygon once for QGIS to be able to use the query layer. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Salvatore Larosa Sent: 27 April 2012 10:38 To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] PostGIS query running in 1.7.4 but not 1.9 Il giorno ven, 27/04/2012 alle 10.28 +0100, James Stott ha scritto: I am trying to run a query in QGIS. The query below works in QGIS 1.7.4 but I cannot get it to open in 1.9 (Windows 7). SELECT units.gid, units.name, pipe.section, units.the_geom FROM data.units, data. pipe WHERE pipe.section = 'W' and ST_DWithin(pipe.the_geom, units.the_geom, 500); Does anyone know what I am doing wrong? Hi James, I see a blank space in name table (pipe) in clause FROM: FROM data.units, data. pipe Could be the problem there? Regards, -SL ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Saved styles and legends
Hi all, I have a categorised and a rule based style set up for a dataset. I would like to apply these to another dataset but my 2nd dataset does not contain all of the things that are in the first dataset. Is it possible to only show the items that appear in a dataset in the legend on a composer when you have applied saved style to the dataset? Or do I have to go through and manually delete them all (I can select show feature count on the layer so I know which items I do not need). I would like to keep the other styles applied to the layer just in case some of the other types are added to the map, just not to show them on the legend on the composer. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Plugin to add a layer for each unique value in a column
I would like to add a layer for each unique value of a text column in a table. For example, if I have a column called type, and the values in it were tree, stone and plant I would like to add a layer for each type. So in this example I would have 3 layers. I know there is a plugin called Shapefile Splitter that splits out to a shapefile for each unique value, but I just want it to split to layers in QGIS. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] Plugin to add a layer for each unique value in acolumn
Thanks for the reply. This is the approach I am using at the moment. I was hoping to find a tool that did it in a more automated fashion, as my data would require me to add the layer 20 times, and query each of these 20 layers. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Zirneklitis Sent: 15 March 2012 11:19 Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugin to add a layer for each unique value in acolumn Add the same layer three times. James Stott wrote: .. For example, if I have a column called type, and the values in it were tree, stone and plant I would like to add a layer for each type. So in this example I would have 3 layers. .. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] Plugin to add a layer for each unique value in acolumn
Hi Nathan/Andreas, I would happily use another method to deal with this but I haven’t managed to come up with one. My layer has site boundaries (20 of them) on it. I also have a layer with buffers for my sites in it. I have a buffer per site (20 sites) and these are from a PostGIS view as these alter whenever I change the site boundary. I would like to then add each site boundary and each buffer onto a map as a separate layer because: 1) I add the site boundary and the buffer to a group, then the users can then turn each one on and off as needed when looking at the project file in QGIS. 2) For map production (using composers) I have a composer per site. I lock the layers in the composer map item and then jpg all my maps at the end. To do this I need to have each buffer on a separate layer as otherwise it would show the other sites as they are quite close together. The only way I can think to do this at the moment is to add each layer 20 times, and then query it by each individual site. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: 15 March 2012 12:10 To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugin to add a layer for each unique value in acolumn Hi James, And why would you need that? Maybe there is another solution to your problem with just one or fewer layers. Andreas On Thu, 15 Mar 2012 11:08:04 -, James Stott wrote: I would like to add a layer for each unique value of a text column in a table. For example, if I have a column called type, and the values in it were tree, stone and plant I would like to add a layer for each type. So in this example I would have 3 layers. I know there is a plugin called Shapefile Splitter that splits out to a shapefile for each unique value, but I just want it to split to layers in QGIS. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] Plugin to add a layer for each unique value in acolumn
I may have a look at seeing if I can use the shapefile splitter plugin and change it so it adds the layers as queries to the QGIS map canvas rather than saving out shapefiles. How would you add a selection of an existing layer as a new layer to the map using python(without saving the selection to a file and then adding that files to the map)? The spatial query plugin seems to do this but I cannot find the code to see how it does it. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: 15 March 2012 14:33 To: qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] Plugin to add a layer for each unique value in acolumn Ok - so it seems like a reporting / map production problem. I am not sure if the EasyPrint or Atlas Plugin can help. EasyPrint allows to print each feature on a separate map. But it sounds like for your problem easy print would have to be extended to allow for maps per filter or using a group attribute. I am not sure if there is an out of the box solution for your problem with QGIS. For my own similar projects I set up a printing process using Apache FOP with XSL-FO and then use QGIS-server to print the map extents. I understand that this would be overkill/too much work to setup for you. Andreas On Thu, 15 Mar 2012 12:50:00 -, James Stott wrote: Hi Nathan/Andreas, I would happily use another method to deal with this but I haven’t managed to come up with one. My layer has site boundaries (20 of them) on it. I also have a layer with buffers for my sites in it. I have a buffer per site (20 sites) and these are from a PostGIS view as these alter whenever I change the site boundary. I would like to then add each site boundary and each buffer onto a map as a separate layer because: 1) I add the site boundary and the buffer to a group, then the users can then turn each one on and off as needed when looking at the project file in QGIS. 2) For map production (using composers) I have a composer per site. I lock the layers in the composer map item and then jpg all my maps at the end. To do this I need to have each buffer on a separate layer as otherwise it would show the other sites as they are quite close together. The only way I can think to do this at the moment is to add each layer 20 times, and then query it by each individual site. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: 15 March 2012 12:10 To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugin to add a layer for each unique value in acolumn Hi James, And why would you need that? Maybe there is another solution to your problem with just one or fewer layers. Andreas On Thu, 15 Mar 2012 11:08:04 -, James Stott wrote: I would like to add a layer for each unique value of a text column in a table. For example, if I have a column called type, and the values in it were tree, stone and plant I would like to add a layer for each type. So in this example I would have 3 layers. I know there is a plugin called Shapefile Splitter that splits out to a shapefile for each unique value, but I just want it to split to layers in QGIS. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis
[Qgis-user] Custom Projection for EPSG 27700 when opening shp and TAB files from other software
I just wanted to check that this was working ok (using QGIS 1.9 Master). I am a little confused by the different results I get from different data. The definition of a layer in QGIS using OSGB 1936 / British National Grid (27700) is: +proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=40 +y_0=-10 +ellps=airy +towgs84=446.448,-125.157,542.06,0.15,0.247,0.842,-20.489 +units=m +no_defs I have data in MapInfo TAB files that are created in software other than QGIS. When I open these they come in with the following custom projection defined which is different from EPSG 27700 and as such not recognised as it: +proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=40 +y_0=-10 +ellps=airy +towgs84=375,-111,431,-0,-0,-0,0 +units=m +no_defs I have data in a shapefile format not created by QGIS. When loaded into QGIS these have the projection defined as a custom projection as shown below which seems to match the EPSG 27700 definition but does not get recognised as 27700: +proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012716 +x_0=40 +y_0=-10 +ellps=airy +towgs84=446.448,-125.157,542.06,0.1502,0.247,0.8421,-20.4894 +units=m +no_defs Is this the correct behaviour and are all the custom projections giving me the correct results? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] Scale seems strange in
Fixed with the latest update. Thanks for fixing this. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: Giovanni Manghi [mailto:giovanni.man...@gmail.com] Sent: 04 November 2011 16:42 To: James Stott Cc: Brad Nesom; qgis-user@lists.osgeo.org; qgis-develo...@lists.osgeo.org Subject: RE: [Qgis-user] Scale seems strange in Hi, I can confirm that in my qgis-master on Ubuntu 11.10 the scale is going crazy with epsg:3763 and others projected CRSs. Seems fine with WGS85. Cheers -- Giovanni -- On Fri, 2011-11-04 at 09:15 +, James Stott wrote: Thanks for the response and your explanation. It helped to cement what I already thought. My point is I think something has gone strange with EPSG 27700 in QGIS at the moment. It works fine on 1.7.1 and not on the OSGeo4W 1.8.0-120. It never used to set the units to degrees – it should be metres. I think that QGIS is getting the default units wrong for 27700. The coordinate system definition states that the units should be m. I am also reporting this behaviour on my windows computer at home (completely separate to the computers we have the issue on at work) and a computer using Ubuntu 11.10. And on a windows machine on (1.8.0-78) it works fine. I have also noticed a change in the behaviour of Save As... When exporting to MapInfo MIF. Previously QGIS was getting the export wrong and using BNG with WGS84, now it is exporting it to BNG with OSGB36 (which is correct). James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - www.npaconsult.co.uk From: kidsmake6until2...@gmail.com [mailto:kidsmake6until2...@gmail.com] On Behalf Of Brad Nesom Sent: 02 November 2011 19:49 To: James Stott Cc: Saber Razmjooei; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Scale seems strange in so did you understand why? lat lon is not an equidistant coordinate system. It is an angular measure. The graticules merge closer togehter the further north they go. When you overlay data projected to ll onto a flat surface the lengths east west at the top are shorter than the lengths east west at the bottom. that is what is changing the scale because without zooming the scale of the objects would change by panning the map north and south. Nothng about the scale is changing except the distance measured across. No coordinate values. HTH On Wed, Nov 2, 2011 at 10:12 AM, James Stott james.st...@npaconsult.co.uk wrote: If I use the arrow keys to pan north and south the scale changes. If I use them to pan left and right it doesn’t change. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - www.npaconsult.co.uk From: kidsmake6until2...@gmail.com [mailto:kidsmake6until2...@gmail.com] On Behalf Of Brad Nesom Sent: 02 November 2011 15:00 To: James Stott Cc: Saber Razmjooei; qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Scale seems strange in I am thinking rather than that it is just the fact that when you use degrees, moving in the map would give you a different scale. Because every time you move north or south you have changed the length of the x distance. If you pan left and right (very carefully) do you see the scale not change? On Wed, Nov 2, 2011 at 9:02 AM, James Stott james.st...@npaconsult.co.uk wrote: Could this just be a windows thing then? I tried an older version of qgis-dev (1.8.0-78) on a different windows machine in the office and there are no problems. Metres should be the default setting for 27700 shouldn't it not degrees? James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: Saber Razmjooei [mailto:razmjoo...@faunalia.co.uk] Sent: 02 November 2011 10:48 To: James Stott Cc: qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] Scale seems strange in James I am using QGIS-Trunk under ubuntu 10.04. The canvas projection is set to 27700 and Layer unit to metre. The scale seems to be fine and not affected by panning. Cheers Saber On Wed, 2011-11-02 at 10:43 +, James Stott wrote: An update: This is also happening on a colleague’s machine. I have reverted back to the previous OSGeo4W nightly and that doesn’t fix the problem. Uninstalling and reinstalling doesn’t work. In 1.7, if I open up this certain dataset of viewpoint locations, it opens with a scale of 1:53478. In 1.8 if I load the dataset it opens at a scale of 1:5325654358. If I use the pan tool and just click on the map the scale changes to 1:631588609, then 1:2918610855, then 1:2934133484 and so
RE: [Qgis-user] Scale seems strange in
Could this just be a windows thing then? I tried an older version of qgis-dev (1.8.0-78) on a different windows machine in the office and there are no problems. Metres should be the default setting for 27700 shouldn't it not degrees? James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: Saber Razmjooei [mailto:razmjoo...@faunalia.co.uk] Sent: 02 November 2011 10:48 To: James Stott Cc: qgis-user@lists.osgeo.org Subject: RE: [Qgis-user] Scale seems strange in James I am using QGIS-Trunk under ubuntu 10.04. The canvas projection is set to 27700 and Layer unit to metre. The scale seems to be fine and not affected by panning. Cheers Saber On Wed, 2011-11-02 at 10:43 +, James Stott wrote: An update: This is also happening on a colleague’s machine. I have reverted back to the previous OSGeo4W nightly and that doesn’t fix the problem. Uninstalling and reinstalling doesn’t work. In 1.7, if I open up this certain dataset of viewpoint locations, it opens with a scale of 1:53478. In 1.8 if I load the dataset it opens at a scale of 1:5325654358. If I use the pan tool and just click on the map the scale changes to 1:631588609, then 1:2918610855, then 1:2934133484 and so on. Distance measures seem unaffected. It seems to be being caused by the units of the project being set to degrees. I have saved a project and the units are set to degrees. If I open an old project up it opens at the correct scale. In my old project files it is set to metres. (see examples below). It seems I have to make sure Enable on the fly projection is unticked in the project properties, and then manually set the Layer units to metres in the general tab. I was also having problems a while ago with exporting to MapInfo but I have just tried this and it works. See links below for details. It is including the 79 not the 104 now. http://gis.stackexchange.com/questions/14350/qgis-and-mapinfo-projections-epsg-27700-british-national-grid http://hub.qgis.org/issues/4271 New project: mapcanvas unitsdegrees/units extent xmin384571.226869/xmin ymin78401.536498/ymin xmax408875.829430/xmax ymax92579.221325/ymax /extent projections0/projections destinationsrs spatialrefsys proj4+proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=40 +y_0=-10 +ellps=airy +towgs84=446.448,-125.157,542.06,0.15,0.247,0.842,-20.489 +units=m +no_defs/proj4 srsid2437/srsid srid27700/srid authidEPSG:27700/authid descriptionOSGB 1936 / British National Grid/description projectionacronymtmerc/projectionacronym ellipsoidacronymairy/ellipsoidacronym geographicflagfalse/geographicflag /spatialrefsys /destinationsrs /mapcanvas Old project: mapcanvas unitsmeters/units extent xmin400790.090563/xmin ymin86512.592259/ymin xmax401731.465923/xmax ymax87217.568425/ymax /extent projections0/projections destinationsrs spatialrefsys proj4+proj=tmerc +lat_0=49 +lon_0=-2 +k=0.9996012717 +x_0=40 +y_0=-10 +ellps=airy +towgs84=446.448,-125.157,542.06,0.15,0.247,0.842,-20.489 +units=m +no_defs/proj4 srsid2437/srsid srid27700/srid authidEPSG:27700/authid descriptionOSGB 1936 / British National Grid/description projectionacronymtmerc/projectionacronym ellipsoidacronymairy/ellipsoidacronym geographicflagfalse/geographicflag /spatialrefsys /destinationsrs /mapcanvas James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - www.npaconsult.co.uk From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of James Stott Sent: 01 November 2011 09:15 To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Scale seems strange in Hi all, I am having problems with scales on v1.8 (7297b23) from OSGeo4W. If I open an existing project everything is fine. If I open data in a fresh QGIS session it is reporting strange scales. It doesn’t matter what source the data is. For example, I open a dataset and it reports 1:784735546. It seems to report correct distances. If I pan the scale changes. I am using EPSG 27700 (British National Grid). Does anyone have any idea what can be causing this? James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson
[Qgis-user] RE: [Qgis-developer] DB Manager release
I just tried to upgrade the plugin (it just came up with the new version recently) and it crashed and said I was missing a dependency. I think it was something tinker (I have forgotten exactly what it was)? I am using QGIS 1.8 from OSGEO4W on XP. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-developer-boun...@lists.osgeo.org [mailto:qgis-developer-boun...@lists.osgeo.org] On Behalf Of Yves Jacolin Sent: 15 September 2011 13:18 To: qgis-develo...@lists.osgeo.org; cavall...@faunalia.it Cc: qgis-user Subject: Re: [Qgis-developer] DB Manager release Great! Thanks to all! Y. Le jeudi 15 septembre 2011 14:18:20, Paolo Cavallini a écrit : Hi all. Thanks to the hard work of Giuseppe Sucameli, the supervision of Martin Dobias, and the support of Google for its Summer of Code initiative, DB Manager is now available. DBManager's aim is to merge together some QGis DB plugins, e.g. PGManager, SLManager, RT_Sql_Layer. In this moment it works with both PostgreSQL and SQLite databases and it displays the list of tables, info about the selected table, table data and preview, but also allows to rename/delete tables through its GUI and run query on the selected database, so at this stage it replaces at all SLManager. Thanks to Mauricio De Paulo (mauriciodev), now DB Manager also supports PostGIS Rasters! The last DB Manager version has support to Import Vector Layer feature by drag'n'drop a layer from the QGis browser (or even DB Manager) to a database in the DBManager GUI. The Import Vector Layer feature allows to import/copy any vector layer QGis can load between different datasources, i.e. PostGIS/SpatiaLite databases and OGR files. It's available through the QgsVectorLayerImport class and it has just been merged in master branch. See [1] for an example of use. Faunalia is committed to support the development of this tool, and other DB plugin developers are welcome to join and merge their work, it this makes sense, to reduce confusion for users. Enjoy. [1] http://www.youtube.com/watch?v=bBe7WctSAXI -- Yves Jacolin http://yjacolin.gloobe.org ___ Qgis-developer mailing list qgis-develo...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] RE: [Qgis-developer] DB Manager release
I cannot recreate the error now as the plugin manager is only finding version 0.1.0 of the plugin. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: Saber Razmjooei [mailto:razmjoo...@faunalia.co.uk] Sent: 15 September 2011 16:00 To: James Stott Cc: Yves Jacolin; qgis-develo...@lists.osgeo.org; cavall...@faunalia.it; qgis-user Subject: RE: [Qgis-developer] DB Manager release James Could you post the error? Cheers Saber On Thu, 2011-09-15 at 15:37 +0100, James Stott wrote: I just tried to upgrade the plugin (it just came up with the new version recently) and it crashed and said I was missing a dependency. I think it was something tinker (I have forgotten exactly what it was)? I am using QGIS 1.8 from OSGEO4W on XP. James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -Original Message- From: qgis-developer-boun...@lists.osgeo.org [mailto:qgis-developer-boun...@lists.osgeo.org] On Behalf Of Yves Jacolin Sent: 15 September 2011 13:18 To: qgis-develo...@lists.osgeo.org; cavall...@faunalia.it Cc: qgis-user Subject: Re: [Qgis-developer] DB Manager release Great! Thanks to all! Y. Le jeudi 15 septembre 2011 14:18:20, Paolo Cavallini a écrit : Hi all. Thanks to the hard work of Giuseppe Sucameli, the supervision of Martin Dobias, and the support of Google for its Summer of Code initiative, DB Manager is now available. DBManager's aim is to merge together some QGis DB plugins, e.g. PGManager, SLManager, RT_Sql_Layer. In this moment it works with both PostgreSQL and SQLite databases and it displays the list of tables, info about the selected table, table data and preview, but also allows to rename/delete tables through its GUI and run query on the selected database, so at this stage it replaces at all SLManager. Thanks to Mauricio De Paulo (mauriciodev), now DB Manager also supports PostGIS Rasters! The last DB Manager version has support to Import Vector Layer feature by drag'n'drop a layer from the QGis browser (or even DB Manager) to a database in the DBManager GUI. The Import Vector Layer feature allows to import/copy any vector layer QGis can load between different datasources, i.e. PostGIS/SpatiaLite databases and OGR files. It's available through the QgsVectorLayerImport class and it has just been merged in master branch. See [1] for an example of use. Faunalia is committed to support the development of this tool, and other DB plugin developers are welcome to join and merge their work, it this makes sense, to reduce confusion for users. Enjoy. [1] http://www.youtube.com/watch?v=bBe7WctSAXI http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
