trees

194,517 rows sorted by qAddress

✎ 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)
3295 44604 Permitted Site 7 Tree(s) :: 17   177 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3363 44550 Permitted Site 7 Tree(s) :: 17   8 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3364 48300 Permitted Site 7 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3382 46731 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172   3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
3387 45923 Permitted Site 7 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3415 44687 Permitted Site 7 Tree(s) :: 17   107 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3439 43015 Permitted Site 7 Geijera parviflora :: Australian Willow 25   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
3443 33088 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   5 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3446 45989 Permitted Site 7 Tree(s) :: 17   222 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
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                    
3497 46195 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
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                    
3632 34115 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 37978                    
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                    
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                    
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                    
3783 47477 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45375                    
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                    
3795 35211 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   8 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
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                    
3829 35184 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3832 36644 Permitted Site 7 Robinia x ambigua :: Locust 196   10 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
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                    
3908 36856 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
3913 35208 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   13 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3932 36559 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   8 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
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                    
3983 34122 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
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                    
4023 31850 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84   2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
4027 46718 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
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                    
4058 34900 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
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                    
4114 46287 Permitted Site 7 Robinia x ambigua :: Locust 196   16 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
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                    
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                    
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                    
4226 35703 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   16 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
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                    
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                    
4373 35701 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   13 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
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                    
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                    
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                    
4502 34972 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM     Permit Number 38555                    
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                    
4537 96174 Permitted Site 7 Malus sylvestris :: Apple 277     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767807                    
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                    
4587 35197 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
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                    
4641 43485 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   5 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
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                    
4666 36564 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
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                    
4732 35697 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   8 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
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                    
4745 46309 Permitted Site 7 Robinia x ambigua :: Locust 196   18 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
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                    

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