2,365 rows where qSpecies_id = 31 sorted by Fire Prevention Districts

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)          
3772 215475 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993086.32041 2105916.03813 37.7620465797188 -122.467062084267 (37.7620465797188, -122.467062084267) 1 8 4 56 12
4061 46914 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44969 5993172.81345795 2105910.62938376 37.7620367208125 -122.466762547601 (37.7620367208125, -122.466762547601) 1 8 4 56 12
6913 215496 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 69 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993975.72153 2097357.94979 37.7385995461283 -122.463364953343 (37.7385995461283, -122.463364953343) 1 8 4 59 40
9179 215530 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994021.33126 2097709.05499 37.7395662211057 -122.463232727835 (37.7395662211057, -122.463232727835) 1 8 4 59 40
16709 215479 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 85 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992627.2877 2096233.38868 37.7354340044744 -122.467945378584 (37.7354340044744, -122.467945378584) 1 8 4 59 40
19733 215491 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 45 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5993998.37881 2097545.6525 37.7391162363258 -122.463300232728 (37.7391162363258, -122.463300232728) 1 8 4 59 40

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)
);