sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4393 71591 2 87 187 Goethe St 1 1 1 1 1 10/11/2017 11:19:00 AM 3     5994642.6055 2086698.5979 37.709369932055004 -122.460287110874 (37.709369932055, -122.460287110874)
89447 96280 1 87 3207 San Bruno Ave 1 1 1 1   04/19/2011 12:00:00 AM   2x2 Permit Number 58764 6011955.4 2090682.8 37.721290434233 -122.40073061580799 (37.721290434233, -122.400730615808)
105633 96281 1 87 3217 San Bruno Ave 1 1 1 1   04/19/2011 12:00:00 AM   2x2 Permit Number 58765 6011946.6 2090709.2 37.7213624324365 -122.400762888856 (37.7213624324365, -122.400762888856)
995 8248 3 87 1515 Galvez Ave 1 1 1 2   04/27/2017 09:09:00 AM 3 3x3   6016190.1928199995 2097375.14571 37.739901571095 -122.38655841155001 (37.739901571095, -122.38655841155)
18290 567 3 87 2956 24th St 1 1 1 2   07/30/2015 12:00:00 AM 3 3x3   6009153.931340001 2102188.78939 37.7527267398546 -122.41122691061899 (37.7527267398546, -122.411226910619)
139756 539 1 87 2862 24th St 1 1 1 2   02/19/2016 07:55:00 AM 3 3X3   6009630.84107 2102242.33848 37.752900508699206 -122.40958144339399 (37.7529005086992, -122.409581443394)
35101 189111 2 87 1290 22nd St 1 1 1 1     8 Width 3ft   6014187.98978 2103886.57813 37.757669542418796 -122.39393693794901 (37.7576695424188, -122.393936937949)
51815 189110 2 87 1280 22nd St 1 1 1 1     8 Width 3ft   6014210.0262 2103887.6489 37.757673707186 -122.393860801355 (37.757673707186, -122.393860801355)
37107 189108 2 87 1260 22nd St 1 1 1 1     8 Width 3ft   6014251.8819 2103889.6971400003 37.7576816571866 -122.393716189448 (37.7576816571866, -122.393716189448)
133700 189107 2 87 1250 22nd St 1 1 1 1     7 Width 3ft   6014268.80299 2103891.1469400004 37.757686578301 -122.39365777040301 (37.757686578301, -122.393657770403)
104003 189106 2 87 1240 22nd St 1 1 1 1     8 Width 3ft   6014286.83976 2103892.9881599997 37.757692636135005 -122.39359552023501 (37.757692636135, -122.393595520235)
185175 189105 2 87 1230 22nd St 1 1 1 1     8 Width 3ft   6014303.7497 2103893.88664 37.757696042764394 -122.39353710115 (37.7576960427644, -122.39353710115)
36742 189104 2 87 1210 22nd St 1 1 1 1     9 Width 3ft   6014347.03164 2103896.55008 37.7577057608157 -122.393387599655 (37.7577057608157, -122.393387599655)
168610 189103 2 87 1200 22nd St 1 1 1 1     11 Width 3ft   6014366.46435 2103897.54658 37.7577095766431 -122.393320462565 (37.7577095766431, -122.393320462565)
180403 189112 2 87 699 Mississippi St 1 4 1 1     8 Width 3ft   6014162.08856 2103908.83128 37.75772920525 -122.39402807344901 (37.75772920525, -122.394028073449)
14083 108447 8 87 696 Pennsylvania Ave 1 1 1 1     12 3x3   6014378.0974 2104018.3558400003 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138)
155993 78625 2 87 862 Kansas St 1 1 1 1 1 10/07/2000 12:00:00 AM 7     6011556.98841 2104318.55424 37.758709082262605 -122.40306645336099 (37.7587090822626, -122.403066453361)
44308 56547 1 87 579 Texas St 1 1 1 1     13     6013852.908530001 2104423.88936 37.7591262544015 -122.395133430179 (37.7591262544015, -122.395133430179)
131002 104454 1 87 616 20th St 1 1 1 1   10/07/2013 12:00:00 AM 2 3x3 Permit Number 769741 6015946.56461 2104917.06512 37.760596617150604 -122.38792691709499 (37.7605966171506, -122.387926917095)
89585 47298 1 87 2116 Bryant St 1 1 1 1 1 08/16/2002 12:00:00 AM     Permit Number 45234 6009545.1120053 2104917.22843549 37.7602403504709 -122.41006673636801 (37.7602403504709, -122.410066736368)
128987 92726 1 87 1050X Minna St 1 1 1 1   09/25/2009 12:00:00 AM 3 3x3 Permit Number 52961 6007521.6 2109720.7 37.773315935079104 -122.41740554982599 (37.7733159350791, -122.417405549826)
3565 253475 4 87 1222 Harrison St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
Powered by Datasette · Query took 1.887ms · Data source: data.sfgov.org