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

4.9

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

4.9

What's included $160

  • Delivery Time3 days
  • Number of Revisions2
  • Number of Queries20
    • Query Debugging
    • Query Optimization
    • Query Scheduling
    • Query Analysis
    • Source Code
3 days delivery — Dec 8, 2022
Revisions may occur after this date.
Upwork Payment Protection

Fund the project upfront. Sayyed gets paid once you are satisfied with the work.

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 Time3 days
  • Number of Revisions2
  • Number of Queries20
    • Query Debugging
    • Query Optimization
    • Query Scheduling
    • Query Analysis
    • Source Code

Customize this project

If you're not seeing exactly what you need here, send Sayyed a custom request. You can talk about the price and timeline to create a personalized project.

4.9
46 reviews
96% Complete
4% Complete
3 stars
1% Complete
(0)
2 stars
1% Complete
(0)
1 star
1% Complete
(0)
Rating breakdown
Availability
5.0
Deadlines
4.9
Skills
4.9
Cooperation
5.0
Quality
4.9
Communication
5.0

ks

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

KY

Kandai Y.
5.00
May 24, 2022
OSM Edits Experts

GG

Gary G.
5.00
Aug 16, 2021
Mapbox or Open Street Maps developer/style designer Job well done  

SK

Sebastian K.
5.00
Aug 15, 2021
Convert SHP to OSM map

BE

Ben E.
5.00
Jan 3, 2021
GIS Spatial Analyst - Clean, Analyze and Process Customer Projects Sayyed was an excellent team member and would be welcomed back any time.  

About Sayyed

Sayyed F.
GIS Analyst | Modern GIS | Python
100% Job Success
Cairo, Egypt - 1:52 pm local time
At a certain point, any business depends on turning data into information to expand. So, we have the opportunity to do so by contributing to your project/business through these applicable elements:

- Running spatial queries and data engineering/analysis by PostGIS which could help with business development like Lead Generation.
- Data Cleaning, Analysis, and Processing using Pandas & Geopandas Python tools.
- Using Python packages/liberaries/modules like (OSMnx, Folium, ... and NetworkX).
- Web GIS backend technologies (GeoPandas and PostGIS).
- GIS purposes include Land Development, Infrastructure monitoring, and design, Land use, Land Ownership, Real estate research etc...
- Creating SVG/vector maps and WMS layers to integrate them into websites/web apps.
- Data visualization on maps and infographics.
- GIS/CAD data production, conversions, and visualization.
- Geocoding addresses.
- Creating styled maps on Mapbox Studio, and exporting them with the desired layout via ArcMap.
- Extracting GIS data (geoJSON and other formats) from OSM (OpenStreetMap) via Overpass API and Python.
- Using JOSM for updating /contributing OSM.
- Conversion between spatial data formats ( DWG, DXF, KML, KMZ, CSV, and Shapefile ).
- Outdoor, Hiking, Climbing, Camping, Biking, and Trekking maps.
- Maps for many platforms like (Books/E-Books, Magazines, Websites, Articles, Brochures, ... etc).
- Creating maps with suitable layouts via ArcGIS.

I have a Bachelor's degree in Geography, Branch of Geographic Information systems (GIS).

I have worked on a large number of projects about mapping and GIS, as I have clients from the U.K, Australia, U.S, Oman, Germany, Canada, Sweden, Austria, and Denmark.

Check my portfolio for examples of my work in various GIS industry projects

Skills tags: GIS - Geospatial - Big Data - GIS Analysis - Geo-Python - Python - Data Analytics - Spatial - Geometry - Geography - PostGIS - Spatial Query - Spatial Join - Geopandas - Pandas - ArcGIS Pro - Fiber Network - OpenStreetMap - OSM - GIS Mapping - QGIS - Data Cleaning - Data Manipulation - Geoprocessing - Geocoding - Mapbox - GeoJSON - Nearnet Analysis - JOSM - ESRI - Heatmap - Network Analysis - Geopackage - AutoGIS - KML - KMZ - GeoDatabase - MapInfo - Network Graph - Databases - Spatialite database - Data Processing - Web Feature Service (WFS) - Geometric operations - Data reclassification - Data Visualization - Spatial Index - GDAL - Folium - OSMnx - NetworkX - DataFrame - CSV - GeoDataFrame - GeoSeries - Automation - Map projections - Cartography & Maps - Overpass API - Digitizing - Leafmap - Leaflet - Data Extraction - Web Mapping - Real Estate - Internet - Communications - Fiber - Wires - Power - Utilities - National Parks - Hiking Trails - Streets - POI - Stores - Addresses - Buildings - Econometric Forecasting Models - Business Intelligence - Census Data - DSL - Cables - Wholesale - Internet Data Analysis - Statistical Analysis - Spatial Autocorrelation - Data Wrangling
 

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.