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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63420 | 18052 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2840 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000317.799 | 2114808.7133 | 37.7868783690408 | -122.442689819484 | (37.7868783690408, -122.442689819484) | 13 | 6 | 1 | 29490 | 27 | |||
| 63979 | 17601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6003845.6513541 | 2090290.953545 | 37.7197588510105 | -122.428735803294 | (37.7197588510105, -122.428735803294) | 9 | 7 | 6 | 28861 | 5 | |||
| 64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
| 64445 | 17617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | 9 | 7 | 6 | 28861 | 5 | |||
| 65181 | 26273 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 9 | 3X3 | 6006790.88974 | 2098369.36034 | 37.742106642199 | -122.419127852295 | (37.742106642199, -122.419127852295) | 2 | 7 | 7 | 28859 | 2 | ||
| 65768 | 255467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
| 66323 | 17517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002447.6310917 | 2091110.4885814 | 37.7219298886661 | -122.433626798632 | (37.7219298886661, -122.433626798632) | 9 | 7 | 6 | 28861 | 5 | |||
| 66328 | 14852 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1352 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002495.37076 | 2111698.57744 | 37.7784626155286 | -122.434933424277 | (37.7784626155286, -122.434933424277) | 15 | 5 | 11 | 29490 | 41 | ||
| 66876 | 85884 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2994 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | 6008392 | 2100977 | 37.7493566776481 | -122.41377610663 | (37.7493566776481, -122.41377610663) | 2 | 4 | 7 | 28859 | 19 | ||
| 66993 | 244411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6005560.024 | 2110238.8403 | 37.7746280615118 | -122.424227776164 | (37.7746280615118, -122.424227776164) | 7 | 9 | 11 | 28852 | 10 | |||
| 68996 | 119785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 70010 | 14840 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 3 | 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 | ||
| 70024 | 246553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6005726.46493 | 2109532.06592 | 37.7726968262309 | -122.423601762727 | (37.7726968262309, -122.423601762727) | 7 | 9 | 11 | 28852 | 10 | |||
| 70359 | 16431 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6016292.5361 | 2094929.44377 | 37.7331918315913 | -122.386034103828 | (37.7331918315913, -122.386034103828) | 10 | 3 | 8 | 58 | 1 | |||
| 70773 | 14839 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 5 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.433664099691 | (37.7783201948721, -122.433664099691) | 15 | 5 | 11 | 29492 | 41 | ||
| 71134 | 17624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | 9 | 7 | 6 | 28861 | 5 | |||
| 71414 | 17582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.429028371762 | (37.7199031291015, -122.429028371762) | 9 | 7 | 6 | 28861 | 5 | |||
| 72628 | 244361 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | 7 | 9 | 11 | 28852 | 10 | |||
| 72750 | 7427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2507 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008260.80742 | 2103776.26176 | 37.7570354493563 | -122.414427820801 | (37.7570354493563, -122.414427820801) | 2 | 4 | 7 | 28859 | 19 | |||
| 72945 | 104450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
| 73186 | 119818 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 73466 | 85777 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1355 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008992.8894 | 2109607.7576 | 37.7730884926028 | -122.412308154132 | (37.7730884926028, -122.412308154132) | 8 | 2 | 9 | 28853 | 34 | ||
| 73784 | 17543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 531 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002997.1960546 | 2090824.1673225 | 37.7211748813523 | -122.431706660652 | (37.7211748813523, -122.431706660652) | 9 | 7 | 6 | 28861 | 5 | |||
| 74389 | 104447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
| 74412 | 244259 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) | 7 | 9 | 11 | 28852 | 10 | |||
| 74986 | 244345 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005607.2268 | 2109894.3659 | 37.7736848832921 | -122.424039990106 | (37.7736848832921, -122.424039990106) | 7 | 9 | 11 | 28852 | 10 | |||
| 75183 | 7568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2941 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008397.77442 | 2101269.6431 | 37.7501605343002 | -122.413776835747 | (37.7501605343002, -122.413776835747) | 2 | 4 | 7 | 28859 | 19 | |||
| 75234 | 13323 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
| 75473 | 244305 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.7753208695982 | -122.424177304818 | (37.7753208695982, -122.424177304818) | 7 | 9 | 11 | 28852 | 10 | |||
| 76143 | 138805 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | 13 | 9 | 11 | 29490 | 27 | |||
| 76640 | 17926 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/2015 11:29:00 AM | 3 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | ||
| 76811 | 244287 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005585.9927 | 2110033.382 | 37.7740653890161 | -122.424123330561 | (37.7740653890161, -122.424123330561) | 7 | 9 | 11 | 28852 | 10 | |||
| 77310 | 119820 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 77425 | 85855 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008286.9019 | 2109012.2565 | 37.771413745293 | -122.414708111421 | (37.771413745293, -122.414708111421) | 8 | 2 | 9 | 28853 | 19 | ||
| 77462 | 7652 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3316 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008450.59192 | 2099314.52137 | 37.7447951717692 | -122.413455934253 | (37.7447951717692, -122.413455934253) | 2 | 7 | 7 | 28859 | 2 | |||
| 77742 | 7573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2969X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008400.46895 | 2101159.93411 | 37.7498594493293 | -122.413759758659 | (37.7498594493293, -122.413759758659) | 2 | 4 | 7 | 28859 | 19 | |||
| 77972 | 119824 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 78440 | 17954 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
| 78776 | 2242 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2799X PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000783 | 2114845 | 37.7870045110932 | -122.441082939895 | (37.7870045110932, -122.441082939895) | 13 | 6 | 1 | 29490 | 27 | |||
| 79927 | 7583 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 3 | 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 | |||
| 80215 | 119712 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 80886 | 17538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4x7.5 | 6002931.4135505 | 2090865.5085081 | 37.7212846660211 | -122.431937002131 | (37.7212846660211, -122.431937002131) | 9 | 7 | 6 | 28861 | 5 | |||
| 81012 | 18524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 6x9 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
| 81071 | 14859 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1368 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002630 | 2111671 | 37.7783945378775 | -122.434465719206 | (37.7783945378775, -122.434465719206) | 15 | 5 | 11 | 29490 | 41 | ||
| 81285 | 244426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.7733541831734 | -122.423776541571 | (37.7733541831734, -122.423776541571) | 7 | 9 | 11 | 28852 | 10 | |||
| 81510 | 17570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003493.5133628 | 2090512.2555079 | 37.7203465611878 | -122.429968797048 | (37.7203465611878, -122.429968797048) | 9 | 7 | 6 | 28861 | 5 | |||
| 82338 | 7451 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2550 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6008217.64578 | 2103538.04814 | 37.756378944247 | -122.414560234263 | (37.756378944247, -122.414560234263) | 2 | 4 | 7 | 28859 | 19 | |||
| 82484 | 7569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2951 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5x5 | 6008400.77269 | 2101230.49082 | 37.750053199295 | -122.413763698449 | (37.750053199295, -122.413763698449) | 2 | 4 | 7 | 28859 | 19 | |||
| 82587 | 17597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 844 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003772.37846 | 2090279.52588 | 37.7197233258537 | -122.428988267402 | (37.7197233258537, -122.428988267402) | 9 | 7 | 6 | 28861 | 5 | |||
| 83454 | 7570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2960 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008348.00397 | 2101217.60001 | 37.7500148405247 | -122.413945264386 | (37.7500148405247, -122.413945264386) | 2 | 4 | 7 | 28859 | 19 | |||
| 83733 | 17620 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
| 84532 | 244398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005622.6544 | 2110184.6115 | 37.7744826985313 | -122.42400726776 | (37.7744826985313, -122.42400726776) | 7 | 9 | 11 | 28852 | 10 | |||
| 84788 | 7632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
| 84842 | 244328 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | 7 | 9 | 11 | 28852 | 10 | |||
| 85012 | 119676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 85286 | 242541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2430 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2007 12:00:00 AM | 5 | Width 4ft | 6008178.84704 | 2104258.05912 | 37.7583537502521 | -122.414745367819 | (37.7583537502521, -122.414745367819) | 2 | 4 | 7 | 28859 | 19 | ||
| 85661 | 17503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002145.06129 | 2091350.82839 | 37.7225726352947 | -122.434689881929 | (37.7225726352947, -122.434689881929) | 9 | 7 | 6 | 28861 | 5 | |||
| 85677 | 7618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3220 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008417.3382 | 2100000.01062 | 37.7466755057898 | -122.413619394131 | (37.7466755057898, -122.413619394131) | 2 | 7 | 7 | 28859 | 2 | |||
| 85836 | 244364 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005534.4686 | 2110345.8041 | 37.7749203151844 | -122.424323786781 | (37.7749203151844, -122.424323786781) | 7 | 9 | 11 | 28852 | 10 | |||
| 85844 | 119675 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 86019 | 17537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/1999 12:00:00 AM | 3 | 3x3 | 6002961.1307 | 2090844.10696 | 37.7212275867697 | -122.431832751099 | (37.7212275867697, -122.431832751099) | 9 | 7 | 6 | 28861 | 5 | ||
| 86911 | 244468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | 7 | 9 | 11 | 28852 | 10 | |||
| 87031 | 85761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009463.2457 | 2110145.8929 | 37.7745924689532 | -122.410719136445 | (37.7745924689532, -122.410719136445) | 8 | 2 | 9 | 28853 | 34 | ||
| 87166 | 16411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
| 87426 | 17516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002342.1367821 | 2091235.8408171 | 37.7222680914982 | -122.434000421261 | (37.7222680914982, -122.434000421261) | 9 | 7 | 6 | 28861 | 5 | |||
| 87498 | 7535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2840 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2011 12:00:00 AM | 18 | 5x5 | 6008283 | 2101875 | 37.7518162620418 | -122.414216558168 | (37.7518162620418, -122.414216558168) | 2 | 4 | 7 | 28859 | 19 | ||
| 87612 | 244235 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | 7 | 9 | 11 | 28852 | 10 | |||
| 87801 | 244358 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | 7 | 9 | 11 | 28852 | 10 | |||
| 87894 | 244467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005631.8918 | 2109690.1946 | 37.7731256707262 | -122.423940148458 | (37.7731256707262, -122.423940148458) | 7 | 9 | 11 | 28852 | 10 | |||
| 88042 | 244423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | 7 | 9 | 11 | 28852 | 10 | |||
| 88227 | 17627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2005 12:00:00 AM | 3 | 3X3 | 6004380.7126814 | 2089954.6929998 | 37.718865821274 | -122.426862349848 | (37.718865821274, -122.426862349848) | 9 | 7 | 6 | 28861 | 5 | ||
| 88819 | 7597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3106 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008396.4425 | 2100409.14848 | 37.7477977337818 | -122.413720584051 | (37.7477977337818, -122.413720584051) | 2 | 7 | 7 | 28859 | 2 | |||
| 89387 | 20253 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2408X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002406.879304 | 2115096.2004906 | 37.7877866035807 | -122.435482667209 | (37.7877866035807, -122.435482667209) | 13 | 6 | 1 | 29490 | 27 | |||
| 89789 | 244330 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.423838604142 | (37.7736448835433, -122.423838604142) | 7 | 9 | 11 | 28852 | 10 | |||
| 89957 | 119827 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 90769 | 85756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 956 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011236.2364 | 2111841.2613 | 37.7793468061687 | -122.404705356954 | (37.7793468061687, -122.404705356954) | 14 | 2 | 9 | 28853 | 34 | ||
| 90891 | 17497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.434919765734 | (37.7226823390961, -122.434919765734) | 9 | 7 | 6 | 28861 | 5 | |||
| 91210 | 14841 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 4 | 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 | ||
| 91540 | 7563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2928 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2011 12:00:00 AM | 3 | 3x3 | 6008338.37893 | 2101340.84965 | 37.7503527158034 | -122.413987266292 | (37.7503527158034, -122.413987266292) | 2 | 4 | 7 | 28859 | 19 | ||
| 91679 | 17550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6003170.84982 | 2090661.1447 | 37.7207370992233 | -122.431094760237 | (37.7207370992233, -122.431094760237) | 9 | 7 | 6 | 28861 | 5 | |||
| 91687 | 17522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 307 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6002546.66743 | 2091098.28956 | 37.7219020117492 | -122.433283584179 | (37.7219020117492, -122.433283584179) | 9 | 7 | 6 | 28861 | 5 | |||
| 91990 | 7608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3201X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6008473.46462 | 2100066.10981 | 37.7468601509795 | -122.413429987917 | (37.7468601509795, -122.413429987917) | 2 | 7 | 7 | 28859 | 2 | |||
| 92198 | 254243 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
| 92927 | 17581 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003766.78664 | 2090331.92818 | 37.7198668945342 | -122.429011330508 | (37.7198668945342, -122.429011330508) | 9 | 7 | 6 | 28861 | 5 | |||
| 93103 | 17933 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002186.7609 | 2115068.0006 | 37.7876966699691 | -122.436242215333 | (37.7876966699691, -122.436242215333) | 13 | 6 | 1 | 29490 | 27 | |||
| 93167 | 91037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.406498774175 | (37.7776845332645, -122.406498774175) | 14 | 2 | 9 | 28853 | 34 | ||
| 93532 | 17520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/1998 12:00:00 AM | 18 | 3x3 | 6002494.30852 | 2091085.91322 | 37.7218650586013 | -122.433463691421 | (37.7218650586013, -122.433463691421) | 9 | 7 | 6 | 28861 | 5 | ||
| 93625 | 7636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3268 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008436.93734 | 2099674.20606 | 37.7457820194342 | -122.41352858329 | (37.7457820194342, -122.41352858329) | 2 | 7 | 7 | 28859 | 2 | |||
| 93680 | 17549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003191.59323 | 2090648.1169 | 37.7207025031963 | -122.431022127369 | (37.7207025031963, -122.431022127369) | 9 | 7 | 6 | 28861 | 5 | |||
| 93874 | 109171 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 94085 | 5928 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1335 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | |||
| 94502 | 20254 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2408X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002391.32422 | 2115095.87148 | 37.7877848167493 | -122.435536461248 | (37.7877848167493, -122.435536461248) | 13 | 6 | 1 | 29490 | 27 | |||
| 94852 | 13322 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
| 95773 | 244344 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005605.8565 | 2109917.6606 | 37.7737487675431 | -122.424046387097 | (37.7737487675431, -122.424046387097) | 7 | 9 | 11 | 28852 | 10 | |||
| 97015 | 7585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
| 97054 | 11630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991380.578 | 2094219.03 | 37.7298310098579 | -122.472108899465 | (37.7298310098579, -122.472108899465) | 9 | 8 | 4 | 64 | 40 | |||
| 97426 | 17495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002027.05349 | 2091378.72089 | 37.722642521628 | -122.43509980193 | (37.722642521628, -122.43509980193) | 9 | 7 | 6 | 28861 | 5 | |||
| 98114 | 7631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
| 98216 | 119713 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 99141 | 18008 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X4 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 |
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) );