Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by XCoord

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
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            
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            
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            
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)
30532 119696 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 14 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
61692 119780 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 15 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
79566 119689 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 7 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)
84867 119767 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
85011 119690 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
86483 119684 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 2 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)
87621 119685 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
87630 119692 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
88222 119683 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 1 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)
90805 119770 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
92703 119766 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 1 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)
96316 119697 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 15 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
97979 119772 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
99317 119769 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 4 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)
100653 119693 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
101391 119774 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
103536 119694 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 12 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)
106450 119771 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x 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)
117272 119768 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
118707 119686 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
120366 119775 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 10 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)
120772 119778 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 13 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
120932 119687 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 5 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)
123532 119777 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
124714 119691 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 9 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)
139912 119688 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
140489 119773 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
141892 119779 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 14 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142187 119776 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142339 119695 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 13 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
23464 121867 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 382 18th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5990303.78145 2112825.7530799997 37.7808577673116 -122.477190674715 (37.7808577673116, -122.477190674715)
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)
177775 53540 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 308 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/1969 12:00:00 AM 24   Permit Number 6452 5994656.440219999 2113376.70713 37.782622110333904 -122.462172779062 (37.7826221103339, -122.462172779062)
29497 135665 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3790 California St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   5996326.409519999 2114621.95963 37.7861372526689 -122.45648551290199 (37.7861372526689, -122.456485512902)
161540 135664 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3790 California St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5996336.60886 2114624.27331 37.786144190959504 -122.45645039347099 (37.7861441909595, -122.456450393471)
134366 135663 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3790 California St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5996346.46825 2114626.15487 37.78614992323771 -122.456416418905 (37.7861499232377, -122.456416418905)
3856 246917 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5997637.485090001 2107521.28402 37.766715824697 -122.451437229753 (37.766715824697, -122.451437229753)
180467 246918 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 3ft   5997638.105140001 2107510.95773 37.7666875068428 -122.451434340243 (37.7666875068428, -122.451434340243)
495 248613 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442)
3855 248614 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5997650.5459 2107506.4452 37.7666758289672 -122.451390984496 (37.7666758289672, -122.451390984496)
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)
49096 212850 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 32 Malta Dr 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 3ft   5999489.821880001 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429)
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)
176864 135666 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3001 Divisadero St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 9ft   6000472.49775 2118651.8946700003 37.797439556256705 -122.442430617479 (37.7974395562567, -122.442430617479)
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)
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)
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)
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)
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)
123249 24282 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 300X Winding Way 20 Median : Cutout 11 Tree 1 DPW 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
180656 247225 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 754 Duboce Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6002109.5730099995 2108309.81574 37.7691360073432 -122.43602549030001 (37.7691360073432, -122.4360254903)
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)
51312 96980 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
87484 96979 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
106073 96984 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
139286 96978 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
141279 96981 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
186484 244409 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 15 Median : Cutout 11 Tree 1 DPW 2     15 Width 0ft   6005580.6462 2110260.99 37.7746900436181 -122.424158015373 (37.7746900436181, -122.424158015373)
153011 244408 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 14 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6005581.41 2110245.7143 37.7746481433715 -122.42415428662599 (37.7746481433715, -122.424154286626)
53575 244407 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 13 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6005584.4651 2110232.73 37.774612664125 -122.424142794808 (37.774612664125, -122.424142794808)
129623 244406 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   6005586.7565 2110217.4543 37.7745708501281 -122.42413378179899 (37.7745708501281, -122.424133781799)
161802 244405 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6005589.0478 2110200.651 37.774524841704704 -122.42412466048701 (37.7745248417047, -122.424124660487)
76412 244404 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6005594.3943 2110164.7531 37.7744265766299 -122.424103612435 (37.7744265766299, -122.424103612435)
64205 244403 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005596.6857 2110150.2412 37.7743868598384 -122.424094653801 (37.7743868598384, -122.424094653801)
147941 244402 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005599.7408 2110138.7844 37.774355574729796 -122.424083270702 (37.7743555747298, -122.424083270702)
65982 244266 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6005600.5046 2110125.0362 37.7743178686238 -122.42407965066499 (37.7743178686238, -122.424079650665)
116487 244265 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6005602.0322 2110112.8157 37.7742844003359 -122.42407349716999 (37.7742844003359, -122.42407349717)
136078 244264 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6005607.3787 2110087.6108 37.7742154956389 -122.42405320983299 (37.7742154956389, -122.424053209833)
46340 244263 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005610.4338 2110073.0988 37.7741758216851 -122.424041609468 (37.7741758216851, -122.424041609468)
157234 244262 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005612.7252 2110055.5318 37.7741277163216 -122.424032433594 (37.7741277163216, -122.424032433594)
90928 244261 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6005613.489 2110034.9096 37.7740711358709 -122.424028324662 (37.7740711358709, -122.424028324662)
157480 244260 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 202x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6005614.2528 2110021.9252 37.774035526971396 -122.42402475899401 (37.7740355269714, -122.424024758994)
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)
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)
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)
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)

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 86.858ms · Data source: data.sfgov.org