sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
437 20292 3 3 20X Sunset Blvd 13 1 1 2     36 60            
556 20399 3 3 262X Sunset Blvd 44 1 1 2     42 60            
1708 251660 6 3 1050 North Point St 4 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1710 251657 6 3 1050 North Point St 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1841 20401 3 3 262X Sunset Blvd 46 1 1 2     12 60            
2042 20405 3 3 262X Sunset Blvd 50 1 1 2     6 60            
2268 4983 3 3 5300 Diamond Heights Blvd 2 1 1 2   07/10/2017 12:00:00 AM 3 3X3 Permit Number 780192 6001475.6363 2098933.58975 37.7433551224547 -122.43754668724199 (37.7433551224547, -122.437546687242)
2700 20053 3 3 100 STAIRWAY53 2 1 1 2     12 30            
3319 4982 3 3 5300 Diamond Heights Blvd 1 1 1 2   08/31/2017 12:00:00 AM 3 3X3 Permit Number 780192 6001462.73007 2098944.10019 37.743383247851604 -122.437592066128 (37.7433832478516, -122.437592066128)
4187 20426 3 3 453X Sunset Blvd 15 1 1 2     12 60            
4260 20045 3 3 100 STAIRWAY52 1 1 1 2     12 10            
4482 20388 3 3 262X Sunset Blvd 34 1 1 2     24 60            
4528 19968 3 3 100 STAIRWAY43 1 1 1 2     12 15            
5176 253818 2 3 219 Concord St 2 1 1 1 1         5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
5183 211164 2 3 25 Burnside Ave 7 1 1 1     1 Width 3ft   6001259.23547 2095941.97308 37.7351285371507 -122.438080692094 (37.7351285371507, -122.438080692094)
5282 20344 3 3 101X Sunset Blvd 30 1 1 2     24 40            
5456 20311 3 3 50X Sunset Blvd 12 1 1 2     36 60            
6219 20290 3 3 20X Sunset Blvd 11 1 1 2     42 60            
6407 20308 3 3 50X Sunset Blvd 10 1 1 2     48 60            
6784 20408 3 3 262X Sunset Blvd 53 1 1 2     12 60            
7028 20295 3 3 20X Sunset Blvd 16 1 1 2     6 60            
7080 20425 3 3 453X Sunset Blvd 14 1 1 2     18 60            
7092 19853 3 3 100 STAIRWAY29 3 1 1 2     12 100ST            
7096 20070 3 3 100 STAIRWAY55 3 1 1 2     6 40ST            
7176 19977 3 3 100 STAIRWAY45 4 1 1 2     24 30ST            
7292 20433 3 3 485X Sunset Blvd 6 1 1 2     6 30            
7424 20416 3 3 453X Sunset Blvd 5 1 1 2     18 60            
7658 20289 3 3 20X Sunset Blvd 10 1 1 2     42 60            
8010 115555 2 3 3897 Clay St 1 1 1 1     20 3x3   5996212.11985 2115219.4068 37.7877711202849 -122.45692415093201 (37.7877711202849, -122.456924150932)
8078 20329 3 3 101X Sunset Blvd 17 1 1 2     42 60            
8485 20457 3 3 495X Sunset Blvd 22 1 1 2     12 60            
9506 20420 3 3 453X Sunset Blvd 9 1 1 2     12 60            
9521 20394 3 3 262X Sunset Blvd 39 1 1 2     36 60            
9593 94859 1 3   1 1 1 1       3x3 Permit Number 53932          
9600 20367 3 3 262X Sunset Blvd 17 1 1 2     42 60            
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            
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)
10567 20323 3 3 101X Sunset Blvd 11 1 1 2     12 60            
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            
11130 20306 3 3 50X Sunset Blvd 8 1 1 2     18 60            
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            
11765 20396 3 3 262X Sunset Blvd 41 1 1 2     48 60            
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            
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            
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            
19651 20575 3 3 1392X Sunset Blvd 14 1 1 2     42 60   5984737.8310875995 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853)
20371 9649 3 3 420X Masonic Ave 3 1 1 2     60 3X3   5999128.38767 2111347.91542 37.77730804103229 -122.446555809153 (37.7773080410323, -122.446555809153)
22323 21142 3 3 2292X Sunset Blvd 11 1 1 2     3 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
22345 21141 3 3 2292X Sunset Blvd 10 1 1 2     3 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
23115 5045 3 3 5399X Diamond Heights Blvd 6 1 1 2     12     6002018.5391 2098420.87622 37.741978183035606 -122.435632798636 (37.7419781830356, -122.435632798636)
24665 20951 3 3 1992X Sunset Blvd 28 1 1 2     48 60   5984875.945426799 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654)
25194 211098 2 3 129 Merced Ave 2 1 1 1     40 Width 4ft   5994586.4001400005 2099476.04195 37.7444504634195 -122.46140704199699 (37.7444504634195, -122.461407041997)
27187 20695 3 3 1592X Sunset Blvd 10 1 1 2     42 60   5984826.8631 2104357.0018991 37.7572856948155 -122.49551293462 (37.7572856948155, -122.49551293462)
32412 21086 3 3 2192X Sunset Blvd 22 1 1 2     12 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
33011 211096 2 3 32 Taraval St 1 1 1 1     43 Width 3ft   5993627.58197 2099243.34173 37.743756295614205 -122.464705516968 (37.7437562956142, -122.464705516968)
34344 55599 1 3 642 43rd Ave 1 1 1 1   01/08/1973 12:00:00 AM 12   Permit Number 11573 5982597.2205300005 2111395.81021 37.776481429538705 -122.503745058688 (37.7764814295387, -122.503745058688)
41858 211167 2 3 87 Lippard Ave 2 1 1 1     34 Width 4ft   6001932.41069 2095548.8110900002 37.7340872661014 -122.435725166204 (37.7340872661014, -122.435725166204)
42746 21487 3 3 2792X Sunset Blvd 10 1 1 2     6 60   5985060.3629888 2096294.4798015 37.735161871163605 -122.49411119238 (37.7351618711636, -122.49411119238)
44183 21077 3 3 2192X Sunset Blvd 13 1 1 2     42 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
47274 121088 6 3 1X Grand View Ave 1 1 1 1       3x3   6000227.0 2103854.0 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848)
49630 20735 3 3 1601X Sunset Blvd 22 1 1 2     3 60   5984865.3499442 2104298.7792233997 37.7571280850658 -122.49537554020701 (37.7571280850658, -122.495375540207)
51437 21387 3 3 2601X Sunset Blvd 11 1 1 2     3 40   5985098.343425 2097506.3093477003 37.7384914535226 -122.494069167367 (37.7384914535226, -122.494069167367)
58730 20690 3 3 1592X Sunset Blvd 5 1 1 2     12 60   5984826.8631 2104357.0018991 37.7572856948155 -122.49551293462 (37.7572856948155, -122.49551293462)
62497 21311 3 3 2501X Sunset Blvd 11 1 1 2     18 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
62679 184390 2 3 2001 48th Ave 1 1 1 1     7 Width 0ft   5981341.9754 2101226.7255 37.748486165253 -122.507332592891 (37.748486165253, -122.507332592891)
66190 20482 1 3 1204 Sunset Blvd 3 1 1 3     42 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
66635 21451 3 3 2701X Sunset Blvd 4 1 1 2     48 40   5985119.006821499 2096832.7848434 37.73664334454379 -122.49394810120701 (37.7366433445438, -122.493948101207)
67566 87917 1 3 160 Gardenside Dr 2 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50940 5999367.0 2102115.0 37.751970392561496 -122.445066449965 (37.7519703925615, -122.445066449965)
69099 211097 2 3 500 Dewey Blvd 1 1 1 1     38 Width 8ft   5994510.98243 2099836.3031200003 37.745435309198896 -122.461693934723 (37.7454353091989, -122.461693934723)
69379 122419 2 3 2200 San Jose Ave 1 1 1 6       3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
71402 211176 2 3 792 Lakeview Ave 1 1 1 1     27 Width 2ft   5994165.53492 2089952.8107099999 37.71827777448029 -122.462171779599 (37.7182777744803, -122.462171779599)
Powered by Datasette · Query took 18.299ms · Data source: data.sfgov.org