trees
163,064 rows where qCaretaker_id = 2 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
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 | ||||||||||||||
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
1600 | 46288 | Permitted Site 7 | Robinia x ambigua :: Locust 196 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
1605 | 35819 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39055 | |||||||||||||
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 | ||||||||||||||
1619 | 95785 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 347 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | |||||||||||
1631 | 30310 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
1637 | 35981 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 83 Prospect Stairs Street | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | Permit Number 39135 | |||||||||||||
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 | ||||||||||||||
1648 | 35048 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 700 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
1665 | 47611 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | Permit Number 45444 | |||||||||||||
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 | ||||||||||||||
1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
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 | ||||||||||||||
1751 | 121138 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
1759 | 35455 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 790 Peninsula Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38883 | |||||||||||||
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 | ||||||||||||||
1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
1770 | 122656 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
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 | ||||||||||||||
1794 | 42923 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42829 | ||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
1928 | 43486 | Permitted Site 7 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43169 | ||||||||||||||
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 | ||||||||||||||
1940 | 43017 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42880 | ||||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
2083 | 46724 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
2100 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 199X Kissling St | 1 | Side Yard : Cutout | Tree | Private 2 | 5x10 | ||||||||||||||
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 | ||||||||||||||
2108 | 35196 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
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 | ||||||||||||||
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
2241 | 46289 | Permitted Site 7 | Robinia x ambigua :: Locust 196 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
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 | ||||||||||||||
2267 | 46716 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
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 | ||||||||||||||
2277 | 44912 | Permitted Site 7 | Tree(s) :: 17 | 185 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2283 | 49626 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152211th/10th Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46481 | |||||||||||||
2296 | 32307 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36882 | |||||||||||||
2318 | 61432 | Permitted Site 7 | Tree(s) :: 17 | 234 La Espiral St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1984 12:00:00 AM | Permit Number 21363 | |||||||||||||
2319 | 34069 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
2323 | 35205 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
2339 | 44535 | Permitted Site 7 | Tree(s) :: 17 | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2366 | 45917 | Permitted Site 7 | Tree(s) :: 17 | 63 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2371 | 57894 | Permitted Site 7 | Tree(s) :: 17 | 972 Terminal Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1977 12:00:00 AM | Permit Number 16848 | |||||||||||||
2424 | 61752 | Permitted Site 7 | Tree(s) :: 17 | 3014 Rolison Road | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1984 12:00:00 AM | Permit Number 21763 | |||||||||||||
2434 | 44999 | Permitted Site 7 | Tree(s) :: 17 | 103 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2445 | 48349 | Permitted Site 7 | Tree(s) :: 17 | 152 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2451 | 44962 | Permitted Site 7 | Tree(s) :: 17 | 75 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2483 | 34134 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37986 |
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) );