trees
556 rows where qSpecies_id = 71 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30718 | 246978 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 201 Noe St | 4 | : | Tree | Private 2 | 21 | Width 8ft | 6002919.18964 | 2107068.61942 | 37.7657739467266 | -122.433136379546 | (37.7657739467266, -122.433136379546) | 15 | 5 | 5 | 28862 | 3 | |||
33641 | 128833 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6002164.86487 | 2116089.53084 | 37.7905002856984 | -122.436391110584 | (37.7905002856984, -122.436391110584) | 13 | 6 | 1 | 29490 | 27 | |||
34257 | 121460 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | |||||
40145 | 142068 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1000 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003893.9859 | 2112297.2467 | 37.7801857244776 | -122.43013780751 | (37.7801857244776, -122.43013780751) | 7 | 9 | 11 | 29490 | 41 | |||
48987 | 247012 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6002599.35575 | 2099199.87277 | 37.7441500988492 | -122.433680185213 | (37.7441500988492, -122.433680185213) | 2 | 7 | 5 | 63 | 22 | ||||
56357 | 107390 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 773951 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | ||||
74884 | 218981 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991484.23887 | 2094055.35352 | 37.7293875934485 | -122.47173861195 | (37.7293875934485, -122.47173861195) | 9 | 8 | 4 | 59 | 40 | |||
78616 | 23803 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1160 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6003835.7537369 | 2112705.7306783 | 37.7813040215007 | -122.430368411811 | (37.7813040215007, -122.430368411811) | 7 | 9 | 11 | 29490 | 41 | |||
89678 | 52015 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
89703 | 225852 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 9ft | 6005926.46484 | 2104057.0106 | 37.7576749077845 | -122.422520824396 | (37.7576749077845, -122.422520824396) | 2 | 4 | 5 | 28859 | 19 | |||
92068 | 10421 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1219X Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 5999421.35342 | 2108678.34127 | 37.7699947998181 | -122.44535035645 | (37.7699947998181, -122.44535035645) | 15 | 5 | 11 | 29492 | 9 | |||
92803 | 245998 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1211 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999402.4121 | 2108663.858 | 37.769953951156 | -122.445414832365 | (37.769953951156, -122.445414832365) | 15 | 5 | 11 | 29492 | 9 | |||
109554 | 139228 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1401 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003615.514 | 2113580.969 | 37.7836947290906 | -122.43119282453 | (37.7836947290906, -122.43119282453) | 13 | 9 | 11 | 29490 | 41 | |||
111832 | 253382 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 4 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
125513 | 247739 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 900 Waller St | 4 | Front Yard : Yard | Tree | Private 2 | 17 | 6001290.39565 | 2108693.08102 | 37.7701417866389 | -122.438886441468 | (37.7701417866389, -122.438886441468) | 15 | 5 | 11 | 29492 | 9 | ||||
132401 | 246263 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2298 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002944.8745 | 2106661.4314 | 37.7646573643321 | -122.433018446764 | (37.7646573643321, -122.433018446764) | 15 | 5 | 5 | 28862 | 3 | |||
136169 | 128830 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997658.68844 | 2114896.31526 | 37.7869669572999 | -122.451896004506 | (37.7869669572999, -122.451896004506) | 11 | 6 | 1 | 54 | 31 | |||
137316 | 23778 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1006 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/19/1992 12:00:00 AM | 40 | 3X3 | 6003898.5093138 | 2112170.2011072 | 37.7798371450347 | -122.430113093173 | (37.7798371450347, -122.430113093173) | 7 | 9 | 11 | 29490 | 41 | ||
137455 | 14534 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
140756 | 23784 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1010 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6003903.8361546 | 2112182.8886989 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | 7 | 9 | 11 | 29490 | 41 | |||
146105 | 23724 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 802X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6003990.0153246 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | 7 | 9 | 11 | 28852 | 41 | |||
146894 | 14357 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002936.44481 | 2106655.16607 | 37.7646396831024 | -122.433047155129 | (37.7646396831024, -122.433047155129) | 15 | 5 | 5 | 28862 | 3 | |||
149463 | 103290 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011095.04469 | 2121443.69303 | 37.8057048879202 | -122.405870402816 | (37.8057048879202, -122.405870402816) | 3 | 1 | 10 | 308 | 23 | |||
150319 | 225866 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 5ft | 6006516.03586 | 2098775.00428 | 37.7432049671495 | -122.420106993662 | (37.7432049671495, -122.420106993662) | 2 | 7 | 7 | 28859 | 2 | |||
153323 | 141994 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 818 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6003989.735 | 2111607.5325 | 37.7782973627546 | -122.429757359707 | (37.7782973627546, -122.429757359707) | 7 | 9 | 11 | 29490 | 41 | |||
161129 | 225823 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6011090.95025 | 2102601.58592 | 37.7539686316657 | -122.404557371938 | (37.7539686316657, -122.404557371938) | 10 | 4 | 8 | 28859 | 19 | |||
168715 | 140250 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5999174.9773 | 2110335.2771 | 37.7745302567897 | -122.446321776898 | (37.7745302567897, -122.446321776898) | 15 | 5 | 11 | 29492 | 16 | |||
182461 | 138432 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1601 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003502.2144 | 2114406.5958 | 37.785955271305 | -122.43164376298 | (37.785955271305, -122.43164376298) | 13 | 9 | 11 | 29490 | 13 | |||
186406 | 138097 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1716 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003549.537 | 2114696.9008 | 37.7867550577771 | -122.43150077205 | (37.7867550577771, -122.43150077205) | 13 | 9 | 11 | 29490 | 27 | |||
192219 | 23748 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 900X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4x4 | 6003941.8583 | 2111953.2204 | 37.7792438248983 | -122.429947647907 | (37.7792438248983, -122.429947647907) | 7 | 9 | 11 | 29490 | 41 | |||
183 | 253381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
2056 | 5946 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.430845511676 | (37.7815635260957, -122.430845511676) | 15 | 9 | 11 | 29490 | 41 | |||
6835 | 4820 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 398X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 4x4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.421804144483 | (37.7406342583881, -122.421804144483) | 2 | 7 | 7 | 28859 | 2 | |||
11408 | 138096 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1710 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003559.9046 | 2114643.6489 | 37.7866094291115 | -122.431461099658 | (37.7866094291115, -122.431461099658) | 13 | 9 | 11 | 29490 | 27 | |||
14713 | 246262 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2298 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002931.9657 | 2106660.3089 | 37.7646535499952 | -122.433063014632 | (37.7646535499952, -122.433063014632) | 15 | 5 | 5 | 28862 | 3 | |||
17910 | 211714 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 100 Tara St | 3 | Unaccepted Street : Yard | Tree | Private 2 | 13 | Width 0ft | 5998092.2362 | 2090928.90604 | 37.7211832160136 | -122.44866915786 | (37.7211832160136, -122.44866915786) | 9 | 8 | 6 | 28861 | 24 | |||
20980 | 140249 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5999170.7375 | 2110360.1102 | 37.7745981999883 | -122.446338229944 | (37.7745981999883, -122.446338229944) | 15 | 5 | 11 | 29492 | 16 | |||
21172 | 107389 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 773951 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | ||||
23086 | 23918 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1639 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 4X4 | 6003511.011206 | 2114320.0570948 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | 13 | 9 | 11 | 29490 | 13 | |||
23348 | 225822 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011089.51394 | 2102630.04924 | 37.7540467053928 | -122.404564342576 | (37.7540467053928, -122.404564342576) | 10 | 4 | 8 | 28859 | 19 | |||
27542 | 14506 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 6X6 | 5999167.52145 | 2111070.84281 | 37.7765495060171 | -122.446400495731 | (37.7765495060171, -122.446400495731) | 15 | 5 | 11 | 29492 | 16 | |||
29500 | 23910 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1620 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.78559018383 | -122.431235644012 | (37.78559018383, -122.431235644012) | 13 | 9 | 11 | 29490 | 13 | |||
30836 | 192376 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6015917.31296 | 2106690.54623 | 37.7654645943419 | -122.388151855539 | (37.7654645943419, -122.388151855539) | 14 | 3 | 9 | 310 | 29 | |||
33085 | 14533 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | City College 20 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | 15 | 5 | 11 | 29492 | 16 | |||
33208 | 246977 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 201 Noe St | 3 | : | Tree | Private 2 | 27 | Width 8ft | 6002905.92105 | 2107067.14879 | 37.7657691560557 | -122.433182167637 | (37.7657691560557, -122.433182167637) | 15 | 5 | 5 | 28862 | 3 | |||
33326 | 23802 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1160 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6003829.6195 | 2112722.1937 | 37.7813488773836 | -122.43039080822 | (37.7813488773836, -122.43039080822) | 7 | 9 | 11 | 29490 | 41 | |||
47468 | 225851 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 9ft | 6005940.80903 | 2104056.71589 | 37.7576749077866 | -122.4224711953 | (37.7576749077866, -122.4224711953) | 2 | 4 | 5 | 28859 | 19 | |||
47666 | 23777 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1006 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6003898.5093138 | 2112170.2011072 | 37.7798371450347 | -122.430113093173 | (37.7798371450347, -122.430113093173) | 7 | 9 | 11 | 29490 | 41 | |||
50580 | 10412 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1154X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 5999422.66976 | 2108913.34746 | 37.7706401425115 | -122.445362703114 | (37.7706401425115, -122.445362703114) | 15 | 5 | 11 | 29492 | 9 | ||||
51349 | 167 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 185X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | 15 | 5 | 5 | 28862 | 3 | ||||
53976 | 245211 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1101 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001258.8419 | 2109339.7403 | 37.7719155564381 | -122.439041937134 | (37.7719155564381, -122.439041937134) | 15 | 5 | 11 | 29492 | 9 | |||
57049 | 225833 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1201 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010883.2575 | 2102402.44646 | 37.753410229111 | -122.40526160404 | (37.753410229111, -122.40526160404) | 10 | 4 | 8 | 28859 | 19 | |||
57785 | 23742 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 856 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6003980.765967 | 2111671.7236867 | 37.7784731079824 | -122.429792966614 | (37.7784731079824, -122.429792966614) | 7 | 9 | 11 | 29490 | 41 | |||
65285 | 16627 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 144 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002842.6673683 | 2107423.1988343 | 37.7667431942981 | -122.433426394261 | (37.7667431942981, -122.433426394261) | 15 | 5 | 5 | 28862 | 3 | |||
65828 | 108040 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6006128.8 | 2104138.4 | 37.7579097966574 | -122.421826846578 | (37.7579097966574, -122.421826846578) | 2 | 4 | 5 | 28859 | 19 | ||||
68125 | 14356 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002946.46264 | 2106656.34752 | 37.7646434953143 | -122.433012590568 | (37.7646434953143, -122.433012590568) | 15 | 5 | 5 | 28862 | 3 | |||
79900 | 225867 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6006525.15417 | 2098793.36254 | 37.7432558885579 | -122.420076767448 | (37.7432558885579, -122.420076767448) | 2 | 7 | 7 | 28859 | 2 | |||
83991 | 11013 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 95 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018177.8841382 | 2094612.4287261 | 37.7324255328509 | -122.379493861146 | (37.7324255328509, -122.379493861146) | 10 | 3 | 8 | 58 | 1 | |||
87200 | 117712 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 499 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5983131.36299 | 2112604.59919 | 37.7798318029571 | -122.501986802339 | (37.7798318029571, -122.501986802339) | 11 | 6 | 2 | 55 | 26 | |||
96016 | 23850 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1401X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003612.0155 | 2113606.6244 | 37.7837649741264 | -122.431206759864 | (37.7837649741264, -122.431206759864) | 13 | 9 | 11 | 29490 | 41 | |||
100806 | 107500 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1101x PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | Permit Number 773474 | 6001297 | 2109248 | 37.7716658315653 | -122.438903370258 | (37.7716658315653, -122.438903370258) | 15 | 5 | 11 | 29492 | 9 | ||
101775 | 21701 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1710X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | 13 | 9 | 11 | 29490 | 27 | |||
103837 | 140106 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 590 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5999163.5213 | 2110903.9816 | 37.7760911194684 | -122.446402326499 | (37.7760911194684, -122.446402326499) | 15 | 5 | 11 | 29492 | 16 | |||
104497 | 10420 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1219X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999405.64403 | 2108687.20317 | 37.7700182355876 | -122.445405332062 | (37.7700182355876, -122.445405332062) | 15 | 5 | 11 | 29492 | 9 | |||
112905 | 52013 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
117907 | 201408 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 201 Harbor Rd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6018149.85399 | 2094926.30804 | 37.7332858379605 | -122.379612566976 | (37.7332858379605, -122.379612566976) | 10 | 3 | 8 | 58 | 1 | |||
122421 | 22668 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1150X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6003840.4795818 | 2112671.8469471 | 37.7812112529089 | -122.430349644485 | (37.7812112529089, -122.430349644485) | 7 | 9 | 11 | 29490 | 41 | |||
122447 | 14584 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | 15 | 5 | 11 | 29492 | 9 | |||
126633 | 17335 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 170 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006561.61722 | 2108839.89648 | 37.7708433996885 | -122.420663729244 | (37.7708433996885, -122.420663729244) | 8 | 2 | 9 | 28853 | 19 | |||
128395 | 247738 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 900 Waller St | 3 | Front Yard : Yard | Tree | Private 2 | 28 | 6001307.4111 | 2108694.63731 | 37.7701470278921 | -122.438827696866 | (37.7701470278921, -122.438827696866) | 15 | 5 | 11 | 29492 | 9 | ||||
130199 | 246973 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 281 Noe St | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6002929.82417 | 2106784.67092 | 37.7649948964257 | -122.433079307674 | (37.7649948964257, -122.433079307674) | 15 | 5 | 5 | 28862 | 3 | |||
141176 | 109834 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2521 JUDAH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 2x2 | 5986663 | 2105677 | 37.7610173925517 | -122.489259989237 | (37.7610173925517, -122.489259989237) | 1 | 8 | 3 | 56 | 35 | |||
146298 | 192359 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1 25th St | 3 | : Yard | Tree | Private 2 | 11 | 6015007.49408 | 2102120.97523 | 37.7528670835631 | -122.390979333923 | (37.7528670835631, -122.390979333923) | 10 | 3 | 8 | 28856 | 29 | ||||
147094 | 23765 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 911 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6003870.64227 | 2111837.18218 | 37.7789211793615 | -122.430185733043 | (37.7789211793615, -122.430185733043) | 15 | 9 | 11 | 29490 | 41 | |||
149324 | 23716 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
150979 | 245996 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1211 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999394.2357 | 2108683.5418 | 37.7700075311334 | -122.445444529843 | (37.7700075311334, -122.445444529843) | 15 | 5 | 11 | 29492 | 9 | |||
158838 | 138431 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1601 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003497.8639 | 2114427.3813 | 37.7860120964491 | -122.431660299037 | (37.7860120964491, -122.431660299037) | 13 | 9 | 11 | 29490 | 13 | |||
165055 | 23747 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 900X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 4x4 | 6003945.3133 | 2111922.8931 | 37.7791607493139 | -122.429933531753 | (37.7791607493139, -122.429933531753) | 7 | 9 | 11 | 29490 | 41 | |||
167732 | 192389 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 450 Amador St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 6018217.013 | 2099612.23959 | 37.7461561769656 | -122.379705821289 | (37.7461561769656, -122.379705821289) | 10 | 3 | 8 | 58 | 1 | |||
177463 | 128829 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997655.29995 | 2114907.57058 | 37.7869976673453 | -122.45190854016 | (37.7869976673453, -122.45190854016) | 11 | 6 | 1 | 54 | 31 | |||
181587 | 225854 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 70 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 7ft | 6005875.84915 | 2104054.64821 | 37.7576655656334 | -122.422695706548 | (37.7576655656334, -122.422695706548) | 2 | 4 | 5 | 28859 | 19 | |||
182025 | 128832 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6002198.1821 | 2116092.80029 | 37.7905111558262 | -122.436276069294 | (37.7905111558262, -122.436276069294) | 13 | 6 | 1 | 29490 | 27 | |||
182925 | 142067 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1000 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003899.9247 | 2112251.4221 | 37.7800602378696 | -122.430113992512 | (37.7800602378696, -122.430113992512) | 7 | 9 | 11 | 29490 | 41 | |||
186304 | 121459 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | |||||
188447 | 245183 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Baker St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 6000788.1423 | 2109334.9151 | 37.7718755141223 | -122.440669770843 | (37.7718755141223, -122.440669770843) | 15 | 5 | 11 | 29492 | 9 | |||
189168 | 225844 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 6006115.25271 | 2104066.06137 | 37.7577104076212 | -122.421868560489 | (37.7577104076212, -122.421868560489) | 2 | 4 | 5 | 28859 | 19 | |||
190962 | 103289 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011124.97439 | 2121449.08907 | 37.805721377897 | -122.405767206501 | (37.805721377897, -122.405767206501) | 3 | 1 | 10 | 308 | 23 | |||
59511 | 192363 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1310 Indiana St | 26 | : Yard | Tree | Private 2 | 8 | 6014946.14902 | 2102349.52066 | 37.7534912166487 | -122.391207452379 | (37.7534912166487, -122.391207452379) | 10 | 3 | 8 | 28856 | 29 | ||||
104041 | 254801 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 700 Brotherhood Way | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
56684 | 192364 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1310 Indiana St | 23 | : Yard | Tree | Private 2 | 8 | 6014928.1243 | 2102399.042 | 37.7536261914184 | -122.391273247671 | (37.7536261914184, -122.391273247671) | 10 | 3 | 8 | 28856 | 29 | ||||
158155 | 192365 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1310 Indiana St | 21 | : Yard | Tree | Private 2 | 8 | 6014917.07843 | 2102437.66889 | 37.7537316396243 | -122.391314147037 | (37.7537316396243, -122.391314147037) | 10 | 3 | 8 | 28856 | 29 | ||||
39637 | 192362 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1 25th St | 20 | : Yard | Tree | Private 2 | 9 | 6014965.98324 | 2102248.74822 | 37.7532156176115 | -122.391131817592 | (37.7532156176115, -122.391131817592) | 10 | 3 | 8 | 28856 | 29 | ||||
57276 | 192366 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1310 Indiana St | 20 | : Yard | Tree | Private 2 | 13 | 6014913.1297 | 2102461.68379 | 37.7537973602844 | -122.39132948139 | (37.7537973602844, -122.39132948139) | 10 | 3 | 8 | 28856 | 29 | ||||
7697 | 23847 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1370 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003735.9392 | 2113413.2165 | 37.7832409463281 | -122.430764223956 | (37.7832409463281, -122.430764223956) | 7 | 9 | 11 | 29490 | 41 | |||
13993 | 139261 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 702 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004039.451 | 2111223.3243 | 37.7772452370478 | -122.429557965765 | (37.7772452370478, -122.429557965765) | 7 | 9 | 11 | 28852 | 10 | |||
16668 | 251641 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1785 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003432 | 2114811 | 37.7870616829204 | -122.431915572303 | (37.7870616829204, -122.431915572303) | 13 | 9 | 11 | 29490 | 27 | ||||
21735 | 5942 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1155X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003738.78415 | 2112752.38886 | 37.781426639976 | -122.430707209452 | (37.781426639976, -122.430707209452) | 15 | 9 | 11 | 29490 | 41 | |||
21775 | 176487 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 14 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 6011797.05153 | 2087306.90558 | 37.7120120754601 | -122.401040902239 | (37.7120120754601, -122.401040902239) | 10 | 3 | 8 | 309 | 1 | |||
22108 | 141881 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1160 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6003834.0273 | 2112698.8952 | 37.7812851551878 | -122.430373896592 | (37.7812851551878, -122.430373896592) | 7 | 9 | 11 | 29490 | 41 | |||
25012 | 192386 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 725 Rhode Island St | 2 | : | Tree | Private 2 | 24 | Width 4ft | 6011857.61784 | 2104994.61162 | 37.7605821695415 | -122.402074261034 | (37.7605821695415, -122.402074261034) | 10 | 3 | 8 | 28856 | 29 |
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) );