135 rows where qSpecies_id = 201 sorted by Supervisor Districts

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts ▼ Zip Codes Neighborhoods (old)
37670 106946 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2710 BAKER ST   Sidewalk: Curb side : Cutout Tree Private 2   07/02/2014 12:00:00 AM 1 3x3   5999632.3 2118174.9 37.7960819303033 -122.44530359746 (37.7960819303033, -122.44530359746) 13 9 1 57 17
51435 26712 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 340 Lake St 3 Sidewalk: Curb side : Cutout Tree DPW 1     16 2x2   5994414.30523 2114928.25799 37.7868683042504 -122.463123069231 (37.7868683042504, -122.463123069231) 11 6 1 54 11
56267 26711 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 340 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 2x2   5994414.30523 2114928.25799 37.7868683042504 -122.463123069231 (37.7868683042504, -122.463123069231) 11 6 1 54 11
58602 85259 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2239 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49558 6007574 2120083 37.8017712241665 -122.417959005089 (37.8017712241665, -122.417959005089) 5 1 1 28858 32
82303 57313 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1504 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM   3x3 Permit Number 16136 5999704.4841929 2114025.1830868 37.784692017358 -122.444755399201 (37.784692017358, -122.444755399201) 15 6 1 29490 31
108197 53283 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2606 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2007 12:00:00 AM     Permit Number 49537 6005355.41207376 2118914.02943872 37.7984364178674 -122.42555310995 (37.7984364178674, -122.42555310995) 13 9 1 57 17
114486 84965 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2503 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52401 6001033 2118263 37.7964036854154 -122.440463231838 (37.7964036854154, -122.440463231838) 13 9 1 57 17
119425 26714 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 340 Lake St 5 Sidewalk: Curb side : Cutout Tree DPW 1     8 2X2   5994414.30523 2114928.25799 37.7868683042504 -122.463123069231 (37.7868683042504, -122.463123069231) 11 6 1 54 11
168126 102450 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2205 Pacific Ave 3 Sidewalk: Property side : Cutout Tree Private 2   02/28/2014 12:00:00 AM     Permit Number 772662 6003508.7 2117188.3 37.7935934914571 -122.431820013768 (37.7935934914571, -122.431820013768) 13 9 1 29490 27
44201 58123 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 800 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/1978 12:00:00 AM     Permit Number 17105 6008509.24459419 2120396.75874665 37.802685318336 -122.414744832906 (37.802685318336, -122.414744832906) 5 1 10 308 32
155511 114474 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1254 MONTGOMERY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011527 2119680 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897) 3 1 10 308 23
180945 113407 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1959X POLK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6006418 2117595 37.7948746770036 -122.421782481899 (37.7948746770036, -122.421782481899) 13 9 10 28858 32
188310 112373 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 15 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009208 2121303 37.8052128657777 -122.412390870606 (37.8052128657777, -122.412390870606) 3 1 10 308 23
11297 12432 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1755 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
21486 114737 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 455x LILY ST 1 Sidewalk: Curb side : Pot Tree DPW for City Agency 14 DPW         6004484 2109981 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119) 7 9 11 28852 10
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 12
28174 12897 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 255X Larch St 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6006360.81512 2112999.88713 37.7822544100736 -122.421653822027 (37.7822544100736, -122.421653822027) 7 9 11 28852 41
28792 12433 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1755 Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
29785 88720 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 301 WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2008 12:00:00 AM   3x3 Permit Number 774804 6004157.3 2109772.9 37.773269399945 -122.429046849446 (37.773269399945, -122.429046849446) 7 9 11 29492 10
30168 12899 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 255X Larch St 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6006360.81512 2112999.88713 37.7822544100736 -122.421653822027 (37.7822544100736, -122.421653822027) 7 9 11 28852 41
32406 113978 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1180 STANYAN ST 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
32491 113027 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 277 EDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996519 2105526 37.7611731745556 -122.455161655777 (37.7611731745556, -122.455161655777) 15 5 11 29492 12
39505 12439 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1595X Laguna St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
44098 2649 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1945 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004183.14856 2114926.81574 37.7874222375245 -122.429325027076 (37.7874222375245, -122.429325027076) 13 9 11 29490 27
45808 113977 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1180 STANYAN ST 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
46728 2641 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1765X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004408.21795 2114879.70403 37.7873056200256 -122.428542973686 (37.7873056200256, -122.428542973686) 13 9 11 29490 27
48075 12885 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 200X Larch St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6006589.39642 2113072.01589 37.7824653447827 -122.420868153744 (37.7824653447827, -122.420868153744) 7 9 11 28852 41
48557 113021 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 135 EDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996560 2106197 37.7630179216572 -122.455068343257 (37.7630179216572, -122.455068343257) 15 5 11 29492 12
53502 101169 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1301X 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 33324 5994554 2106650 37.7641464551633 -122.462039213312 (37.7641464551633, -122.462039213312) 1 5 11 56 12
66425 12435 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1595X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
72888 122606 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 27 Belmont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5996763 2106090 37.7627357707848 -122.454358510098 (37.7627357707848, -122.454358510098) 15 5 11 29492 12
75110 2642 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1765X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4x4   6004408.21795 2114879.70403 37.7873056200256 -122.428542973686 (37.7873056200256, -122.428542973686) 13 9 11 29490 27
87715 2648 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1945 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004183.14856 2114926.81574 37.7874222375245 -122.429325027076 (37.7874222375245, -122.429325027076) 13 9 11 29490 27
91987 58133 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 311 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2016 12:00:00 AM 3   Permit Number 17115 6000220.45021465 2109949.44722515 37.7735305196789 -122.442677584536 (37.7735305196789, -122.442677584536) 15 5 11 29492 16
93852 110586 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 151 EDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x10   5996558 2106132 37.7628393335165 -122.45507056335 (37.7628393335165, -122.45507056335) 15 5 11 29492 12
101621 12901 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 255X Larch St 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6006360.81512 2112999.88713 37.7822544100736 -122.421653822027 (37.7822544100736, -122.421653822027) 7 9 11 28852 41
103348 12437 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1595X Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
107765 113980 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1180 STANYAN ST 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
108252 12436 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1595X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
108521 110587 Private 9 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 151 EDGEWOOD AVE 1 Front Yard : Yard Tree Private 2           5996558 2106132 37.7628393335165 -122.45507056335 (37.7628393335165, -122.45507056335) 15 5 11 29492 12
126330 113022 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 135 EDGEWOOD AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996560 2106197 37.7630179216572 -122.455068343257 (37.7630179216572, -122.455068343257) 15 5 11 29492 12
134662 12898 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 255X Larch St 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6006360.81512 2112999.88713 37.7822544100736 -122.421653822027 (37.7822544100736, -122.421653822027) 7 9 11 28852 41
136130 12431 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1755 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
141620 12882 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 200X Larch St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6006589.39642 2113072.01589 37.7824653447827 -122.420868153744 (37.7824653447827, -122.420868153744) 7 9 11 28852 41
145570 69257 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 401 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1994 12:00:00 AM     Permit Number 33324 5994548.69419505 2106652.17355678 37.7641521177083 -122.462057722056 (37.7641521177083, -122.462057722056) 1 5 11 56 12
148111 117165 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 299x ALMA ST 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
155138 113976 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1180 STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
161672 99651 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1300 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM   3x3   5991764 2106610 37.7638756002396 -122.471686009646 (37.7638756002396, -122.471686009646) 11 8 11 56 12
169289 113025 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 183 EDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996556 2106005 37.7624905091914 -122.455068303068 (37.7624905091914, -122.455068303068) 15 5 11 29492 12
169366 54897 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 203 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1972 12:00:00 AM   3x3 Permit Number 10763 5997226.12135807 2107036.80892371 37.765362015501 -122.452825087824 (37.765362015501, -122.452825087824) 15 5 11 29492 12
174023 101168 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 401 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 33324 5994554 2106650 37.7641464551633 -122.462039213312 (37.7641464551633, -122.462039213312) 1 5 11 56 12
175470 101167 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 401 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 33324 5994554 2106650 37.7641464551633 -122.462039213312 (37.7641464551633, -122.462039213312) 1 5 11 56 12
180509 113981 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1180 STANYAN ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
180899 12896 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 255X Larch St 6 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/1990 12:00:00 AM 3 3X3   6006360.81512 2112999.88713 37.7822544100736 -122.421653822027 (37.7822544100736, -122.421653822027) 7 9 11 28852 41
184820 2460 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1802X Buchanan St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6004009.7642795 2114616.5275781 37.7865604469042 -122.429902759542 (37.7865604469042, -122.429902759542) 13 9 11 29490 27
185037 113026 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 183 EDGEWOOD AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996556 2106005 37.7624905091914 -122.455068303068 (37.7624905091914, -122.455068303068) 15 5 11 29492 12
187122 12883 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 200X Larch St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6006589.39642 2113072.01589 37.7824653447827 -122.420868153744 (37.7824653447827, -122.420868153744) 7 9 11 28852 41
192508 12434 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1755 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
194140 2459 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1801X Buchanan St 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/1998 12:00:00 AM 3 4X4   6003961.1396892 2114603.1916159 37.7865210759478 -122.430070036959 (37.7865210759478, -122.430070036959) 13 9 11 29490 27
3863 113716 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 498x 21ST AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989370 2112285 37.7793187899318 -122.480381451803 (37.7793187899318, -122.480381451803) 11 6 2 55 26
194128 21848 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 224 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/1993 12:00:00 AM 5 3X3   5994910.90461 2110804.06513 37.775572970261 -122.461105914285 (37.775572970261, -122.461105914285) 11 6 2 54 11
11653 218107 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 71 Lopez Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5993982.26369 2100522.02822 37.7472876877838 -122.463571902628 (37.7472876877838, -122.463571902628) 1 8 4 29491 40
34099 105230 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 69 KEYSTONE WAY 1 Front Yard : Yard Tree Private 2   06/17/2014 12:00:00 AM 30   Permit Number 773353 5994093.4 2093229.9 37.7272717167315 -122.462658710338 (37.7272717167315, -122.462658710338) 9 8 4 59 40
92181 107345 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 220 MAGELLAN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x7   5994880.3 2100549.9 37.7474159195797 -122.46046860034 (37.7474159195797, -122.46046860034) 1 8 4 29491 40
96531 109411 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 401 MOLIMO DR 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997363.9 2097040.1 37.7379214277854 -122.451627389441 (37.7379214277854, -122.451627389441) 9 7 4 59 40
109669 105751 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1934 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x9   5993512.3 2102309.6 37.752168813411 -122.465326817059 (37.752168813411, -122.465326817059) 1 8 4 29491 12
110154 102074 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 273 Magellan Ave 4 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
175090 258068 - 12 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2700 15th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1           5991795.11646 2097053.50144 37.7376377360918 -122.470882201509 (37.7376377360918, -122.470882201509) 1 8 4 29491 40
12504 253674 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 600 x Sanchez St 2 Unaccepted Street : Yard Tree DPW 1       3x3   6003598 2104743 37.7594268373878 -122.430622555907 (37.7594268373878, -122.430622555907) 2 4 5 28862 3
19233 108674 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
25263 107955 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 105 Danvers St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999967.5 2105076.1 37.7601351040878 -122.443202492583 (37.7601351040878, -122.443202492583) 2 4 5 28862 3
36111 108671 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
40648 108668 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
56835 4258 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 4094X Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6003364.7569552 2100412.8299453 37.7475239975457 -122.431120155296 (37.7475239975457, -122.431120155296) 2 4 5 63 22
75400 4259 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 4094X Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6003364.7569552 2100412.8299453 37.7475239975457 -122.431120155296 (37.7475239975457, -122.431120155296) 2 4 5 63 22
80596 24372 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 196 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005439.3271375 2108485.5635222 37.7698071707032 -122.42452055163 (37.7698071707032, -122.42452055163) 8 4 5 28853 19
80990 107306 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 191 CASELLI AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000068 2104828 37.7594596127231 -122.442837096046 (37.7594596127231, -122.442837096046) 2 4 5 28862 3
81324 104327 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 69 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002459 2106769 37.7649251496158 -122.434706648196 (37.7649251496158, -122.434706648196) 15 5 5 28862 3
88393 108669 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
142176 104391 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 3506 24TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006060 2102069 37.7522238232197 -122.421917788016 (37.7522238232197, -122.421917788016) 2 4 5 28859 19
153514 108676 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 9 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
171574 108672 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 5 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
173983 108670 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
176478 108673 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
177114 24373 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 196 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005439.3271375 2108485.5635222 37.7698071707032 -122.42452055163 (37.7698071707032, -122.42452055163) 8 4 5 28853 19
178820 108675 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 290x DORLAND ST 8 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6003652 2105829 37.762411792447 -122.430513287182 (37.762411792447, -122.430513287182) 8 4 5 28862 3
179967 104844 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 395X Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003932.8304 2096688.95118 37.7373312570435 -122.428890347629 (37.7373312570435, -122.428890347629) 2 7 5 63 7
191669 4260 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 4094X Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6003303.5082097 2100409.5413687 37.7475114969278 -122.431331714787 (37.7475114969278, -122.431331714787) 2 4 5 63 22
1905 40652 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 227 Congdon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1999 12:00:00 AM 2   Permit Number 41647 6004715.33788 2093887.46334 37.7296832590634 -122.425985487752 (37.7296832590634, -122.425985487752) 9 7 6 28861 5
61697 96800 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 295x Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5992696 2088571 37.7143989335186 -122.467150884655 (37.7143989335186, -122.467150884655) 9 8 6 64 24
84057 113779 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 322 LISBON ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002684 2091576 37.723221487961 -122.432842971004 (37.723221487961, -122.432842971004) 9 7 6 28861 5
8290 259333 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 240 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008972 2097246 37.739144727939 -122.411506882934 (37.739144727939, -122.411506882934) 10 7 7 28859 2
8995 116073 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 88 MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010492 2099980 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671) 2 7 7 28859 2
24432 255551 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 277 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006741 2104530 37.7590195448546 -122.419737382682 (37.7590195448546, -122.419737382682) 2 4 7 28859 19
27232 109017 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 111x 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
32286 102868 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2761 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 .75X.75   6009574.6 2103896.5 37.7574393136514 -122.409892695521 (37.7574393136514, -122.409892695521) 2 4 7 28859 19
46643 39172 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 736 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM 8   Permit Number 40834 6007488.6062833 2105367.57823812 37.761361427438 -122.417211152399 (37.761361427438, -122.417211152399) 2 4 7 28859 19
58269 122812 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 889 York St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6009956.83094511 2104043.07852524 37.7578631996098 -122.40858112242 (37.7578631996098, -122.40858112242) 2 4 7 28859 19
68425 121339 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 214 Putnam St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009065 2096301 37.736555179089 -122.411118596402 (37.736555179089, -122.411118596402) 10 7 7 28859 2
81368 122475 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 3201x 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6006946 2103163 37.7552776242638 -122.41893143992 (37.7552776242638, -122.41893143992) 2 4 7 28859 19

Next page

Advanced export

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

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);