Wednesday 29 January 2020

dem - PostGIS interpolation / triangulation options



I'm looking for an open source workflow to automate DEM construction. We have a series of sites that fall within a LIDAR dataset. We want to create site specific DEM's for each site, and we're looking to automate the process.


So far, we have automated:



  • data loading into PostGIS (LIDAR and site points)

  • creation of site boundaries (combination of st_buffer and st_envelope)


Now we're looking for options to interpolate the data subsets at each site and export them to Surfer7 grid files.


Currently, we're querying the data in the PostGIS database using QuantumGIS, exporting to csv files, then manually importing and gridding the data in Surfer7. Hopefully we can automate this as well.


So for this use case, we'd like to triangulate our lidar data to a DEM. Other potential cases we can think of involve different interpolation methods - so if there are options for inverse distance and kriging - we're interested!


This is very much a learning exercise for us - we're working in baby steps!





No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...