hollyo

/Holly Orr

About Holly Orr

Holly Orr has spent the past 20+ years working in IT departments and geospatial labs on the east and west coasts. Her journey has taken her from jobs as desktop and web developer, database administrator, data steward, analyst, help desk, and GIS educator. Holly has an MS in Information and Knowledge Strategy from Columbia University and a BA in Political Science with a minor in Geography from Temple University. She has taught graduate level GIS courses at NYU and Hunter College. In a past life, Holly toured in a rock band playing lead electric guitar. Today, when she isn’t attending her son’s break dancing recitals, she plays for fun in her rock band, Giant Gowanus.

Connecting to Remote Spatial Data Sources with ogr_fdw

Shout out goes to Regina Obe and Paul Ramsey for their work and documentation on ogr_fdw. The ogr_fdw project can be found here: https://github.com/pramsey/pgsql-ogr-fdw. ogr+fdw = ogr_fdw In an earlier post, I showed you how to use the ogr2ogr (or as my geogeek friends like to call it "ogre to ogre") command line tool to [...]

By | May 25th, 2017|Categories: Uncategorized|Tags: , , , , , , , |0 Comments

Install PostgreSQL 10 Today

Hey, have you heard? PostgreSQL 10 Beta is road ready! Kick the tires and take the cool new features and improvements out for a spin. Highlights include: Declarative Partitioning Logical Replication SCRAM Authentication See the full list of features here. Take the easy route Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy [...]

By | May 19th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , |2 Comments

Installing pgDevOps

Install in 6 easy steps Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy steps. Already have BigSQL pgc installed? Jump to step #3. Read this short introduction to BigSQL's package and update manager (pgc). Install pgc via command line to a sandbox: MAC / Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell [...]

DevOps: Can’t we just all get along?

pgDevOps will help your developers and operations teams work collaboratively, efficiently, and openly. To understand the value added when you include pgDevOps in your PostgreSQL tool-chain, keep reading. tldr; Go straight to the tutorial to start using pgDevOps today! Why DevOps: A brief explainer First a little background to better understand why BigSQL built pgDevops. [...]

By | May 15th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , |2 Comments

ETL (Extract, Transform, Load) PostGIS Data with ogr2ogr

In an earlier post, I showed you how to use the shp2pgsql tool to import shapefiles into PostGIS. But what if you need to import other geodata formats (e.g. GeoJSON, MapInfo, KML, CSV, etc.)? ogr2ogr - ETL for PostGIS Lucky for you, the BigSQL PostGIS distribution comes bundled with GDAL and the ogr2ogr (or as [...]

By | April 24th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , |2 Comments

BIG NEWS from BigSQL: Introducing pgDevOps!

To help our colleagues at OpenSCG provide better service to our clients, BigSQL developed pgDevOps - a one stop shop to provision, develop, and monitor PostgreSQL databases. And now... we are making pgDevOps available to the PostgreSQL community! How Does pgDevOps Help? Install and Provision: Package Manager: One-click installs of PostgreSQL [...]

By | March 30th, 2017|Categories: BigSQL, Holly PostgreSQL, OpenSource|Tags: , , , , , , |0 Comments

Importing Shapefiles into PostGIS with shp2pgsql

Geojson may be catching up, but by and far the most popular data format for sharing geospatial data is (and has been since the early 1990's) the shapefile. Although a shapefile is a simple way to share data that can be easily consumed by almost any GIS system, it comes with many limitations and is [...]

By | March 23rd, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , |1 Comment

How to Save Money: Migrating from Oracle DW to AWS RDS PostgreSQL

How do you migrate a large, expensive, and on premises Oracle data warehouse to a free, open source, and cloud hosted database? PostgreSQL + Amazon RDS + OpenSCG (of course) The Customer A leader in the GPS (Global Positioning System) market has a fleet management product that provides businesses with real-time visibility of vehicle location, [...]

By | March 13th, 2017|Categories: Case Studies|Tags: , , |2 Comments

PostGIS – How to create a Spatial Database with PGC Command Line

We are excited to announce that BigSQL distributions of PostGIS now come bundled with several popular community spatial extensions: postgis fuzzystrmatch postgis_tiger_geocoder postgis_topology ogr_fdw address_standardizer address_standardizer_data_us This is the only community distribution to offer PostGIS with these extensions across ALL platforms (Mac, Linux, and Windows)! So, for all you GeoGeeks using Linux / Mac - [...]

By | February 10th, 2017|Categories: Holly PostGIS|Tags: , , |1 Comment

Are you a Yoda or a Diego?

In the geospatial world there are usually 2 types of people supporting spatially enabled databases: 1. GIS analysts  (scientist, statisticians, analysts, etc) who find themselves as the de facto DBA (among other things). “I don’t have time for this! I’m saving this sea turtle. Just give me a GUI!” 2. DBAs who find themselves supporting these strange [...]

By | February 8th, 2017|Categories: Holly PostGIS|0 Comments