trees
1,196 rows where SiteOrder = 1 and qSpecies_id = 31 sorted by Longitude
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 | |||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||
| 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 | ||||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 61963 | 198601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6016359.83761 | 2108655.37305 | 37.7708840915587 | -122.386758280474 | (37.7708840915587, -122.386758280474) | 14 | 3 | 9 | 310 | 20 | ||||
| 45131 | 198642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016136.74684 | 2108760.92666 | 37.7711615647777 | -122.387537328991 | (37.7711615647777, -122.387537328991) | 14 | 3 | 9 | 310 | 20 | ||||
| 82953 | 198612 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015981.50348 | 2108634.31081 | 37.770805305558 | -122.388065489139 | (37.770805305558, -122.388065489139) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |||
| 44812 | 198627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015673.13601 | 2108738.35245 | 37.7710738916798 | -122.389139413673 | (37.7710738916798, -122.389139413673) | 14 | 3 | 9 | 310 | 20 | ||||
| 36117 | 198433 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015623.39252 | 2106299.43011 | 37.764374384886 | -122.38914115655 | (37.764374384886, -122.38914115655) | 14 | 3 | 9 | 310 | 29 | |||
| 176285 | 198492 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015469.84245 | 2104726.88605 | 37.7600480046386 | -122.389562414283 | (37.7600480046386, -122.389562414283) | 10 | 3 | 8 | 28856 | 29 | |||
| 72355 | 103417 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6015408.53922 | 2105754.52257 | 37.7628662739736 | -122.389846216032 | (37.7628662739736, -122.389846216032) | 10 | 3 | 8 | 28856 | 29 | |||
| 2130 | 83476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 674-680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015406.08252 | 2105913.749 | 37.763303339101 | -122.389865835643 | (37.763303339101, -122.389865835643) | 14 | 3 | 8 | 28856 | 29 | |||
| 98931 | 198469 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015387.00613 | 2105817.97033 | 37.7630392936585 | -122.389925124361 | (37.7630392936585, -122.389925124361) | 14 | 3 | 8 | 28856 | 29 | |||
| 182472 | 198463 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6015318.33391 | 2105764.39063 | 37.7628883667318 | -122.390158896816 | (37.7628883667318, -122.390158896816) | 14 | 3 | 8 | 28856 | 29 | |||
| 33876 | 115549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | 10 | 3 | 8 | 28856 | 29 | ||
| 166589 | 111683 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 915 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x7 | 6015271.38469 | 2104348.44266 | 37.7589978743768 | -122.390222350301 | (37.7589978743768, -122.390222350301) | 10 | 3 | 8 | 28856 | 29 | |||
| 106858 | 112787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 913 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6015266.54568 | 2104367.00121 | 37.7590485637711 | -122.390240382605 | (37.7590485637711, -122.390240382605) | 10 | 3 | 8 | 28856 | 29 | |||
| 24769 | 198491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 907 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015266.77203 | 2104421.22514 | 37.7591974636091 | -122.390243388116 | (37.7591974636091, -122.390243388116) | 10 | 3 | 8 | 28856 | 29 | |||
| 116775 | 57076 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767819 | 6015234.40756552 | 2104029.6701639 | 37.7581205423321 | -122.390327963745 | (37.7581205423321, -122.390327963745) | 10 | 3 | 8 | 28856 | 29 | |
| 189978 | 57074 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 966 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 24 | 9x7.5 | Permit Number 14341 | 6015226.17172 | 2104099.64367 | 37.7583122177548 | -122.390361336011 | (37.7583122177548, -122.390361336011) | 10 | 3 | 8 | 28856 | 29 | |
| 6558 | 57073 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.7584195158777 | -122.390379311651 | (37.7584195158777, -122.390379311651) | 10 | 3 | 8 | 28856 | 29 | ||
| 144725 | 97832 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 44900 | 55226 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1973 12:00:00 AM | 3x3 | Permit Number 51714 | 6015214.86332087 | 2104389.48828919 | 37.7591074416555 | -122.390420697382 | (37.7591074416555, -122.390420697382) | 10 | 3 | 8 | 28856 | 29 | ||
| 20097 | 57068 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 918 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 15 | 6x7 | Permit Number 14334 | 6015212.77238 | 2104346.74514 | 37.7589899621477 | -122.390424942382 | (37.7589899621477, -122.390424942382) | 10 | 3 | 8 | 28856 | 29 | |
| 146968 | 198482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6015196.49511 | 2104613.64131 | 37.7597218987678 | -122.390499886477 | (37.7597218987678, -122.390499886477) | 10 | 3 | 8 | 28856 | 29 | |||
| 38442 | 198473 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015189.15616 | 2104818.6313 | 37.7602843500682 | -122.39053959244 | (37.7602843500682, -122.39053959244) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 84147 | 198454 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015038.61776 | 2106270.38005 | 37.7642621854664 | -122.391161715541 | (37.7642621854664, -122.391161715541) | 14 | 3 | 9 | 310 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 69780 | 198573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014828.40077 | 2114123.03475 | 37.7858121540501 | -122.392438101754 | (37.7858121540501, -122.392438101754) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 54459 | 198563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014720.16797 | 2114187.47554 | 37.7859830827904 | -122.392817069764 | (37.7859830827904, -122.392817069764) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 27935 | 253392 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 105010 | 83024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1209 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52375 | 6013948.88284 | 2105690.73542 | 37.7626100742202 | -122.394890228324 | (37.7626100742202, -122.394890228324) | 10 | 3 | 8 | 28856 | 29 | |
| 164068 | 254716 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
| 112716 | 48869 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 375 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | 23 | Permit Number 46077 | 6013801.17849 | 2105352.33133 | 37.7616726766835 | -122.395377380275 | (37.7616726766835, -122.395377380275) | 10 | 3 | 8 | 28856 | 29 | ||
| 20447 | 198509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 361 Texas St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6013800.26675 | 2105409.79767 | 37.7618304159729 | -122.395384559572 | (37.7618304159729, -122.395384559572) | 10 | 3 | 8 | 28856 | 29 | |||
| 139833 | 198581 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013801.3988 | 2107146.90693 | 37.7666001988537 | -122.395502349162 | (37.7666001988537, -122.395502349162) | 14 | 3 | 8 | 28856 | 20 | |
| 186371 | 67600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 555 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 10 | Permit Number 31170 | 6013571.5238 | 2104494.52261 | 37.7593045458768 | -122.396111549926 | (37.7593045458768, -122.396111549926) | 10 | 3 | 8 | 28856 | 29 | |
| 184345 | 198593 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013352.21579 | 2107122.2943 | 37.7665076235661 | -122.397054279536 | (37.7665076235661, -122.397054279536) | 14 | 3 | 8 | 28856 | 20 | |||
| 37402 | 110633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013429.5241 | 2113847.0849 | 37.7849766786955 | -122.397258498892 | (37.7849766786955, -122.397258498892) | 6 | 2 | 9 | 28856 | 6 | |||
| 164728 | 198598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013134.44315 | 2107112.3448 | 37.766468179289 | -122.397806823228 | (37.766468179289, -122.397806823228) | 14 | 3 | 8 | 28856 | 20 | |||
| 118364 | 198512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 681 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6013048.29942 | 2103920.61394 | 37.7576995923826 | -122.397880868001 | (37.7576995923826, -122.397880868001) | 10 | 3 | 8 | 28856 | 29 | |||
| 186340 | 30358 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 657 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 14 | Permit Number 14187 | 6013035.79545 | 2104016.54587 | 37.7579623041386 | -122.397930841554 | (37.7579623041386, -122.397930841554) | 10 | 3 | 8 | 28856 | 29 | ||
| 52749 | 55989 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 653 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1973 12:00:00 AM | 11 | Permit Number 12064 | 6013032.80163 | 2104035.48043 | 37.7580141275685 | -122.397942523747 | (37.7580141275685, -122.397942523747) | 10 | 3 | 8 | 28856 | 29 | ||
| 63920 | 32998 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.7846540898483 | -122.398013908317 | (37.7846540898483, -122.398013908317) | 6 | 2 | 9 | 28853 | 6 | |
| 37462 | 198510 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 678 Arkansas St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6012982.1442 | 2103924.05495 | 37.7577053561473 | -122.39810990287 | (37.7577053561473, -122.39810990287) | 10 | 3 | 8 | 28856 | 29 | |||
| 34763 | 121610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 22nd St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 11 | 6012951.69217 | 2103797.77434 | 37.7573569210097 | -122.398206359645 | (37.7573569210097, -122.398206359645) | 10 | 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) );