trees

2,365 rows where qSpecies_id = 31 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

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)
42968 100580 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
43704 88338 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 315 Paris St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51325 6002541 2091742 37.7236691751532 -122.433349150158 (37.7236691751532, -122.433349150158) 9 7 6 28861 5
43816 103418 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 700X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015432.6 2105817 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
44866 50808 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 499 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2006 12:00:00 AM     Permit Number 47332 6008981.38895406 2105919.05287132 37.7629595191577 -122.412087198232 (37.7629595191577, -122.412087198232) 8 4 7 28859 19
44900 55226 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/1973 12:00:00 AM   3x3 Permit Number 51714 6015214.86332087 2104389.48828919 37.7591074416555 -122.390420697382 (37.7591074416555, -122.390420697382) 10 3 8 28856 29
45215 98464 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1999X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005154.5 2116787.4 37.7925858789052 -122.426096853469 (37.7925858789052, -122.426096853469) 13 9 1 28858 27
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)          
47416 255466 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301X Newcomb Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1       15x200   6016676.72369 2094975.37763 37.7333392118181 -122.384709049297 (37.7333392118181, -122.384709049297) 10 3 8 58 1
47966 173668 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1709 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014587 2096103 37.7363196386473 -122.392012689283 (37.7363196386473, -122.392012689283) 10 3 8 58 1
49994 107991 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4410x 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000358 2102265 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
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)          
51352 87967 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 901 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51002 6000425.8 2112036.7 37.7792732897886 -122.442117107328 (37.7792732897886, -122.442117107328) 15 5 1 29490 16
51709 173899 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
54430 33935 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1932 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1997 12:00:00 AM     Permit Number 43529 6003424.24641356 2115332.27843331 37.7884925418667 -122.431979635032 (37.7884925418667, -122.431979635032) 13 9 1 29490 27
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)          
55359 44113 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1201 Treat Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.412744337506 (37.7509254812099, -122.412744337506) 2 4 7 28859 19
55545 114012 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 952 CAPP ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6007364 2101732 37.7513719527851 -122.417384460989 (37.7513719527851, -122.417384460989) 2 4 7 28859 19
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)          
56170 46874 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1360 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44937 6008040.39641169 2117081.79459414 37.7935568987708 -122.416132380604 (37.7935568987708, -122.416132380604) 5 1 10 28858 21
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)          
57704 111050 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1820 EDDY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001661 2112577 37.780827132241 -122.437882755751 (37.780827132241, -122.437882755751) 15 5 11 29490 41
58093 48676 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4930 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/06/2006 12:00:00 AM     Permit Number 48856 5997717.95296797 2105658.6000715 37.7616059742438 -122.451024572529 (37.7616059742438, -122.451024572529) 15 5 11 29492 9
58417 31777 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2126 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35251 5989451.98537783 2098364.25532499 37.7411009369348 -122.479079284327 (37.7411009369348, -122.479079284327) 1 8 3 29491 35
59353 45650 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 1 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
62676 32534 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 70 Porter St 3 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
65768 255467 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301X Newcomb Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6016676.72369 2094975.37763 37.7333392118181 -122.384709049297 (37.7333392118181, -122.384709049297) 10 3 8 58 1
67332 108237 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 131 RUSS ST 10 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010302 2111707 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
68264 173898 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
68384 97840 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 9 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
68907 98928 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 112 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005385 2103055 37.7548930594212 -122.424322167644 (37.7548930594212, -122.424322167644) 2 4 5 28859 19
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)          
69027 45652 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 3 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
69505 46504 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 165 08th St 3 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
69960 97850 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 19 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
72061 255051 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199x 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008753 2110574 37.7757281025158 -122.413206304146 (37.7757281025158, -122.413206304146) 8 2 9 28853 34
72945 104450 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2490X Folsom St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
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)          
73437 51550 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1247 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2005 12:00:00 AM     Permit Number 47849 5999742.39026173 2108428.18336747 37.7693262500826 -122.444221920277 (37.7693262500826, -122.444221920277) 15 5 11 29492 9
73546 53738 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 660-662 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1972 12:00:00 AM   4x4 Permit Number 9418 6002127 2102089 37.7520561456392 -122.435520126196 (37.7520561456392, -122.435520126196) 2 4 5 28862 22
74389 104447 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2490X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
75248 49733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2940REVISED Folsom St 2 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
75735 54877 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 317 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1972 12:00:00 AM   4x3 Permit Number 10739 6005042.77490786 2109859.41873684 37.7735570424684 -122.425990029724 (37.7735570424684, -122.425990029724) 7 9 11 28852 10
75960 45651 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 2 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
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)          
79111 50430 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 53REVISED Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2004 12:00:00 AM     Permit Number 47083 5998656.22086914 2105364.79387751 37.7608529276064 -122.447758347691 (37.7608529276064, -122.447758347691) 15 5 11 29492 12
79389 97848 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 17 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
79565 92521 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1350 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6009005 2109688 37.773309499002 -122.412271934387 (37.773309499002, -122.412271934387) 8 2 9 28853 34
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)          
81332 52332 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 20 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48483 5995128.56023296 2096158.11276055 37.7353714395789 -122.459292150941 (37.7353714395789, -122.459292150941) 9 7 4 59 40
81839 87308 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2895 25th St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50315 6010124.3 2101560.9 37.7510570681062 -122.407826914654 (37.7510570681062, -122.407826914654) 2 4 7 28859 19
83460 108482 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 195x 09TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993013.6 2114237 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
84560 110034 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2690 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2           6008245.7 2102789.4 37.7543249025472 -122.414410241803 (37.7543249025472, -122.414410241803) 2 4 7 28859 19
84706 103143 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2620 Buchanan St 1 Front Yard : Yard Tree Private 2       3x3   6003626 2117322 37.7939672460834 -122.431423695166 (37.7939672460834, -122.431423695166) 13 9 1 29490 27
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)          
85066 47527 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 277 27th St 1 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
85126 34988 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 25 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2005 12:00:00 AM     Permit Number 47856 6004110.40789501 2102908.72400582 37.7544193649252 -122.428719637491 (37.7544193649252, -122.428719637491) 2 4 5 28862 22
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)          
85971 120895 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1700X 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005798 2107491 37.7670965853784 -122.423209202949 (37.7670965853784, -122.423209202949) 8 4 5 28853 19
86168 44116 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1201 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.412744337506 (37.7509254812099, -122.412744337506) 2 4 7 28859 19
86900 103275 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2800X Pine St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000456.3 2114876.5 37.7870723881298 -122.442215507279 (37.7870723881298, -122.442215507279) 13 6 1 29490 27
87095 88329 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 120 London St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51317 6002940 2092960 37.7270361584814 -122.432056812936 (37.7270361584814, -122.432056812936) 9 7 6 28861 5
88739 87305 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2895 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50315 6010124.3 2101560.9 37.7510570681062 -122.407826914654 (37.7510570681062, -122.407826914654) 2 4 7 28859 19
89743 108480 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 195x 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993013.6 2114237 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
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)          
91488 100581 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
92189 36145 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2201 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1998 12:00:00 AM     Permit Number 39234 6010900.97776393 2106452.95281145 37.7645330054499 -122.405485571016 (37.7645330054499, -122.405485571016) 8 4 8 28859 19
92198 254243 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 499x Benton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006980 2095456 37.7341178478927 -122.418267455605 (37.7341178478927, -122.418267455605) 2 7 7 28859 2
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)          
95745 251581 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 600 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984701 2111577 37.7771023963007 -122.496480968893 (37.7771023963007, -122.496480968893) 11 6 2 55 26
95943 108135 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2055 FOLSOM ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008137.2 2106486.4 37.7644699210537 -122.415047125765 (37.7644699210537, -122.415047125765) 8 4 7 28859 19
96419 81863 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 880 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50491 5994900.59315185 2093952.33613362 37.7293018063197 -122.459920577502 (37.7293018063197, -122.459920577502) 9 7 4 28861 40
97041 101139 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 169 Buena Vista Ter 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001425 2107346.2 37.7664512423305 -122.438324340152 (37.7664512423305, -122.438324340152) 15 5 5 28862 3
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)          
99529 103588 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 101X Laguna St 1 Front Yard : Yard Tree Private 2           6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
100819 97270 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3099 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2011 12:00:00 AM   3x3 Permit Number 768129 5999976 2116041.4 37.7902435145098 -122.443960962963 (37.7902435145098, -122.443960962963) 13 6 1 29490 27
102228 97852 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 21 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
102300 113801 Private 9 Ulmus parvifolia :: Chinese Elm 31 806 SHOTWELL ST 3 Front Yard : Yard Tree Private 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
102563 99187 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 198X Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000112.3 2105690.3 37.761829801242 -122.442745803115 (37.761829801242, -122.442745803115) 15 5 5 28862 3
102627 117577 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 701x CALIFORNIA ST 1 Sidewalk: Curb side : Pot Tree Private 2       3x3   6010911 2116555 37.7922714332447 -122.406162679671 (37.7922714332447, -122.406162679671) 5 1 10 28857 6
103199 100626 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
105246 36930 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 395 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2002 12:00:00 AM     Permit Number 45859 6001519.66406839 2103540.62826183 37.7560074548941 -122.437724334797 (37.7560074548941, -122.437724334797) 2 4 5 28862 3
105912 99790 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4140-4124 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Most likely planted when tree 1 was planted/permitted. 6002271 2101809 37.7512955097612 -122.435002130134 (37.7512955097612, -122.435002130134) 2 4 5 28862 22
107227 86696 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 248 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2007 12:00:00 AM     Permit Number 49695 6006131 2101708.4 37.7512377023769 -122.421646649176 (37.7512377023769, -122.421646649176) 2 4 5 28859 19
107524 97834 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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)          
109774 82620 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 262 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52220 6007782.82233026 2105835.06197207 37.7626615773847 -122.416226690034 (37.7626615773847, -122.416226690034) 8 4 7 28859 19
109904 40800 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 167 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1999 12:00:00 AM     Permit Number 41749 5995317.58858632 2087395.72139247 37.7113228744096 -122.458004690935 (37.7113228744096, -122.458004690935) 9 8 6 28861 24
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)          
111191 87288 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 131 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2007 12:00:00 AM   3x3 Permit Number 50304 5998096 2105951 37.7624304670172 -122.449738139948 (37.7624304670172, -122.449738139948) 15 5 11 29492 9
114039 44114 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1201 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.412744337506 (37.7509254812099, -122.412744337506) 2 4 7 28859 19
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)          
116688 40378 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 211 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/1999 12:00:00 AM     Permit Number 41491 6005458.18007856 2102476.17721451 37.7533078785176 -122.424027930453 (37.7533078785176, -122.424027930453) 2 4 5 28859 19
116748 45798 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 880 Clipper Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2001 12:00:00 AM     Permit Number 44433 5999675.79411068 2100284.35240189 37.7469614974882 -122.443867085897 (37.7469614974882, -122.443867085897) 2 4 5 63 22
117636 51892 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1135 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48104 6004381.23162594 2089955.54800101 37.7188681982632 -122.42686061692 (37.7188681982632, -122.42686061692) 9 7 6 28861 5
118194 98271 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
119476 98272 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
120641 100077 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 260 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005310 2109942 37.7737988894613 -122.425071534475 (37.7737988894613, -122.425071534475) 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)
);