home / data

City_Facilities

Data source: data.sfgov.org

1,701 rows

View and edit SQL

Suggested facets: city, owned_leased, dept_id, department_name, supervisor_district

Link rowid facility_id common_name address city zip_code block_lot owned_leased dept_id department_name gross_sq_ft longitude latitude geom supervisor_district city_tenants
1 1203 Oceanside Water Pollution Control Plant 3500 Great Hwy San Francisco 1 94132 1 7281009 Own 47 Public Utilities Commission 1   -122.504875697 37.727061605000024 (37.72706160500002, -122.50487569699999) 7 1  
2 1202 Westside Pump Station 2814 Great Hwy San Francisco 1 94132 1 7281009 Own 47 Public Utilities Commission 1   -122.50646214 37.734737285 (37.734737284999994, -122.50646214) 7 1  
3 380 Camp Mather Office 35250 Mather Rd Groveland 2 95321 2   Own 49 Recreation And Parks 2   -119.855690196 37.882703144000004 (37.882703144000004, -119.85569019600001)    
4 3342 500 Pine Rooftop Park 500 Pine St San Francisco 1 94108 3 0258042 Own 49 Recreation And Parks 2   -122.404580943 37.791878743999966 (37.79187874399997, -122.40458094299998) 3 2  
5 3288 Top of the Hill Terminal Operator Restroom 6232 Mission St San Francisco 1 94014 4 2819021 Lease 9 Non-City 3   -122.46011434100001 37.706580492 (37.706580492, -122.46011434100001)   Municipal Transportation Agency 1
6 3286 PALOU/PHELPS OPEN SPACE 1801 Palou Ave San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.39516122799999 37.736120416999995 (37.736120416999995, -122.395161228) 10 3 Recreation And Parks 2
7 3246 Rincon Hill Dog Park Beale St and Bryant St San Francisco 1 94105 6 2819021 Lease 9 Non-City 3   -122.390044746 37.78622608299997 (37.786226082999974, -122.390044746) 6 4 Public Works 3
8 965 Public Defender - Juvenile Justice Center 258 Laguna Honda Blvd #A San Francisco 1 94116 7 2819021 Lease 9 Non-City 3   -122.460693262 37.749434502999975 (37.749434502999975, -122.460693262) 7 1 Public Defender 4
9 3249 246 S Van Ness Ave Parking Lot 246 South Van Ness Ave San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.41843126600004 37.769276468999976 (37.769276468999976, -122.41843126600003) 9 5 Gsa - Real Estate Division 5
10 3265 Mission Family Center 759 South Van Ness Ave San Francisco 1 94110 9 2819021 Lease 9 Non-City 3   -122.41683774299996 37.761029168999976 (37.76102916899998, -122.41683774299997) 9 5 Public Health 6
11 3268 100 Font Blvd 100 Font Blvd San Franicsco 3 94132 1 2819021 Lease 9 Non-City 3   -122.472728894 37.71535026599997 (37.71535026599997, -122.472728894) 7 1 Technology 7
12 3278 713 Brannan - Parking 713 Brannan St San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.401191717 37.77432686100002 (37.77432686100002, -122.40119171700002) 6 4 District Attorney 8
13 3302 1 Ave of the Palms Building 1 Ave of the Palms San Francisco 1 94130 10 2819021 Own 114 Treasure Island Development Authority 4 4052 -122.37087146299999 37.81721268000001 (37.81721268000001, -122.37087146300001) 6 4 Human Services Agency: Police Department 9
14 3299 CPMC-Emergency Equipment Sacramento St & Buchanan St San Francisco 1 94115 11 2819021 Lease 9 Non-City 3   -122.43095162899999 37.790373623999976 (37.79037362399998, -122.43095162899999) 2 6 Technology 7
15 3271 SF VA Medical Center 4150 Clement St San Francisco 1 94121 12 2819021 Lease 9 Non-City 3   -122.504846898 37.78153751299999 (37.78153751299999, -122.50484689799998) 1 7 Emergency Management 10
16 3337 295 San Bruno Ave Building/Parking Lot 295 San Bruno Ave San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.405397283 37.76613478899998 (37.76613478899998, -122.40539728300001) 10 3 Public Health 6
17 3316 KIPP Bayview Academy 1060 Key Ave San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.39636283599998 37.71934281 (37.71934281, -122.39636283599998) 10 3 School District (Sfusd) 11
18 3002 Cottages & Lab Pilarcitas-Davis Tunnel Millbrae Millbrae 4 94030 13 2819021 Own 47 Public Utilities Commission 1   -122.42000911000002 37.594549271000005 (37.594549271000005, -122.42000911000002)    
19 1363 Pump Station Sw Skyline & Se Burlingame 5 94010 14 2819021 Own 47 Public Utilities Commission 1            
20 1400 Res. 2B So. Hill 57 Alta Vista Way Daly City 6 94014 4 2819021 Lease 9 Non-City 3   -122.43015180999998 37.70394431300002 (37.70394431300002, -122.43015180999998)   Technology 7
21 3259 601 Van Ness Ave - Offices 601 Van Ness Ave San Francisco 1 94102 15 2819021 Lease 9 Non-City 3   -122.42140632600001 37.781385779000004 (37.781385779000004, -122.42140632600001) 5 8 Human Services Agency 12
22 164 Bay Bridge Pump Pier W-1 475 Spear St San Francisco 1 94105 6 2819021 Own 46 Port 5   -122.38835424899996 37.788202129000005 (37.78820212900001, -122.38835424899997) 6 4 Public Utilities Commission 13
23 3272 Bureau of Equipment Parking 25th St and Vermont St San Francisco 1 94110 9 2819021 Lease 9 Non-City 3   -122.40365387000004 37.751505023999975 (37.75150502399998, -122.40365387000003) 10 3 Fire Department 14
24 1372 Ranger's Cottage - Crystal Springs Rd Crystal Spring Rd San Mateo 7 94402 16 2819021 Own 47 Public Utilities Commission 1            
25 2090 Valve House Calaveras Alameda Sunol 8 94586 17 2819021 Own 47 Public Utilities Commission 1   -121.819964964 37.49597233200001 (37.49597233200001, -121.81996496400001)    
26 3330 Brady/Stevenson/Colusa - Parking 1125 Stevenson St San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.419834004 37.773491937000024 (37.77349193700002, -122.419834004) 6 4 Human Services Agency 12
27 578 Dechlorinator Station End Of Helen Dr Millbrae 4 94030 13 2819021 Own 47 Public Utilities Commission 1            
28 385 Caretaker's Cottage 8875 Skyline Blvd Sunol 8 94586 17 2819021 Own 47 Public Utilities Commission 1            
29 3244 375 Oyster Point Blvd 375 Oyster Point Blvd South San Francisco 9 94080 18 2819021 Lease 9 Non-City 3   -122.385734475 37.663400732000014 (37.663400732000014, -122.38573447499999)   Law Library 15
30 3282 Pump Station - Hayward 22488 Skywest Dr Hayward 10 94541 19 2819021 Lease 9 Non-City 3   -122.11388085599998 37.65788398299998 (37.65788398299998, -122.11388085599998)   Public Utilities Commission 13
31 3329 1 Bayview Park 1 Bayview Park Rd San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.394739049 37.716263971 (37.71626397099999, -122.39473904900001) 10 3 Technology 7
32 190 Hunters Point Shipyard Building 606 606 Manseau St San Francisco 1 94124 5 2819021 Own 45 Police Department 6 90000 -122.367436445 37.720502415 (37.720502415, -122.36743644500001) 10 3  
33 3341 1755 Egbert Storage Yard 1755 Egbert Ave San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.396999167 37.726175082999994 (37.72617508299999, -122.39699916699999) 10 3  
34 3319 Presidio Early Education School 387 Moraga Ave San Francisco 1 94129 20 2819021 Lease 9 Non-City 3   -122.461018487 37.797674154999974 (37.79767415499998, -122.46101848699999) 2 6 School District (Sfusd) 11
35 1371 Ranger's Cottage 1/4 Skyline Blvd San Bruno 11 94066 21 2819021 Own 47 Public Utilities Commission 1            
36 3300 Park View Commons Housing 701 Frederick St San Francisco 1 94177 22 2819021 Lease 9 Non-City 3   -122.45617046900006 37.765803055999974 (37.76580305599998, -122.45617046900003) 5 8 Mayor 16
37 1429 San Andreas Cottage West Of Hwy 280 Burlingame Millbrae 4 94030 13 2819021 Own 47 Public Utilities Commission 1            
38 3285 BROADWAY/EMBARCADERO SIDEWALK Broadway and Embarcadero San Francisco 1 94111 23 2819021 Own 46 Port 5 2925 -122.39799537599998 37.79889517800001 (37.79889517800001, -122.39799537599998) 3 2 Public Works 3
39 3248 Valencia/Stevenson Dog Park and Parking Valencia and Duboce San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.422244757 37.77042477100002 (37.77042477100002, -122.42224475699999) 9 5 Gsa - Real Estate Division 5
40 3335 Material Testing Lab - 2025 Newcomb 2025 Newcomb San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.39808900499996 37.739653209999965 (37.73965320999997, -122.39808900499997) 10 3 Public Works 3
41 3336 752 Vallejo St 752 Vallejo St San Francisco 1 94133 24 2819021 Lease 9 Non-City 3   -122.409539562 37.798675333000006 (37.798675333000006, -122.40953956200002) 3 2 Fire Department 14
42 3283 3901-3905 Mission St 3901 Mission St San Francisco 1 94112 25 2819021 Lease 9 Non-City 3   -122.42460268899998 37.73508739099997 (37.73508739099998, -122.42460268899998) 9 5 Public Health 6
43 3245 SFO Office - 837 Malcolm Rd 837 Malcolm Rd San Mateo 7 94010 14 2819021 Lease 9 Non-City 3   -122.37180924299996 37.60030703299998 (37.60030703299998, -122.37180924299997)   Airport (Sfo) 17
44 2044 Laguna Honda Valve Station 350 Laguna Honda Blvd San Francisco 1 94131 26 2819021 Lease 9 Non-City 3   -122.45938626100002 37.748347736000035 (37.74834773600003, -122.45938626100002) 7 1 Public Utilities Commission 13
45 3276 Public Art Work - Ingleside Presbyterian Church 1345 Ocean Ave San Francisco 1 94112 25 2819021 Lease 9 Non-City 3   -122.45704206200004 37.723945593 (37.723945592999996, -122.45704206200003) 7 1 Arts Commission 18
46 3292 Fire Station #51 218 Lincoln Blvd San Francisco 1 94129 20 2819021 Lease 9 Non-City 3   -122.455513431 37.80149717500001 (37.80149717500001, -122.45551343099999) 2 6 Fire Department 14
47 2097 Water Dept Cottage Crystal Springs Rd Millbrae 4 94030 13 2819021 Own 47 Public Utilities Commission 1   -122.409328087 37.58053001500002 (37.58053001500002, -122.409328087)    
48 163 Barns West Of Hiway 280 Millbrae 4 94030 13 2819021 Own 47 Public Utilities Commission 1            
49 1373 Ranger's Cottage - Half Moon Bay Rd Half Moon Bay Road San Mateo 7 94404 27 2819021 Own 47 Public Utilities Commission 1            
50 3277 USF Lone Mountain Building East Wing Roof 2800 Turk Blvd San Francisco 1 94118 28 2819021 Lease 9 Non-City 3   -122.452062432 37.779228640999975 (37.779228640999975, -122.45206243199999) 1 7 Emergency Management 10
51 3270 Selby Palou Park Annex 1321 Selby St San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.40041557900005 37.738900167 (37.738900167, -122.40041557900003) 10 3 Recreation And Parks 2
52 3309 San Francisco LGBT Center 1800 Market St San Francisco 1 94102 15 2819021 Lease 9 Non-City 3   -122.42408615800001 37.77174880199999 (37.77174880199999, -122.42408615800002) 8 9 Gsa - City Administrator's Office 19
53 3260 750 Brannan St 750 Brannan St San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.402439908 37.77386904000002 (37.77386904000002, -122.40243990800002) 6 4 Public Library 20
54 3301 TI Athletic Field - 8TH/AVE M Ave M & 8TH TI ST San Francisco 1 94130 10 2819021 Own 114 Treasure Island Development Authority 4   -122.367047647 37.825536724000024 (37.82553672400002, -122.36704764699999) 6 4  
55 3258 833 Bryant St - Parking 833 Bryant St San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.40340165499998 37.775111767 (37.775111767, -122.40340165499998) 6 4 Police Department 21
56 1374 Ranger's Shed - Crystal Springs Es Skyline Blvd N/ San Mateo 7 94402 16 2819021 Own 47 Public Utilities Commission 1            
57 3239 450 Toland St 450 Toland St San Francisco 1 94124 5 2819021 Lease 9 Non-City 3   -122.39849889700001 37.744877159 (37.744877159, -122.39849889700002) 10 3 Gsa - Office Of Contract Administration 22
58 3287 Parkmerced Shopping Center 51 Cambon Dr San Francisco 1 94132 1 2819021 Lease 9 Non-City 3   -122.473645976 37.71751317600001 (37.71751317600001, -122.473645976) 7 1 Gsa - City Administrator's Office 19
59 3262 167 Jessie St - Offices 167 Jessie St San Francisco 1 94105 6 2819021 Lease 9 Non-City 3   -122.401981332 37.786986273000025 (37.786986273000025, -122.40198133199999) 6 4 Mayor 16
60 3333 Treasure Island Substation Avenue M and California Ave San Francisco 1 94130 10 2819021 Own 47 Public Utilities Commission 1   -122.36430524399998 37.821725910999994 (37.82172591099999, -122.36430524399998) 6 4  
61 3261 564 6th St - Offices 564 6th St San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.40171173599998 37.77513883099999 (37.77513883099999, -122.40171173599998) 6 4 Adult Probation 23
62 3290 Bowley St/Lincoln Blvd SFMTA Operator Restroom Bowley St/Lincold Blvd San Francisco 1 94129 20 2819021 Own 42 Municipal Transportation Agency 7 75 -122.48132737200001 37.792030716999996 (37.79203071699999, -122.48132737200001) 2 6  
63 3279 711 Van Ness Ave Offices 711 Van Ness Ave San Francisco 1 94102 15 2819021 Lease 9 Non-City 3   -122.420990705 37.782127635999984 (37.782127635999984, -122.42099070500001) 5 8 Emergency Management 10
64 3338 SamTrans Right of Way - Millbrae Millbrae Millbrae 4 94030 13 2819021 Lease 9 Non-City 3   -122.39698324900002 37.61020556 (37.61020556, -122.39698324900002)   Technology 7
65 3307 Bay Bridge Pump Station West of Main St and Bryant St San Francisco 1 94105 6 2819021 Lease 9 Non-City 3   -122.38913703200001 37.786948036000005 (37.78694803600001, -122.38913703200001) 6 4 Public Utilities Commission 13
66 592 Downtown Substation 79 Stevenson St San Francisco 1 94105 6 3708031 Own 42 Municipal Transportation Agency 7 4644 -122.40009670299996 37.78925921600001 (37.789259216000005, -122.40009670299997) 6 4  
67 1391 Rectifier - Brisbane 133 Main St Daly City 6 94014 4   Own 47 Public Utilities Commission 1   -122.411784717 37.701785374 (37.701785373999996, -122.41178471699999)    
68 485 City Hall 1 Dr Carlton B Goodlett Pl San Francisco 1 94102 15 0787001 Own 63 Gsa - Real Estate Division 8 516484 -122.41922597500002 37.779275118999976 (37.779275118999976, -122.41922597500002) 6 4 Mayor: Gsa - City Administrator's Office: Controller: Elections: Mayor: Treasurer-Tax Collector: Assessor-Recorder: City Attorney: Board Of Supervisors: Public Works: Sheriff: Gsa - County Clerk 24
69 3343 730 Stanyan St 730 Stanyan St San Francisco 1 94117 29 1249024 Own 103 Mayor 9   -122.453192361 37.768714171 (37.768714171, -122.45319236099999) 5 8  
70 3344 1231 Stevenson St Offices 1231 Stevenson St San Francisco 1 94103 8 2819021 Lease 9 Non-City 3   -122.42107253900002 37.772773503 (37.772773502999996, -122.42107253900002) 6 4 Technology 7
71 1395 Redwood Center 100 Edmonds Rd Redwood City 12 94062 30   Own 72 Public Health 10   -122.282673955 37.475726829 (37.475726828999996, -122.282673955)    
72 3425 WEST FIELD CARGO FACILITY - 632 632 WEST CARGO ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.395661712 37.62188696599998 (37.62188696599998, -122.39566171199999)    
73 3365 MAINTENANCE BUILDING - 682 682 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.398982175 37.623700809000006 (37.62370080900001, -122.39898217500001)    
74 3387 RAC QTA - 782 782 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39972432799999 37.629828882000034 (37.62982888200003, -122.39972432799999)    
75 3381 AIRTRAIN RAC - 779 779 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.401203458 37.628192618000014 (37.628192618000014, -122.401203458)    
76 3388 CORP YARD MAINTENANCE SHED - 1010   San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39036103900006 37.630058540999975 (37.63005854099998, -122.39036103900003)    
77 3327 49 South Van Ness Ave Building 49 South Van Ness Ave San Francisco 1 94103 8 3506008 Own 63 Gsa - Real Estate Division 8 564045 -122.418572841 37.773797866 (37.773797865999995, -122.41857284100001) 6 4  
78 3428 ELECTRICAL BUILDING - 11-BR 11 SOUTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.38615230200004 37.60741266000002 (37.60741266000002, -122.38615230200003)    
79 3315 450 6th St 450 6th St San Francisco 1 94103 8 3759043 Own 63 Gsa - Real Estate Division 8 5998 -122.40333281699999 37.77643084499999 (37.77643084499999, -122.40333281699998) 6 4  
80 3357 W FIELD RD AIRTRAIN (INBOUND) - 677A 677 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39953742900002 37.621598655000014 (37.621598655000014, -122.39953742900002)    
81 3395 NORTH CARGO FIELD CARGO - 900 900 NORTH ACCESS ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.38787345600002 37.63764428600001 (37.63764428600001, -122.38787345600002)    
82 3353 BOARDING AREA F JETWAY BUILDING - 400G 400 UPPER DOMESTIC LOOP San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.38891041 37.62025513399999 (37.62025513399999, -122.38891041)    
83 3440 BOARDING AREA F JETWAY BUILDING - 400L 400 UPPER DOMESTIC LOOP San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.38983414199998 37.621169854000016 (37.621169854000016, -122.38983414199998)    
84 3418 MERF - 1030 1030 NORTH ACCESS ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.38770892999996 37.630192572 (37.630192572, -122.38770892999997)    
85 3423 DATA CENTER - 60 60 SOUTH LINK ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.393934354 37.61347702799998 (37.61347702799998, -122.39393435400001)    
86 3447 SFO BART STATION - 497 497 UPPER DOMESTIC LOOP San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.391091624 37.616321374999984 (37.616321374999984, -122.39109162400001)    
87 3358 CCSF STORAGE - 624 624 WEST FIELD ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.397925398 37.621541294000004 (37.621541294, -122.39792539799998)    
88 3385 ELECTRICAL BUILDING - 779A 779 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.40128602599998 37.62866752299999 (37.62866752299999, -122.40128602599998)    
89 874 Hall of Justice (HOJ) 850 Bryant St San Francisco 1 94103 8 3759042 Own 63 Gsa - Real Estate Division 8 615241 -122.40432830100002 37.77498889899999 (37.77498889899999, -122.40432830100002) 6 4 District Attorney: Superior Court: Police Department: Sheriff: Adult Probation: Gsa - Medical Examiner 25
90 3453 GTU BUS MAINTENANCE FACILITY - 949 949 NORTH FIELD ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.391704636 37.63783074700001 (37.63783074700001, -122.39170463599999)    
91 3347 AIRTRAIN SUPPORT - 590 590 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39624697300002 37.61546741500001 (37.61546741500001, -122.39624697300002)    
92 3376 SWISSPORT - 730 730 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.40026415800006 37.626573898000004 (37.626573898000004, -122.40026415800003)    
93 3349 MAINTENANCE - 575B 575 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.394580767 37.616292665 (37.616292665, -122.39458076699998)    
94 3370 SHEET METAL SHOP - 692 692 NORTH MCDONNELL ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39976199799996 37.62430012200002 (37.62430012200002, -122.39976199799997)    
95 881 1650 Mission St Building 1650 Mission St San Francisco 1 94103 8 3512008 Own 63 Gsa - Real Estate Division 8 218538 -122.419563153 37.771740544000004 (37.77174054400001, -122.41956315300001) 6 4 Human Services Agency: Building Inspection: Mayor: Board Of Appeals: Planning 26
96 3421 AIR TRAIN ITB G - 179 179 INTERNATIONAL LOOP San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.38947889999996 37.61664514 (37.61664514, -122.38947889999997)    
97 3431 GARAGE A SUPPORT OFFICES - 98 98 NORTH LINK ROAD San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39099280800001 37.61401548800001 (37.61401548800001, -122.39099280800002)    
98 3438 BOARDING AREA F JETWAY BUILDING - 400J 400 UPPER DOMESTIC LOOP San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.39032999 37.621116213999976 (37.62111621399998, -122.39032999)    
99 3294 Alemany Market Food Stand #2 100 Alemany Blvd San Francisco 1 94110 9 5733A001 Own 63 Gsa - Real Estate Division 8 6800 -122.409984011 37.735861390000025 (37.735861390000025, -122.409984011) 9 5  
100 3405 MLTP - 918 918 CLEARWATER DRIVE San Francisco 1 94128 31   Own 34 Airport (Sfo) 11   -122.384044705 37.63691155700002 (37.63691155700002, -122.38404470500001)    

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "City_Facilities" (
"facility_id" INTEGER,
  "common_name" TEXT,
  "address" TEXT,
  "city" INTEGER,
  "zip_code" INTEGER,
  "block_lot" TEXT,
  "owned_leased" TEXT,
  "dept_id" INTEGER,
  "department_name" INTEGER,
  "gross_sq_ft" INTEGER,
  "longitude" REAL,
  "latitude" REAL,
  "geom" TEXT,
  "supervisor_district" INTEGER,
  "city_tenants" INTEGER
,
FOREIGN KEY ("city") REFERENCES [city](id),
    FOREIGN KEY ("zip_code") REFERENCES [zip_code](id),
    FOREIGN KEY ("department_name") REFERENCES [department_name](id),
    FOREIGN KEY ("supervisor_district") REFERENCES [supervisor_district](id),
    FOREIGN KEY ("city_tenants") REFERENCES [city_tenants](id))
Powered by Datasette · Query took 22.354ms · Data source: data.sfgov.org