This video discusses how to get data out of PostGIS and into GeoPandas.

Code written in this video can be found here:
https://github.com/GeospatialProgramm...

GeoPandas from_postgis() function documentation
https://geopandas.org/en/stable/docs/...

List of PostGIS functions for reference:
https://postgis.net/docs/manual1.5/c...

In this video we used ST_Transform, ST_Buffer, and ST_Intersects, but there are many many more available.