trees
2,365 rows where qSpecies_id = 31 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121002 | 251466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
123476 | 119800 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
124451 | 87307 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
126141 | 119803 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
127662 | 119677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
128168 | 98270 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
128296 | 110096 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 19 DANVERS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999798.2 | 2105476.6 | 37.7612251228861 | -122.443816792986 | (37.7612251228861, -122.443816792986) | 15 | 5 | 5 | 28862 | 3 | ||||
128891 | 173830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000494 | 2114864 | 37.7870402148899 | -122.442084176412 | (37.7870402148899, -122.442084176412) | 13 | 6 | 1 | 29490 | 27 | ||||
129449 | 46210 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3720 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | Permit Number 44526 | 6003610.24375185 | 2103058.68100506 | 37.7548027913083 | -122.430460032532 | (37.7548027913083, -122.430460032532) | 2 | 4 | 5 | 28862 | 22 | |||
129678 | 119716 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
131687 | 87287 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096 | 2105951 | 37.7624304670172 | -122.449738139948 | (37.7624304670172, -122.449738139948) | 15 | 5 | 11 | 29492 | 9 | ||
134418 | 119719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
135352 | 108481 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
137883 | 31072 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 7 | 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 | ||
138910 | 107992 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4410x 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000358 | 2102265 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | 2 | 4 | 5 | 28862 | 22 | ||||
139032 | 114306 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997219 | 2107398 | 37.7663533458689 | -122.452875791584 | (37.7663533458689, -122.452875791584) | 15 | 5 | 11 | 29492 | 9 | ||||
139973 | 119829 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
140296 | 43563 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 511 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | 2 | 7 | 5 | 63 | 22 | ||
140749 | 48645 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | 1 | 8 | 4 | 56 | 12 | ||
141470 | 46502 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 2 | 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 | |||
142223 | 103419 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
143441 | 103420 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
143782 | 43394 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 625 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43137 | 6002354.2327444 | 2102058.9743147 | 37.7519866054834 | -122.434732175811 | (37.7519866054834, -122.434732175811) | 2 | 4 | 5 | 28862 | 22 | ||
144725 | 97832 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
146851 | 97845 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
147410 | 108134 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2055 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | 8 | 4 | 7 | 28859 | 19 | ||||
147491 | 88436 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1631 Folsom St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51400 | 6008146 | 2108680 | 37.7704935294513 | -122.415171976468 | (37.7704935294513, -122.415171976468) | 8 | 2 | 9 | 28853 | 19 | |||
147538 | 50047 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46778 | 6002356.09000511 | 2104575.82706483 | 37.7588973859125 | -122.434905729534 | (37.7588973859125, -122.434905729534) | 2 | 4 | 5 | 28862 | 3 | |||
148155 | 107599 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 177 CORBETT AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000269.8 | 2105595.5 | 37.7615784812961 | -122.442194269292 | (37.7615784812961, -122.442194269292) | 15 | 5 | 5 | 28862 | 3 | ||||||
148260 | 46503 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 5 | 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 | |||
148761 | 44268 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | 2 | 7 | 7 | 28859 | 2 | ||
149108 | 119747 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
149284 | 119680 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
149916 | 115484 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1924 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012266 | 2104770 | 37.7599882208521 | -122.400646065117 | (37.7599882208521, -122.400646065117) | 10 | 3 | 8 | 28856 | 29 | ||||
150725 | 63592 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | 3x3 | Permit Number 24223 | 6005148 | 2109920 | 37.7737293302527 | -122.425630352746 | (37.7737293302527, -122.425630352746) | 7 | 9 | 11 | 28852 | 10 | ||
150836 | 119682 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
151627 | 108869 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2360 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008129 | 2104684.1 | 37.7595207600627 | -122.414947915343 | (37.7595207600627, -122.414947915343) | 2 | 4 | 7 | 28859 | 19 | ||||
151881 | 47711 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.7369794845402 | -122.435360375218 | (37.7369794845402, -122.435360375218) | 2 | 7 | 5 | 63 | 7 | ||
152559 | 97838 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
152742 | 97847 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
153488 | 92522 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005 | 2109688 | 37.773309499002 | -122.412271934387 | (37.773309499002, -122.412271934387) | 8 | 2 | 9 | 28853 | 34 | ||
156020 | 44112 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 5 | 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 | |||
156133 | 100625 | 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 | |||||
156161 | 97833 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
156235 | 119817 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
157733 | 82639 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.416226690034 | (37.7626615773847, -122.416226690034) | 8 | 4 | 7 | 28859 | 19 | ||
158775 | 32532 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 1 | 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 | ||
159379 | 92019 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52167 | 6008096 | 2112840 | 37.7819130903868 | -122.415639514466 | (37.7819130903868, -122.415639514466) | 7 | 10 | 9 | 28852 | 36 | |||
159935 | 43393 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | 2 | 4 | 5 | 28862 | 22 | ||
160961 | 35492 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | 2 | 4 | 5 | 28859 | 19 | ||
161548 | 109167 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 8 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
161728 | 117578 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 701x CALIFORNIA ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6010911 | 2116555 | 37.7922714332447 | -122.406162679671 | (37.7922714332447, -122.406162679671) | 5 | 1 | 10 | 28857 | 6 | ||||
163066 | 108234 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
163070 | 36147 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 3 | 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 | ||
164216 | 98273 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
164751 | 40844 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41772 | 6003136.41051744 | 2107916.36050667 | 37.7681139569619 | -122.432445614329 | (37.7681139569619, -122.432445614329) | 15 | 5 | 5 | 28862 | 3 | ||||
165603 | 119792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
166196 | 119736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
168239 | 46913 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
168553 | 107830 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 145 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999377 | 2107392 | 37.7664602988917 | -122.445411267501 | (37.7664602988917, -122.445411267501) | 15 | 5 | 5 | 29492 | 9 | |||||
169265 | 110630 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991857 | 2101850 | 37.7508112705894 | -122.471017566011 | (37.7508112705894, -122.471017566011) | 1 | 8 | 4 | 29491 | 12 | |||||
169881 | 52081 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.7637380891551 | -122.448274099423 | (37.7637380891551, -122.448274099423) | 15 | 5 | 11 | 29492 | 9 | |||
170626 | 88830 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51714 | 6015215 | 2104389 | 37.7591061085001 | -122.390420190559 | (37.7591061085001, -122.390420190559) | 10 | 3 | 8 | 28856 | 29 | |||
171620 | 87306 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
172519 | 97844 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
172713 | 49790 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2862 & YORK 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46574 | 6010228.54978873 | 2101669.78710325 | 37.7513618837191 | -122.40747408248 | (37.7513618837191, -122.40747408248) | 2 | 4 | 7 | 28859 | 19 | |||
173056 | 122420 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
173780 | 119823 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
175267 | 119821 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
175636 | 88555 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 609 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51500 | 5990920.3 | 2111212.9 | 37.7764650666065 | -122.474940092984 | (37.7764650666065, -122.474940092984) | 11 | 6 | 2 | 54 | 26 | |||
176444 | 97849 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
177167 | 254242 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
177900 | 63730 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | 15 | 9 | 11 | 29492 | 10 | |
178233 | 102452 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 16394 | 6007849 | 2104746 | 37.7596749854601 | -122.415920680262 | (37.7596749854601, -122.415920680262) | 2 | 4 | 7 | 28859 | 19 | |||
178289 | 119822 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
178302 | 119833 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
178452 | 119834 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
180002 | 258222 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2997 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3x3 | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
180406 | 43363 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.7511616557639 | -122.435122856595 | (37.7511616557639, -122.435122856595) | 2 | 4 | 5 | 28862 | 22 | ||
180678 | 119831 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
181320 | 57535 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1976 12:00:00 AM | 3x3 | Permit Number 16394 | 6007841.0815384 | 2104745.28982278 | 37.7596725902927 | -122.41594801607 | (37.7596725902927, -122.41594801607) | 2 | 4 | 7 | 28859 | 19 | ||
184046 | 46506 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 4 | 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 | |||
184925 | 46912 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
184983 | 52726 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 169 ROOSEVELT Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2006 12:00:00 AM | Permit Number 48781 | 6001418.20285712 | 2107376.9010813 | 37.7665351533118 | -122.438350049909 | (37.7665351533118, -122.438350049909) | 15 | 5 | 5 | 28862 | 3 | |||
185430 | 113083 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009864 | 2093047 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | 10 | 3 | 7 | 309 | 28 | ||||
186333 | 103276 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
187008 | 119825 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
187604 | 43412 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 854 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51843 | 6003073.74768147 | 2103234.41761238 | 37.7552549166143 | -122.432327933003 | (37.7552549166143, -122.432327933003) | 2 | 4 | 5 | 28862 | 22 | ||
188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
188567 | 109070 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 3027 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006619.6 | 2106627.5 | 37.7647719501604 | -122.420306113631 | (37.7647719501604, -122.420306113631) | 8 | 4 | 7 | 28859 | 19 | ||||
188745 | 38953 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.413649132677 | (37.747044527767, -122.413649132677) | 2 | 7 | 7 | 28859 | 2 | |||
189071 | 97835 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
189220 | 121499 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 851 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004400 | 2103913 | 37.7571932560102 | -122.427789705541 | (37.7571932560102, -122.427789705541) | 2 | 4 | 5 | 28862 | 3 | ||||
189843 | 119701 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 3 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
190245 | 37289 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.7561221336837 | -122.434458693674 | (37.7561221336837, -122.434458693674) | 2 | 4 | 5 | 28862 | 3 | |||
190456 | 103270 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
190598 | 119757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
190843 | 119787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
191098 | 255052 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 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) );