Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11102 | 11102 | 56779 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1974 12:00:00 AM | 10 | 3x3 | Permit Number 14000 | 6004445.70809 | 2092827.36067 | 37.726757210476606 | -122.42684215943899 | (37.7267572104766, -122.426842159439) | |
94108 | 94108 | 88329 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 120 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940.0 | 2092960.0 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | |||
62617 | 62617 | 180568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 136 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007069.5119199995 | 2093001.96725 | 37.7273846467688 | -122.417784094277 | (37.7273846467688, -122.417784094277) | |||
188123 | 188123 | 215516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 88 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994119.69741 | 2093345.3808900001 | 37.7275903136211 | -122.462576174158 | (37.7275903136211, -122.462576174158) | |||
109273 | 109273 | 58204 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1978 12:00:00 AM | 18 | 3x3 | Permit Number 17195 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | |
144247 | 144247 | 113083 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | ||||
52346 | 52346 | 180572 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 515 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009820.001630001 | 2093055.54033 | 37.7276861489955 | -122.408279384389 | (37.7276861489955, -122.408279384389) | |||
162881 | 162881 | 180573 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 515 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009834.242740001 | 2093058.41578 | 37.7276948418209 | -122.408230355163 | (37.7276948418209, -122.408230355163) | |||
174425 | 174425 | 201913 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013833.24742 | 2093196.5259999998 | 37.728297178952204 | -122.394415299033 | (37.7282971789522, -122.394415299033) | |||
156847 | 156847 | 201912 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | |||
136167 | 136167 | 201911 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.72835012384171 | -122.394511693764 | (37.7283501238417, -122.394511693764) | |||
132509 | 132509 | 46780 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.43357175935301 | (37.7283552769641, -122.433571759353) | |
178128 | 178128 | 201910 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.728373419872604 | -122.39455007233101 | (37.7283734198726, -122.394550072331) | |||
189004 | 189004 | 201909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.39459380727101 | (37.728396715017, -122.394593807271) | |||
39939 | 39939 | 201908 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.39464378978901 | (37.7284270698286, -122.394643789789) | |||
153607 | 153607 | 201907 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | |||
157811 | 157811 | 201906 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6013735.56827 | 2093268.6904400003 | 37.728489897392706 | -122.394758034254 | (37.7284898973927, -122.394758034254) | |||
103920 | 103920 | 117152 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.72855094559029 | -122.389513905896 | (37.7285509455903, -122.389513905896) | |||
59286 | 59286 | 46632 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.728578532365496 | -122.389527911332 | (37.7285785323655, -122.389527911332) |
114136 | 114136 | 107048 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1478 UNDERWOOD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015262.9 | 2093276.2 | 37.7285953185109 | -122.389478448264 | (37.7285953185109, -122.389478448264) | |||
103372 | 103372 | 81863 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.729301806319704 | -122.459920577502 | (37.7293018063197, -122.459920577502) | ||
34463 | 34463 | 180569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 39 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007329.333980001 | 2093756.2890599999 | 37.729470469574 | -122.416939308919 | (37.729470469574, -122.416939308919) | |||
39882 | 39882 | 198695 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 Baldwin Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6017823.537959999 | 2093627.90873 | 37.729702684433605 | -122.3806505222 | (37.7297026844336, -122.3806505222) | |||
102460 | 102460 | 11630 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 5991380.578 | 2094219.03 | 37.7298310098579 | -122.47210889946501 | (37.7298310098579, -122.472108899465) | |||
181961 | 181961 | 180570 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 39 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007772.766419999 | 2093897.53246 | 37.7298832269189 | -122.415416310622 | (37.7298832269189, -122.415416310622) | |||
26996 | 26996 | 180571 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009971.64388 | 2093913.4655400002 | 37.7300503209452 | -122.40781562289801 | (37.7300503209452, -122.407815622898) | |||
188430 | 188430 | 180567 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 79 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003968.93484 | 2094040.3155900002 | 37.7300607449837 | -122.428576774521 | (37.7300607449837, -122.428576774521) | |||
48146 | 48146 | 180566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 111 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004117.41747 | 2094047.5610599997 | 37.730089041271206 | -122.42806396757099 | (37.7300890412712, -122.428063967571) | |||
157153 | 157153 | 215524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995481.220919999 | 2094239.1346200001 | 37.730122661531205 | -122.457934054513 | (37.7301226615312, -122.457934054513) | |||
150723 | 150723 | 215523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Northwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995460.486769999 | 2094242.81923 | 37.7301315873058 | -122.458006001202 | (37.7301315873058, -122.458006001202) | |||
66843 | 66843 | 200759 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1628 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014603.9551 | 2094093.5604 | 37.7308030679401 | -122.391813605271 | (37.7308030679401, -122.391813605271) | |||
16759 | 16759 | 26628 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | ||
15899 | 15899 | 22327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.39177919347401 | (37.7313174804906, -122.391779193474) | |||
70456 | 70456 | 200744 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5101 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014678.5205 | 2094530.4879 | 37.732006921517794 | -122.39158635462601 | (37.7320069215178, -122.391586354626) | |||
172464 | 172464 | 200745 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5101 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6014683.7532 | 2094550.1103 | 37.7320610911002 | -122.391569635286 | (37.7320610911002, -122.391569635286) | |||
151341 | 151341 | 200746 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | |||
77382 | 77382 | 22315 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
92068 | 92068 | 22316 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
99143 | 99143 | 22314 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
160596 | 160596 | 200755 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5099 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014751.1238 | 2094745.6812 | 37.7326018284177 | -122.391350385093 | (37.7326018284177, -122.391350385093) | |||
146021 | 146021 | 22309 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5033 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6014806.53085 | 2094754.47288 | 37.732629043524206 | -122.391159442188 | (37.7326290435242, -122.391159442188) | |||
181726 | 181726 | 200749 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | |||
113677 | 113677 | 16437 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1299X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | |||
117448 | 117448 | 16434 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1299X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | |||
188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | |||
43571 | 43571 | 200600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | |||
59826 | 59826 | 200635 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016404.4653 | 2094836.0752 | 37.7329416541175 | -122.385640625637 | (37.7329416541175, -122.385640625637) | |||
14093 | 14093 | 97435 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.732951043415206 | -122.385341956131 | (37.7329510434152, -122.385341956131) | |||
46120 | 46120 | 200598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.732956277793896 | -122.385302911931 | (37.7329562777939, -122.385302911931) | |||
173743 | 173743 | 200597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.732969621897794 | -122.38526117126301 | (37.7329696218978, -122.385261171263) | |||
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) | |||
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) | ||
77819 | 77819 | 16442 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
97750 | 97750 | 16441 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
99266 | 99266 | 16438 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
100525 | 100525 | 16440 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
108623 | 108623 | 16443 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
111003 | 111003 | 16446 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
111469 | 111469 | 16439 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
113193 | 113193 | 16447 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
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) | ||
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) | ||
140297 | 140297 | 16444 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
146043 | 146043 | 16445 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
144437 | 144437 | 16423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016393.65878 | 2094869.65123 | 37.73303324923471 | -122.385680326224 | (37.7330332492347, -122.385680326224) | |||
110000 | 110000 | 16421 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016475.459559999 | 2094869.09162 | 37.7330362386527 | -122.385397477745 | (37.7330362386527, -122.385397477745) | |||
79911 | 79911 | 200630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1352 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6016410.2733 | 2094871.4126 | 37.7330390049329 | -122.38562300763 | (37.7330390049329, -122.38562300763) | |||
187497 | 187497 | 200580 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1330 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6016475.5774 | 2094870.1567 | 37.7330391696694 | -122.38539714453199 | (37.7330391696694, -122.385397144532) | |||
93435 | 93435 | 16411 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1200X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | |||
108708 | 108708 | 16415 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1200X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | |||
110060 | 110060 | 16424 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.38571240580299 | (37.7330411346315, -122.385712405803) | |||
149386 | 149386 | 200631 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1354 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016389.5518 | 2094874.5522 | 37.733046479064704 | -122.385694866729 | (37.7330464790647, -122.385694866729) | |||
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) | |||
83647 | 83647 | 16426 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.2308330005 | 2094877.1898669999 | 37.733047561100896 | -122.386079920066 | (37.7330475611009, -122.386079920066) | ||
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) | |||
107627 | 107627 | 16425 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016278.2308330005 | 2094877.1898669999 | 37.733047561100896 | -122.386079920066 | (37.7330475611009, -122.386079920066) | |||
89115 | 89115 | 16420 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016497.0965599995 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | |||
155463 | 155463 | 200579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1324 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016496.9269 | 2094875.1801 | 37.7330541440687 | -122.385323682911 | (37.7330541440687, -122.385323682911) | |||
26697 | 26697 | 200627 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016371.342 | 2094881.4594 | 37.7330644372172 | -122.385758304658 | (37.7330644372172, -122.385758304658) | |||
166427 | 166427 | 200628 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1362 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016361.9231 | 2094886.4828 | 37.7330777092621 | -122.385791218603 | (37.7330777092621, -122.385791218603) | |||
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) | |||
141737 | 141737 | 97434 | Ulmus parvifolia :: Chinese Elm 46 | 1380x Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.38579618360501 | (37.7330981190079, -122.385796183605) | ||||
55680 | 55680 | 200623 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1380 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6016334.2945 | 2094904.0647 | 37.7331244567265 | -122.385887963991 | (37.7331244567265, -122.385887963991) | |||
23315 | 23315 | 16418 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1992 12:00:00 AM | 13 | 3x3 | 6016308.5496 | 2094919.7628 | 37.7331661358215 | -122.385978065712 | (37.7331661358215, -122.385978065712) | ||
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) | |||
130602 | 130602 | 200622 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1400 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6016290.9677 | 2094932.3213 | 37.733199645911604 | -122.38603972678301 | (37.7331996459116, -122.386039726783) | |||
181077 | 181077 | 198691 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016677.93992 | 2094927.14945 | 37.7332068541071 | -122.384701486 | (37.7332068541071, -122.384701486) | |||
13974 | 13974 | 97229 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 15x200 | 6016636.9425099995 | 2094930.8404400002 | 37.7332147213866 | -122.38484348356701 | (37.7332147213866, -122.384843483567) | |||
16597 | 16597 | 97225 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.9135099999 | 37.7332595687675 | -122.38479997523599 | (37.7332595687675, -122.384799975236) | ||
173024 | 173024 | 198692 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.733299770270904 | -122.38458557598601 | (37.7332997702709, -122.384585575986) | |||
166257 | 166257 | 198694 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 97 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6016624.01227 | 2094969.8217099998 | 37.733321041016104 | -122.38489090210899 | (37.7333210410161, -122.384890902109) | |||
15023 | 15023 | 97221 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 15x200 | 6016689.53805 | 2094986.8063299998 | 37.733371301443 | -122.38466554190701 | (37.733371301443, -122.384665541907) | |||
68547 | 68547 | 215572 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 745 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5999421.36042 | 2095348.4772 | 37.733394244029796 | -122.44439222861999 | (37.7333942440298, -122.44439222862) | |||
36550 | 36550 | 18546 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | |||
147817 | 147817 | 198693 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6016661.34411 | 2095009.8516799998 | 37.733433020107 | -122.38476462199199 | (37.733433020107, -122.384764621992) | |||
151903 | 151903 | 215573 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 151 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999107.62839 | 2095480.4173299999 | 37.7337386151486 | -122.445486368125 | (37.7337386151486, -122.445486368125) | |||
2748 | 2748 | 30802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.8302099998 | 37.733802178321 | -122.43669510478998 | (37.733802178321, -122.43669510479) |
88869 | 88869 | 32534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
118928 | 118928 | 32532 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
128748 | 128748 | 32533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) |
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");