sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
113666 101255 3 524 3700X Cesar Chavez St 2 7 1 2           6005840.6 2100555.6 37.74805599841039 -122.422568977073 (37.7480559984104, -122.422568977073)
101656 23365 3 512 1356X Van Ness Ave 1 11 1 2     30 9   6006391.382589401 2115174.2493055 37.7882263975959 -122.42170255954201 (37.7882263975959, -122.421702559542)
113613 23368 3 512 1356X Van Ness Ave 4 11 1 2     24 9   6006391.382589401 2115174.2493055 37.7882263975959 -122.42170255954201 (37.7882263975959, -122.421702559542)
100332 21434 3 510 2692X Sunset Blvd 31 1 1 2     12 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
99928 13724 3 509 774X Market St 1 1 1 2     40 4x4   6011177.3442372 2114442.7932563997 37.786486710466704 -122.40509232379499 (37.7864867104667, -122.405092323795)
129280 13725 3 509 776 Market St 1 1 1 2     25 4X4   6011167.8494838 2114433.7120502 37.786461244836296 -122.40512453376499 (37.7864612448363, -122.405124533765)
121943 3925 3 508 99X Castro St 18 1 1 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361)
95817 23447 3 507 2100X Van Ness Ave 6 11 1 2     30 9   6006027.0678818 2117578.0674993 37.794806131309706 -122.42313396012399 (37.7948061313097, -122.423133960124)
94793 106979 3 506 801X Clipper St 1 14 1 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
92792 98222 3 503 1501X 42nd Ave 17 1 1 10 6   30 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
108295 23405 3 503 1700X Van Ness Ave 1 11 1 2     30 9   6006206.237645401 2116289.0241793 37.79127685023521 -122.422422371222 (37.7912768502352, -122.422422371222)
145968 98223 3 503 1501X 42nd Ave 18 1 1 10 6   30 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
85952 21318 3 491 2501X Sunset Blvd 18 1 1 2     36 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
88415 21317 3 491 2501X Sunset Blvd 17 1 1 2     12 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
122861 21319 3 491 2501X Sunset Blvd 19 1 1 2     24 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
85857 5426 3 490 460X Dolores St 4 1 1 2   03/15/1997 12:00:00 AM 12 3X3   6004889.2026724005 2105697.5669461996 37.7621209168257 -122.42622490044901 (37.7621209168257, -122.426224900449)
87219 5548 3 490 947 Dolores St 1 1 1 2   02/07/1997 12:00:00 AM 18 3X3   6005119.2884742 2102839.5530036 37.7542864846581 -122.42522574346201 (37.7542864846581, -122.425225743462)
124584 5534 3 490 900X Dolores St 3 1 1 2   03/15/1997 12:00:00 AM 4 3X6   6005027.1572891 2103111.0000553 37.7550266096242 -122.425563674214 (37.7550266096242, -122.425563674214)
84884 2783 3 486 424 Cabrillo St 1 1 1 2   10/04/2008 12:00:00 AM 12 3X3   5994280.27723 2110781.18915 37.7754738485256 -122.463285730589 (37.7754738485256, -122.463285730589)
104304 89575 3 486 4839 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983613.56659 2111700.17185 37.777376824173004 -122.50025179081699 (37.777376824173, -122.500251790817)
84661 8268 3 485 1525 GALVEZ AVE 2 1 1 2   03/28/2006 12:00:00 AM 3 3x3   6016246.0 2097351.0 37.739838361172204 -122.38636376878901 (37.7398383611722, -122.386363768789)
84396 90707 3 483 4332 Cabrillo St 3 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5982199.060847 2110334.3438979997 37.773543534511205 -122.505043702231 (37.7735435345112, -122.505043702231)
92270 90716 3 483 4530 Cabrillo St 2 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5981585.539599 2110312.077402 37.77344628141061 -122.507164273797 (37.7734462814106, -122.507164273797)
96444 90726 3 483 4799X Cabrillo St 3 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5980764.077178 2110242.237714 37.773206105836 -122.510000589277 (37.773206105836, -122.510000589277)
97676 90709 3 483 4400 Cabrillo St 2 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5981985.083822 2110326.5779669997 37.7735096198008 -122.505783291903 (37.7735096198008, -122.505783291903)
105740 90747 3 483 4331 Cabrillo St 1 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5982206.432655 2110294.58511 37.773434802186706 -122.505015255541 (37.7734348021867, -122.505015255541)
125345 90733 3 483 4525 Cabrillo St 1 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5981604.755434 2110272.748468 37.773339427416296 -122.50709488652001 (37.7733394274163, -122.50709488652)
141260 90748 3 483 4331 Cabrillo St 2 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5982206.432655 2110294.58511 37.773434802186706 -122.505015255541 (37.7734348021867, -122.505015255541)
144389 90741 3 483 4499X Cabrillo St 4 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5981694.399658999 2110276.0019259998 37.7733536396946 -122.50678504147801 (37.7733536396946, -122.506785041478)
103185 4735 3 479 1100X Columbus Ave 6 11 1 2   08/19/2006 12:00:00 AM 6 3x3   6008154.5819477 2121037.0963081 37.804423590750396 -122.41601752221001 (37.8044235907504, -122.41601752221)
82879 2302 3 475 800X Brotherhood Way 17 11 1 2     40 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
89822 2298 3 475 800X Brotherhood Way 13 11 1 2     45 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
89900 2261 3 475 700X Brotherhood Way 7 11 1 2     25 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
101138 2304 3 475 800X Brotherhood Way 19 11 1 2     45 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
105930 2267 3 475 750X Brotherhood Way 1 11 1 2     45 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
107007 2297 3 475 800X Brotherhood Way 12 11 1 2     50 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
112198 2265 3 475 700X Brotherhood Way 11 11 1 2     40 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
123388 2257 3 475 700X Brotherhood Way 3 11 1 2     45 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
126997 2258 3 475 700X Brotherhood Way 4 11 1 2     35 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
127206 2303 3 475 800X Brotherhood Way 18 11 1 2     45 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
139834 2259 3 475 700X Brotherhood Way 5 11 1 2     25 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
140483 2260 3 475 700X Brotherhood Way 6 11 1 2     25 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
111796 24818 3 467 400X Alemany Blvd 10 1 1 2   04/17/2015 12:00:00 AM 3 3x3   6007983.04766 2094988.0680200001 37.73288941859111 -122.41476648967699 (37.7328894185911, -122.414766489677)
105137 101918 3 463 114 Gold Mine Dr 1 1 1 2     4 3x3   6001282.9 2098757.3 37.742860112399796 -122.438200492302 (37.7428601123998, -122.438200492302)
78341 23810 3 462 1200X Webster St 2 1 1 2     18 3X3   6003795.894280001 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234)
79282 23870 3 462 1495X Webster St 3 1 1 2     12 3X3   6003590.023580001 2113875.44534 37.7845018426272 -122.43130203900499 (37.7845018426272, -122.431302039005)
79461 28107 3 462 1355X Webster St 9 1 1 2     12 3X3   6003646.0046556 2113350.9191197 37.783064797596296 -122.431070913528 (37.7830647975963, -122.431070913528)
81906 23815 3 462 1200X Webster St 7 1 1 2     24 4X4   6003795.894280001 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234)
91984 23817 3 462 1200X Webster St 9 1 1 2     25 3X3   6003795.894280001 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234)
95065 23869 3 462 1495X Webster St 2 1 1 2     12 3x3   6003590.023580001 2113875.44534 37.7845018426272 -122.43130203900499 (37.7845018426272, -122.431302039005)
95119 23816 3 462 1200X Webster St 8 1 1 2     25 3X3   6003795.894280001 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234)
102385 23872 3 462 1495X Webster St 5 1 1 2     12 3X3   6003590.023580001 2113875.44534 37.7845018426272 -122.43130203900499 (37.7845018426272, -122.431302039005)
103040 23839 3 462 1355X Webster St 3 1 1 2     12 3X3   6003646.0046556 2113350.9191197 37.783064797596296 -122.431070913528 (37.7830647975963, -122.431070913528)
107662 23873 3 462 1495X Webster St 6 1 1 2     6 3X3   6003590.023580001 2113875.44534 37.7845018426272 -122.43130203900499 (37.7845018426272, -122.431302039005)
121648 23809 3 462 1200X Webster St 1 1 1 2   06/02/1993 12:00:00 AM 40 3x3   6003795.894280001 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234)
144132 23830 3 462 1203X Webster St 1 1 1 2     30 3X3   6003742.20526 2112831.75991 37.781644766894296 -122.430701039692 (37.7816447668943, -122.430701039692)
78169 90468 3 460 600 25th Ave 3 1 1 2 8 03/17/2008 12:00:00 AM 3 3x3   5988164.289455 2111871.41207 37.778113054108296 -122.48452211150601 (37.7781130541083, -122.484522111506)
102220 90517 3 460 619 25th Ave 1 1 1 2 8 03/18/2008 12:00:00 AM 3 3x3   5988128.545308 2111752.691709 37.777784999781794 -122.48463705113701 (37.7777849997818, -122.484637051137)
112407 90502 3 460 401X 25th Ave 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5988073.547859 2113275.972392 37.7819642960053 -122.484939086563 (37.7819642960053, -122.484939086563)
113740 89640 3 460 3349X Anza St 1 1 1 2 8 03/21/2008 12:00:00 AM 3 3x3   5988302.001433 2111876.734088 37.7781356853217 -122.484046112267 (37.7781356853217, -122.484046112267)
139900 91017 3 460 457 25th Ave 1 1 1 2 8 11/17/2008 12:00:00 AM 3 3x3   5988087.568302 2112897.540762 37.7809260463619 -122.48486281200898 (37.7809260463619, -122.484862812009)
142392 90497 3 460 319 25th Ave 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5988052.709 2113836.722691 37.7835027435823 -122.485052332629 (37.7835027435823, -122.485052332629)
94895 89672 3 457 2627 Anza St 1 1 1 2   04/18/2008 12:00:00 AM 3 3x3   5990536.654767 2111956.813347 37.7784854072376 -122.476321569471 (37.7784854072376, -122.476321569471)
107743 89432 3 457 2732 Anza St 1 1 1 2   02/29/2008 12:00:00 AM 3 3x3   5990207.269944999 2111985.0354509996 37.7785437899427 -122.47746308716499 (37.7785437899427, -122.477463087165)
79884 24198 3 455 55X Whitney Young Cir 14 1 1 2   03/29/1990 12:00:00 AM 12 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
138953 63523 3 455 929 VALENCIA ST 1 1 1 2   09/12/2015 03:22:00 PM 3 3x3 Permit Number 24134 6006356.3 2104163.0 37.757990169538495 -122.42104180117902 (37.7579901695385, -122.421041801179)
142404 24196 3 455 55X Whitney Young Cir 12 1 1 2   02/04/1998 12:00:00 AM 6 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
146199 17226 3 455 1884X Alemany Blvd 3 1 1 2     15 3X3   6001017.031830001 2091170.8979900002 37.722014482536295 -122.438576333542 (37.7220144825363, -122.438576333542)
157453 18552 3 453 1700X Quesada Ave 7 11 1 2     7 19   6014642.29362 2095077.14438 37.7335059182554 -122.39174980833201 (37.7335059182554, -122.391749808332)
119388 23234 3 452 700X Van Ness Ave 4 11 1 2     30 9   6006679.199292599 2112885.0865653 37.7819571437982 -122.42054420111201 (37.7819571437982, -122.420544201112)
72584 93335 3 449 2100X Turk Blvd 18 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
80365 93349 3 449 2100X Turk Blvd 32 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
81223 93326 3 449 2100X Turk Blvd 9 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
81783 93331 3 449 2100X Turk Blvd 14 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
82808 93337 3 449 2100X Turk Blvd 20 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
85080 93334 3 449 2100X Turk Blvd 17 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
89071 93323 3 449 2100X Turk Blvd 6 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
90198 93336 3 449 2100X Turk Blvd 19 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
90887 93327 3 449 2100X Turk Blvd 10 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
91847 93380 3 449 3098X Turk Blvd 1 1 1 2   12/08/2008 12:00:00 AM 3 3x3   5996221.5 2111515.5 37.77760171599729 -122.456623735227 (37.7776017159973, -122.456623735227)
93046 93345 3 449 2100X Turk Blvd 28 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
95185 93343 3 449 2100X Turk Blvd 26 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
95590 93318 3 449 2100X Turk Blvd 1 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
98985 93333 3 449 2100X Turk Blvd 16 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
99665 93341 3 449 2100X Turk Blvd 24 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
99880 93381 3 449 3098X Turk Blvd 2 1 1 2   12/08/2008 12:00:00 AM 3 3x3   5996221.5 2111515.5 37.77760171599729 -122.456623735227 (37.7776017159973, -122.456623735227)
99962 93342 3 449 2100X Turk Blvd 25 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
100761 93328 3 449 2100X Turk Blvd 11 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
102390 93321 3 449 2100X Turk Blvd 4 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
103828 93347 3 449 2100X Turk Blvd 30 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
106678 93339 3 449 2100X Turk Blvd 22 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
106982 93348 3 449 2100X Turk Blvd 31 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
108173 93346 3 449 2100X Turk Blvd 29 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
108843 93344 3 449 2100X Turk Blvd 27 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
110827 93330 3 449 2100X Turk Blvd 13 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
111165 93319 3 449 2100X Turk Blvd 2 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
111286 93324 3 449 2100X Turk Blvd 7 1 1 2   11/20/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
112227 93354 3 449 2100X Turk Blvd 37 1 1 2   11/21/2008 12:00:00 AM 3 3x3   5999954.2 2112061.6 37.779314771487996 -122.44375035157302 (37.779314771488, -122.443750351573)
Powered by Datasette · Query took 58.826ms · Data source: data.sfgov.org