sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
139282 87673 1 90 2610 Bay Shore Blvd 1 1 1 1   03/14/2006 12:00:00 AM 3 3x3   6010582.741346 2086196.4709060001 37.708895230886 -122.40515978386101 (37.708895230886, -122.405159783861)
94068 112744 1 90 235 Bright St 1 1 1 1 1 08/18/2015 12:00:00 AM     Permit Number 774127 5993719.1 2088769.4 37.7150026970857 -122.463629063261 (37.7150026970857, -122.463629063261)
114281 26918 3 90 2000X Bay Shore Blvd 8 1 1 2   10/19/2010 12:00:00 AM 3 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
127346 94638 3 90 2000X Bay Shore Blvd 1 1 1 2   10/19/2010 12:00:00 AM 3 3x3   6012318.2 2088514.6 37.715357222040005 -122.399324379639 (37.71535722204, -122.399324379639)
98839 115435 1 90 563 Lisbon St 2 1 1 1   02/01/2016 12:00:00 AM 3   Permit Number 777504 6001919.8 2090201.1 37.7194029477524 -122.43538635551901 (37.7194029477524, -122.435386355519)
91376 4894 3 90 745X Mansell St 2 1 1 2   03/29/2007 12:00:00 AM 3 3X3   6009751.8988059005 2090059.5024836997 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874)
146333 9298 1 90 135X Mansell St 4 1 1 1   06/10/1992 12:00:00 AM 3 3X3   6011497.3933157995 2090592.5284866001 37.7210170109869 -122.40230748066001 (37.7210170109869, -122.40230748066)
106121 9308 3 90 240X Mansell St 3 1 1 2   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224)
138373 9306 3 90 240X Mansell St 1 1 1 2   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224)
90907 13340 3 90 230 Mansell St 1 1 1 2   03/29/2007 12:00:00 AM 3 3X24   6011187.2509688 2090638.9738565 37.721127222942 -122.40338282278499 (37.721127222942, -122.403382822785)
144302 30135 1 90 220X Mansell St 2 1 1 1   03/29/2007 12:00:00 AM 3 3X30   6011221.783783999 2090644.291322 37.721143752318895 -122.403263826082 (37.7211437523189, -122.403263826082)
24021 177451 2 90 836 Brazil Ave 1 1 1 1     5 Width 2ft   6004096.8384300005 2090858.43848 37.7213312534072 -122.427907954105 (37.7213312534072, -122.427907954105)
125075 53133 1 90 925 Holloway Ave 1 5 1 1 1 08/19/2015 12:00:00 AM     Permit Number 774158 5994000.81776041 2091173.40830125 37.7216197566197 -122.46282963525199 (37.7216197566197, -122.462829635252)
2200 252931 2 90 71 Edgar Ave 1 1 1 1       3x3   5997064.0 2091155.0 37.7217451669512 -122.45223976154499 (37.7217451669512, -122.452239761545)
99829 95738 1 90 445 Edinburg St 2 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767484 6003120.3 2091142.7 37.7220564786865 -122.431303852024 (37.7220564786865, -122.431303852024)
172742 177452 2 90 404 Naples St 1 1 1 1     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092)
142073 108791 1 90 323 Edinburgh St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774649 6003546.88289 2091819.58764 37.7239392283561 -122.429877518865 (37.7239392283561, -122.429877518865)
18622 51694 1 90 1205 Plymouth Ave 1 1 1 1   04/29/2005 12:00:00 AM     Permit Number 47971 5995825.9822194 2092036.11859211 37.7240935095077 -122.456582925823 (37.7240935095077, -122.456582925823)
78106 102590 1 90 1205 Plymouth Ave 2 1 1 1         Permit Number 47971 5995820.0 2092088.8 37.724237816628 -122.4566074133 (37.724237816628, -122.4566074133)
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)
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)
105721 95660 1 90 431 Brussels St 1 1 1 1 1 03/08/2011 12:00:00 AM   3x3 Permit Number 767422 6010656.7 2092697.9 37.726750960199794 -122.40536171554 (37.7267509601998, -122.40536171554)
99170 100432 6 90 200X Stonecrest Dr 2 7 1 1           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
114083 100431 6 90 200X Stonecrest Dr 1 7 1 1           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
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)
120899 85560 3 90 980 Palou Ave 2 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018187.977748999 2092810.8923689998 37.727479421244 -122.37933387198099 (37.727479421244, -122.379333871981)
118293 85562 3 90 990 Palou Ave 2 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767)
142002 85561 3 90 990 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767)
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)
120459 85597 3 90 1101 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 6 3x3   6017523.881587001 2093256.0516779998 37.728665096277204 -122.381660625783 (37.7286650962772, -122.381660625783)
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)
90759 108834 1 90 163 Ney St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774662 6004445.49273 2094062.1156099997 37.73014756094079 -122.42693080570601 (37.7301475609408, -122.426930805706)
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)
105434 85569 3 90 1260 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.5196330003 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139)
143637 85570 3 90 1260 Palou Ave 2 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.5196330003 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139)
112715 85568 3 90 1264 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016691.22613 2093926.645569 37.730460403847204 -122.384585884949 (37.7304604038472, -122.384585884949)
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)
144143 85565 3 90 1276 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016630.35305 2093972.0233900002 37.7305816357941 -122.384799493903 (37.7305816357941, -122.384799493903)
143702 85577 3 90 1370 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016127.199744 2094347.0989189998 37.731583677290004 -122.38656512948499 (37.73158367729, -122.386565129485)
118353 85607 3 90 1397 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015969.720597 2094414.6007130002 37.7317603044799 -122.387114277117 (37.7317603044799, -122.387114277117)
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)
120019 85580 3 90 1458 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015655.098902999 2094699.254039 37.7325244779387 -122.38822185678002 (37.7325244779387, -122.38822185678)
138637 94896 1 90 1375 Keith St   1 1 1 1 11/23/2010 12:00:00 AM   3x3 Permit Number 53955 6016208.4 2094705.0 37.7325708970962 -122.386309345138 (37.7325708970962, -122.386309345138)
105958 85583 3 90 1500 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015418.292964 2094875.9215880001 37.7329964475839 -122.389052889382 (37.7329964475839, -122.389052889382)
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)
79853 96159 1 90 2 Milton St 1 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767792 6003680.0 2095311.9 37.7335358734479 -122.429666314328 (37.7335358734479, -122.429666314328)
105916 96160 1 90 2 Milton St 2 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767792 6003680.0 2095311.9 37.7335358734479 -122.429666314328 (37.7335358734479, -122.429666314328)
127595 85589 3 90 1566 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015069.619532 2095135.4181869999 37.7336896386511 -122.390276478357 (37.7336896386511, -122.390276478357)
138443 15056 3 90 1441 Mendell St 1 1 1 2   06/26/2012 12:00:00 AM 3 4x4   6015002.0 2095363.0 37.7343107811298 -122.390526157796 (37.7343107811298, -122.390526157796)
98990 96158 1 90 1 Milton St 1 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767791 6003728.0 2095595.0 37.7343159198258 -122.429520547314 (37.7343159198258, -122.429520547314)
15344 96670 3 90 1425 Mendell St 1 1 1 2   06/26/2012 12:00:00 AM 4 4x4   6015007.7446 2095379.2401 37.7343556918302 -122.390507431087 (37.7343556918302, -122.390507431087)
50163 17385 1 90 1649 Palou Ave 1 1 1 1   10/28/1996 12:00:00 AM 12 6x5   6014583.05525 2095408.96107 37.7344137306531 -122.39197780950899 (37.7344137306531, -122.391977809509)
91750 94689 1 90 218 Roanoke St 2 1 1 1 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53815 6003547.0 2096007.0 37.73543692838779 -122.43017570506201 (37.7354369283878, -122.430175705062)
14910 17426 3 90 1869 Palou Ave 1 1 1 2   12/05/2015 01:06:00 PM 3 3X3   6013447.639169999 2096284.8118900002 37.736755533926 -122.39596469871401 (37.736755533926, -122.395964698714)
118815 11953 3 90 1436 Kirkwood Ave 1 1 1 2   12/27/2007 12:00:00 AM 6 3X4   6015854.7568499 2096315.1604746997 37.7369724919298 -122.38764428476802 (37.7369724919298, -122.387644284768)
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)
113204 114762 1 90 27X Highland Ave 1 1 1 1   12/07/2015 12:00:00 AM     Permit Number 46967 6005096.96871 2096699.6024099998 37.7374263260205 -122.424866136467 (37.7374263260205, -122.424866136467)
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)
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)
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)
105427 86795 1 90 445 Wawona St 2 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)
106942 92587 1 90 445 Wawona St 10 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)
110607 92586 1 90 445 Wawona St 9 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)
111694 92580 1 90 445 Wawona St 3 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)
117359 92585 1 90 445 Wawona St 8 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)
120705 92583 1 90 445 Wawona St 6 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)
123606 92588 1 90 445 Wawona St 11 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)
142121 86796 1 90 445 Wawona St 1 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)
146017 92581 1 90 445 Wawona St 4 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)
124075 50261 1 90 31 Highland Ave 1 1 1 1 1 12/14/2002 12:00:00 AM     Permit Number 46967 6005053.32023027 2096760.11488265 37.737590014135 -122.425021354004 (37.737590014135, -122.425021354004)
97987 117395 1 90 544 Wawona St 1 1 1 1   06/08/2016 12:00:00 AM 3   Permit Number 778554 5991215.4 2097083.4 37.737686285904296 -122.47288871789 (37.7376862859043, -122.47288871789)
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)
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)
113842 6746 3 90 1300X Fairfax Ave 16 1 1 2   12/14/2007 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
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)
516 188685 3 90 1300 Evans Ave 14 4 1 2   04/10/2017 01:01:00 PM 3 Width 3ft   6017863.857919999 2096944.2017700002 37.738810795988606 -122.38074156686301 (37.7388107959886, -122.380741566863)
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)
507 251288 3 90 1335 Fairfax Ave 9 1 1 2 3 03/18/2017 01:58:00 PM 3 3x3   6016828.0 2097292.0 37.7397085577181 -122.38434732981199 (37.7397085577181, -122.384347329812)
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)
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)
119953 63015 1 90 75 Wool St 1 1 1 1 1 06/16/2014 12:00:00 AM     Permit Number 772837 6007421.64921795 2097871.12423845 37.7407740975251 -122.41691158671499 (37.7407740975251, -122.416911586715)
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)
125597 93271 3 90 1699X Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004711.0 2099043.6 37.7438406020251 -122.426367454995 (37.7438406020251, -122.426367454995)
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)
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)
143631 88363 1 90 2294 31st Ave   1 1 1   07/10/2009 12:00:00 AM   3x3 Permit Number 52532 5986746.4 2099664.8 37.7445143908471 -122.48852965844999 (37.7445143908471, -122.48852965845)
109604 93274 3 90 1613 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004607.0 2099503.0 37.7450961296299 -122.426759771954 (37.7450961296299, -122.426759771954)
79518 29856 3 90 1800X Evans Ave 8 1 1 2   05/12/2011 12:00:00 AM 3 4x4   6014606.392164 2099329.1692391 37.745179108267 -122.392171198439 (37.745179108267, -122.392171198439)
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)
108745 93276 3 90 1603 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004604.0 2099562.0 37.7452579604553 -122.426774346316 (37.7452579604553, -122.426774346316)
118880 93268 3 90 1574 Church St 1 1 1 2   01/29/2015 05:47:00 AM 3 3x3   6004569.0 2099722.0 37.7456953047191 -122.42690676352 (37.7456953047191, -122.42690676352)
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)
143516 93278 3 90 1559 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004592.0 2099818.0 37.74596019909129 -122.426834068489 (37.7459601990913, -122.426834068489)
145750 93279 3 90 1557 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004591.0 2099830.0 37.745993091787795 -122.426838380811 (37.7459930917878, -122.426838380811)
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)
104974 95423 1 90 2187 21st Ave 1 1 1 1 1 03/01/2011 12:00:00 AM   3x3 Permit Number 767291 5989736.1 2100494.0 37.7469651560486 -122.478252612879 (37.7469651560486, -122.478252612879)
114770 93280 3 90 1485 Church St 1 1 1 2   12/04/2008 12:00:00 AM 3 3x3   6004568.0 2100246.0 37.7471340314151 -122.42694753458099 (37.7471340314151, -122.426947534581)
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)
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)
139844 93265 3 90 1400X Church St 1 1 1 2   12/02/2008 12:00:00 AM 3 3x3   6004448.1 2100692.1 37.748352138422796 -122.42739391326401 (37.7483521384228, -122.427393913264)
142452 72994 1 90 590 Clipper St 1 1 1 1   07/06/2011 12:00:00 AM   3x3 Permit Number 768023 6001377.74978743 2100887.76679336 37.748715263692006 -122.438025102274 (37.748715263692, -122.438025102274)
Powered by Datasette · Query took 6.776ms · Data source: data.sfgov.org