sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
5239 253830 1 54 651X Polk St 3 1 1 1 4     3x3            
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
89354 111589 3 47 730X Lake Merced Blvd 5 7 1 10 4       Permit Number 774260 5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
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)
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)
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)
96632 116628 2 41 5732X GEARY BLVD 9 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
98906 116629 2 41 5732X GEARY BLVD 10 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
100355 116620 2 41 5732X GEARY BLVD 1 8 1 6 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113343 116624 2 41 5732X GEARY BLVD 5 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
119101 116621 2 41 5732X GEARY BLVD 2 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
123257 116622 2 41 5732X GEARY BLVD 3 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124339 116630 2 41 5732X GEARY BLVD 11 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
125790 116627 2 41 5732X GEARY BLVD 8 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
142683 116623 2 41 5732X GEARY BLVD 4 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
119702 111096 1 52 67 SAINT CHARLES AVE 31 1 1 10 4   15     5992079.0 2088073.0 37.712995910736204 -122.46924723728901 (37.7129959107362, -122.469247237289)
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)
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)
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)
108228 106878 2 3 180X SAN MARCOS AVE 1 11 1 1 4   26     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
114247 106879 2 126 180X SAN MARCOS AVE 2 11 1 1 4   6     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
125523 106883 2 53 180X SAN MARCOS AVE 4 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 3.072ms · Data source: data.sfgov.org