sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3322 44559 1 17   16 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3393 33932 1 17   1 1 1 1   03/25/1997 12:00:00 AM     Permit Number 37893          
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
3395 46141 1 11   4 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44490          
3403 19880 3 198 100 STAIRWAY33 12 1 1 2     6 25ST            
3408 44959 1 17   72 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
3420 35199 1 12   4 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3444 48277 1 17   87 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3448 48107 1 17   202 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3458 44636 1 17   164 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3465 39926 1 58 0 Arleta Ave 4 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41198          
3486 39483 1 41 0 19th St 3 1 1 1   12/28/1998 12:00:00 AM     Permit Number 40941          
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3539 46147 1 11   1 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44490          
3543 44857 1 17   31 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
3545 43015 1 68   1 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3571 39975 1 5 0 Steiner St 1 1 1 1         Permit Number 41235          
3586 253468 3 213 801X Alemany Blvd 1 17 1 2                    
3610 115725 2 198 250X Octavia St 2 17 1 5                    
3614 46882 1 17   1 1 1 1   04/26/2002 12:00:00 AM     Permit Number 44940          
3622 34463 1 12 1521 Ralston Ave 2 1 1 1   07/15/1997 12:00:00 AM     Permit Number 38201          
3636 64705 1 17 252 Walker Ct 1 1 1 1   10/19/1988 12:00:00 AM     Permit Number 25649          
3663 36860 1 12   5 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
3668 43018 1 68   3 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3695 57738 1 17 1999 So. Bascom Ave 1 1 1 1   12/28/1976 12:00:00 AM     Permit Number 16656          
3716 20054 3 42 100 STAIRWAY54 1 1 1 2     6 15ST            
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
3744 46296 1 33   13 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
3751 45854 1 17   71 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
3765 45857 1 17   4 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
3819 19829 3 5 100 STAIRWAY25 13 1 1 2     6 60X            
3821 46195 1 21   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
3838 48141 1 17   251 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3857 19783 3 102 100 STAIRWAY19 5 1 1 2     6 50ST            
3864 44703 1 17   40 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
3875 48176 1 17   57 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3884 20320 3 103 101X Sunset Blvd 9 1 1 2     42 60            
3909 48174 1 17   67 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
3965 253596 1 17 198X Brussels St 1 1 1 1   10/04/2017 12:00:00 AM 3 3x3 Permit Number 780230          
3979 19911 3 34 100 STAIRWAY35 7 1 1 2     12 120ST            
4009 34002 1 15   1 1 1 1         Permit Number 37940          
4012 252965 5 82 115X Whipple Ave 1 1 1 1   10/05/2017 02:04:00 PM 3              
4038 45886 1 17   1 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4053 45907 1 17   62 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
4084 45961 1 17   162 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4085 101532 2 17 11323 Palou Ave 1 1 1 1       3x3            
4106 20001 3 198 100 STAIRWAY46 21 1 1 2     6 2            
4133 48248 1 17   112 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4171 39901 1 15   3 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
4187 20426 3 3 453X Sunset Blvd 15 1 1 2     12 60            
4215 118354 3 109 100X Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 3              
4222 253622 2 128 300x Naglee Ave   14 1 1                    
4256 44534 1 17   35 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4260 20045 3 3 100 STAIRWAY52 1 1 1 2     12 10            
4277 19665 3 203 100 STAIRWAY5 64 1 1 2     18 60ST            
4347 45877 1 17   31 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4351 36746 1 16 5555 Woodward St 1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39516          
4353 20010 3 105 100 STAIRWAY47 19 1 1 2     12 100ST            
4374 118351 3 109 100X Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 3              
4378 45905 1 17   35 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4435 34068 1 68 955 Kennedy Ave 2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
4441 35439 1 11 757 Peninsula Ave 4 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38882          
4443 67752 1 17 2281 Gates St 1 1 1 1   12/04/1992 12:00:00 AM     Permit Number 31376          
4452 19593 3 116 100 STAIRWAY4 16 1 1 2     3 60            
4482 20388 3 3 262X Sunset Blvd 34 1 1 2     24 60            
4492 44688 1 17   108 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4519 46000 1 17   118 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4528 19968 3 3 100 STAIRWAY43 1 1 1 2     12 15            
4531 48083 1 17   193 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4552 97357 1 17   7 14 1 1                    
4555 253633 1 37 1907 Judah St 1 1 1 1 1 01/21/2016 12:00:00 AM   3x3 Permit Number 777409          
4576 60252 1 17   1 1 1 1   08/23/1982 12:00:00 AM     Permit Number 19804          
4629 34972 1 155   3 1 1 1   12/18/1997 12:00:00 AM     Permit Number 38555          
4714 44605 1 17   148 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4741 48244 1 17   122 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
4747 253677 6 71 199X Kissling St 1 18 1 1       5x10            
4774 44595 1 17   150 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
4823 45930 1 17   41 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
4831 44933 1 17   166 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
4834 50011 1 44 99@ 20TH ST Tennessee St 1 1 1 1   07/25/2003 12:00:00 AM     Permit Number 46742          
4862 19656 3 36 100 STAIRWAY5 55 1 1 2     18 60ST            
4880 253705 4 49 98X Shotwell St 2 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4889 253706 4 49 98X Shotwell St 3 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4913 97358 1 17   8 14 1 1                    
4975 47475 1 11   1 1 1 1   05/14/2002 12:00:00 AM     Permit Number 45375          
4991 35276 1 17   3 1 1 1   02/17/1998 12:00:00 AM     Permit Number 38758          
4995 20353 3 181 262X Sunset Blvd 3 1 1 2     6 60            
5018 44607 1 17   171 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
5082 19803 3 176 100 STAIRWAY22 2 1 1 2     6 20            
5109 36635 1 21   10 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5121 45851 1 17   74 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
5128 44995 1 17   107 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5147 48270 1 17   94 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5156 44926 1 17   199 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5203 46584 1 52 2790 York St 1 1 1 1   04/05/2002 12:00:00 AM     Permit Number 44712          
5208 48263 1 17   127 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
Powered by Datasette · Query took 113.518ms · Data source: data.sfgov.org