trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1515 31846 7 7   1 Sidewalk: Curb side : Cutout Tree 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
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                    
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
1605 35819 7 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
1615 44603 7 17   121 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1619 95785 7 37 347 21st St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767529                    
1631 30310 7 70 228 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 8                    
1637 35981 7 135 83 Prospect Stairs Street 2 Sidewalk: Curb side : Cutout Tree 2   04/27/1998 12:00:00 AM     Permit Number 39135                    
1643 44855 7 17   17 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1648 35048 7 37 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
1665 47611 7 11 1201 Houston St 3 Sidewalk: Curb side : Cutout Tree 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
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                    
1759 35455 7 37 790 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1760 44538 7 17   31 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1762 30595 7 122 265 Walter St 2 Sidewalk: Curb side : Cutout Tree 2   01/26/1995 12:00:00 AM     Permit Number 34562                    
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                    
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                    
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                    
1978 87100 7 15 700 Connecticut St 1 Front Yard : Yard Tree 5       3x3 Permit Number 50056                    
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                    
2001 35044 7 17 700 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2031 48316 7 17   182 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2033 35052 7 17 700 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2043 66343 7 17   1 Sidewalk: Curb side : Cutout Tree 2   12/10/1990 12:00:00 AM     Permit Number 29464                    
2066 55924 7 17 524 Morgan Aly 1 Sidewalk: Curb side : Cutout Tree 2   05/17/1973 12:00:00 AM     Permit Number 11988                    
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                    
2087 261314 7 45 2601 Divisadero St 1 Sidewalk: Property side : Cutout Landscaping 2   12/31/2019 12:00:00 AM 3 6x106                      
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                    
2216 63596 7 17 253 Wallber St 1 Sidewalk: Curb side : Cutout Tree 2   05/05/1987 12:00:00 AM     Permit Number 24230                    
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                    
2283 49626 7 11 152211th/10th Houston St 1 Sidewalk: Curb side : Cutout Tree 2   05/13/2003 12:00:00 AM     Permit Number 46481                    
2296 32307 7 11 1097 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   08/19/1996 12:00:00 AM     Permit Number 36882                    
2318 61432 7 17 234 La Espiral St 1 Sidewalk: Curb side : Cutout Tree 2   05/07/1984 12:00:00 AM     Permit Number 21363                    
2319 34069 7 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
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                    
2371 57894 7 17 972 Terminal Way 1 Sidewalk: Curb side : Cutout Tree 2   05/25/1977 12:00:00 AM     Permit Number 16848                    
2424 61752 7 17 3014 Rolison Road 1 Sidewalk: Curb side : Cutout Tree 2   12/18/1984 12:00:00 AM     Permit Number 21763                    
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                    
2549 31437 7 17 4206 02nd St 1 Sidewalk: Curb side : Cutout Tree 2   05/01/1995 12:00:00 AM     Permit Number 35012                    
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