sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
189005 105881 2 53 250 Locust St 1 1 1 1     30     5997617.52659 2115483.20836 37.788576052199396 -122.452080774722 (37.7885760521994, -122.452080774722)
188100 215642 2 53 900 Junipero Serra Blvd 85 4 1 1     3 Width 0ft   5991146.327190001 2090562.0053700001 37.7197761709066 -122.47265219363999 (37.7197761709066, -122.47265219364)
187609 215640 2 53 900 Junipero Serra Blvd 83 4 1 1     5 Width 0ft   5991139.98278 2090571.01197 37.71980053355961 -122.472674780143 (37.7198005335596, -122.472674780143)
187353 142975 2 53 2000 Stockton St 1 1 1 1     15 Width 0ft   6009927.4614 2120951.259 37.804287419917294 -122.40987623003299 (37.8042874199173, -122.409876230033)
186517 199851 2 53 1603 Armstrong Ave 9 1 1 1     30 Width 0ft   6014366.3226 2092462.8184 37.7263121847089 -122.392521119846 (37.7263121847089, -122.392521119846)
185313 215647 2 53 900 Junipero Serra Blvd 90 4 1 1     5 Width 0ft   5991141.92136 2090550.26747 37.719743686490396 -122.472666567521 (37.7197436864904, -122.472666567521)
184481 185713 2 53 2101 Sunset Blvd 44 9 1 1     1 Width 0ft   5984850.6272 2100403.3767 37.746431518886105 -122.49513921196301 (37.7464315188861, -122.495139211963)
184419 142972 2 53 2010 Stockton St 2 1 1 1     19 Width 0ft   6009915.1882 2121025.8734 37.804491604686206 -122.409923973004 (37.8044916046862, -122.409923973004)
184159 215648 2 53 900 Junipero Serra Blvd 92 4 1 1     3 Width 0ft   5991148.46508 2090549.7895400003 37.7197427529995 -122.472643913597 (37.7197427529995, -122.472643913597)
184155 185728 2 53 2101 Sunset Blvd 60 9 1 1     21 Width 0ft   5984906.201 2100307.5936 37.7461717779802 -122.494939985658 (37.7461717779802, -122.494939985658)
183478 215589 2 53 551 Junipero Serra Blvd 16 2 1 1     12 Width 3ft   5991458.35334 2093660.05844 37.7283007142025 -122.47179930268999 (37.7283007142025, -122.47179930269)
183192 215611 2 53 900 Junipero Serra Blvd 51 4 1 1     3 Width 0ft   5991153.406 2090660.89558 37.720048108812705 -122.472634931171 (37.7200481088127, -122.472634931171)
183011 124687 2 53 460 Arguello Blvd 10 1 1 1     19 Width 4ft   5995608.47806 2113376.19737 37.782675480559504 -122.45887912132 (37.7826754805595, -122.45887912132)
181588 137074 2 53 3598 Clay St 4 2 1 1     21 Width 4ft   5997641.85824 2115456.61364 37.7885044238892 -122.45199467183998 (37.7885044238892, -122.45199467184)
181118 123469 2 53 772 02nd Ave 1 1 1 1     26 Width 5ft   5995383.36925 2110442.32995 37.7746069181393 -122.459445351917 (37.7746069181393, -122.459445351917)
180677 102615 2 53 392 Chestnut St 2 1 1 1     16 3x3   6009946.866 2120935.8276 37.804246136595296 -122.409807988636 (37.8042461365953, -122.409807988636)
179478 215604 2 53 900 Junipero Serra Blvd 38 4 1 1     3 Width 0ft   5991153.81619 2090748.1801 37.7202877943298 -122.472639873854 (37.7202877943298, -122.472639873854)
179443 137080 2 53 1639 Taylor St 6 1 1 1     3 Width 3ft   6008758.62885 2118554.07509 37.79763977591279 -122.41375141818999 (37.7976397759128, -122.41375141819)
179042 215595 2 53 400 Junipero Serra Blvd 11 4 1 1     6 Width 0ft   5991368.98283 2094166.96047 37.7296873689589 -122.47214519097 (37.7296873689589, -122.47214519097)
178804 215588 2 53 551 Junipero Serra Blvd 9 2 1 1     12 Width 3ft   5991446.82162 2093469.8712 37.7277778402634 -122.47182531290899 (37.7277778402634, -122.471825312909)
177920 182454 2 53 1500 31st Ave 2 2 1 1     21 Width 0ft   5986553.619 2104615.5531 37.7580965659316 -122.489560229786 (37.7580965659316, -122.489560229786)
177374 123487 2 53 600 Arguello Blvd 5 2 1 1     27     5995668.73883 2111844.87781 37.778474348143895 -122.45855975947599 (37.7784743481439, -122.458559759476)
176952 215598 2 53 700 Junipero Serra Blvd 48 4 1 1     13 Width 0ft   5991274.418330001 2092469.9979599998 37.725022460494706 -122.472348449422 (37.7250224604947, -122.472348449422)
176243 215636 2 53 900 Junipero Serra Blvd 79 4 1 1     4 Width 0ft   5991147.9135 2090580.90098 37.7198281454204 -122.472648087333 (37.7198281454204, -122.472648087333)
175894 137070 2 53 7 Laurel St 5 1 1 1     13 Width 4ft   5997942.37701 2116329.50618 37.7909183634316 -122.451017898383 (37.7909183634316, -122.451017898383)
175491 137081 2 53 1627 Taylor St 1 1 1 1     4 Width 3ft   6008775.75798 2118410.46159 37.7972464106437 -122.413681983361 (37.7972464106437, -122.413681983361)
175424 215628 2 53 900 Junipero Serra Blvd 71 4 1 1     11 Width 0ft   5991139.39343 2090599.4181400002 37.7198784957874 -122.47267888733299 (37.7198784957874, -122.472678887333)
175293 199849 2 53 1607 Armstrong Ave 7 1 1 1     28 Width 0ft   6014322.4694 2092498.1446 37.7264067479006 -122.392675189528 (37.7264067479006, -122.392675189528)
173805 123488 2 53 600 Arguello Blvd 4 2 1 1     16     5995672.61976 2111816.69318 37.7783971836602 -122.458544293173 (37.7783971836602, -122.458544293173)
172911 105883 2 53 250 Locust St 4 1 1 1     15     5997608.20664 2115530.35123 37.7887049601136 -122.452116422945 (37.7887049601136, -122.452116422945)
172059 182465 2 53 2400 Lawton St 5 1 1 1     21 Width 0ft   5986689.3022 2104396.9525 37.7575042689843 -122.489074914666 (37.7575042689843, -122.489074914666)
171899 123484 2 53 600 Arguello Blvd 8 2 1 1     33     5995663.25844 2111930.13675 37.778708131625294 -122.458584891633 (37.7787081316253, -122.458584891633)
171488 215651 2 53 2105 09th Ave 1 2 1 1     25 Width 3ft   5993642.48221 2101265.6792599997 37.749309980671796 -122.46480082800501 (37.7493099806718, -122.464800828005)
171388 137079 2 53 1639 Taylor St 5 1 1 1     3 Width 3ft   6008755.558119999 2118570.22529 37.7976839479247 -122.413763186745 (37.7976839479247, -122.413763186745)
170878 185719 2 53 2101 Sunset Blvd 51 9 1 1     14 Width 0ft   5984913.7198 2100361.206 37.7463194231796 -122.49491793929899 (37.7463194231796, -122.494917939299)
170582 242796 2 53 140 Belgrave Ave 2 2 1 1     23 Width 2ft   5997883.8658300005 2104916.82278 37.7595787374877 -122.450397275322 (37.7595787374877, -122.450397275322)
170489 215610 2 53 900 Junipero Serra Blvd 50 4 1 1     6 Width 0ft   5991146.77446 2090663.32778 37.7200544031655 -122.472658031161 (37.7200544031655, -122.472658031161)
170241 180589 2 53 1241 Alemany Blvd 1 1 1 1     20 Width 4ft   6003010.99045 2094126.1928400001 37.7302422857354 -122.431894635246 (37.7302422857354, -122.431894635246)
166993 107483 3 53 1306x Montgomery St 6 11 1 2     17     6011458.52251 2119859.64432 37.8013757989196 -122.404500953851 (37.8013757989196, -122.404500953851)
166700 180582 2 53 1110 Alemany Blvd 1 1 1 1     26 Width 4ft   6003793.49913 2094480.4258 37.7312592588934 -122.429214647441 (37.7312592588934, -122.429214647441)
166173 124694 2 53 460 Arguello Blvd 3 1 1 1     8 Width 4ft   5995618.45318 2113098.44712 37.78191342592 -122.45882449658501 (37.78191342592, -122.458824496585)
165950 215586 2 53 751 Junipero Serra Blvd 18 2 1 1     13 Width 3ft   5991393.3825900005 2092629.9672299998 37.725468580903 -122.471948860848 (37.725468580903, -122.471948860848)
165193 215592 2 53 177 Sagamore St 1 1 1 1     16 Width 3ft   5995226.8577 2087383.90223 37.7112852083174 -122.458317422904 (37.7112852083174, -122.458317422904)
163752 182456 2 53 1500 31st Ave 4 2 1 1     23 Width 0ft   5986548.9803 2104699.0505 37.758325556062104 -122.489582412162 (37.7583255560621, -122.489582412162)
163579 215612 2 53 900 Junipero Serra Blvd 53 4 1 1     1 Width 0ft   5991154.50456 2090649.59615 37.720017146953 -122.472630310457 (37.720017146953, -122.472630310457)
162620 123479 2 53 600 Arguello Blvd 13 2 1 1     39     5995657.67406 2112077.16899 37.7791115222078 -122.458614856747 (37.7791115222078, -122.458614856747)
161666 215607 2 53 900 Junipero Serra Blvd 47 4 1 1     2 Width 0ft   5991157.54734 2090681.2167900002 37.7201041455671 -122.47262209693301 (37.7201041455671, -122.472622096933)
160644 215625 2 53 900 Junipero Serra Blvd 67 4 1 1     7 Width 0ft   5991149.7740400005 2090612.8046400002 37.719915852707295 -122.472643981029 (37.7199158527073, -122.472643981029)
159718 215608 2 53 900 Junipero Serra Blvd 48 4 1 1     2 Width 0ft   5991156.01629 2090675.51857 37.720088411035206 -122.47262697396799 (37.7200884110352, -122.472626973968)
158658 215606 2 53 900 Junipero Serra Blvd 40 4 1 1     11 Width 0ft   5991163.46661 2090729.52448 37.7202371292081 -122.47260515641399 (37.7202371292081, -122.472605156414)
158560 123481 2 53 600 Arguello Blvd 11 2 1 1     34     5995659.669480001 2112025.6512 37.7789701827075 -122.458604223385 (37.7789701827075, -122.458604223385)
157916 215630 2 53 900 Junipero Serra Blvd 73 4 1 1     9 Width 0ft   5991138.04395 2090591.7564599998 37.7198573805858 -122.47268299363998 (37.7198573805858, -122.47268299364)
157547 215619 2 53 900 Junipero Serra Blvd 61 4 1 1     10 Width 0ft   5991156.50194 2090623.6682099998 37.719946070837395 -122.472621516875 (37.7199460708374, -122.472621516875)
156335 142234 2 53 689 HAYES ST 1 1 1 1     22 Width 0ft   6004609.2702 2110836.2012 37.77621453898529 -122.427559190874 (37.7762145389853, -122.427559190874)
155297 215637 2 53 900 Junipero Serra Blvd 80 4 1 1     4 Width 0ft   5991151.99496 2090577.2658 37.7198184003677 -122.47263371439699 (37.7198184003677, -122.472633714397)
155249 215634 2 53 900 Junipero Serra Blvd 77 4 1 1     4 Width 0ft   5991150.9321800005 2090583.20344 37.7198346421452 -122.47263782070101 (37.7198346421452, -122.472637820701)
153233 185963 2 53 2001 Sunset Blvd 22 9 1 1     11 Width 0ft   5984881.7314 2101336.1941 37.7489946017929 -122.495100432866 (37.7489946017929, -122.495100432866)
152798 123480 2 53 600 Arguello Blvd 12 2 1 1     34     5995658.308019999 2112054.06112 37.7790481105637 -122.458610990374 (37.7790481105637, -122.458610990374)
152540 180586 2 53 177 Santa Rosa Ave 3 1 1 1     6 Width 2ft   6001346.13618 2093162.98872 37.7275030272355 -122.437581294937 (37.7275030272355, -122.437581294937)
150428 242795 2 53 1671 Peralta Ave 1 1 1 1     6 Width 3ft   6009731.24755 2099988.4352599997 37.7467174150944 -122.409075193563 (37.7467174150944, -122.409075193563)
149713 137067 2 53 7 Laurel St 1 1 1 1     16 Width 3ft   5997931.48984 2116393.73013 37.791094081978 -122.45106020067 (37.791094081978, -122.45106020067)
149316 137071 2 53 7 Laurel St 6 1 1 1     16 Width 3ft   5997945.511630001 2116314.45646 37.7908772203684 -122.451005967078 (37.7908772203684, -122.451005967078)
149241 215584 2 53 751 Junipero Serra Blvd 15 2 1 1     17 Width 3ft   5991387.10122 2092540.18841 37.7252217070935 -122.471964034223 (37.7252217070935, -122.471964034223)
147734 180580 2 53 1282 Alemany Blvd 1 1 1 1     15 Width 5ft   6002752.91911 2094123.24132 37.7302195481937 -122.432786610727 (37.7302195481937, -122.432786610727)
147002 83273 2 53 1639X Taylor St 3 1 1 1 1 01/21/2006 12:00:00 AM 3     6008750.425980001 2118601.9970299997 37.797770897055294 -122.413783193943 (37.7977708970553, -122.413783193943)
145740 123490 2 53 600 Arguello Blvd 2 2 1 1     27     5995673.905040001 2111757.95548 37.7782359793629 -122.45853559389299 (37.7782359793629, -122.458535593893)
145404 1420 1 53 50 Arguello Blvd 2 1 1 1     50 3x3   5995529.5957 2115606.06371 37.7887935591586 -122.45931355109501 (37.7887935591586, -122.459313551095)
145390 6278 3 53 1475 Ellis St 1 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
145198 1432 3 53 75X Arguello Blvd 5 1 1 2     17 5   5995472.27833 2115471.9588 37.7884220478225 -122.45950214341002 (37.7884220478225, -122.45950214341)
144992 93023 1 53 394 Fair Oaks St 2 1 1 1         Tree 2 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
144278 2933 3 53 1834 California St 6 1 1 2   05/29/1997 12:00:00 AM 7 3X3   6005503.04257 2115905.51621 37.7901841403418 -122.424828114668 (37.7901841403418, -122.424828114668)
144014 1218 1 53 3575X Alemany Blvd 1 1 1 1     40 3X3   5993629.70146 2087487.1964900002 37.711476919919 -122.463845046869 (37.711476919919, -122.463845046869)
143670 19065 3 53 179 Sagamore St 1 1 1 2     40 3X3   5995218.7218404 2087397.9242615001 37.711323242006294 -122.45834655658399 (37.7113232420063, -122.458346556584)
143144 105784 2 53 1570 31ST AVE 1 1 1 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
142032 1248 3 53 3731 Alemany Blvd 1 1 1 2     25 3x3   5993002.942009999 2087547.889 37.711607428767294 -122.466015680425 (37.7116074287673, -122.466015680425)
141240 11874 1 53 1499X Junipero Serra Blvd 4 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
141047 917 3 53 1245 Alemany Blvd 1 1 1 2     35 3X3   6003003.64796 2094102.5381599998 37.730176919086496 -122.43191833078899 (37.7301769190865, -122.431918330789)
141037 26779 3 53 800X Junipero Serra Blvd 34 1 1 2     24 4x4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
140740 1474 3 53 234 Arguello Blvd 1 1 1 2     15 3x5   5995562.8915 2114652.7171099996 37.7861778408698 -122.459129293157 (37.7861778408698, -122.459129293157)
140555 22541 3 53 1396X Alemany Blvd 1 1 1 2     26 3X3   6002380.38751 2093819.80205 37.7293652374447 -122.434052817677 (37.7293652374447, -122.434052817677)
140037 19107 3 53 3155X Alemany Blvd 3 1 1 2     24 3x3   5995592.56281 2086919.9321700002 37.7100322629968 -122.457019923286 (37.7100322629968, -122.457019923286)
140006 1051 1 53 2035X Alemany Blvd 1 1 1 1     45 3X3   6000572.81835 2090254.9074400002 37.7194741008396 -122.44004621634599 (37.7194741008396, -122.440046216346)
139773 97504 2 53 20X 10th St 1 1 1 1   10/18/2011 12:00:00 AM 12 3x3 Permit Number 768079 6007672.0 2110712.0 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158)
139352 1510 3 53 369 Arguello Blvd 1 1 1 2     100 3x3   5995536.869969999 2113765.1567 37.7837393424086 -122.45915502719102 (37.7837393424086, -122.459155027191)
139259 29914 3 53 810 Junipero Serra Blvd 3 1 1 2     12     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
138620 1526 3 53 440 Arguello Blvd 1 1 1 2     100 3x3   5995608.48873 2113422.41383 37.782802379218296 -122.458882431606 (37.7828023792183, -122.458882431606)
138406 1052 3 53 2039X Alemany Blvd 1 1 1 2     45 3X3   6000548.43841 2090229.36669 37.719402583767 -122.44012865812 (37.719402583767, -122.44012865812)
138392 1014 3 53 1852X Alemany Blvd 1 1 1 2     40 3X3   6001135.54804 2091400.8212599999 37.7226525409555 -122.438183116075 (37.7226525409555, -122.438183116075)
138110 215582 2 53 751 Junipero Serra Blvd 11 2 1 1     25 Width 3ft   5991378.73804 2092411.11653 37.7248668238178 -122.47198354142999 (37.7248668238178, -122.47198354143)
136479 215618 2 53 900 Junipero Serra Blvd 60 4 1 1     8 Width 0ft   5991156.49559 2090631.32735 37.719967100580796 -122.472622096952 (37.7199671005808, -122.472622096952)
136462 215621 2 53 900 Junipero Serra Blvd 63 4 1 1     3 Width 0ft   5991148.3674800005 2090618.2199 37.7199306402575 -122.47264923758999 (37.7199306402575, -122.47264923759)
136173 185691 2 53 2101 Sunset Blvd 23 9 1 1     1 Width 0ft   5984865.9917 2100533.4848 37.746789659782 -122.49509567655001 (37.746789659782, -122.49509567655)
136034 137077 2 53 2955 Steiner St 1 7 1 1     5 Width 5ft   6001974.0393199995 2118352.39854 37.796702688621004 -122.437213445266 (37.796702688621, -122.437213445266)
135449 123482 2 53 600 Arguello Blvd 10 2 1 1     35     5995660.39644 2111993.63742 37.7788823231397 -122.458599390427 (37.7788823231397, -122.458599390427)
134549 215585 2 53 751 Junipero Serra Blvd 16 2 1 1     18 Width 3ft   5991388.97305 2092569.49487 37.725302283667396 -122.471959698575 (37.7253022836674, -122.471959698575)
133735 215638 2 53 900 Junipero Serra Blvd 81 4 1 1     17 Width 0ft   5991161.28352 2090567.01377 37.7197907884826 -122.47260086035801 (37.7197907884826, -122.472600860358)
133658 180592 2 53 1804 Alemany Blvd 3 1 1 1     33 Width 4ft   6001143.73267 2091406.4041400002 37.72266833577 -122.438155223402 (37.72266833577, -122.438155223402)
133362 185690 2 53 2101 Sunset Blvd 22 9 1 1     14 Width 0ft   5984904.8934 2100540.6767 37.7468116841536 -122.494961690438 (37.7468116841536, -122.494961690438)
131994 199846 2 53 1613 Armstrong Ave 4 1 1 1     30 Width 0ft   6014210.3999 2092579.1513 37.726622951149395 -122.393068277245 (37.7266229511494, -122.393068277245)
130396 215622 2 53 900 Junipero Serra Blvd 64 4 1 1     3 Width 0ft   5991146.64961 2090624.8002099998 37.7199486087273 -122.472655655135 (37.7199486087273, -122.472655655135)
129995 215632 2 53 900 Junipero Serra Blvd 75 4 1 1     7 Width 0ft   5991152.25672 2090589.68226 37.7198525080596 -122.472633714394 (37.7198525080596, -122.472633714394)
Powered by Datasette · Query took 3.338ms · Data source: data.sfgov.org