[postgis-users] is possible to use a subset of the srid table?

[Obe, Regina]

How short on space are you?  From my calculation - the space taken up by
the spatial ref table is a little under 2MB.
 
If you did want to save space by keeping only the records you need, I
think the only issue arises is should you have an application that needs
to transform the spatial geometry to another projection you don't have
listed in your table, then it will probably break. If you can guarantee
no such situation will arise or you don't care, then you should be fine.
 
I'm not sure about the distance_sphere and other *sphere *  functions
whether they use any entries in the database other than the one in the
SRID for the particular geometries passed in.  I suspect they do not so
you should be fine there.
 
Hope that helps,
Regina


________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Ludovico Bianchini
Sent: Friday, September 28, 2007 10:24 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] is possible to use a subset of the srid table?


Hi,
I need to create many database on a server.
Every one has to be spatially enabled, so I must load postgis object in
every one.
I want to save disk space...
 
My question is: if I modify spatial_ref_sys.sql taking only srid records
that I need, could I find any problem (maybe there are functions which
silently use that table??)?



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070928/6d08ce42/attachment.html>