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)
1249 107933 1 17 3098X Market St 1 Median : Yard Tree 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
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                    
1314 67685 7 17 766 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/05/1992 12:00:00 AM     Permit Number 31289 5997024.37469935 2095029.17182905 37.7323804536882 -122.452656198743 (37.7323804536882, -122.452656198743) 9 7 4 59 40
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                    
1357 54090 7 17 115 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree 2   05/11/1972 12:00:00 AM     Permit Number 9817 5991911.06498332 2095358.19732765 37.7329895631391 -122.47035789011 (37.7329895631391, -122.47035789011) 9 8 4 59 40
1372 48323 7 17   189 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1381 84767 7 17 185 Berry St 13 Sidewalk: Curb side : Cutout Tree 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
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                    
1430 67640 7 17 66 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/30/1992 12:00:00 AM     Permit Number 31239 5999465.40351772 2088851.00886819 37.7155562089288 -122.443773323232 (37.7155562089288, -122.443773323232) 9 7 6 28861 25
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                    
1559 68149 7 17 306 Santa Ana Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/03/1993 12:00:00 AM     Permit Number 31907 5992597.64738181 2094843.40601485 37.731615747375 -122.467946785243 (37.731615747375, -122.467946785243) 9 8 4 59 40
1575 57819 7 17 3025 Judah St 1 Sidewalk: Curb side : Cutout Tree 2   03/11/1977 12:00:00 AM     Permit Number 16758 5985127.82530714 2105650.40400841 37.7608546360174 -122.494567452266 (37.7608546360174, -122.494567452266) 1 8 3 56 35
1579 45978 7 17   129 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1583 57636 7 17 358 Douglass St 1 Sidewalk: Curb side : Cutout Tree 2   11/16/1976 12:00:00 AM     Permit Number 16534 6001116.64364888 2104248.07049337 37.7579269953626 -122.439168812397 (37.7579269953626, -122.439168812397) 2 4 5 28862 38
1615 44603 7 17   121 Sidewalk: Curb side : Cutout Tree 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1626 56962 7 17 409 Dellbrook Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/21/1974 12:00:00 AM     Permit Number 14214 5997128.15585412 2102761.97155727 37.7536187770602 -122.452855347756 (37.7536187770602, -122.452855347756) 1 5 4 63 38
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                    
1691 63071 7 17 71 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree 2   11/21/1986 12:00:00 AM     Permit Number 23549 6008174.41886116 2098235.80863024 37.741817754914 -122.414334581564 (37.741817754914, -122.414334581564) 2 7 7 28859 2
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                    
1748 56640 7 17 2016 Pine St 1 Sidewalk: Curb side : Cutout Tree 2           6004277.89575757 2115357.17634953 37.7886092629589 -122.429027916831 (37.7886092629589, -122.429027916831) 13 9 11 29490 27
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                    
1883 55293 7 17 1278 25th Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/29/1972 12:00:00 AM     Permit Number 11219 5988350.42063123 2106618.18291031 37.7636999785063 -122.483493006804 (37.7636999785063, -122.483493006804) 1 8 3 56 35
1892 124739 1 17 999 Brannan St 8 Sidewalk: Curb side : Cutout Tree 2           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328) 14 2 9 28853 34
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                    
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                    
1988 53775 7 17 358 San Benito Way 1 Sidewalk: Curb side : Cutout Tree 2   02/03/1972 12:00:00 AM     Permit Number 9461 5992772.54452217 2094326.15826887 37.7302056116577 -122.467304539962 (37.7302056116577, -122.467304539962) 9 8 4 59 40
2001 35044 7 17 700 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2010 260603 1 17 1162 Ingerson Ave   Sidewalk: Curb side : Cutout Tree 1 FUF 08/24/2019 12:00:00 AM 3     6013406.09782 2090446.93369 37.7207235989971 -122.395699409803 (37.7207235989971, -122.395699409803) 10 3 8 58 1
2014 54352 7 17 1225 05th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/20/1972 12:00:00 AM     Permit Number 10116 5994514.2261377 2107168.64010197 37.765568215693 -122.462214395283 (37.765568215693, -122.462214395283) 11 5 11 56 12
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                    
2045 58189 7 17 1886 41st Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/25/1978 12:00:00 AM     Permit Number 17176 5983531.02908859 2102317.07249767 37.751608654204 -122.499843586703 (37.751608654204, -122.499843586703) 1 8 3 56 35
2049 54416 7 17 1434 10th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/19/1972 12:00:00 AM     Permit Number 10189 5993066.16109228 2105705.87123128 37.761468352883 -122.467116526016 (37.761468352883, -122.467116526016) 1 8 4 56 12
2066 55924 7 17 524 Morgan Aly 1 Sidewalk: Curb side : Cutout Tree 2   05/17/1973 12:00:00 AM     Permit Number 11988                    
2073 61706 7 17 577 14th St 1 Sidewalk: Curb side : Cutout Tree 2   12/06/1984 12:00:00 AM     Permit Number 21705 6005012.13015345 2107778.74606637 37.7678422856405 -122.42594789448 (37.7678422856405, -122.42594789448) 8 4 5 28853 19
2076 44958 7 17   82 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2090 260628 1 17 1251 Revere Ave   Sidewalk: Curb side : Cutout Tree 1 FUF 08/24/2019 12:00:00 AM 3     6016934.60308 2092996.85523 37.7279208386687 -122.383679778477 (37.7279208386687, -122.383679778477) 10 3 8 58 1
2102 48160 7 17   270 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2110 42133 7 17 69 Henry St 1 Sidewalk: Curb side : Cutout Tree 2   06/21/2000 12:00:00 AM     Permit Number 42429 6003074.74673035 2107378.43779911 37.7666334554934 -122.43262047379 (37.7666334554934, -122.43262047379) 15 5 5 28862 3
2113 44856 7 17   33 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2146 45914 7 17   33 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2153 100644 7 17 401X Clementina St 14 Sidewalk: Curb side : Cutout Tree 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
2161 64075 7 17 370 21st St 1 Sidewalk: Curb side : Cutout Tree 2   10/27/1987 12:00:00 AM     Permit Number 24835 5989375.82342137 2112846.61573071 37.7808611682899 -122.480402425995 (37.7808611682899, -122.480402425995) 11 6 2 55 26
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                    
2200 54869 7 17 1967 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2   08/17/1972 12:00:00 AM     Permit Number 10729 5998462.86042081 2109983.76069669 37.773524386553 -122.448759792732 (37.773524386553, -122.448759792732) 15 5 11 29492 16
2201 107549 6 17 198X Jennings St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
2203 45984 7 17   123 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2210 53264 7 17 523 Head St 1 Sidewalk: Curb side : Cutout Tree 2   07/28/1969 12:00:00 AM     Permit Number 6154 5993474.77624345 2089341.33970508 37.7165590253308 -122.464515046881 (37.7165590253308, -122.464515046881) 9 8 6 64 24
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                    
2265 48308 7 17   174 Sidewalk: Curb side : Cutout Tree 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2269 58628 7 17 1240 Cole St 1 Sidewalk: Curb side : Cutout Tree 2   04/04/1979 12:00:00 AM     Permit Number 17846 5998229.96040674 2106129.9560019 37.7629294984974 -122.449287716214 (37.7629294984974, -122.449287716214) 15 5 11 29492 9
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