trees
39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id descending
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );