sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
63429 181539 2 116 1300 Sunset Blvd 17 9 1 1     1 Width 0ft   5984878.0833 2105873.5659 37.761452756110394 -122.4954476457 (37.7614527561104, -122.4954476457)
63967 185633 2 116 2100 Sunset Blvd 13 9 1 1     1 Width 0ft   5985076.9465 2100353.2830000003 37.7463072224732 -122.494352945117 (37.7463072224732, -122.494352945117)
64230 118443 2 116 5201 Anza St 1 2 1 1     8 Width 3ft   5982458.0361 2111659.95745 37.7771985159381 -122.504246101222 (37.7771985159381, -122.504246101222)
64361 248069 2 116 20 Rutledge St 3 17 1 1     8     6010620.265980001 2099403.1540599996 37.7451601229588 -122.405959817907 (37.7451601229588, -122.405959817907)
64455 181395 2 116 1500 Sunset Blvd 28 9 1 1     1 Width 0ft   5984933.1803 2104579.26 37.7579021787746 -122.495161642957 (37.7579021787746, -122.495161642957)
64589 186730 2 116 1300 Sunset Blvd 65 9 1 1     4 Width 0ft   5984855.0036 2106288.7736 37.7625914487693 -122.495558092973 (37.7625914487693, -122.495558092973)
65505 248066 2 116 18 Rutledge St 8 17 1 1     7     6010646.65948 2099397.14706 37.7451451051559 -122.405868130216 (37.7451451051559, -122.405868130216)
65616 247596 2 116 900 Tompkins Ave 1 9 1 1     13 Width 8ft   6009145.02453 2096408.71868 37.73685543873 -122.410849521814 (37.73685543873, -122.410849521814)
65956 185096 2 116 2801 Sunset Blvd 24 9 1 1     2 Width 0ft   5985018.6615 2095986.0271 37.7343125019956 -122.494232639372 (37.7343125019956, -122.494232639372)
65961 250201 2 116 203 Union St 2 17 1 1     29 Width 0ft   6011763.02504 2119743.5219400004 37.8010739675505 -122.40343905958099 (37.8010739675505, -122.403439059581)
66493 185214 2 116 2500 Sunset Blvd 70 9 1 1     1 Width 0ft   5985123.3973 2098105.6751 37.7401386169566 -122.494026705548 (37.7401386169566, -122.494026705548)
69472 181545 2 116 1300 Sunset Blvd 23 9 1 1     1 Width 0ft   5984885.3237 2105962.1224 37.7616963314413 -122.495429135957 (37.7616963314413, -122.495429135957)
69595 240624 2 116 5413 Diamond Heights Blvd 3 9 1 1     8     6002039.42489 2097863.5246099997 37.7404490118051 -122.4355207197 (37.7404490118051, -122.4355207197)
69856 136428 2 116 7 Kimball Pl 1 2 1 1     15 Width 0ft   6007991.83691 2116437.43612 37.791784918695 -122.41625474228901 (37.791784918695, -122.416254742289)
70268 120281 2 116 129 24th Ave 11 7 1 1     15     5988339.230269999 2115128.3543599998 37.7870658824376 -122.484155845816 (37.7870658824376, -122.484155845816)
70280 248053 2 116 19 Rutledge St 2 7 1 1     18     6010622.547590001 2099378.6850900003 37.7450930640901 -122.405950205054 (37.7450930640901, -122.405950205054)
70736 247974 2 116 346 Peralta Ave 4 9 1 1     20     6009790.92788 2099185.07173 37.7445148980554 -122.408812155357 (37.7445148980554, -122.408812155357)
70873 240602 2 116 609 28th St 3 1 1 1     4 Width 2ft   6001920.90533 2099400.25112 37.7446617708226 -122.436040449628 (37.7446617708226, -122.436040449628)
70926 186856 2 116 2700 Sunset Blvd 5 9 1 1     2 Width 0ft   5985217.4528 2096293.5766 37.735168582064794 -122.49356801735901 (37.7351685820648, -122.493568017359)
71023 240631 2 116 57 Poppy Ln 1 13 1 1     4 Width 2ft   6002629.35658 2096548.6301400003 37.7368721031581 -122.433387031387 (37.7368721031581, -122.433387031387)
71275 187306 2 116 2401 Sunset Blvd 89 9 1 1     4 Width 0ft   5984963.8587 2098228.7818 37.7404672985278 -122.494587390296 (37.7404672985278, -122.494587390296)
71910 186966 2 116 2800 Sunset Blvd 40 9 1 1     1 Width 0ft   5985198.0961 2096141.0368 37.734748616014 -122.493623703195 (37.734748616014, -122.493623703195)
72190 179498 2 116 892 Peru Ave 1 9 1 1     35     6005545.45161 2091807.84398 37.7240199601485 -122.422967943043 (37.7240199601485, -122.422967943043)
72927 120273 2 116 129 24th Ave 3 7 1 1     16     5988307.3728 2115160.02273 37.787150979882796 -122.484268387653 (37.7871509798828, -122.484268387653)
73058 186967 2 116 2800 Sunset Blvd 41 9 1 1     3 Width 0ft   5985210.5401 2096146.418 37.7347641193316 -122.493581077021 (37.7347641193316, -122.493581077021)
73308 187590 2 116 700 Goettingen St 1 7 1 1     4     6010709.76883 2091388.9815099998 37.7231599087791 -122.40508613194599 (37.7231599087791, -122.405086131946)
73560 120270 2 116 107 24th Ave 3 7 1 1     11     5988338.64874 2115186.1535400003 37.7872245486486 -122.48416209809099 (37.7872245486486, -122.484162098091)
73907 186731 2 116 1300 Sunset Blvd 66 9 1 1     2 Width 0ft   5984870.0408 2106303.059 37.7626315529982 -122.495507139178 (37.7626315529982, -122.495507139178)
74058 186679 2 116 1401 Sunset Blvd 36 9 1 1     1 Width 0ft   5984735.2903 2105403.2290000003 37.760152980386 -122.495906802394 (37.760152980386, -122.495906802394)
74083 187107 2 116 2600 Sunset Blvd 43 9 1 1     1 Width 0ft   5985143.7078 2097238.6019 37.73775905490071 -122.49389259826401 (37.7377590549007, -122.493892598264)
74195 240615 2 116 297 Cumberland St 1 9 1 1     8 Width 3ft   6003715.872169999 2104475.4119700002 37.75869878143 -122.430195805998 (37.75869878143, -122.430195805998)
74221 215021 2 116 2624 14th Ave 3 1 1 1     19 Width 3ft   5992112.26225 2097456.03758 37.7387613350595 -122.469814985494 (37.7387613350595, -122.469814985494)
74839 187109 2 116 2600 Sunset Blvd 45 9 1 1     3 Width 0ft   5985172.8615 2097253.1787 37.7378007845896 -122.493792875188 (37.7378007845896, -122.493792875188)
75550 186581 2 116 1501 Sunset Blvd 52 19 1 1     2 Width 0ft   5984771.5099 2104576.6683 37.75788559627829 -122.495720567601 (37.7578855962783, -122.495720567601)
75777 240625 2 116 5413 Diamond Heights Blvd 4 9 1 1     10     6002051.53836 2097889.55934 37.7405211850978 -122.43548069809799 (37.7405211850978, -122.435480698098)
75876 240607 2 116 888 Elizabeth St 1 1 1 1     21 Width 4ft   6000718.67811 2102015.72187 37.751774854241795 -122.44038504473 (37.7517748542418, -122.44038504473)
76485 197585 3 116 900x Carolina St 75 3 1 2     27     6012517.30691 2102783.51804 37.7545477896502 -122.399637433715 (37.7545477896502, -122.399637433715)
77228 136442 2 116 3 Broadway 8 9 1 1     16     6013378.377640001 2118933.3014 37.7989393870992 -122.397792341438 (37.7989393870992, -122.397792341438)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
78522 112919 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
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)
81040 112918 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
81067 113358 6 116 702 Foerster St 1 5 1 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
82219 97945 6 116 2 Mendosa Ave 1 7 1 1         Permit Number 768165 5993624.4 2101138.5 37.748959736293294 -122.464854121346 (37.7489597362933, -122.464854121346)
83100 240610 2 116 3944 22nd St 6 7 1 1     8     6002190.86574 2102965.81607 37.754467300333296 -122.43536198397301 (37.7544673003333, -122.435361983973)
85054 111269 3 116 700X BOSWORTH ST 7 7 1 2     3     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
85824 112921 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
85994 104510 5 116 254 ALLISON ST 1 13 1 1     40     6000052.0 2087408.0 37.7116274717654 -122.441642291463 (37.7116274717654, -122.441642291463)
86068 121227 3 116 4299x 17th St 3 7 1 2                    
86905 88838 1 116 3711 19th Ave 14 1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51718 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
86911 87150 6 116 4 Bellair Pl 2 13 1 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
87470 102106 6 116 50X Noe St 8 7 1 1   12/19/2012 12:00:00 AM 25   Permit Number 769282 6002816.1 2107996.5 37.7683158318555 -122.433559261751 (37.7683158318555, -122.433559261751)
88274 3774 3 116 1098 Carolina St 7 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
88885 370 1 116 3711X 19th Ave 1 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
89351 116234 6 116 450 PERALTA AVE 1 7 1 1       3x3   6009750.0 2099218.0 37.744603019334 -122.408955999129 (37.744603019334, -122.408955999129)
89530 112922 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
91222 98597 1 116 400X Steiner St 3 5 1 1         Permit Number 768529 6004639.0 2109849.0 37.7735056071657 -122.42738600543899 (37.7735056071657, -122.427386005439)
91300 112804 2 116 219 UPPER TER 1 1 1 1     60 3x3   5999620.0 2106355.0 37.7636268249183 -122.444496241129 (37.7636268249183, -122.444496241129)
91679 94535 6 116 265 Dorland St 1 13 1 1           6003831.0 2105693.0 37.7620485075454 -122.42988449123301 (37.7620485075454, -122.429884491233)
92371 118371 7 116 4808 25th St 1 1 1 1       3x3   5999981.0 2101110.0 37.7492459313263 -122.44287099416799 (37.7492459313263, -122.442870994168)
92695 375 1 116 3711X 19th Ave 5 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
96847 376 1 116 3711X 19th Ave 8 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
97021 106360 6 116 1820 POST ST 1 7 1 1     30     6003351.1 2114201.6 37.785383838011 -122.43215193232099 (37.785383838011, -122.432151932321)
99767 122496 2 116 69x Bonview St 12 1 1 2       3x3   6007716.0 2099172.0 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063)
100317 113359 6 116 702 Foerster St 2 5 1 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
100331 112930 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
101507 381 1 116 3711X 19th Ave 13 1 1 1   09/11/2008 12:00:00 AM 16 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
102600 106362 6 116 1645 WEBSTER ST 1 7 1 1     12     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178)
102899 373 1 116 3711X 19th Ave 4 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
104001 197581 2 116 2101 17th St 1 7 1 1     35     6011118.65336 2106461.14792 37.7645676761706 -122.40473326313601 (37.7645676761706, -122.404733263136)
104910 24794 1 116 7633 Geary Blvd 1 1 1 1     6 3X3   5983299.41691 2112375.1982400003 37.7792118059508 -122.50138846508999 (37.7792118059508, -122.50138846509)
105060 380 1 116 3711X 19th Ave 12 1 1 1   09/11/2008 12:00:00 AM 16 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
105322 181478 2 116 1400 Sunset Blvd 38 9 1 1     2 Width 0ft   5984917.9059 2105334.1509 37.759974004815795 -122.495270136852 (37.7599740048158, -122.495270136852)
105545 54448 1 116 425 Vermont St 1 1 1 1   12/16/2015 12:00:00 AM   3x5 Permit Number 10233 6011220.56042251 2106374.73270267 37.764336094761 -122.40437470921499 (37.764336094761, -122.404374709215)
106132 97857 1 116 895 Indiana St 5 1 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
106519 105769 2 116 1 Gonzalez Dr 1 7 1 1   02/24/2014 12:00:00 AM     Permit Number 772589 5990111.8 2090190.8 37.718696994740704 -122.476201051717 (37.7186969947407, -122.476201051717)
106535 113163 6 116 1300X STANYAN ST 2 7 1 1     40 3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
107500 54927 1 116 485 Duncan St 1 1 1 1   08/16/1972 12:00:00 AM 10   Permit Number 10801 6003402.69319537 2099776.66443458 37.745779384936206 -122.43094357883498 (37.7457793849362, -122.430943578835)
111685 107343 6 116 110 JULIAN AVE 2 13 1 1     15     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366)
112251 113162 6 116 1300X STANYAN ST 1 7 1 1     40 3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
114267 95432 2 116 2675 25th Ave 1 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
114761 112559 6 116 1735x GRANT AVE 1 13 1 1           6010373.0 2120454.0 37.8029470287696 -122.40829930674299 (37.8029470287696, -122.408299306743)
114763 112145 3 116 401X ROOSEVELT WAY 2 3 1 2     24     6000065.0 2106738.0 37.764703828929896 -122.44298463673401 (37.7647038289299, -122.442984636734)
115004 88839 1 116 3711 19th Ave 15 1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51718 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
115065 87450 1 116 180 Castenada Ave 1 1 1 1   04/30/2008 12:00:00 AM   3x3 Permit Number 50376 5994470.9 2100852.3 37.748222673270895 -122.461906191942 (37.7482226732709, -122.461906191942)
115520 112925 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
115606 95435 2 116 2675 25th Ave 2 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
116259 122587 2 116 2500X Lyon St 7 11 1 1     45 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
116977 371 1 116 3711X 19th Ave 2 1 1 1   09/11/2008 12:00:00 AM 6 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
117092 113150 6 116 45 BRONTE ST 1 1 1 1     15 3x3   6009384.0 2097185.0 37.7390003361927 -122.410078062228 (37.7390003361927, -122.410078062228)
117801 27532 1 116 3711X 19th Ave 7 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
117865 112928 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
119676 6389 3 116 40 Entrada Ct 3 1 1 2     3 60M   5992282.41809 2092443.27672 37.725007378570105 -122.468861992007 (37.7250073785701, -122.468861992007)
121387 97856 1 116 895 Indiana St 4 5 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
122391 374 1 116 3711X 19th Ave 6 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
123320 109532   116 818 Goettingen St 1 13 1 1           6010847.3 2090865.3 37.7217296747854 -122.404573864697 (37.7217296747854, -122.404573864697)
123802 97853 1 116 895 Indiana St 1 1 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
124243 378 1 116 3711X 19th Ave 10 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
124987 98548 7 116 132 Hamerton Ave 1 7 1 1           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907)
Powered by Datasette · Query took 6.077ms · Data source: data.sfgov.org