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)
81 46536 7 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
99 255073 9 17 173R Glenview Dr   Back Yard : Yard Tree 2                              
108 44866 7 17   25 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 7 17   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
110 45916 7 17   51 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 7 17   5 Unaccepted Street : Yard Tree 2                              
112 33929 7 17   4 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
333 44989 7 17   83 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
492 44943 7 17   176 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
514 45011 7 17   93 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 7 17   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1956 12:00:00 AM     Permit Number 147                    
531 46009 7 17   195 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
542 35050 7 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
548 48279 7 17   89 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
557 44837 7 17   11 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
622 48348 7 17   153 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
627 34919 7 17   5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
650 46071 7 17   1 Sidewalk: Curb side : Cutout Tree 2   12/12/2001 12:00:00 AM     Permit Number 44455                    
661 48170 7 17   63 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
676 44636 7 17   164 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
706 44899 7 17   133 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
721 46041 7 17   176 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
722 48068 7 17   234 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
790 55179 7 17 2201 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/31/1972 12:00:00 AM     Permit Number 11088                    
794 44541 7 17   28 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
841 44570 7 17   134 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
855 48153 7 17   263 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
892 44903 7 17   137 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
904 48322 7 17   188 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 7 17   62 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
921 61549 7 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
947 60023 7 17   1 Sidewalk: Curb side : Cutout Tree 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
960 45842 7 17   84 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 7 17   141 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
974 48301 7 17   167 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
983 44952 7 17   65 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1007 44545 7 17   24 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1008 48288 7 17   98 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1011 45966 7 17   157 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1035 44875 7 17   148 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1064 44650 7 17   70 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1091 44966 7 17   79 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1100 55205 7 17 44 Dalmar St 1 Sidewalk: Curb side : Cutout Tree 2   09/29/1972 12:00:00 AM     Permit Number 11118                    
1116 65831 7 17 2200 North Point 1 Sidewalk: Curb side : Cutout Tree 2   05/07/1990 12:00:00 AM     Permit Number 28821                    
1129 44885 7 17   158 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1135 48105 7 17   215 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1136 57990 7 17 19 Bausch St 1 Sidewalk: Curb side : Cutout Tree 2   08/08/1977 12:00:00 AM     Permit Number 16955                    
1148 33928 7 17   3 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1162 36561 7 17   5 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
1165 44567 7 17   2 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1186 45889 7 17   18 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1228 65998 7 17 2551 Beacon St 1 Sidewalk: Curb side : Cutout Tree 2   07/10/1990 12:00:00 AM     Permit Number 29030                    
1255 66098 7 17   1 Sidewalk: Curb side : Cutout Tree 2   08/08/1990 12:00:00 AM     Permit Number 29146                    
1261 45997 7 17   115 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1275 46058 7 17   188 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1287 48142 7 17   252 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1321 48199 7 17   58 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1356 44935 7 17   168 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1372 48323 7 17   189 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1386 67784 7 17 1030 South Park 1 Sidewalk: Curb side : Cutout Tree 2   12/17/1992 12:00:00 AM     Permit Number 31421                    
1392 48291 7 17   101 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1395 33932 7 17   1 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1397 44933 7 17   166 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1411 44977 7 17   49 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1413 48094 7 17   218 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1431 60090 7 17   1 Sidewalk: Curb side : Cutout Tree 2   03/19/1982 12:00:00 AM     Permit Number 19591                    
1446 44592 7 17   120 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1451 44942 7 17   175 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1459 46036 7 17   110 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1461 44992 7 17   81 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1465 45986 7 17   226 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1479 44582 7 17   146 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1498 44556 7 17   19 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1508 48345 7 17   162 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1552 63329 7 17 225 Bessie St 1 Sidewalk: Curb side : Cutout Tree 2   02/02/1987 12:00:00 AM     Permit Number 23902                    
1555 61775 7 17 157 Lacrosse Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/03/1984 12:00:00 AM     Permit Number 21796                    
1579 45978 7 17   129 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1615 44603 7 17   121 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1643 44855 7 17   17 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1674 48081 7 17   245 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1700 64639 7 17 465 Convention Way 1 Sidewalk: Curb side : Cutout Tree 2   08/19/1988 12:00:00 AM     Permit Number 25552                    
1703 48311 7 17   177 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1743 55199 7 17 28 Dalmar St 1 Sidewalk: Curb side : Cutout Tree 2   09/12/1972 12:00:00 AM     Permit Number 11112                    
1747 44960 7 17   61 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1760 44538 7 17   31 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1784 44653 7 17   73 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1795 44610 7 17   174 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1802 68847 7 17 2118 Flood Ave 1 Sidewalk: Curb side : Cutout Tree 2   12/28/1993 12:00:00 AM     Permit Number 32810                    
1815 44628 7 17   156 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1821 48173 7 17   66 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1829 55200 7 17 32 Dalmar St 1 Sidewalk: Curb side : Cutout Tree 2   09/29/1972 12:00:00 AM     Permit Number 11113                    
1831 48269 7 17   120 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1840 35278 7 17   5 Sidewalk: Curb side : Cutout Tree 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
1847 57850 7 17 1700 S. Amaylett Blvd 1 Sidewalk: Curb side : Cutout Tree 2   04/14/1977 12:00:00 AM     Permit Number 16791                    
1904 48103 7 17   212 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1917 46148 7 17   2 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
1934 44589 7 17   117 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
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