[Qgis-user] Editing Joined Tables
Springfield Harrison
stellargps at gmail.com
Wed Oct 28 22:41:29 PDT 2020
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>
More information about the Qgis-user
mailing list