python, sqlalchemy, geoalchemy2 and postgis

uio-carpentry / studyGroup

Welcome to UiO@Carpentry Study Group!

https://uio-carpentry.github.io/studyGroup/

Other

8 stars 0 forks source link

python, sqlalchemy, geoalchemy2 and postgis #38

Open cweber9843 opened 5 years ago

cweber9843 commented 5 years ago

I want to use python and geoalchemy to query a postgis database with materialized views. Are there others here who are working with this?

I have used sqlalchemy and postgres before to query tables, but the materialized views give me a headache. Main problem is how to reflect the existing views, in order to be able to query them. Any hints are welcome, and maybe there even are enough interested to take this up in the study group?

annefou commented 5 years ago

This is an excellent idea for a studyGroup session. I would be happy to organize it.

cweber9843 commented 5 years ago

Nice, thanks! I now managed to get the materialized view working, but of course I am running into new problems, so there is a lot to discuss! We can add "geopandas" to the topics to talk about.