trees

39,840 rows where qLegalStatus_id = 7 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)
2656 44646 Permitted Site 7 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2664 45874 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2666 48202 Permitted Site 7 Tree(s) :: 17   45 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2667 66672 Permitted Site 7 Tree(s) :: 17 4307 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1991 12:00:00 AM     Permit Number 29892                    
2677 36640 Permitted Site 7 Robinia x ambigua :: Locust 196   14 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
2690 44593 Permitted Site 7 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2691 58348 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/1978 12:00:00 AM     Permit Number 17373                    
2697 49874 Permitted Site 7 Tree(s) :: 17 0@ 14th ST Trainor St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2003 12:00:00 AM     Permit Number 46642                    
2702 48207 Permitted Site 7 Tree(s) :: 17   50 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2710 44606 Permitted Site 7 Tree(s) :: 17   170 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2715 57888 Permitted Site 7 Tree(s) :: 17 2382 Fost St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/1977 12:00:00 AM     Permit Number 16841                    
2716 48065 Permitted Site 7 Tree(s) :: 17   219 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2722 48074 Permitted Site 7 Tree(s) :: 17   240 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2746 44553 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2763 48152 Permitted Site 7 Tree(s) :: 17   262 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2768 48107 Permitted Site 7 Tree(s) :: 17   202 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2775 45022 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2777 256912 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 26 Lily St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
2794 254529 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 421 Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/2018 12:00:00 AM 3 3x3 Permit Number 769845                    
2795 48259 Permitted Site 7 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2832 45922 Permitted Site 7 Tree(s) :: 17   68 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2835 48321 Permitted Site 7 Tree(s) :: 17   187 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2849 44580 Permitted Site 7 Tree(s) :: 17   144 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2851 45941 Permitted Site 7 Tree(s) :: 17   42 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2852 48188 Permitted Site 7 Tree(s) :: 17   69 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2871 45998 Permitted Site 7 Tree(s) :: 17   116 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2876 46030 Permitted Site 7 Tree(s) :: 17   207 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2890 65297 Permitted Site 7 Tree(s) :: 17 328 Magnolia St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM     Permit Number 28111                    
2893 43480 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
2902 66145 Permitted Site 7 Tree(s) :: 17 2151 North Point 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1990 12:00:00 AM     Permit Number 29211                    
2927 35280 Permitted Site 7 Olea europaea :: Olive Tree 9   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
2942 48171 Permitted Site 7 Tree(s) :: 17   64 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2954 45891 Permitted Site 7 Tree(s) :: 17   11 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2961 35202 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2978 44849 Permitted Site 7 Tree(s) :: 17   41 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2988 35689 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   12 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
2996 38797 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   5 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3005 109931 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2822 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775171                    
3009 63503 Permitted Site 7 Tree(s) :: 17 664 Guardalupe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1987 12:00:00 AM     Permit Number 24104                    
3014 45933 Permitted Site 7 Tree(s) :: 17   52 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3034 48210 Permitted Site 7 Tree(s) :: 17   53 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3039 45878 Permitted Site 7 Tree(s) :: 17   32 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3071 31851 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1117 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35299                    
3072 46535 Permitted Site 7 Tree(s) :: 17 73 Summer St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
3075 44919 Permitted Site 7 Tree(s) :: 17   192 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3081 45873 Permitted Site 7 Tree(s) :: 17   6 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3086 48271 Permitted Site 7 Tree(s) :: 17   81 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3114 45980 Permitted Site 7 Tree(s) :: 17   127 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3130 34137 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 37987                    
3154 48208 Permitted Site 7 Tree(s) :: 17   51 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3189 43487 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   3 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
3231 48131 Permitted Site 7 Tree(s) :: 17   299 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3236 44583 Permitted Site 7 Tree(s) :: 17   147 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3239 44888 Permitted Site 7 Tree(s) :: 17   161 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3242 43297 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1501 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2000 12:00:00 AM     Permit Number 43066                    
3253 33090 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   3 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3268 44595 Permitted Site 7 Tree(s) :: 17   150 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3276 36629 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
3277 33927 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
3294 44573 Permitted Site 7 Tree(s) :: 17   137 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
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                    
3308 60361 Permitted Site 7 Tree(s) :: 17 137 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1982 12:00:00 AM     Permit Number 19939                    
3322 60041 Permitted Site 7 Tree(s) :: 17 33 Monroe St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1982 12:00:00 AM     Permit Number 19538                    
3334 58370 Permitted Site 7 Tree(s) :: 17 444 Lindsay Cir 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/1978 12:00:00 AM     Permit Number 17400                    
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                    
3410 47847 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
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                    
3429 61386 Permitted Site 7 Tree(s) :: 17 3536 Lay St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1984 12:00:00 AM     Permit Number 21303                    
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                    
3450 52146 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 145 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2005 12:00:00 AM     Permit Number 48337                    
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                    
3492 30592 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
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                    
3528 38666 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 850 Brewster St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM     Permit Number 40586                    
3531 39973 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 0 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
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                    
3589 254266 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 85X Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2018 12:00:00 AM 3 3x3 Permit Number 778120                    
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                    
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                    
3707 51415 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 7121 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2004 12:00:00 AM     Permit Number 47739                    
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                    

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