trees

2,365 rows where qSpecies_id = 31 sorted by qCaretaker_id descending

✎ 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)
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
12615 87685 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 118 Virginia Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733) 2 7 7 28859 2
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
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
14091 65135 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 29 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1989 12:00:00 AM 24 6x25 Permit Number 27110 5990777 2114840 37.7864157730855 -122.475700726719 (37.7864157730855, -122.475700726719) 11 6 1 54 33
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
14244 46291 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   4 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
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
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
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
14903 91162 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 525 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 4 3x3 Permit Number 52035 6007112.34702 2112584.78934 37.7811570014217 -122.419024399678 (37.7811570014217, -122.419024399678) 7 9 9 28852 36
15181 137040 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2020 12:00:00 AM 3 Width 3ft   6009716.37448 2116806.11676 37.7928940462749 -122.410313864011 (37.7928940462749, -122.410313864011) 3 1 10 28857 21
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
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
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
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
15809 54753 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4140-4142 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1972 12:00:00 AM     Permit Number 10601 6002268.53854801 2101815.27696084 37.7513126050411 -122.435011090977 (37.7513126050411, -122.435011090977) 2 4 5 28862 22
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
16163 32994 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013107.84928 2113632.60044 37.7843698402516 -122.398356344087 (37.7843698402516, -122.398356344087) 6 2 9 28853 6
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
17144 48943 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1344 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/2005 12:00:00 AM     Permit Number 46130 6010846.48741491 2102064.8294817 37.7524811515419 -122.40536498901 (37.7524811515419, -122.40536498901) 10 4 8 28859 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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