Geo Django Raster Metadata

I’ve been using GeoDjango for some time now, and found myself in a situation where I wanted to retrieve raster metadata using the ST_MetaData function on some datasets stored in PostGIS.

To do so, you can of course use the raw function from the db Manager, but for this I went the extra mile (although, it’s more like the extra half-mile, since it’s very easy)

the ST_Metadata in GeoDjango

Advertisement

Leave a comment

Filed under code, curious, tips

Children of Time

Another book post, how boring!

Children of Time is one of those presents that I knew was coming (Pestering for it for quite some time), and once it was in my hand it took me a couple of weeks to finish, it is one of the most exciting science fiction books I’ve read in a while.

The idea is an interesting one. Humanity has reached a point where it starts colonizing and terraforming other planets, but disaster ensues, and we’re brought back to less technological times, while some of the terraformed planets still inhabited start their own story.

Flash forward lots of years from the fall of that technologically advanced civilization, the earth is dying, and some groups start some sort of Noah’s ark spaceship only with people inside with the hope that they can reach one of those old fabled terraformed planets. But they will have to deal with whatever has evolved there (hint, it has 8 legs).

Interestingly, those inhabitants are not painted as horrible mutations that humanity has to fight, but a relatable nascent civilization that has its own fears and hopes. The book dabbles in both storylines, one of the humans travelling and their social problems inside the spaceship, and the spiders, how their society progresses in strange ways for us, and their own way of seeing the world. All of it coming altogether for the book finale.

This is an open ended book, and as far as I’ve checked online the second book should come soon enough (2019 according to wikipedia)

1 Comment

Filed under books, curious

Spon book & spoon carving

Continuing with the weirdness and going totally off-topic from the type of posts you usually find here, let’s talk about a book of spoons and what it meant to me!.

The book is a short one, split into three parts:

  • A story about the author, and how he got into spoon carving.
  • Instructions on spoon carving techniques and knife grips.
  • A beautiful collection of spoons, with some words about each one of them.

I’ve never heard of Barn The Spoon, he is a spoon artisan carving from green wood mostly using a knife and an axe. I actually got attracted to this book after seeing it while attending a workshop on wood carving, the idea of such a specific book and the hippie feel of everything related to carving without any advanced tools picked my interest, so immediately ordered it from Amazon.

I can’t recommend this book to everybody, but the vibe that it transmits it’s something felt close. The story of Barn is an interesting one, worth reading. And the included pictures are gorgeous (yes, those spoon photos are actually amazing, kudos to the photographer). The only point where it fails to me is trying to explain the knife grips using only prose, probably my engineer’s mind is tricking me here, but some drawings on what is trying to be conveyed would help.

After skimming it, and then thoroughly reading the book, Armed with a sharp knife, a hook knife and the explained techniques I started to carve my first spoon. Which was ok, chunky and nicer to look at than to use, but a second one followed, then a third… and after half a year spoons keep coming out of my hands!.

That’s the best compliment to give to the book, it made me want to carve and enjoy the carving process in itself. I feel that this was the point of all of it :-D.

some spoons after this

Leave a comment

Filed under curious, DIY

Hugo static website on S3

You are in for a treat, static websites are back from the dead (they never left, but were not prominent nor sexy). Combine this with the cheapness of file hostings like S3 and you have a winner here.

more

Leave a comment

Filed under code, tips, tools

Color2Attribute for Qgis3.x

Well, it didn’t take that much. I ported the small Qgis plugin to Qgis version 3.x. Luckily the renderer classes did not change, so the biggest thing to do was reorganize the code for PyQt5 and all the Qgis2 to Qgis3 API breaking changes. Just one coffee and a morning was enough :-).

It should be available from the qgis repository itself.

Related

Original Post
2.X update
Plugin at the Qgis plugin website
Plugin source

Leave a comment

Filed under code, gis

Color2attribute in QGIS Plugin servers

Something like 7 years ago I created a very small plugin for Qgis (V1.x and V2.x later on).

This plugin was available via my github on a clone and copy fashion.

Yesterday I stopped being lazy and fixed that, The plugin is now available directly from the QGis plugin servers. And can be installed from Qgis itself.

Although I’m late as always since It does not work on 3.x versions.. oh well (look at this changelist!).

QGIS Color to Layer

Related

Original Post
2.X update
Plugin at the Qgis plugin website
Plugin source

Leave a comment

Filed under code, gis, tools