I have a bunch of .kml files each with a fairly large number of observations for WindSpeed(~60K). I have been reading them in to R using st_read(), but the windspeed column isn’t present in the sf() object once I read it in, only the geometry and cell name:

sf_df <- st_read("path/to/kml/my_kml.kml") 

sf_df
> sf_df
Simple feature collection with 63336 features and 2 fields
Geometry type: LINESTRING
Dimension:     XYZ
Bounding box:  xmin: -156.7183 ymin: 20.57039 xmax: -155.9632 ymax: 21.03848
z_range:       zmin: 31.25 zmax: 31.25
Geodetic CRS:  WGS 84
First 10 features:
       Name Description                       geometry
1  Cell 0,0             LINESTRING Z (-156.7182 20....
2  Cell 0,1             LINESTRING Z (-156.7158 20....
3  Cell 0,2             LINESTRING Z (-156.7134 20....
4  Cell 0,3             LINESTRING Z (-156.711 20.5...
5  Cell 0,4             LINESTRING Z (-156.7086 20....
6  Cell 0,5             LINESTRING Z (-156.7062 20....
7  Cell 0,6             LINESTRING Z (-156.7038 20....
8  Cell 0,7             LINESTRING Z (-156.7014 20....
9  Cell 0,8             LINESTRING Z (-156.699 20.5...
10 Cell 0,9             LINESTRING Z (-156.6966 20....

Am I missing something? Every thread seems to suggest a now-depreciated package or leads to a closed webpage. I’m not able to share the full data, but a snippet of the .csv looks like this:

# A tibble: 6 × 5
      X     Y Name     Speed Angle
  <dbl> <dbl> <chr>    <dbl> <dbl>
1 -157.  20.6 Cell 0,0  9.81  79.0
2 -157.  20.6 Cell 0,1  9.83  78.7
3 -157.  20.6 Cell 0,2  9.85  78.4
4 -157.  20.6 Cell 0,3  9.87  78.1

However given the number of files I’d like to use the .kml file directly, if possible