sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
187735 239190 2 147 101 Hwy 101 Northbound 2 13 1 1     4     6005977.0875 2108970.19311 37.7711682017725 -122.422694894458 (37.7711682017725, -122.422694894458)
186175 239207 2 147 100 Hwy 101 Southbound 18 13 1 1     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387)
184867 239183 2 147 720 South Van Ness Ave 4 1 1 1     3 Width 3ft   6007476.35772 2105397.09343 37.761441780224 -122.41725560676001 (37.761441780224, -122.41725560676)
183663 239206 2 147 100 Hwy 101 Southbound 19 13 1 1     3     6005929.117819999 2108865.00797 37.7708766820544 -122.42285334689899 (37.7708766820544, -122.422853346899)
180826 239202 2 147 100 Hwy 101 Southbound 24 13 1 1     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225)
180815 239166 2 147 1400 Potrero Ave 10 1 1 1     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.40586209846799 (37.749986307743, -122.405862098468)
178965 239171 2 147 1400 Potrero Ave 20 1 1 1     4 Width 2ft   6010775.13287 2100929.58266 37.7493600234457 -122.40553179815399 (37.7493600234457, -122.405531798154)
176639 239153 2 147 150 Octavia St 5 4 1 1     3 Width 4ft   6005703.32038 2109897.0428299997 37.773697658347395 -122.423707777507 (37.7736976583474, -122.423707777507)
176214 239157 2 147 101 Octavia St 5 4 1 1     3 Width 4ft   6005616.09638 2109686.3289099997 37.7731141647188 -122.423994511963 (37.7731141647188, -122.423994511963)
176100 239229 2 147 391 Church St 1 1 1 1     5 Width 3ft   6004228.5151 2106643.84143 37.764681793855 -122.42857742022899 (37.764681793855, -122.428577420229)
175455 239148 2 147 8 Octavia St 12 4 1 1     3 Width 6ft   6005748.59719 2109565.89201 37.7727909537754 -122.423527610038 (37.7727909537754, -122.423527610038)
174547 239220 2 147 2730 Bryant St 6 7 1 1     2 Width 7ft   6009770.4944400005 2101313.01983 37.750356630576796 -122.409032927236 (37.7503566305768, -122.409032927236)
170487 239210 2 147 100 Hwy 101 Southbound 13 13 1 1     3     6005891.00584 2108925.69957 37.771041176138795 -122.422989491673 (37.7710411761388, -122.422989491673)
169669 114203 2 147 310 Carolina St 3 1 1 1     3 3x3   6012282.10678 2106442.32004 37.764580938483704 -122.400707843686 (37.7645809384837, -122.400707843686)
168811 239193 2 147 101 Hwy 101 Northbound 5 13 1 1     5     6005953.87409 2109001.5556400004 37.771253006051296 -122.42277741983801 (37.7712530060513, -122.422777419838)
168071 239143 2 147 101 Hwy 101 N Off Ramp 2 9 1 1     4 Width 5ft   6005870.17252 2109182.68749 37.771745627697 -122.42307982409099 (37.771745627697, -122.423079824091)
167071 239187 2 147 483 South Van Ness Ave 3 1 1 1     4 Width 3ft   6007459.99284 2106907.97241 37.7655893815639 -122.41741928429701 (37.7655893815639, -122.417419284297)
166869 239197 2 147 101 Hwy 101 Northbound 9 13 1 1     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308001 (37.7713899961886, -122.42288140308)
165954 239146 2 147 101 Hwy 101 N Off Ramp 5 9 1 1     4 Width 5ft   6005853.9818 2109210.66322 37.7718215286672 -122.423137817777 (37.7718215286672, -122.423137817777)
165840 83748 1 147 235 Thornton Ave 1 1 1 1   07/18/2008 12:00:00 AM 4 3x3 Permit Number 51439 6013723.72454 2094177.53037 37.730984728264204 -122.39486260383 (37.7309847282642, -122.39486260383)
164504 239144 2 147 101 Hwy 101 N Off Ramp 3 9 1 1     4 Width 5ft   6005864.044969999 2109192.1189099997 37.7717711783282 -122.423101690202 (37.7717711783282, -122.423101690202)
163838 239218 2 147 100 Hwy 101 Southbound 1 13 1 1     3 Width 10ft   6005833.18575 2109028.0269 37.771318879598105 -122.423196768328 (37.7713188795981, -122.423196768328)
163715 239158 2 147 101 Octavia St 6 4 1 1     4 Width 4ft   6005617.18186 2109670.5002599997 37.7730707643493 -122.42398963132601 (37.7730707643493, -122.423989631326)
160902 239191 2 147 101 Hwy 101 Northbound 3 13 1 1     6     6005967.76325 2108980.83852 37.7711969054453 -122.422727904078 (37.7711969054453, -122.422727904078)
160537 95602 1 147 345 08th Ave 2 1 1 1   11/27/2012 12:00:00 AM 2 3x3 Permit Number 769429 5993373.11205 2113255.69639 37.782215873424605 -122.46660370840799 (37.7822158734246, -122.466603708408)
158664 239205 2 147 100 Hwy 101 Southbound 20 13 1 1     2     6005934.94283 2108857.8407799997 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574)
158471 197028 2 147 2 Waterloo St 5 1 1 1     4 Width 4ft   6010376.04785 2097256.74048 37.739252873912704 -122.40665305401801 (37.7392528739127, -122.406653054018)
158469 197035 2 147 1751 Armstrong Ave 1 2 1 1     4 Width 4ft   6013551.1098 2093063.74117 37.7279168907351 -122.39538136964799 (37.7279168907351, -122.395381369648)
158027 239221 2 147 2810 26th St 3 1 1 1     7 Width 3ft   6010295.22869 2101085.95879 37.749762551916106 -122.407202347334 (37.7497625519161, -122.407202347334)
157838 197037 2 147 176 Maddux Ave 1 4 1 1     2 Width 3ft   6012326.10159 2094826.6531599998 37.732689273593294 -122.399740013104 (37.7326892735933, -122.399740013104)
157689 197030 2 147 1601 Kirkwood Ave 2 4 1 1     4 Width 4ft   6015124.98776 2096779.4659400003 37.7382069300149 -122.39019987173401 (37.7382069300149, -122.390199871734)
155009 239231 2 147 391 Church St 3 1 1 1     7 Width 3ft   6004225.7038199995 2106680.81705 37.764783160934 -122.42858977959699 (37.764783160934, -122.428589779597)
154686 239219 2 147 2730 Bryant St 3 1 1 1     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907)
154682 197033 2 147 2421 Mendell St 1 2 1 1     3 Width 6ft   6013404.921569999 2092933.78448 37.7275519242636 -122.395877647031 (37.7275519242636, -122.395877647031)
154336 239174 2 147 1714 15th St 1 1 1 1     3 Width 4ft   6005940.64905 2107290.54233 37.7665542255162 -122.422701553932 (37.7665542255162, -122.422701553932)
153397 197025 2 147 2 Waterloo St 2 1 1 1     3 Width 4ft   6010590.71236 2097235.47599 37.7392064940954 -122.405909338939 (37.7392064940954, -122.405909338939)
152126 239212 2 147 100 Hwy 101 Southbound 9 13 1 1     6     6005873.5433 2108954.58543 37.7711195043932 -122.42305194869301 (37.7711195043932, -122.423051948693)
149452 197024 2 147 2 Waterloo St 1 1 1 1     3 Width 4ft   6010624.95454 2097233.34103 37.7392025469594 -122.405790793937 (37.7392025469594, -122.405790793937)
149080 239213 2 147 100 Hwy 101 Southbound 8 13 1 1     5     6005865.35862 2108965.54677 37.771149139741 -122.423081039068 (37.771149139741, -122.423081039068)
145837 82263 1 147 850 South Van Ness Ave 1 1 1 1   12/23/2011 12:00:00 AM 5 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.759544830410704 -122.417037358657 (37.7595448304107, -122.417037358657)
145620 109949 8 147 400x CLEMENTINA ST 9 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
144980 102100 1 147 234 Linden St 2 1 1 1 1     6   6006253.0 2110945.0 37.776606109637896 -122.42188080245899 (37.7766061096379, -122.421880802459)
144711 109941 8 147 400x CLEMENTINA ST 1 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
144224 102120 1 147 3906 24th St 1 1 1 1 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003747.7 2101944.5 37.751751298202 -122.429905200436 (37.751751298202, -122.429905200436)
144056 101924 8 147 1099X Hyde St 1 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
143949 102170 1 147 270 Collingwood St 1 1 1 1 1 12/31/2012 12:00:00 AM 3 3x3   6001983.1 2104294.8 37.758104568963105 -122.436175590041 (37.7581045689631, -122.436175590041)
143550 101925 8 147 1099X Hyde St 2 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
141400 43127 1 147 8 Prospect Ave 1 1 1 1   07/14/2009 12:00:00 AM   3x3 Permit Number 52578 6007298.20406204 2099606.09068899 37.745530983588296 -122.417461342572 (37.7455309835883, -122.417461342572)
141229 61618 1 147 3904 24th St 1 1 1 1 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003796.89718088 2101902.23350187 37.7516380302781 -122.42973205570101 (37.7516380302781, -122.429732055701)
139273 239168 2 147 1400 Potrero Ave 12 1 1 1     4 Width 2ft   6010702.848069999 2101113.77684 37.749861738144396 -122.40579473475 (37.7498617381444, -122.40579473475)
138910 82835 1 147 165-167 11th St 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
138658 51377 1 147 356 12th St 2 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52402 6008497.808835 2108622.2239572 37.770354654829504 -122.413950975697 (37.7703546548295, -122.413950975697)
138458 94765 1 147 10X Waterloo St 4 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
137308 239142 2 147 101 Hwy 101 N Off Ramp 1 9 1 1     4 Width 5ft   6005875.43102 2109171.08438 37.771714065081795 -122.42306080971399 (37.7717140650818, -122.423060809714)
137006 92251 1 147 1422 34th Ave 1 1 1 1   07/23/2009 12:00:00 AM 0 3x3 Permit Number 52700 5985614.2 2105517.7 37.7605187222406 -122.492875546543 (37.7605187222406, -122.492875546543)
133851 239201 2 147 100 Hwy 101 Southbound 25 13 1 1     3     6005958.49088 2108828.3343599997 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971)
133557 239195 2 147 101 Hwy 101 Northbound 7 13 1 1     3     6005938.2626 2109031.33623 37.77133389557179 -122.422833537536 (37.7713338955718, -122.422833537536)
132976 197029 2 147 1601 Kirkwood Ave 1 4 1 1     4 Width 4ft   6015115.28126 2096786.0121099998 37.738224366070106 -122.390233889493 (37.7382243660701, -122.390233889493)
131578 114201 2 147 310 Carolina St 1 1 1 1     2 3x3   6012278.4302 2106502.4698 37.7647458912325 -122.40072478603001 (37.7647458912325, -122.40072478603)
131357 239215 2 147 100 Hwy 101 Southbound 5 13 1 1     2     6005849.76837 2108994.2700400003 37.77122712717 -122.423137008381 (37.77122712717, -122.423137008381)
130504 114204 2 147 310 Carolina St 4 1 1 1     2 3x3   6012281.598730001 2106430.0070700003 37.764547101481 -122.40070873583599 (37.764547101481, -122.400708735836)
130200 239200 2 147 100 Hwy 101 Southbound 26 13 1 1     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767)
127469 65253 1 147 1020 Florida St 1 1 1 1   07/21/2009 12:00:00 AM   3x3 Permit Number 52660 6009405.78315449 2103223.20926555 37.75558114637921 -122.410428993303 (37.7555811463792, -122.410428993303)
126287 91026 3 147 722 South Van Ness Ave 2 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
126209 74507 1 147 165-167 11th St 4 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
126197 94767 1 147 10X Waterloo St 5 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
124874 91022 3 147 140 South Van Ness Ave 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
124525 92866 1 147 4800 03rd St 1 1 1 1     3 3x3   6014889.778059999 2095498.93005 37.7346777911521 -122.390923645427 (37.7346777911521, -122.390923645427)
124327 95701 1 147 101 Arbor St 2 1 1 1 1 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805.0 2096722.0 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043)
121921 95064 3 147 4849X 03rd St 1 1 1 1     3 3x3   6014989.6 2095442.3 37.734527834908 -122.390574568357 (37.734527834908, -122.390574568357)
121292 22304 3 147 5012X 03rd St 3 1 1 2     3 3x3   6014702.6472 2094891.22359 37.7329987676998 -122.39152815342301 (37.7329987676998, -122.391528153423)
118628 22295 1 147 4910 03rd St 2 1 1 1     3 3x3   6014801.71028 2095185.44595 37.733812140558705 -122.391206222681 (37.7338121405587, -122.391206222681)
117701 95060 3 147 5033 03rd St 2 1 1 2     3 3x3   6014806.53085 2094754.47288 37.732629043524206 -122.391159442188 (37.7326290435242, -122.391159442188)
116134 95702 1 147 231 Miramar Ave 1 1 1 1 1 03/09/2011 12:00:00 AM   3x3 Permit Number 767451 5995312.0 2091520.8 37.7226490447139 -122.45832239069401 (37.7226490447139, -122.458322390694)
115213 61801 1 147 564 Waller St 1 1 1 1   07/15/2009 12:00:00 AM   3x3 Permit Number 52595 6003001.78864481 2108933.54346304 37.77089925742521 -122.43298393769501 (37.7708992574252, -122.432983937695)
113160 109947 8 147 400x CLEMENTINA ST 7 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
111579 102175 1 147 484 Corbett Ave 1 1 1 1 1 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769767 5999426.4 2104189.2 37.7576690270565 -122.445010134311 (37.7576690270565, -122.445010134311)
111319 22306 3 147 5015 03rd St 1 1 1 2     3 3x3   6014803.86419 2094824.41992 37.7328209559263 -122.39117354906 (37.7328209559263, -122.39117354906)
110960 91024 1 147 140 South Van Ness Ave 6 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
110849 91029 3 147 967 South Van Ness Ave 1 1 1 2   11/18/2008 12:00:00 AM 5 3x3   6007608.48742 2104034.949256 37.7577090789947 -122.416702122814 (37.7577090789947, -122.416702122814)
110318 91028 3 147 722 South Van Ness Ave 4 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
109696 95059 1 147 5115X 03rd St 4 1 1 1     3 3x3   6014711.63884 2094587.79956 37.7321661259618 -122.391475861678 (37.7321661259618, -122.391475861678)
108163 108057 1 147 535X Mission St 6 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
107768 82751 1 147 52 Sheridan St 1 1 2 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626002 (37.772580689338, -122.41138145626)
107641 74954 1 147 165-167 11th St 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
107638 108055 1 147 535X Mission St 4 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
107618 39176 1 147 754 South Van Ness Ave 2 1 1 1   12/15/2009 12:00:00 AM     Permit Number 53085 6007474.0 2105260.0 37.761065220770504 -122.417254045994 (37.7610652207705, -122.417254045994)
105566 239156 2 147 101 Octavia St 4 4 1 1     5 Width 4ft   6005612.49957 2109700.10187 37.7731517788755 -122.42400793341999 (37.7731517788755, -122.42400793342)
105339 82259 1 147 850 South Van Ness Ave 5 1 1 1 1 12/23/2011 12:00:00 AM 3 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.759544830410704 -122.417037358657 (37.7595448304107, -122.417037358657)
104982 109946 8 147 400x CLEMENTINA ST 6 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
104369 91023 1 147 140 South Van Ness Ave 4 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
103499 108058 1 147 535X Mission St 7 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
101764 22308 3 147 5033 03rd St 3 1 1 2   04/24/2000 12:00:00 AM 3 3x3   6014806.8487599995 2094754.47288 37.7326290611665 -122.39115834308599 (37.7326290611665, -122.391158343086)
101758 116523 2 147 2486 FULTON ST 1 1 1 1     2 3x3   5995798.0 2110374.0 37.7744431335528 -122.458006125331 (37.7744431335528, -122.458006125331)
101698 82834 1 147 165-167 11th St 2 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
101642 87767 1 147 200 Beacon St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50472 6003134.0 2097619.0 37.739839710176895 -122.431718656253 (37.7398397101769, -122.431718656253)
100892 109943 8 147 400x CLEMENTINA ST 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
100212 80773 1 147 317 Elizabeth St 1 1 1 1 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767266 6004338.6764807 2102152.37621846 37.7523555276075 -122.427876335011 (37.7523555276075, -122.427876335011)
98771 74661 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
96940 95066 1 147 1575 South Van Ness Ave 1 1 1 1   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927)
96771 102104 1 147 705X Tehama St 3 1 1 1       3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
Powered by Datasette · Query took 4.113ms · Data source: data.sfgov.org