sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
360 6307 3 79 1804 Ellis St 2 1 1 2     6 4x4   6002139.3488 2112974.3616 37.781945376326 -122.436256362281 (37.781945376326, -122.436256362281)
700 6319 3 79 1860 Ellis St 2 1 1 2     6 4X4   6001987.058999999 2112951.3489 37.781873535447396 -122.436781566115 (37.7818735354474, -122.436781566115)
1020 10701 3 79 1290 Hayes St 2 1 1 2     24 3X3   6001704.3359 2110485.9297 37.7750880443133 -122.43758304169201 (37.7750880443133, -122.437583041692)
2704 7043 1 79 1300 Fell St 2 1 1 1   01/07/2010 12:00:00 AM 12 3X3   6001130.7028 2110062.144 37.773891804124 -122.43953697407801 (37.773891804124, -122.439536974078)
2710 141992 3 79 818 Webster St 2 1 1 2   02/12/2005 12:00:00 AM 9 Width 0ft   6003994.291 2111559.6951 37.778166271074205 -122.429738185966 (37.7781662710742, -122.429738185966)
2965 6183 3 79 1100 Ellis St 2 1 1 2     12 3X3   6005506.7779 2113443.7591 37.78342497809621 -122.424639997895 (37.7834249780962, -122.424639997895)
2995 245989 1 79 1250 Waller St 2 1 1 1   01/07/2010 12:00:00 AM 14 Width 0ft Permit Number 53135 5999854.6873 2108493.8194 37.7695128761205 -122.443838207787 (37.7695128761205, -122.443838207787)
3081 199928 1 79 1801 Ingalls St 2 1 1 11   02/27/2008 12:00:00 AM 4 Width 0ft   6016476.4427 2092884.9162 37.727588140695204 -122.385255868852 (37.7275881406952, -122.385255868852)
3350 21605 1 79 1521 Sutter St 2 1 1 1     6 4X4   6005164.0288 2114740.1913 37.7869652957353 -122.425918090858 (37.7869652957353, -122.425918090858)
3372 101650 2 79 3X Masonic Ave 2 1 1 1     6 3x3   5998828.7375 2112398.5369 37.780175655731796 -122.447668041416 (37.7801756557318, -122.447668041416)
3504 7057 3 79 1390 Fell St 2 1 1 2   02/13/1990 12:00:00 AM 12 3X3   6000831.7617 2110022.9142 37.7737670706815 -122.44056824359899 (37.7737670706815, -122.440568243599)
4200 28075 1 79 915 Columbus Ave 2 1 1 1   07/17/2010 12:00:00 AM 3 3X3   6008651.5543 2120512.2278 37.8030103621977 -122.41426054224199 (37.8030103621977, -122.414260542242)
4445 13100 3 79 1501 Lombard St 2 1 1 2   10/12/2017 12:00:00 AM 8 3X3   6005075.7106 2119828.8842 37.800932566852005 -122.42658614308701 (37.800932566852, -122.426586143087)
4690 253527 3 79 100 Haight St 2 1 1 2   10/19/2017 09:54:00 AM 3 3X3   6005589.149 2109643.5092 37.7729950707153 -122.424084680793 (37.7729950707153, -122.424084680793)
5310 6936 3 79 528 Fell St 2 1 1 2   02/22/2008 12:00:00 AM 3 3X3   6004857.7315 2110586.3971 37.775542688283 -122.426681902022 (37.775542688283, -122.426681902022)
5654 6078 3 79 1966 Eddy St 2 1 1 2     12 3X3   6001057.2451 2112477.7276 37.7805202046224 -122.439964313123 (37.7805202046224, -122.439964313123)
5930 12366 3 79 1314X Ellis St 2 1 1 2   03/05/1990 12:00:00 AM 6 3X3   6004530.405 2113308.3501 37.782997988422 -122.42800821421899 (37.782997988422, -122.428008214219)
6025 9561 1 79 1201 Golden Gate Ave 2 1 1 1     12 4X4   6003758.3426 2112108.0173 37.7796584641609 -122.430593553118 (37.7796584641609, -122.430593553118)
6095 12343 3 79 1200 Laguna St 2 1 1 2   09/16/1993 12:00:00 AM 6 4X4   6004715.5822 2113048.0527 37.7822937509983 -122.42734902850401 (37.7822937509983, -122.427349028504)
6139 13094 1 79 1450 Lombard St 2 1 1 1   04/13/1995 12:00:00 AM 12 3X3   6005349.3555 2119944.5969 37.801265750478 -122.425647455227 (37.801265750478, -122.425647455227)
6179 9633 3 79 1455 Golden Gate Ave 2 1 1 2     6 3X3   6002619.654 2111947.8436 37.779154093768796 -122.434521309627 (37.7791540937688, -122.434521309627)
6191 13159 1 79 1880 Lombard St 2 1 1 1     20 3X3   6003407.2588 2119680.3342 37.8004302230496 -122.43234907433599 (37.8004302230496, -122.432349074336)
6253 13146 1 79 1801 Lombard St 2 1 1 1   10/02/1996 12:00:00 AM 6 3x3   6003666.0486 2119638.1147 37.800328969814 -122.43145054275101 (37.800328969814, -122.431450542751)
6333 6317 3 79 1830 Ellis St 2 1 1 2     12 4X4   6002046.2828 2112962.5168 37.781907565329206 -122.436577479183 (37.7819075653292, -122.436577479183)
6345 13106 1 79 1557 Lombard St 2 1 1 1   10/26/1993 12:00:00 AM 40 3x3   6004949.0522 2119813.2474 37.8008824710059 -122.427023320732 (37.8008824710059, -122.427023320732)
6590 21597 3 79 1515 Sutter St 2 1 1 2     12 3x3   6005206.9209 2114744.2763 37.7869789360246 -122.42576998467301 (37.7869789360246, -122.425769984673)
6717 6998 3 79 950X Fell St 2 1 1 2   05/06/1992 12:00:00 AM 12 3X3   6002824.6489 2110299.3044 37.774639250423604 -122.43369429514999 (37.7746392504236, -122.43369429515)
6826 13243 1 79 2353 Lombard St 2 1 1 1     12 3X3   6001148.9876 2119284.6646 37.799215511035705 -122.440135189953 (37.7992155110357, -122.440135189953)
6887 13251 1 79 2395 Lombard St 2 1 1 1     12 3X3   6000984.848999999 2119261.9127 37.7991436944439 -122.44070153167699 (37.7991436944439, -122.440701531677)
7143 13163 3 79 1901 Lombard St 2 1 1 2     12 3X3   6003225.9808 2119572.2163 37.8001230789015 -122.43296863968 (37.8001230789015, -122.43296863968)
7459 7015 1 79 1050 Fell St 2 1 1 1   03/08/2006 12:00:00 AM 3 3X3   6002372.7109 2110234.5481 37.7744357915241 -122.435253003778 (37.7744357915241, -122.435253003778)
7519 14445 3 79 100 Masonic Ave 2 1 1 2     30 3x3   5998940.7552 2112468.0825 37.7803730113246 -122.44728552935801 (37.7803730113246, -122.447285529358)
7522 13182 3 79 2001 Lombard St 2 1 1 2     12 3x4   6002733.3901 2119504.96 37.7999104584024 -122.434668379841 (37.7999104584024, -122.434668379841)
7530 6981 3 79 802 Fell St 2 1 1 2     12 3X3   6003535.9112 2110394.3354 37.77494051486671 -122.431240682973 (37.7749405148667, -122.431240682973)
7536 6323 3 79 1864 Ellis St 2 1 1 2     6 4X4   6001889.2551 2112939.5041 37.7818354537074 -122.437119073338 (37.7818354537074, -122.437119073338)
7818 6321 3 79 1862 Ellis St 2 1 1 2     12 4X4   6001938.3263 2112944.9189 37.781853110577 -122.43694969789301 (37.781853110577, -122.436949697893)
7978 18236 1 79 1790X Post St 2 1 1 1   12/27/2007 12:00:00 AM 3 4X4   6003740.4545 2114242.5919999997 37.7855184591156 -122.43080780955201 (37.7855184591156, -122.430807809552)
8200 17682 3 79 1090 Pierce St 2 1 1 2   05/20/1992 12:00:00 AM 12 4X4   6002406.1709 2112191.9515 37.7798122317892 -122.43527729963002 (37.7798122317892, -122.43527729963)
8409 14468 3 79 211 Masonic Ave 2 1 1 2     60 2X3   5998906.7438 2112277.8895 37.779848847108795 -122.447389496791 (37.7798488471088, -122.447389496791)
8483 21607 3 79 1525 Sutter St 2 1 1 2     6 4X4   6005102.2438 2114726.9152 37.7869253509843 -122.426130907603 (37.7869253509843, -122.426130907603)
8600 12267 3 79 649 Laguna St 2 1 1 2   02/15/2005 12:00:00 AM 3 3X3   6004918.0391 2111202.3941 37.7772374748382 -122.42651715535101 (37.7772374748382, -122.426517155351)
8775 9640 1 79 1475 Golden Gate Ave 2 1 1 1   11/13/2002 12:00:00 AM 3 3X3   6002575.9976 2111942.0905 37.779135818895 -122.434671923313 (37.779135818895, -122.434671923313)
9049 26865 1 79 639 Buchanan St 2 1 1 1     6 3X3   6004491.8585 2110789.0984 37.7760785645134 -122.427961992802 (37.7760785645134, -122.427961992802)
9169 7068 1 79 1600 Fell St 2 1 1 1     24 3X3   5999680.2623 2109860.1441 37.7732545074631 -122.444539748344 (37.7732545074631, -122.444539748344)
9173 21676 1 79 1788 Sutter St 2 1 1 1     12 4X4   6004058.6995 2114630.6202 37.7866019128099 -122.42973446123199 (37.7866019128099, -122.429734461232)
9229 10682 1 79 1145 Hayes St 2 1 1 1     18 3X3   6002385.9834 2110534.2276 37.7752593905207 -122.43522853143 (37.7752593905207, -122.43522853143)
9532 2443 3 79 1296X Eddy St 2 1 1 2   10/22/1990 12:00:00 AM 12 3X3   6004305.6638 2112931.8799 37.7819515776166 -122.42875887985501 (37.7819515776166, -122.428758879855)
9607 6248 3 79 1310X Ellis St 2 1 1 2     24 4X4   6004578.6077 2113315.336 37.783019896919605 -122.427841950596 (37.7830198969196, -122.427841950596)
13604 28836 1 79 1501 Ingalls St 2 1 1 1   03/12/2005 12:00:00 AM 12 4x4   6016976.7304 2093554.8023 37.729455180200794 -122.383572968876 (37.7294551802008, -122.383572968876)
13617 29430 1 79 2401X Ingalls St 2 1 1 1   02/28/2006 12:00:00 AM 5 3X3   6015434.0318 2091490.2952 37.7237010652846 -122.388762207738 (37.7237010652846, -122.388762207738)
13658 29560 3 79 3100X Ingalls St 2 1 1 2   02/28/2006 12:00:00 AM 16 3X3   6014251.2078 2089975.3633 37.7194757354442 -122.39274513029 (37.7194757354442, -122.39274513029)
13702 22191 1 79 4011 03rd St 2 1 1 1   01/18/2008 12:00:00 AM 3     6015646.0862 2097696.0967 37.7407527004376 -122.38846211797701 (37.7407527004376, -122.388462117977)
13783 29532 3 79 2302X Ingalls St 2 1 1 2   02/28/2006 12:00:00 AM 6 3X3   6015618.3638 2091811.707 37.7245938134403 -122.388147417672 (37.7245938134403, -122.388147417672)
14182 22366 1 79 5411 03rd St 2 1 1 1     5 3X3   6014240.2849 2093075.8071 37.7279883280139 -122.39299969922199 (37.7279883280139, -122.392999699222)
14292 22494 3 79 6315 03rd St 2 1 1 2     3 3x3   6013237.8961 2090421.2401 37.7206436914379 -122.39627903536699 (37.7206436914379, -122.396279035367)
14830 29396 1 79 3001 Ingalls St 2 1 1 1   02/28/2006 12:00:00 AM 4 3x3   6014489.3554 2090228.1287 37.720183003403704 -122.39193960073999 (37.7201830034037, -122.39193960074)
14832 22358 3 79 5307 03rd St 2 1 1 2     5 3x3   6014347.5545 2093363.6036 37.7287845172254 -122.392648986246 (37.7287845172254, -122.392648986246)
14949 22438 3 79 6025 03rd St 2 1 1 2     6 3X3   6013608.4406 2091403.3166 37.72336088868371 -122.395066921688 (37.7233608886837, -122.395066921688)
15171 22197 3 79 4049 03rd St 2 1 1 2     6 3x3   6015613.0199 2097583.199 37.740440874048204 -122.388568571109 (37.7404408740482, -122.388568571109)
15301 25475 3 79 1130 Mendell St 2 1 1 2   06/02/1997 12:00:00 AM 6 3X3   6015469.9566 2096062.899 37.73625851112371 -122.388957115588 (37.7362585111237, -122.388957115588)
15437 28833 1 79 1500 Ingalls St 2 1 1 1   03/12/2005 12:00:00 AM 12 4x4   6016963.5397 2093616.3588 37.729623473146894 -122.383622854715 (37.7296234731469, -122.383622854715)
15567 22419 1 79 5815 03rd St 2 1 1 3   12/19/2000 12:00:00 AM 3 3x3   6013854.3759 2092034.5068 37.7251076834032 -122.394260933329 (37.7251076834032, -122.394260933329)
15654 22460 3 79 6150 03rd St 2 1 1 2     12 3X3   6013503.2659 2091352.4289 37.7232153120582 -122.39542693034402 (37.7232153120582, -122.395426930344)
15670 29518 3 79 2002X Ingalls St 2 1 1 2   02/28/2006 12:00:00 AM 6 3X3   6016118.5109 2092491.8522 37.7264890568376 -122.38646585917401 (37.7264890568376, -122.386465859174)
15696 29409 1 79 2715X Ingalls St 2 1 1 1   02/28/2006 12:00:00 AM 6 3x3   6014989.3241 2090898.8532 37.7220524249966 -122.39025819753901 (37.7220524249966, -122.390258197539)
15952 87520 1 79 5299 03rd St 2 1 1 1     3 3x3   6014418.8496 2093596.4572 37.7294278455371 -122.39241879281201 (37.7294278455371, -122.392418792812)
16179 30024 1 79 6190X 03rd St 2 1 1 1     3 3x3   6013452.1791 2091216.0368 37.7228379652128 -122.39559397744 (37.7228379652128, -122.39559397744)
16334 22388 1 79 5600 03rd St 2 1 1 1   05/18/2010 12:00:00 AM 9 3X3 Permit Number 53445 6014004.2537 2092658.7566 37.7268300775798 -122.393786492489 (37.7268300775798, -122.393786492489)
16346 29504 1 79 1800X Ingalls St 2 1 1 1   02/28/2006 12:00:00 AM 12 3x3   6016442.8409 2092919.0689 37.7276800583286 -122.38537441062401 (37.7276800583286, -122.385374410624)
16740 29382 1 79 3199X Ingalls St 2 1 1 1   02/28/2006 12:00:00 AM 4 3x3   6014237.1991 2089885.2205 37.7192274430768 -122.39278725067498 (37.7192274430768, -122.392787250675)
16769 29493 1 79 1700X Ingalls St 2 1 1 1   02/28/2006 12:00:00 AM 12 3X3   6016630.1295 2093166.4001 37.728369541019894 -122.384744167276 (37.7283695410199, -122.384744167276)
16817 22393 1 79 5700 03rd St 2 1 1 1   12/14/2000 12:00:00 AM 3 3X3   6013906.4177 2092399.467 37.726112683263295 -122.39410656725799 (37.7261126832633, -122.394106567258)
16856 22379 3 79 5545 03rd St 2 1 1 2   06/29/2007 12:00:00 AM 3 3x3   6014134.9775 2092764.4635 37.72712759108239 -122.39334197422 (37.7271275910824, -122.39334197422)
17108 9664 3 79 115 Gough St 2 1 1 2   01/07/1995 12:00:00 AM 18 3X3   6006036.6387 2110130.4049 37.7743572242045 -122.422571361821 (37.7743572242045, -122.422571361821)
17230 15283 3 79 1600 Mission St 2 1 1 2   04/12/1995 12:00:00 AM 6 3x3   6007077.8589 2109462.9776 37.7725833140899 -122.41892223244699 (37.7725833140899, -122.418922232447)
17781 24500 3 79 829X Fell St 2 1 1 2   06/24/1995 12:00:00 AM 12 3X3   6003428.9402 2110326.2031 37.774747377761294 -122.43160585304399 (37.7747473777613, -122.431605853044)
18723 6970 3 79 735 Fell St 2 1 1 2   06/24/1995 12:00:00 AM 12 3X3   6003863.6109 2110389.5025 37.7749458101955 -122.430106755206 (37.7749458101955, -122.430106755206)
19294 9654 3 79 95 Gough St 2 1 1 2   01/07/1995 12:00:00 AM 3 3X3   6006063.7461 2109945.4115 37.7738508061395 -122.422464444627 (37.7738508061395, -122.422464444627)
21162 24502 3 79 901 Fell St 2 1 1 2   06/24/1995 12:00:00 AM 6 3X3   6003065.2332 2110278.53 37.7745958573502 -122.432860582365 (37.7745958573502, -122.432860582365)
21220 25224 3 79 1951 Ocean Ave 2 1 1 2     18 3x3   5993865.4444 2092626.4035 37.7256015312656 -122.463402969615 (37.7256015312656, -122.463402969615)
22202 2173 3 79 1010X Haight St 2 1 1 2     11 3X3   6001288.5645 2109046.8136 37.77111294397879 -122.438918128915 (37.7711129439788, -122.438918128915)
23346 9596 3 79 1340 Golden Gate Ave 2 1 1 2   01/02/1991 12:00:00 AM 11 3X3   6003149.1044 2112077.4625 37.7795400355594 -122.432698986969 (37.7795400355594, -122.432698986969)
23565 140557 2 79 1175 MCALLISTER ST 2 1 1 1     10 Width 0ft   6003583.5208 2111740.6921 37.7786399751241 -122.43117211119 (37.7786399751241, -122.43117211119)
23809 139263 2 79 760 WEBSTER ST 2 1 1 1     5 Width 0ft   6004028.8382 2111306.0158 37.7774716865894 -122.42960057778 (37.7774716865894, -122.42960057778)
24026 140096 2 79 515 GOUGH ST 2 1 1 1     2 Width 0ft   6005837.0353 2111584.8045 37.7783393900211 -122.42336524088002 (37.7783393900211, -122.42336524088)
26024 245425 2 79 2500 16th St 2 1 1 1     9 Width 0ft   6009073.1901 2106875.611 37.7655911583595 -122.411837285128 (37.7655911583595, -122.411837285128)
26584 137902 2 79 404 Austin St 2 1 1 1     5 Width 0ft   6005251.6199 2115313.5756 37.788544615646 -122.425655870363 (37.788544615646, -122.425655870363)
26798 199951 2 79 1899 Ingalls St 2 1 1 1     7 Width 0ft   6016408.6882 2092795.6787 37.7273393636102 -122.38548388280701 (37.7273393636102, -122.385483882807)
28177 244436 2 79 404 Rose St 2 1 1 1     5 Width 0ft   6004598.6589 2109671.3511 37.7730155449031 -122.42751289271999 (37.7730155449031, -122.42751289272)
28652 35644 1 79 635 Buchanan St 2 1 1 1   03/30/1998 12:00:00 AM 9   Permit Number 38976 6004498.2203 2110755.6153 37.7759869880383 -122.427937599156 (37.7759869880383, -122.427937599156)
28713 199660 2 79 2799 Ingalls St 2 1 1 1     7 Width 0ft   6014919.1748 2090797.1689 37.7217693287026 -122.390493586774 (37.7217693287026, -122.390493586774)
29166 137923 2 79 1901 WEBSTER ST 2 1 1 1     6 Width 0ft   6003379.2097 2115283.9028 37.788357161353105 -122.432131998946 (37.7883571613531, -122.432131998946)
29984 140324 2 79 1465 LAGUNA ST 2 1 1 1     7 Width 0ft   6004553.8078 2113880.8448 37.784571240321604 -122.42796805864799 (37.7845712403216, -122.427968058648)
30044 140524 2 79 1140 MCALLISTER ST 2 1 1 1     13 Width 0ft   6003674.0233 2111802.6448 37.778815210032 -122.430863450741 (37.778815210032, -122.430863450741)
30896 138911 2 79 723 HAYES ST 2 1 1 1     7 Width 0ft   6004266.8521 2110794.1209 37.776079623036 -122.428740708053 (37.776079623036, -122.428740708053)
30915 142286 2 79 1670 GROVE ST 2 1 1 1     15 Width 0ft   5999804.9802 2110571.1381 37.7752138319513 -122.444159433615 (37.7752138319513, -122.444159433615)
31623 92117 1 79 2012 Pine St 2 1 1 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52450 6004206.4384 2115352.2396 37.788591662793 -122.42927479639401 (37.788591662793, -122.429274796394)
31667 199657 2 79 1395 Donner Ave 2 1 1 1     5 Width 0ft   6015062.4933 2090889.5822 37.7220310269415 -122.39000462027599 (37.7220310269415, -122.390004620276)
32015 184222 2 79 3521 Kirkham St 2 1 1 1     3 Width 0ft   5983907.1382 2104926.4256 37.7587952746185 -122.49873571831999 (37.7587952746185, -122.49873571832)
32291 140132 2 79 501 GOUGH ST 2 1 1 1     12 Width 0ft   6005852.7764 2111465.1717 37.778011795869006 -122.42330228001002 (37.778011795869, -122.42330228001)
32641 32360 1 79 1660 Stockton St 2 1 1 1   10/03/1996 12:00:00 AM 12   Permit Number 36912 6010075.9386 2119846.6344 37.8012627139137 -122.409284411348 (37.8012627139137, -122.409284411348)
Powered by Datasette · Query took 6.087ms · Data source: data.sfgov.org