sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
189013 183208 2 38 4208 Ulloa St 1 1 1 1     9 Width 0ft   5982977.5431 2098144.6836 37.74011993093129 -122.501448961428 (37.7401199309313, -122.501448961428)
188897 84120 2 38 336 Campbell Ave 2 1 1 1 1 06/24/2006 12:00:00 AM 6     6011186.92342 2088226.0732 37.7145018701492 -122.403214308206 (37.7145018701492, -122.403214308206)
188736 207124 2 38 2 Cranleigh Dr 5 7 1 1     9 Width 0ft   5991335.55729 2095661.67857 37.7337895545331 -122.472369667134 (37.7337895545331, -122.472369667134)
188419 129470 2 38 45 MacOndray Ln 2 9 1 1     10     6008463.14234 2119145.61201 37.799247391416394 -122.414815771241 (37.7992473914164, -122.414815771241)
188129 207114 2 38 53 Ralston St 2 13 1 1     23     5992175.21623 2088282.1627599997 37.7135757806697 -122.468929896991 (37.7135757806697, -122.468929896991)
188108 247870 2 38 394 Mayflower St 2 17 1 1     10     6009721.06953 2098395.0417 37.74234173489771 -122.40899798048099 (37.7423417348977, -122.408997980481)
188045 191393 2 38 845 Vermont St 4 2 1 1     26     6011318.33835 2104379.19174 37.758862249405 -122.40389608603901 (37.758862249405, -122.403896086039)
187814 102790 1 38 3445 Moraga St 2 1 1 1     17   Permit Number 42050 5983633.0 2103554.0 37.7550108962308 -122.499582370415 (37.7550108962308, -122.499582370415)
186526 183209 2 38 4212 Ulloa St 2 1 1 1     8 Width 0ft   5982952.5112 2098143.3306 37.740114745803204 -122.501535410067 (37.7401147458032, -122.501535410067)
186348 129483 2 38 12 Greenwich St 1 2 1 1     17     6012307.75016 2120551.4086599997 37.8033226386787 -122.401610879045 (37.8033226386787, -122.401610879045)
186287 191379 2 38 800 Vermont St 29 2 1 1     5     6011295.7098900005 2104243.81406 37.758489268176 -122.403964819445 (37.758489268176, -122.403964819445)
185196 207133 2 38 700 Junipero Serra Blvd 90 4 1 1     10 Width 0ft   5991231.48328 2092142.9158700001 37.724121889294295 -122.472473035196 (37.7241218892943, -122.472473035196)
185104 191404 2 38 2 Tulare St 14 7 1 1     20     6016173.59275 2100299.3088 37.7479298037296 -122.3868196817 (37.7479298037296, -122.3868196817)
185081 227680 2 38 1541 Sanchez St 1 1 1 1     9 Width 2ft   6003988.609540001 2099295.3111900003 37.7444908816604 -122.428883253577 (37.7444908816604, -122.428883253577)
184814 207122 2 38 2 Cranleigh Dr 7 7 1 1     12 Width 0ft   5991343.33969 2095670.4637 37.7338141267018 -122.47234340152399 (37.7338141267018, -122.472343401524)
184000 186754 2 38 1200 Sunset Blvd 20 9 1 1     9 Width 0ft   5984863.7808 2106693.8 37.763704051609004 -122.49555761110202 (37.763704051609, -122.495557611102)
182990 182942 2 38 2671 46th Ave 1 1 1 1     2 Width 0ft   5982115.1 2096931.8144 37.736739035882394 -122.504341059874 (37.7367390358824, -122.504341059874)
182655 186512 2 38 1400 Lower Great Hwy 13 19 1 1     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968)
182431 218284 3 38 50x Junipero Serra Frontage West 0 3 1 2     28     5991438.8932 2095398.7783700002 37.7330736770928 -122.4719932523 (37.7330736770928, -122.4719932523)
180846 207121 2 38 2 Cranleigh Dr 8 7 1 1     20 Width 0ft   5991346.9817 2095677.27593 37.733833042151105 -122.47233130655898 (37.7338330421511, -122.472331306559)
180188 227692 2 38 75 Holly Park Cir 1 1 1 1     4 Width 3ft   6006684.36987 2096973.81613 37.738268789882795 -122.419397184857 (37.7382687898828, -122.419397184857)
179845 207123 2 38 2 Cranleigh Dr 6 7 1 1     21 Width 0ft   5991338.6165 2095665.48618 37.733800186326604 -122.472359368113 (37.7338001863266, -122.472359368113)
179459 176985 2 38 2571 Alemany Blvd 2 1 1 1     21 Width 2ft   5998574.332719999 2088565.20963 37.714720604140204 -122.44683269999399 (37.7147206041402, -122.446832699994)
179206 176986 2 38 745 France Ave 1 1 1 1     1 Width 4ft   6002864.08823 2089338.03726 37.7170867510327 -122.43206070495899 (37.7170867510327, -122.432060704959)
178737 186058 2 38 1901 Sunset Blvd 4 9 1 1     4 Width 0ft   5984794.5256 2102183.7824 37.7513167410032 -122.495464490464 (37.7513167410032, -122.495464490464)
178473 122182 2 38 2 14th Ave 1 2 1 1     10     5991497.785680001 2114857.01928 37.7865042639669 -122.473208256238 (37.7865042639669, -122.473208256238)
178438 207120 2 38 2 Cranleigh Dr 9 7 1 1     21 Width 0ft   5991349.86178 2095682.72956 37.7338481831293 -122.472321746778 (37.7338481831293, -122.472321746778)
178121 47450 1 38 5049 Anza St 1 1 1 1 1 05/14/2002 12:00:00 AM 7   Permit Number 45359 5982925.588409999 2111676.1494 37.7772704608477 -122.502629914355 (37.7772704608477, -122.502629914355)
178085 227673 2 38 1000 San Jose Ave 64 7 1 1     12     6005078.09924 2097049.5351099998 37.738386096529204 -122.424956266738 (37.7383860965292, -122.424956266738)
177899 191399 2 38 2100 Alameda St 5 7 1 1     5     6010727.66479 2107914.7241700003 37.7685370048986 -122.406188011877 (37.7685370048986, -122.406188011877)
177045 191387 2 38 800 Vermont St 39 2 1 1     10 Width 4ft   6011279.1597 2104155.2145599998 37.7582450689735 -122.40401582268801 (37.7582450689735, -122.404015822688)
176859 191367 2 38 548 Vermont St 1 1 1 1     24 Width 3ft   6011194.69766 2105791.5268900003 37.762733297531206 -122.404423107658 (37.7627332975312, -122.404423107658)
176854 191389 2 38 800 Vermont St 43 2 1 1     8 Width 9ft   6011309.9548 2104119.65272 37.758149144577104 -122.403906816767 (37.7581491445771, -122.403906816767)
176379 129482 2 38 11 Greenwich St 5 2 1 1     8     6012315.37501 2120537.75286 37.803285568636 -122.401583532467 (37.803285568636, -122.401583532467)
175676 176981 2 38 2315 Alemany Blvd 2 1 1 1     17 Width 1ft   5999571.4621 2089300.9269299998 37.7167976306892 -122.44343903719299 (37.7167976306892, -122.443439037193)
175633 176982 2 38 2157 Alemany Blvd 2 1 1 1     12 Width 2ft   5999995.5387 2089705.6098099998 37.717932973520206 -122.442002247903 (37.7179329735202, -122.442002247903)
175563 129481 2 38 11 Greenwich St 4 2 1 1     5     6012317.54236 2120532.7765200003 37.8032720257522 -122.401575682271 (37.8032720257522, -122.401575682271)
175448 191392 2 38 845 Vermont St 3 2 1 1     13     6011311.05886 2104374.20224 37.7588481426559 -122.403920910926 (37.7588481426559, -122.403920910926)
174722 207118 2 38 2 Cranleigh Dr 12 7 1 1     27 Width 0ft   5991361.11034 2095702.06647 37.7339019284143 -122.472284266614 (37.7339019284143, -122.472284266614)
174088 207100 2 38 1325 18th Ave 9 1 1 1     2 Width 3ft   5990476.61635 2106239.9997799997 37.762785111079396 -122.476111608564 (37.7627851110794, -122.476111608564)
174070 129473 2 38 11 Filbert St 5 2 1 1     14     6012532.2991 2120205.0438900003 37.8023841322847 -122.400809466192 (37.8023841322847, -122.400809466192)
173767 83228 1 38 4234 Ulloa St 1 1 1 1   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50748 5982916.47531802 2098139.9083931 37.740103232807705 -122.50165975231 (37.7401032328077, -122.50165975231)
173722 227683 2 38 923 Capp St 1 1 1 1     7 Width 3ft   6007409.880530001 2101914.88747 37.7518767015549 -122.41723875888201 (37.7518767015549, -122.417238758882)
173683 191381 2 38 800 Vermont St 32 2 1 1     7 Width 4ft   6011271.17001 2104191.3624299997 37.7583438765916 -122.40404599854601 (37.7583438765916, -122.404045998546)
173361 46399 1 38 2110 47th Ave 1 1 1 1 1 03/05/2002 12:00:00 AM 5   Permit Number 44629 5981721.80383178 2100709.75793181 37.7470890826019 -122.505980852245 (37.7470890826019, -122.505980852245)
172830 84447 1 38 2266 45th Ave 1 1 1 1   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50738 5982378.18226568 2099687.61773546 37.744321183805106 -122.503635505549 (37.7443211838051, -122.503635505549)
172620 191407 2 38 2 Tulare St 7 7 1 1     12     6016225.71134 2100306.15132 37.747951477381 -122.386639933312 (37.747951477381, -122.386639933312)
172179 191388 2 38 800 Vermont St 40 2 1 1     7 Width 4ft   6011282.56063 2104153.62595 37.7582408970175 -122.40400394893 (37.7582408970175, -122.40400394893)
172053 207129 2 38 4986 19th Ave 3 2 1 1     12 Width 3ft   5990655.7482 2093855.39662 37.7287905920011 -122.47458816511002 (37.7287905920011, -122.47458816511)
172032 176987 2 38 1278 Alemany Blvd 1 1 1 1     30 Width 5ft   6002815.8897 2094148.3870700002 37.7302921639516 -122.43257070868799 (37.7302921639516, -122.432570708688)
171868 218294 2 38 1 Woodacre Dr 18 2 1 1     9     5991183.55146 2095353.09261 37.7329334566034 -122.472872697534 (37.7329334566034, -122.472872697534)
171831 191396 2 38 2100 Alameda St 2 7 1 1     6     6010761.0499599995 2107917.30957 37.7685459711594 -122.40607271698799 (37.7685459711594, -122.406072716988)
171814 129480 2 38 11 Greenwich St 3 2 1 1     18     6012320.77236 2120522.45554 37.8032438670795 -122.401563778859 (37.8032438670795, -122.401563778859)
171720 207111 2 38 59 Ralston St 2 13 1 1     11     5992171.5605 2088305.6585 37.713640083085 -122.468944241206 (37.713640083085, -122.468944241206)
171541 186059 2 38 1901 Sunset Blvd 5 9 1 1     6 Width 0ft   5984803.9529 2102180.8195 37.751309157700604 -122.495431671777 (37.7513091577006, -122.495431671777)
171269 83239 1 38 4332 Pacheco St 1 1 1 1   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50745 5981564.36989544 2101497.47247657 37.749242657582705 -122.50658364702 (37.7492426575827, -122.50658364702)
171177 207103 2 38 40 Eastwood Dr 1 1 1 1     8 Width 2ft   5995614.83933 2092751.51074 37.726045680348705 -122.457364540844 (37.7260456803487, -122.457364540844)
170757 184168 2 38 3732 Lawton St 1 1 1 1     18 Width 0ft   5982616.4158 2104253.9424 37.756873039994204 -122.503149769389 (37.7568730399942, -122.503149769389)
170082 191380 2 38 800 Vermont St 30 2 1 1     13     6011289.9844 2104226.0484599997 37.7584401679041 -122.403983370659 (37.7584401679041, -122.403983370659)
169951 183438 2 38 2506 26th Ave 1 1 1 1     6 Width 0ft   5988326.6233 2098215.7152 37.7406276663345 -122.48295944841401 (37.7406276663345, -122.482959448414)
169634 191405 2 38 2 Tulare St 9 7 1 1     8     6016216.75475 2100305.37684 37.7479488549636 -122.386670851103 (37.7479488549636, -122.386670851103)
169449 191383 2 38 800 Vermont St 34 2 1 1     15 Width 4ft   6011269.17641 2104180.10815 37.7583128634534 -122.404052101317 (37.7583128634534, -122.404052101317)
168815 191391 2 38 845 Vermont St 2 2 1 1     5     6011306.2123 2104378.54497 37.7588597960547 -122.40393797827299 (37.7588597960547, -122.403937978273)
167635 207136 2 38 700 Junipero Serra Blvd 100 4 1 1     6 Width 0ft   5991240.31686 2092039.5475299999 37.723838576763896 -122.47243496690399 (37.7238385767639, -122.472434966904)
167106 47850 1 38 1342 41st Ave 1 1 1 1 1 06/14/2002 12:00:00 AM 7   Permit Number 45609 5983405.04544412 2106002.56953842 37.7617206013965 -122.50055173019501 (37.7617206013965, -122.500551730195)
166550 227682 2 38 500 Gates St 1 1 1 1     5 Width 3ft   6008186.7931 2096476.1256400002 37.7369867469298 -122.41416732857999 (37.7369867469298, -122.41416732858)
166033 129485 2 38 12 Greenwich St 4 2 1 1     10     6012301.33061 2120559.21941 37.803343726885 -122.40163364357099 (37.803343726885, -122.401633643571)
165701 42597 1 38 1950 Clay St 3 1 1 1   06/26/2000 12:00:00 AM 7   Permit Number 42667 6005420.67346 2116544.61332 37.7919342879744 -122.42515859980499 (37.7919342879744, -122.425158599805)
164753 207116 2 38 47 Ralston St 9 13 1 1     8     5992178.8337 2088240.4151599999 37.7134613608383 -122.46891435762801 (37.7134613608383, -122.468914357628)
164558 138264 2 38 2600 GEARY BLVD 32 19 1 1     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.44699593627199 (37.7823276740968, -122.446995936272)
164300 186000 2 38 1883 47th Ave 1 9 1 1     1 Width 0ft   5981612.0444 2102288.7145 37.7514179925848 -122.506477461595 (37.7514179925848, -122.506477461595)
164118 191384 2 38 800 Vermont St 35 2 1 1     3 Width 4ft   6011268.81564 2104171.75859 37.7582899172605 -122.40405276143 (37.7582899172605, -122.40405276143)
164114 184169 2 38 3734 Lawton St 2 1 1 1     9 Width 0ft   5982587.082 2104253.9424 37.7568713157118 -122.503251214898 (37.7568713157118, -122.503251214898)
163790 227694 2 38 239 Caselli Ave 1 1 1 1     9 Width 3ft   5999877.66163 2104769.07166 37.7592869569347 -122.44349114479401 (37.7592869569347, -122.443491144794)
163773 83208 1 38 3634 Rivera St 1 1 1 1   06/09/2008 12:00:00 AM 7 3x3 Permit Number 50746 5981914.57527844 2100148.1004138 37.7455582728462 -122.505272655065 (37.7455582728462, -122.505272655065)
163400 207139 2 38 208 Colon Ave 1 1 1 1     6 Width 3ft   5996097.007130001 2094250.7795400003 37.7301899955731 -122.45580605711599 (37.7301899955731, -122.455806057116)
162968 191403 2 38 2100 Alameda St 9 7 1 1     5     6010692.2016199995 2107913.0668 37.7685304704432 -122.40631055979601 (37.7685304704432, -122.406310559796)
162496 207110 2 38 59 Ralston St 1 13 1 1     7     5992170.63195 2088310.84387 37.7136542672107 -122.468947827707 (37.7136542672107, -122.468947827707)
161309 207102 2 38 1325 18th Ave 13 1 1 1     2 Width 3ft   5990480.890819999 2106148.89617 37.7625352128593 -122.476090170539 (37.7625352128593, -122.476090170539)
160532 38367 1 38 4245 Lawton St 2 1 1 1 1 01/06/1999 12:00:00 AM 5   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
160044 186041 2 38 1900 Sunset Blvd 36 9 1 1     13 Width 0ft   5984992.0482 2102149.6578 37.7512346080754 -122.494778929254 (37.7512346080754, -122.494778929254)
159861 227676 2 38 427 Valley St 1 2 1 1     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762)
159748 191397 2 38 2100 Alameda St 3 7 1 1     9     6010751.13717 2107916.6697400003 37.768543659889005 -122.406106959582 (37.768543659889, -122.406106959582)
159286 191372 2 38 2220 20th St 1 1 1 1     15 Width 4ft   6011446.77315 2104664.6622599997 37.7596532625069 -122.403471980161 (37.7596532625069, -122.403471980161)
159182 78557 1 38 2234 47th Ave 1 1 1 1 1 01/06/2016 12:00:00 AM 3   Permit Number 771299 5981748.2661 2099861.5988 37.7447618317919 -122.505826480334 (37.7447618317919, -122.505826480334)
158536 207119 2 38 2 Cranleigh Dr 10 7 1 1     25 Width 0ft   5991353.65823 2095688.25461 37.733863573243205 -122.47230902406099 (37.7338635732432, -122.472309024061)
158119 46395 1 38 2091 46th Ave 1 1 1 1 1 03/05/2002 12:00:00 AM 9   Permit Number 44627 5981974.76389525 2100876.77542895 37.74756255280229 -122.505118527994 (37.7475625528023, -122.505118527994)
156319 186749 2 38 1200 Sunset Blvd 15 9 1 1     10 Width 0ft   5984860.385 2106678.2761 37.7636612284897 -122.495568210877 (37.7636612284897, -122.495568210877)
155355 32594 1 38 1379 34th Ave 1 1 1 1 1 10/22/1996 12:00:00 AM 1   Permit Number 37062 5985531.05347187 2105840.85496484 37.76140115330671 -122.49318691517 (37.7614011533067, -122.49318691517)
154916 37082 1 38 1268 45th Ave 1 1 1 1 1 01/15/2002 12:00:00 AM 6   Permit Number 44549 5982146.28824129 2106471.58463776 37.762934408685396 -122.504939947841 (37.7629344086854, -122.504939947841)
154704 191400 2 38 2100 Alameda St 6 7 1 1     18     6010721.657430001 2107914.21049 37.76853525842721 -122.406208754734 (37.7685352584272, -122.406208754734)
154417 191378 2 38 800 Vermont St 28 2 1 1     6     6011285.84337 2104240.2990099997 37.7584790653842 -122.40399869511002 (37.7584790653842, -122.40399869511)
154113 201278 2 38 28 Lydia Ave 1 4 1 1     6 Width 2ft   6012862.05555 2092837.94578 37.7272585546286 -122.397747632568 (37.7272585546286, -122.397747632568)
154023 207128 2 38 2 Cranleigh Dr 1 7 1 1     15 Width 0ft   5991324.62806 2095649.6189400002 37.7337558092758 -122.472406573513 (37.7337558092758, -122.472406573513)
154014 227691 2 38 309 Bocana St 1 2 1 1     8 Width 3ft   6006868.9204400005 2097195.64462 37.7388882743696 -122.418774826116 (37.7388882743696, -122.418774826116)
153486 207109 2 38 75 Ralston St 2 13 1 1     14     5992170.77084 2088338.0326 37.713728928924105 -122.46894932506599 (37.7137289289241, -122.468949325066)
152713 129469 2 38 1085 Vallejo St 4 9 1 1     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808)
152532 129478 2 38 12 Filbert St 2 2 1 1     17     6012509.68294 2120230.66756 37.80245322719529 -122.400889531035 (37.8024532271953, -122.400889531035)
152163 207138 2 38 700 Junipero Serra Blvd 123 4 1 1     8 Width 0ft   5991217.227519999 2091775.34767 37.7231118130309 -122.472495529957 (37.7231118130309, -122.472495529957)
151607 191377 2 38 800 Vermont St 27 2 1 1     16     6011285.82751 2104250.98235 37.75850839857429 -122.40399950177601 (37.7585083985743, -122.403999501776)
151432 186745 2 38 1200 Sunset Blvd 11 9 1 1     2 Width 0ft   5984852.3804 2106661.5394 37.763614805479 -122.495594661337 (37.763614805479, -122.495594661337)
Powered by Datasette · Query took 3.085ms · Data source: data.sfgov.org