Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");