4,014 rows where qSpecies_id = 40 sorted by TreeID 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)
52211 95618 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2791 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767383 6008097 2106797 37.7653204974455 -122.41520815513 (37.7653204974455, -122.41520815513) 8 4 7 28859 19
70404 95588 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2153 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2009 12:00:00 AM   3x3 Permit Number 767378 6000457 2120611 37.802817854966 -122.442624981194 (37.802817854966, -122.442624981194) 13 9 1 57 17
22763 95579 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3874 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767367 6003977 2101906 37.7516585690455 -122.429109505532 (37.7516585690455, -122.429109505532) 2 4 5 28862 22
17096 95570 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 564 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767361 6001501 2101469 37.7503181999041 -122.437640524789 (37.7503181999041, -122.437640524789) 2 4 5 28862 22
125823 95539 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4609 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767326 6000651 2101096 37.74924566559 -122.44055312449 (37.74924566559, -122.44055312449) 2 4 5 28862 22
60443 95442 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2536 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/03/2011 12:00:00 AM   3x3 Permit Number 767304 5986467.3 2097980.9 37.7398745611118 -122.489370926882 (37.7398745611118, -122.489370926882) 1 8 3 29491 35
77390 95421 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 450 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM   3x3 Permit Number 52610 6002863.5 2105624.8 37.7618064095 -122.433225823053 (37.7618064095, -122.433225823053) 15 4 5 28862 3
79631 95406 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 395 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767278 6003403.3 2099172.9 37.7441216223731 -122.430898399301 (37.7441216223731, -122.430898399301) 2 7 5 63 22
107525 95402 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767275 6003789.7 2099328.3 37.7445702007996 -122.429573394352 (37.7445702007996, -122.429573394352) 2 7 5 63 22
160628 95401 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767275 6003789.7 2099328.3 37.7445702007996 -122.429573394352 (37.7445702007996, -122.429573394352) 2 7 5 63 22
50704 95400 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 227 Valley St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767274 6004277.7 2099178.3 37.7441859544543 -122.427875301427 (37.7441859544543, -122.427875301427) 2 7 5 63 22
79580 95276 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 6x5 Created tree record for 2 trees on 2/2/2011. Trees planted years ago but no permit record for planting. 6009044.4 2104856.4 37.7600452523756 -122.411794171614 (37.7600452523756, -122.411794171614) 2 4 7 28859 19
152606 95275 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2013 12:00:00 AM 8 3x3 Permit Number 769625 6009044.4 2104856.4 37.7600452523756 -122.411794171614 (37.7600452523756, -122.411794171614) 2 4 7 28859 19
32947 95196 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 140 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2011 12:00:00 AM 20 3x3 Permit Number 767111 5992360 2098167.1 37.7407280491549 -122.469010166452 (37.7407280491549, -122.469010166452) 1 8 4 59 40
183291 95194 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 517 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2011 12:00:00 AM 1 3x3 Permit Number 767108 5985627.97637 2112321.20657 37.7792000368481 -122.493329154927 (37.7792000368481, -122.493329154927) 11 6 2 55 26
117109 95132 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 201 Capistrano Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54056 6001204.4 2093241.7 37.7277110907766 -122.438076912641 (37.7277110907766, -122.438076912641) 9 7 6 28861 25
120095 95016 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 83 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010516.6 2087234.5 37.7117417518759 -122.405461434977 (37.7117417518759, -122.405461434977) 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
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
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
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
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
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
78450 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
101013 94947 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
135218 94946 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 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
158140 94877 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3043 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2010 12:00:00 AM 12 3x3   6000192.74031 2115767.95632 37.7895050707416 -122.443191412453 (37.7895050707416, -122.443191412453) 13 6 1 29490 27
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
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
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
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
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
184729 94817 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 683 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2009 12:00:00 AM 3 3x3 Permit Number 52671 5983800.64794 2111169.09276 37.7759296136863 -122.499565366534 (37.7759296136863, -122.499565366534) 11 6 2 55 26
191775 94799 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495@Ulloa 23rd Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM     Permit Number 767295 5989187.3 2098380.9 37.741131264018 -122.479995678002 (37.741131264018, -122.479995678002) 1 8 3 29491 35
22245 94798 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495@Ulloa 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM     Permit Number 767295 5989187.3 2098380.9 37.741131264018 -122.479995678002 (37.741131264018, -122.479995678002) 1 8 3 29491 35
162714 94797 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM     Permit Number 767295 5989187.3 2098380.9 37.741131264018 -122.479995678002 (37.741131264018, -122.479995678002) 1 8 3 29491 35
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
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
32896 94734 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53865 5992586.24712 2110603.0007 37.7748868521692 -122.46913276056 (37.7748868521692, -122.46913276056) 11 6 2 54 11
62065 94707 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Edgehill Way 2 Sidewalk: Property side : Yard Tree Private 2   10/29/2010 12:00:00 AM 6   Permit Number 53868 5994701.2 2098925.3 37.7429448703691 -122.460970181408 (37.7429448703691, -122.460970181408) 1 8 4 59 40
178365 94706 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2   10/29/2010 12:00:00 AM 6   Permit Number 53868 5994701.2 2098925.3 37.7429448703691 -122.460970181408 (37.7429448703691, -122.460970181408) 1 8 4 59 40
123134 94703 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 658 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 3 3x3 Permit Number 53843 5992262.68777 2110962.91491 37.7758563780379 -122.470278225754 (37.7758563780379, -122.470278225754) 11 6 2 54 11
75509 94697 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2443 Clement St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM   3x3 Permit Number 53831 5987960 2113267 37.7819330460656 -122.485331246452 (37.7819330460656, -122.485331246452) 11 6 2 55 26
79616 94696 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2443 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 3 3x3 Permit Number 53831 5987889.1247 2113258.01396 37.7819042437171 -122.485575779552 (37.7819042437171, -122.485575779552) 11 6 2 55 26
128162 94680 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Rousseau St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53816 6003489 2095230 37.7333001775342 -122.430320814613 (37.7333001775342, -122.430320814613) 9 7 5 28861 25
192346 94665 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 113 Cuvier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53802 6004019 2095233 37.7333384216066 -122.428488672198 (37.7333384216066, -122.428488672198) 9 7 5 28861 25
156108 94660 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 179 Brompton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53797 6002081.8 2095055.1 37.7327401332326 -122.435173380526 (37.7327401332326, -122.435173380526) 9 7 5 63 40
34795 94655 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 540 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53794 6003382 2095642 37.7344253745893 -122.430720133335 (37.7344253745893, -122.430720133335) 2 7 5 63 7
31944 94585 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2725 Greenwich St   Sidewalk: Curb side : Cutout Tree Private 2   09/29/2010 12:00:00 AM   3x3 Permit Number 53761 5999865 2118793 37.7977923490456 -122.444542858 (37.7977923490456, -122.444542858) 13 9 1 57 17
116801 94562 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 251X OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6005545 2110135 37.774342092867 -122.424272360307 (37.774342092867, -122.424272360307) 7 9 11 28852 10
63936 94176 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 207 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53592 6000068.3 2105615.8 37.7616227342332 -122.442892631099 (37.7616227342332, -122.442892631099) 15 5 5 28862 3
150070 94175 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 207 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53592 6000068.3 2105615.8 37.7616227342332 -122.442892631099 (37.7616227342332, -122.442892631099) 15 5 5 28862 3
57814 94157 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1552 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53538 5993733.5 2104914.7 37.7593345004852 -122.464751039907 (37.7593345004852, -122.464751039907) 1 8 4 56 12
65115 94153 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2039 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53543 5990940.5 2101530.8 37.7498817803046 -122.474163585532 (37.7498817803046, -122.474163585532) 1 8 4 29491 12
52782 94150 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1623 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53548 5992425.1 2104390.5 37.7578196641788 -122.469237930006 (37.7578196641788, -122.469237930006) 1 8 4 56 12
109759 94145 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1705 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53555 5992755 2103821.2 37.7562755724562 -122.468055597969 (37.7562755724562, -122.468055597969) 1 8 4 56 12
67025 94142 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1846 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53560 5993183.4 2102902.4 37.753777516232 -122.466507276779 (37.753777516232, -122.466507276779) 1 8 4 56 12
185522 94136 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 651 Peralta Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53502 6009812.7 2098359.4 37.7422490030463 -122.408678634941 (37.7422490030463, -122.408678634941) 10 7 7 28859 2
9283 94134 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 18 Nebraska St   Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53498 6009291 2097948 37.7410901551317 -122.410453476975 (37.7410901551317, -122.410453476975) 10 7 7 28859 2
2608 94102 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2010 12:00:00 AM 5 3x3 Permit Number 53477 6009512.58757 2093214.72689 37.7281060226502 -122.409353352981 (37.7281060226502, -122.409353352981) 10 3 7 309 28
79298 93907 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 733 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/22/2010 12:00:00 AM   3x3 Permit Number 53380 5987516.1 2110955.9 37.7755615483313 -122.486697161376 (37.7755615483313, -122.486697161376) 11 6 2 55 26
100297 93749 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 455 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2010 12:00:00 AM   3x3 Permit Number 53324 6003563 2100087 37.7466405761834 -122.43041139941 (37.7466405761834, -122.43041139941) 2 7 5 63 22
21200 93748 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 455 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2010 12:00:00 AM   3x3 Permit Number 53324 6003563 2100087 37.7466405761834 -122.43041139941 (37.7466405761834, -122.43041139941) 2 7 5 63 22
26800 93720 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2329 Cecelia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2010 12:00:00 AM   3x3 Permit Number 53311 5991400.2 2099543.1 37.7444506897731 -122.472429047351 (37.7444506897731, -122.472429047351) 1 8 4 29491 40
117067 93676 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 25th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52753 5988779.9 2097863.1 37.7396858417248 -122.481366393427 (37.7396858417248, -122.481366393427) 1 8 3 29491 35
83709 9346 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 217 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/10/1999 12:00:00 AM 20 2X2   6000803.9441694 2098478.3891844 37.742067037249 -122.439836590706 (37.742067037249, -122.439836590706) 2 7 5 63 7
25013 93220 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1675 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2010 12:00:00 AM   3x3 Permit Number 53212 6004290 2108739 37.7704380729677 -122.42851411253 (37.7704380729677, -122.42851411253) 7 9 5 29492 10
84549 93219 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1675 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2010 12:00:00 AM   3x3 Permit Number 53212 6004290 2108739 37.7704380729677 -122.42851411253 (37.7704380729677, -122.42851411253) 7 9 5 29492 10
133521 93018 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 963 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2010 12:00:00 AM   3x3 Permit Number 53140 6006134 2121397 37.805297983444 -122.423035527254 (37.805297983444, -122.423035527254) 5 1 1 28858 32
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
54353 92795 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 52022 6012811.72806 2102960.97452 37.7550514540675 -122.398631693097 (37.7550514540675, -122.398631693097) 10 3 8 28856 29
175288 92609 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2528 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2009 12:00:00 AM 2 3x3 Permit Number 52920 5990746.65563 2112013.99975 37.778654601597 -122.475599281341 (37.778654601597, -122.475599281341) 11 6 2 54 26
178704 92608 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2524 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2009 12:00:00 AM 2 3x3 Permit Number 52920 5990771.27794 2112015.60912 37.7786604478424 -122.475514221681 (37.7786604478424, -122.475514221681) 11 6 2 54 26
74017 92533 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 349 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2009 12:00:00 AM   3x3 Permit Number 52878 6000209 2110074 37.7738718573556 -122.442726137571 (37.7738718573556, -122.442726137571) 15 5 11 29492 16
96306 92531 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1298X Kansas St 1 Median : Cutout Tree DPW 1     4     6011695.14318 2102366.06354 37.7533556870153 -122.402451357562 (37.7533556870153, -122.402451357562) 10 3 8 28856 29
19833 92520 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 243 Holly Park Cir 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52872 6006893.7 2096608.3 37.7372769513992 -122.418647509778 (37.7372769513992, -122.418647509778) 2 7 7 28859 2
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
65484 92493 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1942 Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/31/2009 12:00:00 AM   3x3 Permit Number 52863 5986947 2097598 37.7388512102115 -122.487684224147 (37.7388512102115, -122.487684224147) 1 8 3 29491 35
187166 92430 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1758 41st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM   3x3 Permit Number 52821 5983521.6 2103180.6 37.7539791070225 -122.499940017573 (37.7539791070225, -122.499940017573) 1 8 3 56 35
34021 92324 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2595 27th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.7390868384366 -122.484151218827 (37.7390868384366, -122.484151218827) 1 8 3 29491 35
14218 92323 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2595 27th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.7390868384366 -122.484151218827 (37.7390868384366, -122.484151218827) 1 8 3 29491 35
159410 92322 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2595 27th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.7390868384366 -122.484151218827 (37.7390868384366, -122.484151218827) 1 8 3 29491 35
114772 92311 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2211 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457) 1 8 3 29491 35
55399 92310 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2591 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM   3x3   5988279 2097698.2 37.7392039339278 -122.483086187221 (37.7392039339278, -122.483086187221) 1 8 3 29491 35
29041 92309 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 25th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52753 5988779.9 2097863.1 37.7396858417248 -122.481366393427 (37.7396858417248, -122.481366393427) 1 8 3 29491 35
118573 92308 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52753 5988779.9 2097863.1 37.7396858417248 -122.481366393427 (37.7396858417248, -122.481366393427) 1 8 3 29491 35
133322 92306 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2001 23rd Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2009 12:00:00 AM   3x3 Permit Number 52751 5989074.6 2101678 37.7501776851115 -122.480626655297 (37.7501776851115, -122.480626655297) 1 8 3 29491 35
64510 92305 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2001 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2009 12:00:00 AM   3x3 Permit Number 52751 5989074.6 2101678 37.7501776851115 -122.480626655297 (37.7501776851115, -122.480626655297) 1 8 3 29491 35
44659 92273 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 526 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2009 12:00:00 AM   3x3 Permit Number 52721 5994919 2098257 37.7411224151431 -122.4601686872 (37.7411224151431, -122.4601686872) 1 8 4 59 40
79827 92265 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2472 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2009 12:00:00 AM   3x3 Permit Number 52713 5991763.7 2098612.3 37.7419159834623 -122.471104352673 (37.7419159834623, -122.471104352673) 1 8 4 29491 40
82726 92257 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 862 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52706 5981411.16308 2109852.88199 37.7721751933845 -122.507733374623 (37.7721751933845, -122.507733374623) 11 6 2 55 26
168726 92237 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 710 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2009 12:00:00 AM 3 3x3 Permit Number 52681 5982614.54862 2110914.94505 37.7751621329201 -122.503649497706 (37.7751621329201, -122.503649497706) 11 6 2 55 26
133407 92234 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 530 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/2009 12:00:00 AM 4 3x3 Permit Number 52677 5982879.44866 2112163.93194 37.778607057675 -122.502825641062 (37.778607057675, -122.502825641062) 11 6 2 55 26
85256 92229 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 831 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 2 3x3 Permit Number 52669 5984149.10381 2110157.50395 37.7731725212481 -122.498285255587 (37.7731725212481, -122.498285255587) 11 6 2 55 26
76191 92228 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 819 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 2 3x3 Permit Number 52552 5984148.0757 2110235.49072 37.7733865902416 -122.498294572929 (37.7733865902416, -122.498294572929) 11 6 2 55 26
3941 92078 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1151 Sutter St   Sidewalk: Curb side : Cutout Tree Private 2   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083 2115004 37.7877979108835 -122.419297592258 (37.7877979108835, -122.419297592258) 13 9 10 28858 21
16351 92032 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4232 21st St   Sidewalk: Curb side : Cutout Tree Private 2   06/12/2009 12:00:00 AM   3x3 Permit Number 52175 6001386.1 2103403.9 37.75562443672 -122.43817644846 (37.75562443672, -122.43817644846) 2 4 5 28862 3

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