trees

2,365 rows where qSpecies_id = 31 sorted by TreeID 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)
193536 99816 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 660-662 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Most likely permitted for planting at same time as tree no. 1 6002127 2102089 37.7520561456392 -122.435520126196 (37.7520561456392, -122.435520126196) 2 4 5 28862 22
105912 99790 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4140-4124 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Most likely planted when tree 1 was planted/permitted. 6002271 2101809 37.7512955097612 -122.435002130134 (37.7512955097612, -122.435002130134) 2 4 5 28862 22
102675 99285 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2839 Pacific Ave 2 Sidewalk: Property side : Cutout Tree Private 2     4     6000571.30245 2116798.91345 37.7923573884461 -122.441955660321 (37.7923573884461, -122.441955660321) 13 6 1 29490 27
138380 99283 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 812 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002420 2103476 37.7558811534963 -122.434606057101 (37.7558811534963, -122.434606057101) 2 4 5 28862 22
102563 99187 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 198X Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000112.3 2105690.3 37.761829801242 -122.442745803115 (37.761829801242, -122.442745803115) 15 5 5 28862 3
178837 99109 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1814 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6001553.766 2114786.5748 37.7868879621167 -122.43841208082 (37.7868879621167, -122.43841208082) 13 6 11 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
68907 98928 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 112 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005385 2103055 37.7548930594212 -122.424322167644 (37.7548930594212, -122.424322167644) 2 4 5 28859 19
97038 98861 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 09th St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008516.35298 2110609.93053 37.7758134708437 -122.414027470493 (37.7758134708437, -122.414027470493) 8 2 9 28853 34
135105 98860 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008529.07758 2110594.62185 37.7757721514991 -122.413982369511 (37.7757721514991, -122.413982369511) 8 2 9 28853 34
145441 98859 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008542.44899 2110581.95524 37.7757381229623 -122.413935218038 (37.7757381229623, -122.413935218038) 8 2 9 28853 34
121104 98858 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008557.54308 2110566.5981 37.7756968035946 -122.413881917042 (37.7756968035946, -122.413881917042) 8 2 9 28853 34
19980 98857 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008572.87311 2110548.2851 37.77564738136 -122.413827590795 (37.77564738136, -122.413827590795) 8 2 9 28853 34
76962 98856 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008586.80061 2110533.83683 37.7756084919722 -122.413778389761 (37.7756084919722, -122.413778389761) 8 2 9 28853 34
60275 98855 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008612.62439 2110507.04759 37.7755363852191 -122.413687163434 (37.7755363852191, -122.413687163434) 8 2 9 28853 34
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
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
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
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
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
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
159174 98182 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 221 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/04/2014 12:00:00 AM 3 3x3   6002914 2106980 37.7655303249722 -122.433147996925 (37.7655303249722, -122.433147996925) 15 5 5 28862 3
107924 98128 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 295X Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3 3644-3650 24th Street is true address 6005477 2102008.3 37.7520242585611 -122.423929579181 (37.7520242585611, -122.423929579181) 2 4 5 28859 19
126078 98127 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 295X Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3 3644-3650 24th St is true address 6005477 2102008.3 37.7520242585611 -122.423929579181 (37.7520242585611, -122.423929579181) 2 4 5 28859 19
30218 97985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     16     6015230.10587 2104016.74085 37.7580848025885 -122.390341937645 (37.7580848025885, -122.390341937645) 10 3 8 28856 29
102228 97852 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 21 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
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
176444 97849 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 18 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
152742 97847 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 16 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
146851 97845 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 14 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
172519 97844 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 13 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
120368 97843 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 12 Sidewalk: Curb side : Cutout Tree Private 2     18     6015209.91817 2104379.39414 37.7590794509666 -122.390437094914 (37.7590794509666, -122.390437094914) 10 3 8 28856 29
116424 97842 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 11 Sidewalk: Curb side : Cutout Tree Private 2     14     6015209.65715 2104398.16252 37.7591309704315 -122.390439309039 (37.7591309704315, -122.390439309039) 10 3 8 28856 29
132431 97841 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 10 Sidewalk: Curb side : Cutout Tree Private 2     15     6015209.75012 2104419.2004 37.7591887410927 -122.390440457463 (37.7591887410927, -122.390440457463) 10 3 8 28856 29
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
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
152559 97838 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 7 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
174974 97837 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 6 Sidewalk: Curb side : Cutout Tree Private 2     12     6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
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
189071 97835 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 4 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
107524 97834 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
156161 97833 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
144725 97832 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
26272 9765 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 827X Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6000964.4329 2111657.6469 37.7782631876883 -122.440226567073 (37.7782631876883, -122.440226567073) 15 5 11 29490 41
115870 97643 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 642 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993491.08963 2113521.49369 37.7829524880612 -122.466214884321 (37.7829524880612, -122.466214884321) 11 6 2 54 11
55149 97435 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1300x Newcomb Ave 4 Median : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3     6016490.8874 2094837.7533 37.7329510434152 -122.385341956131 (37.7329510434152, -122.385341956131) 10 3 8 58 1
16699 97434 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380x Newcomb Ave 5 Median : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3     6016360.63733 2094893.94179 37.7330981190079 -122.385796183605 (37.7330981190079, -122.385796183605) 10 3 8 58 1
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
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
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
145100 97234 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380X Newcomb Ave 14 Median : Cutout Tree DPW 1     8 15x200   6016360.63733 2094893.94179 37.7330981190079 -122.385796183605 (37.7330981190079, -122.385796183605) 10 3 8 58 1
146659 97233 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1300X Newcomb Ave 13 Median : Cutout Tree DPW 1     6 15x200   6016357.8982 2094854.1147 37.7329886101989 -122.385802878589 (37.7329886101989, -122.385802878589) 10 3 8 58 1
40918 97229 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301X Newcomb Ave 9 Median : Cutout Tree DPW 1     28 15x200   6016636.94251 2094930.84044 37.7332147213866 -122.384843483567 (37.7332147213866, -122.384843483567) 10 3 8 58 1
188111 97225 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301X Newcomb Ave 5 Median : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3 15x200   6016649.85073 2094946.91351 37.7332595687675 -122.384799975236 (37.7332595687675, -122.384799975236) 10 3 8 58 1
107965 97221 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301X Newcomb Ave 1 Median : Cutout Tree DPW 1     5 15x200   6016689.53805 2094986.80633 37.733371301443 -122.384665541907 (37.733371301443, -122.384665541907) 10 3 8 58 1
26830 97057 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 227 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6003560 2106944 37.7654681015181 -122.430911059584 (37.7654681015181, -122.430911059584) 8 4 5 28862 3
51187 97030 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 278 Howth St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5997252 2090493 37.7199382378616 -122.451542171872 (37.7199382378616, -122.451542171872) 9 8 6 28861 24
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
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
70821 96366 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1326 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006664.3237 2118739.81484 37.7980319387709 -122.421011488604 (37.7980319387709, -122.421011488604) 13 9 10 28858 32
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
61943 94631 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3359X Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008508.32058 2099227.63825 37.7445598511663 -122.413250176052 (37.7445598511663, -122.413250176052) 2 7 7 28859 2
156222 94494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 750 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5992906.29601 2110338.45907 37.7741789797645 -122.468006407076 (37.7741789797645, -122.468006407076) 11 6 2 54 11
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
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
52862 9361 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 252 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     15 2x2   6001048.03235 2098320.17238 37.7416465022772 -122.43898127679 (37.7416465022772, -122.43898127679) 2 7 5 63 7
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
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
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
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
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
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
105797 91811 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2685 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/28/2016 02:45:00 PM 3 3x3   6008942.770855 2102838.050886 37.754497621185 -122.412003022866 (37.754497621185, -122.412003022866) 2 4 7 28859 19
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
93167 91037 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 7 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010705.7086 2111246.6708 37.7776845332645 -122.406498774175 (37.7776845332645, -122.406498774175) 14 2 9 28853 34
110000 91036 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010688.5143 2111227.8126 37.7776317911098 -122.406556926191 (37.7776317911098, -122.406556926191) 14 2 9 28853 34
23450 91035 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010666.0508 2111208.1223 37.7775764693736 -122.406633247496 (37.7775764693736, -122.406633247496) 14 2 9 28853 34
104469 91034 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010653.2937 2111194.8106 37.7775392048064 -122.406676440472 (37.7775392048064, -122.406676440472) 14 2 9 28853 34
105551 91033 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010628.8889 2111172.6244 37.7774769212136 -122.406759301284 (37.7774769212136, -122.406759301284) 14 2 9 28853 34
165047 91032 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010616.6864 2111159.8673 37.7774412104334 -122.406800614681 (37.7774412104334, -122.406800614681) 14 2 9 28853 34
24697 91031 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010606.148 2111149.8835 37.7774132075868 -122.406836366848 (37.7774132075868, -122.406836366848) 14 2 9 28853 34
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
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
81036 88994 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 680 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2008 12:00:00 AM 3 3x3 Permit Number 51742 6013026.73798 2113549.67814 37.784137636178 -122.398631141832 (37.784137636178, -122.398631141832) 6 2 9 28853 6
126626 88993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 680 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2008 12:00:00 AM 3 3x3 Permit Number 51742 6013040.85329 2113568.29514 37.7841895405473 -122.398583614443 (37.7841895405473, -122.398583614443) 6 2 9 28853 6
82255 88990 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 690 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012998.85994 2113529.84786 37.7840816336096 -122.398726198376 (37.7840816336096, -122.398726198376) 6 2 9 28853 6
170626 88830 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St   Sidewalk: Curb side : Cutout Tree Private 2   09/10/2008 12:00:00 AM   3x3 Permit Number 51714 6015215 2104389 37.7591061085001 -122.390420190559 (37.7591061085001, -122.390420190559) 10 3 8 28856 29
175636 88555 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 609 16th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51500 5990920.3 2111212.9 37.7764650666065 -122.474940092984 (37.7764650666065, -122.474940092984) 11 6 2 54 26
147491 88436 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1631 Folsom St   Sidewalk: Curb side : Cutout Tree Private 2   07/11/2008 12:00:00 AM   3x3 Permit Number 51400 6008146 2108680 37.7704935294513 -122.415171976468 (37.7704935294513, -122.415171976468) 8 2 9 28853 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);