[Qgis-user] using embedded symbols from pdf in field calculator

2023-10-31 Per discussione damien stephens via QGIS-User
Hi all. thanks in advance for your assistance. I have a georef vector pdf which is the only source of some polygon and line data I can find. When brought into QGIS the embedded symbology works as expected - polygons fills look correct etc. I can use the info tool and view the derived field

Re: [Qgis-user] setting graduated symbology for a small postgres point table crashing qgis.

2023-10-11 Per discussione damien stephens via QGIS-User
Thanks Andreas done. #54921 On Wed, Oct 11, 2023 at 4:59 PM Andreas Neumann wrote: > Hi Damien, > > Can you submit a bug report please? > > NULL values in the data shouldn't make QGIS freeze. > > Thanks, > Andreas > > On Wed, 11 Oct 2023 at 10:51, damien stephe

Re: [Qgis-user] setting graduated symbology for a small postgres point table crashing qgis.

2023-10-11 Per discussione damien stephens via QGIS-User
never mind I figured it out. the graduated engine does not like null values in the field, so i used a calulated field: case when field is null then .001 else field end On Wed, Oct 11, 2023 at 4:41 PM damien stephens wrote: > Hi All. > I have a point table view with around 50,000 records a

[Qgis-user] setting graduated symbology for a small postgres point table crashing qgis.

2023-10-11 Per discussione damien stephens via QGIS-User
Hi All. I have a point table view with around 50,000 records and 160 fields in postgres which loads into qgis very quickly. the problem comes when i try to assign a graduated symbology. no matter which Mode i use - fixed interval, jenks etc, when i hit the classify button qgis freezes - and had

Re: [Qgis-user] MSsql odbc connected gespatial view not loading in qgis 3.28

2023-02-13 Per discussione damien stephens via QGIS-User
, cheers Damien On Tue, Feb 14, 2023 at 10:55 AM damien stephens wrote: > Hi All; > I am having trouble bringing a geospatial sql view into qgis using the > add mssql server layer dialogue. > > I have a geospatial view that was created from two tables in a separate > database

[Qgis-user] MSsql odbc connected gespatial view not loading in qgis 3.28

2023-02-13 Per discussione damien stephens via QGIS-User
Hi All; I am having trouble bringing a geospatial sql view into qgis using the add mssql server layer dialogue. I have a geospatial view that was created from two tables in a separate database. One of the two tables has a geospatial field. This table can be brought into qgis without issues

Re: [Qgis-user] georeference plugin not working

2019-05-02 Per discussione damien stephens
Could this be a change in QGIS 3.6? > > https://qgis.org/en/site/forusers/visualchangelog36/index.html#feature-new-option-to-avoid-minimizing-georeferencer-when-adding-points > > Le 30 avr. 2019 à 21:16, damien stephens a > écrit : > > Hi. > I am on qgis 3.6. > I have been using t

Re: [Qgis-user] Dereference plugin not working

2019-05-02 Per discussione damien stephens
; Le mer. 1 mai 2019 à 04:43, Nicolas Cadieux > a écrit : > >> Hi, >> Could this be a change in QGIS 3.6? >> >> https://qgis.org/en/site/forusers/visualchangelog36/index.html#feature-new-option-to-avoid-minimizing-georeferencer-when-adding-points >> >> Le 30

[Qgis-user] Dereference plugin not working

2019-04-30 Per discussione damien stephens
Hi. I am on qgis 3.6. I have been using the referencing plugin for a while with no dramas, but now when I click on the tool button in the raster menu, qgis loses focus, but the georeferencer window does not appear. Have Googled an answer but they are all for qgis v2 and the registry keys they

Re: [Qgis-user] How to merge layers without a work-around?

2017-03-09 Per discussione damien stephens
I would copy one and paste as a new layer eg shapefile, then select the next set of data and page to my new shape file. Not scratch layers, but it works. Cheers On Fri, 10 Mar 2017, 04:33 Tobias Wendorff wrote: > Hi there. > > Is there any way to merge two

