trees

8,758 rows where qSpecies_id = 16 sorted by Police 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                      
529 131532 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 899 Powell St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009999.72804 2116574.87915 37.7922750033291 -122.409317116588 (37.7922750033291, -122.409317116588) 5 1 10 28857 21
1767 143451 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 501 KEARNY ST 12 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6011460.6008 2116606.6227 37.7924439028882 -122.404264674229 (37.7924439028882, -122.404264674229) 4 1 10 28854 6
1909 72386 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 350 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6012294.64496 2118148.60765 37.7967243955558 -122.401487260038 (37.7967243955558, -122.401487260038) 3 1 10 28860 4
2863 143418 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 575 Kearny St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 0ft   6011374.2644 2116814.4836 37.7930098144506 -122.404578041099 (37.7930098144506, -122.404578041099) 3 1 10 28857 4
3280 131640 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 John Maher St 11 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6012516.39598 2119702.01834 37.8010020586619 -122.400829137966 (37.8010020586619, -122.400829137966) 3 1 10 28860 6
3720 60887 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 847 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/12/1983 12:00:00 AM 11   Permit Number 20671 6008866.49451 2119699.37218 37.8007905345249 -122.413459213167 (37.8007905345249, -122.413459213167) 3 1 10 308 32
4893 131541 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1234 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008553.82207 2116816.41978 37.7928570994281 -122.414337095377 (37.7928570994281, -122.414337095377) 5 1 10 28857 21
5338 121017 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 500 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 4x4   6012098.89577 2117793.01824 37.7957371081465 -122.402139588686 (37.7957371081465, -122.402139588686) 3 1 10 28860 4
5381 131608 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2318 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008064.43802 2120372.10874 37.8025926337993 -122.416282346076 (37.8025926337993, -122.416282346076) 5 1 10 308 32
5496 131655 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 967 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6010169.62149 2116837.55427 37.7930057627679 -122.408747818762 (37.7930057627679, -122.408747818762) 3 1 10 28857 4
6016 96544 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100@ Front St Pine St 1 Sidewalk: Curb side : Pot Tree Private 2   08/29/2019 12:00:00 AM 3   Permit Number 784583 6013029.74558 2116576.80835 37.7924495959214 -122.398833259061 (37.7924495959214, -122.398833259061) 4 1 10 28860 6
7106 72209 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 315 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/2019 12:00:00 AM 3     6011420.02502 2119355.99811 37.7999907575129 -122.404598698471 (37.7999907575129, -122.404598698471) 3 1 10 308 23
7384 131525 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1083 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009580.99158 2117083.07964 37.7936469290112 -122.41080186673 (37.7936469290112, -122.41080186673) 3 1 10 28857 21
9995 60885 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 837 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/12/1983 12:00:00 AM 11   Permit Number 20669 6008911.6951 2119705.40633 37.8008096406195 -122.413303226667 (37.8008096406195, -122.413303226667) 3 1 10 308 32
10735 121071 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 600x Sansome St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012133 2117811 37.7957883852557 -122.402022845886 (37.7957883852557, -122.402022845886) 3 1 10 28860 4
13303 131570 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1287 Filbert St 10 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006804.63948 2119416.06365 37.7998966560617 -122.42057398372 (37.7998966560617, -122.42057398372) 5 1 1 28858 32
13671 131538 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1220 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008566.17109 2116750.0591 37.7926755829578 -122.414289669654 (37.7926755829578, -122.414289669654) 5 1 10 28857 21
13722 72210 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 355 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6011262.40416 2119331.44854 37.7999145399845 -122.405142399827 (37.7999145399845, -122.405142399827) 3 1 10 308 23
14825 131643 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 401 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6011418.06673 2116469.53302 37.7920651105726 -122.404402190312 (37.7920651105726, -122.404402190312) 5 1 10 28857 6
15028 49561 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1081@ JONES Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2003 12:00:00 AM 6   Permit Number 46450 6008771.04283 2115931.16008 37.7904385922178 -122.413522859998 (37.7904385922178, -122.413522859998) 5 1 10 28858 21
16101 131675 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 611 Montgomery St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011754.46444 2117581.93802 37.7951383017382 -122.403316534134 (37.7951383017382, -122.403316534134) 3 1 10 28860 4
18218 60886 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 843 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/12/1983 12:00:00 AM 13   Permit Number 20670 6008888.08032 2119703.02395 37.8008017733536 -122.413384775392 (37.8008017733536, -122.413384775392) 3 1 10 308 32
19659 131672 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 611 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6011746.99968 2117632.88274 37.7952777668047 -122.403345949151 (37.7952777668047, -122.403345949151) 3 1 10 28860 4
19851 41638 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 175 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2000 12:00:00 AM 10 2x2 Permit Number 42116 6008374.70502 2122409.49865 37.808204234292 -122.415352980375 (37.808204234292, -122.415352980375) 3 1 10 308 23
20623 131545 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1338 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008440.0527 2116958.47528 37.7932407574189 -122.414740801944 (37.7932407574189, -122.414740801944) 5 1 10 28858 21
22507 131612 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 747 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008181.61728 2120648.76076 37.8033588390995 -122.415896447887 (37.8033588390995, -122.415896447887) 5 1 10 308 32
23021 48587 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1274 Filbert St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2002 12:00:00 AM 8   Permit Number 45899 6006852.18921 2119472.5707 37.8000544897848 -122.420413456529 (37.8000544897848, -122.420413456529) 5 1 1 28858 32
23600 143158 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 30 MIDWAY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6010085.1488 2121513.3062 37.8058394978516 -122.409370226483 (37.8058394978516, -122.409370226483) 3 1 10 308 23
23726 63984 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2143 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM 14   Permit Number 24730 6008092.26877 2119832.2798 37.801111963901 -122.41614778321 (37.801111963901, -122.41614778321) 5 1 1 308 32
24458 121068 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 600x Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012133 2117811 37.7957883852557 -122.402022845886 (37.7957883852557, -122.402022845886) 3 1 10 28860 4
26766 143192 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 23 MIDWAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010074.2827 2121384.5507 37.8054853584752 -122.409398738098 (37.8054853584752, -122.409398738098) 3 1 10 308 23
27465 131563 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 White St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6007077.34616 2118630.96182 37.7977563289566 -122.419574581498 (37.7977563289566, -122.419574581498) 5 1 10 28858 32
27723 131614 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 382 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6011127.68134 2119363.27633 37.7999943988748 -122.405610836886 (37.7999943988748, -122.405610836886) 3 1 10 308 23
29017 52022 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/14/2005 12:00:00 AM 11   Permit Number 48237 6009069.84074 2115972.98171 37.790570197216 -122.412491992318 (37.790570197216, -122.412491992318) 5 1 10 28858 21
29032 131660 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 41 Sutter St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011947.65308 2115679.83028 37.7899263545528 -122.402514249852 (37.7899263545528, -122.402514249852) 4 1 10 28854 6
29427 68913 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1142 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 7   Permit Number 32891 6007509.40088 2118870.07474 37.7984372002801 -122.418096509773 (37.7984372002801, -122.418096509773) 5 1 10 28858 32
29493 131569 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1287 Filbert St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006787.88073 2119413.83781 37.7998895999842 -122.420631817308 (37.7998895999842, -122.420631817308) 5 1 1 28858 32
29534 62965 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1039 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM     Permit Number 23351 6008055.81561944 2118891.78749794 37.7985275574001 -122.416207279797 (37.7985275574001, -122.416207279797) 5 1 10 28858 21
29696 131663 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 68 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6011757.20298 2115352.24561 37.7890162505571 -122.403150141591 (37.7890162505571, -122.403150141591) 4 1 10 28854 6
30827 131559 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1067 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007926.31383 2118874.38942 37.7984725040564 -122.41665416448 (37.7984725040564, -122.41665416448) 5 1 10 28858 21

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