Skip to content
Menu
geoMusings
  • About
geoMusings

Tag: PostGIS

Attribute Transfer in PostGIS Using Spatial SQL

Posted on 2020-04-06

Data conflation is a meat-and-potatoes task in most GIS workflows. There are numerous reasons one might need to get data from one data set into another. Perhaps you want to attach a new geometry type to existing attributes or a table. Or maybe you need to pull attributes from one or more data sets into…

Continue Reading

Watching COVID-19 Data for Your County with PostgreSQL and Node

Posted on 2020-03-31

I have addressed the topic of triggered notifications a couple of times on this blog previously. I’ve taken the opportunity to apply the technique to a current use case – the ability to get notifications whenever the confirmed count of COVID-19 cases changes in my county or surrounding ones. I am basing this workflow on…

Continue Reading

The One About PostGIS

Posted on 2019-03-29

James Fee and I released the next episode of our podcast this week. This month, we are taking a closer look at PostGIS and how you can get started with it. We’re both longtime users and huge fans of PostGIS, so it was fun to dig into it a little. You can check it out…

Continue Reading

Refreshing a PostGIS Materialized View in FME

Posted on 2017-06-09

I am following up my previous post with an extremely simple example using FME to kick off the refresh of a materialized view (matview) after a data import. I had never used FME prior to coming to Spatial Networks, but now I’m hooked. I’m having a really hard time finding things it can’t do. As…

Continue Reading

Working with Materialized Views in PostGIS

Posted on 2017-06-06

It’s been a few months since I’ve posted, owing mainly to getting my feet under me at Spatial Networks. About a month after I started, the company re-merged with Fulcrum, which had previously been spun off as a separate company. As a result, I’ve gotten to know the Fulcrum engineering team and have gotten to…

Continue Reading

Personal Geospatial Workflows, July 2016 Edition

Posted on 2016-07-28

It’s hard to believe, but I last touched upon this topic over two years ago, when my family and I were living in our between-houses rental. One of the goals I had when building our current house was to create a space where I could more effectively work from home. To that end, I have…

Continue Reading

Revisiting Two Old Friends: ArcGIS and PostGIS

Posted on 2016-05-06

Back in the dark old days of ArcSDE, when it first started to support PostgreSQL/PostGIS as a back-end data store, I did a series of posts about how to work with it. Of course, working with PostGIS in ArcGIS was a theme of the early days of this blog, through my association with zigGIS. Although it’s…

Continue Reading

Extending Hibernate Spatial

Posted on 2016-02-12

Java is my “Groundhog Day” language. It’s one that I use just infrequently enough to feel like I’m starting over every time a new requirement pops up. As a result of planning the system migration I discussed in my last post, I’ve been doing some work with it, which is my first sustained Java work since…

Continue Reading

Desktop GIS

Posted on 2015-08-19

I’ve found myself using desktop GIS more and more lately. While I don’t tend to think of myself as an analyst and I’ll never be confused with a cartographer, it is simply not possible to perform GIS software development without making occasional use of desktop GIS. My typical use cases involve data preparation or query…

Continue Reading

A Brief Retrospective

Posted on 2014-12-23

This is the time of year where retrospectives of the previous twelve months become all the rage as content providers have column inches and/or pixels to fill up while skipping out the door on holiday breaks. As an independent blogger, I have no such requirements and the topic of this post, while retrospective, has nothing…

Continue Reading
  • 1
  • 2
  • 3
  • Next

Pages

  • About

Recent Posts

  • Mornings and Evenings
  • Looking Back, Looking Ahead
  • Lately…
  • FME, Salesforce, and BigQuery
  • Your Culture Will Adjust

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org




Web Analytics Made Easy - StatCounter


©2021 geoMusings | WordPress Theme: EcoCoded