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 <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 <mailto: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 <mailto: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 <mailto: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 <mailto: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