You will get PostGIS codes for conducting spatial queries/analysis and data engineering.
Top Rated
You will get PostGIS codes for conducting spatial queries/analysis and data engineering.
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
51 reviews
(50)
(1)
(0)
(0)
(0)
This project doesn't have any reviews.
SL
Sharon 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.
RS
Robbie S.
Apr 29, 2024
Help with Maps!
TE
Tarek E.
Dec 24, 2023
Geospatial Data Integration Specialist
Sayyed Farag was a great help and allowed us to understand more about our project
LL
Lori L.
Aug 9, 2023
Need GIS for a mapping project.
Sayyed did a excellent job at communicating with me about the project I need and getting it done in a timely manner.
About Sayyed
Data Engineer | Geospatial Engineer | GIS
100%
Job Success
Cairo, Egypt - 1:59 pm local time
My expertise spans a wide array of essential geospatial processes and spatial operations that are crucial for modern business planning and deployment. Here's how I can assist your business:
🌐 Data Intelligence: I excel in harnessing the power of location data, turning it into actionable information that can fuel your decision-making processes.
🗺️ Spatial Analysis: I have a deep understanding of GIS processes, enabling me to conduct spatial analysis that uncovers valuable trends and patterns in your data.
Data Analysis: Data Cleaning - Descriptive Analysis - Diagnostic Analysis - Statistical Analysis - Explanatory Analysis - Quantitative Analysis [Discrete - Continuous] - Qualitative/Categorical Analysis [Nominal - Ordinal].
📊 Data Visualization: I create stunning visualizations, including charts, graphs, cartography, maps, and heatmaps, to make complex data easily understandable and actionable.
🌍 Data sourcing: I specialize in automating data extraction from various sources, including web scraping and geospatial data extraction from platforms like Google Maps and OpenStreetMap.
💾 Data Engineering: I design and implement robust ETL (Extract, Transform, Load) pipelines, ensuring your data is organized, accurate, and readily accessible.
🌟 Custom Solutions: I build GIS data models and automation processes tailored to your specific needs, enhancing efficiency and productivity.
I'm well-versed in a variety of GIS technologies, including:
- GIS Software: QGIS, ArcGIS Pro, Global Mapper, Google Earth Engine, and JOSM.
- Programming: Python with GeoPandas, GDAL/ogr2ogr, requests, psycopg2, Shapely, OSMnx, NetworkX, Pandas, Geemap, and Folium.
- Database Management: SQL and spatial SQL with expertise in PostgreSQL and PostGIS.
- Spatial Data Sources: I tap into sources like OpenStreetMap (OSM), Overture Maps, and Mapbox to enrich your data.
My experience spans across diverse industries, including:
📡 Telecommunications
🌍 Tourism
🚚 Logistics and Warehousing
🏞️ Hiking and Backpacking
🚗 Transportation
✍️ Authoring and Publication
📚 Education
⛽ Oil and Gas
🏡 Real Estate
🏞️ Vacant Lands/Parcels
Hydraulic Modeling
Justice and Crime
With a bachelor's degree in geography and a strong GIS focus, I bring both academic knowledge and practical expertise to every project.
Please take a moment to explore my portfolio for a glimpse of my past work, and don't hesitate to reach out for a consultation. I'm here to help you harness the power of geospatial data to achieve your business goals.
In a rapidly evolving business landscape, let's work together to unlock the potential of your data and stay ahead of the curve.
Steps for completing your project
After purchasing the project, send requirements so Sayyed can start the project.
Delivery time starts when Sayyed receives requirements from you.
Sayyed 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.