sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
60876 226631 2 27 141 Moffitt St 1 1 1 1     5 Width 4ft   6002644.82708 2096800.8937799998 37.737565638743895 -122.43335156393299 (37.7375656387439, -122.433351563933)
60961 43315 1 27 259 Athens St 1 1 1 1 1 07/13/2000 12:00:00 AM 4   Permit Number 43078 6004448.9414 2091752.36291 37.72380568677679 -122.426754460261 (37.7238056867768, -122.426754460261)
61063 207293 2 27 965 Darien Way 1 1 1 1     7 Width 3ft   5994659.04342 2093888.37752 37.729112296585996 -122.460750997386 (37.729112296586, -122.460750997386)
61495 41940 1 27 642 05th Ave 2 1 1 1 1 05/09/2011 12:00:00 AM 3 3x3 Permit Number 767709 5994437.32362 2111135.33206 37.7764552768418 -122.46276817075301 (37.7764552768418, -122.462768170753)
61927 184535 2 27 1914 47th Ave 1 1 1 1     1 Width 0ft   5981673.4595 2102023.0319999997 37.7506921190217 -122.506245385817 (37.7506921190217, -122.506245385817)
61977 226613 2 27 322 Elsie St 1 1 1 1     5 Width 3ft   6006488.43942 2097246.62658 37.7390068293023 -122.42009397237601 (37.7390068293023, -122.420093972376)
62171 207300 2 27 145 Hazelwood Ave 1 1 1 1     7 Width 3ft   5996448.99813 2094535.9636799998 37.730993237639105 -122.45460977981199 (37.7309932376391, -122.454609779812)
62306 52667 1 27 226@ MARIPOSA Mississippi St 1 1 1 1   03/29/2006 12:00:00 AM 4   Permit Number 48748 6013989.6640800005 2106012.3733900003 37.7634954891429 -122.39477170574301 (37.7634954891429, -122.394771705743)
62397 207195 2 27 574 Hearst Ave 3 1 1 1     5 Width 2ft   5997610.81771 2094416.06797 37.7307306014402 -122.450584552831 (37.7307306014402, -122.450584552831)
62502 46769 1 27 54 Cotter St 1 1 1 1 1 04/25/2002 12:00:00 AM 6   Permit Number 44865 6002394.404709999 2093228.74941 37.7277431363295 -122.43396212714599 (37.7277431363295, -122.433962127146)
62758 207140 2 27 1682 17th Ave 1 1 1 1     1 Width 3ft   5990920.30999 2103955.3917900003 37.7565379030086 -122.474410316087 (37.7565379030086, -122.474410316087)
62912 177003 2 27 746 Olmstead St 4 1 1 1     3 Width 2ft   6009476.70201 2090586.0760400002 37.720886288652004 -122.409291987754 (37.720886288652, -122.409291987754)
63341 207360 2 27 374 Judson Ave 1 1 1 1     9 Width 2ft   5997612.78816 2093589.9194 37.7284623061695 -122.450518204475 (37.7284623061695, -122.450518204475)
63394 119482 2 27 426 33rd Ave 4 1 1 1     6 Width 3ft   5985642.69106 2113025.08426 37.781133543390204 -122.49333012331499 (37.7811335433902, -122.493330123315)
63672 226582 2 27 383 Elsie St 1 1 1 1     5 Width 3ft   6006413.772530001 2097021.64328 37.738384868057295 -122.420336172385 (37.7383848680573, -122.420336172385)
65074 67318 1 27 666 08th Ave 1 1 1 1 1 07/15/1992 12:00:00 AM 9   Permit Number 30800 5993501.91813 2110961.7349 37.7759247065994 -122.46599136010799 (37.7759247065994, -122.465991360108)
66099 185262 2 27 2167 Vicente St 2 1 1 1     5 Width 0ft   5986237.8922 2097517.551 37.738588933455404 -122.490130038774 (37.7385889334554, -122.490130038774)
67505 50406 1 27 1361 46th Ave 1 1 1 1 1 10/06/2003 12:00:00 AM 4   Permit Number 47058 5981810.1658 2105846.3225 37.761197837443596 -122.50605609679701 (37.7611978374436, -122.506056096797)
67611 43211 1 27 353 Sweeny St 1 1 1 1 1 07/11/2000 12:00:00 AM 5   Permit Number 43002 6008758.60086 2094527.34935 37.73166792973 -122.412052645639 (37.73166792973, -122.412052645639)
67812 207165 2 27 501 Laguna Honda Blvd 1 1 1 1     3 Width 3ft   5995466.11989 2100230.17484 37.746571717707205 -122.458419748693 (37.7465717177072, -122.458419748693)
67877 207215 2 27 351 Judson Ave 17 1 1 1     6 Width 1ft   5997615.0933300005 2093521.35715 37.7282741823893 -122.450505294682 (37.7282741823893, -122.450505294682)
67927 41944 1 27 567 07th Ave 1 1 1 1 1 06/20/2000 12:00:00 AM 7   Permit Number 42302 5993743.34162 2111650.50193 37.7778298007164 -122.465206260397 (37.7778298007164, -122.465206260397)
67977 117858 2 27 600 39th Ave 1 1 1 1     6 Width 3ft   5983830.55841 2111665.32715 37.777293884605704 -122.499498581311 (37.7772938846057, -122.499498581311)
68943 207150 2 27 830 Ortega St 2 1 1 1     5 Width 1ft   5991404.13851 2102515.6148 37.752612672541105 -122.47263211090099 (37.7526126725411, -122.472632110901)
68986 185609 2 27 2261 Quintara St 2 1 1 1     3 Width 0ft   5986412.841 2100929.3732 37.747967099583 -122.489776004492 (37.747967099583, -122.489776004492)
69001 176998 2 27 87 Seneca Ave 2 1 1 1     3 Width 1ft   6000227.51825 2089886.7347900001 37.7184435186304 -122.441213386902 (37.7184435186304, -122.441213386902)
69145 207269 2 27 1477 06th Ave 2 1 1 1     5 Width 3ft   5994263.394830001 2105452.9722599997 37.760842992730105 -122.462957472303 (37.7608429927301, -122.462957472303)
70286 42982 1 27 469 Princeton St 1 1 1 1 1 07/05/2000 12:00:00 AM 7   Permit Number 42866 6008125.46012 2091747.89633 37.724000603132 -122.414044988394 (37.724000603132, -122.414044988394)
70323 207350 2 27 618 Mangels Ave 3 1 1 1     4 Width 3ft   5997300.95019 2095282.96772 37.7330931600175 -122.451718319154 (37.7330931600175, -122.451718319154)
70570 207314 2 27 1570 07th Ave 4 1 1 1     5 Width 3ft   5994021.19813 2104903.51705 37.759320377550395 -122.46375523571999 (37.7593203775504, -122.46375523572)
70729 177010 2 27 78 Lamartine St 1 1 1 1     6 Width 3ft   6002632.11132 2094355.1655700002 37.73084950708879 -122.433220824095 (37.7308495070888, -122.433220824095)
71287 207201 2 27 351 Flood Ave 1 1 1 1     7 Width 2ft   5998416.44412 2094074.8160299999 37.7298396835571 -122.447774830644 (37.7298396835571, -122.447774830644)
71533 117965 2 27 4545 Anza St 6 1 1 1     5 Width 3ft   5984581.6879 2111733.75019 37.7775257966351 -122.496905272636 (37.7775257966351, -122.496905272636)
72391 176996 2 27 763 Morse St 16 1 1 1     6 Width 3ft   5998705.41323 2087176.369 37.7109146507487 -122.44627978598999 (37.7109146507487, -122.44627978599)
73614 40348 1 27 501 38th Ave 1 1 1 1 1 05/17/1999 12:00:00 AM 6   Permit Number 41478 5984070.03891 2112340.8801599997 37.779162805435 -122.498720071631 (37.779162805435, -122.498720071631)
73666 184518 2 27 4108 Pacheco St 1 1 1 1     1 Width 0ft   5982209.6889 2101522.5062 37.7493493689338 -122.504354014902 (37.7493493689338, -122.504354014902)
73802 207144 2 27 1617 16th Ave 2 1 1 1     1 Width 2ft   5991126.06401 2104353.71257 37.757643505256205 -122.473727808906 (37.7576435052562, -122.473727808906)
73988 207312 2 27 101 Ridgewood Ave 1 1 1 1     7 Width 3ft   5996777.2193 2094487.3918299999 37.730878690977704 -122.45347156457399 (37.7308786909777, -122.453471564574)
74258 207354 2 27 236 Ridgewood Ave 1 1 1 1     5 Width 2ft   5996818.09015 2094943.97322 37.732134696764 -122.453363219655 (37.732134696764, -122.453363219655)
74277 67405 1 27 774 20th Ave 1 1 1 1 1 07/30/1992 12:00:00 AM 9   Permit Number 30904 5989782.793 2110097.20217 37.7733356814764 -122.478793391379 (37.7733356814764, -122.478793391379)
74830 207158 2 27 237 Wawona St 1 1 1 1     7 Width 3ft   5992472.8250400005 2097675.82148 37.739385640835295 -122.468584327098 (37.7393856408353, -122.468584327098)
75032 207204 2 27 655 Joost Ave 1 1 1 1     5 Width 1ft   5997746.28105 2094978.11771 37.7322816091084 -122.450156733641 (37.7322816091084, -122.450156733641)
75227 185264 2 27 2147 Vicente St 4 1 1 1     5 Width 0ft   5986264.4244 2097520.2042 37.7385977678327 -122.490038499473 (37.7385977678327, -122.490038499473)
75859 207224 2 27 49 Edna St 1 1 1 1     5 Width 1ft   5998734.87043 2093158.9272 37.727343062112396 -122.446608128468 (37.7273430621124, -122.446608128468)
75893 70393 2 27 63 Madison St 1 1 1 1 1 05/21/1994 12:00:00 AM 6     6005472.78201 2093254.0606099998 37.7279868534853 -122.42332190988998 (37.7279868534853, -122.42332190989)
76051 207298 2 27 111 Valdez Ave 1 1 1 1     6 Width 3ft   5996286.51947 2094316.70178 37.73038187671379 -122.45515565391099 (37.7303818767138, -122.455155653911)
76063 43217 1 27 45 Princeton St 1 1 1 1 1 07/11/2000 12:00:00 AM 4   Permit Number 43007 6007564.041619999 2093733.91416 37.7294222326375 -122.416126315492 (37.7294222326375, -122.416126315492)
76065 207186 2 27 50 Hearst Ave 1 1 1 1     7 Width 2ft   6000874.80167 2094365.21675 37.730777259156 -122.43929683358299 (37.730777259156, -122.439296833583)
76937 42890 1 27 2249 Ulloa St 3 1 1 1 1 07/03/2000 12:00:00 AM 3   Permit Number 42809 5988984.6022 2098295.481 37.7408849467502 -122.48069027409402 (37.7408849467502, -122.480690274094)
77335 207193 2 27 312 Hearst Ave 4 1 1 1     9 Width 2ft   5999342.629819999 2094390.1530400002 37.7307584183688 -122.444595567153 (37.7307584183688, -122.444595567153)
79917 1384 3 27 2550X Diamond St 2 1 1 2     20 3X2   6002245.07965 2096962.3294799998 37.737986217166096 -122.43474521929 (37.7379862171661, -122.43474521929)
89568 87364 1 27 3401 Taraval St 5 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
91369 177012 2 27 78 Lamartine St 3 1 1 1     6 Width 3ft   6002642.0398 2094328.25695 37.730776185352504 -122.433184577831 (37.7307761853525, -122.433184577831)
94485 87363 1 27 3401 Taraval St 4 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
100854 19333 3 27 325 Shields St 1 1 1 2     6 3X3   5993178.445205901 2089816.9668961002 37.7178478960527 -122.46557383978 (37.7178478960527, -122.46557383978)
102241 121608 2 27 99X Lamartine St 3 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
102463 87366 1 27 3401 Taraval St 7 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
103991 100461 2 27 236 Wawona St 1 1 1 1           5992450.0 2097712.0 37.7394836593705 -122.468665877071 (37.7394836593705, -122.468665877071)
108882 90815 3 27 3145 Cabrillo St 1 1 1 2   04/07/2008 12:00:00 AM 3 3x3   5985771.299330001 2110409.9607700002 37.7739606832472 -122.49269254584101 (37.7739606832472, -122.492692545841)
109500 116713 2 27 1400 Baker St 5 1 1 1     4 3x3   6000212.5605 2113848.1665 37.78423495653821 -122.44298491286699 (37.7842349565382, -122.442984912867)
112212 207333 2 27 378 Mangels Ave 1 1 1 1     4 Width 2ft   5998914.45517 2095254.7812700002 37.7331080419878 -122.446137997991 (37.7331080419878, -122.446137997991)
116109 115788 1 27 3628 16th St 2 1 1 1 1 03/09/2016 12:00:00 AM 3   Permit Number 777599 6002731.19846 2106518.35077 37.764252377203 -122.433747267607 (37.764252377203, -122.433747267607)
117257 108497 1 27 1339 12th Ave 1 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773641 5992378.78756 2106335.85187 37.7631584124216 -122.46953970622101 (37.7631584124216, -122.469539706221)
117656 117966 2 27 4545 Anza St 5 1 1 1     4 Width 3ft   5984567.33243 2111733.70358 37.7775248274666 -122.496954928801 (37.7775248274666, -122.496954928801)
117773 121606 2 27 99X Lamartine St 1 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
123823 207323 2 27 734 Teresita Blvd 2 1 1 1     4 Width 3ft   5998893.471580001 2095962.39727 37.7350497898071 -122.446261428139 (37.7350497898071, -122.446261428139)
123975 57938 1 27 7 Byron Ct 1 1 1 1   08/18/2010 12:00:00 AM 4   Permit Number 53686 5999410.13624 2086691.6630000002 37.7096239797406 -122.443809305177 (37.7096239797406, -122.443809305177)
125304 177013 2 27 78 Lamartine St 4 1 1 1     6 Width 3ft   6002644.59595 2094315.3545 37.7307409031583 -122.433174819278 (37.7307409031583, -122.433174819278)
129828 226614 2 27 322 Elsie St 9 1 1 1     6 Width 3ft   6006361.987980001 2097015.1421299998 37.738364099132795 -122.42051475707399 (37.7383640991328, -122.420514757074)
130406 207187 2 27 50 Hearst Ave 2 1 1 1     7 Width 2ft   6000857.41139 2094366.50638 37.730779810542295 -122.439357046798 (37.7307798105423, -122.439357046798)
130433 207283 2 27 84 Manor Dr 3 1 1 1     4 Width 3ft   5993642.59329 2093470.80397 37.7279072068291 -122.464234616632 (37.7279072068291, -122.464234616632)
130678 116712 2 27 1400 Baker St 4 1 1 1     5 3x3   6000214.6483 2113835.6397 37.784200680215605 -122.44297678993999 (37.7842006802156, -122.44297678994)
130898 207284 2 27 84 Manor Dr 2 1 1 1     4 Width 3ft   5993637.22552 2093458.84875 37.727874071330106 -122.464252305417 (37.7278740713301, -122.464252305417)
130905 108372 1 27 575 Paris St 2 1 1 1 1   1 3x3   6001633.30512 2090300.73335 37.7196602437916 -122.436383787393 (37.7196602437916, -122.436383787393)
131253 185261 2 27 2177 Vicente St 1 1 1 1     4 Width 0ft   5986220.9115 2097517.551 37.7385879417998 -122.49018874910401 (37.7385879417998, -122.490188749104)
131369 207156 2 27 2426 16th Ave 1 1 1 1     2 Width 3ft   5991402.6198 2098893.19012 37.7426663442825 -122.472373311184 (37.7426663442825, -122.472373311184)
131611 207292 2 27 965 Darien Way 2 1 1 1     6 Width 3ft   5994659.45419 2093917.36528 37.729191913559205 -122.460751677241 (37.7291919135592, -122.460751677241)
131833 207161 2 27 509 Miramar Ave 1 1 1 1     4 Width 2ft   5995344.03835 2092755.21065 37.726040281721296 -122.45830094463498 (37.7260402817213, -122.458300944635)
131950 71605 2 27 178 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5994512.31694 2086511.3564 37.7088483153534 -122.46072384594 (37.7088483153534, -122.46072384594)
132193 207162 2 27 509 Miramar Ave 2 1 1 1     5 Width 2ft   5995343.73993 2092740.9516 37.7260011126479 -122.45830094463699 (37.7260011126479, -122.458300944637)
133243 226583 2 27 65 Gladys St 1 1 1 1     5 Width 2ft   6005675.46056 2097328.12115 37.7391847556639 -122.422910674207 (37.7391847556639, -122.422910674207)
133267 99298 1 27 50 Norton St 1 1 1 1   05/01/2012 12:00:00 AM 4 3x3 Permit Number 768888 6001844.0532599995 2092273.6485400002 37.7250893979513 -122.435796391592 (37.7250893979513, -122.435796391592)
133337 177023 2 27 1628 Burrows St 2 1 1 1     3 Width 3ft   6006643.54009 2092125.7831400002 37.7249548539585 -122.419194556805 (37.7249548539585, -122.419194556805)
133371 207206 2 27 249 Gennessee St 1 1 1 1     7 Width 1ft   5997427.94217 2094345.17262 37.730525470566896 -122.451211668094 (37.7305254705669, -122.451211668094)
133706 207160 2 27 384 Santa Ana Ave 1 1 1 1     5 Width 3ft   5992464.42361 2094258.2447 37.7300013456858 -122.46836480621799 (37.7300013456858, -122.468364806218)
133915 226620 2 27 688 Capp St 1 1 1 1     5 Width 3ft   6007284.68348 2103336.34747 37.7557726618001 -122.417772455244 (37.7557726618001, -122.417772455244)
133963 184221 2 27 3435 Kirkham St 5 1 1 1     4 Width 0ft   5984145.6537 2104934.9816 37.7588327531435 -122.49791146613899 (37.7588327531435, -122.497911466139)
134174 71938 2 27 384 Vallejo St 1 1 1 1 1 10/21/1995 12:00:00 AM 4     6011634.93944 2119088.82833 37.7992691828709 -122.403836198406 (37.7992691828709, -122.403836198406)
134189 226586 2 27 195 Lexington St 1 1 1 1     1 Width 3ft   6006490.36158 2105010.39 37.760324461620705 -122.420638312212 (37.7603244616207, -122.420638312212)
135470 207277 2 27 236 Wawona St 1 1 1 1     7 Width 3ft   5992402.86272 2097663.9953099997 37.7393491274725 -122.46882536342 (37.7393491274725, -122.46882536342)
136966 207147 2 27 1341 12th Ave 1 1 1 1     1 Width 2ft   5992375.35662 2106303.37048 37.7630690288235 -122.469549207953 (37.7630690288235, -122.469549207953)
137148 177027 2 27 127 Naples St 1 1 1 1     6 Width 4ft   6004458.22384 2092761.54245 37.726577195866206 -122.426794207588 (37.7265771958662, -122.426794207588)
137162 207228 2 27 1018 Capitol Ave 1 1 1 1     6 Width 2ft   5995061.38916 2090705.2918200002 37.720395449464796 -122.459129669002 (37.7203954494648, -122.459129669002)
137313 207334 2 27 27 Melrose Ave 1 1 1 1     5 Width 2ft   5999906.0481 2095478.3381 37.7337784541927 -122.44272585413799 (37.7337784541927, -122.442725854138)
137436 177005 2 27 362 Arleta Ave 1 1 1 1     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669)
137737 207316 2 27 540 Vicente St 1 1 1 1     4 Width 3ft   5991234.77071 2097748.67502 37.739514082899795 -122.47287024148899 (37.7395140828998, -122.472870241489)
138958 87365 1 27 3401 Taraval St 6 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
140890 121607 2 27 99X Lamartine St 2 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
145138 24745 3 27 128X Point Lobos Ave 2 1 1 2   02/02/1996 12:00:00 AM 3 3x3   5982364.706809999 2112649.87562 37.779911051225206 -122.50464231484501 (37.7799110512252, -122.504642314845)
148538 42630 1 27 2634 Octavia St 1 1 1 1 1 06/26/2000 12:00:00 AM 6   Permit Number 42686 6004473.47116 2118249.9245 37.7965630841803 -122.428557534402 (37.7965630841803, -122.428557534402)
148774 68284 1 27 665 Bowdoin St 1 1 1 1 1 06/14/2012 12:00:00 AM 2   Permit Number 769020 6009000.66847 2092983.8736400001 37.727443453448 -122.411106781849 (37.727443453448, -122.411106781849)
Powered by Datasette · Query took 7.405ms · Data source: data.sfgov.org