sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
116617 117139 8 49 2203x NEWCOMB AVE 4 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
116665 103467 8 8 890X Sansome St 3 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
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)
117371 113795 8 22 331 TERESITA BLVD 1 1 1 1       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894)
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)
121912 111085 8 183 117 Manchester St 1 7 1 1   05/20/2015 12:00:00 AM 3   Permit Number 774000 6008295.8 2099262.4 37.744643365507706 -122.413987490618 (37.7446433655077, -122.413987490618)
121990 118341 8 11 1 Franklin St 2 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
122514 113604 8 41 2900 18TH ST 2 1 1 1   10/05/2015 12:00:00 AM   3x3   6009122.0 2105484.0 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816)
122830 113601 8 41 550 FLORIDA ST 2 1 1 1   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233.0 2105681.0 37.762319994612604 -122.411200142124 (37.7623199946126, -122.411200142124)
123153 117141 8 49 2203x NEWCOMB AVE 6 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
123283 112369 8 16 550 Jessie St 2 1 1 1   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727)
123789 113606 8 41 2900 18TH ST 4 1 1 1   10/05/2015 12:00:00 AM   3x3   6009122.0 2105484.0 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816)
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)
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)
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)
126578 103469 8 8 799X Battery St 2 1 1 1           6012272.7 2118721.6 37.798296470544706 -122.401603488036 (37.7982964705447, -122.401603488036)
126955 109116 8 44 2036x 15TH ST 2 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
128798 116471 8 80 882 Carolina St   1 1 1   04/04/2016 12:00:00 AM 3 3x3   6012399.9 2103853.8 37.757480004392 -122.40011862143601 (37.757480004392, -122.400118621436)
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)
129431 110789 8 3 850x SANCHEZ ST 3 8 1 1       3x3   6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
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)
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)
137822 103130 8 21 418 28th Ave 1 4 1 1     1     5987189.392469999 2113118.1924900003 37.781479539688505 -122.487986220863 (37.7814795396885, -122.487986220863)
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)
138904 118339 8 12 2 Page St 4 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
139017 117144 8 49 2203x NEWCOMB AVE 9 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
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)
140060 109118 8 44 2036x 15TH ST 4 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
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)
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)
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)
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)
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)
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)
144368 113609 8 41 2900 18TH ST 7 1 1 1   10/05/2015 12:00:00 AM   3x3   6009122.0 2105484.0 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816)
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)
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)
145031 113612 8 41 595 ALABAMA ST 3 1 1 1   10/05/2015 12:00:00 AM   3x3   6009000.0 2105472.0 37.7617330585457 -122.41199123457899 (37.7617330585457, -122.411991234579)
145351 108823 8 120 101x FREMONT ST 3 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
145620 109949 8 147 400x CLEMENTINA ST 9 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
148004 103468 8 8 799X Battery St 1 1 1 1     2     6012421.85953 2118740.3114 37.798356169556605 -122.401088663417 (37.7983561695566, -122.401088663417)
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)
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)
151907 111321 8 5 1X Peabody St 1 1 1 1     15     6010185.8855099995 2087316.24933 37.7119477217782 -122.406610237293 (37.7119477217782, -122.406610237293)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
901 224716 7 32 3255x 24th St 5 8 1 6     13 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
903 225889 7 121 3255x 24th St 7 16 1 6     18 Width 8ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
905 224715 7 32 3255x 24th St 4 8 1 6     12 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
909 234895 7 86 3255x 24th St 6 18 1 1     40 Width 10ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
914 225888 7 121 3255x 24th St 1 8 1 6     32 6x6   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
916 224714 7 32 3255x 24th St 3 8 1 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
928 224422 7 32 3255x 24th St 2 8 1 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
1928 252837 7 114 98 Prosper St 5 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1929 252833 7 114 98 Prosper St 1 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1948 252834 7 114 98 Prosper St 2 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1955 252835 7 114 98 Prosper St 3 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1996 252848 7 164 99 Reposa Way 1 13 1 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
2595 253142 7 186 735 29th Ave 1 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
2606 253143 7 186 735 29th Ave 2 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
2764 253207 7 47 89 Woodhaven Ct 1 16 1 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
3552 253469 7 114 701 Stanyan St 5 17 1 1           5997178.0 2108423.0 37.7691653834469 -122.45309160151399 (37.7691653834469, -122.453091601514)
4447 253626 7 47 1671 Funston Ave 1 13 1 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
9474 173600 7 60 500 Clarendon Ave 1 5 1 1       3x3   5996184.0 2102497.0 37.7528370823128 -122.45610127186899 (37.7528370823128, -122.456101271869)
11978 112948 7 4 400 Pioche St 1 1 1 1     12 3x15   6005670.66964 2093276.94718 37.7280608613968 -122.42263943148599 (37.7280608613968, -122.422639431486)
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
13296 187658 7 39 600X Clarendon Ave 1 7 1 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
13321 187670 7 3 230 Victoria St 1 13 1 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
22300 248974 7 2 716 Goettingen St 1 13 1 1       3x3   6010713.0 2091306.0 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237)
22826 251117 7 212 2024 Castro St 1 13 1 1           6002622.0 2099601.0 37.7452527853239 -122.43363054854099 (37.7452527853239, -122.433630548541)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
76017 106971 7 3 3479X San Bruno Ave 1 7 1 1     30     6011510.60551 2091910.0343099998 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294)
77354 33781 7 21 200x misson st 12 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6013804.30364325 2116217.11127164 37.7915050790356 -122.396128026757 (37.7915050790356, -122.396128026757)
77987 100070 7 17 331 Serrano Dr 1 7 1 1         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
78509 102745 7 47 222 Moncada Way 1 7 1 1           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409)
Powered by Datasette · Query took 102.058ms · Data source: data.sfgov.org