home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Location Start Date

View and edit SQL

Suggested facets: NAICS Code Description, Supervisor District

Business Corridor

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date ▼ Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
36675 0370837-01-001 Columbus Day Celebration Inc Columbus Day Celebration Inc 678 Green St San Francisco 1 CA 1 94133 11 01/01/1941   01/01/1941   678 Green St San Francisco 1 94133 9 CA     0 0     3 1 Chinatown 7   678 GREEN ST San Francisco, CA 94133 (37.79936, -122.41022)
90872 0467968-01-001 Little Sisters Of The Poor Little Sisters Of The Poor 300 Lake St San Francisco 1 CA 1 94118 6 01/01/1941   01/01/1941   300 Lake Street San Francisco 1 94118 28 CA     0 0 H26 Restaurant Greater Than 2,000 Sqft 2 Inner Richmond 21   300 LAKE ST San Francisco, CA 94118 (37.786775, -122.462513)
69433 0438264-01-001 American Jewish Committee Inc American Jewish Committee 121 Steuart St 405 San Francisco 1 CA 1 94105 7 01/01/1945   01/01/1945   165 E 56th St New York 49 10022 434 NY     0 0     6 3 Financial District/South Beach 1   121 STEUART ST San Francisco, CA 94105 (37.792888, -122.392751)
150955 1052595-02-161 Hung On Tong Society Hung On Tong Society 850 Grant Ave San Francisco 1 CA 1 94108 9 03/19/1904   01/01/1945   567 Pine St Ste 201 San Francisco 1 94108 22 CA     0 0     3 1 Chinatown 7   850 GRANT AVE SAN FRANCISCO, CA 94108 (37.794927, -122.406436)
150956 1052596-02-161 Hung On Tong Society Hung On Tong Society 657 Jackson St San Francisco 1 CA 1 94108 9 03/19/1904   01/01/1945   567 Pine St Ste 201 San Francisco 1 94108 22 CA     0 0     3 1 Chinatown 7   657 JACKSON ST SAN FRANCISCO, CA 94108 (37.796089, -122.406148)
25812 0334899-01-001 The University Corp, Sf State Village At Centennial Square 1600 Holloway Ave C6 San Francisco 1 CA 1 94132 32 01/01/1946   01/01/1946 04/26/2014 1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0     7 9 Lakeshore 31   1600 HOLLOWAY AVE San Francisco, CA 94132 (37.720848, -122.477023)
63587 0427887-01-001 Anasazi Properties Inc Anasazi Properties Inc 1600 Webster St San Francisco 1 CA 1 94115 4 01/01/1946   01/01/1946   1601 Larkin St 100 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Japantown 22   1600 WEBSTER ST San Francisco, CA 94115 (37.785593, -122.431329)
20823 0314730-01-001 Variety Club Of No. Ca Variety Club Of No. Ca 582 Market St 101 San Francisco 1 CA 1 94104 1 01/01/1947   01/01/1947   582 Market St San Francisco 1 94104 1 CA 8100-8139 5 Multiple 13 0 0     3 1 Financial District/South Beach 1   582 MARKET ST San Francisco, CA 94104 (37.78926, -122.401407)
41525 0383792-01-001 Potrero Hill Neighborhood Hse Potrero Hill Neighborhood Hse 953 De Haro St San Francisco 1 CA 1 94107 22 01/01/1947   01/01/1947   953 953 De Haro St St San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D04 H23 Multiple 10 4 Potrero Hill 28   953 DE HARO ST San Francisco, CA 94107 (37.758212, -122.400976)
43028 0387364-01-001 Mental Health Assoctn Of Sf Mental Health Assocatn Of Sf 870 Market St #928 San+francisco 8 CA 1 94102 16 01/01/1947   01/01/1947   870 Market St #928 San Francisco 1 94102 16 CA 5100-5199 6100-6299 8100-8139 145 Multiple 13 0 0           870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
165210 1080744-07-161 United Nations Assocs Of Sf United Nations Assocs Of Sf 3220 Sacramento St San Francisco 1 CA 1 94115 4 01/01/1947   01/01/1947   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Presidio Heights 3    
165659 1081331-07-161 S F Psychoanalytic Institute S F Psychoanalytic Institute 2420 Sutter St San Francisco 1 CA 1 94115 4 01/01/1947   01/01/1947   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Pacific Heights 16    
91050 0468207-01-001 Saint Luke's School Sls School 1755 Clay St San Francisco 1 CA 1 94109 24 01/01/1948   01/01/1948 10/14/2014 1335 Sutter Street San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   1755 CLAY ST San Francisco, CA 94109 (37.792249, -122.422128)
144306 1040516-09-151 Associated Students Inc Associated Students Inc 1650 Holloway Ave C-134 San Francisco 1 CA 1 94132 32 01/01/1948   01/01/1948   1650 Holloway Ave C-134 San Francisco 1 94132 56 CA     0 0           1650 HOLLOWAY AVE SAN FRANCISCO, CA 94132 (37.72091, -122.478945)
39269 0377995-01-001 Board Of Trts Of The Glide Fou Board Of Trts Of The Glide Fou 330 Ellis St San Francisco 1 CA 1 94102 16 01/01/1949   01/01/1949   330 Ellis St San Francisco 1 94102 16 CA     0 0     6 3 Tenderloin 11   330 ELLIS ST San Francisco, CA 94102 (37.785017, -122.411661)
146625 1044632-11-151 Board Of Trts Of The Glide Fou Glide 330 Ellis St San Francisco 1 CA 1 94102 16 01/01/1949   01/01/1949   330 Ellis St San Francisco 1 94102 16 CA     0 0           330 ELLIS ST SAN FRANCISCO, CA 94102 (37.785017, -122.411661)
45261 0392796-01-001 Unity Church San Francisco Unity San Francisco Foundation 2224 Bush St C San Francisco 1 CA 1 94115 4 01/01/1950   01/01/1950   2222 Bush St San Francisco 1 94115 2 CA     0 0     5 7 Pacific Heights 16   2224 BUSH ST C San Francisco, CA 94115 (37.786964, -122.433917)
133690 1022604-03-151 West Portal Merchants Association West Portal Merchants Association 236 West Portal Ave 313 San Francisco 1 CA 1 94127 31 01/01/1950   01/01/1950   236 West Portal Ave 313 San Francisco 1 94127 46 CA     0 0     7 9 West of Twin Peaks 26   236 WEST PORTAL AVE SAN FRANCISCO, CA 94127 (37.738551, -122.468448)
186712 1125990-11-161 Harold Parker Properties, Lp 186 Commonwealth 1844 Union Street San Francisco 1 CA 1 94123 3 01/01/1950   01/01/1950   1844 Union Street San Francisco 1 94123 48 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2    
25533 0334093-01-001 San Francisco Art Institute San Francisco Art Institute 800 Chestnut St San Francisco 1 CA 1 94131 14 01/01/1952   01/01/1952   800 Chestnut St San Francisco 1 94133 9 CA 6100-6299 4 Private Education and Health Services 4 0 0 D04 Places Of Public Assembly & Open-Air Assembly       800 CHESTNUT ST San Francisco, CA 94131 (37.803265, -122.417126)
25813 0334899-02-001 The University Corp, Sf State Whirlwind Wheelchair Intl 1600 Holloway Ave Sci 251 San Francisco 1 CA 1 94132 32 01/01/1946   01/01/1953 07/01/2014 1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0     7 9 Lakeshore 31   1600 HOLLOWAY AVE San Francisco, CA 94132 (37.720848, -122.477023)
41603 0384034-01-001 Temple United Meth Chrch Of Sf Temple United Meth Chrch Of Sf 1111 Junipero Serra Blvd San Francisco 1 CA 1 94132 32 01/01/1953   01/01/1953   1111 Junipero Serra Blvd San Francisco 1 94132 56 CA     0 0     11 Oceanview/Merced/Ingleside 27   1111 JUNIPERO SERRA BLVD San Francisco, CA 94132 (37.717454, -122.4725)
120589 0951672-01-001 Order Of Malta Western Assoc Order Of Malta 465 California St 450 San Francisco 1 CA 1 94104 1 01/01/1953   01/01/1953   465 California St 818 San Francisco 1 94104 1 CA 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   465 CALIFORNIA ST San Francisco, CA 94104 (37.792937, -122.402185)
79338 0453498-01-001 Sf Zoological Society Sf Zoological Society 1 Zoo Road San Francisco 1 CA 1 94132 32 01/01/1954   01/01/1954   1 Zoo Road San Francisco 1 94132 56 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D03 D18 D19 D26 Multiple 7 9 Lakeshore 31   1 ZOO ROAD San Francisco, CA 94132 (37.730346, -122.502199)
164806 1080068-06-161 Sf Culinary/service Empl. Pnsn Sf Culinary/service Empl. Pnsn 642 Harrison St San Francisco 1 CA 1 94107 22 01/01/1956   01/01/1956   1182 Market St #320 San Francisco 1 94102 16 CA     0 0     6 3 Financial District/South Beach 1    
36726 0371004-01-001 Young Audiences Of Ncalifornia Young Audiences Of Ncalifornia 125 Stillman St San Francisco 1 CA 1 94107 22 01/01/1957   01/01/1957   465 California Street 433 San Francisco 1 94104 1 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     6 3 South of Market 15   125 STILLMAN ST San Francisco, CA 94107 (37.781251, -122.397024)
147316 1045866-12-151 The Nature Conservancy The Nature Conservancy 4245 Fairfax Dr 100 Arlington 574 VA 5 22203 1086 01/01/1957   01/01/1957   201 Mission St 4th San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           4245 FAIRFAX DR ARLINGTON, VA 22203 (38.88223, -77.112288)
147318 1045868-12-151 The Nature Conservancy The Nature Conservancy 201 Mission St 4th Flr San Francisco 1 CA 1 94105 7 01/01/1957   01/01/1957   201 Mission St 4th San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   201 MISSION ST FLR SAN FRANCISCO, CA 94105 (37.791663, -122.395179)
40530 0381341-01-001 Whitney Young Child Dev Cntrs Whitney Young Child Dev Cntrs 100 Whitney Young Cr San Francisco 1 CA 1 94124 8 01/01/1958   01/01/1958   1101 Masonic Ave San Francisco 1 94117 80 CA 5600-5699 16 Administrative and Support Services 16 0 0     10 4 Bayview Hunters Point 4   100 WHITNEY YOUNG CR San Francisco, CA 94124 (37.733698, -122.384692)
42328 0385885-01-001 California Tennis Club California Tennis Club 1770 Scott St San Francisco 1 CA 1 94115 4 01/01/1958   01/01/1958   1770 Scott St San Francisco 1 94115 2 CA 4400-4599 7100-7199 7220-7229 144 Multiple 13 0 0 H24 Restaurant Less Than 1,000 Sqft 2 Pacific Heights 16   1770 SCOTT ST San Francisco, CA 94115 (37.785881, -122.438297)
30066 0350591-01-002 Spur Spur 654 Mission St San Francisco 1 CA 1 94105 7 01/01/1959   01/01/1959   654 Mission St San Francisco 1 94105 5 CA     0 0 D04 Places Of Public Assembly & Open-Air Assembly 6 3 Financial District/South Beach 1   654 MISSION ST San Francisco, CA 94105 (37.786911, -122.40119)
14733 0190757-01-999 Simco Electronics Simco Electronics 1178 Bordeaux Drive Sunnyvale 135 CA 1 94089 260 01/01/1962   01/01/1962   3131 Jay Street Suite 100 St Santa Clara 188 95054 521 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1178 BORDEAUX DRIVE Sunnyvale, CA 94089 (37.40638, -122.023183)
60308 0421910-01-001 Sf Women's Rehabilitation Fnd Stepping Stone 255 10th Ave San Francisco 1 CA 1 94118 6 01/01/1962   01/01/1962   255 10th Ave San Francisco 1 94118 28 CA 6100-6299 4 Private Education and Health Services 4 0 0     1 6 Inner Richmond 21   255 10TH AVE San Francisco, CA 94118 (37.783583, -122.468773)
165876 1081631-07-161 Sf African Amer Hist & Cult Sf African Amer Hist & Cult 762 Fulton St 2 San Francisco 1 CA 1 94102 16 01/01/1962   01/01/1962   762 Fulton St 2nd Fl San Francisco 1 94102 16 CA     0 0     5 7 Western Addition 29    
44839 0391752-01-001 Smith-Kettle Well Eye Research Smith-Kettle Well Eye Research 2318 Fillmore St San Francisco 1 CA 1 94115 4 01/01/1963   01/01/1963   2318 Fillmore Street San Francisco 1 94115 2 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     2 Pacific Heights 16   2318 FILLMORE ST San Francisco, CA 94115 (37.791115, -122.434297)
49882 0399412-01-001 Teen Challenge Teen Challenge 1464 Valencia San+francisco 8 CA 1 94110 18 01/01/1964   01/01/1964   1464 Valencia San Francisco 1 94110 37 CA     0 0           1464 VALENCIA San Francisco, CA 94110 (37.749449, -122.420404)
16898 0206666-01-001 Mccoppin St Inc Mccoppin St Inc 133 Mccoppin St San Francisco 1 CA 1 94103 25 01/01/1965 05/31/2015 01/01/1965 05/31/2015             0 0     8 5 Mission 12 Market/Castro 5 133 MCCOPPIN ST San Francisco, CA 94103 (37.771585, -122.42279)
102182 0480006-01-001 Guardian Life Insur Co Of Amer Guardian Life Insur Co Of Amer 555 Montgomery St 1600 San Francisco 1 CA 1 94111 35 01/01/1965   01/01/1965   7 Hanover Square H 15 D New York 49 10004 1265 NY 5240-5249 20 Insurance 17 0 0     3 1 Chinatown 7   555 MONTGOMERY ST San Francisco, CA 94111 (37.794454, -122.403102)
16480 0191910-01-999 Time Clock Sales Serv Co Inc Time Clock Sales Serv Co Inc 99 So San Francisco Brisbane Q4068 65   0 5 01/01/1966   01/01/1966   2950 Airway Av #D-7 Costa Mesa 546 92626 878 CA     0 0           99 SO 00000
36645 0370778-01-001 American Conservatory Theater American Conservatory Theater 30 Grant Ave San Francisco 1 CA 1 94108 9 01/01/1966   01/01/1966   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     3 1 Financial District/South Beach 1   30 GRANT AVE San Francisco, CA 94108 (37.787443, -122.404988)
36646 0370778-01-002 American Conservatory Theater American Conservatory Theater 415 Geary Street San Francisco 1 CA 1 94102 16 01/01/1966   01/01/1966   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D15 H86 Multiple 3 1 Tenderloin 11   415 GEARY STREET San Francisco, CA 94102 (37.787107, -122.410226)
43035 0387382-01-001 Bethany Center Senior Housing Bethany Center Senior Housing 580 Capp Street San Francisco 1 CA 1 94110 18 01/01/1966   01/01/1966   580 Capp Street San Francisco 1 94110 37 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   580 CAPP STREET San Francisco, CA 94110 (37.757455, -122.417841)
45628 0393762-01-001 United Way Of The Bay Area United Way Of The Bay Area 550 Kearny St 1000 San Francisco 1 CA 1 94108 9 01/01/1966   01/01/1966   550 Kearny Street Suite 1000 San Francisco 1 94108 22 CA     0 0     3 1 Financial District/South Beach 1   550 KEARNY ST San Francisco, CA 94108 (37.79297, -122.404505)
71312 0440849-01-001 The San Francisco School The San Francisco School 300 Gaven St San Francisco 1 CA 1 94134 26 01/01/1966   01/01/1966   300 Gaven St San Francisco 1 94134 23 CA 6100-6299 4 Private Education and Health Services 4 0 0 H91 School Cafeterias (Private W/food Prep) 9 8 Portola 18   300 GAVEN ST San Francisco, CA 94134 (37.732528, -122.411645)
84832 0460828-01-001 Sup Welfare Plan Inc Sup Welfare Plan 730 Harrisons St 415 San+francisco 8 CA 1 94107 22 01/01/1966   01/01/1966   730 Harrison St #415 San Francisco 1 94107 47 CA     0 0           730 HARRISONS ST San Francisco, CA 94107 (37.781897, -122.398229)
146999 1045329-11-151 Uso Of No California Uso Of No California Terminal 1 Mezzanine Sf Iap San+francisco 8 CA 1 94128 59 01/01/1966 12/31/2011 01/01/1966 12/31/2011             0 0           1 MEZZANINE SF IAP SAN FRANCISCO, CA 94128
165058 1080490-07-161 Performing Arts Workshop Inc Performing Arts Workshop Inc 265 Fort Mason C San+francisco 8 CA 1 94123 3 01/01/1966   01/01/1966   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
36610 0370687-01-001 Magic Theatre Inc The Magic Theatre Inc The Fort Mason Ctr Bldg D San+francisco 8 CA 1 94123 3 01/01/1967   01/01/1967   0 Fort Mason Ctr Bldg G San Francisco 1 94123 48 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           FORT MASON CTR BLDG D San Francisco, CA 94123 (37.800677, -122.436863)
59828 0421023-01-001 Audium Inc Audium Inc 1616 Bush St San Francisco 1 CA 1 94109 24 01/01/1967   01/01/1967   112 Midcrest Way San Francisco 1 94131 14 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     2 Western Addition 29   1616 BUSH ST San Francisco, CA 94109 (37.788238, -122.42387)
165443 1081042-07-161 Lycee Francais La Perouse Lycee Francais La Perouse 1201 Ortega St San Francisco 1 CA 1 94122 19 01/01/1967   01/01/1967   1201 Ortega Street San Francisco 1 94122 15 CA 6100-6299 4 Private Education and Health Services 4 0 0     4 10 Sunset/Parkside 14    
165461 1081066-07-161 Joint Action In Community Svce Joint Action In Community Svce 5225 Wisconsin Ave #404 Washington+dc 1319   20015 2922 01/01/1967   01/01/1967   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
165710 1081393-07-161 Mission Area Health Asscs Inc Mission Area Health Asscs Inc 240 Shotwell St San Francisco 1 CA 1 94110 18 01/01/1967   01/01/1967   240 Shotwell St San Francisco 1 94110 37 CA 6100-6299 4 Private Education and Health Services 4 0 0            
183103 1119397-09-161 Roger Miles Roger Miles 272 9th St Bldg San Francisco 1 CA 1 94103 25 10/03/2016   01/01/1967   59 Lupine Ave Bldg San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15    
5245 0054345-01-001 Motorola Solutions Inc Motorola Inc 1555 Burke Ave San Francisco 1 CA 1 94124 8 01/01/1968   01/01/1968   1301 E Algonquin Rd - Swa2 Schaumburg 276 60196 399 IL 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1555 BURKE AVE San Francisco, CA 94124 (37.744252, -122.385672)
5257 0032543-02-001 Chiao Johnson L & Diane W 1215 Bay Apts 1215 Bay St San Francisco 1 CA 1 94123 3 01/01/1968   01/01/1968   Po Box 641756 San Francisco 1 94164 132 CA 7210-7219 9 Accommodations 9 0 0     2 Marina 2   1215 BAY ST San Francisco, CA 94123 (37.803903, -122.427068)
5336 0037014-01-001 Pacheu Jean 1261 8th Av Apartments 1261 8th Ave San Francisco 1 CA 1 94122 19 01/01/1968   01/01/1968   1534 Irving St #201 San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1261 8TH AVE San Francisco, CA 94122 (37.764771, -122.465293)
5408 0037014-03-001 Pacheu Jean 3638 19th St Apts 3638 19th St San Francisco 1 CA 1 94110 18 01/01/1968   01/01/1968 12/31/2013 1534 Irving St #201 San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   3638 19TH ST San Francisco, CA 94110 (37.75991, -122.424589)
8365 0047479-01-001 Lai Enterprises Inc 775 Sacramento Rentals 775 Sacramento St San Francisco 1 CA 1 94108 9 01/01/1968   01/01/1968   1168 Pacific Ave San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   775 SACRAMENTO ST San Francisco, CA 94108 (37.793434, -122.405762)
36855 0371446-01-001 Exploratorium Exploratorium Pier 15/17 San+francisco 8 CA 1 94111 35 01/01/1968   01/01/1968   Pier 17 Pier 17 100 San Francisco 1 94111 11 CA     0 0 H93 Onsite Non-Potable Water Systems - Rainwater       17 San Francisco, CA 94111 (37.734361, -122.463842)
106827 0484881-01-001 St Kevin Catholic Church St Kevin Catholic Church 704 Cortland Ave San Francisco 1 CA 1 94110 18 01/01/1968   01/01/1968   704 Cortland Ave San Francisco 1 94110 37 CA     0 0     9 8 Bernal Heights 19   704 CORTLAND AVE San Francisco, CA 94110 (37.738913, -122.414869)
113175 0909895-01-001 Ymca Of San Francisco Ymca Of San Francisco 855 Sacramento St San Francisco 1 CA 1 94108 9 01/01/1968   01/01/1968   50 California St Ste 650 San Francisco 1 94111 11 CA     0 1 D04 H56 Multiple 3 1 Chinatown 7   855 SACRAMENTO ST San Francisco, CA 94108 (37.793285, -122.406895)
113199 0909934-01-001 Methodist Church Methodist Church 940 Washington St San Francisco 1 CA 1 94108 9 01/01/1968   01/01/1968   940 Washington St San Francisco 1 94108 22 CA     0 1     3 1 Chinatown 7   940 WASHINGTON ST San Francisco, CA 94108 (37.794864, -122.408708)
137197 1028612-05-151 Ymca Of San Francisco Urban Services Ymca 1530 Buchanan St San Francisco 1 CA 1 94111 35 01/01/1968   01/01/1968 01/01/1968 50 California St Ste 650 San Francisco 1 94111 11 CA     0 0           1530 BUCHANAN ST SAN FRANCISCO, CA 94111 (37.78411, -122.429531)
154973 1061937-04-161 William Decker & Company Inc William Decker & Company Inc 1113 Connecticut St 6 San Francisco 1 CA 1 94107 22 01/01/1968 01/01/1998 01/01/1968 01/01/1998         2300-2399 6 Construction 6 0 0           1113 CONNECTICUT ST SAN FRANCISCO, CA 94107 (37.751676, -122.396462)
214863 0055914-01-001 Balma Eugene R 20 Niagara Av Apartments 20 Niagara Ave San Francisco 1 CA 1 94112 28 01/01/1968 01/01/2014 01/01/1968 01/01/2014             0 0     11 Outer Mission 35   20 NIAGARA AVE San Francisco, CA 94112 (37.715857, -122.442074)
233 0040119-01-001 Acton Peter/bride/patrick 4106 25th St Apt 4106 25th St San Francisco 1 CA 1 94114 34 01/01/1969   01/01/1969   2487 Nw 1st St Bend 33 97701 59 OR 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   4106 25TH ST San Francisco, CA 94114 (37.749806, -122.432191)
529 0049528-02-999 Toland C E & Son Toland C E & Son Inc 5300 Industrial Wy Benicia 29 CA 1 94510 51 01/01/1969   01/01/1969   5300 Industrial Wy Benicia 59 94510 93 CA 2300-2399 6 Construction 6 0 0           5300 INDUSTRIAL WY BENICIA, CA 94510 (38.082604, -122.110399)
745 0040711-02-001 Cuneo Joseph D Etal 2598 Filbert Apts 2598 Filbert St San Francisco 1 CA 1 94123 3 01/01/1968 12/31/2013 01/01/1969 12/31/2013             0 0     2 Marina 2   2598 FILBERT ST San Francisco, CA 94123 (37.797215, -122.442101)
836 0049845-01-001 Sf Bar Pilots Sf Bar Pilots Pier 9 San Francisco 1 CA 1 94111 35 01/01/1969   01/01/1969   9 Pier East End San Francisco 1 94111 11 CA 4800-4999 12 Transportation and Warehousing 12 0 0           9 San Francisco, CA 94111 (37.732211, -122.464503)
1075 0061807-01-001 Vitlin Victor & Ross Mark 3131 19th St Bldg 3131 19th St San Francisco 1 CA 1 94110 18 10/01/1968   01/01/1969   99 Santa Rita Avenue San Francisco 1 94116 45 CA     0 0     9 8 Mission 12   3131 19TH ST San Francisco, CA 94110 (37.760545, -122.414185)
1146 0049974-01-001 Choy Yuk Kang 27 St Louis Bldg 27 St Louis Aly San Francisco 1 CA 1 94133 11 01/01/1969   01/01/1969   750 Pacific Avenue San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7 Chinatown 1 27 ST LOUIS ALY San Francisco, CA 94133 (37.795689, -122.407034)
1148 0049980-01-001 Alha Investment Company 308 8th Av Bldg 308 8th Ave San Francisco 1 CA 1 94118 6 01/01/1969   01/01/1969   750 Pacific Avenue San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   308 8TH AVE San Francisco, CA 94118 (37.782592, -122.466552)
1176 0050011-01-001 Keil-Sonoma Corp 460 Brannan St Building 460 Brannan St San Francisco 1 CA 1 94107 22 01/01/1969   01/01/1969   244 Kearny St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           460 BRANNAN ST San Francisco, CA 94107 (37.778887, -122.395824)
1204 0050032-01-001 Drake H Corp 151/161 Powell Bldg 151 Powell St San Francisco 1 CA 1 94102 16 01/01/1969   01/01/1969   244 Kearny St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   151 POWELL ST San Francisco, CA 94102 (37.786224, -122.408013)
1210 0050032-02-001 Drake H Corp 235/243 Ofarrell Bldg 235 Ofarrell St San Francisco 1 CA 1 94102 16 01/01/1969   01/01/1969   244 Kearny St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   235 OFARRELL ST San Francisco, CA 94102 (37.786357, -122.408694)
1212 0050032-03-001 Drake H Corp 1200-1208 Market Bldg 1200 Market St San Francisco 1 CA 1 94102 16 01/01/1969   01/01/1969   244 Kearny St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   1200 MARKET ST San Francisco, CA 94102 (37.778428, -122.41513)
1214 0050032-04-001 Drake H Corp 139-149 Powell Bldg 139 Powell St San Francisco 1 CA 1 94102 16 01/01/1969   01/01/1969   244 Kearny St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   139 POWELL ST San Francisco, CA 94102 (37.785884, -122.407945)
1255 0050064-01-001 Oneill Ann Geraldine 1999 Rev Geary Hyde Apartments 615 Hyde St San Francisco 1 CA 1 94109 24 01/01/1969 12/30/2014 01/01/1969 12/30/2014             0 0     6 3 Tenderloin 11   615 HYDE ST San Francisco, CA 94109 (37.78658, -122.41652)
1330 0050225-01-001 Prosek R M Monarch Gold Leaf Print Co 1072 Bryant St San Francisco 1 CA 1 94103 25 01/01/1969 12/31/2013 01/01/1969 12/31/2013             0 0     6 3 South of Market 15   1072 BRYANT ST San Francisco, CA 94103 (37.771627, -122.408135)
1396 0018906-04-001 Menzies Harold Inc 390-396 5th Av Apts 390 5th Ave San Francisco 1 CA 1 94118 6 10/01/1968   01/01/1969   4044 Geary Blvd 1 Ste San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   390 5TH AVE San Francisco, CA 94118 (37.781371, -122.463231)
1434 0073319-01-999 Jarvinen John Arnolds Door Operator Service 1093 Montgomery St Brisbane+q4068 3   0 5 01/01/1969   01/01/1969   1093 Montgomery St San Bruno 12 94066 27 CA 2300-2399 6 Construction 6 0 0           1093 MONTGOMERY ST 00000
1742 0050726-01-001 Woo Billy 237 Columbus Apts 237 Columbus Ave San Francisco 1 CA 1 94133 11 01/01/1969   01/01/1969   237 Columbus Ave San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 1     3 1 Chinatown 7   237 COLUMBUS AVE San Francisco, CA 94133 (37.797419, -122.406116)
1750 0050726-02-001 Woo Billy 217-241 Columbus Bldg 217-241 Columbus Ave San Francisco 1 CA 1 94133 11 01/01/1969   01/01/1969   237 Columbus Ave San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 0     3 1 Chinatown 7   217 241 COLUMBUS AVE San Francisco, CA 94133 (37.797413, -122.4061)
1823 0001746-02-001 Atlantic Richfield Co 2190 Carroll Av Bldg 2190 Carroll Ave San Francisco 1 CA 1 94124 8 10/01/1968   01/01/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     10 4 Bayview Hunters Point 4   2190 CARROLL AVE San Francisco, CA 94124 (37.73041, -122.40298)
1827 0001746-04-001 Atlantic Richfield Co 1798 Mission St Bldg 1798 Mission St San Francisco 1 CA 1 94103 25 10/01/1968   01/01/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     9 8 Mission 12   1798 MISSION ST San Francisco, CA 94103 (37.768512, -122.420008)
1835 0001746-05-001 Atlantic Richfield Co 1175 Fell St Bldg 1175 Fell St San Francisco 1 CA 1 94117 33 10/01/1968   01/01/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     5 7 Hayes Valley 10   1175 FELL ST San Francisco, CA 94117 (37.773993, -122.438157)
1843 0001746-06-001 Atlantic Richfield Co 376 Castro St Bldg 376 Castro St San Francisco 1 CA 1 94114 34 10/01/1968   01/01/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     8 5 Castro/Upper Market 30   376 CASTRO ST San Francisco, CA 94114 (37.762934, -122.435199)
1851 0001746-07-001 Atlantic Richfield Co 1200 Geneva Ave Bldg 1200 Geneva Ave San Francisco 1 CA 1 94112 28 10/01/1968   01/01/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     11 Excelsior 23   1200 GENEVA AVE San Francisco, CA 94112 (37.714034, -122.435918)
1860 0001746-08-001 Atlantic Richfield Co 5898 Mission St Bldg 5898 Mission St San Francisco 1 CA 1 94112 28 10/01/1968   01/01/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     11 Outer Mission 35   5898 MISSION ST San Francisco, CA 94112 (37.70882, -122.452654)
2177 0051017-01-001 Hontalas Demosthenes Louis Restaurant 902 Point Lobos Ave San Francisco 1 CA 1 94121 15 01/01/1969   01/01/1969   902 Point Lobos Av San Francisco 1 94121 17 CA 7220-7229 8 Food Services 8 0 0     1 6 Outer Richmond 9   902 POINT LOBOS AVE San Francisco, CA 94121 (37.779035, -122.512804)
2193 0051026-01-001 Chinese Daily Post Ltd 809 Sacramento Bldg 809 Sacramento St San Francisco 1 CA 1 94108 9 01/01/1969   01/01/1969   608 N.el Camino Real San Mateo 32 94401 220 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   809 SACRAMENTO ST San Francisco, CA 94108 (37.793353, -122.406388)
2351 0018906-04-002 Menzies Harold Inc 390-396 5th Av Apts 390-396 5th Ave San Francisco 1 CA 1 94118 6 10/01/1968   01/01/1969   4044 Geary Blvd 1 Ste San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     1 6 Inner Richmond 21   390 396 5TH AVE San Francisco, CA 94118 (37.781371, -122.463231)
2448 0051308-01-001 Die & Tool Products Co Inc Die & Tool Products Co Inc 1925 Ingalls St San Francisco 1 CA 1 94124 8 01/01/1969   01/01/1969   1925 Ingalls St San Francisco 1 94124 6 CA 3100-3399 10 Manufacturing 10 0 0     10 4 Bayview Hunters Point 4   1925 INGALLS ST San Francisco, CA 94124 (37.727073, -122.385838)
2699 0003856-03-001 Lew Willie L & Po S 1433-1437 Clement St Building 1433 Clement St San Francisco 1 CA 1 94118 6 10/01/1968 08/08/2017 01/01/1969 08/08/2017             0 0     1 6 Outer Richmond 9   1433 CLEMENT ST San Francisco, CA 94118 (37.782476, -122.474733)
3210 0042846-01-001 Avcor Investments 29-31 Guy Place 29 Guy Pl San Francisco 1 CA 1 94105 7 01/01/1969 12/31/2014 01/01/1969 12/31/2014             0 0     6 3 Financial District/South Beach 1   29 GUY PL San Francisco, CA 94105 (37.78652, -122.394368)
3844 0052418-01-001 Borrone Roy A 1127/1133 Kearny Apts 1127 Kearny St San Francisco 1 CA 1 94133 11 01/01/1969 05/12/2016 01/01/1969 05/12/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   1127 KEARNY ST San Francisco, CA 94133 (37.79847, -122.405547)
4376 0063434-01-001 Arvedi Patricia A 3416 26th St Apts 3416 26th St San Francisco 1 CA 1 94110 18 01/01/1969   01/01/1969   700 Diamond St San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   3416 26TH ST San Francisco, CA 94110 (37.749002, -122.418817)
4830 0006669-09-001 Cournale Clyde 4630 Geary Bl Bldg 4630 Geary Blvd San Francisco 1 CA 1 94118 6 10/01/1968   01/01/1969 06/30/2016 4630 Geary Blvd #202 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   4630 GEARY BLVD San Francisco, CA 94118 (37.780873, -122.46891)
4855 0006669-12-001 Cournale Clyde 910-914 Irving St Building 910 Irving St San Francisco 1 CA 1 94122 19 10/01/1968   01/01/1969   4630 Geary Blvd #202 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   910 IRVING ST San Francisco, CA 94122 (37.763985, -122.467751)
4893 0044406-06-001 K & H California Llc 117-119 Post St Bldg 117 Post St San Francisco 1 CA 1 94108 9 01/01/1969   01/01/1969   47 Kearny Street #800 San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   117 POST ST San Francisco, CA 94108 (37.788837, -122.404097)

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "Registered_Business_Locations_-_San_Francisco" (
"Location Id" TEXT,
  "Business Account Number" INTEGER,
  "Ownership Name" TEXT,
  "DBA Name" TEXT,
  "Street Address" TEXT,
  "City" INTEGER,
  "State" INTEGER,
  "Source Zipcode" INTEGER,
  "Business Start Date" TEXT,
  "Business End Date" REAL,
  "Location Start Date" TEXT,
  "Location End Date" REAL,
  "Mail Address" TEXT,
  "Mail City" INTEGER,
  "Mail Zipcode" INTEGER,
  "Mail State" TEXT,
  "NAICS Code" INTEGER,
  "NAICS Code Description" INTEGER,
  "Parking Tax" INTEGER,
  "Transient Occupancy Tax" INTEGER,
  "LIC Code" REAL,
  "LIC Code Description" REAL,
  "Supervisor District" INTEGER,
  "Neighborhoods - Analysis Boundaries" INTEGER,
  "Business Corridor" INTEGER,
  "Business Location" TEXT
,
FOREIGN KEY ("Neighborhoods - Analysis Boundaries") REFERENCES [Neighborhoods - Analysis Boundaries](id),
    FOREIGN KEY ("NAICS Code Description") REFERENCES [NAICS Code Description](id),
    FOREIGN KEY ("NAICS Code") REFERENCES [NAICS Code](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("Mail Zipcode") REFERENCES [Mail Zipcode](id),
    FOREIGN KEY ("Source Zipcode") REFERENCES [Source Zipcode](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("Supervisor District") REFERENCES [Supervisor District](id),
    FOREIGN KEY ("Business Corridor") REFERENCES [Business Corridor](id),
    FOREIGN KEY ("Mail City") REFERENCES [Mail City](id))
Powered by Datasette · Query took 798.376ms · Data source: data.sfgov.org