sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
181559 106870 6 26 38 08th St 1 8 1 1   07/31/2014 12:00:00 AM 2   Permit Number 769156 6008504.136630001 2111439.18954 37.778089733190605 -122.414128411309 (37.7780897331906, -122.414128411309)
154324 112045 6 5 2418 Pacific Ave 1 8 1 1     18 3x3   6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226)
148125 79257 1 12 571 35th Ave 1 8 1 1   12/06/2007 12:00:00 AM 11 3x3 Permit Number 49957 5985010.61242 2111991.22713 37.7782578784089 -122.495440495889 (37.7782578784089, -122.495440495889)
144956 104445 6 183 507 Capp St 2 8 1 1       2x6 Permit Number 770679 6007300.0 2104257.5 37.7583027968034 -122.41778477647301 (37.7583027968034, -122.417784776473)
144669 114930 2 3 4400x OCEAN AVE 6 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
144227 108021 6 75 455X Ivy St 1 8 1 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
143622 87071 1 88 395 Byxbee St 2 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
143274 122379 4 88 466 Vernon St 1 8 1 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
142954 110788 8 17 850x SANCHEZ ST 2 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
142683 116623 2 41 5732X GEARY BLVD 4 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
142320 82180 5 88 105 Lake St 1 8 1 1 1     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.78679106496129 -122.46047184952101 (37.7867910649613, -122.460471849521)
142230 120534 1 12 2043 32nd Ave 1 8 1 1   08/10/2016 12:00:00 AM 3 3x3   5986293.0 2101328.0 37.7490546230695 -122.49021972232599 (37.7490546230695, -122.490219722326)
142217 108441 5 21 105 Lake St   8 1 1 1     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.786807513731105 -122.46047306430201 (37.7868075137311, -122.460473064302)
141973 114935 2 3 4400x OCEAN AVE 11 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141835 114936 2 3 4400x OCEAN AVE 12 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141088 115806 6 169 362 MISSOURI ST 1 8 1 1     12 3x3   6013446.0 2105415.0 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099)
140914 114321 1 12 2118 47th Ave 1 8 2 1   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145)
140796 114929 2 3 4400x OCEAN AVE 5 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
140716 99699 6 36 1750 Divisadero St 2 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
140608 92050 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
139674 117208 6 3 25 MIDCREST WAY 1 8 1 1     20     5997992.0 2100464.0 37.747358577228496 -122.44970241305 (37.7473585772285, -122.44970241305)
139591 87070 1 88 395 Byxbee St 1 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
139221 99831 6 198 2398@Steiner Broadway 2 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
139185 114938 2 3 4400x OCEAN AVE 14 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
139135 112417 2 5 98X BROADMOOR DR 1 8 1 1     28 3x3   5990934.0 2093194.0 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435)
138475 96182 1 17 330 South Van Ness Ave   8 2 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
134828 114679 1 235 836 Brussels St 1 8 1 1   12/01/2015 12:00:00 AM 1   Permit Number 774714 6011176.24092 2090873.36995 37.7217702116011 -122.403437363447 (37.7217702116011, -122.403437363447)
129431 110789 8 3 850x SANCHEZ ST 3 8 1 1       3x3   6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
129412 104753 2 5 2328 12TH AVE   8 1 1     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356)
129398 109973 2 17 1458 43rd Ave 1 8 1 1   03/16/2015 12:00:00 AM 3 3x3   5982831.2 2105195.6 37.7594711884194 -122.502476670215 (37.7594711884194, -122.502476670215)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
129263 63301 1 17 3261 Harrison St 1 8 1 1 1 01/26/1987 12:00:00 AM 18   Permit Number 53402 6009046.03746796 2099701.90725396 37.745892263304896 -122.411424351246 (37.7458922633049, -122.411424351246)
128374 104497 1 526 26 Allston Way 1 8 1 1   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352.0 37.741351881225704 -122.46206101169201 (37.7413518812257, -122.462061011692)
128304 115100 6 17 710 PACHECO ST 1 8 1 1   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727.0 2102215.0 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741)
127767 31647 1 17 4500 Ulloa St 4 8 1 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
127496 36443 1 17 1260 Plymouth Ave 1 8 1 1   11/20/2009 12:00:00 AM   3x3 Permit Number 53041 5995883.45550893 2092448.59347632 37.725229366758 -122.456414062747 (37.725229366758, -122.456414062747)
125790 116627 2 41 5732X GEARY BLVD 8 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
125647 85060 6 47 7070 California St 1 8 1 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
125158 116956 6 143 380 SAN JOSE AVE 1 8 1 1     28 3x3   6006172.0 2100967.0 37.7492042995658 -122.421452219126 (37.7492042995658, -122.421452219126)
124433 114265 2 47 800x BROTHERHOOD WAY 6 8 1 1     26     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
124370 116999 6 36 880x MCALLISTER ST 2 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
124339 116630 2 41 5732X GEARY BLVD 11 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124233 114680 1 80 54 Colby St 1 8 1 1   12/01/2015 12:00:00 AM     Permit Number 774571 6007954.9 2093861.0 37.729793151999395 -122.414784067206 (37.7297931519994, -122.414784067206)
124228 111770 6 243 707 Douglass St   8 1 1       3x3 Permit Number 775627 6001281.0 2102187.2 37.7522776937422 -122.438452748375 (37.7522776937422, -122.438452748375)
124001 99698 6 36 1750 Divisadero St 1 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
123578 114260 2 71 800x BROTHERHOOD WAY 1 8 1 1     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
123257 116622 2 41 5732X GEARY BLVD 3 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
123053 113153 6 408 55 BRONTE ST   8 1 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
122091 114098 2 55 219x VIDAL DR 1 8 1 1     40     5987664.0 2090565.0 37.719582202213104 -122.48468943736401 (37.7195822022131, -122.484689437364)
121120 103719 6 49 748 Treat Ave 1 8 1 1     8 3x3   6008496.2 2104169.0 37.758127039951205 -122.41364151852801 (37.7581270399512, -122.413641518528)
119856 85365 6 1 66 Clarendon Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.758871479144396 -122.45053809231199 (37.7588714791444, -122.450538092312)
119427 12711 6 17 1449 Lake St 3 8 1 2   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046)
119287 85367 6 18 1990 09th Ave 1 8 1 1   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.46526605884199 (37.7513105791605, -122.465266058842)
119101 116621 2 41 5732X GEARY BLVD 2 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
118617 112451 6 129 1526 MASONIC AVE 1 8 1 1       3x6   5999767.0 2107205.0 37.7659690994291 -122.44404889486401 (37.7659690994291, -122.444048894864)
118464 98529 1 136 428 11th St 2 8 1 1   02/22/2012 12:00:00 AM   3x3 Permit Number 768342 6009030.0 2108561.0 37.7702164230423 -122.41210579217699 (37.7702164230423, -122.412105792177)
118309 114264 2 3 800x BROTHERHOOD WAY 5 8 1 1     32     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
117993 108442 1 77 750 12th Ave   8 1 1 1     3x3 Permit Number 773771 5992283.6285 2110333.09253 37.7741282667999 -122.470159914203 (37.7741282667999, -122.470159914203)
117969 105170 7 21 4755X 03RD ST 4 8 1 19     2 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
117945 104498 1 526 26 Allston Way 2 8 1 1   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352.0 37.741351881225704 -122.46206101169201 (37.7413518812257, -122.462061011692)
117877 112570 2 141 162 GRAND VIEW AVE 2 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
117224 117027 6 129 731 CLAYTON ST 1 8 1 1           5998515.0 2108057.0 37.768236974715705 -122.44844065135099 (37.7682369747157, -122.448440651351)
115370 107863 1 61 218 HOWTH ST 1 8 1 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
115344 88568 6 17 1335 Webster St 59 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
114585 115388 2 47 169x BOCANA ST 1 8 1 1     25 40x50   6007278.0 2097999.0 37.7411171346524 -122.417417333034 (37.7411171346524, -122.417417333034)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
113764 31646 1 17 4500 Ulloa St 2 8 1 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
113343 116624 2 41 5732X GEARY BLVD 5 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113089 87675 1 40 770 Golden Gate Ave 11 8 1 1   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.42334835915399 (37.7807698496384, -122.423348359154)
112187 88567 6 17 1335 Webster St 39 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
111937 87074 1 45 395 Byxbee St 5 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
111891 105167 7 60 4755X 03RD ST 1 8 1 19     8 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
111849 117150 8 49 928 TOLAND ST 5 8 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011950.0 2098029.0 37.7414612698949 -122.401265252936 (37.7414612698949, -122.401265252936)
111788 106871 6 26 38 08th St 2 8 1 1   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
111585 88455 6 1 2801 Oakdale Ave 4 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
110241 87072 1 82 395 Byxbee St 3 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
110088 114688 1 88 231 Dwight St 1 8 1 1   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.723279336417704 -122.404549596707 (37.7232793364177, -122.404549596707)
109202 88570 6 17 1335 Webster St 61 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
109200 101625 7 250 64 Levant St 1 8 1 1         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383)
108375 111357 6 3 600x MANSELL ST 1 8 1 2     48 3x3   6010142.0 2090267.0 37.720047423695505 -122.40696976451099 (37.7200474236955, -122.406969764511)
107044 107197 6 58 339 Kirkham St 1 8 1 1   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.5874099997 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
106143 87075 1 45 395 Byxbee St 6 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
106106 114937 2 3 4400x OCEAN AVE 13 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
105928 109708 6 17 621 Laguna Honda Blvd 3 8 1 1 1 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.745700269008296 -122.457505029341 (37.7457002690083, -122.457505029341)
105054 104686 2 22 140 26TH AVE   8 1 1     22 4x4   5987812.9 2115041.6 37.786797021543 -122.485970438221 (37.786797021543, -122.485970438221)
104759 87819 1 47 390 Lansdale Ave 1 8 1 1         Permit Number 50681 5995630.7 2096410.1 37.736092191921294 -122.457574304331 (37.7360921919213, -122.457574304331)
104404 106685 2 19 100 Yukon St   8 1 1         Permit Number 772768 6000197.4 2104288.0 37.757984281634 -122.44235080136299 (37.757984281634, -122.442350801363)
104222 88572 6 17 1335 Webster St 66 8 1 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
104090 87073 1 82 395 Byxbee St 4 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
103820 111068 6 163 1836 08TH AVE 1 8 1 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
103688 92051 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
103533 12529 5 88 105 Lake St 1 8 1 1 1 07/12/2004 12:00:00 AM 6 3x3 Permit Number 773769 5995136.95364 2114887.49287 37.78679797610221 -122.460619935074 (37.7867979761022, -122.460619935074)
103256 114928 2 3 4400x OCEAN AVE 4 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103199 114934 2 71 4400x OCEAN AVE 10 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103011 114923 2 3 51X EVERGLADE DR 1 8 1 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
102533 112571 2 141 162 GRAND VIEW AVE 3 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
102481 114925 2 71 4400x OCEAN AVE 3 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
Powered by Datasette · Query took 2.802ms · Data source: data.sfgov.org