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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 9942 | 9942 | 34361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.42684644404301 | (37.7411467825752, -122.426846444043) | |
| 9949 | 9949 | 63390 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.734132412410396 | -122.416802921773 | (37.7341324124104, -122.416802921773) | |
| 10403 | 10403 | 95015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010521.9467 | 2087254.8816 | 37.711798014587295 | -122.40544438972 | (37.7117980145873, -122.40544438972) | ||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 11927 | 11927 | 52333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.40440027981701 | (37.7115198939825, -122.404400279817) | ||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 12738 | 12738 | 95005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201X Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009777.312000001 | 2087590.4351 | 37.71267771272821 | -122.40804171326799 | (37.7126777127282, -122.408041713268) | ||||
| 14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 18075 | 18075 | 32820 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.43717647687599 | (37.7526444703409, -122.437176476876) | ||
| 18082 | 18082 | 62490 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | ||
| 18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 18485 | 18485 | 36424 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
| 18614 | 18614 | 63155 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23691 | 5992764.22387578 | 2105486.82086268 | 37.7608494648287 | -122.468144857754 | (37.7608494648287, -122.468144857754) | ||
| 18841 | 18841 | 64930 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2306 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25958 | 5991495.59202308 | 2099725.9184431 | 37.7449581828883 | -122.47211252761002 | (37.7449581828883, -122.47211252761) | ||
| 18883 | 18883 | 65715 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.789128153830106 | -122.41204221421499 | (37.7891281538301, -122.412042214215) | ||
| 19124 | 19124 | 59121 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 572 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2013 12:00:00 AM | Permit Number 770918 | 5992864.66737091 | 2111571.53492594 | 37.7775622694604 | -122.46824012776001 | (37.7775622694604, -122.46824012776) | |||
| 19155 | 19155 | 52324 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4119NOE ST. 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48477 | 6002926.75349176 | 2104136.57118168 | 37.7577236789461 | -122.432900729778 | (37.7577236789461, -122.432900729778) | ||
| 19239 | 19239 | 40472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
| 19427 | 19427 | 51055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748001 | (37.746973143605, -122.47319139748) | |||
| 19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 19789 | 19789 | 66507 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 64 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | Permit Number 29671 | 6009973.94739461 | 2110908.31483893 | 37.7767145222423 | -122.409006317188 | (37.7767145222423, -122.409006317188) | ||
| 20288 | 20288 | 34981 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 336 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41309 | 6003431.10233151 | 2104509.78972726 | 37.758777041212895 | -122.43118312363 | (37.7587770412129, -122.43118312363) | ||
| 20378 | 20378 | 31923 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 20492 | 20492 | 65549 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28448 | 5995107.08134396 | 2097533.05659271 | 37.739145462122394 | -122.45946595668998 | (37.7391454621224, -122.45946595669) | ||
| 21832 | 21832 | 52298 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48421st ST Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48459 | 6001164.37327683 | 2103435.80726183 | 37.7556994334338 | -122.43894553395599 | (37.7556994334338, -122.438945533956) | ||
| 24425 | 24425 | 68640 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1843 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32545 | 5990599.2738678 | 2102847.22998444 | 37.753476578420404 | -122.475439654249 | (37.7534765784204, -122.475439654249) | ||
| 24439 | 24439 | 50553 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2231 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 3 | Permit Number 47178 | 5988525.5467 | 2100131.4729 | 37.7458994060846 | -122.482411990345 | (37.7458994060846, -122.482411990345) | ||
| 24819 | 24819 | 65946 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 556 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 2 | Permit Number 28967 | 6007598.7781 | 2113267.2525 | 37.783058259910895 | -122.417389964837 | (37.7830582599109, -122.417389964837) | |
| 25373 | 25373 | 60884 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | |
| 26064 | 26064 | 43329 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43087 | 6003232.20541 | 2091824.6572900002 | 37.7239353231315 | -122.43096566975402 | (37.7239353231315, -122.430965669754) | |
| 26520 | 26520 | 45041 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1874 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 2 | Permit Number 43928 | 5988487.5162 | 2102559.2618 | 37.752563256460206 | -122.48272137554702 | (37.7525632564602, -122.482721375547) | |
| 29145 | 29145 | 43233 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1409 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43020 | 5989575.8109 | 2105718.1661 | 37.7613000207821 | -122.479188967162 | (37.7613000207821, -122.479188967162) | |
| 29397 | 29397 | 38753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 1 | Permit Number 40630 | 6012187.7155 | 2112376.5476 | 37.780869712107396 | -122.40145140226002 | (37.7808697121074, -122.40145140226) | ||
| 30525 | 30525 | 36338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.45733685578699 | (37.7264778306363, -122.457336855787) | ||
| 30680 | 30680 | 46074 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 126 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2010 12:00:00 AM | 4 | Permit Number 53303 | 5996573.1562 | 2113506.5298 | 37.783088742065296 | -122.455551189088 | (37.7830887420653, -122.455551189088) | ||
| 32121 | 32121 | 66333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 6 | Permit Number 29454 | 5986445.8362 | 2106470.4022 | 37.763183176794705 | -122.490069413492 | (37.7631831767947, -122.490069413492) | |
| 33475 | 33475 | 37204 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1575 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 2 | Permit Number 39771 | 5986202.8143 | 2104523.3582 | 37.75782293745029 | -122.49076666265499 | (37.7578229374503, -122.490766662655) | |
| 33802 | 33802 | 51854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 19 Emerson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2005 12:00:00 AM | 3 | Permit Number 48078 | 5998665.3644 | 2113591.8967 | 37.7834429726209 | -122.448319180732 | (37.7834429726209, -122.448319180732) | ||
| 34311 | 34311 | 67662 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.38719389035101 | (37.739521017402, -122.387193890351) | ||
| 34748 | 34748 | 43826 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2657 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43454 | 5985520.0574 | 2097206.122 | 37.7376918862353 | -122.49258900314899 | (37.7376918862353, -122.492589003149) | |
| 35382 | 35382 | 40325 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 655 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1999 12:00:00 AM | 4 | Permit Number 41463 | 6013209.4791 | 2113639.3788 | 37.78439411283129 | -122.39800521351201 | (37.7843941128313, -122.398005213512) | ||
| 36002 | 36002 | 38898 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.78331765575871 | -122.45461255567301 | (37.7833176557587, -122.454612555673) | |
| 37281 | 37281 | 38754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012174.72166 | 2112365.01303 | 37.7808373158384 | -122.40149554368901 | (37.7808373158384, -122.401495543689) | ||
| 37315 | 37315 | 68135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1640 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2011 12:00:00 AM | 1 | Permit Number 767463 | 6000632.1236 | 2114329.1398 | 37.7855794974585 | -122.44156790404699 | (37.7855794974585, -122.441567904047) | ||
| 37902 | 37902 | 60819 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1607 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 1 | Permit Number 20497 | 5989955.2951 | 2101733.4508 | 37.7503810843418 | -122.477585243781 | (37.7503810843418, -122.477585243781) | |
| 38530 | 38530 | 66212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2695 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1990 12:00:00 AM | 5 | Permit Number 29302 | 5988940.3934 | 2097023.2112 | 37.737389055247505 | -122.48075001046499 | (37.7373890552475, -122.480750010465) | ||
| 39935 | 39935 | 43837 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2707 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43459 | 5985531.9387 | 2096872.5005 | 37.736776545221204 | -122.492523362027 | (37.7367765452212, -122.492523362027) | |
| 41098 | 41098 | 45065 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | 5 | Permit Number 43947 | 5987876.0483 | 2100960.5293 | 37.7481379705415 | -122.484718643564 | (37.7481379705415, -122.484718643564) | ||
| 41810 | 41810 | 45064 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.748207264307496 | -122.484739557427 | (37.7482072643075, -122.484739557427) | ||
| 42456 | 42456 | 49558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 46 Arco Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 4 | Permit Number 46447 | 5999447.58525 | 2093082.81404 | 37.7271747584916 | -122.444138815875 | (37.7271747584916, -122.444138815875) | ||
| 42745 | 42745 | 63787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4043 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24473 | 6003575.02317091 | 2101250.14462278 | 37.749834980882 | -122.430452801929 | (37.749834980882, -122.430452801929) | ||
| 43487 | 43487 | 43574 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 165 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43235 | 6004098.34924441 | 2100984.69662112 | 37.7491357535113 | -122.42862419719101 | (37.7491357535113, -122.428624197191) | ||
| 43735 | 43735 | 50229 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 1 | Permit Number 46937 | 5987742.4672 | 2106112.8615 | 37.76227710092729 | -122.485558616267 | (37.7622771009273, -122.485558616267) | |
| 43817 | 43817 | 43193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 42992 | 6007883.41814 | 2094225.91699 | 37.7307911186019 | -122.415057008091 | (37.7307911186019, -122.415057008091) | ||
| 44048 | 44048 | 37254 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4200 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 44173 | 44173 | 41870 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42249 | 6003816.33085796 | 2108205.89422295 | 37.76894747793 | -122.430114498812 | (37.76894747793, -122.430114498812) | ||
| 44572 | 44572 | 52387 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48512 | 6005694.4540201 | 2096630.70014958 | 37.7372708656751 | -122.422795452389 | (37.7372708656751, -122.422795452389) | ||
| 44585 | 44585 | 37353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | Permit Number 39859 | 6000725.3710199995 | 2087720.25032 | 37.7125231844795 | -122.43933731388 | (37.7125231844795, -122.43933731388) | |
| 44762 | 44762 | 48666 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715REVISED Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 1 | Permit Number 45950 | 6004823.677 | 2115363.4456 | 37.7886573555281 | -122.42714004151699 | (37.7886573555281, -122.427140041517) | |
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 46066 | 46066 | 67709 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 87 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 10 | Permit Number 31320 | 6013781.91426 | 2112762.09602 | 37.7820171606904 | -122.395963274202 | (37.7820171606904, -122.395963274202) | ||
| 46491 | 46491 | 38115 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1342 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | 5 | Permit Number 40279 | 5987120.6367 | 2106124.4711 | 37.7622727278914 | -122.487710118761 | (37.7622727278914, -122.487710118761) | |
| 46598 | 46598 | 64923 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2326 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 25951 | 5991484.88147917 | 2099641.61135178 | 37.744726077494995 | -122.472143418263 | (37.744726077495, -122.472143418263) | ||
| 47331 | 47331 | 47760 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2586 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 7 | Permit Number 45539 | 5989891.5254 | 2097770.0852 | 37.7394950154316 | -122.47751611296002 | (37.7394950154316, -122.47751611296) | |
| 48076 | 48076 | 44724 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1970 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 1 | Permit Number 43843 | 5989436.9907 | 2101937.2229 | 37.750910497817294 | -122.479392462675 | (37.7509104978173, -122.479392462675) | |
| 48382 | 48382 | 65548 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 335 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28447 | 5995087.51239517 | 2097484.61184976 | 37.7390113196181 | -122.459530109112 | (37.7390113196181, -122.459530109112) | ||
| 48414 | 48414 | 40566 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 687 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 41611 | 6000998.28566 | 2089807.27388 | 37.7182692120226 | -122.43854347959801 | (37.7182692120226, -122.438543479598) | |||
| 49603 | 49603 | 42126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42422 | 5999645.50083885 | 2093804.90397788 | 37.729168738667795 | -122.44350647351001 | (37.7291687386678, -122.44350647351) | ||
| 50171 | 50171 | 66169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29241 | 6009332.38059352 | 2096679.3641893002 | 37.7376090764499 | -122.410220849347 | (37.7376090764499, -122.410220849347) | ||
| 51314 | 51314 | 64926 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2340 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 25954 | 5991486.309524599 | 2099579.02126823 | 37.744554303869705 | -122.47213391902599 | (37.7445543038697, -122.472133919026) | ||
| 51315 | 51315 | 34818 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 51429 | 51429 | 69307 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1522 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 2 | Permit Number 33386 | 5986858.656 | 2104872.1171 | 37.758818824109 | -122.48852415134701 | (37.758818824109, -122.488524151347) | |
| 51435 | 51435 | 65246 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1123 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28040 | 6009230.45296658 | 2102616.7905535 | 37.753906226408 | -122.410992511898 | (37.753906226408, -122.410992511898) | ||
| 51523 | 51523 | 43732 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | ||
| 52353 | 52353 | 40683 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 52 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 3 | Permit Number 41666 | 6003772.100819999 | 2093995.08887 | 37.7299254213136 | -122.429254030544 | (37.7299254213136, -122.429254030544) | |
| 52734 | 52734 | 69491 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 57 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 3 | Permit Number 33613 | 6002842.65111 | 2094614.47792 | 37.7315734613241 | -122.43251146944999 | (37.7315734613241, -122.43251146945) | |
| 53597 | 53597 | 42437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 53614 | 53614 | 65608 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.729507538818105 | -122.42525182613899 | (37.7295075388181, -122.425251826139) | ||
| 53792 | 53792 | 36410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.45835062173599 | (37.7273922712597, -122.458350621736) | ||
| 53793 | 53793 | 33345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | ||
| 54410 | 54410 | 34473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | ||
| 54613 | 54613 | 43848 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2634 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43470 | 5985245.7192 | 2097273.3217 | 37.7378603541939 | -122.493542458198 | (37.7378603541939, -122.493542458198) | |
| 55722 | 55722 | 39388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 414 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.745062524724204 | -122.43162276019501 | (37.7450625247242, -122.431622760195) | ||
| 56036 | 56036 | 42854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2471 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42783 | 5987340.671 | 2098461.3118 | 37.74124459004229 | -122.486386476099 | (37.7412445900423, -122.486386476099) | |
| 56224 | 56224 | 50964 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47459 | 5996570.7873 | 2113602.9801 | 37.783353433045995 | -122.455566358041 | (37.783353433046, -122.455566358041) | ||
| 56274 | 56274 | 45450 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 56362 | 56362 | 69494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 368 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33617 | 5999712.35805 | 2091715.6264799999 | 37.7234358783342 | -122.443125353647 | (37.7234358783342, -122.443125353647) | |
| 57263 | 57263 | 65499 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.48374245837299 | (37.7446414773793, -122.483742458373) | |
| 57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
| 58672 | 58672 | 58722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | ||
| 58689 | 58689 | 53262 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 2 | Permit Number 6152 | 5987525.5316 | 2103414.2811 | 37.7548548926849 | -122.486110800407 | (37.7548548926849, -122.486110800407) | ||
| 58712 | 58712 | 46802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.763524599 | 2095973.46470501 | 37.7348144532504 | -122.46228249422701 | (37.7348144532504, -122.462282494227) | ||
| 58719 | 58719 | 47693 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | ||
| 58952 | 58952 | 36362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.45722008615101 | (37.7283834402433, -122.457220086151) |
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");