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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 101700 | 101700 | 86749 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 115297 | 115297 | 86750 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 141356 | 141356 | 86901 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 370 Santa Ana Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49847 | 5992482.1 | 2094336.7 | 37.73021778542579 | -122.468309402689 | (37.7302177854258, -122.468309402689) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 92960 | 92960 | 105730 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1245 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 771762 | 5992955.9 | 2106987.0 | 37.7649796301557 | -122.467591041048 | (37.7649796301557, -122.467591041048) | ||
| 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) | |||
| 96471 | 96471 | 56770 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 249 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 777118 | 6000646.04543173 | 2102139.76865728 | 37.752111320918495 | -122.440645114373 | (37.7521113209185, -122.440645114373) | |||
| 97056 | 97056 | 89006 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2200 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51758 | 6003287.9 | 2116231.2 | 37.7909530209385 | -122.432515604779 | (37.7909530209385, -122.432515604779) | |||
| 98265 | 98265 | 95649 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 99570 | 99570 | 56660 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5x5 | 6001647.0 | 2102006.0 | 37.7518009738438 | -122.437174092108 | (37.7518009738438, -122.437174092108) | |||
| 102722 | 102722 | 95195 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | Permit Number 767109 | 5986864.6 | 2114238.7 | 37.7845371806063 | -122.489192237355 | (37.7845371806063, -122.489192237355) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 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) | |||
| 107126 | 107126 | 85498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 110601 | 110601 | 61062 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1983 12:00:00 AM | 15 | 3x3 | Permit Number 20894 | 6003791.73087977 | 2114891.68292751 | 37.7873036043324 | -122.430676743416 | (37.7873036043324, -122.430676743416) | |
| 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) | ||||
| 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) | |||
| 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) | |||
| 113873 | 113873 | 61358 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1029 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1984 12:00:00 AM | Permit Number 21266 | 6001344.49519126 | 2100781.43952904 | 37.7484214231354 | -122.438132480542 | (37.7484214231354, -122.438132480542) | |||
| 114587 | 114587 | 100397 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 204 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2014 12:00:00 AM | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.46527922129101 | (37.7585961040831, -122.465279221291) | |
| 115892 | 115892 | 95277 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 554 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 12:00:00 AM | 3 | 5x7 | Permit Number 777230 | 5994096.260869999 | 2111723.67308 | 37.778051054367204 | -122.463990712248 | (37.7780510543672, -122.463990712248) | |
| 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) | |||
| 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) | |||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 120345 | 120345 | 95655 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 120647 | 120647 | 87298 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 32 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50311 | 5999892.3 | 2095538.5 | 37.7339428609205 | -122.44277770379699 | (37.7339428609205, -122.442777703797) |
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");