trees

Custom SQL query returning 101 rows (show)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
947 60023 7 17   1 Sidewalk: Curb side : Cutout Tree 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
954 20324 1 63 101X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     12 60                      
958 36868 7 11   2 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
960 45842 7 17   84 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 7 17   141 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
970 43482 7 103   8 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
974 48301 7 17   167 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
980 96180 7 158     Unaccepted Street : Cutout Tree 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    
983 44952 7 17   65 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1005 39481 7 9 0 19th St 1 Sidewalk: Curb side : Cutout Tree 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
1007 44545 7 17   24 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1008 48288 7 17   98 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1011 45966 7 17   157 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1017 46142 7 11   3 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
1032 39972 7 70 0 Steiner St 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41235                    
1035 44875 7 17   148 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1051 251262 6 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
1055 35449 7 37 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1062 20065 1 160 100 STAIRWAY54 12 Sidewalk: Curb side : Cutout Tree 1     3 15ST                      
1064 44650 7 17   70 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1076 260666 7 168 2X Serrano Dr 4 Sidewalk: Curb side : Cutout Tree 2   10/03/2019 12:00:00 AM 3 3x6                      
1090 260553 1 36 151x Palm Ave 4 Sidewalk: Curb side : Cutout Tree 1 SFUSD 09/21/2019 12:00:00 AM 3                        
1091 44966 7 17   79 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1095 255202 1 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree 1 FUF                            
1100 55205 7 17 44 Dalmar St 1 Sidewalk: Curb side : Cutout Tree 2   09/29/1972 12:00:00 AM     Permit Number 11118                    
1116 65831 7 17 2200 North Point 1 Sidewalk: Curb side : Cutout Tree 2   05/07/1990 12:00:00 AM     Permit Number 28821                    
1118 36625 7 19   1 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
1129 44885 7 17   158 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1135 48105 7 17   215 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1136 57990 7 17 19 Bausch St 1 Sidewalk: Curb side : Cutout Tree 2   08/08/1977 12:00:00 AM     Permit Number 16955                    
1138 260594 1 1 3090x Jennings St 4 Sidewalk: Curb side : Cutout Tree 1 FUF 08/24/2019 12:00:00 AM 3                        
1144 20400 1 15 262X Sunset Blvd 45 Sidewalk: Curb side : Cutout Tree 1     18 60                      
1148 33928 7 17   3 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1160 122663 1 11 401x Laguna St 1 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
1162 36561 7 17   5 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
1165 44567 7 17   2 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1168 39947 7 172 0 Ervine St 4 Sidewalk: Curb side : Cutout Tree 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
1171 19952 1 52 100 STAIRWAY39 9 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
1176 119263 1 15 495X Lakeshore Dr 1 Median : Yard Tree 1       10x30                      
1179 251578 1 37 1000X Columbus Ave 6 Median : Cutout Tree 1                              
1180 35696 7 145   6 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
1183 47616 7 11 1209 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
1186 45889 7 17   18 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1191 34003 7 27   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
1215 253279 1 44 201X Laguna Honda Blvd 1 Sidewalk: Property side : Yard Tree 1       10x10 ROW IS 10' tree is street tree                    
1216 20357 1 111 262X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     12 60                      
1227 46197 7 27   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1228 65998 7 17 2551 Beacon St 1 Sidewalk: Curb side : Cutout Tree 2   07/10/1990 12:00:00 AM     Permit Number 29030                    
1255 66098 7 17   1 Sidewalk: Curb side : Cutout Tree 2   08/08/1990 12:00:00 AM     Permit Number 29146                    
1259 34123 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
1261 45997 7 17   115 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1275 46058 7 17   188 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1286 39945 7 172 0 Ervine St 2 Sidewalk: Curb side : Cutout Tree 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
1287 48142 7 17   252 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1295 19941 1 56 100 STAIRWAY38 10 Sidewalk: Curb side : Cutout Tree 1     18 10ST                      
1303 35175 7 16   7 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1310 173924 1 11 500X Gough St 4 Sidewalk: Curb side : Cutout Tree 1   10/05/2010 12:00:00 AM   3x3                      
1321 48199 7 17   58 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1326 43484 7 103   6 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
1340 87020 7 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
1346 260123 7 177 3195X Harrison St 1 Sidewalk: Curb side : Cutout Tree 2   08/12/2019 12:00:00 AM 3 3x3                      
1350 19628 1 52 100 STAIRWAY5 27 Sidewalk: Curb side : Cutout Tree 1     6 30                      
1356 44935 7 17   168 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1363 19612 1 100 100 STAIRWAY5 11 Sidewalk: Curb side : Cutout Tree 1     6 30                      
1372 48323 7 17   189 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1386 67784 7 17 1030 South Park 1 Sidewalk: Curb side : Cutout Tree 2   12/17/1992 12:00:00 AM     Permit Number 31421                    
1392 48291 7 17   101 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1393 255136 1 11 401X Brotherhood Way 14 Sidewalk: Property side : Yard Tree 1                              
1395 33932 7 17   1 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1397 44933 7 17   166 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1398 20032 1 19 100 STAIRWAY51 3 Sidewalk: Curb side : Cutout Tree 1     3 3X3ST                      
1404 19975 1 150 100 STAIRWAY45 2 Sidewalk: Curb side : Cutout Tree 1     3 30ST                      
1411 44977 7 17   49 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1413 48094 7 17   218 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1420 19991 1 52 100 STAIRWAY46 11 Sidewalk: Curb side : Cutout Tree 1     12 40                      
1422 259801 1 18 1180x Brussels St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
1431 60090 7 17   1 Sidewalk: Curb side : Cutout Tree 2   03/19/1982 12:00:00 AM     Permit Number 19591                    
1446 44592 7 17   120 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1451 44942 7 17   175 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1459 46036 7 17   110 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1461 44992 7 17   81 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1465 45986 7 17   226 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1476 20456 1 155 495X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree 1     36 60                      
1479 44582 7 17   146 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1492 20444 1 16 495X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     12 15                      
1498 44556 7 17   19 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1504 19794 1 160 100 STAIRWAY19 16 Sidewalk: Curb side : Cutout Tree 1     18 50ST                      
1508 48345 7 17   162 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1511 260421 1 8 200x Bacon St 5 Sidewalk: Curb side : Cutout Tree 1 FUF 08/17/2019 12:00:00 AM 3                        
1515 31846 7 7   1 Sidewalk: Curb side : Cutout Tree 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
1517 19783 1 167 100 STAIRWAY19 5 Sidewalk: Curb side : Cutout Tree 1     6 50ST                      
1531 20287 1 15 20X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     12 60                      
1552 63329 7 17 225 Bessie St 1 Sidewalk: Curb side : Cutout Tree 2   02/02/1987 12:00:00 AM     Permit Number 23902                    
1555 61775 7 17 157 Lacrosse Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/03/1984 12:00:00 AM     Permit Number 21796                    
1577 19793 1 122 100 STAIRWAY19 15 Sidewalk: Curb side : Cutout Tree 1     6 20ST                      
1579 45978 7 17   129 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1581 19590 1 37 100 STAIRWAY4 13 Sidewalk: Curb side : Cutout Tree 1     3 60                      
1595 19920 1 150 100 STAIRWAY36 -2 Sidewalk: Curb side : Cutout Tree 1     6 3X3                      
1600 46288 7 196   15 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
1605 35819 7 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
1615 44603 7 17   121 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835