0

I want to interpolate raster surface from points. I have excel file consisting of latitude, longitude and values( which I want to interpolate).

How do I add these point values in input point feature to extract the desired result?

excel file, first column is for latitude, 2nd for longitude and third are the point values which I want to interpolate

Can I directly add points from excel sheet?

2

I think the part that's missing is filling in the blanks between points, for this you can use triangulation, which is in the realms of 3d analyst extension for which you will need a valid license:

  1. Import your Excel to points using make XY Event layer and save as shapefile or file geodatabase feature class.
  2. Create a new file geodatabase and feature dataset with the same spatial reference as your input points.
  3. Import your points into the feature dataset (Copy features, feature class to feature class etc.).
  4. Create a Terrain with the points - this will triangulate the gaps between points.
  5. If you want a raster surface then export your terrain to raster.

If you don't have an Esri 3d analyst license don't give up all hope, there are methods in QGIS that can triangulate a DEM from point elevations but are significantly more involved than the Esri process.

0

You do want to add your points using Add XY Data as suggested (or the "as event theme" option). You shouldn't need to jump through hoops to create a Spline Interpolation. If you have Spatial Analyst, you can use the Spline tool directly after creating your point feature class from your spreadsheet of points with values.

enter image description here

-1

You have to save the excel file in CSV format then it can be added to GIS. From the GIS you have to convert the file to layer using Add XY Data tool. then you can use the layer as input to interpolate raster.

  • 1
    From the documentation - "You can open Microsoft Office Excel tables directly in ArcGIS and work with them like other tabular data sources." – user2856 May 27 '18 at 6:04
  • Excel files can be opened, but csv is the standard way of adding data to gis. some features of Excel are not compatible in gis. – neogeomat May 28 '18 at 17:34
  • I'm not sure why this answer received such harsh treatment. It is brief and converting to csv sounds a little bit old school since Excel does what is intended much of the time. It (Excel) does however have its own ideas about data types sometimes which may cause problems whereas csv may be more reliable. – jbchurchill May 29 '18 at 14:54

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.