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

[Ludovico Bianchini]

Thanks for the reply,

you are right, 2MB is not so a problem. On the other hand, I need only two srids, so if there is no side effects I think I can start with them and add the other on demand in the future.

Bye,

Ludovico
  ----- Original Message ----- 
  From: Obe, Regina 
  To: PostGIS Users Discussion 
  Sent: Friday, September 28, 2007 5:07 PM
  Subject: RE: [postgis-users] is possible to use a subset of the srid table?


  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. 



------------------------------------------------------------------------------


  _______________________________________________
  postgis-users mailing list
  postgis-users at postgis.refractions.net
  http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070928/60622f37/attachment.html>