trees
217 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 86
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 753 | 197913 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Conkling St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6011758.24884 | 2095732.01029 | 37.7351435225424 | -122.40176684758 | (37.7351435225424, -122.40176684758) | 10 | 3 | 8 | 58 | 1 | |||
| 4119 | 179884 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007440.99847 | 2094010.17739 | 37.7301738725104 | -122.416571250581 | (37.7301738725104, -122.416571250581) | 9 | 3 | 7 | 309 | 28 | |||
| 6275 | 215306 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994798.91109 | 2091839.85894 | 37.7234956059322 | -122.46011911751 | (37.7234956059322, -122.46011911751) | 9 | 8 | 4 | 28861 | 24 | |||
| 8931 | 215339 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999420.83111 | 2095184.41503 | 37.7329437376643 | -122.444382272244 | (37.7329437376643, -122.444382272244) | 9 | 7 | 4 | 59 | 40 | |||
| 12690 | 179887 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007462.62751 | 2094011.80961 | 37.7301795706263 | -122.416496591546 | (37.7301795706263, -122.416496591546) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
| 14557 | 179896 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008623.46871 | 2091235.83896 | 37.7226225602776 | -122.412287269767 | (37.7226225602776, -122.412287269767) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 17039 | 136666 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000890.78199 | 2117450.16174 | 37.7941637460202 | -122.440896995501 | (37.7941637460202, -122.440896995501) | 13 | 9 | 1 | 57 | 27 | |||
| 20054 | 179816 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5998896.47943 | 2087985.98749 | 37.713148590116 | -122.445677603554 | (37.713148590116, -122.445677603554) | 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 | |||
| 20747 | 215303 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5997546.26853 | 2094964.87379 | 37.7322337966419 | -122.450847264584 | (37.7322337966419, -122.450847264584) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | |||
| 22738 | 120295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 191 24th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5988321.26869 | 2114707.42753 | 37.7859090914651 | -122.484187107183 | (37.7859090914651, -122.484187107183) | 11 | 6 | 1 | 55 | 33 | |||
| 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 | |||
| 23212 | 179853 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998760.78346 | 2089904.78247 | 37.7184094145512 | -122.446284557804 | (37.7184094145512, -122.446284557804) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 27598 | 179854 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 339 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998465.19432 | 2089720.01475 | 37.7178851988142 | -122.447292991002 | (37.7178851988142, -122.447292991002) | 9 | 7 | 6 | 28861 | 25 | ||||
| 29990 | 215341 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6000114.95424 | 2094335.27384 | 37.7306517731413 | -122.441921590428 | (37.7306517731413, -122.441921590428) | 9 | 7 | 4 | 63 | 40 | |||
| 30022 | 215307 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994799.16087 | 2091851.78305 | 37.7235283610397 | -122.460119117526 | (37.7235283610397, -122.460119117526) | 9 | 8 | 4 | 28861 | 24 | |||
| 31433 | 136684 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 57 Russell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007021.76535 | 2118934.77129 | 37.7985873825495 | -122.41978847538 | (37.7985873825495, -122.41978847538) | 5 | 1 | 10 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 34212 | 136690 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007706.55666 | 2118838.72504 | 37.7983622165993 | -122.417412065427 | (37.7983622165993, -122.417412065427) | 5 | 1 | 10 | 28858 | 32 | |||
| 35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | |||
| 36884 | 136634 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999197.43818 | 2121197.11006 | 37.8043552744421 | -122.447025895951 | (37.8043552744421, -122.447025895951) | 13 | 9 | 1 | 57 | 17 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 38106 | 247551 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 815 Buena Vista Ave West | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 2ft | 6000085.81992 | 2108391.87741 | 37.769246150022 | -122.443031409565 | (37.769246150022, -122.443031409565) | 15 | 5 | 11 | 29492 | 9 | |||
| 39011 | 179881 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007539.25103 | 2092829.10153 | 37.7269364183715 | -122.416147963965 | (37.7269364183715, -122.416147963965) | 9 | 3 | 7 | 309 | 28 | |||
| 39108 | 179880 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007526.36673 | 2092824.84352 | 37.7269240023301 | -122.416192203412 | (37.7269240023301, -122.416192203412) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 43129 | 100849 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
| 44005 | 179893 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008518.11565 | 2093559.33094 | 37.7289964630154 | -122.412815641254 | (37.7289964630154, -122.412815641254) | 9 | 3 | 7 | 309 | 28 | |||
| 44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | |||
| 44578 | 179805 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1475 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5998972.41815 | 2089460.57977 | 37.7172018201812 | -122.445521103537 | (37.7172018201812, -122.445521103537) | 9 | 7 | 6 | 28861 | 25 | |||
| 44958 | 136637 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997659.79036 | 2114483.77284 | 37.7858342881777 | -122.451862419331 | (37.7858342881777, -122.451862419331) | 15 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 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 | |||
| 46609 | 215311 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.93989 | 2088894.46571 | 37.7154733555918 | -122.455989631214 | (37.7154733555918, -122.455989631214) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 49209 | 179799 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998244.59243 | 2088714.20474 | 37.7151108676608 | -122.447983134341 | (37.7151108676608, -122.447983134341) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 49688 | 136713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 290 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011569.99478 | 2119432.50864 | 37.8002092172264 | -122.404085130728 | (37.8002092172264, -122.404085130728) | 3 | 1 | 10 | 308 | 23 | |||
| 51255 | 215297 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5997404.12695 | 2094370.52949 | 37.7305937308948 | -122.45129582845 | (37.7305937308948, -122.45129582845) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 53739 | 136691 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007718.23454 | 2118839.56071 | 37.7983651681777 | -122.417371715557 | (37.7983651681777, -122.417371715557) | 5 | 1 | 10 | 28858 | 32 | |||
| 54331 | 215340 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999417.92849 | 2095175.79644 | 37.7329199074284 | -122.444391688153 | (37.7329199074284, -122.444391688153) | 9 | 7 | 4 | 59 | 40 | |||
| 54391 | 179886 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6007455.79909 | 2094011.3835 | 37.7301780166028 | -122.416520168176 | (37.7301780166028, -122.416520168176) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 55838 | 179815 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 1ft | 5998907.25749 | 2087996.54696 | 37.713178199383 | -122.445641109954 | (37.713178199383, -122.445641109954) | 9 | 7 | 6 | 28861 | 25 | |||
| 56720 | 116300 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | |||
| 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 | |||
| 58420 | 136671 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000711.13679 | 2117411.08582 | 37.7940462208083 | -122.441515780329 | (37.7940462208083, -122.441515780329) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |||
| 61991 | 136635 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999192.08373 | 2121248.84261 | 37.804497012091 | -122.447048150554 | (37.804497012091, -122.447048150554) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 65762 | 136699 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1955 Jones St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6008168.57169 | 2119227.42502 | 37.7994554738439 | -122.415840886849 | (37.7994554738439, -122.415840886849) | 5 | 1 | 10 | 308 | 32 | |||
| 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 | ||||
| 70544 | 179889 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008314.8677 | 2094310.92324 | 37.7310487635727 | -122.41357142338 | (37.7310487635727, -122.41357142338) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 78875 | 247550 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 815 Buena Vista Ave West | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6000097.50297 | 2108400.91643 | 37.7692716350156 | -122.442991647843 | (37.7692716350156, -122.442991647843) | 15 | 5 | 11 | 29492 | 9 | |||
| 79283 | 179800 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 228 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998609.28877 | 2088802.95321 | 37.7153753906268 | -122.446728973961 | (37.7153753906268, -122.446728973961) | 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 | |||
| 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 | |||
| 81457 | 179891 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008528.33324 | 2093531.3526 | 37.7289202139869 | -122.41277834095 | (37.7289202139869, -122.41277834095) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 84545 | 136709 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007914.92474 | 2120604.50253 | 37.8032223202271 | -122.416816212417 | (37.8032223202271, -122.416816212417) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | |||
| 85219 | 136636 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997648.25188 | 2114482.46822 | 37.7858300451643 | -122.451902244894 | (37.7858300451643, -122.451902244894) | 15 | 6 | 1 | 54 | 31 | |||
| 87437 | 179846 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 29 Colonial Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000367.54069 | 2093586.66565 | 37.7286106583386 | -122.440994678056 | (37.7286106583386, -122.440994678056) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 90245 | 136682 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 874 Green St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008846.30156 | 2119059.10202 | 37.7990313778645 | -122.413483781748 | (37.7990313778645, -122.413483781748) | 3 | 1 | 10 | 308 | 32 | |||
| 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 | |||
| 94276 | 179895 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008618.46635 | 2091234.88491 | 37.7226196599519 | -122.412304494484 | (37.7226196599519, -122.412304494484) | 9 | 3 | 7 | 309 | 28 | |||
| 96676 | 215308 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994977.25671 | 2089298.75113 | 37.7165285859022 | -122.459318680413 | (37.7165285859022, -122.459318680413) | 9 | 8 | 6 | 28861 | 24 | |||
| 98214 | 179796 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1795 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 1ft | 5997861.23879 | 2088411.17322 | 37.714256892113 | -122.449286343701 | (37.714256892113, -122.449286343701) | 9 | 7 | 6 | 28861 | 25 | |||
| 100575 | 136700 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1955 Jones St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6008170.72961 | 2119215.54579 | 37.7994229777558 | -122.415832578026 | (37.7994229777558, -122.415832578026) | 5 | 1 | 10 | 308 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );