home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

70 rows where City = 153

View and edit SQL

Suggested facets: Business End Date, Location End Date, Mail City, Mail Zipcode, NAICS Code, NAICS Code Description, Transient Occupancy Tax

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
7279 0108494-22-999 Western Athletic Clubs Llc Ross Valley Swim&tennis Club 235 Bon Air Road Greenbrae 153 CA 1 94904 239 10/15/1977   11/01/2010 06/15/2015 1 Lombard St San Francisco 1 94111 11 CA     0 0           235 BON AIR ROAD GREENBRAE, CA 94904 (37.948881, -122.536402)
9050 0379956-05-999 Sandhu Nihsima Mahima Nihsima 243 Via La Cumbre Greenbrae 153 CA 1 94904 239 08/11/2004   01/01/2014   243 Via La Cumbre Greenbrae 79 94904 99 CA     0 0           243 VIA LA CUMBRE GREENBRAE, CA 94904 (37.950702, -122.513342)
12867 0064738-04-999 Booth & Little Inc Booth & Little Inc 2150 Redwood Hwy Greenbrae 153 CA 1 94904 239 10/01/1968 01/02/2012 04/17/2009 01/02/2012             0 0           2150 REDWOOD HWY GREENBRAE, CA 94904 (37.942067, -122.514453)
22563 0190052-01-999 Abadie Eileen S & Trust Etal 1554 Market St Property 206 S Ridgewood Rd Greenbrae 153 CA 1 94904 239 01/01/1989 05/21/2015 10/07/2000 05/21/2015             0 0           206 S RIDGEWOOD RD GREENBRAE, CA 94904 (37.94536, -122.556816)
25144 0332622-01-999 Sandhu Ann Style Solutions 243 Via La Cumbre Greenbrae 153 CA 1 94904 239 01/05/2000   02/01/2003   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           243 VIA LA CUMBRE GREENBRAE, CA 94904 (37.950702, -122.513342)
26240 0336318-03-999 Macdonald Susan A Bay Area Ergonomics 8 Altamira Av Greenbrae 153 CA 1 94904 239 10/17/2001   08/25/2009   8 Altamira Av Kentfield 64 94904 99 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           8 ALTAMIRA AV GREENBRAE, CA 94904 (37.958326, -122.54999)
30930 0333512-01-999 National Standard Inc General Product 58 Greenbrae Boardwalk Greenbrae 153 CA 1 94904 239 01/01/2000   04/15/2005   58 Greenbrae Boardwalk Greenbrae 79 94904 99 CA     0 0           58 GREENBRAE BOARDWALK GREENBRAE, CA 94904 (37.941768, -122.511569)
34258 0362578-02-999 Window & Door Factory Of Ca Window Factory 2100 Redwood Hwy Greenbrae 153 CA 1 94904 239 08/10/2007   08/10/2007   2100 Redwood Highway Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0           2100 REDWOOD HWY GREENBRAE, CA 94904 (37.939954, -122.515673)
53061 0408808-02-999 Kipnis Michael Kipnis Michael 175 Upper Via Casitas 25 Greenbrae 153 CA 1 94904 239 05/27/2014   05/27/2014   290 Via Casitas St 301 Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0           175 UPPER VIA GREENBRAE, CA 94904 (37.945943, -122.527635)
53591 0409775-01-999 Minyard Artemas G Minyard Artemas G 378 Via La Cumbre Greenbrae 153 CA 1 94904 239 01/01/2007   01/01/2007   378 Via La Cumbre Greenbrae 79 94904 99 CA     0 0           378 VIA LA CUMBRE GREENBRAE, CA 94904 (37.952179, -122.510838)
61074 0423493-03-999 Velazquez Miguel Angel M V Debis Removal 120 Lower Via Casitas 7 Greenbrae 153 CA 1 94904 239 02/18/2011 09/20/2016 02/18/2011 09/20/2016         2300-2399 6 Construction 6 0 0           120 LOWER VIA GREENBRAE, CA 94904 (37.945454, -122.526595)
63978 0427968-02-999 Andes General Construction Andes General Construction 336 Bon Air Center 104 Greenbrae 153 CA 1 94904 239 04/16/2008 12/31/2014 01/01/2010 12/31/2014             0 0           336 BON AIR CENTER GREENBRAE, CA 94904 (37.945608, -122.522429)
66295 0432659-01-999 Gillies Dan Construction Srvcs Dan Gillies Construction Srvcs 16 Elm Ave Greenbrae 153 CA 1 94904 239 09/08/2008   09/08/2008   16 Elm Avenue Kentfield 64 94904 99 CA 2300-2399 6 Construction 6 0 0           16 ELM AVE GREENBRAE, CA 94904 (37.957688, -122.548179)
68907 0437277-02-999 Pipe Spy Marin Inc Pipe Spy Marin Inc 2170 Redwood Highway Greenbrae 153 CA 1 94904 239 03/19/2009   01/01/2012   Po Box 503 Larkspur 77 94977 610 CA 2300-2399 6 Construction 6 0 0           2170 REDWOOD HIGHWAY GREENBRAE, CA 94904 (37.942657, -122.514347)
83122 0458708-01-999 Trinity Builders & Co Inc Trinity Builders & Co Inc 19 Laurel Grove Ave Greenbrae 153 CA 1 94904 239 12/21/2012 03/31/2013 12/21/2012 03/31/2013             0 0           19 LAUREL GROVE AVE GREENBRAE, CA 94904 (37.954611, -122.540327)
91249 0468457-01-999 Chenney James L Chenney Construction 2130 Redwood Hwy C-7 Greenbrae 153 CA 1 94904 239 04/20/2012 12/16/2014 04/20/2012 12/16/2014             0 0           2130 REDWOOD HWY GREENBRAE, CA 94904 (37.940396, -122.515571)
94865 0472443-01-999 Fiedler Carole Sue Angel Magic Media 336 Bon Air Center 244 Greenbrae 153 CA 1 94904 239 09/15/2012 11/01/2012 09/15/2012 11/01/2012             0 0           336 BON AIR CENTER GREENBRAE, CA 94904 (37.945608, -122.522429)
96256 0473953-01-999 Varganova A & Varganova V Aleks Limo Co 290 Via Casitas Way 306 Greenbrae 153 CA 1 94904 239 10/26/2012   10/26/2012   31 Tan Oak Way Novato 22 94949 215 CA 4800-4999 12 Transportation and Warehousing 12 0 0           290 VIA CASITAS WAY GREENBRAE, CA 94904 (37.946624, -122.528215)
98335 0475985-01-999 Pimentel Construction Inc Pimentel Construction 55 Corte Morada Greenbrae 153 CA 1 94904 239 01/23/2013 05/31/2013 01/23/2013 05/31/2013             0 0           55 CORTE MORADA GREENBRAE, CA 94904 (37.948213, -122.521463)
101218 0479156-01-999 Silva Pablo E West Coast Builders 722 Via Casitas Greenbrae 153 CA 1 94904 239 05/08/2013 06/30/2014 05/08/2013 06/30/2014             0 0           722 VIA CASITAS GREENBRAE, CA 94904
114755 0919369-01-999 Panoramic Software Inc Panoramic Software Inc 336 Bon Air Center 367 Greenbrae 153 CA 1 94904 239 02/01/1993   02/01/1993   32932 Pacific Coast Highway #14-482 Dana Point 1611 92629 2946 CA 5600-5699 16 Administrative and Support Services 16 0 0           336 BON AIR CENTER GREENBRAE, CA 94904 (37.945608, -122.522429)
122448 1002119-07-141 777 Plumbing Inc 777 Plumbing Inc 619 Via Casitas Greenbrae 153 CA 1 94904 239 07/22/2014   07/22/2014   619 Via Casitas Greenbrae 79 94904 99 CA     0 0           619 VIA CASITAS GREENBRAE, CA 94904
124625 1007134-09-141 Melvin William Daniel 201am 40 Rich St #C Greenbrae 153 CA 1 94904 239 01/10/2013 05/26/2015 01/10/2013 05/26/2015             0 0           40 RICH ST C GREENBRAE, CA 94904 (37.939496, -122.513893)
126889 1010896-11-141 Brownstein & Crane Surgical Sv Brownstein & Crane Surgical Sv 575 Sir Francis Drake Blvd 1 Greenbrae 153 CA 1 94904 239 01/01/2013 01/31/2013 02/01/2014 01/31/2013             0 0           575 SIR FRANCIS DRAKE BLVD GREENBRAE, CA 94904 (37.948341, -122.527435)
127124 1011256-11-141 Moncayo Michael G Moncayo Construction 121 Kent Ave #8 Greenbrae 153 CA 1 94904 239 10/10/2011   10/10/2011   Po Box 262 Kentfield 64 94914 667 CA     0 0           121 KENT AVE GREENBRAE, CA 94904 (37.953288, -122.551104)
134470 1023962-03-151 Chenney Construction Inc Chenney Construction 2130 Redwood Hwy #C7 Greenbrae 153 CA 1 94904 239 03/26/2015   03/26/2015   2130 Redwood Hwy #C7 Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0           2130 REDWOOD HWY GREENBRAE, CA 94904 (37.940396, -122.515571)
137851 1029756-06-151 Gueorguiev Petre T Petre T Gueorguiev Electric 30 Via Belardo 8 Greenbrae 153 CA 1 94904 239 07/11/2007   05/25/2015   30 Via Belardo Apt 8 Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0           30 VIA GREENBRAE, CA 94904
140667 1034628-07-151 Newbrn Solu Regst Nursing Corp Newborn-Solutions 24 Via Navarro Greenbrae 153 CA 1 94904 239 04/02/2013   05/01/2015   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0           24 VIA NAVARRO GREENBRAE, CA 94904
145312 1042290-10-151 George's Landscaping Inc Gli Norcal Landscape Construction 125 Rich St Greenbrae 153 CA 1 94904 239 10/16/2015   10/16/2015   125 Rich St Greenbrae 79 94904 99 CA     0 0           125 RICH ST GREENBRAE, CA 94904 (37.939497, -122.513576)
146128 1043744-11-151 Pointu Capital Llc Pointu Capital Llc 300 Drakes Landing Rd C Greenbrae 153 CA 1 94904 239 04/01/2013   01/01/2014   1 Ferry Building Ste 255 San Francisco 1 94111 11 CA     0 0           300 DRAKES LANDING RD C GREENBRAE, CA 94904 (37.943058, -122.519241)
146597 1044583-11-151 Agci, Inc Agci, Inc 336 Bon Air #104 Greenbrae 153 CA 1 94904 239 11/01/2015   11/01/2015   336 Bon Air #104 Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0           336 BON GREENBRAE, CA 94904 (37.945608, -122.522429)
152597 1057338-03-161 Collars & Greens Collars & Greens 2130 Redwood Hwy F-16 Greenbrae 153 CA 1 94904 239 02/01/2016   02/01/2016   2130 Redwood Hwy F-16 Greenbrae 79 94904 99 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2130 REDWOOD HWY GREENBRAE, CA 94904 (37.940396, -122.515571)
159797 1071164-05-161 Downing Heating Inc Downing Heating Inc 31 Industrial Way Greenbrae 153 CA 1 94904 239 05/19/1998   05/07/2016   31 Industrial Way Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0           31 INDUSTRIAL WAY GREENBRAE, CA 94904 (37.938718, -122.514636)
162377 1075854-06-161 Rose Hodges Rose Hodges 441 Via Casitas St Apt 1 Greenbrae 153 CA 1 94904 239 04/03/2016   04/03/2016   441 Via Casitas St 1 Apt Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0           441 VIA CASITAS ST GREENBRAE, CA 94904 (37.947019, -122.530569)
163030 1077062-06-161 Himmat Sandhu Uber 243 Via La Cumbre Apt A Greenbrae 153 CA 1 94904 239 06/01/2016   06/01/2016   243 Via La Cumbre A Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0           243 VIA LA CUMBRE APT A GREENBRAE, CA 94904 (37.950702, -122.513342)
163163 1077328-06-161 Esteban P Ledesma Uber 52 Corte Lenosa Greenbrae 153 CA 1 94904 239 06/20/2016   06/20/2016   52 Corte Lenosa Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0           52 CORTE LENOSA GREENBRAE, CA 94904 (37.947916, -122.521668)
166465 1082584-07-161 Basim Humeid Basim Humeid, Ma, Jd, Ll.m Taxation, Attorney At Law 336 Bon Air Center Dr 504 Greenbrae 153 CA 1 94904 239 07/12/2016   07/12/2016   336 Bon Air Center Dr 504 Greenbrae 79 94904 99 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0            
172891 1098002-08-161 Andre Blanadet Self 365 Via Casitas Greenbrae 153 CA 1 94904 239 07/04/2016   07/04/2016   365 Via Casitas Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
174235 1100931-08-161 Melvin Reyes Uber 2130 Redwood Hwy Greenbrae 153 CA 1 94904 239 03/10/2016   03/10/2016   2130 Redwood Hwy C5 Greenbrae 79 94904 99 CA     0 0            
175320 1103177-08-161 Luciano Martins Arruda Luciano Martins Arruda 21 Corte Lenosa Greenbrae 153 CA 1 94904 239 08/29/2016   08/29/2016   21 Corte Lenosa Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
175411 1103357-08-161 Shawn Kipnis City Of San Francisco (Uber) 290 Via Casitas Apt 301 Greenbrae 153 CA 1 94904 239 05/22/2016 05/11/2017 05/22/2016 05/11/2017         4800-4999 12 Transportation and Warehousing 12 0 0            
176519 1105620-08-161 Juan A. Quirarte Juan A. Quirarte 20 Lower Via Casitas St Apt 4 Greenbrae 153 CA 1 94904 239 01/05/2016   01/05/2016   20 Lower Via Casitas St 4 Apt Greenbrae 79 94905 3539 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
176696 1105990-08-161 Hugh Macmillan Hugh Macmillan 66 Via Holon #1 Greenbrae 153 CA 1 94904 239 08/01/2016   08/01/2016   66 Via Holon 1 Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
178640 1110368-08-161 Mhs Mhs 8 Corte Lenosa Greenbrae 153 CA 1 94904 239 08/31/2016   08/31/2016   8 Corte Lenosa Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
179226 1111564-08-161 Ludwig Leota Dba Ludwig Leota 69 Greenbrae Boardwalk Greenbrae 153 CA 1 94904 239 08/31/2016   08/31/2016   69 Greenbrae Boardwalk Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
179551 1112237-08-161 Gary Morrow Gary Morrow 25 Corte Oriental Apt 9 Greenbrae 153 CA 1 94904 239 01/04/2016 12/31/2016 01/04/2016 12/31/2016         4800-4999 12 Transportation and Warehousing 12 0 0            
179659 1112475-08-161 Marybeth Cooper Marybeth Cooper 75 Corte Encanto Greenbrae 153 CA 1 94904 239 11/28/2015   11/28/2015   75 Corte Encanto Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
180473 1114192-08-161 Alexandre Nery Alexandre Nery 6 Corte Lenosa St Apt 6 Greenbrae 153 CA 1 94904 239 08/01/2016   08/01/2016   6 Corte Lenosa St 6 Apt Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
180701 1114668-09-161 Julia Musisi Julia Musisi 10 Corte Sereno Greenbrae 153 CA 1 94904 239 08/31/2016 06/07/2017 08/31/2016 06/07/2017         4800-4999 12 Transportation and Warehousing 12 0 0            
181409 1116098-09-161 Jesus Ledesma Vargas Uber 424 Via Hidalgo Greenbrae 153 CA 1 94904 239 09/01/2016   09/01/2016   424 Via Hidalgo Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
183680 1120456-09-161 Lorina Mendoza Lorina Mendoza 115 Vista Grande Greenbrae 153 CA 1 94904 239 09/17/2016   09/19/2016   115 Vista Grande Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
183999 1121076-09-161 Melvin Reyes Melvin Reyes 2130 Redwood Hwy C5 Greenbrae 153 CA 1 94904 239 08/26/2016   08/26/2016   2130 Redwood Hwy Unit C5 Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
184762 1122539-10-161 Hagai Zwick Hagai Zwick 875 S Eliseo Dr #1 Greenbrae 153 CA 1 94904 239 08/05/2016   08/05/2016   875 S Eliseo Dr #1 Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
186034 1124781-10-161 Booth & Little Inc Booth & Little Inc 2150 Redwood Hwy Greenbrae 153 CA 1 94904 239 10/21/2016   10/21/2016   2150 Redwood Hwy Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0            
187720 1128858-12-161 Blue Sky Holdings Inc Ackerman Realty Group 336 Bon Air Center 388 Greenbrae 153 CA 1 94904 239 01/15/2004   10/31/2016   336 Bon Air Center 388 Greenbrae 79 94904 99 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
187909 1129217-12-161 Silva Pablo West Coast Builders 40 Rich St A Greenbrae 153 CA 1 94904 239 12/05/2016   12/05/2016   40 Rich St Ste A Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0            
192021 1136871-02-171 Castle Enterprises Jackson Street Apartments 435 Los Cerros Dr Greenbrae 153 CA 1 94904 239 01/01/2014   01/01/2014   435 Los Cerros Dr Greenbrae 79 94904 99 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1            
192023 1136875-02-171 Castle Enterprises Lupine Apartments 435 Los Cerros Dr Greenbrae 153 CA 1 94904 239 01/01/2014   01/01/2014   435 Los Cerros Dr Greenbrae 79 94904 99 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1            
195599 1143309-04-171 Daniel Barrett Yumfy 11 Rich St Ste 145 Greenbrae 153 CA 1 94904 239 01/01/2017   01/01/2017   11 Rich St 145 Ste Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
195608 1143326-04-171 Daniel Barrett Yumfy 11 Rich St Ste 145 Greenbrae 153 CA 1 94904 239 04/18/2017   04/18/2017   11 Rich St 145 Ste Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
203334 1159468-08-171 Nadjibi Farid Farid Nadjibi 79 Corte Ramon Greenbrae 153 CA 1 94904 239 08/29/2017   08/29/2017   79 Corte Ramon Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0            
207136 1166379-11-171 Us Construction California, Inc. Us Construction California, Inc 110 Tioga Ln Greenbrae 153 CA 1 94904 239 11/07/2017   11/07/2017   110 Tioga Ln Greenbrae 79 94904 99 CA 2300-2399 6 Construction 6 0 0            
209495 1152879-07-171 Maria Giovanna Valbonesi Yancy's Saloon 29 Corte Morada Greenbrae 153 CA 1 94904 239 07/01/2017   07/01/2017 07/01/2017 29 Corte Morada Greenbrae 79 94904 99 CA 7220-7229 8 Food Services 8 0 0            
214273 0379956-04-999 Sandhu Nihsima Mahima Nihsima 243 Via La Cumbre Greenbrae 153 CA 1 94904 239 08/11/2004   01/01/2014   243 Via La Cumbre Greenbrae 79 94904 99 CA 4400-4599 3 Retail Trade 3 0 0           243 VIA LA CUMBRE GREENBRAE, CA 94904 (37.950702, -122.513342)
216893 0353932-01-999 Hines Paul R Hines Custom Remodeling 336 Bon Air Center #290 Greenbrae 153 CA 1 94904 239 03/15/2002   03/15/2002   355 Tamalpais Ave Mill Valley 26 94941 50 CA 2300-2399 6 Construction 6 0 0           336 BON AIR CENTER GREENBRAE, CA 94904 (37.945608, -122.522429)
218997 0437214-01-999 Foggs Lath And Plaster Inc Foggs Lath And Plaster Inc 53 Corte Placide Greenbrae 153 CA 1 94904 239 03/20/2009   03/20/2009   53 Corte Placida Greenbrae 79 94904 99 CA     0 0           53 CORTE PLACIDE GREENBRAE, CA 94904 (37.951408, -122.511908)
220854 0477038-01-999 Qin Ruina Jade's Jewels 4 Ash Ave 15 Greenbrae 153 CA 1 94904 239 04/01/2013 01/06/2016 04/01/2013 01/06/2016             0 0           4 ASH AVE GREENBRAE, CA 94904 (37.954514, -122.545614)
222796 1092199-08-161 Angela Mercado Angela Mercado 15 Via Belardo Apt 4 Greenbrae 153 CA 1 94904 239 02/15/2015   02/15/2015   15 Via Belardo 4 Apt Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
223377 1093437-08-161 Andre Siqueira Vieira Andre Vieira 429 Via Hidalgo 41 Greenbrae 153 CA 1 94904 239 07/01/2013   07/01/2013   429 Via Hidalgo 41 Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
225294 1064368-04-161 Eduardo Cesar Coutinho Da Cunha San Francisco 429 Via Hidalgo Apt 52 Greenbrae 153 CA 1 94904 239 04/26/2016   04/26/2016   429 Via Hidalgo 52 Apt Greenbrae 79 94904 99 CA 4800-4999 12 Transportation and Warehousing 12 0 0           429 VIA GREENBRAE, CA 94904

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