sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
101156 111313 8 17 3400x Wawona St 1 5 1 1   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.6213900002 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423)
112158 111315 8 17 3400x Wawona St 3 5 1 1   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.6213900002 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423)
113824 111316 8 17 3400x Wawona St 4 5 1 1   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.6213900002 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423)
117182 111314 8 17 3400x Wawona St 2 5 1 1   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.6213900002 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423)
79719 112585 8 48 3400x WAWONA ST 6 5 1 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
82449 112583 8 48 3400x WAWONA ST 1 5 1 1     1 4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
108178 112584 8 48 3400x WAWONA ST 5 5 1 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
113705 112586 8 48 3400x WAWONA ST 7 5 1 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
81380 112795 8 88 1235 40th Ave 1 1 1 1   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.763735444165796 -122.49984801640899 (37.7637354441658, -122.499848016409)
114269 111632 8 17 1758 36th Ave 1 1 1 1   06/15/2015 12:00:00 AM 3 3x3 Permit Number 774682 5985071.0 2103231.6 37.7542099449347 -122.49458566251002 (37.7542099449347, -122.49458566251)
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)
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)
140107 110044 8 12 550 33rd Ave 1 1 1 1   03/19/2015 12:00:00 AM 3 3x3   5985672.92923 2112141.09949 37.7787081437008 -122.49316037495899 (37.7787081437008, -122.493160374959)
108682 111636 8 44 2625 35TH AVE 1 1 1 1   06/16/2015 12:00:00 AM 3 3x3   5985486.0 2097347.0 37.738076708209796 -122.492717127165 (37.7380767082098, -122.492717127165)
137822 103130 8 21 418 28th Ave 1 4 1 1     1     5987189.392469999 2113118.1924900003 37.781479539688505 -122.487986220863 (37.7814795396885, -122.487986220863)
128813 112756 8 37 590x 22nd Ave 1 1 1 1   08/19/2015 12:00:00 AM   3x3   5989085.68012 2111584.9380099997 37.7773800886213 -122.481313741677 (37.7773800886213, -122.481313741677)
99592 112755 8 37 2038 Balboa St 2 1 1 1   08/19/2015 12:00:00 AM   3x3   5989157.5 2111303.8 37.7766123371313 -122.481044705999 (37.7766123371313, -122.481044705999)
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)
97621 98306 8 18 155 Terrace Dr   1 1 1           5993776.0 2096639.0 37.7366139805049 -122.46400331489299 (37.7366139805049, -122.464003314893)
102547 112688 8 49 259 BRIGHT ST 1 1 1 1   08/18/2015 12:00:00 AM 3 5x4   5993720.0 2088919.0 37.71541351482001 -122.46363680360001 (37.71541351482, -122.4636368036)
90414 112573 8 88 56 ROCKWOOD CT 1 1 1 1   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685.0 2098946.0 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387)
113248 112574 8 88 56 ROCKWOOD CT 2 1 1 1   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685.0 2098946.0 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387)
77418 114246 8 21 54 COMMONWEALTH AVE 2 1 1 1       3x3   5996571.0 2114184.0 37.7849487713586 -122.45560763225201 (37.7849487713586, -122.455607632252)
165459 114245 8 21 54 COMMONWEALTH AVE 1 1 1 1     0 3x3   5996571.0 2114184.0 37.7849487713586 -122.45560763225201 (37.7849487713586, -122.455607632252)
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)
95825 113796 8 191 331 TERESITA BLVD 2 29 1 1       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894)
117371 113795 8 22 331 TERESITA BLVD 1 1 1 1       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894)
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)
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)
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)
108143 110651 8 2 127 CENTRAL AVE 1 1 1 1     1 3x3   5999845.0 2108967.0 37.770811558248 -122.44390571748998 (37.770811558248, -122.44390571749)
8183 112515 8 51 2646 Greenwich St 1 1 1 1     2 3x3   6000218.93903 2118886.7143900003 37.7980698532985 -122.443324869154 (37.7980698532985, -122.443324869154)
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)
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)
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)
8240 111918 8 51 41 Toledo Way 1 1 1 1   07/02/2015 12:00:00 AM 3 3x3 Permit Number 773012 6001705.38657 2120044.83908 37.801334410325104 -122.438264349848 (37.8013344103251, -122.438264349848)
1723 112197 8 44 2570 Jackson St 1 1 1 1   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.792175654341605 -122.43739930364599 (37.7921756543416, -122.437399303646)
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)
112556 112627 8 37 2385 BUSH ST 1 1 1 1       3x3   6002100.0 2114635.0 37.78650283124671 -122.436511387034 (37.7865028312467, -122.436511387034)
44012 114160 8 21 2250 Vallejo St 2 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.43439760046499 (37.7953804657925, -122.434397600465)
62298 114159 8 21 2250 Vallejo St 1 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.795396310934294 -122.434341453993 (37.7953963109343, -122.434341453993)
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)
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)
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)
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)
94493 110787 8 17 850x SANCHEZ ST 1 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
129431 110789 8 3 850x SANCHEZ ST 3 8 1 1       3x3   6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
142954 110788 8 17 850x SANCHEZ ST 2 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
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)
3768 228283 8 44 2036X 15th St 6 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3773 228285 8 44 2036X 15th St 8 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3775 228281 8 44 2036X 15th St 4 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3776 228280 8 44 2036X 15th St 3 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3780 228286 8 44 2036X 15th St 9 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3781 228284 8 44 2036X 15th St 7 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3791 228279 8 44 2036X 15th St 2 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3795 228282 8 44 2036X 15th St 5 2 1 1     3 Width 3ft   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)
82999 109123 8 44 2036x 15TH ST 9 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)
93779 109124 8 44 2036x 15TH ST 10 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)
104643 109122 8 44 2036x 15TH ST 8 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
125094 109115 8 44 2036x 15TH ST 1 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)
126955 109116 8 44 2036x 15TH ST 2 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)
77589 110797 8 58 440 29th St 1 1 1 1   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.743606443306206 -122.42986661573299 (37.7436064433062, -122.429866615733)
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)
98791 111204 8 18 168 CLIPPER ST 1 1 1 1   05/27/2015 12:00:00 AM 3 3x3   6004024.0 2101044.0 37.7492943788142 -122.428885525131 (37.7492943788142, -122.428885525131)
93245 112892 8 216 1X WEBSTER ST 4 9 1 1       3x3   6004219.0 2108568.0 37.769964530341895 -122.428747509741 (37.7699645303419, -122.428747509741)
98492 112891 8 216 1X WEBSTER ST 3 9 1 1       3x3   6004219.0 2108568.0 37.769964530341895 -122.428747509741 (37.7699645303419, -122.428747509741)
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)
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)
102863 113300 8 21 29 DORLAND ST 1 1 1 1   09/18/2015 12:00:00 AM 3 3x3   6005366.0 2105717.0 37.7622012138481 -122.42457722211901 (37.7622012138481, -122.424577222119)
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)
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)
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)
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)
79039 112619 8 406 3534 24th St 1 1 1 1   08/12/2015 12:00:00 AM   3x3   6005980.0 2102026.6 37.752102890525606 -122.42219142885 (37.7521028905256, -122.42219142885)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
83145 118340 8 11 1 Franklin St 1 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
98030 118337 8 12 2 Page St 2 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
108721 118336 8 12 2 Page St 1 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
115517 118338 8 12 2 Page St 3 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
121990 118341 8 11 1 Franklin St 2 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
138904 118339 8 12 2 Page St 4 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
87817 112830 8 26 2265 MISSION ST 1 1 1 1   08/21/2015 12:00:00 AM 3 3x3   6006944.0 2105170.0 37.760788269780996 -122.41908070679399 (37.760788269781, -122.419080706794)
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)
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)
Powered by Datasette · Query took 4.686ms · Data source: data.sfgov.org