39,840 rows where qLegalStatus_id = 7 sorted by qAddress

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)
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
1515 31846 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
1579 45978 Permitted Site 7 Tree(s) :: 17   129 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1600 46288 Permitted Site 7 Robinia x ambigua :: Locust 196   15 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
1602 45381 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2001 12:00:00 AM     Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
1615 44603 Permitted Site 7 Tree(s) :: 17   121 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1643 44855 Permitted Site 7 Tree(s) :: 17   17 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1674 48081 Permitted Site 7 Tree(s) :: 17   245 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1703 48311 Permitted Site 7 Tree(s) :: 17   177 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1747 44960 Permitted Site 7 Tree(s) :: 17   61 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1760 44538 Permitted Site 7 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1784 44653 Permitted Site 7 Tree(s) :: 17   73 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1794 42923 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
1795 44610 Permitted Site 7 Tree(s) :: 17   174 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1815 44628 Permitted Site 7 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1821 48173 Permitted Site 7 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1831 48269 Permitted Site 7 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1840 35278 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
1904 48103 Permitted Site 7 Tree(s) :: 17   212 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1917 46148 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    

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