trees

2,365 rows where qSpecies_id = 31 sorted by qLegalStatus_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)
60 264971 Private 9 Ulmus parvifolia :: Chinese Elm 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
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
57138 104401 Private 9 Ulmus parvifolia :: Chinese Elm 31 727 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999017 2108166 37.768564950056 -122.44671213341 (37.768564950056, -122.44671213341) 15 5 11 29492 9
102300 113801 Private 9 Ulmus parvifolia :: Chinese Elm 31 806 SHOTWELL ST 3 Front Yard : Yard Tree Private 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
112431 104768 Private 9 Ulmus parvifolia :: Chinese Elm 31 912 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.434524613527 (37.7542282864134, -122.434524613527) 2 4 5 28862 22
820 41547 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 244 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2000 12:00:00 AM     Permit Number 42070 6001730.08855162 2104417.99791196 37.7584284625233 -122.437059430993 (37.7584284625233, -122.437059430993) 2 4 5 28862 3
2080 51849 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4000 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14   Permit Number 48073 6003004.48334918 2104779.15411028 37.7594924661239 -122.432677808926 (37.7594924661239, -122.432677808926) 2 4 5 28862 3
4061 46914 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 3 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
4429 97836 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 5 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
5917 66634 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 963 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM 5 3x3 Permit Number 29842 6010240.69544356 2103618.46143652 37.7567131899968 -122.407569458435 (37.7567131899968, -122.407569458435) 10 4 7 28859 19
7090 52720 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 710@ 20th ST Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2006 12:00:00 AM     Permit Number 48773 6002386.64959974 2104032.25895211 37.757406613771 -122.434761169877 (37.757406613771, -122.434761169877) 2 4 5 28862 3
7295 100582 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
8784 46303 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   3 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
9121 46285 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
9906 46304 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
10022 46302 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   5 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
10797 49734 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2940REVISED Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2005 12:00:00 AM     Permit Number 46534 6008347.91771108 2101298.08089598 37.7502358181357 -122.413951255275 (37.7502358181357, -122.413951255275) 2 4 7 28859 19
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
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
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                    
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
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
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
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
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
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
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
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
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
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
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
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
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
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
26544 50045 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3928 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM   3x3 Permit Number 46776 6003593.46976323 2102471.5753466 37.753189787602 -122.430476153053 (37.753189787602, -122.430476153053) 2 4 5 28862 22
27440 33762 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1800X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1996 12:00:00 AM 5 3x3 Permit Number 37814 6003491.84820405 2114902.28438826 37.7873157193536 -122.431715030855 (37.7873157193536, -122.431715030855) 13 9 11 29490 27
27672 107994 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4410x 23RD ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000358 2102265 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
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
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
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
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
36858 22315 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 5115X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3X3   6014716.40109 2094586.27231 37.7321621967642 -122.391459290654 (37.7321621967642, -122.391459290654) 10 3 8 58 1
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
38280 66565 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 195 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/1994 12:00:00 AM     Permit Number 29754 6004459.66256991 2092267.48419115 37.725220702439 -122.426754065425 (37.725220702439, -122.426754065425) 9 7 6 28861 5
38837 52664 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1328C. CHAVEZ Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50454 6003228.63897895 2100503.21297012 37.7477644538986 -122.431597294154 (37.7477644538986, -122.431597294154) 2 4 5 63 22
39992 93040 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4076 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6001828 2105877 37.7624400926035 -122.43682525386 (37.7624400926035, -122.43682525386) 15 5 5 28862 3
40330 102181 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1800X Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 37814 6003496.6 2114956.8 37.7874656747779 -122.431702484378 (37.7874656747779, -122.431702484378) 13 9 11 29490 27
40459 97839 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 8 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
40654 31073 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1700X 15th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34816 6005529.95864507 2107274.01239209 37.7664856587307 -122.424120885174 (37.7664856587307, -122.424120885174) 8 4 5 28853 19
40722 94046 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 42 Rivoli St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 53454 5998445 2106022 37.7626453762737 -122.44853619655 (37.7626453762737, -122.44853619655) 15 5 11 29492 9
40753 97851 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 20 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
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
42968 100580 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
42975 17574 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 752X Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/1997 12:00:00 AM 16 3x3   6003494.26805 2090459.52433 37.7202018157394 -122.429962428847 (37.7202018157394, -122.429962428847) 9 7 6 28861 5
43528 17611 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1001X Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     50 3X3   6004077.2256201 2090145.4202003 37.7193723519994 -122.427924968089 (37.7193723519994, -122.427924968089) 9 7 6 28861 5
43704 88338 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 315 Paris St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51325 6002541 2091742 37.7236691751532 -122.433349150158 (37.7236691751532, -122.433349150158) 9 7 6 28861 5
43816 103418 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 700X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015432.6 2105817 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
44866 50808 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 499 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2006 12:00:00 AM     Permit Number 47332 6008981.38895406 2105919.05287132 37.7629595191577 -122.412087198232 (37.7629595191577, -122.412087198232) 8 4 7 28859 19
44900 55226 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/1973 12:00:00 AM   3x3 Permit Number 51714 6015214.86332087 2104389.48828919 37.7591074416555 -122.390420697382 (37.7591074416555, -122.390420697382) 10 3 8 28856 29
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
47613 2633 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1884 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6004452.48891 2115034.49338 37.7877331379393 -122.428400842266 (37.7877331379393, -122.428400842266) 13 9 11 28858 27
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
49994 107991 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4410x 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000358 2102265 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
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
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
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
55359 44113 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1201 Treat Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.412744337506 (37.7509254812099, -122.412744337506) 2 4 7 28859 19
55545 114012 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 952 CAPP ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6007364 2101732 37.7513719527851 -122.417384460989 (37.7513719527851, -122.417384460989) 2 4 7 28859 19
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
56170 46874 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1360 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44937 6008040.39641169 2117081.79459414 37.7935568987708 -122.416132380604 (37.7935568987708, -122.416132380604) 5 1 10 28858 21
58093 48676 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4930 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/06/2006 12:00:00 AM     Permit Number 48856 5997717.95296797 2105658.6000715 37.7616059742438 -122.451024572529 (37.7616059742438, -122.451024572529) 15 5 11 29492 9
58417 31777 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2126 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35251 5989451.98537783 2098364.25532499 37.7411009369348 -122.479079284327 (37.7411009369348, -122.479079284327) 1 8 3 29491 35
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
59471 87143 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2405 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 7 3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
59946 17494 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 98X Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3X3   6001936.09269 2091434.74089 37.7227911744411 -122.435418238322 (37.7227911744411, -122.435418238322) 9 7 6 28861 5
62619 51850 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4000 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14   Permit Number 48073 6003004.48334918 2104779.15411028 37.7594924661239 -122.432677808926 (37.7594924661239, -122.432677808926) 2 4 5 28862 3
62676 32534 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 70 Porter St 3 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
64449 45714 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4096 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 44384 6001696.66920871 2105876.07387076 37.7624300847566 -122.437279411511 (37.7624300847566, -122.437279411511) 15 5 5 28862 3
67520 40174 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 801 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2006 12:00:00 AM 8   Permit Number 48884 6002465.36284573 2103545.36770604 37.7560741956992 -122.434454137261 (37.7560741956992, -122.434454137261) 2 4 5 28862 22
68384 97840 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 9 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
69505 46504 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 165 08th St 3 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
69960 97850 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 19 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
70956 41880 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 126 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 8   Permit Number 42256 6004087.67177215 2108230.12497736 37.7690293739028 -122.429177676408 (37.7690293739028, -122.429177676408) 7 9 5 28862 3
71778 23649 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 213 Virginia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/1998 12:00:00 AM 12 3X3   6006799.15969 2098412.34568 37.7422251360414 -122.41910230566 (37.7422251360414, -122.41910230566) 2 7 7 28859 2
72778 7571 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2961 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3x3   6008420.23555 2101188.16999 37.7499380887476 -122.413693401536 (37.7499380887476, -122.413693401536) 2 4 7 28859 19
73130 59005 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3709 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/1997 12:00:00 AM 8 3x3 Permit Number 18296 6005582.97907977 2104283.94686981 37.7582786381985 -122.423724875571 (37.7582786381985, -122.423724875571) 2 4 5 28859 19
73437 51550 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1247 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2005 12:00:00 AM     Permit Number 47849 5999742.39026173 2108428.18336747 37.7693262500826 -122.444221920277 (37.7693262500826, -122.444221920277) 15 5 11 29492 9
73533 35673 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 4 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
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
74873 7527 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2808 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008275.78702 2102017.83073 37.7522080378675 -122.414251606301 (37.7522080378675, -122.414251606301) 2 4 7 28859 19
75248 49733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2940REVISED Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2005 12:00:00 AM     Permit Number 46534 6008347.91771108 2101298.08089598 37.7502358181357 -122.413951255275 (37.7502358181357, -122.413951255275) 2 4 7 28859 19
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
75735 54877 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 317 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1972 12:00:00 AM   4x3 Permit Number 10739 6005042.77490786 2109859.41873684 37.7735570424684 -122.425990029724 (37.7735570424684, -122.425990029724) 7 9 11 28852 10
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
79111 50430 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 53REVISED Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2004 12:00:00 AM     Permit Number 47083 5998656.22086914 2105364.79387751 37.7608529276064 -122.447758347691 (37.7608529276064, -122.447758347691) 15 5 11 29492 12
79389 97848 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 17 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29

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