Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182744 | 182744 | 242401 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004422.12829 | 2096026.22682 | 37.7355392485419 | -122.427151426394 | (37.7355392485419, -122.427151426394) | ||||
176511 | 176511 | 242400 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004412.57648 | 2096019.13863 | 37.7355192458083 | -122.427183945908 | (37.7355192458083, -122.427183945908) | ||||
72683 | 72683 | 137053 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Green St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008580.77711 | 2119003.85777 | 37.7988647784329 | -122.414398677364 | (37.7988647784329, -122.414398677364) | ||||
178916 | 178916 | 198666 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013864.8595 | 2107478.20715 | 37.7675134055349 | -122.39530605864901 | (37.7675134055349, -122.395306058649) | |||
169845 | 169845 | 198665 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6013878.81115 | 2107466.84131 | 37.767482973376396 | -122.395257005115 | (37.7674829733764, -122.395257005115) | |||
132426 | 132426 | 198664 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013893.51882 | 2107448.48806 | 37.7674333973606 | -122.39520484712 | (37.7674333973606, -122.39520484712) | |||
100034 | 100034 | 97852 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
169909 | 169909 | 198663 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6013906.856240001 | 2107433.3805400003 | 37.7673926571763 | -122.395157656112 | (37.7673926571763, -122.395157656112) | |||
82060 | 82060 | 97851 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
166998 | 166998 | 198452 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015213.79848 | 2106277.63642 | 37.7642918298343 | -122.390556317147 | (37.7642918298343, -122.390556317147) | |||
41617 | 41617 | 198662 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013921.99886 | 2107418.77263 | 37.767353389178204 | -122.395104256175 | (37.7673533891782, -122.395104256175) | |||
85459 | 85459 | 97850 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
151556 | 151556 | 198451 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015235.48199 | 2106278.14685 | 37.764294434263704 | -122.390481355047 | (37.7642944342637, -122.390481355047) | |||
62501 | 62501 | 198450 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015258.23224 | 2106279.65666 | 37.7642998419001 | -122.390402773191 | (37.7642998419001, -122.390402773191) | |||
141852 | 141852 | 97849 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
25133 | 25133 | 198661 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | |||
50386 | 50386 | 198449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015277.30133 | 2106281.40363 | 37.764305696480896 | -122.39033694009599 | (37.7643056964809, -122.390336940096) | |||
96743 | 96743 | 97848 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
10729 | 10729 | 17592 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.42943389227699 | (37.7200700675728, -122.429433892277) | |||
77339 | 77339 | 198448 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015301.86752 | 2106280.10819 | 37.764303502138794 | -122.390251881336 | (37.7643035021388, -122.390251881336) | |||
120594 | 120594 | 97847 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
25485 | 25485 | 198641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | ||||
59621 | 59621 | 138397 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002370.6113 | 2115041.6133 | 37.787634661222604 | -122.43560424075301 | (37.7876346612226, -122.435604240753) | |||
61396 | 61396 | 198447 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015324.46824 | 2106281.29518 | 37.7643080149349 | -122.390173794086 | (37.7643080149349, -122.390173794086) | |||
81580 | 81580 | 97846 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | Permit Number 775024 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | ||
114063 | 114063 | 16452 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2000 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
126170 | 126170 | 198626 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015680.34741 | 2108616.56793 | 37.770739897870605 | -122.38910596427601 | (37.7707398978706, -122.389105964276) | ||||
186900 | 186900 | 198660 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013952.391369999 | 2107385.9793599998 | 37.767265036187204 | -122.39499683484101 | (37.7672650361872, -122.394996834841) | |||
10554 | 10554 | 17590 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003668.70994 | 2090393.5126599998 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | |||
67701 | 67701 | 198625 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015702.76358 | 2108617.6361 | 37.770744073418896 | -122.38902850026001 | (37.7707440734189, -122.38902850026) | ||||
72973 | 72973 | 198446 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015345.15707 | 2106282.1860700003 | 37.7643116086136 | -122.39010229888399 | (37.7643116086136, -122.390102298884) | |||
86501 | 86501 | 16431 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6016292.5361 | 2094929.44377 | 37.7331918315913 | -122.386034103828 | (37.7331918315913, -122.386034103828) | |||
110613 | 110613 | 97845 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
115097 | 115097 | 97234 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1380X Newcomb Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.38579618360501 | (37.7330981190079, -122.385796183605) | |||
163940 | 163940 | 198640 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015953.105690001 | 2108752.97494 | 37.771129557912204 | -122.388172001232 | (37.7711295579122, -122.388172001232) | ||||
183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
11319 | 11319 | 17589 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503006 | -122.42930461652 | (37.720035114503, -122.42930461652) | |||
15940 | 15940 | 97233 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300X Newcomb Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016357.8982 | 2094854.1147 | 37.7329886101989 | -122.385802878589 | (37.7329886101989, -122.385802878589) | |||
28275 | 28275 | 198639 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015936.8101699995 | 2108752.54325 | 37.7711274696967 | -122.38822833839 | (37.7711274696967, -122.38822833839) | ||||
30111 | 30111 | 198501 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | ||||
65548 | 65548 | 100582 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
98160 | 98160 | 100626 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
102056 | 102056 | 16430 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016278.2308330005 | 2094877.1898669999 | 37.733047561100896 | -122.386079920066 | (37.7330475611009, -122.386079920066) | |||
123489 | 123489 | 198445 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015364.886609999 | 2106281.79771 | 37.764311636502704 | -122.39003403224702 | (37.7643116365027, -122.390034032247) | |||
139312 | 139312 | 97844 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
161482 | 161482 | 198659 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013968.57822 | 2107369.74118 | 37.7672213498189 | -122.39493970902001 | (37.7672213498189, -122.39493970902) | |||
177478 | 177478 | 198624 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015725.44924 | 2108619.45871 | 37.7707503353808 | -122.38895015673701 | (37.7707503353808, -122.388950156737) | ||||
1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
1233 | 1233 | 119757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
12573 | 12573 | 17588 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003687.80932 | 2090380.0219599998 | 37.7199944786431 | -122.429287755146 | (37.7199944786431, -122.429287755146) | |||
40192 | 40192 | 246545 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | |||
42949 | 42949 | 244310 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005563.2696 | 2110605.957 | 37.77563625821271 | -122.424242664251 | (37.7756362582127, -122.424242664251) | |||
46975 | 46975 | 198638 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015910.558069999 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | ||||
48814 | 48814 | 198592 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013452.45897 | 2107129.35079 | 37.766532578853 | -122.396708048633 | (37.766532578853, -122.396708048633) | |||
56778 | 56778 | 198623 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | ||||
66611 | 66611 | 244468 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | |||
95172 | 95172 | 100581 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
110953 | 110953 | 119719 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
116938 | 116938 | 109163 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
120847 | 120847 | 100625 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
122435 | 122435 | 119792 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
122887 | 122887 | 16449 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
127815 | 127815 | 119816 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
131321 | 131321 | 138394 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002278.9059 | 2115030.4127 | 37.7875986981409 | -122.435920721296 | (37.7875986981409, -122.435920721296) | |||
159657 | 159657 | 198444 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015385.264330001 | 2106283.84094 | 37.7643183769187 | -122.38996369358802 | (37.7643183769187, -122.389963693588) | |||
164108 | 164108 | 244401 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.7252 | 2110260.2263 | 37.7746897578806 | -122.424046993197 | (37.7746897578806, -122.424046993197) | |||
168860 | 168860 | 97843 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6015209.9181699995 | 2104379.39414 | 37.7590794509666 | -122.39043709491399 | (37.7590794509666, -122.390437094914) | ||||
172502 | 172502 | 242403 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008707.95248 | 2101269.88955 | 37.75017862504279 | -122.412704235035 | (37.7501786250428, -122.412704235035) | |||
1191 | 1191 | 119838 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
1208 | 1208 | 119803 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1235 | 1235 | 119756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
12852 | 12852 | 17587 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 35 | 3X3 | 6003703.481380001 | 2090378.19842 | 37.7199903588363 | -122.42923345225901 | (37.7199903588363, -122.429233452259) | |||
25458 | 25458 | 244288 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.42410821881201 | (37.7739922036556, -122.424108218812) | |||
52763 | 52763 | 198591 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013476.96853 | 2107132.95858 | 37.766543849139204 | -122.39662352676399 | (37.7665438491392, -122.396623526764) | |||
55243 | 55243 | 244309 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005567.5189 | 2110582.8218 | 37.7755729745028 | -122.42422631910499 | (37.7755729745028, -122.424226319105) | |||
56268 | 56268 | 16448 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
68766 | 68766 | 244467 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.8918 | 2109690.1946 | 37.7731256707262 | -122.423940148458 | (37.7731256707262, -122.423940148458) | |||
69759 | 69759 | 244364 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005534.4686 | 2110345.8041 | 37.774920315184396 | -122.424323786781 | (37.7749203151844, -122.424323786781) | |||
73680 | 73680 | 198611 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6016143.32489 | 2108643.38282 | 37.7708391794209 | -122.38750637344101 | (37.7708391794209, -122.387506373441) | ||||
78899 | 78899 | 100580 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
79474 | 79474 | 16428 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016278.2308330005 | 2094877.1898669999 | 37.733047561100896 | -122.386079920066 | (37.7330475611009, -122.386079920066) | |||
92952 | 92952 | 119827 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
99403 | 99403 | 109164 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
108319 | 108319 | 119791 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
122353 | 122353 | 119718 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
129866 | 129866 | 138393 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002260.0048 | 2115027.6125 | 37.7875899357719 | -122.43598591483101 | (37.7875899357719, -122.435985914831) | |||
136512 | 136512 | 244331 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005661.6953 | 2109906.0133 | 37.7737199393103 | -122.423852403284 | (37.7737199393103, -122.423852403284) | |||
145979 | 145979 | 100624 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
148333 | 148333 | 198443 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015407.0439 | 2106284.7052599997 | 37.7643219580036 | -122.38988842391501 | (37.7643219580036, -122.389888423915) | |||
151969 | 151969 | 246544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005666.89387 | 2109521.5509099998 | 37.7726645918273 | -122.42380707793998 | (37.7726645918273, -122.42380707794) | |||
153528 | 153528 | 198652 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6016352.81609 | 2108774.30794 | 37.771210272076104 | -122.38679086381501 | (37.7712102720761, -122.386790863815) | ||||
155394 | 155394 | 244400 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005615.7803 | 2110234.2576 | 37.774618626605296 | -122.42403457786301 | (37.7746186266053, -122.424034577863) | |||
157554 | 157554 | 198658 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013985.93072 | 2107349.0106 | 37.767165393099205 | -122.39487823676001 | (37.7671653930992, -122.39487823676) | |||
164022 | 164022 | 97842 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6015209.65715 | 2104398.1625200002 | 37.7591309704315 | -122.390439309039 | (37.7591309704315, -122.390439309039) | ||||
169733 | 169733 | 198637 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015891.9528 | 2108749.14049 | 37.7711156409024 | -122.388383265478 | (37.7711156409024, -122.388383265478) | ||||
183346 | 183346 | 198622 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015766.21634 | 2108621.9300599997 | 37.7707593807704 | -122.388809313913 | (37.7707593807704, -122.388809313913) | ||||
1222 | 1222 | 119837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
11095 | 11095 | 17586 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003709.25966 | 2090367.0753099998 | 37.7199601443381 | -122.42921268601499 | (37.7199601443381, -122.429212686015) | |||
28480 | 28480 | 198590 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013501.44813 | 2107135.10099 | 37.766551094088996 | -122.39653900576599 | (37.766551094089, -122.396539005766) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");