2,365 rows where qSpecies_id = 31 sorted by Zip Codes

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes ▼ Neighborhoods (old)
154 119838 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 11 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
206 119799 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 7 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
225 119839 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 12 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
238 119796 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 4 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
344 119791 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 11 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
406 119837 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 10 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
428 119830 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 3 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
442 119718 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 11 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
470 119711 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 4 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
481 119782 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
1908 119794 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 2 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
2605 19985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100 STAIRWAY46 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 40                      
3373 119797 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 5 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
3417 119788 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 8 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
4213 251107 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X Quesada Ave 1 Median : Yard Tree DPW 1                              
4570 119828 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 1 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
5011 119790 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 10 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
6452 109163 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 12 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
6695 260396 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
7980 260398 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   10/20/2018 12:00:00 AM 3                        
8784 46303 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   3 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
8844 119789 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 9 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
8918 119708 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 1 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
9121 46285 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
9242 119783 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
9906 46304 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
10022 46302 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   5 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
10127 119793 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 1 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
10263 119836 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 9 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
11525 119754 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 9 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
12068 26637 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 400X Winfield St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 6 3X3                      
12246 119784 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 4 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
13324 119752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 7 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
14244 46291 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   4 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
14547 119749 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 4 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
15578 119832 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 5 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
15738 119781 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 1 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
18373 259350 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Goettingen St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
18433 260397 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/20/2018 12:00:00 AM 3                        
19858 109170 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 5 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
23251 119710 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
27032 119717 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 10 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
31673 119709 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
33254 119798 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 6 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
33483 119753 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 8 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
33825 119679 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 5 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
34450 119816 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 12 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
37614 119819 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
45367 119681 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 7 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
46034 109168 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 7 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
51199 119795 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 3 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
55145 119750 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 5 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
55922 109169 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 6 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
57589 119826 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 10 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
68996 119785 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 5 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
73186 119818 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
77310 119820 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 4 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
77972 119824 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 8 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
80215 119712 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 5 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
85012 119676 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
85844 119675 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 1 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
89957 119827 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 11 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
93874 109171 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 4 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
98216 119713 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 6 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
107729 109164 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 11 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
108512 119801 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 9 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
110263 119755 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 106x Octavia St Frontage West 10 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
116078 119786 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 6 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
123476 119800 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 8 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
126141 119803 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 11 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
127662 119677 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
129678 119716 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 9 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
134418 119719 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 12 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
139973 119829 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 2 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
149108 119747 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 2 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
149284 119680 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 6 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
150836 119682 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 8 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
156235 119817 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 1 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
161548 109167 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 8 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
165603 119792 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 12 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
166196 119736 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 1 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
173780 119823 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 7 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
175267 119821 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 5 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
178289 119822 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 6 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
178302 119833 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 6 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
178452 119834 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 7 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
180678 119831 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 4 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
187008 119825 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 9 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
189843 119701 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 3 Median : Cutout Tree DPW 1           2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
190598 119757 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 12 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
190843 119787 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 7 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
191150 119756 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 11 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
191279 119748 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 3 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
192783 119714 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 7 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
395 246548 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20x Octavia St 2 Median : Cutout Tree DPW 1     6 Width 6ft   6005741.17746 2109432.24964 37.7724235852138 -122.423543772638 (37.7724235852138, -122.423543772638) 7 9 11 28852 10
2305 251465 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 129 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008072 2112894 37.7820600122669 -122.415726368353 (37.7820600122669, -122.415726368353) 7 10 9 28852 36
2333 246547 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20x Octavia St 1 Median : Cutout Tree DPW 1     3 Width 4ft   6005744.74711 2109415.26549 37.7723771523117 -122.423530217156 (37.7723771523117, -122.423530217156) 7 9 11 28852 10
6138 244422 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100x Octavia St 2 Median : Cutout Tree DPW 1     5 Width 0ft   6005691.1562 2109690.8797 37.7731308974862 -122.423735193743 (37.7731308974862, -122.423735193743) 7 9 11 28852 10
6820 244317 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 5 Median : Cutout Tree DPW 1     6 Width 0ft   6005516.527 2110492.6418 37.7753224827652 -122.424396296997 (37.7753224827652, -122.424396296997) 7 9 11 28852 10
10966 109166 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 51x OCTAVIA ST 5 Median : Cutout Tree DPW 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);