<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=606133414-28092007><FONT face=Arial
color=#0000ff size=2>How short on space are you? From my calculation - the
space taken up by the spatial ref table is a little under
2MB.</FONT></SPAN></DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff size=2>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=606133414-28092007><FONT face=Arial color=#0000ff
size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Ludovico Bianchini<BR><B>Sent:</B> Friday, September 28, 2007 10:24
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] is possible to use a subset of the srid
table?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2>I need to create many database on a
server.</FONT></DIV>
<DIV><FONT face=Arial size=2>Every one has to be spatially enabled, so I must
load postgis object in every one.</FONT></DIV>
<DIV><FONT face=Arial size=2>I want to save disk space...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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??)?</FONT></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>