Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 93717 | 93717 | 25437 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2555 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1998 12:00:00 AM | 3 | 3x3 | 6010830.95304 | 2086585.06609 | 37.7099761086624 | -122.40432925767401 | (37.7099761086624, -122.404329257674) | ||
| 12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
| 10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
| 57966 | 57966 | 188747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6014639.494109999 | 2086953.6057 | 37.7112001369439 | -122.391191848221 | (37.7112001369439, -122.391191848221) | |||
| 71605 | 71605 | 188746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014613.42303 | 2086955.91765 | 37.7112050382485 | -122.391282118582 | (37.7112050382485, -122.391282118582) | |||
| 133838 | 133838 | 188745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014589.916680001 | 2086958.4326 | 37.711210639227 | -122.39136353872101 | (37.711210639227, -122.391363538721) | |||
| 37820 | 37820 | 188744 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6014566.93251 | 2086961.4469700002 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | |||
| 32164 | 32164 | 188743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | |||
| 63133 | 63133 | 188742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6014513.510980001 | 2086966.09658 | 37.7112274421761 | -122.391628153428 | (37.7112274421761, -122.391628153428) | |||
| 168939 | 168939 | 188741 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 8ft | 6014489.73327 | 2086967.85233 | 37.7112309432358 | -122.39171045846399 | (37.7112309432358, -122.391710458464) | |||
| 178538 | 178538 | 188740 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | |||
| 186731 | 186731 | 188739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014439.36233 | 2086971.4204900002 | 37.7112379444543 | -122.39188480373801 | (37.7112379444543, -122.391884803738) | |||
| 149419 | 149419 | 188738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014415.87146 | 2086974.70005 | 37.7112456453465 | -122.39196622388799 | (37.7112456453465, -122.391966223888) | |||
| 71411 | 71411 | 188737 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014387.73209 | 2086976.03412 | 37.7112477461551 | -122.39206357459899 | (37.7112477461551, -122.392063574599) | |||
| 65570 | 65570 | 188736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014364.73249 | 2086978.28388 | 37.7112526465696 | -122.39214322484 | (37.7112526465696, -122.39214322484) | |||
| 75165 | 75165 | 188735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014342.21925 | 2086979.24909 | 37.711254046810495 | -122.39222110431601 | (37.7112540468105, -122.392221104316) | |||
| 174612 | 174612 | 188734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014314.36158 | 2086981.8522700001 | 37.71125964778079 | -122.39231757011801 | (37.7112596477808, -122.392317570118) | |||
| 56907 | 56907 | 187701 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014160.4254 | 2086993.65928 | 37.7112835184788 | -122.392850441814 | (37.7112835184788, -122.392850441814) | |||
| 153767 | 153767 | 187700 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014134.283869999 | 2086999.7269 | 37.7112987269389 | -122.392941218475 | (37.7112987269389, -122.392941218475) | |||
| 30017 | 30017 | 187699 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | |||
| 170303 | 170303 | 188764 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014090.1968 | 2087004.6185400002 | 37.711309709434 | -122.393093937756 | (37.711309709434, -122.393093937756) | |||
| 137789 | 137789 | 188763 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 8ft | 6014060.27429 | 2087007.0702 | 37.711314778934295 | -122.39319752976601 | (37.7113147789343, -122.393197529766) | |||
| 173558 | 173558 | 188762 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6014035.24999 | 2087007.2689599998 | 37.71131393444921 | -122.39328403465299 | (37.7113139344492, -122.393284034653) | |||
| 147853 | 147853 | 188761 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 8ft | 6013991.40971 | 2087009.0790099998 | 37.7113164687655 | -122.39343568552 | (37.7113164687655, -122.39343568552) | |||
| 157079 | 157079 | 187711 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013709.84578 | 2087009.9917799998 | 37.711303326954706 | -122.394408912955 | (37.7113033269547, -122.394408912955) | |||
| 166786 | 166786 | 188760 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6013911.80932 | 2087014.9974599998 | 37.7113282966477 | -122.393711220721 | (37.7113282966477, -122.393711220721) | |||
| 29957 | 29957 | 187712 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013733.01886 | 2087017.8562099999 | 37.7113262093072 | -122.39432937061301 | (37.7113262093072, -122.394329370613) | |||
| 152573 | 152573 | 187713 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 51x Executive Park Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013756.4546300005 | 2087023.9293400003 | 37.71134418764721 | -122.394248794959 | (37.7113441876472, -122.394248794959) | |||
| 11153 | 11153 | 1849 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011118.84502 | 2087065.06419 | 37.7113101708062 | -122.40336798796301 | (37.7113101708062, -122.403367987963) | |||
| 126877 | 126877 | 11850 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 139321 | 139321 | 11851 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 90127 | 90127 | 89023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Hollywood Ct | 1 | unknown : Cutout 12 | Tree 1 | DPW 2 | 6000329.0 | 2088600.0 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | |||||
| 10841 | 10841 | 25393 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | |||
| 109591 | 109591 | 115677 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | ||||
| 9667 | 9667 | 11795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 99816 | 99816 | 11794 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 114205 | 114205 | 114109 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 120454 | 120454 | 11793 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
| 36772 | 36772 | 175020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6010396.843230001 | 2090323.76583 | 37.7202175482911 | -122.40609285101401 | (37.7202175482911, -122.406092851014) | |||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 85780 | 85780 | 396 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3790X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2 | 5990481.42225 | 2090722.77019 | 37.7201790804753 | -122.474962240321 | (37.7201790804753, -122.474962240321) | |||
| 85625 | 85625 | 382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | |||
| 45609 | 45609 | 369 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 98662 | 98662 | 358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
| 115881 | 115881 | 11755 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 901X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X4 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 142135 | 142135 | 339 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3590X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
| 128477 | 128477 | 324 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 88947 | 88947 | 4806 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 91586 | 91586 | 4807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 108562 | 108562 | 4809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 111013 | 111013 | 4808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
| 18211 | 18211 | 11709 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.4086799999 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | ||
| 82334 | 82334 | 294 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
| 21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
| 21068 | 21068 | 29972 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.47220779725299 | (37.7284219643784, -122.472207797253) | ||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 99139 | 99139 | 74759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 54812 | 54812 | 175058 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1132x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | |||
| 15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
| 16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
| 15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
| 13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
| 23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
| 16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
| 15650 | 15650 | 24228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6017105.8284599995 | 2094967.47212 | 37.7333412272151 | -122.383224950289 | (37.7333412272151, -122.383224950289) | |||
| 14161 | 14161 | 24226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.38312226117901 | (37.7333610509772, -122.383122261179) | |||
| 16402 | 16402 | 97222 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.733339211818105 | -122.38470904929702 | (37.7333392118181, -122.384709049297) | |||
| 14947 | 14947 | 24225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.401959999 | 2094982.30239 | 37.7333853506538 | -122.38301310328698 | (37.7333853506538, -122.383013103287) | ||
| 16537 | 16537 | 24220 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017233.65569 | 2094997.2718200001 | 37.7334301143948 | -122.38278508468001 | (37.7334301143948, -122.38278508468) | |||
| 37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
| 13683 | 13683 | 1710 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.73374666585679 | -122.385057651709 | (37.7337466658568, -122.385057651709) | |||
| 23851 | 23851 | 200603 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.38560931762301 | (37.733790555057, -122.385609317623) | |||
| 13870 | 13870 | 24143 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016705.2095099995 | 2095147.06572 | 37.7338122084672 | -122.38462252011999 | (37.7338122084672, -122.38462252012) | |||
| 137314 | 137314 | 200611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | |||
| 59915 | 59915 | 200610 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.733836134681795 | -122.385618942498 | (37.7338361346818, -122.385618942498) | |||
| 55316 | 55316 | 200609 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | |||
| 13964 | 13964 | 24120 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6016647.77235 | 2095170.8389599998 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | |||
| 131211 | 131211 | 200607 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016406.5235 | 2095183.1256 | 37.73389469904829 | -122.385657689133 | (37.7338946990483, -122.385657689133) |
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");