39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id ▲ qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
175075 94587 Permitted Site 7 Persea americana 'Stewart' :: Stewart Avocado 567 4072 24th St   Sidewalk: Curb side : Cutout Tree Private 2   10/04/2010 12:00:00 AM   3x3 Permit Number 53764 6002706 2101836 37.7513943353159 -122.433499781921 (37.7513943353159, -122.433499781921) 2 4 5 28862 22
150327 82083 Permitted Site 7 Ulmus parvifolia 'True Green' :: True Green Chinese Elm 560 1442 Sanchez St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/2011 12:00:00 AM   3x3 Permit Number 767418 6003903.93114879 2099873.27169394 37.7460730342646 -122.42921725762 (37.7460730342646, -122.42921725762) 2 7 5 63 22
144412 53140 Permitted Site 7 Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 556 1498@ KEITH Underwood Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792) 10 3 8 58 1
120013 51021 Permitted Site 7 Prunus sargentii :: Sargent Cherry 548 4275 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50421 6001430.71351981 2101713.7407115 37.750986202789 -122.437901107422 (37.750986202789, -122.437901107422) 2 4 5 28862 22
118226 53220 Permitted Site 7 Citrus x hystrix :: Kaffir lime 547 311 San Benito Way 1 Sidewalk: Property side : Yard Tree Private 2   10/04/2012 12:00:00 AM   3x7 Permit Number 769253 5992906.41199583 2094772.69381636 37.7314394147179 -122.466874195473 (37.7314394147179, -122.466874195473) 9 8 4 59 40
116211 7938 Permitted Site 7 Crinodendron patagua :: Lily-of-the-Valley Tree 544 1410X Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4x4   6005829.8939946 2114877.7740744 37.7873806719016 -122.423624130982 (37.7873806719016, -122.423624130982) 13 9 1 28858 41
184451 57101 Permitted Site 7 Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 534 3721 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 4 3x3 Permit Number 14371 6004927.69179762 2102493.53287665 37.7533255682373 -122.425863704952 (37.7533255682373, -122.425863704952) 2 4 5 28862 22
146294 35968 Permitted Site 7 Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 533 123 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39126 6005630.57353586 2096425.6693507 37.7367042924726 -122.423001748533 (37.7367042924726, -122.423001748533) 2 7 7 28859 2
176461 108981 Permitted Site 7 Eucalyptus odorata :: Peppermint Box 526 10 ARBOR ST   Front Yard : Yard Tree Private 2   03/02/2015 12:00:00 AM 3   Permit Number 774690 6002183.8 2097008.7 37.7381100606509 -122.434960408352 (37.7381100606509, -122.434960408352) 2 7 5 63 7
89056 53144 Permitted Site 7 Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 1498@ KEITH Underwood Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792) 10 3 8 58 1
118188 122503 Permitted Site 7 Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 849 Cole St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5997959.2 2107274.4 37.7660563608956 -122.450306679338 (37.7660563608956, -122.450306679338) 15 5 11 29492 9
187182 56743 Permitted Site 7 Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 18 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM   3x3 Permit Number 52607 6003487.54955553 2105682.63980927 37.7620006052609 -122.431071613448 (37.7620006052609, -122.431071613448) 15 4 5 28862 3
86786 63293 Permitted Site 7 Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 519 15 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23859 6008094.27360425 2100056.59433468 37.7468127256176 -122.414740525712 (37.7468127256176, -122.414740525712) 2 7 7 28859 2
104896 108072 Permitted Site 7 Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 519 101 BUENA VISTA AVE EAST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001336 2108482 37.7695648051764 -122.438713569331 (37.7695648051764, -122.438713569331) 15 5 5 29492 9
176655 3915 Permitted Site 7 Magnolia sargentiana 'Robusta' :: Robusta Magnolia 514 99X Castro St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
75166 40135 Permitted Site 7 Geijera spp :: Geijera 513 2846 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41339 6009180.78986515 2103366.6928894 37.755962504482 -122.411217228554 (37.755962504482, -122.411217228554) 2 4 7 28859 19
86651 107719 Permitted Site 7 Prunus serrula :: Birchbark Cherry 510 3301x 18TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3 3x3 Permit Number 774073 6007483 2105569 37.7619141695106 -122.417244815958 (37.7619141695106, -122.417244815958) 2 4 7 28859 19
107103 97557 Permitted Site 7 Prunus serrula :: Birchbark Cherry 510 1316 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2011 12:00:00 AM     Permit Number 768295 5993059.9 2106465.7 37.7635542817507 -122.467193428173 (37.7635542817507, -122.467193428173) 1 8 11 56 12
70157 52993 Permitted Site 7 Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 508 1210 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 24 3x3 Permit Number 49019 6003829.10545601 2101223.75142142 37.749776901068 -122.429572292056 (37.749776901068, -122.429572292056) 2 4 5 28862 22
170710 55720 Permitted Site 7 Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 508 58 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2010 12:00:00 AM     Permit Number 53177 6003133.68670367 2107965.52082477 37.7682487847408 -122.432458547407 (37.7682487847408, -122.432458547407) 15 5 5 28862 3
68650 95376 Permitted Site 7 Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 505 3864 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767248 6004016 2102485 37.7532505748794 -122.429015915711 (37.7532505748794, -122.429015915711) 2 4 5 28862 22
69428 94882 Permitted Site 7 Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 505 1778 Quesada Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53949 6014333.3 2095365.5 37.7342805262691 -122.392838262387 (37.7342805262691, -122.392838262387) 10 3 8 58 1
94810 95389 Permitted Site 7 Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 505 4751 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767258 6000210 2101069 37.749146408168 -122.442076167893 (37.749146408168, -122.442076167893) 2 4 5 28862 22
145994 95548 Permitted Site 7 Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 505 1701x SANCHEZ ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM 2 3x3 Permit Number 767348 6003979 2098037 37.7410353045642 -122.428826793148 (37.7410353045642, -122.428826793148) 2 7 5 63 7
131349 254658 Permitted Site 7 Malus 'Gala' :: Apple Tree 'Gala' 504 2555 20th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/12/2018 12:00:00 AM 3 3x3 Permit Number 779162 5990155.31756 2097990.36612 37.7401151538523 -122.476620133278 (37.7401151538523, -122.476620133278) 1 8 3 29491 35
67568 47414 Permitted Site 7 Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' 502 396 Cumberland St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45325 6003061.80741147 2104489.40624321 37.7587001387613 -122.43245885881 (37.7587001387613, -122.43245885881) 2 4 5 28862 3
192640 47413 Permitted Site 7 Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' 502 396 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45325 6003061.80741147 2104489.40624321 37.7587001387613 -122.43245885881 (37.7587001387613, -122.43245885881) 2 4 5 28862 3
63713 50410 Permitted Site 7 Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 178 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47065 6000234.8125186 2094385.17995161 37.7307956329874 -122.441510803123 (37.7307956329874, -122.441510803123) 9 7 4 63 40
59343 102927 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
65624 102929 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
93289 102837 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 908 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2013 12:00:00 AM   3x3 Permit Number 770090 5999213 2107044 37.7654954148837 -122.445953479715 (37.7654954148837, -122.445953479715) 15 5 5 29492 9
95710 102928 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
117788 102930 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
58236 98701 Permitted Site 7 Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 484 2490X Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2012 12:00:00 AM   3x3 Permit Number 768696 6000865 2116767.3 37.7922873178989 -122.440937193321 (37.7922873178989, -122.440937193321) 13 6 1 29490 27
59164 98699 Permitted Site 7 Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 484 2490X Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2012 12:00:00 AM   3x3 Permit Number 768696 6000865 2116767.3 37.7922873178989 -122.440937193321 (37.7922873178989, -122.440937193321) 13 6 1 29490 27
68992 98698 Permitted Site 7 Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 484 2490X Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2012 12:00:00 AM   3x3 Permit Number 768696 6000865 2116767.3 37.7922873178989 -122.440937193321 (37.7922873178989, -122.440937193321) 13 6 1 29490 27
53733 87644 Permitted Site 7 Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 1770X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004459.18866 2114839.9257 37.7871992830496 -122.428363789521 (37.7871992830496, -122.428363789521) 13 9 11 28858 27
178348 83461 Permitted Site 7 Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 847 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50441 6000958.23221364 2101981.88946936 37.7516955955481 -122.439554211126 (37.7516955955481, -122.439554211126) 2 4 5 28862 22
52866 52189 Permitted Site 7 Liquidambar formosana :: Chinese Sweet Gum 476 985 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50862 5998794.16746472 2106547.68954693 37.7641087462545 -122.447366395319 (37.7641087462545, -122.447366395319) 15 5 11 29492 9
147089 57009 Permitted Site 7 Liquidambar formosana :: Chinese Sweet Gum 476 24 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2015 12:00:00 AM 3   Permit Number 775634 6003352.23299803 2107445.91361589 37.7668344601842 -122.43166551543 (37.7668344601842, -122.43166551543) 15 5 5 28862 3
47991 41831 Permitted Site 7 Prunus spp 'Purpurea' :: Cherry Plum 469 1359 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 5 3x3 Permit Number 42217 5991431.78738883 2106173.10651318 37.7626567807932 -122.472803163089 (37.7626567807932, -122.472803163089) 1 8 11 56 12
66400 41832 Permitted Site 7 Prunus spp 'Purpurea' :: Cherry Plum 469 1359 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2016 12:00:00 AM 3 3x3 Permit Number 42217 5991431.78738883 2106173.10651318 37.7626567807932 -122.472803163089 (37.7626567807932, -122.472803163089) 1 8 11 56 12
111043 39977 Permitted Site 7 Prunus spp 'Purpurea' :: Cherry Plum 469 2535 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 41236 5990760.76494865 2098142.10858699 37.7405668981047 -122.474537835541 (37.7405668981047, -122.474537835541) 1 8 4 29491 40
137737 39604 Permitted Site 7 Prunus spp 'Purpurea' :: Cherry Plum 469 3628 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM 5 3x3 Permit Number 41007 6005441.47926786 2104914.36675045 37.7600016345446 -122.424259080531 (37.7600016345446, -122.424259080531) 2 4 5 28859 19
171837 46183 Permitted Site 7 Prunus spp 'Purpurea' :: Cherry Plum 469 60 Stonecrest Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 44510 5991036.80877736 2093807.38449355 37.7286808348731 -122.473267326425 (37.7286808348731, -122.473267326425) 9 8 4 64 40
182470 38658 Permitted Site 7 Prunus spp 'Purpurea' :: Cherry Plum 469 130 Beulah St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1998 12:00:00 AM 5 3x3 Permit Number 40580 5997471.03104632 2107818.12364092 37.7675213374579 -122.452034381815 (37.7675213374579, -122.452034381815) 15 5 11 29492 9
47977 97127 Permitted Site 7 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2690 Broadway 6 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
56898 97946 Permitted Site 7 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2 Mendosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2011 12:00:00 AM   3x3 Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
114344 97947 Permitted Site 7 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2 Mendosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2011 12:00:00 AM   3x3 Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
139864 97134 Permitted Site 7 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2690 Broadway 13 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
159559 97948 Permitted Site 7 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2 Mendosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2011 12:00:00 AM   3x3 Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
190999 97126 Permitted Site 7 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2690 Broadway 5 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
110411 41379 Permitted Site 7 Rhus lancea :: African Sumac 458 461 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2000 12:00:00 AM     Permit Number 42015 6003383.28248512 2102699.89411697 37.7538047881037 -122.431219318415 (37.7538047881037, -122.431219318415) 2 4 5 28862 22
160110 32420 Permitted Site 7 Rhus lancea :: African Sumac 458 1300 Ortega St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1996 12:00:00 AM     Permit Number 36947 5990009.30581449 2102467.22445118 37.752398967394 -122.477452096473 (37.752398967394, -122.477452096473) 1 8 3 56 35
117481 11872 Permitted Site 7 Juglans hindsii :: Walnut: Black (n.calif) 457 1499X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991566.5284818 2087248.8358641 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818) 9 8 4 64 24
68772 109215 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
127851 53309 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1775 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/28/1969 12:00:00 AM 30 6x4 Permit Number 6200 5992783.51352838 2103394.77336118 37.7551063623302 -122.46792597399 (37.7551063623302, -122.46792597399) 1 8 4 56 12
132739 109219 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 8 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
140906 109213 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
141367 109212 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
142438 109217 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
143419 109218 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
152164 109220 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
165599 109222 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 11 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
166885 109214 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
171135 109216 Permitted Site 7 Eucalyptus microtheca :: Flooded Box: Coolibah 455 1799x Owens St 5 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6014461.2235 2107332.63138 37.7671468356944 -122.39323311057 (37.7671468356944, -122.39323311057) 14 3 9 310 20
41413 92089 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 440 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2009 12:00:00 AM   3x3 Permit Number 52198 6011453 2106318 37.764193305924 -122.403566769567 (37.764193305924, -122.403566769567) 8 3 8 28856 29
54355 92088 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 440 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2009 12:00:00 AM   3x3 Permit Number 52198 6011453 2106318 37.764193305924 -122.403566769567 (37.764193305924, -122.403566769567) 8 3 8 28856 29
58865 112524 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 2435 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3 3x3 Permit Number 778367 6009761.3 2103168.6 37.7554511252743 -122.409195646414 (37.7554511252743, -122.409195646414) 2 4 7 28859 19
63167 40017 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 25X Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50722 6014441 2094547 37.7320390734938 -122.392408675195 (37.7320390734938, -122.392408675195) 10 3 8 58 1
70994 88763 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 2131 12th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/21/2008 12:00:00 AM   3x3 Permit Number 51685 5992543.2 2100941 37.7483550545978 -122.468578514228 (37.7483550545978, -122.468578514228) 1 8 4 29491 40
74972 106230 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 4016 20th St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 772780 6003554 2104234.5 37.7580281248998 -122.430738442051 (37.7580281248998, -122.430738442051) 2 4 5 28862 3
140549 92668 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 791 San Bruno Ave 6 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
160786 92667 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 791 San Bruno Ave 5 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
59408 96991 Permitted Site 7 Acer circinatum :: Vine Maple 452 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
39798 66957 Permitted Site 7 Tilia spp :: Linden 450 37 Cook St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1992 12:00:00 AM   3x3 Permit Number 30292 5997466.01687457 2113443.17296717 37.7829659755963 -122.452457697129 (37.7829659755963, -122.452457697129) 15 6 1 54 31
39411 44829 Permitted Site 7 New Zealand Tea Tree :: New Zealand Tea Tree 448 4256 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2001 12:00:00 AM     Permit Number 43921 6001511.54431017 2102357.39385657 37.7527581163366 -122.437667678888 (37.7527581163366, -122.437667678888) 2 4 5 28862 22
44728 50834 Permitted Site 7 New Zealand Tea Tree :: New Zealand Tea Tree 448 153 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM     Permit Number 47352 5994256.29106206 2114544.54740164 37.7858056356354 -122.463641898442 (37.7858056356354, -122.463641898442) 11 6 1 54 11
134341 50833 Permitted Site 7 New Zealand Tea Tree :: New Zealand Tea Tree 448 153 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM     Permit Number 47352 5994256.29106206 2114544.54740164 37.7858056356354 -122.463641898442 (37.7858056356354, -122.463641898442) 11 6 1 54 11
141897 40376 Permitted Site 7 New Zealand Tea Tree :: New Zealand Tea Tree 448 1555 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/1999 12:00:00 AM     Permit Number 41488 5993971.05534262 2104925.64646362 37.7593782496265 -122.463930258844 (37.7593782496265, -122.463930258844) 1 5 4 56 12
172516 50630 Permitted Site 7 New Zealand Tea Tree :: New Zealand Tea Tree 448 1198 Gilman Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM     Permit Number 47728 6014541.97081926 2090297.22948146 37.7203756614272 -122.39176255443 (37.7203756614272, -122.39176255443) 10 3 8 58 1
62908 106343 Permitted Site 7 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497 VALLEY ST 5 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22
88557 106340 Permitted Site 7 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497 VALLEY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22
173166 106339 Permitted Site 7 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497X Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779.6 2099138.4 37.7439915346951 -122.433052549622 (37.7439915346951, -122.433052549622) 2 7 5 63 22
34661 47190 Permitted Site 7 Leptospermum petersonii :: Lemon Scented Tea Tree 436 141 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2002 12:00:00 AM     Permit Number 45150 5987383.36668301 2115028.94081093 37.7867372223708 -122.48745557315 (37.7867372223708, -122.48745557315) 11 6 1 55 33
46929 42964 Permitted Site 7 Leptospermum petersonii :: Lemon Scented Tea Tree 436 63 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42853 6009571.37724716 2099895.71895032 37.7464538792999 -122.409621468456 (37.7464538792999, -122.409621468456) 2 7 7 28859 2
71316 108530 Permitted Site 7 Leptospermum petersonii :: Lemon Scented Tea Tree 436 1490-1498X 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773681 5990843.89113 2105531.38959 37.7608607468587 -122.474789624033 (37.7608607468587, -122.474789624033) 1 8 4 56 12
192610 108529 Permitted Site 7 Leptospermum petersonii :: Lemon Scented Tea Tree 436 1490-1498X 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773681 5990843.89113 2105531.38959 37.7608607468587 -122.474789624033 (37.7608607468587, -122.474789624033) 1 8 4 56 12
174087 67339 Permitted Site 7 Sophora japonica :: Japanese Pagoda 434 2512 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1992 12:00:00 AM     Permit Number 30823 6011401.22071301 2101865.59287056 37.7519650915383 -122.403432601922 (37.7519650915383, -122.403432601922) 10 4 8 28859 19
31678 104497 Permitted Site 7 Chionanthus retusa :: Chinese Fringe Tree 428 26 Allston Way 1 Front Yard : Cutout Tree Private 2   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352 37.7413518812257 -122.462061011692 (37.7413518812257, -122.462061011692) 1 8 4 59 40
154426 104498 Permitted Site 7 Chionanthus retusa :: Chinese Fringe Tree 428 26 Allston Way 2 Front Yard : Cutout Tree Private 2   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352 37.7413518812257 -122.462061011692 (37.7413518812257, -122.462061011692) 1 8 4 59 40
31349 97129 Permitted Site 7 Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 427 2690 Broadway 8 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
54017 97131 Permitted Site 7 Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 427 2690 Broadway 10 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
85094 97130 Permitted Site 7 Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 427 2690 Broadway 9 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
86369 97128 Permitted Site 7 Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 427 2690 Broadway 7 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
91031 97133 Permitted Site 7 Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 427 2690 Broadway 12 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
165996 97132 Permitted Site 7 Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 427 2690 Broadway 11 Sidewalk: Property side : Cutout Tree Private 2   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853) 13 9 1 57 27
57453 66716 Permitted Site 7 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 3506 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/1991 12:00:00 AM 12 3x3 Permit Number 29957 6006118 2102026 37.7521090259453 -122.421714160738 (37.7521090259453, -122.421714160738) 2 4 5 28859 19
115380 107697 Permitted Site 7 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 2401 MORAGA ST 3 Sidewalk: Property side : Yard Tree Private 2     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884) 1 8 3 56 35
182845 107698 Permitted Site 7 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 2401 MORAGA ST 2 Sidewalk: Property side : Yard Tree Private 2     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);