sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9639 114121 2 3 1200X JUNIPERO SERRA BLVD 14 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
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)
9642 114119 2 3 1200X JUNIPERO SERRA BLVD 12 9 1 1     24     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)
9645 114115 2 3 1200X JUNIPERO SERRA BLVD 8 9 1 1     36     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)
9652 114118 2 3 1200X JUNIPERO SERRA BLVD 11 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9653 114116 2 3 1200X JUNIPERO SERRA BLVD 9 9 1 1     18     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)
9659 114136 2 3 1200X JUNIPERO SERRA BLVD 31 9 1 1     32     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)
9663 114120 2 3 1200X JUNIPERO SERRA BLVD 13 9 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9675 114114 2 3 1200X JUNIPERO SERRA BLVD 7 9 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9676 114117 2 3 1200X JUNIPERO SERRA BLVD 10 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9679 114122 2 3 1200X JUNIPERO SERRA BLVD 15 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9680 173618 2 3 1200X JUNIPERO SERRA BLVD 36 9 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9694 173632 2 3 3300X Market St 1 17 1 1                    
9843 20458 3 3 495X Sunset Blvd 23 1 1 2     42 60            
9855 20400 3 3 262X Sunset Blvd 45 1 1 2     18 60            
9883 173726 6 3 1101 Connecticut St 1 7 1 1           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345)
9890 3755 3 3 1050 Carolina St 1 11 1 2     12 18   6012450.5971046 2103074.0676917997 37.7553418567665 -122.39988853682199 (37.7553418567665, -122.399888536822)
9909 173722 3 3 928 Carolina St 1 11 1 2     17 3x3   6012423.0 2103596.0 37.7567734300957 -122.400020627969 (37.7567734300957, -122.400020627969)
9968 173756 2 3 1X Emil Ln 2 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9970 173755 2 3 1X Emil Ln 1 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9983 173627 2 3 800X Brotherhood Way 5 1 1 1   01/20/2017 12:00:00 AM 3 3x3   5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
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)
9989 173658 2 3 1200X JUNIPERO SERRA BLVD 46 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
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)
9997 173656 2 3 1200X JUNIPERO SERRA BLVD 44 9 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)
10001 173622 2 3 1200X JUNIPERO SERRA BLVD 40 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10003 173619 2 3 1200X JUNIPERO SERRA BLVD 37 9 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)
10009 173621 2 3 1200X JUNIPERO SERRA BLVD 39 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10013 173624 2 3 1200X JUNIPERO SERRA BLVD 42 9 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)
10017 173623 2 3 1200X JUNIPERO SERRA BLVD 41 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10018 173657 2 3 1200X JUNIPERO SERRA BLVD 45 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10020 115676 2 3 1200X Junipero Serra Blvd 5 7 1 1   01/20/2017 12:00:00 AM 3     5991123.2 2089585.5 37.717093588438 -122.472660975441 (37.717093588438, -122.472660975441)
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)
10022 173620 2 3 1200X JUNIPERO SERRA BLVD 38 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10099 173842 2 3 288X Graystone Ter 1 7 1 1           5999483.0 2103863.0 37.7567765924541 -122.444790942005 (37.7567765924541, -122.444790942005)
10146 173882 2 3 201x Howth St 1 13 1 1           5997459.0 2090748.0 37.7206502603184 -122.450845024895 (37.7206502603184, -122.450845024895)
10199 173896 2 3 326x Dellbrook Ave 1 13 1 1       3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
10208 173903 6 3 675 Corbett Ave 1 9 1 1           5999984.0 2103563.0 37.7559814441149 -122.44303676104799 (37.7559814441149, -122.443036761048)
10214 173907 2 3 2200 Jerrold Ave 1 5 1 2           6012443.0 2099218.0 37.7447535037256 -122.399644080592 (37.7447535037256, -122.399644080592)
10223 173927 6 3 240 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
10236 173928 2 3 51 Vulcan Stwy 1 8 1 1           6000543.0 2106304.0 37.763539413759204 -122.441300222472 (37.7635394137592, -122.441300222472)
10388 2288 3 3 800X Brotherhood Way 3 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989397.47374 2088680.9253 37.714509804868605 -122.47855980688699 (37.7145098048686, -122.478559806887)
10567 20323 3 3 101X Sunset Blvd 11 1 1 2     12 60            
10721 2286 3 3 800X Brotherhood Way 1 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989102.32398 2088689.12288 37.714515172905294 -122.4795805509 (37.7145151729053, -122.4795805509)
10850 20451 3 3 495X Sunset Blvd 16 1 1 2     42 60            
10974 20418 3 3 453X Sunset Blvd 7 1 1 2     12 60            
11124 20380 3 3 262X Sunset Blvd 26 1 1 2     48 60            
11126 2292 3 3 800X Brotherhood Way 7 11 1 2     45 14M   5989842.77121 2088680.7511900002 37.7145351702246 -122.477020683771 (37.7145351702246, -122.477020683771)
11130 20306 3 3 50X Sunset Blvd 8 1 1 2     18 60            
11192 24264 3 3 350X Winding Way 2 11 1 2     24 8   6001155.71614 2086583.0952599999 37.709425288929296 -122.437768517615 (37.7094252889293, -122.437768517615)
11214 20374 3 3 262X Sunset Blvd 22 1 1 2     18 60            
11595 20431 3 3 485X Sunset Blvd 4 1 1 2     36 30            
11659 106061 3 3 12X Canyon Dr 1 3 1 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
11765 20396 3 3 262X Sunset Blvd 41 1 1 2     48 60            
12513 2291 3 3 800X Brotherhood Way 6 11 1 2     24 14M   5989707.10535 2088681.30853 37.714528829127495 -122.477489635265 (37.7145288291275, -122.477489635265)
12711 19749 3 3 100 STAIRWAY15 5 1 1 2     6 10ST            
12855 20286 3 3 20X Sunset Blvd 7 1 1 2     12 60            
12984 2293 3 3 800X Brotherhood Way 8 11 1 2     30 14M   5990043.7756199995 2088644.1713900003 37.71444639007029 -122.476323268498 (37.7144463900703, -122.476323268498)
13003 24273 3 3 350X Winding Way 11 11 1 2     12 8   6000864.27338 2086762.8945799998 37.7099024017335 -122.43878866537399 (37.7099024017335, -122.438788665374)
13180 20069 3 3 100 STAIRWAY55 2 1 1 2     36 40ST            
13202 20284 3 3 20X Sunset Blvd 5 1 1 2     12 60            
13213 2294 3 3 800X Brotherhood Way 9 11 1 2     45 14M   5990137.079530001 2088614.4864299998 37.714370293032204 -122.475998609661 (37.7143702930322, -122.475998609661)
13319 93075 1 3 1230 Twin Peaks Blvd 1 9 1 1   02/01/2010 12:00:00 AM     Permit Number 53156 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
13321 187670 7 3 230 Victoria St 1 13 1 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
13357 20454 3 3 495X Sunset Blvd 19 1 1 2     36 60            
13388 20313 3 3 101X Sunset Blvd 2 1 1 2     12 60            
13426 20293 3 3 20X Sunset Blvd 14 1 1 2     42 60            
13476 20287 3 3 20X Sunset Blvd 8 1 1 2     12 60            
13681 19775 3 3 100 STAIRWAY18 1 1 1 2     12 50ST            
13746 20338 3 3 101X Sunset Blvd 25 1 1 2     48 40            
13748 20343 3 3 101X Sunset Blvd 29 1 1 2     48 40            
14111 20421 3 3 453X Sunset Blvd 10 1 1 2     12 60            
14252 20285 3 3 20X Sunset Blvd 6 1 1 2     12 60            
14683 20337 3 3 101X Sunset Blvd 24 1 1 2     48 40            
14835 20387 3 3 262X Sunset Blvd 33 1 1 2     24 60            
14837 94862 1 3   2 1 1 1       3x3 Permit Number 53932          
14905 20283 3 3 20X Sunset Blvd 4 1 1 2     36 60            
15072 20052 3 3 100 STAIRWAY53 1 1 1 2     12 30            
15202 20339 3 3 101X Sunset Blvd 26 1 1 2     48 40            
15238 20432 3 3 485X Sunset Blvd 5 1 1 2     42 30            
15347 20288 3 3 20X Sunset Blvd 9 1 1 2     12 60            
15632 20427 3 3 453X Sunset Blvd 16 1 1 2     12 60            
16056 20402 3 3 262X Sunset Blvd 47 1 1 2     48 60            
16063 20307 3 3 50X Sunset Blvd 9 1 1 2     48 60            
16202 20435 3 3 485X Sunset Blvd 8 1 1 2     6 30            
16297 19969 3 3 100 STAIRWAY43 2 1 1 2     6 15            
16394 20368 3 3 262X Sunset Blvd 18 1 1 2     3 60            
16828 20461 3 3 495X Sunset Blvd 26 1 1 2     6 60            
Powered by Datasette · Query took 2.56ms · Data source: data.sfgov.org