MATLAB: How to make NxN matrix from excel dataset

importing excel data

Hi there,

I got excel dataset which has longitude(1xn)), latitude(1xn) and elevation(1xn) as described in the attached file.

How can I convert elevation dataset into NxN matrix?

Note: Data points are randomly distributed. not in exact order as described in the example.

Best Answer

griddata()

Related Solutions

MATLAB: Latitude and Longitude Data to Universal Transverse Mercator (UTM)

Matlab has his own functions to deal with it.

First you need to get the utm zone from the coordinates

p1 = [lat,lon];
z1 = utmzone(p1)

Then you must get the geoid of this zone and construct the projection structcture using the following functions

[ellipsoid,estr] = utmgeoid(z1);
utmstruct = defaultm('utm');
utmstruct.zone = z1;
utmstruct.geoid = ellipsoid;
utmstruct = defaultm(utmstruct);

Finally you use mfwdtran to convert coordinates

[x,y] = mfwdtran(utmstruct,lat,lon)

This explanation content was found in reference: https://www.mathworks.com/help/releases/R2020a/map/working-in-utm-without-a-map-axes.html

MATLAB: How to filter the required coordinates which consist with same elevation

filename = 'elevations.nc';
elev = ncread(filename, 'elevation')';
lon  = ncread(filename, 'lon')';
lat  = ncread(filename, 'lat');
[c,h] = contour(lon,lat,elev,'showtext','on','LevelList',0) ;

YOu have your o contour coordinates in c.

Best Answer

Related Solutions

MATLAB: Latitude and Longitude Data to Universal Transverse Mercator (UTM)

MATLAB: How to filter the required coordinates which consist with same elevation

Related Question