Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89317 | 89317 | 85483 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 123690 | 123690 | 85484 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 125466 | 125466 | 110020 | Myoporum laetum :: Myoporum 1 | 1490X Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9x9 | 6001386.81709 | 2099547.0285 | 37.745034430207795 | -122.437897729467 | (37.7450344302078, -122.437897729467) | |||||
| 1 | 1 | 141565 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | 21 | Width 0ft | Permit Number 25401 | 6000609.0 | 2110829.0 | 37.7759676911831 | -122.441396661871 | (37.7759676911831, -122.441396661871) | |
| 6 | 6 | 141566 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000587.8822 | 2110733.5952 | 37.7757045307049 | -122.441462866076 | (37.7757045307049, -122.441462866076) | |||
| 1011 | 1011 | 232310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 26 | Width 3ft | Permit Number 17854 | 5997696.0 | 2107004.0 | 37.7652988449505 | -122.451197528579 | (37.7652988449505, -122.451197528579) | |
| 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) | ||
| 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) | ||
| 1465 | 1465 | 210473 | 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 | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.5743400003 | 37.765803096458995 | -122.46722890580901 | (37.765803096459, -122.467228905809) | |
| 1992 | 1992 | 232379 | 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 | 16 | Width 3ft | Permit Number 10249 | 6001645.52772 | 2101734.6442400003 | 37.751055812089 | -122.43715975664499 | (37.751055812089, -122.437159756645) | |
| 4023 | 4023 | 232380 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6001617.91184 | 2102022.2796 | 37.7518440201921 | -122.437275848296 | (37.7518440201921, -122.437275848296) | |||
| 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) | |||
| 7105 | 7105 | 61394 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2584 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1984 12:00:00 AM | 15 | 3x3 | Permit Number 21315 | 5999837.8956 | 2113700.6918 | 37.7838086607697 | -122.44427051519399 | (37.7838086607697, -122.444270515194) | |
| 7131 | 7131 | 116025 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1425 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 3x3 | 6006694.6941 | 2118351.37216 | 37.796967084814 | -122.42087880533501 | (37.796967084814, -122.420878805335) | ||
| 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) | |
| 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) | ||
| 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) | |
| 10229 | 10229 | 173709 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 26 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2017 12:00:00 AM | 3 | 7x6 | 5998468.52120725 | 2106293.91375272 | 37.76339332794971 | -122.448474428781 | (37.7633933279497, -122.448474428781) | ||
| 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) | |
| 10678 | 10678 | 116741 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1631 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779477 | 5983734.6502 | 2104037.3849 | 37.7563440999856 | -122.499266557723 | (37.7563440999856, -122.499266557723) | |
| 11098 | 11098 | 64696 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1055 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25639 | 5989879.8498 | 2099000.4177 | 37.742872512219 | -122.47764638889299 | (37.742872512219, -122.477646388893) | |
| 11179 | 11179 | 97318 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1026 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5989977.5691 | 2099069.2019 | 37.7430670461122 | -122.477313532312 | (37.7430670461122, -122.477313532312) | |||
| 11464 | 11464 | 97310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 916 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5990323.69 | 2099081.1313 | 37.7431198777207 | -122.476117623457 | (37.7431198777207, -122.476117623457) | |||
| 11465 | 11465 | 107858 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2908 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778432 | 5981789.5382 | 2096536.8762 | 37.735635490547 | -122.505437384685 | (37.735635490547, -122.505437384685) | |
| 11593 | 11593 | 116739 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1678 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778366 | 5983788.3957 | 2103743.2164 | 37.755539548337204 | -122.49905895584999 | (37.7555395483372, -122.49905895585) | |||
| 12286 | 12286 | 97316 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1000 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5990092.4633 | 2099074.5321 | 37.7430883471851 | -122.47691665284201 | (37.7430883471851, -122.476916652842) | |||
| 12647 | 12647 | 115149 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2430 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | Permit Number 777450 | 5987687.2149 | 2098724.2655 | 37.7419867848349 | -122.48520755477199 | (37.7419867848349, -122.485207554772) | ||
| 12762 | 12762 | 116742 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1638 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x3 | Permit Number 778698 | 5983780.8141 | 2103988.0199 | 37.756211265636296 | -122.499103262084 | (37.7562112656363, -122.499103262084) | |
| 13181 | 13181 | 117441 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1204 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778732 | 5989885.5669 | 2107139.7037 | 37.765221164359495 | -122.47822160390498 | (37.7652211643595, -122.478221603905) | |
| 13254 | 13254 | 115458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 476 FAIR OAKS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005502.0 | 2100939.0 | 37.7490896185955 | -122.423767101444 | (37.7490896185955, -122.423767101444) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 25830 | 25830 | 61870 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3657 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1985 12:00:00 AM | 18 | Permit Number 21910 | 5997325.23307 | 2115369.87037 | 37.7882481090091 | -122.453083875833 | (37.7882481090091, -122.453083875833) | ||
| 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) | ||
| 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) | ||
| 33334 | 33334 | 66658 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1601 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1991 12:00:00 AM | 11 | Permit Number 29873 | 5989617.5654 | 2104410.2875 | 37.7577113621685 | -122.478948892591 | (37.7577113621685, -122.478948892591) | ||
| 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) | |
| 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) | |
| 42986 | 42986 | 113272 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||||
| 44329 | 44329 | 97086 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5981457.56361 | 2110998.49669 | 37.7753234489943 | -122.50765789816201 | (37.7753234489943, -122.507657898162) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 51930 | 51930 | 97088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x4.5 | 5981440.73275 | 2110998.41096 | 37.7753222220509 | -122.507716112605 | (37.7753222220509, -122.507716112605) | |||
| 52722 | 52722 | 58056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1957 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 5 | Permit Number 17025 | 6002479.0246 | 2119847.84274 | 37.8008374809215 | -122.435573122311 | (37.8008374809215, -122.435573122311) | ||
| 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) | ||
| 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) | ||
| 61688 | 61688 | 57206 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2202 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1975 12:00:00 AM | Permit Number 774014 | 6000908.32678769 | 2115906.78943665 | 37.7899270475037 | -122.44072552972 | (37.7899270475037, -122.44072552972) | |||
| 65099 | 65099 | 62101 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4224 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1985 12:00:00 AM | 4 | Permit Number 22194 | 5981140.9456 | 2104205.2821 | 37.756652594222004 | -122.508248791959 | (37.756652594222, -122.508248791959) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 71595 | 71595 | 57562 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1717 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 20 | Permit Number 16429 | 6000855.1553 | 2111361.653 | 37.777444241367 | -122.440583361864 | (37.777444241367, -122.440583361864) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 77901 | 77901 | 95656 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 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) | |||
| 78090 | 78090 | 113273 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||||
| 78094 | 78094 | 98145 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2495 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x7 | Permit Number 768497 | 5987947.1 | 2098339.7 | 37.7409460050834 | -122.484280768936 | (37.7409460050834, -122.484280768936) | |||
| 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) | |
| 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) | |||
| 78349 | 78349 | 97118 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1151 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2014 12:00:00 AM | 15 | 3x3 | Permit Number 770734 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | |
| 78519 | 78519 | 94912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1506 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999677.4 | 2107342.3 | 37.7663409791409 | -122.44436866988998 | (37.7663409791409, -122.44436866989) | |||||
| 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) | ||
| 79255 | 79255 | 57585 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 297 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | Permit Number 16453 | 6013500.41645948 | 2105713.4077908 | 37.762647381026504 | -122.39644291208 | (37.7626473810265, -122.39644291208) | ||
| 79648 | 79648 | 94502 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 60 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53693 | 5994613.0 | 2095460.0 | 37.733424938715 | -122.461024038199 | (37.733424938715, -122.461024038199) | ||||
| 80679 | 80679 | 94196 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 355 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | |||||
| 81854 | 81854 | 64519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | Permit Number 25401 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||
| 82848 | 82848 | 93128 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1711 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000564.0 | 2114506.0 | 37.7860612284376 | -122.44181628911899 | (37.7860612284376, -122.441816289119) | |||
| 83109 | 83109 | 66626 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 496 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2009 12:00:00 AM | Permit Number 52007 | 6003158.91614039 | 2102739.58919536 | 37.7539010640869 | -122.43199806254499 | (37.7539010640869, -122.431998062545) | |||
| 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) | ||
| 84788 | 84788 | 103369 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1528 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770212 | 6003912.8 | 2099364.9 | 37.744677665265606 | -122.429150348387 | (37.7446776652656, -122.429150348387) | |||
| 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) | |||
| 85073 | 85073 | 105050 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2835 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771766 | 6002056.0 | 2117852.0 | 37.7953333833033 | -122.436894002104 | (37.7953333833033, -122.436894002104) | |||
| 85087 | 85087 | 111629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 200 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | |||
| 86113 | 86113 | 95657 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 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) | ||||
| 87499 | 87499 | 95651 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 87521 | 87521 | 58634 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 3 | 4x4 | Permit Number 17854 | 5997674.48741574 | 2107055.11858465 | 37.765437971850794 | -122.45127562216999 | (37.7654379718508, -122.45127562217) | |
| 88103 | 88103 | 100398 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 204 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.46527922129101 | (37.7585961040831, -122.465279221291) | ||
| 88289 | 88289 | 61437 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 788 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | Permit Number 778418 | 5993530.07441 | 2110197.53457 | 37.7738280413865 | -122.46583842282101 | (37.7738280413865, -122.465838422821) | ||
| 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) | |||
| 89855 | 89855 | 95653 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 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) | |||
| 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) | |||
| 91286 | 91286 | 94498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1600X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 7x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 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) | ||||
| 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) | ||
| 91621 | 91621 | 110056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 Jamestown Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016119.9 | 2086810.2 | 37.7108884169699 | -122.38606516043899 | (37.7108884169699, -122.386065160439) | |||||
| 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) | ||||
| 91775 | 91775 | 95650 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 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) | ||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 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) |
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");