trees
1,196 rows where SiteOrder = 1 and 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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4213 | 251107 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 4570 | 119828 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 10127 | 119793 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 12068 | 26637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X3 | ||||||||||||
| 15738 | 119781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 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) | ||||||||||
| 156235 | 119817 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 166196 | 119736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 147 | 198543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | : | Tree | Private 2 | 3 | Width 0ft | 6014375.16951 | 2096346.21278 | 37.7369756879815 | -122.392762090617 | (37.7369756879815, -122.392762090617) | 10 | 3 | 8 | 58 | 1 | |||
| 20556 | 18546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 166569 | 200790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1582 McKinnon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 6015482.0599 | 2095886.5322 | 37.735774914559 | -122.388902959798 | (37.735774914559, -122.388902959798) | 10 | 3 | 8 | 58 | 1 | |||
| 172207 | 198534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1766 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014341.63524 | 2096385.88519 | 37.7370827576597 | -122.392880809218 | (37.7370827576597, -122.392880809218) | 10 | 3 | 8 | 58 | 1 | |||
| 174948 | 198519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 6014430.37923 | 2096250.75811 | 37.7367166553422 | -122.392564529327 | (37.7367166553422, -122.392564529327) | 10 | 3 | 8 | 58 | 1 | |||
| 175143 | 198548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014451.76229 | 2096301.97796 | 37.7368584820264 | -122.39249417986 | (37.7368584820264, -122.39249417986) | 10 | 3 | 8 | 58 | 1 | |||
| 176709 | 198541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1766 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014350.02594 | 2096380.10361 | 37.7370673486874 | -122.392851394185 | (37.7370673486874, -122.392851394185) | 10 | 3 | 8 | 58 | 1 | |||
| 178532 | 200623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016334.2945 | 2094904.0647 | 37.7331244567265 | -122.385887963991 | (37.7331244567265, -122.385887963991) | 10 | 3 | 8 | 58 | 1 | |||
| 179924 | 26628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | 10 | 3 | 8 | 58 | 1 | ||
| 182324 | 16418 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1992 12:00:00 AM | 13 | 3x3 | 6016308.5496 | 2094919.7628 | 37.7331661358215 | -122.385978065712 | (37.7331661358215, -122.385978065712) | 10 | 3 | 8 | 58 | 1 | ||
| 188083 | 198559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014669.54022 | 2096142.63764 | 37.7364330577276 | -122.391730081702 | (37.7364330577276, -122.391730081702) | 10 | 3 | 8 | 58 | 1 | |||
| 188966 | 198537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1799 Newcomb Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014201.9546 | 2096422.50115 | 37.737175538008 | -122.393366313629 | (37.737175538008, -122.393366313629) | 10 | 3 | 8 | 58 | 1 | |||
| 189621 | 198539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1774 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6014319.22336 | 2096405.90013 | 37.7371364696747 | -122.392959697748 | (37.7371364696747, -122.392959697748) | 10 | 3 | 8 | 58 | 1 | |||
| 192083 | 22309 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5033 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6014806.53085 | 2094754.47288 | 37.7326290435242 | -122.391159442188 | (37.7326290435242, -122.391159442188) | 10 | 3 | 8 | 58 | 1 | |||
| 2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 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 | |||
| 32217 | 242427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005044.68577 | 2109860.00586 | 37.77355876256 | -122.425983461566 | (37.77355876256, -122.425983461566) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 42463 | 30575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.93268 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | 7 | 9 | 11 | 29492 | 10 | |
| 53252 | 244930 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005316.3896 | 2109945.8285 | 37.7738097625345 | -122.425049704262 | (37.7738097625345, -122.425049704262) | 7 | 9 | 11 | 28852 | 10 | |||
| 64742 | 245869 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 265 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005113.693 | 2109858.5889 | 37.7735587716848 | -122.425744654224 | (37.7735587716848, -122.425744654224) | 7 | 9 | 11 | 28852 | 10 | |||
| 64986 | 245225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | Width 0ft | 6005059 | 2109842 | 37.7735101318079 | -122.425932664502 | (37.7735101318079, -122.425932664502) | 7 | 9 | 11 | 28852 | 10 | ||
| 73424 | 242432 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004922.33437 | 2109891.99021 | 37.7736396682718 | -122.426408971312 | (37.7736396682718, -122.426408971312) | 7 | 9 | 11 | 28852 | 10 | |||
| 75735 | 54877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 317 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1972 12:00:00 AM | 4x3 | Permit Number 10739 | 6005042.77490786 | 2109859.41873684 | 37.7735570424684 | -122.425990029724 | (37.7735570424684, -122.425990029724) | 7 | 9 | 11 | 28852 | 10 | ||
| 77852 | 7013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.7743154774203 | -122.435062751747 | (37.7743154774203, -122.435062751747) | 15 | 5 | 11 | 29492 | 10 | ||
| 86066 | 69124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.425679204983 | (37.7760283687547, -122.425679204983) | 7 | 9 | 11 | 28852 | 10 | |
| 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 | |||
| 96695 | 12261 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2000 12:00:00 AM | 3 | 3X3 | 6004982.9117 | 2111116.4652 | 37.7770052022278 | -122.426286620749 | (37.7770052022278, -122.426286620749) | 7 | 9 | 11 | 28852 | 10 | ||
| 98566 | 242426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 317 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005001.43117 | 2109853.31909 | 37.7735379576528 | -122.426132609638 | (37.7735379576528, -122.426132609638) | 7 | 9 | 11 | 28852 | 10 | |||
| 99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
| 120641 | 100077 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005310 | 2109942 | 37.7737988894613 | -122.425071534475 | (37.7737988894613, -122.425071534475) | 7 | 9 | 11 | 28852 | 10 | ||||
| 120909 | 245848 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 251 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005123.1957 | 2109797.771 | 37.7733923174645 | -122.425707453362 | (37.7733923174645, -122.425707453362) | 7 | 9 | 11 | 28852 | 10 | ||
| 124514 | 244421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005693.2117 | 2109673.0661 | 37.7730821016693 | -122.423726816669 | (37.7730821016693, -122.423726816669) | 7 | 9 | 11 | 28852 | 10 | |||
| 131533 | 47022 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769670 | 6004925.00265887 | 2109895.52879881 | 37.7736495352098 | -122.426399993288 | (37.7736495352098, -122.426399993288) | 7 | 9 | 11 | 28852 | 10 |
| 135919 | 244410 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005558.4964 | 2110254.116 | 37.7746699186287 | -122.424234147092 | (37.7746699186287, -122.424234147092) | 7 | 9 | 11 | 28852 | 10 | |||
| 142468 | 242766 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 133 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003783.1847 | 2108889.43226 | 37.7708224295353 | -122.430277922195 | (37.7708224295353, -122.430277922195) | 15 | 9 | 11 | 29492 | 10 | |||
| 150725 | 63592 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | 3x3 | Permit Number 24223 | 6005148 | 2109920 | 37.7737293302527 | -122.425630352746 | (37.7737293302527, -122.425630352746) | 7 | 9 | 11 | 28852 | 10 | ||
| 153189 | 244353 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005598.6806 | 2110351.942 | 37.7749407940225 | -122.424102100187 | (37.7749407940225, -122.424102100187) | 7 | 9 | 11 | 28852 | 10 | |||
| 171658 | 244454 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003599.7646 | 2110218.5739 | 37.7744615354532 | -122.431007253532 | (37.7744615354532, -122.431007253532) | 15 | 9 | 11 | 29492 | 10 | |||
| 173249 | 242434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004879.95955 | 2109886.96936 | 37.773623486774 | -122.426555194781 | (37.773623486774, -122.426555194781) | 7 | 9 | 11 | 28852 | 10 | |||
| 177900 | 63730 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | 15 | 9 | 11 | 29492 | 10 | |
| 190137 | 244936 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | 7 | 9 | 11 | 28852 | 10 | |||
| 190456 | 103270 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
| 2661 | 123693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995461.17658 | 2113536.44974 | 37.7831070225625 | -122.459400327451 | (37.7831070225625, -122.459400327451) | 11 | 6 | 2 | 54 | 11 | |||
| 18136 | 112514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1014 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992342.97239 | 2113476.2606 | 37.7827619817135 | -122.47018356399 | (37.7827619817135, -122.47018356399) | 11 | 6 | 2 | 54 | 11 | |||
| 19934 | 123687 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 24 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995428.99259 | 2113586.04452 | 37.7832413460359 | -122.459515263281 | (37.7832413460359, -122.459515263281) | 11 | 6 | 2 | 54 | 11 | |||
| 23318 | 112503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 645 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993489.26776 | 2113460.89025 | 37.7827859823771 | -122.46621678157 | (37.7827859823771, -122.46621678157) | 11 | 6 | 2 | 54 | 11 |
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) );