Books we've written

SQL in a Nutshell 4th


PostGIS in Action 1st, 2nd, 3rd editions
check out our book and download the first chapter and SQL primer free.

Tips and Tricks for PostGIS 3rd edition

PostgreSQL: Up and Running (1st, 2nd, and 3rd Editions)
PostgreSQL: Up and Running

pgRouting: A Practical Guide
Learn how to build applications with road routing and vehicle resource management considerations using pgRouting, PostGIS, and PostgreSQL.

Tips and Tricks for pgRouting 2+

We provide both consulting and training.

Consulting work

Consulting work includes building custom applications for your organization or fixing and supporting your existing applications. It also includes technical support for the applications and training your staff on using the applications.

On-site work rates will be negotiated on a case by case basis, but will generally fall in the $400-$600/hr range plus travel expenses.

To get established as a customer we require prepayment (only off-site / on-site requires negotiation) before beginning work of $300/hr for less than 10 hrs and $200/hr for 10 hrs ($2000 total). Once an established customer (a customer who has paid for 10 or more hours of work), you will be billed monthly at the below rates. The 10 hr pre-payment must be used within a year of payment.

Rates listed below are for work done on our premises (off-site work).

Project-Based work is pre-billed 20% of the estimated cost before work can begin with a minimum 10-hour pre-payment requirement for new customers. Project work is any work deemed to require 10 or more hours worth of work and that a quote is requested.


$104 / hour
  • Manual Legacy Data Conversion and Scrubbing
  • Basic QA Testing
$140 / hour
  • ASP.NET
  • Conversion from ASP to ASP.NET or PHP
  • Visual Basic 6, VB.NET, C#
  • PHP, PHP Smarty, PHP ADODB
  • Web Page Development (HTML, XML, XSL, CSS, JavaScript)
  • JQuery with server-side PHP, ASP.NET
  • Angular and AngularJS
$200 / hour
  • PostgreSQL query tuning, auditing of existing queries, general support with various extensions
  • PostgreSQL / PostGIS Installation and upgrade on windows, Linux, and FreeBSD
  • PostGIS Spatial Database Engine (all versions) and pgRouting - Queries, Query optimization, Tuning, PL/PGSQL, SQL Programming. Help with upgrade to newer versions of PostgreSQL.
  • Geocoding / Reverse Geocoding using PostGIS + TIGER (or other data)
  • Real Estate Analysis
  • Microsoft Access Database to PostgreSQL Conversion
  • MySQL to PostgreSQL Conversion
  • Relational Database Design and Analysis
  • SQL Server to PostgreSQL Conversion
  • Oracle to PostgreSQL Conversion
  • Microsoft Access
  • Internet Information Server Web server setup and administration (5 / 6 / 7 / 8 / 10 )
  • Nginx web server
  • Apache2 web server
  • Legacy Data Conversion and Scrubbing Script Programming (Paragon developed applications)
  • Database Connectivity (ADO.NET, ADO, DAO, ODBC)
  • Office Visual Basic for Applications VBA (Word and Excel Automation)
$296 / hour
  • Data migration from non-Paragon developed application data structure to another non-Paragon developed application data structure.1
1 This includes conversions from same database systems or different and conversion of stored procedures and functions. By non-Paragon, we mean applications that we did not develop. Applications we develop we charge the lower rate ($200 / hr) to convert a different system to our system.

Policy

Please contact us for rates for services not listed above. Minimum billing is 15 minutes.

We provide free estimates on planned projects or application enhancements. Just send us a description of your project at and we will be happy to provide an estimate.

To minimize costs, we try to do most work remote. Expedited and emergency services are available at an extra cost.

One-on-one / small group training and mentoring

One-on-one training is done virtually (via e-mail or screen share) and is always pre-paid for new clients. Existing clients get billed monthly as part of their bill. The training can be split up in increments of 15 minutes if desired and will focus on your specific trouble-areas.

$300/hr for 9 hours or less with minimum billing of 1 hr, $2000 for 10 hrs

Group training costs are negotiated on a case by case basis but for on-site will fall in the $450-$500/hr range and dependent on number of people in group and hours required. The more hours the lower the rate. Training preparation will be billed at our off-site rate of $200/hr.

Our specialities are the following

  • PostGIS - query writing and tuning
  • PostgreSQL query optimization
  • pgRouting
  • SQL
  • Relational Database Design
Check out our past presentations on PostGIS and PostgreSQL Past Conference Presentations and Trainings.
For GIS related tips and concepts, check out our Boston GIS tutorial site.
For PostgreSQL related tips and concepts, check out our Postgres OnLine Journal site.