Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
1982 | 1982 | 118349 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 3 | ||||||||
2168 | 2168 | 118346 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 3 | ||||||||
2766 | 2766 | 118353 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 3 | ||||||||
3111 | 3111 | 118355 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 3 | ||||||||
3394 | 3394 | 118348 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 3 | ||||||||
4215 | 4215 | 118354 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 3 | ||||||||
4374 | 4374 | 118351 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 3 | ||||||||
5429 | 5429 | 118350 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 3 | ||||||||
5643 | 5643 | 118347 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:39:00 AM | 3 | ||||||||
5661 | 5661 | 118352 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 3 | ||||||||
9748 | 9748 | 173655 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | ||||||||||
10102 | 10102 | 121489 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2 Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | |||||||||
14379 | 14379 | 48480 | Permitted Site 1 | Tree(s) :: 17 | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
81045 | 81045 | 109169 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
83700 | 83700 | 109168 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
97204 | 97204 | 109171 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
99403 | 99403 | 109164 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
116938 | 116938 | 109163 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
121401 | 121401 | 109167 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
126070 | 126070 | 109170 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
127400 | 127400 | 119700 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
138316 | 138316 | 119699 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
144933 | 144933 | 119701 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
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) | |||||
84832 | 84832 | 119681 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
90750 | 90750 | 119698 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2x Octavia St Frontage East | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
92481 | 92481 | 119675 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
93922 | 93922 | 119676 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
105805 | 105805 | 119677 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
110275 | 110275 | 119680 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
113138 | 113138 | 119682 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
125886 | 125886 | 119679 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1233 | 1233 | 119757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1235 | 1235 | 119756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
99951 | 99951 | 119755 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106x Octavia St Frontage West | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
91459 | 91459 | 119712 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
101446 | 101446 | 119713 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
103389 | 103389 | 119708 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
108290 | 108290 | 119716 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
110953 | 110953 | 119719 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
122353 | 122353 | 119718 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
124457 | 124457 | 119717 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
128093 | 128093 | 119709 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
128531 | 128531 | 119710 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
141876 | 141876 | 119711 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
145232 | 145232 | 119714 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) |
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");