trees
2,365 rows where qSpecies_id = 31 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
| 154 | 119838 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 206 | 119799 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 225 | 119839 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 238 | 119796 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 263 | 17585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | 9 | 7 | 6 | 28861 | 5 | |||
| 265 | 18017 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2713 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000875.2767 | 2114835.3915 | 37.7869833841555 | -122.440762994582 | (37.7869833841555, -122.440762994582) | 13 | 6 | 1 | 29490 | 27 | |||
| 344 | 119791 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 395 | 246548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.7724235852138 | -122.423543772638 | (37.7724235852138, -122.423543772638) | 7 | 9 | 11 | 28852 | 10 | |||
| 406 | 119837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 428 | 119830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 442 | 119718 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 481 | 119782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
| 1830 | 85780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.411697620327 | (37.7735740897245, -122.411697620327) | 8 | 2 | 9 | 28853 | 34 | ||
| 1908 | 119794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 7 | 9 | 11 | 28852 | 10 | |||
| 2405 | 7621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3227 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 6x9 | 6008480.64653 | 2099830.22389 | 37.7462128639419 | -122.413388474314 | (37.7462128639419, -122.413388474314) | 2 | 7 | 7 | 28859 | 2 | |||
| 2469 | 260495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 2605 | 19985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
| 2974 | 260217 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010872 | 2093992 | 37.7303163237311 | -122.404708489988 | (37.7303163237311, -122.404708489988) | 10 | 3 | 7 | 309 | 28 | ||||
| 3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 3373 | 119797 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 3417 | 119788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 3479 | 7598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3106 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6008393.64019 | 2100437.22493 | 37.7478746680801 | -122.413732259957 | (37.7478746680801, -122.413732259957) | 2 | 7 | 7 | 28859 | 2 | |||
| 3814 | 23654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 228 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X6 | 6006768.61882 | 2098382.75486 | 37.742142166343 | -122.419205808214 | (37.742142166343, -122.419205808214) | 2 | 7 | 7 | 28859 | 2 | |||
| 4213 | 251107 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 4570 | 119828 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 4856 | 17502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002131.24887 | 2091360.19572 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | 9 | 7 | 6 | 28861 | 5 | |||
| 5011 | 119790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 5574 | 259351 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 443 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010386.58434 | 2092559.48475 | 37.7263557946777 | -122.406285753959 | (37.7263557946777, -122.406285753959) | 10 | 3 | 7 | 309 | 28 | ||
| 6065 | 14837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1306 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002857.7118 | 2111688.5769 | 37.7784557229826 | -122.433679236224 | (37.7784557229826, -122.433679236224) | 15 | 5 | 11 | 29490 | 41 | ||
| 6138 | 244422 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.7731308974862 | -122.423735193743 | (37.7731308974862, -122.423735193743) | 7 | 9 | 11 | 28852 | 10 | |||
| 6452 | 109163 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 12 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 6695 | 260396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 6820 | 244317 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005516.527 | 2110492.6418 | 37.7753224827652 | -122.424396296997 | (37.7753224827652, -122.424396296997) | 7 | 9 | 11 | 28852 | 10 | |||
| 7980 | 260398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 8039 | 260496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 8844 | 119789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 9242 | 119783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 9914 | 259754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4041 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x9 | 6003639.19109 | 2100382.47433 | 37.7474561955544 | -122.430169014304 | (37.7474561955544, -122.430169014304) | 2 | 4 | 5 | 63 | 22 | ||||
| 10127 | 119793 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 10263 | 119836 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
| 10966 | 109166 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11086 | 242374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006546.0037 | 2109148.19709 | 37.7716890396519 | -122.420739627149 | (37.7716890396519, -122.420739627149) | 8 | 2 | 9 | 28853 | 19 | |||
| 11525 | 119754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 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 | |||
| 11980 | 7531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2829 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008362.05512 | 2101958.45001 | 37.752049837241 | -122.413949076587 | (37.752049837241, -122.413949076587) | 2 | 4 | 7 | 28859 | 19 | |||
| 12068 | 26637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X3 | ||||||||||||
| 12246 | 119784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 13324 | 119752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 14547 | 119749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 15104 | 16448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 15578 | 119832 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 15738 | 119781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 16699 | 97434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380x Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
| 17081 | 17955 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
| 17212 | 17525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6002628.09189 | 2091001.66682 | 37.7216413261572 | -122.432995221074 | (37.7216413261572, -122.432995221074) | 9 | 7 | 6 | 28861 | 5 | |||
| 17973 | 17607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 948X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003925.7500102 | 2090181.5613293 | 37.7194630169915 | -122.428451137586 | (37.7194630169915, -122.428451137586) | 9 | 7 | 6 | 28861 | 5 | |||
| 18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 18433 | 260397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 18715 | 17618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
| 19093 | 25174 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.7611250309289 | -122.442663135402 | (37.7611250309289, -122.442663135402) | 15 | 5 | 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 | |||
| 19592 | 23636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 112 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6006546.53068 | 2098501.49483 | 37.7424556897773 | -122.419982145278 | (37.7424556897773, -122.419982145278) | 2 | 7 | 7 | 28859 | 2 | |||
| 19858 | 109170 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
| 20556 | 18546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | 10 | 3 | 8 | 58 | 1 | |||
| 20748 | 18055 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.7868182138227 | -122.443122531996 | (37.7868182138227, -122.443122531996) | 13 | 6 | 1 | 29490 | 27 | |||
| 21183 | 254244 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
| 21528 | 242621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6008442.97152 | 2099602.35151 | 37.7455850616153 | -122.413502636934 | (37.7455850616153, -122.413502636934) | 2 | 7 | 7 | 28859 | 2 | |||
| 21755 | 13324 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
| 23251 | 119710 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 23450 | 91035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.406633247496 | (37.7775764693736, -122.406633247496) | 14 | 2 | 9 | 28853 | 34 | ||
| 23559 | 17486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
| 23746 | 7561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2921 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6008393.48132 | 2101389.94596 | 37.7504906178693 | -122.413800190239 | (37.7504906178693, -122.413800190239) | 2 | 4 | 7 | 28859 | 19 | |||
| 24002 | 198501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900x Carolina St | 13 | Median : Yard | Tree | DPW 1 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | 10 | 3 | 8 | 28856 | 29 | ||||
| 24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
| 24722 | 244306 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303 | (37.7753816404734, -122.42418868303) | 7 | 9 | 11 | 28852 | 10 | |||
| 24738 | 16679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 248 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002873.9908755 | 2106855.8321643 | 37.7651871206567 | -122.433277506161 | (37.7651871206567, -122.433277506161) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | ||
| 25169 | 17576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.7201172080443 | -122.429795147634 | (37.7201172080443, -122.429795147634) | 9 | 7 | 6 | 28861 | 5 | |||
| 25513 | 17523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002491.854148 | 2091141.7505443 | 37.7220182361725 | -122.433476163825 | (37.7220182361725, -122.433476163825) | 9 | 7 | 6 | 28861 | 5 | |||
| 25646 | 7497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008270.16145 | 2102659.31707 | 37.753969098407 | -122.414316444274 | (37.753969098407, -122.414316444274) | 2 | 4 | 7 | 28859 | 19 | |||
| 25820 | 25189 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3733 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000311.6199976 | 2102932.6354717 | 37.7542692908961 | -122.441858505139 | (37.7542692908961, -122.441858505139) | 2 | 4 | 5 | 63 | 38 | |||
| 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 | |||
| 26377 | 18527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
| 26388 | 244359 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.424374111287 | (37.7752229798737, -122.424374111287) | 7 | 9 | 11 | 28852 | 10 | |||
| 26629 | 7553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6008325.6957 | 2101595.54831 | 37.751051348746 | -122.41404914235 | (37.751051348746, -122.41404914235) | 2 | 4 | 7 | 28859 | 19 | |||
| 26729 | 7657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3334 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008459.10706 | 2099217.21001 | 37.7445284544392 | -122.413419609751 | (37.7445284544392, -122.413419609751) | 2 | 7 | 7 | 28859 | 2 | |||
| 26832 | 7543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2872 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008316.06064 | 2101754.32335 | 37.7514867681181 | -122.414093692993 | (37.7514867681181, -122.414093692993) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 27032 | 119717 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 27268 | 16442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 27279 | 7440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2528 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008209.2972 | 2103689.65921 | 37.7567947646774 | -122.414599835016 | (37.7567947646774, -122.414599835016) | 2 | 4 | 7 | 28859 | 19 | |||
| 27895 | 23744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1111X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003857.72301 | 2111778.219 | 37.7787585493448 | -122.430226218205 | (37.7787585493448, -122.430226218205) | 15 | 9 | 11 | 29492 | 41 | |||
| 27901 | 7664 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3348 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008462.72403 | 2099121.09112 | 37.7442647363292 | -122.413400306703 | (37.7442647363292, -122.413400306703) | 2 | 7 | 7 | 28859 | 2 | |||
| 28436 | 17602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | 9 | 7 | 6 | 28861 | 5 |
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) );