home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Street Address

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
25244 0304452-04-999 Stc Netcom Inc Stc Netcom   Fontana 175 CA 1 92337 667 02/24/2011   02/24/2011   11611 Industry Av Fontana 360 92337 1137 CA 2300-2399 6 Construction 6 0 0            
165538 1081184-07-161 Calif Building Performance Con Calif Building Performance Con   San+francisco 8 CA 1 94509 245 05/21/2002   05/21/2002   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
212232 1001295-07-141 Law Office Of Scott A Sommer Law Office Of Scott A Sommer         07/18/2014 03/31/2016 07/18/2014 03/31/2016             0 0            
214396 0420834-00-000 Discovery Engine Corp Discovery Engine Corp   San Francisco 1 CA 1 94123 3 05/24/2007 05/24/2013 05/24/2007 05/24/2013             0 0            
692 0127494-02-002 Yi Frank C Broadway Deluxe Hotel #2 Nottingham Place San+francisco 8 CA 1 94133 11 01/09/1981 02/05/2014 01/01/2010 02/05/2014             0 0           2 NOTTINGHAM PLACE San Francisco, CA 94133 (37.79763, -122.404873)
8757 0069001-02-001 Odonnell Martha B % Owen P O'donnell % Owen P O'donnell San+francisco 8 CA 1 94117 33 01/01/1972   09/01/1999   705 Scott St San Francisco 1 94117 80 CA 7210-7219 9 Accommodations 9 0 0           OWEN P O'DONNELL San Francisco, CA 94117 (37.770274, -122.443224)
29542 0324807-01-001 Eslick Susan K Susan Eslick Designs * Hunters Point Shipyard 401 San+francisco 8 CA 1 94124 8 11/20/2000 01/11/2016 11/20/2000 01/11/2016             0 0           401 San Francisco, CA 94124 (37.764057, -122.405445)
31922 0350514-02-999 Camper Atlantic Corporation Camper Atlantic Corp - Bostonnychicagolasan Jose New+york 48 NY 4 10012 799 12/10/2001   12/31/2004   221 Bowery St Ground Fl New York 49 10002 331 NY 4400-4599 3 Retail Trade 3 0 0           - BOSTONNYCHICAGOLASAN JOSE NEW YORK, NY 10012 (40.725677, -73.997783)
173509 1099271-08-161 Wahab Afzal S.f . San+francisco 8 CA 1 94103 25 06/01/2016   06/01/2016   Po Box 1341 El Cerrito 15 94530 31 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
12261 0075477-05-001 Macor Inc Channel St . Channel St San+francisco 8 CA 1 94107 22 05/01/1972   05/01/1972   50 California St Ste 2400 San Francisco 1 94111 11 CA     0 0           CHANNEL ST San Francisco, CA 94107 (37.765747, -122.395824)
10159 0097634-01-001 Rescino Frank Lovely Martha Sportfishing . Fishermans Wharf San+francisco 8 CA 1 94133 11 01/01/1969   01/01/1969   218 Hazelwood Dr S San Fran 29 94080 13 CA 4800-4999 7100-7199 62 Multiple 13 0 0           FISHERMANS WHARF San Francisco, CA 94133 (37.801827, -122.411027)
80104 0454977-02-001 Adams Julian L Sports Apparel . Jamestown Bl-Harney Way San+francisco 8 CA 1 94124 8 01/01/2011   01/09/2013   2351 Taylor St San Francisco 1 94133 9 CA     0 0           JAMESTOWN BL-HARNEY WAY San Francisco, CA 94124 (37.732716, -122.388738)
171774 1095705-08-161 Donald Barron 0 0 0 1851 CA 1 94603 182 02/02/2016   02/02/2016   Po Box 6652 Oakland 27 94603 372 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
177068 1106754-08-161 Hashmat Rasool Hashmat Rasool 0 0 1851 CA 1 94102 16 04/01/2016   04/01/2016   4500 Natomas Central Dr 413 Apt Sacramento 231 95834 846 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
180196 1113624-08-161 Cara Baker Screwed Over Uber Driver 0 Many 2010 CA 1 0 5 08/11/2016   08/11/2016   1445 Harrison St 461 Apt Oakland 27 94612 77 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
224826 1094989-08-161 Jawed Fayzi Jawed Fayzi 0 0 1851 CA 1 94103 25 05/25/2015   05/25/2015   1200 Plumas St 34 Apt Yuba City 357 95991 547 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
177264 1107160-08-161 Hassibullah Rahmani O 0 0 O 189 CA 1 94108 9 04/01/2016   04/01/2016   1483 165th Ave 115 Apt San Leandro 25 94578 562 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
98222 0475902-07-001 Ccsf Recreational Park Dept. M.l.king Swimming Pool 0 03rd St & Carroll Ave San+francisco 8 CA 1 94124 8 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 03RD ST & CARROLL AVE San Francisco, CA 94124
220776 0475902-06-001 Ccsf Recreational Park Dept. Mission Swimming Pool 0 19th & Linda San+francisco 8 CA 1 94110 18 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H57 Swimming Pools (Six-Month)       0 19TH LINDA San Francisco, CA 94110
220774 0475902-04-001 Ccsf Recreational Park Dept. Sava Swimming Pool 0 19th & Wawona San+francisco 8 CA 1 94116 23 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 19TH WAWONA San Francisco, CA 94116
98060 0475902-09-001 Ccsf Recreational Park Dept. Garfiel Swimming Pool 0 26th & Harrison San+francisco 8 CA 1 94110 18 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 26TH HARRISON San Francisco, CA 94110
92992 0470382-02-001 Luke Patrick E Zest Bakery 0 3rd & Mission St San+francisco 8 CA 1 94103 25 06/25/2012 11/01/2015 04/01/2014 11/01/2015             0 0           0 3RD & MISSION ST San Francisco, CA 94103
11985 0166858-01-001 Bayline Construction Inc Bayline Construction Inc 0 99 El Sobrante Ca San+francisco 8 CA 1 94102 16 04/24/1987   07/31/1992   369-B 3rd Street, Unit 610 San Rafael 20 94901 38 CA 2300-2399 6 Construction 6 0 0           0 99 EL SOBRANTE CA San Francisco, CA 94102
220775 0475902-05-001 Ccsf Recreational Park Dept. Rossi Swimming Pool 0 Arguello & Anza San+francisco 8 CA 1 94118 6 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 ARGUELLO ANZA San Francisco, CA 94118
21833 0185220-01-001 Kogan Steve J Steve Sun Co 0 Beach St San+francisco 8 CA 1 94133 11 02/27/1989   02/27/1989   3122 Wawona St San Francisco 1 94116 45 CA     0 0           0 BEACH ST San Francisco, CA 94133
216317 0317494-03-001 West Coast Parking Inc West Coast Parking 0 Broadway & Davis (480-23) San Francisco 1 CA 1 94111 35 07/01/1998   07/01/1998   400 Valley Way Milpitas 264 95035 718 CA     1 0     3 1 Russian Hill 5   0 BROADWAY San Francisco, CA 94111
8602 0047617-01-999 Ecolab Center Inc Ecolab Inc 0 Escolab Center St Paul Mexico 28   0 5 10/01/1968   10/01/1968   370 Wabasha St N St Paul 284 55102 522 MN 4200-4299 4400-4599 13 Multiple 13 0 0           0 ESCOLAB CENTER ST PAUL MEXICO 00000 (40.684767, -76.194849)
14068 0187651-01-001 Mark S. Mandzik Mandzik Mark S 0 Fishermans Wharf San+francisco 8 CA 1 94133 11 05/01/1989   05/01/1989   Po Box 534 Laytonville 484 95454 775 CA 4400-4599 3 Retail Trade 3 0 0           0 FISHERMANS WHARF San Francisco, CA 94133
77265 0185482-01-001 Kim Sun Sik Kims-T-Shirts 0 Fishermanswharf San+francisco 8 CA 1 94133 11 01/01/1989 12/31/2013 01/01/1989 12/31/2013             0 0           0 FISHERMANSWHARF San Francisco, CA 94133
10355 0025733-61-002 San Francisco Parking Inc Fort Mason 0 Fort Mason (Special Event) San+francisco 8 CA 1 94105 7 10/01/1968 12/31/2015 07/01/2007 02/28/2013         8100-8139 5 Certain Services 5 0 0           0 FORT MASON (SPECIAL EVENT) San Francisco, CA 94105
93118 0470516-01-001 National Fitness Campaign Llc National Fitness Campaign Llc 0 Fort Mason Ctr B330 San+francisco 8 CA 1 94123 3 06/10/2012   06/10/2012   1740 Kearny Street San Francisco 1 94133 9 CA     0 0           0 FORT MASON CTR San Francisco, CA 94123
98059 0475902-08-001 Ccsf Recreational Park Dept. Hamilton Swimming Pool 0 Geary & Steiner San+francisco 8 CA 1 94115 4 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 GEARY STEINER San Francisco, CA 94115
90056 0467061-01-001 Tinman Merchandising Llc Tinman Merchandising Llc 0 Golden Gate Park San+francisco 8 CA 1 94102 16 08/22/2008   08/22/2008   2490 Arnold Industrial Way #A Concord 42 94520 68 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           0 GOLDEN GATE PARK San Francisco, CA 94102
89965 0466976-01-001 Ggp Tennis Partners Llc Tennis Academy Golden Gate Prk 0 Golden Gate Park Tennis Courts San+francisco 8 CA 1 94118 6 02/19/2012 04/18/2013 02/19/2012 04/18/2013             0 0           0 GOLDEN GATE PARK TENNIS COURTS San Francisco, CA 94118
18543 0304608-02-001 Gilbane Federal Innovative Technical Solutions Inc 0 Hunters Point San+francisco 8 CA 1 94124 8 03/11/1997   01/01/2009   7 Jackson Walkway Providence 584 02903 937 RI 2300-2399 6 Construction 6 0 0           0 HUNTERS POINT San Francisco, CA 94124
45429 0385570-03-002 Taste Inc Vino Volo 0 N. Mcdonnell Rd Terminal 2 San+francisco 8 CA 1 94128 59 10/01/2004   04/11/2011   360 22nd St Ste 640 Oakland 27 94612 77 CA 7220-7229 8 Food Services 8 0 0 H73 Deemed Approved Off-Sale Alcohol Use       0 N MCDONNELL RD San Francisco, CA 94128
114586 0918299-01-006 Sf Baseball Associates Llc San Francisco Giants 0 Pavilion Dugout San+francisco 8 CA 1 94107 22 01/13/1993   01/01/2000 01/01/2016 24 Willie Mays Plz San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           0 PAVILION DUGOUT San Francisco, CA 94107
24189 0329140-18-001 Imperial Parking (Us) Llc Imperial Parking Inc 0 Pier 48 San+francisco 8 CA 1 94105 7 08/18/1999   06/01/2006   1740 Cesar Chavez St # 2w San Francisco 1 94124 6 CA 4400-4599 3 Retail Trade 3 1 0           0 PIER San Francisco, CA 94105
84361 0459930-02-001 Lrico Services Llc Lrico Services Llc 0 Pier 50 Shed B San+francisco 8 CA 1 94158 58 07/06/2010 01/01/2017 07/06/2010 01/01/2017         5210-5239 11 Financial Services 11 0 0           0 PIER SHED B San Francisco, CA 94158
83101 0458359-01-002 Lab Zero Innovations Inc Lab Zero Innovations Inc 0 Pier 9 The Embarcardero 115 San+francisco 8 CA 1 94111 35 01/02/2008   01/01/2011 10/31/2015 77 Battery St 400 Ste San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           0 PIER San Francisco, CA 94111
39937 0379915-37-001 Ambrose Employer Group Llc Aisling Capital, Llc 0 Po Box 330280 San+francisco 8 CA 1 94133 11 01/01/2004 12/31/2013 05/31/2011 12/31/2013             0 0           0 PO San Francisco, CA 94133
10422 0152801-05-999 Federal Express Corp Federal Express 0 San Francisco Int'l Airport Mexico 28   0 5 10/01/1978   01/01/1991   1000 Fedex Dr. Pittsburgh 377 15108 628 PA     0 0           0 SAN FRANCISCO INT'L AIRPORT MEXICO 00000 (45.634262, -87.992225)
81374 0456571-04-001 Avila Retail Devel & Mgmt Llc Greetings From Sf Terminal 2 0 San Francisco Intl Airport San+francisco 8 CA 1 94128 59 03/15/2011   01/01/2013   5001 Ellison Ne Albuquerque 182 87109 2109 NM 4400-4599 3 Retail Trade 3 0 0           0 SAN FRANCISCO INTL AIRPORT San Francisco, CA 94128
98061 0475902-10-001 Ccsf Recreational Park Dept. Balboa Swimming Pool 0 San Jose & Havelock San+francisco 8 CA 1 94112 28 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 SAN JOSE & HAVELOCK San Francisco, CA 94112
209897 0446093-03-001 Liu Yuan Jie Qq Gems 0 Stockton St/post St San+francisco 8 CA 1 94115 4 02/20/2010   06/02/2014 11/26/2014 2135 Naomi Place Santa Rosa 73 95403 153 CA 4200-4299 7 Wholesale Trade 7 0 0           0 STOCKTON ST POST ST San Francisco, CA 94115
22519 0322098-05-001 Siemens Industry Inc San Francisco Intl Airport 0 Terminal 2 Lower Level Ct Yard 2 San+francisco 8 CA 1 94128 59 01/01/1999   01/01/2010   Po Box 80600 Indianapolis 105 46280 248 IN 2300-2399 6 Construction 6 0 0           0 TERMINAL 2 LOWER LEVEL CT San Francisco, CA 94128
98062 0475902-11-001 Ccsf Recreational Park Dept. Coffman Swimming Pool 0 Visitacion & Hahn San+francisco 8 CA 1 94134 26 02/14/2012   09/25/2012   501 Stanyan St San Francisco 1 94117 80 CA     0 0 H56 Swimming Pools (Year-Round)       0 VISITACION HAHN San Francisco, CA 94134
78086 0452039-05-001 Zee Cooks Llc Creperie Saint Germain 0 Waller St @ Stanyan St San+francisco 8 CA 1 94117 33 08/25/2010 09/30/2016 04/02/2014 09/30/2016         7220-7229 8 Food Services 8 0 0           0 WALLER ST @ STANYAN ST San Francisco, CA 94117
4258 0043636-33-001 Pacific Bell Telephone Company Pac Bell 00 001 35 Tubbs St San Francisco 1 CA 1 94107 22 10/01/1968   01/01/2006   1010 Pine St. Rm. 7e B 02 St Louis 67 63101 294 MO 5100-5199 15 Information 15 0 0     10 4 Potrero Hill 28   00 001 35 TUBBS ST San Francisco, CA 94107
164908 1080229-07-161 The Mexican Museum The Mexican Museum 00 Fort Mason Center San+francisco 8 CA 1 94123 3 11/20/1975   11/20/1975   00 Fort Mason Center San Francisco 1 94123 48 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0            
56162 0414621-02-001 Powell Willie Keep It Moving Bbq 000 3rd & Palou Ave San+francisco 8 CA 1 94124 8 07/01/2012   07/01/2012   170 Victoria St San Francisco 1 94132 56 CA     0 0           000 3RD & PALOU AVE San Francisco, CA 94124
36513 0370388-01-001 Museo Italo Americano Museo Italo Americano 000 Fort Mason Ctr Bldg C San+francisco 8 CA 1 94123 3 12/23/1999   12/23/1999   2 Marina Blvd Fort Mason Center Bl#c San Francisco 1 94123 48 CA     0 0           000 FORT MASON CTR BLDG C San Francisco, CA 94123
24339 0302928-04-001 Dinkin Sharon J Dinkin Catering 000 Hunter's Pt Naval Shipyard Bld 110 San+francisco 8 CA 1 94124 8 01/02/2004   05/23/2005   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           000 HUNTER'S PT San Francisco, CA 94124
109511 0487542-01-001 Quinones Anna Auntie Social Designs 000 Justin Hermann Plaza San+francisco 8 CA 1 94111 35 03/03/2014   03/03/2014   3251 Mlk Jr Way #1 Oakland 27 94609 584 CA     0 0           000 JUSTIN HERMANN PLAZA San Francisco, CA 94111
220550 0471462-04-001 Thrive Cleanse Thrive Juicery 000 One Embarcadero Center San+francisco 8 CA 1 94111 35 05/01/2012   06/11/2014   2260 North Point St #6 San Francisco 1 94123 48 CA 7220-7229 8 Food Services 8 0 0 H03 Retail Mkts W/o Prep (Under 5,001)       000 ONE EMBARCADERO CENTER San Francisco, CA 94111
216974 0364719-02-001 White River Inv Partners Llc White River Investment Partnrs 000 One Maritime Plaza 2250 San+francisco 8 CA 1 94111 35 03/15/2003   10/03/2011   One Maritime Plaza #2250 San Francisco 1 94111 11 CA 5210-5239 11 Financial Services 11 0 0           000 ONE MARITIME PLAZA San Francisco, CA 94111
38689 0376525-01-001 S F Suicide Prevention Inc S F Suicide Prevention Inc. 000 Po Box #191350 San+francisco 8 CA 1 94119 391 03/26/1964   03/26/1964   Po Box #191350 San Francisco 1 94119 126 CA     0 0           000 PO San Francisco, CA 94119
98079 0475916-01-015 S F Public Utilities Comm S F Public Utilites Comm 000 Teresita Blvd & Agua Way San+francisco 8 CA 1 94127 31 02/14/2012   08/08/2013   525 Golden Gate Ave 13th Flr San Francisco 1 94102 16 CA     0 0 H60 Wells And Well Water       000 TERESITA BLVD & AGUA WAY San Francisco, CA 94127
27874 0342613-01-001 Presidio World College Presidio World College 000 The Presidio Bldg 36 Ste #120 San+francisco 8 CA 1 94129 42 03/15/1993   03/15/1993   1202 Ralston Avenue Ste 1b San Francisco 1 94129 85 CA 6100-6299 4 Private Education and Health Services 4 0 0           000 THE San Francisco, CA 94129
10744 0154535-03-001 Murphy Denis & Catherine Various Apartments 000 Various Locations San+francisco 8 CA 1 94110 18 01/01/1986   01/01/1986   1355 Valencia St San Francisco 1 94110 37 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           000 VARIOUS LOCATIONS San Francisco, CA 94110
32955 0340893-01-005 Avaya Inc Avaya Inc 000 Virtual Office San+francisco 8 CA 1 94103 25 10/01/2000   01/02/2011   211 Mt. Airy Rd Basking Ridge 412 07920 661 NJ 4200-4299 7 Wholesale Trade 7 0 0           000 VIRTUAL OFFICE San Francisco, CA 94103
105230 0483237-03-001 Miller Tiffanie Tiffanie Miller 000 West Portal Ave San+francisco 8 CA 1 94127 31 09/17/2013   03/17/2014 04/24/2014 2363 19th Ave San Francisco 1 94116 45 CA     0 0           000 WEST PORTAL AVE San Francisco, CA 94127
186498 1125580-10-161 Vera Cort Living Trust Block 0636 And Lot 037 0000 San+francisco 8 CA 1 94115 4 09/16/2014   10/28/2016   757 3rd Ave San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
19580 0309534-04-001 Kansora Thomas J Sf 49ers 2011 Season 0000 Candlestick Park San+francisco 8 CA 1 94124 8 01/01/2004   08/20/2011   369b 3rd St #240 San Rafael 20 94901 38 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           0000 CANDLESTICK PARK San Francisco, CA 94124
89387 0466271-01-002 Applebaum Bakery Llc Applebaum Bakery 0000 Clement St San+francisco 8 CA 1 94121 15 10/11/2009 11/01/2015 01/12/2014 11/01/2015             0 0           0000 CLEMENT ST San Francisco, CA 94121
34749 0365235-01-001 Hog Island Oyster Co Inc Hog Island Oyster Co 0000 Ferry Building E-3a San+francisco 8 CA 1 94105 7 04/01/2003   04/01/2003   Po Box 829 Marshall 846 94940 1402 CA 7220-7229 8 Food Services 8 0 0 H24 Restaurant Less Than 1,000 Sqft       0000 FERRY San Francisco, CA 94105
76881 0450267-06-001 Off The Grid Services Llc Off The Grid: Fort Mason Ctr 0000 Fort Mason Ctr Bldg D D290 San Francisco 1 CA 1 94123 3 06/18/2010   11/01/2011   2 Marina Fort Mason Center Blvd C370 Rm San Francisco 1 94123 48 CA 7220-7229 8 Food Services 8 0 0           0000 FORT MASON CTR San Francisco, CA 94123
76883 0450267-08-001 Off The Grid Services Llc Off The Grid: San Francisco 0000 Fort Mason Ctr Bldg D D290 San+francisco 8 CA 1 94123 3 06/18/2010   11/01/2011   2 Marina Fort Mason Center Blvd C370 Rm San Francisco 1 94123 48 CA 7220-7229 8 Food Services 8 0 0           0000 FORT MASON CTR San Francisco, CA 94123
77180 0450267-05-001 Off The Grid Services Llc Off The Grid Services Llc 0000 Fort Mason Ctr Bldg D D290 San Francisco 1 CA 1 94123 3 06/18/2010   11/01/2011   2 Marina Fort Mason Center Blvd C370 Rm San Francisco 1 94123 48 CA 7220-7229 8 Food Services 8 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids       0000 FORT MASON CTR San Francisco, CA 94123
9527 0025733-01-067 San Francisco Parking Inc City Park 0000 Golden Gate Park San+francisco 8 CA 1 94122 19 10/01/1968 12/31/2015 10/01/2005 12/31/2014         8100-8139 5 Certain Services 5 0 0           0000 GOLDEN GATE PARK San Francisco, CA 94122
209199 0396414-01-001 Ce2 Corporation Ce2 Corporation 0000 Hunters Point Shipyard San+francisco 8 CA 1 94124 8 01/01/2006 02/28/2015 01/01/2006 02/28/2015             0 0           0000 HUNTERS POINT SHIPYARD San Francisco, CA 94124
76882 0450267-07-001 Off The Grid Services Llc San Francisco Cart Project 0000 Mason Ctr Bldg D D290 San+francisco 8 CA 1 94123 3 06/18/2010   11/01/2011   2 Marina Fort Mason Center Blvd C370 Rm San Francisco 1 94123 48 CA 7220-7229 8 Food Services 8 0 0           0000 MASON CTR San Francisco, CA 94123
165821 1081523-07-161 Hunters Point Community Youth Hunters Point Community Youth 0000 Undeliverable Mail San+francisco 8 CA 1 99999 2895 04/22/1969   04/22/1969   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
168162 1085444-07-161 Think 12 Corporation Think 12 Corporation 0000 Undeliverable Mail San Francisco 1 CA 1 99999 2895 03/03/2004   03/03/2004   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
168164 1085446-07-161 Epiphany Prodctns Sonic Dance Epiphany Prodctns Sonic Dance 0000 Undeliverable Mail San Francisco 1 CA 1 99999 2895 01/01/1997   01/01/1997   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
168165 1085447-07-161 Bayview Entertainment Society Bayview Entertainment Society 0000 Undeliverable Mail San Francisco 1 CA 1 99999 2895 12/26/2008   12/26/2008   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
168166 1085448-07-161 U First Community Services U First Community Services 0000 Undeliverable Mail San Francisco 1 CA 1 99999 2895 03/25/2005   03/25/2005   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
33706 0345545-02-001 Execustay By Marriott Execustay Corp 0000 Various Locations San+francisco 8 CA 1 94102 16 05/01/2001 01/01/2013 12/01/2001 01/01/2013             0 0           0000 VARIOUS LOCATIONS San Francisco, CA 94102
34534 0364643-36-001 Sodexo America Llc Aa Admirals Club Sfo 00000 Sf Airport San+francisco 8 CA 1 94128 59 11/18/2002   07/14/2008   Po Box 352 Buffalo 726 14240 1195 NY 7220-7229 8 Food Services 8 0 0           00000 SF AIRPORT San Francisco, CA 94128
29281 0347669-01-001 Gic Real Estate Inc Gic Real Estate Inc 0001 Bush St Suite 1100 San Francisco 1 CA 1 94104 1 02/06/2001   07/28/2003   One Bush Street 1100 Suite San Francisco 1 94104 1 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   0001 BUSH ST San Francisco, CA 94104 (37.791258, -122.400152)
36388 0369988-01-001 Kuehn Allen W San Francisco Fish Company 0001 Ferry Building 31 San+francisco 8 CA 1 94111 35 09/05/2003   09/05/2003   2616 Comistas Dr Walnut Creek 4 94598 243 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft       0001 FERRY San Francisco, CA 94111
217221 0371365-01-001 The Gardener The Gardner 0001 Ferry Building N26 San+francisco 8 CA 1 94105 7 10/04/2003   10/04/2003   1025 Harrison St Berkeley 169 94710 251 CA 4400-4599 3 Retail Trade 3 0 0           0001 FERRY San Francisco, CA 94105
54512 0411504-01-999 Singh Jagpal Singh Jagpal 0005 Pacific Ave S+san+fran 9 CA 1 94080 17 01/01/2007   01/01/2007   0005 Pacific Ave San Bruno 12 94066 27 CA 4800-4999 12 Transportation and Warehousing 12 0 0           0005 PACIFIC AVE S SAN FRAN, CA 94080 (37.639657, -122.413699)
19954 0311243-02-001 Levensohn Venture Partners Llc Levensohn Venture Partners Llc 001 Embarcadero Center 29 San+francisco 8 CA 1 94111 35 07/01/1996   01/01/2012   198 Potrero Ave San Francisco 1 94103 32 CA 5210-5239 11 Financial Services 11 0 0           001 EMBARCADERO CENTER San Francisco, CA 94111 (37.794664, -122.399656)
75177 0447742-02-001 Verizon Data Services Llc Verizon Data Services Llc 001 Front St San Francisco 1 CA 1 94111 35 09/09/2008 10/01/2014 05/01/2012 10/01/2014             0 0     6 3 Financial District/South Beach 1   001 FRONT ST San Francisco, CA 94111 (37.791868, -122.398473)
44370 0390850-02-001 Mainsail Mgmt Company Llc Mainsail Mgmt Company Llc 001 Front St 3000 San Francisco 1 CA 1 94111 35 07/13/2005   09/24/2012   1 Front Street Ste. 3000 San Francisco 1 94111 11 CA 5210-5239 11 Financial Services 11 0 0     6 3 Financial District/South Beach 1   001 FRONT ST San Francisco, CA 94111 (37.791868, -122.398473)
64309 0429106-02-001 Mashable Inc Mashable Inc 001 Market Plaza 550 San+francisco 8 CA 1 94105 7 05/03/2008   01/01/2012 01/01/2014 114 Fifth Ave 15 Floor New York 49 10011 1300 NY     0 0           001 MARKET PLAZA San Francisco, CA 94105 (37.794096, -122.395302)
63515 0427746-02-001 Dbl Investors Llc Dbl Investors Llc 001 Montgomery St 2375 San Francisco 1 CA 1 94104 1 01/25/2008   10/28/2011   1 Montgomery Street Suite 2375 San Francisco 1 94104 1 CA 5210-5239 11 Financial Services 11 0 0     3 1 Financial District/South Beach 1   001 MONTGOMERY ST San Francisco, CA 94104 (37.789286, -122.402058)
50362 0403401-01-001 Hall Jonathan S Hallaway Enterprises 001 Stonestown Ctr 5519 San+francisco 8 CA 1 94132 32 11/03/2006   11/03/2006   380 Bow Hunter Ln Paradise 979 95969 1648 CA     0 0           001 STONESTOWN CTR San Francisco, CA 94132 (37.730043, -122.477361)
6358 0045730-05-001 Faziola Richard J & Hilda Faziolas Apts 0011 Naglee Ave San Francisco 1 CA 1 94112 28 10/01/1968   12/31/2003 12/31/2013 532 Huron St San Francisco 1 94112 20 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Outer Mission 35   0011 NAGLEE AVE San Francisco, CA 94112 (37.711652, -122.446199)
41013 0382548-03-001 642 Harrison & Hawthorn, Llc Credit National De Geneve Inc 002 2nd And Harrison Lot San+francisco 8 CA 1 94107 22 08/03/2009   08/03/2009   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           002 2ND AND HARRISON LOT San Francisco, CA 94107
53734 0406299-01-999 Progrsssive Grounds Cafe #2 Benarafa Aziz A 0027 Pierce Dr Novato 42 CA 1 94947 174 01/01/2007   01/01/2007   2301 Bryant St. San Francisco 1 94110 37 CA     0 0           0027 PIERCE DR NOVATO, CA 94947 (38.083446, -122.574753)
53973 0410437-01-999 Patashvili Igor Patashvili Igor 0036 Matisse Court Pleasant+hill 415 CA 1 94523 653 01/01/2007   01/01/2007   134 Cityview Dr Daly City 11 94014 26 CA 4800-4999 12 Transportation and Warehousing 12 0 0           0036 MATISSE COURT PLEASANT HILL, CA 94523 (37.939906, -122.063335)
121806 0957532-22-001 Electronic Data Systems Corp Hp Enterprise Services Llc 004 Embarcadero Ctr San+francisco 8 CA 1 94111 35 01/01/1998   12/01/2012   0000 Undeliverable Mail San Francisco 1 99999 12 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           004 EMBARCADERO CTR San Francisco, CA 94111 (37.795106, -122.396158)
113519 0911744-01-023 Starbucks Corporation Starbucks Coffee 01 120 4th St San Francisco 1 CA 1 94103 25 03/03/1992   01/01/2002 05/04/2017 Po Box 34442-Tax2 Seattle 140 98124 407 WA 7220-7229 8 Food Services 8 0 0     6 3 South of Market 15   01 120 4TH ST San Francisco, CA 94103 (37.785718, -122.405883)
217922 0407544-01-001 Fernandez David M Fernandez David M 0150 Encline San+francisco 8 CA 1 94127 31 01/01/2007   01/01/2007   0150 Encline San Francisco 1 94127 46 CA     0 0           0150 ENCLINE San Francisco, CA 94127 (37.741863, -122.448663)
51931 0406534-01-001 Burmenko Boris Burmenko Boris 0156 Eucalyptus Dr San Francisco 1 CA 1 94132 32 01/01/2007   01/01/2007 08/21/2016 1113 Shoreline Dr San Mateo 32 94404 218 CA 4800-4999 12 Transportation and Warehousing 12 0 0     7 9 West of Twin Peaks 26   0156 EUCALYPTUS DR San Francisco, CA 94132 (37.731086, -122.473717)
51425 0405622-01-999 Afanador/lopez Sergio S Afanador/lopez Sergio S 0397 Imperial Way #337 Daly+city 40 CA 1 94015 67 01/01/2007 11/10/2007 01/01/2007 11/10/2007             0 0           0397 IMPERIAL WAY DALY CITY, CA 94015 (37.66528, -122.46332)
113529 0911464-01-001 Yee Ken Han San Francisco Floor Co 042 Norton St San Francisco 1 CA 1 94112 28 02/19/1992   02/19/1992   218 Lisbon St San Francisco 1 94112 20 CA 2300-2399 6 Construction 6 0 0     11 Outer Mission 35   042 NORTON ST San Francisco, CA 94112 (37.724938, -122.435625)
54452 0411419-01-999 Silver Roger J Silver Roger J 0514 Nevada St Sausalito 125 CA 1 94965 198 01/01/2007 07/11/2016 01/01/2007 07/11/2016             0 0           0514 NEVADA ST SAUSALITO, CA 94965 (37.864826, -122.499889)

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