search

tagbase / tagbase-server

tagbase-server is a data management web service for working with eTUFF and nc-eTAG files.
https://oiip.jpl.nasa.gov/doc/OIIP_Deliverable7.4_TagbasePostgreSQLeTUFF_UserGuide.pdf
Apache License 2.0
7 stars 2 forks source link

Dynamically compute geometry for reference track #271

Open lewismc opened 1 year ago

lewismc commented 1 year ago

At today's tagup, Jesus presented a use case which dynamically computes the geometry for a reference track

UPDATE data_position SET the_geom = st_setsrid(st_makepoint(cast(data_position.lon as float), cast(data_position.lat as float)), 4326);

ALTER TABLE data_position ADD COLUMN the_geom geometry(Point,4326);

We DO NOT want to include this in the data model but we could possibly include a stored procedure which could be triggered on-demand.