trees
2,365 rows where qSpecies_id = 31 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 147 | 198543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | : | Tree | Private 2 | 3 | Width 0ft | 6014375.16951 | 2096346.21278 | 37.7369756879815 | -122.392762090617 | (37.7369756879815, -122.392762090617) | 10 | 3 | 8 | 58 | 1 | |||
| 4812 | 198517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 2 | : | Tree | Private 2 | 5 | Width 7ft | 6014346.73951 | 2096322.78373 | 37.7369097775472 | -122.392858747949 | (37.7369097775472, -122.392858747949) | 10 | 3 | 8 | 58 | 1 | |||
| 20447 | 198509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 361 Texas St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6013800.26675 | 2105409.79767 | 37.7618304159729 | -122.395384559572 | (37.7618304159729, -122.395384559572) | 10 | 3 | 8 | 28856 | 29 | |||
| 23560 | 198505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 743 Rhode Island St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6011863.14571 | 2104907.21276 | 37.7603425002176 | -122.402048998175 | (37.7603425002176, -122.402048998175) | 10 | 3 | 8 | 28856 | 29 | |||
| 37462 | 198510 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 678 Arkansas St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012982.1442 | 2103924.05495 | 37.7577053561473 | -122.39810990287 | (37.7577053561473, -122.39810990287) | 10 | 3 | 8 | 28856 | 29 | |||
| 41660 | 198529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 Newcomb Ave | 2 | : | Tree | Private 2 | 7 | Width 7ft | 6014569.28946 | 2096208.90311 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | 10 | 3 | 8 | 58 | 1 | |||
| 54882 | 247019 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 530 Valley St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6002475.46095 | 2099175.15499 | 37.7440751988042 | -122.434106819098 | (37.7440751988042, -122.434106819098) | 2 | 7 | 5 | 63 | 22 | |||
| 61528 | 136986 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 Hayes St | 3 | : | Tree | Private 2 | 19 | Width 4ft | 6004705.5479 | 2110850.60835 | 37.7762595426756 | -122.427227166401 | (37.7762595426756, -122.427227166401) | 7 | 9 | 11 | 28852 | 10 | |||
| 62432 | 201912 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | 10 | 3 | 8 | 58 | 1 | |||
| 68160 | 201911 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.7283501238417 | -122.394511693764 | (37.7283501238417, -122.394511693764) | 10 | 3 | 8 | 58 | 1 | |||
| 75492 | 198515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1799 Newcomb Ave | 1 | : | Tree | Private 2 | 6 | Width 7ft | 6014195.4851 | 2096428.16661 | 37.7371907347515 | -122.39338907817 | (37.7371907347515, -122.39338907817) | 10 | 3 | 8 | 58 | 1 | |||
| 78591 | 198554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | : | Tree | Private 2 | 2 | Width 0ft | 6014551.87687 | 2096170.80222 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | 10 | 3 | 8 | 58 | 1 | |||
| 85837 | 242780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 95 McCoppin St | 1 | : | Tree | Private 2 | 3 | Width 9ft | 6006179.77173 | 2109125.10938 | 37.7716049979898 | -122.422004807797 | (37.7716049979898, -122.422004807797) | 8 | 2 | 9 | 28853 | 19 | |||
| 89896 | 198555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 4 | : | Tree | Private 2 | 6 | Width 0ft | 6014573.39316 | 2096202.10779 | 37.7365910128673 | -122.39206666287 | (37.7365910128673, -122.39206666287) | 10 | 3 | 8 | 58 | 1 | |||
| 96569 | 242372 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 65 McCoppin St | 2 | : | Tree | Private 2 | 2 | Width 5ft | 6006293.4937 | 2109105.47321 | 37.7715574949158 | -122.421610041382 | (37.7715574949158, -122.421610041382) | 8 | 2 | 9 | 28853 | 19 | |||
| 97198 | 201906 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6013735.56827 | 2093268.69044 | 37.7284898973927 | -122.394758034254 | (37.7284898973927, -122.394758034254) | 10 | 3 | 8 | 58 | 1 | |||
| 101072 | 201910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.7283734198726 | -122.394550072331 | (37.7283734198726, -122.394550072331) | 10 | 3 | 8 | 58 | 1 | |||
| 101626 | 201907 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | 10 | 3 | 8 | 58 | 1 | |||
| 104649 | 198511 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 678 Arkansas St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012984.38366 | 2103919.05598 | 37.7576917548011 | -122.398101807147 | (37.7576917548011, -122.398101807147) | 10 | 3 | 8 | 28856 | 29 | |||
| 108431 | 198532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 1 | : | Tree | Private 2 | 4 | Width 7ft | 6014372.17182 | 2096354.40755 | 37.7369980226381 | -122.392773028173 | (37.7369980226381, -122.392773028173) | 10 | 3 | 8 | 58 | 1 | |||
| 109770 | 201908 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.394643789789 | (37.7284270698286, -122.394643789789) | 10 | 3 | 8 | 58 | 1 | |||
| 115085 | 246813 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 174 Brewster St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6010206.83584 | 2098924.97539 | 37.7438240172737 | -122.407355690707 | (37.7438240172737, -122.407355690707) | 2 | 7 | 7 | 28859 | 2 | |||
| 116529 | 198508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 998 Rhode Island St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6011865.97365 | 2103785.48158 | 37.7572626324706 | -122.401960360989 | (37.7572626324706, -122.401960360989) | 10 | 3 | 8 | 28856 | 29 | |||
| 117776 | 246976 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 221 Noe St | 1 | : | Tree | Private 2 | 4 | Width 6ft | 6002925.65155 | 2106953.93044 | 37.7654594052395 | -122.433105834068 | (37.7654594052395, -122.433105834068) | 15 | 5 | 5 | 28862 | 3 | |||
| 117989 | 198538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1782 Newcomb Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014279.64227 | 2096432.42158 | 37.737207093417 | -122.393098403779 | (37.737207093417, -122.393098403779) | 10 | 3 | 8 | 58 | 1 | |||
| 132547 | 242604 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 5999041.21728 | 2105197.03695 | 37.7604143056979 | -122.446414751759 | (37.7604143056979, -122.446414751759) | 15 | 5 | 5 | 28862 | 12 | |||
| 134543 | 242778 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 McCoppin St | 1 | : | Tree | Private 2 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | 8 | 2 | 9 | 28853 | 19 | |||
| 138821 | 198506 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 743 Rhode Island St | 2 | : | Tree | Private 2 | 14 | Width 2ft | 6011861.67877 | 2104921.79011 | 37.7603824445082 | -122.40205509649 | (37.7603824445082, -122.40205509649) | 10 | 3 | 8 | 28856 | 29 | |||
| 148692 | 242602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5999038.72124 | 2105222.15033 | 37.7604831182267 | -122.446425191088 | (37.7604831182267, -122.446425191088) | 15 | 5 | 5 | 28862 | 12 | |||
| 152997 | 215517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 164 Howth St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997515.64352 | 2090995.97654 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | 9 | 8 | 6 | 28861 | 24 | |||
| 156126 | 242601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5999037.14179 | 2105234.87473 | 37.7605179660504 | -122.446431569085 | (37.7605179660504, -122.446431569085) | 15 | 5 | 5 | 28862 | 12 | |||
| 156325 | 201909 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.394593807271 | (37.728396715017, -122.394593807271) | 10 | 3 | 8 | 58 | 1 | |||
| 160465 | 198522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1725 Newcomb Ave | 2 | : | Tree | Private 2 | 3 | Width 7ft | 6014552.77288 | 2096169.89847 | 37.7365014278009 | -122.392135704718 | (37.7365014278009, -122.392135704718) | 10 | 3 | 8 | 58 | 1 | |||
| 163774 | 198514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1601 Bay Shore Blvd | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6012038.03347 | 2091375.16372 | 37.7231961325824 | -122.400493582929 | (37.7231961325824, -122.400493582929) | 10 | 3 | 8 | 58 | 1 | |||
| 168414 | 198544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 2 | : | Tree | Private 2 | 4 | Width 0ft | 6014356.36657 | 2096313.21091 | 37.7368840272751 | -122.392824793156 | (37.7368840272751, -122.392824793156) | 10 | 3 | 8 | 58 | 1 | |||
| 173101 | 201913 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 8 | : | Tree | Private 2 | 5 | Width 3ft | 6013833.24742 | 2093196.526 | 37.7282971789522 | -122.394415299033 | (37.7282971789522, -122.394415299033) | 10 | 3 | 8 | 58 | 1 | |||
| 175777 | 242603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5999039.00902 | 2105211.58372 | 37.7604541213822 | -122.446423435607 | (37.7604541213822, -122.446423435607) | 15 | 5 | 5 | 28862 | 12 | |||
| 182893 | 198513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2216 23rd St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6011806.19785 | 2102818.97218 | 37.754605473978 | -122.402099143454 | (37.754605473978, -122.402099143454) | 10 | 3 | 8 | 28856 | 29 | |||
| 188966 | 198537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1799 Newcomb Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014201.9546 | 2096422.50115 | 37.737175538008 | -122.393366313629 | (37.737175538008, -122.393366313629) | 10 | 3 | 8 | 58 | 1 | |||
| 189741 | 242375 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 130 Church St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004079.07598 | 2108183.78189 | 37.7689016404155 | -122.429204103801 | (37.7689016404155, -122.429204103801) | 7 | 9 | 5 | 28862 | 3 | |||
| 190727 | 180562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4101 Alemany Blvd | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5991620.89043 | 2086817.03581 | 37.7095208535614 | -122.470739173794 | (37.7095208535614, -122.470739173794) | 9 | 8 | 4 | 64 | 24 | |||
| 192705 | 215518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997249.4841 | 2090499.44451 | 37.7199557889053 | -122.451551333026 | (37.7199557889053, -122.451551333026) | 9 | 8 | 6 | 28861 | 24 | |||
| 192817 | 242605 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315 Clayton St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5999041.02625 | 2105175.78998 | 37.7603559558947 | -122.446413883893 | (37.7603559558947, -122.446413883893) | 15 | 5 | 5 | 28862 | 12 | |||
| 39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
| 179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
| 59089 | 116955 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 818 Douglass St | 1 | Front Yard : Cutout | Tree | Private 2 | 6 | 3x3 | 6001245 | 2101454 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | 2 | 4 | 5 | 28862 | 22 | |||
| 14326 | 112045 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785474 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | 13 | 9 | 1 | 29490 | 27 | |
| 84706 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2620 Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003626 | 2117322 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | 13 | 9 | 1 | 29490 | 27 | ||||
| 87092 | 242400 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 5 | 6004412.57648 | 2096019.13863 | 37.7355192458083 | -122.427183945908 | (37.7355192458083, -122.427183945908) | 2 | 7 | 5 | 28861 | 2 | ||||
| 99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
| 102300 | 113801 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 806 SHOTWELL ST | 3 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 106141 | 137053 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Green St | 28 | Front Yard : Yard | Tree | Private 2 | 8 | 6008580.77711 | 2119003.85777 | 37.7988647784329 | -122.414398677364 | (37.7988647784329, -122.414398677364) | 5 | 1 | 10 | 308 | 32 | ||||
| 184015 | 242401 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 3 | 6004422.12829 | 2096026.22682 | 37.7355392485419 | -122.427151426394 | (37.7355392485419, -122.427151426394) | 2 | 7 | 5 | 28861 | 2 | ||||
| 154 | 119838 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 206 | 119799 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 225 | 119839 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 238 | 119796 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 344 | 119791 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 395 | 246548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.7724235852138 | -122.423543772638 | (37.7724235852138, -122.423543772638) | 7 | 9 | 11 | 28852 | 10 | |||
| 406 | 119837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 428 | 119830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 442 | 119718 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 481 | 119782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 1908 | 119794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 7 | 9 | 11 | 28852 | 10 | |||
| 3373 | 119797 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 3417 | 119788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 4570 | 119828 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 5011 | 119790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 6138 | 244422 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.7731308974862 | -122.423735193743 | (37.7731308974862, -122.423735193743) | 7 | 9 | 11 | 28852 | 10 | |||
| 6452 | 109163 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 12 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 6820 | 244317 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005516.527 | 2110492.6418 | 37.7753224827652 | -122.424396296997 | (37.7753224827652, -122.424396296997) | 7 | 9 | 11 | 28852 | 10 | |||
| 8844 | 119789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 9242 | 119783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 10127 | 119793 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 10263 | 119836 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 10966 | 109166 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11525 | 119754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 11729 | 244288 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.424108218812 | (37.7739922036556, -122.424108218812) | 7 | 9 | 11 | 28852 | 10 | |||
| 12246 | 119784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 13324 | 119752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 14547 | 119749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 15578 | 119832 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 15738 | 119781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 16699 | 97434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380x Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
| 19858 | 109170 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 20556 | 18546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | 10 | 3 | 8 | 58 | 1 | |||
| 23251 | 119710 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 24722 | 244306 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303 | (37.7753816404734, -122.42418868303) | 7 | 9 | 11 | 28852 | 10 | |||
| 26225 | 244356 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.7751450388721 | -122.424143338216 | (37.7751450388721, -122.424143338216) | 7 | 9 | 11 | 28852 | 10 | |||
| 26388 | 244359 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.424374111287 | (37.7752229798737, -122.424374111287) | 7 | 9 | 11 | 28852 | 10 | |||
| 27032 | 119717 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 29420 | 244397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | 7 | 9 | 11 | 28852 | 10 | |||
| 29511 | 244254 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005646.3317 | 2110018.1063 | 37.7740268522621 | -122.423913520847 | (37.7740268522621, -122.423913520847) | 7 | 9 | 11 | 28852 | 10 | |||
| 29976 | 244375 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005617.5038 | 2109823.1115 | 37.7734898161448 | -122.423999372272 | (37.7734898161448, -122.423999372272) | 7 | 9 | 11 | 28852 | 10 | |||
| 31182 | 244424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.423754560713 | (37.7732378565997, -122.423754560713) | 7 | 9 | 11 | 28852 | 10 | |||
| 31486 | 244396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005626.4733 | 2110143.3671 | 37.7743696669954 | -122.423991123858 | (37.7743696669954, -122.423991123858) | 7 | 9 | 11 | 28852 | 10 | |||
| 31673 | 119709 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) |
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) );