Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 85021 | 85021 | 33758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 842 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37811 | 5981102.7142707 | 2109980.14676383 | 37.77250644827279 | -122.508809756644 | (37.7725064482728, -122.508809756644) | |||
| 32419 | 32419 | 89550 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 5539 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981409.7822199995 | 2111623.31383 | 37.7770361978186 | -122.50786956100401 | (37.7770361978186, -122.507869561004) | ||
| 135919 | 135919 | 85241 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | 1 | Permit Number 49544 | 5981367.2124 | 2104841.304 | 37.7584122600662 | -122.507513483633 | (37.7584122600662, -122.507513483633) | ||
| 62539 | 62539 | 183257 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981497.12 | 2105917.3408 | 37.7613744008584 | -122.50714403834999 | (37.7613744008584, -122.50714403835) | |||
| 45174 | 45174 | 184179 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1607 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981558.7987 | 2104123.9871 | 37.7564539963073 | -122.50679770031401 | (37.7564539963073, -122.506797700314) | |||
| 177635 | 177635 | 118425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981790.15899 | 2111638.01027 | 37.7770989536906 | -122.506554832582 | (37.7770989536906, -122.506554832582) | |||
| 111879 | 111879 | 68559 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 511 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32449 | 5981895.88613984 | 2112278.88841287 | 37.778864841011796 | -122.50623662905001 | (37.7788648410118, -122.50623662905) | ||
| 100869 | 100869 | 68558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 508 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32448 | 5981947.34598034 | 2112294.26948127 | 37.7789101022126 | -122.50605975288799 | (37.7789101022126, -122.506059752888) | ||
| 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) | ||
| 136211 | 136211 | 183297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1279 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5983033.5705 | 2106401.2294 | 37.762793394201005 | -122.501865989484 | (37.762793394201, -122.501865989484) | |||
| 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) | ||
| 139180 | 139180 | 34817 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 76643 | 76643 | 184445 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2143 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983233.2456 | 2100550.728 | 37.746741282577894 | -122.500742738194 | (37.7467412825779, -122.500742738194) | |||
| 25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
| 24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
| 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) | ||
| 178771 | 178771 | 184275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1535 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983712.9456 | 2104682.7299 | 37.7581147632448 | -122.499389306755 | (37.7581147632448, -122.499389306755) | |||
| 171595 | 171595 | 184311 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1563 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983718.446 | 2104512.8306 | 37.757648590113604 | -122.49935772939301 | (37.7576485901136, -122.499357729393) | |||
| 164030 | 164030 | 184601 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1763 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983763.5526 | 2103165.7132 | 37.753952428223 | -122.49910220128099 | (37.753952428223, -122.499102201281) | |||
| 188640 | 188640 | 184708 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984043.3081 | 2104133.2508 | 37.7566254238897 | -122.498206207845 | (37.7566254238897, -122.498206207845) | |||
| 136125 | 136125 | 183176 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2446 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983967.9959 | 2098507.985 | 37.7411755776416 | -122.498051254673 | (37.7411755776416, -122.498051254673) | |||
| 135632 | 135632 | 183177 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2450 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983968.3342 | 2098473.4815 | 37.741080860242896 | -122.498047537544 | (37.7410808602429, -122.498047537544) | |||
| 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) | ||
| 157753 | 157753 | 184578 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1726 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984111.7886 | 2103392.1174 | 37.7545944930516 | -122.49791465490499 | (37.7545944930516, -122.497914654905) | |||
| 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) | |
| 45248 | 45248 | 184305 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984382.3056 | 2104532.0637 | 37.757740324240295 | -122.497063286444 | (37.7577403242403, -122.497063286444) | |||
| 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) | |
| 82888 | 82888 | 69140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2639 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33173 | 5984275.37028508 | 2097213.25013079 | 37.737638602389396 | -122.496892944046 | (37.7376386023894, -122.496892944046) | ||
| 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) |
| 51415 | 51415 | 182275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376001 | (37.7591168373077, -122.49474304376) | |||
| 124447 | 124447 | 32174 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 1 | 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) | ||
| 18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 152743 | 152743 | 182409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1521 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985259.3217 | 2104833.2809 | 37.7586187384667 | -122.494052446724 | (37.7586187384667, -122.494052446724) | |||
| 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) |
| 60297 | 60297 | 182224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1599 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985275.2811 | 2104383.8376 | 37.7573856255252 | -122.493964129886 | (37.7573856255252, -122.493964129886) | |||
| 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) | |
| 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) | |
| 143293 | 143293 | 43850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2674 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43472 | 5985253.1482 | 2097047.7977 | 37.7372415601551 | -122.493500160872 | (37.7372415601551, -122.493500160872) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) |
| 34748 | 34748 | 43826 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2657 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43454 | 5985520.0574 | 2097206.122 | 37.7376918862353 | -122.49258900314899 | (37.7376918862353, -122.492589003149) | |
| 39935 | 39935 | 43837 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2707 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43459 | 5985531.9387 | 2096872.5005 | 37.736776545221204 | -122.492523362027 | (37.7367765452212, -122.492523362027) | |
| 81224 | 81224 | 43843 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2729 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43465 | 5985530.78244018 | 2096757.50782257 | 37.736460738343204 | -122.49251889363501 | (37.7364607383432, -122.492518893635) | ||
| 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) | |
| 183024 | 183024 | 185612 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2101 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985702.4651 | 2100891.7117 | 37.7478221885491 | -122.492229646849 | (37.7478221885491, -122.492229646849) | |||
| 136915 | 136915 | 95445 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2201 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 767307 | 5985726.3556 | 2100198.6842 | 37.7459207192562 | -122.492096016775 | (37.7459207192562, -122.492096016775) |
| 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) |
| 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) |
| 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) |
| 111978 | 111978 | 43863 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 1 | 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) | ||
| 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) |
| 59178 | 59178 | 182739 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1755 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985933.2204 | 2103292.5347 | 37.7544276818477 | -122.491608417213 | (37.7544276818477, -122.491608417213) | |||
| 188651 | 188651 | 185046 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2767 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985833.5409 | 2096575.126 | 37.7359776633696 | -122.491458724203 | (37.7359776633696, -122.491458724203) | |||
| 166127 | 166127 | 185265 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2616 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985852.1135 | 2097401.8704 | 37.7382487690483 | -122.491455345913 | (37.7382487690483, -122.491455345913) | |||
| 10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
| 13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
| 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) |
| 10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
| 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) | |
| 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) | |||
| 24861 | 24861 | 182367 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986186.5787 | 2104935.6262 | 37.758953963431 | -122.49085314669901 | (37.758953963431, -122.490853146699) | |||
| 33475 | 33475 | 37204 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1575 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 2 | Permit Number 39771 | 5986202.8143 | 2104523.3582 | 37.75782293745029 | -122.49076666265499 | (37.7578229374503, -122.490766662655) | |
| 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) | |
| 47132 | 47132 | 182844 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1819 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986260.4974 | 2102849.4662 | 37.7532302577495 | -122.49044403080799 | (37.7532302577495, -122.490444030808) | |||
| 66440 | 66440 | 182858 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1826 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986304.0542 | 2102796.2301 | 37.7530866298604 | -122.49028948878201 | (37.7530866298604, -122.490289488782) | |||
| 107031 | 107031 | 58127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | Permit Number 29453 | 5986440.58306347 | 2106473.88273378 | 37.763192426611795 | -122.490087838111 | (37.7631924266118, -122.490087838111) | ||
| 32121 | 32121 | 66333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 6 | Permit Number 29454 | 5986445.8362 | 2106470.4022 | 37.763183176794705 | -122.490069413492 | (37.7631831767947, -122.490069413492) | |
| 74048 | 74048 | 182548 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986518.7594 | 2105601.9213 | 37.760802826429796 | -122.489753326371 | (37.7608028264298, -122.489753326371) | |||
| 135959 | 135959 | 95525 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986606.408 | 2107060.1496 | 37.764811835149295 | -122.489557426261 | (37.7648118351493, -122.489557426261) |
| 179376 | 179376 | 182553 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2545 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986583.8092 | 2105694.5347 | 37.7610609151296 | -122.48953516150299 | (37.7610609151296, -122.489535161503) | |||
| 51079 | 51079 | 182554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986607.6975 | 2105696.3722 | 37.7610673549786 | -122.489452678447 | (37.7610673549786, -122.489452678447) | |||
| 167537 | 167537 | 183513 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2538 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986470.4078 | 2097964.8461 | 37.739830662789004 | -122.489359001455 | (37.739830662789, -122.489359001455) | |||
| 35810 | 35810 | 92326 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52758 | 5986769.8307 | 2106099.7914 | 37.7621844965801 | -122.488921594092 | (37.7621844965801, -122.488921594092) |
| 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) |
| 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) |
| 136725 | 136725 | 92333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2182 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52765 | 5986695.3951 | 2100425.9019 | 37.7466011963621 | -122.488761954977 | (37.7466011963621, -122.488761954977) |
| 29283 | 29283 | 95438 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.746478551124504 | -122.48874631833598 | (37.7464785511245, -122.488746318336) |
| 51429 | 51429 | 69307 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1522 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 2 | Permit Number 33386 | 5986858.656 | 2104872.1171 | 37.758818824109 | -122.48852415134701 | (37.758818824109, -122.488524151347) | |
| 166830 | 166830 | 181326 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2020 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986900.7227 | 2098966.9139 | 37.742607185371206 | -122.48794478148399 | (37.7426071853712, -122.487944781484) | |||
| 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) |
| 12005 | 12005 | 93421 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2014 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986933.5496 | 2098966.2371 | 37.7426072419271 | -122.487831227416 | (37.7426072419271, -122.487831227416) | ||
| 68429 | 68429 | 185590 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2086 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986989.5241 | 2101082.1958 | 37.748420363683294 | -122.487793111063 | (37.7484203636833, -122.487793111063) | |||
| 46491 | 46491 | 38115 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1342 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | 5 | Permit Number 40279 | 5987120.6367 | 2106124.4711 | 37.7622727278914 | -122.487710118761 | (37.7622727278914, -122.487710118761) | |
| 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) | |
| 99434 | 99434 | 51238 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1342 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2004 12:00:00 AM | Permit Number 47609 | 5987125.87683066 | 2106129.95545111 | 37.762288092049296 | -122.487692398291 | (37.7622880920493, -122.487692398291) | |||
| 52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
| 121675 | 121675 | 53179 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2610@ 27th Ave Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51476 | 5987391.86463584 | 2114656.62979524 | 37.785715458645704 | -122.487398814258 | (37.7857154586457, -122.487398814258) | ||
| 80735 | 80735 | 48847 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 211@ Lake St 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46061 | 5987400.97577089 | 2114545.21286522 | 37.785410070991205 | -122.487359105809 | (37.7854100709912, -122.487359105809) | |||
| 11411 | 11411 | 93457 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5987093.9615 | 2098905.6596 | 37.74245026783021 | -122.487272128606 | (37.7424502678302, -122.487272128606) | ||
| 24750 | 24750 | 182725 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1734 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987217.2069 | 2103447.5916 | 37.7549283802803 | -122.487179505586 | (37.7549283802803, -122.487179505586) | |||
| 12156 | 12156 | 86038 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1261 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987366.2761 | 2106684.0781 | 37.7638235791025 | -122.486901653076 | (37.7638235791025, -122.486901653076) | ||
| 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) | |
| 13001 | 13001 | 93459 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1901X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987294.6457 | 2098913.1049 | 37.742482411351396 | -122.486578778111 | (37.7424824113514, -122.486578778111) | ||
| 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) |
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");