trees
379 rows where 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193341 | 120231 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988063.88277 | 2114955.73403 | 37.7865758810738 | -122.485095805195 | (37.7865758810738, -122.485095805195) | 11 | 6 | 1 | 55 | 33 | |||
| 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 | |||
| 192763 | 215327 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992028.3413 | 2098343.65136 | 37.7411936459769 | -122.470169759049 | (37.7411936459769, -122.470169759049) | 1 | 8 | 4 | 59 | 40 | |||
| 192633 | 215285 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1536 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993707.75608 | 2105010.81191 | 37.7595969145732 | -122.464847054052 | (37.7595969145732, -122.464847054052) | 1 | 8 | 4 | 56 | 12 | |||
| 191808 | 103623 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | ||
| 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 | |||
| 190200 | 215291 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5994404.07408 | 2100583.57652 | 37.7474809790792 | -122.462117787007 | (37.7474809790792, -122.462117787007) | 1 | 8 | 4 | 29491 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 183619 | 215325 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992027.65667 | 2098311.13553 | 37.7411043262013 | -122.470169759048 | (37.7411043262013, -122.470169759048) | 1 | 8 | 4 | 59 | 40 | |||
| 183558 | 215284 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1442 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993065.75738 | 2105645.52263 | 37.7613026281332 | -122.467113534456 | (37.7613026281332, -122.467113534456) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 180866 | 179830 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 966 Randolph St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 5991498.1765 | 2088667.95393 | 37.7145959293389 | -122.471298058377 | (37.7145959293389, -122.471298058377) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 178178 | 197908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012886.87762 | 2106673.42615 | 37.7652492165901 | -122.398632309145 | (37.7652492165901, -122.398632309145) | 14 | 3 | 8 | 28856 | 20 | |||
| 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 | |||
| 175671 | 67619 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 11 | Permit Number 31202 | 6007683.17057 | 2118835.54867 | 37.7983521792584 | -122.417492763389 | (37.7983521792584, -122.417492763389) | 5 | 1 | 10 | 28858 | 32 | |
| 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 | |||
| 171043 | 215330 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2095 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5993552.71459 | 2101379.42964 | 37.7496171342399 | -122.465119504581 | (37.7496171342399, -122.465119504581) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 169423 | 41927 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42287 | 5994711.05634 | 2111911.6847 | 37.7786026960614 | -122.46187756658 | (37.7786026960614, -122.46187756658) | 11 | 6 | 2 | 54 | 11 | |
| 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 | |||
| 166505 | 215294 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 4ft | 5994441.43842 | 2100548.35757 | 37.7473864279531 | -122.461986030947 | (37.7473864279531, -122.461986030947) | 1 | 8 | 4 | 29491 | 40 | |||
| 166310 | 179817 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998649.3213 | 2087861.75891 | 37.712793372299 | -122.446522930295 | (37.712793372299, -122.446522930295) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 163182 | 256443 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | |||
| 161074 | 41928 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42287 | 5994708.51972 | 2111929.51477 | 37.7786515066402 | -122.461887634901 | (37.7786515066402, -122.461887634901) | 11 | 6 | 2 | 54 | 11 | |
| 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 | |||
| 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 | |||
| 158694 | 197907 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012887.44209 | 2106652.03819 | 37.7651905214559 | -122.398628855746 | (37.7651905214559, -122.398628855746) | 14 | 3 | 8 | 28856 | 20 | |||
| 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 | |||
| 157310 | 215326 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992028.53266 | 2098327.51469 | 37.7411493498502 | -122.470167922636 | (37.7411493498502, -122.470167922636) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 157108 | 114608 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 2398X 15TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 5991654 | 2099150 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | 1 | 8 | 4 | 29491 | 40 | ||||
| 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 | |||
| 155425 | 197901 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6010946.53736 | 2105641.36513 | 37.7623071159928 | -122.405270835575 | (37.7623071159928, -122.405270835575) | 8 | 3 | 8 | 28856 | 29 | |||
| 153842 | 179802 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Rome St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 1ft | 5998783.71606 | 2088961.91688 | 37.715821831192 | -122.446137506065 | (37.715821831192, -122.446137506065) | 9 | 7 | 6 | 28861 | 25 | |||
| 152699 | 215321 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1546 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993089.7363 | 2104935.14056 | 37.7593534887954 | -122.466978955425 | (37.7593534887954, -122.466978955425) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 152327 | 17449 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012949.37731 | 2096657.76915 | 37.7377518631542 | -122.39771357075 | (37.7377518631542, -122.39771357075) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 150071 | 67960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 819 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31680 | 5987243.89988 | 2110346.29905 | 37.7738718832899 | -122.487593962509 | (37.7738718832899, -122.487593962509) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |||
| 147312 | 215316 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997674.77739 | 2090086.49914 | 37.7188462827039 | -122.45005150039 | (37.7188462827039, -122.45005150039) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||
| 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 | |||
| 146312 | 17448 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012936.47341 | 2096667.45251 | 37.7377777330535 | -122.397758865084 | (37.7377777330535, -122.397758865084) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 145870 | 197909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012886.11406 | 2106697.30378 | 37.7653147367117 | -122.398636625887 | (37.7653147367117, -122.398636625887) | 14 | 3 | 8 | 28856 | 20 | |||
| 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 | ||||
| 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 | |||
| 145014 | 256324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3000X Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 |
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) );