Re: [Qgis-user] Problem with Using Google maps -Showing the points not exactly after exporting as a pdf or png

2016-11-17 Per discussione damien stephens
don't use the open layers plugin, use the quickmapservices one instead. then hit the get contributed pack. there are lots of different satellite images in there as well as plenty fo topographic style map options, and they all print properly. On Wed, Nov 16, 2016 at 9:16 PM, Nicolas Cadieux <

Re: [Qgis-user] Geological Legends

2016-11-17 Per discussione damien stephens
not so simple, If you use the colour function to set the symbol colours using data defined styles, then use the categorised fields to get the text labels for the symbols, the wrong colours show up on the legend, although they are fine on the map. if you just use a single symbol with the data

Re: [Qgis-user] MapInfo Attribures

2016-08-03 Per discussione damien stephens
If you have MapInfo wth discover, you can save the colour scheme for each polygon as a new column in the tab file, then use that to colourise it via the properties, styles menu in qgis. Failing that if you have a screen grab of the map/tab file you can categorise the features in qgis by one of

Re: [Qgis-user] Query on Expressions

2016-08-01 Per discussione damien stephens
h extending beyond the page size, hence i looked out for the > wordwrap option. So i need both record filter and column wordwrap to work > together. > > Hope its clear why i need to do this. I would be glad if you can suggest > any alternate ways to resolve this. Thankyou > >

Re: [Qgis-user] Mssql offline table with sync

2016-07-30 Per discussione damien stephens
Agreed that would work, but it is just moving the synchronisation problem upstream so that it now sits between my local SQL server and the main one that every one works from. I am thinking of trying to put together a Python program that will grab all of the SQL requirements, download the table

Re: [Qgis-user] Mssql offline table with sync

2016-07-29 Per discussione damien stephens
Hi Goyo.. Thanks for your response. I don't believe the offline editing plugin will copy my mssql table? Either way, the idea is not to edit the database offline, just being able to view the data offline is the goal, then when coming back to a connection, getting the latest copy of the database

Re: [Qgis-user] Label Formatting - Wrap on character with "wordwrap"

2016-06-08 Per discussione damien stephens
t;,length("name")-15) end Hi Damien, thanks for the feedback. Unfortunately, your suggestion does not work. I have already tried many variants, but I had no success. Burghardt Von: damien stephens [mailto:damien.steph...@gmail.com] Gesendet: Mittwoch, 8. Juni 2016 12:56 An: Scholle, Burgha

Re: [Qgis-user] QGIS 2.14.1 does not find internal GPSQ

2016-06-08 Per discussione damien stephens
If you have an android phone, you might be able to use it as a bluetooth gps for windows; http://androgeoid.com/2010/10/using-your-android-phone-as-a-bluetooth-gps-transmitter/ On Tue, 7 Jun 2016, 8:15 AM Laurence Béchet wrote: > Hi Eggerer, > > I personally use

Re: [Qgis-user] Label Formatting - Wrap on character with "wordwrap"

2016-06-08 Per discussione damien stephens
Try something along the lines of Case when length ("name") < 15 then "name" else wordwrap ("name",15) end I havent got my computer with me, but might be a work around. On Mon, 6 Jun 2016, 6:40 PM wrote: > Hi, > > I created a bug report for this issue:

Re: [Qgis-user] Query or export related layers

2016-06-01 Per discussione damien stephens
Hi Jonas. I think it is pretty re ent, but newer version of qgis allow this inherently. Iam using version 2.14.2 and have a shape file linked to an excel spreadsheet (using spreadsheet layers plugin to bring in the excel doc) via an id field. I can then just use the linked fields exactly the same

[Qgis-user] avl2qml.py python script

2016-05-12 Per discussione damien stephens
HI i have been trying to get the above script running for a couple of days but keep getting a lot of errors. I am new to python so don't know if it is me or the script. The aim of it is to convert argis 3 legend files to qgis files has anyone got this working, or have a workaround for

