[Qgis-user] Which font for Delimited Text Layer

[Bernd Vogelgesang]

> 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.

In current master version, soon to be QGIS 2.0, the Delimited Text Layer  
Importer has now a "DMS-Coordinates" checkbox behind the x- and y-fields.
With this i already successfully managed to import those horrible  
DMS-Coordinates without having to transform them to decimal degrees.

For the import, you then have to choose EPSG 4326 (WGS84), and i can  
imagine that you are expected to reproject them afterwards to your EPSG:  
32633 (save as and choose other CRS)



> 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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> This mail was received via Mail-SeCure System.
>
>
>
>


-- 
Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374