trees
2,365 rows where qSpecies_id = 31 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28588 | 17551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003191.74591 | 2090695.76954 | 37.7208333554501 | -122.431024998907 | (37.7208333554501, -122.431024998907) | 9 | 7 | 6 | 28861 | 5 | |||
29302 | 7646 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6008513.44624 | 2099397.67081 | 37.745027010685 | -122.413244473962 | (37.745027010685, -122.413244473962) | 2 | 7 | 7 | 28859 | 2 | |||
29404 | 23635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
29511 | 244254 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005646.3317 | 2110018.1063 | 37.7740268522621 | -122.423913520847 | (37.7740268522621, -122.423913520847) | 7 | 9 | 11 | 28852 | 10 | |||
29976 | 244375 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005617.5038 | 2109823.1115 | 37.7734898161448 | -122.423999372272 | (37.7734898161448, -122.423999372272) | 7 | 9 | 11 | 28852 | 10 | |||
30219 | 7647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3302 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6008452.78429 | 2099390.30637 | 37.7450033836799 | -122.413453712108 | (37.7450033836799, -122.413453712108) | 2 | 7 | 7 | 28859 | 2 | |||
31182 | 244424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.423754560713 | (37.7732378565997, -122.423754560713) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
31673 | 119709 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
31677 | 138807 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | 13 | 9 | 11 | 29490 | 27 | |||
31679 | 17592 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.429433892277 | (37.7200700675728, -122.429433892277) | 9 | 7 | 6 | 28861 | 5 | |||
33254 | 119798 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
33260 | 7579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2995 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4x4 | 6008416.03486 | 2101001.24422 | 37.7494245965646 | -122.41369470787 | (37.7494245965646, -122.41369470787) | 2 | 4 | 7 | 28859 | 19 | |||
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) | ||||||||||
33825 | 119679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
34450 | 119816 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
34502 | 2598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1738 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005142.52853 | 2115146.44686 | 37.7880795569985 | -122.426021407949 | (37.7880795569985, -122.426021407949) | 13 | 9 | 11 | 28858 | 27 | |||
35000 | 244311 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | 7 | 9 | 11 | 28852 | 10 | |||
35158 | 100568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | 6 | 2 | 9 | 28853 | 34 | |||
35263 | 17532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002799.2909021 | 2090948.5412155 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | 9 | 7 | 6 | 28861 | 5 | |||
35356 | 23645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 197 Virginia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006675.2549665 | 2098483.0974626 | 37.7424124262119 | -122.419535749262 | (37.7424124262119, -122.419535749262) | 2 | 7 | 7 | 28859 | 2 | |||
35431 | 7550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2888 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008324.12517 | 2101635.93861 | 37.7511621632162 | -122.414057430518 | (37.7511621632162, -122.414057430518) | 2 | 4 | 7 | 28859 | 19 | |||
35889 | 14842 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.433664099691 | (37.7783201948721, -122.433664099691) | 15 | 5 | 11 | 29492 | 41 | ||
36034 | 18002 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2676 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001135.87676 | 2114918.88378 | 37.7872274699544 | -122.439867367887 | (37.7872274699544, -122.439867367887) | 13 | 6 | 1 | 29490 | 27 | |||
36250 | 244237 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005569.1894 | 2110157.879 | 37.7744062789 | -122.42419031207 | (37.7744062789, -122.42419031207) | 7 | 9 | 11 | 28852 | 10 | |||
36270 | 7607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3167 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008461.57901 | 2100237.08528 | 37.7473289441915 | -122.413483177404 | (37.7473289441915, -122.413483177404) | 2 | 7 | 7 | 28859 | 2 | |||
36724 | 7562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2924 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 5x5 | 6008336.41396 | 2101367.26054 | 37.7504251238168 | -122.413995929472 | (37.7504251238168, -122.413995929472) | 2 | 4 | 7 | 28859 | 19 | ||
36983 | 25188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3741 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000279.55164 | 2102883.22055 | 37.7541317821777 | -122.441965858665 | (37.7541317821777, -122.441965858665) | 2 | 4 | 5 | 63 | 38 | |||
37182 | 109162 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | |||
37614 | 119819 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
37690 | 17590 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003668.70994 | 2090393.51266 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | 9 | 7 | 6 | 28861 | 5 | |||
37973 | 18057 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2882 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6000155.2064 | 2114785.6979 | 37.7868059046739 | -122.443250696948 | (37.7868059046739, -122.443250696948) | 13 | 6 | 1 | 29490 | 27 | |||
38457 | 85775 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008458.3046 | 2109095.9531 | 37.7716531852784 | -122.4141211414 | (37.7716531852784, -122.4141211414) | 8 | 2 | 9 | 28853 | 19 | ||
38890 | 17931 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2416 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002234.6053 | 2115077.8001 | 37.7877262951282 | -122.436077384684 | (37.7877262951282, -122.436077384684) | 13 | 6 | 1 | 29490 | 27 | |||
39111 | 200598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.7329562777939 | -122.385302911931 | (37.7329562777939, -122.385302911931) | 10 | 3 | 8 | 58 | 1 | |||
40235 | 17524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | 9 | 7 | 6 | 28861 | 5 | |||
40840 | 17595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003715.34966 | 2090318.22231 | 37.7198263494989 | -122.429188153404 | (37.7198263494989, -122.429188153404) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
41142 | 49606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | 8 | 2 | 9 | 28853 | 34 | |
41166 | 17580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003780.63082 | 2090335.55969 | 37.7198776495042 | -122.428963734788 | (37.7198776495042, -122.428963734788) | 9 | 7 | 6 | 28861 | 5 | |||
41669 | 17530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002769.64699 | 2090910.44177 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | 9 | 7 | 6 | 28861 | 5 | |||
41710 | 244310 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005563.2696 | 2110605.957 | 37.7756362582127 | -122.424242664251 | (37.7756362582127, -122.424242664251) | 7 | 9 | 11 | 28852 | 10 | |||
43059 | 244376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | 7 | 9 | 11 | 28852 | 10 | |||
43146 | 7599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3106 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6008391.53469 | 2100462.67214 | 37.7479444222008 | -122.413741340393 | (37.7479444222008, -122.413741340393) | 2 | 7 | 7 | 28859 | 2 | |||
43307 | 7660 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 01:35:00 PM | 3 | 4x4 | 6008461.08319 | 2099185.41304 | 37.7444412579547 | -122.413410528397 | (37.7444412579547, -122.413410528397) | 2 | 7 | 7 | 28859 | 2 | ||
43659 | 17498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.434870362385 | (37.72266164479, -122.434870362385) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
45091 | 25175 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.442616778303 | (37.7611492576992, -122.442616778303) | 15 | 5 | 5 | 28862 | 3 | ||
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) | |||||||||
46315 | 17923 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
46405 | 7637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6008436.96279 | 2099620.40725 | 37.7456343012777 | -122.413524691037 | (37.7456343012777, -122.413524691037) | 2 | 7 | 7 | 28859 | 2 | |||
47077 | 17528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002717.3851 | 2090942.27549 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | 9 | 7 | 6 | 28861 | 5 | |||
47292 | 18702 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3401 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x8 | 6008528.43414 | 2099029.73603 | 37.7440175846489 | -122.413166635838 | (37.7440175846489, -122.413166635838) | 2 | 7 | 7 | 28859 | 2 | |||
47416 | 255466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15x200 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
47670 | 1208 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3141 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5995992.87885 | 2086942.40616 | 37.7101169521706 | -122.455637985173 | (37.7101169521706, -122.455637985173) | 9 | 7 | 6 | 28861 | 25 | |||
47938 | 85786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | 8 | 2 | 9 | 28853 | 34 | ||
48013 | 17920 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 3 | 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 | |||
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 | ||
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 | |||
50052 | 18015 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2712 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000819.3499 | 2114877.5272 | 37.7870958927498 | -122.440959512089 | (37.7870958927498, -122.440959512089) | 13 | 6 | 1 | 29490 | 27 | |||
50232 | 7528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2815 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008357.33424 | 2102016.55073 | 37.7522091035878 | -122.413969511892 | (37.7522091035878, -122.413969511892) | 2 | 4 | 7 | 28859 | 19 | |||
50705 | 246545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | 7 | 9 | 11 | 28852 | 10 | |||
51199 | 119795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
52055 | 85766 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2012 12:00:00 AM | 3 | 3x3 | 6008764.4124 | 2109484.6384 | 37.7727376126497 | -122.413089780599 | (37.7727376126497, -122.413089780599) | 8 | 2 | 9 | 28853 | 34 | ||
52244 | 14861 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1372 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002599.36465 | 2111713.08201 | 37.7785083454918 | -122.434574707994 | (37.7785083454918, -122.434574707994) | 15 | 5 | 11 | 29490 | 41 | ||
53176 | 14843 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1320 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002817.8815 | 2111683.4502 | 37.7784393862348 | -122.433816657579 | (37.7784393862348, -122.433816657579) | 15 | 5 | 11 | 29490 | 41 | ||
53336 | 17515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002425.76888 | 2091174.41595 | 37.7221041784351 | -122.433706937351 | (37.7221041784351, -122.433706937351) | 9 | 7 | 6 | 28861 | 5 | |||
53646 | 7509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2737 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008336.68586 | 2102472.1775 | 37.7534589921577 | -122.414073147974 | (37.7534589921577, -122.414073147974) | 2 | 4 | 7 | 28859 | 19 | |||
53797 | 200600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | 10 | 3 | 8 | 58 | 1 | |||
54013 | 17571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003526.33065 | 2090483.75414 | 37.7202701612065 | -122.429853326536 | (37.7202701612065, -122.429853326536) | 9 | 7 | 6 | 28861 | 5 | |||
55145 | 119750 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
55149 | 97435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.7329510434152 | -122.385341956131 | (37.7329510434152, -122.385341956131) | 10 | 3 | 8 | 58 | 1 | |||
55547 | 7559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2915 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008391.20659 | 2101423.19839 | 37.750581793832 | -122.413810408316 | (37.750581793832, -122.413810408316) | 2 | 4 | 7 | 28859 | 19 | |||
55922 | 109169 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 6 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
56148 | 246538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | 7 | 9 | 11 | 28852 | 10 | |||
56457 | 23641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 10 | 3X3 | 6006567.62834 | 2098529.44793 | 37.7425336313356 | -122.419911178867 | (37.7425336313356, -122.419911178867) | 2 | 7 | 7 | 28859 | 2 | ||
57103 | 16428 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 11 | 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 | |||
57212 | 7663 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3343 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008519.81594 | 2099195.42015 | 37.744472032765 | -122.413208149458 | (37.744472032765, -122.413208149458) | 2 | 7 | 7 | 28859 | 2 | |||
57589 | 119826 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
58374 | 18022 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2726 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/1994 12:00:00 AM | 18 | 3X3 | 6000886.2670207 | 2114885.2948521 | 37.7871210317525 | -122.44072855159 | (37.7871210317525, -122.44072855159) | 13 | 6 | 1 | 29490 | 27 | ||
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 | |||
58794 | 7638 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6008420.15681 | 2099616.94183 | 37.7456238423258 | -122.413582558723 | (37.7456238423258, -122.413582558723) | 2 | 7 | 7 | 28859 | 2 | |||
59252 | 244309 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005567.5189 | 2110582.8218 | 37.7755729745028 | -122.424226319105 | (37.7755729745028, -122.424226319105) | 7 | 9 | 11 | 28852 | 10 | |||
59632 | 17589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503 | -122.42930461652 | (37.720035114503, -122.42930461652) | 9 | 7 | 6 | 28861 | 5 | |||
59722 | 17586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003709.25966 | 2090367.07531 | 37.7199601443381 | -122.429212686015 | (37.7199601443381, -122.429212686015) | 9 | 7 | 6 | 28861 | 5 | |||
60158 | 244357 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005584.9883 | 2110453.4536 | 37.7752187471852 | -122.424156685679 | (37.7752187471852, -122.424156685679) | 7 | 9 | 11 | 28852 | 10 | |||
60340 | 17536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.7211479104352 | -122.431654537837 | (37.7211479104352, -122.431654537837) | 9 | 7 | 6 | 28861 | 5 | |||
60434 | 7582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
60750 | 18003 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2676 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001111.97407 | 2114914.60088 | 37.7872143495752 | -122.439949758664 | (37.7872143495752, -122.439949758664) | 13 | 6 | 1 | 29490 | 27 | |||
61112 | 1325 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4051X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5991764.76245 | 2086963.37686 | 37.7099309898835 | -122.470252581934 | (37.7099309898835, -122.470252581934) | 9 | 8 | 4 | 64 | 24 | |||
61263 | 16420 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016497.09656 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | 10 | 3 | 8 | 58 | 1 | |||
61325 | 244354 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005594.4313 | 2110381.2151 | 37.7750209309426 | -122.424118881689 | (37.7750209309426, -122.424118881689) | 7 | 9 | 11 | 28852 | 10 | |||
61681 | 7659 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3339 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008524.12376 | 2099222.60541 | 37.7445469193178 | -122.413195175821 | (37.7445469193178, -122.413195175821) | 2 | 7 | 7 | 28859 | 2 | |||
61874 | 17917 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2370 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002602.4145 | 2115123.2744 | 37.7878720449725 | -122.43480808996 | (37.7878720449725, -122.43480808996) | 13 | 9 | 1 | 29490 | 27 | |||
61943 | 94631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3359X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008508.32058 | 2099227.63825 | 37.7445598511663 | -122.413250176052 | (37.7445598511663, -122.413250176052) | 2 | 7 | 7 | 28859 | 2 | |||
62430 | 16676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 241 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6002923.72472 | 2106883.15367 | 37.7652649601376 | -122.433107441172 | (37.7652649601376, -122.433107441172) | 15 | 5 | 5 | 28862 | 3 | |||
62456 | 7443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2534 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008210.94059 | 2103665.03858 | 37.7567272543663 | -122.414592409333 | (37.7567272543663, -122.414592409333) | 2 | 4 | 7 | 28859 | 19 | |||
62831 | 25173 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3062 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6000161.42067 | 2105438.61683 | 37.7611415415605 | -122.44255784368 | (37.7611415415605, -122.44255784368) | 15 | 5 | 5 | 28862 | 3 |
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) );