sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3843 253568 6 103 301X Sargent St 1 8 1 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
3879 253286 6 17 40 Mendosa Ave 1 1 1 1   10/02/2017 12:00:00 AM 3 6x10 Permit Number 780599 5993445.0 2101187.0 37.7490825597194 -122.465478005037 (37.7490825597194, -122.465478005037)
4182 253620 6 142 1120 South Van Ness Ave 3 8 1 1       Width 3ft   6007603.98274 2103104.1444200003 37.755153048679205 -122.41665176419201 (37.7551530486792, -122.416651764192)
4283 253621 6 143 200x Montcalm St 1 13 1 1       3x3   6010036.0 2099760.0 37.7461072494139 -122.40800527847799 (37.7461072494139, -122.408005278478)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4673 253651 6 60 131 Font Blvd 1 5 1 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4747 253677 6 71 199X Kissling St 1 18 1 1       5x10            
4916 251372 6 129 1526 Masonic Ave 1 5 1 1   11/01/2017 12:00:00 AM 3 3x3 Permit Number 779800 5999767.0 2107205.0 37.7659690994291 -122.44404889486401 (37.7659690994291, -122.444048894864)
4922 253717 6 105 4101 Balboa St 1 13 1 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5144 253807 6 25 2 Garfield St 1 17 1 1       10x2   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5179 253770 6 142 234 Carl St 1 8 1 1       3x3 Permit Number 770677 5997066.0 2107091.0 37.7655016335596 -122.453382820195 (37.7655016335596, -122.453382820195)
5478 121205 6 234 930 Chestnut St 1 7 1 1     20 3x3   6007386.5238 2120591.4348299997 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145)
7743 121449 6 2 1274 Filbert St 1 7 1 1     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562)
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
8003 109210 6 32 2637 Larkin St 1 7 1 1   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774817 6006569.78732 2120282.61277 37.802262741793704 -122.421448236261 (37.8022627417937, -122.421448236261)
8131 112367 6 5 2770 Broadway 1 5 1 1   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.434780001 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617)
8728 121206 6 12 930 Chestnut St 2 1 1 1   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.5282099997 37.803122321012296 -122.418746939923 (37.8031223210123, -122.418746939923)
9148 85030 6 17 411 Panama St 1 1 1 1   06/26/2007 12:00:00 AM     Permit Number 49384          
9444 173598 6 123 1771 11th Ave 1 5 1 1     12 3x3   5992768.0 2103420.0 37.7551747322674 -122.467981458634 (37.7551747322674, -122.467981458634)
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 6 3 1200X JUNIPERO SERRA BLVD 11 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9655 114155 6 128 1200X JUNIPERO SERRA BLVD 16 7 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9683 173631 6 47 99X Everglade Dr 1 5 1 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
9726 173663 6 82 3878 17th St 1 5 1 1       3x3   6003109.0 2105964.0 37.7627516946294 -122.432400964417 (37.7627516946294, -122.432400964417)
9738 173675 6 258 299x Beale St 5 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9740 173671 6 75 299x Beale St 1 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9741 173676 6 258 299x Beale St 6 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9743 173674 6 135 299x Beale St 4 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9744 173673 6 135 299x Beale St 3 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9749 173677 6 258 299x Beale St 7 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9750 173672 6 135 299x Beale St 2 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9752 173678 6 75 299x Beale St 8 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9848 122687 6 17 1462 Funston Ave 1 8 1 1   01/04/2017 12:00:00 AM 3 3x8 Permit Number 779171 5992142.99696903 2105491.66018597 37.7608268551195 -122.470293739312 (37.7608268551195, -122.470293739312)
9862 173716 6 43 1652 Fell St 1 8 1 1           5999516.0 2109850.0 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354)
9883 173726 6 3 1101 Connecticut St 1 7 1 1           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345)
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
9985 120925 6 3 3995X Alemany Blvd 8 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9986 1263 6 3 3995X Alemany Blvd 3 5 1 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9987 173779 6 148 99X Cleveland St 2 17 1 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
9994 120923 6 3 3995X Alemany Blvd 6 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9998 120931 6 3 3995X Alemany Blvd 14 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 6 3 3995X Alemany Blvd 5 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10000 173780 6 55 99X Cleveland St 3 17 1 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10002 114158 6 259 1200X JUNIPERO SERRA BLVD 6 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10004 114140 6 3 1200X JUNIPERO SERRA BLVD 5 17 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10006 120927 6 3 3995X Alemany Blvd 10 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10010 173778 6 17 99X Cleveland St 1 18 1 1       3x3   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10011 173616 6 26 1200X JUNIPERO SERRA BLVD 15 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10015 120928 6 3 3995X Alemany Blvd 11 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10019 173629 6 260 10X Junipero Serra Blvd Off Ramp 1 5 1 1   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
10021 120935 6 3 3995X Alemany Blvd 18 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10151 173889 6 67 190 Holladay Ave 1 1 1 1       3x3   6010824.0 2099939.0 37.746642831954496 -122.405293064953 (37.7466428319545, -122.405293064953)
10174 173886 6 75 2931 20th St 1 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10190 173887 6 75 2931 20th St 2 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10208 173903 6 3 675 Corbett Ave 1 9 1 1           5999984.0 2103563.0 37.7559814441149 -122.44303676104799 (37.7559814441149, -122.443036761048)
10223 173927 6 3 240 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
10256 173933 6 47 190 Beacon St 1 7 1 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
10461 92319 6 35 2788 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)
10597 92315 6 35 2783 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985839.9086 2096474.3035 37.73570120363421 -122.491429290175 (37.7357012036342, -122.491429290175)
10627 1283 6 44 3995X Alemany Blvd 1 5 1 1     10 10x10   5992081.50866 2087171.0422099999 37.710519496741206 -122.469172961285 (37.7105194967412, -122.469172961285)
10790 80073 6 35 2788 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3     5985889.2586 2096432.3825 37.735588983385 -122.49125558617901 (37.735588983385, -122.491255586179)
10899 92314 6 35 2783 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509)
10991 116458 6 267 777 Brotherhood Way 1 2 1 1     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
11055 116459 6 267 777 Brotherhood Way 2 2 1 1     20 10x20 Permit Number 777772 5989848.42836 2088633.8329099999 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287)
11071 113042 6 62 500 Raymond Ave 1 8 1 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
11570 174950 6 2 309 Crestlake Dr 1 1 1 1       3x3   5987294.0 2096147.0 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564)
11662 102569 6 41 0 Diaz Ave 1 7 1 1   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.8197400002 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
12500 92318 6 35 2787 34th Ave 3 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988222999 (37.7356241060746, -122.49141988223)
12690 92317 6 35 2787 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463)
13114 92316 6 35 2787 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511002 (37.7355642757438, -122.49142378511)
13267 187629 6 183 4283 23rd St 1 7 1 1       3x3   6001353.0 2102279.0 37.7525338497288 -122.43821033719401 (37.7525338497288, -122.438210337194)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13290 187642 6 13 2526 Polk St 1 1 1 1       3x3   6006264.0 2119500.0 37.8000966404513 -122.42245076966002 (37.8000966404513, -122.42245076966)
13301 187651 6 1 175 Raccoon Dr 1 13 1 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
13306 187657 6 5 2072 15th Ave 1 2 1 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
13307 187654 6 47 375 Woodside Ave 1 2 1 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
13315 187668 6 49 100x OGDEN AVE 4 13 1 1           6007659.0 2096105.0 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682)
15902 108047 6 44 1301 Evans Ave 4 1 1 1   06/12/2015 12:00:00 AM 3 3x3   6017036.144669999 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928)
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
17858 121173 6 17 950 Duncan St 2 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
18031 96327 6 141 296 Randall St 1 9 1 1         Permit Number 767829 6003708.0 2097940.0 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294)
Powered by Datasette · Query took 13.174ms · Data source: data.sfgov.org