sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
125 119758 2 22 151X Octavia St Frontage West 1 1 1 1                    
142 251241 2 34 2305 Golden Gate Ave 1 1 1 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
168 179480 2 25 100 Serrano Dr 1 2 1 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
171 251242 2 34 2449 Golden Gate Ave 1 5 1 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
549 251321 2 47 100X Monument Way 1 14 1 1                    
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)
692 176334 2 103 287 Hester Ave 7 17 1 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
701 176335 2 103 287 Hester Ave 5 17 1 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
810 212202 2 60 800 Bosworth St 10 9 1 1     13     6001677.26505 2095571.4535400001 37.734134940976 -122.43660890297501 (37.734134940976, -122.436608902975)
959 83601 2 11 1 Jones St 1 1 1 1 1 04/22/2008 12:00:00 AM 5     6009088.96788 2112689.1650900003 37.7815547005346 -122.41219362785499 (37.7815547005346, -122.412193627855)
1060 71174 2 58 1432 Santiago St 1 1 1 1 1 07/22/1995 12:00:00 AM 3     5988368.0802 2099689.3718 37.7446763519612 -122.48292408536301 (37.7446763519612, -122.482924085363)
1069 80004 2 61 881 44th Ave 1 1 1 1 1 05/01/2017 12:00:00 AM 3   Permit Number 779791 5982299.17664 2109781.12407 37.772030443625795 -122.504656395048 (37.7720304436258, -122.504656395048)
1262 251479 2 1 1214 29th Ave 3 1 1 1         Permit Number 779194 5987090.84961 2106996.2792700003 37.7646647351899 -122.48787719677 (37.7646647351899, -122.48787719677)
1387 250572 2 34 600 Parker Ave 9 9 1 1   05/15/2017 12:00:00 AM 3   Permit Number 779711 5997267.39343 2111112.94332 37.7765563945078 -122.45297659119 (37.7765563945078, -122.45297659119)
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1605 251634 2 47 14R Amethyst Way 3 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1618 251611 2 47 56R Amber Dr 4 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 2 47 64R Amber Dr 4 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1624 251624 2 47 76R Amber Dr 2 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1625 251623 2 47 76R Amber Dr 1 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 2 47 18R Amethyst Way 1 13 1 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1638 251620 2 47 72R Amber Dr 3 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1639 251615 2 47 64R Amber Dr 2 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1640 251622 2 47 72R Amber Dr 5 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1641 251627 2 47 2R Amethyst Way 2 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1643 251614 2 47 64R Amber Dr 1 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
2153 251201 2 2 2000X Market St 1 5 1 1   06/27/2017 12:00:00 AM 3   Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2567 252819 2 55 407 Miguel St 1 2 1 1   07/19/2017 12:00:00 AM 3   Permit Number 780051 6004479.0 2096413.0 37.736604456337105 -122.426982337456 (37.7366044563371, -122.426982337456)
2593 155952 2 16 35 Manor Dr 1 9 1 1   07/20/2017 12:00:00 AM 3     5993448.18795 2093194.64055 37.7271377226027 -122.464886627823 (37.7271377226027, -122.464886627823)
2683 71631 2 25 678 36th Ave 1 1 1 1 1 07/26/2017 12:00:00 AM 3   Permit Number 780356 5984775.35157 2111233.16415 37.776162677429205 -122.496198392825 (37.7761626774292, -122.496198392825)
2713 109887 2 190 1024 Pacific Ave 1 1 1 1     10     6009193.94635 2118049.36414 37.796278400188704 -122.412209406439 (37.7962784001887, -122.412209406439)
3028 191362 2 195 999 Key Ave 2 2 1 1     27     6013336.3333 2089743.8780099999 37.718789267498295 -122.39589132571999 (37.7187892674983, -122.39589132572)
3029 193472 2 196 1059 Jamestown Ave 1 2 1 1     8     6013665.43892 2089838.8488900003 37.719068342415596 -122.39476037791599 (37.7190683424156, -122.394760377916)
3031 78440 2 177 953 Key Ave 1 7 1 1   01/12/2002 12:00:00 AM 31     6013574.75289 2089557.5945599999 37.7182910313742 -122.395054157617 (37.7182910313742, -122.395054157617)
3033 253285 2 141 8245 Geary Blvd 1 2 1 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
3040 189089 2 74 1033 Le Conte Ave 2 2 1 1     6     6012956.43123 2089677.63232 37.718586227543504 -122.397199861797 (37.7185862275435, -122.397199861797)
3044 253288 2 47 650 Peru Ave 4 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3046 253289 2 47 650 Peru Ave 5 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3049 253290 2 47 650 Peru Ave 6 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3050 253291 2 47 650 Peru Ave 7 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3068 253294 2 198 840x Sacramento St 2 5 1 1           6010611.0 2116923.0 37.793265087793294 -122.407226643637 (37.7932650877933, -122.407226643637)
3072 253293 2 198 840x Sacramento St 1 5 1 1           6010611.0 2116923.0 37.793265087793294 -122.407226643637 (37.7932650877933, -122.407226643637)
3112 253318 2 47 2 Euclid Ave 16 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3113 253332 2 47 2 Euclid Ave 27 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3115 253329 2 47 2 Euclid Ave 24 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3116 253328 2 47 2 Euclid Ave 23 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3119 253313 2 47 2 Euclid Ave 11 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3120 253308 2 47 2 Euclid Ave 6 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3121 253303 2 47 2 Euclid Ave 1 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3122 253323 2 47 2 Euclid Ave 21 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3123 253306 2 47 2 Euclid Ave 4 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3125 253309 2 47 2 Euclid Ave 7 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3127 253316 2 47 2 Euclid Ave 14 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3128 253330 2 47 2 Euclid Ave 25 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3129 253317 2 47 2 Euclid Ave 15 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3130 253319 2 47 2 Euclid Ave 17 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3131 253310 2 47 2 Euclid Ave 8 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3133 253333 2 47 2 Euclid Ave 28 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3135 253335 2 47 2 Euclid Ave 30 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3136 253320 2 47 2 Euclid Ave 18 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3139 253322 2 47 2 Euclid Ave 20 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3140 253334 2 47 2 Euclid Ave 29 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3141 253311 2 47 2 Euclid Ave 9 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3143 253336 2 47 2 Euclid Ave 31 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3145 253304 2 47 2 Euclid Ave 2 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3146 253314 2 47 2 Euclid Ave 12 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3148 253327 2 47 2 Euclid Ave 22 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3150 253331 2 47 2 Euclid Ave 26 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3151 253312 2 47 2 Euclid Ave 10 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3152 253307 2 47 2 Euclid Ave 5 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3153 253315 2 47 2 Euclid Ave 13 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3155 253305 2 47 2 Euclid Ave 3 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3156 253321 2 47 2 Euclid Ave 19 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3257 253379 2 10 899 Waller St 1 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3262 253382 2 10 899 Waller St 4 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3269 253386 2 142 726 El Camino Del Mar 1 8 1 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
3270 253380 2 10 899 Waller St 2 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3271 253381 2 10 899 Waller St 3 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3272 253387 2 142 726 El Camino Del Mar 2 8 1 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
3279 253383 2 10 899 Waller St 5 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3284 253385 2 53 1100 Golden Gate Ave 1 7 1 1           6004275.0 2112509.0 37.780788718892204 -122.428834805692 (37.7807887188922, -122.428834805692)
3494 106527 2 60 2100 Baker St 3 1 1 1     15     5999890.2062099995 2116153.78918 37.7905472114236 -122.444265881958 (37.7905472114236, -122.444265881958)
3530 123324 2 12 798 05th Ave 2 9 1 1     13   Permit Number 780721 5994466.95086 2110266.43708 37.7740712286384 -122.462602639066 (37.7740712286384, -122.462602639066)
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3579 123325 2 12 798 05th Ave 1 9 1 1     12   Permit Number 780721 5994467.5512 2110242.48836 37.7740055063811 -122.46259882484101 (37.7740055063811, -122.462598824841)
3610 115725 2 198 250X Octavia St 2 17 1 5                    
3804 253558 2 143 1240 Wisconsin St 1 7 1 1           6012830.0 2101639.0 37.7514226163546 -122.39847574638901 (37.7514226163546, -122.398475746389)
4004 251722 2 26 18 Lobos St 2 2 1 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
4008 216051 2 12 48 Lobos St 1 2 1 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4014 216033 2 26 4 Lobos St 1 2 1 1   10/05/2017 03:13:00 PM 3     5996833.19651 2088697.5304900003 37.7149843051513 -122.452860296276 (37.7149843051513, -122.452860296276)
4026 216034 2 26 8 Lobos St 1 2 1 1   10/05/2017 03:11:00 PM 3     5996778.28459 2088695.06883 37.714974399131705 -122.45304991653099 (37.7149743991317, -122.453049916531)
4027 253600 2 21 865 El Camino Del Mar 1 5 1 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
4030 216055 2 12 52 Lobos St 3 2 1 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4041 253601 2 21 865 El Camino Del Mar 2 5 1 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
4092 216045 2 12 36 Lobos St 2 2 1 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4097 216058 2 12 58 Lobos St 1 2 1 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
4103 216046 2 12 38 Lobos St 1 2 1 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
Powered by Datasette · Query took 102.775ms · Data source: data.sfgov.org