Tag: PostGIS

Database, Other, PostGIS, PostgreSQL, SQL

Tracing golden monkeys through time

My collegue TUYISINGIZE Deogratias (“Deo) and others at Dian Fossey Gorilla Fund International have been studying golden monkeys (Cercopithecus kandti) in Rwanda. Golden monkeys are an endangered monkey along the Albertine Rift (including the Virungas, host to the endangered mountain gorilla). They are also cute as can be, but more on that another time. Deo has been leading efforts to track the golden monkeys in … Continue reading Tracing golden monkeys through time

smathermatherLeave a comment
Database, Ecology, Gorillas, Karisoke, National Park, PostgreSQL, SQL

A little Gorilla Time

I miss my mountain gorilla friends in Rwanda. Let’s write a little more code to support them. I’ll be visiting Karisoke again next week, so it seems timely to post a little more code (HT Jean Pierre Samedi Mucyo for working with me on this one). The problem today is simple — given a time series of gorilla locations and dates, can we calculate rate … Continue reading A little Gorilla Time

smathermather1 Comment
3D, Database, Docker, LiDAR, Other, PDAL, pointcloud, PostGIS, PostgreSQL

Taking Slices from LiDAR data: Part IX

I finally got PDAL properly compiled with Point Cloud Library (PCL) baked in. Word to the wise — CLANG is what the makers are using to compile. The PDAL crew were kind enough to revert the commit which broke GCC support, but why swim upstream? If you are compiling PDAL yourself, use CLANG. (Side note, […]

Continue reading Taking Slices from LiDAR data: Part IX

smathermather1 Comment
3D, Database, Docker, LiDAR, Other, PDAL, pointcloud, PostGIS, PostgreSQL

Taking Slices from LiDAR data: Part VIII

I finally got PDAL properly compiled with Point Cloud Library (PCL) baked in. Word to the wise — CLANG is what the makers are using to compile. The PDAL crew were kind enough to revert the commit which broke GCC support, but why swim upstream? If you are compiling PDAL yourself, use CLANG. (Side note, […]

Continue reading Taking Slices from LiDAR data: Part VIII

smathermather1 Comment
3D, Database, Docker, LiDAR, Other, PDAL, pointcloud, PostGIS, PostgreSQL

Taking Slices from LiDAR data: Part VII

I finally got PDAL properly compiled with Point Cloud Library (PCL) baked in. Word to the wise — CLANG is what the makers are using to compile. The PDAL crew were kind enough to revert the commit which broke GCC support, but why swim upstream? If you are compiling PDAL yourself, use CLANG. (Side note, […]

Continue reading Taking Slices from LiDAR data: Part VII

smathermather2 Comments
Database, PostGIS, PostgreSQL, SQL

Using PostGIS for Hydrologic Modeling (reblog)

The Problem We have to filter out the roads and ditches without removing streams that cross roads or follow them closely. I’m going to use PostGIS to find the intersection of the streams lines data with a buffered roads polygon. If the intersected line is less than 50% of the length of the stream line, […] via Filtering Roads from Extracted Streams Data — GeoKota Continue reading Using PostGIS for Hydrologic Modeling (reblog)

smathermatherLeave a comment
Database, PostGIS, PostgreSQL, SQL

Using foreign data wrapper to use PostGIS with SQLServer

Here was the problem that needed solved last week (we have a few similar problems in upcoming projects, so this was an exciting thing to try): we needed to use PostGIS to access data in a SQLServer database. The SQLServer database backs the web site in question, the underlying content management system, etc., so no– removing SQLServer isn’t really an option at this stage. Obviously … Continue reading Using foreign data wrapper to use PostGIS with SQLServer

smathermatherLeave a comment
3D, Database, Docker, LiDAR, Other, PDAL, pointcloud, PostGIS, PostgreSQL

Taking Slices from LiDAR data: Part VI

I finally got PDAL properly compiled with Point Cloud Library (PCL) baked in. Word to the wise — CLANG is what the makers are using to compile. The PDAL crew were kind enough to revert the commit which broke GCC support, but why swim upstream? If you are compiling PDAL yourself, use CLANG. (Side note, the revert to support GCC was really helpful for ensuring … Continue reading Taking Slices from LiDAR data: Part VI

smathermather3 Comments
Database, PostGIS, PostgreSQL

PostgreSQL table drop — a little fun with ouroboros

My latests posts on PDAL have been fun. For the moment, a quick bit of code for dropping all the tables in your PostgreSQL database. BTW, the following is a bad idea. Many bad ideas are really useful. This is a really useful but bad idea: How does this work? Let’s do a quick step through. First we echo “\dt”. This just prints literally (the literally … Continue reading PostgreSQL table drop — a little fun with ouroboros

smathermather3 Comments
3D, Database, Docker, LiDAR, Other, PDAL, pointcloud, PostGIS, PostgreSQL

Taking Slices from LiDAR data: Part V

For this post, let’s combine the work in the last 4 posts in order to get a single pipeline for doing the following: Calculate relative height of LiDAR data Slice that data into bands of heights Load the data into a PostgreSQL/PostGIS/pgPointCloud database. Now, we can use parallel to make this run a little faster: Sadly, we can run into issues in running this in … Continue reading Taking Slices from LiDAR data: Part V

smathermatherLeave a comment