sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
511 251164 2 90 1215 Fairfax Ave 10 1 1 1   04/10/2017 01:46:00 PM 3 3x3   6017471.0 2096747.0 37.738247630240295 -122.382086185189 (37.7382476302403, -122.382086185189)
1124 29774 3 90 1100X Evans Ave 8 1 1 2   05/03/2017 12:44:00 PM 3 3x3   6018183.3236 2096672.8034 37.7380832156692 -122.37961814277901 (37.7380832156692, -122.379618142779)
2200 252931 2 90 71 Edgar Ave 1 1 1 1       3x3   5997064.0 2091155.0 37.7217451669512 -122.45223976154499 (37.7217451669512, -122.452239761545)
4901 18480 3 90 1298 Potrero Ave 1 1 1 2   10/31/2017 01:20:00 PM 3 3x3   6010561.39126 2101710.28558 37.751491708090896 -122.406325925618 (37.7514917080909, -122.406325925618)
9079 6769 1 90 1275 Fairfax Ave 14 1 1 1   12/27/2007 12:00:00 AM 3 3x3   6017217.4089567 2096970.3613046003 37.738846926957706 -122.382978527185 (37.7388469269577, -122.382978527185)
9121 85732 1 90 901 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988)
9231 6725 1 90 1200X Fairfax Ave 22 1 1 1   05/05/2008 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
9244 87452 1 90 601 Dolores St 4 1 1 1   04/28/2008 12:00:00 AM 4 3x3   6004976.0 2104871.0 37.7598562652774 -122.425865863079 (37.7598562652774, -122.425865863079)
9463 85733 1 90 901 Howard St 2 1 1 1   04/30/2007 12:00:00 AM 4 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988)
9834 6787 3 90 1360 Fairfax Ave 7 1 1 2   01/03/2017 06:55:00 AM 3 3x3   6016787.1910829 2097353.9213772 37.739876324716896 -122.384492742853 (37.7398763247169, -122.384492742853)
9977 5406 3 90 392 Dolores St 1 1 1 2   02/02/2012 12:00:00 AM 5 3x3   6004848.6988147 2106052.9215434 37.7630943465887 -122.42639029035401 (37.7630943465887, -122.426390290354)
13480 85599 3 90 1115 Palou Ave 1 1 1 2   03/07/2014 12:00:00 AM 3 3x3   6017434.0078 2093308.576 37.7288043549368 -122.38197498007798 (37.7288043549368, -122.381974980078)
14031 18353 4 90 480 Potrero Ave 2 1 1 1   04/02/2013 12:00:00 AM 3 3x3   6010310.709559999 2106111.3358 37.76356198052329 -122.407503071611 (37.7635619805233, -122.407503071611)
17657 18422 3 90 940 Potrero Ave 1 1 1 2   06/09/2016 06:57:00 AM 3 3x3   6010451.25485 2103753.05423 37.7570945357026 -122.406850749261 (37.7570945357026, -122.406850749261)
17773 18420 3 90 924 Potrero Ave 1 1 1 2   12/14/2013 12:00:00 AM 3 3x3   6010442.48956 2103839.41038 37.7573311599314 -122.406887149344 (37.7573311599314, -122.406887149344)
18377 93250 3 90 1050 Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004388.0 2102776.0 37.754070642695496 -122.42775019598 (37.7540706426955, -122.42775019598)
19158 5458 1 90 589 Dolores St 2 1 1 1   08/20/2009 12:00:00 AM 90 3x3   6004996.57492 2104960.58209 37.7601033992601 -122.42580108085801 (37.7601033992601, -122.425801080858)
21685 18423 3 90 952 Potrero Ave 1 1 1 2   11/20/2013 12:00:00 AM 3 3x3   6010455.30853 2103703.2834799998 37.75695810316021 -122.406833222372 (37.7569581031602, -122.406833222372)
21837 5348 1 90 200X Dolores St 1 1 1 1   07/22/2010 12:00:00 AM 12 3x3 Permit Number 53640 6004789.9063099995 2107160.01438 37.7661308355062 -122.426672475382 (37.7661308355062, -122.426672475382)
22956 103844 3 90 1541 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285)
22970 103849 3 90 1524 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
22978 103850 3 90 1524 Polk St 3 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
44178 91424 1 90 2112 15th St 4 1 1 1   09/26/2008 12:00:00 AM   3x3 Permit Number 52102 6003571.0 2107157.0 37.7660535712373 -122.430888215554 (37.7660535712373, -122.430888215554)
59156 87882 1 90 1771 North Point St 1 1 1 1   06/13/2008 12:00:00 AM 6 3x3 Permit Number 50853 6002283.00879 2120864.7759700003 37.8036185768076 -122.436324238766 (37.8036185768076, -122.436324238766)
66030 103847 3 90 1529 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006640.1 2116184.7 37.7910148670423 -122.42091380589399 (37.7910148670423, -122.420913805894)
77688 93269 3 90 1730 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004618.0 2098811.0 37.743196678206296 -122.42667246707799 (37.7431966782063, -122.426672467078)
78052 103838 3 90 900X O'Farrell St 5 1 1 2   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446)
79013 85727 1 90 1025 Howard St 1 1 1 1   05/16/2007 12:00:00 AM 3 3x3   6010365.0 2111820.0 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288)
80881 85815 1 90 1607 Howard St 2 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007663.0 2109095.0 37.7716058657462 -122.41687208779301 (37.7716058657462, -122.416872087793)
81232 93286 3 90 1283 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004502.0 2101425.0 37.7503675600759 -122.427259727267 (37.7503675600759, -122.427259727267)
81332 94246 1 90 2125 BRYANT ST 4 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
82006 32722 1 90 644 Hyde St 3 1 1 1   11/30/2011 12:00:00 AM 3 3x3 Permit Number 768334 6007901.48303797 2114768.35798987 37.7871969578975 -122.416449089052 (37.7871969578975, -122.416449089052)
82685 103874 3 90 1331 Polk St 2 1 1 2   11/01/2009 12:00:00 AM 3 3x3   6006716.3 2115545.2 37.7892632533111 -122.42060474068998 (37.7892632533111, -122.42060474069)
82865 93743 1 90 875 Howard St   1 1 1   03/29/2010 12:00:00 AM   3x3 Permit Number 53322 6011367.4 2112778.7 37.7819281242694 -122.40431760427 (37.7819281242694, -122.40431760427)
83075 93252 3 90 1070 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004394.0 2102659.0 37.753749727529396 -122.427721110855 (37.7537497275294, -122.427721110855)
83349 93300 3 90 589X Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004575.9 2105667.0 37.7620192734995 -122.427306317148 (37.7620192734995, -122.427306317148)
83591 94262 1 90 2850X 20th St 3 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.759260809864294 -122.409349258874 (37.7592608098643, -122.409349258874)
84159 85604 3 90 1261 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016687.610646 2093879.449725 37.7303306134548 -122.384595098105 (37.7303306134548, -122.384595098105)
84434 88753 1 90 990 Polk St 10 1 1 1   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284.0 37.785814090273796 -122.41966893082501 (37.7858140902738, -122.419668930825)
84499 103835 3 90 900X O'Farrell St 2 1 1 2   11/01/2009 12:00:00 AM 3 3x3   6006751.076230001 2113939.67696 37.78485684194221 -122.420370415446 (37.7848568419422, -122.420370415446)
84744 88349 1 90 100 Vienna St 1 1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183)
84828 93291 3 90 1065 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004445.0 2102697.0 37.753856951407705 -122.42754744828301 (37.7538569514077, -122.427547448283)
84975 93277 3 90 1565 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004670.9 2099777.3 37.7458529070189 -122.426558345234 (37.7458529070189, -122.426558345234)
85134 93273 3 90 1679 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004706.9 2099119.3 37.7440482251279 -122.42638702061701 (37.7440482251279, -122.426387020617)
85241 85828 3 90 875 Howard St 1 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
85581 93267 3 90 1550 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004563.0 2099865.0 37.746087610537295 -122.426937693393 (37.7460876105373, -122.426937693393)
85638 92584 1 90 445 Wawona St 7 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
85874 94260 1 90 2850X 20th St 1 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.759260809864294 -122.409349258874 (37.7592608098643, -122.409349258874)
85944 93266 3 90 1440 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004482.7 2100527.8 37.747902965476 -122.42726256538602 (37.747902965476, -122.427262565386)
86047 85812 1 90 1675 Howard St 3 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007516.0 2108769.0 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156)
86147 55564 1 90 1X CASELLI AVE 1 1 1 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50796 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
86562 103851 1 90 1524 Polk St 4 1 1 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
86667 85584 3 90 1512 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015354.897796 2094923.102787 37.7331224832721 -122.389275358402 (37.7331224832721, -122.389275358402)
87496 103843 3 90 1541 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285)
87716 93293 3 90 1049 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004440.0 2102791.0 37.7541147705659 -122.42757143594 (37.7541147705659, -122.42757143594)
87986 91094 1 90 3417X 18th St 6 1 1 1   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736.0 2105525.0 37.761751301646704 -122.41982527826299 (37.7617513016467, -122.419825278263)
88428 86595 3 90 2154 Bryant St 1 1 1 2   04/30/2007 12:00:00 AM 6 3x3   6009566.0 2104744.0 37.7597658751742 -122.409982265203 (37.7597658751742, -122.409982265203)
88557 85827 1 90 1345 Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008580.0 2110114.0 37.774455337270396 -122.413772211324 (37.7744553372704, -122.413772211324)
88751 92582 1 90 445 Wawona St 5 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
88852 93281 3 90 1465 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004562.0 2100365.0 37.747460438671105 -122.426976756198 (37.7474604386711, -122.426976756198)
89180 85698 3 90 640 Howard St 4 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.786122430176896 -122.39918531693199 (37.7861224301769, -122.399185316932)
89374 88771 1 90 461 Baker St 1 1 1 1   04/03/2015 12:00:00 AM 3 3x3 Permit Number 775199 6000624.0 2110522.0 37.7751256013752 -122.441322740074 (37.7751256013752, -122.441322740074)
90042 93288 3 90 1259 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004494.0 2101568.0 37.7507597523824 -122.42729757712601 (37.7507597523824, -122.427297577126)
90378 88350 1 90 100 Vienna St 2 1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183)
90783 92589 1 90 445 Wawona St 12 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
91134 85567 3 90 1274 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016640.49857 2093964.460415 37.730561430483796 -122.384763892339 (37.7305614304838, -122.384763892339)
91334 94243 1 90 2125 BRYANT ST 1 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
91361 91421 3 90 2112 15th St 1 1 1 1   09/26/2008 12:00:00 AM   3x3 Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 6003571.0 2107157.0 37.7660535712373 -122.430888215554 (37.7660535712373, -122.430888215554)
91448 93260 3 90 1250X Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004401.7 2101569.1 37.750757552311704 -122.427616837084 (37.7507575523117, -122.427616837084)
92111 29047 3 90 244 11th St 1 1 1 2   07/31/2012 12:00:00 AM 3 3x3   6008230.7231960995 2109406.8924959 37.7724941663121 -122.414930372766 (37.7724941663121, -122.414930372766)
92614 93258 3 90 1180X Church St 2 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004390.8 2101994.4 37.7519247103798 -122.42768482883699 (37.7519247103798, -122.427684828837)
93558 85578 3 90 1388 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016034.7263629995 2094416.0331849998 37.7317678372886 -122.386889636739 (37.7317678372886, -122.386889636739)
94013 93253 3 90 1070 Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004394.0 2102659.0 37.753749727529396 -122.427721110855 (37.7537497275294, -122.427721110855)
95708 103848 3 90 1524 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
96403 94244 1 90 2125 BRYANT ST 3 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
96738 85598 3 90 1101 Palou Ave 2 1 1 2   03/08/2014 12:00:00 AM 3 3x3   6017523.881587001 2093256.0516779998 37.728665096277204 -122.381660625783 (37.7286650962772, -122.381660625783)
96836 85833 3 90 875 Howard St 6 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
96859 85826 1 90 1399X Howard St 3 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.774014420128495 -122.414306166437 (37.7740144201285, -122.414306166437)
97097 88749 1 90 990 Polk St 6 1 1 1   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284.0 37.785814090273796 -122.41966893082501 (37.7858140902738, -122.419668930825)
97539 93284 3 90 1347 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004523.0 2101050.0 37.7493390847523 -122.427160399995 (37.7493390847523, -122.427160399995)
98187 434 3 90 890X Potrero Ave 1 1 1 2   12/14/2013 12:00:00 AM 3 3x3   6010425.429178201 2104052.7086425 37.7579158746071 -122.406961184613 (37.7579158746071, -122.406961184613)
98869 93275 3 90 1607 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004606.0 2099539.0 37.7451949208192 -122.42676579302 (37.7451949208192, -122.42676579302)
99054 88750 1 90 990 Polk St 7 1 1 1   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284.0 37.785814090273796 -122.41966893082501 (37.7858140902738, -122.419668930825)
99080 103792 1 90 1214 Polk St 2 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177)
99235 86637 3 90 2679 Bryant St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6009805.5318559995 2101750.09748 37.751558711569096 -122.40894259967101 (37.7515587115691, -122.408942599671)
99600 103846 3 90 1540 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006747.0 2116248.1 37.7911949727431 -122.42054843762399 (37.7911949727431, -122.420548437624)
99675 103845 3 90 1540 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006747.0 2116248.1 37.7911949727431 -122.42054843762399 (37.7911949727431, -122.420548437624)
100161 85559 3 90 980 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018187.977748999 2092810.8923689998 37.727479421244 -122.37933387198099 (37.727479421244, -122.379333871981)
100415 6784 1 90 1360 Fairfax Ave 4 1 1 1   03/10/2007 12:00:00 AM 4 3x3   6016787.1910829 2097353.9213772 37.739876324716896 -122.384492742853 (37.7398763247169, -122.384492742853)
100513 93282 3 90 1383 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004535.0 2100841.0 37.748765897796204 -122.42710401922199 (37.7487658977962, -122.427104019222)
100706 85720 1 90 1133 Howard St 2 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6009666.355548 2111144.506481 37.777345813652 -122.41008705150699 (37.777345813652, -122.410087051507)
100755 93259 3 90 1234 Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004459.0 2101704.0 37.7511311972424 -122.42742829765899 (37.7511311972424, -122.427428297659)
101173 94263 1 90 2850X 20th St 4 1 1 1   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.759260809864294 -122.409349258874 (37.7592608098643, -122.409349258874)
101720 93272 3 90 1689 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004632.0 2099057.0 37.7438729293821 -122.42664157265 (37.7438729293821, -122.42664157265)
102183 93254 3 90 1070 Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004394.0 2102659.0 37.753749727529396 -122.427721110855 (37.7537497275294, -122.427721110855)
102655 87857 1 90 1X CASELLI AVE 5 1 1 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50796 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
102730 93257 3 90 1180X Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004390.8 2101994.4 37.7519247103798 -122.42768482883699 (37.7519247103798, -122.427684828837)
102892 13103 1 90 1516 Lombard St 1 1 1 1   03/11/2008 12:00:00 AM 3 3x3   6005111.0 2119918.0 37.801179250916796 -122.426470375667 (37.8011792509168, -122.426470375667)
102897 87853 1 90 599 Moultrie St 1 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50764 6007684.0 2096571.0 37.7372189966792 -122.415912430403 (37.7372189966792, -122.415912430403)
103131 88442 1 90 1148 Treat Ave   1 1 1   07/11/2008 12:00:00 AM   3x3 Permit Number 51406 6008612.9 2101850.1 37.7517664174328 -122.413073954345 (37.7517664174328, -122.413073954345)
103470 103793 1 90 1214 Polk St 3 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177)
Powered by Datasette · Query took 2.692ms · Data source: data.sfgov.org