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)
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                    
382 34903 7 19   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
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                    
525 33087 7 27   6 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
530 35187 7 14   17 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
531 46009 7 17   195 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
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                    
794 44541 7 17   28 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
796 36869 7 22   4 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
841 44570 7 17   134 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
843 38804 7 11   2 Sidewalk: Curb side : Cutout Tree 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
845 35702 7 145   15 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
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                    
947 60023 7 17   1 Sidewalk: Curb side : Cutout Tree 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
958 36868 7 11   2 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
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                    
970 43482 7 103   8 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
974 48301 7 17   167 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
980 96180 7 158     Unaccepted Street : Cutout Tree 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    
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                    
1017 46142 7 11   3 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
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                    
1118 36625 7 19   1 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
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                    
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                    
1180 35696 7 145   6 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
1186 45889 7 17   18 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1191 34003 7 27   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
1227 46197 7 27   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1255 66098 7 17   1 Sidewalk: Curb side : Cutout Tree 2   08/08/1990 12:00:00 AM     Permit Number 29146                    
1259 34123 7 14   2 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
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                    
1303 35175 7 16   7 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1321 48199 7 17   58 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1326 43484 7 103   6 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
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                    
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                    
1515 31846 7 7   1 Sidewalk: Curb side : Cutout Tree 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
1579 45978 7 17   129 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1600 46288 7 196   15 Sidewalk: Curb side : Cutout Tree 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
1602 45381 7 11   4 Sidewalk: Curb side : Cutout Tree 2   07/06/2001 12:00:00 AM     Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
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                    
1703 48311 7 17   177 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
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                    
1794 42923 7 33   1 Sidewalk: Curb side : Cutout Tree 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
1795 44610 7 17   174 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
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                    
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                    
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                    
1928 43486 7 103   1 Sidewalk: Curb side : Cutout Tree 2   07/19/2000 12:00:00 AM     Permit Number 43169