home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5,790 rows where Mail Zipcode = 47 sorted by Location Id

View and edit SQL

Suggested facets: State, Mail City, NAICS Code Description, Parking Tax, Transient Occupancy Tax, Supervisor District

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
184106 0000244-01-001 Crown Building Maintenance Co Able Building Maintenance Co 868 Folsom St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   868 Folsom St San Francisco 1 94107 47 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 South of Market 15   868 FOLSOM ST San Francisco, CA 94107 (37.780746, -122.402797)
184107 0000244-02-001 Crown Building Maintenance Co Able Services 868 Folsom St San Francisco 1 CA 1 94107 22 10/01/1968   04/01/2005   868 Folsom St San Francisco 1 94107 47 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 South of Market 15   868 FOLSOM ST San Francisco, CA 94107 (37.780746, -122.402797)
1528 0001190-01-001 Anderson Rowe & Buckley Inc Anderson Rowe & Buckley Inc 2833 3rd St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   2833 3rd St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0 D02 D19 Multiple 10 4 Potrero Hill 28   2833 3RD ST San Francisco, CA 94107 (37.75374, -122.387764)
213971 0001341-01-001 Antonio Mariani Inc Antonios Antiques 701 Bryant St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   701 Bryant Street San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0 P52 State 2nd Hand Dealer Jewelry/clothg/furn/books 6 3 South of Market 15   701 BRYANT ST San Francisco, CA 94107 (37.777683, -122.400452)
213972 0001341-03-001 Antonio Mariani Inc Antonios 701 Bryant St San Francisco 1 CA 1 94107 22 10/01/1968   12/12/2003   701 Bryant Street San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0 D03 Portable Containers 6 3 South of Market 15   701 BRYANT ST San Francisco, CA 94107 (37.777683, -122.400452)
1690 0001341-04-001 Antonio Mariani Inc Antonio's Antiques Custom & Re 701 Bryant St San Francisco 1 CA 1 94107 22 10/01/1968   01/01/2013   701 Bryant Street San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     6 3 South of Market 15   701 BRYANT ST San Francisco, CA 94107 (37.777683, -122.400452)
2529 0003530-01-002 Books Inc Books Inc 3515 California St (Laurel Village) San Francisco 1 CA 1 94118 6 03/01/1977   01/01/1978   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     2 Presidio Heights 3   3515 CALIFORNIA ST (LAUREL VILLAGE San Francisco, CA 94118
2531 0003530-01-006 Books Inc Books Inc 601 Van Ness Ave San Francisco 1 CA 1 94102 16 03/01/1977   09/27/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0           601 VAN NESS AVE San Francisco, CA 94102 (37.781471, -122.420616)
2536 0003530-04-001 Books Inc Books Inc 2275 Market St (Mkt Village Mall) San Francisco 1 CA 1 94105 7 03/01/1977   07/01/2000   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     8 5 Castro/Upper Market 30   2275 MARKET ST (MKT VILLAGE MALL San Francisco, CA 94105
2539 0003530-05-001 Books Inc Books Inc 2251 Chestnut St San Francisco 1 CA 1 94123 3 03/01/1977   05/15/1998   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     2 Marina 2   2251 CHESTNUT ST San Francisco, CA 94123 (37.800296, -122.440317)
2564 0003530-12-001 Books Inc Compass Books 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   10/03/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2566 0003530-13-001 Books Inc Compass Books Inc 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   10/03/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2573 0003530-14-001 Books Inc Compass Books & Cafe 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   10/03/2006   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2589 0003530-15-001 Books Inc Books Inc 1501 Vermont St San Francisco 1 CA 1 94107 22 03/01/1977   01/01/2005   1501 Vermont St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Potrero Hill 28   1501 VERMONT ST San Francisco, CA 94107 (37.750215, -122.402829)
2654 0003778-01-001 Bressie & Company Bressie Property Mgmt-Lesng Co 500 3rd St #505 San+francisco 8 CA 1 94107 22 10/01/1968   01/02/2002   500 3rd Street #505 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           500 3RD ST SAN FRANCISCO, CA 94107 (37.781326, -122.395835)
3611 0004739-01-001 Cammisa & Wipf Cammisa-Wipf Consltng Engnrs 642 Harrison St 4th Floor San Francisco 1 CA 1 94107 22 10/01/1968   08/01/2010   642 Harrison St. 4th Floor San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   642 HARRISON ST San Francisco, CA 94107 (37.783522, -122.396184)
4025 0005189-01-001 Center Hardware &Supply Co Inc Center Hardware & Supply Co In 999 Mariposa St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968 12/31/2016 3003 Third St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 10 4 Potrero Hill 28   999 MARIPOSA ST San Francisco, CA 94107 (37.764036, -122.393749)
8236 0009552-01-001 Fiore Richard A Fiore & Co 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   12/30/1990   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8240 0009552-03-001 Fiore Richard A 987 Rhode Island Apts 987 Rhode Island St San Francisco 1 CA 1 94107 22 10/01/1968   02/18/1972   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   987 RHODE ISLAND ST San Francisco, CA 94107 (37.757346, -122.40187)
8252 0009552-04-001 Fiore Richard A 272-276 Connecticut Apts 272 Connecticut St San Francisco 1 CA 1 94107 22 10/01/1968   06/02/1975   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   272 CONNECTICUT ST San Francisco, CA 94107 (37.762845, -122.397524)
185161 0009552-05-001 Fiore Richard A 1301-1307 Hampshire Apts 1301 Hampshire St San Francisco 1 CA 1 94110 18 10/01/1968   01/01/1976   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   1301 HAMPSHIRE ST San Francisco, CA 94110 (37.751091, -122.40711)
185162 0009552-07-001 Fiore Richard A 2833 25th St Bldg 2833 25th St San Francisco 1 CA 1 94110 18 10/01/1968   01/01/1976   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   2833 25TH ST San Francisco, CA 94110 (37.75133, -122.406856)
213985 0009552-08-001 Fiore Richard A 4539-4543 Mission Bldg 4539 Mission St San Francisco 1 CA 1 94112 28 10/01/1968   09/26/1973   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Excelsior 23   4539 MISSION ST San Francisco, CA 94112 (37.725631, -122.434094)
213986 0009552-09-001 Fiore Richard A 586 6th St Rentals 586 6th St San Francisco 1 CA 1 94103 25 10/01/1968   01/01/1978   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   586 6TH ST San Francisco, CA 94103 (37.775123, -122.401382)
185163 0009552-10-001 Fiore Richard A 928 Geneva Bldg 928 Geneva Ave San Francisco 1 CA 1 94112 28 10/01/1968   03/22/1977   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     11 Excelsior 23   928 GENEVA AVE San Francisco, CA 94112 (37.716177, -122.440698)
185164 0009552-11-001 Fiore Richard A 271 Clara St Building 271 Clara St San Francisco 1 CA 1 94107 22 10/01/1968   11/20/1979   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   271 CLARA ST San Francisco, CA 94107 (37.778279, -122.403896)
185165 0009552-12-001 Fiore Richard A 82-84 1st St Building 82 1st St San Francisco 1 CA 1 94105 7 10/01/1968   09/01/1977   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   82 1ST ST San Francisco, CA 94105 (37.790019, -122.397861)
8255 0009552-13-001 Fiore Richard A 89-91 Stillman St Building 89 Stillman St San Francisco 1 CA 1 94107 22 10/01/1968   05/07/1973   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   89 STILLMAN ST San Francisco, CA 94107 (37.78206, -122.396005)
8277 0009552-14-001 Fiore Richard A 228-242 Townsend St Building 228 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   06/22/1984   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   228 TOWNSEND ST San Francisco, CA 94107 (37.778094, -122.393738)
8285 0009552-15-001 Fiore Richard A First California Loans 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/02/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8300 0009552-16-001 Fiore Richard A First California Loan Co 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   04/04/1998   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8355 0009552-19-001 Fiore Richard A Townsend Place 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   04/03/1998   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8394 0009552-20-001 Fiore Richard A Townsend Square 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   04/03/1998   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8411 0009552-21-001 Fiore Richard A Fiore And Company 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
214911 0009552-22-001 Fiore Richard A Raf Properties 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8463 0009552-23-001 Fiore Richard A R.a.f. Development Company 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8472 0009552-24-001 Fiore Richard A 987 Rhode Island Apts 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8482 0009552-25-001 Fiore Richard A First California Loan Co 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8491 0009552-26-001 Fiore Richard A First California Loans 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8496 0009552-27-001 Fiore Richard A Fiore & Co 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
185194 0009552-28-001 Fiore Richard A Fiore & Company 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
231 0009552-29-001 Fiore Richard A Fiore & Company 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8508 0009552-30-001 Fiore Richard A Raf Properties 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8518 0009552-31-001 Fiore Richard A Townsend Place 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8543 0009552-32-001 Fiore Richard A 228-242 Townsend St Building 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8551 0009552-33-001 Fiore Richard A 272-276 Connecticut Apts 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8583 0009552-34-001 Fiore Richard A 1301-1307 Hampshire Apts 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8605 0009552-35-001 Fiore Richard A 586 6th St Rentals 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8620 0009552-36-001 Fiore Richard A R.a.f. Development Company 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8631 0009552-37-001 Fiore Richard A Townsend Square 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8887 0009586-01-001 First Spice Mixing Co Inc First Spice Mixing & Mfg Co 195 Arkansas St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   195 Arkansas St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     10 4 Potrero Hill 28   195 ARKANSAS ST San Francisco, CA 94107 (37.763797, -122.398561)
8086 0009722-01-001 Florindo Cimino Flos Barber Shop 1532 20th St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   1532 20th St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1532 20TH ST San Francisco, CA 94107 (37.759991, -122.396998)
9007 0010041-01-001 Frankel Thomas L Frankel Thomas L 695 5th St 13 San Francisco 1 CA 1 94107 22 10/01/1968   08/02/1999   695 5th St #13 San Francisco 1 94107 47 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 South of Market 15   695 5TH ST San Francisco, CA 94107 (37.775481, -122.397403)
738 0012716-06-001 Paul's Stores Inc Paul Stores Inc Pier 70 Bldg #2 San+francisco 8 CA 1 94107 22 12/31/1987   12/31/1987   Pier 70 Bldg 2 San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0           2 San Francisco, CA 94107
1311 0013211-01-001 Hosoda Satoru Etal Hosoda Bros Inc 1444 Tennessee St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   1444 Tennessee Street San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0 D19 H21 Multiple 10 4 Potrero Hill 28   1444 TENNESSEE ST San Francisco, CA 94107 (37.753565, -122.388842)
1696 0013910-01-001 Hundley E M Hardware Co Hundley E M Hardware Co 617 Bryant St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   617 Bryant St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     6 3 South of Market 15   617 BRYANT ST San Francisco, CA 94107 (37.779257, -122.39847)
1830 0014439-02-001 Konce Allan A Md Inc Connecticut Street Medical Grp 2 Connecticut St 2nd Fl San Francisco 1 CA 1 94107 22 06/19/2009   06/19/2009   2 Connecticut St 2nd Fl San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Mission Bay 25   2 CONNECTICUT ST San Francisco, CA 94107 (37.765982, -122.397837)
1859 0014503-01-001 Jackson He Co Jackson H E Co 334 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   334 Brannan St San Francisco 1 94107 47 CA 5210-5239 11 Financial Services 11 0 0     6 3 Financial District/South Beach 1   334 BRANNAN ST San Francisco, CA 94107 (37.781226, -122.392869)
222521 0014720-01-001 Jenson Lonnie Co Inc Jensen Lonnie Co 1350b 25th St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   1350b 25th St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1350B 25TH ST San Francisco, CA 94107 (37.75257, -122.392314)
2872 0015662-01-001 Bart-Bek Plus 4, Inc. Kca Engineers Inc 318 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   318 Brannan St, 2nd Floor San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   318 BRANNAN ST San Francisco, CA 94107 (37.78143, -122.392607)
3537 0016922-01-001 Lewis & Taylor, Llc Lewis & Taylor Inc 440 Bryant St San Francisco 1 CA 1 94107 22 12/31/2008   12/31/2008   440 Bryant St San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   440 BRYANT ST San Francisco, CA 94107 (37.782295, -122.394584)
5918 0020930-01-001 Nuckton Co Nuckton Co 668 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   668 Brannan St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   668 BRANNAN ST San Francisco, CA 94107 (37.775346, -122.400318)
6421 0021703-01-001 Paganini Electric Corp Paganini Electric Corp 190 Hubbell St San Francisco 1 CA 1 94107 22 10/01/1968   10/22/1996   190 Hubbell St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Mission Bay 25   190 HUBBELL ST San Francisco, CA 94107 (37.766887, -122.397897)
7955 0023483-02-001 Rapid Typographers Co Inc Rapid 836 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   05/01/2010   836 Harrison St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0           836 HARRISON ST San Francisco, CA 94107 (37.780029, -122.4006)
7956 0023483-03-001 Rapid Typographers Co Inc Rapid Lasergraphics 836 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   05/01/2010   836 Harrison St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     6 3 South of Market 15   836 HARRISON ST SAN FRANCISCO, CA 94107 (37.780029, -122.4006)
7970 0023483-04-001 Rapid Typographers Co Inc Rapid Giclee 505 Beach St San Francisco 1 CA 1 94133 11 10/01/1968   07/01/2008   836 Harrison St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     3 1 North Beach 6   505 BEACH ST San Francisco, CA 94133 (37.807034, -122.417619)
8970 0024944-01-001 Santa Rosa Wholesale Flrst Inc Santa Rosa Wholesale Flrst Inc 674 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   08/29/1998   674 Brannan St San Francisco 1 94107 47 CA 4200-4299 4400-4599 13 Multiple 13 0 0     6 3 South of Market 15   674 BRANNAN ST San Francisco, CA 94107 (37.775282, -122.400398)
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)
225 0026377-01-001 Slovenian Progressive Home Inc Slovenian Progresive Home 2101 Mariposa St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   2101 Mariposa St San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D04 P23 Multiple 10 4 Potrero Hill 28   2101 MARIPOSA ST San Francisco, CA 94107 (37.763382, -122.404376)
1441 0028914-01-001 Trayer Engineering Corp Trayer Engineering Corp 898 Pennsylvania Ave San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   898 Pennsylvania Av San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0 D03 D10 D19 D39 Multiple 10 4 Potrero Hill 28   898 PENNSYLVANIA AVE San Francisco, CA 94107 (37.755723, -122.392931)
1665 0028977-01-001 Tropical California Inc Tropical California Inc 666 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   666 Brannan St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   666 BRANNAN ST San Francisco, CA 94107 (37.775367, -122.400291)
1820 0029694-01-001 Venetian Natural Marble Co In Venetian Natural Marble Co Inc 991 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   991 Harrison St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   991 HARRISON ST San Francisco, CA 94107 (37.777614, -122.40366)
8798 0033855-01-001 Gee Edward & Louie & Amy L 1435 Pacific Apts 1435 Pacific Ave San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   165 Texas St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1435 PACIFIC AVE San Francisco, CA 94109 (37.795393, -122.418912)
4613 0036833-01-001 Speyer Stanley A 720 Haight St Apts 720 Haight St San Francisco 1 CA 1 94117 33 10/01/1968   10/01/1968   665 3rd St #408 San Francisco 1 94107 47 CA     0 0     5 7 Haight Ashbury 32   720 HAIGHT ST San Francisco, CA 94117 (37.771619, -122.434251)
5641 0044904-01-001 Joseph Bruno Sheetmetal Co.inc Standard Sheet Metal Etc 366 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   366 Brannan St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0 D03 D19 Multiple 6 3 Financial District/South Beach 1   366 BRANNAN ST San Francisco, CA 94107 (37.780628, -122.393624)
214005 0044904-02-001 Joseph Bruno Sheetmetal Co.inc Standard Sheet Metal & Marine 159 S Park St San+francisco 8 CA 1 94107 22 10/01/1968   10/01/1968   366 Brannan St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0           159 S PARK ST San Francisco, CA 94107 (37.781065, -122.394363)
190656 0047783-01-001 E Mitchell Inc E Mitchell Inc 1580 Indiana St San Francisco 1 CA 1 94107 22 10/01/1968   01/01/1999   1580 Indiana St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 10 4 Bayview Hunters Point 4   1580 INDIANA ST San Francisco, CA 94107 (37.750349, -122.390464)
9143 0048017-01-001 Sheedy Drayage Co Sheedy Drayage Co 1215 Michigan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   Po Box 77004 San Francisco 1 94107 47 CA     0 0 D03 D19 D23 D39 Multiple 10 4 Potrero Hill 28   1215 MICHIGAN ST San Francisco, CA 94107 (37.753109, -122.385897)
215144 0048017-02-999 Sheedy Drayage Co Sheedy Hoist Company 34301 7th St Union+city 79 CA 1 94587 124 10/01/1968   01/02/1997   Po Box 77004 San Francisco 1 94107 47 CA     0 0           34301 7TH ST UNION CITY, CA 94587 (37.593549, -122.010248)
9189 0048017-03-999 Sheedy Drayage Co Sheedy Hoist 12536 Clark St Santa+fe+springs 21 CA 1 90670 43 10/01/1968   01/01/2008   Po Box 77004 San Francisco 1 94107 47 CA     0 0           12536 CLARK ST SANTA FE SPRINGS, CA 90670 (33.938959, -118.064876)
45280 0048017-04-999 Sheedy Drayage Co Sheedy Hoist 4970 E Cartier Ave Las+vegas 366 NV 18 89115 1069 10/01/1968   01/01/2008   Po Box 77004 San Francisco 1 94107 47 CA     0 0           4970 E CARTIER AVE LAS VEGAS, NV 89115 (36.207213, -115.065582)
9327 0048017-05-999 Sheedy Drayage Co Sheedy Dryage 515 Port Rd 21 Stockton 115 CA 1 95203 202 10/01/1968   01/01/2008   Po Box 77004 San Francisco 1 94107 47 CA     0 0           515 PORT RD STOCKTON, CA 95203 (37.941456, -121.320843)
9491 0048017-06-999 Sheedy Drayage Co Sheedy Drayage Co 943 East Hedding San+jose 26 CA 1 95133 311 10/01/1968   09/01/2011   Po Box 77004 San Francisco 1 94107 47 CA     0 0           943 EAST HEDDING SAN JOSE, CA 95133
1353 0050253-01-001 Maillard John & Laiola, Et Al 53-69 Bluxome Bldg 63 Bluxome St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   63 Bluxome San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   63 BLUXOME ST San Francisco, CA 94107 (37.776606, -122.39717)
3554 0052274-01-001 Louie Walter W Etal 835-841 Pacific Bldg 835 Pacific Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1001 16th St San Francisco 1 94107 47 CA 5300-5399 7210-7219 19 Multiple 13 0 0     3 1 Chinatown 7   835 PACIFIC AVE San Francisco, CA 94133 (37.79662, -122.409118)
7784 0057392-01-002 Hill & Knowlton Inc Hill & Knowlton Inc 60 Green St San Francisco 1 CA 1 94111 35 01/01/2010 11/06/2017 12/31/2010 11/06/2017   San Francisco 1 94107 47   5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   60 GREEN ST San Francisco, CA 94111 (37.80058, -122.400545)
8009 0057823-01-001 Peterson Robert L Chase Auto Service 911 Harrison St San Francisco 1 CA 1 94107 22 07/01/1969   02/21/1999   911 Harrison St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 6 3 South of Market 15   911 HARRISON ST San Francisco, CA 94107 (37.778757, -122.402205)
1080 0061811-01-001 Speedway Copy Systems Inc Speedway Copy Systems Inc 227 Front St San Francisco 1 CA 1 94111 35 04/21/1970   04/21/1970   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   227 FRONT ST San Francisco, CA 94111 (37.793841, -122.398886)
1091 0061811-01-002 Speedway Copy Systems Inc Speedway Copy Systems Inc 475 4th St San Francisco 1 CA 1 94107 22 04/21/1970   01/01/1985   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   475 4TH ST San Francisco, CA 94107 (37.779819, -122.398409)
1095 0061811-01-013 Speedway Copy Systems Inc Speedway Copy Systems Inc 300 Pine St San Francisco 1 CA 1 94104 1 04/21/1970   05/06/2011   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   300 PINE ST San Francisco, CA 94104 (37.792105, -122.400958)
4017 0063320-01-001 Mitchell-Michael Properties 1051 26th St Bldg 1051 26th St San Francisco 1 CA 1 94107 22 04/01/1974   04/01/1974 10/26/2014 1580 Indiana St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1051 26TH ST San Francisco, CA 94107 (37.751434, -122.389901)
4021 0063320-02-001 Mitchell-Michael Properties 1500-1580 Indiana Bldg 1580 Indiana St San Francisco 1 CA 1 94107 22 04/01/1974   04/01/1974   1580 Indiana St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1580 INDIANA ST San Francisco, CA 94107 (37.750349, -122.390464)
5054 0064300-01-001 Edmondson John R Inc Ciarlo Bros 765 Bryant St San Francisco 1 CA 1 94107 22 06/01/1971   06/01/1971   765 Bryant St San Francisco 1 94107 47 CA     0 0 D10 Application Of Flammable Finishes 6 3 South of Market 15   765 BRYANT ST San Francisco, CA 94107 (37.776742, -122.401642)
8180 0067808-01-001 Grenier Wholesale Liquors Inc Grenier Wholesale Liquors Inc 1500 Tennessee St San Francisco 1 CA 1 94107 22 10/01/1971   10/01/1971   1500 Tennessee St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0 D19 H21 H73 Multiple 10 4 Bayview Hunters Point 4   1500 TENNESSEE ST San Francisco, CA 94107 (37.75229, -122.388725)
1564 0073643-01-001 Pang Fred S Sin Ma 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   11/15/1972   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1576 0073643-02-001 Pang Fred S 1425 Minnesota Building 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   06/01/1987   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1578 0073643-03-001 Pang Fred S Lucky Foods Products Co 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   01/01/2002   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1587 0073643-04-001 Pang Fred S Sin Ma Imports Co 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   01/01/2002   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
1610 0073643-05-001 Pang Fred S San Francisco Oils 1425 Minnesota St San Francisco 1 CA 1 94107 22 11/15/1972   12/09/2011   1425 Minnesota St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1425 MINNESOTA ST San Francisco, CA 94107 (37.751621, -122.38959)
2219 0074290-01-001 Farnan William T Farnan Studios 2339 Third St 21 San Francisco 1 CA 1 94107 22 08/01/1972   12/01/2009   2339 3rd Street Suite 21 San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     10 4 Potrero Hill 28   2339 THIRD ST San Francisco, CA 94107 (37.760275, -122.388434)

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