sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
46130 132162 2 71 165 Francisco St 11 7 1 1     13     6010559.73859 2121313.26508 37.8053168133783 -122.40771371440901 (37.8053168133783, -122.407713714409)
185848 132161 2 71 165 Francisco St 10 7 1 1     15     6010552.8238 2121311.7929599998 37.8053123842132 -122.407737540175 (37.8053123842132, -122.407737540175)
65528 132163 2 71 150 Lombard St 12 2 1 1     16 Width 5ft   6011528.08163 2120803.5748799997 37.8039714887622 -122.40432672370399 (37.8039714887622, -122.404326723704)
39232 132164 2 71 150 Lombard St 13 2 1 1     16 Width 5ft   6011515.19186 2120799.8495099996 37.8039605395195 -122.404371067467 (37.8039605395195, -122.404371067467)
151346 132160 2 71 1141 Chestnut St 5 7 1 1     20     6006382.37262 2120397.93248 37.802568811663605 -122.422104980572 (37.8025688116636, -122.422104980572)
109599 98161 6 71 600 Front St   7 1 1   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.39944985704099 (37.7974274520849, -122.399449857041)
145855 122584 2 71 2500X Lyon St 4 11 1 1     11 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
144047 108298 1 71 10X Greenwich St 1 7 1 1   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830.0 2116175.0 37.791335193350896 -122.399496166675 (37.7913351933509, -122.399496166675)
86909 120542 2 71 2450 California St 1 7 1 6 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
166247 120262 2 71 100 24th Ave 6 17 1 1     26     5988353.58713 2115180.43805 37.7872097252822 -122.484109995805 (37.7872097252822, -122.484109995805)
77480 8344 3 71 1300 Geary Blvd 10 11 1 2   06/08/1994 12:00:00 AM 12 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
80466 8349 3 71 1300 Geary Blvd 15 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
80484 8339 3 71 1300 Geary Blvd 5 11 1 2   06/08/1994 12:00:00 AM 18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
88546 8341 3 71 1300 Geary Blvd 7 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
92710 8340 3 71 1300 Geary Blvd 6 11 1 2   06/08/1994 12:00:00 AM 24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
108857 8348 3 71 1300 Geary Blvd 14 11 1 2   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
115283 8342 3 71 1300 Geary Blvd 8 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
117891 8351 3 71 1300 Geary Blvd 17 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
179339 139329 3 71 1350x GEARY BLVD 3 11 1 2     13 Width 0ft   6005196.3246 2114113.3931 37.785246088934706 -122.425761723999 (37.7852460889347, -122.425761723999)
62236 139330 3 71 1350x GEARY BLVD 4 11 1 2     31 Width 0ft   6005126.2471 2114101.4827 37.7852094256692 -122.42600332266599 (37.7852094256692, -122.426003322666)
131295 139356 3 71 1350x GEARY BLVD 5 11 1 2     24 Width 0ft   6005063.0942 2114090.4032 37.785175434752105 -122.42622102328698 (37.7851754347521, -122.426221023287)
176294 139358 3 71 1350x GEARY BLVD 7 11 1 2     19 Width 0ft   6004934.0187 2114075.446 37.7851270694756 -122.426666519258 (37.7851270694756, -122.426666519258)
60960 139214 3 71 1350x GEARY BLVD 8 11 1 2     29 Width 0ft   6004809.3749 2114055.503 37.78506526335679 -122.427096327106 (37.7850652633568, -122.427096327106)
90526 120629 3 71 1500 Geary Blvd 6 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
70800 139359 3 71 1350x GEARY BLVD 9 11 1 2     28 Width 0ft   6004685.2851 2114039.9918 37.7850156556233 -122.42752453341801 (37.7850156556233, -122.427524533418)
5271 8390 3 71 1500 Geary Blvd 1 11 1 2     36 8   6004488.7034 2114010.5767 37.784923768316396 -122.428202546761 (37.7849237683164, -122.428202546761)
5273 8391 3 71 1500 Geary Blvd 2 11 1 2     36 8   6004438.3798 2114005.2394 37.784906265949004 -122.428376269712 (37.784906265949, -122.428376269712)
5280 8392 3 71 1500 Geary Blvd 3 11 1 2     36 8   6004378.143999999 2113996.8521 37.784879827842296 -122.428584068109 (37.7848798278423, -122.428584068109)
4472 8393 3 71 1500 Geary Blvd 4 11 1 2     36 8   6004320.9581 2113985.4149 37.7848451877241 -122.428781097193 (37.7848451877241, -122.428781097193)
6395 8394 3 71 1500 Geary Blvd 5 11 1 2     36 8   6004234.0356 2113977.7901 37.784819331933 -122.429081276927 (37.784819331933, -122.429081276927)
5837 8395 3 71 1500 Geary Blvd 6 11 1 2   06/09/1994 12:00:00 AM 6 8   6004192.8617 2113973.9777 37.7848065332396 -122.429223453232 (37.7848065332396, -122.429223453232)
61501 120626 3 71 1500 Geary Blvd 3 11 1 2           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401)
111709 120624 3 71 1500 Geary Blvd 1 11 1 2           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401)
117256 120627 3 71 1500 Geary Blvd 4 11 1 2           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401)
121508 120628 3 71 1500 Geary Blvd 5 11 1 2           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401)
79301 120625 3 71 1500 Geary Blvd 2 11 1 2           6004349.0 2113949.0 37.784746788576705 -122.428681484586 (37.7847467885767, -122.428681484586)
6405 8469 3 71 1900 Geary Blvd 6 11 1 2     48 8   6002244.0904 2113695.2 37.7839305664786 -122.435945599699 (37.7839305664786, -122.435945599699)
3479 8471 3 71 1900 Geary Blvd 8 11 1 2   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.783879157642104 -122.43635890448 (37.7838791576421, -122.43635890448)
1548 8472 3 71 1900 Geary Blvd 9 11 1 2     6 8   6002074.2026 2113678.2789 37.7838744530021 -122.436532136471 (37.7838744530021, -122.436532136471)
129015 8536 3 71 2100 Geary Blvd 7 11 1 2   06/10/1994 12:00:00 AM 6 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651002 (37.7837972495813, -122.43786449651)
140538 8537 3 71 2100 Geary Blvd 8 11 1 2   06/10/1994 12:00:00 AM 3 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651002 (37.7837972495813, -122.43786449651)
6701 8474 3 71 1900 Geary Blvd 11 11 1 2     6 8   6001879.2717 2113651.8819999998 37.7837908949329 -122.437204633286 (37.7837908949329, -122.437204633286)
7244 8475 3 71 1900 Geary Blvd 12 11 1 2   06/03/1994 12:00:00 AM 6 8   6001831.8926 2113645.1136 37.7837696172579 -122.43736806210899 (37.7837696172579, -122.437368062109)
8796 8530 3 71 2100X Geary Blvd 1 11 1 2   06/10/1994 12:00:00 AM 15     6001630.1932 2113615.3325 37.783676377346794 -122.438063730933 (37.7836763773468, -122.438063730933)
6954 8532 3 71 2100 Geary Blvd 3 11 1 2   06/10/1994 12:00:00 AM 6 6   6001535.4351 2113580.6442 37.783575742772705 -122.438389071264 (37.7835757427727, -122.438389071264)
88368 8563 3 71 2200 Geary Blvd 4 1 1 2     36 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
89362 8562 3 71 2200 Geary Blvd 3 1 1 2     48 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
99151 8561 3 71 2200 Geary Blvd 2 1 1 2   06/01/1994 12:00:00 AM 6 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
100876 8560 3 71 2200 Geary Blvd 1 1 1 2   06/01/1994 12:00:00 AM 6 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
7257 8535 3 71 2100 Geary Blvd 6 11 1 2     18 6   6001300.5704 2113502.1304 37.7833468021346 -122.439195981768 (37.7833468021346, -122.439195981768)
5263 8574 3 71 2200 Geary Blvd 1 11 1 2     6 6   6001134.4053 2113480.9790000003 37.783279269060294 -122.43976932905301 (37.7832792690603, -122.439769329053)
7070 8575 3 71 2200 Geary Blvd 2 11 1 2     48 6   6001093.7947 2113474.2106 37.7832583731226 -122.439909339764 (37.7832583731226, -122.439909339764)
1116 8576 3 71 2200 Geary Blvd 3 11 1 2     48 6   6001010.5429 2113459.32 37.7832127479531 -122.440196288881 (37.7832127479531, -122.440196288881)
5311 8577 3 71 2200 Geary Blvd 4 11 1 2     36 6   6000958.4259 2113453.9053 37.783194913277796 -122.440376203878 (37.7831949132778, -122.440376203878)
8091 8578 3 71 2200 Geary Blvd 5 11 1 2     18 6   6000905.6321 2113444.4294 37.7831658887746 -122.44055816885599 (37.7831658887746, -122.440558168856)
6394 8581 3 71 2200 Geary Blvd 8 11 1 2     24 6   6000715.1007 2113420.9091 37.7830904567466 -122.441215640748 (37.7830904567466, -122.441215640748)
8635 8582 3 71 2200 Geary Blvd 9 11 1 2     18 6   6000649.7853 2113412.1102 37.7830625764785 -122.441440973241 (37.7830625764785, -122.441440973241)
7700 8586 3 71 2200 Geary Blvd 13 11 1 2     24 6   6000400.7068 2113377.2527 37.782952673809795 -122.442300177437 (37.7829526738098, -122.442300177437)
96458 116067 3 71 4150X CLEMENT ST 5 7 1 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777818 5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
117254 24789 3 71 7700 Geary Blvd 1 11 1 2     6 4X4   5983110.07731 2112460.67779 37.779435386439204 -122.50204978501301 (37.7794353864392, -122.502049785013)
9686 173637 2 71 1155 Market St 99 1 1 1       3x3   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
128707 27300 3 71 7900X Geary Blvd 1 1 1 2   06/10/1999 12:00:00 AM 6 5x5   5982547.933540001 2112415.51016 37.7792783288562 -122.50399109880101 (37.7792783288562, -122.503991098801)
125546 27294 1 71 7800X Geary Blvd 1 11 1 11   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.77924621575129 -122.503283404585 (37.7792462157513, -122.503283404585)
92056 27295 1 71 7800X Geary Blvd 2 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982729.47953 2112398.50568 37.779242313567295 -122.50336180684499 (37.7792423135673, -122.503361806845)
114112 27296 1 71 7800X Geary Blvd 3 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.7930900003 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232)
111288 27297 1 71 7800X Geary Blvd 4 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982680.863919999 2112396.64212 37.7792343387449 -122.50352984750401 (37.7792343387449, -122.503529847504)
143978 27298 1 71 7800X Geary Blvd 5 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413)
86601 27299 1 71 7800X Geary Blvd 6 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.779227117259296 -122.503705073784 (37.7792271172593, -122.503705073784)
161403 118538 3 71 7900x Geary Blvd 1 11 1 2     11 Width 4ft   5982472.235830001 2112389.87128 37.7792034803758 -122.504251064408 (37.7792034803758, -122.504251064408)
280 194427 2 71 905 Minna St 3 1 1 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
65779 194426 2 71 132 Kissling St 5 2 1 1     19 Width 5ft   6007946.83693 2109121.1094299997 37.77169351738029 -122.415892125715 (37.7716935173803, -122.415892125715)
175007 194425 2 71 132 Kissling St 4 2 1 1     16 Width 5ft   6007938.01013 2109107.31213 37.771655137004 -122.41592168104799 (37.771655137004, -122.415921681048)
47480 194424 2 71 132 Kissling St 3 2 1 1     23 Width 5ft   6007931.050980001 2109095.29996 37.77162176316789 -122.41594490245599 (37.7716217631679, -122.415944902456)
155635 194423 2 71 132 Kissling St 2 2 1 1     17 Width 5ft   6007917.867000001 2109077.33792 37.771571702413 -122.41598923453002 (37.771571702413, -122.41598923453)
4769 194422 2 71 199X Kissling St 1 2 1 1     52 Width 5ft   6007901.53326 2109054.5781799997 37.771508291196 -122.41604412194401 (37.771508291196, -122.416044121944)
159854 247525 2 71 1101 Waller St 6 17 1 1     2     6000029.935269999 2108491.2793400004 37.7695158962756 -122.443231851395 (37.7695158962756, -122.443231851395)
64531 184348 2 71 1251 Sunset Blvd 14 9 1 1     1 Width 0ft   5984683.9949 2106431.9954 37.762974680362206 -122.496160108596 (37.7629746803622, -122.496160108596)
185501 184347 2 71 1251 Sunset Blvd 15 9 1 1     1 Width 0ft   5984658.9334 2106421.3632 37.7629440193232 -122.49624600189699 (37.7629440193232, -122.496246001897)
55771 186733 2 71 1250 Sunset Blvd 2 9 1 1     2 Width 0ft   5984855.8629 2106397.0571 37.7628888152225 -122.49556310804701 (37.7628888152225, -122.495563108047)
174927 181557 2 71 1300 Sunset Blvd 35 9 1 1     2 Width 0ft   5984875.8554 2106073.5142 37.76200162774529 -122.495470098326 (37.7620016277453, -122.495470098326)
160510 234472 2 71 4810 17th St 1 9 1 1     28 Width 2ft   5998175.60392 2105685.14055 37.7617050378737 -122.44944366388701 (37.7617050378737, -122.449443663887)
187908 181540 2 71 1300 Sunset Blvd 18 9 1 1     2 Width 0ft   5984863.0454 2105869.1102 37.7614396414651 -122.49549932614799 (37.7614396414651, -122.495499326148)
174392 181538 2 71 1300 Sunset Blvd 16 9 1 1     1 Width 0ft   5984897.5768 2105857.4141 37.761409549185 -122.495379035532 (37.761409549185, -122.495379035532)
70507 184801 2 71 1301 Sunset Blvd 62 9 1 1     3 Width 0ft   5984720.8276 2105758.3732 37.7611272600096 -122.49598302148998 (37.7611272600096, -122.49598302149)
136877 181519 2 71 1400 Sunset Blvd 79 9 1 1     2 Width 0ft   5984899.8047 2105606.7824 37.76072151501489 -122.49535284581002 (37.7607215150149, -122.49535284581)
166214 181513 2 71 1400 Sunset Blvd 73 9 1 1     2 Width 0ft   5984909.8299 2105563.3396 37.7606028201969 -122.49531496977501 (37.7606028201969, -122.495314969775)
69894 186685 2 71 1401 Sunset Blvd 42 9 1 1     2 Width 0ft   5984734.6622 2105357.4834 37.7600273389586 -122.495905599978 (37.7600273389586, -122.495905599978)
177368 181473 2 71 1400 Sunset Blvd 33 9 1 1     2 Width 0ft   5984918.4628 2105275.6702 37.759813465723795 -122.49526389807 (37.7598134657238, -122.49526389807)
44224 186691 2 71 1401 Sunset Blvd 48 9 1 1     10 Width 0ft   5984728.0673 2105259.502 37.7597579231437 -122.49592118002701 (37.7597579231437, -122.495921180027)
69007 186699 2 71 1401 Sunset Blvd 56 9 1 1     1 Width 0ft   5984730.9983 2105175.3386 37.759527005597604 -122.495904834542 (37.7595270055976, -122.495904834542)
126787 23612 1 71 890X Vermont St 1 1 1 3     12 30X30PL   6011290.8652502 2104244.5269478 37.7584909549369 -122.403981624636 (37.7584909549369, -122.403981624636)
123604 23614 3 71 910X Vermont St 1 1 1 2     18 30X30PL   6011300.2113585 2104101.3880723 37.7580984495586 -122.403939228694 (37.7580984495586, -122.403939228694)
2179 252925 3 71 700 Sanchez St 2 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
54231 181385 2 71 1500 Sunset Blvd 18 9 1 1     1 Width 0ft   5984917.5854 2104501.8427 37.7576886993488 -122.495209866912 (37.7576886993488, -122.495209866912)
170555 181384 2 71 1500 Sunset Blvd 17 9 1 1     2 Width 0ft   5984945.4334 2104486.2478 37.75764751046 -122.49511240858 (37.75764751046, -122.49511240858)
64562 181379 2 71 1500 Sunset Blvd 12 9 1 1     1 Width 0ft   5984933.4588 2104463.134 37.7575833453331 -122.495152116603 (37.7575833453331, -122.495152116603)
177987 186620 2 71 1501 Sunset Blvd 91 9 1 1     1 Width 0ft   5984755.0749 2104355.2681 37.7572767304033 -122.495761074715 (37.7572767304033, -122.495761074715)
74141 186421 2 71 1601 Sunset Blvd 9 9 1 1     1 Width 0ft   5984727.9626 2104153.7573 37.756721849906 -122.495839973726 (37.756721849906, -122.495839973726)
170936 186435 2 71 1601 Sunset Blvd 23 9 1 1     1 Width 0ft   5984740.5243 2104016.8346 37.7563466338471 -122.495786431621 (37.7563466338471, -122.495786431621)
36257 186440 2 71 1601 Sunset Blvd 28 9 1 1     1 Width 0ft   5984767.7413 2103960.7256 37.7561941679911 -122.495688168642 (37.7561941679911, -122.495688168642)
70815 186456 2 71 1601 Sunset Blvd 44 9 1 1     1 Width 0ft   5984777.372 2103875.7247 37.755961343063895 -122.49564859346701 (37.7559613430639, -122.495648593467)
Powered by Datasette · Query took 8.883ms · Data source: data.sfgov.org