Holly PostGIS

/Holly PostGIS

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

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

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

Two great things that taste great together: PostGIS and PostgreSQL

In my past life as a geospatial DBA, I had to navigate users and managers who belonged to different database teams (PostgreSQL, MySQL, SQL Server, Oracle, etc). When I was lucky enough to work in a shop that supported open source solutions, I was often asked by members of team MySQL, “Why should we use PostgreSQL [...]

By | October 17th, 2016|Categories: Holly PostGIS|Tags: , , |1 Comment

Why are you still paying for your GIS when you can get it for free?

If you haven’t switched to open source solutions (FREE!), then you have probably fallen for some common misconceptions/myths: MYTH: Open source tools are buggy. Does software have bugs? Of course. It was made by humans! But open source has the benefit of a strong community that can crowdsource fixes because the code base is not [...]

By | October 4th, 2016|Categories: Holly PostGIS|Tags: , , , , , |0 Comments