5,723 rows where qSpecies_id = 14 sorted by Location

View and edit SQL

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)
530 35187 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
871 259735 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 100x Florida St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/09/2018 12:00:00 AM 3                        
1259 34123 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
2108 35196 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2267 46716 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
2483 34134 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
2566 35200 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2583 34124 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
2961 35202 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3005 109931 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2822 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775171                    
3130 34137 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
3632 34115 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37978                    
3795 35211 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   8 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3829 35184 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3908 36856 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
3983 34122 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
4027 46718 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
4338 259737 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 100x Florida St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/09/2018 12:00:00 AM 3                        
4864 47038 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 716 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM     Permit Number 45030                    
5168 35201 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5297 35195 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   9 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5998 36865 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   10 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6031 34117 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
6187 85268 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
6405 34118 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
6689 259736 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 100x Florida St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/09/2018 12:00:00 AM 3                        
6696 36862 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   7 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
7861 34464 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1521 Ralston Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
8052 34462 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1521 Ralston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
8248 36860 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
8338 34101 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
8522 34103 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
8698 260238 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1401x Quintara St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
8724 258144 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Woolsey St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
8853 34116 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
9048 35190 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   14 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
9202 36861 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   6 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
9209 46152 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
9782 34132 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
9838 34102 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
10067 88529 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14     Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51479                    
10288 34120 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
10337 36866 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
10342 251266 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10x Paloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2                              
10774 34136 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
10816 36858 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
10831 35192 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   12 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11187 36874 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   11 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11279 34466 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1521 Ralston Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
11508 36864 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
12097 46717 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
12347 46713 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
12428 46715 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   4 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
12477 50776 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
12490 47039 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 771 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM     Permit Number 45031                    
12680 34135 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
12730 34138 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
12866 85267 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
13038 34133 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
13270 50775 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
13633 35194 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   10 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13814 34461 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1521 Ralston Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
13994 34100 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
14350 258500 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1177 Brussels St 2 Sidewalk: Curb side : Cutout Tree DPW 1                              
14417 34463 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1521 Ralston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
14536 35191 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   13 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
14711 258145 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Woolsey St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
14758 34114 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37978                    
15142 34465 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1521 Ralston Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
15233 109923 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 214 state st 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15407 35199 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   4 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15727 35188 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   16 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15763 35185 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   19 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15777 35189 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   15 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15800 35182 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   7 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
16219 46153 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
16509 34121 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
16822 258142 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Woolsey St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
16839 36857 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
17208 50777 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47304                    
17254 46714 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   6 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
17346 85269 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Edinburgh St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
17460 253167 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Brotherhood Way 1 Front Yard : Yard Tree DPW 1                              
17594 254853 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 799 Avalon Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/29/2018 12:00:00 AM 3 3x3 Permit Number 781645                    
17825 35193 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   11 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18801 34119 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
19047 35186 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   18 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
19117 36863 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   8 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
19130 85270 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000 Edinburgh St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
19248 47040 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 771 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM     Permit Number 45031                    
19488 36859 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
16673 71598 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 126 Wilson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5994743.91592 2086305.62835 37.7082967566677 -122.459908520573 (37.7082967566677, -122.459908520573) 9 8 6 28861 25
187058 53003 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 88@ GENEVA Pasadena St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 4   Permit Number 48983 6006543.04417 2086136.95976 37.708505157469 -122.419117357192 (37.708505157469, -122.419117357192) 9 7 8 309 39
1769 251583 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM   3x3   5995352 2086409 37.7086155444167 -122.457814401925 (37.7086155444167, -122.457814401925) 9 7 6 28861 25
59333 73959 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM 4 2x4 Permit Number 773591 5995358.56494273 2086411.36688337 37.7086224204841 -122.457791883945 (37.7086224204841, -122.457791883945) 9 7 6 28861 25
190879 71596 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM 12 2x3   5995358.56494273 2086411.36688337 37.7086224204841 -122.457791883945 (37.7086224204841, -122.457791883945) 9 7 6 28861 25
26619 115723 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 147 Baltimore Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2016 12:00:00 AM 3   Permit Number 775898 6002684.2 2086288.6 37.7087034632659 -122.432464808573 (37.7087034632659, -122.432464808573) 9 7 6 28861 5
65816 25774 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2027 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/1997 12:00:00 AM 16 2x3   6005967.11892 2086230.65451 37.7087299735811 -122.421114477163 (37.7087299735811, -122.421114477163) 9 7 8 309 39
13437 71606 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 182 Wilson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     5994495.51543 2086527.6412 37.708892062899 -122.460783093263 (37.708892062899, -122.460783093263) 9 8 6 28861 25
128847 25775 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1965 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/07/1997 12:00:00 AM 16 2X3   6005734.23372 2086319.0681 37.708959607374 -122.42192563688 (37.708959607374, -122.42192563688) 9 7 8 309 39

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