ST_LineMerge(st_collect(wkb_geometry)) as wkb_geometry, name
from road_segments group by name;
--
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org
dialog box that lists the columns in the view and
explains why each is unsuitable.
What am I doing wrong?
Thanks,
Rich
[1]
http://gis.stackexchange.com/questions/12233/in-postgis-is-it-possible-to-create-a-view-with-a-unique-id
--
Richard Greenwood
richard.greenw...@gmail.com
* FOSS Consulting Services
Skype: timlinux
Irc: timlinux on #qgis at freenode.net
==
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
--
Richard
Sure. Use the Expression builder. You get to it by press the ∑ button to
the righ of the value drop down list. Then enter the fields in double
quotes concatenated with +, for example:
"Town" + "Date"
If you need a space or other text, enclose it in single quotes. For example:
"Town" + '
On Wed, Jul 28, 2021 at 2:08 PM C Hamilton wrote:
> Thanks everyone for that explanation. This does complicate the ability to
> set an expression filter in a plugin when it depends on the data source
> type. I'm not sure what to do about that.
>
Convert both arguments to upper (or lower) case:
Posting again without screenshot, which apparently caused my previous email
to await moderator approval.
Mats,
I fired up a new Ubuntu 20.04 instance on AWS and did the following 5 steps
which got me an XML capabilities document.
# standard practice when starting a new instance
sudo apt update
On Sat, Oct 2, 2021 at 10:02 AM Mats Elfström
wrote:
> Hi!
> Let me just recuperate that the goal for QGIS server is to be used as a
> map and data server for webmaps on MapStore and to be harvestable by
> Geonetwork for a metadata catalogue. MapStore and Geonetwork are running on
> another
I don't think that it's fair to suggest that QGIS Server isn't ready for
prime time based on one user's difficulty with getting it set up. I am
relatively new to QGIS and QGIS Server but I found the setup pretty
straight forward and familiar, probably because I have used CGI, FastCGI
and MapServer
On Mon, Oct 4, 2021 at 3:58 AM Mats Elfström
wrote:
> Hi Richard!
> I should have mentioned that. The request you suggest gives a Not Found
> response.
>
In a default configuration, the files in /cgi-bin/ would be available to
all of the hosts on your server, but there are more than one places
g = (450-m) - int((450-m) / 360) * 360
where m = mathematical angle (0 east, anti-clockwise)
and g = geographic angle (0 north, clockwise)
On Mon, Dec 6, 2021 at 11:02 AM wrote:
> Dear colleagues on the QGIS user list,
>
> have an urgent problem with the representation of arrows with a data
>
Any AutoCAD drawing *can* be on real world coordinates. They're often not
because no real world coordinates were readily available for the project
and there wasn't a compelling need for real world coordinates. AutoCAD
Map3D and subsequent versions with different names like "Civil 3D" have
support
Is it possible for a user to add a format to the new bearing tool in 3.22?
Cadastral descriptions in the United States are usually expressed in
degrees, minutes, seconds in four quadrants e.g.
N 45°27'18"W or S 15°07'54"E, etc.
I have a SQL expression below that I use for labeling in that
>
> Regards,
> Harrissou
>
> Le jeu. 28 oct. 2021 à 19:10, Richard Greenwood <
> richard.greenw...@gmail.com> a écrit :
>
>> I'm on QGIS 3.22 from the qgis.org/ubuntu repo running on Linux Mint
>> 20.2. I didn't take any special action to get on 3.22, I just cli
I'm on QGIS 3.22 from the qgis.org/ubuntu repo running on Linux Mint 20.2.
I didn't take any special action to get on 3.22, I just clicked "Install
Updates" in the update manager. My Vector menu does not have any items in
it and I no longer have a Processing menu nor do I see an option to show
the
a setting option to display in a DMS format. Give it a try
> and let me know whether you think it would be helpful to include a DMS
> format.
>
> Thanks,
>
> Calvin
>
> On Tue, Nov 2, 2021 at 9:56 AM Richard Greenwood <
> richard.greenw...@gmail.com> wrote:
>
>&
I don't know if this is related or helpful, but GDAL 3.0 doesn't produce
MapInfo TAB files with the correct coordinate system when the coordinate
system is in feet. GDAL 3.3 and 3.4 do work.
A suggestion would be to install GDAL 3.3 or 3.4 and use
ogr2ogr -f "MapInfo file" dest source
On Wed,
I just upgraded from 3.20.0 to 3.20.1 on Linux Mint 20.1. Qgis doesn't
start, or more accurately, I don't get a GUI interface. I can see the
qgis.bin process running and using 100% of one core, so I guess it's hung.
I uninstalled, reinstalled, rebooted, same result. Suggestions?
--
Richard W.
Same here -
removing ~/.local/share/QGIS/QGIS3/profiles/default/symbology-style.db
fixes the issue.
Many thanks!
Rich
On Wed, Jul 21, 2021 at 11:47 AM Fernando M. Roxo da Motta
wrote:
> On Wed, 21 Jul 2021 13:05:14 -0400, Randal Hale
> wrote:
>
>
> > Removing the
> >
I did a quick test. I installed QGIS 3.22 on a Windows 7 computer, created
a project. Switched to Linux Mint, used the file manager to navigate to the
Windows computer, double clicked the project and it opened correctly. The
path that QGIS displays in the properties/info panel is:
Path
As Zoltan suggested, a .vrt is a good approach, but you will want overviews
also so that you can zoom out. You can create overviews (aka pyramids) of
.vrt files.
Personally, I'd suggest creating one, or a few, big GeoTIFFs with internal
or external overviews. I have a 4,400 sq mile (1,140,000
The "apt" package manager is looking for a 32 bit version of QGIS, which
doesn't exist and which you don't want. Adjust your
/etc/apt/sources.list
to look something like:
deb *[arch=amd64]* https://qgis.org/ubuntu-ltr focal main
deb-src *[arch=amd64]* https://qgis.org/ubuntu-ltr focal
Do you have the "side car" files .shx and .dbf and possibly others?
On Thu, Mar 3, 2022 at 9:31 AM David Witton wrote:
> Hello
>
> I'm pointing the Data source Manager|Vector at a .shp file and getting the
> error "Invalid Data Source". The file exists on an external drive, and the
> path is
I believe this is a bug but I'm posting here first in case I'm overlooking
something obvious. Merge Selected Features is causing QGIS 3.32.3 to crash
(close without showing errors). However the same operation on the same data
in 3.28.11 doesn't crash. I copy features from a linestring or polygon
ls
>
> 0.2.0
>
> QuickOSM
>
> 2.2.3
>
> veloroutes_voies_vertes
>
> 1.0.0
>
> tile_index_generator
>
> 1.0
>
> qgis_resource_sharing
>
> 1.0.0
>
> pluginbuilder3
>
> 3.2.1
>
> realcentroid
>
> 1.0.3
>
> gribdownloader
Is a recording of the workshop available online?
On Tue, May 10, 2022 at 2:46 AM Andreas Neumann via Qgis-user <
qgis-user@lists.osgeo.org> wrote:
> Dear QGIS users,
>
> Tomorrow, Wed. May 11, 11:00 to 12:00am MET will be our QGIS-CH mini
> workshop on QGIS construction tools instructed by Denis
On Sat, Jun 25, 2022 at 10:00 AM David Strip via Qgis-user <
qgis-user@lists.osgeo.org> wrote:
> To the extent that anyone is interested in a discussion of adding CAD-like
> dimensioning capabilities to Qgis:
>
> In a CAD model dimensional callouts present the user with information
> about
Has the raster>georeferencer menu item moved in 3.26? I can't find it in my
raster menu.
--
Richard W. Greenwood
www.greenwoodmap.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Thanks so much. I should have seen that myself!
On Thu, Jun 30, 2022 at 11:16 AM Sebastian Gutwein wrote:
> Yes - because they added vector georeferencing it is now under the Layer
> menu.
>
> On Thu, Jun 30, 2022 at 1:04 PM Richard Greenwood via Qgis-user <
> qgis-user@list
I used the Edit menu function "add Circular String" and got just what I
wanted. But how can I convert it into a regular linestring with a bunch of
vertices that approximate the curve? Specifically, I need to be able to
trace the curve with the Split Features tool and trace it when drawing a
2/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#densify-by-count
>
> The tools can be used as in-place mode, so you can select a specific
> feature are run the tools without creating a new layer.
>
>
> Alexandre Neto
> Users support
> www.qcooperative.net
>
>
t is .shp, then, they will be converted
> automatically.
>
> Nicolas Cadieux
> https://gitlab.com/njacadieux
>
> Le 14 juin 2022 à 15:28, Richard Greenwood via Qgis-user <
> qgis-user@lists.osgeo.org> a écrit :
>
>
> Perfect, just what I needed. Thanks so much.
>
You could export the shapefile and use *Layer Options > RESIZE=YES*. This
is the same as the ogr2ogr switch *-lco RESIZE=YES*, which reduces the
attribute column widths down to their minimum width required to store
the longest actual value in the data. A dbf file allocates space for the
full
There is a docker version of GDAL that supports ECW and MrSID formats:
https://hub.docker.com/r/klokantech/gdal
which you can use to convert images from those proprietary formats to an
open format. An example from my notes that converts from MrSID to GeoTIFF
and also reprojects using the docker
On Fri, Aug 5, 2022 at 1:17 PM Thayer Young via Qgis-user <
qgis-user@lists.osgeo.org> wrote:
> Hi Matt,
>
> A good strategy for finding stuff in QGIS, in addition to the
> documentation:
> There is a search bar for stuff listed in the menus at the top of the
> user interface. It is the first
I'm guessing that you are on version 21.x of Linux Mint. (You can check
your version at the command line by entering *cat /etc/issue*). At the
command line you can check that the Ubuntu QGIS repository is installed by
entering:
*cat /etc/apt/sources.list.d/qgis.list*
if you get the following
I have an old project that is painful to edit with topological editing
activated. I put a couple of the layers into a new project and topological
editing is very quick. Specifically, in the old project, moving a single
node on a polygon with the vertex tool that does not require any additional
Adam,
Thanks for your suggestions. I added the layer to the slow project and it's
still slow. The project, and the layers in it, are generally responsive and
there's no especially complex styling. The issue is only when editing,
specifically editing nodes, with topological editing enabled, on
I believe I'm seeing a regression in QGIS 3.32 in the advanced
digitizing tool. When I'm working on a layer with a coordinate system
that's in feet (and the project coordinate system is the same), distances
that I enter are being multiplied by 0.3048. e.g. I enter 1000 and it
draws a line that's
On Fri, Jul 21, 2023 at 4:26 PM Andrea Giudiceandrea via QGIS-User <
qgis-user@lists.osgeo.org> wrote:
> > Richard Greenwood richard.greenwood at gmail.com
> > Fri Jul 21 13:27:19 PDT 2023
>
> > I believe I'm seeing a regression in QGIS 3.32 in the advanced
> >
You can just use the QGIS *Move Feature* tool, possibly in conjunction with
the *Rotate Feature* and/or *Scale Feature* tools in the advanced
digitizing toolbar.
1. Assign a coordinate system to the DXF layer. If you don't know the
coordinate system, or if the DXF file doesn't have one,
The "Azimuth and Distance Plugin" might meet your needs. It accepts
bearings/azimuths from north increasing clockwise.
On Thu, May 16, 2024 at 7:50 PM Philip Ryan via QGIS-User <
qgis-user@lists.osgeo.org> wrote:
> Hello,
> I am trying to digitise a series of old gold lease "portion plans"
>
On Fri, May 17, 2024 at 6:16 AM Jeremy Jackson via QGIS-User <
qgis-user@lists.osgeo.org> wrote:
> A related question, what about grid to ground conversions and vice-versa,
> are there plugins which support this? Surveys here in Canada always
> specify a "combined scale factor", which is tedious
42 matches
Mail list logo