topic Re: Ascii to Raster error in Data Management Questions

Ascii to Raster error

AlexandreAssunção — Wed, 15 Jun 2016 15:09:27 GMT

Hi everyone, I have one question about the conversion from ASCII to raster. I know that ASCII files can be represented on ArcGIS as rasters. I have a lot of files to convert and manipulate right after the conversion; however, the conversion does not work for some files. I tried analyzing the ASCII files in the notepad and it seems that the values are corrupted. For example, I have values of ice concentration, which can vary from -1 to 100 %, looking through the ASCII files that do not work I found values such as, -110,010,010. In my opinion, some of the values in the ASCII file have gotten together, and now when I try to put them into ArcGIS, it just show a blur instead of what I want (the ice concentration on the waterways). Does anyone know a way that I can try to fix it? The grids are huge (516columns and 510rows) and try to space each corrupted value manually it's not an option.

Thanks.

Re: Ascii to Raster error

DarrenWiens2 — Wed, 15 Jun 2016 16:28:28 GMT

It's hard to know exactly how your data is supposed to get fixed, but for example, if your values of "-110" are supposed to get changed to "-1,010", you can do a simple Find/Replace in notepad.

Re: Ascii to Raster error

AlexandreAssunção — Wed, 15 Jun 2016 19:37:33 GMT

That's true, I have different sizes of values, it seems that just the 100's have gotten together. For sure, I need to re-space them, but the problem is they have turned into different values, it depends how many 100's have gotten together. 😕

Re: Ascii to Raster error

DanPatterson_Retired — Wed, 15 Jun 2016 19:44:13 GMT

can you provide a sample of a few of the offending rows, I am curious since you mention ice concentration and was wondering how you got a -1% concentration? Is the result an artifact of the calculation? or are these changes/differences between locations or times?

Re: Ascii to Raster error

AlexandreAssunção — Wed, 15 Jun 2016 19:48:00 GMT

-1 represent the land

There is your example:

0 -1 -1 -1 -1 -1 -1100100100100 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 0 0 0 0 -1 0 0 0 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1

-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1100100100100100 -1 -1 -1 -1 -1 -1100100 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 0 0 0 0 0 0 0 0 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1

-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1100100100100100100 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 0 -1 -1 0 0 -1 0 0 -1 0 0 0 0 0 -1 -1 -1 -1 -1 -1 -1 -1 -1 0 0 -1 -1 -1 -1 -1 -1 0 0 0 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -

Re: Ascii to Raster error

DanPatterson_Retired — Wed, 15 Jun 2016 19:54:01 GMT

Alexandre .... that is a mess ... does 0 represent land, -1 nodata and 100 something else?

Now some people use ascii to mean something else.

Is this a true ascii file (aka esri's) which has a header such as shown here

ASCII to Raster—Help | ArcGIS for Desktop

is there any chance that this file was opened\used in another program? I just want to ensure that it was and is a space delimited format. I have never seen an esri tool produce such a 'inconsistency' so I am suspecting something has happened along its journy.

Re: Ascii to Raster error

AlexandreAssunção — Wed, 15 Jun 2016 20:00:47 GMT

I didn't put the whole file, I just put some lines to illustrate better and to clarify your doubt. -1 represent the land and the range 0-100 represent the ice concentration in the waterways. I was clear about the error, the 100's values have gotten together and I don't know why, what I know is if I separate them manually the ASCII file work well in the ArcMap. I am just trying to find a easier way to do that.

Re: Ascii to Raster error

DarrenWiens2 — Wed, 15 Jun 2016 20:04:40 GMT

I think you can just Find/Replace "100" with " 100", at least for this example.

Before:

After:

Re: Ascii to Raster error

JayantaPoddar — Wed, 15 Jun 2016 20:05:28 GMT

In he above example, I can see all the values "100" are getting clubbed together with its previous value.

So I can Find and Replace "100" with "<Space>100". Check and replace them one by one (NOT "Replace All" option). Check for anomalies in other values as well.

Re: Ascii to Raster error

DanPatterson_Retired — Wed, 15 Jun 2016 20:11:01 GMT

well if it is just the 100, the do what Jayanta and Darren suggest, if it extends to other values like 99 and below, I would go back to the original generating program and figure out what the problem is.... maybe changing the nodata value would have helped

Re: Ascii to Raster error

AlexandreAssunção — Wed, 15 Jun 2016 20:15:56 GMT

Thank you, definitely that will be faster. Just one more question? Is there anyway, if I have a ASCII File with no delimiter in other words there is no space between the values, to create a space between each value in this ASCII file?

Re: Ascii to Raster error

DarrenWiens2 — Wed, 15 Jun 2016 20:19:12 GMT

So, a file with a line like "3928736745959037239405843"? If there's a pattern, like number of characters per value, you could split it using something like Python, but there would be no way to split it like "39 287367 459 5 9 0 3723 9405843" because there is no pattern.

Re: Ascii to Raster error

AlexandreAssunção — Wed, 15 Jun 2016 20:28:41 GMT

Yes, that's what I was thinking. Because I have values varying from -1 to 100, if I get the value 5 and 95 for example, if I split the fives. I would separate the 95 too.