2008. 02. 1, péntek keltezéssel 11.55-kor Paul Scott ezt írta: > Did anyone actually get this mail? > > More concrete example? What would you like to see? > > I suspect that some of my mail is getting dropped :( sure I got it but answered before I reached it in reading. sorry for the noise. as for the GEOS stuff I think I'll do some research on it, it sounds very interesting greets Zoltán Németh > > --Paul > > On Fri, 2008-02-01 at 06:33 +0200, Paul Scott wrote: > > 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 > > > > All Email originating from UWC is covered by disclaimer > > http://www.uwc.ac.za/portal/public/portal_services/disclaimer.htm > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > All Email originating from UWC is covered by disclaimer > http://www.uwc.ac.za/portal/public/portal_services/disclaimer.htm > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
