Author: smathermather
Editing in progress
Edit: Free book to the first to tell me what the is name of the children’s book on the armchair in the foreground: Book editing in progress… . Continue reading Editing in progress
2013 in review
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 38,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 14 sold-out performances for that many people to see it. Click here to see the complete … Continue reading 2013 in review
Drone Pointilism
Just an image today. Continue reading Drone Pointilism
Voronoi in PostGIS
PostGIS has for a time had ST_DelaunayTriangles for Delaunay Triangulation, and since 2.1 apparently can even natively create a 2.5D TIN using said function, which is pretty cool. I think with SFCGAL, we will eventually have true 3D TINs as well. We’re still waiting on native Vororoi support for PostGIS though. According to http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS “GEOS 3.5 is still in development but will have Voronoi which … Continue reading Voronoi in PostGIS
What’s in a name? That which we call a GIS By any other name would smell as sweet;
What’s in a name? That which we call a GIS By any other name would smell as sweet; But would it. I’m at a place where I could name my working group. Thoughts? (we could just call ourselves the GeoHipsters…). GIS, Geospatial, Mapping… Continue reading What’s in a name? That which we call a GIS By any other name would smell as sweet;
They’ve gone to plaid. (LeafletJS and CartoDB)
Enjoyed setting the errorTileUrl flag in a leafletjs map today. A small homage: Continue reading They’ve gone to plaid. (LeafletJS and CartoDB)
2.5D TINs in PostGIS
(edited: changed TIN to TIN Z) (edited again — function already exists as a flag in ST_DelaunayTriangles… .) Uh, I wrote a function for nothin’… As Regina points out in the commments, this functionality was rolled into 2.1 with a flag. Her example: For the record, my code is about 2% slower on a dataset that takes ~50minutes to triangulate . —————————————— Original Post —————————————— … Continue reading 2.5D TINs in PostGIS
UAS (drone) Footprint Geometries Calculated in PostGIS with SFCGAL — for real this time
In my earlier post, I made a claim that SFCGAL was used in this figure: It dawned on my afterwards, while I was using 3D, I hadn’t actually employed any of the analysis goodies that come with SFCGAL. Well, here it is– a footprint as calculated using the view angles and a real terrain model: Here it is compared with the initial calculation: Continue reading UAS (drone) Footprint Geometries Calculated in PostGIS with SFCGAL — for real this time
UAS (drone) Footprint Geometries Calculated in PostGIS — Individual Footprint
UAS (drone) Footprint Geometries Calculated in PostGIS (viewed in QGIS nightly), taking into account relative elevation, bearing, pitch, and roll, this time just one: Continue reading UAS (drone) Footprint Geometries Calculated in PostGIS — Individual Footprint