sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8611 5309 3 5 1736 Divisadero St 1 1 1 2     12 3x3   6001119.1558 2114392.6005 37.7857814798006 -122.439887470169 (37.7857814798006, -122.439887470169)
8616 23547 3 5 2806 Van Ness Ave 1 1 1 2     35 4X4   6005703.65589 2120048.52482 37.801571123555895 -122.424428815235 (37.8015711235559, -122.424428815235)
8727 7110 3 5 1892X Fell St 1 1 1 2     12 3X3   5998395.8128 2109678.4377 37.7726822136463 -122.448969721072 (37.7726822136463, -122.448969721072)
8859 5308 3 5 1722 Divisadero St 1 1 1 2     16 3X3   6001127.4861 2114346.0125 37.785654035319396 -122.439855308268 (37.7856540353194, -122.439855308268)
8863 23876 3 5 1499X Webster St 2 1 1 2     18 3X3   6003591.0247 2113771.0527 37.7842152634044 -122.43129112119301 (37.7842152634044, -122.431291121193)
8868 7107 3 5 2140 Fell St 1 1 1 2     36 4X4   5997173.1498 2109507.8264 37.77214375901271 -122.453186703241 (37.7721437590127, -122.453186703241)
8899 5319 3 5 1844 Divisadero St 1 1 1 2     18 3X3   6001069.8732 2114771.5539 37.786819182767296 -122.44008515695101 (37.7868191827673, -122.440085156951)
8940 9931 1 5 2336 Gough St 2 1 1 1     12 3X3   6005032.8646599995 2117688.63241 37.7950535595338 -122.426581919932 (37.7950535595338, -122.426581919932)
8990 6946 3 5 566 Fell St 3 1 1 2     12 5x4   6004669.16029 2110552.41632 37.7754387224635 -122.427331794438 (37.7754387224635, -122.427331794438)
9002 6927 3 5 488 Fell St 1 1 1 2     24 3X3   6005098.7367 2110617.0491 37.7756404737796 -122.425850388577 (37.7756404737796, -122.425850388577)
9010 23574 3 5 3035 Van Ness Ave 1 1 1 2     30 3x3   6005498.0371199995 2120829.33235 37.8037034071495 -122.425195941456 (37.8037034071495, -122.425195941456)
9241 27374 1 5 1702 Fell St 1 1 1 1     12 3X3   5999207.4594 2109789.3959999997 37.773033261646496 -122.44617014115101 (37.7730332616465, -122.446170141151)
9391 24148 1 5 100X Whitney Young Cir 8 1 1 1     12 3x4   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
9667 11795 3 5 1200X Junipero Serra Blvd 29 1 1 2     10     5991118.2706518 2089586.5464946998 37.7170961765154 -122.472678089933 (37.7170961765154, -122.472678089933)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9853 173717 2 5 614 Buchanan St 1 1 1 1       3x3   6004584.0 2110624.0 37.775630457098295 -122.427631485331 (37.7756304570983, -122.427631485331)
9882 173729 3 5 994 Carolina St 2 11 1 2     6 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
9888 173719 3 5 922 Carolina St 1 11 1 2     12 3x3   6012422.0 2103621.0 37.7568420188621 -122.40002584196199 (37.7568420188621, -122.400025841962)
9889 3743 3 5 906 Carolina St 2 11 1 2     18 18   6012418.0 2103694.0 37.757042237838796 -122.400044801952 (37.7570422378388, -122.400044801952)
9898 3765 3 5 1074 Carolina St 3 11 1 2     15 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.39986024500799 (37.7550481677782, -122.399860245008)
9903 3758 3 5 1056 Carolina St 3 11 1 2     15 18   6012452.0863519 2103047.5184298 37.7552690413169 -122.399881522302 (37.7552690413169, -122.399881522302)
9906 173728 3 5 994 Carolina St 1 11 1 2     8 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
9908 3768 3 5 1098 Carolina St 1 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
9957 173686 2 5 2211 Palou Ave 1 1 1 1   01/12/2017 12:00:00 AM 3     6011691.0 2097676.0 37.740477553883096 -122.402135979323 (37.7404775538831, -122.402135979323)
9962 173753 2 5 1140 Lawton St   1 1 1       3x3   5990653.0 2104548.0 37.7581495573033 -122.475378025252 (37.7581495573033, -122.475378025252)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10113 5402 3 5 368 Dolores St 1 1 1 2     26 4X4   6004841.2181400005 2106223.26914 37.763561657659295 -122.426428293246 (37.7635616576593, -122.426428293246)
10116 173859 3 5 118 Saint Mary's Ave 5 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
10123 173857 3 5 118 Saint Mary's Ave 3 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
10124 173862 2 5 98 Frederick St 1 1 1 1       3x3   5999618.0 2107794.0 37.7675778447629 -122.444606591258 (37.7675778447629, -122.444606591258)
10125 173858 3 5 118 Saint Mary's Ave 4 9 1 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
10162 173888 2 5 2 Vasquez Ave   1 1 1       3x3   5995783.0 2100209.0 37.7465317821399 -122.457322486502 (37.7465317821399, -122.457322486502)
10203 106598 3 5 1001X SAN JOSE AVE 11 3 1 2     21     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
10259 141190 2 5 1771 ELLIS ST 1 1 1 1     9999 Width 0ft   6002407.0405 2112959.471 37.781919696317296 -122.43532920805599 (37.7819196963173, -122.435329208056)
10422 100386 2 5 1630 21st Ave 1 1 1 1     10 3x3   5989668.805 2104235.219 37.7572336462205 -122.478758883384 (37.7572336462205, -122.478758883384)
10531 120538 2 5 2 South Hill Blvd 1 1 1 1     12 3x3   6002576.6751 2087720.0510900002 37.7126278178947 -122.43293862581999 (37.7126278178947, -122.43293862582)
10745 776 3 5 1600X 37th Ave 2 1 1 2     12 3   5984705.3515 2104090.9487 37.7565480706746 -122.49591353675899 (37.7565480706746, -122.495913536759)
10808 100387 2 5 1630 21st Ave 2 1 1 1     10 3x3   5989667.3817 2104248.5033 37.75727003871479 -122.47876477719299 (37.7572700387148, -122.478764777193)
10841 25393 3 5 1051 Geneva Ave 1 1 1 2     30 3X3   6001007.68114 2088741.24323 37.7153426652198 -122.438434668834 (37.7153426652198, -122.438434668834)
10853 102802 2 5 1245 27th Ave 1 1 1 1     12 3x3   5987672.179 2106793.3292 37.764141382947706 -122.485851660773 (37.7641413829477, -122.485851660773)
10888 113348 2 5 36 Curtis St 1 1 1 1     20 15x6   6000512.8548 2088435.33913 37.7144745622345 -122.440123079431 (37.7144745622345, -122.440123079431)
10951 24278 3 5 350X Winding Way 16 11 1 2     6 8   6000808.42529 2086790.5767400002 37.709975233345 -122.438983668972 (37.709975233345, -122.438983668972)
10984 105220 2 5 1443 28th Ave 1 1 1 1     8 3x3   5987410.3461 2105455.8349 37.760453729777396 -122.48665903725299 (37.7604537297774, -122.486659037253)
10993 764 1 5 1200X 37th Ave 1 1 1 3     12 3   5984614.2914 2106873.7688 37.76418358274471 -122.496433785178 (37.7641835827447, -122.496433785178)
11006 120949 2 5 2750 Ortega St 1 1 1 1     12 3x3   5985472.8534 2102314.8398 37.7517162845821 -122.493128443109 (37.7517162845821, -122.493128443109)
11007 19809 3 5 100 STAIRWAY23 4 1 1 2     12 60ST            
11153 1849 3 5 2401 Bay Shore Blvd 5 1 1 2     12 3X3   6011118.84502 2087065.06419 37.7113101708062 -122.40336798796301 (37.7113101708062, -122.403367987963)
11209 20386 3 5 262X Sunset Blvd 32 1 1 2     12 60            
11240 19966 3 5 100 STAIRWAY41 4 1 1 2     6 25ST            
11295 773 3 5 1500X 37th Ave 1 1 1 2     18 3   5984696.2443 2104420.7984 37.7574532129065 -122.495969365063 (37.7574532129065, -122.495969365063)
11420 745 3 5 2201X 36th Ave 2 1 1 2     18 6   5985120.8379 2099719.0966 37.7445684872167 -122.49415444151501 (37.7445684872167, -122.494154441515)
11670 102444 2 5 430X Amazon Ave 1 1 1 1     5 3x3   6001528.5407 2088896.6516 37.715798995606704 -122.436645469419 (37.7157989956067, -122.436645469419)
11825 20029 3 5 100 STAIRWAY50 1 1 1 2     12 40ST            
12211 20025 3 5 100 STAIRWAY48 9 1 1 2     12 10ST            
12225 24277 3 5 350X Winding Way 15 11 1 2     6 8   6000814.16949 2086790.4577099998 37.709975233345496 -122.43896380743999 (37.7099752333455, -122.43896380744)
12421 748 3 5 2301X 36th Ave 2 1 1 2     18 6   5985137.3758 2099321.1031 37.7434766724968 -122.49406793054101 (37.7434766724968, -122.494067930541)
12444 27070 1 5 801 Silver Ave 12 1 1 1   05/11/2000 12:00:00 AM 6 4x15   6006926.95376 2093626.2596599997 37.7290907946921 -122.41832116401699 (37.7290907946921, -122.418321164017)
12564 115359 2 5 345 Rolph St 1 1 1 1     27 5x6   6001770.67381 2087944.68785 37.7131988712114 -122.43574047716001 (37.7131988712114, -122.43574047716)
12609 774 3 5 1500X 37th Ave 2 1 1 2     18 3   5984689.126 2104618.0173 37.7579943042171 -122.496008531807 (37.7579943042171, -122.496008531807)
12986 19789 3 5 100 STAIRWAY19 11 1 1 2     18 50ST            
13306 187657 6 5 2072 15th Ave 1 2 1 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
13458 24144 1 5 100X Whitney Young Cir 4 1 1 1     12 3X4   6016701.61434 2095161.25681 37.7338509755474 -122.38463593799999 (37.7338509755474, -122.384635938)
13460 6707 3 5 1200X Fairfax Ave 4 1 1 2     18 3x3   6017570.5024 2096779.6090000002 37.7383426628708 -122.381744418894 (37.7383426628708, -122.381744418894)
13466 104640 5 5 112 07th St 1 1 1 1     10 2.5x2.5   6009509.89326 2111697.52669 37.778855505921605 -122.410667371323 (37.7788555059216, -122.410667371323)
13509 106317 2 5 1133 De Haro St 1 1 1 1     32 4x4   6012240.80146 2103138.9754 37.7555083807236 -122.400618637234 (37.7555083807236, -122.400618637234)
13612 3695 3 5 400X Cargo Way 2 11 1 2     12 8   6017120.58643 2098873.01635 37.7440658827378 -122.383445712243 (37.7440658827378, -122.383445712243)
13675 18550 9 5 1700X Quesada Ave 5 11 1 2     30 19   6014656.2717 2095062.2920900001 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637)
13683 1710 3 5 5 Bass Ct 1 1 1 2     12 3x3   6016578.92227 2095125.73941 37.73374666585679 -122.385057651709 (37.7337466658568, -122.385057651709)
13761 6553 1 5 1275 Evans Ave 5 1 1 1     18 4x8   6017462.04156 2097126.1556099998 37.7392882208803 -122.382143528109 (37.7392882208803, -122.382143528109)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
13870 24143 3 5 100X Whitney Young Cir 3 1 1 2     12 3x3   6016705.2095099995 2095147.06572 37.7338122084672 -122.38462252011999 (37.7338122084672, -122.38462252012)
13955 97226 3 5 1301X Newcomb Ave 6 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016643.51258 2094941.1276900002 37.7332433315076 -122.38482148523899 (37.7332433315076, -122.384821485239)
13964 24120 3 5 99X Whitney Young Cir 1 1 1 2     24 3x3   6016647.77235 2095170.8389599998 37.7338743084492 -122.384822755067 (37.7338743084492, -122.384822755067)
14006 6423 3 5 1100X Evans Ave 4 1 1 2     10 3x3   6018250.03314 2096623.41897 37.7379512950012 -122.37938406274901 (37.7379512950012, -122.379384062749)
14058 6836 1 5 1475 Fairfax Ave 1 1 1 1   04/03/2015 12:00:00 AM 3 3X3   6016046.71071 2097829.88517 37.7411422488076 -122.387086226361 (37.7411422488076, -122.387086226361)
14082 6598 3 5 1400 Evans Ave 5 1 1 2     12 3X3   6016617.02929 2097872.2499700002 37.741290138730506 -122.385117202121 (37.7412901387305, -122.385117202121)
14116 24108 3 5 101X Whitney Young Cir 15 1 1 2     12 3x3   6016610.88324 2095264.1891400001 37.7341285890533 -122.384956794538 (37.7341285890533, -122.384956794538)
14140 6797 3 5 1375 Fairfax Ave 6 1 1 2   06/30/2011 12:00:00 AM 3     6016896.75135 2097199.75019 37.7394590596789 -122.384103192232 (37.7394590596789, -122.384103192232)
14161 24226 3 5 60 Whitney Young Cir 1 1 1 2     18 4X4   6017135.66368 2094974.09134 37.7333610509772 -122.38312226117901 (37.7333610509772, -122.383122261179)
14181 24141 1 5 100X Whitney Young Cir 1 1 1 1     9 3x3   6016711.43718 2095116.50195 37.733728630852795 -122.38459886076001 (37.7337286308528, -122.38459886076)
14364 6420 3 5 1100X Evans Ave 1 1 1 2   11/29/1990 12:00:00 AM 12 3x3   6018302.7051 2096585.42337 37.7378498712671 -122.379199309611 (37.7378498712671, -122.379199309611)
14399 6795 3 5 1375 Fairfax Ave 4 1 1 2     12 3x3   6016906.375469999 2097191.59326 37.7394371944809 -122.384069348045 (37.7394371944809, -122.384069348045)
14568 8258 3 5 1555 Galvez Ave 1 1 1 2   02/14/2004 12:00:00 AM 30 3x3   6015878.41647 2097607.57172 37.7405225008163 -122.387652625679 (37.7405225008163, -122.387652625679)
14724 28654 1 5 1275 Evans Ave 4 1 1 1   03/25/2004 12:00:00 AM 3 6x3   6017442.42343 2097139.5251799999 37.739323847514 -122.38221228939 (37.739323847514, -122.38221228939)
14728 6594 3 5 1400 Evans Ave 1 1 1 2   02/03/2000 12:00:00 AM 12 3X3   6016699.98802 2097810.08527 37.741124035759796 -122.384826027706 (37.7411240357598, -122.384826027706)
14779 6775 3 5 1355 Fairfax Ave 5 1 1 2   08/11/2016 12:00:00 AM 12 3x3   6017039.80382 2097089.47454 37.7391641728912 -122.383600899281 (37.7391641728912, -122.383600899281)
14857 6772 3 5 1353 Fairfax Ave 1 1 1 2   08/11/2016 12:00:00 AM 12 3x3   6017054.96873 2097078.5407099999 37.739134988985796 -122.38354770437401 (37.7391349889858, -122.383547704374)
14947 24225 3 5 58 Whitney Young Cir 1 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6017167.401959999 2094982.30239 37.7333853506538 -122.38301310328698 (37.7333853506538, -122.383013103287)
15245 11544 3 5 101X Jennings St 34 1 1 2   12/23/1997 12:00:00 AM 3 3X3   6018840.43674 2097157.24182 37.7394496095988 -122.37737975539 (37.7394496095988, -122.37737975539)
15286 8276 3 5 1600X Galvez Ave 3 1 1 2     24 3x3   6015781.61274 2097763.57245 37.740945484337395 -122.387998221651 (37.7409454843374, -122.387998221651)
15352 97230 3 5 1301X Newcomb Ave 10 11 1 2     10 15x200   6016626.81073 2094919.21722 37.7331822459561 -122.38487770274999 (37.7331822459561, -122.38487770275)
15459 6794 1 5 1375 Fairfax Ave 3 1 1 1   12/29/1992 12:00:00 AM 6 3x3   6016884.458330001 2097207.3634599997 37.7394792845271 -122.38414622657 (37.7394792845271, -122.38414622657)
15525 3745 3 5 900 Carolina St 4 11 1 2     6 18   6012461.71984 2103674.63492 37.7569915030708 -122.39989224135799 (37.7569915030708, -122.399892241358)
15553 20453 3 5 495X Sunset Blvd 18 1 1 2     12 60            
15650 24228 3 5 62 Whitney Young Cir 1 1 1 2     12 4x4   6017105.8284599995 2094967.47212 37.7333412272151 -122.383224950289 (37.7333412272151, -122.383224950289)
15842 97227 3 5 1301X Newcomb Ave 7 11 1 2     8 15x200   6016638.64484 2094938.128 37.733234825728296 -122.384838105605 (37.7332348257283, -122.384838105605)
15924 122795 2 5 241 Mississippi St 1 1 1 1     10 3x3   6014055.37556 2105891.1297 37.7631662338691 -122.39453593861 (37.7631662338691, -122.39453593861)
15970 104641 2 5 112 07th St 2 1 1 1     10 2.5x2.5   6009525.15876 2111682.0778200002 37.7788139428406 -122.410613470452 (37.7788139428406, -122.410613470452)
15979 6431 3 5 1100X Evans Ave 13 1 1 2     12 3x3   6018097.17297 2096735.7519999999 37.738251307945596 -122.379920384224 (37.7382513079456, -122.379920384224)
16079 19828 3 5 100 STAIRWAY25 12 1 1 2     6 60X            
16094 20027 3 5 100 STAIRWAY48 11 1 1 2     6 10ST            
Powered by Datasette · Query took 33.314ms · Data source: data.sfgov.org