Tag: PostGIS

3D, Analysis, Database, PostGIS, PostgreSQL, SQL

PostGIS with SFCGAL — Videos, how did I miss these videos?

The guys from Oslandia are really ripping things up in the PostGIS 3D world.  (They are nice guys too– Olivier and Hugo had a skeletonization approach punched up and ready to test before I left the Boston Code Sprint this past Spring.) So I missed these two videos in my first few views of the SFCGAL website: ————————————————————————————- Just one question– what is “Horoa plugin … Continue reading PostGIS with SFCGAL — Videos, how did I miss these videos?

Unknown's avatarsmathermather3 Comments
3D, Analysis, Database, PostGIS, PostgreSQL, SQL

PostGIS with SFCGAL

So, for those of you who haven’t seen it, SFCGAL, “a C++ wrapper library around CGAL with the aim of supporting ISO 19107:2013 and OGC Simple Features Access 1.2 for 3D operations” is now an optional include in PostGIS (I believe beginning with 2.1, forgive me if I’m wrong).  This was a quiet outcome of the Boston Code Sprint, after Paul Ramsey declared exact rational number … Continue reading PostGIS with SFCGAL

Unknown's avatarsmathermather2 Comments
Analysis, Database, pgRouting, PostGIS, PostgreSQL, SQL

Realistic biking distances, pgRouting

In an upcoming recipe (another one for the cutting room floor), we’ll play a bit with realistic biking distances, as compared with a 5-mile buffer (light grey), a 5-mile driving distance (dark grey), and a 5-mile biking-on-roads-with-speed-limits-under-40mph (purplish). This is just a teaser for mapbaker… . Continue reading Realistic biking distances, pgRouting

Unknown's avatarsmathermather1 Comment
pgRouting, PostGIS, PostgreSQL, SQL

PostGIS Cookbook Promises

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 … Continue reading PostGIS Cookbook Promises

Unknown's avatarsmathermather2 Comments
Database, PostGIS, PostgreSQL, SQL

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

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 (a tagged repost) Happy #postgis day, everybody! A big and fun day

Unknown's avatarsmathermatherLeave a comment
Other, PostGIS, PostgreSQL, SQL

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

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

Unknown's avatarsmathermather2 Comments
PostGIS, PostgreSQL

New PostGIS book, on its way…

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…

Unknown's avatarsmathermatherLeave a comment