Skip to content
Menu
geoMusings
  • About
geoMusings

Tag: PostGIS

Return on Non-Investment

Posted on 2021-04-07

Yesterday evening, I had the pleasure of participating in a panel discussion on Clubhouse, hosted by Todd Barr and Jordan Cullen, and including Will Cadell of SparkGeo. Clubhouse seems to be a really convenient venue for setting up such a forum with low barriers to entry, so that was enjoyable. The topic of the discussion…

Continue Reading

Analyzing Location Change Over Time in PostGIS

Posted on 2021-02-27

Following up on my previous post, I decided to attempt the same analysis in PostgreSQL. The analysis doesn’t make use of any spatial logic itself (yet), but I consider this a PostGIS post because it is using PostGIS geometries. In the past, I have noticed that BigQuery SQL is very reminiscent of that of PostgreSQL,…

Continue Reading

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
  • 1
  • 2
  • 3
  • Next

Pages

  • About

Recent Posts

  • Return on Non-Investment
  • BigQuery and Koop
  • Routing with BigQuery and ArcGIS Platform APIs
  • Analyzing Location Change Over Time in PostGIS
  • Analyzing Location Change Over Time in BigQuery

Meta

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




Web Analytics Made Easy - StatCounter


©2021 geoMusings | WordPress Theme: EcoCoded