<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello Nicolas <i>et al,</i><br>
<br>
Thanks for your thoughts and the suggestion copied below:<br>
<br>
<font color="#3333ff">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"||')'). <br>
<br>
<a class="moz-txt-link-freetext" href="https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields">https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields</a><br>
</font><br>
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:<br>
</p>
<ol>
<li>Tree positions in a shapefile</li>
<li>tree attributes in a shapefile</li>
<li>the files are linked by a common tree tag field</li>
<li>attributes are added as and when to the attribute shape file</li>
<li>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</li>
<li>new tree positions are copied in the CSV file, then pasted
into the tree position shapefile.<br>
</li>
</ol>
<p>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.<br>
<br>
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.<br>
<br>
Thanks again for everyone's thoughts, collaboration is definitely
of great value…<br>
<br>
</p>
<pre class="moz-signature" cols="72">-----
Cheers, Spring Harrison</pre>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 10/28/20 22:50, Nicolas Cadieux
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:36EC9F2D-4352-4679-A8DC-BE0A1759071D@gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<br>
<div dir="ltr"><br>
<blockquote type="cite">Le 29 oct. 2020 à 01:41, Springfield
Harrison <a class="moz-txt-link-rfc2396E" href="mailto:stellargps@gmail.com"><stellargps@gmail.com></a> a écrit :<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<p>Hello Nicolas,</p>
<p>Thanks for the comments, I'll go over them shortly. Only a
few dozen trees, not 1 million!<br>
</p>
</div>
</blockquote>
<div>Well thats easier! Funny, your message got mixed up with
another email list with a question about 1.3 million
features... </div>
<div>keep us posted!</div>
<div>Good luck</div>
<div>Nicolas</div>
<blockquote type="cite">
<div dir="ltr">
<p> </p>
<pre class="moz-signature" cols="72">-----
Cheers, Spring Harrison</pre>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 10/28/20 07:52, Nicolas
Cadieux wrote:<br>
</div>
<blockquote type="cite"
cite="mid:9EA273B2-834C-4905-A833-502AB16B6104@gmail.com">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div dir="ltr">I have not followed this closely but see
below.<br>
<div dir="ltr"><br>
<blockquote type="cite">Le 28 oct. 2020 à 04:40,
Springfield Harrison <a class="moz-txt-link-rfc2396E"
href="mailto:stellargps@gmail.com"
moz-do-not-send="true"><stellargps@gmail.com></a>
a écrit :<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<p>Hello Charles & Sebastian,</p>
<p>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.</p>
</div>
</blockquote>
<div>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?</div>
<blockquote type="cite">
<div dir="ltr">
<p> I didn't try the xlsx option as I require a CSV
table as the primary table in the join (to import
UTM coordinates). </p>
</div>
</blockquote>
<div>With over a million object, you will go over the xlsx
max limit. </div>
<blockquote type="cite">
<div dir="ltr">
<p> Other spreadsheet formats do not trigger the X/Y
georeferencing options found in the delimited text
file type.</p>
</div>
</blockquote>
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 <span
style="color: var(--black-800); font-family: Consolas,
Menlo, Monaco, "Lucida Console",
"Liberation Mono", "DejaVu Sans
Mono", "Bitstream Vera Sans Mono",
"Courier New", monospace, sans-serif;
font-style: inherit; font-variant-caps: inherit;
white-space: inherit; font-size: 13px;
-webkit-text-size-adjust: auto;">geom_from_wkt('POINT('||"x"||'
'||"y"||')'). </span>
<div>
<div><br>
</div>
<div><a
href="https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields"
moz-do-not-send="true">https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields</a></div>
<div><br>
</div>
<blockquote type="cite">
<div dir="ltr">
<p>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.</p>
</div>
</blockquote>
<br>
<blockquote type="cite">
<div dir="ltr">
<p>Anyway, thanks again, your suggestions helped me
along . . . . .<br>
</p>
<pre class="moz-signature" cols="72">-----
Cheers, Springfield
</pre>
<div class="moz-cite-prefix">On 10/27/20 09:14,
Sebastian Gutwein wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAED_52qVCPVf3gZH5+e3V-RLnEMxGwZZ0bT5JMi26+QyzGoOhg@mail.gmail.com">
<meta http-equiv="content-type"
content="text/html; charset=UTF-8">
<div dir="ltr">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</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Oct
27, 2020 at 5:02 AM Charles Dixon-Paver <<a
href="mailto:charles@kartoza.com"
moz-do-not-send="true">charles@kartoza.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">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.
<div><br>
</div>
<div>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.</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, 27
Oct 2020 at 10:03, Springfield Harrison
<<a href="mailto:stellargps@gmail.com"
target="_blank" moz-do-not-send="true">stellargps@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hello
All:<br>
<br>
Using version 3.10.10, I have joined two
MS Excel files: Positions.csv <br>
and catalogue.xls using a common field
called Tag. This is a tree <br>
inventory project.<br>
<br>
All is well except I cannot edit either
table from within QGIS. I need <br>
to create some new positions manually and
generally update the tables <br>
continuously.<br>
<br>
In the Join dialogue, I have selected
Enable Editing but it has no effect.<br>
<br>
I feel that different file types or a
different procedure may facilitate <br>
this process but am exhausted from trying
so many blind alleys.<br>
<br>
Is there a trick to being able to edit
joined tables?<br>
<br>
Thanks very much . . . .<br>
<br>
-----<br>
Cheers, Springfield Harrison, British
Columbia<br>
<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org"
target="_blank" moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org"
target="_blank" moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
</div>
</blockquote>
<span>_______________________________________________</span><br>
<span>Qgis-user mailing list</span><br>
<span><a class="moz-txt-link-abbreviated"
href="mailto:Qgis-user@lists.osgeo.org"
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a></span><br>
<span>List info: <a class="moz-txt-link-freetext"
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br>
<span>Unsubscribe: <a class="moz-txt-link-freetext"
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span></div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</blockquote>
</body>
</html>