sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8284 7069 3 79 1620 Fell St 1 1 1 2     18 3X3   5999644.1221 2109852.7822 37.7732322313227 -122.44466423249399 (37.7732322313227, -122.444664232494)
5716 7070 1 79 1634 Fell St 1 1 1 1     30 3X3   5999592.5889 2109848.7666 37.7732182646887 -122.4448422034 (37.7732182646887, -122.4448422034)
9084 7073 1 79 1664 Fell St 1 1 1 1     18 3X3   5999470.1137 2109827.3502 37.773152470395296 -122.44526431981701 (37.7731524703953, -122.445264319817)
5258 7076 1 79 1712 Fell St 1 1 1 1   07/11/2008 12:00:00 AM 3 3x3   5999133.3592 2109779.0297 37.7730005664352 -122.44642571608499 (37.7730005664352, -122.446425716085)
6500 7087 1 79 1854 Fell St 1 1 1 1   05/06/1992 12:00:00 AM 12 3X3   5998578.5677 2109701.858 37.7727569698827 -122.44833924164101 (37.7727569698827, -122.448339241641)
2847 7089 1 79 1874 Fell St 1 1 1 1   04/25/2009 12:00:00 AM 3 3x3   5998459.5467 2109686.5004 37.7727079965007 -122.448749840415 (37.7727079965007, -122.448749840415)
2968 7092 1 79 1926 Fell St 1 1 1 1   12/10/2009 12:00:00 AM 3 3X3   5998180.0393 2109648.8744 37.7725886979314 -122.449713970747 (37.7725886979314, -122.449713970747)
5606 7095 1 79 1970 Fell St 1 1 1 1   12/21/1994 12:00:00 AM 18 3X3   5998027.6156 2109626.606 37.772518832985504 -122.45023961224 (37.7725188329855, -122.45023961224)
8199 7101 3 79 2070 Fell St 1 1 1 2   12/21/1994 12:00:00 AM 6 4X4   5997541.7411 2109558.8408 37.7723049499053 -122.451915402773 (37.7723049499053, -122.451915402773)
3752 7102 3 79 2080 Fell St 1 1 1 2     30 4X4   5997497.5881 2109552.6978 37.7722855537803 -122.45206768793001 (37.7722855537803, -122.45206768793)
7117 7106 3 79 2136 Fell St 1 1 1 2     24 3X3   5997200.5381 2109511.6187 37.7721557413798 -122.453092239143 (37.7721557413798, -122.453092239143)
1505 8187 3 79 1255 Fulton St 1 1 1 2     12 3X3   6001743.6158 2111134.8252 37.7768719817661 -122.43749364217301 (37.7768719817661, -122.437493642173)
7203 8199 3 79 1310X Fulton St 4 1 1 2   04/21/2011 12:00:00 AM 3 3x3   6001414.7162 2111141.806 37.7768724447291 -122.438631903562 (37.7768724447291, -122.438631903562)
22563 9064 1 79 5530 Geary Blvd 1 1 1 1   01/25/2001 12:00:00 AM 3 3X3   5989802.812000001 2112705.6659 37.7804989633648 -122.478914967756 (37.7804989633648, -122.478914967756)
6506 9520 1 79 1046 Golden Gate Ave 1 1 1 1   03/31/2000 12:00:00 AM 3 3X3   6004532.0878 2112270.4724 37.780148328739706 -122.42792841204799 (37.7801483287397, -122.427928412048)
8831 9560 1 79 1201 Golden Gate Ave 1 1 1 1   12/05/1991 12:00:00 AM 12 3x3   6003719.6013 2112101.1806 37.77963749747521 -122.430727087996 (37.7796374974752, -122.430727087996)
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)
8923 9562 1 79 1201 Golden Gate Ave 3 1 1 1     12 4X4   6003785.6894 2112111.0558 37.77966835631079 -122.43049916558701 (37.7796683563108, -122.430499165587)
5416 9589 3 79 1320 Golden Gate Ave 1 1 1 2   12/11/1997 12:00:00 AM 6 3X3   6003248.1509 2112093.2525 37.779589007656604 -122.432357471075 (37.7795890076566, -122.432357471075)
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)
5943 9604 1 79 1355 Golden Gate Ave 6 1 1 1     12 3X3   6003125.8375 2112021.5623 37.7793852280154 -122.432775482637 (37.7793852280154, -122.432775482637)
6605 9632 3 79 1455 Golden Gate Ave 1 1 1 2     18 3X3   6002597.6566 2111945.8131 37.7791472697919 -122.434597262323 (37.7791472697919, -122.434597262323)
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)
8825 9639 3 79 1475 Golden Gate Ave 1 1 1 2     12 3X3   6002557.0459 2111940.0599 37.779129167459004 -122.434737339662 (37.779129167459, -122.434737339662)
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)
20341 9651 3 79 75 Gough St 1 1 1 2   03/21/2012 12:00:00 AM 3 3x3   6006082.2488 2109830.2127 37.7735355417257 -122.422392253849 (37.7735355417257, -122.422392253849)
19870 9653 3 79 95 Gough St 1 1 1 2   01/07/1995 12:00:00 AM 18 3x3   6006060.8562 2109963.4178 37.773900084076296 -122.42247572098499 (37.7739000840763, -122.422475720985)
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)
20200 9655 3 79 95 Gough St 3 1 1 2   01/07/1995 12:00:00 AM 18 3X3   6006065.5245 2109925.4044 37.7737959717838 -122.42245687094999 (37.7737959717838, -122.42245687095)
19569 9656 3 79 95 Gough St 4 1 1 2   01/07/1995 12:00:00 AM 18 3X3   6006068.1921 2109906.7312 37.773744850157 -122.422446316196 (37.773744850157, -122.422446316196)
18047 9657 3 79 95 Gough St 5 1 1 2   01/07/1995 12:00:00 AM 18 3X3   6006069.5259 2109884.9457 37.7736851076601 -122.422440154098 (37.7736851076601, -122.422440154098)
20191 9663 3 79 115 Gough St 1 1 1 2   01/07/1995 12:00:00 AM 18 3X3   6006029.8522 2110171.1235 37.774468644794204 -122.42259773170099 (37.7744686447942, -122.422597731701)
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)
18144 9669 3 79 203 Gough St 1 1 1 2   01/07/1995 12:00:00 AM 18 3X3   6006010.5370000005 2110311.0286 37.7748517007261 -122.42267449094999 (37.7748517007261, -122.42267449095)
17489 9671 1 79 207 Gough St 1 1 1 1   01/07/1995 12:00:00 AM 24 3X3   6005999.0821 2110438.7223 37.77520167050999 -122.422723192397 (37.77520167051, -122.422723192397)
8648 9718 1 79 555 Gough St 3 1 1 1     15 4X4   6005827.0659 2111648.8185 37.7785145942054 -122.423404280737 (37.7785145942054, -122.423404280737)
7255 9753 3 79 725 Gough St 1 1 1 2   03/05/1990 12:00:00 AM 16 4x4   6005752.1131 2112212.6104 37.780058398475106 -122.423703668106 (37.7800583984751, -122.423703668106)
8543 9758 3 79 735 Gough St 3 1 1 2   02/25/1997 12:00:00 AM 18 4x4   6005747.9577 2112242.2179 37.78013945886 -122.423720149275 (37.78013945886, -122.423720149275)
6447 9761 1 79 745 Gough St 3 1 1 1   02/25/1997 12:00:00 AM 8 4x4   6005736.7899 2112320.9115 37.7803549018091 -122.423764380812 (37.7803549018091, -122.423764380812)
20140 10246 3 79 100 Haight St 1 1 1 2     30 3X3   6005589.149 2109643.5092 37.7729950707153 -122.424084680793 (37.7729950707153, -122.424084680793)
20257 10302 3 79 596 Haight St 1 1 1 2   05/29/1997 12:00:00 AM 20 3X3   6003330.7652 2109326.5077 37.7719968952641 -122.431874063617 (37.7719968952641, -122.431874063617)
21406 10305 3 79 614 Haight St 1 1 1 2   03/03/1999 12:00:00 AM 25 3x3   6003095.7029 2109294.636 37.7718960552644 -122.432684884303 (37.7718960552644, -122.432684884303)
19372 10310 1 79 630 Haight St 1 1 1 1   06/15/2004 12:00:00 AM 8     6002998.1704 2109278.2038 37.771845404706504 -122.433021081698 (37.7718454047065, -122.433021081698)
17246 10340 3 79 914 Haight St 1 1 1 2     90 3X4   6001716.4806 2109101.7503 37.7712881236094 -122.437441889428 (37.7712881236094, -122.437441889428)
20328 10344 3 79 946 Haight St 1 1 1 2     24 3x3   6001573.5571 2109081.4751 37.7712243264402 -122.43793481453899 (37.7712243264402, -122.437934814539)
17853 10365 3 79 1158 Haight St 1 1 1 2   10/01/2001 12:00:00 AM 20 3X3   6000552.7964 2108940.2901 37.7707785679811 -122.44145552457199 (37.7707785679811, -122.441455524572)
18847 10366 1 79 1166 Haight St 1 1 1 1     40 3X4   6000501.5622 2108932.6998 37.7707548079908 -122.441632199385 (37.7707548079908, -122.441632199385)
19252 10388 3 79 1354 Haight St 1 1 1 2   09/26/2007 12:00:00 AM 3 3X3   5999661.5734 2108814.8136 37.770383228179895 -122.44452925228799 (37.7703832281799, -122.444529252288)
17810 10406 1 79 1386 Haight St 1 1 1 1   06/29/2007 12:00:00 AM 3 3x3   5999529.6926 2108795.3635 37.7703222971334 -122.444984028084 (37.7703222971334, -122.444984028084)
17221 10407 1 79 1392 Haight St 1 1 1 1   01/01/2009 12:00:00 AM 8 3x3   5999510.2425 2108793.466 37.7703159769785 -122.445051169277 (37.7703159769785, -122.445051169277)
20800 10428 1 79 1427 Haight St 1 1 1 1   09/26/2007 12:00:00 AM 3 3X3   5999264.0192 2108708.6767 37.7700691107077 -122.44589675291799 (37.7700691107077, -122.445896752918)
17277 10431 1 79 1430 Haight St 1 1 1 1   02/02/2004 12:00:00 AM 8 3X3   5999221.0892 2108752.9533 37.770188231639 -122.446048431812 (37.770188231639, -122.446048431812)
17441 10432 3 79 1441 Haight St 1 1 1 2   03/18/1999 12:00:00 AM 18 3X3   5999180.1356 2108696.8663 37.770031892228495 -122.44618605438801 (37.7700318922285, -122.446186054388)
18101 10433 1 79 1449 Haight St 1 1 1 1   05/12/2001 12:00:00 AM 3 3x3   5999155.0008 2108693.838 37.7700221418409 -122.446272777074 (37.7700221418409, -122.446272777074)
23032 10440 3 79 1476 Haight St 1 1 1 2     3 3X3   5999041.0219 2108727.6134 37.770108370408 -122.44666945726999 (37.770108370408, -122.44666945727)
19979 10448 1 79 1525 Haight St 1 1 1 1   08/09/1996 12:00:00 AM 20 2X3   5998831.2765 2108649.625 37.7698822506188 -122.447389347046 (37.7698822506188, -122.447389347046)
19192 10456 1 79 1556 Haight St 1 1 1 1     8 3x3   5998680.607000001 2108678.296 37.7699523629106 -122.447912571831 (37.7699523629106, -122.447912571831)
17480 10468 1 79 1600 Haight St 1 1 1 1   03/04/1993 12:00:00 AM 10 3x3   5998442.2021 2108643.6888 37.7698437104477 -122.448734713286 (37.7698437104477, -122.448734713286)
19714 10469 3 79 1608 Haight St 1 1 1 2   09/06/2011 12:00:00 AM 3 3x3   5998376.833 2108635.1438 37.769816509818796 -122.44896020681499 (37.7698165098188, -122.448960206815)
21334 10471 3 79 1628 Haight St 1 1 1 2   09/06/2011 12:00:00 AM 1 3x3   5998338.8079 2108630.4441 37.769801430915706 -122.44909139548 (37.7698014309157, -122.44909139548)
23333 10480 3 79 1665 Haight St 1 1 1 2   06/09/1992 12:00:00 AM 1 3X3   5998086.3169 2108545.149 37.7695527882164 -122.44995860301701 (37.7695527882164, -122.449958603017)
18673 10488 3 79 1679 Haight St 1 1 1 2     12 3X3   5998021.2087 2108536.3669 37.7695249491594 -122.45018317568399 (37.7695249491594, -122.450183175684)
22121 10491 3 79 1694 Haight St 1 1 1 2   06/19/2008 12:00:00 AM 3 3X3   5998067.7185 2108593.9143 37.769685621068895 -122.45002644909901 (37.7696856210689, -122.450026449099)
23274 10492 3 79 1699 Haight St 1 1 1 2   06/09/1992 12:00:00 AM 10 3X3   5997918.2468 2108523.3453 37.7694833025616 -122.450538376308 (37.7694833025616, -122.450538376308)
23211 10510 3 79 1793 Haight St 1 1 1 2   06/09/1992 12:00:00 AM 1     5997601.0333 2108476.5582 37.7693366759731 -122.451632224006 (37.7693366759731, -122.451632224006)
21260 10511 1 79 1800 Haight St 1 1 1 1   02/10/2007 12:00:00 AM 6 3X3   5997484.5237 2108509.319 37.7694199557275 -122.452037587086 (37.7694199557275, -122.452037587086)
16912 10519 1 79 1840 Haight St 1 1 1 1   02/27/1990 12:00:00 AM 50     5997331.1413 2108490.0928 37.76935837855329 -122.45256673963301 (37.7693583785533, -122.452566739633)
5419 10640 3 79 879 Hayes St 1 1 1 2   05/26/1992 12:00:00 AM 12 3X3   6003664.2022 2110709.9334 37.7758143385689 -122.430819424449 (37.7758143385689, -122.430819424449)
5463 10657 3 79 945 Hayes St 1 1 1 2   03/05/1990 12:00:00 AM 6     6003325.2554 2110665.5174 37.7756731734805 -122.43198875443701 (37.7756731734805, -122.431988754437)
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)
6059 10683 1 79 1155 Hayes St 1 1 1 1     12 3X3   6002334.989 2110528.6392 37.775241150218 -122.43540453260401 (37.775241150218, -122.435404532604)
6863 10685 1 79 1167 Hayes St 1 1 1 1     12 3x3   6002283.296 2110520.9551 37.7752171157043 -122.435582800345 (37.7752171157043, -122.435582800345)
6702 10686 3 79 1179 Hayes St 1 1 1 2     18 3X3   6002229.5074 2110511.8739 37.775189125797205 -122.435768217131 (37.7751891257972, -122.435768217131)
6411 10687 1 79 1185 Hayes St 1 1 1 1     18 3X3   6002205.7566 2110510.4768 37.775183940568496 -122.435850276383 (37.7751839405685, -122.435850276383)
1927 10692 3 79 1249 Hayes St 1 1 1 2     6 3X3   6001880.3859 2110463.9678 37.7750377503654 -122.43697247440201 (37.7750377503654, -122.436972474402)
6167 10693 1 79 1250 Hayes St 1 1 1 1     18 3X3   6001870.5552 2110507.5567 37.7751568758154 -122.43700960221001 (37.7751568758154, -122.43700960221)
5939 10696 3 79 1257 Hayes St 1 1 1 2     12 3X3   6001848.8335 2110459.5307 37.7750237737687 -122.43708130308998 (37.7750237737687, -122.43708130309)
23234 10697 3 79 1273 Hayes St 1 1 1 2     14 3X3   6001825.1691 2110457.0657 37.7750156603511 -122.437162986716 (37.7750156603511, -122.437162986716)
5670 10699 3 79 1275 Hayes St 1 1 1 2     18 3X3   6001777.3475 2110450.1636 37.774993990438205 -122.43732791737 (37.7749939904382, -122.43732791737)
5517 10700 3 79 1290 Hayes St 1 1 1 2     24 3X3   6001738.9392 2110489.0192 37.775098494652795 -122.437463562764 (37.7750984946528, -122.437463562764)
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)
15697 12242 3 79 1130 Mendell St 3 1 1 2   03/04/1997 12:00:00 AM 6 3X3   6015460.5377 2096047.2009 37.7362148852375 -122.388988585219 (37.7362148852375, -122.388988585219)
2481 12266 3 79 649 Laguna St 1 1 1 2   02/02/1991 12:00:00 AM 16 3X3   6004915.2268 2111219.2684 37.7772836485499 -122.426528085844 (37.7772836485499, -122.426528085844)
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)
5639 12273 1 79 721 Laguna St 1 1 1 1   02/02/1991 12:00:00 AM 12 3X3   6004895.7756 2111355.1796 37.7776557277721 -122.426605054269 (37.7776557277721, -122.426605054269)
5743 12280 1 79 741 Laguna St 1 1 1 1   06/10/1997 12:00:00 AM 3 3X3   6004879.1558 2111501.6218 37.7780568825374 -122.42667297875201 (37.7780568825374, -122.426672978752)
6548 12281 1 79 739 Laguna St 1 1 1 1     18 3X3   6004881.0373 2111477.1625 37.777989829673096 -122.426664727755 (37.7779898296731, -122.426664727755)
1195 12282 3 79 745 Laguna St 1 1 1 2     18 5x10   6004875.3929 2111529.8441 37.7781341613075 -122.42668800624901 (37.7781341613075, -122.426688006249)
3985 12338 3 79 1151X Laguna St 1 1 1 2   06/10/1997 12:00:00 AM 12 3X3   6004696.7001 2112810.35 37.7816400103646 -122.427397413482 (37.7816400103646, -122.427397413482)
6733 12339 3 79 1199 Laguna St 1 1 1 2   01/22/1999 12:00:00 AM 12 3X3   6004687.2548 2112907.9517 37.7819074662565 -122.42743704493999 (37.7819074662565, -122.42743704494)
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)
8127 12344 3 79 1200 Laguna St 3 1 1 2   09/16/1993 12:00:00 AM 6 4X4   6004712.8065 2113066.0947 37.782343132875795 -122.427359916847 (37.7823431328758, -122.427359916847)
3599 12345 3 79 1200 Laguna St 4 1 1 2   05/27/1992 12:00:00 AM 6 4X4   6004709.3369 2113084.1368 37.782392475782 -122.42737320580099 (37.782392475782, -122.427373205801)
23070 12346 3 79 1200X Laguna St 1 1 1 2     13     6004717.664 2113030.0107 37.7822443298756 -122.427340540761 (37.7822443298756, -122.427340540761)
7923 12350 3 79 1280 Laguna St 1 1 1 2   06/10/1997 12:00:00 AM 3 4x4   6004697.5402 2113177.8166 37.782649030091704 -122.42742069293699 (37.7826490300917, -122.427420692937)
9620 12359 3 79 1295X Ellis St 1 1 1 2     24 4X6   6004744.0331 2113287.4568 37.7829527043097 -122.427267659807 (37.7829527043097, -122.427267659807)
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)
5369 12368 3 79 1325 Laguna St 1 1 1 2   02/02/1991 12:00:00 AM 18 3X3   6004615.632999999 2113432.0006 37.7833423233744 -122.42772217323 (37.7833423233744, -122.42772217323)
2361 12987 1 79 318 Lombard St 1 1 1 1   08/19/2006 12:00:00 AM 3 3X3   6010766.7048 2120702.1725 37.8036504876245 -122.406954379692 (37.8036504876245, -122.406954379692)
2645 13092 1 79 1447 Lombard St 1 1 1 1   03/18/2005 12:00:00 AM 8 3x3   6005407.9937 2119875.0129 37.8010780038521 -122.42543958631501 (37.8010780038521, -122.425439586315)
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)
Powered by Datasette · Query took 8.268ms · Data source: data.sfgov.org