sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
24447 201523 2 1 799 Earl St 1 7 1 1     18 Width 10ft   6020371.96237 2093662.3098400002 37.729937451546704 -122.371842613372 (37.7299374515467, -122.371842613372)
28873 177837 2 1 650 Peru Ave 3 7 1 1     12     6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
30242 247859 2 1 81 Bradford St 1 7 1 1     14     6009590.028030001 2098126.55062 37.741597175379894 -122.409432139892 (37.7415971753799, -122.409432139892)
37741 177836 2 1 650 Peru Ave 2 7 1 1     30     6005089.4768199995 2092569.03703 37.7260842891429 -122.424598299682 (37.7260842891429, -122.424598299682)
38897 177806 2 1 62 Tomaso Ct 10 7 1 1     25 Width 8ft   6009249.93875 2086480.54598 37.709600642326606 -122.409786194885 (37.7096006423266, -122.409786194885)
44191 194043 2 1 1700 22nd St 2 7 1 1     22     6012940.14961 2103802.44192 37.7573690942271 -122.398246606115 (37.7573690942271, -122.398246606115)
52437 232289 2 1 0 San Jose Av Off Ramp 4 7 1 1     16 Width 9ft   6002953.30911 2095259.2744599998 37.7333502006365 -122.43217493415301 (37.7333502006365, -122.432174934153)
60467 247863 2 1 81 Bradford St 5 7 1 1     18     6009595.21098 2098157.48801 37.7416824131186 -122.409416401771 (37.7416824131186, -122.409416401771)
62149 232294 2 1 200 Eugenia Ave 38 7 1 1     17     6006564.33926 2098135.6208099998 37.7414520850542 -122.41989461157301 (37.7414520850542, -122.419894611573)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
69757 247862 2 1 81 Bradford St 4 7 1 1     14     6009589.386530001 2098133.6831900002 37.7416167239206 -122.40943486124701 (37.7416167239206, -122.409434861247)
73078 247860 2 1 81 Bradford St 2 7 1 1     12     6009586.93034 2098129.5986 37.7416053709039 -122.40944306575899 (37.7416053709039, -122.409443065759)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
92138 101902 1 1 1100 Ocean Ave 3 7 1 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
102326 104898 6 1 310 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
102950 105540 6 1 2694 47TH AVE 1 7 1 1     12     5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
106220 102130 2 1 33 Topaz Way 4 7 1 1     7   Permit Number 769641 6001571.9 2098568.0 37.7423567715609 -122.437187662125 (37.7423567715609, -122.437187662125)
106634 121195 6 1 255x Red Rock Way 2 7 1 1       3x3 Permit Number 775289 5999917.0 2099808.0 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589)
109657 98303 6 1 6 Locksley Ave 3 7 1 1           5994194.0 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093)
117957 98300 2 1 6 Locksley Ave 1 7 1 1           5994194.0 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093)
118620 104908 6 1 500 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
131380 194064 2 1 1640 Davidson Ave 1 7 1 1     9 Width 6ft   6014536.55143 2099742.5606 37.7463103162609 -122.3924416073 (37.7463103162609, -122.3924416073)
135181 232295 2 1 200 Eugenia Ave 39 7 1 1     6     6006547.43699 2098127.1164599997 37.7414277817691 -122.419952450553 (37.7414277817691, -122.419952450553)
142656 121196 6 1 255x Red Rock Way 3 7 1 1       3x3 Permit Number 775289 5999917.0 2099808.0 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589)
149889 177838 2 1 652 Peru Ave 1 7 1 1     16     6005106.92486 2092561.69197 37.7260651065947 -122.42453746056101 (37.7260651065947, -122.424537460561)
158989 177835 2 1 650 Peru Ave 1 7 1 1     17     6005084.25734 2092571.43545 37.7260905799026 -122.42461651366301 (37.7260905799026, -122.424616513663)
162173 177805 2 1 62 Tomaso Ct 9 7 1 1     25 Width 8ft   6009236.846480001 2086428.13607 37.709456001673296 -122.409827747151 (37.7094560016733, -122.409827747151)
166693 194049 2 1 100 Hampshire St 6 7 1 1     8     6009981.034030001 2107543.0973799997 37.76747481202629 -122.40874433479999 (37.7674748120263, -122.4087443348)
167980 232292 2 1 200 Eugenia Ave 35 7 1 1     27 Width 10ft   6006575.0369 2098117.47597 37.7414028660575 -122.41985633551701 (37.7414028660575, -122.419856335517)
175127 177839 2 1 652 Peru Ave 2 7 1 1     17     6005114.3651 2092558.89448 37.7260578454775 -122.42451154118 (37.7260578454775, -122.42451154118)
180452 177816 2 1 60 Tomaso Ct 1 7 1 1     15 Width 3ft   6009147.33252 2086269.1354099999 37.7090144012735 -122.41012590570601 (37.7090144012735, -122.410125905706)
182248 232293 2 1 200 Eugenia Ave 37 7 1 1     17     6006572.50895 2098130.46557 37.741438390175205 -122.41986599782301 (37.7414383901752, -122.419865997823)
184202 177807 2 1 62 Tomaso Ct 12 7 1 1     19 Width 8ft   6009274.965480001 2086528.64182 37.7097341062031 -122.409703090337 (37.7097341062031, -122.409703090337)
7743 121449 6 2 1274 Filbert St 1 7 1 1     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562)
35461 193775 2 2 1040 Minnesota St 3 7 1 1     14     6015239.9483 2103736.7361 37.7573165153716 -122.39028833533199 (37.7573165153716, -122.390288335332)
47525 177649 2 2 451 Tocoloma Ave 3 7 1 1     8 Width 5ft   6012431.1901 2086436.64385 37.709657863481205 -122.398788087022 (37.7096578634812, -122.398788087022)
47993 105254 2 2 130 GONZALEZ DR   7 1 1     2     5990327.0 2090136.0 37.7185590045312 -122.47545320091999 (37.7185590045312, -122.47545320092)
54100 231223 2 2 220 Coso Ave 5 7 1 1     4     6007580.66688 2099526.6685200003 37.7453287970792 -122.416479002612 (37.7453287970792, -122.416479002612)
58214 249935 2 2 345 Filbert St 4 7 1 1     13 Width 0ft   6011217.60626 2120022.59893 37.8018097658745 -122.40534611785601 (37.8018097658745, -122.405346117856)
72791 232774 2 2 23 Seward St 2 7 1 1     3 Width 3ft   6001021.9889 2104218.53505 37.7578405116552 -122.439494050427 (37.7578405116552, -122.439494050427)
77391 92760 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
78407 92764 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
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)
82826 92763 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
83452 92762 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
86127 92761 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
96352 92759 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
99263 101435 6 2 600X Grant Ave 1 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
105471 101436 6 2 600X Grant Ave 2 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
106295 113380 6 2 63 Potomac St 1 7 1 1       4x4 Permit Number 776311 6003081.0 2108682.5 37.7702144463181 -122.432692008068 (37.7702144463181, -122.432692008068)
113684 92767 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
116515 92766 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
117761 101439 6 2 600X Grant Ave 4 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
123027 101440 6 2 600X Grant Ave 5 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
127045 92765 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
128404 101438 6 2 600X Grant Ave 3 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
136773 193819 2 2 300 Tulare St 8 7 1 1     2     6015080.24684 2100323.5646599997 37.747935809394896 -122.39060215016501 (37.7479358093949, -122.390602150165)
140550 116849 4 2 83 Panorama Dr 1 7 1 1   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054)
147478 177648 2 2 451 Tocoloma Ave 2 7 1 1     7 Width 5ft   6012427.630469999 2086427.74351 37.7096332265644 -122.398799765591 (37.7096332265644, -122.398799765591)
150158 193818 2 2 300 Tulare St 7 7 1 1     3     6015085.697980001 2100310.3734 37.7478998913736 -122.390582378571 (37.7478998913736, -122.390582378571)
153886 177650 2 2 451 Tocoloma Ave 4 7 1 1     8 Width 5ft   6012434.26652 2086449.4800599997 37.7096932805964 -122.39877835455201 (37.7096932805964, -122.398778354552)
154599 177647 2 2 451 Tocoloma Ave 1 7 1 1     10 Width 5ft   6012423.949469999 2086414.60679 37.7095969506192 -122.398811566514 (37.7095969506192, -122.398811566514)
172642 193817 2 2 300 Tulare St 6 7 1 1     2     6015100.80126 2100307.8332 37.747893754394205 -122.390529974205 (37.7478937543942, -122.390529974205)
175732 249934 2 2 345 Filbert St 3 7 1 1     15 Width 0ft   6011220.75334 2120024.0866900003 37.8018140268525 -122.40533533227101 (37.8018140268525, -122.405335332271)
177116 193816 2 2 300 Tulare St 5 7 1 1     3     6015118.62426 2100316.39595 37.74791825464221 -122.390468940782 (37.7479182546422, -122.390468940782)
179074 201933 2 2 190 Boutwell St 3 7 1 1     20 Width 9ft   6010622.819180001 2095611.5496200002 37.7347493344117 -122.405683976059 (37.7347493344117, -122.405683976059)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 6 3 900X 14th St 3 7 1 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
1272 251489 3 3 900 Bosworth St 31 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1282 251482 3 3 900 Bosworth St 1 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1283 251493 3 3 900 Bosworth St 35 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1286 251492 3 3 900 Bosworth St 34 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1288 251487 3 3 900 Bosworth St 29 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1290 251486 3 3 900 Bosworth St 28 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1295 251491 3 3 900 Bosworth St 33 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1298 251490 3 3 900 Bosworth St 32 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1299 251494 3 3 900 Bosworth St 36 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1316 251488 3 3 900 Bosworth St 30 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1322 251483 3 3 900 Bosworth St 8 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1332 251484 3 3 900 Bosworth St 7 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1338 251485 3 3 900 Bosworth St 6 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
2100 178279 2 3 900 Brotherhood Way 6 7 1 2     4 Width 0ft   5987917.15522 2088760.91322 37.714643374877895 -122.48368218070499 (37.7146433748779, -122.483682180705)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3034 253070 2 3 132 Sagamore St 2 7 1 1       Width 0ft Permit Number 780451 5995539.3842400005 2087458.9579900003 37.7115092483173 -122.45724268539699 (37.7115092483173, -122.457242685397)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 6 3 1200X JUNIPERO SERRA BLVD 11 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
Powered by Datasette · Query took 27.634ms · Data source: data.sfgov.org