2,365 rows where qSpecies_id = 31

View and edit SQL

Suggested facets: SiteOrder

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);