Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132408 | 132408 | 175130 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.603519999 | 2086651.0077400003 | 37.7095529054216 | -122.441347441633 | (37.7095529054216, -122.441347441633) | |||
| 32646 | 32646 | 203423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | |||
| 64702 | 64702 | 220472 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009413.9185 | 2095926.46105 | 37.735546336994794 | -122.409885800206 | (37.7355463369948, -122.409885800206) | |||
| 152475 | 152475 | 220471 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009494.822380001 | 2095997.42417 | 37.735745720287106 | -122.4096110906 | (37.7357457202871, -122.4096110906) | |||
| 171009 | 171009 | 220470 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009551.6866 | 2096070.2477900002 | 37.7359488645495 | -122.409419625821 | (37.7359488645495, -122.409419625821) | |||
| 105346 | 105346 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 34428 | 34428 | 187860 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014887.824680001 | 2103924.74261 | 37.7578132028277 | -122.391519270711 | (37.7578132028277, -122.391519270711) | |||
| 73338 | 73338 | 187861 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014851.37518 | 2103923.26798 | 37.7578071306235 | -122.391645226173 | (37.7578071306235, -122.391645226173) | |||
| 165796 | 165796 | 187862 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014817.13681 | 2103921.30652 | 37.7577998442984 | -122.391763500508 | (37.7577998442984, -122.391763500508) | |||
| 177219 | 177219 | 187863 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014779.35542 | 2103919.85891 | 37.7577937720836 | -122.391894064084 | (37.7577937720836, -122.391894064084) | |||
| 86826 | 86826 | 29064 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1000X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 03/02/2006 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 145179 | 145179 | 29063 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1000X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 53388 | 53388 | 137760 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001423.7559 | 2112018.8276 | 37.7792810387103 | -122.438663489904 | (37.7792810387103, -122.438663489904) | |||
| 63089 | 63089 | 137761 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001442.3691 | 2111886.1663 | 37.7789178432038 | -122.43858959128299 | (37.7789178432038, -122.438589591283) | |||
| 67396 | 67396 | 137764 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001436.616 | 2111937.2679 | 37.7790578279952 | -122.438613156035 | (37.7790578279952, -122.438613156035) | |||
| 138085 | 138085 | 137763 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001437.9696 | 2111922.039 | 37.77901609029121 | -122.438607381917 | (37.7790160902912, -122.438607381917) | |||
| 154554 | 154554 | 137759 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001427.817000001 | 2112000.5528 | 37.7792310917629 | -122.438648131089 | (37.7792310917629, -122.438648131089) | |||
| 165225 | 165225 | 137749 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | |||
| 172170 | 172170 | 137762 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001439.6617 | 2111903.7642 | 37.7789660085719 | -122.438600218498 | (37.7789660085719, -122.438600218498) | |||
| 179995 | 179995 | 137750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209408995 | -122.43867130831 | (37.779356209409, -122.43867130831) | |||
| 87911 | 87911 | 29065 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 113978 | 113978 | 29066 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 18469 | 18469 | 28373 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1008X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/14/2003 12:00:00 AM | 3 | 3X3 | 6004368.57651 | 2102993.46907 | 37.7546666629566 | -122.42783286161001 | (37.7546666629566, -122.42783286161) | ||
| 74171 | 74171 | 203427 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 101 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994083.74487 | 2096763.2179299998 | 37.7369727831569 | -122.462948326201 | (37.7369727831569, -122.462948326201) | |||
| 21941 | 21941 | 28285 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1010 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2003 12:00:00 AM | 3 | 3x3 | 6004371.7708 | 2102969.95862 | 37.7546022894831 | -122.427820139789 | (37.7546022894831, -122.427820139789) | ||
| 3726 | 3726 | 14780 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1019 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004321.3595 | 2111841.1408 | 37.7789575666093 | -122.42862680452801 | (37.7789575666093, -122.428626804528) | ||
| 41174 | 41174 | 189076 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010179.59918 | 2108995.88933 | 37.7714749641405 | -122.408159994002 | (37.7714749641405, -122.408159994002) | |||
| 49093 | 49093 | 189078 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010207.59565 | 2109022.90661 | 37.771550714911896 | -122.40806505798 | (37.7715507149119, -122.40806505798) | |||
| 49948 | 49948 | 189079 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010221.55971 | 2109034.74016 | 37.771583988945 | -122.40801758996099 | (37.771583988945, -122.408017589961) | |||
| 152710 | 152710 | 189080 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010237.11859 | 2109048.60365 | 37.7716229259945 | -122.407964748472 | (37.7716229259945, -122.407964748472) | |||
| 161993 | 161993 | 189077 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010192.31636 | 2109010.06883 | 37.7715146098343 | -122.408117004595 | (37.7715146098343, -122.408117004595) | |||
| 180567 | 180567 | 141986 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1067 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004102.6078 | 2111812.2185 | 37.778865770833505 | -122.429381491168 | (37.7788657708335, -122.429381491168) | |||
| 87832 | 87832 | 14784 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1067 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 4X4 | 6004083.630320299 | 2111809.5297481003 | 37.7788573137505 | -122.429446949988 | (37.7788573137505, -122.429446949988) | ||
| 145170 | 145170 | 86614 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1070 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010177.0 | 2109056.0 | 37.7716398686135 | -122.4081732249 | (37.7716398686135, -122.4081732249) | ||
| 113637 | 113637 | 86681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1099X Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.771276268637706 | -122.408451379419 | (37.7712762686377, -122.408451379419) | ||
| 85039 | 85039 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 117245 | 117245 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 50461 | 50461 | 187926 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013589.1856 | 2115211.48481 | 37.788731892112004 | -122.39680180476499 | (37.788731892112, -122.396801804765) | |||
| 53943 | 53943 | 187929 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013625.5813 | 2115247.15828 | 37.788831868855205 | -122.396678381805 | (37.7888318688552, -122.396678381805) | |||
| 62879 | 62879 | 187927 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013603.72769 | 2115224.95515 | 37.7887696879241 | -122.39675243559601 | (37.7887696879241, -122.396752435596) | |||
| 66786 | 66786 | 187924 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013555.31002 | 2115180.42433 | 37.7886447217118 | -122.39691683164301 | (37.7886447217118, -122.396916831643) | |||
| 71721 | 71721 | 187928 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013614.18616 | 2115234.9562 | 37.788797730571396 | -122.396716951919 | (37.7887977305714, -122.396716951919) | |||
| 134632 | 134632 | 187925 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013571.0237 | 2115195.4234 | 37.7886867803215 | -122.396863516254 | (37.7886867803215, -122.396863516254) | |||
| 132785 | 132785 | 203421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993401.40723 | 2097258.40143 | 37.738293106632 | -122.46534341236799 | (37.738293106632, -122.465343412368) | |||
| 64406 | 64406 | 137743 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001371.9774 | 2112372.8168 | 37.780250057585505 | -122.438867987251 | (37.7802500575855, -122.438867987251) | |||
| 131506 | 131506 | 137746 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001366.2242 | 2112424.9338 | 37.78039283031271 | -122.43889162608299 | (37.7803928303127, -122.438891626083) | |||
| 135895 | 135895 | 137754 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001389.9137 | 2112267.2292 | 37.7799611612734 | -122.43879836898199 | (37.7799611612734, -122.438798368982) | |||
| 147616 | 147616 | 137751 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001395.6669 | 2112224.5881 | 37.77984440693479 | -122.43877540968398 | (37.7798444069348, -122.438775409684) | |||
| 160930 | 160930 | 137753 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001391.9443 | 2112251.3234 | 37.779917603505 | -122.438790204132 | (37.779917603505, -122.438790204132) | |||
| 163683 | 163683 | 137745 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001366.2242 | 2112409.7048 | 37.7803510153457 | -122.438890534421 | (37.7803510153457, -122.438890534421) | |||
| 169743 | 169743 | 137744 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001369.6084 | 2112388.3842 | 37.7802926669324 | -122.43887729860701 | (37.7802926669324, -122.438877298607) | |||
| 174027 | 174027 | 137752 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001393.9748 | 2112237.1097 | 37.7798786918075 | -122.43878216092399 | (37.7798786918075, -122.438782160924) | |||
| 67378 | 67378 | 141946 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1101 GOLDEN GATE AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004240.9751 | 2112176.1634 | 37.779872906242204 | -122.42892877801201 | (37.7798729062422, -122.428928778012) | |||
| 25823 | 25823 | 187931 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | |||
| 70381 | 70381 | 187935 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6015174.64356 | 2115822.5435099998 | 37.790497836842796 | -122.391359037593 | (37.7904978368428, -122.391359037593) | |||
| 163804 | 163804 | 187932 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015226.56568 | 2115767.0795400003 | 37.790348427077106 | -122.39117551026101 | (37.7903484270771, -122.391175510261) | |||
| 176021 | 176021 | 187933 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015208.90661 | 2115787.01653 | 37.7904021894671 | -122.391238004144 | (37.7904021894671, -122.391238004144) | |||
| 176685 | 176685 | 187934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | |||
| 183883 | 183883 | 187930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6015248.50297 | 2115743.86859 | 37.790285912521 | -122.391097985077 | (37.790285912521, -122.391097985077) | |||
| 63219 | 63219 | 189073 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1111 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009955.51496 | 2108774.3382900003 | 37.770854086583796 | -122.40891948225 | (37.7708540865838, -122.40891948225) | |||
| 76056 | 76056 | 189074 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1111 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009972.167330001 | 2108791.01573 | 37.770900811749 | -122.40886305789101 | (37.770900811749, -122.408863057891) | |||
| 149227 | 149227 | 189072 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1111 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009937.5475699995 | 2108756.6562900003 | 37.7708045294385 | -122.40898038434901 | (37.7708045294385, -122.408980384349) | |||
| 161655 | 161655 | 189075 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1111 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009987.72673 | 2108804.8794 | 37.7709397497056 | -122.408810215546 | (37.7709397497056, -122.408810215546) | |||
| 11390 | 11390 | 887 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1132 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2016 12:00:00 AM | 3 | 3x4 | 6003641.7751 | 2094429.9895799998 | 37.731112181982205 | -122.429735588731 | (37.7311121819822, -122.429735588731) | ||
| 101439 | 101439 | 14797 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1135 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | 0 | 4X4 | 6003741.3117055 | 2111761.9657456 | 37.77870732769679 | -122.43062777021099 | (37.7787073276968, -122.430627770211) | ||
| 14909 | 14909 | 86671 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1155 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009854.63379 | 2108677.64485 | 37.7705829373798 | -122.409261609551 | (37.7705829373798, -122.409261609551) | ||
| 15710 | 15710 | 86672 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1155 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009883.68707 | 2108705.67197 | 37.77066152104221 | -122.409163091525 | (37.7706615210422, -122.409163091525) | ||
| 15143 | 15143 | 86673 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009836.98822 | 2108663.0502 | 37.770541875235 | -122.409321615924 | (37.770541875235, -122.409321615924) | ||
| 41437 | 41437 | 189071 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009822.97122 | 2108648.63961 | 37.7705015217488 | -122.40936908392 | (37.7705015217488, -122.40936908392) | |||
| 67944 | 67944 | 189070 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009807.6250599995 | 2108635.36026 | 37.77046419989421 | -122.409421229304 | (37.7704641998942, -122.409421229304) | |||
| 161748 | 161748 | 140559 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1165 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003635.7523 | 2111746.192 | 37.778658036196106 | -122.430991815 | (37.7786580361961, -122.430991815) | |||
| 86142 | 86142 | 86610 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1174 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/20/2012 12:00:00 AM | 3 | 3x3 | 6009792.0 | 2108692.0 | 37.770618844032796 | -122.40947927469699 | (37.7706188440328, -122.409479274697) | ||
| 87096 | 87096 | 103269 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1175 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003540.3 | 2111739.0 | 37.7786328797101 | -122.431321507712 | (37.7786328797101, -122.431321507712) | ||||
| 9232 | 9232 | 903 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1176 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 6003354.20402 | 2094344.7552 | 37.7308618593504 | -122.430723691407 | (37.7308618593504, -122.430723691407) | ||
| 134444 | 134444 | 175133 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1176 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003358.89864 | 2094334.77609 | 37.730834724939605 | -122.43070674951099 | (37.7308347249396, -122.430706749511) | |||
| 64160 | 64160 | 220475 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1177 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5997354.16789 | 2106085.5022299998 | 37.7627573058278 | -122.452313556128 | (37.7627573058278, -122.452313556128) | |||
| 34534 | 34534 | 220499 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.23781 | 2108216.38247 | 37.768937280547796 | -122.432495314901 | (37.7689372805478, -122.432495314901) | |||
| 150427 | 150427 | 220500 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003126.35036 | 2108201.25772 | 37.7688956446503 | -122.43250076301001 | (37.7688956446503, -122.43250076301) | |||
| 162622 | 162622 | 112592 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 3x3 | 6001349.3031 | 2112591.7757 | 37.7808499730483 | -122.438962124144 | (37.7808499730483, -122.438962124144) | |||
| 165972 | 165972 | 112593 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001345.5805 | 2112610.0505 | 37.7808999391999 | -122.43897631246901 | (37.7808999391999, -122.438976312469) | |||
| 183186 | 183186 | 112594 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001343.2115 | 2112635.4321 | 37.7809694958311 | -122.438986327521 | (37.7809694958311, -122.438986327521) | |||
| 29792 | 29792 | 112595 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.781176707308504 | -122.43904854399099 | (37.7811767073085, -122.439048543991) | |||
| 149679 | 149679 | 112598 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001320.7065 | 2112754.895 | 37.7812962300665 | -122.439072747614 | (37.7812962300665, -122.439072747614) | |||
| 152323 | 152323 | 112597 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001322.3986 | 2112740.3429 | 37.7812563699828 | -122.439065850543 | (37.7812563699828, -122.439065850543) | |||
| 177808 | 177808 | 112591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 3x3 | 6001352.6873 | 2112575.8699 | 37.7808064923129 | -122.438949276348 | (37.7808064923129, -122.438949276348) | |||
| 187201 | 187201 | 112596 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001324.7675 | 2112728.8365 | 37.7812249111251 | -122.439056830439 | (37.7812249111251, -122.439056830439) | |||
| 50896 | 50896 | 68389 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.728420898703604 | -122.43531143848 | (37.7284208987036, -122.43531143848) | |
| 55050 | 55050 | 66327 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.48800101763901 | (37.7642819711606, -122.488001017639) | |
| 13076 | 13076 | 921 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1252 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 6002917.86629 | 2094183.9473299999 | 37.730395586884 | -122.432220700641 | (37.730395586884, -122.432220700641) | ||
| 38131 | 38131 | 140748 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001272.3122 | 2113103.8079 | 37.782251502236704 | -122.439265184087 | (37.7822515022367, -122.439265184087) | |||
| 55776 | 55776 | 140751 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001278.4038 | 2113063.8741 | 37.782142200849 | -122.439241246745 | (37.782142200849, -122.439241246745) | |||
| 59104 | 59104 | 141319 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001291.9406 | 2112967.0855 | 37.781877214323 | -122.439187476292 | (37.781877214323, -122.439187476292) | |||
| 67216 | 67216 | 140746 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001281.788 | 2113047.9683 | 37.7820987201541 | -122.439228398563 | (37.7820987201541, -122.439228398563) | |||
| 135416 | 135416 | 141317 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001294.3096 | 2112929.1823 | 37.781773276597 | -122.439176563192 | (37.781773276597, -122.439176563192) | |||
| 148363 | 148363 | 141316 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001298.7091 | 2112910.2306 | 37.781721490399605 | -122.439159984285 | (37.7817214903996, -122.439159984285) | |||
| 159298 | 159298 | 141318 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001293.2943 | 2112947.457 | 37.781823396493394 | -122.439181385856 | (37.7818233964934, -122.439181385856) | |||
| 182395 | 182395 | 140747 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001275.0195 | 2113083.841 | 37.7821968322814 | -122.43925438646299 | (37.7821968322814, -122.439254386463) | |||
| 67330 | 67330 | 220407 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009368.17271 | 2108071.27488 | 37.7688907199643 | -122.410901456736 | (37.7688907199643, -122.410901456736) |
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");