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 … Continue reading Happy #postgis day, everybody! A big and fun day
It’s starting to feel real around here: Continue reading Book is coming…
I have posted about this previously, but just a reminder that I am working (with dedicated and brilliant co-authors) on a PostGIS book! Publication date TBD, but we are not far off now. It will be via Packt, and likely a title like “PostGIS Cookbook” or similar. Like many great projects, reviewing it at editing time is revealing that it is better than it felt … Continue reading New PostGIS book, on its way…
A little more refinement to the SQL for building masking fill for hand-placed text on maps. Continue reading Cartographic tricks and tips– making text readable, PostGIS edition, take 3
I have a couple of posts number 1 and number 2 about masking for text. One more from the actual implementation: Continue reading Cartographic tricks and tips– making text readable, PostGIS edition part 2
Recall from previous post, http://wp.me/phWh4-qm I played a bit with using convex polygons and buffers to control noisy backgrounds behind text, ala: ——–> I was tired of doing this in the GUI in QGIS, so I wrote some simple code to do it in PostGIS. Continue reading Cartographic tricks and tips– making text readable, PostGIS edition
I hung out this week at the Boston Code Sprint http://wiki.osgeo.org/wiki/Boston_Code_Sprint_2013, which is a “C-Tribe” code sprint for improving things like PostGIS, MapServer, and other GeoFOSS projects written in C. See Paul Ramsey’s posts on PostGIS and MapServer for more on what everyone was working on. Being my first time at a code sprint, it’s been very interesting, and it’s a very warm and inviting … Continue reading Boston Code Sprint
I thought one more post for procrastination sake. Brother 4 years ago: and sister today: Continue reading PostGIS Onesie, redux– side-by-side comparison
Following in her brother’s (and father’s) footsteps: Continue reading PostGIS Onesie Redux
Photogrammetric like ortho-photos rendered with GDAL/PostGIS from 3D point clouds created in Bundler and PMVS? Yes indeedeedoo: Point cloud in meshlab: And “orthophoto” derived from voronoi polygons in PostGIS, rendered to tif with gdal: Hat tip to my3dscanner for making it so easy to generate the point cloud. More on this later. Continue reading Photogrammetry using Bundler, PMVS, GDAL, and PostGIS.
Smathermather's Weblog 