sf-trees

Data source: data.sfgov.org

Custom SQL query returning 53 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
47863 177393 2 88 1657 Sunnydale Ave 1 9 1 1     4 Width 10ft   6006855.18138 2087491.9955900002 37.7122433757141 -122.41813457086599 (37.7122433757141, -122.418134570866)
49439 83995 1 88 254 Dublin St 1 1 1 1   10/10/2008 12:00:00 AM 4 3x3 Permit Number 51873 6003949.050969999 2088987.2537599998 37.7161850277922 -122.428285520976 (37.7161850277922, -122.428285520976)
35817 83433 2 88 760 Paris St 1 1 1 1 1 12/03/2005 12:00:00 AM 4     6000998.571 2089370.50235 37.7170699516967 -122.43851121642099 (37.7170699516967, -122.438511216421)
34070 177396 2 88 650 France Ave 1 1 1 1     4 Width 3ft   6002554.32379 2089489.05378 37.7174838421787 -122.433142195459 (37.7174838421787, -122.433142195459)
2517 178826 2 88 927 Brazil Ave 2 1 1 1     4 Width 3ft   6004356.8834 2090741.4764900003 37.7210248094256 -122.427000725205 (37.7210248094256, -122.427000725205)
151961 177422 2 88 0 Santa Ynez Ave 2 1 1 1     4 Width 4ft   6001061.39064 2091803.12496 37.7237529577069 -122.438468271097 (37.7237529577069, -122.438468271097)
39201 177424 2 88 85 Santa Ynez Ave 1 1 1 1     4 Width 3ft   6000559.946819999 2092109.10715 37.7245645787726 -122.440223605655 (37.7245645787726, -122.440223605655)
72897 43147 1 88 249 Gambier St 1 1 1 1 1 03/08/2011 12:00:00 AM 4 3x3 Permit Number 767437 6005979.23995 2092615.6379200001 37.7262624547464 -122.421525745221 (37.7262624547464, -122.421525745221)
180774 43160 1 88 261 Harvard St 1 1 1 1 1 03/08/2011 12:00:00 AM 4 3x3 Permit Number 767438 6006282.82959 2092642.1581700002 37.7263523869376 -122.42047813126499 (37.7263523869376, -122.420478131265)
175968 177426 2 88 125 Lisbon St 1 1 1 1     4 Width 4ft   6003455.72001 2092686.0671599999 37.7263132250654 -122.430254442684 (37.7263132250654, -122.430254442684)
172336 110563 2 88 135 Theresa St 2 1 1 1     4 3x9   6002082.973999999 2093709.6113599997 37.729045795311706 -122.43507312442499 (37.7290457953117, -122.435073124425)
177264 110562 2 88 135 Theresa St 1 1 1 1     4 3x9   6002071.86629 2093721.73728 37.729078459595605 -122.43511239152001 (37.7290784595956, -122.43511239152)
164563 61691 1 88 61 Lucy St 1 1 1 1 1 11/05/1992 12:00:00 AM 4   Permit Number 31258 6014147.06906 2093799.2682599998 37.7299696274983 -122.393372558494 (37.7299696274983, -122.393372558494)
131930 95118 1 88 70 Danton St 1 1 1 1 1 12/28/2010 12:00:00 AM 4 3x3 Permit Number 54045 6002845.36735 2094508.37035 37.7312822680527 -122.432494502827 (37.7312822680527, -122.432494502827)
41605 30800 1 88 199 Burnside Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 4   Permit Number 34666 6001059.22701 2095245.3674599999 37.7332044430184 -122.438722291799 (37.7332044430184, -122.438722291799)
61328 193352 2 88 1707 McKinnon Ave 1 4 1 1     4 Width 3ft   6014777.576230001 2096343.32459 37.736990099615 -122.39137057769199 (37.736990099615, -122.391370577692)
129514 230353 2 88 210 Moffitt St 3 1 1 1     4 Width 2ft   6002369.42033 2097177.7522 37.7385847765781 -122.43433070979401 (37.7385847765781, -122.434330709794)
68631 208843 2 88 40 Agua Way 1 1 1 1     4 Width 2ft   5997291.06099 2098595.63938 37.74218838968729 -122.451991423486 (37.7421883896873, -122.451991423486)
77158 208851 2 88 185 Vasquez Ave 1 2 1 1     4 Width 3ft   5994827.47674 2099365.31036 37.7441602944536 -122.46056543215299 (37.7441602944536, -122.460565432153)
135913 208850 2 88 185 Vasquez Ave 2 2 1 1     4 Width 3ft   5994846.41703 2099381.9265400004 37.7442070079607 -122.46050114503001 (37.7442070079607, -122.46050114503)
180308 230326 2 88 383 27th St 1 1 1 1     4 Width 3ft   6004064.30243 2100111.9169799997 37.7467373764274 -122.428679723506 (37.7467373764274, -122.428679723506)
135397 218385 2 88 50 San Marcos Ave 7 2 1 1     4 Width 0ft   5993842.10795 2100214.10934 37.7464341439306 -122.46403419821999 (37.7464341439306, -122.46403419822)
106163 84574 1 88 1090X Noe St 1 1 1 1 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003150.0 2101890.0 37.7515677875779 -122.43196823442301 (37.7515677875779, -122.431968234423)
186500 193340 2 88 1280 Minnesota St 1 1 1 1     4 Width 3ft   6015310.01646 2102516.50346 37.753969902388796 -122.38996077348 (37.7539699023888, -122.38996077348)
59718 193339 2 88 1278 Minnesota St 1 1 1 1     4 Width 3ft   6015309.7122 2102531.15535 37.7540101165005 -122.389962849121 (37.7540101165005, -122.389962849121)
30570 193337 2 88 1270 Minnesota St 2 1 1 1     4 Width 3ft   6015308.479069999 2102559.27559 37.7540872603324 -122.389969077812 (37.7540872603324, -122.389969077812)
165822 193336 2 88 1270 Minnesota St 1 1 1 1     4 Width 3ft   6015307.256519999 2102573.04925 37.7541250120819 -122.38997426781499 (37.7541250120819, -122.389974267815)
75334 193343 2 88 698 Arkansas St 1 4 1 1     4 Width 3ft   6012989.114019999 2103849.31958 37.757500537346395 -122.39808055528299 (37.7575005373464, -122.398080555283)
9341 116840 1 88 636 POTRERO AVE 2 1 1 1     4 3x3   6010345.0 2105335.0 37.761432257364994 -122.40732973919701 (37.761432257365, -122.407329739197)
136274 193319 2 88 2111 18th St 1 1 1 1     4 Width 4ft   6011383.02095 2105548.33564 37.762076071170895 -122.403754647862 (37.7620760711709, -122.403754647862)
155809 193320 2 88 2111 18th St 2 1 1 1     4 Width 4ft   6011400.26798 2105549.24377 37.762079528159795 -122.403695060604 (37.7620795281598, -122.403695060604)
137475 84780 1 88 224 Mississippi St 2 1 1 1   04/18/2007 12:00:00 AM 4   Permit No. 49287 6013987.25375 2106041.39506 37.7635750422708 -122.39478207494899 (37.7635750422708, -122.394782074949)
181062 31608 1 88 5 Lucerne St 5 1 1 1   06/06/1995 12:00:00 AM 4   Permit Number 35133 6012020.8525 2109827.45516 37.7738611793697 -122.401849428724 (37.7738611793697, -122.401849428724)
69848 81662 2 88 563 14th Ave 1 1 1 1 1   4     5991577.12734 2111607.04314 37.7775853186785 -122.472696706975 (37.7775853186785, -122.472696706975)
36801 49512 1 88 1928& 21st AVE Clement St 1 1 1 1   04/23/2003 12:00:00 AM 4   Permit Number 46417 5989493.41802 2113376.93915 37.7823241210106 -122.480034435471 (37.7823241210106, -122.480034435471)
188880 38814 1 88 286 02nd Ave 1 1 1 1   07/03/2008 12:00:00 AM 4 3x3 Permit Number 51147 5995268.26088 2113665.38834 37.7834499595789 -122.460077076847 (37.7834499595789, -122.460077076847)
160936 121810 2 88 106 19th Ave 2 2 1 1     4 Width 4ft   5989928.89895 2114601.72994 37.7857123459232 -122.478617478776 (37.7857123459232, -122.478617478776)
174893 46093 1 88 100 19th Ave 3 1 1 1   12/10/2001 12:00:00 AM 4   Permit Number 44465 5989926.67635 2114640.8160200003 37.785819536272 -122.478628027687 (37.785819536272, -122.478628027687)
152466 94730 1 88 418 Spruce St 1 1 1 1 1 10/28/2010 12:00:00 AM 4 3x3 Permit Number 53862 5997217.67326 2114882.8026 37.7869045857318 -122.45342083293001 (37.7869045857318, -122.45342083293)
73825 120376 2 88 123 25th Ave 1 1 1 1     4 Width 2ft   5987996.34408 2115176.14425 37.787177130208995 -122.48534564914301 (37.787177130209, -122.485345649143)
68652 124611 2 88 3931 Clay St 2 1 1 1     4 Width 3ft   5995971.07063 2115182.72875 37.787656567418 -122.457755475318 (37.787656567418, -122.457755475318)
168053 72311 2 88 3769 Jackson St 1 1 1 1 1 02/10/1996 12:00:00 AM 4     5996250.37824 2115874.5059700003 37.7895720432509 -122.456839183887 (37.7895720432509, -122.456839183887)
73621 130991 2 88 1645 Washington St 1 1 1 1     4 Width 3ft   6006783.4642 2117013.9596599997 37.7932998878436 -122.42047665816901 (37.7932998878436, -122.420476658169)
43019 130992 2 88 1645 Washington St 2 1 1 1     4 Width 3ft   6006789.62412 2117015.0975 37.7933033592027 -122.420455425186 (37.7933033592027, -122.420455425186)
35824 131007 3 88 150x Drumm St 2 3 1 2     4 Width 7ft   6013687.07221 2117423.5151299997 37.7948110573238 -122.396618254944 (37.7948110573238, -122.396618254944)
25560 131008 3 88 150x Drumm St 3 3 1 2     4 Width 7ft   6013685.844769999 2117434.71438 37.7948417395127 -122.396623287539 (37.7948417395127, -122.396623287539)
54511 131009 3 88 150x Drumm St 4 3 1 2     4 Width 7ft   6013684.354719999 2117443.2289299998 37.794865035532396 -122.396629040522 (37.7948650355324, -122.396629040522)
178157 34926 1 88 2625 Baker St 1 1 1 1   05/31/2012 12:00:00 AM 4   Permit Number 768761 5999600.82758 2117890.72086 37.795299853268205 -122.445392054402 (37.7952998532682, -122.445392054402)
165318 130977 2 88 2801 Webster St 8 10 1 1     4 Width 2ft   6002958.5494099995 2118258.6214900003 37.7965011163873 -122.43380011427901 (37.7965011163873, -122.433800114279)
167026 130974 2 88 2801 Webster St 5 10 1 1     4 Width 2ft   6002954.53886 2118286.2899 37.796576859099105 -122.433815970239 (37.7965768590991, -122.433815970239)
68884 55891 1 88 1981 Union St 1 1 1 1   05/24/1979 12:00:00 AM 4   Permit Number 17936 6003525.54431 2118603.6465 37.7974806237872 -122.43186283789801 (37.7974806237872, -122.431862837898)
64441 249953 2 88 303 Filbert St 2 17 1 1     4 Width 0ft   6011372.652369999 2120041.55492 37.8018704817969 -122.40481091868901 (37.8018704817969, -122.404810918689)
134199 130995 2 88 832 Lombard St 1 1 1 1     4 Width 3ft   6008337.45548 2120371.32318 37.8026058250595 -122.41533751023998 (37.8026058250595, -122.41533751024)
Powered by Datasette · Query took 8.945ms · Data source: data.sfgov.org