sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
119332 120526 7 3 1439 47th Ave 1 13 1 1     20 3x3   5981489.0 2105275.0 37.759610238830206 -122.50712446853998 (37.7596102388302, -122.50712446854)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
140030 103504 7 3 148 Huntington Dr 1 13 1 1           5984515.0 2095210.0 37.732152252278794 -122.49591670504999 (37.7321522522788, -122.49591670505)
99953 117254 7 3 2067 33RD AVE 1 13 1 1       3x3   5985987.0 2101171.0 37.7486056682842 -122.49126630479601 (37.7486056682842, -122.491266304796)
2595 253142 7 186 735 29th Ave 1 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
2606 253143 7 186 735 29th Ave 2 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
98644 106968 7 54 351 26th Ave   13 1 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
120579 114365 7 3 2546 28th Ave 1 13 1 1     35     5987735.7 2097954.4 37.739875761389605 -122.48498344199601 (37.7398757613896, -122.484983441996)
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
100275 96676 7 84 1701 21st Ave 1 1 1 1   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
145060 102056 7 3 332 19th Ave 1 13 1 1           5990007.7 2113121.3 37.781652074321705 -122.47823656971501 (37.7816520743217, -122.478236569715)
98218 122480 7 3 596X Buckingham Way 1 18 1 1       3x3   5990152.0 2094375.0 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616)
77987 100070 7 17 331 Serrano Dr 1 7 1 1         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807)
124150 121198 7 141 2521 18th Ave 1 5 1 1     3 3x3   5990743.0 2098231.0 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
111345 114949 7 3 1X WOODACRE DR 1 19 1 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
82732 102470 7 3 1021 Kirkham St 2 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
113649 102469 7 3 1021 Kirkham St 1 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
140844 102706 7 47 1342 Funston Ave 1 13 1 1           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645)
4447 253626 7 47 1671 Funston Ave 1 13 1 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
108742 110939 7 3 38 SAINT CHARLES AVE 1 16 1 1     30 3x3   5992046.0 2088201.0 37.7133454608488 -122.46937060641001 (37.7133454608488, -122.46937060641)
78509 102745 7 47 222 Moncada Way 1 7 1 1           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409)
114652 97162 7 235 478 10th Ave   13 1 1         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686)
104891 102101 7 141 331 Vernon St 1 1 1 1 1 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.718492301183204 -122.468164197766 (37.7184923011832, -122.468164197766)
110958 108680 7 19 240 SANTA ANA AVE 1 13 1 1           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449)
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
90230 98140 7 47 315 San Marcos Ave   7 1 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
92228 122453 7 3 217 San Marcos Ave 1 13 1 1       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
13321 187670 7 3 230 Victoria St 1 13 1 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
79534 121404 7 116 1900 08th Ave 1 13 1 1     3 10x10   5993817.0 2102486.0 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649)
99642 113379 7 250 140 CASTENADA AVE 1 7 1 1     50     5994437.0 2101097.0 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848)
144179 102639 7 3 251 Dorado Ter 1 13 1 1           5994312.1 2092840.7 37.726215661035106 -122.461874461465 (37.7262156610351, -122.461874461465)
145393 98880 7 47 101 Lansdale Ave 1 7 1 1     11     5994747.9 2097283.1 37.738438484278895 -122.460689725403 (37.7384384842789, -122.460689725403)
13296 187658 7 39 600X Clarendon Ave 1 7 1 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
2764 253207 7 47 89 Woodhaven Ct 1 16 1 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
9474 173600 7 60 500 Clarendon Ave 1 5 1 1       3x3   5996184.0 2102497.0 37.7528370823128 -122.45610127186899 (37.7528370823128, -122.456101271869)
105687 122518 7 3 772X Panorama Dr 1 16 1 1       3x3   5996713.0 2102901.0 37.753976715350106 -122.45430108189 (37.7539767153501, -122.45430108189)
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
78854 101901 7 2 1100 Ocean Ave 2 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
107366 101903 7 75 1100 Ocean Ave 4 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
110616 101905 7 75 1100 Ocean Ave 6 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
146191 101904 7 75 1100 Ocean Ave 5 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
3552 253469 7 114 701 Stanyan St 5 17 1 1           5997178.0 2108423.0 37.7691653834469 -122.45309160151399 (37.7691653834469, -122.453091601514)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
101635 121104 7 3 477 Myra Way 1 13 1 1       3x3   5997298.0 2097021.0 37.7378652095891 -122.45185385938998 (37.7378652095891, -122.45185385939)
141038 102381 7 3 258 Molimo Dr   13 1 1           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905)
100224 91109 7 17 2650 Turk Blvd 2 7 1 1       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915)
103103 91108 7 17 2650 Turk Blvd 1 7 1 1       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915)
119700 100472 7 3 70 Stanford Heights Ave   13 1 1           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729)
115179 106275 7 103 42 Stanford Heights Ave 1 13 1 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
124250 99374 7 3 21 Panorama Dr   13 1 1     24     5998009.0 2100230.0 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
1996 252848 7 164 99 Reposa Way 1 13 1 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
120804 96938 7 17 1306 Cole St   13 1 1         Backyard tree on private property 5998246.0 2105961.0 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
78510 114817 7 3 100 RACCOON DR 1 16 1 1           5998725.0 2104028.0 37.757186355085004 -122.447424250084 (37.757186355085, -122.447424250084)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
103600 98436 7 17 238 Glenview Dr   13 1 1           5999035.0 2100736.0 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
116003 114410 7 3 10 GARDENSIDE DR   1 1 1           5999306.0 2102458.0 37.752908704913395 -122.445302055175 (37.7529087049134, -122.445302055175)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
154560 110181 7 21 2620 Sutter St 1 1 1 1     11 1.5x4   5999902.8272 2114053.62 37.784781414472704 -122.444071244627 (37.7847814144727, -122.444071244627)
116035 105232 7 3 460X ROOSEVELT WAY 2 7 1 1     17     5999944.0 2106286.0 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769)
79751 105231 7 105 460X ROOSEVELT WAY 1 7 1 1     9     6000051.0 2106345.0 37.7636239504047 -122.44300483360901 (37.7636239504047, -122.443004833609)
92371 118371 7 116 4808 25th St 1 1 1 1       3x3   5999981.0 2101110.0 37.7492459313263 -122.44287099416799 (37.7492459313263, -122.442870994168)
102208 110843 7 231 2037 TURK BLVD   7 1 1     15     6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
81073 101977 7 129 601 Grand View Ave   7 1 1           6000076.2 2101609.9 37.750623962991796 -122.44257767940901 (37.7506239629918, -122.442577679409)
108324 105353 7 17 1979 SAN JOSE AVE 2 7 1 1   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552)
109200 101625 7 250 64 Levant St 1 8 1 1         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383)
98180 120995 7 64 231 Delano Ave 1 7 2 1       3x3   6000066.0 2092260.0 37.72495076112679 -122.44194193563999 (37.7249507611268, -122.44194193564)
88993 121199 7 47 72 Fountain St 1 13 1 1           6000322.0 2101283.0 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556)
81598 94690 7 329 749 Congo St   7 1 1   10/28/2010 12:00:00 AM     Permit Number 53820 6000274.0 2096023.0 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367)
91108 97177 7 17 257 Roosevelt Way   13 1 1         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.765819014897296 -122.44030407045099 (37.7658190148973, -122.440304070451)
124085 116154 7 105 324 POPE ST 1 13 1 1       3x3   6000502.0 2087202.0 37.711087470467795 -122.440072212787 (37.7110874704678, -122.440072212787)
142682 102752 7 116 2452 Green St   13 1 1           6001313.0 2117994.0 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164)
101483 113482 7 3 2839 Pierce St   13 1 1           6001345.0 2118077.0 37.7959107386074 -122.43937030854799 (37.7959107386074, -122.439370308548)
105403 105236 7 47 235X STATES ST 1 13 1 1     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
86057 94469 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
126549 94468 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
124987 98548 7 116 132 Hamerton Ave 1 7 1 1           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
95068 109091 7 316 4235 23rd St 1 1 1 1 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876002 (37.7525900037408, -122.43731782876)
146266 109076 7 18 1137 Munich St 1 1 1 1 1     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.43642021389401 (37.7106245477128, -122.436420213894)
129259 122558 7 3 1760 Diamond St 1 13 1 1     20 3x3   6001927.0 2098732.0 37.7428272563398 -122.43597156823799 (37.7428272563398, -122.435971568238)
109233 104397 7 231 350 Collingwood St 1 7 1 1           6002086.0 2103822.0 37.756812219827296 -122.43578589078301 (37.7568122198273, -122.435785890783)
117738 104008 7 3 357 Collingwood St 1 13 1 1     36     6002124.0 2103789.0 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
107936 118318 7 22 20 Norton St 1 7 1 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
90103 100046 7 17 562 28th St   7 1 1   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189)
82794 110929 7 3 445 BEACON ST   13 1 1       3x3   6002243.0 2098437.0 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
Powered by Datasette · Query took 3.537ms · Data source: data.sfgov.org