[postgis-users] Error in analysis

[Paragon Corporation]

Ravi,

Nope that wasn't your mistake.  It was ours in that we had changed the line
segment we were using to make more curvy but forgot to go back and change
the model.  It has been corrected since, but the latest updates of our
chapters has not been posted yet.  It should be posted sometime this week or
next.

Sorry about that.  Check this thread out

http://www.manning-sandbox.com/message.jspa?messageID=86852#86852

Leo 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ravi
Sent: Monday, July 06, 2009 6:21 PM
To: postgis
Subject: [postgis-users] Error in analysis


Hi,
>From PostGIS_MEAPCH01.pdf have done the exercise Coastline and public
facilities

for
SELECT p.poi_name, round(CAST(ST_Distance(p.poi_geom, c.line_geom) / 1000 As
numeric),2) As dist_km FROM hello.poi As p INNER JOIN hello.coastline As c
ON ST_DWithin(c.line_geom, p.poi_geom, 1000*3);

I get result "Hospital";0.92
checked it in openjump also and found correct.

The text of the pdf document indicates
poiname dist_km
Hospital 2.8

If this is my mistake I would like to correct myself.

Ravi


      Love Cricket? Check out live scores, photos, video highlights and
more. Click here http://cricket.yahoo.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users