4,014 rows where qSpecies_id = 40 sorted by PlantDate descending

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)
58838 91880 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 840 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2008 12:00:00 AM 3 3x3   5993189.659614 2106651.64796 37.7640723354625 -122.466758152363 (37.7640723354625, -122.466758152363) 11 8 11 56 12
96983 91881 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 902 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2008 12:00:00 AM 3 3x3   5992992.499251 2106644.894373 37.7640424113715 -122.467439575398 (37.7640424113715, -122.467439575398) 11 8 11 56 12
128449 91882 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 910 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2008 12:00:00 AM 3 3x3   5992968.789826 2106644.082228 37.764038812611 -122.467521519562 (37.764038812611, -122.467521519562) 11 8 11 56 12
119368 81982 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 563 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2007 12:00:00 AM 1 3x3 Permit Number 49998 5982533.65676 2111927.12728 37.7779365331701 -122.504004303472 (37.7779365331701, -122.504004303472) 11 6 2 55 26
28058 114800 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1587 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2015 12:00:00 AM     Permit Number 770932 5990525.1 2104605.1 37.7582989241527 -122.475824523864 (37.7582989241527, -122.475824523864) 1 8 4 56 12
72488 5816 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 949 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2009 12:00:00 AM 3 3X3   6000363.39173 2099612.72886 37.745156576909 -122.441441255331 (37.745156576909, -122.441441255331) 2 7 5 63 22
90435 91875 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 700 Irving St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2008 12:00:00 AM 3 3x3   5993617.143263 2106666.291015 37.7641372031802 -122.465280687147 (37.7641372031802, -122.465280687147) 11 8 11 56 12
121331 91871 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 602 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2008 12:00:00 AM 3 3x3   5993921.546454 2106676.718119 37.7641833831457 -122.464228609956 (37.7641833831457, -122.464228609956) 11 5 11 56 12
137789 91872 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 602 Irving St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2008 12:00:00 AM 3 3x3   5993921.546454 2106676.718119 37.7641833831457 -122.464228609956 (37.7641833831457, -122.464228609956) 11 5 11 56 12
142666 91873 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 642 IRVING ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2008 12:00:00 AM 3 3x3   5993707.3 2106715.4 37.7642772424027 -122.464972430451 (37.7642772424027, -122.464972430451) 11 8 11 56 12
177403 91874 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 700 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2008 12:00:00 AM 3 3x3   5993617.143263 2106666.291015 37.7641372031802 -122.465280687147 (37.7641372031802, -122.465280687147) 11 8 11 56 12
131162 98034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1817 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2011 12:00:00 AM 3 3x3 Permit Number 768344 5999961.07212 2115342.88884 37.7883247339384 -122.443962403049 (37.7883247339384, -122.443962403049) 13 6 1 29490 27
70689 94959 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1059 Evans Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/09/2010 12:00:00 AM       6018613.9 2096078.3 37.7364745658864 -122.378088153142 (37.7364745658864, -122.378088153142) 10 3 8 58 1
91237 94954 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1725 Monterey Blvd   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53987 5992718.5 2095334 37.7329697745731 -122.467564641429 (37.7329697745731, -122.467564641429) 9 8 4 59 40
104975 94956 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1701 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53988 5994700.9 2092261.1 37.7246465945991 -122.460488430612 (37.7246465945991, -122.460488430612) 9 8 4 28861 24
127370 84326 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM 5 3x3 Permit Number 53994 5987888.08845 2110995.20666 37.7756911522049 -122.485413264439 (37.7756911522049, -122.485413264439) 11 6 2 55 26
146951 94958 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 201 San Benito Way   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53990 5992929.1 2095285.9 37.7328498609093 -122.46683305318 (37.7328498609093, -122.46683305318) 9 8 4 59 40
184284 94955 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1701 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53988 5994700.9 2092261.1 37.7246465945991 -122.460488430612 (37.7246465945991, -122.460488430612) 9 8 4 28861 24
24571 29668 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Van Ness Ave 3 Median : Cutout Tree DPW 1   12/09/2004 12:00:00 AM 6     6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
97434 23488 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500X Van Ness Ave 4 Median : Cutout Tree DPW 1   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
166393 23489 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500X Van Ness Ave 5 Median : Cutout Tree DPW 1   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679 37.7985416396102 -122.423888617279 (37.7985416396102, -122.423888617279) 13 9 10 28858 32
2473 88167 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 189 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 1 3x3 Permit Number 51184 6010014.6058 2087504.2072 37.7124542316575 -122.407215472312 (37.7124542316575, -122.407215472312) 9 7 8 309 39
65703 95006 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 195 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 3 3x3   6009968.4 2087457.4 37.7123231225616 -122.407371876718 (37.7123231225616, -122.407371876718) 9 7 8 309 39
41341 62520 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4156 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2011 12:00:00 AM 3 3x3 Permit Number 768356 6001341.51712821 2102932.94007142 37.7543287587325 -122.43829689141 (37.7543287587325, -122.43829689141) 2 4 5 28862 22
105003 81961 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 485 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2007 12:00:00 AM 2   Permit Number 49960 5984369.11349 2112553.91349 37.7797652693345 -122.497701199729 (37.7797652693345, -122.497701199729) 11 6 2 55 26
113429 81737 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 591 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2007 12:00:00 AM 4 3x3 Permit Number 49969 5983468.0529 2111801.95258 37.7776477425111 -122.500762690576 (37.7776477425111, -122.500762690576) 11 6 2 55 26
41093 87021 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 220 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2007 12:00:00 AM   3x3 Permit Number 49952 6004869 2103995 37.7574449283847 -122.426173558598 (37.7574449283847, -122.426173558598) 2 4 5 28862 3
61086 87022 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 569 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2007 12:00:00 AM   3x3 Permit Number 49956 5985016.5 2111999.9 37.7782820363511 -122.49542076869 (37.7782820363511, -122.49542076869) 11 6 2 55 26
135932 48973 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1409 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/2002 12:00:00 AM 10 3x3 Permit Number 46160 5992699.25598435 2105862.87116543 37.7618782478409 -122.468396910406 (37.7618782478409, -122.468396910406) 1 8 4 56 12
29686 114760 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2849 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM     Permit Number 777140 6009026.4 2101883.5 37.7518813304133 -122.41164636992 (37.7518813304133, -122.41164636992) 2 4 7 28859 19
93936 26519 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2851 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM 1 1X1 Permit Number 777140 6009004.2746 2101873.01384 37.7518512966093 -122.411722142074 (37.7518512966093, -122.411722142074) 2 4 7 28859 19
24698 8097 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 762 Fulton St 8 Sidewalk: Curb side : Cutout Tree Arts Commission 19   12/04/2010 12:00:00 AM 3 3X3   6004143.8911021 2111521.3201229 37.7780693729621 -122.4292179278 (37.7780693729621, -122.4292179278) 7 9 11 28852 41
50672 238483 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 103 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 13 Width 3ft Permit Number 37768 6003709.01097 2108821.61027 37.7706320052989 -122.430529650538 (37.7706320052989, -122.430529650538) 15 9 11 29492 10
170480 238484 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 103 Germania St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 7 Width 3ft Permit Number 37768 6003723.3725 2108822.3529 37.7706348579377 -122.430480026835 (37.7706348579377, -122.430480026835) 15 9 11 29492 10
53915 104995 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2220 Castro St   Sidewalk: Curb side : Cutout Tree Private 2   12/03/2013 12:00:00 AM   3X3 Permit Number 771144 6002644.3 2099031.5 37.7436903366208 -122.433512747881 (37.7436903366208, -122.433512747881) 2 7 5 63 22
3867 33659 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 545 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 8   Permit Number 37747 6004792.43502 2110705.04365 37.7758647708832 -122.426916230306 (37.7758647708832, -122.426916230306) 7 9 11 28852 10
87406 33649 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 541 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 8   Permit Number 37740 6004806.91261 2110706.66354 37.7758700373021 -122.426866263978 (37.7758700373021, -122.426866263978) 7 9 11 28852 10
130832 121549 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 53 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2016 12:00:00 AM 3 3x3   6002689 2105575 37.7616597701015 -122.433825788836 (37.7616597701015, -122.433825788836) 15 4 5 28862 3
192289 50606 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2003 12:00:00 AM 7   Permit Number 47205 5994896.0666 2113978.53623 37.784288365195 -122.461387423321 (37.784288365195, -122.461387423321) 11 6 2 54 11
25801 33423 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 163 Westgate Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/01/2015 12:00:00 AM     Permit Number 774515 5993446.55612201 2094023.66864414 37.7294139362366 -122.464952451879 (37.7294139362366, -122.464952451879) 9 8 4 59 40
38586 73075 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 212-214 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2010 12:00:00 AM   3x3 Permit Number 53964 6005141.46475823 2099927.4876788 37.7462918791242 -122.424941880524 (37.7462918791242, -122.424941880524) 2 7 5 63 22
32970 81 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 899 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/29/2001 12:00:00 AM 8 3X3   6002864.3199934 2107660.1796498 37.7673951141913 -122.433368437593 (37.7673951141913, -122.433368437593) 15 5 5 28862 3
61092 10178 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/29/2001 12:00:00 AM 16 2X2   6005705.19862 2102704.3683 37.7539483816144 -122.423189907382 (37.7539483816144, -122.423189907382) 2 4 5 28859 19
23854 86960 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 208 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2007 12:00:00 AM 6 3x3 Permit Number 49928 5993493.7535 2087361.9529 37.7111251955331 -122.464305827668 (37.7111251955331, -122.464305827668) 9 8 4 64 24
55464 86961 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 212 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2007 12:00:00 AM 4 3x3 Permit Number 49929 5993495.99209 2087406.23034 37.7112468999028 -122.464301303157 (37.7112468999028, -122.464301303157) 9 8 4 64 24
83349 33813 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 261 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/26/1996 12:00:00 AM 6   Permit Number 37827 6006152.11101 2110895.22751 37.7764637562375 -122.422226270344 (37.7764637562375, -122.422226270344) 7 9 11 28852 10
83624 33812 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 261 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/1996 12:00:00 AM 5   Permit Number 37827 6006136.86682 2110893.01835 37.776456830551 -122.422278847415 (37.776456830551, -122.422278847415) 7 9 11 28852 10
46800 89366 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51946 6006673.6 2095420.1 37.7340020224619 -122.419324232824 (37.7340020224619, -122.419324232824) 2 7 7 28859 2
82306 89369 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 360 Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51947 6006757.2 2095391.9 37.7339292995254 -122.419033201721 (37.7339292995254, -122.419033201721) 2 7 7 28859 2
111354 89368 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 360 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51947 6006757.2 2095391.9 37.7339292995254 -122.419033201721 (37.7339292995254, -122.419033201721) 2 7 7 28859 2
137305 89367 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51946 6006673.6 2095420.1 37.7340020224619 -122.419324232824 (37.7340020224619, -122.419324232824) 2 7 7 28859 2
183304 89365 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Benton Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51945 6006769 2095411.9 37.733984879603 -122.418993823503 (37.733984879603, -122.418993823503) 2 7 7 28859 2
152097 114542 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011944.84803 2103714.66509 37.7570725877403 -122.401682603564 (37.7570725877403, -122.401682603564) 10 3 8 28856 29
192611 114543 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011964.29912 2103715.17017 37.7570750599871 -122.401615369369 (37.7570750599871, -122.401615369369) 10 3 8 28856 29
39510 41180 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1780 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM 3   Permit Number 41899 6001541.153 2121088.1531 37.804189731738 -122.438907479297 (37.804189731738, -122.438907479297) 13 9 1 57 17
112966 41181 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1780 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM 11   Permit Number 41899 6001559.95191 2121091.33566 37.8041995397404 -122.438842652585 (37.8041995397404, -122.438842652585) 13 9 1 57 17
120825 34255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2280 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2016 12:00:00 AM 3 6x4 Permit Number 779106 6002701.36974 2117843.10011 37.7953456053627 -122.434660283471 (37.7953456053627, -122.434660283471) 13 9 1 57 17
74016 94875 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 44 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53944 6011618 2095077 37.7333371742049 -122.402205704408 (37.7333371742049, -122.402205704408) 10 3 8 58 1
100494 94874 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53943 6011600 2095102 37.7334048142135 -122.402269692882 (37.7334048142135, -122.402269692882) 10 3 8 58 1
134237 94878 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 56 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53946 6011673 2095004 37.73313980136 -122.402010422944 (37.73313980136, -122.402010422944) 10 3 8 58 1
185997 94869 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53939 6012921 2095173 37.7336734157115 -122.397707572671 (37.7336734157115, -122.397707572671) 10 3 8 58 1
189602 94876 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 48 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53945 6011636 2095053 37.7332722799512 -122.402141786329 (37.7332722799512, -122.402141786329) 10 3 8 58 1
38841 48912 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1930 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2002 12:00:00 AM 2 3x3 Permit Number 46107 6004309.09705 2118070.5094 37.7960611527628 -122.429113506091 (37.7960611527628, -122.429113506091) 13 9 1 57 17
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
133498 92826 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 755 14th Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/19/2009 12:00:00 AM 5 3x3 Permit Number 53040 5991610.35704 2110282.05129 37.7739491753353 -122.472485133979 (37.7739491753353, -122.472485133979) 11 6 2 54 26
127618 29119 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 509 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/19/2005 12:00:00 AM 3 3x3   6008381.9659 2113792.89597 37.7845455839642 -122.414717657915 (37.7845455839642, -122.414717657915) 7 10 9 28858 36
16956 103454 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 284 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 3x3   5988396.69633 2114118.88325 37.7842975073391 -122.483882980771 (37.7842975073391, -122.483882980771) 11 6 2 55 26
62451 91030 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6009941.213427 2111462.810786 37.7782352043229 -122.409158690819 (37.7782352043229, -122.409158690819) 14 2 9 28853 34
124293 4156 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3728 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/1997 12:00:00 AM 12 3X3   6005666.3363086 2100538.647271 37.7479996173298 -122.423170370206 (37.7479996173298, -122.423170370206) 2 4 5 28859 19
37392 96373 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1315 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008912.46348 2117456.9297 37.7946359224745 -122.413141486295 (37.7946359224745, -122.413141486295) 5 1 10 28857 21
177201 96374 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1315 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008916.21068 2117429.19629 37.7945599836999 -122.413126558466 (37.7945599836999, -122.413126558466) 5 1 10 28857 21
38382 28779 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4065 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2004 12:00:00 AM 3 3X3   6003498.49604 2100372.77288 37.747421587832 -122.430654836155 (37.747421587832, -122.430654836155) 2 4 5 63 22
28311 4063 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3053 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/15/1995 12:00:00 AM 3 3X3   6009245.44366 2100538.36575 37.7482001758998 -122.410793893342 (37.7482001758998, -122.410793893342) 2 4 7 28859 2
67796 33273 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1121 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/1996 12:00:00 AM 7   Permit Number 37442 6009382.25638 2117052.96271 37.7935530901583 -122.411487381259 (37.7935530901583, -122.411487381259) 3 1 10 28857 21
77137 57611 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 356 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1976 12:00:00 AM 13   Permit Number 16500 6013179.72476 2105412.69394 37.7618038355947 -122.397530985864 (37.7618038355947, -122.397530985864) 10 3 8 28856 29
23477 94834 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1256 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53912 5993662.6 2106952.2 37.7649248555896 -122.465144234508 (37.7649248555896, -122.465144234508) 11 8 11 56 12
88363 69086 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1466 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53819 5992143.8934222 2105465.60262386 37.7607553597545 -122.470288741274 (37.7607553597545, -122.470288741274) 1 8 4 56 12
95591 62769 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1601 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53899 5993053.19389213 2104565.97882444 37.7583377577 -122.467078496083 (37.7583377577, -122.467078496083) 1 8 4 56 12
105605 92496 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1268 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53913 5993659.7 2106862.4 37.7646781211284 -122.465147741843 (37.7646781211284, -122.465147741843) 11 8 11 56 12
139276 94828 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1307 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53906 5994508.7 2106601.7 37.7640112277419 -122.462192388622 (37.7640112277419, -122.462192388622) 1 5 11 56 12
157807 94825 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1255 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53905 5990438 2106842.5 37.764437175462 -122.476289179121 (37.764437175462, -122.476289179121) 11 8 3 56 12
70365 46154 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 466 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2008 12:00:00 AM   3x3 Permit Number 51922 5997486.25604709 2107473.80664401 37.766576803009 -122.451956877082 (37.766576803009, -122.451956877082) 15 5 11 29492 9
6547 238340 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 227 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2020 12:00:00 AM 3 Width 3ft Permit Number 787829 6002088.29914 2104514.86028 37.7587147776761 -122.435827511746 (37.7587147776761, -122.435827511746) 2 4 5 28862 3
12211 238341 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 227 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2020 12:00:00 AM 3 Width 3ft Permit Number 787829 6002087.73113 2104529.67514 37.7587554234364 -122.435830536172 (37.7587554234364, -122.435830536172) 2 4 5 28862 3
187810 4031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/06/2015 02:05:00 PM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
58230 107938 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 613 Faxon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3 3x3 Permit Number 772422 5994837.09376 2092346.05841 37.7248877040282 -122.460023781173 (37.7248877040282, -122.460023781173) 9 8 4 28861 40
185715 107937 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 613 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3 3x3 Permit Number 772422 5994837.09376 2092346.05841 37.7248877040282 -122.460023781173 (37.7248877040282, -122.460023781173) 9 8 4 28861 40
30236 94788 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2461 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/2010 12:00:00 AM   3x3 Permit Number 53886 6008244 2104101 37.757926162272 -122.414508925782 (37.757926162272, -122.414508925782) 2 4 7 28859 19
168154 4210 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3932 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/05/2004 12:00:00 AM 3 3X3   6004303.84786 2100460.14425 37.7477070821197 -122.427876208032 (37.7477070821197, -122.427876208032) 2 4 5 63 22
17129 33142 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3148 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 8   Permit Number 37368 6001934.81136 2119023.66644 37.7985435846779 -122.437397274777 (37.7985435846779, -122.437397274777) 13 9 1 57 17
110826 33141 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3143 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 9   Permit Number 37367 6001898.22805 2118969.04221 37.7983915210181 -122.437519950413 (37.7983915210181, -122.437519950413) 13 9 1 57 17
157300 33140 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3143 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 6   Permit Number 37367 6001896.074 2118984.29093 37.7984332675401 -122.437528496644 (37.7984332675401, -122.437528496644) 13 9 1 57 17
144490 94744 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1801 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2010 12:00:00 AM 4 3x3 Permit Number 53879 6004279.92071 2118358.49437 37.7968502341069 -122.429235007194 (37.7968502341069, -122.429235007194) 13 9 1 57 17
85613 68681 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 324 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 3   Permit Number 32590 5992799.21781 2113282.48251 37.7822562861189 -122.468591057596 (37.7822562861189, -122.468591057596) 11 6 2 54 11
20779 103766 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101X Austin St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006706.11036 2115484.69473 37.7890965465282 -122.420635698799 (37.7890965465282, -122.420635698799) 13 9 10 28858 21
23030 135979 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99 Fern St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 4 Width 4ft   6006900.63841 2115164.21663 37.7882275541095 -122.419939904112 (37.7882275541095, -122.419939904112) 13 9 10 28858 21
23842 103777 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 90X Fern St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6007061.73741 2115197.31568 37.7883275106802 -122.41938487644 (37.7883275106802, -122.41938487644) 13 9 10 28858 21
28084 103765 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101X Austin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006551.29204 2115477.084 37.7890669227742 -122.42117081077 (37.7890669227742, -122.42117081077) 13 9 10 28858 21
60351 135978 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99 Fern St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 4 Width 4ft   6006877.42 2115159.3392 37.7882128537759 -122.420019889812 (37.7882128537759, -122.420019889812) 13 9 10 28858 21
60607 103806 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 98X Hemlock St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006930.58351 2114841.83487 37.7873440601297 -122.419813414468 (37.7873440601297, -122.419813414468) 13 9 10 28858 21

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)
);