trees

8,758 rows where qSpecies_id = 16 sorted by Fire Prevention 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                      
65621 193819 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Tulare St 8 Front Yard : Yard Tree Private 2     2     6015080.24684 2100323.56466 37.7479358093949 -122.390602150165 (37.7479358093949, -122.390602150165)   3 8 58 1
112017 193817 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Tulare St 6 Front Yard : Yard Tree Private 2     2     6015100.80126 2100307.8332 37.7478937543942 -122.390529974205 (37.7478937543942, -122.390529974205)   3 8 58 1
116729 193816 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Tulare St 5 Front Yard : Yard Tree Private 2     3     6015118.62426 2100316.39595 37.7479182546422 -122.390468940782 (37.7479182546422, -122.390468940782)   3 8 58 1
174606 193818 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Tulare St 7 Front Yard : Yard Tree Private 2     3     6015085.69798 2100310.3734 37.7478998913736 -122.390582378571 (37.7478998913736, -122.390582378571)   3 8 58 1
408 109629 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 30 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
624 20956 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2000X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984893.4728491 2101578.9445242 37.749661815397 -122.495077729215 (37.749661815397, -122.495077729215) 1 8 3 29491 35
656 37103 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39701 5981201.77477995 2106888.46207069 37.7640234205488 -122.508237579769 (37.7640234205488, -122.508237579769) 1 8 3 56 35
715 67254 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2107 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1994 12:00:00 AM 4   Permit Number 32998 5981675.3208 2100708.9402 37.7470841010946 -122.506141523298 (37.7470841010946, -122.506141523298) 1 8 3 29491 35
850 181731 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2755 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5987133.0103 2107077.382 37.7648898800849 -122.487737334915 (37.7648898800849, -122.487737334915) 1 8 3 56 35
896 184943 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2000 41st Ave 7 Sidewalk: Curb side : Yard Tree Private 2 FUF 12/12/2019 12:00:00 AM 3 3x10   5983552 2101519 37.7494185989562 -122.499712087956 (37.7494185989562, -122.499712087956) 1 8 3 29491 35
915 40138 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1501 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1979 12:00:00 AM 12   Permit Number 41341 5982776.0706 2104863.9918 37.7585574465855 -122.502642786425 (37.7585574465855, -122.502642786425) 1 8 3 56 35
1001 70458 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3222 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5982856.1897 2099504.4786 37.74384642674 -122.501969135738 (37.74384642674, -122.501969135738) 1 8 3 29491 35
1188 186259 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1800 Sunset Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 0ft   5984936.3948 2102583.754 37.7524232591449 -122.495003387226 (37.7524232591449, -122.495003387226) 1 8 3 56 35
1307 184338 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Sunset Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 0ft   5984829.2872 2105764.6569 37.7611508651334 -122.495608375429 (37.7611508651334, -122.495608375429) 1 8 3 56 35
1368 184450 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2127 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5982917.6673 2100633.8105 37.7469508716588 -122.501840104956 (37.7469508716588, -122.501840104956) 1 8 3 29491 35
1394 60245 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2501 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/1982 12:00:00 AM 15   Permit Number 19797 5987888.319 2107103.366 37.7650052514475 -122.485126853783 (37.7650052514475, -122.485126853783) 1 8 3 56 35
1440 60253 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1258 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/1982 12:00:00 AM 12   Permit Number 19805 5988032.4773 2106727.2678 37.7639809852919 -122.484600662652 (37.7639809852919, -122.484600662652) 1 8 3 56 35
1458 97747 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2685 30th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18001 5986960.2 2097027.9 37.7372866359421 -122.487596715706 (37.7372866359421, -122.487596715706) 1 8 3 29491 35
1485 70364 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4039 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5982287.6338 2104871.478 37.7585492864556 -122.504332547004 (37.7585492864556, -122.504332547004) 1 8 3 56 35
1542 261489 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1100X Portola Dr 3 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
1610 60248 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1238 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/1982 12:00:00 AM 14   Permit Number 19800 5988026.3501 2106852.875 37.7643255113996 -122.48463106882 (37.7643255113996, -122.48463106882) 1 8 3 56 35
1621 71826 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1559 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5988678.2006 2104711.6203 37.7584841471685 -122.482219640193 (37.7584841471685, -122.482219640193) 1 8 3 56 35
1874 78526 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3550 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5981863.3141 2099471.5008 37.7436975019585 -122.505399764525 (37.7436975019585, -122.505399764525) 1 8 3 29491 35
1894 185385 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2300 Sunset Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5985055.3332 2099090.1134 37.7428376362899 -122.494334586063 (37.7428376362899, -122.494334586063) 1 8 3 29491 35
1974 114892 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2226 45TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777232 5982390 2099932 37.7449928846436 -122.503612737002 (37.7449928846436, -122.503612737002) 1 8 3 29491 35
2021 40151 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1232 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/2000 12:00:00 AM 1   Permit Number 43635 5982132.3748 2106725.7272 37.7636313927747 -122.505006903253 (37.7636313927747, -122.505006903253) 1 8 3 56 35
2124 209922 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 870 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990546.69569 2099087.99208 37.7431516445476 -122.475347038257 (37.7431516445476, -122.475347038257) 1 8 4 29491 40
2228 48000 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1901 16th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45728 5991233.33873947 2102463.46573508 37.752459596695 -122.47321895744 (37.752459596695, -122.47321895744) 1 8 4 29491 12
2361 256460 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 9 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
2373 183738 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2271 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2 FUF 09/26/2020 12:00:00 AM 3 4x6   5985432.7595 2099768.105 37.7447212985473 -122.493079504102 (37.7447212985473, -122.493079504102) 1 8 3 29491 35
2425 31630 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2482 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35147 5981478.22688702 2098193.22560061 37.7401650446812 -122.506636494986 (37.7401650446812, -122.506636494986) 1 8 3 29491 35
2547 38368 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4245 Lawton St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1998 12:00:00 AM 3   Permit Number 40431 5981092.1865 2104150.2665 37.7564986636188 -122.508413331792 (37.7564986636188, -122.508413331792) 1 8 3 56 35
2639 210264 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201 Irving St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991895.36421 2106557.41103 37.7637388043301 -122.471227833003 (37.7637388043301, -122.471227833003) 1 8 11 56 12
2663 181722 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2645 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987446.5903 2107090.374 37.764943837931 -122.486653709544 (37.764943837931, -122.486653709544) 1 8 3 56 35
2680 71821 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1270 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5988034.775 2106656.0393 37.7637855451579 -122.484587490638 (37.7637855451579, -122.484587490638) 1 8 3 56 35
2926 183551 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5989202.4612 2097677.5503 37.7392009295048 -122.479891799473 (37.7392009295048, -122.479891799473) 1 8 3 29491 35
3036 258017 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2342 43rd Ave 1 Sidewalk: Curb side : Tree DPW 1     3     5983011.19804 2099184.33916 37.7429765166721 -122.501409485055 (37.7429765166721, -122.501409485055) 1 8 3 29491 35
3318 185278 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984958.2606 2097437.8471 37.7382952768032 -122.49454845339 (37.7382952768032, -122.49454845339) 1 8 3 29491 35
3401 21158 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2300X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984964.3463827 2099540.4551822 37.7440688278009 -122.494682382207 (37.7440688278009, -122.494682382207) 1 8 3 29491 35
3432 60254 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1282 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/1982 12:00:00 AM 13   Permit Number 19806 5988036.3068 2106574.0882 37.7635606190909 -122.484576181107 (37.7635606190909, -122.484576181107) 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)
);