Skip to content

Instantly share code, notes, and snippets.

View tmhalbert's full-sized avatar

Tim Halbert tmhalbert

2 followers · 2 following
View GitHub Profile
@tmhalbert
tmhalbert / StateBoundaries.sql
Created December 21, 2018 20:42 — forked from jakebathman/StateBoundaries.sql
The approximate max/min latitude and longitude for all states and major territories
-- Create the table
CREATE TABLE IF NOT EXISTS `StateBoundaries` (
`State` varchar(10) DEFAULT NULL,
`Name` varchar(255) DEFAULT NULL,
`MinLat` varchar(50) DEFAULT NULL,
`MaxLat` varchar(50) DEFAULT NULL,
`MinLon` varchar(50) DEFAULT NULL,
`MaxLon` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;