Groove 11 Code Blog

Drupalcon 2010 SF Beckons

I'm off to my first Drupal con in just a few hours. Not at all sure what to expect. Being essentially a novice, I just hope I am able to grasp enough during the sessions to make the three days worthwhile.

I've been tracking all the #drupalcon tweets and the "Drupalistas" are nothing if not enthusiastic (the hard core pre-conference stuff started Saturday, two days before the "regular" conference). I'm terrible at networking, but I hope to meet a few Drupal folk. Groove 11 can always use more Drupal resources.

I also have a nagging feeling that in two or three months I will wish I could go back to Drupalcon SF 2010 and do it over again with the knowledge gained after the conference.

SQL For Creating States, Provinces, Districts, and Territories

INSERT INTO `state` (`state_id`, `abbr`, `name`) VALUES
(1,'AL','Alabama'),
(2,'AK','Alaska'),
(3,'AB','Alberta'),
(4,'AZ','Arizona'),
(5,'AR','Arkansas'),
(6,'BC','British Columbia'),
(7,'CA','California'),
(8,'CO','Colorado'),
(9,'CT','Connecticut'),
(10,'DE','Delaware'),
(11,'DC','District of Columbia'),
(12,'FL','Florida'),
(13,'GA','Georgia'),
(14,'HI','Hawaii'),
(15,'ID','Idaho'),
(16,'IL','Illinois'),
(17,'IN','Indiana'),
(18,'IA','Iowa'),
(19,'KS','Kansas'),
(20,'KY','Kentucky'),
(21,'LB','Labrador'),
(22,'LA','Louisiana'),
(23,'ME','Maine'),
(24,'MB','Manitoba'),
(25,'MD','Maryland'),
(26,'MA','Massachusetts'),
(27,'MI','Michigan'),
(28,'MN','Minnesota'),
(29,'MS','Mississippi'),
(30,'MO','Missouri'),
(31,'MT','Montana'),
(32,'NE','Nebraska'),
(33,'NV','Nevada'),
(34,'NB','New Brunswick'),
(35,'NL','Newfoundland'),
(36,'NH','New Hampshire'),
(37,'NJ','New Jersey'),
(38,'NM','New Mexico'),
(39,'NY','New York'),
(40,'NC','North Carolina'),
(41,'ND','North Dakota'),
(42,'NT','Northwest Territories'),
(43,'NS','Nova Scotia'),
(44,'NU','Nunavut'),
(45,'OH','Ohio'),
(46,'OK','Oklahoma'),
(47,'ON','Ontario'),
(48,'OR','Oregon'),
(49,'PA','Pennsylvania'),
(50,'PE','Prince Edward Island'),
(51,'QC','Quebec'),
(52,'RI','Rhode Island'),
(53,'SK','Saskatchewan'),
(54,'SC','South Carolina'),
(55,'SD','South Dakota'),
(56,'TN','Tennessee'),
(57,'TX','Texas'),
(58,'UT','Utah'),
(59,'VT','Vermont'),
(60,'VA','Virginia'),
(61,'WA','Washington'),
(62,'WV','West Virginia'),
(63,'WI','Wisconsin'),
(64,'WY','Wyoming'),
(65,'YT','Yukon Territory');