trees

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

✎ 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)
121496 53398 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1221 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1972 12:00:00 AM 9   Permit Number 9833 6008515.21769 2116802.84208 37.7928176497632 -122.414469707612 (37.7928176497632, -122.414469707612) 5 1 10 28858 21
73546 53738 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 660-662 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1972 12:00:00 AM   4x4 Permit Number 9418 6002127 2102089 37.7520561456392 -122.435520126196 (37.7520561456392, -122.435520126196) 2 4 5 28862 22
106144 53737 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 656-658 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1972 12:00:00 AM 17   Permit Number 9417 6002154.67978797 2102100.23729555 37.7520885726312 -122.435425209305 (37.7520885726312, -122.435425209305) 2 4 5 28862 22
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
8319 260505 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 760 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2019 12:00:00 AM 3 3x3 Permit Number 784870 6007464 2105234 37.7609932681872 -122.417286789238 (37.7609932681872, -122.417286789238) 2 4 7 28859 19
8224 254835 Private 9 Ulmus parvifolia :: Chinese Elm 31 250 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2019 12:00:00 AM 3 4x3 Permit Number 784635 5989365 2113673 37.7831295589045 -122.480500378386 (37.7831295589045, -122.480500378386) 11 6 2 55 26
49086 239919 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1146 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2018 12:00:00 AM 3 4x4 Permit Number 781978 6009451.28129 2102498.7476 37.7535944875974 -122.410220499083 (37.7535944875974, -122.410220499083) 2 4 7 28859 19
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
68264 173898 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 1 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
134825 117445 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 403 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 778578 6009365.1 2121160.8 37.8048312347901 -122.411837150077 (37.8048312347901, -122.411837150077) 3 1 10 308 23
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
50358 242579 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 818 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2016 12:00:00 AM 11 Width 3ft Permit Number 778239 6001257.94342 2101462.97247 37.7502878270446 -122.438480597209 (37.7502878270446, -122.438480597209) 2 4 5 28862 22
81176 116954 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 818 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2016 12:00:00 AM 3 3x3 Permit Number 778239 6001245 2101454 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352) 2 4 5 28862 22
58996 242613 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 48 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 777782 6007306.44134 2099195.30791 37.7444035295914 -122.417403753004 (37.7444035295914, -122.417403753004) 2 7 7 28859 2
96267 116355 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 148 28TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777724 6004916 2099631 37.7454650539376 -122.425700412207 (37.7454650539376, -122.425700412207) 2 7 5 63 22
81593 95635 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 111X 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777379 6007972 2107962 37.7685122898352 -122.415722998498 (37.7685122898352, -122.415722998498) 8 4 7 28853 19
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
170421 102277 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 316 Walnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2013 12:00:00 AM 1 3x3 Permit Number 776676 5998600.56179 2115376.04421 37.7883380681833 -122.448671915192 (37.7883380681833, -122.448671915192) 13 6 1 54 31
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
172458 23638 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 118 VIRGINIA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 12 4x4 Permit Number 776560 6006594 2098480 37.7423993441016 -122.419816485332 (37.7423993441016, -122.419816485332) 2 7 7 28859 2
74714 166016 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 3332 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2018 12:00:00 AM 3 3x3 Permit Number 776384 6008453.51061 2099255.43212 37.7446330896597 -122.413441663829 (37.7446330896597, -122.413441663829) 2 7 7 28859 2
187402 121251 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4151 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3 Permit Number 776206 6001358 2105811 37.762232149605 -122.438446078367 (37.762232149605, -122.438446078367) 15 5 5 28862 3
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
37035 198590 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013501.44813 2107135.10099 37.766551094089 -122.396539005766 (37.766551094089, -122.396539005766) 14 3 8 28856 20
55756 198584 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013716.83628 2107143.63605 37.7665865138841 -122.395794609033 (37.7665865138841, -122.395794609033) 14 3 8 28856 20
59194 198587 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013654.04555 2107139.63113 37.7665720240075 -122.396011512024 (37.7665720240075, -122.396011512024) 14 3 8 28856 20
72278 198591 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013476.96853 2107132.95858 37.7665438491392 -122.396623526764 (37.7665438491392, -122.396623526764) 14 3 8 28856 20
114716 198586 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013678.51918 2107141.48068 37.7665784640576 -122.39592699106 (37.7665784640576, -122.39592699106) 14 3 8 28856 20
131688 198592 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013452.45897 2107129.35079 37.766532578853 -122.396708048633 (37.766532578853, -122.396708048633) 14 3 8 28856 20
139833 198581 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013801.3988 2107146.90693 37.7666001988537 -122.395502349162 (37.7666001988537, -122.395502349162) 14 3 8 28856 20
158870 198585 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013694.72301 2107142.03178 37.7665808787261 -122.395870983078 (37.7665808787261, -122.395870983078) 14 3 8 28856 20
166195 198588 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013599.81261 2107136.62549 37.766560753709 -122.396198884879 (37.766560753709, -122.396198884879) 14 3 8 28856 20
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
189573 198589 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013524.37895 2107133.46335 37.76654787361 -122.396459576758 (37.76654787361, -122.396459576758) 14 3 8 28856 20
118552 110612 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 15 MAGELLAN AVE   Sidewalk: Property side : Cutout Tree Private 2   05/12/2015 12:00:00 AM 3 3x3 Permit Number 775412 5994586 2101167 37.7490933856104 -122.461530994698 (37.7490933856104, -122.461530994698) 1 8 4 29491 40
55690 97846 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 15 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2015 12:00:00 AM 3   Permit Number 775024 6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
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
165131 16605 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 101 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2014 12:00:00 AM 18 3X3 Permit Number 773154 6002878.7558281 2107677.2386142 37.7674427729111 -122.433319725194 (37.7674427729111, -122.433319725194) 15 5 5 28862 3
9357 106645 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4421 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 772901 6001633.7 2104049.1 37.7574100789152 -122.437366369677 (37.7574100789152, -122.437366369677) 2 4 5 28862 3
5878 236882 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 150 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2016 12:00:00 AM 5 Width 3ft Permit Number 772898 5999413.41178 2107340.88769 37.7663220358477 -122.445281650937 (37.7663220358477, -122.445281650937) 15 5 5 29492 9
45091 25175 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3066 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 9x9 Permit Number 772559 6000144.4461106 2105441.7794376 37.7611492576992 -122.442616778303 (37.7611492576992, -122.442616778303) 15 5 5 28862 3
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
189918 31036 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300 Bennington St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2015 12:00:00 AM 2   Permit Number 771782 6007053.24421 2096706.03657 37.7375542956049 -122.418102817609 (37.7375542956049, -122.418102817609) 2 7 7 28859 2
27935 253392 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 1 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
70032 253393 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 2 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
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
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
121783 96758 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 54 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2014 12:00:00 AM 24 4x4 Permit Number 771133 5994277.34482 2115214.04583 37.7876451092051 -122.463617666172 (37.7876451092051, -122.463617666172) 11 6 1 54 11
127597 103379 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2712 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2013 12:00:00 AM 4 3x3 Permit Number 770136 6000520 2117210 37.7934832007909 -122.44216269001 (37.7934832007909, -122.44216269001) 13 9 1 57 27
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
131533 47022 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 340 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/2013 12:00:00 AM 3 3x3 Permit Number 769670 6004925.00265887 2109895.52879881 37.7736495352098 -122.426399993288 (37.7736495352098, -122.426399993288) 7 9 11 28852 10
171880 34578 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3300 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2012 12:00:00 AM 3   Permit Number 769651 5998982.19825 2115648.46298 37.789107873481 -122.44737113579 (37.789107873481, -122.44737113579) 13 6 1 54 31
82749 101950 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 149 09th St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 11 3x3 Permit Number 769636 6008537 2110562 37.7756830245653 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
110810 101949 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 149 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 10 3x3 Permit Number 769636 6008537 2110562 37.7756830245653 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
35624 38383 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3815-3817 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769372 6003483 2105926 37.762668556024 -122.431104719068 (37.762668556024, -122.431104719068) 15 4 5 28862 3
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
137129 97268 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2050X Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3 Permit Number 769192 5999910.90621 2116024.41622 37.7901931681384 -122.44418496098 (37.7901931681384, -122.44418496098) 13 6 1 29490 27
147345 35612 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2839 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2012 12:00:00 AM 5 3x3 Permit Number 768882 6000549.03074 2116799.12347 37.792356695946 -122.442032735847 (37.792356695946, -122.442032735847) 13 6 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
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
118194 98271 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
119476 98272 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
128168 98270 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   witin landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
164216 98273 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
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
100819 97270 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3099 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2011 12:00:00 AM   3x3 Permit Number 768129 5999976 2116041.4 37.7902435145098 -122.443960962963 (37.7902435145098, -122.443960962963) 13 6 1 29490 27
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
116775 57076 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2011 12:00:00 AM 18 3x3 Permit Number 767819 6015234.40756552 2104029.6701639 37.7581205423321 -122.390327963745 (37.7581205423321, -122.390327963745) 10 3 8 28856 29
141855 53651 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 829 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/1969 12:00:00 AM 1   Permit Number 6587 6012068.4217 2112548.0645 37.7813340008977 -122.401876160632 (37.7813340008977, -122.401876160632) 6 2 9 28856 34
119288 53481 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1969 12:00:00 AM 8   Permit Number 6390 6002979.07126 2117470.0427 37.7943370471773 -122.433672716337 (37.7943370471773, -122.433672716337) 13 9 1 29490 27
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
160640 30372 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 498x Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/1956 12:00:00 AM 10 3x3 Permit Number 60 6012938.59384 2104777.04886 37.7600450647473 -122.39832036669 (37.7600450647473, -122.39832036669) 10 3 8 28856 29
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
109377 101909 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1801 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 1 3x3 Permit Number 56808 6000521 2114812 37.7868989750002 -122.441987028891 (37.7868989750002, -122.441987028891) 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
192648 137003 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2009 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2018 12:00:00 AM 3 Width 5ft Permit Number 54784 6000925.45589 2115354.39726 37.7884112973018 -122.44062662694 (37.7884112973018, -122.44062662694) 13 6 1 29490 27
155936 102761 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 100X Russ St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.408218187711 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
176570 68218 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 233 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/04/2010 12:00:00 AM 4   Permit Number 53885 5990842.3093 2113821.79414 37.7836238495535 -122.475400406913 (37.7836238495535, -122.475400406913) 11 6 2 54 26
177512 94464 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 894 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/2010 12:00:00 AM 4 3x3 Permit Number 53682 6011686.524 2112270.5705 37.7805507464569 -122.403177821901 (37.7805507464569, -122.403177821901) 6 2 9 28853 34
76316 94343 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 735 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2010 12:00:00 AM 3 3x3 Permit Number 53631 6009320.52267 2110260.04995 37.7748979142358 -122.411220911221 (37.7748979142358, -122.411220911221) 8 2 9 28853 34
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
140374 93578 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 401X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2010 12:00:00 AM 1 3x3 Permit Number 53401 6009309.6837 2121148.6264 37.8047947000965 -122.41202806393 (37.8047947000965, -122.41202806393) 3 1 10 308 23
30137 52300 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 264 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 5 3x3 Permit Number 53169 6001736.20846819 2104306.03679934 37.758121392277 -122.437030249981 (37.758121392277, -122.437030249981) 2 4 5 28862 3
79565 92521 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1350 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6009005 2109688 37.773309499002 -122.412271934387 (37.773309499002, -122.412271934387) 8 2 9 28853 34
153488 92522 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1350 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6009005 2109688 37.773309499002 -122.412271934387 (37.773309499002, -122.412271934387) 8 2 9 28853 34
93983 83010 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 507 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 6 3x3 Permit Number 52387 6011806.26016 2105993.89934 37.763323124185 -122.402322147448 (37.763323124185, -122.402322147448) 8 3 8 28856 29
80710 81876 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1209 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52375 6013966.08986 2105691.70822 37.762613702073 -122.394830783137 (37.762613702073, -122.394830783137) 10 3 8 28856 29
105010 83024 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1209 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 8 3x3 Permit Number 52375 6013948.88284 2105690.73542 37.7626100742202 -122.394890228324 (37.7626100742202, -122.394890228324) 10 3 8 28856 29
172075 83229 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1169 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52333 6005183.33361 2120915.83626 37.8039231412044 -122.426291152916 (37.8039231412044, -122.426291152916) 13 9 1 28858 17
109774 82620 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 262 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52220 6007782.82233026 2105835.06197207 37.7626615773847 -122.416226690034 (37.7626615773847, -122.416226690034) 8 4 7 28859 19
157733 82639 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 262 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52220 6007782.82233026 2105835.06197207 37.7626615773847 -122.416226690034 (37.7626615773847, -122.416226690034) 8 4 7 28859 19
159379 92019 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 129 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2009 12:00:00 AM   3x3 Permit Number 52167 6008096 2112840 37.7819130903868 -122.415639514466 (37.7819130903868, -122.415639514466) 7 10 9 28852 36
41418 64129 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 662 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2009 12:00:00 AM   3x3 Permit Number 52075 6002246.83688253 2098888.05007266 37.7432738978208 -122.434876821092 (37.7432738978208, -122.434876821092) 2 7 5 63 22
28247 91339 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 829 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2009 12:00:00 AM 1 3x3 Permit Number 52060 6012087.196 2112565.923 37.7813840839391 -122.401812466037 (37.7813840839391, -122.401812466037) 6 2 9 28856 34
171381 91295 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3065 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2009 12:00:00 AM 5 3x3 Permit Number 52052 6000114.74904 2115757.98498 37.7894732446403 -122.443460536396 (37.7894732446403, -122.443460536396) 13 6 1 29490 27
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
54713 91161 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 525 Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 4 3x3 Permit Number 52035 6007091.03056 2112582.20177 37.7811486961969 -122.419097960601 (37.7811486961969, -122.419097960601) 7 9 9 28852 36
115223 91160 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 525 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 4 3x3 Permit Number 52035 6007065.15922 2112579.7073 37.7811403900434 -122.419187285764 (37.7811403900434, -122.419187285764) 7 9 9 28852 36
189568 6037 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1822 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2008 12:00:00 AM 3 3x3 Permit Number 51912 6001625.9468 2112554.8978 37.7807644518495 -122.43800243798 (37.7807644518495, -122.43800243798) 15 5 11 29490 41

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