trees
3,965 rows where qSpecies_id = 70 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37590 | 30343 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3789 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 27 | 6001958.22163 | 2121669.55401 | 37.8058098244409 | -122.437505844543 | (37.8058098244409, -122.437505844543) | 13 | 9 | 1 | 57 | 17 | |||
38870 | 124841 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Retiro Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001779.40776 | 2121521.29923 | 37.8053925884559 | -122.438114029041 | (37.8053925884559, -122.438114029041) | 13 | 9 | 1 | 57 | 17 | |||
43641 | 200538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 14 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016175.1953 | 2095654.7768 | 37.7351769557335 | -122.386490343499 | (37.7351769557335, -122.386490343499) | 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 | ||||
49006 | 203952 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2379 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991670.74328 | 2099247.13538 | 37.7436537018588 | -122.471472011519 | (37.7436537018588, -122.471472011519) | 1 | 8 | 4 | 29491 | 40 | |||
49122 | 175035 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 177 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010415.17043 | 2086409.01493 | 37.7094694645007 | -122.405753896527 | (37.7094694645007, -122.405753896527) | 9 | 7 | 8 | 309 | 39 | |||
52773 | 220201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 7 | Width 5ft | 6003510.43036 | 2095660.01539 | 37.7344821161581 | -122.430277392481 | (37.7344821161581, -122.430277392481) | 2 | 7 | 5 | 63 | 7 | |||
55689 | 203682 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1499 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991788.69227 | 2105284.21612 | 37.7602367777281 | -122.471503994108 | (37.7602367777281, -122.471503994108) | 1 | 8 | 4 | 56 | 12 | |||
57438 | 183599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 116 Escolta Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986611.9824 | 2097255.1837 | 37.7378903813657 | -122.488817350509 | (37.7378903813657, -122.488817350509) | 1 | 8 | 3 | 29491 | 35 | |||
58289 | 125113 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3160 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999104.95598 | 2116320.17458 | 37.7909592304403 | -122.446994768606 | (37.7909592304403, -122.446994768606) | 13 | 6 | 1 | 29490 | 31 | |||
60876 | 125035 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1467 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002202.71085 | 2121546.35864 | 37.8054854596596 | -122.436650930122 | (37.8054854596596, -122.436650930122) | 13 | 9 | 1 | 57 | 17 | |||
61199 | 125005 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3768 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002044.39034 | 2121704.85565 | 37.8059116519779 | -122.43721017441 | (37.8059116519779, -122.43721017441) | 13 | 9 | 1 | 57 | 17 | |||
67884 | 125304 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
69030 | 124848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 170 Retiro Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001909.64403 | 2121706.81926 | 37.8059093829805 | -122.4376766249 | (37.8059093829805, -122.4376766249) | 13 | 9 | 1 | 57 | 17 | |||
75059 | 203971 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 272 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992250.30207 | 2097494.76369 | 37.7388756451875 | -122.469340531056 | (37.7388756451875, -122.469340531056) | 1 | 8 | 4 | 59 | 40 | |||
79005 | 124909 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3839 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996503.81543 | 2115584.45242 | 37.7887901834653 | -122.455941345715 | (37.7887901834653, -122.455941345715) | 11 | 6 | 1 | 54 | 31 | |||
82805 | 220262 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 691 29th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6002099.81762 | 2098825.68061 | 37.743094297472 | -122.435380714155 | (37.743094297472, -122.435380714155) | 2 | 7 | 5 | 63 | 7 | ||||
85981 | 181922 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2392 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986744.7102 | 2099010.2319 | 37.742717022992 | -122.488487403006 | (37.742717022992, -122.488487403006) | 1 | 8 | 3 | 29491 | 35 | |||
88312 | 97090 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2756 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6002131.41317 | 2117668.55194 | 37.7948339684692 | -122.436619923275 | (37.7948339684692, -122.436619923275) | 13 | 9 | 1 | 29490 | 27 | |||
89967 | 143073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 586 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010122.9219 | 2120266.0158 | 37.802416863921 | -122.40915143763 | (37.802416863921, -122.40915143763) | 3 | 1 | 10 | 308 | 23 | |||
92788 | 125033 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1499 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002182.69611 | 2121542.62172 | 37.8054740616425 | -122.436719926078 | (37.8054740616425, -122.436719926078) | 13 | 9 | 1 | 57 | 17 | |||
93087 | 125306 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
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 | ||||
94307 | 125124 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2939 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999506.07525 | 2117351.68768 | 37.7938144016778 | -122.445681128889 | (37.7938144016778, -122.445681128889) | 13 | 9 | 1 | 57 | 27 | |||
96224 | 186541 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 12 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.495831387136 | (37.7587075661518, -122.495831387136) | 1 | 8 | 3 | 56 | 35 | |||
97535 | 200539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 15 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016182.3272 | 2095656.8744 | 37.735183110122 | -122.386465831914 | (37.735183110122, -122.386465831914) | 10 | 3 | 8 | 58 | 1 | |||
97610 | 186611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 82 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984721.577 | 2104411.7958 | 37.7574299779546 | -122.49588109169 | (37.7574299779546, -122.49588109169) | 1 | 8 | 3 | 56 | 35 | |||
101468 | 125019 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 135 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002839.24225 | 2121472.84536 | 37.8053197640715 | -122.434442869665 | (37.8053197640715, -122.434442869665) | 13 | 9 | 1 | 57 | 17 | |||
102846 | 188608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2370 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6011669.87256 | 2099790.80879 | 37.7462831864145 | -122.402357690473 | (37.7462831864145, -122.402357690473) | 10 | 3 | 8 | 58 | 1 | |||
103291 | 125034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1467 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002193.98471 | 2121545.09547 | 37.8054814954333 | -122.436681037594 | (37.8054814954333, -122.436681037594) | 13 | 9 | 1 | 57 | 17 | |||
103347 | 125006 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3776 Fillmore St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002042.33893 | 2121722.74316 | 37.8059606497147 | -122.43721855519 | (37.8059606497147, -122.43721855519) | 13 | 9 | 1 | 57 | 17 | |||
108149 | 124912 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998925.93425 | 2116327.80405 | 37.790969949446 | -122.447614723439 | (37.790969949446, -122.447614723439) | 13 | 6 | 1 | 54 | 31 | |||
108271 | 203802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 365 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994147.85172 | 2101219.85432 | 37.7492132810743 | -122.463049938805 | (37.7492132810743, -122.463049938805) | 1 | 8 | 4 | 29491 | 40 | |||
113025 | 124811 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3420 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5999272.70884 | 2120585.70754 | 37.8026808285249 | -122.446721398098 | (37.8026808285249, -122.446721398098) | 13 | 9 | 1 | 57 | 17 | |||
113119 | 125220 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1903 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004459.4494 | 2117676.6904 | 37.7949883361974 | -122.428565171454 | (37.7949883361974, -122.428565171454) | 13 | 9 | 1 | 28858 | 27 | |||
113685 | 203976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993355.56121 | 2095278.1224 | 37.7328531093825 | -122.465358115406 | (37.7328531093825, -122.465358115406) | 9 | 8 | 4 | 59 | 40 | |||
116066 | 124783 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3055 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000935.61002 | 2118892.48301 | 37.798126533981 | -122.440845399609 | (37.798126533981, -122.440845399609) | 13 | 9 | 1 | 57 | 17 | |||
118480 | 203916 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1283 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992666.11934 | 2106749.09035 | 37.7643096579749 | -122.468575999378 | (37.7643096579749, -122.468575999378) | 11 | 8 | 11 | 56 | 12 | |||
119233 | 203244 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1648 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995594.77464 | 2094937.09571 | 37.7320456171101 | -122.457591967706 | (37.7320456171101, -122.457591967706) | 9 | 7 | 4 | 59 | 40 | |||
119830 | 186608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 79 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984734.9762 | 2104426.0324 | 37.7574698524378 | -122.495835802783 | (37.7574698524378, -122.495835802783) | 1 | 8 | 3 | 56 | 35 | |||
130661 | 188638 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011031.7538 | 2096195.40257 | 37.736375330259 | -122.40431122211 | (37.736375330259, -122.40431122211) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
134775 | 183382 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986718.0062 | 2097232.4085 | 37.7378340336236 | -122.488449105903 | (37.7378340336236, -122.488449105903) | 1 | 8 | 3 | 29491 | 35 | |||
139431 | 120071 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987688.6545 | 2115263.01404 | 37.7873977198016 | -122.486416555063 | (37.7873977198016, -122.486416555063) | 11 | 6 | 1 | 55 | 33 | |||
139706 | 125239 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007196.23625 | 2113975.33069 | 37.7849798135129 | -122.418832832384 | (37.7849798135129, -122.418832832384) | 7 | 9 | 9 | 28858 | 36 | |||
140128 | 125303 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
142865 | 118402 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5981581.19272 | 2111336.44811 | 37.7762586467108 | -122.50725532177 | (37.7762586467108, -122.50725532177) | 11 | 6 | 2 | 55 | 26 | |||
143345 | 174973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002045.00305 | 2088644.45077 | 37.7151358445192 | -122.434842314338 | (37.7151358445192, -122.434842314338) | 9 | 7 | 6 | 28861 | 5 | |||
144421 | 220199 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 7 | Width 5ft | 6003519.67627 | 2095667.91857 | 37.7345043401998 | -122.430245989975 | (37.7345043401998, -122.430245989975) | 2 | 7 | 5 | 63 | 7 | |||
145829 | 184850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984672.2236 | 2106848.3576 | 37.764117204402 | -122.49623154236 | (37.764117204402, -122.49623154236) | 1 | 8 | 3 | 56 | 35 | |||
154135 | 183052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 801 Vicente St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5990392.5588 | 2097661.621 | 37.7392262618712 | -122.475775857597 | (37.7392262618712, -122.475775857597) | 1 | 8 | 3 | 29491 | 35 | |||
154686 | 184875 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984644.1243 | 2106811.5248 | 37.7640144258904 | -122.496326010311 | (37.7640144258904, -122.496326010311) | 1 | 8 | 3 | 56 | 35 | |||
157083 | 122183 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 14th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5991499.99073 | 2114915.15294 | 37.7866640105088 | -122.473204868681 | (37.7866640105088, -122.473204868681) | 11 | 6 | 1 | 54 | 33 | ||||
157558 | 200546 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016197.8191 | 2095632.8949 | 37.7351181248044 | -122.386410598906 | (37.7351181248044, -122.386410598906) | 10 | 3 | 8 | 58 | 1 | |||
157857 | 184857 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984627.4167 | 2106843.4213 | 37.7641010259615 | -122.496386149808 | (37.7641010259615, -122.496386149808) | 1 | 8 | 3 | 56 | 35 | |||
162428 | 184860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984687.0326 | 2106838.4849 | 37.7640909641996 | -122.496179594648 | (37.7640909641996, -122.496179594648) | 1 | 8 | 3 | 56 | 35 | |||
162539 | 203875 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | 9 | 8 | 6 | 64 | 24 | ||||
165773 | 220154 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 7 | 6004158.18023 | 2095867.64857 | 37.7350888986179 | -122.428052698177 | (37.7350888986179, -122.428052698177) | 2 | 7 | 5 | 28861 | 2 | ||||
166048 | 186609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984732.0451 | 2104419.3328 | 37.7574512855375 | -122.495845445346 | (37.7574512855375, -122.495845445346) | 1 | 8 | 3 | 56 | 35 | |||
167104 | 115721 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3530 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x5 | 5999222.11492 | 2120952.10002 | 37.8036839530115 | -122.44692285883 | (37.8036839530115, -122.44692285883) | 13 | 9 | 1 | 57 | 17 | |||
176030 | 142568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008908.9878 | 2120990.33 | 37.804337568276 | -122.413403516875 | (37.804337568276, -122.413403516875) | 3 | 1 | 10 | 308 | 23 | |||
178574 | 220152 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 San Jose Ave | 7 | Front Yard : Yard | Tree | Private 2 | 7 | 6005125.32169 | 2096750.37402 | 37.7375673348643 | -122.424771717755 | (37.7375673348643, -122.424771717755) | 2 | 7 | 5 | 28859 | 2 | ||||
179817 | 220202 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 75 | Front Yard : Yard | Tree | Private 2 | 7 | 6003538.0871 | 2095667.44086 | 37.7345040713105 | -122.430182303581 | (37.7345040713105, -122.430182303581) | 2 | 7 | 5 | 63 | 7 | ||||
180531 | 205131 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1261 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994543.00751 | 2097885.11 | 37.7400796638394 | -122.461441770226 | (37.7400796638394, -122.461441770226) | 1 | 8 | 4 | 59 | 40 | |||
180967 | 187754 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.379859346358 | (37.728760777668, -122.379859346358) | 10 | 3 | 8 | 58 | 1 | ||||
184376 | 46251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.443148536401 | (37.7950986884031, -122.443148536401) | 13 | 9 | 1 | 57 | 27 | ||
186118 | 91400 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Maple St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52096 | 5996639.65876 | 2115525.86158 | 37.7886371044596 | -122.455467113417 | (37.7886371044596, -122.455467113417) | 11 | 6 | 1 | 54 | 31 | |
188104 | 181917 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986799.7038 | 2098962.0068 | 37.742587818431 | -122.488293710215 | (37.742587818431, -122.488293710215) | 1 | 8 | 3 | 29491 | 35 | |||
191678 | 250948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987141.62407 | 2114456.19432 | 37.7851505237326 | -122.488249829271 | (37.7851505237326, -122.488249829271) | 11 | 6 | 1 | 55 | 33 | |||
192716 | 203757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992536.87292 | 2097880.10011 | 37.7399502379196 | -122.468377737549 | (37.7399502379196, -122.468377737549) | 1 | 8 | 4 | 59 | 40 | |||
146462 | 10450 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1535 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 5998775.5559 | 2108640.5401 | 37.7698541215464 | -122.447581428516 | (37.7698541215464, -122.447581428516) | 15 | 5 | 11 | 29492 | 9 | |||
2052 | 13108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.8008727786968 | -122.427090735634 | (37.8008727786968, -122.427090735634) | 13 | 9 | 1 | 57 | 17 | |||
16737 | 5399 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6004915.02967 | 2106451.33313 | 37.764192039253 | -122.426189239948 | (37.764192039253, -122.426189239948) | 8 | 4 | 5 | 28859 | 19 | |||
16854 | 14553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | 15 | 5 | 11 | 29492 | 16 | |||
29784 | 12809 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2112 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 5 | 5988863.55424 | 2114711.62184 | 37.7859521665696 | -122.482311278452 | (37.7859521665696, -122.482311278452) | 11 | 6 | 1 | 55 | 33 | |||
40440 | 9405 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 473 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6001706.5922 | 2097649.68492 | 37.7398429487944 | -122.436656219905 | (37.7398429487944, -122.436656219905) | 2 | 7 | 5 | 63 | 7 | |||
72020 | 5608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1148 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6005093.57807 | 2101711.52687 | 37.7511877345454 | -122.425234393764 | (37.7511877345454, -122.425234393764) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
136517 | 12746 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1708 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5990140.90507 | 2114757.41663 | 37.7861521246527 | -122.477895391404 | (37.7861521246527, -122.477895391404) | 11 | 6 | 1 | 55 | 33 | |||
137946 | 14593 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999415.7366 | 2108593.9044 | 37.7697626368824 | -122.445363712809 | (37.7697626368824, -122.445363712809) | 15 | 5 | 11 | 29492 | 9 | |||
144721 | 11450 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 30X ARGUELLO BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X12 | 5995510 | 2115730 | 37.789132728017 | -122.459390328068 | (37.789132728017, -122.459390328068) | 11 | 6 | 1 | 54 | 31 | |||
175732 | 5418 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Dolores St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 6 | 6004853.9708326 | 2105864.857711 | 37.7625782660478 | -122.426358665446 | (37.7625782660478, -122.426358665446) | 8 | 4 | 5 | 28859 | 3 | |||
186415 | 5509 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 807 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5X5 | 6005073.51013 | 2103628.56716 | 37.7564503468259 | -122.425440203623 | (37.7564503468259, -122.425440203623) | 2 | 4 | 5 | 28859 | 19 | |||
1923 | 20027 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
2304 | 19829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
3125 | 20020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
6048 | 19828 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
6317 | 204000 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1570 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994021.37267 | 2104949.86003 | 37.7594476334284 | -122.463757995738 | (37.7594476334284, -122.463757995738) | 1 | 5 | 4 | 56 | 12 | |||
8386 | 20019 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
12706 | 203693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994214.99035 | 2106013.29581 | 37.7623787074434 | -122.463165538553 | (37.7623787074434, -122.463165538553) | 1 | 5 | 11 | 56 | 12 | |||
17456 | 38562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 | |
17638 | 20026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
19317 | 221374 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 653 Sanchez St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003693.10013 | 2104500.87823 | 37.7587674158898 | -122.430276378964 | (37.7587674158898, -122.430276378964) | 2 | 4 | 5 | 28862 | 3 | |||
19569 | 19966 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY41 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
19734 | 24211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
20230 | 203896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5990596.84308 | 2090479.69294 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | 9 | 8 | 4 | 64 | 40 | |||
21969 | 125176 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2519 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001330.49234 | 2117251.0663 | 37.7936421149431 | -122.439361275412 | (37.7936421149431, -122.439361275412) | 13 | 9 | 1 | 29490 | 27 | |||
24362 | 125167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2647 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001006.56911 | 2117558.99371 | 37.7944691638671 | -122.440504169841 | (37.7944691638671, -122.440504169841) | 13 | 9 | 1 | 57 | 27 | |||
25156 | 185173 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985147.9667 | 2097768.3431 | 37.7392138314574 | -122.493916902067 | (37.7392138314574, -122.493916902067) | 1 | 8 | 3 | 29491 | 35 | |||
27228 | 124845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001817.73408 | 2121573.58628 | 37.8055383343822 | -122.437985143623 | (37.8055383343822, -122.437985143623) | 13 | 9 | 1 | 57 | 17 |
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) );