sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
15232 95293 3 9 4618 03rd St 1 1 1 2     6 3x3   6015049.0735 2096005.3469 37.7360771463621 -122.390408274564 (37.7360771463621, -122.390408274564)
15264 105277 4 9 64 Townsend St 6 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015510.23316 2112419.2864900003 37.781171886114706 -122.38996007562 (37.7811718861147, -122.38996007562)
15265 22253 1 9 4546 03rd St 2 1 1 1   06/19/1993 12:00:00 AM 6 3x3   6015116.5558 2096227.8276 37.736691776177295 -122.390190497304 (37.7366917761773, -122.390190497304)
15273 22220 1 9 4301 03rd St 2 1 1 1     6 3X3   6015388.4053 2096841.333 37.7383914115765 -122.389293415685 (37.7383914115765, -122.389293415685)
15371 22310 1 9 5048 03rd St 2 1 1 1     3 3x3   6014681.6111 2094780.648 37.7326939819519 -122.391593153167 (37.7326939819519, -122.391593153167)
15378 22297 1 9 4947 03rd St 1 1 1 1   02/01/2001 12:00:00 AM 3 3x3   6014819.7772 2094987.0918 37.7332685029776 -122.391129899656 (37.7332685029776, -122.391129899656)
15386 22255 3 9 4614 03rd St 1 1 1 2   01/19/1996 12:00:00 AM 6 3x3   6015052.7639 2096021.1630000002 37.7361207788628 -122.390396619988 (37.7361207788628, -122.390396619988)
15407 101368 2 9 555 Minna St 1 1 1 1   10/17/2012 12:00:00 AM 1 3x5 Permit Number 769424 6009870.786169999 2111925.3371200003 37.77950124702579 -122.40943497635901 (37.7795012470258, -122.409434976359)
15412 117198 2 9 78 Ringold St 1 1 1 1     11 2.5x2.5   6009460.131469999 2109802.88553 37.773650476322295 -122.410705680637 (37.7736504763223, -122.410705680637)
15417 22246 1 9 4445 03rd St 3 1 1 1     3 3X3   6015268.8942 2096480.9105 37.7373951386403 -122.38968146396002 (37.7373951386403, -122.38968146396)
15430 98183 2 9 1166 Howard St 2 1 1 1     3 3x3   6009361.09189 2110925.30032 37.7767268106175 -122.411127574195 (37.7767268106175, -122.411127574195)
15443 22230 1 9 4343 03rd St 4 1 1 1     6 3X3   6015369.9826 2096775.2005 37.7382088038746 -122.38935249607401 (37.7382088038746, -122.389352496074)
15465 22290 1 9 4850 03rd St 1 1 1 1     3     6014853.4802 2095344.2309 37.7342510046252 -122.391038331468 (37.7342510046252, -122.391038331468)
15475 22302 1 9 5005 03rd St 1 1 1 1     3 3X3   6014777.2871 2094864.0702 37.732928352623 -122.391268204226 (37.732928352623, -122.391268204226)
15533 22271 1 9 4720 03rd St 1 1 1 1   03/03/1995 12:00:00 AM 6 3x3   6014966.8294 2095722.7646 37.735296670354295 -122.390672887136 (37.7352966703543, -122.390672887136)
15635 22233 1 9 4400X 03rd St 1 1 1 1     6 3x3   6015237.9536 2096632.7792 37.737810423344996 -122.389799045633 (37.737810423345, -122.389799045633)
15682 92867 1 9 4800 03rd St 2 1 1 1   12/14/2009 12:00:00 AM 3 3x3 Permit Number 53082 6014898.2926 2095492.3757 37.7346602666874 -122.390893749601 (37.7346602666874, -122.390893749601)
15701 95056 1 9 5100 03rd St 2 1 1 1     3 3x3   6014630.0146 2094610.4713 37.7322238471755 -122.39175964179701 (37.7322238471755, -122.391759641797)
15716 22235 1 9 4410 03rd St 1 1 1 1     6 3x3   6015225.6719 2096592.1549 37.737698196233794 -122.38983867300301 (37.7376981962338, -122.389838673003)
15741 84839 1 9 13X Harriet St 3 1 1 1   05/04/2007 12:00:00 AM 3 3x3 Permit No. 49303 6010429.20805 2111813.3182099997 37.7792249420059 -122.40749524841999 (37.7792249420059, -122.40749524842)
15816 84838 1 9 13X Harriet St 2 1 1 1   05/04/2007 12:00:00 AM 3 3x3 Permit No. 49303 6010446.83177 2111795.3152099997 37.7791764964284 -122.407433010849 (37.7791764964284, -122.407433010849)
15851 95291 3 9 4500 03rd St 1 1 1 2     6 3x3   6015158.7323 2096375.4452 37.73709944325871 -122.390054982777 (37.7370994432587, -122.390054982777)
15862 114993 2 9 96X Tehama St 2 1 1 1     2 3x3   6013204.76311 2114263.56563 37.78610772254971 -122.398065333368 (37.7861077225497, -122.398065333368)
15870 22286 1 9 4820 03rd St 1 1 1 1   12/13/1999 12:00:00 AM 3 3X3   6014883.0037 2095444.9272 37.7345291344217 -122.390943293827 (37.7345291344217, -122.390943293827)
15991 22288 3 9 4830 03rd St 1 1 1 2   01/05/1998 12:00:00 AM 3 3X3   6014865.0787 2095383.7713 37.7343602181244 -122.391000994081 (37.7343602181244, -122.391000994081)
16077 22245 1 9 4445 03rd St 2 1 1 1     3 3X3   6015261.8086 2096457.764 37.7373311901678 -122.389704346197 (37.7373311901678, -122.389704346197)
16153 98184 2 9 1166 Howard St 3 1 1 1   10/28/2016 12:00:00 AM 3 3x3 Permit Number 777050 6009341.871809999 2110905.80719 37.7766722091935 -122.41119268511001 (37.7766722091935, -122.41119268511)
16166 95061 1 9 5019 03rd St 1 1 1 1     3 3x3   6014762.2432 2094820.2467 37.732807187274105 -122.391317152917 (37.7328071872741, -122.391317152917)
16184 22254 1 9 4602 03rd St 1 1 1 1     6 3x3   6015071.7433 2096082.3189 37.7362897533029 -122.39033527146499 (37.7362897533029, -122.390335271465)
16246 85552 1 9 320 12th St 1 1 1 1   05/29/2007 12:00:00 AM 6     6008325.98929 2108714.16712 37.7705974578492 -122.414551808542 (37.7705974578492, -122.414551808542)
16287 22251 3 9 4522 03rd St 1 1 1 2   03/31/1995 12:00:00 AM 6 3x3   6015135.007999999 2096296.8916 37.7368824352823 -122.390131522919 (37.7368824352823, -122.390131522919)
16289 22301 1 9 5012X 03rd St 1 1 1 1     3 3x3   6014715.8795 2094899.7965 37.733023041622204 -122.391483004656 (37.7330230416222, -122.391483004656)
16328 22259 1 9 4636 03rd St 1 1 1 1   01/09/1996 12:00:00 AM 6 3x3   6015032.7301 2095944.7182 37.7359097656913 -122.390460545797 (37.7359097656913, -122.390460545797)
16373 114992 2 9 96X Tehama St 1 1 1 1     2 3x3   6013259.23301 2114318.42588 37.786261389694296 -122.397880730433 (37.7862613896943, -122.397880730433)
16436 22232 1 9 4342 03rd St 1 1 1 1   10/31/1997 12:00:00 AM 4 3x3   6015306.4481 2096851.4891 37.7384147541361 -122.38957749525 (37.7384147541361, -122.38957749525)
16459 102415 2 9 286 06th St 2 1 1 1     3 3x3   6010900.79062 2111559.68279 37.7785549030328 -122.405845970014 (37.7785549030328, -122.405845970014)
16491 95057 1 9 5112 03rd St 1 1 1 1     3 3x3   6014622.8598 2094584.2372 37.7321514164802 -122.391782544083 (37.7321514164802, -122.391782544083)
16546 24302 1 9 15 Young Ct 1 1 1 1   11/27/2007 12:00:00 AM 3 3X3   6016323.370209999 2096080.15892 37.7363531709501 -122.386007687413 (37.7363531709501, -122.386007687413)
16548 22320 1 9 5130 03rd St 1 1 1 1     3 3x3   6014589.6697 2094475.5245 37.731851070935704 -122.391889691503 (37.7318510709357, -122.391889691503)
16596 24297 1 9 3 Young Ct 1 1 1 1     12 3X3   6016221.017419999 2096090.1073 37.736374822132504 -122.386362260423 (37.7363748221325, -122.386362260423)
16627 24444 1 9 4512X 03rd St 1 1 1 1   03/31/1995 12:00:00 AM 6 3x3   6015145.0249 2096325.3607 37.7369611611957 -122.390098878017 (37.7369611611957, -122.390098878017)
16647 22313 1 9 5114 03rd St 1 1 1 1   01/18/1995 12:00:00 AM 3 3x3   6014616.1025 2094561.5804 37.7320888303862 -122.391804322113 (37.7320888303862, -122.391804322113)
16800 91697 1 9 1699 Howard St 2 1 1 1   03/01/2007 12:00:00 AM 3 3x3   6007471.37046 2108630.96251 37.770320947775396 -122.41750205429399 (37.7703209477754, -122.417502054294)
16823 22249 3 9 4517 03rd St 3 1 1 2   02/17/1995 12:00:00 AM 6 3X3   6015186.4487 2096240.2877 37.7367298654987 -122.38994971533998 (37.7367298654987, -122.38994971534)
16867 84834 1 9 1011 Howard St 2 1 1 1   05/04/2007 12:00:00 AM 5   Permit No. 49303 6010439.60599 2111868.75172 37.7793777314294 -122.40746318667 (37.7793777314294, -122.40746318667)
16929 16335 3 9 862X Monterey Blvd 5 11 1 2   04/22/2008 12:00:00 AM 3 5   5996588.55754 2094717.49275 37.7314996764704 -122.454140408353 (37.7314996764704, -122.454140408353)
17060 16342 3 9 890X Monterey Blvd 4 11 1 2     6 5   5996198.48565 2094691.8474400002 37.731406885306704 -122.455487100866 (37.7314068853067, -122.455487100866)
17099 16338 3 9 862X Monterey Blvd 8 11 1 2   04/22/2008 12:00:00 AM 3 5   5996505.10477 2094713.35848 37.7314835390346 -122.454428620411 (37.7314835390346, -122.454428620411)
17126 16113 3 9 300X Monterey Blvd 11 11 1 2   04/24/1998 12:00:00 AM 3 5   5999657.47743 2094677.0013700002 37.7315639977654 -122.443527690574 (37.7315639977654, -122.443527690574)
17206 16009 3 9 100X Monterey Blvd 3 11 1 2   04/06/1998 12:00:00 AM 3 4   6001288.3370900005 2094653.38984 37.731592040430705 -122.43788781177099 (37.7315920404307, -122.437887811771)
17219 15306 3 9 1650 Mission St 3 1 1 2   01/23/2012 12:00:00 AM 12 4X4   6006908.0519 2109118.2179 37.7716271230049 -122.41948515010701 (37.7716271230049, -122.419485150107)
17393 16115 3 9 300X Monterey Blvd 13 11 1 2   04/24/1998 12:00:00 AM 3 5   5999569.73094 2094680.4197799999 37.7315683792686 -122.44383129178101 (37.7315683792686, -122.443831291781)
17414 24350 1 9 69 Duboce Ave 1 1 1 1   06/08/2002 12:00:00 AM 3 3X3   6006243.86106 2108474.23182 37.769821458035295 -122.42173687996001 (37.7698214580353, -122.42173687996)
17448 5159 3 9 280 Divisadero St 1 1 1 2   04/04/2014 12:00:00 AM 3 3x3   6001840.8605 2109274.7601 37.7717702359874 -122.43702404315799 (37.7717702359874, -122.437024043158)
17507 16015 3 9 100X Monterey Blvd 9 11 1 2     12 4   6000956.04768 2094656.76286 37.731582400588294 -122.43903684047899 (37.7315824005883, -122.439036840479)
17516 16016 3 9 100X Monterey Blvd 10 11 1 2     3 4   6000925.306059999 2094658.03828 37.7315841533775 -122.43914321141001 (37.7315841533775, -122.43914321141)
17529 27492 1 9 1360 Valencia St 1 1 1 1   08/02/2016 12:00:00 AM 3 3X3   6006409.07404 2101649.59564 37.7510919153811 -122.420680862742 (37.7510919153811, -122.420680862742)
17572 5174 3 9 350 Divisadero St 1 1 1 1 4 11/28/2006 12:00:00 AM 3 3x4   6001785.2321 2109677.0482 37.7728716568906 -122.437245274575 (37.7728716568906, -122.437245274575)
17616 25607 1 9 1225 Cortland Ave 1 1 1 1   04/07/2000 12:00:00 AM 3 3X3   6008935.12695 2097525.18951 37.7399092531173 -122.411654094874 (37.7399092531173, -122.411654094874)
17980 51193 1 9 2550& VICENTE 24th Ave 6 1 1 1   07/28/2004 12:00:00 AM     Permit Number 47565 5988957.29016327 2097975.36056036 37.740004392032496 -122.48076127761298 (37.7400043920325, -122.480761277613)
18069 15305 3 9 1650 Mission St 2 1 1 2     6 3X3   6006919.2009 2109139.6581 37.7716866206556 -122.41944810628799 (37.7716866206556, -122.419448106288)
18176 16013 3 9 100X Monterey Blvd 7 11 1 2     3 4   6001154.39221 2094654.56847 37.731587658935396 -122.43835096892201 (37.7315876589354, -122.438350968922)
18181 7048 3 9 1301 Fell St 2 1 1 2     3     6001113.3036400005 2110008.37363 37.7737431739315 -122.43959330500601 (37.7737431739315, -122.439593305006)
18219 5158 3 9 275 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001773.6501 2109268.6052 37.771749515715605 -122.437256087151 (37.7717495157156, -122.437256087151)
18231 25584 3 9 1100 Cortland Ave 1 1 1 2     3 3X3   6008703.17196 2097328.50441 37.739356184437796 -122.412442202248 (37.7393561844378, -122.412442202248)
18343 16048 3 9 200X Monterey Blvd 6 11 1 2   01/02/1991 12:00:00 AM 6 4   6000504.30929 2094664.8510599998 37.7315788950381 -122.440599164328 (37.7315788950381, -122.440599164328)
18421 32094 1 9 4056 19th St 1 1 1 1 1 08/09/1995 12:00:00 AM 16 4x4 Permit Number 35466 6002634.735280001 2104754.49716 37.759403787880004 -122.43395481658399 (37.75940378788, -122.433954816584)
18570 119857 3 9 401 Octavia St Frontage West 4 1 1 2       4x4   6005602.0 2110303.0 37.774806598562 -122.42408713638201 (37.774806598562, -122.424087136382)
18577 5154 3 9 259 Divisadero St 1 1 1 1 4   3 3X3   6001780.9624 2109220.4101 37.771617599631604 -122.43722734206499 (37.7716175996316, -122.437227342065)
18660 2548 3 9 26 Burnside Ave 1 1 1 2   05/24/2012 12:00:00 AM 3 3x3   6001209.41963 2095931.6881 37.7350974637785 -122.438252186489 (37.7350974637785, -122.438252186489)
18671 25608 1 9 1201 Cortland Ave 1 1 1 1   01/22/2005 12:00:00 AM 3 3X3   6008878.530040001 2097513.7909999997 37.7398747802954 -122.41184897886801 (37.7398747802954, -122.411848978868)
18764 16103 3 9 300X Monterey Blvd 1 11 1 2   02/18/2012 12:00:00 AM 2 5   6000043.907980001 2094672.48858 37.7315736376005 -122.44219140500799 (37.7315736376005, -122.442191405008)
18798 24364 1 9 94X Duboce Ave 1 1 1 1   10/16/2008 12:00:00 AM 3 3X3   6006127.193940001 2108531.26259 37.769971471229994 -122.42214448149099 (37.76997147123, -122.422144481491)
18929 16187 3 9 401X Monterey Blvd 4 11 1 2     3 5   5999317.5789 2094684.3827099998 37.731564874619 -122.44470331222901 (37.731564874619, -122.444703312229)
19005 16334 3 9 862X Monterey Blvd 4 11 1 2   04/22/2008 12:00:00 AM 3 5   5996621.72685 2094716.0654099998 37.731497659285104 -122.45402563328001 (37.7314976592851, -122.45402563328)
19058 93046 1 9 155 26th Ave 2 1 1 1     10 3x3   5987682.5 2114946.6 37.7865285787391 -122.48641460847601 (37.7865285787391, -122.486414608476)
19198 10243 3 9 80X Haight St 2 1 1 2   05/15/2000 12:00:00 AM 8 3X3   6005750.7633 2109671.0107 37.7730797066295 -122.423527591987 (37.7730797066295, -122.423527591987)
19414 16111 3 9 300X Monterey Blvd 9 11 1 2     12 5   5999725.13349 2094678.46865 37.7315718848268 -122.443293896493 (37.7315718848268, -122.443293896493)
19527 24348 3 9 85 Duboce Ave 2 1 1 2     12 2x2   6006216.94974 2108473.11084 37.7698168624935 -122.421829886054 (37.7698168624935, -122.421829886054)
19610 16184 3 9 401X Monterey Blvd 1 11 1 2     3 5   5999406.634869999 2094682.7033 37.7315653449635 -122.444395308802 (37.7315653449635, -122.444395308802)
19681 100150 2 9 4007 18th St 1 1 1 1     3 3x3   6002942.0 2105314.0 37.7609574805046 -122.432932117926 (37.7609574805046, -122.432932117926)
19693 45729 1 9 235 02nd St 17 1 1 1   10/05/2001 12:00:00 AM     Permit Number 44392 6013350.5591251 2114341.46161867 37.7863297261158 -122.397566379799 (37.7863297261158, -122.397566379799)
19708 16012 3 9 100X Monterey Blvd 6 11 1 2   04/06/1998 12:00:00 AM 3 4   6001201.17189 2094653.91848 37.7315885348835 -122.43818919619301 (37.7315885348835, -122.438189196193)
19772 23092 1 9 1370 Valencia St 2 1 1 1   02/01/1992 12:00:00 AM 3 3X3   6006411.6799099995 2101600.51519 37.7509572985639 -122.420668367552 (37.7509572985639, -122.420668367552)
19868 25582 1 9 1050 Cortland Ave 1 1 1 1   01/22/2005 12:00:00 AM 6 3X3   6008562.72198 2097229.54928 37.7390765924125 -122.412920823236 (37.7390765924125, -122.412920823236)
19907 16336 3 9 862X Monterey Blvd 6 11 1 2   04/22/2008 12:00:00 AM 3 5   5996559.751619999 2094715.89038 37.7314936249086 -122.454239879686 (37.7314936249086, -122.454239879686)
20041 16019 1 9 101 Monterey Blvd 1 1 1 1   01/01/2003 12:00:00 AM 3 3x3   6001362.879269999 2094609.69043 37.7314762904984 -122.43762697692301 (37.7314762904984, -122.437626976923)
20046 5155 3 9 265 Divisadero St 1 1 1 1 4 12/17/2001 12:00:00 AM 3 3X3   6001777.3063 2109242.3472 37.7716776256193 -122.43724155970399 (37.7716776256193, -122.437241559704)
20084 32102 1 9 184 Hartford St 1 1 1 1   08/09/1995 12:00:00 AM 16 4x4 Permit Number 35474 6002676.86971 2104831.86113 37.759618601743796 -122.43381462484601 (37.7596186017438, -122.433814624846)
20107 4293 3 9 4339 Cesar Chavez St 1 1 1 2     12 3X3   6001695.46709 2100282.2377 37.747070687663204 -122.436883097284 (37.7470706876632, -122.436883097284)
20187 23091 1 9 1370 Valencia St 1 1 1 1   02/01/1992 12:00:00 AM 3 3X3   6006409.75471 2101616.74712 37.751001759225105 -122.420676177262 (37.7510017592251, -122.420676177262)
20214 16047 3 9 200X Monterey Blvd 5 11 1 2     6     6000544.66834 2094663.6950599998 37.731578019092396 -122.440459552683 (37.7315780190924, -122.440459552683)
20252 2549 3 9 30 Burnside Ave 1 1 1 2   05/24/2012 12:00:00 AM 3 3x3   6001196.7389 2095889.2850400002 37.7349803135805 -122.438292991438 (37.7349803135805, -122.438292991438)
20271 23093 1 9 1370 Valencia St 3 1 1 1   02/01/1992 12:00:00 AM 3 3X3   6006411.8269 2101585.66917 37.7509165430738 -122.420666805454 (37.7509165430738, -122.420666805454)
20322 2547 3 9 20 Burnside Ave 1 1 1 2   03/28/2014 12:00:00 AM 3 3x3   6001218.37586 2095964.9326099998 37.7351892548769 -122.43822360245001 (37.7351892548769, -122.43822360245)
20354 27346 3 9 100X Monterey Blvd 13 11 1 2     12 4   6000818.28486 2094659.29899 37.731581524667504 -122.43951329411301 (37.7315815246675, -122.439513294113)
20419 16017 3 9 100X Monterey Blvd 11 11 1 2     12 4   6000892.30856 2094658.72213 37.7315841533843 -122.43925733896002 (37.7315841533843, -122.43925733896)
20443 16112 3 9 300X Monterey Blvd 10 11 1 2     12 5   5999693.39114 2094677.85118 37.7315683792706 -122.443403591302 (37.7315683792706, -122.443403591302)
20489 96596 3 9 3342 Anza St 4 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5988207.53014 2111924.69302 37.7782618665825 -122.48437643702499 (37.7782618665825, -122.484376437025)
20512 16106 3 9 300X Monterey Blvd 4 11 1 2     12 5   5999928.25024 2094674.5701 37.731572760761104 -122.44259140457599 (37.7315727607611, -122.442591404576)
20548 16117 3 9 300X Monterey Blvd 15 11 1 2     3 5   5999494.77273 2094682.2963900003 37.7315692561142 -122.444090570848 (37.7315692561142, -122.444090570848)
Powered by Datasette · Query took 2.661ms · Data source: data.sfgov.org