sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1354 14491 3 37 320 Masonic Ave 1 1 1 2     50 3X3   5999051.991 2111710.9656 37.77830051932229 -122.446846219186 (37.7783005193223, -122.446846219186)
1445 22600 3 37 837 Turk St 1 1 1 2     12 4X4   6005887.44223 2112751.69518 37.78154623162111 -122.42327383483999 (37.7815462316211, -122.42327383484)
1531 5189 3 37 509 Divisadero St 1 1 1 2     12 2X3   6001637.7109 2110249.8513 37.7744360439082 -122.43779659970501 (37.7744360439082, -122.437796599705)
1940 139586 3 37 3 Saint Joseph's Ave 3 1 1 2     8 Width 0ft   6000731.3449 2112139.6442 37.779573356306 -122.44106749101401 (37.779573356306, -122.441067491014)
1942 139585 3 37 5 Saint Joseph's Ave 2 1 1 2     8 Width 0ft   6000729.6528 2112161.6416 37.7796336591807 -122.4410749233 (37.7796336591807, -122.4410749233)
1952 139587 3 37 1 Saint Joseph's Ave 4 1 1 2     11 Width 0ft   6000732.3602 2112121.031 37.7795223070318 -122.441062642932 (37.7795223070318, -122.441062642932)
3757 6923 3 37 436 Fell St 1 1 1 2     24 3x3   6005320.8239 2110648.3853 37.775739063409794 -122.425084363796 (37.7757390634098, -122.425084363796)
4556 136909 3 37 2210 Stockton St 1 1 1 2     2 Width 3ft   6009830.0684 2121639.18274 37.806170828478606 -122.410261867902 (37.8061708284786, -122.410261867902)
4578 136910 3 37 2210 Stockton St 6 1 1 2     2 Width 3ft   6009806.2153 2121790.84358 37.8065859141719 -122.410355131177 (37.8065859141719, -122.410355131177)
5292 14530 3 37 700 Masonic Ave 1 1 1 2     60 3X3   5999227.9935 2110423.9359 37.774776718941105 -122.44614476286999 (37.7747767189411, -122.44614476287)
5443 23446 3 37 2100X Van Ness Ave 5 11 1 2     30 9   6005973.04919 2117793.46515 37.7953945104887 -122.423336192033 (37.7953945104887, -122.423336192033)
5493 22601 3 37 837 Turk St 2 1 1 2     12 4X4   6005919.22221 2112752.51326 37.781550271357204 -122.42316394935601 (37.7815502713572, -122.423163949356)
5745 18285 3 37 2000 Post St 3 1 1 2     6 4X4   6002494.2739 2114068.183 37.784968892425496 -122.435106743694 (37.7849688924255, -122.435106743694)
6149 14526 3 37 637 Masonic Ave 1 1 1 2     100 3X3   5999136.9105 2110609.5392 37.775281136182606 -122.446473192139 (37.7752811361826, -122.446473192139)
6490 8647 3 37 2761 Geary Blvd 2 1 1 2     3 3X3   5998533.8029 2113119.8829 37.7821394236041 -122.448740321446 (37.7821394236041, -122.448740321446)
6895 6225 3 37 1220 Ellis St 3 1 1 2     18 3X4   6005060.4446 2113384.1056 37.783235967029206 -122.426179889067 (37.7832359670292, -122.426179889067)
7514 14490 3 37 303 Masonic Ave 3 1 1 2     50 3X3   5998985.0486 2111710.2278 37.7782946690144 -122.44707774367399 (37.7782946690144, -122.447077743674)
7861 8161 3 37 1102 Fulton St 1 1 1 2     30 3X3   6002408.427999999 2111279.278 37.7773063874437 -122.43520419289699 (37.7773063874437, -122.435204192897)
8139 26934 3 37 1590 Golden Gate Ave 1 1 1 2     3 3X3   6002010.1563 2111919.4162 37.7790414215793 -122.436627772948 (37.7790414215793, -122.436627772948)
8574 26199 3 37 871 Turk St 2 1 1 2     3 3X3   6005870.33887 2112746.1622900004 37.7815300743983 -122.42333261090799 (37.7815300743983, -122.423332610908)
8720 22649 3 37 1251 Turk St 3 1 1 2     6 3X3   6003938.1475 2112482.5866 37.7806971228818 -122.429998257146 (37.7806971228818, -122.429998257146)
8980 17002 3 37 2028 Jefferson St 1 1 1 2     18 3X3   5999484.07976 2121214.10704 37.8044183160192 -122.446035175776 (37.8044183160192, -122.446035175776)
9015 22602 3 37 871 Turk St 1 1 1 2     12 4X4   6005851.84947 2112745.07106 37.78152603462821 -122.423396497843 (37.7815260346282, -122.423396497843)
9021 14488 3 37 303 Masonic Ave 1 1 1 2     60 3X3   5998978.3148 2111745.3393 37.778390691402 -122.447103565775 (37.778390691402, -122.447103565775)
9512 19511 3 37 101X Saint Joseph's Ave 2 1 1 2     12 4X4   6000658.415 2112657.2603 37.7809904437075 -122.44135693728902 (37.7809904437075, -122.441356937289)
9728 173660 3 37 1252 Turk St 1 1 1 2     1 3x3   6004044.0 2112543.0 37.7808689972899 -122.429636372405 (37.7808689972899, -122.429636372405)
9731 173661 3 37 1252 Turk St 1 1 1 2     1 3x3   6004044.0 2112543.0 37.7808689972899 -122.429636372405 (37.7808689972899, -122.429636372405)
10363 26319 3 37 2021 San Jose Ave 1 1 1 2     10 3X3   5999671.6195 2092116.9094 37.7245353858939 -122.443294987371 (37.7245353858939, -122.443294987371)
10431 26328 3 37 1857 San Jose Ave 2 1 1 2     6 3X3   6000421.70721 2093270.90592 37.7277467399142 -122.440784780799 (37.7277467399142, -122.440784780799)
10437 115185 3 37 2300X Alemany Blvd 2 11 1 2     3     5999482.43288 2089277.31598 37.716727722789 -122.443745071105 (37.716727722789, -122.443745071105)
10581 1040 3 37 2003X Alemany Blvd 2 1 1 2     25 4X4   6000664.666119999 2090352.04738 37.7197460535115 -122.439735693745 (37.7197460535115, -122.439735693745)
10742 115189 3 37 2300X Alemany Blvd 6 11 1 2     3     5999437.68927 2089235.07738 37.716609193035396 -122.443896694081 (37.7166091930354, -122.443896694081)
11125 15842 3 37 5243 Mission St 1 1 1 2     12 3x3   5999889.83361 2088564.50035 37.7147937208238 -122.442285750192 (37.7147937208238, -122.442285750192)
11251 115187 3 37 2300X Alemany Blvd 4 11 1 2     3     5999459.81391 2089256.7158599999 37.716669869389 -122.443821774256 (37.716669869389, -122.443821774256)
11541 15769 3 37 4770 Mission St 2 1 1 2     12 3X3   6001431.4832 2091064.0258 37.7217446032554 -122.437136033126 (37.7217446032554, -122.437136033126)
11787 26327 3 37 1857 San Jose Ave 1 1 1 2     6 3X3   6000413.8047 2093256.1266 37.7277057092515 -122.440811040114 (37.7277057092515, -122.440811040114)
12033 15771 3 37 4770 Mission St 4 1 1 2     12 3X3   6001407.8795 2091033.0967 37.7216583371772 -122.437215411352 (37.7216583371772, -122.437215411352)
12735 115192 3 37 2300X Alemany Blvd 9 11 1 2     3     5999381.87795 2089181.7631299999 37.7164596204897 -122.44408577653499 (37.7164596204897, -122.444085776535)
13177 94998 3 37 144 Leland Ave 1 1 1 2     3 3x3   6010267.0774 2087433.8156 37.712275077109 -122.406337892214 (37.712275077109, -122.406337892214)
13925 2497 3 37 1500 Burke Ave 1 1 1 2     12 3X3   6016766.5915 2098782.9536200003 37.7437990179202 -122.384663486948 (37.7437990179202, -122.384663486948)
14626 10913 3 37 1351X Hudson Ave 5 1 1 2     6 3X4   6016987.51869 2096153.0024299999 37.7365899183909 -122.38371649632299 (37.7365899183909, -122.383716496323)
16849 22416 3 37 5800 03rd St 15 1 1 2     18     6013664.2375 2091773.8949 37.724381524856206 -122.39489998248001 (37.7243815248562, -122.39489998248)
17148 197 3 37 300 Castro St 1 1 1 2     12 3X3   6002246.85388 2106423.49653 37.7639644352284 -122.43541568967899 (37.7639644352284, -122.435415689679)
17249 28766 3 37 1007 Guerrero St 1 1 1 2     3 3x3   6005756.3593 2103044.9501900002 37.7548864275923 -122.423037187213 (37.7548864275923, -122.423037187213)
17440 4242 3 37 4024 Cesar Chavez St 2 1 1 2     12 2X2   6003700.62714 2100425.74142 37.7475784763835 -122.42995965841101 (37.7475784763835, -122.429959658411)
17592 4009 3 37 321 Castro St 1 1 1 2     12 3X3   6002319.05105 2106225.20693 37.7634240802833 -122.43515179801201 (37.7634240802833, -122.435151798012)
17663 4241 3 37 4024 Cesar Chavez St 1 1 1 2     12 3X3   6003717.078869999 2100425.61204 37.747579052827504 -122.429902760105 (37.7475790528275, -122.429902760105)
17811 4012 3 37 328 Castro St 1 1 1 2     12 3x3   6002260.92536 2106287.441 37.76359165905 -122.435357287719 (37.76359165905, -122.435357287719)
17984 26257 3 37 1532 Guerrero St 1 1 1 2     10 3X3   6005857.37846 2100031.69628 37.746618424911496 -122.422473736782 (37.7466184249115, -122.422473736782)
18130 28744 3 37 756 San Jose Ave 1 1 1 2     3 3x3   6005606.56213 2098654.88944 37.7428238740223 -122.42324318142201 (37.7428238740223, -122.423243181422)
18296 4008 3 37 317 Castro St 1 1 1 2     12 3X3   6002316.37598 2106247.05915 37.7634839292556 -122.435162613271 (37.7634839292556, -122.435162613271)
18471 4497 3 37 1705 Church St 1 1 1 2     6 3X3   6004661.68171 2098887.89252 37.743410276978295 -122.426526901197 (37.7434102769783, -122.426526901197)
18678 19521 3 37 130X Saint Joseph's Ave 1 1 1 2     12 3X3   6000722.7955642 2112514.8377136 37.7806030550121 -122.44112399249201 (37.7806030550121, -122.441123992492)
18760 19342 3 37 509 Shields St 1 1 1 2     6 3X3   5992668.8586 2089831.50787 37.717858417018796 -122.467336296546 (37.7178584170188, -122.467336296546)
18886 19520 3 37 127 Saint Joseph's Ave 2 1 1 2     8 4X4   6000564.0 2112525.0 37.7806219117946 -122.44167407008999 (37.7806219117946, -122.44167407009)
19074 28747 3 37 802 San Jose Ave 1 1 1 2     3 3X3   6005523.07189 2098399.8522 37.7421188873695 -122.423513739777 (37.7421188873695, -122.423513739777)
19259 1364 3 37 25 Amethyst Way 1 1 1 2     12 1X1   5999126.95834 2100012.88601 37.746184795201 -122.445745384538 (37.746184795201, -122.445745384538)
19593 10226 3 37 1401 Guerrero St 1 1 1 2     12 3X3   6005881.42321 2100761.4578 37.7486235398515 -122.422442436769 (37.7486235398515, -122.422442436769)
19756 28746 3 37 842 San Jose Ave 1 1 1 2     3 3X3   6005458.2686 2098205.39084 37.7415812825622 -122.423723985986 (37.7415812825622, -122.423723985986)
19878 5726 3 37 1682 Dolores St 1 1 1 2     35 3X3   6005266.70473 2098545.04181 37.742503071459204 -122.424410502341 (37.7425030714592, -122.424410502341)
20063 19324 3 37 209 Shields St 1 1 1 2     6 3X3   5993447.930369999 2089821.98942 37.717877226336604 -122.46464272089099 (37.7178772263366, -122.464642720891)
20156 3999 3 37 301 Castro St 1 1 1 2     12 3X3   6002308.92816 2106431.24272 37.7639892295409 -122.43520154760598 (37.7639892295409, -122.435201547606)
20559 10046 3 37 380 Guerrero St 1 1 1 2     20 3X3   6005478.637490001 2106816.50174 37.765226545592604 -122.424265853604 (37.7652265455926, -122.424265853604)
20922 26259 3 37 1536 Guerrero St 1 1 1 2     10 3X3   6005857.34173 2100012.7812099997 37.7465664863671 -122.422472519989 (37.7465664863671, -122.422472519989)
20935 5168 3 37 301 Divisadero St 1 1 1 2     12 3X3   6001743.2373 2109490.4691 37.7723569698475 -122.437377176448 (37.7723569698475, -122.437377176448)
21504 5727 3 37 1677X Dolores St 1 1 1 2     80 3X3   6005353.56233 2098539.50836 37.742492782318 -122.424109780756 (37.742492782318, -122.424109780756)
21579 17062 3 37 1331 Oak St 1 1 1 2     12 3X3   6000630.2617 2109590.1832 37.7725674241249 -122.441234207963 (37.7725674241249, -122.441234207963)
21878 28494 3 37 448 Cortland Ave 1 1 1 2     8 3X3   6007458.4187 2097228.942 37.7390128754438 -122.416738967825 (37.7390128754438, -122.416738967825)
22036 5724 3 37 1673 Dolores St 1 1 1 2     70 3X3   6005351.61965 2098567.02903 37.7425682381455 -122.424118454716 (37.7425682381455, -122.424118454716)
22053 26209 3 37 794X San Jose Ave 1 1 1 2     6 3X3   6005562.046490001 2098516.05542 37.742440154891 -122.423387236658 (37.742440154891, -122.423387236658)
22176 26245 3 37 1539 Guerrero St 1 1 1 2     12 3X3   6005940.72977 2100031.08147 37.746621438530795 -122.422185472598 (37.7466214385308, -122.422185472598)
22717 9122 3 37 5812 Geary Blvd 1 1 1 2     6 3X3   5988979.0954 2112675.0185 37.7803669476462 -122.481762313457 (37.7803669476462, -122.481762313457)
23072 23656 3 37 300 Virginia Ave 1 1 1 2     8 3X3   6006894.09507 2098285.17058 37.7418812873926 -122.418765030684 (37.7418812873926, -122.418765030684)
23097 24665 3 37 4850 Geary Blvd 1 1 1 2     7     5991933.61016 2112783.76885 37.7808369148225 -122.471549293385 (37.7808369148225, -122.471549293385)
23135 9024 3 37 5335 Geary Blvd 1 1 1 2     4 3X3   5990401.7809 2112623.9395 37.7803093284395 -122.47683690049801 (37.7803093284395, -122.476836900498)
23157 16087 3 37 278 Monterey Blvd 1 1 1 2     4 0   6000249.694130001 2094706.57543 37.731678958116 -122.441482409212 (37.731678958116, -122.441482409212)
23252 22795 3 37 1910 Turk St 1 1 1 2     4 3X3   6000839.4886 2112107.3676 37.7794908920615 -122.440691060698 (37.7794908920615, -122.440691060698)
23285 1681 3 37 405 Balboa St 1 1 1 2     3 3X3   5994319.83202 2111404.8234200003 37.7771884605269 -122.46319416353901 (37.7771884605269, -122.463194163539)
23304 24655 3 37 333 Winfield St 1 1 1 2     5 2X3   6006602.01583 2097861.4273599996 37.7407013336984 -122.419744887942 (37.7407013336984, -122.419744887942)
23314 25277 3 37 1914 Ocean Ave 2 1 1 2     4 3X3   5994096.5557 2092590.4338 37.7255160797575 -122.46260143489401 (37.7255160797575, -122.462601434894)
23348 12189 3 37 1463 La Salle Ave 1 1 1 2     2     6016268.9903 2095509.3837 37.7347829272824 -122.38615592449699 (37.7347829272824, -122.386155924497)
23474 180020 3 37 1800x Alemany Blvd 8 11 1 2     4 Width 2ft   6001294.8535400005 2091604.85507 37.7232218307036 -122.437647038084 (37.7232218307036, -122.437647038084)
23615 180300 3 37 1500x Alemany Blvd 15 11 1 2     3 Width 3ft   6001840.8677900005 2092960.9802599999 37.7269764741671 -122.43585655983 (37.7269764741671, -122.43585655983)
23923 180093 3 37 2200x Alemany Blvd 3 11 1 2     3 Width 2ft   5999825.21966 2089601.0341900003 37.717636125294206 -122.44258345996799 (37.7176361252942, -122.442583459968)
25341 180280 3 37 1204x Alemany Blvd 18 11 1 2     3 Width 3ft   6002728.35558 2094064.39346 37.730056572136704 -122.432867327564 (37.7300565721367, -122.432867327564)
25355 180096 3 37 2200x Alemany Blvd 8 11 1 2     3 Width 2ft   5999764.69095 2089543.44622 37.717474551281704 -122.44278854676399 (37.7174745512817, -122.442788546764)
27182 15918 3 37 5688X Mission St 9 1 1 2     8 3x3   5997918.76709 2086907.8121 37.710132296496894 -122.44897927437799 (37.7101322964969, -122.448979274378)
27205 180297 3 37 1500x Alemany Blvd 12 11 1 2     3 Width 3ft   6001879.66047 2093045.2388099998 37.7272100325946 -122.43572848019699 (37.7272100325946, -122.435728480197)
28906 180049 3 37 1900x Alemany Blvd 13 11 1 2     2 Width 2ft   6000848.655230001 2090751.2328 37.7208525973406 -122.439128305154 (37.7208525973406, -122.439128305154)
29276 180062 3 37 1900x Alemany Blvd 29 11 1 2     3 Width 2ft   6000649.61116 2090402.60873 37.7198840266041 -122.439791356397 (37.7198840266041, -122.439791356397)
30468 180034 3 37 1800x Alemany Blvd 25 11 1 2     3 Width 2ft   6001097.83369 2091228.63345 37.7221776071819 -122.43830115639601 (37.7221776071819, -122.438301156396)
31090 180050 3 37 1900x Alemany Blvd 15 11 1 2     3 Width 2ft   6000834.87553 2090725.84202 37.7207820959038 -122.43917411838801 (37.7207820959038, -122.439174118388)
31509 180054 3 37 1900x Alemany Blvd 20 11 1 2     2 Width 2ft   6000783.664419999 2090626.8381700001 37.7205073395271 -122.43934404620501 (37.7205073395271, -122.439344046205)
31681 180089 3 37 2100x Alemany Blvd 13 11 1 2     1 Width 2ft   5999997.23135 2089763.94995 37.7180932587717 -122.442000582366 (37.7180932587717, -122.442000582366)
32210 180306 3 37 1604x Alemany Blvd 8 11 1 2     3 Width 3ft   6001696.41333 2092647.43732 37.7261073495475 -122.436333505406 (37.7261073495475, -122.436333505406)
33314 180058 3 37 1900x Alemany Blvd 25 11 1 2     3 Width 2ft   6000718.4568 2090503.6472599998 37.7201653741024 -122.43956062093599 (37.7201653741024, -122.439560620936)
33418 180274 3 37 1204x Alemany Blvd 11 11 1 2     3 Width 3ft   6002921.14547 2094140.96014 37.7302777397151 -122.432206295294 (37.7302777397151, -122.432206295294)
33919 180071 3 37 1900x Alemany Blvd 43 11 1 2     3 Width 2ft   6000421.866669999 2090169.28245 37.719230399348795 -122.440561861357 (37.7192303993488, -122.440561861357)
34228 218724 3 37 600x Laguna Honda Blvd 3 11 1 2     4 Width 3ft   5995542.9319 2099985.30545 37.7459037813392 -122.458136423557 (37.7459037813392, -122.458136423557)
34599 180281 3 37 1204x Alemany Blvd 19 11 1 2     3 Width 3ft   6002702.132669999 2094050.3830099998 37.7300166152669 -122.43295698278799 (37.7300166152669, -122.432956982788)
34779 180046 3 37 1900x Alemany Blvd 10 11 1 2     2 Width 2ft   6000892.57758 2090835.74953 37.72108716032729 -122.438982533116 (37.7210871603273, -122.438982533116)
Powered by Datasette · Query took 59.156ms · Data source: data.sfgov.org