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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81662 | 81662 | 115444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 97297 | 97297 | 115442 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 112326 | 112326 | 115441 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 113661 | 113661 | 115440 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 115493 | 115493 | 115443 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 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) | |||
| 85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 104809 | 104809 | 116896 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 998X KIRKHAM ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991857.0 | 2105283.0 | 37.760237390046704 | -122.471267663471 | (37.7602373900467, -122.471267663471) | ||||
| 125344 | 125344 | 116895 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 998X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991857.0 | 2105283.0 | 37.760237390046704 | -122.471267663471 | (37.7602373900467, -122.471267663471) | ||||
| 9882 | 9882 | 173729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 154189 | 154189 | 247416 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 991 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001894.4537 | 2109427.399 | 37.7721923905385 | -122.43684958992901 | (37.7721923905385, -122.436849589929) | |||
| 132566 | 132566 | 203830 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 990 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5995335.27016 | 2094553.61244 | 37.730977754916 | -122.45846137648998 | (37.730977754916, -122.45846137649) | ||||
| 43424 | 43424 | 140778 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000008.8144 | 2112798.5514 | 37.78134136570179 | -122.44361437311599 | (37.7813413657018, -122.443614373116) | |||
| 42983 | 42983 | 30852 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 100372 | 100372 | 30856 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 104646 | 104646 | 30855 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 140019 | 140019 | 30857 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 140989 | 140989 | 30854 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 141603 | 141603 | 30853 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 71572 | 71572 | 203997 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 Merced Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994838.45589 | 2099724.9238 | 37.745148334641 | -122.460553522421 | (37.745148334641, -122.460553522421) | |||
| 103795 | 103795 | 92788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | |||
| 62277 | 62277 | 250545 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5987996.344380001 | 2115386.3423900004 | 37.7877542741995 | -122.485361078263 | (37.7877542741995, -122.485361078263) | |||
| 79584 | 79584 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 103243 | 103243 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 107871 | 107871 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 139135 | 139135 | 112417 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98X BROADMOOR DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 5990934.0 | 2093194.0 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | |||
| 18902 | 18902 | 2171 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 980X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6001393.407000001 | 2109056.2142 | 37.771144720167705 | -122.43855614944799 | (37.7711447201677, -122.438556149448) | |||
| 156682 | 156682 | 175042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 San Diego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | ||||
| 10124 | 10124 | 173862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999618.0 | 2107794.0 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | ||||
| 159067 | 159067 | 187733 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 97 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6016669.5568699995 | 2095074.42086 | 37.7336107684215 | -122.384740724326 | (37.7336107684215, -122.384740724326) | |||
| 186826 | 186826 | 187734 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 97 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6016672.472159999 | 2095023.0659400001 | 37.7334699192814 | -122.384727069019 | (37.7334699192814, -122.384727069019) | |||
| 32675 | 32675 | 125260 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 962 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6008370.79579 | 2119332.90352 | 37.799756458059 | -122.415148587839 | (37.799756458059, -122.415148587839) | |||
| 67831 | 67831 | 188723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013346.445730001 | 2089388.2762799999 | 37.717813418545205 | -122.39583146685499 | (37.7178134185452, -122.395831466855) | ||||
| 152170 | 152170 | 188724 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013382.05808 | 2089359.66984 | 37.7177368520568 | -122.395706366661 | (37.7177368520568, -122.395706366661) | ||||
| 84837 | 84837 | 24174 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 95X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | |||
| 100171 | 100171 | 24182 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 95X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | |||
| 122978 | 122978 | 24169 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 95X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x6 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | |||
| 47154 | 47154 | 203685 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 959 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5991882.496280001 | 2105197.7773599997 | 37.7600048659563 | -122.471173275634 | (37.7600048659563, -122.471173275634) | |||
| 71784 | 71784 | 203686 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 959 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991902.66845 | 2105197.58333 | 37.7600054999736 | -122.471103496339 | (37.7600054999736, -122.471103496339) | |||
| 171808 | 171808 | 203687 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 959 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991923.80205 | 2105198.98577 | 37.760010573041896 | -122.471030508255 | (37.7600105730419, -122.471030508255) | |||
| 74583 | 74583 | 125259 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 956 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008388.69953 | 2119336.7815799997 | 37.7997681123759 | -122.41508690874599 | (37.7997681123759, -122.415086908746) | |||
| 41350 | 41350 | 203862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 951 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5991278.5837 | 2090872.19555 | 37.7206355315929 | -122.472217633157 | (37.7206355315929, -122.472217633157) | |||
| 76210 | 76210 | 218201 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 950 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5993067.47845 | 2098384.4578299997 | 37.7413657105616 | -122.466579789523 | (37.7413657105616, -122.466579789523) | |||
| 157946 | 157946 | 203688 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 950 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5991858.41058 | 2105254.40313 | 37.7601589521859 | -122.471260701418 | (37.7601589521859, -122.471260701418) | |||
| 36573 | 36573 | 203963 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 95 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993055.09065 | 2098419.62465 | 37.7414615549015 | -122.46662517742901 | (37.7414615549015, -122.466625177429) | |||
| 130106 | 130106 | 203964 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 95 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993057.74173 | 2098432.01976 | 37.7414957417343 | -122.466616911738 | (37.7414957417343, -122.466616911738) | |||
| 67675 | 67675 | 125287 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 945 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6008576.87154 | 2118976.92053 | 37.798790596063206 | -122.414410284916 | (37.7987905960632, -122.414410284916) | ||||
| 110309 | 110309 | 116003 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 945 FRONT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | 6012663.0 | 2119386.0 | 37.8001425245044 | -122.40029961366501 | (37.8001425245044, -122.400299613665) | ||
| 172088 | 172088 | 125288 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 943 Green St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.41407270821101 | (37.7988459853112, -122.414072708211) | ||||
| 75430 | 75430 | 125286 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 941 Vallejo St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008909.00848 | 2118677.12072 | 37.797986072467204 | -122.413239767796 | (37.7979860724672, -122.413239767796) | ||||
| 57654 | 57654 | 246248 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 94 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999664.5107 | 2107772.1777 | 37.7675205800989 | -122.44444414881399 | (37.7675205800989, -122.444444148814) | |||
| 159663 | 159663 | 139450 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 934 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6001513.171 | 2111631.5925 | 37.77822287523 | -122.438326416807 | (37.77822287523, -122.438326416807) | |||
| 166054 | 166054 | 142662 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 93 Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6008939.5318 | 2121284.2688 | 37.805146365416896 | -122.413318615775 | (37.8051463654169, -122.413318615775) | |||
| 88900 | 88900 | 100067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | On property line with 99 Buena Vista Ter | 6001505.1 | 2107681.4 | 37.76737617437121 | -122.438071302911 | (37.7673761743712, -122.438071302911) | |||
| 149428 | 149428 | 221379 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001485.45303 | 2107668.90579 | 37.7673407510066 | -122.438138363796 | (37.7673407510066, -122.438138363796) | |||
| 9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 156135 | 156135 | 200237 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 919 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351002 | (37.7182212977035, -122.39160673351) | |||
| 34242 | 34242 | 142663 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008956.5365 | 2121285.8147 | 37.80515156476479 | -122.41325987814301 | (37.8051515647648, -122.413259878143) | |||
| 46008 | 46008 | 187764 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6019412.692980001 | 2093581.83976 | 37.729663759061 | -122.37515338563 | (37.729663759061, -122.37515338563) | ||||
| 137993 | 137993 | 187765 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6019429.17387 | 2093568.53818 | 37.7296281423191 | -122.375095487273 | (37.7296281423191, -122.375095487273) | ||||
| 8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
| 118350 | 118350 | 105142 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Hillway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996094.58438 | 2106700.45244 | 37.764373561312205 | -122.456714459214 | (37.7643735613122, -122.456714459214) | |||||
| 101747 | 101747 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
| 9889 | 9889 | 3743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 906 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 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) | |||
| 53970 | 53970 | 188566 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 901 Iowa St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6014791.61868 | 2102890.82424 | 37.7549689439879 | -122.391779701799 | (37.7549689439879, -122.391779701799) | ||||
| 60507 | 60507 | 188584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710205995 | -122.39978828959299 | (37.756276710206, -122.399788289593) | ||||
| 63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
| 74110 | 74110 | 188585 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012499.61765 | 2103177.92943 | 37.755629771207 | -122.39972630024799 | (37.755629771207, -122.399726300248) | ||||
| 130923 | 130923 | 188582 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.39981880719999 | (37.7565745414011, -122.3998188072) | ||||
| 137116 | 137116 | 188583 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012480.57258 | 2103516.6299400004 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | ||||
| 146596 | 146596 | 188586 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012501.01622 | 2103043.06832 | 37.755259550009896 | -122.399711994725 | (37.7552595500099, -122.399711994725) | ||||
| 147407 | 147407 | 188588 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 57 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | ||||
| 155305 | 155305 | 188580 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012471.14702 | 2103650.00365 | 37.7569243965657 | -122.399857908838 | (37.7569243965657, -122.399857908838) | ||||
| 166461 | 166461 | 188581 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012475.30485 | 2103528.81943 | 37.75659188303771 | -122.39983502019 | (37.7565918830377, -122.39983502019) | ||||
| 83174 | 83174 | 111552 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 141167 | 141167 | 111532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 143355 | 143355 | 111556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 18289 | 18289 | 5540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005033.64005 | 2102782.9896400003 | 37.7541263358861 | -122.425517912248 | (37.7541263358861, -122.425517912248) | |||
| 21468 | 21468 | 5532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005017.6668300005 | 2103067.07529 | 37.7549054662318 | -122.42559336895599 | (37.7549054662318, -122.425593368956) | |||
| 162928 | 162928 | 125289 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Green St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008651.45364 | 2119007.8784 | 37.7988797881271 | -122.414154397206 | (37.7988797881271, -122.414154397206) | ||||
| 49334 | 49334 | 220209 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005038.30793 | 2102756.62564 | 37.7540542102343 | -122.42549989342399 | (37.7540542102343, -122.425499893424) | |||
| 15525 | 15525 | 3745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Carolina St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.39989224135799 | (37.7569915030708, -122.399892241358) | |||
| 97293 | 97293 | 55547 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 90- 92 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1972 12:00:00 AM | Permit Number 11515 | 6000515.5 | 2104940.8 | 37.759794835822 | -122.44129751840201 | (37.759794835822, -122.441297518402) | |||
| 174779 | 174779 | 142641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 90 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008933.8636 | 2121305.911 | 37.805205471231105 | -122.413339762783 | (37.8052054712311, -122.413339762783) | |||
| 186248 | 186248 | 220313 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 90 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6000504.24211 | 2104917.08566 | 37.7597290807509 | -122.44133475221201 | (37.7597290807509, -122.441334752212) | |||
| 169832 | 169832 | 203866 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996236.4849 | 2090473.9124900002 | 37.7198276211289 | -122.455051057381 | (37.7198276211289, -122.455051057381) | |||
| 174329 | 174329 | 203919 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Hillway Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5996077.658919999 | 2106538.2502599997 | 37.763927223976005 | -122.456761267518 | (37.763927223976, -122.456761267518) | |||
| 35992 | 35992 | 203867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5995596.425009999 | 2089995.66595 | 37.7184777288524 | -122.45722892757401 | (37.7184777288524, -122.457228927574) | |||
| 51801 | 51801 | 203869 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995595.19547 | 2089971.4511099998 | 37.7184111700071 | -122.45723142680401 | (37.7184111700071, -122.457231426804) | |||
| 57390 | 57390 | 203868 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995595.3460099995 | 2089978.64807 | 37.7184309398048 | -122.457231426799 | (37.7184309398048, -122.457231426799) | |||
| 163702 | 163702 | 203870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995594.9546 | 2089959.9355900001 | 37.718379537275894 | -122.45723142680401 | (37.7183795372759, -122.457231426804) | |||
| 163854 | 163854 | 203872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995594.11167 | 2089942.67302 | 37.7183320899249 | -122.457233092344 | (37.7183320899249, -122.457233092344) | |||
| 164225 | 164225 | 203871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 Granada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995594.53815 | 2089951.54412 | 37.718356472363794 | -122.45723225957799 | (37.7183564723638, -122.457232259578) | |||
| 38647 | 38647 | 122188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 9 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 7ft | 5991455.25466 | 2115068.89976 | 37.7870835661247 | -122.473370861161 | (37.7870835661247, -122.473370861161) | |||
| 158460 | 158460 | 142664 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 89 Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008968.9034 | 2121287.3605 | 37.80515650344 | -122.41321719022 | (37.80515650344, -122.41321719022) | |||
| 72439 | 72439 | 140779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 89 Terra Vista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000037.9186 | 2112803.9662 | 37.781357893205204 | -122.443514076205 | (37.7813578932052, -122.443514076205) |
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");