trees
286 rows where qSpecies_id = 74
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73877 | 219514 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992615.02777 | 2096610.18146 | 37.7364678749865 | -122.468015164161 | (37.7364678749865, -122.468015164161) | 1 | 8 | 4 | 59 | 40 | |||
| 74093 | 219506 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 65 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992621.37254 | 2096400.00635 | 37.7358911532574 | -122.467977944832 | (37.7358911532574, -122.467977944832) | 1 | 8 | 4 | 59 | 40 | |||
| 74265 | 219581 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 201 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993830.50755 | 2099471.62985 | 37.7443948142649 | -122.464020422411 | (37.7443948142649, -122.464020422411) | 1 | 8 | 4 | 29491 | 40 | |||
| 74416 | 215464 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 155 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995075.02131 | 2100739.26228 | 37.7479470608168 | -122.459808986296 | (37.7479470608168, -122.459808986296) | 1 | 8 | 4 | 29491 | 40 | |||
| 74552 | 19089 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 245 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994528.08002 | 2087391.0087 | 37.7112645409908 | -122.460733072089 | (37.7112645409908, -122.460733072089) | 9 | 8 | 6 | 28861 | 24 | |||
| 76459 | 219568 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 432 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993595.89147 | 2099490.15845 | 37.7444321649285 | -122.464833014754 | (37.7444321649285, -122.464833014754) | 1 | 8 | 4 | 29491 | 40 | |||
| 76935 | 64409 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 215 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25255 | 6006726.83577731 | 2098456.71661789 | 37.7423428955731 | -122.419355526894 | (37.7423428955731, -122.419355526894) | 2 | 7 | 7 | 28859 | 2 | |
| 77444 | 219580 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 320 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994238.61211 | 2099950.79183 | 37.7457339839424 | -122.462644044196 | (37.7457339839424, -122.462644044196) | 1 | 8 | 4 | 29491 | 40 | |||
| 77772 | 1174 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 5996843.31726 | 2087475.01833 | 37.7116281495005 | -122.452737133232 | (37.7116281495005, -122.452737133232) | 9 | 7 | 6 | 28861 | 25 | |||
| 78722 | 219462 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 141 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5992648.10165 | 2095694.10938 | 37.7339544803051 | -122.467834207082 | (37.7339544803051, -122.467834207082) | 9 | 8 | 4 | 59 | 40 | |||
| 79202 | 1022 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1909 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000975.40411 | 2090904.61398 | 37.7212809588173 | -122.438701158651 | (37.7212809588173, -122.438701158651) | 9 | 7 | 6 | 28861 | 25 | |||
| 79410 | 215451 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5992603.36881 | 2095771.61937 | 37.7341647202147 | -122.467994496876 | (37.7341647202147, -122.467994496876) | 9 | 8 | 4 | 59 | 40 | |||
| 79485 | 219575 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 215 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993599.71947 | 2099709.46865 | 37.7450345560008 | -122.464835701903 | (37.7450345560008, -122.464835701903) | 1 | 8 | 4 | 29491 | 40 | |||
| 80413 | 215467 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995042.95861 | 2100982.39636 | 37.7486128019409 | -122.459937467057 | (37.7486128019409, -122.459937467057) | 1 | 8 | 4 | 29491 | 40 | |||
| 82287 | 1077 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2125 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6000118.83057 | 2089820.59476 | 37.7182557213131 | -122.44158433025 | (37.7182557213131, -122.44158433025) | 9 | 7 | 6 | 28861 | 25 | |||
| 83310 | 180509 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2500 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010776.88958 | 2086485.57277 | 37.7096998986965 | -122.4045091134 | (37.7096998986965, -122.4045091134) | 10 | 3 | 8 | 309 | 1 | |||
| 83350 | 215466 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5995052.95095 | 2100968.80441 | 37.7485760565417 | -122.459901929455 | (37.7485760565417, -122.459901929455) | 1 | 8 | 4 | 29491 | 40 | |||
| 83668 | 219470 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 195 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992655.36284 | 2095444.36492 | 37.7332691636304 | -122.467790945215 | (37.7332691636304, -122.467790945215) | 9 | 8 | 4 | 59 | 40 | |||
| 83747 | 1864 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2555 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 3 | 3X3 | 6010698.44639 | 2086315.70345 | 37.7092290874102 | -122.404768277337 | (37.7092290874102, -122.404768277337) | 10 | 3 | 8 | 309 | 1 | ||
| 84180 | 219571 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993693.09404 | 2099500.59064 | 37.7444664129069 | -122.464497668332 | (37.7444664129069, -122.464497668332) | 1 | 8 | 4 | 29491 | 40 | |||
| 85970 | 219458 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 125 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992642.59495 | 2095810.90237 | 37.7342748466983 | -122.467861737123 | (37.7342748466983, -122.467861737123) | 9 | 8 | 4 | 59 | 40 | |||
| 86131 | 219468 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 195 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992655.03542 | 2095482.88699 | 37.7333749167204 | -122.467794877953 | (37.7333749167204, -122.467794877953) | 9 | 8 | 4 | 59 | 40 | |||
| 86613 | 219512 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 41 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992615.55608 | 2096571.31124 | 37.7363611776267 | -122.468010511076 | (37.7363611776267, -122.468010511076) | 1 | 8 | 4 | 59 | 40 | |||
| 87045 | 1018 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1867 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6001202.49586 | 2091340.5101 | 37.7224907475345 | -122.437947374798 | (37.7224907475345, -122.437947374798) | 9 | 7 | 6 | 28861 | 25 | |||
| 87126 | 219480 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 40 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992573.35664 | 2096580.23843 | 37.7363832523767 | -122.468157060102 | (37.7363832523767, -122.468157060102) | 1 | 8 | 4 | 59 | 40 | |||
| 87202 | 219583 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 201 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5993863.59028 | 2099405.60943 | 37.7442154454004 | -122.463901238844 | (37.7442154454004, -122.463901238844) | 1 | 8 | 4 | 29491 | 40 | |||
| 88060 | 219529 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3798 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990509.31034 | 2090609.6806 | 37.7198701806571 | -122.474857591227 | (37.7198701806571, -122.474857591227) | 9 | 8 | 4 | 64 | 40 | |||
| 88369 | 219504 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 65 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992624.10653 | 2096354.05467 | 37.7357651393451 | -122.467965151081 | (37.7357651393451, -122.467965151081) | 1 | 8 | 4 | 59 | 40 | |||
| 88466 | 219456 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 115 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5992639.24928 | 2095904.23823 | 37.734530930444 | -122.467880090494 | (37.734530930444, -122.467880090494) | 9 | 8 | 4 | 59 | 40 | |||
| 89209 | 219577 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 250 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993372.19825 | 2099725.86442 | 37.7450664540558 | -122.465623614159 | (37.7450664540558, -122.465623614159) | 1 | 8 | 4 | 29491 | 40 | |||
| 89582 | 180498 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2059 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000514.10075 | 2090205.66552 | 37.7193355507714 | -122.440245651613 | (37.7193355507714, -122.440245651613) | 9 | 7 | 6 | 28861 | 25 | |||
| 90049 | 19079 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 219 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5994761.18216 | 2087388.38548 | 37.7112707472265 | -122.459927228278 | (37.7112707472265, -122.459927228278) | 9 | 8 | 6 | 28861 | 24 | |||
| 90137 | 219501 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 75 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992625.26831 | 2096281.33572 | 37.7355655384208 | -122.467955846711 | (37.7355655384208, -122.467955846711) | 1 | 8 | 4 | 59 | 40 | |||
| 90190 | 219539 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3774 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990471.08973 | 2090949.21154 | 37.7208002334236 | -122.475014477034 | (37.7208002334236, -122.475014477034) | 9 | 8 | 4 | 64 | 40 | |||
| 90384 | 219499 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 89 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992627.94959 | 2096200.87994 | 37.7353447818384 | -122.467940726393 | (37.7353447818384, -122.467940726393) | 1 | 8 | 4 | 59 | 40 | |||
| 91221 | 219554 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 540 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5992988.81952 | 2099440.93268 | 37.7442619835139 | -122.466928548418 | (37.7442619835139, -122.466928548418) | 1 | 8 | 4 | 29491 | 40 | |||
| 91277 | 219497 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 89 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992628.80524 | 2096145.58724 | 37.7351930113401 | -122.46793374764 | (37.7351930113401, -122.46793374764) | 1 | 8 | 4 | 59 | 40 | |||
| 91654 | 215462 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 196 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992612.69306 | 2095452.3609 | 37.7332886546337 | -122.467939046451 | (37.7332886546337, -122.467939046451) | 9 | 8 | 4 | 59 | 40 | |||
| 92095 | 17221 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1875X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6001098.52222 | 2091140.53503 | 37.7219357480204 | -122.438292468038 | (37.7219357480204, -122.438292468038) | 9 | 7 | 6 | 28861 | 25 | |||
| 92153 | 117518 | Significant Tree 6 | Ulmus americana :: American Elm 74 | 30 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | Permit Number 777803 | 5993995.8 | 2097679.6 | 37.7394838741894 | -122.463318866351 | (37.7394838741894, -122.463318866351) | 1 | 8 | 4 | 59 | 40 | ||
| 92510 | 242357 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 619 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007454.61895 | 2096052.89461 | 37.7357834945126 | -122.416668815323 | (37.7357834945126, -122.416668815323) | 2 | 7 | 7 | 28859 | 2 | |||
| 94712 | 242365 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004152.28939 | 2108699.9482 | 37.7703230522076 | -122.428987669363 | (37.7703230522076, -122.428987669363) | 7 | 9 | 5 | 29492 | 10 | |||
| 94899 | 407 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3826 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 2X3 | 5990704.40844 | 2090329.91237 | 37.7191133102994 | -122.47416280918 | (37.7191133102994, -122.47416280918) | 9 | 8 | 4 | 64 | 40 | |||
| 97199 | 180502 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2003 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6000738.6193 | 2090458.82485 | 37.7200434494224 | -122.4394877147 | (37.7200434494224, -122.4394877147) | 9 | 7 | 6 | 28861 | 25 | |||
| 97470 | 1178 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5996742.67365 | 2087394.80201 | 37.7114021264716 | -122.453079195751 | (37.7114021264716, -122.453079195751) | 9 | 7 | 6 | 28861 | 25 | |||
| 97722 | 1082 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6000045.94187 | 2089750.00425 | 37.7180577427488 | -122.44183121126 | (37.7180577427488, -122.44183121126) | 9 | 7 | 6 | 28861 | 25 | |||
| 98169 | 1012 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1845 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001257.97709 | 2091441.77631 | 37.7227719565453 | -122.437762838379 | (37.7227719565453, -122.437762838379) | 9 | 7 | 6 | 28861 | 25 | |||
| 98921 | 219557 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 500 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993193.55184 | 2099470.33756 | 37.7443545363406 | -122.466222770361 | (37.7443545363406, -122.466222770361) | 1 | 8 | 4 | 29491 | 40 | |||
| 99216 | 1310 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4035 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X6 | 5991848.72186 | 2087031.07112 | 37.7101217158162 | -122.469967330646 | (37.7101217158162, -122.469967330646) | 9 | 8 | 4 | 64 | 24 | |||
| 99530 | 215449 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 120 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992601.94776 | 2095825.37047 | 37.7343122252356 | -122.468003318313 | (37.7343122252356, -122.468003318313) | 9 | 8 | 4 | 59 | 40 | |||
| 102654 | 219550 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 584 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992742.68217 | 2099422.51229 | 37.7441971963417 | -122.467778291755 | (37.7441971963417, -122.467778291755) | 1 | 8 | 4 | 29491 | 40 | |||
| 103253 | 215452 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992604.2406 | 2095761.0748 | 37.7341358178054 | -122.467990716115 | (37.7341358178054, -122.467990716115) | 9 | 8 | 4 | 59 | 40 | |||
| 104999 | 405 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3818 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X5 | 5990665.10533 | 2090381.89852 | 37.719253774519 | -122.474302455007 | (37.719253774519, -122.474302455007) | 9 | 8 | 4 | 64 | 40 | |||
| 105688 | 219511 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 41 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992616.80765 | 2096550.85016 | 37.736305068912 | -122.468004696059 | (37.736305068912, -122.468004696059) | 1 | 8 | 4 | 59 | 40 | |||
| 105716 | 84297 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1369-1369 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52440 | 6008956.5592 | 2109575.0604 | 37.772996675036 | -122.41243151374 | (37.772996675036, -122.41243151374) | 8 | 2 | 9 | 28853 | 34 | |
| 106423 | 219471 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992545.99069 | 2096862.54215 | 37.7371568069404 | -122.468272205699 | (37.7371568069404, -122.468272205699) | 1 | 8 | 4 | 59 | 40 | |||
| 107099 | 215447 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 110 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992597.98393 | 2095879.53795 | 37.7344607266837 | -122.468020961215 | (37.7344607266837, -122.468020961215) | 9 | 8 | 4 | 59 | 40 | |||
| 108561 | 219524 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 751 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991357.23794 | 2092104.99366 | 37.7240250422104 | -122.472035561797 | (37.7240250422104, -122.472035561797) | 9 | 8 | 4 | 59 | 40 | |||
| 109261 | 19049 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 129 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995630.2780118 | 2087392.9172085 | 37.7113331356468 | -122.456923761037 | (37.7113331356468, -122.456923761037) | 9 | 8 | 6 | 28861 | 24 | |||
| 109330 | 242355 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 215 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006802.79352 | 2098409.45176 | 37.7422173946201 | -122.419089535751 | (37.7422173946201, -122.419089535751) | 2 | 7 | 7 | 28859 | 2 | |||
| 112212 | 219519 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 25 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992609.905 | 2096718.49186 | 37.7367649723144 | -122.468040751674 | (37.7367649723144, -122.468040751674) | 1 | 8 | 4 | 59 | 40 | |||
| 113494 | 29962 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991375.88875 | 2094170.02081 | 37.729696171533 | -122.472121539675 | (37.729696171533, -122.472121539675) | 9 | 8 | 4 | 64 | 40 | ||
| 115165 | 19054 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 147 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5995468.13357 | 2087379.87793 | 37.7112880204961 | -122.457483227074 | (37.7112880204961, -122.457483227074) | 9 | 8 | 6 | 28861 | 24 | |||
| 116407 | 219516 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992613.16178 | 2096649.41488 | 37.73657549235 | -122.468024468563 | (37.73657549235, -122.468024468563) | 1 | 8 | 4 | 59 | 40 | |||
| 116673 | 219520 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 15 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992608.23435 | 2096751.02117 | 37.7368541931494 | -122.468048893267 | (37.7368541931494, -122.468048893267) | 1 | 8 | 4 | 59 | 40 | |||
| 116989 | 1313 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4055 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X6 | 5991770.79861 | 2086968.57426 | 37.7099456096734 | -122.470232098246 | (37.7099456096734, -122.470232098246) | 9 | 8 | 4 | 64 | 24 | |||
| 117044 | 219526 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 121 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995598.71297 | 2087377.82947 | 37.7112898955879 | -122.457031766517 | (37.7112898955879, -122.457031766517) | 9 | 8 | 6 | 28861 | 24 | |||
| 119521 | 219478 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 30 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992570.88525 | 2096654.65896 | 37.7365874497346 | -122.468171016701 | (37.7365874497346, -122.468171016701) | 1 | 8 | 4 | 59 | 40 | |||
| 119766 | 219474 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992559.60263 | 2096805.97754 | 37.7370022809142 | -122.468221029778 | (37.7370022809142, -122.468221029778) | 1 | 8 | 4 | 59 | 40 | |||
| 119775 | 233 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X4 | 5990616.42168 | 2095336.99138 | 37.7328563982031 | -122.474832216845 | (37.7328563982031, -122.474832216845) | 1 | 8 | 4 | 64 | 40 | |||
| 120298 | 1233 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5993343.79351 | 2087539.5057 | 37.7116040683488 | -122.464837007716 | (37.7116040683488, -122.464837007716) | 9 | 8 | 4 | 64 | 24 | |||
| 120581 | 242369 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 233 Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004255.94534 | 2108711.38345 | 37.7703603174149 | -122.428629938834 | (37.7703603174149, -122.428629938834) | 7 | 9 | 5 | 29492 | 10 | |||
| 121628 | 1070 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3X3 | 6000193.5332 | 2089890.50062 | 37.7184519227936 | -122.441331128839 | (37.7184519227936, -122.441331128839) | 9 | 7 | 6 | 28861 | 25 | |||
| 122136 | 1192 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3047 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 1X2 | 5996542.59797 | 2087158.26518 | 37.710741182331 | -122.453753635137 | (37.710741182331, -122.453753635137) | 9 | 7 | 6 | 28861 | 25 | |||
| 122629 | 390 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3790X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2 | 5990465.39673 | 2090774.00996 | 37.7203188434295 | -122.475021373044 | (37.7203188434295, -122.475021373044) | 9 | 8 | 4 | 64 | 40 | |||
| 125573 | 219565 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 456 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5993467.92544 | 2099480.37304 | 37.7443979178455 | -122.465274780618 | (37.7443979178455, -122.465274780618) | 1 | 8 | 4 | 29491 | 40 | |||
| 126341 | 219503 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 75 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992624.10282 | 2096321.89499 | 37.7356768367092 | -122.467962825444 | (37.7356768367092, -122.467962825444) | 1 | 8 | 4 | 59 | 40 | |||
| 126701 | 180499 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2055 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000543.56528 | 2090231.5563 | 37.7194083185059 | -122.440145659613 | (37.7194083185059, -122.440145659613) | 9 | 7 | 6 | 28861 | 25 | |||
| 127045 | 117053 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 5997209.5044 | 2116053.97345 | 37.7901198401005 | -122.453533689754 | (37.7901198401005, -122.453533689754) | 11 | 6 | 1 | 54 | 31 | |||
| 127844 | 242358 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 569 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007471.61723 | 2096250.01155 | 37.7363256903806 | -122.416624004798 | (37.7363256903806, -122.416624004798) | 2 | 7 | 7 | 28859 | 2 | |||
| 128210 | 219587 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 100 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 5992597.45757 | 2095923.83271 | 37.7345823186193 | -122.468026001902 | (37.7345823186193, -122.468026001902) | 9 | 8 | 4 | 59 | 40 | |||
| 128531 | 215468 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 140 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5995041.47526 | 2100911.57821 | 37.7484182678045 | -122.459937467056 | (37.7484182678045, -122.459937467056) | 1 | 8 | 4 | 29491 | 40 | |||
| 129511 | 219477 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 30 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992571.34305 | 2096676.4237 | 37.7366472366842 | -122.468171016694 | (37.7366472366842, -122.468171016694) | 1 | 8 | 4 | 59 | 40 | |||
| 129619 | 17220 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1875X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6001085.65168 | 2091116.17371 | 37.7218681252969 | -122.438335213721 | (37.7218681252969, -122.438335213721) | 9 | 7 | 6 | 28861 | 25 | |||
| 131091 | 25430 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2118 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1997 12:00:00 AM | 6 | 3X3 | 6011929.29613 | 2087786.5725 | 37.7133365214367 | -122.400617498717 | (37.7133365214367, -122.400617498717) | 10 | 7 | 8 | 309 | 39 | ||
| 132143 | 180488 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 434 Huron Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5998779.43876 | 2088603.45048 | 37.7148373199676 | -122.44612652085 | (37.7148373199676, -122.44612652085) | 9 | 7 | 6 | 28861 | 25 | |||
| 132505 | 219487 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 66 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992581.45271 | 2096373.37647 | 37.7358157289051 | -122.468114025768 | (37.7358157289051, -122.468114025768) | 1 | 8 | 4 | 59 | 40 | |||
| 133524 | 219515 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 35 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992614.77796 | 2096630.2864 | 37.7365230636791 | -122.468017489821 | (37.7365230636791, -122.468017489821) | 1 | 8 | 4 | 59 | 40 | |||
| 134532 | 219573 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 140 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5993734.74084 | 2099541.05519 | 37.7445799190316 | -122.46435660067 | (37.7445799190316, -122.46435660067) | 1 | 8 | 4 | 29491 | 40 | |||
| 136346 | 25439 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2401 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1997 12:00:00 AM | 3 | 3x3 | 6011150.97537 | 2087110.40453 | 37.7114364608051 | -122.403260124179 | (37.7114364608051, -122.403260124179) | 10 | 3 | 8 | 309 | 1 | ||
| 136938 | 242353 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 472 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 5998570.9732 | 2106433.24481 | 37.7637817532369 | -122.448130115038 | (37.7637817532369, -122.448130115038) | 15 | 5 | 11 | 29492 | 9 | |||
| 138511 | 180493 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3163 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995731.65538 | 2086919.46942 | 37.7100389790737 | -122.456539161954 | (37.7100389790737, -122.456539161954) | 9 | 7 | 6 | 28861 | 25 | |||
| 139058 | 219562 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 474 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993376.84863 | 2099471.9511 | 37.7443695406169 | -122.465589090967 | (37.7443695406169, -122.465589090967) | 1 | 8 | 4 | 29491 | 40 | |||
| 139950 | 219543 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 4 | Width 0ft | 5991389.00988 | 2094463.60901 | 37.7305030504606 | -122.472097570066 | (37.7305030504606, -122.472097570066) | 9 | 8 | 4 | 64 | 40 | |||
| 140972 | 219505 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 65 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992622.51145 | 2096374.1879 | 37.7358203280358 | -122.467972129825 | (37.7358203280358, -122.467972129825) | 1 | 8 | 4 | 59 | 40 | |||
| 141609 | 219460 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992644.33525 | 2095767.44219 | 37.7341556163962 | -122.46785256047 | (37.7341556163962, -122.46785256047) | 9 | 8 | 4 | 59 | 40 | |||
| 141948 | 219509 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 45 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 8ft | 5992617.13851 | 2096502.60389 | 37.736172615865 | -122.46800004387 | (37.736172615865, -122.46800004387) | 1 | 8 | 4 | 59 | 40 | |||
| 141997 | 219467 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 165 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5992654.89634 | 2095512.3426 | 37.7334557864464 | -122.467797500378 | (37.7334557864464, -122.467797500378) | 9 | 8 | 4 | 59 | 40 | |||
| 144712 | 219491 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 80 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992586.43112 | 2096226.20805 | 37.7354119288232 | -122.468086111696 | (37.7354119288232, -122.468086111696) | 1 | 8 | 4 | 59 | 40 | |||
| 146078 | 219579 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 396 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993828.63857 | 2099567.99676 | 37.7446593057809 | -122.464033878966 | (37.7446593057809, -122.464033878966) | 1 | 8 | 4 | 29491 | 40 |
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) );