sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1 141565 1 1 501X Baker St 1 1 1 1   07/21/1988 12:00:00 AM 21 Width 0ft Permit Number 25401 6000609.0 2110829.0 37.7759676911831 -122.441396661871 (37.7759676911831, -122.441396661871)
4 207368 2 4 920 Kirkham St 1 1 1 1     6 Width 1ft   5992009.48044 2105269.9271 37.760210314285004 -122.47073935813 (37.760210314285, -122.47073935813)
6 141566 1 1 501X Baker St 2 1 1 1     14 Width 0ft   6000587.8822 2110733.5952 37.7757045307049 -122.441462866076 (37.7757045307049, -122.441462866076)
8 122650 1 6 300x Hickory St 6 1 1 1   11/10/2016 12:00:00 AM 3 3x3            
9 203507 2 7 920 Kirkham St 2 1 1 1     23 Width 3ft   5991972.62617 2105259.8491700003 37.76018051163321 -122.470866084321 (37.7601805116332, -122.470866084321)
10 122670 1 8 301x Hickory St 3 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
11 122658 1 6 300x Hickory St 14 1 1 1   11/10/2016 12:00:00 AM 3 3x3            
12 122660 1 6 300x Hickory St 16 1 1 1   11/10/2016 12:00:00 AM 3 3x3            
13 122648 1 6 300x Hickory St 4 1 1 1   11/10/2016 12:00:00 AM 3 3x3            
16 122649 1 6 300x Hickory St 5 1 1 1   11/10/2016 12:00:00 AM 3 3x3            
17 145278 2 10 730 11th Ave 1 1 1 1   03/20/2017 12:00:00 AM 0 Width 3ft Permit Number 779614 5992589.961569999 2110455.11477 37.774481011910204 -122.469109146279 (37.7744810119102, -122.469109146279)
18 96369 2 11 168 Cervantes Blvd 1 1 1 1   08/09/2011 12:00:00 AM 24 3x3 Permit Number 767919 6001162.44444 2121276.45677 37.8046852096195 -122.44023153767799 (37.8046852096195, -122.440231537678)
19 182260 2 12 1471 28th Ave 1 1 1 1     5 3x3   5987398.0 2105276.0 37.759959232607606 -122.486688530832 (37.7599592326076, -122.486688530832)
22 203506 2 7 910 Kirkham St 4 1 1 1     15 Width 3ft   5992059.0 2105289.0 37.760265546982495 -122.470569484113 (37.7602655469825, -122.470569484113)
23 52566 1 14 1555 40th Ave 1 1 1 1   01/12/2016 12:00:00 AM 2 3x3 Permit Number 777142 5983716.6125 2104561.7225 37.7577827259957 -122.499367683206 (37.7577827259957, -122.499367683206)
24 22346 3 11 5280 03rd St 1 1 1 2   06/27/2014 12:00:00 AM 3 3x3   6014341.487000001 2093641.8617 37.7295482207565 -122.39268941982701 (37.7295482207565, -122.392689419827)
25 23567 3 15 2975 Van Ness Ave 1 1 1 2   05/27/1992 12:00:00 AM 3 3X3   6005531.337230001 2120589.48411 37.803046726686894 -122.42506362870199 (37.8030467266869, -122.425063628702)
26 237469 1 16 4200 23rd St 1 1 1 1   07/17/2000 12:00:00 AM 0 Width 3ft Permit Number 43111 6001814.64366 2102375.07824 37.75282390261339 -122.43662077403299 (37.7528239026134, -122.436620774033)
28 21823 1 15 2741 Taylor St 1 1 1 1   08/19/2006 12:00:00 AM 3 4x4   6008229.33947 2122327.41953 37.8079706947476 -122.415850241604 (37.8079706947476, -122.415850241604)
31 22614 1 5 1001 Turk St 5 1 1 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
32 10933 3 11 1359 Hudson Ave 1 1 1 2     12 3X4   6016893.48466 2096461.5108299998 37.7374318223223 -122.384063092353 (37.7374318223223, -122.384063092353)
33 2889 1 15 1545 California St 1 1 1 1     65 3X3   6006951.47041 2116025.01423 37.79059395549061 -122.419825138035 (37.7905939554906, -122.419825138035)
34 240126 2 18 20 Lily St 2 1 1 1     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.42132618837299 (37.7747364652596, -122.421326188373)
36 13434 3 15 2X Market St 2 1 1 2     6 4X4   6014136.36792 2117295.16476 37.7944836321678 -122.39505462349199 (37.7944836321678, -122.395054623492)
38 192589 2 11 1390 Mission St 1 1 1 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
39 3558 1 11 101 Cargo Way 4 1 1 1   03/21/2017 05:52:00 PM 6 3X3   6018773.865780001 2097541.9761 37.7405023461002 -122.377636624239 (37.7405023461002, -122.377636624239)
40 222540 2 20 1 Newburg St 3 1 1 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
41 192590 2 11 1390 Mission St 2 1 1 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
42 28375 3 21 3014 Sacramento St 1 1 1 1   10/09/2003 12:00:00 AM 3 3x3 Permit Number 54020 6000248.590919999 2115494.6796 37.788757908594896 -122.442978542939 (37.7887579085949, -122.442978542939)
43 222539 2 20 1 Newburg St 2 1 1 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
45 27522 1 2 3201 California St 2 1 1 1     8 3X3   5998967.7443 2114917.3257 37.787099536792 -122.44736849888001 (37.787099536792, -122.44736849888)
46 18228 3 22 1737-1795 Post St 2 1 1 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
47 17325 3 23 150 Otis St 1 1 1 2   08/31/2016 12:00:00 AM 3 3x3   6006651.4447 2108878.4679400004 37.7709543699737 -122.420355751511 (37.7709543699737, -122.420355751511)
48 3528 3 11 201X Cargo Way 38 1 1 2   03/21/2017 04:23:00 PM 3 3X3   6018298.55272 2097894.94115 37.7414453176516 -122.37930460042801 (37.7414453176516, -122.379304600428)
51 60867 1 17   1 1 1 1   04/25/1983 12:00:00 AM     Permit Number 20649          
52 233897 2 24 1021 Noe St 1 1 1 1     9 Width 3ft   6003182.0050800005 2102290.73647 37.75266992967379 -122.43188616810801 (37.7526699296738, -122.431886168108)
53 251187 2 25 1 Baker St 2 1 1 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
54 121137 4 26 1388x Minna St 1 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
55 2909 1 15 1700 California St 5 1 1 1     30 4X4   6006037.49643 2115968.63965 37.7903876339283 -122.422983431149 (37.7903876339283, -122.422983431149)
56 27602 1 26 988 Fulton St 2 1 1 1     20 4X4   6003218.3377 2111393.5053 37.7776659856505 -122.432410615738 (37.7776659856505, -122.432410615738)
57 44642 1 17   60 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
58 4749 1 5 1255 Columbus Ave 1 1 1 1   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.805773032263296 -122.41826116482599 (37.8057730322633, -122.418261164826)
59 44994 1 17   106 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
60 121139 4 26 1388x Minna St 3 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
62 239043 2 9 10 12th St 2 1 1 1     13 Width 3ft   6006946.59098 2109912.5632700003 37.773810376676295 -122.41940820332898 (37.7738103766763, -122.419408203329)
63 222541 2 28 1 Newburg St 4 1 1 1     5 Width 2ft Permit Number 779491 6002580.9472199995 2099999.66602 37.7463450993615 -122.433800991143 (37.7463450993615, -122.433800991143)
64 138748 2 11 1614 Broderick St 2 1 1 1     0 Width 0ft   6000643.1477 2114229.9232 37.7853077023438 -122.441522641665 (37.7853077023438, -122.441522641665)
66 222538 2 20 1 Newburg St 1 1 1 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
67 166623 1 29 520 Jersey St 1 1 1 1   03/21/2017 12:00:00 AM 3 Width 3ft Permit Number 18521 6001647.24706 2101482.78936 37.7503643764264 -122.437135780708 (37.7503643764264, -122.437135780708)
68 251188 2 25 1 Baker St 5 1 1 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
69 19206 3 30 630 Sansome St 4 1 1 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
70 121138 4 26 1388x Minna St 2 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
71 251206 2 18 270 Trumbull St 1 1 1 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
72 25725 3 15 729 Grove St 1 1 1 2     12 3X3   6004286.7153 2111148.1106 37.777052715887706 -122.428697236196 (37.7770527158877, -122.428697236196)
73 65479 1 18 1051 Bush St 1 1 1 1 1 11/01/1997 12:00:00 AM 10 3x3 Permit Number 28361 6008468.497880001 2115537.43749 37.789340533487795 -122.41454177659901 (37.7893405334878, -122.414541776599)
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
75 138824 1 15 729 GROVE ST 2 1 1 1     18 Width 0ft   6004305.1004 2111150.1162 37.77705926326529 -122.428633779399 (37.7770592632653, -122.428633779399)
77 49739 1 17 145 Missouri St 1 1 1 1 1 03/22/2017 12:00:00 AM 3   Permit Number 779552 6013462.1222 2106403.54987 37.764540227980206 -122.396623740816 (37.7645402279802, -122.396623740816)
80 225032 1 32 4425 18th St 1 1 1 1   03/02/2004 12:00:00 AM 11 Width 3ft Permit Number 47310 6001257.01437 2105216.66208 37.7605944983664 -122.43875275812799 (37.7605944983664, -122.438752758128)
81 221366 2 28 55 Homestead St 1 1 1 1   03/22/2017 12:00:00 AM 3 Width 3ft Permit Number 778991 6000992.93047 2101385.53728 37.750060130381605 -122.439391477336 (37.7500601303816, -122.439391477336)
83 130626 2 21 3660 Jackson St 1 1 1 1     9 Width 3ft Permit Number 779583 5996802.12344 2115996.768 37.789939408212206 -122.454939052208 (37.7899394082122, -122.454939052208)
84 36641 1 33   13 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
85 22613 1 5 1001 Turk St 4 1 1 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
87 11032 1 32 1500 Hyde St 1 1 1 1     70 3X3   6007492.86428 2117507.22815 37.794694232707 -122.41805706457599 (37.794694232707, -122.418057064576)
88 251208 2 2 4115 Kirkham St 1 1 1 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
89 251189 1 17 1493 Hudson Ave 1 1 1 1   03/22/2017 12:00:00 AM 3 3x3   6016267.45517 2096986.6643299998 37.7388391569445 -122.38626419104999 (37.7388391569445, -122.38626419105)
92 98091 3 35 2X Frank Norris St 4 1 1 4 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
94 201404 2 36 1051 Ingalls St 16 1 1 1   04/02/1990 12:00:00 AM 14 Width 3ft   6018112.6185 2094686.77545 37.732626074632705 -122.379724665662 (37.7326260746327, -122.379724665662)
97 5266 3 26 1245 Divisadero St 2 1 1 2     12 3X4   6001289.7409 2112772.8314 37.781343716873 -122.43918115910401 (37.781343716873, -122.439181159104)
98 142074 2 26 1384X GROVE ST 2 1 1 1     5 Width 0ft   6001183.1648 2110763.0502 37.7758193019084 -122.439405751925 (37.7758193019084, -122.439405751925)
99 7992 1 9 2247 Franklin St 1 1 1 1   02/01/2007 12:00:00 AM 3 3X3   6005467.69382 2117725.44397 37.7951792074025 -122.42507996488001 (37.7951792074025, -122.42507996488)
100 106679 1 37 2200 Lyon St 1 1 1 1   06/24/2014 12:00:00 AM 10 3x3 Permit Number 773028 5999374.7893199995 2116379.94206 37.7911387486163 -122.44606546047702 (37.7911387486163, -122.446065460477)
101 192592 2 11 1399X Mission St 2 1 1 1     14 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
102 98037 5 26 1384X Grove St 1 1 1 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
103 117428 1 38   2 1 1 1   06/14/2016 12:00:00 AM 3   Permit Number 776915          
104 251210 3 39 1170 Ingalls St 2 1 1 2   11/02/1992 12:00:00 AM                
105 6251 3 5 1315 Ellis St 1 1 1 2   12/06/2003 12:00:00 AM 24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144)
106 10645 3 36 906 Hayes St 3 1 1 2     24 4x4   6003455.1435 2110726.9996 37.775849351151706 -122.431543829861 (37.7758493511517, -122.431543829861)
107 142075 2 26 1384X GROVE ST 3 1 1 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
108 192593 2 11 1399X Mission St 3 1 1 1     11 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
109 9895 3 40 1800X Pine St 1 1 1 2     18 3X3   6005051.0377 2115464.4068 37.7889474242075 -122.426360597873 (37.7889474242075, -122.426360597873)
110 97646 2 2 1824 Noriega St 1 1 1 1     12 4x4   5988290.0 2103126.0 37.7541078738982 -122.48344595561899 (37.7541078738982, -122.483445955619)
111 7749 1 15 400X Franklin St 6 1 1 1     7 3X3   6006371.15759 2111615.2483900003 37.7784531123456 -122.421519673008 (37.7784531123456, -122.421519673008)
112 9896 3 11 1800X Pine St 2 1 1 2   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917)
113 183695 1 41 1341 42nd Ave 9 1 1 1     2 Width 0ft   5983048.7244 2105854.1384 37.7612921278024 -122.50177309900499 (37.7612921278024, -122.501773099005)
115 6964 1 26 700 Fell St 2 1 1 1     8 3X3   6003997.6735 2110460.7643 37.7751490695403 -122.42964808764499 (37.7751490695403, -122.429648087645)
116 26163 1 32 220 Richardson Ave 6 1 1 1     12 3X3   5999083.87135 2119853.9919 37.8006609458028 -122.447322173097 (37.8006609458028, -122.447322173097)
117 220007 3 42 929 Valencia St 1 1 1 2   09/12/2015 03:22:00 PM 1 Width 3ft Permit Number 24134 6006336.25046 2104153.4311599997 37.7579627654961 -122.421110461684 (37.7579627654961, -122.421110461684)
119 251215 3 43 175X Otis St 11 1 1 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
120 110194 1 44 2123 Pierce St 1 1 1 1   03/26/2015 12:00:00 AM 3 3x3 Permit Number 774924 6001844.69538 2115843.7088 37.789807124247496 -122.43748126425501 (37.7898071242475, -122.437481264255)
121 59839 1 2 1201 Palou Ave 1 1 1 1 1 10/10/1981 12:00:00 AM 3   Permit Number 19293 6016946.5018 2093669.1216 37.729767407645895 -122.383685429115 (37.7297674076459, -122.383685429115)
122 183689 1 45 1341 42nd Ave 3 1 1 1     6 Width 0ft   5983043.6112 2105976.497 37.761627789464704 -122.501799836383 (37.7616277894647, -122.501799836383)
123 18916 3 41 2621 Sacramento St 1 1 1 2     14 6x5   6002236.03231 2115724.70658 37.7895026155894 -122.4361187581 (37.7895026155894, -122.4361187581)
124 20281 3 2 20X Sunset Blvd 2 1 1 2     12 60            
125 119758 2 22 151X Octavia St Frontage West 1 1 1 1                    
126 228560 3 11 700 Valencia St 2 1 1 2     7 Width 3ft   6006200.30022 2105449.82338 37.761514690968596 -122.42167271244301 (37.7615146909686, -122.421672712443)
127 18052 3 46 2840 Pine St 2 1 1 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
129 20398 3 47 262X Sunset Blvd 43 1 1 2     24 60            
130 66855 1 22 2041 Hayes St 1 1 1 1 1 11/15/1991 12:00:00 AM 8   Permit Number 30161 5998071.2779 2109932.9259 37.7733624072524 -122.450110663343 (37.7733624072524, -122.450110663343)
133 218972 2 23 742 Myra Way 1 1 1 1     10 Width 2ft Permit Number 779535 5997475.9556599995 2098006.28819 37.7405807633888 -122.451309623139 (37.7405807633888, -122.451309623139)
134 47510 1 12 54X Cayuga Ave 1 1 1 1   03/27/2017 12:00:00 AM 3 3x3 Permit Number 45390 6003705.560409999 2094600.28554 37.731583388063 -122.42952721221901 (37.731583388063, -122.429527212219)
Powered by Datasette · Query took 2.615ms · Data source: data.sfgov.org