Parse JSON to a dataframe

Question

Not sure how to do this:

I have a something stored like this (in a):

[
  "MULTIPOLYGON (((-95.0000000372529 40.999989970587194, -94.5000000372529 40.999989970587194, -94.5000000372529 40.499989970587194, -95.0000000372529 40.499989970587194)))"
]

typeof(a) # prints "character"
class(a)  # prints "json"

And I would like to convert it to a data.frame that looks like this (no need to round the numbers, it was just easier to type that)

I tried

a.df<-as.data.frame(as.matrix(a))

but that prints

 V1
1 [\n  "MULTIPOLYGON (((-95.0000000372529 40.999989970587194, -94.5000000372529 40.999989970587194, -94.5000000372529 40.499989970587194, -95.0000000372529 40.499989970587194)))"\n]\n

That doesn't look like valid JSON at all. Are you sure there isn't some other name for this file format? — MrFlick
– MrFlick, Commented Apr 6, 2017 at 15:17

hrbrmstr · Accepted Answer · 2017-04-06 16:15:08Z

1

library(sf)
library(jsonlite)
library(tidyverse)

x <- fromJSON('[
  "MULTIPOLYGON (((-95.0000000372529 40.999989970587194, -94.5000000372529 40.999989970587194, -94.5000000372529 40.499989970587194, -95.0000000372529 40.499989970587194)))"
]')

map(x, st_as_sfc) %>%
  map(~as.data.frame(.[[1]][[1]]))
## [[1]]
##      X1       X2
## 1 -95.0 40.99999
## 2 -94.5 40.99999
## 3 -94.5 40.49999
## 4 -95.0 40.49999

Now:

wkt2geojson('[
  "MULTIPOLYGON (((-95.0000000372529 40.999989970587194, -94.5000000372529 40.999989970587194, -94.5000000372529 40.499989970587194, -95.0000000372529 40.499989970587194)))"
]')

also kinda works but tosses warnings.

Knowing the actual source that created this WKT in such a configuration wld be helpful

edited Apr 6, 2017 at 16:15

answered Apr 6, 2017 at 16:06

hrbrmstr

79.1k11 gold badges146 silver badges209 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parse JSON to a dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related