trees

39,840 rows where qLegalStatus_id = 7 sorted by DBH

✎ View and edit SQL

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)
1447 43059 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 3033 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42909 5983784.03584538 2100159.31178354 37.7456988823219 -122.498809278198 (37.7456988823219, -122.498809278198) 1 8 3 29491 35
1450 43844 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2736 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2003 12:00:00 AM     Permit Number 43466 5985584.65410627 2096702.64202879 37.7363132411039 -122.492328600224 (37.7363132411039, -122.492328600224) 1 8 3 29491 35
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                    
1452 50129 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 126 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46851 5992933.01758855 2098244.53048723 37.740973745145 -122.467034533605 (37.740973745145, -122.467034533605) 1 8 4 59 40
1458 97747 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2685 30th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18001 5986960.2 2097027.9 37.7372866359421 -122.487596715706 (37.7372866359421, -122.487596715706) 1 8 3 29491 35
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                    
1460 30324 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 720 Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/17/1956 12:00:00 AM     Permit Number 16 6011772.9424544 2117800.56968196 37.7957396438077 -122.403267984357 (37.7957396438077, -122.403267984357) 3 1 10 28860 4
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                    
1489 69250 Permitted Site 7 Maytenus boaria :: Mayten 58 1838 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/1994 12:00:00 AM     Permit Number 33318 5991599.04334449 2102860.56941142 37.7535711078961 -122.471983242544 (37.7535711078961, -122.471983242544) 1 8 4 56 12
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                    
1503 33210 Permitted Site 7 :: 45 80 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.7446507048802 -122.454762009134 (37.7446507048802, -122.454762009134) 1 5 4 59 40
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                    
1518 99500 Permitted Site 7 Aesculus hippocastanum :: White Horsechestnut 190 2698@Divisadero Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000656 2117555 37.7944382299983 -122.441716891944 (37.7944382299983, -122.441716891944) 13 9 1 57 27
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
1572 36143 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 1027 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM   3x3 Permit Number 39232 5992592.32005608 2107256.68934819 37.7656991270754 -122.468868188853 (37.7656991270754, -122.468868188853) 11 8 11 56 12
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                    
1617 87946 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 143 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50969 6000889 2105548 37.7614833276299 -122.440049308669 (37.7614833276299, -122.440049308669) 15 5 5 28862 3
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                    
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                    
1642 92622 Permitted Site 7 Tree(s) :: 17 1150 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2009 12:00:00 AM   3x3 Permit Number 52926 6002360 2112465 37.7805593321564 -122.43545656304 (37.7805593321564, -122.43545656304) 15 5 11 29490 41
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                    
1649 92526 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 275 10th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6008743 2109634 37.7731465224788 -122.413174412357 (37.7731465224788, -122.413174412357) 8 2 9 28853 34
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                    
1676 84541 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 838 31st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51852 5986369.18358167 2110196.92433931 37.7734106873115 -122.49060871536 (37.7734106873115, -122.49060871536) 11 6 2 55 26
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                    
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
1895 73501 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.7492053706113 -122.436016109621 (37.7492053706113, -122.436016109621) 2 4 5 28862 22
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                    
1978 87100 Permitted Site 7 Pinus radiata :: Monterey Pine 15 700 Connecticut St 1 Front Yard : Yard Tree Rec/Park 5       3x3 Permit Number 50056                    
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
1981 40499 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 44 Aptos Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/1999 12:00:00 AM   3x3 Permit Number 50329 5993102.74682774 2094714.88282209 37.7312920097199 -122.466191234844 (37.7312920097199, -122.466191234844) 9 8 4 59 40
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
1995 87953 Permitted Site 7 Cordyline australis :: Dracena Palm 64 495 Harkness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171) 10 7 8 309 39
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);