trees

163,064 rows where qCaretaker_id = 2 sorted by PlotSize

✎ 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)
514 45011 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
518 70144 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 8 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5991175.64413 2115000.10527 37.7868784805694 -122.474333220033 (37.7868784805694, -122.474333220033) 11 6 1 54 33
521 100638 Permitted Site 7 Tree(s) :: 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
522 74913 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1600 Cabrillo St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5990592.63982 2110647.77936 37.7748944063775 -122.476032267507 (37.7748944063775, -122.476032267507) 11 6 2 55 26
525 33087 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
527 32100 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 156 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1995 12:00:00 AM 10   Permit Number 35473 6002658.19542 2104999.95129 37.7600790771166 -122.433891224619 (37.7600790771166, -122.433891224619) 2 4 5 28862 3
528 57932 Permitted Site 7 Tree(s) :: 17 583 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM     Permit Number 16891 5999047.47505332 2086793.7936429 37.7098837148731 -122.445070058439 (37.7098837148731, -122.445070058439) 9 7 6 28861 5
530 35187 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
531 46009 Permitted Site 7 Tree(s) :: 17   195 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
540 35140 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 911 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 7   Permit Number 38670 6001882.60594 2088665.49745 37.7151844124098 -122.435405132561 (37.7151844124098, -122.435405132561) 9 7 6 28861 5
542 35050 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
548 48279 Permitted Site 7 Tree(s) :: 17   89 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
549 63156 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 1483 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1986 12:00:00 AM     Permit Number 23692 5992405.6320278 2105370.20909848 37.7605085633711 -122.4693765688 (37.7605085633711, -122.4693765688) 1 8 4 56 12
552 78931 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2701 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5986423.7343 2105012.1654 37.7591779705862 -122.490038592243 (37.7591779705862, -122.490038592243) 1 8 3 56 35
554 63105 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 86 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23825 6006733.57538349 2099199.19959074 37.7443819667232 -122.41938488452 (37.7443819667232, -122.41938488452) 2 7 7 28859 2
556 116312 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1515 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     12     6001647.9793 2113762.7776 37.784082235457 -122.438012762917 (37.784082235457, -122.438012762917) 15 6 11 29490 13
557 44837 Permitted Site 7 Tree(s) :: 17   11 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
560 97763 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 115 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2011 12:00:00 AM 1   Permit Number 768298 5996511.5635 2113681.1555 37.783564683267 -122.455776900676 (37.783564683267, -122.455776900676) 11 6 1 54 31
564 67334 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 801 University St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/21/1992 12:00:00 AM 12   Permit Number 30818 6008868.73151 2090340.18885 37.7201770527016 -122.411376204361 (37.7201770527016, -122.411376204361) 9 3 7 309 28
568 78813 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 110 Foote Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5998921.12979 2088066.27223 37.713370441156 -122.445598173631 (37.713370441156, -122.445598173631) 9 7 6 28861 25
579 41331 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 1099 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/25/2000 12:00:00 AM 8   Permit Number 41989 6015098.10078 2102956.66001 37.7551667237886 -122.390724391438 (37.7551667237886, -122.390724391438) 10 3 8 28856 29
580 65382 DPW Maintained 1 Olea europaea :: Olive Tree 9 1709 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/1989 12:00:00 AM 9   Permit Number 28221 6000542.2902 2114603.4223 37.7863274878262 -122.441898393886 (37.7863274878262, -122.441898393886) 13 6 1 29490 27
586 178423 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 226 Athens St 2 Sidewalk: Property side : Yard Tree Private 2     5     6004525.81285 2091935.4006 37.7243126139184 -122.426501755257 (37.7243126139184, -122.426501755257) 9 7 6 28861 5
587 37078 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1318 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 2   Permit Number 39680 5982466.3981 2106106.9098 37.7619519432804 -122.50380580728 (37.7619519432804, -122.50380580728) 1 8 3 56 35
588 59987 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1546 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1982 12:00:00 AM 20   Permit Number 19471 6015827.92235 2097026.68646 37.7389247113108 -122.387786695709 (37.7389247113108, -122.387786695709) 10 3 8 58 1
589 108776 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 500X Lathrop Ave 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
590 75888 DPW Maintained 1 Fraxinus spp :: Ash Spp 121 350 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6011802.87578 2118766.0417 37.7983922692391 -122.403232358505 (37.7983922692391, -122.403232358505) 3 1 10 308 23
599 78256 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6002680.72455 2088998.08405 37.7161429170478 -122.432670234864 (37.7161429170478, -122.432670234864) 9 7 6 28861 5
601 83308 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1773-1775 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6014316.33002 2095278.14651 37.7340397288572 -122.392890824075 (37.7340397288572, -122.392890824075) 10 3 8 58 1
605 52150 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1646 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 5   Permit Number 48341 6014994.17904 2096246.44188 37.7367360986871 -122.390614910664 (37.7367360986871, -122.390614910664) 10 3 8 58 1
607 34245 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 778 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1997 12:00:00 AM 8   Permit Number 38055 6011531.92576 2104772.40188 37.7599538473986 -122.403185056849 (37.7599538473986, -122.403185056849) 10 3 8 28856 29
612 223703 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1100 San Jose Ave 77 Front Yard : Yard Tree Private 2     18     6004573.37155 2096423.41392 37.7366383864359 -122.426656795699 (37.7366383864359, -122.426656795699) 2 7 5 63 7
614 82138 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 360 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5993114.28903 2113170.01374 37.7819656727858 -122.467492879752 (37.7819656727858, -122.467492879752) 11 6 2 54 11
620 74869 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 751 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5991293.21229 2110325.51656 37.7740501576748 -122.473585351012 (37.7740501576748, -122.473585351012) 11 6 2 54 26
622 48348 Permitted Site 7 Tree(s) :: 17   153 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
626 75627 DPW Maintained 1 Maytenus boaria :: Mayten 58 1345 Vicente St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5988723.2495 2097607.46 37.7389806270439 -122.481543546445 (37.7389806270439, -122.481543546445) 1 8 3 29491 35
627 34919 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
634 79736 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 705 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6008945.3206 2110776.64932 37.7762953249107 -122.412555345054 (37.7762953249107, -122.412555345054) 8 2 9 28853 34
636 67551 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 655 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 8   Permit Number 31099 6011561.87177 2105285.59303 37.7613646282886 -122.403117586111 (37.7613646282886, -122.403117586111) 10 3 8 28856 29
637 35060 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 5545 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1999 12:00:00 AM     Permit Number 41350 6014167.69706675 2092844.73590691 37.7273498207281 -122.393234476852 (37.7273498207281, -122.393234476852) 10 3 8 58 1
650 46071 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44455                    
651 59344 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 532 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1980 12:00:00 AM 8   Permit Number 18692 6000155.0247 2110781.0357 37.7758101209138 -122.44296363094 (37.7758101209138, -122.44296363094) 15 5 11 29492 16
655 73536 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2270 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5987645.1852 2099831.4757 37.7450244421871 -122.485434109471 (37.7450244421871, -122.485434109471) 1 8 3 29491 35
656 37103 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39701 5981201.77477995 2106888.46207069 37.7640234205488 -122.508237579769 (37.7640234205488, -122.508237579769) 1 8 3 56 35
661 48170 Permitted Site 7 Tree(s) :: 17   63 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
666 49628 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1591 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 3   Permit Number 46483 6007746.40275 2109230.16933 37.7719816997133 -122.416593168865 (37.7719816997133, -122.416593168865) 8 2 9 28853 19
669 30402 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
676 44636 Permitted Site 7 Tree(s) :: 17   164 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
680 47114 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 65 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45098 6008176.0434029 2098254.72889507 37.7418697970416 -122.414330302805 (37.7418697970416, -122.414330302805) 2 7 7 28859 2
681 71797 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2033 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5998131.4502 2109940.9744 37.7733879494567 -122.449903100064 (37.7733879494567, -122.449903100064) 15 5 11 29492 16
683 38304 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
692 61241 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3970 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/1984 12:00:00 AM     Permit Number 21113 6003879.55901956 2104241.51200503 37.7580658175007 -122.429613020503 (37.7580658175007, -122.429613020503) 2 4 5 28862 3
693 60435 Permitted Site 7 Tree(s) :: 17 471 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/1982 12:00:00 AM     Permit Number 20019 6003532.89070287 2098907.31164333 37.7433997199793 -122.430431357539 (37.7433997199793, -122.430431357539) 2 7 5 63 22
696 60808 DPW Maintained 1 Maytenus boaria :: Mayten 58 2075 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1983 12:00:00 AM 8   Permit Number 20486 5989723.8885 2101238.2089 37.7490078493386 -122.478349246975 (37.7490078493386, -122.478349246975) 1 8 3 29491 35
700 53215 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 770 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/16/1956 12:00:00 AM 12   Permit Number 39 6013009.5189 2103441.54791 37.756382021722 -122.397981381646 (37.756382021722, -122.397981381646) 10 3 8 28856 29
701 52560 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1742 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 7   Permit Number 48656 5984113.6499 2103302.6049 37.7543488257224 -122.497901608629 (37.7543488257224, -122.497901608629) 1 8 3 56 35
702 62566 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 484 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1986 12:00:00 AM 11   Permit Number 22767 6011457.1056 2106150.727 37.7637342411783 -122.403540799888 (37.7637342411783, -122.403540799888) 8 3 8 28856 29
706 44899 Permitted Site 7 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
713 38369 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 4245 Lawton St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1998 12:00:00 AM 5   Permit Number 40431 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224) 1 8 3 56 35
715 67254 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2107 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1994 12:00:00 AM 4   Permit Number 32998 5981675.3208 2100708.9402 37.7470841010946 -122.506141523298 (37.7470841010946, -122.506141523298) 1 8 3 29491 35
719 80747 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1111 Munich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6001772.74556 2087054.04067 37.7107534679609 -122.435669635744 (37.7107534679609, -122.435669635744) 9 7 6 28861 5
721 46041 Permitted Site 7 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
722 48068 Permitted Site 7 Tree(s) :: 17   234 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
723 62606 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 818 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1986 12:00:00 AM 11   Permit Number 22914 5984501.0298 2110256.07846 37.7734638082368 -122.497075193473 (37.7734638082368, -122.497075193473) 11 6 2 55 26
738 55617 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM 6   Permit Number 20476 5998121.25588 2115028.99118 37.7873577334097 -122.45030520092 (37.7873577334097, -122.45030520092) 11 6 1 54 31
739 38480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2515 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 9   Permit Number 40479 5999797.20513 2119471.52027 37.7996515161494 -122.444826245059 (37.7996515161494, -122.444826245059) 13 9 1 57 17
742 37975 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 1199 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.7564076382433 -122.389020897855 (37.7564076382433, -122.389020897855) 10 3 8 28856 29
745 43286 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1200 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM 13   Permit Number 43056 6013973.47383 2105741.62866 37.7627511832352 -122.394808740727 (37.7627511832352, -122.394808740727) 14 3 8 28856 29
747 59192 Permitted Site 7 Tree(s) :: 17 253 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1980 12:00:00 AM     Permit Number 18508 6001467.56641345 2096421.00019604 37.7364556803125 -122.437394709055 (37.7364556803125, -122.437394709055) 2 7 5 63 7
749 72500 DPW Maintained 1 Podocarpus macrophyllus :: Yew Pine 137 2311 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5986050.4379 2098869.9561 37.7422913280707 -122.49087764471 (37.7422913280707, -122.49087764471) 1 8 3 29491 35
756 124716 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2195 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2                              
769 35030 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 403 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1998 12:00:00 AM 15   Permit Number 38603 6015647.17286 2114807.4956 37.7877369613497 -122.389653177477 (37.7877369613497, -122.389653177477) 6 2 9 28855 6
772 132391 DPW Maintained 1 Pittosporum eugenioides :: Tarata 138 2833 Larkin St 2 Side Yard : Yard Tree Private 2     31     6006489.42377 2120936.29447 37.8040530536607 -122.421772791676 (37.8040530536607, -122.421772791676) 5 9 1 28858 32
774 208910 DPW Maintained 1 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 24 Melrose Ave 1 Sidewalk: Property side : Yard Tree Private 2     13     5999949.61858 2095523.77288 37.7339056911991 -122.442578479527 (37.7339056911991, -122.442578479527) 9 7 4 63 40
777 84774 Permitted Site 7 Tree(s) :: 17 185 Berry St 20 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
778 61131 Permitted Site 7 Tree(s) :: 17 76 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/1983 12:00:00 AM     Permit Number 20983 5998241.83548559 2106883.25514995 37.7649985471459 -122.449300920602 (37.7649985471459, -122.449300920602) 15 5 11 29492 9
779 69766 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1725 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6014547.15395 2096165.56329 37.7364892123042 -122.392154828809 (37.7364892123042, -122.392154828809) 10 3 8 58 1
783 56824 Permitted Site 7 Tree(s) :: 17 1787 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM     Permit Number 14055 5988492.53915334 2103043.35746657 37.7538927457413 -122.482739478412 (37.7538927457413, -122.482739478412) 1 8 3 56 35
784 187688 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 399X Ash St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2017 12:00:00 AM 3                        
790 55179 Permitted Site 7 Tree(s) :: 17 2201 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1972 12:00:00 AM     Permit Number 11088                    
793 64948 Permitted Site 7 Tree(s) :: 17 263 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/1989 12:00:00 AM     Permit Number 25979 6013492.3823467 2105864.52669583 37.763061873209 -122.39648129263 (37.763061873209, -122.39648129263) 14 3 8 28856 29
794 44541 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
796 36869 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
799 72078 DPW Maintained 1 Rhamnus alaternus :: Italian Buckthorn 29 167 20th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/2020 12:00:00 AM 3     5989583.57132 2114255.42421 37.784741432124 -122.479786850818 (37.784741432124, -122.479786850818) 11 6 2 55 26
800 43502 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 401 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2000 12:00:00 AM     Permit Number 43180 6008272.42807324 2096955.00828501 37.7383064636933 -122.413905114955 (37.7383064636933, -122.413905114955) 2 7 7 28859 2
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
810 75303 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 376 Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6010591.15079 2106579.14528 37.7648621726769 -122.406566076957 (37.7648621726769, -122.406566076957) 8 4 8 28853 19
814 261435 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 371 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007244 2095778 37.7350168462428 -122.417377534221 (37.7350168462428, -122.417377534221) 2 7 7 28859 2
816 248050 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 38 Rutledge St 7 Side Yard : Yard Tree Private 2     5     6010496.13368 2099436.61391 37.7452450531093 -122.406391405264 (37.7452450531093, -122.406391405264) 2 7 7 28859 2
818 71164 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2118 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5988230.9552 2100880.1949 37.7479380567645 -122.483485514105 (37.7479380567645, -122.483485514105) 1 8 3 29491 35
820 41547 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 244 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2000 12:00:00 AM     Permit Number 42070 6001730.08855162 2104417.99791196 37.7584284625233 -122.437059430993 (37.7584284625233, -122.437059430993) 2 4 5 28862 3
823 33293 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 166 Sproule Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 10   Permit Number 37451 6009221.08576 2116982.79677 37.7933513902069 -122.412040085683 (37.7933513902069, -122.412040085683) 3 1 10 28857 21
835 61682 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 27 Ceres St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/1984 12:00:00 AM 4   Permit Number 21679 6013919.66127 2093997.42296 37.7305010827376 -122.394172607985 (37.7305010827376, -122.394172607985) 10 3 8 58 1
839 71209 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2170 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988552.6315 2100561.3439 37.7470812936995 -122.48234982645 (37.7470812936995, -122.48234982645) 1 8 3 29491 35
841 44570 Permitted Site 7 Tree(s) :: 17   134 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
843 38804 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
845 35702 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   15 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
849 51822 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 75 Dore St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM 11   Permit Number 48062 6008911.92726 2109811.9687 37.7736446648878 -122.412602652111 (37.7736446648878, -122.412602652111) 8 2 9 28853 34
855 48153 Permitted Site 7 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    

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