Skip to content
Menu
geoMusings
  • About
geoMusings

Tag: GIS

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

Analyzing Location Change Over Time in BigQuery

Posted on 2021-02-22

I’ve recently spent a lot of time doing various forms of business analytics in BigQuery. As discussed in a previous post, I’ve been using BigQuery as the data integration environment for several business systems. I’ve found integration at the data level via an ETL/ELT/IPaaS pipeline to be a lot more stable than system-level integrations that…

Continue Reading

Lately…

Posted on 2020-10-25

These are some of the things I’ve been up to lately, while the blog has been quiet: At work, I’ve continued delving into BigQuery. Our FME jobs are running like clockwork and I’ve been spending a lot of time writing queries and doing analysis for various stakeholders across the company. The next phase of the…

Continue Reading

FME, Salesforce, and BigQuery

Posted on 2020-09-04

More often that not in my current role, opportunities to get my hands dirty come from the data side of our operation rather than the engineering side. These days, the data side involves corporate data rather than a lot of geospatial data. If I were to be guided by my own personal inertia, I’d drift…

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

Fulcrum Query API and Koop

Posted on 2020-03-20

I don’t write code as much as I used to, but I have to return to it every so often to keep my sanity. With the current world situation, there are a lot of dashboards going up, many of which are based on the Esri Operations Dashboard or ArcGIS Hub. I got thinking about a…

Continue Reading

Milestones, Goals, and the Power of No

Posted on 2019-11-21

It’s been a few weeks since I hit my latest milestone, but life was fairly full in the immediate aftermath. On the plus side, the extra time was good for reflection. The milestone to which I am referring is that, on October 27, 2019, I ran the Marine Corps Marathon in Washington, DC. The race…

Continue Reading

Ron Lake – The Man In the Arena

Posted on 2019-09-06

It is not the critic who counts; not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood; who strives valiantly; who…

Continue Reading

Hello, Discipline, My Old Friend

Posted on 2019-08-16

It wasn’t that long ago that I was “always on” in terms of work. There is a certain ethos in the DC area that rewards that outlook and I was fairly good at it. This was compounded by the fact that I was a partner in my company and the buck always stops with the…

Continue Reading
  • 1
  • 2
  • 3
  • 4
  • …
  • 11
  • Next

Pages

  • About

Recent Posts

  • Analyzing Location Change Over Time in PostGIS
  • Analyzing Location Change Over Time in BigQuery
  • Mornings and Evenings
  • Looking Back, Looking Ahead
  • Lately…

Meta

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




Web Analytics Made Easy - StatCounter


©2021 geoMusings | WordPress Theme: EcoCoded