sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3087 19650 3 36 100 STAIRWAY5 49 1 1 2     12 60ST            
4862 19656 3 36 100 STAIRWAY5 55 1 1 2     18 60ST            
5896 19680 3 36 100 STAIRWAY5 79 1 1 2     12 60ST            
5976 19649 3 36 100 STAIRWAY5 48 1 1 2     12 60ST            
6914 19672 3 36 100 STAIRWAY5 71 1 1 2     12 60ST            
7103 19675 3 36 100 STAIRWAY5 74 1 1 2     12 60ST            
7153 19677 3 36 100 STAIRWAY5 76 1 1 2     12 60ST            
7446 19683 3 36 100 STAIRWAY5 82 1 1 2     12 60ST            
9546 19678 3 36 100 STAIRWAY5 77 1 1 2     12 60ST            
9875 19651 3 36 100 STAIRWAY5 50 1 1 2     12 60ST            
10475 19661 3 36 100 STAIRWAY5 60 1 1 2     12 60ST            
12748 19671 3 36 100 STAIRWAY5 70 1 1 2     12 60ST            
14057 19674 3 36 100 STAIRWAY5 73 1 1 2     12 60ST            
14729 19657 3 36 100 STAIRWAY5 56 1 1 2     18 60ST            
15686 19660 3 36 100 STAIRWAY5 59 1 1 2     18 60ST            
16120 19653 3 36 100 STAIRWAY5 52 1 1 2     12 60ST            
36323 182757 2 36 1768 31st Ave 7 1 1 1     13 Width 0ft   5986603.8813 2103201.6608 37.7542173383784 -122.489282448699 (37.7542173383784, -122.489282448699)
152916 182758 2 36 1762 31st Ave 8 1 1 1     7 Width 0ft   5986605.2662 2103225.2032 37.7542820602368 -122.48927939027 (37.7542820602368, -122.48927939027)
75991 182754 2 36 1780 31st Ave 4 1 1 1     15 Width 0ft   5986605.2662 2103133.3419 37.7540298341253 -122.489272636653 (37.7540298341253, -122.489272636653)
25006 182753 2 36 1788 31st Ave 3 1 1 1     12 Width 0ft   5986606.1894 2103114.4157 37.753977921823 -122.489268052608 (37.753977921823, -122.489268052608)
178619 182752 2 36 1790 31st Ave 2 1 1 1     20 Width 0ft   5986608.9591 2103091.7966 37.7539159776066 -122.48925681152599 (37.7539159776066, -122.489256811526)
28860 51570 1 36 227 24th Ave 1 1 1 1 1 02/04/2005 12:00:00 AM 17   Permit Number 47867 5988337.51894 2114460.53389 37.7852321378524 -122.48411277430401 (37.7852321378524, -122.484112774304)
148918 62209 1 36 227 24th Ave 1 1 1 1 1 10/12/1985 12:00:00 AM 16   Permit Number 22331 5988338.57879 2114482.10714 37.7852914335725 -122.48411069019699 (37.7852914335725, -122.484110690197)
52315 120312 2 36 160 23rd Ave 1 1 1 1     21 Width 4ft   5988698.92527 2114284.33233 37.784769373123005 -122.482849516634 (37.784769373123, -122.482849516634)
84641 118343 2 36 162 23rd Ave 1 1 1 1       3x3   5988772.0 2114277.0 37.784753492132104 -122.48259616764 (37.7847534921321, -122.48259616764)
98034 106401 2 36 22 22nd Ave 1 1 1 1     15 5x6   5988976.53234 2115004.21174 37.786762106623705 -122.481941850779 (37.7867621066237, -122.481941850779)
31839 108738 2 36 22 22nd Ave 3 1 1 1     19 5x6   5988982.34798 2115051.76356 37.786893008658296 -122.481925214884 (37.7868930086583, -122.481925214884)
53672 108737 2 36 22 22nd Ave 2 1 1 1     13 5x6   5988982.16462 2115033.23873 37.786842134064706 -122.481924491754 (37.7868421340647, -122.481924491754)
139042 108739 2 36 22 22ND AVE 4 1 1 1       5x6   5989006.7 2115022.6 37.786814349999105 -122.48183882646299 (37.7868143499991, -122.481838826463)
97915 121201 2 36 423 18th Ave 2 1 1 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
51360 110401 2 36 419X 18th Ave 2 1 1 10 10   27 3x3   5990271.90904 2112469.3758 37.779877404965504 -122.4772748837 (37.7798774049655, -122.4772748837)
176523 121988 2 36 528 15th Ave 1 1 1 1     22 Width 4ft   5991288.02079 2111782.83574 37.778051257453704 -122.473709641027 (37.7780512574537, -122.473709641027)
20112 29963 3 36 500X Junipero Serra Blvd 6 11 1 2   03/09/2013 12:00:00 AM 3 3x3   5991394.8537099995 2093447.95886 37.7277146673841 -122.47200336878099 (37.7277146673841, -122.472003368781)
181793 206291 3 36 500x Junipero Serra Blvd 38 11 1 2     7 Width 0ft   5991445.95006 2094262.4550299998 37.7299540269465 -122.471886066612 (37.7299540269465, -122.471886066612)
12006 1294 3 36 4000X Alemany Blvd 2 11 1 2     25 10   5991953.08243 2087152.92109 37.7104623187479 -122.469615507754 (37.7104623187479, -122.469615507754)
10605 1293 3 36 4000X Alemany Blvd 1 11 1 2     50 10   5991961.87152 2087160.6390900002 37.7104840184951 -122.46958569253701 (37.7104840184951, -122.469585692537)
160018 206274 2 36 130 Saint Francis Blvd 2 2 1 1     15 Width 10ft   5992348.03804 2095988.5894400002 37.7347457173231 -122.468893032011 (37.7347457173231, -122.468893032011)
128360 106364 6 36 155 BORICA ST 1 7 1 1           5992696.0 2092292.5 37.724617268406604 -122.467421338179 (37.7246172684066, -122.467421338179)
60209 124039 2 36 737 Lake St 2 1 1 1     18 Width 6ft   5993203.99509 2114811.08925 37.7864767964616 -122.467301904185 (37.7864767964616, -122.467301904185)
44606 206273 2 36 335 Saint Francis Blvd 1 2 1 1     20 Width 10ft   5992818.8463 2096062.89914 37.734976942936 -122.46727070178301 (37.734976942936, -122.467270701783)
41921 206270 2 36 301 Santa Clara Ave 1 2 1 1     20 Width 10ft   5993141.97199 2095936.7158400002 37.7346491229581 -122.46614438456801 (37.7346491229581, -122.466144384568)
42087 206272 2 36 70 Santa Clara Ave 1 2 1 1     21 Width 10ft   5993269.28362 2097133.14802 37.7379415715549 -122.46579112907 (37.7379415715549, -122.46579112907)
162695 206275 2 36 531 Saint Francis Blvd 1 2 1 1     20 Width 8ft   5993329.29471 2096110.62255 37.735137433227294 -122.465509381364 (37.7351374332273, -122.465509381364)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
107199 112376 6 36 801 ULLOA ST 2 1 1 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
48470 206295 2 36 1289 08th Ave 1 1 1 1     21 Width 3ft   5993598.25468 2106726.01097 37.76430008921321 -122.465350355136 (37.7643000892132, -122.465350355136)
142623 101243 2 36 1299X 08th Ave 1 1 1 1       3x3   5993606.4 2106666.6 37.7641374320151 -122.465317867129 (37.7641374320151, -122.465317867129)
104962 97215 3 36 300X Claremont Blvd 2 5 1 10     20 4x12   5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
118995 97217 3 36 300X Claremont Blvd 4 16 1 10     18     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
143072 97216 3 36 300X Claremont Blvd 3 16 1 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
137222 206278 2 36 121 Ortega St 1 2 1 1     23 Width 2ft   5993596.441240001 2102535.31336 37.7527934164816 -122.46505223798701 (37.7527934164816, -122.465052237987)
33604 206271 2 36 1510 Monterey Blvd 1 2 1 1     14 Width 4ft   5993525.3861 2095199.14432 37.7326460476786 -122.46476525891899 (37.7326460476786, -122.464765258919)
158289 206296 2 36 1495 Monterey Blvd 2 2 1 1     13 Width 3ft   5993533.84781 2095106.3143799999 37.7323916474557 -122.464729266269 (37.7323916474557, -122.464729266269)
96285 96780 2 36 1502X Monterey Blvd 1 1 1 1     12 3x50   5993551.4 2095180.8 37.732597178480894 -122.4646739916 (37.7325971784809, -122.4646739916)
123678 97297 1 36 450 06th Ave 1 1 1 1           5994062.8 2112448.2 37.7800384821655 -122.46415907596202 (37.7800384821655, -122.464159075962)
136459 123281 2 36 400 06th Ave 12 1 1 1     19 Width 3ft   5994069.81611 2112666.40035 37.7806380059293 -122.464150649226 (37.7806380059293, -122.464150649226)
33400 123284 2 36 400 06th Ave 7 1 1 1     20 Width 3ft   5994067.51233 2112489.4392 37.780151985503004 -122.46414576865699 (37.780151985503, -122.464145768657)
28943 206276 2 36 1575 07th Ave 3 1 1 1     16 Width 2ft   5993975.596059999 2104757.26291 37.758916173673605 -122.463902332454 (37.7589161736736, -122.463902332454)
166171 123313 2 36 401 05th Ave 17 1 1 1     18 Width 4ft   5994324.87447 2112727.37957 37.7808201355721 -122.46327271312599 (37.7808201355721, -122.463272713126)
156619 123312 2 36 401 05th Ave 16 1 1 1     16 Width 4ft   5994326.95545 2112691.62436 37.7807220812689 -122.46326291878201 (37.7807220812689, -122.463262918782)
166280 123309 2 36 401 05th Ave 13 1 1 1     17 Width 4ft   5994326.71646 2112582.77127 37.7804231861892 -122.463255844547 (37.7804231861892, -122.463255844547)
35053 123308 2 36 401 05th Ave 12 1 1 1     16 Width 4ft   5994328.16527 2112546.87269 37.7803247018036 -122.46324822682399 (37.7803247018036, -122.463248226824)
157434 206269 2 36 576 Dewey Blvd 3 1 1 1     24 Width 6ft   5994053.8446 2099403.66341 37.744221064358705 -122.463243244477 (37.7442210643587, -122.463243244477)
43433 123307 2 36 401 05th Ave 11 1 1 1     20 Width 4ft   5994333.67454 2112494.59894 37.7801814895167 -122.46322537368 (37.7801814895167, -122.46322537368)
69722 123306 2 36 401 05th Ave 10 1 1 1     20 Width 4ft   5994336.05737 2112465.72885 37.7801023572772 -122.463215034991 (37.7801023572772, -122.463215034991)
66055 206268 2 36 576 Dewey Blvd 2 1 1 1     25 Width 6ft   5994062.286309999 2099409.86302 37.74423857324471 -122.463214504856 (37.7442385732447, -122.463214504856)
127278 206267 2 36 576 Dewey Blvd 1 1 1 1     16 Width 6ft   5994070.0708800005 2099419.58791 37.7442657237995 -122.46318829319901 (37.7442657237995, -122.463188293199)
129571 206277 2 36 100 Yerba Buena Ave 1 2 1 1     15 Width 6ft   5994075.53376 2096720.2997299999 37.73685446745821 -122.46297360255801 (37.7368544674582, -122.462973602558)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
85276 105668 2 36 301X DORADO TER 2 19 1 1     12     5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
70753 206290 1 36 519 Faxon Ave 1 1 1 1   12/15/1989 12:00:00 AM 13 Width 3ft Permit Number 28366 5994747.213769999 2092021.25084 37.7239906908132 -122.460310960879 (37.7239906908132, -122.460310960879)
134942 123506 2 36 2630 Fulton St 1 1 1 1     19 Width 8ft   5995210.5755199995 2110304.28467 37.774217945514 -122.460033072871 (37.774217945514, -122.460033072871)
51352 206266 2 36 1217 Arguello Blvd 1 1 1 1     14 Width 2ft   5995764.33389 2107222.76394 37.76578872620429 -122.457894496039 (37.7657887262043, -122.457894496039)
152750 206265 2 36 1223 Arguello Blvd 1 1 1 1     24 Width 4ft   5995764.11125 2107172.86823 37.765651712687394 -122.45789165508002 (37.7656517126874, -122.45789165508)
10033 54506 1 36 1215 Arguello Blvd 1 1 1 1   07/12/1972 12:00:00 AM   5x5 Permit Number 10300 5995769.71808299 2107217.0895637 37.7657734551651 -122.457875462722 (37.7657734551651, -122.457875462722)
129818 206264 2 36 1235 Arguello Blvd 1 1 1 1     25 Width 4ft   5995769.52537 2107097.9044 37.7654461924254 -122.45786750379101 (37.7654461924254, -122.457867503791)
55567 206292 2 36 1275 Arguello Blvd 9 1 1 1     14 Width 5ft   5995766.39546 2106910.95096 37.764932686723 -122.457864799544 (37.764932686723, -122.457864799544)
65730 206293 2 36 1283 Arguello Blvd 1 1 1 1     14 Width 5ft   5995766.93118 2106868.2316900003 37.7648154214066 -122.457859855072 (37.7648154214066, -122.457859855072)
53297 206294 2 36 1291 Arguello Blvd 1 1 1 1     14 Width 5ft   5995770.00748 2106810.2745 37.7646564626472 -122.457845020728 (37.7646564626472, -122.457845020728)
86521 54509 1 36 1291 Arguello Blvd 1 1 1 1   07/12/1972 12:00:00 AM   6x5 Permit Number 10303 5995784.13645716 2106797.98257299 37.7646235238936 -122.457795263133 (37.7646235238936, -122.457795263133)
38508 206297 2 36 565 Los Palmos Dr 1 1 1 1     13 Width 3ft   5996520.85452 2095770.92684 37.7343882701062 -122.454450538684 (37.7343882701062, -122.454450538684)
157373 246154 2 36 1730 Waller St 1 1 1 1     20 Width 0ft   5997434.1745 2108152.8339 37.768438254928704 -122.45218601649401 (37.7684382549287, -122.452186016494)
146060 106499 1 36 420X Shrader St 2 1 1 1           5997462.73555 2109001.92463 37.770771276139705 -122.452148498658 (37.7707712761397, -122.452148498658)
67715 248403 2 36 1713 Waller St 1 1 1 1     20 Width 0ft   5997457.4924 2108113.6175 37.7683319124677 -122.452102532521 (37.7683319124677, -122.452102532521)
149232 244110 2 36 1890 Page St 2 1 1 1     18 Width 0ft   5997524.2657 2108863.6995 37.7703952699374 -122.451925692038 (37.7703952699374, -122.451925692038)
41887 248497 2 36 114 Beulah St 1 1 1 1     14 Width 0ft   5997504.128 2107818.662 37.7675247113964 -122.45191994324699 (37.7675247113964, -122.451919943247)
84347 106497 1 36 1890 Page St 2 1 1 1         Permit Number 772114 5997541.6 2108881.8 37.770445962098705 -122.451867038975 (37.7704459620987, -122.451867038975)
180713 244109 2 36 1890 Page St 1 1 1 1     21 Width 0ft   5997547.3781 2108866.1758 37.770403393000606 -122.45184592528099 (37.7704033930006, -122.451845925281)
177148 248496 2 36 110 Beulah St 1 1 1 1     33 Width 0ft   5997529.2628 2107821.3875 37.7675336345309 -122.451833202371 (37.7675336345309, -122.451833202371)
149297 248615 2 36 446 Frederick St 1 1 1 1     21 Width 0ft   5997626.0167 2107489.4868 37.7666278609206 -122.451474603078 (37.7666278609206, -122.451474603078)
41393 248493 2 36 748 Shrader St 1 1 1 1     21 Width 0ft   5997645.2464 2107858.3326 37.7676417185294 -122.451434697353 (37.7676417185294, -122.451434697353)
155601 248526 2 36 75 Beulah St 1 1 1 1     13 Width 0ft   5997669.6241 2107795.1927 37.7674697483814 -122.451345824031 (37.7674697483814, -122.451345824031)
131150 248583 2 36 832 Shrader St 1 1 1 1     15 Width 0ft   5997671.8953 2107653.4687 37.7670807404856 -122.45132774569099 (37.7670807404856, -122.451327745691)
150366 246155 2 36 1644 Waller St 1 1 1 1     17 Width 0ft   5997687.6425 2108190.0819 37.768555044956 -122.45131198438801 (37.768555044956, -122.451311984388)
144172 117163 2 36 832 SHRADER ST 1 1 1 1       3x3   5997697.0 2107652.0 37.767078145258004 -122.45124080685899 (37.767078145258, -122.451240806859)
187024 248372 2 36 1609 Waller St 2 1 1 1     19 Width 0ft   5997820.1302 2108164.6442 37.768492784741895 -122.450851888359 (37.7684927847419, -122.450851888359)
164518 248513 2 36 23 Beulah St 1 1 1 1     19 Width 0ft   5997819.2217 2107818.3592 37.767541922496 -122.450830059129 (37.767541922496, -122.450830059129)
55714 107425 2 36 1600X Waller St 1 1 1 1           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345)
40266 246174 2 36 1602 Waller St 1 1 1 1     26 Width 0ft   5997866.0088 2108213.3997 37.768629281127296 -122.45069671469 (37.7686292811273, -122.45069671469)
135072 224028 2 36 1420 Shrader St 1 1 1 1     13 Width 4ft   5997836.6848 2105808.46526 37.7620242630195 -122.450624734548 (37.7620242630195, -122.450624734548)
Powered by Datasette · Query took 9.92ms · Data source: data.sfgov.org