Street_Tree_List

Data source: data.sfgov.org

93 rows where qSpecies = 23

View and edit SQL

Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
47 17325 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/31/2016 12:00:00 AM 3 3x3   6006651.4447 2108878.4679400004 37.7709543699737 -122.420355751511 (37.7709543699737, -122.420355751511)
133 218972 Undocumented 2 Fraxinus americana :: American Ash 23 742 Myra Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft Permit Number 779535 5997475.9556599995 2098006.28819 37.7405807633888 -122.451309623139 (37.7405807633888, -122.451309623139)
5625 23563 Permitted Site 1 Fraxinus americana :: American Ash 23 2940 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 4X4   6005640.896240001 2120504.56885 37.8028197593833 -122.42467845266701 (37.8028197593833, -122.424678452667)
10495 986 DPW Maintained 3 Fraxinus americana :: American Ash 23 1634 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6001643.13591 2092619.68288 37.7260281147961 -122.436515696352 (37.7260281147961, -122.436515696352)
10728 22543 DPW Maintained 3 Fraxinus americana :: American Ash 23 1416X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X6   6002329.27888 2093769.4237799998 37.7292240094582 -122.434225904616 (37.7292240094582, -122.434225904616)
10870 22542 DPW Maintained 3 Fraxinus americana :: American Ash 23 1416X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3X6   6002345.30363 2093794.47674 37.7292937087186 -122.43417229601499 (37.7292937087186, -122.434172296015)
11684 989 DPW Maintained 3 Fraxinus americana :: American Ash 23 1654 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6001587.11696 2092507.46593 37.725716809081604 -122.436701320907 (37.7257168090816, -122.436701320907)
17650 17327 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6006652.60436 2108850.55128 37.7708777828196 -122.420349758438 (37.7708777828196, -122.420349758438)
19584 17328 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006653.987869999 2108819.46705 37.7707925108849 -122.420342766214 (37.7707925108849, -122.420342766214)
20852 3378 Permitted Site 1 Fraxinus americana :: American Ash 23 6042 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2009 12:00:00 AM 3 3x3   5988776.433730001 2114029.70842 37.7840747573181 -122.482562701651 (37.7840747573181, -122.482562701651)
21084 17329 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006657.292 2108797.5447400003 37.77073250362729 -122.42032978092199 (37.7707325036273, -122.420329780922)
23336 17326 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/29/2015 12:00:00 AM 24 3X3   6006652.92291 2108866.0729799997 37.770920419662794 -122.420349758429 (37.7709204196628, -122.420349758429)
23647 137617 Undocumented 2 Fraxinus americana :: American Ash 23 2000 TURK BLVD 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999974.0415 2112006.8982 37.779165706043 -122.44367778095 (37.779165706043, -122.44367778095)
24812 128806 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6010753.62234 2121642.08784 37.806230530884 -122.40706594354201 (37.806230530884, -122.407065943542)
25614 192193 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6014938.13468 2116178.28244 37.79146148471221 -122.392202240147 (37.7914614847122, -122.392202240147)
27983 112232 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 34 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   5999559.4748 2111943.9518 37.7789692179466 -122.44510740551901 (37.7789692179466, -122.445107405519)
28575 112217 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999859.3165 2111987.2698 37.7791052675019 -122.44407324969801 (37.7791052675019, -122.444073249698)
29088 192187 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014922.34565 2116076.94881 37.7911823693173 -122.3922497801 (37.7911823693173, -122.3922497801)
31336 112207 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000150.3593 2112028.2188 37.7792343016328 -122.44306935884899 (37.7792343016328, -122.443069358849)
33561 112199 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6000361.5345 2112057.6615 37.779327182073395 -122.44234093295799 (37.7793271820734, -122.442340932958)
34004 112228 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 30 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999656.6019 2111958.8423 37.779015646658394 -122.44477247571501 (37.7790156466584, -122.444772475715)
37849 128800 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6010780.9231 2121471.9877299997 37.8057650058121 -122.406959467428 (37.8057650058121, -122.406959467428)
38659 112219 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999801.7848 2111978.4708 37.7790778255592 -122.444271642134 (37.7790778255592, -122.444271642134)
39731 112221 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999767.2658 2111975.0866 37.779066563967206 -122.444390813692 (37.7790665639672, -122.444390813692)
39897 112227 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 29 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999670.4772 2111960.8729 37.7790220139758 -122.44472462161998 (37.7790220139758, -122.44472462162)
42143 176482 Undocumented 2 Fraxinus americana :: American Ash 23 751 Burrows St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6009094.685930001 2092828.45865 37.727021988858205 -122.41077079064199 (37.7270219888582, -122.410770790642)
42677 192180 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014994.3077300005 2116006.28065 37.7909923263706 -122.39199584752599 (37.7909923263706, -122.391995847526)
44460 112222 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 24 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999751.0216 2111973.3945 37.7790609910565 -122.444446887136 (37.7790609910565, -122.444446887136)
47041 112205 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000191.9852 2112033.972 37.7792524717433 -122.44292577135599 (37.7792524717433, -122.442925771356)
47523 112220 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999785.2022 2111976.4403 37.7790713042385 -122.444328861929 (37.7790713042385, -122.444328861929)
48233 112203 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000273.8832 2112045.1399 37.7792878048325 -122.442643255191 (37.7792878048325, -122.442643255191)
48387 128804 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6010764.510430001 2121581.8591 37.8060657669756 -122.407024015346 (37.8060657669756, -122.407024015346)
48426 112230 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 32 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999608.2076 2111950.3818 37.77898965446521 -122.444939282166 (37.7789896544652, -122.444939282166)
48570 192178 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6015027.5058699995 2115974.64571 37.7909073071818 -122.391878769291 (37.7909073071818, -122.391878769291)
52848 176479 Undocumented 2 Fraxinus americana :: American Ash 23 1624 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001670.19338 2092689.0121799998 37.726220014826495 -122.436427120331 (37.7262200148265, -122.436427120331)
52953 192181 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014979.691880001 2116018.41542 37.791024834186004 -122.39204726717199 (37.791024834186, -122.392047267172)
57085 192192 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6014928.99529 2116169.34325 37.791436432301296 -122.392233237069 (37.7914364323013, -122.392233237069)
57247 112208 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000131.4077 2112027.2035 37.7792304332977 -122.443134847125 (37.7792304332977, -122.443134847125)
57698 192179 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   6015008.84996 2115990.5046 37.7909498163315 -122.39194442791201 (37.7909498163315, -122.391944427912)
58397 192183 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6014959.29976 2116038.8631 37.7910798466 -122.392119254319 (37.7910798466, -122.392119254319)
59458 112216 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999876.9145 2111991.6693 37.779118351288204 -122.444012687447 (37.7791183512882, -122.444012687447)
60187 112229 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 31 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999625.4671 2111952.4123 37.778996214713004 -122.444879720826 (37.778996214713, -122.444879720826)
60436 112231 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 33 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999586.5486 2111947.336 37.778980055338295 -122.44501399007 (37.7789800553383, -122.44501399007)
62229 128803 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6010772.336130001 2121543.44092 37.8059607180809 -122.406994223527 (37.8059607180809, -122.406994223527)
63927 192185 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6014943.40955 2116055.80461 37.7911254818008 -122.392175419669 (37.7911254818008, -122.392175419669)
65484 176481 Undocumented 2 Fraxinus americana :: American Ash 23 751 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6009070.611819999 2092821.38895 37.727001227099294 -122.410853515679 (37.7270012270993, -122.410853515679)
65806 192195 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6014955.9111 2116194.51925 37.7915070542455 -122.39214186955799 (37.7915070542455, -122.392141869558)
70406 128801 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6010778.48493 2121493.15112 37.805822978810795 -122.40696939771601 (37.8058229788108, -122.406969397716)
73412 192184 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014951.26578 2116048.5878 37.7911061023123 -122.392147732225 (37.7911061023123, -122.392147732225)
73661 192194 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6014948.50747 2116187.8045900003 37.79148820627071 -122.39216701641199 (37.7914882062707, -122.392167016412)
74479 112233 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 35 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999535.7853 2111942.5981 37.778964148885706 -122.44518925935499 (37.7789641488857, -122.445189259355)
75233 192182 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014968.9428900005 2116029.5611400004 37.7910548409688 -122.392085238363 (37.7910548409688, -122.392085238363)
82743 93379 DPW Maintained 3 Fraxinus americana :: American Ash 23 3066 Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/08/2008 12:00:00 AM 3 3x3   5996271.089980001 2111490.88446 37.7775369752727 -122.45645040737101 (37.7775369752727, -122.456450407371)
93535 120314 Undocumented 2 Fraxinus americana :: American Ash 23 178 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5988704.36476 2114157.6050400003 37.784421732340704 -122.482821407456 (37.7844217323407, -122.482821407456)
97603 79790 Permitted Site 1 Fraxinus americana :: American Ash 23 1367 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52440 6008963.36292155 2109590.31438919 37.773038940725606 -122.41240905716002 (37.7730389407256, -122.41240905716)
109363 84273 Permitted Site 1 Fraxinus americana :: American Ash 23 3420 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/2008 12:00:00 AM   3x3 Permit Number 50589 6007432.35867316 2104438.63663813 37.7588076039256 -122.417339857257 (37.7588076039256, -122.417339857257)
121566 35778 Permitted Site 1 Fraxinus americana :: American Ash 23 3426 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51390 6007395.20860977 2104436.57542117 37.7587998540815 -122.417468193596 (37.7587998540815, -122.417468193596)
125648 61146 Permitted Site 1 Fraxinus americana :: American Ash 23 218 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/01/1983 12:00:00 AM     Permit Number 21000 5997856.78022338 2109854.41813893 37.77313456850471 -122.450846975383 (37.7731345685047, -122.450846975383)
126632 4236 DPW Maintained 3 Fraxinus americana :: American Ash 23 4015 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003796.178919099 2100385.9218973 37.7474745521244 -122.42962640666799 (37.7474745521244, -122.429626406668)
129682 128799 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6010785.19281 2121446.81831 37.8056961357319 -122.406942916281 (37.8056961357319, -122.406942916281)
130221 192196 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6014973.5029 2116205.54717 37.7915383110903 -122.39208177325199 (37.7915383110903, -122.392081773252)
131017 112212 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000031.5732 2112011.6361 37.779181996245605 -122.443479096263 (37.7791819962456, -122.443479096263)
131044 192186 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6014933.05778 2116063.9824200002 37.7911473614027 -122.392211808925 (37.7911473614027, -122.392211808925)
131502 112210 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000061.0159 2112016.0356 37.7791957551898 -122.443377558283 (37.7791957551898, -122.443377558283)
131845 218965 Undocumented 2 Fraxinus americana :: American Ash 23 110 Edgewood Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     18 Width 2ft   5996620.681480001 2106396.26972 37.7635685464754 -122.4548728666 (37.7635685464754, -122.4548728666)
135084 112226 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 28 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999690.1056 2111964.2571 37.779032426205795 -122.444656962607 (37.7790324262058, -122.444656962607)
135581 112201 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000313.4786 2112051.2315 37.779306787844604 -122.44250671611799 (37.7793067878446, -122.442506716118)
136249 112225 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 27 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999706.3499 2111966.626 37.77903985754121 -122.44460093751199 (37.7790398575412, -122.444600937512)
136269 112204 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000217.3668 2112038.0330000003 37.7792650692531 -122.44283825785 (37.7792650692531, -122.44283825785)
136544 112214 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999912.7872 2111996.4072 37.779133406627494 -122.443888930048 (37.7791334066275, -122.443888930048)
151333 143110 Undocumented 2 Fraxinus americana :: American Ash 23 566 FILBERT ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 0ft   6010230.9083 2119932.1131 37.8015060984123 -122.408754179532 (37.8015060984123, -122.408754179532)
153033 192191 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6014914.80311 2116152.19352 37.7913885550754 -122.39228114216999 (37.7913885550754, -122.39228114217)
154320 225379 Undocumented 2 Fraxinus americana :: American Ash 23 1556 15th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007034.72267 2107351.45555 37.7667831452642 -122.418921659306 (37.7667831452642, -122.418921659306)
156126 112211 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000045.7869 2112014.0051 37.7791893114958 -122.443430095603 (37.7791893114958, -122.443430095603)
156363 128805 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6010758.93625 2121613.40498 37.8061520722219 -122.407045530742 (37.8061520722219, -122.407045530742)
162218 192188 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6014909.81903 2116090.63513 37.7912192532274 -122.392294079819 (37.7912192532274, -122.392294079819)
164125 192176 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6015058.68394 2115944.87304 37.7908272891018 -122.39176881099701 (37.7908272891018, -122.391768810997)
164918 112209 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000086.7360000005 2112020.0967 37.779208372612096 -122.44328887392 (37.7792083726121, -122.44328887392)
165281 128802 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6010774.40927 2121527.84155 37.80591800208121 -122.40698594886899 (37.8059180020812, -122.406985948869)
166010 176484 Undocumented 2 Fraxinus americana :: American Ash 23 751 Burrows St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009148.6586 2092846.14487 37.72707357756379 -122.410585455665 (37.7270735775638, -122.410585455665)
166143 128807 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6010751.177730001 2121662.9336599996 37.8062876315397 -122.407075873864 (37.8062876315397, -122.407075873864)
167160 137618 Undocumented 2 Fraxinus americana :: American Ash 23 2000 TURK BLVD 37 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999494.1594 2111936.8449 37.778945976017795 -122.445332845737 (37.7789459760178, -122.445332845737)
168403 112200 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3x3   6000341.5676 2112055.2926 37.779319539633605 -122.442409836485 (37.7793195396336, -122.442409836485)
168737 112206 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000170.3262 2112030.9262 37.779242873892606 -122.443000479785 (37.7792428738926, -122.443000479785)
170321 192189 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014899.53632 2116102.22671 37.7912505100498 -122.392330469077 (37.7912505100498, -122.392330469077)
174067 128798 Undocumented 2 Fraxinus americana :: American Ash 23 1870 Kearny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6010788.13884 2121419.29471 37.8056207275841 -122.406930779942 (37.8056207275841, -122.406930779942)
174469 112234 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 36 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999518.8642 2111940.5676 37.7789576077977 -122.445247649985 (37.7789576077977, -122.445247649985)
175151 192190 Undocumented 2 Fraxinus americana :: American Ash 23 77 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6014904.23889 2116143.2831599996 37.791363502686295 -122.392317070973 (37.7913635026863, -122.392317070973)
175320 112224 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999721.5789 2111968.3181 37.7790453725975 -122.444548376071 (37.7790453725975, -122.444548376071)
176005 192177 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6015044.75368 2115956.99358 37.790859796004206 -122.39181785730499 (37.7908597960042, -122.391817857305)
176695 176483 Undocumented 2 Fraxinus americana :: American Ash 23 751 Burrows St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6009120.13043 2092835.04217 37.7270414924457 -122.410683293803 (37.7270414924457, -122.410683293803)
176847 112215 DPW Maintained 3 Fraxinus americana :: American Ash 23 2000X Turk Blvd 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5999896.5429 2111994.715 37.7791278336753 -122.443945003918 (37.7791278336753, -122.443945003918)
184277 176480 Undocumented 2 Fraxinus americana :: American Ash 23 89 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6004600.65706 2092987.51005 37.727205705053294 -122.426317902365 (37.7272057050533, -122.426317902365)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 116.367ms · Data source: data.sfgov.org