Re: [Qgis-user] Which font for Delimited Text Layer

Thu, 05 Sep 2013 05:40:51 -0700

On 09/05/2013 03:11 PM, silverio abati wrote:
hello List,
I have a little problem to import a layer with the function "delimited text layer":

I have the coordinates (e.g. 41°44'51'' Lat, 14°18'13'' Long) and I know the coordinate reference system: WGS84 UTM33N, EPSG: 32633.

the problem is that I don't know which font I have to use in the database (e.g. excel) so QGIS can read them in correct mode (at the end of the import process QGIS says me the fields for coordinates are no valid).

Nothing to do with the font. The lon/lat values *must* be in decimal degrees: DD.dddddd
 In excel separate the degrees, minutes, seconds into three different columns. Then, in a fourth column put in the formula: "degree_column + (minutes_column/60) + (seconds_column/3600). Same for the longitude values.
Now you must convert those formulas to numbers. Use in Excel "Copy", then "Paste Special" to copy the formulas to numbers.

Now, when you input the delimited text file, point to those (numeric) columns that hold the decimal degree values for the X and Y columns, and it should work fine.

I tried:
41°44'51''
414451
41.44.51
but they don't work

thank you very much

BEST,
silverio

This mail was received via Mail-SeCure System.


_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
This mail was received via Mail-SeCure System.





-- 
Micha Silver
GIS Consultant, Arava Development Co.
http://www.surfaces.co.il
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to