trees
2,365 rows where qSpecies_id = 31 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||
| 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 | ||||
| 12615 | 87685 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 Virginia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | 2 | 7 | 7 | 28859 | 2 | |||
| 43704 | 88338 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Paris St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541 | 2091742 | 37.7236691751532 | -122.433349150158 | (37.7236691751532, -122.433349150158) | 9 | 7 | 6 | 28861 | 5 | |||
| 57138 | 104401 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 727 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999017 | 2108166 | 37.768564950056 | -122.44671213341 | (37.768564950056, -122.44671213341) | 15 | 5 | 11 | 29492 | 9 | ||||
| 87095 | 88329 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 120 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940 | 2092960 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | 9 | 7 | 6 | 28861 | 5 | |||
| 118552 | 110612 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586 | 2101167 | 37.7490933856104 | -122.461530994698 | (37.7490933856104, -122.461530994698) | 1 | 8 | 4 | 29491 | 40 | ||
| 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 | |||
| 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 | ||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
| 147 | 198543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | : | Tree | Private 2 | 3 | Width 0ft | 6014375.16951 | 2096346.21278 | 37.7369756879815 | -122.392762090617 | (37.7369756879815, -122.392762090617) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 820 | 41547 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | 2 | 4 | 5 | 28862 | 3 | |||
| 1367 | 242756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 188 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000188.06394 | 2105671.62419 | 37.7617828409166 | -122.442482425621 | (37.7617828409166, -122.442482425621) | 15 | 5 | 5 | 28862 | 3 | |||
| 1609 | 7556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2908 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6008332.64418 | 2101445.38004 | 37.7506394106909 | -122.414014491473 | (37.7506394106909, -122.414014491473) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | ||
| 2080 | 51849 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4000 19th St | 1 | 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 | |||
| 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 | |||
| 2305 | 251465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
| 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 | |||
| 2613 | 242693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002933 | 2104797 | 37.7595374124063 | -122.432926308416 | (37.7595374124063, -122.432926308416) | 2 | 4 | 5 | 28862 | 3 | |||
| 2661 | 123693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995461.17658 | 2113536.44974 | 37.7831070225625 | -122.459400327451 | (37.7831070225625, -122.459400327451) | 11 | 6 | 2 | 54 | 11 | |||
| 2748 | 51918 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.92432 | 2091688.24542 | 37.7233599872689 | -122.443166369055 | (37.7233599872689, -122.443166369055) | 9 | 7 | 6 | 28861 | 25 | |
| 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 | ||||
| 3281 | 18051 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2840 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1999 12:00:00 AM | 6 | 3X3PL | 6000336.3598 | 2114811.683 | 37.7868875811217 | -122.442625816895 | (37.7868875811217, -122.442625816895) | 13 | 6 | 1 | 29490 | 27 | ||
| 3398 | 30348 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 420 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1956 12:00:00 AM | 13 | Permit Number 31 | 6012919.88824 | 2105064.35635 | 37.7608329059296 | -122.398405220419 | (37.7608329059296, -122.398405220419) | 10 | 3 | 8 | 28856 | 29 | ||
| 3454 | 136963 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2590 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000644.64668 | 2118255.6964 | 37.7963615110306 | -122.441806488875 | (37.7963615110306, -122.441806488875) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 3886 | 7433 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008263.61131 | 2103755.89394 | 37.7569796814773 | -122.414416682704 | (37.7569796814773, -122.414416682704) | 2 | 4 | 7 | 28859 | 19 | |||
| 3906 | 242754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 78 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001027.40301 | 2105958.45714 | 37.7626182202887 | -122.439600057097 | (37.7626182202887, -122.439600057097) | 15 | 5 | 5 | 28862 | 3 | |||
| 4054 | 61321 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1493 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 2 | Permit Number 21224 | 6011782.72959 | 2101393.64443 | 37.750690525464 | -122.40208010572 | (37.750690525464, -122.40208010572) | 10 | 3 | 8 | 28856 | 29 | |
| 4146 | 242645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3226 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008172.83241 | 2101552.12353 | 37.7509235272008 | -122.414574688189 | (37.7509235272008, -122.414574688189) | 2 | 4 | 7 | 28859 | 19 | |||
| 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) | ||||||||||
| 4577 | 137042 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008994.19297 | 2117174.51361 | 37.7938650649634 | -122.412838714232 | (37.7938650649634, -122.412838714232) | 3 | 1 | 10 | 28857 | 21 | |||
| 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 | |||
| 4995 | 242611 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 121 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6006528.89277 | 2098549.54535 | 37.7425866319823 | -122.420046541223 | (37.7425866319823, -122.420046541223) | 2 | 7 | 7 | 28859 | 2 | |||
| 5182 | 242721 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 291 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6004399.96765 | 2103934.30493 | 37.7572517524893 | -122.427791335409 | (37.7572517524893, -122.427791335409) | 2 | 4 | 5 | 28862 | 3 | |||
| 5237 | 200943 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008270.8642 | 2108872.4279 | 37.7710289077095 | -122.41475368939 | (37.7710289077095, -122.41475368939) | 8 | 2 | 9 | 28853 | 19 | |||
| 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 | |||
| 5503 | 7438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2525 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008265.55566 | 2103676.03648 | 37.7567605203109 | -122.414404308016 | (37.7567605203109, -122.414404308016) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 5878 | 236882 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 150 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 5 | Width 3ft | Permit Number 772898 | 5999413.41178 | 2107340.88769 | 37.7663220358477 | -122.445281650937 | (37.7663220358477, -122.445281650937) | 15 | 5 | 5 | 29492 | 9 | |
| 5917 | 66634 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 963 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | 5 | 3x3 | Permit Number 29842 | 6010240.69544356 | 2103618.46143652 | 37.7567131899968 | -122.407569458435 | (37.7567131899968, -122.407569458435) | 10 | 4 | 7 | 28859 | 19 |
| 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 | ||
| 6194 | 198430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 312 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010577.37661 | 2106819.14849 | 37.7655203963654 | -122.406630632998 | (37.7655203963654, -122.406630632998) | 8 | 4 | 8 | 28853 | 19 | |||
| 6477 | 215562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | 9 | 8 | 4 | 59 | 40 | |||
| 6558 | 57073 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.7584195158777 | -122.390379311651 | (37.7584195158777, -122.390379311651) | 10 | 3 | 8 | 28856 | 29 | ||
| 6579 | 242676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3937 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003536.02331 | 2102417.7982 | 37.7530388738604 | -122.430670977181 | (37.7530388738604, -122.430670977181) | 2 | 4 | 5 | 28862 | 22 | |||
| 6913 | 215496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 69 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993975.72153 | 2097357.94979 | 37.7385995461283 | -122.463364953343 | (37.7385995461283, -122.463364953343) | 1 | 8 | 4 | 59 | 40 | |||
| 7090 | 52720 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 710@ 20th ST Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2006 12:00:00 AM | Permit Number 48773 | 6002386.64959974 | 2104032.25895211 | 37.757406613771 | -122.434761169877 | (37.757406613771, -122.434761169877) | 2 | 4 | 5 | 28862 | 3 | |||
| 7134 | 7508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2733 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008332.69798 | 2102504.20303 | 37.7535467030383 | -122.414089204467 | (37.7535467030383, -122.414089204467) | 2 | 4 | 7 | 28859 | 19 | |||
| 7847 | 7489 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008322.6919 | 2102757.85565 | 37.7542426137298 | -122.414141751858 | (37.7542426137298, -122.414141751858) | 2 | 4 | 7 | 28859 | 19 | |||
| 8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
| 8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
| 8503 | 80188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.413264744885 | (37.7723172927739, -122.413264744885) | 8 | 2 | 9 | 28853 | 34 | |||
| 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) | ||||||||||
| 9179 | 215530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994021.33126 | 2097709.05499 | 37.7395662211057 | -122.463232727835 | (37.7395662211057, -122.463232727835) | 1 | 8 | 4 | 59 | 40 | |||
| 9357 | 106645 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.7574100789152 | -122.437366369677 | (37.7574100789152, -122.437366369677) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 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 | ||||
| 9921 | 220013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005865.66076 | 2102301.94093 | 37.7528524632741 | -122.42260639579 | (37.7528524632741, -122.42260639579) | 2 | 4 | 5 | 28859 | 19 | |||
| 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) | ||||||||||
| 10187 | 242636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3357 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6008524.39622 | 2099125.83566 | 37.7442812262921 | -122.413187392191 | (37.7442812262921, -122.413187392191) | 2 | 7 | 7 | 28859 | 2 | |||
| 10265 | 242383 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005959.30946 | 2107292.9046 | 37.7665617645426 | -122.422637178672 | (37.7665617645426, -122.422637178672) | 8 | 4 | 5 | 28853 | 19 | |||
| 10305 | 98993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1919 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768862 | 6003810 | 2118645 | 37.7976102909597 | -122.430881499482 | (37.7976102909597, -122.430881499482) | 13 | 9 | 1 | 57 | 17 | |
| 10797 | 49734 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2940REVISED Folsom St | 1 | 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 | ||
| 11968 | 242397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1784 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x8 | 6005589.03646 | 2107271.34136 | 37.7664816601377 | -122.423916355479 | (37.7664816601377, -122.423916355479) | 8 | 4 | 5 | 28853 | 19 | |||
| 11978 | 7458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2576 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2019 12:00:00 AM | 3 | 5x5 | 6008224.65711 | 2103426.0166 | 37.7560717250334 | -122.41452805924 | (37.7560717250334, -122.41452805924) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 12015 | 242657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 502 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001803.26335 | 2102879.5886 | 37.7542085204161 | -122.436696239741 | (37.7542085204161, -122.436696239741) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||||||||||
| 13245 | 17573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6003469.36772 | 2090473.15538 | 37.7202378333854 | -122.430049472832 | (37.7202378333854, -122.430049472832) | 9 | 7 | 6 | 28861 | 5 | |||
| 13803 | 74944 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010701.03805 | 2106443.01503 | 37.7644945370101 | -122.406176411522 | (37.7644945370101, -122.406176411522) | 8 | 4 | 8 | 28859 | 19 | |||
| 13822 | 115740 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4075 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6001859 | 2105815 | 37.7622716175276 | -122.436713598175 | (37.7622716175276, -122.436713598175) | 15 | 5 | 5 | 28862 | 3 | |||
| 14326 | 112045 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785474 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | 13 | 9 | 1 | 29490 | 27 | |
| 14815 | 114434 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 576 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002952 | 2104864 | 37.7597224559637 | -122.432865383548 | (37.7597224559637, -122.432865383548) | 2 | 4 | 5 | 28862 | 3 | |||
| 14897 | 242642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 952 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007375.48933 | 2101738.08123 | 37.7513892968874 | -122.417345160358 | (37.7513892968874, -122.417345160358) | 2 | 4 | 7 | 28859 | 19 | |||
| 15262 | 73760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997597.70095 | 2116065.74811 | 37.7901744154595 | -122.452191417426 | (37.7901744154595, -122.452191417426) | 11 | 6 | 1 | 54 | 31 | |||
| 15421 | 242745 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4048 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 7x4 | 6001990.5336 | 2105890.39532 | 37.762486108974 | -122.436264069635 | (37.762486108974, -122.436264069635) | 15 | 5 | 5 | 28862 | 3 | |||
| 15645 | 137035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 128 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008088.76932 | 2112909.47489 | 37.7821034452579 | -122.415669449996 | (37.7821034452579, -122.415669449996) | 7 | 10 | 9 | 28852 | 36 | |||
| 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) | ||||||||||
| 15764 | 258890 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
| 15809 | 54753 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4140-4142 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | Permit Number 10601 | 6002268.53854801 | 2101815.27696084 | 37.7513126050411 | -122.435011090977 | (37.7513126050411, -122.435011090977) | 2 | 4 | 5 | 28862 | 22 | |||
| 16396 | 242589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002102 | 2102108 | 37.7521068951849 | -122.435607938928 | (37.7521068951849, -122.435607938928) | 2 | 4 | 5 | 28862 | 22 | |||
| 16688 | 137060 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011807.58318 | 2118407.27 | 37.7974074315733 | -122.403190818824 | (37.7974074315733, -122.403190818824) | 3 | 1 | 10 | 308 | 23 | |||
| 16717 | 262293 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002408 | 2117119 | 37.7933407549318 | -122.435623560602 | (37.7933407549318, -122.435623560602) | 13 | 9 | 1 | 29490 | 27 | ||||
| 16945 | 180528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
| 17144 | 48943 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901 | (37.7524811515419, -122.40536498901) | 10 | 4 | 8 | 28859 | 19 | ||
| 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 | |||
| 17803 | 117536 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 601 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002803 | 2108833 | 37.7706119122875 | -122.433664364997 | (37.7706119122875, -122.433664364997) | 15 | 5 | 5 | 29492 | 9 | ||||
| 17960 | 81238 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008758.1555 | 2109381.0971 | 37.7724529612773 | -122.41310410127 | (37.7724529612773, -122.41310410127) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 |
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) );