trees
556 rows where qSpecies_id = 71 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 18178 | 192378 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 9ft | 6015920.68395 | 2106620.64032 | 37.7652728345979 | -122.388135317012 | (37.7652728345979, -122.388135317012) | 14 | 3 | 9 | 310 | 29 | |||
| 21645 | 192374 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 6015916.946 | 2106720.28142 | 37.7655462204113 | -122.388155200109 | (37.7655462204113, -122.388155200109) | 14 | 3 | 9 | 310 | 29 | |||
| 24503 | 247010 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6002631.32186 | 2099201.86815 | 37.7441573914612 | -122.433569796116 | (37.7441573914612, -122.433569796116) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | |||
| 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 | ||||
| 60664 | 192383 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 6015928.56627 | 2106487.94693 | 37.7649089239349 | -122.388098792835 | (37.7649089239349, -122.388098792835) | 14 | 3 | 9 | 310 | 29 | |||
| 62034 | 218978 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 635 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5997875.75574 | 2094965.1361 | 37.7322533730829 | -122.449708177017 | (37.7322533730829, -122.449708177017) | 9 | 7 | 4 | 59 | 40 | ||||
| 77259 | 192382 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6015926.91076 | 2106504.64628 | 37.7649546850211 | -122.388105684345 | (37.7649546850211, -122.388105684345) | 14 | 3 | 9 | 310 | 29 | |||
| 81746 | 192381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 6015923.36734 | 2106564.05052 | 37.7651175999097 | -122.38812208619 | (37.7651175999097, -122.38812208619) | 14 | 3 | 9 | 310 | 29 | |||
| 102087 | 192385 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 9ft | 6015934.88312 | 2106386.42358 | 37.7646305127095 | -122.388069858948 | (37.7646305127095, -122.388069858948) | 14 | 3 | 9 | 310 | 29 | |||
| 109157 | 192379 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6015920.8983 | 2106611.50942 | 37.7652477749961 | -122.38813393835 | (37.7652477749961, -122.38813393835) | 14 | 3 | 9 | 310 | 29 | |||
| 110181 | 192384 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6015929.33713 | 2106466.90045 | 37.7648511775542 | -122.38809465775 | (37.7648511775542, -122.38809465775) | 14 | 3 | 9 | 310 | 29 | |||
| 137075 | 247011 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6002619.5945 | 2099198.996 | 37.7441488398068 | -122.433610141488 | (37.7441488398068, -122.433610141488) | 2 | 7 | 5 | 63 | 22 | ||||
| 138173 | 123091 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 625 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5992511.62982 | 2111163.49628 | 37.7764215097268 | -122.469431683073 | (37.7764215097268, -122.469431683073) | 11 | 6 | 2 | 54 | 11 | |||
| 148424 | 192375 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 6015916.65317 | 2106707.2255 | 37.7655103554542 | -122.38815530173 | (37.7655103554542, -122.38815530173) | 14 | 3 | 9 | 310 | 29 | |||
| 152342 | 192380 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6015923.02581 | 2106586.61921 | 37.7651795497335 | -122.388124842588 | (37.7651795497335, -122.388124842588) | 14 | 3 | 9 | 310 | 29 | |||
| 191213 | 192377 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6015920.48189 | 2106647.80141 | 37.7653474018847 | -122.388137911545 | (37.7653474018847, -122.388137911545) | 14 | 3 | 9 | 310 | 29 | |||
| 41608 | 14583 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | 15 | 5 | 11 | 29492 | 9 | |||
| 53328 | 107392 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | |||||
| 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 | ||||
| 81236 | 107394 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6002910.36282 | 2106651.27938 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | 15 | 5 | 5 | 28862 | 3 | |||||
| 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 | |||
| 127144 | 258338 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 209 Spear St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | |||||||||||||||
| 160207 | 107388 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 2 | 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 | ||||
| 37303 | 218980 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5991479.42203 | 2093975.5381 | 37.7291681615656 | -122.47174944968 | (37.7291681615656, -122.47174944968) | 9 | 8 | 4 | 59 | 40 | |||
| 66918 | 245182 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 6000783.8214 | 2109356.5198 | 37.7719345891466 | -122.440686267053 | (37.7719345891466, -122.440686267053) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 124599 | 124031 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991786.57969 | 2114495.60147 | 37.7855286280973 | -122.472182755667 | (37.7855286280973, -122.472182755667) | 11 | 6 | 2 | 54 | 11 | |||
| 139162 | 218983 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 145 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994996.58862 | 2099522.38942 | 37.7446013220014 | -122.459992061292 | (37.7446013220014, -122.459992061292) | 1 | 8 | 4 | 59 | 40 | |||
| 154270 | 218979 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.471788464971 | (37.7284927194476, -122.471788464971) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 172913 | 218984 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 145 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994984.80598 | 2099511.62786 | 37.744571095774 | -122.460032023581 | (37.744571095774, -122.460032023581) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 3580 | 56277 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778721 | 6005870.9645754 | 2104060.4446756 | 37.7576812057902 | -122.422713011346 | (37.7576812057902, -122.422713011346) | 2 | 4 | 5 | 28859 | 19 | ||
| 3605 | 141795 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1280 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6003792.0243 | 2113029.1397 | 37.7821895448546 | -122.43054277764 | (37.7821895448546, -122.43054277764) | 7 | 9 | 11 | 29490 | 41 | |||
| 6463 | 40381 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | Permit Number 41493 | 6002951.47000009 | 2101559.64792523 | 37.7506494618032 | -122.432631180412 | (37.7506494618032, -122.432631180412) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 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 | |||
| 9711 | 128841 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011188.37532 | 2121452.80256 | 37.8057351195451 | -122.405548058817 | (37.8057351195451, -122.405548058817) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 13690 | 225828 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011100.13283 | 2102409.04918 | 37.7534404813975 | -122.404512064091 | (37.7534404813975, -122.404512064091) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 14178 | 225841 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1201 Utah St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6010865.97168 | 2102677.80317 | 37.7541653313745 | -122.405340772261 | (37.7541653313745, -122.405340772261) | 10 | 4 | 8 | 28859 | 19 | |||
| 14510 | 225860 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1979 12:00:00 AM | 32 | Width 4ft | Permit Number 17861 | 5997829.91039 | 2105879.41446 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | 15 | 5 | 11 | 29492 | 9 | |
| 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 | |||
| 14955 | 139262 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004035.029 | 2111258.7004 | 37.7773421207118 | -122.429575786462 | (37.7773421207118, -122.429575786462) | 7 | 9 | 11 | 28852 | 10 | |||
| 16143 | 225872 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 918 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1983 12:00:00 AM | 17 | Width 3ft | Permit Number 20345 | 6009124.648 | 2103673.1383 | 37.7568007856426 | -122.411433035206 | (37.7568007856426, -122.411433035206) | 2 | 4 | 7 | 28859 | 19 | |
| 16382 | 2685 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6003437.92088 | 2114825.67122 | 37.7871023020297 | -122.431896135366 | (37.7871023020297, -122.431896135366) | 13 | 9 | 11 | 29490 | 27 | |||
| 16419 | 260956 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 53 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9x9 | 6005953 | 2103995 | 37.7575061380505 | -122.422424648788 | (37.7575061380505, -122.422424648788) | 2 | 4 | 5 | 28859 | 19 | ||||
| 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 | ||||
| 17334 | 248431 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 721 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 5997917.0355 | 2108037.1532 | 37.7681482738929 | -122.450507510702 | (37.7681482738929, -122.450507510702) | 15 | 5 | 11 | 29492 | 9 | |||
| 18781 | 103292 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011032.30685 | 2121439.6325 | 37.8056902298748 | -122.406087231156 | (37.8056902298748, -122.406087231156) | 3 | 1 | 10 | 308 | 23 | |||
| 19018 | 28638 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
| 19884 | 109998 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
| 20329 | 225847 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 7ft | 6006004.32173 | 2104059.75576 | 37.7576868372893 | -122.422251758015 | (37.7576868372893, -122.422251758015) | 2 | 4 | 5 | 28859 | 19 | |||
| 20644 | 14589 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1221 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999408.7715 | 2108648.7165 | 37.7699127394546 | -122.445391746523 | (37.7699127394546, -122.445391746523) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 21155 | 128837 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6001930.71219 | 2116056.5883 | 37.7903965264241 | -122.437198903224 | (37.7903965264241, -122.437198903224) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | ||||
| 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 | |||
| 21857 | 225878 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3336 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006137.18827 | 2103195.79991 | 37.7553221086433 | -122.421730885992 | (37.7553221086433, -122.421730885992) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 22214 | 23712 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6003969.6344427 | 2111125.822349 | 37.7769735674529 | -122.429792527426 | (37.7769735674529, -122.429792527426) | 7 | 9 | 11 | 29492 | 10 | |||
| 23080 | 248433 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 718 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5997964.5796 | 2108003.6906 | 37.7680591152112 | -122.450340648856 | (37.7680591152112, -122.450340648856) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 23176 | 169 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 185X Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 6X6 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 23680 | 10997 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018318.9881754 | 2094475.1533635 | 37.732056382705 | -122.378996495822 | (37.732056382705, -122.378996495822) | 10 | 3 | 8 | 58 | 1 | |||
| 24512 | 225862 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 198 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6006460.77519 | 2098675.08466 | 37.7429274966048 | -122.420290980542 | (37.7429274966048, -122.420290980542) | 2 | 7 | 7 | 28859 | 2 | |||
| 24782 | 225826 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011095.54336 | 2102504.46266 | 37.7537022093019 | -122.404534651466 | (37.7537022093019, -122.404534651466) | 10 | 4 | 8 | 28859 | 19 | |||
| 24969 | 258214 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6018341.5004 | 2094530.72341 | 37.7322102084437 | -122.378922523056 | (37.7322102084437, -122.378922523056) | 10 | 3 | 8 | 58 | 1 | ||||
| 25654 | 16632 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 150 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002845.7066 | 2107359.01628 | 37.7665671370879 | -122.433411295115 | (37.7665671370879, -122.433411295115) | 15 | 5 | 5 | 28862 | 3 | |||
| 26326 | 225834 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1201 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010880.09664 | 2102425.66941 | 37.7534738174881 | -122.40527417026 | (37.7534738174881, -122.40527417026) | 10 | 4 | 8 | 28859 | 19 | |||
| 26497 | 141790 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1280 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6003808.9126 | 2112898.5974 | 37.7818320649833 | -122.430475034423 | (37.7818320649833, -122.430475034423) | 7 | 9 | 11 | 29490 | 41 | |||
| 26535 | 5944 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003654.4203 | 2112794.2785 | 37.7815368785362 | -122.431002057977 | (37.7815368785362, -122.431002057977) | 15 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 28014 | 5941 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1155X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003735.29014 | 2112772.66113 | 37.7814821046204 | -122.430720744107 | (37.7814821046204, -122.430720744107) | 15 | 9 | 11 | 29490 | 41 | |||
| 28902 | 128835 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6002002.11764 | 2116066.62683 | 37.7904281483977 | -122.436952564533 | (37.7904281483977, -122.436952564533) | 13 | 6 | 1 | 29490 | 27 | |||
| 29375 | 23140 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.7446440145012 | -122.426661469126 | (37.7446440145012, -122.426661469126) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 29522 | 102830 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x12 | 6000750.2 | 2109361.5 | 37.7719463488262 | -122.440802922949 | (37.7719463488262, -122.440802922949) | 15 | 5 | 11 | 29492 | 9 | ||||
| 29813 | 141878 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1130 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003852.9179 | 2112548.3998 | 37.7808730023316 | -122.4302978041 | (37.7808730023316, -122.4302978041) | 7 | 9 | 11 | 29490 | 41 | |||
| 30057 | 142002 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 681 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004463.7555 | 2111518.3082 | 37.778079205485 | -122.428111187061 | (37.778079205485, -122.428111187061) | 7 | 9 | 11 | 28852 | 10 | |||
| 30138 | 16656 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 200 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6002872.09203 | 2107040.69534 | 37.7656946022435 | -122.433297284454 | (37.7656946022435, -122.433297284454) | 15 | 5 | 5 | 28862 | 3 | |||
| 30151 | 1324 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 4051X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 5991764.76245 | 2086963.37686 | 37.7099309898835 | -122.470252581934 | (37.7099309898835, -122.470252581934) | 9 | 8 | 4 | 64 | 24 | |||
| 30390 | 23721 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 802X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003990.0153246 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | 7 | 9 | 11 | 28852 | 41 | |||
| 31663 | 165 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | 15 | 5 | 5 | 28862 | 3 | |||
| 32021 | 247292 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1177 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999383.1114 | 2108836.268 | 37.7704262435841 | -122.445493992117 | (37.7704262435841, -122.445493992117) | 15 | 5 | 11 | 29492 | 9 | |||
| 32190 | 56267 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.421648953731 | (37.7577455134305, -122.421648953731) | 2 | 4 | 5 | 28859 | 19 | |
| 32192 | 141999 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 818 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003970.657 | 2111746.2039 | 37.7786770397608 | -122.429833251248 | (37.7786770397608, -122.429833251248) | 7 | 9 | 11 | 29490 | 41 | |||
| 32451 | 138435 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1601 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003509.4651 | 2114326.354 | 37.7857353585392 | -122.431612946728 | (37.7857353585392, -122.431612946728) | 13 | 9 | 11 | 29490 | 13 | |||
| 32575 | 8110 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 790X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6004003.8918438 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | 7 | 9 | 11 | 28852 | 10 | |||
| 32987 | 16652 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 198 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6002855.56746 | 2107156.83131 | 37.7660125458771 | -122.43336273892 | (37.7660125458771, -122.43336273892) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | |||
| 33357 | 246264 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2298 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002930.8432 | 2106681.6365 | 37.7647120467347 | -122.433068420975 | (37.7647120467347, -122.433068420975) | 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 |
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) );