> Le 29 oct. 2020 à 01:41, Springfield Harrison <stellar...@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 <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
