[postgis-users] Geometry Functions?

[Gregory Williamson]

(Sorry for top-posting -- challenged email interface)

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. 

HTH,

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of chris hinkle
Sent: Mon 8/27/2007 3:20 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Geometry Functions?
 
I think the problem is simpler than that, select postgis_full_version();
gives the same error.

Is there a step I'm missing to initialize the db with the functions?

On 27/08/07, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
>
>
> To add you should check which version you have installed
>
> By running the following
>
> select postgis_full_version();
>
> If it returns something lower than 1.2.2 then you should use the names
> without the ST in front of them.
>
> I developed 2 cheatsheets.
>
> One is for 1.2.1
> http://www..bostongis.com/postgis_quickguide_1_2_1.bqg<http://www.bostongis.com/postgis_quickguide_1_2_1.bqg>
>
> and one is for 1.3.1
> http://www.bostongis.com/postgis_quickguide.bqg
>
> I'm still fleshing out the examples and gaps in both.  Hopefully these
> will be of benefit to you.
>
> Thanks,
> Regina
>
>  ------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Milo van der
> Linden
> *Sent:* Monday, August 27, 2007 4:19 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Geometry Functions?
>
> Hello Chris,
>
> Welcome!
>
> Try calling them without the ST_ in front of it:
>
> SELECT transform(simplify(transform(the_geom, 2249), 500),4326) from
> neighborhoods
>
> As described on:
>
> http://www.bostongis.com/postgis_simplify.snippet
>
> Good luck!
>
> chris hinkle schreef:
>
> 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.
>
> I installed Postgres and PostGIS using the binary windows installers.
> What did I miss?
>
> --
> Chris Hinkle
> Brooklyn, NY
> lilhinx at gmail.com
> 646-240-3024
>
> ------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.nethttp://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> --
>
>
>  Milo van der Linden
> skype: milovanderlinden
> mlinden at zeelandnet.nl
> milovanderlinden at gmail.com
> milo at 3dsite.nl
> http://www.3dsite.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. 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.
>
> ------------------------------
>
> * 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
>
>


-- 
Chris Hinkle
Brooklyn, NY
lilhinx at gmail.com
646-240-3024

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070827/94eabf47/attachment.html>