trees
3,965 rows where qSpecies_id = 70 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13471 | 20029 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
13825 | 87087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | 13 | 6 | 1 | 29490 | 27 | ||
14009 | 125068 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6001667.65947 | 2115975.31483 | 37.7901584138266 | -122.438103221909 | (37.7901584138266, -122.438103221909) | 13 | 6 | 1 | 29490 | 27 | |||
14016 | 249712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 1 | Back Yard : Yard | Tree | Private 2 | 21 | 5999372.04623 | 2116967.23886 | 37.7927511539072 | -122.44611721374 | (37.7927511539072, -122.44611721374) | 13 | 9 | 1 | 29490 | 27 | ||||
14017 | 181325 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1229 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5987669.8168 | 2106894.9032 | 37.7644201395656 | -122.485867286736 | (37.7644201395656, -122.485867286736) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
14423 | 114573 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3621 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | 5997465.48926 | 2115720.33673 | 37.7892184334409 | -122.452623918478 | (37.7892184334409, -122.452623918478) | 11 | 6 | 1 | 54 | 31 | ||
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 | ||||
15068 | 59890 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 12 | Permit Number 19356 | 5998808.9736 | 2111008.0431 | 37.7763565892826 | -122.447636289265 | (37.7763565892826, -122.447636289265) | 15 | 6 | 2 | 29492 | 16 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
17223 | 39975 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
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 | |
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 | |||
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 | ||||
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 | |||
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 | |||
18948 | 51496 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.440129480361 | (37.773809648853, -122.440129480361) | 15 | 5 | 11 | 29492 | 10 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
20338 | 30322 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 720 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | 3 | 1 | 10 | 28860 | 4 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
22388 | 98555 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2360 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991737.8 | 2099355.8 | 37.7439559460975 | -122.471248063337 | (37.7439559460975, -122.471248063337) | 1 | 8 | 4 | 29491 | 40 | |||||
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 | ||||
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 | |||
23222 | 53937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 174 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 12 | 3x4 | Permit Number 9651 | 5993070.40109 | 2114326.65829 | 37.7851389689099 | -122.467728857293 | (37.7851389689099, -122.467728857293) | 11 | 6 | 2 | 54 | 11 | |
23506 | 247295 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1416 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 5999264.8582 | 2108759.0964 | 37.7702075983445 | -122.445897477638 | (37.7702075983445, -122.445897477638) | 15 | 5 | 11 | 29492 | 9 | |||
23626 | 99853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
23786 | 221392 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 19 Short St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000060.07492 | 2104157.98703 | 37.7576194699753 | -122.442816392471 | (37.7576194699753, -122.442816392471) | 2 | 4 | 5 | 28862 | 3 | |||
23841 | 203991 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 61 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995098.20375 | 2093017.11176 | 37.7267452692552 | -122.45916973021 | (37.7267452692552, -122.45916973021) | 9 | 7 | 4 | 28861 | 40 | |||
23875 | 182346 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1518 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5988091.9469 | 2104953.0189 | 37.7591128448339 | -122.484264846545 | (37.7591128448339, -122.484264846545) | 1 | 8 | 3 | 56 | 35 | |||
24079 | 220307 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 114 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003496.4505 | 2105093.35796 | 37.760383083023 | -122.430998769296 | (37.760383083023, -122.430998769296) | 2 | 4 | 5 | 28862 | 3 | |||
24114 | 116895 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
24150 | 203998 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995084.78347 | 2099948.84972 | 37.7457773474569 | -122.459717986591 | (37.7457773474569, -122.459717986591) | 1 | 8 | 4 | 59 | 40 | |||
24174 | 123143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 582 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 5ft | 5992871.73325 | 2111517.59924 | 37.7774145847454 | -122.468211760136 | (37.7774145847454, -122.468211760136) | 11 | 6 | 2 | 54 | 11 | |||
24181 | 203963 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993055.09065 | 2098419.62465 | 37.7414615549015 | -122.466625177429 | (37.7414615549015, -122.466625177429) | 1 | 8 | 4 | 59 | 40 | |||
24289 | 30297 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2734 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | 9 | Permit Number 140 | 6003569.97515 | 2117774.33074 | 37.7952060548567 | -122.43164985595 | (37.7952060548567, -122.43164985595) | 13 | 9 | 1 | 29490 | 27 | ||
24319 | 106459 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 HANCOCK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003462.6 | 2105028.1 | 37.7602019821643 | -122.431111184527 | (37.7602019821643, -122.431111184527) | 2 | 4 | 5 | 28862 | 3 | ||||
24398 | 23561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | 5 | 9 | 1 | 28858 | 32 | |||
24797 | 203992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 402 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995690.08771 | 2093990.03586 | 37.7294506943798 | -122.457193967347 | (37.7294506943798, -122.457193967347) | 9 | 7 | 4 | 28861 | 40 | |||
25335 | 87291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
25412 | 23448 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6006201.29445 | 2118123.14104 | 37.796312596515 | -122.422569862433 | (37.796312596515, -122.422569862433) | 13 | 9 | 10 | 28858 | 32 | |||
25430 | 4171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005278.26135 | 2100471.01085 | 37.7477919952017 | -122.424507508611 | (37.7477919952017, -122.424507508611) | 2 | 4 | 5 | 28859 | 22 | |||
25505 | 188633 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6010969.7403 | 2096191.55002 | 37.7363612864506 | -122.40452535877 | (37.7363612864506, -122.40452535877) | 10 | 3 | 8 | 58 | 1 | ||||
25600 | 188606 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 6014179.73832 | 2105282.17122 | 37.761501079734 | -122.3940631731 | (37.761501079734, -122.3940631731) | 10 | 3 | 8 | 28856 | 29 | |||
25711 | 111769 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 MONTEREY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996319 | 2094654 | 37.7313098799379 | -122.455067728735 | (37.7313098799379, -122.455067728735) | 9 | 7 | 4 | 28861 | 40 | ||||
25724 | 12743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1641 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5990285.06578 | 2114712.64103 | 37.7860375492525 | -122.477393365207 | (37.7860375492525, -122.477393365207) | 11 | 6 | 2 | 55 | 26 | |||
25791 | 124961 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3146 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999036.86973 | 2119627.81105 | 37.800037228206 | -122.447468527859 | (37.800037228206, -122.447468527859) | 13 | 9 | 1 | 57 | 17 | |||
25896 | 187702 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6013770.9191 | 2087051.91118 | 37.7114218243198 | -122.394200759471 | (37.7114218243198, -122.394200759471) | 10 | 3 | 8 | 58 | 1 | |||
26093 | 124678 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3855 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995722.23749 | 2115802.66967 | 37.7893444597434 | -122.458661280755 | (37.7893444597434, -122.458661280755) | 11 | 6 | 1 | 54 | 31 | |||
26266 | 9406 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6001730.26656 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) | 2 | 7 | 5 | 63 | 7 | |||
26287 | 119617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3536 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2016 12:00:00 AM | 3 | 3x10 | 5999214.99092 | 2121000.37655 | 37.8038161003064 | -122.446950987796 | (37.8038161003064, -122.446950987796) | 13 | 9 | 1 | 57 | 17 | ||
26461 | 183598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 116 Escolta Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986616.6908 | 2097250.4752 | 37.7378777278495 | -122.488800725476 | (37.7378777278495, -122.488800725476) | 1 | 8 | 3 | 29491 | 35 | |||
26516 | 123199 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 519 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993106.45198 | 2111928.10825 | 37.7785552848638 | -122.467429656315 | (37.7785552848638, -122.467429656315) | 11 | 6 | 2 | 54 | 11 | |||
26679 | 124855 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001720.89506 | 2121441.74849 | 37.805170835422 | -122.438310816889 | (37.805170835422, -122.438310816889) | 13 | 9 | 1 | 57 | 17 | |||
26794 | 181716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1213 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5987666.2736 | 2107069.7049 | 37.7648998904527 | -122.485892372819 | (37.7648998904527, -122.485892372819) | 1 | 8 | 3 | 56 | 35 | |||
26922 | 40094 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||
27095 | 104422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2362 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 5999509.01294 | 2120174.0716 | 37.8015640827681 | -122.445874046945 | (37.8015640827681, -122.445874046945) | 13 | 9 | 1 | 57 | 17 | |||
27206 | 66038 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 616 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 14 | Permit Number 29076 | 6004557.2069 | 2110631.459 | 37.7756494221228 | -122.427724700841 | (37.7756494221228, -122.427724700841) | 7 | 9 | 11 | 28852 | 10 | ||
27228 | 124845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001817.73408 | 2121573.58628 | 37.8055383343822 | -122.437985143623 | (37.8055383343822, -122.437985143623) | 13 | 9 | 1 | 57 | 17 | |||
27408 | 124833 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001778.79024 | 2121390.34711 | 37.8050329936375 | -122.438106779619 | (37.8050329936375, -122.438106779619) | 13 | 9 | 1 | 57 | 17 | |||
27527 | 51878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2251 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 14 | Permit Number 48095 | 6002306.75433 | 2116015.71739 | 37.790305674209 | -122.435894898847 | (37.790305674209, -122.435894898847) | 13 | 9 | 1 | 29490 | 27 | ||
27626 | 48436 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | Permit Number 45813 | 5993118.67686511 | 2111697.80509175 | 37.7779236404027 | -122.467370615227 | (37.7779236404027, -122.467370615227) | 11 | 6 | 2 | 54 | 11 | |||
27679 | 175034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010467.70028 | 2086649.87132 | 37.7101337451556 | -122.40558929631 | (37.7101337451556, -122.40558929631) | 9 | 7 | 8 | 309 | 39 | |||
27754 | 246868 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3090x Market St | 1 | Median : Yard | Tree | DPW 1 | 32 | 5999955.5697 | 2105338.29244 | 37.760854339489 | -122.443262585704 | (37.760854339489, -122.443262585704) | 15 | 5 | 5 | 28862 | 3 | ||||
27780 | 250630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5987115.47488 | 2114730.85404 | 37.7859031348758 | -122.488360488171 | (37.7859031348758, -122.488360488171) | 11 | 6 | 1 | 55 | 33 | |||
27839 | 123332 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 737 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5994713.86391 | 2110546.24566 | 37.7748537255052 | -122.461768822817 | (37.7748537255052, -122.461768822817) | 11 | 6 | 2 | 54 | 11 |
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) );