Re: [Qgis-user] QGIS- How to render a raster using a field other than Value [SEC=UNCLASSIFIED]

2015-10-29 Per discussione Damien Stephens
Fair enough. Good luck. From: Inna Nogeste [mailto:i.noge...@bom.gov.au] Sent: Friday, 30 October 2015 8:03 AM To: Damien Stephens Cc: qgis-user@lists.osgeo.org Subject: RE: QGIS- How to render a raster using a field other than Value [SEC=UNCLASSIFIED] Thanks Damien, For the purposes

Re: [Qgis-user] Copy field definitions from one vector layer to another?

2015-10-21 Per discussione Damien Stephens
You can change the prefix of the column names in 2.10 there is a tick box in the join dialog. not sure if you can set it to blank, but might work? From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Richard Males Sent: Thursday, 22 October 2015 11:17 AM To: Luca Lanteri

Re: [Qgis-user] iGIS point shapefiles - exporting back to QGIS

2015-10-18 Per discussione Damien Stephens
HI Jan. What is happening is that the coords in the shape file that you can see in the attributes table are just copies of the actual coords used to display the data. It is simple to update these coords from the underlying data. In qgis, 1. open the attribute table for your shapefile. 2. Make

Re: [Qgis-user] Job opportunity: Open Source GIS / WebGIS / Database developer at NINA, Norway - urgent

2015-10-12 Per discussione Damien Stephens
Pity I am just a humble geo would love to work in Trondheim. From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Blumentrath, Stefan Sent: Friday, 9 October 2015 9:23 PM To: Qgis-user@lists.osgeo.org Subject: [Qgis-user] Job opportunity: Open Source GIS / WebGIS / Database

[Qgis-user] python or plugin to automatically download/refresh a mssql table

2015-10-04 Per discussione Damien Stephens
HI. I use qgis in the field as well as the office and have most of my data stored in a corporate mssql database. I can link to it easily enough, but that data is then not available when I am in the field, as I do not have an internet connection. I can also setup a link and download to a table

Re: [Qgis-user] MBTiles from QGIS

2015-09-21 Per discussione Damien Stephens
Nope rasters Sent from Mobile From: Adam Sherman <a...@sherman.ca> Sent: 21 Sep 2015 10:08 pm To: Damien Stephens Cc: Bernd Vogelgesang; Phil (The Geek) Wyatt; kimaidou; qgis-user Subject: Re: [Qgis-user] MBTiles from QGIS Are you folks speaking of vector MBtiles? A. On Mon, Sep 21, 201

Re: [Qgis-user] MBTiles from QGIS

2015-09-20 Per discussione Damien Stephens
I have been using the mbtiles out of qtiles for locus gis on android and they are working fine.- this issue may have been fixed? From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Bernd Vogelgesang Sent: Sunday, 20 September 2015 6:49 PM To: Phil

Re: [Qgis-user] refresh a layer without restarting qgis.

2015-09-09 Per discussione Damien Stephens
Excellent! Thanks very much, it does exactly what it says on the tin. From: Nicola Poles [mailto:nicola.po...@gmail.com] Sent: Wednesday, 9 September 2015 1:41 PM To: Damien Stephens Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] refresh a layer without restarting qgis. Hi Damien

[Qgis-user] refresh a layer without restarting qgis.

2015-09-08 Per discussione Damien Stephens
Hi I have a .csv file which I have brought into qgis using the add_delimited_text importer. It works fine and when I brought it in I set watchfile = yes. My question is does anyone know how to trigger qgis to check the file for changes without shutting down and restarting the program? I know I

Re: [Qgis-user] .mbtiles raster conversion error

2015-09-06 Per discussione Damien Stephens
I have used the qtiles plugin to export to mbtiles format with good results. However I am using windows not mac so cant guarantee anything. Cheers Damien From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Jim Proctor Sent: Sunday, 6 September 2015

Re: [Qgis-user] Using data defined attributes to colour a shapefile gives an all black legend

