trees
39,840 rows where qLegalStatus_id = 7 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||||||||||||||
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 | ||
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 | |||
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 | |||||||||||||
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 | ||||||||||||
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 | |||||||||||||
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 | ||
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 | |||||||||||||||
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 | ||
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 | ||||||||||||||
1257 | 260668 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
1259 | 34123 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37981 | ||||||||||||||
1261 | 45997 | Permitted Site 7 | Tree(s) :: 17 | 115 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1265 | 120363 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6118 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5988496.49362 | 2114018.15896 | 37.7840267560995 | -122.483530334528 | (37.7840267560995, -122.483530334528) | 11 | 6 | 2 | 55 | 26 | |||
1275 | 46058 | Permitted Site 7 | Tree(s) :: 17 | 188 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
1287 | 48142 | Permitted Site 7 | Tree(s) :: 17 | 252 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1303 | 35175 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
1314 | 67685 | Permitted Site 7 | Tree(s) :: 17 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | Permit Number 31289 | 5997024.37469935 | 2095029.17182905 | 37.7323804536882 | -122.452656198743 | (37.7323804536882, -122.452656198743) | 9 | 7 | 4 | 59 | 40 | |||
1321 | 48199 | Permitted Site 7 | Tree(s) :: 17 | 58 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1326 | 43484 | Permitted Site 7 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43169 | ||||||||||||||
1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
1335 | 31615 | Permitted Site 7 | Gleditsia triacanthos :: Honey Locust 182 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | Permit Number 35136 | 6005596.48777411 | 2104595.39586612 | 37.7591345667337 | -122.423700300709 | (37.7591345667337, -122.423700300709) | 2 | 4 | 5 | 28859 | 19 | |||
1340 | 87020 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49949 | |||||||||||||
1346 | 260123 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3195X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
1347 | 109892 | Permitted Site 7 | Tree(s) :: 17 | 205 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2015 12:00:00 AM | 3 | 3x6 | 5995308.1 | 2091295.6 | 37.7220304751495 | -122.458319579925 | (37.7220304751495, -122.458319579925) | 9 | 8 | 4 | 28861 | 24 | ||
1356 | 44935 | Permitted Site 7 | Tree(s) :: 17 | 168 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1357 | 54090 | Permitted Site 7 | Tree(s) :: 17 | 115 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9817 | 5991911.06498332 | 2095358.19732765 | 37.7329895631391 | -122.47035789011 | (37.7329895631391, -122.47035789011) | 9 | 8 | 4 | 59 | 40 | |||
1358 | 109891 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013218 | 2106201 | 37.7639704813344 | -122.397453893083 | (37.7639704813344, -122.397453893083) | 14 | 3 | 8 | 28856 | 29 | ||||
1372 | 48323 | Permitted Site 7 | Tree(s) :: 17 | 189 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1381 | 84767 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 13 | 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 | |||
1382 | 4111 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3385X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1995 12:00:00 AM | 3 | 3x3 | 6007239.656 | 2100524.9644 | 37.7480507095515 | -122.417728911573 | (37.7480507095515, -122.417728911573) | 2 | 4 | 7 | 28859 | 2 | ||
1386 | 67784 | Permitted Site 7 | Tree(s) :: 17 | 1030 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | Permit Number 31421 | |||||||||||||
1390 | 33763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
1392 | 48291 | Permitted Site 7 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1395 | 33932 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1997 12:00:00 AM | Permit Number 37893 | ||||||||||||||
1397 | 44933 | Permitted Site 7 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1402 | 128081 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009658.72737 | 2121889.09987 | 37.8068474325394 | -122.410872486877 | (37.8068474325394, -122.410872486877) | 3 | 1 | 10 | 308 | 23 | |||
1405 | 96265 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2776 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.427343605274 | (37.798850712467, -122.427343605274) | 13 | 9 | 1 | 57 | 17 | |||
1411 | 44977 | Permitted Site 7 | Tree(s) :: 17 | 49 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1413 | 48094 | Permitted Site 7 | Tree(s) :: 17 | 218 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 |
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) );