trees
268 rows where qSpecies_id = 77 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165888 | 238583 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3726 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005678.26698 | 2100537.88452 | 37.7479981962719 | -122.423129060168 | (37.7479981962719, -122.423129060168) | 2 | 4 | 5 | 28859 | 19 | |||
168356 | 238590 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006558.68339 | 2107326.24442 | 37.7666871048439 | -122.420566413202 | (37.7666871048439, -122.420566413202) | 8 | 4 | 7 | 28853 | 19 | |||
173613 | 238599 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007470.12204 | 2105516.97902 | 37.7617706074473 | -122.417285669309 | (37.7617706074473, -122.417285669309) | 2 | 4 | 7 | 28859 | 19 | |||
174055 | 4162 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3754 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2011 12:00:00 AM | 3 | 3X3 | 6005539.04385 | 2100528.63943 | 37.7479649537167 | -122.423609831438 | (37.7479649537167, -122.423609831438) | 2 | 4 | 5 | 28859 | 19 | ||
180974 | 239003 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2392 Bryant St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6009661.58461 | 2103420.7224 | 37.7561378099155 | -122.409558287803 | (37.7561378099155, -122.409558287803) | 2 | 4 | 7 | 28859 | 19 | |||
183729 | 239026 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1340 Treat Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008687.9198 | 2100899.65847 | 37.7491609288407 | -122.412747338613 | (37.7491609288407, -122.412747338613) | 2 | 4 | 7 | 28859 | 19 | |||
188738 | 238595 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006430.43554 | 2107395.44142 | 37.7668698749586 | -122.421014915008 | (37.7668698749586, -122.421014915008) | 8 | 4 | 7 | 28853 | 19 | |||
188992 | 44050 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
189062 | 238596 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006429.49363 | 2107423.62513 | 37.7669472076635 | -122.421020174242 | (37.7669472076635, -122.421020174242) | 8 | 4 | 7 | 28853 | 19 | |||
189744 | 10006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 165 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1991 12:00:00 AM | 6 | 3X2 | 6005478.90232 | 2108028.91066 | 37.7685555462362 | -122.42435117769 | (37.7685555462362, -122.42435117769) | 8 | 4 | 5 | 28853 | 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 | |||
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 | |||
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 | |||
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 | |
127131 | 239002 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Mirabel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007267.34733 | 2099764.86466 | 37.7459652050335 | -122.417579291677 | (37.7459652050335, -122.417579291677) | 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 | |||
138650 | 239009 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010637.01006 | 2100427.5195 | 37.7479737436878 | -122.405974068569 | (37.7479737436878, -122.405974068569) | 2 | 7 | 7 | 28859 | 2 | |||
140665 | 246630 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3320 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6009028.43524 | 2099278.75412 | 37.7447293908617 | -122.411455327621 | (37.7447293908617, -122.411455327621) | 2 | 7 | 7 | 28859 | 2 | ||||
187043 | 239011 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010666.51854 | 2100440.55381 | 37.7480111833878 | -122.405872946996 | (37.7480111833878, -122.405872946996) | 2 | 7 | 7 | 28859 | 2 | |||
61657 | 246464 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 212 Duncan St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005064.93111 | 2099921.35386 | 37.7462707137301 | -122.425206088515 | (37.7462707137301, -122.425206088515) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
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 | |||
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 | |||
174611 | 239023 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 4093 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003318.18687 | 2100656.24769 | 37.7481897266866 | -122.431298564594 | (37.7481897266866, -122.431298564594) | 2 | 4 | 5 | 63 | 22 | |||
183984 | 239022 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 927 Church St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6004402.67666 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | 2 | 4 | 5 | 28862 | 22 | |||
192435 | 5697 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1551 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2007 12:00:00 AM | 3 | 6X6 | 6005311.69042 | 2099268.6032 | 37.7444923466503 | -122.424306405838 | (37.7444923466503, -122.424306405838) | 2 | 7 | 5 | 28859 | 22 | ||
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 | |
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
116368 | 118026 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Shore View Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5984344.44515 | 2112788.18454 | 37.780407063583 | -122.49780384034 | (37.780407063583, -122.49780384034) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
120911 | 118028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Shore View Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984316.15967 | 2112798.24876 | 37.780433038793 | -122.49790243493 | (37.780433038793, -122.49790243493) | 11 | 6 | 2 | 55 | 26 | |||
164743 | 119967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 536 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987220.23089 | 2112258.31491 | 37.7791203589842 | -122.487816341376 | (37.7791203589842, -122.487816341376) | 11 | 6 | 2 | 55 | 26 | |||
183821 | 63200 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 450 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2015 12:00:00 AM | 3 | Permit Number 775741 | 5984716.80521 | 2112828.61382 | 37.7805398924486 | -122.496518676344 | (37.7805398924486, -122.496518676344) | 11 | 6 | 2 | 55 | 26 | |
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 | ||
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 | ||
22945 | 250158 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 5999254.28786 | 2117464.37854 | 37.7941094422474 | -122.446560444632 | (37.7941094422474, -122.446560444632) | 13 | 9 | 1 | 57 | 27 | ||||
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 | |||
33567 | 249637 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 3 | Side Yard : Yard | Tree | Private 2 | 7 | 5999297.09837 | 2117106.84322 | 37.7931301902456 | -122.4463865832 | (37.7931301902456, -122.4463865832) | 13 | 9 | 1 | 57 | 27 | ||||
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 | ||
38537 | 249640 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 5999291.59314 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | 13 | 9 | 1 | 57 | 27 | ||||
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 | ||
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 | ||
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 | ||
67698 | 249638 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 5 | Side Yard : Yard | Tree | Private 2 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | 13 | 9 | 1 | 57 | 27 | ||||
84577 | 250155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 5999259.65981 | 2117410.03204 | 37.7939605280209 | -122.446537945371 | (37.7939605280209, -122.446537945371) | 13 | 9 | 1 | 57 | 27 | ||||
90248 | 249642 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2460 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 5999289.16084 | 2117209.34278 | 37.7934111735351 | -122.446421424722 | (37.7934111735351, -122.446421424722) | 13 | 9 | 1 | 57 | 27 | ||||
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 | ||
103407 | 250156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | 5999256.55789 | 2117425.58205 | 37.7940030470443 | -122.446549797562 | (37.7940030470443, -122.446549797562) | 13 | 9 | 1 | 57 | 27 | ||||
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 | ||
123301 | 249636 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 5999299.54264 | 2117085.08931 | 37.7930705993714 | -122.446376560233 | (37.7930705993714, -122.446376560233) | 13 | 9 | 1 | 57 | 27 | ||||
124228 | 250157 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 5999256.81946 | 2117443.67812 | 37.7940527489909 | -122.446550195053 | (37.7940527489909, -122.446550195053) | 13 | 9 | 1 | 57 | 27 | ||||
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 | ||
134097 | 47496 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 7 | 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 | ||
146504 | 250159 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 5999252.38937 | 2117479.90418 | 37.7941519630933 | -122.446568131123 | (37.7941519630933, -122.446568131123) | 13 | 9 | 1 | 57 | 27 | ||||
158964 | 249680 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Baker St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 5999746.74355 | 2117232.18734 | 37.7935000229554 | -122.444839803216 | (37.7935000229554, -122.444839803216) | 13 | 9 | 1 | 57 | 27 | ||||
169847 | 47509 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 9 | 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 | ||
172511 | 47507 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 2 | 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 | ||
184216 | 250154 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 5999263.26744 | 2117392.55411 | 37.7939127443244 | -122.446524204627 | (37.7939127443244, -122.446524204627) | 13 | 9 | 1 | 57 | 27 | ||||
184368 | 249641 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2460 Lyon St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 5999290.35855 | 2117187.34 | 37.7933508281386 | -122.446415696946 | (37.7933508281386, -122.446415696946) | 13 | 9 | 1 | 57 | 27 | ||||
191629 | 47501 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 10 | 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 | ||
154619 | 114678 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 726 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774712 | 6011027.75702 | 2091361.80007 | 37.7231030455441 | -122.40398499124 | (37.7231030455441, -122.40398499124) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
51956 | 196545 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 938 Rhode Island St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6011854.06587 | 2104027.62304 | 37.7579268348784 | -122.402018565106 | (37.7579268348784, -122.402018565106) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
56628 | 196546 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1017 Rhode Island St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6011946.26987 | 2103466.67493 | 37.7563917406915 | -122.401660256322 | (37.7563917406915, -122.401660256322) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | ||
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 | |||
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 | |||
84016 | 196547 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Wisconsin St | 1 | : | Tree | Private 2 | 10 | Width 6ft | 6012751.32394 | 2103003.67516 | 37.7551653352247 | -122.398843585967 | (37.7551653352247, -122.398843585967) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | |||
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 | ||
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 | |
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 | |
121261 | 196544 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1200x Kansas St | 1 | Median : Cutout | Tree | DPW 1 | 05/15/2018 12:10:00 PM | 4 | Width 5ft | 6011674.97402 | 2102731.27183 | 37.7543573429212 | -122.402546786412 | (37.7543573429212, -122.402546786412) | 10 | 3 | 8 | 28856 | 29 | ||
140257 | 114200 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6012241.34164 | 2106528.09119 | 37.7648141731694 | -122.400854866677 | (37.7648141731694, -122.400854866677) | 14 | 3 | 8 | 28856 | 29 | |||
155378 | 114198 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012211.95597 | 2106527.54933 | 37.7648110462088 | -122.400956466675 | (37.7648110462088, -122.400956466675) | 14 | 3 | 8 | 28856 | 29 | |||
160650 | 196542 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012149.92661 | 2106523.64769 | 37.7647968728895 | -122.401170737335 | (37.7647968728895, -122.401170737335) | 14 | 3 | 8 | 28856 | 29 | |||
171028 | 106887 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014179.56003 | 2106221.50204 | 37.7640802670231 | -122.394129552957 | (37.7640802670231, -122.394129552957) | 14 | 3 | 8 | 28856 | 29 | ||
176792 | 196538 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012116.4996 | 2106522.07184 | 37.764790681081 | -122.401286242662 | (37.764790681081, -122.401286242662) | 14 | 3 | 8 | 28856 | 29 | |||
180977 | 106888 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014142.8658 | 2106218.65545 | 37.7640704113316 | -122.394256269225 | (37.7640704113316, -122.394256269225) | 14 | 3 | 8 | 28856 | 29 | ||
16844 | 249665 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 17 | Front Yard : Yard | Tree | Private 2 | 9 | 5999244.57563 | 2117118.96584 | 37.7931604758161 | -122.44656918694 | (37.7931604758161, -122.44656918694) | 11 | 1 | 57 | 30 | |||||
26148 | 250147 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5999210.3991 | 2117472.66602 | 37.7941296904761 | -122.446712900392 | (37.7941296904761, -122.446712900392) | 11 | 1 | 57 | 30 | |||||
57531 | 250151 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 5999220.87756 | 2117406.81737 | 37.7939494861264 | -122.446671903881 | (37.7939494861264, -122.446671903881) | 11 | 1 | 57 | 30 | |||||
67120 | 249663 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 15 | Front Yard : Yard | Tree | Private 2 | 9 | 5999240.36151 | 2117161.61527 | 37.7932773391397 | -122.446586837907 | (37.7932773391397, -122.446586837907) | 11 | 1 | 57 | 30 | |||||
88103 | 250148 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 5999211.58041 | 2117458.26171 | 37.7940902075462 | -122.446707776048 | (37.7940902075462, -122.446707776048) | 11 | 1 | 57 | 30 | |||||
116012 | 249662 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 14 | Front Yard : Yard | Tree | Private 2 | 12 | 5999235.55005 | 2117182.17249 | 37.7933335089853 | -122.446604965544 | (37.7933335089853, -122.446604965544) | 11 | 1 | 57 | 30 | |||||
130390 | 249661 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 5999232.65842 | 2117208.86838 | 37.7934066436505 | -122.446616892353 | (37.7934066436505, -122.446616892353) | 11 | 1 | 57 | 30 | |||||
133564 | 249667 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 19 | Front Yard : Yard | Tree | Private 2 | 12 | 5999247.61227 | 2117079.36111 | 37.7930519051704 | -122.446555829313 | (37.7930519051704, -122.446555829313) | 11 | 1 | 57 | 30 | |||||
137971 | 250150 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 5999218.59352 | 2117421.61343 | 37.7939899817095 | -122.446680871938 | (37.7939899817095, -122.446680871938) | 11 | 1 | 57 | 30 |
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) );