sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
62 239043 2 9 10 12th St 2 1 1 1     13 Width 3ft   6006946.59098 2109912.5632700003 37.773810376676295 -122.41940820332898 (37.7738103766763, -122.419408203329)
257 251260 2 9 1163 South Van Ness Ave 3 1 1 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
624 70356 2 9 1912 Polk St 1 1 1 1 1 05/07/1994 12:00:00 AM 5     6006535.5562 2117410.9094 37.7943758388735 -122.42136264060801 (37.7943758388735, -122.421362640608)
998 106624 2 9 156 Commonwealth Ave 3 1 1 1     9 3x6 Permit Number 778450 5996579.9247 2113340.3647 37.78263288517989 -122.455515759177 (37.7826328851799, -122.455515759177)
1359 196907 2 9 351 Clementina St 2 1 1 1     2 Width 2ft   6011780.0 2112595.0 37.7814467742932 -122.40287726647301 (37.7814467742932, -122.402877266473)
1427 196746 2 9 1201x 08th St 2 1 1 1     2 Width 3ft   6012720.73761 2107120.44123 37.7664673626982 -122.399238333493 (37.7664673626982, -122.399238333493)
1541 196583 2 9 375 07th St 5 4 1 1     7 Width 3ft   6010636.210390001 2110621.8756 37.7759651028325 -122.406695151275 (37.7759651028325, -122.406695151275)
1554 196582 2 9 375 07th St 4 4 1 1     8 Width 3ft   6010641.65206 2110616.23142 37.7759499096844 -122.40667592917801 (37.7759499096844, -122.406675929178)
2092 196948 2 9 3536 Jennings St 4 2 1 1     3 Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
3254 244746 2 9 98 12th St 1 2 1 1     15 Width 3ft   6007069.86029 2109755.10428 37.7733849739584 -122.418970623803 (37.7733849739584, -122.418970623803)
3710 240036 2 9 4121 18th St 2 1 1 1     13 Width 3ft   6002205.0 2105251.0 37.7607426677704 -122.435476567852 (37.7607426677704, -122.435476567852)
3897 253589 2 9 365x 06th St 2 1 1 1       Width 3ft   6011360.0 2111196.0 37.7775819849571 -122.404231777509 (37.7775819849571, -122.404231777509)
3905 196577 2 9 365x 06th St 1 1 1 1     5 Width 3ft   6011360.0 2111196.0 37.7775819849571 -122.404231777509 (37.7775819849571, -122.404231777509)
3984 102394 2 9 30X Harriet St 7 1 1 1     3 3x3   6010499.119030001 2111685.94424 37.778879115810795 -122.407244414896 (37.7788791158108, -122.407244414896)
3998 159324 2 9 516 Ellington Ave 1 1 1 1   10/05/2017 10:39:00 AM 3 Width 0ft   5998061.98233 2087178.88925 37.710884802276205 -122.44850380581998 (37.7108848022762, -122.44850380582)
4015 159294 2 9 118 Whipple Ave 1 1 1 1   10/05/2017 02:12:00 PM 3 Width 0ft   5998151.37307 2087303.3135799998 37.7112315538724 -122.44820380548799 (37.7112315538724, -122.448203805488)
4025 159222 2 9 384 Ellington Ave 1 1 1 1   10/05/2017 09:28:00 AM 3 Width 0ft   5998624.92984 2087716.64467 37.712393528324206 -122.446596800611 (37.7123935283242, -122.446596800611)
4042 179821 2 9 364 Ellington Ave 1 1 1 1   10/05/2017 10:07:00 AM 3 Width 2ft   5998698.94465 2087786.79601 37.712590375508796 -122.446346027354 (37.7125903755088, -122.446346027354)
4052 102393 2 9 30X Harriet St 6 1 1 1     3 3x3   6010484.4318 2111700.90158 37.7789193631694 -122.407296278794 (37.7789193631694, -122.407296278794)
4087 159329 2 9 556 Ellington Ave 1 1 1 1   10/05/2017 11:09:00 AM 3 Width 0ft   5997921.94288 2087046.44589 37.7105131349458 -122.448978278232 (37.7105131349458, -122.448978278232)
4104 159219 2 9 366 Ellington Ave 1 1 1 1   10/05/2017 09:32:00 AM 3 Width 0ft   5998673.37335 2087760.7240000002 37.7125173271842 -122.446432534932 (37.7125173271842, -122.446432534932)
4119 159216 2 9 326 Ellington Ave 1 1 1 1   10/05/2017 10:09:00 AM 3 Width 0ft   5998830.44796 2087909.1779599998 37.712933918350394 -122.445900308946 (37.7129339183504, -122.445900308946)
4129 216706 2 9 231 Faxon Ave 1 2 1 1   10/06/2017 08:40:00 AM 3 Width 3ft   5994712.86869 2090137.86358 37.718817384787606 -122.460293291921 (37.7188173847876, -122.460293291921)
4175 244050 2 9 400 Cole St 4 1 1 1     11 Width 0ft   5997945.2406 2109187.6851 37.771308954489 -122.45049290616699 (37.771308954489, -122.450492906167)
4230 244048 2 9 400 Cole St 3 1 1 1     12 Width 0ft   5997950.1933 2109141.0477 37.771181183618395 -122.45047241196801 (37.7711811836184, -122.450472411968)
4233 244049 2 9 400 Cole St 2 1 1 1     11 Width 0ft   5997947.3042 2109165.8109 37.7712490116574 -122.450484190924 (37.7712490116574, -122.450484190924)
4717 240016 2 9 6 Ford St 1 1 1 1     11 6x6   6003449.63845 2105676.77669 37.7619823582336 -122.431202314632 (37.7619823582336, -122.431202314632)
5177 213769 2 9 901 Chenery St 1 1 1 1     1 Width 3ft   6001465.0 2095917.0 37.735071666753 -122.437367503603 (37.735071666753, -122.437367503603)
5608 106622 2 9 156 Commonwealth Ave 1 1 1 1     9 3x6 Permit Number 778450 5996579.2478 2113322.09 37.78258266885771 -122.455516779687 (37.7825826688577, -122.455516779687)
8313 110973 2 9 2231 Fillmore St 1 1 1 1     6 3x3   6002796.68152 2115999.3322 37.7902885034734 -122.434198615596 (37.7902885034734, -122.434198615596)
13402 98185 2 9 1166 Howard St 4 1 1 1     3 3x3   6009313.61515 2110882.15559 37.7766056827446 -122.41128876238001 (37.7766056827446, -122.41128876238)
13850 98187 2 9 1166 Howard St 6 1 1 1   10/28/2016 12:00:00 AM 3 3x3 Permit Number 777050 6009249.68117 2110819.91866 37.7764312088743 -122.41150553135598 (37.7764312088743, -122.411505531356)
13897 83463 2 9 1011 Howard St 1 1 1 1 1 10/14/2006 12:00:00 AM 6 3x3   6010416.80991 2111846.95811 37.77931661531171 -122.407540511299 (37.7793166153117, -122.407540511299)
14105 102389 2 9 90X Harriet St 2 1 1 1     3 3x3   6010750.24129 2111421.87021 37.7781680812419 -122.406357067338 (37.7781680812419, -122.406357067338)
14719 98186 2 9 1166 Howard St 5 1 1 1     3 3x3   6009297.66811 2110865.56699 37.7765592399587 -122.411342755875 (37.7765592399587, -122.411342755875)
14965 95845 2 9 148 06th St 1 1 1 1     3 4x4   6010292.7909 2112199.1337200003 37.780276664085704 -122.40799438924999 (37.7802766640857, -122.40799438925)
15407 101368 2 9 555 Minna St 1 1 1 1   10/17/2012 12:00:00 AM 1 3x5 Permit Number 769424 6009870.786169999 2111925.3371200003 37.77950124702579 -122.40943497635901 (37.7795012470258, -122.409434976359)
15412 117198 2 9 78 Ringold St 1 1 1 1     11 2.5x2.5   6009460.131469999 2109802.88553 37.773650476322295 -122.410705680637 (37.7736504763223, -122.410705680637)
15430 98183 2 9 1166 Howard St 2 1 1 1     3 3x3   6009361.09189 2110925.30032 37.7767268106175 -122.411127574195 (37.7767268106175, -122.411127574195)
15862 114993 2 9 96X Tehama St 2 1 1 1     2 3x3   6013204.76311 2114263.56563 37.78610772254971 -122.398065333368 (37.7861077225497, -122.398065333368)
16153 98184 2 9 1166 Howard St 3 1 1 1   10/28/2016 12:00:00 AM 3 3x3 Permit Number 777050 6009341.871809999 2110905.80719 37.7766722091935 -122.41119268511001 (37.7766722091935, -122.41119268511)
16373 114992 2 9 96X Tehama St 1 1 1 1     2 3x3   6013259.23301 2114318.42588 37.786261389694296 -122.397880730433 (37.7862613896943, -122.397880730433)
16459 102415 2 9 286 06th St 2 1 1 1     3 3x3   6010900.79062 2111559.68279 37.7785549030328 -122.405845970014 (37.7785549030328, -122.405845970014)
19681 100150 2 9 4007 18th St 1 1 1 1     3 3x3   6002942.0 2105314.0 37.7609574805046 -122.432932117926 (37.7609574805046, -122.432932117926)
22848 196744 2 9 70 Gilbert St 1 1 1 1     12 Width 2ft   6011668.77571 2109790.69 37.773740575795 -122.40306474017099 (37.773740575795, -122.403064740171)
23404 240048 2 9 43 Caselli Ave 1 1 1 1     14 Width 3ft   6000857.65959 2104899.8955900003 37.7597020075671 -122.440111226348 (37.7597020075671, -122.440111226348)
23524 196682 2 9 5 Bryant St 1 1 1 1     3 Width 4ft   6015696.3573900005 2114271.42038 37.786267747913996 -122.389445555473 (37.786267747914, -122.389445555473)
23595 136131 2 9 198 Hemlock St 4 1 1 1     3 Width 4ft   6006507.20289 2114786.55408 37.78716841265071 -122.42127429839701 (37.7871684126507, -122.421274298397)
23728 240105 2 9 8 Landers St 4 1 1 1     3 Width 3ft   6004445.22444 2107657.1066799997 37.767476238364395 -122.427900086823 (37.7674762383644, -122.427900086823)
23866 213780 2 9 401 Detroit St 1 1 1 1     14 Width 3ft   5999412.8800099995 2094425.91408 37.730860618202 -122.444355271001 (37.730860618202, -122.444355271001)
23900 136080 2 9 2451 Steiner St 12 1 1 1     5 Width 5ft   6002277.07488 2116237.64468 37.7909133434315 -122.43601347444799 (37.7909133434315, -122.436013474448)
23964 239744 2 9 568 Clipper St 2 1 1 1     9 Width 4ft   6001504.60892 2100890.93751 37.7487311832969 -122.437586652201 (37.7487311832969, -122.437586652201)
24120 179207 2 9 1750 Sunnydale Ave 2 9 1 1     10 Width 10ft   6006573.63704 2087691.58982 37.7127755684169 -122.41912182232402 (37.7127755684169, -122.419121822324)
24294 240116 2 9 68 Mars St 1 1 1 1     10 Width 3ft   5999571.42153 2105391.81538 37.760979387506 -122.444595026656 (37.760979387506, -122.444595026656)
24327 136155 2 9 774 Francisco St 3 1 1 1     11 Width 4ft   6007553.7315 2120957.34522 37.8041708145069 -122.418091165079 (37.8041708145069, -122.418091165079)
24387 196870 2 9 472 Clementina St 1 1 1 1     1 Width 3ft   6010925.85315 2111832.37951 37.779305066206604 -122.405778482215 (37.7793050662066, -122.405778482215)
24390 183485 2 9 1200 Vicente St 1 1 1 1     4 Width 0ft   5988896.6651 2097669.2164 37.7391602759822 -122.480948482471 (37.7391602759822, -122.480948482471)
24463 238876 2 9 1491 South Van Ness Ave 1 1 1 1     5 Width 2ft   6007784.85752 2101047.0876700003 37.7495150081106 -122.415880587419 (37.7495150081106, -122.415880587419)
24506 213803 2 9 216 Byxbee St 3 4 1 1     4 Width 2ft   5991962.814730001 2089977.4457200002 37.7182183418945 -122.469787374494 (37.7182183418945, -122.469787374494)
24722 238913 2 9 1068 South Van Ness Ave 1 1 1 1     1 Width 3ft   6007587.824440001 2103414.46405 37.7560042066578 -122.41672962747299 (37.7560042066578, -122.416729627473)
24781 239789 2 9 231 Chenery St 1 1 1 1     8 Width 3ft   6004717.296 2096978.74622 37.738171339340205 -122.42619871072901 (37.7381713393402, -122.426198710729)
24820 244313 2 9 355 Octavia St 1 1 1 1     2 Width 0ft   6005485.8375 2110599.8191 37.77561503254971 -122.424510084491 (37.7756150325497, -122.424510084491)
24824 136161 2 9 201 Filbert St 3 1 1 1     8 Width 3ft   6011844.59181 2120106.54793 37.8020753041917 -122.40318235259399 (37.8020753041917, -122.403182352594)
24877 239855 2 9 130 Coso Ave 1 1 1 1     4 Width 3ft   6007274.472630001 2099692.72245 37.745767519658706 -122.41754954119301 (37.7457675196587, -122.417549541193)
24905 196689 2 9 502 Beale St 1 1 1 1     11 Width 6ft   6015659.73754 2114184.09825 37.7860259507775 -122.38956615096701 (37.7860259507775, -122.389566150967)
24909 196684 2 9 5 Bryant St 3 1 1 1     5 Width 4ft   6015730.46543 2114303.5098599996 37.7863577493517 -122.389329791131 (37.7863577493517, -122.389329791131)
24924 196625 2 9 147 Minna St 3 1 1 1     2 Width 3ft   6012482.23546 2114419.12647 37.7864945874895 -122.400576033651 (37.7864945874895, -122.400576033651)
24996 196826 2 9 100 Merrimac St 6 1 1 1     2 Width 5ft   6014562.70735 2108760.4377599997 37.7710729141165 -122.392981999126 (37.7710729141165, -122.392981999126)
25140 239844 2 9 145 Kingston St 1 1 1 1     13 Width 3ft   6006073.52024 2098158.83629 37.741488165849105 -122.42159334545099 (37.7414881658491, -122.421593345451)
25203 196859 2 9 434 Clementina St 1 1 1 1     1 Width 3ft   6011421.85676 2112297.76071 37.7806106201269 -122.404095350623 (37.7806106201269, -122.404095350623)
25349 196709 2 9 50 Colin P Kelly Jr St 5 1 1 1     7 Width 3ft   6015487.2146 2112506.03774 37.7814088089166 -122.390045771117 (37.7814088089166, -122.390045771117)
25514 239832 2 9 76 Nebraska St 1 1 1 1     3 Width 3ft   6009261.2334 2097625.2894200003 37.740202393439205 -122.41053361693301 (37.7402023934392, -122.410533616933)
25714 196574 2 9 282 Shipley St 2 1 1 1     4 Width 5ft   6011149.22911 2111419.33677 37.7781834362492 -122.404976637663 (37.7781834362492, -122.404976637663)
25835 238959 2 9 1111 Florida St 1 1 1 1     8 Width 4ft   6009480.56073 2102670.61993 37.7540680517192 -122.41013137718299 (37.7540680517192, -122.410131377183)
26059 239748 2 9 25 Homestead St 1 1 1 1     10 Width 3ft   6000981.99156 2101546.28179 37.7505008737212 -122.439440825843 (37.7505008737212, -122.439440825843)
26072 136103 2 9 2670 Pierce St 2 1 1 1     4 Width 4ft   6001647.44385 2117615.48557 37.794660747350605 -122.43829071794701 (37.7946607473506, -122.438290717947)
26179 179193 2 9 170 Brookdale Ave 7 9 1 1     3 Width 6ft   6005644.83636 2087196.5165400002 37.7113638531203 -122.422296907583 (37.7113638531203, -122.422296907583)
26217 200688 2 9 4705 03rd St 4 1 1 1     4 Width 0ft   6015005.5461 2095633.7106 37.7350542941254 -122.39053280741999 (37.7350542941254, -122.39053280742)
26344 196782 2 9 209 Channel 3 1 1 1     3 Width 5ft   6014472.23828 2109430.12451 37.7729066992149 -122.393341808879 (37.7729066992149, -122.393341808879)
26475 196593 2 9 966 Natoma St 1 4 1 1     3 Width 3ft   6007961.50634 2109867.3377900003 37.7737433088451 -122.41589423462798 (37.7737433088451, -122.415894234628)
26559 245949 2 9 751 Cole St 2 1 1 1     6 Width 0ft   5997948.2269 2107812.3026 37.767532676646205 -122.450383412512 (37.7675326766462, -122.450383412512)
26612 239801 2 9 455 Chenery St 1 1 1 1     11 Width 2ft   6003719.083459999 2096178.0797599999 37.735916419701205 -122.42959294547701 (37.7359164197012, -122.429592945477)
26779 196645 2 9 46 Tehama St 1 1 1 1     9 Width 3ft   6013699.06436 2114734.2176200002 37.787427542398504 -122.396388171474 (37.7874275423985, -122.396388171474)
26821 196616 2 9 761 Mission St 4 1 1 1     16 Width 4ft   6011860.50981 2114097.56816 37.785576970551 -122.402704440271 (37.785576970551, -122.402704440271)
26831 248160 2 9 201 Rutledge St 3 1 1 1     11 Width 3ft   6010158.71072 2099550.9487099997 37.7455401098893 -122.407566222029 (37.7455401098893, -122.407566222029)
26852 196627 2 9 147 Natoma St 1 1 1 1     1 Width 4ft   6012623.58096 2114312.81429 37.7862105609171 -122.40007954136401 (37.7862105609171, -122.400079541364)
26857 239819 2 9 601 Moultrie St 2 1 1 1     13 Width 3ft   6007679.66756 2096504.8408400002 37.7370370945787 -122.41592272607001 (37.7370370945787, -122.41592272607)
26875 179199 2 9 65 Blythdale Ave 1 9 1 1     8 Width 6ft   6006710.21835 2086918.77417 37.710661269476 -122.41859498419 (37.710661269476, -122.41859498419)
26907 179220 2 9 1851 Sunnydale Ave 2 9 1 1     9 Width 10ft   6006068.28025 2087832.3093700001 37.7131334823856 -122.420878485149 (37.7131334823856, -122.420878485149)
27052 136144 2 9 240 Linden St 2 1 1 1     4 Width 4ft   6006227.72635 2110929.7096 37.7765627005485 -122.421967145061 (37.7765627005485, -122.421967145061)
27057 238975 2 9 181 Bartlett St 1 1 1 1     14 Width 4ft   6006722.09906 2102742.62319 37.7541107560263 -122.419675932416 (37.7541107560263, -122.419675932416)
27112 196886 2 9 433 Clementina St 11 1 1 1     1 Width 3ft   6011428.028580001 2112266.0356400004 37.780523855317 -122.404071765908 (37.780523855317, -122.404071765908)
27155 239752 2 9 845 Diamond St 1 1 1 1     9 Width 4ft   6001933.47511 2101528.47832 37.7505060933955 -122.43614925500201 (37.7505060933955, -122.436149255002)
27227 196669 2 9 68 Clementina St 5 1 1 1     3 Width 3ft   6013576.19768 2114348.87912 37.786362654248 -122.396786242904 (37.786362654248, -122.396786242904)
27232 240094 2 9 2 Beaver St 3 1 1 1     10 Width 3ft   6002810.74137 2106823.9514 37.765095995496395 -122.43349399227101 (37.7650959954964, -122.433493992271)
27260 239993 2 9 3945 25th St 1 1 1 1     9 Width 3ft   6004204.66413 2101286.73756 37.749971103789896 -122.428278082666 (37.7499711037899, -122.428278082666)
27372 196638 2 9 11 Shaw Aly 1 1 1 1     2 Width 3ft   6013210.02974 2115178.55923 37.7886203752705 -122.398111327376 (37.7886203752705, -122.398111327376)
27450 196678 2 9 501 Beale St 2 1 1 1     6 Width 6ft   6015773.95432 2114161.0463099997 37.7859689877116 -122.389169378158 (37.7859689877116, -122.389169378158)
27467 238993 2 9 365 San Jose Ave 2 1 1 1     8 Width 3ft   6006229.76943 2101018.50023 37.7493489644829 -122.421256107802 (37.7493489644829, -122.421256107802)
27510 141443 2 9 2942 TURK BLVD 2 1 1 1     9 Width 0ft   5996978.8034 2111585.4647 37.7778372719661 -122.454009036016 (37.7778372719661, -122.454009036016)
Powered by Datasette · Query took 11.612ms · Data source: data.sfgov.org