sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1529 251578 3 62 1000X Columbus Ave 6 11 1 2                    
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
4215 118354 3 109 100X Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 3              
4374 118351 3 109 100X Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 3              
5429 118350 3 109 100X Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 3              
5643 118347 3 109 100X Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 3              
5661 118352 3 109 100X Guerrero St 7 11 1 2   07/15/2016 06:56:00 AM 3              
9748 173655 3 78 100 Lawton St 1 11 1 10                    
10102 121489 3 80 2 Judah St 1 11 1 2       3x3            
14379 48480 1 17   1 11 1 1         Permit Number 45832          
147452 178266 3 3 12x Canyon Dr 13 11 1 2     11 Width 0ft   6002746.13562 2086151.65676 37.7083309587667 -122.43224097763901 (37.7083309587667, -122.432240977639)
161444 176333 3 40 12x Canyon Dr 12 11 1 2     12 Width 0ft   6002752.1139 2086168.71447 37.708378134509296 -122.43222153339899 (37.7083781345093, -122.432221533399)
180884 178265 3 3 12x Canyon Dr 11 11 1 2     25 Width 0ft   6002756.140790001 2086182.07734 37.7084150543766 -122.43220856967501 (37.7084150543766, -122.432208569675)
151982 178264 3 3 12x Canyon Dr 10 11 1 2     34 Width 0ft   6002759.723230001 2086192.08797 37.708442744517896 -122.432196902771 (37.7084427445179, -122.432196902771)
10449 98333 3 15 12X Canyon Dr 2 11 1 2     99     6003235.70781 2086338.01389 37.708870401808205 -122.43056224915199 (37.7088704018082, -122.430562249152)
169994 179174 3 231 12x Canyon Dr 5 11 1 2     6 Width 0ft   6003147.35342 2086364.11434 37.7089370622714 -122.43086947554899 (37.7089370622714, -122.430869475549)
13019 24270 3 28 300X Winding Way 8 11 1 2     6 8   6001396.0736 2086458.9864 37.709098177596005 -122.436928924942 (37.709098177596, -122.436928924942)
11289 24269 3 28 300X Winding Way 7 11 1 2     6 8   6001399.20674 2086458.92155 37.7090981776115 -122.43691809171999 (37.7090981776115, -122.43691809172)
10927 24271 3 28 300X Winding Way 9 11 1 2     6 8   6001388.30533 2086462.2685599998 37.70910674815379 -122.436956008017 (37.7091067481538, -122.436956008017)
11032 24272 3 28 300X Winding Way 10 11 1 2     6 8   6001382.61488 2086464.9875900003 37.7091138905754 -122.43697586956301 (37.7091138905754, -122.436975869563)
186679 179670 3 198 300x Winding Way 6 11 1 2     7 Width 0ft   6001487.80324 2086473.7350700002 37.7091438874604 -122.436612949055 (37.7091438874604, -122.436612949055)
52138 177088 3 55 300x Winding Way 5 11 1 2     10 Width 0ft   6001504.621119999 2086478.58914 37.7091581713864 -122.436555171203 (37.7091581713864, -122.436555171203)
115627 178410 3 193 300x Winding Way 4 11 1 2     12 Width 0ft   6001531.44731 2086487.39833 37.7091838838906 -122.43646308602 (37.7091838838906, -122.43646308602)
13159 24265 3 277 300X Winding Way 3 11 1 2     18 8   6001546.70936 2086492.80474 37.7091995959417 -122.43641072479299 (37.7091995959417, -122.436410724793)
39688 178859 3 227 300x Winding Way 2 11 1 2     36 Width 0ft   6001566.6929 2086499.15435 37.7092181660671 -122.436342112826 (37.7092181660671, -122.436342112826)
10890 24263 3 227 300X Winding Way 1 11 1 2     30 8   6001575.13411 2086503.1415799998 37.7092295937538 -122.43631322390199 (37.7092295937538, -122.436313223902)
103037 24281 3 105 300X Winding Way 19 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
110884 24285 3 26 300X Winding Way 23 11 1 2     12 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
123249 24282 3 86 300X Winding Way 20 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
128561 24283 3 143 300X Winding Way 21 11 1 2     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
144777 24280 3 39 300X Winding Way 18 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
146155 24284 3 105 300X Winding Way 22 11 1 2     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
11264 117179 3 116 350x Winding Way 1 11 1 2     30 3x3   6001167.67306 2086580.24641 37.7094181465037 -122.43772698870701 (37.7094181465037, -122.437726988707)
167020 179495 3 116 350x Winding Way 3 11 1 2     13 Width 0ft   6001141.4285699995 2086583.09342 37.7094244714452 -122.43781789759 (37.7094244714452, -122.43781789759)
11192 24264 3 3 350X Winding Way 2 11 1 2     24 8   6001155.71614 2086583.0952599999 37.709425288929296 -122.437768517615 (37.7094252889293, -122.437768517615)
11178 24266 3 107 350X Winding Way 4 11 1 2     30 8   6001132.77174 2086585.13109 37.7094295741756 -122.437847962815 (37.7094295741756, -122.437847962815)
12367 24267 3 103 350X Winding Way 5 11 1 2     12 8   6001124.44895 2086586.86413 37.7094338594468 -122.43787685174401 (37.7094338594468, -122.437876851744)
12342 24268 3 103 350X Winding Way 6 11 1 2     12 8   6001111.916180001 2086587.12369 37.7094338594537 -122.437920185566 (37.7094338594537, -122.437920185566)
35157 178267 3 3 350x Winding Way 7 11 1 2     20 Width 0ft   6001101.515319999 2086589.4198900003 37.7094395728456 -122.437956296952 (37.7094395728456, -122.437956296952)
22854 176359 3 39 350x Winding Way 8 11 1 2     19 Width 0ft   6001093.21408 2086592.19305 37.7094467152559 -122.437985185864 (37.7094467152559, -122.437985185864)
142086 110077 2 3 4099x ALEMANY BLVD   11 1 1     48     5991599.0 2086829.0 37.7095524384103 -122.470815701049 (37.7095524384103, -122.470815701049)
46886 175915 3 141 350x Winding Way 10 11 1 2     8 Width 0ft   6000968.48443 2086648.8804900001 37.7095952724697 -122.43842033004299 (37.7095952724697, -122.438420330043)
10981 1860 3 75 2500 Bay Shore Blvd 4 11 1 2     6 6   6010703.231369999 2086455.7019 37.709613762523205 -122.404761589082 (37.7096137625232, -122.404761589082)
10337 1859 3 75 2500 Bay Shore Blvd 3 11 1 2     18 6   6010721.136519999 2086497.1887700001 37.7097286779125 -122.404702624138 (37.7097286779125, -122.404702624138)
11400 1858 3 75 2500 Bay Shore Blvd 2 11 1 2     12 6   6010736.7682300005 2086529.19155 37.709817424799 -122.404650849269 (37.709817424799, -122.404650849269)
13013 1304 3 11 4000X Alemany Blvd 12 11 1 2     35 10   5991645.96929 2086939.8139900002 37.7098594231521 -122.470661434599 (37.7098594231521, -122.470661434599)
11567 1857 3 75 2500 Bay Shore Blvd 1 11 1 2     12 6   6010751.52595 2086559.13987 37.7099004816803 -122.404601950438 (37.7099004816803, -122.404601950438)
13003 24273 3 3 350X Winding Way 11 11 1 2     12 8   6000864.27338 2086762.8945799998 37.7099024017335 -122.43878866537399 (37.7099024017335, -122.438788665374)
11332 1303 3 11 4000X Alemany Blvd 11 11 1 2     45 10   5991684.008830001 2086976.4673900001 37.709962264210404 -122.47053263188299 (37.7099622642104, -122.470532631883)
10951 24278 3 5 350X Winding Way 16 11 1 2     6 8   6000808.42529 2086790.5767400002 37.709975233345 -122.438983668972 (37.709975233345, -122.438983668972)
12225 24277 3 5 350X Winding Way 15 11 1 2     6 8   6000814.16949 2086790.4577099998 37.709975233345496 -122.43896380743999 (37.7099752333455, -122.43896380744)
23244 24275 3 3 350X Winding Way 13 11 1 2     38 8   6000843.90644 2086792.8315400002 37.709983443260995 -122.438861201091 (37.709983443261, -122.438861201091)
13219 24279 3 1 350X Winding Way 17 11 1 2     6 8   6000809.6312 2086798.35513 37.709996659695 -122.43898005820299 (37.709996659695, -122.438980058203)
12496 24276 3 38 350X Winding Way 14 11 1 2     6 8   6000825.35085 2086800.6303 37.710003801206796 -122.438925891137 (37.7100038012068, -122.438925891137)
11821 24274 3 26 350X Winding Way 12 11 1 2     6 8   6000860.34882 2086800.42556 37.710005230221 -122.438804917029 (37.710005230221, -122.438804917029)
90771 98853 3 11 4043X Alemany Blvd 1 11 1 2           5991835.94326 2086997.82238 37.710029684074 -122.470009076276 (37.710029684074, -122.470009076276)
143078 121420 3 38 1155x Prague St 1 11 1 2       3x3   6000780.0 2086820.0 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343)
11290 1302 3 2 4000X Alemany Blvd 10 11 1 2     25 10   5991739.11571 2087020.66511 37.7100868068254 -122.470345390352 (37.7100868068254, -122.470345390352)
188789 1301 3 60 4000X Alemany Blvd 9 11 1 2     32 10   5991772.09471 2087046.42932 37.7101594558675 -122.470233284447 (37.7101594558675, -122.470233284447)
12049 1300 3 11 4000X Alemany Blvd 8 11 1 2     25 10   5991824.5048400005 2087077.28239 37.7102472009077 -122.470054391311 (37.7102472009077, -122.470054391311)
86585 1862 3 114 2510 Bay Shore Blvd 6 11 1 2     12 6   6010780.8257042 2086709.3373148 37.710314531205896 -122.404511250175 (37.7103145312059, -122.404511250175)
87252 1861 3 114 2510 Bay Shore Blvd 5 11 1 2     6 6   6010780.8257042 2086709.3373148 37.710314531205896 -122.404511250175 (37.7103145312059, -122.404511250175)
10821 1299 3 39 4000X Alemany Blvd 7 11 1 2     40 10   5991881.88808 2087114.90346 37.7103538164401 -122.46985880224301 (37.7103538164401, -122.469858802243)
10727 1298 3 39 4000X Alemany Blvd 6 11 1 2     25 10   5991889.9079 2087118.85792 37.7103651380077 -122.46983137204599 (37.7103651380077, -122.469831372046)
11437 1297 3 39 4000X Alemany Blvd 5 11 1 2     25 10   5991899.37983 2087126.21827 37.7103858952584 -122.46979917089199 (37.7103858952584, -122.469799170892)
10785 1296 3 39 4000X Alemany Blvd 4 11 1 2     35 10   5991907.39965 2087130.17274 37.710397216839496 -122.46977174067499 (37.7103972168395, -122.469771740675)
10299 1295 3 39 4000X Alemany Blvd 3 11 1 2     25 10   5991914.74417 2087134.82891 37.710410426081 -122.46974669545901 (37.710410426081, -122.469746695459)
106367 1854 3 40 2500 Bay Shore Blvd 1 11 1 2     12 6   6010837.5147418 2086759.4488696998 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881)
138313 1855 3 40 2500 Bay Shore Blvd 2 11 1 2     3 6   6010837.5147418 2086759.4488696998 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881)
139020 1856 3 114 2500 Bay Shore Blvd 3 11 1 2     12 6   6010837.5147418 2086759.4488696998 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881)
12006 1294 3 36 4000X Alemany Blvd 2 11 1 2     25 10   5991953.08243 2087152.92109 37.7104623187479 -122.469615507754 (37.7104623187479, -122.469615507754)
10605 1293 3 36 4000X Alemany Blvd 1 11 1 2     50 10   5991961.87152 2087160.6390900002 37.7104840184951 -122.46958569253701 (37.7104840184951, -122.469585692537)
12362 15901 3 41 5600 Mission St 1 11 1 2   03/10/1995 12:00:00 AM 6 20   5998236.34112 2087033.73083 37.710496198018 -122.447890739788 (37.710496198018, -122.447890739788)
10954 15902 3 37 5600 Mission St 2 11 1 2   03/23/1995 12:00:00 AM 6 TR20   5998238.99709 2087038.7453700001 37.7105101186185 -122.447881921009 (37.7105101186185, -122.447881921009)
42138 181261 3 75 2400x Bay Shore Blvd 6 11 1 2     15 Width 6ft   6010896.06222 2086791.14453 37.710545596879705 -122.40411872042299 (37.7105455968797, -122.404118720423)
13018 15903 3 41 5600 Mission St 3 11 1 2   06/01/1992 12:00:00 AM 6 TR20   5998269.83738 2087060.55751 37.7105717725495 -122.44777690001101 (37.7105717725495, -122.447776900011)
11532 15904 3 37 5600 Mission St 4 11 1 2   03/10/1995 12:00:00 AM 6 TR20   5998273.75241 2087065.5939900002 37.7105858253457 -122.44776373121 (37.7105858253457, -122.44776373121)
11509 15905 3 37 5600 Mission St 5 11 1 2   07/13/1994 12:00:00 AM 12 TR20   5998282.5187800005 2087066.12192 37.71058777596279 -122.44773347081998 (37.7105877759628, -122.44773347082)
10548 15906 3 37 5600 Mission St 6 11 1 2   03/23/1995 12:00:00 AM 3 TR20   5998281.91295 2087072.66875 37.7106057174457 -122.447736035688 (37.7106057174457, -122.447736035688)
12577 15907 3 37 5600 Mission St 7 11 1 2   03/23/1995 12:00:00 AM 3 TR20   5998292.86326 2087073.3238400002 37.7106081420281 -122.447698236291 (37.7106081420281, -122.447698236291)
10887 15908 3 37 5600 Mission St 8 11 1 2   06/01/1992 12:00:00 AM 3 TR20   5998294.210469999 2087081.2429799999 37.7106299631863 -122.447694149767 (37.7106299631863, -122.447694149767)
57972 181260 3 75 2400x Bay Shore Blvd 5 11 1 2     15 Width 6ft   6010918.05044 2086828.8185599998 37.7106502707697 -122.40404537351601 (37.7106502707697, -122.404045373516)
44652 181259 3 75 2400x Bay Shore Blvd 4 11 1 2     15 Width 6ft   6010937.034659999 2086861.99587 37.710742429686206 -122.40398209272499 (37.7107424296862, -122.403982092725)
27734 181258 3 75 2400x Bay Shore Blvd 3 11 1 2     15 Width 6ft   6010956.04386 2086896.41565 37.7108380015362 -122.403918812817 (37.7108380015362, -122.403918812817)
29208 181257 3 75 2400x Bay Shore Blvd 2 11 1 2     15 Width 6ft   6010977.11587 2086929.96483 37.7109312981009 -122.40384834192801 (37.7109312981009, -122.403848341928)
150822 181256 3 75 2400x Bay Shore Blvd 1 11 1 2     15 Width 6ft   6010998.20467 2086964.34233 37.7110268699605 -122.40377787107799 (37.7110268699605, -122.403777871078)
9112 122861 3 51 3000X Alemany Blvd 8 11 1 2   12/08/2016 01:43:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9209 122858 3 51 3000X Alemany Blvd 5 11 1 2   12/08/2016 01:48:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9268 122855 3 51 3000X Alemany Blvd 2 11 1 2   12/08/2016 01:30:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9272 122860 3 51 3000X Alemany Blvd 7 11 1 2   12/08/2016 01:54:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9280 122859 3 51 3000X Alemany Blvd 6 11 1 2   12/08/2016 01:46:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9291 122856 3 51 3000X Alemany Blvd 3 11 1 2   12/08/2016 01:13:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9327 122854 3 51 3000X Alemany Blvd 1 11 1 2   12/08/2016 01:40:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9354 122862 3 51 3000X Alemany Blvd 9 11 1 2   12/08/2016 01:57:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9406 122857 3 51 3000X Alemany Blvd 4 11 1 2   12/08/2016 01:17:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
77993 12500 3 47 1200X Lake Merced Blvd 2 11 1 2     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
88191 12503 3 105 1200X Lake Merced Blvd 5 11 1 2     12 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
Powered by Datasette · Query took 31.461ms · Data source: data.sfgov.org