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)
1169 246080 1 59 1390 Waller St 1 1 1 1   03/29/1979 12:00:00 AM 12 Width 0ft Permit Number 17683 5999123.3551 2108389.3434 37.7691842694065 -122.446360330481 (37.7691842694065, -122.446360330481)
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)
1336 7171 3 59 801 Fillmore St 3 1 1 2     12 3x3 Permit Number 780067 6003475.9145 2111120.5411 37.7769310959731 -122.431500078765 (37.7769310959731, -122.431500078765)
1340 7172 3 59 801 Fillmore St 4 1 1 2     12 3x3 Permit Number 780067 6003478.683999999 2111101.7087 37.7768795438362 -122.43148915347099 (37.7768795438362, -122.431489153471)
1343 7169 3 59 801 Fillmore St 1 1 1 2     12 3x3 Permit Number 780067 6003470.3756 2111160.9753 37.777041804334296 -122.43152212680799 (37.7770418043343, -122.431522126808)
1345 7170 3 59 801 Fillmore St 2 1 1 2     12 3x3 Permit Number 780067 6003473.1451 2111141.589 37.776988731328295 -122.43151116193 (37.7769887313283, -122.43151116193)
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)
1873 20151 1 59 1043 Steiner St 1 1 1 1   10/13/2016 12:00:00 AM 3 3x3 Permit Number 778996 6002888.3687 2111863.5194 37.7789378108444 -122.433585688352 (37.7789378108444, -122.433585688352)
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)
2797 142505 1 59 620 Vallejo St 3 1 1 1   12/17/2014 12:00:00 AM 22 Width 0ft Permit Number 774306 6010566.6807 2118940.2612 37.7988015168915 -122.407522281284 (37.7988015168915, -122.407522281284)
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)
2878 57526 1 59 501 Grove St 1 1 1 1   12/19/1981 12:00:00 AM 13 3x3 Permit Number 19437 6005352.078 2111299.9206 37.7775297860553 -122.42502261513701 (37.7775297860553, -122.425022615137)
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)
2923 140143 1 59 2077 HAYES ST 1 1 1 1   05/06/1981 12:00:00 AM 9 Width 0ft Permit Number 19125 5997871.2148 2109901.8816 37.7732657172386 -122.45080046745001 (37.7732657172386, -122.45080046745)
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)
3219 142514 1 59 624 VALLEJO ST 4 1 1 1   12/17/2014 12:00:00 AM 20 Width 0ft Permit Number 774306 6010535.3238 2118936.1488 37.7987884700296 -122.407630496745 (37.7987884700296, -122.407630496745)
3249 142515 1 59 624 VALLEJO ST 5 1 1 1   12/17/2014 12:00:00 AM 21 Width 0ft Permit Number 774306 6010502.9388 2118931.0084 37.7987725428783 -122.40774219721901 (37.7987725428783, -122.407742197219)
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)
Powered by Datasette · Query took 2.47ms · Data source: data.sfgov.org