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)
10535 258146 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1048 Folsom St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6010642.12041 2111257.36423 37.7777103373451 -122.406719502289 (37.7777103373451, -122.406719502289) 14 2 9 28853 34
10966 109166 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 51x OCTAVIA ST 5 Median : Cutout Tree DPW 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
11086 242374 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x McCoppin St 2 Median : Yard Tree DPW 1     5 Width 9ft   6006546.0037 2109148.19709 37.7716890396519 -122.420739627149 (37.7716890396519, -122.420739627149) 8 2 9 28853 19
11128 198446 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 14 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015345.15707 2106282.18607 37.7643116086136 -122.390102298884 (37.7643116086136, -122.390102298884) 14 3 9 310 29
11178 200944 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1595 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008285.8995 2108891.4726 37.771082044751 -122.41470302964 (37.771082044751, -122.41470302964) 8 2 9 28853 19
11525 119754 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 9 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
11729 244288 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 11 Median : Cutout Tree DPW 1     7 Width 0ft   6005589.8116 2110006.6495 37.7739922036556 -122.424108218812 (37.7739922036556, -122.424108218812) 7 9 11 28852 10
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
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
12027 258891 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6003970 2113206 37.7826852397237 -122.429939681443 (37.7826852397237, -122.429939681443) 7 9 11 29490 41
12246 119784 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 4 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
12738 72412 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3485 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997617.1015 2116066.53919 37.7901776988858 -122.452124350462 (37.7901776988858, -122.452124350462) 11 6 1 54 31
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
13324 119752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 7 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
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
14105 180573 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 515 Burrows St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009834.24274 2093058.41578 37.7276948418209 -122.408230355163 (37.7276948418209, -122.408230355163) 10 3 7 309 28
14201 138412 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2445 PINE ST 8 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6002175.9998 2115015.7118 37.7875524868912 -122.436275703068 (37.7875524868912, -122.436275703068) 13 6 11 29490 27
14245 242715 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3880 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002516.60789 2103579.90107 37.7561719248109 -122.434279383699 (37.7561719248109, -122.434279383699) 2 4 5 28862 3
14547 119749 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 4 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
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
15578 119832 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 5 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
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
15703 74054 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 194X Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 5x5   6010549.99954 2111279.17691 37.7777650752333 -122.407039719318 (37.7777650752333, -122.407039719318) 14 2 9 28853 34
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
16029 198662 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 19 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   6013921.99886 2107418.77263 37.7673533891782 -122.395104256175 (37.7673533891782, -122.395104256175) 14 3 9 310 20
16049 258892 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6003970 2113206 37.7826852397237 -122.429939681443 (37.7826852397237, -122.429939681443) 7 9 11 29490 41
16133 7485 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2676 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008262.291899 2102845.0627354 37.7544786718635 -122.414356800841 (37.7544786718635, -122.414356800841) 2 4 7 28859 19
16269 198600 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1050 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6013090.52825 2107110.01033 37.7664593236741 -122.397958554166 (37.7664593236741, -122.397958554166) 14 3 8 28856 20
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
16481 242572 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2075 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008125.16647 2106366.43702 37.7641398542804 -122.415080254657 (37.7641398542804, -122.415080254657) 8 4 7 28859 19
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
16709 215479 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 85 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992627.2877 2096233.38868 37.7354340044744 -122.467945378584 (37.7354340044744, -122.467945378584) 1 8 4 59 40
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
16748 96876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2100X San Jose Ave 8 Sidewalk: Property side : Yard Tree Private 2           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923) 9 7 6 28861 25
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
17062 198453 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 700 Mariposa St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6015012.52649 2106269.21439 37.7642575368696 -122.391251877095 (37.7642575368696, -122.391251877095) 14 3 9 310 29
17081 17955 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2475 Pine St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002112.5991001 2115004.8317446 37.7875190105667 -122.436494277471 (37.7875190105667, -122.436494277471) 13 6 11 29490 27
17212 17525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 342 Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6002628.09189 2091001.66682 37.7216413261572 -122.432995221074 (37.7216413261572, -122.432995221074) 9 7 6 28861 5
17580 17622 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1100 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6004279.3637264 2089959.3319014 37.7188728276872 -122.427213003456 (37.7188728276872, -122.427213003456) 9 7 6 28861 5
17600 220014 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 58X Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6005814 2102330 37.752926592326 -122.422787042427 (37.752926592326, -122.422787042427) 2 4 5 28859 19
17630 242739 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4097 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6001725.29855 2105828.01986 37.7622997676344 -122.437176952577 (37.7622997676344, -122.437176952577) 15 5 5 28862 3
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
17974 7452 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2567 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008279.66518 2103491.16877 37.7562537082641 -122.414342431978 (37.7562537082641, -122.414342431978) 2 4 7 28859 19
17980 180512 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1027 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004254.69534 2090025.204 37.7190523030053 -122.427302962162 (37.7190523030053, -122.427302962162) 9 7 6 28861 5
17985 242506 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2690 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6008258.82022 2102787.11957 37.7543193780408 -122.414364707265 (37.7543193780408, -122.414364707265) 2 4 7 28859 19
18136 112514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1014 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5992342.97239 2113476.2606 37.7827619817135 -122.47018356399 (37.7827619817135, -122.47018356399) 11 6 2 54 11
18278 242639 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 546 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007844.9141 2104767.39545 37.7597335027307 -122.415936326515 (37.7597335027307, -122.415936326515) 2 4 7 28859 19
18401 146496 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3570 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 4ft   6001206.87483 2120871.25234 37.8035751557371 -122.440048709094 (37.8035751557371, -122.440048709094) 13 9 1 57 17
18546 141885 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1375 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003895.1071 2112829.8704 37.7816482400961 -122.430171937151 (37.7816482400961, -122.430171937151) 7 9 11 29490 41
18698 180522 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 703 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6003548.0155 2090475.44462 37.7202485730803 -122.429777776817 (37.7202485730803, -122.429777776817) 9 7 6 28861 5
18715 17618 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1049X Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3x3   6004182.5788866 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461) 9 7 6 28861 5
18776 242548 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2498 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008191.23851 2104001.87408 37.7576510208955 -122.414684382976 (37.7576510208955, -122.414684382976) 2 4 7 28859 19
18889 242437 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 155 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004941.65866 2098698.95529 37.7429073221216 -122.425545367634 (37.7429073221216, -122.425545367634) 2 7 5 63 22
19093 25174 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3062 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6000130.8652 2105433.23803 37.7611250309289 -122.442663135402 (37.7611250309289, -122.442663135402) 15 5 5 28862 3
19271 102526 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 312 Walnut St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769739 5998624 2115422.5 37.7884669637257 -122.448594170268 (37.7884669637257, -122.448594170268) 13 6 1 54 31
19427 242615 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 195 Virginia Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     7 Width 3ft   6006637.73336 2098498.23096 37.7424518658562 -122.419666561475 (37.7424518658562, -122.419666561475) 2 7 7 28859 2
19592 23636 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 112 Virginia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x4   6006546.53068 2098501.49483 37.7424556897773 -122.419982145278 (37.7424556897773, -122.419982145278) 2 7 7 28859 2
19733 215491 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 45 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5993998.37881 2097545.6525 37.7391162363258 -122.463300232728 (37.7391162363258, -122.463300232728) 1 8 4 59 40
19785 198466 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 707 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6015361.95352 2105766.343 37.7628961467725 -122.390008166863 (37.7628961467725, -122.390008166863) 14 3 8 28856 29
19858 109170 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 5 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
19934 123687 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 24 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995428.99259 2113586.04452 37.7832413460359 -122.459515263281 (37.7832413460359, -122.459515263281) 11 6 2 54 11
19935 242560 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2331 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008202.94857 2104853.89142 37.7599911234086 -122.414704179747 (37.7599911234086, -122.414704179747) 2 4 7 28859 19
19940 141752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2 HOLLIS ST 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003991.9132 2113242.703 37.7827872579582 -122.429866489942 (37.7827872579582, -122.429866489942) 7 9 11 29490 41
19980 98857 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008572.87311 2110548.2851 37.77564738136 -122.413827590795 (37.77564738136, -122.413827590795) 8 2 9 28853 34
20447 198509 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 361 Texas St 1 : Tree Private 2     16 Width 4ft   6013800.26675 2105409.79767 37.7618304159729 -122.395384559572 (37.7618304159729, -122.395384559572) 10 3 8 28856 29
20556 18546 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X Quesada Ave 1 Median : Cutout Tree DPW 1     9 19   6014682.66084 2095048.92479 37.7334306737717 -122.391608273909 (37.7334306737717, -122.391608273909) 10 3 8 58 1
20688 242726 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 66 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003143.88793 2107880.88822 37.7680169827249 -122.432417216901 (37.7680169827249, -122.432417216901) 15 5 5 28862 3
20748 18055 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2872 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000192.328 2114789.41 37.7868182138227 -122.443122531996 (37.7868182138227, -122.443122531996) 13 6 1 29490 27
20814 242748 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4096 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001694.23867 2105873.65626 37.7624233084181 -122.437287644716 (37.7624233084181, -122.437287644716) 15 5 5 28862 3
20869 198471 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 704 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6015348.95336 2105815.25959 37.7630297401524 -122.390056547668 (37.7630297401524, -122.390056547668) 14 3 8 28856 29
21138 198434 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015605.2539 2106298.94966 37.7643720601453 -122.389203859978 (37.7643720601453, -122.389203859978) 14 3 9 310 29
21183 254244 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 499x Benton Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006980 2095456 37.7341178478927 -122.418267455605 (37.7341178478927, -122.418267455605) 2 7 7 28859 2
21205 215567 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 254 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993893.11792 2096318.45791 37.735740600456 -122.463575134792 (37.735740600456, -122.463575134792) 9 8 4 59 40
21307 215486 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 25 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5994053.65956 2097702.19422 37.7395492454888 -122.463120453749 (37.7395492454888, -122.463120453749) 1 8 4 59 40
21448 215545 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993953.28384 2097231.84575 37.7382520031164 -122.463433382759 (37.7382520031164, -122.463433382759) 1 8 4 59 40
21528 242621 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3274 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 3ft   6008442.97152 2099602.35151 37.7455850616153 -122.413502636934 (37.7455850616153, -122.413502636934) 2 7 7 28859 2
21714 242719 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 853 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004377.23368 2103892.56966 37.7571358712273 -122.427866984578 (37.7571358712273, -122.427866984578) 2 4 5 28862 3
21755 13324 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 435X Persia Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6002777.3722738 2090962.3160144 37.7215417439498 -122.432476389775 (37.7215417439498, -122.432476389775) 9 7 6 28861 5
22011 198661 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 17 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   6013934.2668 2107404.04412 37.7673136301584 -122.39506079103 (37.7673136301584, -122.39506079103) 14 3 9 310 20
22037 242534 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2360 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008152.44131 2104693.50741 37.7595479078416 -122.414867509238 (37.7595479078416, -122.414867509238) 2 4 7 28859 19
22234 242677 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3933 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003560.02812 2102420.4138 37.753047415608 -122.430588150548 (37.753047415608, -122.430588150548) 2 4 5 28862 22
22343 242556 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2405 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008229.8333 2104396.39289 37.7587364477383 -122.414578823255 (37.7587364477383, -122.414578823255) 2 4 7 28859 19
22413 242733 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 177 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6000262.66947 2105618.74767 37.7616419072768 -122.442220599714 (37.7616419072768, -122.442220599714) 15 5 5 28862 3
22420 102669 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4097 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001692 2105829 37.7623005659716 -122.437292189744 (37.7623005659716, -122.437292189744) 15 5 5 28862 3
22426 93041 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4076 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6001828 2105877 37.7624400926035 -122.43682525386 (37.7624400926035, -122.43682525386) 15 5 5 28862 3
22837 215572 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 745 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5999421.36042 2095348.4772 37.7333942440298 -122.44439222862 (37.7333942440298, -122.44439222862) 9 7 4 59 40
22856 180559 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 192 Dublin St 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 5ft   6004156.47541 2089333.3612 37.7171470982496 -122.427593206665 (37.7171470982496, -122.427593206665) 9 7 6 28861 5
23251 119710 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
23263 137056 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012005.94187 2118434.64519 37.7974936729554 -122.402506368172 (37.7974936729554, -122.402506368172) 3 1 10 308 23
23318 112503 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 645 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5993489.26776 2113460.89025 37.7827859823771 -122.46621678157 (37.7827859823771, -122.46621678157) 11 6 2 54 11
23349 242769 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 922 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002452.60513 2102826.48579 37.7540995936313 -122.43444686085 (37.7540995936313, -122.43444686085) 2 4 5 28862 22
23356 258198 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1918 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6003441 2115348 37.7885366590719 -122.431922793308 (37.7885366590719, -122.431922793308) 13 9 1 29490 27

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