trees

2,365 rows where qSpecies_id = 31 sorted by rowid 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)
187286 242504 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2618 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008251.23076 2102923.39648 37.7546931372024 -122.414400595628 (37.7546931372024, -122.414400595628) 2 4 7 28859 19
187153 137646 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1399 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6002523.8866 2111593.3391 37.7781752764428 -122.434827249536 (37.7781752764428, -122.434827249536) 15 5 11 29492 41
187152 115485 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1924 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6012271.36264 2104713.50287 37.7598333913054 -122.400623549336 (37.7598333913054, -122.400623549336) 10 3 8 28856 29
187128 23644 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 197 Virginia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2005 12:00:00 AM 8 3X3   6006643.75963 2098486.48829 37.7424199625796 -122.41964489142 (37.7424199625796, -122.41964489142) 2 7 7 28859 2
187127 85768 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1400X Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2007 12:00:00 AM 3 3x3   6008662.6876 2109384.932 37.7724581311851 -122.41343460644 (37.7724581311851, -122.41343460644) 8 2 9 28853 34
187100 137013 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2920 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   5999627.95657 2117064.96637 37.7930340986073 -122.445238785654 (37.7930340986073, -122.445238785654) 13 9 1 57 27
187008 119825 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 9 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
186905 242411 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 276 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6005434.9057 2102102.80352 37.7522813668053 -122.42408186761 (37.7522813668053, -122.42408186761) 2 4 5 28859 19
186652 28264 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1100X McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003899.2367 2111834.49982 37.7789154337837 -122.430086622126 (37.7789154337837, -122.430086622126) 7 9 11 29490 41
186650 17941 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2445 Pine St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/23/2016 12:00:00 AM 18 3x3   6002249.5312774 2115023.8576257 37.7875790308508 -122.436021882306 (37.7875790308508, -122.436021882306) 13 6 11 29490 27
186628 18001 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2673 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001165.7528 2114873.8019 37.7871053873216 -122.439760770078 (37.7871053873216, -122.439760770078) 13 6 1 29490 27
186619 606 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2785X Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3x3   6008351.06015 2102163.79121 37.7526130403718 -122.414001623984 (37.7526130403718, -122.414001623984) 2 4 7 28859 19
186583 198438 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015515.17331 2106293.18394 37.764351234542 -122.389515023625 (37.764351234542, -122.389515023625) 14 3 9 310 29
186554 198608 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 456 Mission Bay Blvd South 8 Sidewalk: Curb side : Yard Tree Private 2     5     6016209.64695 2108646.95211 37.7708526530593 -122.387277210877 (37.7708526530593, -122.387277210877) 14 3 9 310 20
186422 35676 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1998 12:00:00 AM 8 4x4 Permit Number 38982 6011704.38678633 2118401.70170081 37.7973863786405 -122.403547515196 (37.7973863786405, -122.403547515196) 3 1 10 308 23
186371 67600 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 555 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1992 12:00:00 AM 10   Permit Number 31170 6013571.5238 2104494.52261 37.7593045458768 -122.396111549926 (37.7593045458768, -122.396111549926) 10 3 8 28856 29
186340 30358 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 657 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 14   Permit Number 14187 6013035.79545 2104016.54587 37.7579623041386 -122.397930841554 (37.7579623041386, -122.397930841554) 10 3 8 28856 29
186333 103276 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2800X Pine St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000456.3 2114876.5 37.7870723881298 -122.442215507279 (37.7870723881298, -122.442215507279) 13 6 1 29490 27
185910 198653 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6014062.16151 2107274.88823 37.7669661078202 -122.394609372737 (37.7669661078202, -122.394609372737) 14 3 9 310 20
185745 7506 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2728 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6008274.4224 2102517.76202 37.7535806596234 -122.41429169402 (37.7535806596234, -122.41429169402) 2 4 7 28859 19
185644 141076 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 189 COMMONWEALTH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996534.5761 2113062.8589 37.7818683255127 -122.455652579934 (37.7818683255127, -122.455652579934) 11 6 1 54 31
185571 215478 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1283 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5992361.60735 2106714.7447 37.7641977589329 -122.4696267106 (37.7641977589329, -122.4696267106) 11 8 11 56 12
185470 198582 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013779.59756 2107146.17602 37.7665969792947 -122.395577705173 (37.7665969792947, -122.395577705173) 14 3 8 28856 20
185430 113083 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 501x BURROWS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009864 2093047 37.7276651627155 -122.408126678641 (37.7276651627155, -122.408126678641) 10 3 7 309 28
185387 242454 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 466 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5998567.8134 2106456.95878 37.7638466852012 -122.448142751394 (37.7638466852012, -122.448142751394) 15 5 11 29492 9
185255 242699 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4421 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001625.17244 2104067.18144 37.7574592413801 -122.437397156048 (37.7574592413801, -122.437397156048) 2 4 5 28862 3
185237 242412 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 280 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005433.56456 2102074.06805 37.7522023901346 -122.424084462141 (37.7522023901346, -122.424084462141) 2 4 5 28859 19
185186 46875 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1031 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM 10 3x4 Permit Number 44938 6009178.55411 2118013.02984 37.7961777714378 -122.412260097639 (37.7961777714378, -122.412260097639) 3 1 10 308 21
185141 242525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1916 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 7 Width 2ft   6008012.49588 2107266.03409 37.7666036064 -122.415533646066 (37.7666036064, -122.415533646066) 8 4 7 28853 19
185130 30619 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1645 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM 4   Permit Number 34580 6008146.3215 2108637.1249 37.7703758225592 -122.415167828975 (37.7703758225592, -122.415167828975) 8 2 9 28853 19
185117 18525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3104X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     60 6x8   6008391.22062 2100547.0534 37.7481760966626 -122.413748394121 (37.7481760966626, -122.413748394121) 2 4 7 28859 2
185104 136960 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000577.85533 2118280.57754 37.7964260220962 -122.442039387228 (37.7964260220962, -122.442039387228) 13 9 1 57 17
185031 7522 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2801 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3X3   6008356.19666 2102043.47464 37.7522829666863 -122.413975350304 (37.7522829666863, -122.413975350304) 2 4 7 28859 19
184983 52726 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 169 ROOSEVELT Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2006 12:00:00 AM     Permit Number 48781 6001418.20285712 2107376.9010813 37.7665351533118 -122.438350049909 (37.7665351533118, -122.438350049909) 15 5 5 28862 3
184969 103753 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1615 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2007 12:00:00 AM 3 3x3   6008187.9193 2108722.8263 37.7706134761345 -122.415030008645 (37.7706134761345, -122.415030008645) 8 2 9 28853 19
184946 141761 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 10 HOLLIS ST 8 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6003925.4266 2113468.4989 37.7834034717338 -122.430112618538 (37.7834034717338, -122.430112618538) 7 9 11 29490 41
184925 46912 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44969 5993172.81345795 2105910.62938376 37.7620367208125 -122.466762547601 (37.7620367208125, -122.466762547601) 1 8 4 56 12
184440 242655 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 502 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001805.86123 2102847.44693 37.7541204147416 -122.436684955058 (37.7541204147416, -122.436684955058) 2 4 5 28862 22
184345 198593 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1000 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6013352.21579 2107122.2943 37.7665076235661 -122.397054279536 (37.7665076235661, -122.397054279536) 14 3 8 28856 20
184326 136987 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1508 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005725.54512 2118613.25141 37.7976314643833 -122.424250931151 (37.7976314643833, -122.424250931151) 13 9 1 57 17
184193 136961 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000580.09999 2118271.36688 37.7964008599691 -122.442030958785 (37.7964008599691, -122.442030958785) 13 9 1 57 17
184052 123587 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 62 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5994280.07322 2115179.97331 37.7875517125633 -122.463605752716 (37.7875517125633, -122.463605752716) 11 6 1 54 11
184046 46506 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 165 08th St 4 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
184015 242401 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1201 San Jose Ave 35 Front Yard : Yard Tree Private 2     3     6004422.12829 2096026.22682 37.7355392485419 -122.427151426394 (37.7355392485419, -122.427151426394) 2 7 5 28861 2
183902 253394 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
183708 7544 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2872 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   6008318.08385 2101730.76273 37.751422189596 -122.414085029817 (37.751422189596, -122.414085029817) 2 4 7 28859 19
183649 242682 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 415 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002985.90603 2105797.23135 37.7622868075003 -122.432814788295 (37.7622868075003, -122.432814788295) 15 4 5 28862 3
183611 246552 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20x Octavia St 6 Median : Yard Tree DPW 1     5 Width 8ft   6005729.77249 2109512.91923 37.77264444073 -122.423588959979 (37.77264444073, -122.423588959979) 7 9 11 28852 10
182982 198440 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015476.91332 2106290.58138 37.7643419670439 -122.389647173584 (37.7643419670439, -122.389647173584) 14 3 9 310 29
182968 198502 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900x Carolina St 14 Median : Yard Tree DPW 1     9     6012462.6007 2103568.62023 37.7567004590693 -122.399881750743 (37.7567004590693, -122.399881750743) 10 3 8 28856 29
182964 198675 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6010435.10015 2111478.17829 37.7783050560667 -122.407451231095 (37.7783050560667, -122.407451231095) 14 2 9 28853 34
182893 198513 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2216 23rd St 1 : Tree Private 2     14 Width 3ft   6011806.19785 2102818.97218 37.754605473978 -122.402099143454 (37.754605473978, -122.402099143454) 10 3 8 28856 29
182891 242438 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 155 Day St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004951.72488 2098699.71043 37.7429099643322 -122.425510615143 (37.7429099643322, -122.425510615143) 2 7 5 63 22
182817 137891 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1735 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6005146.5819 2115135.5945 37.7880499882125 -122.426006611145 (37.7880499882125, -122.426006611145) 13 9 11 28858 27
182809 180551 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6001942.54043 2091434.19539 37.7227900428055 -122.435395910889 (37.7227900428055, -122.435395910889) 9 7 6 28861 5
182723 244355 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Octavia St 3 Median : Cutout Tree DPW 1     8 Width 0ft   6005591.5984 2110402.9339 37.7750804055544 -122.424130226226 (37.7750804055544, -122.424130226226) 7 9 11 28852 10
182709 123995 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 57 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5993926.48607 2115175.33347 37.7875185929993 -122.464828746995 (37.7875185929993, -122.464828746995) 11 6 1 54 11
182645 198572 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 400 01st St 10 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6014810.33886 2114095.2184 37.7857347736954 -122.392498644996 (37.7857347736954, -122.392498644996) 6 2 9 28855 6
182519 85784 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1257 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/09/2015 11:19:00 AM 3 3x3   6009427.6278 2110025.2513 37.7742592182749 -122.410833824093 (37.7742592182749, -122.410833824093) 8 2 9 28853 34
182514 198695 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2 Baldwin Ct 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6017823.53796 2093627.90873 37.7297026844336 -122.3806505222 (37.7297026844336, -122.3806505222) 10 3 8 58 1
182476 242663 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 369 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002749.5058 2101497.98954 37.7504687067818 -122.433325183215 (37.7504687067818, -122.433325183215) 2 4 5 28862 22
182472 198463 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 707 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6015318.33391 2105764.39063 37.7628883667318 -122.390158896816 (37.7628883667318, -122.390158896816) 14 3 8 28856 29
182434 242673 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3995 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003206.76531 2102408.34794 37.752994266572 -122.431808939752 (37.752994266572, -122.431808939752) 2 4 5 28862 22
182324 16418 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1390X Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/1992 12:00:00 AM 13 3x3   6016308.5496 2094919.7628 37.7331661358215 -122.385978065712 (37.7331661358215, -122.385978065712) 10 3 8 58 1
182257 17491 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 33 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001944.766 2091477.89942 37.7229101706379 -122.435391342346 (37.7229101706379, -122.435391342346) 9 7 6 28861 5
182213 97272 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3099 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2011 12:00:00 AM 3 3x3 Permit Number 768129 5999961.63318 2116061.04996 37.7902966486155 -122.444012083414 (37.7902966486155, -122.444012083414) 13 6 1 29490 27
182134 17956 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2475 Pine St 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002112.5991001 2115004.8317446 37.7875190105667 -122.436494277471 (37.7875190105667, -122.436494277471) 13 6 11 29490 27
182106 244315 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 3 Median : Cutout Tree DPW 1     7 Width 0ft   6005508.5005 2110550.2437 37.7754801903482 -122.424428160556 (37.7754801903482, -122.424428160556) 7 9 11 28852 10
181994 242428 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6005059.64252 2109908.94794 37.7736939909104 -122.425935208466 (37.7736939909104, -122.425935208466) 7 9 11 28852 10
181823 242742 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4075 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6001841.78911 2105834.98209 37.7623255053519 -122.43677455453 (37.7623255053519, -122.43677455453) 15 5 5 28862 3
181780 137025 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2257 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6003076.30587 2117463.99371 37.79432595493 -122.43333584109 (37.79432595493, -122.43333584109) 13 9 1 29490 27
181698 198507 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 701 Rhode Island St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 6ft   6011858.82974 2105091.40426 37.7608480082603 -122.402076874465 (37.7608480082603, -122.402076874465) 10 3 8 28856 29
181645 244373 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 3 Median : Cutout Tree DPW 1     5 Width 0ft   6005612.0227 2109867.6455 37.7736117862994 -122.424021499783 (37.7736117862994, -122.424021499783) 7 9 11 28852 10
181351 137048 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1221 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008515.8047 2116792.05002 37.7927880503911 -122.414466912531 (37.7927880503911, -122.414466912531) 5 1 10 28858 21
181320 57535 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 546 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1976 12:00:00 AM   3x3 Permit Number 16394 6007841.0815384 2104745.28982278 37.7596725902927 -122.41594801607 (37.7596725902927, -122.41594801607) 2 4 7 28859 19
181114 7500 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2709 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008323.74727 2102623.75492 37.7538744627533 -122.414128615438 (37.7538744627533, -122.414128615438) 2 4 7 28859 19
181096 242460 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 207 Virginia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6006786.17438 2098418.92511 37.7422424704181 -122.419147671535 (37.7422424704181, -122.419147671535) 2 7 7 28859 2
181060 242624 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3198X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008399.77576 2100315.30904 37.7475402587958 -122.413702421345 (37.7475402587958, -122.413702421345) 2 7 7 28859 2
180993 198621 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 454 Mission Bay Blvd South 10 Sidewalk: Curb side : Yard Tree Private 2     5     6015788.57088 2108619.95844 37.7707552061109 -122.388731850804 (37.7707552061109, -122.388731850804) 14 3 9 310 20
180875 242482 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2675 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6008309.34886 2102910.2805 37.7546603883701 -122.414198678945 (37.7546603883701, -122.414198678945) 2 4 7 28859 19
180728 137057 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011992.2179 2118432.89222 37.7974880935481 -122.402553733674 (37.7974880935481, -122.402553733674) 3 1 10 308 23
180678 119831 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 4 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
180670 35675 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1998 12:00:00 AM 8 4x4 Permit Number 38982 6011704.38678633 2118401.70170081 37.7973863786405 -122.403547515196 (37.7973863786405, -122.403547515196) 3 1 10 308 23
180662 242546 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2470 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008189.20727 2104080.21656 37.7578660173281 -122.41469695193 (37.7578660173281, -122.41469695193) 2 4 7 28859 19
180485 17484 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 220X Persia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6002262.8923189 2091226.588151 37.7222381881928 -122.434273689054 (37.7222381881928, -122.434273689054) 9 7 6 28861 5
180406 43363 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4147 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43113 6002235.09605777 2101760.99319187 37.7511616557639 -122.435122856595 (37.7511616557639, -122.435122856595) 2 4 5 28862 22
180386 215502 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 225 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994102.83883 2096543.31026 37.7363700710175 -122.462866361103 (37.7363700710175, -122.462866361103) 9 8 4 59 40
180325 17514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 245X Persia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002400.99383 2091189.19971 37.7221433654964 -122.433793634664 (37.7221433654964, -122.433793634664) 9 7 6 28861 5
180201 136989 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2781 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999666.44189 2118415.79962 37.7967453254804 -122.445202788494 (37.7967453254804, -122.445202788494) 13 9 1 57 17
180076 103743 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2011 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/2014 12:00:00 AM 3 3x3   6008128.1 2106710.2 37.7650839125599 -122.415094442696 (37.7650839125599, -122.415094442696) 8 4 7 28859 19
180073 7610 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3201X Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x3   6008468.12704 2100135.33382 37.7470499250079 -122.413453339725 (37.7470499250079, -122.413453339725) 2 7 7 28859 2
180006 32993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013060.48706 2113590.00605 37.7842502474912 -122.398517212115 (37.7842502474912, -122.398517212115) 6 2 9 28853 6
180002 258222 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2997 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM   3x3   6009042 2101022 37.7495167187784 -122.41153156233 (37.7495167187784, -122.41153156233) 2 4 7 28859 19
179935 242576 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2019 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6008104.56596 2106730.31535 37.7651378220854 -122.415177265415 (37.7651378220854, -122.415177265415) 8 4 7 28859 19
179924 26628 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1099X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/05/2003 12:00:00 AM 3 3X3   6011258.58098 2094170.8511 37.7308290106415 -122.403384596621 (37.7308290106415, -122.403384596621) 10 3 8 58 1
179870 112877 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 300x FRANCONIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x2   6010100 2099291 37.7448230609493 -122.407750909418 (37.7448230609493, -122.407750909418) 2 7 7 28859 2
179762 137033 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1756 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005192.45176 2117848.27927 37.79550092999 -122.426041094625 (37.79550092999, -122.426041094625) 13 9 1 28858 27
179706 17599 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 901X Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x3   6003845.6513541 2090290.953545 37.7197588510105 -122.428735803294 (37.7197588510105, -122.428735803294) 9 7 6 28861 5
179512 123685 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 8 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995474.7934 2113587.5491 37.7832481106245 -122.459356920862 (37.7832481106245, -122.459356920862) 11 6 2 54 11
179498 106172 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 150 CONRAD ST 1 Back Yard : Yard Tree Private 2     14     6001768.8 2096480 37.7366348009068 -122.436357440328 (37.7366348009068, -122.436357440328) 2 7 5 63 7

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