trees

427 rows where SiteOrder = 2 and qSpecies_id = 31 sorted by PlantDate

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
48485 141785 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1481 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003818.0941 2113163.9826 37.7825612665801 -122.430462212052 (37.7825612665801, -122.430462212052) 7 9 11 29490 41
49216 7525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2804 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6008301.92426 2102042.90132 37.7522783441942 -122.414162992926 (37.7522783441942, -122.414162992926) 2 4 7 28859 19
49804 198690 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 52 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6008856.64566 2109825.7938 37.7736795226325 -122.41279485791 (37.7736795226325, -122.41279485791) 8 2 9 28853 34
50971 138624 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1853 SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6001491.942 2114861.9229 37.7870913318734 -122.438631378118 (37.7870913318734, -122.438631378118) 13 6 1 29490 27
51582 242735 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 115 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6000736.15625 2105646.04373 37.7617438292481 -122.440584963137 (37.7617438292481, -122.440584963137) 15 5 5 28862 3
51709 173899 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
52070 198464 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 707 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015333.10926 2105765.07508 37.7628910655837 -122.390107841403 (37.7628910655837, -122.390107841403) 14 3 8 28856 29
52919 110675 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 34 Bonita St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 2.5x3   6006170.0244 2118492.14329 37.7973240194296 -122.422704299571 (37.7973240194296, -122.422704299571) 13 9 10 28858 32
53154 7487 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2675X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6008318.24783 2102788.20898 37.7543257074831 -122.41415926793 (37.7543257074831, -122.41415926793) 2 4 7 28859 19
53830 105078 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 299X FAIR OAKS ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005467 2101988 37.7519679548938 -122.42396271727 (37.7519679548938, -122.42396271727) 2 4 5 28859 19
54233 198676 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010397.30176 2111518.55677 37.7784138101995 -122.407584837978 (37.7784138101995, -122.407584837978) 14 2 9 28853 34
54596 242599 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 Surrey St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002203.4241 2096143.28973 37.7357349581026 -122.434830687885 (37.7357349581026, -122.434830687885) 2 7 5 63 7
54694 215525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 478 Dewey Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994741.9738 2100056.97706 37.7460545185029 -122.460911199901 (37.7460545185029, -122.460911199901) 1 8 4 29491 40
54742 200631 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1354 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6016389.5518 2094874.5522 37.7330464790647 -122.385694866729 (37.7330464790647, -122.385694866729) 10 3 8 58 1
54889 136976 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 340 Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996232.2691 2114976.93638 37.7871065186035 -122.456836895121 (37.7871065186035, -122.456836895121) 11 6 1 54 31
57360 242510 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2808 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6008305.34942 2102000.42568 37.7521619080513 -122.41414814334 (37.7521619080513, -122.41414814334) 2 4 7 28859 19
57704 111050 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1820 EDDY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001661 2112577 37.780827132241 -122.437882755751 (37.780827132241, -122.437882755751) 15 5 11 29490 41
58501 242380 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1217 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011151.17373 2102568.66425 37.7538816015592 -122.404346786677 (37.7538816015592, -122.404346786677) 10 4 8 28859 19
58794 7638 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3274 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6008420.15681 2099616.94183 37.7456238423258 -122.413582558723 (37.7456238423258, -122.413582558723) 2 7 7 28859 2

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