[Qgis-user] Export polygon coordinates qgis
Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use Ctrl+C but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I'd prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
Hi Lester, Thanks, it works but… I still get XY coordinates, not lat/long. The question i show to convert from XY to lat/long ? Regards – Tomasz From: Lester Anderson [mailto:arctica1...@gmail.com] Sent: Tuesday, March 17, 2015 9:48 AM To: Tomasz Bigaj Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Export polygon coordinates qgis Hi Tomasz, This is easy to do. Go into edit mode and select the feature(s) you want (highlighted yellow usually). Open the attribute table for the polygon shapefile and click copy slected rows to clipboard (4th icon from the right on the toolbar). Copy this into a text editor and you get something like this: wkt_geomid POLYGON((-2.72439024390243922 1.60975609756097571,-2.72439024390243922 1.95121951219512213,-1.77073170731707341 2.02926829268292686,-1.57073170731707323 1.42926829268292699,-2.21951219512195141 1.06341463414634152,-2.72439024390243922 1.60975609756097571))1 Just edit this file to leave the X, Y coordinates and away you go! Coordinate pairs are separated by commas. Cheers Lester On 17 March 2015 at 08:08, Tomasz Bigaj to...@jagielka.eu mailto:to...@jagielka.eu wrote: Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use “Ctrl+C” but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I’d prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
Hi Tomasz, This is easy to do. Go into edit mode and select the feature(s) you want (highlighted yellow usually). Open the attribute table for the polygon shapefile and click copy slected rows to clipboard (4th icon from the right on the toolbar). Copy this into a text editor and you get something like this: wkt_geomid POLYGON((-2.72439024390243922 1.60975609756097571,-2.72439024390243922 1.95121951219512213,-1.77073170731707341 2.02926829268292686,-1.57073170731707323 1.42926829268292699,-2.21951219512195141 1.06341463414634152,-2.72439024390243922 1.60975609756097571))1 Just edit this file to leave the X, Y coordinates and away you go! Coordinate pairs are separated by commas. Cheers Lester On 17 March 2015 at 08:08, Tomasz Bigaj to...@jagielka.eu wrote: Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use “Ctrl+C” but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I’d prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
The important point is to make sure the shapefile is in a proper projection and not just a cartesian reference. Then you can export the vertices after reprojecting. There are other ways to do this via GMT too. On 17 March 2015 at 08:50, Enrico Ferreguti enrico...@gmail.com wrote: You can simply copy selected features from attributes table and paste them to excel table. in the first column you will find magically the geom attribute in WKT (Well Known Text format) containing all vertices coordinates expressed in layer srs. To get lat/long in geom field you need to explicitly reproject layer with vector or processing tool. Reproject on the fly does not apply on copy paste geom field. Regards 2015-03-17 9:08 GMT+01:00 Tomasz Bigaj to...@jagielka.eu: Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use “Ctrl+C” but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I’d prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
You can simply copy selected features from attributes table and paste them to excel table. in the first column you will find magically the geom attribute in WKT (Well Known Text format) containing all vertices coordinates expressed in layer srs. To get lat/long in geom field you need to explicitly reproject layer with vector or processing tool. Reproject on the fly does not apply on copy paste geom field. Regards 2015-03-17 9:08 GMT+01:00 Tomasz Bigaj to...@jagielka.eu: Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use “Ctrl+C” but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I’d prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
You can right click on the layer and choose save as. Then select save to csv. Select save selected if you only want a selection and select AS_WKT to get the coordinates. Then select the CRS in this case something like 4326 to get longitude latitude coordinates. On 03/17/2015 01:57 AM, Lester Anderson wrote: The important point is to make sure the shapefile is in a proper projection and not just a cartesian reference. Then you can export the vertices after reprojecting. There are other ways to do this via GMT too. On 17 March 2015 at 08:50, Enrico Ferreguti enrico...@gmail.com wrote: You can simply copy selected features from attributes table and paste them to excel table. in the first column you will find magically the geom attribute in WKT (Well Known Text format) containing all vertices coordinates expressed in layer srs. To get lat/long in geom field you need to explicitly reproject layer with vector or processing tool. Reproject on the fly does not apply on copy paste geom field. Regards 2015-03-17 9:08 GMT+01:00 Tomasz Bigaj to...@jagielka.eu: Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use “Ctrl+C” but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I’d prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
Have you assigned a projection to your shapefile? On 17 March 2015 at 08:59, Tomasz Bigaj to...@jagielka.eu wrote: Hi Lester, Thanks, it works but… I still get XY coordinates, not lat/long. The question i show to convert from XY to lat/long ? Regards – Tomasz *From:* Lester Anderson [mailto:arctica1...@gmail.com] *Sent:* Tuesday, March 17, 2015 9:48 AM *To:* Tomasz Bigaj *Cc:* qgis-user@lists.osgeo.org *Subject:* Re: [Qgis-user] Export polygon coordinates qgis Hi Tomasz, This is easy to do. Go into edit mode and select the feature(s) you want (highlighted yellow usually). Open the attribute table for the polygon shapefile and click copy slected rows to clipboard (4th icon from the right on the toolbar). Copy this into a text editor and you get something like this: wkt_geomid POLYGON((-2.72439024390243922 1.60975609756097571,-2.72439024390243922 1.95121951219512213,-1.77073170731707341 2.02926829268292686,-1.57073170731707323 1.42926829268292699,-2.21951219512195141 1.06341463414634152,-2.72439024390243922 1.60975609756097571))1 Just edit this file to leave the X, Y coordinates and away you go! Coordinate pairs are separated by commas. Cheers Lester On 17 March 2015 at 08:08, Tomasz Bigaj to...@jagielka.eu wrote: Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use “Ctrl+C” but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I’d prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Export polygon coordinates qgis
Problem solved. Thank you all for help. /Tomasz From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of David J. Bakeman Sent: Tuesday, March 17, 2015 6:31 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Export polygon coordinates qgis You can right click on the layer and choose save as. Then select save to csv. Select save selected if you only want a selection and select AS_WKT to get the coordinates. Then select the CRS in this case something like 4326 to get longitude latitude coordinates. On 03/17/2015 01:57 AM, Lester Anderson wrote: The important point is to make sure the shapefile is in a proper projection and not just a cartesian reference. Then you can export the vertices after reprojecting. There are other ways to do this via GMT too. On 17 March 2015 at 08:50, Enrico Ferreguti enrico...@gmail.com mailto:enrico...@gmail.com wrote: You can simply copy selected features from attributes table and paste them to excel table. in the first column you will find magically the geom attribute in WKT (Well Known Text format) containing all vertices coordinates expressed in layer srs. To get lat/long in geom field you need to explicitly reproject layer with vector or processing tool. Reproject on the fly does not apply on copy paste geom field. Regards 2015-03-17 9:08 GMT+01:00 Tomasz Bigaj to...@jagielka.eu mailto:to...@jagielka.eu : Hello, I need to export polygon coordinates from shp to text file. I can mark an object on map and use Ctrl+C but only x y coordinates are copied. How can I recalculate X Y coordinates to get lat/long geographical coordinates? I'd prefer to do it in Excel, because have a lot of extracted X Y data. Regards - Tomek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user