sf-trees

Data source: data.sfgov.org

Custom SQL query returning 65 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
114948 113440 7 47 190 BEACON ST   13 1 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
1398 251517 2 47 145 Bonview St 1 13 1 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
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)
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)
1650 251608 6 47 56R Amber Dr 1 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)
4447 253626 7 47 1671 Funston Ave 1 13 1 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
10255 112606 2 47 100X Monument Way 1 13 1 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
22926 251147 2 47 113x Gladeview Way 1 13 1 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
30020 218148 2 47 35 Ashton Ave 1 13 1 1     25     5994122.86099 2090034.3755400002 37.7184992748049 -122.462325196761 (37.7184992748049, -122.462325196761)
44939 223816 2 47 1 Ohlone Way 1 13 1 1     45 Width 5ft   6002135.08017 2096585.1811900001 37.7369444095655 -122.435098574335 (37.7369444095655, -122.435098574335)
46680 249916 2 47 358 Greenwich St 1 13 1 1     20 Width 0ft   6011201.85513 2120410.11068 37.8028728976405 -122.40542793096901 (37.8028728976405, -122.405427930969)
60877 250194 2 47 18 Alta St 1 13 1 1     3 Width 0ft   6011773.11718 2119954.14642 37.8016528548612 -122.403418962409 (37.8016528548612, -122.403418962409)
84088 103516 7 47 980 Green St 1 13 1 1           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445)
88993 121199 7 47 72 Fountain St 1 13 1 1           6000322.0 2101283.0 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556)
105403 105236 7 47 235X STATES ST 1 13 1 1     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
122672 102060 5 47 115 Kensington Way 1 13 1 1           5994908.3 2098325.8 37.741310707397396 -122.460210667073 (37.7413107073974, -122.460210667073)
123752 95982 6 47 100 Vasquez Ave 1 13 1 1           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972)
124625 111763 9 47 2626 Vallejo St 1 13 1 1           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268)
139657 117644 7 47 1111X SANSOME ST 1 13 1 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
140844 102706 7 47 1342 Funston Ave 1 13 1 1           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645)
144877 120110 2 47 90X Knollview Way 1 13 1 1     20 3x25   5997618.0 2101448.0 37.750038994650396 -122.45106661992399 (37.7500389946504, -122.451066619924)
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)
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)
1637 251619 6 47 72R Amber Dr 2 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)
1641 251627 2 47 2R Amethyst Way 2 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)
1651 251609 6 47 56R Amber Dr 2 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
5091 253769 5 47 100 Raccoon Dr 2 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
132547 249917 2 47 358 Greenwich St 2 13 1 1     10 Width 0ft   6011197.83082 2120409.77535 37.802871751897 -122.405441833595 (37.802871751897, -122.405441833595)
176884 218149 2 47 35 Ashton Ave 2 13 1 1     12     5994121.0220800005 2090034.4141 37.7184992747921 -122.462331555861 (37.7184992747921, -122.462331555861)
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)
1629 251631 6 47 8R Amethyst Way 3 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1632 251628 6 47 2R Amethyst Way 3 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1638 251620 2 47 72R Amber Dr 3 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)
51446 249918 2 47 358 Greenwich St 3 13 1 1     20 Width 0ft   6011195.29362 2120394.33345 37.8028292103611 -122.405449525493 (37.8028292103611, -122.405449525493)
61253 218150 2 47 35 Ashton Ave 3 13 1 1     8     5994126.47455 2090031.2465099997 37.7184908913149 -122.46231247944999 (37.7184908913149, -122.46231247945)
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)
1631 251621 6 47 72R Amber Dr 4 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
74458 249919 2 47 358 Greenwich St 4 13 1 1     14 Width 0ft   6011190.2403 2120395.87946 37.8028331727783 -122.405467121607 (37.8028331727783, -122.405467121607)
161920 218151 2 47 35 Ashton Ave 4 13 1 1     19     5994130.74614 2090030.24083 37.7184883759248 -122.46229764153799 (37.7184883759248, -122.462297641538)
1640 251622 2 47 72R Amber Dr 5 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
187617 249716 2 47 2975 Broadway 5 13 1 1     7     5999444.23089 2116975.8695799997 37.7927789735145 -122.44586807365 (37.7927789735145, -122.44586807365)
76467 249921 2 47 358 Greenwich St 6 13 1 1     10 Width 0ft   6011183.71747 2120405.40754 37.8028589698347 -122.40549036550101 (37.8028589698347, -122.405490365501)
170870 249922 2 47 358 Greenwich St 7 13 1 1     18 Width 0ft   6011172.25119 2120397.10621 37.802835535282604 -122.405529459923 (37.8028355352826, -122.405529459923)
179841 249924 2 47 358 Greenwich St 8 13 1 1     12 Width 0ft   6011171.36702 2120411.09017 37.802873882370896 -122.405533505089 (37.8028738823709, -122.405533505089)
156630 249923 2 47 358 Greenwich St 9 13 1 1     33 Width 0ft   6011163.06331 2120405.05222 37.8028568393309 -122.40556181483801 (37.8028568393309, -122.405561814838)
176394 249925 2 47 358 Greenwich St 10 13 1 1     14 Width 0ft   6011155.36985 2120409.86411 37.802869621408796 -122.40558877741002 (37.8028696214088, -122.40558877741)
176393 249926 2 47 358 Greenwich St 11 13 1 1     24 Width 0ft   6011142.49576 2120408.96257 37.8028664261111 -122.405633265077 (37.8028664261111, -122.405633265077)
24155 249927 2 47 358 Greenwich St 12 13 1 1     31 Width 0ft   6011132.35015 2120388.99651 37.8028110368738 -122.40566696715099 (37.8028110368738, -122.405666967151)
Powered by Datasette · Query took 6.977ms · Data source: data.sfgov.org