trees

2,365 rows where qSpecies_id = 31 sorted by qAddress 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)
116529 198508 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 998 Rhode Island St 4 : Tree Private 2     10 Width 3ft   6011865.97365 2103785.48158 37.7572626324706 -122.401960360989 (37.7572626324706, -122.401960360989) 10 3 8 28856 29
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
25561 101710 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 990 Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 3x3   6011874 2103773 37.7572288087602 -122.401931725179 (37.7572288087602, -122.401931725179) 10 3 8 28856 29
87922 180542 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 990 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004004.09033 2090139.32192 37.7193514696869 -122.42817733523 (37.7193514696869, -122.42817733523) 9 7 6 28861 5
119597 122758 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 99 Park Hill Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x5   6001111 2107407 37.766600319422 -122.439414765245 (37.766600319422, -122.439414765245) 15 5 5 29492 3
120238 242731 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 99 Park Hill Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6001135.55367 2107466.14024 37.7667641011975 -122.439334078131 (37.7667641011975, -122.439334078131) 15 5 5 29492 3
154130 242759 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 99 Ord St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6000876.8584 2105865.2464 37.7623537170769 -122.440114051125 (37.7623537170769, -122.440114051125) 15 5 5 28862 3
106747 115732 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 99 ORD ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   22 3x3   6000874 2105811 37.7622046070719 -122.440120047168 (37.7622046070719, -122.440120047168) 15 5 5 28862 3
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
173502 17493 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 98X Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3X3   6001898.43212 2091454.2052 37.722842480127 -122.435549814469 (37.722842480127, -122.435549814469) 9 7 6 28861 5
26663 85795 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 985 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 12 3x3   6011121.9774 2111644.9134 37.7788012938106 -122.405086799447 (37.7788012938106, -122.405086799447) 14 2 9 28856 34
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
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
127376 105993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6015232.0353 2104000.80366 37.7580411495011 -122.390334151305 (37.7580411495011, -122.390334151305) 10 3 8 28856 29
62805 105992 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 980 MINNESOTA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6015221.1 2104017.4 37.758086112912 -122.39037313012 (37.758086112912, -122.39037313012) 10 3 8 28856 29
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
90577 198693 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 97 Whitney Young Cir 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6016661.34411 2095009.85168 37.733433020107 -122.384764621992 (37.733433020107, -122.384764621992) 10 3 8 58 1
121839 198694 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 97 Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6016624.01227 2094969.82171 37.7333210410161 -122.384890902109 (37.7333210410161, -122.384890902109) 10 3 8 58 1
159626 85797 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 969 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2007 12:00:00 AM 3 3x3   6011197.4105 2111716.4639 37.7790019714524 -122.404830884084 (37.7790019714524, -122.404830884084) 14 2 9 28856 34
189978 57074 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 966 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 24 9x7.5 Permit Number 14341 6015226.17172 2104099.64367 37.7583122177548 -122.390361336011 (37.7583122177548, -122.390361336011) 10 3 8 28856 29
120906 41342 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 965 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM 4 3x3 Permit Number 45442 6011232.3538 2111749.1886 37.7790937789608 -122.404712304921 (37.7790937789608, -122.404712304921) 14 2 9 28856 34
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
159077 242402 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 963 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010232.4769 2103605.53366 37.756677233172 -122.407596969832 (37.756677233172, -122.407596969832) 10 4 7 28859 19
179272 85757 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 960 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2007 12:00:00 AM 3 3x3   6011195.1919 2111802.9901 37.7792394282463 -122.404844652616 (37.7792394282463, -122.404844652616) 14 2 9 28853 34
107929 242593 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 960 Elizabeth St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6000277.53945 2101991.55092 37.7516833590194 -122.441908822732 (37.7516833590194, -122.441908822732) 2 4 5 28862 22
73412 215570 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 96 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5995600.39767 2096198.59734 37.7355097165874 -122.457663772269 (37.7355097165874, -122.457663772269) 9 7 4 59 40
163843 242781 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95x McCoppin St 2 Median : Yard Tree DPW 1     4 Width 9ft   6006152.38517 2109124.27435 37.771601160584 -122.422099480311 (37.771601160584, -122.422099480311) 8 2 9 28853 19
6558 57073 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 958 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 17   Permit Number 14340 6015221.7654 2104138.81007 37.7584195158777 -122.390379311651 (37.7584195158777, -122.390379311651) 10 3 8 28856 29
90769 85756 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 956 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2007 12:00:00 AM 3 3x3   6011236.2364 2111841.2613 37.7793468061687 -122.404705356954 (37.7793468061687, -122.404705356954) 14 2 9 28853 34
14897 242642 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 952 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007375.48933 2101738.08123 37.7513892968874 -122.417345160358 (37.7513892968874, -122.417345160358) 2 4 7 28859 19
96466 242643 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 952 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007376.06475 2101722.46593 37.7513464531926 -122.417342064 (37.7513464531926, -122.417342064) 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
103135 85799 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 951 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2007 12:00:00 AM 3 3x3   6011299.4671 2111813.5286 37.7792741924758 -122.404484661651 (37.7792741924758, -122.404484661651) 14 2 9 28856 34
160247 242435 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 951 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6004408.4107 2103355.6712 37.7556634382295 -122.427720909508 (37.7556634382295, -122.427720909508) 2 4 5 28862 22
28621 198494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015476.06266 2104658.66701 37.7598610346751 -122.389536136987 (37.7598610346751, -122.389536136987) 10 3 8 28856 29
61156 198493 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6015474.58751 2104684.20174 37.7599310657768 -122.389543022191 (37.7599310657768, -122.389543022191) 10 3 8 28856 29
99175 198497 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6015478.44281 2104579.86448 37.7596447917884 -122.389522401658 (37.7596447917884, -122.389522401658) 10 3 8 28856 29
152759 198495 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015477.3225 2104627.00235 37.7597741601603 -122.389529568345 (37.7597741601603, -122.389529568345) 10 3 8 28856 29
176285 198492 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6015469.84245 2104726.88605 37.7600480046386 -122.389562414283 (37.7600480046386, -122.389562414283) 10 3 8 28856 29
188406 198496 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015478.89402 2104602.20916 37.7597061705092 -122.389522401658 (37.7597061705092, -122.389522401658) 10 3 8 28856 29
112923 215498 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993979.5407 2097285.08347 37.7383996933922 -122.463346462392 (37.7383996933922, -122.463346462392) 1 8 4 59 40
113352 215546 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993989.26357 2097198.82691 37.7381634145006 -122.463306588246 (37.7381634145006, -122.463306588246) 1 8 4 59 40
172535 215499 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993991.18061 2097202.58443 37.7381738421581 -122.463300232714 (37.7381738421581, -122.463300232714) 1 8 4 59 40
85837 242780 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 McCoppin St 1 : Tree Private 2     3 Width 9ft   6006179.77173 2109125.10938 37.7716049979898 -122.422004807797 (37.7716049979898, -122.422004807797) 8 2 9 28853 19
17973 17607 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 948X Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6003925.7500102 2090181.5613293 37.7194630169915 -122.428451137586 (37.7194630169915, -122.428451137586) 9 7 6 28861 5
37705 17606 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 945X Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004029.89293 2090169.1541 37.7194348422149 -122.428090270065 (37.7194348422149, -122.428090270065) 9 7 6 28861 5
171836 17605 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 937 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6003999.6997 2090190.61004 37.7194920472054 -122.428196165219 (37.7194920472054, -122.428196165219) 9 7 6 28861 5
157109 3749 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 934 Carolina St 3 Median : Cutout Tree DPW 1     3 18   6012421.5071398 2103592.6632765 37.756764184951 -122.400025556542 (37.756764184951, -122.400025556542) 10 3 8 28856 29
26914 242771 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 930 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002454.1308 2102779.02186 37.7539693556059 -122.434438191367 (37.7539693556059, -122.434438191367) 2 4 5 28862 22
44335 242772 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 930 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002452.78798 2102762.57285 37.7539241143239 -122.434441659158 (37.7539241143239, -122.434441659158) 2 4 5 28862 22
164074 104772 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 930 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6002436.6 2102773.8 37.7539540224902 -122.434498443618 (37.7539540224902, -122.434498443618) 2 4 5 28862 22
174224 104773 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 930 CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002436.6 2102773.8 37.7539540224902 -122.434498443618 (37.7539540224902, -122.434498443618) 2 4 5 28862 22
92258 242770 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 928 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002453.02968 2102798.51667 37.7540228211998 -122.434443393046 (37.7540228211998, -122.434443393046) 2 4 5 28862 22
25061 104771 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 928 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002435.2 2102798.9 37.7540228616298 -122.434505079683 (37.7540228616298, -122.434505079683) 2 4 5 28862 22
33876 115549 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412) 10 3 8 28856 29
38426 115550 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.390181786362 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
129944 115551 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.390190372193 (37.7585616474178, -122.390190372193) 10 3 8 28856 29
23349 242769 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 922 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002452.60513 2102826.48579 37.7540995936313 -122.43444686085 (37.7540995936313, -122.43444686085) 2 4 5 28862 22
42118 180519 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 919 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6003897.75198 2090254.30542 37.7196611719008 -122.428553098957 (37.7196611719008, -122.428553098957) 9 7 6 28861 5
47025 180518 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 919 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6003927.65212 2090238.59404 37.7196197239493 -122.42844862563 (37.7196197239493, -122.42844862563) 9 7 6 28861 5
64697 180520 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 919 Persia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6003878.61607 2090266.0202 37.7196922551652 -122.428620079558 (37.7196922551652, -122.428620079558) 9 7 6 28861 5
20097 57068 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 918 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1974 12:00:00 AM 15 6x7 Permit Number 14334 6015212.77238 2104346.74514 37.7589899621477 -122.390424942382 (37.7589899621477, -122.390424942382) 10 3 8 28856 29
167031 242768 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 918 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002453.76443 2102846.18378 37.7541537454185 -122.434444259992 (37.7541537454185, -122.434444259992) 2 4 5 28862 22
124588 104769 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 918 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6002432.5 2102848.2 37.7541580743967 -122.434517941678 (37.7541580743967, -122.434517941678) 2 4 5 28862 22
161237 104770 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 918 CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002432.5 2102848.2 37.7541580743967 -122.434517941678 (37.7541580743967, -122.434517941678) 2 4 5 28862 22
80782 242681 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 915 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003786.92394 2102934.71001 37.7544724030869 -122.429840181696 (37.7544724030869, -122.429840181696) 2 4 5 28862 22
166589 111683 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 915 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x7   6015271.38469 2104348.44266 37.7589978743768 -122.390222350301 (37.7589978743768, -122.390222350301) 10 3 8 28856 29
106858 112787 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 913 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6015266.54568 2104367.00121 37.7590485637711 -122.390240382605 (37.7590485637711, -122.390240382605) 10 3 8 28856 29
28436 17602 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 912 Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6003897.46129 2090203.63126 37.7195220153206 -122.428550493605 (37.7195220153206, -122.428550493605) 9 7 6 28861 5
157246 242767 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 912 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6002452.81588 2102860.93213 37.7541941870245 -122.434448594721 (37.7541941870245, -122.434448594721) 2 4 5 28862 22
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
191739 201850 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 911 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6011602 2112119 37.7801298483764 -122.403459565618 (37.7801298483764, -122.403459565618) 14 2 9 28856 34
126700 242370 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90x McCoppin St 1 Median : Yard Tree DPW 1     5 Width 10ft   6006121.14049 2109126.61017 37.7716058118802 -122.422207723609 (37.7716058118802, -122.422207723609) 8 2 9 28853 19
127825 242371 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90x McCoppin St 2 Median : Yard Tree DPW 1     6 Width 10ft   6006102.65154 2109126.4322 37.771604280331 -122.42227166541 (37.771604280331, -122.42227166541) 8 2 9 28853 19
24769 198491 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 907 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6015266.77203 2104421.22514 37.7591974636091 -122.390243388116 (37.7591974636091, -122.390243388116) 10 3 8 28856 29
63979 17601 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 901X Persia Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     17 3x3   6003845.6513541 2090290.953545 37.7197588510105 -122.428735803294 (37.7197588510105, -122.428735803294) 9 7 6 28861 5
119925 17600 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 901X Persia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     15 3x3   6003845.6513541 2090290.953545 37.7197588510105 -122.428735803294 (37.7197588510105, -122.428735803294) 9 7 6 28861 5
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
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
132072 84446 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 901 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6000457.5617 2112125.7689 37.7795196602627 -122.442013625663 (37.7795196602627, -122.442013625663) 15 5 1 29490 16
24002 198501 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900x Carolina St 13 Median : Yard Tree DPW 1     15     6012463.03254 2103576.30053 37.7567215715659 -122.399880796574 (37.7567215715659, -122.399880796574) 10 3 8 28856 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
117784 242606 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900X Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5997274 2107360 37.7662521591899 -122.45268281502 (37.7662521591899, -122.45268281502) 15 5 11 29492 9
139032 114306 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 900 STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997219 2107398 37.7663533458689 -122.452875791584 (37.7663533458689, -122.452875791584) 15 5 11 29492 9
167875 17598 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6003858.86664 2090228.3157 37.71958760917 -122.428685659924 (37.71958760917, -122.428685659924) 9 7 6 28861 5
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

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