sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
186005 227076 2 562 35 Yukon St 1 1 1 1     6 Width 3ft   6000264.72064 2104678.20499 37.7590595255837 -122.442145988358 (37.7590595255837, -122.442145988358)
185862 232267 2 561 38 Nebraska St 1 1 1 1     2 Width 3ft   6009278.96363 2097829.67893 37.7407645965011 -122.41048674157801 (37.7407645965011, -122.410486741578)
185138 227078 2 560 139 Duncan St 1 1 1 1     3 Width 3ft   6005638.73494 2099902.37732 37.7462510077934 -122.42322059318 (37.7462510077934, -122.42322059318)
184767 234869 2 559 483 Valley St 9 2 1 1     22     6002812.524730001 2099166.42238 37.7440703451703 -122.432940705074 (37.7440703451703, -122.432940705074)
184389 246328 2 558 1735 Mission St 1 1 1 1     23 Width 0ft   6006779.179 2108213.1723 37.76913482316721 -122.419866697495 (37.7691348231672, -122.419866697495)
179168 247007 2 557 401 Valley St 7 17 1 1     10 Width 8ft   6003259.67301 2099184.77085 37.744146077987 -122.431395876644 (37.744146077987, -122.431395876644)
178973 222747 2 556 131 Albion St 1 1 1 1     1 Width 3ft   6005909.4208 2106484.7834799998 37.764340040684296 -122.422752299085 (37.7643400406843, -122.422752299085)
170666 187858 2 554 550 Missouri St 2 7 1 1     5     6013512.81245 2104486.93396 37.7592804422575 -122.39631407184099 (37.7592804422575, -122.396314071841)
170201 243956 2 553 1374 Hampshire St 1 1 1 1     19 Width 3ft   6010321.8959800005 2101296.94026 37.7503433529628 -122.407125000243 (37.7503433529628, -122.407125000243)
166103 248402 2 551 701 Shrader St 1 1 1 1     1 Width 0ft   5997566.8136 2108099.9902 37.7683007569323 -122.45172341954999 (37.7683007569323, -122.45172341955)
173140 248498 2 551 156 Belvedere St 1 1 1 1     4 Width 0ft   5998302.5369 2107853.4873 37.7676660307619 -122.449160873661 (37.7676660307619, -122.449160873661)
162882 220117 2 550 1200 York St 2 1 1 1     2 Width 3ft   6010017.12435 2102145.65843 37.7526566844658 -122.408238779095 (37.7526566844658, -122.408238779095)
180948 188541 2 550 1201 20th St 5 9 1 1     6 Width 6ft   6014304.71414 2104773.92766 37.7601124986177 -122.393595357466 (37.7601124986177, -122.393595357466)
162156 193474 2 549 1310 Indiana St 25 23 1 1     1     6014936.17409 2102358.6880200002 37.7535158347022 -122.391242588881 (37.7535158347022, -122.391242588881)
161504 225137 2 548 1101 San Jose Ave 6 7 1 1     24     6004725.51952 2096307.5135400002 37.736328750759796 -122.42612250576 (37.7363287507598, -122.42612250576)
160329 118189 2 546 806 34th Ave 1 1 1 1     20 Width 3ft   5985428.5638 2110364.72057 37.773816419818296 -122.493874773697 (37.7738164198183, -122.493874773697)
155559 188839 2 545 1754 Revere Ave 1 4 1 1     1 Width 3ft   6014336.85502 2094986.79308 37.7332408718702 -122.392799486222 (37.7332408718702, -122.392799486222)
168155 188838 2 545 1639 Kirkwood Ave 1 4 1 1     4 Width 4ft   6014968.28203 2096897.0990000002 37.738521233155204 -122.39074990519501 (37.7385212331552, -122.390749905195)
154172 187565 2 544 136 Alpha St 7 9 1 1     4 Width 10ft   6010916.99184 2088120.11863 37.714195861437794 -122.404139852688 (37.7141958614378, -122.404139852688)
167381 187566 2 544 136 Alpha St 8 9 1 1     5 Width 10ft   6010914.5006 2088119.67508 37.7141945043399 -122.404148432227 (37.7141945043399, -122.404148432227)
186930 188812 2 544 2211 25th St 3 9 1 1     4     6012100.78981 2101856.17323 37.7519782763782 -122.40101271476601 (37.7519782763782, -122.401012714766)
153481 136057 2 543 331 Walnut St 1 1 1 1     8 Width 2ft   5998559.644719999 2115379.19074 37.7883443679496 -122.448813707713 (37.7883443679496, -122.448813707713)
150767 131244 2 542 2770 Green St 3 9 1 1     5 Width 6ft   5999801.9058 2117795.56718 37.795050062951496 -122.44468945095899 (37.7950500629515, -122.444689450959)
161876 116755 2 542 601x Wisconsin St 3 1 1 1     3 3x3   6012732.7732 2104597.96658 37.7595418769705 -122.39901963633999 (37.7595418769705, -122.39901963634)
147432 248427 2 541 730 Ashbury St 1 1 1 1     2 Width 0ft   5999078.0822 2108014.2896 37.768151880704 -122.44648994003401 (37.768151880704, -122.446489940034)
136308 223353 2 536 476 Noe St 1 1 1 1     4 Width 3ft   6002943.03103 2105483.62599 37.7614232910681 -122.432940670896 (37.7614232910681, -122.432940670896)
136054 191713 2 535 601 Wisconsin St 20 9 1 1     15 Width 6ft   6012726.33226 2104665.52893 37.759727029402704 -122.399046654695 (37.7597270294027, -122.399046654695)
133988 221178 2 534 1101 San Jose Ave 68 2 1 1     4 Width 8ft   6005051.84205 2096632.8627099998 37.7372405248233 -122.425017413417 (37.7372405248233, -122.425017413417)
163433 205609 2 534 1484 16th Ave 2 2 1 1     7 Width 5ft   5991184.61852 2105324.79706 37.760313237173 -122.47359614005899 (37.760313237173, -122.473596140059)
180475 188232 2 534 1498 25th St 3 1 1 1     3 Width 3ft   6014336.19933 2102024.0819200003 37.7525637629087 -122.39329403420601 (37.7525637629087, -122.393294034206)
133932 197368 2 533 601 Wisconsin St 12 9 1 1     8 Width 6ft   6012729.08438 2104643.98882 37.759668038361504 -122.399035624504 (37.7596680383615, -122.399035624504)
128807 102796 2 531 536 Alvarado St 1 1 1 1       3x3   6002890.0 2102715.0 37.753818298827206 -122.43292628008001 (37.7538182988272, -122.43292628008)
122921 106507 2 529 50 FANNING WAY   7 1 1           5991716.2 2101233.1 37.749109278682795 -122.471459514348 (37.7491092786828, -122.471459514348)
122731 104778 2 528 736 CASTRO ST 1 1 1 1     16 3x3   6002380.5 2103803.5 37.7567781475012 -122.434766079383 (37.7567781475012, -122.434766079383)
165189 215574 2 527 637 Detroit St 3 9 1 1     9 Width 8ft   5999417.56245 2095197.50098 37.732979482112 -122.444394512913 (37.732979482112, -122.444394512913)
131449 120240 2 526 288 24th Ave 3 1 1 1     2 Width 3ft   5988397.12224 2114058.72928 37.7841323663842 -122.483877094997 (37.7841323663842, -122.483877094997)
155426 190034 2 526 594 Arkansas St 1 4 1 1     2 Width 3ft   6012963.9697199995 2104277.8254 37.7586757201207 -122.398197577755 (37.7586757201207, -122.398197577755)
161922 225212 2 526 1357 Natoma St 1 1 1 1     4 Width 2ft   6007181.04871 2107590.64768 37.76744814894921 -122.41843250275801 (37.7674481489492, -122.418432502758)
162265 227077 2 525 644 South Van Ness Ave 1 1 1 1     5 Width 3ft   6007449.2504900005 2105879.4887599996 37.7627648007686 -122.417383547038 (37.7627648007686, -122.417383547038)
112157 122695 2 522 2500X Pierce St 3 1 1 1       3x3   6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
109005 99791 2 520 4120-4124 24th St 1 1 1 1       3x4   6002399.0 2101817.0 37.7513247429435 -122.43456006421499 (37.7513247429435, -122.434560064215)
122132 99793 2 520 4120-4124 24th St 3 1 1 1       3x3   6002399.0 2101817.0 37.7513247429435 -122.43456006421499 (37.7513247429435, -122.434560064215)
103902 112152 2 514 299x SHOTWELL ST 2 1 1 3       3x3   6007772.0 2106483.0 37.7644400562771 -122.41631001514901 (37.7644400562771, -122.416310015149)
105186 113783 2 514 1188 SHOTWELL ST 1 1 1 1     26 3x3   6008033.0 2101004.0 37.7494106463882 -122.41501945132 (37.7494106463882, -122.41501945132)
140878 107632 2 514 814 Potrero Ave 1 1 1 1     10 3x3   6010397.84183 2104391.4418 37.758844416174 -122.407080469655 (37.758844416174, -122.407080469655)
101864 122731 2 513 310 Sanchez St 1 1 1 1     10 3x3   6003508.0 2106439.0 37.7640785470532 -122.431054869188 (37.7640785470532, -122.431054869188)
96007 102903 2 508 577 Castro St 1 1 1 1     11 3x3   6002396.0 2104853.0 37.7596607018428 -122.43478752318701 (37.7596607018428, -122.434787523187)
120962 108073 2 505 101 BUENA VISTA AVE EAST 3 1 1 1       3x3   6001336.0 2108482.0 37.769564805176394 -122.438713569331 (37.7695648051764, -122.438713569331)
92918 110864 2 504 1798x 22ND ST 1 14 1 1           6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
143095 99561 2 503 418 Clipper St 1 1 1 1           6002462.0 2100938.0 37.748914793116995 -122.434279368207 (37.748914793117, -122.434279368207)
87731 109029 2 497 923 CAPP ST   1 1 1       3x3   6007430.9 2101912.0 37.7518699557381 -122.417165865844 (37.7518699557381, -122.417165865844)
87008 108240 2 495 163 DELMAR ST 1 1 1 1     8 3x3   5999383.5 2107248.1 37.766065556669396 -122.445378437485 (37.7660655566694, -122.445378437485)
101029 122389 2 493 166 Lomita Ave 1 1 1 1       3x3   5991334.0 2104180.0 37.7571785771329 -122.47299602104601 (37.7571785771329, -122.472996021046)
101496 117093 2 493 2X 09TH AVE 4 2 1 1     4 3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
102296 117095 2 493 2X 09TH AVE 6 2 1 1     5 3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
103462 106338 2 493 497 VALLEY ST 3 5 1 1   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779.0 2099138.0 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711)
145290 106337 2 493 497 VALLEY ST 6 5 1 1   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779.0 2099138.0 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711)
85592 111045 2 488 400x BUCHANAN ST 1 1 1 1       3x3   6004666.0 2109838.0 37.7734769308436 -122.42729182472 (37.7734769308436, -122.42729182472)
87709 111046 2 488 400x BUCHANAN ST 6 1 1 1       3x3   6004666.0 2109838.0 37.7734769308436 -122.42729182472 (37.7734769308436, -122.42729182472)
104529 111048 2 488 400x BUCHANAN ST 8 1 1 1       3x3   6004666.0 2109838.0 37.7734769308436 -122.42729182472 (37.7734769308436, -122.42729182472)
138715 111047 2 488 400x BUCHANAN ST 7 1 1 1       3x3   6004666.0 2109838.0 37.7734769308436 -122.42729182472 (37.7734769308436, -122.42729182472)
171569 187859 2 488 801 Arkansas St 27 9 1 1     14     6013056.7920699995 2103769.18964 37.7572842872596 -122.39784087518 (37.7572842872596, -122.39784087518)
117144 192174 2 486 170 Venus St 1 4 1 1     4 Width 2ft   6012806.8459 2094069.7860400002 37.7306378606291 -122.39802487285101 (37.7306378606291, -122.398024872851)
135347 176478 2 486 44 Winding Way 2 1 1 1     1 Width 6ft   6002686.439069999 2087042.3982900002 37.7107733564667 -122.432510875004 (37.7107733564667, -122.432510875004)
158915 192175 2 486 1508 Quint St 2 9 1 1     5 Width 4ft   6013162.6398599995 2096311.8698099998 37.7368139691889 -122.396951969064 (37.7368139691889, -122.396951969064)
84560 103946 2 484 243 Banks St 1 1 1 1     10 2x3 Permit Number 770210 6008640.0 2097502.0 37.739829020043295 -122.41267288548401 (37.7398290200433, -122.412672885484)
159105 249960 2 484 273 Filbert St 2 7 1 1     7 Width 0ft   6011557.47515 2120068.82812 37.801955696153 -122.40417326248999 (37.801955696153, -122.40417326249)
116955 107434 2 482 3169 WASHINGTON ST 1 1 1 1           5999560.6 2115983.6 37.7900611064648 -122.44539405336 (37.7900611064648, -122.44539405336)
167266 239563 2 480 51 13th St 6 4 1 1     19 Width 5ft   6008200.43388 2108278.8287 37.7693950660465 -122.414955290262 (37.7693950660465, -122.414955290262)
178977 197475 2 480 1900 19th St 5 7 1 1     16     6012041.1357 2105142.55363 37.760998626697294 -122.40144994987 (37.7609986266973, -122.40144994987)
82737 106281 2 474 399X Elliot St 2 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
95834 106280 2 474 399X Elliot St 1 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
119057 106282 2 474 399X Elliot St 3 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
81570 103674 2 471 3141 23rd St 1 1 1 1       3x3   6008036.0 2102674.0 37.7539962579222 -122.41512727180599 (37.7539962579222, -122.415127271806)
141434 106171 2 470 2521 19TH ST 1 1 1 1   02/11/2015 12:00:00 AM 3 3x3 Permit Number 774749 6010356.3 2105009.4 37.7605388656214 -122.40726770344601 (37.7605388656214, -122.407267703446)
114847 108140 2 467 3390x 18TH ST 2 1 1 1       3x3   6006957.7 2105612.4 37.7620037686995 -122.41906470461399 (37.7620037686995, -122.419064704614)
94337 114188 2 466 2200 HAYES ST 4 1 1 1       5x6   5997096.0 2109871.0 37.7731365175856 -122.45347979574801 (37.7731365175856, -122.453479795748)
144707 115633 2 466 4567 19th St 1 1 1 1       4x9   6000786.8 2104618.2 37.7589245060719 -122.44033609165001 (37.7589245060719, -122.44033609165)
79691 108875 2 465 240X NORIEGA ST 2 1 1 1       3x3   5993306.5 2103252.9 37.7547470014972 -122.46610704085501 (37.7547470014972, -122.466107040855)
82268 108877 2 465 240X NORIEGA ST 4 1 1 1       3x3   5993306.5 2103252.9 37.7547470014972 -122.46610704085501 (37.7547470014972, -122.466107040855)
114098 105750 2 465 240X NORIEGA ST 1 1 1 1     26 3x3   5993306.5 2103252.9 37.7547470014972 -122.46610704085501 (37.7547470014972, -122.466107040855)
117499 108876 2 465 240X NORIEGA ST 3 1 1 1       3x3   5993306.5 2103252.9 37.7547470014972 -122.46610704085501 (37.7547470014972, -122.466107040855)
80032 105543 2 460 123 SOUTH VAN NESS AVE 2 1 1 1     7 3x3   6007367.5 2109091.5 37.771579629731704 -122.417893993822 (37.7715796297317, -122.417893993822)
77975 106185 2 456 1349 ULLOA ST 2 1 1 1     8 4x4   5991806.5 2098368.4 37.741248771742896 -122.470938602248 (37.7412487717429, -122.470938602248)
105124 106186 2 456 1349 ULLOA ST 1 1 1 1     6 4x4   5991806.5 2098368.4 37.741248771742896 -122.470938602248 (37.7412487717429, -122.470938602248)
75026 199509 2 453 800 19th St 9 9 1 1     8 Width 10ft   6015055.67161 2105341.31512 37.7617121209521 -122.39103778987 (37.7617121209521, -122.39103778987)
153814 199510 2 453 1 01st St 14 23 1 1     5     6014434.26374 2105920.54159 37.7632680488164 -122.39322753922801 (37.7632680488164, -122.393227539228)
72971 122942 2 452 300 09th Ave 9 1 1 1     8 Width 3ft   5993109.163980001 2113243.95905 37.7821684105844 -122.467515988912 (37.7821684105844, -122.467515988912)
72609 240846 2 451 2070 Folsom St 6 1 1 1     19 Width 3ft   6008057.57585 2106395.3094 37.7642153325926 -122.41531607580299 (37.7642153325926, -122.415316075803)
162587 240845 2 451 237 Holly Park Cir 2 1 1 1     3 Width 3ft   6006873.33933 2096646.66058 37.737381134717204 -122.418720625774 (37.7373811347172, -122.418720625774)
71888 197477 2 447 1301 Minnesota St 19 7 1 1     9     6015374.65635 2102387.84204 37.75362021001371 -122.38972824565799 (37.7536202100137, -122.389728245658)
173936 197478 2 447 1301 Minnesota St 66 7 1 1     12     6015365.810330001 2102331.75895 37.7534657271771 -122.389754920476 (37.7534657271771, -122.389754920476)
182590 197476 2 447 1301 Minnesota St 11 7 1 1     12     6015385.43711 2102326.66714 37.7534528344877 -122.38968669068899 (37.7534528344877, -122.389686690689)
152379 240365 2 446 322 Elsie St 13 1 1 1     5 Width 3ft   6006294.96909 2096881.84233 37.737994310480204 -122.420737015497 (37.7379943104802, -122.420737015497)
71183 245129 2 444 1262 Page St 1 1 1 1     4 Width 0ft   6000511.2695 2109276.7485 37.771700032393 -122.441623315797 (37.771700032393, -122.441623315797)
68539 205975 2 443 5 Sequoia Way 6 2 1 1     6 Width 3ft   5998211.61791 2097832.09967 37.7401445796092 -122.448753454923 (37.7401445796092, -122.448753454923)
67491 190750 2 442 1717 Revere Ave 1 2 1 1     35     6014482.8243 2094823.0948599998 37.732799496305596 -122.392283381472 (37.7327994963056, -122.392283381472)
76582 246774 2 442 1850 Alabama St 3 2 1 1     15     6009457.96402 2098740.81971 37.743276423664796 -122.40993212697398 (37.7432764236648, -122.409932126974)
67436 197370 2 441 1914 23rd St 1 9 1 1     4     6012653.596919999 2102871.10125 37.7547958703446 -122.399172251311 (37.7547958703446, -122.399172251311)
65849 116063 2 440 2100x 19th St 7 1 1 4 2   19 3x3   6011332.66531 2105125.78364 37.760913024731295 -122.403899073603 (37.7609130247313, -122.403899073603)
76037 205637 2 440 39 Gaviota Way 1 1 1 1     9 Width 3ft   5998478.2496 2097431.88931 37.739060941513706 -122.44780275009501 (37.7390609415137, -122.447802750095)
Powered by Datasette · Query took 64.281ms · Data source: data.sfgov.org