trees

427 rows where SiteOrder = 2 and qSpecies_id = 31

✎ View and edit SQL

This data as json, CSV (advanced)

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)
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
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)          
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)          
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
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
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
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
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
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
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
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
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
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
9121 46285 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
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
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
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
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
12480 47528 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 277 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/2003 12:00:00 AM     Permit Number 45400 6004720.64686455 2100142.45310534 37.7468583456276 -122.426412322279 (37.7468583456276, -122.426412322279) 2 7 5 63 22
12506 105953 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 54 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2014 12:00:00 AM 4   Permit Number 771133 5994277.8794 2115232.96253 37.7876970801078 -122.463617190077 (37.7876970801078, -122.463617190077) 11 6 1 54 11
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
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
15550 32997 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013196.81609 2113721.08426 37.784617751847 -122.398054757315 (37.784617751847, -122.398054757315) 6 2 9 28853 6
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
25726 215523 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 80 Northwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995460.48677 2094242.81923 37.7301315873058 -122.458006001202 (37.7301315873058, -122.458006001202) 9 7 4 28861 40
26333 85767 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1400X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6008747.4583 2109466.0696 37.7726856753072 -122.41314711365 (37.7726856753072, -122.41314711365) 8 2 9 28853 34
27123 242567 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2121 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008134.5513 2106113.05528 37.7634446540583 -122.415029859359 (37.7634446540583, -122.415029859359) 8 4 7 28859 19
27440 33762 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1800X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1996 12:00:00 AM 5 3x3 Permit Number 37814 6003491.84820405 2114902.28438826 37.7873157193536 -122.431715030855 (37.7873157193536, -122.431715030855) 13 9 11 29490 27
28247 91339 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 829 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2009 12:00:00 AM 1 3x3 Permit Number 52060 6012087.196 2112565.923 37.7813840839391 -122.401812466037 (37.7813840839391, -122.401812466037) 6 2 9 28856 34
28789 31076 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 8   Permit Number 34816 6006020.69113 2107294.38947 37.7665693044606 -122.422424975532 (37.7665693044606, -122.422424975532) 8 4 5 28853 19
28829 123586 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 62 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994279.04973 2115190.28174 37.787579957729 -122.463610042193 (37.787579957729, -122.463610042193) 11 6 1 54 11
30218 97985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     16     6015230.10587 2104016.74085 37.7580848025885 -122.390341937645 (37.7580848025885, -122.390341937645) 10 3 8 28856 29
31673 119709 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
32368 242591 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4412 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6000545.74742 2102300.80991 37.7525477891746 -122.441003511213 (37.7525477891746, -122.441003511213) 2 4 5 28862 22
32495 105218 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2100 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2014 12:00:00 AM 2 3x3 Permit Number 772439 5999896.69925 2116138.83336 37.790506517102 -122.444242341317 (37.790506517102, -122.444242341317) 13 6 1 29490 27
32829 242711 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3836 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002806.04485 2103594.72393 37.7562290488364 -122.433279472464 (37.7562290488364, -122.433279472464) 2 4 5 28862 3
33627 39478 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2856 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 777203 5999897.32915775 2117456.37972289 37.7941241886563 -122.44433488583 (37.7941241886563, -122.44433488583) 13 9 1 57 27
34818 245849 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 251 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6005124.4628 2109778.1319 37.7733384648593 -122.425701672194 (37.7733384648593, -122.425701672194) 7 9 11 28852 10
35158 100568 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 868 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6011788.1802 2112369.4793 37.780828003664 -122.40283310111 (37.780828003664, -122.40283310111) 6 2 9 28853 34
36411 138628 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2693 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6001099.9461 2114865.3107 37.7870783267507 -122.439987837155 (37.7870783267507, -122.439987837155) 13 6 1 29490 27
36858 22315 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 5115X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3X3   6014716.40109 2094586.27231 37.7321621967642 -122.391459290654 (37.7321621967642, -122.391459290654) 10 3 8 58 1
37889 242424 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 209 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6005453.21466 2102408.07888 37.7531206159404 -122.424040259559 (37.7531206159404, -122.424040259559) 2 4 5 28859 19
38205 7428 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2507 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008259.11324 2103798.38895 37.757096110403 -122.414435245589 (37.757096110403, -122.414435245589) 2 4 7 28859 19
38426 115550 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.390181786362 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
38942 137004 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2009 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2018 12:00:00 AM 3 Width 5ft Permit Number 54784 6000928.49211 2115336.76015 37.7883630432624 -122.440614856585 (37.7883630432624, -122.440614856585) 13 6 1 29490 27
39077 103271 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 350 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004879 2109882 37.7736097878739 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
39873 215541 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993946.31928 2097307.15629 37.7384583858397 -122.463462926386 (37.7384583858397, -122.463462926386) 1 8 4 59 40
40087 215483 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 15 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5994103.6572 2097790.09327 37.7397934743851 -122.462953960472 (37.7397934743851, -122.462953960472) 1 8 4 59 40
40491 242416 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3652 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005376.79468 2101978.6432 37.7519371701822 -122.424273995163 (37.7519371701822, -122.424273995163) 2 4 5 28859 19
40722 94046 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 42 Rivoli St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 53454 5998445 2106022 37.7626453762737 -122.44853619655 (37.7626453762737, -122.44853619655) 15 5 11 29492 9
41592 33124 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2380 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 12 6x6 Permit Number 37358 6001499.40758 2119065.90574 37.7986348002003 -122.438906933417 (37.7986348002003, -122.438906933417) 13 9 1 57 17
41660 198529 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1722 Newcomb Ave 2 : Tree Private 2     7 Width 7ft   6014569.28946 2096208.90311 37.73660944358 -122.392081326305 (37.73660944358, -122.392081326305) 10 3 8 58 1
42118 180519 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 919 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6003897.75198 2090254.30542 37.7196611719008 -122.428553098957 (37.7196611719008, -122.428553098957) 9 7 6 28861 5
42812 215548 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 200 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5994023.18881 2096729.95205 37.7368779550533 -122.463155280903 (37.7368779550533, -122.463155280903) 9 8 4 59 40
43197 215476 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993096.43343 2105917.73669 37.7620518272484 -122.467027231034 (37.7620518272484, -122.467027231034) 1 8 4 56 12
43335 215497 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 73 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993976.24019 2097340.186 37.738550801067 -122.46336187137 (37.738550801067, -122.46336187137) 1 8 4 59 40
43816 103418 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 700X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015432.6 2105817 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
44191 123695 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995508.22475 2113538.45627 37.7831152369297 -122.459237706338 (37.7831152369297, -122.459237706338) 11 6 2 54 11
44300 137020 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6002995.15639 2117477.21245 37.7943576461387 -122.433617572612 (37.7943576461387, -122.433617572612) 13 9 1 29490 27
44335 242772 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 930 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002452.78798 2102762.57285 37.7539241143239 -122.434441659158 (37.7539241143239, -122.434441659158) 2 4 5 28862 22
44710 215501 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 225 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994092.6368 2096583.02497 37.7364785301452 -122.462904513945 (37.7364785301452, -122.462904513945) 9 8 4 59 40
45197 215559 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 240 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994067.05947 2096413.85404 37.7360125554181 -122.462980674831 (37.7360125554181, -122.462980674831) 9 8 4 59 40
45215 98464 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1999X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005154.5 2116787.4 37.7925858789052 -122.426096853469 (37.7925858789052, -122.426096853469) 13 9 1 28858 27
45264 198574 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 425 01st St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6014815.04425 2114132.68239 37.7858379025473 -122.392484987011 (37.7858379025473, -122.392484987011) 6 2 9 28855 6
45851 180552 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001906.70426 2091457.08941 37.7228508693472 -122.435521425698 (37.7228508693472, -122.435521425698) 9 7 6 28861 5
47613 2633 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1884 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6004452.48891 2115034.49338 37.7877331379393 -122.428400842266 (37.7877331379393, -122.428400842266) 13 9 11 28858 27
47670 1208 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3141 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     25 3x3   5995992.87885 2086942.40616 37.7101169521706 -122.455637985173 (37.7101169521706, -122.455637985173) 9 7 6 28861 25

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