sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3525 253489 4 31 1x Gordon St 7 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3532 253483 4 31 1x Gordon St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3533 253491 4 31 1x Gordon St 9 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3538 253485 4 31 1x Gordon St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3546 253495 4 31 1x Gordon St 13 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3553 253492 4 31 1x Gordon St 10 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3554 253490 4 31 1x Gordon St 8 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3555 253487 4 31 1x Gordon St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3562 253488 4 31 1x Gordon St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3563 253493 4 31 1x Gordon St 11 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3573 253496 4 31 1x Gordon St 14 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3581 253486 4 31 1x Gordon St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3582 253484 4 31 1x Gordon St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3587 253494 4 31 1x Gordon St 12 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
6292 87392 1 31 3322 Fillmore St 2 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
6671 87391 1 31 3322 Fillmore St 1 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.43605331890801 (37.800247665053, -122.436053318908)
13285 187639 4 31 1671 34th Ave 1 1 1 1   02/22/2017 12:00:00 AM 3 3x6   5985585.0 2103854.0 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295)
15504 49998 1 31 1101X 19th St 1 1 1 1 1 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014225.48172 2105233.1729900003 37.7613690835438 -122.39390153433901 (37.7613690835438, -122.393901534339)
17013 16027 1 31 160 Monterey Blvd 1 1 1 1   02/23/2005 12:00:00 AM 3 3X3   6001078.56062 2094701.12537 37.7317111799206 -122.43861646769899 (37.7317111799206, -122.438616467699)
18197 34055 1 31 375 Alabama St 8 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
18713 34080 1 31 240 Shotwell St 3 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
19051 582 3 31 3013 24th St 1 1 1 2   09/23/1992 12:00:00 AM 12 3x3   6008818.92095 2102127.6459 37.7525400594852 -122.41238111940099 (37.7525400594852, -122.412381119401)
19758 4166 3 31 3771 Cesar Chavez St 1 1 1 2   10/18/1999 12:00:00 AM 3 3X3   6005390.77926 2100476.4482400003 37.747813278574 -122.424118813557 (37.747813278574, -122.424118813557)
21324 621 3 31 3151 24th St 1 1 1 2   09/23/1992 12:00:00 AM 18 3X3   6007979.07595 2102079.2423799997 37.7523599891254 -122.41528202924101 (37.7523599891254, -122.415282029241)
23598 179958 2 31 162 Tunnel Ave 2 1 1 1     14 Width 3ft   6011915.65824 2087516.33041 37.7125937299935 -122.40064566366999 (37.7125937299935, -122.40064566367)
24952 34654 1 31 2000 Kirkham St 2 1 1 1 1 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505)
25124 241190 2 31 2858 25th St 1 1 1 1     8 Width 3ft   6010222.306919999 2101664.86224 37.7513480117 -122.407495323966 (37.7513480117, -122.407495323966)
26649 49071 1 31 1970 Ocean Ave 7 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
27219 215426 2 31 15 Fairfield Way 2 1 1 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
27397 241185 2 31 3781 Cesar Chavez St 2 1 1 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
28207 179962 2 31 299 Lathrop Ave 4 1 1 1     5 Width 3ft   6012155.6977 2086855.9290099998 37.710793783685006 -122.39976966465599 (37.710793783685, -122.399769664656)
29244 215411 2 31 1939 16th Ave 1 1 1 1     10 Width 2ft   5991245.12391 2102202.13663 37.7517427376545 -122.473159145982 (37.7517427376545, -122.473159145982)
29943 83166 1 31 1089 Gilman Ave 1 1 1 1   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52361 6015096.6014 2089812.1317 37.719074451264 -122.389811494874 (37.719074451264, -122.389811494874)
29979 241228 2 31 128 Laidley St 1 1 1 1     11 Width 3ft   6003596.19295 2097670.1680900003 37.740006394279796 -122.43012423703699 (37.7400063942798, -122.430124237037)
31101 66988 1 31 1445 Green St 1 1 1 1   02/12/1992 12:00:00 AM 12   Permit Number 30339 6006117.71616 2118619.27503 37.7976701397196 -122.422894339811 (37.7976701397196, -122.422894339811)
31251 241193 2 31 699 Hampshire St 1 1 1 1     7 Width 3ft   6010149.76354 2105082.07302 37.7607268479899 -122.40798714698299 (37.7607268479899, -122.407987146983)
32139 215423 2 31 15 Fairfield Way 5 1 1 1     9 Width 3ft   5993769.4086 2092813.96021 37.72611098282629 -122.46374856183998 (37.7261109828263, -122.46374856184)
34328 241212 2 31 2801 17th St 4 1 1 1     11 Width 3ft   6009052.89196 2106353.81264 37.7641572813666 -122.411870616529 (37.7641572813666, -122.411870616529)
34372 241223 2 31 2800 17th St 7 1 1 1     9 Width 3ft   6009004.56515 2106399.07167 37.7642788409211 -122.41204096432699 (37.7642788409211, -122.412040964327)
34945 113776 2 31 1710 Baker St 1 1 1 1     12 3x3   6000070.198 2114878.1306 37.7870548531015 -122.443551447546 (37.7870548531015, -122.443551447546)
35031 241196 2 31 285 Mullen Ave 5 1 1 1     10 Width 3ft   6010370.46966 2100029.8165599997 37.7468668275408 -122.406867732983 (37.7468668275408, -122.406867732983)
37469 241216 2 31 6 Fountain St 1 1 1 1     24 Width 3ft   6000321.631 2101619.05614 37.7506630907493 -122.44172961845301 (37.7506630907493, -122.441729618453)
39377 241220 2 31 2800 17th St 3 1 1 1     8 Width 3ft   6009102.18096 2106403.8524599997 37.7642974442959 -122.41170367540899 (37.7642974442959, -122.411703675409)
39697 241201 2 31 26 Carl St 2 1 1 1     11 Width 4ft   5998490.815219999 2107264.4937400003 37.7660595705173 -122.44846722318898 (37.7660595705173, -122.448467223189)
41866 181367 2 31 4019 Judah St 1 1 1 1     6 Width 0ft   5982046.1498 2105540.3564 37.76037163028771 -122.505217265817 (37.7603716302877, -122.505217265817)
42196 183595 2 31 2639 22nd Ave 1 1 1 1     10 Width 0ft   5989548.2713 2097387.6993 37.7384251583472 -122.478674965089 (37.7384251583472, -122.478674965089)
42264 246217 2 31 725 Buena Vista Ave West 5 1 1 1     9 Width 0ft   5999828.0384 2107849.3991 37.7677419398126 -122.443884078726 (37.7677419398126, -122.443884078726)
42490 241188 2 31 419 South Van Ness Ave 1 1 1 1     10 Width 4ft   6007442.12211 2107229.45736 37.7664710984984 -122.417503881697 (37.7664710984984, -122.417503881697)
44646 119965 2 31 518 28th Ave 1 1 1 1     4 Width 4ft   5987217.06494 2112373.1551 37.7794354929176 -122.48783573328801 (37.7794354929176, -122.487835733288)
47070 83362 1 31 3325 Rivera St 1 1 1 1   07/01/2008 12:00:00 AM 5 3x3 Permit Number 51120 5982822.4546 2100126.935 37.745553538391206 -122.50213183404101 (37.7455535383912, -122.502131834041)
47759 241195 2 31 699 Hampshire St 3 1 1 1     7 Width 3ft   6010149.3192300005 2105113.8429400004 37.7608140561404 -122.407990924146 (37.7608140561404, -122.407990924146)
48125 36793 1 31 1350 Donner Ave 2 1 1 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015250.697000001 2090820.757 37.721852482589796 -122.38934923747601 (37.7218524825898, -122.389349237476)
51602 197989 2 31 28 15th St 5 1 1 1     6 Width 4ft   6012209.71616 2107476.11774 37.7674154774686 -122.401030868501 (37.7674154774686, -122.401030868501)
51881 197988 2 31 82 Carolina St 1 1 1 1     10 Width 4ft   6012221.12319 2107462.35445 37.7673783228879 -122.40099044576 (37.7673783228879, -122.40099044576)
53611 109316 2 31 1516 BROADWAY 3 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
54785 66435 1 31 154 Highland Ave 1 1 1 1 1 01/29/2016 12:00:00 AM 3   Permit Number 776442 6005832.64379623 2096619.46427693 37.7372478105316 -122.422316867971 (37.7372478105316, -122.422316867971)
54816 57900 1 31 1324 Hayes St 1 1 1 1   06/09/1977 12:00:00 AM 5   Permit Number 16856 6001502.5818 2110462.7186 37.77501283944979 -122.438279288937 (37.7750128394498, -122.438279288937)
56686 241210 2 31 2801 17th St 6 1 1 1     12 Width 3ft   6009103.79641 2106355.71742 37.764165367153204 -122.41169468665899 (37.7641653671532, -122.411694686659)
57252 199656 2 31 1395 Donner Ave 1 1 1 1     13 Width 0ft   6015030.8215 2090912.727 37.7220928214053 -122.39011571883199 (37.7220928214053, -122.390115718832)
58250 215427 2 31 15 Fairfield Way 3 1 1 1     8 Width 3ft   5993797.5326 2092869.7349099999 37.726265747145604 -122.463655385788 (37.7262657471456, -122.463655385788)
59569 115612 1 31 1400 16th St 2 1 1 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
59765 241209 2 31 2801 17th St 7 1 1 1     14 Width 3ft   6009128.3617 2106356.68814 37.76416941052621 -122.411609790669 (37.7641694105262, -122.411609790669)
60020 241221 2 31 2800 17th St 4 1 1 1     9 Width 3ft   6009078.922 2106403.19833 37.764294343422996 -122.411784075669 (37.764294343423, -122.411784075669)
61689 42736 1 31 2155 Bay Shore Blvd 2 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
62417 52600 1 31 1360WASHINGTON Jones St 2 1 1 1   02/03/2006 12:00:00 AM 9   Permit Number 48694 6008503.01401 2117214.59757 37.793947543601 -122.41454108323 (37.793947543601, -122.41454108323)
65029 241191 2 31 3630 20th St 1 1 1 1     6 Width 3ft   6006057.8545699995 2104359.21039 37.7585120893797 -122.42208789256901 (37.7585120893797, -122.422087892569)
66988 179969 2 31 623 Goettingen St 2 1 1 1     4 Width 4ft   6010613.39722 2091824.0219599998 37.7243490517445 -122.40544989510599 (37.7243490517445, -122.405449895106)
68564 241227 2 31 104 Laidley St 1 1 1 1     11 Width 3ft   6003479.820730001 2097757.7557200002 37.7402402980644 -122.430532852122 (37.7402402980644, -122.430532852122)
68713 69181 1 31 1335 45th Ave 1 1 1 1 1 01/26/1994 12:00:00 AM 12   Permit Number 33220 5982114.4178 2105957.0803 37.761519851873295 -122.505012044902 (37.7615198518733, -122.505012044902)
69093 114917 1 31 86 Carr St 2 1 1 1   01/04/2016 12:00:00 AM 8   Permit 774770 6012955.87899 2090602.59506 37.721125958889104 -122.397266597771 (37.7211259588891, -122.397266597771)
69860 241226 2 31 102 Laidley St 1 1 1 1     10 Width 3ft   6003452.26052 2097778.5444 37.740295817689294 -122.43062962727 (37.7402958176893, -122.43062962727)
71330 179970 2 31 307 Athens St 2 1 1 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
73423 72214 2 31 1799 Revere Ave 3 1 1 1 1 08/18/1990 12:00:00 AM 12     6014033.56934 2095149.8862 37.7336718422767 -122.39385944784901 (37.7336718422767, -122.393859447849)
73993 241200 2 31 26 Carl St 2 1 1 1     10 Width 4ft   5998502.5017 2107263.12139 37.7660564705643 -122.448426703328 (37.7660564705643, -122.448426703328)
74241 241197 2 31 285 Mullen Ave 2 1 1 1     8 Width 3ft   6010385.48006 2100017.65971 37.7468342873856 -122.406814971529 (37.7468342873856, -122.406814971529)
75251 84928 1 31 1500@Polk Broadway 4 1 1 1   06/06/2007 12:00:00 AM 6   Permit Number 49344 6006295.343780001 2118001.00844 37.79598255651371 -122.422235750095 (37.7959825565137, -122.422235750095)
76250 215428 2 31 20 Lakewood Ave 7 1 1 1     10 Width 3ft   5993651.19736 2093024.90181 37.7266833644367 -122.464172514845 (37.7266833644367, -122.464172514845)
80153 82685 1 31 35 Jennings Ct 1 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52459 6012802.99497586 2089176.16957459 37.7172007679129 -122.397695078281 (37.7172007679129, -122.397695078281)
80952 109314 2 31 1516 BROADWAY 1 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
80956 34053 1 31 375 Alabama St 2 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
81156 109317 2 31 1516 BROADWAY 4 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
81608 44006 1 31 2701X 17th St 4 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 4 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
81701 52306 1 31 715 Buena Vista Ave West 3 1 1 1   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896)
82313 64622 1 31 350 San Carlos St 1 1 1 1 1 08/15/1988 12:00:00 AM     Permit Number 25527 6006698.09280064 2104074.24597744 37.75776573278821 -122.41985343647801 (37.7577657327882, -122.419853436478)
83290 11584 3 31 4001 Judah St 1 1 1 2     0 3X3   5982142.686634201 2105549.2773534 37.7604018044904 -122.504884056543 (37.7604018044904, -122.504884056543)
83463 49161 1 31 804 Faxon Ave 2 1 1 1 1 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.45978949774499 (37.7277062535492, -122.459789497745)
83681 34052 1 31 375 Alabama St 3 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
86383 34081 1 31 240 SHOTWELL ST 4 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
86818 68587 1 31 104 Laidley St 1 1 1 1 1 09/24/1994 12:00:00 AM     Permit Number 32485 6003450.61209517 2097770.88653532 37.7402746975659 -122.430634780555 (37.7402746975659, -122.430634780555)
86898 34083 1 31 240 Shotwell St 6 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
87190 106452 1 31 56 Lucy St 1 1 1 1   04/28/2014 12:00:00 AM 3   Permit Number 772906 6014092.7 2093830.3 37.7300518134974 -122.393562691323 (37.7300518134974, -122.393562691323)
87568 67821 1 31 669 Mississippi St 1 1 1 1 1 02/12/1993 12:00:00 AM     Permit Number 31477 6014155.20534869 2104021.00071857 37.7580368157249 -122.394059730987 (37.7580368157249, -122.394059730987)
87668 103568 2 31 223 Parnassus Ave 1 1 1 1     8 3x3   5997125.5 2106655.6 37.76430954658429 -122.45314559026801 (37.7643095465843, -122.453145590268)
87848 100205 2 31 4085 20th St 1 1 1 1   09/27/2012 12:00:00 AM 12 3x4 Permit Number 769140 6003091.0 2104064.0 37.757533730328205 -122.43232751517901 (37.7575337303282, -122.432327515179)
89328 31970 1 31 1350 Florida St 1 1 1 1   06/30/1995 12:00:00 AM     Permit Number 35371 6009512.01927897 2101306.3823381998 37.7503239226813 -122.409926287411 (37.7503239226813, -122.409926287411)
89857 49072 1 31 1970 Ocean Ave 6 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
90069 40438 1 31 400 Cortland Ave 1 1 1 1 1 06/10/1999 12:00:00 AM     Permit Number 41530 6007160.84774193 2097270.742449 37.7391109088923 -122.417770796303 (37.7391109088923, -122.417770796303)
91227 67800 1 31 4318 26th St 1 1 1 1 1 12/17/1992 12:00:00 AM     Permit Number 31444 6001831.31402978 2100620.67337741 37.7480076719463 -122.43643756932501 (37.7480076719463, -122.436437569325)
93469 69068 1 31 1407 14th Ave 1 1 1 1 1 01/10/1994 12:00:00 AM     Permit Number 33076 5991768.06854816 2105844.04694914 37.76177273191679 -122.471616117782 (37.7617727319168, -122.471616117782)
93667 49070 1 31 1970 Ocean Ave 2 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
94065 41897 1 31 2500 Market St 1 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42262 6001987.05760353 2105790.14936536 37.762210660505 -122.436268917311 (37.762210660505, -122.436268917311)
Powered by Datasette · Query took 5.264ms · Data source: data.sfgov.org