[Qgis-user] Fwd: troubleshooting: point shapefile (from Excel table) does not display after CRS change

[Ana Marques]

Hi everyone,
problem fixed!
Many thanks,
Ana

---------- Forwarded message ---------
From: Ana Marques <anamarques.ea at gmail.com>
Date: Thu, Jan 17, 2019 at 9:44 AM
Subject: Re: [Qgis-user] troubleshooting: point shapefile (from Excel
table) does not display after CRS change
To: Nicolas Cadieux <nicolas.cadieux at archeotec.ca>


Hi Nicolas,

wow, many thanks for the expedite reply!
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! : )

Thanks again,
Ana


On Wed, Jan 16, 2019 at 8:28 PM Nicolas Cadieux <
nicolas.cadieux at archeotec.ca> wrote:

> Hi,
>
> Answers below.
> On 2019-01-16 1:38 p.m., Ana Marques wrote:
>
> Hi everyone,
>
> 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.
>
> 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)
>
>
>
> So far so good, this first shapefile displays well in QGIS projects.
>
>
> 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?
>
>
> 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:
>
>    - Right-clicked on the point layer in the Layers list
>    - Selected Export > Save Features As
>    - ...
>
> Make sure you also selected the CRS...  Make sure you are still in the
> correct spot.
>
>
> [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.]
>
> 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?
>
>
> 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.
>
> If I don't understand the problem, send us the files and the coordinates.
>
>
>
>    1. Do you have any recommendations on how to make the point vector
>    shapefile in EPSG:27700 display on the map?
>    2. When saving the shapefile in the new CRS, which layer options
>    should I use (e.g.: Resize: yes/no, etc.)?
>
>
> I have QGIS Desktop 3.4.1 (started off with 3.2.2 but the problem remains).
> I am new to QGIS so maybe I am missing something really obvious...
>
> Thanks in advance,
> Ana
>
>
> Nicolas
>
>
>
>
> _______________________________________________
> Qgis-user mailing listQgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>

-- 
Ana Marques Leandro
Bonn, Germany





-- 
Ana Marques Leandro
Bonn, Germany
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190117/4f33b9ba/attachment.html>