Smathermather's Weblog

Remote Sensing, GIS, Ecology, and Oddball Techniques

Archive for November, 2013

PostGIS Cookbook Promises

Posted by smathermather on November 30, 2013

So, as we’re are in the final edits of the PostGIS Cookbook, there are some recipes that have ended up on the cutting room floor.  Several of these will end up on this blog:

Amongst those that will end up in the alternate pipeline, and thus ultimately in GitHub, will be a project called pgOrthogonalize, similar to the functionality in Potlatch2 and iD to square up building footprints. I will be adding a set of scripts for PostGIS to do the same at the database level.

Other smaller things are ending up on the cutting room floor, including a soup-to-nuts tutorial on how to use TravelingSalesPerson (pgr_tsp and related tools) in pgRouting.

So, stay tuned for those.  Really cool thing– once I recover from book writing, expect more blog posts here than have been in the past year or so.  I’m looking forward to being back… .

Driving Distance as compared to Buffer Distance

Driving Distance as compared to Buffer Distance

Posted in pgRouting, PostGIS, PostgreSQL, SQL | Tagged: , | 2 Comments »

Ubuntu Touch

Posted by smathermather on November 24, 2013

If you are feeling truly geeky, check out Ubuntu Touch, now that you can install it on your Nexus 4:

Picture from Ubuntu site showing 3 views of Ubuntu Touch
Ubuntu Touch

http://www.ubuntu.com/phone/install

I installed it last weekend as a ramp up to a writing/editing week.  It was a nice semi-brainless and obsessive thing to do in advance of a heavy tech week– it required no documentation to be written, no expectation of success, no deliverable for anyone.  By the way, TL/DR on installation– if you have a rooted customized Android– be sure to restore to factory everything before trying to install.  Then it should be fast to do and painless.  Otherwise, you will spend much time trying hard things you shouldn’t have to try… .

The short review, is that their disclaimer for developers and industry partners only is true.  This is not yet a fully featured phone.  But it is very pretty, nearly functional, and has been a joy to use this week.

I am definitely looking forward to this platform maturing.

Posted in Phone, Ubuntu | Tagged: , , | Leave a Comment »

(a tagged repost) Happy #postgis day, everybody! A big and fun day

Posted by smathermather on November 22, 2013

All goes well, the PostGIS Cookbook will be out in January here’s some of the official info:

If you are a web developer or a software architect, … and want to expand the range of techniques you are using with PostGIS, then this book is for you… .

An easy-to-use guide, full of hands-on recipes for manipulating spatial data in a PostGIS database. Each topic is explained and placed in context, and for the more inquisitive, there are more details of the concepts used.

Image of PostGIS Cookbook Cover

More to the point, as Paul Ramsey asked me today on the PostGIS Day Extravaganza, will it be packed with wacky “I didn’t know you could/should do that with PostGIS recipes”? the answer is, “Yes”. I wrote some special for it, including creating a TIN from a structure-from-motion drone/UAS/UAV point cloud.

But, it is also graced with a great chapter on raster by the venerable Bborie Park. Want to know how to do raster acrobatics in PostGIS? We can help with that. Want to optimize and tune Postgres for PostGIS? We can help with that. Want to connect all that PostGIS goodness into a web application? Paulo Corti wrote a great few chapters on that and other topics (2/3rds of the book). We can help with that. Want to connect into a OpenJump, QGIS or other desktop application? Tom Kraft wrote a good chapter for that– yes, we can help with that.

Pre-orders can be done here: http://www.packtpub.com/postgis-to-store-organize-manipulate-analyze-spatial-data-cookbook/book

Happy PostGIS Day, everybody.

Posted in Database, PostGIS, PostgreSQL, SQL | Tagged: | Leave a Comment »

More #PostGIS Day

Posted by smathermather on November 21, 2013

Posted in Other, PostGIS, PostgreSQL, SQL | Tagged: | 2 Comments »

Happy #postgis day, everybody! A big and fun day

Posted by smathermather on November 21, 2013

All goes well, the PostGIS Cookbook will be out in January here’s some of the official info:

If you are a web developer or a software architect, … and want to expand the range of techniques you are using with PostGIS, then this book is for you… .

An easy-to-use guide, full of hands-on recipes for manipulating spatial data in a PostGIS database. Each topic is explained and placed in context, and for the more inquisitive, there are more details of the concepts used.

Image of PostGIS Cookbook Cover

More to the point, as Paul Ramsey asked me today on the PostGIS Day Extravaganza, will it be packed with wacky “I didn’t know you could/should do that with PostGIS recipes”? the answer is, “Yes”.  I wrote some special for it, including creating a TIN from a structure-from-motion drone/UAS/UAV point cloud.

But, it is also graced with a great chapter on raster by the venerable Bborie Park.  Want to know how to do raster acrobatics in PostGIS?  We can help with that.  Want to optimize and tune Postgres for PostGIS?  We can help with that.  Want to connect all that PostGIS goodness into a web application?  Paulo Corti wrote a great few chapters on that and other topics (2/3rds of the book).  We can help with that.  Want to connect into a OpenJump, QGIS or other desktop application?  Tom Kraft wrote a good chapter for that– yes, we can help with that.

Pre-orders can be done here: http://www.packtpub.com/postgis-to-store-organize-manipulate-analyze-spatial-data-cookbook/book

Happy PostGIS Day, everybody.

Posted in Other, PostGIS, PostgreSQL, SQL | Tagged: | 2 Comments »

Book is coming…

Posted by smathermather on November 21, 2013

It’s starting to feel real around here:

PostGIS Cookbook Cover

Woah! A PostGIS Cookbook!

Posted in Other, PostGIS, PostgreSQL, SQL | Tagged: | 2 Comments »

And on that farm he had a cat… #cfasummit

Posted by smathermather on November 4, 2013

Two of the sets of conversations I really enjoyed at the CfA Summit in the 3rd day unconference were on the topic of Chief level technology positions, from Chief Innovation Officers to Chief Technology Officers to Chief Information Officers.  It was interesting to hear others’ interests, frustrations with both ends of recruitment, and the realization that there wasn’t a central repository for such position descriptions available.  So with the help of people in those sessions plus a few people after the Summit, I started a little repo to centralize the PDs and other relevant info for C*O tech positions.

Screen shot 2013-11-04 at 10.09.20 PM

From the repo:

“A number of C-level technology related positions have been created in local governance in the last few years, from traditional Chief Information Officer and Chief Technology Officer, to newer descriptions including Chief Data Officer, Chief Innovation Officer and others. This repo is meant as a source of C*O position descriptions and other relevant information for the creation of these leadership tech position in the civic sector.”

https://github.com/smathermather/EIEIO

A number of people have been involved in the discussion, including the following folks at the Summit:

Steve Allen, David Burns, Jennifer Anastasoff, Matthew Barron, Noel Hidalgo, Brian Chatman, Zachary Vruwink, Jake Levitas (and a couple I unfortunately forgot the names of…)

as well as a number of people who weighed in post-Summit, including: Jonathan Reichental, Bill Haight, Deborah Acosta, Yiaway Yeh, Vakil Kuner, Mark Headd, and of course, CfA’s own Abhi Nemani.

If anything is wrong in the repo, I take credit.  Anything right?  Check the above list of names.  Oh, and fork it, so I’m not the only one being wrong… .

Posted in CfASummit, Conferences, OpenGov | Tagged: , , | Leave a Comment »