trees
147 rows where qLegalStatus_id = 5 and qSiteInfo = "Sidewalk: Curb side : Cutout" sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
3414 | 262418 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4243 | 162646 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
7952 | 262419 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
6293 | 97158 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.397943616401 | (37.7189762599209, -122.397943616401) | 10 | 3 | 8 | 58 | 1 | ||
6990 | 97154 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | 10 | 3 | 8 | 58 | 1 | ||
12625 | 97159 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.60574 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | 10 | 3 | 8 | 58 | 1 | ||
12626 | 97156 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.398022907844 | (37.7190195469812, -122.398022907844) | 10 | 3 | 8 | 58 | 1 | ||
18330 | 97157 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768080 | 6012734.70575 | 2089832.2191 | 37.7189983454895 | -122.397977119771 | (37.7189983454895, -122.397977119771) | 10 | 3 | 8 | 58 | 1 | ||
18353 | 97155 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.95173 | 37.7190672497343 | -122.398087681509 | (37.7190672497343, -122.398087681509) | 10 | 3 | 8 | 58 | 1 | ||
194400 | 265055 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
194401 | 265056 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
14595 | 262138 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783072 | 5995073.28586 | 2091364.23184 | 37.7222054253906 | -122.459136235782 | (37.7222054253906, -122.459136235782) | 9 | 8 | 4 | 28861 | 24 | |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
4750 | 113090 | Section 806 (d) 5 | Pyrus calleryana :: Ornamental Pear 44 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.60872 | 37.7303322746045 | -122.41230559973 | (37.7303322746045, -122.41230559973) | 9 | 3 | 7 | 309 | 28 | ||
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
7105 | 262039 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1251 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783100 | 6007540 | 2116706 | 37.7924969115625 | -122.417837146347 | (37.7924969115625, -122.417837146347) | 5 | 1 | 10 | 28858 | 21 | ||
19451 | 254404 | Section 806 (d) 5 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2018 12:00:00 AM | 3 | 3x3 | 5999857 | 2108965 | 37.7708067512445 | -122.443864065657 | (37.7708067512445, -122.443864065657) | 15 | 5 | 11 | 29492 | 9 | ||
8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
11626 | 262262 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1324 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784290 | 5993653.14185 | 2106470.72632 | 37.763602309694 | -122.465141974097 | (37.763602309694, -122.465141974097) | 1 | 8 | 11 | 56 | 12 | |
194494 | 264749 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 1339 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785207 | 5991088 | 2106284 | 37.7629413570223 | -122.474000279679 | (37.7629413570223, -122.474000279679) | 1 | 8 | 11 | 56 | 12 | |
9924 | 101922 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769132 | 6007599.52227 | 2116115.67925 | 37.7908793859256 | -122.417589338874 | (37.7908793859256, -122.417589338874) | 13 | 1 | 10 | 28858 | 21 | |
13794 | 101919 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 9 | 3x3 | Permit Number 769132 | 6007497.40622 | 2116101.25633 | 37.7908340376155 | -122.417941633898 | (37.7908340376155, -122.417941633898) | 13 | 1 | 10 | 28858 | 21 | |
17403 | 101921 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769132 | 6007574.87115 | 2116111.37594 | 37.7908661829645 | -122.417674325729 | (37.7908661829645, -122.417674325729) | 13 | 1 | 10 | 28858 | 21 | |
19022 | 101920 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 13 | 3x3 | Permit Number 769132 | 6007536.5156 | 2116104.21807 | 37.7908443708073 | -122.417806526949 | (37.7908443708073, -122.417806526949) | 13 | 1 | 10 | 28858 | 21 | |
5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
17710 | 169495 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 150 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 770415 | 6004561.3283 | 2097566.6275 | 37.7397767110236 | -122.426779823841 | (37.7397767110236, -122.426779823841) | 2 | 7 | 5 | 63 | 7 | |
8444 | 103091 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008424.20559 | 2117797.21945 | 37.7955428518875 | -122.414855023041 | (37.7955428518875, -122.414855023041) | 5 | 1 | 10 | 308 | 21 | |
9912 | 103092 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008422.05981 | 2117808.63756 | 37.7955740826282 | -122.414863256344 | (37.7955740826282, -122.414863256344) | 5 | 1 | 10 | 308 | 21 | |
10996 | 103096 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008414.12252 | 2117870.41106 | 37.7957432514055 | -122.414895095058 | (37.7957432514055, -122.414895095058) | 5 | 1 | 10 | 308 | 21 | |
14679 | 103093 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008420.39916 | 2117820.52002 | 37.7956066156178 | -122.414869843894 | (37.7956066156178, -122.414869843894) | 5 | 1 | 10 | 308 | 21 | |
17667 | 103095 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008416.42419 | 2117851.09099 | 37.7956903325975 | -122.414885762773 | (37.7956903325975, -122.414885762773) | 5 | 1 | 10 | 308 | 21 | |
18706 | 103094 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008418.50881 | 2117836.67229 | 37.7956508595435 | -122.414877528601 | (37.7956508595435, -122.414877528601) | 5 | 1 | 10 | 308 | 21 | |
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
18205 | 262139 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 1582 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782766 | 5981929 | 2104333 | 37.7570496794991 | -122.505532928251 | (37.7570496794991, -122.505532928251) | 1 | 8 | 3 | 56 | 35 | |
3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
4989 | 256185 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
6215 | 256187 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
18862 | 256188 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
7765 | 263633 | Section 806 (d) 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 160 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782824 | 6000235.49843 | 2104901.88273 | 37.7596720242526 | -122.442263109517 | (37.7596720242526, -122.442263109517) | 2 | 4 | 5 | 28862 | 3 | |
18916 | 152848 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 160 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 781252 | 6006654.74312 | 2105190.58967 | 37.7608285109489 | -122.420082580673 | (37.7608285109489, -122.420082580673) | 2 | 4 | 7 | 28859 | 19 | |
12144 | 111632 | Section 806 (d) 5 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774682 | 5985071 | 2103231.6 | 37.7542099449347 | -122.49458566251 | (37.7542099449347, -122.49458566251) | 1 | 8 | 3 | 56 | 35 | ||
33 | 261067 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1832 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782484 | 6011934 | 2092960 | 37.727541965346 | -122.400964507068 | (37.727541965346, -122.400964507068) | 10 | 3 | 8 | 58 | 1 | |
18226 | 98437 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1840 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2012 12:00:00 AM | 4 | 4x12 | Permit Number 768068 | 6005870.33263 | 2116931.58044 | 37.7930221942694 | -122.423630300016 | (37.7930221942694, -122.423630300016) | 13 | 9 | 1 | 28858 | 27 | |
6139 | 264669 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 1890 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 770415 | 6004581.61952 | 2097649.26106 | 37.7400047512279 | -122.426715548384 | (37.7400047512279, -122.426715548384) | 2 | 7 | 5 | 63 | 7 | |
15098 | 169494 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 1890 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 770415 | 6004581.61952 | 2097649.26106 | 37.7400047512279 | -122.426715548384 | (37.7400047512279, -122.426715548384) | 2 | 7 | 5 | 63 | 7 | |
16264 | 111321 | Section 806 (d) 5 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6010185.88551 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | 9 | 7 | 8 | 309 | 39 | ||||
4594 | 221063 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006493.11817 | 2110111.72475 | 37.7743316749983 | -122.420990984947 | (37.7743316749983, -122.420990984947) | 7 | 9 | 11 | 28852 | 10 | |||
11965 | 221066 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006423.38991 | 2110105.498 | 37.7743106470621 | -122.421231746062 | (37.7743106470621, -122.421231746062) | 7 | 9 | 11 | 28852 | 10 | |||
14708 | 221065 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006445.36198 | 2110108.11027 | 37.7743190584079 | -122.421155926024 | (37.7743190584079, -122.421155926024) | 7 | 9 | 11 | 28852 | 10 | |||
19533 | 259217 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996177 | 2090586 | 37.7201319742324 | -122.455264770625 | (37.7201319742324, -122.455264770625) | 9 | 8 | 6 | 28861 | 24 | |
9006 | 112755 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2038 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 5989157.5 | 2111303.8 | 37.7766123371313 | -122.481044705999 | (37.7766123371313, -122.481044705999) | 11 | 6 | 2 | 55 | 26 | |||
2103 | 262299 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
15368 | 262300 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
3533 | 263634 | Section 806 (d) 5 | Tree(s) :: 17 | 211 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 3x3 | 6008194.27066 | 2088426.33179 | 37.71488415001 | -122.413572307092 | (37.71488415001, -122.413572307092) | 9 | 7 | 8 | 309 | 39 | ||
194448 | 265090 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 784731 | 5994883.78198 | 2089306.03852 | 37.7165432206381 | -122.459642300713 | (37.7165432206381, -122.459642300713) | 9 | 8 | 6 | 28861 | 24 | |
8728 | 96402 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2160 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2011 12:00:00 AM | 1 | 2x3 | 5985141.5215 | 2100472.7854 | 37.7466391224256 | -122.494138462065 | (37.7466391224256, -122.494138462065) | 1 | 8 | 3 | 29491 | 35 | ||
1296 | 114159 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.7953963109343 | -122.434341453993 | (37.7953963109343, -122.434341453993) | 13 | 9 | 1 | 57 | 17 | |
4024 | 114160 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.434397600465 | (37.7953804657925, -122.434397600465) | 13 | 9 | 1 | 57 | 17 | |
6198 | 112830 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 2265 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 3 | 3x3 | 6006944 | 2105170 | 37.760788269781 | -122.419080706794 | (37.760788269781, -122.419080706794) | 2 | 4 | 7 | 28859 | 19 | ||
746 | 110743 | Section 806 (d) 5 | Cercis occidentalis :: Western Redbud 136 | 2300x Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010565.19201 | 2106016.80838 | 37.7633166706365 | -122.406616231274 | (37.7633166706365, -122.406616231274) | 8 | 4 | 8 | 28859 | 19 | ||
2411 | 110745 | Section 806 (d) 5 | Cotinus coggygria 'Royal Purple' :: Smoke tree 229 | 2300x Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010533.01376 | 2106015.32988 | 37.7633108106613 | -122.406727421634 | (37.7633108106613, -122.406727421634) | 8 | 4 | 8 | 28859 | 19 | ||
3788 | 110746 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010517.26001 | 2106013.51672 | 37.7633049506856 | -122.406781781161 | (37.7633049506856, -122.406781781161) | 8 | 4 | 8 | 28859 | 19 | ||
14075 | 110744 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010545.16814 | 2106015.79361 | 37.7633127639997 | -122.406685416098 | (37.7633127639997, -122.406685416098) | 8 | 4 | 8 | 28859 | 19 | ||
16603 | 110742 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010595.22782 | 2106018.33058 | 37.7633225306396 | -122.406512454011 | (37.7633225306396, -122.406512454011) | 8 | 4 | 8 | 28859 | 19 | ||
17154 | 110741 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010604.54028 | 2106019.56363 | 37.7633264372932 | -122.406480331995 | (37.7633264372932, -122.406480331995) | 8 | 4 | 8 | 28859 | 19 | ||
8961 | 260880 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
14443 | 260878 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
18095 | 260879 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
5386 | 262533 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
8745 | 262534 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
15035 | 164228 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991043.64805 | 2099007.36638 | 37.7429590601275 | -122.473622846338 | (37.7429590601275, -122.473622846338) | 1 | 8 | 4 | 29491 | 40 | |
15653 | 164229 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991045.42225 | 2098958.21862 | 37.7428242157788 | -122.47361312736 | (37.7428242157788, -122.47361312736) | 1 | 8 | 4 | 29491 | 40 | |
18260 | 164230 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
14057 | 107967 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 2405x Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001240.68928 | 2116684.58018 | 37.7920815807513 | -122.439631370586 | (37.7920815807513, -122.439631370586) | 13 | 6 | 1 | 29490 | 27 | |
4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
17749 | 13265 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000636.2224 | 2119294.0135 | 37.7992119752158 | -122.441910200363 | (37.7992119752158, -122.441910200363) | 13 | 9 | 1 | 57 | 17 | |
16257 | 225172 | Section 806 (d) 5 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | 4x4 | Permit Number 779647 | 6006535.62128 | 2098220.14009 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | 2 | 7 | 7 | 28859 | 2 | |
14464 | 44040 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.74454 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | 13 | 6 | 1 | 29490 | 27 | ||
7043 | 112197 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.7921756543416 | -122.437399303646 | (37.7921756543416, -122.437399303646) | 13 | 6 | 1 | 29490 | 27 | ||
7524 | 111636 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486 | 2097347 | 37.7380767082098 | -122.492717127165 | (37.7380767082098, -122.492717127165) | 1 | 8 | 3 | 29491 | 35 | ||
13701 | 112515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2646 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6000218.93903 | 2118886.71439 | 37.7980698532985 | -122.443324869154 | (37.7980698532985, -122.443324869154) | 13 | 9 | 1 | 57 | 17 | |||
37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
194318 | 264973 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 3135 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 781901 | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |
9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
10128 | 256113 | Section 806 (d) 5 | Magnolia spp :: Magnolia 224 | 356 Willard North St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2018 12:00:00 AM | 3 | |||||||||||||
2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 |
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) );