[Qgis-user] Editing Joined Tables

[Springfield Harrison]

Hello Nicolas,

Thanks for the comments, I'll go over them shortly.  Only a few dozen 
trees, not 1 million!

-----
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 <mailto: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 <mailto: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 <mailto: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 <mailto: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/5e7c10d6/attachment.html>