The approximate max/min latitude and longitude for all states and major territories

state_boundaries.json

{
  "AK":
  {
    "name": "Alaska",
    "min_lat": 52.5964,
    "max_lat": 71.5232,
    "min_lng": -169.9146,
    "max_lng": -129.993
  },
  "AL":
  {
    "name": "Alabama",
    "min_lat": 30.1463,
    "max_lat": 35.0041,
    "min_lng": -88.4743,
    "max_lng": -84.8927
  },
  "AR":
  {
    "name": "Arkansas",
    "min_lat": 33.0075,
    "max_lat": 36.4997,
    "min_lng": -94.6198,
    "max_lng": -89.6594
  },
  "AZ":
  {
    "name": "Arizona",
    "min_lat": 31.3325,
    "max_lat": 37.0004,
    "min_lng": -114.8126,
    "max_lng": -109.0475
  },
  "CA":
  {
    "name": "California",
    "min_lat": 32.5121,
    "max_lat": 42.0126,
    "min_lng": -124.6509,
    "max_lng": -114.1315
  },
  "CO":
  {
    "name": "Colorado",
    "min_lat": 36.9949,
    "max_lat": 41.0006,
    "min_lng": -109.0489,
    "max_lng": -102.0424
  },
  "CT":
  {
    "name": "Connecticut",
    "min_lat": 40.9509,
    "max_lat": 42.0511,
    "min_lng": -73.7272,
    "max_lng": -71.7874
  },
  "DE":
  {
    "name": "Delaware",
    "min_lat": 38.4482,
    "max_lat": 39.8296,
    "min_lng": -75.7919,
    "max_lng": -74.8526
  },
  "FL":
  {
    "name": "Florida",
    "min_lat": 24.3959,
    "max_lat": 31.0035,
    "min_lng": -87.6256,
    "max_lng": -79.8198
  },
  "GA":
  {
    "name": "Georgia",
    "min_lat": 30.3575,
    "max_lat": 34.9996,
    "min_lng": -85.6082,
    "max_lng": -80.696
  },
  "HI":
  {
    "name": "Hawaii",
    "min_lat": 18.71,
    "max_lat": 22.3386,
    "min_lng": -160.3922,
    "max_lng": -154.6271
  },
  "IA":
  {
    "name": "Iowa",
    "min_lat": 40.3622,
    "max_lat": 43.5008,
    "min_lng": -96.6357,
    "max_lng": -90.1538
  },
  "ID":
  {
    "name": "Idaho",
    "min_lat": 41.9871,
    "max_lat": 49.0018,
    "min_lng": -117.2372,
    "max_lng": -111.0471
  },
  "IL":
  {
    "name": "Illinois",
    "min_lat": 36.9894,
    "max_lat": 42.5116,
    "min_lng": -91.512,
    "max_lng": -87.0213
  },
  "IN":
  {
    "name": "Indiana",
    "min_lat": 37.7718,
    "max_lat": 41.7611,
    "min_lng": -88.098,
    "max_lng": -84.809
  },
  "KS":
  {
    "name": "Kansas",
    "min_lat": 36.9927,
    "max_lat": 40.0087,
    "min_lng": -102.0506,
    "max_lng": -94.6046
  },
  "KY":
  {
    "name": "Kentucky",
    "min_lat": 36.4931,
    "max_lat": 39.1439,
    "min_lng": -89.5372,
    "max_lng": -82.0308
  },
  "LA":
  {
    "name": "Louisiana",
    "min_lat": 28.8832,
    "max_lat": 33.0225,
    "min_lng": -94.043,
    "max_lng": -88.7421
  },
  "MA":
  {
    "name": "Massachusetts",
    "min_lat": 41.159,
    "max_lat": 42.889,
    "min_lng": -73.5081,
    "max_lng": -69.7398
  },
  "MD":
  {
    "name": "Maryland",
    "min_lat": 37.8889,
    "max_lat": 39.722,
    "min_lng": -79.4861,
    "max_lng": -74.8581
  },
  "ME":
  {
    "name": "Maine",
    "min_lat": 42.9182,
    "max_lat": 47.455,
    "min_lng": -71.0829,
    "max_lng": -66.8628
  },
  "MI":
  {
    "name": "Michigan",
    "min_lat": 41.6965,
    "max_lat": 48.3042,
    "min_lng": -90.4175,
    "max_lng": -82.1221
  },
  "MN":
  {
    "name": "Minnesota",
    "min_lat": 43.5008,
    "max_lat": 49.3877,
    "min_lng": -97.2304,
    "max_lng": -89.4919
  },
  "MO":
  {
    "name": "Missouri",
    "min_lat": 35.9958,
    "max_lat": 40.6181,
    "min_lng": -95.7527,
    "max_lng": -89.1005
  },
  "MS":
  {
    "name": "Mississippi",
    "min_lat": 30.0905,
    "max_lat": 35.0075,
    "min_lng": -91.6589,
    "max_lng": -88.0994
  },
  "MT":
  {
    "name": "Montana",
    "min_lat": 44.3563,
    "max_lat": 48.9991,
    "min_lng": -116.0458,
    "max_lng": -104.0186
  },
  "NC":
  {
    "name": "North Carolina",
    "min_lat": 33.7666,
    "max_lat": 36.588,
    "min_lng": -84.3201,
    "max_lng": -75.4129
  },
  "ND":
  {
    "name": "North Dakota",
    "min_lat": 45.934,
    "max_lat": 48.9982,
    "min_lng": -104.0501,
    "max_lng": -96.5671
  },
  "NE":
  {
    "name": "Nebraska",
    "min_lat": 39.9992,
    "max_lat": 43.0006,
    "min_lng": -104.0543,
    "max_lng": -95.3091
  },
  "NH":
  {
    "name": "New Hampshire",
    "min_lat": 42.6986,
    "max_lat": 45.3058,
    "min_lng": -72.5592,
    "max_lng": -70.5583
  },
  "NJ":
  {
    "name": "New Jersey",
    "min_lat": 38.8472,
    "max_lat": 41.3593,
    "min_lng": -75.5708,
    "max_lng": -73.8885
  },
  "NM":
  {
    "name": "New Mexico",
    "min_lat": 31.3337,
    "max_lat": 36.9982,
    "min_lng": -109.0489,
    "max_lng": -103.0023
  },
  "NV":
  {
    "name": "Nevada",
    "min_lat": 35.003,
    "max_lat": 42.0003,
    "min_lng": -120.0037,
    "max_lng": -114.0436
  },
  "NY":
  {
    "name": "New York",
    "min_lat": 40.4772,
    "max_lat": 45.0153,
    "min_lng": -79.7624,
    "max_lng": -71.7517
  },
  "OH":
  {
    "name": "Ohio",
    "min_lat": 38.3761,
    "max_lat": 42.321,
    "min_lng": -84.8172,
    "max_lng": -80.5188
  },
  "OK":
  {
    "name": "Oklahoma",
    "min_lat": 33.6386,
    "max_lat": 37.0015,
    "min_lng": -103.0064,
    "max_lng": -94.4357
  },
  "OR":
  {
    "name": "Oregon",
    "min_lat": 41.9952,
    "max_lat": 46.2891,
    "min_lng": -124.7305,
    "max_lng": -116.4606
  },
  "PA":
  {
    "name": "Pennsylvania",
    "min_lat": 39.7199,
    "max_lat": 42.5167,
    "min_lng": -80.5243,
    "max_lng": -74.707
  },
  "RI":
  {
    "name": "Rhode Island",
    "min_lat": 41.1849,
    "max_lat": 42.0156,
    "min_lng": -71.9041,
    "max_lng": -71.0541
  },
  "SC":
  {
    "name": "South Carolina",
    "min_lat": 32.0453,
    "max_lat": 35.2075,
    "min_lng": -83.3588,
    "max_lng": -78.4836
  },
  "SD":
  {
    "name": "South Dakota",
    "min_lat": 42.4772,
    "max_lat": 45.9435,
    "min_lng": -104.0529,
    "max_lng": -96.438
  },
  "TN":
  {
    "name": "Tennessee",
    "min_lat": 34.9884,
    "max_lat": 36.6871,
    "min_lng": -90.3131,
    "max_lng": -81.6518
  },
  "TX":
  {
    "name": "Texas",
    "min_lat": 25.8419,
    "max_lat": 36.5008,
    "min_lng": -106.6168,
    "max_lng": -93.5074
  },
  "UT":
  {
    "name": "Utah",
    "min_lat": 36.9982,
    "max_lat": 41.9993,
    "min_lng": -114.0504,
    "max_lng": -109.0462
  },
  "VA":
  {
    "name": "Virginia",
    "min_lat": 36.5427,
    "max_lat": 39.4659,
    "min_lng": -83.6753,
    "max_lng": -74.9707
  },
  "VT":
  {
    "name": "Vermont",
    "min_lat": 42.7289,
    "max_lat": 45.0153,
    "min_lng": -73.4381,
    "max_lng": -71.4949
  },
  "WA":
  {
    "name": "Washington",
    "min_lat": 45.5439,
    "max_lat": 49.0027,
    "min_lng": -124.8679,
    "max_lng": -116.9165
  },
  "WI":
  {
    "name": "Wisconsin",
    "min_lat": 42.4954,
    "max_lat": 47.31,
    "min_lng": -92.8564,
    "max_lng": -86.2523
  },
  "WV":
  {
    "name": "West Virginia",
    "min_lat": 37.1953,
    "max_lat": 40.6338,
    "min_lng": -82.6392,
    "max_lng": -77.731
  },
  "WY":
  {
    "name": "Wyoming",
    "min_lat": 40.9986,
    "max_lat": 44.9998,
    "min_lng": -111.0539,
    "max_lng": -104.0556
  },
  "AS":
  {
    "name": "American Samoa",
    "min_lat": -14.377579,
    "max_lat": -14.221549,
    "min_lng": -170.851479,
    "max_lng": -170.539742
  },
  "DC":
  {
    "name": "District of Columbia",
    "min_lat": 38.79164435,
    "max_lat": 39.031386,
    "min_lng": -77.11979522,
    "max_lng": -76.867218
  },
  "FM":
  {
    "name": "Federated States of Micronesia",
    "min_lat": 6.673985,
    "max_lat": 7.202918,
    "min_lng": 157.651062,
    "max_lng": 158.595886
  },
  "GU":
  {
    "name": "Guam",
    "min_lat": 13.227058,
    "max_lat": 14.204108,
    "min_lng": 144.598961,
    "max_lng": 145.301743
  },
  "MH":
  {
    "name": "Marshall Islands",
    "min_lat": 1.7575,
    "max_lat": 17.9578,
    "min_lng": 157.4121,
    "max_lng": 175.5395
  },
  "MP":
  {
    "name": "Northern Mariana Islands",
    "min_lat": 14.834442,
    "max_lat": 15.300557,
    "min_lng": 145.530052,
    "max_lng": 145.836296
  },
  "PW":
  {
    "name": "Palau",
    "min_lat": 1.7355,
    "max_lat": 11.4584,
    "min_lng": 129.6166,
    "max_lng": 136.9116
  },
  "PR":
  {
    "name": "Puerto Rico",
    "min_lat": 17.904834,
    "max_lat": 18.520551,
    "min_lng": -67.289886,
    "max_lng": -65.177765
  },
  "VI":
  {
    "name": "Virgin Islands",
    "min_lat": 18.302014,
    "max_lat": 18.751244,
    "min_lng": -64.861221,
    "max_lng": -64.26384
  }
}

stateBoundaries.php

<?php
// The approximate max/min latitude and longitude for each state and US territory, keyed on the state abbreviation
return [
    "AK" => [
        "name"    => "Alaska",
        "min_lat" => 52.5964,
        "max_lat" => 71.5232,
        "min_lng" => -169.9146,
        "max_lng" => -129.993,
    ],
    "AL" => [
        "name"    => "Alabama",
        "min_lat" => 30.1463,
        "max_lat" => 35.0041,
        "min_lng" => -88.4743,
        "max_lng" => -84.8927,
    ],
    "AR" => [
        "name"    => "Arkansas",
        "min_lat" => 33.0075,
        "max_lat" => 36.4997,
        "min_lng" => -94.6198,
        "max_lng" => -89.6594,
    ],
    "AZ" => [
        "name"    => "Arizona",
        "min_lat" => 31.3325,
        "max_lat" => 37.0004,
        "min_lng" => -114.8126,
        "max_lng" => -109.0475,
    ],
    "CA" => [
        "name"    => "California",
        "min_lat" => 32.5121,
        "max_lat" => 42.0126,
        "min_lng" => -124.6509,
        "max_lng" => -114.1315,
    ],
    "CO" => [
        "name"    => "Colorado",
        "min_lat" => 36.9949,
        "max_lat" => 41.0006,
        "min_lng" => -109.0489,
        "max_lng" => -102.0424,
    ],
    "CT" => [
        "name"    => "Connecticut",
        "min_lat" => 40.9509,
        "max_lat" => 42.0511,
        "min_lng" => -73.7272,
        "max_lng" => -71.7874,
    ],
    "DE" => [
        "name"    => "Delaware",
        "min_lat" => 38.4482,
        "max_lat" => 39.8296,
        "min_lng" => -75.7919,
        "max_lng" => -74.8526,
    ],
    "FL" => [
        "name"    => "Florida",
        "min_lat" => 24.3959,
        "max_lat" => 31.0035,
        "min_lng" => -87.6256,
        "max_lng" => -79.8198,
    ],
    "GA" => [
        "name"    => "Georgia",
        "min_lat" => 30.3575,
        "max_lat" => 34.9996,
        "min_lng" => -85.6082,
        "max_lng" => -80.696,
    ],
    "HI" => [
        "name"    => "Hawaii",
        "min_lat" => 18.71,
        "max_lat" => 22.3386,
        "min_lng" => -160.3922,
        "max_lng" => -154.6271,
    ],
    "IA" => [
        "name"    => "Iowa",
        "min_lat" => 40.3622,
        "max_lat" => 43.5008,
        "min_lng" => -96.6357,
        "max_lng" => -90.1538,
    ],
    "ID" => [
        "name"    => "Idaho",
        "min_lat" => 41.9871,
        "max_lat" => 49.0018,
        "min_lng" => -117.2372,
        "max_lng" => -111.0471,
    ],
    "IL" => [
        "name"    => "Illinois",
        "min_lat" => 36.9894,
        "max_lat" => 42.5116,
        "min_lng" => -91.512,
        "max_lng" => -87.0213,
    ],
    "IN" => [
        "name"    => "Indiana",
        "min_lat" => 37.7718,
        "max_lat" => 41.7611,
        "min_lng" => -88.098,
        "max_lng" => -84.809,
    ],
    "KS" => [
        "name"    => "Kansas",
        "min_lat" => 36.9927,
        "max_lat" => 40.0087,
        "min_lng" => -102.0506,
        "max_lng" => -94.6046,
    ],
    "KY" => [
        "name"    => "Kentucky",
        "min_lat" => 36.4931,
        "max_lat" => 39.1439,
        "min_lng" => -89.5372,
        "max_lng" => -82.0308,
    ],
    "LA" => [
        "name"    => "Louisiana",
        "min_lat" => 28.8832,
        "max_lat" => 33.0225,
        "min_lng" => -94.043,
        "max_lng" => -88.7421,
    ],
    "MA" => [
        "name"    => "Massachusetts",
        "min_lat" => 41.159,
        "max_lat" => 42.889,
        "min_lng" => -73.5081,
        "max_lng" => -69.7398,
    ],
    "MD" => [
        "name"    => "Maryland",
        "min_lat" => 37.8889,
        "max_lat" => 39.722,
        "min_lng" => -79.4861,
        "max_lng" => -74.8581,
    ],
    "ME" => [
        "name"    => "Maine",
        "min_lat" => 42.9182,
        "max_lat" => 47.455,
        "min_lng" => -71.0829,
        "max_lng" => -66.8628,
    ],
    "MI" => [
        "name"    => "Michigan",
        "min_lat" => 41.6965,
        "max_lat" => 48.3042,
        "min_lng" => -90.4175,
        "max_lng" => -82.1221,
    ],
    "MN" => [
        "name"    => "Minnesota",
        "min_lat" => 43.5008,
        "max_lat" => 49.3877,
        "min_lng" => -97.2304,
        "max_lng" => -89.4919,
    ],
    "MO" => [
        "name"    => "Missouri",
        "min_lat" => 35.9958,
        "max_lat" => 40.6181,
        "min_lng" => -95.7527,
        "max_lng" => -89.1005,
    ],
    "MS" => [
        "name"    => "Mississippi",
        "min_lat" => 30.0905,
        "max_lat" => 35.0075,
        "min_lng" => -91.6589,
        "max_lng" => -88.0994,
    ],
    "MT" => [
        "name"    => "Montana",
        "min_lat" => 44.3563,
        "max_lat" => 48.9991,
        "min_lng" => -116.0458,
        "max_lng" => -104.0186,
    ],
    "NC" => [
        "name"    => "North Carolina",
        "min_lat" => 33.7666,
        "max_lat" => 36.588,
        "min_lng" => -84.3201,
        "max_lng" => -75.4129,
    ],
    "ND" => [
        "name"    => "North Dakota",
        "min_lat" => 45.934,
        "max_lat" => 48.9982,
        "min_lng" => -104.0501,
        "max_lng" => -96.5671,
    ],
    "NE" => [
        "name"    => "Nebraska",
        "min_lat" => 39.9992,
        "max_lat" => 43.0006,
        "min_lng" => -104.0543,
        "max_lng" => -95.3091,
    ],
    "NH" => [
        "name"    => "New Hampshire",
        "min_lat" => 42.6986,
        "max_lat" => 45.3058,
        "min_lng" => -72.5592,
        "max_lng" => -70.5583,
    ],
    "NJ" => [
        "name"    => "New Jersey",
        "min_lat" => 38.8472,
        "max_lat" => 41.3593,
        "min_lng" => -75.5708,
        "max_lng" => -73.8885,
    ],
    "NM" => [
        "name"    => "New Mexico",
        "min_lat" => 31.3337,
        "max_lat" => 36.9982,
        "min_lng" => -109.0489,
        "max_lng" => -103.0023,
    ],
    "NV" => [
        "name"    => "Nevada",
        "min_lat" => 35.003,
        "max_lat" => 42.0003,
        "min_lng" => -120.0037,
        "max_lng" => -114.0436,
    ],
    "NY" => [
        "name"    => "New York",
        "min_lat" => 40.4772,
        "max_lat" => 45.0153,
        "min_lng" => -79.7624,
        "max_lng" => -71.7517,
    ],
    "OH" => [
        "name"    => "Ohio",
        "min_lat" => 38.3761,
        "max_lat" => 42.321,
        "min_lng" => -84.8172,
        "max_lng" => -80.5188,
    ],
    "OK" => [
        "name"    => "Oklahoma",
        "min_lat" => 33.6386,
        "max_lat" => 37.0015,
        "min_lng" => -103.0064,
        "max_lng" => -94.4357,
    ],
    "OR" => [
        "name"    => "Oregon",
        "min_lat" => 41.9952,
        "max_lat" => 46.2891,
        "min_lng" => -124.7305,
        "max_lng" => -116.4606,
    ],
    "PA" => [
        "name"    => "Pennsylvania",
        "min_lat" => 39.7199,
        "max_lat" => 42.5167,
        "min_lng" => -80.5243,
        "max_lng" => -74.707,
    ],
    "RI" => [
        "name"    => "Rhode Island",
        "min_lat" => 41.1849,
        "max_lat" => 42.0156,
        "min_lng" => -71.9041,
        "max_lng" => -71.0541,
    ],
    "SC" => [
        "name"    => "South Carolina",
        "min_lat" => 32.0453,
        "max_lat" => 35.2075,
        "min_lng" => -83.3588,
        "max_lng" => -78.4836,
    ],
    "SD" => [
        "name"    => "South Dakota",
        "min_lat" => 42.4772,
        "max_lat" => 45.9435,
        "min_lng" => -104.0529,
        "max_lng" => -96.438,
    ],
    "TN" => [
        "name"    => "Tennessee",
        "min_lat" => 34.9884,
        "max_lat" => 36.6871,
        "min_lng" => -90.3131,
        "max_lng" => -81.6518,
    ],
    "TX" => [
        "name"    => "Texas",
        "min_lat" => 25.8419,
        "max_lat" => 36.5008,
        "min_lng" => -106.6168,
        "max_lng" => -93.5074,
    ],
    "UT" => [
        "name"    => "Utah",
        "min_lat" => 36.9982,
        "max_lat" => 41.9993,
        "min_lng" => -114.0504,
        "max_lng" => -109.0462,
    ],
    "VA" => [
        "name"    => "Virginia",
        "min_lat" => 36.5427,
        "max_lat" => 39.4659,
        "min_lng" => -83.6753,
        "max_lng" => -74.9707,
    ],
    "VT" => [
        "name"    => "Vermont",
        "min_lat" => 42.7289,
        "max_lat" => 45.0153,
        "min_lng" => -73.4381,
        "max_lng" => -71.4949,
    ],
    "WA" => [
        "name"    => "Washington",
        "min_lat" => 45.5439,
        "max_lat" => 49.0027,
        "min_lng" => -124.8679,
        "max_lng" => -116.9165,
    ],
    "WI" => [
        "name"    => "Wisconsin",
        "min_lat" => 42.4954,
        "max_lat" => 47.31,
        "min_lng" => -92.8564,
        "max_lng" => -86.2523,
    ],
    "WV" => [
        "name"    => "West Virginia",
        "min_lat" => 37.1953,
        "max_lat" => 40.6338,
        "min_lng" => -82.6392,
        "max_lng" => -77.731,
    ],
    "WY" => [
        "name"    => "Wyoming",
        "min_lat" => 40.9986,
        "max_lat" => 44.9998,
        "min_lng" => -111.0539,
        "max_lng" => -104.0556,
    ],
    "AS" => [
        "name"    => "American Samoa",
        "min_lat" => -14.377579,
        "max_lat" => -14.221549,
        "min_lng" => -170.851479,
        "max_lng" => -170.539742,
    ],
    "DC" => [
        "name"    => "District of Columbia",
        "min_lat" => 38.79164435,
        "max_lat" => 39.031386,
        "min_lng" => -77.11979522,
        "max_lng" => -76.867218,
    ],
    "FM" => [
        "name"    => "Federated States of Micronesia",
        "min_lat" => 6.673985,
        "max_lat" => 7.202918,
        "min_lng" => 157.651062,
        "max_lng" => 158.595886,
    ],
    "GU" => [
        "name"    => "Guam",
        "min_lat" => 13.227058,
        "max_lat" => 14.204108,
        "min_lng" => 144.598961,
        "max_lng" => 145.301743,
    ],
    "MH" => [
        "name"    => "Marshall Islands",
        "min_lat" => 1.7575,
        "max_lat" => 17.9578,
        "min_lng" => 157.4121,
        "max_lng" => 175.5395,
    ],
    "MP" => [
        "name"    => "Northern Mariana Islands",
        "min_lat" => 14.834442,
        "max_lat" => 15.300557,
        "min_lng" => 145.530052,
        "max_lng" => 145.836296,
    ],
    "PW" => [
        "name"    => "Palau",
        "min_lat" => 1.7355,
        "max_lat" => 11.4584,
        "min_lng" => 129.6166,
        "max_lng" => 136.9116,
    ],
    "PR" => [
        "name"    => "Puerto Rico",
        "min_lat" => 17.904834,
        "max_lat" => 18.520551,
        "min_lng" => -67.289886,
        "max_lng" => -65.177765,
    ],
    "VI" => [
        "name"    => "Virgin Islands",
        "min_lat" => 18.302014,
        "max_lat" => 18.751244,
        "min_lng" => -64.861221,
        "max_lng" => -64.26384,
    ],
];

