I'm trying to convert the attached ASCII File containing climate data to a raster layer. But all I get is a distorted raster. I'm using the ASCII to Raster Tool.
There seems to be no cellsize info in the header of the text file instead only dx dy values and a bunch of other variables.
This is the format required for ascii to raster
The format isn't suitable for ascii to raster
* Kooperation ZAMG - DWD KU1
* Modellsimulation zur Anzahl der Sommertage
* auf der Grundlage der Station
* fuer den Kontrollzeitraum 1971 - 2000
* Data specifications
subject Anzahl der Sommertage
unit per annum
cellpos 1 (=Cell center)
horizontal cell dimensions dx(1..310) 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 1... snip
horizontal cell dimensions dy(1..240) 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 … snip
* Weitere Erlaeuterungen zu den folgenden Datenzeilen:
* Die Zeilen sind von "Nord" nach "Sued" geordnet
* und die Werte in den Zeilen von "West" nach "Ost".
* Die Datenfolge innerhalb der Zeilen ist: Zyklus Niveau S-N-Index W-O-Index Werte ...
* mit den fuehrenden 4 Indizes im Format "i5"
* und den folgenden Werten im Format "ndigits" (siehe oben).
* Fuer die fuehrenden Indizes gelten die Konventionen:
* -99: undefiniert; 0: Laufindex
* NODATA_value: Fehlende Werte
1 -99 240 0 69.8 66.9 66.6 66.3 66.9 66.6 68.1 67.4 67.5 67.2 69.4 69.3 70.3 70.5 71.9 76.2 … snip
In ArcGIS Pro it yields this error message
Input ASCII raster file C:\Temp\W_197100_REMO_C20_Sommertage.txt
Output raster C:\GIS\testing_project\testing_project.gdb\ASCIITo_txt2
Output data type FLOAT
Start Time: August 22, 2018 5:48:29 AM
ERROR 010022: Keyvalue * misses its value.
ERROR 010067: Error in executing grid expression.
Failed to execute (ASCIIToRaster).
Failed at August 22, 2018 5:48:29 AM (Elapsed Time: 0.23 seconds)
Where did you get it? perhaps there is some meta data that provides some extra information
Thank you for your quick reply! I got it from the website of the Austrian Weather Information Association (ZAMG). Here is the link: https://www.zamg.ac.at/cms/de/klima/informationsportal-klimawandel/daten-download/stadtklima-zukunft
But there is no additional information, I have already searched everything. To get the distorted image I got I delete parts of the header.
That was what I finally put in the header :
Because with the other values it would give me errors, but obviously the cellsize is not 100, but I don't really know what to do with the dx/dy values in the original file.
The data are in a projected coordinate system if the corner information is correct.
What appears to be throwing if off are the first 3 or 4 columns. They are not floating point and they seem to be a reference to a row number, nodata value etc.. The data for the row starts with the first floating point value.
Sorry, but I will have to defer to you to find a description of how to read the data on that site but it is not a straight ascii format
Ok I see. The first columns contain the nodata value and 0 and 1 and the number of the row.
There is some information in the file, it says:
"The rows are aranged from north to south and the values in the rows from west to east. The data sequence within the rows is: cycle standard S-N-Index W-O Index Values, with the leading 4 indices in the format "i5" and the values in the fomat "idigits"
The indices have the following rules:
-99 undefined; 0: running index
NODATA: missing values"
But I guess that doesn't really help how to read the first 4 rows. Do you think deleting the first 4 colums would help?
On a copy... I have never seen an ascii file like that before... but the short header you are using is what is needed, but the data in those columns except for the floating point values are strange ie 1 -99 240 0
ok I finally deleted the first 4 digits in each row and it works now. I don't know what's the purpose of those. Thank you very much for your help, I wouldn't have figured it out on my own.