You will get PostGIS codes for conducting spatial queries/analysis and data engineering.

Sayyed F.
Sayyed F. Sayyed F.
5.0
Top Rated Plus

Let a pro handle the details

Buy Database Queries services from Sayyed, priced and ready to go.

You will get PostGIS codes for conducting spatial queries/analysis and data engineering.

Sayyed F.
Sayyed F. Sayyed F.
5.0
Top Rated Plus

What's included $160

PostGIS coding

PostGIS codes for spatial database queries.

  • Delivery Time 3 days
  • Number of Revisions 2
  • Number of Queries 20
    • Query Debugging
    • Query Optimization
    • Query Scheduling
    • Query Analysis
    • Source Code
3 days delivery — Mar 8, 2024
Revisions may occur after this date.
Upwork Payment Protection
Fund the project upfront. Sayyed gets paid once you are satisfied with the work.

Let a pro handle the details

Buy Database Queries services from Sayyed, priced and ready to go.

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!
Database Type
PostgreSQL
What'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
5.0
48 reviews
3 stars
(0)
2 stars
(0)
1 star
(0)
Rating breakdown
Availability
5.0
Deadlines
5.0
Skills
4.9
Quality
5.0
Cooperation
5.0
Communication
5.0

TE

Tarek E.
5.00
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.
5.00
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.

JM

John M.
5.00
Jun 8, 2023
Create GIS Shapefiles From Dataset Worked efficiently and quickly. Will use again.

BG

Bruno G.
5.00
Jan 13, 2023
PostGIS Expert - Consultation with spatial query Sayyed is great, super recommend it. He asks good questions, proactively seeks answers, and is reliable and hard-working.

ks

keith s.
5.00
Oct 27, 2022
Map Expert to simplify geojson files
Sayyed F.

About Sayyed

Sayyed F.
GIS Expert | Unlocking Business Insights through Data
100% Job Success
5.0  (48 reviews)
Cairo, Egypt - 3:29 am local time
Hello and welcome to my profile! I specialize in transforming data into valuable insights that drive business success. As a Geospatial Data Analyst, I offer a comprehensive range of services designed to help businesses thrive in today's data-driven world.

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.

🌍 Web Scraping: I specialize in automating data extraction from various sources, including web scraping and geospatial data extraction from platforms like Google Maps and OpenStreetMap.

💾 Data Management: 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, Beautiful Soup, Selenium, requests, psycopg2, SqlAlchemy + GeoAlchemy, Shapely, OSMnx, NetworkX, Pandas, Geemap, and Folium.
- Database Management: SQL, with expertise in PostgreSQL and PostGIS.
- Spatial Data Sources: I tap into sources like OpenStreetMap (OSM) 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
Justice and Crim
With a Bachelor's degree in Geography with 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.

Review the work, release payment, and leave feedback to Sayyed.