sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19435 16276 8 2 690 Monterey Blvd 1 1 1 1     18 3X3   5997552.36845 2094747.2906 37.7316367142582 -122.45081049312799 (37.7316367142582, -122.450810493128)
144968 17872 8 73 2148 Pine St 2 1 1 2 3 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.788333445178104 -122.43117780902399 (37.7883334451781, -122.431177809024)
18811 19154 8 26 64 Sanchez St 1 1 1 1   12/30/2014 12:00:00 AM 3 3x3 Permit Number 774356 6003450.274019999 2107953.58185 37.7682339504649 -122.431362651168 (37.7682339504649, -122.431362651168)
14802 24222 8 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.38288292190398 (37.7334154068844, -122.382882921904)
139876 31650 8 12 3632 Vicente St 1 1 1 1   08/07/2015 12:00:00 AM 3   Permit Number 35160 5981711.46236471 2097421.70961548 37.7380604052223 -122.505772893936 (37.7380604052223, -122.505772893936)
112863 32654 8 11 260 05th St 1 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011426.1069309 2112339.71009356 37.7807260408269 -122.40408360027 (37.7807260408269, -122.40408360027)
83581 43568 8 44 601 29TH ST 2 1 1 1   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
1138 44040 8 21 2504 Jackson St 1 1 1 1   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.7445400003 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121)
140477 70518 8 35 27 Edinburg St 1 1 1 1   06/25/1994 12:00:00 AM   3x3 Permit Number 775094 6004529.42153392 2093371.60291271 37.728256311969396 -122.426591501924 (37.7282563119694, -122.426591501924)
120424 72837 8 67 2624 21st St 1 1 1 1   05/06/2015 12:00:00 AM 3 3x3 Permit Number 770762 6010331.33933918 2104014.11752446 37.7578046465334 -122.407283867997 (37.7578046465334, -122.407283867997)
86995 85449 8 17 287 GUERRERO ST 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005798.0 2107491.2 37.7670971345308 -122.42320921716801 (37.7670971345308, -122.423209217168)
106507 85450 8 17 285 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006141.0 2107369.0 37.7667809533476 -122.42201414851601 (37.7667809533476, -122.422014148516)
95747 85451 8 17 281 GUERRERO ST 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005518.5 2107341.2 37.7666694929162 -122.424165297356 (37.7666694929162, -122.424165297356)
80666 85452 8 17 275 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138.0 2107427.0 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748)
140578 85453 8 17 271 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
107223 85454 8 17 269 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
105420 85455 8 17 265 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
97717 85456 8 17 265 Guerrero St 2 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
81723 85457 8 17 265 Guerrero St 3 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
126492 85458 8 17 265 Guerrero St 4 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
116308 85459 8 17 245x Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
108448 85460 8 17 245x Guerrero St 2 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
111923 85461 8 17 245x Guerrero St 3 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
97792 89263 8 2 1 Polk St 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 775142 6007496.395175 2110885.881534 37.7765138277066 -122.41757533494 (37.7765138277066, -122.41757533494)
12972 92206 8 44 443 Madrid St 1 1 1 1   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.7684400002 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576)
138606 94563 8 37 301X Oak St 3 21 1 1   09/15/2010 12:00:00 AM     Permit Number 53745 6005493.0 2110231.0 37.7746027492624 -122.42445906794902 (37.7746027492624, -122.424459067949)
25738 95912 8 12 858 34th Ave 1 1 1 1   03/17/2011 12:00:00 AM 4   Permit Number 767389 5985440.58134 2110021.2041 37.772873924382296 -122.49380788423099 (37.7728739243823, -122.493807884231)
175584 96402 8 12 2160 36th Ave 1 1 1 1   05/12/2011 12:00:00 AM 1 2x3   5985141.5215 2100472.7854 37.746639122425606 -122.494138462065 (37.7466391224256, -122.494138462065)
132132 97154 8 138 1079 Le Conte Ave 1 1 1 1   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174)
149702 97155 8 138 1079 Le Conte Ave 2 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.9517299999 37.719067249734294 -122.398087681509 (37.7190672497343, -122.398087681509)
73660 97156 8 138 1079 Le Conte Ave 3 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.39802290784401 (37.7190195469812, -122.398022907844)
72331 97157 8 138 1079 Le Conte Ave 4 1 1 1   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771)
181154 97158 8 138 1079 Le Conte Ave 5 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.39794361640101 (37.7189762599209, -122.397943616401)
29879 97159 8 138 1079 Le Conte Ave 6 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.6057400005 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286)
152399 98280 8 44 66 09th St 1 1 1 1   01/24/2012 12:00:00 AM 2   Permit Number 58649 6008148.55904 2110896.00071 37.776578287595 -122.41532002290899 (37.776578287595, -122.415320022909)
170162 98281 8 44 66 09th St 2 1 1 1   01/24/2012 12:00:00 AM 3   Permit Number 58649 6008165.69574 2110879.12634 37.776532917703705 -122.41525954711399 (37.7765329177037, -122.415259547114)
167151 98282 8 44 66 09th St 3 1 1 1   01/24/2012 12:00:00 AM 3   Permit Number 58649 6008179.30272 2110863.5043200003 37.776490788067896 -122.415211370411 (37.7764907880679, -122.415211370411)
82447 98285 8 246 300 Mangels Ave 1 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
81451 98286 8 246 300 Mangels Ave 2 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
78583 98287 8 246 300 Mangels Ave 3 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
97621 98306 8 18 155 Terrace Dr   1 1 1           5993776.0 2096639.0 37.7366139805049 -122.46400331489299 (37.7366139805049, -122.464003314893)
53719 98437 8 21 1840 Washington St 1 1 1 1   02/13/2012 12:00:00 AM 4 4x12 Permit Number 768068 6005870.33263 2116931.58044 37.7930221942694 -122.423630300016 (37.7930221942694, -122.423630300016)
97598 100059 8 11 260 05th St 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
77766 100060 8 11 260 05th St 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
71351 101919 8 15 1401X California St 1 1 1 1   12/07/2012 12:00:00 AM 9 3x3 Permit Number 769132 6007497.406219999 2116101.25633 37.7908340376155 -122.417941633898 (37.7908340376155, -122.417941633898)
154640 101920 8 15 1401X California St 3 1 1 1   12/07/2012 12:00:00 AM 13 3x3 Permit Number 769132 6007536.5156 2116104.21807 37.79084437080729 -122.41780652694901 (37.7908443708073, -122.417806526949)
159429 101921 8 15 1401X California St 5 1 1 1   12/07/2012 12:00:00 AM 3 3x3 Permit Number 769132 6007574.87115 2116111.37594 37.7908661829645 -122.41767432572901 (37.7908661829645, -122.417674325729)
185806 101922 8 15 1401X California St 6 1 1 1   12/07/2012 12:00:00 AM 4 3x3 Permit Number 769132 6007599.52227 2116115.67925 37.7908793859256 -122.417589338874 (37.7908793859256, -122.417589338874)
115319 101923 8 127 1401X California St 7 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.790726135860204 -122.418266664095 (37.7907261358602, -122.418266664095)
144056 101924 8 147 1099X Hyde St 1 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
143550 101925 8 147 1099X Hyde St 2 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
81444 101926 8 147 1099X Hyde St 3 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
64007 102480 8 21 1456 Chestnut St 1 1 1 1   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.9115400002 37.80203068792579 -122.427302455863 (37.8020306879258, -122.427302455863)
84595 102523 8 62 2192 Funston Ave 1 1 1 1   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.46938861272601 (37.7472806432819, -122.469388612726)
62948 103091 8 250 1540 Jones St 1 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041)
33388 103092 8 250 1540 Jones St 2 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.6375599997 37.7955740826282 -122.41486325634399 (37.7955740826282, -122.414863256344)
42795 103093 8 250 1540 Jones St 3 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008420.39916 2117820.52002 37.79560661561779 -122.41486984389401 (37.7956066156178, -122.414869843894)
160143 103094 8 250 1540 Jones St 4 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008418.50881 2117836.67229 37.7956508595435 -122.414877528601 (37.7956508595435, -122.414877528601)
149863 103095 8 250 1540 Jones St 5 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008416.42419 2117851.09099 37.7956903325975 -122.414885762773 (37.7956903325975, -122.414885762773)
176988 103096 8 250 1540 Jones St 6 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008414.12252 2117870.41106 37.795743251405504 -122.414895095058 (37.7957432514055, -122.414895095058)
83777 103097 8 478 1199X Pacific Ave 1 1 1 1   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.41497276422399 (37.7958257402639, -122.414972764224)
137822 103130 8 21 418 28th Ave 1 4 1 1     1     5987189.392469999 2113118.1924900003 37.781479539688505 -122.487986220863 (37.7814795396885, -122.487986220863)
80836 103465 8 8 890X Sansome St 1 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
77847 103466 8 8 890X Sansome St 2 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
116665 103467 8 8 890X Sansome St 3 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
148004 103468 8 8 799X Battery St 1 1 1 1     2     6012421.85953 2118740.3114 37.798356169556605 -122.401088663417 (37.7983561695566, -122.401088663417)
126578 103469 8 8 799X Battery St 2 1 1 1           6012272.7 2118721.6 37.798296470544706 -122.401603488036 (37.7982964705447, -122.401603488036)
88908 107533 8 17 130 MATEO ST 1 1 1 1   02/05/2015 12:00:00 AM 3 3x3 Permit Number 774373 6003821.3 2096389.2 37.7365018950939 -122.429254591879 (37.7365018950939, -122.429254591879)
79684 107964 8 15 2401x SCOTT ST 1 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
8965 107967 8 15 2405x Scott St 4 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001240.6892800005 2116684.58018 37.792081580751294 -122.439631370586 (37.7920815807513, -122.439631370586)
110700 107977 8 15 2750 JACKSON ST 7 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.4 2116670.4 37.7920344322485 -122.440129594684 (37.7920344322485, -122.440129594684)
78687 108260 8 62 45 Belcher St 1 1 1 1   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.5446900004 37.768614322037294 -122.430103370918 (37.7686143220373, -122.430103370918)
14083 108447 8 87 696 Pennsylvania Ave 1 1 1 1     12 3x3   6014378.0974 2104018.3558400003 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138)
187247 108450 8 87 696 Pennsylvania Ave 2 1 1 1     6 3x3   6014379.30863 2103997.39375 37.757984449027795 -122.39328302830799 (37.7579844490278, -122.393283028308)
27410 108451 8 87 696 Pennsylvania Ave 3 1 1 1     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387)
184427 108452 8 87 696 Pennsylvania Ave 4 1 1 1     8 3x3   6014381.40925 2103952.1831400003 37.757860427147 -122.39327259977199 (37.757860427147, -122.393272599772)
136446 108453 8 87 696 Pennsylvania Ave 5 1 1 1     11 3x3   6014383.1993 2103935.66602 37.7578151741454 -122.39326525319099 (37.7578151741454, -122.393265253191)
182307 108454 8 265 696 Pennsylvania Ave 6 1 1 1     8 3x3   6014383.50929 2103916.35065 37.757762155526 -122.39326282951099 (37.757762155526, -122.393262829511)
50489 108536 8 11 1036X Mission St 2 1 1 1       3x3   6009831.243980001 2112235.16984 37.780349758914795 -122.40959364419399 (37.7803497589148, -122.409593644194)
87984 108821 8 120 101x FREMONT ST 1 1 1 1   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
80528 108822 8 120 101x FREMONT ST 2 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
145351 108823 8 120 101x FREMONT ST 3 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
125094 109115 8 44 2036x 15TH ST 1 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
126955 109116 8 44 2036x 15TH ST 2 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
100550 109117 8 44 2036x 15TH ST 3 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
140060 109118 8 44 2036x 15TH ST 4 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
18918 109119 8 44 2036x 15TH ST 5 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
93411 109120 8 44 2036x 15TH ST 6 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
125268 109121 8 44 2036x 15TH ST 7 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
104643 109122 8 44 2036x 15TH ST 8 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
82999 109123 8 44 2036x 15TH ST 9 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
93779 109124 8 44 2036x 15TH ST 10 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
51328 109935 8 11 260 05th St 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302.0 2112245.5 37.780460426865396 -122.404506314811 (37.7804604268654, -122.404506314811)
124592 109936 8 11 260 05th St 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302.0 2112245.5 37.780460426865396 -122.404506314811 (37.7804604268654, -122.404506314811)
144711 109941 8 147 400x CLEMENTINA ST 1 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93713 109942 8 147 400x CLEMENTINA ST 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
100892 109943 8 147 400x CLEMENTINA ST 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
92212 109944 8 147 400x CLEMENTINA ST 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93248 109945 8 147 400x CLEMENTINA ST 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
104982 109946 8 147 400x CLEMENTINA ST 6 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
113160 109947 8 147 400x CLEMENTINA ST 7 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
Powered by Datasette · Query took 3.676ms · Data source: data.sfgov.org