home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by City

View and edit SQL

Suggested facets: NAICS Code Description, Supervisor District, Business Corridor

Link rowid Location Id Ownership Name DBA Name Street Address City ▼ State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
401 0049323-06-999 Iron Mountain Inform Mgt Inc Iron Mountain Info Mgmt Inc 336 Oyster Point Blvd     94099 46 01/15/1998   01/01/2010   1 Federal St 7th Fl Boston 50 02110 79 MA 4800-4999 12 Transportation and Warehousing 12 0 0           336 OYSTER POINT BLVD 94099 (37.662455, -122.386587)
960 0473976-02-999 Boomerang Wireless Llc Boomerang Wireless Llc 955 Kacena Rd A     52233 68 09/01/2012   09/01/2012   740 Florida Central Parkway Suite #2028 Longwood 88 32750 133 FL 5100-5199 15 Information 15 0 0           955 KACENA RD A 52233 (42.054198, -91.68422)
968 0009563-04-999 Bridgestone Retail Operati,llc Bridgestone/firestone Inc 1200 Firestone Parkway     44317 69 10/01/1968   01/01/1988   535 Marriott Dr Nashville 89 37214 134 TN 4400-4599 3 Retail Trade 3 0 0           1200 FIRESTONE PARKWAY 44317 (41.05187, -81.529109)
1780 0373455-01-999 Dohrer Vicky L V Technologies 26 County Rd 4025     81137 93 01/15/2004   01/15/2004   133 Atwell Drive Statesville 129 28677 192 NC     0 0           26 COUNTY RD 81137
3027 0447002-02-999 World Communications Inc World Communications Inc 5909 Nw Expressway Ste 101     73132 126 12/01/2009   12/01/2009   Po Box 720128 Oklahoma City 187 73172 276 OK     0 0           5909 NW EXPRESSWAY 73132 (35.550748, -97.621692)
3912 0005033-02-999 Meda Pharmaceuticals Inc Medpointe Healthcare Inc 265 Davidson Ave #300 S     8875 156 10/01/1968   09/29/2001   Po Box 4310 Morgantown 220 26504 318 WV 3100-3399 10 Manufacturing 10 0 0           265 DAVIDSON AVE S 08875 (40.533448, -74.527655)
4352 0005906-01-999 Cleveland Wrecking Co Cleveland Wrecking Co 628 East Edna Pl     91723 168 10/01/1968   06/06/2007   4840 Cox Road Glen Allen 237 23060 341 VA     0 0           628 EAST EDNA PL 91723 (34.093033, -117.878486)
4904 0462565-01-999 West Am Llc West Am Llc 421 E 34th St     79103 184 10/11/2010   10/11/2010   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           421 E 34TH ST 79103
5256 0470815-01-999 Greenfly Networks Inc Clearfly Communications 550 S 24th St W 201     59102 194 04/01/2012   04/01/2012   8675 W 96th St #220 Overland Park 204 66212 403 KS 5100-5199 15 Information 15 0 0           550 S 24TH ST W 59102 (45.759966, -108.576274)
5756 0478759-01-999 Gray Anthony Photo Magic By Tony 2200 High St     94001 208 04/25/2013 05/31/2014 04/25/2013 05/31/2014             0 0           2200 HIGH ST 94001 (38.748811, -82.972768)
6002 0332315-08-999 Sephora Usa Inc Sephora Usa San Francisco Intl Airport     94000 216 04/01/1999   10/16/2003 01/01/2016 525 Market St. 32nd Floor San Francisco 1 94105 5 CA 4400-4599 3 Retail Trade 3 0 0           SAN FRANCISCO INTL AIRPORT 94000 (37.78008, -122.420168)
6352 0486877-01-999 Big Red Construction Big Red Cosntruction 946 Hough Ave     94649 224 02/07/2014   02/07/2014   946 Hough Ave Lafayette 146 94549 217 CA     0 0           946 HOUGH AVE 94649
8801 0370294-03-999 Covista Inc Covista Inc 225 E 8th St 400     37402 273 01/01/2003   09/30/2009   740 Florida Central Pkwy #2028 Longwood 88 32750 133 FL     0 0           225 E 8TH ST 37402 (35.046689, -85.306408)
13019 0161464-04-999 Cooper Edward F Edward Cooper Roofing & Const 24 Convent Ct     94910 374 01/20/1987 05/11/2015 01/15/2009 05/11/2015             0 0           24 CONVENT CT 94910 (37.987002, -122.513086)
13292 0182969-02-999 Mckesson Medical Surgical Inc Mckesson Medical Surgical Inc 8741 Landmark Rd     23228 386 01/01/1988   07/27/2001   Po Box 819066 Dallas 194 75381 744 TX 4200-4299 7 Wholesale Trade 7 0 0           8741 LANDMARK RD 23228 (37.632214, -77.506293)
13530 0184397-02-999 Safety Kleen Systems Inc Eds Safety Kleen Accts Payable 3300 Sw 34th Ave #101     34474 396 01/01/1989   10/01/2002 12/31/2015 42 Longwater Drive Norwell 470 02061 758 MA 2300-2399 6 Construction 6 0 0           3300 SW 34TH AVE 34474 (29.152585, -82.178057)
14094 0187760-01-999 Alfa Laval Inc Alfa Laval Inc. 5400 International Trade Drive     23231 408 01/01/1989   01/01/1989   Po Box 50361 Richmond 98 23250 779 VA 4400-4599 3 Retail Trade 3 0 0           5400 INTERNATIONAL TRADE DRIVE 23231 (37.528059, -77.339462)
14231 0188513-02-999 Cardno Entrix Cardno Entrix 5252 Westchester St 250       10/18/2010 12/31/2014 10/18/2010 12/31/2014             0 0           5252 WESTCHESTER ST (29.726341, -95.430126)
15034 0150097-09-999 Hartmann Studios Incorporated Green Valley Plant Rental 100 W Ohio Ave       03/01/1993   01/01/1998   70 West Ohio Ave #H Richmond 98 94804 483 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           100 W OHIO AVE (37.930849, -122.37038)
15769 0198021-02-999 Henkels & Mccoy Inc Henkels & Mccoy Inc 2840 Ficus St     94766 454 06/25/1990 05/01/2015 06/11/2013 05/01/2015             0 0           2840 FICUS ST 94766 (34.021281, -117.735736)
17144 0191304-01-999 Oec Medical Systems Inc Oec Medical Systems Inc 384 Wright Bros Dr     84116 480 12/01/1987   12/01/1987   Po Box 60320 Fort Myers 115 33906 555 FL     0 0           384 WRIGHT BROS DR 84116
17382 0193404-02-999 Smiths Medical Asd, Inc. Smithsmedical Asd 10 Bowman Dr     3431 481 12/22/1989   02/17/2004   5200 Upper Metro Place Suite200 Dublin 390 43017 909 OH 3100-3399 4200-4299 23 Multiple 13 0 0           10 BOWMAN DR 03431 (42.958936, -72.330362)
18288 0303752-16-999 Labor Ready Inc Labor Ready Sw,inc 1103 Airport Blvd     94800 507 02/19/1997   01/01/2011   Po Box 2910 Tacoma 260 98401 374 WA 5600-5699 16 Administrative and Support Services 16 0 0           1103 AIRPORT BLVD 94800 (37.663181, -122.400954)
18892 0162551-32-999 Luxottica Retail N A Inc Sunglass Hut #4945 1 Airport-Term 32nd Fl Area F     77085 521 02/26/2009   01/01/2010   4000 Luxottica Mason 421 45040 675 OH 4400-4599 3 Retail Trade 3 0 0           1 AIRPORT FL AREA F 77085
19239 0170032-01-999 Chase National Corp Svcs Inc Chase National Corp Svcs Inc Bp1995yr Chase Manhattan Plaza 8th Fl     10081 523 01/01/1985 12/31/2016 11/01/1994 12/31/2016         5210-5239 11 Financial Services 11 0 0            
19407 0182272-03-999 Nestle Healthcare Nutrition In Nestle Healthcare Nutrition In 445 State St     49413 534 01/01/1988   01/23/2008   30500 Bainbridge Rd Solon 561 44139 898 OH     0 0           445 STATE ST 49413
19961 0182612-02-999 Grolier Publishing Co Inc Grolier Publishing Co Inc 1 Sherman Turnpike     6816 545 01/01/1988   11/01/1995   100 Plaza Dr Secaucus 154 07094 228 NJ 4200-4299 7 Wholesale Trade 7 0 0           1 SHERMAN TURNPIKE 06816 (41.288212, -73.37322)
20544 0313787-02-999 Linear Options Inc Linear Options Inc 792 Durham Dayton Hwy     95939 556 02/01/2002 11/17/2014 04/09/2012 11/17/2014             0 0           792 DURHAM DAYTON HWY 95939 (39.646855, -121.728084)
20703 0314351-01-999 Nosaj Disposables Inc Nosaj Disposables Inc 235 Ellison St     7509 563 01/09/1998   01/09/1998   4508 Oak Fair Blvd 230 Ste Tampa 210 33610 995 FL 4200-4299 7 Wholesale Trade 7 0 0           235 ELLISON ST 07509 (40.917152, -74.167115)
21273 0316859-01-999 Weston Telecommunications,llc Easton Telecom Svcs. Inc. 3046 Breckville Rd Ii-A     44286 575 02/01/1998   02/01/1998   3838 Carson St. Ste 200 Fax: 310-792-8272 Torrence 621 90503 938 CA     0 0           3046 BRECKVILLE RD II-A 44286 (41.218664, -81.638061)
21533 0318211-01-999 Custom Network Solutions Inc Custom Network Solutions Inc 1351 Camelot Lane     60439 583 01/01/1998   01/01/1998   3838 Carson St. Ste 200 Torrance 268 90503 938 CA     0 0           1351 CAMELOT LANE 60439 (41.663679, -87.972679)
22520 0322098-06-999 Siemens Industry Inc Siemens Industry Inc. 3765 Yale Way     34538 607 01/01/1999   10/01/2012   Po Box 80600 Indianapolis 105 46280 248 IN 2300-2399 6 Construction 6 0 0           3765 YALE WAY 34538 (37.509307, -121.948)
22536 0189904-01-999 Kentec Medical Inc Kentec Medical Inc 17871 Fitch St     92714 608 01/01/1989   01/01/1989   17871 Fitch St Irvine 112 92614 570 CA 4200-4299 4400-4599 13 Multiple 13 0 0           17871 FITCH ST 92714
23443 0325766-02-999 Horizon Retail Constr Inc Horizon Retail Constr Inc 1458 Horizon Blvd     53406 619 04/12/1999   10/15/2001   1500 Horizon Dr Sturtevant 661 53177 1092 WI 2300-2399 6 Construction 6 0 0           1458 HORIZON BLVD 53406 (42.714447, -87.848922)
23959 0310156-01-999 Business Telecom Inc Business Telecom Inc 4300 Six Forks Rd Suite 500     27609 633 05/01/1994 09/30/2013 05/01/1994 09/30/2013             0 0           4300 SIX FORKS RD 27609 (35.838428, -78.641588)
24148 0329017-03-999 Pro Installations Inc Pro Spectra Contract Flooring 8320 Camino Sante Fe 1     82122 640 09/15/2008   08/01/2011   Po Box 2128 Po Box 2128 Md 95 03 Dalton 678 30722 1114 GA     0 0           8320 CAMINO 82122
24220 0311351-01-999 Bellaver Tony V Bella Fine Art 4325 Market St     94068 641 01/01/1998   08/02/1999   4325 Market St Oakland 27 94608 35 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           4325 MARKET ST 94068 (37.83345, -122.273219)
24390 0303199-01-999 Orr Bonnie U The Cherry Street Collection 25 Woodland Dr Auon Ct     6001 648 02/20/1997   05/25/1999   1155 Jones St Apt 401 San Francisco 1 94109 7 CA     0 0           25 WOODLAND DR AUON CT 06001 (41.796357, -72.859305)
24814 0302644-01-999 Smith & Nephew Inc Smith & Nephew Inc 1450 Brooks Rd     38116 661 01/01/1997   01/01/1997   150 Minuteman Road Andover 235 01810 338 MA 4200-4299 7 Wholesale Trade 7 0 0           1450 BROOKS RD 38116 (35.061281, -90.0155)
25039 0332315-07-999 Sephora Usa Inc Sephora Usa San Francisco Intl Airport     94000 216 04/01/1999   10/16/2003 01/01/2016 251 Little Falls Dr Wilmington 218 19808 316 DE 4400-4599 3 Retail Trade 3 0 0           SAN FRANCISCO INTL AIRPORT 94000 (37.78008, -122.420168)
25699 0334488-03-999 Bond Blacktop Inc Bond Blacktop Inc 27607 Industrial Blvd       09/07/2013 05/31/2014 09/07/2013 05/31/2014             0 0           27607 INDUSTRIAL BLVD (37.624693, -122.103936)
25846 0334987-01-999 Costello Sean M Cobur Securities 205 Wurr Rd     94021 675 03/14/2000   03/14/2000   205 Wurr Road Po Box 326 La Honda 707 94020 1159 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           205 WURR RD 94021 (37.271735, -122.30534)
26197 0332315-02-999 Sephora Usa Inc Sephora #14 San Fran Intl Airport     94000 216 04/01/1999   01/01/2002 01/01/2016 251 Little Falls Dr Wilmington 218 19808 316 DE 4400-4599 3 Retail Trade 3 0 0           SAN FRAN INTL AIRPORT 94000 (37.78008, -122.420168)
27344 0332315-03-999 Sephora Usa Inc Sephora #16 San Fran Intl Airport     94000 216 04/01/1999   01/01/2002 01/01/2016 251 Little Falls Dr Wilmington 218 19808 316 DE 4400-4599 3 Retail Trade 3 0 0           SAN FRAN INTL AIRPORT 94000 (37.78008, -122.420168)
27975 0330804-01-999 Arana Miguel A Miguels Steam Cleaning 431 Gatehouse Dr.     95697 717 10/01/1999   10/01/1999   Po Box 1682 Vacaville 229 95696 568 CA 8100-8139 5 Certain Services 5 0 0           431 GATEHOUSE DR 95697 (38.359472, -121.940517)
28537 0344938-01-999 Zone Telecom, Inc. Zone Telecom Inc 459 Oak Shade Rd Shamong Nj     8088 727 11/01/2000   11/01/2000   7460 Warren Parkway Suite 218 Frisco 741 75034 1221 TX 2200-2299 29 Utilities 18 0 0           459 OAK SHADE RD SHAMONG, NJ 08088 (39.813494, -74.762656)
28779 0345852-01-999 Mcleodusa Tlcmmnctns Srvcs Inc Mcleodusa Tlcmmnctns Srvcs Inc 6400 C St Sw     52406 732 03/01/2002 06/01/2016 03/01/2002 06/01/2016         5100-5199 15 Information 15 0 0           6400 C ST SW 52406 (41.915311, -91.637236)
28831 0346028-01-999 Medtronic Sofamor Danek Usa Medtronic Sofamor Danek Usa 1800 Pyramid Pl     38132 737 01/01/2000   01/01/2000   710 Medtronic Pkwy Ls195 Minneapolis 19 55432 975 MN 4200-4299 7 Wholesale Trade 7 0 0           1800 PYRAMID PL 38132 (35.072698, -90.002283)
30287 0351320-01-999 Enhanced Communications (Ecg) Enhanced Communications Grp Lc 312 S.e. Delaware-Bartlesville Ok     74003 769 06/01/2001   06/01/2001   242 Rangeline Rd Longwood 88 32750 133 FL     0 0           312 S E DELAWARE BARTLESVILLE, OK 74003 (36.749917, -95.972091)
30288 0351320-02-999 Enhanced Communications (Ecg) Enhancedcommunication 312s.e.delware-Bartlesville Ok     74003 769 06/01/2001   06/01/2001   242 Rangeline Rd Longwood 88 32750 133 FL     0 0           312S E DELWARE BARTLESVILLE, OK 74003
31816 0356330-01-999 Onstar Corp On Star Corporation 300 Renaissence Ctr Mc482-C14-C66     48265 796 05/01/2002   05/01/2002   300 Renaissance Center Mc 482 C14 C66 Detroit 162 48265 1319 MI     0 0           300 RENAISSENCE CTR 48265 (42.329821, -83.040801)
34486 0353759-01-999 Aerotek Inc Aerotek, Inc. 7301 Parkway Dr     31076 843 01/01/2002   01/01/2002   7301 Parkway Dr Hanover 689 21076 1130 MD     0 0           7301 PARKWAY DR 31076
35295 0366680-01-999 Bard Access Systems Inc Bard Access Systems Inc 5425 W Amelia Earhart Dr     84116 480 01/01/2003   01/01/2003   730 Central Ave Murray Hill 457 07974 733 NJ 4400-4599 3 Retail Trade 3 0 0           5425 W AMELIA EARHART DR 84116 (40.77629, -112.021002)
35330 0366784-01-999 Wallace Munoz V All City Security Systems 7032 Comstock Ave. 208     90602 405 04/30/2003   04/30/2003   Po Box 4726 Whittier 485 90607 776 CA     0 0           7032 COMSTOCK AVE 90602 (33.977808, -118.038591)
36337 0369896-08-999 Digby Adler Group Llc Digby Adler Group Llc 2850 Nw 40th Ave     33142 890 09/01/2003   01/01/2013   2200 Cesar Chavez #16 San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2850 NW 40TH AVE 33142 (25.80163, -80.261785)
36492 0361163-01-999 Bound Tree Medical Llc Bound Tree Medical Llc 6106 Busch Rd     43119 891 09/01/2002   09/01/2002   Po Box 8023 Dublin 390 43016 1443 OH 4200-4299 7 Wholesale Trade 7 0 0           6106 BUSCH RD 43119 (39.905196, -83.158573)
36629 0357127-01-999 Culinary Solutions Llc Culinary Solutions Llc 310 S Stanwood Rd     43209 898 06/20/2002   06/25/2008   548 2nd St Woodland 870 95695 1447 CA 7220-7229 8 Food Services 8 0 0           310 S STANWOOD RD 43209 (39.963856, -82.928111)
36693 0370880-01-999 Virgin Mobile Usa Lp Virgin Mobile Usa, Lp 10 Independence Blvd.warren Nj     90860 902 03/29/2002   03/29/2002   6200 Sprint Parkway 2bttx Overland Park 204 66251 302 KS 2200-2299 29 Utilities 18 0 0           10 INDEPENDENCE BLVD WARREN, NJ 90860 (40.651897, -74.573561)
36734 0371034-01-999 Respironics Inc Respironics Inc 1010 Murry Ridge Lane     15668 903 10/01/2003   10/01/2003   3000 Minuteman Road Mail Stop 5301 Andover 235 01810 338 MA 4400-4599 3 Retail Trade 3 0 0           1010 MURRY RIDGE LANE 15668 (40.485497, -79.695265)
37905 0363028-02-999 Merker Jonathan A Jon's School Of Music 1605 Church St     84131 931 01/24/2003 05/01/2016 03/01/2013 05/01/2016             0 0           1605 CHURCH ST 84131
38382 0375775-01-999 Enterasys Networks Inc Enterasys Networks Inc 35 Industrial Way     3867 939 03/30/2003   03/30/2003   9 Northeastern Blvd Ste 300 Salem 460 03079 1495 NH     0 0           35 INDUSTRIAL WAY 03867 (43.310483, -70.998692)
39595 0367361-01-999 National Security Services National Security Services 343 El Camino Real     95080 969 06/09/2003   06/09/2003   940 Park Avenue San Jose 10 95126 95 CA     0 0           343 EL CAMINO REAL 95080 (31.468283, -111.000143)
39932 0379915-32-999 Ambrose Employer Group Llc Financial Products Llc 7950 West Sunset Blvd Apt 313     94006 979 01/01/2004 12/31/2013 03/15/2011 12/31/2013             0 0           7950 WEST SUNSET BLVD 94006 (34.098034, -118.363342)
40465 0379982-01-999 Show Services Llc Show Services Llc 616 Jealouse Wy     75104 988 07/29/2004   07/29/2004   Po Box P O Box 1269 Springtown 920 76082 1541 TX 2300-2399 6 Construction 6 0 0           616 JEALOUSE WY 75104 (32.575274, -96.964811)
40806 0373541-01-999 Cooper Jim B Cooptek 278 1st Ave       02/02/2004 02/25/2015 02/02/2004 02/25/2015             0 0           278 1ST AVE (37.366911, -79.904083)
41396 0372835-01-999 Moonka Nishi Nishi Moonka 105 Galisteo Ct       12/08/2003 05/21/2016 12/08/2003 05/21/2016             0 0           105 GALISTEO CT (37.760329, -121.977793)
41995 0385091-01-999 Ernest Communications Ernest Communications 1979 E Osceola Pkwy     34743 1014 01/01/2005   01/01/2005   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           1979 E OSCEOLA PKWY 34743 (28.345028, -81.364876)
42286 0385766-01-999 Granite Telecommunications Llc Granite Telecommunications Llc 1702 W Main Street     35960 1022 01/01/2005   01/01/2005   1050 Crown Pointe Parkway 1500 Ste Atlanta 298 30338 1572 GA 2200-2299 29 Utilities 18 0 0           1702 W MAIN STREET 35960 (34.159493, -85.708881)
43314 0388132-01-999 Balfour Beatty Rail Sys Inc Balfour Beatty Rail Sys Inc 4390 Imeson Rd     32219 1042 05/18/2005 01/01/2014 05/18/2005 01/01/2014             0 0           4390 IMESON RD 32219 (30.374012, -81.77291)
45115 0384068-02-999 Oliso Inc Oliso Inc 4 Valley View Dr     7045 1067 12/01/2004 09/30/2015 01/01/2013 09/30/2015         4200-4299 7 Wholesale Trade 7 0 0           4 VALLEY VIEW DR 07045 (40.889089, -74.349956)
45387 0393111-01-999 Nii Communications Nii Communications Ltd 2855 S Congress Ave     33445 1072 10/01/2005   10/01/2005   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           2855 S CONGRESS AVE 33445 (26.428581, -80.092244)
45434 0393234-01-999 American Chemical Society Chemical Abstracts Service 2540 Olentangy River Rd     43210 1075 01/01/1992   01/01/1992   1155 Sixteenth St Nw Washington 291 20036 1273 DC     0 0           2540 OLENTANGY RIVER RD 43210
45709 0393943-01-999 Heritage Security & Invstg.inc Heritage Security & Invstg. 2050 Russet Wy.#139     89730 1084 01/02/2006 09/25/2014 01/02/2006 09/25/2014             0 0           2050 RUSSET WY 89730 (39.179605, -119.767965)
48350 0399321-01-999 Allied Propane Service, Inc. Allied Propane Service, Inc. 5000 Seaport Ave     85804 1117 01/01/1988   01/01/1988   5000 Seaport Ave Richmond 98 94804 483 CA     0 0           5000 SEAPORT AVE 85804 (37.912035, -122.327404)
48869 0400381-01-999 Glenn Tofaini Advanced Constru Advanced Construction Tech 77 Bunsen     2618 1125 07/24/2006   07/24/2006   77 Bunsen Irvine 112 92618 167 CA 2300-2399 6 Construction 6 0 0           77 BUNSEN 02618 (33.640105, -117.740369)
49257 0401224-02-999 Emp Industries Inc Emp Industries Inc 2985 44th Ave N     33714 1134 09/05/2006   03/14/2007   1330 2nd St S Saint Petersburg 1022 33701 1007 FL     0 0           2985 44TH AVE N 33714 (27.81228, -82.673916)
49815 0402277-01-999 Kim Young Nam Archbest Construction 114 Santa Ana St     94866 1147 09/22/2006   09/22/2006   2600 San Leandro Blvd Apt 808 San Leandro 25 94578 562 CA     0 0           114 SANTA ANA ST 94866 (37.965244, -122.340957)
50551 0403800-01-999 Mountain Cascade Inc Mountain Cascade Inc 555 Exchange Ct     92537 1166 05/31/2013 01/01/2016 05/31/2013 01/01/2016         2300-2399 6 Construction 6 0 0           555 EXCHANGE CT 92537 (42.128348, -87.925296)
51475 0405702-01-999 Alaeli Ibrahim A Alaeli Ibrahim A 1332 Peralta St     94699 1184 01/01/2007 12/31/2009 01/01/2007 12/31/2009             0 0           1332 PERALTA ST 94699 (37.811228, -122.29405)
52241 0405901-01-999 Amirehsani Manoch Amirehsani Manoch 6 Wintergreen Terrace     94902 1189 01/01/2007 05/30/2017 01/01/2007 05/30/2017             0 0           6 WINTERGREEN TERRACE 94902 (38.016139, -122.556398)
53064 0408815-01-999 Klebanov Joseph Klebanov Joseph 1638 Ashwood Dr     94853 1195 01/01/2007   01/01/2007   603 Port St S Non None Calistoga 141 94515 208 CA 4800-4999 12 Transportation and Warehousing 12 0 0           1638 ASHWOOD DR 94853 (37.982421, -122.097316)
53181 0407857-01-999 Golchehreh David Golchehreh David 2972 Morgan Drive     94958 1197 01/01/2007 01/01/2012 01/01/2007 01/01/2012             0 0           2972 MORGAN DRIVE 94958 (37.75724, -121.976104)
53319 0409247-01-999 Lintz James M Lintz James M 1097 Alamo Ct     94654 1198 01/01/2007   01/01/2007   1126 Gilman Ave San Francisco 1 94124 6 CA     0 0           1097 ALAMO CT 94654 (38.015023, -121.933783)
56115 0414517-02-999 Academyx Inc Academyx Inc 180 Promenade Circle 110     95384 1227 01/01/2007   01/01/2009   601 Montgomery St #409 San Francisco 1 94111 11 CA 6100-6299 4 Private Education and Health Services 4 0 0           180 PROMENADE CIRCLE 95384 (28.760652, -81.370254)
57492 0416529-02-999 Paychex North America Inc Paychex North America Inc 1111 Bayhill Dr 350     64066 1239 01/01/2003   03/21/2011   911 Panorama Trail South Rochester 207 14625 1490 NY 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1111 BAYHILL DR 64066
58171 0417706-01-999 Smart Choice Comms. Llc Smart Choice Comms. Llc 483 Freedom Plains Road     12603 1245 01/01/2007   01/01/2007   56 W 45th Street Fl 2nd New York 49 10036 1129 NY 2200-2299 29 Utilities 18 0 0           483 FREEDOM PLAINS ROAD 12603 (41.680347, -73.854734)
58298 0417202-02-999 Automatic Fire Inc Automatic Fire Inc 536 Lewelling Blvd     94529 1248 10/12/2010   10/08/2010   Po Box 21241 Concord 42 94521 70 CA 4400-4599 3 Retail Trade 3 0 0           536 LEWELLING BLVD 94529 (37.686607, -122.134211)
58783 0418891-02-999 Morris Visitor Publication Llc San Francisco Guest Informant 725 Broad St     30901 1256 01/01/2007   01/01/2007   Po Box 936 Augusta 1119 30903 1910 GA 5100-5199 15 Information 15 0 0           725 BROAD ST 30901 (33.474712, -81.963512)
58784 0418891-03-999 Morris Visitor Publication Llc San Francisco Where Map 725 Broad St     30901 1256 01/01/2007   01/01/2007   Po Box 936 Augusta 1119 30903 1910 GA 5100-5199 15 Information 15 0 0           725 BROAD ST 30901 (33.474712, -81.963512)
58785 0418891-04-999 Morris Visitor Publication Llc San Francisco Where 725 Broad St     30901 1256 01/01/2007   01/01/2007   Po Box 936 Augusta 1119 30903 1910 GA 5100-5199 15 Information 15 0 0           725 BROAD ST 30901 (33.474712, -81.963512)
58786 0418891-05-999 Morris Visitor Publication Llc San Francisco Cruise Guide 725 Broad St     30901 1256 01/01/2007   01/01/2007   Po Box 936 Augusta 1119 30903 1910 GA 5100-5199 15 Information 15 0 0           725 BROAD ST 30901 (33.474712, -81.963512)
59981 0421325-01-999 Wholesale Carrier Services Inc Wholesale Carrier Services Inc 5471 N University Dr     33067 1277 08/01/2007   08/01/2007   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           5471 N UNIVERSITY DR 33067 (26.296231, -80.249586)
60117 0421599-01-999 Saft America Inc Saft America Inc 711 Gill Harbin Industrial Blvd     31601 1280 01/01/2007   01/01/2007   13575 Waterworks St Jacksonville 81 32221 1938 FL 3100-3399 10 Manufacturing 10 0 0           711 GILL HARBIN INDUSTRIAL BLVD 31601 (30.802648, -83.287621)
60536 0420839-01-999 Ascencion Flores Ismael O Big Noah Hauling 10412 Arcata Ct       08/17/2007   08/17/2007   Po Box 690411 Stockton 134 95269 1951 CA     0 0           10412 ARCATA CT (38.049907, -121.364639)
60559 0422437-01-999 Ntt America Inc Ntt America Inc 101 Park Ave 41st Fl     10178 1288 04/30/2010   04/30/2010   8300 E. Maplewood Ave Ste 400 Greenwood Village 250 80111 346 CO     0 0           101 PARK AVE 10178 (40.750849, -73.978439)
60783 0421412-01-999 Gp Communications Llc Gp Communications Llc 2016 Riverside Drive     24540 1293 01/01/2007   01/01/2007 12/31/2014 8675 W 96th St 220 Overland Park 204 66212 403 KS 5100-5199 15 Information 15 0 0           2016 RIVERSIDE DRIVE 24540 (36.595933, -79.403906)
62578 0426141-01-999 Mgt Of America Inc Mgt Of America Inc 2123 Centre Pointe Blvd     32308 1317 08/01/2007   08/01/2007   3800 Esplanade Way 210 Ste Tallahassee 468 32311 1981 FL 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2123 CENTRE POINTE BLVD 32308 (30.474995, -84.239465)
62671 0426307-02-999 Almendarez Marcia Bay Area Janitorial & Handymen 1557 69th Ave     94671 1320 03/11/2013   03/11/2013 04/30/2014 2428 Havenscourt Blvd Oakland 27 94605 469 CA 2300-2399 6 Construction 6 0 0           1557 69TH AVE 94671 (37.761882, -122.188606)
63254 0427236-01-999 Duran Manuel J Gone Pro Services 1575 Ferndale Dr     95718 1339 03/22/2008 10/01/2008 03/22/2008 10/01/2008             0 0           1575 FERNDALE DR 95718 (37.242557, -121.901245)
64245 0428967-01-999 Wdt Wireless Telecomm., Inc. Wdt Wireless Telecomms., Inc. 5909 Nw Expressway 101     73132 126 01/01/2008 12/31/2015 01/01/2008 12/31/2015             0 0           5909 NW EXPRESSWAY 73132 (35.550748, -97.621692)

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