sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
56900 239186 2 147 483 South Van Ness Ave 2 1 1 1     5 Width 3ft   6007463.67946 2106844.52399 37.7654153744566 -122.41740203617701 (37.7654153744566, -122.417402036177)
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)
27893 217747 2 147 625 Frederick St 1 4 1 1     4 Width 3ft   5996570.53056 2107292.29818 37.7660259340648 -122.455111074526 (37.7660259340648, -122.455111074526)
53022 239177 2 147 1778 15th St 1 1 1 1     1 Width 4ft   6005631.82803 2107273.89376 37.7664910841327 -122.42376852849199 (37.7664910841327, -122.423768528492)
46484 239176 2 147 1748 15th St 1 1 1 1     4 Width 4ft   6005773.30835 2107281.9684900003 37.7665212410869 -122.42327974697201 (37.7665212410869, -122.423279746972)
50307 239175 2 147 1742 15th St 1 1 1 1     3 Width 4ft   6005792.615730001 2107282.2581599997 37.7665231260736 -122.42321298670099 (37.7665231260736, -122.423212986701)
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)
52540 239181 2 147 380 14th St 3 1 1 1     2 Width 3ft   6006215.6761300005 2107893.9456599997 37.7682265409602 -122.42179314696001 (37.7682265409602, -122.42179314696)
46968 239180 2 147 370 14th St 4 1 1 1     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.42162365172301 (37.7682355881421, -122.421623651723)
52804 239179 2 147 370 14th St 2 1 1 1     2 Width 3ft   6006290.70185 2107898.44552 37.768243127135705 -122.42153395963601 (37.7682431271357, -122.421533959636)
33973 239178 2 147 370 14th St 1 1 1 1     2 Width 3ft   6006302.56864 2107899.15692 37.7682457495759 -122.421492964039 (37.7682457495759, -122.421492964039)
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)
38350 239199 2 147 100 Hwy 101 Southbound 27 13 1 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
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)
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)
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)
59769 239203 2 147 100 Hwy 101 Southbound 22 13 1 1     3     6005946.44181 2108844.1649 37.7708204294492 -122.42279194121402 (37.7708204294492, -122.422791941214)
45307 239204 2 147 100 Hwy 101 Southbound 21 13 1 1     4     6005940.87649 2108850.7859900002 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426)
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)
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)
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)
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)
60490 239208 2 147 100 Hwy 101 Southbound 17 13 1 1     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484)
35375 239209 2 147 100 Hwy 101 Southbound 14 13 1 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
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)
27650 239211 2 147 100 Hwy 101 Southbound 11 13 1 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
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)
63852 239189 2 147 101 Hwy 101 Northbound 1 13 1 1     3     6005983.85034 2108958.2836700003 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046)
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)
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)
34830 239214 2 147 100 Hwy 101 Southbound 7 13 1 1     6     6005859.14445 2108978.35649 37.771183961488106 -122.423103444792 (37.7711839614881, -122.423103444792)
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)
44635 239192 2 147 101 Hwy 101 Northbound 4 13 1 1     6     6005960.3562900005 2108991.91912 37.771226912211795 -122.422754312663 (37.7712269122118, -122.422754312663)
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)
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)
61226 239216 2 147 100 Hwy 101 Southbound 3 13 1 1     5     6005843.543219999 2109006.7344400003 37.771261000120504 -122.42315942758499 (37.7712610001205, -122.423159427585)
73553 239217 2 147 100 Hwy 101 Southbound 2 13 1 1     4     6005837.81281 2109017.0594 37.7712890265976 -122.423179983379 (37.7712890265976, -122.423179983379)
31969 239194 2 147 101 Hwy 101 Northbound 6 13 1 1     3     6005943.751730001 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768)
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)
85858 91025 1 147 140 South Van Ness Ave 8 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
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)
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)
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)
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)
75553 239196 2 147 101 Hwy 101 Northbound 8 13 1 1     3     6005930.84591 2109041.9421200003 37.771362598325 -122.42285994612499 (37.771362598325, -122.422859946125)
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)
32290 239198 2 147 101 Hwy 101 Northbound 10 13 1 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
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)
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)
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)
72859 239145 2 147 101 Hwy 101 N Off Ramp 4 9 1 1     4 Width 5ft   6005859.0162 2109201.52808 37.7717967298683 -122.42311975398701 (37.7717967298683, -122.423119753987)
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)
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)
68215 239147 2 147 8 Octavia St 11 4 1 1     5 Width 6ft   6005750.76035 2109550.79453 37.7727496218289 -122.423519053867 (37.7727496218289, -122.423519053867)
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)
54298 239149 2 147 8 Octavia St 13 4 1 1     3 Width 6ft   6005748.02057 2109577.9462099997 37.7728240191579 -122.423530461786 (37.7728240191579, -122.423530461786)
20029 10244 3 147 99X Haight St 1 1 1 2   01/28/2000 12:00:00 AM 6 3X3   6005773.33687 2109613.89968 37.7729241676403 -122.42344544616002 (37.7729241676403, -122.42344544616)
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)
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)
1489 239150 3 147 100 Octavia St 1 1 1 2     4 Width 4ft   6005732.390269999 2109686.64828 37.773121606595105 -122.42359225870001 (37.7731216065951, -122.4235922587)
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)
35585 239152 2 147 100 Octavia St 3 4 1 1     4 Width 4ft   6005729.11778 2109714.63204 37.773198258533895 -122.42360556863599 (37.7731982585339, -122.423605568636)
86372 74812 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)
91409 82833 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)
93976 82832 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)
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)
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)
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)
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)
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)
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)
70626 239155 2 147 150 Octavia St 7 4 1 1     7 Width 4ft   6005700.01949 2109925.2105900003 37.7737748138817 -122.42372119899099 (37.7737748138817, -122.423721198991)
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)
83671 82942 1 147 236 08th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
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)
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)
9721 173654 3 147 118 06th St 1 1 1 2       3x3   6010152.0 2112318.0 37.7805951592946 -122.408489839314 (37.7805951592946, -122.408489839314)
18013 109951 8 147 400x CLEMENTINA ST 11 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
77374 109950 8 147 400x CLEMENTINA ST 10 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
82275 109948 8 147 400x CLEMENTINA ST 8 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
92212 109944 8 147 400x CLEMENTINA ST 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93248 109945 8 147 400x CLEMENTINA ST 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93713 109942 8 147 400x CLEMENTINA ST 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
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)
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)
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)
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)
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)
83586 82094 1 147 356 Funston Ave 1 1 1 1   06/03/2008 12:00:00 AM   3x3 Permit Number 50622 5991881.95379836 2113031.51992267 37.7815141826847 -122.471746056837 (37.7815141826847, -122.471746056837)
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)
64157 65681 1 147 345 08th Ave 1 1 1 1   03/03/2011 12:00:00 AM 3   Permit Number 767215 5993370.6959 2113311.72647 37.782369577363 -122.466616141073 (37.782369577363, -122.466616141073)
68673 249388 2 147 301 Eddy St 3 4 1 1     5 Width 3ft   6008934.66326 2113525.78003 37.78384318556579 -122.41278661472602 (37.7838431855658, -122.412786614726)
30621 249356 2 147 625 Leavenworth St 2 4 1 1     2 Width 3ft   6008325.07213 2114654.93665 37.7869093422284 -122.414975526796 (37.7869093422284, -122.414975526796)
18021 108056 1 147 535X Mission St 5 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)
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)
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)
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)
81444 101926 8 147 1099X Hyde St 3 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)
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)
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)
63559 136188 2 147 3598 Webster St 1 1 1 1     3 Width 3ft   6002648.6286 2120880.08452 37.8036813773578 -122.435060090577 (37.8036813773578, -122.435060090577)
Powered by Datasette · Query took 4.142ms · Data source: data.sfgov.org