[Qgis-user] Create a non spatial index on an attribute in QGIS before joining two layers
Hi, I'm using QGIS 2.0.1 on Windows 7. I'm trying to join a .dbf which contains no spatial data to a shape file containing spatial data. Ideally I'd like to create an attribute index on the join field in the .dbf before I join it to the shape file. Does anybody know how I can do this? Also in the join menu there are two tick box options: 1. Cache join layer in virtual memory 2. Create attribute index on join field Can anybody tell me what these two options mean? Is the attribute index created during the join if I was to tick this or is it done before the join? Cheers Jess This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person. Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice. Thank you for your cooperation. Ordnance Survey Adanac Drive Southampton SO16 0AS Tel: 08456 050505 http://www.ordnancesurvey.co.uk ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Categorised Styling of PostGIS layers
Morning all, I'm trying to style some flooding probability data. It's in PostGIS and I'm using QGIS master (same issue in 2.0 and 2.2 though). My polygon layer has a probability field with values H, M and L. If I select a categorised style using the probability field I get the expected three values. And an extra one. And the data is drawn using the style of the extra category - in the screenshot the pink lines and not the blues as expected. If I delete the extra category from the classification table then nothing is drawn on the canvas. I have checked the field and there are only three unique values in it without nulls or blanks. The table is properly indexed with a primary key and GIST spatial index. So, is it a QGIS style engine problem or a PostGIS data problem? I should add that the same data from PostGIS draws perfectly in ArcGIS 10.2.2 and is styled as expected. Anyone else had similar experiences? [If the screenshot is scrubbed by the list then you can see it here: http://openphoto.mixedbredie.net/photo/96/view] Ross McDonald | GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT T: 01307 476419 | F: 01307 476401 | E: mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk | W: Angus Mapshttp://www.angus.gov.uk/maps/map_home.cfm This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Categorised Styling of PostGIS layers
Somehow QGIS is not finding any of those 3 values in the features in that extent. Can you select a few visible (pink) features and check their probability field values? Are you sure that all you features have valid values in the prob column? Try build that same stack of symbols using rule-based symbology. And see if it works. You can also try save a few features in other format, say a shapefile, open it and copy the style. See if it works there (I doubt). Not having access to the data, is quite difficult to understand what can be wrong, if you can provide a sample data, I can give a look into it. Alexandre Neto On Fri, May 30, 2014 at 11:35 AM, McDonaldR mcdona...@angus.gov.uk wrote: Morning all, I'm trying to style some flooding probability data. It's in PostGIS and I'm using QGIS master (same issue in 2.0 and 2.2 though). My polygon layer has a probability field with values H, M and L. If I select a categorised style using the probability field I get the expected three values. And an extra one. And the data is drawn using the style of the extra category - in the screenshot the pink lines and not the blues as expected. If I delete the extra category from the classification table then nothing is drawn on the canvas. I have checked the field and there are only three unique values in it without nulls or blanks. The table is properly indexed with a primary key and GIST spatial index. So, is it a QGIS style engine problem or a PostGIS data problem? I should add that the same data from PostGIS draws perfectly in ArcGIS 10.2.2 and is styled as expected. Anyone else had similar experiences? [If the screenshot is scrubbed by the list then you can see it here: http://openphoto.mixedbredie.net/photo/96/view] *Ross McDonald *| GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT T: *01307 476419* | F: 01307 476401 | E: mcdona...@angus.gov.uk | W: *Angus Maps http://www.angus.gov.uk/maps/map_home.cfm* This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ 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] Categorised Styling of PostGIS layers
Hi Alexandre, Brent Thanks for the pointers. Rules based renderer failed but it work on the same data in different format. Going back to the source data (ESRI FGDB) and checking PostGIS I noticed the prob field was set to char(50). I reloaded the data with the field as varchar(50) and it now renders correctly although I still get the extra category added – presumably to catch blank records. With the data as char(50) categorisation works if I set the field with an expression like, TRIM(“prob”), as it then strips of the 49 blank spaces after the H. Varchar is better though as the table is smaller. Many thanks Ross From: Alexandre Neto [mailto:senhor.n...@gmail.com] Sent: 30 May 2014 12:01 To: McDonaldR Cc: QGIS User Subject: Re: [Qgis-user] Categorised Styling of PostGIS layers Somehow QGIS is not finding any of those 3 values in the features in that extent. Can you select a few visible (pink) features and check their probability field values? Are you sure that all you features have valid values in the prob column? Try build that same stack of symbols using rule-based symbology. And see if it works. You can also try save a few features in other format, say a shapefile, open it and copy the style. See if it works there (I doubt). Not having access to the data, is quite difficult to understand what can be wrong, if you can provide a sample data, I can give a look into it. Alexandre Neto On Fri, May 30, 2014 at 11:35 AM, McDonaldR mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk wrote: Morning all, I'm trying to style some flooding probability data. It's in PostGIS and I'm using QGIS master (same issue in 2.0 and 2.2 though). My polygon layer has a probability field with values H, M and L. If I select a categorised style using the probability field I get the expected three values. And an extra one. And the data is drawn using the style of the extra category - in the screenshot the pink lines and not the blues as expected. If I delete the extra category from the classification table then nothing is drawn on the canvas. I have checked the field and there are only three unique values in it without nulls or blanks. The table is properly indexed with a primary key and GIST spatial index. So, is it a QGIS style engine problem or a PostGIS data problem? I should add that the same data from PostGIS draws perfectly in ArcGIS 10.2.2 and is styled as expected. Anyone else had similar experiences? [If the screenshot is scrubbed by the list then you can see it here: http://openphoto.mixedbredie.net/photo/96/view] Ross McDonald | GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT T: 01307 476419 | F: 01307 476401 | E: mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk | W: Angus Mapshttp://www.angus.gov.uk/maps/map_home.cfm This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ Qgis-user mailing list Qgis-user@lists.osgeo.orgmailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Categorised Styling of PostGIS layers
That sounds still strange. Do you have space characters on your fields? I would definitely remove them. Either way, in Rule based symbology, you could use a rule like this: prob like 'H%' Alexandre Neto On Fri, May 30, 2014 at 12:47 PM, McDonaldR mcdona...@angus.gov.uk wrote: Hi Alexandre, Brent Thanks for the pointers. Rules based renderer failed but it work on the same data in different format. Going back to the source data (ESRI FGDB) and checking PostGIS I noticed the prob field was set to char(50). I reloaded the data with the field as varchar(50) and it now renders correctly although I still get the extra category added – presumably to catch blank records. With the data as char(50) categorisation works if I set the field with an expression like, TRIM(“prob”), as it then strips of the 49 blank spaces after the H. Varchar is better though as the table is smaller. Many thanks Ross *From:* Alexandre Neto [mailto:senhor.n...@gmail.com] *Sent:* 30 May 2014 12:01 *To:* McDonaldR *Cc:* QGIS User *Subject:* Re: [Qgis-user] Categorised Styling of PostGIS layers Somehow QGIS is not finding any of those 3 values in the features in that extent. Can you select a few visible (pink) features and check their probability field values? Are you sure that all you features have valid values in the prob column? Try build that same stack of symbols using rule-based symbology. And see if it works. You can also try save a few features in other format, say a shapefile, open it and copy the style. See if it works there (I doubt). Not having access to the data, is quite difficult to understand what can be wrong, if you can provide a sample data, I can give a look into it. Alexandre Neto On Fri, May 30, 2014 at 11:35 AM, McDonaldR mcdona...@angus.gov.uk wrote: Morning all, I'm trying to style some flooding probability data. It's in PostGIS and I'm using QGIS master (same issue in 2.0 and 2.2 though). My polygon layer has a probability field with values H, M and L. If I select a categorised style using the probability field I get the expected three values. And an extra one. And the data is drawn using the style of the extra category - in the screenshot the pink lines and not the blues as expected. If I delete the extra category from the classification table then nothing is drawn on the canvas. I have checked the field and there are only three unique values in it without nulls or blanks. The table is properly indexed with a primary key and GIST spatial index. So, is it a QGIS style engine problem or a PostGIS data problem? I should add that the same data from PostGIS draws perfectly in ArcGIS 10.2.2 and is styled as expected. Anyone else had similar experiences? [If the screenshot is scrubbed by the list then you can see it here: http://openphoto.mixedbredie.net/photo/96/view] *Ross McDonald *| GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT T: *01307 476419* | F: 01307 476401 | E: mcdona...@angus.gov.uk | W: *Angus Maps http://www.angus.gov.uk/maps/map_home.cfm* This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] LRS Plugin
Hello all, I will start exploring LRS Plugin. Does anyone have any free sample data to try? Any tricks and tips for this plugins? Thanks Nelson Poupe na sua conta de telefone com os melhores preccedil;os para moacute;veis e fixos. Natilde;o necessita de mudar nada e temos ofertas de boas vindas para si. Visite-nos em www.g9telecom.pt ou telefone para 707 450 000. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Share some of my Processing Scripts
Hi QGIS users and devs, I would like to share the Processing scripts I have created this last 2 months. Here is the list : Database = * Create vector layer from PostGIS table : fill the database connection parameters, choose a table and an optionnal WHERE clause, and get the result as a vector layer * Create vector layer from SQL Query : Choose the database type (PostGIS or Spatialite), write the query and get the data as a vector layer Raster == * Define 1 raster layer properties : set style from optionnal QML, set the layer CRS, refresh contrast enhancement and save properties as default style * Define multiple raster layers properties : the same as above for more than one raster layer String === * Read file content into string : Read a text file and output a string with the file content (usefull to run some queries) Another of my script is already in Processing Example script and allows to search and replace values by another . This could be handy with the one above to run parametric queries. Vector * Define 1 vector layer properties : select and apply a QML (optional), set layer CRS, create spatial index, recalculate extent, set title and abstract, save properties as default style - all in once. * Define multiple vector layers properties : same as above but for multiple vector layers (without title and abstract inputs) * Save features filtered by expression : Choose a vector layer, use and expression to save the matching features as a new vector layer * Select vector features by expression : Use an expression to select the vector layer matching features * Square grid from layer extent : choose a vector layer and a grid cell size and outputs a vector grid. All the scripts are on Github ( GPL2 licence). https://github.com/3liz/QgisProcessingScripts I documented each script with the Processing help feature. Any feedback welcome ! Cheers Michael ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Share some of my Processing Scripts
Thanks for sharing them, it would be nice if there was something similar to plugins to install processing scripts -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Share-some-of-my-Processing-Scripts-tp5143276p5143280.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
Re: [Qgis-user] Problem to download data from OpenStreetMap
Dear Sir/Madam, As per QGIS 2.2 user guide, I can download data from Opensteetmap when connecting with OSM server, how could I connect with the server?. Would you please give me a hand? Regards Caroline ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Share some of my Processing Scripts
Il 30/05/2014 16:37, AntonioLocandro ha scritto: Thanks for sharing them, it would be nice if there was something similar to plugins to install processing scripts agreed, a long standing idea, nedds some code writing though. anyone interested? all the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Share some of my Processing Scripts
maybe a github repository is more practical and easier to setup On Fri, May 30, 2014 at 11:58 AM, Paolo Cavallini cavall...@faunalia.it wrote: Il 30/05/2014 16:37, AntonioLocandro ha scritto: Thanks for sharing them, it would be nice if there was something similar to plugins to install processing scripts agreed, a long standing idea, nedds some code writing though. anyone interested? all the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ 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] Problem to download data from OpenStreetMap
Have you clicked on Vector - Openstreetmap - Download data? 2014-05-30 17:07 GMT+02:00 Caroline Kwan cpmk...@yahoo.com.hk: I don't have the promt to define the area and am rejected to do it? Since this is my first time to download data from Openstreetmap. would you please give me a detailed procedure to follow? Caroline 2014年5月30日 星期五,G. Allegri gioha...@gmail.com 寫道﹕ 主題: Re: [Qgis-user] Problem to download data from OpenStreetMap 收件人: Caroline Kwan cpmk...@yahoo.com.hk 日期: 2014年5月30日,星期五,下午10:50 What do you mean connecting to the server? When you open Vector - Openstreetmap - Download data you're prompted to define the area you want to download data for, it will connect to the server, and it will start fetching the data. giovanni 2014-05-30 16:47 GMT+02:00 Caroline Kwan cpmk...@yahoo.com.hk: Dear Sir/Madam, As per QGIS 2.2 user guide, I can download data from Opensteetmap when connecting with OSM server, how could I connect with the server?. Would you please give me a hand? Regards Caroline ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Giovanni Allegri http://about.me/giovanniallegriTwitter: https://twitter.com/_giohappy_ blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus -- Giovanni Allegri http://about.me/giovanniallegri Twitter: https://twitter.com/_giohappy_ blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Categorised Styling of PostGIS layers
I have tested myself and I can confirm this behavior with char(x) values. If the classifier identify 3 different classes, but the renderer does not draw them. I think this might be classified as a bug. Maybe you should fill a bug report, with all the steps to reproduce the error. Also, maybe a SQL to create and populate a table to help developers reproduce the problem. Best regards, Alexandre Neto Best regards, Alexandre Neto On Fri, May 30, 2014 at 1:21 PM, McDonaldR mcdona...@angus.gov.uk wrote: No spaces in the fields or table name – all lowercase and underscores. Yeah, the rules work if I use trim(“prob”) or prob like ‘H%’ I would have thought that the display by category would have worked on the strings in the field even if the values were made up of a lot of space characters. Ross *From:* Alexandre Neto [mailto:senhor.n...@gmail.com] *Sent:* 30 May 2014 12:58 *To:* McDonaldR *Cc:* Brent Wood; QGIS User *Subject:* Re: [Qgis-user] Categorised Styling of PostGIS layers That sounds still strange. Do you have space characters on your fields? I would definitely remove them. Either way, in Rule based symbology, you could use a rule like this: prob like 'H%' Alexandre Neto On Fri, May 30, 2014 at 12:47 PM, McDonaldR mcdona...@angus.gov.uk wrote: Hi Alexandre, Brent Thanks for the pointers. Rules based renderer failed but it work on the same data in different format. Going back to the source data (ESRI FGDB) and checking PostGIS I noticed the prob field was set to char(50). I reloaded the data with the field as varchar(50) and it now renders correctly although I still get the extra category added – presumably to catch blank records. With the data as char(50) categorisation works if I set the field with an expression like, TRIM(“prob”), as it then strips of the 49 blank spaces after the H. Varchar is better though as the table is smaller. Many thanks Ross *From:* Alexandre Neto [mailto:senhor.n...@gmail.com] *Sent:* 30 May 2014 12:01 *To:* McDonaldR *Cc:* QGIS User *Subject:* Re: [Qgis-user] Categorised Styling of PostGIS layers Somehow QGIS is not finding any of those 3 values in the features in that extent. Can you select a few visible (pink) features and check their probability field values? Are you sure that all you features have valid values in the prob column? Try build that same stack of symbols using rule-based symbology. And see if it works. You can also try save a few features in other format, say a shapefile, open it and copy the style. See if it works there (I doubt). Not having access to the data, is quite difficult to understand what can be wrong, if you can provide a sample data, I can give a look into it. Alexandre Neto On Fri, May 30, 2014 at 11:35 AM, McDonaldR mcdona...@angus.gov.uk wrote: Morning all, I'm trying to style some flooding probability data. It's in PostGIS and I'm using QGIS master (same issue in 2.0 and 2.2 though). My polygon layer has a probability field with values H, M and L. If I select a categorised style using the probability field I get the expected three values. And an extra one. And the data is drawn using the style of the extra category - in the screenshot the pink lines and not the blues as expected. If I delete the extra category from the classification table then nothing is drawn on the canvas. I have checked the field and there are only three unique values in it without nulls or blanks. The table is properly indexed with a primary key and GIST spatial index. So, is it a QGIS style engine problem or a PostGIS data problem? I should add that the same data from PostGIS draws perfectly in ArcGIS 10.2.2 and is styled as expected. Anyone else had similar experiences? [If the screenshot is scrubbed by the list then you can see it here: http://openphoto.mixedbredie.net/photo/96/view] *Ross McDonald *| GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT T: *01307 476419* | F: 01307 476401 | E: mcdona...@angus.gov.uk | W: *Angus Maps http://www.angus.gov.uk/maps/map_home.cfm* This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment. ___ Qgis-user mailing list
Re: [Qgis-user] Categorised Styling of PostGIS layers
Filed as a bug: https://hub.qgis.org/issues/10401 Ross From: Alexandre Neto [mailto:senhor.n...@gmail.com] Sent: 30 May 2014 16:21 To: McDonaldR Cc: Brent Wood; QGIS User Subject: Re: [Qgis-user] Categorised Styling of PostGIS layers I have tested myself and I can confirm this behavior with char(x) values. If the classifier identify 3 different classes, but the renderer does not draw them. I think this might be classified as a bug. Maybe you should fill a bug report, with all the steps to reproduce the error. Also, maybe a SQL to create and populate a table to help developers reproduce the problem. Best regards, Alexandre Neto Best regards, Alexandre Neto On Fri, May 30, 2014 at 1:21 PM, McDonaldR mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk wrote: No spaces in the fields or table name – all lowercase and underscores. Yeah, the rules work if I use trim(“prob”) or prob like ‘H%’ I would have thought that the display by category would have worked on the strings in the field even if the values were made up of a lot of space characters. Ross From: Alexandre Neto [mailto:senhor.n...@gmail.commailto:senhor.n...@gmail.com] Sent: 30 May 2014 12:58 To: McDonaldR Cc: Brent Wood; QGIS User Subject: Re: [Qgis-user] Categorised Styling of PostGIS layers That sounds still strange. Do you have space characters on your fields? I would definitely remove them. Either way, in Rule based symbology, you could use a rule like this: prob like 'H%' Alexandre Neto On Fri, May 30, 2014 at 12:47 PM, McDonaldR mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk wrote: Hi Alexandre, Brent Thanks for the pointers. Rules based renderer failed but it work on the same data in different format. Going back to the source data (ESRI FGDB) and checking PostGIS I noticed the prob field was set to char(50). I reloaded the data with the field as varchar(50) and it now renders correctly although I still get the extra category added – presumably to catch blank records. With the data as char(50) categorisation works if I set the field with an expression like, TRIM(“prob”), as it then strips of the 49 blank spaces after the H. Varchar is better though as the table is smaller. Many thanks Ross From: Alexandre Neto [mailto:senhor.n...@gmail.commailto:senhor.n...@gmail.com] Sent: 30 May 2014 12:01 To: McDonaldR Cc: QGIS User Subject: Re: [Qgis-user] Categorised Styling of PostGIS layers Somehow QGIS is not finding any of those 3 values in the features in that extent. Can you select a few visible (pink) features and check their probability field values? Are you sure that all you features have valid values in the prob column? Try build that same stack of symbols using rule-based symbology. And see if it works. You can also try save a few features in other format, say a shapefile, open it and copy the style. See if it works there (I doubt). Not having access to the data, is quite difficult to understand what can be wrong, if you can provide a sample data, I can give a look into it. Alexandre Neto On Fri, May 30, 2014 at 11:35 AM, McDonaldR mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk wrote: Morning all, I'm trying to style some flooding probability data. It's in PostGIS and I'm using QGIS master (same issue in 2.0 and 2.2 though). My polygon layer has a probability field with values H, M and L. If I select a categorised style using the probability field I get the expected three values. And an extra one. And the data is drawn using the style of the extra category - in the screenshot the pink lines and not the blues as expected. If I delete the extra category from the classification table then nothing is drawn on the canvas. I have checked the field and there are only three unique values in it without nulls or blanks. The table is properly indexed with a primary key and GIST spatial index. So, is it a QGIS style engine problem or a PostGIS data problem? I should add that the same data from PostGIS draws perfectly in ArcGIS 10.2.2 and is styled as expected. Anyone else had similar experiences? [If the screenshot is scrubbed by the list then you can see it here: http://openphoto.mixedbredie.net/photo/96/view] Ross McDonald | GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT T: 01307 476419 | F: 01307 476401 | E: mcdona...@angus.gov.ukmailto:mcdona...@angus.gov.uk | W: Angus Mapshttp://www.angus.gov.uk/maps/map_home.cfm This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing
Re: [Qgis-user] Share some of my Processing Scripts
Awesome work, thanks a lot Michael! The github repo idea sounds rather feasible. We can have one under the QGIS organization and people can make pull requests against it to add new scripts and models. We can add a commit hook to the git repo that builds a file with a list of available scripts/models, their description and their version numbers, whenever changes are made. Through the GitHub API it is easy to fetch that file and then let the user download the script/model files that he wants. There is a limit of 60 requests per hour in the API, but that should not be a problem If no one volunteers for this, I will try to spend sometime and implement it. Cheers p.s. Michael, you might prefer to use the progress.setInfo(text) method instead of progress.setText(text) method for communicating with the user. It will add text into the log window. Also, there is no need to set the text if later you are raising an exception. If you throw a GeoAlgorithmExecutionException, Processing will handle it and let the user know that the script failed and print the exception message in the dialog. It's a better mechanism, since it will also work when calling the script from the python console, where the exception message will be printed out to the console itself. 2014-05-30 17:04 GMT+02:00 Etienne Tourigny etourigny@gmail.com: maybe a github repository is more practical and easier to setup On Fri, May 30, 2014 at 11:58 AM, Paolo Cavallini cavall...@faunalia.it wrote: Il 30/05/2014 16:37, AntonioLocandro ha scritto: Thanks for sharing them, it would be nice if there was something similar to plugins to install processing scripts agreed, a long standing idea, nedds some code writing though. anyone interested? all the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem to download data from OpenStreetMap
On Fri, May 30, 2014 at 7:47 AM, Caroline Kwan cpmk...@yahoo.com.hk wrote: As per QGIS 2.2 user guide, I can download data from Opensteetmap when connecting with OSM server, how could I connect with the server?. Would you please give me a hand? I've been using QGIS for the past couple of years so not much of an expert. To download from the OSM server, you just need select a bounding box of suitable size for downloading. OSM won't allow downloading an entire country. But you can download portion of a city. To download an area, from the OpenLayers plugin, add an OSM layer. Zoom into the area needed. Then from the Vectors menu, select OpenStreetMap-download data. From looking at the resulting .osm file, QGIS is using the overpass api to download the data. You can read more about overpass on the OSM wiki at https://wiki.openstreetmap.org/wiki/Overpass_API. Note, I usually use overpass-turbo.eu to grab data. Not sure I answered your question. Write back with more details and I'll attempt to do better. Clifford -- @osm_seattle osm_seattle.snowandsnow.us OpenStreetMap: Maps with a human touch ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problem zooming in on ECW files in QGIS
I had the same issue. Unfortunately I did not find a way to solve it, however, I am doing a workaround by converting the ecw-files into JPEGs using gdal_translate (in QGIS this would be under Raster Conversion translate). The JPEGs will have the same size as the ecw's and you get rid of that zoom-problem and many other issues caused by ECW. On 05/31/2014 03:41 AM, CornGiS [via OSGeo.org] wrote: I opened a 490mb ecw image in QGIS on my mac (using the ecw 1.10.1 GDAL-ECW plug-in 5.1.1. ERDAS Image Compression SDK read-only for desktop). The ecw is loaded in less than a second, but it seems that QGIS does not manage to completely uncompress the ecw file, as zooming in results in a blurry picture. If I open the ecw file using IrfanView I can zoom in without any problem and get a decent picture.. Did anybody have a similiar experience? Does anybody know how to fix this problem? Any help is appreciated, thank you! If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/Problem-zooming-in-on-ECW-files-in-QGIS-tp5143348.html To unsubscribe from Quantum GIS - User, click here http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4125267code=c3RlZmFuc3lsbGFAZ214LmRlfDQxMjUyNjd8LTExNTE4ODczMTc=. NAML http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-zooming-in-on-ECW-files-in-QGIS-tp5143348p5143370.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