Re: [Qgis-user] editing and saving very large table

2024-03-12 Thread Gordon Wakelin-King via QGIS-User
Surely this is something that can be done easily with an SQL Select with Order-by, in one of the SQL variants that QGIS can use? I’m asking for my own benefit too. Having come from the MapInfo environment I would reach for an SQL Select to do this task, but I’m less familiar with SQL in QGIS.

Re: [Qgis-user] editing and saving very large table

2024-03-12 Thread chris hermansen via QGIS-User
Michael and list, On Tue, Mar 12, 2024 at 11:48 AM Michael.Dodd wrote: > In this particular instance the data are not spatial data, at this stage > at least. There is no link to location. > > > > The data does have a hierarchy according to several columns, by sorting I > can put the data into a

Re: [Qgis-user] editing and saving very large table

2024-03-12 Thread Michael.Dodd via QGIS-User
In this particular instance the data are not spatial data, at this stage at least. There is no link to location. The data does have a hierarchy according to several columns, by sorting I can put the data into a suitable order for editing in further information into an extra column. Without

Re: [Qgis-user] editing and saving very large table

2024-03-12 Thread chris hermansen via QGIS-User
Michael and list, On Tue, Mar 12, 2024 at 5:31 AM Michael.Dodd via QGIS-User < qgis-user@lists.osgeo.org> wrote: > Thanks, can you suggest how as the refactor fields help is not clear, to > say the least, about saving after sorting. > > I sorted the data (5 million rows) by a couple of the

Re: [Qgis-user] editing and saving very large table

2024-03-12 Thread Michael.Dodd via QGIS-User
Thanks, can you suggest how as the refactor fields help is not clear, to say the least, about saving after sorting. I sorted the data (5 million rows) by a couple of the columns, just by clicking on them, then wanted to save in the new order but this 'save in the new order' seems impossible.

Re: [Qgis-user] editing and saving very large table

2024-03-12 Thread Frederik-Matti Bartels (CAPSA) via QGIS-User
Hello Michael, How did you sort the columns? If you have ordered them in the QGIS attribute table, they will not change their order when you export them. For this, you must use the "Refactor Fields" tool. Cheers, Matti -Ursprüngliche Nachricht- Von: QGIS-User Im Auftrag von

Re: [Qgis-user] question abot shapes

2024-03-12 Thread Sylvain Ard via QGIS-User
Good morning, I have a PostgreSQL database of several million points with latitude/longitude and I would like to do the following with qgis-server or PostGis: according to a number of shapes (hexagons, circles or squares) per mesh, calculate the number of points per shape and color the shape

Re: [Qgis-user] question abot shapes

2024-03-12 Thread Régis Haubourg via QGIS-User
What is your question Sylvain? This is unclear Regards On 08/03/2024 17:15, Sylvain Ard via QGIS-User wrote: Good morning, I have a PostgreSQL database of several million points with latitude/longitude and I would like to do the following with qgis-server or PostGis: according to a number