trees
2,365 rows where qSpecies_id = 31 sorted by SiteOrder descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
75473 | 244305 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.7753208695982 | -122.424177304818 | (37.7753208695982, -122.424177304818) | 7 | 9 | 11 | 28852 | 10 | |||
78440 | 17954 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
89346 | 198579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014752.73718 | 2114197.75689 | 37.7860131219458 | -122.392705107773 | (37.7860131219458, -122.392705107773) | 6 | 2 | 9 | 28855 | 6 | |||
91285 | 180538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010266.12531 | 2092269.81 | 37.7255536693496 | -122.406681772069 | (37.7255536693496, -122.406681772069) | 10 | 3 | 7 | 309 | 28 | |||
93167 | 91037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.406498774175 | (37.7776845332645, -122.406498774175) | 14 | 2 | 9 | 28853 | 34 | ||
100227 | 244327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.423804755705 | (37.773436531636, -122.423804755705) | 7 | 9 | 11 | 28852 | 10 | |||
103899 | 246541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.7724418486558 | -122.423755901126 | (37.7724418486558, -122.423755901126) | 7 | 9 | 11 | 28852 | 10 | |||
109613 | 198479 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015200.24285 | 2104674.66991 | 37.759889678091 | -122.390491189139 | (37.759889678091, -122.390491189139) | 10 | 3 | 8 | 28856 | 29 | |||
109695 | 198488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6015206.153 | 2104497.93944 | 37.75940474205 | -122.390458399858 | (37.75940474205, -122.390458399858) | 10 | 3 | 8 | 28856 | 29 | |||
119811 | 16424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.385712405803 | (37.7330411346315, -122.385712405803) | 10 | 3 | 8 | 58 | 1 | |||
122519 | 137017 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700 Pacific Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001093.24038 | 2116921.57925 | 37.79272392512 | -122.440158546893 | (37.79272392512, -122.440158546893) | 13 | 6 | 1 | 29490 | 27 | |||
124594 | 198569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014782.21142 | 2114125.62722 | 37.7858167073117 | -122.392598086644 | (37.7858167073117, -122.392598086644) | 6 | 2 | 9 | 28855 | 6 | |||
125359 | 17583 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003749.15172 | 2090342.65671 | 37.7198953544779 | -122.429073052804 | (37.7198953544779, -122.429073052804) | 9 | 7 | 6 | 28861 | 5 | |||
127051 | 244478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | 7 | 9 | 11 | 28852 | 10 | |||
131987 | 254722 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
132398 | 198439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015495.11625 | 2106291.74793 | 37.7643461794683 | -122.389584295684 | (37.7643461794683, -122.389584295684) | 14 | 3 | 9 | 310 | 29 | |||
137883 | 31072 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
142693 | 244455 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | 7 | 9 | 11 | 28852 | 10 | |||
148133 | 242483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008307.6947 | 2102932.59061 | 37.7547215539608 | -122.414205977849 | (37.7547215539608, -122.414205977849) | 2 | 4 | 7 | 28859 | 19 | |||
152559 | 97838 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
162776 | 141760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003934.4308 | 2113424.6033 | 37.7832834553568 | -122.430078335144 | (37.7832834553568, -122.430078335144) | 7 | 9 | 11 | 29490 | 41 | |||
163066 | 108234 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
166035 | 244360 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | 7 | 9 | 11 | 28852 | 10 | |||
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) | ||||||||||
178017 | 16444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
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) | ||||||||||
180006 | 32993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | 6 | 2 | 9 | 28853 | 6 | |
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) | ||||||||||
191242 | 200601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016439.2859 | 2094833.558 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | 10 | 3 | 8 | 58 | 1 | |||
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) | ||||||||||
21448 | 215545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993953.28384 | 2097231.84575 | 37.7382520031164 | -122.463433382759 | (37.7382520031164, -122.463433382759) | 1 | 8 | 4 | 59 | 40 | |||
22198 | 14869 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1399 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | 15 | 5 | 11 | 29492 | 41 | ||
26388 | 244359 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.424374111287 | (37.7752229798737, -122.424374111287) | 7 | 9 | 11 | 28852 | 10 | |||
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) | ||||||||||
40654 | 31073 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
41761 | 242738 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000793.83368 | 2105649.34692 | 37.7617561832258 | -122.440385717444 | (37.7617561832258, -122.440385717444) | 15 | 5 | 5 | 28862 | 3 | |||
43059 | 244376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | 7 | 9 | 11 | 28852 | 10 | |||
46315 | 17923 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
51789 | 198487 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6015204.943 | 2104516.59795 | 37.7594559071887 | -122.390463888397 | (37.7594559071887, -122.390463888397) | 10 | 3 | 8 | 28856 | 29 | |||
53797 | 200600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | 10 | 3 | 8 | 58 | 1 | |||
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) | |||||||||
67758 | 242502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008245.3225 | 2103001.91157 | 37.7549083899243 | -122.414426583341 | (37.7549083899243, -122.414426583341) | 2 | 4 | 7 | 28859 | 19 | |||
68160 | 201911 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.7283501238417 | -122.394511693764 | (37.7283501238417, -122.394511693764) | 10 | 3 | 8 | 58 | 1 | |||
70618 | 198478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015196.41735 | 2104702.38206 | 37.7599655574783 | -122.390506356185 | (37.7599655574783, -122.390506356185) | 10 | 3 | 8 | 28856 | 29 | |||
71414 | 17582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.429028371762 | (37.7199031291015, -122.429028371762) | 9 | 7 | 6 | 28861 | 5 | |||
74412 | 244259 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) | 7 | 9 | 11 | 28852 | 10 | |||
81046 | 198432 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010814.0242 | 2106448.53894 | 37.7645160236153 | -122.405786010411 | (37.7645160236153, -122.405786010411) | 8 | 4 | 8 | 28859 | 19 | |||
81285 | 244426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.7733541831734 | -122.423776541571 | (37.7733541831734, -122.423776541571) | 7 | 9 | 11 | 28852 | 10 | |||
81626 | 17813 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1900X Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 4 | 3x3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | 13 | 9 | 11 | 28858 | 27 | ||
83145 | 105880 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131X RUSS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6010355 | 2111553 | 37.7785060152737 | -122.407733605583 | (37.7785060152737, -122.407733605583) | 14 | 2 | 9 | 28853 | 34 | |||
87801 | 244358 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | 7 | 9 | 11 | 28852 | 10 | |||
90759 | 32989 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.33259 | 37.7843240827368 | -122.398422883105 | (37.7843240827368, -122.398422883105) | 6 | 2 | 9 | 28853 | 6 | |
93406 | 198655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014030.31136 | 2107306.63823 | 37.7670515155374 | -122.3947217619 | (37.7670515155374, -122.3947217619) | 14 | 3 | 9 | 310 | 20 | |||
95950 | 198692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.7332997702709 | -122.384585575986 | (37.7332997702709, -122.384585575986) | 10 | 3 | 8 | 58 | 1 | |||
97154 | 70472 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
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) | ||||||||||
98633 | 198578 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014761.29071 | 2114189.12116 | 37.7859898852611 | -122.392674910313 | (37.7859898852611, -122.392674910313) | 6 | 2 | 9 | 28855 | 6 | |||
99175 | 198497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015478.44281 | 2104579.86448 | 37.7596447917884 | -122.389522401658 | (37.7596447917884, -122.389522401658) | 10 | 3 | 8 | 28856 | 29 | |||
100699 | 246540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | 7 | 9 | 11 | 28852 | 10 | |||
101944 | 7633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
106947 | 242557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008209.56252 | 2104759.13269 | 37.7597313092745 | -122.414674599275 | (37.7597313092745, -122.414674599275) | 2 | 4 | 7 | 28859 | 19 | |||
107318 | 198468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015390.71439 | 2105768.72163 | 37.7629042730221 | -122.389908858318 | (37.7629042730221, -122.389908858318) | 14 | 3 | 8 | 28856 | 29 | |||
110000 | 91036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | 14 | 2 | 9 | 28853 | 34 | ||
114018 | 254721 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
114716 | 198586 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013678.51918 | 2107141.48068 | 37.7665784640576 | -122.39592699106 | (37.7665784640576, -122.39592699106) | 14 | 3 | 8 | 28856 | 20 | |
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) | ||||||||||
120435 | 198647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6016245.34642 | 2108770.39329 | 37.7711935725654 | -122.387162335966 | (37.7711935725654, -122.387162335966) | 14 | 3 | 9 | 310 | 20 | ||||
121072 | 141753 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003977.6484 | 2113242.1747 | 37.7827849995584 | -122.429915802437 | (37.7827849995584, -122.429915802437) | 7 | 9 | 11 | 29490 | 41 | |||
121185 | 198680 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6010306.35372 | 2111595.60808 | 37.7786202837256 | -122.407904897704 | (37.7786202837256, -122.407904897704) | 14 | 2 | 9 | 28853 | 34 | |||
123455 | 18529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
127822 | 16443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
137869 | 16437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1299X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | |||
142901 | 198568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014772.61549 | 2114134.95579 | 37.7858417885051 | -122.392631938935 | (37.7858417885051, -122.392631938935) | 6 | 2 | 9 | 28855 | 6 | |||
143338 | 244477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | 7 | 9 | 11 | 28852 | 10 | |||
146614 | 198458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014912.11479 | 2106274.08898 | 37.7642653483915 | -122.391599516314 | (37.7642653483915, -122.391599516314) | 14 | 3 | 9 | 310 | 29 | |||
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) | ||||||||||
151442 | 215510 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994019.70982 | 2096325.72526 | 37.73576784809 | -122.463137987822 | (37.73576784809, -122.463137987822) | 9 | 8 | 4 | 59 | 40 | |||
163757 | 198498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6016508.17513 | 2102448.92255 | 37.753850715249 | -122.385812507548 | (37.753850715249, -122.385812507548) | 10 | 3 | 8 | 28856 | 29 | |||
166520 | 198606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6016250.47578 | 2108648.85468 | 37.7708601381228 | -122.387136114449 | (37.7708601381228, -122.387136114449) | 14 | 3 | 9 | 310 | 20 | ||||
166672 | 137052 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008525.03986 | 2116714.30677 | 37.7925751052991 | -122.414429454859 | (37.7925751052991, -122.414429454859) | 5 | 1 | 10 | 28858 | 21 | |||
172832 | 16423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016393.65878 | 2094869.65123 | 37.7330332492347 | -122.385680326224 | (37.7330332492347, -122.385680326224) | 10 | 3 | 8 | 58 | 1 | |||
174974 | 97837 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | ||||
176412 | 137024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003051.10397 | 2117478.36483 | 37.7943639845568 | -122.433424069968 | (37.7943639845568, -122.433424069968) | 13 | 9 | 1 | 29490 | 27 | |||
177497 | 141759 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003937.2446 | 2113390.8375 | 37.7831909022721 | -122.430066191 | (37.7831909022721, -122.430066191) | 7 | 9 | 11 | 29490 | 41 | |||
177675 | 198632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015782.37645 | 2108741.7224 | 37.7710891999363 | -122.388761779325 | (37.7710891999363, -122.388761779325) | 14 | 3 | 9 | 310 | 20 | ||||
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) | ||||||||||
180875 | 242482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008309.34886 | 2102910.2805 | 37.7546603883701 | -122.414198678945 | (37.7546603883701, -122.414198678945) | 2 | 4 | 7 | 28859 | 19 | |||
183611 | 246552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | 7 | 9 | 11 | 28852 | 10 | |||
186583 | 198438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015515.17331 | 2106293.18394 | 37.764351234542 | -122.389515023625 | (37.764351234542, -122.389515023625) | 14 | 3 | 9 | 310 | 29 | |||
188844 | 198617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015877.04462 | 2108628.30945 | 37.7707830392222 | -122.388426398764 | (37.7707830392222, -122.388426398764) | 14 | 3 | 9 | 310 | 20 | ||||
96 | 137041 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009697.84819 | 2116804.05029 | 37.7928873337267 | -122.410377820179 | (37.7928873337267, -122.410377820179) | 3 | 1 | 10 | 28857 | 21 | ||
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) | ||||||||||
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 | |||||
5601 | 180565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | |||
6820 | 244317 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005516.527 | 2110492.6418 | 37.7753224827652 | -122.424396296997 | (37.7753224827652, -122.424396296997) | 7 | 9 | 11 | 28852 | 10 | |||
8039 | 260496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
8560 | 242617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007051.1369 | 2096685.57383 | 37.7374979908344 | -122.418108653317 | (37.7374979908344, -122.418108653317) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );