I have not followed this closely but see below. >> Le 28 oct. 2020 à 04:40, Springfield Harrison <stellar...@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 <char...@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 <stellar...@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@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@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@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user