[Qgis-user] Editing Joined Tables
Springfield Harrison
stellargps at gmail.com
Fri Oct 30 22:28:10 PDT 2020
Hello Nicolas /et al,/
Thanks for your thoughts and the suggestion copied below:
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
This looks like a useful procedure, but only for a few points. I will
have a dozen or so (from Total Station and/or GPS) to input per batch so
I think my workflow will be:
1. Tree positions in a shapefile
2. tree attributes in a shapefile
3. the files are linked by a common tree tag field
4. attributes are added as and when to the attribute shape file
5. tree positions are brought into the project as a CSV file derived
from the total station or the GPS; X and Y fields are defined upon
import. The file structure mimics the tree position shapefile
6. new tree positions are copied in the CSV file, then pasted into the
tree position shapefile.
This is complex, but does seem to work after considerable trial and
error. If there is a simpler approach, I would be more than pleased to
hear about it but this is where I have fetched up for the moment.
The complication is that the position file needs to be edited for
on-screen digitizing plus it needs to accept batch inputs from the GPS
and survey instruments. It seems that the workflow outlined above is
the only way to meet all these needs.
Thanks again for everyone's thoughts, collaboration is definitely of
great value…
-----
Cheers, Spring Harrison
On 10/28/20 22:50, Nicolas Cadieux wrote:
>
>
>> 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 <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/20201030/81906e4a/attachment.html>
More information about the Qgis-user
mailing list