> -- Even if you only go down to 1'-by-1' granularity, you've divided the > world into 64,800 blocks. Assuming that your 840K cities are all over the > globe, and that about 70% of Earth is covered by water, that means that only > about 20,000 blocks would actually have cities in them. But with 840K > cities, that means you're only considering about 42 cities for a single > block.
Nice! Though I haven't been part of this thread, I wanted to comment that this is a very elegant & efficient solution. Kind of like a 2-D hash table. I can see other areas where a similar approach would be helpful. Thanks for a good tip-- I'm sure it will come in handy at some point. ~Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users