#%%
import pandas as pd
import geopandas as gpd


df = pd.read_excel('/Users/huseyin.kaya/Downloads/Tomorrowville_Dataset/TV_Others/VS2/_outputs/Layer_Building_VS2.xlsx')

#df = pd.read_excel('/Users/huseyin.kaya/Downloads/Tomorrowville_Dataset/TV_Others/VS1/_outputs/Layer_Individual_VS1.xlsx')
#df.to_json('individual_tv50_1.json')

#df = df.rename(columns={'X':'x','Y':'y','IM':'im'})

gdf = gpd.GeoDataFrame(df, geometry=gpd.points_from_xy(df.xcoord, df.ycoord))
gdf.set_crs(epsg=32645, inplace=True)
gdf = gdf.to_crs(crs="EPSG:4326")

gdf.xcoord = gdf.geometry.x
gdf.ycoord = gdf.geometry.y

#gdf = gdf.sample(n=1000)
gdf = gdf.reset_index(drop=True)
#gdf = gdf.drop(columns=['xcoord','ycoord'])
#gdf = gdf.drop(columns=['geometry'])

gdf.to_file('building_tv50_2.geojson', driver="GeoJSON")  
#%%