Gregory Power's Avatar

Gregory Power

@gregorywpower

My opinions are my own and not of my employer. ISO-8601, Apache Arrow, and neovim enjoyer. they/them

304
Followers
1,022
Following
85
Posts
11.11.2024
Joined
Posts Following

Latest posts by Gregory Power @gregorywpower

Anything is possible with PostGIS and triggers. πŸ‘€

06.01.2026 15:57 πŸ‘ 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...

03.10.2025 16:28 πŸ‘ 28 πŸ” 4 πŸ’¬ 0 πŸ“Œ 1

That Project Manager extension seems pretty nifty!

02.10.2025 01:53 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

01.10.2025 04:11 πŸ‘ 13930 πŸ” 2790 πŸ’¬ 306 πŸ“Œ 172

You can also do math with vim. πŸ‘€

04.09.2025 23:15 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Hackers:

Your goal is to launch the Calculator.

04.09.2025 23:15 πŸ‘ 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...

14.08.2025 20:47 πŸ‘ 2453 πŸ” 1056 πŸ’¬ 105 πŸ“Œ 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

16.04.2025 00:20 πŸ‘ 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

15.04.2025 00:20 πŸ‘ 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

15.04.2025 00:13 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

This is so cute I absolutely love it! #rstats

14.04.2025 22:54 πŸ‘ 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

14.04.2025 22:46 πŸ‘ 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.

12.04.2025 13:41 πŸ‘ 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

12.04.2025 01:47 πŸ‘ 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...

12.04.2025 01:45 πŸ‘ 2 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

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

12.04.2025 01:36 πŸ‘ 6 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Nah, you’re good.

01.04.2025 11:42 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

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

01.04.2025 11:32 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

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

03.03.2025 04:26 πŸ‘ 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

14.11.2024 13:36 πŸ‘ 1060 πŸ” 278 πŸ’¬ 75 πŸ“Œ 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

01.03.2025 23:38 πŸ‘ 18835 πŸ” 6846 πŸ’¬ 698 πŸ“Œ 446

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

02.03.2025 05:28 πŸ‘ 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.

02.03.2025 02:51 πŸ‘ 1145 πŸ” 390 πŸ’¬ 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...

28.02.2025 14:28 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

28.02.2025 14:24 πŸ‘ 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

26.02.2025 18:41 πŸ‘ 3 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Post image Post image Post image Post image

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

12.02.2025 17:52 πŸ‘ 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.

11.02.2025 20:10 πŸ‘ 546 πŸ” 291 πŸ’¬ 3 πŸ“Œ 20

I vouched for the β€œincorrect_name” to be used. #gischat

11.02.2025 15:17 πŸ‘ 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.

11.02.2025 14:53 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0