ad_state_name_from_usps

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]