trees
268 rows where qSpecies_id = 77 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 63461 | 213724 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 8 | Median : Yard | Tree | DPW 1 | 8 | 5993565.41473 | 2097500.59466 | 37.7389675657933 | -122.46479394281 | (37.7389675657933, -122.46479394281) | 1 | 8 | 4 | 59 | 40 | ||||
| 174567 | 202188 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1900 Armstrong Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013190.44315 | 2093406.40364 | 37.728837705679 | -122.39665222323 | (37.728837705679, -122.39665222323) | 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 | |||
| 79306 | 136048 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5996075.48126 | 2116002.11474 | 37.7899123782026 | -122.457453541344 | (37.7899123782026, -122.457453541344) | 11 | 1 | 54 | 31 | |||||
| 119804 | 136040 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 55 Laurel St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5997963.88145 | 2116192.9912 | 37.7905447607719 | -122.450933646298 | (37.7905447607719, -122.450933646298) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 147580 | 136044 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5997978.05362 | 2116388.40928 | 37.7910821380693 | -122.450898708531 | (37.7910821380693, -122.450898708531) | 13 | 6 | 1 | 54 | 31 | |||
| 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 | ||||
| 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 | |||||
| 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 | ||
| 76440 | 136047 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5996079.9197 | 2115992.25742 | 37.7898855676012 | -122.457437471381 | (37.7898855676012, -122.457437471381) | 11 | 1 | 54 | 31 | |||||
| 90085 | 136045 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5997979.66837 | 2116375.74786 | 37.7910474656235 | -122.45089220822 | (37.7910474656235, -122.45089220822) | 13 | 6 | 1 | 54 | 31 | |||
| 128274 | 213723 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 6 | Median : Yard | Tree | DPW 1 | 3 | 5993589.39355 | 2097453.93432 | 37.7388408306314 | -122.46470764836 | (37.7388408306314, -122.46470764836) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | ||||
| 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 | |||
| 160166 | 202259 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013218.01399 | 2093376.88816 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 51211 | 122964 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 5993049.94359 | 2114912.63546 | 37.7867467201865 | -122.467842267803 | (37.7867467201865, -122.467842267803) | 11 | 6 | 1 | 54 | 11 | |||
| 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 | ||
| 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 | ||||
| 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 | |
| 136645 | 94793 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 5 | Permit Number 53892 | 5997982.2072 | 2116362.36591 | 37.7910108676939 | -122.450882458672 | (37.7910108676939, -122.450882458672) | 13 | 6 | 1 | 54 | 31 | ||
| 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 | |||||
| 142227 | 213722 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 5 | Median : Yard | Tree | DPW 1 | 4 | 5993592.57964 | 2097450.02121 | 37.7388302698944 | -122.464696348358 | (37.7388302698944, -122.464696348358) | 1 | 8 | 4 | 59 | 40 | ||||
| 150831 | 136046 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5996087.67176 | 2116001.00322 | 37.78991002647 | -122.45741128312 | (37.78991002647, -122.45741128312) | 11 | 1 | 54 | 31 | |||||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 45234 | 202184 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1900 Armstrong Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013198.98425 | 2093399.22832 | 37.7288184790723 | -122.396622193069 | (37.7288184790723, -122.396622193069) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 152580 | 250149 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 5999215.63832 | 2117439.7417 | 37.794039588317 | -122.446692402146 | (37.794039588317, -122.446692402146) | 11 | 1 | 57 | 30 | |||||
| 181133 | 52707 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2006 12:00:00 AM | 7 | Permit Number 48767 | 5996046.88013 | 2115983.52672 | 37.7898596976604 | -122.457551152633 | (37.7898596976604, -122.457551152633) | 11 | 1 | 54 | 31 | |||
| 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 | |||
| 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 | |
| 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 | ||||
| 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 | |||
| 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 | |||
| 63795 | 124683 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3899 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5995553.12452 | 2115771.60073 | 37.7892494317403 | -122.459244137371 | (37.7892494317403, -122.459244137371) | 11 | 6 | 1 | 54 | 31 | |||
| 83042 | 123363 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994763.50549 | 2110414.96281 | 37.7744961151162 | -122.461587583233 | (37.7744961151162, -122.461587583233) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 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 | |||||
| 88338 | 213729 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 150 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993589.16073 | 2101660.48807 | 37.7503909504883 | -122.465013883688 | (37.7503909504883, -122.465013883688) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 147761 | 35082 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43889 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 158164 | 120284 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 139 24th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5988322.78334 | 2115034.52421 | 37.7868072939982 | -122.484205864007 | (37.7868072939982, -122.484205864007) | 11 | 6 | 1 | 55 | 33 | ||||
| 158227 | 136042 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3399 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998049.07867 | 2116118.00061 | 37.7903437335326 | -122.450633461567 | (37.7903437335326, -122.450633461567) | 13 | 6 | 1 | 54 | 31 | |||
| 162524 | 239008 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009837.36864 | 2104524.2797 | 37.7591777783485 | -122.409028227385 | (37.7591777783485, -122.409028227385) | 2 | 4 | 7 | 28859 | 19 | |||
| 166572 | 213719 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993051.46655 | 2103255.88389 | 37.754740477507 | -122.466989225694 | (37.754740477507, -122.466989225694) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | ||
| 184976 | 213732 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 475 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994831.427 | 2100060.8711 | 37.746070357361 | -122.460602166776 | (37.746070357361, -122.460602166776) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |
| 4262 | 213721 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 66x Santa Monica Way | 2 | Median : Yard | Tree | DPW 1 | 1 | 5993647.57824 | 2097426.08398 | 37.7387677148629 | -122.464504452814 | (37.7387677148629, -122.464504452814) | 1 | 8 | 4 | 59 | 40 | ||||
| 15965 | 136043 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3425 Jackson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997844.87788 | 2116098.17267 | 37.7902776009696 | -122.451338548042 | (37.7902776009696, -122.451338548042) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 59098 | 98408 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 24 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | 11 | 6 | 1 | 55 | 33 | ||
| 60025 | 124684 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3899 Jackson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5995566.4285 | 2115772.64492 | 37.7892530636592 | -122.459198183151 | (37.7892530636592, -122.459198183151) | 11 | 6 | 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 | |||
| 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 | ||||
| 70516 | 123029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991968.39214 | 2110452.13533 | 37.7744368966539 | -122.471259036935 | (37.7744368966539, -122.471259036935) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 102636 | 124378 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 37 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5996168.03045 | 2114275.5227 | 37.7851769356666 | -122.457008391438 | (37.7851769356666, -122.457008391438) | 11 | 6 | 1 | 54 | 31 | |||
| 103313 | 122967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993050.69162 | 2114890.11462 | 37.7866849273422 | -122.467838041215 | (37.7866849273422, -122.467838041215) | 11 | 6 | 1 | 54 | 11 | |||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | |||
| 135030 | 84901 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3710 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2007 12:00:00 AM | 5 | Permit No. 49300 | 5996951.85595 | 2115692.33884 | 37.7891121155896 | -122.454398994017 | (37.7891121155896, -122.454398994017) | 11 | 6 | 1 | 54 | 31 | ||
| 135365 | 124512 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2656 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996425.61433 | 2110792.8133 | 37.7756291250409 | -122.455865383128 | (37.7756291250409, -122.455865383128) | 11 | 6 | 2 | 54 | 16 |
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) );