<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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>
<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"><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">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">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">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span></div>
</blockquote>
</div>
</div>
</blockquote>
</body>
</html>