trees
379 rows where qSpecies_id = 86 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 102034 | 136652 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002131.53394 | 2121592.77416 | 37.8056088592346 | -122.43690057202 | (37.8056088592346, -122.43690057202) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 144491 | 136651 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002148.06177 | 2121594.41755 | 37.8056143109046 | -122.436843492933 | (37.8056143109046, -122.436843492933) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 156393 | 136650 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002164.97809 | 2121597.31622 | 37.8056232312917 | -122.436785159329 | (37.8056232312917, -122.436785159329) | 13 | 9 | 1 | 57 | 17 | |||
| 38090 | 949 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/1990 12:00:00 AM | 6 | 3X6 | 6002168.03285 | 2093561.19975 | 37.7286431202677 | -122.434768461095 | (37.7286431202677, -122.434768461095) | 9 | 7 | 6 | 28861 | 25 | ||
| 12939 | 136649 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002175.88564 | 2121598.89549 | 37.8056281874435 | -122.436747525379 | (37.8056281874435, -122.436747525379) | 13 | 9 | 1 | 57 | 17 | |||
| 166932 | 136648 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002184.59684 | 2121599.43708 | 37.8056301695703 | -122.436717417869 | (37.8056301695703, -122.436717417869) | 13 | 9 | 1 | 57 | 17 | |||
| 144301 | 136647 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6002197.32767 | 2121601.52004 | 37.8056366123151 | -122.436673510277 | (37.8056366123151, -122.436673510277) | 13 | 9 | 1 | 57 | 17 | |||
| 50876 | 39476 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 14 | Permit Number 40937 | 6002367.56738 | 2121559.91338 | 37.8055320445375 | -122.436081393069 | (37.8055320445375, -122.436081393069) | 13 | 9 | 1 | 57 | 17 | ||
| 105124 | 136656 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 4 | : | Tree | Private 2 | 18 | Width 3ft | 6002391.37561 | 2121563.03053 | 37.8055419559627 | -122.435999224706 | (37.8055419559627, -122.435999224706) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 31608 | 136644 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.13752 | 2121660.90327 | 37.8058166394946 | -122.435643688532 | (37.8058166394946, -122.435643688532) | 13 | 9 | 1 | 57 | 17 | |||
| 146617 | 136645 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.65751 | 2121656.65619 | 37.8058050076721 | -122.435641584993 | (37.8058050076721, -122.435641584993) | 13 | 9 | 1 | 57 | 17 | |||
| 145031 | 136646 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.98739 | 2121653.01832 | 37.8057950377808 | -122.435640182969 | (37.8057950377808, -122.435640182969) | 13 | 9 | 1 | 57 | 17 | |||
| 108553 | 179909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002595.51683 | 2086620.13725 | 37.7096087631907 | -122.432794977119 | (37.7096087631907, -122.432794977119) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 59411 | 179908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002616.49516 | 2086635.08435 | 37.7096509944651 | -122.432723539456 | (37.7096509944651, -122.432723539456) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 141539 | 179840 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6002632.59127 | 2093895.12097 | 37.7295863562117 | -122.433186306304 | (37.7295863562117, -122.433186306304) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 35581 | 179842 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002649.41519 | 2093884.99893 | 37.7295595177473 | -122.433127421409 | (37.7295595177473, -122.433127421409) | 9 | 7 | 6 | 28861 | 25 | |||
| 148964 | 241064 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002651.6707 | 2100291.95945 | 37.7471516815152 | -122.433577323454 | (37.7471516815152, -122.433577323454) | 2 | 7 | 5 | 63 | 22 | ||||
| 169145 | 179841 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002653.07168 | 2093883.32374 | 37.7295551254715 | -122.433114660921 | (37.7295551254715, -122.433114660921) | 9 | 7 | 6 | 28861 | 25 | |||
| 48837 | 241065 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002656.66446 | 2100292.18739 | 37.7471525907236 | -122.433560071737 | (37.7471525907236, -122.433560071737) | 2 | 7 | 5 | 63 | 22 | ||||
| 156304 | 241066 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002659.6635 | 2100292.45655 | 37.7471534999337 | -122.43354972054 | (37.7471534999337, -122.43354972054) | 2 | 7 | 5 | 63 | 22 | ||||
| 181295 | 105517 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002660.53162 | 2089394.02729 | 37.7172289446341 | -122.432768299618 | (37.7172289446341, -122.432768299618) | 9 | 7 | 6 | 28861 | 5 | |||
| 63804 | 179827 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002666.48138 | 2089402.27505 | 37.7172519286027 | -122.432748322975 | (37.7172519286027, -122.432748322975) | 9 | 7 | 6 | 28861 | 5 | |||
| 40383 | 105515 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002668.24171 | 2089385.75875 | 37.7172066783264 | -122.432741059164 | (37.7172066783264, -122.432741059164) | 9 | 7 | 6 | 28861 | 5 | |||
| 181460 | 179828 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002676.62468 | 2089397.35699 | 37.7172389999654 | -122.432712911272 | (37.7172389999654, -122.432712911272) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 111535 | 136714 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.8039755150326 | -122.433293789677 | (37.8039755150326, -122.433293789677) | 13 | 9 | 1 | 57 | 17 | |||
| 134209 | 136658 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 6 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003175.48548 | 2120978.26665 | 37.8039808614944 | -122.433243896185 | (37.8039808614944, -122.433243896185) | 13 | 9 | 1 | 57 | 17 | |||
| 85899 | 136715 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 9 | Side Yard : Yard | Tree | Private 2 | 9 | Width 7ft | 6003190.85748 | 2120979.91426 | 37.803986257417 | -122.433190818205 | (37.803986257417, -122.433190818205) | 13 | 9 | 1 | 57 | 17 | |||
| 54469 | 136659 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 11 | Side Yard : Yard | Tree | Private 2 | 13 | Width 7ft | 6003202.74777 | 2120982.34817 | 37.8039936147875 | -122.433149845112 | (37.8039936147875, -122.433149845112) | 13 | 9 | 1 | 57 | 17 | |||
| 40704 | 136716 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 14 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003215.33658 | 2120983.87446 | 37.8039985196804 | -122.43310638985 | (37.8039985196804, -122.43310638985) | 13 | 9 | 1 | 57 | 17 | |||
| 93918 | 136660 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 17 | Side Yard : Yard | Tree | Private 2 | 14 | Width 7ft | 6003228.45993 | 2120985.21121 | 37.8040029344509 | -122.433061071222 | (37.8040029344509, -122.433061071222) | 13 | 9 | 1 | 57 | 17 | |||
| 173813 | 179843 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6003264.53226 | 2094054.72637 | 37.7300604248468 | -122.431013009142 | (37.7300604248468, -122.431013009142) | 9 | 7 | 6 | 28861 | 25 | |||
| 146018 | 136674 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2127 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003286.01413 | 2117511.22224 | 37.7944675271099 | -122.432613601844 | (37.7944675271099, -122.432613601844) | 13 | 9 | 1 | 29490 | 27 | |||
| 46559 | 179844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6003286.16791 | 2094080.48748 | 37.7301323849801 | -122.430940049855 | (37.7301323849801, -122.430940049855) | 9 | 7 | 6 | 28861 | 25 | |||
| 181270 | 136675 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2127 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003298.06459 | 2117513.66207 | 37.7944749096307 | -122.432572080161 | (37.7944749096307, -122.432572080161) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 150798 | 136677 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2121 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003353.41971 | 2117521.18244 | 37.7944986976029 | -122.432381082137 | (37.7944986976029, -122.432381082137) | 13 | 9 | 1 | 29490 | 27 | |||
| 189782 | 241071 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6004095.14268 | 2103015.18666 | 37.7547108223494 | -122.428780017682 | (37.7547108223494, -122.428780017682) | 2 | 4 | 5 | 28862 | 22 | |||
| 128853 | 136661 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1307 Bay St | 3 | : | Tree | Private 2 | 4 | Width 1ft | 6004511.51487 | 2120814.19666 | 37.8036060681264 | -122.428608775088 | (37.8036060681264, -122.428608775088) | 13 | 9 | 1 | 28858 | 17 | |||
| 29197 | 136662 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1307 Bay St | 4 | : | Tree | Private 2 | 1 | Width 1ft | 6004522.84241 | 2120815.90939 | 37.8036114118857 | -122.428569697738 | (37.8036114118857, -122.428569697738) | 13 | 9 | 1 | 28858 | 17 | |||
| 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 | |||
| 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 | |||
| 159259 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 3649-3651 17TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | 8 | 4 | 5 | 28862 | 3 | |||
| 148102 | 179864 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6004587.63153 | 2091546.86804 | 37.7232492834105 | -122.4262604078 | (37.7232492834105, -122.4262604078) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 157077 | 179866 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 279 Moscow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6004629.91456 | 2091490.19984 | 37.7230960748979 | -122.426110211111 | (37.7230960748979, -122.426110211111) | 9 | 7 | 6 | 28861 | 5 | |||
| 123804 | 179868 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 345 Congdon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6004732.69466 | 2093569.91681 | 37.7288123277178 | -122.425902888604 | (37.7288123277178, -122.425902888604) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||
| 53129 | 136663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.8032971105329 | -122.426737318298 | (37.8032971105329, -122.426737318298) | 13 | 9 | 1 | 28858 | 17 | |||
| 93014 | 136664 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6005052.80958 | 2120674.99367 | 37.8032544709705 | -122.42672567836 | (37.8032544709705, -122.42672567836) | 13 | 9 | 1 | 28858 | 17 | |||
| 70182 | 179871 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Athens St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6005395.25697 | 2093256.97645 | 37.7279904840704 | -122.423590123686 | (37.7279904840704, -122.423590123686) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 179861 | 179869 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6005754.24665 | 2092349.7952 | 37.725519819773 | -122.422284657027 | (37.725519819773, -122.422284657027) | 9 | 7 | 7 | 309 | 5 | |||
| 4496 | 74361 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6005755.65434 | 2092345.08491 | 37.7255069657486 | -122.422279456248 | (37.7255069657486, -122.422279456248) | 9 | 7 | 7 | 309 | 5 | |||
| 188876 | 241058 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6005911.64547 | 2095827.03332 | 37.7350764277212 | -122.421987446374 | (37.7350764277212, -122.421987446374) | 2 | 7 | 7 | 28859 | 2 | |||
| 65143 | 241059 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6005916.72603 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 63554 | 241060 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.7350755589952 | -122.421928139697 | (37.7350755589952, -122.421928139697) | 2 | 7 | 7 | 28859 | 2 | |||
| 68300 | 241061 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 6005940.184 | 2095824.54912 | 37.7350712161596 | -122.421888601897 | (37.7350712161596, -122.421888601897) | 2 | 7 | 7 | 28859 | 2 | |||
| 128394 | 241062 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005944.68012 | 2095825.54843 | 37.7350742136048 | -122.421873128139 | (37.7350742136048, -122.421873128139) | 2 | 7 | 7 | 28859 | 2 | |||
| 126944 | 241063 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005947.85615 | 2095824.2566 | 37.73507084564 | -122.421862055716 | (37.73507084564, -122.421862055716) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
| 98485 | 104833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6006442.50157 | 2121083.02679 | 37.8044532969577 | -122.421945599118 | (37.8044532969577, -122.421945599118) | 5 | 1 | 1 | 28858 | 32 | ||||
| 67917 | 87249 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||||
| 132265 | 87248 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50274 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||
| 146664 | 87250 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50274 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||
| 132805 | 136694 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1201 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007018.29249 | 2119785.88696 | 37.8009241359937 | -122.41986091934 | (37.8009241359937, -122.41986091934) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 189980 | 179878 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1516 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007090.65933 | 2091786.11509 | 37.7240473687785 | -122.417624848631 | (37.7240473687785, -122.417624848631) | 9 | 7 | 7 | 309 | 28 | |||
| 6411 | 136695 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1200 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6007098.70591 | 2119850.28744 | 37.8011054932745 | -122.419587225988 | (37.8011054932745, -122.419587225988) | 5 | 1 | 1 | 28858 | 32 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 175053 | 179875 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007112.5297 | 2091803.34556 | 37.7240959105931 | -122.417550466576 | (37.7240959105931, -122.417550466576) | 9 | 7 | 7 | 309 | 28 | |||
| 123638 | 179876 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007115.03067 | 2091796.72343 | 37.7240778683719 | -122.41754135197 | (37.7240778683719, -122.41754135197) | 9 | 7 | 7 | 309 | 28 | |||
| 43003 | 136693 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2164 Hyde St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007181.34298 | 2119779.01061 | 37.8009144395066 | -122.41929620626 | (37.8009144395066, -122.41929620626) | 5 | 1 | 1 | 28858 | 32 | |||
| 134836 | 99719 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2164 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007186.17673 | 2119740.01598 | 37.8008076423232 | -122.419276711652 | (37.8008076423232, -122.419276711652) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 144877 | 179883 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 39 Amherst St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007323.05766 | 2093363.44581 | 37.7283914539998 | -122.416933184515 | (37.7283914539998, -122.416933184515) | 9 | 3 | 7 | 309 | 5 | |||
| 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 | |||
| 169155 | 136706 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1155 Greenwich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007368.03811 | 2119831.84665 | 37.8010700267201 | -122.418653909561 | (37.8010700267201, -122.418653909561) | 5 | 1 | 1 | 28858 | 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) );