trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
83 259099 1 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
101 255229 1 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree 1 FUF                            
843 38804 7 11   2 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
958 36868 7 11   2 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
1017 46142 7 11   3 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
1160 122663 1 11 401x Laguna St 1 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
1183 47616 7 11 1209 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
1310 173924 1 11 500X Gough St 4 Sidewalk: Curb side : Cutout Tree 1   10/05/2010 12:00:00 AM   3x3                      
1393 255136 1 11 401X Brotherhood Way 14 Sidewalk: Property side : Yard Tree 1                              
1665 47611 7 11 1201 Houston St 3 Sidewalk: Curb side : Cutout Tree 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
1736 255231 1 11 300X Goettingen St 6 Sidewalk: Curb side : Cutout Tree 1 FUF                            
2283 49626 7 11 152211th/10th Houston St 1 Sidewalk: Curb side : Cutout Tree 2   05/13/2003 12:00:00 AM     Permit Number 46481                    
2296 32307 7 11 1097 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
2887 255158 1 11 3098 Turk St 3 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
2996 38797 7 11   5 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3477 259101 1 11 600 Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
3528 38666 7 11 850 Brewster St 3 Sidewalk: Curb side : Cutout Tree 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
3783 47477 7 11   3 Sidewalk: Curb side : Cutout Tree 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
3868 259094 1 11 800 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1   06/01/2019 12:00:00 AM 3                        
3879 260548 2 11 1190 Valencia St 1 Sidewalk: Curb side : Cutout Tree 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
4395 255228 1 11 300X Goettingen St 3 Sidewalk: Curb side : Cutout Tree 1 FUF                            
4834 255234 1 11 300X Goettingen St 9 Sidewalk: Curb side : Cutout Tree 1 FUF                            
4997 255137 1 11 401X Brotherhood Way 15 Sidewalk: Property side : Yard Tree 1                              
5759 47617 7 11 1209 Houston St 3 Sidewalk: Curb side : Cutout Tree 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
6231 46141 7 11   4 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
6441 255157 1 11 3098 Turk St 2 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
6648 255227 1 11 300X Goettingen St 2 Sidewalk: Curb side : Cutout Tree 1 FUF                            
7019 258770 1 11 399 Gough St 1 Sidewalk: Curb side : Cutout Tree 1                              
7036 38800 7 11   8 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
7086 255139 1 11 401X Brotherhood Way 17 Sidewalk: Property side : Yard Tree 1                              
7311 255140 1 11 401X Brotherhood Way 18 Sidewalk: Property side : Yard Tree 1                              
7363 35440 7 11 757 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
7393 259095 1 11 800 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1   06/01/2019 12:00:00 AM 3                        
7619 35441 7 11 757 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
8397 38801 7 11   6 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
8544 256668 7 11 1835 Hyde St   Sidewalk: Curb side : Cutout Tree 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782601                    
8625 122664 1 11 401x Laguna St 2 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
8691 47618 7 11 1209 Houston St 2 Sidewalk: Curb side : Cutout Tree 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
8822 260549 2 11 1190 Valencia St 4 Sidewalk: Curb side : Cutout Tree 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
8945 38806 7 11   7 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
9056 251171 1 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout Tree 1   04/10/2017 11:21:00 AM 3                        
9193 32309 7 11 1097 Houston St 3 Sidewalk: Curb side : Cutout Tree 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
9292 46150 7 11   2 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
9413 35439 7 11 757 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
9832 46143 7 11   2 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
9920 255153 1 11 2901 Turk Blvd 10 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
10086 47615 7 11 1209 Houston St 5 Sidewalk: Curb side : Cutout Tree 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
10098 255141 1 11 2901 Turk Blvd 4 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
10214 255235 1 11 300X Goettingen St 10 Sidewalk: Curb side : Cutout Tree 1 FUF                            
10289 122666 1 11 401x Laguna St 4 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
10648 255138 1 11 401X Brotherhood Way 16 Sidewalk: Property side : Yard Tree 1                              
10916 108180 4 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2       3x3                      
10993 122665 1 11 401x Laguna St 3 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
11177 47475 7 11   1 Sidewalk: Curb side : Cutout Tree 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
11307 255155 1 11 3066 Turk St 1 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
11945 47610 7 11 1201 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12394 47612 7 11 1201 Houston St 2 Sidewalk: Curb side : Cutout Tree 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12656 262184 1 11 550 Delta St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 09/07/2019 12:00:00 AM 3                        
12744 35438 7 11 757 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
12774 255134 1 11 401X Brotherhood Way 12 Sidewalk: Property side : Yard Tree 1                              
12891 47614 7 11 1209 Houston St 4 Sidewalk: Curb side : Cutout Tree 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
12896 47476 7 11   2 Sidewalk: Curb side : Cutout Tree 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
13109 38799 7 11   9 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13373 46149 7 11   1 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
13382 38798 7 11   10 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13402 19893 1 11 100 STAIRWAY33 25 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
13404 46147 7 11   1 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
13511 19889 1 11 100 STAIRWAY33 21 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
13590 38665 7 11 850 Brewster St 1 Sidewalk: Curb side : Cutout Tree 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
13602 32308 7 11 1097 Houston St 2 Sidewalk: Curb side : Cutout Tree 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
13620 259100 1 11 600 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1   03/30/2019 12:00:00 AM 3                        
14090 47478 7 11   4 Sidewalk: Curb side : Cutout Tree 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
14363 38802 7 11   4 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
14389 95083 7 11 730@ Waller Stanyan Blvd 4 Sidewalk: Curb side : Cutout Tree 2   12/20/2010 12:00:00 AM   3x3 Permit Number 54023                    
14637 36870 7 11   4 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
14702 19896 1 11 100 STAIRWAY33 28 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
14722 38664 7 11 850 Brewster St 2 Sidewalk: Curb side : Cutout Tree 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
14753 259380 2 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree 1                              
14775 19897 1 11 100 STAIRWAY33 29 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
15031 253830 1 11 651X Polk St 3 Sidewalk: Curb side : Cutout Tree 2 DPW 02/22/2018 12:07:00 PM 3 3x3                      
15221 255135 1 11 401X Brotherhood Way 13 Sidewalk: Property side : Yard Tree 1                              
15394 255154 1 11 2901 Turk St 18 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
16288 38803 7 11   3 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
16805 36846 7 11   3 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
16819 38805 7 11   1 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
17169 255230 1 11 300X Goettingen St 5 Sidewalk: Curb side : Cutout Tree 1 FUF                            
17252 255152 1 11 2901 Turk Blvd 6 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
17273 88119 7 11 1313 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 51123                    
17581 122667 1 11 401x Laguna St 5 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
18432 255156 1 11 3098 Turk St 1 Sidewalk: Curb side : Cutout Tree 1   03/17/2018 12:00:00 AM 3                        
18518 255232 1 11 300X Goettingen St 7 Sidewalk: Curb side : Cutout Tree 1 FUF                            
18604 35437 7 11 757 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
18779 38667 7 11 850 Brewster St 4 Sidewalk: Curb side : Cutout Tree 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
19035 255226 1 11 300X Goettingen St 1 Sidewalk: Curb side : Cutout Tree 1 FUF                            
19065 255233 1 11 300X Goettingen St 8 Sidewalk: Curb side : Cutout Tree 1 FUF                            
19614 36867 7 11   1 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
23971 87693 7 11 2640X Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6010430.21787 2085894.88295 37.70805860283 -122.405665701193 (37.70805860283, -122.405665701193)       28588  
46966 87694 7 11 2640X Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6010413.19181 2085847.77235 37.707928294454 -122.405721229244 (37.707928294454, -122.405721229244)       28588  
132310 87691 7 11 2640X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6010453.75722 2085956.27314 37.7082284842795 -122.40558866725 (37.7082284842795, -122.40558866725)       28588  
171870 87692 7 11 2640X Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6010446.60881 2085937.89343 37.708177617555 -122.405612079416 (37.708177617555, -122.405612079416)       28588  
194389 265057 5 11 1190 Mason St 1 Sidewalk: Curb side : Cutout Tree 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590