trees

39,840 rows where qLegalStatus_id = 7

✎ 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)
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                    
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
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
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                    
847 92588 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 11 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
852 108444 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 2 3x2.5   6014877 2117007 37.7937335561349 -122.392471758503 (37.7937335561349, -122.392471758503) 12 2 9 28855 6
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                    
862 51904 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 168 Caselli Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.442410364393 (37.7596792654558, -122.442410364393) 2 4 5 28862 3
865 65062 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 481 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/31/1989 12:00:00 AM     Permit Number 27018 5982198.4613122 2112526.22921648 37.7795617740877 -122.505208255718 (37.7795617740877, -122.505208255718) 11 6 2 55 26
866 28332 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3247 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2004 12:00:00 AM 9 3x3   6006498.83651 2099346.51324 37.74477323292 -122.420207017141 (37.74477323292, -122.420207017141) 2 7 7 28859 2
870 65298 Permitted Site 7 Tree(s) :: 17 601 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM     Permit Number 28112 6004986.98138427 2104867.56644754 37.7598474581316 -122.42582763941 (37.7598474581316, -122.42582763941) 2 4 5 28859 19
892 44903 Permitted Site 7 Tree(s) :: 17   137 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
904 48322 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
912 48169 Permitted Site 7 Tree(s) :: 17   62 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
913 128077 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009569.08364 2121877.54409 37.8068106763465 -122.411181901328 (37.8068106763465, -122.411181901328) 3 1 10 308 23
920 91853 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 601x Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
921 61549 Permitted Site 7 Tree(s) :: 17 1129 Huff Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1984 12:00:00 AM     Permit Number 21507                    
928 67058 Permitted Site 7 Tree(s) :: 17 180 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1992 12:00:00 AM   3x3 Permit Number 30439 6009767.36044891 2111443.36861251 37.7781720795529 -122.409758741886 (37.7781720795529, -122.409758741886) 8 2 9 28853 34
937 95737 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 445 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767484 6003120.3 2091142.7 37.7220564786865 -122.431303852024 (37.7220564786865, -122.431303852024) 9 7 6 28861 5
942 67185 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 154 Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM 12   Permit Number 30632 5998076.31886872 2105384.33640813 37.7608734252807 -122.449765371246 (37.7608734252807, -122.449765371246) 15 5 11 29492 12
947 60023 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1982 12:00:00 AM     Permit Number 19510                    
949 38398 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
958 36868 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
959 49689 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2235 NOTES) Hayes St 20 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2003 12:00:00 AM     Permit Number 46511 5997175.15188937 2109805.23760487 37.7729604879505 -122.453201252207 (37.7729604879505, -122.453201252207) 15 5 11 29492 16
960 45842 Permitted Site 7 Tree(s) :: 17   84 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
964 44568 Permitted Site 7 Tree(s) :: 17   141 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
970 43482 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   8 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
972 58852 Permitted Site 7 Tree(s) :: 17 198 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/1979 12:00:00 AM     Permit Number 18111 6007897.70750463 2097731.51362688 37.7404175243374 -122.415255671137 (37.7404175243374, -122.415255671137) 2 7 7 28859 2
974 48301 Permitted Site 7 Tree(s) :: 17   167 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
980 96180 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    
983 44952 Permitted Site 7 Tree(s) :: 17   65 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
989 40872 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3456 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1999 12:00:00 AM     Permit Number 41788 5998239.16759035 2115871.78992415 37.7896785829725 -122.449958017829 (37.7896785829725, -122.449958017829) 13 6 1 54 31
991 38251 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1475 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40361 6007534.04468586 2107333.12590687 37.7667609198383 -122.417193284079 (37.7667609198383, -122.417193284079) 8 4 7 28853 19
992 192119 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
997 42493 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 50 Phelan Ave 18 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42614 5997102.28501 2092861.95301 37.7264342507672 -122.452230525303 (37.7264342507672, -122.452230525303) 9 7 4 28861 40
1000 52636 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 185@ BELMONT Edgewood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48718 5996563.25999555 2105933.66378054 37.7622950546263 -122.455038038603 (37.7622950546263, -122.455038038603) 15 5 11 29492 12
1004 50532 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2003 12:00:00 AM     Permit Number 47171 5996679.82856356 2106618.62344586 37.7641824656847 -122.454684361894 (37.7641824656847, -122.454684361894) 15 5 11 29492 12
1005 39481 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
1007 44545 Permitted Site 7 Tree(s) :: 17   24 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1008 48288 Permitted Site 7 Tree(s) :: 17   98 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1011 45966 Permitted Site 7 Tree(s) :: 17   157 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1014 48047 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 3251 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   2x2 Permit Number 52041 6007813.0003926 2105579.22117963 37.7619607946272 -122.416104194982 (37.7619607946272, -122.416104194982) 2 4 7 28859 19
1015 52400 Permitted Site 7 Acer buergeranum :: Trident Maple 110 47@ MISSION Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/01/2005 12:00:00 AM     Permit Number 48521 6005927.5376712 2097730.99268597 37.7403051709369 -122.422067716571 (37.7403051709369, -122.422067716571) 2 7 7 28859 2
1017 46142 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   3 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44490                    
1028 67081 Permitted Site 7 Arbutus unedo :: Strawberry Tree 106 345 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1995 12:00:00 AM     Permit Number 30479 6006832.91402463 2097113.31465906 37.7386601871907 -122.418893482297 (37.7386601871907, -122.418893482297) 2 7 7 28859 2
1032 39972 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 0 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
1035 44875 Permitted Site 7 Tree(s) :: 17   148 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1036 82363 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1455 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2007 12:00:00 AM   3x3 Permit Number 49901 6007633.52614619 2107338.64546667 37.7667816713746 -122.416849584537 (37.7667816713746, -122.416849584537) 8 4 7 28853 19
1037 63388 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 139 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23969 6005989.66886949 2095872.0431692 37.7352044148911 -122.421720887046 (37.7352044148911, -122.421720887046) 2 7 7 28859 2
1039 51110 Permitted Site 7 Koelreuteria paniculata :: Golden Rain Tree 131 420@ 6TH ST Berry St 21 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2004 12:00:00 AM     Permit Number 47557 6013008.01748439 2109097.62504611 37.7719122726701 -122.398383421945 (37.7719122726701, -122.398383421945) 14 2 9 310 20
1040 94769 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
1045 17359 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2221X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005488.40666 2117587.01663 37.7948002909451 -122.424998441372 (37.7948002909451, -122.424998441372) 13 9 1 28858 27
1050 59568 Permitted Site 7 Koelreuteria bipinnata :: Chinese Flame Tree 164 636 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1981 12:00:00 AM     Permit Number 18958 6007406.54160631 2096049.3151302 37.7357709619243 -122.416834784421 (37.7357709619243, -122.416834784421) 2 7 7 28859 2
1052 65988 Permitted Site 7 Tree(s) :: 17 121 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1990 12:00:00 AM     Permit Number 29018 5995709.58889373 2096251.06183698 37.7356600432467 -122.457290053496 (37.7356600432467, -122.457290053496) 9 7 4 59 40
1055 35449 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1063 32734 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 808 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37117 5995081.95862964 2089664.82981262 37.7175397705127 -122.458983271916 (37.7175397705127, -122.458983271916) 9 8 6 28861 24
1064 44650 Permitted Site 7 Tree(s) :: 17   70 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1066 49147 Permitted Site 7 Tree(s) :: 17 201REVISED Elmira St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2003 12:00:00 AM     Permit Number 46271 6011255.32647148 2095465.44056571 37.7343834996245 -122.40348689328 (37.7343834996245, -122.40348689328) 10 3 8 58 1
1069 49087 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 692 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2003 12:00:00 AM     Permit Number 46237 6012085.19773634 2105185.1896517 37.7611181541392 -122.401300553818 (37.7611181541392, -122.401300553818) 10 3 8 28856 29
1076 260666 Permitted Site 7 Aesculus californica :: California Buckeye 168 2X Serrano Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6                      
1079 48011 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1921 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45734 5991237.8181057 2102332.85604348 37.7521012359965 -122.473193942643 (37.7521012359965, -122.473193942643) 1 8 4 29491 12
1081 52091 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 300 Dorantes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2005 12:00:00 AM     Permit Number 48287 5993176.51233561 2099718.04340733 37.7450336906204 -122.466299687476 (37.7450336906204, -122.466299687476) 1 8 4 29491 40
1091 44966 Permitted Site 7 Tree(s) :: 17   79 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1100 55205 Permitted Site 7 Tree(s) :: 17 44 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11118                    
1102 64618 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 355 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29568 6008648.33494852 2097105.55483154 37.7387409360622 -122.412616048547 (37.7387409360622, -122.412616048547) 10 7 7 28859 2
1110 79368 Permitted Site 7 Myoporum laetum :: Myoporum 62 54 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2008 12:00:00 AM   3x3 Permit Number 51121 6000325.93637272 2101364.83619438 37.7499653094156 -122.441696487801 (37.7499653094156, -122.441696487801) 2 4 5 28862 22
1112 8732 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3210 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1996 12:00:00 AM 6 3X3   5997102.31429 2113088.26659 37.7819706522719 -122.453690315182 (37.7819706522719, -122.453690315182) 11 6 1 54 31
1114 32669 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
1116 65831 Permitted Site 7 Tree(s) :: 17 2200 North Point 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1990 12:00:00 AM     Permit Number 28821                    
1118 36625 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
1125 101207 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 3 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
1129 44885 Permitted Site 7 Tree(s) :: 17   158 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1130 54772 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 1446 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/1972 12:00:00 AM   4x5 Permit Number 10621 5994307.43834186 2105670.05162948 37.7614415732371 -122.462820895269 (37.7614415732371, -122.462820895269) 1 5 11 56 12
1132 87818 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 85 Mendosa Ave 1 Median : Cutout Tree Private 2   06/04/2008 12:00:00 AM     Permit Number 50680 5993356 2100787 37.747979128324 -122.465756707117 (37.747979128324, -122.465756707117) 1 8 4 29491 40
1135 48105 Permitted Site 7 Tree(s) :: 17   215 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1136 57990 Permitted Site 7 Tree(s) :: 17 19 Bausch St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1977 12:00:00 AM     Permit Number 16955                    
1137 24844 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 200X Alemany Blvd 22 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/12/1996 12:00:00 AM 20 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
1143 29069 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1002X Laguna St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 15 3x3   6004818.3149515 2112301.2204093 37.7802489436872 -122.4269404119 (37.7802489436872, -122.4269404119) 7 9 11 28852 41
1148 33928 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1162 36561 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
1165 44567 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1168 39947 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 0 Ervine St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
1177 50666 Permitted Site 7 Celtis sinensis :: Chinese Hackberry 153 132 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2004 12:00:00 AM     Permit Number 47245 5997808.46990271 2107170.46182714 37.7657623457378 -122.450820527035 (37.7657623457378, -122.450820527035) 15 5 11 29492 9
1180 35696 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   6 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
1183 47616 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1209 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2002 12:00:00 AM     Permit Number 45446                    
1186 45889 Permitted Site 7 Tree(s) :: 17   18 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1191 34003 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 37940                    
1207 39056 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 2800X 18th St 20 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1998 12:00:00 AM     Permit Number 40772 6009422.123 2105494.394 37.7618182216771 -122.410532856099 (37.7618182216771, -122.410532856099) 8 4 7 28859 19
1208 54959 Permitted Site 7 Tree(s) :: 17 1571 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/1972 12:00:00 AM     Permit Number 10837 5982474.94240495 2104427.27217039 37.7573406377263 -122.503651864556 (37.7573406377263, -122.503651864556) 1 8 3 56 35
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
1214 44389 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 15 Cordova St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/2001 12:00:00 AM     Permit Number 43749 6001647.0719332 2087964.37014378 37.7132458927569 -122.436169094311 (37.7132458927569, -122.436169094311) 9 7 6 28861 5
1227 46197 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1228 65998 Permitted Site 7 Tree(s) :: 17 2551 Beacon St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1990 12:00:00 AM     Permit Number 29030                    
1237 35474 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38887 6007396.82109854 2112616.81920427 37.7812609627381 -122.418042529741 (37.7812609627381, -122.418042529741) 7 9 9 28852 36
1239 82960 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4774 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50809 5999900.41105831 2104653.85391663 37.7589718947663 -122.443404190452 (37.7589718947663, -122.443404190452) 2 4 5 28862 3
1244 27591 Permitted Site 7 Quercus suber :: Cork Oak 78 2100X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   06/21/2001 12:00:00 AM 3 3x3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
1247 214916 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 20 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1993 12:00:00 AM 13 Width 2ft Permit Number 32246 5993222.12997 2093186.27538 37.7271017173463 -122.465667493867 (37.7271017173463, -122.465667493867) 9 8 4 59 40
1255 66098 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1990 12:00:00 AM     Permit Number 29146                    

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