sf-trees

Data source: data.sfgov.org

Custom SQL query returning 68 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4735 226781 2 52 466 Sanchez St 1 1 1 1     7 7x8   6003584.13439 2105555.33075 37.7616565176582 -122.430728478955 (37.7616565176582, -122.430728478955)
13590 122711 2 52 225 Arkansas St 1 1 1 1     7 3x3   6012928.83224 2105933.48701 37.763219845153706 -122.398435273093 (37.7632198451537, -122.398435273093)
19790 53252 1 52 18 Vicksburg St 1 1 1 1   07/21/1969 12:00:00 AM 7   Permit Number 6139 6004056.10022951 2102948.9340362 37.754526698445 -122.428910313961 (37.754526698445, -122.428910313961)
25893 226384 2 52 15 Bennington St 1 1 1 1     7 Width 3ft   6007204.63358 2097592.3752900003 37.7399965053243 -122.417642194748 (37.7399965053243, -122.417642194748)
25940 226434 2 52 106 Bartlett St 8 1 1 1     7 Width 3ft   6006662.06006 2103117.82252 37.7551375848404 -122.419910185127 (37.7551375848404, -122.419910185127)
27605 39569 1 52 806 Kansas St 1 1 1 1 1 12/28/1998 12:00:00 AM 7   Permit Number 40988 6011543.776869999 2104583.27285 37.7594352029858 -122.40313076567101 (37.7594352029858, -122.403130765671)
33023 229856 2 52 119 Fair Oaks St 1 1 1 1     7 Width 3ft   6005420.32438 2102982.74414 37.7546966562501 -122.42419486740299 (37.7546966562501, -122.424194867403)
33217 247662 2 52 108 Divisadero St 1 4 1 1     7 Width 3ft   6001959.68947 2108344.83823 37.769223654362605 -122.436546435187 (37.7692236543626, -122.436546435187)
33332 226355 2 52 2175 Harrison St 1 1 1 1     7 Width 3ft   6008795.60516 2105650.73446 37.7622123526471 -122.412710792894 (37.7622123526471, -122.412710792894)
34320 190702 2 52 648 Carolina St 2 1 1 1     7 Width 3ft   6012372.026430001 2104905.9974700003 37.760367552645704 -122.40028892061899 (37.7603675526457, -122.400288920619)
36119 226431 2 52 106 Bartlett St 5 1 1 1     7 Width 3ft   6006664.9239300005 2103021.2685 37.7548726310745 -122.419893429847 (37.7548726310745, -122.419893429847)
38255 229744 2 52 1 27th St 2 1 1 1     7 Width 3ft   6006129.97006 2100227.1008099997 37.747170335258204 -122.421545017711 (37.7471703352582, -122.421545017711)
40061 226772 2 52 580 Hill St 1 1 1 1     7 Width 3ft   6002600.09968 2103291.6140799997 37.7553850962495 -122.433970034883 (37.7553850962495, -122.433970034883)
41064 226779 2 52 3974 18th St 1 1 1 1     7 Width 3ft   6003146.2455400005 2105369.3554599998 37.76112105592 -122.432229675877 (37.76112105592, -122.432229675877)
42197 226381 2 52 60 Nebraska St 1 9 1 1     7 Width 3ft   6009264.00065 2097705.48363 37.740422744414396 -122.410529710297 (37.7404227444144, -122.410529710297)
43399 226803 2 52 4187 20th St 6 1 1 1     7 Width 3ft   6002522.14485 2104118.46632 37.7576510101026 -122.434298737121 (37.7576510101026, -122.434298737121)
48315 190746 2 52 1725 Newcomb Ave 1 2 1 1     7 Width 4ft   6014545.668430001 2096162.71895 37.7364813198484 -122.392159766062 (37.7364813198484, -122.392159766062)
50747 229889 2 52 77 Manchester St 1 1 1 1     7 Width 3ft   6008249.8814900005 2099665.88685 37.7457486716635 -122.414174809135 (37.7457486716635, -122.414174809135)
53105 47677 1 52 442 Pennsylvania Ave 1 1 1 1 1 05/21/2002 12:00:00 AM 7 6x7 Permit Number 45461 6014320.2471199995 2105057.7059400002 37.7608925552604 -122.39356149707301 (37.7608925552604, -122.393561497073)
56206 226427 2 52 106 Bartlett St 1 1 1 1     7 Width 3ft   6006674.0476 2102914.93571 37.7545811796958 -122.419854332733 (37.7545811796958, -122.419854332733)
57747 248027 2 52 423 Franconia St 1 1 1 1     7 Width 2ft   6009988.36995 2098561.68629 37.7428142746487 -122.40808548247 (37.7428142746487, -122.40808548247)
57922 226353 2 52 3027 Harrison St 1 1 1 1     7 Width 3ft   6009058.07626 2100853.8453 37.7490559051208 -122.41146409148999 (37.7490559051208, -122.41146409149)
58077 226413 2 52 1420 Alabama St 1 1 1 1     7 Width 4ft   6009277.36888 2100886.8777799997 37.7491589026595 -122.41070810519 (37.7491589026595, -122.41070810519)
59686 226329 2 52 351 Shotwell St 3 1 1 1     7 Width 3ft   6007821.99816 2105868.6324299998 37.7627559568505 -122.416093572069 (37.7627559568505, -122.416093572069)
60214 229847 2 52 3494 21st St 3 1 1 1     7 Width 5ft   6005127.97551 2103724.2468 37.756716137850795 -122.42525865118999 (37.7567161378508, -122.42525865119)
62717 78495 2 52 1300 Rhode Island St 3 1 1 1 1 10/07/2000 12:00:00 AM 7     6011953.72275 2102256.16538 37.7530683626141 -122.40154940677401 (37.7530683626141, -122.401549406774)
63739 39570 1 52 806 Kansas St 2 1 1 1 1 12/28/1998 12:00:00 AM 7   Permit Number 40988 6011544.20572 2104572.19135 37.759404799599 -122.403128503001 (37.759404799599, -122.403128503001)
65742 105894 2 52 635 Texas St 2 1 1 1     7 3x3   6013871.777480001 2104094.2415400003 37.758222162353704 -122.395045082568 (37.7582221623537, -122.395045082568)
73438 190716 2 52 333 Arkansas St 1 9 1 1     7 Width 3ft   6012961.26572 2105490.25457 37.7620046335244 -122.398291995789 (37.7620046335244, -122.398291995789)
75690 229799 2 52 69 Lapidge St 2 1 1 1     7 Width 3ft   6006019.542880001 2105120.91089 37.7606013799572 -122.422274509073 (37.7606013799572, -122.422274509073)
76385 58933 1 52 1330 Rhode Island St 1 1 1 1   03/28/1980 12:00:00 AM 7   Permit Number 18211 6011958.83687 2102173.2877700003 37.752841084147704 -122.401525896729 (37.7528410841477, -122.401525896729)
76600 226396 2 52 1483 Shotwell St 1 1 1 1     7 Width 3ft   6008038.2899400005 2099516.86307 37.7453275982942 -122.41489591881 (37.7453275982942, -122.41489591881)
90724 226444 2 52 3184 25th St 1 1 1 1     7 Width 3ft   6008475.72782 2101569.16263 37.750987325127 -122.413528448383 (37.750987325127, -122.413528448383)
132037 226447 2 52 3170 23rd St 1 1 1 1     7 Width 3ft   6007854.47288 2102702.51383 37.7540643473922 -122.415757056543 (37.7540643473922, -122.415757056543)
132827 190721 2 52 2200 Alameda St 1 1 1 1     7 Width 4ft   6010462.79733 2107890.40635 37.7684554148125 -122.40710245603901 (37.7684554148125, -122.407102456039)
133554 190713 2 52 529 Texas St 3 4 1 1     7 Width 3ft   6013844.9587900005 2104593.96331 37.759592798384105 -122.395172837551 (37.7595927983841, -122.395172837551)
134772 229800 2 52 230 Lexington St 1 1 1 1     7 Width 3ft   6006477.6106 2104743.99354 37.75959228038 -122.42066350043899 (37.75959228038, -122.420663500439)
136393 226440 2 52 501 Bartlett St 1 1 1 1     7 Width 3ft   6006828.6728300005 2100820.93756 37.748840248593396 -122.419171070095 (37.7488402485934, -122.419171070095)
137231 229818 2 52 990 Treat Ave 6 1 1 1     7 Width 4ft   6008585.67153 2102788.11843 37.7543404761497 -122.41323443932801 (37.7543404761497, -122.413234439328)
139792 104962 5 52 1474X SHOTWELL ST 1 1 1 1     7 3x3 74 Aztec St. 6008023.0 2099506.0 37.7452969115591 -122.414948020341 (37.7452969115591, -122.414948020341)
147318 226768 2 52 508 Diamond St 2 1 1 1     7 Width 3ft   6001810.12784 2102797.39865 37.7539832366425 -122.436666617866 (37.7539832366425, -122.436666617866)
147445 226428 2 52 106 Bartlett St 2 1 1 1     7 Width 3ft   6006671.335630001 2102940.18758 37.7546503627401 -122.419865503217 (37.7546503627401, -122.419865503217)
147455 226787 2 52 166 Hartford St 1 1 1 1     7 Width 3ft   6002663.06838 2104932.4361099997 37.7598939732341 -122.43386954555001 (37.7598939732341, -122.43386954555)
147524 226349 2 52 3169 25th St 1 1 1 1     7 Width 3ft   6008560.82259 2101530.27945 37.7508853383864 -122.413231431983 (37.7508853383864, -122.413231431983)
147956 48401 1 52 1170 Rhode Island St 1 1 1 1   06/03/2008 12:00:00 AM 7 3x3 Permit Number 50635 6011912.33745 2102971.80272 37.7550310367587 -122.40174282399799 (37.7550310367587, -122.401742823998)
150086 190727 2 52 2211 Alameda St 3 1 1 1     7 Width 4ft   6010484.13409 2107848.45184 37.768341411351706 -122.407025696183 (37.7683414113517, -122.407025696183)
154047 226354 2 52 2531 Harrison St 1 1 1 1     7 Width 3ft   6008912.12857 2103526.86687 37.756387235107496 -122.41215767113998 (37.7563872351075, -122.41215767114)
155639 226379 2 52 424 Nevada St 1 1 1 1     7 Width 3ft   6008895.67252 2096317.34788 37.736590569490104 -122.41170519075199 (37.7365905694901, -122.411705190752)
156104 226423 2 52 582 Shotwell St 1 1 1 1     7 Width 3ft   6007852.94487 2104547.46953 37.7591300882142 -122.415892978285 (37.7591300882142, -122.415892978285)
159380 248006 2 52 444 Franconia St 2 1 1 1     7 Width 3ft   6009948.03902 2098416.30132 37.7424128208876 -122.408214684483 (37.7424128208876, -122.408214684483)
160629 228542 2 52 1465 Florida St 1 1 1 1     7 Width 6ft   6009587.77635 2100703.29886 37.748672234533295 -122.409621752043 (37.7486722345333, -122.409621752043)
161626 226818 2 52 272 Corbett Ave 2 17 1 1     7 Width 3ft   5999639.14958 2105380.58985 37.7609524294432 -122.44435997895599 (37.7609524294432, -122.444359978956)
161657 39574 1 52 863 Kansas St 1 1 1 1 1 12/28/1998 12:00:00 AM 7   Permit Number 40991 6011617.31177 2104338.8923 37.758768294548105 -122.402859256767 (37.7587682945481, -122.402859256767)
162626 226330 2 52 351 Shotwell St 4 1 1 1     7 Width 3ft   6007820.8839300005 2105900.2229299997 37.7628426343977 -122.416099663169 (37.7628426343977, -122.416099663169)
162916 229857 2 52 119 Fair Oaks St 2 1 1 1     7 Width 3ft   6005419.16743 2102997.26245 37.754736454825704 -122.42419990093 (37.7547364548257, -122.42419990093)
162976 248227 2 52 38 Lundy's Ln 1 1 1 1     7 Width 3ft   6007014.76999 2099297.76945 37.7446684509831 -122.418419557911 (37.7446684509831, -122.418419557911)
164194 229821 2 52 862 York St 1 1 1 1     7 Width 4ft   6009901.39603 2104182.38613 37.758242602143795 -122.40878266838001 (37.7582426021438, -122.40878266838)
165182 226799 2 52 701 Sanchez St 1 9 1 1     7 Width 3ft   6003733.12478 2104096.2711400003 37.7576587280713 -122.43010909155899 (37.7576587280713, -122.430109091559)
166188 226807 2 52 48 Henry St 1 1 1 1     7 Width 3ft   6003212.25535 2107433.99017 37.7667937860223 -122.432148823236 (37.7667937860223, -122.432148823236)
168009 49995 1 52 908@ 20TH ST Kansas St 1 1 1 1 1 07/25/2003 12:00:00 AM 7   Permit Number 46738 6011567.9770599995 2104146.58896 37.7582375173758 -122.403016353927 (37.7582375173758, -122.403016353927)
168280 138954 2 52 719 Buchanan St 3 1 1 1     7 Width 0ft   6004474.5770000005 2110934.0085 37.7764754744029 -122.42803210297501 (37.7764754744029, -122.428032102975)
170050 228547 2 52 1325 Florida St 1 1 1 1     7 Width 5ft   6009559.03474 2101249.47013 37.7501702892497 -122.409759687354 (37.7501702892497, -122.409759687354)
172206 226451 2 52 3070 23rd St 5 1 1 1     7 Width 3ft   6008441.9337 2102736.37343 37.7541903253234 -122.41372786314501 (37.7541903253234, -122.413727863145)
181234 226785 2 52 3894 19th St 1 1 1 1     7 Width 3ft   6003780.43348 2104817.05272 37.75964050202929 -122.429996893968 (37.7596405020293, -122.429996893968)
181725 70134 2 52 342-344 Utah St 1 1 1 1 1 09/17/1994 12:00:00 AM 7     6010584.92199 2106684.72003 37.7651517084965 -122.40659506122499 (37.7651517084965, -122.406595061225)
182992 190692 2 52 1007 Tennessee St 1 1 1 1     7 Width 5ft   6015546.55953 2104430.7549099997 37.7592391453969 -122.38927640559099 (37.7592391453969, -122.389276405591)
184211 190717 2 52 1150 19th St 4 2 1 1     7 Width 4ft   6014133.64605 2105280.55607 37.7614940829991 -122.39422247538401 (37.7614940829991, -122.394222475384)
184718 229816 2 52 990 Treat Ave 2 1 1 1     7 Width 4ft   6008580.21051 2102912.8481900003 37.7546826492875 -122.41326214475299 (37.7546826492875, -122.413262144753)
Powered by Datasette · Query took 6.596ms · Data source: data.sfgov.org