trees
3,965 rows where qSpecies_id = 70 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128434 | 10359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1060 HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X4 | 6001056 | 2109004 | 37.770982153968 | -122.439719505856 | (37.770982153968, -122.439719505856) | 15 | 5 | 11 | 29492 | 9 | |||
152722 | 188721 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1062 Key Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Width 5ft | 6013117.817 | 2089964.07481 | 37.7193817246629 | -122.396662082497 | (37.7193817246629, -122.396662082497) | 10 | 3 | 8 | 58 | 1 | |||
82149 | 125252 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1067 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008499.87029 | 2118254.27562 | 37.7968020664151 | -122.414625569117 | (37.7968020664151, -122.414625569117) | 5 | 1 | 10 | 308 | 21 | |||
111417 | 112832 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1068x BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6008436 | 2118271 | 37.7968443988369 | -122.414847760064 | (37.7968443988369, -122.414847760064) | 5 | 1 | 10 | 308 | 21 | |||
131926 | 125250 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1073 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008472.63138 | 2118248.82998 | 37.796785583654 | -122.414719436774 | (37.796785583654, -122.414719436774) | 5 | 1 | 10 | 308 | 21 | |||
166441 | 125251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1073 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008484.56321 | 2118250.48158 | 37.7967907889218 | -122.414678266696 | (37.7967907889218, -122.414678266696) | 5 | 1 | 10 | 308 | 21 | |||
149578 | 3765 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1074 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 15 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
21537 | 220207 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 108 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008584.43652 | 2099064.66412 | 37.7441166332796 | -122.41297546067 | (37.7441166332796, -122.41297546067) | 2 | 7 | 7 | 28859 | 2 | |||
154443 | 220206 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 108 Ripley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008609.11441 | 2099067.28064 | 37.7441252029124 | -122.412890314643 | (37.7441252029124, -122.412890314643) | 2 | 7 | 7 | 28859 | 2 | |||
98161 | 10360 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1080 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6000968.2773 | 2109001.3276 | 37.7709698227664 | -122.440022748836 | (37.7709698227664, -122.440022748836) | 15 | 5 | 11 | 29492 | 9 | |||
85312 | 175074 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1082 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 6001979.9665 | 2087165.3446 | 37.7110708522134 | -122.434961389078 | (37.7110708522134, -122.434961389078) | 9 | 7 | 6 | 28861 | 5 | |||
124396 | 175075 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1082 Munich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 6001955.35702 | 2087155.69226 | 37.7110429516559 | -122.435045755382 | (37.7110429516559, -122.435045755382) | 9 | 7 | 6 | 28861 | 5 | |||
149119 | 125248 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1085 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008437.94949 | 2118244.01061 | 37.7967704021933 | -122.41483910324 | (37.7967704021933, -122.41483910324) | 5 | 1 | 10 | 308 | 21 | |||
102128 | 121403 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1089 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6015119.7462 | 2089795.6867 | 37.7190305799817 | -122.389730343556 | (37.7190305799817, -122.389730343556) | 10 | 3 | 8 | 58 | 1 | |||
56125 | 205134 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 109 Alton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5993812.60655 | 2101635.72897 | 37.7503358499157 | -122.46423940104 | (37.7503358499157, -122.46423940104) | 1 | 8 | 4 | 29491 | 40 | |||
179266 | 116959 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1090x KEY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013239 | 2090033 | 37.719577723269 | -122.396248023097 | (37.719577723269, -122.396248023097) | 10 | 3 | 8 | 58 | 1 | ||||
76807 | 7879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1095X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006012.62101 | 2113826.37447 | 37.7845041008944 | -122.422917178661 | (37.7845041008944, -122.422917178661) | 7 | 9 | 11 | 28858 | 41 | |||
108215 | 7877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1095X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006012.62101 | 2113826.37447 | 37.7845041008944 | -122.422917178661 | (37.7845041008944, -122.422917178661) | 7 | 9 | 11 | 28858 | 41 | |||
192134 | 3768 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1098 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
32701 | 247931 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | 10 | 7 | 7 | 28859 | 2 | ||||
137784 | 247934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099 Esmeralda Ave | 7 | Side Yard : Yard | Tree | Private 2 | 14 | 6010311.02519 | 2098743.98721 | 37.7433328939103 | -122.406982672633 | (37.7433328939103, -122.406982672633) | 10 | 7 | 7 | 28859 | 2 | ||||
143828 | 188599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012848.11967 | 2102532.63168 | 37.753877345082 | -122.398475784828 | (37.753877345082, -122.398475784828) | 10 | 3 | 8 | 28856 | 29 | ||||
102160 | 117527 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099x WALLER ST | 1 | Front Yard : Yard | Tree | Private 2 | 6000071 | 2108311 | 37.769023235971 | -122.44307686155 | (37.769023235971, -122.44307686155) | 15 | 5 | 5 | 29492 | 9 | |||||
57232 | 100838 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
159964 | 100837 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
24488 | 220241 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10x Benton Ave | 3 | Median : Yard | Tree | DPW 1 | 42 | 6004791.23434 | 2095030.36311 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | 2 | 7 | 7 | 28861 | 2 | ||||
42535 | 122128 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 5ft | 5990802.7595 | 2114921.63237 | 37.7866414061123 | -122.475617569247 | (37.7866414061123, -122.475617569247) | 11 | 6 | 1 | 54 | 33 | |||
127163 | 122129 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5990801.21404 | 2114943.98839 | 37.7867026998997 | -122.475624549155 | (37.7867026998997, -122.475624549155) | 11 | 6 | 1 | 54 | 33 | |||
190688 | 34955 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38552 | 5990784 | 2114938 | 37.786685259507 | -122.475683667555 | (37.786685259507, -122.475683667555) | 11 | 6 | 1 | 54 | 33 | ||||
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
24057 | 175026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011082.6747 | 2087261.47183 | 37.7118474464748 | -122.403506811807 | (37.7118474464748, -122.403506811807) | 9 | 7 | 8 | 309 | 39 | |||
38134 | 175024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011045.77873 | 2087277.95122 | 37.7118906346058 | -122.403635493987 | (37.7118906346058, -122.403635493987) | 9 | 7 | 8 | 309 | 39 | |||
58144 | 175023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011015.66047 | 2087294.85448 | 37.7119353650883 | -122.403740780316 | (37.7119353650883, -122.403740780316) | 9 | 7 | 8 | 309 | 39 | |||
88347 | 175022 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010987.76373 | 2087310.02713 | 37.7119754676783 | -122.403838266825 | (37.7119754676783, -122.403838266825) | 9 | 7 | 8 | 309 | 39 | |||
95095 | 175025 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011065.88407 | 2087267.99252 | 37.7118644130932 | -122.403565303698 | (37.7118644130932, -122.403565303698) | 9 | 7 | 8 | 309 | 39 | |||
156300 | 175021 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010965.97825 | 2087320.58179 | 37.7120032315468 | -122.403914306301 | (37.7120032315468, -122.403914306301) | 9 | 7 | 8 | 309 | 39 | |||
51177 | 221409 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Thor Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6002231.18225 | 2096094.99891 | 37.735603938579 | -122.434731265154 | (37.735603938579, -122.434731265154) | 2 | 7 | 5 | 63 | 7 | |||
11723 | 93875 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997572 | 2107825 | 37.7675460011803 | -122.451685641377 | (37.7675460011803, -122.451685641377) | 15 | 5 | 11 | 29492 | 9 | |||||
111326 | 124890 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5996111.85979 | 2115830.13955 | 37.7894422702032 | -122.457315229218 | (37.7894422702032, -122.457315229218) | 11 | 6 | 1 | 54 | 31 | |||
39912 | 88823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51710 | 5998275 | 2110294 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | 15 | 5 | 11 | 29492 | 16 | ||||
116949 | 220305 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003546.60789 | 2105097.64138 | 37.7603976862105 | -122.430825603935 | (37.7603976862105, -122.430825603935) | 2 | 4 | 5 | 28862 | 3 | |||
111012 | 139642 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 DIVISADERO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6001425.6172 | 2112241.3399 | 37.779892106987 | -122.438672999264 | (37.779892106987, -122.438672999264) | 15 | 5 | 11 | 29490 | 41 | |||
117971 | 5234 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001436.83253 | 2112303.93811 | 37.7800646238097 | -122.438638687165 | (37.7800646238097, -122.438638687165) | 15 | 5 | 11 | 29490 | 41 | |||
137229 | 5240 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001405.3119 | 2112421.3803 | 37.7803852970972 | -122.438756149045 | (37.7803852970972, -122.438756149045) | 15 | 5 | 11 | 29490 | 41 | |||
18026 | 175051 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991233.90488 | 2088989.0818 | 37.7154623775575 | -122.472234874046 | (37.7154623775575, -122.472234874046) | 1 | 8 | 4 | 64 | 14 | |||
41158 | 175050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991220.94101 | 2089033.65994 | 37.7155840279702 | -122.472282930219 | (37.7155840279702, -122.472282930219) | 1 | 8 | 4 | 64 | 14 | |||
48049 | 175052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991243.24078 | 2088948.27208 | 37.715350864326 | -122.472199632304 | (37.715350864326, -122.472199632304) | 1 | 8 | 4 | 64 | 14 | |||
143891 | 175053 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 3ft | 5991263.57125 | 2088857.38752 | 37.7151024940541 | -122.472122741173 | (37.7151024940541, -122.472122741173) | 1 | 8 | 4 | 64 | 14 | |||
80573 | 203690 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991410.69594 | 2105237.51163 | 37.7600866646964 | -122.472807886998 | (37.7600866646964, -122.472807886998) | 1 | 8 | 4 | 56 | 12 | |||
113416 | 203689 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991422.53777 | 2105238.18561 | 37.7600892007797 | -122.472766981313 | (37.7600892007797, -122.472766981313) | 1 | 8 | 4 | 56 | 12 | |||
49610 | 6423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6018250.03314 | 2096623.41897 | 37.7379512950012 | -122.379384062749 | (37.7379512950012, -122.379384062749) | 10 | 3 | 8 | 58 | 1 | |||
58804 | 6420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | 10 | 3 | 8 | 58 | 1 | ||
129789 | 6435 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
146547 | 6431 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018097.17297 | 2096735.752 | 37.7382513079456 | -122.379920384224 | (37.7382513079456, -122.379920384224) | 10 | 3 | 8 | 58 | 1 | |||
159877 | 6443 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
164322 | 6428 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 6 | 3x3 | 6018145.74781 | 2096700.42192 | 37.7381569780515 | -122.379749980697 | (37.7381569780515, -122.379749980697) | 10 | 3 | 8 | 58 | 1 | ||
174265 | 6429 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018128.86285 | 2096712.12629 | 37.7381881845457 | -122.379809174075 | (37.7381881845457, -122.379809174075) | 10 | 3 | 8 | 58 | 1 | |||
187020 | 6432 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
102561 | 111074 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991438 | 2105265 | 37.7601637210649 | -122.472715460505 | (37.7601637210649, -122.472715460505) | 1 | 8 | 4 | 56 | 12 | ||||
166125 | 111075 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X KIRKHAM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991438 | 2105265 | 37.7601637210649 | -122.472715460505 | (37.7601637210649, -122.472715460505) | 1 | 8 | 4 | 56 | 12 | ||||
26139 | 253819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100x Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001057 | 2086858 | 37.7101745029318 | -122.43812937572 | (37.7101745029318, -122.43812937572) | 9 | 7 | 6 | 28861 | 5 | |||||
40260 | 14571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | 15 | 5 | 11 | 29492 | 9 | |||
68580 | 137556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6002303 | 2112450 | 37.7805149085363 | -122.435652679377 | (37.7805149085363, -122.435652679377) | 15 | 5 | 11 | 29490 | 41 | |||
69388 | 137558 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6002303 | 2112450 | 37.7805149085363 | -122.435652679377 | (37.7805149085363, -122.435652679377) | 15 | 5 | 11 | 29490 | 41 | |||
6421 | 220173 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 37 | Front Yard : Yard | Tree | Private 2 | 16 | 6004965.33197 | 2096549.91203 | 37.7370078737986 | -122.425310617592 | (37.7370078737986, -122.425310617592) | 2 | 7 | 5 | 28859 | 2 | ||||
7786 | 220170 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 13 | 6004937.56248 | 2096542.42817 | 37.7369857558904 | -122.425406096807 | (37.7369857558904, -122.425406096807) | 2 | 7 | 5 | 28859 | 2 | ||||
25606 | 220176 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 41 | Front Yard : Yard | Tree | Private 2 | 7 | 6004978.26443 | 2096560.74559 | 37.7370383509436 | -122.425266674926 | (37.7370383509436, -122.425266674926) | 2 | 7 | 5 | 28859 | 2 | ||||
30617 | 220175 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 40 | Front Yard : Yard | Tree | Private 2 | 17 | 6004976.12829 | 2096559.96941 | 37.7370360990465 | -122.425274005312 | (37.7370360990465, -122.425274005312) | 2 | 7 | 5 | 28859 | 2 | ||||
46939 | 220174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 8 | 6004973.16585 | 2096557.19919 | 37.7370283252818 | -122.425284050737 | (37.7370283252818, -122.425284050737) | 2 | 7 | 5 | 28859 | 2 | ||||
54519 | 220179 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 44 | Front Yard : Yard | Tree | Private 2 | 22 | 6004963.53829 | 2096567.90345 | 37.7370571728501 | -122.42531809906 | (37.7370571728501, -122.42531809906) | 2 | 7 | 5 | 28859 | 2 | ||||
58980 | 220171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 23 | 6004943.37646 | 2096556.00352 | 37.7370233592275 | -122.425386961047 | (37.7370233592275, -122.425386961047) | 2 | 7 | 5 | 28859 | 2 | ||||
60784 | 220162 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 25 | Front Yard : Yard | Tree | Private 2 | 33 | 6004904.25494 | 2096495.99975 | 37.7368563920029 | -122.42551795269 | (37.7368563920029, -122.42551795269) | 2 | 7 | 5 | 28859 | 2 | ||||
81570 | 220168 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 32 | Front Yard : Yard | Tree | Private 2 | 9 | 6004945.76603 | 2096533.5746 | 37.7369619094711 | -122.425377103585 | (37.7369619094711, -122.425377103585) | 2 | 7 | 5 | 28859 | 2 | ||||
93424 | 220182 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 7 | 6004985.47233 | 2096611.09675 | 37.7371770110996 | -122.425245335799 | (37.7371770110996, -122.425245335799) | 2 | 7 | 5 | 28859 | 2 | ||||
102806 | 220188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 6 | 6004898.43848 | 2096540.40011 | 37.736977976744 | -122.425541221768 | (37.736977976744, -122.425541221768) | 2 | 7 | 5 | 28859 | 2 | ||||
107627 | 220184 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 14 | 6004926.8696 | 2096549.97699 | 37.7370058791054 | -122.425443603957 | (37.7370058791054, -122.425443603957) | 2 | 7 | 5 | 28859 | 2 | ||||
107652 | 220177 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 42 | Front Yard : Yard | Tree | Private 2 | 31 | 6004978.16757 | 2096563.63573 | 37.7370462811452 | -122.425267215414 | (37.7370462811452, -122.425267215414) | 2 | 7 | 5 | 28859 | 2 | ||||
113928 | 220167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 31 | Front Yard : Yard | Tree | Private 2 | 13 | 6004945.26232 | 2096528.1578 | 37.7369470076993 | -122.425378459774 | (37.7369470076993, -122.425378459774) | 2 | 7 | 5 | 28859 | 2 | ||||
121122 | 220172 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 13 | 6004959.70888 | 2096542.80768 | 37.7369880491675 | -122.425329553743 | (37.7369880491675, -122.425329553743) | 2 | 7 | 5 | 28859 | 2 | ||||
126565 | 220161 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 23 | 6004865.4895 | 2096506.15272 | 37.7368820793529 | -122.42565270441 | (37.7368820793529, -122.42565270441) | 2 | 7 | 5 | 28859 | 2 | ||||
127471 | 220164 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 28 | Front Yard : Yard | Tree | Private 2 | 23 | 6004931.31387 | 2096515.53098 | 37.7369115492209 | -122.425425787491 | (37.7369115492209, -122.425425787491) | 2 | 7 | 5 | 28859 | 2 | ||||
135356 | 220189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 77 | Front Yard : Yard | Tree | Private 2 | 10 | 6004903.37501 | 2096531.93768 | 37.7369550197456 | -122.425523551887 | (37.7369550197456, -122.425523551887) | 2 | 7 | 5 | 28859 | 2 | ||||
140013 | 220160 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 22 | Front Yard : Yard | Tree | Private 2 | 18 | 6004872.2864 | 2096465.4493 | 37.7367707009968 | -122.425626308409 | (37.7367707009968, -122.425626308409) | 2 | 7 | 5 | 28859 | 2 | ||||
143807 | 220190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 8 | 6004897.78998 | 2096535.50608 | 37.7369645021978 | -122.425543115723 | (37.7369645021978, -122.425543115723) | 2 | 7 | 5 | 28859 | 2 | ||||
143953 | 220187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 75 | Front Yard : Yard | Tree | Private 2 | 8 | 6004907.90324 | 2096539.115 | 37.7369749829053 | -122.42550840641 | (37.7369749829053, -122.42550840641) | 2 | 7 | 5 | 28859 | 2 | ||||
153757 | 220181 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 46 | Front Yard : Yard | Tree | Private 2 | 9 | 6004987.92222 | 2096576.46546 | 37.7370820597802 | -122.425234401841 | (37.7370820597802, -122.425234401841) | 2 | 7 | 5 | 28859 | 2 | ||||
154044 | 220186 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 12 | 6004903.97159 | 2096543.19438 | 37.7369859618163 | -122.425522290127 | (37.7369859618163, -122.425522290127) | 2 | 7 | 5 | 28859 | 2 | ||||
155179 | 220183 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 27 | 6004926.20278 | 2096562.8505 | 37.7370411891885 | -122.425446825336 | (37.7370411891885, -122.425446825336) | 2 | 7 | 5 | 28859 | 2 | ||||
159214 | 220185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 6 | 6004909.03243 | 2096549.63363 | 37.7370039284954 | -122.42550525066 | (37.7370039284954, -122.42550525066) | 2 | 7 | 5 | 28859 | 2 | ||||
160865 | 220180 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 45 | Front Yard : Yard | Tree | Private 2 | 8 | 6004956.45114 | 2096571.71335 | 37.7370672335752 | -122.425342873587 | (37.7370672335752, -122.425342873587) | 2 | 7 | 5 | 28859 | 2 | ||||
161713 | 220178 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 43 | Front Yard : Yard | Tree | Private 2 | 12 | 6004980.92808 | 2096566.55389 | 37.7370544497104 | -122.425257878673 | (37.7370544497104, -122.425257878673) | 2 | 7 | 5 | 28859 | 2 | ||||
164448 | 220163 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 14 | 6004924.61859 | 2096505.26609 | 37.7368829858608 | -122.42544820577 | (37.7368829858608, -122.42544820577) | 2 | 7 | 5 | 28859 | 2 | ||||
168890 | 220169 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 33 | Front Yard : Yard | Tree | Private 2 | 25 | 6004952.51664 | 2096535.60689 | 37.7369678710776 | -122.425353908278 | (37.7369678710776, -122.425353908278) | 2 | 7 | 5 | 28859 | 2 | ||||
170904 | 220191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 11 | 6004894.80738 | 2096532.47755 | 37.7369560180099 | -122.425553212433 | (37.7369560180099, -122.425553212433) | 2 | 7 | 5 | 28859 | 2 | ||||
173737 | 220166 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 30 | Front Yard : Yard | Tree | Private 2 | 19 | 6004931.1825 | 2096526.65396 | 37.7369420829968 | -122.425427033027 | (37.7369420829968, -122.425427033027) | 2 | 7 | 5 | 28859 | 2 | ||||
193459 | 220165 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 29 | Front Yard : Yard | Tree | Private 2 | 22 | 6004939.36103 | 2096521.46367 | 37.7369282937109 | -122.425398386937 | (37.7369282937109, -122.425398386937) | 2 | 7 | 5 | 28859 | 2 | ||||
25302 | 247541 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6000212.07193 | 2108508.73139 | 37.7695741993109 | -122.442603102947 | (37.7695741993109, -122.442603102947) | 15 | 5 | 11 | 29492 | 9 | ||||
29121 | 247529 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 10 | Side Yard : Yard | Tree | Private 2 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.443080032335 | (37.7695086378454, -122.443080032335) | 15 | 5 | 11 | 29492 | 9 | ||||
42127 | 247539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6000199.67712 | 2108517.8655 | 37.7695985727307 | -122.442646631948 | (37.7695985727307, -122.442646631948) | 15 | 5 | 11 | 29492 | 9 | ||||
42339 | 247532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6000110.00328 | 2108483.6988 | 37.7694996473165 | -122.442954355683 | (37.7694996473165, -122.442954355683) | 15 | 5 | 11 | 29492 | 9 |
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) );