  INSERT INTO "NH_SEG_TRAFFIC_2009"
  (AGENCYID, CALENDARYEAR, AADTVPD)
SELECT UNIQUE_ID AS AGENCYID, AADT_CURR_YEAR AS CALENDARYEAR,
  case
      when substr(sri,1,1)='I'
      Then AADT/2
      When SRI = 'S0000101__' and MP_START >= 59.271 and MP_END <= 91.997
      Then AADT/2
      When SRI = 'S0000101_W' and MP_START >= 20 and MP_END <= 52.961
      Then AADT/2
      Else AADT
  end as AADTVPD
FROM ROADS_AADT_6_25_2010
Where SRI NOT LIKE 'R%' AND SRI NOT LIKE 'T%' AND SRI NOT LIKE 'C%';