sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
94146 110101 2 51 1348 Douglass St   1 1 1   01/19/2016 12:00:00 AM   3x3 Permit Number 774671 6001379.0 2099692.0 37.7454320431231 -122.437935141467 (37.7454320431231, -122.437935141467)
2079 181058 2 51 5258 Mission St 1 1 1 1     0 Width 3ft   5999890.56935 2088656.9040700002 37.7150474825255 -122.442289836724 (37.7150474825255, -122.442289836724)
2218 114579 2 51 1501 Beach St 1 1 1 1   12/29/2015 12:00:00 AM 3 3x3   6002950.36974 2121305.2817599997 37.8048659859314 -122.43404631360701 (37.8048659859314, -122.434046313607)
2885 205488 2 51 1430 17th Ave 1 1 1 1     19 Width 3ft   5990862.44739 2105654.74875 37.761200533507 -122.474734450646 (37.761200533507, -122.474734450646)
4320 178028 2 51 398x Athens St 1 1 1 1   10/11/2017 09:59:00 AM 3 Width 3ft   6004185.0 2091264.0 37.7224498233553 -122.427632084441 (37.7224498233553, -122.427632084441)
4422 253158 2 51 700 Avalon Ave 1 1 1 1   10/11/2017 07:47:00 AM 3 3x3   6004446.0 2092174.0 37.7249632430066 -122.426794641082 (37.7249632430066, -122.426794641082)
4637 160693 2 51 700 Russia Ave 1 1 1 1 1 10/18/2017 03:34:00 PM 3 Width 0ft   6003044.40323 2089957.59001 37.7187981275985 -122.431481646786 (37.7187981275985, -122.431481646786)
4672 160512 2 51 718 Madrid St 1 1 1 1 1 10/18/2017 03:07:00 PM 3 Width 0ft   6001887.21385 2089766.7884 37.7182085743334 -122.43546794121 (37.7182085743334, -122.43546794121)
4732 160902 2 51 687 Madrid St 1 1 1 1 1 10/24/2017 03:13:00 PM 3 Width 0ft   6002042.96964 2089934.48855 37.718677886450294 -122.43494154733101 (37.7186778864503, -122.434941547331)
4758 161382 2 51 523 Madrid St 1 1 1 1   10/25/2017 03:54:00 PM 3 Width 0ft   6002614.99011 2090841.7835900001 37.721201579268495 -122.43302909312901 (37.7212015792685, -122.433029093129)
5559 98004 2 51 1908 Filbert St 1 1 1 1   11/20/2015 12:00:00 AM 14 5x5 Permit Number 775450 6003753.55269 2119031.9849799997 37.79866965343071 -122.43110445762301 (37.7986696534307, -122.431104457623)
6520 121576 2 51 3553-3555 Sacramento St 1 1 1 1     2 3x3   5997856.717119999 2115116.32362 37.787582382260396 -122.451226746117 (37.7875823822604, -122.451226746117)
6827 100292 2 51 3701 Buchanan St 1 1 1 1     6 3x3   6003061.81659 2121064.97367 37.804212487284005 -122.43364345509701 (37.804212487284, -122.433643455097)
13358 79034 2 51 10 Moss St 1 1 1 1   02/09/2002 12:00:00 AM 1 2.5x4   6010138.62156 2111398.24518 37.7780689795412 -122.40847122506399 (37.7780689795412, -122.408471225064)
13559 106005 2 51 59 Reddy St 1 1 1 1 1   3 3x3   6013632.51665 2093922.487 37.7302793593954 -122.395160068985 (37.7302793593954, -122.395160068985)
13779 101367 2 51 551 Minna St 1 1 1 1   10/17/2012 12:00:00 AM 1 3x5 Permit Number 769423 6009889.66847 2111940.62383 37.779544278688604 -122.409370733267 (37.7795442786886, -122.409370733267)
14003 100882 2 51 91 Welsh St 1 1 1 1     6 3x3   6013366.225459999 2111763.75465 37.7792528084154 -122.397331345366 (37.7792528084154, -122.397331345366)
15205 102387 2 51 84 Harriet St 1 1 1 1     3 3x3   6010709.4483199995 2111466.67522 37.778288823307 -122.406501343779 (37.778288823307, -122.406501343779)
15219 74369 2 51 535 Minna St 1 1 1 1 1 02/09/2002 12:00:00 AM 2 8x4   6009942.57894 2111988.4402900003 37.7796785357608 -122.40919106762101 (37.7796785357608, -122.409191067621)
15592 102388 2 51 90X Harriet St 1 1 1 1     3 3x3   6010739.31321 2111434.0362400003 37.778200875001104 -122.406395729189 (37.7782008750011, -122.406395729189)
23782 219426 2 51 1426 16th Ave 1 1 1 1     8 Width 3ft   5991173.89859 2105672.02771 37.7612660194265 -122.473658544928 (37.7612660194265, -122.473658544928)
24076 198405 2 51 155 Grace St 1 1 1 1     1 Width 2ft   6008338.60303 2110264.2023400003 37.7748541981831 -122.414617883501 (37.7748541981831, -122.414617883501)
25481 198281 2 51 500 Amador St 1 2 1 1     2 Width 8ft   6017868.75025 2099595.89007 37.7460920687928 -122.380908946009 (37.7460920687928, -122.380908946009)
26512 242907 2 51 320 Lily St 1 1 1 1     4 Width 2ft   6004859.69332 2110047.4287099997 37.774062923387795 -122.426636727297 (37.7740629233878, -122.426636727297)
26540 70481 2 51 934 Avalon Ave 1 1 1 1 1 08/06/1994 12:00:00 AM 3     6005107.91916 2092023.60961 37.7245877066523 -122.424495766183 (37.7245877066523, -122.424495766183)
26764 242331 2 51 206 28th St 1 1 1 1     3 Width 3ft   6004526.0717 2099598.82102 37.74535465619329 -122.427046431465 (37.7453546561933, -122.427046431465)
26966 70402 2 51 212 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 10     6006462.64225 2092921.27798 37.727128920939606 -122.419876323835 (37.7271289209396, -122.419876323835)
29033 123711 2 51 437 Balboa St 1 1 1 1     4 Width 3ft   5994213.82065 2111401.8338099997 37.777174144242295 -122.46356067075199 (37.7771741442423, -122.463560670752)
29092 242342 2 51 50 Whitney St 1 1 1 1     11 Width 3ft   6004264.15883 2097942.68629 37.740792476382 -122.427834099074 (37.740792476382, -122.427834099074)
29317 217810 2 51 198 Lee Ave 1 2 1 1     2 Width 3ft   5996576.41484 2091837.9853700001 37.7235925393546 -122.453974506819 (37.7235925393546, -122.453974506819)
29488 219440 2 51 142 Joost Ave 1 1 1 1     5 Width 3ft   6001119.093859999 2094963.2287700002 37.732433161058395 -122.438495108681 (37.7324331610584, -122.438495108681)
30123 120689 2 51 598 22nd Ave 1 1 1 1     1 Width 3ft   5989116.38632 2111294.87868 37.7765854515948 -122.48118627511299 (37.7765854515948, -122.481186275113)
30819 123714 2 51 339 Balboa St 1 1 1 1     4 Width 3ft   5994520.39053 2111414.8777 37.7772276185203 -122.462501102485 (37.7772276185203, -122.462501102485)
30973 198274 2 51 1236 Rhode Island St 1 1 1 1     4 Width 3ft   6011932.48905 2102621.16084 37.7540693755115 -122.401648489597 (37.7540693755115, -122.401648489597)
31564 242341 2 51 1867 Church St 1 1 1 1     9 Width 3ft   6004609.18081 2097837.81117 37.7405240251544 -122.426633675907 (37.7405240251544, -122.426633675907)
31927 117672 2 51 7751 Geary Blvd 1 1 1 1     7 Width 2ft   5982922.15587 2112497.69809 37.77952599164671 -122.502702614984 (37.7795259916467, -122.502702614984)
32025 242890 2 51 2230 Bryant St 1 1 1 1     5 Width 3ft   6009606.26166 2104418.84355 37.7588753255595 -122.40982006693999 (37.7588753255595, -122.40982006694)
32706 120106 2 51 2651 Cabrillo St 1 1 1 1     6 Width 3ft   5987317.09594 2110472.8163099997 37.7742235329464 -122.487350063639 (37.7742235329464, -122.487350063639)
32720 198344 2 51 451 Tehama St 1 1 1 1     3 Width 2ft   6010981.61371 2112109.48263 37.780069044799106 -122.40560510460101 (37.7800690447991, -122.405605104601)
33703 117914 2 51 839 41st Ave 1 1 1 1     1 Width 3ft   5983220.24264 2110063.17362 37.7728590079713 -122.501491276363 (37.7728590079713, -122.501491276363)
33722 242337 2 51 157 Chattanooga St 1 1 1 1     5 Width 3ft   6004758.7797 2102744.04826 37.754003877891606 -122.42646567447599 (37.7540038778916, -122.426465674476)
33820 198396 2 51 16 Moss St 1 1 1 1     3 Width 3ft   6010197.36501 2111335.28961 37.7778994078643 -122.408263568012 (37.7778994078643, -122.408263568012)
33823 136938 2 51 1277 Clay St 1 1 1 1     3 Width 3ft   6008610.97542 2116946.31505 37.7932169703383 -122.41414853544201 (37.7932169703383, -122.414148535442)
35027 242906 2 51 2641 20th St 1 1 1 1     2 Width 3ft   6010204.149619999 2104543.2646 37.759250446279005 -122.407761055636 (37.759250446279, -122.407761055636)
35277 136947 2 51 915 Front St 1 1 1 1     5 Width 4ft   6012726.66985 2119026.8860400002 37.799160033972 -122.400054056345 (37.799160033972, -122.400054056345)
35758 242888 2 51 1100 Guerrero St 1 1 1 1     1 Width 3ft   6005717.8738400005 2102519.39452 37.753441201753205 -122.423132926343 (37.7534412017532, -122.423132926343)
35858 246494 2 51 365 Duncan St 1 4 1 1     5 Width 4ft   6004182.0093 2099825.58993 37.745957849487795 -122.428252301803 (37.7459578494878, -122.428252301803)
35907 242901 2 51 3666 20th St 1 1 1 1     1 Width 3ft   6005862.21716 2104347.95143 37.758470138701895 -122.422763695285 (37.7584701387019, -122.422763695285)
36650 242863 2 51 98 McCoppin St 1 4 1 1     1 Width 3ft   6006168.47171 2109163.73568 37.7717104192431 -122.422046639762 (37.7717104192431, -122.422046639762)
37494 70335 2 51 320 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 6     6009780.67381 2094049.10859 37.7304120750579 -122.408485397509 (37.7304120750579, -122.408485397509)
37498 198311 2 51 75 Lansing St 1 1 1 1     2 Width 3ft   6014300.67476 2114126.83927 37.7857932808859 -122.394264166169 (37.7857932808859, -122.394264166169)
38574 219441 2 51 147 Stillings Ave 1 9 1 1     2 Width 8ft   5999786.27103 2095740.5208700001 37.734491517651 -122.443158781469 (37.734491517651, -122.443158781469)
38608 180407 2 51 314 Cayuga Ave 1 9 1 1     8 Width 3ft   6002242.22225 2094108.3589599999 37.7301497068323 -122.434551091376 (37.7301497068323, -122.434551091376)
38853 70336 2 51 324 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 8     6009735.9866 2094035.87413 37.7303732333298 -122.408638954927 (37.7303732333298, -122.408638954927)
38922 180401 2 51 450 Munich St 1 1 1 1     1 Width 3ft   6003847.76406 2089839.62189 37.7185197127976 -122.428696343867 (37.7185197127976, -122.428696343867)
39275 198334 2 51 432 Natoma St 1 1 1 1     1 Width 3ft   6010764.31285 2112543.17724 37.7812477151384 -122.406387417652 (37.7812477151384, -122.406387417652)
39498 198275 2 51 1199 Kansas St 1 1 1 1     6 Width 1ft   6011697.22277 2102839.72016 37.754656360309994 -122.40247746938 (37.75465636031, -122.40247746938)
39535 136939 2 51 1149 Taylor St 1 1 1 1     4 Width 4ft   6008985.04879 2116923.16762 37.7931744171228 -122.412852575501 (37.7931744171228, -122.412852575501)
40561 180403 2 51 428 Cayuga Ave 1 1 1 1     7 Width 2ft   6002092.324580001 2093893.81656 37.7295521118195 -122.435053967971 (37.7295521118195, -122.435053967971)
41404 219433 2 51 1650 12th Ave 1 1 1 1     4 Width 3ft   5992497.08192 2104245.61626 37.757426010509995 -122.46897844511001 (37.75742601051, -122.46897844511)
41429 219435 2 51 1247 11th Ave 1 1 1 1     6 Width 3ft   5992661.28483 2106962.1744 37.7648944511525 -122.468608225701 (37.7648944511525, -122.468608225701)
42765 242336 2 51 1404 Sanchez St 1 1 1 1     1 Width 3ft   6003892.07763 2100038.4689599997 37.7465259566162 -122.429270023211 (37.7465259566162, -122.429270023211)
43394 78532 2 51 501 Wayland St 1 1 1 1 1 09/30/2000 12:00:00 AM 5     6010074.13409 2092167.4028 37.725261736838604 -122.407338256469 (37.7252617368386, -122.407338256469)
43763 79959 2 51 1719 Quesada Ave 1 1 1 1 1 09/07/2002 12:00:00 AM 5     6014649.309169999 2095031.35513 37.73338057973321 -122.39172235292 (37.7333805797332, -122.39172235292)
44595 218774 2 51 2059 17th Ave 1 1 1 1     5 Width 2ft   5990964.04125 2101394.10178 37.7495078063521 -122.474072206961 (37.7495078063521, -122.474072206961)
45366 70407 2 51 231 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 8     6006535.83698 2092862.23217 37.7269709172726 -122.419619102459 (37.7269709172726, -122.419619102459)
45388 118167 2 51 3238 Balboa St 1 1 1 1     7 Width 3ft   5985487.69599 2111143.2321 37.775957450089 -122.493727608092 (37.775957450089, -122.493727608092)
45566 123719 2 51 111 Balboa St 1 1 1 1     3 Width 3ft   5995199.7628 2111434.37432 37.777320250731705 -122.460152365551 (37.7773202507317, -122.460152365551)
45828 242335 2 51 240 28th St 1 1 1 1     7 Width 2ft   6004310.20228 2099583.9062799998 37.7453014945788 -122.427791810249 (37.7453014945788, -122.427791810249)
46044 120186 2 51 172 26th Ave 1 1 1 1     1 Width 4ft   5987746.67951 2114854.71533 37.7862800304413 -122.48618581827 (37.7862800304413, -122.48618581827)
46135 180483 2 51 321 Silliman St 1 1 1 1     10 Width 3ft   6009804.862930001 2094010.61906 37.7303077455958 -122.40839905808998 (37.7303077455958, -122.40839905809)
47240 242878 2 51 1470 15th St 1 1 1 1     5 Width 3ft   6007581.63696 2107382.48327 37.7668991209285 -122.417032167507 (37.7668991209285, -122.417032167507)
49855 242329 2 51 107 28th St 1 1 1 1     2 Width 2ft   6005095.8624599995 2099583.89393 37.745345873425705 -122.42507512473699 (37.7453458734257, -122.425075124737)
50678 80637 2 51 706 Vermont St 1 1 1 1 1 10/05/2002 12:00:00 AM 4     6011239.20103 2105002.70461 37.7605698551303 -122.404213664555 (37.7605698551303, -122.404213664555)
50918 242882 2 51 1399 Minna St 1 1 1 1     6 Width 2ft   6007001.44379 2107374.71472 37.7668451355276 -122.419038415585 (37.7668451355276, -122.419038415585)
50945 123066 2 51 470 12th Ave 1 1 1 1     1 Width 3ft   5992217.29456 2112247.9898099997 37.7793822197335 -122.470528866493 (37.7793822197335, -122.470528866493)
52515 123697 2 51 126 Balboa St 1 1 1 1     3 Width 3ft   5995184.692290001 2111494.1895 37.777483620495296 -122.46020883366998 (37.7774836204953, -122.46020883367)
52843 123809 2 51 2151 Anza St 1 1 1 1     2 Width 3ft   5991938.472709999 2111997.6444599996 37.7786787136504 -122.47147517248699 (37.7786787136504, -122.471475172487)
54192 242340 2 51 232 Alma St 1 1 1 1     14 Width 3ft   5997593.66914 2106162.79262 37.76298324339871 -122.45149078527099 (37.7629832433987, -122.451490785271)
55075 74119 2 51 164 South Park 1 1 1 1 1 07/23/1994 12:00:00 AM 7     6014130.8006 2112451.57445 37.7811839433263 -122.39473452509199 (37.7811839433263, -122.394734525092)
55397 242344 2 51 147 Moffitt St 1 1 1 1     2 Width 2ft   6002611.74141 2096837.65353 37.7376646954683 -122.43346858283199 (37.7376646954683, -122.433468582832)
55529 198315 2 51 335 Ritch St 1 1 1 1     3 Width 3ft   6014439.67715 2111549.1897299998 37.778723367631706 -122.39360278135 (37.7787233676317, -122.39360278135)
56163 116375 2 51 50x Madera St 1 1 1 1     5 3x3   6012868.23872 2103276.4049 37.7559207054891 -122.39845839373301 (37.7559207054891, -122.398458393733)
56614 198357 2 51 581 Natoma St 1 1 1 1     3 Width 3ft   6009825.28404 2111621.68868 37.7786649503536 -122.40957095115299 (37.7786649503536, -122.409570951153)
57102 198419 2 51 6504 03rd St 1 1 1 1     5 Width 3ft   6012953.87538 2089942.68055 37.7193138546205 -122.397227272216 (37.7193138546205, -122.397227272216)
57137 123801 2 51 2000 Anza St 1 1 1 1     3 Width 3ft   5992459.32859 2112076.63971 37.7789257310694 -122.46967909888001 (37.7789257310694, -122.46967909888)
57172 123813 2 51 2001 Anza St 1 1 1 1     3 Width 3ft   5992407.3835 2112015.56897 37.778755044993794 -122.469854348482 (37.7787550449938, -122.469854348482)
57802 218772 2 51 1474 17th Ave 1 1 1 1     1 Width 3ft   5990872.72127 2105363.26088 37.760400780802 -122.474677643153 (37.760400780802, -122.474677643153)
58664 242887 2 51 1050 Guerrero St 1 1 1 1     7 Width 3ft   6005696.3409 2102856.44643 37.754365453022 -122.423231349069 (37.754365453022, -122.423231349069)
59288 219438 2 51 2551 15th Ave 1 1 1 1     8 Width 3ft   5991712.62848 2098073.6420400003 37.74043401203279 -122.471241703239 (37.7404340120328, -122.471241703239)
59386 218777 2 51 2097 16th Ave 1 2 1 1     1 Width 3ft   5991278.3024699995 2101198.1006 37.74898783722271 -122.472971202076 (37.7489878372227, -122.472971202076)
59804 118171 2 51 3239 Balboa St 1 1 1 1     3 Width 3ft   5985480.725380001 2111087.37265 37.7758036681834 -122.493747603691 (37.7758036681834, -122.493747603691)
59967 180424 2 51 731 Cayuga Ave 1 1 1 1     5 Width 3ft   6001468.370569999 2092778.3997 37.7264539824556 -122.437131206758 (37.7264539824556, -122.437131206758)
61309 120173 2 51 2350 Balboa St 1 1 1 1     3 Width 3ft   5988251.07109 2111245.15539 37.7763985819689 -122.484175967181 (37.7763985819689, -122.484175967181)
61657 219437 2 51 2207 17th Ave 1 1 1 1     2 Width 3ft   5990996.77172 2100343.44313 37.746624866753294 -122.473882383471 (37.7466248667533, -122.473882383471)
62590 242894 2 51 2240 Bryant St 1 1 1 1     6 Width 3ft   6009610.93402 2104332.14774 37.75863754029871 -122.409797788056 (37.7586375402987, -122.409797788056)
62996 242904 2 51 3699 24th St 1 1 1 1     7 Width 3ft   6005195.07588 2101930.11385 37.7517936572624 -122.424898952928 (37.7517936572624, -122.424898952928)
63468 123701 2 51 332 Balboa St 1 1 1 1     4 Width 3ft   5994538.935269999 2111469.38772 37.7773783564116 -122.462440905509 (37.7773783564116, -122.462440905509)
63498 136937 2 51 1020 Sacramento St 1 1 1 1     3 Width 3ft   6009944.47498 2116838.4179700003 37.792995521282 -122.409526902355 (37.792995521282, -122.409526902355)
63993 248030 2 51 155 Faith St 1 1 1 1     3 Width 2ft   6010347.266969999 2099079.20277 37.7442553510029 -122.406880978172 (37.7442553510029, -122.406880978172)
64340 242880 2 51 1321 Natoma St 1 1 1 1     7 Width 2ft   6007174.89238 2107740.52123 37.7678593198724 -122.41846442511101 (37.7678593198724, -122.418464425111)
Powered by Datasette · Query took 63.14ms · Data source: data.sfgov.org