trees
3,965 rows where qSpecies_id = 70 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15635 | 5803 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 218X Cashmere St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2020 12:00:00 AM | 3 | 3X4 | 6016111.4085 | 2096200.72161 | 37.7366724788363 | -122.386748939219 | (37.7366724788363, -122.386748939219) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 16079 | 20022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 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 | |||
| 16669 | 66481 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1991 12:00:00 AM | 17 | Permit Number 29638 | 6002649.70784 | 2117838.97461 | 37.7953313448215 | -122.434838746712 | (37.7953313448215, -122.434838746712) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | |||
| 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 | |||
| 17456 | 38562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 19338 | 65714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1990 12:00:00 AM | 16 | Permit Number 28646 | 5990406.78353 | 2113406.96053 | 37.7824595769169 | -122.476876823137 | (37.7824595769169, -122.476876823137) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 19963 | 55630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.65482 | 37.7968976958139 | -122.403523149777 | (37.7968976958139, -122.403523149777) | 3 | 1 | 10 | 308 | 4 | ||
| 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 | |||
| 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 | ||||
| 21042 | 67608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 261 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31186 | 5988028.8714 | 2114260.18154 | 37.7846640526933 | -122.485165880985 | (37.7846640526933, -122.485165880985) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 21198 | 173686 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2211 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2017 12:00:00 AM | 3 | 6011691 | 2097676 | 37.7404775538831 | -122.402135979323 | (37.7404775538831, -122.402135979323) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 21261 | 55934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1973 12:00:00 AM | 9 | Permit Number 11998 | 5986719.3111 | 2097252.7279 | 37.7378899014651 | -122.488446087215 | (37.7378899014651, -122.488446087215) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 | |||
| 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 | |||
| 21920 | 184111 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1604 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5986875.3953 | 2104311.06 | 37.7572792915924 | -122.488425026161 | (37.7572792915924, -122.488425026161) | 1 | 8 | 3 | 56 | 35 | |||
| 21969 | 125176 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2519 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001330.49234 | 2117251.0663 | 37.7936421149431 | -122.439361275412 | (37.7936421149431, -122.439361275412) | 13 | 9 | 1 | 29490 | 27 | |||
| 22035 | 185597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5986575.4427 | 2100993.2848 | 37.748152076203 | -122.489218440489 | (37.748152076203, -122.489218440489) | 1 | 8 | 3 | 29491 | 35 | |||
| 22058 | 5492 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 719 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 8 | 6005040.75383 | 2104151.1903 | 37.7578834965409 | -122.425590680889 | (37.7578834965409, -122.425590680889) | 2 | 4 | 5 | 28859 | 19 | |||
| 22096 | 124305 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 169 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5996209.82243 | 2113206.80783 | 37.7822449293206 | -122.456786484191 | (37.7822449293206, -122.456786484191) | 11 | 6 | 1 | 54 | 31 | |||
| 22211 | 8278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X Galvez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6015786.61194 | 2097763.1602 | 37.7409446293456 | -122.387980907347 | (37.7409446293456, -122.387980907347) | 10 | 3 | 8 | 58 | 1 | |||
| 22212 | 246119 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5998881.3947 | 2108355.4265 | 37.7690773199884 | -122.447194813606 | (37.7690773199884, -122.447194813606) | 15 | 5 | 11 | 29492 | 9 | |||
| 22235 | 125135 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2655 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000111.60795 | 2117732.00363 | 37.7948932023106 | -122.44361327005 | (37.7948932023106, -122.44361327005) | 13 | 9 | 1 | 57 | 27 | |||
| 22272 | 5913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1245 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004490.90647 | 2112892.55275 | 37.7818540774754 | -122.428115221825 | (37.7818540774754, -122.428115221825) | 7 | 9 | 11 | 29490 | 41 | |||
| 22279 | 187708 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 6013663.58022 | 2087013.01188 | 37.7113090475516 | -122.394569030961 | (37.7113090475516, -122.394569030961) | 10 | 3 | 8 | 58 | 1 | |||
| 22316 | 185668 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 5984929.7381 | 2100287.489 | 37.7461179540332 | -122.494857116456 | (37.7461179540332, -122.494857116456) | 1 | 8 | 3 | 29491 | 35 | |||
| 22336 | 98569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 22338 | 203950 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991063.90943 | 2098465.7038 | 37.7414729672935 | -122.473513287329 | (37.7414729672935, -122.473513287329) | 1 | 8 | 4 | 29491 | 40 | |||
| 22371 | 17865 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/31/2016 12:00:00 AM | 18 | 4X4 | 6003789.962559 | 2115237.891116 | 37.7882541043801 | -122.430707576303 | (37.7882541043801, -122.430707576303) | 13 | 9 | 11 | 29490 | 27 | ||
| 22416 | 38478 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 21 | Permit Number 40477 | 5987978.37889 | 2115306.2666 | 37.7875333623487 | -122.485417356275 | (37.7875333623487, -122.485417356275) | 11 | 6 | 1 | 55 | 33 | ||
| 22458 | 125100 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3298 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999060.86441 | 2115983.22168 | 37.7900315275801 | -122.4471230632 | (37.7900315275801, -122.4471230632) | 13 | 6 | 1 | 29490 | 31 | |||
| 22625 | 188658 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | 10 | 3 | 8 | 58 | 1 | ||||
| 22704 | 188665 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 37 | 6011669.71313 | 2097723.45025 | 37.7406066539877 | -122.402212916691 | (37.7406066539877, -122.402212916691) | 10 | 3 | 8 | 58 | 1 | ||||
| 22707 | 184072 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984928.5463 | 2103997.684 | 37.7563050611127 | -122.495134783659 | (37.7563050611127, -122.495134783659) | 1 | 8 | 3 | 56 | 35 | |||
| 22759 | 220218 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004730.92104 | 2103164.34461 | 37.7551563384039 | -122.426591942883 | (37.7551563384039, -122.426591942883) | 2 | 4 | 5 | 28862 | 22 | |||
| 22959 | 124866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 12 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001683.07545 | 2121358.73098 | 37.8049407402829 | -122.438435744435 | (37.8049407402829, -122.438435744435) | 13 | 9 | 1 | 57 | 17 | |||
| 22983 | 125092 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2145 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5999827.24336 | 2116322.83843 | 37.7910077839349 | -122.444495883591 | (37.7910077839349, -122.444495883591) | 13 | 6 | 1 | 29490 | 27 |
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) );