trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
80 260998 1 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree 4       10x10                      
106 251438 1 41 2501X Santiago St 1 Median : Yard Tree 1                              
394 119605 6 41 299x Avalon Ave 1 Front Yard : Yard Tree 2                              
509 19905 1 41 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
537 261951 1 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree 1                              
595 261954 1 41 1X Portola Dr To Clipper St Connetion 8 Sidewalk: Property side : Yard Tree 1                              
657 20296 1 41 20X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree 1     42 60                      
720 19950 1 41 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
795 19570 1 41 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
1051 251262 6 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
2302 19935 1 41 100 STAIRWAY38 4 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
2744 261957 1 41 1X Portola Dr To Clipper St Connetion 11 Sidewalk: Property side : Yard Tree 1                              
2858 261960 1 41 1X Portola Dr To Clipper St Connetion 14 Sidewalk: Property side : Yard Tree 1                              
3011 19948 1 41 100 STAIRWAY39 5 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
3028 19906 1 41 100 STAIRWAY35 2 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
3052 19908 1 41 100 STAIRWAY35 4 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
3078 19568 1 41 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
3098 20419 1 41 453X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     12 60                      
3191 19565 1 41 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout Tree 1     36 100ST                      
3442 20392 1 41 262X Sunset Blvd 38 Sidewalk: Curb side : Cutout Tree 1     12 60                      
4154 261966 1 41 1X Portola Dr To Clipper St Connetion 20 Sidewalk: Property side : Yard Tree 1                              
4336 20312 1 41 101X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     24 60                      
4465 20303 1 41 50X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     12 60                      
4930 20365 1 41 262X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree 1     48 60                      
5295 19947 1 41 100 STAIRWAY39 4 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
5357 19933 1 41 100 STAIRWAY38 2 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
5438 20428 1 41 485X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     42 40                      
5813 20297 1 41 20X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree 1     36 60                      
6028 261967 1 41 299x Portola Dr 1 Median : Yard Tree 1                              
6583 20407 1 41 262X Sunset Blvd 52 Sidewalk: Curb side : Cutout Tree 1     36 60                      
6724 261948 1 41 1X Portola Dr To Clipper St Connetion 2 Sidewalk: Property side : Yard Tree 1                              
7317 20294 1 41 20X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree 1     24 60                      
7644 19569 1 41 100 STAIRWAY1 3 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
7787 19910 1 41 100 STAIRWAY35 6 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
8411 19699 1 41 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout Tree 1     24 40ST                      
8535 251265 6 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
8582 19955 1 41 100 STAIRWAY39 12 Sidewalk: Curb side : Cutout Tree 1     12 2ST                      
8866 20398 1 41 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout Tree 1     24 60                      
8937 19804 1 41 100 STAIRWAY22 3 Sidewalk: Curb side : Cutout Tree 1     6 20                      
9183 261965 1 41 1X Portola Dr To Clipper St Connetion 19 Sidewalk: Property side : Yard Tree 1                              
9387 19932 1 41 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
9705 261963 1 41 1X Portola Dr To Clipper St Connetion 17 Sidewalk: Property side : Yard Tree 1                              
9757 261950 1 41 1X Portola Dr To Clipper St Connetion 4 Sidewalk: Property side : Yard Tree 1                              
9922 261964 1 41 1X Portola Dr To Clipper St Connetion 18 Sidewalk: Property side : Yard Tree 1                              
10143 256870 2 41 30X Bernal Heights Blvd 1 Back Yard : Cutout Tree 2       12x6                      
10413 20317 1 41 101X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     18 60                      
11142 20455 1 41 495X Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree 1     42 60                      
11294 20417 1 41 453X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     42 60                      
12224 19907 1 41 100 STAIRWAY35 3 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
12236 20366 1 41 262X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree 1     48 60                      
12293 20434 1 41 485X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     12 30                      
12390 20412 1 41 453X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     42 60                      
12448 261958 1 41 1X Portola Dr To Clipper St Connetion 12 Sidewalk: Property side : Yard Tree 1                              
12674 19753 1 41 100 STAIRWAY15 11 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
12679 19813 1 41 100 STAIRWAY24 4 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
12914 20429 1 41 485X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     42 30                      
12968 19943 1 41 100 STAIRWAY38 12 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
13027 261955 1 41 1X Portola Dr To Clipper St Connetion 9 Sidewalk: Property side : Yard Tree 1                              
13064 19694 1 41 100 STAIRWAY7 1 Sidewalk: Curb side : Cutout Tree 1     24 12ST                      
13121 261953 1 41 1X Portola Dr To Clipper St Connetion 7 Sidewalk: Property side : Yard Tree 1                              
13143 19776 1 41 100 STAIRWAY18 2 Sidewalk: Curb side : Cutout Tree 1     18 50ST                      
13162 251365 9 41 138x Gladeview Way 2 Sidewalk: Property side : Yard Tree 2                              
13223 19700 1 41 100 STAIRWAY11 2 Sidewalk: Curb side : Cutout Tree 1     36 40ST                      
13417 19945 1 41 100 STAIRWAY39 2 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
13718 251364 9 41 138x Gladeview Way 1 Sidewalk: Property side : Yard Tree 2                              
14026 19949 1 41 100 STAIRWAY39 6 Sidewalk: Curb side : Cutout Tree 1     24 25ST                      
14194 261962 1 41 1X Portola Dr To Clipper St Connetion 16 Sidewalk: Property side : Yard Tree 1                              
14203 20280 1 41 20X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     18 60                      
14241 251264 6 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
14832 261961 1 41 1X Portola Dr To Clipper St Connetion 15 Sidewalk: Property side : Yard Tree 1                              
14966 20413 1 41 453X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     42 60                      
15219 251366 9 41 138x Gladeview Way 3 Sidewalk: Property side : Yard Tree 2                              
15603 251321 1 41 1X Monument Way 1 Unaccepted Street : Yard Tree 2                              
15795 251263 6 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
15823 20424 1 41 453X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree 1     42 60                      
15891 261952 1 41 1X Portola Dr To Clipper St Connetion 6 Sidewalk: Property side : Yard Tree 1                              
15921 20422 1 41 453X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     36 60                      
15978 20430 1 41 485X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     42 30                      
16093 19936 1 41 100 STAIRWAY38 5 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
16153 19978 1 41 100 STAIRWAY45 5 Sidewalk: Curb side : Cutout Tree 1     36 30ST                      
16212 261956 1 41 1X Portola Dr To Clipper St Connetion 10 Sidewalk: Property side : Yard Tree 1                              
16465 19951 1 41 100 STAIRWAY39 8 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
16556 20423 1 41 453X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     42 60                      
16638 19909 1 41 100 STAIRWAY35 5 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
16749 20291 1 41 20X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     18 60                      
16814 261949 1 41 1X Portola Dr To Clipper St Connetion 3 Sidewalk: Property side : Yard Tree 1                              
17534 261947 1 41 1X Portola Dr To Clipper St Connetion 1 Sidewalk: Property side : Yard Tree 1                              
17805 20377 1 41 262X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree 1     48 60                      
17984 20373 1 41 262X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree 1     18 60                      
18123 19934 1 41 100 STAIRWAY38 3 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
18542 19869 1 41 100 STAIRWAY33 1 Sidewalk: Curb side : Cutout Tree 1     24 25ST                      
18620 261959 1 41 1X Portola Dr To Clipper St Connetion 13 Sidewalk: Property side : Yard Tree 1                              
19208 19953 1 41 100 STAIRWAY39 10 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
19293 20452 1 41 495X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree 1     36 60                      
19500 20013 1 41 100 STAIRWAY47 1 Sidewalk: Curb side : Cutout Tree 1     6 100ST                      
19615 19566 1 41 100 STAIRWAY1 -9 Sidewalk: Curb side : Cutout Tree 1     36 100ST                      
703 262210 6 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
10153 262205 8 41 2 Lois Ln 1 Back Yard : Yard Tree 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
13759 190995 1 41 10x Cashmere St 3 Median : Yard Tree 1     28     6017237.22965 2095860.87095 37.7358015834667 -122.382832806316 (37.7358015834667, -122.382832806316) 10 3 8 58 1
25939 190985 1 41 2 Tulare St 17 Front Yard : Yard Tree 2     13     6016130.05616 2100249.95648 37.747791881903 -122.386966789196 (37.747791881903, -122.386966789196)   3 8 58 1
30658 190983 1 41 2 Tulare St 20 Front Yard : Yard Tree 2     15     6016115.94828 2100251.37259 37.7477949890666 -122.387015672733 (37.7477949890666, -122.387015672733)   3 8 58 1