Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get geospatial capabilities on your PostgreSQL database using PostGIS

Mark B.Status: Offline
Mark B.
Preview image

Let a pro handle the details

Buy Database Optimization & Design services from Mark, priced and ready to go.
Mark B.Status: Offline
Mark B.
Preview image

Let a pro handle the details

Buy Database Optimization & Design services from Mark, priced and ready to go.

Project details

āœ… Expert with geospatial/location data, with 15 years experience with PostGIS on PostgreSQL
āœ… Expert at database architecture
āœ… Expert at developing SQL and PostGIS function queries

Over the past 15 years, I have helped several commercial clients of my LLC implement their first geospatial database to help them answer "Where?" These clients have included retail, manufacturing, agribusiness, and logistics.

I will provide for you:

* A 30-60 minute consultation (based upon level) to review your data and goals
* A solid database design for your geospatial data
* Installation of PostGIS on your PostgreSQL database
* Implementation of the database design above
* Loading of your data
* A 30-minute post-project review

Optionally, I will also
* Load US Census TIGER or Open Street Map geospatial data
* Create SQL queries for your data
Database Type
PostgreSQL
What's included
Service Tiers Starter
$150
Standard
$500
Advanced
$1,000
Delivery Time 2 days 4 days 7 days
Number of Revisions
135
Number of Tables Added
21020
Schema Diagram
-
Permissions Setup
Import/Export Data
Admin Panel Setup
-
-
Optional add-ons You can add these on the next page.
Additional Revision
+$25
Additional Table Added (+ 1 Day)
+$50
Schema Diagram (+ 1 Day)
+$50
Admin Panel Setup (+ 1 Day)
+$50
Spatial data SQL query creation (+ 1 Day)
+$75
Load US Census TIGER national boundaries, features, and geocoder (+ 2 Days)
+$75
Load US Census TIGER state level boundaries and features (+ 2 Days)
+$75
Mark B.Status: Offline

About Mark

Mark B.Status: Offline
Data Scientist
Pleasant Hill, United StatesĀ - 6:21 pm local time
I'm a results-oriented data scientist, with 15 years experience helping companies become more profitable through data. Fluent in data analysis, mathematical & statistical modeling, simulation, and machine learning/neural networks. My passions are geospatial/location and time-series data analysis.

Toolkits:
Data Science: R, Python, Julia, GeoPandas, PostGIS, GeoJSON, Octave, Scikit, Scikit-learn, PyTorch, NumPy, SciPy, Pandas, MatPlotLib
Data Engineering: PostgreSQL, MySQL, SQL Server, AWS S3, AWS RedShift, AWS RDB, AIrflow, Kafka
End-user: Tableau, PowerBI

Steps for completing your project

After purchasing the project, send requirements so Mark can start the project.

Delivery time starts when Mark receives requirements from you.

Mark works on your project following the steps below.

Revisions may occur after the delivery date.

Client selects level and purchases project

Schedule a 30-60 minute consultation to review data and goals

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