sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
114 251216 6 1 399X Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 6 1 399X Townsend St 2 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
13301 187651 6 1 175 Raccoon Dr 1 13 1 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
78781 121184 6 1 1000x Duncan St 5 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
79242 121190 6 1 1000x Duncan St 11 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
80352 121187 6 1 1000x Duncan St 8 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
89056 121188 6 1 1000x Duncan St 9 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
90930 121191 6 1 1000x Duncan St 12 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91506 121193 6 1 1000x Duncan St 14 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91613 88453 6 1 2801 Oakdale Ave 2 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
93028 115827 6 1 60X CHUMASERO DR 1 5 1 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
93352 112398 6 1 246 CRESCENT AVE 1 2 1 1           6006552.0 2095759.0 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192)
95270 121186 6 1 1000x Duncan St 7 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
100978 121192 6 1 1000x Duncan St 13 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
102326 104898 6 1 310 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
102605 121181 6 1 1000x Duncan St 2 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
102950 105540 6 1 2694 47TH AVE 1 7 1 1     12     5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
104617 121185 6 1 1000x Duncan St 6 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104788 121183 6 1 1000x Duncan St 4 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
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)
107866 112769 6 1 1X HOWTH ST 1 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
109657 98303 6 1 6 Locksley Ave 3 7 1 1           5994194.0 2104902.7 37.7593280901784 -122.463157548093 (37.7593280901784, -122.463157548093)
111205 112771 6 1 1X HOWTH ST 3 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111585 88455 6 1 2801 Oakdale Ave 4 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
111811 112770 6 1 1X HOWTH ST 2 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
112482 112773 6 1 1X HOWTH ST 5 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
115212 112774 6 1 1X HOWTH ST 6 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
118620 104908 6 1 500 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
119856 85365 6 1 66 Clarendon Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.758871479144396 -122.45053809231199 (37.7588714791444, -122.450538092312)
121815 112772 6 1 1X HOWTH ST 4 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
123005 121182 6 1 1000x Duncan St 3 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
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)
143633 121087 6 1 1443 47th Ave 1 1 1 1       3x3 Permit Number 778784 5981521.320719999 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719)
3811 177743 6 2 401 Ocean Ave 4 9 1 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
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)
11570 174950 6 2 309 Crestlake Dr 1 1 1 1       3x3   5987294.0 2096147.0 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564)
80217 92320 6 2 2733 Wawona St 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5984522.0 2096783.0 37.736471699686206 -122.49600850837099 (37.7364716996862, -122.496008508371)
89532 112366 6 2 2224 Baker St 1 8 1 1       3x3 Permit Number 775823 5999858.5 2116547.8 37.791627252722 -122.444403911295 (37.791627252722, -122.444403911295)
96972 120593 6 2 499x Ocean Ave 4 1 1 6     34 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
99263 101435 6 2 600X Grant Ave 1 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
102016 105368 6 2 180 CLIFFORD TER   1 1 1           5999283.1 2106587.2 37.7642451591147 -122.44567816768298 (37.7642451591147, -122.445678167683)
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)
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)
128404 101438 6 2 600X Grant Ave 3 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
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)
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
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)
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1708 251660 6 3 1050 North Point St 4 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1710 251657 6 3 1050 North Point St 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
2760 251575 6 3 300 Sussex St 1 2 1 1   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194.0 2096647.0 37.737060666835205 -122.438356728037 (37.7370606668352, -122.438356728037)
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)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3147 253098 6 3 1290 Portola Dr 2 9 1 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3799 178336 6 3 401 Ocean Ave 2 9 1 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
3803 178335 6 3 401 Ocean Ave 1 9 1 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
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)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
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)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9883 173726 6 3 1101 Connecticut St 1 7 1 1           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345)
9985 120925 6 3 3995X Alemany Blvd 8 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9986 1263 6 3 3995X Alemany Blvd 3 5 1 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9994 120923 6 3 3995X Alemany Blvd 6 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9998 120931 6 3 3995X Alemany Blvd 14 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 6 3 3995X Alemany Blvd 5 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10004 114140 6 3 1200X JUNIPERO SERRA BLVD 5 17 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10006 120927 6 3 3995X Alemany Blvd 10 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10015 120928 6 3 3995X Alemany Blvd 11 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
Powered by Datasette · Query took 11.761ms · Data source: data.sfgov.org