sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
463 234072 3 26 1400 San Bruno Ave 2 1 1 4 4   4 Width 3ft   6011140.67766 2101759.7310900004 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746)
521 5204 3 15 777 Divisadero St 1 1 1 1 4 04/21/2016 12:00:00 AM 3 4X4   6001528.9942 2111019.6475 37.7765435284866 -122.438227828795 (37.7765435284866, -122.438227828795)
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
657 5214 3 9 835 Divisadero St 1 1 1 1 4 12/09/2001 12:00:00 AM 3 3X3   6001489.0793 2111327.2763 37.7773859294292 -122.438387950593 (37.7773859294292, -122.438387950593)
985 97601 3 9 855 Divisadero St 1 1 1 1 4   3 3x3   6001476.9066 2111398.2834 37.7775802046297 -122.43843514847099 (37.7775802046297, -122.438435148471)
1065 24631 3 44 601 Divisadero St 1 1 1 1 4 04/03/2013 12:00:00 AM 3 3X3   6001596.3507 2110541.037 37.775233214934104 -122.43796053363701 (37.7752332149341, -122.437960533637)
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)
2484 5197 3 9 631 Divisadero St 1 1 1 1 4 05/10/1993 12:00:00 AM 3 3X3   6001585.1623 2110622.5519999997 37.7754563984119 -122.438005076955 (37.7754563984119, -122.438005076955)
2929 28092 3 9 528 Divisadero St 1 1 1 1 4 05/12/2001 12:00:00 AM 3 3X3   6001704.4418 2110256.1887 37.774457239071104 -122.43756621922199 (37.7744572390711, -122.437566219222)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3798 5199 3 9 643 Divisadero St 1 1 1 1 4 06/29/2007 12:00:00 AM 3 3X3   6001573.1748 2110709.1284 37.7756934337528 -122.43805274745701 (37.7756934337528, -122.438052747457)
4425 97577 3 9 628 Divisadero St 1 1 1 1 4   3 3x3   6001652.1221 2110620.3263 37.775454094869296 -122.43777328811301 (37.7754540948693, -122.437773288113)
4475 253631 2 49 39 Mason St 1 1 1 1 4         6009957.290080001 2113442.89538 37.783672949399204 -122.409242840109 (37.7836729493992, -122.409242840109)
4588 200921 1 79 4040 03rd St 1 1 1 1 4 01/18/2008 12:00:00 AM 5 Width 0ft   6015547.5959 2097647.2059 37.7406129979736 -122.388799250904 (37.7406129979736, -122.388799250904)
5125 97583 3 9 748 Divisadero St 1 1 1 1 4   3 3x3   6001590.7259 2111040.5 37.776604295001 -122.438015775508 (37.776604295001, -122.438015775508)
5209 169218 1 29 824 Ellis St 1 1 1 1 4   0 3x3   6006905.3054599995 2113639.6299099997 37.7840416758297 -122.419815533287 (37.7840416758297, -122.419815533287)
5210 83637 1 17 840 Ellis St 1 1 1 1 4 11/19/2005 12:00:00 AM   3x3   6006834.966315799 2113631.30048912 37.784014842491395 -122.420058290383 (37.7840148424914, -122.420058290383)
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5217 169168 1 29 701 Polk St 2 1 1 1 4   0 3x3   6007051.56678 2113380.55802 37.7833385660552 -122.41929113679599 (37.7833385660552, -122.419291136796)
5218 169214 1 29 724 Ellis St 1 1 1 1 4   0 Width 4ft   6007369.544319999 2113705.88387 37.7842497348906 -122.41821413029301 (37.7842497348906, -122.418214130293)
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5227 169217 1 29 800 Ellis St 1 1 1 1 4   0 3x3   6006932.37231 2113646.73425 37.7840627073778 -122.41972239586501 (37.7840627073778, -122.419722395865)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5234 169170 1 29 750 Eddy St 1 1 1 1 4   0 3x3   6006877.9642199995 2113290.02776 37.7830802133315 -122.419885308057 (37.7830802133315, -122.419885308057)
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
5238 169219 1 29 840 Polk St 1 1 1 1 4   0 3x3   6006827.36035 2113629.7400599997 37.7840101293977 -122.42008449353001 (37.7840101293977, -122.42008449353)
5239 253830 1 54 651X Polk St 3 1 1 1 4     3x3            
5728 97579 3 9 628 Divisadero St 3 1 1 1 4   3 3x3   6001646.5608 2110651.222 37.7755386104847 -122.437794739235 (37.7755386104847, -122.437794739235)
5735 28095 3 9 650 Divisadero St 2 1 1 1 4 12/06/2006 12:00:00 AM 3 3x3   6001636.0563 2110732.7869 37.775761969914896 -122.437836920035 (37.7757619699149, -122.437836920035)
5871 97602 3 9 833 Divisadero St 1 1 1 1 4   3 3xe   6001492.376 2111306.2278 37.777328323069796 -122.438375037891 (37.7773283230698, -122.438375037891)
5874 97590 3 9 559 Divisadero St 1 1 1 1 4   3 3x3   6001615.3648 2110410.2466 37.774875178544995 -122.437885389718 (37.774875178545, -122.437885389718)
5886 5187 3 9 505 Divisadero St 1 1 1 1 4   3 3X3   6001641.6836 2110218.0701 37.7743490065847 -122.43778058071699 (37.7743490065847, -122.437780580717)
6000 28097 3 9 661 Divisadero St 1 1 1 1 4   3 3X3   6001567.17 2110752.9686 37.7758134664372 -122.438076660597 (37.7758134664372, -122.438076660597)
6072 24616 3 9 830 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001554.3804 2111297.3519 37.777307478654706 -122.438159908991 (37.7773074786547, -122.438159908991)
6760 24628 3 9 536 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001694.2572 2110311.9357 37.774609727324204 -122.437605442785 (37.7746097273242, -122.437605442785)
7406 97595 3 9 793 Divisadero St 3 1 1 1 4   3 4x4   6001524.4178 2111055.242 37.7766410017417 -122.438246210395 (37.7766410017417, -122.438246210395)
7506 14836 1 21 1300 McAllister St 1 1 1 1 4 10/22/2008 12:00:00 AM 9 3X3   6002892.8097 2111692.1261 37.7784674596438 -122.43355807318501 (37.7784674596438, -122.433558073185)
7792 97581 3 9 736 Divisadero St 1 1 1 1 4   3 3x3   6001597.3606 2110988.4698 37.776461810461704 -122.43798909643101 (37.7764618104617, -122.437989096431)
7872 97569 3 9 542 Divisadero St 1 1 1 1 4   3     6001690.505 2110331.7687 37.7746639704386 -122.437619843013 (37.7746639704386, -122.437619843013)
8085 5202 3 9 740 Divisadero St 1 1 1 1 4 02/15/2005 12:00:00 AM 3 3X4   6001595.2588 2111007.3853 37.7765136281427 -122.437997722367 (37.7765136281427, -122.437997722367)
8303 97591 3 9 501 Divisadero St 1 1 1 1 4   3 4x3   6001649.1323 2110166.4258 37.7742076278049 -122.43775111477899 (37.7742076278049, -122.437751114779)
8311 5206 3 9 793 Divisadero St 1 1 1 1 4 05/10/1993 12:00:00 AM 3 4X4   6001519.3329 2111090.328 37.7767370498578 -122.438266314655 (37.7767370498578, -122.438266314655)
8394 97584 3 9 818 Divisadero St 1 1 1 1 4   3 3x3   6001564.5243 2111243.3358 37.777159740959895 -122.43812094768101 (37.7771597409599, -122.438120947681)
8431 97593 3 9 661 Divisadero St 2 1 1 1 4   3     6001569.9782 2110730.4395 37.7757517668907 -122.438065332169 (37.7757517668907, -122.438065332169)
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
10038 96503 3 150 2360X Harrison St 4 1 1 4 4     3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
12092 77648 3 55 1300X Silliman St 9 1 1 4 4 01/01/2011 12:00:00 AM 3 3x3   6006817.147419999 2093142.9824700002 37.727757638780204 -122.418666516263 (37.7277576387802, -122.418666516263)
17572 5174 3 9 350 Divisadero St 1 1 1 1 4 11/28/2006 12:00:00 AM 3 3x4   6001785.2321 2109677.0482 37.7728716568906 -122.437245274575 (37.7728716568906, -122.437245274575)
17669 5170 3 223 318 Divisadero St 1 1 1 1 4 02/15/2005 12:00:00 AM 3 3X3   6001801.5136 2109559.6859 37.7725503347821 -122.43718055043101 (37.7725503347821, -122.437180550431)
18219 5158 3 9 275 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001773.6501 2109268.6052 37.771749515715605 -122.437256087151 (37.7717495157156, -122.437256087151)
18577 5154 3 9 259 Divisadero St 1 1 1 1 4   3 3X3   6001780.9624 2109220.4101 37.771617599631604 -122.43722734206499 (37.7716175996316, -122.437227342065)
20046 5155 3 9 265 Divisadero St 1 1 1 1 4 12/17/2001 12:00:00 AM 3 3X3   6001777.3063 2109242.3472 37.7716776256193 -122.43724155970399 (37.7716776256193, -122.437241559704)
22018 24636 3 223 443 Divisadero St 3 1 1 1 4 06/17/2014 12:00:00 AM 3 3X4   6001673.68932 2109984.60324 37.773709784823296 -122.437653143592 (37.7737097848233, -122.437653143592)
26614 98657 1 55 2110 Greenwich St 11 1 1 4 4   11 5x5   6002607.56666 2119218.5959900003 37.7991170337862 -122.43508328318701 (37.7991170337862, -122.435083283187)
28447 116579 6 98 3000x 19TH AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
31571 98656 1 55 2110 Greenwich St 10 1 1 4 4   8 5x5   6002629.88193 2119221.45898 37.799126161900396 -122.435006269744 (37.7991261619004, -122.435006269744)
33915 98646 1 55 2110 Greenwich St 3 1 1 4 4   8 5x5   6002771.23879 2119243.65965 37.799195144410795 -122.43451871576099 (37.7991951444108, -122.434518715761)
44053 97599 3 223 857 Divisadero St 1 1 1 1 4   3 3x3   6001483.0 2111323.0 37.7773738419974 -122.43840867438801 (37.7773738419974, -122.438408674388)
44207 98648 1 55 2110 Greenwich St 5 1 1 4 4   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245)
53064 98650 1 55 2110 Greenwich St 7 1 1 4 4   11 5x5   6002693.158 2119231.9709099997 37.799158617543604 -122.43478806542801 (37.7991586175436, -122.434788065428)
58682 116625 2 41 5732X GEARY BLVD 6 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
61687 97564 3 223 252 Divisadero St 1 1 1 1 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
63146 75990 2 273 350 Broadway 1 1 1 4 4 10/07/1995 12:00:00 AM 3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.40285383475599 (37.7984395708796, -122.402853834756)
69128 98649 1 55 2110 Greenwich St 6 1 1 4 4   16 5x5   6002707.76445 2119233.0203 37.799162328147794 -122.434737597267 (37.7991623281478, -122.434737597267)
71504 98651 1 32 2110 Greenwich St 8 1 1 4 4   23 5x5   6002674.17203 2119228.66956 37.799148474973705 -122.434853527066 (37.7991484749737, -122.434853527066)
77610 109992 2 55 501X Shotwell St 9 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
77875 106884 2 53 180X SAN MARCOS AVE 6 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
80527 97588 3 223 327 Divisadero St 1 1 1 1 4   3     6001736.6 2109522.6 37.7724448159613 -122.437402436672 (37.7724448159613, -122.437402436672)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
81163 104152 1 54 525X Church St 2 5 2 4 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
81722 104155 1 54 525X Church St 3 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
82894 24632 3 15 605 Divisadero St 1 1 1 1 4 10/08/2014 11:30:00 AM 3 3X3   6001606.913089 2110457.4002288003 37.7750041699802 -122.437918004082 (37.7750041699802, -122.437918004082)
83032 28101 3 223 305 Divisadero St 1 1 1 1 4   3 3X3   6001749.0605888 2109439.6370142 37.7722177286516 -122.437353392664 (37.7722177286516, -122.437353392664)
83876 109990 2 26 501X Shotwell St 7 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
84168 28096 3 223 850 Divisadero St 1 1 1 1 4   3 3X3   6001561.6093482 2111313.2017111 37.77735140937129 -122.43813603744499 (37.7773514093713, -122.438136037445)
84743 116631 2 41 5732X GEARY BLVD 12 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
85143 115005 5 16 1050 MCALLISTER ST 2 8 1 21 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
85949 109996 2 55 501X Shotwell St 13 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
87276 112509 2 11 699x WILLOW ST 1 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
88343 97566 3 223 338 Divisadero St 1 1 1 1 4   3     6001793.0 2109569.0 37.7725754250276 -122.437210666805 (37.7725754250276, -122.437210666805)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89691 109988 2 26 501X Shotwell St 5 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
90177 109991 2 297 501X Shotwell St 8 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
92075 111588 3 47 730X Lake Merced Blvd 4 7 1 10 4   48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
92640 109986 2 26 501X Shotwell St 3 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
93134 98908 2 26 501X Shotwell St 2 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93703 97898 2 49 375X Precita Ave 4 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
94993 112510 2 11 699x WILLOW ST 2 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
95046 109987 2 26 501X Shotwell St 4 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
Powered by Datasette · Query took 3.513ms · Data source: data.sfgov.org