<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks for the reply,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bye,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Ludovico</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=robe.dnd@cityofboston.gov
href="mailto:robe.dnd@cityofboston.gov">Obe, Regina</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, September 28, 2007 5:07
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [postgis-users] is possible
to use a subset of the srid table?</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR SIZE=1>
<P></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>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE></BODY></HTML>