2,694 rows where qSpecies_id = 84 sorted by PermitNotes

View and edit SQL

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
523 92314 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509) 1 8 3 29491 35
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
1475 80073 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2788 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5985889.2586 2096432.3825 37.735588983385 -122.491255586179 (37.735588983385, -122.491255586179) 1 8 3 64 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
1697 92318 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988223 (37.7356241060746, -122.49141988223) 1 8 3 29491 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
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
2220 117168 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 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
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
2591 92319 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2788 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509) 1 8 3 64 35
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
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
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
5244 261407 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2                              
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
6931 92315 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985839.9086 2096474.3035 37.7357012036342 -122.491429290175 (37.7357012036342, -122.491429290175) 1 8 3 29491 35
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
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
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
8270 261411 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 7 Sidewalk: Curb side : Cutout Tree Private 2                              
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                              
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
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
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
11452 110549 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 7 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
11464 71211 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2267 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5988532.3745 2099906.1549 37.7452811395366 -122.48237187504 (37.7452811395366, -122.48237187504) 1 8 3 29491 35
11497 26788 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 78 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/1999 12:00:00 AM 4 3X3   6010596.3656 2087261.1203 37.711819305554 -122.405187615188 (37.711819305554, -122.405187615188) 9 7 8 309 39
11519 261392 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 670 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6010377.23792 2118557.51621 37.7977399869991 -122.408150809713 (37.7977399869991, -122.408150809713) 3 1 10 308 4
11581 98091 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2X Frank Norris St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6007129.63323 2115568.12393 37.7893494826426 -122.419176280756 (37.7893494826426, -122.419176280756) 13 9 10 28858 21
11618 92317 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463) 1 8 3 29491 35
11667 72507 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2135 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5988189.7462 2100767.6803 37.7476267230083 -122.483619763458 (37.7476267230083, -122.483619763458) 1 8 3 29491 35
11993 261391 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 660 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6010421.78403 2118563.41089 37.7977586664904 -122.407997083107 (37.7977586664904, -122.407997083107) 3 1 10 308 4
12101 70886 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2145 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5997606.572 2109869.8792 37.7731626941817 -122.451713589147 (37.7731626941817, -122.451713589147) 15 5 11 29492 16
12189 9378 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 320 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6001091.8143019 2097867.0769739 37.7404048998329 -122.438797433034 (37.7404048998329, -122.438797433034) 2 7 5 63 7
12262 261408 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2                              
12502 261420 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 780 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6009867.40288 2118488.04976 37.7975206891225 -122.409910080478 (37.7975206891225, -122.409910080478) 3 1 10 308 4

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);