trees

2,365 rows where qSpecies_id = 31 sorted by Supervisor Districts

✎ 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)
10264 137022 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003025.71137 2117483.5061 37.7943766605074 -122.433512298867 (37.7943766605074, -122.433512298867) 13 9 1 29490 27
10305 98993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1919 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2012 12:00:00 AM 1 3x3 Permit Number 768862 6003810 2118645 37.7976102909597 -122.430881499482 (37.7976102909597, -122.430881499482) 13 9 1 57 17
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
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
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
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
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
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
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
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
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
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
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
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
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
26005 137018 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2716 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6001024.79883 2116912.49705 37.7926950910553 -122.440394705264 (37.7926950910553, -122.440394705264) 13 6 1 29490 27
26952 137023 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003036.9655 2117481.25366 37.7943711144001 -122.433473197238 (37.7943711144001, -122.433473197238) 13 9 1 29490 27
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
28840 137884 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1928 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003417.2048 2115384.0895 37.7886344027041 -122.432007699107 (37.7886344027041, -122.432007699107) 13 9 1 29490 27
28962 136999 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2452 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6002307.2495 2116764.38372 37.7923613472576 -122.435946778048 (37.7923613472576, -122.435946778048) 13 9 1 29490 27
30193 31614 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2146 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1995 12:00:00 AM 12   Permit Number 35135 6001571.0697 2119772.3198 37.8005785040659 -122.43870960599 (37.8005785040659, -122.43870960599) 13 9 1 57 17
30309 137034 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1756 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6005175.40466 2117844.84093 37.7954905257115 -122.426099835651 (37.7954905257115, -122.426099835651) 13 9 1 28858 27
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
32785 115468 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 83 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5993932.33914 2114999.07157 37.7870349634341 -122.464795691681 (37.7870349634341, -122.464795691681) 11 6 1 54 11
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
34280 138312 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2400 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6002409.4598 2115100.9692 37.7877998437953 -122.43547408046 (37.7877998437953, -122.43547408046) 13 6 1 29490 27
34645 18039 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2813 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6000314.1463 2114749.1203 37.7867145338964 -122.442698176369 (37.7867145338964, -122.442698176369) 13 6 1 29490 27
34693 18053 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2852 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6000250.2377 2114802.0314 37.7868561706627 -122.442923085267 (37.7868561706627, -122.442923085267) 13 6 1 29490 27
36034 18002 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2676 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001135.87676 2114918.88378 37.7872274699544 -122.439867367887 (37.7872274699544, -122.439867367887) 13 6 1 29490 27
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
36432 45653 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2001 12:00:00 AM     Permit Number 44350 6000345.05114977 2116113.5186525 37.790462578374 -122.442689257593 (37.790462578374, -122.442689257593) 13 6 1 29490 27
36744 136985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 454 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5998649.64618 2115048.5568 37.7874416806303 -122.448478497988 (37.7874416806303, -122.448478497988) 13 6 1 54 31
36978 97271 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3099 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2011 12:00:00 AM   3x3 Permit Number 768129 5999886 2116055 37.790275722262 -122.444273332996 (37.790275722262, -122.444273332996) 13 6 1 29490 27
37218 256504 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3579 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997147.04528 2116001.57364 37.7899723836566 -122.453746006699 (37.7899723836566, -122.453746006699) 11 6 1 54 31
37219 137015 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2795 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000234.59127 2117454.54255 37.7941383806269 -122.443167794482 (37.7941383806269, -122.443167794482) 13 9 1 57 27
37815 36939 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 106 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 14   Permit Number 39578 5994917.29896 2114783.54641 37.7864999276851 -122.461372345087 (37.7864999276851, -122.461372345087) 11 6 1 54 11
37973 18057 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2882 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   6000155.2064 2114785.6979 37.7868059046739 -122.443250696948 (37.7868059046739, -122.443250696948) 13 6 1 29490 27
38890 17931 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2416 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002234.6053 2115077.8001 37.7877262951282 -122.436077384684 (37.7877262951282, -122.436077384684) 13 6 1 29490 27
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
39467 136997 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2511 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6002190.47702 2116848.68458 37.7925861813489 -122.436356849106 (37.7925861813489, -122.436356849106) 13 9 1 29490 27
39987 33125 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2380 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 13 6x7 Permit Number 37358 6001538.52427 2119069.35252 37.7986464896046 -122.438771824677 (37.7986464896046, -122.438771824677) 13 9 1 57 17
41277 106350 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1853 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001488.8508 2114881.6293 37.7871452647326 -122.43864348553 (37.7871452647326, -122.43864348553) 13 6 1 29490 27
41446 62038 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2015 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2015 12:00:00 AM 3   Permit Number 773957 6000922.27992 2115385.79956 37.7884973390282 -122.440639868553 (37.7884973390282, -122.440639868553) 13 6 1 29490 27
41548 89025 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2724 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2015 12:00:00 AM 3 3x3 Permit Number 774819 6000906.5 2116912.2 37.7926875389812 -122.440804001611 (37.7926875389812, -122.440804001611) 13 6 1 29490 27
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
42142 53259 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 210 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1969 12:00:00 AM 15   Permit Number 6149 5997600.12702 2115607.00528 37.7889149689082 -122.452149910107 (37.7889149689082, -122.452149910107) 11 6 1 54 31
42775 137027 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2057 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6003211.76656 2118215.6872 37.7963975954305 -122.432920859704 (37.7963975954305, -122.432920859704) 13 9 1 57 17
43128 51255 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2485 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2006 12:00:00 AM 8   Permit Number 49056 6001759.16032 2117307.51172 37.7938214847188 -122.437882095676 (37.7938214847188, -122.437882095676) 13 9 1 29490 27
43928 62667 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 438 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2008 12:00:00 AM 4 3x3 Permit Number 50321 5998175.41267 2114969.52536 37.7871975551779 -122.45011354281 (37.7871975551779, -122.45011354281) 13 6 1 54 31
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
44441 137029 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1987 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6005188.10798 2116792.05792 37.7926005678068 -122.42598090032 (37.7926005678068, -122.42598090032) 13 9 1 28858 27
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
45688 136988 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2855 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5999300.72637 2118363.97788 37.7965821551925 -122.446464513021 (37.7965821551925, -122.446464513021) 13 9 1 57 17
47312 18034 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2806 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000470.7399 2114833.2135 37.7869543575665 -122.442162440141 (37.7869543575665, -122.442162440141) 13 6 1 29490 27
48921 36885 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2914 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 9   Permit Number 39542 6000200.34388 2116470.40485 37.79143424424 -122.443215577236 (37.79143424424, -122.443215577236) 13 6 1 29490 27
50052 18015 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2712 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000819.3499 2114877.5272 37.7870958927498 -122.440959512089 (37.7870958927498, -122.440959512089) 13 6 1 29490 27
50095 137001 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2990 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6000456.70725 2115850.47267 37.7897466871152 -122.442284044196 (37.7897466871152, -122.442284044196) 13 6 1 29490 27
50160 35613 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2839 Pacific Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2011 12:00:00 AM 6 3x3 Permit Number 768494 6000560.21131744 2116797.97814823 37.7923541883271 -122.44199396864 (37.7923541883271, -122.44199396864) 13 6 1 29490 27
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
51115 41185 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3440 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM 2   Permit Number 41903 6001280.22409 2120345.11349 37.8021346936235 -122.439757137177 (37.8021346936235, -122.439757137177) 13 9 1 57 17
51352 87967 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 901 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51002 6000425.8 2112036.7 37.7792732897886 -122.442117107328 (37.7792732897886, -122.442117107328) 15 5 1 29490 16
53468 137005 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2110 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6000416.46537 2115868.24641 37.7897931955501 -122.442424553347 (37.7897931955501, -122.442424553347) 13 6 1 29490 27
54430 33935 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1932 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1997 12:00:00 AM     Permit Number 43529 6003424.24641356 2115332.27843331 37.7884925418667 -122.431979635032 (37.7884925418667, -122.431979635032) 13 9 1 29490 27
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
58374 18022 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2726 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/1994 12:00:00 AM 18 3X3   6000886.2670207 2114885.2948521 37.7871210317525 -122.44072855159 (37.7871210317525, -122.44072855159) 13 6 1 29490 27
58674 136969 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2640 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6000252.03874 2118890.89742 37.7980832262203 -122.443210635483 (37.7980832262203, -122.443210635483) 13 9 1 57 17
58992 136977 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 304 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5998585.82745 2115521.28488 37.7887360181866 -122.448733358666 (37.7887360181866, -122.448733358666) 13 6 1 54 31
59353 45650 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2001 12:00:00 AM     Permit Number 44350 6000345.05114977 2116113.5186525 37.790462578374 -122.442689257593 (37.790462578374, -122.442689257593) 13 6 1 29490 27
59679 137031 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1752 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005234.06309 2117850.62901 37.7955097334486 -122.425897279546 (37.7955097334486, -122.425897279546) 13 9 1 28858 27
59964 93910 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2690 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16 3x3   6001101.2138 2114914.769 37.7872141986511 -122.439986998855 (37.7872141986511, -122.439986998855) 13 6 1 29490 27
60750 18003 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2676 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001111.97407 2114914.60088 37.7872143495752 -122.439949758664 (37.7872143495752, -122.439949758664) 13 6 1 29490 27
61874 17917 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2370 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002602.4145 2115123.2744 37.7878720449725 -122.43480808996 (37.7878720449725, -122.43480808996) 13 9 1 29490 27
61962 32023 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2700 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1995 12:00:00 AM 18   Permit Number 35413 6001158.18036 2116931.31755 37.7927543608653 -122.439934550957 (37.7927543608653, -122.439934550957) 13 6 1 29490 27
62297 138612 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2802 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6000495.2401 2114841.3803 37.7869781777261 -122.442078261692 (37.7869781777261, -122.442078261692) 13 6 1 29490 27
62898 117051 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1827 SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 4x4 Permit Number 778308 6001498 2114739 37.7867541617971 -122.438601607836 (37.7867541617971, -122.438601607836) 13 6 1 29490 27
63420 18052 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2840 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484) 13 6 1 29490 27
65142 136958 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 8 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000568.04629 2118355.71273 37.7966317645105 -122.442078724458 (37.7966317645105, -122.442078724458) 13 9 1 57 17
65870 138627 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2691 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6001082.2561 2114862.4803 37.7870695481569 -122.44004883746 (37.7870695481569, -122.44004883746) 13 6 1 29490 27
66508 66277 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2750 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2007 12:00:00 AM 6   Permit No. 49271 5999752.72813 2118820.10006 37.7978603517187 -122.444933297631 (37.7978603517187, -122.444933297631) 13 9 1 57 17
66630 72449 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3687 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1996 12:00:00 AM 11     5997241.71464 2115032.69529 37.7873175292136 -122.453348481559 (37.7873175292136, -122.453348481559) 11 6 1 54 31
66717 136968 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 77 Pixley St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003015.29864 2119068.11708 37.7987270014142 -122.433661633074 (37.7987270014142, -122.433661633074) 13 9 1 57 17
67660 123533 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3 05th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   5994221.75726 2115563.21138 37.7886006193808 -122.463835340542 (37.7886006193808, -122.463835340542) 11 6 1 54 11
68142 43942 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3885 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2000 12:00:00 AM 11   Permit Number 43530 5995636.78457 2115791.89347 37.7893099594942 -122.458956155447 (37.7893099594942, -122.458956155447) 11 6 1 54 31
68441 45690 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1932 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2001 12:00:00 AM 7   Permit Number 44375 5999944.86656 2121277.56514 37.8046188567315 -122.44444515194 (37.8046188567315, -122.44444515194) 13 9 1 57 17
69027 45652 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2001 12:00:00 AM     Permit Number 44350 6000345.05114977 2116113.5186525 37.790462578374 -122.442689257593 (37.790462578374, -122.442689257593) 13 6 1 29490 27
69043 74234 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3695 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1996 12:00:00 AM 13     5997222.04614 2115031.53176 37.7873132070818 -122.45341644603 (37.7873132070818, -122.45341644603) 11 6 1 54 31
69088 136964 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2590 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6000622.04414 2118252.24291 37.7963507407448 -122.441884450223 (37.7963507407448, -122.441884450223) 13 9 1 57 17
71954 68197 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 417 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 7   Permit Number 31977 5998129.56207 2114980.61061 37.7872253685036 -122.450272974611 (37.7872253685036, -122.450272974611) 11 6 1 54 31
73890 55949 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2814 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/1989 12:00:00 AM 3   Permit Number 28156 5999490.08281 2118090.45953 37.7958419601055 -122.445789619521 (37.7958419601055, -122.445789619521) 13 9 1 57 17
73984 142896 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2009 DIVISADERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000927.3924 2115350.0275 37.7883994093472 -122.44061961339 (37.7883994093472, -122.44061961339) 13 6 1 29490 27
74737 137014 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2795 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000218.16422 2117453.42518 37.7941343759438 -122.443224553374 (37.7941343759438, -122.443224553374) 13 9 1 57 27
74868 136996 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2241 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003218.2854 2116412.88242 37.7914479265348 -122.432769452565 (37.7914479265348, -122.432769452565) 13 9 1 29490 27
74991 137002 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2990 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000440.09482 2115849.1235 37.7897420358261 -122.442341424527 (37.7897420358261, -122.442341424527) 13 6 1 29490 27
75342 98463 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1999X Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6005166 2116743 37.7924646176623 -122.426053900855 (37.7924646176623, -122.426053900855) 13 9 1 28858 27
75960 45651 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3001 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2001 12:00:00 AM     Permit Number 44350 6000345.05114977 2116113.5186525 37.790462578374 -122.442689257593 (37.790462578374, -122.442689257593) 13 6 1 29490 27
77286 51159 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1801 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2004 12:00:00 AM 4   Permit Number 47564 6000498.9523 2114920.078 37.7871944727635 -122.44207106941 (37.7871944727635, -122.44207106941) 13 6 1 29490 27
77700 136975 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 340 Cherry St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996232.67992 2114967.11027 37.7870795623305 -122.456834762835 (37.7870795623305, -122.456834762835) 11 6 1 54 31
78776 2242 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2799X PINE ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6000783 2114845 37.7870045110932 -122.441082939895 (37.7870045110932, -122.441082939895) 13 6 1 29490 27
80399 136965 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2762 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5999775.07561 2118126.74108 37.7959578476198 -122.44480610383 (37.7959578476198, -122.44480610383) 13 9 1 57 17

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