Writing GeoPandas data frame to PostGIS?

You are dropping the wrong column which leads your script to try to insert in the DB the type Point from Shapely, change this line :

gdf1.drop('geom', 1, inplace=True)

to this :

gdf1.drop('geometry', 1, inplace=True)

and the last line to this:

 gdf1.to_sql('helloworld', engine, if_exists='append', index=False, dtype={'geom': Geometry(geometry_type='POINT', srid= 4326)})

Related