trees
217 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 86 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 753 | 197913 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Conkling St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6011758.24884 | 2095732.01029 | 37.7351435225424 | -122.40176684758 | (37.7351435225424, -122.40176684758) | 10 | 3 | 8 | 58 | 1 | |||
| 4119 | 179884 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007440.99847 | 2094010.17739 | 37.7301738725104 | -122.416571250581 | (37.7301738725104, -122.416571250581) | 9 | 3 | 7 | 309 | 28 | |||
| 13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
| 24655 | 215338 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998226.11251 | 2096380.78786 | 37.7361604543418 | -122.448598839867 | (37.7361604543418, -122.448598839867) | 9 | 7 | 4 | 59 | 40 | |||
| 26893 | 241069 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6002146.1874 | 2103426.00537 | 37.7557283324003 | -122.435549412575 | (37.7557283324003, -122.435549412575) | 2 | 4 | 5 | 28862 | 22 | |||
| 27598 | 179854 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 339 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998465.19432 | 2089720.01475 | 37.7178851988142 | -122.447292991002 | (37.7178851988142, -122.447292991002) | 9 | 7 | 6 | 28861 | 25 | ||||
| 29990 | 215341 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6000114.95424 | 2094335.27384 | 37.7306517731413 | -122.441921590428 | (37.7306517731413, -122.441921590428) | 9 | 7 | 4 | 63 | 40 | |||
| 31433 | 136684 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 57 Russell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007021.76535 | 2118934.77129 | 37.7985873825495 | -122.41978847538 | (37.7985873825495, -122.41978847538) | 5 | 1 | 10 | 28858 | 32 | |||
| 36884 | 136634 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999197.43818 | 2121197.11006 | 37.8043552744421 | -122.447025895951 | (37.8043552744421, -122.447025895951) | 13 | 9 | 1 | 57 | 17 | ||||
| 37296 | 179836 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6002646.43295 | 2094204.87454 | 37.7304376544756 | -122.433160577611 | (37.7304376544756, -122.433160577611) | 9 | 7 | 5 | 28861 | 25 | |||
| 39108 | 179880 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007526.36673 | 2092824.84352 | 37.7269240023301 | -122.416192203412 | (37.7269240023301, -122.416192203412) | 9 | 3 | 7 | 309 | 28 | |||
| 44578 | 179805 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1475 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5998972.41815 | 2089460.57977 | 37.7172018201812 | -122.445521103537 | (37.7172018201812, -122.445521103537) | 9 | 7 | 6 | 28861 | 25 | |||
| 46837 | 179803 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998958.13876 | 2089448.31197 | 37.7171673203931 | -122.445569578776 | (37.7171673203931, -122.445569578776) | 9 | 7 | 6 | 28861 | 25 | |||
| 49273 | 136676 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2121 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003331.47965 | 2117519.24553 | 37.7944921352492 | -122.432456859008 | (37.7944921352492, -122.432456859008) | 13 | 9 | 1 | 29490 | 27 | |||
| 55838 | 179815 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 1ft | 5998907.25749 | 2087996.54696 | 37.713178199383 | -122.445641109954 | (37.713178199383, -122.445641109954) | 9 | 7 | 6 | 28861 | 25 | |||
| 56948 | 179838 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002614.6695 | 2093907.99697 | 37.7296206941164 | -122.433249183323 | (37.7296206941164, -122.433249183323) | 9 | 7 | 6 | 28861 | 25 | |||
| 58420 | 136671 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000711.13679 | 2117411.08582 | 37.7940462208083 | -122.441515780329 | (37.7940462208083, -122.441515780329) | 13 | 9 | 1 | 57 | 27 | |||
| 62547 | 136657 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1725 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6002469.52976 | 2120880.32815 | 37.8036718751301 | -122.435679888015 | (37.8036718751301, -122.435679888015) | 13 | 9 | 1 | 57 | 17 | |||
| 65645 | 179865 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 279 Moscow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6004627.95191 | 2091486.48414 | 37.7230857614719 | -122.426116731211 | (37.7230857614719, -122.426116731211) | 9 | 7 | 6 | 28861 | 5 | |||
| 65762 | 136699 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1955 Jones St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6008168.57169 | 2119227.42502 | 37.7994554738439 | -122.415840886849 | (37.7994554738439, -122.415840886849) | 5 | 1 | 10 | 308 | 32 | |||
| 70723 | 179829 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 700 France Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002680.04915 | 2089397.80932 | 37.7172404361776 | -122.432701106797 | (37.7172404361776, -122.432701106797) | 9 | 7 | 6 | 28861 | 5 | |||
| 78577 | 241068 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 419 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6002152.08787 | 2103380.55956 | 37.7556038842372 | -122.43552575593 | (37.7556038842372, -122.43552575593) | 2 | 4 | 5 | 28862 | 22 | |||
| 79283 | 179800 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 228 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998609.28877 | 2088802.95321 | 37.7153753906268 | -122.446728973961 | (37.7153753906268, -122.446728973961) | 9 | 7 | 6 | 28861 | 25 | |||
| 79418 | 179867 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005404.97601 | 2092232.73416 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | 9 | 7 | 6 | 309 | 5 | |||
| 82501 | 136685 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 929 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006311.09024 | 2121067.4414 | 37.8044030913911 | -122.422399252223 | (37.8044030913911, -122.422399252223) | 5 | 1 | 1 | 28858 | 32 | |||
| 84969 | 136678 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6007492.70889 | 2117096.59509 | 37.7935667274799 | -122.418028477839 | (37.7935667274799, -122.418028477839) | 5 | 1 | 10 | 28858 | 32 | |||
| 85219 | 136636 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997648.25188 | 2114482.46822 | 37.7858300451643 | -122.451902244894 | (37.7858300451643, -122.451902244894) | 15 | 6 | 1 | 54 | 31 | |||
| 90245 | 136682 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 874 Green St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008846.30156 | 2119059.10202 | 37.7990313778645 | -122.413483781748 | (37.7990313778645, -122.413483781748) | 3 | 1 | 10 | 308 | 32 | |||
| 91516 | 179860 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6004522.90502 | 2091823.63198 | 37.7240055575044 | -122.426503852472 | (37.7240055575044, -122.426503852472) | 9 | 7 | 6 | 28861 | 5 | |||
| 96676 | 215308 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994977.25671 | 2089298.75113 | 37.7165285859022 | -122.459318680413 | (37.7165285859022, -122.459318680413) | 9 | 8 | 6 | 28861 | 24 | |||
| 98214 | 179796 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1795 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 1ft | 5997861.23879 | 2088411.17322 | 37.714256892113 | -122.449286343701 | (37.714256892113, -122.449286343701) | 9 | 7 | 6 | 28861 | 25 | |||
| 104409 | 179798 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998239.51925 | 2088721.51535 | 37.7151306509273 | -122.448001195404 | (37.7151306509273, -122.448001195404) | 9 | 7 | 6 | 28861 | 25 | |||
| 105016 | 136696 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1063 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 6ft | 6007280.02976 | 2120167.28303 | 37.8019860950362 | -122.418982261931 | (37.8019860950362, -122.418982261931) | 5 | 1 | 1 | 28858 | 32 | |||
| 106736 | 179905 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1216 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 6008780.07198 | 2094033.26413 | 37.7303124823168 | -122.411943512893 | (37.7303124823168, -122.411943512893) | 9 | 3 | 7 | 309 | 28 | |||
| 112263 | 97298 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
| 112775 | 241073 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Eureka St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6001398.38872 | 2105751.17643 | 37.7620701860117 | -122.438302103356 | (37.7620701860117, -122.438302103356) | 15 | 5 | 5 | 28862 | 3 | |||
| 113257 | 215310 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.84882 | 2088877.77404 | 37.7154275189482 | -122.455988739984 | (37.7154275189482, -122.455988739984) | 9 | 8 | 6 | 28861 | 24 | |||
| 114189 | 179855 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 950 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5998508.96783 | 2089424.10578 | 37.7170752019331 | -122.447120402108 | (37.7170752019331, -122.447120402108) | 9 | 7 | 6 | 28861 | 25 | |||
| 115107 | 123109 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992552.3957 | 2111792.37608 | 37.7781505989958 | -122.469336449069 | (37.7781505989958, -122.469336449069) | 11 | 6 | 2 | 54 | 11 | |||
| 124331 | 215343 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999604.29165 | 2093616.12751 | 37.7286480521422 | -122.443635380789 | (37.7286480521422, -122.443635380789) | 9 | 7 | 4 | 63 | 40 | |||
| 126756 | 179845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 85 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000550.17873 | 2092849.30944 | 37.7265964485477 | -122.44031043159 | (37.7265964485477, -122.44031043159) | 9 | 7 | 6 | 28861 | 25 | ||||
| 133462 | 179834 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001971.52486 | 2093519.43437 | 37.7285172835473 | -122.435444813332 | (37.7285172835473, -122.435444813332) | 9 | 7 | 6 | 28861 | 25 | |||
| 133906 | 179882 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005924.81091 | 2093297.57145 | 37.7281318260086 | -122.421762319978 | (37.7281318260086, -122.421762319978) | 9 | 7 | 7 | 309 | 5 | |||
| 141080 | 179879 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 463 Amherst St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007835.00514 | 2091691.6908 | 37.7238299567678 | -122.415045072275 | (37.7238299567678, -122.415045072275) | 9 | 3 | 7 | 309 | 28 | |||
| 141829 | 179801 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 1ft | 5998776.53885 | 2088955.27581 | 37.7158031864544 | -122.446161836306 | (37.7158031864544, -122.446161836306) | 9 | 7 | 6 | 28861 | 25 | |||
| 144237 | 241072 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 121 Buena Vista Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001500.23395 | 2107474.74915 | 37.7668084854387 | -122.43807332932 | (37.7668084854387, -122.43807332932) | 15 | 5 | 5 | 28862 | 3 | |||
| 145353 | 179859 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 71 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004926.25969 | 2092979.13729 | 37.7272011149393 | -122.425191700232 | (37.7272011149393, -122.425191700232) | 9 | 7 | 6 | 28861 | 5 | ||||
| 149317 | 179894 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008613.89309 | 2091233.32436 | 37.7226151183816 | -122.412320193042 | (37.7226151183816, -122.412320193042) | 9 | 3 | 7 | 309 | 28 | |||
| 159941 | 136686 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 915 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6006372.4804 | 2121073.97355 | 37.8044244898475 | -122.42218727034 | (37.8044244898475, -122.42218727034) | 5 | 1 | 1 | 28858 | 32 | |||
| 161620 | 179873 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007108.9711 | 2091815.95561 | 37.7241303348443 | -122.417563661454 | (37.7241303348443, -122.417563661454) | 9 | 7 | 7 | 309 | 28 | |||
| 161950 | 179870 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 743 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6005435.63394 | 2092350.08273 | 37.7255026319158 | -122.423386095411 | (37.7255026319158, -122.423386095411) | 9 | 7 | 7 | 309 | 5 | |||
| 162049 | 179857 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2344 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5999361.46611 | 2089227.95328 | 37.7165852836723 | -122.444159646863 | (37.7165852836723, -122.444159646863) | 9 | 7 | 6 | 28861 | 25 | |||
| 173401 | 179888 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008315.20524 | 2094307.45797 | 37.7310392676412 | -122.413570011448 | (37.7310392676412, -122.413570011448) | 9 | 3 | 7 | 309 | 28 | |||
| 173768 | 136712 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 84 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008291.17542 | 2119130.0368 | 37.7991949618221 | -122.415409734769 | (37.7991949618221, -122.415409734769) | 5 | 1 | 10 | 308 | 32 | ||||
| 175773 | 179848 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5998870.31235 | 2090001.49747 | 37.7186812265492 | -122.445912915673 | (37.7186812265492, -122.445912915673) | 9 | 7 | 6 | 28861 | 25 | |||
| 179893 | 179877 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1516 Bacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007105.23827 | 2091790.85239 | 37.7240611967477 | -122.417574786965 | (37.7240611967477, -122.417574786965) | 9 | 7 | 7 | 309 | 28 | |||
| 181025 | 179862 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6004589.52556 | 2091551.8255 | 37.7232630025659 | -122.426254213277 | (37.7232630025659, -122.426254213277) | 9 | 7 | 6 | 28861 | 5 | |||
| 182035 | 241074 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6001396.61944 | 2105774.83467 | 37.762135045117 | -122.438309917572 | (37.762135045117, -122.438309917572) | 15 | 5 | 5 | 28862 | 3 | |||
| 184131 | 179832 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 89 Belle Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5991610.51667 | 2086489.35195 | 37.7086205125859 | -122.470751174349 | (37.7086205125859, -122.470751174349) | 9 | 8 | 4 | 64 | 24 | |||
| 185017 | 136688 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 777 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007087.93893 | 2121181.13167 | 37.8047590475447 | -122.419718966771 | (37.8047590475447, -122.419718966771) | 5 | 1 | 1 | 28858 | 32 | |||
| 189701 | 136643 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2781 Filbert St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999657.45024 | 2118405.07114 | 37.7967153546854 | -122.445233129815 | (37.7967153546854, -122.445233129815) | 13 | 9 | 1 | 57 | 17 | |||
| 44005 | 179893 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008518.11565 | 2093559.33094 | 37.7289964630154 | -122.412815641254 | (37.7289964630154, -122.412815641254) | 9 | 3 | 7 | 309 | 28 | |||
| 49054 | 179903 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6008647.44016 | 2091243.13146 | 37.7226439290591 | -122.412204920617 | (37.7226439290591, -122.412204920617) | 9 | 3 | 7 | 309 | 28 | |||
| 62558 | 136653 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6002117.3275 | 2121589.45847 | 37.8055989477865 | -122.436949497817 | (37.8055989477865, -122.436949497817) | 13 | 9 | 1 | 57 | 17 | |||
| 157281 | 197905 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 654 Minnesota St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6015150.56239 | 2105371.17571 | 37.7617993767681 | -122.390711684909 | (37.7617993767681, -122.390711684909) | 10 | 3 | 8 | 28856 | 29 | |||
| 157954 | 179904 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008652.42423 | 2091244.38754 | 37.7226476576547 | -122.412187780452 | (37.7226476576547, -122.412187780452) | 9 | 3 | 7 | 309 | 28 | |||
| 51654 | 136654 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002110.79049 | 2121588.87191 | 37.8055969657012 | -122.436972078008 | (37.8055969657012, -122.436972078008) | 13 | 9 | 1 | 57 | 17 | |||
| 167364 | 136640 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002002.26446 | 2118153.31636 | 37.7961576653005 | -122.43710151924 | (37.7961576653005, -122.43710151924) | 13 | 9 | 1 | 57 | 17 | |||
| 22753 | 136655 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002095.53828 | 2121587.56307 | 37.80559250506 | -122.437024766584 | (37.80559250506, -122.437024766584) | 13 | 9 | 1 | 57 | 17 | |||
| 55052 | 136641 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002004.16197 | 2118138.13487 | 37.796116088744 | -122.437093866005 | (37.796116088744, -122.437093866005) | 13 | 9 | 1 | 57 | 17 | |||
| 17039 | 136666 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000890.78199 | 2117450.16174 | 37.7941637460202 | -122.440896995501 | (37.7941637460202, -122.440896995501) | 13 | 9 | 1 | 57 | 27 | |||
| 27027 | 179833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002155.36157 | 2093545.08036 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | 9 | 7 | 6 | 28861 | 25 | |||
| 37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
| 37301 | 241067 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 229 Grand View Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000638.50789 | 2103037.93604 | 37.7545770419209 | -122.440735600467 | (37.7545770419209, -122.440735600467) | 2 | 4 | 5 | 28862 | 22 | |||
| 39011 | 179881 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007539.25103 | 2092829.10153 | 37.7269364183715 | -122.416147963965 | (37.7269364183715, -122.416147963965) | 9 | 3 | 7 | 309 | 28 | |||
| 44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 44958 | 136637 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997659.79036 | 2114483.77284 | 37.7858342881777 | -122.451862419331 | (37.7858342881777, -122.451862419331) | 15 | 6 | 1 | 54 | 31 | |||
| 46609 | 215311 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.93989 | 2088894.46571 | 37.7154733555918 | -122.455989631214 | (37.7154733555918, -122.455989631214) | 9 | 8 | 6 | 28861 | 24 | |||
| 49209 | 179799 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998244.59243 | 2088714.20474 | 37.7151108676608 | -122.447983134341 | (37.7151108676608, -122.447983134341) | 9 | 7 | 6 | 28861 | 25 | |||
| 49688 | 136713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 290 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011569.99478 | 2119432.50864 | 37.8002092172264 | -122.404085130728 | (37.8002092172264, -122.404085130728) | 3 | 1 | 10 | 308 | 23 | |||
| 54533 | 215301 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001252.93679 | 2094603.03258 | 37.7314517578791 | -122.438006591549 | (37.7314517578791, -122.438006591549) | 9 | 7 | 4 | 63 | 40 | |||
| 70544 | 179889 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008314.8677 | 2094310.92324 | 37.7310487635727 | -122.41357142338 | (37.7310487635727, -122.41357142338) | 9 | 3 | 7 | 309 | 28 | |||
| 77632 | 136687 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 915 Bay St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006389.37934 | 2121076.02461 | 37.8044310746876 | -122.422128935803 | (37.8044310746876, -122.422128935803) | 5 | 1 | 1 | 28858 | 32 | |||
| 80235 | 179835 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001963.44434 | 2093526.42722 | 37.7285360253961 | -122.435473248114 | (37.7285360253961, -122.435473248114) | 9 | 7 | 6 | 28861 | 25 | |||
| 81813 | 241070 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6002148.82258 | 2103426.21289 | 37.7557290518693 | -122.43554031414 | (37.7557290518693, -122.43554031414) | 2 | 4 | 5 | 28862 | 22 | |||
| 87437 | 179846 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 29 Colonial Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000367.54069 | 2093586.66565 | 37.7286106583386 | -122.440994678056 | (37.7286106583386, -122.440994678056) | 9 | 7 | 6 | 28861 | 25 | |||
| 94276 | 179895 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008618.46635 | 2091234.88491 | 37.7226196599519 | -122.412304494484 | (37.7226196599519, -122.412304494484) | 9 | 3 | 7 | 309 | 28 | |||
| 102546 | 179863 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6004588.75772 | 2091549.34292 | 37.7232561425447 | -122.426256690891 | (37.7232561425447, -122.426256690891) | 9 | 7 | 6 | 28861 | 5 | |||
| 105096 | 179885 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007447.44417 | 2094010.42268 | 37.7301749085276 | -122.416548984266 | (37.7301749085276, -122.416548984266) | 9 | 3 | 7 | 309 | 28 | |||
| 105099 | 179861 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004531.11595 | 2091836.46353 | 37.7240412542901 | -122.426476381783 | (37.7240412542901, -122.426476381783) | 9 | 7 | 6 | 28861 | 5 | |||
| 107371 | 179874 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007111.06937 | 2091808.8773 | 37.7241110173924 | -122.4175559066 | (37.7241110173924, -122.4175559066) | 9 | 7 | 7 | 309 | 28 | |||
| 121368 | 179807 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1441 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5999120.21959 | 2089604.47334 | 37.7176053558696 | -122.445020564272 | (37.7176053558696, -122.445020564272) | 9 | 7 | 6 | 28861 | 25 | |||
| 122170 | 179839 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002619.90718 | 2093903.00137 | 37.7296072744596 | -122.433230719323 | (37.7296072744596, -122.433230719323) | 9 | 7 | 6 | 28861 | 25 | |||
| 124320 | 136672 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000710.42284 | 2117422.03568 | 37.7940762455768 | -122.441519036792 | (37.7940762455768, -122.441519036792) | 13 | 9 | 1 | 57 | 27 | |||
| 125001 | 179872 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 66 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005421.70819 | 2093230.42134 | 37.7279190626089 | -122.423496793843 | (37.7279190626089, -122.423496793843) | 9 | 7 | 6 | 28861 | 5 | |||
| 126092 | 215309 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994986.28741 | 2089298.56204 | 37.7165285859158 | -122.459287452364 | (37.7165285859158, -122.459287452364) | 9 | 8 | 6 | 28861 | 24 | |||
| 127245 | 123108 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992553.53653 | 2111802.27469 | 37.7781778438173 | -122.469333223241 | (37.7781778438173, -122.469333223241) | 11 | 6 | 2 | 54 | 11 | |||
| 133349 | 136697 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007352.71781 | 2120177.3681 | 37.80201787889 | -122.418731441927 | (37.80201787889, -122.418731441927) | 5 | 1 | 1 | 28858 | 32 | |||
| 135830 | 179804 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998957.13313 | 2089446.35886 | 37.717161900187 | -122.44557291438 | (37.717161900187, -122.44557291438) | 9 | 7 | 6 | 28861 | 25 | |||
| 140172 | 136708 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007910.30742 | 2120604.37308 | 37.803221705081 | -122.416832181661 | (37.803221705081, -122.416832181661) | 5 | 1 | 1 | 308 | 32 |
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) );