sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
334 246360 2 75 1932 Mission St 1 1 1 1     11 Width 0ft   6006755.8259 2107130.7038 37.76616130474321 -122.419870652653 (37.7661613047432, -122.419870652653)
2846 253262 2 75 2425 Ocean Ave 1 1 1 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
2856 253264 2 75 2425 Ocean Ave 3 1 1 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
4287 181059 2 75 5810 Mission St 1 1 1 1   10/10/2017 03:37:00 PM 3 Width 3ft   5997243.54219 2086644.28205 37.7093700633606 -122.451293980329 (37.7093700633606, -122.451293980329)
13185 98922 2 75 2507 21st Ave 1 1 1 1     19 6x6   5989831.2863 2098268.2421 37.7408593296697 -122.47776079641599 (37.7408593296697, -122.477760796416)
17840 105162 2 75 1600X OAKDALE AVE 1 1 1 1     15 5x5   6015006.0 2095503.0 37.734695414582795 -122.390522107646 (37.7346954145828, -122.390522107646)
23492 202174 2 75 100 Kalmanovitz St 1 2 1 1     21 Width 2ft   6013138.83373 2093054.0318599998 37.7278672922301 -122.39680594795401 (37.7278672922301, -122.396805947954)
23753 199483 2 75 1300 03rd St 4 1 1 1     13 Width 5ft   6015509.13182 2108964.41049 37.7716855044225 -122.38972250619801 (37.7716855044225, -122.389722506198)
23814 247646 2 75 900 Duboce Ave 2 4 1 1     13 Width 5ft   6001616.30949 2108303.20625 37.769089824469496 -122.43773118404499 (37.7690898244695, -122.437731184045)
23991 246367 2 75 1999 Mission St 4 1 1 1     8 Width 0ft   6006824.8887 2106890.3369 37.7655052042839 -122.41961472171002 (37.7655052042839, -122.41961472171)
24106 246790 2 75 175 Brewster St 10 2 1 1     8     6010136.6415 2098750.10917 37.74333994367979 -122.40758608083901 (37.7433399436798, -122.407586080839)
24537 217484 2 75 554 Mangels Ave 1 9 1 1     16     5997767.10933 2095284.1068799999 37.7331229743458 -122.450106772723 (37.7331229743458, -122.450106772723)
24682 203198 2 75 91 Market St 8 10 1 1     15 Width 10ft   6013828.57328 2116873.69458 37.7933092533841 -122.39609008760401 (37.7933092533841, -122.396090087604)
24790 199437 2 75 189 Hubbell St 15 1 1 1     18 Width 4ft   6013340.81155 2107445.60575 37.7673947300992 -122.397116397514 (37.7673947300992, -122.397116397514)
25192 203195 2 75 1998 Revere Ave 11 9 1 1     13     6012994.723999999 2096005.499 37.735963390387 -122.39751105148999 (37.735963390387, -122.39751105149)
25234 244842 2 75 41 Bartlett St 1 1 1 1     11 Width 6ft   6006681.50629 2103383.71332 37.755868755243704 -122.419861800707 (37.7558687552437, -122.419861800707)
25274 203174 2 75 331 Pennsylvania Ave 2 9 1 1     20 Width 7ft   6014370.72377 2105559.7788 37.7622739427176 -122.39342205628999 (37.7622739427176, -122.39342205629)
25608 246285 2 75 2109 Mission St 2 1 1 1     13 Width 0ft   6006870.1021 2106021.3241 37.763121645518204 -122.419396683437 (37.7631216455182, -122.419396683437)
26802 243938 2 75 315 Sanchez St 1 1 1 1     19 Width 3ft   6003592.012490001 2106424.54324 37.764043612453996 -122.43076326292 (37.764043612454, -122.43076326292)
27009 199444 2 75 1515 03rd St 1 1 1 1     20 Width 5ft   6015656.62698 2107992.23345 37.769024297155205 -122.389144413879 (37.7690242971552, -122.389144413879)
27058 247653 2 75 900 Duboce Ave 9 4 1 1     15 Width 5ft   6001528.81511 2108296.30035 37.7690658872209 -122.438033326596 (37.7690658872209, -122.438033326596)
27240 73535 2 75 2207 28th Ave 1 1 1 1 1 07/22/1995 12:00:00 AM 18     5987582.0279 2100272.2966 37.7462311393003 -122.485684839892 (37.7462311393003, -122.485684839892)
27436 244863 2 75 117 Prospect Ave 1 1 1 1     17 Width 3ft   6006906.41702 2098789.62543 37.7432671013094 -122.418758192246 (37.7432671013094, -122.418758192246)
27544 217486 2 75 134 Flood Ave 1 9 1 1     27 Width 10ft   5999850.54516 2094099.6824900003 37.729989823555705 -122.442818779256 (37.7299898235557, -122.442818779256)
27658 246312 2 75 1601 Mission St 7 1 1 1     13 Width 0ft   6007098.251 2109393.5574 37.7723938509682 -122.418846769596 (37.7723938509682, -122.418846769596)
27968 199441 2 75 189 Hubbell St 19 1 1 1     16 Width 4ft   6013426.97714 2107527.99953 37.767625761459705 -122.39682413764 (37.7676257614597, -122.39682413764)
28011 124342 2 75 105 Palm Ave 4 1 1 1     21 Width 4ft   5995870.42219 2113701.84259 37.7835846686773 -122.457996486135 (37.7835846686773, -122.457996486135)
28270 217447 2 75 395 Faxon Ave 3 9 1 1     17 Width 2ft   5994720.00419 2091109.04775 37.721484434931796 -122.460338956771 (37.7214844349318, -122.460338956771)
28387 199462 2 75 1530 03rd St 14 1 1 1     11 Width 5ft   6015592.103080001 2107492.64638 37.7676489630463 -122.389332708559 (37.7676489630463, -122.389332708559)
28662 247652 2 75 900 Duboce Ave 8 4 1 1     14 Width 5ft   6001539.54665 2108297.82153 37.7690706742937 -122.437996315894 (37.7690706742937, -122.437996315894)
29445 124343 2 75 105 Palm Ave 2 1 1 1     18 Width 4ft   5995870.59128 2113726.09219 37.7836512613147 -122.457997656644 (37.7836512613147, -122.457997656644)
29817 245984 2 75 2755 Mission St 1 1 1 1     13 Width 0ft   6007074.8359 2102333.0826 37.7530061148801 -122.418427042538 (37.7530061148801, -122.418427042538)
30281 181242 2 75 80 Blanken Ave 5 1 1 1     24 Width 4ft   6011652.37664 2087363.09382 37.7121582854612 -122.40154488951099 (37.7121582854612, -122.401544889511)
30691 244835 2 75 1880 Mission St 1 1 1 1     15 Width 5ft   6006729.90929 2107524.20157 37.7672402967355 -122.41998822018101 (37.7672402967355, -122.419988220181)
31002 203209 2 75 189 Hubbell St 10 1 1 1     16 Width 4ft   6013274.2221800005 2107384.36901 37.767222880462796 -122.39734242771401 (37.7672228804628, -122.397342427714)
31642 217485 2 75 616 Joost Ave 5 9 1 1     17 Width 10ft   5998040.52965 2095018.98025 37.7324106420337 -122.449142396404 (37.7324106420337, -122.449142396404)
31746 243915 2 75 527 Peralta Ave 1 1 1 1     14 Width 2ft   6009846.89705 2099022.9743 37.744072948723996 -122.408607191783 (37.744072948724, -122.408607191783)
31881 199455 2 75 1401 03rd St 7 1 1 1     17 Width 5ft   6015625.9056 2108540.0716 37.7705268376657 -122.389288938555 (37.7705268376657, -122.389288938555)
32638 199456 2 75 1279 03rd St 1 1 1 1     16 Width 5ft   6015610.82208 2108808.9255 37.77126421521471 -122.38935989056299 (37.7712642152147, -122.389359890563)
32803 243929 2 75 1409 Douglass St 1 9 1 1     15 Width 6ft   6001410.85086 2099557.6127299997 37.745064858666 -122.437815383076 (37.745064858666, -122.437815383076)
32830 203205 2 75 189 Hubbell St 6 1 1 1     16 Width 4ft   6013159.72459 2107270.14751 37.7669028782866 -122.397730448328 (37.7669028782866, -122.397730448328)
33231 181999 2 75 2474 30th Ave 9 2 1 1     14 Width 0ft   5987078.0557 2098396.6732 37.7410517986936 -122.487289748097 (37.7410517986936, -122.487289748097)
33282 217464 2 75 127 Beverly St 1 9 1 1     4 Width 10ft   5991405.11003 2090040.73714 37.7183598726973 -122.471719713607 (37.7183598726973, -122.471719713607)
33283 181264 2 75 271 Leland Ave 5 9 1 1     24 Width 3ft   6009517.64457 2087677.5938400002 37.712902490626895 -122.40894535574499 (37.7129024906269, -122.408945355745)
33501 199465 2 75 1530 03rd St 20 1 1 1     14 Width 5ft   6015601.020959999 2107350.5744 37.7672593587506 -122.389291940488 (37.7672593587506, -122.389291940488)
33585 137505 2 75 2521 Leavenworth St 2 1 1 1     17 Width 5ft   6007440.6556 2121042.48362 37.8043982179661 -122.41848851434601 (37.8043982179661, -122.418488514346)
33699 187438 2 75 4760 Mission St 2 1 1 1     15 Width 0ft   6001460.7844 2091113.675 37.721882594303395 -122.437038299541 (37.7218825943034, -122.437038299541)
33786 199476 2 75 1240 03rd St 3 1 1 1     15 Width 5ft   6015490.48538 2109320.84762 37.772663168207 -122.389811906894 (37.772663168207, -122.389811906894)
34386 199497 2 75 72 06th St 2 1 1 1     20 Width 4ft   6010024.2102 2112481.0403 37.7810356721041 -122.408943433887 (37.7810356721041, -122.408943433887)
34652 243942 2 75 701 Church St 8 7 1 1     22 Width 3ft   6004361.46086 2104388.80864 37.7584975338534 -122.427956893407 (37.7584975338534, -122.427956893407)
34846 243945 2 75 142 South Van Ness Ave 2 1 1 1     16 Width 3ft   6007159.400359999 2109389.15821 37.7723852147468 -122.41863493565901 (37.7723852147468, -122.418634935659)
35169 217430 2 75 1113 Kirkham St 4 1 1 1     18 Width 3ft   5991534.38297 2105188.62915 37.7599596057689 -122.47237655325 (37.7599596057689, -122.47237655325)
35626 199488 2 75 1300 03rd St 12 1 1 1     15 Width 5ft   6015518.167640001 2108801.30732 37.7712381600557 -122.38967985676099 (37.7712381600557, -122.389679856761)
35759 117922 2 75 683 41st Ave 1 9 1 1     15 Width 3ft   5983174.6969099995 2111166.71748 37.775886344567496 -122.501730482451 (37.7758863445675, -122.501730482451)
36034 187450 2 75 5098 Mission St 2 1 1 1     13 Width 0ft   6000319.4478 2089309.2863 37.7168632117114 -122.440854224757 (37.7168632117114, -122.440854224757)
36738 181277 2 75 0 Gonzalez Dr 6 2 1 1     11     5988402.74919 2089827.8491900002 37.7176011677477 -122.482081905481 (37.7176011677477, -122.482081905481)
36914 247654 2 75 900 Duboce Ave 10 4 1 1     15 Width 5ft   6001517.12711 2108295.57391 37.7690632279012 -122.438073702561 (37.7690632279012, -122.438073702561)
37483 217487 2 75 15 Staples Ave 2 9 1 1     7 Width 8ft   5999757.91748 2093744.86936 37.729010308071 -122.44311353116501 (37.729010308071, -122.443113531165)
38080 217478 2 75 51 Keystone Way 2 1 1 1     22 Width 3ft   5994094.09681 2093023.21308 37.7267042448879 -122.462641314769 (37.7267042448879, -122.462641314769)
38378 203183 2 75 1900 03rd St 28 1 1 1     10 Width 5ft   6015658.44629 2106386.7571400004 37.7646161091615 -122.38902601186001 (37.7646161091615, -122.38902601186)
38493 181278 2 75 46 Admiral Ave 2 9 1 1     9 Width 8ft   6003332.53306 2094181.6518 37.730412786411904 -122.430786976247 (37.7304127864119, -122.430786976247)
38749 181998 2 75 2476 30th Ave 8 2 1 1     15 Width 0ft   5987077.3789 2098389.2279 37.7410313164056 -122.48729154146099 (37.7410313164056, -122.487291541461)
38867 199498 2 75 1008 Mission St 1 1 1 1     20 Width 4ft   6010028.2471900005 2112434.38373 37.780907790314394 -122.40892617503 (37.7809077903144, -122.40892617503)
39038 203204 2 75 189 Hubbell St 5 1 1 1     15 Width 4ft   6013138.407819999 2107249.76439 37.766845723690096 -122.397802750202 (37.7668457236901, -122.397802750202)
39171 181241 2 75 80 Blanken Ave 4 1 1 1     17 Width 4ft   6011651.716019999 2087377.2812700002 37.712197204501294 -122.401548169322 (37.7121972045013, -122.401548169322)
39215 199440 2 75 189 Hubbell St 18 1 1 1     18 Width 4ft   6013418.56487 2107519.66805 37.767602416836 -122.396852650636 (37.767602416836, -122.396852650636)
39492 181267 2 75 271 Leland Ave 8 9 1 1     22 Width 3ft   6009562.93662 2087661.4051599998 37.7128605768164 -122.40878766951799 (37.7128605768164, -122.408787669518)
39669 118709 2 75 4201 Balboa St 7 1 1 1     15 Width 3ft   5982467.72104 2110969.09723 37.7753021852736 -122.504161410758 (37.7753021852736, -122.504161410758)
39967 199470 2 75 1050 03rd St 7 1 1 1     19 Width 5ft   6015462.75637 2109791.03207 37.7739526530238 -122.38994067543001 (37.7739526530238, -122.38994067543)
40393 244837 2 75 1880 Mission St 3 1 1 1     16 Width 5ft   6006731.37022 2107461.01908 37.7670668948411 -122.41997868286998 (37.7670668948411, -122.41997868287)
40464 199494 2 75 281 06th St 3 1 1 1     10 Width 4ft   6010924.085580001 2111634.58421 37.7787618676114 -122.405770660782 (37.7787618676114, -122.405770660782)
40524 246614 2 75 405 Precita Ave 1 10 1 1     3 Width 2ft   6009136.11989 2100236.51166 37.7473652210349 -122.411150613905 (37.7473652210349, -122.411150613905)
40665 244841 2 75 1880 Mission St 7 1 1 1     13 Width 5ft   6006736.38106 2107369.27612 37.766815272626296 -122.41995484006901 (37.7668152726263, -122.419954840069)
41031 182386 2 75 1538 35th Ave 1 2 1 1     5 Width 0ft   5985306.5492 2104723.6759 37.758320556835606 -122.493881037718 (37.7583205568356, -122.493881037718)
41272 243941 2 75 701 Church St 1 7 1 1     21 Width 3ft   6004362.39063 2104350.06977 37.758391218686796 -122.4279509174 (37.7583912186868, -122.4279509174)
41733 203194 2 75 1998 Revere Ave 10 9 1 1     16     6012994.12431 2096000.54159 37.7359497449792 -122.3975127773 (37.7359497449792, -122.3975127773)
42207 203193 2 75 47 Ceres St 2 4 1 1     17 Width 2ft   6013909.9694300005 2093925.2511200001 37.7303023748506 -122.39420106345301 (37.7303023748506, -122.394201063453)
42499 246350 2 75 1917 Mission St 2 1 1 1     10 Width 0ft   6006813.4383 2107178.9472 37.7662970152725 -122.419674805523 (37.7662970152725, -122.419674805523)
43216 203186 2 75 1501 25th St 25 2 1 1     4     6014234.68411 2101965.33677 37.752396820871894 -122.393640982742 (37.7523968208719, -122.393640982742)
43226 118483 2 75 8349 Geary Blvd 3 2 1 1     17     5981073.18846 2112308.0171 37.7788963529663 -122.50908477858499 (37.7788963529663, -122.509084778585)
43297 181269 2 75 37 Alpha St 1 9 1 1     17 Width 4ft   6011324.26316 2088509.61111 37.7152880772715 -122.402759532751 (37.7152880772715, -122.402759532751)
43387 247655 2 75 900 Duboce Ave 11 4 1 1     14 Width 5ft   6001504.48718 2108295.83572 37.769063227919105 -122.43811744198601 (37.7690632279191, -122.438117441986)
43953 249965 2 75 265 Filbert St 2 7 1 1     19 Width 0ft   6011638.85917 2120086.18138 37.802007891017205 -122.40389285566799 (37.8020078910172, -122.403892855668)
44059 199443 2 75 625 King St 23 2 1 1     24 Width 4ft   6012254.773469999 2108757.11148 37.7709353106325 -122.400965034535 (37.7709353106325, -122.400965034535)
44144 184617 2 75 1758 Lower Great Hwy 1 1 1 1     7 Width 0ft   5981057.9764 2103098.1394 37.753607806054 -122.508453540189 (37.753607806054, -122.508453540189)
44198 246412 2 75 3032 Mission St 1 1 1 1     8 Width 0ft   6007104.9213 2100736.786 37.7486247408195 -122.41820983567499 (37.7486247408195, -122.418209835675)
44242 181222 2 75 578 Madrid St 1 1 1 1     22 Width 3ft   6002385.20268 2090560.3971799999 37.720415918045795 -122.43380329969101 (37.7204159180458, -122.433803299691)
44370 137500 2 75 52 Iris Ave 1 9 1 1     5 Width 4ft   5997635.71873 2114163.76026 37.78495423950061 -122.451922604659 (37.7849542395006, -122.451922604659)
44421 199463 2 75 1530 03rd St 16 1 1 1     13 Width 5ft   6015595.21944 2107438.50948 37.7675004876899 -122.38931814851999 (37.7675004876899, -122.38931814852)
44429 244865 2 75 142 Highland Ave 1 10 1 1     4 Width 3ft   6005730.73165 2096631.6868599998 37.737275621771104 -122.42267009385401 (37.7372756217711, -122.422670093854)
44536 243947 2 75 142 South Van Ness Ave 4 1 1 1     15 Width 3ft   6007173.3402 2109359.55607 37.772304719112704 -122.418584616798 (37.7723047191127, -122.418584616798)
44785 243930 2 75 1351 Douglass St 2 9 1 1     18 Width 6ft   6001401.88208 2099729.52286 37.7455363732181 -122.437858706116 (37.7455363732181, -122.437858706116)
44790 244846 2 75 90 Bartlett St 9 2 1 1     11 Width 8ft   6006641.954969999 2103569.5656 37.75637683445171 -122.42001177073901 (37.7563768344517, -122.420011770739)
44869 199502 2 75 1012 Howard St 2 1 1 1     18 Width 4ft   6010449.4105 2111969.43782 37.7796547406221 -122.40743636892 (37.7796547406221, -122.40743636892)
45056 217450 2 75 127 Lee Ave 1 1 1 1     16 Width 3ft   5996493.32654 2090728.3649400002 37.720541019141706 -122.454181619786 (37.7205410191417, -122.454181619786)
45244 124344 2 75 105 Palm Ave 1 1 1 1     22 Width 4ft   5995869.2461 2113758.79509 37.7837409774514 -122.458004677882 (37.7837409774514, -122.458004677882)
45399 181238 2 75 80 Blanken Ave 1 1 1 1     15 Width 4ft   6011635.346940001 2087388.95322 37.7122283399444 -122.401605565857 (37.7122283399444, -122.401605565857)
45408 244813 2 75 45 Hoff St 3 1 1 1     20 Width 6ft   6006570.0042 2106423.3785 37.7642086856934 -122.42046316294599 (37.7642086856934, -122.420463162946)
46093 181993 2 75 2488 30th Ave 3 2 1 1     16 Width 0ft   5987080.4247 2098320.1899 37.7408419339653 -122.487275940676 (37.7408419339653, -122.487275940676)
47352 203175 2 75 2338 Lane St 3 7 1 1     10     6013915.08418 2092868.40903 37.7274007851107 -122.394109422506 (37.7274007851107, -122.394109422506)
47898 248076 2 75 405 Holladay Ave 1 9 1 1     18 Width 3ft   6010319.424219999 2098700.6468 37.7432143605434 -122.40695057673099 (37.7432143605434, -122.406950576731)
Powered by Datasette · Query took 5.548ms · Data source: data.sfgov.org