sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
198 103786 3 21 1221 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006804.9894 2115120.2532 37.7881014522033 -122.420267712778 (37.7881014522033, -122.420267712778)
1781 214663 2 17 427 Kirkham St 1 10 1 1   06/01/2017 12:00:00 AM 3 Width 4ft Permit Number 779947 5993526.84887 2105257.2946900004 37.7602632600539 -122.46549062240601 (37.7602632600539, -122.465490622406)
2811 115532 4 106 100X Hayes St 2 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.777545665835596 -122.41830427922501 (37.7775456658356, -122.418304279225)
4327 103839 3 22 1552 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006685.2576 2116316.1212 37.791378262309706 -122.420766896 (37.7913782623097, -122.420766896)
4390 175420 2 82 211 Edinburgh St 1 10 1 1     5 Width 3ft   6003926.56795 2092414.35505 37.7255938222743 -122.428607384746 (37.7255938222743, -122.428607384746)
4580 142832 3 142 1553 POLK ST 1 10 1 2   11/01/2009 12:00:00 AM 9 Width 0ft   6006643.2439 2116275.8765 37.791265392276 -122.420909404242 (37.791265392276, -122.420909404242)
4604 142833 3 142 1549 POLK ST 1 10 1 2   11/01/2009 12:00:00 AM 9 Width 0ft   6006645.4552 2116252.8795 37.7912023728705 -122.42090011974501 (37.7912023728705, -122.420900119745)
4899 109487 2 88 1314 POLK ST 2 10 1 2   10/31/2017 02:27:00 PM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515)
5221 72132 2 17 950 Wisconsin St 1 10 1 1 1 12/01/2011 12:00:00 AM 3 3x3 Permit Number 780813 6012748.1522699995 2103075.8524599997 37.755363341648795 -122.398859619973 (37.7553633416488, -122.398859619973)
6140 115534 4 106 100X Hayes St 4 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.777528483399294 -122.418420222514 (37.7775284833993, -122.418420222514)
6196 103853 3 142 1507 Polk St 2 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006668.0099 2116095.4388 37.790771351094605 -122.420810898748 (37.7907713510946, -122.420810898748)
6300 103795 1 21 1215 Polk St 1 10 1 1   11/01/2009 12:00:00 AM 3 3x3   6006811.4062 2115079.7468 37.78799059318229 -122.42024263571899 (37.7879905931823, -122.420242635719)
6989 115533 4 106 100X Hayes St 3 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452)
7553 142835 2 21 1515 POLK ST 1 10 1 1       Width 0ft   6006663.5874 2116129.9342 37.7908658176323 -122.42082865045799 (37.7908658176323, -122.420828650458)
8241 115531 4 106 100X Hayes St 1 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.7374599995 2111269.98589 37.777558150214404 -122.41823790028 (37.7775581502144, -122.41823790028)
8494 115535 4 106 100X Hayes St 5 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.777528148837796 -122.41849726655899 (37.7775281488378, -122.418497266559)
8870 103858 3 142 1475 Polk St 2 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006691.391 2115929.0779 37.790315883136 -122.42071818597401 (37.790315883136, -122.420718185974)
8938 103857 3 142 1475 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006690.1878 2115953.9432 37.7903840892726 -122.42072411493 (37.7903840892726, -122.42072411493)
16896 100001 2 32 501X 01st St 2 10 1 1         Address is 100 1st Street          
18492 63236 1 31 3634 20th St 1 10 1 1 1 01/13/1987 12:00:00 AM 12   Permit Number 23784 6006063.67565171 2104362.69748074 37.7585219924343 -122.422068008351 (37.7585219924343, -122.422068008351)
22812 224471 2 201 627 Precita Ave 1 10 1 1     11 Width 3ft   6009784.7997 2100421.88863 37.7479105825135 -122.408920592022 (37.7479105825135, -122.408920592022)
22852 138173 2 54 1953 GOLDEN GATE AVE 1 10 1 1     0 Width 0ft   6000211.2401 2111613.6154 37.7780993776744 -122.44282896766 (37.7780993776744, -122.44282896766)
22874 179489 2 25 36 Goettingen St 1 10 1 1     3 Width 3ft   6009813.802999999 2094277.0712700002 37.7310398674871 -122.40838693792801 (37.7310398674871, -122.408386937928)
22907 233756 2 41 138 Alpine Ter 1 10 1 1     1 Width 3ft   6001688.04868 2107994.1327400003 37.768245263926396 -122.43746090722 (37.7682452639264, -122.43746090722)
22940 103859 3 88 1475 Polk St 3 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
22953 103852 3 88 1507 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006614.6 2116113.6 37.7908182067111 -122.420996984718 (37.7908182067111, -122.420996984718)
22956 103844 3 90 1541 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.791101384779296 -122.420931274285 (37.7911013847793, -122.420931274285)
22958 103860 3 88 1475 Polk St 4 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
22965 103768 3 88 1323 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006757.0 2115467.0 37.7890508291132 -122.42045837028401 (37.7890508291132, -122.420458370284)
22970 103849 3 90 1524 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
22978 103850 3 90 1524 Polk St 3 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042)
23385 225339 2 32 3033 Castro St 1 10 1 1     15 Width 3ft   6002890.27268 2096019.3333400001 37.73543357459229 -122.43244713645001 (37.7354335745923, -122.43244713645)
23569 211718 2 26 431 Arch St 2 10 1 1     13 Width 4ft   5992705.448530001 2090061.4664900003 37.7184919399203 -122.46722653339701 (37.7184919399203, -122.467226533397)
23670 129807 2 85 901 Sacramento St 6 10 1 1     11 Width 3ft   6010390.20829 2116866.53247 37.793097682469394 -122.407986617304 (37.7930976824694, -122.407986617304)
23685 131311 2 2 3701 Jackson St 1 10 1 1     9 Width 3ft   5996479.01622 2115904.55519 37.7896676762649 -122.45605029860201 (37.7896676762649, -122.456050298602)
23717 190342 2 32 101 Howard St 8 10 1 1     4 Width 3ft   6014826.26604 2116061.6193 37.7911349426626 -122.39258114252199 (37.7911349426626, -122.392581142522)
23754 194580 2 110 598 Missouri St 1 10 1 1     3 Width 4ft   6013513.20546 2104325.65158 37.758837617875294 -122.39630140851001 (37.7588376178753, -122.39630140851)
23806 232314 2 1 99 Elsie St 2 10 1 1     5     6007320.806890001 2098778.15204 37.7432589210582 -122.417324523624 (37.7432589210582, -122.417324523624)
23836 204823 2 12 1331 09th Ave 1 10 1 1     2 Width 4ft   5993302.77838 2106404.87542 37.7634012905668 -122.466348974927 (37.7634012905668, -122.466348974927)
23903 128508 2 32 415 Montgomery St 2 10 1 1     3 Width 3ft   6011852.868919999 2116847.94752 37.7931284347821 -122.40292438836 (37.7931284347821, -122.40292438836)
24173 190232 2 32 536 Mission St 3 10 1 1     7 Width 4ft   6013096.96075 2115369.31377 37.7891378442858 -122.398515922465 (37.7891378442858, -122.398515922465)
24220 188507 2 339 1525 18th St 3 10 1 1     1 Width 2ft   6013039.99307 2105636.60333 37.7624108600086 -122.398029973803 (37.7624108600086, -122.398029973803)
24538 232518 2 2 4518 25th St 1 10 1 1     11 Width 3ft   6000862.85333 2101145.4432599996 37.749393486316706 -122.43982407823401 (37.7493934863167, -122.439824078234)
24563 128713 2 32 555 Jackson St 1 10 1 1     4 Width 4ft   6011289.01038 2117973.50016 37.7961874301503 -122.404954668136 (37.7961874301503, -122.404954668136)
24580 130549 2 21 341 Maple St 2 10 1 1     10 Width 2ft   5996655.62034 2115093.6524799997 37.7874512898863 -122.455380640001 (37.7874512898863, -122.455380640001)
24601 138420 2 59 1819 STEINER ST 3 10 1 1     14 Width 0ft   6002521.5979 2114452.899 37.786026776312596 -122.435039736101 (37.7860267763126, -122.435039736101)
24608 128760 2 32 145 Geary St 12 10 1 1     5 Width 4ft   6010990.83089 2114854.39463 37.7876064418291 -122.405766620129 (37.7876064418291, -122.405766620129)
24682 203198 2 75 91 Market St 8 10 1 1     15 Width 10ft   6013828.57328 2116873.69458 37.7933092533841 -122.39609008760401 (37.7933092533841, -122.396090087604)
24709 182142 2 49 1418 25th Ave 2 10 1 1     6 Width 0ft   5988379.3786 2105646.1459999997 37.761032715479395 -122.483321592218 (37.7610327154794, -122.483321592218)
24727 129157 2 19 175 Spruce St 2 10 1 1     8 Width 3ft   5997198.13027 2114418.3589 37.785628226512706 -122.45345490104499 (37.7856282265127, -122.453454901045)
24769 244936 2 46 294 Page St 1 10 1 1     16 Width 0ft   6005165.6636 2109931.2421 37.7737611964044 -122.425570051796 (37.7737611964044, -122.425570051796)
24801 179172 2 220 766 Brussels St 1 10 1 1     4 Width 4ft   6011071.2158 2091212.4916599998 37.7226955033774 -122.403824260795 (37.7226955033774, -122.403824260795)
24832 246304 2 329 3996 17th St 3 10 1 1     2 Width 0ft   6002336.3946 2105898.3028 37.7625274658745 -122.435068430359 (37.7625274658745, -122.435068430359)
24865 127538 2 32 170 O'Farrell St 4 10 1 1     5 Width 3ft   6010539.53779 2114494.20954 37.7865922116181 -122.40730261183701 (37.7865922116181, -122.407302611837)
25005 177418 2 88 857 Dartmouth St 1 10 1 1     6 Width 4ft   6009516.77243 2090302.7647799999 37.720110619797104 -122.409133494811 (37.7201106197971, -122.409133494811)
25040 210510 2 1 57 Agua Way 13 10 1 1     9 Width 6ft   5997279.39992 2098558.56074 37.7420859128371 -122.452029069086 (37.7420859128371, -122.452029069086)
25089 224296 2 114 5 Powhattan Ave 1 10 1 1     43 Width 3ft   6007487.03456 2098209.30712 37.7417063503734 -122.416709460186 (37.7417063503734, -122.416709460186)
25116 132137 2 344 576 Sacramento St 1 10 1 1     5 Width 3ft   6011959.93168 2117122.22989 37.7938875264289 -122.40257323908999 (37.7938875264289, -122.40257323909)
25128 143413 2 2 599 Kearny St 1 10 1 1     4 Width 0ft   6011351.7699 2116964.7162 37.7934210599755 -122.404666454604 (37.7934210599755, -122.404666454604)
25173 140670 2 22 40 COLE ST 1 10 1 1     2 Width 0ft   5997774.3514 2110415.6204 37.7746707659902 -122.451172585534 (37.7746707659902, -122.451172585534)
25630 194576 2 110 572 Missouri St 1 10 1 1     5 Width 4ft   6013508.15849 2104424.13067 37.7591077391483 -122.396325765734 (37.7591077391483, -122.396325765734)
25634 128547 2 32 530 California St 5 10 1 1     5 Width 4ft   6011621.44747 2116740.1603200003 37.792819551831 -122.40371753735 (37.792819551831, -122.40371753735)
25652 193862 2 2 90 Stevenson St 4 10 1 1     11 Width 4ft   6012460.38897 2115317.66617 37.7889605483383 -122.40071476487101 (37.7889605483383, -122.400714764871)
25730 233142 2 41 62 Worth St 5 10 1 1     4 Width 3ft   6000859.74729 2102942.63257 37.754327958491395 -122.43996366469901 (37.7543279584914, -122.439963664699)
25825 233757 2 41 138 Alpine Ter 2 10 1 1     1 Width 3ft   6001688.84947 2107982.08951 37.7682122417201 -122.437457274854 (37.7682122417201, -122.437457274854)
25845 237234 2 18 110 Carmel St 4 10 1 1     10 Width 3ft   5998175.72217 2105385.27781 37.7608816968555 -122.449421648503 (37.7608816968555, -122.449421648503)
26021 137509 2 224 85 Toledo Way 1 10 1 1     6 Width 3ft   6001461.48208 2119936.52079 37.801023121670106 -122.439100597914 (37.8010231216701, -122.439100597914)
26027 227311 2 55 405 Beacon St 1 10 1 1     7 Width 4ft   6002323.66405 2098293.59277 37.7416460184529 -122.434568676724 (37.7416460184529, -122.434568676724)
26132 136381 2 138 1023 Broadway 2 10 1 1     15 Width 3ft   6008695.6423 2118278.0740799997 37.7968784080765 -122.413949834731 (37.7968784080765, -122.413949834731)
26143 245512 2 141 106 Chattanooga St 1 10 1 1     1 Width 4ft   6004701.89686 2103004.13948 37.754714811762206 -122.42668090920701 (37.7547148117622, -122.426680909207)
26283 226595 2 27 880 Douglass St 1 10 1 1     8 Width 3ft   6001269.3073 2101283.04072 37.749794423884794 -122.438428410468 (37.7497944238848, -122.438428410468)
26581 194044 2 1 1542 20th St 1 10 1 1     14 Width 3ft   6013293.95823 2104770.11303 37.760045809374205 -122.39709083697201 (37.7600458093742, -122.397090836972)
26617 126477 2 326 614 Grant Ave 4 10 1 1     1 Width 3ft   6010973.50945 2116764.5912 37.7928504165589 -122.405961165984 (37.7928504165589, -122.405961165984)
26691 222522 2 197 791 27th St 3 10 1 1     7 Width 5ft   6001439.60059 2099957.7516 37.7461651800752 -122.43774462443899 (37.7461651800752, -122.437744624439)
26807 223746 2 47 591 27th St 4 10 1 1     6 Width 4ft   6002725.9014 2100031.26808 37.7464400956267 -122.43330201489599 (37.7464400956267, -122.433302014896)
26888 128506 2 32 132 Bush St 6 10 1 1     3 Width 4ft   6012518.245680001 2116156.64354 37.791267409218705 -122.400573546136 (37.7912674092187, -122.400573546136)
26967 127517 2 32 330 Geary St 1 10 1 1     4 Width 4ft   6010076.35722 2114778.73619 37.7873475198145 -122.40892519296499 (37.7873475198145, -122.408925192965)
27067 225239 2 278 3900 22nd St 6 10 1 1     2 Width 4ft   6002410.772480001 2102995.6148099997 37.7545616068455 -122.43460362076799 (37.7545616068455, -122.434603620768)
27091 233553 2 108 916 Alvarado St 3 10 1 1     16 Width 3ft   6000357.83918 2102588.4411 37.7533268502794 -122.44167396838101 (37.7533268502794, -122.441673968381)
27120 135723 2 16 1910 Baker St 1 10 1 1     9 Width 4ft   5999974.03757 2115574.89722 37.7889625079578 -122.44393422098699 (37.7889625079578, -122.443934220987)
27204 126614 2 253 728 Washington St 1 10 1 1     1 Width 3ft   6011128.855280001 2117659.08548 37.7953151696175 -122.40548668546002 (37.7953151696175, -122.40548668546)
27211 190009 2 99 499 Arkansas St 2 10 1 1     12 Width 3ft   6013000.6424 2104780.97852 37.7600593109036 -122.39810604475099 (37.7600593109036, -122.398106044751)
27270 126949 2 32 3439 Sacramento St 2 10 1 1     2 Width 2ft   5998374.58367 2115190.1998 37.787814864221204 -122.449440363388 (37.7878148642212, -122.449440363388)
27365 128529 2 32 350 California St 4 10 1 1     5 Width 3ft   6012461.93985 2116858.6183599997 37.79319172545561 -122.400817703074 (37.7931917254556, -122.400817703074)
27368 138258 2 2 2600 GEARY BLVD 26 10 1 1     13 Width 0ft   5999069.3554 2113186.3828 37.7823526251779 -122.446892345537 (37.7823526251779, -122.446892345537)
27373 127889 2 32 1520 Mason St 1 10 1 1     6 Width 3ft   6009298.57619 2118522.06879 37.797582201307705 -122.411880784278 (37.7975822013077, -122.411880784278)
27555 101445 1 330 771 Stockton Tunl 4 10 1 1     2   Permit Number 25247 6010467.187000001 2116750.7503 37.7927840821229 -122.407712097586 (37.7927840821229, -122.407712097586)
27853 128263 2 32 2 Lombard St 1 10 1 1     7 Width 4ft   6012051.14949 2120876.60895 37.80420123766179 -122.402521741194 (37.8042012376618, -122.402521741194)
27892 208144 2 62 40 Garcia Ave 4 10 1 1     8 Width 3ft   5995206.64176 2099494.55804 37.7445369826924 -122.459263729149 (37.7445369826924, -122.459263729149)
27938 128409 2 32 251 Sutter St 5 10 1 1     6 Width 3ft   6011283.06953 2115589.6115900003 37.789641511384204 -122.40480730793699 (37.7896415113842, -122.404807307937)
27957 128525 2 32 300 California St 3 10 1 1     5 Width 4ft   6012595.64796 2116876.01852 37.7932469591239 -122.40035628434099 (37.7932469591239, -122.400356284341)
28116 128527 2 32 350 California St 2 10 1 1     5 Width 3ft   6012510.08821 2116864.88564 37.79321161938179 -122.400651546131 (37.7932116193818, -122.400651546131)
28203 122263 2 60 1400 Balboa St 2 10 1 1     17 Width 4ft   5991199.98338 2111351.52204 37.7768618890602 -122.473982714477 (37.7768618890602, -122.473982714477)
28250 129809 2 85 901 Sacramento St 8 10 1 1     12 Width 3ft   6010417.7029 2116870.15869 37.7931091785103 -122.40789173971399 (37.7931091785103, -122.407891739714)
28509 234021 2 243 147 Nevada St 1 10 1 1     13 Width 3ft   6009064.5456300005 2097789.7459400003 37.7406429263284 -122.411225300822 (37.7406429263284, -122.411225300822)
28548 223916 2 197 588 Ogden Ave 5 10 1 1     1 Width 4ft   6007765.411040001 2096148.4497200001 37.736063342858 -122.415601045774 (37.736063342858, -122.415601045774)
28732 127522 2 32 441 Mason St 2 10 1 1     6 Width 4ft   6009737.67951 2114979.8254 37.7878806856047 -122.410111154116 (37.7878806856047, -122.410111154116)
28738 209878 2 2 649 Parnassus Ave 1 10 1 1     8 Width 4ft   5994950.47657 2106078.83176 37.7626009937499 -122.460626532115 (37.7626009937499, -122.460626532115)
28810 189783 2 32 1712 20th St 1 10 1 1     9 Width 3ft   6012852.355219999 2104746.67943 37.759956872734705 -122.39861649547501 (37.7599568727347, -122.398616495475)
28844 128476 2 32 209 Front St 2 10 1 1     2 Width 5ft   6013054.34541 2116659.1488799998 37.792677054245296 -122.398753923573 (37.7926770542453, -122.398753923573)
28966 242013 2 37 3350 18th St 1 10 1 1     5 Width 3ft   6007139.614130001 2105587.52459 37.7619457090369 -122.418433769026 (37.7619457090369, -122.418433769026)
Powered by Datasette · Query took 81.292ms · Data source: data.sfgov.org