trees
177 rows where Fire Prevention Districts = 2 and qLegalStatus_id = 2 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1810 | 253859 | Planning Code 138.1 required 2 | Prunus spp :: Cherry 68 | 130 Graystone Ter | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | Permit Number 780749 | 5998952.88335 | 2104176.47413 | 37.7576070480405 | -122.446646826709 | (37.7576070480405, -122.446646826709) | 2 | 5 | 5 | 28862 | 3 | |||
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
3850 | 262121 | Planning Code 138.1 required 2 | Potential Site :: Potential Site 48 | 296x Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004047 | 2098716 | 37.7429035313116 | -122.428640063872 | (37.7429035313116, -122.428640063872) | 2 | 7 | 5 | 63 | 22 | ||||
4803 | 260955 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
7182 | 262122 | Planning Code 138.1 required 2 | Potential Site :: Potential Site 48 | 296x Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004047 | 2098716 | 37.7429035313116 | -122.428640063872 | (37.7429035313116, -122.428640063872) | 2 | 7 | 5 | 63 | 22 | ||||
8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
11040 | 260952 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
11346 | 261371 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095358 | 37.7338620991787 | -122.417441127318 | (37.7338620991787, -122.417441127318) | 2 | 7 | 7 | 28859 | 2 | ||||
11620 | 260954 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
13412 | 260953 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
33539 | 114537 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 1624 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | 3x4 | 6009248.6 | 2099914.9 | 37.7464884538144 | -122.41073895467 | (37.7464884538144, -122.41073895467) | 2 | 7 | 7 | 28859 | 2 | |||
36004 | 187698 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008980.17665 | 2103937.78959 | 37.7575193538388 | -122.41195137385 | (37.7575193538388, -122.41195137385) | 2 | 4 | 7 | 28859 | 19 | ||||
76348 | 258086 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 381 Lexington St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x1 | 6006575 | 2103913 | 37.7573160533564 | -122.420267699006 | (37.7573160533564, -122.420267699006) | 2 | 4 | 7 | 28859 | 19 | ||||
80448 | 187677 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
88053 | 187676 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
105542 | 251314 | Planning Code 138.1 required 2 | :: 45 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001901 | 2100825 | 37.7485726639367 | -122.4362112186 | (37.7485726639367, -122.4362112186) | 2 | 4 | 5 | 28862 | 22 | ||||
119022 | 60277 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2690 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51145 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||
135896 | 114985 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 773128 | 6003158.9 | 2101346.9 | 37.7500770674438 | -122.43189868142 | (37.7500770674438, -122.43189868142) | 2 | 4 | 5 | 28862 | 22 | |||
135962 | 187674 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
144520 | 43569 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | 3x3 | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | ||
152958 | 258304 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2946 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008567 | 2103911 | 37.7574226061115 | -122.413378415329 | (37.7574226061115, -122.413378415329) | 2 | 4 | 7 | 28859 | 19 | ||||
169946 | 187675 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
170182 | 258184 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 95 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003372 | 2097903 | 37.74063299685 | -122.430916015884 | (37.74063299685, -122.430916015884) | 2 | 7 | 5 | 63 | 7 | ||||
170362 | 187678 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
180002 | 258222 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2997 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3x3 | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
185007 | 187679 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
4773 | 165865 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x4 | 6006836.83511 | 2097542.23848 | 37.7398381374333 | -122.418910337746 | (37.7398381374333, -122.418910337746) | 2 | 7 | 7 | 28859 | 2 | |||
5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 | ||
11734 | 243526 | Planning Code 138.1 required 2 | Cassia leptophylla :: Gold Medallion Tree 152 | 3443 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007325.13159 | 2104386.27009 | 37.7586577840397 | -122.417706987288 | (37.7586577840397, -122.417706987288) | 2 | 4 | 7 | 28859 | 19 | |||
15201 | 243525 | Planning Code 138.1 required 2 | Cassia leptophylla :: Gold Medallion Tree 152 | 3445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x5 | 6007302.00064 | 2104384.8851 | 37.7586526795002 | -122.417786886671 | (37.7586526795002, -122.417786886671) | 2 | 4 | 7 | 28859 | 19 | |||
17339 | 166211 | Planning Code 138.1 required 2 | Cercis canadensis :: Eastern Redbud 346 | 3140 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6008730.35876 | 2101584.0935 | 37.7510426163255 | -122.412648961786 | (37.7510426163255, -122.412648961786) | 2 | 4 | 7 | 28859 | 19 | |||
147582 | 166259 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2880 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008980.17665 | 2103937.78959 | 37.7575193538388 | -122.41195137385 | (37.7575193538388, -122.41195137385) | 2 | 4 | 7 | 28859 | 19 | |||
21868 | 221950 | Planning Code 138.1 required 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 31 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 780973 | 6006097.6775 | 2099053.58173 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | 2 | 7 | 7 | 28859 | 2 | ||
88632 | 60705 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1983 12:00:00 AM | 1 | 3x3 | Permit Number 20354 | 6009178.18020232 | 2103559.73737881 | 37.7564924147418 | -122.4112398899 | (37.7564924147418, -122.4112398899) | 2 | 4 | 7 | 28859 | 19 | |
120060 | 221127 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1218 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 778419 | 6008662.3869 | 2101444.26707 | 37.750654869142 | -122.412874131348 | (37.750654869142, -122.412874131348) | 2 | 4 | 7 | 28859 | 19 | |
524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
13706 | 225187 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
58996 | 242613 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.7444035295914 | -122.417403753004 | (37.7444035295914, -122.417403753004) | 2 | 7 | 7 | 28859 | 2 | ||
3990 | 60261 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.412268813453 | (37.7575442102667, -122.412268813453) | 2 | 4 | 7 | 28859 | 19 | |
11200 | 4249 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 4043 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1995 12:00:00 AM | 12 | 4x4 | 6003613.964 | 2100376.48243 | 37.7474383143284 | -122.430255820476 | (37.7474383143284, -122.430255820476) | 2 | 4 | 5 | 63 | 22 | ||
60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 2 | 7 | 7 | 28859 | 2 | |||
115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
152110 | 239088 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.40071 | 37.748496089722 | -122.426200479689 | (37.748496089722, -122.426200479689) | 2 | 4 | 5 | 63 | 22 | ||
37358 | 247943 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 29 Joy St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | 2 | 7 | 7 | 28859 | 2 | |||
96451 | 225775 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002401.77617 | 2104846.28665 | 37.75964259654 | -122.43476706624 | (37.75964259654, -122.43476706624) | 2 | 4 | 5 | 28862 | 3 | ||
141915 | 225774 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002400.68275 | 2104833.82508 | 37.7596083179996 | -122.434769956692 | (37.7596083179996, -122.434769956692) | 2 | 4 | 5 | 28862 | 3 | ||
685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
1023 | 228184 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776221 | 6006352.00962 | 2102676.26299 | 37.7539076917969 | -122.420951082919 | (37.7539076917969, -122.420951082919) | 2 | 4 | 5 | 28859 | 19 | ||
1519 | 154406 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1270 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782729 | 6004450.91353 | 2101490.17776 | 37.7505436337949 | -122.427441030576 | (37.7505436337949, -122.427441030576) | 2 | 4 | 5 | 28862 | 22 | |
1902 | 261997 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
2224 | 236583 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
2678 | 157809 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 647 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781831 | 6002443.37703 | 2099727.28553 | 37.7455893990301 | -122.4342572226 | (37.7455893990301, -122.4342572226) | 2 | 7 | 5 | 63 | 22 | |
3426 | 231237 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009518.21853 | 2105339.01767 | 37.7613969805183 | -122.410189528218 | (37.7613969805183, -122.410189528218) | 2 | 4 | 7 | 28859 | 19 | |
3779 | 231240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009523.77815 | 2105243.21899 | 37.7611342507514 | -122.410163536041 | (37.7611342507514, -122.410163536041) | 2 | 4 | 7 | 28859 | 19 | |
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
4508 | 260546 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
5042 | 231235 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009517.2839 | 2105385.27542 | 37.7615239413898 | -122.410196026727 | (37.7615239413898, -122.410196026727) | 2 | 4 | 7 | 28859 | 19 | |
5901 | 260465 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2019 12:00:00 AM | 3 | 3x4 | Permit Number 782033 | 6005003.24747 | 2095750.87761 | 37.7348160467336 | -122.425122689163 | (37.7348160467336, -122.425122689163) | 2 | 7 | 7 | 28861 | 2 | |
6077 | 230988 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 44 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778706 | 6007424.10799 | 2099038.48568 | 37.7439795505181 | -122.416985775987 | (37.7439795505181, -122.416985775987) | 2 | 7 | 7 | 28859 | 2 | |
6664 | 226514 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1225 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781565 | 6005204.64951 | 2101211.39699 | 37.7498207677153 | -122.424814719741 | (37.7498207677153, -122.424814719741) | 2 | 4 | 5 | 28859 | 19 | |
6679 | 152982 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006311.85744 | 2102620.48455 | 37.7537522736602 | -122.421085978553 | (37.7537522736602, -122.421085978553) | 2 | 4 | 5 | 28859 | 19 | |
7127 | 260547 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
7195 | 4140 | Planning Code 138.1 required 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3620 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2020 12:00:00 AM | 3 | 3x6 | Permit Number 780969 | 6006062.29639 | 2100597.35658 | 37.7481831571401 | -122.421805323766 | (37.7481831571401, -122.421805323766) | 2 | 4 | 5 | 28859 | 19 | |
7258 | 262001 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
7502 | 236582 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009292.77734 | 2105398.52034 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | 2 | 4 | 7 | 28859 | 19 | |
7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
8008 | 260640 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776281 | 6004258 | 2100777 | 37.7485745007292 | -122.428057323873 | (37.7485745007292, -122.428057323873) | 2 | 4 | 5 | 28862 | 22 | |
8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
8601 | 222646 | Planning Code 138.1 required 2 | Ceanothus Sps :: California lilac 192 | 4209 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2018 12:00:00 AM | 3 | Width 3ft | 6001770.77195 | 2101738.59247 | 37.7510737715579 | -122.436726932715 | (37.7510737715579, -122.436726932715) | 2 | 4 | 5 | 28862 | 22 | ||
8699 | 262221 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
8936 | 261999 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
9770 | 262000 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
10030 | 261998 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
10742 | 166681 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 563 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2019 12:00:00 AM | 3 | 3x3 | 6002718.47853 | 2102666.28528 | 37.7536748096657 | -122.433515959096 | (37.7536748096657, -122.433515959096) | 2 | 4 | 5 | 28862 | 22 | ||
10960 | 166315 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 | |
11143 | 258742 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 367 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774042 | 6003945 | 2103884 | 37.7570878795298 | -122.429361203627 | (37.7570878795298, -122.429361203627) | 2 | 4 | 5 | 28862 | 3 | |
11330 | 166753 | Planning Code 138.1 required 2 | Schinus molle :: California Pepper 91 | 350 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2019 12:00:00 AM | 3 | 4x4 | Permit Number 781737 | 6002856.72425 | 2101550.76622 | 37.7506197011549 | -122.43295818429 | (37.7506197011549, -122.43295818429) | 2 | 4 | 5 | 28862 | 22 | |
11885 | 157920 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777832 | 6002961.17206 | 2100636.31842 | 37.7481147664022 | -122.432531686182 | (37.7481147664022, -122.432531686182) | 2 | 4 | 5 | 63 | 22 | |
11910 | 262222 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
12003 | 166317 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008865.69274 | 2103234.56357 | 37.755582030708 | -122.412297603862 | (37.755582030708, -122.412297603862) | 2 | 4 | 7 | 28859 | 19 | |
12391 | 221098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2815 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009314.5684 | 2105431.86525 | 37.7616405016156 | -122.410900429722 | (37.7616405016156, -122.410900429722) | 2 | 4 | 7 | 28859 | 19 | |
12677 | 259879 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 776294 | 6001192.18773 | 2103413.52714 | 37.7556398401092 | -122.438847746407 | (37.7556398401092, -122.438847746407) | 2 | 4 | 5 | 28862 | 3 | |
13037 | 152668 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008574.99769 | 2103713.14234 | 37.7568797829862 | -122.413336764205 | (37.7568797829862, -122.413336764205) | 2 | 4 | 7 | 28859 | 19 | |
13165 | 152981 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
13240 | 157603 | Planning Code 138.1 required 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 16 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 5x5 | Permit Number 784681 | 6000322.25182 | 2101567.57465 | 37.7505217703771 | -122.441723777343 | (37.7505217703771, -122.441723777343) | 2 | 4 | 5 | 28862 | 22 | |
15138 | 231239 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009523.66683 | 2105264.06886 | 37.7611914935157 | -122.410165393114 | (37.7611914935157, -122.410165393114) | 2 | 4 | 7 | 28859 | 19 | |
15356 | 251313 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 390 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
15413 | 262220 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
16166 | 166316 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008870.16891 | 2103155.64589 | 37.7553655917605 | -122.412276546247 | (37.7553655917605, -122.412276546247) | 2 | 4 | 7 | 28859 | 19 | |
16474 | 253340 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004464 | 2102825 | 37.7542094840672 | -122.427490860103 | (37.7542094840672, -122.427490860103) | 2 | 4 | 5 | 28862 | 22 | |
17746 | 262424 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 328 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2020 12:00:00 AM | 3 | 3x3 | 6006735.98718 | 2096026.524 | 37.7356706425738 | -122.419151541699 | (37.7356706425738, -122.419151541699) | 2 | 7 | 7 | 28859 | 2 | ||
18063 | 259659 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4061 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784440 | 6003514 | 2100377 | 37.7474340728524 | -122.430601526112 | (37.7474340728524, -122.430601526112) | 2 | 4 | 5 | 63 | 22 | |
18610 | 259660 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 | |
18657 | 251312 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 |
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) );