trees
79 rows where SiteOrder = 1, Supervisor Districts = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
12221 | 261589 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 299x 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006795 | 2107850 | 37.7681385292637 | -122.41978620049 | (37.7681385292637, -122.41978620049) | 8 | 4 | 7 | 28853 | 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 | |||
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 | ||||
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 | ||||
172871 | 256721 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776275 | 6009358 | 2098062 | 37.7414069300959 | -122.410229861131 | (37.7414069300959, -122.410229861131) | 10 | 7 | 7 | 28859 | 2 | |||
176140 | 44012 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 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 | |||
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 | |||
152218 | 152308 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3420 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6006693.54336 | 2105565.92746 | 37.7618612870018 | -122.419975023524 | (37.7618612870018, -122.419975023524) | 8 | 4 | 7 | 28859 | 19 | |||
180665 | 152326 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6006659.4536 | 2105583.0811 | 37.7619064662287 | -122.420094144155 | (37.7619064662287, -122.420094144155) | 8 | 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 | ||
71950 | 176972 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 161 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 781886 | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.414559571484 | (37.7278844827614, -122.414559571484) | 9 | 3 | 7 | 309 | 28 | ||
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 | |
163344 | 115976 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||
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 | |
27 | 121462 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
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 | |
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 | |
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 | |
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 | |
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 | |
13567 | 243284 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | 8 | 4 | 7 | 28853 | 19 | |
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 | ||
20472 | 124717 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 610 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.7389386461297 | -122.415817669649 | (37.7389386461297, -122.415817669649) | 2 | 7 | 7 | 28859 | 2 | |
22723 | 119256 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 195 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010242 | 2098801 | 37.7434855758555 | -122.407225363197 | (37.7434855758555, -122.407225363197) | 2 | 7 | 7 | 28859 | 2 | ||
23615 | 117008 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | 6006952.61647 | 2093135.11232 | 37.7277436552341 | -122.418197638517 | (37.7277436552341, -122.418197638517) | 9 | 3 | 7 | 309 | 5 | ||
27582 | 116803 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 931 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2016 12:00:00 AM | 3 | 3x3 | 6007342.71844 | 2093540.39539 | 37.7288784251848 | -122.416877747635 | (37.7288784251848, -122.416877747635) | 9 | 3 | 7 | 309 | 28 | ||
32243 | 66394 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553 | (37.7369932248849, -122.41672547553) | 2 | 7 | 7 | 28859 | 2 | |
41739 | 253164 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.41191 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | 9 | 7 | 7 | 309 | 5 | ||
48832 | 243143 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
53742 | 82615 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.7511727251881 | -122.408119020981 | (37.7511727251881, -122.408119020981) | 2 | 4 | 7 | 28859 | 19 | |
54415 | 224728 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1110 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 771820 | 6009984.63313 | 2102660.33541 | 37.754068053508 | -122.408387439738 | (37.754068053508, -122.408387439738) | 2 | 4 | 7 | 28859 | 19 | |
68317 | 228832 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 517 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2018 12:00:00 AM | 3 | 4x4 | 6006836.21643 | 2100716.23735 | 37.7485531903885 | -122.419137558645 | (37.7485531903885, -122.419137558645) | 2 | 4 | 7 | 28859 | 19 | ||
71921 | 256722 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009288 | 2098069 | 37.7414222265504 | -122.410472391962 | (37.7414222265504, -122.410472391962) | 10 | 7 | 7 | 28859 | 2 | |
74714 | 166016 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 3332 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776384 | 6008453.51061 | 2099255.43212 | 37.7446330896597 | -122.413441663829 | (37.7446330896597, -122.413441663829) | 2 | 7 | 7 | 28859 | 2 | |
74821 | 36044 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
78698 | 173775 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1057 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779347 | 6009462.91602 | 2103024.17334 | 37.7550378411013 | -122.410217357343 | (37.7550378411013, -122.410217357343) | 2 | 4 | 7 | 28859 | 19 | |
78754 | 119257 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 191 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010220 | 2098811 | 37.743511802413 | -122.407302138847 | (37.743511802413, -122.407302138847) | 2 | 7 | 7 | 28859 | 2 | ||
81103 | 156905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
81706 | 122697 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
98671 | 256868 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 965 Powhattan Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246.49493 | 2098072.65991 | 37.7414299489627 | -122.410616161073 | (37.7414299489627, -122.410616161073) | 10 | 7 | 7 | 28859 | 2 | |
99548 | 256905 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 338 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781421 | 6007824.5446 | 2092249.93927 | 37.7253622000817 | -122.415120729164 | (37.7253622000817, -122.415120729164) | 9 | 3 | 7 | 309 | 28 | |
100907 | 229627 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778622 | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.413330912287 | (37.7406815009641, -122.413330912287) | 2 | 7 | 7 | 28859 | 2 | |
114599 | 240686 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.7497675773096 | -122.407098537685 | (37.7497675773096, -122.407098537685) | 2 | 4 | 7 | 28859 | 19 | |
119230 | 254617 | Planning Code 138.1 required 2 | :: 45 | 685 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 773164 | 6009303.1948 | 2105068.09113 | 37.7606410229668 | -122.410914072761 | (37.7606410229668, -122.410914072761) | 2 | 4 | 7 | 28859 | 19 | |
119839 | 152118 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 44 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780873 | 6006474.76942 | 2108215.62621 | 37.7691244070031 | -122.420919809024 | (37.7691244070031, -122.420919809024) | 8 | 4 | 7 | 28853 | 19 | |
122256 | 254396 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774780 | 6006150.23201 | 2093073.81475 | 37.7275301484246 | -122.420967149802 | (37.7275301484246, -122.420967149802) | 9 | 7 | 7 | 309 | 5 | |
124014 | 108228 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492 | 2106262 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | 8 | 4 | 7 | 28859 | 19 | |
125325 | 256910 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 835 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2019 12:00:00 AM | 3 | 3x3 | 6007598 | 2104806 | 37.7598256170474 | -122.416793017555 | (37.7598256170474, -122.416793017555) | 2 | 4 | 7 | 28859 | 19 | ||
129591 | 152667 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008576.51497 | 2103684.24515 | 37.7568005230537 | -122.413329473377 | (37.7568005230537, -122.413329473377) | 2 | 4 | 7 | 28859 | 19 | |
133371 | 255306 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1163 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | 3x6 | Permit Number 777039 | 6008085.276 | 2101160.09095 | 37.7498421745418 | -122.414849724814 | (37.7498421745418, -122.414849724814) | 2 | 4 | 7 | 28859 | 19 | |
134654 | 152810 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.7511779795992 | -122.408352609887 | (37.7511779795992, -122.408352609887) | 2 | 4 | 7 | 28859 | 19 | |
146805 | 121136 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1875 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/04/2017 12:00:00 AM | 3 | 3x3 | 6006784.10346 | 2107469.87255 | 37.7670941752111 | -122.419796914586 | (37.7670941752111, -122.419796914586) | 8 | 4 | 7 | 28853 | 19 | |
152203 | 152615 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
173437 | 255664 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781650 | 6007860.32032 | 2092132.7947 | 37.7250425565594 | -122.414988767826 | (37.7250425565594, -122.414988767826) | 9 | 3 | 7 | 309 | 28 | |
174008 | 251470 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.08468 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | 10 | 3 | 7 | 309 | 28 | |
176317 | 256115 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 503 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774745 | 6007867.72621 | 2096528.91607 | 37.7371137709195 | -122.41527422465 | (37.7371137709195, -122.41527422465) | 2 | 7 | 7 | 28859 | 2 | |
178976 | 252905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
182124 | 166234 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2986 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781629 | 6008392.95809 | 2103319.50363 | 37.7557887182862 | -122.413938481678 | (37.7557887182862, -122.413938481678) | 2 | 4 | 7 | 28859 | 19 | |
182774 | 255792 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2018 12:00:00 AM | 3 | 3x3 | 6007843 | 2092137 | 37.7250531301082 | -122.415048939995 | (37.7250531301082, -122.415048939995) | 9 | 3 | 7 | 309 | 28 | ||
183741 | 255653 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
191014 | 122700 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
7744 | 225194 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778605 | 6007219.63733 | 2103836.19178 | 37.7571414587344 | -122.418032839538 | (37.7571414587344, -122.418032839538) | 2 | 4 | 7 | 28859 | 19 | ||
162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 |
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) );