trees
2,694 rows where qSpecies_id = 84 sorted by PlotSize descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132799 | 214408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Idora Ave | 20 | Median : Yard | Tree | DPW 1 | 3 | Width 9ft | 5995751.65358 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | 1 | 8 | 4 | 59 | 40 | |||
| 154286 | 196407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 301 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6014364.2295 | 2105674.47806 | 37.7625885210619 | -122.393452545091 | (37.7625885210619, -122.393452545091) | 10 | 3 | 8 | 28856 | 29 | |||
| 176035 | 178946 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 25 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 6005433.25 | 2093389.63985 | 37.7283568930528 | -122.42346820799 | (37.7283568930528, -122.42346820799) | 9 | 7 | 7 | 309 | 5 | |||
| 64859 | 214472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 249 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6000443.47619 | 2094924.07855 | 37.7322872091904 | -122.440828064285 | (37.7322872091904, -122.440828064285) | 9 | 7 | 4 | 63 | 40 | |||
| 75451 | 178875 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998646.96752 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | 9 | 7 | 6 | 28861 | 25 | |||
| 88113 | 214455 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 449 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 6000738.08484 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | 9 | 7 | 5 | 63 | 40 | |||
| 159909 | 178874 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998666.63351 | 2088343.63451 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | 9 | 7 | 6 | 28861 | 25 | |||
| 69267 | 135892 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6001823.0897 | 2121828.59544 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | 13 | 9 | 1 | 57 | 17 | |||
| 87841 | 135908 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | 3 | 1 | 10 | 308 | 23 | |||
| 122246 | 135891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2398 North Point St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.8024605098936 | -122.446592451473 | (37.8024605098936, -122.446592451473) | 13 | 9 | 1 | 57 | 17 | |||
| 14237 | 240835 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 87579 | 214381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1862 17th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5990969.19969 | 2102754.50273 | 37.7532434102637 | -122.474153618994 | (37.7532434102637, -122.474153618994) | 1 | 8 | 4 | 56 | 12 | |||
| 98679 | 238009 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1269 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5997476.9069 | 2105200.16728 | 37.7603334305535 | -122.451825175712 | (37.7603334305535, -122.451825175712) | 15 | 5 | 11 | 29492 | 12 | |||
| 109957 | 214385 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1955 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 5993134.95065 | 2102190.16883 | 37.7518191170825 | -122.466623057705 | (37.7518191170825, -122.466623057705) | 1 | 8 | 4 | 29491 | 12 | |||
| 143097 | 214420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 466 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993273.26213 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | 9 | 8 | 6 | 64 | 24 | |||
| 3061 | 214398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5994265.55246 | 2098714.72698 | 37.7423416116873 | -122.46246124889 | (37.7423416116873, -122.46246124889) | 1 | 8 | 4 | 59 | 40 | |||
| 3919 | 240834 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 19743 | 237974 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005423.51837 | 2102260.48733 | 37.7527136870909 | -122.424132459851 | (37.7527136870909, -122.424132459851) | 2 | 4 | 5 | 28859 | 19 | |||
| 21090 | 214399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 280 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5993979.94578 | 2098920.29255 | 37.7428895919817 | -122.463463697088 | (37.7428895919817, -122.463463697088) | 1 | 8 | 4 | 59 | 40 | |||
| 26683 | 238016 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 50 Ashbury Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999571.74452 | 2106835.86862 | 37.7649444165749 | -122.44469770674 | (37.7649444165749, -122.44469770674) | 15 | 5 | 5 | 29492 | 9 | |||
| 33839 | 238020 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 20 Ashbury Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999596.30607 | 2106935.78713 | 37.7652201693967 | -122.444619936965 | (37.7652201693967, -122.444619936965) | 15 | 5 | 5 | 29492 | 9 | |||
| 64814 | 214394 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.7422144457429 | -122.462188567252 | (37.7422144457429, -122.462188567252) | 1 | 8 | 4 | 59 | 40 | |||
| 73938 | 135905 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006460.32075 | 2121020.93031 | 37.8042838008308 | -122.421879520521 | (37.8042838008308, -122.421879520521) | 5 | 9 | 1 | 28858 | 32 | |||
| 120758 | 237973 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 47 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6005397.27572 | 2103411.57149 | 37.7558728147995 | -122.424305073936 | (37.7558728147995, -122.424305073936) | 2 | 4 | 5 | 28859 | 19 | |||
| 131389 | 214396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 195 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 5994309.48311 | 2098688.20376 | 37.742271315265 | -122.462307427938 | (37.742271315265, -122.462307427938) | 1 | 8 | 4 | 59 | 40 | |||
| 145110 | 214397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 195 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5994296.95298 | 2098696.80879 | 37.7422942210096 | -122.462351376935 | (37.7422942210096, -122.462351376935) | 1 | 8 | 4 | 59 | 40 | |||
| 147239 | 214382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1935 16th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5991235.49714 | 2102232.23855 | 37.7518248322674 | -122.473194631436 | (37.7518248322674, -122.473194631436) | 1 | 8 | 4 | 29491 | 12 | |||
| 149783 | 238018 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) | 15 | 5 | 5 | 29492 | 9 | |||
| 160982 | 238019 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 50 Ashbury Ter | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 5999588.96153 | 2106868.76746 | 37.7650357310381 | -122.444640522441 | (37.7650357310381, -122.444640522441) | 15 | 5 | 5 | 29492 | 9 | |||
| 162029 | 238017 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 50 Ashbury Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999577.21744 | 2106844.64509 | 37.7649688268778 | -122.444679408227 | (37.7649688268778, -122.444679408227) | 15 | 5 | 5 | 29492 | 9 | |||
| 176913 | 214395 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 191 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5994322.338 | 2098681.31803 | 37.7422531489715 | -122.462262480723 | (37.7422531489715, -122.462262480723) | 1 | 8 | 4 | 59 | 40 | |||
| 1181 | 238014 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999606.96605 | 2106732.73135 | 37.7646632372481 | -122.444568471453 | (37.7646632372481, -122.444568471453) | 15 | 5 | 5 | 29492 | 9 | |||
| 2221 | 238015 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.7646659486903 | -122.444594775755 | (37.7646659486903, -122.444594775755) | 15 | 5 | 5 | 29492 | 9 | |||
| 16606 | 118027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.7804150560022 | -122.497862491352 | (37.7804150560022, -122.497862491352) | 11 | 6 | 2 | 55 | 26 | |||
| 21898 | 214404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 66 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993883.93649 | 2101380.33833 | 37.7496387233569 | -122.463974202658 | (37.7496387233569, -122.463974202658) | 1 | 8 | 4 | 29491 | 40 | |||
| 24845 | 237978 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5998568.18197 | 2106878.54944 | 37.7650042880525 | -122.448171835459 | (37.7650042880525, -122.448171835459) | 15 | 5 | 11 | 29492 | 9 | |||
| 28348 | 118427 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5400 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5981873.51616 | 2111696.39703 | 37.7772641742522 | -122.506270809551 | (37.7772641742522, -122.506270809551) | 11 | 6 | 2 | 55 | 26 | |||
| 38556 | 196406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | 10 | 3 | 8 | 28856 | 29 | |||
| 41889 | 238012 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 170 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5999727.58165 | 2106665.35693 | 37.7644851256196 | -122.444146453789 | (37.7644851256196, -122.444146453789) | 15 | 5 | 5 | 29492 | 9 | |||
| 41956 | 178886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.429146369125 | (37.7205786116989, -122.429146369125) | 9 | 7 | 6 | 28861 | 5 | |||
| 44363 | 178888 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003758.58722 | 2090633.91893 | 37.7206956305865 | -122.429061193425 | (37.7206956305865, -122.429061193425) | 9 | 7 | 6 | 28861 | 5 | |||
| 44784 | 214440 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1746 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992520.38058 | 2103558.15623 | 37.7555397706536 | -122.468847844656 | (37.7555397706536, -122.468847844656) | 1 | 8 | 4 | 56 | 12 | |||
| 45699 | 238010 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1231 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5997428.72694 | 2105545.13928 | 37.7612778769942 | -122.452016696208 | (37.7612778769942, -122.452016696208) | 15 | 5 | 11 | 29492 | 12 | |||
| 49771 | 178924 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000939.25503 | 2093544.20079 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | 9 | 7 | 6 | 28861 | 25 | |||
| 54356 | 178894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000524.98993 | 2088394.35729 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | 9 | 7 | 6 | 28861 | 5 | |||
| 58603 | 178891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 579 Madrid St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.7204375997904 | -122.43356984467 | (37.7204375997904, -122.43356984467) | 9 | 7 | 6 | 28861 | 5 | |||
| 65163 | 237975 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 132 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998055.30969 | 2105976.44068 | 37.7624979926238 | -122.449880705624 | (37.7624979926238, -122.449880705624) | 15 | 5 | 11 | 29492 | 9 | |||
| 73457 | 214411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Ulloa St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995342.99314 | 2098250.40426 | 37.7411286834337 | -122.458702204138 | (37.7411286834337, -122.458702204138) | 1 | 8 | 4 | 59 | 40 | |||
| 82448 | 178887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003747.16271 | 2090614.46015 | 37.7206415543513 | -122.429099297695 | (37.7206415543513, -122.429099297695) | 9 | 7 | 6 | 28861 | 5 | |||
| 88262 | 214412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 441 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5995385.60147 | 2098278.36305 | 37.7412079002216 | -122.458556904286 | (37.7412079002216, -122.458556904286) | 1 | 8 | 4 | 59 | 40 | |||
| 89128 | 237999 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | 2 | 4 | 5 | 28862 | 22 | |
| 93327 | 118023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 455 37th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5984366.09559 | 2112727.46699 | 37.780241619998 | -122.497724458012 | (37.780241619998, -122.497724458012) | 11 | 6 | 2 | 55 | 26 | |||
| 98066 | 237993 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.435959814617 | (37.7504390831161, -122.435959814617) | 2 | 4 | 5 | 28862 | 22 | |||
| 106381 | 214435 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 320 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5993233.77766 | 2104623.70866 | 37.758506690737 | -122.466458158922 | (37.758506690737, -122.466458158922) | 1 | 8 | 4 | 56 | 12 | |||
| 108232 | 178900 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6009581.67769 | 2090926.39169 | 37.721826605402 | -122.408953115987 | (37.721826605402, -122.408953115987) | 9 | 3 | 7 | 309 | 28 | |||
| 113748 | 214427 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 55 Cranleigh Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991235.53196 | 2095666.85517 | 37.7337979784868 | -122.472715858468 | (37.7337979784868, -122.472715858468) | 1 | 8 | 4 | 64 | 40 | |||
| 115314 | 214409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 319 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994299.528 | 2098982.87958 | 37.7430798480616 | -122.462363217409 | (37.7430798480616, -122.462363217409) | 1 | 8 | 4 | 59 | 40 | |||
| 118767 | 178922 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 88 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000972.29348 | 2093568.35179 | 37.7285947987994 | -122.438902705697 | (37.7285947987994, -122.438902705697) | 9 | 7 | 6 | 28861 | 25 | |||
| 121692 | 178923 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 88 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6000952.16838 | 2093553.63725 | 37.7285532510089 | -122.438971225059 | (37.7285532510089, -122.438971225059) | 9 | 7 | 6 | 28861 | 25 | |||
| 135431 | 238013 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999618.47962 | 2106729.85774 | 37.764656004003 | -122.444528442659 | (37.764656004003, -122.444528442659) | 15 | 5 | 5 | 29492 | 9 | |||
| 136382 | 237979 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 823 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999103.16972 | 2107519.69828 | 37.7667952905854 | -122.446367580505 | (37.7667952905854, -122.446367580505) | 15 | 5 | 11 | 29492 | 9 | |||
| 137604 | 238002 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1471 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003322.02861 | 2099674.87097 | 37.7454953128593 | -122.431215240608 | (37.7454953128593, -122.431215240608) | 2 | 7 | 5 | 63 | 22 | |||
| 143215 | 238011 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 170 Upper Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999678.69839 | 2106620.27376 | 37.7643585496334 | -122.444312287003 | (37.7643585496334, -122.444312287003) | 15 | 5 | 5 | 29492 | 9 | |||
| 145256 | 214417 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994480.56308 | 2091128.35436 | 37.7215236696771 | -122.461168031889 | (37.7215236696771, -122.461168031889) | 9 | 8 | 6 | 28861 | 24 | |||
| 149281 | 118431 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | 11 | 6 | 2 | 55 | 26 | |||
| 163824 | 237997 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 4160 23rd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6002093.96349 | 2102384.78862 | 37.7528664342394 | -122.435655530791 | (37.7528664342394, -122.435655530791) | 2 | 4 | 5 | 28862 | 22 | |||
| 168648 | 238003 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 860 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000870.32995 | 2102023.89699 | 37.7518059348134 | -122.439861199541 | (37.7518059348134, -122.439861199541) | 2 | 4 | 5 | 28862 | 22 | |||
| 172218 | 178965 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002497.19746 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | 9 | 7 | 6 | 28861 | 5 | |||
| 182049 | 118024 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 455 37th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5984366.77643 | 2112718.2833 | 37.7802164441611 | -122.497721424423 | (37.7802164441611, -122.497721424423) | 11 | 6 | 2 | 55 | 26 | |||
| 184801 | 118429 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | 11 | 6 | 2 | 55 | 26 | |||
| 185297 | 214410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 319 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994311.31652 | 2098976.32342 | 37.7430625253047 | -122.462321980781 | (37.7430625253047, -122.462321980781) | 1 | 8 | 4 | 59 | 40 | |||
| 3542 | 214446 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 500 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993157.34712 | 2099454.91856 | 37.7443101107192 | -122.46634683724 | (37.7443101107192, -122.46634683724) | 1 | 8 | 4 | 29491 | 40 | |||
| 4216 | 135900 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 12 Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006826.33833 | 2115526.46894 | 37.7892180233479 | -122.420222690545 | (37.7892180233479, -122.420222690545) | 13 | 9 | 10 | 28858 | 21 | |||
| 4260 | 178882 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | 9 | 7 | 6 | 28861 | 5 | |||
| 6548 | 178944 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 202 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004727.85531 | 2094036.32936 | 37.7300927194874 | -122.425952806385 | (37.7300927194874, -122.425952806385) | 9 | 7 | 6 | 28861 | 5 | |||
| 7568 | 247783 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 278 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004785 | 2098454 | 37.7422258778278 | -122.426069615856 | (37.7422258778278, -122.426069615856) | 2 | 7 | 5 | 63 | 22 | |||
| 15690 | 214433 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993395.62301 | 2105048.89443 | 37.7596834779287 | -122.465929324277 | (37.7596834779287, -122.465929324277) | 1 | 8 | 4 | 56 | 12 | |||
| 17707 | 196376 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012181.96532 | 2112407.5214 | 37.7809544381487 | -122.40147347254 | (37.7809544381487, -122.40147347254) | 6 | 2 | 9 | 28856 | 34 | |||
| 18391 | 214451 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | 1 | 8 | 4 | 29491 | 40 | |||
| 19300 | 214438 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1237 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993585.37565 | 2107057.08841 | 37.7652083981778 | -122.465418951844 | (37.7652083981778, -122.465418951844) | 11 | 8 | 11 | 56 | 12 | |||
| 20362 | 237988 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 114 Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005544.33972 | 2096386.43433 | 37.7365916954539 | -122.42329710838 | (37.7365916954539, -122.42329710838) | 2 | 7 | 7 | 28859 | 2 | |||
| 20865 | 196378 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012410.67338 | 2112360.21924 | 37.7808373158188 | -122.400678929615 | (37.7808373158188, -122.400678929615) | 6 | 2 | 9 | 28856 | 34 | |||
| 21027 | 196418 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010052.79507 | 2110841.75773 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | 8 | 2 | 9 | 28853 | 34 | |||
| 22237 | 214456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001455.73616 | 2094912.80793 | 37.7323138605989 | -122.437327650168 | (37.7323138605989, -122.437327650168) | 9 | 7 | 4 | 63 | 40 | |||
| 22463 | 196415 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.7765984252192 | -122.408805329496 | (37.7765984252192, -122.408805329496) | 8 | 2 | 9 | 28853 | 34 | |||
| 23329 | 178962 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 217 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007226.63785 | 2092632.02114 | 37.7263776956646 | -122.417214704709 | (37.7263776956646, -122.417214704709) | 9 | 3 | 7 | 309 | 28 | |||
| 25804 | 196403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 140 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010340.69149 | 2110544.62696 | 37.7757364574022 | -122.407711985019 | (37.7757364574022, -122.407711985019) | 8 | 2 | 9 | 28853 | 34 | |||
| 26383 | 214390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 291 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992218.06134 | 2097396.8798 | 37.7386050175954 | -122.469444880296 | (37.7386050175954, -122.469444880296) | 1 | 8 | 4 | 59 | 40 | |||
| 27605 | 178906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009976.78188 | 2089389.92306 | 37.7176299046612 | -122.407479066904 | (37.7176299046612, -122.407479066904) | 9 | 7 | 8 | 309 | 39 | |||
| 31967 | 238021 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 142 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999408.51642 | 2107367.43215 | 37.7663946408336 | -122.445300491725 | (37.7663946408336, -122.445300491725) | 15 | 5 | 5 | 29492 | 9 | |||
| 32366 | 196377 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 137 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012419.03852 | 2112368.2176 | 37.7808597440141 | -122.400650552379 | (37.7808597440141, -122.400650552379) | 6 | 2 | 9 | 28856 | 34 | |||
| 32514 | 246499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.83338 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | 2 | 7 | 5 | 63 | 22 | |
| 32809 | 237984 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 124 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004243.12433 | 2095170.90257 | 37.7331805965962 | -122.427709389171 | (37.7331805965962, -122.427709389171) | 9 | 7 | 5 | 28861 | 25 | |||
| 33631 | 214444 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992635.01675 | 2098889.72124 | 37.7427280701488 | -122.468111823327 | (37.7427280701488, -122.468111823327) | 1 | 8 | 4 | 29491 | 40 | |||
| 38236 | 238031 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3896 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002524.05826 | 2102994.76083 | 37.7545656924717 | -122.43421178796 | (37.7545656924717, -122.43421178796) | 2 | 4 | 5 | 28862 | 22 | |||
| 40414 | 214471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000292.89042 | 2094938.17921 | 37.7323173490585 | -122.441349683656 | (37.7323173490585, -122.441349683656) | 9 | 7 | 4 | 63 | 40 | |||
| 40657 | 237998 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 338 Hoffman Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000611.91644 | 2101788.98208 | 37.7511462020375 | -122.440737977395 | (37.7511462020375, -122.440737977395) | 2 | 4 | 5 | 28862 | 22 | |||
| 41243 | 196386 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 462 Stillman St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6013883.34247 | 2112854.56717 | 37.7822767077361 | -122.395618857241 | (37.7822767077361, -122.395618857241) | 6 | 2 | 9 | 28856 | 6 | |||
| 41313 | 196392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6013963.53714 | 2112927.48749 | 37.7824813907387 | -122.395346527235 | (37.7824813907387, -122.395346527235) | 6 | 2 | 9 | 28856 | 6 | |||
| 41559 | 135907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | 5 | 1 | 1 | 308 | 32 |
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) );