sf-trees

Data source: data.sfgov.org

Custom SQL query returning 82 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2256 200334 1 85 750 Phelps St 4 4 1 15   11/15/1992 12:00:00 AM 8 Width 3ft   6015528.91481 2098358.82009 37.742565908900204 -122.388913512973 (37.7425659089002, -122.388913512973)
4102 253611 2 85 900 Front St 12 1 1 1       Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497)
23670 129807 2 85 901 Sacramento St 6 10 1 1     11 Width 3ft   6010390.20829 2116866.53247 37.793097682469394 -122.407986617304 (37.7930976824694, -122.407986617304)
25573 129783 2 85 900 Front St 11 1 1 1     18 Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497)
25678 129817 2 85 241 Battery St 1 1 1 1     8 Width 3ft   6012643.50693 2117148.0023 37.793996430738 -122.40020979915899 (37.793996430738, -122.400209799159)
28250 129809 2 85 901 Sacramento St 8 10 1 1     12 Width 3ft   6010417.7029 2116870.15869 37.7931091785103 -122.40789173971399 (37.7931091785103, -122.407891739714)
28769 129827 2 85 354 Sacramento St 1 1 1 1     18 Width 3ft   6012617.00039 2117213.20404 37.7941739812068 -122.400306096749 (37.7941739812068, -122.400306096749)
29650 129819 2 85 241 Battery St 3 1 1 1     2 Width 3ft   6012648.9601 2117092.8382099997 37.793845267304505 -122.400187054399 (37.7938452673045, -122.400187054399)
30051 129811 2 85 435 Sacramento St 2 1 1 1     7 Width 3ft   6012498.509190001 2117154.1734 37.794005289065794 -122.40071194282801 (37.7940052890658, -122.400711942828)
31378 129821 2 85 504 Sansome St 1 1 1 1     15 Width 3ft   6012337.50928 2117203.47544 37.7941316797929 -122.40127248843201 (37.7941316797929, -122.401272488432)
32083 129818 2 85 241 Battery St 2 1 1 1     9 Width 3ft   6012648.53437 2117119.11483 37.79391739292829 -122.400190373809 (37.7939173929283, -122.400190373809)
33596 227938 2 85 25 Chattanooga St 1 1 1 1     4 Width 3ft   6004713.51107 2103480.2352 37.756022715594604 -122.426674645426 (37.7560227155946, -122.426674645426)
34082 129826 2 85 510 Battery St 1 1 1 1     8 Width 3ft   6012620.11049 2117309.3448900003 37.7944381345611 -122.400302091187 (37.7944381345611, -122.400302091187)
34108 129780 2 85 900 Front St 8 1 1 1     14 Width 3ft   6012726.999559999 2119408.50299 37.800207880833895 -122.400079730213 (37.8002078808339, -122.400079730213)
35863 129806 2 85 901 Sacramento St 5 10 1 1     6 Width 3ft   6010377.17129 2116863.70379 37.793089185679705 -122.40803152672702 (37.7930891856797, -122.408031526727)
38087 129808 2 85 901 Sacramento St 7 10 1 1     4 Width 3ft   6010404.49438 2116867.87948 37.7931021808659 -122.40793728139201 (37.7931021808659, -122.407937281392)
38577 129810 2 85 435 Sacramento St 1 1 1 1     9 Width 3ft   6012477.08259 2117150.1123 37.7939929431787 -122.40078579605101 (37.7939929431787, -122.400785796051)
40031 129832 2 85 354 Sacramento St 6 1 1 1     7 Width 3ft   6012451.480280001 2117191.95794 37.7941064133197 -122.400877324536 (37.7941064133197, -122.400877324536)
40130 228846 2 85 210 Cumberland St 1 1 1 1     7 Width 3ft   6004252.08143 2104552.56077 37.758940969765 -122.428346847525 (37.758940969765, -122.428346847525)
40999 129775 2 85 80 Vallejo St 7 1 1 1     16 Width 3ft   6012820.869469999 2119255.17116 37.799792101768396 -122.399744129295 (37.7997921017684, -122.399744129295)
41186 228842 2 85 1010 Ashbury St 1 1 1 1     9 Width 3ft   5999127.094409999 2106474.67422 37.7639272833421 -122.446209649681 (37.7639272833421, -122.446209649681)
43828 208173 2 85 170 Vasquez Ave 1 2 1 1     9 Width 3ft   5994847.17518 2099430.14012 37.744339434016794 -122.460502016448 (37.7443394340168, -122.460502016448)
45773 129823 2 85 504 Battery St 2 1 1 1     9 Width 3ft   6012601.68821 2117444.3368599997 37.7948077631249 -122.40037532116501 (37.7948077631249, -122.400375321165)
46581 228841 2 85 65 Homestead St 2 1 1 1     16 Width 3ft   6000998.7373 2101290.13943 37.749798521207204 -122.439364559745 (37.7497985212072, -122.439364559745)
47917 129784 2 85 1600 Montgomery St 1 9 1 1     9 Width 3ft   6011334.32807 2120989.68408 37.8044716700829 -122.405010336152 (37.8044716700829, -122.405010336152)
50680 129764 2 85 1379 Green St 2 1 1 1     7 Width 3ft   6006404.89602 2118659.8041 37.7977976222176 -122.42190349824101 (37.7977976222176, -122.421903498241)
57959 129812 2 85 435 Sacramento St 3 1 1 1     3 Width 3ft   6012517.23545 2117156.65433 37.794013145532 -122.40064732203301 (37.794013145532, -122.400647322033)
59650 129831 2 85 354 Sacramento St 5 1 1 1     7 Width 3ft   6012476.45918 2117195.3094900004 37.7941170091435 -122.40079112993 (37.7941170091435, -122.40079112993)
62252 227934 2 85 1731 15th St 1 1 1 1     1 Width 3ft   6005814.854180001 2107243.32997 37.7664174935056 -122.423133300469 (37.7664174935056, -122.423133300469)
62703 129830 2 85 354 Sacramento St 4 1 1 1     9 Width 3ft   6012498.4118 2117199.54922 37.794129874847606 -122.400715469043 (37.7941298748476, -122.400715469043)
65614 228852 2 85 210 Cumberland St 7 1 1 1     3 Width 3ft   6004131.71858 2104545.14122 37.7589137859482 -122.428762589748 (37.7589137859482, -122.428762589748)
66960 200333 2 85 903 Minnesota St 1 1 1 1     9 Width 3ft   6015264.35575 2104459.34943 37.7593020107061 -122.39025440841002 (37.7593020107061, -122.39025440841)
67539 129822 2 85 504 Sansome St 2 1 1 1     17 Width 3ft   6012331.01864 2117278.3358 37.7943368663928 -122.401300210056 (37.7943368663928, -122.401300210056)
68851 228850 2 85 210 Cumberland St 5 1 1 1     6 Width 3ft   6004169.71901 2104547.0578 37.7589211990752 -122.42863130311501 (37.7589211990752, -122.428631303115)
69203 129829 2 85 354 Sacramento St 3 1 1 1     2 Width 3ft   6012523.949659999 2117203.16491 37.7941412269928 -122.400627358876 (37.7941412269928, -122.400627358876)
72002 129820 2 85 241 Battery St 4 1 1 1     11 Width 3ft   6012651.85549 2117070.09364 37.7937829775554 -122.400175437873 (37.7937829775554, -122.400175437873)
72713 208168 2 85 2590 16th Ave 2 1 1 1     11 Width 3ft   5991441.450619999 2097800.63089 37.7396687033598 -122.472159425416 (37.7396687033598, -122.472159425416)
73201 228843 2 85 707 Eugenia Ave 2 1 1 1     14 Width 3ft   6007452.7290199995 2097768.34677 37.7404936415683 -122.416796844595 (37.7404936415683, -122.416796844595)
75033 228849 2 85 210 Cumberland St 4 1 1 1     5 Width 3ft   6004184.64448 2104547.65023 37.75892367042171 -122.42857972608499 (37.7589236704217, -122.428579726085)
75415 129774 2 85 80 Vallejo St 6 1 1 1     16 Width 3ft   6012849.953480001 2119259.82939 37.7998065134132 -122.39964381442499 (37.7998065134132, -122.399643814425)
75521 228848 2 85 210 Cumberland St 3 1 1 1     3 Width 3ft   6004199.57922 2104548.6925 37.7589273774242 -122.42852814905599 (37.7589273774242, -122.428528149056)
76914 129776 2 85 80 Vallejo St 8 1 1 1     18 Width 3ft   6012790.20467 2119250.54506 37.7997776901326 -122.39984991653601 (37.7997776901326, -122.399849916536)
113875 129759 2 85 1827 Jones St 2 1 1 1     10 Width 3ft   6008241.72856 2118745.4751 37.7981362718366 -122.415553596641 (37.7981362718366, -122.415553596641)
130005 129813 2 85 435 Sacramento St 4 1 1 1     2 Width 3ft   6012536.38879 2117159.9438 37.794023245839796 -122.400581280298 (37.7940232458398, -122.400581280298)
131468 129753 2 85 2407 Clay St 6 1 1 1     18 Width 3ft   6003149.59406 2116175.6254 37.790792583373104 -122.43299016506901 (37.7907925833731, -122.432990165069)
131501 129770 2 85 80 Vallejo St 2 1 1 1     10 Width 3ft   6012963.296490001 2119273.7997 37.7998511899251 -122.39925258414499 (37.7998511899251, -122.399252584145)
131803 129772 2 85 80 Vallejo St 4 1 1 1     17 Width 3ft   6012910.450180001 2119266.99952 37.799829572932296 -122.39943497565099 (37.7998295729323, -122.399434975651)
132351 129779 2 85 900 Front St 7 1 1 1     9 Width 3ft   6012731.79119 2119371.92723 37.800107719749604 -122.400060579146 (37.8001077197496, -122.400060579146)
134069 124474 2 85 344 Willard St North 1 1 1 1     4 Width 3ft   5996301.59979 2110522.81259 37.7748806555631 -122.45627485050899 (37.7748806555631, -122.456274850509)
134397 129803 2 85 901 Sacramento St 2 10 1 1     11 Width 3ft   6010302.01456 2116853.58579 37.7930571958732 -122.408290860643 (37.7930571958732, -122.408290860643)
136849 208174 2 85 170 Vasquez Ave 2 2 1 1     6 Width 3ft   5994830.69157 2099413.59203 37.7442930488025 -122.460557814002 (37.7442930488025, -122.460557814002)
149570 129755 2 85 2407 Clay St 8 1 1 1     11 Width 3ft   6003208.43493 2116180.994 37.7908106615232 -122.432786962347 (37.7908106615232, -122.432786962347)
149913 129804 2 85 901 Sacramento St 3 10 1 1     12 Width 3ft   6010351.68054 2116862.21581 37.793083672815705 -122.408119621635 (37.7930836728157, -122.408119621635)
151478 228845 2 85 4526 20th St 1 1 1 1     17 Width 3ft   6001290.00365 2104097.6707200003 37.7575238972389 -122.438558485713 (37.7575238972389, -122.438558485713)
151570 129805 2 85 901 Sacramento St 4 10 1 1     10 Width 3ft   6010365.088819999 2116862.85785 37.793086186442 -122.40807327328899 (37.793086186442, -122.408073273289)
151663 129773 2 85 80 Vallejo St 5 1 1 1     13 Width 3ft   6012883.50017 2119263.61 37.799818763986295 -122.399527995233 (37.7998187639863, -122.399527995233)
151732 228851 2 85 210 Cumberland St 6 1 1 1     3 Width 3ft   6004146.65332 2104546.1831400003 37.7589174920696 -122.42871101271002 (37.7589174920696, -122.42871101271)
152362 129754 2 85 2407 Clay St 7 1 1 1     16 Width 3ft   6003179.18897 2116177.33789 37.7907989640458 -122.43288789058902 (37.7907989640458, -122.432887890589)
152581 129751 2 85 2320 Chestnut St 2 1 1 1     8 Width 3ft   6000742.15542 2119656.12238 37.8002122659526 -122.44156963624201 (37.8002122659526, -122.441569636242)
153734 129816 2 85 433 Sacramento St 3 1 1 1     11 Width 3ft   6012609.05006 2117170.5257599996 37.7940563534572 -122.400330606896 (37.7940563534572, -122.400330606896)
154064 208170 2 85 1225 Willard St 1 1 1 1     22 Width 3ft   5996717.7598 2107182.54151 37.7657330159006 -122.454593911282 (37.7657330159006, -122.454593911282)
155277 228844 2 85 709 Eugenia Ave 1 1 1 1     10 Width 3ft   6007473.725769999 2097767.91667 37.7404936415809 -122.416724215363 (37.7404936415809, -122.416724215363)
156528 129824 2 85 504 Battery St 3 1 1 1     7 Width 3ft   6012608.14 2117404.20841 37.794697939723704 -122.40035017702499 (37.7946979397237, -122.400350177025)
158244 129814 2 85 433 Sacramento St 1 1 1 1     8 Width 3ft   6012557.97886 2117161.9578299997 37.7940299799473 -122.40050671752199 (37.7940299799473, -122.400506717522)
166431 200336 2 85 750 Phelps St 8 4 1 1     9 Width 3ft   6015493.51667 2098314.62088 37.7424425848476 -122.38903282511002 (37.7424425848476, -122.38903282511)
167501 129749 2 85 2300 Chestnut St 2 1 1 1     5 Width 3ft   6000782.42382 2119661.2506 37.8002286408033 -122.44143066041599 (37.8002286408033, -122.441430660416)
168272 129750 2 85 2320 Chestnut St 1 1 1 1     6 Width 3ft   6000760.50701 2119657.6711 37.800217563850296 -122.44150624394301 (37.8002175638503, -122.441506243943)
168728 129828 2 85 354 Sacramento St 2 1 1 1     4 Width 3ft   6012548.895219999 2117204.8631700003 37.7941472812331 -122.400541163364 (37.7941472812331, -122.400541163364)
169203 129777 2 85 900 Front St 1 1 1 1     18 Width 3ft   6012748.89649 2119266.86751 37.79982020469429 -122.399994005922 (37.7998202046943, -122.399994005922)
169758 208167 2 85 2590 16th Ave 1 1 1 1     9 Width 3ft   5991441.567009999 2097783.56953 37.7396218639513 -122.47215777968201 (37.7396218639513, -122.472157779682)
170047 129781 2 85 900 Front St 9 1 1 1     14 Width 3ft   6012720.0769 2119456.93183 37.8003404688016 -122.40010708848 (37.8003404688016, -122.40010708848)
170579 228847 2 85 210 Cumberland St 2 1 1 1     8 Width 3ft   6004213.13115 2104548.41319 37.758927377407 -122.42848126022699 (37.758927377407, -122.428481260227)
172062 129771 2 85 80 Vallejo St 3 1 1 1     16 Width 3ft   6012935.02914 2119270.4372 37.79984038189279 -122.399350164196 (37.7998403818928, -122.399350164196)
174249 129833 2 85 354 Sacramento St 7 1 1 1     14 Width 3ft   6012379.779080001 2117177.7039400004 37.794063275551295 -122.40112441775601 (37.7940632755513, -122.401124417756)
176983 129765 2 85 1379 Green St 3 1 1 1     7 Width 3ft   6006424.31939 2118660.7850599997 37.797801411063396 -122.421836357588 (37.7978014110634, -122.421836357588)
180032 129815 2 85 433 Sacramento St 2 1 1 1     9 Width 3ft   6012587.02488 2117167.29458 37.7940462531923 -122.400406589716 (37.7940462531923, -122.400406589716)
180399 129782 2 85 900 Front St 10 1 1 1     12 Width 3ft   6012716.05958 2119492.7044900004 37.800438467927606 -122.40012350379601 (37.8004384679276, -122.400123503796)
181097 208169 2 85 2590 16th Ave 3 1 1 1     9 Width 3ft   5991440.6028 2097828.1323700002 37.7397441663462 -122.472164360908 (37.7397441663462, -122.472164360908)
184232 129802 2 85 901 Sacramento St 1 10 1 1     10 Width 3ft   6010252.4995 2116845.85776 37.79303320378 -122.40846164098801 (37.79303320378, -122.408461640988)
185432 129825 2 85 504 Battery St 4 1 1 1     13 Width 3ft   6012609.836569999 2117389.63944 37.79465803140361 -122.400343282842 (37.7946580314036, -122.400343282842)
187504 129778 2 85 900 Front St 2 1 1 1     16 Width 3ft   6012744.14452 2119292.42038 37.7998901017986 -122.400012245068 (37.7998901017986, -122.400012245068)
187663 129748 2 85 2300 Chestnut St 1 1 1 1     7 Width 3ft   6000804.68172 2119664.29702 37.800238273442396 -122.441353858292 (37.8002382734424, -122.441353858292)
Powered by Datasette · Query took 4.611ms · Data source: data.sfgov.org