trees
286 rows where qSpecies_id = 74 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 46039 | 1017 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1863 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001211.31639 | 2091358.64779 | 37.7225410511223 | -122.437918182794 | (37.7225410511223, -122.437918182794) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 71098 | 1020 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1871 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6001188.68996 | 2091314.66638 | 37.7224190014148 | -122.437993248302 | (37.7224190014148, -122.437993248302) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 210 | 1023 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1925 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000937.4135 | 2090832.4174 | 37.7210805620079 | -122.438827310136 | (37.7210805620079, -122.438827310136) | 9 | 7 | 6 | 28861 | 25 | |||
| 176249 | 1067 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2087X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000311.61814 | 2090004.87585 | 37.7187726974675 | -122.440931159865 | (37.7187726974675, -122.440931159865) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 172004 | 1080 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2143 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6000078.80203 | 2089782.45851 | 37.7181487271488 | -122.441719956114 | (37.7181487271488, -122.441719956114) | 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 | |||
| 34902 | 1084 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2155 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000026.48644 | 2089733.60344 | 37.7180116012293 | -122.441897283559 | (37.7180116012293, -122.441897283559) | 9 | 7 | 6 | 28861 | 25 | |||
| 20327 | 109501 | Private 9 | Ulmus americana :: American Elm 74 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard | Tree | Private 2 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.8021053817179 | -122.404424889694 | (37.8021053817179, -122.404424889694) | 3 | 1 | 10 | 308 | 23 | ||||
| 161011 | 1132 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2565 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 5998605.29781 | 2088582.84713 | 37.7147708016152 | -122.446726940623 | (37.7147708016152, -122.446726940623) | 9 | 7 | 6 | 28861 | 25 | |||
| 8134 | 1169 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5996958.76452 | 2087574.18326 | 37.7119070481533 | -122.452345269826 | (37.7119070481533, -122.452345269826) | 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 | |||
| 15962 | 117054 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3570 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778339 | 5997182.58708 | 2116049.71281 | 37.7901065984817 | -122.453626513253 | (37.7901065984817, -122.453626513253) | 11 | 6 | 1 | 54 | 31 | |
| 17513 | 1171 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5996917.80808 | 2087537.65552 | 37.7118044049283 | -122.452484191688 | (37.7118044049283, -122.452484191688) | 9 | 7 | 6 | 28861 | 25 | |||
| 185799 | 11726 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 899X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 40894 | 1173 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 5996863.34156 | 2087489.7045 | 37.7116696217356 | -122.452668983506 | (37.7116696217356, -122.452668983506) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | ||
| 42656 | 1176 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x7 | 5996790.08186 | 2087431.57248 | 37.7115058066164 | -122.452917994084 | (37.7115058066164, -122.452917994084) | 9 | 7 | 6 | 28861 | 25 | |||
| 170790 | 1177 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2900 Alemany Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5996769.26781 | 2087415.39261 | 37.7114601876211 | -122.452988765336 | (37.7114601876211, -122.452988765336) | 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 | |||
| 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 | |||
| 62832 | 119698 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 57205 | 1207 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3141 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5995985.58699 | 2086962.17792 | 37.710170822386 | -122.455664615342 | (37.710170822386, -122.455664615342) | 9 | 7 | 6 | 28861 | 25 | |||
| 168524 | 1209 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3147 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 5995880.33209 | 2086940.05264 | 37.7101040306546 | -122.456026796619 | (37.7101040306546, -122.456026796619) | 9 | 7 | 6 | 28861 | 25 | |||
| 70434 | 1210 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3149 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5995849.95134 | 2086935.52226 | 37.7100898474467 | -122.456131470508 | (37.7100898474467, -122.456131470508) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 13068 | 1286 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3928 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 6x5 | 5992480.71384 | 2087450.61333 | 37.7113101914743 | -122.467813554168 | (37.7113101914743, -122.467813554168) | 9 | 8 | 4 | 64 | 24 | |||
| 65958 | 1307 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4001 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X6 | 5991965.2566 | 2087108.33774 | 37.7103406072022 | -122.46957018822 | (37.7103406072022, -122.46957018822) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 32585 | 1312 | Permitted Site 7 | Ulmus americana :: American Elm 74 | 4043 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x5 | 5991834.02635 | 2087022.6898 | 37.7100978532157 | -122.470017510902 | (37.7100978532157, -122.470017510902) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 7578 | 136957 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2411 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002488.64673 | 2117068.27748 | 37.7932060642605 | -122.435340887694 | (37.7932060642605, -122.435340887694) | 13 | 9 | 1 | 29490 | 27 | |||
| 38855 | 139051 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2669 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999827.1373 | 2113991.9623 | 37.7846078002996 | -122.444328673472 | (37.7846078002996, -122.444328673472) | 15 | 6 | 11 | 29490 | 31 | |||
| 159778 | 17219 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1875X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6001071.69008 | 2091082.82466 | 37.7217757622246 | -122.438381087239 | (37.7217757622246, -122.438381087239) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 159629 | 180486 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2091 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6000288.07511 | 2089979.94333 | 37.7187028974975 | -122.441010750768 | (37.7187028974975, -122.441010750768) | 9 | 7 | 6 | 28861 | 25 | |||
| 27534 | 180487 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2079 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000343.28213 | 2090036.11194 | 37.7188602680644 | -122.440823949885 | (37.7188602680644, -122.440823949885) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 46610 | 180489 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 434 Huron Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998732.6593 | 2088560.74965 | 37.7147174016639 | -122.446285139651 | (37.7147174016639, -122.446285139651) | 9 | 7 | 6 | 28861 | 25 | |||
| 151404 | 180490 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3019 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5996681.72081 | 2087250.51406 | 37.7110024515725 | -122.453279453211 | (37.7110024515725, -122.453279453211) | 9 | 7 | 6 | 28861 | 25 | |||
| 174554 | 180491 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3019 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5996704.34387 | 2087265.59196 | 37.7110451486737 | -122.453202350731 | (37.7110451486737, -122.453202350731) | 9 | 7 | 6 | 28861 | 25 | |||
| 182067 | 180492 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3163 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 2ft | 5995698.84362 | 2086914.014 | 37.7100221158864 | -122.456652170788 | (37.7100221158864, -122.456652170788) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 178691 | 180494 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3163 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5995762.75975 | 2086924.30814 | 37.7100540508169 | -122.45643200954 | (37.7100540508169, -122.45643200954) | 9 | 7 | 6 | 28861 | 25 | |||
| 51001 | 180495 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3135 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5996019.45689 | 2086971.09551 | 37.7101972516624 | -122.45554819901 | (37.7101972516624, -122.45554819901) | 9 | 7 | 6 | 28861 | 25 | |||
| 39345 | 180496 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2067 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000450.00528 | 2090141.8929 | 37.7191567961292 | -122.440462633746 | (37.7191567961292, -122.440462633746) | 9 | 7 | 6 | 28861 | 25 | |||
| 159036 | 180497 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2061 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000499.29084 | 2090188.97711 | 37.7192888849654 | -122.440295647643 | (37.7192888849654, -122.440295647643) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 165548 | 180500 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2051 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000567.81295 | 2090256.97916 | 37.719479504361 | -122.440063666607 | (37.719479504361, -122.440063666607) | 9 | 7 | 6 | 28861 | 25 | |||
| 24193 | 180501 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2019 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6000600.83666 | 2090287.11698 | 37.7195641359612 | -122.439951675834 | (37.7195641359612, -122.439951675834) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 194269 | 180503 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 4x4 | Permit Number 785142 | 6000822.0474 | 2090606.84585 | 37.7204546293715 | -122.439209936613 | (37.7204546293715, -122.439209936613) | 9 | 7 | 6 | 28861 | 25 | ||
| 194283 | 180504 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 2ft | Permit Number 785142 | 6000839.04929 | 2090641.3338 | 37.720550292949 | -122.439153637233 | (37.720550292949, -122.439153637233) | 9 | 7 | 6 | 28861 | 25 | ||
| 194259 | 180505 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | Permit Number 785142 | 6000851.90782 | 2090665.09489 | 37.7206162672045 | -122.43911089157 | (37.7206162672045, -122.43911089157) | 9 | 7 | 6 | 28861 | 25 | ||
| 12368 | 180506 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1985 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6000867.32742 | 2090696.01152 | 37.7207020346632 | -122.439059805593 | (37.7207020346632, -122.439059805593) | 9 | 7 | 6 | 28861 | 25 | |||
| 191194 | 180507 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1971 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 6000896.20852 | 2090750.67644 | 37.7208537754604 | -122.438963888373 | (37.7208537754604, -122.438963888373) | 9 | 7 | 6 | 28861 | 25 | |||
| 40986 | 180508 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2500 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010763.65816 | 2086463.16447 | 37.7096376305352 | -122.404553267433 | (37.7096376305352, -122.404553267433) | 10 | 3 | 8 | 309 | 1 | |||
| 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 | |||
| 38865 | 180510 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4035 Alemany Blvd | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5991869.02362 | 2087044.73214 | 37.7101603992515 | -122.469898158374 | (37.7101603992515, -122.469898158374) | 9 | 8 | 4 | 64 | 24 | |||
| 187781 | 180511 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3597 Alemany Blvd | 1 | : | Tree | Private 2 | 18 | Width 3ft | 5993538.56271 | 2087481.65959 | 37.711456464416 | -122.464159641976 | (37.711456464416, -122.464159641976) | 9 | 8 | 4 | 64 | 24 | |||
| 192840 | 1814 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2090 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1997 12:00:00 AM | 6 | 3X3 | 6012058.52275 | 2087947.72362 | 37.713786216629 | -122.400182154876 | (37.713786216629, -122.400182154876) | 10 | 7 | 8 | 309 | 39 | ||
| 156960 | 1829 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6011803.61651 | 2087487.56349 | 37.7125084922469 | -122.401030897272 | (37.7125084922469, -122.401030897272) | 10 | 3 | 8 | 309 | 1 | |||
| 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 | ||
| 178351 | 19048 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 129 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5995630.2780118 | 2087392.9172085 | 37.7113331356468 | -122.456923761037 | (37.7113331356468, -122.456923761037) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 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 | |||
| 42845 | 19076 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 212 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5994913.18282 | 2087466.94262 | 37.711495187435 | -122.459407564904 | (37.711495187435, -122.459407564904) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 64904 | 19087 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 237 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5994597.47912 | 2087391.16897 | 37.7112689737487 | -122.460493224683 | (37.7112689737487, -122.460493224683) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 53558 | 19092 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 253 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994541.9924055 | 2087407.5063683 | 37.7113106401579 | -122.46068618252 | (37.7113106401579, -122.46068618252) | 9 | 8 | 6 | 28861 | 24 | |||
| 14006 | 19096 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 265 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5994373.4122 | 2087391.66656 | 37.7112574471572 | -122.46126768668 | (37.7112574471572, -122.46126768668) | 9 | 8 | 6 | 28861 | 24 | |||
| 36726 | 19098 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 277 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994301.47387 | 2087394.14332 | 37.7112601073303 | -122.461516501212 | (37.7112601073303, -122.461516501212) | 9 | 8 | 6 | 28861 | 24 | |||
| 63663 | 21035 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
| 11616 | 21036 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
| 146696 | 21045 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
| 169884 | 215446 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 110 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992597.86385 | 2095891.15575 | 37.7344926193226 | -122.468022221156 | (37.7344926193226, -122.468022221156) | 9 | 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 | |||
| 149140 | 215448 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 110 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992599.75801 | 2095859.89979 | 37.7344069076591 | -122.468013399705 | (37.7344069076591, -122.468013399705) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 53999 | 215450 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 120 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992601.06459 | 2095800.70653 | 37.7342444532197 | -122.46800457827 | (37.7342444532197, -122.46800457827) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 64275 | 215453 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 130 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992604.15491 | 2095739.66057 | 37.7340770147327 | -122.467989455265 | (37.7340770147327, -122.467989455265) | 9 | 8 | 4 | 59 | 40 | |||
| 44877 | 215454 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 160 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5992606.05096 | 2095656.49757 | 37.7338487794048 | -122.467976853054 | (37.7338487794048, -122.467976853054) | 9 | 8 | 4 | 59 | 40 | |||
| 158534 | 215455 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 160 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 5992606.29113 | 2095633.26163 | 37.7337849931862 | -122.467974333173 | (37.7337849931862, -122.467974333173) | 9 | 8 | 4 | 59 | 40 | |||
| 40895 | 215456 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 170 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992607.47204 | 2095602.74615 | 37.7337012734937 | -122.467968031596 | (37.7337012734937, -122.467968031596) | 9 | 8 | 4 | 59 | 40 | |||
| 33294 | 215457 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 170 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992608.79004 | 2095578.76173 | 37.7336354943765 | -122.467961730965 | (37.7336354943765, -122.467961730965) | 9 | 8 | 4 | 59 | 40 | |||
| 182954 | 215458 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 180 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992610.41916 | 2095552.22945 | 37.7335627374372 | -122.467954169463 | (37.7335627374372, -122.467954169463) | 9 | 8 | 4 | 59 | 40 | |||
| 166805 | 215459 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 180 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992611.44157 | 2095531.51805 | 37.7335059281442 | -122.467949128772 | (37.7335059281442, -122.467949128772) | 9 | 8 | 4 | 59 | 40 | |||
| 161179 | 215460 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 180 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5992612.98876 | 2095518.41795 | 37.7334700478853 | -122.467942827217 | (37.7334700478853, -122.467942827217) | 9 | 8 | 4 | 59 | 40 | |||
| 171726 | 215461 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 196 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992613.18906 | 2095475.94459 | 37.7333534382047 | -122.467939046448 | (37.7333534382047, -122.467939046448) | 9 | 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 |
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) );