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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 35296 | 35296 | 75017 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Dorman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1997 12:00:00 AM | 14 | 6011095.51982 | 2097238.5902400003 | 37.7392432646533 | -122.40416415145201 | (37.7392432646533, -122.404164151452) | ||
| 36508 | 36508 | 31629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2667 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35146 | 5981804.4287 | 2096935.1986 | 37.736730050914296 | -122.505415418144 | (37.7367300509143, -122.505415418144) | |
| 48592 | 48592 | 63207 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3633 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23749 | 5984209.30853 | 2113126.2552799997 | 37.7813273844972 | -122.498296310267 | (37.7813273844972, -122.498296310267) | |
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 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) | |||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
| 75879 | 75879 | 35907 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2295 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 14 | Permit Number 39091 | 6011293.56173 | 2098002.1271 | 37.7413508375758 | -122.403533112479 | (37.7413508375758, -122.403533112479) | |
| 76036 | 76036 | 37096 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.759149087294794 | -122.506987547698 | (37.7591490872948, -122.506987547698) | |
| 78222 | 78222 | 38067 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1654X SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8x5 | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
| 92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 123095 | 123095 | 63455 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 746 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | Permit Number 28489 | 6007346.89818679 | 2095405.54054849 | 37.7339999430548 | -122.41699539620001 | (37.7339999430548, -122.4169953962) | ||
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 139715 | 139715 | 32413 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 153246 | 153246 | 69457 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 19 | 3x3 | Permit Number 33567 | 5985660.203509999 | 2112573.9841400003 | 37.7798959764685 | -122.493236296991 | (37.7798959764685, -122.493236296991) |
| 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) | ||
| 159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 168440 | 168440 | 75548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013526.462719999 | 2104188.60864 | 37.758462065501796 | -122.39624595358102 | (37.7584620655018, -122.396245953581) | ||
| 177905 | 177905 | 43789 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 121 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 10 | Permit Number 43419 | 5988953.60454 | 2114542.0898700003 | 37.7854919174236 | -122.481987309149 | (37.7854919174236, -122.481987309149) | |
| 121 | 121 | 59839 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.729767407645895 | -122.383685429115 | (37.7297674076459, -122.383685429115) | |
| 802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 5877 | 5877 | 84829 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999399.8288 | 2113638.7489 | 37.7836135792544 | -122.44578160080499 | (37.7836135792544, -122.445781600805) |
| 5969 | 5969 | 111118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5997454.0334 | 2109847.6499 | 37.7730929211041 | -122.45223963309401 | (37.7730929211041, -122.452239633094) | |||
| 6011 | 6011 | 66459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 12 | Permit Number 29609 | 5998393.1041 | 2113638.7682 | 37.7835561003446 | -122.449264468811 | (37.7835561003446, -122.449264468811) | |
| 6158 | 6158 | 111117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997427.9716 | 2109844.5838 | 37.7730830093731 | -122.452329562425 | (37.7730830093731, -122.452329562425) | |||
| 6596 | 6596 | 84828 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999419.5799 | 2113641.8213 | 37.783623142966 | -122.445713490833 | (37.783623142966, -122.445713490833) |
| 7455 | 7455 | 66458 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 12 | Permit Number 29608 | 5998357.739 | 2113627.431 | 37.783522948461396 | -122.449386000758 | (37.7835229484614, -122.449386000758) | |
| 7682 | 7682 | 84827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999436.2585 | 2113644.4547 | 37.7836313258411 | -122.445655978901 | (37.7836313258411, -122.445655978901) |
| 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 | |||||
| 9950 | 9950 | 68298 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2100 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3x3 | Permit Number 32107 | 5981719.63070527 | 2100774.89065863 | 37.747267790944 | -122.50599319492201 | (37.747267790944, -122.505993194922) | |
| 10465 | 10465 | 46403 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3725 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774152 | 5982443.3691 | 2102154.0013 | 37.7510970192105 | -122.50359271554501 | (37.7510970192105, -122.503592715545) | |
| 10657 | 10657 | 108540 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011963.42578 | 2086819.2708400001 | 37.710682407129795 | -122.400431631316 | (37.7106824071298, -122.400431631316) |
| 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) |
| 10910 | 10910 | 68310 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2186 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32121 | 5981735.8983 | 2100213.1522 | 37.7457263715271 | -122.505895303793 | (37.7457263715271, -122.505895303793) | |
| 11023 | 11023 | 60053 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1406 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/1982 12:00:00 AM | 24 | 3x3 | Permit Number 19552 | 5988377.0869 | 2105705.2719 | 37.7611949257495 | -122.483333852456 | (37.7611949257495, -122.483333852456) |
| 11587 | 11587 | 108539 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.7313299999 | 37.710752810563996 | -122.400402802668 | (37.710752810564, -122.400402802668) |
| 11636 | 11636 | 92966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2186 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5981735.5599 | 2100228.0428 | 37.7457672370442 | -122.505897577684 | (37.7457672370442, -122.505897577684) | |||
| 11809 | 11809 | 108541 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011955.27785 | 2086793.07341 | 37.710610019802296 | -122.40045795358999 | (37.7106100198023, -122.40045795359) |
| 12382 | 12382 | 39827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2194 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | 6 | Permit Number 44096. | 5981736.2368 | 2100175.5874 | 37.7456232489839 | -122.50589134882799 | (37.7456232489839, -122.505891348828) | |
| 12653 | 12653 | 83310 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1478 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2012 12:00:00 AM | 5 | 3x3 | Permit Number 54428 | 5982811.5616 | 2105064.3321 | 37.7591096099493 | -122.502534872577 | (37.7591096099493, -122.502534872577) |
| 12975 | 12975 | 65624 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 234 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 11 | 3x4 | Permit Number 28532 | 6004932.148580001 | 2094045.1422299999 | 37.7301284612426 | -122.425247165046 | (37.7301284612426, -122.425247165046) |
| 13328 | 13328 | 63694 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1862 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 24352 | 5993137.0 | 2102888.0 | 37.753735299933 | -122.46666669057501 | (37.753735299933, -122.466666690575) | ||
| 14339 | 14339 | 59853 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1167 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 19309 | 6017186.1327 | 2093497.6426 | 37.7293098027153 | -122.382845061392 | (37.7293098027153, -122.382845061392) |
| 15279 | 15279 | 59852 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.728873523519894 | -122.382086980049 | (37.7288735235199, -122.382086980049) |
| 16553 | 16553 | 60401 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1537 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 20 | 4x4 | Permit Number 19982 | 6015576.0436 | 2094341.8469999998 | 37.731538729377796 | -122.388470234454 | (37.7315387293778, -122.388470234454) |
| 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) | ||
| 18916 | 18916 | 65141 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | Permit Number 27116 | 5981364.99930459 | 2112708.09753982 | 37.780012054358394 | -122.508105008848 | (37.7800120543584, -122.508105008848) | ||
| 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) | ||
| 19272 | 19272 | 65062 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | ||
| 19555 | 19555 | 63127 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23641 | 6007142.25261762 | 2099206.716095 | 37.7444256145798 | -122.417972293386 | (37.7444256145798, -122.417972293386) | ||
| 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) | ||
| 23471 | 23471 | 47859 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1399 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 5 | Permit Number 45616 | 5982746.5554 | 2105696.4247 | 37.7608413368995 | -122.50280648168899 | (37.7608413368995, -122.502806481689) | |
| 23739 | 23739 | 62090 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1527 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 9 | Permit Number 31146 | 6013382.10776 | 2104727.08591 | 37.75993257304379 | -122.396782951399 | (37.7599325730438, -122.396782951399) | |
| 23918 | 23918 | 38491 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1055 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 7 | Permit Number 40486 | 6007969.19712 | 2118884.80635 | 37.7985035180865 | -122.416506512892 | (37.7985035180865, -122.416506512892) | |
| 23935 | 23935 | 31454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 625 Douglass St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35026 | 6001228.91963 | 2102742.34175 | 37.7537990168301 | -122.43867262494601 | (37.7537990168301, -122.438672624946) | |
| 23995 | 23995 | 68972 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3444 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 10 | Permit Number 32962 | 5999781.0936 | 2120437.57627 | 37.8023031276514 | -122.444951481035 | (37.8023031276514, -122.444951481035) | |
| 24018 | 24018 | 31934 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1286 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 0 | Permit Number 35350 | 5981530.42710663 | 2106331.73149581 | 37.762514160345205 | -122.50705958621 | (37.7625141603452, -122.50705958621) | |
| 24038 | 24038 | 37228 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1827 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39792 | 5985640.6866 | 2102775.6534 | 37.75299136712471 | -122.49258199603999 | (37.7529913671247, -122.49258199604) | |
| 24052 | 24052 | 68291 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2026 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 9 | Permit Number 32996 | 5981388.6776 | 2101267.3361 | 37.748600421328 | -122.50717411267401 | (37.748600421328, -122.507174112674) | |
| 24252 | 24252 | 69018 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2035 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 10 | Permit Number 33022 | 5981651.8006 | 2101224.6231 | 37.748498637333896 | -122.50626108566799 | (37.7484986373339, -122.506261085668) | |
| 24351 | 24351 | 92407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2211 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52805 | 5985400.9 | 2100141.4 | 37.7457444022459 | -122.493217161932 | (37.7457444022459, -122.493217161932) |
| 24352 | 24352 | 68538 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 790 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 12 | Permit Number 32420 | 5993840.78744 | 2110199.31187 | 37.7738508399811 | -122.464763753871 | (37.7738508399811, -122.464763753871) | |
| 24586 | 24586 | 61569 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 958 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 12 | Permit Number 21529 | 6012748.7696 | 2103051.87566 | 37.7552975409755 | -122.398855802363 | (37.7552975409755, -122.398855802363) | |
| 24705 | 24705 | 74639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 3 | 6007029.8225 | 2113512.7316900003 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | ||
| 24817 | 24817 | 70493 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6005304.47442 | 2091965.6716099998 | 37.7244397195916 | -122.42381218159599 | (37.7244397195916, -122.423812181596) | ||
| 25025 | 25025 | 65744 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 184 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 11 | Permit Number 28703 | 6000756.34177 | 2087488.39058 | 37.711888311673796 | -122.43921366159901 | (37.7118883116738, -122.439213661599) | |
| 25108 | 25108 | 47852 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1430 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 4 | Permit Number 45611 | 5983111.9868 | 2105384.8257 | 37.760007243783704 | -122.501519585216 | (37.7600072437837, -122.501519585216) | |
| 25280 | 25280 | 60068 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2309 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 11 | Permit Number 19568 | 5988521.12 | 2107125.5346 | 37.7651029613737 | -122.482939804052 | (37.7651029613737, -122.482939804052) | |
| 25326 | 25326 | 63559 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3655 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | Permit Number 24181 | 5982862.532000001 | 2104209.7007 | 37.7567660283709 | -122.502295347911 | (37.7567660283709, -122.502295347911) | |
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 25545 | 25545 | 71820 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 11 | 5988034.0091 | 2106701.9931 | 37.763911677097894 | -122.484593510615 | (37.7639116770979, -122.484593510615) | ||
| 25606 | 25606 | 68961 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2139 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32950 | 5988833.65861 | 2111208.64898 | 37.7763322483358 | -122.48215798183901 | (37.7763322483358, -122.482157981839) | |
| 26003 | 26003 | 70424 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982456.3495 | 2105108.4827 | 37.759209955641104 | -122.50376661440501 | (37.7592099556411, -122.503766614405) | ||
| 26181 | 26181 | 74488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.50035771523599 | (37.7433893618735, -122.500357715236) | ||
| 26350 | 26350 | 43056 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2183 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981689.1961 | 2100235.8265 | 37.745785879800295 | -122.506058471243 | (37.7457858798003, -122.506058471243) | |
| 26367 | 26367 | 60088 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1278 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 15 | Permit Number 19589 | 5988967.2555 | 2106649.5291 | 37.76382192904121 | -122.481361886812 | (37.7638219290412, -122.481361886812) | |
| 26652 | 26652 | 48000 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1901 16th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45728 | 5991233.33873947 | 2102463.46573508 | 37.752459596695 | -122.47321895744 | (37.752459596695, -122.47321895744) | ||
| 26716 | 26716 | 65106 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 33 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 13 | Permit Number 27073 | 5989250.782430001 | 2114950.87727 | 37.7866316111123 | -122.480989114681 | (37.7866316111123, -122.480989114681) | |
| 27186 | 27186 | 34359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1827 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38115 | 6004598.72588548 | 2098167.19179023 | 37.7414278382274 | -122.426693274937 | (37.7414278382274, -122.426693274937) | ||
| 27709 | 27709 | 38137 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 13 | Permit Number 40297 | 6009992.36409 | 2093106.3292 | 37.7278352547766 | -122.40768710170201 | (37.7278352547766, -122.407687101702) | |
| 27747 | 27747 | 67429 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1629 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 11 | Permit Number 30931 | 5990524.00684 | 2110590.93063 | 37.7747343354864 | -122.476265527652 | (37.7747343354864, -122.476265527652) | |
| 27754 | 27754 | 41626 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2285 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 7 | Permit Number 46000 | 6011671.24586 | 2099696.5444400003 | 37.7460244334925 | -122.40234631495701 | (37.7460244334925, -122.402346314957) | |
| 27833 | 27833 | 83796 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1518 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767121 | 5981891.7052 | 2104730.2332 | 37.7581381740928 | -122.50569135221599 | (37.7581381740928, -122.505691352216) |
| 28438 | 28438 | 65621 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 178 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 11 | Permit Number 28528 | 6004548.78205 | 2094027.5188799999 | 37.7300584058739 | -122.42657125845301 | (37.7300584058739, -122.426571258453) | |
| 28452 | 28452 | 32184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924841998 | (37.7295164954065, -122.49686924842) | ||
| 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) | |
| 28521 | 28521 | 65185 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 247 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 9 | Permit Number 27169 | 6003009.6432300005 | 2091977.0708700002 | 37.724341203376795 | -122.43174590807 | (37.7243412033768, -122.43174590807) | |
| 28684 | 28684 | 63997 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2313 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 14 | Permit Number 24744 | 6008014.08698 | 2120392.95206 | 37.802647032905 | -122.416458063683 | (37.802647032905, -122.416458063683) | |
| 29066 | 29066 | 38668 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 917 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 9 | Permit Number 40587 | 6000931.2676 | 2111861.7153 | 37.778821619424896 | -122.44035593667 | (37.7788216194249, -122.44035593667) | |
| 29140 | 29140 | 47853 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1311 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 4 | Permit Number 45612 | 5982730.9779 | 2106164.1066 | 37.7621245429238 | -122.50289497879 | (37.7621245429238, -122.50289497879) | |
| 29265 | 29265 | 63614 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2087 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | 10 | Permit Number 27029 | 5999637.0129 | 2111535.8519 | 37.7778531056478 | -122.44480982844802 | (37.7778531056478, -122.444809828448) |
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");