[Qgis-user] Editing Joined Tables

[Nicolas Cadieux]

> Le 29 oct. 2020 à 01:41, Springfield Harrison <stellargps at gmail.com> a écrit :
> 
> 
> Hello Nicolas,
> 
> Thanks for the comments, I'll go over them shortly.  Only a few dozen trees, not 1 million!
> 
Well thats  easier!  Funny, your message got mixed up with another email list with a question about 1.3 million features... 
keep us posted!
Good luck
Nicolas
> -----
> Cheers, Spring Harrison
> 
> 
> 
> On 10/28/20 07:52, Nicolas Cadieux wrote:
>> 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/20201029/07d25910/attachment.html>