Skip to content

Dynamically compute geometry for reference track #271

Description

@lewismc

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    storageAnything tagbase-server storage/persistence related.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions