trees
3,965 rows where qSpecies_id = 70 sorted by PlantDate
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14302 | 175030 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010584.6901 | 2086918.22746 | 37.710877138233 | -122.405203838782 | (37.710877138233, -122.405203838782) | 9 | 7 | 8 | 309 | 39 | |||
14404 | 261203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
14483 | 22142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
14540 | 125028 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1454 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002238.36811 | 2121596.51915 | 37.8056252134011 | -122.436531126017 | (37.8056252134011, -122.436531126017) | 13 | 9 | 1 | 57 | 17 | |||
14545 | 30309 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
14554 | 205138 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1998 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993815.52591 | 2101897.64726 | 37.7510551789624 | -122.464248318725 | (37.7510551789624, -122.464248318725) | 1 | 8 | 4 | 29491 | 12 | |||
14555 | 247858 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Bradford St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.409495368525 | (37.7414618274161, -122.409495368525) | 10 | 7 | 7 | 28859 | 2 | ||||
14773 | 203979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992248.70603 | 2096739.03136 | 37.7368005027325 | -122.469291057549 | (37.7368005027325, -122.469291057549) | 1 | 8 | 4 | 59 | 40 | |||
14836 | 221387 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 701 Church St | 38 | Front Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6004318.36502 | 2104792.37844 | 37.7596032026492 | -122.428134698373 | (37.7596032026492, -122.428134698373) | 2 | 4 | 5 | 28862 | 3 | |||
14952 | 124990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2354 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999518.65691 | 2120176.7884 | 37.8015720930274 | -122.44584087006 | (37.8015720930274, -122.44584087006) | 13 | 9 | 1 | 57 | 17 | |||
15006 | 6568 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017234.1596238 | 2097288.6286052 | 37.7397217505579 | -122.382942754401 | (37.7397217505579, -122.382942754401) | 10 | 3 | 8 | 58 | 1 | |||
15072 | 246185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999538.3824 | 2108204.1634 | 37.7686995067752 | -122.444911465275 | (37.7686995067752, -122.444911465275) | 15 | 5 | 11 | 29492 | 9 | |||
15095 | 182345 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1522 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x8 | 5988118 | 2104920 | 37.7590237008279 | -122.484172322146 | (37.7590237008279, -122.484172322146) | 1 | 8 | 3 | 56 | 35 | |||
15097 | 125078 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2402 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6002281.85498 | 2116525.22121 | 37.7917032260602 | -122.4360175223 | (37.7917032260602, -122.4360175223) | 13 | 9 | 1 | 29490 | 27 | |||
15115 | 203925 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799X 12th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5992470.02129 | 2103495.15392 | 37.755363873152 | -122.469017416317 | (37.755363873152, -122.469017416317) | 1 | 8 | 4 | 56 | 12 | |||
15118 | 247553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000067.12392 | 2108379.27144 | 37.7692104712049 | -122.443095172401 | (37.7692104712049, -122.443095172401) | 15 | 5 | 11 | 29492 | 9 | |||
15187 | 6707 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017570.5024 | 2096779.609 | 37.7383426628708 | -122.381744418894 | (37.7383426628708, -122.381744418894) | 10 | 3 | 8 | 58 | 1 | |||
15254 | 260460 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | ||||
15359 | 124880 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3820 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5996409.41763 | 2115616.90715 | 37.7888738770624 | -122.456270294343 | (37.7888738770624, -122.456270294343) | 11 | 6 | 1 | 54 | 31 | |||
15453 | 103382 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3199X JACKSON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999158 | 2116301 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | 13 | 6 | 1 | 29490 | 31 | |||||
15463 | 20023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
15711 | 20018 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
15739 | 23509 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2620 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005816.48256 | 2119432.12103 | 37.7998850066476 | -122.423994524448 | (37.7998850066476, -122.423994524448) | 13 | 9 | 1 | 28858 | 32 | |||
15872 | 203996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5996332.32562 | 2094668.87187 | 37.7313514789886 | -122.455022734117 | (37.7313514789886, -122.455022734117) | 9 | 7 | 4 | 59 | 40 | |||
16020 | 96530 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
16079 | 20022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
16200 | 103940 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | |||||
16264 | 111321 | Section 806 (d) 5 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6010185.88551 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | 9 | 7 | 8 | 309 | 39 | ||||
16375 | 122239 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 103 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5990148.76857 | 2114703.45142 | 37.7860044077166 | -122.477864239619 | (37.7860044077166, -122.477864239619) | 11 | 6 | 2 | 55 | 26 | |||
16444 | 220308 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003435.7388 | 2105046.58076 | 37.7602512037428 | -122.431205403824 | (37.7602512037428, -122.431205403824) | 2 | 4 | 5 | 28862 | 3 | |||
16567 | 175055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989631.25858 | 2089762.2141 | 37.7174923263774 | -122.477830757993 | (37.7174923263774, -122.477830757993) | 1 | 8 | 4 | 64 | 14 | |||
16703 | 99560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1142 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6011556.95658 | 2119287.39483 | 37.7998100414445 | -122.404120029814 | (37.7998100414445, -122.404120029814) | 3 | 1 | 10 | 308 | 23 | ||||
16737 | 5399 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6004915.02967 | 2106451.33313 | 37.764192039253 | -122.426189239948 | (37.764192039253, -122.426189239948) | 8 | 4 | 5 | 28859 | 19 | |||
16802 | 52926 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 48909 | 5988008.14773 | 2114828.39565 | 37.7862229995097 | -122.485279285217 | (37.7862229995097, -122.485279285217) | 11 | 6 | 1 | 55 | 33 | |
16841 | 123290 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 490 06th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5994075.65584 | 2112255.71235 | 37.779510703816 | -122.464100624725 | (37.779510703816, -122.464100624725) | 11 | 6 | 2 | 54 | 11 | |||
16854 | 14553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | 15 | 5 | 11 | 29492 | 16 | |||
16921 | 125192 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6003488.35981 | 2118026.85016 | 37.7958947817809 | -122.431950297892 | (37.7958947817809, -122.431950297892) | 13 | 9 | 1 | 57 | 17 | |||
17126 | 45658 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1330 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | |||
17202 | 132596 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3437 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 5ft | 5998295.07475 | 2115506.79516 | 37.7886796028307 | -122.449738271914 | (37.7886796028307, -122.449738271914) | 13 | 6 | 1 | 54 | 31 | |||
17223 | 39975 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
17306 | 203240 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 3ft | 5994884.38137 | 2099419.15994 | 37.7443114255431 | -122.460372570763 | (37.7443114255431, -122.460372570763) | 1 | 8 | 4 | 59 | 40 | |||
17330 | 203948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5991355.40682 | 2098983.74406 | 37.7429122494956 | -122.472543158936 | (37.7429122494956, -122.472543158936) | 1 | 8 | 4 | 29491 | 40 | |||
17547 | 203960 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 317 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5993052.38285 | 2099661.64456 | 37.7448716708006 | -122.466724802526 | (37.7448716708006, -122.466724802526) | 1 | 8 | 4 | 29491 | 40 | |||
17569 | 98514 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||||
17638 | 20026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
17687 | 95675 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2207 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6x6 | 6001981.9652 | 2114296.4072 | 37.7855664339568 | -122.436895509024 | (37.7855664339568, -122.436895509024) | 13 | 6 | 11 | 29490 | 13 | |||
17786 | 258887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | ||||
17802 | 203691 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5994228.79771 | 2106016.63225 | 37.7623886638276 | -122.463118026482 | (37.7623886638276, -122.463118026482) | 1 | 5 | 11 | 56 | 12 | |||
17877 | 101023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3024 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999465 | 2119192 | 37.7988650643156 | -122.445955676486 | (37.7988650643156, -122.445955676486) | 13 | 9 | 1 | 57 | 17 | ||||
17965 | 220232 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 437 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 5998506.37363 | 2106647.05925 | 37.764365140767 | -122.448368942583 | (37.764365140767, -122.448368942583) | 15 | 5 | 11 | 29492 | 9 | |||
18026 | 175051 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991233.90488 | 2088989.0818 | 37.7154623775575 | -122.472234874046 | (37.7154623775575, -122.472234874046) | 1 | 8 | 4 | 64 | 14 | |||
18268 | 262388 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1525 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6016246.49948 | 2097351.8889 | 37.739840829559 | -122.38636210374 | (37.739840829559, -122.38636210374) | 10 | 3 | 8 | 58 | 1 | |||||
18286 | 124768 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3030 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5999457.57205 | 2119269.23943 | 37.799076718977 | -122.445986937943 | (37.799076718977, -122.445986937943) | 13 | 9 | 1 | 57 | 17 | |||
18623 | 99145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 302X Pacheco St | 29 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
18624 | 184510 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1975 42nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5983188.0663 | 2101709.4842 | 37.7499202536606 | -122.500984645445 | (37.7499202536606, -122.500984645445) | 1 | 8 | 3 | 29491 | 35 | |||
18796 | 19809 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY23 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18924 | 108959 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 447 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990585.11051 | 2112333.61073 | 37.7795227987613 | -122.476181473209 | (37.7795227987613, -122.476181473209) | 11 | 6 | 2 | 55 | 26 | |||
18941 | 264761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 240 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007356 | 2087104 | 37.7112061971181 | -122.416376123926 | (37.7112061971181, -122.416376123926) | 9 | 7 | 8 | 309 | 39 | ||||
19219 | 18871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003913.28197 | 2115924.59754 | 37.7901466122144 | -122.430329924961 | (37.7901466122144, -122.430329924961) | 13 | 9 | 1 | 29490 | 27 | |||
19317 | 221374 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 653 Sanchez St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003693.10013 | 2104500.87823 | 37.7587674158898 | -122.430276378964 | (37.7587674158898, -122.430276378964) | 2 | 4 | 5 | 28862 | 3 | |||
19351 | 125032 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1490 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002182.39111 | 2121589.19488 | 37.8056019218535 | -122.436724317478 | (37.8056019218535, -122.436724317478) | 13 | 9 | 1 | 57 | 17 | |||
19454 | 233191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999741.22032 | 2107224.57416 | 37.7660213745188 | -122.444139467874 | (37.7660213745188, -122.444139467874) | 15 | 5 | 5 | 29492 | 9 | |||
19477 | 203874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5993391.13026 | 2089210.06391 | 37.7161937512299 | -122.464794638879 | (37.7161937512299, -122.464794638879) | 9 | 8 | 6 | 64 | 24 | |||
19486 | 186864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.7204 | 2096355.2343 | 37.7353368988439 | -122.493630408308 | (37.7353368988439, -122.493630408308) | 1 | 8 | 3 | 29491 | 35 | |||
19569 | 19966 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
19734 | 24211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
19803 | 7872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006017.92474 | 2113680.12204 | 37.7841028269903 | -122.422888431641 | (37.7841028269903, -122.422888431641) | 7 | 9 | 11 | 28858 | 41 | |||
19888 | 125117 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3170 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5999039.29441 | 2116309.03861 | 37.7909249024118 | -122.44722115226 | (37.7909249024118, -122.44722115226) | 13 | 6 | 1 | 29490 | 31 | |||
19890 | 3695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | 10 | 3 | 8 | 58 | 1 | |||
19982 | 142665 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 87 Vandewater St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008980.7551 | 2121289.4217 | 37.8051628283357 | -122.413176321677 | (37.8051628283357, -122.413176321677) | 3 | 1 | 10 | 308 | 23 | |||
20079 | 12739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5990329.44242 | 2114713.68905 | 37.7860430016299 | -122.477239912272 | (37.7860430016299, -122.477239912272) | 11 | 6 | 2 | 55 | 26 | |||
20113 | 124934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 313 Maple St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996638.30422 | 2115205.01677 | 37.7877560728439 | -122.455448601768 | (37.7877560728439, -122.455448601768) | 11 | 6 | 1 | 54 | 31 | |||
20167 | 220228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998615.97135 | 2106084.29487 | 37.7628261965949 | -122.447949355798 | (37.7628261965949, -122.447949355798) | 15 | 5 | 11 | 29492 | 9 | |||
20221 | 187212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 0ft | 5984988.5085 | 2098705.0047 | 37.741776320928 | -122.494537260078 | (37.741776320928, -122.494537260078) | 1 | 8 | 3 | 29491 | 35 | |||
20230 | 203896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5990596.84308 | 2090479.69294 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | 9 | 8 | 4 | 64 | 40 | |||
20303 | 101420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000374.3516 | 2116185.0207 | 37.7906605745677 | -122.442593016179 | (37.7906605745677, -122.442593016179) | 13 | 6 | 1 | 29490 | 27 | ||||
20332 | 203978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992223.47194 | 2096717.87979 | 37.7367409676228 | -122.469376762928 | (37.7367409676228, -122.469376762928) | 1 | 8 | 4 | 59 | 40 | |||
20381 | 186821 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 105 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | |||
20406 | 188744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6014566.93251 | 2086961.44697 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | 10 | 3 | 8 | 58 | 1 | |||
20469 | 114842 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2670 LEAVENWORTH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007398 | 2121652 | 37.8060693936166 | -122.418679378695 | (37.8060693936166, -122.418679378695) | 5 | 1 | 1 | 308 | 23 | ||||
20506 | 250806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 279 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5986182.48717 | 2114056.18318 | 37.7839962033991 | -122.491538643706 | (37.7839962033991, -122.491538643706) | 11 | 6 | 1 | 55 | 33 | |||
20526 | 125225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1606 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6005725.27471 | 2118266.64899 | 37.7966797667037 | -122.424227203437 | (37.7966797667037, -122.424227203437) | 13 | 9 | 1 | 28858 | 17 | |||
20738 | 18077 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5999820.6048 | 2114741.0687 | 37.7866642791044 | -122.444405127725 | (37.7866642791044, -122.444405127725) | 15 | 6 | 1 | 29490 | 31 | |||
20826 | 203829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200x Terrace Dr | 41 | Median : Yard | Tree | DPW 1 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | 1 | 8 | 4 | 59 | 40 | ||||
20901 | 181396 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984914.2437 | 2104590.3992 | 37.757931655251 | -122.495227954147 | (37.757931655251, -122.495227954147) | 1 | 8 | 3 | 56 | 35 | |||
20956 | 188641 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011091.32099 | 2096197.80071 | 37.7363852434915 | -122.404105441008 | (37.7363852434915, -122.404105441008) | 10 | 3 | 8 | 58 | 1 | ||||
21150 | 187379 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985060.734 | 2100052.5124 | 37.7454804393236 | -122.494386838151 | (37.7454804393236, -122.494386838151) | 1 | 8 | 3 | 29491 | 35 | |||
21164 | 220127 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 6ft | 6004864.42666 | 2105831.25856 | 37.762486601794 | -122.426320110198 | (37.762486601794, -122.426320110198) | 8 | 4 | 5 | 28859 | 3 | |||
21202 | 124066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Funston Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 4ft | 5991886.30964 | 2111587.55564 | 37.7775497038674 | -122.471625731033 | (37.7775497038674, -122.471625731033) | 11 | 6 | 2 | 54 | 11 | |||
21220 | 182980 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 20th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 0ft | 5990206.2576 | 2097911.7147 | 37.739902151809 | -122.47643826121 | (37.739902151809, -122.47643826121) | 1 | 8 | 3 | 29491 | 35 | |||
21247 | 203924 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 828 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990829.70497 | 2101134.74222 | 37.7487878900543 | -122.474517815648 | (37.7487878900543, -122.474517815648) | 1 | 8 | 4 | 29491 | 12 | |||
21344 | 220226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Carmel St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5998587.28318 | 2105401.77798 | 37.7609505363472 | -122.447999434541 | (37.7609505363472, -122.447999434541) | 15 | 5 | 11 | 29492 | 12 | |||
21431 | 124977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3751 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999590.28353 | 2121474.47758 | 37.8051392872022 | -122.445686385433 | (37.8051392872022, -122.445686385433) | 13 | 9 | 1 | 57 | 17 | |||
21435 | 1649 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1357X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6005247.73797 | 2100448.62508 | 37.7477288052344 | -122.424611464856 | (37.7477288052344, -122.424611464856) | 2 | 7 | 5 | 28859 | 22 | |||
21465 | 104273 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3675 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997210.1 | 2115656.5 | 37.7890285184352 | -122.453502918425 | (37.7890285184352, -122.453502918425) | 11 | 6 | 1 | 54 | 31 | ||||
21537 | 220207 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 108 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008584.43652 | 2099064.66412 | 37.7441166332796 | -122.41297546067 | (37.7441166332796, -122.41297546067) | 2 | 7 | 7 | 28859 | 2 | |||
21553 | 6948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 583 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004650.95912 | 2110501.84562 | 37.7752988382968 | -122.427391153284 | (37.7752988382968, -122.427391153284) | 7 | 9 | 11 | 28852 | 10 | |||
21562 | 220223 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Carmel St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5998639.38293 | 2105406.49302 | 37.7609664606466 | -122.447819584529 | (37.7609664606466, -122.447819584529) | 15 | 5 | 11 | 29492 | 12 | |||
21595 | 26448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1817 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001669.86946 | 2112366.99146 | 37.7802510063553 | -122.437837026039 | (37.7802510063553, -122.437837026039) | 15 | 5 | 11 | 29490 | 41 | |||
21622 | 175038 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 137 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010492.95199 | 2086616.94014 | 37.7100447347569 | -122.405499703176 | (37.7100447347569, -122.405499703176) | 9 | 7 | 8 | 309 | 39 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );