home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows

View and edit SQL

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
101 0140437-01-001 Cake Gallery Inc The Cake Gallery Inc The 290 9th St San Francisco 1 CA 1 94103 25 03/17/1983   03/17/1983   290 9th St San Francisco 1 94103 32 CA 7220-7229 8 Food Services 8 0 0 H88 Retail Bakeries With Food Prep 6 3 South of Market 15   290 9TH ST San Francisco, CA 94103 (37.773836, -122.411676)
102 0099555-01-001 Collins Edward J Md Inc Collins Edward J Md Inc 1635 Divisadero St 525 San Francisco 1 CA 1 94115 4 10/01/1976   10/01/1976   2100 Webster St Ste 222 San Francisco 1 94115 2 CA     0 0     5 7 Japantown 22   1635 DIVISADERO ST San Francisco, CA 94115 (37.784843, -122.439845)
103 0034361-01-001 Owyang Sherwin & Jennette 1540 Hyde Apts 1540 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968 03/14/2014 10/01/1968 03/14/2014             0 0     3 1 Russian Hill 5   1540 HYDE ST San Francisco, CA 94109 (37.795043, -122.41822)
104 0034381-01-001 Micheli Julie & Mcginty A 1545 Filbert Apts 1545 Filbert St San Francisco 1 CA 1 94123 3 10/01/1968 01/01/2011 10/01/1968 01/01/2011             0 0     2 Marina 2   1545 FILBERT ST San Francisco, CA 94123 (37.799376, -122.425049)
105 0140473-01-001 Keung Walter L Dragon Seed Advertising 228 Chicago Way San Francisco 1 CA 1 94112 28 03/30/1983 06/30/2015 03/30/1983 06/30/2015             0 0     11 Excelsior 23   228 CHICAGO WAY San Francisco, CA 94112 (37.710235, -122.431824)
106 0048894-02-001 Chong Hing Co Inc 848 Grant Bldg 848 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   848 GRANT AVE San Francisco, CA 94108 (37.794872, -122.406426)
107 0083768-02-999 Armstrong Installation Ser In Armstrong Painting Roof & Wind 4575 San Pablo Ave Emeryville Emeryville 13 CA 1 94608 29 02/01/1973   07/01/2003   4575 San Pablo Ave Emeryville 18 94608 35 CA 2300-2399 6 Construction 6 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids       4575 SAN PABLO AVE EMERYVILLE EMERYVILLE, CA 94608 (37.835404, -122.281343)
108 0126717-05-001 Legallet Properties Llc 1001 Quesada Av 1001 Quesada Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   1401 Griffith St San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1001 QUESADA AVE San Francisco, CA 94124 (37.726154, -122.378767)
109 0005037-04-999 Honeywell International Inc Honeywell International Inc 353a Vintage Park Dr Foster City 14 CA 1 94404 30 10/01/1968   06/12/2006   Po Box 524 Mn10 182a Minneapolis 19 55440 36 MN 3100-3399 10 Manufacturing 10 0 0           353A VINTAGE PARK DR FOSTER CITY, CA 94404 (37.565365, -122.278755)
110 0031779-01-002 Papazian Emmy 2847 Fillmore Apts 320 Judah St San Francisco 1 CA 1 94122 19 10/01/1968   10/26/1993   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     5 7 Inner Sunset 13   320 JUDAH ST San Francisco, CA 94122 (37.762213, -122.465718)
111 0083797-01-001 Chambers & Chambers Inc Chambers & Chambers 2140 Palou Ave San Francisco 1 CA 1 94124 8 01/01/1974   09/21/1998   2140 Palou Ave San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0 H73 Deemed Approved Off-Sale Alcohol Use 10 4 Bayview Hunters Point 4   2140 PALOU AVE San Francisco, CA 94124 (37.739787, -122.401031)
112 0000265-06-003 Stephens Institute Inc Academy Of Art University 180 New Montgomery St San Francisco 1 CA 1 94105 7 10/01/1968   04/28/1995   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D04 D39 Multiple 6 3 Financial District/South Beach 1   180 NEW MONTGOMERY ST San Francisco, CA 94105 (37.786634, -122.399502)
113 0025733-77-001 San Francisco Parking Inc City Park 923 Folsom St San Francisco 1 CA 1 94107 22 10/01/1968 12/31/2015 08/01/2013 09/30/2014   San Francisco 1 99999 12   8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   923 FOLSOM ST San Francisco, CA 94107 (37.780026, -122.403712)
114 0099583-01-001 Relos Apolinar D Relos Dental Office 2460 Mission St. 202 San Francisco 1 CA 1 94110 18 10/01/1976   04/01/1998   2460 Mission St #202 San Francisco 1 94110 37 CA     0 0     9 8 Mission 12   2460 MISSION ST San Francisco, CA 94110 (37.757692, -122.418961)
115 0040064-02-001 Chin F Chin J Louie L Payne-Fong Building 405 6th Ave. San Francisco 1 CA 1 94118 6 10/01/1968   10/13/2000   551 Pacific Ave San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   405 6TH AVE San Francisco, CA 94118 (37.780882, -122.464281)
116 0071179-01-001 Deluca Anthony C & Michael 1801 Greenwich Apts 1801 Greenwich St San Francisco 1 CA 1 94123 3 01/01/1970   01/01/1970   51 Lunada Ct San Rafael 20 94901 38 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1801 GREENWICH ST San Francisco, CA 94123 (37.799755, -122.42957)
117 0034382-02-001 Mecham Woodrow J & Sally 75 Capra Way Apts 75 Capra Way San Francisco 1 CA 1 94123 3 10/01/1968   05/21/1996   400 Montgomery St Ste 1110 San Francisco 1 94104 1 CA     0 0     2 Marina 2   75 CAPRA WAY San Francisco, CA 94123 (37.802792, -122.43969)
118 0112362-01-001 Lee Dale Innovations 182 Bernard St San Francisco 1 CA 1 94109 24 06/27/1978   06/27/1978 06/01/2015 1835 30th Ave San Francisco 1 94122 15 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   182 BERNARD ST San Francisco, CA 94109 (37.796169, -122.416489)
119 0000265-06-004 Stephens Institute Inc Academy Of Art University 540 Powell St San Francisco 1 CA 1 94108 9 10/01/1968   01/28/1994   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D04 Places Of Public Assembly & Open-Air Assembly 3 1 Financial District/South Beach 1   540 POWELL ST San Francisco, CA 94108 (37.789736, -122.408673)
120 0048894-03-001 Chong Hing Co Inc 933-939 Grant Av Bldg 933 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   933 GRANT AVE San Francisco, CA 94108 (37.795646, -122.406581)
121 0048894-04-001 Chong Hing Co Inc 740 Jackson St Apts 740 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   740 JACKSON ST San Francisco, CA 94133 (37.795931, -122.407385)
122 0025753-01-001 Chait Robert R Etal Sf Provident Loan Assn 932 Mission St San Francisco 1 CA 1 94103 25 10/01/1968 06/30/2013 10/01/1968 06/30/2013             0 0     6 3 South of Market 15   932 MISSION ST SAN FRANCISCO, CA 94103 (37.782021, -122.407389)
123 0060940-04-001 Zachariah Family Trust 1444 Market St Building 1444 Market St San Francisco 1 CA 1 94102 16 10/01/1968 01/17/2017 03/04/1987 05/03/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   1444 MARKET ST San Francisco, CA 94102 (37.775967, -122.418233)
124 0140498-02-001 Kang Yung Dae Etal Printing Usa Co 3421 Geary Blvd San Francisco 1 CA 1 94118 6 05/30/1990 12/31/2014 04/01/1983 12/31/2014             0 0     1 6 Lone Mountain/USF 24   3421 GEARY BLVD San Francisco, CA 94118 (37.781358, -122.455651)
125 0000265-06-005 Stephens Institute Inc Academy Of Art University 460 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   10/02/2009   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Mission Bay 25   460 TOWNSEND ST San Francisco, CA 94107 (37.774234, -122.398633)
126 0034389-01-001 Kirkham Associates 1530 5th Av Apts 1530 5th Ave San Francisco 1 CA 1 94122 19 10/01/1968 04/08/2014 10/01/1968 04/08/2014             0 0     7 9 Inner Sunset 13   1530 5TH AVE San Francisco, CA 94122 (37.759806, -122.46143)
127 0040069-01-001 Pezzi A Co 407 Greenwich Apts 407-411 Greenwich St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   331 Orchard Avenue Redwood City 21 94061 39 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   407 411 GREENWICH ST SAN FRANCISCO, CA 94133 (37.802632, -122.406779)
128 0161414-02-001 Wilkinson George F G F Wilkinson Books 34 Trinity Pl San Francisco 1 CA 1 94104 1 01/01/1987   10/01/2011   782 30th Ave San Francisco 1 94121 17 CA 4400-4599 3 Retail Trade 3 0 0           34 TRINITY PL San Francisco, CA 94104 (37.79031, -122.402557)
129 0112474-01-002 Rafaels Boutique Inc The Rafaels Boutique Inc The 643 Market St San Francisco 1 CA 1 94105 7 07/07/1978   03/13/2000   643 Market St San Francisco 1 94105 5 CA 4400-4599 3 Retail Trade 3 0 0     6 3 Financial District/South Beach 1   643 MARKET ST San Francisco, CA 94105 (37.78848, -122.402395)
130 0112490-01-001 Gigler Richard A Giglers Body Shop 3252 19th St San Francisco 1 CA 1 94110 18 06/16/1976 11/15/2013 06/16/1976 11/15/2013             0 0     9 8 Mission 12   3252 19TH ST San Francisco, CA 94110 (37.760426, -122.416086)
131 0048894-05-001 Chong Hing Co Inc 742 Jackson Rentals 742 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   12/31/1988   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   742 JACKSON ST San Francisco, CA 94133 (37.795927, -122.407415)
132 0061015-01-001 Wong Ngao Ngen & Fay 4600-4604 California Apts 4600 California St San Francisco 1 CA 1 94118 6 05/01/1969   05/01/1969   183 8th Av San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   4600 CALIFORNIA ST San Francisco, CA 94118 (37.784723, -122.466718)
133 0011650-01-001 Dare Rose Dare Rose 966 Pine St San Francisco 1 CA 1 94108 9 09/17/1973   09/17/1973   966 Pine St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   966 PINE ST San Francisco, CA 94108 (37.790728, -122.411831)
134 0031779-02-001 Papazian Emmy 688 Teresita Blvd Apts 688 Teresita Blvd San Francisco 1 CA 1 94127 31 10/01/1968   09/25/1992   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     7 9 West of Twin Peaks 26   688 TERESITA BLVD San Francisco, CA 94127 (37.735795, -122.446376)
135 0140506-01-001 Liang Hsung Ying Liang Dr Medical Office 2000 Van Ness Ave 607 San Francisco 1 CA 1 94109 24 04/01/1983   05/01/2008   2000 Van Ness Ave Ste 607 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Russian Hill 5   2000 VAN NESS AVE San Francisco, CA 94109 (37.794086, -122.423016)
136 0126717-06-001 Legallet Properties Llc 1031 Quesada Av 1031 Quesada Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   1401 Griffith St San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1031 QUESADA AVE San Francisco, CA 94124 (37.726629, -122.379611)
137 0048894-06-001 Chong Hing Co Inc 933-939 Grant Av Rentals 933 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   12/31/1988   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   933 GRANT AVE San Francisco, CA 94108 (37.795646, -122.406581)
138 0031779-03-001 Papazian Emmy 1379 30th Ave Apts 1379 30th Ave San Francisco 1 CA 1 94122 19 10/01/1968   11/17/1986   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     4 10 Sunset/Parkside 14   1379 30TH AVE San Francisco, CA 94122 (37.761664, -122.488846)
139 0011651-01-001 Greene Howard C Inc Greene Howard C Inc 276 11th St San Francisco 1 CA 1 94103 25 10/01/1968   10/01/1968   30 Daryl Ave Novato 22 94947 40 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission 12   276 11TH ST San Francisco, CA 94103 (37.77228, -122.414562)
140 0071434-01-001 Williams Marion & Geraldine 190 Victoria Apts 190 Victoria St San Francisco 1 CA 1 94132 32 01/01/1972   01/01/1972   35 Grove St Ste 108 San Francisco 1 94102 16 CA     0 0     11 Oceanview/Merced/Ingleside 27   190 VICTORIA ST San Francisco, CA 94132 (37.714068, -122.46531)
141 0112513-02-001 Russ Bldg Stationers Inc Russ Stationers 3790 Balboa St San Francisco 1 CA 1 94121 15 06/10/1978   09/10/2003   3795 Balboa St San Francisco 1 94121 17 CA 4400-4599 3 Retail Trade 3 0 0     1 6 Outer Richmond 9   3790 BALBOA ST San Francisco, CA 94121 (37.775607, -122.499473)
142 0011651-03-001 Greene Howard C Inc 1526 Folsom St Building 1526 Folsom St San Francisco 1 CA 1 94103 25 10/01/1968   02/28/1969   30 Daryl Ave Novato 22 94947 40 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission 12   1526 FOLSOM ST San Francisco, CA 94103 (37.771463, -122.414493)
143 0061015-02-001 Wong Ngao Ngen & Fay 648 7th Ave Apts 648 7th Ave San Francisco 1 CA 1 94118 6 05/01/1969   05/01/1969   183 8th Av San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   648 7TH AVE San Francisco, CA 94118 (37.776012, -122.465019)
144 0140520-02-001 Tran Sam & Rose Q Sam Coffee 1432 Yosemite Ave San Francisco 1 CA 1 94124 8 04/01/1983   01/01/1989   1432 Yosemite Ave San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1432 YOSEMITE AVE San Francisco, CA 94124 (37.725074, -122.388553)
145 0048904-01-001 Tom Jinnie 227 15th Av Apts 227 15th Ave San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   227 15th Av San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   227 15TH AVE San Francisco, CA 94118 (37.783825, -122.474214)
146 0112513-03-001 Russ Bldg Stationers Inc San Francisco Archery Shop 3795 Balboa St San Francisco 1 CA 1 94121 15 06/10/1978   03/01/2004   3795 Balboa St San Francisco 1 94121 17 CA 4400-4599 3 Retail Trade 3 0 0     1 6 Outer Richmond 9   3795 BALBOA ST San Francisco, CA 94121 (37.77561, -122.49941)
147 0061067-01-001 Fortuin Floyd D Fortuin Floyd D 909 Hyde St 609 San Francisco 1 CA 1 94109 24 11/01/1970   02/09/2000   909 Hyde St #620 San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)
148 0011651-04-001 Greene Howard C Inc 1560 Folsom St Building 1560 Folsom St San Francisco 1 CA 1 94103 25 10/01/1968   02/28/1969   30 Daryl Ave Novato 22 94947 40 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission 12   1560 FOLSOM ST San Francisco, CA 94103 (37.771227, -122.414721)
149 0416090-01-001 Belani Suesh/ravi 92-98 Webster St Apts 92-98 Webster St San Francisco 1 CA 1 94117 33 03/31/2007   03/31/2007   11645 Putter Wy Los Altos 23 94024 41 CA 7210-7219 9 Accommodations 9 0 0     5 7 Hayes Valley 10   92 98 WEBSTER ST San Francisco, CA 94117 (37.77121, -122.428606)
150 0000265-06-006 Stephens Institute Inc Academy Of Art University 1835-49 Van Ness Ave San Francisco 1 CA 1 94109 24 10/01/1968   06/09/1998   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D05 D10 D19 D31 Multiple 2 Pacific Heights 16   1835 49 VAN NESS AVE San Francisco, CA 94109 (37.792972, -122.422943)
151 0099678-01-001 Echenberg Dean F 406-412 Arkansas Apts 406 Arkansas St San Francisco 1 CA 1 94107 22 01/01/1976   01/01/1976   2799 California St San Francisco 1 94115 2 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   406 ARKANSAS ST San Francisco, CA 94107 (37.760992, -122.398302)
152 0025790-01-001 Sf Warehouse Property Co Sf Warehouse Property Co 200 Napoleon St San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   Po Box 475520 San Francisco 1 94147 42 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   200 NAPOLEON ST San Francisco, CA 94124 (37.746438, -122.400744)
153 0007393-01-003 Del Camp Investments Inc Del Camp Investments Inc 2755 Webster St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   2120 Market St #100 San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   2755 WEBSTER ST San Francisco, CA 94123 (37.796221, -122.433637)
154 0038303-01-001 Rodriguez Pearl 296 Union St Apts 296 Union St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1800 Atrium Pkwy Apt 414 Napa 24 94559 44 CA     0 0     3 1 North Beach 6   296 UNION ST San Francisco, CA 94133 (37.801061, -122.404195)
155 0040074-01-001 Yee Jack M & Grace S 407 11th Av Apts 407 11th Ave San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   1540 Pacheco St San Francisco 1 94116 45 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   407 11TH AVE San Francisco, CA 94118 (37.780474, -122.469618)
156 0112536-01-001 Inter World Trading Co Inc Inter World Trading Co Inc 760 Market St 365 San Francisco 1 CA 1 94102 16 01/01/1978   01/01/1978 09/30/2013 833 Market St Ste 505 San Francisco 1 94103 32 CA 4200-4299 7 Wholesale Trade 7 0 0     3 1 Financial District/South Beach 1   760 MARKET ST San Francisco, CA 94102 (37.786173, -122.40532)
157 0140525-01-001 Ko Kim Ping & Karen Ko Dry Cleaner & Tailoring 333 Columbus Ave San Francisco 1 CA 1 94133 11 04/01/1983   04/01/1983   333 Columbus Av San Francisco 1 94133 9 CA 8100-8139 5 Certain Services 5 0 0     3 1 Chinatown 7   333 COLUMBUS AVE San Francisco, CA 94133 (37.798348, -122.407444)
158 0061092-01-001 Hall Association Nsgw 414 Mason Bldg 414 Mason St San Francisco 1 CA 1 94102 16 01/01/1970   01/01/1970   414 Mason St San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   414 MASON ST San Francisco, CA 94102 (37.787472, -122.409946)
159 0083808-01-001 Crisera Robert A Crisera Robert A Phd-Cnslt Mgt 155 Yerba Buena Ave San Francisco 1 CA 1 94127 31 02/01/1974 01/01/2015 02/11/2010 01/01/2015             0 0     7 9 West of Twin Peaks 26   155 YERBA BUENA AVE San Francisco, CA 94127 (37.736207, -122.461848)
160 0140577-01-001 Vogel Richard J Vogel Sales 90 Loomis St San Francisco 1 CA 1 94124 8 02/01/1983   01/05/1993   Po Box 27674 San Francisco 1 94127 46 CA     0 0     10 4 Bayview Hunters Point 4   90 LOOMIS ST San Francisco, CA 94124 (37.742835, -122.404102)
161 0158585-02-001 Chu Chin Jung & Kuo Fong San Tung Restaurant #2 1031 Irving St San Francisco 1 CA 1 94122 19 09/01/1986 07/01/2011 10/02/1996 07/01/2011             0 0     5 7 Inner Sunset 13   1031 IRVING ST San Francisco, CA 94122 (37.763931, -122.468904)
162 0000265-06-007 Stephens Institute Inc Academy Of Art University 620 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   08/11/2005   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 H56 Swimming Pools (Year-Round) 3 1 Nob Hill 17   620 SUTTER ST San Francisco, CA 94102 (37.788972, -122.410677)
163 0025833-02-001 Soha Engineers Soha Engineers 48 Colin P Kelly St San+francisco 8 CA 1 94107 22 09/03/1997   06/01/2004   48 Colin P Kelly Street San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           48 COLIN P KELLY ST San Francisco, CA 94107 (37.781852, -122.39053)
164 0126717-07-001 Legallet Properties Llc 1101 Shafter Av 1101 Shafter Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   1401 Griffith St San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1101 SHAFTER AVE San Francisco, CA 94124 (37.725859, -122.381582)
165 0061116-01-001 Auerbach Nina K Auerbach Nina K Md 3663 Sacramento St San Francisco 1 CA 1 94118 6 07/01/1969   07/01/1969   3663 Sacramento St San Francisco 1 94118 28 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     2 Presidio Heights 3   3663 SACRAMENTO ST San Francisco, CA 94118 (37.787419, -122.452992)
166 0000265-06-008 Stephens Institute Inc Academy Of Art University 655 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   03/01/1999   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   655 SUTTER ST San Francisco, CA 94102 (37.788919, -122.41109)
167 0083814-01-001 Schneider Alan P Antique Traders 4300 California St San Francisco 1 CA 1 94118 6 04/01/1974   04/01/1974   4300 California St San Francisco 1 94118 28 CA 4400-4599 3 Retail Trade 3 0 0 P52 State 2nd Hand Dealer Jewelry/clothg/furn/books 2 Inner Richmond 21   4300 CALIFORNIA ST San Francisco, CA 94118 (37.785129, -122.463511)
168 0112536-03-001 Inter World Trading Co Inc Inter World Trading Co Inc 833 Market St 505 San Francisco 1 CA 1 94103 25 01/01/1978   10/01/2013   833 Market St Ste 505 San Francisco 1 94103 32 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   833 MARKET ST San Francisco, CA 94103 (37.784697, -122.407187)
169 0007393-51-001 Del Camp Investments Inc 1461 California Street 1461 California St San Francisco 1 CA 1 94114 34 10/01/1968   01/01/2000   2120 Market St #100 San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1461 CALIFORNIA ST San Francisco, CA 94114 (37.790868, -122.418392)
170 0007393-52-001 Del Camp Investments Inc 3755 Fillmore St 3755 Fillmore St San Francisco 1 CA 1 94123 3 10/01/1968   09/04/2009   2120 Market St #100 San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3755 FILLMORE ST San Francisco, CA 94123 (37.805328, -122.437319)
171 0007393-53-001 Del Camp Investments Inc 1930 Sacramento St 1930 Sacramento St San Francisco 1 CA 1 94109 24 10/01/1968   09/17/2010   2120 Market St #100 San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Pacific Heights 16   1930 SACRAMENTO ST San Francisco, CA 94109 (37.791011, -122.424757)
172 0026028-01-001 Shiota Paul K Shiota T Z 3131 Fillmore St San Francisco 1 CA 1 94123 3 07/01/2010   07/01/2010   3131 Fillmore St San Francisco 1 94123 48 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3131 FILLMORE ST San Francisco, CA 94123 (37.798457, -122.43578)
173 0034402-01-001 Golden Gateway Center Golden Gateway Center 460 Davis Ct San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   460 DAVIS CT San Francisco, CA 94111 (37.796577, -122.398248)
174 0071469-01-001 Fong Sheldon United Mechanical Svc Agency 2610 36th Ave San Francisco 1 CA 1 94116 23 04/01/1971   04/01/1971   2610 36th Av San Francisco 1 94116 45 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   2610 36TH AVE San Francisco, CA 94116 (37.738219, -122.493642)
175 0166489-02-001 Tucker Suzanne Marketing Solutions 211 14th Ave San Francisco 1 CA 1 94118 6 01/01/2001   01/01/2001   211 14th Ave San Francisco 1 94118 28 CA     0 0     1 6 Outer Richmond 9   211 14TH AVE San Francisco, CA 94118 (37.784145, -122.473119)
176 0083879-01-001 Gauger & Silva Inc Gauger & Silva Inc 360 Post Street Ste #901 San+francisco 8 CA 1 94108 9 01/02/1995   01/01/1997 07/21/2015 360 Post St 701 San Francisco 1 94108 22 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           360 POST STREET San Francisco, CA 94108 (37.788389, -122.407664)
177 0140622-03-999 Mcnely Construction Co Inc Mcnely Construction Co Inc 1040 Davis St San+leandro 15 CA 1 94577 36 05/29/2012   05/29/2012   1040 Davis St Suite 203 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0           1040 DAVIS ST SAN LEANDRO, CA 94577 (37.722144, -122.166437)
178 0000265-07-001 Stephens Institute Inc Academy Of Art University 1055 Pine St San Francisco 1 CA 1 94109 24 10/01/1968   01/02/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   1055 PINE ST San Francisco, CA 94109 (37.790564, -122.413156)
179 0061143-01-001 Richman David N Richman David N Md 2536 Clay St San Francisco 1 CA 1 94115 4 07/01/1969   07/01/1969 01/01/2015 305 Cape Ct Mill Valley 26 94941 50 CA 6100-6299 4 Private Education and Health Services 4 0 0     2 Pacific Heights 16   2536 CLAY ST San Francisco, CA 94115 (37.790632, -122.434942)
180 0099698-01-001 Dinelli Robert R Dinelli Robert Studio 2546 Bryant St San Francisco 1 CA 1 94110 18 09/01/1975 09/11/2013 09/01/1975 09/11/2013             0 0     9 8 Mission 12   2546 BRYANT ST San Francisco, CA 94110 (37.75363, -122.409186)
181 0071475-01-001 Wedbush Morgan Securities Inc Wedbush Morgan Securities Inc 601 California St 500 San Francisco 1 CA 1 94108 9 01/01/1971   04/28/2006   1000 Wilshire Blvd Los Angeles 3 90017 51 CA 5210-5239 11 Financial Services 11 0 0     3 1 Financial District/South Beach 1   601 CALIFORNIA ST San Francisco, CA 94108 (37.792606, -122.404716)
182 0112607-01-001 Cook Collection Attorneys, A P Cook Perkiss Prof Law Corp 165 Fell St San Francisco 1 CA 1 94102 16 07/11/1978   01/01/2008   165 Fell Street San Francisco 1 94102 16 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     5 7 Hayes Valley 10   165 FELL ST San Francisco, CA 94102 (37.776232, -122.420694)
183 0007566-02-999 Design Workshops Design Workshops 486 Lesser St Oakland 16 CA 1 94601 37 09/03/1999   09/03/1999   486 Lesser St Oakland 27 94601 52 CA 2300-2399 6 Construction 6 0 0           486 LESSER ST OAKLAND, CA 94601 (37.763907, -122.219237)
184 0011651-05-001 Greene Howard C Inc 135 Kissling St Building 135 Kissling St San Francisco 1 CA 1 94103 25 10/01/1968   02/28/1969   30 Daryl Ave Novato 22 94947 40 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission 12   135 KISSLING ST San Francisco, CA 94103 (37.772228, -122.415471)
185 0112731-01-002 Leslie A. Hennessy Inc Leslie A. Hennessy Inc 545 2nd St San Francisco 1 CA 1 94107 22 06/01/1978   10/04/2004   545 2nd St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 H07 H31 H73 Multiple       545 2ND ST San Francisco, CA 94107 (37.782483, -122.392898)
186 0061172-01-001 Busk Ernest E & Mary J 212-246 Clement Bldg 212 Clement St San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   244 Clement St San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   212 CLEMENT ST San Francisco, CA 94118 (37.783086, -122.461772)
187 0048980-01-001 Schaezlein Robert F Schaezlein R & Son 1146 Clement St San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   1146 Clement St San Francisco 1 94118 28 CA 3100-3399 10 Manufacturing 10 0 0     1 6 Inner Richmond 21   1146 CLEMENT ST San Francisco, CA 94118 (37.7826, -122.471702)
188 0011673-01-001 Stauffacher Jack W Greenwood Press 300 Broadway St 300 San+francisco 8 CA 1 94133 11 10/01/1968   10/01/1968   1945 Broadway #305 San Francisco 1 94109 7 CA     0 0           300 BROADWAY ST San Francisco, CA 94133 (37.798383, -122.4026)
189 0099700-01-001 Scocci Remo & Rosanna Etal 1211 14th Av Apts 1211 14th Ave San Francisco 1 CA 1 94122 19 10/01/1973   10/01/1973   4444 Geary Blvd 105 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1211 14TH AVE SAN FRANCISCO, CA 94122 (37.765342, -122.471766)
190 0140625-05-001 Davanloo Hooshang Contempo Hair Design 4 Embarcadero Center San Francisco 1 CA 1 94111 35 04/02/1983   12/02/2012   163 Prince Royal Drive Corte Madera 28 94925 53 CA     0 0           4 EMBARCADERO CENTER San Francisco, CA 94111 (37.795106, -122.396158)
191 0048987-01-001 Burns F J Warehouse Inc Burns F J Warehouse Inc 640 Army St San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   640 Army St San Francisco 1 94124 6 CA 4800-4999 12 Transportation and Warehousing 12 0 0           640 ARMY ST San Francisco, CA 94124
192 0048999-01-001 Summit Land Co 1860 Jackson Apts 1860 Jackson St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   Po Box 591087 San Francisco 1 94159 4 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Pacific Heights 16   1860 JACKSON ST San Francisco, CA 94109 (37.793613, -122.425587)
193 0099749-04-001 Robertson Wm D & B A Etal 50-54 Webster St Apts 50 Webster St San Francisco 1 CA 1 94117 33 10/01/1976 12/15/2014 10/01/1976 12/15/2014             0 0     5 7 Hayes Valley 10   50 WEBSTER ST San Francisco, CA 94117 (37.770577, -122.428456)
194 0112736-01-002 Doyle Richard Jr Dds Inc Doyle Richard Jr-Dds 1 Daniel Burnham Ct Lobby Level 120c San Francisco 1 CA 1 94109 24 01/01/2002 01/02/2014 01/01/2002 01/02/2014             0 0     2 Western Addition 29   1 DANIEL BURNHAM CT San Francisco, CA 94109 (37.786987, -122.422537)
195 0083946-01-001 Toy Kan L Toy Kan L Dds 450 Sutter St 2340 San Francisco 1 CA 1 94108 9 08/01/1974 11/01/2017 08/01/1974 11/01/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   450 SUTTER ST San Francisco, CA 94108 (37.789331, -122.407788)
196 0112776-01-001 Barkhordarian George 533 Sutter St Building 533 Sutter St San Francisco 1 CA 1 94102 16 08/01/1976 12/15/2012 08/01/1976 12/15/2012             0 0     3 1 Nob Hill 17   533 SUTTER ST San Francisco, CA 94102 (37.789178, -122.409117)
197 0011795-01-001 Guardinos Souvenir & Gift Sho Guardinos Souvenir & Gift Shop 2801 Taylor St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   2801 Taylor St San Francisco 1 94133 9 CA 4400-4599 3 Retail Trade 3 0 0 H28 H73 Multiple 3 1 North Beach 6   2801 TAYLOR ST San Francisco, CA 94133 (37.80831, -122.415795)
198 0026225-01-999 Simonds Machinery Co Simonds Machinery Co 259 Harbor Way So San Francisco S+san+fran 9 CA 1 94080 17 10/01/1968   10/01/1968   259 Harbor Way S San Fran 29 94080 13 CA 4200-4299 4400-4599 13 Multiple 13 0 0           259 HARBOR WAY SO SAN FRANCISCO S SAN FRAN, CA 94080 (37.648652, -122.400123)
199 0008450-01-001 Sutter West Bay Hospitals California Pacific Med Ctr Pkg 2015 Steiner St San Francisco 1 CA 1 94115 4 06/01/1965   06/01/1965   Po Box 7999 San Francisco 1 94120 54 CA 6100-6299 4 Private Education and Health Services 4 0 0     2 Pacific Heights 16   2015 STEINER ST San Francisco, CA 94115 (37.787937, -122.435341)
200 0018906-01-004 Menzies Harold Inc Menzies Harold Inc 4044 Geary Blvd San Francisco 1 CA 1 94118 6 10/01/1968   12/31/1988   4044 Geary Blvd 1 Ste San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           4044 GEARY BLVD San Francisco, CA 94118 (37.781139, -122.462927)

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 41.543ms · Data source: data.sfgov.org