Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
| 9566 | 9566 | 95785 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | ||||||
| 11029 | 11029 | 67936 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 78 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31649 | |||||||
| 11717 | 11717 | 61760 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3739 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21774 | |||||||
| 12866 | 12866 | 108593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | |||||
| 15243 | 15243 | 109931 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | |||||
| 22409 | 22409 | 249318 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 174851 | 174851 | 40217 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 755 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 9 | Permit Number 41396 | 5980721.24963 | 2110609.89549 | 37.7742130596134 | -122.51017605378999 | (37.7742130596134, -122.51017605379) | |
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 82212 | 82212 | 31943 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1300 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767126 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | |
| 93638 | 93638 | 31942 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | ||
| 93917 | 93917 | 47887 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1396 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | Permit Number 45633 | 5980936.26532386 | 2105566.37783375 | 37.7603777089466 | -122.50905770342301 | (37.7603777089466, -122.509057703423) | ||
| 141830 | 141830 | 47888 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1396 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | Permit Number 45633 | 5980936.26532386 | 2105566.37783375 | 37.7603777089466 | -122.50905770342301 | (37.7603777089466, -122.509057703423) | ||
| 87412 | 87412 | 37133 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1496 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095356996 | -122.50896520854799 | (37.758434095357, -122.508965208548) | ||
| 102170 | 102170 | 37134 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1496 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095356996 | -122.50896520854799 | (37.758434095357, -122.508965208548) | ||
| 79872 | 79872 | 38359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
| 88039 | 88039 | 38357 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
| 94790 | 94790 | 38358 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
| 105666 | 105666 | 38355 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
| 106484 | 106484 | 38356 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1536 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40423 | 5980948.55127101 | 2104598.70694914 | 37.7577214867159 | -122.508943360628 | (37.7577214867159, -122.508943360628) | ||
| 70108 | 70108 | 94683 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1496 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53823 | 5980955.2273 | 2104911.2096 | 37.7585799229956 | -122.508943475923 | (37.7585799229956, -122.508943475923) |
| 94765 | 94765 | 38360 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1610 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41156 | 5980983.59087853 | 2104088.99570474 | 37.756324030904395 | -122.50878433832399 | (37.7563240309044, -122.508784338324) | ||
| 136540 | 136540 | 31944 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4739X Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767126 | 5980987.9788 | 2106187.281 | 37.7620855787641 | -122.508924957063 | (37.7620855787641, -122.508924957063) |
| 107182 | 107182 | 38361 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | Permit Number 40425 | 5980991.46797396 | 2103984.91123867 | 37.756038708992 | -122.5087493697 | (37.756038708992, -122.5087493697) | ||
| 89063 | 89063 | 38362 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1642 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2001 12:00:00 AM | Permit Number 40426 | 5980999.10411901 | 2103880.73539886 | 37.755753121966706 | -122.508715227831 | (37.7557531219667, -122.508715227831) | ||
| 184504 | 184504 | 38371 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4245 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2011 12:00:00 AM | 1 | Permit Number 46593 | 5981002.9588 | 2104145.6829 | 37.756480819381 | -122.50872156701999 | (37.756480819381, -122.50872156702) | |
| 28500 | 28500 | 47886 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4737 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 6 | Permit Number 45632 | 5981014.1249 | 2106186.9276 | 37.7620861496896 | -122.508834503155 | (37.7620861496896, -122.508834503155) | |
| 91954 | 91954 | 109278 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773630 | 5981021.8 | 2103979.8 | 37.756026462840296 | -122.508644093874 | (37.7560264628403, -122.508644093874) |
| 115428 | 115428 | 36089 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.754536221771204 | -122.508568229446 | (37.7545362217712, -122.508568229446) | ||
| 79922 | 79922 | 38363 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1730 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 44741 | 5981045.1604602 | 2103280.47601246 | 37.7541076952376 | -122.50851139458099 | (37.7541076952376, -122.508511394581) | ||
| 104871 | 104871 | 40219 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 165 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41398 | 5981062.91201163 | 2112924.76539407 | 37.780589154708295 | -122.50916613998699 | (37.7805891547083, -122.509166139987) | ||
| 45974 | 45974 | 34719 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 726 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 1 | Permit Number 3834 | 5981068.63905 | 2110748.84496 | 37.7746150589051 | -122.50898471253299 | (37.7746150589051, -122.508984712533) | |
| 140797 | 140797 | 37132 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4447 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39714 | 5981086.08651436 | 2104832.07084282 | 37.7583703439041 | -122.508485038953 | (37.7583703439041, -122.508485038953) | ||
| 63953 | 63953 | 38368 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4245 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1998 12:00:00 AM | 3 | Permit Number 40431 | 5981092.1865 | 2104150.2665 | 37.7564986636188 | -122.508413331792 | (37.7564986636188, -122.508413331792) | |
| 135660 | 135660 | 37119 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4731 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39709 | 5981101.19035238 | 2106191.54023256 | 37.762103946482505 | -122.508533725105 | (37.7621039464825, -122.508533725105) | |
| 48730 | 48730 | 38372 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4245 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 8 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
| 70656 | 70656 | 38369 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4245 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1998 12:00:00 AM | 5 | Permit Number 40431 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
| 160532 | 160532 | 38367 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
| 176806 | 176806 | 38370 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 4 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
| 65276 | 65276 | 37104 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1215 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39702 | 5981158.6347 | 2106766.3804 | 37.7636856772509 | -122.508377723134 | (37.7636856772509, -122.508377723134) | |
| 90264 | 90264 | 65145 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 512 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1991 12:00:00 AM | Permit Number 30097 | 5981171.08035557 | 2112695.84581661 | 37.779966986168496 | -122.50877493976002 | (37.7799669861685, -122.50877493976) | ||
| 105039 | 105039 | 69000 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1984 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32995 | 5981187.48777379 | 2101571.41580392 | 37.7494234868175 | -122.50789237554301 | (37.7494234868175, -122.507892375543) | ||
| 146190 | 146190 | 68288 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1994 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1993 12:00:00 AM | Permit Number 32097 | 5981192.89165036 | 2101506.41861494 | 37.74924534123971 | -122.507868866206 | (37.7492453412397, -122.507868866206) | ||
| 91538 | 91538 | 65140 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | Permit Number 27115 | 5981196.67226771 | 2112697.46270488 | 37.779972934138705 | -122.508686527544 | (37.7799729341387, -122.508686527544) | ||
| 79563 | 79563 | 109279 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
| 128537 | 128537 | 109280 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
| 142429 | 142429 | 109281 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
| 19133 | 19133 | 37103 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
| 19842 | 19842 | 37102 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
| 78788 | 78788 | 40218 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 139 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41397 | 5981206.29115693 | 2112930.16439571 | 37.7806124308083 | -122.50867053303499 | (37.7806124308083, -122.508670533035) | ||
| 175657 | 175657 | 37866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4635 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 7 | Permit Number 40226 | 5981211.71775 | 2110254.1908299997 | 37.773265317596895 | -122.50845305630301 | (37.7732653175969, -122.508453056303) | |
| 125104 | 125104 | 39835 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2034 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41157 | 5981216.95216217 | 2101218.11125367 | 37.7484551479521 | -122.507764274182 | (37.7484551479521, -122.507764274182) | ||
| 83651 | 83651 | 68577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 139 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32471 | 5981217.74443457 | 2111271.39856875 | 37.7760586259822 | -122.508507736704 | (37.7760586259822, -122.508507736704) | ||
| 92685 | 92685 | 37106 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | ||
| 139615 | 139615 | 37105 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | ||
| 129052 | 129052 | 39836 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2048 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41158 | 5981224.57274912 | 2101126.86261798 | 37.7482050538241 | -122.50773115252399 | (37.7482050538241, -122.507731152524) | ||
| 147938 | 147938 | 38351 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1525 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 2 | Permit Number 40418 | 5981225.53274519 | 2104685.47699717 | 37.7579760566052 | -122.50799190128001 | (37.7579760566052, -122.50799190128) | |
| 120745 | 120745 | 31940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1322 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767124 | 5981230.33279016 | 2106058.35423449 | 37.7617458665939 | -122.508077193589 | (37.7617458665939, -122.508077193589) | |
| 102504 | 102504 | 69023 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2090 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | Permit Number 33027 | 5981247.43450995 | 2100853.11671093 | 37.747454771320704 | -122.50763178888701 | (37.7474547713207, -122.507631788887) | ||
| 113767 | 113767 | 50438 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 472 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1989 12:00:00 AM | Permit Number 47089 | 5981256.38673996 | 2112701.23544484 | 37.779986812480395 | -122.50848023228201 | (37.7799868124804, -122.508480232282) | ||
| 103416 | 103416 | 34726 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 124 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38380 | 5981257.35364784 | 2111324.85465996 | 37.7762077350133 | -122.508374689338 | (37.7762077350133, -122.508374689338) | ||
| 163652 | 163652 | 38352 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1723 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 2 | Permit Number 40419 | 5981271.60203473 | 2103339.27473669 | 37.7542824830847 | -122.507732681289 | (37.7542824830847, -122.507732681289) | |
| 95188 | 95188 | 109277 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1787 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772804 | 5981271.8 | 2102925.3 | 37.7531458375643 | -122.50770127946801 | (37.7531458375643, -122.507701279468) |
| 185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | |
| 30374 | 30374 | 37136 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4641 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2000 12:00:00 AM | 7 | Permit Number 39718 | 5981284.3022 | 2106878.7818 | 37.764001704243796 | -122.507951428358 | (37.7640017042438, -122.507951428358) | |
| 181428 | 181428 | 34717 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 527 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 16 | Permit Number 38372 | 5981286.01571 | 2112124.00365 | 37.778403651193706 | -122.50833487486601 | (37.7784036511937, -122.508334874866) | |
| 119851 | 119851 | 34725 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | ||
| 180992 | 180992 | 67264 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 549 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 9 | Permit Number 30731 | 5981289.18602 | 2111977.44312 | 37.778001426165396 | -122.50831302603001 | (37.7780014261654, -122.50831302603) | |
| 171311 | 171311 | 67223 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | |
| 168384 | 168384 | 38354 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1875 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 0 | Permit Number 40422 | 5981305.52143941 | 2102319.66652747 | 37.751484926000295 | -122.50753973195499 | (37.7514849260003, -122.507539731955) | |
| 61035 | 61035 | 37135 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4625 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2000 12:00:00 AM | 4 | Permit Number 39717 | 5981309.3931 | 2106878.3636 | 37.7640020343296 | -122.507864616861 | (37.7640020343296, -122.507864616861) | |
| 157575 | 157575 | 68992 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1883 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 7 | Permit Number 32985 | 5981312.3634 | 2102264.6652 | 37.7513343109416 | -122.50751199144199 | (37.7513343109416, -122.507511991442) | |
| 58110 | 58110 | 96111 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 458 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767766 | 5981315.73412 | 2112558.6605700003 | 37.7795988416807 | -122.508264340954 | (37.7795988416807, -122.508264340954) |
| 152684 | 152684 | 68993 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1901 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 7 | Permit Number 32986 | 5981316.4245 | 2102095.1159 | 37.7508690156634 | -122.507485369114 | (37.7508690156634, -122.507485369114) | |
| 10752 | 10752 | 68995 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1911 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 10 | 3x3 | Permit Number 32988 | 5981319.4703 | 2102031.831 | 37.750695432604296 | -122.50747014161199 | (37.7506954326043, -122.507470141612) |
| 59984 | 59984 | 68996 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1917 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32989 | 5981319.4703 | 2101997.9888 | 37.750602511470206 | -122.50746763091101 | (37.7506025114702, -122.507467630911) | |
| 42269 | 42269 | 68998 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1921 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32991 | 5981319.8087 | 2101980.7293 | 37.7505551416857 | -122.50746518026399 | (37.7505551416857, -122.507465180264) | |
| 157661 | 157661 | 68994 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1907 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 9 | Permit Number 32987 | 5981319.8087 | 2102052.4747 | 37.750752134314105 | -122.50747050294399 | (37.7507521343141, -122.507470502944) | |
| 37789 | 37789 | 39833 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1925 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 7 | Permit Number 41154 | 5981320.4856 | 2101954.6708 | 37.7504836322681 | -122.507460906301 | (37.7504836322681, -122.507460906301) | |
| 110756 | 110756 | 68572 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 685 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32463 | 5981320.71250249 | 2111079.78815826 | 37.7755385883149 | -122.508137324272 | (37.7755385883149, -122.508137324272) | ||
| 65377 | 65377 | 68999 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1937 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 3 | Permit Number 32993 | 5981324.2082 | 2101884.9559 | 37.750292434094796 | -122.507442861533 | (37.7502924340948, -122.507442861533) | |
| 18560 | 18560 | 37810 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.753860479355396 | -122.50752362923201 | (37.7538604793554, -122.507523629232) | ||
| 145575 | 145575 | 47836 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 506 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | Permit Number 45598 | 5981328.87768988 | 2112285.52839896 | 37.778849676193296 | -122.508198593969 | (37.7788496761933, -122.508198593969) | ||
| 186509 | 186509 | 47837 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 548 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45599 | 5981333.02429 | 2111993.2264799997 | 37.7780473459501 | -122.50816254832701 | (37.7780473459501, -122.508162548327) | |
| 106879 | 106879 | 67263 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.778002010661105 | -122.508136768544 | (37.7780020106611, -122.508136768544) | ||
| 141727 | 141727 | 38353 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1800 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | Permit Number 40421 | 5981341.25756614 | 2102804.1865841 | 37.7528173861664 | -122.507452100184 | (37.7528173861664, -122.507452100184) | ||
| 26561 | 26561 | 79997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 6 | 5981344.9471 | 2112403.2124900003 | 37.7791737487824 | -122.50815174160499 | (37.7791737487824, -122.508151741605) | ||
| 168947 | 168947 | 79998 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.50813990451401 | (37.7791033052806, -122.508139904514) | ||
| 119576 | 119576 | 68317 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.50731153380801 | (37.7492103807501, -122.507311533808) | ||
| 67321 | 67321 | 79880 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1874 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5981353.9893 | 2102319.4895 | 37.751487294996295 | -122.507372114024 | (37.7514872949963, -122.507372114024) | ||
| 174525 | 174525 | 47838 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 636 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45600 | 5981355.1062900005 | 2111406.4182700003 | 37.7764374450216 | -122.508042597219 | (37.7764374450216, -122.508042597219) |
| 41236 | 41236 | 68990 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1878 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 9 | Permit Number 32983 | 5981356.0199 | 2102290.7237 | 37.751408431843295 | -122.50736295808301 | (37.7514084318433, -122.507362958083) | |
| 52961 | 52961 | 68991 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1882 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 2 | Permit Number 32984 | 5981356.0199 | 2102264.6652 | 37.7513368825607 | -122.507361024926 | (37.7513368825607, -122.507361024926) | |
| 143583 | 143583 | 34718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 626 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38373 | 5981358.16274912 | 2111480.6327423 | 37.7766413961782 | -122.508037533581 | (37.7766413961782, -122.508037533581) | ||
| 133518 | 133518 | 68285 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1894 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32094 | 5981358.7272 | 2102199.6882 | 37.7511586335316 | -122.50734684264 | (37.7511586335316, -122.50734684264) | |
| 104785 | 104785 | 109134 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 833 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773415 | 5981360.00156 | 2110051.11927 | 37.77271648064389 | -122.507925058041 | (37.7727164806439, -122.507925058041) |
| 106401 | 106401 | 39832 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1900 48th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");