trees

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2 262167 1 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
6 262166 1 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
13 264822 1 10 2 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6                      
16 264823 1 10 2 Harkness Ave 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6                      
19 262168 1 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
80 260998 1 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree 4       10x10                      
81 46536 7 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
82 251210 1 42 1170 Ingalls St 2 Sidewalk: Curb side : Cutout Tree 1   11/02/1992 12:00:00 AM                          
83 259099 1 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
85 259368 1 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF                            
87 259654 1 45 101x Cora St   Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 1 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 1 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
90 259864 1 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
91 260225 1 10 2201x 22nd Ave 21 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
92 260521 1 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
93 260525 1 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
94 260654 7 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping 2   10/03/2019 12:00:00 AM 3 3.5x3                      
99 255073 9 17 173R Glenview Dr   Back Yard : Yard Tree 2                              
100 255131 1 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree 1                              
101 255229 1 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree 1 FUF                            
102 258152 1 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
103 253831 1 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3                      
104 260590 1 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 08/20/2020 12:00:00 AM 3                        
106 251438 1 41 2501X Santiago St 1 Median : Yard Tree 1                              
107 264818 1 51 101x Olmstead St 2 Sidewalk: Curb side : Cutout Tree 1   10/23/2020 12:00:00 AM 3                        
108 44866 7 17   25 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 7 17   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
110 45916 7 17   51 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 7 17   5 Unaccepted Street : Yard Tree 2                              
112 33929 7 17   4 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
114 251458 1 50 651 Texas St 1 Sidewalk: Curb side : Cutout Tree 2   05/03/2017 12:00:00 AM 3 3x3                      
285 260625 1 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 08/24/2019 12:00:00 AM 3                        
333 44989 7 17   83 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
382 34903 7 19   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
394 119605 6 41 299x Avalon Ave 1 Front Yard : Yard Tree 2                              
449 252970 1 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree 2   04/26/2019 12:00:00 AM 3                        
488 20353 1 111 262X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     6 60                      
492 44943 7 17   176 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
509 19905 1 41 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout Tree 1     12 120ST                      
514 45011 7 17   93 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 7 17   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1956 12:00:00 AM     Permit Number 147                    
525 33087 7 27   6 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
530 35187 7 14   17 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
531 46009 7 17   195 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
537 261951 1 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree 1                              
542 35050 7 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
544 259763 1 75 2701 24th St 1 Sidewalk: Curb side : Cutout Tree 1   03/12/2019 12:00:00 AM 3                        
548 48279 7 17   89 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
550 19742 1 117 100 STAIRWAY15 -9 Sidewalk: Curb side : Cutout Tree 1     6 1OST                      
557 44837 7 17   11 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
561 19835 1 119 100 STAIRWAY25 19 Sidewalk: Curb side : Cutout Tree 1     12 60X                      
566 260237 1 10 2201x 22nd Ave 33 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
582 20409 1 27 451X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     18 10                      
594 20063 1 122 100 STAIRWAY54 10 Sidewalk: Curb side : Cutout Tree 1     6 15ST                      
595 261954 1 41 1X Portola Dr To Clipper St Connetion 8 Sidewalk: Property side : Yard Tree 1                              
604 20034 1 7 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout Tree 1     3 ST                      
622 48348 7 17   153 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
627 34919 7 17   5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
650 46071 7 17   1 Sidewalk: Curb side : Cutout Tree 2   12/12/2001 12:00:00 AM     Permit Number 44455                    
657 20296 1 41 20X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree 1     42 60                      
661 48170 7 17   63 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
663 259361 1 128 1699x Keith St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 05/25/2019 12:00:00 AM 3                        
668 19865 1 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
676 44636 7 17   164 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
689 119914 1 15 400X Brotherhood Way 1 Front Yard : Yard Tree 1       100x100                      
690 19651 1 127 100 STAIRWAY5 50 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
695 20360 1 111 262X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree 1     12 60                      
706 44899 7 17   133 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
720 19950 1 41 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
721 46041 7 17   176 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
722 48068 7 17   234 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
756 124716 1 70 2195 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2                              
767 100549 4 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
768 20385 1 70 262X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree 1     12 60                      
784 187688 1 33 399X Ash St 2 Sidewalk: Curb side : Cutout Tree 2   02/27/2017 12:00:00 AM 3                        
790 55179 7 17 2201 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/31/1972 12:00:00 AM     Permit Number 11088                    
794 44541 7 17   28 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
795 19570 1 41 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout Tree 1     48 100ST                      
796 36869 7 22   4 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
798 19725 1 100 100 STAIRWAY14 3 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
808 19837 1 36 100 STAIRWAY25 21 Sidewalk: Curb side : Cutout Tree 1     6 60X                      
815 20416 1 15 453X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     18 60                      
819 20315 1 56 101X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     42 60                      
841 44570 7 17   134 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
843 38804 7 11   2 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
844 254210 1 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree 1                              
845 35702 7 145   15 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
855 48153 7 17   263 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
871 259735 1 14 100x Florida St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 06/09/2018 12:00:00 AM 3                        
874 19715 1 100 100 STAIRWAY13 13 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
875 19954 1 150 100 STAIRWAY39 11 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
884 261406 1 84 779 Broadway 2 Sidewalk: Curb side : Cutout Tree 2                              
892 44903 7 17   137 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
900 19637 1 52 100 STAIRWAY5 36 Sidewalk: Curb side : Cutout Tree 1     12 30                      
904 48322 7 17   188 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 7 17   62 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
921 61549 7 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
947 60023 7 17   1 Sidewalk: Curb side : Cutout Tree 2   01/25/1982 12:00:00 AM     Permit Number 19510