You will get PostGIS Spatial Database Design & Setup
Project details
Your spatial data deserves a proper database — not scattered shapefiles on a shared drive.
I design and build PostgreSQL/PostGIS databases for organizations that manage spatial assets: utility networks, infrastructure, environmental monitoring, and urban planning data.
As Head of GIS at Tunisia's National Sanitation Office, I designed and manage a PostGIS database covering 20,000+ km of sanitation networks — serving 300+ users daily.
WHAT I DELIVER:
→ Custom PostGIS schema designed for your data model and business needs
→ Data migration from your existing sources (Shapefiles, CSV, KML, GeoPackage, Excel, other databases)
→ Spatial indexing and query optimization
→ Data validation, topology checks, and quality assurance
→ Documentation: schema diagram, data dictionary, connection guide
OPTIONAL ADD-ONS:
→ QGIS project pre-configured to connect to your new database
→ FME workflows for automated data updates (ETL)
→ SQL views and functions for common spatial queries
Tell me about your data and I'll propose the right architecture.
I design and build PostgreSQL/PostGIS databases for organizations that manage spatial assets: utility networks, infrastructure, environmental monitoring, and urban planning data.
As Head of GIS at Tunisia's National Sanitation Office, I designed and manage a PostGIS database covering 20,000+ km of sanitation networks — serving 300+ users daily.
WHAT I DELIVER:
→ Custom PostGIS schema designed for your data model and business needs
→ Data migration from your existing sources (Shapefiles, CSV, KML, GeoPackage, Excel, other databases)
→ Spatial indexing and query optimization
→ Data validation, topology checks, and quality assurance
→ Documentation: schema diagram, data dictionary, connection guide
OPTIONAL ADD-ONS:
→ QGIS project pre-configured to connect to your new database
→ FME workflows for automated data updates (ETL)
→ SQL views and functions for common spatial queries
Tell me about your data and I'll propose the right architecture.
Database Type
PostgreSQLWhat's included
| Service Tiers |
Starter
$300
|
Standard
$600
|
Advanced
$1,000
|
|---|---|---|---|
| Delivery Time | 5 days | 8 days | 12 days |
Number of Revisions | 1 | 2 | 3 |
Number of Tables Added | 5 | 15 | 30 |
Schema Diagram | |||
Permissions Setup | - | ||
Import/Export Data | |||
Admin Panel Setup | - | - |
Optional add-ons
You can add these on the next page.
FME ETL workflow for automated updates
+$200
SQL views & spatial query functions
+$150
Pre-configured QGIS project file
+$75Frequently asked questions
About Anis
Senior GIS & Hydraulic Engineer | QGIS/ArcGIS PostGIS - Python | 17+ Y
Tunis, Tunisia - 11:43 am local time
As Head of GIS at Tunisia's National Sanitation Office, I designed and deployed a national-scale GIS covering 20,000+ km of sanitation networks, used daily by 300+ operators for planning, maintenance, and investment decisions. This was a €1.3M AFD-funded digital transformation project that I led from scoping through production over 5 years.
What sets me apart: I combine deep GIS/geomatics expertise with hydraulic engineering — a rare profile that lets me understand both the data infrastructure and the physical networks it represents.
WHAT I CAN DO FOR YOU:
→ Spatial Database Design & Management
PostgreSQL/PostGIS architecture, enterprise geodatabases (SDE), data migration, ETL pipelines with FME Desktop. I've designed and managed databases covering 20,000+ km of infrastructure networks.
→ Web GIS Application Development
Full-stack web mapping with Lizmap, QGIS Server, GeoServer, Leaflet, and OpenLayers. I've built production platforms including an epidemiological monitoring system and a national network management application.
→ GIS Automation & Data Processing
Python/PyQGIS scripting that reduced our spatial data processing time by 40%. Custom geoprocessing workflows, batch cartographic production, automated quality control.
→ Mobile Field Data Collection
QField/QFieldSync solutions for field teams. I designed a mobile data collection app that improved field data accuracy by 60% for 50+ field agents.
→ Cartography & Spatial Analysis
Professional thematic mapping, multi-criteria analysis for infrastructure planning, network rehabilitation prioritization. ArcGIS Pro 3.x and QGIS advanced analysis.
→ Hydraulic Modeling Integration
HEC-RAS, MIKE URBAN, EPANET, SewerGEMS — with the ability to integrate modeling results into GIS for visualization and decision support.
CREDENTIALS:
- Master's in Geomatics + Engineering Degree in Civil Engineering/Hydraulics (ENIT, Tunisia)
- 17+ years of progressive experience in GIS and infrastructure management
- 8+ donor-funded projects managed (AFD, EIB) — total budget ~€4.5M
- ISO 19115/19139/INSPIRE metadata standards expertise
- Trilingual: Arabic (Native), French (Fluent), English (Professional)
I'm available for projects worldwide and work comfortably across time zones. Let's discuss how I can help with your geospatial challenge.
Steps for completing your project
After purchasing the project, send requirements so Anis can start the project.
Delivery time starts when Anis receives requirements from you.
Anis works on your project following the steps below.
Revisions may occur after the delivery date.
Data audit and schema design
I review your data sources, analyze structure and quality, then design a PostGIS schema tailored to your needs. You receive a schema diagram for approval before I build.
Database build and data migration
I create the database, build tables with proper types, constraints, and spatial indexes. I migrate, clean, and validate all your data into the new structure.