Leo Hsu and Regina Obe

Co-Founder at Paragon Corporation

About

Regina Obe and Leo Hsu are co-founders of Paragon Corporation, a database and web application consulting company based in Boston. They have extensive experience with PostGIS and PostgreSQL. They are co-authors of PostGIS in Action (1st and 2nd editions) (publisher Manning) and PostgreSQL: Up and Running (1st and 2nd editions) (publisher O'Reilly).

They are currently working on more books, pgRouting: a Practical Guide, (publisher LocatePress) and PostgreSQL: Up and Running (3rd edition).

Leo Hsu and Regina Obe has presented the following presentations

    Leo Hsu and Regina Obe Getting Stuff done with PostGIS at PGConf US 2017 [PgConf.US]

    presented by Leo Hsu and Regina Obe

    If you want to follow along on your laptop, you should already have PostGIS 2.3 and PostgreSQL 9.6 installed as well as QGIS desktop software. For those who don't have time to prep but still want to follow along, we'll have a test server available with ability to run queries using pgAdmin4. This workshop will cover the following topics: Overview of the 2 core vector types geometry and geography...

    more

    Tue 28 2017 Training
    Leo Hsu and Regina Obe Top 10 Problems Solved by PostGIS at PGConf US 2017 [PgConf.US]

    presented by Leo Hsu and Regina Obe


    video

    We'll cover 10 problems where we've found PostGIS to be the easiest and fastest tool for the job. Areas covered will be: Proximity Analysis Statistical aggregation of data by location Mapping Routing Geocoding Unlikely uses for PostGIS -- non-spatial problems solved by re-imagining the problem as a spatial one. Extra focus on new tricks made possible by PostGIS 2.3+ and PostgreSQL 9.6+.

    Use Cases
    Leo Hsu and Regina Obe Top 10 Problems Solved by PostGIS at PGConf US 2016 [PgConf.US]

    presented by Leo Hsu and Regina Obe

    We'll cover 10 problems where we've found PostGIS to be the easiest and fastest tool for the job. Areas covered will be: Proximity Analysis Statistical aggregation of data by location Mapping Routing Geocoding Unlikely uses for PostGIS -- non-spatial problems solved by re-imagining the problem as a spatial one.

    Development
    Leo Hsu and Regina Obe Introduction to PostGIS at PGConf US 2016 [PgConf.US]

    presented by Leo Hsu and Regina Obe

    All attendees will receive a free copy of our PostGIS In Action 2e http://www.postgis.us/chapters_edition_2 If you want to follow along on your laptop, you should already have PostGIS 2.2 and PostgreSQL 9.5 installed on your laptop as well as QGIS desktop software. This workshop will cover the following topics: What is PostGIS? and How to install it and spatially enable a database. Fundamentals...

    more

    Development
    Leo Hsu and Regina Obe PostGIS Up and Running at PGConf US 2015 [PgConf.US]

    presented by Leo Hsu and Regina Obe

    What is PostGIS? How to install it. Fundamentals of the 3 core types geometry, geography including both 2D and 3D subtypes, and raster. How to load data in geography and geometry. How you can use PostGIS for spatial analysis to help answer questions about where and how far using spatial SQL. Visualizing answers to spatial questions with Open Source desktop spatial tools.

    GIS