sf-trees

Data source: data.sfgov.org

Custom SQL query returning 83 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
5223 74484 1 17 749 Polk St 4 1 1 1 4 06/29/2016 12:00:00 AM 3 3x3 Permit Number 778449 6007035.08305 2113498.23336 37.783660745502296 -122.41935651480301 (37.7836607455023, -122.419356514803)
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)
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)
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)
22149 16024 1 11 130 Monterey Blvd 1 1 1 1 4 12/29/2015 12:00:00 AM 3 3X3 Permit Number 776129 6001188.36813 2094689.80455 37.731686341545206 -122.43823603107799 (37.7316863415452, -122.438236031078)
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)
57285 100977 3 22 450X Chestnut St 9 1 1 4 4   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075)
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)
69366 93014 1 79 2395 Lombard St 4 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001021.4146 2119265.9756 37.7991569323377 -122.440575294128 (37.7991569323377, -122.440575294128)
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)
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)
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)
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)
96184 102636 1 26 2176 Mission St 2 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
98455 97903 2 2 375X Precita Ave 9 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
99549 97896 2 49 375X Precita Ave 2 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
100514 97565 3 223 258 Divisadero St 1 1 1 1 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
104363 24644 3 223 845 Divisadero St 1 1 1 1 4 12/17/2001 12:00:00 AM 3 3X3   6001484.9123945 2111282.0018462 37.7772613801811 -122.43839912079099 (37.7772613801811, -122.438399120791)
105955 24643 3 223 801X Divisadero St 1 1 1 1 4 05/04/2010 12:00:00 AM 3 4x4   6001519.6000152 2111126.7877173 37.776837174254 -122.438268003206 (37.776837174254, -122.438268003206)
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)
106746 97598 3 223 701X Divisadero St 2 1 1 1 4   3 4x3   6001578.0 2110798.0 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333)
106828 24629 3 223 616 Divisadero St 1 1 1 1 4 12/06/2006 12:00:00 AM 3 3x3   6001670.9205271 2110518.3359108996 37.7751751237236 -122.437700953995 (37.7751751237236, -122.437700953995)
108016 28093 3 223 508 Divisadero St 1 1 1 1 4   3 3X3   6001722.1241568 2110151.9438084 37.7741720139963 -122.43749758605 (37.7741720139963, -122.43749758605)
108200 97586 3 223 285 Divisadero St 1 1 1 1 4   3     6001769.0 2109329.0 37.771915080469 -122.437276497302 (37.771915080469, -122.437276497302)
109167 97897 2 49 375X Precita Ave 3 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
109180 102635 1 26 2176 Mission St 1 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
109229 93013 1 11 2395 Lombard St 1 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6000915.0 2119261.0 37.7991372104515 -122.440943166878 (37.7991372104515, -122.440943166878)
109678 97597 3 223 701X Divisadero St 1 1 1 1 4   3 4x3   6001578.0 2110798.0 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333)
113485 97567 3 223 342 Divisadero St 1 1 1 1 4   3     6001791.0 2109583.0 37.772613751849605 -122.43721858759199 (37.7726137518496, -122.437218587592)
114335 5184 3 223 460X Divisadero St 1 1 1 1 4 04/21/2016 12:00:00 AM 3 3x3   6001745.349517 2109984.4298688998 37.7737133829934 -122.437405247826 (37.7737133829934, -122.437405247826)
117253 97580 3 223 700X Divisadero St 1 1 1 1 4   3 3x3   6001615.5 2110795.9 37.7759340937147 -122.437912550894 (37.7759340937147, -122.437912550894)
118370 97563 3 223 250 Divisadero St 1 1 1 1 4 09/21/2015 12:00:00 AM 3 5x5   6001845.0 2109086.0 37.771252182937296 -122.436996208247 (37.7712521829373, -122.436996208247)
118803 97587 3 223 319 Divisadero St 1 1 1 1 4   3     6001745.0 2109492.0 37.772361273527004 -122.437371188758 (37.772361273527, -122.437371188758)
119523 97603 3 223 823 Divisadero St 1 1 1 1 4   3 3x3   6001500.0 2111204.0 37.777048064939706 -122.438341338421 (37.7770480649397, -122.438341338421)
119651 97570 3 223 546 Divisadero St 1 1 1 1 4   3     6001754.3 2110345.0 37.7747039272721 -122.437400111383 (37.7747039272721, -122.437400111383)
119913 97600 3 223 857 Divisadero St 2 1 1 1 4   3 3x3   6001483.0 2111323.0 37.7773738419974 -122.43840867438801 (37.7773738419974, -122.438408674388)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
120473 112511 2 11 699x WILLOW ST 3 1 1 20 4 08/08/2015 03:37:00 PM 3 2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
120777 95241 2 26 1220 Noe St 8 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
120836 24637 3 223 425 Divisadero St 1 1 1 1 4 10/25/2011 12:00:00 AM 3 3X3   6001690.3813095 2109822.1283023 37.773264618286 -122.437583765683 (37.773264618286, -122.437583765683)
121382 5205 3 127 781 Divisadero St 1 1 1 1 4 10/28/2015 07:08:00 AM 3 4X4   6001514.7755792 2111067.8471612 37.776675063930504 -122.438280468838 (37.7766750639305, -122.438280468838)
121486 95235 2 26 1220 Noe St 1 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
121851 97594 3 223 601X Divisadero St 1 1 1 1 4   3 3x3   6001572.2 2110512.7 37.7751540352305 -122.43804204596901 (37.7751540352305, -122.438042045969)
122481 102195 2 55 3999X Folsom St 9 1 1 4 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141399 97582 3 223 744 Divisadero St 1 1 1 1 4   3 3x3   6001602.0 2110950.0 37.7763564458951 -122.43797029127701 (37.7763564458951, -122.437970291277)
144041 97895 2 49 375X Precita Ave 1 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
144879 24627 3 223 444 Divisadero St 3 1 1 1 4 12/06/2006 12:00:00 AM 3 3X4   6001753.1685929 2109931.6605583 37.7735689361616 -122.43737442109699 (37.7735689361616, -122.437374421097)
145311 100972 3 26 450X Chestnut St 4 1 1 4 4 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
145991 97568 3 223 500 Divisadero St 1 1 1 1 4   3     6001703.0 2110108.0 37.7740502679918 -122.437560592174 (37.7740502679918, -122.437560592174)
171968 93015 1 79 2395 Lombard St 5 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001036.8533 2119267.6007 37.7991622735558 -122.440521987709 (37.7991622735558, -122.440521987709)
Powered by Datasette · Query took 4.675ms · Data source: data.sfgov.org