sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
152279 224022 2 36 1300 San Jose Ave 21 7 1 1     25     6003540.82213 2095652.97051 37.7344644939234 -122.43017181569999 (37.7344644939234, -122.4301718157)
152132 218786 2 36 230 Edna St 6 17 1 1     11     5998782.33461 2095362.2846400002 37.733395674875005 -122.44660250410101 (37.733395674875, -122.446602504101)
151958 246078 2 36 646 Clayton St 1 1 1 1     23 Width 0ft   5998541.3176 2108402.6679 37.7691875956286 -122.44837451744 (37.7691875956286, -122.44837451744)
151612 138646 2 36 600 PRESIDIO AVE 3 1 1 1     12 Width 0ft   5999217.4357 2114545.2385 37.786092147648894 -122.446477845811 (37.7860921476489, -122.446477845811)
151016 201393 2 36 1051 Ingalls St 4 1 1 1     16 Width 3ft   6018055.18008 2094851.83514 37.733076127748795 -122.379934711318 (37.7330761277488, -122.379934711318)
150829 224029 2 36 56 Alma St 1 1 1 1     21 Width 4ft   5998311.99153 2106260.3659 37.7632922630546 -122.44901339496799 (37.7632922630546, -122.449013394968)
150414 199358 2 36 1144 Rhode Island St 1 4 1 1     11 Width 3ft   6011907.7918 2103052.2048299997 37.755251549640704 -122.401764195454 (37.7552515496407, -122.401764195454)
150368 199376 2 36 200 Jennings St 13 4 1 1     20 Width 3ft   6018454.3293699995 2096728.7492099998 37.7382517755872 -122.378685014295 (37.7382517755872, -122.378685014295)
150366 246155 2 36 1644 Waller St 1 1 1 1     17 Width 0ft   5997687.6425 2108190.0819 37.768555044956 -122.45131198438801 (37.768555044956, -122.451311984388)
150144 224030 2 36 56 Alma St 2 1 1 1     20 Width 4ft   5998290.39945 2106258.63265 37.7632862690788 -122.44908794966899 (37.7632862690788, -122.449087949669)
149297 248615 2 36 446 Frederick St 1 1 1 1     21 Width 0ft   5997626.0167 2107489.4868 37.7666278609206 -122.451474603078 (37.7666278609206, -122.451474603078)
149237 206281 2 36 201 Elk St 3 9 1 1     22 Width 2ft   6000794.7331 2095912.2311 37.735020444925205 -122.439684508859 (37.7350204449252, -122.439684508859)
149232 244110 2 36 1890 Page St 2 1 1 1     18 Width 0ft   5997524.2657 2108863.6995 37.7703952699374 -122.451925692038 (37.7703952699374, -122.451925692038)
148918 62209 1 36 227 24th Ave 1 1 1 1 1 10/12/1985 12:00:00 AM 16   Permit Number 22331 5988338.57879 2114482.10714 37.7852914335725 -122.48411069019699 (37.7852914335725, -122.484110690197)
148887 199373 2 36 200 Jennings St 1 4 1 1     13 Width 3ft   6018659.73844 2097012.77983 37.739042989241 -122.37799451303002 (37.739042989241, -122.37799451303)
146659 201400 2 36 1051 Ingalls St 12 4 1 1     11 Width 3ft   6018104.40497 2094706.8923400003 37.732680858616796 -122.379754459312 (37.7326808586168, -122.379754459312)
146356 199366 3 36 300x Division St 5 3 1 2     28 Width 9ft   6009946.07759 2108167.65587 37.769187748042704 -122.40890931543801 (37.7691877480427, -122.408909315438)
146328 36834 1 36 2715 Ingalls St 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
146271 6125 3 36 199X Elk St 9 1 1 2     18 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
146060 106499 1 36 420X Shrader St 2 1 1 1           5997462.73555 2109001.92463 37.770771276139705 -122.452148498658 (37.7707712761397, -122.452148498658)
145856 6120 3 36 199X Elk St 4 1 1 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
144172 117163 2 36 832 SHRADER ST 1 1 1 1       3x3   5997697.0 2107652.0 37.767078145258004 -122.45124080685899 (37.767078145258, -122.451240806859)
144147 11973 3 36 1020X Mendell St 3 1 1 2     12 3X3   6015669.55392 2096331.84807 37.7370080523218 -122.388285783946 (37.7370080523218, -122.388285783946)
143972 5244 3 36 1780X Turk St 5 1 1 2     30 4X4   6001669.86946 2112366.9914599997 37.78025100635529 -122.437837026039 (37.7802510063553, -122.437837026039)
143797 3737 3 36 401X Cargo Way 42 1 1 2     18 3X3   6017167.798756 2098792.720184 37.743848015002605 -122.383276872883 (37.7438480150026, -122.383276872883)
143617 16166 3 36 405 Monterey Blvd 1 1 1 2     18 3X3   5999388.049433099 2094640.7964516003 37.7314492181413 -122.44445655139799 (37.7314492181413, -122.444456551398)
143272 3741 3 36 401X Cargo Way 46 1 1 2     18 3X3   6017167.798756 2098792.720184 37.743848015002605 -122.383276872883 (37.7438480150026, -122.383276872883)
143072 97216 3 36 300X Claremont Blvd 3 16 1 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
142623 101243 2 36 1299X 08th Ave 1 1 1 1       3x3   5993606.4 2106666.6 37.7641374320151 -122.465317867129 (37.7641374320151, -122.465317867129)
142506 10660 3 36 957 Hayes St 3 1 1 2     18 3X3   6003300.92525 2110638.18324 37.7755967412885 -122.432070966007 (37.7755967412885, -122.432070966007)
141336 5243 3 36 1780X Turk St 4 1 1 2     30 4X4   6001669.86946 2112366.9914599997 37.78025100635529 -122.437837026039 (37.7802510063553, -122.437837026039)
141205 58522 1 36 1525 Waller St 1 1 1 1   04/02/1979 12:00:00 AM   4x4 Permit Number 17699 5998383.76026587 2108237.92603054 37.768726247134204 -122.448907628846 (37.7687262471342, -122.448907628846)
141075 17993 3 36 2650X Pine St 1 1 1 2     24 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
140716 99699 6 36 1750 Divisadero St 2 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
140492 11523 3 36 101X Jennings St 13 1 1 2     18 3X3   6018517.10401 2096771.58701 37.7383728601739 -122.378470941616 (37.7383728601739, -122.378470941616)
140472 17811 3 36 1900X Pine St 4 1 1 2     24 3X3   6004830.0574482 2115432.8862429 37.7888483829176 -122.427122914168 (37.7888483829176, -122.427122914168)
140133 12381 3 36 1435 Laguna St 2 1 1 2     18 3x3   6004345.46385 2113763.0093400003 37.7842359045501 -122.42868045552099 (37.7842359045501, -122.428680455521)
139546 17753 1 36 1634 Pine St 3 1 1 1     18 3X3   6006028.796019999 2115599.444 37.7893734236606 -122.422987282423 (37.7893734236606, -122.422987282423)
139042 108739 2 36 22 22ND AVE 4 1 1 1       5x6   5989006.7 2115022.6 37.786814349999105 -122.48183882646299 (37.7868143499991, -122.481838826463)
138869 11509 3 36 100 Jennings St 23 1 1 2     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
138565 6127 3 36 199X Elk St 11 1 1 2     18 3X3   6000782.74757 2096053.9984099998 37.735409022713704 -122.439736107551 (37.7354090227137, -122.439736107551)
137668 200250 2 36 917 Ingerson Ave 1 19 1 1     5 Width 0ft   6014641.601 2089467.7692 37.7181036570096 -122.391360208379 (37.7181036570096, -122.391360208379)
137315 199380 2 36 200 Jennings St 18 4 1 1     15 Width 3ft   6018370.09073 2096624.46593 37.7379607900541 -122.37896903279301 (37.7379607900541, -122.378969032793)
137222 206278 2 36 121 Ortega St 1 2 1 1     23 Width 2ft   5993596.441240001 2102535.31336 37.7527934164816 -122.46505223798701 (37.7527934164816, -122.465052237987)
136960 224446 2 36 40 Fillmore St 1 1 1 1     17 Width 3ft   6003874.09282 2108583.13838 37.7699865699439 -122.42994161713001 (37.7699865699439, -122.42994161713)
136677 224431 2 36 111 Surrey St 1 1 1 1     20 Width 3ft   6002252.13649 2096208.5785299998 37.7359169916712 -122.434666937538 (37.7359169916712, -122.434666937538)
136459 123281 2 36 400 06th Ave 12 1 1 1     19 Width 3ft   5994069.81611 2112666.40035 37.7806380059293 -122.464150649226 (37.7806380059293, -122.464150649226)
136355 199367 2 36 1500 Michigan St 1 4 1 1     14 Width 3ft   6016510.76764 2101132.40556 37.7502359775117 -122.385711790678 (37.7502359775117, -122.385711790678)
136016 199382 2 36 200 Jennings St 20 4 1 1     15 Width 4ft   6018339.04048 2096582.3620200001 37.7378434689969 -122.37907346658501 (37.7378434689969, -122.379073466585)
135881 206280 2 36 201 Elk St 2 1 1 1     20 Width 3ft   6000785.269280001 2095899.66212 37.7349853947672 -122.43971632775299 (37.7349853947672, -122.439716327753)
135072 224028 2 36 1420 Shrader St 1 1 1 1     13 Width 4ft   5997836.6848 2105808.46526 37.7620242630195 -122.450624734548 (37.7620242630195, -122.450624734548)
135013 199393 2 36 1199 Ingalls St 2 1 1 1     12 Width 3ft   6018101.32261 2094012.4303700002 37.730773831851 -122.37971688473999 (37.730773831851, -122.37971688474)
134942 123506 2 36 2630 Fulton St 1 1 1 1     19 Width 8ft   5995210.5755199995 2110304.28467 37.774217945514 -122.460033072871 (37.774217945514, -122.460033072871)
134530 218787 2 36 230 Edna St 7 17 1 1     14     5998781.19291 2095377.439 37.733437219949 -122.44660754120702 (37.733437219949, -122.446607541207)
134377 224017 2 36 1000 San Jose Ave 91 7 1 1     28     6004994.74234 2096924.0742900001 37.7380369005842 -122.425235549407 (37.7380369005842, -122.425235549407)
133793 206299 2 36 231 Edna St 1 17 1 1     21     5998763.35609 2095379.2875599999 37.733441276780205 -122.446669340837 (37.7334412767802, -122.446669340837)
133709 176392 2 36 1669 Geneva Ave 2 2 1 1     20 Width 8ft   6003793.19406 2087522.42519 37.712154106300396 -122.428719874622 (37.7121541063004, -122.428719874622)
133301 218784 2 36 230 Edna St 4 17 1 1     6     5998790.64503 2095351.5410200001 37.733366650131295 -122.446573000066 (37.7333666501313, -122.446573000066)
133143 102290 1 36 801 Cesar Chavez St 2 1 1 1     12 3x3   6016394.11438 2101141.39793 37.7502542130621 -122.386115815616 (37.7502542130621, -122.386115815616)
133083 250094 2 36 1700 Gough St 8 4 1 1     16 Width 4ft   6005324.767440001 2115623.21527 37.789398941767004 -122.425424835102 (37.789398941767, -122.425424835102)
132884 102293 1 36 801 Cesar Chavez St 5 1 1 1     12 3x3   6016486.61621 2101147.40436 37.7502758246674 -122.385796353939 (37.7502758246674, -122.385796353939)
132825 199368 2 36 1500 Michigan St 3 4 1 1     12 Width 3ft   6016513.5001 2101084.14011 37.7501036018027 -122.38569897801901 (37.7501036018027, -122.385698978019)
132361 206283 2 36 201 Elk St 5 9 1 1     16 Width 2ft   6000785.48714 2095941.8805200001 37.7351013290572 -122.439718600327 (37.7351013290572, -122.439718600327)
132302 137684 2 36 733 BAKER ST 1 1 1 1     25 Width 0ft   6000491.3923 2111526.0041 37.7778747868229 -122.441853533294 (37.7778747868229, -122.441853533294)
131752 199391 2 36 1201 Ingalls St 7 1 1 1     20 Width 3ft   6018044.87708 2093963.65233 37.7306367832528 -122.379908639985 (37.7306367832528, -122.379908639985)
131355 247086 2 36 2301 Castro St 4 7 1 1     21     6002759.04691 2098591.69247 37.7424892371899 -122.43308456422501 (37.7424892371899, -122.433084564225)
131150 248583 2 36 832 Shrader St 1 1 1 1     15 Width 0ft   5997671.8953 2107653.4687 37.7670807404856 -122.45132774569099 (37.7670807404856, -122.451327745691)
130217 250108 2 36 1688 Pine St 4 4 1 1     20 Width 4ft   6005895.20899 2115581.5118400003 37.7893166475034 -122.423448203486 (37.7893166475034, -122.423448203486)
129895 138989 2 36 999 Hayes St 1 1 1 1     18 Width 0ft   6003118.0992 2110635.6071 37.7755793009505 -122.432703221339 (37.7755793009505, -122.432703221339)
129818 206264 2 36 1235 Arguello Blvd 1 1 1 1     25 Width 4ft   5995769.52537 2107097.9044 37.7654461924254 -122.45786750379101 (37.7654461924254, -122.457867503791)
129571 206277 2 36 100 Yerba Buena Ave 1 2 1 1     15 Width 6ft   5994075.53376 2096720.2997299999 37.73685446745821 -122.46297360255801 (37.7368544674582, -122.462973602558)
129383 4430 3 36 1195 Church St 1 1 1 2     18 3X3   6004484.1301445 2101944.4411304 37.751792813836104 -122.427358521283 (37.7517928138361, -122.427358521283)
129014 11507 3 36 100 Jennings St 21 1 1 2     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
128599 11231 3 36 1050X Ingalls St 17 1 1 2   04/02/1990 12:00:00 AM 50 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
128360 106364 6 36 155 BORICA ST 1 7 1 1           5992696.0 2092292.5 37.724617268406604 -122.467421338179 (37.7246172684066, -122.467421338179)
128144 50377 1 36 1620 Montgomery St 1 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
128009 109203 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
127665 20126 3 36 999X Hayes St 1 1 1 2     18 3X4   6003226.6736 2110648.3783 37.7756205244718 -122.432328548686 (37.7756205244718, -122.432328548686)
127278 206267 2 36 576 Dewey Blvd 1 1 1 1     16 Width 6ft   5994070.0708800005 2099419.58791 37.7442657237995 -122.46318829319901 (37.7442657237995, -122.463188293199)
126552 11503 3 36 100 Jennings St 17 1 1 2     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
125997 34460 1 36 1960 Jones St 2 1 1 1 1 12/21/2015 12:00:00 AM   3x3 Permit Number 38200 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
125797 109198 2 36 2401x CASTRO ST 2 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
125442 3740 3 36 401X Cargo Way 45 1 1 2     18 3X3   6017167.798756 2098792.720184 37.743848015002605 -122.383276872883 (37.7438480150026, -122.383276872883)
124892 11481 3 36 10X Jennings St 7 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
124644 11327 3 36 1223 Ingalls St 5 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017540.6929483 2093936.3628531997 37.730534025837706 -122.38164980170299 (37.7305340258377, -122.381649801703)
124370 116999 6 36 880x MCALLISTER ST 2 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
124037 10826 3 36 1139X Hudson Ave 33 1 1 2   03/29/1990 12:00:00 AM 12 3X4   6017834.53501 2094620.0550099998 37.732427530713004 -122.380681442077 (37.732427530713, -122.380681442077)
124008 106918 2 36 274 PUTNAM ST 1 1 1 1           6009044.8 2096077.1 37.7359392652864 -122.41117262558201 (37.7359392652864, -122.411172625582)
124001 99698 6 36 1750 Divisadero St 1 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
123678 97297 1 36 450 06th Ave 1 1 1 1           5994062.8 2112448.2 37.7800384821655 -122.46415907596202 (37.7800384821655, -122.464159075962)
123575 11966 3 36 1009X Mendell St 4 1 1 2     12 3x3   6015728.77645 2096327.58352 37.736999624078 -122.38808072579599 (37.736999624078, -122.388080725796)
123401 109201 2 36 2401x CASTRO ST 4 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123260 109205 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123251 92054 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123191 11510 3 36 100 Jennings St 24 1 1 2     12 3x3   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
123070 11559 3 36 830X Mendell St 5 1 1 2     12 3X3   6015912.14045 2096650.33898 37.737896002535294 -122.387469258127 (37.7378960025353, -122.387469258127)
123002 48545 1 36 501X Mariposa St 3 1 1 1   08/22/2002 12:00:00 AM   3x3 Permit Number 45866 6013823.0 2112518.0 37.7813492145506 -122.39580402612101 (37.7813492145506, -122.395804026121)
122748 111320 2 36 200x PENINSULA AVE 3 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
122202 11556 3 36 830X Mendell St 2 1 1 2   06/07/1996 12:00:00 AM 18 3X3   6015938.87476 2096683.24967 37.737987849284394 -122.387379118862 (37.7379878492844, -122.387379118862)
121890 11558 3 36 830X Mendell St 4 1 1 2     12 3X3   6015923.7081699995 2096663.9429799998 37.7379339970425 -122.387430211254 (37.7379339970425, -122.387430211254)
121637 110196 2 36 60x ASHBURY ST 1 1 1 1       3x3   5998800.0 2110445.0 37.7748101047276 -122.44762679098999 (37.7748101047276, -122.44762679099)
Powered by Datasette · Query took 3.863ms · Data source: data.sfgov.org