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