<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>3DSite</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left> </DIV>
<DIV><SPAN
class=877382120-27082007></SPAN>To add you should check which version you have installed</DIV>
<DIV> </DIV>
<DIV><SPAN class=877382120-27082007></SPAN><SPAN
class=877382120-27082007></SPAN>B<SPAN class=877382120-27082007>y running the
following</SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007></SPAN>s<SPAN class=877382120-27082007>elect
postgis_full_version();</SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007>If it returns something lower than 1.2.2
then you should use the names without the ST in front of them.</SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007>I developed 2 cheatsheets.
</SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007>One is for 1.2.1</SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN><SPAN class=877382120-27082007><A
href="http://www.bostongis.com/postgis_quickguide_1_2_1.bqg">http://www..bostongis.com/postgis_quickguide_1_2_1.bqg</A></SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007>and one is for 1.3.1</SPAN></DIV>
<DIV><SPAN class=877382120-27082007><A
href="http://www.bostongis.com/postgis_quickguide.bqg">http://www.bostongis.com/postgis_quickguide.bqg</A></SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007>I'm still fleshing out the examples and gaps
in both. Hopefully these will be of benefit to
you. </SPAN></DIV>
<DIV><SPAN class=877382120-27082007></SPAN> </DIV>
<DIV><SPAN class=877382120-27082007>Thanks,</SPAN></DIV>
<DIV><SPAN class=877382120-27082007>Regina </SPAN></DIV>
<DIV><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>Milo
van der Linden<BR><B>Sent:</B> Monday, August 27, 2007 4:19 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Geometry
Functions?<BR></FONT><BR></DIV>
<DIV></DIV>Hello Chris, <BR><BR>Welcome!<BR><BR>Try calling them without the ST_
in front of it:<BR><BR><SPAN id=ctl00_cphMain_BodyContent><SPAN
color="red"><SPAN><CODE>SELECT transform(simplify(transform(the_geom, 2249),
500),4326) from neighborhoods<BR><BR>As described on:<BR><BR><A
class=moz-txt-link-freetext
href="http://www.bostongis.com/postgis_simplify.snippet">http://www.bostongis.com/postgis_simplify.snippet</A><BR><BR>Good
luck!<BR><BR></CODE></SPAN></SPAN></SPAN>chris hinkle schreef:
<BLOCKQUOTE cite=mid:dda5970b0708271228j1dd7a130na7bab28aa116b838@mail.gmail.com
type="cite">Hi, very new to this, but I'm trying to call functions like
ST_Simplify and I'm getting errors telling me that the function doesn't
exist.<BR><BR>I installed Postgres and PostGIS using the binary windows
installers. What did I miss? <BR clear=all><BR>-- <BR>Chris
Hinkle<BR>Brooklyn, NY<BR><A href="mailto:lilhinx@gmail.com"
moz-do-not-send="true">lilhinx@gmail.com</A><BR>646-240-3024 <PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE><BR><BR>
<DIV class=moz-signature>-- <BR>
<STYLE type=text/css>BODY {
MARGIN: 5px; BACKGROUND-COLOR: #ffffff
}
BODY {
FONT-SIZE: 12px; COLOR: #333333; FONT-FAMILY: Arial, Helvetica, sans-serif
}
TD {
FONT-SIZE: 12px; COLOR: #333333; FONT-FAMILY: Arial, Helvetica, sans-serif
}
TH {
FONT-SIZE: 12px; COLOR: #333333; FONT-FAMILY: Arial, Helvetica, sans-serif
}
..style4 {
FONT-SIZE: 9px
}
..style5 {
FONT-SIZE: 9px; COLOR: #cccccc
}
</STYLE>
<META content="MSHTML 6.00.2900.2912" name=GENERATOR><BR>
<TABLE cellSpacing=0 cellPadding=0 width=400 border=0>
<TBODY>
<TR>
<TD vAlign=bottom align=left width=15 height=0 rowSpan=3><BR></TD>
<TD vAlign=top align=left width=0 colSpan=2 height=78>
<P class=style4>Milo van der Linden <BR><A
href="skype:milovanderlinden?add">skype: milovanderlinden</A><BR><A
href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</A><BR><A
href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</A><BR><A
href="mailto:milo@3dsite.nl">milo@3dsite.nl</A><BR><A
href="http://www.3dsite.nl">http://www.3dsite.nl</A><BR></P></TD>
<TD vAlign=top align=left width=15 height=0 rowSpan=3> </TD>
<TD vAlign=top width=300>
<P class=style5><SPAN lang=NL>De informatie in dit bericht reflecteert
mijn persoonlijke mening en niet die van een bedrijf of instantie. Aan de
informatie kunnen geen rechten worden ontleend. Indien dit bericht
onderdeel is van een forum, mailing-list of community dan gelden
automatisch de bij het betreffende medium behorende voorwaarden.</SPAN>
<SPAN lang=EN>The information in this message reflects my personal opinion
and not that of a company or public body. All rights reserved.If this
message is contained in a mailing-list or community, the rights on the
medium are automatically
adapted.</SPAN></P></TD></TR></TBODY></TABLE></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>