sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
47177 177448 2 88 1022 Prague St 1 1 1 1     1 Width 4ft   6001291.58576 2086844.2282099999 37.7101500273691 -122.437317616421 (37.7101500273691, -122.437317616421)
165176 114986 1 88 1028 Prague St 1 1 1 1   12/29/2015 12:00:00 AM 1   Permit Number 770492 6001259.4385 2086848.65908 37.7101603659725 -122.437429040618 (37.7101603659725, -122.437429040618)
28727 177449 2 88 324 Cordova St 1 1 1 1     1 Width 3ft   6001907.3749400005 2086972.3844599999 37.7105369040276 -122.43519848992901 (37.7105369040276, -122.435198489929)
60469 80737 2 88 186 Allison St 1 1 1 1 1 03/22/2003 12:00:00 AM 1     6000043.5525400005 2087718.3093599998 37.7124790304587 -122.44169374357 (37.7124790304587, -122.44169374357)
64511 177400 2 88 1112 Russia Ave 1 1 1 1     1 Width 2ft   6003994.8137 2089359.3172799998 37.7172092225078 -122.428153843121 (37.7172092225078, -122.428153843121)
34177 177411 2 88 474 Munich St 1 1 1 1     1 Width 2ft   6003775.47727 2089725.4167 37.7182020389599 -122.42893807173 (37.7182020389599, -122.42893807173)
38105 177410 2 88 470 Munich St 1 1 1 1     1 Width 2ft   6003782.11139 2089736.37793 37.718232511606296 -122.428915921448 (37.7182325116063, -122.428915921448)
23545 177395 2 88 715 Madrid St 1 1 1 1     1 Width 2ft   6001937.656140001 2089768.77997 37.718216907458704 -122.435293726344 (37.7182169074587, -122.435293726344)
71293 208847 2 88 422 Grafton Ave 1 1 1 1     1 Width 3ft   5995505.44933 2090582.5246599999 37.7200838784427 -122.457585828931 (37.7200838784427, -122.457585828931)
60143 72252 2 88 531 Madrid St 1 1 1 1 1 01/06/1996 12:00:00 AM 1     6002585.93283 2090796.9641 37.7210768666757 -122.43312633500601 (37.7210768666757, -122.433126335006)
76764 108377 1 88 226 Munich St 1 1 1 1 1   1 3x3 Permit Number 773810 6004631.19295 2091083.0586299999 37.7219782266077 -122.42607682199801 (37.7219782266077, -122.426076821998)
44581 177415 2 88 451 Edinburgh St 1 1 1 1     1 Width 3ft   6003094.686869999 2091098.4419099998 37.7219335042119 -122.431389232421 (37.7219335042119, -122.431389232421)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
171742 115979 4 88 2x Olmstead St 4 1 1 1     1 3x3   6011610.19593 2091240.25279 37.722801825729604 -122.401963063449 (37.7228018257296, -122.401963063449)
172623 115978 4 88 2x Olmstead St 3 1 1 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
182061 115977 4 88 2x Olmstead St 2 1 1 1     1 3x3   6011639.0005 2091249.90123 37.722829925953896 -122.40186416949 (37.7228299259539, -122.40186416949)
12646 115976 4 88 2x Olmstead St 1 1 1 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
71256 52791 1 88 955@ MOSCOW Excelsior Ave 1 1 1 1   05/25/2006 12:00:00 AM 1   Permit Number 48832 6004754.52241 2091271.3997400003 37.7225023397811 -122.425663900979 (37.7225023397811, -122.425663900979)
174665 177435 2 88 99 Karen Ct 1 1 1 1     1 Width 2ft   6010088.68836 2091439.3296700001 37.72326341446679 -122.407236642978 (37.7232634144668, -122.407236642978)
75167 177436 2 88 99 Karen Ct 2 1 1 1     1 Width 2ft   6010107.2934 2091444.47715 37.7232785896114 -122.40717269128099 (37.7232785896114, -122.407172691281)
36033 177437 2 88 93 Karen Ct 1 1 1 1     1 Width 2ft   6010115.68283 2091447.6223799998 37.72328769526371 -122.407143912081 (37.7232876952637, -122.407143912081)
171865 114755 1 88 89 Karen Ct 1 1 1 1   12/04/2015 12:00:00 AM 1   Permit Number 777135 6010155.72688 2091460.8073900002 37.723326139481294 -122.407006415641 (37.7233261394813, -122.407006415641)
176355 177438 2 88 83 Karen Ct 1 1 1 1     1 Width 2ft   6010165.7616 2091462.99776 37.723332715313894 -122.406971881647 (37.7233327153139, -122.406971881647)
37487 177439 2 88 79 Karen Ct 1 1 1 1     1 Width 2ft   6010188.86492 2091471.00105 37.7233559834822 -122.406892581232 (37.7233559834822, -122.406892581232)
149083 177440 2 88 71 Karen Ct 1 1 1 1     1 Width 2ft   6010238.57006 2091486.2001099999 37.7234004981218 -122.406721829644 (37.7234004981218, -122.406721829644)
41960 177441 2 88 71 Karen Ct 2 1 1 1     1 Width 2ft   6010258.66598 2091491.8701799999 37.7234171913236 -122.406652760812 (37.7234171913236, -122.406652760812)
160433 177442 2 88 67 Karen Ct 1 1 1 1     1 Width 2ft   6010267.21749 2091493.9064200001 37.723423260860706 -122.40662334309799 (37.7234232608607, -122.406623343098)
56518 177443 2 88 63 Karen Ct 1 1 1 1     1 Width 2ft   6010306.59987 2091507.00491 37.7234614298874 -122.40648812732799 (37.7234614298874, -122.406488127328)
154138 177445 2 88 15 Karen Ct 4 1 1 1     1 Width 5ft   6010506.33995 2091553.32971 37.723599800462296 -122.405800920297 (37.7235998004623, -122.405800920297)
40468 114753 1 88 10 Karen Ct 1 1 1 1   12/04/2015 12:00:00 AM 1   Permit Number 777133 6010495.976919999 2091580.43732 37.723673652787596 -122.40583865223101 (37.7236736527876, -122.405838652231)
23977 177421 2 88 0 Santa Ynez Ave 1 1 1 1     1 Width 4ft   6001079.38248 2091791.86287 37.7237230579705 -122.438405269984 (37.7237230579705, -122.438405269984)
149661 95133 1 88 450@ Wayland Somerset St 2 1 1 1   01/04/2010 12:00:00 AM 1 3x3 Permit Number 54066 6010089.84133 2092358.2905700002 37.725786753837 -122.407297408351 (37.725786753837, -122.407297408351)
153325 43146 1 88 243 Gambier St 1 1 1 1 1 12/01/2015 12:00:00 AM 1   Permit Number 774635 6005976.40354 2092622.5546099998 37.7262812865364 -122.421536041574 (37.7262812865364, -122.421536041574)
26535 177420 2 88 121 Cotter St 1 9 1 1     1 Width 3ft   6001985.26237 2093449.7289900002 37.728326668619296 -122.435392337892 (37.7283266686193, -122.435392337892)
181142 208857 2 88 1 Gennessee St 1 9 1 1     1 Width 8ft   5997408.7613699995 2093610.5667299998 37.7285073190505 -122.451225020336 (37.7285073190505, -122.451225020336)
54565 177434 2 88 131 Brussels St 1 1 1 1     1 Width 4ft   6010258.4147 2094004.87757 37.7303173692474 -122.40683065573099 (37.7303173692474, -122.406830655731)
185429 177428 2 88 274 Ney St 1 1 1 1     1 Width 3ft   6005170.17326 2094055.30176 37.7301698012868 -122.42442500480499 (37.7301698012868, -122.424425004805)
74564 177429 2 88 278 Ney St 1 1 1 1     1 Width 3ft   6005195.233080001 2094056.1980299999 37.7301736773527 -122.42433843338699 (37.7301736773527, -122.424338433387)
34364 177430 2 88 294 Ney St 1 1 1 1     1 Width 2ft   6005292.64234 2094059.9977799999 37.730189610640004 -122.424001946647 (37.73018961064, -122.424001946647)
185939 193350 2 88 1752 Quesada Ave 1 4 1 1     1 Width 4ft   6014471.5284 2095248.21375 37.7339661589078 -122.39235215802799 (37.7339661589078, -122.392352158028)
174129 193351 2 88 1752 Quesada Ave 2 4 1 1     1 Width 4ft   6014452.02014 2095263.45344 37.734006920685204 -122.392420670182 (37.7340069206852, -122.392420670182)
23030 17382 1 88 1627 Palou Ave 1 1 1 1   08/21/2015 12:00:00 AM 1 3X3 Permit Number 776412 6014690.32946 2095358.97831 37.7342824432881 -122.39160343105 (37.7342824432881, -122.39160343105)
48337 230332 2 88 73 Leese St 2 1 1 1     1 Width 3ft   6005526.20735 2096295.99594 37.736342348511 -122.423353372654 (37.736342348511, -122.423353372654)
65368 230328 2 88 518 Banks St 1 1 1 1     1 Width 2ft   6008539.17549 2096369.5184099998 37.7367138134929 -122.41294144560601 (37.7367138134929, -122.412941445606)
57558 230352 2 88 136 Moffitt St 1 1 1 1     1 Width 2ft   6002654.78135 2096839.9013099999 37.7376733091617 -122.433319933881 (37.7376733091617, -122.433319933881)
176498 230339 2 88 65 Chenery St 4 1 1 1     1 Width 3ft   6004912.08615 2097855.70847 37.7405902872201 -122.425587619594 (37.7405902872201, -122.425587619594)
147660 230340 2 88 65 Chenery St 5 1 1 1     1 Width 3ft   6004910.8116 2097869.74707 37.7406287620114 -122.425593025396 (37.7406287620114, -122.425593025396)
38961 230341 2 88 65 Chenery St 6 1 1 1     1 Width 3ft   6004909.36728 2097888.2006599996 37.7406793497697 -122.425599332346 (37.7406793497697, -122.425599332346)
44551 230342 2 88 65 Chenery St 7 1 1 1     1 Width 3ft   6004911.05921 2097907.1085200002 37.740731362062704 -122.42559482765499 (37.7407313620627, -122.425594827655)
153254 230343 2 88 65 Chenery St 8 1 1 1     1 Width 3ft   6004910.0558400005 2097921.66035 37.7407712613889 -122.42559933235 (37.7407712613889, -122.42559933235)
152854 208839 2 88 131 Wawona St 1 1 1 1     1 Width 3ft   5992959.48741 2098205.81206 37.74086896193 -122.466940197353 (37.74086896193, -122.466940197353)
157255 230354 2 88 531 30th St 1 9 1 1     1 Width 8ft   6003165.5903900005 2098301.47872 37.7417154299181 -122.431658143201 (37.7417154299181, -122.431658143201)
168110 230355 2 88 397 30th St 1 1 1 1     1 Width 3ft   6004002.34815 2098351.08289 37.7418990256315 -122.428768448829 (37.7418990256315, -122.428768448829)
55956 246808 2 88 162 Brewster St 1 4 1 1     1 Width 2ft   6010230.46229 2099004.5054099998 37.744043711743004 -122.407279600877 (37.744043711743, -122.407279600877)
170923 230330 2 88 38 Bonview St 1 1 1 1     1 Width 2ft   6007670.81289 2099114.19378 37.744201302652705 -122.416138084916 (37.7442013026527, -122.416138084916)
180726 230329 2 88 33 Prospect Ave 1 1 1 1     1 Width 2ft   6007181.85452 2099302.37672 37.7446905059706 -122.417842137412 (37.7446905059706, -122.417842137412)
74610 230333 2 88 629 28th St 1 1 1 1     1 Width 2ft   6001808.677069999 2099403.33262 37.7446638554471 -122.436428732821 (37.7446638554471, -122.436428732821)
146648 230316 2 88 131 Peralta Ave 1 1 1 1     1 Width 3ft   6010129.26175 2100145.52723 37.7471710439032 -122.407709968747 (37.7471710439032, -122.407709968747)
150867 230315 2 88 131 Peralta Ave 2 1 1 1     1 Width 3ft   6010141.9244099995 2100150.42012 37.7471851875523 -122.407666527004 (37.7471851875523, -122.407666527004)
165446 230327 2 88 204 27th St 1 1 1 1     1 Width 3ft   6005133.403419999 2100215.61494 37.747082555133 -122.42499025209999 (37.747082555133, -122.4249902521)
176873 230285 2 88 112 27th St 1 1 1 1     1 Width 4ft   6005732.266 2100246.49817 37.7472011631029 -122.422921627052 (37.7472011631029, -122.422921627052)
150105 230317 2 88 609 Precita Ave 1 1 1 1     1 Width 3ft   6009667.55833 2100362.09801 37.74773984264029 -122.40932179038799 (37.7477398426403, -122.409321790388)
27217 230322 2 88 4089 26th St 1 1 1 1     1 Width 5ft   6003345.458190001 2100655.86235 37.7481902141138 -122.43120423378299 (37.7481902141138, -122.431204233783)
171575 230321 2 88 1297 Sanchez St 1 1 1 1     1 Width 4ft   6003909.46951 2100753.0320099997 37.748488965296204 -122.42926082853901 (37.7484889652962, -122.429260828539)
28385 230289 2 88 3798 25th St 4 1 1 1     1 Width 4ft   6005260.07773 2101390.67485 37.750316153870294 -122.424635797817 (37.7503161538703, -122.424635797817)
46226 230288 2 88 3798 25th St 3 1 1 1     1 Width 4ft   6005272.34355 2101391.85682 37.7503200920091 -122.424593465816 (37.7503200920091, -122.424593465816)
39226 230287 2 88 3798 25th St 2 1 1 1     1 Width 4ft   6005284.60936 2101393.03847 37.750324029253505 -122.42455113382299 (37.7503240292535, -122.424551133823)
66302 61318 1 88 1419 Kansas St 1 1 1 1 1 06/02/2014 12:00:00 AM 1   Permit Number 772899 6011764.55732 2101642.9103 37.751373940974204 -122.402160470048 (37.7513739409742, -122.402160470048)
151933 230309 2 88 3668 24th St 1 1 1 1     1 Width 3ft   6005328.964269999 2101978.057 37.7519328597144 -122.424439358013 (37.7519328597144, -122.424439358013)
137500 208837 2 88 1958 17th Ave 1 1 1 1     1 Width 2ft   5990984.78596 2102065.3313 37.7513520289909 -122.474049439736 (37.7513520289909, -122.474049439736)
48794 193328 2 88 900 24th St 1 1 1 1     1 Width 4ft   6015574.56777 2102562.74505 37.7541115402303 -122.389049112743 (37.7541115402303, -122.389049112743)
167402 193327 2 88 1398 Tennessee St 4 1 1 1     1 Width 5ft   6015585.429769999 2102602.25227 37.7542206208044 -122.38901430715799 (37.7542206208044, -122.389014307158)
135931 193323 2 88 1189 Tennessee St 1 1 1 1     1 Width 3ft   6015597.773159999 2103545.2289400003 37.7568105190107 -122.38903745483299 (37.7568105190107, -122.389037454833)
79119 105692 1 88 2523 HARRISON ST 1 1 1 1 1   1 3x3   6008930.3 2103627.5 37.7566645705002 -122.41210193949699 (37.7566645705002, -122.412101939497)
81426 105758 1 88 2523 HARRISON ST 1 1 1 1 1   1 3x3   6008930.3 2103627.5 37.7566645705002 -122.41210193949699 (37.7566645705002, -122.412101939497)
87725 105693 1 88 2523 HARRISON ST   1 1 1     1 3x3   6008930.3 2103627.5 37.7566645705002 -122.41210193949699 (37.7566645705002, -122.412101939497)
30218 208836 2 88 1677 18th Ave 1 2 1 1     1 Width 3ft   5990563.73281 2104000.71919 37.756641694668396 -122.47564678406499 (37.7566416946684, -122.475646784065)
181254 208834 2 88 1669 18th Ave 1 9 1 1     1 Width 3ft   5990551.61783 2104055.61326 37.756791716882404 -122.47569268998699 (37.7567917168824, -122.475692689987)
148326 208833 2 88 1655 18th Ave 1 1 1 1     1 Width 3ft   5990561.21502 2104064.77483 37.75681742851079 -122.47566016868299 (37.7568174285108, -122.475660168683)
42297 80634 2 88 577 Arkansas St 1 1 1 1 1 10/05/2002 12:00:00 AM 1     6013018.0309 2104352.7115 37.758884352052604 -122.398015861652 (37.7588843520526, -122.398015861652)
102284 109757 1 88 3590 20TH ST 1 1 1 1   12/01/2015 12:00:00 AM 1 3x3 Permit Number 772584 6006354.0 2104372.0 37.75856390529879 -122.421064595152 (37.7585639052988, -122.421064595152)
34741 230311 2 88 2901 20th St 1 1 1 1     1 Width 3ft   6009504.69694 2104506.09173 37.7591091969416 -122.41017748630101 (37.7591091969416, -122.410177486301)
133786 230312 2 88 2901 20th St 3 1 1 1     1 Width 3ft   6009544.39548 2104509.50944 37.759120806308204 -122.41004043054701 (37.7591208063082, -122.410040430547)
134885 102443 1 88 514 Missouri St 1 1 1 1   08/07/2013 12:00:00 AM 1   Permit Number 770339 6013518.76597 2104573.81866 37.7595193399709 -122.396299571184 (37.7595193399709, -122.396299571184)
45125 193342 2 88 401 Texas St 4 4 1 1     1 Width 3ft   6013812.69862 2105193.07398 37.7612360315304 -122.39532637971901 (37.7612360315304, -122.395326379719)
153849 193344 2 88 1133 19th St 3 2 1 1     1 Width 3ft   6014141.435 2105240.8231200003 37.761385417914205 -122.394192754591 (37.7613854179142, -122.394192754591)
187472 193345 2 88 1133 19th St 4 2 1 1     1 Width 3ft   6014171.26133 2105242.63423 37.7613920486234 -122.394089723782 (37.7613920486234, -122.394089723782)
165491 193346 2 88 1133 19th St 5 2 1 1     1 Width 3ft   6014187.49963 2105244.21667 37.761397296172 -122.394033672633 (37.761397296172, -122.394033672633)
77021 32342 1 88 130 Lexington St 1 1 1 1 1 02/20/1998 12:00:00 AM 1   Permit Number 770451 6006450.269730001 2105316.80145 37.761163536302206 -122.420798725186 (37.7611635363022, -122.420798725186)
40529 230283 2 88 626 Potrero Ave 1 1 1 1     1 Width 3ft   6010353.7895 2105370.3020900004 37.761529680867 -122.40730182853201 (37.761529680867, -122.407301828532)
140795 70259 1 88 613 York St 1 1 1 1   01/24/2014 12:00:00 AM 1 3x5 Permit Number 771047 6009849.60881533 2105419.99624628 37.761637898995104 -122.409049096462 (37.7616378989951, -122.409049096462)
120994 95216 2 88 3623 18th St 1 1 1 1     1 3x3 Magnolia planted in Fall; 2010 without permit; to replace Acacia baileyana; which there was no permit for planting or removing. 6005441.0 2105452.0 37.761477821729706 -122.424298976847 (37.7614778217297, -122.424298976847)
37514 193348 2 88 2501 18th St 7 1 1 1     1 Width 5ft   6010227.27367 2105486.95448 37.7618429003376 -122.407747622459 (37.7618429003376, -122.407747622459)
132124 193349 2 88 2501 18th St 13 1 1 1     1 Width 5ft   6010309.72434 2105489.81742 37.761855376635104 -122.407462658778 (37.7618553766351, -122.407462658778)
65070 78191 2 88 680 Tennessee St 1 1 1 1 1 10/05/2002 12:00:00 AM 1     6015407.71241 2105894.14692 37.7632496064147 -122.389858829046 (37.7632496064147, -122.389858829046)
181671 230338 2 88 31 Walter St 1 1 1 1     1 Width 3ft   6003171.4913099995 2108119.01737 37.7686723924455 -122.43233874923 (37.7686723924455, -122.43233874923)
53694 109906 3 88 1415 Howard St 3 1 1 2     1 3x3   6008272.88194 2109795.90835 37.773564680997296 -122.41481207772199 (37.7735646809973, -122.414812077722)
59077 118718 2 88 818 44th Ave 1 1 1 1     1 Width 3ft   5982331.02075 2110159.51383 37.7730712650544 -122.504574285424 (37.7730712650544, -122.504574285424)
151720 193376 2 88 778 Tehama St 3 1 1 1     1 Width 2ft   6008940.991169999 2110196.43665 37.7747019546579 -122.41252929798999 (37.7747019546579, -122.41252929799)
163844 123126 2 88 771 11th Ave 1 1 1 1     1 Width 4ft   5992555.29457 2110202.5485900003 37.773785530078605 -122.469210678659 (37.7737855300786, -122.469210678659)
182454 193375 2 88 778 Tehama St 2 1 1 1     1 Width 2ft   6008954.62424 2110209.1337900003 37.774737583109705 -122.41248303597901 (37.7747375831097, -122.412483035979)
Powered by Datasette · Query took 9.121ms · Data source: data.sfgov.org