home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

7,344 rows where Supervisor District = 9

View and edit SQL

Suggested facets: City, NAICS Code Description, Parking Tax, Transient Occupancy Tax, Neighborhoods - Analysis Boundaries

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
30 0145642-01-001 Biscay Jacques & Leonie 414-416 Warren Apts 414 Warren Dr San Francisco 1 CA 1 94131 14 01/01/1984   01/01/1984   14 Forest Knolls Dr San Francisco 1 94131 14 CA     0 0     7 9 Inner Sunset 13   414 WARREN DR San Francisco, CA 94131 (37.757056, -122.46168)
87 0112259-01-001 Lee Vincent & Sylvia 1571 9th Av Apts 1571 9th Ave San Francisco 1 CA 1 94122 19 08/20/1976   08/20/1976   2928 Fulton St San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1571 9TH AVE San Francisco, CA 94122 (37.759028, -122.465959)
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)
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)
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)
220 0099771-04-001 Jweinat John & Maha S Park Plaza Fine Foods 111 Cambon Dr San Francisco 1 CA 1 94132 32 07/01/1989   09/17/1996 03/01/2014 29a Cambon Dr San Francisco 1 94132 56 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Lakeshore 31   111 CAMBON DR San Francisco, CA 94132 (37.718267, -122.474546)
298 0071652-04-001 Elarms Luther & Catherine 824-830 Holloway Ave Building 824 Holloway Ave San Francisco 1 CA 1 94112 28 06/01/1972   03/03/1994   345 Garfield St San Francisco 1 94132 56 CA     0 0     7 9 Oceanview/Merced/Ingleside 27   824 HOLLOWAY AVE San Francisco, CA 94112 (37.721824, -122.461734)
302 0026883-05-016 Chevron Texaco Corp Chevron 3451 19th Ave San Francisco 1 CA 1 94132 32 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     7 9 Lakeshore 31   3451 19TH AVE San Francisco, CA 94132 (37.726378, -122.475062)
316 0026883-12-001 Chevron Texaco Corp Chevron 301 Claremont Blvd San Francisco 1 CA 1 94127 31 10/01/1968   01/31/1977   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     7 9 West of Twin Peaks 26   301 CLAREMONT BLVD San Francisco, CA 94127 (37.7405, -122.465095)
367 0071960-03-001 Yang Mary W 1475 18th Av Apartments 1475 18th Ave San Francisco 1 CA 1 94122 19 08/01/1971   03/09/1978 12/31/2013 1171 Pacific Av San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1475 18TH AVE San Francisco, CA 94122 (37.76039, -122.475845)
424 0040406-04-001 Kwock John C & Susan C Ask Accounting Svc By Kwock 301 Vicente St San Francisco 1 CA 1 94127 31 02/28/1969   01/01/1998   301 Vicente St San Francisco 1 94127 46 CA     0 0     7 9 West of Twin Peaks 26   301 VICENTE ST San Francisco, CA 94127 (37.739569, -122.470134)
467 0027117-01-001 Powell Maxine Star Dance Studio 300 Moraga St San Francisco 1 CA 1 94122 19 10/01/1968   10/16/1996   300 Moraga St San Francisco 1 94122 15 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     7 9 Inner Sunset 13   300 MORAGA ST San Francisco, CA 94122 (37.756573, -122.465964)
469 0049367-01-001 Digrande Enterprises Inc Gold Mirror Italian Restaurant 800 Taraval St San Francisco 1 CA 1 94116 23 03/03/1969   03/03/1969   800 Taraval St San Francisco 1 94116 45 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft 7 9 West of Twin Peaks 26   800 TARAVAL ST San Francisco, CA 94116 (37.743093, -122.47481)
537 0127256-01-001 Lin Les Ti Linsons Co Ltd 2379 12th Ave San Francisco 1 CA 1 94116 23 09/20/1980   09/20/1980   2379 12th Av San Francisco 1 94116 45 CA 2300-2399 6 Construction 6 0 0     7 9 West of Twin Peaks 26   2379 12TH AVE San Francisco, CA 94116 (37.743812, -122.468123)
625 0086138-02-001 Garicoitz Leon & Germaine 1501 10th Av Apts 1501 10th Ave San Francisco 1 CA 1 94122 19 08/30/1974   08/29/1975   220 Warren Dr San Francisco 1 94131 14 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1501 10TH AVE San Francisco, CA 94122 (37.760026, -122.467105)
628 0000481-01-001 Agentours Inc Agentours Inc 126 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   10/01/1968   126 West Portal Av San Francisco 1 94127 46 CA 4200-4299 7 Wholesale Trade 7 0 0     7 9 West of Twin Peaks 26   126 WEST PORTAL AVE San Francisco, CA 94127 (37.739525, -122.46731)
666 0313238-01-001 Liu Sun K May Sun Kitchen 18 Dorado Ter 19 San Francisco 1 CA 1 94112 28 02/16/1998 03/10/2015 02/16/1998 03/10/2015             0 0     7 9 West of Twin Peaks 26   18 DORADO TER San Francisco, CA 94112 (37.725373, -122.460614)
705 0072145-03-001 Charles Schwab & Co Inc Charles Schwab & Co Inc 106 West Portal Ave San Francisco 1 CA 1 94127 31 06/30/1989   05/01/1997   211 Main St San Francisco 1 94105 5 CA     0 0     7 9 West of Twin Peaks 26   106 WEST PORTAL AVE San Francisco, CA 94127 (37.739703, -122.467104)
759 0000484-01-001 Agid Hyman D Agid Hyman D 452 Gellert Dr San Francisco 1 CA 1 94132 32 10/01/1968 05/06/2017 10/01/1968 05/06/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 Sunset/Parkside 14   452 GELLERT DR San Francisco, CA 94132 (37.730494, -122.48987)
784 0141346-19-001 Sutti John & Associates Inc Whole Foods 1150 Ocean Ave San Francisco 1 CA 1 94112 28 05/01/1983   04/24/2012   700 Airport Blvd #260 Burlingame 60 94010 75 CA 2300-2399 6 Construction 6 0 0     7 9 West of Twin Peaks 26   1150 OCEAN AVE San Francisco, CA 94112 (37.723637, -122.455027)
796 0099996-01-001 Naughton Realty Inc Shamrock Realty 630 Taraval St San Francisco 1 CA 1 94116 23 10/08/1976   10/08/1976   630 Taraval St San Francisco 1 94116 45 CA     0 0     7 9 West of Twin Peaks 26   630 TARAVAL ST San Francisco, CA 94116 (37.743169, -122.473144)
805 0061529-01-001 Elf Realty Corp Various Buildings 290 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   10/01/1968   101 Larkspur Landing Cir #112 Larkspur 77 94939 118 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   290 WEST PORTAL AVE San Francisco, CA 94127 (37.738151, -122.468952)
813 0141479-01-001 Effective Systems Inc Effective Systems Inc 146 Galewood Cir San Francisco 1 CA 1 94131 14 05/25/1983   05/25/1983   146 Galewood Cr San Francisco 1 94131 14 CA 5100-5199 15 Information 15 0 0     7 9 Inner Sunset 13   146 GALEWOOD CIR San Francisco, CA 94131 (37.752635, -122.457657)
912 0061621-03-001 B/c Associates Inc Associated West Imports 1559b Sloat Blvd 240 San Francisco 1 CA 1 94132 32 01/01/1970   03/01/2007   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     7 9 Sunset/Parkside 14   1559B SLOAT BLVD San Francisco, CA 94132 (37.73395, -122.4907)
934 0046291-03-001 Soss Edward H Soss Edward H 1533 Ocean Ave San Francisco 1 CA 1 94112 28 10/01/1968   07/01/1996   1533 Ocean Av San Francisco 1 94112 20 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 Oceanview/Merced/Ingleside 27   1533 OCEAN AVE San Francisco, CA 94112 (37.724419, -122.458739)
955 0072317-03-001 Finnegan Construction Co Inc Finnegan Construction Co Inc 270 Magellan Ave San Francisco 1 CA 1 94116 23 08/01/1972   09/01/2010   Po Box 640231 San Francisco 1 94164 132 CA 2300-2399 6 Construction 6 0 0     7 9 West of Twin Peaks 26   270 MAGELLAN AVE San Francisco, CA 94116 (37.746683, -122.461277)
972 0114713-01-001 Love David G Love G David Piano Service 1686 17th Ave San Francisco 1 CA 1 94122 19 11/01/1978   11/01/1978   1686 17th Av San Francisco 1 94122 15 CA 4400-4599 3 Retail Trade 3 0 0     7 9 Inner Sunset 13   1686 17TH AVE San Francisco, CA 94122 (37.756477, -122.474489)
975 0114713-02-001 Love David G David Love Piano Svc & Restrtn 1686 17th Av San Francisco 1 CA 1 94122 19 11/01/1978   01/17/2003   1686 17th Av San Francisco 1 94122 15 CA 4400-4599 3 Retail Trade 3 0 0     7 9 Inner Sunset 13   1686 17TH AV San Francisco, CA 94122 (37.756477, -122.474489)
1019 0100418-01-001 Anderson Loreta F Anderson Loreta Real Estate 3080 26th Ave San Francisco 1 CA 1 94132 32 06/01/1976 01/10/2013 06/01/1976 01/10/2013             0 0     7 9 Sunset/Parkside 14   3080 26TH AVE San Francisco, CA 94132 (37.731385, -122.481818)
1041 0061778-03-001 Chinn Alberta G 527 529 Moraga St Apts 527 Moraga St San Francisco 1 CA 1 94122 19 01/01/1970   10/10/1992   1462 19th Av San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   527 MORAGA ST San Francisco, CA 94122 (37.756451, -122.468466)
1061 0141638-01-001 Spalding James Hilary Spalding & Co 180 Desoto St San Francisco 1 CA 1 94127 31 03/01/1983   10/25/1999   180 De Soto St San Francisco 1 94127 46 CA 5210-5239 11 Financial Services 11 0 0     7 9 West of Twin Peaks 26   180 DESOTO ST San Francisco, CA 94127 (37.724925, -122.465237)
1130 0061847-01-001 Nathan Paul H Dmd Inc Nathan Paul H Dmd Inc 595 Buckingham Wy 437 San Francisco 1 CA 1 94132 32 09/01/1970 12/31/2014 09/01/1970 12/31/2014             0 0     7 9 Lakeshore 31   595 BUCKINGHAM WY San Francisco, CA 94132 (37.73015, -122.47621)
1152 0061908-01-001 Rozen Richard D Rozen Richard D Dds 2439 Ocean Ave San Francisco 1 CA 1 94127 31 10/01/1968 03/31/2015 10/01/1968 03/31/2015   San Francisco 1 94127 46       0 0     7 9 West of Twin Peaks 26   2439 OCEAN AVE San Francisco, CA 94127 (37.730449, -122.470488)
1170 0141748-01-001 Paul Lynn Sf Preventive Medicine Med Grp 380 West Portal Ave C San Francisco 1 CA 1 94127 31 05/01/1983   05/01/2011   380 West Portal Avenue #C San Francisco 1 94127 46 CA 6100-6299 4 Private Education and Health Services 4 0 0     7 9 West of Twin Peaks 26   380 WEST PORTAL AVE C San Francisco, CA 94127 (37.736941, -122.470397)
1172 0087000-01-001 Sky Tad S Sky Tad S 215 Hearst Ave San Francisco 1 CA 1 94131 14 07/26/1974   07/26/1974   215 Hearst Av San Francisco 1 94131 14 CA 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   215 HEARST AVE San Francisco, CA 94131 (37.730737, -122.442592)
1283 0141893-03-001 Kwan Sam Dat-Shing Lakewood Plaza 2000 Ocean Ave San Francisco 1 CA 1 94127 31 01/01/1996   01/01/1996   3735 Geary Blvd San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   2000 OCEAN AVE San Francisco, CA 94127 (37.726316, -122.465042)
1339 0354178-02-001 Bass Elisa C Elisa C Bass 1727 9th Ave San Francisco 1 CA 1 94122 19 04/16/2010 12/31/2014 04/16/2010 12/31/2014             0 0     7 9 Inner Sunset 13   1727 9TH AVE San Francisco, CA 94122 (37.756019, -122.465749)
1384 0087110-01-001 Monetta Bernard 2528-2536 Ocean Bldg 2528 Ocean Ave San Francisco 1 CA 1 94132 32 04/24/1974   04/24/1974   Po Box P.o. Box 320321 San Francisco 1 94132 56 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   2528 OCEAN AVE San Francisco, CA 94132 (37.731464, -122.472705)
1420 0034818-01-001 Parasol Richard & Gun 166 Locksley Apts 166 Locksley Ave San Francisco 1 CA 1 94122 19 10/01/1968   10/01/1968   775 East Blithedale Ave 212 Suite Mill Valley 26 94941 50 CA 7210-7219 9 Accommodations 9 0 0     7 9 Inner Sunset 13   166 LOCKSLEY AVE San Francisco, CA 94122 (37.757215, -122.462832)
1424 0141952-02-001 Chun Victor C Etal 840 Kirkham St Apartments 840 Kirkham St San Francisco 1 CA 1 94122 19 01/01/1983   01/01/1983 05/17/2017 569 26th Av #3 San Francisco 1 94121 17 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   840 KIRKHAM ST San Francisco, CA 94122 (37.760155, -122.469873)
1431 0127987-01-001 Singh Dp Amerind Co 118 Hearst Ave San Francisco 1 CA 1 94131 14 02/01/1980 03/31/2014 02/01/1980 03/31/2014             0 0     7 9 West of Twin Peaks 26   118 HEARST AVE San Francisco, CA 94131 (37.730732, -122.44023)
1484 0116162-01-001 Wickstrom Donna Rae Flowers By Donna Rae 115 Eastwood Dr San Francisco 1 CA 1 94112 28 04/01/1978   04/01/1978   115 Eastwood Dr San Francisco 1 94112 20 CA 4200-4299 7 Wholesale Trade 7 0 0     7 9 West of Twin Peaks 26   115 EASTWOOD DR San Francisco, CA 94112 (37.727946, -122.457379)
1514 0116294-05-001 All City Locksmith Inc 0 Locksmith 161 Del Vale Ave San Francisco 1 CA 1 94127 31 03/06/1979 03/31/2015 11/08/2004 03/31/2015             0 0     7 9 West of Twin Peaks 26   161 DEL VALE AVE San Francisco, CA 94127 (37.741055, -122.446998)
1551 0087299-01-001 Vorperian Jerry & Knar 601 Taraval Bldg 601 Taraval St San Francisco 1 CA 1 94116 23 10/20/1972   10/20/1972   1339 Murchison Dr Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   601 TARAVAL ST San Francisco, CA 94116 (37.743188, -122.472654)
1577 0142252-03-001 Godiva Chocolatier Inc Godiva Chocolatier 3251 20th Ave San Francisco 1 CA 1 94132 32 01/01/1983   12/21/1987   1 Meridian Blvd 3c-1 Ste Wyomissing 119 19610 178 PA 7220-7229 8 Food Services 8 0 0 H07 Retail Food Market W/food Prep. Lt 5001 Sqft 7 9 Lakeshore 31   3251 20TH AVE San Francisco, CA 94132 (37.727905, -122.475605)
1586 0116450-01-001 Zanze Samuel Zanzes Cheesecake 2405 Ocean Ave San Francisco 1 CA 1 94127 31 03/19/1979   03/19/1979   2450 2405 Ocean Av San Francisco 1 94127 46 CA 7220-7229 8 Food Services 8 0 0 H28 Take-Out Establishment 7 9 West of Twin Peaks 26   2405 OCEAN AVE San Francisco, CA 94127 (37.730123, -122.469715)
1638 0001334-03-001 Antonchuk Richard A 1117 Ocean Av Apts 1117 Ocean Ave San Francisco 1 CA 1 94112 28 10/01/1968   12/02/1991 01/01/2012 16 Hudson Street Redwood City 21 94062 171 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Oceanview/Merced/Ingleside 27   1117 OCEAN AVE San Francisco, CA 94112 (37.723517, -122.454443)
1651 0101289-01-001 Ng Angela 172 Locksley Apts 172 Locksley Ave San Francisco 1 CA 1 94122 19 06/19/1972   06/19/1972 11/10/2013 377 West Portal Av Ste A San Francisco 1 94127 46 CA 5240-5249 20 Insurance 17 0 0     7 9 Inner Sunset 13   172 LOCKSLEY AVE San Francisco, CA 94122 (37.757102, -122.462806)
1658 0101289-02-001 Ng Angela State Farm Insurance 377 W. Portal Ave San Francisco 1 CA 1 94127 31 06/19/1972   10/01/1985   377 West Portal Av Ste A San Francisco 1 94127 46 CA 5240-5249 20 Insurance 17 0 0     7 9 West of Twin Peaks 26   377 W PORTAL AVE San Francisco, CA 94127 (37.736972, -122.470201)
1667 0116654-01-001 Kind Jean S Kind Jean S 2165 15th Ave San Francisco 1 CA 1 94116 23 03/27/1979   03/27/1979   2165 15th Av San Francisco 1 94116 45 CA     0 0     7 9 West of Twin Peaks 26   2165 15TH AVE San Francisco, CA 94116 (37.747607, -122.471658)
1669 0001334-04-001 Antonchuk Richard A 1125 Ocean Av Apts 1125 Ocean Ave San Francisco 1 CA 1 94112 28 10/01/1968   12/02/1991 01/01/2012 16 Hudson Street Redwood City 21 94062 171 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Oceanview/Merced/Ingleside 27   1125 OCEAN AVE San Francisco, CA 94112 (37.723562, -122.454662)
1746 0001484-02-001 Armstrong Carpet&linoleum Co Armstrong Carpet&linoleum Co 369 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   11/20/2002   369 West Portal Ave San Francisco 1 94127 46 CA 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   369 WEST PORTAL AVE San Francisco, CA 94127 (37.737105, -122.470073)
1748 0001484-03-001 Armstrong Carpet&linoleum Co Armstrong Carpt&linoleum Co 369 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   01/01/2010   369 West Portal Ave San Francisco 1 94127 46 CA 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   369 WEST PORTAL AVE San Francisco, CA 94127 (37.737105, -122.470073)
1831 0117040-02-001 Fanfelle Jean S & Georgette Fanfelle Jean S & Georgette 5 Forest Knolls Dr San Francisco 1 CA 1 94131 14 05/26/1978   05/26/1978   5 Forest Knolls Dr San Francisco 1 94131 14 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   5 FOREST KNOLLS DR San Francisco, CA 94131 (37.75671, -122.454743)
1932 0029925-01-001 Sourikoff Judy Sourikoff Alex Insurance Agcy 624 Taraval St San Francisco 1 CA 1 94116 23 10/01/1968   09/01/1999   624 Taraval St San Francisco 1 94116 45 CA 5240-5249 20 Insurance 17 0 0     7 9 West of Twin Peaks 26   624 TARAVAL ST San Francisco, CA 94116 (37.743172, -122.473063)
1940 0142435-01-001 Siyahian Edward S Dental Office 2386 15th Ave San Francisco 1 CA 1 94116 23 08/01/1983   08/01/1983   2386 15th Av San Francisco 1 94116 45 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 West of Twin Peaks 26   2386 15TH AVE San Francisco, CA 94116 (37.743366, -122.471363)
1949 0101581-01-001 Finnegan James E Finnegan & Co 270 Magellan Ave San Francisco 1 CA 1 94116 23 01/10/1977   06/25/2001   270 Magellan Ave San Francisco 1 94116 45 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   270 MAGELLAN AVE San Francisco, CA 94116 (37.746683, -122.461277)
1954 0041655-02-001 Gin Wayne & Barbara 1463 10th Av Apts 1463 10th Ave San Francisco 1 CA 1 94122 19 10/01/1968   07/11/1973 10/26/2017 348 17th Av San Francisco 1 94121 17 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1463 10TH AVE San Francisco, CA 94122 (37.760983, -122.467171)
1967 0087838-01-005 Simoni Zelko & Renn 125 San Jose Apts 232-236 Taraval St San Francisco 1 CA 1 94116 23 01/01/1974   03/01/2007 12/31/2013 112 Terra Vista Av San Francisco 1 94115 2 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   232 236 TARAVAL ST San Francisco, CA 94116 (37.743354, -122.468763)
2038 0030032-01-019 Walgreen Co Walgreen Co 1630 Ocean Ave San Francisco 1 CA 1 94112 28 10/01/1968   06/02/2002   300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0 H04 Retail Mkts W/o Prep (5,001 - 10,000) 7 9 West of Twin Peaks 26   1630 OCEAN AVE San Francisco, CA 94112 (37.724618, -122.45969)
2050 0014885-02-001 Totah John B 220-226 West Portal Bldg 220 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   10/01/1969   125 Broadmoor Dr San Francisco 1 94132 56 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   220 WEST PORTAL AVE San Francisco, CA 94127 (37.738585, -122.468408)
2056 0014885-03-001 Totah John B 2381-87 Ocean Av Bldg 2381 Ocean Ave San Francisco 1 CA 1 94127 31 10/01/1968   09/11/1989   125 Broadmoor Dr San Francisco 1 94132 56 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   2381 OCEAN AVE San Francisco, CA 94127 (37.729993, -122.469397)
2066 0050877-03-001 General Employment Enterprises General Employment Enterprises 30 Santa Paula Ave San Francisco 1 CA 1 94127 31 10/01/1969 06/27/2014 06/01/2013 06/27/2014             0 0     7 9 West of Twin Peaks 26   30 SANTA PAULA AVE San Francisco, CA 94127 (37.739401, -122.463254)
2068 0014885-04-001 Totah John B 2403-05 Ocean Av Bldg 2403 Ocean Ave San Francisco 1 CA 1 94127 31 10/01/1968   09/11/1989   125 Broadmoor Dr San Francisco 1 94132 56 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   2403 OCEAN AVE San Francisco, CA 94127 (37.730142, -122.46976)
2092 0117477-07-001 Lichty J Stoner Jr/raszl Darry Foxfire Property Management 14 Santa Clara Ave San Francisco 1 CA 1 94127 31 11/10/1978   08/11/1997   14 Santa Clara Ave San Francisco 1 94127 46 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   14 SANTA CLARA AVE San Francisco, CA 94127 (37.738889, -122.466012)
2097 0030032-01-022 Walgreen Co Walgreen Co 2550 Ocean Ave San Francisco 1 CA 1 94132 32 10/01/1968   06/02/2002   300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0 H04 Retail Mkts W/o Prep (5,001 - 10,000) 7 9 West of Twin Peaks 26   2550 OCEAN AVE San Francisco, CA 94132 (37.731528, -122.472832)
2111 0117618-02-001 Wu Pit Chu Chu Wu Painting Co 344 Marietta Dr San Francisco 1 CA 1 94127 31 01/20/2012   01/20/2012   344 Marietta Drive San Francisco 1 94127 46 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 West of Twin Peaks 26   344 MARIETTA DR San Francisco, CA 94127 (37.739432, -122.444981)
2126 0002250-01-001 Barbagelata & Co Inc Barbagelata Co The 45 W Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   07/02/2006   45 W Portal Ave San Francisco 1 94127 46 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   45 W PORTAL AVE San Francisco, CA 94127 (37.7402, -122.466393)
2132 0062169-01-001 Stern Earl Md Inc Stern Earl Md Inc 1496 Portola Dr San Francisco 1 CA 1 94127 31 03/01/1970   03/01/1970   10 Melba Ave San Francisco 1 94132 56 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 West of Twin Peaks 26   1496 PORTOLA DR San Francisco, CA 94127 (37.737516, -122.468277)
2139 0002250-02-001 Barbagelata & Co Inc Real Estate Sf.com 45 W Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   07/02/2006   45 W Portal Ave San Francisco 1 94127 46 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   45 W PORTAL AVE San Francisco, CA 94127 (37.7402, -122.466393)
2191 0002425-01-001 Joseph Basso Dpm Inc Basso Joseph Dpm Inc 340 Taraval St San Francisco 1 CA 1 94116 23 10/01/1968   10/01/1968   340 Taraval St San Francisco 1 94116 45 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 West of Twin Peaks 26   340 TARAVAL ST San Francisco, CA 94116 (37.743305, -122.469859)
2202 0002529-02-001 Bay City Paint Co Bay City Paint Co 1818 15th Ave San Francisco 1 CA 1 94122 19 10/01/1968   04/01/2001   1818 15th Ave San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1818 15TH AVE San Francisco, CA 94122 (37.753774, -122.47211)
2274 0134944-02-002 Lie Roland K S Law Offices Of Roland Lie 706 Monterey Blvd San Francisco 1 CA 1 94127 31 03/29/1982   06/15/1992   706 Monterey Blvd 102 San Francisco 1 94127 46 CA     0 0     7 9 West of Twin Peaks 26   706 MONTEREY BLVD San Francisco, CA 94127 (37.731587, -122.451377)
2275 0062251-02-001 Harbin West Holdings, Llc 311-317 West Portal Bldg 311 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   01/01/1973   10390 Mississippi Av Los Angeles 3 90025 227 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   311 WEST PORTAL AVE San Francisco, CA 94127 (37.737815, -122.469233)
2287 0392816-01-003 H & M Hennes & Mauritz Lp H & M 3251 20th Ave 203 San Francisco 1 CA 1 94132 32 11/17/2005   05/24/2007   300 Lighting Way 100 Unit Secaucus 154 07094 228 NJ 4400-4599 3 Retail Trade 3 0 0     7 9 Lakeshore 31   3251 20TH AVE San Francisco, CA 94132 (37.727905, -122.475605)
2299 0041936-01-001 Johnson Allen M 643 Taraval Apts 643 Taraval St San Francisco 1 CA 1 94116 23 10/01/1968   10/01/1968   36 Cragmont Av San Francisco 1 94116 45 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   643 TARAVAL ST San Francisco, CA 94116 (37.743168, -122.473163)
2300 0117786-01-001 Takatani Toru Joto Construction 1919 18th Ave San Francisco 1 CA 1 94116 23 09/01/1978   01/01/2004   1919 18th Ave San Francisco 1 94116 45 CA 2300-2399 6 Construction 6 0 0     7 9 Inner Sunset 13   1919 18TH AVE San Francisco, CA 94116 (37.752015, -122.47528)
2327 0143158-01-001 Choi Priscilla P New Century Real Estate Co 85 Lomita Ave San Francisco 1 CA 1 94122 19 09/13/1983   09/13/1983   85 Lomita Av San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   85 LOMITA AVE San Francisco, CA 94122 (37.758445, -122.472858)
2381 0143194-14-001 Payless Shoe Source Inc Payless Shoesource #5770 1563 Sloat Blvd San Francisco 1 CA 1 94132 32 09/01/1983   05/27/1999 09/25/2016 Po Box 3590 Topeka 159 66601 234 KS 4400-4599 3 Retail Trade 3 0 0     7 9 Sunset/Parkside 14   1563 SLOAT BLVD San Francisco, CA 94132 (37.734011, -122.489742)
2385 0074398-02-001 Woo Wayne & Pang Tet H 1114 Ortega St Apartments 1114 Ortega St San Francisco 1 CA 1 94122 19 11/02/1972   03/27/1976   4790 Geary Bl San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1114 ORTEGA ST San Francisco, CA 94122 (37.752421, -122.475441)
2391 0074398-04-001 Woo Wayne & Pang Tet H 1910-1910a Ocean Av Apts 1910-10a Ocean Ave San Francisco 1 CA 1 94127 31 11/02/1972   11/02/1972   4790 Geary Bl San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   1910 10A OCEAN AVE San Francisco, CA 94127 (37.725352, -122.462486)
2396 0088168-03-001 Choy Bing W & Anne H 62-68 West Portal Bldg 62 West Portal Ave San Francisco 1 CA 1 94127 31 01/01/1974   06/03/1976   277 7th Ave San Francisco 1 94118 28 CA     0 0     7 9 West of Twin Peaks 26   62 WEST PORTAL AVE San Francisco, CA 94127 (37.740076, -122.466687)
2432 0035506-03-001 Carberry Margaret Etal 1566 19th Av Apts 1566 19th Ave San Francisco 1 CA 1 94122 19 10/01/1968 02/24/2015 10/01/1968 02/24/2015             0 0     7 9 Inner Sunset 13   1566 19TH AVE San Francisco, CA 94122 (37.758601, -122.476659)
2450 0400703-02-001 Happy Path Inc Mro-Direct 45 Aloha Ave San Francisco 1 CA 1 94122 19 07/28/2006 01/01/2016 04/22/2011 01/01/2016             0 0     7 9 Inner Sunset 13   45 ALOHA AVE San Francisco, CA 94122 (37.757501, -122.470773)
2498 0030032-10-001 Walgreen Co Walgreens #04264 2 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   10/01/1968 05/24/2009 300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   2 WEST PORTAL AVE SAN FRANCISCO, CA 94127 (37.74073, -122.466024)
2513 0030032-12-001 Walgreen Co Walgreens #04180 685 Portola Dr San Francisco 1 CA 1 94127 31 10/01/1968   04/30/1999 06/07/2015 300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   685 PORTOLA DR San Francisco, CA 94127 (37.7448, -122.452911)
2517 0403543-03-001 Mack Ronald C Mackboiant Mb Clothing 3737 Alemany Blvd San Francisco 1 CA 1 94132 32 05/24/2011 06/14/2014 05/24/2011 06/14/2014         4400-4599 3 Retail Trade 3 0 0     7 9 Oceanview/Merced/Ingleside 27   3737 ALEMANY BLVD San Francisco, CA 94132 (37.71169, -122.465945)
2527 0003438-01-001 Bock Ernest Bock Ernest 226 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968 04/01/2017 10/01/1968 04/01/2017         4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   226 WEST PORTAL AVE San Francisco, CA 94127 (37.73864, -122.468344)
2579 0088308-03-001 Moresi Raymond D Moresi Realty 2751 15th Ave San Francisco 1 CA 1 94127 31 01/01/1975   04/01/2010   2751 15th Avenue San Francisco 1 94127 46 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   2751 15TH AVE San Francisco, CA 94127 (37.737005, -122.470925)
2632 0062518-02-001 Wong Hing J & Sue K 1763 7th Av Apts 1763 7th Ave San Francisco 1 CA 1 94122 19 10/01/1968   08/27/1976 12/31/2013 2160 Brittany Ct Concord 42 94518 246 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1763 7TH AVE San Francisco, CA 94122 (37.755543, -122.463571)
2650 0015410-01-004 Kelly Moore Paint Co Inc Kelly Moore Paint Co Inc 445 Taraval St San Francisco 1 CA 1 94116 23 10/01/1968   05/01/2001   987 Commercial St San Carlos 164 94070 240 CA 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   445 TARAVAL ST San Francisco, CA 94116 (37.743257, -122.471019)
2656 0118345-01-001 Lenahan J A Md Inc Lenahan John A Md Inc 595 Buckingham Wy 404 San Francisco 1 CA 1 94132 32 01/01/1978   01/01/1978   595 Buckingham Wy #404 San Francisco 1 94132 56 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 Lakeshore 31   595 BUCKINGHAM WY San Francisco, CA 94132 (37.73015, -122.47621)
2671 0118352-01-001 Marks Mendy S Marks Mendy Jeweler 1552 9th Ave San Francisco 1 CA 1 94122 19 01/01/1978   01/01/1978   1552 9th Av San Francisco 1 94122 15 CA 4400-4599 3 Retail Trade 3 0 0     7 9 Inner Sunset 13   1552 9TH AVE San Francisco, CA 94122 (37.759317, -122.465979)
2730 0015455-01-001 Arden Wood Inc Arden Wood Inc 400 West Portal Ave San Francisco 1 CA 1 94127 31 04/21/1975   04/21/1975   445 Wawona St San Francisco 1 94116 45 CA 8100-8139 5 Certain Services 5 0 0     7 9 West of Twin Peaks 26   400 WEST PORTAL AVE San Francisco, CA 94127 (37.736636, -122.470664)
2746 0428872-02-001 Jin Hui Hj Trading Co 1559a Sloat Blvd San Francisco 1 CA 1 94132 32 05/14/2008 05/30/2014 01/20/2010 05/30/2014 1559a Sloat Blvd San Francisco 1 94132 56 CA     0 0     7 9 Sunset/Parkside 14   1559A SLOAT BLVD San Francisco, CA 94132 (37.734182, -122.489697)
2766 0129476-02-001 Shelaar Restaurant Serv Inc El Toreador Fonda Mexicana Res 50 West Portal Ave San Francisco 1 CA 1 94127 31 04/14/1981   01/01/1999   50 West Portal Av San Francisco 1 94127 46 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft 7 9 West of Twin Peaks 26   50 WEST PORTAL AVE San Francisco, CA 94127 (37.740269, -122.466477)
2785 0015470-03-001 Eleanore Kermani 231-239 West Portal Bldg 231 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   02/01/1972   7 Mariposa Ct Burlingame 60 94010 75 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   231 WEST PORTAL AVE San Francisco, CA 94127 (37.739111, -122.467653)
2806 0030032-34-001 Walgreen Co Walgreens #13670 200 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   04/01/2009   300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0 H05 H73 Multiple 7 9 West of Twin Peaks 26   200 WEST PORTAL AVE San Francisco, CA 94127 (37.738741, -122.468225)
2808 0030032-35-001 Walgreen Co Walgreens #13671 3931 Alemany Blvd 2001 San Francisco 1 CA 1 94132 32 10/01/1968   04/01/2009 07/07/2015 300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0     7 9 Oceanview/Merced/Ingleside 27   3931 ALEMANY BLVD San Francisco, CA 94132 (37.711353, -122.467256)
2837 0015575-01-001 Kimura Framing Gallery Inc Kimura Framing Gallery Inc 1933 Ocean Ave San Francisco 1 CA 1 94127 31 10/01/1968 04/30/2014 10/01/1968 04/30/2014             0 0     7 9 West of Twin Peaks 26   1933 OCEAN AVE San Francisco, CA 94127 (37.72552, -122.462921)

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