PUBLICNED.NED_BUILDINGS

The PUBLICNED.NED_BUILDINGS Oracle view contains NED building information.  The following attributes are included in the view:

NAME DATA TYPE DESCRIPTION
BUILDINGNAME VARCHAR2 (10) NOT NULL Building short name or abbreviation (e.g., 10)
NIHBUILDINGFULLNAME VARCHAR2 (40) Building full name (e.g., Magnuson Clinical Center)
NIHSITE VARCHAR2 (8) NOT NULL Building site code (e.g., MD-BC)*
STREET VARCHAR2 (128) Building street address (e.g., 10 Center Dr)
L VARCHAR2 (48) City where building is located (e.g., Bethesda)
ST VARCHAR2 (2) State where building is located (e.g., MD)
C VARCHAR2 (2) Country where building is located (e.g., US)
NIHBUILDINGZIPCODE VARCHAR2 (10) US Postal Service zip code of building (e.g., 20892)
NIHPHYSICALPOSTALCODE VARCHAR2 (10) Physical postal code of building (e.g., 20814)


* Site codes include:
        AZ-PNX (Arizona-Phoenix)
        MA-BST (Massachusetts-Boston)
        MA-FRM (Massachusetts-Framingham)
        MA-WLT (Massachusetts-Waltham)
        MD-BC (Maryland-Bethesda Campus)               
        MD-BLT (Maryland-Baltimore)
        MD-BTH (Maryland-Bethesda)
        MD-FCR (Maryland-Frederick)
        MD-GLD (Maryland-Glen Dade)
        MD-GTH (Maryland-Gaithersburg)
        MD-KNS (Maryland-Kensington)
        MD-NMC (Maryland-Naval Medical Center)
        MD-PAC (Maryland-Poolesville Animal Center)
        MD-RCK (Maryland-Rockville)
        MI-DET (Michigan-Detroit)
        MS-JCK (Mississippi-Jackson)
        MT-RML (Montana-Rocky Mountain Labs)
        NC-RTP (North Carolina-Research Triangle Park)
 

For additional information or questions, please contact ned-ops@list.nih.gov
     

Return to "Data Access"