trees

8,758 rows where qSpecies_id = 16 sorted by Zip Codes

✎ 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                      
1237 35474 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38887 6007396.82109854 2112616.81920427 37.7812609627381 -122.418042529741 (37.7812609627381, -122.418042529741) 7 9 9 28852 36
5054 102983 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 555 Turk St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
8148 7734 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Franklin St 5 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3x3   6006417.36011 2111247.60822 37.777446266458 -122.421333726477 (37.777446266458, -122.421333726477) 7 9 11 28852 10
8332 131472 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 280 Redwood St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006289.44845 2112330.99569 37.7804137729253 -122.421853191093 (37.7804137729253, -122.421853191093) 7 9 11 28852 41
9864 102975 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 555 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
12583 131471 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 280 Redwood St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6006315.87363 2112335.20118 37.7804268103756 -122.421762072675 (37.7804268103756, -122.421762072675) 7 9 11 28852 41
12589 142807 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 560 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6007175.9825 2112820.8168 37.7818086588347 -122.418820996316 (37.7818086588347, -122.418820996316) 7 9 9 28852 36
12713 131502 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 599 Turk St 8 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6007471.98595 2112970.25265 37.7822356356972 -122.417807555783 (37.7822356356972, -122.417807555783) 7 9 9 28852 36
13287 75339 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 288 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15   Permit Number 768105 6009126.26844 2113603.03631 37.7840660654432 -122.41212919142 (37.7840660654432, -122.41212919142) 14 10 9 28852 36
13314 75092 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 288 Eddy St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     16     6009056.34359 2113588.95965 37.7840234906369 -122.412370111692 (37.7840234906369, -122.412370111692) 14 10 9 28852 36
13455 131485 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 75 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008130.48281 2112560.90329 37.7811486961987 -122.415500453895 (37.7811486961987, -122.415500453895) 7 10 9 28852 36
13790 35470 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM 7   Permit Number 38887 6007482.79504 2112627.10573 37.7812940455214 -122.417745830826 (37.7812940455214, -122.417745830826) 7 9 9 28852 36
14869 117019 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.415562303882 (37.782365960952, -122.415562303882) 7 10 9 28852 36
15379 71911 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 54 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6008864.22373 2112520.03206 37.7810776884121 -122.41295917575 (37.7810776884121, -122.41295917575) 7 10 9 28852 36
15753 138822 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 628 IVY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004336.8563 2111016.0726 37.7766930096288 -122.428514368993 (37.7766930096288, -122.428514368993) 7 9 11 28852 10
17268 131440 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 333 O'Farrell St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009774.26155 2114331.48798 37.786102556832 -122.409938800836 (37.786102556832, -122.409938800836) 14 10 9 28852 36
18023 131424 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009313.39675 2114526.95981 37.7866134356058 -122.411547091752 (37.7866134356058, -122.411547091752) 5 10 9 28852 36
21229 131496 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 599 Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6007241.99076 2112941.14333 37.7821427627223 -122.418601173323 (37.7821427627223, -122.418601173323) 7 9 9 28852 36
22001 131467 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009403.87507 2114189.54444 37.7856920487042 -122.411210213779 (37.7856920487042, -122.411210213779) 14 10 9 28852 36
23409 131466 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009408.26069 2114164.04859 37.7856222891685 -122.411193239081 (37.7856222891685, -122.411193239081) 14 10 9 28852 36
23755 131459 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 240 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009644.27123 2114020.47093 37.7852412922998 -122.410366566079 (37.7852412922998, -122.410366566079) 14 10 9 28852 36
24037 108406 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 99x Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM 12 3x3 Permit Number 773269 6008120.84483 2112658.906 37.7814172463574 -122.415540737233 (37.7814172463574, -122.415540737233) 7 10 9 28852 36
25091 131498 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 599 Turk St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6007304.36965 2112951.80978 37.7821755618839 -122.418386126541 (37.7821755618839, -122.418386126541) 7 9 9 28852 36
25961 131487 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 25 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008138.00266 2112507.8131 37.7810033459583 -122.415470679129 (37.7810033459583, -122.415470679129) 7 10 9 28852 36
26488 131481 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 333 Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6007948.96937 2112696.20303 37.7815099925299 -122.41613798689 (37.7815099925299, -122.41613798689) 7 10 9 28852 36
27712 131499 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 599 Turk St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6007343.63427 2112952.09091 37.782178544034 -122.418250308228 (37.782178544034, -122.418250308228) 7 9 9 28852 36
27825 131512 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 270 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006101.39727 2110910.32308 37.7765023443558 -122.422402776687 (37.7765023443558, -122.422402776687) 7 9 11 28852 10
29125 39233 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1998 12:00:00 AM 7   Permit Number 40872 6007554.12985 2112694.05006 37.7814818725203 -122.417503792676 (37.7814818725203, -122.417503792676) 7 9 9 28852 36
30046 142809 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 580 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6007168.5268 2112869.7338 37.7819425532526 -122.418850259969 (37.7819425532526, -122.418850259969) 7 9 9 28852 36
31070 35471 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM 6   Permit Number 38887 6007305.09171 2112609.40179 37.7812354331103 -122.418359342935 (37.7812354331103, -122.418359342935) 7 9 9 28852 36
31935 142818 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 401 LARKIN ST 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6007650.4228 2112555.8649 37.7811078670394 -122.417160869916 (37.7811078670394, -122.417160869916) 7 9 9 28852 36
33816 131425 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009315.55993 2114505.81114 37.7865554877808 -122.411538112901 (37.7865554877808, -122.411538112901) 5 10 9 28852 36
33897 100566 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34017 100567 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34982 131464 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009434.78586 2113997.38762 37.7851661656211 -122.411089692961 (37.7851661656211, -122.411089692961) 14 10 9 28852 36
35028 131428 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 288 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6009144.41838 2113602.23472 37.7840648828302 -122.412066342288 (37.7840648828302, -122.412066342288) 14 10 9 28852 36
35135 120974 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 399 Golden Gate Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     5     6007869.23939 2112684.22363 37.781472616699 -122.416412966282 (37.781472616699, -122.416412966282) 7 10 9 28852 36
35989 131436 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 333 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009459.94739 2114292.46733 37.7859777947778 -122.411023491147 (37.7859777947778, -122.411023491147) 14 10 9 28852 36
37174 7732 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Franklin St 3 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3x3   6006424.96145 2111194.8411 37.7773018092612 -122.421303682828 (37.7773018092612, -122.421303682828) 7 9 11 28852 10
39285 131475 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 440 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6007218.68142 2112511.52333 37.7809618179646 -122.418651337495 (37.7809618179646, -122.418651337495) 7 9 9 28852 36

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