trees
39,840 rows where qLegalStatus_id = 7 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
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 | ||||||||||||||
1282 | 65048 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1994 12:00:00 AM | Permit Number 27001 | 6008641.92550277 | 2097033.56507471 | 37.7385429081789 | -122.412633121744 | (37.7385429081789, -122.412633121744) | 10 | 7 | 7 | 28859 | 2 | ||
1283 | 41795 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1201 08th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42196 | 6012618.34920617 | 2107219.96513791 | 37.7667349263458 | -122.39959946704 | (37.7667349263458, -122.39959946704) | 14 | 3 | 8 | 28856 | 20 | ||
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 | ||||||||||||||
1288 | 233082 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1418 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785211 | 6001974.22065 | 2099890.10044 | 37.746009810513 | -122.43589113876 | (37.746009810513, -122.43589113876) | 2 | 7 | 5 | 63 | 22 |
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 | ||||||||||||||
1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
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 | ||||
1370 | 49770 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | 9 | 7 | 8 | 309 | 39 | ||
1371 | 52082 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 138 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/2005 12:00:00 AM | Permit Number 48280 | 6004279.40612984 | 2097417.63926751 | 37.7393516795249 | -122.427743978882 | (37.7393516795249, -122.427743978882) | 2 | 7 | 5 | 63 | 7 | ||
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 | |||||||||||||
1389 | 35341 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 810 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38807 | 6013022.29386504 | 2103288.02203798 | 37.7559611845743 | -122.397926431796 | (37.7559611845743, -122.397926431796) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
1410 | 68319 | Permitted Site 7 | Heteromeles arbutifolia :: Toyon 186 | 100 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32134 | 5993677.209627 | 2114838.05789906 | 37.7865781513031 | -122.465666673248 | (37.7865781513031, -122.465666673248) | 11 | 6 | 2 | 54 | 11 | ||
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 | ||||||||||||||
1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
1430 | 67640 | Permitted Site 7 | Tree(s) :: 17 | 66 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1992 12:00:00 AM | Permit Number 31239 | 5999465.40351772 | 2088851.00886819 | 37.7155562089288 | -122.443773323232 | (37.7155562089288, -122.443773323232) | 9 | 7 | 6 | 28861 | 25 | |||
1431 | 60090 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1982 12:00:00 AM | Permit Number 19591 | ||||||||||||||
1435 | 68125 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.7444006509706 | -122.421806351312 | (37.7444006509706, -122.421806351312) | 2 | 7 | 5 | 28859 | 2 | ||
1446 | 44592 | Permitted Site 7 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
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 | ||||||||||||||
1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||||||||||||||
1501 | 27903 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015937.152 | 2112771.705 | 37.7821632154212 | -122.388507741674 | (37.7821632154212, -122.388507741674) | 6 | 2 | 9 | 28856 | 6 | |||
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 | ||
1546 | 86589 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2680 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 6 | 3x3 | 6009770 | 2101729 | 37.7514987921589 | -122.40906398531 | (37.7514987921589, -122.40906398531) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||||||||||||
1556 | 158441 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002069.34164 | 2096386.56921 | 37.7363953338756 | -122.435311658815 | (37.7363953338756, -122.435311658815) | 2 | 7 | 5 | 63 | 7 | |
1558 | 256904 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1571 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782743 | 5984651.59496 | 2104500.79365 | 37.7576702424259 | -122.496129679735 | (37.7576702424259, -122.496129679735) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
1561 | 24107 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
1571 | 56051 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.7684109649411 | -122.43229368198 | (37.7684109649411, -122.43229368198) | 15 | 5 | 5 | 28862 | 3 |
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) );