trees

8,758 rows where qSpecies_id = 16 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)
1303 35175 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   7 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1340 87020 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
1492 20444 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
2323 35205 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   16 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2511 20282 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 20X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2538 20304 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3339 19580 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 8                      
3634 20382 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
3913 35208 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   13 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3997 20436 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 15                      
4295 20447 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
4531 20442 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
4587 35197 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5218 19581 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 8                      
5272 20437 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 15                      
5362 109193 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 4124 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/2015 12:00:00 AM 3 3x3 Permit Number 773525                    
5850 20445 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
6596 20449 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
6911 20443 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
6998 20438 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
7474 35177 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   5 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
8283 19872 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY33 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
8676 34246 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38056                    
9631 35176 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
9856 35210 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   11 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10004 20406 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 51 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
10031 35174 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   8 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10516 102842 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree DPW 1                              
10526 20383 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 29 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
10547 20439 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 15                      
10551 35179 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10979 35203 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   20 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11384 258014 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4222 Moraga Ave 1 Sidewalk: Curb side : Tree DPW 1                              
11690 35212 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   19 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11860 20441 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 15                      
11862 260530 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1790x 46th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
12844 35183 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13065 20384 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 30 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
13515 35181 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   9 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13897 20448 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
14056 20375 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
14273 20403 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 48 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
14818 20309 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
14889 35207 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   14 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
14939 20281 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
15355 20450 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
15456 20376 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
15754 35209 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   12 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15758 260531 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1790x 46th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
16160 20446 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 15                      
16270 35178 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   4 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
16636 35198 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   10 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
17105 20440 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
17110 35180 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
17377 260517 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4711x Lincoln Way 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
17847 20000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY46 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
18187 35206 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   15 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18230 35204 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   18 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18875 46976 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 94122 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM     Permit Number 44996                    
19559 19579 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3                      
46781 90290 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4825X Balboa St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5980449 2110794 37.7747024934985 -122.511131484433 (37.7747024934985, -122.511131484433) 11 6 2 55 26
22814 65028 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4875 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1989 12:00:00 AM 3   Permit Number 26080 5980518.0662 2110908.19812 37.77502012338 -122.510901064292 (37.77502012338, -122.510901064292) 11 6 2 55 26
91851 90291 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4800X Balboa St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5980520.08002 2110961.83438 37.7751675115073 -122.510898085477 (37.7751675115073, -122.510898085477) 11 6 2 55 26
2953 118676 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4825 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5980559.76523 2110909.18852 37.7750253031785 -122.510756894567 (37.7750253031785, -122.510756894567) 11 6 2 55 26
76279 118675 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4825 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5980581.14799 2110910.44383 37.7750300115108 -122.510683021621 (37.7750300115108, -122.510683021621) 11 6 2 55 26
61519 118674 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4825 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5980614.91009 2110910.7476 37.7750328375051 -122.510566255892 (37.7750328375051, -122.510566255892) 11 6 2 55 26
103558 118904 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 701 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5980709.06279 2110874.30302 37.774938325765 -122.510237858768 (37.774938325765, -122.510237858768) 11 6 2 55 26
78192 46282 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 705 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM 5   Permit Number 44561 5980709.06285 2110831.64762 37.7748212066407 -122.510234688625 (37.7748212066407, -122.510234688625) 11 6 2 55 26
186180 46284 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 711 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM 7   Permit Number 44563 5980709.97353 2110788.74424 37.7747034603493 -122.510228350103 (37.7747034603493, -122.510228350103) 11 6 2 55 26
104383 41420 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 725 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM 6 5x5 Permit Number 42027 5980710.81691 2110753.36996 37.7746063827707 -122.510222803918 (37.7746063827707, -122.510222803918) 11 6 2 55 26
113922 41421 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 731A B C La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM 7   Permit Number 42028 5980717.31821 2110693.46667 37.774442289512 -122.51019586344 (37.774442289512, -122.51019586344) 11 6 2 55 26
101064 41422 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 737A B C La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM 7   Permit Number 42029 5980718.37612 2110657.40313 37.7743433320773 -122.510189524011 (37.7743433320773, -122.510189524011) 11 6 2 55 26
46558 41423 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 743A B C La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM 6   Permit Number 42030 5980719.58689 2110639.12886 37.7742932277433 -122.510183977803 (37.7742932277433, -122.510183977803) 11 6 2 55 26
38854 40217 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 755 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1999 12:00:00 AM 9   Permit Number 41396 5980721.24963 2110609.89549 37.7742130596134 -122.51017605379 (37.7742130596134, -122.51017605379) 11 6 2 55 26
134919 46283 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 4801 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44562 5980721.66048407 2110916.40891105 37.7750546792032 -122.510197410494 (37.7750546792032, -122.510197410494) 11 6 2 55 26
153617 118910 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 779 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5980721.87491 2110457.73462 37.7737953076248 -122.510162583557 (37.7737953076248, -122.510162583557) 11 6 2 55 26
148415 118909 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 775 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5980722.52384 2110466.61703 37.7738197343812 -122.510160998907 (37.7738197343812, -122.510160998907) 11 6 2 55 26
124925 118906 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 763 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5980722.84871 2110577.69802 37.7741247491826 -122.510168129734 (37.7741247491826, -122.510168129734) 11 6 2 55 26
59157 118907 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 767 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5980723.00275 2110520.89615 37.7739687970878 -122.510163375859 (37.7739687970878, -122.510163375859) 11 6 2 55 26
47234 118905 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 759 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5980723.1377 2110591.1502 37.7741617019468 -122.51016812974 (37.7741617019468, -122.51016812974) 11 6 2 55 26
98871 118911 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 783 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5980723.51809 2110427.58911 37.7737126338651 -122.510154659499 (37.7737126338651, -122.510154659499) 11 6 2 55 26
87742 118912 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 787 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5980724.35298 2110402.47948 37.7736437394687 -122.510149905624 (37.7736437394687, -122.510149905624) 11 6 2 55 26
120926 118908 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 771 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5980724.52574 2110506.49264 37.7739293391312 -122.510157037335 (37.7739293391312, -122.510157037335) 11 6 2 55 26
45822 118913 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 791 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5980726.27409 2110374.60886 37.7735673282771 -122.51014118926 (37.7735673282771, -122.51014118926) 11 6 2 55 26
63024 118914 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 795 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5980726.65599 2110349.737 37.7734990600053 -122.510138020006 (37.7734990600053, -122.510138020006) 11 6 2 55 26
129300 118915 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 825 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 4x4   5980733.09837 2110116.47079 37.772858959689 -122.510098401613 (37.772858959689, -122.510098401613) 11 6 2 55 26
141530 118918 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 855 La Playa 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5980739.80677 2109948.89302 37.7723992361183 -122.510062744773 (37.7723992361183, -122.510062744773) 11 6 2 55 26
161371 118923 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 855 La Playa 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5980744.20111 2109822.88075 37.7720535026603 -122.510038181246 (37.7720535026603, -122.510038181246) 11 6 2 55 26
167368 118925 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 855 La Playa 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5980744.81689 2109798.23147 37.7719858593014 -122.510034219696 (37.7719858593014, -122.510034219696) 11 6 2 55 26
113108 90287 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4740 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5980821.75322 2110975.07524 37.775221663232 -122.509855533094 (37.775221663232, -122.509855533094) 11 6 2 55 26
24254 186636 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 12 unknown : Yard Tree Private 2     3 Width 0ft   5980864.6099 2105729.0507 37.7608201372164 -122.509317602916 (37.7608201372164, -122.509317602916) 1 8 3 56 35
102296 186625 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 1 unknown : Yard Tree Private 2     2 Width 0ft   5980868.2988 2105582.371 37.7604176144972 -122.50929395155 (37.7604176144972, -122.50929395155) 1 8 3 56 35
47826 186634 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 10 unknown : Yard Tree Private 2     2 Width 0ft   5980874.0957 2105690.7559 37.7607155500113 -122.509281952349 (37.7607155500113, -122.509281952349) 1 8 3 56 35
91321 186519 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1400 Lower Great Hwy 7 unknown : Yard Tree Private 2     3 Width 0ft   5980902.9388 2105057.6001 37.758978786758 -122.509135180581 (37.758978786758, -122.509135180581) 1 8 3 56 35
107456 186508 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1400 Lower Great Hwy 9 unknown : Yard Tree Private 2     3 Width 0ft   5980903.4565 2105112.4796 37.7591295006299 -122.509137465432 (37.7591295006299, -122.509137465432) 1 8 3 56 35
61294 90296 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4725 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5980914.47368 2110921.9769 37.7750813387497 -122.509530853193 (37.7750813387497, -122.509530853193) 11 6 2 55 26
98577 181618 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1396 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5980931.0935 2105583.8021 37.7604252460715 -122.509076883921 (37.7604252460715, -122.509076883921) 1 8 3 56 35
167968 183264 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1396 La Playa 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5980931.0935 2105603.235 37.7604786032233 -122.509078326964 (37.7604786032233, -122.509078326964) 1 8 3 56 35
76858 47887 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1396 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2002 12:00:00 AM     Permit Number 45633 5980936.26532386 2105566.37783375 37.7603777089466 -122.509057703423 (37.7603777089466, -122.509057703423) 1 8 3 56 35
188388 47888 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1396 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2002 12:00:00 AM     Permit Number 45633 5980936.26532386 2105566.37783375 37.7603777089466 -122.509057703423 (37.7603777089466, -122.509057703423) 1 8 3 56 35

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)
);