StateBoundaries.sql

-- 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;

-- Insert the data
REPLACE INTO `StateBoundaries` (`State`, `Name`, `MinLat`, `MaxLat`, `MinLon`, `MaxLon`) VALUES
  ('AK', 'Alaska', '52.5964', '71.5232', '-169.9146', '-129.993'),
  ('AL', 'Alabama', '30.1463', '35.0041', '-88.4743', '-84.8927'),
  ('AR', 'Arkansas', '33.0075', '36.4997', '-94.6198', '-89.6594'),
  ('AZ', 'Arizona', '31.3325', '37.0004', '-114.8126', '-109.0475'),
  ('CA', 'California', '32.5121', '42.0126', '-124.6509', '-114.1315'),
  ('CO', 'Colorado', '36.9949', '41.0006', '-109.0489', '-102.0424'),
  ('CT', 'Connecticut', '40.9509', '42.0511', '-73.7272', '-71.7874'),
  ('DE', 'Delaware', '38.4482', '39.8296', '-75.7919', '-74.8526'),
  ('FL', 'Florida', '24.3959', '31.0035', '-87.6256', '-79.8198'),
  ('GA', 'Georgia', '30.3575', '34.9996', '-85.6082', '-80.696'),
  ('HI', 'Hawaii', '18.71', '22.3386', '-160.3922', '-154.6271'),
  ('IA', 'Iowa', '40.3622', '43.5008', '-96.6357', '-90.1538'),
  ('ID', 'Idaho', '41.9871', '49.0018', '-117.2372', '-111.0471'),
  ('IL', 'Illinois', '36.9894', '42.5116', '-91.512', '-87.0213'),
  ('IN', 'Indiana', '37.7718', '41.7611', '-88.098', '-84.809'),
  ('KS', 'Kansas', '36.9927', '40.0087', '-102.0506', '-94.6046'),
  ('KY', 'Kentucky', '36.4931', '39.1439', '-89.5372', '-82.0308'),
  ('LA', 'Louisiana', '28.8832', '33.0225', '-94.043', '-88.7421'),
  ('MA', 'Massachusetts', '41.159', '42.889', '-73.5081', '-69.7398'),
  ('MD', 'Maryland', '37.8889', '39.722', '-79.4861', '-74.8581'),
  ('ME', 'Maine', '42.9182', '47.455', '-71.0829', '-66.8628'),
  ('MI', 'Michigan', '41.6965', '48.3042', '-90.4175', '-82.1221'),
  ('MN', 'Minnesota', '43.5008', '49.3877', '-97.2304', '-89.4919'),
  ('MO', 'Missouri', '35.9958', '40.6181', '-95.7527', '-89.1005'),
  ('MS', 'Mississippi', '30.0905', '35.0075', '-91.6589', '-88.0994'),
  ('MT', 'Montana', '44.3563', '48.9991', '-116.0458', '-104.0186'),
  ('NC', 'North Carolina', '33.7666', '36.588', '-84.3201', '-75.4129'),
  ('ND', 'North Dakota', '45.934', '48.9982', '-104.0501', '-96.5671'),
  ('NE', 'Nebraska', '39.9992', '43.0006', '-104.0543', '-95.3091'),
  ('NH', 'New Hampshire', '42.6986', '45.3058', '-72.5592', '-70.5583'),
  ('NJ', 'New Jersey', '38.8472', '41.3593', '-75.5708', '-73.8885'),
  ('NM', 'New Mexico', '31.3337', '36.9982', '-109.0489', '-103.0023'),
  ('NV', 'Nevada', '35.003', '42.0003', '-120.0037', '-114.0436'),
  ('NY', 'New York', '40.4772', '45.0153', '-79.7624', '-71.7517'),
  ('OH', 'Ohio', '38.3761', '42.321', '-84.8172', '-80.5188'),
  ('OK', 'Oklahoma', '33.6386', '37.0015', '-103.0064', '-94.4357'),
  ('OR', 'Oregon', '41.9952', '46.2891', '-124.7305', '-116.4606'),
  ('PA', 'Pennsylvania', '39.7199', '42.5167', '-80.5243', '-74.707'),
  ('RI', 'Rhode Island', '41.1849', '42.0156', '-71.9041', '-71.0541'),
  ('SC', 'South Carolina', '32.0453', '35.2075', '-83.3588', '-78.4836'),
  ('SD', 'South Dakota', '42.4772', '45.9435', '-104.0529', '-96.438'),
  ('TN', 'Tennessee', '34.9884', '36.6871', '-90.3131', '-81.6518'),
  ('TX', 'Texas', '25.8419', '36.5008', '-106.6168', '-93.5074'),
  ('UT', 'Utah', '36.9982', '41.9993', '-114.0504', '-109.0462'),
  ('VA', 'Virginia', '36.5427', '39.4659', '-83.6753', '-74.9707'),
  ('VT', 'Vermont', '42.7289', '45.0153', '-73.4381', '-71.4949'),
  ('WA', 'Washington', '45.5439', '49.0027', '-124.8679', '-116.9165'),
  ('WI', 'Wisconsin', '42.4954', '47.31', '-92.8564', '-86.2523'),
  ('WV', 'West Virginia', '37.1953', '40.6338', '-82.6392', '-77.731'),
  ('WY', 'Wyoming', '40.9986', '44.9998', '-111.0539', '-104.0556'),
  ('AS', 'American Samoa', '-14.377579', '-14.221549', '-170.851479', '-170.539742'),
  ('DC', 'District of Columbia', '38.79164435', '39.031386', '-77.11979522', '-76.867218'),
  ('FM', 'Federated States of Micronesia', '6.673985', '7.202918', '157.651062', '158.595886'),
  ('GU', 'Guam', '13.227058', '14.204108', '144.598961', '145.301743'),
  ('MH', 'Marshall Islands', '1.7575', '17.9578', '157.4121', '175.5395'),
  ('MP', 'Northern Mariana Islands', '14.834442', '15.300557', '145.530052', '145.836296'),
  ('PW', 'Palau', '1.7355', '11.4584', '129.6166', '136.9116'),
  ('PR', 'Puerto Rico', '17.904834', '18.520551', '-67.289886', '-65.177765'),
  ('VI', 'Virgin Islands', '18.302014', '18.751244', '-64.861221', '-64.26384');

This looks awesome! Where do these numbers come from?

Hmm I can’t remember, I wish I had sourced it in the gist. I think I got some myself, and pulled some from other sources. Sorry I don’t have something more direct.

Do you have similar set of data for Canada?

Sorry @hnarisetty, I made this for a project I was working on that needed US states. Nothing for Canada!

Thank you!