trees
379 rows where qSpecies_id = 86 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
6245 | 75019 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.457882656117 | (37.782106991639, -122.457882656117) | 11 | 6 | 1 | 54 | 31 | ||
11629 | 47454 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 5135 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45360 | 5982684.34734 | 2111666.51211 | 37.7772298203102 | -122.50346371712 | (37.7772298203102, -122.50346371712) | 11 | 6 | 2 | 55 | 26 | |
12157 | 241051 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 961 San Bruno Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011090.2221 | 2103848.38169 | 37.757392016144 | -122.40464765488 | (37.757392016144, -122.40464765488) | 10 | 4 | 8 | 28859 | 19 | |||
15056 | 136668 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000716.04305 | 2117375.36701 | 37.793948425839 | -122.44149623986 | (37.793948425839, -122.44149623986) | 13 | 9 | 1 | 57 | 27 | |||
27027 | 179833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002155.36157 | 2093545.08036 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | 9 | 7 | 6 | 28861 | 25 | |||
27327 | 179900 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008639.8841 | 2091240.95748 | 37.7226375357801 | -122.412230886773 | (37.7226375357801, -122.412230886773) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
33199 | 179907 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 600 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6010281.08553 | 2091712.86969 | 37.7240252643514 | -122.406590826309 | (37.7240252643514, -122.406590826309) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||
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 | |||
40385 | 215342 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5999549.56796 | 2093580.96212 | 37.7285483748934 | -122.443822037778 | (37.7285483748934, -122.443822037778) | 9 | 7 | 4 | 63 | 40 | |||
43003 | 136693 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2164 Hyde St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007181.34298 | 2119779.01061 | 37.8009144395066 | -122.41929620626 | (37.8009144395066, -122.41929620626) | 5 | 1 | 1 | 28858 | 32 | |||
44452 | 136673 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000708.53208 | 2117436.75891 | 37.7941165639844 | -122.441526636039 | (37.7941165639844, -122.441526636039) | 13 | 9 | 1 | 57 | 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 | |||
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 | |||
57882 | 136670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000713.73895 | 2117400.40925 | 37.7940170539955 | -122.441506010108 | (37.7940170539955, -122.441506010108) | 13 | 9 | 1 | 57 | 27 | |||
60405 | 120082 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 261 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987725.3967 | 2114231.06843 | 37.7845664337094 | -122.486213650773 | (37.7845664337094, -122.486213650773) | 11 | 6 | 1 | 55 | 26 | |||
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 | |||
67559 | 179809 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 114 Niagara Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5999497.59387 | 2089483.70241 | 37.7172952777295 | -122.443707485722 | (37.7172952777295, -122.443707485722) | 9 | 7 | 6 | 28861 | 25 | |||
79418 | 179867 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005404.97601 | 2092232.73416 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | 9 | 7 | 6 | 309 | 5 | |||
81024 | 113456 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 6X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008347.73797 | 2116436.02263 | 37.7918010435277 | -122.415023221461 | (37.7918010435277, -122.415023221461) | 5 | 1 | 10 | 28858 | 21 | |||
83289 | 64384 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 290 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53175 | 6011583.39503 | 2119434.85196 | 37.8002164001168 | -122.404038925378 | (37.8002164001168, -122.404038925378) | 3 | 1 | 10 | 308 | 23 | |
84447 | 241052 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 961 San Bruno Ave | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6011089.42148 | 2103864.30149 | 37.7574356836305 | -122.404651544442 | (37.7574356836305, -122.404651544442) | 10 | 4 | 8 | 28859 | 19 | |||
84969 | 136678 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6007492.70889 | 2117096.59509 | 37.7935667274799 | -122.418028477839 | (37.7935667274799, -122.418028477839) | 5 | 1 | 10 | 28858 | 32 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
129943 | 123960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 241 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | Permit Number 782043 | 5993663.58723 | 2113895.36148 | 37.7839889783025 | -122.465645289525 | (37.7839889783025, -122.465645289525) | 11 | 6 | 2 | 54 | 11 | ||
132805 | 136694 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1201 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007018.29249 | 2119785.88696 | 37.8009241359937 | -122.41986091934 | (37.8009241359937, -122.41986091934) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
20460 | 100528 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4.5x6 | 6008351.1313 | 2118382.01094 | 37.7971444383282 | -122.415149288427 | (37.7971444383282, -122.415149288427) | 5 | 1 | 10 | 308 | 21 | |||
21329 | 136680 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007505.03866 | 2117018.90394 | 37.7933541007707 | -122.417980305661 | (37.7933541007707, -122.417980305661) | 5 | 1 | 10 | 28858 | 32 | |||
24655 | 215338 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998226.11251 | 2096380.78786 | 37.7361604543418 | -122.448598839867 | (37.7361604543418, -122.448598839867) | 9 | 7 | 4 | 59 | 40 | |||
33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
34996 | 31114 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.19171 | 2094330.53052 | 37.7305632843566 | -122.44649422303 | (37.7305632843566, -122.44649422303) | 9 | 7 | 4 | 28861 | 40 | |
37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
46837 | 179803 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998958.13876 | 2089448.31197 | 37.7171673203931 | -122.445569578776 | (37.7171673203931, -122.445569578776) | 9 | 7 | 6 | 28861 | 25 | |||
49054 | 179903 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6008647.44016 | 2091243.13146 | 37.7226439290591 | -122.412204920617 | (37.7226439290591, -122.412204920617) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
59813 | 136702 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008349.70738 | 2118393.07464 | 37.7971747364841 | -122.415154999108 | (37.7971747364841, -122.415154999108) | 5 | 1 | 10 | 308 | 21 | |||
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 | |||
69558 | 84155 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 770 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52704 | 5981697.89996 | 2110507.76717 | 37.7739902053501 | -122.506790127416 | (37.7739902053501, -122.506790127416) | 11 | 6 | 2 | 55 | 26 | |
71160 | 136681 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007511.08374 | 2116974.21798 | 37.7932317444123 | -122.41795622 | (37.7932317444123, -122.41795622) | 5 | 1 | 10 | 28858 | 32 | |||
71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||
88955 | 215335 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998237.40059 | 2096398.28008 | 37.7362091292407 | -122.448561071933 | (37.7362091292407, -122.448561071933) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
92456 | 215336 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998234.84844 | 2096392.28962 | 37.7361925349403 | -122.448569464424 | (37.7361925349403, -122.448569464424) | 9 | 7 | 4 | 59 | 40 | |||
126944 | 241063 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005947.85615 | 2095824.2566 | 37.73507084564 | -122.421862055716 | (37.73507084564, -122.421862055716) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
105769 | 17447 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012920.44639 | 2096678.64853 | 37.7378075824587 | -122.397815063738 | (37.7378075824587, -122.397815063738) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
9034 | 179812 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999375.14619 | 2089880.54718 | 37.71837793826 | -122.444159228684 | (37.71837793826, -122.444159228684) | 9 | 7 | 6 | 28861 | 25 | |||
20238 | 197904 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 654 Minnesota St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6015148.99162 | 2105385.9246 | 37.761839786886 | -122.390718148347 | (37.761839786886, -122.390718148347) | 10 | 3 | 8 | 28856 | 29 | |||
32212 | 179898 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008631.84124 | 2091237.77549 | 37.7226283473964 | -122.412258464481 | (37.7226283473964, -122.412258464481) | 9 | 3 | 7 | 309 | 28 | |||
46050 | 215344 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999563.31377 | 2093588.13313 | 37.7285688488645 | -122.443775032896 | (37.7285688488645, -122.443775032896) | 9 | 7 | 4 | 63 | 40 | |||
64911 | 179899 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008635.8472 | 2091239.23923 | 37.7226325913056 | -122.412244720114 | (37.7226325913056, -122.412244720114) | 9 | 3 | 7 | 309 | 28 | |||
103352 | 179813 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999385.00434 | 2089890.92911 | 37.7184070070682 | -122.444125898896 | (37.7184070070682, -122.444125898896) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | |||
137276 | 179819 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998682.50802 | 2087825.81458 | 37.7126965728687 | -122.446405642516 | (37.7126965728687, -122.446405642516) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
61794 | 215293 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5994427.84018 | 2100560.89209 | 37.747420061691 | -122.462033961208 | (37.747420061691, -122.462033961208) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
6411 | 136695 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1200 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6007098.70591 | 2119850.28744 | 37.8011054932745 | -122.419587225988 | (37.8011054932745, -122.419587225988) | 5 | 1 | 1 | 28858 | 32 | ||||
42109 | 215292 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5994414.45382 | 2100572.16969 | 37.747450256423 | -122.462081067713 | (37.747450256423, -122.462081067713) | 1 | 8 | 4 | 29491 | 40 |
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) );