trees
213 rows where SiteOrder = 3 and qSpecies_id = 31 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7980 | 260398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 8784 | 46303 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 118544 | 11877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
| 152862 | 180514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 4ft | 6004210.58168 | 2090053.82189 | 37.7191283865346 | -122.427457483699 | (37.7191283865346, -122.427457483699) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 144805 | 17610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004083.79011 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | 9 | 7 | 6 | 28861 | 5 | |||
| 44226 | 180517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004131.62894 | 2090104.37161 | 37.7192627191689 | -122.427733992853 | (37.7192627191689, -122.427733992853) | 9 | 7 | 6 | 28861 | 5 | |||
| 169347 | 17613 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
| 64697 | 180520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6003878.61607 | 2090266.0202 | 37.7196922551652 | -122.428620079558 | (37.7196922551652, -122.428620079558) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 157561 | 17579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003783.82433 | 2090321.42028 | 37.7198390065544 | -122.428951688396 | (37.7198390065544, -122.428951688396) | 9 | 7 | 6 | 28861 | 5 | |||
| 25169 | 17576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.7201172080443 | -122.429795147634 | (37.7201172080443, -122.429795147634) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 160933 | 180523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003530.18037 | 2090485.12312 | 37.720274138132 | -122.429840116925 | (37.720274138132, -122.429840116925) | 9 | 7 | 6 | 28861 | 5 | |||
| 152147 | 17565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.7204299915223 | -122.430159579516 | (37.7204299915223, -122.430159579516) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 8303 | 180530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
| 122734 | 17534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 3 | 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 | |||
| 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 | |||
| 141496 | 180533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 401 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002751.65611 | 2090978.09371 | 37.7215836076762 | -122.432566409917 | (37.7215836076762, -122.432566409917) | 9 | 7 | 6 | 28861 | 5 | |||
| 103898 | 17519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6002513.47081 | 2091072.78557 | 37.7218301001725 | -122.433396514735 | (37.7218301001725, -122.433396514735) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 77576 | 180549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002285.83786 | 2091218.55546 | 37.7222174345718 | -122.43419379793 | (37.7222174345718, -122.43419379793) | 9 | 7 | 6 | 28861 | 5 | |||
| 88381 | 180555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.7222422225842 | -122.433987296498 | (37.7222422225842, -122.433987296498) | 9 | 7 | 6 | 28861 | 5 | |||
| 192768 | 17485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
| 173125 | 17509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 209 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6002301.24651 | 2091251.1556 | 37.7223078217962 | -122.434142863321 | (37.7223078217962, -122.434142863321) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 160710 | 180536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010343.05054 | 2092296.39853 | 37.7256309795628 | -122.406417719414 | (37.7256309795628, -122.406417719414) | 10 | 3 | 7 | 309 | 28 | |||
| 109770 | 201908 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.394643789789 | (37.7284270698286, -122.394643789789) | 10 | 3 | 8 | 58 | 1 | |||
| 125652 | 117152 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.7285509455903 | -122.389513905896 | (37.7285509455903, -122.389513905896) | 10 | 3 | 8 | 58 | 1 | |||
| 2974 | 260217 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010872 | 2093992 | 37.7303163237311 | -122.404708489988 | (37.7303163237311, -122.404708489988) | 10 | 3 | 7 | 309 | 28 | ||||
| 83633 | 200746 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | 10 | 3 | 8 | 58 | 1 | |||
| 86976 | 22316 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
| 69763 | 200749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | 10 | 3 | 8 | 58 | 1 | |||
| 160975 | 16434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1299X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 111256 | 16440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 30156 | 198691 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016677.93992 | 2094927.14945 | 37.7332068541071 | -122.384701486 | (37.7332068541071, -122.384701486) | 10 | 3 | 8 | 58 | 1 | |||
| 90577 | 198693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016661.34411 | 2095009.85168 | 37.733433020107 | -122.384764621992 | (37.733433020107, -122.384764621992) | 10 | 3 | 8 | 58 | 1 | |||
| 21183 | 254244 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
| 62676 | 32534 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
| 84939 | 200792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.7358498081793 | -122.389034132513 | (37.7358498081793, -122.389034132513) | 10 | 3 | 8 | 58 | 1 | |||
| 29698 | 242600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002217.82403 | 2096159.00983 | 37.7357789394319 | -122.434782025597 | (37.7357789394319, -122.434782025597) | 2 | 7 | 5 | 63 | 7 | |||
| 34642 | 198561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014636.30194 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | 10 | 3 | 8 | 58 | 1 | |||
| 125460 | 198527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014634.66691 | 2096168.32121 | 37.7365016436308 | -122.391852449756 | (37.7365016436308, -122.391852449756) | 10 | 3 | 8 | 58 | 1 | |||
| 78591 | 198554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | : | Tree | Private 2 | 2 | Width 0ft | 6014551.87687 | 2096170.80222 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | 10 | 3 | 8 | 58 | 1 | |||
| 37774 | 111106 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199X Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6002254 | 2096173 | 37.7358194070146 | -122.43465795136 | (37.7358194070146, -122.43465795136) | 2 | 7 | 5 | 63 | 7 | |||
| 152752 | 215513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993924.28661 | 2096292.23015 | 37.7356703813878 | -122.463465470563 | (37.7356703813878, -122.463465470563) | 9 | 8 | 4 | 59 | 40 | |||
| 30298 | 215566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.7357680072927 | -122.463427186434 | (37.7357680072927, -122.463427186434) | 9 | 8 | 4 | 59 | 40 | |||
| 169600 | 215560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994063.02887 | 2096405.49286 | 37.7359893655189 | -122.462994003686 | (37.7359893655189, -122.462994003686) | 9 | 8 | 4 | 59 | 40 | |||
| 137860 | 215557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994081.97838 | 2096463.44747 | 37.7361495860356 | -122.462932691498 | (37.7361495860356, -122.462932691498) | 9 | 8 | 4 | 59 | 40 | |||
| 3611 | 242616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Highland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
| 166644 | 242459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 434 Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008569.03881 | 2096702.15608 | 37.7376288403924 | -122.412861705413 | (37.7376288403924, -122.412861705413) | 10 | 7 | 7 | 28859 | 2 | |||
| 40289 | 215500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618 | -122.463015880573 | (37.736806354618, -122.463015880573) | 9 | 8 | 4 | 59 | 40 | |||
| 172603 | 215549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994024.47246 | 2096717.64037 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | 9 | 8 | 4 | 59 | 40 | |||
| 170664 | 215542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993945.30252 | 2097292.64109 | 37.7384184721345 | -122.463465388735 | (37.7384184721345, -122.463465388735) | 1 | 8 | 4 | 59 | 40 | |||
| 122804 | 215495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 69 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993977.51854 | 2097401.11032 | 37.7387181577226 | -122.463361871354 | (37.7387181577226, -122.463361871354) | 1 | 8 | 4 | 59 | 40 | |||
| 175468 | 23643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6006665.30474 | 2098482.56394 | 37.7424104008083 | -122.419570116381 | (37.7424104008083, -122.419570116381) | 2 | 7 | 7 | 28859 | 2 | ||
| 129503 | 183427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2419 22nd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5989498.023 | 2098855.9096 | 37.7424535651362 | -122.478956057135 | (37.7424535651362, -122.478956057135) | 1 | 8 | 3 | 29491 | 35 | |||
| 140465 | 7662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x4 | 6008466.34336 | 2099149.15248 | 37.7443419898261 | -122.413389775903 | (37.7443419898261, -122.413389775903) | 2 | 7 | 7 | 28859 | 2 | |||
| 179870 | 112877 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 300x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x2 | 6010100 | 2099291 | 37.7448230609493 | -122.407750909418 | (37.7448230609493, -122.407750909418) | 2 | 7 | 7 | 28859 | 2 | |||
| 193847 | 7630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008486.33548 | 2099778.1775 | 37.7460702755308 | -122.413365122515 | (37.7460702755308, -122.413365122515) | 2 | 7 | 7 | 28859 | 2 | |||
| 180073 | 7610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3201X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008468.12704 | 2100135.33382 | 37.7470499250079 | -122.413453339725 | (37.7470499250079, -122.413453339725) | 2 | 7 | 7 | 28859 | 2 | |||
| 44141 | 242625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3198X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008400.82271 | 2100348.16336 | 37.747630528223 | -122.413701124526 | (37.747630528223, -122.413701124526) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 31801 | 242443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1331 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003922.38967 | 2100509.16496 | 37.7478200945407 | -122.429198764536 | (37.7478200945407, -122.429198764536) | 2 | 4 | 5 | 63 | 22 | |||
| 106451 | 18526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
| 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 | |||
| 107317 | 242514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2948 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008345.17157 | 2101253.04618 | 37.7501120086795 | -122.413957566206 | (37.7501120086795, -122.413957566206) | 2 | 4 | 7 | 28859 | 19 | |||
| 114039 | 44114 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
| 171620 | 87306 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 192321 | 242417 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3652 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005352.57915 | 2101976.52488 | 37.7519299863868 | -122.424357585351 | (37.7519299863868, -122.424357585351) | 2 | 4 | 5 | 28859 | 19 | |||
| 149987 | 242679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 381 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003962.28874 | 2102142.64479 | 37.7523075073868 | -122.429177250923 | (37.7523075073868, -122.429177250923) | 2 | 4 | 5 | 28862 | 22 | |||
| 61272 | 608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6008346.15887 | 2102213.06871 | 37.7527480699909 | -122.414022059281 | (37.7527480699909, -122.414022059281) | 2 | 4 | 7 | 28859 | 19 | |||
| 150045 | 242592 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4412 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000533.60664 | 2102299.68252 | 37.752544002129 | -122.44104541512 | (37.752544002129, -122.44104541512) | 2 | 4 | 5 | 28862 | 22 | |||
| 118124 | 242675 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3995 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003246.40491 | 2102411.67746 | 37.7530056556116 | -122.43167209619 | (37.7530056556116, -122.43167209619) | 2 | 4 | 5 | 28862 | 22 | |||
| 99200 | 242647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008809.14525 | 2102757.20392 | 37.7542681355747 | -122.412459422473 | (37.7542681355747, -122.412459422473) | 2 | 4 | 7 | 28859 | 19 | |||
| 90005 | 7488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6008316.60225 | 2102810.93946 | 37.7543880278024 | -122.414166566835 | (37.7543880278024, -122.414166566835) | 2 | 4 | 7 | 28859 | 19 | |||
| 184440 | 242655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 502 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001805.86123 | 2102847.44693 | 37.7541204147416 | -122.436684955058 | (37.7541204147416, -122.436684955058) | 2 | 4 | 5 | 28862 | 22 | |||
| 6749 | 242499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008244.84467 | 2103100.98301 | 37.7551803907701 | -122.414435245603 | (37.7551803907701, -122.414435245603) | 2 | 4 | 7 | 28859 | 19 | |||
| 102300 | 113801 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 806 SHOTWELL ST | 3 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 119476 | 98272 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | ||
| 48109 | 242378 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005393.3739 | 2103473.26085 | 37.7560419790638 | -122.424322955135 | (37.7560419790638, -122.424322955135) | 2 | 4 | 5 | 28859 | 19 | |||
| 157109 | 3749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 934 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012421.5071398 | 2103592.6632765 | 37.756764184951 | -122.400025556542 | (37.756764184951, -122.400025556542) | 10 | 3 | 8 | 28856 | 29 | |||
| 25561 | 101710 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
| 51129 | 242492 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2507 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6008258.15624 | 2103821.5698 | 37.7571597059716 | -122.414440195483 | (37.7571597059716, -122.414440195483) | 2 | 4 | 7 | 28859 | 19 | |||
| 79500 | 242723 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 291 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004435.5728 | 2103937.20176 | 37.7572617205823 | -122.42766840527 | (37.7572617205823, -122.42766840527) | 2 | 4 | 5 | 28862 | 3 | |||
| 107524 | 97834 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 127376 | 105993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015232.0353 | 2104000.80366 | 37.7580411495011 | -122.390334151305 | (37.7580411495011, -122.390334151305) | 10 | 3 | 8 | 28856 | 29 | |||
| 129944 | 115551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.390190372193 | (37.7585616474178, -122.390190372193) | 10 | 3 | 8 | 28856 | 29 | ||
| 142251 | 198484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6015200.57665 | 2104577.87924 | 37.7596239302292 | -122.390483271483 | (37.7596239302292, -122.390483271483) | 10 | 3 | 8 | 28856 | 29 | |||
| 28621 | 198494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015476.06266 | 2104658.66701 | 37.7598610346751 | -122.389536136987 | (37.7598610346751, -122.389536136987) | 10 | 3 | 8 | 28856 | 29 | |||
| 77331 | 198504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 785 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011870.75445 | 2104712.89725 | 37.7598093776163 | -122.402009022396 | (37.7598093776163, -122.402009022396) | 10 | 3 | 8 | 28856 | 29 | |||
| 74815 | 198475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015192.04095 | 2104775.13196 | 37.7601650702756 | -122.390526575643 | (37.7601650702756, -122.390526575643) | 10 | 3 | 8 | 28856 | 29 | |||
| 175777 | 242603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5999039.00902 | 2105211.58372 | 37.7604541213822 | -122.446423435607 | (37.7604541213822, -122.446423435607) | 15 | 5 | 5 | 28862 | 12 | |||
| 38103 | 242736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6000751.24207 | 2105647.23063 | 37.761747947223 | -122.440532872599 | (37.761747947223, -122.440532872599) | 15 | 5 | 5 | 28862 | 3 | |||
| 126663 | 198465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015348.3409 | 2105766.19544 | 37.7628949866348 | -122.390055238278 | (37.7628949866348, -122.390055238278) | 14 | 3 | 8 | 28856 | 29 | |||
| 20869 | 198471 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015348.95336 | 2105815.25959 | 37.7630297401524 | -122.390056547668 | (37.7630297401524, -122.390056547668) | 14 | 3 | 8 | 28856 | 29 | |||
| 142223 | 103419 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 |
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) );