sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31 22614 1 5 1001 Turk St 5 1 1 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
85 22613 1 5 1001 Turk St 4 1 1 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
589 26916 1 15 1901 Geary Blvd 10 1 1 3     18 3X3   6002555.1851 2113680.9302 37.783909052953 -122.43486830704398 (37.783909052953, -122.434868307044)
630 20157 1 26 1100X Steiner St 2 1 1 3     18 4X4   6002895.0285 2112125.5503 37.7796576600117 -122.433581380876 (37.7796576600117, -122.433581380876)
1909 125218 1 5 2101 Washington St 21 1 1 3     13 Width 4ft   6005090.35688 2116771.11072 37.7925375271472 -122.42631763077499 (37.7925375271472, -122.426317630775)
1964 238618 2 15 4302 24th St 4 1 1 3     14 Width 4ft   6001078.53558 2101746.02342 37.751054810249 -122.439121284114 (37.751054810249, -122.439121284114)
1974 238616 2 15 4302 24th St 2 1 1 3     23 Width 4ft   6001186.94921 2101750.3744 37.7510729252903 -122.43874669133301 (37.7510729252903, -122.438746691333)
1975 238619 2 15 4302 24th St 5 1 1 3     23 Width 4ft   6001066.93276 2101745.60422 37.7510529990026 -122.43916137771099 (37.7510529990026, -122.439161377711)
2024 139198 1 15 1900 GEARY BLVD 26 1 1 3     18 Width 0ft   6001803.3539 2113704.6103 37.783931357581395 -122.437471057097 (37.7839313575814, -122.437471057097)
2033 139199 1 15 1900 GEARY BLVD 27 1 1 3     19 Width 0ft   6001773.0984 2113703.8723 37.7839276110688 -122.437575676931 (37.7839276110688, -122.437575676931)
3688 9457 1 150 800X Golden Gate Ave 13 1 1 3     6 3X3   6005414.2393 2112401.6078 37.7805582605963 -122.424885977306 (37.7805582605963, -122.424885977306)
3904 4665 1 59 600X Columbus Ave 8 1 1 3     100 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881)
4255 4659 1 59 600X Columbus Ave 2 1 1 3     90 5X5   6009780.1976 2119571.0943 37.800489575353104 -122.410288343699 (37.8004895753531, -122.410288343699)
5145 4664 1 59 600X Columbus Ave 7 1 1 3     90 5X5   6009692.467999999 2119649.5892 37.8007001848924 -122.410597470914 (37.8007001848924, -122.410597470914)
5555 8527 1 15 1901 Geary Blvd 9 1 1 3     24 3X3   6002529.8149 2113677.2092 37.7838973955703 -122.434955812258 (37.7838973955703, -122.434955812258)
6893 8489 1 15 1900X Geary Blvd 12 1 1 3     18 3X3   6002220.6585 2113766.2282 37.7841242607304 -122.436031749589 (37.7841242607304, -122.436031749589)
6968 4661 1 59 600X Columbus Ave 4 1 1 3     90 5X5   6009739.5649 2119605.2627 37.8005811155969 -122.41043136381901 (37.8005811155969, -122.410431363819)
7037 4663 1 59 600X Columbus Ave 6 1 1 3     60 5X5   6009710.0139 2119634.3519 37.8006593307081 -122.41053567802 (37.8006593307081, -122.41053567802)
7109 18519 1 59 1700X Powell St 1 1 1 3     30 3X3   6009627.5943 2119520.0726 37.800340927010296 -122.410812809398 (37.8003409270103, -122.410812809398)
7171 9447 1 22 800X Golden Gate Ave 3 7 1 3     12 3X3   6005622.1957 2112431.3933 37.780651788182794 -122.424168675479 (37.7806517881828, -122.424168675479)
7403 107472 2 26 1464 Washington St 1 1 1 3     12 3x3   6007706.0171300005 2117181.73808 37.793812512193604 -122.417296448573 (37.7938125121936, -122.417296448573)
7614 20156 1 26 1100X Steiner St 1 1 1 3     18 4X4   6002897.8994 2112109.7603 37.7796144675148 -122.43357032043899 (37.7796144675148, -122.433570320439)
7635 8487 1 15 1900X Geary Blvd 10 1 1 3     18 3X3   6002304.7836 2113777.2973 37.7841594324943 -122.43574149958401 (37.7841594324943, -122.435741499584)
7636 99241 2 32 560X Ellis St 2 1 1 3     10 4x4   6008235.1228 2113825.75072 37.7846275436788 -122.415228013286 (37.7846275436788, -122.415228013286)
7647 99242 2 32 560X Ellis St 3 1 1 3     8 4x4   6008195.716580001 2113819.71845 37.7846087658129 -122.415363918808 (37.7846087658129, -122.415363918808)
7676 9450 1 150 800X Golden Gate Ave 6 7 1 3     12 3X3   6005543.6705 2112420.5622 37.780617614602896 -122.424439561439 (37.7806176146029, -122.424439561439)
7827 9544 1 50 1100X Golden Gate Ave 12 1 1 3     6 3X3   6003937.8747 2112189.6367 37.7798927397998 -122.429978297745 (37.7798927397998, -122.429978297745)
7851 4658 1 59 600X Columbus Ave 1 1 1 3     34 5X5   6009795.4348 2119557.2423 37.8004523952872 -122.410234638074 (37.8004523952872, -122.410234638074)
7925 22616 1 37 1001 Turk St 7 1 1 3     24 3x5   6005581.297 2112717.6262 37.7814354041528 -122.424330527926 (37.7814354041528, -122.424330527926)
7939 4660 1 59 600X Columbus Ave 3 1 1 3     125 5X5   6009761.7282 2119587.7167 37.8005341810425 -122.410353429867 (37.8005341810425, -122.410353429867)
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
8289 4662 1 59 600X Columbus Ave 5 1 1 3     80 5X5   6009727.0981 2119617.2678 37.8006133797513 -122.41047535239099 (37.8006133797513, -122.410475352391)
8608 9533 1 25 1100X Golden Gate Ave 1 1 1 3     6 3X3   6004176.1272 2112221.7819 37.7799944925987 -122.429156369266 (37.7799944925987, -122.429156369266)
8790 105143 2 35 432 Octavia St 1 1 1 3 2   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933)
8794 8525 1 15 1901 Geary Blvd 7 1 1 3     18 3X3   6002439.1587 2113663.3402 37.7838541670365 -122.43526845642201 (37.7838541670365, -122.435268456422)
8920 9449 1 22 800X Golden Gate Ave 5 7 1 3     12 3X3   6005556.1262 2112420.5622 37.780618317973 -122.424396471178 (37.780618317973, -122.424396471178)
10993 764 1 5 1200X 37th Ave 1 1 1 3     12 3   5984614.2914 2106873.7688 37.76418358274471 -122.496433785178 (37.7641835827447, -122.496433785178)
11793 120892 2 37 201 Leland Ave 8 1 1 3     6 3x3   6009904.76 2087542.3079 37.7125527002168 -122.407597819442 (37.7125527002168, -122.407597819442)
14183 7380 1 44 1000X Folsom St 4 1 1 3     45 3X3   6010853.2469 2111475.4662 37.7783210049209 -122.40600450833401 (37.7783210049209, -122.406004508334)
14374 26131 1 25 1500 Oakdale Ave 1 1 1 3     12 3x3   6015558.456 2095125.3192 37.7336890117673 -122.388585707606 (37.7336890117673, -122.388585707606)
15206 26133 1 25 1504 Oakdale Ave 3 1 1 3     18 5x5   6015522.1816 2095153.8991 37.7337654760523 -122.388713114387 (37.7337654760523, -122.388713114387)
15454 7377 1 44 1000X Folsom St 1 1 1 3     45 3X3   6010910.3764 2111530.9317 37.7784764953194 -122.405810783213 (37.7784764953194, -122.405810783213)
15604 7382 1 44 1000X Folsom St 6 1 1 3     60 3X3   6010814.6984 2111439.6909 37.7782206182135 -122.406135341461 (37.7782206182135, -122.406135341461)
15693 7378 1 44 1000X Folsom St 2 1 1 3     45 3X3   6010884.8623 2111505.4176 37.7784050126686 -122.40589724881 (37.7784050126686, -122.40589724881)
16764 7379 1 44 1000X Folsom St 3 1 1 3     45 3X3   6010870.4412 2111489.3325 37.7783600402028 -122.40594600363998 (37.7783600402028, -122.40594600364)
17375 24541 1 15 500X Cortland Ave 5 1 1 3     50 3x3   6007668.223019999 2097198.66884 37.7389415501992 -122.416011415406 (37.7389415501992, -122.416011415406)
17563 687 1 229 1299X Potrero Ave 1 1 1 3     20 3X3   6010636.022580001 2101844.6913400004 37.75186493122229 -122.40607730804199 (37.7518649312223, -122.406077308042)
17712 5442 1 21 500X Dolores St 10 1 1 3     20 6   6004907.01705 2105068.65381 37.7603950772802 -122.426118512771 (37.7603950772802, -122.426118512771)
18045 24537 1 15 500X Cortland Ave 1 1 1 3     18 3X3   6007586.10322 2097213.8581 37.738978639151505 -122.416296424042 (37.7389786391515, -122.416296424042)
18074 112652 2 21 3100X 26TH ST 6 1 1 3       3x3   6008747.0 2100981.0 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695)
18163 24539 9 292 500X Cortland Ave 3 1 1 3     50 3X3   6007622.1254900005 2097206.54003 37.738960570878795 -122.41617135711999 (37.7389605708788, -122.41617135712)
18569 9792 1 11 997X Gough St 3 1 1 3     36 3x3   6005630.9126204 2113075.2727516997 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881)
18744 5437 1 21 500X Dolores St 5 1 1 3     25 6   6004897.82208 2105221.96635 37.760815517531206 -122.426161228775 (37.7608155175312, -122.426161228775)
18991 5440 1 21 500X Dolores St 8 1 1 3     100 6   6004903.17124 2105121.8240799997 37.7605408528978 -122.426135598976 (37.7605408528978, -122.426135598976)
19639 9777 1 11 897X Gough St 5 1 1 3     30 3X3   6005678.151576 2112736.5747486 37.781492900843894 -122.42399680548999 (37.7814929008439, -122.42399680549)
19884 5444 1 21 500X Dolores St 12 1 1 3     20 6   6004913.15076 2105006.62195 37.760225099135795 -122.426092882994 (37.7602250991358, -122.426092882994)
19899 24538 1 15 500X Cortland Ave 2 1 1 3     12 3X3   6007606.23219 2097211.71423 37.7389738844263 -122.416226675338 (37.7389738844263, -122.416226675338)
19927 10223 1 25 1377X Guerrero St 1 1 1 3     12 3X3   6005871.04446 2100967.56548 37.7491888788632 -122.42249296966999 (37.7491888788632, -122.42249296967)
20082 111807 2 43 50X COLUMBIA SQUARE ST 4 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
20843 111792 2 43 55X SHERMAN ST 9 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
20862 116132 2 17 1601X Armstrong Ave 4 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
20901 5441 1 21 500X Dolores St 9 1 1 3     90 6   6004905.78091 2105098.60706 37.76047725195271 -122.426124920443 (37.7604772519527, -122.426124920443)
21449 24540 9 292 500X Cortland Ave 4 1 1 3     50 3X3   6007652.968230001 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819)
21952 5447 1 21 500X Dolores St 15 1 1 3     100 6   6004926.667780001 2104747.1594700003 37.7595134404185 -122.42602766326401 (37.7595134404185, -122.426027663264)
24234 103219 3 15 1600X 29th Ave 3 5 1 3     11 3x4   5987198.2105 2103866.2266 37.7560767305116 -122.48727594694401 (37.7560767305116, -122.487275946944)
24419 20488 1 47 1204 Sunset Blvd 9 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
25448 102374 2 44 870 39th Ave 3 1 1 3     2     5983888.78905 2110020.99125 37.7727824290992 -122.499175615397 (37.7727824290992, -122.499175615397)
26127 110046 2 44 288 Eddy St 6 1 1 3     2     6009043.83179 2113590.50747 37.7840270384566 -122.412413507572 (37.7840270384566, -122.412413507572)
27576 103186 3 15 1601X 28th Ave 10 1 1 3     0 3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
28004 103180 3 15 1601X 28th Ave 1 1 1 3     11 3x4   5987448.1702 2104354.2995 37.757431419068496 -122.486447346513 (37.7574314190685, -122.486447346513)
30617 103185 3 15 1601X 28th Ave 8 1 1 3     0 3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
31420 102369 2 15 851 38th Ave 2 1 1 3     12   Permit Number 769895 5984151.59861 2110096.53732 37.773005270668 -122.49827212221099 (37.773005270668, -122.498272122211)
32170 111793 2 18 55X Sherman St 10 1 1 3     6 3x3   6010868.84129 2110834.34163 37.7765614981606 -122.405905386452 (37.7765614981606, -122.405905386452)
32299 103222 3 15 1600X 29th Ave 8 5 1 3     11 3x4   5987186.3641 2104162.3873 37.7568892163494 -122.487338668246 (37.7568892163494, -122.487338668246)
33246 102378 2 16 870 39th Ave 4 1 1 3     2     5983886.84831 2110037.48525 37.7728276030319 -122.499183547509 (37.7728276030319, -122.499183547509)
33621 102375 2 44 870 39th Ave 5 1 1 3     1     5983887.37527 2110050.4929400003 37.7728633493226 -122.499182686047 (37.7728633493226, -122.499182686047)
34305 20466 1 2 1202X Sunset Blvd 5 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
38057 102379 2 15 851 38th Ave 6 1 1 3     3     5984156.57881 2110013.67242 37.772778039448106 -122.49824877411999 (37.7727780394481, -122.49824877412)
38305 116138 2 53 1601X Armstrong Ave 10 1 1 3     30     6014404.0852 2092434.1919 37.7262356791342 -122.39238857399599 (37.7262356791342, -122.392388573996)
39888 102373 2 44 870 39th Ave 1 1 1 3     1     5983890.730690001 2109977.48147 37.7726630776505 -122.499165683617 (37.7726630776505, -122.499165683617)
43434 103190 3 15 1601X 28th Ave 4 5 1 3     11 3x4   5987454.6857 2104172.4568 37.7569325082599 -122.486411463243 (37.7569325082599, -122.486411463243)
43485 20515 1 47 1211X Sunset Blvd 11 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
43693 111802 2 32 55X Sherman St 19 1 1 3     25 3x3   6010732.9183 2110973.0919 37.7769348714848 -122.406385364505 (37.7769348714848, -122.406385364505)
44221 103193 3 15 1601X 28th Ave 11 5 1 3     10 3x4   5987467.1245 2103820.0255 37.755965552668705 -122.486342572342 (37.7559655526687, -122.486342572342)
45897 103220 3 15 1600X 29th Ave 5 5 1 3     12 3x4   5987192.8796 2103980.5446 37.756390305765706 -122.48730277925199 (37.7563903057657, -122.487302779252)
46034 103206 3 15 1600X 29th Ave 1 1 1 3     10 3x4   5987202.3567 2103753.0931 37.7557663384655 -122.487253298879 (37.7557663384655, -122.487253298879)
46862 103223 3 15 1600X 29th Ave 9 5 1 3     11 3x4   5987183.9948 2104224.5811 37.7570598454095 -122.487351430278 (37.7570598454095, -122.487351430278)
48565 112649 2 21 3100X 26TH ST 3 1 1 3       3x3   6008747.0 2100981.0 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695)
50158 20507 1 11 1211X Sunset Blvd 3 1 1 3     12 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
50310 103191 3 15 1601X 28th Ave 6 5 1 3     10 3x4   5987457.055 2104097.8243 37.7567277258047 -122.48639779019199 (37.7567277258047, -122.486397790192)
55860 111803 2 32 55X Sherman St 20 1 1 3     26 3x3   6010715.3243 2110993.12608 37.7769888964448 -122.40644763986099 (37.7769888964448, -122.406447639861)
56141 120887 2 35 201 Leland Ave 3 1 1 3     1 3x3   6009811.6249 2087578.8489 37.7126478205015 -122.407922299954 (37.7126478205015, -122.407922299954)
61312 103208 3 15 1600X 29th Ave 7 1 1 3     12 3x4   5987188.7333 2104102.5628 37.7567250927297 -122.487326080643 (37.7567250927297, -122.487326080643)
61322 120888 2 35 201 Leland Ave 4 1 1 3     1 3x3   6009826.3305 2087573.9471 37.7126351844606 -122.40787112709101 (37.7126351844606, -122.407871127091)
63534 120891 2 35 201 Leland Ave 7 1 1 3     1 3x3   6009886.0438 2087551.2204 37.71257612443421 -122.407663136759 (37.7125761244342, -122.407663136759)
66190 20482 1 3 1204 Sunset Blvd 3 1 1 3     42 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
67560 117168 2 35 299x ALMA ST 5 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
68744 103184 3 15 1601X 28th Ave 7 1 1 3     11 3x4   5987458.2396 2104042.7384 37.75657654394 -122.48638964930001 (37.75657654394, -122.4863896493)
69190 102377 2 16 870 39th Ave 2 1 1 3     3     5983889.8768 2109995.31333 37.7727119887219 -122.49916995510901 (37.7727119887219, -122.499169955109)
72532 116318 2 54 1451 Hampshire St 1 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
74287 103218 3 15 1600X 29th Ave 2 5 1 3     11 3x4   5987199.9875 2103809.956 37.755922330371796 -122.48726566863701 (37.7559223303718, -122.487265668637)
Powered by Datasette · Query took 10.139ms · Data source: data.sfgov.org