LiDAR and pointcloud extension pt 3

Digging a little deeper. Ran the chipper on a smaller number of points and then am doing a little hacking to get height per chip (if you start to get lost, go to Paul Ramsey’s tutorial). Here’s my pipeline file. Note the small chipper size– 20 points per chip. Easy enough to load (though slow for the sake of the chip size): Now we can … Continue reading LiDAR and pointcloud extension pt 3

LiDAR and pointcloud extension

Paul Ramsey has a great tutorial on using the pointcloud extension with PostgreSQL / PostGIS: http://workshops.boundlessgeo.com/tutorial-lidar/ You can get point cloud and all that goodness running a variety of ways. Probably the easiest is to download OpenGeo Suite from Boundless: http://boundlessgeo.com/solutions/opengeo-suite/download/ If you are an Ubuntu user, try a docker instance to run PostGIS with PDAL, pointcloud, etc in a container: https://github.com/vpicavet/docker-pggis Also, I’m working … Continue reading LiDAR and pointcloud extension

The easiest way to get PostGIS and friends running:

Docker.  See: https://github.com/vpicavet/docker-pggis for a quick and easy Docker running PostGIS. Understand, this isn’t production ready (the connection permissions make my teeth hurt a little) but, so nice to have a one stop shop for postgis, pgrouting, and pointcloud. Now I may have to write blog posts on pointcloud. Point cloud didn’t get in the PostGIS Cookbook because it was too hard to build. I … Continue reading The easiest way to get PostGIS and friends running:

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)

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