<div dir="ltr">Hi everyone,<div>problem fixed!<br></div><div>Many thanks,</div><div>Ana<br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">---------- Forwarded message ---------<br>From: <strong class="gmail_sendername" dir="auto">Ana Marques</strong> <span dir="ltr"><<a href="mailto:anamarques.ea@gmail.com">anamarques.ea@gmail.com</a>></span><br>Date: Thu, Jan 17, 2019 at 9:44 AM<br>Subject: Re: [Qgis-user] troubleshooting: point shapefile (from Excel table) does not display after CRS change<br>To: Nicolas Cadieux <<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>><br></div><br><br><div dir="ltr"><div dir="ltr">Hi Nicolas,<div><br></div><div>wow, many thanks for the expedite reply!</div><div>You were right, the coordinates in my original Excel file were already in EPSG:27700 and not in WSG84, so unknowingly I was applying the transformation twice and getting nowhere. It is fixed now! : )</div><div><br></div><div>Thanks again,<br></div><div>Ana</div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="m_7610273304318805167gmail_attr">On Wed, Jan 16, 2019 at 8:28 PM Nicolas Cadieux <<a href="mailto:nicolas.cadieux@archeotec.ca" target="_blank">nicolas.cadieux@archeotec.ca</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 bgcolor="#FFFFFF">
<p>Hi, <br>
</p>
<p>Answers below.<br>
</p>
<div class="m_7610273304318805167gmail-m_-5621522328548180346moz-cite-prefix">On 2019-01-16 1:38 p.m., Ana Marques
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi everyone,
<div><br>
</div>
<div>I used an Excel file to
create a point vector
shapefile in WGS84. The
original table in the
Excel file has a X and Y
column with coordinates in
WGS84.</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p>These should be in longitude and latitude. (something like
-3.666900154 and 55.2569877) If you have a long series of
numbers in the millions and hundred thousand, you are in metres
and not in WGS84 or epsg 4326)</p>
<p> </p>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div> So far so good, this
first shapefile displays
well in QGIS projects.</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<p>Install the Quickmap services plugin. Make sure the project CRS
is WGS84. Add a map in the background and make sure you are over
GB. Are you in the correct spot?<br>
</p>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>But I need the
shapefile in EPSG:27700,
so I followed the training
manual's instructions on
"Saving a Dataset to
Another CRS" to create a
new shapefile with the
right CRS:</div>
<div>
<div>
<ul>
<li>Right-clicked on
the point layer in
the Layers list<br>
</li>
<li>Selected Export
> Save Features
As</li>
<li>...</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p>Make sure you also selected the CRS... Make sure you are still
in the correct spot.<br>
</p>
<p><br>
</p>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>
<div>
<div>[Footnote: The
dialog window that
shows up in my PC
(Windows 7) is not
exactly the same as in
the manual (Mac) so I
am not sure if I have
set all the options
correctly.]<br>
</div>
<div><br>
</div>
<div>Now the Problem: I
add this new point
vector shapefile (in
EPSG:27700) to a QGIS
project, it appears
listed in the layers
list, but the points
do not display on the
map, even if I add it
as vector layer to a
new project having
previously defined
EPSG:27700 as the CRS
for all new projects.
The attribute table of
the vector shapefile
in EPSG:27700 seems
the same as the
original Excel file
(which has XY in
WGS84) - are the
EPSG:27700 coordinates
stored but not
visible?</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<p>If your coordinate look like the same as WGS84 (something like
-3.666900154 and 55.2569877, then you are adding the longitude
latitude coordinate to a file with a CRS that is in metres.
Select the object in the table and click "Zoom to Selection" you
will find that point. If you click " zoom to layer", you will
zoom out and your points will be very small. If that is the
case, you will need to translate the coordinates to the new CRS or
add them to the file that is in WGS84.</p>
<p>If I don't understand the problem, send us the files and the
coordinates.</p>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>
<ol>
<li>Do you have any
recommendations on how
to make the point
vector shapefile in
EPSG:27700 display on
the map?<br>
</li>
<li>When saving the
shapefile in the new
CRS, which layer
options should I use
(e.g.: Resize: yes/no,
etc.)?<br>
</li>
</ol>
</div>
<div><br>
</div>
<div>
<div>I have QGIS Desktop
3.4.1 (started off with
3.2.2 but the problem
remains).<br>
</div>
</div>
<div>I am new to QGIS so
maybe I am missing
something really
obvious...<br>
</div>
<div><br>
</div>
<div>Thanks in advance,</div>
<div>Ana<br clear="all">
<div><br>
</div>
<div dir="ltr" class="m_7610273304318805167gmail-m_-5621522328548180346gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr"><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
Nicolas<br>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr" class="m_7610273304318805167gmail-m_-5621522328548180346gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<p style="margin-bottom:0.0001pt;line-height:normal"><br>
</p>
<p style="margin-bottom:0.0001pt;line-height:normal"><br>
</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="m_7610273304318805167gmail-m_-5621522328548180346mimeAttachmentHeader"></fieldset>
<pre class="m_7610273304318805167gmail-m_-5621522328548180346moz-quote-pre">_______________________________________________
Qgis-user mailing list
<a class="m_7610273304318805167gmail-m_-5621522328548180346moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a class="m_7610273304318805167gmail-m_-5621522328548180346moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="m_7610273304318805167gmail-m_-5621522328548180346moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="m_7610273304318805167gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><font size="2">Ana Marques Leandro<br></font>Bonn, Germany<br><p style="margin-bottom:0.0001pt;line-height:normal"><br></p>
<p style="margin-bottom:0.0001pt;line-height:normal"><br></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><font size="2">Ana Marques Leandro<br></font>Bonn, Germany<br><p style="margin-bottom:0.0001pt;line-height:normal"><br></p>
<p style="margin-bottom:0.0001pt;line-height:normal"><br></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>