Try to specify your datatype.
df.to_sql('my_name', con=engine, index=True, if_exists='replace', dtype=({'geometry':'geometry'}))
Try to specify your datatype.
df.to_sql('my_name', con=engine, index=True, if_exists='replace', dtype=({'geometry':'geometry'}))