sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1214 14441 3 1 57 Masonic Ave 1 1 1 2     100 4X4   5998815.3699 2112874.8656 37.781482766726896 -122.447748586483 (37.7814827667269, -122.447748586483)
126064 9313 3 1 99X Gold Mine Dr 1 1 1 2     90 2X2   6001391.6487444 2098856.3848919 37.743138360608704 -122.437831565564 (37.7431383606087, -122.437831565564)
8703 2829 3 1 1200 California St 1 1 1 2     80 3X3   6008547.0936900005 2116310.73962 37.7914682476113 -122.414324580422 (37.7914682476113, -122.414324580422)
91528 12533 1 1 129 LAKE ST 2 1 1 1   03/23/2006 12:00:00 AM 80 3X3   5995062.0 2114816.5 37.786598736379105 -122.460874108141 (37.7865987363791, -122.460874108141)
3267 2831 3 1 1200 California St 3 1 1 2     75 3X3   6008484.02773 2116302.9533599997 37.791443325609606 -122.414542237062 (37.7914433256096, -122.414542237062)
65623 177843 2 1 653 Peru Ave 5 17 1 1     51     6005078.05129 2092608.48476 37.726191958666796 -122.424640601997 (37.7261919586668, -122.424640601997)
21350 5101 3 1 2629 Diamond St 1 1 1 2     50 3x3   6002336.13825 2096372.73058 37.7363724838986 -122.43438824303101 (37.7363724838986, -122.434388243031)
6574 2832 3 1 1200 California St 4 1 1 2     45 3X3   6008465.75544 2116301.4842 37.7914382651038 -122.414605355047 (37.7914382651038, -122.414605355047)
19157 22548 3 1 19 Topaz Way 1 1 1 2     45 2X3   6001457.66842 2098646.06303 37.7425646201593 -122.437588228722 (37.7425646201593, -122.437588228722)
54380 194099 2 1 84 Whitney Young Cir 7 9 1 1     43     6016735.93504 2095074.45923 37.733614544669706 -122.384511236201 (37.7336145446697, -122.384511236201)
129850 244081 2 1 1600 Page St 3 1 1 1     43 Width 0ft   5998790.9441 2109040.9235 37.770954351947296 -122.447557026238 (37.7709543519473, -122.447557026238)
20254 23999 3 1 300 West Portal Ave 3 1 1 2     40 3x3   5992235.8832 2097133.9008 37.7378839736291 -122.469364124733 (37.7378839736291, -122.469364124733)
102948 109902 2 1 1534 SHRADER ST 1 1 1 1     40 3x3   5997915.3 2105444.6 37.7610296801598 -122.45032660600701 (37.7610296801598, -122.450326606007)
141464 114054 2 1 4422 24TH ST 1 1 1 1     40 5x5   6000476.0 2101726.0 37.750965527219 -122.441203471187 (37.750965527219, -122.441203471187)
35348 194039 3 1 900x Carolina St 74 3 1 2     38     6012510.33858 2102789.20195 37.754563007990896 -122.399661931254 (37.7545630079909, -122.399661931254)
76383 232394 2 1 45 Sharon St 1 1 1 1     37 Width 3ft   6003880.35265 2106887.72771 37.765331737480295 -122.42979901882799 (37.7653317374803, -122.429799018828)
3830 14440 3 1 45 Masonic Ave 1 1 1 2     36 4X4   5998808.9399 2112938.4889 37.78165709226779 -122.44777541277399 (37.7816570922678, -122.447775412774)
7106 8639 3 1 2600X Geary Blvd 2 1 1 2     36 3x3   5999285.607000001 2113327.5047 37.7827524611939 -122.446154367514 (37.7827524611939, -122.446154367514)
71281 232353 2 1 1401 Noe St 1 2 1 1     36 Width 6ft   6003304.68613 2099994.68694 37.74637247023129 -122.43129803308099 (37.7463724702313, -122.431298033081)
867 5563 3 1 1000 Dolores St 1 1 1 2     35 3   6005047.93676 2102495.8008 37.753338590028 -122.42544803402399 (37.753338590028, -122.425448034024)
17849 26939 3 1 1000 Dolores St 3 1 1 2     35 3   6005048.52765 2102486.42553 37.7533128811044 -122.42544532345501 (37.7533128811044, -122.425445323455)
151928 232302 2 1 1534 Shrader St 1 1 1 1     35 Width 4ft   5997889.799869999 2105442.36752 37.761022090923795 -122.450414638525 (37.7610220909238, -122.450414638525)
175058 177833 2 1 648 Peru Ave 3 17 1 1     35     6005045.58694 2092601.1582099998 37.726170008036 -122.42475230858601 (37.726170008036, -122.424752308586)
34033 177850 2 1 1260 Athens St 1 1 1 1     33 Width 6ft   6001426.1792 2087609.14768 37.7122579779848 -122.43690715954399 (37.7122579779848, -122.436907159544)
41840 232365 2 1 310 Miguel St 3 1 1 1     33 Width 3ft   6004309.242980001 2096567.7661599999 37.7370198087262 -122.427580283426 (37.7370198087262, -122.427580283426)
54114 210568 2 1 163 Melrose Ave 1 1 1 1     33 Width 5ft   5999033.69954 2095485.54294 37.7337484681112 -122.445742329568 (37.7337484681112, -122.445742329568)
56871 194048 2 1 1242 19th St 1 4 1 1     33 Width 5ft   6013830.06416 2105268.62635 37.761444447624 -122.395271611894 (37.761444447624, -122.395271611894)
155753 194045 2 1 399 Texas St 1 4 1 1     33 Width 5ft   6013807.05349 2105290.79153 37.7615040286026 -122.395352749639 (37.7615040286026, -122.395352749639)
161127 177831 2 1 100 Trumbull St 4 1 1 1     33 Width 3ft   6003962.8397 2094273.86284 37.730701668441895 -122.428614487595 (37.7307016684419, -122.428614487595)
43960 232361 2 1 869 Elizabeth St 1 1 1 1     32 Width 4ft   6000744.54456 2101976.60754 37.751668928482204 -122.440292790492 (37.7516689284822, -122.440292790492)
64474 248576 2 1 811 Shrader St 1 1 1 1     32 Width 0ft   5997625.7139 2107687.8398 37.7671724703286 -122.45148995870599 (37.7671724703286, -122.451489958706)
67467 232373 2 1 1520 Masonic Ave 1 2 1 1     32 Width 3ft   5999724.322980001 2107246.96096 37.766081879088 -122.44419952100401 (37.766081879088, -122.444199521004)
69526 177851 2 1 1260 Athens St 2 1 1 1     32 Width 6ft   6001405.83426 2087613.5591099998 37.712268934433 -122.436977793197 (37.712268934433, -122.436977793197)
124215 106155 2 1 174 STILLINGS AVE 1 1 1 1     32 3x3   5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791)
162072 210516 2 1 212 Staples Ave 5 9 1 1     32     5998671.88838 2093815.67028 37.7291427269309 -122.44687309392401 (37.7291427269309, -122.446873093924)
137153 177830 2 1 100 Trumbull St 2 1 1 1     31 Width 3ft   6003869.42584 2094268.83295 37.7306825704475 -122.42893707528201 (37.7306825704475, -122.428937075282)
167409 210548 2 1 1535 Plymouth Ave 3 2 1 1     31 Width 3ft   5995792.50445 2094281.41203 37.7302566245384 -122.456860970872 (37.7302566245384, -122.456860970872)
19162 9363 3 1 256 Gold Mine Dr 1 1 1 2     30 2x2   6001113.86641 2098278.49055 37.7415357993513 -122.43875065912901 (37.7415357993513, -122.438750659129)
37741 177836 2 1 650 Peru Ave 2 7 1 1     30     6005089.4768199995 2092569.03703 37.7260842891429 -122.424598299682 (37.7260842891429, -122.424598299682)
80150 838 3 1 4255X Judah St 2 1 1 2   04/24/2008 12:00:00 AM 30 3x3   5981362.6566223 2105522.5911084 37.7602826110734 -122.50757979099501 (37.7602826110734, -122.507579790995)
90609 120119 2 1 699X 28th St 2 1 1 1     30 3x3   6001710.0 2099417.0 37.744695775282004 -122.436770916391 (37.744695775282, -122.436770916391)
93600 11449 3 1 2X Arguello Blvd 3 1 1 2     30 3   5995514.85453 2115936.98374 37.789701328403794 -122.459388527967 (37.7897013284038, -122.459388527967)
103762 115780 2 1 1401X MASONIC AVE 1 1 1 1     30 3x3   5999527.0 2107685.0 37.7672733650738 -122.444913510993 (37.7672733650738, -122.444913510993)
114117 114775 2 1 101 FREDERICK ST 2 1 1 1     30 3x3   5999527.0 2107685.0 37.7672733650738 -122.444913510993 (37.7672733650738, -122.444913510993)
127929 106934 2 1 725 CASTRO ST 1 1 1 1     30 9x6   6002468.8 2103993.4 37.7573045800385 -122.43447428318501 (37.7573045800385, -122.434474283185)
50372 119204 2 1 851 48th Ave 9 1 1 1     29 Width 3ft   5981054.81855 2109824.51434 37.772076303922205 -122.50896387162399 (37.7720763039222, -122.508963871624)
52622 194098 2 1 389 Townsend St 2 9 1 1     29 Width 7ft   6013425.60382 2110329.05815 37.7753167635898 -122.397025307881 (37.7753167635898, -122.397025307881)
149665 210537 2 1 1427 Ulloa St 2 1 1 1     29 Width 3ft   5991566.4324900005 2098375.46288 37.741254277373 -122.471769177213 (37.741254277373, -122.471769177213)
23645 131755 2 1 1856 Pacific Ave 2 1 1 1     28 Width 4ft   6005252.93645 2117501.9314 37.7945533647075 -122.425807142281 (37.7945533647075, -122.425807142281)
24163 194035 2 1 1433 17th St 1 1 1 1     28 Width 3ft   6012914.68454 2106566.8968 37.7649582598465 -122.398528655089 (37.7649582598465, -122.398528655089)
42977 105374 2 1 127 WESTGATE DR 1 1 1 1     28 3x3   5993372.2 2093864.2 37.7289717869451 -122.46519792761299 (37.7289717869451, -122.465197927613)
51891 248548 2 1 136 Frederick St 1 1 1 1     28 Width 0ft   5999227.0741 2107711.1577 37.7673280658329 -122.445952789289 (37.7673280658329, -122.445952789289)
24757 210558 2 1 140 Hernandez Ave 1 9 1 1     27 Width 3ft   5995578.737319999 2099631.293 37.7449338085654 -122.457986999419 (37.7449338085654, -122.457986999419)
41968 245001 2 1 221 Central Ave 1 1 1 1     27 Width 0ft   5999831.2193 2109275.5852 37.7716580691907 -122.443975560572 (37.7716580691907, -122.443975560572)
46568 232340 2 1 691 29th St 6 9 1 1     27     6002112.62766 2098832.12217 37.7431127119846 -122.435336881217 (37.7431127119846, -122.435336881217)
53426 232343 2 1 685 29th St 1 9 1 1     27     6002200.5465400005 2098838.1570900003 37.7431342750257 -122.43503331323099 (37.7431342750257, -122.435033313231)
56393 232297 2 1 301 Putnam St 1 2 1 1     27 Width 9ft   6009073.4894199995 2095823.27697 37.73524393096471 -122.411055511504 (37.7352439309647, -122.411055511504)
56975 232389 2 1 25 Hartford St 1 1 1 1     27 Width 3ft   6002657.06447 2105749.66648 37.7621375497266 -122.433948726371 (37.7621375497266, -122.433948726371)
58319 141573 2 1 1500 GROVE ST 6 1 1 1     27 Width 0ft   6000484.1528 2110668.7166 37.7755204805101 -122.44181703345501 (37.7755204805101, -122.441817033455)
59881 141571 2 1 1500 GROVE ST 4 1 1 1     27 Width 0ft   6000522.0944 2110671.7279 37.775530910627 -122.441686000863 (37.775530910627, -122.441686000863)
133273 53674 1 1 2324 Divisadero St 1 1 1 1   02/02/1970 12:00:00 AM 27 3x3 Permit Number 6615 6000847.30796 2116375.23213 37.7912097941415 -122.44097026868401 (37.7912097941415, -122.440970268684)
167980 232292 2 1 200 Eugenia Ave 35 7 1 1     27 Width 10ft   6006575.0369 2098117.47597 37.7414028660575 -122.41985633551701 (37.7414028660575, -122.419856335517)
172858 187572 2 1 73 Bishop St 3 17 1 1     27     6010864.17104 2089487.4487 37.7179473203875 -122.404418609237 (37.7179473203875, -122.404418609237)
177620 210577 2 1 371 Staples Ave 2 1 1 1     27 Width 5ft   5997627.625030001 2093788.53301 37.72900850132 -122.45048122525499 (37.72900850132, -122.450481225255)
1011 232310 1 1 1018 Shrader St 1 1 1 1   08/18/2016 12:00:00 AM 26 Width 3ft Permit Number 17854 5997696.0 2107004.0 37.7652988449505 -122.451197528579 (37.7652988449505, -122.451197528579)
23048 8638 3 1 2600X Geary Blvd 1 1 1 2     26 0   5999322.495 2113336.6421 37.782779656634396 -122.44602740853901 (37.7827796566344, -122.446027408539)
52560 131721 2 1 451 Laurel St 1 1 1 1     26 Width 4ft   5998142.44354 2114904.79672 37.7870179407648 -122.45022294085501 (37.7870179407648, -122.450222940855)
56061 232364 2 1 310 Miguel St 1 1 1 1     26 Width 3ft   6004285.24489 2096599.68732 37.737106099566 -122.427665529246 (37.737106099566, -122.427665529246)
132942 210544 2 1 587 Dewey Blvd 4 2 1 1     26 Width 4ft   5994033.45225 2099305.95334 37.743951602279104 -122.46330666736601 (37.7439516022791, -122.463306667366)
136262 177829 2 1 100 Trumbull St 1 1 1 1     26 Width 4ft   6003826.80299 2094267.18245 37.7306756258798 -122.429084311385 (37.7306756258798, -122.429084311385)
150964 232363 2 1 301 Chenery St 1 1 1 1     26 Width 3ft   6004253.20124 2096600.10182 37.7371054250736 -122.427776348197 (37.7371054250736, -122.427776348197)
154193 232299 2 1 108 Valley St 1 1 1 1     26 Width 4ft   6005119.98151 2099339.98705 37.7446775233394 -122.424974374591 (37.7446775233394, -122.424974374591)
163421 194046 2 1 399 Texas St 2 4 1 1     26 Width 5ft   6013804.04007 2105323.21797 37.761592896918394 -122.395365443572 (37.7615928969184, -122.395365443572)
167556 131751 2 1 1690 Broadway 2 1 1 1     26 Width 4ft   6005602.995519999 2117899.87458 37.795665791896894 -122.424624213638 (37.7956657918969, -122.424624213638)
187126 142895 2 1 1015 DIVISADERO ST 1 1 1 1     26 Width 0ft   6000919.8741 2115393.3679 37.788517982728294 -122.440648735369 (37.7885179827283, -122.440648735369)
12649 24533 3 1 1395 47th Ave 2 1 1 2     25 3X3   5981505.7764 2105644.9273 37.7606269413357 -122.507093890918 (37.7606269413357, -122.507093890918)
17928 22547 3 1 15 Topaz Way 1 1 1 2     25 2X3   6001443.018180001 2098660.99719 37.7426047928778 -122.437639954147 (37.7426047928778, -122.437639954147)
24632 124488 2 1 3015 Turk Blvd 1 1 1 1     25 Width 5ft   5996527.76957 2111462.12046 37.7774727294111 -122.45556039254299 (37.7774727294111, -122.455560392543)
36763 194034 2 1 1 24th St 18 23 1 1     25     6017329.2954 2102592.85695 37.754291333594395 -122.382982871671 (37.7542913335944, -122.382982871671)
38897 177806 2 1 62 Tomaso Ct 10 7 1 1     25 Width 8ft   6009249.93875 2086480.54598 37.709600642326606 -122.409786194885 (37.7096006423266, -122.409786194885)
52201 131767 2 1 2448 Hyde St 2 1 1 1     25 Width 3ft   6007044.7048 2120715.74188 37.8034787699919 -122.419835539578 (37.8034787699919, -122.419835539578)
53946 122845 2 1 2X Masonic Ave 1 1 1 1     25 3x3   5999031.283 2113317.8597 37.782711451453096 -122.44703352321699 (37.7827114514531, -122.447033523217)
53960 232354 2 1 1401 Noe St 2 2 1 1     25 Width 6ft   6003303.21337 2100010.18921 37.746414952387 -122.431304232109 (37.746414952387, -122.431304232109)
54955 247427 2 1 433 Pierce St 3 1 1 1     25 Width 0ft   6002640.9603 2110148.8535 37.7742157250355 -122.43431895136001 (37.7742157250355, -122.43431895136)
56910 232413 2 1 297 Addison St 2 9 1 1     25 Width 2ft   6002454.82765 2097697.74661 37.7400174082831 -122.434072573816 (37.7400174082831, -122.434072573816)
66435 131722 2 1 451 Laurel St 2 1 1 1     25 Width 4ft   5998141.840030001 2114887.60099 37.7869706912948 -122.45022378889601 (37.7869706912948, -122.450223788896)
80904 105375 2 1 133 WESTGATE DR 1 1 1 1     25 3x3   5993389.1 2093898.7 37.7290674900164 -122.465142008345 (37.7290674900164, -122.465142008345)
84555 2254 3 1 410X Brotherhood Way 7 11 1 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
90353 104983 2 1 5715 DIAMOND HEIGHTS BLVD 2 1 1 1     25 3x3   6000755.2 2097122.9 37.738342408402204 -122.439907965606 (37.7383424084022, -122.439907965606)
98286 30056 3 1 410X Brotherhood Way 8 11 1 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
157284 113297 2 1 162 15th Ave 1 1 1 1   11/02/2015 12:00:00 AM 25 3x3 Permit Number 776713 5991196.72746 2114338.44012 37.7850629536775 -122.47421197891501 (37.7850629536775, -122.474211978915)
162173 177805 2 1 62 Tomaso Ct 9 7 1 1     25 Width 8ft   6009236.846480001 2086428.13607 37.709456001673296 -122.409827747151 (37.7094560016733, -122.409827747151)
172806 232342 2 1 687 29th St 1 9 1 1     25     6002180.92651 2098835.3599099996 37.74312548054821 -122.435100953944 (37.7431254805482, -122.435100953944)
176868 95004 1 1 220 Leland Ave 1 1 1 1     25 3x3   6009838.7213 2087613.1663 37.7127435660796 -122.40783106419701 (37.7127435660796, -122.407831064197)
180343 177809 2 1 968 Athens St 2 1 1 1     25 Width 4ft   6002194.0253 2088207.5246700002 37.7139446016244 -122.434296011252 (37.7139446016244, -122.434296011252)
180900 232341 2 1 689 29th St 4 9 1 1     25     6002137.6004 2098831.04756 37.7431111795389 -122.435250455448 (37.7431111795389, -122.435250455448)
53691 232409 2 1 275 Beacon St 1 1 1 1     24 Width 3ft   6002843.978680001 2097939.74109 37.7407039471414 -122.432744333589 (37.7407039471414, -122.432744333589)
54942 247437 2 1 400 Pierce St 3 2 1 1     24 Width 0ft   6002701.7149 2110019.7981 37.773864819164096 -122.434099563044 (37.7738648191641, -122.434099563044)
57725 54294 1 1 1950 Pierce St 1 1 1 1   06/08/1972 12:00:00 AM 24 3x3 Permit Number 10048 6001969.7317 2115259.0901 37.78820901946921 -122.437006779209 (37.7882090194692, -122.437006779209)
59114 131766 2 1 2448 Hyde St 1 1 1 1     24 Width 3ft   6007046.8227699995 2120698.6660599997 37.803432003442396 -122.419826997845 (37.8034320034424, -122.419826997845)
60864 210489 2 1 151 Merced Ave 2 1 1 1     24 Width 4ft   5994457.512490001 2099364.5681 37.7441369651657 -122.461844624233 (37.7441369651657, -122.461844624233)
Powered by Datasette · Query took 20.375ms · Data source: data.sfgov.org