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

Sayyed F. Sayyed F.

4.9

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

Sayyed F. Sayyed F.

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

4.9

46 reviews

5 stars

96% Complete

(44)

4 stars

4% Complete

(2)

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

Map Expert to simplify geojson files

OSM Edits Experts

Mapbox or Open Street Maps developer/style designer Job well done

Convert SHP to OSM map

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

About Sayyed

GIS Analyst | Modern GIS | Python

100% Job Success

Cairo, Egypt - 1:52 pm local time

View profile

View portfolio

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.