sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
125 119758 2 22 151X Octavia St Frontage West 1 1 1 1                    
795 140241 2 22 160 Ashbury St 3 1 1 1     2 Width 0ft   5998775.6798 2110202.3294 37.7741424035345 -122.44769344620701 (37.7741424035345, -122.447693446207)
1498 251577 2 22 490X Ashbury St 2 1 1 1       3x3   5998892.0 2109203.0 37.7714051474644 -122.447219139052 (37.7714051474644, -122.447219139052)
2277 230875 2 22 236 Whitney St 1 1 1 1   07/10/2017 12:00:00 AM 3 Width 3ft Permit Number 780225 6004378.79824 2096997.6993900002 37.7382042419264 -122.42737041762 (37.7382042419264, -122.42737041762)
3356 231847 2 22 4050 17th St 2 1 1 1   08/22/2016 12:00:00 AM 3 Width 2ft Permit Number 778753 6001932.15846 2105889.72854 37.762480961257296 -122.436465919794 (37.7624809612573, -122.436465919794)
3681 210783 2 22 102 Kirkham St 3 1 1 1     8 Width 4ft   5994553.24166 2105346.7379 37.7605679917509 -122.46194732411001 (37.7605679917509, -122.46194732411)
3715 240037 2 22 4109 18th St 1 1 1 1     7 Width 3ft   6002258.67075 2105277.61191 37.7608187856797 -122.435292848592 (37.7608187856797, -122.435292848592)
3777 121577 2 22 358 Walnut St 2 1 1 1     1 3x3   5998615.65144 2115302.1022900003 37.788135906006104 -122.448614380145 (37.7881359060061, -122.448614380145)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5685 95207 2 22 2203 Divisadero St 1 1 1 1     6 3x3   6000850.32239 2115965.74375 37.7900856173129 -122.440930450291 (37.7900856173129, -122.440930450291)
9572 100227 2 22 542 Valley St 1 2 1 1     30   Permit Number 769993 6002426.0 2099190.0 37.7441131524814 -122.434278904907 (37.7441131524814, -122.434278904907)
9704 104747 2 22 2-X FORD ST 1 1 1 1     12     6003502.9 2105705.5 37.762064243675106 -122.431020153892 (37.7620642436751, -122.431020153892)
9729 173667 2 22 37 Ford St 2 1 1 1       3x3   6003363.0 2105606.0 37.7617831123707 -122.431496910184 (37.7617831123707, -122.431496910184)
9733 173666 2 22 37 Ford St 1 1 1 1       3x3   6003363.0 2105606.0 37.7617831123707 -122.431496910184 (37.7617831123707, -122.431496910184)
10149 173884 2 22 100X Kirkham St 2 1 1 1   02/02/2017 12:00:00 AM 3 3x3            
10171 173890 2 22 2593 23rd Ave 1 1 1 1       3x3   5989209.0 2097724.0 37.7393288482101 -122.479872589648 (37.7393288482101, -122.479872589648)
10173 173893 2 22 2593 23rd Ave 2 1 1 1       3x3   5989209.0 2097724.0 37.7393288482101 -122.479872589648 (37.7393288482101, -122.479872589648)
10257 101048 2 22 3050 19th St 1 1 1 1       3x3   6008765.0 2105072.0 37.7606215625409 -122.41277572810101 (37.7606215625409, -122.412775728101)
10261 101049 2 22 3050 19th St 2 1 1 1       3x3   6008765.0 2105072.0 37.7606215625409 -122.41277572810101 (37.7606215625409, -122.412775728101)
10356 75141 2 22 1739X Felton St 4 1 1 1 1 05/21/1994 12:00:00 AM 5 4x4   6005823.096940001 2092308.52948 37.7254103965462 -122.422043716969 (37.7254103965462, -122.422043716969)
10568 75056 2 22 1739X Felton St 5 1 1 1 1 05/21/1994 12:00:00 AM 12 4x4   6005836.26564 2092311.52216 37.7254193565072 -122.421998406407 (37.7254193565072, -122.421998406407)
10885 75223 2 22 1739X Felton St 3 1 1 1 1 05/21/1994 12:00:00 AM 5 3x3   6005812.42229 2092304.2308200002 37.7253979913003 -122.42208031306801 (37.7253979913003, -122.422080313068)
11652 75299 2 22 1739X Felton St 2 1 1 1 1 05/21/1994 12:00:00 AM 10 3x3   6005800.51839 2092301.4633900002 37.7253897211337 -122.422121267299 (37.7253897211337, -122.422121267299)
12317 75378 2 22 1739X Felton St 1 1 1 1 1 05/21/1994 12:00:00 AM 10 3x3   6005787.8485 2092298.2096 37.7253800723092 -122.422164834944 (37.7253800723092, -122.422164834944)
14041 101151 2 22 390X Missouri St 2 1 1 1     10 5x9   6013467.3769 2105274.43287 37.7614402136082 -122.39652641256001 (37.7614402136082, -122.39652641256)
17991 99745 2 22 4295X 26th St 1 1 1 1     10 3x3 1201 Diamond St is true address 6002005.5 2100584.2 37.7479174208607 -122.435832632906 (37.7479174208607, -122.435832632906)
20259 111367 2 22 20 MELROSE AVE 1 1 1 1     4 3x3   5999966.0 2095537.0 37.7339429435496 -122.442522793498 (37.7339429435496, -122.442522793498)
22357 231905 2 22 465 Waller St 1 1 1 1     15 Width 3ft   6003484.44623 2108951.72697 37.7709765499621 -122.431315711972 (37.7709765499621, -122.431315711972)
22986 250821 2 22 45 Sea View Ter 2 2 1 1     9 Width 4ft   5986295.23656 2114137.57517 37.7842262706806 -122.49115456935 (37.7842262706806, -122.49115456935)
23410 184354 2 22 1251 Sunset Blvd 1 9 1 1     8 Width 0ft   5984645.6432 2106661.7256 37.7636032084053 -122.496309703367 (37.7636032084053, -122.496309703367)
23450 123728 2 22 442 Cabrillo St 3 1 1 1     2 Width 3ft   5994183.65104 2110778.10938 37.7754598251749 -122.46361975746201 (37.7754598251749, -122.463619757462)
23451 231854 2 22 159 Lower Ter 1 1 1 1     8 Width 3ft   6000087.79155 2106199.90497 37.763227653065705 -122.44286716371401 (37.7632276530657, -122.442867163714)
23470 71021 2 22 511 17th Ave 1 1 1 1 1 03/09/1996 12:00:00 AM 6     5990601.64729 2111881.43393 37.7782822050168 -122.476091231143 (37.7782822050168, -122.476091231143)
23508 209794 2 22 109 Alton Ave 1 1 1 1     3 Width 3ft   5993782.32233 2101635.61991 37.7503338048846 -122.464344117192 (37.7503338048846, -122.464344117192)
23510 209272 2 22 843 Detroit St 8 9 1 1     2 Width 5ft   5999418.82606 2095617.22879 37.7341320280635 -122.444420298265 (37.7341320280635, -122.444420298265)
23517 209373 2 22 1252 16th Ave 1 1 1 1     14 Width 3ft   5991128.27573 2106899.83011 37.7646345947379 -122.473905912433 (37.7646345947379, -122.473905912433)
23533 123322 2 22 716 05th Ave 2 1 1 1     11 Width 3ft   5994444.46467 2110634.73162 37.7750811726017 -122.462707144593 (37.7750811726017, -122.462707144593)
23599 131095 2 22 706 Buchanan St 1 1 1 1     8 Width 3ft   6004512.18465 2110960.6129900003 37.776550651416294 -122.427903903557 (37.7765506514163, -122.427903903557)
23603 231527 2 22 127 Scott St 1 4 1 1     9 Width 3ft   6002315.440669999 2108966.67057 37.7709512619163 -122.435360399361 (37.7709512619163, -122.435360399361)
23729 209465 2 22 1878 15th Ave 1 1 1 1     5 Width 2ft   5991595.57895 2102614.9413799997 37.752896477005 -122.47197732171101 (37.752896477005, -122.471977321711)
23762 209637 2 22 1430 06th Ave 1 1 1 1     12 Width 4ft   5994302.72702 2105756.1428 37.7616776858958 -122.46284343557501 (37.7616776858958, -122.462843435575)
23808 231563 2 22 2920 26th St 2 1 1 1     10 Width 3ft   6009927.8420400005 2101065.79255 37.749686612257 -122.408471368954 (37.749686612257, -122.408471368954)
23888 209236 2 22 32 Malta Dr 9 2 1 1     13 Width 3ft   5999655.9462 2095979.13545 37.735139265160704 -122.443626491896 (37.7351392651607, -122.443626491896)
23890 123138 2 22 658 10th Ave 1 1 1 1     12 Width 4ft   5992881.38641 2110973.8933099997 37.7759222725903 -122.468138806154 (37.7759222725903, -122.468138806154)
23984 209244 2 22 775 Ulloa St 1 9 1 1     10 Width 3ft   5993691.11569 2098103.1453400003 37.740629265622104 -122.46440306685801 (37.7406292656221, -122.464403066858)
24002 182106 2 22 2439 28th Ave 1 1 1 1     14 Width 0ft   5987641.7311 2098685.4824 37.7418776469871 -122.485361975947 (37.7418776469871, -122.485361975947)
24040 183387 2 22 40 Escolta Way 1 1 1 1     14 Width 0ft   5986812.7748 2097161.9589 37.737646126802396 -122.488116273818 (37.7376461268024, -122.488116273818)
24050 209682 2 22 1849 15th Ave 1 2 1 1     6 Width 3ft   5991553.31162 2102854.2151599997 37.7535510143851 -122.472140928188 (37.7535510143851, -122.472140928188)
24117 231843 2 22 481 Duboce Ave 1 9 1 1     8 Width 3ft   6003596.22484 2108318.99367 37.769245552863495 -122.430883903372 (37.7692455528635, -122.430883903372)
24131 230898 2 22 11 Clarendon Ave 3 2 1 1     5 Width 2ft   5998114.42055 2104641.61422 37.758836276097796 -122.44958007486 (37.7588362760978, -122.44958007486)
24174 139827 2 22 935 GOLDEN GATE AVE 1 1 1 1     8 Width 0ft   6004994.0584 2112283.956 37.7802114754967 -122.42633120445 (37.7802114754967, -122.42633120445)
24178 231624 2 22 1154 Cole St 1 1 1 1     16 Width 4ft   5998207.511 2106262.64748 37.7632925517426 -122.44937492152201 (37.7632925517426, -122.449374921522)
24189 230870 2 22 379 Laidley St 4 1 1 1     17 Width 4ft   6003816.948969999 2096577.80971 37.7370195281372 -122.429283080446 (37.7370195281372, -122.429283080446)
24250 137978 2 22 1620 LAGUNA ST 3 1 1 1     11 Width 0ft   6004505.4337 2114508.372 37.7862915363591 -122.428180153911 (37.7862915363591, -122.428180153911)
24359 138317 2 22 2434 Pine St 1 1 1 1     6 Width 0ft   6002023.3405 2115050.4193 37.78763910988 -122.43680635844 (37.78763910988, -122.43680635844)
24372 246497 2 22 319 Duncan St 1 4 1 1     15 Width 6ft   6004279.93355 2099832.71811 37.7459829621447 -122.427914200798 (37.7459829621447, -122.427914200798)
24458 209631 2 22 1254 05th Ave 1 1 1 1     3 Width 3ft   5994572.8448 2106935.5378400004 37.7649315526747 -122.46199474266899 (37.7649315526747, -122.461994742669)
24474 193517 2 22 1600 Bay Shore Blvd 9 9 1 1     11 Width 6ft   6011952.06769 2091431.9694299998 37.7233473149134 -122.400794740685 (37.7233473149134, -122.400794740685)
24511 231737 2 22 1301 Douglass St 7 9 1 1     9 Width 4ft   6001392.41312 2099896.6008200003 37.745994591279796 -122.437903413209 (37.7459945912798, -122.437903413209)
24578 230993 2 22 372 Park St 1 1 1 1     6 Width 4ft   6007220.08517 2096245.2040099998 37.736298340185705 -122.41749331738701 (37.7362983401857, -122.417493317387)
24624 131128 2 22 2611 Pierce St 4 1 1 1     9 Width 4ft   6001629.49322 2117399.46805 37.794066598536205 -122.438337345993 (37.7940665985362, -122.438337345993)
24751 231062 2 22 3929 19th St 2 1 1 1     6 Width 3ft   6003454.39351 2104753.7452 37.7594482044981 -122.431119984394 (37.7594482044981, -122.431119984394)
24797 120177 2 22 130 26th Ave 1 9 1 1     14 Width 2ft   5987747.51554 2115102.62556 37.786960769727294 -122.486201131854 (37.7869607697273, -122.486201131854)
24806 250749 2 22 2845 Lake St 2 2 1 1     4 Width 4ft   5986570.97427 2114425.38607 37.785032623492896 -122.490221805991 (37.7850326234929, -122.490221805991)
24863 209325 2 22 1973 17th Ave 1 1 1 1     9 Width 2ft   5990940.97298 2101989.70904 37.751141852032205 -122.474195431169 (37.7511418520322, -122.474195431169)
25104 231699 2 22 965 Alabama St 1 1 1 1     9 Width 4ft   6009171.435959999 2103550.45035 37.7564665364152 -122.41126255794501 (37.7564665364152, -122.411262557945)
25173 140670 2 22 40 COLE ST 1 10 1 1     2 Width 0ft   5997774.3514 2110415.6204 37.7746707659902 -122.451172585534 (37.7746707659902, -122.451172585534)
25181 230942 2 22 510 Anderson St 2 1 1 1     20 Width 3ft   6007792.31674 2095781.12645 37.7350562658258 -122.4154820241 (37.7350562658258, -122.4154820241)
25204 209684 2 22 1853 15th Ave 1 2 1 1     4 Width 3ft   5991553.70129 2102821.79388 37.7534620165755 -122.472137217586 (37.7534620165755, -122.472137217586)
25317 209387 2 22 1279 06th Ave 1 1 1 1     9 Width 4ft   5994216.77658 2106859.15952 37.7647013316329 -122.46322074075 (37.7647013316329, -122.46322074075)
25356 106321 2 22 1215 De Haro St 2 1 1 1     14 4x4   6012267.27485 2102718.9065900003 37.754356440022605 -122.40049757771001 (37.7543564400226, -122.40049757771)
25368 139833 2 22 915 GOLDEN GATE AVE 2 1 1 1     7 Width 0ft   6005225.3404 2112316.8255 37.7803147977684 -122.42553343322099 (37.7803147977684, -122.425533433221)
25415 209553 2 22 95 Sotelo Ave 1 2 1 1     11 Width 4ft   5993698.07886 2101380.70554 37.7496290187806 -122.46461692652599 (37.7496290187806, -122.464616926526)
25520 185142 2 22 2513 33rd Ave 3 9 1 1     7 Width 0ft   5986108.0169 2098114.3936 37.7402201189445 -122.49062297943001 (37.7402201189445, -122.49062297943)
25531 70321 2 22 148 Cole St 1 1 1 1 1 04/23/1994 12:00:00 AM 11 7x6   5997828.6446 2110019.5409 37.7735863423596 -122.45095620867501 (37.7735863423596, -122.450956208675)
25571 209651 2 22 542 Moraga St 2 1 1 1     18 Width 3ft   5992551.11807 2103917.05169 37.7565269798607 -122.46876766022 (37.7565269798607, -122.46876766022)
25662 231833 2 22 1992 15th St 1 1 1 1     3 Width 3ft   6004253.30921 2107202.01126 37.7662157971484 -122.428531453164 (37.7662157971484, -122.428531453164)
25737 140187 2 22 298 Shrader St 1 1 1 1     8 Width 0ft   5997405.5507 2109562.5025 37.772307202525504 -122.452386759556 (37.7723072025255, -122.452386759556)
25833 209473 2 22 521 Magellan Ave 2 1 1 1     13 Width 3ft   5993084.65074 2099414.4556400003 37.7441948149359 -122.46659526326 (37.7441948149359, -122.46659526326)
25853 231817 2 22 120 Landers St 3 1 1 1     10 Width 3ft   6004475.52391 2106972.78879 37.7655989800448 -122.42774652130699 (37.7655989800448, -122.427746521307)
25892 209370 2 22 1228 16th Ave 1 1 1 1     10 Width 4ft   5991124.46575 2107043.58776 37.765029094054206 -122.473929578986 (37.7650290940542, -122.473929578986)
25898 131148 2 22 270 Willow St 1 1 1 1     6 Width 4ft   6006181.71516 2113353.0284599997 37.7832139488076 -122.422298527251 (37.7832139488076, -122.422298527251)
25899 209594 2 22 131 Gennessee St 1 1 1 1     6 Width 2ft   5997421.349330001 2093976.65079 37.729513219752896 -122.451207893625 (37.7295132197529, -122.451207893625)
25931 139829 2 22 925 GOLDEN GATE AVE 1 1 1 1     6 Width 0ft   6005130.3176 2112304.2753 37.7802749685253 -122.425861267784 (37.7802749685253, -122.425861267784)
26026 139835 2 22 887 GOLDEN GATE AVE 1 1 1 1     9 Width 0ft   6005300.0439 2112324.5947 37.7803403507322 -122.425275551972 (37.7803403507322, -122.425275551972)
26066 250823 2 22 30 Sea View Ter 2 2 1 1     4 Width 4ft   5986296.26976 2114176.2212099996 37.784332441942 -122.491153839973 (37.784332441942, -122.491153839973)
26084 231059 2 22 67 Ford St 1 1 1 1     5 Width 4ft   6003202.40331 2105618.92925 37.7618095094311 -122.432053272964 (37.7618095094311, -122.432053272964)
26107 139981 2 22 751 MCALLISTER ST 1 1 1 1     9 Width 0ft   6005577.1494 2112015.1112 37.779506235975795 -122.42429489646901 (37.7795062359758, -122.424294896469)
26148 209365 2 22 1300 14th Ave 1 1 1 1     10 Width 4ft   5991796.04351 2106482.35941 37.7635269869967 -122.47156588008 (37.7635269869967, -122.47156588008)
26175 231115 2 22 3953 20th St 1 1 1 1     4 Width 3ft   6003978.51295 2104194.32029 37.7579418427606 -122.429267430449 (37.7579418427606, -122.429267430449)
26237 231564 2 22 2920 26th St 3 1 1 1     10 Width 3ft   6009909.06605 2101066.3789 37.7496871707305 -122.408536338684 (37.7496871707305, -122.408536338684)
26300 230904 2 22 485 Dellbrook Ave 1 4 1 1     6 Width 3ft   5996727.95407 2103173.3402400003 37.7547253509046 -122.454269037488 (37.7547253509046, -122.454269037488)
26411 230860 2 22 318 Laidley St 1 1 1 1     18 Width 3ft   6004026.63407 2096783.8935599998 37.7375972562056 -122.42857279052299 (37.7375972562056, -122.428572790523)
26588 137973 2 22 1500 POST ST 14 1 1 1     2 Width 0ft   6004643.8873 2114372.6655 37.785926752973104 -122.42769146756599 (37.7859267529731, -122.427691467566)
26595 209576 2 22 463 Ulloa St 1 2 1 1     2 Width 4ft   5995269.77251 2098206.45138 37.7410037910016 -122.458952191409 (37.7410037910016, -122.458952191409)
26597 231781 2 22 268 Chenery St 1 1 1 1     4 Width 3ft   6004520.71069 2096859.01043 37.737831458554204 -122.42686988016399 (37.7378314585542, -122.426869880164)
26637 193496 2 22 1255 De Haro St 1 1 1 1     8 Width 3ft   6012278.046709999 2102532.17796 37.753844324662104 -122.40044721029601 (37.7538443246621, -122.400447210296)
26756 209688 2 22 1875 15th Ave 2 2 1 1     10 Width 3ft   5991556.577380001 2102635.80219 37.7529514984241 -122.472113715571 (37.7529514984241, -122.472113715571)
26778 245098 2 22 1010 Page St 1 1 1 1     9 Width 0ft   6001676.4288 2109440.6119999997 37.7722162763824 -122.437604701673 (37.7722162763824, -122.437604701673)
Powered by Datasette · Query took 12.92ms · Data source: data.sfgov.org