sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
149 26071 3 50 247 Orizaba Ave 1 1 1 2   03/28/2017 01:41:00 PM 3 3X3   5993990.1569314 2088190.8403771 37.7134297247264 -122.46265023824101 (37.7134297247264, -122.462650238241)
626 251342 3 50 2275 Ocean Ave 2 1 1 2   11/14/1996 12:00:00 AM   3x3 Permit Number 37503 5992527.0 2093770.0 37.7286643609316 -122.46811297163299 (37.7286643609316, -122.468112971633)
638 251341 1 50 2275 Ocean Ave 1 1 1 1   11/14/1996 12:00:00 AM   3x3 Permit Number 37503 5992527.0 2093770.0 37.7286643609316 -122.46811297163299 (37.7286643609316, -122.468112971633)
864 37366 1 50 125 Street 1 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39871          
963 251419 2 50 39 Jones St 2 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
970 251418 2 50 39 Jones St 1 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
1005 131220 1 50 411 Leavenworth St 2 1 1 1   01/18/1994 12:00:00 AM 8 Width 5ft Permit Number 33166 6008433.24487 2113895.82908 37.7848310944226 -122.414547535863 (37.7848310944226, -122.414547535863)
1402 108699 1 50 2956 Scott St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774624 6001032.64864 2118516.20126 37.797098889465 -122.4404826167 (37.797098889465, -122.4404826167)
1808 26069 3 50 271 Orizaba Ave 1 1 1 2   06/27/1997 12:00:00 AM 3 3X3   5993995.7894187 2088348.3730133998 37.713862596316 -122.462642190986 (37.713862596316, -122.462642190986)
1852 178671 2 50 624 Rolph St 1 1 1 1     8 Width 5ft   6002757.8843 2087321.68 37.7115442544376 -122.432283877092 (37.7115442544376, -122.432283877092)
1977 35358 1 50 861 Rhode Island St 1 1 1 1 1 06/14/2017 12:00:00 AM 3   Permit Number 779956 6011891.4551800005 2104381.4501400003 37.758900452609794 -122.401914128638 (37.7589004526098, -122.401914128638)
1995 193739 3 50 65 Whitney Young Cir 11 1 1 2     3 Width 4ft   6016922.219330001 2094905.4243400001 37.7331607080971 -122.383855425397 (37.7331607080971, -122.383855425397)
2598 110677 1 50 1717 Mason St 2 1 1 1 1 07/07/2015 12:00:00 AM 3     6009154.39159 2119176.95818 37.7993722757787 -122.412426018055 (37.7993722757787, -122.412426018055)
3166 210180 1 50 433 Congo St 1 1 1 1   06/23/2000 12:00:00 AM 10 Width 2ft Permit Number 42521 6000082.86486 2095135.8413200001 37.7328481163341 -122.4420899714 (37.7328481163341, -122.4420899714)
3180 210181 1 50 433 Congo St 2 1 1 1   06/23/2000 12:00:00 AM 12 Width 2ft Permit Number 42521 6000081.5883599995 2095118.51755 37.7328004765596 -122.442093141495 (37.7328004765596, -122.442093141495)
3253 120896 2 50 3760 Webster St 1 1 1 1   10/04/2016 12:00:00 AM 3 2x6 Permit Number 778876 6002561.2369800005 2121569.64726 37.805569771989205 -122.43541187026399 (37.8055697719892, -122.435411870264)
3609 246906 1 50 491 Frederick St 4 1 1 1   11/23/2010 12:00:00 AM 3 Width 5ft Permit Number 53958 5997348.6484 2107404.24528 37.7663779224388 -122.45242781498699 (37.7663779224388, -122.452427814987)
3881 232104 1 50 308 Laidley St 2 1 1 1   06/17/1997 12:00:00 AM 12 Width 3ft Permit Number 38019 6004039.72435 2096794.4699099998 37.7376270372551 -122.42852828485901 (37.7376270372551, -122.428528284859)
4151 216680 2 50 430 Grafton Ave 1 1 1 1   10/06/2017 07:33:00 AM 3 Width 3ft   5995444.86919 2090582.23732 37.720079609356205 -122.45779521180401 (37.7200796093562, -122.457795211804)
4208 163311 2 50 261 Sadowa St 1 1 1 1   10/10/2017 08:33:00 AM 3 Width 0ft   5994382.20064 2087745.46311 37.7122293948338 -122.46126294184201 (37.7122293948338, -122.461262941842)
4262 163377 2 50 210 Sadowa St 1 1 1 1   10/10/2017 08:24:00 AM 3 Width 0ft   5994919.0 2087792.0 37.7123880531541 -122.45941098523701 (37.7123880531541, -122.459410985237)
4263 163376 2 50 204 Sadowa St 2 1 1 1   10/10/2017 08:04:00 AM 3 Width 0ft   5994976.692009999 2087776.5788200002 37.7123490271688 -122.45921046950899 (37.7123490271688, -122.459210469509)
4269 163375 2 50 204 Sadowa St 1 1 1 1   10/10/2017 07:56:00 AM 3 Width 0ft   5994989.76466 2087776.26613 37.712348920149104 -122.45916526416799 (37.7123489201491, -122.459165264168)
4397 251730 2 50 536 Rolph St 1 1 1 1   10/11/2017 11:34:00 AM 3 3x3   6002599.0 2087392.0 37.71172832759 -122.432838043044 (37.71172832759, -122.432838043044)
4829 187456 1 50 4727 Mission St 1 1 1 1   05/02/1995 12:00:00 AM 1 Width 0ft   6001715.1447 2091405.3885 37.722698028608 -122.43617990767099 (37.722698028608, -122.436179907671)
4920 224837 2 50 268 Chattanooga St 1 1 1 1   11/01/2017 12:40:00 PM 3 Width 3ft   6004749.38547 2102099.60781 37.752233863708895 -122.42645227906601 (37.7522338637089, -122.426452279066)
5259 42922 1 50   1 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42829          
5550 37365 1 50 125 Street 2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39871          
6555 22647 3 50 1251 Turk St 1 1 1 2   12/10/1990 12:00:00 AM 18 3X3   6003892.2472 2112477.7184 37.780681156415895 -122.430156700947 (37.7806811564159, -122.430156700947)
6939 22658 3 50 1251 Turk St 12 1 1 2   05/18/1992 12:00:00 AM 12 3X3   6004212.8538 2112518.7504 37.7808119734419 -122.429050494981 (37.7808119734419, -122.429050494981)
7440 9542 1 50 1100X Golden Gate Ave 10 1 1 3   03/31/2000 12:00:00 AM 3 3X3   6003977.1107 2112193.8912 37.7799066435706 -122.429842866574 (37.7799066435706, -122.429842866574)
7765 18879 1 50 2315 Sacramento St 1 1 1 1   06/09/1998 12:00:00 AM 3 3X3   6003607.44812 2115913.14135 37.790097828305 -122.431387267427 (37.790097828305, -122.431387267427)
7827 9544 1 50 1100X Golden Gate Ave 12 1 1 3     6 3X3   6003937.8747 2112189.6367 37.7798927397998 -122.429978297745 (37.7798927397998, -122.429978297745)
7858 22652 3 50 1251 Turk St 6 1 1 2   05/18/1992 12:00:00 AM 18 3X3   6004004.2161 2112490.9321 37.7807237790226 -122.429770289505 (37.7807237790226, -122.429770289505)
8253 22651 3 50 1251 Turk St 5 1 1 2   12/10/1990 12:00:00 AM 18 3X3   6003985.4387 2112488.1502 37.7807150772953 -122.4298350511 (37.7807150772953, -122.4298350511)
8410 22654 3 50 1251 Turk St 8 1 1 2     18 5x6   6004084.8894 2112499.2776 37.7807512616309 -122.42949179698 (37.7807512616309, -122.42949179698)
8432 22657 1 50 1251 Turk St 11 1 1 1     18 5x6   6004182.2536 2112515.9686 37.780802603117706 -122.42915615755899 (37.7808026031177, -122.429156157559)
8672 22653 3 50 1251 Turk St 7 1 1 2     18 3X3   6004029.2526 2112495.8003 37.7807385635944 -122.429684023491 (37.7807385635944, -122.429684023491)
8985 106565 1 50 3036 Pierce St 1 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773498 6001472.42472 2118868.9622400003 37.7980925099205 -122.438986180768 (37.7980925099205, -122.438986180768)
9103 24126 1 50 140X Whitney Young Cir 5 1 1 1   05/07/1997 12:00:00 AM 9 3X3   6016343.6401634 2095980.6654178002 37.736081103602096 -122.38593067194799 (37.7360811036021, -122.385930671948)
9111 10861 1 50 1299X HUDSON AVE 10 1 1 1   04/28/2016 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
9153 24125 1 50 140X Whitney Young Cir 4 1 1 1   03/17/2016 12:00:00 AM 3 3X3   6016343.6401634 2095980.6654178002 37.736081103602096 -122.38593067194799 (37.7360811036021, -122.385930671948)
9157 10857 1 50 1299X HUDSON AVE 6 1 1 1   04/28/2016 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
9247 24150 1 50 100X Whitney Young Cir 10 1 1 1   05/12/1996 12:00:00 AM 7 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
9276 24081 1 50 141X Whitney Young Cir 3 1 1 1   01/02/2001 12:00:00 AM 3 3X3   6016393.5495733 2095983.6738742 37.7360921261264 -122.38575832291299 (37.7360921261264, -122.385758322913)
9330 24138 1 50 120X Whitney Young Cir 5 1 1 1   12/05/1997 12:00:00 AM 9 3x3   6016341.404377299 2096017.7564546003 37.736182824394206 -122.38594098669901 (37.7361828243942, -122.385940986699)
9342 24095 1 50 105X Whitney Young Cir 2 1 1 1   05/15/1996 12:00:00 AM 5 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
9378 24087 1 50 141X Whitney Young Cir 9 1 1 1   04/26/2000 12:00:00 AM 9 3X3   6016393.5495733 2095983.6738742 37.7360921261264 -122.38575832291299 (37.7360921261264, -122.385758322913)
9427 24136 1 50 120X Whitney Young Cir 3 1 1 1   05/14/1996 12:00:00 AM 6 3x3   6016341.404377299 2096017.7564546003 37.736182824394206 -122.38594098669901 (37.7361828243942, -122.385940986699)
9483 24137 1 50 120X Whitney Young Cir 4 1 1 1   05/14/1996 12:00:00 AM 12 3x3   6016341.404377299 2096017.7564546003 37.736182824394206 -122.38594098669901 (37.7361828243942, -122.385940986699)
9769 159355 4 50 417 Ellington Ave 2 1 1 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.882680001 2087558.1907400002 37.7119518775514 -122.44698304145001 (37.7119518775514, -122.44698304145)
10185 86271 3 50 1498X 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988421.0 2105155.0 37.7596865840953 -122.48314164268601 (37.7596865840953, -122.483141642686)
10186 86272 3 50 1498X 25th Ave 2 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988421.0 2105155.0 37.7596865840953 -122.48314164268601 (37.7596865840953, -122.483141642686)
10286 109713 1 50 643 Edinburgh St 1 1 1 1 1 03/02/2015 12:00:00 AM 3 3x3 Permit Number 774155 6002421.08479 2090027.9033099997 37.7189558444233 -122.43364123018 (37.7189558444233, -122.43364123018)
10294 15756 1 50 4669 Mission St 1 1 1 1   05/02/1995 12:00:00 AM 6 3X3   6001905.7706 2091706.1989 37.723534814894 -122.435542465485 (37.723534814894, -122.435542465485)
10393 85922 3 50 1750 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988150.1283 2103379.9075 37.754796893765395 -122.483948277297 (37.7547968937654, -122.483948277297)
10504 86267 3 50 1562 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988412.0307 2104673.7348 37.7583646382457 -122.483137386721 (37.7583646382457, -122.483137386721)
10551 15791 1 50 4859 Mission St 1 1 1 1   04/28/1995 12:00:00 AM 7 3x3   6001243.5294 2090654.0842 37.720608310371794 -122.437756393358 (37.7206083103718, -122.437756393358)
10552 86314 3 50 1563 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988370.7453 2104668.8777 37.758348899365394 -122.483279812102 (37.7583488993654, -122.483279812102)
10566 85914 3 50 1882 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988180.9701 2102501.3004 37.7523862701891 -122.483777202176 (37.7523862701891, -122.483777202176)
10576 85916 3 50 1838 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988170.1375 2102775.399 37.753138240815204 -122.48383475868201 (37.7531382408152, -122.483834758682)
10583 86264 3 50 1694 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988441.0116 2103811.0505 37.755997626406206 -122.482973932182 (37.7559976264062, -122.482973932182)
10706 15766 1 50 4760 Mission St 1 1 1 1   04/26/1995 12:00:00 AM 12 3X3   6001476.2489 2091134.8369 37.721941579108794 -122.436986357081 (37.7219415791088, -122.436986357081)
10774 15813 1 50 5017 Mission St 1 1 1 1   08/08/2003 12:00:00 AM 12 3x3   6000686.592 2089771.9365 37.71815444799179 -122.439618338087 (37.7181544479918, -122.439618338087)
10847 15814 3 50 5017 Mission St 2 1 1 2   04/27/1995 12:00:00 AM 12 3X3   6000703.7551 2089800.5417 37.7182339682695 -122.43956106225401 (37.7182339682695, -122.439561062254)
10916 86279 3 50 1370 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988367.4417 2105985.7022 37.761964349683396 -122.48338776877199 (37.7619643496834, -122.483387768772)
10918 86319 3 50 1687 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988396.6413 2103838.6204 37.756070744005605 -122.483129398253 (37.7560707440056, -122.483129398253)
11034 15821 3 50 5051 Mission St 1 1 1 2   04/27/1995 12:00:00 AM 6 3X3   6000582.469 2089604.8822 37.717689827708895 -122.43996627417101 (37.7176898277089, -122.439966274171)
11050 86410 3 50 1823 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988122.3065 2102871.1988 37.7533984968143 -122.484007190165 (37.7533984968143, -122.484007190165)
11063 86318 3 50 1659 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988389.7488 2104019.117 37.7565659379204 -122.48316646418999 (37.7565659379204, -122.48316646419)
11211 85907 3 50 2246 26th Ave 1 1 1 2   12/20/2006 12:00:00 AM 3 3x3   5988262.6758 2100024.3615 37.7455900114068 -122.48331310017299 (37.7455900114068, -122.483313100173)
11245 85919 3 50 1792 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988158.7855 2103127.4828 37.7541043074668 -122.483899830474 (37.7541043074668, -122.483899830474)
11255 86284 3 50 1330 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988359.3252 2106249.2195 37.762687423978 -122.483435159107 (37.762687423978, -122.483435159107)
11263 86266 3 50 1650 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988431.5344 2104067.7951 37.75670202642571 -122.483025524044 (37.7567020264257, -122.483025524044)
11299 86306 3 50 1483 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988351.387999999 2105239.4954 37.7599145343681 -122.483388587245 (37.7599145343681, -122.483388587245)
11342 86268 3 50 1554 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988410.0879 2104736.3916 37.7585365638092 -122.483148698285 (37.7585365638092, -122.483148698285)
11405 86274 3 50 1470 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988390.8371 2105304.6829 37.7600958174171 -122.48325693207899 (37.7600958174171, -122.483256932079)
11446 15765 3 50 4750 Mission St 1 1 1 2   04/26/1995 12:00:00 AM 12 3X3   6001511.2475 2091189.3697 37.7220933031097 -122.436869277919 (37.7220933031097, -122.436869277919)
11485 86280 3 50 1366 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988366.3595 2106019.7917 37.7620578871803 -122.483394010737 (37.7620578871803, -122.483394010737)
11502 86307 3 50 1491 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988352.2197 2105195.8317 37.7597946941019 -122.483382509952 (37.7597946941019, -122.483382509952)
11561 85917 3 50 1830 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988168.9979 2102827.2497 37.7532805425745 -122.48384250118299 (37.7532805425745, -122.483842501183)
11583 86277 3 50 1390 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988371.7706 2105858.0017 37.761613970822 -122.48336343539101 (37.761613970822, -122.483363435391)
11585 15794 3 50 4929 Mission St 1 1 1 2   02/23/2007 12:00:00 AM 8 3x3   6000979.6747 2090237.6292 37.7194498121599 -122.43863862911199 (37.7194498121599, -122.438638629112)
11590 15745 3 50 4570 Mission St 1 1 1 2   04/21/1995 12:00:00 AM 15 3X3   6002141.222999999 2092193.7491 37.7248868880905 -122.434763397745 (37.7248868880905, -122.434763397745)
11613 15789 1 50 4855 Mission St 1 1 1 1   04/28/1995 12:00:00 AM 8 3x3   6001259.5956 2090679.9975 37.720680375992295 -122.437702712586 (37.7206803759923, -122.437702712586)
11621 76445 2 50 118X Lowell St 6 1 1 1 1 05/30/1998 12:00:00 AM 10 3x3   5998808.0264099995 2086988.0844400001 37.710403523785 -122.445911599067 (37.710403523785, -122.445911599067)
11631 15824 3 50 5060 Mission St 2 1 1 2   04/26/1995 12:00:00 AM 12 3X3   6000432.8297 2089486.0645 37.7173550615336 -122.440474991501 (37.7173550615336, -122.440474991501)
11647 24814 3 50 4749 Mission St 1 1 1 2   05/02/1995 12:00:00 AM 12 3X3   6001619.1557 2091250.5894 37.7222675310536 -122.436500645989 (37.7222675310536, -122.436500645989)
11661 86405 3 50 1751 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988101.9893 2103387.0665 37.7548137478444 -122.48411527814501 (37.7548137478444, -122.484115278145)
11676 86269 3 50 1514 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988401.8308 2104975.3617 37.7591922304865 -122.48319477105301 (37.7591922304865, -122.483194771053)
11828 15762 1 50 4731 Mission St 1 1 1 1   05/02/1995 12:00:00 AM 6 3X3   6001687.4296 2091360.7739 37.722573952286794 -122.436272521266 (37.7225739522868, -122.436272521266)
11830 86278 3 50 1386 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988372.3117 2105874.2348 37.761658573987496 -122.483362753995 (37.7616585739875, -122.483362753995)
11857 86285 3 50 1326 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988357.7019 2106271.4048 37.762748244281795 -122.483442399915 (37.7627482442818, -122.483442399915)
11872 86305 3 50 1475 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988348.892999999 2105280.6641 37.7600274272341 -122.483400234139 (37.7600274272341, -122.483400234139)
11892 86407 3 50 1767 26th Ave 1 1 1 2   12/19/2006 12:00:00 AM 3 3x3   5988104.9226 2103286.9146 37.7545389284857 -122.48409779006599 (37.7545389284857, -122.484097790066)
11931 15807 1 50 4959 Mission St 1 1 1 1   04/27/1995 12:00:00 AM 6 3X3   6000887.0139999995 2090089.1979 37.719036981600496 -122.43894829066299 (37.7190369816005, -122.438948290663)
11961 86303 3 50 1467 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988346.8137 2105325.1594 37.7601494782311 -122.48341068724599 (37.7601494782311, -122.483410687246)
11977 86290 3 50 1323 25th Ave 1 1 1 2   12/05/2006 12:00:00 AM 3 3x3   5988313.8725 2106295.7544 37.7628125505969 -122.483595773705 (37.7628125505969, -122.483595773705)
12038 15746 1 50 4585 Mission St 1 1 1 1   05/02/1995 12:00:00 AM 6 4x4   6002220.4386 2092206.761 37.72492711289 -122.434490488851 (37.72492711289, -122.434490488851)
12056 85925 3 50 1730 26th Ave 1 1 1 2   12/20/2006 12:00:00 AM 3 3x3   5988145.2074 2103504.7685 37.7551394419513 -122.483974450282 (37.7551394419513, -122.483974450282)
12073 109711 1 50 46 Wanda St 1 1 1 1 1 03/02/2015 12:00:00 AM 3 3x3 Permit Number 773351 6000527.40359 2091492.50948 37.7228696894556 -122.44029190466999 (37.7228696894556, -122.44029190467)
Powered by Datasette · Query took 2.824ms · Data source: data.sfgov.org