sf-trees

Data source: data.sfgov.org

Custom SQL query returning 48 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
124908 85802 3 69 935 Folsom St 3 1 1 2   05/07/2007 12:00:00 AM 3 3x3 Permit Number 768011 6011398.0 2111930.0 37.7795995018672 -122.404151992929 (37.7795995018672, -122.404151992929)
125220 85861 3 69 1900 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6008004.0 2107379.0 37.7669133068935 -122.415571030805 (37.7669133068935, -122.415571030805)
125494 85878 3 69 2460 Folsom St 1 1 1 2   05/16/2013 12:00:00 AM 9 3x3   6008191.0 2104098.0 37.757914947315506 -122.414692010384 (37.7579149473155, -122.414692010384)
125931 85871 3 69 2366 Folsom St 1 1 1 2   05/22/2007 12:00:00 AM 6 3x3   6008161.0 2104646.0 37.759417944294 -122.414834546653 (37.759417944294, -122.414834546653)
126501 85867 3 69 2108 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6008073.0 2106151.0 37.763545382442295 -122.41524543235701 (37.7635453824423, -122.415245432357)
127189 103737 3 69 2075 Folsom St 1 1 1 2   05/04/2007 12:00:00 AM 9 3x3   6008144.6 2106350.8 37.7640980107115 -122.415011932629 (37.7640980107115, -122.415011932629)
127384 103750 1 69 1665 Folsom St 1 1 1 1   05/04/2007 12:00:00 AM 3 3x3   6008126.9 2108535.0 37.770094320073596 -122.41522777783301 (37.7700943200736, -122.415227777833)
127683 85770 1 69 1480 Folsom St 1 1 1 1   05/07/2007 12:00:00 AM 3 3x3   6008543.0 2109248.0 37.7720754271741 -122.41383893105801 (37.7720754271741, -122.413838931058)
128080 96190 1 69 2889 Folsom St 1 1 1 1   05/22/2007 12:00:00 AM 3 3x3   6008375.88429 2101615.45305 37.7511088214431 -122.41387699241899 (37.7511088214431, -122.413876992419)
129479 112783 1 69 506 10th Ave 1 1 1 1   08/19/2015 12:00:00 AM     Permit Number 774416 5992870.4 2111974.5 37.7786690335249 -122.468249618869 (37.7786690335249, -122.468249618869)
138619 110252 2 69 1514 Castro St 1 1 1 1   04/01/2015 12:00:00 AM 3 3x3 Permit Number 774936 6002531.9 2101059.9 37.749253468980896 -122.434046366801 (37.7492534689809, -122.434046366801)
139186 122423 4 69 2655 Bush St 5 1 1 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
140521 85863 3 69 1920 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 3 3x3   6008022.853044 2107254.679206 37.7665730106978 -122.415497018354 (37.7665730106978, -122.415497018354)
141072 85880 3 69 2564 Folsom St 1 1 1 2   05/22/2007 12:00:00 AM 3 3x3   6008224.0 2103492.0 37.7562528635191 -122.414535000717 (37.7562528635191, -122.414535000717)
142209 103732 3 69 2225 Folsom St 2 1 1 2   05/04/2007 12:00:00 AM 3 3x3   6008315.8 2105284.4 37.761179541063704 -122.414344341073 (37.7611795410637, -122.414344341073)
142253 122428 4 69 2655 Bush St 10 1 1 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
142716 17508 3 69 209 Persia Ave 2 1 1 2   04/25/2008 12:00:00 AM 3 3X3   6002263.284973901 2091285.3954444 37.722399682135205 -122.434276533913 (37.7223996821352, -122.434276533913)
143964 96191 1 69 2843 Folsom St 1 1 1 1   05/22/2007 12:00:00 AM 3 3x3   6008392.81566 2101883.12562 37.7518447409777 -122.41383737404101 (37.7518447409777, -122.413837374041)
144526 103738 3 69 2075 Folsom St 2 1 1 2   05/04/2007 12:00:00 AM 3 3x3   6008144.6 2106350.8 37.7640980107115 -122.415011932629 (37.7640980107115, -122.415011932629)
145109 98188 1 69 1498X Folsom St 1 1 1 1     4 3x3   6008543.0 2109248.0 37.7720754271741 -122.41383893105801 (37.7720754271741, -122.413838931058)
145445 85742 3 69 816 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6012158.0 2112700.0 37.7817561793381 -122.40157694342501 (37.7817561793381, -122.401576943425)
146319 85750 3 69 900 Folsom St 5 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6011609.0 2112176.0 37.78028674810621 -122.403439360525 (37.7802867481062, -122.403439360525)
147797 180576 2 69 100 Ney St 1 1 1 1     4 Width 3ft   6004076.33336 2094007.41244 37.7299764776345 -122.428203140362 (37.7299764776345, -122.428203140362)
158978 242789 2 69 305 Shotwell St 2 1 1 1     5 Width 3ft   6007810.4861 2106094.80833 37.7633763361668 -122.416149407388 (37.7633763361668, -122.416149407388)
159535 180578 2 69 106 Ney St 2 1 1 1     4 Width 3ft   6004112.42356 2094009.6957900003 37.7299847891668 -122.42807853481001 (37.7299847891668, -122.42807853481)
160833 120786 2 69 253 21st Ave 1 1 1 1     2 Width 4ft   5989295.33642 2113646.62963 37.78305310452279 -122.480739452185 (37.7830531045228, -122.480739452185)
166098 242788 2 69 305 Shotwell St 1 1 1 1     5 Width 3ft   6007812.97751 2106058.80596 37.763277622093206 -122.416138240487 (37.7632776220932, -122.416138240487)
172845 180574 2 69 605 Naples St 1 1 1 1     1 Width 4ft   6002770.24765 2090074.97352 37.7191048944443 -122.43243767198601 (37.7191048944443, -122.432437671986)
178714 180575 2 69 185 Maynard St 1 1 1 1     5 Width 3ft   6004602.74534 2093797.60717 37.7294301700595 -122.426368337242 (37.7294301700595, -122.426368337242)
182330 180577 2 69 106 Ney St 1 1 1 1     3 Width 3ft   6004093.306609999 2094009.2250299999 37.729982414954904 -122.428144590899 (37.7299824149549, -122.428144590899)
185851 242784 2 69 2730 22nd St 1 2 1 1     2 Width 7ft   6009801.01572 2103396.12186 37.756078074246 -122.409074350022 (37.756078074246, -122.409074350022)
187261 242787 2 69 72 Santa Marina St 1 1 1 1     1 Width 3ft   6006069.06091 2097600.46575 37.7399547543139 -122.421569116835 (37.7399547543139, -122.421569116835)
4333 160542 2 69 787 Edinburgh St 1 1 1 1 1 10/11/2017 08:58:00 AM 3 Width 0ft   6001926.33849 2089244.2387299999 37.716775991190794 -122.435295346912 (37.7167759911908, -122.435295346912)
4363 160546 2 69 755 Edinburgh St 1 1 1 1 1 10/11/2017 08:38:00 AM 3 Width 0ft   6002026.63127 2089400.9055 37.7172118584185 -122.434959882691 (37.7172118584185, -122.434959882691)
4423 160541 2 69 795 Edinburgh St 1 1 1 1 1 10/11/2017 09:01:00 AM 3 Width 0ft   6001897.94252 2089197.43685 37.7166458709939 -122.435390151656 (37.7166458709939, -122.435390151656)
4815 160876 2 69 623 Naples St 1 1 1 1 1 10/25/2017 11:58:00 AM 3 Width 0ft   6002712.67368 2089986.17958 37.7188578210185 -122.43263034363702 (37.7188578210185, -122.432630343637)
78881 38309 1 69 2000 Folsom St 4 1 1 1 1 03/01/2016 12:00:00 AM 3   Permit Number 771420 6008042.39215173 2106787.37094181 37.765290989194895 -122.415396349695 (37.7652909891949, -122.415396349695)
90626 69599 1 69 366 Page St 1 1 1 1 1 10/24/2014 12:00:00 AM 3   Permit Number 773624 6004805.18148758 2109878.85249056 37.7735969721496 -122.42681328543001 (37.7735969721496, -122.42681328543)
90684 116842 1 69 1110 Sanchez St 2 1 1 1 1   8     6003795.63291288 2101809.17317596 37.751382436857796 -122.429729790926 (37.7513824368578, -122.429729790926)
99817 49040 1 69 1110 Sanchez St 1 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46215 6003795.63291288 2101809.17317596 37.751382436857796 -122.429729790926 (37.7513824368578, -122.429729790926)
104873 32862 1 69 367 Jersey St 1 1 1 1 1 11/28/2012 12:00:00 AM     Permit Number 769301 6002770.016647 2101497.55213803 37.7504686693665 -122.433254224 (37.7504686693665, -122.433254224)
106404 99947 1 69 522 Shotwell St 2 1 1 1 1 06/18/2012 12:00:00 AM   4x4 Permit Number 54785 6007824.0 2104880.2 37.7600420622217 -122.416016646831 (37.7600420622217, -122.416016646831)
107082 59736 1 69 916 Sanchez St 1 1 1 1 1 01/19/2016 12:00:00 AM     Permit Number 775357 6003734.07108678 2102930.08592587 37.7544567132931 -122.430022630753 (37.7544567132931, -122.430022630753)
109170 95393 1 69 3965 Cesar Chavez St 1 1 1 1 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767262 6004412.0 2100353.0 37.747419006534 -122.427494591738 (37.747419006534, -122.427494591738)
114998 81136 1 69 4657 18th St 1 1 1 1 1 06/06/2012 12:00:00 AM   3x3 Permit Number 768983 6000147.95764033 2105151.97717561 37.7603537323491 -122.442583825347 (37.7603537323491, -122.442583825347)
116680 108833 1 69 79 Ney St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774661 6003925.191380001 2094039.50832 37.7300560527634 -122.42872794360301 (37.7300560527634, -122.428727943603)
120339 33043 1 69 418 Fair Oaks St 1 1 1 1 1 12/28/2015 12:00:00 AM     Permit Number 775549 6005473.51792127 2101262.44502377 37.7499761163357 -122.423888589368 (37.7499761163357, -122.423888589368)
124602 95382 1 69 4317 24th St 1 1 1 1 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767252 6001161.0 2101705.0 37.75094686177329 -122.43883317496099 (37.7509468617733, -122.438833174961)
Powered by Datasette · Query took 2.064ms · Data source: data.sfgov.org