trees
39,840 rows where qLegalStatus_id = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
1539 | 39700 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
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 | |||
1571 | 56051 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.7684109649411 | -122.43229368198 | (37.7684109649411, -122.43229368198) | 15 | 5 | 5 | 28862 | 3 | ||
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 | |||
1585 | 34112 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||||||||||||||
1602 | 45381 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 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 | 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 | ||||||||||||||
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 | |||
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
1631 | 30310 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
1633 | 50106 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | 1 | 8 | 4 | 59 | 40 | ||
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 | |||||||||||||
1651 | 37169 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.7462364463923 | -122.423472053683 | (37.7462364463923, -122.423472053683) | 2 | 7 | 5 | 28859 | 22 | ||
1657 | 40280 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 307 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41432 | 6007215.02535858 | 2105520.83315888 | 37.7617668348059 | -122.418168222107 | (37.7617668348059, -122.418168222107) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||||||||||||
1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
1692 | 61474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.7662489975602 | -122.428035576337 | (37.7662489975602, -122.428035576337) | 8 | 4 | 5 | 28862 | 3 | ||
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 | |||||||||||||
1702 | 46741 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.7160695363268 | -122.462913152344 | (37.7160695363268, -122.462913152344) | 9 | 8 | 6 | 64 | 24 | ||
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 | ||||||||||||||
1733 | 36818 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1319 Egbert Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39533 | 6014721.91392724 | 2090796.36288096 | 37.7217561705213 | -122.391175415466 | (37.7217561705213, -122.391175415466) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||||
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 | |||||||||||||
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 | |||||||||||||
1803 | 55831 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 584 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1973 12:00:00 AM | 28 | Permit Number 11880 | 6002591.13434063 | 2102708.25019663 | 37.7537828093918 | -122.43395934272 | (37.7537828093918, -122.43395934272) | 2 | 4 | 5 | 28862 | 22 | ||
1812 | 52955 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.7200511847077 | -122.465273429637 | (37.7200511847077, -122.465273429637) | 9 | 8 | 6 | 64 | 24 | ||
1814 | 43257 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.7281186387281 | -122.407120168437 | (37.7281186387281, -122.407120168437) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||||||||||||||
1822 | 51694 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | 9 | 8 | 4 | 28861 | 40 | |||
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 | |||||||||||||
1868 | 37331 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 700 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39840 | 6003021.44463533 | 2104165.68333023 | 37.7578089842605 | -122.432575328482 | (37.7578089842605, -122.432575328482) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
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 | ||||||||||||||
1907 | 36575 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2959 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | |
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 | ||||||||||||||
1980 | 63280 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 363 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23841 | 6006563.98546453 | 2103999.80423144 | 37.7575537770148 | -122.420311952542 | (37.7575537770148, -122.420311952542) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||||||||||||
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 | |||
2025 | 97297 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 450 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994062.8 | 2112448.2 | 37.7800384821655 | -122.464159075962 | (37.7800384821655, -122.464159075962) | 11 | 6 | 2 | 54 | 11 | |||||
2027 | 32641 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
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 | |||
2050 | 50805 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | 15 | 5 | 11 | 29492 | 41 | |||
2063 | 87007 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
2074 | 64926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2340 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25954 | 5991486.3095246 | 2099579.02126823 | 37.7445543038697 | -122.472133919026 | (37.7445543038697, -122.472133919026) | 1 | 8 | 4 | 29491 | 40 | ||
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 | ||||||||||||||
2080 | 51849 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.432677808926 | (37.7594924661239, -122.432677808926) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | |||||
2157 | 66537 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 17 Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1995 12:00:00 AM | Permit Number 29712 | 6000633.94026001 | 2105546.19436908 | 37.76146384633 | -122.440931323073 | (37.76146384633, -122.440931323073) | 15 | 5 | 5 | 28862 | 3 | ||
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 | ||||||||||||||
2171 | 61848 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | 2 | 4 | 7 | 28859 | 19 | ||
2173 | 63110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23613 | 6006806.68286349 | 2099834.22007943 | 37.7461297072747 | -122.419177129276 | (37.7461297072747, -122.419177129276) | 2 | 7 | 7 | 28859 | 2 | ||
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 |
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) );