Python FastAPI + PostGIS Mini-Project

Hello,
I understand that you need a backend on FastAPI that works with PostGIS for geospatial data. I can create the necessary endpoints for accepting GeoJSON, bounding box queries, and asynchronous data access. The API will return clean GeoJSON responses.
I will use asyncpg or SQLAlchemy with async support. Docker configuration will be included. I have experience working with large geospatial datasets and know how to use spatial indexes to improve speed.

Show original

Translate

Hello. All recent projects were done using almost your stack. I am ready to offer my candidacy.

Show original

Translate

Hi,
The test task looks straightforward. I'd set up a docker-compose environment, build the API with FastAPI's async features, and use PostGIS with proper GIST indexing for the spatial queries to make them fast.
I have production experience with exactly this stack, especially with optimizing PostGIS queries on large datasets, which seems to be the core of your main project.
Quick question about the main project: you mentioned "large volumes of data" and "batch inserts". Could you give a rough idea of the scale we're talking about? Just curious about the performance challenges ahead.
Ready to tackle the test task. Let's talk.

Hi. I am able to do your project. I have enough experience and time. You can write me message to discuss details.

Good day, I have 5 years of experience, I work at IBM, ready to help, write to me to discuss the details.

Show original

Translate

Hi Anton!

That sounds interesting, I'd be happy to learn more about your test task :)

Hi!
I'm very interested in this opportunity. I have solid experience working with FastAPI and asynchronous programming, as well as deep knowledge of PostgreSQL and PostGIS, including complex spatial queries, indexing, and performance optimization.

In past projects, I've implemented endpoints for GeoJSON input/output, bounding box searches, and layer filtering with millions of spatial objects using PostGIS. I'm also comfortable working with Docker and async ORMs like SQLModel or Tortoise.

I can deliver a clean, well-structured REST API with full GeoJSON support, async operations, and PostGIS-backed logic. I’d be happy to go through the test task — please send over the details.

Let’s connect — I’d love to contribute to your GIS platform.

Hello, my name is Ruslan. My team and I are engaged in development
We have extensive experience in developing projects in Python using APIs and processing geospatial data.
I suggest discussing the details in private messages

Show original

Translate

Good day!

Thank you for the detailed project description and requirements. This challenge fully matches my experience and interests.

Why I am suitable for this project:
Over 3 years of experience with Python focusing on backend development, particularly with FastAPI.

Practical experience with FastAPI — created scalable REST APIs using asynchronous programming and Pydantic validation.

… Deep knowledge of PostgreSQL with PostGIS — worked with complex geospatial queries, geometry and geography types, created spatial indexes, optimized queries for large datasets.

Asynchronous database access — used SQLAlchemy 1.4+ with asyncpg driver for efficient operation.

Serialization of geospatial data into GeoJSON — ensured correct conversion of spatial types into valid GeoJSON for clients.

Performance optimization — experienced in optimizing batch inserts, indexing, and tuning PostGIS for fast geospatial data processing.

Docker — create and maintain docker-compose configurations for projects with PostGIS and FastAPI for easy deployment.

Git — a routine part of workflow, maintaining clean commit history and branch management.

How I plan to implement the tasks:
GeoJSON polygon acceptance endpoint — via POST method, with Pydantic validation, conversion to WKB, and storage in a table with geometry.

Spatial query (bbox) — GET endpoint with bounding box parameters, using PostGIS ST_Intersects function to find overlaps.

Asynchronous operation — fully asynchronous work through FastAPI and asyncpg to ensure maximum throughput.

Serialization — when returning data, convert polygons to GeoJSON using ST_AsGeoJSON and deliver valid GeoJSON to clients.

Docker configuration — create docker-compose with PostgreSQL + PostGIS service and FastAPI backend.

If interested, I am ready to provide a prototype solution or deploy a full minimal working example for evaluation.

I would be glad to join the team and help develop the geospatial platform.

Thank you for the opportunity!

Best regards,
Ruslan

Show original

Translate