sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3018 128709 1 32 4x Columbus Ave 1 3 1 1     19 Width 9ft   6011726.08303 2117794.9108 37.795721488711294 -122.403429729102 (37.7957214887113, -122.403429729102)
9919 173741 2 17 2500X Lyon St 8 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9921 173736 2 17 2500X Lyon St 3 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9923 173740 2 17 2500X Lyon St 7 3 1 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9924 173738 2 17 2500X Lyon St 5 3 1 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9925 173735 2 17 2500X Lyon St 2 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9926 173734 2 17 2500X Lyon St 1 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9927 173742 2 17 2500X Lyon St 9 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9929 173737 2 17 2500X Lyon St 4 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9931 173739 2 17 2500X Lyon St 6 3 1 1   01/10/2017 12:00:00 AM 3 3x3 Permit Number 779102 5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
13314 187669 2 47 554 Valley St 1 3 1 1           6002324.0 2099197.0 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307)
19556 99478 1 60 650X Miramar Ave 4 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
76136 111405 2 3 50x SANTA RITA AVE 10 3 1 1     50     5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
79568 116501 6 3 71X PARKRIDGE DR 2 3 1 1     40 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
81264 99456 1 60 400X Miramar Ave 6 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
82501 111413 2 3 150x SAN MARCOS AVE 8 3 1 1     42     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
82835 113195 3 40 699X Noe St 2 3 1 1           6003039.779709999 2104315.51778 37.7582214335608 -122.432522620301 (37.7582214335608, -122.432522620301)
83529 111403 2 3 50x SANTA RITA AVE 8 3 1 1     28     5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
84421 96975 3 17 399X Filbert St 4 3 1 1     24     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
84668 116500 6 3 71X PARKRIDGE DR 1 3 1 1     45 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
85151 99471 1 60 600X Miramar Ave 7 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
85176 104920 2 75 750 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
87236 99491 1 60 800X Miramar Ave 5 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
89670 114428 2 3 34x HIGUERA AVE 2 3 1 1     56     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
89696 111418 2 62 200x SAN MARCOS AVE 3 3 1 1     5     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
89796 111400 2 3 50x SANTA RITA AVE 5 3 1 1     54   Permit Number 779360 5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
95691 111404 2 3 50x SANTA RITA AVE 9 3 1 1     48     5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
95918 111398 2 3 50x SANTA RITA AVE 3 3 1 1     4   Permit Number 779360 5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
95953 111416 2 215 200x SAN MARCOS AVE 1 3 1 1     24     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
96206 111407 2 3 150x SAN MARCOS AVE 2 3 1 1     12     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
98576 99490 1 60 800X Miramar Ave 4 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
98788 111423 2 3 200x SAN MARCOS AVE 8 3 1 1     50     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
99310 111417 2 215 200x SAN MARCOS AVE 2 3 1 1     24     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
99590 111406 2 3 150x SAN MARCOS AVE 1 3 1 1     40     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
101258 104921 2 75 750 Gonzalez Dr 2 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
101535 116502 6 3 71X PARKRIDGE DR 3 3 1 1     28 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
103385 111415 2 3 150x SAN MARCOS AVE 10 3 1 1     48     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
103516 111419 2 1 200x SAN MARCOS AVE 4 3 1 1     10     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
103771 111426 2 62 200x SAN MARCOS AVE 11 3 1 1     6     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
104683 111397 2 3 50x SANTA RITA AVE 2 3 1 1     36   Permit Number 779360 5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
106027 111425 2 39 200x SAN MARCOS AVE 10 3 1 1     16     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
106876 111408 2 3 150x SAN MARCOS AVE 3 3 1 1     15     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
107740 107644 2 3 1400x KIRKWOOD AVE 1 3 1 1           6015822.8 2096363.1 37.7371023539668 -122.38775811873998 (37.7371023539668, -122.38775811874)
108934 113438 2 3 180x LOWER TER   3 1 1     22 3x3   6000120.0 2106246.0 37.7633560547765 -122.44275907578 (37.7633560547765, -122.44275907578)
109414 111414 2 3 150x SAN MARCOS AVE 9 3 1 1     42     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
109545 111090 2 15 28x HIGUERA AVE 1 3 1 1   06/04/2015 12:00:00 AM 3   Permit Number 777485 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
109648 111396 2 3 50x SANTA RITA AVE 1 3 1 1     53   Permit Number 779360 5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
110134 117310 1 17 126X Juan Bautista Cir 1 3 1 1   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777998 5989282.4 2089642.3 37.7171428191075 -122.479027821944 (37.7171428191075, -122.479027821944)
111624 104922 2 75 750 Gonzalez Dr 3 3 1 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
111907 111427 2 39 200x SAN MARCOS AVE 12 3 1 1     20     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
112509 111420 2 1 200x SAN MARCOS AVE 5 3 1 1     15     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
114353 111399 2 3 50x SANTA RITA AVE 4 3 1 1     48   Permit Number 779360 5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
116375 99101 6 11 55x Santa Monica Way 1 3 1 1   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.739396991894104 -122.464361897304 (37.7393969918941, -122.464361897304)
121319 111411 2 3 150x SAN MARCOS AVE 6 3 1 1     12     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
121346 111410 2 3 150x SAN MARCOS AVE 5 3 1 1     10     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
121585 111422 2 3 200x SAN MARCOS AVE 7 3 1 1     48     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
121860 102111 3 3 18 Saturn St 1 3 1 1     24     6000559.0 2106017.0 37.7627522940794 -122.441224290546 (37.7627522940794, -122.441224290546)
123683 99488 1 60 800X Miramar Ave 1 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
127178 108238 2 17 764x JUNIPERO SERRA BLVD 1 3 1 1           5991289.6 2092496.8 37.7250969308873 -122.47229792145599 (37.7250969308873, -122.472297921456)
127394 111402 2 3 50x SANTA RITA AVE 7 3 1 1       29   5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
128606 104928 2 75 810 Gonzalez Dr 3 3 1 1     12     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
138714 99482 1 60 700X Miramar Ave 1 3 1 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
140384 104978 2 116 66X San Lorenzo Way 1 3 1 1         Permit Number 770332 5993690.5 2097533.7 37.7390656757525 -122.46436386193301 (37.7390656757525, -122.464363861933)
140697 111409 2 3 150x SAN MARCOS AVE 4 3 1 1     45     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
142054 111424 2 3 200x SAN MARCOS AVE 9 3 1 1     12     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
143022 111421 2 3 200x SAN MARCOS AVE 6 3 1 1     46     5993395.0 2100395.0 37.746905045660796 -122.465593373526 (37.7469050456608, -122.465593373526)
143894 104927 2 75 810 Gonzalez Dr 2 3 1 1     10     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
144513 111401 2 3 50x SANTA RITA AVE 6 3 1 1       40   5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
144760 104926 2 75 810 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
145014 111412 2 3 150x SAN MARCOS AVE 7 3 1 1     36     5993566.0 2100407.0 37.7469478560931 -122.465002947317 (37.7469478560931, -122.465002947317)
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 3 47 401 Portola Dr 6 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 3 47 401 Portola Dr 2 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 3 47 401 Portola Dr 5 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 3 47 401 Portola Dr 1 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 3 47 401 Portola Dr 7 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
785 251376 3 47 401 Portola Dr 4 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
1022 186874 3 5 2700 Sunset Blvd 23 3 1 2     13 Width 0ft   5985204.8462 2096382.2812 37.7354114037883 -122.493618136413 (37.7354114037883, -122.493618136413)
1039 186954 3 17 2800 Sunset Blvd 28 3 1 2     2 Width 0ft   5985211.8854 2096092.27 37.734615522028896 -122.493572437422 (37.7346155220289, -122.493572437422)
1041 187245 3 129 2401 Sunset Blvd 28 3 1 2     1 Width 0ft   5984968.6731 2098517.9713 37.741261616740005 -122.494592058244 (37.74126161674, -122.494592058244)
1052 187279 3 105 2401 Sunset Blvd 62 3 1 2     4 Width 0ft   5984952.4466 2098301.7622 37.7406670151021 -122.494632227246 (37.7406670151021, -122.494632227246)
1059 186952 3 5 2800 Sunset Blvd 26 3 1 2     3 Width 0ft   5985204.8226 2096075.4539 37.734568936321295 -122.493595616872 (37.7345689363213, -122.493595616872)
1098 251438 3 47 2501X Santiago St 1 3 1 2                    
3208 253368 3 47 236 Moncada Way 1 3 1 2       10x10   5992398.0 2093455.0 37.7277919980392 -122.468536018982 (37.7277919980392, -122.468536018982)
3898 212122 3 60 300x Miramar Ave 4 3 1 2     3     5995365.2918 2092257.6675200001 37.724675368963105 -122.45819147914699 (37.7246753689631, -122.458191479147)
5008 253723 3 177 1X Glenview Dr   3 1 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
10203 106598 3 5 1001X SAN JOSE AVE 11 3 1 2     21     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
10408 106060 3 177 12X Canyon Dr 3 3 1 2     24     6003183.55845 2086355.5239400002 37.7089155261884 -122.430743733243 (37.7089155261884, -122.430743733243)
11046 116538 3 48 1002x Naples St 1 3 1 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
11659 106061 3 3 12X Canyon Dr 1 3 1 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
18076 107933 3 17 3098X Market St 1 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
19618 102860 3 177 10X CRANLEIGH DR 1 3 1 2   03/06/2013 12:00:00 AM 6     5991339.0 2095700.0 37.7338949747581 -122.472360557436 (37.7338949747581, -122.472360557436)
22808 195725 3 15 250x King St 9 3 1 2     5 Width 10ft   6014714.95739 2111115.10019 37.7775467477219 -122.39262009845 (37.7775467477219, -122.39262009845)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
Powered by Datasette · Query took 20.379ms · Data source: data.sfgov.org