Parks Data Cake, part deux

Following up on my previous post, I have started to detail the how of our parks map rendering works, including a GitHub repository with all the code and data to build your own in TileStache. One of these days, we’ll port this to TileMill, but in the mean time, it works and works wonderfully.   — Addendum — Truth in advertising– the contours data were … Continue reading Parks Data Cake, part deux

Packt Sale — 2 books for the price of one

Now I feel like a salesman. I feel obliged to mention the Packt buy one get one free sale (ends tomorrow): http://www.packtpub.com/?utm_source=referral&utm_medium=marketingPR&utm_campaign=2000thTitle If you want a postgresql title to go with the PostGIS Cookbook (just sayin’): http://www.packtpub.com/search?keys=postgresql&sort=0&types=0&forthcoming=1&available=1&count=20&op=Go Ok. Enough. Back to fun reading:   Continue reading Packt Sale — 2 books for the price of one

Parks Data Cake

Stamen has a great blog entry on mapping for parks on their blog. It’s a teaser for a deeper dive in mapping parks, and I’m staying tuned, as their write-ups tend to be detailed, thoughtful, and complete. I thought I’d offer my own teaser– a bit of work done collaboratively with GreenInfo Network.  It started with their basemap– something they spent a few person-years refining from … Continue reading Parks Data Cake

Custom projections using spatialreference.org and gdal

Every now and then I get the urge to define my own projection. Usually, I sit down for a while, hit my head on the wall, and the urge passes. For a few years I have worked with the Lake Erie and Allegheny Partnership for Biodiversity on various projects. Now we are getting deep into region-wide data collection, and so I decided to define an … Continue reading Custom projections using spatialreference.org and gdal

PostGIS Cookbook(s)

This is starting to feel real… PostGIS Cookbook(s).  2904 pages. Page count for a single book can be calculated as in the following code: The preceding query will result in the following: A special thanks to my family, my co-authors, all the contributors to PostGIS, and to Regina Obe for helping me through the hardest bit of code in my part of the book. Check … Continue reading PostGIS Cookbook(s)

Short follow up: Photogrammetrically Derived Point Clouds

In my previous post, https://smathermather.wordpress.com/2014/02/04/big-dmn-post-photogrammetrically-derived-point-clouds/, I briefly cover software for creating photogrammetrically derived point clouds.  I didn’t summarize, like this, but PDPCs can be created in three easy steps: Structure from Motion for unordered image collections Clustering Views for Multi-view Stereo Multi-view stereo (dense point cloud reconstruction) But, unfairly, I gloss over some of the complications of creating meaningful data from PDPC processing. Truth told, … Continue reading Short follow up: Photogrammetrically Derived Point Clouds

Big d@mn post: Photogrammetrically Derived Point Clouds

I chatted with Howard Butler (@howardbutler) today about a project he’s working on with Uday Verma (@udayverma @udaykverma) called Greyhound (https://github.com/hobu/greyhound) a pointcloud querying and streaming framework over websockets for the web and your native apps. It’s a really promising project, and I hope to kick the tires of it really soon. The conversation inspired this post, which I’ve been meaning to do for a … Continue reading Big d@mn post: Photogrammetrically Derived Point Clouds

Book Complete

For all following along at home, the PostGIS Cookbook is complete!  At 484 pages it’s a tome– but a great one (It’s been out for a few days, actually). A shout out to my brilliant co-authors, Paolo, Bborie, and Tom. I could not have hoped for better. http://www.packtpub.com/postgis-to-store-organize-manipulate-analyze-spatial-data-cookbook/book And for any who wonder, the picture on the front is of the Maumee River, the largest … Continue reading Book Complete