trees
217 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 86 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192961 | 136689 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007697.4603 | 2118837.4061 | 37.7983580833179 | -122.41744344816 | (37.7983580833179, -122.41744344816) | 5 | 1 | 10 | 28858 | 32 | |||
| 191106 | 136679 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6007499.46397 | 2117047.73589 | 37.7934329524128 | -122.41800163939 | (37.7934329524128, -122.41800163939) | 5 | 1 | 10 | 28858 | 32 | |||
| 190798 | 136683 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 874 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008833.05028 | 2119058.08121 | 37.7990278309217 | -122.413529563544 | (37.7990278309217, -122.413529563544) | 3 | 1 | 10 | 308 | 32 | |||
| 190275 | 215305 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5997468.9434 | 2093863.63233 | 37.7292056228286 | -122.451035210326 | (37.7292056228286, -122.451035210326) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 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 | |||
| 188918 | 179849 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5998875.31966 | 2090008.53873 | 37.7187008461546 | -122.445896113635 | (37.7187008461546, -122.445896113635) | 9 | 7 | 6 | 28861 | 25 | |||
| 186499 | 136703 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008348.84171 | 2118396.84882 | 37.7971850507978 | -122.415158261846 | (37.7971850507978, -122.415158261846) | 5 | 1 | 10 | 308 | 21 | |||
| 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 | |||
| 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 | |||
| 183336 | 136701 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008350.35689 | 2118390.24391 | 37.7971670005024 | -122.415152551158 | (37.7971670005024, -122.415152551158) | 5 | 1 | 10 | 308 | 21 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 177939 | 179858 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2344 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5999350.65317 | 2089217.81228 | 37.7165568219137 | -122.444196293341 | (37.7165568219137, -122.444196293341) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 175531 | 116299 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 175109 | 120844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.94097 | 2113420.78105 | 37.7824690387717 | -122.478575916411 | (37.7824690387717, -122.478575916411) | 11 | 6 | 2 | 55 | 26 | |||
| 175071 | 179890 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008311.43296 | 2094322.79302 | 37.7310811625636 | -122.413584137105 | (37.7310811625636, -122.413584137105) | 9 | 3 | 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 172817 | 179824 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998241.3307 | 2088717.20403 | 37.715118916577 | -122.447994624052 | (37.715118916577, -122.447994624052) | 9 | 7 | 6 | 28861 | 25 | |||
| 171818 | 179910 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5998425.41243 | 2088873.3917 | 37.7155582929503 | -122.447369596148 | (37.7155582929503, -122.447369596148) | 9 | 7 | 6 | 28861 | 25 | |||
| 169548 | 179797 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1795 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5997865.72526 | 2088414.28202 | 37.7142656847892 | -122.449271060624 | (37.7142656847892, -122.449271060624) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 168781 | 179913 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5998438.88118 | 2088852.56905 | 37.7155018883663 | -122.447321544456 | (37.7155018883663, -122.447321544456) | 9 | 7 | 6 | 28861 | 25 | |||
| 168686 | 136707 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1155 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007381.61519 | 2119835.37419 | 37.8010804768418 | -122.418607177199 | (37.8010804768418, -122.418607177199) | 5 | 1 | 1 | 28858 | 32 | |||
| 168206 | 179823 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998235.7927 | 2088724.10902 | 37.7151375595318 | -122.448014262544 | (37.7151375595318, -122.448014262544) | 9 | 7 | 6 | 28861 | 25 | |||
| 167373 | 215302 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 698 Hearst Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5996836.53539 | 2094438.39167 | 37.7307475482438 | -122.453262964135 | (37.7307475482438, -122.453262964135) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 164736 | 136638 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 98 Blake St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5997852.8228 | 2113221.03458 | 37.7823781953411 | -122.451103490434 | (37.7823781953411, -122.451103490434) | 15 | 6 | 1 | 54 | 31 | |||
| 163744 | 179847 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 231 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6000051.92108 | 2092264.11906 | 37.7249612688295 | -122.441990900256 | (37.7249612688295, -122.441990900256) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 161461 | 215320 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 613 Head St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5993477.4709 | 2089866.91929 | 37.7180022959343 | -122.464543873715 | (37.7180022959343, -122.464543873715) | 9 | 8 | 6 | 64 | 24 | |||
| 160226 | 179856 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 950 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5998506.12303 | 2089417.33041 | 37.7170564357799 | -122.447129747851 | (37.7170564357799, -122.447129747851) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 158009 | 179911 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5998429.31666 | 2088867.05856 | 37.7155411266995 | -122.447355645862 | (37.7155411266995, -122.447355645862) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 155887 | 179901 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008641.95014 | 2091241.02596 | 37.7226378397427 | -122.412223749739 | (37.7226378397427, -122.412223749739) | 9 | 3 | 7 | 309 | 28 | |||
| 152644 | 136704 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6008348.41822 | 2118399.20524 | 37.7971914971435 | -122.415159894117 | (37.7971914971435, -122.415159894117) | 5 | 1 | 10 | 308 | 21 | |||
| 152355 | 136667 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000893.50994 | 2117430.42201 | 37.7941097012578 | -122.440886139797 | (37.7941097012578, -122.440886139797) | 13 | 9 | 1 | 57 | 27 | |||
| 151400 | 97300 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
| 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 | |||
| 149391 | 215296 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5997379.68023 | 2094370.54244 | 37.7305923666319 | -122.451380344931 | (37.7305923666319, -122.451380344931) | 9 | 7 | 4 | 28861 | 40 | |||
| 149332 | 179850 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998778.24395 | 2089941.01946 | 37.7185099101936 | -122.446226809638 | (37.7185099101936, -122.446226809638) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | ||||
| 148428 | 179906 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 600 Somerset St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6010277.8918 | 2091719.16171 | 37.7240423622482 | -122.406602309775 | (37.7240423622482, -122.406602309775) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 147511 | 136710 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007938.82451 | 2120606.36693 | 37.8032287836485 | -122.41673363846 | (37.8032287836485, -122.41673363846) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 142955 | 215334 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998241.14099 | 2096403.03655 | 37.7362224032408 | -122.448548482343 | (37.7362224032408, -122.448548482343) | 9 | 7 | 4 | 59 | 40 | |||
| 142858 | 179806 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1475 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5998976.19185 | 2089464.18471 | 37.7172119339604 | -122.445508318764 | (37.7172119339604, -122.445508318764) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 137739 | 241056 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 4864 17th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5997871.31028 | 2105665.38567 | 37.7616333843862 | -122.450494663794 | (37.7616333843862, -122.450494663794) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 135535 | 120845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.85655 | 2113416.78862 | 37.7824580717728 | -122.478575916409 | (37.7824580717728, -122.478575916409) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 133639 | 121844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 518 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990041.13259 | 2111807.14387 | 37.7780457072257 | -122.478024804476 | (37.7780457072257, -122.478024804476) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 127564 | 179912 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5998434.10808 | 2088860.2602 | 37.7155227337561 | -122.447338595604 | (37.7155227337561, -122.447338595604) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | ||||
| 126177 | 179892 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008521.95318 | 2093544.04536 | 37.728954707483 | -122.412801294348 | (37.728954707483, -122.412801294348) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 125099 | 215304 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5997552.24164 | 2094964.50066 | 37.7322331140486 | -122.450826587399 | (37.7322331140486, -122.450826587399) | 9 | 7 | 4 | 59 | 40 | ||||
| 125098 | 179852 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5998768.26163 | 2089920.0752 | 37.7184518319668 | -122.446259808467 | (37.7184518319668, -122.446259808467) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 121616 | 136698 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6007369.77523 | 2120178.57084 | 37.802022141674 | -122.418672500363 | (37.802022141674, -122.418672500363) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 117200 | 136669 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000715.68155 | 2117388.18403 | 37.7939835974195 | -122.44149841085 | (37.7939835974195, -122.44149841085) | 13 | 9 | 1 | 57 | 27 | |||
| 115962 | 136711 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007948.87662 | 2120608.06628 | 37.8032340150017 | -122.416698973183 | (37.8032340150017, -122.416698973183) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | |||
| 114841 | 179851 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998773.25514 | 2089930.66617 | 37.718481197523 | -122.44624330948 | (37.718481197523, -122.44624330948) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 |
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) );