Changes between Initial Version and Version 1 of Ticket #5387, comment 8
- Timestamp:
- Jun 19, 2023, 1:44:39 PM (14 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #5387, comment 8
initial v1 1 Yes - but it doesn't make sense to have to sync up the SRIDs in that table with the systems in proj.db. Apart from any other concerns, we'd have to find and use some form of integer IDs for them - and not all of them are EPSG CRSes. In addition the Postgres database is not deployed concurrently with the proj.db in our app images and so trying to keep them in sync would require complex migrations, which can be avoided if we skip using spatial_ref_sys at all.1 Yes - but it doesn't make sense to have to sync up the SRIDs in that table with the systems in proj.db. Apart from any other concerns, we'd have to find and use some form of integer IDs for them - and not all of them are EPSG CRSes. 2 2 3 3 I feel like that concern is tangential - the issue I had in this ticket is that some forms of the ST_Transform() function are very slow - presumably they are not caching their transforms across multiple input rows. Can this be improved?