Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9853 | 9853 | 173717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 614 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004584.0 | 2110624.0 | 37.775630457098295 | -122.427631485331 | (37.7756304570983, -122.427631485331) | ||||
| 9957 | 9957 | 173686 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2211 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 3 | 6011691.0 | 2097676.0 | 37.740477553883096 | -122.402135979323 | (37.7404775538831, -122.402135979323) | |||
| 9962 | 9962 | 173753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1140 Lawton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990653.0 | 2104548.0 | 37.7581495573033 | -122.475378025252 | (37.7581495573033, -122.475378025252) | |||||
| 9971 | 9971 | 121203 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3041 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778902 | 5999408.34577 | 2119299.99025 | 37.7991583414361 | -122.446159489987 | (37.7991583414361, -122.446159489987) | ||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10031 | 10031 | 121152 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 10032 | 10032 | 122739 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 10040 | 10040 | 122740 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4300 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168.0 | 2102360.0 | 37.752745732689206 | -122.43885590136401 | (37.7527457326892, -122.438855901364) | |
| 10078 | 10078 | 121575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57-59 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | 6x8 | Permit Number 779439 | 5991428.0 | 2114866.0 | 37.786524881607 | -122.473450350287 | (37.786524881607, -122.473450350287) | |
| 10124 | 10124 | 173862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999618.0 | 2107794.0 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | ||||
| 10162 | 10162 | 173888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Vasquez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995783.0 | 2100209.0 | 37.7465317821399 | -122.457322486502 | (37.7465317821399, -122.457322486502) | |||||
| 10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
| 10422 | 10422 | 100386 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989668.805 | 2104235.219 | 37.7572336462205 | -122.478758883384 | (37.7572336462205, -122.478758883384) | |||
| 10531 | 10531 | 120538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | |||
| 10808 | 10808 | 100387 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989667.3817 | 2104248.5033 | 37.75727003871479 | -122.47876477719299 | (37.7572700387148, -122.478764777193) | |||
| 10853 | 10853 | 102802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.764141382947706 | -122.485851660773 | (37.7641413829477, -122.485851660773) | |||
| 10888 | 10888 | 113348 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | |||
| 10984 | 10984 | 105220 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1443 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5987410.3461 | 2105455.8349 | 37.760453729777396 | -122.48665903725299 | (37.7604537297774, -122.486659037253) | |||
| 11006 | 11006 | 120949 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2750 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5985472.8534 | 2102314.8398 | 37.7517162845821 | -122.493128443109 | (37.7517162845821, -122.493128443109) | |||
| 11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 11670 | 11670 | 102444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.715798995606704 | -122.436645469419 | (37.7157989956067, -122.436645469419) | |||
| 12213 | 12213 | 115358 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 353 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778572 | 6001795.91538 | 2087927.53278 | 37.713153200931295 | -122.435652007258 | (37.7131532009313, -122.435652007258) | |
| 12444 | 12444 | 27070 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 801 Silver Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 4x15 | 6006926.95376 | 2093626.2596599997 | 37.7290907946921 | -122.41832116401699 | (37.7290907946921, -122.418321164017) | ||
| 12564 | 12564 | 115359 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x6 | 6001770.67381 | 2087944.68785 | 37.7131988712114 | -122.43574047716001 | (37.7131988712114, -122.43574047716) | |||
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 13458 | 13458 | 24144 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.38463593799999 | (37.7338509755474, -122.384635938) | |||
| 13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
| 13509 | 13509 | 106317 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1133 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 4x4 | 6012240.80146 | 2103138.9754 | 37.7555083807236 | -122.400618637234 | (37.7555083807236, -122.400618637234) | |||
| 13761 | 13761 | 6553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x8 | 6017462.04156 | 2097126.1556099998 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | |||
| 14058 | 14058 | 6836 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | ||
| 14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
| 14724 | 14724 | 28654 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.5251799999 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | ||
| 15459 | 15459 | 6794 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.458330001 | 2097207.3634599997 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | ||
| 15924 | 15924 | 122795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | |||
| 15970 | 15970 | 104641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009525.15876 | 2111682.0778200002 | 37.7788139428406 | -122.410613470452 | (37.7788139428406, -122.410613470452) | |||
| 17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
| 17561 | 17561 | 22565 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 231 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001358.74635 | 2097645.7360799997 | 37.7398123322633 | -122.437858639569 | (37.7398123322633, -122.437858639569) | |||
| 17865 | 17865 | 99661 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
| 18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 18154 | 18154 | 111228 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
| 18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
| 18488 | 18488 | 98514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328001 | (37.7238271478872, -122.45935081328) | ||||
| 18892 | 18892 | 116488 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2149 LYON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999319.0 | 2116238.0 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | |||||
| 19122 | 19122 | 103382 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3199X JACKSON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999158.0 | 2116301.0 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | |||||
| 19250 | 19250 | 7648 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3303 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1999 12:00:00 AM | 3 | 4x4 | 6008513.3556 | 2099374.88287 | 37.7449644349621 | -122.413243176241 | (37.7449644349621, -122.413243176241) | ||
| 19616 | 19616 | 116162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2569 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000631.0 | 2118874.0 | 37.7980584318084 | -122.44189810937901 | (37.7980584318084, -122.441898109379) | ||||
| 19654 | 19654 | 104292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | |||||
| 19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 19698 | 19698 | 117036 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2220x SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 19747 | 19747 | 118326 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3200 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999426.0 | 2115708.0 | 37.7892966967134 | -122.44583992728799 | (37.7892966967134, -122.445839927288) | ||||
| 20368 | 20368 | 22570 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 285 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6001210.73338 | 2097821.1569 | 37.7402855789128 | -122.438382969513 | (37.7402855789128, -122.438382969513) | |||
| 20374 | 20374 | 6568 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017234.1596238 | 2097288.6286052 | 37.7397217505579 | -122.382942754401 | (37.7397217505579, -122.382942754401) | |||
| 20386 | 20386 | 101023 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3024 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999465.0 | 2119192.0 | 37.7988650643156 | -122.445955676486 | (37.7988650643156, -122.445955676486) | ||||
| 20504 | 20504 | 10495 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | |||
| 20602 | 20602 | 14575 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1134 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | 18 | 4X4 | 5999433.6283 | 2108924.6352 | 37.770671761343706 | -122.445325609236 | (37.7706717613437, -122.445325609236) | ||
| 20617 | 20617 | 87007 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 20788 | 20788 | 14571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | |||
| 21099 | 21099 | 1649 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1357X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005247.73797 | 2100448.62508 | 37.7477288052344 | -122.424611464856 | (37.7477288052344, -122.424611464856) | |||
| 21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | |||
| 22181 | 22181 | 9403 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 461 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1998 12:00:00 AM | 6 | 3x3 | 6001657.4794 | 2097610.8780099996 | 37.7397336029134 | -122.43682325371599 | (37.7397336029134, -122.436823253716) | ||
| 22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 22309 | 22309 | 248978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987396.0 | 2097538.0 | 37.738712644317204 | -122.486127408072 | (37.7387126443172, -122.486127408072) | ||||
| 22364 | 22364 | 249565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005937.376069999 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | |||
| 23402 | 23402 | 123384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 03rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5995024.54572 | 2110548.53973 | 37.7748779041184 | -122.460694283234 | (37.7748779041184, -122.460694283234) | |||
| 23416 | 23416 | 247236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Haight St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | |||
| 23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
| 23476 | 23476 | 187768 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1442 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6016135.99542 | 2097500.7582799997 | 37.740243477167 | -122.3867545627 | (37.740243477167, -122.3867545627) | |||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 23506 | 23506 | 203697 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1612 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5993725.685740001 | 2104505.50158 | 37.7582104972207 | -122.464748349861 | (37.7582104972207, -122.464748349861) | |||
| 23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
| 23512 | 23512 | 49013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.2569999998 | 37.8006524480994 | -122.44555118855601 | (37.8006524480994, -122.445551188556) | ||
| 23529 | 23529 | 185014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985039.8071 | 2096458.9756 | 37.73561232989871 | -122.494194380975 | (37.7356123298987, -122.494194380975) | |||
| 23624 | 23624 | 221399 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 38 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003390.07716 | 2108570.1218 | 37.769923406978705 | -122.431614888542 | (37.7699234069787, -122.431614888542) | |||
| 23674 | 23674 | 125034 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1467 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002193.9847099995 | 2121545.09547 | 37.8054814954333 | -122.436681037594 | (37.8054814954333, -122.436681037594) | |||
| 23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
| 23878 | 23878 | 106648 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1293 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5987685.171 | 2106501.0088 | 37.763339508501396 | -122.48578526928301 | (37.7633395085014, -122.485785269283) | ||||
| 23882 | 23882 | 125253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Reed St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008205.34429 | 2117069.05453 | 37.793531190756205 | -122.41556074355101 | (37.7935311907562, -122.415560743551) | ||||
| 23967 | 23967 | 184113 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2345 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5986890.7956 | 2104347.1916 | 37.7573793976552 | -122.4883744219 | (37.7573793976552, -122.4883744219) | |||
| 23976 | 23976 | 68013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.9581699995 | 2120820.4060400003 | 37.803337026932894 | -122.446024564694 | (37.8033370269329, -122.446024564694) | ||
| 24149 | 24149 | 125090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3075 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6000094.70412 | 2115753.61769 | 37.789460110053795 | -122.44352957555 | (37.7894601100538, -122.44352957555) | |||
| 24253 | 24253 | 123529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2850 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5994479.78836 | 2110203.1842799997 | 37.7738982925338 | -122.462553643166 | (37.7738982925338, -122.462553643166) | |||
| 24278 | 24278 | 183048 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 20th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990217.9332 | 2097368.8862 | 37.7384123615974 | -122.47635825040301 | (37.7384123615974, -122.476358250403) | |||
| 24305 | 24305 | 187754 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.37985934635799 | (37.728760777668, -122.379859346358) | ||||
| 24361 | 24361 | 124790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1650 Green St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005095.79493 | 2118523.91802 | 37.7973505989009 | -122.42642367433099 | (37.7973505989009, -122.426423674331) | |||
| 24378 | 24378 | 124854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Casa Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6001534.02589 | 2121572.74926 | 37.8055198982766 | -122.438966893034 | (37.8055198982766, -122.438966893034) | |||
| 24384 | 24384 | 203942 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5991551.86269 | 2098375.2612400004 | 37.7412528807104 | -122.47181953924299 | (37.7412528807104, -122.471819539243) | |||
| 24386 | 24386 | 125162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2667 Vallejo St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6000844.12478 | 2117536.98502 | 37.7943994826029 | -122.441064665996 | (37.7943994826029, -122.441064665996) | |||
| 24483 | 24483 | 175030 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Desmond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010584.6901 | 2086918.2274599997 | 37.710877138233 | -122.405203838782 | (37.710877138233, -122.405203838782) | |||
| 24500 | 24500 | 203904 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357001 | (37.7272777533559, -122.47464379357) | |||
| 24548 | 24548 | 184805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984688.1718 | 2105711.6678 | 37.7609971073609 | -122.496092516316 | (37.7609971073609, -122.496092516316) | |||
| 24641 | 24641 | 203805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 4ft | 5993891.16391 | 2100082.05221 | 37.7460743755414 | -122.463854985838 | (37.7460743755414, -122.463854985838) | |||
| 24674 | 24674 | 7916 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1225 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6005951.06937 | 2114267.1292 | 37.785710831353896 | -122.423161466763 | (37.7857108313539, -122.423161466763) | |||
| 24716 | 24716 | 47878 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41X 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45624 | 5990495.13219 | 2114853.7022700002 | 37.786437050562704 | -122.476676909352 | (37.7864370505627, -122.476676909352) | |
| 24724 | 24724 | 203893 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 Eucalyptus Dr | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5991106.51635 | 2094658.68815 | 37.7310223370083 | -122.473088402602 | (37.7310223370083, -122.473088402602) | |||
| 24760 | 24760 | 188680 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6018245.47476 | 2096448.1212400002 | 37.7374697107694 | -122.37938765012501 | (37.7374697107694, -122.379387650125) | ||||
| 24771 | 24771 | 220203 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6010135.22584 | 2100726.27725 | 37.7487659897773 | -122.407730288036 | (37.7487659897773, -122.407730288036) | |||
| 24814 | 24814 | 124936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3785 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5996163.43195 | 2115866.40469 | 37.7895448064048 | -122.45713942077299 | (37.7895448064048, -122.457139420773) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");