sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
80 225032 1 32 4425 18th St 1 1 1 1   03/02/2004 12:00:00 AM 11 Width 3ft Permit Number 47310 6001257.01437 2105216.66208 37.7605944983664 -122.43875275812799 (37.7605944983664, -122.438752758128)
87 11032 1 32 1500 Hyde St 1 1 1 1     70 3X3   6007492.86428 2117507.22815 37.794694232707 -122.41805706457599 (37.794694232707, -122.418057064576)
116 26163 1 32 220 Richardson Ave 6 1 1 1     12 3X3   5999083.87135 2119853.9919 37.8006609458028 -122.447322173097 (37.8006609458028, -122.447322173097)
143 18836 3 32 2055 Sacramento St 2 1 1 2     12 3X3   6004953.14987 2116100.2629400003 37.7906877916676 -122.426744576702 (37.7906877916676, -122.426744576702)
181 9914 3 32 1900 Gough St 1 1 1 2     126 3X3   6005235.69262 2116267.9294 37.7911641319684 -122.42577893234899 (37.7911641319684, -122.425778932349)
183 15429 3 32 2125 Mission St 1 1 1 2   04/09/2015 12:00:00 AM 15 4X4   6006871.98757 2105962.63928 37.762960616913205 -122.41938599878401 (37.7629606169132, -122.419385998784)
206 4750 1 32 1201 Columbus Ave 1 1 1 1     50 3X3   6007660.31382 2121409.3470799997 37.8054178953714 -122.417754386066 (37.8054178953714, -122.417754386066)
269 127441 3 32 2101 Van Ness Ave 4 1 1 2     15 Width 4ft   6005937.76794 2117668.55868 37.795049557533105 -122.423449386982 (37.7950495575331, -122.423449386982)
288 226558 3 32 320 Dolores St 3 1 1 2     22 Width 7ft   6004836.50691 2106380.98977 37.7639944545966 -122.42645581878 (37.7639944545966, -122.42645581878)
312 226557 1 32 320 Dolores St 2 1 1 1     16 Width 7ft   6004833.37225 2106401.74543 37.7640512674875 -122.42646813862 (37.7640512674875, -122.42646813862)
315 127442 3 32 2101 Van Ness Ave 5 1 1 2     19 Width 4ft   6005941.14617 2117647.79475 37.794992735681504 -122.423436220932 (37.7949927356815, -122.423436220932)
354 93479 2 32 113X Leroy Pl 4 1 1 1     9 1.5x3 Tree 4 on Leroy 6008317.250990001 2116630.80353 37.792334150853 -122.415142500331 (37.792334150853, -122.415142500331)
388 11057 3 32 1630 Hyde St 1 1 1 2     70 3X3   6007426.31744 2117960.00612 37.795933702633796 -122.418319444503 (37.7959337026338, -122.418319444503)
436 6932 3 32 500 Fell St 1 1 1 2     12 3X3   6004980.8762 2110598.20876 37.775582081585895 -122.42625675563801 (37.7755820815859, -122.426256755638)
448 224849 2 32 4 Rotteck St 1 1 1 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
461 98533 2 32 1805X Baker St 2 1 1 1     10 6x6 Permit Number 779899 5999986.39066 2115181.83206 37.787883958235504 -122.44386322941901 (37.7878839582355, -122.443863229419)
462 187628 2 32 2 Rotteck St 1 1 1 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
470 98535 2 32 1805X Baker St 4 1 1 1     12 6x6 Permit Number 779899 5999990.232999999 2115142.7171 37.7877767779168 -122.44384712433799 (37.7877767779168, -122.443847124338)
486 98534 2 32 1805X Baker St 3 1 1 1     10 3x3 Permit Number 779899 5999986.755609999 2115164.0145 37.787835056676705 -122.443860686142 (37.7878350566767, -122.443860686142)
538 224356 1 32 3122 16th St 1 1 1 1   08/27/1976 12:00:00 AM 20 Width 4ft Permit Number 16121 6005963.44888 2106707.74991 37.7649553019601 -122.422581275918 (37.7649553019601, -122.422581275918)
540 224369 1 32 3159 16th St 1 1 1 1   01/02/1981 12:00:00 AM 16 Width 3ft Permit Number 18874 6005753.01157 2106639.16646 37.7647551137777 -122.423304250809 (37.7647551137777, -122.423304250809)
542 224353 1 32 3024 16th St 1 1 1 1     21 Width 4ft   6006632.75905 2106740.0972599997 37.7650818572521 -122.42026859194901 (37.7650818572521, -122.420268591949)
544 224355 1 32 3120 16th St 1 1 1 1   08/27/1976 12:00:00 AM 23 Width 6ft Permit Number 16120 6005992.7506800005 2106707.14788 37.7649553019752 -122.42247988543501 (37.7649553019752, -122.422479885435)
559 224354 1 32 3030 16th St 1 1 1 1   08/27/1976 12:00:00 AM 21 Width 4ft Permit Number 16115 6006614.25148 2106740.2812200002 37.7650813194782 -122.420332618267 (37.7650813194782, -122.420332618267)
562 15241 3 32 1370 Mission St 1 1 1 2     18 3X3 Permit Number 49662 6008042.0 2110573.0 37.7756854149614 -122.415665767345 (37.7756854149614, -122.415665767345)
592 251331 2 32 2232 Webster St 2 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
599 251330 2 32 2232 Webster St 1 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
728 2813 1 32 1075 California St 4 1 1 1     20 2X2   6009225.04881 2116342.3210299998 37.7915930222591 -122.41198109107599 (37.7915930222591, -122.411981091076)
762 7350 3 32 2239 Fillmore St 1 1 1 2     12 3X3   6002792.88059 2116041.24067 37.790403357673895 -122.434214763813 (37.7904033576739, -122.434214763813)
901 224716 7 32 3255x 24th St 5 8 1 6     13 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
905 224715 7 32 3255x 24th St 4 8 1 6     12 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
910 7954 1 32 1756 Franklin St 1 1 1 1     14 3X3   6005736.45543 2116153.36588 37.7908778543671 -122.424038156058 (37.7908778543671, -122.424038156058)
916 224714 7 32 3255x 24th St 3 8 1 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
926 19204 3 32 630 Sansome St 2 1 1 2     12 3X3   6012243.07343 2117875.4725099998 37.7959715542054 -122.401646502996 (37.7959715542054, -122.401646502996)
928 224422 7 32 3255x 24th St 2 8 1 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
941 18512 3 32 626 Powell St 2 1 1 2     12 4X4   6010135.39241 2115955.1821 37.790581064620106 -122.408803973339 (37.7905810646201, -122.408803973339)
945 26844 3 32 100 Van Ness Ave 6 1 1 2     24 3X3 Permit Number 775213 6006969.72882 2110998.7322 37.7767940394414 -122.419405236481 (37.7767940394414, -122.419405236481)
1018 7366 3 32 2360 Fillmore St 3 1 1 2     18 3X3   6002774.54957 2116438.38146 37.79149276403471 -122.434306592692 (37.7914927640347, -122.434306592692)
1021 189660 3 32 2573 03rd St 2 1 1 2     18 Width 4ft   6015900.45488 2103484.96239 37.7566618134199 -122.38798645493601 (37.7566618134199, -122.387986454936)
1035 189666 3 32 2585 03rd St 4 1 1 2     20 Width 5ft   6015923.45326 2103178.08659 37.7558204715491 -122.38788550510598 (37.7558204715491, -122.387885505106)
1037 189668 3 32 2585 03rd St 7 1 1 2     19 Width 5ft   6015920.2977599995 2103253.32542 37.7560268866495 -122.387901667748 (37.7560268866495, -122.387901667748)
1044 189667 3 32 2585 03rd St 6 1 1 2     17 Width 5ft   6015923.778390001 2103213.67674 37.7559182125844 -122.38788686398199 (37.7559182125844, -122.387886863982)
1046 189659 3 32 2573 03rd St 4 1 1 2     18 Width 4ft   6015895.51865 2103530.26934 37.7567859432258 -122.388006687875 (37.7567859432258, -122.388006687875)
1055 21993 3 32 2585 03rd St 12 1 1 2     12 4x6   6015910.4355 2103353.3332599998 37.756300940646604 -122.387942753271 (37.7563009406466, -122.387942753271)
1057 189664 3 32 2585 03rd St 2 1 1 2     20 Width 5ft   6015924.43943 2103136.85911 37.755707324239395 -122.38787921795799 (37.7557073242394, -122.387879217958)
1062 189665 3 32 2585 03rd St 3 1 1 2     19 Width 5ft   6015925.0907 2103156.8300799998 37.755762196378996 -122.387878359099 (37.755762196379, -122.387878359099)
1074 11442 3 32 2200X Gough St 3 1 1 2     15 3X3   6005100.87554 2117226.15448 37.7937875569128 -122.42631364855801 (37.7937875569128, -122.426313648558)
1182 11089 3 32 1900 Hyde St 1 1 1 2   09/10/2007 12:00:00 AM 70 3X3   6007306.35542 2118856.39008 37.798388195314296 -122.418798140138 (37.7983881953143, -122.418798140138)
1217 113450 2 32 21X Leroy Pl 1 1 1 1     6 3x3   6008324.74095 2116562.6798400003 37.7921475208351 -122.415111760598 (37.7921475208351, -122.415111760598)
1306 127778 3 32 1459 Hyde St 1 1 1 2     19 Width 5ft   6007455.77406 2117413.73976 37.794435449198495 -122.418178770753 (37.7944354491985, -122.418178770753)
1381 189623 2 32 347 10th St 2 1 1 1     16 Width 3ft   6009091.0 2109329.0 37.7723285943803 -122.411949073152 (37.7723285943803, -122.411949073152)
1403 122808 1 32 1830 17th St 2 1 1 1   05/15/2017 12:00:00 AM 3 4x4   6011911.59203 2106562.15691 37.7648893115244 -122.401997787192 (37.7648893115244, -122.401997787192)
1435 226556 3 32 301 Dolores St 5 1 1 2     21 Width 6ft   6004916.06592 2106558.9555200003 37.7644876032441 -122.42619331838199 (37.7644876032441, -122.426193318382)
1441 226555 3 32 301 Dolores St 4 1 1 2     21 Width 6ft   6004913.144780001 2106531.61539 37.7644123686589 -122.42620147522699 (37.7644123686589, -122.426201475227)
1450 18855 1 32 2222 Sacramento St 4 1 1 1     13 3X3   6003966.78981 2116014.3774900003 37.790396155900105 -122.43015119962 (37.7903961559001, -122.43015119962)
1568 251592 3 32 1999X Hyde St 1 1 1 2 3     3x3   6007220.0 2119146.0 37.799178528828 -122.41911751038602 (37.799178528828, -122.419117510386)
1627 101897 2 32 1030 Leavenworth St 2 1 1 1     18 3x3 Permit Number 769674 6008181.44725 2116041.89613 37.7907095228698 -122.415570672075 (37.7907095228698, -122.415570672075)
1678 25510 1 32 1845 Gough St 2 1 1 1     18 3X3   6005220.005340001 2116049.4982 37.7905634882709 -122.42581765535401 (37.7905634882709, -122.425817655354)
1752 11021 3 32 1407 Hyde St 1 1 1 2     70 3x3   6007490.12051 2117192.20597 37.7938291055709 -122.41804421508002 (37.7938291055709, -122.41804421508)
1770 192158 2 32 13 South Van Ness Ave 1 1 1 1     20 Width 3ft Permit Number 779453 6007102.0 2110018.0 37.7741086326202 -122.418878096719 (37.7741086326202, -122.418878096719)
1771 192159 2 32 13 South Van Ness Ave 2 1 1 1     21 Width 3ft Permit Number 779453 6007133.19838 2109972.1913099997 37.7739846095361 -122.41876692647 (37.7739846095361, -122.41876692647)
1777 251693 1 32 98 11th St 4 1 1 1       3x3 Permit Number 779453 6007396.0 2110315.0 37.77494067377889 -122.417882154347 (37.7749406737789, -122.417882154347)
1783 251690 1 32 98 11th St 1 1 1 1       3x3 Permit Number 779453 6007396.0 2110315.0 37.77494067377889 -122.417882154347 (37.7749406737789, -122.417882154347)
1786 251694 1 32 98 11th St 5 1 1 1       3x3 Permit Number 779453 6007396.0 2110315.0 37.77494067377889 -122.417882154347 (37.7749406737789, -122.417882154347)
1787 11037 3 32 1523 Hyde St 1 1 1 2     70 3x3   6007436.11305 2117588.78298 37.794914967702496 -122.41825921689801 (37.7949149677025, -122.418259216898)
1802 123705 3 32 448 Balboa St 1 1 1 2   04/18/1996 12:00:00 AM 7 Width 3ft   5994163.86514 2111457.6280799997 37.7773244619044 -122.46373753196501 (37.7773244619044, -122.463737531965)
1825 224880 2 32 691 Chenery St 1 1 1 1   10/19/2016 12:00:00 AM 15 Width 3ft Permit Number 779045 6002530.35822 2095666.1320599997 37.734443349068606 -122.43366625920099 (37.7344433490686, -122.433666259201)
1903 127944 2 32 101 Vallejo St 2 1 1 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012622.90875 2119176.76577 37.7995657819845 -122.400423640834 (37.7995657819845, -122.400423640834)
1908 127945 2 32 101 Vallejo St 3 1 1 1   06/12/2017 12:00:00 AM 3 Width 2ft   6012656.99006 2119182.6904 37.7995839500992 -122.40030612282601 (37.7995839500992, -122.400306122826)
1911 127947 2 32 855 Front St 2 1 1 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012711.6665 2119148.4967900002 37.7994931113801 -122.400114518675 (37.7994931113801, -122.400114518675)
1913 127946 2 32 855 Front St 1 1 1 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012709.78092 2119164.70922 37.7995375216859 -122.400122182714 (37.7995375216859, -122.400122182714)
1924 127943 2 32 101 Vallejo St 1 1 1 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012601.19681 2119174.02118 37.7995570351977 -122.400498579547 (37.7995570351977, -122.400498579547)
1960 18692 1 32 220 Richardson Ave 7 1 1 1     12 3X3   5999079.26803 2119858.05546 37.800671840202796 -122.447338395052 (37.8006718402028, -122.447338395052)
2003 127110 6 32 3201 Laguna St 1 9 1 1     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812)
2013 225525 1 32 27 Walter St 1 1 1 1   06/01/1981 12:00:00 AM 25 Width 3ft Permit Number 19152 6003169.56249 2108141.44694 37.7687338691973 -122.432347023007 (37.7687338691973, -122.432347023007)
2043 127861 3 32 1898 Hyde St 2 1 1 2     19 Width 3ft   6007317.93078 2118761.71757 37.798128900073294 -122.418751368192 (37.7981289000733, -122.418751368192)
2047 127862 3 32 1898 Hyde St 3 1 1 2     14 Width 3ft   6007316.9194 2118776.88276 37.7981704829404 -122.41875594393 (37.7981704829404, -122.41875594393)
2060 127860 3 32 1898 Hyde St 1 1 1 2     19 Width 6ft   6007322.606430001 2118731.77235 37.798046941256 -122.418733064272 (37.798046941256, -122.418733064272)
2116 11044 1 32 1550 Hyde St 1 1 1 1     70 3x3   6007464.945230001 2117711.8455 37.795254489665 -122.418168182118 (37.795254489665, -122.418168182118)
2140 225336 1 32 3030 Castro St 1 1 1 1   12/03/1980 12:00:00 AM 15 Width 2ft Permit Number 18789 6002856.92306 2096000.60547 37.7353802609748 -122.43256110120899 (37.7353802609748, -122.432561101209)
2157 127892 1 32 623 Green St 1 1 1 1   10/12/2016 12:00:00 AM 20 Width 4ft Resulted descion 9/7/16 -DE 6010045.66816 2119169.32215 37.7994012851886 -122.40934133534999 (37.7994012851886, -122.40934133535)
2161 127894 1 32 623 Green St 4 1 1 1     18 Width 4ft   6010099.45524 2119176.61212 37.7994243150494 -122.40915572694999 (37.7994243150494, -122.40915572695)
2170 127072 2 32 3399X Steiner St 2 1 1 1     20 Width 4ft Permit Number 779572 6001832.0 2119600.0 37.800120199825 -122.437794333712 (37.800120199825, -122.437794333712)
2209 189798 3 32 1 Potrero Ave 2 1 1 2     17 Width 3ft   6010293.93626 2108038.50565 37.7688526102954 -122.407696978027 (37.7688526102954, -122.407696978027)
2364 192162 3 32 1500 Mission St 5 1 1 2     29 Width 5ft Permit Number 779453 6007414.0762 2109937.75552 37.7739058675964 -122.417792878858 (37.7739058675964, -122.417792878858)
2416 192163 3 32 1500 Mission St 6 1 1 2     29 Width 5ft Permit Number 779453 6007335.7591 2109863.52425 37.7736976385647 -122.41805852779 (37.7736976385647, -122.41805852779)
2426 192160 3 32 1500 Mission St 3 1 1 2     22 Width 3ft Permit Number 779453 6007491.12658 2110012.65001 37.774115845790796 -122.41753165726699 (37.7741158457908, -122.417531657267)
2442 192161 3 32 1500 Mission St 4 1 1 2     32 Width 5ft Permit Number 779453 6007448.619659999 2109968.2743599997 37.7739916089565 -122.417675550588 (37.7739916089565, -122.417675550588)
2449 192165 3 32 1500 Mission St 8 1 1 2   09/30/2008 12:00:00 AM 29 Width 4ft Permit Number 779453 6007288.76075 2109818.60353 37.7735716516336 -122.418217917334 (37.7735716516336, -122.418217917334)
2467 192164 3 32 1500 Mission St 7 1 1 2     28 Width 5ft Permit Number 779453 6007314.84465 2109842.28548 37.7736381448041 -122.418129368272 (37.7736381448041, -122.418129368272)
2469 48871 1 32 535 Pacific Ave 1 1 1 1   11/15/2002 12:00:00 AM 12 3x3 Permit Number 46080 6011476.385009999 2118326.9888400002 37.797168496982 -122.404331203243 (37.797168496982, -122.404331203243)
2472 224776 2 32 1600 Dolores St 1 1 1 1     24 Width 6ft   6005221.0 2098972.0 37.743672820465896 -122.42459890056001 (37.7436728204659, -122.42459890056)
2493 127969 2 32 73 Castle St 4 1 1 1     13 Width 1ft   6011253.45973 2119573.0614099996 37.8005774500495 -122.405190374142 (37.8005774500495, -122.405190374142)
2505 127968 2 32 73 Castle St 3 1 1 1     13 Width 1ft   6011251.91529 2119582.84216 37.8006042192626 -122.405196407682 (37.8006042192626, -122.405196407682)
2586 225598 1 32 236 Laussat St 1 1 1 1   04/24/1986 12:00:00 AM 16 Width 3ft Permit Number 22999 6003567.57753 2109171.0221700002 37.771583391799396 -122.431043812717 (37.7715833917994, -122.431043812717)
2646 18988 3 32 2939 Sacramento St 1 1 1 2     12 3X3   6000733.58986 2115514.6365 37.7888403449574 -122.44130195304301 (37.7888403449574, -122.441301953043)
2653 116000 1 32 1454 Jones St 4 1 1 1     11 3x3   6008456.02855 2117561.49656 37.7948974030383 -122.41472821952499 (37.7948974030383, -122.414728219525)
2659 253154 1 32 1454 Jones St 5 1 1 1       3x3   6008456.02855 2117561.49656 37.7948974030383 -122.41472821952499 (37.7948974030383, -122.414728219525)
2682 102785 1 32 3343 Buchanan St 1 1 1 1     3 5.5x6 Permit Number 772480 6003227.9831 2119876.64018 37.800959061171206 -122.43298347232599 (37.8009590611712, -122.432983472326)
2697 11019 3 32 1401 Hyde St 1 1 1 2     21 3x3   6007491.51177 2117162.78636 37.793748404921 -122.418037314589 (37.793748404921, -122.418037314589)
2750 23535 3 32 2750 Van Ness Ave 10 1 1 2     24 3x3   6005732.6393 2119914.78395 37.8012055419589 -122.424319001733 (37.8012055419589, -122.424319001733)
Powered by Datasette · Query took 2.417ms · Data source: data.sfgov.org