ad_state_name_from_usps_abbrev

one of the documented procedures in this installation of the ACS
Usage:
ad_state_name_from_usps_abbrev   db   usps_abbrev
What it does:
Takes a database connection and a USPS abbrevation and returns the full state name, e.g., MA in yields Massachusetts out
Defined in: /web/philip/tcl/ad-geospatial.tcl

Source code:


    return [database_to_tcl_string_or_null $db "select state_name from states where usps_abbrev ='[DoubleApos $usps_abbrev]'" $usps_abbrev]


philg@mit.edu