python - 将 JSON 加载到 GeoDataFrame 中

Question

我在将以下包含 GIS 数据 ( https://data.cityofnewyork.us/resource/5rqd-h5ci.json ) 的 JSON 加载到 GeoDataFrame 时遇到困难。

当我尝试设置几何体时，以下代码失败。

import requests
import geopandas as gpd
data = requests.get("https://data.cityofnewyork.us/resource/5rqd-h5ci.json")
gdf = gpd.GeoDataFrame(data.json())
gdf = gdf.set_geometry('the_geom')
gdf.head()

Answer 1

对于使用网络 map 库的人...

如果 GeoJSON 被包装在 FeatureCollection 中，就像它们通常被网络映射库(在我的例子中是 Leaflet)导出到 GeoJSON 字符串时一样，那么您需要做的就是传递列出 features 到 from_features() 像这样:

import geopandas as gpd
study_area = json.loads("""
 {"type": "FeatureCollection", "features": [{"type": "Feature", "properties": {}, "geometry": {"type": "Polygon", "coordinates": [[[36.394272, -18.626726], [36.394272, -18.558391], [36.489716, -18.558391], [36.489716, -18.626726], [36.394272, -18.626726]]]}}]}
""")
gdf = gpd.GeoDataFrame.from_features(study_area["features"])
print(gdf.head())

输出:

                                            geometry
0  POLYGON ((36.394272 -18.626726, 36.394272 -18....

简单易行。