2,365 rows where qSpecies_id = 31 sorted by PlotSize

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)
60 264971 Private 9 Ulmus parvifolia :: Chinese Elm 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
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)          
820 41547 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 244 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2000 12:00:00 AM     Permit Number 42070 6001730.08855162 2104417.99791196 37.7584284625233 -122.437059430993 (37.7584284625233, -122.437059430993) 2 4 5 28862 3
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)          
2080 51849 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4000 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14   Permit Number 48073 6003004.48334918 2104779.15411028 37.7594924661239 -122.432677808926 (37.7594924661239, -122.432677808926) 2 4 5 28862 3
2130 83476 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 674-680 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015406.08252 2105913.749 37.763303339101 -122.389865835643 (37.763303339101, -122.389865835643) 14 3 8 28856 29
2748 51918 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 374 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 9   Permit Number 48916 5999699.92432 2091688.24542 37.7233599872689 -122.443166369055 (37.7233599872689, -122.443166369055) 9 7 6 28861 25
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)          
3398 30348 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 420 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1956 12:00:00 AM 13   Permit Number 31 6012919.88824 2105064.35635 37.7608329059296 -122.398405220419 (37.7608329059296, -122.398405220419) 10 3 8 28856 29
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)          
4054 61321 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1493 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 2   Permit Number 21224 6011782.72959 2101393.64443 37.750690525464 -122.40208010572 (37.750690525464, -122.40208010572) 10 3 8 28856 29
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
4213 251107 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X Quesada Ave 1 Median : Yard Tree DPW 1                              
4429 97836 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 5 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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)          
4643 76181 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1200 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6009574.6956 2110252.7468 37.7748921128949 -122.410341153951 (37.7748921128949, -122.410341153951) 8 2 9 28853 34
4645 107053 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 450 Walnut St 4 Sidewalk: Curb side : Cutout Tree Private 2           5998625.9783 2115075.11894 37.7875132600186 -122.448562297399 (37.7875132600186, -122.448562297399) 13 6 1 54 31
4702 198610 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 456 Mission Bay Blvd South 10 Sidewalk: Curb side : Yard Tree Private 2     5     6016166.07078 2108644.55968 37.7708436706185 -122.387427776296 (37.7708436706185, -122.387427776296) 14 3 9 310 20
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)          
5574 259351 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 443 Goettingen St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3     6010386.58434 2092559.48475 37.7263557946777 -122.406285753959 (37.7263557946777, -122.406285753959) 10 3 7 309 28
6558 57073 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 958 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 17   Permit Number 14340 6015221.7654 2104138.81007 37.7584195158777 -122.390379311651 (37.7584195158777, -122.390379311651) 10 3 8 28856 29
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                        
7090 52720 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 710@ 20th ST Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2006 12:00:00 AM     Permit Number 48773 6002386.64959974 2104032.25895211 37.757406613771 -122.434761169877 (37.757406613771, -122.434761169877) 2 4 5 28862 3
7235 74494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2233 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6010764.33667 2106446.7054 37.7645082103165 -122.405957737757 (37.7645082103165, -122.405957737757) 8 4 8 28859 19
7295 100582 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
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                        
8503 80188 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1435 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6008710.7243 2109332.6568 37.7723172927739 -122.413264744885 (37.7723172927739, -122.413264744885) 8 2 9 28853 34
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)          
9031 74649 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2233 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6010746.42629 2106444.22464 37.7645003969982 -122.406019510419 (37.7645003969982, -122.406019510419) 8 4 8 28859 19
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)          
10535 258146 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1048 Folsom St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6010642.12041 2111257.36423 37.7777103373451 -122.406719502289 (37.7777103373451, -122.406719502289) 14 2 9 28853 34
10797 49734 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2940REVISED Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2005 12:00:00 AM     Permit Number 46534 6008347.91771108 2101298.08089598 37.7502358181357 -122.413951255275 (37.7502358181357, -122.413951255275) 2 4 7 28859 19
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)          
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)          
12480 47528 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 277 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/2003 12:00:00 AM     Permit Number 45400 6004720.64686455 2100142.45310534 37.7468583456276 -122.426412322279 (37.7468583456276, -122.426412322279) 2 7 5 63 22
12506 105953 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 54 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2014 12:00:00 AM 4   Permit Number 771133 5994277.8794 2115232.96253 37.7876970801078 -122.463617190077 (37.7876970801078, -122.463617190077) 11 6 1 54 11
12738 72412 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3485 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997617.1015 2116066.53919 37.7901776988858 -122.452124350462 (37.7901776988858, -122.452124350462) 11 6 1 54 31
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)          
13803 74944 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2233 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6010701.03805 2106443.01503 37.7644945370101 -122.406176411522 (37.7644945370101, -122.406176411522) 8 4 8 28859 19
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)          
15262 73760 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3485 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997597.70095 2116065.74811 37.7901744154595 -122.452191417426 (37.7901744154595, -122.452191417426) 11 6 1 54 31
15550 32997 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013196.81609 2113721.08426 37.784617751847 -122.398054757315 (37.784617751847, -122.398054757315) 6 2 9 28853 6
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)          
15809 54753 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4140-4142 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1972 12:00:00 AM     Permit Number 10601 6002268.53854801 2101815.27696084 37.7513126050411 -122.435011090977 (37.7513126050411, -122.435011090977) 2 4 5 28862 22
16163 32994 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013107.84928 2113632.60044 37.7843698402516 -122.398356344087 (37.7843698402516, -122.398356344087) 6 2 9 28853 6
16699 97434 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380x Newcomb Ave 5 Median : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3     6016360.63733 2094893.94179 37.7330981190079 -122.385796183605 (37.7330981190079, -122.385796183605) 10 3 8 58 1
16748 96876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2100X San Jose Ave 8 Sidewalk: Property side : Yard Tree Private 2           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923) 9 7 6 28861 25
17144 48943 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1344 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/2005 12:00:00 AM     Permit Number 46130 6010846.48741491 2102064.8294817 37.7524811515419 -122.40536498901 (37.7524811515419, -122.40536498901) 10 4 8 28859 19
17960 81238 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1425 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6008758.1555 2109381.0971 37.7724529612773 -122.41310410127 (37.7724529612773, -122.41310410127) 8 2 9 28853 34
18245 66733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1133 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/06/1991 12:00:00 AM     Permit Number 29980 6008997 2116859 37.7929988993441 -122.41280668477 (37.7929988993441, -122.41280668477) 5 1 10 28857 21
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                        
20199 46505 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 165 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44676 6009030.30482136 2110979.07994252 37.7768559207247 -122.412275670972 (37.7768559207247, -122.412275670972) 8 2 9 28853 34
21744 44267 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 315 Montcalm St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/22/2001 12:00:00 AM     Permit Number 43696 6009681.81388664 2099574.48898013 37.7455780401568 -122.409216925278 (37.7455780401568, -122.409216925278) 2 7 7 28859 2
22908 32995 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 4   Permit Number 37299 6013130.33001 2113657.26593 37.7844388182424 -122.398280299215 (37.7844388182424, -122.398280299215) 6 2 9 28853 6
23232 32533 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 70 Porter St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM     Permit Number 37034 6006985.4956632 2095516.38069521 37.7342839493681 -122.418252734879 (37.7342839493681, -122.418252734879) 2 7 7 28859 2
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)          
23291 41906 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 60 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42269 6003134.36765804 2107953.23072837 37.7682150777502 -122.432455314129 (37.7682150777502, -122.432455314129) 15 5 5 28862 3
24002 198501 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900x Carolina St 13 Median : Yard Tree DPW 1     15     6012463.03254 2103576.30053 37.7567215715659 -122.399880796574 (37.7567215715659, -122.399880796574) 10 3 8 28856 29
24709 123166 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 579 10th Ave 1 Sidewalk: Property side : Yard Tree Private 2     6     5992807.48236 2111535.86844 37.7774610360275 -122.468435352622 (37.7774610360275, -122.468435352622) 11 6 2 54 11
26267 198618 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 454 Mission Bay Blvd South 7 Sidewalk: Curb side : Yard Tree Private 2     5     6015853.85549 2108626.75005 37.770777472425 -122.388506502268 (37.770777472425, -122.388506502268) 14 3 9 310 20
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)          
28789 31076 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 8   Permit Number 34816 6006020.69113 2107294.38947 37.7665693044606 -122.422424975532 (37.7665693044606, -122.422424975532) 8 4 5 28853 19
30193 31614 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2146 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1995 12:00:00 AM 12   Permit Number 35135 6001571.0697 2119772.3198 37.8005785040659 -122.43870960599 (37.8005785040659, -122.43870960599) 13 9 1 57 17
30218 97985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     16     6015230.10587 2104016.74085 37.7580848025885 -122.390341937645 (37.7580848025885, -122.390341937645) 10 3 8 28856 29
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)          
33215 198644 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 421 Mission Bay Blvd North 3 Sidewalk: Curb side : Yard Tree Private 2     7     6016180.11848 2108766.38719 37.7711789603624 -122.387387684488 (37.7711789603624, -122.387387684488) 14 3 9 310 20
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)          
33488 198652 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 421 Mission Bay Blvd North 11 Sidewalk: Curb side : Yard Tree Private 2     8     6016352.81609 2108774.30794 37.7712102720761 -122.386790863815 (37.7712102720761, -122.386790863815) 14 3 9 310 20
33627 39478 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2856 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 777203 5999897.32915775 2117456.37972289 37.7941241886563 -122.44433488583 (37.7941241886563, -122.44433488583) 13 9 1 57 27
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)          
34182 198607 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 456 Mission Bay Blvd South 7 Sidewalk: Curb side : Yard Tree Private 2     7     6016227.74089 2108648.22285 37.7708571442621 -122.387214711603 (37.7708571442621, -122.387214711603) 14 3 9 310 20
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)          
34763 121610 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 22nd St 1 Unaccepted Street : Yard Tree Private 2     11     6012951.69217 2103797.77434 37.7573569210097 -122.398206359645 (37.7573569210097, -122.398206359645) 10 3 8 28856 29
35624 38383 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3815-3817 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769372 6003483 2105926 37.762668556024 -122.431104719068 (37.762668556024, -122.431104719068) 15 4 5 28862 3
36432 45653 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2001 12:00:00 AM     Permit Number 44350 6000345.05114977 2116113.5186525 37.790462578374 -122.442689257593 (37.790462578374, -122.442689257593) 13 6 1 29490 27
37218 256504 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3579 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997147.04528 2116001.57364 37.7899723836566 -122.453746006699 (37.7899723836566, -122.453746006699) 11 6 1 54 31
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)          
37815 36939 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 106 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 14   Permit Number 39578 5994917.29896 2114783.54641 37.7864999276851 -122.461372345087 (37.7864999276851, -122.461372345087) 11 6 1 54 11
38280 66565 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 195 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/1994 12:00:00 AM     Permit Number 29754 6004459.66256991 2092267.48419115 37.725220702439 -122.426754065425 (37.725220702439, -122.426754065425) 9 7 6 28861 5
39514 108244 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 150 Conrad St 1 Back Yard : Cutout Tree Private 2     20     6001768.8 2096480 37.7366348009068 -122.436357440328 (37.7366348009068, -122.436357440328) 2 7 5 63 7

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