trees
11,761 rows where qSpecies_id = 17 sorted by PlotSize
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1249 | 107933 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
1255 | 66098 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1990 12:00:00 AM | Permit Number 29146 | ||||||||||||||
1261 | 45997 | Permitted Site 7 | Tree(s) :: 17 | 115 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1275 | 46058 | Permitted Site 7 | Tree(s) :: 17 | 188 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1287 | 48142 | Permitted Site 7 | Tree(s) :: 17 | 252 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1314 | 67685 | Permitted Site 7 | Tree(s) :: 17 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 58 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1356 | 44935 | Permitted Site 7 | Tree(s) :: 17 | 168 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1357 | 54090 | Permitted Site 7 | Tree(s) :: 17 | 115 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 189 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1381 | 84767 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 1030 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | Permit Number 31421 | |||||||||||||
1392 | 48291 | Permitted Site 7 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1395 | 33932 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1997 12:00:00 AM | Permit Number 37893 | ||||||||||||||
1397 | 44933 | Permitted Site 7 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1411 | 44977 | Permitted Site 7 | Tree(s) :: 17 | 49 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1413 | 48094 | Permitted Site 7 | Tree(s) :: 17 | 218 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1430 | 67640 | Permitted Site 7 | Tree(s) :: 17 | 66 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1982 12:00:00 AM | Permit Number 19591 | ||||||||||||||
1446 | 44592 | Permitted Site 7 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1451 | 44942 | Permitted Site 7 | Tree(s) :: 17 | 175 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1459 | 46036 | Permitted Site 7 | Tree(s) :: 17 | 110 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1461 | 44992 | Permitted Site 7 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1465 | 45986 | Permitted Site 7 | Tree(s) :: 17 | 226 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1479 | 44582 | Permitted Site 7 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1498 | 44556 | Permitted Site 7 | Tree(s) :: 17 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1508 | 48345 | Permitted Site 7 | Tree(s) :: 17 | 162 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1552 | 63329 | Permitted Site 7 | Tree(s) :: 17 | 225 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1987 12:00:00 AM | Permit Number 23902 | |||||||||||||
1555 | 61775 | Permitted Site 7 | Tree(s) :: 17 | 157 Lacrosse Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1984 12:00:00 AM | Permit Number 21796 | |||||||||||||
1559 | 68149 | Permitted Site 7 | Tree(s) :: 17 | 306 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 3025 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 129 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1583 | 57636 | Permitted Site 7 | Tree(s) :: 17 | 358 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 121 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1626 | 56962 | Permitted Site 7 | Tree(s) :: 17 | 409 Dellbrook Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1674 | 48081 | Permitted Site 7 | Tree(s) :: 17 | 245 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1691 | 63071 | Permitted Site 7 | Tree(s) :: 17 | 71 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 465 Convention Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1988 12:00:00 AM | Permit Number 25552 | |||||||||||||
1703 | 48311 | Permitted Site 7 | Tree(s) :: 17 | 177 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1743 | 55199 | Permitted Site 7 | Tree(s) :: 17 | 28 Dalmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | Permit Number 11112 | |||||||||||||
1747 | 44960 | Permitted Site 7 | Tree(s) :: 17 | 61 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1748 | 56640 | Permitted Site 7 | Tree(s) :: 17 | 2016 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004277.89575757 | 2115357.17634953 | 37.7886092629589 | -122.429027916831 | (37.7886092629589, -122.429027916831) | 13 | 9 | 11 | 29490 | 27 | |||||
1760 | 44538 | Permitted Site 7 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1784 | 44653 | Permitted Site 7 | Tree(s) :: 17 | 73 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1795 | 44610 | Permitted Site 7 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1802 | 68847 | Permitted Site 7 | Tree(s) :: 17 | 2118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1993 12:00:00 AM | Permit Number 32810 | |||||||||||||
1815 | 44628 | Permitted Site 7 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1821 | 48173 | Permitted Site 7 | Tree(s) :: 17 | 66 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1829 | 55200 | Permitted Site 7 | Tree(s) :: 17 | 32 Dalmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1972 12:00:00 AM | Permit Number 11113 | |||||||||||||
1831 | 48269 | Permitted Site 7 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1840 | 35278 | Permitted Site 7 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
1847 | 57850 | Permitted Site 7 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1977 12:00:00 AM | Permit Number 16791 | |||||||||||||
1883 | 55293 | Permitted Site 7 | Tree(s) :: 17 | 1278 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
1904 | 48103 | Permitted Site 7 | Tree(s) :: 17 | 212 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1917 | 46148 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
1934 | 44589 | Permitted Site 7 | Tree(s) :: 17 | 117 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1956 | 44540 | Permitted Site 7 | Tree(s) :: 17 | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1964 | 48189 | Permitted Site 7 | Tree(s) :: 17 | 43 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1968 | 44918 | Permitted Site 7 | Tree(s) :: 17 | 183 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1975 | 48204 | Permitted Site 7 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1984 | 48220 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1986 | 45957 | Permitted Site 7 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1987 | 44951 | Permitted Site 7 | Tree(s) :: 17 | 64 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1988 | 53775 | Permitted Site 7 | Tree(s) :: 17 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 700 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
2010 | 260603 | DPW Maintained 1 | Tree(s) :: 17 | 1162 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 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 | Permitted Site 7 | Tree(s) :: 17 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2033 | 35052 | Permitted Site 7 | Tree(s) :: 17 | 700 Peninsula Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
2043 | 66343 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/1990 12:00:00 AM | Permit Number 29464 | ||||||||||||||
2045 | 58189 | Permitted Site 7 | Tree(s) :: 17 | 1886 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 1434 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 524 Morgan Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1973 12:00:00 AM | Permit Number 11988 | |||||||||||||
2073 | 61706 | Permitted Site 7 | Tree(s) :: 17 | 577 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2090 | 260628 | DPW Maintained 1 | Tree(s) :: 17 | 1251 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 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 | Permitted Site 7 | Tree(s) :: 17 | 270 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2110 | 42133 | Permitted Site 7 | Tree(s) :: 17 | 69 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2146 | 45914 | Permitted Site 7 | Tree(s) :: 17 | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2153 | 100644 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
2161 | 64075 | Permitted Site 7 | Tree(s) :: 17 | 370 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
2170 | 44902 | Permitted Site 7 | Tree(s) :: 17 | 136 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2177 | 44598 | Permitted Site 7 | Tree(s) :: 17 | 126 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2187 | 46061 | Permitted Site 7 | Tree(s) :: 17 | 103 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2189 | 48278 | Permitted Site 7 | Tree(s) :: 17 | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2196 | 48265 | Permitted Site 7 | Tree(s) :: 17 | 129 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2200 | 54869 | Permitted Site 7 | Tree(s) :: 17 | 1967 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard | Tree | DPW 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 | Permitted Site 7 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2210 | 53264 | Permitted Site 7 | Tree(s) :: 17 | 523 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 253 Wallber St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | Permit Number 24230 | |||||||||||||
2225 | 44536 | Permitted Site 7 | Tree(s) :: 17 | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2226 | 44987 | Permitted Site 7 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2265 | 48308 | Permitted Site 7 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2269 | 58628 | Permitted Site 7 | Tree(s) :: 17 | 1240 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 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 | Permitted Site 7 | Tree(s) :: 17 | 200 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );