39,840 rows where qLegalStatus_id = 7 sorted by Neighborhoods (old)

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) ▼
81 46536 Permitted Site 7 Tree(s) :: 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
108 44866 Permitted Site 7 Tree(s) :: 17   25 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
110 45916 Permitted Site 7 Tree(s) :: 17   51 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 Permitted Site 7 Tree(s) :: 17   5 Unaccepted Street : Yard Tree Private 2                              
112 33929 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
333 44989 Permitted Site 7 Tree(s) :: 17   83 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
382 34903 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
492 44943 Permitted Site 7 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
514 45011 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
525 33087 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
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                    
531 46009 Permitted Site 7 Tree(s) :: 17   195 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
542 35050 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
548 48279 Permitted Site 7 Tree(s) :: 17   89 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
557 44837 Permitted Site 7 Tree(s) :: 17   11 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
622 48348 Permitted Site 7 Tree(s) :: 17   153 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
627 34919 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
650 46071 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44455                    
661 48170 Permitted Site 7 Tree(s) :: 17   63 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
676 44636 Permitted Site 7 Tree(s) :: 17   164 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
706 44899 Permitted Site 7 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
721 46041 Permitted Site 7 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
722 48068 Permitted Site 7 Tree(s) :: 17   234 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
790 55179 Permitted Site 7 Tree(s) :: 17 2201 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1972 12:00:00 AM     Permit Number 11088                    
794 44541 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
796 36869 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
841 44570 Permitted Site 7 Tree(s) :: 17   134 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
843 38804 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
845 35702 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   15 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
855 48153 Permitted Site 7 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
892 44903 Permitted Site 7 Tree(s) :: 17   137 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
904 48322 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 Permitted Site 7 Tree(s) :: 17   62 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
921 61549 Permitted Site 7 Tree(s) :: 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
947 60023 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
958 36868 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
960 45842 Permitted Site 7 Tree(s) :: 17   84 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 Permitted Site 7 Tree(s) :: 17   141 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
970 43482 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   8 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
974 48301 Permitted Site 7 Tree(s) :: 17   167 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
980 96180 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    
983 44952 Permitted Site 7 Tree(s) :: 17   65 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1005 39481 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
1007 44545 Permitted Site 7 Tree(s) :: 17   24 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1008 48288 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1011 45966 Permitted Site 7 Tree(s) :: 17   157 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1017 46142 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
1032 39972 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 0 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
1035 44875 Permitted Site 7 Tree(s) :: 17   148 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1055 35449 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1064 44650 Permitted Site 7 Tree(s) :: 17   70 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1076 260666 Permitted Site 7 Aesculus californica :: California Buckeye 168 2X Serrano Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6                      
1091 44966 Permitted Site 7 Tree(s) :: 17   79 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1100 55205 Permitted Site 7 Tree(s) :: 17 44 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11118                    
1116 65831 Permitted Site 7 Tree(s) :: 17 2200 North Point 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1990 12:00:00 AM     Permit Number 28821                    
1118 36625 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
1129 44885 Permitted Site 7 Tree(s) :: 17   158 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1135 48105 Permitted Site 7 Tree(s) :: 17   215 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1136 57990 Permitted Site 7 Tree(s) :: 17 19 Bausch St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1977 12:00:00 AM     Permit Number 16955                    
1148 33928 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1162 36561 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
1165 44567 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1168 39947 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 0 Ervine St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
1180 35696 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   6 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
1183 47616 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
1186 45889 Permitted Site 7 Tree(s) :: 17   18 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1191 34003 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
1227 46197 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1228 65998 Permitted Site 7 Tree(s) :: 17 2551 Beacon St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1990 12:00:00 AM     Permit Number 29030                    
1255 66098 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1990 12:00:00 AM     Permit Number 29146                    
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                    
1261 45997 Permitted Site 7 Tree(s) :: 17   115 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1275 46058 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1286 39945 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 0 Ervine St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
1287 48142 Permitted Site 7 Tree(s) :: 17   252 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
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                    
1321 48199 Permitted Site 7 Tree(s) :: 17   58 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1326 43484 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   6 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
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                    
1346 260123 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 3195X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2019 12:00:00 AM 3 3x3                      
1356 44935 Permitted Site 7 Tree(s) :: 17   168 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1372 48323 Permitted Site 7 Tree(s) :: 17   189 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1386 67784 Permitted Site 7 Tree(s) :: 17 1030 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1992 12:00:00 AM     Permit Number 31421                    
1392 48291 Permitted Site 7 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1395 33932 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1397 44933 Permitted Site 7 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1411 44977 Permitted Site 7 Tree(s) :: 17   49 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1413 48094 Permitted Site 7 Tree(s) :: 17   218 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1431 60090 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1982 12:00:00 AM     Permit Number 19591                    
1446 44592 Permitted Site 7 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1451 44942 Permitted Site 7 Tree(s) :: 17   175 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1459 46036 Permitted Site 7 Tree(s) :: 17   110 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1461 44992 Permitted Site 7 Tree(s) :: 17   81 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1465 45986 Permitted Site 7 Tree(s) :: 17   226 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1479 44582 Permitted Site 7 Tree(s) :: 17   146 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1498 44556 Permitted Site 7 Tree(s) :: 17   19 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1508 48345 Permitted Site 7 Tree(s) :: 17   162 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    

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