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                      
178909 176103 1 41 50 Kelloch Ave 1 Sidewalk: Curb side : Pot Tree 2     14 Width 6ft   6008313.99103 2086238.62297 37.7088838754685 -122.413003909814 (37.7088838754685, -122.413003909814) 9 7 8 309 39
73365 176102 1 41 62 Tomaso Ct 5 Front Yard : Yard Tree 2     20 Width 8ft   6009173.04361 2086270.92749 37.7090207630614 -122.410037170481 (37.7090207630614, -122.410037170481) 9 7 8 309 39
92013 176112 1 41 35 Tomaso Ct 4 Side Yard : Yard Tree 2     15 Width 3ft   6009187.4096 2086275.44759 37.7090339795175 -122.409987838189 (37.7090339795175, -122.409987838189) 9 7 8 309 39
62452 176111 1 41 520 Carter St 4 Sidewalk: Curb side : Yard Tree 2     64     6005239.18473 2086329.30196 37.7089597755375 -122.423637326411 (37.7089597755375, -122.423637326411) 9 7 8 309 5
161125 176110 1 41 520 Carter St 3 Sidewalk: Curb side : Yard Tree 2     47     6005248.37143 2086351.63031 37.7090216030216 -122.423607162245 (37.7090216030216, -122.423607162245) 9 7 8 309 5