sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1605 251634 2 47 14R Amethyst Way 3 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 6 108 44R Amber Dr 1 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1608 251603 6 47 44R Amber Dr 2 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 6 108 48R Amber Dr 2 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
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)
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
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)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1629 251631 6 47 8R Amethyst Way 3 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1631 251621 6 47 72R Amber Dr 4 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1632 251628 6 47 2R Amethyst Way 3 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1637 251619 6 47 72R Amber Dr 2 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
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)
1645 251626 6 47 2R Amethyst Way 1 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1646 251633 6 47 14R Amethyst Way 2 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1650 251608 6 47 56R Amber Dr 1 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1651 251609 6 47 56R Amber Dr 2 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1654 251610 6 47 56R Amber Dr 3 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
2502 253119 5 3 185 Belgrave Ave 1 13 1 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
3835 253567 5 218 25 Raycliff Ter 1 13 1 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
4922 253717 6 105 4101 Balboa St 1 13 1 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
5091 253769 5 47 100 Raccoon Dr 2 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
8592 121500 5 3 251X Pennsylvania Ave 1 13 1 2                    
10146 173882 2 3 201x Howth St 1 13 1 1           5997459.0 2090748.0 37.7206502603184 -122.450845024895 (37.7206502603184, -122.450845024895)
10223 173927 6 3 240 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13301 187651 6 1 175 Raccoon Dr 1 13 1 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
13315 187668 6 49 100x OGDEN AVE 4 13 1 1           6007659.0 2096105.0 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682)
19360 105328 6 17 2051 03rd St 2 13 1 1         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631)
20974 109568 6 116 95 Nordhoff St 1 13 1 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
22826 251117 7 212 2024 Castro St 1 13 1 1           6002622.0 2099601.0 37.7452527853239 -122.43363054854099 (37.7452527853239, -122.433630548541)
22866 251139 6 17 621X Gough St 1 13 1 1   03/10/2017 12:00:00 AM 3   Permit Number 779685          
25761 217537 2 224 89 Ralston St 1 13 1 1     18     5992163.635980001 2088434.33055 37.713992927605204 -122.468980989298 (37.7139929276052, -122.468980989298)
26205 195969 2 86 200 Tulare St 15 13 1 1     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)
26526 228904 2 11 902 Duboce Ave 1 13 1 1     6     6002231.23378 2108246.83249 37.7689699817064 -122.435600166732 (37.7689699817064, -122.435600166732)
27599 232417 2 1 173 Everson St 1 13 1 1     15     6002718.41885 2097663.27226 37.7399377058635 -122.433158722322 (37.7399377058635, -122.433158722322)
27650 239211 2 147 100 Hwy 101 Southbound 11 13 1 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
28143 87300 3 44 2323 Cesar Chavez St 2 13 1 2     6   Permit Number 50312 6011877.987480001 2100898.0514700003 37.749335051069004 -122.401715863223 (37.749335051069, -122.401715863223)
28419 108850 1 58 250x MONTCALM ST 1 13 1 1   02/09/2015 12:00:00 AM 3   Permit Number 774524 6009909.2 2099657.1 37.745817608401104 -122.40843648152 (37.7458176084011, -122.40843648152)
29851 210532 2 1 47 Ralston St 5 13 1 1     3     5992170.38695 2088246.7586700001 37.7134782905637 -122.46894401367099 (37.7134782905637, -122.468944013671)
30020 218148 2 47 35 Ashton Ave 1 13 1 1     25     5994122.86099 2090034.3755400002 37.7184992748049 -122.462325196761 (37.7184992748049, -122.462325196761)
30471 188564 2 5 300 Vermont St 4 13 1 1     21     6011131.87643 2106822.77201 37.7655613532939 -122.404712987912 (37.7655613532939, -122.404712987912)
31147 207112 2 38 59 Ralston St 4 13 1 1     12     5992171.746719999 2088295.8735200001 37.7136132266511 -122.46894288591899 (37.7136132266511, -122.468942885919)
31427 223996 2 287 100 Hwy 101 Southbound 23 13 1 1     18     6005945.0032 2108837.4935 37.770802030213105 -122.42279644320699 (37.7708020302131, -122.422796443207)
31601 195958 2 86 200 Tulare St 4 13 1 1     10     6015649.240619999 2100340.8983400003 37.7480149542299 -122.388635787013 (37.7480149542299, -122.388635787013)
31969 239194 2 147 101 Hwy 101 Northbound 6 13 1 1     3     6005943.751730001 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768)
32290 239198 2 147 101 Hwy 101 Northbound 10 13 1 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
32977 219173 2 322 47 Ralston St 3 13 1 1     14     5992177.27741 2088252.3205900001 37.71349396036 -122.46892060252199 (37.71349396036, -122.468920602522)
33201 195967 2 86 200 Tulare St 13 13 1 1     5     6015456.783980001 2100328.64296 37.747970635647 -122.389300444473 (37.747970635647, -122.389300444473)
33236 195970 2 86 200 Tulare St 16 13 1 1     8     6015399.1088 2100325.42161 37.747958592828205 -122.389499659601 (37.7479585928282, -122.389499659601)
34117 237115 2 18 100 Hwy 101 Southbound 6 13 1 1     6     6005846.05822 2108984.84199 37.7712010306339 -122.42314917169399 (37.7712010306339, -122.423149171694)
34603 249714 2 5 2975 Broadway 3 13 1 1     20     5999388.9274 2116973.5904200003 37.7927695576174 -122.446059261445 (37.7927695576174, -122.446059261445)
34830 239214 2 147 100 Hwy 101 Southbound 7 13 1 1     6     6005859.14445 2108978.35649 37.771183961488106 -122.423103444792 (37.7711839614881, -122.423103444792)
35242 249713 2 5 2975 Broadway 2 13 1 1     15     5999382.51554 2116973.87968 37.792769985700296 -122.446081467494 (37.7927699857003, -122.446081467494)
35303 249715 2 5 2975 Broadway 4 13 1 1     18     5999395.51836 2116974.38878 37.7927721260745 -122.44603651397 (37.7927721260745, -122.44603651397)
35375 239209 2 147 100 Hwy 101 Southbound 14 13 1 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
37767 211724 2 26 41 Ralston St 1 13 1 1     4     5992178.335940001 2088233.1934099998 37.71344150289679 -122.468915552827 (37.7134415028968, -122.468915552827)
38334 195966 2 86 200 Tulare St 12 13 1 1     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)
38350 239199 2 147 100 Hwy 101 Southbound 27 13 1 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
38396 195968 2 86 200 Tulare St 14 13 1 1     7     6015437.03514 2100327.8138099997 37.747967264084295 -122.389368677829 (37.7479672640843, -122.389368677829)
38627 210531 2 1 47 Ralston St 1 13 1 1     5     5992169.14182 2088256.46113 37.7135048592377 -122.46894902289 (37.7135048592377, -122.46894902289)
41322 211727 2 26 41 Ralston St 10 13 1 1     6     5992176.51123 2088212.22362 37.7133838194885 -122.468920334526 (37.7133838194885, -122.468920334526)
44635 239192 2 147 101 Hwy 101 Northbound 4 13 1 1     6     6005960.3562900005 2108991.91912 37.771226912211795 -122.422754312663 (37.7712269122118, -122.422754312663)
45069 126561 2 190 8 Codman Pl 2 13 1 1     7     6009832.93804 2117260.0663900003 37.7941470150322 -122.40994260678998 (37.7941470150322, -122.40994260679)
45307 239204 2 147 100 Hwy 101 Southbound 21 13 1 1     4     6005940.87649 2108850.7859900002 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426)
46092 195960 2 86 200 Tulare St 6 13 1 1     8     6015597.7328 2100337.72732 37.748003392560896 -122.38881367921302 (37.7480033925609, -122.388813679213)
47138 118572 2 32 7940 Geary Blvd 2 13 1 1     6     5982338.13373 2112440.49418 37.7793345882457 -122.50471872286 (37.7793345882457, -122.50471872286)
47848 209611 2 22 77 Ralston St 1 13 1 1     13     5992168.85342 2088365.8404 37.7138051716457 -122.468957974754 (37.7138051716457, -122.468957974754)
49336 87301 3 44 2323 Cesar Chavez St 3 13 1 2     5   Permit Number 50312 6011915.6161 2100899.61614 37.7493414470685 -122.401585851825 (37.7493414470685, -122.401585851825)
53610 104278 6 176 2 Allston Way 1 13 1 1           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974)
59360 207117 2 38 41 Ralston St 9 13 1 1     19     5992170.67066 2088214.0686700002 37.7133885481037 -122.46894065558399 (37.7133885481037, -122.468940655584)
59769 239203 2 147 100 Hwy 101 Southbound 22 13 1 1     3     6005946.44181 2108844.1649 37.7708204294492 -122.42279194121402 (37.7708204294492, -122.422791941214)
60490 239208 2 147 100 Hwy 101 Southbound 17 13 1 1     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484)
60639 191813 2 39 300 Vermont St 6 13 1 1     25     6011137.70759 2106686.95849 37.7651887659782 -122.40468325722901 (37.7651887659782, -122.404683257229)
60662 207115 2 38 47 Ralston St 8 13 1 1     8     5992168.43399 2088239.2563900002 37.7134575782774 -122.468950218099 (37.7134575782774, -122.468950218099)
60765 195957 2 86 200 Tulare St 3 13 1 1     12     6015667.37966 2100340.53223 37.7480149542209 -122.38857303683399 (37.7480149542209, -122.388573036834)
60806 96274 6 41 55@ Alemany Trumbull St 2 13 1 1     2     6004001.3006 2094332.0064299998 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086)
61226 239216 2 147 100 Hwy 101 Southbound 3 13 1 1     5     6005843.543219999 2109006.7344400003 37.771261000120504 -122.42315942758499 (37.7712610001205, -122.423159427585)
61253 218150 2 47 35 Ashton Ave 3 13 1 1     8     5994126.47455 2090031.2465099997 37.7184908913149 -122.46231247944999 (37.7184908913149, -122.46231247945)
62177 195962 2 86 200 Tulare St 8 13 1 1     9     6015556.6084199995 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422)
63607 191841 2 39 1501 Davidson Ave 9 13 1 1     23     6015067.74656 2099262.4877299997 37.7450216201491 -122.39057124226801 (37.7450216201491, -122.390571242268)
63852 239189 2 147 101 Hwy 101 Northbound 1 13 1 1     3     6005983.85034 2108958.2836700003 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046)
65300 111749 9 180 4124 23rd St 1 13 1 1           6002319.4 2102413.2 37.752957247271 -122.434877962118 (37.752957247271, -122.434877962118)
Powered by Datasette · Query took 6.065ms · Data source: data.sfgov.org