trees
217 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 86 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 100716 | 136692 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007731.45393 | 2118841.87046 | 37.7983722539254 | -122.417326136092 | (37.7983722539254, -122.417326136092) | 5 | 1 | 10 | 28858 | 32 | |||
| 105016 | 136696 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1063 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 6ft | 6007280.02976 | 2120167.28303 | 37.8019860950362 | -122.418982261931 | (37.8019860950362, -122.418982261931) | 5 | 1 | 1 | 28858 | 32 | |||
| 115962 | 136711 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007948.87662 | 2120608.06628 | 37.8032340150017 | -122.416698973183 | (37.8032340150017, -122.416698973183) | 5 | 1 | 1 | 308 | 32 | |||
| 121616 | 136698 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6007369.77523 | 2120178.57084 | 37.802022141674 | -122.418672500363 | (37.802022141674, -122.418672500363) | 5 | 1 | 1 | 28858 | 32 | |||
| 133349 | 136697 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007352.71781 | 2120177.3681 | 37.80201787889 | -122.418731441927 | (37.80201787889, -122.418731441927) | 5 | 1 | 1 | 28858 | 32 | |||
| 140172 | 136708 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007910.30742 | 2120604.37308 | 37.803221705081 | -122.416832181661 | (37.803221705081, -122.416832181661) | 5 | 1 | 1 | 308 | 32 | |||
| 147511 | 136710 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007938.82451 | 2120606.36693 | 37.8032287836485 | -122.41673363846 | (37.8032287836485, -122.41673363846) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 173768 | 136712 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 84 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008291.17542 | 2119130.0368 | 37.7991949618221 | -122.415409734769 | (37.7991949618221, -122.415409734769) | 5 | 1 | 10 | 308 | 32 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 192961 | 136689 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6007697.4603 | 2118837.4061 | 37.7983580833179 | -122.41744344816 | (37.7983580833179, -122.41744344816) | 5 | 1 | 10 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 105096 | 179885 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007447.44417 | 2094010.42268 | 37.7301749085276 | -122.416548984266 | (37.7301749085276, -122.416548984266) | 9 | 3 | 7 | 309 | 28 | |||
| 105223 | 179902 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008644.61497 | 2091242.09558 | 37.7226409262237 | -122.412214613536 | (37.7226409262237, -122.412214613536) | 9 | 3 | 7 | 309 | 28 | |||
| 106736 | 179905 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1216 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 6008780.07198 | 2094033.26413 | 37.7303124823168 | -122.411943512893 | (37.7303124823168, -122.411943512893) | 9 | 3 | 7 | 309 | 28 | |||
| 112107 | 179897 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008627.84918 | 2091236.6223 | 37.7226249569704 | -122.412272182734 | (37.7226249569704, -122.412272182734) | 9 | 3 | 7 | 309 | 28 | |||
| 126177 | 179892 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008521.95318 | 2093544.04536 | 37.728954707483 | -122.412801294348 | (37.728954707483, -122.412801294348) | 9 | 3 | 7 | 309 | 28 | |||
| 141080 | 179879 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 463 Amherst St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007835.00514 | 2091691.6908 | 37.7238299567678 | -122.415045072275 | (37.7238299567678, -122.415045072275) | 9 | 3 | 7 | 309 | 28 | |||
| 144877 | 179883 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 39 Amherst St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007323.05766 | 2093363.44581 | 37.7283914539998 | -122.416933184515 | (37.7283914539998, -122.416933184515) | 9 | 3 | 7 | 309 | 5 | |||
| 148428 | 179906 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 600 Somerset St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6010277.8918 | 2091719.16171 | 37.7240423622482 | -122.406602309775 | (37.7240423622482, -122.406602309775) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 157954 | 179904 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008652.42423 | 2091244.38754 | 37.7226476576547 | -122.412187780452 | (37.7226476576547, -122.412187780452) | 9 | 3 | 7 | 309 | 28 | |||
| 173401 | 179888 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008315.20524 | 2094307.45797 | 37.7310392676412 | -122.413570011448 | (37.7310392676412, -122.413570011448) | 9 | 3 | 7 | 309 | 28 | |||
| 175071 | 179890 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008311.43296 | 2094322.79302 | 37.7310811625636 | -122.413584137105 | (37.7310811625636, -122.413584137105) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 137739 | 241056 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 4864 17th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5997871.31028 | 2105665.38567 | 37.7616333843862 | -122.450494663794 | (37.7616333843862, -122.450494663794) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 115107 | 123109 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992552.3957 | 2111792.37608 | 37.7781505989958 | -122.469336449069 | (37.7781505989958, -122.469336449069) | 11 | 6 | 2 | 54 | 11 | |||
| 127245 | 123108 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992553.53653 | 2111802.27469 | 37.7781778438173 | -122.469333223241 | (37.7781778438173, -122.469333223241) | 11 | 6 | 2 | 54 | 11 | |||
| 133639 | 121844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 518 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990041.13259 | 2111807.14387 | 37.7780457072257 | -122.478024804476 | (37.7780457072257, -122.478024804476) | 11 | 6 | 2 | 55 | 26 | |||
| 135535 | 120845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.85655 | 2113416.78862 | 37.7824580717728 | -122.478575916409 | (37.7824580717728, -122.478575916409) | 11 | 6 | 2 | 55 | 26 | |||
| 164736 | 136638 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 98 Blake St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5997852.8228 | 2113221.03458 | 37.7823781953411 | -122.451103490434 | (37.7823781953411, -122.451103490434) | 15 | 6 | 1 | 54 | 31 | |||
| 175109 | 120844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.94097 | 2113420.78105 | 37.7824690387717 | -122.478575916411 | (37.7824690387717, -122.478575916411) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );