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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120690 | 120690 | 110630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991857.0 | 2101850.0 | 37.7508112705894 | -122.47101756601101 | (37.7508112705894, -122.471017566011) | |||||
| 84223 | 84223 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 Conrad St | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 20 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 160398 | 160398 | 121610 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 22nd St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 11 | 6012951.69217 | 2103797.77434 | 37.7573569210097 | -122.398206359645 | (37.7573569210097, -122.398206359645) | ||||
| 143856 | 143856 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 CONRAD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1185 | 1185 | 119832 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 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) | |||||
| 1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 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) | |||||
| 1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 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) | |||||
| 1209 | 1209 | 119800 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1211 | 1211 | 119836 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 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) | |||||
| 1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1228 | 1228 | 119831 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1230 | 1230 | 119834 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1231 | 1231 | 119833 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | 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) | |||||
| 1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 22362 | 22362 | 244426 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.773354183173396 | -122.423776541571 | (37.7733541831734, -122.423776541571) | |||
| 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) | |||
| 25504 | 25504 | 244422 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.773130897486205 | -122.423735193743 | (37.7731308974862, -122.423735193743) | |||
| 27441 | 27441 | 244317 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005516.527000001 | 2110492.6418 | 37.775322482765205 | -122.42439629699699 | (37.7753224827652, -122.424396296997) | |||
| 28092 | 28092 | 246547 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.772377152311705 | -122.42353021715599 | (37.7723771523117, -122.423530217156) | |||
| 28574 | 28574 | 244375 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005617.5038 | 2109823.1115 | 37.773489816144796 | -122.423999372272 | (37.7734898161448, -122.423999372272) | |||
| 29153 | 29153 | 244356 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.775145038872104 | -122.424143338216 | (37.7751450388721, -122.424143338216) | |||
| 29250 | 29250 | 244237 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005569.1894 | 2110157.879 | 37.774406278899995 | -122.42419031206998 | (37.7744062789, -122.42419031207) | |||
| 29392 | 29392 | 244311 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | |||
| 31383 | 31383 | 244306 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303001 | (37.7753816404734, -122.42418868303) | |||
| 32047 | 32047 | 244254 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005646.3317 | 2110018.1063 | 37.774026852262104 | -122.423913520847 | (37.7740268522621, -122.423913520847) | |||
| 33227 | 33227 | 244397 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | |||
| 34532 | 34532 | 244424 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.42375456071301 | (37.7732378565997, -122.423754560713) | |||
| 34812 | 34812 | 244359 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.42437411128701 | (37.7752229798737, -122.424374111287) | |||
| 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) | |||
| 38215 | 38215 | 244396 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005626.4733 | 2110143.3671 | 37.7743696669954 | -122.42399112385799 | (37.7743696669954, -122.423991123858) | |||
| 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) | |||
| 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) | |||
| 45981 | 45981 | 244376 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | |||
| 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) | |||
| 51495 | 51495 | 244361 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | |||
| 51603 | 51603 | 244259 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) | |||
| 52888 | 52888 | 244411 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6005560.024 | 2110238.8403 | 37.7746280615118 | -122.424227776164 | (37.7746280615118, -122.424227776164) | |||
| 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) | |||
| 56950 | 56950 | 244345 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005607.2268 | 2109894.3659 | 37.773684883292105 | -122.424039990106 | (37.7736848832921, -122.424039990106) | |||
| 57681 | 57681 | 244354 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005594.4313 | 2110381.2151 | 37.7750209309426 | -122.424118881689 | (37.7750209309426, -122.424118881689) | |||
| 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) | |||
| 60342 | 60342 | 244357 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005584.9883 | 2110453.4536 | 37.7752187471852 | -122.424156685679 | (37.7752187471852, -122.424156685679) | |||
| 62806 | 62806 | 244235 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | |||
| 62865 | 62865 | 244423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | |||
| 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) | |||
| 66723 | 66723 | 244358 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | |||
| 67382 | 67382 | 244287 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005585.9927 | 2110033.3819999998 | 37.7740653890161 | -122.424123330561 | (37.7740653890161, -122.424123330561) | |||
| 68449 | 68449 | 244328 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | |||
| 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) | |||
| 69418 | 69418 | 244398 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005622.6544 | 2110184.6115 | 37.7744826985313 | -122.42400726776 | (37.7744826985313, -122.42400726776) | |||
| 69750 | 69750 | 244330 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.42383860414199 | (37.7736448835433, -122.423838604142) | |||
| 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) | |||
| 73396 | 73396 | 244466 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | |||
| 76593 | 76593 | 244327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.42380475570499 | (37.773436531636, -122.423804755705) | |||
| 77107 | 77107 | 244284 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005583.7013 | 2110055.5318 | 37.774126077633206 | -122.42413283246701 | (37.7741260776332, -122.424132832467) | |||
| 78159 | 78159 | 109162 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51x OCTAVIA ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649005 | -122.42385688843399 | (37.772384002649, -122.423856888434) | |||
| 81045 | 81045 | 109169 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 83700 | 83700 | 109168 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 84832 | 84832 | 119681 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 84934 | 84934 | 119788 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 85315 | 85315 | 119826 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 85972 | 85972 | 119818 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 87810 | 87810 | 119785 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 91459 | 91459 | 119712 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 91533 | 91533 | 119820 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 92481 | 92481 | 119675 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 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) | |||||
| 93091 | 93091 | 119824 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 93922 | 93922 | 119676 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 96137 | 96137 | 119790 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 97204 | 97204 | 109171 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 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) | ||||
| 99764 | 99764 | 109166 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51x OCTAVIA ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649005 | -122.42385688843399 | (37.772384002649, -122.423856888434) | ||||
| 99951 | 99951 | 119755 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106x Octavia St Frontage West | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) |
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");