trees
2,365 rows where 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 142267 | 198637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015891.9528 | 2108749.14049 | 37.7711156409024 | -122.388383265478 | (37.7711156409024, -122.388383265478) | 14 | 3 | 9 | 310 | 20 | ||||
| 188844 | 198617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015877.04462 | 2108628.30945 | 37.7707830392222 | -122.388426398764 | (37.7707830392222, -122.388426398764) | 14 | 3 | 9 | 310 | 20 | ||||
| 160445 | 198636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015870.56468 | 2108748.55843 | 37.771112857499 | -122.38845720776 | (37.771112857499, -122.38845720776) | 14 | 3 | 9 | 310 | 20 | ||||
| 26267 | 198618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015853.85549 | 2108626.75005 | 37.770777472425 | -122.388506502268 | (37.770777472425, -122.388506502268) | 14 | 3 | 9 | 310 | 20 | ||||
| 90428 | 198635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015851.9543 | 2108746.90695 | 37.7711072915897 | -122.388521466994 | (37.7711072915897, -122.388521466994) | 14 | 3 | 9 | 310 | 20 | ||||
| 106875 | 198634 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015830.83594 | 2108747.07967 | 37.7711065955099 | -122.38859452884 | (37.7711065955099, -122.38859452884) | 14 | 3 | 9 | 310 | 20 | ||||
| 87834 | 198619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015825.0595 | 2108624.79715 | 37.770770514383 | -122.388605972695 | (37.770770514383, -122.388605972695) | 14 | 3 | 9 | 310 | 20 | ||||
| 142794 | 198620 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015807.97532 | 2108623.11457 | 37.7707649475819 | -122.388664950249 | (37.7707649475819, -122.388664950249) | 14 | 3 | 9 | 310 | 20 | ||||
| 66944 | 198633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015806.09479 | 2108744.28476 | 37.7710975501444 | -122.388679914958 | (37.7710975501444, -122.388679914958) | 14 | 3 | 9 | 310 | 20 | ||||
| 180993 | 198621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015788.57088 | 2108619.95844 | 37.7707552061109 | -122.388731850804 | (37.7707552061109, -122.388731850804) | 14 | 3 | 9 | 310 | 20 | ||||
| 177675 | 198632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015782.37645 | 2108741.7224 | 37.7710891999363 | -122.388761779325 | (37.7710891999363, -122.388761779325) | 14 | 3 | 9 | 310 | 20 | ||||
| 44496 | 198622 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015766.21634 | 2108621.93006 | 37.7707593807704 | -122.388809313913 | (37.7707593807704, -122.388809313913) | 14 | 3 | 9 | 310 | 20 | ||||
| 119458 | 198631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015760.25573 | 2108742.67593 | 37.7710905920838 | -122.388838362899 | (37.7710905920838, -122.388838362899) | 14 | 3 | 9 | 310 | 20 | ||||
| 56446 | 198623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | 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 | |||
| 142832 | 198630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015737.06642 | 2108741.11663 | 37.7710850252717 | -122.388918467334 | (37.7710850252717, -122.388918467334) | 14 | 3 | 9 | 310 | 20 | ||||
| 193067 | 198624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015725.44924 | 2108619.45871 | 37.7707503353808 | -122.388950156737 | (37.7707503353808, -122.388950156737) | 14 | 3 | 9 | 310 | 20 | ||||
| 171282 | 198629 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015714.39108 | 2108739.80049 | 37.7710801545587 | -122.388996810881 | (37.7710801545587, -122.388996810881) | 14 | 3 | 9 | 310 | 20 | ||||
| 189844 | 198625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015702.76358 | 2108617.6361 | 37.7707440734189 | -122.38902850026 | (37.7707440734189, -122.38902850026) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |||
| 144684 | 198628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015696.32506 | 2108739.9117 | 37.7710794584904 | -122.389059310163 | (37.7710794584904, -122.389059310163) | 14 | 3 | 9 | 310 | 20 | ||||
| 122941 | 198626 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015680.34741 | 2108616.56793 | 37.7707398978706 | -122.389105964276 | (37.7707398978706, -122.389105964276) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |||
| 21138 | 198434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015605.2539 | 2106298.94966 | 37.7643720601453 | -122.389203859978 | (37.7643720601453, -122.389203859978) | 14 | 3 | 9 | 310 | 29 | |||
| 148627 | 198435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015582.58309 | 2106296.4914 | 37.7643640534737 | -122.389282101 | (37.7643640534737, -122.389282101) | 14 | 3 | 9 | 310 | 29 | |||
| 81835 | 198436 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015560.81783 | 2106295.35578 | 37.7643597286383 | -122.389357302304 | (37.7643597286383, -122.389357302304) | 14 | 3 | 9 | 310 | 29 | |||
| 160953 | 198437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015533.99841 | 2106294.64452 | 37.7643562887343 | -122.389450014314 | (37.7643562887343, -122.389450014314) | 14 | 3 | 9 | 310 | 29 | |||
| 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 | |||
| 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 | |||
| 186583 | 198438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015515.17331 | 2106293.18394 | 37.764351234542 | -122.389515023625 | (37.764351234542, -122.389515023625) | 14 | 3 | 9 | 310 | 29 | |||
| 99175 | 198497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015478.44281 | 2104579.86448 | 37.7596447917884 | -122.389522401658 | (37.7596447917884, -122.389522401658) | 10 | 3 | 8 | 28856 | 29 | |||
| 188406 | 198496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015478.89402 | 2104602.20916 | 37.7597061705092 | -122.389522401658 | (37.7597061705092, -122.389522401658) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 |
| 152759 | 198495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015477.3225 | 2104627.00235 | 37.7597741601603 | -122.389529568345 | (37.7597741601603, -122.389529568345) | 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 | |||
| 61156 | 198493 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6015474.58751 | 2104684.20174 | 37.7599310657768 | -122.389543022191 | (37.7599310657768, -122.389543022191) | 10 | 3 | 8 | 28856 | 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 | |||
| 132398 | 198439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015495.11625 | 2106291.74793 | 37.7643461794683 | -122.389584295684 | (37.7643461794683, -122.389584295684) | 14 | 3 | 9 | 310 | 29 | |||
| 182982 | 198440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015476.91332 | 2106290.58138 | 37.7643419670439 | -122.389647173584 | (37.7643419670439, -122.389647173584) | 14 | 3 | 9 | 310 | 29 | |||
| 176936 | 198441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015454.54719 | 2106287.83835 | 37.7643331950564 | -122.389724340824 | (37.7643331950564, -122.389724340824) | 14 | 3 | 9 | 310 | 29 | |||
| 43816 | 103418 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 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 | ||||
| 143441 | 103420 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
| 47528 | 198442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015430.62355 | 2106285.94365 | 37.7643266659781 | -122.389806954341 | (37.7643266659781, -122.389806954341) | 14 | 3 | 9 | 310 | 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 | |||
| 10327 | 198443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015407.0439 | 2106284.70526 | 37.7643219580036 | -122.389888423915 | (37.7643219580036, -122.389888423915) | 14 | 3 | 9 | 310 | 29 | |||
| 107318 | 198468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015390.71439 | 2105768.72163 | 37.7629042730221 | -122.389908858318 | (37.7629042730221, -122.389908858318) | 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 | |||
| 178124 | 198467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6015376.19959 | 2105766.90453 | 37.7628984786941 | -122.389958933463 | (37.7628984786941, -122.389958933463) | 14 | 3 | 8 | 28856 | 29 | |||
| 7095 | 198444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015385.26433 | 2106283.84094 | 37.7643183769187 | -122.389963693588 | (37.7643183769187, -122.389963693588) | 14 | 3 | 9 | 310 | 29 | |||
| 166871 | 198470 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6015369.36264 | 2105816.80106 | 37.7630351046092 | -122.389986066016 | (37.7630351046092, -122.389986066016) | 14 | 3 | 8 | 28856 | 29 | |||
| 19785 | 198466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015361.95352 | 2105766.343 | 37.7628961467725 | -122.390008166863 | (37.7628961467725, -122.390008166863) | 14 | 3 | 8 | 28856 | 29 | |||
| 104850 | 198445 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015364.88661 | 2106281.79771 | 37.7643116365027 | -122.390034032247 | (37.7643116365027, -122.390034032247) | 14 | 3 | 9 | 310 | 29 | |||
| 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 | |||
| 11128 | 198446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015345.15707 | 2106282.18607 | 37.7643116086136 | -122.390102298884 | (37.7643116086136, -122.390102298884) | 14 | 3 | 9 | 310 | 29 | |||
| 52070 | 198464 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015333.10926 | 2105765.07508 | 37.7628910655837 | -122.390107841403 | (37.7628910655837, -122.390107841403) | 14 | 3 | 8 | 28856 | 29 | |||
| 100295 | 198472 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015328.96766 | 2105817.04022 | 37.7630335209151 | -122.390125796375 | (37.7630335209151, -122.390125796375) | 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 | ||
| 32856 | 198447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015324.46824 | 2106281.29518 | 37.7643080149349 | -122.390173794086 | (37.7643080149349, -122.390173794086) | 14 | 3 | 9 | 310 | 29 | |||
| 38426 | 115550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.390181786362 | (37.7584697654838, -122.390181786362) | 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 | ||
| 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 | |||
| 154062 | 198448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015301.86752 | 2106280.10819 | 37.7643035021388 | -122.390251881336 | (37.7643035021388, -122.390251881336) | 14 | 3 | 9 | 310 | 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 | |
| 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 | |||
| 52805 | 198449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015277.30133 | 2106281.40363 | 37.7643056964809 | -122.390336940096 | (37.7643056964809, -122.390336940096) | 14 | 3 | 9 | 310 | 29 | |||
| 30218 | 97985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6015230.10587 | 2104016.74085 | 37.7580848025885 | -122.390341937645 | (37.7580848025885, -122.390341937645) | 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 | |
| 62805 | 105992 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 980 MINNESOTA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6015221.1 | 2104017.4 | 37.758086112912 | -122.39037313012 | (37.758086112912, -122.39037313012) | 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 | ||
| 4429 | 97836 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 40459 | 97839 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 40753 | 97851 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 55690 | 97846 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | Permit Number 775024 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | ||
| 68384 | 97840 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 69960 | 97850 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 79389 | 97848 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 102228 | 97852 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 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 | |||||
| 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 | |||||
| 146851 | 97845 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 152559 | 97838 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 152742 | 97847 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 156161 | 97833 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 172519 | 97844 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 174974 | 97837 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | ||||
| 176444 | 97849 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 189071 | 97835 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 89375 | 198450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015258.23224 | 2106279.65666 | 37.7642998419001 | -122.390402773191 | (37.7642998419001, -122.390402773191) | 14 | 3 | 9 | 310 | 29 | |||
| 170626 | 88830 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51714 | 6015215 | 2104389 | 37.7591061085001 | -122.390420190559 | (37.7591061085001, -122.390420190559) | 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 | |
| 120368 | 97843 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6015209.91817 | 2104379.39414 | 37.7590794509666 | -122.390437094914 | (37.7590794509666, -122.390437094914) | 10 | 3 | 8 | 28856 | 29 | ||||
| 116424 | 97842 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6015209.65715 | 2104398.16252 | 37.7591309704315 | -122.390439309039 | (37.7591309704315, -122.390439309039) | 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) );