Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188309 234896 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 10ft   6007240.7393 2101963.9408299997 37.7520018736867 -122.41782715109501 (37.7520018736867, -122.417827151095)
35215 196035 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 10ft   6017042.43736 2096973.9330400003 37.7388470647366 -122.38358375190501 (37.7388470647366, -122.383583751905)
38488 196041 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6017065.52556 2097005.9762799998 37.738936325136706 -122.383506153 (37.7389363251367, -122.383506153)
53814 196045 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6017076.588380001 2097018.35028 37.7389709130863 -122.383468763681 (37.7389709130863, -122.383468763681)
55642 196036 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   6017046.41048 2096978.7292799999 37.738860453849 -122.383570348389 (37.738860453849, -122.383570348389)
61094 196049 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 10ft   6017090.910619999 2097040.61449 37.7390328376916 -122.38342079293501 (37.7390328376916, -122.383420792935)
65477 196046 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017076.84536 2097020.9862799998 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608)
69044 196048 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 10ft   6017086.8639400005 2097032.1625700002 37.7390094067689 -122.383434196434 (37.7390094067689, -122.383434196434)
73353 196047 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 10ft   6017083.0987599995 2097027.5652 37.7389965752218 -122.383446894874 (37.7389965752218, -122.383446894874)
74651 196034 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 10ft   6017038.2356199995 2096967.92235 37.738830328350794 -122.38359786136002 (37.7388303283508, -122.38359786136)
148840 196044 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   6017074.4672 2097014.32935 37.7389597551859 -122.38347581797701 (37.7389597551859, -122.383475817977)
149400 196040 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6017061.14337 2096999.0636099998 37.738917102131204 -122.383520823632 (37.7389171021312, -122.383520823632)
150116 196042 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6017068.02223 2097008.3641400002 37.7389430197102 -122.383497686772 (37.7389430197102, -122.383497686772)
152860 196043 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   6017069.89025 2097009.95172 37.7389474821301 -122.38349133844801 (37.7389474821301, -122.383491338448)
162017 196037 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017049.14343 2096982.7375599998 37.7388716108342 -122.383561177999 (37.7388716108342, -122.383561177999)
166201 196038 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017052.09274 2096987.35134 37.7388844423585 -122.38355130167 (37.7388844423585, -122.38355130167)
168448 196039 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   6017058.78761 2096996.2330599998 37.7389091998064 -122.38352877183998 (37.7389091998064, -122.38352877184)
7574 19781 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 50ST            
13863 19841 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
5897 19904 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 6X6            
6788 19903 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY34 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 6X6            
16741 20051 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY52 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10            
26304 140079 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 100 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6000729.2298 2112451.4153 37.780429279749605 -122.44109718195499 (37.7804292797496, -122.441097181955)
46771 140080 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 102 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6000726.8608 2112462.5832 37.7804598090154 -122.441106178881 (37.7804598090154, -122.441106178881)
37654 244429 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6005659.2973 2109696.7034 37.773145089481794 -122.4238458121 (37.7731450894818, -122.4238458121)
46046 244430 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005657.927 2109705.6102 37.7731694680478 -122.42385118560499 (37.7731694680478, -122.423851185605)
47891 244336 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 13 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6005628.4661 2109884.4314 37.7736588046762 -122.423965813403 (37.7736588046762, -122.423965813403)
59788 244335 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6005630.5215 2109874.8395 37.7736325836766 -122.42395802123 (37.7736325836766, -122.42395802123)
66890 244431 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6005656.5567 2109717.2576 37.77320137163979 -122.42385675402599 (37.7732013716398, -122.423856754026)
73006 244339 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 16 Median : Cutout 11 Tree 1 DPW 2     14 Width 0ft   6005625.7255 2109918.6883 37.7737527111209 -122.42397773010799 (37.7737527111209, -122.423977730108)
136569 244337 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 14 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   6005627.7809 2109896.0788 37.7736907469384 -122.423969012041 (37.7736907469384, -122.423969012041)
147500 244428 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005659.9824 2109685.0561 37.7731131474821 -122.423842613892 (37.7731131474821, -122.423842613892)
150135 244433 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6005647.6499 2109776.1795 37.7733626541324 -122.42389175449499 (37.7733626541324, -122.423891754495)
152207 244334 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6005631.2066 2109866.6178 37.77361004755279 -122.423955066597 (37.7736100475528, -122.423955066597)
153505 244434 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6005644.2243 2109791.2526 37.7734038478353 -122.42390467617399 (37.7734038478353, -122.423904676174)
155716 244432 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2     11 Width 0ft   6005649.0202 2109761.1065 37.7733213446724 -122.423885942412 (37.7733213446724, -122.423885942412)
168209 244332 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6005642.1688 2109804.2702 37.773439474978794 -122.42391271229602 (37.7734394749788, -122.423912712296)
168334 244338 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 15 Median : Cutout 11 Tree 1 DPW 2     11 Width 0ft   6005626.4106 2109908.4113 37.773724531640894 -122.42397462928001 (37.7737245316409, -122.42397462928)
176308 244427 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6005661.3527 2109672.0384 37.7730774813758 -122.423836948028 (37.7730774813758, -122.423836948028)
185211 244333 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 102x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   6005640.1134 2109813.1769999997 37.773463814863 -122.42392045570699 (37.773463814863, -122.423920455707)
169265 140081 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 104 Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6000726.183999999 2112472.3974 37.7804867177527 -122.441109224562 (37.7804867177527, -122.441109224562)
25404 119731 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
80683 119723 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
83899 119728 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
86543 119734 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 14 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
89139 119727 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
92884 119733 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 13 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
100173 119722 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
103992 119729 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
105008 119726 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
115597 119725 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
120707 119721 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
123390 119724 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
126370 119730 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
129094 119732 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
138816 119735 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 15 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
18395 6096 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 106X Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
78042 6095 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 106X Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/19/2015 12:00:00 AM 12 3X3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
108312 6094 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 106X Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
112632 6098 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 106X Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6000733.8426241 2112435.5369559 37.780385944611204 -122.44108008458001 (37.7803859446112, -122.44108008458)
24297 248119 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 9 Side Yard : Yard 17 Tree 1 Private 1     18     6010375.35501 2099399.67941 37.7451368817742 -122.40680643699301 (37.7451368817742, -122.406806436993)
36690 248115 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 5 Side Yard : Yard 17 Tree 1 Private 1     7     6010382.6698900005 2099427.30215 37.7452131370921 -122.406783089664 (37.7452131370921, -122.406783089664)
38800 248116 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 6 Side Yard : Yard 17 Tree 1 Private 1     9     6010379.57479 2099419.47211 37.745191464327995 -122.406793240314 (37.745191464328, -122.406793240314)
46620 248114 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 4 Side Yard : Yard 17 Tree 1 Private 1     15     6010381.0463 2099434.05906 37.7452315992509 -122.406789179902 (37.7452315992509, -122.406789179902)
54920 248118 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 8 Side Yard : Yard 17 Tree 1 Private 1     6     6010376.970919999 2099406.95495 37.7451569492381 -122.40680136209 (37.7451569492381, -122.40680136209)
70123 248111 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 1 Side Yard : Yard 17 Tree 1 Private 1     24     6010383.711069999 2099443.8594400003 37.7452586580609 -122.406780656096 (37.7452586580609, -122.406780656096)
130896 248113 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 3 Side Yard : Yard 17 Tree 1 Private 1     17     6010385.30327 2099441.28079 37.745251666737296 -122.40677496881099 (37.7452516667373, -122.406774968811)
148699 248117 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 7 Side Yard : Yard 17 Tree 1 Private 1     6     6010378.29952 2099414.5285 37.7451778188963 -122.40679730165701 (37.7451778188963, -122.406797301657)
154282 248120 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 10 Side Yard : Yard 17 Tree 1 Private 1     12     6010373.21137 2099395.33781 37.745124840742 -122.40681354343701 (37.745124840742, -122.406813543437)
175227 140083 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6000722.7998 2112497.1022 37.7805543580623 -122.441122705034 (37.7805543580623, -122.441122705034)
30434 248121 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 1 Front Yard : Yard 7 Tree 1 Private 1     11     6010387.395819999 2099398.52057 37.7451343735684 -122.40676472010901 (37.7451343735684, -122.406764720109)
32347 248125 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 5 Front Yard : Yard 7 Tree 1 Private 1     7     6010397.048769999 2099427.00914 37.745213137076796 -122.406733349058 (37.7452131370768, -122.406733349058)
35883 248126 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 6 Front Yard : Yard 7 Tree 1 Private 1     6     6010387.789530001 2099433.6295 37.7452307970734 -122.40676583257401 (37.7452307970734, -122.406765832574)
51090 248124 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 4 Front Yard : Yard 7 Tree 1 Private 1     10     6010394.26479 2099420.04988 37.7451938726969 -122.406742485274 (37.7451938726969, -122.406742485274)
129839 248123 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 3 Front Yard : Yard 7 Tree 1 Private 1     13     6010392.06783 2099413.0786599996 37.7451746083214 -122.40674959081899 (37.7451746083214, -122.406749590819)
182677 248122 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 2 Front Yard : Yard 7 Tree 1 Private 1     14     6010390.78091 2099407.55033 37.7451593567256 -122.406753651253 (37.7451593567256, -122.406753651253)
185609 248127 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 7 Front Yard : Yard 7 Tree 1 Private 1     18     6010399.6226 2099438.06548 37.7452436393873 -122.40672522818701 (37.7452436393873, -122.406725228187)
4763 220524 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 110 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/1974 12:00:00 AM 38 Width 3ft Permit Number 14125 6003373.13767 2108706.4584 37.770296793780396 -122.431683217203 (37.7702967937804, -122.431683217203)
86843 109377 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 4 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
96460 109375 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 2 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
112237 109378 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 5 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
118325 109374 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 1 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
127758 109376 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 3 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
77831 117475 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout 20 Tree 1 Private 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
81560 117474 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout 20 Tree 1 Private 1           6011580.0 2119440.0 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068)
44122 212849 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1201 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5992374.69215 2098410.70315 37.7413977704887 -122.468977090726 (37.7413977704887, -122.468977090726)
101181 117473 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout 20 Tree 1 Private 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
101847 117472 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout 20 Tree 1 Private 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
164715 139060 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1455 Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     39 Width 0ft   5999670.4186 2113895.7324 37.7843346353185 -122.444863945857 (37.7843346353185, -122.444863945857)
127197 249899 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 3 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701)
171284 249897 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 5 Side Yard : Yard 17 Tree 1 Private 1     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.40479885070101 (37.8030148322229, -122.404798850701)
78277 98312 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 160 Stanford Heights Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5998064.7 2096544.4 37.7366004632858 -122.449168689734 (37.7366004632858, -122.449168689734)
160001 196024 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1670 Owen St 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   6013848.21751 2107498.5657599997 37.7675683801977 -122.39536504787701 (37.7675683801977, -122.395365047877)
173216 196023 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1670 Owen St 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 8ft   6013858.29957 2107482.27299 37.7675242045935 -122.395329033601 (37.7675242045935, -122.395329033601)
51068 201994 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251)
132662 201996 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968)
137250 201997 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013313.68951 2092516.98736 37.7264024081338 -122.39616384100201 (37.7264024081338, -122.396163841002)
157844 201995 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013319.20907 2092521.7003099998 37.726415656052104 -122.396145090149 (37.7264156560521, -122.396145090149)
164241 201993 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013314.351009999 2092488.44605 37.726324076294205 -122.396159554816 (37.7263240762942, -122.396159554816)
33120 249800 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 8 Front Yard : Yard 7 Tree 1 Private 1     16 Width 0ft   6010811.58408 2121055.18857 37.8046222939481 -122.406823966551 (37.8046222939481, -122.406823966551)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 91.335ms · Data source: data.sfgov.org