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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
| 188317 | 188317 | 81230 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1615 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2005 12:00:00 AM | 2 | 3x3 | Permit Number 49855 | 5989003.1653 | 2104324.8882 | 37.757441181357 | -122.48106746320101 | (37.757441181357, -122.481067463201) | |
| 187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) | |
| 187269 | 187269 | 49212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | |
| 186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
| 186001 | 186001 | 95591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986627.6602 | 2107061.3303 | 37.7648163177268 | -122.48948400821001 | (37.7648163177268, -122.48948400821) |
| 185181 | 185181 | 47469 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2907 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45370 | 5999522.715 | 2114292.4911 | 37.785415601023395 | -122.445403484856 | (37.7854156010234, -122.445403484856) | |
| 185028 | 185028 | 43836 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43458 | 5985569.2648 | 2097041.677 | 37.737243241151496 | -122.492406765684 | (37.7372432411515, -122.492406765684) | |
| 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) | |
| 183255 | 183255 | 83569 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2579 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50370 | 5987984.0904 | 2097769.4524 | 37.7393824087044 | -122.48411106317499 | (37.7393824087044, -122.484111063175) | |
| 182867 | 182867 | 41338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | ||
| 182779 | 182779 | 31302 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.42548090783501 | (37.7779765092875, -122.425480907835) | |
| 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) | |
| 182703 | 182703 | 41337 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 176 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.7 | 2113122.5903 | 37.7820168986492 | -122.456587081702 | (37.7820168986492, -122.456587081702) | ||
| 182510 | 182510 | 43851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.737130827494504 | -122.49349719028 | (37.7371308274945, -122.49349719028) | |
| 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) | |
| 181390 | 181390 | 46205 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2005 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | |
| 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) | |
| 180921 | 180921 | 52459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 584@ BALBOA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48570 | 5992242.76591 | 2111511.4032400004 | 37.777361226341895 | -122.470387093473 | (37.7773612263419, -122.470387093473) | |
| 180326 | 180326 | 38857 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 8 | Permit Number 40684 | 5989293.1114 | 2104890.3622 | 37.759010671995505 | -122.48010610913401 | (37.7590106719955, -122.480106109134) | |
| 179574 | 179574 | 36161 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 59 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 2 | Permit Number 39242 | 5997481.3111 | 2113388.5898 | 37.7828169808275 | -122.45240084560699 | (37.7828169808275, -122.452400845607) | |
| 179446 | 179446 | 92292 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2551 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52738 | 5989839.8453 | 2098004.8092 | 37.7401365078293 | -122.47771195140801 | (37.7401365078293, -122.477711951408) |
| 179405 | 179405 | 95827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 144A Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767562 | 6010353.30698 | 2110532.02613 | 37.7757025646591 | -122.407667456007 | (37.7757025646591, -122.407667456007) |
| 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) |
| 179096 | 179096 | 31300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | |
| 179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | |
| 179038 | 179038 | 82923 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1622 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52750 | 5989046.8138 | 2104277.4442 | 37.757313450159295 | -122.48091303747299 | (37.7573134501593, -122.480913037473) |
| 178235 | 178235 | 51494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1767 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | 1 | Permit Number 47806 | 5984074.2238 | 2103158.268 | 37.7539502052222 | -122.498027293704 | (37.7539502052222, -122.498027293704) | ||
| 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) | ||
| 177998 | 177998 | 63548 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 942 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 10 | Permit Number 24164 | 5999530.709 | 2111776.0946 | 37.7785066833069 | -122.445194846179 | (37.7785066833069, -122.445194846179) | |
| 176061 | 176061 | 52828 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 750WASHINGTON Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48852 | 6011319.3348 | 2117592.1734 | 37.79514209381671 | -122.404822878731 | (37.7951420938167, -122.404822878731) | ||
| 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) | |
| 175027 | 175027 | 51531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 175 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 1 | Permit Number 47833 | 5997697.55511 | 2087175.4993200002 | 37.7108546506849 | -122.449763101302 | (37.7108546506849, -122.449763101302) | ||
| 174807 | 174807 | 44212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2009 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/2002 12:00:00 AM | 2 | Permit Number 43659 | 6003842.4279 | 2115438.8041 | 37.788808732867395 | -122.43054039659799 | (37.7888087328674, -122.430540396598) | |
| 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) |
| 172828 | 172828 | 30770 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1662 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | Permit Number 51077 | 6014463.7744 | 2093152.8983 | 37.7282124168861 | -122.39223247286101 | (37.7282124168861, -122.392232472861) | ||
| 172535 | 172535 | 47757 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2517 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 7 | Permit Number 45537 | 5989831.6247 | 2098216.4636 | 37.7407171789575 | -122.477755842346 | (37.7407171789575, -122.477755842346) | |
| 172408 | 172408 | 95443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1634 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767305 | 5985639.2643 | 2104071.5459 | 37.7565494487406 | -122.49268234984 | (37.7565494487406, -122.49268234984) |
| 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) |
| 169349 | 169349 | 31758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2646 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35244 | 5989596.3538 | 2097340.4362 | 37.738298177735 | -122.478505265789 | (37.738298177735, -122.478505265789) | |
| 169020 | 169020 | 30735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005244.0655 | 2109725.8172 | 37.773201579085004 | -122.42528422609699 | (37.773201579085, -122.425284226097) | |
| 168850 | 168850 | 92321 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2591 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52754 | 5988296.7898 | 2097687.1554 | 37.739174643542796 | -122.483023869558 | (37.7391746435428, -122.483023869558) |
| 168740 | 168740 | 96022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 625 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767663 | 6007522.2203 | 2113467.103 | 37.7836026932034 | -122.417668993855 | (37.7836026932034, -122.417668993855) |
| 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) | ||
| 167694 | 167694 | 34635 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1458 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52130 | 5988076.0988 | 2105378.3876 | 37.7602798688507 | -122.48435085380501 | (37.7602798688507, -122.484350853805) | |
| 167611 | 167611 | 95528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) |
| 167545 | 167545 | 51767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982982.0116 | 2104266.5376 | 37.756929105781495 | -122.501886355597 | (37.7569291057815, -122.501886355597) | ||
| 165170 | 165170 | 66492 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 58 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 8 | Permit Number 29653 | 6009972.98695 | 2110931.16988 | 37.7767772230325 | -122.409011252663 | (37.7767772230325, -122.409011252663) | |
| 164556 | 164556 | 92332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2178 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52764 | 5986694.1348 | 2100449.0089 | 37.746664568430795 | -122.488768011117 | (37.7466645684308, -122.488768011117) |
| 163874 | 163874 | 58170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1410 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1988 12:00:00 AM | 2 | Permit Number 25303 | 5999733.102000001 | 2113804.6885 | 37.7840882294941 | -122.44464053791 | (37.7840882294941, -122.44464053791) | ||
| 163864 | 163864 | 47758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2517 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 4 | Permit Number 45537 | 5989832.0192 | 2098195.9454 | 37.740660864188 | -122.477752978845 | (37.740660864188, -122.477752978845) | |
| 163621 | 163621 | 82790 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49858 | 5989079.3347 | 2102124.6913 | 37.7514044560494 | -122.48064297897699 | (37.7514044560494, -122.480642978977) | |
| 163426 | 163426 | 104125 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1330 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 9x6 | Permit Number 770527 | 6001480.2051 | 2110460.0547 | 37.775004252315604 | -122.438356503743 | (37.7750042523156, -122.438356503743) | ||
| 163418 | 163418 | 48665 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715REVISED Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 2 | Permit Number 45950 | 6004834.5382 | 2115307.6761 | 37.7885048406598 | -122.42709848948799 | (37.7885048406598, -122.427098489488) | |
| 162516 | 162516 | 69047 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3627 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 1 | Permit Number 33054 | 5984427.5354 | 2106304.0281 | 37.762608292752105 | -122.497037654386 | (37.7626082927521, -122.497037654386) | |
| 162332 | 162332 | 85242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | 1 | Permit Number 49544 | 5981385.546 | 2104841.9152 | 37.7584150182243 | -122.507450124372 | (37.7584150182243, -122.507450124372) | ||
| 161721 | 161721 | 50963 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 2 | Permit Number 47459 | 5996572.8178 | 2113583.69 | 37.7833005840711 | -122.455557938638 | (37.7833005840711, -122.455557938638) | ||
| 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) | |
| 160892 | 160892 | 92303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1583 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52748 | 5988994.8845 | 2104576.1068 | 37.758130478678105 | -122.481114495747 | (37.7581304786781, -122.481114495747) |
| 160866 | 160866 | 44713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1923 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 6 | Permit Number 43836 | 5990003.0613 | 2102262.9361 | 37.7518376831776 | -122.477458761132 | (37.7518376831776, -122.477458761132) | |
| 160610 | 160610 | 67707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 31 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 11 | Permit Number 31318 | 6014113.9587900005 | 2113076.60421 | 37.7828991959845 | -122.39483657655 | (37.7828991959845, -122.39483657655) | |
| 159661 | 159661 | 47761 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2582 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 1 | Permit Number 45540 | 5989894.53015279 | 2097799.30899888 | 37.7395754307957 | -122.477507859345 | (37.7395754307957, -122.477507859345) | |
| 159636 | 159636 | 40022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | |
| 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) | |
| 159197 | 159197 | 44057 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | ||
| 159144 | 159144 | 46854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44923 | 6003136.568519999 | 2092772.62748 | 37.7265328179246 | -122.431363909331 | (37.7265328179246, -122.431363909331) | |
| 158113 | 158113 | 65196 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 326 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 4 | Permit Number 27181 | 6003265.18452 | 2091962.93655 | 37.7243168758021 | -122.43086153005501 | (37.7243168758021, -122.430861530055) | |
| 157805 | 157805 | 36162 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 5 | Permit Number 39243 | 5997531.2283 | 2113294.3394 | 37.7825610537015 | -122.452221351103 | (37.7825610537015, -122.452221351103) | |
| 157734 | 157734 | 46392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2474 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 1 | Permit Number 44624 | 5982733.0582 | 2098295.9927 | 37.7405210225717 | -122.502305471655 | (37.7405210225717, -122.502305471655) | |
| 157644 | 157644 | 49211 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001478.3979 | 2115000.5443 | 37.787471180094705 | -122.438688174294 | (37.7874711800947, -122.438688174294) | ||
| 156668 | 156668 | 70126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.9090200001 | 37.720567588703105 | -122.43150910488701 | (37.7205675887031, -122.431509104887) |
| 156664 | 156664 | 51809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | 2 | 3x3 | Permit Number 48055 | 6015110.437000001 | 2092946.715 | 37.7276821641004 | -122.389982519172 | (37.7276821641004, -122.389982519172) | |
| 156078 | 156078 | 92366 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1915 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52779 | 5985969.6964 | 2102174.4618 | 37.7513598906592 | -122.49139998707199 | (37.7513598906592, -122.491399987072) |
| 154563 | 154563 | 53175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 732 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 1 | Permit Number 49090 | 6000061.1851 | 2111441.5646 | 37.7776184143497 | -122.443335699324 | (37.7776184143497, -122.443335699324) | |
| 152143 | 152143 | 45042 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1874 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 6 | Permit Number 43928 | 5988487.0359 | 2102578.4714 | 37.7526159729384 | -122.48272444408998 | (37.7526159729384, -122.48272444409) | |
| 151643 | 151643 | 31579 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1766 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 10 | Permit Number 35118 | 5989083.5648 | 2103328.988 | 37.7547113797178 | -122.480716506349 | (37.7547113797178, -122.480716506349) | |
| 151451 | 151451 | 95446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.49209381774901 | (37.7458386996409, -122.492093817749) |
| 151418 | 151418 | 47893 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 745 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48331 | 6000477.4696 | 2111570.4889 | 37.7779961374161 | -122.44190489030899 | (37.7779961374161, -122.441904890309) | |
| 151321 | 151321 | 84041 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1514 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52690 | 5986231.2266 | 2104899.676 | 37.758857862275704 | -122.49069609034099 | (37.7588578622757, -122.490696090341) | |
| 150756 | 150756 | 104961 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2013 12:00:00 AM | 10 | Permit Number 770811 | 5996496.5 | 2113597.6 | 37.7833343975689 | -122.455822972198 | (37.7833343975689, -122.455822972198) | ||
| 150611 | 150611 | 31299 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34943 | 6005251.2106 | 2111468.7266 | 37.777987587802 | -122.42538356524099 | (37.777987587802, -122.425383565241) | |
| 149853 | 149853 | 53802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1758 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9494 | 5983498.0607 | 2103182.1267 | 37.7539819174643 | -122.500021533616 | (37.7539819174643, -122.500021533616) | ||
| 149345 | 149345 | 92403 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1545 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52803 | 5985264.691000001 | 2104708.4468 | 37.7582762928221 | -122.494024677293 | (37.7582762928221, -122.494024677293) |
| 149041 | 149041 | 46629 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1490 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 7 | Permit Number 44750 | 6015847.6531 | 2095265.1212 | 37.734088902667104 | -122.38759560956001 | (37.7340889026671, -122.38759560956) | |
| 147047 | 147047 | 92304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52751 | 5989091.9697 | 2101683.9526 | 37.7501950388707 | -122.480567026206 | (37.7501950388707, -122.480567026206) |
| 146852 | 146852 | 49210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001469.3091 | 2115060.1894 | 37.7876344331375 | -122.43872389522 | (37.7876344331375, -122.43872389522) | ||
| 146395 | 146395 | 67954 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2011 12:00:00 AM | 1 | Permit Number 768251 | 5988399.92289 | 2111930.46202 | 37.778288907581 | -122.483711310905 | (37.778288907581, -122.483711310905) | |
| 146393 | 146393 | 81679 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1942 Vicente St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52863 | 5986874.2463 | 2097598.6809 | 37.738848836056 | -122.487935819213 | (37.738848836056, -122.487935819213) |
| 146227 | 146227 | 45359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 438 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44767 | 5993275.62106747 | 2090094.58069454 | 37.718615761020004 | -122.46525810245701 | (37.71861576102, -122.465258102457) | ||
| 146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 145842 | 145842 | 40948 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | ||
| 145743 | 145743 | 34397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 140 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38144 | 6002549.58677603 | 2096969.20024046 | 37.7380223658164 | -122.433692879918 | (37.7380223658164, -122.433692879918) | ||
| 145702 | 145702 | 33705 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 156 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37773 | 6003507.92359647 | 2108831.35817354 | 37.7706473771769 | -122.431225909902 | (37.7706473771769, -122.431225909902) | |||
| 145699 | 145699 | 32137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
| 145671 | 145671 | 62859 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 215 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23227 | 6008661.7100891 | 2097596.64616316 | 37.740090116159294 | -122.412604509779 | (37.7400901161593, -122.412604509779) | ||
| 145666 | 145666 | 68951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 738 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32940 | 5988848.01258948 | 2110286.79093664 | 37.7738019171776 | -122.482040779575 | (37.7738019171776, -122.482040779575) | ||
| 145664 | 145664 | 50427 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 575 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47080 | 5996062.43497228 | 2089871.90840865 | 37.718164673097 | -122.45560919316799 | (37.718164673097, -122.455609193168) | ||
| 145650 | 145650 | 40461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 327 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41546 | 6007757.73635157 | 2097585.89785669 | 37.740009828036705 | -122.415729329739 | (37.7400098280367, -122.415729329739) |
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");