sf-trees

Data source: data.sfgov.org

Custom SQL query returning 42 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
69038 190440 3 44 1350 Evans Ave 7 4 1 2   03/30/2004 12:00:00 AM 4 Width 3ft   6016842.64833 2097703.08966 37.740838136776794 -122.384325304974 (37.7408381367768, -122.384325304974)
117769 115188 3 37 2300X Alemany Blvd 5 4 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
Powered by Datasette · Query took 65.719ms · Data source: data.sfgov.org