Advertisement · 728 × 90

Posts by Gregory Power

Anything is possible with PostGIS and triggers. 👀

3 months ago 0 0 0 0
Preview
bliki: Frequency Reduces Difficulty "If it hurts - do it more often". Good advice if the amount of pain raises exponentially with the time between actions, such as for integrating software.

BTW this "Frequency Reduces Difficulty" post from @martinfowler.com is the origin of the mantra "if it hurts, do it more often" (at least, it's where I learned it). It's amazing how broadly this applies.

martinfowler.com/bliki/Freque...

6 months ago 28 4 0 1

That Project Manager extension seems pretty nifty!

6 months ago 3 0 0 0

quick while the government is shut down let’s all switch to metric

6 months ago 13900 2782 304 171

You can also do math with vim. 👀

7 months ago 1 0 0 0

Hackers:

Your goal is to launch the Calculator.

7 months ago 3 0 0 0
Post image

Someone finally wrote the data-center/electricity inflation story.

@nytimes.com #CPI
www.nytimes.com/2025/08/14/b...

8 months ago 2446 1055 104 59

My personal opinion? Not much better when it comes to the quality of the data. Is it easier to download? Maybe? osm2pgsql is a dope tool too. #gischat #geosky

1 year ago 1 0 0 0

I know Ibis integrates well with BigQuery as far as python packages go. I’m a little vendor lock-in averse. #gischat #geosky

1 year ago 1 0 0 0

I’m at a Azure/Microsoft shop for the time being. I’ll be sure to keep the GCP solution in my noggin though. #gischat #geosky

1 year ago 0 0 0 0
Advertisement

This is so cute I absolutely love it! #rstats

1 year ago 1 0 0 0

Am I crazy for wanting to use Apache Airflow and PostGIS to build a geospatial data platform for my org? Is that a dumb idea? #GISchat #geosky

1 year ago 8 2 1 0

I’m tempted to go down the rabbit hole of either GRASS functions or setting up safeguards in PostGIS to solve this problem.

1 year ago 1 0 0 0

I’ve found pixi to be pretty darn helpful for geospatial, uv is solid if you need only Python stuff. #gischat

1 year ago 3 0 0 0
GIS/MEA582: Geospatial Modeling and Analysis

Are you looking for courses? I’ve got a course on geospatial modeling that has been helpful: ncsu-geoforall-lab.github.io/geospatial-m...

1 year ago 2 1 0 0

PSA to GIS Professionals: friends don’t let friends create data products with invalid geometries. #GISchat

1 year ago 6 0 1 0

Nah, you’re good.

1 year ago 1 0 1 0
Advertisement

I was referring to the xkcd comic strip. 🤷🏼 in this case, it is what it is.

1 year ago 0 0 1 0

Instead of saving a csv, why not give Arrow a try?

1 year ago 3 0 0 0
NWS Bots for Bluesky

None of this is official, but there have been NWS bots setup to get weather info, alerts and warnings.
nws-bot.us

1 year ago 1067 281 77 31
We're not done yet | 18F

18F was doing exactly the type of work that DOGE claims to want – yet we were eliminated shortly after midnight. Read our letter to the American people:
18f.org

1 year ago 18816 6834 697 446

I remember seeing 18F at Pycon a few years back. Godspeed.

1 year ago 5 0 0 0

The administration got rid of 18F under the cover of night. People who own skyscrapers are afraid of 100 people who make websites.

Not because of the latest tech fad, but because we proved the government can be fixed, the government can be made better and the government can work for the people.

1 year ago 1144 388 19 13
Spatial SQL What is Spatial SQL? Why is it needed for querying geospatial data in a database?

Locate Press has a pretty great book on the topic: locatepress.com/book/spatial...

1 year ago 2 0 0 0
Advertisement

You may enjoy ruff as a replacement for your Python linting—it’s wicked fast.

1 year ago 1 0 0 0
Post image

OSM US voting members: make sure to submit your votes for the board by midnight on March 2nd!

Check your inbox for more info

1 year ago 3 2 0 0
Post image Post image Post image Post image

We're seeking funding to take @source.coop to the next level.

1 year ago 29 14 1 1
Preview
Why Private Forecasting Companies Can’t Replace the National Weather Service NOAA and the NWS provide public weather data that private companies cannot recreate

This is a really nice, simple distillation of the vital role NOAA and the NWS play and how private companies cannot replace what they do.

1 year ago 546 291 3 20

I vouched for the “incorrect_name” to be used. #gischat

1 year ago 3 0 1 0

I know that’s what some folks in the OpenStreetMap community were waiting to see if the GNIS record to change since folks were committing vandalism.

1 year ago 1 0 1 0