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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 180505 | 180505 | 79189 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5988574.1949 | 2099905.7282 | 37.745282400553 | -122.482227237552 | (37.745282400553, -122.482227237552) | |||
| 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) | |
| 180063 | 180063 | 83723 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986042.1421 | 2100161.1312 | 37.7458360633129 | -122.491001322638 | (37.7458360633129, -122.491001322638) | |||
| 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) | |
| 179548 | 179548 | 73527 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5988189.2832 | 2100871.8604 | 37.747912746917 | -122.48362900134701 | (37.747912746917, -122.483629001347) | ||
| 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) |
| 178351 | 178351 | 71165 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 4 | 5988190.2092 | 2100857.5067 | 37.747873389373396 | -122.48362474712499 | (37.7478733893734, -122.483624747125) | ||
| 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) | |
| 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) | |
| 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) |
| 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) |
| 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) | |
| 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) | ||
| 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) |
| 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) |
| 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) | |
| 165087 | 165087 | 71211 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2267 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | 5988532.3745 | 2099906.1549 | 37.7452811395366 | -122.48237187504 | (37.7452811395366, -122.48237187504) | ||
| 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) |
| 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) | |
| 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) | |
| 162534 | 162534 | 70939 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1925 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1995 12:00:00 AM | 4 | 5989075.8648 | 2102218.2021 | 37.7516610101851 | -122.480661823031 | (37.7516610101851, -122.480661823031) | ||
| 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) | |
| 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) | |
| 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) | |
| 158689 | 158689 | 70671 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 73 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 2 | 6010033.5172 | 2110899.92735 | 37.7766948289379 | -122.408799654802 | (37.7766948289379, -122.408799654802) | ||
| 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) | |
| 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) |
| 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) |
| 154934 | 154934 | 80023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.43968765086201 | (37.7762172841329, -122.439687650862) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 147970 | 147970 | 73456 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 11 | 6009946.950619999 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 145639 | 145639 | 62945 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23327 | 6007203.62024712 | 2097035.47638332 | 37.7384673272843 | -122.41760623779601 | (37.7384673272843, -122.417606237796) | ||
| 145629 | 145629 | 37877 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355121998 | 37.7297645826714 | -122.45354159093701 | (37.7297645826714, -122.453541590937) | ||
| 145527 | 145527 | 52163 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2807 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | Permit Number 48356 | 6009994.23902274 | 2102188.41779998 | 37.752772810696605 | -122.408320936624 | (37.7527728106966, -122.408320936624) | ||
| 145500 | 145500 | 52532 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | |
| 145426 | 145426 | 45252 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 568 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44099 | 6009813.67282905 | 2098883.83763279 | 37.7436890489958 | -122.40871226048701 | (37.7436890489958, -122.408712260487) | ||
| 145399 | 145399 | 45277 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 530 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44120 | 6007988.96647408 | 2096402.04290031 | 37.736772218146 | -122.41484606418501 | (37.736772218146, -122.414846064185) | ||
| 145387 | 145387 | 45139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43996 | 6000511.08946601 | 2109229.61979704 | 37.771570618561604 | -122.44162055585 | (37.7715706185616, -122.44162055585) | ||
| 145379 | 145379 | 37266 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 145257 | 145257 | 48941 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46128 | 6011661.44049501 | 2091503.35733972 | 37.7235271168325 | -122.401804405977 | (37.7235271168325, -122.401804405977) | ||
| 145244 | 145244 | 36433 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
| 145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 145099 | 145099 | 31922 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 1 | 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) | ||
| 145088 | 145088 | 36583 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1378 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39444 | 6009261.20468059 | 2101135.34094494 | 37.7498402210045 | -122.410781546504 | (37.7498402210045, -122.410781546504) | ||
| 145059 | 145059 | 36395 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 799 FAXON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39328 | 5994869.9 | 2093286.2 | 37.7274709926994 | -122.459978448904 | (37.7274709926994, -122.459978448904) | ||
| 145007 | 145007 | 32149 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35500 | 6006458.85096741 | 2110609.91009121 | 37.775697640431396 | -122.42114490355699 | (37.7756976404314, -122.421144903557) | ||
| 144966 | 144966 | 66440 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 260 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29585 | 6006101.64636516 | 2096073.98831183 | 37.735765225297705 | -122.421348075821 | (37.7357652252977, -122.421348075821) | ||
| 144965 | 144965 | 35304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | ||
| 144876 | 144876 | 36367 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 143 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39319 | 5995629.61458477 | 2093656.01088528 | 37.7285300690508 | -122.457378871767 | (37.7285300690508, -122.457378871767) | ||
| 144870 | 144870 | 41710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 76 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42158 | 6002439.09088109 | 2096621.84793492 | 37.7370623461114 | -122.43405009550699 | (37.7370623461114, -122.434050095507) |
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");