trees

11,761 rows where qSpecies_id = 17 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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)
3468 48096 Permitted Site 7 Tree(s) :: 17   206 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3471 44691 Permitted Site 7 Tree(s) :: 17   111 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3476 45929 Permitted Site 7 Tree(s) :: 17   40 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3563 44709 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3573 46144 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
3590 48066 Permitted Site 7 Tree(s) :: 17   232 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3649 44915 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3659 46140 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
3671 46016 Permitted Site 7 Tree(s) :: 17   202 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3678 44846 Permitted Site 7 Tree(s) :: 17   32 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3680 55595 Permitted Site 7 Tree(s) :: 17 1150 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1973 12:00:00 AM     Permit Number 11568                    
3716 45971 Permitted Site 7 Tree(s) :: 17   161 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3742 48168 Permitted Site 7 Tree(s) :: 17   61 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3748 45897 Permitted Site 7 Tree(s) :: 17   17 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3758 48478 Permitted Site 7 Tree(s) :: 17   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
3771 45970 Permitted Site 7 Tree(s) :: 17   224 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3774 48205 Permitted Site 7 Tree(s) :: 17   48 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3787 44565 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3794 44711 Permitted Site 7 Tree(s) :: 17   85 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3827 48482 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2002 12:00:00 AM     Permit Number 45832                    
3854 44847 Permitted Site 7 Tree(s) :: 17   16 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3876 48275 Permitted Site 7 Tree(s) :: 17   85 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3952 55206 Permitted Site 7 Tree(s) :: 17 55 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11119                    
3953 48072 Permitted Site 7 Tree(s) :: 17   238 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3955 64751 Permitted Site 7 Tree(s) :: 17 532 Walker Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1988 12:00:00 AM     Permit Number 25716                    
3987 44668 Permitted Site 7 Tree(s) :: 17   50 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3988 65877 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1990 12:00:00 AM     Permit Number 28876                    
4002 61236 Permitted Site 7 Tree(s) :: 17 432 Greenwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/1983 12:00:00 AM     Permit Number 21107                    
4047 45921 Permitted Site 7 Tree(s) :: 17   67 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4069 44877 Permitted Site 7 Tree(s) :: 17   150 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4076 59741 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1981 12:00:00 AM     Permit Number 19174                    
4079 44609 Permitted Site 7 Tree(s) :: 17   173 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4090 45972 Permitted Site 7 Tree(s) :: 17   119 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4105 45931 Permitted Site 7 Tree(s) :: 17   53 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4120 48106 Permitted Site 7 Tree(s) :: 17   217 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4142 56948 Permitted Site 7 Tree(s) :: 17 1905 Barker St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 14200                    
4158 44629 Permitted Site 7 Tree(s) :: 17   169 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4165 48186 Permitted Site 7 Tree(s) :: 17   79 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4170 44867 Permitted Site 7 Tree(s) :: 17   26 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4171 48297 Permitted Site 7 Tree(s) :: 17   92 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4175 57000 Permitted Site 7 Tree(s) :: 17 515 Alcarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM     Permit Number 14258                    
4182 48070 Permitted Site 7 Tree(s) :: 17   236 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4198 48133 Permitted Site 7 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4206 44632 Permitted Site 7 Tree(s) :: 17   160 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4250 48327 Permitted Site 7 Tree(s) :: 17   137 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4285 48240 Permitted Site 7 Tree(s) :: 17   24 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4301 35051 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
4303 48137 Permitted Site 7 Tree(s) :: 17   247 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4342 44990 Permitted Site 7 Tree(s) :: 17   51 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4355 45880 Permitted Site 7 Tree(s) :: 17   34 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4359 48488 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
4385 60708 Permitted Site 7 Tree(s) :: 17 2601 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/1983 12:00:00 AM     Permit Number 20358                    
4397 44679 Permitted Site 7 Tree(s) :: 17   99 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4403 46019 Permitted Site 7 Tree(s) :: 17   218 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4417 65265 Permitted Site 7 Tree(s) :: 17 2884 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/1989 12:00:00 AM     Permit Number 28066                    
4418 44832 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4430 44853 Permitted Site 7 Tree(s) :: 17   36 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4460 48135 Permitted Site 7 Tree(s) :: 17   288 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4476 112909 Undocumented 4 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
4489 97354 Permitted Site 7 Tree(s) :: 17   4 Unaccepted Street : Yard Tree Private 2                              
4495 44934 Permitted Site 7 Tree(s) :: 17   167 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4514 48156 Permitted Site 7 Tree(s) :: 17   266 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4519 44869 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4557 44954 Permitted Site 7 Tree(s) :: 17   67 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4572 45006 Permitted Site 7 Tree(s) :: 17   118 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4580 44552 Permitted Site 7 Tree(s) :: 17   10 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4590 48087 Permitted Site 7 Tree(s) :: 17   197 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4600 48104 Permitted Site 7 Tree(s) :: 17   213 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4602 48484 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2002 12:00:00 AM     Permit Number 45832                    
4622 48093 Permitted Site 7 Tree(s) :: 17   203 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4644 48129 Permitted Site 7 Tree(s) :: 17   297 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4661 44851 Permitted Site 7 Tree(s) :: 17   38 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4674 45959 Permitted Site 7 Tree(s) :: 17   164 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4698 46006 Permitted Site 7 Tree(s) :: 17   192 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4720 48140 Permitted Site 7 Tree(s) :: 17   250 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4738 45945 Permitted Site 7 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4748 45021 Permitted Site 7 Tree(s) :: 17   94 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4769 36649 Permitted Site 7 Tree(s) :: 17   8 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
4780 46020 Permitted Site 7 Tree(s) :: 17   217 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
4787 35045 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
4792 48144 Permitted Site 7 Tree(s) :: 17   254 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
4796 59337 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/1980 12:00:00 AM     Permit Number 18684                    
4811 44608 Permitted Site 7 Tree(s) :: 17   172 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4836 44537 Permitted Site 7 Tree(s) :: 17   21 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
4851 44961 Permitted Site 7 Tree(s) :: 17   74 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
4889 60481 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/1982 12:00:00 AM     Permit Number 20076                    
4934 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4955 64905 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/1989 12:00:00 AM     Permit Number 25932                    
4976 48089 Permitted Site 7 Tree(s) :: 17   199 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
5008 45898 Permitted Site 7 Tree(s) :: 17   26 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
5021 44937 Permitted Site 7 Tree(s) :: 17   170 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
5022 44671 Permitted Site 7 Tree(s) :: 17   53 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
5026 48194 Permitted Site 7 Tree(s) :: 17   36 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
5029 48138 Permitted Site 7 Tree(s) :: 17   248 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
5080 48307 Permitted Site 7 Tree(s) :: 17   173 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
5100 101532 Undocumented 4 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
5101 48351 Permitted Site 7 Tree(s) :: 17   150 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
5108 48330 Permitted Site 7 Tree(s) :: 17   140 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
5144 48216 Permitted Site 7 Tree(s) :: 17   190 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)
);