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:

Figure showing overlapping viewing footprints from images from UAS flight.

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:

Map showing TIN of intersection of digital terrain model and viewing cone from UAS.

Here it is compared with the initial calculation:

Comparison of previous figure with original less correct estimate.

3 thoughts on “UAS (drone) Footprint Geometries Calculated in PostGIS with SFCGAL — for real this time

  1. Hello! Great book! I got the print and eBook versions. It was exactly what I was looking for and the timing could not have been better.
    I am still waiting for access to the dataset from Packt though…

    If one was interested in the 3D GPS coordinates of the four corners of intersection with the surface instead of the full boundary, what would be the best approach?

    I had already been considering using a ray frame similar to your solid pyramid and had a similar RotateXYZ worked up, but can’t figure out how to get the intersection with the corner rays.

    Instead of extruding the surface, I was considering volumizing the rays so your approach has triggered all sorts of new options. Thanks!

    After extruding the surface, is it possible to get the intersection points of the corner rays with PostGIS?

    Thanks. Love the book.

    1. I suppose if all you want is the intersecting corner points, you just intersect a ray (or your 4 rays) with the DTM– no need for extrusion. I think that would give the result you seek (although I haven’t tested). That’s an elegant way to do it. That said, we are very near the edge of what 3D PostGIS can do at the moment, so beware dragons. That’s why I stuck to volumetric intersections with TINs– really the only guaranteed intersections until Oslandia finishes their work for PostGIS 2.2.

      I’m sorry to hear Packt hasn’t posted the data yet. You can get chapter 2, 4, 6, and 7 (unofficially) in the following github repo.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.