Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1647 | 1647 | 20023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 3819 | 3819 | 19829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 6492 | 6492 | 20389 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 6746 | 6746 | 20018 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 7838 | 7838 | 20021 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 8001 | 8001 | 20026 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8245 | 8245 | 20020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 8435 | 8435 | 19808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 8460 | 8460 | 20385 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11007 | 11007 | 19809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY23 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 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 | |||||||||
| 11209 | 11209 | 20386 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 262X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11240 | 11240 | 19966 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 11825 | 11825 | 20029 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 12211 | 12211 | 20025 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 12986 | 12986 | 19789 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY19 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 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 | |||||||||
| 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 | |||||||||
| 15553 | 15553 | 20453 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16079 | 16079 | 19828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16094 | 16094 | 20027 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 16846 | 16846 | 20022 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 172542 | 172542 | 118402 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5981581.19272 | 2111336.4481099998 | 37.776258646710794 | -122.50725532177 | (37.7762586467108, -122.50725532177) | |||
| 93554 | 93554 | 87293 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 106304 | 106304 | 87292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 126772 | 126772 | 87291 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 28206 | 28206 | 183276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1258 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982450.6111 | 2106538.8 | 37.7631368622084 | -122.503892396491 | (37.7631368622084, -122.503892396491) | |||
| 176108 | 176108 | 182905 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2721 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5982744.7337 | 2096592.2081 | 37.7358435812589 | -122.502139054485 | (37.7358435812589, -122.502139054485) | |||
| 146945 | 146945 | 113984 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 538 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | 5982879.61718 | 2112112.63686 | 37.7784662262945 | -122.50282125997101 | (37.7784662262945, -122.502821259971) | |||
| 44355 | 44355 | 184513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5983187.3894 | 2101698.6547 | 37.7498904791156 | -122.50098618533801 | (37.7498904791156, -122.500986185338) | |||
| 48295 | 48295 | 184511 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983188.0663 | 2101701.7005 | 37.749898881781895 | -122.50098406985501 | (37.7498988817819, -122.500984069855) | |||
| 62247 | 62247 | 184510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5983188.0663 | 2101709.4842 | 37.749920253660605 | -122.500984645445 | (37.7499202536606, -122.500984645445) | |||
| 174232 | 174232 | 184514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5983188.0663 | 2101693.9168 | 37.749877509903 | -122.500983494265 | (37.749877509903, -122.500983494265) | |||
| 49203 | 49203 | 184512 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983188.7431 | 2101700.3468 | 37.7498952046369 | -122.50098162938299 | (37.7498952046369, -122.500981629383) | |||
| 36012 | 36012 | 183644 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1479 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5983388.9318 | 2105088.2135 | 37.7592090919823 | -122.50053984924801 | (37.7592090919823, -122.500539849248) | |||
| 147827 | 147827 | 59324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1370 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2012 12:00:00 AM | 1 | Permit Number 769281 | 5983406.5406 | 2105829.5951 | 37.761245750286996 | -122.50053376884199 | (37.761245750287, -122.500533768842) | ||
| 165055 | 165055 | 184149 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1587 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5983414.0938 | 2104358.5155 | 37.7572070235512 | -122.500398877559 | (37.7572070235512, -122.500398877559) | |||
| 120651 | 120651 | 30332 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1783 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1956 12:00:00 AM | Permit Number 23 | 5983455.10471621 | 2103020.95546664 | 37.753536865117795 | -122.5001581692 | (37.7535368651178, -122.5001581692) | |||
| 65219 | 65219 | 183320 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3921 Lincoln Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5983535.7378 | 2106954.4614 | 37.764341897987705 | -122.50017009829399 | (37.7643418979877, -122.500170098294) | |||
| 171707 | 171707 | 183318 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3915 Lincoln Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5983544.4671 | 2106954.7342 | 37.764343159359 | -122.50013992674 | (37.764343159359, -122.50013992674) | |||
| 64324 | 64324 | 183319 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3915 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5983558.1066 | 2106954.4614 | 37.7643432108416 | -122.500092732113 | (37.7643432108416, -122.500092732113) | |||
| 36249 | 36249 | 183710 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1205 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5984255.4943 | 2106945.8685 | 37.7643605222858 | -122.497680065967 | (37.7643605222858, -122.497680065967) | |||
| 155608 | 155608 | 118211 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 822 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5984502.17858 | 2110227.24681 | 37.7733847121042 | -122.497069091186 | (37.7733847121042, -122.497069091186) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 161099 | 161099 | 184809 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1250 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5984621.3412 | 2106632.1075 | 37.7635204618116 | -122.49639156949301 | (37.7635204618116, -122.496391569493) | |||
| 174588 | 174588 | 184857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984627.4167 | 2106843.4213 | 37.7641010259615 | -122.496386149808 | (37.7641010259615, -122.496386149808) | |||
| 53890 | 53890 | 184855 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984629.3153 | 2106852.5345 | 37.764126159465796 | -122.49638025568501 | (37.7641261594658, -122.496380255685) | |||
| 41402 | 41402 | 184854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984632.7328 | 2106851.7751 | 37.764124274568 | -122.496368379685 | (37.764124274568, -122.496368379685) | |||
| 150735 | 150735 | 184840 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984633.1125 | 2106860.5086 | 37.7641482765436 | -122.49636771089199 | (37.7641482765436, -122.496367710892) | |||
| 179837 | 179837 | 184835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984633.1125 | 2106875.3177 | 37.764188938163 | -122.496368803682 | (37.764188938163, -122.496368803682) | |||
| 131473 | 131473 | 184856 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984633.4922 | 2106845.3199 | 37.764106594892205 | -122.49636527684099 | (37.7641065948922, -122.496365276841) | |||
| 138084 | 138084 | 184839 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984633.4922 | 2106865.0653 | 37.7641608102021 | -122.49636673388599 | (37.7641608102021, -122.496366733886) | |||
| 73850 | 73850 | 184867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.0111 | 2106821.7773 | 37.7640420425175 | -122.496358286248 | (37.7640420425175, -122.496358286248) | |||
| 35947 | 35947 | 184865 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.3908 | 2106835.0674 | 37.7640785556344 | -122.49635795369 | (37.7640785556344, -122.49635795369) | |||
| 55241 | 55241 | 184879 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984636.1502 | 2106802.0319 | 37.7639878939354 | -122.49635288946101 | (37.7639878939354, -122.496352889461) | |||
| 185060 | 185060 | 184887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984636.53 | 2106768.6166 | 37.763896167173705 | -122.496349110122 | (37.7638961671737, -122.496349110122) | |||
| 155281 | 155281 | 184841 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984637.2894 | 2106860.5086 | 37.7641485212291 | -122.496353264421 | (37.7641485212291, -122.496353264421) | |||
| 161523 | 161523 | 184853 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984637.6691 | 2106845.6996 | 37.7641078821268 | -122.496350858396 | (37.7641078821268, -122.496350858396) | |||
| 59482 | 59482 | 184880 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984640.7069 | 2106797.4752 | 37.763975649452 | -122.496336793184 | (37.763975649452, -122.496336793184) | |||
| 178871 | 178871 | 184858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984642.9852 | 2106842.6618 | 37.7640998526008 | -122.49633224767 | (37.7640998526008, -122.49633224767) | |||
| 150808 | 150808 | 184875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984644.1243 | 2106811.5248 | 37.764014425890394 | -122.496326010311 | (37.7640144258904, -122.496326010311) | |||
| 47210 | 47210 | 184881 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984647.1621 | 2106788.3619999997 | 37.7639510053125 | -122.496313794444 | (37.7639510053125, -122.496313794444) | |||
| 163857 | 163857 | 184864 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984647.1621 | 2106835.0674 | 37.7640792451971 | -122.496317240818 | (37.7640792451971, -122.496317240818) | |||
| 32442 | 32442 | 184851 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984650.5796 | 2106846.0793 | 37.7641096809697 | -122.496306233424 | (37.7641096809697, -122.496306233424) | |||
| 186018 | 186018 | 184852 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984650.5796 | 2106852.1548 | 37.7641263625826 | -122.49630668173201 | (37.7641263625826, -122.496306681732) | |||
| 172966 | 172966 | 184838 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984655.5159 | 2106866.5842 | 37.764166270816396 | -122.496290673488 | (37.7641662708164, -122.496290673488) | |||
| 139867 | 139867 | 184859 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984655.8956 | 2106841.143 | 37.7640964386841 | -122.49628748296101 | (37.7640964386841, -122.496287482961) | |||
| 172587 | 172587 | 184870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984657.0348 | 2106822.5367 | 37.7640454177531 | -122.496282169928 | (37.7640454177531, -122.496282169928) | |||
| 155970 | 155970 | 184876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984660.832 | 2106807.7277 | 37.764004978839296 | -122.496267944002 | (37.7640049788393, -122.496267944002) | |||
| 159541 | 159541 | 184871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984661.2117 | 2106828.9919 | 37.7640633865909 | -122.496268199792 | (37.7640633865909, -122.496268199792) | |||
| 30179 | 30179 | 184882 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984668.0467 | 2106784.9445 | 37.763942845201996 | -122.496241309763 | (37.763942845202, -122.496241309763) | |||
| 32524 | 32524 | 184847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984668.0467 | 2106854.8129 | 37.764134684168404 | -122.49624646514401 | (37.7641346841684, -122.496246465144) | |||
| 56071 | 56071 | 184863 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984668.8061 | 2106833.1689 | 37.764075300319 | -122.496242241592 | (37.764075300319, -122.496242241592) | |||
| 172559 | 172559 | 184836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984671.8439 | 2106872.6597 | 37.7641839088875 | -122.496234648785 | (37.7641839088875, -122.496234648785) | |||
| 42663 | 42663 | 184878 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984672.2236 | 2106800.5130000003 | 37.763985836593 | -122.496228012074 | (37.763985836593, -122.496228012074) | |||
| 106774 | 106774 | 184850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984672.2236 | 2106848.3576 | 37.764117204402 | -122.49623154236001 | (37.764117204402, -122.49623154236) | |||
| 155834 | 155834 | 184862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984672.6033 | 2106838.8646 | 37.764091161536996 | -122.496229528652 | (37.764091161537, -122.496229528652) | |||
| 33671 | 33671 | 184350 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984674.1222 | 2106470.7267 | 37.7630804473372 | -122.496197112117 | (37.7630804473372, -122.496197112117) | |||
| 42608 | 42608 | 184797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984676.0208 | 2105815.7109 | 37.761282068862 | -122.496142217022 | (37.761282068862, -122.496142217022) | |||
| 176241 | 176241 | 184888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984676.0208 | 2106738.9985 | 37.7638171575071 | -122.496210339991 | (37.7638171575071, -122.496210339991) | |||
| 179644 | 179644 | 184877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984676.4005 | 2106805.4493 | 37.763999634952505 | -122.49621392986201 | (37.7639996349525, -122.496213929862) | |||
| 168404 | 168404 | 184829 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984677.5396 | 2106895.0631 | 37.7642457559536 | -122.496216602354 | (37.7642457559536, -122.496216602354) | |||
| 26399 | 26399 | 184774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984678.2991 | 2105977.4713 | 37.7617263510589 | -122.496146272255 | (37.7617263510589, -122.496146272255) | |||
| 179583 | 179583 | 184846 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984679.0585 | 2106853.294 | 37.764131158732 | -122.496208267019 | (37.764131158732, -122.496208267019) | |||
| 138070 | 138070 | 184849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984683.2354 | 2106848.3576 | 37.7641178494327 | -122.49619345631599 | (37.7641178494327, -122.496193456316) | |||
| 44264 | 44264 | 186653 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984685.2528 | 2105582.1287 | 37.76064125825761 | -122.49609305452199 | (37.7606412582576, -122.496093054522) | |||
| 31867 | 31867 | 184860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984687.0326 | 2106838.4849 | 37.7640909641996 | -122.496179594648 | (37.7640909641996, -122.496179594648) | |||
| 149798 | 149798 | 184837 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984687.4123 | 2106865.8247 | 37.764166053838395 | -122.496180298656 | (37.7641660538384, -122.496180298656) | |||
| 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) | |||
| 41974 | 41974 | 184884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984688.9312 | 2106783.4256 | 37.7639398980625 | -122.49616896553101 | (37.7639398980625, -122.496168965531) | |||
| 12609 | 12609 | 774 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5984689.126 | 2104618.0173 | 37.7579943042171 | -122.496008531807 | (37.7579943042171, -122.496008531807) | |||
| 151848 | 151848 | 184848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984690.0704 | 2106845.3199 | 37.764109909126205 | -122.496169592258 | (37.7641099091262, -122.496169592258) | |||
| 176885 | 176885 | 184861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984691.2095 | 2106834.308 | 37.7640797402699 | -122.496164839998 | (37.7640797402699, -122.496164839998) | |||
| 38326 | 38326 | 184352 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984691.969 | 2106499.9651 | 37.7631617731469 | -122.496137544283 | (37.7631617731469, -122.496137544283) | |||
| 177194 | 177194 | 184883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984691.969 | 2106787.6025 | 37.763951544593795 | -122.49615876703399 | (37.7639515445938, -122.496158767034) |
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");