Mi-ss-i-ss-i-pp-i

January 27, 2012 4:07 PM

StateTable:  US/Canada  states, provinces,  territories and minor possessions as CSV, SQL, HTML form elements, PHP arrays, and more. All the countries in the world, as a text list, CSV and API (from the very handy and open Factual).
Also: FreeMapTools, including “how far can I travel from any point on the Earth in a certain time, using a form of ground transportation?”, and “If I dug a tunnel straight through the planet, where should I emerge?” (previously)
posted by Bora Horza Gobuchul (11 comments total)

The "how far can I travel?" too is so awesome that I'm going to complain about it -- when I tell it I want to go by "walking" some of the points on the boundary of the region it comes up with are marked by little flags in the middle of a freeway.
posted by madcaptenor at 4:15 PM on January 27, 2012

(Apparently there's an "avoid highways" button. But when I click walking, shouldn't it assume I don't want to walk on the highway?)
posted by madcaptenor at 4:16 PM on January 27, 2012

I've always wondered where I'd tunnel out to, and this finally answers that question. Thanks interwebs!
posted by [insert clever name here] at 4:21 PM on January 27, 2012

EARTH IS BORING!

I checked every single place I have ever lived and EVERY GODDAMN TIME I'd emerge at the bottom of the Pacific or Indian Ocean if I dug straight through.

Stupid waterlogged planet.
posted by Hairy Lobster at 5:07 PM on January 27, 2012 [1 favorite]

Gosh darn it that StateTable website has a swell UI, and golly gee does it make me feel old.
posted by i_have_a_computer at 5:39 PM on January 27, 2012

No, YOU'RE BORING. And you shouldn't be. Boring through the earth is dangerous and unlikely to be successful.

I too was a bit disappointed by "how far can I travel". For walking, Walkscore's "Street Smart Walk Score" is more interesting, though it's fixed to 15 minutes (find your address on the regular site, then click on "check out your new score".
posted by alexei at 6:03 PM on January 27, 2012

I always wondered how long it would take me to walk from my city to my family's farm in the event of the apocalypse—48 hours. That seems manageable, assuming I beat my cousins.
posted by ifandonlyif at 6:44 PM on January 27, 2012

Stupid waterlogged planet.

hehehe ... start in the middle of the Pacific with the most isolated land mass in the world - the Hawaiian Islands. Dig. End up in Botswana!

... maybe tunneling is faster/shorter travel route than flying to nearest continent?
posted by Surfurrus at 8:18 PM on January 27, 2012

surfurrus, tunneling would take 42 minutes.
posted by madcaptenor at 10:46 PM on January 27, 2012 [1 favorite]

Wait, it's just a list of states? No coordinates, no FIPS or GNIS? I don't get it. What does that have to do with map tools?
posted by desjardins at 11:22 PM on January 27, 2012 [1 favorite]

How splendid. If you dug a tunnel near Salamanca (Spain) where Wellington (Duke of) fought a famous battle, you'd end up in Wellington (NZ). I love this. The universe makes sense!
posted by kariebookish at 1:05 AM on January 28, 2012