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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53597 | 53597 | 42437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 53614 | 53614 | 65608 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.729507538818105 | -122.42525182613899 | (37.7295075388181, -122.425251826139) | ||
| 53715 | 53715 | 72507 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1996 12:00:00 AM | 6 | 5988189.7462 | 2100767.6803 | 37.747626723008295 | -122.48361976345801 | (37.7476267230083, -122.483619763458) | ||
| 53792 | 53792 | 36410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.45835062173599 | (37.7273922712597, -122.458350621736) | ||
| 53793 | 53793 | 33345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | ||
| 54613 | 54613 | 43848 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2634 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43470 | 5985245.7192 | 2097273.3217 | 37.7378603541939 | -122.493542458198 | (37.7378603541939, -122.493542458198) | |
| 55722 | 55722 | 39388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 414 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.745062524724204 | -122.43162276019501 | (37.7450625247242, -122.431622760195) | ||
| 56036 | 56036 | 42854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2471 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42783 | 5987340.671 | 2098461.3118 | 37.74124459004229 | -122.486386476099 | (37.7412445900423, -122.486386476099) | |
| 56274 | 56274 | 45450 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 56362 | 56362 | 69494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 368 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33617 | 5999712.35805 | 2091715.6264799999 | 37.7234358783342 | -122.443125353647 | (37.7234358783342, -122.443125353647) | |
| 56684 | 56684 | 44186 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 792 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45643 | 6004083.1428 | 2110821.1912 | 37.7761435523821 | -122.429378138275 | (37.7761435523821, -122.429378138275) |
| 57263 | 57263 | 65499 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.48374245837299 | (37.7446414773793, -122.483742458373) | |
| 57315 | 57315 | 92291 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2541 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52737 | 5989837.8157 | 2098042.3571 | 37.7402394868641 | -122.47772171282601 | (37.7402394868641, -122.477721712826) |
| 57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
| 58060 | 58060 | 46783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54062 | 6002335.14709 | 2093516.37756 | 37.7285295350115 | -122.43418753503 | (37.7285295350115, -122.43418753503) |
| 58289 | 58289 | 95775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.6643199995 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) |
| 58672 | 58672 | 58722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | ||
| 58712 | 58712 | 46802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.763524599 | 2095973.46470501 | 37.7348144532504 | -122.46228249422701 | (37.7348144532504, -122.462282494227) | ||
| 58719 | 58719 | 47693 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | ||
| 58952 | 58952 | 36362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.45722008615101 | (37.7283834402433, -122.457220086151) | ||
| 59112 | 59112 | 40021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.73523191912879 | -122.387929152323 | (37.7352319191288, -122.387929152323) | |
| 59501 | 59501 | 95117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54044 | 6002203.8888 | 2093301.19707 | 37.7279312475122 | -122.43462592124399 | (37.7279312475122, -122.434625921244) |
| 60519 | 60519 | 92488 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2432 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52859 | 5988420.575 | 2098331.0194 | 37.740949727843706 | -122.482643050711 | (37.7409497278437, -122.482643050711) |
| 60558 | 60558 | 72752 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 2 | 5988097.7754 | 2104798.077 | 37.758687755802995 | -122.484233325891 | (37.758687755803, -122.484233325891) | ||
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 61952 | 61952 | 44806 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 2 | Permit Number 43901 | 5987417.062999999 | 2106562.4256 | 37.7634925157287 | -122.486717065387 | (37.7634925157287, -122.486717065387) | |
| 62412 | 62412 | 71226 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987603.3648 | 2099853.8795 | 37.745083520509894 | -122.485580358953 | (37.7450835205099, -122.485580358953) | ||
| 62988 | 62988 | 92393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2223 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52798 | 5985729.7695 | 2100081.3311 | 37.745598698912204 | -122.49207557319401 | (37.7455986989122, -122.492075573194) |
| 63096 | 63096 | 71170 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2127 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 8 | 5987570.8389 | 2100801.7844 | 37.747684319575 | -122.485762384494 | (37.747684319575, -122.485762384494) | ||
| 63241 | 63241 | 73536 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | ||
| 63659 | 63659 | 38558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.735249514063895 | -122.38798439240601 | (37.7352495140639, -122.387984392406) | ||
| 63938 | 63938 | 64516 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 709 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 15 | Permit Number 25397 | 6000497.1651 | 2111433.2992 | 37.7776205716937 | -122.441826907997 | (37.7776205716937, -122.441826907997) | |
| 66194 | 66194 | 43721 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.718160841718394 | -122.45775999315399 | (37.7181608417184, -122.457759993154) | ||
| 67347 | 67347 | 92397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985786.098999999 | 2099670.3819 | 37.7444736358369 | -122.491850548624 | (37.7444736358369, -122.491850548624) |
| 68046 | 68046 | 71314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 530 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2012 12:00:00 AM | 2 | Permit Number 769252 | 6003477.6405 | 2090266.5364299999 | 37.7196709718096 | -122.43000614527399 | (37.7196709718096, -122.430006145274) | |
| 68675 | 68675 | 72444 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1733 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | 7 | 5999558.0145 | 2110143.3213 | 37.7740250637938 | -122.444982979337 | (37.7740250637938, -122.444982979337) | ||
| 69277 | 69277 | 43352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4184 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | ||
| 69989 | 69989 | 92394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.8059 | 2099633.6824 | 37.7443729686632 | -122.491841945332 | (37.7443729686632, -122.491841945332) |
| 70066 | 70066 | 96023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767664 | 6007549.8611 | 2113603.1249 | 37.783977731681496 | -122.417583010796 | (37.7839777316815, -122.417583010796) |
| 70235 | 70235 | 79414 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2635 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52810 | 5984897.7294 | 2097238.629 | 37.7377447344094 | -122.49474305383 | (37.7377447344094, -122.49474305383) |
| 70310 | 70310 | 43849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43471 | 5985246.7805 | 2097245.1976 | 37.73778319502121 | -122.49353671716999 | (37.7377831950212, -122.49353671717) | |
| 70605 | 70605 | 83551 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1430 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52747 | 5989003.7874 | 2105594.4433 | 37.7609270735028 | -122.481158272381 | (37.7609270735028, -122.481158272381) |
| 71523 | 71523 | 92404 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1545 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52803 | 5985265.6119 | 2104693.7127 | 37.7582358909523 | -122.494020406574 | (37.7582358909523, -122.494020406574) |
| 71730 | 71730 | 31304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | |
| 71955 | 71955 | 34634 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1334 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2006 12:00:00 AM | 2 | Permit Number 48747 | 5988049.813999999 | 2106208.6368 | 37.762557976115104 | -122.48450265773701 | (37.7625579761151, -122.484502657737) | |
| 72111 | 72111 | 69039 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33045 | 5984314.5522 | 2105205.1639 | 37.759584498582896 | -122.497347291362 | (37.7595844985829, -122.497347291362) | |
| 73029 | 73029 | 61076 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2611 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 1 | Permit Number 20913 | 5999537.3607 | 2113600.286 | 37.783515821739705 | -122.445303028393 | (37.7835158217397, -122.445303028393) | |
| 73741 | 73741 | 37222 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2075 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39786 | 5986006.8021 | 2101124.4403 | 37.748478985005896 | -122.49119440423401 | (37.7484789850059, -122.491194404234) | |
| 74008 | 74008 | 70886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2145 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 13 | 5997606.572000001 | 2109869.8792 | 37.77316269418171 | -122.45171358914699 | (37.7731626941817, -122.451713589147) | ||
| 74407 | 74407 | 95447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 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 767309 | 5985770.3096 | 2100149.6093 | 37.745788542103206 | -122.49194041962099 | (37.7457885421032, -122.491940419621) |
| 74745 | 74745 | 31301 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | |
| 75226 | 75226 | 34636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45216 | 5988080.2573 | 2105318.5059 | 37.760115692139394 | -122.48433207977399 | (37.7601156921394, -122.484332079774) | |
| 75758 | 75758 | 47310 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | ||
| 76367 | 76367 | 45053 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2275 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43938 | 5988225.1228 | 2099842.9977 | 37.7450898488188 | -122.483429658025 | (37.7450898488188, -122.483429658025) | |
| 76549 | 76549 | 44797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 0 | Permit Number 43891 | 5989264.78401364 | 2107125.07259505 | 37.7651449362762 | -122.48036764782499 | (37.7651449362762, -122.480367647825) | |
| 76635 | 76635 | 38116 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40280 | 5987121.6044 | 2106101.731 | 37.7622103462776 | -122.487705101187 | (37.7622103462776, -122.487705101187) | |
| 76820 | 76820 | 66242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29340 | 5997754.61642905 | 2090213.33999682 | 37.7191991265322 | -122.449784665644 | (37.7191991265322, -122.449784665644) | ||
| 77341 | 77341 | 33704 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 196 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | ||
| 77360 | 77360 | 43354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43105 | 6002331.77416149 | 2104155.95516802 | 37.757743138206 | -122.434959796908 | (37.757743138206, -122.434959796908) | ||
| 77370 | 77370 | 37268 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 6 | 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) | ||
| 77502 | 77502 | 42394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 531 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42554 | 5997433.46765796 | 2095082.84468997 | 37.732551258555105 | -122.451245745641 | (37.7325512585551, -122.451245745641) | ||
| 77516 | 77516 | 63176 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1438 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23713 | 5992757.94867175 | 2105669.22551201 | 37.7613499376947 | -122.468179830058 | (37.7613499376947, -122.468179830058) | ||
| 77553 | 77553 | 64920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2320 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | Permit Number 25948 | 5991486.61980938 | 2099663.95831255 | 37.7447875370964 | -122.47213903609502 | (37.7447875370964, -122.472139036095) | ||
| 77608 | 77608 | 64036 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24793 | 6008741.54974036 | 2096719.77289509 | 37.7376868940515 | -122.41226649546302 | (37.7376868940515, -122.412266495463) | ||
| 77678 | 77678 | 50789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | ||
| 77817 | 77817 | 67647 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1980 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31246 | 6013237.51927358 | 2096157.49523352 | 37.736394256512206 | -122.39668225739901 | (37.7363942565122, -122.396682257399) | ||
| 77858 | 77858 | 40258 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3502 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 10 | Permit Number 41417 | 6006132.27744777 | 2102027.63127436 | 37.7521143101544 | -122.421664902947 | (37.7521143101544, -122.421664902947) | |
| 77887 | 77887 | 38952 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 77910 | 77910 | 50059 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46789 | 6002684.4080652 | 2104459.13376981 | 37.758595609838096 | -122.433761913311 | (37.7585956098381, -122.433761913311) | ||
| 77921 | 77921 | 41587 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2000 12:00:00 AM | Permit Number 42095 | 6000324.11613416 | 2101399.22119137 | 37.750059618615495 | -122.441705249653 | (37.7500596186155, -122.441705249653) | ||
| 77960 | 77960 | 68492 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1863 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32367 | 5993733.23917615 | 2102822.62397698 | 37.7535901848349 | -122.464600030151 | (37.7535901848349, -122.464600030151) | ||
| 78018 | 78018 | 45189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 80 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44032 | 6009648.85827888 | 2099848.14474258 | 37.7463275924044 | -122.409350189836 | (37.7463275924044, -122.409350189836) | ||
| 78150 | 78150 | 64131 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 619 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 24902 | 6002577.32467051 | 2098854.14366792 | 37.743199557291 | -122.433731658795 | (37.743199557291, -122.433731658795) | ||
| 78236 | 78236 | 43735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711003 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | ||
| 78275 | 78275 | 61292 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 513 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23291 | 6007551.81435287 | 2097267.45931552 | 37.739123888071205 | -122.41641877514601 | (37.7391238880712, -122.416418775146) | ||
| 78342 | 78342 | 43353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4184 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | ||
| 78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 78517 | 78517 | 50077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2662 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46809 | 5991463.01210611 | 2097302.86781432 | 37.7383032204594 | -122.472048604289 | (37.7383032204594, -122.472048604289) | ||
| 78556 | 78556 | 40389 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 78741 | 78741 | 47278 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45225 | 6010323.37047205 | 2103961.60067533 | 37.7576600010286 | -122.40730772564699 | (37.7576600010286, -122.407307725647) | |
| 78748 | 78748 | 39753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 78757 | 78757 | 65245 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1106 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28039 | 6009173.38165211 | 2102703.44295541 | 37.7541409539447 | -122.411195999264 | (37.7541409539447, -122.411195999264) | ||
| 78862 | 78862 | 65551 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 289 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28450 | 5995479.90221927 | 2097471.34821385 | 37.7389974556715 | -122.458172454258 | (37.7389974556715, -122.458172454258) | ||
| 78957 | 78957 | 49137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 79015 | 79015 | 32921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
| 79056 | 79056 | 39135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 825 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40814 | 6007381.77493134 | 2102503.74166558 | 37.7534919799027 | -122.417377678845 | (37.7534919799027, -122.417377678845) | ||
| 79137 | 79137 | 63845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24538 | 6008805.48916661 | 2096845.15100597 | 37.7380347427312 | -122.41205428341499 | (37.7380347427312, -122.412054283415) | ||
| 79215 | 79215 | 36343 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | ||
| 79351 | 79351 | 50276 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46979 | 6004285.87067198 | 2095713.64445309 | 37.734673261546504 | -122.42760025785401 | (37.7346732615465, -122.427600257854) | ||
| 79418 | 79418 | 37690 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 562 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40078 | 6007845.87669797 | 2104655.5935128 | 37.759426574444106 | -122.415925080154 | (37.7594265744441, -122.415925080154) | ||
| 79484 | 79484 | 62930 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 7 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23311 | 6007219.07323891 | 2097777.61404541 | 37.7405059423525 | -122.417605393857 | (37.7405059423525, -122.417605393857) | ||
| 79577 | 79577 | 32850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 743 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2006 12:00:00 AM | Permit Number 37201 | 6001607.63275994 | 2102018.09259502 | 37.751831939335204 | -122.437311094932 | (37.7518319393352, -122.437311094932) | ||
| 79623 | 79623 | 62851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/1986 12:00:00 AM | 6008695.79989615 | 2098007.34632384 | 37.7412197219886 | -122.412515664848 | (37.7412197219886, -122.412515664848) | |||
| 79778 | 79778 | 63421 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 216 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 24005 | 6008985.00081085 | 2097389.20642275 | 37.7395386707954 | -122.411472046568 | (37.7395386707954, -122.411472046568) | ||
| 79803 | 79803 | 43861 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
| 79817 | 79817 | 49121 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46253 | 5995746.37464462 | 2094397.74678667 | 37.730573402709396 | -122.457028858359 | (37.7305734027094, -122.457028858359) | ||
| 79831 | 79831 | 64805 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1425 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25804 | 6003950.13397491 | 2099979.34039052 | 37.7463668898084 | -122.429065055592 | (37.7463668898084, -122.429065055592) | ||
| 80019 | 80019 | 69528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 3 | Permit Number 37970 | 5995596.79094541 | 2093236.22494982 | 37.7273755525392 | -122.457461985557 | (37.7273755525392, -122.457461985557) |
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");