sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6955 23850 1 10 1401X Webster St 3 1 1 1     12 3X3   6003612.0155 2113606.6244 37.7837649741264 -122.43120675986401 (37.7837649741264, -122.431206759864)
7737 8094 1 10 762 Fulton St 5 1 1 19     100 3X3   6004211.6397 2111535.7715 37.7781128879326 -122.428984591665 (37.7781128879326, -122.428984591665)
8799 23802 1 10 1160 Webster St 3 1 1 1     70 3X3   6003829.6195 2112722.1937 37.7813488773836 -122.43039080821998 (37.7813488773836, -122.43039080822)
9878 14590 3 10 1221 Masonic Ave 2 1 1 2     45 3X3   5999397.8697 2108638.7231 37.7698846777669 -122.44542873681401 (37.7698846777669, -122.445428736814)
17417 14589 3 10 1221 Masonic Ave 1 1 1 2     90 3X3   5999408.7715 2108648.7165 37.769912739454604 -122.445391746523 (37.7699127394546, -122.445391746523)
18104 23633 3 10 198X Coleridge St 2 1 1 2     24 3X3   6006450.06706 2098653.35241 37.7428672213344 -122.42032646421801 (37.7428672213344, -122.420326464218)
18603 14356 3 10 299X Noe St 3 1 1 2     12 3X3   6002946.4626400005 2106656.3475200003 37.764643495314296 -122.43301259056801 (37.7646434953143, -122.433012590568)
20277 16663 3 10 207 Noe St 1 1 1 2     18 3X3   6002906.06809 2107042.07255 37.7657003111441 -122.43317986716002 (37.7657003111441, -122.43317986716)
20858 14357 3 10 299X Noe St 4 1 1 2     12 3X3   6002936.44481 2106655.1660700003 37.764639683102395 -122.43304715512899 (37.7646396831024, -122.433047155129)
21088 16664 3 10 207 Noe St 2 1 1 2     18 3X3   6002919.64524 2107042.50705 37.7657022743565 -122.433132937832 (37.7657022743565, -122.433132937832)
77925 5942 3 10 1155X Webster St 2 1 1 2     35 3X3   6003738.78415 2112752.38886 37.781426639976 -122.430707209452 (37.781426639976, -122.430707209452)
80650 23768 3 10 1001 Webster St 1 1 1 2     80 3X3   6003798.77229 2112300.9395 37.7801904708611 -122.430467458421 (37.7801904708611, -122.430467458421)
84578 23777 1 10 1006 Webster St 3 1 1 1     30 3X3   6003898.5093138 2112170.2011072 37.779837145034705 -122.430113093173 (37.7798371450347, -122.430113093173)
87397 14536 1 10 701X Masonic Ave 6 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
88708 17333 3 10 170 Otis St 1 1 1 2     18 3X3   6006561.617219999 2108839.89648 37.7708433996885 -122.420663729244 (37.7708433996885, -122.420663729244)
91056 17334 3 10 170 Otis St 2 1 1 2     18 3X3   6006561.617219999 2108839.89648 37.7708433996885 -122.420663729244 (37.7708433996885, -122.420663729244)
92924 14535 1 10 701X Masonic Ave 5 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
93994 17330 3 10 150 Otis St 6 1 1 2     18 3X3   6006661.1201948 2108857.0849494 37.770896202588 -122.420320765713 (37.770896202588, -122.420320765713)
94656 11004 3 10 40 Hudson Ave 1 1 1 2     12 3X3   6018314.1623349 2094585.1363671 37.7323581084588 -122.37902081553499 (37.7323581084588, -122.379020815535)
96160 23803 1 10 1160 Webster St 4 1 1 1     60 3X3   6003835.7537369 2112705.7306783 37.7813040215007 -122.430368411811 (37.7813040215007, -122.430368411811)
96659 10421 3 10 1219X Masonic Ave 4 1 1 2     50 3X3   5999421.35342 2108678.34127 37.7699947998181 -122.44535035645 (37.7699947998181, -122.44535035645)
98223 10420 3 10 1219X Masonic Ave 3 1 1 2     100 3X3   5999405.64403 2108687.20317 37.7700182355876 -122.445405332062 (37.7700182355876, -122.445405332062)
98415 23782 1 10 1010 Webster St 2 1 1 1     35 3X3   6003903.8361546 2112182.8886988997 37.7798722837048 -122.430095570639 (37.7798722837048, -122.430095570639)
100980 14347 3 10 299X Noe St 11 1 1 2     18 3X3   6002931.216347099 2106726.8081779 37.7648360983599 -122.43307035800699 (37.7648360983599, -122.433070358007)
101591 11007 3 10 60 Hudson Ave 1 1 1 2     12 3X3   6018282.6314 2094636.8214067002 37.7324982868599 -122.379133414916 (37.7324982868599, -122.379133414916)
104401 17335 3 10 170 Otis St 3 1 1 2     18 3X3   6006561.617219999 2108839.89648 37.7708433996885 -122.420663729244 (37.7708433996885, -122.420663729244)
105887 16639 3 10 159 Noe St 1 1 1 2     18 3X3   6002897.330053501 2107339.8890724997 37.766517547095106 -122.43323137202299 (37.7665175470951, -122.433231372023)
105990 11009 3 10 80 Hudson Ave 1 1 1 2     18 3X3   6018206.0401963 2094670.6666495 37.7325869956158 -122.379400561989 (37.7325869956158, -122.379400561989)
107352 22668 3 10 1150X Webster St 3 1 1 2     60 3X3   6003840.4795818 2112671.8469471 37.781211252908896 -122.43034964448499 (37.7812112529089, -122.430349644485)
107403 14539 1 10 701X Masonic Ave 9 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
110605 23778 3 10 1006 Webster St 4 1 1 2   05/19/1992 12:00:00 AM 40 3X3   6003898.5093138 2112170.2011072 37.779837145034705 -122.430113093173 (37.7798371450347, -122.430113093173)
110610 23784 3 10 1010 Webster St 4 1 1 2     40 3X3   6003903.8361546 2112182.8886988997 37.7798722837048 -122.430095570639 (37.7798722837048, -122.430095570639)
110819 11005 3 10 50 Hudson Ave 1 1 1 2     12 3X3   6018298.396867501 2094610.9788869 37.7324281976732 -122.37907711517201 (37.7324281976732, -122.379077115172)
111363 17997 3 10 2650X Pine St 5 1 1 2     18 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
111750 14345 3 10 299X Noe St 9 1 1 2     12 3X3   6002931.216347099 2106726.8081779 37.7648360983599 -122.43307035800699 (37.7648360983599, -122.433070358007)
112962 14532 1 10 701X Masonic Ave 2 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
113693 23776 1 10 1006 Webster St 2 1 1 1     30 3X3   6003898.5093138 2112170.2011072 37.779837145034705 -122.430113093173 (37.7798371450347, -122.430113093173)
114709 17331 3 10 150 Otis St 7 1 1 2     24 3X3   6006645.84304 2108796.58735 37.7707292297079 -122.420369315185 (37.7707292297079, -122.420369315185)
115922 10410 3 10 1154 MASONIC AVE 1 1 1 2     28 3X3   5999422.7 2108913.3 37.770640013924606 -122.44536259510099 (37.7706400139246, -122.445362595101)
116039 14534 1 10 701X Masonic Ave 4 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
116404 14355 3 10 299X Noe St 2 1 1 2     12 3X3   6002931.216347099 2106726.8081779 37.7648360983599 -122.43307035800699 (37.7648360983599, -122.433070358007)
119571 14537 1 10 701X Masonic Ave 7 1 1 12     70 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
119891 14538 1 10 701X Masonic Ave 8 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
120313 14531 1 10 701X Masonic Ave 1 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
122617 11001 3 10 20 Hudson Ave 1 1 1 2     18 3X3   6018345.6932697 2094533.4513275002 37.7322179299469 -122.37890821657899 (37.7322179299469, -122.378908216579)
123057 23785 3 10 1085X Webster St 1 1 1 2   05/25/2016 12:00:00 AM 3 3X3   6003779.292648099 2112432.2054737 37.780549791072005 -122.430544216434 (37.780549791072, -122.430544216434)
123076 23781 1 10 1010 Webster St 1 1 1 1     20 3X3   6003903.8361546 2112182.8886988997 37.7798722837048 -122.430095570639 (37.7798722837048, -122.430095570639)
124314 14533 1 10 701X Masonic Ave 3 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
124676 5941 3 10 1155X Webster St 1 1 1 2     15 3X3   6003735.29014 2112772.66113 37.7814821046204 -122.43072074410699 (37.7814821046204, -122.430720744107)
139945 16657 3 10 201 Noe St 1 1 1 2     24 3X3   6002910.8788077 2107093.8667075 37.765842798192395 -122.433166929024 (37.7658427981924, -122.433166929024)
141516 5943 1 10 1407 Eddy St 1 1 1 1     12 3X3   6003673.95863 2112759.04875 37.781441253516704 -122.430931949696 (37.7814412535167, -122.430931949696)
141650 14346 3 10 299X Noe St 10 1 1 2     12 3X3   6002931.216347099 2106726.8081779 37.7648360983599 -122.43307035800699 (37.7648360983599, -122.433070358007)
142013 23800 3 10 1160 Webster St 1 1 1 2     40 3X3   6003835.7537369 2112705.7306783 37.7813040215007 -122.430368411811 (37.7813040215007, -122.430368411811)
142548 16658 3 10 201 Noe St 2 1 1 2     24 3X3   6002910.8788077 2107093.8667075 37.765842798192395 -122.433166929024 (37.7658427981924, -122.433166929024)
17793 16659 1 10 201 Noe St 1 1 1 1     18 3X4   6002918.29496 2107052.8377799997 37.765730563431894 -122.43313834635 (37.7657305634319, -122.43313834635)
85524 11012 3 10 95 Hudson Ave 2 1 1 2     12 3X4   6018177.8841382 2094612.4287261001 37.7324255328509 -122.37949386114599 (37.7324255328509, -122.379493861146)
95235 11010 3 10 85 Hudson Ave 1 1 1 2     12 3X4   6018199.1590574 2094619.5131788002 37.7324461587057 -122.379420799908 (37.7324461587057, -122.379420799908)
97084 11013 3 10 95 Hudson Ave 3 1 1 2     18 3X4   6018177.8841382 2094612.4287261001 37.7324255328509 -122.37949386114599 (37.7324255328509, -122.379493861146)
117497 11002 3 10 25 Hudson Ave 1 1 1 2     12 3X4   6018294.3685242 2094521.575214 37.7321824905391 -122.379084835175 (37.7321824905391, -122.379084835175)
118584 10550 3 10 217 Harbor Rd 1 1 1 2   02/12/1992 12:00:00 AM 12 3X4   6018348.7736836 2094772.4250311002 37.7328742748645 -122.378914156582 (37.7328742748645, -122.378914156582)
124482 10997 3 10 3X Hudson Ave 1 1 1 2     18 3X4   6018318.9881754005 2094475.1533634998 37.732056382705004 -122.378996495822 (37.732056382705, -122.378996495822)
128617 10559 3 10 266 Harbor Rd 1 1 1 2   02/12/1992 12:00:00 AM 18 3X4   6018220.577079 2094928.7869737998 37.733296545147795 -122.379368227321 (37.7332965451478, -122.379368227321)
142601 11006 3 10 55 Hudson Ave 1 1 1 2     18 3X4   6018247.9816681 2094597.6118588 37.7323887144105 -122.37925048612 (37.7323887144105, -122.37925048612)
1657 251641 3 10 1785 Webster St 2 1 1 2       3x3   6003432.0 2114811.0 37.787061682920395 -122.43191557230301 (37.7870616829204, -122.431915572303)
1662 251640 3 10 1785 Webster St 1 1 1 2       3x3   6003432.0 2114811.0 37.787061682920395 -122.43191557230301 (37.7870616829204, -122.431915572303)
4297 50999 1 10 3000X Jackson St 1 1 1 1   08/31/2010 12:00:00 AM 3 3x3 Permit Number 774202 5999788.70466 2116412.94537 37.7912529948724 -122.444635704772 (37.7912529948724, -122.444635704772)
5689 51000 1 10 3000X Jackson St 2 1 1 1   08/31/2010 12:00:00 AM 3 3x3 Permit Number 774202 5999777.56327 2116411.2536400002 37.7912477140612 -122.444674131902 (37.7912477140612, -122.444674131902)
9109 23140 1 10 1621X Church St 1 1 1 1     40 3x3   6004632.02812 2099337.8259 37.744644014501205 -122.42666146912599 (37.7446440145012, -122.426661469126)
18178 4495 3 10 1618 Church St 1 1 1 2   11/02/1990 12:00:00 AM 18 3x3   6004570.56721 2099356.4076799997 37.744691560861895 -122.426875312064 (37.7446915608619, -122.426875312064)
18383 4503 3 10 1767 Church St 1 1 1 2     12 3x3   6004674.71192 2098595.28716 37.742607586167395 -122.42646101595601 (37.7426075861674, -122.426461015956)
23227 2679 3 10 2085 Bush St 1 1 1 2     16 3x3   6003592.8137 2114862.3516 37.7872117965975 -122.43136285998101 (37.7872117965975, -122.431362859981)
39523 103291 2 10 50 Francisco St 5 1 1 1     18 3x3   6011052.07349 2121439.56361 37.8056911462811 -122.406018820613 (37.8056911462811, -122.406018820613)
41509 54991 1 10 646 16th Ave 1 1 1 1   09/12/1972 12:00:00 AM 13 3x3 Permit Number 10869 5990991.81393 2111001.00614 37.7758874082105 -122.474677239765 (37.7758874082105, -122.474677239765)
52681 103293 2 10 50 Francisco St 7 1 1 1     21 3x3   6010999.50344 2121432.93356 37.80567000143571 -122.406200280445 (37.8056700014357, -122.406200280445)
53721 103292 2 10 50 Francisco St 6 1 1 1     17 3x3   6011032.30685 2121439.6325 37.8056902298748 -122.40608723115601 (37.8056902298748, -122.406087231156)
80688 14354 1 10 299X Noe St 1 1 1 1   09/06/2016 12:00:00 AM 3 3x3 Permit Number 778955 6002931.216347099 2106726.8081779 37.7648360983599 -122.43307035800699 (37.7648360983599, -122.433070358007)
82292 21704 3 10 1710X Webster St 6 1 1 2     50 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
84315 21700 1 10 1710X Webster St 2 1 1 1     40 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
85744 16627 3 10 144 Noe St 3 1 1 2     12 3x3   6002842.6673683 2107423.1988343 37.7667431942981 -122.43342639426099 (37.7667431942981, -122.433426394261)
87820 21706 3 10 1710X Webster St 8 1 1 2     40 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
88273 120870 2 10 815 Duboce Ave 1 1 1 1     36 3x3   6001854.0 2108207.0 37.768839178210705 -122.436902139783 (37.7688391782107, -122.436902139783)
94677 104328 2 10 21 Beaver St 1 1 1 1       3x3 Permit Number 770906 6002767.0 2106786.0 37.76498930837 -122.433642570245 (37.76498930837, -122.433642570245)
97851 21701 3 10 1710X Webster St 3 1 1 2     40 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
101948 107386 2 10 26x BLANKEN AVE 1 1 1 1     22 3x3   6011510.0 2087367.0 37.712161065506 -122.402037262127 (37.712161065506, -122.402037262127)
102315 21703 3 10 1710X Webster St 5 1 1 2     50 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
108953 8080 3 10 677 Fulton St 1 1 1 2     24 3x3   6004653.03771 2111392.08692 37.7777433402869 -122.427447397341 (37.7777433402869, -122.427447397341)
108985 33805 1 10 751 Cole St 1 1 1 1   12/24/1996 12:00:00 AM   3x3 Permit Number 37823 5997939.03141438 2107846.29922309 37.7676254964359 -122.45041766938401 (37.7676254964359, -122.450417669384)
118966 8065 3 10 631 Fulton St 1 1 1 2     26 3x3   6004732.981000001 2111553.11801 37.7781900132645 -122.427182319007 (37.7781900132645, -122.427182319007)
121359 103287 2 10 50 Francisco St 1 1 1 1       3x3   6011114.9 2121460.0 37.805750773231004 -122.40580283963699 (37.805750773231, -122.405802839637)
128834 1324 3 10 4051X Alemany Blvd 1 1 1 2     50 3x3   5991764.76245 2086963.37686 37.709930989883496 -122.47025258193399 (37.7099309898835, -122.470252581934)
138391 21699 3 10 1710X Webster St 1 1 1 2     40 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
144856 21705 3 10 1710X Webster St 7 1 1 2     50 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
145998 8081 3 10 679 Fulton St 1 1 1 2     12 3x3   6004653.03771 2111392.08692 37.7777433402869 -122.427447397341 (37.7777433402869, -122.427447397341)
149599 103034 1 10 646 16th Ave 2 1 1 1     8 3x3   5990990.666019999 2111015.32542 37.775926658519296 -122.474682255974 (37.7759266585193, -122.474682255974)
154368 103290 2 10 50 Francisco St 4 1 1 1     17 3x3   6011095.04469 2121443.6930299997 37.8057048879202 -122.405870402816 (37.8057048879202, -122.405870402816)
160824 103289 2 10 50 Francisco St 3 1 1 1     16 3x3   6011124.97439 2121449.08907 37.805721377897 -122.40576720650101 (37.805721377897, -122.405767206501)
163756 103288 2 10 50 Francisco St 2 1 1 1     14 3x3   6011153.48298 2121450.51033 37.8057268745504 -122.405668647988 (37.8057268745504, -122.405668647988)
178588 112518 2 10 1849 Lyon St 1 1 1 1     18 3x3   5999474.66705 2115314.93957 37.7882202345095 -122.44564326833401 (37.7882202345095, -122.445643268334)
2038 23713 1 10 709 Webster St 1 1 1 1     25 4X4   6003942.7402 2111225.1787 37.7772448524761 -122.429892651683 (37.7772448524761, -122.429892651683)
2242 23928 3 10 1715 Webster St 2 1 1 2     70 4X4   6003464.0168 2114669.7894 37.7866757692841 -122.431794715065 (37.7866757692841, -122.431794715065)
3202 14513 3 10 501 Masonic Ave 1 1 1 2     100 4X4   5999073.0679 2111076.7771 37.776560404910796 -122.4467276636 (37.7765604049108, -122.4467276636)
Powered by Datasette · Query took 7.655ms · Data source: data.sfgov.org