You will get PostGIS codes for conducting spatial queries/analysis and data engineering.
Top Rated
Project details
Did you know that databases can store geographical data? With the help of spatial extensions, a database can store the locations of stores, ATMs, hotels, streets, districts, and other points of interest. Moreover, you can use SQL queries to process this information.
In this course, you'll learn about PostGIS, a spatial extension of the PostgreSQL database. You will learn how PostGIS stores geographical data and how its basic geographical functions can be used in simple and complex SQL queries.
To make your learning process more interesting, we'll be working with both real and not-so-real places in San Francisco and the United States. Additionally, we've prepared a special surprise—some exercises will even let you see the results of your queries drawn on a real-world map!
In this course, you'll learn about PostGIS, a spatial extension of the PostgreSQL database. You will learn how PostGIS stores geographical data and how its basic geographical functions can be used in simple and complex SQL queries.
To make your learning process more interesting, we'll be working with both real and not-so-real places in San Francisco and the United States. Additionally, we've prepared a special surprise—some exercises will even let you see the results of your queries drawn on a real-world map!
Database Type
PostgreSQLWhat's included $160
These options are included with the project scope.
$160
- Delivery Time 3 days
- Number of Revisions 2
- Number of Queries 20
- Query Debugging
- Query Optimization
- Query Scheduling
- Query Analysis
- Source Code
54 reviews
(53)
(1)
(0)
(0)
(0)
This project doesn't have any reviews.
MS
Michael S.
Jul 28, 2026
Help to start up a business for poster maps
MS
Mike S.
Jun 1, 2026
Data Extraction Specialist for Real Estate Datasets
Great experience!
PF
Paul F.
Jul 4, 2025
Remote Junior to Mid-Level GIS Engineer
SL
Siyuan L.
Feb 19, 2025
GIS Mapping Specialist Needed to Create Maps from Photos
CS
Charles S.
Feb 18, 2025
Data Science, Python, Data Visualization, ETL expert
Sayyed did an excellent job on our data analysis project. He is an excellent communicator and worked hard to provide us with an insightful analysis of several datasets. I highly recommend him.
About Saied
Data Engineer | Geospatial Data Engineer | GIS Database | SQL & Python
100%
Job Success
Cairo, Egypt - 6:10 am local time
My expertise goes far beyond traditional GIS mapping. I specialize in building data pipelines, automating geospatial workflows, managing large spatial databases, and delivering high-quality datasets for business intelligence, analytics, and location-based applications.
My core expertise includes:
• Spatial Data Engineering & ETL
* Python (Pandas, GeoPandas, Shapely)
* PostGIS & PostgreSQL
* SQL optimization and spatial queries
* FME Flow automation
* Data cleaning, validation, and transformation
* GeoParquet and modern geospatial data formats
• GIS & Spatial Analysis
* ArcGIS Pro
* ArcGIS Online
* Esri Business Analyst
* QGIS
* JOSM / OpenStreetMap
* Network analysis
* Demographic and market analysis
* Spatial statistics
• Automation & Backend Processing
* Python automation
* Batch geoprocessing
* REST API integration
* Large-scale data processing
* Report generation
* Workflow optimization
• Databases & Cloud Data
* PostgreSQL/PostGIS
* Spatial indexing
* Query optimization
* Data modeling
* Feature engineering
* Large geospatial datasets
Throughout my career, I've worked with organizations ranging from startups to enterprise clients across telecommunications, education, mapping, and location intelligence. My projects have included demographic analysis, business intelligence, network planning, spatial ETL pipelines, OpenStreetMap data management, geospatial reporting, and enterprise GIS solutions.
I focus on delivering solutions that are accurate, automated, maintainable, and scalable. Whether you need a one-time spatial analysis, a complex PostGIS solution, Python automation, or a complete geospatial data pipeline, I can help turn your data into meaningful insights.
If you're looking for someone who understands both GIS and modern data engineering practices, let's discuss your project.
Steps for completing your project
After purchasing the project, send requirements so Saied can start the project.
Delivery time starts when Saied receives requirements from you.
Saied works on your project following the steps below.
Revisions may occur after the delivery date.
Checking data.
Checking the data as per data types, column names, and defining the columns that we need to focus on.
Data cleaning
If there are miss-lead data, we need to run some cleaning processes like dropping the empty cells, and the not important columns.