I am having a problem using the arcmap point to raster tool. I have x/y coordinates for a set of data, and 1464 (2 months worth of hourly data) separate files to convert from an excel with X/Y/value to a matrix for use in another program. I already have a small python-script in order to automate the point to raster and then a raster to ascii, but in my first round of testing, the values i get out of this are really weird.

I have 6 separate excel files with x/y/value1/value2/value3... etc., which i have loaded into arcmap using the Add Data -> Add xy Data tool. However, when i convert this point data based on a value-field, it gives me a range of 0:401, whereas the actual maximum value in excel is 5.05. How can these values be so different?

  • did you convert your added points into a feature class before you ran the tool? which kind of cell assignment type did you choose for the point to raster conversion? – dru87 Jun 29 '16 at 12:49
  • Yes, I imported them into a gdb as a feature class, and I used the mean cell assignment type. Also, I used a cellsize of 0.015, which is fairly close to the resolution of the original dataset (1x1km) – Martin13131 Jun 29 '16 at 13:14
  • Looking at the data in arcmap, i see that the valuefields are still recognised as datatype text as opposed to double. Could this be the cause? – Martin13131 Jun 29 '16 at 15:45
  • 1
    Thank you for all the suggestions though. I really appreciate it – Martin13131 Jun 30 '16 at 14:28
  • 1
    @dru87 I redid all the dataprocessing and found the problem. turns out I accidentally didn't select all precipitation data when assigning cellproperties. Thanks again for your help! – Martin13131 Jul 1 '16 at 10:52

I just managed to fix the problem. It turns out I didn't correctly assign the cell-properties of the precipitation data as a number in excel.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.