trees
268 rows where qSpecies_id = 77 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 163299 | 136049 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2258 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999403.25073 | 2120854.72135 | 37.8034269240649 | -122.446289022013 | (37.8034269240649, -122.446289022013) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||||
| 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 | |||
| 182334 | 41184 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3414 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 4 | Permit Number 41902 | 5999801.39213 | 2120297.1759 | 37.8019187843817 | -122.4448711401 | (37.8019187843817, -122.4448711401) | 13 | 9 | 1 | 57 | 17 | |
| 143442 | 141371 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001203.2035 | 2110227.5052 | 37.7743499704497 | -122.439298037861 | (37.7743499704497, -122.439298037861) | 15 | 5 | 11 | 29492 | 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 | |||
| 131277 | 179170 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 179 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001259.83204 | 2087347.33172 | 37.7115296332658 | -122.437463366848 | (37.7115296332658, -122.437463366848) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 158219 | 136036 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2901 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001479.25997 | 2118476.71669 | 37.7970158955175 | -122.438934404121 | (37.7970158955175, -122.438934404121) | 13 | 9 | 1 | 57 | 17 | |||
| 169416 | 51703 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 3 | Permit Number 47979 | 6001520.69358 | 2121621.59135 | 37.805653247063 | -122.439016533799 | (37.805653247063, -122.439016533799) | 13 | 9 | 1 | 57 | 17 | ||
| 174724 | 136037 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2810 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001581.50265 | 2118066.63071 | 37.7958957233673 | -122.438551222785 | (37.7958957233673, -122.438551222785) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||
| 130605 | 35852 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 2 | 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 | ||
| 169272 | 35855 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 5 | 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 | ||
| 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 | |||
| 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 | |||
| 33456 | 239029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003326.30087 | 2097748.91757 | 37.7402073325128 | -122.431063031234 | (37.7402073325128, -122.431063031234) | 2 | 7 | 5 | 63 | 7 | |||
| 67181 | 239028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003397.86036 | 2097787.1303 | 37.7403163105472 | -122.430818333806 | (37.7403163105472, -122.430818333806) | 2 | 7 | 5 | 63 | 7 | ||||
| 35888 | 239027 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6003403.2403 | 2097795.09814 | 37.740338493218 | -122.430800300593 | (37.740338493218, -122.430800300593) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | |
| 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 | ||
| 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 | |||
| 190946 | 238580 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 519 Hickory St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |
| 135006 | 136050 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 584 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004583.8437 | 2110676.25728 | 37.7757739339551 | -122.427635749998 | (37.7757739339551, -122.427635749998) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 146323 | 238579 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 415 Buchanan St | 1 | : | Tree | Private 2 | 7 | Width 6ft | 6004609.7624 | 2109940.50049 | 37.7737551915801 | -122.427493662508 | (37.7737551915801, -122.427493662508) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 183526 | 239018 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 420 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004647.99887 | 2110037.75326 | 37.7740243865621 | -122.427368325805 | (37.7740243865621, -122.427368325805) | 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 | |||
| 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 | |||
| 147344 | 239016 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 399 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004681.24572 | 2110023.15394 | 37.773986180653 | -122.427252279074 | (37.773986180653, -122.427252279074) | 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 |
| 32892 | 238578 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 149 Buchanan St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6004732.39628 | 2109051.52361 | 37.7713212124262 | -122.427006123859 | (37.7713212124262, -122.427006123859) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 22899 | 238577 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 133 Buchanan St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6004747.18096 | 2108954.98025 | 37.771056963743 | -122.426948105892 | (37.771056963743, -122.426948105892) | 7 | 9 | 11 | 28852 | 10 | |||
| 92612 | 238575 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 1 | : | Tree | Private 2 | 05/02/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 45000 | 6004751.79623 | 2108930.40583 | 37.7709897493005 | -122.426930391028 | (37.7709897493005, -122.426930391028) | 7 | 9 | 11 | 28852 | 10 | |
| 192405 | 238576 | Private 9 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 782890 | 6004764 | 2108902 | 37.7709124438039 | -122.42688615445 | (37.7709124438039, -122.42688615445) | 7 | 9 | 11 | 28852 | 10 | |
| 170138 | 239019 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 539 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004833.64681 | 2110391.58665 | 37.7750064246485 | -122.426751340518 | (37.7750064246485, -122.426751340518) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 132173 | 85064 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 57 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49430 | 6005948 | 2102270 | 37.7527694058254 | -122.422319381816 | (37.7527694058254, -122.422319381816) | 2 | 4 | 5 | 28859 | 19 | |||
| 139200 | 44049 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 3 | 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 | |||
| 143199 | 44048 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 2 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 162237 | 238597 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006428.61387 | 2107454.83624 | 37.7670328563946 | -122.421025433495 | (37.7670328563946, -122.421025433495) | 8 | 4 | 7 | 28853 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 129057 | 238591 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006521.80542 | 2107326.31519 | 37.7666852207654 | -122.420693973056 | (37.7666852207654, -122.420693973056) | 8 | 4 | 7 | 28853 | 19 | |||
| 129753 | 238587 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 88 Hoff St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006547.66375 | 2106304.16095 | 37.763880083309 | -122.420531969171 | (37.763880083309, -122.420531969171) | 8 | 4 | 7 | 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );