trees
2,694 rows where qSpecies_id = 84 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
| 339 | 18096 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.7864812852303 | -122.445770680231 | (37.7864812852303, -122.445770680231) | 15 | 6 | 1 | 29490 | 31 | ||
| 647 | 259570 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
| 655 | 73536 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | 1 | 8 | 3 | 29491 | 35 | |||
| 884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 940 | 71166 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2123 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100838.0598 | 37.747820074212 | -122.483618518196 | (37.747820074212, -122.483618518196) | 1 | 8 | 3 | 29491 | 35 | |||
| 1003 | 72752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988097.7754 | 2104798.077 | 37.758687755803 | -122.484233325891 | (37.758687755803, -122.484233325891) | 1 | 8 | 3 | 56 | 35 | |||
| 1086 | 91876 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2015 02:50:00 PM | 3 | 3x3 | 5993617.143263 | 2106666.291015 | 37.7641372031802 | -122.465280687147 | (37.7641372031802, -122.465280687147) | 11 | 8 | 11 | 56 | 12 | ||
| 1149 | 259572 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 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 | |||
| 1301 | 183453 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2519 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989212.7579 | 2098154.5204 | 37.7405111636594 | -122.4798910928 | (37.7405111636594, -122.4798910928) | 1 | 8 | 3 | 29491 | 35 | |||
| 1474 | 86100 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2628 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097431.8111 | 37.738512846905 | -122.480667939289 | (37.738512846905, -122.480667939289) | 1 | 8 | 3 | 29491 | 35 | ||
| 1659 | 65957 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2451 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 6 | Permit Number 28979 | 5987645.5214 | 2098612.1125 | 37.7416764134378 | -122.485343487905 | (37.7416764134378, -122.485343487905) | 1 | 8 | 3 | 29491 | 35 | ||
| 1668 | 86560 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.485018839299 | (37.7522790893532, -122.485018839299) | 1 | 8 | 3 | 56 | 35 | ||
| 1745 | 72898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2476 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990180.6745 | 2098530.744 | 37.7416003626627 | -122.476571927541 | (37.7416003626627, -122.476571927541) | 1 | 8 | 3 | 29491 | 35 | |||
| 1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
| 1818 | 38898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.7833176557587 | -122.454612555673 | (37.7833176557587, -122.454612555673) | 11 | 6 | 1 | 54 | 31 | |
| 1828 | 98097 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.7891705031567 | -122.420050723983 | (37.7891705031567, -122.420050723983) | 13 | 9 | 10 | 28858 | 21 | |||
| 1869 | 71210 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988533.228 | 2099925.3582 | 37.7453339163785 | -122.482370330567 | (37.7453339163785, -122.482370330567) | 1 | 8 | 3 | 29491 | 35 | |||
| 1961 | 259574 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Public Park | 4 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
| 2005 | 23894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | 13 | 9 | 11 | 29490 | 13 | ||
| 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 | |||
| 2537 | 245955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 450 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997557.5774 | 2107478.8878 | 37.7665948394439 | -122.45171055689 | (37.7665948394439, -122.45171055689) | 15 | 5 | 11 | 29492 | 9 | |||
| 2833 | 47893 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 745 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 6 | Permit Number 48331 | 6000477.4696 | 2111570.4889 | 37.7779961374161 | -122.441904890309 | (37.7779961374161, -122.441904890309) | 15 | 5 | 11 | 29490 | 16 | |
| 3027 | 214407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200x Terrace Dr | 11 | Median : Yard | Tree | DPW 1 | 8 | 5993812.00581 | 2096497.75562 | 37.7362282335302 | -122.463868579087 | (37.7362282335302, -122.463868579087) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | |||
| 3297 | 183411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2350 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5985672.7267 | 2097039.7501 | 37.737243998747 | -122.492048913642 | (37.737243998747, -122.492048913642) | 1 | 8 | 3 | 29491 | 35 | |||
| 3508 | 95024 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 3665 | 261403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 746 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010031.95335 | 2118510.77151 | 37.797592298166 | -122.409342294069 | (37.797592298166, -122.409342294069) | 3 | 1 | 10 | 308 | 4 | |||||
| 3715 | 137933 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003135 | 2115313 | 37.788423206128 | -122.432979003927 | (37.788423206128, -122.432979003927) | 13 | 9 | 1 | 29490 | 27 | |||
| 3849 | 27720 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2015 06:49:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.7501876266135 | -122.390460137824 | (37.7501876266135, -122.390460137824) | 10 | 3 | 8 | 28856 | 1 | ||
| 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 | |||
| 3967 | 72444 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1733 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5999558.0145 | 2110143.3213 | 37.7740250637938 | -122.444982979337 | (37.7740250637938, -122.444982979337) | 15 | 5 | 11 | 29492 | 16 | |||
| 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 | |||
| 4233 | 27745 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1399 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | ||
| 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 | |||
| 4437 | 244983 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | 7 | 9 | 11 | 28852 | 10 | |
| 4516 | 259272 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2019 12:00:00 AM | 3 | 6009597.7323 | 2119503.87292 | 37.8002947722719 | -122.410914999374 | (37.8002947722719, -122.410914999374) | 3 | 1 | 10 | 308 | 4 | |||
| 4562 | 261421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
| 4734 | 63548 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 942 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 10 | Permit Number 24164 | 5999530.709 | 2111776.0946 | 37.7785066833069 | -122.445194846179 | (37.7785066833069, -122.445194846179) | 15 | 5 | 11 | 29490 | 16 | |
| 4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 5050 | 182572 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2212 Ulloa St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5989118.5154 | 2098355.8518 | 37.7410584915124 | -122.480231674803 | (37.7410584915124, -122.480231674803) | 1 | 8 | 3 | 29491 | 35 | |||
| 5081 | 69491 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 57 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 3 | Permit Number 33613 | 6002842.65111 | 2094614.47792 | 37.7315734613241 | -122.43251146945 | (37.7315734613241, -122.43251146945) | 9 | 7 | 5 | 28861 | 25 | |
| 5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 5252 | 253357 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | 13 | 9 | 11 | 29490 | 13 | ||
| 5592 | 43851 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.7371308274945 | -122.49349719028 | (37.7371308274945, -122.49349719028) | 1 | 8 | 3 | 29491 | 35 | |
| 5710 | 261400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 730 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010100.55131 | 2118520.19892 | 37.7976220266446 | -122.409105591228 | (37.7976220266446, -122.409105591228) | 3 | 1 | 10 | 308 | 4 | |||||
| 5766 | 69922 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | 1 | 8 | 3 | 56 | 35 | |||
| 6155 | 247321 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 212 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002821 | 2109296 | 37.7718842175888 | -122.433635197846 | (37.7718842175888, -122.433635197846) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 6602 | 89550 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981409.78222 | 2111623.31383 | 37.7770361978186 | -122.507869561004 | (37.7770361978186, -122.507869561004) | 11 | 6 | 2 | 55 | 26 | ||
| 6847 | 260435 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 917 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992908 | 2106572 | 37.7638373839544 | -122.467726529112 | (37.7638373839544, -122.467726529112) | 1 | 8 | 11 | 56 | 12 | ||||
| 6906 | 48666 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1715REVISED Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2002 12:00:00 AM | 1 | Permit Number 45950 | 6004823.677 | 2115363.4456 | 37.7886573555281 | -122.427140041517 | (37.7886573555281, -122.427140041517) | 13 | 9 | 11 | 28858 | 27 | |
| 6947 | 23903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | 13 | 9 | 11 | 29490 | 13 | |||
| 7068 | 66214 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2233 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1990 12:00:00 AM | 9 | Permit Number 29304 | 5989765.2961 | 2100174.6084 | 37.7460898851299 | -122.47812830871 | (37.7460898851299, -122.47812830871) | 1 | 8 | 3 | 29491 | 35 | ||
| 7392 | 261325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 644 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010473 | 2118597 | 37.79785376133 | -122.407822230627 | (37.79785376133, -122.407822230627) | 3 | 1 | 10 | 308 | 4 | ||||
| 7496 | 71798 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | 15 | 5 | 11 | 29492 | 16 | |||
| 7515 | 70939 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1925 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989075.8648 | 2102218.2021 | 37.7516610101851 | -122.480661823031 | (37.7516610101851, -122.480661823031) | 1 | 8 | 3 | 29491 | 35 | |||
| 7546 | 86580 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2539 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987975.8922 | 2098002.1559 | 37.7400208741264 | -122.484156469463 | (37.7400208741264, -122.484156469463) | 1 | 8 | 3 | 29491 | 35 | ||
| 7567 | 78659 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998369.99191 | 2089313.52564 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 7569 | 86577 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2519 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987971.7931 | 2098127.9672 | 37.740366080244 | -122.484179866453 | (37.740366080244, -122.484179866453) | 1 | 8 | 3 | 29491 | 35 | ||
| 7650 | 28640 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 2 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.7827766127993 | -122.430825656777 | (37.7827766127993, -122.430825656777) | 15 | 9 | 11 | 29490 | 41 | ||
| 7700 | 261404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009997.65437 | 2118506.05781 | 37.7975774337622 | -122.409460645418 | (37.7975774337622, -122.409460645418) | 3 | 1 | 10 | 308 | 4 | |||||
| 7795 | 34636 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1466 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45216 | 5988080.2573 | 2105318.5059 | 37.7601156921394 | -122.484332079774 | (37.7601156921394, -122.484332079774) | 1 | 8 | 3 | 56 | 35 | |
| 7880 | 46205 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2002 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | 1 | 8 | 3 | 56 | 35 | |
| 7942 | 71165 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2119 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988190.2092 | 2100857.5067 | 37.7478733893734 | -122.483624747125 | (37.7478733893734, -122.483624747125) | 1 | 8 | 3 | 29491 | 35 | |||
| 8000 | 71225 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2262 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5987644.7584 | 2099883.1111 | 37.7451661944085 | -122.485439373685 | (37.7451661944085, -122.485439373685) | 1 | 8 | 3 | 29491 | 35 | |||
| 8197 | 65499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1989 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.483742458373 | (37.7446414773793, -122.483742458373) | 1 | 8 | 3 | 29491 | 35 | |
| 8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 8330 | 60243 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1241 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 1 | Permit Number 19795 | 5987983.8428 | 2106825.6856 | 37.7642483811973 | -122.484776093092 | (37.7642483811973, -122.484776093092) | 1 | 8 | 3 | 56 | 35 | |
| 8464 | 92304 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2001 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52751 | 5989091.9697 | 2101683.9526 | 37.7501950388707 | -122.480567026206 | (37.7501950388707, -122.480567026206) | 1 | 8 | 3 | 29491 | 35 |
| 8548 | 138687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2828 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999933.5509 | 2114410.1103 | 37.7857619969761 | -122.443990574135 | (37.7857619969761, -122.443990574135) | 15 | 6 | 1 | 29490 | 31 | |||
| 8574 | 182275 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376 | (37.7591168373077, -122.49474304376) | 1 | 8 | 3 | 56 | 35 | |||
| 8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 8785 | 178959 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007585.1415 | 2091886.23741 | 37.7243500958617 | -122.415922582174 | (37.7243500958617, -122.415922582174) | 9 | 3 | 7 | 309 | 28 | |||
| 8946 | 98096 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 81 Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006843.26628 | 2115504.44745 | 37.789158511592 | -122.420162558272 | (37.789158511592, -122.420162558272) | 13 | 9 | 10 | 28858 | 21 | |||
| 8968 | 261399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 715 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010168.78657 | 2118489.20051 | 37.7975407349103 | -122.408867289597 | (37.7975407349103, -122.408867289597) | 3 | 1 | 10 | 308 | 4 | |||||
| 8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 9198 | 44212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2009 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2001 12:00:00 AM | 2 | Permit Number 43659 | 6003842.4279 | 2115438.8041 | 37.7888087328674 | -122.430540396598 | (37.7888087328674, -122.430540396598) | 13 | 9 | 1 | 29490 | 27 | |
| 9212 | 259382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
| 9392 | 70671 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 73 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010033.5172 | 2110899.92735 | 37.7766948289379 | -122.408799654802 | (37.7766948289379, -122.408799654802) | 8 | 2 | 9 | 28853 | 34 | |||
| 9471 | 119842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9552 | 139978 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | 15 | 5 | 11 | 29490 | 41 | |||
| 9643 | 70441 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982992.9824 | 2098498.3633 | 37.7410919453428 | -122.501421735716 | (37.7410919453428, -122.501421735716) | 1 | 8 | 3 | 29491 | 35 | |||
| 9852 | 31300 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | 7 | 9 | 11 | 28852 | 10 | |
| 9928 | 261390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 638 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010519.78547 | 2118576.37921 | 37.7977997607314 | -122.407658884309 | (37.7977997607314, -122.407658884309) | 3 | 1 | 10 | 308 | 4 | |||||
| 10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 10250 | 261397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 720 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010143.42503 | 2118526.09105 | 37.7976406066987 | -122.408957651874 | (37.7976406066987, -122.408957651874) | 3 | 1 | 10 | 308 | 4 | |||||
| 10332 | 86369 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | 1 | 8 | 3 | 56 | 35 | ||
| 10452 | 182205 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1651 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988079.8655 | 2104054.0379 | 37.7566437831632 | -122.484240699303 | (37.7566437831632, -122.484240699303) | 1 | 8 | 3 | 56 | 35 | |||
| 10794 | 71822 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 5988042.7796 | 2106389.3653 | 37.7630537975137 | -122.484540243852 | (37.7630537975137, -122.484540243852) | 1 | 8 | 3 | 56 | 35 | ||||
| 10978 | 261419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 781 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009855.16282 | 2118445.96033 | 37.7974044358704 | -122.409949461749 | (37.7974044358704, -122.409949461749) | 3 | 1 | 10 | 308 | 4 | |||||
| 11005 | 49212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | 13 | 6 | 1 | 29490 | 27 | |
| 11088 | 79919 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988008.149 | 2106155.0675 | 37.7624084631065 | -122.484642830378 | (37.7624084631065, -122.484642830378) | 1 | 8 | 3 | 56 | 35 | |||
| 11092 | 74333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | 10 | 3 | 8 | 58 | 1 | |||
| 11107 | 78786 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | 15 | 5 | 11 | 29492 | 10 | |||
| 11347 | 85990 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2234 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987638.7841 | 2100062.768 | 37.7456591364178 | -122.485473213008 | (37.7456591364178, -122.485473213008) | 1 | 8 | 3 | 29491 | 35 | ||
| 11410 | 25472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.7142087634879 | -122.464599140586 | (37.7142087634879, -122.464599140586) | 9 | 8 | 6 | 64 | 24 |
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) );