4,014 rows where qSpecies_id = 40 sorted by Neighborhoods (old)

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) ▼
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
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
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
189754 196482 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr 1 : Tree Private 2     5 Width 2ft   6012916.33928 2095157.16046 37.7336296640747 -122.39772257563 (37.7336296640747, -122.39772257563) 10 3 8 58 1
190080 196481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2075 Palou Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6012348.97653 2097093.78891 37.738915629056 -122.399820067148 (37.738915629056, -122.399820067148) 10 3 8 58 1
190180 42715 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 43 Pomona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 10   Permit Number 42728 6014158.74539 2094459.12789 37.7317821166448 -122.393378351035 (37.7317821166448, -122.393378351035) 10 3 8 58 1
191654 102036 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 52501 6012999.572 2089254.628 37.7174271437906 -122.397021097837 (37.7174271437906, -122.397021097837) 10 3 8 58 1
191876 196439 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015016.02089 2101171.05558 37.7502592780626 -122.390883463504 (37.7502592780626, -122.390883463504) 10 3 8 28856 1
191921 14624 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Matthew Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 6 3X4   6018000.3078284 2094247.4364445 37.7314135402286 -122.380082436697 (37.7314135402286, -122.380082436697) 10 3 8 58 1
192027 196459 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1760 Cesar Chavez St 5 : Tree Private 2     5 Width 2ft   6013796.36432 2101069.01684 37.7499113519264 -122.395093999398 (37.7499113519264, -122.395093999398) 10 3 8 58 1
1115 238053 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 426 Lily St 2 : Tree Private 2     9 Width 3ft   6004459.53739 2109991.59452 37.7738869854343 -122.428016956418 (37.7738869854343, -122.428016956418) 7 9 11 28852 10
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
6608 47030 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
8391 238054 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 432 Lily St 1 Sidewalk: Property side : Cutout Tree Private 2     11 Width 3ft   6004439.8336 2109989.04683 37.7738788753301 -122.428084933487 (37.7738788753301, -122.428084933487) 7 9 11 28852 10
10602 104255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
17260 57706 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 268 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2009 12:00:00 AM   3x3 Permit Number 52597 6003986.30319774 2108724.10323801 37.7703799791966 -122.429563538214 (37.7703799791966, -122.429563538214) 7 9 11 29492 10
18621 238048 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400 Lily St 3 : Tree Private 2     6 Width 3ft   6004553.97154 2110004.04883 37.7739265241283 -122.427691180609 (37.7739265241283, -122.427691180609) 7 9 11 28852 10
22117 238046 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400 Lily St 1 : Tree Private 2     1 Width 3ft   6004578.89431 2110007.96592 37.7739386892479 -122.427605247709 (37.7739386892479, -122.427605247709) 7 9 11 28852 10
22969 103049 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400X Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6005072 2110257 37.7746503556504 -122.425917242315 (37.7746503556504, -122.425917242315) 7 9 11 28852 10
24376 237016 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 6 : Tree Private 2     10 Width 2ft   6004555.22046 2109981.30616 37.773864148951 -122.42768523968 (37.773864148951, -122.42768523968) 7 9 11 28852 10
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
28308 237185 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 78 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004315.99922 2108931.71426 37.7709686907843 -122.428437919182 (37.7709686907843, -122.428437919182) 7 9 11 28852 10
29810 51964 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 624 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/2005 12:00:00 AM     Permit Number 48186 6004986.46742486 2111098.21623731 37.7769552960255 -122.426273020817 (37.7769552960255, -122.426273020817) 7 9 11 28852 10
31840 103051 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     5 3x3   6005072 2110257 37.7746503556504 -122.425917242315 (37.7746503556504, -122.425917242315) 7 9 11 28852 10
33834 238052 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 426 Lily St 1 : Tree Private 2     11 Width 3ft   6004475.89025 2109993.473 37.7738930684378 -122.42796052306 (37.7738930684378, -122.42796052306) 7 9 11 28852 10
35727 238050 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400 Lily St 5 : Tree Private 2     4 Width 3ft   6004531.27247 2110000.08562 37.7739143581026 -122.427769418044 (37.7739143581026, -122.427769418044) 7 9 11 28852 10
36796 30881 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 59 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1995 12:00:00 AM 1   Permit Number 34714 6004013.78951 2108865.19521 37.7707689396642 -122.429478526513 (37.7707689396642, -122.429478526513) 7 9 11 29492 10
39361 82980 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 535-537 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52398 6004842.87299878 2110699.22399126 37.7758516433121 -122.426741337783 (37.7758516433121, -122.426741337783) 7 9 11 28852 10
39680 237014 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 4 : Tree Private 2     5 Width 2ft   6004527.81122 2109977.01256 37.7738508093129 -122.427779746755 (37.7738508093129, -122.427779746755) 7 9 11 28852 10
40675 47009 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 463 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45007 6003641.69340393 2109907.77842423 37.7736105432433 -122.430840029306 (37.7736105432433, -122.430840029306) 15 9 11 29492 10
48274 103042 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 450X Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758) 7 9 11 28852 10
49146 104249 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St Frontage East 3 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
49196 238049 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400 Lily St 4 : Tree Private 2     7 Width 3ft   6004542.42912 2110001.70207 37.7739194275845 -122.427730940528 (37.7739194275845, -122.427730940528) 7 9 11 28852 10
49777 47033 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
50233 237038 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Octavia St 1 : Tree Private 2     5 Width 4ft   6005608.42983 2109742.33589 37.773267513529 -122.424025015163 (37.773267513529, -122.424025015163) 7 9 11 28852 10
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
54306 237027 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St 8 : Tree Private 2     5 Width 6ft   6005758.33223 2109504.65873 37.7726233714135 -122.423489581302 (37.7726233714135, -122.423489581302) 7 9 11 28852 10
54764 237017 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 7 : Tree Private 2     8 Width 2ft   6004569.305 2109982.95925 37.7738694846242 -122.427636636743 (37.7738694846242, -122.427636636743) 7 9 11 28852 10
54770 237029 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St 10 : Tree Private 2     3 Width 6ft   6005753.2097 2109536.23847 37.7727097926437 -122.423509546241 (37.7727097926437, -122.423509546241) 7 9 11 28852 10
55163 238478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004072.80326 2108893.58954 37.7708502446648 -122.429276421875 (37.7708502446648, -122.429276421875) 7 9 11 29492 10
55599 238475 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 381 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003837.74726 2108996.21108 37.7711187084898 -122.430096807715 (37.7711187084898, -122.430096807715) 7 9 11 29492 10
55857 237026 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St 7 : Tree Private 2     3 Width 6ft   6005759.75569 2109493.68206 37.7725933124646 -122.423483876889 (37.7725933124646, -122.423483876889) 7 9 11 28852 10
55987 238471 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003403.57137 2108474.9085 37.7696627393757 -122.431561413932 (37.7696627393757, -122.431561413932) 15 9 5 29492 10
61739 238469 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 434 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003617.97734 2109021.69866 37.7711762417126 -122.430858818585 (37.7711762417126, -122.430858818585) 15 9 11 29492 10
62220 238479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82 Germania St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003859.40004 2108866.56108 37.7707639475293 -122.43001265998 (37.7707639475293, -122.43001265998) 7 9 11 29492 10
66327 238470 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003405.92625 2108464.16893 37.7696333846125 -122.431552501661 (37.7696333846125, -122.431552501661) 15 9 5 29492 10
70990 238051 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 400 Lily St 6 : Tree Private 2     14 Width 3ft   6004519.00384 2109998.49241 37.7739092895156 -122.427811743735 (37.7739092895156, -122.427811743735) 7 9 11 28852 10
72323 43023 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 519 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM 9   Permit Number 42885 6004020.08181 2110698.29349 37.7758025350991 -122.429587516272 (37.7758025350991, -122.429587516272) 7 9 11 29492 10
73822 237021 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 509 Hickory St 1 : Tree Private 2     6 Width 2ft   6004431.83065 2110307.63972 37.7747532007429 -122.428135326097 (37.7747532007429, -122.428135326097) 7 9 11 28852 10
73934 104256 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
74420 238491 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006355.34413 2110387.19122 37.7750802724623 -122.421487139129 (37.7750802724623, -122.421487139129) 7 9 11 28852 10
77514 238490 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006307.18834 2110382.81943 37.7750655532558 -122.421653410291 (37.7750655532558, -122.421653410291) 7 9 11 28852 10
78950 237033 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Octavia St 7 : Tree DPW 1     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079) 7 9 11 28852 10
79153 47019 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2002 12:00:00 AM     Permit Number 45014 6004716.89647578 2110040.09694572 37.7740347181094 -122.427130164093 (37.7740347181094, -122.427130164093) 7 9 11 28852 10
79907 237019 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 203 Webster St 2 : Tree Private 2     3 Width 3ft   6004185.26879 2109539.80191 37.7726309526779 -122.428933479791 (37.7726309526779, -122.428933479791) 7 9 11 29492 10
83109 238487 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Lily St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006307.15117 2110249.94796 37.7747007180984 -122.42164409961 (37.7747007180984, -122.42164409961) 7 9 11 28852 10
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
84440 30682 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3   Permit Number 782764 6004593.18284 2110062.14173 37.7740882510028 -122.427559681752 (37.7740882510028, -122.427559681752) 7 9 11 28852 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
86715 47032 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
86720 238056 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 439 Lily St 1 : Tree Private 2     9 Width 2ft   6004411.75821 2109960.94242 37.7738001190119 -122.428180047573 (37.7738001190119, -122.428180047573) 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
87661 238488 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Lily St 10 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006273.57752 2110244.12778 37.7746828440634 -122.42175982435 (37.7746828440634, -122.42175982435) 7 9 11 28852 10
89833 51966 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 624 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/2005 12:00:00 AM     Permit Number 48186 6004986.46742486 2111098.21623731 37.7769552960255 -122.426273020817 (37.7769552960255, -122.426273020817) 7 9 11 28852 10
89932 104250 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
91034 101319 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2-4 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 6x5   6003417 2108348 37.7693150407363 -122.431505903511 (37.7693150407363, -122.431505903511) 15 9 5 28862 10
92339 238480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 138 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003616.88408 2108831.82292 37.7706548273998 -122.430849047443 (37.7706548273998, -122.430849047443) 15 9 11 29492 10
99348 237011 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 1 : Tree Private 2     11 Width 2ft   6004491.59652 2109971.54016 37.7738337347625 -122.427904629301 (37.7738337347625, -122.427904629301) 7 9 11 28852 10
99924 47001 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 127 BUCHANAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45001 6004764.4 2108902.6 37.7709141138756 -122.426884813577 (37.7709141138756, -122.426884813577) 7 9 11 28852 10
101441 238485 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Lily St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006368.40748 2110255.5826 37.77471964342 -122.421432601534 (37.77471964342, -122.421432601534) 7 9 11 28852 10
101721 237025 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St 6 : Tree Private 2     3 Width 6ft   6005760.04076 2109480.81274 37.7725579925006 -122.423481975714 (37.7725579925006, -122.423481975714) 7 9 11 28852 10
102903 237013 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 401 Lily St 3 : Tree Private 2     8 Width 2ft   6004515.0923 2109975.33135 37.7738454736228 -122.427823623763 (37.7738454736228, -122.427823623763) 7 9 11 28852 10
104854 237018 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 203 Webster St 1 : Tree Private 2     3 Width 3ft   6004183.20353 2109550.46274 37.7726601078159 -122.428941383946 (37.7726601078159, -122.428941383946) 7 9 11 29492 10
105662 238492 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6006395.8599 2110394.0176 37.7751013004086 -122.421347470809 (37.7751013004086, -122.421347470809) 7 9 11 28852 10
108095 32988 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 205 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45058 6004189.32426901 2109462.38505411 37.7724186144331 -122.428913931102 (37.7724186144331, -122.428913931102) 7 9 11 29492 10
108764 103040 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 450X Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758) 7 9 11 28852 10
108824 30684 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3   Permit Number 782764 6004595.56145 2110044.99198 37.7740412965118 -122.427550231668 (37.7740412965118, -122.427550231668) 7 9 11 28852 10
109985 238489 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Lily St 12 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006240.43536 2110240.59642 37.7746712787972 -122.421874219038 (37.7746712787972, -122.421874219038) 7 9 11 28852 10
111215 47002 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 133 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/25/2005 12:00:00 AM     Permit Number 45001 6004750.78049806 2108920.69040717 37.7709630156683 -122.426933212426 (37.7709630156683, -122.426933212426) 7 9 11 28852 10
114112 47007 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 132 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM     Permit Number 45005 6003838.67811356 2108860.89265049 37.7707472098173 -122.430083933065 (37.7707472098173, -122.430083933065) 7 9 11 29492 10
115591 104252 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 6 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
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
119462 237040 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Octavia St 3 : Tree Private 2     5 Width 4ft   6005610.09761 2109720.52403 37.7732077175873 -122.424017694677 (37.7732077175873, -122.424017694677) 7 9 11 28852 10
121411 237020 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 85 Webster St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6004265.72291 2108964.39918 37.7710555904751 -122.428614156631 (37.7710555904751, -122.428614156631) 7 9 11 29492 10
121833 47023 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 533 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45019 6004017.02375654 2109716.65813112 37.7731070321144 -122.429528072193 (37.7731070321144, -122.429528072193) 7 9 11 29492 10
122924 30598 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 66 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1995 12:00:00 AM 12   Permit Number 34565 6004323.10435 2108874.18954 37.7708111439393 -122.428409241587 (37.7708111439393, -122.428409241587) 7 9 11 28852 10
123336 238057 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 413 Lily St 1 : Tree Private 2     5 Width 2ft   6004461.64769 2109967.10473 37.7738198618406 -122.428007911041 (37.7738198618406, -122.428007911041) 7 9 11 28852 10
123557 246593 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 4 : Tree Private 2     2 Width 3ft   6005556.53311 2109286.77456 37.7720137218797 -122.424172128036 (37.7720137218797, -122.424172128036) 7 9 11 28852 10
128297 50757 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1424 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2004 12:00:00 AM   3x3 Permit Number 47297 6000982.34687807 2110734.59068474 37.7757297287638 -122.440098389278 (37.7757297287638, -122.440098389278) 15 5 11 29492 10
131106 237030 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Octavia St 4 : Tree DPW 1     5 Width 4ft   6005725.94025 2109733.85532 37.7732508616652 -122.423617927146 (37.7732508616652, -122.423617927146) 7 9 11 28852 10
131435 237032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Octavia St 6 : Tree Private 2     5 Width 4ft   6005721.49565 2109758.3052 37.7733177442556 -122.423635040324 (37.7733177442556, -122.423635040324) 7 9 11 28852 10
132330 238055 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 438 Lily St 1 : Tree Private 2     9 Width 2ft   6004413.04242 2109984.42979 37.7738646822544 -122.428177279482 (37.7738646822544, -122.428177279482) 7 9 11 28852 10
132418 47031 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
134398 246594 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 5 : Tree Private 2     5 Width 3ft   6005538.63737 2109282.04946 37.7719997374372 -122.424233694733 (37.7719997374372, -122.424233694733) 7 9 11 28852 10
136415 237037 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 129 Octavia St 1 : Tree Private 2     6 Width 4ft   6005605.52362 2109755.39176 37.7733031977155 -122.424035996776 (37.7733031977155, -122.424035996776) 7 9 11 28852 10
136737 237034 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 150 Octavia St 1 : Tree Private 2     4 Width 4ft   6005711.67822 2109842.25548 37.7735476972984 -122.423674970241 (37.7735476972984, -122.423674970241) 7 9 11 28852 10
137716 240126 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.421326188373 (37.7747364652596, -122.421326188373) 7 9 11 28852 10
140690 238486 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Lily St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6006336.80273 2110252.01922 37.7747080772398 -122.421541675834 (37.7747080772398, -122.421541675834) 7 9 11 28852 10
141008 103080 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 445 Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6005464 2110963 37.7766110057417 -122.424611466414 (37.7766110057417, -122.424611466414) 7 9 11 28852 10

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