2,365 rows where qSpecies_id = 31 sorted by PlantDate

View and edit SQL

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)
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)          
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
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
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
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)          
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
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                              
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
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
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
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
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
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
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
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
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
8303 180530 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 445 Persia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6002899 2090905 37.7213912632755 -122.432051865162 (37.7213912632755, -122.432051865162) 9 7 6 28861 5
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
8560 242617 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300 Bennington St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007051.1369 2096685.57383 37.7374979908344 -122.418108653317 (37.7374979908344, -122.418108653317) 2 7 7 28859 2
8701 200755 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5099 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6014751.1238 2094745.6812 37.7326018284177 -122.391350385093 (37.7326018284177, -122.391350385093) 10 3 8 58 1
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)          
9012 180529 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 445 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6002899 2090905 37.7213912632755 -122.432051865162 (37.7213912632755, -122.432051865162) 9 7 6 28861 5
9031 74649 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2233 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6010746.42629 2106444.22464 37.7645003969982 -122.406019510419 (37.7645003969982, -122.406019510419) 8 4 8 28859 19
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
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)          
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
9860 261981 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 853 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6004377.23368 2103892.56966 37.7571358712273 -122.427866984578 (37.7571358712273, -122.427866984578) 2 4 5 28862 3
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
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)          
10264 137022 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003025.71137 2117483.5061 37.7943766605074 -122.433512298867 (37.7943766605074, -122.433512298867) 13 9 1 29490 27
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
10327 198443 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015407.0439 2106284.70526 37.7643219580036 -122.389888423915 (37.7643219580036, -122.389888423915) 14 3 9 310 29

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