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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
263 | 17585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | 9 | 7 | 6 | 28861 | 5 | |||
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) | ||||||||||
10263 | 119836 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
11525 | 119754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
40918 | 97229 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 9 | Median : Cutout | Tree | DPW 1 | 28 | 15x200 | 6016636.94251 | 2094930.84044 | 37.7332147213866 | -122.384843483567 | (37.7332147213866, -122.384843483567) | 10 | 3 | 8 | 58 | 1 | |||
49167 | 16426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | ||
58566 | 200635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016404.4653 | 2094836.0752 | 37.7329416541175 | -122.385640625637 | (37.7329416541175, -122.385640625637) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||||
70305 | 198609 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016187.15273 | 2108644.67946 | 37.7708451671001 | -122.387354861049 | (37.7708451671001, -122.387354861049) | 14 | 3 | 9 | 310 | 20 | ||||
76640 | 17926 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/2015 11:29:00 AM | 3 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | ||
84532 | 244398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005622.6544 | 2110184.6115 | 37.7744826985313 | -122.42400726776 | (37.7744826985313, -122.42400726776) | 7 | 9 | 11 | 28852 | 10 | |||
90428 | 198635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015851.9543 | 2108746.90695 | 37.7711072915897 | -122.388521466994 | (37.7711072915897, -122.388521466994) | 14 | 3 | 9 | 310 | 20 | ||||
102320 | 244307 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005574.129 | 2110533.2464 | 37.775437225715 | -122.424199926569 | (37.775437225715, -122.424199926569) | 7 | 9 | 11 | 28852 | 10 | |||
105079 | 141762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003923.1755 | 2113496.0743 | 37.7834790593899 | -122.430122374293 | (37.7834790593899, -122.430122374293) | 7 | 9 | 11 | 29490 | 41 | |||
108330 | 244284 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005583.7013 | 2110055.5318 | 37.7741260776332 | -122.424132832467 | (37.7741260776332, -122.424132832467) | 7 | 9 | 11 | 28852 | 10 | |||
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) | ||||||||||
126507 | 180540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5998917.8755 | 2091146.49396 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | 9 | 7 | 6 | 28861 | 25 | |||
127388 | 138413 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002201.9014 | 2115017.8119 | 37.7875597248604 | -122.436186239179 | (37.7875597248604, -122.436186239179) | 13 | 6 | 11 | 29490 | 27 | |||
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) | ||||||||||
135699 | 244329 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005667.8615 | 2109858.0536 | 37.773588601657 | -122.423827662517 | (37.773588601657, -122.423827662517) | 7 | 9 | 11 | 28852 | 10 | |||
142794 | 198620 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015807.97532 | 2108623.11457 | 37.7707649475819 | -122.388664950249 | (37.7707649475819, -122.388664950249) | 14 | 3 | 9 | 310 | 20 | ||||
146361 | 198571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014800.77369 | 2114106.06902 | 37.7857640358271 | -122.392532497299 | (37.7857640358271, -122.392532497299) | 6 | 2 | 9 | 28855 | 6 | |||
150079 | 16446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
154989 | 244465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | 7 | 9 | 11 | 28852 | 10 | |||
155320 | 198490 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015210.07266 | 2104451.60181 | 37.7592777263026 | -122.390441605915 | (37.7592777263026, -122.390441605915) | 10 | 3 | 8 | 28856 | 29 | |||
155530 | 198650 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016310.0808 | 2108775.16968 | 37.7712102720573 | -122.386938748345 | (37.7712102720573, -122.386938748345) | 14 | 3 | 9 | 310 | 20 | ||||
161873 | 246555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.7728152903163 | -122.423623602744 | (37.7728152903163, -122.423623602744) | 7 | 9 | 11 | 28852 | 10 | |||
164874 | 198461 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014835.64644 | 2106275.86157 | 37.764265970711 | -122.391864124747 | (37.764265970711, -122.391864124747) | 14 | 3 | 9 | 310 | 29 | |||
171872 | 242485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008307.91668 | 2102984.70422 | 37.754864658588 | -122.414208897026 | (37.754864658588, -122.414208897026) | 2 | 4 | 7 | 28859 | 19 | |||
176936 | 198441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015454.54719 | 2106287.83835 | 37.7643331950564 | -122.389724340824 | (37.7643331950564, -122.389724340824) | 14 | 3 | 9 | 310 | 29 | |||
177419 | 244362 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005532.1079 | 2110378.8544 | 37.7750109299929 | -122.424334304145 | (37.7750109299929, -122.424334304145) | 7 | 9 | 11 | 28852 | 10 | |||
182134 | 17956 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 9 | 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 | |||
187008 | 119825 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
187286 | 242504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008251.23076 | 2102923.39648 | 37.7546931372024 | -122.414400595628 | (37.7546931372024, -122.414400595628) | 2 | 4 | 7 | 28859 | 19 | |||
189573 | 198589 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013524.37895 | 2107133.46335 | 37.76654787361 | -122.396459576758 | (37.76654787361, -122.396459576758) | 14 | 3 | 8 | 28856 | 20 | |
191103 | 198481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015200.5956 | 2104639.69489 | 37.7597936637724 | -122.390487525273 | (37.7597936637724, -122.390487525273) | 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) | ||||||||||
14201 | 138412 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002175.9998 | 2115015.7118 | 37.7875524868912 | -122.436275703068 | (37.7875524868912, -122.436275703068) | 13 | 6 | 11 | 29490 | 27 | |||
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 | |||||
17081 | 17955 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
24722 | 244306 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303 | (37.7753816404734, -122.42418868303) | 7 | 9 | 11 | 28852 | 10 | |||
28371 | 108235 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
29420 | 244397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | 7 | 9 | 11 | 28852 | 10 | |||
31707 | 242484 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008307.71975 | 2102954.44615 | 37.7547815657263 | -122.414207437417 | (37.7547815657263, -122.414207437417) | 2 | 4 | 7 | 28859 | 19 | |||
31708 | 198480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015199.5579 | 2104656.07032 | 37.7598385696177 | -122.390492258425 | (37.7598385696177, -122.390492258425) | 10 | 3 | 8 | 28856 | 29 | |||
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) | ||||||||||
40459 | 97839 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
40639 | 251525 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | 7 | 9 | 5 | 28862 | 3 | ||||
43824 | 246542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126 | (37.772505687922, -122.42377321126) | 7 | 9 | 11 | 28852 | 10 | |||
49492 | 17925 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 8 | 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 | |||
65142 | 136958 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Divisadero St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000568.04629 | 2118355.71273 | 37.7966317645105 | -122.442078724458 | (37.7966317645105, -122.442078724458) | 13 | 9 | 1 | 57 | 17 | |||
72628 | 244361 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | 7 | 9 | 11 | 28852 | 10 | |||
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) | ||||||||||
79512 | 198570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014790.57868 | 2114116.0189 | 37.7857907897446 | -122.392568465686 | (37.7857907897446, -122.392568465686) | 6 | 2 | 9 | 28855 | 6 | |||
84842 | 244328 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | 7 | 9 | 11 | 28852 | 10 | |||
87834 | 198619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015825.0595 | 2108624.79715 | 37.770770514383 | -122.388605972695 | (37.770770514383, -122.388605972695) | 14 | 3 | 9 | 310 | 20 | ||||
95343 | 198500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016504.90448 | 2102523.10402 | 37.754054221042 | -122.385828988529 | (37.754054221042, -122.385828988529) | 10 | 3 | 8 | 28856 | 29 | |||
106875 | 198634 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015830.83594 | 2108747.07967 | 37.7711065955099 | -122.38859452884 | (37.7711065955099, -122.38859452884) | 14 | 3 | 9 | 310 | 20 | ||||
119302 | 16425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
122715 | 244283 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005579.1186 | 2110077.6816 | 37.7741866368779 | -122.424150260413 | (37.7741866368779, -122.424150260413) | 7 | 9 | 11 | 28852 | 10 | |||
123476 | 119800 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
124048 | 246554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.7727396879137 | -122.423612306376 | (37.7727396879137, -122.423612306376) | 7 | 9 | 11 | 28852 | 10 | |||
124440 | 7588 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
127492 | 17584 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.429104673852 | (37.7199371612464, -122.429104673852) | 9 | 7 | 6 | 28861 | 5 | |||
128696 | 141783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1439 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003973.4218 | 2113184.0589 | 37.7826251887217 | -122.42992627789 | (37.7826251887217, -122.42992627789) | 7 | 9 | 11 | 29490 | 41 | |||
129352 | 198649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016285.57372 | 2108771.35591 | 37.7711984432851 | -122.387023254046 | (37.7711984432851, -122.387023254046) | 14 | 3 | 9 | 310 | 20 | ||||
143654 | 198580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014742.64135 | 2114209.62608 | 37.7860451513037 | -122.392740867522 | (37.7860451513037, -122.392740867522) | 6 | 2 | 9 | 28855 | 6 | |||
145343 | 198489 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015206.91645 | 2104475.31213 | 37.7593426546662 | -122.390454178415 | (37.7593426546662, -122.390454178415) | 10 | 3 | 8 | 28856 | 29 | |||
145347 | 244456 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.7733190115017 | -122.423971237778 | (37.7733190115017, -122.423971237778) | 7 | 9 | 11 | 28852 | 10 | |||
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) | ||||||||||
155428 | 198656 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014014.86759 | 2107324.11249 | 37.7670986373305 | -122.394776403817 | (37.7670986373305, -122.394776403817) | 14 | 3 | 9 | 310 | 20 | |||
158337 | 198682 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010265.52536 | 2111657.00033 | 37.7787865665763 | -122.408050470058 | (37.7787865665763, -122.408050470058) | 14 | 2 | 9 | 28853 | 34 | |||
161548 | 109167 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 8 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
162006 | 254723 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 8 | 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 | ||
166195 | 198588 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013599.81261 | 2107136.62549 | 37.766560753709 | -122.396198884879 | (37.766560753709, -122.396198884879) | 14 | 3 | 8 | 28856 | 20 | |
173101 | 201913 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 8 | : | Tree | Private 2 | 5 | Width 3ft | 6013833.24742 | 2093196.526 | 37.7282971789522 | -122.394415299033 | (37.7282971789522, -122.394415299033) | 10 | 3 | 8 | 58 | 1 | |||
182982 | 198440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015476.91332 | 2106290.58138 | 37.7643419670439 | -122.389647173584 | (37.7643419670439, -122.389647173584) | 14 | 3 | 9 | 310 | 29 | |||
184946 | 141761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003925.4266 | 2113468.4989 | 37.7834034717338 | -122.430112618538 | (37.7834034717338, -122.430112618538) | 7 | 9 | 11 | 29490 | 41 | |||
186554 | 198608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016209.64695 | 2108646.95211 | 37.7708526530593 | -122.387277210877 | (37.7708526530593, -122.387277210877) | 14 | 3 | 9 | 310 | 20 | ||||
190991 | 198460 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014862.84066 | 2106274.78772 | 37.7642645317963 | -122.391769991798 | (37.7642645317963, -122.391769991798) | 14 | 3 | 9 | 310 | 29 | |||
191729 | 16445 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
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) | ||||||||||
4133 | 138411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002152.1984 | 2115012.2116 | 37.7875415238713 | -122.436357800436 | (37.7875415238713, -122.436357800436) | 13 | 6 | 11 | 29490 | 27 | |||
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) | ||||||||||
23988 | 198459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | 14 | 3 | 9 | 310 | 29 | |||
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 | ||||
27340 | 242558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008208.12172 | 2104777.36989 | 37.7597813034931 | -122.414680872925 | (37.7597813034931, -122.414680872925) | 2 | 4 | 7 | 28859 | 19 | |||
29914 | 198681 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010294.84433 | 2111624.83118 | 37.7786998791448 | -122.407946774624 | (37.7786998791448, -122.407946774624) | 14 | 2 | 9 | 28853 | 34 | |||
31486 | 244396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005626.4733 | 2110143.3671 | 37.7743696669954 | -122.423991123858 | (37.7743696669954, -122.423991123858) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||||
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) | |||||||||
54691 | 198499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016506.22051 | 2102490.10595 | 37.7539636880787 | -122.38582213748 | (37.7539636880787, -122.38582213748) | 10 | 3 | 8 | 28856 | 29 | |||
59194 | 198587 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013654.04555 | 2107139.63113 | 37.7665720240075 | -122.396011512024 | (37.7665720240075, -122.396011512024) | 14 | 3 | 8 | 28856 | 20 | |
62432 | 201912 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | 10 | 3 | 8 | 58 | 1 | |||
66137 | 242503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008245.42572 | 2102971.97718 | 37.7548262026792 | -122.414424108384 | (37.7548262026792, -122.414424108384) | 2 | 4 | 7 | 28859 | 19 | |||
66944 | 198633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015806.09479 | 2108744.28476 | 37.7710975501444 | -122.388679914958 | (37.7710975501444, -122.388679914958) | 14 | 3 | 9 | 310 | 20 | ||||
70024 | 246553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6005726.46493 | 2109532.06592 | 37.7726968262309 | -122.423601762727 | (37.7726968262309, -122.423601762727) | 7 | 9 | 11 | 28852 | 10 | |||
74565 | 198648 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016263.67679 | 2108770.7838 | 37.77119565988 | -122.387098957165 | (37.77119565988, -122.387098957165) | 14 | 3 | 9 | 310 | 20 | ||||
74767 | 141782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1441 Ellis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003950.7038 | 2113181.9456 | 37.7826180995506 | -122.430004721615 | (37.7826180995506, -122.430004721615) | 7 | 9 | 11 | 29490 | 41 |
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) );