home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Neighborhoods - Analysis Boundaries

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
2 0012758-02-999 Hexol Inc Hexol Inc 19217 Willow Lane Sonoma 2 CA 1 95476 2 10/01/1968 11/30/2014 01/01/2006 11/30/2014             0 0           19217 WILLOW LANE SONOMA, CA 95476 (38.291744, -122.500337)
5 0074024-01-999 Western Shower Door Co., Inc. Western Shower Door Co., Inc. 99 Menlo Park Ca Brisbane+q4068 3   0 5 01/01/1973   01/01/1973   47000 Warm Springs Blvd Ste 1 Fremont 2 94539 3 CA     0 0           99 MENLO PARK 00000 (40.367952, -75.294567)
11 0087962-03-999 Jack Nadel Inc Jack Nadel International 2335 American River Dr 301 Sacramento 4 CA 1 95825 10 10/17/2006   10/24/2006   8701 Bellanca Ave Los Angeles 3 90045 8 CA     0 0           2335 AMERICAN RIVER DR SACRAMENTO, CA 95825 (38.569605, -121.409084)
13 0042500-08-999 Brondello A & Crespi V Bbc Investments 251 Layayette Cir 250 Yountville 5 CA 1 94599 12 10/01/1968   01/02/2002   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           251 LAYAYETTE CIR YOUNTVILLE, CA 94599
15 0051691-01-999 Levin Jos Realty Corp Of Sf Levin Jos Realty Corp Of Sf 170 Alpine Way San+bruno 6 CA 1 94066 13 10/01/1968 06/07/2016 01/01/2005 06/07/2016             0 0           170 ALPINE WAY SAN BRUNO, CA 94066 (37.618514, -122.438594)
20 0130792-05-999 Wang Joe Jw Flooring 116 Starlite St A S San Fran 7 CA 1 94080 17 11/26/1997   01/02/2006   483 Victory Ave So San Fran 5 94080 13 CA 2300-2399 6 Construction 6 0 0           116 STARLITE ST A S SAN FRAN, CA 94080 (37.650321, -122.416416)
25 0043960-01-002 Ampco System Parking 4415-4287 Ampco Pkg-Lot 4287 220 Bush St San Francisco 1 CA 1 94104 1 01/01/1995 12/31/2013 11/01/1988 12/31/2013             0 0           220 BUSH ST San Francisco, CA 94104 (37.791124, -122.401272)
35 0011460-06-001 Gow Supply Co Gow Supply Company 1490 Egbert St San+francisco 8 CA 1 94124 8 10/01/1968   04/09/1975   Po Box 24160 San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0           1490 EGBERT ST San Francisco, CA 94124 (37.723609, -122.394268)
37 0021420-01-999 Marchetti Construction Inc Marchetti Construction Inc 184 Harbor Way S+san+fran 9 CA 1 94080 17 10/01/1968 12/31/2014 10/01/1968 12/31/2014             0 0           184 HARBOR WAY S SAN FRAN, CA 94080 (37.651916, -122.400113)
38 0046324-21-999 Compass Group Usa Inc Imageworks 9050 W Washington Blvd Culver+city 10 CA 1 90232 20 10/01/1968   11/01/2011   2400 Yorkmont Rd Charlotte 6 28217 18 NC 7220-7229 8 Food Services 8 0 0           9050 W WASHINGTON BLVD CULVER CITY, CA 90232
40 0145700-01-999 Koledo Patricia S Vitalsigns 801 Middlefield Rd 11 Palo+alto 11 CA 1 94301 21 04/15/1984   04/02/1999   801 Middlefield Rd #11 Palo Alto 7 94301 19 CA 6100-6299 4 Private Education and Health Services 4 0 0           801 MIDDLEFIELD RD PALO ALTO, CA 94301 (37.44816, -122.152714)
53 0047749-07-001 Recology San Francisco Recology San Francisco 94 Pier 94 San+francisco 8 CA 1 94124 8 10/01/1968   01/01/2013   250 Executive Park Blvd Suite 2100 San Francisco 1 94134 23 CA     0 0           94 PIER San Francisco, CA 94124 (37.793776, -122.392656)
57 0082044-01-999 Tera-Lite Inc Tera-Lite Inc 1631 So. 10th St Brisbane+q4068 3   0 5 08/01/1974   08/01/1974   1631 So 10th St San Jose 10 95112 25 CA 2300-2399 6 Construction 6 0 0           1631 SO 10TH ST 00000 (38.276861, -104.581499)
59 0150975-01-999 Dulberg Bernard M Bernies Repairs 2130 Rosewood Dr Brisbane+q4068 3   0 5 05/02/1985   05/02/1985   2130 Rosewood Dr San Bruno 12 94066 27 CA 2300-2399 6 Construction 6 0 0           2130 ROSEWOOD DR 00000 (34.977529, -81.008222)
64 0025733-01-092 San Francisco Parking Inc City Park 1600 Egbert Ave San+francisco 8 CA 1 94124 8 10/01/1968 12/31/2015 08/12/2011 08/31/2014         8100-8139 5 Certain Services 5 0 0           1600 EGBERT AVE San Francisco, CA 94124
69 0152271-01-999 Decisionone Corp. Decisionone Inc. Po 3004 Frazer Pa Brisbane+q4068 3   0 5 01/29/1985   01/29/1985   426 W Lancaster Ave Devon 13 19333 29 PA 8100-8139 5 Certain Services 5 0 0            
72 0099397-01-001 Wong Louis K C Dot Printing & Stationery 828 Stockton St San Francisco 1 CA 1 94108 9 09/22/1976   09/22/1976 12/07/2015 828 Stockton St San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           828 STOCKTON ST San Francisco, CA 94108 (37.793485, -122.407792)
79 0099472-03-999 Hardwoods Uslp Hardwoods Inc Northern Califor 5621 Skylane Blvd Livermore 12 CA 1 94550 27 06/25/1998   06/25/1998   Po Box 157 Blaine 14 98231 30 WA 4200-4299 7 Wholesale Trade 7 0 0           5621 SKYLANE BLVD LIVERMORE, CA 94550
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)
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)
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)
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)
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)
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)
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)
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)
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
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)
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)
206 0140642-02-001 Compleat Baldwin Brass Ctr In Belmont Hardware 115 Wisconsin San+francisco 8 CA 1 94107 22 04/21/2005   04/21/2005   940 El Camino Real Belmont 30 94002 55 CA 4400-4599 3 Retail Trade 3 0 0           115 WISCONSIN San Francisco, CA 94107 (37.766007, -122.39977)
208 0083973-01-001 Wong James Kay Dds Inc Apc Wong James Kay Dds Inc 644 Broadway St 403b San+francisco 8 CA 1 94133 11 08/08/1974 06/27/2017 08/08/1974 06/27/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           644 BROADWAY ST San Francisco, CA 94133 (37.797724, -122.40782)
216 0008450-38-001 Sutter West Bay Hospitals California Pacific Med Ctr 475 Brannan St San Francisco 1 CA 1 94107 22 06/01/1965   01/01/2009   Po Box 7999 San Francisco 1 94120 54 CA 6100-6299 4 Private Education and Health Services 4 0 0           475 BRANNAN ST San Francisco, CA 94107 (37.778746, -122.396002)
245 0071475-03-001 Wedbush Morgan Securities Inc Wedbush Securities Inc 2 Embarcadero Ctr 600 San+francisco 8 CA 1 94111 35 01/01/1971   12/01/2013   1000 Wilshire Blvd Los Angeles 3 90017 51 CA 5210-5239 11 Financial Services 11 0 0           2 EMBARCADERO CTR San Francisco, CA 94111 (37.794812, -122.398499)
247 0181498-03-999 Drayer Charles B Signs Of All Kind 11573 Bodega Hwy Sebastopol 17 CA 1 95472 38 02/20/2008 01/01/2015 02/20/2008 01/01/2015             0 0           11573 BODEGA HWY SEBASTOPOL, CA 95472 (38.381858, -122.89415)
252 0026636-02-999 Union Pacific Rail Company Union Pacific Rail Company 1416 Dodge St 738 Omaha 18 NE 2 68179 39 10/01/1968   10/02/1968   1400 Douglas Street Stop #1730 Omaha 37 68179 63 NE 4800-4999 12 Transportation and Warehousing 12 0 0           1416 DODGE ST OMAHA, NE 68179 (41.259701, -95.935279)
253 0182193-01-999 Muncie Reclamation And Supply Company Muncie Reclamation And Supply Co 3720 S Madison St Brisbane+q4068 3   0 5 01/01/1988   01/01/1988   3720 South Madison St Muncie 38 47302 64 IN     0 0           3720 S MADISON ST 00000 (40.159438, -85.381701)
254 0071494-01-001 Soker Donald Soker Don Contemporary Art 49 Geary St #418 San+francisco 8 CA 1 94108 9 05/24/1972   01/15/1998 01/13/2015 2180 Bryant St Ste 205 San Francisco 1 94110 37 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           49 GEARY ST San Francisco, CA 94108 (37.787863, -122.40425)
262 0183884-02-999 Micro Motion Inc Micro Motion Inc 7070 Winchester Cir Boulder 19 CO 3 80301 40 01/01/1994   01/01/1994   7070 Winchester Cir Boulder 39 80301 65 CO     0 0           7070 WINCHESTER CIR BOULDER, CO 80301 (40.077338, -105.192054)
273 0049108-01-002 Chen Erwin/chen Walter/g&b Llc Waverly Grant Properties 342 Grant Ave San Francisco 1 CA 1 94108 9 01/01/1991   09/19/1998   3133 Geary Blvd San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           342 GRANT AVE San Francisco, CA 94108 (37.790316, -122.405517)
287 0049231-03-999 Towill Inc Towill Inc 2300 Clayton Rd 1200 Concord 20 CA 1 94520 41 04/01/2013   04/01/2013   2300 Clayton Road 1200 Concord 42 94520 68 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2300 CLAYTON RD CONCORD, CA 94520 (37.975834, -122.030402)
300 0026883-05-014 Chevron Texaco Corp Chevron 1288 19th Ave San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           1288 19TH AVE San Francisco, CA 94122 (37.763958, -122.477158)
310 0026883-05-018 Chevron Texaco Corp Chevron 1000 Harrison St San Francisco 1 CA 1 94103 25 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           1000 HARRISON ST San Francisco, CA 94103 (37.777027, -122.4044)
312 0015442-03-001 Kennedy Van & Storage Inc Kennedy Van & Storage 2015 Mckinnon St San Francisco 1 CA 1 94124 8 10/01/1968   07/01/1998   2015 Mckinnon St San Francisco 1 94124 6 CA 4800-4999 12 Transportation and Warehousing 12 0 0 D32 Storage Of Combustible Materials (High-Piled)       2015 MCKINNON ST San Francisco, CA 94124 (37.740278, -122.397048)
322 0140949-01-999 Rb Roofing Co Inc Rb Roofing Co Inc 434 N Canal St 16 S+san+fran 9 CA 1 94080 17 05/01/1983   06/27/2007   434 N Canal St Ste 16 S San Francisco 43 94080 13 CA 2300-2399 6 Construction 6 0 0           434 N CANAL ST S SAN FRAN, CA 94080 (37.651174, -122.415907)
326 0099797-04-001 Hoshiyama Daniel S 1418 La Playa Apts 1418 Laplaya St San+francisco 8 CA 1 94122 19 02/02/1976   05/20/1976   1436 Moraga St San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1418 LAPLAYA ST San Francisco, CA 94122 (37.759888, -122.509107)
345 0192000-01-999 Invacare Corp Invacare Corp 13220 Orden Dr Santa+fe+springs 21 CA 1 90670 43 09/01/1989   09/01/1989   One Invacare Way Elyria 45 44035 72 OH 3100-3399 10 Manufacturing 10 0 0           13220 ORDEN DR SANTA FE SPRINGS, CA 90670 (33.911742, -118.048956)
347 0040306-03-001 Chan David David & Pauline Chan 2240 Northpoint St San Francisco 1 CA 1 94123 3 10/01/1968 07/21/2016 02/01/2005 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2240 NORTHPOINT ST San Francisco, CA 94123 (37.802665, -122.444224)
348 0071960-01-001 Yang Mary W 300 Anza Vista Apartments 300 Anza St San Francisco 1 CA 1 94118 6 08/01/1971   08/01/1971   1171 Pacific Av San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           300 ANZA ST San Francisco, CA 94118 (37.780758, -122.449968)
349 0026883-17-001 Chevron Texaco Corp Chevron 1000 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   01/31/1977   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           1000 HARRISON ST San Francisco, CA 94107 (37.777027, -122.4044)
350 0192511-01-999 Subtronic Corp Subtronic Corp 2099c Arnold Ind Way Concord 20 CA 1 94520 41 01/01/1984   01/01/1984   5031 Blum Rd 2 Martinez 46 94553 73 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2099C ARNOLD IND WAY CONCORD, CA 94520
353 0040306-04-001 Chan David David Chan 2240 Northpoint St San+francisco 8 CA 1 94123 3 10/01/1968 07/21/2016 02/01/2005 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2240 NORTHPOINT ST San Francisco, CA 94123 (37.802665, -122.444224)
354 0141027-03-999 Grundy Michael W Grundy Construction Co 370 Channing Wy 27 San+rafael 22 CA 1 94901 44 06/18/2001 12/31/2014 09/16/2008 12/31/2014         2300-2399 6 Construction 6 0 0           370 CHANNING WY SAN RAFAEL, CA 94901 (38.011831, -122.53754)
356 0193844-02-999 Sears Roebuck & Co Great Indoors The 1822 A East Route 66 212 Glendora 23 CA 1 91740 45 01/01/1990   10/14/2005   3333 Beverly Rd Hoffman Estates 47 60179 74 IL     0 0           1822 A EAST ROUTE GLENDORA, CA 91740 (34.128664, -117.830064)
370 0026883-26-001 Chevron Texaco Corp Chevron Corporation 345 California St San Francisco 1 CA 1 94104 1 10/01/1968   01/01/2009   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           345 CALIFORNIA ST San Francisco, CA 94104 (37.793146, -122.400532)
378 0040354-01-001 Lee Richard & Kit Ngar 431 Arguello Apts 431 Arguello Blvd San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968 08/10/2017 661 Arguello Blvd San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           431 ARGUELLO BLVD San Francisco, CA 94118 (37.78256, -122.458973)
383 0026883-27-001 Chevron Texaco Corp Chevron Tci Inc 345 California St San Francisco 1 CA 1 94104 1 10/01/1968   01/01/2009   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           345 CALIFORNIA ST San Francisco, CA 94104 (37.793146, -122.400532)
392 0026883-28-001 Chevron Texaco Corp Chevron Envergy Solutions L.p. 345 California St San Francisco 1 CA 1 94104 1 10/01/1968   01/01/2009   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           345 CALIFORNIA ST San Francisco, CA 94104 (37.793146, -122.400532)
396 0026883-29-001 Chevron Texaco Corp Chevron Business & Real Estate 345 California St San Francisco 1 CA 1 94104 1 10/01/1968   01/01/2009   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           345 CALIFORNIA ST San Francisco, CA 94104 (37.793146, -122.400532)
398 0026883-32-001 Chevron Texaco Corp Chevron Products Company 345 California St San Francisco 1 CA 1 94104 1 10/01/1968   01/01/2012   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           345 CALIFORNIA ST San Francisco, CA 94104 (37.793146, -122.400532)
401 0049323-06-999 Iron Mountain Inform Mgt Inc Iron Mountain Info Mgmt Inc 336 Oyster Point Blvd     94099 46 01/15/1998   01/01/2010   1 Federal St 7th Fl Boston 50 02110 79 MA 4800-4999 12 Transportation and Warehousing 12 0 0           336 OYSTER POINT BLVD 94099 (37.662455, -122.386587)
418 0084649-02-999 Robert S Ferretti Md Robert S Ferretti Md Inc 49 Southridge Dr Belvedere 24 CA 1 94920 47 07/01/2010   07/01/2010   49 Southridge Rd W Tiburon 52 94920 82 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           49 SOUTHRIDGE DR BELVEDERE, CA 94920 (37.89794, -122.494475)
419 0026883-33-001 Chevron Texaco Corp Chevron Services Co 345 California St San Francisco 1 CA 1 94104 1 10/01/1968   01/01/2012   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0           345 CALIFORNIA ST San Francisco, CA 94104 (37.793146, -122.400532)
425 0021688-04-999 Pac Utilities Supply Co Pacific Utilites Supply Co 1140 Willow Pass Ct Concord 20 CA 1 94520 41 01/01/1998   04/01/2011   1140 Willow Pass Ct Concord 42 94520 68 CA 5600-5699 16 Administrative and Support Services 16 0 0           1140 WILLOW PASS CT CONCORD, CA 94520
428 0021688-05-999 Pac Utilities Supply Co Pacific Utilites Supply Co 1140 Willow Pass Ct Concord 20 CA 1 94520 41 01/01/1998   04/01/2011   1140 Willow Pass Ct Concord 42 94520 68 CA 5600-5699 16 Administrative and Support Services 16 0 0           1140 WILLOW PASS CT CONCORD, CA 94520
430 0012175-03-999 Hanson Bridgett Llp Hanson Bridgett Llp 80 E. Sir Francis Drake Blvd 3e Larkspur 25 CA 1 94939 48 10/01/1968   01/01/2003   425 Market St, 26th Fl San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           80 E SIR FRANCIS DRAKE BLVD LARKSPUR, CA 94939 (37.946276, -122.51052)
431 0084652-02-999 B & B Landscape Cont Inc B & B Landscape Cont Inc 450 Phelan Ave San+jose 26 CA 1 95112 49 08/24/2005   08/24/2005   Po Box 1127 Pebble Beach 53 93953 84 CA     0 0           450 PHELAN AVE SAN JOSE, CA 95112 (37.315997, -121.86199)
434 0127001-02-999 Calabresi Robert L Rlc Construction 1052 Monterey Ave Foster+city 27 CA 1 94404 30 10/10/1980 04/01/2013 10/01/1993 04/01/2013             0 0           1052 MONTEREY AVE FOSTER CITY, CA 94404 (37.539708, -122.269505)
448 0012175-05-999 Hanson Bridgett Llp Hanson Bridgett Llp 500 Capitol Mall 1500 Sacramento 4 CA 1 95814 50 10/01/1968   06/01/2009   425 Market St, 26th Fl San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           500 CAPITOL MALL SACRAMENTO, CA 95814 (38.578581, -121.501266)
450 0141155-01-001 Philip Bellber & Isabel Pak Cha Cha Cha Restaurant 1801 Haight St San Francisco 1 CA 1 94117 33 05/19/1983   05/19/1983   949 Ashbury St B San Francisco 1 94117 80 CA 7220-7229 8 Food Services 8 0 0 H26 Restaurant Greater Than 2,000 Sqft       1801 HAIGHT ST San Francisco, CA 94117 (37.769337, -122.452059)
456 0084831-01-001 Land Sea & Air Corp Land Sea & Air Corp 5 3rd St #608 San+francisco 8 CA 1 94103 25 04/01/1974   02/12/2002 01/31/2015 2040 Franklin St Apt 605 San Francisco 1 94109 7 CA     0 0           5 3RD ST San Francisco, CA 94103 (37.787454, -122.403428)
459 0012175-06-999 Hanson Bridgett Llp Hanson Bridgett Llp 950 Tower Lane 925 Foster+city 27 CA 1 94404 30 10/01/1968   06/16/2008   425 Market St, 26th Fl San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           950 TOWER LANE FOSTER CITY, CA 94404 (37.558472, -122.276617)
464 0027090-01-001 Stanley Produce Co Inc Stanley Produce Co Inc 1975 Jerrold Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   1975 Jerrold Av San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0 H15 Wholesale Food Markets W/retail (Produce)       1975 JERROLD AVE San Francisco, CA 94124 (37.742397, -122.396038)
468 0027235-01-001 Stein H Thomas Stein H Thomas Md 2186 Geary Blvd #211 San+francisco 8 CA 1 94115 4 10/01/1968 07/31/2014 10/01/1968 07/31/2014             0 0           2186 GEARY BLVD San Francisco, CA 94115 (37.783404, -122.439253)
472 0084989-02-002 Kwong Lam Po & Shirley Man Hing Market 1368 9th Ave San Francisco 1 CA 1 94122 19 10/15/1974   07/10/1980   1368 9th Ave San Francisco 1 94122 15 CA     0 0 H73 Deemed Approved Off-Sale Alcohol Use       1368 9TH AVE San Francisco, CA 94122 (37.762779, -122.466219)
473 0127095-02-001 22 Battery St Inc 501 Taylor St Apartments 501 Taylor St San Francisco 1 CA 1 94102 16 01/01/1980   12/23/1987 12/31/2013 98 Battery Street # 600 San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           501 TAYLOR ST San Francisco, CA 94102 (37.787234, -122.411578)
476 0027243-01-001 Steinberg Stanley A Steinberg Stanley A 2420 Sutter St San Francisco 1 CA 1 94115 4 10/01/1968   10/01/1968   9 Funston Ave San Francisco 1 94129 85 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2420 SUTTER ST San Francisco, CA 94115 (37.785164, -122.440535)
477 0027256-01-999 Steiny & Co Inc Steiny & Co Inc 27 Sheridan St Mexico 28   0 5 10/01/1968 12/31/2014 10/01/1968 12/31/2014             0 0           27 SHERIDAN ST MEXICO 00000
479 0049441-01-001 Tarantino Dominic Etal 1630 Polk Rental 1630 Polk St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1664 North Point St San Francisco 1 94123 48 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1630 POLK ST San Francisco, CA 94109 (37.791969, -122.420979)
483 0027344-01-001 Stewart And Patten Co Llc Stewart & Patten Co Llc One Post St 850 San+francisco 8 CA 1 94104 1 10/01/1968   01/08/2008   One Post Street #850 San Francisco 1 94104 1 CA 5210-5239 11 Financial Services 11 0 0           ONE POST ST San Francisco, CA 94104
489 0207141-01-999 Certified Folder Disp Svc Inc Certified Folder Disp Svc Inc 1120 Joshua Way Mexico 28   0 5 01/01/1991   01/01/1991   1120 Joshua Wy Vista 55 92081 88 CA     0 0           1120 JOSHUA WAY MEXICO 00000
492 0113376-01-001 Colotti Linda M Bay Blossoms Pier 70 San+francisco 8 CA 1 94107 22 04/01/1991 06/28/2016 01/02/2000 06/28/2016             0 0           70 SAN FRANCISCO, CA 94107
496 0113431-01-001 Bobier Elizabeth A Shell Cellar The Pier 39 San Francisco 1 CA 1 94133 11 09/01/1978   09/01/1978   39 Pier Ste 232 San Francisco 1 94133 9 CA 4400-4599 3 Retail Trade 3 0 0           39 San Francisco, CA 94133 (37.799415, -122.406131)
512 0300955-01-999 Kapsiak Kathryn Catering By Kass Kapsiak 2240 Crestmore Dr San+bruno 6 CA 1 94066 13 01/31/1996   01/31/1996   2240 Crestmoor Dr San Bruno 12 94066 27 CA 7220-7229 8 Food Services 8 0 0           2240 CRESTMORE DR SAN BRUNO, CA 94066 (37.62487, -122.432912)
516 0113559-01-001 Mixed Media Calif Corp China Basin Video Works 12 Geary St #402 San+francisco 8 CA 1 94108 9 04/01/1978   11/01/1999   271 Del Mesa Carmel 57 93923 90 CA     0 0           12 GEARY ST San Francisco, CA 94108 (37.787944, -122.403645)
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)
539 0034437-01-001 Northwestern Title Co Of Sf 1556 Laplaya Apts 1556 Laplaya St San+francisco 8 CA 1 94122 19 10/01/1968   10/01/1968   4444 Geary Bl #105 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           1556 LAPLAYA ST San Francisco, CA 94122 (37.758055, -122.508994)
543 0027543-01-001 Sullivan Alice Phelan Corp Sullivan Alice Phelan Corp 255 Sutter St San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   490 Post St, Ste 1632 San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           255 SUTTER ST San Francisco, CA 94108 (37.789695, -122.404791)
544 0141346-02-999 Sutti John & Associates Inc John Sutti & Associates Inc 700 Airport Blvd 110 Hillsborough 30 CA 1 94010 52 05/01/1983   10/11/2004   700 Airport Blvd #260 Burlingame 60 94010 75 CA 2300-2399 6 Construction 6 0 0           700 AIRPORT BLVD HILLSBOROUGH, CA 94010 (37.589716, -122.347675)
545 0085521-02-999 Canon Usa Inc Canon Usa Inc 1 Canon Park Melville 31 NY 4 11747 53 11/01/1974   02/19/2013   One One Canon Park Melville 61 11747 94 NY 4200-4299 5300-5399 8100-8139 18 Multiple 13 0 0           1 CANON PARK MELVILLE, NY 11747 (40.77798, -73.424998)
553 0141346-03-001 Sutti John & Associates Inc John Sutti & Associates Inc 782 Arquello St San+francisco 8 CA 1 94118 6 05/01/1983   02/13/2010   700 Airport Blvd #260 Burlingame 60 94010 75 CA 2300-2399 6 Construction 6 0 0           782 ARQUELLO ST San Francisco, CA 94118
557 0049532-02-999 Peletz C M Co Peletz C M Co 2021 The Alameda #350 San+jose 26 CA 1 95126 54 05/12/1997   05/12/1997   2021 The Alameda #350 San Jose 10 95126 95 CA 2300-2399 6 Construction 6 0 0           2021 THE SAN JOSE, CA 95126
562 0049532-03-001 Peletz C M Co Peletz C M Co 55 New Montgomery St 624 San Francisco 1 CA 1 94105 7 05/12/1997   01/01/2004 09/01/2014 2021 The Alameda #350 San Jose 10 95126 95 CA 2300-2399 6 Construction 6 0 0           55 NEW MONTGOMERY ST San Francisco, CA 94105 (37.787833, -122.400946)
570 0113606-01-001 Camisa Madeline L Scribes Of The City P O Box 29382 San+francisco 8 CA 1 94129 42 07/01/1978   07/01/1978   1270 Chestnut St #6 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0            
572 0012175-07-999 Hanson Bridgett Llp Hanson Bridgett Llp 1676 North California Blvd 620 Walnut+creek 32 CA 1 94596 55 10/01/1968   08/01/2011   425 Market St, 26th Fl San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1676 NORTH CALIFORNIA BLVD WALNUT CREEK, CA 94596 (37.90235, -122.064645)
575 0304996-00-000 Milarepa Foundation Inc Milarepa Foundation Inc 1880 Century Park E 16th Fl Los+angeles 33 CA 1 90067 56 04/01/1995 09/21/2004 04/01/1995 09/21/2004             0 0           1880 CENTURY PARK E LOS ANGELES, CA 90067 (34.061482, -118.414635)
588 0085798-02-999 Bay Area Concretes Inc Bay Area Concretes Inc 1306 Stealth St Livermore 12 CA 1 94551 57 10/11/1974   04/24/2006   5637 La Ribera St Ste B Livermore 63 94550 98 CA 2300-2399 6 Construction 6 0 0           1306 STEALTH ST LIVERMORE, CA 94551 (37.691942, -121.797482)
599 0085798-03-999 Bay Area Concretes Inc Bay Area Concretes Inc 5637 La Ribera St B Livermore 12 CA 1 94550 27 10/11/1974   10/01/2013   5637 La Ribera St Ste B Livermore 63 94550 98 CA 2300-2399 6 Construction 6 0 0           5637 LA RIBERA ST B LIVERMORE, CA 94550 (37.698568, -121.723838)
610 0113792-01-003 British Airways Plc British Airways 100 Upper Loop Rd 1-5-064 San+francisco 8 CA 1 94128 59 01/01/1973   10/01/2009   2 Park Ave 1100 Ste New York 49 10016 100 NY 4800-4999 12 Transportation and Warehousing 12 0 0           100 UPPER LOOP RD San Francisco, CA 94128

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