Table: hospital_building_data , 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_	building_url	height_ft	stories	building_code	building_code_year	year_completed	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=30HIS&capID2=00000&capID3=00002&agencyCode=OSHPD	None	3	1927 Uniform Building Code (UBC)	1927	1930	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=61HIS&capID2=00000&capID3=00015&agencyCode=OSHPD	23	2	1955 Uniform Building Code (UBC)	1955	1961	None	37.7100449	-122.1153183	1
10 - Fresno	17938	Fresno Heart And Surgical Hospital	Fresno	BLD-05187	Main Hospital	OSHPD 1-In Service	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=03HIS&capID2=00000&capID3=00045&agencyCode=OSHPD	None	4	1998 California Building Code (CBC)	1998	2003	None	36.85989	-119.7885513	1
10 - Fresno	17938	Fresno Heart And Surgical Hospital	Fresno	BLD-05188	Central Plant	OSHPD 1-In Service	5	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=03HIS&capID2=00000&capID3=00046&agencyCode=OSHPD	22	1	1998 California Building Code (CBC)	1998	2003	None	36.85989	-119.7885513	1
10 - Fresno	17938	Fresno Heart And Surgical Hospital	Fresno	BLD-05278	Wing A	OSHPD 1-In Service	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=11CAP&capID2=00000&capID3=002P0&agencyCode=OSHPD	None	2	1998 California Building Code (CBC)	1998	2003	None	36.85989	-119.7885513	1
10 - Fresno	16878	Fresno Surgical Hospital	Fresno	BLD-00294	Recovery Center	OSHPD 1-In Service	4	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=97HIS&capID2=00000&capID3=00005&agencyCode=OSHPD	None	3	1985 California Building Code (CBC)	1985	1997	None	36.8250999	-119.781929	1
10 - Fresno	16878	Fresno Surgical Hospital	Fresno	BLD-03748	Expansion	OSHPD 1-In Service	5	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=07HIS&capID2=00000&capID3=00032&agencyCode=OSHPD	30	2	1998 California Building Code (CBC)	1998	2010	None	36.8250999	-119.781929	1
10 - Fresno	16878	Fresno Surgical Hospital	Fresno	BLD-05252	New Tower	OSHPD 1-In Service	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=11CAP&capID2=00000&capID3=0023Q&agencyCode=OSHPD	28.67	2	2007 California Building Code (CBC)	2007	2017	None	36.8250999	-119.781929	1
10 - Fresno	16878	Fresno Surgical Hospital	Fresno	BLD-05366	Equipment Yard	OSHPD 1-Equipment Yard	N/A	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=12CAP&capID2=00000&capID3=002K7&agencyCode=OSHPD	None	None	1998 California Building Code (CBC)	1998	2010	None	36.8250999	-119.781929	1
10 - Fresno	16878	Fresno Surgical Hospital	Fresno	BLD-07246	New Tower Support	OSHPD 1-In Service	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=24CAP&capID2=00000&capID3=009KK&agencyCode=OSHPD	15.81	1	2007 California Building Code (CBC)	2007	2017	None	36.8250999	-119.781929	1
30 - Orange	12573	Foothill Regional Medical Center	Tustin	BLD-01029	Original Building	OSHPD 1-In Service	2	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=67HIS&capID2=00000&capID3=00016&agencyCode=OSHPD	14	1	1964 Uniform Building Code (UBC)	1964	1967	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=78HIS&capID2=00000&capID3=00025&agencyCode=OSHPD	None	1	1976 California Building Code (CBC)	1976	1978	None	33.7302628	-117.8283157	1
30 - Orange	12573	Foothill Regional Medical Center	Tustin	BLD-02631	Mechanical Addition	OSHPD 1-In Service	4s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=81HIS&capID2=00000&capID3=00040&agencyCode=OSHPD	None	1	1976 California Building Code (CBC)	1976	1981	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=71HIS&capID2=00000&capID3=00029&agencyCode=OSHPD	17	1	1967 Uniform Building Code (UBC)	1967	1971	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=87HIS&capID2=00000&capID3=00019&agencyCode=OSHPD	None	1	1985 California Building Code (CBC)	1985	1989	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=93HIS&capID2=00000&capID3=00015&agencyCode=OSHPD	None	1	1992 California Building Code (CBC)	1992	1995	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=93HIS&capID2=00000&capID3=00059&agencyCode=OSHPD	9.75	1	1989 California Building Code (CBC)	1989	1995	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=13CAP&capID2=00000&capID3=006G0&agencyCode=OSHPD	15.38	1	2001 California Building Code (CBC)	2001	2013	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=17CAP&capID2=00000&capID3=003OO&agencyCode=OSHPD	16	1	2016 California Building Code (CBC)	2016	2021	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=19CAP&capID2=00000&capID3=000V2&agencyCode=OSHPD	None	None	2016 California Building Code (CBC)	2016	None	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=20CAP&capID2=00000&capID3=002WF&agencyCode=OSHPD	15.75	1	2019 California Building Code (CBC)	2019	2024	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=20CAP&capID2=00000&capID3=0051E&agencyCode=OSHPD	None	None	2016 California Building Code (CBC)	2016	None	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=20CAP&capID2=00000&capID3=007CQ&agencyCode=OSHPD	32	1	2019 California Building Code (CBC)	2019	2023	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=21CAP&capID2=00000&capID3=003C5&agencyCode=OSHPD	14	1	2016 California Building Code (CBC)	2016	2021	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=21CAP&capID2=00000&capID3=003C9&agencyCode=OSHPD	13	1	2016 California Building Code (CBC)	2016	2021	None	35.2779935	-120.6496936	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-00082	Nursing Wing	OSHPD 1-In Service	5	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=97HIS&capID2=00000&capID3=00001&agencyCode=OSHPD	None	None	1992 California Building Code (CBC)	1992	1997	None	41.7194939	-122.6458054	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-00083	D & T Wing	OSHPD 1-In Service	5	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=97HIS&capID2=00000&capID3=00002&agencyCode=OSHPD	None	1	1992 California Building Code (CBC)	1992	1997	None	41.7194939	-122.6458054	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-00084	Med. Gas Shed	OSHPD 1-In Service	5	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=97HIS&capID2=00000&capID3=00003&agencyCode=OSHPD	None	1	1992 California Building Code (CBC)	1992	1997	None	41.7194939	-122.6458054	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-07087	Emergency Department Waiting Room Addition	OSHPD 1-In Service	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=23CAP&capID2=00000&capID3=004MF&agencyCode=OSHPD	12	1	2001 California Building Code (CBC)	2001	2008	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	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=23CAP&capID2=00000&capID3=00503&agencyCode=OSHPD	None	None	2022 California Building Code (CBC)	2022	None	None	41.7194939	-122.6458054	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-07156	Emergency Department Expansion	OSHPD 1-Under Construction	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=23CAP&capID2=00000&capID3=00ACW&agencyCode=OSHPD	None	None	2022 California Building Code (CBC)	2022	None	None	41.7194939	-122.6458054	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-07157	Generator Yard	OSHPD 1-Under Construction	N/A	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=23CAP&capID2=00000&capID3=00ADZ&agencyCode=OSHPD	None	None	2022 California Building Code (CBC)	2022	None	None	41.7194939	-122.6458054	1
47 - Siskiyou	14900	Fairchild Medical Center	Yreka	BLD-07158	Patient Drop-Off Canopy	OSHPD 1-Under Construction	5s	https://esp.oshpd.ca.gov/CitizenAccess/Cap/CapDetail.aspx?Module=Permits&TabName=Permits&capID1=23CAP&capID2=00000&capID3=00AE1&agencyCode=OSHPD	None	1	2022 California Building Code (CBC)	2022	None	None	41.7194939	-122.6458054	1