home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

126 rows where Mail City = 100

View and edit SQL

Suggested facets: City, Location End Date, Mail Zipcode, NAICS Code, NAICS Code Description, Parking Tax, Transient Occupancy Tax, LIC Code, LIC Code Description, Supervisor District, 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
1229 0064249-04-001 Gary D. Nelson Associates Inc Nelson 425 California St 600 San Francisco 1 CA 1 94104 1 05/17/1971   05/17/1971 02/01/2015 19080 Lomita Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   425 CALIFORNIA ST San Francisco, CA 94104 (37.793038, -122.401382)
1231 0064249-05-001 Gary D. Nelson Associates Inc Nelson 425 California St 600 San Francisco 1 CA 1 94104 1 05/17/1971   05/17/1971 02/01/2015 19080 Lomita Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   425 CALIFORNIA ST San Francisco, CA 94104 (37.793038, -122.401382)
1534 0116378-01-001 Brown Wanda A Brown Ann Interiors 726 Lake St San Francisco 1 CA 1 94118 6 03/13/1979   03/13/1979   372 Engler St. Sonoma 100 95476 151 CA 4200-4299 7 Wholesale Trade 7 0 0     2 Inner Richmond 21   726 LAKE ST San Francisco, CA 94118 (37.786551, -122.467379)
1645 0369523-08-001 Tfswcs Llc Tfswcs 2300 16th St San Francisco 1 CA 1 94103 25 01/29/2013   01/29/2013   19481 Franquelin Pl Sonoma 100 95476 151 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Mission 12   2300 16TH ST San Francisco, CA 94103 (37.765632, -122.410113)
1979 0117238-01-001 Oneil Glenn W & Claudette 319 Duncan Apts 319 Duncan St San Francisco 1 CA 1 94131 14 08/29/1975   08/29/1975   706 5th St East Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   319 DUNCAN ST San Francisco, CA 94131 (37.746049, -122.427873)
2426 0074448-01-001 Maria Bude & Sylvia A May 61-67 Duncan St Apts 374 Connecticut St San Francisco 1 CA 1 94107 22 08/07/1972   01/15/1996   19060 Robinson Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   374 CONNECTICUT ST San Francisco, CA 94107 (37.761574, -122.397405)
4003 0444220-01-999 Bonney Inc Heat Wave Systems Po Box 1747 Sonoma 2 CA 1 95476 2 12/02/2009   12/02/2009   Po Box 1747 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0            
4982 0146528-01-001 Dempcy John M 37-41 Walter Apts 37 Walter St San Francisco 1 CA 1 94114 34 01/10/1984   01/10/1984   310 Francisco Dr Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30   37 WALTER ST San Francisco, CA 94114 (37.768516, -122.432403)
5004 0064249-01-001 Gary D. Nelson Associates Inc Nelson 425 California St 600 San Francisco 1 CA 1 94104 1 05/17/1971   05/17/1971 02/01/2015 19080 Lomita Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   425 CALIFORNIA ST San Francisco, CA 94104 (37.793038, -122.401382)
6892 0056240-01-001 Lewis Ralph & Harry 737-747 Beach St 737 Beach St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   444 Moon Mountain Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Russian Hill 5   737 BEACH ST San Francisco, CA 94109 (37.806604, -122.4211)
7137 0038505-01-001 Giovacchini Dino L & Jane 3035 Webster Apts 3035 Webster St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   648 Avenue Del Oro Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3035 WEBSTER ST San Francisco, CA 94123 (37.798809, -122.434146)
7152 0038505-01-002 Giovacchini Dino L & Jane 3035 Webster Apts 3035 Webster St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   648 Avenue Del Oro Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     2 Marina 2   3035 WEBSTER ST San Francisco, CA 94123 (37.798809, -122.434146)
8018 0109788-01-002 Berthoud Claude & Johanna 233 Dolores Apts 233 Dolores St San Francisco 1 CA 1 94110 18 08/25/1977   08/25/1977   1265 Craig Ave Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0           233 DOLORES ST San Francisco, CA 94110 (37.765664, -122.426407)
8414 0068447-01-001 Wong Sam Ling & Lai Sheong 571 24th Av Apts 571 24th Ave San Francisco 1 CA 1 94121 15 07/26/1971   07/26/1971   21900 Arnold Dr Sonoma 100 95476 151 CA     0 0     1 6 Outer Richmond 9   571 24TH AVE San Francisco, CA 94121 (37.778779, -122.483577)
10156 0039907-01-001 Pariani John A 3224 Judah Apts 3224 Judah St San Francisco 1 CA 1 94122 19 10/01/1968   01/01/1970   19443 Marna Ln Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Sunset/Parkside 14   3224 JUDAH ST San Francisco, CA 94122 (37.760834, -122.496781)
10158 0039907-02-001 Pariani John A 3947 Mission Apts 3947 Mission St San Francisco 1 CA 1 94112 28 10/01/1968   10/01/1968   19443 Marna Ln Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Bernal Heights 19   3947 MISSION ST San Francisco, CA 94112 (37.734654, -122.425435)
11207 0109788-01-001 Berthoud Claude & Johanna 233 Dolores Apts 233 Dolores St San Francisco 1 CA 1 94103 25 08/25/1977   08/25/1977   1265 Craig Ave Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   233 DOLORES ST San Francisco, CA 94103 (37.765664, -122.426407)
14795 0191272-01-001 Commercial Lawyers Network In Commercial Lawyers Network Inc 667 Chenery St San Francisco 1 CA 1 94131 14 08/16/1989   01/01/2007   1130 Brockman Lane Sonoma 100 95476 151 CA     0 0     8 5 Glen Park 8   667 CHENERY ST San Francisco, CA 94131 (37.734528, -122.433274)
16489 0203652-02-001 Blue Richard P Richard Blue B Beach St Fishermans Wharf San+francisco 8 CA 1 94109 24 03/25/1991   07/01/2007   20680 Broadway Sonoma 100 95476 151 CA 4400-4599 3 Retail Trade 3 0 0           B BEACH ST FISHERMANS WHARF San Francisco, CA 94109 (37.792737, -122.420971)
20943 0196256-01-999 Abide International Inc Abide International Inc 561 1st Street West Sonoma Sonoma 2 CA 1 95476 2 04/01/1990   01/01/2008   561 1st St West Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           561 1ST STREET WEST SONOMA SONOMA, CA 95476 (38.291751, -122.459021)
22095 0311944-05-001 Rossdruliscusenbery Archtc Inc Rossdruliscusenbery Archtc Inc 926 Pierce St San Francisco 1 CA 1 94115 4 03/21/2012   03/21/2012   18294 Sonoma Highway Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     5 7 Western Addition 29   926 PIERCE ST San Francisco, CA 94115 (37.778458, -122.435116)
23611 0321536-01-999 Boldt David B Boldt Electric Company 19301 Carriger Rd Sonoma 2 CA 1 95476 2 11/01/1998   11/01/1998   19301 Carriger Rd Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           19301 CARRIGER RD SONOMA, CA 95476 (38.291706, -122.502994)
24944 0331881-01-001 Pacific Forensic Psych Assoc Sharp Program 1540 Market St 310 San Francisco 1 CA 1 94102 16 06/17/1999   02/28/2011 01/26/2017 19230 Sonoma Highway 200 Sonoma 100 94954 146 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1540 MARKET ST San Francisco, CA 94102 (37.774765, -122.419752)
26699 0338353-02-001 Coll Thomas G Coll Construction 1422 16th Ave San Francisco 1 CA 1 94122 19 10/14/2011   10/14/2011   Po Box 1391 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0     7 9 Inner Sunset 13   1422 16TH AVE San Francisco, CA 94122 (37.761352, -122.473743)
29071 0335140-01-999 Sonoma Access Control Systems Sonoma Access Control System 21600 8th East St Sonoma 2 CA 1 95476 2 02/20/2000   02/20/2000   21600 8th East St Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           21600 8TH EAST ST SONOMA, CA 95476 (38.260889, -122.440335)
31309 0349812-01-001 Friend Ruth 2713 44th Ave Apts 2713 44th Ave San Francisco 1 CA 1 94116 23 01/01/2002   01/01/2002   5060 Grove Street Sonoma 100 95476 151 CA 7210-7219 9 Accommodations 9 0 0     4 10 Sunset/Parkside 14   2713 44TH AVE San Francisco, CA 94116 (37.736008, -122.502048)
31598 0355473-01-999 Superior Services Llc North American Chem-Dry 1357 San Mateo Ave 1508 S+san+fran 9 CA 1 94080 17 01/01/2002   06/26/2009   Po Box 811 Sonoma 100 95476 151 CA 8100-8139 5 Certain Services 5 0 0           1357 SAN MATEO AVE S SAN FRAN, CA 94080 (37.643934, -122.410475)
32152 0357382-02-999 Sinotte Daniel E Earthstar Electric 170 Malet St Sonoma 2 CA 1 95476 2 07/08/2002   01/01/2008   170 Malet St Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           170 MALET ST SONOMA, CA 95476 (38.283256, -122.461952)
33957 0363180-01-001 Munsch Gene/petersen Steven Polk St Munsch Family Prtnrshp 2727 Polk St San Francisco 1 CA 1 94109 24 01/01/2003   01/01/2003   413 Saunders Dr Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Russian Hill 5   2727 POLK ST San Francisco, CA 94109 (37.80197, -122.422997)
36222 0369523-09-001 Tfswcs Llc Tfswcs 3035 Geary Blvd San Francisco 1 CA 1 94118 6 01/29/2013   01/30/2013   19481 Franquelin Pl Sonoma 100 95476 151 CA 4400-4599 3 Retail Trade 3 0 0     1 6 Lone Mountain/USF 24   3035 GEARY BLVD San Francisco, CA 94118 (37.781826, -122.451894)
38802 0369523-07-001 Tfswcs Llc Tfswcs 1200 19th Ave San Francisco 1 CA 1 94122 19 01/29/2013   01/30/2013   19481 Franquelin Pl Sonoma 100 95476 151 CA 4400-4599 3 Retail Trade 3 0 0     4 10 Inner Sunset 13   1200 19TH AVE San Francisco, CA 94122 (37.76512, -122.477221)
44093 0390103-01-001 Scinto Gia M Gia Scinto 115 15th Ave San Francisco 1 CA 1 94118 6 07/11/2005   07/11/2005   336 Napa Rd Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     1 6 Outer Richmond 9   115 15TH AVE San Francisco, CA 94118 (37.785895, -122.474366)
45525 0393525-02-001 Pearce Jason C Pearce Autotech 518 Brannan St San Francisco 1 CA 1 94107 22 10/01/2008   10/01/2008 07/25/2017 543 Avenue Del Oro Sonoma 100 95476 151 CA 4400-4599 3 Retail Trade 3 0 0 D23 Vehicle Repair Garage - Major 6 3 South of Market 15   518 BRANNAN ST San Francisco, CA 94107 (37.777873, -122.397105)
47486 0397620-01-999 Wolf Electric Inc Wolf Electric Inc 6475 Wild Horse Valley Rd Napa 80 CA 1 94558 125 01/01/2006   01/01/2006   Po Box 1506 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           6475 WILD HORSE VALLEY RD NAPA, CA 94558 (38.301287, -122.199967)
48969 0400591-01-999 San Felipe Services, Inc San Felipe Services, Inc 1545 N Castle Rd Sonoma 2 CA 1 95476 2 07/24/2006   07/24/2006   1545 N Castle Rd Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1545 N CASTLE RD SONOMA, CA 95476 (38.29961, -122.434554)
51773 0406232-01-999 Bastanmehr Nasser Bastanmehr Nasser 75 Gann Way Novato 42 CA 1 94949 123 01/01/2007   01/01/2007   20772 Temelec Dr. Sonoma 100 95476 151 CA     0 0           75 GANN WAY NOVATO, CA 94949 (38.059541, -122.516694)
52270 0407245-02-001 Diprima Rudi Diprima Rudi 5 Ruth St San Francisco 1 CA 1 94112 28 01/01/2007 01/01/2016 05/28/2013 01/01/2016   Sonoma 100 95476 151       0 0     11 Outer Mission 35   5 RUTH ST San Francisco, CA 94112 (37.723059, -122.436104)
53158 0408097-01-999 Harold Maurice J Harold Maurice J 516 Bokman Place Sonoma 2 CA 1 95476 2 01/01/2007   01/01/2007 07/25/2015 153 Bearflag Rd Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0           516 BOKMAN PLACE SONOMA, CA 95476 (38.315945, -122.486548)
53939 0410390-01-999 Palter Noel S Palter Noel S 17540 Highland Blvd Sonoma 2 CA 1 95476 2 01/01/2007   01/01/2007   17540 Highland Blvd Sonoma 100 95476 151 CA     0 0           17540 HIGHLAND BLVD SONOMA, CA 95476 (38.319071, -122.481542)
54892 0412251-01-999 Velez Jeffrey F Velez Jeffrey F 237 Picnic Ave #4 San+rafael 22 CA 1 94901 44 01/01/2007   01/01/2007   830 Donald St Sonoma 100 95476 151 CA     0 0           237 PICNIC AVE SAN RAFAEL, CA 94901 (37.965122, -122.52745)
58535 0418457-01-001 Betty J Droubi Lvg Trust Betty Jane Droubi 4120 24th St San Francisco 1 CA 1 94114 34 05/30/2007   05/30/2007   19201 Highway 12 Pmb 412 Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   4120 24TH ST San Francisco, CA 94114 (37.751257, -122.434736)
58660 0418653-01-001 Burgess Ronald & Debra Ronald & Debra Burgess 321 Chestnut San+francisco 8 CA 1 94109 24 06/01/2007   06/01/2007   1077 Sobre Vista Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           321 CHESTNUT San Francisco, CA 94109
59702 0419820-01-999 Bay Hydronic Inc Bay Hydronic Inc 19100 Riverside Dr Sonoma 2 CA 1 95476 2 07/01/2007   07/01/2007   Po Box 478 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           19100 RIVERSIDE DR SONOMA, CA 95476 (38.299588, -122.484687)
60325 0421925-03-001 Weaver Robynne R Weaver Mobile Notary 293 4th Ave 6 San Francisco 1 CA 1 94118 6 03/19/2014   03/19/2014   836 W Spain St Apt 3 Sonoma 100 95476 151 CA     0 0     1 6 Inner Richmond 21   293 4TH AVE San Francisco, CA 94118 (37.782987, -122.462277)
69271 0437986-01-001 Avery Marketing Inc Avery Marketing Inc 117 Greenwich St San Francisco 1 CA 1 94111 35 04/01/2009   04/01/2009   1008 Loma Ct Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   117 GREENWICH ST San Francisco, CA 94111 (37.803166, -122.402685)
70569 0440234-01-001 Von Koontz Raquel A B.e. 514 8th Av San Francisco 1 CA 1 94118 6 07/01/2009   07/01/2009 01/30/2014 17345 Buena Vista Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     1 6 Inner Richmond 21   514 8TH AV San Francisco, CA 94118 (37.778644, -122.466265)
70570 0440234-03-001 Von Koontz Raquel A Balanced Energies 514 8th Ave San Francisco 1 CA 1 94118 6 07/01/2009   07/01/2009 01/30/2014 17345 Buena Vista Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     1 6 Inner Richmond 21   514 8TH AVE San Francisco, CA 94118 (37.778644, -122.466265)
70571 0440234-05-001 Von Koontz Raquel A B.e. Balanced Energies 514 8th Ave San Francisco 1 CA 1 94118 6 07/01/2009   07/01/2009 01/30/2014 17345 Buena Vista Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     1 6 Inner Richmond 21   514 8TH AVE San Francisco, CA 94118 (37.778644, -122.466265)
70572 0440234-07-001 Von Koontz Raquel A Studio Balanced Energies 514 8th Ave San Francisco 1 CA 1 94118 6 07/01/2009   01/31/2014   17345 Buena Vista Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     1 6 Inner Richmond 21   514 8TH AVE San Francisco, CA 94118 (37.778644, -122.466265)
83402 0459043-01-001 Warrior One Llc Warrior One Llc 756 B Portola St San+francisco 8 CA 1 94129 42 01/01/2011   01/01/2011 09/21/2014 17830 Carriger Rd Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           756 B PORTOLA ST San Francisco, CA 94129 (37.794614, -122.454553)
94789 0472365-01-999 Saint Benoit Yogurt Corp Saint Benoit Creamery 1796 Pepper Rd Petaluma 37 CA 1 94952 63 08/12/2012   08/12/2012   22085 Carneros Vineyard Way Sonoma 100 95476 151 CA     0 0           1796 PEPPER RD PETALUMA, CA 94952 (38.284476, -122.751169)
96555 0474274-01-001 Burn Sf Llc Burn Sf 1043 Valencia St San Francisco 1 CA 1 94110 18 10/09/2012   10/09/2012   1114 Manor Drive Sonoma 100 95476 151 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     9 8 Mission 12   1043 VALENCIA ST San Francisco, CA 94110 (37.75619, -122.421057)
96557 0474274-02-001 Burn Sf Llc Burn Sf 673 Irving St San Francisco 1 CA 1 94122 19 10/09/2012   10/09/2012   1114 Manor Drive Sonoma 100 95476 151 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     5 7 Inner Sunset 13   673 IRVING ST San Francisco, CA 94122 (37.764104, -122.464962)
96558 0474274-03-001 Burn Sf Llc Burn Sf 1463 Broadway San Francisco 1 CA 1 94109 24 10/09/2012   10/09/2012   1114 Manor Drive Sonoma 100 95476 151 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     3 1 Russian Hill 5   1463 BROADWAY San Francisco, CA 94109 (37.796024, -122.420733)
98337 0476142-01-999 Exosports Llc Exosports 19481 Franquelin Pl Sonoma 2 CA 1 95476 2 01/29/2013   01/29/2013   19481 Franquelin Pl Sonoma 100 95476 151 CA     0 0           19481 FRANQUELIN PL SONOMA, CA 95476 (38.293567, -122.477814)
101507 0479451-01-999 North Counties Drywall Inc North Counties Drywall Inc 20563 Broadway Sonoma 2 CA 1 95476 2 04/29/2013   04/29/2013   Po Box 260 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           20563 BROADWAY SONOMA, CA 95476 (38.273784, -122.460637)
101640 0479585-01-999 Alcaraz Rodolfo Wine County Hvac 18664 Melody Ln Sonoma 2 CA 1 95476 2 05/22/2013   05/22/2013   18664 Melody Ln Sonoma 100 95476 151 CA     0 0           18664 MELODY LN SONOMA, CA 95476 (38.307227, -122.480305)
102950 0480914-01-999 Raftery Colman Tara Custom Painting 492 Patten St Sonoma 2 CA 1 95476 2 06/27/2013   06/27/2013   492 Patten St Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           492 PATTEN ST SONOMA, CA 95476 (38.289085, -122.448132)
103688 0481491-01-999 Vaio Bart Precision 4939 Grove St Sonoma 2 CA 1 95476 2 07/14/2013   07/14/2013   4939 Grove St Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           4939 GROVE ST SONOMA, CA 95476 (38.308064, -122.553261)
104875 0482886-01-999 Fullam John John Fullam 275 Leveroni Rd Sonoma 2 CA 1 95476 2 08/30/2013   08/30/2013   275 Leveroni Rd Sonoma 100 95476 151 CA     0 0           275 LEVERONI RD SONOMA, CA 95476 (38.27622, -122.464468)
108157 0486153-01-999 Pomeroy Richard Richard Allen Pomeroy Constrtn 175 E Thomson Ave Sonoma 2 CA 1 95476 2 01/01/2014   01/01/2014   175 E Thomson Ave Sonoma 100 95476 151 CA     0 0           175 E THOMSON AVE SONOMA, CA 95476 (38.310597, -122.477877)
111760 0489721-01-999 Browning Stewart W Aqua Stop Water Proofing 638 Craig Ave Hercules 98 CA 1 94547 157 05/19/2014   05/19/2014   638 Craig Ave Sonoma 100 95476 151 CA     0 0           638 CRAIG AVE HERCULES, CA 94547
112100 0490047-01-999 Pearce Jeff K Pearce Home Comfort 17359 Hillside Av Sonoma 2 CA 1 95476 2 05/29/2014   05/29/2014   17359 Hillside Av Sonoma 100 95476 151 CA     0 0           17359 HILLSIDE AV SONOMA, CA 95476 (38.320423, -122.482846)
115564 0924513-02-001 Brantseg Michael S Brantsegs Taekwondo 1755 Laguna St San Francisco 1 CA 1 94115 4 01/02/2001   01/02/2001   415 W Napa St Apt C Sonoma 100 95476 151 CA     0 0     5 7 Pacific Heights 16   1755 LAGUNA ST San Francisco, CA 94115 (37.787249, -122.428457)
118888 0943409-02-001 Rocket Science Inc Rocket Science 22 Shotwell St San Francisco 1 CA 1 94103 25 09/24/2007   09/24/2007 07/31/2014 1856 Sperring Rd Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           22 SHOTWELL ST San Francisco, CA 94103 (37.768015, -122.416665)
120801 0952599-02-999 Mc Mahon John F Mc Mahon Plumbing 939 Oak St Sonoma 2 CA 1 95476 2 03/02/1998   03/02/1998   939 Oak St Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           939 OAK ST SONOMA, CA 95476 (38.29626, -122.489572)
122061 1000815-07-141 Saint Benoit Yogurt Corp Saint Benoit Creamery 1 Ferry Building San Francisco 1 CA 1 94111 35 08/12/2012   08/12/2012   22085 Carneros Vineyard Way Sonoma 100 95476 151 CA     0 0 H34 Caterer Retail Food Vehicles       1 FERRY BUILDING SAN FRANCISCO, CA 94111
124378 1006666-09-141 Portal Construction Portal Construction 17247 Hillside Ave Sonoma 2 CA 1 95476 2 09/05/2014   09/05/2014   17247 Hillside Ave Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           17247 HILLSIDE AVE SONOMA, CA 95476 (38.322616, -122.482513)
126155 1009675-10-141 Warrior One Llc Warrior One Llc 17830 Carriger Rd Sonoma 2 CA 1 95476 2 01/01/2011   09/22/2014   17830 Carriger Rd Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           17830 CARRIGER RD SONOMA, CA 95476 (38.310861, -122.510345)
131539 1018795-02-151 Brady Patrick Brady Construction Company 18337 1st Ave Sonoma 2 CA 1 95476 2 02/11/2015   02/11/2015   18337 1st Ave Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           18337 1ST AVE SONOMA, CA 95476 (38.312048, -122.479417)
133539 1022318-03-151 Burn Sf Llc Burn Sf 1632 Market St San Francisco 1 CA 1 94102 16 10/09/2012   02/26/2015   1114 Manor Drive Sonoma 100 95476 151 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     5 7 Hayes Valley 10   1632 MARKET ST SAN FRANCISCO, CA 94102 (37.773742, -122.421187)
134157 1023411-03-151 Gary D. Nelson Associates Inc Gary D. Nelson Associates Inc 595 Market St 120 San Francisco 1 CA 1 94105 7 05/17/1971   02/01/2015   19080 Lomita Avenue Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 Financial District/South Beach 1   595 MARKET ST SAN FRANCISCO, CA 94105 (37.789648, -122.400916)
134743 1024407-03-151 1335-65 Columbus Avenue Llc 1335-65 Columbus Avenue Llc 1335 Columbus Ave San Francisco 1 CA 1 94133 11 03/20/2007   03/20/2007   1450 Castle Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Russian Hill 5   1335 COLUMBUS AVE SAN FRANCISCO, CA 94133 (37.806692, -122.419461)
139049 1031862-06-151 Alioto Family Trust Alioto Family Trust 430 Van Ness San+francisco 8 CA 1 94133 11 04/01/2007   04/01/2007   1450 Castle Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           430 VAN NESS SAN FRANCISCO, CA 94133
139307 1032342-07-151 Belozerova Yana Yana Belozerova 389 Arguello Blvd San Francisco 1 CA 1 94118 6 07/03/2015   07/03/2015 11/21/2016 19 Ramon St Sonoma 100 95476 151 CA     0 0     1 6 Inner Richmond 21   389 ARGUELLO BLVD SAN FRANCISCO, CA 94118 (37.783382, -122.459036)
139953 1033430-07-151 Rocket Science Inc Rocket Science 1856 Sperring Rd Sonoma 2 CA 1 95476 2 09/24/2007   08/01/2014   1856 Sperring Rd Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           1856 SPERRING RD SONOMA, CA 95476 (38.276172, -122.504427)
142377 1037236-08-151 Alioto Family Trust Alioto Family Trust 41 14th St San Francisco 1 CA 1 94103 25 04/01/2007   01/01/2015   1450 Castle Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   41 14TH ST SAN FRANCISCO, CA 94103 (37.768603, -122.414642)
143503 1039046-09-151 Harold Maurice J Harold Maurice J 153 Bearflag Rd Sonoma 2 CA 1 95476 2 01/01/2007   01/01/2007   153 Bearflag Rd Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0           153 BEARFLAG RD SONOMA, CA 95476 (38.259628, -122.49353)
149495 1049807-01-161 Sweet Jacqueline Zenzic Design 5360 Lovall Valley Rd Sonoma 2 CA 1 95476 2 11/23/2015   11/23/2015   5360 Lovall Valley Rd Sonoma 100 95476 151 CA     0 0           5360 LOVALL VALLEY RD SONOMA, CA 95476 (38.28999, -122.397526)
150675 1052066-02-161 Portraits To The People Llc Portraits To The People 5758 Geary Blvd #320 San+francisco 8 CA 1 94121 15 01/22/2016   01/22/2016   613 Joaquin Dr Sonoma 100 95476 151 CA     0 0           5758 GEARY BLVD SAN FRANCISCO, CA 94121 (37.780325, -122.481115)
151716 1054969-02-161 Olympia Moving & Storage Llc Olympia Moving & Storage Llc 2450 Newcomb Ave San Francisco 1 CA 1 94124 8 01/22/2016   01/22/2016   16762 La Placita Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0           2450 NEWCOMB AVE SAN FRANCISCO, CA 94124 (37.742661, -122.402879)
152068 1056146-02-161 Hyde Michael Mjh Construction Management 19374 Sleepy Hollow Ct Sonoma 2 CA 1 95476 2 02/25/2016   02/25/2016   19374 Sleepy Hollow Ct Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           19374 SLEEPY HOLLOW CT SONOMA, CA 95476 (38.294145, -122.482674)
152079 1056179-02-161 Event Rentals 3, Llc Bright Event Rentals 145 Park Ln Brisbane 54 CA 1 94005 84 05/13/2015   05/13/2015   22674 Broadway Ste A Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           145 PARK LN BRISBANE, CA 94005 (37.686619, -122.405045)
153224 1058530-03-161 Zenzic Design Zenzic Design 5360 Local Valley Rd Sonoma 2 CA 1 95476 2 01/01/2016   01/01/2016   5360 Local Valley Rd Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           5360 LOCAL VALLEY RD SONOMA, CA 95476
154121 1060280-03-161 White Paul Solas Electric 17336 Hillside Ave Sonoma 2 CA 1 95476 2 03/29/2016   03/29/2016   17336 Hillside Ave Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           17336 HILLSIDE AVE SONOMA, CA 95476 (38.320971, -122.48277)
154340 1060682-04-161 Lucchetti Living Trust Lucchetti Living Trust 1869-73 Lombard St San Francisco 1 CA 1 94123 3 01/01/2014   01/01/2014   499 Moon Mountain Rd Sonoma 100 95476 151 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1869 73 LOMBARD ST SAN FRANCISCO, CA 94123 (37.800281, -122.432218)
162257 1075612-06-161 John Walker Dba Stonework Cellars Engineering Contractor 410 Plum Tree Ct Sonoma 2 CA 1 95476 2 12/01/2016   12/01/2016   410 Plum Tree Ct Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0           410 PLUM TREE CT SONOMA, CA 95476 (38.292474, -122.446602)
163102 1077206-06-161 Gregory Slocum Sonoma, Ca San Francisco, Ca 17555 Johnson Ave Sonoma 2 CA 1 95476 2 08/02/2014   08/02/2014   17555 Johnson Ave Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0           17555 JOHNSON AVE SONOMA, CA 95476 (38.317145, -122.485019)
165981 1081776-07-161 Treanorhl Pa Treanor Architects, P.a. 460 Bush St San Francisco 1 CA 1 94108 9 05/02/2016   05/02/2016 01/26/2017 19230 Sonoma Highway 200 Sonoma 100 94954 146 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0            
165987 1081788-07-161 Anderson Development Anderson Development 555 Central Ave Ave Sonoma 2 CA 1 95476 2 07/07/2016   07/07/2016   555 Central Ave Ave Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0            
167960 1085143-07-161 Courville Michael Open Mind Consulting 657 Barrachi Way Sonoma 2 CA 1 95476 2 03/31/2014   05/31/2016   657 Barrachi Way Sonoma 100 95476 151 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0            
168224 1085545-07-161 Lake Merced Hill Recreation Lake Merced Hill Recreation 1100 Lake Merced Blvd San Francisco 1 CA 1 94132 32 01/02/2013   01/02/2013   Po Box 1368 Sonoma 100 95476 151 CA     0 0 H56 Swimming Pools (Year-Round) 7 9 Lakeshore 31    
170805 1090559-08-161 Jkt Associates Inc Jkt Associates Inc 21600 8th St Sonoma 2 CA 1 95476 2 08/18/2016   08/18/2016   Po Box 1875 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0            
173223 1098679-08-161 Rahwr, Inc. Sourced By Good 2169 Folsom St M202 San Francisco 1 CA 1 94011 357 08/28/2016   08/28/2016   17349 Park Ave Sonoma 100 95476 151 CA 4200-4299 7 Wholesale Trade 7 0 0     9 8 Mission 12    
176513 1105606-08-161 Uber Pukar Khadka 341 1st St Apt 2 Sonoma 2 CA 1 95476 2 12/23/2015   12/23/2015   341 1st St W 2 Apt Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
178452 1109886-08-161 Sherpa Pasang Pasang Sherpa 815 First St West 2 Sonoma 2 CA 1 95476 2 07/15/2016   07/15/2016   815 First St West 2 Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
180071 1113348-08-161 Bnfree Bnfree 846 3rd St Sonoma 2 CA 1 95476 2 07/16/2016   07/16/2016   846 3rd St W Sonoma 100 95476 151 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
184874 1122749-10-161 Rogala Michael Earlywood Carpentry 2620 Acacia Ave Sonoma 2 CA 1 95476 2 07/01/2016   07/01/2016   2620 Acacia Ave Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0            
189827 1132813-01-171 Iworkglobal Usa, Llc Iworkglobal Usa 19080 Lomita Ave Sonoma 2 CA 1 95476 2 01/02/2017   01/02/2017   19080 Lomita Ave Sonoma 100 95476 151 CA 5600-5699 16 Administrative and Support Services 16 0 0            
190036 1133206-01-171 George Kardum Maybelle Apartments 3440 24th St San Francisco 1 CA 1 94110 18 01/03/2017   01/03/2017   1204 Solano Ave Sonoma 100 95746 415 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12    

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