Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189121 | 189121 | 214450 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 45 Dorantes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994111.5037 | 2100039.81972 | 37.7459711108718 | -122.463090021601 | (37.7459711108718, -122.463090021601) | |||
| 189052 | 189052 | 139053 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1470 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999716.3669 | 2113930.9987 | 37.784434089571704 | -122.444707517048 | (37.7844340895717, -122.444707517048) | |||
| 187913 | 187913 | 196376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012181.9653199995 | 2112407.5214 | 37.780954438148704 | -122.40147347253999 | (37.7809544381487, -122.40147347254) | |||
| 186573 | 186573 | 196411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009748.505890001 | 2111160.13618 | 37.7773933332614 | -122.40980396908002 | (37.7773933332614, -122.40980396908) | |||
| 186494 | 186494 | 182276 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985061.2024 | 2105018.6781 | 37.759116193094 | -122.494751291704 | (37.759116193094, -122.494751291704) | |||
| 185641 | 185641 | 138955 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 721 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004476.9169 | 2110918.2976 | 37.7764324685086 | -122.428022888756 | (37.7764324685086, -122.428022888756) | |||
| 185001 | 185001 | 47520 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 250 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45392 | 6000896.21512 | 2093538.05114 | 37.7285072713869 | -122.43916354146099 | (37.7285072713869, -122.439163541461) | |
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 182711 | 182711 | 91520 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 520 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52125 | 6011001.0511 | 2118999.3767 | 37.7989881374692 | -122.406023377789 | (37.7989881374692, -122.406023377789) | |
| 182499 | 182499 | 178943 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005019.44035 | 2094085.37748 | 37.730243869436 | -122.424948247481 | (37.730243869436, -122.424948247481) | |||
| 182392 | 182392 | 71214 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2131 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5988191.5983 | 2100799.6289 | 37.7477145531771 | -122.483615701045 | (37.7477145531771, -122.483615701045) | ||
| 182222 | 182222 | 178965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002497.1974599995 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | |||
| 182219 | 182219 | 63055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 3 | Permit Number 29651 | 6010016.44472 | 2110878.7775 | 37.7766358001278 | -122.408857221277 | (37.7766358001278, -122.408857221277) | |
| 181207 | 181207 | 92543 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 137 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52887 | 6010552.68366 | 2094065.4210599998 | 37.7305000701252 | -122.40581758561001 | (37.7305000701252, -122.40581758561) | |
| 179376 | 179376 | 182553 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2545 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986583.8092 | 2105694.5347 | 37.7610609151296 | -122.48953516150299 | (37.7610609151296, -122.489535161503) | |||
| 179211 | 179211 | 92327 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1347 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 52759 | 5986769.8307 | 2106074.1568 | 37.7621141110413 | -122.488919709577 | (37.7621141110413, -122.488919709577) |
| 178028 | 178028 | 38750 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012258.40846 | 2112446.8085 | 37.7810665763953 | -122.40121177791 | (37.7810665763953, -122.40121177791) | ||
| 176835 | 176835 | 247315 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 303 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003239.3513 | 2109346.5826 | 37.7720468334568 | -122.432191704953 | (37.7720468334568, -122.432191704953) | |||
| 176116 | 176116 | 183842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2222 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5987636.2237 | 2100151.1028 | 37.745901531101396 | -122.485488547623 | (37.7459015311014, -122.485488547623) | |||
| 175887 | 175887 | 45626 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2226 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/2001 12:00:00 AM | 3 | Permit Number 44336 | 5985467.3253 | 2100031.8294 | 37.745447435936896 | -122.492979406528 | (37.7454474359369, -122.492979406528) | |
| 175411 | 175411 | 139396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 496 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005003.1486 | 2111107.1822 | 37.7769808572422 | -122.426215953949 | (37.7769808572422, -122.426215953949) | |||
| 174170 | 174170 | 95122 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 75 Lyell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54049 | 6003110.14823 | 2094598.2490700001 | 37.731544066089 | -122.43158552205401 | (37.731544066089, -122.431585522054) |
| 173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
| 172415 | 172415 | 178930 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999988.7456 | 2091602.04327 | 37.723139760387504 | -122.442161785857 | (37.7231397603875, -122.442161785857) | |||
| 172080 | 172080 | 214438 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1237 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993585.37565 | 2107057.08841 | 37.7652083981778 | -122.465418951844 | (37.7652083981778, -122.465418951844) | |||
| 171955 | 171955 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6003967.5577300005 | 2094330.4049099998 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | ||||
| 171467 | 171467 | 196377 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 137 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012419.03852 | 2112368.2176 | 37.7808597440141 | -122.40065055237899 | (37.7808597440141, -122.400650552379) | |||
| 171407 | 171407 | 143053 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 700 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008940.2059 | 2120454.0688 | 37.8028668818708 | -122.413257538683 | (37.8028668818708, -122.413257538683) | |||
| 171386 | 171386 | 40958 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3442 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | 3 | Permit Number 41813 | 5987915.24459 | 2111913.2239 | 37.778213351801895 | -122.485386705758 | (37.7782133518019, -122.485386705758) | ||
| 171011 | 171011 | 92290 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2541 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52737 | 5989838.4923 | 2098065.0212 | 37.74030175588479 | -122.47772102971099 | (37.7403017558848, -122.477721029711) |
| 170313 | 170313 | 238021 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 142 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999408.516419999 | 2107367.43215 | 37.7663946408336 | -122.445300491725 | (37.7663946408336, -122.445300491725) | |||
| 169267 | 169267 | 71822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1300 26th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/1982 12:00:00 AM | 3 | 5988042.7796 | 2106389.3653 | 37.763053797513706 | -122.48454024385201 | (37.7630537975137, -122.484540243852) | |||
| 169014 | 169014 | 72898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2476 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | 5990180.6745 | 2098530.744 | 37.7416003626627 | -122.476571927541 | (37.7416003626627, -122.476571927541) | ||
| 168201 | 168201 | 38758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012273.2979999995 | 2112461.93462 | 37.7811089398776 | -122.401161330453 | (37.7811089398776, -122.401161330453) | ||
| 167652 | 167652 | 246225 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1387 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999540.3508 | 2107874.8368 | 37.7677953711537 | -122.44488098038401 | (37.7677953711537, -122.444880980384) | |||
| 166408 | 166408 | 196419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010076.8083 | 2110817.30643 | 37.776470395916206 | -122.40864406758301 | (37.7764703959162, -122.408644067583) | |||
| 164638 | 164638 | 178898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012665.55046 | 2087301.61111 | 37.7120459484316 | -122.398038730507 | (37.7120459484316, -122.398038730507) | |||
| 163292 | 163292 | 196380 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012381.80562 | 2112329.94836 | 37.780752588889705 | -122.40077667062599 | (37.7807525888897, -122.400776670626) | |||
| 161251 | 161251 | 214467 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5997445.39853 | 2095476.3376 | 37.7336323791121 | -122.451232866022 | (37.7336323791121, -122.451232866022) | |||
| 160976 | 160976 | 43236 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1750 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43023 | 5989702.3281 | 2103445.8872 | 37.7550682980166 | -122.478585226723 | (37.7550682980166, -122.478585226723) | |
| 160580 | 160580 | 182741 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1770 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988465.6918 | 2103273.9626 | 37.754524363505 | -122.482849220914 | (37.754524363505, -122.482849220914) | |||
| 159980 | 159980 | 196374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012209.830030001 | 2112433.27452 | 37.7810267049661 | -122.40137888454201 | (37.7810267049661, -122.401378884542) | |||
| 159451 | 159451 | 42263 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1579 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42504 | 5988063.3445 | 2104556.9894 | 37.7580237898534 | -122.484334720445 | (37.7580237898534, -122.484334720445) | |
| 159299 | 159299 | 43835 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43458 | 5985569.0545 | 2097059.5514 | 37.737292307195396 | -122.492408808668 | (37.7372923071954, -122.492408808668) | |
| 158401 | 158401 | 118027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.780415056002205 | -122.49786249135201 | (37.7804150560022, -122.497862491352) | |||
| 157753 | 157753 | 184578 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1726 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984111.7886 | 2103392.1174 | 37.7545944930516 | -122.49791465490499 | (37.7545944930516, -122.497914654905) | |||
| 157212 | 157212 | 93809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 460 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2010 12:00:00 AM | 3 | Permit Number 57622 | 6003467.08848 | 2090756.16475 | 37.7210147855714 | -122.43007752986999 | (37.7210147855714, -122.43007752987) | ||
| 156388 | 156388 | 214471 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000292.89042 | 2094938.1792099997 | 37.7323173490585 | -122.441349683656 | (37.7323173490585, -122.441349683656) | |||
| 154865 | 154865 | 139183 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1900 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002330.6115 | 2113779.5111 | 37.784166978068 | -122.435652302842 | (37.784166978068, -122.435652302842) | |||
| 154849 | 154849 | 135905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6006460.32075 | 2121020.9303099997 | 37.804283800830795 | -122.42187952052099 | (37.8042838008308, -122.421879520521) | |||
| 154642 | 154642 | 178945 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 202 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004737.15632 | 2094036.7651400003 | 37.730094441687 | -122.42592068260599 | (37.730094441687, -122.425920682606) | |||
| 154579 | 154579 | 214418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995206.37473 | 2088687.6179099998 | 37.714863728550604 | -122.458482527651 | (37.7148637285506, -122.458482527651) | |||
| 154301 | 154301 | 182184 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1608 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988115.6488 | 2104343.8826 | 37.757441701729 | -122.484138204224 | (37.757441701729, -122.484138204224) | |||
| 153541 | 153541 | 178882 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | |||
| 151052 | 151052 | 178883 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003694.22054 | 2090531.28472 | 37.7204101758585 | -122.42927637423 | (37.7204101758585, -122.42927637423) | |||
| 150151 | 150151 | 71225 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2262 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5987644.7584 | 2099883.1111 | 37.7451661944085 | -122.485439373685 | (37.7451661944085, -122.485439373685) | ||
| 149620 | 149620 | 214464 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000254.923830001 | 2094969.53305 | 37.732401276487 | -122.44148319160801 | (37.732401276487, -122.441483191608) | |||
| 147197 | 147197 | 139395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 486 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005025.4278 | 2111110.8954 | 37.7769923120329 | -122.426139147688 | (37.7769923120329, -122.426139147688) | |||
| 147146 | 147146 | 142758 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010864.8123 | 2120023.3634 | 37.80179213390711 | -122.406567008949 | (37.8017921339071, -122.406567008949) | |||
| 146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
| 146157 | 146157 | 115103 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | |||
| 145371 | 145371 | 89654 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3021 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989260.15494 | 2111906.2632400002 | 37.778272500510894 | -122.480733712855 | (37.7782725005109, -122.480733712855) | ||
| 145044 | 145044 | 104036 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 149 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 770678 | 6005538.0 | 2099025.0 | 37.743836244033496 | -122.423506557165 | (37.7438362440335, -122.423506557165) | ||
| 143612 | 143612 | 94987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 36 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2015 03:25:00 PM | 3 | 3x3 | 6010827.4 | 2087210.2 | 37.711692402207106 | -122.40438551024401 | (37.7116924022071, -122.404385510244) | ||
| 143514 | 143514 | 4029 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 141683 | 141683 | 8518 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2099X Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | ||
| 138262 | 138262 | 70314 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 209 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51137 | 5997808.9346 | 2109832.5111 | 37.7730716783726 | -122.451010898748 | (37.7730716783726, -122.451010898748) | |
| 137191 | 137191 | 36164 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 3 | Permit Number 39245 | 5997542.7347 | 2113210.4108 | 37.7823312669858 | -122.452175486469 | (37.7823312669858, -122.452175486469) | |
| 136990 | 136990 | 182393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1554 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988100.204 | 2104724.7345 | 37.758486518599796 | -122.48421954804199 | (37.7584865185998, -122.484219548042) | |||
| 136756 | 136756 | 63604 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 900 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | 3 | Permit Number 24240 | 5999553.7216 | 2111620.759 | 37.778081485139296 | -122.445104066804 | (37.7780814851393, -122.445104066804) | |
| 136440 | 136440 | 247321 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 216 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002799.395 | 2109324.8498 | 37.771962206126794 | -122.433711993285 | (37.7719622061268, -122.433711993285) | |||
| 135279 | 135279 | 41123 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2012 12:00:00 AM | 3 | Permit Number 768786 | 5998522.6402 | 2110343.8816 | 37.77451660437121 | -122.448578947735 | (37.7745166043712, -122.448578947735) | |
| 134832 | 134832 | 238035 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 47 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002547.90945 | 2096426.13275 | 37.736531132406604 | -122.43365987760401 | (37.7365311324066, -122.433659877604) | |||
| 133718 | 133718 | 182549 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986517.2893 | 2105614.7843 | 37.7608380588456 | -122.489759356723 | (37.7608380588456, -122.489759356723) | |||
| 133307 | 133307 | 137970 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 POST ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004704.8729 | 2114380.3573 | 37.785951322241004 | -122.42748102225401 | (37.785951322241, -122.427481022254) | |||
| 130997 | 130997 | 38752 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 3 | Permit Number 40630 | 6012228.62933 | 2112416.55663 | 37.780981850378105 | -122.40131267285 | (37.7809818503781, -122.40131267285) | ||
| 130397 | 130397 | 178963 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006326.59012 | 2093865.7151900001 | 37.729714473630295 | -122.420413662483 | (37.7297144736303, -122.420413662483) | |||
| 128771 | 128771 | 102810 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.0068900003 | 37.780140206640205 | -122.493254729507 | (37.7801402066402, -122.493254729507) | |
| 128575 | 128575 | 89655 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3003 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989317.85585 | 2111907.9300700002 | 37.778280430687396 | -122.480534228481 | (37.7782804306874, -122.480534228481) | ||
| 126737 | 126737 | 27754 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 125081 | 125081 | 4027 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 124164 | 124164 | 27720 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 06:49:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.750187626613496 | -122.39046013782401 | (37.7501876266135, -122.390460137824) | ||
| 123464 | 123464 | 4023 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 123154 | 123154 | 4019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1760 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 3 | 2X3 | 6013957.30178 | 2101067.5315943 | 37.7499162221241 | -122.39453736171801 | (37.7499162221241, -122.394537361718) | ||
| 123029 | 123029 | 116779 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650.0 | 2118281.0 | 37.796883878440795 | -122.41410797545099 | (37.7968838784408, -122.414107975451) | ||
| 123021 | 123021 | 109156 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2015 01:49:00 PM | 3 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||
| 122216 | 122216 | 43232 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1275 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43019 | 5989543.2106 | 2106684.7604 | 37.7639521342039 | -122.479372433397 | (37.7639521342039, -122.479372433397) | |
| 121773 | 121773 | 4025 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/2015 03:01:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 119406 | 119406 | 4026 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 118003 | 118003 | 27753 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 117113 | 117113 | 103651 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 307X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |
| 116748 | 116748 | 91939 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 947 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992870.0 | 2106592.0 | 37.7638901044666 | -122.467859413197 | (37.7638901044666, -122.467859413197) | ||
| 116574 | 116574 | 91879 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 822 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2016 06:37:00 AM | 3 | 3x3 | 5993243.241662 | 2106653.483375 | 37.764080467218896 | -122.46657296270399 | (37.7640804672189, -122.466572962704) | ||
| 116364 | 116364 | 61460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 212 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2016 12:00:00 AM | 3 | Permit Number 778169 | 6004120.40486409 | 2107599.50179922 | 37.7672996882221 | -122.429019486595 | (37.7672996882221, -122.429019486595) | |
| 114696 | 114696 | 18784 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 345X Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 3x3 | 6000292.8158924 | 2106925.3125911 | 37.7652311289718 | -122.442210131131 | (37.7652311289718, -122.442210131131) | ||
| 112696 | 112696 | 55637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 258 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778639 | 6002688.12514343 | 2104391.86827459 | 37.758411125870104 | -122.43374425038999 | (37.7584111258701, -122.43374425039) | |
| 112336 | 112336 | 24168 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 107990 | 107990 | 18204 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1570 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6004662.4699013 | 2114369.5525339 | 37.7859192566668 | -122.42762695498699 | (37.7859192566668, -122.427626954987) | |||
| 107830 | 107830 | 4033 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 107038 | 107038 | 91878 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 750 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5993469.259852 | 2106661.22542 | 37.7641147650176 | -122.465791800781 | (37.7641147650176, -122.465791800781) |
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");