trees
286 rows where qSpecies_id = 74 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 193485 | 25433 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2520 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1997 12:00:00 AM | 3 | 3X3 | 6010733.72503 | 2086629.56111 | 37.7100928493748 | -122.404668428307 | (37.7100928493748, -122.404668428307) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | ||
| 191756 | 219483 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 54 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992577.4442 | 2096486.68909 | 37.7361266254364 | -122.468136124802 | (37.7361266254364, -122.468136124802) | 1 | 8 | 4 | 59 | 40 | |||
| 191275 | 411 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3850 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 15 | 2 | 5990800.34516 | 2090196.27007 | 37.7187519186484 | -122.473821451697 | (37.7187519186484, -122.473821451697) | 9 | 8 | 4 | 64 | 40 | ||
| 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 | |||
| 191100 | 219542 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 24 | : | Tree | Private 2 | 15 | Width 0ft | 5991404.22112 | 2094464.36175 | 37.7305059975454 | -122.472045037948 | (37.7305059975454, -122.472045037948) | 9 | 8 | 4 | 64 | 40 | |||
| 190262 | 219485 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 60 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992578.71338 | 2096435.07341 | 37.7359849750264 | -122.468127983245 | (37.7359849750264, -122.468127983245) | 1 | 8 | 4 | 59 | 40 | |||
| 188687 | 219482 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 50 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992576.61335 | 2096511.16113 | 37.7361937715337 | -122.468140776996 | (37.7361937715337, -122.468140776996) | 1 | 8 | 4 | 59 | 40 | |||
| 188650 | 219533 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3794 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5 | Width 8ft | 5990481.81422 | 2090701.15077 | 37.7201197416248 | -122.474959308131 | (37.7201197416248, -122.474959308131) | 9 | 8 | 4 | 64 | 40 | |||
| 188418 | 219495 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 92 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992590.1122 | 2096129.31629 | 37.7351461009061 | -122.468066339199 | (37.7351461009061, -122.468066339199) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 186061 | 219530 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3798 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5990495.45016 | 2090638.28304 | 37.7199479126589 | -122.474907587234 | (37.7199479126589, -122.474907587234) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | ||
| 184746 | 219518 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 25 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992611.40848 | 2096694.00568 | 37.7366978262389 | -122.468033772953 | (37.7366978262389, -122.468033772953) | 1 | 8 | 4 | 59 | 40 | |||
| 183747 | 219536 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3778 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5990478.1501 | 2090882.01341 | 37.720616133219 | -122.474985169044 | (37.720616133219, -122.474985169044) | 9 | 8 | 4 | 64 | 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 | |||
| 182205 | 219532 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3794 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5990477.6688 | 2090693.78822 | 37.7200992856469 | -122.474973100146 | (37.7200992856469, -122.474973100146) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 181714 | 219566 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 450 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5993496.23714 | 2099482.27291 | 37.7444047670699 | -122.465177023412 | (37.7444047670699, -122.465177023412) | 1 | 8 | 4 | 29491 | 40 | |||
| 181461 | 404 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3814 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X4 | 5990648.68908 | 2090407.57525 | 37.7193233254004 | -122.474361071922 | (37.7193233254004, -122.474361071922) | 9 | 8 | 4 | 64 | 40 | |||
| 179384 | 219465 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 157 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992651.10608 | 2095584.54329 | 37.733653812663 | -122.467815853722 | (37.733653812663, -122.467815853722) | 9 | 8 | 4 | 59 | 40 | |||
| 179125 | 219559 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 4 Cortes Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 5993189.55754 | 2099585.29183 | 37.7446699411581 | -122.466244934168 | (37.7446699411581, -122.466244934168) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 177693 | 219547 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 500 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 4 | Width 0ft | 5991319.77336 | 2093416.99308 | 37.7276252981672 | -122.4722606639 | (37.7276252981672, -122.4722606639) | 9 | 8 | 4 | 64 | 40 | |||
| 177505 | 219481 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 50 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992575.51838 | 2096555.0686 | 37.7363142671892 | -122.468147755737 | (37.7363142671892, -122.468147755737) | 1 | 8 | 4 | 59 | 40 | |||
| 176932 | 219498 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 89 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992626.79103 | 2096177.78936 | 37.7352813139843 | -122.467943052944 | (37.7352813139843, -122.467943052944) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 175954 | 219531 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3796 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990484.55998 | 2090665.82939 | 37.7200229169975 | -122.474947240127 | (37.7200229169975, -122.474947240127) | 9 | 8 | 4 | 64 | 40 | |||
| 175337 | 219552 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 560 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5992845.00519 | 2099427.10194 | 37.744215706187 | -122.467424817725 | (37.744215706187, -122.467424817725) | 1 | 8 | 4 | 29491 | 40 | |||
| 175325 | 219585 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 241 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993899.35887 | 2099335.10378 | 37.7440239158702 | -122.463772443345 | (37.7440239158702, -122.463772443345) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 174515 | 219486 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 60 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992579.41042 | 2096404.23892 | 37.7359003515064 | -122.468123331026 | (37.7359003515064, -122.468123331026) | 1 | 8 | 4 | 59 | 40 | |||
| 173379 | 219455 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 113 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5992638.64408 | 2095929.54956 | 37.7346003940798 | -122.467884023242 | (37.7346003940798, -122.467884023242) | 9 | 8 | 4 | 59 | 40 | |||
| 173118 | 258 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3100 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 5990642.03803 | 2094556.09253 | 37.7307137319489 | -122.474686681352 | (37.7307137319489, -122.474686681352) | 9 | 8 | 4 | 64 | 40 | |||
| 173012 | 25442 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2177 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6011778.87071 | 2087467.65414 | 37.7124524446924 | -122.401115028828 | (37.7124524446924, -122.401115028828) | 10 | 3 | 8 | 309 | 1 | ||
| 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 | |||
| 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 | |||
| 171215 | 219555 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 540 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 5993011.22836 | 2099444.16931 | 37.7442721638315 | -122.466851299354 | (37.7442721638315, -122.466851299354) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 170411 | 219457 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 125 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992642.51774 | 2095825.25253 | 37.734314244193 | -122.467863047447 | (37.734314244193, -122.467863047447) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 168531 | 219586 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 45 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5994631.61405 | 2099807.81481 | 37.7453640307186 | -122.461274748142 | (37.7453640307186, -122.461274748142) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 168464 | 219484 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 54 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5992577.59564 | 2096461.89628 | 37.7360585593464 | -122.468133798263 | (37.7360585593464, -122.468133798263) | 1 | 8 | 4 | 59 | 40 | |||
| 167566 | 219473 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 2 Santa Ana Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992552.54486 | 2096838.28511 | 37.7370905817533 | -122.468247781032 | (37.7370905817533, -122.468247781032) | 1 | 8 | 4 | 59 | 40 | |||
| 167438 | 219537 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3778 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5990477.3207 | 2090889.9775 | 37.7206379525664 | -122.47498861704 | (37.7206379525664, -122.47498861704) | 9 | 8 | 4 | 64 | 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 | |||
| 166442 | 242354 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 636 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007410.95168 | 2096056.11062 | 37.7357898689032 | -122.416820018323 | (37.7357898689032, -122.416820018323) | 2 | 7 | 7 | 28859 | 2 | |||
| 166296 | 219464 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 151 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992648.37159 | 2095634.82133 | 37.733791705711 | -122.467828963142 | (37.733791705711, -122.467828963142) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 165482 | 215463 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 187 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5995065.4232 | 2100715.05952 | 37.747880054141 | -122.459840423011 | (37.747880054141, -122.459840423011) | 1 | 8 | 4 | 29491 | 40 | |||
| 164929 | 219507 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 55 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 5992619.03813 | 2096448.96489 | 37.7360254463244 | -122.467989575775 | (37.7360254463244, -122.467989575775) | 1 | 8 | 4 | 59 | 40 | |||
| 164594 | 410 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3840 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X6 | 5990764.11669 | 2090252.16515 | 37.7189032943325 | -122.473950753525 | (37.7189032943325, -122.473950753525) | 9 | 8 | 4 | 64 | 40 | |||
| 164288 | 219502 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 75 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992626.60813 | 2096297.05268 | 37.7356087706264 | -122.46795235732 | (37.7356087706264, -122.46795235732) | 1 | 8 | 4 | 59 | 40 | |||
| 163236 | 219528 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3800 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5990523.17081 | 2090581.07783 | 37.7197924477439 | -122.474807594299 | (37.7197924477439, -122.474807594299) | 9 | 8 | 4 | 64 | 40 | |||
| 161859 | 219500 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 85 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 5992628.23833 | 2096214.60894 | 37.735382494908 | -122.467940726397 | (37.735382494908, -122.467940726397) | 1 | 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 | |||
| 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 | |||
| 160814 | 219535 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3780 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5990477.51267 | 2090868.47849 | 37.7205789327461 | -122.474986384926 | (37.7205789327461, -122.474986384926) | 9 | 8 | 4 | 64 | 40 | |||
| 160461 | 219558 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 500 Cortes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 5993196.24887 | 2099494.98963 | 37.7444223802847 | -122.466215235845 | (37.7444223802847, -122.466215235845) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 158316 | 219545 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 34 | : | Tree | Private 2 | 17 | Width 0ft | 5991400.33592 | 2094418.5167 | 37.730379893706 | -122.472055129242 | (37.730379893706, -122.472055129242) | 9 | 8 | 4 | 64 | 40 | |||
| 157716 | 219546 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Junipero Serra Blvd | 14 | : | Tree | Private 2 | 8 | Width 0ft | 5991370.04012 | 2094121.65421 | 37.7295630305013 | -122.472138234715 | (37.7295630305013, -122.472138234715) | 9 | 8 | 4 | 64 | 40 | |||
| 157642 | 219584 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 241 Montalvo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993880.71075 | 2099373.6943 | 37.7441288011066 | -122.463839724345 | (37.7441288011066, -122.463839724345) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 156527 | 219538 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3776 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990469.41158 | 2090916.96408 | 37.7207115926475 | -122.475017925048 | (37.7207115926475, -122.475017925048) | 9 | 8 | 4 | 64 | 40 | |||
| 155587 | 219488 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 66 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992583.52997 | 2096344.18796 | 37.735735704541 | -122.468104721355 | (37.735735704541, -122.468104721355) | 1 | 8 | 4 | 59 | 40 | |||
| 155297 | 242361 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 388 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 3ft | 6006038.37778 | 2097891.21022 | 37.7407513431918 | -122.421695851975 | (37.7407513431918, -122.421695851975) | 2 | 7 | 7 | 28859 | 2 | |||
| 153606 | 219496 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 91 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992630.2874 | 2096120.09632 | 37.7351231052451 | -122.467926769816 | (37.7351231052451, -122.467926769816) | 1 | 8 | 4 | 59 | 40 | |||
| 151808 | 219570 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 400 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5993657.20288 | 2099495.64217 | 37.7444507566102 | -122.464621412364 | (37.7444507566102, -122.464621412364) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 149791 | 219461 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 131 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992643.55955 | 2095748.57888 | 37.7341037776669 | -122.467853870763 | (37.7341037776669, -122.467853870763) | 9 | 8 | 4 | 59 | 40 | |||
| 149356 | 403 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 3810 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5990630.76678 | 2090432.7869 | 37.7193915120005 | -122.474424860828 | (37.7193915120005, -122.474424860828) | 9 | 8 | 4 | 64 | 40 | |||
| 149164 | 219463 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 141 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5992649.22089 | 2095675.20622 | 37.7339026415776 | -122.46782896316 | (37.7339026415776, -122.46782896316) | 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 | |||
| 147606 | 242364 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 27 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001462.52439 | 2108082.98823 | 37.768476414885 | -122.438247338258 | (37.768476414885, -122.438247338258) | 15 | 5 | 5 | 29492 | 3 | |||
| 147160 | 99960 | Undocumented 4 | Ulmus americana :: American Elm 74 | 279 Filbert St | 1 | Unaccepted Street : Yard | Tree | Private 2 | shared responsibility with 1400 Montgomery | 6011546.2 | 2120046.5 | 37.8018937585678 | -122.40421070766 | (37.8018937585678, -122.40421070766) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | |||
| 146569 | 219548 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 598 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5992680.0025 | 2099419.78547 | 37.7441860897219 | -122.467994824228 | (37.7441860897219, -122.467994824228) | 1 | 8 | 4 | 29491 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 |
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) );