sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1389 251532 1 54 2100X 20th St 4 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 1 54 2100X 20th St 2 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
10638 96234 1 17     1 2 1   04/15/2011 12:00:00 AM     Permit Number 767856          
11641 96232 1 17     1 2 1                    
16044 96231 1 17     1 2 1                    
101229 85273 1 17 36 Santa Cruz Ave   5 2 1           5993017.1 2086630.8 37.709090137513 -122.465900153218 (37.709090137513, -122.465900153218)
97877 121418 5 226 521 Lakeview Ave 1 5 2 1       3x3   5996348.0 2089857.0 37.718140121256106 -122.45462104638399 (37.7181401212561, -122.454621046384)
101905 97139 2 19 937 Goettingen St   25 2 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
98180 120995 7 64 231 Delano Ave 1 7 2 1       3x3   6000066.0 2092260.0 37.72495076112679 -122.44194193563999 (37.7249507611268, -122.44194193564)
111918 109831 1 54 146 Staples Ave 1 5 2 1       12x15.3   5999109.5 2093827.3 37.7291996500545 -122.445361075989 (37.7291996500545, -122.445361075989)
25407 95032   17 211 Maynard St   8 2 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
46600 116804 3 19 131 LAKESHORE DR 1 3 2 2       10x100   5984782.0 2094243.0 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174)
107476 82512 1 12 52 Tulane St 1 1 2 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52482 6007264.0 2093867.0 37.7297707824944 -122.41717301728399 (37.7297707824944, -122.417173017284)
120169 104564 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
138621 104565 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
100486 103619 2 17 1200 Monterey Blvd 1 7 2 1           5994284.3 2094292.0 37.7301989768893 -122.46207576474701 (37.7301989768893, -122.462075764747)
128027 82995 1 12 1412 Quesada Ave 1 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52364 6016260.71862294 2093905.81391215 37.730379387125204 -122.38607277339099 (37.7303793871252, -122.386072773391)
110920 85195 1 17 333 Eucalyptus Dr   5 2 1           5990168.0 2094689.0 37.731051182582604 -122.47633519175501 (37.7310511825826, -122.476335191755)
92510 88654 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
120372 88656 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
119565 99732 2 98 4150 Ocean Ave 1 5 2 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
101718 109770 1 192 9 Pomona St 1 1 2 1   12/29/2015 12:00:00 AM   6x7 Permit Number 774437 6014227.8 2094671.9 37.7323701819213 -122.393154495945 (37.7323701819213, -122.393154495945)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
118241 4313 3 98 727 Chenery St 1 1 2 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
129188 105003 2 98 607 CONGO ST   9 2 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
145744 109499 1 7 99 Surrey St 1 1 2 1 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 774984 6002392.9 2096233.9 37.7359945088656 -122.43418207236999 (37.7359945088656, -122.43418207237)
110838 107348 5 64 260 LANSDALE AVE 1 13 2 1           5995019.0 2096651.7 37.7367204092857 -122.459706678853 (37.7367204092857, -122.459706678853)
94709 117610 2 98 391 NEVADA ST 1 14 2 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
79103 120636 5 64 385 Nevada St 1 5 2 1       3x3   6008960.0 2096519.0 37.7371478708762 -122.411497024701 (37.7371478708762, -122.411497024701)
92261 117511 3 98 2634 37TH AVE 1 3 2 2     20 3x3   5984921.0 2097163.0 37.737538439530795 -122.49465702329901 (37.7375384395308, -122.494657023299)
13970 17450 3 284 1967 Palou Ave 4 1 2 2     42 3X3   6012966.10245 2096645.10936 37.7377180333685 -122.397654855789 (37.7377180333685, -122.397654855789)
82393 108910 1 7 129 Ellert St 1 1 2 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773054 6007361.2 2097016.9 37.7384251864379 -122.417060086005 (37.7384251864379, -122.417060086005)
117306 104857 1 54 2555 46th Ave   1 2 1           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
125761 108576 7 54 2479 Diamond St 1 7 2 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
97106 102276 5 17 279 Topaz Way   13 2 1           6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733)
114741 104860 1 54 283 Randall St   1 2 1           6003774.7 2097827.3 37.7404479510811 -122.429518236565 (37.7404479510811, -122.429518236565)
114314 108701 1 12 478 30th St   1 2 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.3309400002 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961)
105459 96289 1 17 228 30th St   1 2 1         Permit Number 767877 6005120.0 2098458.0 37.7422557889482 -122.42491157296699 (37.7422557889482, -122.424911572967)
50491 107717 2 17 2400X 25th Ave 3 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
97433 107716 2 17 2400X 25th Ave 2 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
1800 251700 1 54 1560 Sanchez St 1 1 2 1   06/05/2017 12:00:00 AM 3 410x11 Permit Number 780193 6003924.0 2099150.0 37.7440882334859 -122.429096301435 (37.7440882334859, -122.429096301435)
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 1 54 450 Toland St 4 1 2 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 1 54 450 Toland St 5 1 2 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 1 54 450 Toland St 3 1 2 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 1 54 450 Toland St 1 1 2 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 1 54 450 Toland St 2 1 2 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
80680 117478 2 64 400 PERALTA AVE 1 7 2 1       3x3   6009762.0 2099359.0 37.7449908466617 -122.40892445167499 (37.7449908466617, -122.408924451675)
118218 104635 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
141674 104634 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
84066 83339 1 51 2233 28th Ave 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52332 5987590.2167451 2100087.03718588 37.7457229434205 -122.485642930331 (37.7457229434205, -122.485642930331)
94853 104637 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
111744 104636 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
52224 227520 2 284 16 Tiffany Ave 1 4 2 1     4 Width 2ft   6006374.41145 2099856.22866 37.746165784439896 -122.420673433456 (37.7461657844399, -122.420673433456)
81298 104856 1 54 739 27th St   1 2 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
114798 105147 1 18 52 Mirabel Ave   1 2 1   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.41622057503099 (37.7464458666696, -122.416220575031)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
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)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
127072 99201 1 17 4016 26th St   1 2 2 1 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855)
115664 85184 1 49 501 Bartlett St   5 2 1   12/13/2006 12:00:00 AM   3x25 Permit Number 768657 6006822.0 2100867.0 37.748966349809606 -122.419197411761 (37.7489663498096, -122.419197411761)
96749 93115 1 75 397 San Jose Ave 1 21 2 1   02/02/2009 12:00:00 AM   26x6 Permit Number 53167 6006259.6 2100887.6 37.7489912240508 -122.42114365927 (37.7489912240508, -122.42114365927)
128347 104667 1 18 172 Clipper St 1 1 2 1 1 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467)
91444 107078 2 17 92 Homestead St   5 2 1   07/25/2014 12:00:00 AM   3x3.5 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227)
112497 104858 1 54 4205 24th St   5 2 1           6001816.0 2101720.7 37.7510272133613 -122.43656924920201 (37.7510272133613, -122.436569249202)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
139298 92611 1 98 3856 23rd St   6 2 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
87925 104864 1 54 45 Hoffman Ave   1 2 1           6000629.3 2102650.0 37.7535113392088 -122.440739618385 (37.7535113392088, -122.440739618385)
443 251293 2 54 3789 Market St 1 5 2 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
86139 89139 1 17 3170 23rd St   5 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
111084 89138 1 17 3170 23rd St   1 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
117077 89137 1 17 3170 23rd St   1 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
125875 89140 1 17 3170 23rd St   5 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
1361 16698 3 26 950X Noriega St 2 11 2 2     12 8   5991017.9677099995 2103156.31666 37.7543495107367 -122.47401428523999 (37.7543495107367, -122.47401428524)
85310 105043 1 54 2660 Harrison St 5 5 2 1       2x4   6008902.0 2102968.0 37.754852144595795 -122.41215320319701 (37.7548521445958, -122.412153203197)
85839 105039 1 54 2660 Harrison St 1 5 2 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
106819 105042 1 54 2660 Harrison St 4 5 2 1       2x10   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
122806 105040 1 54 2660 Harrison St 2 5 2 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
140829 105041 1 54 2660 Harrison St 3 5 2 1       2x2   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
96541 110246 1 54 1706 28th Ave 1 1 2 1   04/01/2015 12:00:00 AM 3 1.5x12   5987540.7 2103643.4 37.755484875136204 -122.486075162345 (37.7554848751362, -122.486075162345)
79393 106516 1 17 366 Hill St   1 2 1   05/07/2014 12:00:00 AM   3X3 Permit Number 772751 6003996.2 2103381.7 37.755711581068795 -122.42914832014 (37.7557115810688, -122.42914832014)
2270 253008 1 54 1201 Tennessee St 1 1 2 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
127755 83007 1 457 1058 De Haro St 1 11 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
123231 88829 1 98 4437 20th St   1 2 1   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
143838 89015 1 98 4437 20th St   1 2 1   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
100274 99610 2 17 111 Corwin St   14 2 1           6000616.0 2104331.0 37.7581261988062 -122.44090619353999 (37.7581261988062, -122.44090619354)
79753 107409 2 98 125 VILLA TER 1 1 2 1           5999028.2 2104385.8 37.758186107000796 -122.44640141076401 (37.7581861070008, -122.446401410764)
3170 208471 1 141 1175 Kirkham St 1 1 2 1   08/23/2017 12:00:00 AM 3 Width 2ft Permit Number 780657 5991201.16474 2105172.16858 37.7598951180952 -122.473527781682 (37.7598951180952, -122.473527781682)
103907 106639 5 64 1321X CLAYTON ST 1 13 2 1           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167)
Powered by Datasette · Query took 2.418ms · Data source: data.sfgov.org