[postgis-users] View area

Sean M. Montague smontague at ATSDenver.com
Wed Feb 16 09:23:30 PST 2005


Strk, I really appreciate your help.  My geometries return valid, 't'.
I've imported a new shape file, Colorado counties in StatePlane NAD83.
Below is the full SQL statement I'm usisg.  I can send you the SQL file
for importing the table or the shape file itself if it'll help.

SELECT AsSVG(intersection(the_geom, setSRID('BOX3D(2705381 1688914,
2915183 1534212)'::box3d, 2332)),0,8) 
AS the_geom 
FROM counties 
WHERE the_geom && setSRID('BOX3D(2705381 1688914, 2915183
1534212)'::box3d, 2332);


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Wednesday, February 16, 2005 10:07 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] View area

On Wed, Feb 16, 2005 at 10:00:45AM -0700, Sean M. Montague wrote:
> I found a web site that said the version shipped with postgreSQL 8.0
> installer had problems and linked to a windows installer for PostGIS
> 0.9.1.  So I reloaded it, which is the version below.  I did get an
> improvement, I think, but still have problems with intersection.  I
> actually got polygons, but they don't resemble what actually exists.
> Looks like they've been generalized into triangles, and some points
were
> still returned.
> 
> POSTGIS="0.9.1" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
> DBPROC="0.0.1" RELPROC="0.0.1"

Are you input geometries valid - check isvalid() ?
Can you reproduce the *bug* with a single, full contained
( and possibly small ) sql script so I can take a look at it ?
--strk;

> 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> strk at refractions.net
> Sent: Wednesday, February 16, 2005 1:23 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] View area
> 
> On Tue, Feb 15, 2005 at 01:42:35PM -0700, Sean M. Montague wrote:
> > I'm using postgreSQL 8.0.1 win32 version and whichever postGIS comes
> > with it, 0.9.1 I think.  My input geometries are multi-part polygons
> > imported from a shape file.  Every state is its own multi-part poly,
> > regardless of the number of individual polys, at least as a shape
> file,
> > not sure how postGIS handles this.  I'm also not sure what GEOS I'm
> > using.  Is this an add-on installed separately?
> 
> If intersection is working it's probably installed by the package
> you got. Check output of SELECT postgis_full_version() to find
> out the version.
> 
> --strk;
> 
> > 
> > --Sean
> > 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> > strk at refractions.net
> > Sent: Tuesday, February 15, 2005 1:33 PM
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] View area
> > 
> > On Tue, Feb 15, 2005 at 12:37:25PM -0700, Sean M. Montague wrote:
> > > I've investigated what the relationship of the points is to the
> > original
> > > poly layer, and they are not the vertices, at least not all of
them.
> > > The original layer is the coast of south east Alaska with about 25
> > > islands.  The points may be some of the vertices perhaps, they do
> lie
> > on
> > > the coasts.  The summary() returns 556 "Object 0 is a POINT()" and
1
> > > "Object 0 is a LINESTRING() with 2 points".  The up side is, they
at
> > > least lie within my bounding box.
> > 
> > It sounds as a bug to me. Which GEOS version are you using ?
> > What types are input geometries ?
> > Which postgis version ? postgresql ?
> > --strk;
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list