trees

8,659 rows where qSpecies_id = 11 sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
83 259099 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
101 255229 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
843 38804 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
958 36868 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
1017 46142 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
1160 122663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
1183 47616 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
1310 173924 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500X Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2010 12:00:00 AM   3x3                      
1393 255136 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 14 Sidewalk: Property side : Yard Tree DPW 1                              
1665 47611 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
1736 255231 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
2283 49626 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 152211th/10th Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46481                    
2296 32307 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
2887 255158 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3098 Turk St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
2996 38797 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   5 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3477 259101 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
3528 38666 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
3783 47477 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
3868 259094 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 800 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
3879 260548 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
4395 255228 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4834 255234 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 9 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4997 255137 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 15 Sidewalk: Property side : Yard Tree DPW 1                              
5759 47617 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
6231 46141 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
6441 255157 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3098 Turk St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
6648 255227 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
7019 258770 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 399 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
7036 38800 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   8 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
7086 255139 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 17 Sidewalk: Property side : Yard Tree DPW 1                              
7311 255140 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 18 Sidewalk: Property side : Yard Tree DPW 1                              
7363 35440 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
7393 259095 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 800 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
7619 35441 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
8397 38801 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   6 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
8544 256668 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1835 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782601                    
8625 122664 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
8691 47618 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
8822 260549 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
8945 38806 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   7 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
9056 251171 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 11:21:00 AM 3                        
9193 32309 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
9292 46150 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
9413 35439 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
9832 46143 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
9920 255153 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
10086 47615 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
10098 255141 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
10214 255235 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 10 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
10289 122666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
10648 255138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 16 Sidewalk: Property side : Yard Tree DPW 1                              
10916 108180 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
10993 122665 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
11177 47475 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
11307 255155 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3066 Turk St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
11945 47610 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12394 47612 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
12656 262184 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 550 Delta St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
12744 35438 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
12774 255134 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 12 Sidewalk: Property side : Yard Tree DPW 1                              
12891 47614 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
12896 47476 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
13109 38799 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   9 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13373 46149 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
13382 38798 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   10 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
13402 19893 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
13404 46147 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
13511 19889 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
13590 38665 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
13602 32308 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1097 Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
13620 259100 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2019 12:00:00 AM 3                        
14090 47478 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
14363 38802 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
14389 95083 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 730@ Waller Stanyan Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2010 12:00:00 AM   3x3 Permit Number 54023                    
14637 36870 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
14702 19896 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 28 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
14722 38664 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
14753 259380 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
14775 19897 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 29 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
15031 253830 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 651X Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW 02/22/2018 12:07:00 PM 3 3x3                      
15221 255135 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 13 Sidewalk: Property side : Yard Tree DPW 1                              
15394 255154 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk St 18 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
16288 38803 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
16805 36846 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
16819 38805 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
17169 255230 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
17252 255152 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2901 Turk Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
17273 88119 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1313 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51123                    
17581 122667 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
18432 255156 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3098 Turk St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
18518 255232 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 7 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
18604 35437 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 757 Peninsula Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38882                    
18779 38667 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
19035 255226 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
19065 255233 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 8 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
19614 36867 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
194389 265057 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194396 265058 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194403 265059 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
157481 34715 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 827 46th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3   Permit Number 46400 5981668.92819 2110083.30025 37.7728230372839 -122.50685885303 (37.7728230372839, -122.50685885303) 11 6 2 55 26

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);