[postgis] Error in creating WKBPolygon by Postgis

Dave Blasby dblasby at refractions.net
Tue Sep 4 14:37:48 PDT 2001

Hisaji ONO wrote:
>  Thank you very much, Dave.
> > I've added full[er] support for the WKB type.
> >
>  "full[er] support for the WKB type" includes creating spatial indexes for
> WKB-type items or not?

No, there are no operations you can perform on the WKB types.

If you want spatial indexing you have a few choices.

One of them is to just have a GEOMETRY column.  You can use the spatial
index on this column, and retrieve results using the asbinary() command.

The other is to create two columns, one with GEOMETRY and the other as
the WKB representation of the geometry.  You can use the spatial index
on the GEOMETRY column, but get information out of the WKB column.

For example,
The first method, queries would look like;
SELECT asbinary(<geometry column>) FROM <table> WHERE <geometry column>
&& <bounding box>

And the second method would look like;
SELECT <wkb column> FROM <table> WHERE <geometry column> && <bounding

The major difference being that the 1st method requires translating the
internal GEOMETRY format to the WKB format for every query.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of VeriSign's FREE Guide: "Securing Your Web Site for Business." Get it Now!

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 

More information about the postgis-users mailing list