trees
2,365 rows where qSpecies_id = 31 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41660 | 198529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 Newcomb Ave | 2 | : | Tree | Private 2 | 7 | Width 7ft | 6014569.28946 | 2096208.90311 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 47416 | 255466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15x200 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
| 47966 | 173668 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014587 | 2096103 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | 10 | 3 | 8 | 58 | 1 | ||||
| 49082 | 198557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014596.8944 | 2096198.85091 | 37.7365833749264 | -122.391985180675 | (37.7365833749264, -122.391985180675) | 10 | 3 | 8 | 58 | 1 | |||
| 49167 | 16426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | ||
| 51789 | 198487 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6015204.943 | 2104516.59795 | 37.7594559071887 | -122.390463888397 | (37.7594559071887, -122.390463888397) | 10 | 3 | 8 | 28856 | 29 | |||
| 52389 | 198503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 711 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6012443.96033 | 2104600.30725 | 37.7595322056728 | -122.400018665343 | (37.7595322056728, -122.400018665343) | 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 | ||
| 53797 | 200600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | 10 | 3 | 8 | 58 | 1 | |||
| 54691 | 198499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016506.22051 | 2102490.10595 | 37.7539636880787 | -122.38582213748 | (37.7539636880787, -122.38582213748) | 10 | 3 | 8 | 28856 | 29 | |||
| 54742 | 200631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1354 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016389.5518 | 2094874.5522 | 37.7330464790647 | -122.385694866729 | (37.7330464790647, -122.385694866729) | 10 | 3 | 8 | 58 | 1 | |||
| 55149 | 97435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.7329510434152 | -122.385341956131 | (37.7329510434152, -122.385341956131) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 56312 | 242381 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2612 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011044.54469 | 2101843.02489 | 37.7518831964721 | -122.4046644569 | (37.7518831964721, -122.4046644569) | 10 | 4 | 8 | 28859 | 19 | |||
| 57103 | 16428 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
| 58501 | 242380 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1217 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011151.17373 | 2102568.66425 | 37.7538816015592 | -122.404346786677 | (37.7538816015592, -122.404346786677) | 10 | 4 | 8 | 28859 | 19 | |||
| 58566 | 200635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016404.4653 | 2094836.0752 | 37.7329416541175 | -122.385640625637 | (37.7329416541175, -122.385640625637) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 61263 | 16420 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016497.09656 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | 10 | 3 | 8 | 58 | 1 | |||
| 61858 | 200580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1330 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016475.5774 | 2094870.1567 | 37.7330391696694 | -122.385397144532 | (37.7330391696694, -122.385397144532) | 10 | 3 | 8 | 58 | 1 | |||
| 62302 | 198549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1742 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6014473.93082 | 2096284.01772 | 37.7368103979679 | -122.392416277009 | (37.7368103979679, -122.392416277009) | 10 | 3 | 8 | 58 | 1 | |||
| 62432 | 201912 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 63241 | 180537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010311.60374 | 2092285.69304 | 37.7255998252705 | -122.406525674941 | (37.7255998252705, -122.406525674941) | 10 | 3 | 7 | 309 | 28 | |||
| 65768 | 255467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
| 67211 | 198540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014330.01059 | 2096395.83153 | 37.7371094225658 | -122.392921696874 | (37.7371094225658, -122.392921696874) | 10 | 3 | 8 | 58 | 1 | |||
| 68160 | 201911 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.7283501238417 | -122.394511693764 | (37.7283501238417, -122.394511693764) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||||
| 69763 | 200749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||||
| 70359 | 16431 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6016292.5361 | 2094929.44377 | 37.7331918315913 | -122.386034103828 | (37.7331918315913, -122.386034103828) | 10 | 3 | 8 | 58 | 1 | |||
| 70618 | 198478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015196.41735 | 2104702.38206 | 37.7599655574783 | -122.390506356185 | (37.7599655574783, -122.390506356185) | 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 | |||
| 74815 | 198475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015192.04095 | 2104775.13196 | 37.7601650702756 | -122.390526575643 | (37.7601650702756, -122.390526575643) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 76275 | 198486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015201.9775 | 2104548.15133 | 37.7595423814855 | -122.390476349396 | (37.7595423814855, -122.390476349396) | 10 | 3 | 8 | 28856 | 29 | |||
| 76321 | 180535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010393.23752 | 2092315.54751 | 37.7256863661069 | -122.406245574796 | (37.7256863661069, -122.406245574796) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 77331 | 198504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 785 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011870.75445 | 2104712.89725 | 37.7598093776163 | -122.402009022396 | (37.7598093776163, -122.402009022396) | 10 | 3 | 8 | 28856 | 29 | |||
| 78591 | 198554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | : | Tree | Private 2 | 2 | Width 0ft | 6014551.87687 | 2096170.80222 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||||
| 80710 | 81876 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1209 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52375 | 6013966.08986 | 2105691.70822 | 37.762613702073 | -122.394830783137 | (37.762613702073, -122.394830783137) | 10 | 3 | 8 | 28856 | 29 | |
| 81102 | 242382 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2612 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011032.0091 | 2101843.28005 | 37.7518831964576 | -122.404707824918 | (37.7518831964576, -122.404707824918) | 10 | 4 | 8 | 28859 | 19 | |||
| 83633 | 200746 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | 10 | 3 | 8 | 58 | 1 | |||
| 84939 | 200792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.7358498081793 | -122.389034132513 | (37.7358498081793, -122.389034132513) | 10 | 3 | 8 | 58 | 1 | |||
| 86976 | 22316 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
| 87166 | 16411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
| 87526 | 200759 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1628 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014603.9551 | 2094093.5604 | 37.7308030679401 | -122.391813605271 | (37.7308030679401, -122.391813605271) | 10 | 3 | 8 | 58 | 1 | |||
| 88581 | 198542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014379.25839 | 2096358.16964 | 37.7370087461611 | -122.392748789643 | (37.7370087461611, -122.392748789643) | 10 | 3 | 8 | 58 | 1 | |||
| 89896 | 198555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 4 | : | Tree | Private 2 | 6 | Width 0ft | 6014573.39316 | 2096202.10779 | 37.7365910128673 | -122.39206666287 | (37.7365910128673, -122.39206666287) | 10 | 3 | 8 | 58 | 1 | |||
| 90577 | 198693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016661.34411 | 2095009.85168 | 37.733433020107 | -122.384764621992 | (37.733433020107, -122.384764621992) | 10 | 3 | 8 | 58 | 1 | |||
| 91124 | 198531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014434.12864 | 2096316.99865 | 37.7368987464799 | -122.392556198035 | (37.7368987464799, -122.392556198035) | 10 | 3 | 8 | 58 | 1 | |||
| 91285 | 180538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010266.12531 | 2092269.81 | 37.7255536693496 | -122.406681772069 | (37.7255536693496, -122.406681772069) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 95343 | 198500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016504.90448 | 2102523.10402 | 37.754054221042 | -122.385828988529 | (37.754054221042, -122.385828988529) | 10 | 3 | 8 | 28856 | 29 | |||
| 95950 | 198692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.7332997702709 | -122.384585575986 | (37.7332997702709, -122.384585575986) | 10 | 3 | 8 | 58 | 1 | |||
| 97154 | 70472 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
| 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 | |||
| 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 | |||
| 99304 | 22314 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
| 101072 | 201910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.7283734198726 | -122.394550072331 | (37.7283734198726, -122.394550072331) | 10 | 3 | 8 | 58 | 1 | |||
| 101626 | 201907 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||||
| 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 |
| 104649 | 198511 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 678 Arkansas St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012984.38366 | 2103919.05598 | 37.7576917548011 | -122.398101807147 | (37.7576917548011, -122.398101807147) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |
| 106040 | 16430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
| 106373 | 16438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||||
| 107965 | 97221 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | 15x200 | 6016689.53805 | 2094986.80633 | 37.733371301443 | -122.384665541907 | (37.733371301443, -122.384665541907) | 10 | 3 | 8 | 58 | 1 | |||
| 108431 | 198532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 1 | : | Tree | Private 2 | 4 | Width 7ft | 6014372.17182 | 2096354.40755 | 37.7369980226381 | -122.392773028173 | (37.7369980226381, -122.392773028173) | 10 | 3 | 8 | 58 | 1 | |||
| 108987 | 16441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 109613 | 198479 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015200.24285 | 2104674.66991 | 37.759889678091 | -122.390491189139 | (37.759889678091, -122.390491189139) | 10 | 3 | 8 | 28856 | 29 | |||
| 109695 | 198488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6015206.153 | 2104497.93944 | 37.75940474205 | -122.390458399858 | (37.75940474205, -122.390458399858) | 10 | 3 | 8 | 28856 | 29 | |||
| 109770 | 201908 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.394643789789 | (37.7284270698286, -122.394643789789) | 10 | 3 | 8 | 58 | 1 | |||
| 111256 | 16440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 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 | |||
| 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 | ||||
| 116529 | 198508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 998 Rhode Island St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6011865.97365 | 2103785.48158 | 37.7572626324706 | -122.401960360989 | (37.7572626324706, -122.401960360989) | 10 | 3 | 8 | 28856 | 29 | |||
| 116534 | 198560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014655.2828 | 2096153.01044 | 37.7364607478562 | -122.391780101069 | (37.7364607478562, -122.391780101069) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 119015 | 198545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014347.46676 | 2096307.91829 | 37.736869000501 | -122.392855193808 | (37.736869000501, -122.392855193808) | 10 | 3 | 8 | 58 | 1 | |||
| 119302 | 16425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
| 119811 | 16424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.385712405803 | (37.7330411346315, -122.385712405803) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 121839 | 198694 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016624.01227 | 2094969.82171 | 37.7333210410161 | -122.384890902109 | (37.7333210410161, -122.384890902109) | 10 | 3 | 8 | 58 | 1 | |||
| 125460 | 198527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014634.66691 | 2096168.32121 | 37.7365016436308 | -122.391852449756 | (37.7365016436308, -122.391852449756) | 10 | 3 | 8 | 58 | 1 | |||
| 125643 | 180572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 515 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009820.00163 | 2093055.54033 | 37.7276861489955 | -122.408279384389 | (37.7276861489955, -122.408279384389) | 10 | 3 | 7 | 309 | 28 | |||
| 125652 | 117152 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.7285509455903 | -122.389513905896 | (37.7285509455903, -122.389513905896) | 10 | 3 | 8 | 58 | 1 | |||
| 126107 | 16421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016475.45956 | 2094869.09162 | 37.7330362386527 | -122.385397477745 | (37.7330362386527, -122.385397477745) | 10 | 3 | 8 | 58 | 1 | |||
| 126634 | 200579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1324 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016496.9269 | 2094875.1801 | 37.7330541440687 | -122.385323682911 | (37.7330541440687, -122.385323682911) | 10 | 3 | 8 | 58 | 1 | |||
| 126690 | 16415 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 127822 | 16443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 |
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) );