Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189115 | 189115 | 53052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.258169999 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | |
189048 | 189048 | 95921 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767619 | 5988991.254980001 | 2113497.8107 | 37.782626811071296 | -122.48178053312701 | (37.7826268110713, -122.481780533127) |
188706 | 188706 | 98034 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1817 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768344 | 5999961.07212 | 2115342.88884 | 37.788324733938396 | -122.44396240304899 | (37.7883247339384, -122.443962403049) | |
188053 | 188053 | 66364 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1991 12:00:00 AM | 4 | Permit Number 29965 | 5991908.34552 | 2112195.95462 | 37.7792214762424 | -122.471593848027 | (37.7792214762424, -122.471593848027) | ||
187658 | 187658 | 92257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 862 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52706 | 5981411.16308 | 2109852.88199 | 37.7721751933845 | -122.50773337462299 | (37.7721751933845, -122.507733374623) | |
187355 | 187355 | 50504 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 9 | Permit Number 47140 | 6001297.56946 | 2089761.94857 | 37.7181617790314 | -122.437505740198 | (37.7181617790314, -122.437505740198) | |
186659 | 186659 | 94703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 658 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53843 | 5992262.68777 | 2110962.91491 | 37.77585637803789 | -122.470278225754 | (37.7758563780379, -122.470278225754) |
186651 | 186651 | 96029 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767669 | 6007514.32648 | 2113867.32169 | 37.78470115228 | -122.417724680544 | (37.78470115228, -122.417724680544) |
186414 | 186414 | 45549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990323.96119 | 2095935.96592 | 37.7344840775814 | -122.47588704426201 | (37.7344840775814, -122.475887044262) | ||
186409 | 186409 | 45569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44312 | 5997642.12042 | 2115315.11009 | 37.7881159077753 | -122.451983551718 | (37.7881159077753, -122.451983551718) | |
186347 | 186347 | 47388 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 476Howard Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | 1 | Permit Number 45304 | 6010838.51311 | 2112011.8477 | 37.7797929592141 | -122.406093276399 | (37.7797929592141, -122.406093276399) | ||
186222 | 186222 | 56305 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 6 | Permit Number 12437 | 5993019.12779 | 2114510.13973 | 37.785639797963704 | -122.467919595671 | (37.7856397979637, -122.467919595671) | ||
185776 | 185776 | 50300 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.1569299998 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | |
185754 | 185754 | 30598 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 66 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 12 | Permit Number 34565 | 6004323.10435 | 2108874.18954 | 37.7708111439393 | -122.428409241587 | (37.7708111439393, -122.428409241587) | |
185481 | 185481 | 51890 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 1 | Permit Number 48103 | 6010867.53759 | 2112000.42013 | 37.779763205136206 | -122.40599206220301 | (37.7797632051362, -122.405992062203) | ||
185419 | 185419 | 96033 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767672 | 6008167.44383 | 2115805.7111 | 37.790060229456294 | -122.41560239383301 | (37.7900602294563, -122.415602393833) |
185006 | 185006 | 52876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3 | Permit Number 48887 | 6001354.74762 | 2121139.05445 | 37.8043188860645 | -122.439556198976 | (37.8043188860645, -122.439556198976) | ||
184941 | 184941 | 66120 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1990 12:00:00 AM | 11 | 6x9 | Permit Number 29180 | 5992838.2067599995 | 2112235.24508 | 37.7793831093725 | -122.4683799616 | (37.7793831093725, -122.4683799616) | |
184937 | 184937 | 36732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39511 | 6014611.904019999 | 2112877.2892299998 | 37.7823795964711 | -122.393099929045 | (37.7823795964711, -122.393099929045) | |
184864 | 184864 | 42977 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 6 | Permit Number 42862 | 6006537.3191599995 | 2092680.57085 | 37.7264721982142 | -122.419601095323 | (37.7264721982142, -122.419601095323) | |
184812 | 184812 | 94696 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53831 | 5987889.1247 | 2113258.0139599997 | 37.7819042437171 | -122.48557577955201 | (37.7819042437171, -122.485575779552) |
184608 | 184608 | 62176 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 42 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 14 | Permit Number 22292 | 6000115.63671 | 2091826.84592 | 37.723764247800396 | -122.441739275348 | (37.7237642478004, -122.441739275348) | |
184323 | 184323 | 45553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) | |
184236 | 184236 | 65288 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 7 | Permit Number 28836 | 6001457.593230001 | 2121333.88235 | 37.8048596843835 | -122.439214266819 | (37.8048596843835, -122.439214266819) | |
184160 | 184160 | 45526 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3001 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/2001 12:00:00 AM | 3 | Permit Number 44287 | 5988554.87545 | 2095154.91197 | 37.732236774288396 | -122.481946089834 | (37.7322367742884, -122.481946089834) | |
184129 | 184129 | 32690 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010817.622359999 | 2111993.44255 | 37.7797412544913 | -122.406164249981 | (37.7797412544913, -122.406164249981) | |
184059 | 184059 | 39688 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 464 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 41073 | 5991907.09743 | 2112240.92064 | 37.779344868431004 | -122.47160144327101 | (37.779344868431, -122.471601443271) | |||
183771 | 183771 | 33141 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37367 | 6001898.22805 | 2118969.0422099996 | 37.7983915210181 | -122.437519950413 | (37.7983915210181, -122.437519950413) | |
183324 | 183324 | 68544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32430 | 5982530.7498 | 2111896.5441900003 | 37.777852390021 | -122.504012093664 | (37.777852390021, -122.504012093664) | |
182902 | 182902 | 40949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45163 | 5989370.51415 | 2111642.49878 | 37.7775546903632 | -122.480332633054 | (37.7775546903632, -122.480332633054) | |
182777 | 182777 | 49699 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | |
182770 | 182770 | 34483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38210 | 6008918.6183400005 | 2119360.64227 | 37.7998633928514 | -122.413254875509 | (37.7998633928514, -122.413254875509) | |
182102 | 182102 | 103454 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5988396.696330001 | 2114118.88325 | 37.7842975073391 | -122.48388298077101 | (37.7842975073391, -122.483882980771) | |||
181801 | 181801 | 48394 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2520 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 14 | Permit Number 45776 | 6002671.64848 | 2116160.62189 | 37.7907242663701 | -122.434642758376 | (37.7907242663701, -122.434642758376) | |
181369 | 181369 | 31513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2513 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 15 | Permit Number 35071 | 6011012.0661 | 2102261.56789 | 37.7530306081845 | -122.40480623683399 | (37.7530306081845, -122.404806236834) | |
180717 | 180717 | 62178 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | 11 | Permit Number 22295 | 6000183.38046 | 2091791.51338 | 37.723671092440796 | -122.441502563011 | (37.7236710924408, -122.441502563011) | |
180438 | 180438 | 103498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989807.55073 | 2110619.1422900003 | 37.774770222887604 | -122.478745931564 | (37.7747702228876, -122.478745931564) | |
180103 | 180103 | 64839 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1989 12:00:00 AM | 13 | Permit Number 25851 | 6003826.24575 | 2093276.39298 | 37.727955108333795 | -122.429015623867 | (37.7279551083338, -122.429015623867) | ||
180014 | 180014 | 100870 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769325 | 5995481.9791 | 2111446.40578 | 37.7773695144675 | -122.45917696584299 | (37.7773695144675, -122.459176965843) | |
179064 | 179064 | 39571 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 835 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40989 | 6011610.458330001 | 2104449.8311400004 | 37.7590725253066 | -122.402890761795 | (37.7590725253066, -122.402890761795) | |
178641 | 178641 | 70480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 919 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767510 | 6005011.406280001 | 2092024.56337 | 37.724584874666206 | -122.42482946681001 | (37.7245848746662, -122.42482946681) |
178476 | 178476 | 43281 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 731 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43050 | 6009296.58944 | 2092411.7929900002 | 37.725889231602395 | -122.410043408191 | (37.7258892316024, -122.410043408191) | |
178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
178265 | 178265 | 95761 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 211 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767498 | 6004841.33495 | 2091865.6988400002 | 37.724139060046795 | -122.425406081532 | (37.7241390600468, -122.425406081532) |
178173 | 178173 | 88272 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51258 | 6010632.7883 | 2105837.1165299998 | 37.7628270590352 | -122.40636977475599 | (37.7628270590352, -122.406369774756) | |
177958 | 177958 | 45540 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.48628552285801 | (37.7314359091244, -122.486285522858) | |
177891 | 177891 | 62079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 595 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1985 12:00:00 AM | 14 | Permit Number 22161 | 6013301.58361 | 2104304.12984 | 37.7587667459021 | -122.397031791103 | (37.7587667459021, -122.397031791103) | |
177753 | 177753 | 111197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6003620.633230001 | 2116569.07161 | 37.791899593028205 | -122.43138849140499 | (37.7918995930282, -122.431388491405) | ||||
177715 | 177715 | 40658 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 8 | Permit Number 47919 | 6004683.64689 | 2093722.1701 | 37.7292276094514 | -122.426083284515 | (37.7292276094514, -122.426083284515) | |
177092 | 177092 | 94734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53865 | 5992586.2471199995 | 2110603.0007 | 37.7748868521692 | -122.46913276056002 | (37.7748868521692, -122.46913276056) |
176951 | 176951 | 48912 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1930 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2002 12:00:00 AM | 2 | 3x3 | Permit Number 46107 | 6004309.09705 | 2118070.5094 | 37.796061152762796 | -122.429113506091 | (37.7960611527628, -122.429113506091) |
176209 | 176209 | 32514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 814 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 3 | Permit Number 37016 | 6007565.02408 | 2095597.87607 | 37.7345403220735 | -122.41625488347799 | (37.7345403220735, -122.416254883478) | |
175674 | 175674 | 45552 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2003 12:00:00 AM | 3 | Permit Number 44300 | 5987586.8772599995 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | |
175579 | 175579 | 64857 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 5 | Permit Number 25873 | 5995838.9792599995 | 2112526.25675 | 37.780355016559504 | -122.458020161226 | (37.7803550165595, -122.458020161226) | |
175301 | 175301 | 67942 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 4 | Permit Number 31656 | 5989115.53927 | 2111342.9098799997 | 37.776717282669296 | -122.48119272322701 | (37.7767172826693, -122.481192723227) | |
175252 | 175252 | 51995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2837 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2005 12:00:00 AM | 11 | Permit Number 48213 | 5999309.41845 | 2118712.36147 | 37.797539220023296 | -122.44645951279301 | (37.7975392200233, -122.446459512793) | ||
175243 | 175243 | 96075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767701 | 5983103.04582 | 2113013.19289 | 37.7809520179972 | -122.50211500631399 | (37.7809520179972, -122.502115006314) |
175130 | 175130 | 32497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 665 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 16 | Permit Number 37002 | 6007442.3069400005 | 2095863.1015400002 | 37.7352616718948 | -122.416697941676 | (37.7352616718948, -122.416697941676) | |
174698 | 174698 | 49745 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46544 | 6008556.3350599995 | 2087877.23988 | 37.7133967814171 | -122.41228206988899 | (37.7133967814171, -122.412282069889) | |
174561 | 174561 | 68280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32088 | 6008949.32855 | 2093160.8279900001 | 37.7279264532255 | -122.411296760036 | (37.7279264532255, -122.411296760036) | |
173911 | 173911 | 84352 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51575 | 5994138.19056 | 2110541.38294 | 37.7748072179408 | -122.463759829065 | (37.7748072179408, -122.463759829065) | |
173766 | 173766 | 36753 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2579 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 8 | Permit Number 41197 | 6002394.06342 | 2116399.40669 | 37.7913641456997 | -122.435620277371 | (37.7913641456997, -122.435620277371) | |
173587 | 173587 | 95934 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 674 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767631 | 5987254.50705 | 2111348.9878700003 | 37.7766256032795 | -122.487630947058 | (37.7766256032795, -122.487630947058) |
173547 | 173547 | 37340 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39848 | 6000626.60293 | 2087367.0099799999 | 37.7115476439893 | -122.43965337791799 | (37.7115476439893, -122.439653377918) | |
173528 | 173528 | 39575 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 885 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40992 | 6011619.84178 | 2104260.65443 | 37.7585536119741 | -122.40284500428999 | (37.7585536119741, -122.40284500429) | |
173356 | 173356 | 38235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 10 | Permit Number 40353 | 6010102.82343 | 2110824.83764 | 37.7764925318532 | -122.408554604827 | (37.7764925318532, -122.408554604827) | ||
173069 | 173069 | 62262 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 78 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1985 12:00:00 AM | 18 | Permit Number 22388 | 5999957.62074 | 2091909.06342 | 37.7239809934048 | -122.442291407838 | (37.7239809934048, -122.442291407838) | |
172983 | 172983 | 50299 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 4 | Permit Number 47010 | 5989048.57412 | 2095810.2761099997 | 37.7340649359436 | -122.480287231884 | (37.7340649359436, -122.480287231884) | |
172980 | 172980 | 50792 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2740 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47317 | 5999864.3976 | 2118141.20218 | 37.7960026509676 | -122.444498073449 | (37.7960026509676, -122.444498073449) | |||
172628 | 172628 | 34523 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | 8 | Permit Number 38233 | 6010643.980930001 | 2105619.91693 | 37.762231304058204 | -122.40631575879 | (37.7622313040582, -122.40631575879) | |
172523 | 172523 | 62479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 10 | Permit Number 31826 | 6000682.25846 | 2093099.2989400001 | 37.7272903816351 | -122.43987175399499 | (37.7272903816351, -122.439871753995) | |
172196 | 172196 | 35478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 524 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 6 | Permit Number 38890 | 5986598.81458 | 2112347.1481 | 37.779328002919705 | -122.489972580124 | (37.7793280029197, -122.489972580124) | ||
172079 | 172079 | 41946 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 690 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42304 | 5993510.89143 | 2110826.8547 | 37.775554879409206 | -122.46595051642299 | (37.7755548794092, -122.465950516423) | |
171618 | 171618 | 68224 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2012 12:00:00 AM | 1 | Permit Number 769229 | 5990833.387490001 | 2113424.07906 | 37.782531317215295 | -122.47540222511999 | (37.7825313172153, -122.47540222512) | |
171041 | 171041 | 65739 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 12 | Permit Number 28675 | 5999799.15568 | 2087425.51821 | 37.7116611636025 | -122.442517443427 | (37.7116611636025, -122.442517443427) | |
170838 | 170838 | 68956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.3324599997 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | |
170516 | 170516 | 44260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 6 | Permit Number 43692 | 6003282.08858 | 2092150.8754099999 | 37.72483387178 | -122.430816500988 | (37.72483387178, -122.430816500988) | ||
170473 | 170473 | 82703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52500 | 6012950.17329 | 2089208.10371 | 37.71729664739521 | -122.39718858698 | (37.7172966473952, -122.39718858698) | |
170297 | 170297 | 65278 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205633999 | (37.7806943784819, -122.40481205634) | |
170172 | 170172 | 59138 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18444 | 5992185.73773 | 2111803.62567 | 37.7781602921817 | -122.47060565987302 | (37.7781602921817, -122.470605659873) | ||
169964 | 169964 | 43259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 8 | Permit Number 43042 | 6010225.92511 | 2092216.8838799999 | 37.725406095999396 | -122.406817013015 | (37.7254060959994, -122.406817013015) | |
169580 | 169580 | 84326 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53994 | 5987888.08845 | 2110995.2066599997 | 37.7756911522049 | -122.48541326443899 | (37.7756911522049, -122.485413264439) |
168755 | 168755 | 41936 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 684 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | 3x9 | Permit Number 42295 | 5994746.112840001 | 2110871.9454099997 | 37.7757498669665 | -122.461680887642 | (37.7757498669665, -122.461680887642) |
168539 | 168539 | 45578 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 6 | Permit Number 44318 | 5998557.11063 | 2115405.08726 | 37.788415328045204 | -122.448824341269 | (37.7884153280452, -122.448824341269) | |
167820 | 167820 | 45548 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990306.88184 | 2095939.17218 | 37.734491890873606 | -122.475946326684 | (37.7344918908736, -122.475946326684) | ||
166797 | 166797 | 50876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 322 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 7 | Permit Number 47534 | 5987167.73714 | 2113766.40078 | 37.7832580715076 | -122.48810878253401 | (37.7832580715076, -122.488108782534) | ||
166558 | 166558 | 68939 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 491 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2010 12:00:00 AM | 3 | Permit Number 53187 | 5989664.28625 | 2112063.79605 | 37.7787285224831 | -122.479347217114 | (37.7787285224831, -122.479347217114) | |
166312 | 166312 | 68274 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 2 | Permit Number 32081 | 6008779.93848 | 2093554.1542200001 | 37.7289969414408 | -122.411910130973 | (37.7289969414408, -122.411910130973) | |
166176 | 166176 | 68393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 248 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 4 | Permit Number 32221 | 6001588.48331 | 2093972.4225299999 | 37.729739323692705 | -122.436801419974 | (37.7297393236927, -122.436801419974) | |
166051 | 166051 | 64856 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 2 | Permit Number 25872 | 5995898.09877 | 2112568.97781 | 37.7804757138181 | -122.45781873289499 | (37.7804757138181, -122.457818732895) | |
165958 | 165958 | 66569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 15 | Permit Number 29758 | 6005069.72782 | 2093317.4329799998 | 37.728138104176004 | -122.424719787291 | (37.728138104176, -122.424719787291) | |
165794 | 165794 | 41942 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 760 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 12 | Permit Number 42300 | 5994453.07656 | 2110414.51665 | 37.7744770167939 | -122.462661376327 | (37.7744770167939, -122.462661376327) | |
165599 | 165599 | 68952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 747 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32941 | 5988797.45218 | 2110217.11495 | 37.7736076654938 | -122.482210568345 | (37.7736076654938, -122.482210568345) | |
165571 | 165571 | 30804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 14 | Permit Number 34669 | 6001616.65191 | 2095326.1919200001 | 37.733458064439 | -122.43680091003401 | (37.733458064439, -122.436800910034) | |
165506 | 165506 | 95992 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 858 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767644 | 5986371.40114 | 2110056.12968 | 37.7730242344515 | -122.490590683906 | (37.7730242344515, -122.490590683906) |
165469 | 165469 | 45480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3014 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44262 | 5990294.42195 | 2095159.6612900002 | 37.732350829908704 | -122.47593249418699 | (37.7323508299087, -122.475932494187) | |
165270 | 165270 | 95771 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 335 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767506 | 6003734.79279 | 2091608.3124 | 37.7233697529841 | -122.429212886579 | (37.7233697529841, -122.429212886579) |
164850 | 164850 | 31788 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35258 | 6001692.80487 | 2107894.1622099997 | 37.7679710399513 | -122.437437296395 | (37.7679710399513, -122.437437296395) | |
164404 | 164404 | 40950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 6 | Permit Number 42451 | 5989371.25434 | 2111628.81002 | 37.777517147846204 | -122.480329070335 | (37.7775171478462, -122.480329070335) | |
164246 | 164246 | 62478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 19 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 17 | Permit Number 22649 | 6000701.05589 | 2093131.58953 | 37.7273801141826 | -122.43980908564501 | (37.7273801141826, -122.439809085645) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");