Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more

Posts about Spatial

  • 6 min read

    Performance Improvements in GEOS

    Paul Ramsey

    We at Crunchy Data put as much development effort into improving GEOS as we do improving PostGIS proper, because the GEOS library is so central to much geospatial processing.

    The GEOS library is a core piece of PostGIS. It is the library that provides all the "hard" computational geometry functionality:

    • Intersections of geometry
    • Unions of geometry
    • Differences of geometry
    • Buffers of geometry
    • Geometry relationship evaluation
    Read More
  • 8 min read

    ArcGIS Feature Service to PostGIS: The QGIS Way

    Kat Batuigas

    As a GIS newbie, I've been trying to use local open data for my own learning projects. I recently relocated to Tampa, Florida and was browsing through the City of Tampa open data portal and saw that they have a Public Art map

    Read More
  • Loading Data into PostGIS: An Overview

    Kat Batuigas

    There are a lot of ways to load data into a PostgreSQL/PostGIS database and it's no different with spatial data. If you're new to PostGIS, you've come to the right place. In this blog post, I'll outline a few free, open source tools you can use for your spatial data import needs.

    You can use a desktop GUI application like QGIS, and/or command-line utilities. If you want more flexibility, it's great to have both types in your toolkit.

    I'll talk about importing to PostGIS within the context of vector data, since it's a much more common use case. It's possible to import raster data

    Read More
  • PostGIS Raster and Crunchy Bridge

    Paul Ramsey

    The PostGIS raster extension has a steep learning curve, but it opens up some unique possibilities for data analysis and accessing non-standard data from within PostgreSQL. Here's an example that shows how to access raster data from PostGIS running on Crunchy Bridge

    Read More
  • 4 min read

    Waiting for PostGIS 3.1: GEOS 3.9

    Paul Ramsey

    While we talk about "PostGIS" like it's one thing, it's actually the collection of a number of specialized geospatial libraries, along with a bunch of code of its own.

    • PostGIS provides core functionality
      • bindings to PostgreSQL, the types and indexes
    Read More
  • 7 min read

    PostGIS Day 2020 Roundup

    Kat Batuigas

    Crunchy Data's second annual PostGIS Day took place a couple weeks ago on November 19th, and as a first-time attendee I was blown away by the knowledge-sharing and sense of community that I saw, even as I was tuning in remotely from my computer at home. This year's PostGIS Day

    Read More
  • 2 min read

    Waiting for PostGIS 3.1: Grid Generators

    Paul Ramsey

    Summarizing data against a fixed grid is a common way of preparing data for analysis. Fixed grids have some advantages over natural and administrative boundaries:

    • No appeal to higher authorities
    • Equal unit areas
    • Equal distances between cells
    • Good for passing data from the "spatial" computational realm to a "non-spatial" realm
    Read More
  • 3 min read

    Waiting for PostGIS 3.1: Performance

    Paul Ramsey

    Open source developers sometimes have a hard time figuring out what feature to focus on to generate the greatest value for end users. As a result, they will often default to performance.

    Performance is the one feature that every user approves of. The software will keep on doing all the same cool stuff, only faster

    Read More
  • 4 min read

    Virtual PostGIS Day 2020 is Nov. 19

    Crunchy Data

    Authored by Steve Pousty

    Today we are going to talk a little bit about spatial databases and a virtual event Crunchy Data is hosting with several friends and community members. We're putting together an awesome PostGIS Day

    Read More
  • 14 min read

    Using Postgres and pgRouting To Explore The Smooth Waves of Yacht Rock

    John Porvaznik

    pgRouting is a powerful routing tool, usually used for pathfinding/mapping/direction applications. (See Paul Ramsey's introduction to pgRouting here). It is, however, also a robust graph db implementation, and can be used for much more than just finding the directions to your great aunt Tildy’s.

    Read More