Table: seismic_ratings_and_collapse_probabilities_of_californi_ae55f270 , facility_name like F*

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  *

county_code perm_id facility_name city building_nbr building_name building_status spc_rating 2007_hazus_score_pct 2010_hazus_score_pct hcai_npc_rating ab_1882_notice latitude longitude count_num
01 - Alameda 11268 Fairmont Hospital San Leandro BLD-01311 Building B OSHPD 2-Skilled Nursing Only N/A None None 1 None 37.7100449 -122.1153183 1
01 - Alameda 11268 Fairmont Hospital San Leandro BLD-01312 Building H OSHPD 1R-Delicensed Clinic under OSHPD N/A None 1.22000 1 None 37.7100449 -122.1153183 1
10 - Fresno 17938 Fresno Heart And Surgical Hospital Fresno BLD-05187 Main Hospital OSHPD 1-In Service 5 None None 4 None 36.85989 -119.7885513 1
10 - Fresno 17938 Fresno Heart And Surgical Hospital Fresno BLD-05188 Central Plant OSHPD 1-In Service 5 None None 4 None 36.85989 -119.7885513 1
10 - Fresno 17938 Fresno Heart And Surgical Hospital Fresno BLD-05278 Wing A OSHPD 1-In Service 5 None None 4 None 36.85989 -119.7885513 1
10 - Fresno 16878 Fresno Surgical Hospital Fresno BLD-00294 Recovery Center OSHPD 1-In Service 4 None None 4 None 36.8250999 -119.781929 1
10 - Fresno 16878 Fresno Surgical Hospital Fresno BLD-03748 Expansion OSHPD 1-In Service 5 None None 4 None 36.8250999 -119.781929 1
10 - Fresno 16878 Fresno Surgical Hospital Fresno BLD-05252 New Tower OSHPD 1-In Service 5 None None 4 None 36.8250999 -119.781929 1
10 - Fresno 16878 Fresno Surgical Hospital Fresno BLD-05366 Equipment Yard OSHPD 1-Equipment Yard N/A None None 4 None 36.8250999 -119.781929 1
10 - Fresno 16878 Fresno Surgical Hospital Fresno BLD-07246 New Tower Support OSHPD 1-In Service 5 None None 4 None 36.8250999 -119.781929 1
30 - Orange 12573 Foothill Regional Medical Center Tustin BLD-01029 Original Building OSHPD 1-In Service 2 0.02000 None 2 This building does not significantly jeopardize life, but may not be repairable or functional following an earthquake. 33.7302628 -117.8283157 1
30 - Orange 12573 Foothill Regional Medical Center Tustin BLD-01030 Classroom Addition OSHPD 1-In Service 4s None None 2 None 33.7302628 -117.8283157 1
30 - Orange 12573 Foothill Regional Medical Center Tustin BLD-02631 Mechanical Addition OSHPD 1-In Service 4s None None 2 None 33.7302628 -117.8283157 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-00955 Main Hospital OSHPD 1-In Service 2 0.00000 None 2 This building does not significantly jeopardize life, but may not be repairable or functional following an earthquake. 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-00956 Cath Lab Addition OSHPD 1-In Service 4 None None 2 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-00957 Surgery Addition OSHPD 1-In Service 4s None None 2 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-03600 Mechanical Building OSHPD 1-In Service 4 None None 2 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-05622 Electrical Room OSHPD 1-In Service 5s None None 4 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06242 Emergency Department Addition OSHPD 1-In Service 5 None None 4 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06458 Patient Tower Addition OSHPD 1-Proposed 5s None None NYA None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06630 Chapel OSHPD 1-In Service 5 None None 4 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06642 Generator Yard OSHPD 1-Proposed N/A None None NYA None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06675 Bell Tower OSHPD 1-In Service 5 None None 4 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06745 Ambulance Canopy OSHPD 1-In Service 5 None None 4 None 35.2779935 -120.6496936 1
40 - San Luis Obispo 12964 French Hospital Medical Center San Luis Obispo BLD-06746 Patient Drop Off Canopy OSHPD 1-In Service 5 None None 4 None 35.2779935 -120.6496936 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-00082 Nursing Wing OSHPD 1-In Service 5 None None 4 None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-00083 D & T Wing OSHPD 1-In Service 5 None None 4 None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-00084 Med. Gas Shed OSHPD 1-In Service 5 None None 4 None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-07087 Emergency Department Waiting Room Addition OSHPD 1-In Service 5 None None 4 None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-07093 Bulk O2 and Propane Yard OSHPD 1-Under Construction 5s None None NYA None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-07156 Emergency Department Expansion OSHPD 1-Under Construction 5s None None NYA None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-07157 Generator Yard OSHPD 1-Under Construction N/A None None NYA None 41.7194939 -122.6458054 1
47 - Siskiyou 14900 Fairchild Medical Center Yreka BLD-07158 Patient Drop-Off Canopy OSHPD 1-Under Construction 5s None None NYA None 41.7194939 -122.6458054 1