sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
97104 50378 1 36 1620 Montgomery St 2 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
128144 50377 1 36 1620 Montgomery St 1 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
7023 23544 3 36 2800X Van Ness Ave 2 11 1 2     24 9   6005656.2038 2120054.10262 37.80158375904121 -122.424593418169 (37.8015837590412, -122.424593418169)
116970 34459 1 36 1960 Jones St 1 1 1 1 1 12/21/2015 12:00:00 AM     Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
120244 34458 1 36 1960 Jones St 3 1 1 1 1 12/21/2015 12:00:00 AM   3x3 Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
125997 34460 1 36 1960 Jones St 2 1 1 1 1 12/21/2015 12:00:00 AM   3x3 Permit Number 38200 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
7523 87408 3 36 2400X Van Ness Ave 2 11 1 2   04/18/2008 12:00:00 AM 3 3x3   6005843.02152 2118712.53051 37.7979106921903 -122.42385149366501 (37.7979106921903, -122.423851493665)
8547 23445 3 36 2100X Van Ness Ave 4 11 1 2     30 9   6005972.56611 2117769.9625 37.7953299508697 -122.423336192004 (37.7953299508697, -122.423336192004)
7761 23444 3 36 2100X Van Ness Ave 3 11 1 2     36 9   6005977.75981 2117720.35574 37.795194036322705 -122.423314692816 (37.7951940363227, -122.423314692816)
6470 110846 2 36 2776 Broadway 1 1 1 1     20 3x3   6000368.55091 2117170.43785 37.793365941237894 -122.44268387196999 (37.7933659412379, -122.44268387197)
52323 126606 2 36 3388 Washington St 1 1 1 1     8 Width 2ft   5998604.48648 2115920.6274200003 37.7898335742166 -122.448697575531 (37.7898335742166, -122.448697575531)
109130 119808 4 36 1634 Pine St 2 1 1 1   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6006048.0 2115627.0 37.789450169199796 -122.422922798032 (37.7894501691998, -122.422922798032)
22805 17745 3 36 1600X Pine St 2 1 1 2     18 3X3   6006152.6648 2115617.75127 37.7894306797229 -122.422560011429 (37.7894306797229, -122.422560011429)
133083 250094 2 36 1700 Gough St 8 4 1 1     16 Width 4ft   6005324.767440001 2115623.21527 37.789398941767004 -122.425424835102 (37.789398941767, -122.425424835102)
169546 250104 2 36 1634 Pine St 1 4 1 1     2 Width 4ft   6006039.94152 2115602.86884 37.789383456327705 -122.422948963731 (37.7893834563277, -122.422948963731)
183607 250103 2 36 1634 Pine St 2 4 1 1     2 Width 4ft   6006023.8446 2115600.71368 37.7893766304877 -122.423004504073 (37.7893766304877, -122.423004504073)
139546 17753 1 36 1634 Pine St 3 1 1 1     18 3X3   6006028.796019999 2115599.444 37.7893734236606 -122.422987282423 (37.7893734236606, -122.422987282423)
63679 250102 2 36 1634 Pine St 3 4 1 1     16 Width 4ft   6006004.13239 2115596.49895 37.7893639455439 -122.42307240646099 (37.7893639455439, -122.423072406461)
88515 17754 3 36 1634 Pine St 4 1 1 2     18 3X3   6006002.61013 2115594.52588 37.789358442083 -122.423077533013 (37.789358442083, -122.423077533013)
9377 17756 1 36 1634 Pine St 6 1 1 1     18 3X3   6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971)
90620 116853 4 36 1634 Pine St 1 1 1 1   08/01/2016 12:00:00 AM 3 3X3 Permit Number 773331 6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971)
159517 250101 2 36 1634 Pine St 4 4 1 1     13 Width 4ft   6005978.51572 2115593.66659 37.78935472300171 -122.42316083590299 (37.7893547230017, -122.423160835903)
9298 17755 1 36 1634 Pine St 5 1 1 1     18 3X3   6005983.055346799 2115593.0882202997 37.789353391125104 -122.42314508816901 (37.7893533911251, -122.423145088169)
23295 9894 3 36 1700 Gough St 6 1 1 2   10/15/1997 12:00:00 AM 23 3X3   6005329.1496 2115601.42673 37.7893393634754 -122.425408122112 (37.7893393634754, -122.425408122112)
26804 250105 2 36 1688 Pine St 1 4 1 1     18 Width 4ft   6005949.70174 2115586.76552 37.7893341482864 -122.423260038317 (37.7893341482864, -122.423260038317)
40055 250106 2 36 1688 Pine St 2 4 1 1     16 Width 4ft   6005930.7358800005 2115585.60481 37.7893298908963 -122.42332557552601 (37.7893298908963, -122.423325575526)
95123 17757 4 36 1634 Pine St 7 1 1 2   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6005917.49192 2115584.99362 37.7893274652545 -122.42337135467699 (37.7893274652545, -122.423371354677)
9504 17758 1 36 1634 Pine St 8 1 1 1     18 3x3   6005894.5926 2115584.1297299997 37.7893238007876 -122.423450522313 (37.7893238007876, -122.423450522313)
35112 250107 2 36 1688 Pine St 3 4 1 1     2 Width 4ft   6005911.45005 2115583.3816299997 37.7893226981327 -122.423392144226 (37.7893226981327, -122.423392144226)
130217 250108 2 36 1688 Pine St 4 4 1 1     20 Width 4ft   6005895.20899 2115581.5118400003 37.7893166475034 -122.423448203486 (37.7893166475034, -122.423448203486)
158273 250109 2 36 1688 Pine St 5 4 1 1     20 Width 4ft   6005867.157869999 2115579.68143 37.7893100383746 -122.42354512700899 (37.7893100383746, -122.423545127009)
9564 17759 1 36 1634 Pine St 9 1 1 1     18 3x3   6005845.8328233 2115574.0220236 37.7892932953595 -122.42361850671999 (37.7892932953595, -122.42361850672)
80357 17764 3 36 1700 Pine St 4 1 1 2     18 3X3   6005780.4714382 2115564.9404688 37.789264670055 -122.423844003631 (37.789264670055, -122.423844003631)
117458 17765 3 36 1700 Pine St 5 1 1 2     24 3X3   6005780.4714382 2115564.9404688 37.789264670055 -122.423844003631 (37.789264670055, -122.423844003631)
22410 9892 3 36 1700 Gough St 4 1 1 2     18 3X3   6005332.72699 2115570.2247599997 37.7892538927886 -122.42539352339199 (37.7892538927886, -122.425393523392)
23186 17762 3 36 1700 Pine St 2 1 1 2     23     6005688.226009999 2115553.43335 37.7892278664309 -122.424162343438 (37.7892278664309, -122.424162343438)
22450 17763 3 36 1700 Pine St 3 1 1 2     18 3X3   6005669.54525 2115550.54053 37.7892188686951 -122.42422677084998 (37.7892188686951, -122.42422677085)
188187 250125 2 36 1730 Pine St 1 4 1 1     25 Width 4ft   6005649.1110000005 2115549.12657 37.7892138324921 -122.424297370338 (37.7892138324921, -122.424297370338)
22570 9891 3 36 1700 Gough St 3 1 1 2     24 3X3   6005334.61917 2115551.7772 37.7892033473078 -122.425385663344 (37.7892033473078, -122.425385663344)
1843 9890 3 36 1700 Gough St 2 1 1 2     24 3X3   6005344.337040001 2115550.48459 37.7892003471598 -122.42535194865299 (37.7892003471598, -122.425351948653)
22500 17776 3 36 1762 Pine St 2 1 1 2     18 3X3   6005516.07608 2115531.08967 37.7891567948058 -122.424756371721 (37.7891567948058, -122.424756371721)
22653 17778 3 36 1770 Pine St 2 1 1 2     18 3X3   6005458.75733 2115520.73995 37.7891251395545 -122.424953950985 (37.7891251395545, -122.424953950985)
22379 17784 1 36 1798X Pine St 1 1 1 1     12 3x3   6005418.97388 2115516.65721 37.7891116821071 -122.42509130621599 (37.7891116821071, -122.425091306216)
37030 250127 2 36 1798 Pine St 4 4 1 1     22 Width 5ft   6005361.6989 2115505.86135 37.789078803778295 -122.425288702018 (37.7890788037783, -122.425288702018)
22519 17782 3 36 1791 Pine St 3 1 1 2     24 3x3   6005428.2033400005 2115468.32597 37.788979497959296 -122.425055933202 (37.7889794979593, -122.425055933202)
24203 137837 2 36 1800X Pine St 1 1 1 1     21 Width 0ft   6005085.0 2115443.0 37.7888905662133 -122.42624156812799 (37.7888905662133, -122.426241568128)
92028 17812 3 36 1900X Pine St 5 1 1 2     18 3X3   6004830.0574482 2115432.8862429 37.7888483829176 -122.427122914168 (37.7888483829176, -122.427122914168)
140472 17811 3 36 1900X Pine St 4 1 1 2     24 3X3   6004830.0574482 2115432.8862429 37.7888483829176 -122.427122914168 (37.7888483829176, -122.427122914168)
178608 137847 2 36 1900 Pine St 1 1 1 1     16 Width 0ft   6004787.7852 2115427.8819 37.7888322517036 -122.427268813718 (37.7888322517036, -122.427268813718)
184969 137848 2 36 1900 Pine St 2 1 1 1     17 Width 0ft   6004770.9565 2115424.5161 37.7888220583291 -122.42732679883301 (37.7888220583291, -122.427326798833)
34797 137849 2 36 1900 Pine St 4 1 1 1     20 Width 0ft   6004722.1533 2115420.5894 37.7888085164114 -122.42749537127199 (37.7888085164114, -122.427495371272)
171664 137851 2 36 1900 Pine St 5 1 1 1     21 Width 0ft   6004700.2761 2115415.5408 37.7887934168266 -122.427570703503 (37.7887934168266, -122.427570703503)
1153 17806 3 36 1881 Pine St 1 1 1 2     24 3x3   6004903.5356 2115394.9801 37.7887484569995 -122.42686598915199 (37.7887484569995, -122.426865989152)
6636 2588 3 36 1710 Bush St 1 1 1 2   07/12/1999 12:00:00 AM 18 3   6005206.687000001 2115142.0135 37.788071009916 -122.42579911500499 (37.788071009916, -122.425799115005)
7947 2629 1 36 1872 Bush St 1 1 1 1     12 3X3   6004578.2934 2115053.5876 37.787792683911 -122.427966943787 (37.787792683911, -122.427966943787)
5622 87285 1 36 1820 Webster St 1 8 1 1     24 3x3 Permit Number 50302 6003460.507999999 2115059.4384 37.7877454479518 -122.43183468665801 (37.7877454479518, -122.431834686658)
63071 138599 2 36 2630 Pine St 1 1 1 1     27 Width 0ft   6001313.0958 2114947.1478 37.7873151619105 -122.43925625600001 (37.7873151619105, -122.439256256)
61033 138601 2 36 2650 Pine St 3 1 1 1     24 Width 0ft   6001240.9537 2114939.1951 37.7872892203341 -122.439505281612 (37.7872892203341, -122.439505281612)
94012 17996 3 36 2650X Pine St 4 1 1 2     18 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
113234 17995 3 36 2650X Pine St 3 1 1 2     24 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
141075 17993 3 36 2650X Pine St 1 1 1 2     24 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
67905 138602 2 36 2660 Pine St 4 1 1 1     21 Width 0ft   6001218.2318 2114936.9229 37.7872816882761 -122.43958373144699 (37.7872816882761, -122.439583731447)
31839 108738 2 36 22 22nd Ave 3 1 1 1     19 5x6   5988982.34798 2115051.76356 37.786893008658296 -122.481925214884 (37.7868930086583, -122.481925214884)
53672 108737 2 36 22 22nd Ave 2 1 1 1     13 5x6   5988982.16462 2115033.23873 37.786842134064706 -122.481924491754 (37.7868421340647, -122.481924491754)
139042 108739 2 36 22 22ND AVE 4 1 1 1       5x6   5989006.7 2115022.6 37.786814349999105 -122.48183882646299 (37.7868143499991, -122.481838826463)
98034 106401 2 36 22 22nd Ave 1 1 1 1     15 5x6   5988976.53234 2115004.21174 37.786762106623705 -122.481941850779 (37.7867621066237, -122.481941850779)
60209 124039 2 36 737 Lake St 2 1 1 1     18 Width 6ft   5993203.99509 2114811.08925 37.7864767964616 -122.467301904185 (37.7864767964616, -122.467301904185)
101721 18107 3 36 3067 Pine St 1 1 1 2     28 3x3   5999321.271546599 2114616.8679369 37.7862947536085 -122.446123757059 (37.7862947536085, -122.446123757059)
2560 138642 3 36 3059 PINE ST 1 1 1 2     22 Width 0ft   5999277.8969 2114611.151 37.7862765793233 -122.446273410182 (37.7862765793233, -122.446273410182)
165437 138649 2 36 3073 Pine St 1 1 1 1     18 Width 0ft   5999235.7723 2114604.2128 37.786255122975504 -122.44641865052 (37.7862551229755, -122.44641865052)
97378 18108 3 36 3071X PINE ST 1 1 1 2     18 3X3   5999273.0 2114556.0 37.7861248694209 -122.44628638333499 (37.7861248694209, -122.446286383335)
185697 138647 2 36 600 PRESIDIO AVE 4 1 1 1     9 Width 0ft   5999215.4534 2114556.1413 37.786121970664894 -122.44648548868099 (37.7861219706649, -122.446485488681)
151612 138646 2 36 600 PRESIDIO AVE 3 1 1 1     12 Width 0ft   5999217.4357 2114545.2385 37.786092147648894 -122.446477845811 (37.7860921476489, -122.446477845811)
57256 138645 2 36 600 PRESIDIO AVE 2 1 1 1     15 Width 0ft   5999221.4004 2114525.9107 37.786039305012004 -122.446462738067 (37.786039305012, -122.446462738067)
124001 99698 6 36 1750 Divisadero St 1 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
140716 99699 6 36 1750 Divisadero St 2 8 1 1           6001124.0 2114376.0 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979)
148918 62209 1 36 227 24th Ave 1 1 1 1 1 10/12/1985 12:00:00 AM 16   Permit Number 22331 5988338.57879 2114482.10714 37.7852914335725 -122.48411069019699 (37.7852914335725, -122.484110690197)
28860 51570 1 36 227 24th Ave 1 1 1 1 1 02/04/2005 12:00:00 AM 17   Permit Number 47867 5988337.51894 2114460.53389 37.7852321378524 -122.48411277430401 (37.7852321378524, -122.484112774304)
52315 120312 2 36 160 23rd Ave 1 1 1 1     21 Width 4ft   5988698.92527 2114284.33233 37.784769373123005 -122.482849516634 (37.784769373123, -122.482849516634)
84641 118343 2 36 162 23rd Ave 1 1 1 1       3x3   5988772.0 2114277.0 37.784753492132104 -122.48259616764 (37.7847534921321, -122.48259616764)
140133 12381 3 36 1435 Laguna St 2 1 1 2     18 3x3   6004345.46385 2113763.0093400003 37.7842359045501 -122.42868045552099 (37.7842359045501, -122.428680455521)
171543 140328 2 36 1435 LAGUNA ST 3 1 1 1     20 Width 0ft   6004571.2725 2113745.3183 37.784200106361105 -122.427897976235 (37.7842001063611, -122.427897976235)
39832 141203 2 36 1813 ELLIS ST 3 1 1 1     24 Width 0ft   6002244.2596 2112941.8731 37.7818621312845 -122.435891094436 (37.7818621312845, -122.435891094436)
31502 141200 2 36 1825 ELLIS ST 1 1 1 1     16 Width 0ft   6002183.0052 2112931.3819999998 37.7818298455487 -122.436102254923 (37.7818298455487, -122.436102254923)
92387 6315 3 36 1829 Ellis St 2 1 1 2     12 4X4   6002129.29202 2112924.84308 37.781808839600394 -122.43628760910102 (37.7818088396004, -122.436287609101)
163721 141298 2 36 1835 ELLIS ST 10 1 1 1     18 Width 0ft   6002114.3056 2112921.2293 37.7817980655656 -122.436339196325 (37.7817980655656, -122.436339196325)
53025 141296 2 36 1835 ELLIS ST 8 1 1 1     26 Width 0ft   6002071.6645 2112917.5067 37.7817854213105 -122.436486447843 (37.7817854213105, -122.436486447843)
82431 6309 3 36 1807 Ellis St 2 1 1 2     18 4X4   6002200.5977300005 2112898.1085099997 37.7817394844201 -122.43603901136999 (37.7817394844201, -122.43603901137)
32861 141292 2 36 1835 ELLIS ST 4 1 1 1     23 Width 0ft   6001970.8148 2112901.9393 37.7817369459936 -122.436834225266 (37.7817369459936, -122.436834225266)
188514 141287 2 36 1855 ELLIS ST 1 1 1 1     27 Width 0ft   6001856.4282 2112885.6951 37.7816858418255 -122.43722878495701 (37.7816858418255, -122.437228784957)
77690 6329 3 36 1895X Ellis St 6 1 1 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
79295 6333 3 36 1895X Ellis St 10 1 1 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
79767 6335 3 36 1895X Ellis St 12 1 1 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
96484 6324 3 36 1895X Ellis St 1 1 1 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
123002 48545 1 36 501X Mariposa St 3 1 1 1   08/22/2002 12:00:00 AM   3x3 Permit Number 45866 6013823.0 2112518.0 37.7813492145506 -122.39580402612101 (37.7813492145506, -122.395804026121)
166171 123313 2 36 401 05th Ave 17 1 1 1     18 Width 4ft   5994324.87447 2112727.37957 37.7808201355721 -122.46327271312599 (37.7808201355721, -122.463272713126)
156619 123312 2 36 401 05th Ave 16 1 1 1     16 Width 4ft   5994326.95545 2112691.62436 37.7807220812689 -122.46326291878201 (37.7807220812689, -122.463262918782)
50686 139597 2 36 1122 BRODERICK ST 1 1 1 1     23 Width 0ft   6000883.0425 2112553.4494 37.7807181991979 -122.440572393516 (37.7807181991979, -122.440572393516)
111141 2204 1 36 1120 Broderick St 2 1 1 1     18 5x9   6000904.16856 2112542.81493 37.7806902026292 -122.440498545519 (37.7806902026292, -122.440498545519)
136459 123281 2 36 400 06th Ave 12 1 1 1     19 Width 3ft   5994069.81611 2112666.40035 37.7806380059293 -122.464150649226 (37.7806380059293, -122.464150649226)
70359 139620 2 36 1895 Eddy St 1 1 1 1     30 Width 0ft   6001417.4951 2112473.8357 37.7805300194093 -122.43871776158998 (37.7805300194093, -122.43871776159)
Powered by Datasette · Query took 5.319ms · Data source: data.sfgov.org