trees
2,365 rows where qSpecies_id = 31 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40054 | 198640 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015953.10569 | 2108752.97494 | 37.7711295579122 | -122.388172001232 | (37.7711295579122, -122.388172001232) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |||||
| 40654 | 31073 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
| 40722 | 94046 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 42 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 53454 | 5998445 | 2106022 | 37.7626453762737 | -122.44853619655 | (37.7626453762737, -122.44853619655) | 15 | 5 | 11 | 29492 | 9 | ||||
| 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 | |||||
| 41446 | 62038 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2015 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2015 12:00:00 AM | 3 | Permit Number 773957 | 6000922.27992 | 2115385.79956 | 37.7884973390282 | -122.440639868553 | (37.7884973390282, -122.440639868553) | 13 | 6 | 1 | 29490 | 27 | ||
| 42142 | 53259 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 210 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | 15 | Permit Number 6149 | 5997600.12702 | 2115607.00528 | 37.7889149689082 | -122.452149910107 | (37.7889149689082, -122.452149910107) | 11 | 6 | 1 | 54 | 31 | ||
| 42463 | 30575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.93268 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | 7 | 9 | 11 | 29492 | 10 | |
| 42968 | 100580 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
| 43128 | 51255 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.51172 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | 13 | 9 | 1 | 29490 | 27 | ||
| 44282 | 55984 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1260 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1974 12:00:00 AM | 8 | Permit Number 12058 | 6008765.405 | 2116672.96891 | 37.7924751016038 | -122.41359485524 | (37.7924751016038, -122.41359485524) | 5 | 1 | 10 | 28857 | 21 | ||
| 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 | ||||
| 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 | ||||
| 44866 | 50808 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 499 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2006 12:00:00 AM | Permit Number 47332 | 6008981.38895406 | 2105919.05287132 | 37.7629595191577 | -122.412087198232 | (37.7629595191577, -122.412087198232) | 8 | 4 | 7 | 28859 | 19 | ||
| 45131 | 198642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016136.74684 | 2108760.92666 | 37.7711615647777 | -122.387537328991 | (37.7711615647777, -122.387537328991) | 14 | 3 | 9 | 310 | 20 | ||||
| 45367 | 119681 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 48921 | 36885 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2914 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39542 | 6000200.34388 | 2116470.40485 | 37.79143424424 | -122.443215577236 | (37.79143424424, -122.443215577236) | 13 | 6 | 1 | 29490 | 27 | |
| 51115 | 41185 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.22409 | 2120345.11349 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | 13 | 9 | 1 | 57 | 17 | |
| 51199 | 119795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 52684 | 30285 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1355 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1956 12:00:00 AM | 8 | Permit Number 132 | 6008895.30173 | 2117592.00623 | 37.7950058459972 | -122.413210424719 | (37.7950058459972, -122.413210424719) | 5 | 1 | 10 | 28857 | 21 | ||
| 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 | ||
| 54139 | 47103 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.7771583581843 | -122.457996229218 | (37.7771583581843, -122.457996229218) | 11 | 6 | 2 | 54 | 16 | ||
| 54430 | 33935 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1932 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1997 12:00:00 AM | Permit Number 43529 | 6003424.24641356 | 2115332.27843331 | 37.7884925418667 | -122.431979635032 | (37.7884925418667, -122.431979635032) | 13 | 9 | 1 | 29490 | 27 | |||
| 55145 | 119750 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 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 | |||
| 55359 | 44113 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 56016 | 51434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 277 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.7246369688192 | -122.433701359735 | (37.7246369688192, -122.433701359735) | 9 | 7 | 6 | 28861 | 5 | ||
| 56170 | 46874 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.7935568987708 | -122.416132380604 | (37.7935568987708, -122.416132380604) | 5 | 1 | 10 | 28858 | 21 | ||
| 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 | ||||
| 57589 | 119826 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 58093 | 48676 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | 15 | 5 | 11 | 29492 | 9 | ||
| 58417 | 31777 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.7411009369348 | -122.479079284327 | (37.7411009369348, -122.479079284327) | 1 | 8 | 3 | 29491 | 35 | ||
| 58932 | 31077 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.7665636495047 | -122.422496504935 | (37.7665636495047, -122.422496504935) | 8 | 4 | 5 | 28853 | 19 | |
| 59353 | 45650 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | 13 | 6 | 1 | 29490 | 27 | |||
| 59407 | 198638 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015910.55807 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | 14 | 3 | 9 | 310 | 20 | ||||
| 60183 | 198611 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6016143.32489 | 2108643.38282 | 37.7708391794209 | -122.387506373441 | (37.7708391794209, -122.387506373441) | 14 | 3 | 9 | 310 | 20 | ||||
| 61571 | 55641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 450 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/1973 12:00:00 AM | 12 | Permit Number 11624 | 6011869.72365 | 2118415.97295 | 37.7974347979269 | -122.40297640786 | (37.7974347979269, -122.40297640786) | 3 | 1 | 10 | 308 | 23 | ||
| 61962 | 32023 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | 18 | Permit Number 35413 | 6001158.18036 | 2116931.31755 | 37.7927543608653 | -122.439934550957 | (37.7927543608653, -122.439934550957) | 13 | 6 | 1 | 29490 | 27 | ||
| 61963 | 198601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6016359.83761 | 2108655.37305 | 37.7708840915587 | -122.386758280474 | (37.7708840915587, -122.386758280474) | 14 | 3 | 9 | 310 | 20 | ||||
| 62619 | 51850 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4000 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.432677808926 | (37.7594924661239, -122.432677808926) | 2 | 4 | 5 | 28862 | 3 | |||
| 62676 | 32534 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
| 63920 | 32998 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.7846540898483 | -122.398013908317 | (37.7846540898483, -122.398013908317) | 6 | 2 | 9 | 28853 | 6 | |
| 66508 | 66277 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2750 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | 6 | Permit No. 49271 | 5999752.72813 | 2118820.10006 | 37.7978603517187 | -122.444933297631 | (37.7978603517187, -122.444933297631) | 13 | 9 | 1 | 57 | 17 | ||
| 66630 | 72449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.453348481559 | (37.7873175292136, -122.453348481559) | 11 | 6 | 1 | 54 | 31 | ||
| 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 | ||||
| 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 | |
| 68142 | 43942 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3885 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2000 12:00:00 AM | 11 | Permit Number 43530 | 5995636.78457 | 2115791.89347 | 37.7893099594942 | -122.458956155447 | (37.7893099594942, -122.458956155447) | 11 | 6 | 1 | 54 | 31 | ||
| 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 | |||||
| 68441 | 45690 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1932 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2001 12:00:00 AM | 7 | Permit Number 44375 | 5999944.86656 | 2121277.56514 | 37.8046188567315 | -122.44444515194 | (37.8046188567315, -122.44444515194) | 13 | 9 | 1 | 57 | 17 | ||
| 68996 | 119785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 69027 | 45652 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | 13 | 6 | 1 | 29490 | 27 | |||
| 69043 | 74234 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 13 | 5997222.04614 | 2115031.53176 | 37.7873132070818 | -122.45341644603 | (37.7873132070818, -122.45341644603) | 11 | 6 | 1 | 54 | 31 | ||
| 69505 | 46504 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.412275670972 | (37.7768559207247, -122.412275670972) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||||
| 70305 | 198609 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016187.15273 | 2108644.67946 | 37.7708451671001 | -122.387354861049 | (37.7708451671001, -122.387354861049) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |
| 71954 | 68197 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 417 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 7 | Permit Number 31977 | 5998129.56207 | 2114980.61061 | 37.7872253685036 | -122.450272974611 | (37.7872253685036, -122.450272974611) | 11 | 6 | 1 | 54 | 31 | ||
| 72644 | 198605 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016273.49532 | 2108650.02611 | 37.770864629317 | -122.387056570311 | (37.770864629317, -122.387056570311) | 14 | 3 | 9 | 310 | 20 | ||||
| 73186 | 119818 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 73437 | 51550 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1247 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2005 12:00:00 AM | Permit Number 47849 | 5999742.39026173 | 2108428.18336747 | 37.7693262500826 | -122.444221920277 | (37.7693262500826, -122.444221920277) | 15 | 5 | 11 | 29492 | 9 | |||
| 73818 | 198602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016341.19636 | 2108654.11325 | 37.7708796003339 | -122.386822673738 | (37.7708796003339, -122.386822673738) | 14 | 3 | 9 | 310 | 20 | ||||
| 73890 | 55949 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2814 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1989 12:00:00 AM | 3 | Permit Number 28156 | 5999490.08281 | 2118090.45953 | 37.7958419601055 | -122.445789619521 | (37.7958419601055, -122.445789619521) | 13 | 9 | 1 | 57 | 17 | ||
| 74565 | 198648 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016263.67679 | 2108770.7838 | 37.77119565988 | -122.387098957165 | (37.77119565988, -122.387098957165) | 14 | 3 | 9 | 310 | 20 | ||||
| 75248 | 49733 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2940REVISED Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.7502358181357 | -122.413951255275 | (37.7502358181357, -122.413951255275) | 2 | 4 | 7 | 28859 | 19 | ||
| 75960 | 45651 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | 13 | 6 | 1 | 29490 | 27 | |||
| 77089 | 56515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17376 | 6008990.48315 | 2116704.87455 | 37.7925753427324 | -122.412818332001 | (37.7925753427324, -122.412818332001) | 5 | 1 | 10 | 28857 | 21 | ||
| 77286 | 51159 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1801 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2004 12:00:00 AM | 4 | Permit Number 47564 | 6000498.9523 | 2114920.078 | 37.7871944727635 | -122.44207106941 | (37.7871944727635, -122.44207106941) | 13 | 6 | 1 | 29490 | 27 | ||
| 77310 | 119820 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 77725 | 198643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016155.89645 | 2108764.08817 | 37.7711713062286 | -122.387471309764 | (37.7711713062286, -122.387471309764) | 14 | 3 | 9 | 310 | 20 | ||||
| 77972 | 119824 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 78156 | 198614 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015943.0209 | 2108631.53953 | 37.7707955640939 | -122.388198408934 | (37.7707955640939, -122.388198408934) | 14 | 3 | 9 | 310 | 20 | ||||
| 79111 | 50430 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 53REVISED Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2004 12:00:00 AM | Permit Number 47083 | 5998656.22086914 | 2105364.79387751 | 37.7608529276064 | -122.447758347691 | (37.7608529276064, -122.447758347691) | 15 | 5 | 11 | 29492 | 12 | ||
| 79347 | 32996 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.02247 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | 6 | 2 | 9 | 28853 | 6 | |
| 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 | |||||
| 80215 | 119712 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 81332 | 52332 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.459292150941 | (37.7353714395789, -122.459292150941) | 9 | 7 | 4 | 59 | 40 | ||||
| 81384 | 51562 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4083 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | 18 | Permit Number 47860 | 6001768 | 2105813 | 37.7622609540043 | -122.437028189167 | (37.7622609540043, -122.437028189167) | 15 | 5 | 5 | 28862 | 3 | ||
| 82953 | 198612 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015981.50348 | 2108634.31081 | 37.770805305558 | -122.388065489139 | (37.770805305558, -122.388065489139) | 14 | 3 | 9 | 310 | 20 | ||||
| 84509 | 33151 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.7418697871522 | -122.487350256926 | (37.7418697871522, -122.487350256926) | 1 | 8 | 3 | 29491 | 35 | |
| 84560 | 110034 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008245.7 | 2102789.4 | 37.7543249025472 | -122.414410241803 | (37.7543249025472, -122.414410241803) | 2 | 4 | 7 | 28859 | 19 | |||||
| 85012 | 119676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 85066 | 47527 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
| 85126 | 34988 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47856 | 6004110.40789501 | 2102908.72400582 | 37.7544193649252 | -122.428719637491 | (37.7544193649252, -122.428719637491) | 2 | 4 | 5 | 28862 | 22 | |||
| 85472 | 198641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | 14 | 3 | 9 | 310 | 20 | ||||
| 85844 | 119675 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
| 86066 | 69124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.425679204983 | (37.7760283687547, -122.425679204983) | 7 | 9 | 11 | 28852 | 10 | |
| 86168 | 44116 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
| 87092 | 242400 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 5 | 6004412.57648 | 2096019.13863 | 37.7355192458083 | -122.427183945908 | (37.7355192458083, -122.427183945908) | 2 | 7 | 5 | 28861 | 2 | ||||
| 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 | ||||
| 88210 | 198604 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016296.79375 | 2108651.46445 | 37.7708698687766 | -122.386976080084 | (37.7708698687766, -122.386976080084) | 14 | 3 | 9 | 310 | 20 | ||||
| 88315 | 198603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016318.41228 | 2108651.0285 | 37.7708698687754 | -122.386901269979 | (37.7708698687754, -122.386901269979) | 14 | 3 | 9 | 310 | 20 | ||||
| 89957 | 119827 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 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 | ||||
| 90759 | 32989 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.33259 | 37.7843240827368 | -122.398422883105 | (37.7843240827368, -122.398422883105) | 6 | 2 | 9 | 28853 | 6 | |
| 90967 | 33602 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | 2 | 7 | 7 | 28859 | 2 | ||
| 91488 | 100581 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
| 92189 | 36145 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | 8 | 4 | 8 | 28859 | 19 | ||
| 97900 | 106019 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1942 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6003927.2972 | 2115156.9668 | 37.7880396862695 | -122.430226645832 | (37.7880396862695, -122.430226645832) | 13 | 9 | 11 | 29490 | 27 | ||||
| 98216 | 119713 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) |
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) );