Tag: PostGIS

Database, Database Optimization, Fulcrum, PostGIS, PostgreSQL, SQL

Normalizing tables in PostgreSQL: experiments with Fulcrum

Fulcrum by Spatial Networks is an interesting and very useful hosted service for collecting geo data in the field with whatever smartphone or tablet you already own.  It works well, so long as you just want to collect points, and the field building capabilities are quite extraordinary. Also, for many applications, it’s cheaper than custom solutions, so it hits that sweet spot well. If you’ve … Continue reading Normalizing tables in PostgreSQL: experiments with Fulcrum

Unknown's avatarsmathermatherLeave a comment
3D, Cartography, Database, Drone, PostGIS, PostgreSQL, SQL, UAS

Airspace — A deep rabbit hole

In previous maps we looked at Class B, C, and D airspace. Let’s add in Class E0 and E5… (not yet in 3D): (Map tiles by Stamen Design, under CC BY 3.0. Data by OpenStreetMap, under ODbL) Previous posts: https://smathermather.wordpress.com/2014/10/25/airspace-is-complicated-and-so-i-abuse-postgis-once-again/ and https://smathermather.wordpress.com/2014/10/25/airspace-is-complicated-and-so-i-abuse-postgis-once-again-reprise/ Continue reading Airspace — A deep rabbit hole

Unknown's avatarsmathermatherLeave a comment
3D, Cartography, Database, Drone, PostGIS, PostgreSQL, SQL, UAS

Airspace is complicated — and so I abuse PostGIS once again — Reprise…

In the previous post: https://smathermather.wordpress.com/2014/10/25/airspace-is-complicated-and-so-i-abuse-postgis-once-again/ we explore the 3D shape and complexity of controlled airspace. Now here’s the rest of the code. We’ll add our affine transformation ala Seth Fitsimmons: And integrate that into our original function: And voila! Let’s take a look at Washington, DC and surrounds, another nice complicated example: And again with map tiles by Stamen Design, under CC BY 3.0. Data … Continue reading Airspace is complicated — and so I abuse PostGIS once again — Reprise…

Unknown's avatarsmathermather3 Comments
3D, Cartography, Database, Drone, PostGIS, PostgreSQL, SQL, UAS

Airspace is complicated — and so I abuse PostGIS once again

Let’s ignore for a moment the drone hobbiest / enthusiast. What is the shape of airspace for airplanes and commercial and government unmanned aircraft flying under Certificates of Authorization, and how can we visualize it? Thanks to Anita in the last post, we have the Class B,C,D,E Airspace Shape Files which helps us define the overall shape of controlled airspace. But, these are 3D things. … Continue reading Airspace is complicated — and so I abuse PostGIS once again

Unknown's avatarsmathermather4 Comments
3D, Database, FLANN, Other, pointcloud, PostGIS, PostgreSQL

KNN with FLANN and laspy, a starting place

FLANN is Fast Library for Approximate Nearest Neighbors, which is a purportedly wicked fast nearest neighbor library for comparing multi-dimensional points. I only say purportedly, as I haven’t verified, but I assume this to be quite true. I’d like to move some (all) of my KNN calculations outside the database. I’d like to do the following with FLANN– take a LiDAR point cloud and change … Continue reading KNN with FLANN and laspy, a starting place

Unknown's avatarsmathermatherLeave a comment
Analysis, Database, pgRouting, PostGIS, PostgreSQL, SQL

Drivetime analyses, pgRouting

We’ve got some quick and dirty pgRouting-based code up on github. I say quick and dirty because it directly references the table names in both of the functions. I hope to fix this in the future. The objective with this code is to input a point, use a nearest neighbor search to find the nearest intersection, and from that calculate a drive time alpha shape. … Continue reading Drivetime analyses, pgRouting

Unknown's avatarsmathermather4 Comments
Analysis, Database, PostGIS, PostgreSQL, QGIS, SQL, TileStache

Plugin-free QGIS TMS tiles via GDAL

Want to load your favorite tiles into QGIS? How about a plugin-free QGIS TMS tiles via GDAL: http://www.3liz.com/blog/rldhont/index.php?post/2012/07/17/OpenStreetMap-Tiles-in-QGIS Really awesome… . Needs but one change: epsg:900913 should be epsg:3857 or QGIS (GDAL?) throws an error. Presumably you could also define epsg:900913 in some config file, but barring that create an XML file as follows, and load as a raster in QGIS: Now I can use … Continue reading Plugin-free QGIS TMS tiles via GDAL

Unknown's avatarsmathermather1 Comment
Analysis, Database, PostGIS, PostgreSQL, SQL

Cleaning animal tracking data — throwing away extra points

Much the problem of the modern era– too much data, uneven data, and yet, should we keep it all? Here’s the problem space: attach GPS collar to a coyote, send that data home, and you have a recipe for gleaning a lot of information about the movement of that animal across the landscape. In order to maximize the data collected while also maximizing the battery … Continue reading Cleaning animal tracking data — throwing away extra points

Unknown's avatarsmathermather4 Comments
3D, Database, Other, pointcloud, PostGIS, PostgreSQL

LiDAR and pointcloud extension pt 5

Now for the crazy stuff: The objective is to allow us to do vertical and horizontal summaries of our data. To do this, we’ll take chipped LiDAR input and further chip it vertically by classifying it. First a classifier for height that we’ll use to do vertical splits on our point cloud chips: And now, let’s pull apart our point cloud, calculate heights from approximate … Continue reading LiDAR and pointcloud extension pt 5

Unknown's avatarsmathermatherLeave a comment