trees
2,365 rows where qSpecies_id = 31
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 | ||
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 | |||
96 | 137041 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009697.84819 | 2116804.05029 | 37.7928873337267 | -122.410377820179 | (37.7928873337267, -122.410377820179) | 3 | 1 | 10 | 28857 | 21 | ||
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 | |||
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) | ||||||||||
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 | |||
969 | 198677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010377.80869 | 2111537.89689 | 37.7784658224798 | -122.407653636128 | (37.7784658224798, -122.407653636128) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||
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 | ||
1850 | 138602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2660 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:03:00 PM | 3 | Width 0ft | 6001218.2318 | 2114936.9229 | 37.7872816882761 | -122.439583731447 | (37.7872816882761, -122.439583731447) | 13 | 6 | 1 | 29490 | 27 | ||
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) | ||||||||||
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 | |||
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 | |||||||||||||
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 | |
2754 | 198688 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 165 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008649.71032 | 2110465.86433 | 37.7754253882045 | -122.413555960437 | (37.7754253882045, -122.413555960437) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||||
3023 | 137045 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.7925550234358 | -122.412997178389 | (37.7925550234358, -122.412997178389) | 5 | 1 | 10 | 28857 | 21 | |||
3172 | 138586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2702 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000914.7508 | 2114889.5525 | 37.7871343442132 | -122.440630309715 | (37.7871343442132, -122.440630309715) | 13 | 6 | 1 | 29490 | 27 | |||
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 | ||
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) | ||||||||||
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 | ||
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) | ||||||||||
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 | |||
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 | |||
3611 | 242616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Highland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
4061 | 46914 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 3 | 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 | ||
4133 | 138411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002152.1984 | 2115012.2116 | 37.7875415238713 | -122.436357800436 | (37.7875415238713, -122.436357800436) | 13 | 6 | 11 | 29490 | 27 | |||
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 | |||||||||||||||
4228 | 254718 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
4429 | 97836 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
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) | ||||||||||
4576 | 137643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1313 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002875.8523 | 2111640.465 | 37.7783246490231 | -122.43361304212 | (37.7783246490231, -122.43361304212) | 15 | 5 | 11 | 29492 | 41 | |||
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 | |||
4643 | 76181 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) | 8 | 2 | 9 | 28853 | 34 | |||
4645 | 107053 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | |||||
4702 | 198610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016166.07078 | 2108644.55968 | 37.7708436706185 | -122.387427776296 | (37.7708436706185, -122.387427776296) | 14 | 3 | 9 | 310 | 20 | ||||
4784 | 242408 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3711 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6005560.82063 | 2104287.7294 | 37.7582877732797 | -122.42380177823 | (37.7582877732797, -122.42380177823) | 2 | 4 | 5 | 28859 | 19 | |||
4812 | 198517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 2 | : | Tree | Private 2 | 5 | Width 7ft | 6014346.73951 | 2096322.78373 | 37.7369097775472 | -122.392858747949 | (37.7369097775472, -122.392858747949) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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) | ||||||||||
5056 | 248171 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 314 Franconia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010101.97177 | 2099246.95589 | 37.7447022358135 | -122.407740986359 | (37.7447022358135, -122.407740986359) | 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 | ||
5601 | 180565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | |||
5767 | 237723 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 175 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6000298.26897 | 2105610.5096 | 37.7616213164011 | -122.442096884487 | (37.7616213164011, -122.442096884487) | 15 | 5 | 5 | 28862 | 3 | |||
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 |
5992 | 115018 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4311 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000722 | 2105756 | 37.7620449359843 | -122.440641810954 | (37.7620449359843, -122.440641810954) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
6385 | 85779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009155.5683 | 2109764.3815 | 37.7735276724734 | -122.411756494108 | (37.7735276724734, -122.411756494108) | 8 | 2 | 9 | 28853 | 34 | ||
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) | |||||||||
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 | |||
6498 | 242573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5x9 | 6008115.25699 | 2106522.97754 | 37.7645691213862 | -122.415125610158 | (37.7645691213862, -122.415125610158) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||||||||||||
6749 | 242499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008244.84467 | 2103100.98301 | 37.7551803907701 | -122.414435245603 | (37.7551803907701, -122.414435245603) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
7095 | 198444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015385.26433 | 2106283.84094 | 37.7643183769187 | -122.389963693588 | (37.7643183769187, -122.389963693588) | 14 | 3 | 9 | 310 | 29 | |||
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 | |||
7172 | 242618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007915.14616 | 2096519.82077 | 37.7370914621948 | -122.415109628301 | (37.7370914621948, -122.415109628301) | 2 | 7 | 7 | 28859 | 2 | |||
7235 | 74494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.405957737757 | (37.7645082103165, -122.405957737757) | 8 | 4 | 8 | 28859 | 19 | |||
7295 | 100582 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
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 |
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) );