sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
69728 125437 2 70 1921 Jefferson St 3 1 1 1     5 Width 4ft   6000052.89269 2121248.37983 37.8045448847905 -122.44406922002199 (37.8045448847905, -122.444069220022)
56342 125442 2 70 3719 Scott St 1 4 1 1     1 Width 3ft   6000612.64349 2121133.3219999997 37.8042608824853 -122.442123892024 (37.8042608824853, -122.442123892024)
170392 125444 2 70 3676 Fillmore St 3 4 1 1     6 Width 2ft   6002146.17897 2121077.47724 37.8041948227854 -122.436812979831 (37.8041948227854, -122.436812979831)
49472 41212 1 70 3676 Fillmore St 1 1 1 1 1 11/29/1999 12:00:00 AM 6   Permit Number 41921 6002149.73701 2121055.69726 37.804135222937 -122.43679910691002 (37.804135222937, -122.43679910691)
35891 125523 2 70 220 Lombard St 7 9 1 1     6 Width 9ft   6011207.16585 2120734.5295700002 37.8037639692824 -122.40543241409401 (37.8037639692824, -122.405432414094)
160138 125525 2 70 220 Lombard St 9 9 1 1     8 Width 9ft   6011203.66326 2120729.63027 37.8037503211682 -122.405444189817 (37.8037503211682, -122.405444189817)
75383 125524 2 70 220 Lombard St 8 9 1 1     8 Width 9ft   6011207.6846199995 2120726.9389400003 37.8037431562814 -122.40543008395201 (37.8037431562814, -122.405430083952)
137536 249818 2 70 285 Kearny St 4 7 1 1     24 Width 0ft   6010887.46579 2120660.30432 37.803542284601996 -122.40653352599399 (37.803542284602, -122.406533525994)
154615 249823 2 70 285 Kearny St 2 7 1 1     14 Width 0ft   6010881.14413 2120640.5408 37.8034876651725 -122.406554008974 (37.8034876651725, -122.406554008974)
183937 249822 2 70 285 Kearny St 1 7 1 1     10 Width 0ft   6010893.58143 2120633.6568400003 37.8034694593133 -122.406510483572 (37.8034694593133, -122.406510483572)
167284 125445 2 70 3615 Buchanan St 1 1 1 1     7 Width 3ft   6003103.29494 2120784.42 37.8034445139256 -122.433479854917 (37.8034445139256, -122.433479854917)
39363 249821 2 70 281 Kearny St 2 7 1 1     14 Width 0ft   6010901.8759699995 2120623.17353 37.8034411387496 -122.406481040676 (37.8034411387496, -122.406481040676)
46865 249820 2 70 281 Kearny St 1 7 1 1     13 Width 0ft   6010902.80513 2120614.31353 37.8034168633488 -122.40647720057301 (37.8034168633488, -122.406477200573)
136884 125446 2 70 3615 Buchanan St 2 1 1 1     6 Width 3ft   6003103.6015800005 2120772.6345599997 37.8034121715947 -122.433477951057 (37.8034121715947, -122.433477951057)
70954 125443 2 70 2298 Beach St 8 9 1 1     4 Width 5ft   5999265.80635 2120844.85189 37.8033919746241 -122.446763941418 (37.8033919746241, -122.446763941418)
177222 125447 2 70 3057 Franklin St 1 4 1 1     5 Width 2ft   6005068.7625400005 2120514.19483 37.8028138607435 -122.426659015206 (37.8028138607435, -122.426659015206)
162716 125448 2 70 3057 Franklin St 2 4 1 1     5 Width 2ft   6005070.86935 2120497.70862 37.8027687129688 -122.426650549882 (37.8027687129688, -122.426650549882)
165596 125497 2 70 1154 Chestnut St 5 9 1 1     10 Width 2ft   6006282.866880001 2120431.59702 37.8026556331117 -122.422451714169 (37.8026556331117, -122.422451714169)
67240 125498 2 70 1154 Chestnut St 6 9 1 1     8 Width 2ft   6006270.07079 2120429.11585 37.8026480985929 -122.422495818752 (37.8026480985929, -122.422495818752)
100438 97940 2 70 491 Greenwich St 2 1 1 1           6010516.0 2120277.0 37.802469036850205 -122.407791962119 (37.8024690368502, -122.407791962119)
114838 97942 2 70 491 Greenwich St 4 1 1 1           6010516.0 2120277.0 37.802469036850205 -122.407791962119 (37.8024690368502, -122.407791962119)
141972 97941 2 70 491 Greenwich St 3 1 1 1           6010516.0 2120277.0 37.802469036850205 -122.407791962119 (37.8024690368502, -122.407791962119)
143236 97939 2 70 491 Greenwich St 1 1 1 1           6010516.0 2120277.0 37.802469036850205 -122.407791962119 (37.8024690368502, -122.407791962119)
71919 125496 2 70 1207 Chestnut St 8 9 1 1     5 Width 3ft   6006063.84143 2120339.6871599997 37.802390914060204 -122.42320311664899 (37.8023909140602, -122.423203116649)
45984 125495 2 70 1207 Chestnut St 7 9 1 1     3 Width 3ft   6006051.2199 2120336.9264 37.802382621428706 -122.423246597049 (37.8023826214287, -122.423246597049)
35121 125494 2 70 1207 Chestnut St 6 9 1 1     3 Width 3ft   6006034.74479 2120336.40198 37.8023802517163 -122.423303571803 (37.8023802517163, -122.423303571803)
149835 125493 2 70 1207 Chestnut St 4 9 1 1     4 Width 3ft   6006021.473809999 2120333.6545700002 37.8023719590496 -122.42334930055401 (37.8023719590496, -122.423349300554)
172117 125492 2 70 1207 Chestnut St 3 9 1 1     4 Width 3ft   6006010.16913 2120331.72981 37.8023660361287 -122.42338828343901 (37.8023660361287, -122.423388283439)
76694 125491 2 70 1207 Chestnut St 2 9 1 1     3 Width 3ft   6005994.09185 2120329.4714599997 37.8023589278732 -122.42344375814599 (37.8023589278732, -122.423443758146)
184444 66783 1 70 1207 Chestnut St 1 1 1 1 1 09/20/1991 12:00:00 AM 5   Permit Number 30054 6005979.755609999 2120327.60903 37.80235300495529 -122.42349323614799 (37.8023530049553, -122.423493236148)
153001 92753 1 70 3356 Baker St 2 1 1 1   10/07/2009 12:00:00 AM 4 3x3 Permit Number 52980 5999299.39389 2120397.7877700003 37.802166375831106 -122.446615526285 (37.8021663758311, -122.446615526285)
131923 125440 2 70 3517 Divisadero St 1 4 1 1     4 Width 2ft   6000220.82214 2120372.11662 37.8021484793247 -122.44342510578801 (37.8021484793247, -122.443425105788)
148997 125441 2 70 3517 Divisadero St 2 4 1 1     4 Width 2ft   6000221.62171 2120363.5906700003 37.8021251149445 -122.443421726125 (37.8021251149445, -122.443421726125)
24395 92752 1 70 3356 Baker St 1 1 1 1   10/07/2009 12:00:00 AM 4 3x3 Permit Number 52980 5999300.27951 2120375.08626 37.8021040941904 -122.446610827352 (37.8021040941904, -122.446610827352)
133037 249983 2 70 226 Filbert St 1 7 1 1     13 Width 0ft   6011603.53088 2120119.93244 37.8020985894405 -122.40401748554301 (37.8020985894405, -122.404017485543)
48362 125504 2 70 1001 Lombard St 3 9 1 1     4 Width 7ft   6007489.69173 2120199.0729400003 37.8020851859507 -122.418258985774 (37.8020851859507, -122.418258985774)
161839 125503 2 70 1001 Lombard St 2 9 1 1     6 Width 7ft   6007472.5485 2120196.7006200003 37.802077707171605 -122.418318141382 (37.8020777071716, -122.418318141382)
70754 249984 2 70 226 Filbert St 2 7 1 1     10 Width 0ft   6011604.5053 2120111.99388 37.8020768465317 -122.404013554575 (37.8020768465317, -122.404013554575)
150526 125502 2 70 1001 Lombard St 1 9 1 1     5 Width 7ft   6007468.42884 2120195.8771599997 37.8020752142594 -122.41833233898701 (37.8020752142594, -122.418332338987)
183705 249985 2 70 228 Filbert St 1 7 1 1     4 Width 0ft   6011591.62105 2120106.88257 37.802062092258 -122.40405778055799 (37.802062092258, -122.404057780558)
45739 249986 2 70 228 Filbert St 2 7 1 1     4 Width 0ft   6011589.33259 2120106.08083 37.802059763014 -122.404065643309 (37.802059763014, -122.404065643309)
159610 249987 2 70 228 Filbert St 3 7 1 1     3 Width 0ft   6011587.32256 2120104.99043 37.802056656736 -122.404072522227 (37.802056656736, -122.404072522227)
61458 249988 2 70 228 Filbert St 4 7 1 1     3 Width 0ft   6011583.89861 2120104.21147 37.802054326596206 -122.404084315938 (37.8020543265962, -122.404084315938)
35263 249989 2 70 228 Filbert St 5 7 1 1     2 Width 0ft   6011581.894069999 2120103.40396 37.802051997370896 -122.404091195777 (37.8020519973709, -122.404091195777)
184956 249990 2 70 228 Filbert St 6 7 1 1     2 Width 0ft   6011580.18498 2120103.15607 37.802051221233 -122.404097092619 (37.802051221233, -122.404097092619)
61770 249991 2 70 228 Filbert St 7 7 1 1     2 Width 0ft   6011578.47013 2120102.62532 37.802049668108396 -122.404102989475 (37.8020496681084, -122.404102989475)
26278 249950 2 70 303 Filbert St 5 17 1 1     9 Width 0ft   6011359.33086 2120056.95578 37.801912024192795 -122.404858102512 (37.8019120241928, -122.404858102512)
60021 249949 2 70 303 Filbert St 6 17 1 1     14 Width 0ft   6011354.62644 2120055.4997 37.801907763195 -122.404874279527 (37.801907763195, -122.404874279527)
74131 249946 2 70 305 Filbert St 1 7 1 1     12 Width 0ft   6011346.83837 2120055.6582400003 37.801907763181205 -122.404901241218 (37.8019077631812, -122.404901241218)
41677 249947 2 70 305 Filbert St 2 7 1 1     7 Width 0ft   6011342.9125 2120054.18632 37.8019035022036 -122.40491472295 (37.8019035022036, -122.40491472295)
148756 249948 2 70 305 Filbert St 3 7 1 1     18 Width 0ft   6011338.9869 2120052.71472 37.8018992421182 -122.40492820376998 (37.8018992421182, -122.40492820377)
63040 249939 2 70 331 Filbert St 1 7 1 1     7 Width 0ft   6011281.55151 2120038.154 37.801856051265204 -122.40512593233 (37.8018560512652, -122.40512593233)
49008 125522 2 70 1087 Greenwich St 3 9 1 1     11 Width 4ft   6007750.4574 2119887.81691 37.8012452299295 -122.417334539369 (37.8012452299295, -122.417334539369)
55076 125501 2 70 1115 Filbert St 2 9 1 1     8 Width 4ft   6007553.747280001 2119514.62481 37.8002094690578 -122.417988773678 (37.8002094690578, -122.417988773678)
22809 125505 2 70 45 Havens St 1 9 1 1     11     6007613.99229 2119386.63886 37.799861442220895 -122.41777122496 (37.7998614422209, -122.41777122496)
159071 125499 2 70 10 Hastings Ter 1 9 1 1     2     6007355.47144 2119286.0885099997 37.799570804701396 -122.418658671469 (37.7995708047014, -122.418658671469)
149721 125500 2 70 12 Hastings Ter 6 9 1 1     2     6007269.76384 2119273.06582 37.7995302219096 -122.41895432719299 (37.7995302219096, -122.418954327193)
7088 107943 2 70 44x MacOndray Ln 5 1 1 1     14 3x3   6008438.53642 2119159.8208 37.7992850226339 -122.41490192268 (37.7992850226339, -122.41490192268)
34959 104356 1 70 1671 Filbert St 2 1 1 1   09/25/2013 12:00:00 AM 3   Permit Number 770626 6004967.00865 2119154.82266 37.7990756208885 -122.426914264396 (37.7990756208885, -122.426914264396)
45092 64967 1 70 1671 Filbert St 1 1 1 1 1 09/25/2013 12:00:00 AM 3   Permit Number 770626 6004948.17442 2119151.63157 37.799065794014396 -122.42697920982201 (37.7990657940144, -122.426979209822)
49868 125509 2 70 900 Green St 13 9 1 1     3 Width 5ft   6008633.29576 2119030.27082 37.7989402522368 -122.41421881477301 (37.7989402522368, -122.414218814773)
102425 125510 2 70 900 Green St 14 9 1 1     1 Width 5ft   6008630.57528 2119029.65242 37.79893840145329 -122.41422818478901 (37.7989384014533, -122.414228184789)
47885 125511 2 70 900 Green St 15 9 1 1     2 Width 5ft   6008625.76186 2119029.2242099997 37.7989369553212 -122.41424481055799 (37.7989369553212, -122.414244810558)
178396 125512 2 70 900 Green St 17 9 1 1     1 Width 5ft   6008620.72695 2119028.05639 37.7989334659598 -122.414262150401 (37.7989334659598, -122.414262150401)
74953 125514 2 70 900 Green St 24 9 1 1     2 Width 5ft   6008590.31929 2119027.3925900003 37.7989299352366 -122.414367324317 (37.7989299352366, -122.414367324317)
35158 125513 2 70 900 Green St 22 9 1 1     1 Width 5ft   6008593.294869999 2119027.33171 37.798929935227 -122.414357023482 (37.798929935227, -122.414357023482)
182144 125516 2 70 900 Green St 26 9 1 1     1 Width 5ft   6008584.50737 2119027.0667 37.798928713939205 -122.414387412476 (37.7989287139392, -122.414387412476)
35686 125515 2 70 900 Green St 25 9 1 1     1 Width 5ft   6008587.48018 2119026.85751 37.7989283065533 -122.414377110727 (37.7989283065533, -122.414377110727)
67817 125519 2 70 900 Green St 31 9 1 1     1 Width 5ft   6008571.89831 2119026.74658 37.798927126643896 -122.414431021472 (37.7989271266439, -122.414431021472)
172712 125518 2 70 900 Green St 30 9 1 1     2 Width 5ft   6008573.08581 2119026.43144 37.7989263280573 -122.414426890005 (37.7989263280573, -122.414426890005)
134395 125517 2 70 900 Green St 29 9 1 1     2 Width 5ft   6008575.41519 2119026.3782099998 37.7989263127569 -122.414418825785 (37.7989263127569, -122.414418825785)
30635 125520 2 70 900 Green St 32 9 1 1     1 Width 5ft   6008570.50339 2119026.46396 37.798926272277704 -122.414435828363 (37.7989262722777, -122.414435828363)
184003 125521 2 70 900 Green St 33 9 1 1     2 Width 5ft   6008568.41134 2119026.0619799998 37.7989250510158 -122.414443039112 (37.7989250510158, -122.414443039112)
48809 125436 2 70 3157 Steiner St 1 1 1 1     6 Width 3ft   6001892.570830001 2119015.7946 37.798519569189 -122.437542875929 (37.798519569189, -122.437542875929)
183063 34667 1 70 3065 Buchanan St 1 1 1 1   07/28/1997 12:00:00 AM 3   Permit Number 38339 6003364.40129 2118901.0104900002 37.798287972172396 -122.43244168475799 (37.7982879721724, -122.432441684758)
40273 125508 2 70 7 Fallon Pl 3 9 1 1     6 Width 6ft   6008930.4214699995 2118571.4914 37.797697242591504 -122.41315819931299 (37.7976972425915, -122.413158199313)
41654 125506 2 70 7 Fallon Pl 1 9 1 1     8 Width 4ft   6008920.97468 2118571.47788 37.7976966751291 -122.413190886946 (37.7976966751291, -122.413190886946)
151252 125507 2 70 7 Fallon Pl 2 9 1 1     4 Width 4ft   6008925.22265 2118571.08085 37.7976958234636 -122.41317615966801 (37.7976958234636, -122.413176159668)
175422 113957 1 70 1644 Taylor St 1 1 1 1   12/28/2015 12:00:00 AM 1 3x3   6008801.14182 2118530.39041 37.7975771309301 -122.413602635263 (37.7975771309301, -122.413602635263)
156178 33132 1 70 2927 Pierce St 1 1 1 1 1 11/05/1996 12:00:00 AM 7 4x5 Permit Number 37362 6001472.71004 2118540.58919 37.7971908999849 -122.438961648188 (37.7971908999849, -122.438961648188)
73300 125461 2 70 1845 Green St 2 9 1 1     11 Width 4ft   6004195.45414 2118342.0241799997 37.7968002290978 -122.42952610606399 (37.7968002290978, -122.429526106064)
44709 125485 3 70 1237x Robert C Levy Tunl 3 3 1 2     10     6007640.9414 2118138.07584 37.796434716745 -122.417589429708 (37.796434716745, -122.417589429708)
174163 125486 3 70 1237x Robert C Levy Tunl 4 3 1 2     6     6007645.270330001 2118136.8198 37.7964315115565 -122.417574361577 (37.7964315115565, -122.417574361577)
164866 125484 3 70 1237x Robert C Levy Tunl 1 3 1 2     18     6007648.69076 2118115.73393 37.796373807471 -122.41756103092699 (37.796373807471, -122.417561030927)
80090 32128 1 70 45 Ross Aly 1 1 1 1 1 08/15/1995 12:00:00 AM     Permit Number 35490 6010568.1937078 2117713.19841403 37.7954323857446 -122.407430491589 (37.7954323857446, -122.407430491589)
8590 102757 2 70 2807 Steiner St 2 1 1 1     8 3x3   6002051.958459999 2117801.7316900003 37.795195129895895 -122.436904386043 (37.7951951298959, -122.436904386043)
34506 125457 2 70 2807 Steiner St 4 9 1 1     8 Width 4ft   6002053.50035 2117793.13608 37.795171616221104 -122.43689843522101 (37.7951716162211, -122.436898435221)
92731 32134 1 70 842 Washington St 2 1 1 1 1 08/15/1995 12:00:00 AM     Permit Number 35494 6010631.11006318 2117599.53652258 37.795123819025704 -122.407204773258 (37.7951238190257, -122.407204773258)
138919 32133 1 70 842 Washington St 1 1 1 1 1 08/15/1995 12:00:00 AM     Permit Number 35494 6010631.11006318 2117599.53652258 37.795123819025704 -122.407204773258 (37.7951238190257, -122.407204773258)
79612 32135 1 70 858 Washington St 1 1 1 1 1 08/15/1995 12:00:00 AM     Permit Number 35495 6010580.68586277 2117592.53204935 37.7951017643418 -122.40737875552 (37.7951017643418, -122.40737875552)
104718 32136 1 70 858 Washington St 2 1 1 1 1 08/15/1995 12:00:00 AM     Permit Number 35495 6010580.68586277 2117592.53204935 37.7951017643418 -122.40737875552 (37.7951017643418, -122.40737875552)
134317 125539 2 70 31 Spofford St 1 10 1 1     1 Width 3ft   6010570.5264 2117382.56278 37.794524670939204 -122.407399099212 (37.7945246709392, -122.407399099212)
155868 125451 2 70 2601 Vallejo St 10 9 1 1     6 Width 4ft   6001095.19419 2117566.7818299998 37.7944955940578 -122.44019807567499 (37.7944955940578, -122.440198075675)
143941 32129 1 70 35 Spofford Ln 1 10 1 1 1 08/15/1995 12:00:00 AM     Permit Number 35491 6010554.96159279 2117351.45133924 37.7944383752725 -122.407450761229 (37.7944383752725, -122.407450761229)
51714 125450 2 70 44 Normandie Ter 1 9 1 1     7 Width 3ft   6000949.24806 2117425.20451 37.79409854965171 -122.44069290604999 (37.7940985496517, -122.44069290605)
173529 125459 2 70 2371 Broadway 3 9 1 1     5 Width 4ft   6002302.24315 2117372.6414900003 37.7940311814406 -122.436007644151 (37.7940311814406, -122.436007644151)
150229 125458 2 70 2371 Broadway 2 9 1 1     5 Width 4ft   6002284.26434 2117368.32549 37.794018309436396 -122.436069543591 (37.7940183094364, -122.436069543591)
153719 125456 2 70 2401 Broadway 18 9 1 1     11 Width 4ft   6002104.20596 2117349.59529 37.79395665014079 -122.436691221543 (37.7939566501408, -122.436691221543)
131618 125455 2 70 2401 Broadway 17 9 1 1     5 Width 4ft   6002099.50591 2117347.8348 37.7939515491883 -122.436707358076 (37.7939515491883, -122.436707358076)
157035 125454 2 70 2401 Broadway 16 9 1 1     5 Width 4ft   6002093.86703 2117345.7842200003 37.7939455983674 -122.43672672227 (37.7939455983674, -122.43672672227)
54839 125453 2 70 2401 Broadway 12 9 1 1     5 Width 4ft   6002078.25785 2117342.70193 37.793936248105 -122.43678051073299 (37.793936248105, -122.436780510733)
Powered by Datasette · Query took 8.812ms · Data source: data.sfgov.org