trees
4,014 rows where qSpecies_id = 40 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57761 | 124180 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Almaden Ct | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 9ft | 5995876 | 2112606 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | 11 | 6 | 2 | 54 | 16 | |||
134486 | 196470 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6013295.58948 | 2097174.20298 | 37.7391891560441 | -122.396552730329 | (37.7391891560441, -122.396552730329) | 10 | 3 | 8 | 58 | 1 | |||
35589 | 214784 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 222 Fowler Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 50 | Width 8ft | 5997118.36808 | 2099147.53648 | 37.7436938709906 | -122.452628360234 | (37.7436938709906, -122.452628360234) | 9 | 7 | 4 | 59 | 40 | |||
55343 | 179153 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 412 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 8ft | 6001969.08964 | 2086773.82028 | 37.7099951946836 | -122.434970999229 | (37.7099951946836, -122.434970999229) | 9 | 7 | 6 | 28861 | 5 | |||
68318 | 237063 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 132 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6005626.63256 | 2100241.78482 | 37.7471822602654 | -122.423286564723 | (37.7471822602654, -122.423286564723) | 2 | 7 | 5 | 28859 | 22 | |||
73476 | 124184 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 18 Almaden Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5995890.93647 | 2112594.82496 | 37.7805462717533 | -122.457845381425 | (37.7805462717533, -122.457845381425) | 11 | 6 | 2 | 54 | 16 | |||
82028 | 237426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4301 26th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6001882.89987 | 2100571.76133 | 37.7478763021598 | -122.436255687975 | (37.7478763021598, -122.436255687975) | 2 | 4 | 5 | 63 | 22 | |||
117443 | 214826 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 115 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5999324.23026 | 2093457.23325 | 37.7281957885028 | -122.444592150628 | (37.7281957885028, -122.444592150628) | 9 | 7 | 4 | 28861 | 40 | |||
132358 | 238528 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 28 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6003301.96281 | 2097731.40275 | 37.7401578616993 | -122.431145932563 | (37.7401578616993, -122.431145932563) | 2 | 7 | 5 | 63 | 7 | |||
135045 | 135943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5999351.77852 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | 13 | 9 | 1 | 57 | 17 | |||
172521 | 117710 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 477 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | 11 | 6 | 2 | 55 | 26 | |||
176507 | 136014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6007575.68988 | 2119392.22094 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | 5 | 1 | 1 | 28858 | 32 | |||
100129 | 238045 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 38 Dolores St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6004739.1194 | 2107851.95841 | 37.7680278762037 | -122.426897421898 | (37.7680278762037, -122.426897421898) | 8 | 4 | 5 | 28862 | 3 | |||
173058 | 202147 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1979 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012955.25231 | 2093506.82348 | 37.7291003454988 | -122.397472339298 | (37.7291003454988, -122.397472339298) | 10 | 3 | 8 | 58 | 1 | |||
190080 | 196481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2075 Palou Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6012348.97653 | 2097093.78891 | 37.738915629056 | -122.399820067148 | (37.738915629056, -122.399820067148) | 10 | 3 | 8 | 58 | 1 | |||
13146 | 237136 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1346 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6010061.84572 | 2101335.33586 | 37.7504342222613 | -122.408026983369 | (37.7504342222613, -122.408026983369) | 2 | 4 | 7 | 28859 | 19 | |||
22481 | 237058 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 61 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6006122.75596 | 2099931.66618 | 37.7463587321654 | -122.421548984621 | (37.7463587321654, -122.421548984621) | 2 | 7 | 5 | 28859 | 2 | |||
24728 | 237122 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2957 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6009722.71045 | 2101009.10522 | 37.7495194714422 | -122.40917672522 | (37.7495194714422, -122.40917672522) | 2 | 4 | 7 | 28859 | 19 | |||
37177 | 250524 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.45058 | 2115374.99193 | 37.7877049922276 | -122.486435864334 | (37.7877049922276, -122.486435864334) | 11 | 6 | 1 | 55 | 33 | |||
42800 | 239467 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1285 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 5997501.9107 | 2105032.0283 | 37.7598731953164 | -122.451726570432 | (37.7598731953164, -122.451726570432) | 15 | 5 | 11 | 29492 | 12 | |||
47652 | 237060 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6006047.42812 | 2099152.06421 | 37.7442138742778 | -122.421754094776 | (37.7442138742778, -122.421754094776) | 2 | 7 | 7 | 28859 | 2 | |||
51846 | 120353 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5988483.64082 | 2114700.05239 | 37.7858982939261 | -122.483624810328 | (37.7858982939261, -122.483624810328) | 11 | 6 | 1 | 55 | 33 | |||
54306 | 237027 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 8 | : | Tree | Private 2 | 5 | Width 6ft | 6005758.33223 | 2109504.65873 | 37.7726233714135 | -122.423489581302 | (37.7726233714135, -122.423489581302) | 7 | 9 | 11 | 28852 | 10 | |||
54488 | 250523 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.92853 | 2115397.50584 | 37.7877668368263 | -122.48643586434 | (37.7877668368263, -122.48643586434) | 11 | 6 | 1 | 55 | 33 | |||
54770 | 237029 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 10 | : | Tree | Private 2 | 3 | Width 6ft | 6005753.2097 | 2109536.23847 | 37.7727097926437 | -122.423509546241 | (37.7727097926437, -122.423509546241) | 7 | 9 | 11 | 28852 | 10 | |||
55857 | 237026 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 7 | : | Tree | Private 2 | 3 | Width 6ft | 6005759.75569 | 2109493.68206 | 37.7725933124646 | -122.423483876889 | (37.7725933124646, -122.423483876889) | 7 | 9 | 11 | 28852 | 10 | |||
56562 | 213680 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6001486.95332 | 2094958.62798 | 37.7324414465191 | -122.437223005055 | (37.7324414465191, -122.437223005055) | 9 | 7 | 5 | 63 | 40 | |||
59328 | 214696 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 550 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 5994229.95008 | 2099570.53066 | 37.744689383614 | -122.462646416624 | (37.744689383614, -122.462646416624) | 1 | 8 | 4 | 29491 | 40 | |||
68091 | 214698 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 550 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 5994208.79657 | 2099551.1927 | 37.7446350681495 | -122.462718158229 | (37.7446350681495, -122.462718158229) | 1 | 8 | 4 | 29491 | 40 | |||
68216 | 214699 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 572 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 5994083.55737 | 2099431.17375 | 37.7442983125168 | -122.46314250065 | (37.7442983125168, -122.46314250065) | 1 | 8 | 4 | 29491 | 40 | |||
70509 | 214483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5990967.17432 | 2102702.632 | 37.7531008695265 | -122.474156838569 | (37.7531008695265, -122.474156838569) | 1 | 8 | 4 | 56 | 12 | |||
101721 | 237025 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 6 | : | Tree | Private 2 | 3 | Width 6ft | 6005760.04076 | 2109480.81274 | 37.7725579925006 | -122.423481975714 | (37.7725579925006, -122.423481975714) | 7 | 9 | 11 | 28852 | 10 | |||
105011 | 237448 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4609 25th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 6ft | 6000549.98027 | 2101082.72419 | 37.7492034604754 | -122.440901499304 | (37.7492034604754, -122.440901499304) | 2 | 4 | 5 | 28862 | 22 | |||
108120 | 237059 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 199 Tiffany Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006039.83494 | 2099139.16123 | 37.7441780174179 | -122.421779434069 | (37.7441780174179, -122.421779434069) | 2 | 7 | 7 | 28859 | 2 | |||
108615 | 237153 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 758 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6010110.83147 | 2104756.28299 | 37.7598301222807 | -122.408098819429 | (37.7598301222807, -122.408098819429) | 2 | 4 | 8 | 28859 | 19 | |||
112202 | 237127 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 501 York St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6009827.96491 | 2105859.23915 | 37.7628427477209 | -122.409154949944 | (37.7628427477209, -122.409154949944) | 8 | 4 | 8 | 28859 | 19 | |||
112941 | 179011 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 579 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001850.91399 | 2090131.7943 | 37.7192087373638 | -122.435619512955 | (37.7192087373638, -122.435619512955) | 9 | 7 | 6 | 28861 | 5 | |||
130974 | 214697 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 550 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 5994224.09398 | 2099564.9387 | 37.7446736922334 | -122.462666260157 | (37.7446736922334, -122.462666260157) | 1 | 8 | 4 | 29491 | 40 | |||
131806 | 250521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 95 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5987685.5238 | 2115445.0256 | 37.7878972888638 | -122.486440754852 | (37.7878972888638, -122.486440754852) | 11 | 6 | 1 | 55 | 33 | |||
137806 | 214484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1868 17th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5990968.36883 | 2102715.12154 | 37.7531352317224 | -122.474153618996 | (37.7531352317224, -122.474153618996) | 1 | 8 | 4 | 56 | 12 | |||
139963 | 237123 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1049 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6008643.89723 | 2102440.90127 | 37.7533903648753 | -122.413008530528 | (37.7533903648753, -122.413008530528) | 2 | 4 | 7 | 28859 | 19 | |||
142295 | 196471 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | 10 | 3 | 8 | 58 | 1 | |||
144027 | 179012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001860.73543 | 2090148.27679 | 37.7192545524417 | -122.435586742551 | (37.7192545524417, -122.435586742551) | 9 | 7 | 6 | 28861 | 5 | |||
149007 | 237154 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | 10 | 4 | 7 | 28859 | 19 | |
153268 | 179161 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 233 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002647.79999 | 2086739.65434 | 37.7099398962889 | -122.432622809119 | (37.7099398962889, -122.432622809119) | 9 | 7 | 6 | 28861 | 5 | |||
154393 | 237135 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1346 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010061.02642 | 2101350.15065 | 37.7504748545291 | -122.408030861231 | (37.7504748545291, -122.408030861231) | 2 | 4 | 7 | 28859 | 19 | |||
161262 | 214700 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 200x Vasquez Ave | 2 | Median : Cutout | Tree | DPW 1 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | 1 | 8 | 4 | 59 | 40 | |||
167908 | 213290 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.72101711662 | -122.462357593044 | (37.72101711662, -122.462357593044) | 9 | 8 | 6 | 28861 | 24 | |||
177224 | 237137 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1447 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6010126.81888 | 2100822.77716 | 37.7490304866626 | -122.40776616289 | (37.7490304866626, -122.40776616289) | 2 | 4 | 7 | 28859 | 19 | |||
182970 | 237141 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1247 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6010327.59386 | 2101954.7488 | 37.7521498688327 | -122.407151659747 | (37.7521498688327, -122.407151659747) | 10 | 4 | 7 | 28859 | 19 | |||
183872 | 179013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001863.70015 | 2090153.04553 | 37.719267814726 | -122.435576835623 | (37.719267814726, -122.435576835623) | 9 | 7 | 6 | 28861 | 5 | |||
186661 | 237062 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 189 Tiffany Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006064.26727 | 2099183.21264 | 37.7443003503954 | -122.421698080498 | (37.7443003503954, -122.421698080498) | 2 | 7 | 7 | 28859 | 2 | |||
192928 | 237124 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6008637.74753 | 2102555.44614 | 37.7537045340508 | -122.413037896084 | (37.7537045340508, -122.413037896084) | 2 | 4 | 7 | 28859 | 19 | |||
11603 | 238318 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 23 Clover Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6000458.56738 | 2105088.99316 | 37.7601984944918 | -122.441505054123 | (37.7601984944918, -122.441505054123) | 2 | 4 | 5 | 28862 | 3 | |||
13155 | 196442 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 971 Kansas St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 5ft | 6011633.49107 | 2103859.13783 | 37.7574518984069 | -122.402769561075 | (37.7574518984069, -122.402769561075) | 10 | 3 | 8 | 28856 | 29 | |||
30595 | 237093 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006628.38963 | 2107330.3055 | 37.7667021837902 | -122.420325599041 | (37.7667021837902, -122.420325599041) | 8 | 4 | 7 | 28853 | 19 | |||
34471 | 237092 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006640.82063 | 2107331.42339 | 37.766705953729 | -122.420282681595 | (37.766705953729, -122.420282681595) | 8 | 4 | 7 | 28853 | 19 | |||
36326 | 238106 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006183.4276 | 2102112.77314 | 37.7523509743301 | -122.421494063899 | (37.7523509743301, -122.421494063899) | 2 | 4 | 5 | 28859 | 19 | |||
36815 | 238227 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6004074.9323 | 2102707.38646 | 37.753864531534 | -122.428827968657 | (37.753864531534, -122.428827968657) | 2 | 4 | 5 | 28862 | 22 | |||
37146 | 237434 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1206 Diamond St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6001928.49113 | 2100507.97364 | 37.7477037465288 | -122.436093471852 | (37.7477037465288, -122.436093471852) | 2 | 4 | 5 | 63 | 22 | |||
44034 | 237074 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 405 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6005515.14346 | 2101298.89105 | 37.7500785385947 | -122.423747237058 | (37.7500785385947, -122.423747237058) | 2 | 4 | 5 | 28859 | 19 | |||
44806 | 179033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 88 Alpha St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6011104.28456 | 2088327.78048 | 37.7147765222032 | -122.40350709418 | (37.7147765222032, -122.40350709418) | 9 | 7 | 8 | 309 | 39 | |||
45071 | 237079 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6011116.28674 | 2102209.61891 | 37.7528937925351 | -122.404442163398 | (37.7528937925351, -122.404442163398) | 10 | 4 | 8 | 28859 | 19 | |||
46479 | 213682 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.439840520538 | (37.7325501736469, -122.439840520538) | 9 | 7 | 5 | 63 | 40 | |||
52400 | 237433 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1206 Diamond St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6001927.83941 | 2100530.44886 | 37.7477654211388 | -122.436097333527 | (37.7477654211388, -122.436097333527) | 2 | 4 | 5 | 63 | 22 | |||
64309 | 179034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 88 Alpha St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6011090.19294 | 2088313.27178 | 37.7147358971229 | -122.403554780747 | (37.7147358971229, -122.403554780747) | 9 | 7 | 8 | 309 | 39 | |||
65480 | 196425 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011155.75972 | 2111427.64984 | 37.7782066270623 | -122.404954631245 | (37.7782066270623, -122.404954631245) | 14 | 2 | 9 | 28856 | 34 | |||
68282 | 237087 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006704.33245 | 2107335.95471 | 37.7667219742591 | -122.420063326182 | (37.7667219742591, -122.420063326182) | 8 | 4 | 7 | 28853 | 19 | |||
71083 | 238254 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6002935.27424 | 2105635.73424 | 37.7618405036566 | -122.432978365964 | (37.7618405036566, -122.432978365964) | 15 | 4 | 5 | 28862 | 3 | |||
75405 | 213683 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Baden St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6000730.40073 | 2094998.07335 | 37.732506718412 | -122.43984140637 | (37.732506718412, -122.43984140637) | 9 | 7 | 5 | 63 | 40 | |||
75617 | 237152 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 601 Hampshire St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6010131.84271 | 2105445.94414 | 37.7617249524607 | -122.408074789522 | (37.7617249524607, -122.408074789522) | 10 | 4 | 8 | 28859 | 19 | |||
75881 | 237088 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006692.25312 | 2107335.17282 | 37.7667191467912 | -122.420105051126 | (37.7667191467912, -122.420105051126) | 8 | 4 | 7 | 28853 | 19 | |||
76301 | 237094 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006486.26316 | 2107324.29875 | 37.7666776808499 | -122.420816764707 | (37.7666776808499, -122.420816764707) | 8 | 4 | 7 | 28853 | 19 | |||
80154 | 135938 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Walnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998466.03707 | 2116398.73144 | 37.7911384032693 | -122.44921105427 | (37.7911384032693, -122.44921105427) | 13 | 6 | 1 | 54 | 31 | |||
87789 | 238223 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 151 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6004139.72853 | 2102237.92914 | 37.7525791790987 | -122.428570427086 | (37.7525791790987, -122.428570427086) | 2 | 4 | 5 | 28862 | 22 | |||
95145 | 196444 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200x Kansas St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | 10 | 3 | 8 | 28856 | 29 | |||
106741 | 237151 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 601 Hampshire St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010131.8746 | 2105435.17727 | 37.7616953908578 | -122.40807391988 | (37.7616953908578, -122.40807391988) | 10 | 4 | 8 | 28859 | 19 | |||
113427 | 213319 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 262 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991459.9673 | 2090912.89222 | 37.7207577701313 | -122.471593616958 | (37.7207577701313, -122.471593616958) | 9 | 8 | 6 | 64 | 24 | |||
116299 | 213681 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | 9 | 7 | 5 | 63 | 40 | |||
118444 | 238226 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 62 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004072.81767 | 2102724.1328 | 37.7539103933597 | -122.428836475319 | (37.7539103933597, -122.428836475319) | 2 | 4 | 5 | 28862 | 22 | |||
121822 | 213320 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 238 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991458.7746 | 2090762.70401 | 37.7203453212587 | -122.471586801009 | (37.7203453212587, -122.471586801009) | 9 | 8 | 6 | 64 | 24 | |||
126995 | 238317 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 80 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6000563.23083 | 2104921.82591 | 37.7597454565059 | -122.441131080058 | (37.7597454565059, -122.441131080058) | 2 | 4 | 5 | 28862 | 3 | |||
130656 | 239548 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 229 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6006756.29841 | 2097775.01539 | 37.7404727557057 | -122.419205308176 | (37.7404727557057, -122.419205308176) | 2 | 7 | 7 | 28859 | 2 | |||
134702 | 213383 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 337 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5996461.62761 | 2106582.16791 | 37.7640698501549 | -122.455436416867 | (37.7640698501549, -122.455436416867) | 15 | 5 | 11 | 29492 | 12 | |||
143147 | 237089 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006678.09953 | 2107334.09058 | 37.7667153777448 | -122.420153929277 | (37.7667153777448, -122.420153929277) | 8 | 4 | 7 | 28853 | 19 | |||
144435 | 179115 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Yale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006932.90152 | 2093437.92283 | 37.7285739974769 | -122.41828725417 | (37.7285739974769, -122.41828725417) | 9 | 3 | 7 | 309 | 5 | |||
147930 | 237099 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3571 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6005122.29654 | 2106016.88493 | 37.7630108606773 | -122.425441442891 | (37.7630108606773, -122.425441442891) | 8 | 4 | 5 | 28859 | 19 | |||
155565 | 237150 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 601 Hampshire St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010131.8199 | 2105423.31362 | 37.7616628128969 | -122.408073272368 | (37.7616628128969, -122.408073272368) | 10 | 4 | 8 | 28859 | 19 | |||
157397 | 237090 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006663.58723 | 2107332.32887 | 37.766709722802 | -122.420203999914 | (37.766709722802, -122.420203999914) | 8 | 4 | 7 | 28853 | 19 | |||
160529 | 213384 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 337 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5996440.69022 | 2106573.21313 | 37.7640440612137 | -122.455508185479 | (37.7640440612137, -122.455508185479) | 15 | 5 | 11 | 29492 | 12 | |||
171595 | 120701 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 70 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5988982.8407 | 2114887.49266 | 37.7864419959893 | -122.481911472455 | (37.7864419959893, -122.481911472455) | 11 | 6 | 1 | 55 | 33 | |||
172702 | 237091 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006652.56263 | 2107332.55511 | 37.7667097228027 | -122.420242148266 | (37.7667097228027, -122.420242148266) | 8 | 4 | 7 | 28853 | 19 | |||
182517 | 196437 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2125 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6011358.58417 | 2105543.63854 | 37.7620618088278 | -122.403838835192 | (37.7620618088278, -122.403838835192) | 10 | 3 | 8 | 28856 | 29 | |||
182841 | 237149 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 601 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010132.87275 | 2105399.32846 | 37.7615970140239 | -122.408067939392 | (37.7615970140239, -122.408067939392) | 10 | 4 | 8 | 28859 | 19 | |||
184491 | 237095 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006471.77901 | 2107323.90958 | 37.7666757958826 | -122.420866835358 | (37.7666757958826, -122.420866835358) | 8 | 4 | 7 | 28853 | 19 | |||
184890 | 135939 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Walnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998471.02227 | 2116380.33284 | 37.7910881707365 | -122.449192479647 | (37.7910881707365, -122.449192479647) | 13 | 6 | 1 | 54 | 31 | |||
189116 | 214480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1406 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5990546.58136 | 2105796.37428 | 37.7615710910435 | -122.475837228101 | (37.7615710910435, -122.475837228101) | 1 | 8 | 4 | 56 | 12 | |||
192887 | 238107 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006184.05234 | 2102126.82183 | 37.7523895840278 | -122.421492901086 | (37.7523895840278, -122.421492901086) | 2 | 4 | 5 | 28859 | 19 | |||
78 | 237365 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2463 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008244.71386 | 2104091.00553 | 37.7578987598438 | -122.414505749733 | (37.7578987598438, -122.414505749733) | 2 | 4 | 7 | 28859 | 19 | |||
3465 | 123273 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 578 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | 11 | 6 | 2 | 54 | 11 |
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) );