Hi everyone, problem fixed! Many thanks, Ana ---------- Forwarded message --------- From: Ana Marques <[email protected]> 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 <[email protected]>
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 < [email protected]> 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 [email protected] > 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
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
