Re: [Qgis-user] Record the cracks in our (private) streets

2019-12-16 Thread Charlotte Toma
Hi Doug, you can create photogrammetric export models (e.g. DEM, point cloud) with the open source software OpenDroneMap. Try WebODM [1] with the graphical user interface - you can install it with docker. The DEM is perfect for QGIS, you can create a 3D view of your Street with the 3d map vie

[Qgis-user] Plugin QGIS asistente consultas POSTGIS SQL

2019-12-16 Thread Alejandro Chamizo de Castro
Hola compañer@s, estoy buscando algún plugin en QGIS o complemento de POSTGIS, que hagas las funciones de asistente en la construcción de consultas SQL. Una herramienta que ayude a los dummies en SQL. He encontrado PostGIS Query Builder, en principio perfecto, pero por lo que puedo ver, con muy

Re: [Qgis-user] Record the cracks in our (private) streets

2019-12-16 Thread Christoph Jung
Hi Doug, This makes it a lot easier, the others mentioned good possibilities to find the cracks. Concerning your question of segmentation of the roadbed: You could create a regular grid and count, measure or what else the cracks within the grid cells/polygons. A comparison based on this grid w

[Qgis-user] Rule Based Symbology with aggregate Function

2019-12-16 Thread Jürg Lindauer
Hi I'm trying to create a rule based symbology with "id_alpperimeter" IN (aggregate( layer:='alpperimeter20190607152251688', aggregate:='concatenate', expression:= "pk" , filter:=selected = '1', concatenator:=concat( char(39), char(44), char(39 But there are no results in there. The rule

Re: [Qgis-user] Rule Based Symbology with aggregate Function

2019-12-16 Thread Stefan Giese
Hi Jurg, you need to make an array first, your statement should be: "id_alpperimeter" IN string_to_array((aggregate( layer:='alpperimeter20190607152251688', aggregate:='concatenate', expression:= "pk" , filter:=selected = '1', concatenator:=concat( char(39), char(44), char(39) Mit freun

Re: [Qgis-user] vector layer only displays when zoomed out to layer extent

2019-12-16 Thread Lee Eddington
Hi Nicolas, Vector densification worked. I went with the default 1 vertices to add and it created a new layer that now displays at any zoom level. Can you explain why my original layer doesn’t display? Thanks, Lee > On Dec 14, 2019, at 3:13 PM, Nicolas Cadieux > wrote: > > Hi, > > Try m

Re: [Qgis-user] Rule Based Symbology with aggregate Function

2019-12-16 Thread Jürg Lindauer
Hi Stefan The IN operator didn't like arrays. But i've found the solution. array_contains( string_to_array( aggregate( layer:='alpperimeter20190607152251688', aggregate:='concatenate', expression:= pk , filter:=selected = '1', concatenator:=char(44))), attribute( $currentfeature , 'id_alpperi

Re: [Qgis-user] vector layer only displays when zoomed out to layer extent

2019-12-16 Thread Nicolas Cadieux
Hi, If you have a very long straight line represented by only two point, reprojection operates only on those two points (called vertices or nodes). The lines just represent a straight connections between two point. The problem is that the earth is round (contrary to some popular belief :) and

Re: [Qgis-user] Plugin QGIS asistente consultas POSTGIS SQL

2019-12-16 Thread Nicolas Cadieux
Translation, He is looking for a SQL GUI query builder plugin for POSTGIS. Do you know a plugin? Nicolas > Le 16 déc. 2019 à 05:09, Alejandro Chamizo de Castro a > écrit : > >  > Hola compañer@s, > > > estoy buscando algún plugin en QGIS o complemento de POSTGIS, que hagas las > funciones

Re: [Qgis-user] Working with DEMs

2019-12-16 Thread Nicolas Cadieux
Hi, I agree Falk that DEMs made from contour lines have their problems (stepped slopes, flat areas, elevation drops in lakes...).  Depending on the input data, they can still be a very accurate model for elevation.  I tested the SRTM, NASADEMs, Alos, ASTER and the CDED (Canadian Digital Eleva

Re: [Qgis-user] Working with DEMs

2019-12-16 Thread Falk Huettmann
Hi there, thanks, just to elaborate, for those who are interested: (I would like to see the study that has compared those DEM products; it matters a lot for climate models, for instance; happy to read the citations). Getting precise DEMs remains a massive struggle, regardless of what people, gov

Re: [Qgis-user] Working with DEMs

2019-12-16 Thread Håvard Tveite
Hi Dave, When "Use Z-coordinate for interpolation" is checked, it must be assumed that the Z coordinate will be used *instead* of the value in the "Elevation" attribute. But it is strange that this should cause the Exception / error you experience. The TIN Interpolator seems to works fine here (

Re: [Qgis-user] Working with DEMs

2019-12-16 Thread Nicolas Cadieux
Hi On 2019-12-16 5:36 p.m., Falk Huettmann wrote: Hi there, thanks, just to elaborate, for those who are interested: (I would like to see the study that has compared those DEM products; it matters a lot for climate models, for instance; happy to read the citations). You will find many on web

Re: [Qgis-user] Imported Line Symbol Problem

2019-12-16 Thread Dave Gardiner
Hi Jorge Here is an extract form one of the source xls files. Embedded in here is a reference to a svg symbol, in this case "geology/arrows_sinistral.svg". I have located this file along with other associated svg files but where is QGIS expecting to see these files. What is the root directory for

Re: [Qgis-user] vector layer only displays when zoomed out to layer extent

2019-12-16 Thread Lee Eddington
I’m not sure that’s the reason as I have plenty of points in my lines. Also, I saved the densified layer to disk, but the saved layer has the same display problem as the original layer. Lee > On Dec 16, 2019, at 8:35 AM, Nicolas Cadieux > wrote: > > Hi, > > If you have a very long straigh

Re: [Qgis-user] vector layer only displays when zoomed out to layer extent

2019-12-16 Thread Nicolas Cadieux
Hi, When you cross 360 degrees, some projections have difficulty dealing with that. Try not crossing that or try splitting the shapes that cross it. Nicolas > Le 16 déc. 2019 à 22:32, Lee Eddington a écrit : > > I’m not sure that’s the reason as I have plenty of points in my lines. > Also,

Re: [Qgis-user] vector layer only displays when zoomed out to layer extent

2019-12-16 Thread Nyall Dawson
On Sun, 15 Dec 2019 at 07:38, Lee Eddington wrote: > > I have a vector layer of lines that span -360 to 360 deg. They display fine > when I’m zoomed out full, but if I zoom in to any degree they disappear. > > I’m using 3.4.14 on a Mac. It's likely a corrupt spatial index on the file. Try remov

Re: [Qgis-user] Imported Line Symbol Problem

2019-12-16 Thread Andreas Neumann
Hi Dave, You would create a folder anywhere in your file system (preferably not on a slow partition), copy the necessary SVG files in there and then create a configuration in "Settings" --> "Options" --> "SVG paths" --> "add a new entry (green plus)" with a path to the folder you created in the

[Qgis-user] Rotated pole coordinate system - how to transform CORDEX

2019-12-16 Thread Kamil Drejer
Hi, It is my first message on mailing list, so I am sorry if I am writing something wrong. I am looking for some solution, but without any result. I downloaded climatological data from the CORDEX framework (using Copernicus services). The data is in rotated pole coordinate system. I found on GIS