trees

2,365 rows where qSpecies_id = 31

✎ View and edit SQL

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)
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
18245 66733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1133 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/06/1991 12:00:00 AM     Permit Number 29980 6008997 2116859 37.7929988993441 -122.41280668477 (37.7929988993441, -122.41280668477) 5 1 10 28857 21
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
18373 259350 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Goettingen St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
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
18433 260397 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/20/2018 12:00:00 AM 3                        
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
18804 85789 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1157 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 8 3x3   6009966.4934 2110538.8397 37.7756996123582 -122.409006027185 (37.7756996123582, -122.409006027185) 8 2 9 28853 34
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
19169 34703 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 591 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2008 12:00:00 AM 4 3x3 Permit Number 50359 5981606.78939 2111740.24587 37.777368864087 -122.507196740825 (37.777368864087, -122.507196740825) 11 6 2 55 26
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
20097 57068 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 918 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 15 6x7 Permit Number 14334 6015212.77238 2104346.74514 37.7589899621477 -122.390424942382 (37.7589899621477, -122.390424942382) 10 3 8 28856 29
20199 46505 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 165 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44676 6009030.30482136 2110979.07994252 37.7768559207247 -122.412275670972 (37.7768559207247, -122.412275670972) 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
20821 85762 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1246 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6009446.0112 2110126.3604 37.7745378709641 -122.410777374473 (37.7745378709641, -122.410777374473) 8 2 9 28853 34
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
21744 44267 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 315 Montcalm St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/22/2001 12:00:00 AM     Permit Number 43696 6009681.81388664 2099574.48898013 37.7455780401568 -122.409216925278 (37.7455780401568, -122.409216925278) 2 7 7 28859 2
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
22198 14869 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1399 McAllister St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2011 12:00:00 AM 3 3x3   6002569.68984 2111577.93891 37.7781355917554 -122.434667698155 (37.7781355917554, -122.434667698155) 15 5 11 29492 41
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
22843 55859 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 206 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2011 12:00:00 AM   3x3 Permit Number 56866 6005405.07087572 2102495.68659096 37.7533584481258 -122.424212980631 (37.7533584481258, -122.424212980631) 2 4 5 28859 19
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
22908 32995 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 4   Permit Number 37299 6013130.33001 2113657.26593 37.7844388182424 -122.398280299215 (37.7844388182424, -122.398280299215) 6 2 9 28853 6
22910 75248 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199X RUSS ST 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 2 5x5   6010421 2111456 37.7782433704481 -122.407498444933 (37.7782433704481, -122.407498444933) 14 2 9 28853 34
23232 32533 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 70 Porter St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM     Permit Number 37034 6006985.4956632 2095516.38069521 37.7342839493681 -122.418252734879 (37.7342839493681, -122.418252734879) 2 7 7 28859 2
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
23291 41906 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 60 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42269 6003134.36765804 2107953.23072837 37.7682150777502 -122.432455314129 (37.7682150777502, -122.432455314129) 15 5 5 28862 3
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
23450 91035 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010666.0508 2111208.1223 37.7775764693736 -122.406633247496 (37.7775764693736, -122.406633247496) 14 2 9 28853 34
23472 242575 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2019 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6008104.80442 2106706.37062 37.7650720888176 -122.415174745544 (37.7650720888176, -122.415174745544) 8 4 7 28859 19
23559 17486 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 220X Persia Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6002262.8923189 2091226.588151 37.7222381881928 -122.434273689054 (37.7222381881928, -122.434273689054) 9 7 6 28861 5
23560 198505 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 743 Rhode Island St 1 : Tree Private 2     11 Width 3ft   6011863.14571 2104907.21276 37.7603425002176 -122.402048998175 (37.7603425002176, -122.402048998175) 10 3 8 28856 29
23618 112386 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2200 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999398 2116386 37.7911567075357 -122.445985588475 (37.7911567075357, -122.445985588475) 13 6 1 29490 27
23639 7466 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2601 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3X3   6008295.31777 2103224.31145 37.7555218579731 -122.41426941961 (37.7555218579731, -122.41426941961) 2 4 7 28859 19
23716 242547 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2470 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008189.29085 2104062.22691 37.7578166265547 -122.414695389796 (37.7578166265547, -122.414695389796) 2 4 7 28859 19
23746 7561 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2921 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 4X4   6008393.48132 2101389.94596 37.7504906178693 -122.413800190239 (37.7504906178693, -122.413800190239) 2 4 7 28859 19
23867 215521 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1750 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5993133.83624 2103556.81567 37.755571512239 -122.466726245046 (37.755571512239, -122.466726245046) 1 8 4 56 12
23894 200745 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5101 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6014683.7532 2094550.1103 37.7320610911002 -122.391569635286 (37.7320610911002, -122.391569635286) 10 3 8 58 1
23988 198459 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 700 Mariposa St 7 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6014889.29769 2106275.30651 37.7642674249283 -122.391678519967 (37.7642674249283, -122.391678519967) 14 3 9 310 29
24002 198501 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900x Carolina St 13 Median : Yard Tree DPW 1     15     6012463.03254 2103576.30053 37.7567215715659 -122.399880796574 (37.7567215715659, -122.399880796574) 10 3 8 28856 29
24025 242641 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 262 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007759.04259 2106432.24164 37.764299956994 -122.416351235928 (37.764299956994, -122.416351235928) 8 4 7 28859 19
24118 97269 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2050X Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769192 5999973.8 2116027.1 37.79020412496 -122.443967546887 (37.79020412496, -122.443967546887) 13 6 1 29490 27
24238 215561 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 240 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5994051.56415 2096391.91316 37.7359514186289 -122.463032656549 (37.7359514186289, -122.463032656549) 9 8 4 59 40
24270 242668 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3956 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003431.93143 2102453.4748 37.7531309356663 -122.431033493027 (37.7531309356663, -122.431033493027) 2 4 5 28862 22
24576 248409 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 120 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998272.8596 2108056.6857 37.7682222644528 -122.449278164682 (37.7682222644528, -122.449278164682) 15 5 11 29492 9
24615 242404 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2868 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6010188.91419 2101663.03935 37.7513411372819 -122.407610671899 (37.7513411372819, -122.407610671899) 2 4 7 28859 19
24697 91031 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010606.148 2111149.8835 37.7774132075868 -122.406836366848 (37.7774132075868, -122.406836366848) 14 2 9 28853 34
24709 123166 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 579 10th Ave 1 Sidewalk: Property side : Yard Tree Private 2     6     5992807.48236 2111535.86844 37.7774610360275 -122.468435352622 (37.7774610360275, -122.468435352622) 11 6 2 54 11
24722 244306 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Octavia St 8 Median : Cutout Tree DPW 1     2 Width 0ft   6005576.9618 2110512.9441 37.7753816404734 -122.42418868303 (37.7753816404734, -122.42418868303) 7 9 11 28852 10
24738 16679 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 248 Noe St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002873.9908755 2106855.8321643 37.7651871206567 -122.433277506161 (37.7651871206567, -122.433277506161) 15 5 5 28862 3
24769 198491 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 907 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6015266.77203 2104421.22514 37.7591974636091 -122.390243388116 (37.7591974636091, -122.390243388116) 10 3 8 28856 29
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
25001 242526 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1922 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 7 Width 2ft   6008013.77103 2107241.1183 37.7665352651235 -122.415527471335 (37.7665352651235, -122.415527471335) 8 4 7 28853 19
25061 104771 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 928 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002435.2 2102798.9 37.7540228616298 -122.434505079683 (37.7540228616298, -122.434505079683) 2 4 5 28862 22
25169 17576 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 752X Persia Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     15 3x3   6003542.00606 2090427.72603 37.7201172080443 -122.429795147634 (37.7201172080443, -122.429795147634) 9 7 6 28861 5
25246 242379 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1217 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011152.0776 2102554.59258 37.7538430143636 -122.40434267049 (37.7538430143636, -122.40434267049) 10 4 8 28859 19
25292 89024 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2724 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2008 12:00:00 AM 4 4x4 Permit Number 51769 6000900.18903 2116892.91159 37.7926342186313 -122.440824453501 (37.7926342186313, -122.440824453501) 13 6 1 29490 27
25389 215519 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1800 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993153.53472 2103109.22386 37.7543436777209 -122.466625589315 (37.7543436777209, -122.466625589315) 1 8 4 56 12
25402 242705 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 622 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002352.40846 2104549.28931 37.7588243106064 -122.434916564156 (37.7588243106064, -122.434916564156) 2 4 5 28862 3
25513 17523 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 309 Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002491.854148 2091141.7505443 37.7220182361725 -122.433476163825 (37.7220182361725, -122.433476163825) 9 7 6 28861 5
25561 101710 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 990 Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 3x3   6011874 2103773 37.7572288087602 -122.401931725179 (37.7572288087602, -122.401931725179) 10 3 8 28856 29
25624 138666 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2721 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000819.0242 2114826.1264 37.7869547408882 -122.440956950105 (37.7869547408882, -122.440956950105) 13 6 1 29490 27
25646 7497 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2700 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6008270.16145 2102659.31707 37.753969098407 -122.414316444274 (37.753969098407, -122.414316444274) 2 4 7 28859 19
25685 242513 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2948 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008340.21249 2101308.02712 37.7502626954836 -122.413978604037 (37.7502626954836, -122.413978604037) 2 4 7 28859 19
25694 242395 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1772 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6005651.81735 2107273.82605 37.7664920266105 -122.423699384137 (37.7664920266105, -122.423699384137) 8 4 5 28853 19
25715 242409 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 214 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005416.645 2102345.79668 37.7529475387091 -122.424162295755 (37.7529475387091, -122.424162295755) 2 4 5 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)
);