trees
379 rows where qSpecies_id = 86 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | |||
| 80235 | 179835 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001963.44434 | 2093526.42722 | 37.7285360253961 | -122.435473248114 | (37.7285360253961, -122.435473248114) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 22753 | 136655 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002095.53828 | 2121587.56307 | 37.80559250506 | -122.437024766584 | (37.80559250506, -122.437024766584) | 13 | 9 | 1 | 57 | 17 | |||
| 55052 | 136641 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002004.16197 | 2118138.13487 | 37.796116088744 | -122.437093866005 | (37.796116088744, -122.437093866005) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 112794 | 136639 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001999.29002 | 2118169.89644 | 37.7962030208048 | -122.437112999059 | (37.7962030208048, -122.437112999059) | 13 | 9 | 1 | 57 | 17 | |||
| 54533 | 215301 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001252.93679 | 2094603.03258 | 37.7314517578791 | -122.438006591549 | (37.7314517578791, -122.438006591549) | 9 | 7 | 4 | 63 | 40 | |||
| 12934 | 16022 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001242.37794 | 2094603.69246 | 37.7314529692816 | -122.438043142671 | (37.7314529692816, -122.438043142671) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |||
| 42725 | 215295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001248.26665 | 2095899.59415 | 37.7350115506281 | -122.43811558039 | (37.7350115506281, -122.43811558039) | 2 | 7 | 5 | 63 | 7 | |||
| 88824 | 179826 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 838 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001050.56087 | 2088944.05849 | 37.7159019895732 | -122.438300979212 | (37.7159019895732, -122.438300979212) | 9 | 7 | 6 | 28861 | 5 | |||
| 112775 | 241073 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Eureka St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6001398.38872 | 2105751.17643 | 37.7620701860117 | -122.438302103356 | (37.7620701860117, -122.438302103356) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 73562 | 59560 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/03/1981 12:00:00 AM | 1x1 | Permit Number 18946 | 6001393.95326629 | 2105805.98956595 | 37.7622204371899 | -122.438321370904 | (37.7622204371899, -122.438321370904) | 15 | 5 | 5 | 28862 | 3 | ||
| 5344 | 102057 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1x1 | Permit Number 18946 | 6001387 | 2105809 | 37.7622283076155 | -122.438345635253 | (37.7622283076155, -122.438345635253) | 15 | 5 | 5 | 28862 | 3 | |||
| 104877 | 179837 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Santa Rosa Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6000743.66321 | 2093585.989 | 37.728630215899 | -122.439694355537 | (37.728630215899, -122.439694355537) | 9 | 7 | 6 | 28861 | 25 | |||
| 113842 | 25295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 7x3 | 6000605.77697 | 2091736.42859 | 37.7235438977056 | -122.440038466696 | (37.7235438977056, -122.440038466696) | 9 | 7 | 6 | 28861 | 25 | |||
| 14728 | 62484 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 81 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 10 | Permit Number 22655 | 6000565.24487 | 2092874.98588 | 37.7266678079605 | -122.440260189157 | (37.7266678079605, -122.440260189157) | 9 | 7 | 6 | 28861 | 25 | |
| 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 | ||||
| 107311 | 179825 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1115 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6000416.25611 | 2090642.64667 | 37.7205298306712 | -122.440615189366 | (37.7205298306712, -122.440615189366) | 9 | 7 | 6 | 28861 | 25 | |||
| 37301 | 241067 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 229 Grand View Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000638.50789 | 2103037.93604 | 37.7545770419209 | -122.440735600467 | (37.7545770419209, -122.440735600467) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 |
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) );