sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5 188702 3 5 1501 Evans Ave 2 4 1 2     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263)
7 188697 3 5 1301 Evans Ave 13 4 1 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
14 196590 4 9 43 Lafayette St 2 4 1 1     10 Width 3ft Permit Number 772992 6007565.6944699995 2109618.27361 37.773037177355796 -122.41724576098301 (37.7730371773558, -122.417245760983)
15 196591 4 9 43 Lafayette St 3 4 1 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
29 188686 3 5 1300 Evans Ave 20 4 1 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
30 196592 4 9 43 Lafayette St 4 4 1 1     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.41735848920901 (37.7731013709756, -122.417358489209)
131 237033 3 18 100 Octavia St 7 4 1 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 3 18 100 Octavia St 4 4 1 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
382 228870 1 11 132 Church St 1 4 1 1   11/03/2006 12:00:00 AM 2 Width 4ft Permit Number 49185 6004081.45763 2108139.41942 37.768779966653106 -122.42919270218599 (37.7687799666531, -122.429192702186)
395 249557 4 11 1450 Franklin St 3 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
404 249555 4 11 1450 Franklin St 1 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.787898211588704 -122.423418809148 (37.7878982115887, -122.423418809148)
406 249556 4 11 1450 Franklin St 2 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.0832400005 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778)
413 249558 4 11 1450 Franklin St 4 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.42347688825899 (37.7881220384566, -122.423476888259)
516 188685 3 90 1300 Evans Ave 14 4 1 2   04/10/2017 01:01:00 PM 3 Width 3ft   6017863.857919999 2096944.2017700002 37.738810795988606 -122.38074156686301 (37.7388107959886, -122.380741566863)
576 240412 3 45 3420 Market St 1 4 1 2   04/19/1996 12:00:00 AM 7 Width 3ft   6000095.059769999 2103920.2632400002 37.7569687331323 -122.442678332141 (37.7569687331323, -122.442678332141)
586 237035 3 98 150 Octavia St 2 4 1 2   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918)
596 240413 3 45 3420 Market St 2 4 1 2   04/19/1996 12:00:00 AM 8 Width 3ft   6000107.95046 2103900.11575 37.756914147893795 -122.442632304847 (37.7569141478938, -122.442632304847)
622 237036 3 98 150 Octavia St 4 4 1 2   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.053180001 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022)
643 239154 3 98 150 Octavia St 6 4 1 2   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387848999 (37.773736235682, -122.42371387849)
652 237023 3 82 8 Octavia St 4 4 1 2   04/15/2017 01:44:00 PM 3 Width 6ft   6005765.01716 2109438.39176 37.7724417955802 -122.423461745458 (37.7724417955802, -122.423461745458)
661 237024 3 82 8 Octavia St 5 4 1 2   04/15/2017 01:48:00 PM 3 Width 6ft   6005763.84021 2109451.72322 37.772478334130994 -122.423466764586 (37.772478334131, -122.423466764586)
663 237022 3 82 8 Octavia St 3 4 1 2   04/15/2017 01:40:00 PM 3 Width 6ft   6005770.133230001 2109412.50366 37.772371001847 -122.423442207693 (37.772371001847, -122.423442207693)
665 239151 3 82 100 Octavia St 2 4 1 2   04/15/2017 01:58:00 PM 3 Width 4ft   6005731.03459 2109700.90805 37.7731606839629 -122.423597962203 (37.7731606839629, -122.423597962203)
666 237028 3 82 8 Octavia St 9 4 1 2   04/15/2017 01:55:00 PM 3 Width 6ft   6005756.39315 2109517.28856 37.7726579404383 -122.423497186858 (37.7726579404383, -122.423497186858)
715 246970 3 10 299 Noe St 2 4 1 2     9 Width 4ft   6002947.4073 2106634.57369 37.764583763244794 -122.43300776749099 (37.7645837632448, -122.433007767491)
719 246969 1 10 299 Noe St 1 4 1 1   09/06/2016 12:00:00 AM 9 Width 4ft Permit Number 778955 6002937.11929 2106633.84457 37.7645811776972 -122.433043298823 (37.7645811776972, -122.433043298823)
730 195047 1 15 360 06th St 2 4 1 2   03/26/2005 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.777673209496605 -122.404737337955 (37.7776732094966, -122.404737337955)
748 195045 3 15 312 06th St 1 4 1 2     10 Width 3ft   6010980.17572 2111476.79231 37.7783317443601 -122.40556550564501 (37.7783317443601, -122.405565505645)
761 195041 2 15 402 06th St 1 4 1 2     28 Width 3ft   6011480.36813 2111044.01847 37.777171403968296 -122.40380468436199 (37.7771714039683, -122.403804684362)
791 191798 3 114 2 Newhall St 3 4 1 2   11/12/2014 12:00:00 AM 6 Width 3ft Permit Number 774049 6018546.987380001 2097184.73725 37.7395089360924 -122.378396294176 (37.7395089360924, -122.378396294176)
792 199372 3 36 2 Newhall St 2 4 1 2   11/12/2014 12:00:00 AM 15 Width 3ft Permit Number 774049 6018530.30847 2097200.55685 37.7395514542225 -122.37845506126499 (37.7395514542225, -122.378455061265)
808 193091 3 21 1395 Fairfax Ave 1 4 1 2   01/27/2015 12:22:00 PM 6 Width 3ft   6016598.40823 2097419.6759099998 37.7400464320877 -122.38515006152201 (37.7400464320877, -122.385150061522)
827 191800 3 114 2 Newhall St 5 4 1 2   11/12/2014 12:00:00 AM 19 Width 4ft Permit Number 774049 6018580.4534 2097158.49779 37.739438732322704 -122.37827876085301 (37.7394387323227, -122.378278760853)
840 193039 3 21 1800 Evans Ave 10 4 1 2   05/12/2011 12:00:00 AM 5 Width 4ft   6014331.82546 2099544.27863 37.7457545046729 -122.39313565907699 (37.7457545046729, -122.393135659077)
1099 250070 3 70 399 Austin St 1 4 1 2     2 Width 3ft   6005393.47416 2115303.0126799997 37.788523627097 -122.425164323999 (37.788523627097, -122.425164323999)
1127 188687 3 134 1300 Evans Ave 30 4 1 2   03/18/2017 12:53:00 PM 3 Width 4ft   6017556.40659 2097171.27575 37.7394173230594 -122.381820390005 (37.7394173230594, -122.381820390005)
1132 188688 3 134 1300 Evans Ave 37 4 1 2   03/18/2017 02:16:00 PM 3 Width 4ft   6017441.41972 2097257.16832 37.739646816543996 -122.382223941884 (37.739646816544, -122.382223941884)
1134 188691 3 134 1300 Evans Ave 45 4 1 2   03/18/2017 02:26:00 PM 3 Width 3ft   6017107.93008 2097506.97635 37.740314314066296 -122.38339440233999 (37.7403143140663, -122.38339440234)
1139 188692 3 134 1300 Evans Ave 46 4 1 2   03/18/2017 02:33:00 PM 3 Width 3ft   6017090.76081 2097520.28707 37.7403499137184 -122.383454693803 (37.7403499137184, -122.383454693803)
1145 188690 3 134 1300 Evans Ave 44 4 1 2   03/18/2017 02:23:00 PM 3 Width 3ft   6017127.64655 2097493.15124 37.7402774427419 -122.383325267851 (37.7402774427419, -122.383325267851)
1158 190438 3 134 1350 Evans Ave 4 4 1 2   03/18/2017 11:59:00 AM 3 Width 3ft   6016891.21359 2097667.15217 37.740742144938395 -122.38415488076001 (37.7407421449384, -122.38415488076)
1165 249373 1 7 649 Jones St 1 4 1 1   06/22/1998 12:00:00 AM 21 Width 4ft Permit Number 39973 6008805.56783 2114728.1661400003 37.78713740130579 -122.4133182966 (37.7871374013058, -122.4133182966)
1167 190439 3 134 1350 Evans Ave 6 4 1 2   03/18/2017 11:54:00 AM 3 Width 3ft   6016857.78658 2097692.82931 37.740810800972206 -122.384272247659 (37.7408108009722, -122.384272247659)
1168 218199 3 15 819 Ulloa St 1 4 1 2     13 Width 3ft   5993346.67502 2098141.32486 37.740714236277 -122.46559677389799 (37.740714236277, -122.465596773898)
1173 190143 3 8 1200 Fairfax Ave 7 4 1 2   03/18/2017 10:47:00 AM 3 Width 4ft   6017523.521480001 2096815.65975 37.738439056714704 -122.381909364434 (37.7384390567147, -122.381909364434)
1334 250499 2 17 540 El Camino Del Mar 2 4 1 1   05/10/2017 12:00:00 AM 3 Width 3ft Permit Number 779924 5986884.24135 2115388.89729 37.7876964378791 -122.489208879795 (37.7876964378791, -122.489208879795)
1541 196583 2 9 375 07th St 5 4 1 1     7 Width 3ft   6010636.210390001 2110621.8756 37.7759651028325 -122.406695151275 (37.7759651028325, -122.406695151275)
1544 196581 3 9 375 07th St 3 4 1 2     10 Width 3ft   6010649.28152 2110608.88242 37.77593015789721 -122.40664901875 (37.7759301578972, -122.40664901875)
1554 196582 2 9 375 07th St 4 4 1 1     8 Width 3ft   6010641.65206 2110616.23142 37.7759499096844 -122.40667592917801 (37.7759499096844, -122.406675929178)
1969 198010 2 37 213 Clara St 1 4 1 1     1 Width 3ft Permit Number 779305 6011863.46506 2111836.2655700003 37.7793681257663 -122.40253514649099 (37.7793681257663, -122.402535146491)
2241 193105 1 21 1649 Palou Ave 1 4 1 1   10/28/1996 12:00:00 AM 10 Width 5ft   6014582.89152 2095437.7386599998 37.734492738953 -122.39198038730301 (37.734492738953, -122.391980387303)
2250 200335 1 85 750 Phelps St 7 4 1 15     4 Width 2ft   6015505.4551 2098329.2709 37.7424834725483 -122.388992567847 (37.7424834725483, -122.388992567847)
2256 200334 1 85 750 Phelps St 4 4 1 15   11/15/1992 12:00:00 AM 8 Width 3ft   6015528.91481 2098358.82009 37.742565908900204 -122.388913512973 (37.7425659089002, -122.388913512973)
2282 234424 2 153 360 Church St 1 4 1 1     6 Width 3ft Permit Number 780144 6004154.11162 2106813.1044400004 37.7651423384845 -122.428846830126 (37.7651423384845, -122.428846830126)
2381 201818 2 48 100 Friedell St 2 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021088.08179 2093322.4173400002 37.7290434795636 -122.369343396492 (37.7290434795636, -122.369343396492)
2409 201824 2 48 100 Friedell St 8 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021004.603680001 2093212.5880900002 37.728737329640495 -122.369624404053 (37.7287373296405, -122.369624404053)
2410 201817 2 48 100 Friedell St 1 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021101.98762 2093338.62944 37.7290887577236 -122.36929644199101 (37.7290887577236, -122.369296441991)
2438 201823 2 48 100 Friedell St 7 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021023.85438 2093233.10906 37.728794732485206 -122.369559269737 (37.7287947324852, -122.369559269737)
2475 213240 1 2 72 Majestic Ave 1 4 1 1   11/24/1982 12:00:00 AM 14 Width 3ft Permit Number 20046 5997197.846969999 2089560.74227 37.7173753740534 -122.451662146612 (37.7173753740534, -122.451662146612)
2514 246848 2 11 301 Broderick St 10 4 1 10     14 Width 3ft   6001221.8841699995 2109765.97896 37.773083798207296 -122.439200331843 (37.7730837982073, -122.439200331843)
2519 246843 2 11 301 Broderick St 5 4 1 10     9 Width 3ft   6001198.912769999 2109877.26909 37.7733880658265 -122.439287771129 (37.7733880658265, -122.439287771129)
2532 246847 2 11 301 Broderick St 9 4 1 10     9 Width 3ft   6001212.96216 2109784.10249 37.773133053181404 -122.43923249339198 (37.7731330531814, -122.439232493392)
2533 246849 2 11 301 Broderick St 11 4 1 10     9 Width 3ft   6001216.8657599995 2109748.1446700003 37.7730345441487 -122.439216412614 (37.7730345441487, -122.439216412614)
2535 246841 2 11 301 Broderick St 3 4 1 10     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449)
2546 246846 2 11 301 Broderick St 8 4 1 10     14 Width 3ft   6001207.38463 2109809.38993 37.773202168766105 -122.43925359959101 (37.7732021687661, -122.439253599591)
2552 246840 2 11 301 Broderick St 2 4 1 10     19 Width 3ft   6001188.51269 2109936.2184200003 37.7735493340682 -122.43932797261999 (37.7735493340682, -122.43932797262)
2553 246842 2 11 301 Broderick St 4 4 1 10     15 Width 4ft   6001208.43411 2109888.06605 37.7734182533891 -122.439255609578 (37.7734182533891, -122.439255609578)
2554 246844 2 11 301 Broderick St 6 4 1 10     17 Width 3ft   6001203.63374 2109838.69012 37.773282406297895 -122.439268674924 (37.7732824062979, -122.439268674924)
2565 191072 2 49 396 12th St 4 4 1 1     5 Width 3ft Permit Number 779704 6008614.31812 2108613.9778 37.770338555601505 -122.41354738542101 (37.7703385556015, -122.413547385421)
2946 228442 3 91 413 Haight St 1 4 1 2   04/08/2009 12:00:00 AM 5 Width 3ft   6004129.64861 2109389.34953 37.7722146987825 -122.429115146464 (37.7722146987825, -122.429115146464)
2970 228443 3 91 401 Haight St 1 4 1 2   04/08/2009 12:00:00 AM 5 Width 3ft   6004157.65728 2109393.74469 37.7722283522845 -122.42901857547301 (37.7722283522845, -122.429018575473)
2984 228440 3 91 451 Haight St 1 4 1 2   04/08/2008 12:00:00 AM 4 Width 3ft   6003980.50091 2109366.20592 37.7721427080557 -122.42962941028401 (37.7721427080557, -122.429629410284)
3025 228441 3 91 419 Haight St 1 4 1 2   04/08/2008 12:00:00 AM 6 Width 3ft   6004104.36681 2109385.12417 37.7722016657998 -122.429202297052 (37.7722016657998, -122.429202297052)
3206 189833 3 97 1570 Burke Ave 2 4 1 2   02/12/2016 12:00:00 AM 14 Width 3ft   6016585.78665 2098909.19771 37.7441356575455 -122.385297468507 (37.7441356575455, -122.385297468507)
3210 194747 1 26 1580 Burke Ave 2 4 1 1     3 Width 4ft   6016181.61808 2099214.241 37.74495087589921 -122.386716274933 (37.7449508758992, -122.386716274933)
3231 188482 3 97 1580 Burke Ave 3 4 1 2   03/30/1990 12:00:00 AM 9 Width 4ft   6016171.38717 2099220.37618 37.7449671554124 -122.386752079638 (37.7449671554124, -122.386752079638)
3247 188481 1 97 1570 Burke Ave 10 4 1 1   08/24/2017 12:00:00 AM 3 Width 3ft   6016299.33242 2099120.87091 37.744701017238796 -122.38630272799999 (37.7447010172388, -122.386302728)
3364 188226 1 61 1350 19th St 3 4 1 1   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013575.41694 2105253.06849 37.7613875637091 -122.396151246903 (37.7613875637091, -122.396151246903)
3371 188225 1 61 1350 19th St 2 4 1 1   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013591.2999599995 2105254.0413599997 37.7613911187249 -122.396096381957 (37.7613911187249, -122.396096381957)
3379 188227 1 61 1350 19th St 4 4 1 1   11/01/1996 12:00:00 AM 5 Width 3ft Permit Number 37286 6013561.10942 2105252.84027 37.7613861409778 -122.39620071499901 (37.7613861409778, -122.396200714999)
3621 249566 1 5 1201 Franklin St 1 4 1 1     16 Width 4ft   6005942.163819999 2114329.62673 37.7858819315591 -122.42319672154899 (37.7858819315591, -122.423196721549)
3630 246504 1 104 255 Duncan St 1 4 1 1   01/05/1989 12:00:00 AM 9 Width 3ft Permit Number 25818 6004850.160540001 2099861.56096 37.7460944007479 -122.425944484052 (37.7460944007479, -122.425944484052)
3873 228872 2 11 32 Church St 1 4 1 1   10/02/2017 12:00:00 AM 3 4x7 Permit Number 780415 6004066.01114 2108522.69035 37.7698314611737 -122.42927346400101 (37.7698314611737, -122.429273464001)
5171 247184 2 25 1 Buena Vista Ave East 1 4 1 1   11/09/2017 12:00:00 AM 3 Width 4ft Permit Number 780753 6001013.06071 2108893.70983 37.7706768805726 -122.439860124855 (37.7706768805726, -122.439860124855)
5187 247186 2 25 1 Buena Vista Ave East 3 4 1 1     10 Width 4ft Permit Number 780753 6000985.28448 2108903.00262 37.770700815109294 -122.439956869431 (37.7707008151093, -122.439956869431)
8599 96031 1 252 1116 Greenwich St 1 4 1 1   04/05/2011 12:00:00 AM 20   Permit Number 767346 6007512.843169999 2119899.46213 37.8012638333238 -122.418157616905 (37.8012638333238, -122.418157616905)
22286 188618 2 5 3601 03rd St 15 4 1 1     16 Width 3ft   6015989.5781 2098825.23782 37.7438721192948 -122.387353189223 (37.7438721192948, -122.387353189223)
22360 191245 2 48 1675 Jerrold Ave 1 4 1 1     12 Width 3ft   6014937.212180001 2097262.06336 37.7395216264201 -122.3908828304 (37.7395216264201, -122.3908828304)
22364 249565 2 5 1251 Franklin St 3 4 1 1     25 Width 4ft   6005937.376069999 2114355.05187 37.785951472517 -122.423215093814 (37.785951472517, -122.423215093814)
22855 188957 2 28 1708 La Salle Ave 1 4 1 1     10 Width 3ft   6014940.685740001 2096639.31184 37.73781187133179 -122.39082730983499 (37.7378118713318, -122.390827309835)
22878 211497 2 193 500 Junipero Serra Blvd 69 4 1 1     4 Width 0ft   5991316.04145 2093239.9376700001 37.7271389322076 -122.472260663898 (37.7271389322076, -122.472260663898)
22880 230389 2 90 51 13th St 4 4 1 1     6 Width 3ft   6008142.81587 2108281.73826 37.7693998171644 -122.41515479496701 (37.7693998171644, -122.415154794967)
22911 238577 2 237 133 Buchanan St 1 4 1 1     9 Width 3ft   6004747.18096 2108954.98025 37.771056963743 -122.426948105892 (37.771056963743, -122.426948105892)
23411 195158 2 15 1188 Rhode Island St 1 4 1 1     14 Width 4ft   6011916.5871 2102892.02207 37.7548122137394 -122.401722520004 (37.7548122137394, -122.401722520004)
23416 247236 2 5 1251 Haight St 1 4 1 1     26 Width 6ft   6000176.36555 2108836.62464 37.770472476353 -122.442750157415 (37.770472476353, -122.442750157415)
23424 197132 2 82 201 Newhall St 4 4 1 1     2 Width 3ft   6016788.78445 2098277.43468 37.742412193171795 -122.384551543811 (37.7424121931718, -122.384551543811)
23436 187515 2 11 299 Lauren Ct 1 4 1 1     5 Width 2ft   6012570.47183 2088125.85933 37.7143038745038 -122.398425150324 (37.7143038745038, -122.398425150324)
23455 194596 2 193 800 Wisconsin St 7 4 1 1     12 Width 3ft   6012720.64304 2103613.2936299997 37.7568375049672 -122.398992475934 (37.7568375049672, -122.398992475934)
23459 240288 2 180 3980 22nd St 2 4 1 1     20     6001954.916780001 2102957.6016 37.7544313427449 -122.43617736779 (37.7544313427449, -122.43617736779)
23467 205659 2 28 1598 10th Ave 7 4 1 1     3 Width 2ft   5993106.7424 2104692.3682 37.7586878807581 -122.466902491455 (37.7586878807581, -122.466902491455)
23483 234406 2 65 147 Valencia St 1 4 1 1     20 Width 8ft   6006058.10348 2108951.831 37.7711223543454 -122.422413351811 (37.7711223543454, -122.422413351811)
Powered by Datasette · Query took 2.577ms · Data source: data.sfgov.org