sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
30108 210927 2 100 234 Joost Ave 1 9 1 1     35     6000492.41263 2094973.31916 37.732425199355 -122.44066241093701 (37.732425199355, -122.440662410937)
31219 194283 2 100 2 Tulare St 1 7 1 1     44     6016255.79944 2100318.37917 37.747986718206604 -122.386536741486 (37.7479867182066, -122.386536741486)
33897 132069 2 100 45 Havens St 3 9 1 1     29     6007646.13343 2119391.20002 37.7998757746973 -122.417660327771 (37.7998757746973, -122.417660327771)
34789 119450 2 100 800 33rd Ave 1 9 1 1     32     5985749.05602 2110390.9661 37.7739072286205 -122.49276808877701 (37.7739072286205, -122.492768088777)
39519 118599 2 100 249 Point Lobos Ave 4 17 1 1     35     5981986.20635 2112598.8818200002 37.7797487653148 -122.50594791191901 (37.7797487653148, -122.505947911919)
39528 194389 2 100 1031 Key Ave 4 2 1 1     36     6013123.75243 2089902.89375 37.7192140640518 -122.396637279208 (37.7192140640518, -122.396637279208)
42394 201687 2 100 401 08th St 23 7 1 1     23     6010195.30306 2109846.89146 37.7738124981919 -122.408165701983 (37.7738124981919, -122.408165701983)
42834 194390 2 100 1031 Key Ave 5 2 1 1     29     6013152.66051 2089880.8718700001 37.719155205216104 -122.396535811395 (37.7191552052161, -122.396535811395)
46040 187495 2 100 100 Walbridge St 1 7 1 1     8     6005184.36761 2086469.76682 37.709342367834395 -122.423836763664 (37.7093423678344, -122.423836763664)
47741 194278 2 100 1750 22nd St 7 17 1 1     5     6012817.610719999 2103799.38432 37.7573538722899 -122.398670182286 (37.7573538722899, -122.398670182286)
48345 194388 2 100 1031 Key Ave 3 2 1 1     40     6013107.94825 2089911.6587099999 37.7192372512804 -122.39669252276501 (37.7192372512804, -122.396692522765)
48420 187504 2 100 100 Walbridge St 10 7 1 1     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354)
48507 118600 2 100 249 Point Lobos Ave 2 17 1 1     37     5981958.17368 2112601.6345 37.779754673268705 -122.506045091658 (37.7797546732687, -122.506045091658)
48989 233929 2 100 8 Octavia St 2 2 1 1     31     6005769.81739 2109368.12443 37.77224912933389 -122.42344014465901 (37.7722491293339, -122.423440144659)
53743 118598 2 100 249 Point Lobos Ave 8 17 1 1     35     5982022.838269999 2112594.06181 37.7797376871414 -122.50582083083799 (37.7797376871414, -122.505820830838)
54301 194281 2 100 2 Tulare St 11 7 1 1     38     6016211.24922 2100302.5214299997 37.7479407097974 -122.38668969007601 (37.7479407097974, -122.386689690076)
54411 234398 2 100 3980 22nd St 8 4 1 1     32     6001905.073469999 2102956.38941 37.7544251823875 -122.436349651817 (37.7544251823875, -122.436349651817)
59423 194280 2 100 2 Tulare St 18 7 1 1     3     6016126.44291 2100241.55687 37.747768618243605 -122.38697869801202 (37.7477686182436, -122.386978698012)
59904 187497 2 100 100 Walbridge St 3 7 1 1     6     6005151.09396 2086478.68565 37.7093649785846 -122.42395239669399 (37.7093649785846, -122.423952396694)
68513 210928 2 100 617 Mangels Ave 2 9 1 1     37     5997342.33131 2095240.63361 37.732979290542104 -122.451572201795 (37.7329792905421, -122.451572201795)
69742 210912 2 100 443 Gennessee St 2 9 1 1     33     5997433.76219 2094954.34243 37.732198438902294 -122.451235463255 (37.7321984389023, -122.451235463255)
76008 201682 2 100 401 08th St 18 7 1 1     25     6010248.09063 2109749.24504 37.773547339368704 -122.40797621303899 (37.7735473393687, -122.407976213039)
132648 210911 2 100 443 Gennessee St 1 9 1 1     32     5997433.82925 2094957.55837 37.7322072729454 -122.451235463261 (37.7322072729454, -122.451235463261)
134605 194275 2 100 1 01st St 34 23 1 1     8     6014376.659969999 2105881.88915 37.76315871732 -122.39342406806101 (37.76315871732, -122.393424068061)
151716 194282 2 100 2 Tulare St 6 7 1 1     15     6016226.55416 2100307.94064 37.7479564371431 -122.386637143603 (37.7479564371431, -122.386637143603)
161645 194297 2 100 2198 Revere Ave 1 17 1 1     31     6011968.87844 2096761.7845599998 37.737982818059294 -122.40111095580299 (37.7379828180593, -122.401110955803)
162443 194387 2 100 1031 Key Ave 2 2 1 1     31     6013093.20116 2089924.2998099998 37.7192711404238 -122.39674438396099 (37.7192711404238, -122.396744383961)
163407 187499 2 100 100 Walbridge St 5 7 1 1     8     6005135.10052 2086491.02363 37.7093979531098 -122.42400854947999 (37.7093979531098, -122.42400854948)
164116 194276 2 100 2347 19th St 2 9 1 1     46     6010780.52383 2105047.83738 37.7606681393399 -122.405803207256 (37.7606681393399, -122.405803207256)
164381 218156 2 100 1396 Portola Dr 1 9 1 1     30     5993216.16649 2097685.94396 37.7394563464375 -122.46601493705799 (37.7394563464375, -122.466014937058)
170613 194296 2 100 1799 Revere Ave 6 2 1 1     38     6014052.02799 2095141.7859200002 37.733650626363 -122.393795063609 (37.733650626363, -122.393795063609)
171992 218157 2 100 1396 Portola Dr 2 9 1 1     44     5993196.82548 2097677.0995099996 37.7394309459859 -122.46608116671001 (37.7394309459859, -122.46608116671)
173622 234381 2 100 200 Eugenia Ave 2 7 1 1     10     6006554.5281 2098105.53483 37.74136892295 -122.41992640079599 (37.74136892295, -122.419926400796)
176009 234379 2 100 246 Bemis St 4 2 1 1     39     6003018.34772 2096316.7253 37.736257406663704 -122.432025563025 (37.7362574066637, -122.432025563025)
179308 124647 2 100 2 Arguello Blvd 4 9 1 1     24     5995536.8608800005 2115835.19472 37.789423108579996 -122.459305014392 (37.78942310858, -122.459305014392)
181517 194279 2 100 2 Tulare St 21 7 1 1     4     6016113.78589 2100276.91255 37.7478649967659 -122.387024931273 (37.7478649967659, -122.387024931273)
181927 201684 2 100 401 08th St 20 7 1 1     30     6010233.57215 2109769.89905 37.773603237626 -122.408027891695 (37.773603237626, -122.408027891695)
181931 247638 2 100 360 Bradford St 2 2 1 1     15     6009465.98098 2096572.55437 37.7373232876386 -122.40975139021499 (37.7373232876386, -122.409751390215)
182456 234394 2 100 1350 Noe St 2 9 1 1     30     6003187.2989 2100371.4904099996 37.7474004312881 -122.431730842629 (37.7474004312881, -122.431730842629)
184903 201683 2 100 401 08th St 19 7 1 1     23     6010259.3376400005 2109773.81073 37.7736154207404 -122.407939040461 (37.7736154207404, -122.407939040461)
186407 194386 2 100 1031 Key Ave 1 2 1 1     32     6013080.03152 2089934.31035 37.7192978943535 -122.396790608192 (37.7192978943535, -122.396790608192)
9735 173670 2 100 251x Lathrop Ave 1 1 1 1       3x3   6012236.0 2086860.0 37.7108094381203 -122.399492405366 (37.7108094381203, -122.399492405366)
100781 109174 2 100 63 KEYSTONE WAY 1 9 1 1   05/04/2015 12:00:00 AM 3 3x3 Permit Number 775282 5994095.9 2093146.9 37.7270439629203 -122.46264404963699 (37.7270439629203, -122.462644049637)
111110 116685 2 100 1x BIRD ST 2 1 1 1       3x3   6005912.0 2105722.0 37.762245762674496 -122.42268916815901 (37.7622457626745, -122.422689168159)
23525 187316 2 100 2200 Sunset Blvd 1 9 1 1     11 Width 0ft   5985075.4607 2099608.8478 37.744263118481705 -122.494303219592 (37.7442631184817, -122.494303219592)
24453 185441 2 100 2300 Sunset Blvd 60 9 1 1     4 Width 0ft   5985106.1344 2099492.3058 37.7439449206951 -122.49418856991899 (37.7439449206951, -122.494188569919)
32150 186007 2 100 1900 Sunset Blvd 2 9 1 1     4 Width 0ft   5985000.2752 2101640.5507 37.749837221065 -122.49471294958 (37.749837221065, -122.49471294958)
34765 143058 2 100 426 GREENWICH ST 1 1 1 1     30 Width 0ft   6010776.1378 2120354.2833 37.8026957973236 -122.406897202115 (37.8026957973236, -122.406897202115)
47083 186006 2 100 1900 Sunset Blvd 1 9 1 1     5 Width 0ft   5985010.9219 2101633.2915 37.7498179124605 -122.494675598244 (37.7498179124605, -122.494675598244)
52544 186008 2 100 1900 Sunset Blvd 3 9 1 1     2 Width 0ft   5985026.892000001 2101640.0667 37.749837450044495 -122.494620873169 (37.7498374500445, -122.494620873169)
59740 182872 2 100 1845 28th Ave 1 1 1 1     25 Width 0ft   5987505.5699 2102718.6655 37.7529437568716 -122.48612877158999 (37.7529437568716, -122.48612877159)
61791 182681 2 100 2701 Moraga St 2 1 1 1     8 Width 0ft   5985882.7747 2103629.0901 37.75534882242739 -122.491807644065 (37.7553488224274, -122.491807644065)
62437 182268 2 100 1466 35th Ave 1 1 1 1     37 Width 0ft   5985290.7143 2105238.2671 37.759732554956 -122.493973725026 (37.759732554956, -122.493973725026)
62633 185382 2 100 2615 34th Ave 1 9 1 1     36 Width 0ft   5985803.8248 2097379.5833 37.7381847526444 -122.491620661903 (37.7381847526444, -122.491620661903)
71688 182873 2 100 1845 28th Ave 2 1 1 1     24 Width 0ft   5987506.6654 2102709.2443 37.7529179526447 -122.486124291657 (37.7529179526447, -122.486124291657)
72198 245079 2 100 154 Baker St 1 1 1 1     38 Width 0ft   6000824.0394 2109520.8819 37.7723881764486 -122.440558941181 (37.7723881764486, -122.440558941181)
136550 186179 2 100 1700 Sunset Blvd 64 9 1 1     7 Width 0ft   5984928.6664 2103564.4514 37.755115531312704 -122.49510242297701 (37.7551155313127, -122.495102422977)
175193 182680 2 100 2701 Moraga St 1 1 1 1     7 Width 0ft   5985854.1638 2103629.5919999997 37.7553485282392 -122.491906624733 (37.7553485282392, -122.491906624733)
180226 186180 2 100 1700 Sunset Blvd 65 9 1 1     6 Width 0ft   5984958.094 2103565.49 37.755120105782204 -122.49500073187099 (37.7551201057822, -122.495000731871)
188962 182197 2 100 1584 36th Ave 1 2 1 1     33 Width 0ft   5985008.2078 2104414.5267 37.7574542590905 -122.494890024235 (37.7574542590905, -122.494890024235)
29139 194295 2 100 1942 Quesada Ave 1 7 1 1     30 Width 10ft   6013443.13195 2096013.71128 37.7360108970885 -122.395961290278 (37.7360108970885, -122.395961290278)
157407 210926 2 100 39 Melrose Ave 1 9 1 1     38 Width 10ft   5999833.49072 2095475.12852 37.7337655048678 -122.44297647541 (37.7337655048678, -122.44297647541)
166452 210925 2 100 43 Melrose Ave 1 9 1 1     36 Width 10ft   5999799.64358 2095482.9145400003 37.7337849536105 -122.443094053648 (37.7337849536105, -122.443094053648)
23714 234376 2 100 1750 Harrison St 2 4 1 1     6 Width 2ft   6008587.75214 2108113.66978 37.7689633348285 -122.41360388622499 (37.7689633348285, -122.413603886225)
32528 247549 2 100 815 Buena Vista Ave West 6 9 1 1     32 Width 2ft   6000106.41756 2108406.30035 37.7692869261681 -122.44296119951099 (37.7692869261681, -122.442961199511)
48105 118707 2 100 4201 Balboa St 2 9 1 1     18 Width 2ft   5982546.62842 2110970.49419 37.775310661099795 -122.503888560039 (37.7753106610998, -122.503888560039)
55424 210903 2 100 1939 16th Ave 2 1 1 1     22 Width 2ft   5991246.46009 2102193.40392 37.7517188372786 -122.47315388853599 (37.7517188372786, -122.473153888536)
70062 234377 2 100 1750 Harrison St 3 4 1 1     3 Width 2ft   6008587.9096 2108086.3181 37.768888242332004 -122.413601406792 (37.768888242332, -122.413601406792)
150774 118706 2 100 4201 Balboa St 1 9 1 1     10 Width 2ft   5982550.59501 2110970.7524 37.7753116033094 -122.50387485804899 (37.7753116033094, -122.503874858049)
159203 132067 2 100 3038 Lyon St 2 9 1 1     2 Width 2ft   5999089.102080001 2119262.1852 37.799036302553 -122.44726145536 (37.799036302553, -122.44726145536)
164993 118208 2 100 578 35th Ave 1 9 1 1     24 Width 2ft   5985073.59503 2111934.34638 37.7781053878802 -122.495218423393 (37.7781053878802, -122.495218423393)
186247 118708 2 100 4201 Balboa St 5 9 1 1     18 Width 2ft   5982482.88801 2110969.6299 37.7753045397791 -122.504108985066 (37.7753045397791, -122.504108985066)
25123 210904 2 100 1539 Lincoln Way 1 1 1 1     10 Width 3ft   5990882.40967 2107206.58351 37.7654626131273 -122.47477868020201 (37.7654626131273, -122.474778680202)
25705 234339 2 100 420 Dolores St 20 9 1 1     38 Width 3ft   6004868.93824 2105500.74139 37.7615793351331 -122.426280973507 (37.7615793351331, -122.426280973507)
26482 210923 2 100 1540 Plymouth Ave 2 2 1 1     41 Width 3ft   5995839.221390001 2094293.33064 37.7302920326405 -122.456700326779 (37.7302920326405, -122.456700326779)
28217 210914 2 100 317 Dorantes Ave 1 2 1 1     25 Width 3ft   5993048.097569999 2099658.5212 37.744862847537206 -122.46673939310301 (37.7448628475372, -122.466739393103)
29021 234332 2 100 420 Dolores St 5 9 1 1     15 Width 3ft   6004849.34041 2105800.52772 37.7624013694379 -122.42637009990601 (37.7624013694379, -122.426370099906)
32517 234386 2 100 800 Dolores St 2 1 1 1     18 Width 3ft   6004984.24145 2103652.12046 37.7565099745835 -122.42575060280899 (37.7565099745835, -122.425750602809)
35628 210924 2 100 1540 Plymouth Ave 5 2 1 1     43 Width 3ft   5995827.117740001 2094309.51389 37.730335772973206 -122.45674334043699 (37.7303357729732, -122.456743340437)
35925 234399 2 100 319 Virginia Ave 5 2 1 1     39 Width 3ft   6006918.01461 2098154.19018 37.7415229912067 -122.418673038125 (37.7415229912067, -122.418673038125)
39365 234337 2 100 420 Dolores St 17 9 1 1     31 Width 3ft   6004866.4127400005 2105541.3308900003 37.7616906415182 -122.42629259813299 (37.7616906415182, -122.426292598133)
43396 194272 2 100 1022 Minna St 2 4 1 1     9 Width 3ft   6007547.687530001 2109714.25342 37.7732997020571 -122.41731485230801 (37.7732997020571, -122.417314852308)
44771 234338 2 100 420 Dolores St 19 9 1 1     37 Width 3ft   6004867.72819 2105514.5268599996 37.761617118366104 -122.42628614009199 (37.7616171183661, -122.426286140092)
48676 210905 2 100 1545 Lincoln Way 1 1 1 1     10 Width 3ft   5990857.32948 2107205.82169 37.76545906800929 -122.47486537036501 (37.7654590680093, -122.474865370365)
63620 234384 2 100 899 Hampshire St 4 9 1 1     10 Width 3ft   6010216.7904900005 2104076.88773 37.757970587791 -122.407684453188 (37.757970587791, -122.407684453188)
72122 234341 2 100 420 Dolores St 22 9 1 1     35 Width 3ft   6004869.93402 2105476.5468200003 37.7615129588681 -122.42627580688401 (37.7615129588681, -122.426275806884)
73625 178085 2 100 210 Tocoloma Ave 6 1 1 1     16 Width 3ft   6012726.322790001 2087488.8573099999 37.712563474091894 -122.397841808652 (37.7125634740919, -122.397841808652)
130062 178088 2 100 201 Chicago Way 2 1 1 1     31 Width 3ft   6003023.7628 2086943.7814599997 37.7105216991954 -122.431337972882 (37.7105216991954, -122.431337972882)
131685 210910 2 100 151 Garcia Ave 4 9 1 1     10 Width 3ft   5994660.64772 2099277.20114 37.743908769387005 -122.461135900907 (37.743908769387, -122.461135900907)
131778 234335 2 100 420 Dolores St 13 9 1 1     28 Width 3ft   6004864.336759999 2105585.63058 37.7618121606106 -122.42630293224899 (37.7618121606106, -122.426302932249)
135856 234333 2 100 420 Dolores St 10 9 1 1     30 Width 3ft   6004857.87037 2105688.78101 37.762095021687706 -122.42633264136002 (37.7620950216877, -122.42633264136)
136108 234331 2 100 420 Dolores St 4 9 1 1     25 Width 3ft   6004849.00155 2105814.83535 37.762440635635 -122.426372290646 (37.762440635635, -122.426372290646)
136703 178086 2 100 364 Capistrano Ave 1 1 1 1     43 Width 3ft   6001063.00753 2092653.5980599998 37.7260882551546 -122.438523588412 (37.7260882551546, -122.438523588412)
149136 234366 2 100 9 Duncan St 2 1 1 1     8 Width 3ft   6006381.599330001 2099941.08815 37.746399194477206 -122.420654601644 (37.7463991944772, -122.420654601644)
149367 234380 2 100 1001 San Jose Ave 4 2 1 1     9 Width 3ft   6005142.82168 2096774.43039 37.7376343766353 -122.424712922782 (37.7376343766353, -122.424712922782)
157052 210909 2 100 151 Garcia Ave 2 9 1 1     8 Width 3ft   5994659.02084 2099296.69557 37.7439622025921 -122.46114293900601 (37.7439622025921, -122.461142939006)
158189 234383 2 100 3483 22nd St 2 1 1 1     3 Width 3ft   6005156.87556 2103096.1087599997 37.7549930502992 -122.425114011399 (37.7549930502992, -122.425114011399)
160623 234336 2 100 420 Dolores St 14 9 1 1     18 Width 3ft   6004864.2449199995 2105581.16954 37.7617999064621 -122.42630293226101 (37.7617999064621, -122.426302932261)
163198 234393 2 100 1557 Sanchez St 2 1 1 1     7 Width 3ft   6003994.29589 2099192.81462 37.7442097715744 -122.42885628561001 (37.7442097715744, -122.42885628561)
163388 233927 2 100 389 Webster St 3 4 1 1     18 Width 3ft   6004115.83529 2109995.53754 37.7738783609231 -122.429206159632 (37.7738783609231, -122.429206159632)
163745 234334 2 100 420 Dolores St 12 9 1 1     33 Width 3ft   6004862.85296 2105604.25637 37.7618632187373 -122.426309390288 (37.7618632187373, -122.426309390288)
Powered by Datasette · Query took 92.912ms · Data source: data.sfgov.org