[Qgis-user] Editing Joined Tables

[Nicolas Cadieux]

I have not followed this closely but see below.

>> Le 28 oct. 2020 à 04:40, Springfield Harrison <stellargps at gmail.com> a écrit :
> 
> Hello Charles & Sebastian,
> 
> Thanks very much for your suggestions.  I did try the Geopackage but it seems much less convenient for my needs than shapefiles or CSV files.
> 
I thing you said you had over a million tree?  Shapefile will be very slow even if you create a spatial index. You would be better using a geopackage.  What make geopackage less convenient?  Do you have a work flow that can only produce a csv and a shapefile?
>   I didn't try the xlsx option as I require a CSV table as the primary table in the join (to import UTM coordinates). 
> 
With over a million object, you will go over the xlsx max limit.  
> Other spreadsheet formats do not trigger the X/Y georeferencing options found in the delimited text file type.
> 
Csv table is a convenient way manually adding coordinates but if all you need is to have access to the x/y georefencing options, you can do that with any filed in any vector file by updating the geometry from a field using the field calculator. Using something like geom_from_wkt('POINT('||"x"||' '||"y"||')').  

https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields

> I need to frequently add UTM positions to the primary table plus make manual edits to it so it needs to be a shapefile.  However, with care, I can copy and paste new UTM records from a CSV file into the primary shapefile.
> 

> Anyway, thanks again, your suggestions helped me along . . . . .
> 
> -----
> Cheers, Springfield 
> 
> 
> 
> On 10/27/20 09:14, Sebastian Gutwein wrote:
>> I have found that CSV layers are not editable but .xlsx layers are. I just tried editing a joined field in 2 .xslx layers and it worked if I have upsert on edit checked. QGIS 3.14.16
>> 
>> On Tue, Oct 27, 2020 at 5:02 AM Charles Dixon-Paver <charles at kartoza.com> wrote:
>>> As far as I'm aware you cannot edit external flat file tables like csv as they are imported into a QGIS project in a read only state. 
>>> 
>>> I would try exporting those tables to a database table (like a geopackage table without geometry) and then performing the join to see if you get the desired result.
>>> 
>>> On Tue, 27 Oct 2020 at 10:03, Springfield Harrison <stellargps at gmail.com> wrote:
>>>> Hello All:
>>>> 
>>>> Using version 3.10.10, I have joined two MS Excel files: Positions.csv 
>>>> and catalogue.xls using a common field called Tag. This is a tree 
>>>> inventory project.
>>>> 
>>>> All is well except I cannot edit either table from within QGIS. I need 
>>>> to create some new positions manually and generally update the tables 
>>>> continuously.
>>>> 
>>>> In the Join dialogue, I have selected Enable Editing but it has no effect.
>>>> 
>>>> I feel that different file types or a different procedure may facilitate 
>>>> this process but am exhausted from trying so many blind alleys.
>>>> 
>>>> Is there a trick to being able to edit joined tables?
>>>> 
>>>> Thanks very much . . . .
>>>> 
>>>> -----
>>>> Cheers, Springfield Harrison, British Columbia
>>>> 
>>>> 
>>>> _______________________________________________
>>>> Qgis-user mailing list
>>>> Qgis-user at lists.osgeo.org
>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20201028/1b1c13a2/attachment.html>