[postgis-devel] [PostGIS] #1505: Deal with database dumps containing geometries with SRID > MAX_SRID
PostGIS
trac at osgeo.org
Fri Feb 10 08:30:19 PST 2012
#1505: Deal with database dumps containing geometries with SRID > MAX_SRID
---------------------+------------------------------------------------------
Reporter: strk | Owner: pramsey
Type: defect | Status: new
Priority: high | Milestone: PostGIS 2.0.0
Component: postgis | Version: trunk
Keywords: |
---------------------+------------------------------------------------------
Comment(by pramsey):
Not sure what the point is here... we're mapping 4B values into 1000
slots, it's known we're going to have a chance of collision. Particularly
if we use an even modulo (1000) peoples tendency to build SRIDs by
starting from a round number will drastically increase odds of collision.
Using a CRC is one way to avoid this. Another is to just go modulo 999.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1505#comment:21>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list