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)
1928 43486 7 103   1 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
1934 44589 7 17   117 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1940 43017 7 25   2 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
1956 44540 7 17   29 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1964 48189 7 17   43 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1968 44918 7 17   183 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1975 48204 7 17   47 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1984 48220 7 17   2 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1986 45957 7 17   166 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1987 44951 7 17   64 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2031 48316 7 17   182 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2043 66343 7 17   1 Sidewalk: Curb side : Cutout Tree 2   12/10/1990 12:00:00 AM     Permit Number 29464                    
2076 44958 7 17   82 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2083 46724 7 33   5 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
2102 48160 7 17   270 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2108 35196 7 14   5 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2113 44856 7 17   33 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2140 46192 7 19   6 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2146 45914 7 17   33 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2163 48471 7 17   15 Sidewalk: Curb side : Cutout Tree 2         Permit Number 45832                    
2170 44902 7 17   136 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2177 44598 7 17   126 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2187 46061 7 17   103 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2189 48278 7 17   88 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2196 48265 7 17   129 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2203 45984 7 17   123 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2225 44536 7 17   33 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2226 44987 7 17   59 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2241 46289 7 196   14 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
2265 48308 7 17   174 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2267 46716 7 14   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
2275 46014 7 17   200 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2277 44912 7 17   185 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2323 35205 7 16   16 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2339 44535 7 17   34 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2366 45917 7 17   63 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2434 44999 7 17   103 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2445 48349 7 17   152 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2451 44962 7 17   75 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2483 34134 7 14   5 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
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                    
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                    
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                    
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                    
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                    
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                    
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                    
2795 48259 7 17   123 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
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                    
2893 43480 7 103   2 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
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                    
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                    
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                    
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                    
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