将包含featurerecognition的Pandas列转换为GeoJSON

w51jfk4q 于 2023-02-06 发布在其他

关注(0)|答案(1)|浏览(154)

I downloaded a CSV that contains a column which has a GeoJSON format, and imported it as a pandas dataframe. How can I convert this to a GeoJSON (.geojson)? I have about 10,000 rows, each with information as shown below:
This is an example of a cell in the column: {"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Polygon","coordinates":[-0.0903517,9.488375],[-0.0905786,9.488523],[-0.0909767,9.48913],[-0.09122,9.4895258],[-0.0909733,9.4901503],[-0.0908833,9.4906802],[-0.0906984,9.4905612],[-0.0907146,9.4898184],[-0.090649,9.4895175],[-0.0907516,9.489142],[-0.0906146,9.4889654],[-0.0903517,9.488375]},"properties":{"pointCount":"11","length":"502.9413","area":"8043.091133117676"}}]}

Overview of my pandas dataframe print now:                             site_registration_gps_area  ...                   geometry
11    {"type":"FeatureCollection","features":[{"type...  ...  POINT (-76.75880 2.38031)
14    {"type":"FeatureCollection","features":[{"type...  ...  POINT (-76.73718 2.33163)
40    {"type":"FeatureCollection","features":[{"type...  ...   POINT (-0.15727 9.69560)
42    {"type":"FeatureCollection","features":[{"type...  ...   POINT (-0.11686 9.65522)
44    {"type":"FeatureCollection","features":[{"type...  ...   POINT (-0.10379 9.65226)

JSON

来源：https://stackoverflow.com/questions/75298179/convert-pandas-column-with-featurecollection-to-geojson

1条答案

按热度按时间

lp0sw83n1#

我建议使用GeoPandas来完成这个任务。最简单的解决方案是使用GeoDataFrame直接用GeoPandas读取CSV文件。如果你这样做，你需要这样的东西：

import geopandas as gpd

# read the CSV file into a GeoDataFrame
gdf = gpd.read_file('myFile.csv')

# convert the GeoDataFrame to a geojson object
geo_json = gdf.to_json()

# however if the objects become very big, store the GeoDataFrame to a .geojson file
gdf.to_file('path', driver='GeoJSON')

但是，如果您使用Pandas中的DataFrame，则可以将其转换为GeoDataFrame，然后使用与上面代码片段相同的步骤。

import pandas as pd
import geopandas as gpd

# your code here ...

# extract the geojson column as a list 
geo_j_list = df['geometry'].tolist()

# temporary list for GeoDataFrames
gdfs = []

# iterate over the geojson objects in the list
for geom in geo_j_list:
    gdfs.append(gpd.GeoDataFrame.from_features(geom['features']))

# merge the list of GeoDataFrames into one
gdf = gpd.GeoDataFrame(pd.concat(gdfs, ignore_index=True))

# convert the gdf to a json object
geo_json = gdf.to_json()

# store the gdf in a geojson file
gdf.to_file('path', driver='GeoJSON')

赞(0）回复(0）举报 2023-02-06

我来回答

将包含featurerecognition的Pandas列转换为GeoJSON

1条答案

相关问题

热门标签

最新问答