trees
3,965 rows where qSpecies_id = 70 sorted by qAddress descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92681 | 115442 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
95648 | 115441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
137554 | 115443 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
150284 | 115440 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
156023 | 115444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
47175 | 24120 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016647.77235 | 2095170.83896 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | 10 | 3 | 8 | 58 | 1 | |||
62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 | |||||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
24114 | 116895 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
124474 | 116896 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
27485 | 173729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
192871 | 173728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
71191 | 247416 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 991 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001894.4537 | 2109427.399 | 37.7721923905385 | -122.436849589929 | (37.7721923905385, -122.436849589929) | 15 | 5 | 11 | 29492 | 9 | |||
104694 | 203830 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 990 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5995335.27016 | 2094553.61244 | 37.730977754916 | -122.45846137649 | (37.730977754916, -122.45846137649) | 9 | 7 | 4 | 59 | 40 | ||||
87779 | 140778 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000008.8144 | 2112798.5514 | 37.7813413657018 | -122.443614373116 | (37.7813413657018, -122.443614373116) | 15 | 5 | 1 | 29490 | 16 | |||
7482 | 30852 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
103924 | 30856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
117900 | 30855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
175870 | 30854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
182952 | 30857 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
186981 | 30853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
152964 | 203997 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Merced Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994838.45589 | 2099724.9238 | 37.745148334641 | -122.460553522421 | (37.745148334641, -122.460553522421) | 1 | 8 | 4 | 59 | 40 | |||
104618 | 92788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | 15 | 5 | 5 | 29492 | 3 | |||
88901 | 250545 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 5ft | 5987996.34438 | 2115386.34239 | 37.7877542741995 | -122.485361078263 | (37.7877542741995, -122.485361078263) | 11 | 6 | 1 | 55 | 33 | |||
33143 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
54660 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
96610 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
122222 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
179210 | 112417 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 98X BROADMOOR DR | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | |||
91123 | 2171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 980X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001393.407 | 2109056.2142 | 37.7711447201677 | -122.438556149448 | (37.7711447201677, -122.438556149448) | 15 | 5 | 11 | 29492 | 9 | |||
81179 | 175042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 98 San Diego Ave | 1 | Front Yard : Yard | Tree | Private 2 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | 9 | 8 | 6 | 28588 | 25 | ||||
86322 | 173862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999618 | 2107794 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | 15 | 5 | 11 | 29492 | 9 | ||||
30744 | 187733 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6016669.55687 | 2095074.42086 | 37.7336107684215 | -122.384740724326 | (37.7336107684215, -122.384740724326) | 10 | 3 | 8 | 58 | 1 | |||
79885 | 187734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 97 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6016672.47216 | 2095023.06594 | 37.7334699192814 | -122.384727069019 | (37.7334699192814, -122.384727069019) | 10 | 3 | 8 | 58 | 1 | |||
24470 | 125260 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 962 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6008372 | 2119361 | 37.7998336716629 | -122.415146410717 | (37.7998336716629, -122.415146410717) | 5 | 1 | 10 | 308 | 32 | |||
30644 | 188724 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 961 Le Conte Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013382.05808 | 2089359.66984 | 37.7177368520568 | -122.395706366661 | (37.7177368520568, -122.395706366661) | 10 | 3 | 8 | 58 | 1 | ||||
44628 | 188723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013346.44573 | 2089388.27628 | 37.7178134185452 | -122.395831466855 | (37.7178134185452, -122.395831466855) | 10 | 3 | 8 | 58 | 1 | ||||
76219 | 24174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
104714 | 24182 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
161053 | 24169 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x6 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
122524 | 203687 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 959 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991923.80205 | 2105198.98577 | 37.7600105730419 | -122.471030508255 | (37.7600105730419, -122.471030508255) | 1 | 8 | 4 | 56 | 12 | |||
150771 | 203686 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 959 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5991902.66845 | 2105197.58333 | 37.7600054999736 | -122.471103496339 | (37.7600054999736, -122.471103496339) | 1 | 8 | 4 | 56 | 12 | |||
174854 | 203685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 959 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5991882.49628 | 2105197.77736 | 37.7600048659563 | -122.471173275634 | (37.7600048659563, -122.471173275634) | 1 | 8 | 4 | 56 | 12 | |||
34294 | 125259 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 956 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008388.69953 | 2119336.78158 | 37.7997681123759 | -122.415086908746 | (37.7997681123759, -122.415086908746) | 5 | 1 | 10 | 308 | 32 | |||
156844 | 203862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 951 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5991278.5837 | 2090872.19555 | 37.7206355315929 | -122.472217633157 | (37.7206355315929, -122.472217633157) | 9 | 8 | 6 | 64 | 24 | |||
8880 | 218201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 950 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 2ft | 5993067.47845 | 2098384.45783 | 37.7413657105616 | -122.466579789523 | (37.7413657105616, -122.466579789523) | 1 | 8 | 4 | 59 | 40 | |||
193373 | 203688 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 950 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5991858.41058 | 2105254.40313 | 37.7601589521859 | -122.471260701418 | (37.7601589521859, -122.471260701418) | 1 | 8 | 4 | 56 | 12 | |||
24181 | 203963 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993055.09065 | 2098419.62465 | 37.7414615549015 | -122.466625177429 | (37.7414615549015, -122.466625177429) | 1 | 8 | 4 | 59 | 40 | |||
36422 | 203964 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993057.74173 | 2098432.01976 | 37.7414957417343 | -122.466616911738 | (37.7414957417343, -122.466616911738) | 1 | 8 | 4 | 59 | 40 | |||
74587 | 258628 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95 Banks St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6008696 | 2098147 | 37.7416031915622 | -122.412524842458 | (37.7416031915622, -122.412524842458) | 10 | 7 | 7 | 28859 | 2 | ||||
121173 | 125287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 945 Green St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6008576.87154 | 2118976.92053 | 37.7987905960632 | -122.414410284916 | (37.7987905960632, -122.414410284916) | 5 | 1 | 10 | 308 | 21 | ||||
147671 | 116003 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 945 FRONT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | 3x3 | 6012663 | 2119386 | 37.8001425245044 | -122.400299613665 | (37.8001425245044, -122.400299613665) | 3 | 1 | 10 | 28860 | 6 | ||
458 | 125288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 943 Green St | 11 | Side Yard : Yard | Tree | Private 2 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.414072708211 | (37.7988459853112, -122.414072708211) | 5 | 1 | 10 | 308 | 21 | ||||
28670 | 125286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 941 Vallejo St | 6 | Front Yard : Yard | Tree | Private 2 | 11 | 6008909.00848 | 2118677.12072 | 37.7979860724672 | -122.413239767796 | (37.7979860724672, -122.413239767796) | 3 | 1 | 10 | 308 | 21 | ||||
7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
167126 | 246248 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999664.5107 | 2107772.1777 | 37.7675205800989 | -122.444444148814 | (37.7675205800989, -122.444444148814) | 15 | 5 | 11 | 29492 | 9 | |||
161028 | 139450 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 934 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6001513.171 | 2111631.5925 | 37.77822287523 | -122.438326416807 | (37.77822287523, -122.438326416807) | 15 | 5 | 11 | 29490 | 41 | |||
61875 | 142662 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 93 Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6008939.5318 | 2121284.2688 | 37.8051463654169 | -122.413318615775 | (37.8051463654169, -122.413318615775) | 3 | 1 | 10 | 308 | 23 | |||
72037 | 100067 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | On property line with 99 Buena Vista Ter | 6001505.1 | 2107681.4 | 37.7673761743712 | -122.438071302911 | (37.7673761743712, -122.438071302911) | 15 | 5 | 5 | 29492 | 3 | |||
106245 | 221379 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001485.45303 | 2107668.90579 | 37.7673407510066 | -122.438138363796 | (37.7673407510066, -122.438138363796) | 15 | 5 | 5 | 29492 | 3 | |||
90425 | 173719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 922 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012422 | 2103621 | 37.7568420188621 | -122.400025841962 | (37.7568420188621, -122.400025841962) | 10 | 3 | 8 | 28856 | 29 | |||
185980 | 200237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 919 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351 | (37.7182212977035, -122.39160673351) | 10 | 3 | 8 | 58 | 1 | |||
56732 | 142663 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 91 Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008956.5365 | 2121285.8147 | 37.8051515647648 | -122.413259878143 | (37.8051515647648, -122.413259878143) | 3 | 1 | 10 | 308 | 23 | |||
121059 | 187765 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 91 Kiska Rd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6019429.17387 | 2093568.53818 | 37.7296281423191 | -122.375095487273 | (37.7296281423191, -122.375095487273) | 10 | 3 | 8 | 58 | 1 | ||||
144674 | 187764 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 91 Kiska Rd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6019412.69298 | 2093581.83976 | 37.729663759061 | -122.37515338563 | (37.729663759061, -122.37515338563) | 10 | 3 | 8 | 58 | 1 | ||||
153351 | 14425 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90X Masonic Ave | 1 | Median : Cutout | Tree | DPW 1 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.7817254541344 | -122.447548220181 | (37.7817254541344, -122.447548220181) | 15 | 5 | 2 | 54 | 16 | |||
166796 | 105142 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 90X Hillway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996094.58438 | 2106700.45244 | 37.7643735613122 | -122.456714459214 | (37.7643735613122, -122.456714459214) | 15 | 5 | 11 | 29492 | 12 | |||||
194496 | 265137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90X Broadmoor Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x6 | 5991049 | 2093460 | 37.7277277099678 | -122.47319985648 | (37.7277277099678, -122.47319985648) | 9 | 8 | 4 | 64 | 40 | ||||
110004 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6009441 | 2103786 | 37.7571284172194 | -122.410346937481 | (37.7571284172194, -122.410346937481) | 2 | 4 | 7 | 28859 | 19 | |||
83191 | 3743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 906 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 18 | 18 | 6012418 | 2103694 | 37.7570422378388 | -122.400044801952 | (37.7570422378388, -122.400044801952) | 10 | 3 | 8 | 28856 | 29 | |||
135909 | 11755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 901X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X4 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
108941 | 188566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 901 Iowa St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6014791.61868 | 2102890.82424 | 37.7549689439879 | -122.391779701799 | (37.7549689439879, -122.391779701799) | 10 | 3 | 8 | 28856 | 29 | ||||
74538 | 188584 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 28 | Median : Yard | Tree | DPW 1 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710206 | -122.399788289593 | (37.756276710206, -122.399788289593) | 10 | 3 | 8 | 28856 | 29 | ||||
83416 | 188587 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 55 | Median : Yard | Tree | DPW 1 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | 10 | 3 | 8 | 28856 | 29 | ||||
101226 | 188582 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 19 | Median : Yard | Tree | DPW 1 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.3998188072 | (37.7565745414011, -122.3998188072) | 10 | 3 | 8 | 28856 | 29 | ||||
109408 | 188585 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 36 | Median : Yard | Tree | DPW 1 | 10 | 6012499.61765 | 2103177.92943 | 37.755629771207 | -122.399726300248 | (37.755629771207, -122.399726300248) | 10 | 3 | 8 | 28856 | 29 | ||||
118371 | 188588 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 57 | Median : Yard | Tree | DPW 1 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | 10 | 3 | 8 | 28856 | 29 | ||||
120144 | 188583 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 20 | Median : Yard | Tree | DPW 1 | 5 | 6012480.57258 | 2103516.62994 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | 10 | 3 | 8 | 28856 | 29 | ||||
125545 | 188586 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 45 | Median : Yard | Tree | DPW 1 | 18 | 6012501.01622 | 2103043.06832 | 37.7552595500099 | -122.399711994725 | (37.7552595500099, -122.399711994725) | 10 | 3 | 8 | 28856 | 29 | ||||
139858 | 188580 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 6 | Median : Yard | Tree | DPW 1 | 11 | 6012471.14702 | 2103650.00365 | 37.7569243965657 | -122.399857908838 | (37.7569243965657, -122.399857908838) | 10 | 3 | 8 | 28856 | 29 | ||||
161741 | 188581 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x Carolina St | 18 | Median : Yard | Tree | DPW 1 | 5 | 6012475.30485 | 2103528.81943 | 37.7565918830377 | -122.39983502019 | (37.7565918830377, -122.39983502019) | 10 | 3 | 8 | 28856 | 29 | ||||
51614 | 111552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 30 | Front Yard : Yard | Tree | DPW 1 | 6 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
173671 | 111532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 10 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
187412 | 111556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 34 | Front Yard : Yard | Tree | DPW 1 | 6 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
73716 | 5540 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900X Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6005033.64005 | 2102782.98964 | 37.7541263358861 | -122.425517912248 | (37.7541263358861, -122.425517912248) | 2 | 4 | 5 | 28862 | 22 | |||
152135 | 5532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005017.66683 | 2103067.07529 | 37.7549054662318 | -122.425593368956 | (37.7549054662318, -122.425593368956) | 2 | 4 | 5 | 28862 | 22 | |||
188011 | 125289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900 Green St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6008651.45364 | 2119007.8784 | 37.7988797881271 | -122.414154397206 | (37.7988797881271, -122.414154397206) | 5 | 1 | 10 | 308 | 32 | ||||
126951 | 220209 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900 Dolores St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005038.30793 | 2102756.62564 | 37.7540542102343 | -122.425499893424 | (37.7540542102343, -122.425499893424) | 2 | 4 | 5 | 28862 | 22 | |||
116637 | 3745 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900 Carolina St | 4 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.399892241358 | (37.7569915030708, -122.399892241358) | 10 | 3 | 8 | 28856 | 29 | |||
82582 | 55547 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 90- 92 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11515 | 6000515.5 | 2104940.8 | 37.759794835822 | -122.441297518402 | (37.759794835822, -122.441297518402) | 2 | 4 | 5 | 28862 | 3 | |||
51179 | 142641 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008933.8636 | 2121305.911 | 37.8052054712311 | -122.413339762783 | (37.8052054712311, -122.413339762783) | 3 | 1 | 10 | 308 | 23 | |||
145845 | 220313 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000504.24211 | 2104917.08566 | 37.7597290807509 | -122.441334752212 | (37.7597290807509, -122.441334752212) | 2 | 4 | 5 | 28862 | 3 | |||
96067 | 203866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996236.4849 | 2090473.91249 | 37.7198276211289 | -122.455051057381 | (37.7198276211289, -122.455051057381) | 9 | 8 | 6 | 28861 | 24 | |||
135415 | 203919 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Hillway Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5996077.65892 | 2106538.25026 | 37.763927223976 | -122.456761267518 | (37.763927223976, -122.456761267518) | 15 | 5 | 11 | 29492 | 12 | |||
48689 | 203870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995594.9546 | 2089959.93559 | 37.7183795372759 | -122.457231426804 | (37.7183795372759, -122.457231426804) | 9 | 8 | 6 | 28861 | 24 | |||
118961 | 203872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995594.11167 | 2089942.67302 | 37.7183320899249 | -122.457233092344 | (37.7183320899249, -122.457233092344) | 9 | 8 | 6 | 28861 | 24 | |||
147113 | 203867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5995596.42501 | 2089995.66595 | 37.7184777288524 | -122.457228927574 | (37.7184777288524, -122.457228927574) | 9 | 8 | 6 | 28861 | 24 | |||
154192 | 203868 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995595.34601 | 2089978.64807 | 37.7184309398048 | -122.457231426799 | (37.7184309398048, -122.457231426799) | 9 | 8 | 6 | 28861 | 24 | |||
163400 | 203871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995594.53815 | 2089951.54412 | 37.7183564723638 | -122.457232259578 | (37.7183564723638, -122.457232259578) | 9 | 8 | 6 | 28861 | 24 | |||
190858 | 203869 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995595.19547 | 2089971.45111 | 37.7184111700071 | -122.457231426804 | (37.7184111700071, -122.457231426804) | 9 | 8 | 6 | 28861 | 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );