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
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.
Just discovered ST_Node, a function in PostGIS just for noding geometries. I used to use ST_Union for this, a potentially memory intensive operation. Now I can use ST_Node. For usage, see the PostGIS docs (requires 2.0 and GEOS 3.3.2 for bug free use). Back to coding. That is all. Continue reading Using ST_Node in PostGIS (where once I used ST_Union)
Sadly, I cannot post the code for this one, but will post the images– playing with tesselation in PostGIS today: Continue reading Tesselation of Hexagons in PostGIS
Anyone who has been following along at home knows I don’t think much like a DBA. Sometimes that’s good; mostly it’s probably bad. In this post, I hope it will be interesting. The problem of the day is how to take engineering contours derived from breaklines, a lidar point cloud, and all the lot, and do a good job interpolating that to a DEM. This … Continue reading Proper (ab)use of a database, contour interpolation using #postgresql #postgis #arcgis
Just pretty pictures today. Continue reading Cartographically Pleasing Vegetation Boundaries– with PovRay, PostGIS, and LiDAR
In a previous couple of posts (this one, and this one), we dealt with point rotations, first with bounding box searches, and then with nominal use of operators. First we create a function to do our angle calculations, then use select to loop through all the records and do the calculations. Within our function, first we find our first (in this case) five nearest streets … Continue reading Cartography and USGS — Fake Building Footprints in PostGIS now with distance operator (part 2)
Smathermather's Weblog 