Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 252 | 252 | 182864 | DPW Maintained 3 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | ||
| 1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
| 1967 | 1967 | 138282 | DPW Maintained 3 | Tree(s) :: 17 | 1202 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6003789.8642 | 2112168.8213 | 37.7798272025121 | -122.430488845982 | (37.7798272025121, -122.430488845982) | |||
| 2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
| 2769 | 2769 | 17844 | DPW Maintained 3 | Tree(s) :: 17 | 2064 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780190 | 6004071.9084 | 2115331.7333 | 37.7885277407175 | -122.429738786656 | (37.7885277407175, -122.429738786656) | |
| 2977 | 2977 | 10292 | DPW Maintained 3 | Tree(s) :: 17 | 488 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x4 | 6003826.4075 | 2109393.9739 | 37.7722102257422 | -122.43016441338301 | (37.7722102257422, -122.430164413383) | |||
| 3191 | 3191 | 21648 | DPW Maintained 3 | Tree(s) :: 17 | 1660 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6004632.9541 | 2114713.0403 | 37.7868607185832 | -122.427753554263 | (37.7868607185832, -122.427753554263) | |||
| 4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 9039 | 9039 | 27385 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779236 | 6007159.916809999 | 2119895.6354400003 | 37.8012334551161 | -122.419378628241 | (37.8012334551161, -122.419378628241) | |
| 9042 | 9042 | 27384 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | Permit Number 779236 | 6007162.48532 | 2119880.42159 | 37.801191826388504 | -122.41936866015101 | (37.8011918263885, -122.419368660151) | ||
| 10222 | 10222 | 173923 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10224 | 10224 | 173918 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10225 | 10225 | 173920 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10227 | 10227 | 173914 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10228 | 10228 | 173922 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10230 | 10230 | 173919 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10232 | 10232 | 173916 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10233 | 10233 | 173917 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10234 | 10234 | 122682 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/03/2017 12:00:00 AM | 3 | 6x10 | Permit Number 778226 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | |
| 10237 | 10237 | 173915 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10238 | 10238 | 173921 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 18076 | 18076 | 107933 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 18486 | 18486 | 106393 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 20656 | 20656 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
| 22306 | 22306 | 203218 | DPW Maintained 3 | Tree(s) :: 17 | 865x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | ||||
| 22766 | 22766 | 9009 | DPW Maintained 3 | Tree(s) :: 17 | 5255 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777115 | 5990680.0267 | 2112634.9623 | 37.7803557304658 | -122.47587513459999 | (37.7803557304658, -122.4758751346) | |
| 23155 | 23155 | 543 | DPW Maintained 3 | Tree(s) :: 17 | 2871 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6009625.4825 | 2102172.3236 | 37.7527079631855 | -122.409595033175 | (37.7527079631855, -122.409595033175) | |||
| 65723 | 65723 | 90247 | DPW Maintained 3 | Tree(s) :: 17 | 3026 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986221.604052 | 2111161.316487 | 37.7760500133858 | -122.49119019528798 | (37.7760500133858, -122.491190195288) | |
| 69415 | 69415 | 185128 | DPW Maintained 3 | Tree(s) :: 17 | 1200x Sloat Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5987683.0779 | 2095922.3154 | 37.7342931239465 | -122.48501633511002 | (37.7342931239465, -122.48501633511) | |||
| 77416 | 77416 | 107558 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 78009 | 78009 | 54521 | DPW Maintained 3 | Tree(s) :: 17 | 3500 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/31/1972 12:00:00 AM | Permit Number 10315 | 6006490.84096056 | 2100597.22904115 | 37.7482069647181 | -122.420323418546 | (37.7482069647181, -122.420323418546) | |||
| 78307 | 78307 | 27438 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | |||
| 78577 | 78577 | 107545 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||
| 79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 79307 | 79307 | 107935 | DPW Maintained 3 | Tree(s) :: 17 | 1099X Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6009025.86197 | 2112294.38137 | 37.7804671773494 | -122.41238403194401 | (37.7804671773494, -122.412384031944) | |||||
| 79374 | 79374 | 881 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 79938 | 79938 | 96141 | DPW Maintained 3 | Tree(s) :: 17 | 1468X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | ||||
| 79975 | 79975 | 106399 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 80854 | 80854 | 25577 | DPW Maintained 3 | Tree(s) :: 17 | 250 Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3X3 | 6010651.890723 | 2096938.1663788003 | 37.738393566923705 | -122.40567687514499 | (37.7383935669237, -122.405676875145) | |||
| 80883 | 80883 | 106374 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 81473 | 81473 | 106380 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 81584 | 81584 | 107564 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 81773 | 81773 | 104786 | DPW Maintained 3 | Tree(s) :: 17 | 750 Holly Park Cir | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2x2 | 6006276.6738599995 | 2096799.83163 | 37.7377680961975 | -122.42079445065201 | (37.7377680961975, -122.420794450652) | ||||
| 82181 | 82181 | 106395 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 82638 | 82638 | 96136 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 82688 | 82688 | 26848 | DPW Maintained 3 | Tree(s) :: 17 | 130 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006976.7555 | 2111107.62587 | 37.7770934310359 | -122.419388656004 | (37.7770934310359, -122.419388656004) | |
| 83347 | 83347 | 22801 | DPW Maintained 3 | Tree(s) :: 17 | 1 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 3 | 2x2 | 5998832.3639752995 | 2099992.0164602003 | 37.746110667966704 | -122.446762549602 | (37.7461106679667, -122.446762549602) | ||
| 83430 | 83430 | 107562 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 83897 | 83897 | 106386 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 83946 | 83946 | 106379 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 83951 | 83951 | 876 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 84279 | 84279 | 1036 | DPW Maintained 3 | Tree(s) :: 17 | 1992 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6000710.3605652 | 2090584.316502 | 37.720386412787 | -122.439594386876 | (37.720386412787, -122.439594386876) | ||
| 84529 | 84529 | 25575 | DPW Maintained 3 | Tree(s) :: 17 | 250 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 3X3 | 6010651.890723 | 2096938.1663788003 | 37.738393566923705 | -122.40567687514499 | (37.7383935669237, -122.405676875145) | |||
| 84607 | 84607 | 107559 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 85184 | 85184 | 107546 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||
| 85406 | 85406 | 984 | DPW Maintained 3 | Tree(s) :: 17 | 1617 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1997 12:00:00 AM | 3 | 2X2 | 6001782.703797701 | 2092720.8776329 | 37.726313902626295 | -122.436040457682 | (37.7263139026263, -122.436040457682) | ||
| 85441 | 85441 | 27443 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2000 12:00:00 AM | 3 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | ||
| 85551 | 85551 | 1317 | DPW Maintained 3 | Tree(s) :: 17 | 4050X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 3 | TR | 5991740.4279021 | 2087082.0100679002 | 37.710255321179204 | -122.470345319704 | (37.7102553211792, -122.470345319704) | ||
| 87081 | 87081 | 69781 | DPW Maintained 3 | Tree(s) :: 17 | 1136X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6003354.0 | 2094330.0 | 37.7308213333418 | -122.43072334419399 | (37.7308213333418, -122.430723344194) | |||||
| 89830 | 89830 | 106376 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 91114 | 91114 | 90656 | DPW Maintained 3 | Tree(s) :: 17 | 3450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.7362440005 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) |
| 91418 | 91418 | 105325 | DPW Maintained 3 | Tree(s) :: 17 | 2051 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | |||
| 91583 | 91583 | 96139 | DPW Maintained 3 | Tree(s) :: 17 | 1460X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016261.2 | 2096710.2 | 37.738079695647706 | -122.386266549459 | (37.7380796956477, -122.386266549459) | ||||
| 92047 | 92047 | 106392 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 92062 | 92062 | 100665 | Permitted Site 1 | Tree(s) :: 17 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | FUF 1 | 09/04/2012 12:00:00 AM | 3x3 | Permit Number 769258 | 6003201.8 | 2107946.7 | 37.768200969529204 | -122.432221606092 | (37.7682009695292, -122.432221606092) | |
| 92240 | 92240 | 28968 | DPW Maintained 3 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | ||||||
| 92298 | 92298 | 22858 | DPW Maintained 3 | Tree(s) :: 17 | 144 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5999468.3728742 | 2098975.529944 | 37.7433559522386 | -122.444490278488 | (37.7433559522386, -122.444490278488) | |||
| 93055 | 93055 | 103567 | DPW Maintained 3 | Tree(s) :: 17 | 49X Nevada St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | DPW property; tree is below Bernal Heights Blvd; near this address | 6009060.0 | 2098204.0 | 37.741780122475 | -122.411270274356 | (37.741780122475, -122.411270274356) | ||||
| 93537 | 93537 | 28936 | DPW Maintained 3 | Tree(s) :: 17 | 350 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009925.6038615 | 2109969.203142 | 37.7741332326441 | -122.40910727123199 | (37.7741332326441, -122.409107271232) | |
| 93614 | 93614 | 8324 | DPW Maintained 3 | Tree(s) :: 17 | 1101 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2013 12:00:00 AM | 6 | 3x5 | 6006325.83915 | 2114183.13875 | 37.7855013564448 | -122.421858899832 | (37.7855013564448, -122.421858899832) | ||
| 94414 | 94414 | 106389 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 94441 | 94441 | 96130 | DPW Maintained 3 | Tree(s) :: 17 | 1428X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016403.1 | 2096603.7 | 37.737795121412795 | -122.385768505015 | (37.7377951214128, -122.385768505015) | ||||
| 95804 | 95804 | 879 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 95809 | 95809 | 28937 | DPW Maintained 3 | Tree(s) :: 17 | 350 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009925.6038615 | 2109969.203142 | 37.7741332326441 | -122.40910727123199 | (37.7741332326441, -122.409107271232) | |
| 96353 | 96353 | 104459 | DPW Maintained 3 | Tree(s) :: 17 | 1601X Kansas St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | |||
| 96466 | 96466 | 877 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 96550 | 96550 | 107116 | DPW Maintained 3 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6004270.1 | 2103982.4 | 37.757376462852704 | -122.42824389606199 | (37.7573764628527, -122.428243896062) | ||||
| 96833 | 96833 | 107891 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 97164 | 97164 | 105324 | DPW Maintained 3 | Tree(s) :: 17 | 2051 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | |||
| 97264 | 97264 | 106377 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 97347 | 97347 | 27440 | DPW Maintained 3 | Tree(s) :: 17 | 1690X Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | |||
| 97640 | 97640 | 106384 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 98648 | 98648 | 27545 | DPW Maintained 3 | Tree(s) :: 17 | 1301X Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/24/2004 12:00:00 AM | 3 | 3X3 | 6016183.3939042995 | 2103024.5390709997 | 37.7554132592376 | -122.386975829537 | (37.7554132592376, -122.386975829537) | ||
| 98961 | 98961 | 107560 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 99588 | 99588 | 26070 | DPW Maintained 3 | Tree(s) :: 17 | 251 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2002 12:00:00 AM | 3 | 3X3 | 5993991.0956793 | 2088217.0958163997 | 37.7135018699932 | -122.46264889703801 | (37.7135018699932, -122.462648897038) | ||
| 100615 | 100615 | 91776 | DPW Maintained 3 | Tree(s) :: 17 | 1200x Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6010069.453126 | 2109834.328197 | 37.7737709548765 | -122.40860015267 | (37.7737709548765, -122.40860015267) | |
| 100742 | 100742 | 3886 | DPW Maintained 3 | Tree(s) :: 17 | 18 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002041.7840637 | 2108518.2345868 | 37.769704422667395 | -122.436274885743 | (37.7697044226674, -122.436274885743) | |||
| 101291 | 101291 | 91388 | DPW Maintained 3 | Tree(s) :: 17 | 151 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52086 | 6006268.862000001 | 2110391.01499 | 37.7750858950422 | -122.421786571974 | (37.7750858950422, -122.421786571974) | |
| 101787 | 101787 | 107890 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 102417 | 102417 | 87443 | DPW Maintained 3 | Tree(s) :: 17 | 2801X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3x3 | 5997499.095644999 | 2087961.1596509998 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | |||
| 102603 | 102603 | 96129 | DPW Maintained 3 | Tree(s) :: 17 | 1424X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016423.9 | 2096594.4 | 37.7377707364606 | -122.385695940665 | (37.7377707364606, -122.385695940665) | ||||
| 102705 | 102705 | 29461 | DPW Maintained 3 | Tree(s) :: 17 | 1735X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 6016645.7817587005 | 2093112.7248692 | 37.7282230250629 | -122.384686318732 | (37.7282230250629, -122.384686318732) | |||
| 102762 | 102762 | 107548 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |
| 103346 | 103346 | 95333 | DPW Maintained 3 | Tree(s) :: 17 | 399X Filbert St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 103506 | 103506 | 12958 | DPW Maintained 3 | Tree(s) :: 17 | 829X Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001844.208871599 | 2095812.5283612 | 37.7348063625139 | -122.436048971563 | (37.7348063625139, -122.436048971563) | |||
| 103510 | 103510 | 92813 | Significant Tree 6 | Tree(s) :: 17 | 365 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 53020 | 6006011.0 | 2111744.0 | 37.7787863189721 | -122.42277474798 | (37.7787863189721, -122.42277474798) | |||
| 103606 | 103606 | 107561 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 103703 | 103703 | 870 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 103968 | 103968 | 106387 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
| 104703 | 104703 | 868 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) |
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");