From: Paul Ramsey <pramsey@refractions.net>
Subject: [postgis-users] (no subject)
Date: Fri, 16 Apr 2004 07:45:24 -0700
Message-ID: <B15E8FCC-8FB4-11D8-AD91-000393D33C2E@refractions.net> (raw)
In-Reply-To: <1082122224.3927.31.camel@davidpc>
Over 30 km, your elevations are not going to make much of a difference
to your distance calculations. There is no distance3d function, because
of the difficulties in coding it and relative obscurity of the
functionality (always a deadly combination :). There is a length3d
function, which tends to be more useful (how far is it *really* from A
to B, including up and down hills).
P.
On Friday, April 16, 2004, at 06:30 AM, David Sharp wrote:
> Hi ,
>
> I was just wondering , at the moment I am using the following command
> to
> enter data into my database.
>
> insert into
> table(id,poly_geom,name,level)values(1,GeometryFromText('POLYGON((5
> 2.30 -9.75 0,52.30 -9.66 0,52.25 -9.66 0,52.25 -9.75 0,52.30 -9.75
> 0))',-1),'
>
>
> If I wanted to integrate height also into my table of polygons would I
> just replace the zero value with the height in meters.
>
> Once I then query the database for places within a 30km range will it
> take the height into account when It returns my result.
>
> Any help appreciated
>
> regards
>
> David Sharp
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
Paul Ramsey
Refractions Research
Email: pramsey at refractions.net
Phone: (250) 885-0632
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgis-users@lists.osgeo.org
Cc: pramsey@refractions.net
Subject: Re: [postgis-users] (no subject)
In-Reply-To: <B15E8FCC-8FB4-11D8-AD91-000393D33C2E@refractions.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox