sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1529 251578 3 62 1000X Columbus Ave 6 11 1 2                    
5701 35451 1 62 790 Peninsula Ave 8 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
6310 35452 1 62 790 Peninsula Ave 7 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
6803 19590 3 62 100 STAIRWAY4 13 1 1 2     3 60            
7231 19588 3 62 100 STAIRWAY4 11 1 1 2     3 60            
7407 19591 3 62 100 STAIRWAY4 14 1 1 2     3 60            
7488 35443 1 62 790 Peninsula Ave 16 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
7802 35460 1 62 790 Peninsula Ave 3 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
8146 35450 1 62 790 Peninsula Ave 9 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
8339 37971 1 62 620 Peninsula Ave 1 1 1 1   07/08/1998 12:00:00 AM     Permit Number 40201          
8797 35455 1 62 790 Peninsula Ave 12 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9539 35456 1 62 790 Peninsula Ave 1 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9554 35448 1 62 790 Peninsula Ave 11 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9566 95785 1 62 347 21st St 1 1 1 1 1 08/19/2011 12:00:00 AM   3x3 Permit Number 767529          
9594 35445 1 62 790 Peninsula Ave 18 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10262 35446 1 62 790 Peninsula Ave 13 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10483 35442 1 62 790 Peninsula Ave 14 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10753 35454 1 62 790 Peninsula Ave 5 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
11139 35047 1 62 700 Peninsula Ave 2 1 1 1   01/22/1998 12:00:00 AM     Permit Number 38613          
11629 35449 1 62 790 Peninsula Ave 10 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
12085 35458 1 62 790 Peninsula Ave 4 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
12173 37972 1 62 624 Peninsula Ave 1 1 1 1   07/08/1998 12:00:00 AM     Permit Number 40202          
12970 19589 3 62 100 STAIRWAY4 12 1 1 2     3 60            
14341 35444 1 62 790 Peninsula Ave 17 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14595 35457 1 62 790 Peninsula Ave 2 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14838 35048 1 62 700 Peninsula Ave 1 1 1 1   01/22/1998 12:00:00 AM     Permit Number 38613          
15544 37973 1 62 630 Peninsula Ave 1 1 1 1   07/08/1998 12:00:00 AM     Permit Number 40203          
16105 35453 1 62 790 Peninsula Ave 6 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
16221 35459 1 62 790 Peninsula Ave 15 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
16521 19806 3 62 100 STAIRWAY23 1 1 1 2     6 60ST            
17025 35447 1 62 790 Peninsula Ave 19 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
151681 118454 2 62 8350 Geary Blvd 1 9 1 1     7     5981044.43167 2112373.0207700003 37.7790731383894 -122.50918908645399 (37.7790731383894, -122.509189086454)
46626 59336 1 62 775 43rd Ave 1 1 1 1   06/29/1993 12:00:00 AM 9   Permit Number 31976 5982585.1174 2110516.14744 37.774065420371706 -122.50372176444999 (37.7740654203717, -122.50372176445)
164001 56674 1 62 1371 37th Ave 1 1 1 1     6     5984603.4838 2105851.1543 37.761375137437604 -122.496395703433 (37.7613751374376, -122.496395703433)
112719 21073 3 62 2192X Sunset Blvd 9 1 1 2     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
115970 21074 3 62 2192X Sunset Blvd 10 1 1 2     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
140920 21075 3 62 2192X Sunset Blvd 11 1 1 2     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
189129 182301 2 62 2537 Kirkham St 1 1 1 1     4 Width 0ft   5986893.9274 2105029.3143 37.7592525025823 -122.488413720954 (37.7592525025823, -122.488413720954)
56115 182302 2 62 2535 Kirkham St 2 1 1 1     3 Width 0ft   5986906.12 2105029.3143 37.7592532139832 -122.488371553614 (37.7592532139832, -122.488371553614)
40247 182303 2 62 2533 Kirkham St 3 1 1 1     4 Width 0ft   5986913.9581 2105029.3143 37.7592536713044 -122.488344446038 (37.7592536713044, -122.488344446038)
160391 120011 2 62 886 29th Ave 2 9 1 1     4 Width 5ft   5987003.60348 2109935.62097 37.7727302588392 -122.48839498846 (37.7727302588392, -122.48839498846)
153718 69330 1 62 2119 Ortega St 1 1 1 1   03/23/1994 12:00:00 AM 4   Permit Number 33413 5987433.342 2102324.8030000003 37.751858106926704 -122.486349632544 (37.7518581069267, -122.486349632544)
171446 45471 1 62 790 27th Ave 1 1 1 1 1 07/19/2001 12:00:00 AM 4   Permit Number 44250 5987593.6437099995 2110560.6661900003 37.7744808674341 -122.48639989849501 (37.7744808674341, -122.486399898495)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
113595 114068 6 62 8 HIGUERA AVE 1 7 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
86962 114103 6 62 5 ACEVEDO AVE 2 7 1 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
103750 114102 6 62 7 ACEVEDO AVE 1 7 1 1     18     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
127535 12849 3 62 2412 Lake St 1 1 1 2   02/02/2010 12:00:00 AM 12 3X3   5987958.93678 2114680.36581 37.7858136848869 -122.48543867329501 (37.7858136848869, -122.485438673295)
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
180131 43801 1 62 525 23rd Ave 1 1 1 1 1 07/26/2000 12:00:00 AM 5   Permit Number 43431 5988746.62136 2111728.0872299997 37.777753417998206 -122.48249713450899 (37.7777534179982, -122.482497134509)
176780 67047 1 62 2532 24th Ave 1 1 1 1   03/20/1992 12:00:00 AM 8   Permit Number 30427 5988951.1175 2098070.1197 37.7402642171623 -122.480789555517 (37.7402642171623, -122.480789555517)
162278 183548 2 62 2590 23rd Ave 2 1 1 1     9 Width 0ft   5989271.0961 2097748.8175 37.7394005980364 -122.479659706735 (37.7394005980364, -122.479659706735)
51194 99324 2 62 1150 Vicente St 7 1 1 1     11 3x3   5989313.9402 2097680.7708 37.739216248209 -122.479506595172 (37.739216248209, -122.479506595172)
173203 99323 2 62 1150 Vicente St 6 1 1 1     9 3x3   5989330.3766 2097681.8666 37.73922021170971 -122.479449846275 (37.7392202117097, -122.479449846275)
165203 99322 2 62 1150 Vicente St 5 1 1 1     5 3x3   5989346.812999999 2097682.9624 37.739224175183 -122.479393097373 (37.739224175183, -122.479393097373)
59050 99321 2 62 1150 Vicente St 4 1 1 1     8 3x3   5989362.5919 2097683.4007 37.7392262951159 -122.47933857369101 (37.7392262951159, -122.479338573691)
166570 99320 2 62 1150 Vicente St 3 1 1 1     3 3x3   5989380.1241 2097683.1815 37.7392267115304 -122.479277939862 (37.7392267115304, -122.479277939862)
133189 120726 2 62 450 21st Ave 1 1 1 1     4 Width 2ft   5989392.84856 2112260.68272 37.779253349203294 -122.480300629667 (37.7792533492033, -122.480300629667)
134764 99319 2 62 1150 Vicente St 2 1 1 1     8 3x3   5989394.1498 2097683.839 37.73922933145371 -122.479229493917 (37.7392293314537, -122.479229493917)
91835 99325 2 62 1150@23rd Ave Vicente St 1 1 1 1       4.5x6   5989403.0 2097682.0 37.73922479603689 -122.479198759749 (37.7392247960369, -122.479198759749)
76802 99318 2 62 1150 Vicente St 1 1 1 1     7 3x3   5989408.3581 2097684.4234 37.7392317612483 -122.47918041128 (37.7392317612483, -122.47918041128)
11928 105246 2 62 2439 22nd Ave 1 1 1 1     14 6x6   5989501.8448 2098751.2622 37.7421664525595 -122.478935190185 (37.7421664525595, -122.478935190185)
53171 85317 1 62 1278 20th Ave 1 1 1 1     0     5989890.9 2106671.2 37.76393508945571 -122.478168901115 (37.7639350894557, -122.478168901115)
112317 85318 1 62 1278 20th Ave 1 1 1 1   08/06/2007 12:00:00 AM     Permit Number 49596 5989890.9 2106671.2 37.76393508945571 -122.478168901115 (37.7639350894557, -122.478168901115)
168505 46656 1 62 332 19th Ave 1 1 1 1 1 04/19/2002 12:00:00 AM 6   Permit Number 44787 5989986.8778099995 2113120.4528799998 37.781648539642404 -122.47830854187 (37.7816485396424, -122.47830854187)
147926 121858 2 62 682 19th Ave 1 1 1 1     13 Width 3ft   5990066.45835 2110748.50952 37.7751404594463 -122.477859785758 (37.7751404594463, -122.477859785758)
72156 104935 6 62 835 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
99811 104936 6 62 837 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
109347 104937 6 62 839 Gonzalez Dr 2 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
114209 104934 6 62 805 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
62476 43761 1 62 364 17th Ave 1 1 1 1 1 07/26/2000 12:00:00 AM 5   Permit Number 43396 5990612.6596 2112954.63099 37.781229546008895 -122.476131541236 (37.7812295460089, -122.476131541236)
109022 29640 3 62 1110X Junipero Serra Blvd 13 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
110556 29641 3 62 1110X Junipero Serra Blvd 14 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
144121 29639 3 62 1110X Junipero Serra Blvd 12 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
30755 208080 3 62 1000x Junipero Serra Blvd 1 11 1 2     4 Width 0ft   5991162.63824 2089810.37082 37.7177133113937 -122.472541042839 (37.7177133113937, -122.472541042839)
65001 208083 3 62 1000x Junipero Serra Blvd 46 11 1 2     3 Width 0ft   5991231.056580001 2090980.0304 37.720928868853896 -122.472389775075 (37.7209288688539, -122.472389775075)
33216 208082 3 62 1000x Junipero Serra Blvd 45 11 1 2     3 Width 0ft   5991232.009819999 2090962.1201799999 37.720879746979705 -122.47238517505 (37.7208797469797, -122.47238517505)
42602 208081 3 62 1000x Junipero Serra Blvd 43 11 1 2     4 Width 0ft   5991233.74878 2090918.35178 37.720759670396106 -122.47237597496999 (37.7207596703961, -122.47237597497)
88746 11784 3 62 810X Junipero Serra Blvd 16 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991252.992504 2092079.9575241 37.7239502662313 -122.472394094235 (37.7239502662313, -122.472394094235)
18117 11765 3 62 800X Junipero Serra Blvd 3 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991272.34511 2091581.45548 37.7225826231682 -122.47229087392 (37.7225826231682, -122.47229087392)
20128 11766 3 62 800X Junipero Serra Blvd 4 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991273.54078 2091606.60865 37.72265175674929 -122.47228857348101 (37.7226517567493, -122.472288573481)
21942 11767 3 62 800X Junipero Serra Blvd 5 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991276.05264 2091631.0711599998 37.7227190701221 -122.472281672976 (37.7227190701221, -122.472281672976)
91557 29978 3 62 610X Junipero Serra Blvd 5 11 1 2   04/01/2007 12:00:00 AM 3 3x3   5991336.00972369 2093444.32433125 37.7277012826104 -122.47220652658001 (37.7277012826104, -122.47220652658)
101082 29979 3 62 610X Junipero Serra Blvd 6 11 1 2   04/01/2007 12:00:00 AM 3 3x3   5991336.00972369 2093444.32433125 37.7277012826104 -122.47220652658001 (37.7277012826104, -122.47220652658)
140520 29589 3 62 610X Junipero Serra Blvd 3 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991336.987432401 2093443.9543843998 37.7277003234109 -122.472203119704 (37.7277003234109, -122.472203119704)
23828 177148 2 62 1100 Junipero Serra Blvd 11 4 1 1     3 Width 0ft   5991345.1062 2088786.2704900003 37.7149119421181 -122.47183574413401 (37.7149119421181, -122.471835744134)
52418 177149 2 62 1100 Junipero Serra Blvd 12 4 1 1     3 Width 0ft   5991352.53535 2088761.3617099999 37.714843978538205 -122.47180825186301 (37.7148439785382, -122.471808251863)
38457 208084 3 62 800x Junipero Serra Blvd 53 11 1 2     4 Width 0ft   5991354.011469999 2092835.9648 37.726031920722605 -122.47209997035 (37.7260319207226, -122.47209997035)
25223 208086 3 62 800x Junipero Serra Blvd 56 11 1 2     4 Width 0ft   5991357.47228 2092905.4597099999 37.7262229367261 -122.472093069866 (37.7262229367261, -122.472093069866)
162256 177150 2 62 1100 Junipero Serra Blvd 13 4 1 1     3 Width 0ft   5991357.8727400005 2088731.5467 37.7147624226096 -122.471787632218 (37.7147624226096, -122.471787632218)
150230 208085 3 62 800x Junipero Serra Blvd 55 11 1 2     5 Width 0ft   5991358.2999 2092881.5903900003 37.726157445407296 -122.47208846980301 (37.7261574454073, -122.472088469803)
19955 29580 3 62 500X Junipero Serra Blvd 2 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991386.6913 2093344.7747799999 37.7274308773069 -122.47202406848 (37.7274308773069, -122.47202406848)
19813 29581 3 62 500X Junipero Serra Blvd 3 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991390.5187800005 2093368.54568 37.7274963677541 -122.47201256884199 (37.7274963677541, -122.472012568842)
90967 208087 3 62 500x Junipero Serra Blvd 5 11 1 2     3 Width 0ft   5991392.30049 2093421.51137 37.7276419014288 -122.472010268365 (37.7276419014288, -122.472010268365)
105098 30048 3 62 1400X Junipero Serra Blvd 29 11 1 2     3 3X3   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
105889 30047 3 62 1400X Junipero Serra Blvd 28 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
146267 30049 3 62 1400X Junipero Serra Blvd 30 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
66612 208088 3 62 500x Junipero Serra Blvd 40 11 1 2     3 Width 0ft   5991446.48536 2094319.42031 37.7301104703116 -122.471888366152 (37.7301104703116, -122.471888366152)
68520 208089 3 62 500x Junipero Serra Blvd 42 11 1 2     3 Width 0ft   5991450.70341 2094361.7324599999 37.730226892943705 -122.471876866532 (37.7302268929437, -122.471876866532)
134959 68463 1 62 339 14th Ave 1 1 1 1 1 10/04/1993 12:00:00 AM 8   Permit Number 32325 5991519.12103 2113131.34732 37.781767281646204 -122.473008553548 (37.7817672816462, -122.473008553548)
Powered by Datasette · Query took 32.93ms · Data source: data.sfgov.org