trees
2,365 rows where qSpecies_id = 31 sorted by Neighborhoods (old)
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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23894 | 200745 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014683.7532 | 2094550.1103 | 37.7320610911002 | -122.391569635286 | (37.7320610911002, -122.391569635286) | 10 | 3 | 8 | 58 | 1 | |||
| 27268 | 16442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 5 | 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 | |||
| 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 | |||
| 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 | |||
| 35787 | 198528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014599.09575 | 2096195.70079 | 37.7365748475583 | -122.391977349386 | (37.7365748475583, -122.391977349386) | 10 | 3 | 8 | 58 | 1 | |||
| 36858 | 22315 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 2 | 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 | |||
| 38292 | 200627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1360 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016371.342 | 2094881.4594 | 37.7330644372172 | -122.385758304658 | (37.7330644372172, -122.385758304658) | 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 | |||
| 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 | |||
| 41088 | 198525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014663.37225 | 2096146.01075 | 37.736441977204 | -122.391751642923 | (37.736441977204, -122.391751642923) | 10 | 3 | 8 | 58 | 1 | |||
| 41378 | 198530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014455.10696 | 2096302.51395 | 37.7368601394856 | -122.392482653249 | (37.7368601394856, -122.392482653249) | 10 | 3 | 8 | 58 | 1 | |||
| 41660 | 198529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 Newcomb Ave | 2 | : | Tree | Private 2 | 7 | Width 7ft | 6014569.28946 | 2096208.90311 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 47966 | 173668 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014587 | 2096103 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | 10 | 3 | 8 | 58 | 1 | ||||
| 49082 | 198557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014596.8944 | 2096198.85091 | 37.7365833749264 | -122.391985180675 | (37.7365833749264, -122.391985180675) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 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 | |||
| 54742 | 200631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1354 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016389.5518 | 2094874.5522 | 37.7330464790647 | -122.385694866729 | (37.7330464790647, -122.385694866729) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 61858 | 200580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1330 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016475.5774 | 2094870.1567 | 37.7330391696694 | -122.385397144532 | (37.7330391696694, -122.385397144532) | 10 | 3 | 8 | 58 | 1 | |||
| 62302 | 198549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1742 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6014473.93082 | 2096284.01772 | 37.7368103979679 | -122.392416277009 | (37.7368103979679, -122.392416277009) | 10 | 3 | 8 | 58 | 1 | |||
| 62432 | 201912 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 67211 | 198540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014330.01059 | 2096395.83153 | 37.7371094225658 | -122.392921696874 | (37.7371094225658, -122.392921696874) | 10 | 3 | 8 | 58 | 1 | |||
| 68160 | 201911 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.7283501238417 | -122.394511693764 | (37.7283501238417, -122.394511693764) | 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 | |||
| 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 | |||
| 75492 | 198515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1799 Newcomb Ave | 1 | : | Tree | Private 2 | 6 | Width 7ft | 6014195.4851 | 2096428.16661 | 37.7371907347515 | -122.39338907817 | (37.7371907347515, -122.39338907817) | 10 | 3 | 8 | 58 | 1 | |||
| 76662 | 198550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6014437.8332 | 2096238.23141 | 37.7366826735549 | -122.392537881536 | (37.7366826735549, -122.392537881536) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 87526 | 200759 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1628 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014603.9551 | 2094093.5604 | 37.7308030679401 | -122.391813605271 | (37.7308030679401, -122.391813605271) | 10 | 3 | 8 | 58 | 1 | |||
| 88581 | 198542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014379.25839 | 2096358.16964 | 37.7370087461611 | -122.392748789643 | (37.7370087461611, -122.392748789643) | 10 | 3 | 8 | 58 | 1 | |||
| 89896 | 198555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 4 | : | Tree | Private 2 | 6 | Width 0ft | 6014573.39316 | 2096202.10779 | 37.7365910128673 | -122.39206666287 | (37.7365910128673, -122.39206666287) | 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 | |||
| 91124 | 198531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014434.12864 | 2096316.99865 | 37.7368987464799 | -122.392556198035 | (37.7368987464799, -122.392556198035) | 10 | 3 | 8 | 58 | 1 | |||
| 94744 | 198518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6014349.89775 | 2096310.64458 | 37.7368766213595 | -122.392846979413 | (37.7368766213595, -122.392846979413) | 10 | 3 | 8 | 58 | 1 | |||
| 95950 | 198692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.7332997702709 | -122.384585575986 | (37.7332997702709, -122.384585575986) | 10 | 3 | 8 | 58 | 1 | |||
| 97198 | 201906 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6013735.56827 | 2093268.69044 | 37.7284898973927 | -122.394758034254 | (37.7284898973927, -122.394758034254) | 10 | 3 | 8 | 58 | 1 | |||
| 99304 | 22314 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
| 101072 | 201910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.7283734198726 | -122.394550072331 | (37.7283734198726, -122.394550072331) | 10 | 3 | 8 | 58 | 1 | |||
| 101626 | 201907 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | 10 | 3 | 8 | 58 | 1 | |||
| 103111 | 46632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.7285785323655 | -122.389527911332 | (37.7285785323655, -122.389527911332) | 10 | 3 | 8 | 58 | 1 |
| 106040 | 16430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 13 | 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 | |||
| 106373 | 16438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 1 | 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 | |||
| 107965 | 97221 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | 15x200 | 6016689.53805 | 2094986.80633 | 37.733371301443 | -122.384665541907 | (37.733371301443, -122.384665541907) | 10 | 3 | 8 | 58 | 1 | |||
| 108431 | 198532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 1 | : | Tree | Private 2 | 4 | Width 7ft | 6014372.17182 | 2096354.40755 | 37.7369980226381 | -122.392773028173 | (37.7369980226381, -122.392773028173) | 10 | 3 | 8 | 58 | 1 | |||
| 108987 | 16441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 4 | 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 | |||
| 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 | |||
| 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 | |||
| 114660 | 200622 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016290.9677 | 2094932.3213 | 37.7331996459116 | -122.386039726783 | (37.7331996459116, -122.386039726783) | 10 | 3 | 8 | 58 | 1 | |||
| 116534 | 198560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014655.2828 | 2096153.01044 | 37.7364607478562 | -122.391780101069 | (37.7364607478562, -122.391780101069) | 10 | 3 | 8 | 58 | 1 | |||
| 117224 | 198523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1721 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014565.58066 | 2096150.99697 | 37.7364502392755 | -122.392090100993 | (37.7364502392755, -122.392090100993) | 10 | 3 | 8 | 58 | 1 | |||
| 117989 | 198538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1782 Newcomb Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014279.64227 | 2096432.42158 | 37.737207093417 | -122.393098403779 | (37.737207093417, -122.393098403779) | 10 | 3 | 8 | 58 | 1 | |||
| 119015 | 198545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014347.46676 | 2096307.91829 | 37.736869000501 | -122.392855193808 | (37.736869000501, -122.392855193808) | 10 | 3 | 8 | 58 | 1 | |||
| 119302 | 16425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 8 | 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 | |||
| 119811 | 16424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.385712405803 | (37.7330411346315, -122.385712405803) | 10 | 3 | 8 | 58 | 1 | |||
| 121839 | 198694 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016624.01227 | 2094969.82171 | 37.7333210410161 | -122.384890902109 | (37.7333210410161, -122.384890902109) | 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 | |||
| 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 | |||
| 126107 | 16421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016475.45956 | 2094869.09162 | 37.7330362386527 | -122.385397477745 | (37.7330362386527, -122.385397477745) | 10 | 3 | 8 | 58 | 1 | |||
| 126634 | 200579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1324 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016496.9269 | 2094875.1801 | 37.7330541440687 | -122.385323682911 | (37.7330541440687, -122.385323682911) | 10 | 3 | 8 | 58 | 1 | |||
| 126690 | 16415 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 5 | 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 | |||
| 127822 | 16443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 6 | 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 | |||
| 132082 | 198520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 7ft | 6014468.3432 | 2096223.93289 | 37.7366451070745 | -122.392431394602 | (37.7366451070745, -122.392431394602) | 10 | 3 | 8 | 58 | 1 | |||
| 132223 | 198558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014602.58168 | 2096122.38183 | 37.7363737222543 | -122.391960171423 | (37.7363737222543, -122.391960171423) | 10 | 3 | 8 | 58 | 1 | |||
| 134540 | 200744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014678.5205 | 2094530.4879 | 37.7320069215178 | -122.391586354626 | (37.7320069215178, -122.391586354626) | 10 | 3 | 8 | 58 | 1 | |||
| 135776 | 200630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1352 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016410.2733 | 2094871.4126 | 37.7330390049329 | -122.38562300763 | (37.7330390049329, -122.38562300763) | 10 | 3 | 8 | 58 | 1 | |||
| 137869 | 16437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1299X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | |||
| 138460 | 198535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014325.04496 | 2096399.73326 | 37.7371198600908 | -122.392939138341 | (37.7371198600908, -122.392939138341) | 10 | 3 | 8 | 58 | 1 | |||
| 138730 | 198551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1739 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6014460.695 | 2096227.37136 | 37.7366541236867 | -122.392458078374 | (37.7366541236867, -122.392458078374) | 10 | 3 | 8 | 58 | 1 | |||
| 140459 | 198536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1782 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014278.07437 | 2096434.64774 | 37.7372131188949 | -122.393103980488 | (37.7372131188949, -122.393103980488) | 10 | 3 | 8 | 58 | 1 | |||
| 141460 | 198524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014591.36063 | 2096131.83286 | 37.7363990498707 | -122.391999628307 | (37.7363990498707, -122.391999628307) | 10 | 3 | 8 | 58 | 1 | |||
| 142895 | 107048 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1478 UNDERWOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015262.9 | 2093276.2 | 37.7285953185109 | -122.389478448264 | (37.7285953185109, -122.389478448264) | 10 | 3 | 8 | 58 | 1 | |||
| 145100 | 97234 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380X Newcomb Ave | 14 | Median : Cutout | Tree | DPW 1 | 8 | 15x200 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
| 145272 | 22327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.391779193474 | (37.7313174804906, -122.391779193474) | 10 | 3 | 8 | 58 | 1 | |||
| 146179 | 16452 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2000 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 146461 | 16439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 2 | 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 | |||
| 146659 | 97233 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300X Newcomb Ave | 13 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016357.8982 | 2094854.1147 | 37.7329886101989 | -122.385802878589 | (37.7329886101989, -122.385802878589) | 10 | 3 | 8 | 58 | 1 | |||
| 150079 | 16446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 150171 | 198552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6014479.14008 | 2096215.50605 | 37.7366225682648 | -122.392393475605 | (37.7366225682648, -122.392393475605) | 10 | 3 | 8 | 58 | 1 | |||
| 151036 | 16447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 151164 | 198553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1731 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014499.16672 | 2096200.32532 | 37.7365819971662 | -122.392323172901 | (37.7365819971662, -122.392323172901) | 10 | 3 | 8 | 58 | 1 | |||
| 152521 | 113838 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1774 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 15x6 | 6014313.29307 | 2096408.00557 | 37.7371419213669 | -122.392980348878 | (37.7371419213669, -122.392980348878) | 10 | 3 | 8 | 58 | 1 | |||
| 153183 | 198533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014374.32844 | 2096361.30259 | 37.7370170747819 | -122.392766053934 | (37.7370170747819, -122.392766053934) | 10 | 3 | 8 | 58 | 1 | |||
| 155130 | 198516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014335.02638 | 2096322.17337 | 37.7369074510206 | -122.392899203062 | (37.7369074510206, -122.392899203062) | 10 | 3 | 8 | 58 | 1 | |||
| 155817 | 16449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 156325 | 201909 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.394593807271 | (37.728396715017, -122.394593807271) | 10 | 3 | 8 | 58 | 1 | |||
| 157753 | 113837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1731 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 9x6 | 6014502.91741 | 2096197.81168 | 37.7365753034961 | -122.392310029303 | (37.7365753034961, -122.392310029303) | 10 | 3 | 8 | 58 | 1 | |||
| 158203 | 198556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1721 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014562.23913 | 2096154.41154 | 37.7364594294568 | -122.392101892885 | (37.7364594294568, -122.392101892885) | 10 | 3 | 8 | 58 | 1 | |||
| 158613 | 198547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014431.1753 | 2096316.6231 | 37.7368975512817 | -122.392566382859 | (37.7368975512817, -122.392566382859) | 10 | 3 | 8 | 58 | 1 | |||
| 159129 | 198546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6014355.59614 | 2096302.28152 | 37.7368539746257 | -122.392826692499 | (37.7368539746257, -122.392826692499) | 10 | 3 | 8 | 58 | 1 | |||
| 160465 | 198522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1725 Newcomb Ave | 2 | : | Tree | Private 2 | 3 | Width 7ft | 6014552.77288 | 2096169.89847 | 37.7365014278009 | -122.392135704718 | (37.7365014278009, -122.392135704718) | 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 |
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) );