sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3709 253265 6 19 180 San Aleso Ave 1 8 1 1   09/19/2017 12:00:00 AM 3 3x3   5993319.0 2094440.0 37.730549723890206 -122.465423653439 (37.7305497238902, -122.465423653439)
3799 178336 6 3 401 Ocean Ave 2 9 1 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
3801 177109 6 55 401 Ocean Ave 16 9 1 6     6 Width 5ft   5998958.08532 2091518.52367 37.72285164275971 -122.445718558684 (37.7228516427597, -122.445718558684)
3803 178335 6 3 401 Ocean Ave 1 9 1 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
3805 177105 6 55 401 Ocean Ave 12 9 1 6     4 Width 5ft   5998924.5969 2091518.7811599998 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179)
3806 177110 6 55 401 Ocean Ave 17 9 1 6     6 Width 5ft   5998978.57855 2091518.5364400002 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081)
3808 177108 6 55 401 Ocean Ave 15 9 1 6     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369563999 (37.7228504376851, -122.44574369564)
3811 177743 6 2 401 Ocean Ave 4 9 1 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
3826 177104 6 55 401 Ocean Ave 11 9 1 6     4 Width 5ft   5998921.0818300005 2091519.29315 37.722851642780796 -122.44584652679501 (37.7228516427808, -122.445846526795)
3827 177106 6 55 401 Ocean Ave 13 9 1 6     7 Width 5ft   5998933.177730001 2091518.16383 37.7228492325857 -122.44580463279199 (37.7228492325857, -122.445804632792)
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)
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
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)
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
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)
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
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)
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
Powered by Datasette · Query took 6.613ms · Data source: data.sfgov.org