trees

2,365 rows where qSpecies_id = 31 sorted by TreeID

✎ 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)
162990 110079 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2751x Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5990053.53958 2111933.09723 37.7783922604051 -122.477991095219 (37.7783922604051, -122.477991095219) 11 6 2 55 26
128296 110096 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 19 DANVERS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999798.2 2105476.6 37.7612251228861 -122.443816792986 (37.7612251228861, -122.443816792986) 15 5 5 28862 3
165516 110458 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2471 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 5x5   6008273 2104056 37.7578042316996 -122.414405447195 (37.7578042316996, -122.414405447195) 2 4 7 28859 19
153912 110459 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2497 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 5x5   6008316 2103926 37.7574496968318 -122.414247537253 (37.7574496968318, -122.414247537253) 2 4 7 28859 19
118552 110612 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 15 MAGELLAN AVE   Sidewalk: Property side : Cutout Tree Private 2   05/12/2015 12:00:00 AM 3 3x3 Permit Number 775412 5994586 2101167 37.7490933856104 -122.461530994698 (37.7490933856104, -122.461530994698) 1 8 4 29491 40
169265 110630 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1050X MANDALAY LN 1 Unaccepted Street : Cutout Tree Private 2           5991857 2101850 37.7508112705894 -122.471017566011 (37.7508112705894, -122.471017566011) 1 8 4 29491 12
37402 110633 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 631 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6013429.5241 2113847.0849 37.7849766786955 -122.397258498892 (37.7849766786955, -122.397258498892) 6 2 9 28856 6
67105 110634 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 631 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013451.1173 2113865.5933 37.7850287006154 -122.397185091079 (37.7850287006154, -122.397185091079) 6 2 9 28856 6
46833 110635 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 631 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013464.4845 2113882.0453 37.7850746181572 -122.397139998491 (37.7850746181572, -122.397139998491) 6 2 9 28856 6
151229 110636 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 631 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013480.9365 2113896.4407 37.7851150604573 -122.397084089074 (37.7851150604573, -122.397084089074) 6 2 9 28856 6
82189 110674 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 34 Bonita St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 2.5x3   6006186.90221 2118494.21303 37.7973306546326 -122.422646045101 (37.7973306546326, -122.422646045101) 13 9 10 28858 32
52919 110675 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 34 Bonita St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 2.5x3   6006170.0244 2118492.14329 37.7973240194296 -122.422704299571 (37.7973240194296, -122.422704299571) 13 9 10 28858 32
26567 110786 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 410 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012080 2118442 37.7975180016372 -122.402250623365 (37.7975180016372, -122.402250623365) 3 1 10 308 23
152186 111049 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1820 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6001658.332 2112561.815 37.7807852863652 -122.437890897691 (37.7807852863652, -122.437890897691) 15 5 11 29490 41
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
163238 111056 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 623 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5993570.9875 2113459.71956 37.7827874825496 -122.46593398292 (37.7827874825496, -122.46593398292) 11 6 2 54 11
37774 111106 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199X Surrey St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6002254 2096173 37.7358194070146 -122.43465795136 (37.7358194070146, -122.43465795136) 2 7 5 63 7
166589 111683 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 915 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x7   6015271.38469 2104348.44266 37.7589978743768 -122.390222350301 (37.7589978743768, -122.390222350301) 10 3 8 28856 29
138840 111919 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 48 Toledo Way 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6001642.84207 2120043.14006 37.8013261877997 -122.43848065927 (37.8013261877997, -122.43848065927) 13 9 1 57 17
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
151300 112173 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 190 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010499.33864 2111330.08185 37.7779020131996 -122.407218562985 (37.7779020131996, -122.407218562985) 14 2 9 28853 34
23618 112386 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2200 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999398 2116386 37.7911567075357 -122.445985588475 (37.7911567075357, -122.445985588475) 13 6 1 29490 27
23318 112503 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 645 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5993489.26776 2113460.89025 37.7827859823771 -122.46621678157 (37.7827859823771, -122.46621678157) 11 6 2 54 11
18136 112514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1014 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5992342.97239 2113476.2606 37.7827619817135 -122.47018356399 (37.7827619817135, -122.47018356399) 11 6 2 54 11
89717 112625 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1811 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008061 2107870 37.7682646820652 -122.415408640275 (37.7682646820652, -122.415408640275) 8 4 7 28853 19
177161 112747 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1262 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008734.43896 2116668.83333 37.7924620074572 -122.413701706384 (37.7924620074572, -122.413701706384) 5 1 10 28857 21
106858 112787 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 913 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6015266.54568 2104367.00121 37.7590485637711 -122.390240382605 (37.7590485637711, -122.390240382605) 10 3 8 28856 29
179870 112877 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 300x FRANCONIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x2   6010100 2099291 37.7448230609493 -122.407750909418 (37.7448230609493, -122.407750909418) 2 7 7 28859 2
150640 113046 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6010572.94796 2106882.20336 37.76569328293 -122.40665039471 (37.76569328293, -122.40665039471) 8 4 8 28853 19
96327 113047 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6010575.33708 2106849.91364 37.7656047563669 -122.406639855538 (37.7656047563669, -122.406639855538) 8 4 8 28853 19
185430 113083 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 501x BURROWS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009864 2093047 37.7276651627155 -122.408126678641 (37.7276651627155, -122.408126678641) 10 3 7 309 28
28907 113443 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 742 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5994762.07163 2110522.43311 37.7747911175465 -122.461600336607 (37.7747911175465, -122.461600336607) 11 6 2 54 11
145175 113444 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 742 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5994761.5711 2110535.58365 37.7748271966325 -122.461603021673 (37.7748271966325, -122.461603021673) 11 6 2 54 11
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
157753 113837 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1731 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 9x6   6014502.91741 2096197.81168 37.7365753034961 -122.392310029303 (37.7365753034961, -122.392310029303) 10 3 8 58 1
152521 113838 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1774 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 15x6   6014313.29307 2096408.00557 37.7371419213669 -122.392980348878 (37.7371419213669, -122.392980348878) 10 3 8 58 1
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
139032 114306 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 900 STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997219 2107398 37.7663533458689 -122.452875791584 (37.7663533458689, -122.452875791584) 15 5 11 29492 9
14815 114434 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 576 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002952 2104864 37.7597224559637 -122.432865383548 (37.7597224559637, -122.432865383548) 2 4 5 28862 3
119499 114435 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 576 NOE ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2016 12:00:00 AM 3 3x3   6002952 2104864 37.7597224559637 -122.432865383548 (37.7597224559637, -122.432865383548) 2 4 5 28862 3
46660 115017 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4311 17TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6000722 2105756 37.7620449359843 -122.440641810954 (37.7620449359843, -122.440641810954) 15 5 5 28862 3
5992 115018 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4311 17TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6000722 2105756 37.7620449359843 -122.440641810954 (37.7620449359843, -122.440641810954) 15 5 5 28862 3
32785 115468 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 83 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5993932.33914 2114999.07157 37.7870349634341 -122.464795691681 (37.7870349634341, -122.464795691681) 11 6 1 54 11
149916 115484 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1924 20TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012266 2104770 37.7599882208521 -122.400646065117 (37.7599882208521, -122.400646065117) 10 3 8 28856 29
187152 115485 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1924 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6012271.36264 2104713.50287 37.7598333913054 -122.400623549336 (37.7598333913054, -122.400623549336) 10 3 8 28856 29
33876 115549 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412) 10 3 8 28856 29
38426 115550 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.390181786362 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
129944 115551 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.390190372193 (37.7585616474178, -122.390190372193) 10 3 8 28856 29
46247 115705 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 255 HARTFORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     28 3x3   6002752 2104417 37.7584837558361 -122.433525139011 (37.7584837558361, -122.433525139011) 2 4 5 28862 3
106747 115732 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 99 ORD ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   22 3x3   6000874 2105811 37.7622046070719 -122.440120047168 (37.7622046070719, -122.440120047168) 15 5 5 28862 3
123005 115739 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4077 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     24     6001800.02048091 2105829.59496805 37.7623083397269 -122.436918630667 (37.7623083397269, -122.436918630667) 15 5 5 28862 3
13822 115740 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4075 17TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 5x5   6001859 2105815 37.7622716175276 -122.436713598175 (37.7622716175276, -122.436713598175) 15 5 5 28862 3
146065 115741 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4075 17TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 5x5   6001859 2105815 37.7622716175276 -122.436713598175 (37.7622716175276, -122.436713598175) 15 5 5 28862 3
97054 11630 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 400X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   5991380.578 2094219.03 37.7298310098579 -122.472108899465 (37.7298310098579, -122.472108899465) 9 8 4 64 40
96267 116355 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 148 28TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777724 6004916 2099631 37.7454650539376 -122.425700412207 (37.7454650539376, -122.425700412207) 2 7 5 63 22
55 1166 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/23/2020 12:00:00 AM 25 3X3   5997012.91474 2087625.16187 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836) 9 7 6 28861 25
81176 116954 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 818 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2016 12:00:00 AM 3 3x3 Permit Number 778239 6001245 2101454 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352) 2 4 5 28862 22
59089 116955 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 818 Douglass St 1 Front Yard : Cutout Tree Private 2     6 3x3   6001245 2101454 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352) 2 4 5 28862 22
90710 117050 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1827 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 4x4   6001509.7164 2114739.434 37.7867560199397 -122.438561103054 (37.7867560199397, -122.438561103054) 13 6 1 29490 27
62898 117051 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1827 SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 4x4 Permit Number 778308 6001498 2114739 37.7867541617971 -122.438601607836 (37.7867541617971, -122.438601607836) 13 6 1 29490 27
125652 117152 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1478 Underwood Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6015252.32147994 2093260.25332261 37.7285509455903 -122.389513905896 (37.7285509455903, -122.389513905896) 10 3 8 58 1
134825 117445 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 403 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 778578 6009365.1 2121160.8 37.8048312347901 -122.411837150077 (37.8048312347901, -122.411837150077) 3 1 10 308 23
17803 117536 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 601 WALLER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002803 2108833 37.7706119122875 -122.433664364997 (37.7706119122875, -122.433664364997) 15 5 5 29492 9
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
161728 117578 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 701x CALIFORNIA ST 2 Sidewalk: Curb side : Pot Tree Private 2       3x3   6010911 2116555 37.7922714332447 -122.406162679671 (37.7922714332447, -122.406162679671) 5 1 10 28857 6
177374 117609 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1227 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     7 3x3   6009518.3962 2110117.1687 37.7745166910375 -122.410526330451 (37.7745166910375, -122.410526330451) 8 2 9 28853 34
108007 11876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
118544 11877 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
176701 11878 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          
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)          

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