trees
172 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 77 sorted by qCaretaker_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35128 | 5454 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 561 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 8 | 6004988.38949 | 2105109.00015 | 37.7605104576133 | -122.425839954961 | (37.7605104576133, -122.425839954961) | 2 | 4 | 5 | 28859 | 19 | ||
52717 | 5516 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.7560425375576 | -122.425422183901 | (37.7560425375576, -122.425422183901) | 2 | 4 | 5 | 28859 | 19 | ||
70362 | 4175 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3812X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6005112.58146 | 2100504.28147 | 37.7478739908906 | -122.425082788743 | (37.7478739908906, -122.425082788743) | 2 | 4 | 5 | 63 | 22 | ||
118812 | 90480 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 139 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988320.04401 | 2115047.37952 | 37.7868424315213 | -122.484216284461 | (37.7868424315213, -122.484216284461) | 11 | 6 | 1 | 55 | 33 | ||
144554 | 28271 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1227 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5 | 6005204.12074 | 2101185.69152 | 37.7497501565604 | -122.424814719731 | (37.7497501565604, -122.424814719731) | 2 | 4 | 5 | 28859 | 19 | |||
165707 | 4211 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3935 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004300.14403 | 2100415.02402 | 37.7475829828864 | -122.427885801087 | (37.7475829828864, -122.427885801087) | 2 | 4 | 5 | 63 | 22 | |||
2376 | 57631 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 724 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1976 12:00:00 AM | 8 | Permit Number 16529 | 6004511.94268 | 2110995.61836 | 37.7766467538829 | -122.427907235555 | (37.7766467538829, -122.427907235555) | 7 | 9 | 11 | 28852 | 10 | |
3654 | 47498 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
10454 | 106790 | Undocumented 4 | Prunus x yedoensis :: Yoshino Cherry 77 | 174 FAIRMOUNT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6004503.2 | 2097272.2 | 37.7389649933023 | -122.426959842808 | (37.7389649933023, -122.426959842808) | 2 | 7 | 5 | 63 | 7 | |||
14337 | 47497 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
17624 | 120418 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 779 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988805.2712 | 2110017.74707 | 37.7730607113316 | -122.482168912555 | (37.7730607113316, -122.482168912555) | 11 | 6 | 2 | 55 | 26 | |||
19457 | 96917 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2151X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768104 | 5988894.20073 | 2110528.61903 | 37.7744685962766 | -122.481898727171 | (37.7744685962766, -122.481898727171) | 11 | 6 | 2 | 55 | 26 | |
19717 | 47020 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 521 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 4 | Permit Number 45015 | 6004890.00739 | 2110720.29512 | 37.7759121642541 | -122.426579788542 | (37.7759121642541, -122.426579788542) | 7 | 9 | 11 | 28852 | 10 | |
21481 | 41610 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
22259 | 31877 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 457 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984054.95538 | 2112747.63581 | 37.7802787535999 | -122.498802308795 | (37.7802787535999, -122.498802308795) | 11 | 6 | 2 | 55 | 26 | ||
22465 | 136051 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 584 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004614.40707 | 2110680.65398 | 37.7757877349621 | -122.427530336862 | (37.7757877349621, -122.427530336862) | 7 | 9 | 11 | 28852 | 10 | |||
24045 | 141370 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001204.6932 | 2110218.0701 | 37.7743241488087 | -122.439292208301 | (37.7743241488087, -122.439292208301) | 15 | 5 | 11 | 29492 | 10 | |||
24291 | 123575 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 118 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994297.68738 | 2114732.87451 | 37.7863251158785 | -122.463512352181 | (37.7863251158785, -122.463512352181) | 11 | 6 | 1 | 54 | 11 | |||
24773 | 98036 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2242 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2011 12:00:00 AM | Permit Number 768378 | 6002381.4 | 2115984.8 | 37.7902250230638 | -122.43563441767 | (37.7902250230638, -122.43563441767) | 13 | 9 | 1 | 29490 | 27 | |||
25428 | 238585 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.58671 | 2103307.08135 | 37.7555862656019 | -122.424275817175 | (37.7555862656019, -122.424275817175) | 2 | 4 | 5 | 28859 | 19 | |||
25738 | 97483 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989920.47182 | 2114841.78 | 37.7863709666179 | -122.478664195663 | (37.7863709666179, -122.478664195663) | 11 | 6 | 1 | 55 | 33 | ||
26278 | 239005 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 250 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005423.80449 | 2102247.03404 | 37.7526767636284 | -122.424130513718 | (37.7526767636284, -122.424130513718) | 2 | 4 | 5 | 28859 | 19 | |||
27412 | 65777 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1796- 1796 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 3 | Permit Number 28742 | 6004431.04108 | 2118780.7342 | 37.7980181503743 | -122.428742211078 | (37.7980181503743, -122.428742211078) | 13 | 9 | 1 | 57 | 17 | |
29395 | 83672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 76 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52299 | 6012122.94965 | 2095206.11599 | 37.7337198723641 | -122.400469008954 | (37.7337198723641, -122.400469008954) | 10 | 3 | 8 | 58 | 1 | |
29597 | 238598 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006428.46561 | 2107477.24993 | 37.7670943907258 | -122.421027537902 | (37.7670943907258, -122.421027537902) | 8 | 4 | 7 | 28853 | 19 | |||
30391 | 239020 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 482 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004672.88732 | 2110370.92399 | 37.7749405996584 | -122.427305970394 | (37.7749405996584, -122.427305970394) | 7 | 9 | 11 | 28852 | 10 | |||
30515 | 238584 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.70836 | 2103296.31784 | 37.7555567183818 | -122.42427463098 | (37.7555567183818, -122.42427463098) | 2 | 4 | 5 | 28859 | 19 | |||
36420 | 124156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995846.07339 | 2112226.83412 | 37.7795332890719 | -122.457973944713 | (37.7795332890719, -122.457973944713) | 11 | 6 | 2 | 54 | 16 | |||
37380 | 47499 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
38026 | 50359 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1044 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 5 | Permit Number 47031 | 6014195.81741 | 2102278.81797 | 37.753255413506 | -122.3937973317 | (37.753255413506, -122.3937973317) | 10 | 3 | 8 | 28856 | 29 | ||
39652 | 124172 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 81 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995886.79128 | 2112251.90704 | 37.7796044719959 | -122.457834899878 | (37.7796044719959, -122.457834899878) | 11 | 6 | 2 | 54 | 16 | |||
41965 | 47508 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
42382 | 84481 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 59 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50146 | 6012081.07031 | 2095312.02235 | 37.7340083335059 | -122.40062123629 | (37.7340083335059, -122.40062123629) | 10 | 3 | 8 | 58 | 1 | |
43016 | 51309 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 518 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 7 | Permit Number 47675 | 5989718.85945 | 2111803.87155 | 37.7780180115133 | -122.479139410746 | (37.7780180115133, -122.479139410746) | 11 | 6 | 2 | 55 | 26 | ||
43319 | 239004 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1299 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010075.23485 | 2101730.69719 | 37.751520546657 | -122.40800856074 | (37.751520546657, -122.40800856074) | 2 | 4 | 7 | 28859 | 19 | |||
43615 | 114880 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1687 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 3x3 | 6009362.4 | 2099644 | 37.7457510020701 | -122.4103263211 | (37.7457510020701, -122.4103263211) | 2 | 7 | 7 | 28859 | 2 | |||
46845 | 238593 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006434.12493 | 2107338.12771 | 37.7667127130356 | -122.420998084205 | (37.7667127130356, -122.420998084205) | 8 | 4 | 7 | 28853 | 19 | |||
48308 | 136039 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3434 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999787.69729 | 2120389.72868 | 37.8021721279018 | -122.44492518757 | (37.8021721279018, -122.44492518757) | 13 | 9 | 1 | 57 | 17 | |||
51859 | 238588 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006604.02075 | 2107329.38217 | 37.7666982753322 | -122.420409821465 | (37.7666982753322, -122.420409821465) | 8 | 4 | 7 | 28853 | 19 | |||
52161 | 106889 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014125.23342 | 2106217.58962 | 37.7640665046851 | -122.394317180299 | (37.7640665046851, -122.394317180299) | 14 | 3 | 8 | 28856 | 29 | ||
53920 | 33647 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 532 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 6 | Permit Number 47617 | 6004852.49961 | 2110739.683 | 37.7759632781281 | -122.426710918693 | (37.7759632781281, -122.426710918693) | 7 | 9 | 11 | 28852 | 10 | |
55306 | 47505 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
56484 | 122199 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 171 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991475.81854 | 2114309.23252 | 37.7849989216744 | -122.473244290329 | (37.7849989216744, -122.473244290329) | 11 | 6 | 2 | 54 | 26 | |||
56637 | 239007 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009827.40599 | 2104524.43186 | 37.7591776380486 | -122.409062693893 | (37.7591776380486, -122.409062693893) | 2 | 4 | 7 | 28859 | 19 | |||
57891 | 196540 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012078.91363 | 2106521.10785 | 37.7647859371415 | -122.401416175823 | (37.7647859371415, -122.401416175823) | 14 | 3 | 8 | 28856 | 29 | |||
59809 | 45688 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 614 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2001 12:00:00 AM | 6 | Permit Number 44373 | 5988813.86357 | 2111116.63856 | 37.7760784619734 | -122.482219714975 | (37.7760784619734, -122.482219714975) | 11 | 6 | 2 | 55 | 26 | ||
60441 | 46239 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1050 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 5 | Permit Number 44533 | 6014194.98195 | 2102252.43023 | 37.7531829119855 | -122.393798374016 | (37.7531829119855, -122.393798374016) | 10 | 3 | 8 | 28856 | 29 | ||
60987 | 47504 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
62744 | 47503 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
62806 | 52709 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | 8 | Permit Number 48767 | 5996047.33493 | 2115997.05017 | 37.7898968555268 | -122.457550557933 | (37.7898968555268, -122.457550557933) | 11 | 1 | 54 | 31 | |||
64185 | 52711 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | 5 | Permit Number 48767 | 5996055.9612 | 2115990.01738 | 37.7898780408886 | -122.457520202963 | (37.7898780408886, -122.457520202963) | 11 | 1 | 54 | 31 | |||
64342 | 35854 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
65368 | 50856 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 743 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47371 | 5985677.37672 | 2110827.17931 | 37.7751007543065 | -122.493048175392 | (37.7751007543065, -122.493048175392) | 11 | 6 | 2 | 55 | 26 | ||
69930 | 57837 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2009 12:00:00 AM | 3x3 | Permit Number 52005 | 5994540.33028408 | 2106409.85629846 | 37.763486295989 | -122.46206907635 | (37.763486295989, -122.46206907635) | 1 | 5 | 11 | 56 | 12 | ||
75753 | 196539 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012100.68573 | 2106521.94936 | 37.7647894624906 | -122.401340930463 | (37.7647894624906, -122.401340930463) | 14 | 3 | 8 | 28856 | 29 | |||
75784 | 82345 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 254 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774176 | 6003940.30685 | 2088972.31262 | 37.7161435078943 | -122.428314680584 | (37.7161435078943, -122.428314680584) | 9 | 7 | 6 | 28861 | 5 | |
77284 | 44274 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2001 12:00:00 AM | 4 | Permit Number 43700 | 6011255.06578 | 2104741.61874 | 37.7598538580824 | -122.404140420144 | (37.7598538580824, -122.404140420144) | 10 | 3 | 8 | 28856 | 29 | ||
77776 | 196541 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012133.24244 | 2106522.80627 | 37.7647936317506 | -122.401228384779 | (37.7647936317506, -122.401228384779) | 14 | 3 | 8 | 28856 | 29 | |||
79691 | 124155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995858.43793 | 2112228.39454 | 37.7795382839593 | -122.457931283713 | (37.7795382839593, -122.457931283713) | 11 | 6 | 2 | 54 | 16 | |||
80211 | 122200 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 171 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991476.58631 | 2114290.78647 | 37.784948318391 | -122.473240288339 | (37.784948318391, -122.473240288339) | 11 | 6 | 2 | 54 | 26 | |||
80849 | 238589 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006580.76101 | 2107327.1643 | 37.7666908748181 | -122.420490115647 | (37.7666908748181, -122.420490115647) | 8 | 4 | 7 | 28853 | 19 | |||
80871 | 46546 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 637 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2002 12:00:00 AM | Permit Number 44689 | 6009489.66445837 | 2111279.62627541 | 37.7777069157879 | -122.410707830593 | (37.7777069157879, -122.410707830593) | 8 | 2 | 9 | 28853 | 34 | |||
83140 | 41607 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
83158 | 57747 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3425 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1977 12:00:00 AM | 8 | Permit Number 16667 | 5997831.65027 | 2116097.2527 | 37.7902743175622 | -122.45138424801 | (37.7902743175622, -122.45138424801) | 11 | 6 | 1 | 54 | 31 | ||
84425 | 41604 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
84948 | 107672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 184 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773528 | 5997643.33289 | 2112648.90363 | 37.7807952777935 | -122.45178694364 | (37.7807952777935, -122.45178694364) | 15 | 6 | 2 | 54 | 16 | |
93507 | 114199 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012227.07645 | 2106528.11077 | 37.7648134312296 | -122.400904207967 | (37.7648134312296, -122.400904207967) | 14 | 3 | 8 | 28856 | 29 | |||
94425 | 115309 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 500x Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6004961.03279 | 2110755.75124 | 37.776013533141 | -122.426336618167 | (37.776013533141, -122.426336618167) | 7 | 9 | 11 | 28852 | 10 | |||
94982 | 239017 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 420 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004649.23928 | 2110026.77374 | 37.7739943096302 | -122.427363252712 | (37.7739943096302, -122.427363252712) | 7 | 9 | 11 | 28852 | 10 | |||
96537 | 239010 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010651.97236 | 2100432.84922 | 37.747989214748 | -122.405922704693 | (37.747989214748, -122.405922704693) | 2 | 7 | 7 | 28859 | 2 | |||
97109 | 239025 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 323 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006919.22148 | 2096314.31292 | 37.7364711647048 | -122.41853842942 | (37.7364711647048, -122.41853842942) | 2 | 7 | 7 | 28859 | 2 | |||
97447 | 84400 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 611-613 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51577 | 5993447.66428 | 2111301.75717 | 37.7768551863663 | -122.466203752377 | (37.7768551863663, -122.466203752377) | 11 | 6 | 2 | 54 | 11 | |
99570 | 114197 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6012196.35096 | 2106527.32725 | 37.7648095659429 | -122.4010104251 | (37.7648095659429, -122.4010104251) | 14 | 3 | 8 | 28856 | 29 | |||
100212 | 238582 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3456 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006754.5466 | 2100607.36077 | 37.7482496404132 | -122.41941224938 | (37.7482496404132, -122.41941224938) | 2 | 4 | 7 | 28859 | 19 | |||
100238 | 57625 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014196.28428 | 2106222.11039 | 37.7640828669594 | -122.394071750814 | (37.7640828669594, -122.394071750814) | 14 | 3 | 8 | 28856 | 29 | ||
101900 | 47502 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
102967 | 39863 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 55 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 14 | Permit Number 41168 | 5997961.8347 | 2116210.86321 | 37.7905937153799 | -122.450942017156 | (37.7905937153799, -122.450942017156) | 11 | 6 | 1 | 54 | 31 | |
104300 | 196537 | Planning Code 138.1 required 2 | Prunus x yedoensis :: Yoshino Cherry 77 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782869 | 6010635.96485 | 2105787.36101 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | 8 | 4 | 8 | 28859 | 19 | |
104730 | 47500 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
106048 | 61899 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 335 Maple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1985 12:00:00 AM | 5 | Permit Number 21942 | 5996649.71832 | 2115128.18725 | 37.7875457744774 | -122.455403556547 | (37.7875457744774, -122.455403556547) | 11 | 6 | 1 | 54 | 31 | ||
106942 | 62466 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 708 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2012 12:00:00 AM | 2 | Permit Number 769096 | 6011238.859 | 2104985.8972 | 37.7605236866263 | -122.40421366454 | (37.7605236866263, -122.40421366454) | 10 | 3 | 8 | 28856 | 29 | |
107927 | 239012 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 417 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009194 | 2100253 | 37.7474137401608 | -122.410951632147 | (37.7474137401608, -122.410951632147) | 2 | 7 | 7 | 28859 | 2 | |||
113302 | 238592 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006502.41381 | 2107324.73135 | 37.7666797789728 | -122.420760932989 | (37.7666797789728, -122.420760932989) | 8 | 4 | 7 | 28853 | 19 | |||
113704 | 239024 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 389 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004038.85397 | 2100110.5602 | 37.7467322107326 | -122.428767625048 | (37.7467322107326, -122.428767625048) | 2 | 7 | 5 | 63 | 22 | |||
114222 | 52710 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | 7 | Permit Number 48767 | 5996063.73844 | 2115999.96188 | 37.7899057925288 | -122.457494014373 | (37.7899057925288, -122.457494014373) | 11 | 1 | 54 | 31 | |||
115364 | 105908 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1237 NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772682 | 5990134.3 | 2103036.1 | 37.7539682014274 | -122.477061416534 | (37.7539682014274, -122.477061416534) | 1 | 8 | 3 | 56 | 35 | |
116083 | 239015 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 380 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004736.9455 | 2110029.27372 | 37.7740061339081 | -122.427060040012 | (37.7740061339081, -122.427060040012) | 7 | 9 | 11 | 28852 | 10 | |||
119039 | 67591 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 210 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 4 | Permit Number 31158 | 6013702.18081 | 2106068.08806 | 37.763632481088 | -122.395769929855 | (37.763632481088, -122.395769929855) | 14 | 3 | 8 | 28856 | 29 | |
119873 | 239006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009817.72923 | 2104524.2582 | 37.7591766191261 | -122.409096148662 | (37.7591766191261, -122.409096148662) | 2 | 4 | 7 | 28859 | 19 | |||
120741 | 31876 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 457 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984053.55944 | 2112762.76101 | 37.7803202011246 | -122.498808255642 | (37.7803202011246, -122.498808255642) | 11 | 6 | 2 | 55 | 26 | ||
121753 | 136038 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001472.99161 | 2118372.51035 | 37.7967294155856 | -122.438948622379 | (37.7967294155856, -122.438948622379) | 13 | 9 | 1 | 57 | 17 | |||
121757 | 238594 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006432.46991 | 2107376.01737 | 37.7668166557888 | -122.421006499155 | (37.7668166557888, -122.421006499155) | 8 | 4 | 7 | 28853 | 19 | |||
122239 | 97484 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989917.9579 | 2114856.79796 | 37.7864120557494 | -122.4786739918 | (37.7864120557494, -122.4786739918) | 11 | 6 | 1 | 55 | 33 | ||
122436 | 239021 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 530 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004598.87911 | 2110377.72269 | 37.7749550814495 | -122.427562465139 | (37.7749550814495, -122.427562465139) | 7 | 9 | 11 | 28852 | 10 | |||
124046 | 44512 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 10 | 4x4 | Permit Number 43806 | 6004687.03371464 | 2097226.29740092 | 37.7388493482812 | -122.426320962915 | (37.7388493482812, -122.426320962915) | 2 | 7 | 5 | 63 | 7 |
125981 | 47506 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
126493 | 84727 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | 5 | Permit No. 49296 | 5996090.69151 | 2115989.11998 | 37.7898775717477 | -122.457399975051 | (37.7898775717477, -122.457399975051) | 11 | 1 | 54 | 31 | |||
127095 | 32222 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 623 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 15 | Permit Number 35543 | 6009718.6984 | 2100387.54672 | 37.7478125842885 | -122.40914674543 | (37.7478125842885, -122.40914674543) | 2 | 7 | 7 | 28859 | 2 | |
128052 | 238581 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 18 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006358.36528 | 2099816.491 | 37.7460557694506 | -122.420726098652 | (37.7460557694506, -122.420726098652) | 2 | 7 | 5 | 28859 | 2 | |||
128463 | 109327 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2015 12:00:00 AM | 3 | Permit Number 774911 | 6003963.48635 | 2119408.041 | 37.7997140999836 | -122.430404865987 | (37.7997140999836, -122.430404865987) | 13 | 9 | 1 | 57 | 17 |
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) );