Skip to content
This repository was archived by the owner on Jan 4, 2022. It is now read-only.
This repository was archived by the owner on Jan 4, 2022. It is now read-only.

Inconsistent SRIDs in database geom fields #430

@xhoenner

Description

@xhoenner

Applies to the capture_location and release_location fields in animal_release, but would be worth checking all the geom fields in the database while fixing up this issue.

select st_srid(capture_location) as capture_location_srid, count(*) as nb_occurrences from aatams.animal_release
group by st_srid(capture_location)
order by capture_location_srid;
capture_location_srid nb_occurrences
0 229
4326 6528
28353 19
28355 1
1

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions