<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] Geometry Functions?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>(Sorry for top-posting -- challenged email interface)<BR>
<BR>
The install sets up the proper DDLs and the like, but to access them you need to run some SQL in the database you want to enable, specifically the sql file called "lwpostgis.sql" (not sure where Windows would put this though -- I have linux only at hand), and then run the "spatial_ref_sys.sql" to populate the needed SRIDs.<BR>
<BR>
HTH,<BR>
<BR>
Greg Williamson<BR>
Senior DBA<BR>
GlobeXplorer LLC, a DigitalGlobe company<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of chris hinkle<BR>
Sent: Mon 8/27/2007 3:20 PM<BR>
To: PostGIS Users Discussion<BR>
Subject: Re: [postgis-users] Geometry Functions?<BR>
<BR>
I think the problem is simpler than that, select postgis_full_version();<BR>
gives the same error.<BR>
<BR>
Is there a step I'm missing to initialize the db with the functions?<BR>
<BR>
On 27/08/07, Obe, Regina <robe.dnd@cityofboston.gov> wrote:<BR>
><BR>
><BR>
> To add you should check which version you have installed<BR>
><BR>
> By running the following<BR>
><BR>
> select postgis_full_version();<BR>
><BR>
> If it returns something lower than 1.2.2 then you should use the names<BR>
> without the ST in front of them.<BR>
><BR>
> I developed 2 cheatsheets.<BR>
><BR>
> One is for 1.2.1<BR>
> <A HREF="http://www..bostongis.com/postgis_quickguide_1_2_1.bqg">http://www..bostongis.com/postgis_quickguide_1_2_1.bqg</A><<A HREF="http://www.bostongis.com/postgis_quickguide_1_2_1.bqg">http://www.bostongis.com/postgis_quickguide_1_2_1.bqg</A>><BR>
><BR>
> and one is for 1.3.1<BR>
> <A HREF="http://www.bostongis.com/postgis_quickguide.bqg">http://www.bostongis.com/postgis_quickguide.bqg</A><BR>
><BR>
> I'm still fleshing out the examples and gaps in both. Hopefully these<BR>
> will be of benefit to you.<BR>
><BR>
> Thanks,<BR>
> Regina<BR>
><BR>
> ------------------------------<BR>
> *From:* postgis-users-bounces@postgis.refractions.net [mailto:<BR>
> postgis-users-bounces@postgis.refractions.net] *On Behalf Of *Milo van der<BR>
> Linden<BR>
> *Sent:* Monday, August 27, 2007 4:19 PM<BR>
> *To:* PostGIS Users Discussion<BR>
> *Subject:* Re: [postgis-users] Geometry Functions?<BR>
><BR>
> Hello Chris,<BR>
><BR>
> Welcome!<BR>
><BR>
> Try calling them without the ST_ in front of it:<BR>
><BR>
> SELECT transform(simplify(transform(the_geom, 2249), 500),4326) from<BR>
> neighborhoods<BR>
><BR>
> As described on:<BR>
><BR>
> <A HREF="http://www.bostongis.com/postgis_simplify.snippet">http://www.bostongis.com/postgis_simplify.snippet</A><BR>
><BR>
> Good luck!<BR>
><BR>
> chris hinkle schreef:<BR>
><BR>
> Hi, very new to this, but I'm trying to call functions like ST_Simplify<BR>
> 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.<BR>
> What did I miss?<BR>
><BR>
> --<BR>
> Chris Hinkle<BR>
> Brooklyn, NY<BR>
> lilhinx@gmail.com<BR>
> 646-240-3024<BR>
><BR>
> ------------------------------<BR>
><BR>
> _______________________________________________<BR>
> postgis-users mailing list<BR>
> postgis-users@postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users<BR>
><BR>
><BR>
><BR>
> --<BR>
><BR>
><BR>
> Milo van der Linden<BR>
> skype: milovanderlinden<BR>
> mlinden@zeelandnet.nl<BR>
> milovanderlinden@gmail.com<BR>
> milo@3dsite.nl<BR>
> <A HREF="http://www.3dsite.nl">http://www.3dsite.nl</A><BR>
><BR>
><BR>
> De informatie in dit bericht reflecteert mijn persoonlijke mening en niet<BR>
> die van een bedrijf of instantie. Aan de informatie kunnen geen rechten<BR>
> worden ontleend. Indien dit bericht onderdeel is van een forum, mailing-list<BR>
> of community dan gelden automatisch de bij het betreffende medium behorende<BR>
> voorwaarden. The information in this message reflects my personal opinion<BR>
> and not that of a company or public body. All rights reserved.If this<BR>
> message is contained in a mailing-list or community, the rights on the<BR>
> medium are automatically adapted.<BR>
><BR>
> ------------------------------<BR>
><BR>
> * The substance of this message, including any attachments, may be<BR>
> confidential, legally privileged and/or exempt from disclosure pursuant to<BR>
> Massachusetts law. It is intended solely for the addressee. If you received<BR>
> this in error, please contact the sender and delete the material from any<BR>
> computer. *<BR>
><BR>
> _______________________________________________<BR>
> postgis-users mailing list<BR>
> postgis-users@postgis.refractions.net<BR>
> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
><BR>
><BR>
<BR>
<BR>
--<BR>
Chris Hinkle<BR>
Brooklyn, NY<BR>
lilhinx@gmail.com<BR>
646-240-3024<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>