Alex Sorokine's Random Notes

This is a revised random-point-in-polygon function first discussed in my earlier post . It turns out that in some weird cases (multipolygon...

Check the revised version of this post. This is a function that I wrote to generate a random point inside a polygon. It works by first g...

This is a continuation of my previous post . To make GNIS useable with spatial queries you need to add geometry or geography column to the...

The script below will load GNIS National File into PostgreSQL. You can download National File from here (about 280MB uncompressed, main we...

Google has come up with a new service with some neat features. Now you can shorten your URL if you go to http://goo.gl/ . So, for example,...