Test new types that use PostGIS geometry fields for smokePPE data

[dadamsncsa]

Description

PostGIS extensions are supported on c3:

• https://community.c3.ai/t/how-can-i-leverage-geo-queries-provided-by-the-postgis-extension-in-the-typesystem/997/2
• Also see c3ShowType(ExpressionEngineFunction)

In theory GiST indices should operate much faster that traditional b-tree type indices

Overall Approach

Begin by using GeoPointWithMeasure type for a field in place ofGeoSurfaceTimePoint. The 'M measure value will be time ( converted to epoch timestamps.

Steps

• [x] Create type with PoiustGIS field: SmokePPEGeoTimeSimulationOutput
• [x] Create a new data processing routine to extract data from the files and insert to new data type
• [x] Run routine on small subset and test
• [ ] Run routine on full dataset
• [ ] Test queires

PostGIS references

• https://postgis.net/docs/
• https://blog.rustprooflabs.com/2020/11/postgis-trajectory-intro
• https://anitagraser.com/2018/04/16/movement-data-in-gis-12-why-you-should-be-using-postgis-trajectories/

[dadamsncsa]

The C3 support of PostGIS is somewhat limited at the moment, but I think it could still help us...

https://community.c3.ai/t/query-within-bounding-box-on-a-geopointwithmeasure-field/14440