geoalchemy2 | Geospatial extension to SQLAlchemy | SQL Database library

I'm trying to create an in-memory SQLite database off of SQLAlchemy ORMs originally designed for a Postgres database. To allow the SQLite engine to convert postgres specific datatypes, I've relied on the SQLAlchemy @compiles decorator, which works as intended for types in the sqlalchemy.dialects.postgresql namespace.

How can I convert the geoalchemy2.Raster data type to a engine-agnostic data type (it could be a sqlalchemy.BLOB type for all I care. The important thing is that I can create tables that are similar, they don't need to be exact)?

This example code converts the DOUBLE_PRECISION type as intended, but I'm at a loss for how to modify the geoalchemy2.Raster data type which is a UserDefinedType. I'd like to be able to write a similar method to compile_DOUBLE_PRECISION() that changes Raster into a BLOB type.

Have successfully defined and migrated a table into a PostGIS database with the following definition:

I need to insert a point into Column(Geometry(geometry_type='POINT', srid=4326)). I can not figure out how to implement the srid=4326 into the point data POINT(58.183594 22.593726). I searched for it. I still cannot solve this!

Error:

I am trying to build my own Python package (installable by pip) using the twine package. This is all going well right up until the point where I try to pip install my actual package (so after uploading to PyPi).

So I first run:

python3 setup.py sdist bdist_wheel

In which my setup.py install_requires list looks like this:

I'm having a go at setting up my first Postgres database, but am getting quite confused about why I'm having issues with enabling Postgis in one schema and then using it in another.

I'm using Google Cloud SQL with Postgres v12. I'm connecting via the Cloud SQL proxy, and have connected to the server via both pgAdmin4 and a Jupyter Notebook (SQLAlchemy).

My goal is to write a shapefile full of points into a table on the database via geopandas.

Based on this thread I'm trying to install postgis into a separate schema, while creating a couple more different schemas where my data will actually go. I'm opening the shapefile in geopandas, and then using .to_postgis() to try and save the shapefile contents into a new table in one of my data schemas. This always fails.

However, if I try to write the geodataframe into the extensions schema, it works just fine. This makes me think that there's something wrong with the search_path, but no idea what. I'm setting the search path as suggested here. I've tried a range ways to setup the search_path, but I think there's something lacking in my fundamental understanding of what it does and how it works.

Here's the workflow:

• (create the postgres server on Google Cloud SQL)
• (get the proxy up and running)
• (connect to pgAdmin)
• (create a database in pgAdmin called "mydb", equivalent to "CREATE DATABASE mydb")
• (open Query Tool in pgAdmin)

SQL:

I'm working on a project that uses SQLite as a database and Alembic as a database migration tool. It includes spatial data and therefore, spatial extensions and geoalchemy2 are included in the project. I'm using autogenerate command and it detects some changes that don't exist in the geometry columns.

Here is the simplified structure of the project: