trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2516 45863 7 17   85 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2524 30480 7 17   3 Sidewalk: Curb side : Cutout Tree 2   09/05/1956 12:00:00 AM     Permit Number 147                    
2534 48332 7 17   142 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2549 31437 7 17 4206 02nd St 1 Sidewalk: Curb side : Cutout Tree 2   05/01/1995 12:00:00 AM     Permit Number 35012                    
2551 256191 5 177 3600 Buchanan St 3 Sidewalk: Curb side : Cutout Tree 2   09/21/2018 12:00:00 AM 3                        
2554 48167 7 17   60 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2559 48211 7 17   54 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2566 35200 7 14   3 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2573 60778 7 17 3933 29th St 1 Sidewalk: Curb side : Cutout Tree 2   03/03/1983 12:00:00 AM     Permit Number 20448                    
2583 34124 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
2602 42924 7 33   2 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
2610 31853 7 135 1263 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   06/19/1995 12:00:00 AM     Permit Number 35300                    
2612 48088 7 17   198 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2632 48281 7 17   91 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2646 44909 7 17   132 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2656 44646 7 17   66 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2664 45874 7 17   28 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2666 48202 7 17   45 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2667 66672 7 17 4307 02nd St 1 Sidewalk: Curb side : Cutout Tree 2   06/25/1991 12:00:00 AM     Permit Number 29892                    
2677 36640 7 196   14 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
2690 44593 7 17   133 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2691 58348 7 17   1 Sidewalk: Curb side : Cutout Tree 2   11/08/1978 12:00:00 AM     Permit Number 17373                    
2697 49874 7 17 0@ 14th ST Trainor St 2 Sidewalk: Curb side : Cutout Tree 2   06/30/2003 12:00:00 AM     Permit Number 46642                    
2702 48207 7 17   50 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2710 44606 7 17   170 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2715 57888 7 17 2382 Fost St 1 Sidewalk: Curb side : Cutout Tree 2   05/04/1977 12:00:00 AM     Permit Number 16841                    
2716 48065 7 17   219 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2722 48074 7 17   240 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2746 44553 7 17   4 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2762 46200 7 83   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2763 48152 7 17   262 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2768 48107 7 17   202 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2775 45022 7 17   95 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2777 256912 7 39 26 Lily St   Sidewalk: Curb side : Cutout Tree 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
2794 254529 7 29 421 Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/23/2018 12:00:00 AM 3 3x3 Permit Number 769845                    
2795 48259 7 17   123 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2809 251459 1 140 651 Texas St 2 Sidewalk: Curb side : Cutout Tree 2   05/03/2017 12:00:00 AM 3 3x3                      
2832 45922 7 17   68 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2835 48321 7 17   187 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2849 44580 7 17   144 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2851 45941 7 17   42 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2852 48188 7 17   69 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2871 45998 7 17   116 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2876 46030 7 17   207 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2890 65297 7 17 328 Magnolia St 1 Sidewalk: Curb side : Cutout Tree 2   09/13/1989 12:00:00 AM     Permit Number 28111                    
2893 43480 7 103   2 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
2902 66145 7 17 2151 North Point 1 Sidewalk: Curb side : Cutout Tree 2   08/18/1990 12:00:00 AM     Permit Number 29211                    
2912 122668 1 33 301x Hickory St 1 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3X3                      
2927 35280 7 9   1 Sidewalk: Curb side : Cutout Tree 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
2942 48171 7 17   64 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2954 45891 7 17   11 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2961 35202 7 14   1 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2978 44849 7 17   41 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2988 35689 7 27   12 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
2996 38797 7 11   5 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3005 109931 7 14 2822 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775171                    
3009 63503 7 17 664 Guardalupe Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/07/1987 12:00:00 AM     Permit Number 24104                    
3014 45933 7 17   52 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3034 48210 7 17   53 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3039 45878 7 17   32 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3071 31851 7 84 1117 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   06/19/1995 12:00:00 AM     Permit Number 35299                    
3072 46535 7 17 73 Summer St 1 Sidewalk: Curb side : Cutout Tree 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
3075 44919 7 17   192 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3081 45873 7 17   6 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3086 48271 7 17   81 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3114 45980 7 17   127 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3130 34137 7 14   1 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
3154 48208 7 17   51 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3171 119608 6 185 299x Avalon Ave 4 Front Yard : Yard Tree 2                              
3182 261252 6 21 100 Collins St 1 Front Yard : Cutout Tree 2   12/18/2019 12:00:00 AM 3                        
3189 43487 7 103   3 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
3231 48131 7 17   299 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3236 44583 7 17   147 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3239 44888 7 17   161 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
3242 43297 7 7 1501 Missouri St 1 Sidewalk: Curb side : Cutout Tree 2   07/12/2000 12:00:00 AM     Permit Number 43066                    
3253 33090 7 27   3 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3268 44595 7 17   150 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3276 36629 7 17   4 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
3277 33927 7 17   2 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
3294 44573 7 17   137 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3295 44604 7 17   177 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3308 60361 7 17 137 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/26/1982 12:00:00 AM     Permit Number 19939                    
3322 60041 7 17 33 Monroe St 1 Sidewalk: Curb side : Cutout Tree 2   02/10/1982 12:00:00 AM     Permit Number 19538                    
3334 58370 7 17 444 Lindsay Cir 1 Sidewalk: Curb side : Cutout Tree 2   12/07/1978 12:00:00 AM     Permit Number 17400                    
3363 44550 7 17   8 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3364 48300 7 17   166 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3382 46731 7 172   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
3387 45923 7 17   60 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3410 47847 7 64 8250on Geary 47th Ave 6 Sidewalk: Curb side : Cutout Tree 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
3415 44687 7 17   107 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3429 61386 7 17 3536 Lay St 1 Sidewalk: Curb side : Cutout Tree 2   04/10/1984 12:00:00 AM     Permit Number 21303                    
3439 43015 7 25   1 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
3443 33088 7 27   5 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3446 45989 7 17   222 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3450 52146 7 83 145 Hawes St 1 Sidewalk: Curb side : Cutout Tree 2   10/31/2005 12:00:00 AM     Permit Number 48337                    
3468 48096 7 17   206 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
3471 44691 7 17   111 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
3476 45929 7 17   40 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
3492 30592 7 83 269 Walter St 2 Sidewalk: Curb side : Cutout Tree 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
3497 46195 7 19   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3528 38666 7 11 850 Brewster St 3 Sidewalk: Curb side : Cutout Tree 2   10/01/1998 12:00:00 AM     Permit Number 40586