2015-03-23 Per discussione Damien Stephens
No takers on this question? From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Damien Stephens Sent: Thursday, 19 March 2015 11:51 AM To: QGIS Mailing List Subject: [Qgis-user] Using data defined attributes to colour a shapefile gives an all black

[Qgis-user] Using data defined attributes to colour a shapefile gives an all black legend

2015-03-18 Per discussione Damien Stephens
HI guys. I have stored the colour information for polygons in three columns in a shapefile (Red,Green and Blue). I then used the data defined attributes in the symbol dialogue box to set the colours: [cid:image001.png@01D06239.F3FC98E0] This works a charm except that my legend for the layer

[Qgis-user] using rule based styles and ranges at once

2015-01-19 Per discussione Damien Stephens
Hi. I am trying to set up a symbol type from one field and a symbol colour range from another field. I have set up several rule based styles for a point layer. Ie for a given field (name) where the value equals George, I have set the symbol to a black square, for value = dave the symbol is a

Re: [Qgis-user] using field calculator to do a spatial update for a table using data from an overlapping geometry.

2014-10-23 Per discussione Damien Stephens
Enrico you have made my day ! - much appreciated. I will have a look at it and get back to you on how I progress. Thanks Again Damien -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of enricofer Sent: Thursday, 23 October

[Qgis-user] using field calculator to do a spatial update for a table using data from an overlapping geometry.

2014-10-22 Per discussione Damien Stephens
HI I have two tables, a point table and a polygon table. I want to be able to create a new field in the point table using data in a field in the polygon table. Basically if a point is within a poygon I would like to return the value from polygon.value as a field in the point table, but am lost

Re: [Qgis-user] Finding Points which do not overlay

2014-09-22 Per discussione Damien Stephens
My suggestion would be to create a buffer of 3m around your original points. (vector/geoprocessing/buffer That creates a new vector table. (vector Buffer) Load the new vector table is it isn’t already Then do a spatial query select source features from: new points table Where the feature: within

Re: [Qgis-user] Editing - table mask - Insert values from near features from other layer

2014-09-04 Per discussione Damien Stephens
My suggestion would be to try using the buffer tool in vector/geoprocessingtools. This automatically creates buffers around your discharge point at set distances. You could then use these to select areas within those radii and assign attributes? Cheers Damien -Original Message- From:

Re: [Qgis-user] does someone know why I cannot export maps generated with openlayers plugin?

2014-08-21 Per discussione Damien Stephens
Hi I have the same setup and am printing without issue. Can you give a bit more detail? Which open layers are you using, do you have anything else overlaying it, what grid system are you using. Will see if I can replicate. Thanks Damien -Original Message- From:

Re: [Qgis-user] Reverting to version 2.2 from 2.4

2014-08-19 Per discussione Damien Stephens
Hi if all you want is to get open layers back. Just upgrade the plugin (plugins\manage and install plugins\ select open layers plugin then upgrade. The layers move to the WEB menu from the PLUGINS menu across the top, but other than that they are identical, and I think there are improvements

Re: [Qgis-user] Velocity Difference Calculation?

2014-08-17 Per discussione Damien Stephens
Very clunky, but if you have a consecutive numerical field in your table, you could add a new field which equals old field -1, then bring the table in twice and link by old field to new field. The rest should be easy. Probably much easier in a database though. From:

Re: [Qgis-user] print composer

2014-08-17 Per discussione Damien Stephens
Actually I still have issues with google maps, although it go better with the latest release when printing I still have the same issue. From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Jeff Partain Sent: Monday, 18 August 2014 8:44 AM To: Nyall

Re: [Qgis-user] print composer

2014-08-17 Per discussione Damien Stephens
Hi Daniel. I assume you are using the open layers plugin. If so set your map canvas to exactly the same size as the page size. This works for me. You do this under item properties/position and size. The attached image is the setup for A1: [cid:image001.png@01CFBABB.561BD8F0] From: