sf-trees

Data source: data.sfgov.org

Custom SQL query returning 64 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1054 125462 1 70 125 Mason St 3 1 1 1   04/28/2017 12:00:00 AM 3 Width 4ft Permit Number 52121 6009895.29665 2113891.24599 37.7849005400769 -122.40948896803499 (37.7849005400769, -122.409488968035)
24123 175160 2 70 229 Delano Ave 8 9 1 1     1 Width 4ft   6000093.42571 2092311.2225 37.7250929691415 -122.44185080298 (37.7250929691415, -122.44185080298)
33529 175163 2 70 229 Delano Ave 12 9 1 1     1 Width 4ft   6000100.60606 2092317.35748 37.7251102235329 -122.44182642145701 (37.7251102235329, -122.441826421457)
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)
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)
42654 125464 2 70 887 Eddy St 6 9 1 1     11 Width 4ft   6006280.54306 2113153.33425 37.782671211560704 -122.4219424317 (37.7826712115607, -122.4219424317)
47152 125475 2 70 150 Sproule Ln 2 1 1 1     7 Width 4ft   6009249.92549 2116801.2629400003 37.7928545606515 -122.41192746357599 (37.7928545606515, -122.411927463576)
47327 201923 2 70 125 Elmira St 1 4 1 1     13 Width 4ft   6011215.48386 2096005.8192 37.735865039640395 -122.403662651736 (37.7358650396404, -122.403662651736)
48661 125469 2 70 1177 California St 5 10 1 1     4 Width 4ft   6008779.73096 2116281.55689 37.791401184258795 -122.413517591782 (37.7914011842588, -122.413517591782)
48805 220628 2 70 907 Elizabeth St 1 9 1 1     8 Width 4ft   6000553.10276 2101957.71166 37.751606143208 -122.44095346395201 (37.751606143208, -122.440953463952)
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)
50442 220612 2 70 9 Bradford St 1 1 1 1     6 Width 4ft   6009640.52107 2098655.41337 37.743052146240295 -122.409294863773 (37.7430521462403, -122.409294863773)
51580 189194 2 70 30 15th St 3 1 1 1     7 Width 4ft   6012053.23647 2107512.8913 37.7675077191257 -122.40157469843001 (37.7675077191257, -122.40157469843)
53779 120025 2 70 743 28th Ave 1 1 1 1     1 Width 4ft   5987224.82866 2110876.6376900002 37.775326931785294 -122.487698901899 (37.7753269317853, -122.487698901899)
54337 175154 2 70 229 Delano Ave 1 9 1 1     1 Width 4ft   6000079.77144 2092298.5573 37.7250574153596 -122.44189709559299 (37.7250574153596, -122.441897095593)
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)
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)
57123 175162 2 70 229 Delano Ave 11 9 1 1     1 Width 4ft   6000098.0141199995 2092315.01212 37.7251036360216 -122.441835213242 (37.7251036360216, -122.441835213242)
58417 125477 2 70 150 Sproule Ln 4 1 1 1     9 Width 4ft   6009239.02025 2116870.71678 37.793044652131 -122.41197010674802 (37.793044652131, -122.411970106748)
61016 125467 2 70 1177 California St 3 10 1 1     6 Width 4ft   6008702.23207 2116269.4831 37.791363680726796 -122.413784882888 (37.7913636807268, -122.413784882888)
64478 125452 2 70 2401 Broadway 9 9 1 1     5 Width 4ft   6002068.61749 2117342.59163 37.7939353973611 -122.436813859368 (37.7939353973611, -122.436813859368)
65811 175157 2 70 229 Delano Ave 4 9 1 1     1 Width 4ft   6000084.80379 2092303.48045 37.7250712199557 -122.44188005254 (37.7250712199557, -122.44188005254)
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)
70001 175158 2 70 229 Delano Ave 6 9 1 1     1 Width 4ft   6000088.06493 2092305.57905 37.7250771680567 -122.44186892971399 (37.7250771680567, -122.441868929714)
72887 189192 2 70 30 15th St 1 1 1 1     8 Width 4ft   6012099.2034599995 2107516.8442700002 37.767521137926394 -122.401415981588 (37.7675211379264, -122.401415981588)
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)
73496 220620 2 70 747 Duncan St 1 9 1 1     8 Width 4ft   6001698.74806 2099680.01267 37.745417306567 -122.43682864783001 (37.745417306567, -122.43682864783)
76457 125449 2 70 3101 Clay St 4 1 1 1     4 Width 4ft   5999876.27718 2115725.0378099997 37.789369177790206 -122.444283251471 (37.7893691777902, -122.444283251471)
76565 220629 2 70 907 Elizabeth St 3 9 1 1     7 Width 4ft   6000561.393680001 2101957.84527 37.7516069822761 -122.440924802556 (37.7516069822761, -122.440924802556)
76902 175164 2 70 229 Delano Ave 13 9 1 1     1 Width 4ft   6000102.2336800005 2092318.3901400003 37.7251131517233 -122.44182086904301 (37.7251131517233, -122.441820869043)
79896 220604 2 70 446 27th St 1 1 1 1     16 Width 4ft   6003586.44761 2100127.58593 37.7467533438884 -122.430333215209 (37.7467533438884, -122.430333215209)
118179 125465 2 70 1177 California St 1 10 1 1     6 Width 4ft   6008661.04402 2116264.72933 37.7913483149251 -122.41392705669399 (37.7913483149251, -122.413927056694)
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)
136527 125466 2 70 1177 California St 2 10 1 1     3 Width 4ft   6008683.65979 2116266.52541 37.7913545166392 -122.413848933479 (37.7913545166392, -122.413848933479)
137603 117918 2 70 731 41st Ave 2 9 1 1     3 Width 4ft   5983185.43658 2110793.02592 37.774860926834606 -122.501665678898 (37.7748609268346, -122.501665678898)
137746 118929 2 70 875 La Playa 5 9 1 1     5 Width 4ft   5980750.23602 2109645.2788 37.7715662158284 -122.510004109936 (37.7715662158284, -122.510004109936)
146408 220630 2 70 901 Elizabeth St 1 9 1 1     5 Width 4ft   6000579.189809999 2101957.47614 37.7516069822848 -122.44086323496 (37.7516069822848, -122.44086323496)
148949 189196 2 70 30 15th St 5 1 1 1     6 Width 4ft   6012020.7847 2107509.88543 37.767497654832894 -122.401686734167 (37.7674976548329, -122.401686734167)
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)
150463 125478 2 70 150 Sproule Ln 5 1 1 1     9 Width 4ft   6009235.21214 2116893.1375 37.79310600030529 -122.411984868232 (37.7931060003053, -122.411984868232)
150893 189163 2 70 2324 19th St 1 1 1 1     2 Width 4ft   6010839.472159999 2105097.2568200002 37.7608071304715 -122.405602811334 (37.7608071304715, -122.405602811334)
151194 220621 2 70 714 Duncan St 2 9 1 1     5 Width 4ft   6001868.87894 2099747.43156 37.745612090735506 -122.43624518748999 (37.7456120907355, -122.43624518749)
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)
152269 220631 2 70 901 Elizabeth St 3 1 1 1     5 Width 4ft   6000591.194080001 2101959.06133 37.751612018500204 -122.440821836477 (37.7516120185002, -122.440821836477)
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)
154701 220611 2 70 1 Bradford St 1 1 1 1     5 Width 4ft   6009641.7814 2098664.7156700003 37.743077758937105 -122.40929116218399 (37.7430777589371, -122.409291162184)
155489 125460 2 70 2416 Webster St 1 1 1 1     2 Width 4ft   6003175.77984 2117097.00502 37.7933239410913 -122.432965418428 (37.7933239410913, -122.432965418428)
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)
156172 249529 2 70 1035 Van Ness Ave 3 1 1 1     1 Width 4ft   6006430.75514 2114125.51985 37.7853490652506 -122.4214918273 (37.7853490652506, -122.4214918273)
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)
160711 175159 2 70 229 Delano Ave 7 9 1 1     1 Width 4ft   6000090.185269999 2092307.21266 37.7250817743959 -122.441861717141 (37.7250817743959, -122.441861717141)
164426 125476 2 70 150 Sproule Ln 3 1 1 1     7 Width 4ft   6009246.74599 2116823.51326 37.792915476223705 -122.41194003791 (37.7929154762237, -122.41194003791)
168173 125468 2 70 1177 California St 4 10 1 1     5 Width 4ft   6008726.14199 2116272.16952 37.7913723996763 -122.413702344902 (37.7913723996763, -122.413702344902)
171065 125463 2 70 935 O'Farrell St 1 1 1 1     6 Width 4ft   6006804.241090001 2113922.09635 37.7848115656375 -122.42018523378599 (37.7848115656375, -122.420185233786)
172151 220652 2 70 324 Park St 1 1 1 1     1 Width 4ft   6006873.24491 2096273.48816 37.7363564804515 -122.418694495969 (37.7363564804515, -122.418694495969)
172584 125474 2 70 150 Sproule Ln 1 1 1 1     9 Width 4ft   6009252.35721 2116781.07333 37.792799261332 -122.411917622313 (37.792799261332, -122.411917622313)
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)
173963 203499 2 70 379 Staples Ave 1 1 1 1     4 Width 4ft   5997569.0689199995 2093791.20398 37.7290124835419 -122.45068384968799 (37.7290124835419, -122.450683849688)
178536 189195 2 70 30 15th St 4 1 1 1     9 Width 4ft   6012037.52857 2107512.72185 37.767506377346294 -122.401629018386 (37.7675063773463, -122.401629018386)
179679 175156 2 70 229 Delano Ave 3 9 1 1     1 Width 4ft   6000083.66792 2092301.69867 37.7250662628724 -122.441883851284 (37.7250662628724, -122.441883851284)
182457 246824 2 70 402 Franconia St 1 4 1 1     10 Width 4ft   6009972.67277 2098701.6792900003 37.7431977860534 -122.408149630203 (37.7431977860534, -122.408149630203)
183613 175155 2 70 229 Delano Ave 2 9 1 1     1 Width 4ft   6000081.06235 2092299.82458 37.7250609685792 -122.441892723985 (37.7250609685792, -122.441892723985)
184886 175161 2 70 229 Delano Ave 9 9 1 1     1 Width 4ft   6000095.42068 2092313.2586299998 37.7250986735632 -122.44184405267 (37.7250986735632, -122.44184405267)
188590 189193 2 70 30 15th St 2 1 1 1     6 Width 4ft   6012073.860090001 2107513.44954 37.767510402696296 -122.401503402873 (37.7675104026963, -122.401503402873)
Powered by Datasette · Query took 4.615ms · Data source: data.sfgov.org