Skip to content
Menu
geoMusings
  • About
geoMusings

Tag: PostGIS

Reconsidering the Spreadsheet

Posted on 2021-09-17

I’m a CIO. That means a typical day can involve a range of activities: responding to data calls for security audits, reviewing SOC2 reports of prospective platform vendors, managing subscriptions of existing vendors, handling GDPR requests, ensuring data from corporate systems is meaningful and relevant for our internal stakeholders, attending meetings of various sorts. Somewhere…

Continue Reading

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

Pages

  • About

Recent Posts

  • New Directions
  • Stripe API Pagination in FME
  • Mission Accomplished
  • Organizational Muscle Memory
  • Integrating Stripe with BigQuery

Meta

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




Web Analytics Made Easy - StatCounter


©2023 geoMusings | WordPress Theme: EcoCoded