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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 13302 | 13302 | 187656 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1548 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | ||||
| 14002 | 14002 | 44086 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013734.19002 | 2112474.65205 | 37.7812252500735 | -122.396108228707 | (37.7812252500735, -122.396108228707) | |
| 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 | ||||||||
| 15620 | 15620 | 44090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013747.9947 | 2112490.5876700003 | 37.7812697737139 | -122.39606158808701 | (37.7812697737139, -122.396061588087) | |
| 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) | ||
| 18192 | 18192 | 64739 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51671 | 6002793.57505281 | 2109015.34015791 | 37.771112038694504 | -122.43371000005101 | (37.7711120386945, -122.433710000051) | ||
| 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) | ||
| 18656 | 18656 | 25472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1999 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.714208763487896 | -122.46459914058599 | (37.7142087634879, -122.464599140586) | ||
| 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) | ||
| 20466 | 20466 | 18597 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | ||
| 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) | ||
| 22231 | 22231 | 25471 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | ||
| 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) | |
| 27021 | 27021 | 95729 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) |
| 27593 | 27593 | 82193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49858 | 5989080.382 | 2102109.5053 | 37.7513628201965 | -122.48063824575 | (37.7513628201965, -122.48063824575) | |
| 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) | |
| 29283 | 29283 | 95438 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.746478551124504 | -122.48874631833598 | (37.7464785511245, -122.488746318336) |
| 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) | ||
| 34554 | 34554 | 92542 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 129 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52886 | 6010542.11041 | 2094099.98718 | 37.730594390103505 | -122.40585657301901 | (37.7305943901035, -122.405856573019) | |
| 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) | ||
| 35810 | 35810 | 92326 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52758 | 5986769.8307 | 2106099.7914 | 37.7621844965801 | -122.488921594092 | (37.7621844965801, -122.488921594092) |
| 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) | |
| 36062 | 36062 | 96607 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1655 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768135 | 5988818.1686 | 2103045.0516 | 37.7539163374898 | -122.48161351303601 | (37.7539163374898, -122.481613513036) | |
| 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) | |
| 38035 | 38035 | 92473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2408 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52855 | 5988531.9158 | 2098337.111 | 37.7409729307865 | -122.482258526052 | (37.7409729307865, -122.482258526052) |
| 38492 | 38492 | 92487 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2424 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52858 | 5988469.6462 | 2098334.742 | 37.7409628038913 | -122.482473655322 | (37.7409628038913, -122.482473655322) |
| 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) | ||
| 39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
| 39304 | 39304 | 97751 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2478 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x6 | 5989249.1358 | 2098482.8133 | 37.741414683908 | -122.479789330113 | (37.741414683908, -122.479789330113) | |||
| 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) | |
| 40005 | 40005 | 32827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.751219399221604 | -122.434275246016 | (37.7512193992216, -122.434275246016) |
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 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) | ||
| 41505 | 41505 | 92486 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2416 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52857 | 5988503.8268 | 2098336.0957 | 37.7409685091415 | -122.48235557195801 | (37.7409685091415, -122.482355571958) |
| 41743 | 41743 | 99624 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768786 | 5998532.9 | 2110322.2 | 37.7744576589045 | -122.448541895436 | (37.7744576589045, -122.448541895436) | |
| 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) | ||
| 42720 | 42720 | 94722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 172 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53857 | 5998128.6274 | 2113392.2279 | 37.7828640340497 | -122.450161675731 | (37.7828640340497, -122.450161675731) |
| 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) | ||
| 43324 | 43324 | 61000 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 569 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | 3x3 | Permit Number 20813 | 6003055.65980298 | 2095965.62236934 | 37.735295473547794 | -122.43187149765 | (37.7352954735478, -122.43187149765) | |
| 43360 | 43360 | 84963 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51615 | 5999235.1 | 2094032.0 | 37.7297688774613 | -122.44494157687599 | (37.7297688774613, -122.444941576876) | ||
| 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) | |
| 44756 | 44756 | 97495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988364.44571 | 2111930.92454 | 37.778288112362 | -122.483834071993 | (37.778288112362, -122.483834071993) | |
| 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) | ||
| 46224 | 46224 | 91571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 511 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52143 | 6010245.730359999 | 2088527.6355299999 | 37.71527728989071 | -122.40648870199 | (37.7152772898907, -122.40648870199) | |
| 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) | |
| 46496 | 46496 | 92773 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 135 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52993 | 5997556.9484 | 2112845.9305 | 37.7813313140415 | -122.452100007845 | (37.7813313140415, -122.452100007845) | |
| 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) | ||
| 46606 | 46606 | 42787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 413 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42754 | 6004586.33786017 | 2109969.42501453 | 37.773833286350396 | -122.427576752843 | (37.7738332863504, -122.427576752843) | |
| 46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
| 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) | |||
| 48718 | 48718 | 97494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988382.76278 | 2111930.5362 | 37.778288112363796 | -122.483770678777 | (37.7782881123638, -122.483770678777) | |
| 49418 | 49418 | 104126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1330 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 8x6 | Permit Number 770527 | 6001460.4923 | 2110454.7269 | 37.774988502255 | -122.438424312648 | (37.774988502255, -122.438424312648) | ||
| 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) | ||
| 50354 | 50354 | 95524 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767316 | 5987892.7113 | 2105115.9895 | 37.75954871508429 | -122.484965845966 | (37.7595487150843, -122.484965845966) |
| 50603 | 50603 | 43244 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 148 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52907 | 6010526.7074 | 2094001.3390799998 | 37.7303226617554 | -122.405902877341 | (37.7303226617554, -122.405902877341) | |
| 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) |
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");