Re: how dod you get to do multiple mysql queries concurrently?
| From: | Paul Scott | Date: | Fri, 01 Feb 2008 04:33:01 +0000 |
| Subject: | Re: how dod you get to do multiple mysql queries concurrently? | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268515@lists.php.net to get a copy of this message | ||
On Fri, 2008-02-01 at 03:40 +0100, Jochem Maas wrote:
> I for one would really like to see a concrete example of this kind of
> use of geometry columns and spacial indexes as an alternative to the stand
> integer based primary keys.
On one of my local postGIS tables:
CREATE INDEX k1
ON kanagawa
USING gist
(the_geom);
A gist index is a GEOS based spatial index. You will need GEOS to create
one.
When loading spatial data, your geometry column looks like so:
01050000000100000001020000000C00000011ECE564CF7561404A8999CCDABC4140E5C0981ACE75614012901CD641BD4140603C8386BE756140E525611B40BD41405BF216D3BD756140151DC9E53FBD414054DC1A4DBD756140760B997A3FBD414012219BD1BC756140D20823E33EBD41407AB2884EBC7561400F2110243EBD41404571B4D0BB756140CC0C6A213DBD4140F707192ABB7561405DF2A1803CBD4140F0F11CA4BA756140C3D1B7413CBD4140E89CB2ADB97561406F046D233CBD414017D4B7CCA97561406D47AD7F39BD4140
Which is WKB (Well Known Binary) data or WKT (Well Known Text) data. The
gist index simply indexes this as opposed to the regular gid (which you
still use btree indexes on anyways)
--Paul