trees
2,694 rows where qSpecies_id = 84 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3919 | 240834 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
4251 | 42457 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.7329900693173 | -122.450477464919 | (37.7329900693173, -122.450477464919) | 9 | 7 | 4 | 59 | 40 |
7068 | 66214 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2233 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1990 12:00:00 AM | 9 | Permit Number 29304 | 5989765.2961 | 2100174.6084 | 37.7460898851299 | -122.47812830871 | (37.7460898851299, -122.47812830871) | 1 | 8 | 3 | 29491 | 35 | ||
8785 | 178959 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007585.1415 | 2091886.23741 | 37.7243500958617 | -122.415922582174 | (37.7243500958617, -122.415922582174) | 9 | 3 | 7 | 309 | 28 | |||
14237 | 240835 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
18344 | 40022 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | 10 | 3 | 8 | 58 | 1 | |
24348 | 41338 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | 11 | 6 | 1 | 54 | 31 | ||
57518 | 237977 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 155 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997765.75644 | 2104874.46732 | 37.7594556796657 | -122.450802700494 | (37.7594556796657, -122.450802700494) | 15 | 5 | 11 | 28862 | 12 | |||
58505 | 196409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.410316628528 | (37.7771240168943, -122.410316628528) | 8 | 2 | 9 | 28853 | 34 | |||
58603 | 178891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 579 Madrid St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.7204375997904 | -122.43356984467 | (37.7204375997904, -122.43356984467) | 9 | 7 | 6 | 28861 | 5 | |||
64985 | 102572 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 778 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x9 | 5997324.2834 | 2112596.006 | 37.7806317567919 | -122.452886865809 | (37.7806317567919, -122.452886865809) | 15 | 6 | 2 | 54 | 16 | |||
74267 | 31302 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.425480907835 | (37.7779765092875, -122.425480907835) | 7 | 9 | 11 | 28852 | 10 | |
75128 | 244991 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | 7 | 9 | 11 | 28852 | 10 | |||
85027 | 238001 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 591 27th St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6002762.01889 | 2100032.14119 | 37.7464445418877 | -122.433177187196 | (37.7464445418877, -122.433177187196) | 2 | 7 | 5 | 63 | 22 | ||||
86120 | 196408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 22 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009625.06025 | 2110948.02453 | 37.7768040057292 | -122.41021603036 | (37.7768040057292, -122.41021603036) | 8 | 2 | 9 | 28853 | 34 | |||
100157 | 244907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999911.6566 | 2109010.7372 | 37.7709354515424 | -122.443678294205 | (37.7709354515424, -122.443678294205) | 15 | 5 | 11 | 29492 | 9 | |||
102372 | 196395 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Clara St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.403901990095 | (37.7782984271806, -122.403901990095) | 14 | 2 | 9 | 28856 | 34 | |||
102648 | 183767 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2287 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5987606.1386 | 2099727.1382 | 37.744735684193 | -122.48556146831 | (37.744735684193, -122.48556146831) | 1 | 8 | 3 | 29491 | 35 | |||
108232 | 178900 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6009581.67769 | 2090926.39169 | 37.721826605402 | -122.408953115987 | (37.721826605402, -122.408953115987) | 9 | 3 | 7 | 309 | 28 | |||
135431 | 238013 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999618.47962 | 2106729.85774 | 37.764656004003 | -122.444528442659 | (37.764656004003, -122.444528442659) | 15 | 5 | 5 | 29492 | 9 | |||
138418 | 178950 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 609 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007192.0962 | 2091723.76737 | 37.7238818827397 | -122.417269780083 | (37.7238818827397, -122.417269780083) | 9 | 3 | 7 | 309 | 28 | |||
166152 | 41337 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.7 | 2113122.5903 | 37.7820168986492 | -122.456587081702 | (37.7820168986492, -122.456587081702) | 11 | 6 | 1 | 54 | 31 | ||
173585 | 114422 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 30X OGDEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x9 | 6009444 | 2095952 | 37.7356181472918 | -122.40978359874 | (37.7356181472918, -122.40978359874) | 10 | 7 | 7 | 28859 | 2 | |||
181908 | 196393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 93 Stillman St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6013990.37233 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | 6 | 2 | 9 | 28856 | 6 | |||
184801 | 118429 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | 11 | 6 | 2 | 55 | 26 | |||
188503 | 196412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | 8 | 2 | 9 | 28853 | 34 | |||
1181 | 238014 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999606.96605 | 2106732.73135 | 37.7646632372481 | -122.444568471453 | (37.7646632372481, -122.444568471453) | 15 | 5 | 5 | 29492 | 9 | |||
2221 | 238015 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.7646659486903 | -122.444594775755 | (37.7646659486903, -122.444594775755) | 15 | 5 | 5 | 29492 | 9 | |||
3027 | 214407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200x Terrace Dr | 11 | Median : Yard | Tree | DPW 1 | 8 | 5993812.00581 | 2096497.75562 | 37.7362282335302 | -122.463868579087 | (37.7362282335302, -122.463868579087) | 1 | 8 | 4 | 59 | 40 | ||||
11747 | 66492 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 8 | Permit Number 29653 | 6009972.98695 | 2110931.16988 | 37.7767772230325 | -122.409011252663 | (37.7767772230325, -122.409011252663) | 8 | 2 | 9 | 28853 | 34 | |
17013 | 70667 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009828.97228 | 2111081.01172 | 37.7771805851524 | -122.409520022524 | (37.7771805851524, -122.409520022524) | 8 | 2 | 9 | 28853 | 34 | |||
17474 | 71170 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2127 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5987570.8389 | 2100801.7844 | 37.747684319575 | -122.485762384494 | (37.747684319575, -122.485762384494) | 1 | 8 | 3 | 29491 | 35 | |||
24996 | 31758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2646 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35244 | 5989596.3538 | 2097340.4362 | 37.738298177735 | -122.478505265789 | (37.738298177735, -122.478505265789) | 1 | 8 | 3 | 29491 | 35 | |
37145 | 73572 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
41827 | 143115 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1635 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6004533.1119 | 2119761.6458 | 37.8007172577851 | -122.428458969748 | (37.8007172577851, -122.428458969748) | 13 | 9 | 1 | 57 | 17 | |||
45064 | 28647 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.7858859308492 | -122.431484021877 | (37.7858859308492, -122.431484021877) | 13 | 9 | 11 | 29490 | 13 | |||
51219 | 51045 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 8 | 3x3 | Permit Number 47518 | 6009984 | 2120227 | 37.8023019525749 | -122.4096294226 | (37.8023019525749, -122.4096294226) | 3 | 1 | 10 | 308 | 23 | |
58652 | 31299 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34943 | 6005251.2106 | 2111468.7266 | 37.777987587802 | -122.425383565241 | (37.777987587802, -122.425383565241) | 7 | 9 | 11 | 28852 | 10 | |
65133 | 178955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1403 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007439.90509 | 2091839.23144 | 37.7242128611213 | -122.41642131739 | (37.7242128611213, -122.41642131739) | 9 | 3 | 7 | 309 | 28 | |||
68060 | 31301 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | 7 | 9 | 11 | 28852 | 10 | |
70297 | 238024 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251 Alma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997519.0494 | 2106123.05363 | 37.7628698568746 | -122.451746001204 | (37.7628698568746, -122.451746001204) | 15 | 5 | 11 | 29492 | 9 | |||
80951 | 135910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011521.09538 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | 3 | 1 | 10 | 308 | 23 | ||||
82295 | 37055 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 283 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | Permit Number 39660 | 6006018.75197 | 2092482.10871 | 37.7258980404498 | -122.421379675536 | (37.7258980404498, -122.421379675536) | 9 | 7 | 7 | 309 | 5 | |
84781 | 196394 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 497 03rd St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6013753.77821 | 2112514.40047 | 37.7813354799985 | -122.396043249122 | (37.7813354799985, -122.396043249122) | 6 | 2 | 9 | 28856 | 34 | |||
86475 | 141238 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 31 PARKER AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996802.437 | 2114389.98 | 37.7855276158827 | -122.454821826496 | (37.7855276158827, -122.454821826496) | 11 | 6 | 1 | 54 | 31 | |||
88262 | 214412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 441 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5995385.60147 | 2098278.36305 | 37.7412079002216 | -122.458556904286 | (37.7412079002216, -122.458556904286) | 1 | 8 | 4 | 59 | 40 | |||
93372 | 140211 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004017.0107 | 2110696.0316 | 37.7757961506144 | -122.429597978666 | (37.7757961506144, -122.429597978666) | 7 | 9 | 11 | 29492 | 10 | |||
94971 | 196413 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009790.62694 | 2111119.41573 | 37.7772838848824 | -122.409655383101 | (37.7772838848824, -122.409655383101) | 8 | 2 | 9 | 28853 | 34 | |||
96380 | 214462 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 139 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000481.84259 | 2095189.99694 | 37.7330195442146 | -122.440714490676 | (37.7330195442146, -122.440714490676) | 9 | 7 | 5 | 63 | 40 | |||
96980 | 140966 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 159 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996524.4235 | 2113288.9246 | 37.782488459378 | -122.455704048946 | (37.782488459378, -122.455704048946) | 11 | 6 | 1 | 54 | 31 | |||
98488 | 62656 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 54 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | 8 | Permit Number 22980 | 6002634.46199827 | 2108713.61135297 | 37.7702745359856 | -122.434238802768 | (37.7702745359856, -122.434238802768) | 15 | 5 | 5 | 29492 | 9 | |
99238 | 196414 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 72 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010005.6719 | 2110890.86599 | 37.7766683888663 | -122.408895340869 | (37.7766683888663, -122.408895340869) | 8 | 2 | 9 | 28853 | 34 | |||
101115 | 107518 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 59 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x4 | 6003087.6 | 2108634.4 | 37.7700827498113 | -122.432665742309 | (37.7700827498113, -122.432665742309) | 15 | 5 | 5 | 29492 | 9 | |||
104580 | 48557 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 229 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45873 | 5999935.73213397 | 2105555.64509201 | 37.7614500048987 | -122.443346807074 | (37.7614500048987, -122.443346807074) | 15 | 5 | 5 | 28862 | 3 | |
109272 | 183452 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2519 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989212.0936 | 2098169.1351 | 37.7405512532287 | -122.479894458871 | (37.7405512532287, -122.479894458871) | 1 | 8 | 3 | 29491 | 35 | |||
111122 | 143052 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008958.7736 | 2120458.7538 | 37.8028807881226 | -122.413193616152 | (37.8028807881226, -122.413193616152) | 3 | 1 | 10 | 308 | 23 | |||
120841 | 38857 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1535 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 8 | Permit Number 40684 | 5989293.1114 | 2104890.3622 | 37.7590106719955 | -122.480106109134 | (37.7590106719955, -122.480106109134) | 1 | 8 | 3 | 56 | 35 | |
124995 | 214428 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1455 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994568.84933 | 2105618.5919 | 37.7613153310709 | -122.46191305814 | (37.7613153310709, -122.46191305814) | 1 | 5 | 11 | 56 | 12 | |||
125770 | 238030 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 806 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003058.03734 | 2103537.29487 | 37.7560856546308 | -122.432403895241 | (37.7560856546308, -122.432403895241) | 2 | 4 | 5 | 28862 | 22 | |||
129376 | 135893 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6001843.59752 | 2121830.48703 | 37.8062451862265 | -122.437914052191 | (37.8062451862265, -122.437914052191) | 13 | 9 | 1 | 57 | 17 | ||||
130551 | 141646 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 540 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000633.4281 | 2110866.4642 | 37.7760719499762 | -122.441314847671 | (37.7760719499762, -122.441314847671) | 15 | 5 | 11 | 29492 | 10 | |||
130770 | 28641 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 3 | Median : Cutout | Tree | DPW 1 | 8 | 20 | 6003709.2011 | 2113267.9212 | 37.7828404869024 | -122.43084635463 | (37.7828404869024, -122.43084635463) | 15 | 9 | 11 | 29490 | 41 | |||
132070 | 196404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 482 10th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009690.27769 | 2108658.23097 | 37.7705204219146 | -122.409828750806 | (37.7705204219146, -122.409828750806) | 8 | 2 | 9 | 28853 | 34 | |||
135122 | 182714 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1739 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989337.2395 | 2103510.1473 | 37.7552235355691 | -122.479852496079 | (37.7552235355691, -122.479852496079) | 1 | 8 | 3 | 56 | 35 | |||
136382 | 237979 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 823 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999103.16972 | 2107519.69828 | 37.7667952905854 | -122.446367580505 | (37.7667952905854, -122.446367580505) | 15 | 5 | 11 | 29492 | 9 | |||
140612 | 178953 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1433 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007354.96805 | 2091814.90318 | 37.7241412840743 | -122.416713210345 | (37.7241412840743, -122.416713210345) | 9 | 3 | 7 | 309 | 28 | |||
141889 | 140965 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 72 COOK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997532.582 | 2113283.8483 | 37.7825323254485 | -122.452215910684 | (37.7825323254485, -122.452215910684) | 15 | 6 | 1 | 54 | 31 | |||
145615 | 138849 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 650x WEBSTER ST | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6004012.6112 | 2111066.8822 | 37.7768141659098 | -122.429639652936 | (37.7768141659098, -122.429639652936) | 7 | 9 | 11 | 28852 | 10 | |||
152835 | 35991 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 62 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | 8 | 6x4.5 | Permit Number 39142 | 6008206.60828059 | 2099659.67368383 | 37.7457291809603 | -122.414324002549 | (37.7457291809603, -122.414324002549) | 2 | 7 | 7 | 28859 | 2 |
153987 | 196405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 482 10th St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6009655.4576 | 2108693.13255 | 37.7706143021254 | -122.409951658457 | (37.7706143021254, -122.409951658457) | 8 | 2 | 9 | 28853 | 34 | |||
156655 | 142258 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 545 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004771.8857 | 2110705.1842 | 37.7758639948557 | -122.426987325719 | (37.7758639948557, -122.426987325719) | 7 | 9 | 11 | 28852 | 10 | |||
160424 | 48932 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2417 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | 8 | 3x3 | Permit Number 46120 | 6008894 | 2104256 | 37.7583882521325 | -122.412271898759 | (37.7583882521325, -122.412271898759) | 2 | 4 | 7 | 28859 | 19 |
165374 | 109158 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
167067 | 178961 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1313 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007631.35752 | 2091897.45686 | 37.7243835002773 | -122.415763613493 | (37.7243835002773, -122.415763613493) | 9 | 3 | 7 | 309 | 28 | |||
172388 | 135914 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | 3 | 1 | 10 | 308 | 23 | |||
173150 | 37402 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4376 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 8 | Permit Number 39884 | 6001480.83310651 | 2100601.41490283 | 37.7479348712443 | -122.437648136887 | (37.7479348712443, -122.437648136887) | 2 | 4 | 5 | 28862 | 22 | |
184480 | 214460 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001504.80171 | 2094910.40142 | 37.7323100420806 | -122.437157847364 | (37.7323100420806, -122.437157847364) | 9 | 7 | 4 | 63 | 40 | |||
189435 | 178958 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1343 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007547.64809 | 2091871.91329 | 37.7243086569025 | -122.41605117804 | (37.7243086569025, -122.41605117804) | 9 | 3 | 7 | 309 | 28 | |||
3715 | 137933 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003135 | 2115313 | 37.788423206128 | -122.432979003927 | (37.788423206128, -122.432979003927) | 13 | 9 | 1 | 29490 | 27 | |||
3967 | 72444 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1733 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5999558.0145 | 2110143.3213 | 37.7740250637938 | -122.444982979337 | (37.7740250637938, -122.444982979337) | 15 | 5 | 11 | 29492 | 16 | |||
11107 | 78786 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | 15 | 5 | 11 | 29492 | 10 | |||
22463 | 196415 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.7765984252192 | -122.408805329496 | (37.7765984252192, -122.408805329496) | 8 | 2 | 9 | 28853 | 34 | |||
23975 | 142257 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 541 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004803.1693 | 2110709.0411 | 37.7758763538472 | -122.426879382419 | (37.7758763538472, -122.426879382419) | 7 | 9 | 11 | 28852 | 10 | |||
31653 | 12410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1610X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 7 | 4X4 | 6004460.5933 | 2114341.7023 | 37.78583136591 | -122.428323406904 | (37.78583136591, -122.428323406904) | 13 | 9 | 11 | 29490 | 13 | ||
41045 | 142281 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 638 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999674.3585 | 2110736.0947 | 37.7756593080095 | -122.444623140793 | (37.7756593080095, -122.444623140793) | 15 | 5 | 11 | 29492 | 16 | |||
41218 | 47760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2586 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2002 12:00:00 AM | 7 | Permit Number 45539 | 5989891.5254 | 2097770.0852 | 37.7394950154316 | -122.47751611296 | (37.7394950154316, -122.47751611296) | 1 | 8 | 3 | 29491 | 35 | |
42413 | 99624 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1941 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768786 | 5998532.9 | 2110322.2 | 37.7744576589045 | -122.448541895436 | (37.7744576589045, -122.448541895436) | 15 | 5 | 11 | 29492 | 16 | |
43932 | 196384 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 3 | : | Tree | Private 2 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.7819454154917 | -122.396070069587 | (37.7819454154917, -122.396070069587) | 6 | 2 | 9 | 28856 | 6 | |||
45372 | 173611 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6005304 | 2101328 | 37.7501465436699 | -122.424479453971 | (37.7501465436699, -122.424479453971) | 2 | 4 | 5 | 28859 | 19 | |||
54623 | 238023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1430 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999614.18249 | 2107598.76839 | 37.7670415699392 | -122.444605761842 | (37.7670415699392, -122.444605761842) | 15 | 5 | 5 | 29492 | 9 | |||
63991 | 139465 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 855 CENTRAL AVE | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 0ft | 5999527.6632 | 2111481.3292 | 37.7776971593158 | -122.445184184965 | (37.7776971593158, -122.445184184965) | 15 | 5 | 11 | 54 | 16 | |||
65631 | 178954 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1423 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007391.99195 | 2091825.51299 | 37.7241724986518 | -122.416585975176 | (37.7241724986518, -122.416585975176) | 9 | 3 | 7 | 309 | 28 | |||
69267 | 135892 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6001823.0897 | 2121828.59544 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | 13 | 9 | 1 | 57 | 17 | |||
69820 | 21708 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1710X Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 7 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | 13 | 9 | 11 | 29490 | 27 | ||
70247 | 245006 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1201 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000755.8359 | 2109268.0945 | 37.7716902017242 | -122.440776726653 | (37.7716902017242, -122.440776726653) | 15 | 5 | 11 | 29492 | 9 | |||
70631 | 237985 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 124 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004244.2289 | 2095153.53222 | 37.7331329640029 | -122.427704333181 | (37.7331329640029, -122.427704333181) | 9 | 7 | 5 | 28861 | 25 | |||
74478 | 185265 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2616 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985852.1135 | 2097401.8704 | 37.7382487690483 | -122.491455345913 | (37.7382487690483, -122.491455345913) | 1 | 8 | 3 | 29491 | 35 | |||
76906 | 47757 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2517 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2002 12:00:00 AM | 7 | Permit Number 45537 | 5989831.6247 | 2098216.4636 | 37.7407171789575 | -122.477755842346 | (37.7407171789575, -122.477755842346) | 1 | 8 | 3 | 29491 | 35 | |
78119 | 214457 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001468.0488 | 2094911.62577 | 37.7323113146131 | -122.437284998007 | (37.7323113146131, -122.437284998007) | 9 | 7 | 4 | 63 | 40 | |||
78657 | 44057 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | 5 | 1 | 1 | 28858 | 32 |
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) );