Skip to content

13 centrelines referenced from miovision_api.centreline_miovision are no longer in centreline_latest #1168

@Nate-Wessel

Description

@Nate-Wessel

They exist in the history of the centreline table (2023-04-01) so they were probably correct originally, but should now be updated.

WITH unmatched_centrelines AS (
    SELECT centreline_id
    FROM miovision_api.centreline_miovision
    LEFT JOIN gis_core.centreline_latest USING (centreline_id)
    WHERE centreline_latest.version_date IS NULL
)

SELECT DISTINCT ON (centreline_id)
    centreline.*
FROM gis_core.centreline
JOIN unmatched_centrelines USING (centreline_id)
ORDER BY
    centreline_id,
    version_date ASC

Metadata

Metadata

Assignees

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions