sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
63668 175754 2 20 12 Farragut Ave 1 1 1 1     4 Width 2ft   5997730.99268 2086963.4604 37.7102743532383 -122.449632264321 (37.7102743532383, -122.449632264321)
73248 54766 1 20 192 Nueva Ave 1 1 1 1   08/09/1972 12:00:00 AM 7   Permit Number 10615 6012860.29811 2087055.87455 37.7113820491125 -122.39734840011101 (37.7113820491125, -122.397348400111)
30579 175758 2 20 201 Tocoloma Ave 5 7 1 1     4     6012839.87945 2087571.5634599999 37.7127968922232 -122.397455115464 (37.7127968922232, -122.397455115464)
177203 175759 2 20 201 Tocoloma Ave 7 7 1 1     5     6012872.74847 2087577.73375 37.7128156646891 -122.397341941199 (37.7128156646891, -122.397341941199)
110263 52957 1 20 227 Ramsell St 1 1 1 1 1 08/03/2006 12:00:00 AM     Permit Number 48944 5992946.65383726 2088708.6513983002 37.714791356792 -122.46629453065701 (37.714791356792, -122.466294530657)
165896 84186 1 20 467 Campbell Ave 1 1 1 1   06/05/2008 12:00:00 AM 5 3x3 Permit Number 50687 6010581.884869999 2088390.3432099998 37.7149191133084 -122.40531713630101 (37.7149191133084, -122.405317136301)
41434 175767 2 20 0 Gonzalez Dr 1 2 1 1     13     5989494.93952 2089175.43765 37.7158732715029 -122.478259065526 (37.7158732715029, -122.478259065526)
24183 175768 2 20 0 Gonzalez Dr 2 2 1 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
154455 175771 2 20 0 Gonzalez Dr 4 2 1 1     5     5989791.935380001 2089208.15493 37.7159803412063 -122.477234910356 (37.7159803412063, -122.477234910356)
59851 175772 2 20 0 Gonzalez Dr 5 2 1 1     9     5989911.02174 2089222.5365 37.716026738112 -122.47682434649201 (37.716026738112, -122.476824346492)
24841 175769 2 20 0 Gonzalez Dr 1 2 1 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
154732 204656 2 20 201 Sargent St 1 4 1 1     12 Width 3ft   5993464.3561 2089166.2811200002 37.716077755750206 -122.464538359982 (37.7160777557502, -122.464538359982)
171701 175770 2 20 0 Gonzalez Dr 5 2 1 1     27     5989758.80887 2089246.54995 37.7160838423675 -122.477352214341 (37.7160838423675, -122.477352214341)
97932 175756 2 20 837 Paris St 1 1 1 1     14 Width 3ft   6000844.62416 2089035.80235 37.7161421822999 -122.439019362161 (37.7161421822999, -122.439019362161)
175761 204654 2 20 222 Ralston St 1 4 1 1     7 Width 3ft   5992216.41936 2089361.24223 37.7165410523041 -122.46886596240299 (37.7165410523041, -122.468865962403)
180214 175773 2 20 0 Gonzalez Dr 2 2 1 1     14     5990089.9017900005 2089410.48117 37.716553162587296 -122.476219779021 (37.7165531625873, -122.476219779021)
44057 175774 2 20 0 Gonzalez Dr 1 2 1 1     9     5990113.97654 2089437.91841 37.7166298945381 -122.47613856845 (37.7166298945381, -122.47613856845)
134307 204647 2 20 64 Montana St 1 1 1 1     6 Width 2ft   5996124.76777 2089322.40375 37.716659439069794 -122.455354045254 (37.7166594390698, -122.455354045254)
44691 175766 2 20 0 Gonzalez Dr 5 2 1 1     13     5989094.03032 2089506.27121 37.7167583770722 -122.47966897135001 (37.7167583770722, -122.47966897135)
110193 41345 1 20 733 Plymouth Ave 1 1 1 1   03/03/2000 12:00:00 AM     Permit Number 41999 5995888.07123287 2089420.5370121002 37.716915305937796 -122.4561792734 (37.7169153059378, -122.4561792734)
112096 51290 1 20 738 Capitol Ave 1 1 1 1   08/26/2004 12:00:00 AM     Permit Number 47662 5995079.16819472 2089446.39884805 37.716939850408394 -122.458977110473 (37.7169398504084, -122.458977110473)
82665 39219 1 20 347 Victoria St 1 1 1 1   11/30/1998 12:00:00 AM     Permit Number 40862 5993215.94072133 2089494.769314 37.7169653816902 -122.465420843024 (37.7169653816902, -122.465420843024)
32795 204648 2 20 733 Plymouth Ave 1 1 1 1     12 Width 2ft   5995892.41562 2089491.7886299998 37.71711119551271 -122.456169405709 (37.7171111955127, -122.456169405709)
34559 175753 2 20 755 London St 1 2 1 1     12     6000826.82092 2089512.30625 37.7174495420436 -122.439115030257 (37.7174495420436, -122.439115030257)
167088 175765 2 20 0 Gonzalez Dr 1 2 1 1     18     5988629.85447 2089774.3019599998 37.7174673468061 -122.481292995899 (37.7174673468061, -122.481292995899)
43337 204651 2 20 27 Majestic Ave 1 4 1 1     6 Width 3ft   5997399.75585 2089775.82239 37.7179774953307 -122.45097974552401 (37.7179774953307, -122.450979745524)
117199 51289 1 20 875 Capitol Ave 1 1 1 1   08/26/2004 12:00:00 AM     Permit Number 47661 5995029.72941729 2089837.87433116 37.718011907210204 -122.45917632673999 (37.7180119072102, -122.45917632674)
92664 39671 1 20 500 Orizaba Ave 2 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
99326 39673 1 20 500 Orizaba Ave 4 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
112900 39672 1 20 500 Orizaba Ave 3 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
127185 39670 1 20 500 Orizaba Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
50558 70268 2 20 656 Naples St 1 1 1 1 1 01/06/1996 12:00:00 AM 11     6002561.31186 2089826.6998700001 37.71841134000321 -122.43314215230801 (37.7184113400032, -122.433142152308)
35496 204653 2 20 131 Beverly St 1 9 1 1     4 Width 10ft   5991405.61668 2090064.78105 37.718425920692795 -122.47171971360599 (37.7184259206928, -122.471719713606)
82360 39674 1 20 510 Orizaba Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41060 5994056.62807806 2090013.39911729 37.718437864492394 -122.462552614145 (37.7184378644924, -122.462552614145)
67938 204649 2 20 508 Orizaba Ave 1 1 1 1     2 Width 2ft   5994044.084530001 2090032.62859 37.7184899416364 -122.46259736577 (37.7184899416364, -122.46259736577)
50710 72270 2 20 619 Vienna St 1 1 1 1 1 01/06/1996 12:00:00 AM 5     6002965.14713 2089877.08907 37.7185725974338 -122.431749858784 (37.7185725974338, -122.431749858784)
153820 108373 1 20 637 Naples St 1 1 1 1 1   1 3x3 Permit Number 773812 6002662.58132 2089906.96275 37.718637468222 -122.432797836946 (37.718637468222, -122.432797836946)
182698 108374 1 20 637 Naples St 2 1 1 1 1   1 3x3 Permit Number 773812 6002670.30203 2089919.45736 37.718672213540295 -122.432772041698 (37.7186722135403, -122.432772041698)
28372 204655 2 20 452 Victoria St 1 4 1 1     5 Width 3ft   5993265.60688 2090192.2995 37.7188834957636 -122.46529981143298 (37.7188834957636, -122.465299811433)
120200 47376 1 20 454 Victoria St 1 1 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45293 5993277.02762299 2090193.33113846 37.718886987019 -122.46526040964899 (37.718886987019, -122.465260409649)
4201 252891 2 20 300x Howth St 1 1 1 1   10/10/2017 04:13:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4203 252894 2 20 300x Howth St 4 1 1 1   10/10/2017 04:10:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4213 252892 2 20 300x Howth St 2 1 1 1   10/10/2017 04:08:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4246 252893 2 20 300x Howth St 3 1 1 1   10/10/2017 04:25:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4212 204652 2 20 324 Howth St 1 1 1 1   10/10/2017 03:45:00 PM 3 Width 3ft   5997137.29551 2090290.56774 37.719375836806705 -122.45192406695601 (37.7193758368067, -122.451924066956)
106583 46402 1 20 324 Howth St 1 1 1 1 1 03/05/2002 12:00:00 AM     Permit Number 44632 5997151.20329152 2090327.07955038 37.7194768863059 -122.451878625824 (37.7194768863059, -122.451878625824)
11500 66889 1 20 562 Vienna St 1 1 1 1   12/06/1991 12:00:00 AM 8 3x3 Permit Number 30203 6003132.96801 2090225.04515 37.7195375196183 -122.43119459394899 (37.7195375196183, -122.431194593949)
4291 252895 2 20 790x Mount Vernon Ave 1 1 1 1   10/10/2017 03:29:00 PM 3 3x3   5997282.0 2090432.0 37.719772464034904 -122.45143407539 (37.7197724640349, -122.45143407539)
86680 39663 1 20 901 Grafton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41054 5994040.07409456 2090558.08173508 37.719932478931796 -122.46264932396299 (37.7199324789318, -122.462649323963)
90504 39664 1 20 901 Grafton Ave 2 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41054 5994040.07409456 2090558.08173508 37.719932478931796 -122.46264932396299 (37.7199324789318, -122.462649323963)
4156 213178 1 20 629 Grafton Ave 1 1 1 1   10/06/2017 08:23:00 AM 3 Width 3ft Permit Number 20774 5994856.22066 2090552.89382 37.7199652039099 -122.45982783161502 (37.7199652039099, -122.459827831615)
181555 204650 2 20 254 Howth St 1 4 1 1     11 Width 3ft   5997292.004269999 2090577.4247599998 37.720172339354704 -122.451409977591 (37.7201723393547, -122.451409977591)
164499 204646 2 20 111 Ashton Ave 3 2 1 1     5 Width 3ft   5994133.91606 2090657.47285 37.7202107871682 -122.462332152117 (37.7202107871682, -122.462332152117)
107272 39648 1 20 111 Ashton Ave 1 1 1 1 1 05/25/2002 12:00:00 AM     Permit Number 41042 5994130.09830184 2090661.11089351 37.720220556524204 -122.462345612464 (37.7202205565242, -122.462345612464)
145840 39649 1 20 111 Ashton Ave 2 1 1 1   12/29/1998 12:00:00 AM 5 3x20 Permit Number 41042 5994130.09830184 2090661.11089351 37.720220556524204 -122.462345612464 (37.7202205565242, -122.462345612464)
136971 175757 2 20 500 Vienna St 3 1 1 1     4 Width 3ft   6003296.85898 2090487.74665 37.7202681261541 -122.43064681870199 (37.7202681261541, -122.430646818702)
54422 204645 2 20 111 Ashton Ave 1 1 1 1     6 Width 3ft   5994132.807630001 2090689.3393400002 37.7202982210683 -122.462338293601 (37.7202982210683, -122.462338293601)
103711 39650 1 20 114 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41043 5994182.55528924 2090689.21166175 37.7203007349832 -122.462166324336 (37.7203007349832, -122.462166324336)
38894 50846 1 20 500 Vienna St 1 1 1 1   04/08/2004 12:00:00 AM 5   Permit Number 47372 6003324.61709 2090530.54695 37.720387218868495 -122.430553920527 (37.7203872188685, -122.430553920527)
85541 30142 3 20 410X Mansell St 4 11 1 2     9 M   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
107581 39652 1 20 141 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41045 5994132.92951736 2090837.78725757 37.7207058303918 -122.462348633516 (37.7207058303918, -122.462348633516)
139952 39653 1 20 150 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41046 5994186.17432148 2090915.05015887 37.7209210416097 -122.462170184545 (37.7209210416097, -122.462170184545)
80689 106706 2 20 199X BRIGHTON AVE 2 1 1 1     10 3x3   5996224.0 2090880.0 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447)
65031 204644 2 20 150 Ashton Ave 1 1 1 1     4 Width 3ft   5994179.89282 2090937.7889 37.7209831150476 -122.46219354590099 (37.7209831150476, -122.462193545901)
121726 106704 2 20 179 BRIGHTON AVE 1 1 1 1     12 3x3   5996189.7 2091071.1 37.7214646729593 -122.45525590980199 (37.7214646729593, -122.455255909802)
177655 175760 2 20 885 Girard St 2 1 1 1     6 Width 3ft   6011559.50494 2090784.62511 37.72154793606661 -122.402106275984 (37.7215479360666, -122.402106275984)
187374 36805 1 20 1450 Donner Ave 1 1 1 1 1 05/26/1998 12:00:00 AM 10   Permit Number 39531 6014737.8573 2091203.2549 37.7228743001584 -122.39114872971001 (37.7228743001584, -122.39114872971)
187540 36806 1 20 1450 Donner Ave 2 1 1 1 1 05/26/1998 12:00:00 AM 4   Permit Number 39531 6014725.6758 2091211.782 37.722897037873395 -122.391191434704 (37.7228970378734, -122.391191434704)
65839 36807 1 20 1450 Donner Ave 3 1 1 1 1 05/26/1998 12:00:00 AM 8   Permit Number 39531 6014713.4944 2091220.9181 37.722921447771604 -122.39123418192699 (37.7229214477716, -122.391234181927)
90190 59352 1 20 469 Faxon Ave 1 1 1 1   11/19/1980 12:00:00 AM 11 4x4 Permit Number 18701 5994737.99829015 2091686.56057322 37.7230711817022 -122.460318578759 (37.7230711817022, -122.460318578759)
131647 175755 2 20 10 Ruth St 2 2 1 1     1 Width 2ft   6001686.67815 2091578.8653 37.7231727394058 -122.43629071923401 (37.7231727394058, -122.436290719234)
137468 175776 2 20 281 Vienna St 1 1 1 1     15 Width 3ft   6004111.17595 2091728.8824200002 37.723722111883504 -122.427920387213 (37.7237221118835, -122.427920387213)
175753 204641 2 20 290 Granada Ave 2 1 1 1     1 Width 3ft   5995679.43604 2091904.4278 37.7237235031239 -122.45707998907601 (37.7237235031239, -122.457079989076)
52367 175777 2 20 281 Vienna St 2 1 1 1     10 Width 3ft   6004127.09808 2091752.9850700002 37.7237891931904 -122.42786706372601 (37.7237891931904, -122.427867063726)
137701 175778 2 20 281 Vienna St 3 1 1 1     6 Width 3ft   6004138.179280001 2091770.31166 37.7238373950554 -122.427829991858 (37.7238373950554, -122.427829991858)
54861 204642 2 20 290 Granada Ave 7 1 1 1     5 Width 4ft   5995680.91746 2091957.8181099999 37.7238701852543 -122.457078728228 (37.7238701852543, -122.457078728228)
38724 204643 2 20 290 Miramar Ave 1 1 1 1     1 Width 3ft   5995381.41136 2092014.7979700002 37.7240094335681 -122.458118187113 (37.7240094335681, -122.458118187113)
107537 39654 1 20 326 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41047 5994205.8673586 2092067.47591786 37.7240864587641 -122.46218564714898 (37.7240864587641, -122.462185647149)
148447 175761 2 20 223 Woolsey St 1 1 1 1     6 Width 3ft   6011060.579 2091989.46007 37.72482830406621 -122.403915678669 (37.7248283040662, -122.403915678669)
183090 47228 1 20 600 Girard St 1 1 1 1 1 05/09/2002 12:00:00 AM 6   Permit Number 45171 6011142.396240001 2091994.05057 37.724845479317004 -122.403633167442 (37.724845479317, -122.403633167442)
50129 175762 2 20 223 Woolsey St 2 1 1 1     5 Width 3ft   6011080.3120099995 2091995.56752 37.7248461762995 -122.403847893187 (37.7248461762995, -122.403847893187)
133233 175763 2 20 223 Woolsey St 3 1 1 1     8 Width 3ft   6011100.65099 2092002.25417 37.724865672709605 -122.40377805363 (37.7248656727096, -122.40377805363)
79362 47227 1 20 600 Girard St 3 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45171 6011131.84499471 2092020.43251585 37.7249173292839 -122.403671497463 (37.7249173292839, -122.403671497463)
93761 47226 1 20 600 Girard St 2 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45171 6011131.84499471 2092020.43251585 37.7249173292839 -122.403671497463 (37.7249173292839, -122.403671497463)
114176 47229 1 20 600 Girard St 4 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45171 6011131.84499471 2092020.43251585 37.7249173292839 -122.403671497463 (37.7249173292839, -122.403671497463)
71277 175764 2 20 325 Wayland St 1 1 1 1     3 Width 3ft   6010619.0390099995 2092334.0476400002 37.7257497917057 -122.40546629512698 (37.7257497917057, -122.405466295127)
4849 253684 2 20 767 Burrows St 1 1 1 1       3x3   6009074.0 2092682.0 37.7266186845557 -122.410831962563 (37.7266186845557, -122.410831962563)
74603 66582 1 20 425 Peru Ave 1 1 1 1 1 04/15/1991 12:00:00 AM 16   Permit Number 29772 6004685.90241 2092879.2867599998 37.7269133660376 -122.426015508917 (37.7269133660376, -122.426015508917)
130006 204640 2 20 25 Edna St 1 1 1 1     8 Width 2ft   5998733.11218 2093060.00406 37.7270713418516 -122.446607092452 (37.7270713418516, -122.446607092452)
91385 102872 1 20 173 Marston Ave 3 9 1 1         Permit Number 769914 5998407.2 2093120.4 37.7272185530423 -122.44773810752899 (37.7272185530423, -122.447738107529)
138626 102585 1 20 173 Marston Ave 1 9 1 1   03/07/2013 12:00:00 AM     Permit Number 769914 5998407.2 2093120.4 37.7272185530423 -122.44773810752899 (37.7272185530423, -122.447738107529)
144474 102871 1 20 173 Marston Ave 2 9 1 1         Permit Number 769914 5998407.2 2093120.4 37.7272185530423 -122.44773810752899 (37.7272185530423, -122.447738107529)
35293 204639 2 20 185 Marston Ave 2 9 1 1     1     5998393.85271 2093179.60638 37.7273803570158 -122.44778850934401 (37.7273803570158, -122.447788509344)
157176 175775 2 20 17 Paulding St 1 1 1 1     15 Width 3ft   6000241.49713 2093189.3269599997 37.7275124782167 -122.44140191715799 (37.7275124782167, -122.441401917158)
161247 175781 2 20 119 Madison St 1 1 1 1     11 Width 3ft   6005510.38459 2093087.28862 37.7275310563876 -122.423180067012 (37.7275310563876, -122.423180067012)
142456 51756 1 20 1350 Thomas Ave 1 1 1 1   06/27/2005 12:00:00 AM     Permit Number 48024 6016094.75384316 2092981.324561 37.727831736096796 -122.386582102799 (37.7278317360968, -122.386582102799)
179570 47485 1 20 165 Capistrano Ave 1 1 1 1 1 05/22/2002 12:00:00 AM 7   Permit Number 45478 6001374.27527 2093423.0179299999 37.7282186079017 -122.43750263124399 (37.7282186079017, -122.437502631244)
174106 47486 1 20 165 Capistrano Ave 2 1 1 1   05/14/2002 12:00:00 AM 10   Permit Number 45383 6001387.26681 2093436.23595 37.7282556401779 -122.437458665212 (37.7282556401779, -122.437458665212)
79995 109185 2 20 198x JUDSON AVE 1 1 1 1       3x3   5998796.0 2093546.0 37.7284093651166 -122.446424638984 (37.7284093651166, -122.446424638984)
88418 109186 2 20 198x JUDSON AVE 2 1 1 1       3x3   5998796.0 2093546.0 37.7284093651166 -122.446424638984 (37.7284093651166, -122.446424638984)
11230 27210 1 20 302 Silver Ave 17 1 1 1   11/28/2000 12:00:00 AM 3 3X3   6003698.299930001 2093465.5644 37.728467287514206 -122.42947142096901 (37.7284672875142, -122.429471420969)
Powered by Datasette · Query took 11.03ms · Data source: data.sfgov.org