sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1659 251643 2 17 2701 Leavenworth St 1 1 1 1 1     3x3   6007328.0 2121670.0 37.8061148757045 -122.418922903139 (37.8061148757045, -122.418922903139)
1846 251738 1 108 859 Prague St 14 1 1 1 1         6002345.06488 2087027.78932 37.7107138789231 -122.433689697349 (37.7107138789231, -122.433689697349)
3387 161273 2 66 566 Naples St 1 1 1 1 1   0 Width 0ft   6002889.180369999 2090346.5289900003 37.719857269085104 -122.432045948864 (37.7198572690851, -122.432045948864)
3455 160606 2 207 745 Vienna St 1 1 1 1 1   0 Width 0ft   6002538.27018 2089198.0058799998 37.716683778298 -122.43317690119301 (37.716683778298, -122.433176901193)
3759 253555 1 71 27 Ceres St 1 7 1 1 1         6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
4844 253688 1 37 999 Natoma St 3 1 1 1 1         6007970.79373767 2109754.69864739 37.7734345505501 -122.415854130267 (37.7734345505501, -122.415854130267)
5176 253818 2 3 219 Concord St 2 1 1 1 1         5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
5256 253838 2 141 1458 46th Ave 1 1 1 1 1     5.5x4   5981900.0 2105162.0 37.759324170949604 -122.505694672765 (37.7593241709496, -122.505694672765)
5969 111118 1 2 2185 Hayes St 3 1 1 1 1   10     5997454.0334 2109847.6499 37.7730929211041 -122.45223963309401 (37.7730929211041, -122.452239633094)
6158 111117 1 2 2185 Hayes St 2 1 1 1 1   12     5997427.9716 2109844.5838 37.7730830093731 -122.452329562425 (37.7730830093731, -122.452329562425)
7270 98268 1 37 401X Esmeralda Ave 1 1 1 1 1     3x3            
9563 108596 1 51 36 Bronte St   1 1 1 1   1 3x3 Permit Number 770949 6009339.44395 2097251.26276 37.7391797819084 -122.410236794344 (37.7391797819084, -122.410236794344)
9827 173704 1 11 99x Majestic Ave 2 1 1 1 1     3x3   5997184.0 2089426.0 37.7170046100656 -122.451700294591 (37.7170046100656, -122.451700294591)
9954 173752 1 15 1291 05th Ave 2 1 1 1 1     3x3   5994529.13136199 2106735.38069373 37.7643794565111 -122.46213141846201 (37.7643794565111, -122.462131418462)
9956 173750 1 11 989 South Van Ness Ave 2 1 1 1 1         6007621.28893018 2103912.36255672 37.7573732040434 -122.41664916584601 (37.7573732040434, -122.416649165846)
10027 122385 2 17 1642 17th Ave 1 1 1 1 1     3x3 Permit Number 778904 5990935.0 2104213.0 37.7572460781285 -122.474378311379 (37.7572460781285, -122.474378311379)
10035 173805 1 64 221 Stillings Ave 2 1 1 1 1         5999380.73268965 2095746.24622826 37.7344841059817 -122.444561268208 (37.7344841059817, -122.444561268208)
10860 104506 2 88 631 France Ave 1 1 1 1 1   3 3x3   6002582.75614 2089515.1433 37.7175570910528 -122.43304578096 (37.7175570910528, -122.43304578096)
11636 92966 1 2 2186 47th Ave 2 1 1 1 1   5     5981735.5599 2100228.0428 37.7457672370442 -122.505897577684 (37.7457672370442, -122.505897577684)
13187 106199 2 12 2107 42nd Ave 1 1 1 1 1   4 3x4   5983225.8003 2100763.9337 37.74732624942661 -122.500784246807 (37.7473262494266, -122.500784246807)
13344 187697 1 68 1256 Treat Ave 2 1 1 1 1         6008667.10840058 2101226.16540452 37.7500562758063 -122.41284238591601 (37.7500562758063, -122.412842385916)
13559 106005 2 51 59 Reddy St 1 1 1 1 1   3 3x3   6013632.51665 2093922.487 37.7302793593954 -122.395160068985 (37.7302793593954, -122.395160068985)
13782 121585 2 21 424 Texas St 1 1 1 1 1   1 3x3   6013758.73818 2105099.18568 37.760975233543 -122.395506429391 (37.760975233543, -122.395506429391)
15030 101775 1 51 1700 Yosemite Ave 2 1 1 1 1   10 3x3 Permit Number 19103 6014052.75296 2093112.8912 37.728079734566606 -122.393650601914 (37.7280797345666, -122.393650601914)
16234 96620 1 295 525 Phelps St 2 5 1 1 1   15 5x15 Permit Number 48345 6015380.46656 2098080.19885 37.741792643019096 -122.38940735498801 (37.7417926430191, -122.389407354988)
19027 97174 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19276 108963 2 94 2395x 15TH ST 3 1 1 1 1         6001858.0 2107008.0 37.7655472468341 -122.436802461881 (37.7655472468341, -122.436802461881)
20943 6386 2 21 205 Elsie St 1 1 1 1 1   3 3x3   6006831.93965 2097911.00568 37.7408504143285 -122.418953412568 (37.7408504143285, -122.418953412568)
22409 249318 1 135 198X Prospect Ave 1 1 1 1 1     3x3            
23887 83255 2 18 790 41st Ave 1 1 1 1 1   1     5983253.61867 2110435.38712 37.773882958787205 -122.501403365431 (37.7738829587872, -122.501403365431)
26077 98248 2 11 650 Eddy St 3 1 1 1 1   5 3x3 I believe these were planted in 2010 by FUF. C.Buck 6007281.495490001 2113344.84788 37.7832534614285 -122.41849313956001 (37.7832534614285, -122.41849313956)
27331 117477 1 12 1999X Vallejo St 4 1 1 1 1   14   Permit Number 778454 6004121.651819999 2117991.3278099997 37.7958331278375 -122.429756453008 (37.7958331278375, -122.429756453008)
27427 109082 2 108 360 09th Ave 7 1 1 1 1   5     5993123.846940001 2113007.94423 37.7815212258156 -122.46744802506399 (37.7815212258156, -122.467448025064)
28065 84526 2 37 1607 35th Ave 1 1 1 1 1   2     5985279.5041 2104240.0581 37.756991093889496 -122.49393892942699 (37.7569910938895, -122.493938929427)
28159 116806 1 32 1300 Cabrillo St 3 1 1 1 1   14     5991537.4363400005 2110683.08947 37.7750460962456 -122.472766623766 (37.7750460962456, -122.472766623766)
28970 84365 2 22 129 Escolta Way 1 1 1 1 1   5     5986616.9958 2097211.3869 37.7377704195158 -122.488796798517 (37.7377704195158, -122.488796798517)
30447 114559 1 2 1551 32nd Ave 2 1 1 1 1   6 5x6   5986195.2764 2104674.6971 37.7582380320911 -122.490803866981 (37.7582380320911, -122.490803866981)
30893 81813 2 12 1419 24th Ave 1 1 1 1 1   5     5988645.6741 2105641.5626 37.7610356250119 -122.482400266833 (37.7610356250119, -122.482400266833)
31787 121581 2 52 199X Texas St 1 1 1 1 1   2 3x3   6013754.46885 2106222.8302700003 37.764060277784 -122.395599922908 (37.764060277784, -122.395599922908)
32214 121078 1 11 726 Polk St 2 1 1 1 1   5 4x4   6007074.608519999 2113528.41761 37.7837458501408 -122.419221913271 (37.7837458501408, -122.419221913271)
33883 110043 1 90 890 Rhode Island St 2 1 1 1 1   9     6011841.59848 2104237.14125 37.7585014297196 -122.402076412192 (37.7585014297196, -122.402076412192)
34385 109079 2 108 360 09th Ave 4 1 1 1 1   8     5993122.1097099995 2113067.45423 37.7816845237935 -122.46745836376999 (37.7816845237935, -122.46745836377)
36317 108395 1 41 311 Ordway St 1 5 1 1 1   2 3x3   6011028.372719999 2090050.89786 37.7195036115824 -122.403890660433 (37.7195036115824, -122.403890660433)
36445 106365 2 13 1970 47th Ave 1 1 1 1 1   1 4x2   5981684.7966 2101671.2426 37.7497268716349 -122.506180099858 (37.7497268716349, -122.506180099858)
38343 122390 2 88 1958 17th Ave 1 1 1 1 1     3x2   5991007.0 2102078.0 37.7513881006776 -122.47397354599501 (37.7513881006776, -122.473973545995)
39790 79264 2 30 180 19th Ave 1 1 1 1 1   1     5989943.75827 2114181.74363 37.7845600440954 -122.47853534669399 (37.7845600440954, -122.478535346694)
39825 83498 2 12 1840 29th Ave 1 1 1 1 1   4     5987237.7366 2102721.865 37.752936928713495 -122.48705521280199 (37.7529369287135, -122.487055212802)
41039 110469 1 59 465 Grove St 5 1 1 1 1   15 3x3   6005632.4002 2111334.52 37.777640618295706 -122.42405534708901 (37.7776406182957, -122.424055347089)
41359 80821 2 12 843 24th Ave 1 1 1 1 1   7     5988489.67822 2110248.9611400003 37.7736771996736 -122.48327752702299 (37.7736771996736, -122.483277527023)
41932 114086 1 7 20 Cook St 7 1 1 1 1   12     5997489.0948 2113600.1035 37.783398187645 -122.45238918542401 (37.783398187645, -122.452389185424)
43230 81651 2 73 1100@ 12th Ave Cabrillo St 1 1 1 1 1   6   Permit Number 767881 5992197.33713 2110704.35062 37.7751426520596 -122.470485452724 (37.7751426520596, -122.470485452724)
43730 110480 1 44 573 Scott St 2 1 1 1 1   4     6002112.3456 2110445.7265 37.7750008457371 -122.436168770849 (37.7750008457371, -122.436168770849)
44768 121639 1 18 195 Otsego Ave 2 1 1 1 1   14     6000575.25086 2092201.75917 37.7248198513454 -122.440177342728 (37.7248198513454, -122.440177342728)
46325 82058 2 35 2663 24th Ave 1 1 1 1 1   3     5988935.079 2097218.8486 37.737925915904896 -122.480782703185 (37.7379259159049, -122.480782703185)
46752 121094 1 82 1697 McAllister St 2 1 1 1 1   4 3x3   6001082.7006 2111393.2018 37.777543821113206 -122.43979847194099 (37.7775438211132, -122.439798471941)
46823 114049 2 95 1190 Shafter Ave 2 1 1 1 1   2 3x3   6017122.5886 2092569.8305 37.7267587013694 -122.38300019404801 (37.7267587013694, -122.383000194048)
47382 84587 2 2 2374 47th Ave 1 1 1 1 1   2     5981781.9237 2098926.9802 37.7421976095989 -122.50564083146999 (37.7421976095989, -122.50564083147)
48882 111292 1 16 291 14th Ave 2 1 1 1 1   4     5991505.832330001 2113494.12901 37.78276261074429 -122.47308099011002 (37.7827626107443, -122.47308099011)
49381 109083 2 108 360 09th Ave 8 1 1 1 1   9     5993121.9003800005 2112970.33483 37.7814178482518 -122.46745202346001 (37.7814178482518, -122.46745202346)
50399 83940 2 37 346 Lisbon St 1 1 1 1 1   5     6002623.3428 2091444.05642 37.722855759877895 -122.43304322866999 (37.7228557598779, -122.43304322867)
51321 115599 1 15 699 02nd St 6 1 1 1 1     3x3   6015347.857021701 2112248.60687265 37.7806942317989 -122.390509891446 (37.7806942317989, -122.390509891446)
53655 112501 1 11 801 Clement St 2 1 1 1 1   4 2x2   5993015.96784 2113442.43109 37.782707979643504 -122.467852842771 (37.7827079796435, -122.467852842771)
54494 83988 2 37 51 Prague St 1 1 1 1 1   3     6004863.63581 2090857.16015 37.7213710933771 -122.425257258112 (37.7213710933771, -122.425257258112)
55462 113717 1 42 1342 Cabrillo St 2 1 1 1 1   12     5991400.52029 2110673.00421 37.775010478076794 -122.47323950591299 (37.7750104780768, -122.473239505913)
56054 114089 1 12 20 Cook St 10 1 1 1 1   4     5997479.2806 2113658.9889 37.78355930916071 -122.452427389255 (37.7835593091607, -122.452427389255)
57301 83542 2 1 875 La Playa 1 1 1 1 1   19     5980747.696719999 2109761.67142 37.7718856460039 -122.51002154176399 (37.7718856460039, -122.510021541764)
57867 79130 2 12 1293 28th Ave 1 1 1 1 1   4     5987372.1815 2106509.2764 37.763343966061896 -122.486868390866 (37.7633439660619, -122.486868390866)
58276 122823 1 79 1736 Stockton St 3 1 1 1 1   7 4x4   6010043.2132 2120098.5684 37.8019526289989 -122.409415446027 (37.8019526289989, -122.409415446027)
58748 121640 1 18 195 Otsego Ave 3 1 1 1 1   17     6000583.2387 2092221.3848599999 37.724874193767796 -122.440151136477 (37.7248741937678, -122.440151136477)
58950 121048 1 5 2652 Polk St 2 1 1 1 1         6006192.78395747 2119877.54417008 37.80112926306921 -122.422724050002 (37.8011292630692, -122.422724050002)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
59233 108371 1 48 575 Paris St 1 1 1 1 1   1 3x3   6001620.80772 2090281.19611 37.719605888781295 -122.43642558878 (37.7196058887813, -122.43642558878)
59442 80399 2 37 1359 35th Ave 1 1 1 1 1   4     5985221.9445 2105957.3134 37.7617028317997 -122.494264562885 (37.7617028317997, -122.494264562885)
59855 82988 2 21 1345 Howard St 1 1 1 1 1   3     6008577.18796 2110086.84492 37.7743806179076 -122.41378001753701 (37.7743806179076, -122.413780017537)
59973 82021 2 12 1550 28th Ave 1 1 1 1 1   5     5987476.0557 2104733.3067 37.75847369503 -122.48637873374099 (37.75847369503, -122.486378733741)
61145 95563 1 88 497 Elizabeth St 1 1 1 1 1     3x3   6003239.0 2102086.6 37.75211264995529 -122.43167449646799 (37.7521126499553, -122.431674496468)
61360 83419 2 35 2379 24th Ave 1 1 1 1 1   1     5988867.9747 2099162.5294 37.7432588555713 -122.48115699763201 (37.7432588555713, -122.481156997632)
62195 84689 2 19 3632 Fillmore St 1 1 1 1 1   3     6002195.05393 2120739.39081 37.80326930438871 -122.436619630107 (37.8032693043887, -122.436619630107)
63984 121080 1 11 726 Polk St 4 1 1 1 1   15     6007066.4684 2113565.1138400002 37.78384615061189 -122.419252679062 (37.7838461506119, -122.419252679062)
64744 114084 1 7 20 Cook St 5 1 1 1 1   17     5997493.8327 2113562.2002 37.783294386609796 -122.452370058209 (37.7832943866098, -122.452370058209)
65198 82609 2 22 343 17th Ave 1 1 1 1 1   7     5990560.55724 2113091.75493 37.7816030289127 -122.476321807103 (37.7816030289127, -122.476321807103)
65671 78959 2 37 2083 28th Ave 1 1 1 1 1   1     5987558.9086 2101118.3339 37.748552784681 -122.485826868551 (37.748552784681, -122.485826868551)
66019 111476 1 17 2x TRAINOR ST 2 1 1 1 1     3x3   6008026.0 2108277.0 37.7693802414943 -122.41555852152901 (37.7693802414943, -122.415558521529)
66616 110470 1 59 465 Grove St 6 1 1 1 1   15 3x3   6005644.9931 2111337.1436 37.777648533038395 -122.42401197054701 (37.7776485330384, -122.424011970547)
68176 110468 1 59 465 Grove St 4 1 1 1 1   15 3x3   6005616.1343 2111331.3718 37.7776310557335 -122.42411139247 (37.7776310557335, -122.42411139247)
69699 109081 2 108 360 09th Ave 6 1 1 1 1   8     5993122.61553 2113029.97254 37.7815816384713 -122.46745388745701 (37.7815816384713, -122.467453887457)
69765 83695 2 37 2434 33rd Ave 1 1 1 1 1   2     5986135.3818 2098661.4883 37.741723893319 -122.49056860476601 (37.741723893319, -122.490568604766)
69848 81662 2 88 563 14th Ave 1 1 1 1 1   4     5991577.12734 2111607.04314 37.7775853186785 -122.472696706975 (37.7775853186785, -122.472696706975)
70462 81627 2 49 351 16th Ave 1 1 1 1 1   3     5990871.84274 2113035.63499 37.781466986417605 -122.475240820306 (37.7814669864176, -122.475240820306)
70536 83955 2 37 55 Athens St 1 1 1 1 1   4     6005194.32236 2092948.4396799998 37.7271319660671 -122.42426282649099 (37.7271319660671, -122.424262826491)
71159 84446 2 46 901 Baker St 1 1 1 1 1   6     6000457.5617 2112125.7689 37.77951966026271 -122.442013625663 (37.7795196602627, -122.442013625663)
72482 116841 1 94 2344 15TH ST 1 1 1 1 1   24     6002015.0 2107091.0 37.7657840660528 -122.436265375372 (37.7657840660528, -122.436265375372)
72719 116386 1 15 88 Arkansas St 7 1 1 1 1   10 3x3   6012827.44648 2106665.0509 37.765222908729996 -122.398837280835 (37.76522290873, -122.398837280835)
72782 102646 1 11 650X Jones St 2 1 1 1 1   15 3x3 Permit Number 28309 6008830.0317 2114874.50645 37.7875405898706 -122.413244009 (37.7875405898706, -122.413244009)
73278 113422 1 45 1583 Shafter Ave 2 1 1 1 1   11 3x3   6015014.3399 2094064.2928 37.7307454784064 -122.390392783554 (37.7307454784064, -122.390392783554)
73309 110467 1 59 465 Grove St 3 1 1 1 1   15 3x3   6005585.7014 2111327.1742 37.7776178118347 -122.424216371681 (37.7776178118347, -122.424216371681)
74070 110466 1 59 465 Grove St 2 1 1 1 1   16 3x3   6005573.1085 2111325.0754 37.777611337989605 -122.42425978551701 (37.7776113379896, -122.424259785517)
74615 78962 2 49 2324 Francisco St 1 1 1 1 1   6     6000164.38759 2119919.6080400003 37.8009027932886 -122.443587870495 (37.8009027932886, -122.443587870495)
75438 112502 1 11 801 Clement St 3 1 1 1 1   4 2x2   5993032.4422699995 2113443.17737 37.7827109800118 -122.46779590302799 (37.7827109800118, -122.467795903028)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
76764 108377 1 88 226 Munich St 1 1 1 1 1   1 3x3 Permit Number 773810 6004631.19295 2091083.0586299999 37.7219782266077 -122.42607682199801 (37.7219782266077, -122.426076821998)
Powered by Datasette · Query took 75.037ms · Data source: data.sfgov.org