Integration of FastAPI framework supported by Pydantic with SQLAlchemy ORM and PostGIS on psycopg driver
-
Updated
Sep 29, 2024 - Python
Integration of FastAPI framework supported by Pydantic with SQLAlchemy ORM and PostGIS on psycopg driver
Working with Spatial Data using FastAPI, SQLAlchemy, GeoAlchemy and PostGIS
webApp features: allow us to print map, adding notes to map and rendering to templates, you can switch between basemaps, geoJSON file visualization, adding shp files to map with the help of postgis, postgresal, geoserver and python liberaries, deleting and adding operation using djnago models signals(post_save, post_delete)...
Сервис по прогнозированию негативных аспектов развития городской среды
A modular approach to Python-FLask-PostGIS project
Technical Test - A CRUD RestFul API written in FastAPI, using techonlogies like PostgreSQL and PostGIS for spacial queries.
Integration of FastAPI, Strawberry, PostGIS, SQLAlchemy, and asyncpg.
a full-stack application for exploring campsites in the US and Canada
Geospatial API demo with FastAPI, GeoAlchemy2, SQLAlchemy, Pydantic, Alembic, PostGIS (PostgreSQL), SpatiaLite (SQLite), uv.
Generate GeoAlchemy2 and SQLAlchemy 2.0 declarative models from a live PostGIS database, complete with geometry types, SRIDs, spatial indexes, enums and foreign-key relationships — plus typed spatial query helpers for ST_DWithin, KNN and bounding-box searches. Works from a live DSN or a shareable JSON schema description.
Organization API
A full-stack geospatial memory journal. Features PostGIS spatial queries for viewport optimization, frontend marker clustering, and robust security (JWT, Rate Limiting, reCAPTCHA).
Company directory service (test assignment from Secunda campany)
Curated, example-driven reference for 92 PostGIS ST_* functions and spatial operators. Every entry has a SQL example with its real result, psycopg and GeoAlchemy2 snippets, SRID gotchas, GiST index behaviour and common mistakes. Search from the terminal, or generate a single self-contained searchable HTML page.
Scaffold a production-shaped FastAPI + PostGIS spatial API: async SQLAlchemy, strict Pydantic geometry validation, keyset pagination, index-friendly bbox queries, MVT tiles and JWT spatial scopes.
Production-grade PostGIS + Python documentation: spatial queries, GiST indexing, SQLAlchemy/GeoAlchemy2 integration, schema migrations, and performance tuning — runnable SQL + Python, no pseudocode.
Add a description, image, and links to the geoalchemy2 topic page so that developers can more easily learn about it.
To associate your repository with the geoalchemy2 topic, visit your repo's landing page and select "manage topics."