trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
530 35187 7 14   17 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
871 259735 1 14 100x Florida St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 06/09/2018 12:00:00 AM 3                        
1259 34123 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
2108 35196 7 14   5 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2267 46716 7 14   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
2483 34134 7 14   5 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
2566 35200 7 14   3 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2583 34124 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
2961 35202 7 14   1 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3005 109931 7 14 2822 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775171                    
3130 34137 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
3632 34115 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37978                    
3795 35211 7 14   8 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3829 35184 7 14   6 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3908 36856 7 14   2 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
3983 34122 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
4027 46718 7 14   1 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
4338 259737 1 14 100x Florida St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 06/09/2018 12:00:00 AM 3                        
4864 47038 7 14 716 Walter St 1 Sidewalk: Curb side : Cutout Tree 2   05/02/2002 12:00:00 AM     Permit Number 45030                    
5168 35201 7 14   2 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5297 35195 7 14   9 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5998 36865 7 14   10 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6031 34117 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
6187 85268 7 14 1000 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
6405 34118 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
6689 259736 1 14 100x Florida St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/09/2018 12:00:00 AM 3                        
6696 36862 7 14   7 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
7861 34464 7 14 1521 Ralston Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
8052 34462 7 14 1521 Ralston Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
8248 36860 7 14   5 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
8338 34101 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
8522 34103 7 14   4 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
8698 260238 1 14 1401x Quintara St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
8724 258144 1 14 1000 Woolsey St 2 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
8853 34116 7 14   3 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
9048 35190 7 14   14 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
9202 36861 7 14   6 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
9209 46152 7 14   2 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
9782 34132 7 14   3 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
9838 34102 7 14   3 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
10067 88529 7 14     Sidewalk: Curb side : Cutout Tree 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51479                    
10288 34120 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
10337 36866 7 14   12 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
10342 251266 1 14 10x Paloma Ave 1 Sidewalk: Curb side : Cutout Tree 2                              
10774 34136 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
10816 36858 7 14   3 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
10831 35192 7 14   12 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11187 36874 7 14   11 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11279 34466 7 14 1521 Ralston Ave 5 Sidewalk: Curb side : Cutout Tree 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
11508 36864 7 14   9 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
12097 46717 7 14   2 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
12347 46713 7 14   5 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
12428 46715 7 14   4 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
12477 50776 7 14   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47304                    
12490 47039 7 14 771 Walter St 1 Sidewalk: Curb side : Cutout Tree 2   05/02/2002 12:00:00 AM     Permit Number 45031                    
12680 34135 7 14   4 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
12730 34138 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
12866 85267 7 14 1000 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
13038 34133 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
13270 50775 7 14   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47304                    
13633 35194 7 14   10 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13814 34461 7 14 1521 Ralston Ave 6 Sidewalk: Curb side : Cutout Tree 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
13994 34100 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
14350 258500 1 14 1177 Brussels St 2 Sidewalk: Curb side : Cutout Tree 1                              
14417 34463 7 14 1521 Ralston Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
14536 35191 7 14   13 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
14711 258145 1 14 1000 Woolsey St 3 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
14758 34114 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37978                    
15142 34465 7 14 1521 Ralston Ave 4 Sidewalk: Curb side : Cutout Tree 2   07/15/1997 12:00:00 AM     Permit Number 38201                    
15233 109923 4 14 214 state st 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15407 35199 7 14   4 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15727 35188 7 14   16 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15763 35185 7 14   19 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15777 35189 7 14   15 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15800 35182 7 14   7 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
16219 46153 7 14   1 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
16509 34121 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
16822 258142 1 14 1000 Woolsey St 1 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
16839 36857 7 14   1 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
17208 50777 7 14   3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47304                    
17254 46714 7 14   6 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
17346 85269 7 14 1000 Edinburgh St 3 Sidewalk: Curb side : Cutout Tree 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
17460 253167 1 14 1X Brotherhood Way 1 Front Yard : Yard Tree 1                              
17594 254853 7 14 799 Avalon Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 03/29/2018 12:00:00 AM 3 3x3 Permit Number 781645                    
17825 35193 7 14   11 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18801 34119 7 14   3 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
19047 35186 7 14   18 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
19117 36863 7 14   8 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
19130 85270 7 14 1000 Edinburgh St 4 Sidewalk: Curb side : Cutout Tree 2   07/24/2007 12:00:00 AM     Permit Number 49560                    
19248 47040 7 14 771 Walter St 2 Sidewalk: Curb side : Cutout Tree 2   05/02/2002 12:00:00 AM     Permit Number 45031                    
19488 36859 7 14   4 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
1640 138208 1 14 65 Nido Ave 4 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   5999218.5995 2112143.8745 37.7794986921677 -122.446301010953 (37.7794986921677, -122.446301010953) 15 5 1 54 16
1782 39916 1 14 2107 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/25/1999 12:00:00 AM 4   Permit Number 41193 6001859.33399 2115759.57552 37.7895769481743 -122.437424588992 (37.7895769481743, -122.437424588992) 13 6 1 29490 27
2167 18043 1 14 2817 Pine St 1 Sidewalk: Curb side : Cutout Tree 2   05/25/2011 12:00:00 AM 6 3x3   6000257.4375 2114746.9392 37.7867053122561 -122.442894218022 (37.7867053122561, -122.442894218022) 13 6 1 29490 27
2346 114557 1 14 2775 Green St 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3   5999783.32875 2117736.28966 37.7948862424707 -122.444749467237 (37.7948862424707, -122.444749467237) 13 9 1 57 27
3252 35926 1 14 2660 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773492 6001423.81293 2116968.31873 37.7928710739952 -122.439018105808 (37.7928710739952, -122.439018105808) 13 6 1 29490 27
4033 42686 1 14 2340 Larkin St 1 Sidewalk: Curb side : Cutout Tree 2   03/16/2011 12:00:00 AM 3   Permit Number 767586 6006754.35737 2119313.32094 37.7996117166702 -122.420740681136 (37.7996117166702, -122.420740681136) 5 9 1 28858 32
4473 125611 1 14 400 Euclid Ave 2 Sidewalk: Property side : Yard Tree 2     2 Width 6ft   5997327.18214 2113882.6625 37.7841647426444 -122.452969739277 (37.7841647426444, -122.452969739277) 15 6 1 54 31
5202 125631 1 14 2501 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6001359.406 2116583.78778 37.7918115871761 -122.439213382799 (37.7918115871761, -122.439213382799) 13 6 1 29490 27
5263 124698 1 14 451 Cherry St 2 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5996218.82946 2114740.21668 37.7864557780408 -122.456866265371 (37.7864557780408, -122.456866265371) 11 6 1 54 31
5906 250614 1 14 107 28th Ave 1 Sidewalk: Curb side : Yard Tree 2   08/08/2019 12:00:00 AM 3 Width 4ft   5987083.69063 2115313.12063 37.7875000169526 -122.4885132614 (37.7875000169526, -122.4885132614) 11 6 1 55 33