trees
334 rows where qSpecies_id = 59 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150253 | 234896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 10ft | 6007240.7393 | 2101963.94083 | 37.7520018736867 | -122.417827151095 | (37.7520018736867, -122.417827151095) | 2 | 4 | 7 | 28859 | 19 | |||
| 21224 | 196043 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6017069.89025 | 2097009.95172 | 37.7389474821301 | -122.383491338448 | (37.7389474821301, -122.383491338448) | 10 | 3 | 8 | 58 | 1 | |||
| 35055 | 196038 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | 10 | 3 | 8 | 58 | 1 | |||
| 37731 | 196046 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017076.84536 | 2097020.98628 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | 10 | 3 | 8 | 58 | 1 | |||
| 52670 | 196039 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017058.78761 | 2096996.23306 | 37.7389091998064 | -122.38352877184 | (37.7389091998064, -122.38352877184) | 10 | 3 | 8 | 58 | 1 | |||
| 66956 | 196045 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017076.58838 | 2097018.35028 | 37.7389709130863 | -122.383468763681 | (37.7389709130863, -122.383468763681) | 10 | 3 | 8 | 58 | 1 | |||
| 91426 | 196034 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 6017038.23562 | 2096967.92235 | 37.7388303283508 | -122.38359786136 | (37.7388303283508, -122.38359786136) | 10 | 3 | 8 | 58 | 1 | |||
| 98268 | 196037 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017049.14343 | 2096982.73756 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | 10 | 3 | 8 | 58 | 1 | |||
| 104734 | 196035 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6017042.43736 | 2096973.93304 | 37.7388470647366 | -122.383583751905 | (37.7388470647366, -122.383583751905) | 10 | 3 | 8 | 58 | 1 | |||
| 110153 | 196040 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017061.14337 | 2096999.06361 | 37.7389171021312 | -122.383520823632 | (37.7389171021312, -122.383520823632) | 10 | 3 | 8 | 58 | 1 | |||
| 112062 | 196048 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6017086.86394 | 2097032.16257 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | 10 | 3 | 8 | 58 | 1 | |||
| 144912 | 196042 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017068.02223 | 2097008.36414 | 37.7389430197102 | -122.383497686772 | (37.7389430197102, -122.383497686772) | 10 | 3 | 8 | 58 | 1 | |||
| 148904 | 196044 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017074.4672 | 2097014.32935 | 37.7389597551859 | -122.383475817977 | (37.7389597551859, -122.383475817977) | 10 | 3 | 8 | 58 | 1 | |||
| 153530 | 196036 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017046.41048 | 2096978.72928 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | 10 | 3 | 8 | 58 | 1 | |||
| 158208 | 196041 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017065.52556 | 2097005.97628 | 37.7389363251367 | -122.383506153 | (37.7389363251367, -122.383506153) | 10 | 3 | 8 | 58 | 1 | |||
| 159019 | 196047 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6017083.09876 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | 10 | 3 | 8 | 58 | 1 | |||
| 164057 | 196049 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 10ft | 6017090.91062 | 2097040.61449 | 37.7390328376916 | -122.383420792935 | (37.7390328376916, -122.383420792935) | 10 | 3 | 8 | 58 | 1 | |||
| 6805 | 19781 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY19 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 50ST | |||||||||||||
| 12447 | 19841 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY25 | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 1959 | 19904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY34 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | |||||||||||||
| 18074 | 19903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY34 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | |||||||||||||
| 13169 | 20051 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY52 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
| 152832 | 140079 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000729.2298 | 2112451.4153 | 37.7804292797496 | -122.441097181955 | (37.7804292797496, -122.441097181955) | 15 | 5 | 1 | 29490 | 41 | |||
| 14173 | 140080 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000726.8608 | 2112462.5832 | 37.7804598090154 | -122.441106178881 | (37.7804598090154, -122.441106178881) | 15 | 5 | 1 | 29490 | 41 | |||
| 34981 | 244429 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005659.2973 | 2109696.7034 | 37.7731450894818 | -122.4238458121 | (37.7731450894818, -122.4238458121) | 7 | 9 | 11 | 28852 | 10 | |||
| 39892 | 244430 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.423851185605 | (37.7731694680478, -122.423851185605) | 7 | 9 | 11 | 28852 | 10 | |||
| 46467 | 244336 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | 7 | 9 | 11 | 28852 | 10 | |||
| 59524 | 244335 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | 7 | 9 | 11 | 28852 | 10 | |||
| 83892 | 244431 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.7732013716398 | -122.423856754026 | (37.7732013716398, -122.423856754026) | 7 | 9 | 11 | 28852 | 10 | |||
| 92490 | 244339 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 16 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005625.7255 | 2109918.6883 | 37.7737527111209 | -122.423977730108 | (37.7737527111209, -122.423977730108) | 7 | 9 | 11 | 28852 | 10 | |||
| 117263 | 244433 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.423891754495 | (37.7733626541324, -122.423891754495) | 7 | 9 | 11 | 28852 | 10 | |||
| 121894 | 244337 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005627.7809 | 2109896.0788 | 37.7736907469384 | -122.423969012041 | (37.7736907469384, -122.423969012041) | 7 | 9 | 11 | 28852 | 10 | |||
| 122485 | 244334 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005631.2066 | 2109866.6178 | 37.7736100475528 | -122.423955066597 | (37.7736100475528, -122.423955066597) | 7 | 9 | 11 | 28852 | 10 | |||
| 125575 | 244428 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005659.9824 | 2109685.0561 | 37.7731131474821 | -122.423842613892 | (37.7731131474821, -122.423842613892) | 7 | 9 | 11 | 28852 | 10 | |||
| 131182 | 244434 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005644.2243 | 2109791.2526 | 37.7734038478353 | -122.423904676174 | (37.7734038478353, -122.423904676174) | 7 | 9 | 11 | 28852 | 10 | |||
| 150696 | 244432 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005649.0202 | 2109761.1065 | 37.7733213446724 | -122.423885942412 | (37.7733213446724, -122.423885942412) | 7 | 9 | 11 | 28852 | 10 | |||
| 153224 | 244332 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005642.1688 | 2109804.2702 | 37.7734394749788 | -122.423912712296 | (37.7734394749788, -122.423912712296) | 7 | 9 | 11 | 28852 | 10 | |||
| 168738 | 244338 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005626.4106 | 2109908.4113 | 37.7737245316409 | -122.42397462928 | (37.7737245316409, -122.42397462928) | 7 | 9 | 11 | 28852 | 10 | |||
| 178442 | 244333 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005640.1134 | 2109813.177 | 37.773463814863 | -122.423920455707 | (37.773463814863, -122.423920455707) | 7 | 9 | 11 | 28852 | 10 | |||
| 184838 | 244427 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005661.3527 | 2109672.0384 | 37.7730774813758 | -122.423836948028 | (37.7730774813758, -122.423836948028) | 7 | 9 | 11 | 28852 | 10 | |||
| 126030 | 140081 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000726.184 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | 15 | 5 | 1 | 29490 | 41 | |||
| 313 | 119729 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 16277 | 119724 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 16362 | 119731 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 21014 | 119730 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 35418 | 119732 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 46759 | 119728 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 53212 | 119723 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 64910 | 119734 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 75461 | 119727 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 90812 | 119733 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 113560 | 119722 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 126751 | 119726 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 135794 | 119725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 160546 | 119721 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 180133 | 119735 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 14196 | 6096 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 36058 | 6095 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2015 12:00:00 AM | 12 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | ||
| 129436 | 6094 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 145827 | 6098 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 35297 | 248111 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6010383.71107 | 2099443.85944 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 37570 | 248117 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 7 | Side Yard : Yard | Tree | Private 2 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.406797301657 | (37.7451778188963, -122.406797301657) | 2 | 7 | 7 | 28859 | 2 | ||||
| 40536 | 248113 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | 6010385.30327 | 2099441.28079 | 37.7452516667373 | -122.406774968811 | (37.7452516667373, -122.406774968811) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80514 | 248115 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6010382.66989 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | 2 | 7 | 7 | 28859 | 2 | ||||
| 87689 | 248119 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 9 | Side Yard : Yard | Tree | Private 2 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.406806436993 | (37.7451368817742, -122.406806436993) | 2 | 7 | 7 | 28859 | 2 | ||||
| 89186 | 248114 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | 2 | 7 | 7 | 28859 | 2 | ||||
| 104444 | 248116 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464328 | -122.406793240314 | (37.745191464328, -122.406793240314) | 2 | 7 | 7 | 28859 | 2 | ||||
| 146085 | 248120 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.406813543437 | (37.745124840742, -122.406813543437) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172175 | 248118 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6010376.97092 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | 2 | 7 | 7 | 28859 | 2 | ||||
| 154261 | 140083 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | 15 | 5 | 1 | 29490 | 41 | |||
| 19786 | 248125 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6010397.04877 | 2099427.00914 | 37.7452131370768 | -122.406733349058 | (37.7452131370768, -122.406733349058) | 2 | 7 | 7 | 28859 | 2 | ||||
| 40830 | 248124 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | 2 | 7 | 7 | 28859 | 2 | ||||
| 77949 | 248121 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010387.39582 | 2099398.52057 | 37.7451343735684 | -122.406764720109 | (37.7451343735684, -122.406764720109) | 2 | 7 | 7 | 28859 | 2 | ||||
| 113044 | 248122 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 2 | Front Yard : Yard | Tree | Private 2 | 14 | 6010390.78091 | 2099407.55033 | 37.7451593567256 | -122.406753651253 | (37.7451593567256, -122.406753651253) | 2 | 7 | 7 | 28859 | 2 | ||||
| 126542 | 248127 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.406725228187 | (37.7452436393873, -122.406725228187) | 2 | 7 | 7 | 28859 | 2 | ||||
| 145571 | 248126 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6010387.78953 | 2099433.6295 | 37.7452307970734 | -122.406765832574 | (37.7452307970734, -122.406765832574) | 2 | 7 | 7 | 28859 | 2 | ||||
| 191905 | 248123 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010392.06783 | 2099413.07866 | 37.7451746083214 | -122.406749590819 | (37.7451746083214, -122.406749590819) | 2 | 7 | 7 | 28859 | 2 | ||||
| 16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
| 26017 | 109376 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 3 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 64778 | 109377 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 4 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 84676 | 109375 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 2 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 137889 | 109378 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 5 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 155569 | 109374 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 1 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 24272 | 117475 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
| 42959 | 117474 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
| 140069 | 212849 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | 1 | 8 | 4 | 59 | 40 | |||
| 95955 | 117473 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
| 114094 | 117472 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
| 83859 | 139060 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | 15 | 6 | 11 | 29490 | 31 | |||
| 35274 | 249899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | 3 | 1 | 10 | 28860 | 6 | |||
| 150059 | 249897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.404798850701 | (37.8030148322229, -122.404798850701) | 3 | 1 | 10 | 28860 | 6 | |||
| 55125 | 98312 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | 9 | 7 | 4 | 59 | 40 | |||||
| 52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 100049 | 196024 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6013848.21751 | 2107498.56576 | 37.7675683801977 | -122.395365047877 | (37.7675683801977, -122.395365047877) | 14 | 3 | 9 | 310 | 20 | |||
| 108842 | 196023 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6013858.29957 | 2107482.27299 | 37.7675242045935 | -122.395329033601 | (37.7675242045935, -122.395329033601) | 14 | 3 | 9 | 310 | 20 | |||
| 21347 | 201996 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013312.67339 | 2092499.74696 | 37.7263550129554 | -122.396166145968 | (37.7263550129554, -122.396166145968) | 10 | 3 | 8 | 58 | 1 | ||||
| 61218 | 201995 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013319.20907 | 2092521.70031 | 37.7264156560521 | -122.396145090149 | (37.7264156560521, -122.396145090149) | 10 | 3 | 8 | 58 | 1 | ||||
| 97183 | 201993 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013314.35101 | 2092488.44605 | 37.7263240762942 | -122.396159554816 | (37.7263240762942, -122.396159554816) | 10 | 3 | 8 | 58 | 1 | ||||
| 104890 | 201994 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013316.6056 | 2092506.69666 | 37.7263743142142 | -122.396153039251 | (37.7263743142142, -122.396153039251) | 10 | 3 | 8 | 58 | 1 | ||||
| 169280 | 201997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013313.68951 | 2092516.98736 | 37.7264024081338 | -122.396163841002 | (37.7264024081338, -122.396163841002) | 10 | 3 | 8 | 58 | 1 |
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) );