sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
186 138359 3 59 2060 SUTTER ST 1 1 1 2     15 Width 0ft   6002861.592 2114464.6761 37.7860784126894 -122.43386429175101 (37.7860784126894, -122.433864291751)
188 138368 3 59 2060 SUTTER ST 10 1 1 2     13 Width 0ft   6002679.2262 2114443.3671 37.786009553218996 -122.434493703661 (37.786009553219, -122.434493703661)
192 138369 3 59 2060 SUTTER ST 11 1 1 2     16 Width 0ft   6002665.8461 2114439.4026 37.78599790817471 -122.434539711553 (37.7859979081747, -122.434539711553)
195 138365 3 59 2060 SUTTER ST 7 1 1 2     19 Width 0ft   6002748.6045 2114451.296 37.78603526200121 -122.43425424087799 (37.7860352620012, -122.434254240878)
199 138362 3 59 2060 SUTTER ST 4 1 1 2     15 Width 0ft   6002806.585 2114457.2427 37.78605488083279 -122.434054069465 (37.7860548808328, -122.434054069465)
201 138367 3 59 2060 SUTTER ST 9 1 1 2     15 Width 0ft   6002691.6152 2114444.3582 37.7860129777854 -122.434450912019 (37.7860129777854, -122.434450912019)
211 138370 3 59 2060 SUTTER ST 12 1 1 2     16 Width 0ft   6002647.5104 2114436.9248 37.7859900638921 -122.434602970779 (37.7859900638921, -122.434602970779)
216 138364 3 59 2060 SUTTER ST 6 1 1 2     18 Width 0ft   6002783.7892 2114453.2783 37.7860427018539 -122.43413265320801 (37.7860427018539, -122.434132653208)
217 138366 3 59 2060 SUTTER ST 8 1 1 2     18 Width 0ft   6002708.9598 2114445.3493 37.7860166836287 -122.43439097535801 (37.7860166836287, -122.434390975358)
220 138363 3 59 2060 SUTTER ST 5 1 1 2     16 Width 0ft   6002798.656 2114455.2605 37.7860489882217 -122.434081359893 (37.7860489882217, -122.434081359893)
221 138361 3 59 2060 SUTTER ST 3 1 1 2     16 Width 0ft   6002830.8674 2114461.7028 37.78606850519029 -122.433970377911 (37.7860685051903, -122.433970377911)
228 246283 3 59 2125 Mission St 2 1 1 2     17 Width 0ft   6006872.377 2105970.5198 37.7629822769131 -122.419385210964 (37.7629822769131, -122.419385210964)
230 138371 3 59 2060 SUTTER ST 13 1 1 2     17 Width 0ft   6002611.3346 2114434.4469999997 37.785981206770394 -122.434727951803 (37.7859812067704, -122.434727951803)
231 138360 3 59 2060 SUTTER ST 2 1 1 2     14 Width 0ft   6002847.7164 2114462.1983 37.7860708218731 -122.433912120385 (37.7860708218731, -122.433912120385)
273 20166 3 59 1155X Steiner St 7 1 1 2     20 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
284 137592 1 59 1125 Steiner St 1 1 1 1   04/16/1990 12:00:00 AM 18 Width 0ft   6002857.6038 2112094.871 37.7795712988398 -122.433708655697 (37.7795712988398, -122.433708655697)
296 18021 3 59 2725 Pine St 1 1 1 2     12 3X3   6000769.3896 2114817.5231 37.78692829139071 -122.44112805661501 (37.7869282913907, -122.441128056615)
325 21670 3 59 1776 Sutter St 3 1 1 2     22 4X4   6004121.8146 2114641.2436 37.786634655728605 -122.429516856277 (37.7866346557286, -122.429516856277)
342 21738 3 59 2045 Sutter St 2 1 1 2     12 4X4   6002837.9936 2114410.7158 37.7859289122324 -122.43394207733601 (37.7859289122324, -122.433942077336)
378 138112 3 59 1698 Sutter St 1 1 1 2     17 Width 0ft   6004508.5013 2114699.1479 37.7868155327596 -122.428183141793 (37.7868155327596, -122.428183141793)
523 247328 2 59 696X Oak St 1 1 1 1     20 Width 0ft   6003691.2873 2110070.3794 37.774059815342795 -122.430680081912 (37.7740598153428, -122.430680081912)
593 140072 2 59 601X Octavia St 3 1 1 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
594 140071 2 59 601X Octavia St 2 1 1 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
611 140070 2 59 601X Octavia St 1 1 1 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
879 246305 3 59 2135 Mission St 2 1 1 2     18 Width 0ft   6006876.9266 2105933.3644 37.762880513109295 -122.41936683944401 (37.7628805131093, -122.419366839444)
894 15433 3 59 2135 Mission St 1 1 1 2     18 4X4   6006876.1683 2105910.6162 37.7628180091578 -122.419367848279 (37.7628180091578, -122.419367848279)
911 12249 3 59 511 Laguna St 2 1 1 2     12 3X3   6004989.1563 2110705.1842 37.7758762780635 -122.42623573054199 (37.7758762780635, -122.426235730542)
935 143018 3 59 404 LOMBARD ST 1 1 1 2     20 Width 0ft   6010387.0782 2120648.4016 37.80348159588821 -122.40826430805402 (37.8034815958882, -122.408264308054)
954 251405 1 59 540 LOMBARD ST 1 1 1 1   01/21/2016 12:08:00 PM   Width 0ft   6009678.016 2120549.6995 37.8031708545804 -122.410711083519 (37.8031708545804, -122.410711083519)
1064 7177 1 59 827 Fillmore St 1 1 1 1     6 3X3   6003463.7289 2111198.6401 37.7771448458144 -122.431547809387 (37.7771448458144, -122.431547809387)
1072 7266 3 59 1740 Fillmore St 2 1 1 2     16 4X4   6003064.3461 2114369.1192 37.7858275412041 -122.433155987425 (37.7858275412041, -122.433155987425)
1120 7264 3 59 1730 Fillmore St 2 1 1 2     18 4X4   6003073.6496 2114318.6841 37.78568958693 -122.43312019509199 (37.78568958693, -122.433120195092)
1121 13143 3 59 1800 Lombard St 1 1 1 2     100 3X3   6003680.9036 2119717.0807 37.8005466318744 -122.431404778789 (37.8005466318744, -122.431404778789)
1154 246084 1 59 1390 Waller St 5 1 1 1     12 Width 0ft   5999058.5497 2108380.2585 37.7691556230859 -122.446583834228 (37.7691556230859, -122.446583834228)
1164 246083 1 59 1390 Waller St 4 1 1 1     14 Width 0ft   5999078.2336 2108382.6812 37.7691633995354 -122.446515923307 (37.7691633995354, -122.446515923307)
1172 143012 1 59 336 LOMBARD ST 2 1 1 1     20 Width 0ft   6010686.887999999 2120692.5302 37.803619545603205 -122.40722991099 (37.8036195456032, -122.40722991099)
1176 246082 1 59 1390 Waller St 3 1 1 1     11 Width 0ft   5999092.1637 2108384.801 37.7691700156221 -122.44646789257601 (37.7691700156221, -122.446467892576)
1363 21606 3 59 1525 Sutter St 1 1 1 2     12 4X4   6005078.2447 2114724.3621 37.7869169843519 -122.426213757225 (37.7869169843519, -122.426213757225)
1448 138093 3 59 1890 Sutter St 3 1 1 2     18 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1462 247381 3 59 1001 Oak St 5 1 1 2     12 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1463 13191 3 59 2095 Lombard St 2 1 1 2     12 3X3   6002470.5921 2119469.4635 37.7997980716779 -122.43557521775601 (37.7997980716779, -122.435575217756)
1466 247380 3 59 1001 Oak St 4 1 1 2     13 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1468 247377 3 59 1001 Oak St 1 1 1 2     15 Width 0ft   6002208.0 2109818.0 37.7732826991746 -122.43579295981199 (37.7732826991746, -122.435792959812)
1470 138091 3 59 1890 Sutter St 1 1 1 2   04/09/1990 12:00:00 AM 15 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1477 138092 3 59 1890 Sutter St 2 1 1 2     19 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1504 21609 3 59 1531 Sutter St 2 1 1 2   04/09/1990 12:00:00 AM 12 4X4   6005037.9058 2114711.086 37.7868782513618 -122.42635237507 (37.7868782513618, -122.42635237507)
1528 13126 3 59 1701 Lombard St 1 1 1 2     21 3X3   6004190.6649 2119706.135 37.8005454550984 -122.42964001675399 (37.8005454550984, -122.429640016754)
1644 14813 3 59 1195 McAllister St 1 1 1 2     12 4X4   6003481.2511 2111720.7527 37.778579430545896 -122.431524477475 (37.7785794305459, -122.431524477475)
1759 7200 3 59 949 Fillmore St 7 1 1 2     12 3X3   6003420.9887 2111521.8792 37.7780299575939 -122.431718745255 (37.7780299575939, -122.431718745255)
1775 245411 3 59 2794 24th St 1 1 1 1     24 Width 0ft   6010069.4683 2102240.5937 37.7529202865107 -122.408064458251 (37.7529202865107, -122.408064458251)
1834 13113 1 59 1611 Lombard St 1 1 1 1     30 3x3   6004587.0591 2119767.9005 37.8007374842012 -122.428272736084 (37.8007374842012, -122.428272736084)
1838 9642 3 59 1482 Golden Gate Ave 2 1 1 2     15 3x3   6002517.4506 2111986.4237 37.7792542228164 -122.43487763237101 (37.7792542228164, -122.434877632371)
1904 245410 2 59 2782 24th St 1 1 1 1     19 Width 0ft   6010125.3081 2102244.3008 37.752933591707794 -122.40787161420401 (37.7529335917078, -122.407871614204)
1906 244384 3 59 257 Oak St 1 1 1 2     16 Width 0ft   6005748.2149 2110309.2015 37.7748318806023 -122.423581789147 (37.7748318806023, -122.423581789147)
1971 21669 3 59 1776 Sutter St 2 1 1 2     22 4X4   6004141.1865 2114642.4934 37.7866391841692 -122.42944992335698 (37.7866391841692, -122.429449923357)
2005 7164 1 59 733 Fillmore St 1 1 1 1     12 3X3   6003503.3323 2110918.6468 37.7763782981407 -122.43139081647399 (37.7763782981407, -122.431390816474)
2016 13112 1 59 1601 Lombard St 1 1 1 1     90 3x3   6004666.807 2119779.6281 37.800774197193796 -122.42799761136001 (37.8007741971938, -122.42799761136)
2052 143142 3 59 2140 LOMBARD ST 2 1 1 2     16 Width 0ft   6002105.6639 2119495.6188 37.7998491537216 -122.43683987606899 (37.7998491537216, -122.436839876069)
2054 143144 3 59 2150 LOMBARD ST 1 1 1 2     13 Width 0ft   6002035.2938 2119489.3913 37.799828054976395 -122.437082936374 (37.7998280549764, -122.437082936374)
2056 143141 3 59 2140 LOMBARD ST 1 1 1 2     17 Width 0ft   6002153.6152 2119503.7145 37.7998741075374 -122.436674526744 (37.7998741075374, -122.436674526744)
2132 13212 1 59 2190 Lombard St 2 1 1 1     70 3X3   6001925.0681 2119471.9545 37.7997739121356 -122.437463108341 (37.7997739121356, -122.437463108341)
2173 21585 3 59 1500 Sutter St 1 1 1 2     6 2X2   6005366.3574 2114813.7602 37.7871787298771 -122.425223316098 (37.7871787298771, -122.425223316098)
2207 244533 3 59 1588 Haight St 1 1 1 2     14 Width 0ft   5998589.1758 2108666.333 37.7699142890018 -122.448227967728 (37.7699142890018, -122.448227967728)
2225 7163 3 59 730 Fillmore St 1 1 1 2     21 3X3   6003538.8779 2111021.3343 37.776662267069895 -122.43127518600001 (37.7766622670699, -122.431275186)
2607 139083 1 59 2512 Post St 1 1 1 1     16 Width 0ft   6000143.6633 2113744.4727 37.7839463117797 -122.443215821997 (37.7839463117797, -122.443215821997)
2799 142504 3 59 610 Vallejo St 2 1 1 2   09/29/1999 12:00:00 AM 12 Width 0ft   6010596.4955 2118942.3174 37.7988088315184 -122.407419256939 (37.7988088315184, -122.407419256939)
2890 17680 3 59 1020 Pierce St 1 1 1 2     12 3X3   6002416.7239 2112103.0842 37.7795688238035 -122.43523443397801 (37.7795688238035, -122.435234433978)
2903 13280 3 59 2524 Lombard St 1 1 1 2   08/15/1993 12:00:00 AM 40 3X3   6000256.3025 2119240.7621 37.7990441048198 -122.44322102307699 (37.7990441048198, -122.443221023077)
2908 140145 1 59 2077 HAYES ST 3 1 1 1     10 Width 0ft   5997912.6072 2109907.6306 37.7732838718856 -122.45065770078699 (37.7732838718856, -122.450657700787)
2909 140144 1 59 2077 HAYES ST 2 1 1 1     9 Width 0ft   5997892.6775 2109904.5645 37.7732743123753 -122.450726418895 (37.7732743123753, -122.450726418895)
2910 140146 1 59 2077 HAYES ST 4 1 1 1     10 Width 0ft   5997931.7703 2109910.6967 37.773293387477395 -122.450591634422 (37.7732933874774, -122.450591634422)
3051 99233 2 59 1111 Columbus Ave 8 1 1 1     12 3x3   6008063.2168 2121048.832 37.8044506767497 -122.416334531861 (37.8044506767497, -122.416334531861)
3154 142517 3 59 402 Columbus Ave 1 1 1 2     19 Width 0ft   6010454.8754 2118953.3694 37.798831249998 -122.40791009059299 (37.798831249998, -122.407910090593)
3328 140422 1 59 1499 TURK ST 1 1 1 18     14 Width 0ft   6002931.6326 2112346.6107 37.7802667133087 -122.43347055342699 (37.7802667133087, -122.433470553427)
3334 140424 1 59 1499 TURK ST 3 1 1 18     13 Width 0ft   6002981.8736 2112352.3525 37.7802853291655 -122.43329715719 (37.7802853291655, -122.43329715719)
3335 140428 1 59 1499 TURK ST 7 1 1 18     14 Width 0ft   6003076.6138 2112365.9894 37.7803281468599 -122.43297038187401 (37.7803281468599, -122.432970381874)
3337 140433 1 59 1499 Turk St 12 1 1 18     15 Width 0ft   6003251.7396 2112391.1099 37.7804070531695 -122.432366335522 (37.7804070531695, -122.432366335522)
3338 138120 2 59 1970 SUTTER ST 1 1 1 1     17 Width 0ft   6003157.8417 2114507.235 37.7862120754355 -122.432842389477 (37.7862120754355, -122.432842389477)
3339 140429 1 59 1499 TURK ST 8 1 1 18     15 Width 0ft   6003096.7102 2112369.578 37.7803391401181 -122.432901115602 (37.7803391401181, -122.432901115602)
3342 140426 1 59 1499 TURK ST 5 1 1 18     12 Width 0ft   6003027.0905 2112359.5298 37.7803076012967 -122.43314124413601 (37.7803076012967, -122.433141244136)
3343 140423 1 59 1499 TURK ST 2 1 1 18     13 Width 0ft   6002956.7531 2112350.9171 37.7802799627924 -122.43338395792802 (37.7802799627924, -122.433383957928)
3344 140425 1 59 1499 TURK ST 4 1 1 18     12 Width 0ft   6003006.2764 2112357.3766 37.780300508432795 -122.43321309578998 (37.7803005084328, -122.43321309579)
3347 140434 1 59 1499 Turk St 13 1 1 18     14 Width 0ft   6003279.731000001 2112394.6985 37.780418493723204 -122.43226975660299 (37.7804184937232, -122.432269756603)
3349 140427 1 59 1499 TURK ST 6 1 1 18     14 Width 0ft   6003052.211 2112362.4007 37.7803169090148 -122.43305454594 (37.7803169090148, -122.43305454594)
3351 140431 1 59 1499 Turk St 1 1 1 18     14 Width 0ft   6003184.2731 2112381.0617 37.7803756375453 -122.432599015585 (37.7803756375453, -122.432599015585)
3362 114879 2 59 1454 HAYES ST 1 1 1 1       3x3   6000868.0 2110394.0 37.7747880422892 -122.440469509771 (37.7747880422892, -122.440469509771)
3435 13052 1 59 557 Lombard St 1 1 1 1     12 3X3   6009686.1191 2120512.8313 37.8030700779734 -122.410680437216 (37.8030700779734, -122.410680437216)
3729 18005 3 59 2683 Pine St 1 1 1 2     12 3X3   6001144.5248 2114870.2639 37.787094464568796 -122.43983396035101 (37.7870944645688, -122.439833960351)
3904 4665 1 59 600X Columbus Ave 8 1 1 3     100 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881)
3945 6232 3 59 1220 Ellis St 4 1 1 2   01/02/1991 12:00:00 AM 12 3X3   6005007.0756 2113377.0261 37.7832135118405 -122.42636402033199 (37.7832135118405, -122.426364020332)
3990 21628 3 59 1615 Sutter St 2 1 1 2   06/29/1994 12:00:00 AM 6 4X4   6004654.6857 2114664.3643 37.786728295749896 -122.427674898563 (37.7867282957499, -122.427674898563)
4021 4643 1 59 515 Columbus Ave 2 1 1 1     65 3x3   6010000.9813 2119283.7816 37.7997130589262 -122.409504050861 (37.7997130589262, -122.409504050861)
4022 22785 3 59 1885 Turk St 1 1 1 2     12 3X3   6001011.2725 2112069.058 37.7793954847522 -122.44009404075399 (37.7793954847522, -122.440094040754)
4206 13097 3 59 1475 Lombard St 2 1 1 2     12 3x3   6005336.846 2119866.4127 37.801050369840205 -122.42568517574 (37.8010503698402, -122.42568517574)
4221 244055 2 59 401 Cole St 5 1 1 1     12 Width 0ft   5997910.1594 2109123.3007 37.771130163517704 -122.450609610411 (37.7711301635177, -122.450609610411)
4223 246149 1 59 1504 Waller St 4 1 1 1     16 Width 0ft   5998439.5671 2108294.2551 37.7688841037799 -122.44871865576 (37.7688841037799, -122.44871865576)
4236 246150 1 59 1504 Waller St 5 1 1 1     15 Width 0ft   5998421.7001 2108292.1353 37.7688772616464 -122.448780303512 (37.7688772616464, -122.448780303512)
4243 246126 1 59 1546 Waller St 2 1 1 1     14 Width 0ft   5998264.228999999 2108270.3316 37.768808388052605 -122.449323411621 (37.7688083880526, -122.449323411621)
4252 244056 2 59 401 Cole St 6 1 1 1     13 Width 0ft   5997913.0484 2109110.0936 37.771094065570296 -122.45059866498 (37.7710940655703, -122.45059866498)
4255 4659 1 59 600X Columbus Ave 2 1 1 3     90 5X5   6009780.1976 2119571.0943 37.800489575353104 -122.410288343699 (37.8004895753531, -122.410288343699)
4278 246148 2 59 1504 Waller St 3 1 1 1     13 Width 0ft   5998461.6736 2108298.4947 37.768897008730896 -122.44864249661501 (37.7688970087309, -122.448642496615)
Powered by Datasette · Query took 16.627ms · Data source: data.sfgov.org