sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
88826 22610 1 5 1001 Turk St 1 1 1 3     30 3X5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
120636 22615 1 5 1001 Turk St 6 1 1 3     24 3x5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
126289 22618 1 5 1001 Turk St 9 1 1 3     24 3x5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
10203 106598 3 5 1001X SAN JOSE AVE 11 3 1 2     21     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
39003 174984 2 5 1005 Madrid St 4 2 1 1     19 Width 4ft   6001116.49451 2088434.7952400001 37.7145074162652 -122.438036624391 (37.7145074162652, -122.438036624391)
167983 174983 2 5 1005 Madrid St 3 2 1 1     11 Width 4ft   6001103.82585 2088413.5291400002 37.7144483038197 -122.438078889846 (37.7144483038197, -122.438078889846)
57310 125264 2 5 1009 Green St 1 1 1 1     12 Width 3ft   6008170.85008 2118913.6211 37.79859397459521 -122.415810770352 (37.7985939745952, -122.415810770352)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
118559 3686 1 5 100X Cargo Way 1 11 1 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
38066 111168 2 5 100X Magnolia St 3 1 1 1     17 3x3   6003190.196690001 2119810.74673 37.8007759915841 -122.43310951858999 (37.8007759915841, -122.43310951859)
71650 111167 2 5 100X Magnolia St 2 1 1 1     12 3x3   6003205.803309999 2119813.99508 37.80078579597271 -122.433055745441 (37.8007857959727, -122.433055745441)
156773 111166 2 5 100X Magnolia St 1 1 1 1     16 3x3   6003221.39002 2119816.29205 37.800792986965796 -122.43300197316499 (37.8007929869658, -122.433001973165)
116268 42069 1 5 100X Ripley St 1 1 1 1 1 06/21/2000 12:00:00 AM 10 3x3 Permit Number 42381 6015269.0 2115673.0 37.790092461076604 -122.39102211089701 (37.7900924610766, -122.391022110897)
9391 24148 1 5 100X Whitney Young Cir 8 1 1 1     12 3x4   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
13458 24144 1 5 100X Whitney Young Cir 4 1 1 1     12 3X4   6016701.61434 2095161.25681 37.7338509755474 -122.38463593799999 (37.7338509755474, -122.384635938)
13870 24143 3 5 100X Whitney Young Cir 3 1 1 2     12 3x3   6016705.2095099995 2095147.06572 37.7338122084672 -122.38462252011999 (37.7338122084672, -122.38462252012)
14181 24141 1 5 100X Whitney Young Cir 1 1 1 1     9 3x3   6016711.43718 2095116.50195 37.733728630852795 -122.38459886076001 (37.7337286308528, -122.38459886076)
120584 24142 3 5 100X Whitney Young Cir 2 1 1 2     18 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
164024 120378 2 5 101 25th Ave 1 1 1 1     13 Width 2ft   5987994.967999999 2115215.60018 37.7872853847458 -122.485353306378 (37.7872853847458, -122.485353306378)
57184 120073 2 5 101 26th Ave 4 1 1 1     8 Width 3ft   5987689.48695 2115234.87158 37.787320497195 -122.48641160802299 (37.787320497195, -122.486411608023)
154594 120071 2 5 101 26th Ave 2 1 1 1     7 Width 3ft   5987688.6545 2115263.0140400003 37.787397719801604 -122.486416555063 (37.7873977198016, -122.486416555063)
186296 120072 2 5 101 26th Ave 3 1 1 1     8 Width 3ft   5987688.32967 2115247.71242 37.7873556870051 -122.486416555037 (37.7873556870051, -122.486416555037)
42043 188631 2 5 101 Charter Oak Ave 1 2 1 1     27     6010953.30174 2096155.7818599998 37.7362621559727 -122.404579676927 (37.7362621559727, -122.404579676927)
75315 188632 2 5 101 Charter Oak Ave 2 2 1 1     8     6010956.26861 2096182.79853 37.7363365038229 -122.404571320413 (37.7363365038229, -122.404571320413)
90217 115147 2 5 101 EXECUTIVE PARK BLVD 8 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
96999 115142 2 5 101 EXECUTIVE PARK BLVD 3 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
104010 115146 2 5 101 EXECUTIVE PARK BLVD 7 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
108315 115143 2 5 101 EXECUTIVE PARK BLVD 4 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
118266 115144 2 5 101 EXECUTIVE PARK BLVD 5 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
128837 115141 2 5 101 EXECUTIVE PARK BLVD 2 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
138505 115140 2 5 101 EXECUTIVE PARK BLVD 1 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
139204 115145 2 5 101 EXECUTIVE PARK BLVD 6 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
169297 175017 2 5 101 Nueva Ave 7 7 1 1     1 Width 4ft   6013060.88681 2087564.6207700002 37.712790132022704 -122.39669075108101 (37.7127901320227, -122.396690751081)
58205 188572 2 5 101 Pennsylvania Ave 22 7 1 1     1     6014321.6155199995 2106524.04213 37.764918870439 -122.39365939726801 (37.764918870439, -122.393659397268)
157254 188571 2 5 101 Pennsylvania Ave 19 7 1 1     1     6014323.12928 2106506.5800900003 37.764871007621004 -122.39365293923599 (37.764871007621, -122.393652939236)
174896 188573 2 5 101 Pennsylvania Ave 23 7 1 1     2     6014313.95748 2106525.31857 37.764921949722705 -122.393685974041 (37.7649219497227, -122.393685974041)
175480 188574 2 5 101 Pennsylvania Ave 24 7 1 1     1     6014321.12378 2106534.34369 37.7649471289393 -122.39366181916 (37.7649471289393, -122.39366181916)
116158 89312 1 5 101 Scott St 4 1 1 1   12/18/1969 12:00:00 AM   3x3 Permit Number 6484 6002340.0 2108819.0 37.7705471897255 -122.43526488371799 (37.7705471897255, -122.435264883718)
53119 175069 2 5 101 Woolsey St 6 17 1 1     20     6011573.1556 2092162.2260200002 37.7253313074768 -122.402155892479 (37.7253313074768, -122.402155892479)
179049 175068 2 5 101 Woolsey St 5 17 1 1     5     6011564.90281 2092154.99462 37.7253109908919 -122.402183913575 (37.7253109908919, -122.402183913575)
148953 140728 2 5 1010 FELL ST 1 1 1 1     21 Width 0ft   6002589.9611 2110263.1888 37.7745267665162 -122.434503543236 (37.7745267665162, -122.434503543236)
141304 7008 3 5 1010 Fell St 1 1 1 2     24 3X3   6002586.66205 2110263.38045 37.774527105466 -122.434514968983 (37.774527105466, -122.434514968983)
60424 125285 2 5 1015 Vallejo St 2 7 1 1     11     6008615.56594 2118630.81045 37.7978424372369 -122.41425188820699 (37.7978424372369, -122.414251888207)
15245 11544 3 5 101X Jennings St 34 1 1 2   12/23/1997 12:00:00 AM 3 3X3   6018840.43674 2097157.24182 37.7394496095988 -122.37737975539 (37.7394496095988, -122.37737975539)
138494 55211 1 5 101X Terra Vista Ave 1 1 1 1   09/18/1972 12:00:00 AM     Permit Number 775231 5999977.22784047 2112772.7148777 37.781268623734604 -122.44372179014601 (37.7812686237346, -122.443721790146)
14116 24108 3 5 101X Whitney Young Cir 15 1 1 2     12 3x3   6016610.88324 2095264.1891400001 37.7341285890533 -122.384956794538 (37.7341285890533, -122.384956794538)
104790 24131 3 5 101X Whitney Young Cir 2 1 1 2     12 3x3   6016408.932866001 2096090.6845669998 37.7363868071997 -122.38571259219101 (37.7363868071997, -122.385712592191)
106080 24133 3 5 101X Whitney Young Cir 4 1 1 2     18 3x3   6016408.932866001 2096090.6845669998 37.7363868071997 -122.38571259219101 (37.7363868071997, -122.385712592191)
111899 24132 3 5 101X Whitney Young Cir 3 1 1 2   09/21/2016 12:00:00 AM 18 3x3   6016408.932866001 2096090.6845669998 37.7363868071997 -122.38571259219101 (37.7363868071997, -122.385712592191)
99582 104425 2 5 101x WHITNEY YOUNG CIR 2 1 1 2     23 3x3   6016394.0 2096049.0 37.7362715234519 -122.38576131735901 (37.7362715234519, -122.385761317359)
76699 203232 2 5 102 Castenada Ave 1 2 1 1     21 Width 3ft   5994447.144830001 2101331.42465 37.7495368607335 -122.462023075825 (37.7495368607335, -122.462023075825)
63519 187749 2 5 1020 Griffith St 1 9 1 1     38     6018386.6897599995 2093315.1959 37.7288750976933 -122.378681918831 (37.7288750976933, -122.378681918831)
36572 125283 2 5 1022 Vallejo St 2 2 1 1     19     6008553.3357 2118652.52979 37.797898577410706 -122.414468760628 (37.7978985774107, -122.414468760628)
165268 125284 2 5 1022 Vallejo St 3 2 1 1     9     6008534.98172 2118654.3458 37.797902532623205 -122.414532399365 (37.7979025326232, -122.414532399365)
41859 203857 2 5 1025 Junipero Serra Blvd 6 1 1 1     13 Width 3ft   5991224.82027 2090017.2317599999 37.718284899813206 -122.47234118110201 (37.7182848998132, -122.472341181102)
76095 203859 2 5 1025 Junipero Serra Blvd 12 1 1 1     25 Width 3ft   5991237.16543 2090216.1679099998 37.718831844103704 -122.472313003552 (37.7188318441037, -122.472313003552)
153003 203858 2 5 1025 Junipero Serra Blvd 8 1 1 1     16 Width 3ft   5991229.23047 2090077.70959 37.718451212329505 -122.47233034336901 (37.7184512123295, -122.472330343369)
154993 203861 2 5 1025 Junipero Serra Blvd 18 2 1 1     18 Width 3ft   5991252.63127 2090414.4123799999 37.7193770697644 -122.472273988268 (37.7193770697644, -122.472273988268)
168689 203856 2 5 1025 Junipero Serra Blvd 4 1 1 1     16 Width 3ft   5991221.72934 2089959.84815 37.7181271596151 -122.47234768412399 (37.7181271596151, -122.472347684124)
184381 203860 2 5 1025 Junipero Serra Blvd 16 1 1 1     23 Width 3ft   5991248.87422 2090355.17031 37.719214188172 -122.472282658627 (37.719214188172, -122.472282658627)
47658 122239 2 5 103 Lake St 1 1 1 1     11 Width 4ft   5990148.768569999 2114703.4514200003 37.786004407716604 -122.47786423961901 (37.7860044077166, -122.477864239619)
129517 203738 2 5 1030 Ulloa St 2 1 1 1     14 Width 3ft   5992859.26291 2098454.84038 37.7415469455276 -122.467304836462 (37.7415469455276, -122.467304836462)
173417 203737 2 5 1030 Ulloa St 1 1 1 1     17 Width 3ft   5992875.8085900005 2098448.42334 37.741530281100104 -122.467247161152 (37.7415302811001, -122.467247161152)
164663 249542 2 5 1031 Franklin St 2 4 1 1     17 Width 4ft   6006025.644830001 2113728.66347 37.7842365454133 -122.422865173892 (37.7842365454133, -122.422865173892)
187271 249543 2 5 1031 Franklin St 4 4 1 1     20 Width 4ft   6006034.95999 2113672.91543 37.7840840006086 -122.42282898338699 (37.7840840006086, -122.422828983387)
4407 5225 3 5 1034 Divisadero St 1 1 1 2     18 3X3   6001461.1836 2111997.0255 37.779223304768 -122.43853244967698 (37.779223304768, -122.438532449677)
158909 125275 2 5 1036 Broadway 1 1 1 1     11 Width 3ft   6008484.892530001 2118308.52925 37.796950191958295 -122.41468123716801 (37.7969501919583, -122.414681237168)
93980 110202 2 5 1039 PAGE ST   8 1 1       4x5   6001572.7 2109358.5 37.771984919077 -122.43795762529301 (37.771984919077, -122.437957625293)
79636 103385 2 5 104 PRESIDIO AVE 4 1 1 1       3x3   5999013.0 2116197.0 37.79061577152721 -122.447304062173 (37.7906157715272, -122.447304062173)
92936 34180 1 5 104 Presidio Ave 1 1 1 1   06/05/1997 12:00:00 AM     Permit Number 38006 5998990.33122805 2116224.12146592 37.7906889445626 -122.447384447462 (37.7906889445626, -122.447384447462)
47506 124842 2 5 104 Retiro Way 1 1 1 1     8 Width 3ft   6001792.104119999 2121538.6526900004 37.8054409584916 -122.43807133554199 (37.8054409584916, -122.438071335542)
170752 124843 2 5 104 Retiro Way 2 1 1 1     6 Width 3ft   6001801.68917 2121551.89814 37.8054778720718 -122.438039114634 (37.8054778720718, -122.438039114634)
174897 124844 2 5 104 Retiro Way 3 1 1 1     6 Width 3ft   6001807.9499 2121561.96756 37.8055058760609 -122.438018170296 (37.8055058760609, -122.438018170296)
181186 175070 2 5 104 Woolsey St 2 17 1 1     14     6011561.993480001 2092186.33195 37.725396874350096 -122.40219617312599 (37.7253968743501, -122.402196173126)
19012 5575 3 5 1040 Dolores St 2 1 1 2     25 3X3   6005061.37186 2102302.0381 37.752807321807 -122.425387784834 (37.752807321807, -122.425387784834)
66689 187761 2 5 1040 Palou Ave 12 9 1 1     24     6017511.07328 2093334.4830599998 37.7288797462969 -122.381710357951 (37.7288797462969, -122.381710357951)
133165 187758 2 5 1040 Palou Ave 9 9 1 1     5     6017560.01516 2093300.23406 37.7287884075452 -122.38153877989299 (37.7287884075452, -122.381538779893)
149025 187760 2 5 1040 Palou Ave 11 9 1 1     17     6017527.04391 2093321.80664 37.7288458211654 -122.381654264546 (37.7288458211654, -122.381654264546)
156153 187757 2 5 1040 Palou Ave 8 9 1 1     23     6017577.45499 2093289.4287599998 37.7287597011768 -122.38147773753 (37.7287597011768, -122.38147773753)
165389 187759 2 5 1040 Palou Ave 10 9 1 1     32     6017547.84189 2093311.88395 37.7288197237472 -122.381581673978 (37.7288197237472, -122.381581673978)
107424 104714 2 5 1043 Francisco St 2 9 1 1           6006311.1 2120706.2 37.8034112154379 -122.42237353578301 (37.8034112154379, -122.422373535783)
122781 104713 2 5 1043 Francisco St 1 9 1 1           6006311.1 2120706.2 37.8034112154379 -122.42237353578301 (37.8034112154379, -122.422373535783)
130262 200159 2 5 1043 Ingerson Ave 1 19 1 1     9 Width 0ft   6013947.408 2089985.5634 37.719486864857004 -122.39379597620301 (37.719486864857, -122.393795976203)
31138 249446 2 5 1050 Ellis St 6 4 1 1     21 Width 5ft   6005679.55916 2113469.5737 37.7835056151439 -122.424044078095 (37.7835056151439, -122.424044078095)
67123 249442 2 5 1050 Ellis St 2 4 1 1     11 Width 4ft   6005782.21609 2113483.18621 37.783548787090105 -122.42368989267901 (37.7835487870901, -122.423689892679)
70092 249441 2 5 1050 Ellis St 1 4 1 1     21 Width 5ft   6005807.98079 2113486.28035 37.7835587371777 -122.42360097670601 (37.7835587371777, -122.423600976706)
29477 188598 2 5 1050 Wisconsin St 4 4 1 1     18 Width 5ft   6012781.12633 2102535.65122 37.7538819037331 -122.398707676819 (37.7538819037331, -122.398707676819)
60307 188597 2 5 1050 Wisconsin St 3 4 1 1     15 Width 5ft   6012781.38051 2102548.17796 37.7539163136043 -122.398707676835 (37.7539163136043, -122.398707676835)
10841 25393 3 5 1051 Geneva Ave 1 1 1 2     30 3X3   6001007.68114 2088741.24323 37.7153426652198 -122.438434668834 (37.7153426652198, -122.438434668834)
153621 175010 2 5 1051 Hester Ave 1 7 1 1     6     6012675.7431 2088120.44685 37.714294876771895 -122.39806090961001 (37.7142948767719, -122.39806090961)
175404 175011 2 5 1051 Hester Ave 2 7 1 1     12     6012671.33567 2088131.05018 37.7143237459272 -122.398076886938 (37.7143237459272, -122.398076886938)
9903 3758 3 5 1056 Carolina St 3 11 1 2     15 18   6012452.0863519 2103047.5184298 37.7552690413169 -122.399881522302 (37.7552690413169, -122.399881522302)
148612 245204 2 5 1058 Haight St 1 1 1 1     20 Width 0ft   6001022.4834 2109009.3407 37.7709949104145 -122.43983582345 (37.7709949104145, -122.43983582345)
107419 10359 3 5 1060 HAIGHT ST 1 1 1 2     28 3X4   6001056.0 2109004.0 37.770982153968 -122.439719505856 (37.770982153968, -122.439719505856)
72260 188721 2 5 1062 Key Ave 4 1 1 1     41 Width 5ft   6013117.817000001 2089964.07481 37.7193817246629 -122.396662082497 (37.7193817246629, -122.396662082497)
157071 125252 2 5 1067 Broadway 1 1 1 1     15 Width 3ft   6008499.87029 2118254.27562 37.7968020664151 -122.41462556911699 (37.7968020664151, -122.414625569117)
102363 112832 2 5 1068x BROADWAY 1 1 1 1     11 3x3   6008436.0 2118271.0 37.796844398836896 -122.41484776006399 (37.7968443988369, -122.414847760064)
179282 125250 2 5 1073 Broadway 1 1 1 1     7 Width 3ft   6008472.63138 2118248.82998 37.796785583654 -122.414719436774 (37.796785583654, -122.414719436774)
186711 125251 2 5 1073 Broadway 2 1 1 1     10 Width 2ft   6008484.56321 2118250.48158 37.7967907889218 -122.414678266696 (37.7967907889218, -122.414678266696)
9898 3765 3 5 1074 Carolina St 3 11 1 2     15 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.39986024500799 (37.7550481677782, -122.399860245008)
Powered by Datasette · Query took 17.717ms · Data source: data.sfgov.org