trees

11,761 rows where qSpecies_id = 17 sorted by PlotSize

✎ 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)
2277 44912 Permitted Site 7 Tree(s) :: 17   185 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2287 63935 Permitted Site 7 Tree(s) :: 17 4086 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/1992 12:00:00 AM     Permit Number 31216 6003335.30229838 2100703.31540535 37.7483199335724 -122.431242739217 (37.7483199335724, -122.431242739217) 2 4 5 28862 22
2294 84947 Permitted Site 7 Tree(s) :: 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
2318 61432 Permitted Site 7 Tree(s) :: 17 234 La Espiral St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1984 12:00:00 AM     Permit Number 21363                    
2328 57118 Permitted Site 7 Tree(s) :: 17 567 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM     Permit Number 14388 6001433.85993869 2090479.06392424 37.7201385647203 -122.437085957535 (37.7201385647203, -122.437085957535) 9 7 6 28861 5
2336 59785 Permitted Site 7 Tree(s) :: 17 237 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1981 12:00:00 AM     Permit Number 19234 6003567.2308667 2106887.18352857 37.7653125069264 -122.430881994524 (37.7653125069264, -122.430881994524) 8 4 5 28862 3
2339 44535 Permitted Site 7 Tree(s) :: 17   34 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2366 45917 Permitted Site 7 Tree(s) :: 17   63 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2371 57894 Permitted Site 7 Tree(s) :: 17 972 Terminal Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/1977 12:00:00 AM     Permit Number 16848                    
2375 58506 Permitted Site 7 Tree(s) :: 17 1378 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1979 12:00:00 AM     Permit Number 17681 5999108.40955672 2108391.40839874 37.7691890857648 -122.446412174677 (37.7691890857648, -122.446412174677) 15 5 11 29492 9
2424 61752 Permitted Site 7 Tree(s) :: 17 3014 Rolison Road 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1984 12:00:00 AM     Permit Number 21763                    
2434 44999 Permitted Site 7 Tree(s) :: 17   103 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2445 48349 Permitted Site 7 Tree(s) :: 17   152 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2451 44962 Permitted Site 7 Tree(s) :: 17   75 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2478 110785 Permitted Site 7 Tree(s) :: 17 2 Edna St 2 Front Yard : Yard Tree Private 2   05/06/2015 12:00:00 AM 3     5998788.4 2092979.9 37.7268545527586 -122.446410203741 (37.7268545527586, -122.446410203741) 9 7 4 28861 40
2499 55575 Permitted Site 7 Tree(s) :: 17 622 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM     Permit Number 11546 6010538.99497753 2108399.45644768 37.7698574135988 -122.40687477594 (37.7698574135988, -122.40687477594) 8 2 9 28853 19
2516 45863 Permitted Site 7 Tree(s) :: 17   85 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2524 30480 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
2534 48332 Permitted Site 7 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2549 31437 Permitted Site 7 Tree(s) :: 17 4206 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1995 12:00:00 AM     Permit Number 35012                    
2554 48167 Permitted Site 7 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2559 48211 Permitted Site 7 Tree(s) :: 17   54 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2573 60778 Permitted Site 7 Tree(s) :: 17 3933 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1983 12:00:00 AM     Permit Number 20448                    
2586 66958 Permitted Site 7 Tree(s) :: 17 283 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1992 12:00:00 AM     Permit Number 30294 5994190.17633556 2087741.03649596 37.7122061872577 -122.461926308953 (37.7122061872577, -122.461926308953) 9 8 6 28861 24
2598 95032 - 12 Tree(s) :: 17 211 Maynard St   Front Yard : Cutout Landscaping Private 2           6004772 2093802 37.7294517978782 -122.425783519869 (37.7294517978782, -122.425783519869) 9 7 6 28861 5
2612 48088 Permitted Site 7 Tree(s) :: 17   198 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2632 48281 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2646 44909 Permitted Site 7 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
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                    
2660 62615 Permitted Site 7 Tree(s) :: 17 1868 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1986 12:00:00 AM     Permit Number 22925 5993167.63363514 2102765.07828361 37.7533995564178 -122.466551819518 (37.7533995564178, -122.466551819518) 1 8 4 56 12
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                    
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                    
2705 54005 Permitted Site 7 Tree(s) :: 17 515 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1972 12:00:00 AM     Permit Number 9724 6003024.81931846 2102680.10849791 37.7537301410207 -122.432457552268 (37.7537301410207, -122.432457552268) 2 4 5 28862 22
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                    
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                    
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                    
2838 65166 Permitted Site 7 Tree(s) :: 17 439 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2006 12:00:00 AM     Permit Number 48848 5999406.26967916 2094532.50818101 37.7311529235029 -122.444385781456 (37.7311529235029, -122.444385781456) 9 7 4 59 40
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                    
2856 64671 Permitted Site 7 Tree(s) :: 17 825 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/1988 12:00:00 AM     Permit Number 25617 6006551.01917293 2113304.1780681 37.7831006421796 -122.421017411704 (37.7831006421796, -122.421017411704) 7 9 11 28858 41
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                    
2896 57627 Permitted Site 7 Tree(s) :: 17 151 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/1976 12:00:00 AM     Permit Number 16523 6012939.28895773 2087149.90749528 37.7116446426562 -122.39708197473 (37.7116446426562, -122.39708197473) 10 3 8 309 1
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                    
2920 57356 Permitted Site 7 Tree(s) :: 17 408 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1976 12:00:00 AM     Permit Number 16190 6003732.6166891 2102187.85387442 37.7524186365739 -122.42997471801 (37.7524186365739, -122.42997471801) 2 4 5 28862 22
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                    
2962 58930 Permitted Site 7 Tree(s) :: 17 482 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1980 12:00:00 AM     Permit Number 18208 5985970.29601233 2112643.56840929 37.7801051670012 -122.492168689483 (37.7801051670012, -122.492168689483) 11 6 2 55 26
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                    
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                    
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                    
3073 65776 Permitted Site 7 Tree(s) :: 17 1492 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1990 12:00:00 AM     Permit Number 28741 6005204.54785283 2099636.58243571 37.7454966829846 -122.424703055616 (37.7454966829846, -122.424703055616) 2 7 5 63 22
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                    
3084 54685 Permitted Site 7 Tree(s) :: 17 1237 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/1972 12:00:00 AM     Permit Number 10516 5992967.6128004 2107054.24404177 37.7651649407886 -122.467555420255 (37.7651649407886, -122.467555420255) 11 8 11 56 12
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                    
3090 68020 Permitted Site 7 Tree(s) :: 17 1488 Portola Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1993 12:00:00 AM     Permit Number 31751 5992594.58458889 2097062.94168296 37.737709860171 -122.468118769262 (37.737709860171, -122.468118769262) 1 8 4 59 40
3105 56728 Permitted Site 7 Tree(s) :: 17 1543 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6015672.6894307 2095677.74798122 37.7352121997354 -122.388229306646 (37.7352121997354, -122.388229306646) 10 3 8 58 1
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                    
3133 53387 Permitted Site 7 Tree(s) :: 17 272 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994766.71798377 2090393.02640531 37.7195210985022 -122.460125633496 (37.7195210985022, -122.460125633496) 9 8 6 28861 24
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                    
3169 55591 Permitted Site 7 Tree(s) :: 17 246 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1973 12:00:00 AM     Permit Number 11563 6004738.60124279 2102235.34344452 37.7526059525007 -122.426499236751 (37.7526059525007, -122.426499236751) 2 4 5 28862 22
3204 57536 Permitted Site 7 Tree(s) :: 17 300 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1976 12:00:00 AM     Permit Number 16395 6004402.26000103 2096454.97863083 37.7367153805698 -122.427250650001 (37.7367153805698, -122.427250650001) 2 7 5 63 7
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                    
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                    
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                    
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                    
3436 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
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                    

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