trees

8,758 rows where qSpecies_id = 16 sorted by Supervisor Districts

✎ 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                      
682 16784 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1961 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   5999039.4234543 2112720.6314145 37.781072082708 -122.446962370058 (37.781072082708, -122.446962370058) 15 5 1 54 16
1147 131409 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2817 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6003467.33625 2118170.97636 37.796289323341 -122.432033340382 (37.796289323341, -122.432033340382) 13 9 1 57 17
1201 2190 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1055 Broderick St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6000864.0909 2112351.4116 37.7801623757286 -122.440623460362 (37.7801623757286, -122.440623460362) 15 5 1 29490 41
1667 101664 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1677 259282 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3891 Sacramento St 5 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
1966 61296 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2360 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1986 12:00:00 AM 9   Permit Number 23055 6006748.00387 2119357.01746 37.7997313381808 -122.420765770421 (37.7997313381808, -122.420765770421) 5 9 1 28858 32
2051 250522 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 95 26th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 6ft   5987685.78964 2115424.25577 37.7878402763649 -122.486438309599 (37.7878402763649, -122.486438309599) 11 6 1 55 33
2162 250415 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/14/2020 12:00:00 AM 3 Width 4ft   5987895.18737 2115830.32518 37.7889674299609 -122.485743656163 (37.7889674299609, -122.485743656163) 11 6 1 55 33
2401 75310 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Vega St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     5999369.874 2112377.7239 37.7801494207177 -122.445794512547 (37.7801494207177, -122.445794512547) 15 5 1 54 16
2422 80046 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2325 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6001817.74148 2118715.85745 37.7976917657091 -122.437780314931 (37.7976917657091, -122.437780314931) 13 9 1 57 17
2518 250436 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 98 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   5987616.8568 2115817.96032 37.7889172576592 -122.486705722111 (37.7889172576592, -122.486705722111) 11 6 1 55 33
2749 60098 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3349 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/19/1982 12:00:00 AM 12   Permit Number 19599 5998205.44012 2116147.0262 37.7904323787895 -122.450094557236 (37.7904323787895, -122.450094557236) 13 6 1 54 31
2971 250510 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 75 27th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 5ft   5987308.66603 2115522.71145 37.7880886178397 -122.487750306256 (37.7880886178397, -122.487750306256) 11 6 1 55 33
3003 131309 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Maple St 2 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5996544.36803 2115871.17754 37.7895797810398 -122.455821775454 (37.7895797810398, -122.455821775454) 11 6 1 54 31
3317 75134 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Vega St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5999276.808 2112366.556 37.7801134423261 -122.44611566553 (37.7801134423261, -122.44611566553) 15 5 1 54 16
3424 116715 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2817 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5999908.2786 2114349.9787 37.7855954495545 -122.444073686604 (37.7855954495545, -122.444073686604) 15 6 1 29490 31
3650 72105 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3024 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5997692.6555 2113106.1769 37.7820536550082 -122.451649308253 (37.7820536550082, -122.451649308253) 15 6 1 54 31
3825 263630 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1020 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000550 2112598 37.7808215534457 -122.441727743189 (37.7808215534457, -122.441727743189) 15 5 1 29490 16
3859 75387 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Vega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5999425.0368 2112388.5534 37.7801823052034 -122.445604458946 (37.7801823052034, -122.445604458946) 15 5 1 54 16
3921 12687 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1330 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     50 3X3   5991313.40727 2114800.59643 37.7863386650766 -122.473842035632 (37.7863386650766, -122.473842035632) 11 6 1 54 33
4017 250443 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 120 Seacliff Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5987542.94428 2115793.76045 37.7888465026131 -122.486959668166 (37.7888465026131, -122.486959668166) 11 6 1 55 33
4111 131305 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 401 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 6ft   5997155.69751 2115003.89282 37.7872335145555 -122.453644000576 (37.7872335145555, -122.453644000576) 11 6 1 54 31
4193 66459 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 26 Wood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM 12   Permit Number 29609 5998393.1041 2113638.7682 37.7835561003446 -122.449264468811 (37.7835561003446, -122.449264468811) 15 6 1 54 31
5115 260959 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 400 Cherry St 11 Sidewalk: Property side : Yard Tree Private 2       Width 9ft   5996243 2114742 37.7864620624436 -122.456782770891 (37.7864620624436, -122.456782770891) 11 6 1 54 31
5354 8706 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3100 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5997482.4956 2113078.7647 37.7819663504933 -122.452374383353 (37.7819663504933, -122.452374383353) 15 6 1 54 31
5512 259281 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3891 Sacramento St 4 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
5611 139705 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 301 Saint Joseph's Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000476.8247 2113129.5897 37.7822769928429 -122.442019059209 (37.7822769928429, -122.442019059209) 15 5 1 29490 16
5620 250454 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 200 Seacliff Ave 1 : Tree Private 2     9 Width 4ft   5987161.73503 2115752.97281 37.7887122778945 -122.488275583153 (37.7887122778945, -122.488275583153) 11 6 1 55 33
5672 250483 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 475 Seacliff Ave 6 : Tree Private 2     7 Width 2ft   5986409.29286 2115158.05614 37.7870348804072 -122.490835095073 (37.7870348804072, -122.490835095073) 11 6 1 55 33
5810 111954 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 73 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     24     5987709 2115789 37.7888431121968 -122.486384796167 (37.7888431121968, -122.486384796167) 11 6 1 55 33
6563 71813 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3353 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5998192.69497 2116144.55888 37.7904248748608 -122.450138476504 (37.7904248748608, -122.450138476504) 13 6 1 54 31
6571 94972 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 230 Seacliff Ave 4 Sidewalk: Curb side : Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53388 5987086.7 2115743.7 37.7886824393648 -122.488534508212 (37.7886824393648, -122.488534508212) 11 6 1 55 33
6828 131262 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2711 Union St 2 Front Yard : Cutout Tree DPW 1     8 3x3 Permit Number 785082 6000010.78683 2118118.88771 37.7959497330364 -122.443989935801 (37.7959497330364, -122.443989935801) 13 9 1 57 17
8514 250400 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 15 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5988097.76743 2115798.38338 37.7888915289683 -122.485040420476 (37.7888915289683, -122.485040420476) 11 6 1 55 33
8762 97574 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 501x Presidio Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           5999116.8 2114959.9 37.7872249510267 -122.4468558657 (37.7872249510267, -122.4468558657) 15 6 1 54 31
9040 3086 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2925 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   6000198.2675 2115085.6403 37.7876319239021 -122.443123265692 (37.7876319239021, -122.443123265692) 13 6 1 29490 27
9076 9908 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1809 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 6x6   6005225.98494 2115998.17525 37.7904229062421 -122.425793311632 (37.7904229062421, -122.425793311632) 13 9 1 28858 27
9336 131379 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2990 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5999358.44425 2117025.78745 37.7929111360792 -122.446168490398 (37.7929111360792, -122.446168490398) 13 9 1 57 27
9491 72305 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3662 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5997266.67895 2115407.36737 37.7883477098214 -122.453289170381 (37.7883477098214, -122.453289170381) 11 6 1 54 31
9679 111947 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 95 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     30     5987570 2115773 37.7887910778243 -122.486864535179 (37.7887910778243, -122.486864535179) 11 6 1 55 33

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