17 - Reviewing Tabular Geospatial Data

When tabular data contains geospatial elements, analysts can use Contour to visualize it or Code Workbook to apply common libraries for various geospatial analysis workflows.

In this task, we'll review some of the ways geospatial data appears in tabular data.

🔨 Task Instructions

1. Open the runways dataset located in /Foundry Training and Resources/Example Data/Aviation Ontology/runways.

2. Scroll through the columns, noting that there are four that contain geospatial data:

   • latitude: the airport's latitude. Analysts can use this property (along with the accompanying longitude) to plot a point in a Contour map.
   • longitude: the airport's longitude. Analysts can use this property (along with the accompanying latitude) to plot a point in a Contour map.
   • geohash: Concatenation of latitude and longitude that is mapped to a geohash property in the Ontology so that it can be used to plot points in Ontology-aware applications.
   • line_geojson: JSON representation of a shape, in this case of the runway line, that can be used in tabular and Ontology analysis applications.

3. Let's show how the lat/long values and the geoJSON in the tabular data can be represented in Contour. Click the blue Analyze button to open the dataset in Contour.

4. Filter to just those rows where the elevation_ft > 5000.

5. Add a Map board to your analysis.

6. Configure two layers in the board: one to represent the airport points (using the latitude and longitude columns) and another to show the runway lines (using the line_geojson column) as shown below.

7. Zoom in on any of the airport points to see the geojson runway lines.