sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
96595 106311 6 71 99X Clearfield Dr 5 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
101397 87015 1 71 35 Whitfield Ct 2 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.38165350279101 (37.7310090102049, -122.381653502791)
102481 114925 2 71 4400x OCEAN AVE 3 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103199 114934 2 71 4400x OCEAN AVE 10 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103326 96843 1 71 417 Dewey Blvd 3 1 1 1           5995136.0 2100316.9 37.7467908665237 -122.45956754031602 (37.7467908665237, -122.459567540316)
104763 105268 1 71 842X GONZALEZ DR 1 2 1 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
106088 91502 1 71 1501@Clearfield Sloat Blvd 12 1 1 1   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
107755 94230 1 71 1501@Everglade Sloat Blvd 9 9 1 1   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
108306 96844 1 71 417 Dewey Blvd 4 1 1 1           5995136.0 2100316.9 37.7467908665237 -122.45956754031602 (37.7467908665237, -122.459567540316)
109599 98161 6 71 600 Front St   7 1 1   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.39944985704099 (37.7974274520849, -122.399449857041)
109790 100068 1 71 303 Serrano Dr 1 1 1 1   07/13/2012 12:00:00 AM     Permit Number 769006 5990392.0 2090762.0 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247)
110779 98279 1 71 900 Brotherhood Way 501 2 1 1   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.48041912379101 (37.7146559434524, -122.480419123791)
114243 115834 2 71 900X LAKE MERCED BLVD 2 11 1 1   08/30/2016 12:00:00 AM 3 10x100 Permit Number 777492 5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844)
114533 87835 1 71 1501@Ocean Sloat Blvd 11 1 1 1   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
115433 186889 2 71 2700 Sunset Blvd 38 9 1 1     2 Width 0ft   5985183.3004 2096502.846 37.7357411821318 -122.49370150858101 (37.7357411821318, -122.493701508581)
116587 94232 1 71 1501@Ocean Sloat Blvd 12 9 1 1   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
116918 211018 2 71 700 Junipero Serra Blvd 55 4 1 1     3 Width 0ft   5991237.26366 2092440.87353 37.7249403415953 -122.472474765495 (37.7249403415953, -122.472474765495)
119505 114372 2 71 821 GONZALEZ DR 3 2 1 1     3     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061)
120091 234474 2 71 72 Santa Marina St 2 1 1 1     12 Width 3ft   6006078.82979 2097595.56477 37.739941848150394 -122.421534992063 (37.7399418481504, -122.421534992063)
120538 87017 1 71 1200 Oakdale Ave 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304)
120617 114370 2 71 821 GONZALEZ DR 1 2 1 1     2     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061)
122533 87014 1 71 35 Whitfield Ct 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.38165350279101 (37.7310090102049, -122.381653502791)
123578 114260 2 71 800x BROTHERHOOD WAY 1 8 1 1     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
123850 107158 2 71 101x Elsie St 1 14 1 1     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614)
125758 114378 1 71 842X GONZALEZ DR 3 2 1 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
127115 178176 2 71 0 Gonzalez Dr 3 2 1 1     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325)
130721 178158 2 71 10 Brotherhood Way 13 4 1 1     5 Width 0ft   5993255.20411 2087840.2590599998 37.7124247572585 -122.465165024673 (37.7124247572585, -122.465165024673)
130784 178165 2 71 10 Brotherhood Way 20 4 1 1     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667)
132551 211019 2 71 700 Junipero Serra Blvd 71 4 1 1     3 Width 0ft   5991242.8983 2092280.74938 37.724501006592895 -122.472443619273 (37.7245010065929, -122.472443619273)
132856 178174 2 71 0 Gonzalez Dr 5 2 1 1     2     5988358.3694 2089791.63303 37.717499145949 -122.48223265254101 (37.717499145949, -122.482232652541)
133473 211020 2 71 700 Junipero Serra Blvd 74 4 1 1     4 Width 0ft   5991248.48231 2092260.69315 37.7244462603628 -122.472422854829 (37.7244462603628, -122.472422854829)
134128 178133 2 71 20 Brotherhood Way 4 4 1 1     6 Width 0ft   5992553.46677 2087849.4362400002 37.7124094643071 -122.467591088862 (37.7124094643071, -122.467591088862)
134503 178140 2 71 20 Brotherhood Way 11 4 1 1     6 Width 0ft   5992153.764330001 2087899.9141099998 37.712524978625005 -122.46897624088301 (37.712524978625, -122.468976240883)
135334 184982 2 71 2701 Sunset Blvd 8 9 1 1     1 Width 0ft   5984985.373 2096691.7859999998 37.7362483795762 -122.494399733702 (37.7362483795762, -122.494399733702)
135899 211034 2 71 417 Dewey Blvd 2 2 1 1     15 Width 3ft   5995115.077769999 2100328.51022 37.746821542199996 -122.45964072765 (37.7468215422, -122.45964072765)
136097 185539 2 71 2201 Sunset Blvd 23 9 1 1     1 Width 0ft   5984878.3804 2100042.8891 37.7454433428019 -122.495016669314 (37.7454433428019, -122.495016669314)
136877 181519 2 71 1400 Sunset Blvd 79 9 1 1     2 Width 0ft   5984899.8047 2105606.7824 37.76072151501489 -122.49535284581002 (37.7607215150149, -122.49535284581)
137218 211026 2 71 700 Junipero Serra Blvd 138 4 1 1     4 Width 0ft   5991196.61305 2091604.8062200001 37.7226423552448 -122.472554361808 (37.7226423552448, -122.472554361808)
137509 187121 2 71 2600 Sunset Blvd 57 9 1 1     2 Width 0ft   5985174.7424 2097328.4139 37.7380074703554 -122.493791914706 (37.7380074703554, -122.493791914706)
141881 94235 1 71 1501@Clearfield Sloat Blvd 9 9 1 1   06/28/2010 12:00:00 AM 27   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
142007 106310 6 71 99X Clearfield Dr 4 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
144047 108298 1 71 10X Greenwich St 1 7 1 1   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830.0 2116175.0 37.791335193350896 -122.399496166675 (37.7913351933509, -122.399496166675)
145855 122584 2 71 2500X Lyon St 4 11 1 1     11 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
146720 178155 2 71 10 Brotherhood Way 10 4 1 1     6 Width 0ft   5993366.44396 2087810.43567 37.71234928345479 -122.46477838452499 (37.7123492834548, -122.464778384525)
146741 211030 2 71 700 Junipero Serra Blvd 165 4 1 1     4 Width 0ft   5991183.72988 2091349.85826 37.7219415855123 -122.47258031712099 (37.7219415855123, -122.472580317121)
147538 186878 2 71 2700 Sunset Blvd 27 9 1 1     1 Width 0ft   5985170.4646 2096439.5838 37.7355667300556 -122.493741225987 (37.7355667300556, -122.493741225987)
148698 211010 2 71 500 Junipero Serra Blvd 27 4 1 1     3 Width 0ft   5991339.1010300005 2093646.61822 37.728256910008895 -122.47221057976601 (37.7282569100089, -122.472210579766)
150068 178148 2 71 20 Brotherhood Way 19 4 1 1     5 Width 0ft   5991783.61367 2087988.3395200002 37.712746380014295 -122.47026201958299 (37.7127463800143, -122.470262019583)
150293 178166 2 71 10 Brotherhood Way 21 4 1 1     5 Width 0ft   5992891.51235 2087851.5166099998 37.7124346884767 -122.466422861421 (37.7124346884767, -122.466422861421)
151346 132160 2 71 1141 Chestnut St 5 7 1 1     20     6006382.37262 2120397.93248 37.802568811663605 -122.422104980572 (37.8025688116636, -122.422104980572)
151728 200146 2 71 6101 03rd St 2 1 1 1     22 Width 0ft   6013586.8559 2091305.2042 37.7230902914135 -122.395134667477 (37.7230902914135, -122.395134667477)
152330 211015 2 71 500 Junipero Serra Blvd 78 4 1 1     3 Width 0ft   5991307.93934 2093199.2311 37.727026693213794 -122.47228570643101 (37.7270266932138, -122.472285706431)
152650 178139 2 71 20 Brotherhood Way 10 4 1 1     6 Width 0ft   5992188.74587 2087889.2446599999 37.7124977039766 -122.468854559004 (37.7124977039766, -122.468854559004)
153955 185290 2 71 2601 Sunset Blvd 15 9 1 1     2 Width 0ft   5984983.8028 2097379.2257 37.738135813056005 -122.494455822202 (37.738135813056, -122.494455822202)
155336 178160 2 71 10 Brotherhood Way 15 4 1 1     6 Width 0ft   5993144.356269999 2087854.16093 37.712456535710395 -122.465549154771 (37.7124565357104, -122.465549154771)
155635 194423 2 71 132 Kissling St 2 2 1 1     17 Width 5ft   6007917.867000001 2109077.33792 37.771571702413 -122.41598923453002 (37.771571702413, -122.41598923453)
156194 178141 2 71 20 Brotherhood Way 12 4 1 1     5 Width 0ft   5992021.87667 2087934.24208 37.7126116138994 -122.46943457854401 (37.7126116138994, -122.469434578544)
156327 185563 2 71 2201 Sunset Blvd 47 9 1 1     1 Width 0ft   5984887.6667 2099768.5458 37.7446906142612 -122.49496433430599 (37.7446906142612, -122.494964334306)
156435 178169 2 71 10 Brotherhood Way 24 4 1 1     6 Width 0ft   5992786.910569999 2087851.5448200002 37.7124287295635 -122.466784396099 (37.7124287295635, -122.466784396099)
156453 211011 2 71 500 Junipero Serra Blvd 34 4 1 1     3 Width 0ft   5991335.35345 2093583.37833 37.728083052188104 -122.47221892726499 (37.7280830521881, -122.472218927265)
156892 211023 2 71 700 Junipero Serra Blvd 83 4 1 1     5 Width 0ft   5991239.95465 2092188.59606 37.7242478060794 -122.472447079879 (37.7242478060794, -122.472447079879)
156955 211039 2 71 52 Burnside Ave 10 9 1 1     23     6001157.31367 2095726.26325 37.7345304511011 -122.438417622186 (37.7345304511011, -122.438417622186)
157213 211033 2 71 417 Dewey Blvd 3 2 1 1     17 Width 3ft   5995123.84893 2100332.4468799997 37.746832855650396 -122.459610683101 (37.7468328556504, -122.459610683101)
157592 185023 2 71 2701 Sunset Blvd 49 9 1 1     2 Width 0ft   5985046.0879999995 2096329.59 37.735257439095705 -122.49416313243499 (37.7352574390957, -122.494163132435)
157655 178162 2 71 10 Brotherhood Way 17 4 1 1     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.46579770942301 (37.7124585223038, -122.465797709423)
158981 211037 2 71 61 Burnside Ave 4 9 1 1     16     6001183.29295 2095747.84811 37.734591195811795 -122.438329349227 (37.7345911958118, -122.438329349227)
159159 178170 2 71 0 Serrano Dr 4 2 1 1     4     5989035.58475 2090454.3423900001 37.719358148051796 -122.479940326497 (37.7193581480518, -122.479940326497)
159459 234473 2 71 99 Elsie St 2 10 1 1     16     6007295.70063 2098744.01488 37.7431637754778 -122.417408915989 (37.7431637754778, -122.417408915989)
159660 186880 2 71 2700 Sunset Blvd 29 9 1 1     14 Width 0ft   5985201.1788 2096460.2128 37.73562516865071 -122.49363655642 (37.7356251686507, -122.49363655642)
159854 247525 2 71 1101 Waller St 6 17 1 1     2     6000029.935269999 2108491.2793400004 37.7695158962756 -122.443231851395 (37.7695158962756, -122.443231851395)
160510 234472 2 71 4810 17th St 1 9 1 1     28 Width 2ft   5998175.60392 2105685.14055 37.7617050378737 -122.44944366388701 (37.7617050378737, -122.449443663887)
160627 186893 2 71 2700 Sunset Blvd 42 9 1 1     1 Width 0ft   5985181.9251 2096557.8565 37.7358921458374 -122.493710315825 (37.7358921458374, -122.493710315825)
160645 178163 2 71 10 Brotherhood Way 18 4 1 1     5 Width 0ft   5993033.97644 2087855.7565900001 37.712454549997204 -122.465930773993 (37.7124545499972, -122.465930773993)
161140 178136 2 71 20 Brotherhood Way 7 4 1 1     5 Width 0ft   5992351.132540001 2087854.27594 37.7124110686957 -122.468290763208 (37.7124110686957, -122.468290763208)
161248 186247 2 71 1701 Sunset Blvd 58 9 1 1     1 Width 0ft   5984819.3113 2103171.6078 37.754030488698895 -122.49545162726801 (37.7540304886989, -122.495451627268)
161339 178145 2 71 20 Brotherhood Way 16 4 1 1     4 Width 0ft   5991905.80045 2087967.0692099999 37.71269504040679 -122.469838159212 (37.7126950404068, -122.469838159212)
161740 178134 2 71 20 Brotherhood Way 5 4 1 1     5 Width 0ft   5992424.40969 2087850.98169 37.7124062555176 -122.46803725782699 (37.7124062555176, -122.468037257827)
162182 178153 2 71 10 Brotherhood Way 8 4 1 1     7 Width 0ft   5993495.89449 2087748.40295 37.712186418929896 -122.464326467118 (37.7121864189299, -122.464326467118)
162875 211022 2 71 700 Junipero Serra Blvd 80 4 1 1     3 Width 0ft   5991230.5084 2092239.13983 37.7243860399747 -122.47248341699101 (37.7243860399747, -122.472483416991)
163106 185033 2 71 2701 Sunset Blvd 59 9 1 1     1 Width 0ft   5985049.8565 2096299.4419 37.7351748809707 -122.494147882197 (37.7351748809707, -122.494147882197)
163628 178129 2 71 345 Tocoloma Ave 1 9 1 1     4 Width 8ft   6012554.38724 2086809.43241 37.7106883309719 -122.398388432799 (37.7106883309719, -122.398388432799)
164388 234478 2 71 398 Surrey St 2 9 1 1     30 Width 5ft   6001098.400769999 2096167.19905 37.7357378071451 -122.43865288754 (37.7357378071451, -122.43865288754)
164480 185307 2 71 2601 Sunset Blvd 32 9 1 1     1 Width 0ft   5984973.1253 2097316.8359 37.7379638824881 -122.494488141215 (37.7379638824881, -122.494488141215)
164811 178154 2 71 10 Brotherhood Way 9 4 1 1     7 Width 0ft   5993415.347159999 2087786.9851099998 37.7122877131728 -122.464607659932 (37.7122877131728, -122.464607659932)
166214 181513 2 71 1400 Sunset Blvd 73 9 1 1     2 Width 0ft   5984909.8299 2105563.3396 37.7606028201969 -122.49531496977501 (37.7606028201969, -122.495314969775)
166247 120262 2 71 100 24th Ave 6 17 1 1     26     5988353.58713 2115180.43805 37.7872097252822 -122.484109995805 (37.7872097252822, -122.484109995805)
168152 211014 2 71 500 Junipero Serra Blvd 53 4 1 1     3 Width 0ft   5991322.30761 2093384.4785900002 37.7275361681597 -122.4722495339 (37.7275361681597, -122.4722495339)
169232 178173 2 71 0 Gonzalez Dr 4 2 1 1     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364)
169644 185964 2 71 2001 Sunset Blvd 23 9 1 1     1 Width 0ft   5984823.122 2101326.4259 37.7489643495953 -122.495302381208 (37.7489643495953, -122.495302381208)
170060 185310 2 71 2601 Sunset Blvd 35 9 1 1     3 Width 0ft   5984962.2385 2097256.121 37.737796538483295 -122.494521307154 (37.7377965384833, -122.494521307154)
170076 178164 2 71 10 Brotherhood Way 19 4 1 1     5 Width 0ft   5993000.50065 2087852.84302 37.71244461881 -122.46604626403 (37.71244461881, -122.46604626403)
170555 181384 2 71 1500 Sunset Blvd 17 9 1 1     2 Width 0ft   5984945.4334 2104486.2478 37.75764751046 -122.49511240858 (37.75764751046, -122.49511240858)
170901 178143 2 71 20 Brotherhood Way 14 4 1 1     5 Width 0ft   5991964.10718 2087949.4813 37.7126501183836 -122.46963535489999 (37.7126501183836, -122.4696353549)
170936 186435 2 71 1601 Sunset Blvd 23 9 1 1     1 Width 0ft   5984740.5243 2104016.8346 37.7563466338471 -122.495786431621 (37.7563466338471, -122.495786431621)
171829 178157 2 71 10 Brotherhood Way 12 4 1 1     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.46503447098499 (37.712406882332, -122.465034470985)
171858 185535 2 71 2201 Sunset Blvd 19 9 1 1     1 Width 0ft   5984921.0973 2100070.748 37.745522336384795 -122.49487101697099 (37.7455223363848, -122.494871016971)
172467 187388 2 71 2200 Sunset Blvd 74 9 1 1     1 Width 0ft   5985049.5619 2100144.9354 37.7457335539505 -122.49443228067 (37.7457335539505, -122.49443228067)
172637 211002 2 71 700 Portola Dr 3 1 1 1     8 Width 3ft   5996779.38475 2099373.51377 37.744294920285 -122.45381679181801 (37.744294920285, -122.453816791818)
172927 211028 2 71 700 Junipero Serra Blvd 160 4 1 1     4 Width 0ft   5991184.3391 2091378.75733 37.722020970475505 -122.472580317131 (37.7220209704755, -122.472580317131)
173075 186890 2 71 2700 Sunset Blvd 39 9 1 1     1 Width 0ft   5985200.262 2096503.3044 37.7357434330648 -122.493642900348 (37.7357434330648, -122.493642900348)
173673 211035 2 71 61 Burnside Ave 1 9 1 1     20     6001198.5187 2095714.51341 37.7345005324595 -122.438274321504 (37.7345005324595, -122.438274321504)
Powered by Datasette · Query took 7.361ms · Data source: data.sfgov.org