Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9190 | 9190 | 2472 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2031X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1993 12:00:00 AM | 12 | 4X4 | 6003774.0905 | 2114890.3514 | 37.7872989488923 | -122.43073768033301 | (37.7872989488923, -122.430737680333) | ||
| 109592 | 109592 | 2713 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2168 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 769716 | 6003121.54577 | 2114856.3596900003 | 37.7871686246892 | -122.43299291599199 | (37.7871686246892, -122.432992915992) | ||
| 18727 | 18727 | 3939 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 999X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002271.23678 | 2107631.4399099997 | 37.7672825369934 | -122.43541777162201 | (37.7672825369934, -122.435417771622) | |||
| 88678 | 88678 | 5013 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 5313 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2 | 6001578.667721 | 2098979.6063858 | 37.7434873306528 | -122.437193725781 | (37.7434873306528, -122.437193725781) | |||
| 6978 | 6978 | 6035 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001552.687000001 | 2112546.4084 | 37.780736975678295 | -122.438255270265 | (37.7807369756783, -122.438255270265) | |||
| 91528 | 91528 | 12533 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 129 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 80 | 3X3 | 5995062.0 | 2114816.5 | 37.786598736379105 | -122.460874108141 | (37.7865987363791, -122.460874108141) | ||
| 19078 | 19078 | 16995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 900 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6002566.6368 | 2109915.0941 | 37.7735696608208 | -122.43455933158998 | (37.7735696608208, -122.43455933159) | ||
| 94657 | 94657 | 25957 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2695X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | 3 | 2x3 | 6011407.61362 | 2098218.7686799997 | 37.741952058974796 | -122.40315399409201 | (37.7419520589748, -122.403153994092) | ||
| 93616 | 93616 | 25960 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2301X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6011400.367219999 | 2098224.16578 | 37.741966473568795 | -122.40317942951 | (37.7419664735688, -122.40317942951) | ||
| 14583 | 14583 | 25961 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 2x3 | 6011423.37679 | 2098134.57194 | 37.7417217530491 | -122.403093568809 | (37.7417217530491, -122.403093568809) | ||
| 15432 | 15432 | 25962 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2X3 | 6011447.1772300005 | 2098118.06457 | 37.7416777564365 | -122.40301011353901 | (37.7416777564365, -122.403010113539) | ||
| 84871 | 84871 | 31201 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 257 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1969 12:00:00 AM | Permit Number 34892 | 5995623.87772067 | 2091687.20373025 | 37.723123866844894 | -122.457256336737 | (37.7231238668449, -122.457256336737) | |||
| 77652 | 77652 | 31202 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 276 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1969 12:00:00 AM | Permit Number 34894 | 5995678.83964111 | 2091843.96330625 | 37.7235574477937 | -122.45707767911101 | (37.7235574477937, -122.457077679111) | |||
| 87239 | 87239 | 31218 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2302 Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34907 | 6002345.06195587 | 2116106.2366551002 | 37.79055639288929 | -122.43576883650199 | (37.7905563928893, -122.435768836502) | ||||
| 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) | |
| 142341 | 142341 | 32011 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
| 91684 | 91684 | 32012 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
| 143090 | 143090 | 32410 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | |||
| 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) | ||
| 109409 | 109409 | 32427 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1901 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36954 | 6003387.68416895 | 2115217.90617727 | 37.7881764318356 | -122.432097963893 | (37.7881764318356, -122.432097963893) | |||
| 109051 | 109051 | 33491 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49655 | 6006996.29665496 | 2099574.0262700003 | 37.7454259501675 | -122.418503020578 | (37.7454259501675, -122.418503020578) | |||
| 128916 | 128916 | 33827 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 405 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37843 | 5999402.87583246 | 2094395.39820181 | 37.730776257944 | -122.44438766473101 | (37.730776257944, -122.444387664731) | |||
| 144574 | 144574 | 33894 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4152 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37868 | 6002903.75621342 | 2100679.60251963 | 37.74823035826571 | -122.43273331953199 | (37.7482303582657, -122.432733319532) | |||
| 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) | ||
| 103706 | 103706 | 34223 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4353 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | Permit Number 38036 | 6001597.05586573 | 2101140.27274833 | 37.7494210542971 | -122.43728482259199 | (37.7494210542971, -122.437284822592) | |||
| 74676 | 74676 | 34232 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 378 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | 6 | Permit Number 48201 | 5986869.968169999 | 2113396.40571 | 37.7822247950158 | -122.48911172009899 | (37.7822247950158, -122.489111720099) | ||
| 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) | ||
| 100877 | 100877 | 34518 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 129072 | 129072 | 34519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 174161 | 174161 | 34851 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2036 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Permit Number 38474 | 5987708.54863135 | 2103068.55697664 | 37.7539162921572 | -122.485452515625 | (37.7539162921572, -122.485452515625) | |||
| 160379 | 160379 | 35170 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 414 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 17 | Permit Number 38703 | 5984711.39216 | 2113056.75346 | 37.7811659806757 | -122.496554242469 | (37.7811659806757, -122.496554242469) | ||
| 31069 | 31069 | 35171 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 13 | Permit Number 38706 | 5983467.302999999 | 2113078.2669599997 | 37.7811520854856 | -122.500859695146 | (37.7811520854856, -122.500859695146) | ||
| 30347 | 30347 | 35172 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 12 | Permit Number 38706 | 5983466.53844 | 2113086.7632299997 | 37.7811753688678 | -122.50086296861099 | (37.7811753688678, -122.500862968611) | ||
| 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) | |
| 95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
| 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) | ||
| 104528 | 104528 | 39968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41229 | 5994642.74946915 | 2095844.31987513 | 37.7344818986137 | -122.460949031683 | (37.7344818986137, -122.460949031683) | |||
| 126881 | 126881 | 40087 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 708 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41310 | 6002385.65008555 | 2104050.52983918 | 37.7574567244894 | -122.434765933114 | (37.7574567244894, -122.434765933114) | |||
| 78233 | 78233 | 40342 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 170 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41473 | 5993510.486220299 | 2094049.6713278 | 37.7294890191855 | -122.464733328734 | (37.7294890191855, -122.464733328734) | |||
| 113184 | 113184 | 40561 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 25 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1999 12:00:00 AM | Permit Number 41605 | 6002662.09875993 | 2105750.86481793 | 37.7621411257649 | -122.43393140036699 | (37.7621411257649, -122.433931400367) | |||
| 127812 | 127812 | 40861 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41784 | 5994083.13181366 | 2093531.57356405 | 37.728099447432896 | -122.462716082104 | (37.7280994474329, -122.462716082104) | |||
| 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) | ||
| 125247 | 125247 | 41048 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 41828 | 5993076.0 | 2107259.0 | 37.7657334037891 | -122.46719542706002 | (37.7657334037891, -122.46719542706) | |
| 109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
| 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) | ||
| 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) | |
| 160490 | 160490 | 43880 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1828 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 9 | Permit Number 43493 | 6001514.0134 | 2112541.0633 | 37.7807200997255 | -122.43838867760799 | (37.7807200997255, -122.438388677608) | ||
| 119890 | 119890 | 43991 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43551 | 6009974.46243584 | 2107504.86062599 | 37.767369454596 | -122.408764367283 | (37.767369454596, -122.408764367283) | |||
| 53078 | 53078 | 43995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 6 | Permit Number 43551 | 6009986.76566 | 2107516.11876 | 37.767401055952604 | -122.408722606278 | (37.7674010559526, -122.408722606278) | ||
| 104451 | 104451 | 44044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 15 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2000 12:00:00 AM | 3x3 | Permit Number 52166 | 6007300.39530105 | 2099500.4637239 | 37.7452410789231 | -122.417446281159 | (37.7452410789231, -122.417446281159) | ||
| 70080 | 70080 | 44059 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 257 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43586 | 6006396.21431 | 2086366.5390599999 | 37.7091272643882 | -122.419641098064 | (37.7091272643882, -122.419641098064) | |
| 51833 | 51833 | 44251 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 43686 | 6000810.1983 | 2111352.5828 | 37.7774167767615 | -122.440738231786 | (37.7774167767615, -122.440738231786) | |||
| 90890 | 90890 | 44755 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | |||
| 140399 | 140399 | 44756 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | ||
| 77956 | 77956 | 45719 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 227 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | Permit Number 44389 | 5993425.80357844 | 2089157.89359185 | 37.7160525030782 | -122.464671006022 | (37.7160525030782, -122.464671006022) | |||
| 148976 | 148976 | 47819 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2 Seymour St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | 11 | Permit Number 45583 | 6001696.6687 | 2111985.4923 | 37.7792050300035 | -122.43771698483499 | (37.7792050300035, -122.437716984835) | ||
| 91357 | 91357 | 49091 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 113123 | 113123 | 49092 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 116320 | 116320 | 49878 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 511@ PAGE Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46644 | 5998896.54514998 | 2108984.87658964 | 37.77080649578671 | -122.44718771644301 | (37.7708064957867, -122.447187716443) | |||
| 157863 | 157863 | 50783 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 770 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2004 12:00:00 AM | 14 | Permit Number 47309 | 5980766.08534 | 2110461.55309 | 37.7738083996933 | -122.51000993912201 | (37.7738083996933, -122.510009939122) | ||
| 143850 | 143850 | 50968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2004 12:00:00 AM | 3x3 | Permit Number 778895 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231001 | (37.7544198816731, -122.43443350231) | ||
| 67490 | 67490 | 51036 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2614 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47511 | 5981836.5788 | 2097266.1752 | 37.7376407136614 | -122.50532878706001 | (37.7376407136614, -122.50532878706) | ||
| 158901 | 158901 | 51084 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1358 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 5 | Permit Number 47542 | 5981543.7588 | 2105841.1993 | 37.7611680849155 | -122.50697708881701 | (37.7611680849155, -122.506977088817) | ||
| 113608 | 113608 | 51648 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1430 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47932 | 5999618.72813404 | 2107626.34389142 | 37.7671175447299 | -122.444592021369 | (37.7671175447299, -122.444592021369) | |||
| 110464 | 110464 | 51814 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 266 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48060 | 5994901.32061156 | 2096492.00794019 | 37.736275166275796 | -122.460101979176 | (37.7362751662758, -122.460101979176) | |||
| 108792 | 108792 | 52088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 533 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48285 | 6003018.90245389 | 2105154.15611633 | 37.7605229492534 | -122.432654727925 | (37.7605229492534, -122.432654727925) | ||||
| 129331 | 129331 | 52144 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2695 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48326 | 5983357.46927228 | 2096816.23912163 | 37.7364946892524 | -122.500037175829 | (37.7364946892524, -122.500037175829) | ||||
| 110927 | 110927 | 52190 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 71 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48381 | 5999969.39262726 | 2104422.33072392 | 37.758340122613795 | -122.44314899255 | (37.7583401226138, -122.44314899255) | ||||
| 174982 | 174982 | 52214 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2001 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2005 12:00:00 AM | 17 | Permit Number 48397 | 6003318.2213 | 2118578.20562 | 37.797399014802 | -122.432578411388 | (37.797399014802, -122.432578411388) | ||
| 159091 | 159091 | 52591 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | 24 | Permit Number 48684 | 6005626.503190001 | 2117904.3459900003 | 37.7956793968408 | -122.424543191035 | (37.7956793968408, -122.424543191035) | ||
| 142181 | 142181 | 52735 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 90341 | 90341 | 52736 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 114027 | 114027 | 52737 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 108150 | 108150 | 52738 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 35388 | 35388 | 53227 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1419 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1969 12:00:00 AM | 13 | 3x3 | Permit Number 6110 | 6007265.78904 | 2117749.89162 | 37.795347743065 | -122.41885999550301 | (37.795347743065, -122.418859995503) | |
| 8885 | 8885 | 53229 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 6112 | 6007249.74611 | 2117746.2070299997 | 37.795336722764795 | -122.41891524533999 | (37.7953367227648, -122.41891524534) | |
| 133273 | 133273 | 53674 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1970 12:00:00 AM | 27 | 3x3 | Permit Number 6615 | 6000847.30796 | 2116375.23213 | 37.7912097941415 | -122.44097026868401 | (37.7912097941415, -122.440970268684) | |
| 124556 | 124556 | 53759 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 492x Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | Permit Number 9439 845-849 Diamond St | 6001965.94583867 | 2101505.01209507 | 37.750443505469605 | -122.43603528995001 | (37.7504435054696, -122.43603528995) | |||
| 136240 | 136240 | 53866 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1746 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 13 | Permit Number 9576 | 5983496.0301 | 2103256.2411 | 37.754185295753295 | -122.50003403412201 | (37.7541852957533, -122.500034034122) | ||
| 129286 | 129286 | 53959 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1661 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | Permit Number 9674 | 6004995.7689664 | 2119500.86037361 | 37.800027377944495 | -122.42683940106701 | (37.8000273779445, -122.426839401067) | |||
| 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) | |
| 116224 | 116224 | 53992 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | Permit Number 9709 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||
| 1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) | ||
| 1095 | 1095 | 54070 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.50780830550801 | (37.7556473215408, -122.507808305508) | ||
| 66758 | 66758 | 54071 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1650 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 17 | Permit Number 9794 | 5981301.6578 | 2103844.8448 | 37.7556724054432 | -122.50766625573 | (37.7556724054432, -122.50766625573) | ||
| 48536 | 48536 | 54077 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1416 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1972 12:00:00 AM | 12 | Permit Number 9800 | 5982488.8605 | 2105444.4291 | 37.7601342805878 | -122.503679056793 | (37.7601342805878, -122.503679056793) | ||
| 57725 | 57725 | 54294 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1950 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 24 | 3x3 | Permit Number 10048 | 6001969.7317 | 2115259.0901 | 37.78820901946921 | -122.437006779209 | (37.7882090194692, -122.437006779209) | |
| 60123 | 60123 | 54383 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 651 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 15 | Permit Number 10149 | 5981319.187940001 | 2111228.52141 | 37.7759468761842 | -122.508153639765 | (37.7759468761842, -122.508153639765) | ||
| 108027 | 108027 | 54458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4235 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1972 12:00:00 AM | Permit Number 10249 | 6001672.30868862 | 2101726.83398167 | 37.751035889282 | -122.437066586385 | (37.751035889282, -122.437066586385) | |||
| 83258 | 83258 | 54511 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 624 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | 3x3 | Permit Number 10305 | 5993855.83604665 | 2106680.47077674 | 37.7641898993307 | -122.464456154065 | (37.7641898993307, -122.464456154065) | ||
| 167704 | 167704 | 55221 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2301 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1972 12:00:00 AM | 12 | Permit Number 11139 | 5986369.9081 | 2099546.7997 | 37.744168417752206 | -122.489822796734 | (37.7441684177522, -122.489822796734) | ||
| 79226 | 79226 | 55388 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1377 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11325 | 5993310.46042535 | 2106120.10977525 | 37.762619842052494 | -122.466301708727 | (37.7626198420525, -122.466301708727) | ||
| 106817 | 106817 | 55765 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1932 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | Permit Number 11801 | 5989775.56943078 | 2106540.70455177 | 37.7635700889575 | -122.478558247096 | (37.7635700889575, -122.478558247096) | |||
| 121978 | 121978 | 55766 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 294 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2003 12:00:00 AM | Permit Number 46713 | 6002057.64133429 | 2104155.81527833 | 37.757727185230706 | -122.435907849922 | (37.7577271852307, -122.435907849922) | |||
| 147512 | 147512 | 55950 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3119 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1973 12:00:00 AM | 13 | Permit Number 12017 | 5983275.8316 | 2096739.2371 | 37.73627847101589 | -122.50031373613999 | (37.7362784710159, -122.50031373614) | ||
| 10231 | 10231 | 56289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 26 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1973 12:00:00 AM | 3 | 7x6 | Permit Number 12417 | 5998468.52120725 | 2106293.91375272 | 37.76339332794971 | -122.448474428781 | (37.7633933279497, -122.448474428781) | |
| 127271 | 127271 | 56508 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 583 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000090.55107769 | 2095627.82411946 | 37.73419942412529 | -122.442098700898 | (37.7341994241253, -122.442098700898) | ||||
| 140078 | 140078 | 56595 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 535 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 6003215.47967599 | 2096091.02007461 | 37.735648845754795 | -122.431327890197 | (37.7356488457548, -122.431327890197) |
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");