我正在尝试将CDC/HHS医院紧张情况数据转化为空间数据,可以从以下链接下载:
https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/anag-cw7u
这是部分数据的示例:
hospital_name hospital_pk geocoded_hospital_address
TRIHEALTH EVENDALE HOSPITAL 360362 POINT (-84.420098 39.253934)
KANE COUNTY HOSPITAL 461309 POINT (-112.52859 37.054324)
CRAIG HOSPITAL 062011 POINT (-104.978247 39.654008)
对于入口:
structure(list(hospital_name = c("TRIHEALTH EVENDALE HOSPITAL",
"KANE COUNTY HOSPITAL", "CRAIG HOSPITAL", "JAY HOSPITAL", "HARRISON COUNTY COMMUNITY HOSPITAL"
), geocoded_hospital_address = c("POINT (-84.420098 39.253934)",
"POINT (-112.52859 37.054324)", "POINT (-104.978247 39.654008)",
"POINT (-87.151673 30.950024)", "POINT (-94.025425 40.26528)"
)), row.names = c(NA, -5L), class = c("tbl_df", "tbl", "data.frame"
))
我试图将其作为CSV导入,进行转换,然后将其转换为shapefile格式。该文件有一个字段称为geocoded_hospital_address,我尝试使用它来转换数据集。它以POINT(longitude, latitude)格式存储,例如"POINT(-100.01382, 37.441504)"。我通常使用coords选项下的两个变量(经度/纬度),但是我无法使“sf_column_name”选项起作用,也无法将该字段分解为两个部分。
test_sf<-COVID_19_Reported_Patient_Impact_and_Hospital_Capacity_by_Facility%>%
+ st_as_sf(sf_column_name="geocoded_hospital_address", crs=4326)
Error in st_sf(x, ..., agr = agr, sf_column_name = sf_column_name) :
no simple features geometry column present
有什么想法吗?
sf_column_name
,试试wkt
?COVID_19_Reported_Patient_Impact_and_Hospital_Capacity_by_Facility %>% st_as_sf(wkt = "geocoded_hospital_address", crs=4326)
- John Polosf::st_as_sf(df, wkt = "geocoded_hospital_address")
对我来说是可行的(其中我将您的对象命名为df
,而不是您使用的那个长名称) - SymbolixAU