sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
214 251244 1 15 99 Grove St 5 1 1 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
425 251299 4 15 2190X Market St 3 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
431 251298 4 15 2190X Market St 4 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 4 15 2190X Market St 5 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
446 251296 4 15 2190X Market St 2 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
476 174954 2 15 1400x Market St 1 1 1 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
975 251421 3 15 300X King St 6 1 1 2 3 09/30/2014 01:37:00 PM   3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
1665 251650 3 15 101X Vicente St 1 1 1 2       3x3            
1685 251478 1 15 2x Virginia Ave 2 1 1 1 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
2087 252878 3 15 300X King St 7 1 1 2 3     3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
2299 253020 2 15 760 Hayes St 1 1 1 1       3x3   6004216.0 2110862.0 37.7762631241711 -122.42892145951299 (37.7762631241711, -122.428921459513)
2733 253189 2 15 99x The Embarcadero 12 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2735 253188 2 15 99x The Embarcadero 11 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2737 253186 2 15 99x The Embarcadero 9 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2738 253184 2 15 99x The Embarcadero 7 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2739 253185 2 15 99x The Embarcadero 8 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2741 253190 2 15 99x The Embarcadero 13 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2744 253187 2 15 99x The Embarcadero 10 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2767 252950 2 15 261x Winding Way 2 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
2772 252949 2 15 261x Winding Way 1 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
3168 33093 1 15   9 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
4009 34002 1 15   1 1 1 1         Permit Number 37940          
4013 253610 2 15 1075 Mission St 16 1 1 1       Width 4ft   6009725.02676 2112060.52163 37.7798642637711 -122.40994876804 (37.7798642637711, -122.40994876804)
4171 39901 1 15   3 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
4620 253639 3 15 4405 California St 3 1 1 2 3     3x3   5993893.0 2114132.0 37.784651953064206 -122.46486880251801 (37.7846519530642, -122.464868802518)
4955 253734 3 15 350 Girard St 12 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4956 253729 3 15 350 Girard St 7 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4965 253732 3 15 350 Girard St 10 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4968 253724 3 15 350 Girard St 2 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4982 253733 3 15 350 Girard St 11 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4986 253726 3 15 350 Girard St 4 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4993 253727 3 15 350 Girard St 5 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5004 253731 3 15 350 Girard St 1 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5021 253725 3 15 350 Girard St 3 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5028 253730 3 15 350 Girard St 8 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5029 251680 3 15 350 Girard St 9 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5037 253728 3 15 350 Girard St 6 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5912 35691 1 15   1 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
6766 33092 1 15   8 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7580 33091 1 15   2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7627 33085 1 15   10 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7750 33087 1 15   6 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
8822 36564 1 15   1 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
9595 35817 1 15 980 Houston St 2 1 1 1   04/22/1998 12:00:00 AM     Permit Number 39055          
9687 173638 2 15 2590 Pacific Ave 1 1 1 1       3x3   6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
9689 173639 2 15 2590 Pacific Ave 2 1 1 1       3x3   6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
9725 173665 2 15 28 Ford St 2 1 1 1       3x3   6003201.0 2105688.0 37.7619990815164 -122.432063058995 (37.7619990815164, -122.432063058995)
9727 173664 2 15 28 Ford St 1 1 1 1       3x3   6003201.0 2105688.0 37.7619990815164 -122.432063058995 (37.7619990815164, -122.432063058995)
9954 173752 1 15 1291 05th Ave 2 1 1 1 1     3x3   5994529.13136199 2106735.38069373 37.7643794565111 -122.46213141846201 (37.7643794565111, -122.462131418462)
9992 173782 1 15 2002 Buchanan St 2 1 1 1   06/26/1995 12:00:00 AM   3x3 Permit Number 35358 6003922.0 2115390.0 37.7886792365293 -122.43026160514098 (37.7886792365293, -122.430261605141)
10008 173783 1 15 2002 Buchanan St 3 1 1 1   06/26/1995 12:00:00 AM   3x3 Permit Number 35358 6003922.0 2115390.0 37.7886792365293 -122.43026160514098 (37.7886792365293, -122.430261605141)
10014 173781 1 15 2002 Buchanan St 1 1 1 1   07/13/1995 12:00:00 AM   3x3 Permit Number 35405 6003922.0 2115390.0 37.7886792365293 -122.43026160514098 (37.7886792365293, -122.430261605141)
10082 173838 2 15 401X Spear St 4 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10083 173841 2 15 401X Spear St 7 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10084 173839 2 15 401X Spear St 5 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10085 173840 2 15 401X Spear St 6 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10087 173835 2 15 401X Spear St 1 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10088 173837 2 15 401X Spear St 3 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10091 173836 2 15 401X Spear St 2 1 1 1       3x3   6015881.0 2115288.0 37.789069279801204 -122.388877732103 (37.7890692798012, -122.388877732103)
10127 173869 2 15 619 Brussels St 1 1 1 1       3x3   6010937.0 2091855.0 37.72445219957 -122.40433341923901 (37.72445219957, -122.404333419239)
10191 35689 1 15   12 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
10366 46719 1 15   3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
10578 39903 1 15   1 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
10962 33089 1 15   4 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
11036 36559 1 15   8 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
11116 34003 1 15   2 1 1 1         Permit Number 37940          
12200 46197 1 15   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
12311 39902 1 15   2 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
12475 36562 1 15   3 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
12563 174952 1 15 399 Webster St 2 1 1 1       3x3   6004101.817542099 2110091.88469153 37.7741421130406 -122.429261520888 (37.7741421130406, -122.429261520888)
12686 35818 1 15 980 Houston St 3 1 1 1   04/22/1998 12:00:00 AM     Permit Number 39055          
13260 60572 1 15 1002 Clayton St 1 1 1 1   12/16/1982 12:00:00 AM     Permit Number 20185 5998848.38048099 2106535.44717902 37.7640782295423 -122.44717800789302 (37.7640782295423, -122.447178007893)
13380 36560 1 15   7 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
13386 46196 1 15   3 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
13646 50156 1 15 215 REVISED Fremont St 4 1 1 1   08/12/2003 12:00:00 AM     Permit Number 46870 6014159.85874387 2115328.34387959 37.789084506842705 -122.39483553069999 (37.7890845068427, -122.3948355307)
13673 33088 1 15   5 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
13881 35819 1 15 980 Houston St 4 1 1 1   04/22/1998 12:00:00 AM     Permit Number 39055          
14741 33082 1 15   7 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14773 46721 1 15   1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
15188 34004 1 15   3 1 1 1         Permit Number 37940          
15368 33086 1 15   1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
15498 35820 1 15 980 Houston St 1 1 1 1   04/22/1998 12:00:00 AM     Permit Number 39055          
15698 46198 1 15   1 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
15858 33090 1 15   3 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
16147 36565 1 15   6 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
16437 36563 1 15   2 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
16615 46720 1 15   2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
17977 116827 2 15 111 BAY ST 14 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
18362 57232 1 15 91 Henry St 1 1 1 1   01/09/1975 12:00:00 AM     Permit Number 14519 6002939.30874382 2107370.92325937 37.766605140706794 -122.43308839292601 (37.7666051407068, -122.433088392926)
18528 120131 2 15 799x Shotwell St 2 1 1 1       3x3            
18737 34217 1 15 110 Frederick St 2 1 1 1   06/17/1997 12:00:00 AM     Permit Number 38032 5999469.36873216 2107750.31436605 37.7674494126495 -122.445117544708 (37.7674494126495, -122.445117544708)
19025 116366 2 15 100x SACRAMENTO ST 5 1 1 1       3x3   6013491.0 2117477.0 37.7949470000015 -122.397300449207 (37.7949470000015, -122.397300449207)
19127 49220 1 15 500 Howard St 14 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
19178 119707 1 15 47 Octavia St 6 1 1 1           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588)
19407 122441 2 15 599X Folsom St 2 1 1 1       3x3   6013894.0 2113944.0 37.785268632987204 -122.395658341533 (37.7852686329872, -122.395658341533)
19678 34828 1 15 1627 18th Ave 1 1 1 1   07/29/1997 12:00:00 AM     Permit Number 38458 5990549.21563661 2104310.17201234 37.757490528410294 -122.4757195858 (37.7574905284103, -122.4757195858)
19694 110273 2 15 4169 20TH ST 1 1 1 1       3x3   6002618.0 2104102.0 37.7576112377986 -122.433966054221 (37.7576112377986, -122.433966054221)
19787 118299 2 15 275 OLYMPIA WAY 10 5 1 1       3x3   5996383.0 2101914.0 37.7512477308097 -122.455370966371 (37.7512477308097, -122.455370966371)
20185 120130 2 15 799x Shotwell St 1 1 1 1       3x3            
20377 113374 2 15 88 HOWARD ST 5 1 1 1       3x3   6014757.0 2116474.0 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575)
20654 49903 1 15 1686 15th St 3 1 1 1 1 07/02/2003 12:00:00 AM     Permit Number 46673 6006217.29915575 2107312.14837083 37.7666291551697 -122.42174620348499 (37.7666291551697, -122.421746203485)
Powered by Datasette · Query took 53.936ms · Data source: data.sfgov.org