trees
2,365 rows where qSpecies_id = 31 sorted by DBH descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65753 | 242398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1790 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005569.03303 | 2107270.72289 | 37.7664788326491 | -122.423985499825 | (37.7664788326491, -122.423985499825) | 8 | 4 | 5 | 28853 | 19 | |||
| 66002 | 242545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2460 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008186.74637 | 2104114.44399 | 37.7579598597653 | -122.414707884977 | (37.7579598597653, -122.414707884977) | 2 | 4 | 7 | 28859 | 19 | |||
| 67520 | 40174 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 801 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2006 12:00:00 AM | 8 | Permit Number 48884 | 6002465.36284573 | 2103545.36770604 | 37.7560741956992 | -122.434454137261 | (37.7560741956992, -122.434454137261) | 2 | 4 | 5 | 28862 | 22 | |
| 67600 | 215522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2669 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992094.03809 | 2097402.04556 | 37.738612033229 | -122.469874065536 | (37.738612033229, -122.469874065536) | 1 | 8 | 4 | 59 | 40 | |||
| 68730 | 242692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 442 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002935.80921 | 2105661.63125 | 37.761911640939 | -122.432978365974 | (37.761911640939, -122.432978365974) | 15 | 4 | 5 | 28862 | 3 | |||
| 70722 | 242667 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003571.73195 | 2102466.14454 | 37.7531736444653 | -122.43055093927 | (37.7531736444653, -122.43055093927) | 2 | 4 | 5 | 28862 | 22 | |||
| 70956 | 41880 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 126 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42256 | 6004087.67177215 | 2108230.12497736 | 37.7690293739028 | -122.429177676408 | (37.7690293739028, -122.429177676408) | 7 | 9 | 5 | 28862 | 3 | |
| 73130 | 59005 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3709 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1997 12:00:00 AM | 8 | 3x3 | Permit Number 18296 | 6005582.97907977 | 2104283.94686981 | 37.7582786381985 | -122.423724875571 | (37.7582786381985, -122.423724875571) | 2 | 4 | 5 | 28859 | 19 | |
| 73533 | 35673 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
| 74754 | 242444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 209 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6004775.72746 | 2102364.1571 | 37.7529617434884 | -122.426380018538 | (37.7529617434884, -122.426380018538) | 2 | 4 | 5 | 28862 | 22 | |||
| 75256 | 137061 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011779.14715 | 2118403.24493 | 37.7973947915995 | -122.403288932137 | (37.7973947915995, -122.403288932137) | 3 | 1 | 10 | 308 | 23 | |||
| 76962 | 98856 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008586.80061 | 2110533.83683 | 37.7756084919722 | -122.413778389761 | (37.7756084919722, -122.413778389761) | 8 | 2 | 9 | 28853 | 34 | |||
| 77852 | 7013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.7743154774203 | -122.435062751747 | (37.7743154774203, -122.435062751747) | 15 | 5 | 11 | 29492 | 10 | ||
| 82816 | 101523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2326 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001809.97493 | 2118762.85825 | 37.7978203759732 | -122.437810557338 | (37.7978203759732, -122.437810557338) | 13 | 9 | 1 | 57 | 17 | |||
| 85836 | 244364 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005534.4686 | 2110345.8041 | 37.7749203151844 | -122.424323786781 | (37.7749203151844, -122.424323786781) | 7 | 9 | 11 | 28852 | 10 | |||
| 87354 | 242564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008170.65344 | 2105509.80354 | 37.761790292697 | -122.414862295865 | (37.761790292697, -122.414862295865) | 2 | 4 | 7 | 28859 | 19 | |||
| 89847 | 101524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 91200 | 242577 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1811 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008043.01248 | 2107858.0308 | 37.7682308064267 | -122.41547001005 | (37.7682308064267, -122.41547001005) | 8 | 4 | 7 | 28853 | 19 | |||
| 98651 | 33318 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.00816 | 37.7974394114518 | -122.427055518194 | (37.7974394114518, -122.427055518194) | 13 | 9 | 1 | 57 | 17 | |
| 100699 | 246540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | 7 | 9 | 11 | 28852 | 10 | |||
| 102983 | 242391 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1754 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005735.36143 | 2107280.34604 | 37.7665146445612 | -122.4234108834 | (37.7665146445612, -122.4234108834) | 8 | 4 | 5 | 28853 | 19 | |||
| 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 | |
| 105512 | 242614 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2005 12:00:00 AM | 8 | Width 3ft | 6006648.68245 | 2098490.72536 | 37.7424318739254 | -122.419628170307 | (37.7424318739254, -122.419628170307) | 2 | 7 | 7 | 28859 | 2 | ||
| 106141 | 137053 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Green St | 28 | Front Yard : Yard | Tree | Private 2 | 8 | 6008580.77711 | 2119003.85777 | 37.7988647784329 | -122.414398677364 | (37.7988647784329, -122.414398677364) | 5 | 1 | 10 | 308 | 32 | ||||
| 107408 | 137063 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011730.01399 | 2118396.8785 | 37.7973745667251 | -122.403458498435 | (37.7973745667251, -122.403458498435) | 3 | 1 | 10 | 308 | 23 | |||
| 112370 | 198564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014732.17193 | 2114176.27095 | 37.7859529842748 | -122.392774754864 | (37.7859529842748, -122.392774754864) | 6 | 2 | 9 | 28855 | 6 | |||
| 116030 | 35674 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
| 119288 | 53481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1969 12:00:00 AM | 8 | Permit Number 6390 | 6002979.07126 | 2117470.0427 | 37.7943370471773 | -122.433672716337 | (37.7943370471773, -122.433672716337) | 13 | 9 | 1 | 29490 | 27 | ||
| 119886 | 242569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008127.66505 | 2106292.34802 | 37.7639365634558 | -122.415066368228 | (37.7639365634558, -122.415066368228) | 8 | 4 | 7 | 28859 | 19 | |||
| 124575 | 85858 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1608 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 8 | 3x3 | 6008131.7874 | 2108761.9182 | 37.7707176588514 | -122.415226937815 | (37.7707176588514, -122.415226937815) | 8 | 2 | 9 | 28853 | 19 | ||
| 124594 | 198569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014782.21142 | 2114125.62722 | 37.7858167073117 | -122.392598086644 | (37.7858167073117, -122.392598086644) | 6 | 2 | 9 | 28855 | 6 | |||
| 132483 | 198483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6015197.31328 | 2104594.68874 | 37.7596699044709 | -122.390495732502 | (37.7596699044709, -122.390495732502) | 10 | 3 | 8 | 28856 | 29 | |||
| 133563 | 242389 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1740 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005811.26232 | 2107283.9341 | 37.7665287801004 | -122.423148610531 | (37.7665287801004, -122.423148610531) | 8 | 4 | 5 | 28853 | 19 | |||
| 140350 | 242387 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1730 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005854.02538 | 2107285.11476 | 37.7665344350517 | -122.423000784458 | (37.7665344350517, -122.423000784458) | 8 | 4 | 5 | 28853 | 19 | |||
| 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 | |||
| 142251 | 198484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6015200.57665 | 2104577.87924 | 37.7596239302292 | -122.390483271483 | (37.7596239302292, -122.390483271483) | 10 | 3 | 8 | 28856 | 29 | |||
| 142346 | 242571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008126.47482 | 2106341.38137 | 37.7640711307933 | -122.415073955818 | (37.7640711307933, -122.415073955818) | 8 | 4 | 7 | 28859 | 19 | |||
| 142917 | 242396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1780 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005609.74325 | 2107272.63155 | 37.7664863716757 | -122.423844826097 | (37.7664863716757, -122.423844826097) | 8 | 4 | 5 | 28853 | 19 | |||
| 145100 | 97234 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380X Newcomb Ave | 14 | Median : Cutout | Tree | DPW 1 | 8 | 15x200 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
| 146361 | 198571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014800.77369 | 2114106.06902 | 37.7857640358271 | -122.392532497299 | (37.7857640358271, -122.392532497299) | 6 | 2 | 9 | 28855 | 6 | |||
| 148581 | 242565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008169.06246 | 2105538.85559 | 37.761869973535 | -122.414869854678 | (37.761869973535, -122.414869854678) | 2 | 4 | 7 | 28859 | 19 | |||
| 150045 | 242592 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4412 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000533.60664 | 2102299.68252 | 37.752544002129 | -122.44104541512 | (37.752544002129, -122.44104541512) | 2 | 4 | 5 | 28862 | 22 | |||
| 151948 | 198577 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014773.44374 | 2114176.75281 | 37.7859565995548 | -122.392631998283 | (37.7859565995548, -122.392631998283) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 152997 | 215517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 164 Howth St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997515.64352 | 2090995.97654 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | 9 | 8 | 6 | 28861 | 24 | |||
| 153183 | 198533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014374.32844 | 2096361.30259 | 37.7370170747819 | -122.392766053934 | (37.7370170747819, -122.392766053934) | 10 | 3 | 8 | 58 | 1 | |||
| 153973 | 137000 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2452 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002291.94194 | 2116764.70043 | 37.7923613472598 | -122.435999765177 | (37.7923613472598, -122.435999765177) | 13 | 9 | 1 | 29490 | 27 | |||
| 156126 | 242601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5999037.14179 | 2105234.87473 | 37.7605179660504 | -122.446431569085 | (37.7605179660504, -122.446431569085) | 15 | 5 | 5 | 28862 | 12 | |||
| 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 | |||
| 158337 | 198682 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010265.52536 | 2111657.00033 | 37.7787865665763 | -122.408050470058 | (37.7787865665763, -122.408050470058) | 14 | 2 | 9 | 28853 | 34 | |||
| 162851 | 242646 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3222 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008197.74187 | 2101553.16309 | 37.7509277810113 | -122.414488622178 | (37.7509277810113, -122.414488622178) | 2 | 4 | 7 | 28859 | 19 | |||
| 163777 | 138048 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1800 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003477.2141 | 2114952.814 | 37.7874536313531 | -122.431769270905 | (37.7874536313531, -122.431769270905) | 13 | 9 | 11 | 29490 | 27 | |||
| 167868 | 244363 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005533.5243 | 2110362.3292 | 37.7749656357807 | -122.424328228908 | (37.7749656357807, -122.424328228908) | 7 | 9 | 11 | 28852 | 10 | |||
| 170839 | 242538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2394 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008164.43202 | 2104565.65474 | 37.7591975274662 | -122.41481699071 | (37.7591975274662, -122.41481699071) | 2 | 4 | 7 | 28859 | 19 | |||
| 172075 | 83229 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | 13 | 9 | 1 | 28858 | 17 | |
| 172739 | 200628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1362 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016361.9231 | 2094886.4828 | 37.7330777092621 | -122.385791218603 | (37.7330777092621, -122.385791218603) | 10 | 3 | 8 | 58 | 1 | |||
| 172901 | 198526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014646.0524 | 2096160.05646 | 37.736479582376 | -122.391812507248 | (37.736479582376, -122.391812507248) | 10 | 3 | 8 | 58 | 1 | |||
| 175254 | 242686 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3883 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003089.74874 | 2105903.46212 | 37.7625843805828 | -122.432463223521 | (37.7625843805828, -122.432463223521) | 15 | 4 | 5 | 28862 | 3 | |||
| 175777 | 242603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5999039.00902 | 2105211.58372 | 37.7604541213822 | -122.446423435607 | (37.7604541213822, -122.446423435607) | 15 | 5 | 5 | 28862 | 12 | |||
| 177023 | 123692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 11 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995433.73143 | 2113533.85695 | 37.7830983254289 | -122.459495088037 | (37.7830983254289, -122.459495088037) | 11 | 6 | 2 | 54 | 11 | |||
| 180670 | 35675 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
| 181096 | 242460 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 207 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006786.17438 | 2098418.92511 | 37.7422424704181 | -122.419147671535 | (37.7422424704181, -122.419147671535) | 2 | 7 | 7 | 28859 | 2 | |||
| 182723 | 244355 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.424130226226 | (37.7750804055544, -122.424130226226) | 7 | 9 | 11 | 28852 | 10 | |||
| 182891 | 242438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 155 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004951.72488 | 2098699.71043 | 37.7429099643322 | -122.425510615143 | (37.7429099643322, -122.425510615143) | 2 | 7 | 5 | 63 | 22 | |||
| 186422 | 35676 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
| 187128 | 23644 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 197 Virginia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2005 12:00:00 AM | 8 | 3X3 | 6006643.75963 | 2098486.48829 | 37.7424199625796 | -122.41964489142 | (37.7424199625796, -122.41964489142) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 189177 | 198679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010343.11508 | 2111575.05475 | 37.7785659071229 | -122.40777627577 | (37.7785659071229, -122.40777627577) | 14 | 2 | 9 | 28853 | 34 | |||
| 81012 | 18524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 6x9 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
| 969 | 198677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010377.80869 | 2111537.89689 | 37.7784658224798 | -122.407653636128 | (37.7784658224798, -122.407653636128) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 3772 | 215475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993086.32041 | 2105916.03813 | 37.7620465797188 | -122.467062084267 | (37.7620465797188, -122.467062084267) | 1 | 8 | 4 | 56 | 12 | |||
| 5430 | 242594 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4317 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001015.759 | 2101696.42281 | 37.7509150466066 | -122.439334816464 | (37.7509150466066, -122.439334816464) | 2 | 4 | 5 | 28862 | 22 | |||
| 9720 | 242385 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005896.47931 | 2107288.01777 | 37.7665448015394 | -122.422854150009 | (37.7665448015394, -122.422854150009) | 8 | 4 | 5 | 28853 | 19 | |||
| 11729 | 244288 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.424108218812 | (37.7739922036556, -122.424108218812) | 7 | 9 | 11 | 28852 | 10 | |||
| 14245 | 242715 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3880 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002516.60789 | 2103579.90107 | 37.7561719248109 | -122.434279383699 | (37.7561719248109, -122.434279383699) | 2 | 4 | 5 | 28862 | 3 | |||
| 19427 | 242615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6006637.73336 | 2098498.23096 | 37.7424518658562 | -122.419666561475 | (37.7424518658562, -122.419666561475) | 2 | 7 | 7 | 28859 | 2 | |||
| 22343 | 242556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008229.8333 | 2104396.39289 | 37.7587364477383 | -122.414578823255 | (37.7587364477383, -122.414578823255) | 2 | 4 | 7 | 28859 | 19 | |||
| 25001 | 242526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1922 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008013.77103 | 2107241.1183 | 37.7665352651235 | -122.415527471335 | (37.7665352651235, -122.415527471335) | 8 | 4 | 7 | 28853 | 19 | ||
| 25912 | 215526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 478 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994752.10675 | 2100066.65325 | 37.7460816699447 | -122.460876862898 | (37.7460816699447, -122.460876862898) | 1 | 8 | 4 | 29491 | 40 | |||
| 26225 | 244356 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.7751450388721 | -122.424143338216 | (37.7751450388721, -122.424143338216) | 7 | 9 | 11 | 28852 | 10 | |||
| 26707 | 242697 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 264 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001741.09826 | 2104301.70162 | 37.7581097668584 | -122.437013028641 | (37.7581097668584, -122.437013028641) | 2 | 4 | 5 | 28862 | 3 | |||
| 26996 | 242532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2140 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 3ft | 6008084.96302 | 2105937.52751 | 37.7629599086871 | -122.41518894402 | (37.7629599086871, -122.41518894402) | 8 | 4 | 7 | 28859 | 19 | ||
| 32368 | 242591 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4412 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000545.74742 | 2102300.80991 | 37.7525477891746 | -122.441003511213 | (37.7525477891746, -122.441003511213) | 2 | 4 | 5 | 28862 | 22 | |||
| 33215 | 198644 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016180.11848 | 2108766.38719 | 37.7711789603624 | -122.387387684488 | (37.7711789603624, -122.387387684488) | 14 | 3 | 9 | 310 | 20 | ||||
| 34182 | 198607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016227.74089 | 2108648.22285 | 37.7708571442621 | -122.387214711603 | (37.7708571442621, -122.387214711603) | 14 | 3 | 9 | 310 | 20 | ||||
| 34544 | 121498 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 851 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6004400 | 2103913 | 37.7571932560102 | -122.427789705541 | (37.7571932560102, -122.427789705541) | 2 | 4 | 5 | 28862 | 3 | |||
| 34723 | 242403 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008707.95248 | 2101269.88955 | 37.7501786250428 | -122.412704235035 | (37.7501786250428, -122.412704235035) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 42775 | 137027 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2057 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003211.76656 | 2118215.6872 | 37.7963975954305 | -122.432920859704 | (37.7963975954305, -122.432920859704) | 13 | 9 | 1 | 57 | 17 | |||
| 43059 | 244376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | 7 | 9 | 11 | 28852 | 10 | |||
| 43197 | 215476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993096.43343 | 2105917.73669 | 37.7620518272484 | -122.467027231034 | (37.7620518272484, -122.467027231034) | 1 | 8 | 4 | 56 | 12 | |||
| 47344 | 215477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993371.53162 | 2104323.9029 | 37.7576914499066 | -122.465959963285 | (37.7576914499066, -122.465959963285) | 1 | 8 | 4 | 56 | 12 | |||
| 54694 | 215525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 478 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994741.9738 | 2100056.97706 | 37.7460545185029 | -122.460911199901 | (37.7460545185029, -122.460911199901) | 1 | 8 | 4 | 29491 | 40 | |||
| 56109 | 242522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1746 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007972.88605 | 2108208.63163 | 37.7691895323108 | -122.415737399173 | (37.7691895323108, -122.415737399173) | 8 | 4 | 7 | 28853 | 19 | |||
| 56148 | 246538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | 7 | 9 | 11 | 28852 | 10 | |||
| 59471 | 87143 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | |
| 60336 | 123691 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 35 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995371.26757 | 2113529.88581 | 37.7830838299438 | -122.459710898388 | (37.7830838299438, -122.459710898388) | 11 | 6 | 2 | 54 | 11 | |||
| 60909 | 85783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1265 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009394.3077 | 2109993.0802 | 37.7741690156078 | -122.410946812123 | (37.7741690156078, -122.410946812123) | 8 | 2 | 9 | 28853 | 34 |
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) );