sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
78878 2044 3 143 700X Bosworth St 1 8 1 2     36   Permit Number 772999 6002154.6210393 2095431.8532492002 37.733778746199796 -122.43494855504801 (37.7337787461998, -122.434948555048)
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)
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)
56651 31242 1 155 2523 17th Ave 1 8 1 1   02/08/2008 12:00:00 AM 5 3x3 Permit Number 50225 5991071.12499 2098214.14208 37.7407826611875 -122.473469993967 (37.7407826611875, -122.473469993967)
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)
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)
102290 31648 1 17 4500 Ulloa St 3 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)
82032 39247 6 96 3524 Jackson St 1 8 1 1   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.790205252620794 -122.452921449726 (37.7902052526208, -122.452921449726)
86072 54809 1 12 150 Carmel St 2 8 1 1   03/12/2007 12:00:00 AM 5 3x3 Permit Number 773425 5998092.51354995 2105385.25255364 37.760876867329294 -122.449709427273 (37.7608768673293, -122.449709427273)
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)
11497 69940 1 49 1295 30th Ave 1 8 1 1   05/06/2016 12:00:00 AM 3 5x5 Permit Number 778203 5986757.5345 2106473.3538 37.7632094781069 -122.488991584645 (37.7632094781069, -122.488991584645)
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)
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)
46828 84740 1 7 143 Alhambra St 1 8 1 1   03/27/2007 12:00:00 AM 13 4x6 Permit Number 49254 6001588.49283 2120281.76365 37.8019782934262 -122.438685839601 (37.8019782934262, -122.438685839601)
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)
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)
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)
97229 85428 6 17 43 Ora Way 1 8 1 1   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.741605021987205 -122.437232403771 (37.7416050219872, -122.437232403771)
80037 86731 1 100 2 Pico Ave   8 1 1         Permit Number 49705 5994102.9 2092171.9 37.724367252780496 -122.462549157922 (37.7243672527805, -122.462549157922)
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)
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)
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)
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)
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)
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)
5622 87285 1 36 1820 Webster St 1 8 1 1     24 3x3 Permit Number 50302 6003460.507999999 2115059.4384 37.7877454479518 -122.43183468665801 (37.7877454479518, -122.431834686658)
80436 87674 1 40 770 Golden Gate Ave 10 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)
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)
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)
80984 88447 1 17 93 Prentiss St 1 8 1 1   07/14/2008 12:00:00 AM   3x3 Permit Number 51413 6008891.7 2098141.7 37.7415996198956 -122.411847801096 (37.7415996198956, -122.411847801096)
91613 88453 6 1 2801 Oakdale Ave 2 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
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)
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)
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)
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)
81053 88569 6 17 1335 Webster St 60 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)
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)
93053 88571 6 17 1335 Webster St 62 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)
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)
81076 88608 6 17 350 Urbano Dr 1 8 1 1   08/01/2008 12:00:00 AM     Permit Number 51562 5991996.0 2092560.0 37.72531132011171 -122.46986059313801 (37.7253113201117, -122.469860593138)
89222 89359 1 35 308 Tocoloma Ave 3 8 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50704 6012556.9 2087009.2 37.7112369933076 -122.39839375585301 (37.7112369933076, -122.398393755853)
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)
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)
95257 93959 1 84 419 Elizabeth St   8 1 1       3x3 Permit Number 53399 6003681.0 2102149.0 37.752309029626495 -122.430150445418 (37.7523090296265, -122.430150445418)
79626 94583 1 17 90 Joost Ave 1 8 1 1       3x3   6001518.0 2094975.2 37.732488714298 -122.43711685564699 (37.732488714298, -122.437116855647)
25407 95032   17 211 Maynard St   8 2 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
79071 95369   17 27 Hartford St   8 2 1   02/18/2011 12:00:00 AM       6002651.0 2105744.0 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968)
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)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
95902 96835 6 60 6001 Geary Blvd 1 8 1 1           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894)
85808 98327 1 176 143 Alhambra St 2 8 1 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49254 6001613.1 2120268.4 37.8019430002039 -122.43859972925199 (37.8019430002039, -122.438599729252)
89776 98528 1 136 428 11th St 1 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)
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)
129310 99268 7 17 292 Whitney St   8 1 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
124001 99698 6 36 1750 Divisadero St 1 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
140716 99699 6 36 1750 Divisadero St 2 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
92947 99830 6 198 2398@Steiner Broadway 1 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
139221 99831 6 198 2398@Steiner Broadway 2 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
98327 99832 6 198 2398@Steiner Broadway 3 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
94216 100680 2 1 387 Beacon St   8 1 1         7' wide public RoW 6002378.0 2098199.0 37.7413893731095 -122.434374040118 (37.7413893731095, -122.434374040118)
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)
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)
80785 104444 6 183 507 Capp St 1 8 1 1       2x6 Permit Number 770679 6007300.0 2104257.5 37.7583027968034 -122.41778477647301 (37.7583027968034, -122.417784776473)
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)
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)
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)
56265 104652 6 94 953 Indiana St 1 8 1 1           6015057.1 2104275.7 37.758786250670205 -122.39095836980302 (37.7587862506702, -122.390958369803)
105054 104686 2 22 140 26TH AVE   8 1 1     22 4x4   5987812.9 2115041.6 37.786797021543 -122.485970438221 (37.786797021543, -122.485970438221)
85444 104728 6 17 3212 Jackson St 1 8 1 1   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492)
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)
123166 105073 6 1 101 LUNDYS LN 1 8 1 1     18     6006875.0 2098969.0 37.7437578546964 -122.41887954343599 (37.7437578546964, -122.418879543436)
13821 105161 6 18 1600X Oakdale Ave 2 8 1 19     13 3x3   6014869.34112 2095641.8363700002 37.735069048787 -122.39100428831499 (37.735069048787, -122.391004288315)
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)
42991 105168 6 60 4755X 03RD ST 2 8 1 19     23 3x3 Permit Number 770204 6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
83931 105169 7 60 4755X 03RD ST 3 8 1 19     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
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)
29261 105753 6 15 3636 Buchanan St 1 8 1 1   02/21/2014 12:00:00 AM 13   Permit Number 771077 6003146.89414 2120799.57812 37.803488607670296 -122.433330062032 (37.8034886076703, -122.433330062032)
78703 105804 1 68 117 ALPINE TER 1 8 1 1   04/10/2014 12:00:00 AM 14 3x3 Permit Number 772090 6001724.2 2108149.5 37.7686739192463 -122.437346990121 (37.7686739192463, -122.437346990121)
91973 106184 6 41 1327 ULLOA ST 1 8 1 1 1   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077)
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)
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)
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)
86948 106872 6 26 38 08th St 3 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)
54137 106873 6 26 38 08th St 4 8 1 1         Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
85042 106874 6 26 38 08th St 5 8 1 1         Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
86498 107113 6 115 2100 MARKET ST   8 1 1           6004034.0 2107672.1 37.767494134010896 -122.429323526179 (37.7674941340109, -122.429323526179)
88934 107130 7 65 751 DOLORES ST 1 8 1 1           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507)
79650 107185 6 21 10 Florence St 1 8 1 1         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272)
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)
115370 107863 1 61 218 HOWTH ST 1 8 1 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
66196 107892 1 88 162 Brewster St   8 1 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.40727852777799 (37.7440766668365, -122.407278527778)
99196 108002 6 75 461X Ivy St 1 8 1 1           6005199.36333 2111122.83043 37.777034912059605 -122.425538300101 (37.7770349120596, -122.425538300101)
144227 108021 6 75 455X Ivy St 1 8 1 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
86717 108022 6 145 455X Ivy St 2 8 1 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
68819 108096 6 188 3370 Washington St 1 8 1 1     17   Permit Number 773610 5998674.83986 2115933.37372 37.789872594881295 -122.44845507873801 (37.7898725948813, -122.448455078738)
83219 108097 6 17 3370 Washington St 2 8 1 1           5998663.3699 2115944.3199400003 37.789901994506 -122.44849555223101 (37.789901994506, -122.448495552231)
85675 108214 2 1 1611 47th Ave 1 8 1 1     15 3x3   5981530.432709999 2104091.45519 37.756363002508294 -122.50689338520701 (37.7563630025083, -122.506893385207)
85532 108239 1 17 15 ASHBURY TER 1 8 1 1   01/14/2015 12:00:00 AM 3 5x50 Permit Number 774721 5999554.7 2106911.6 37.7651513833487 -122.444762103204 (37.7651513833487, -122.444762103204)
98792 108275 6 238 1800x ALAMEDA ST 5 8 1 1     15     6011533.0 2107928.0 37.7686184708296 -122.40340334412501 (37.7686184708296, -122.403403344125)
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)
Powered by Datasette · Query took 3.47ms · Data source: data.sfgov.org