Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 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 | |||||||||
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 3019 | 3019 | 20034 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 3403 | 3403 | 19880 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 3951 | 3951 | 20035 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 4106 | 4106 | 20001 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 4351 | 4351 | 36746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39516 | ||||||||
| 5302 | 5302 | 35167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38700 | ||||||||
| 5325 | 5325 | 40088 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41311 | |||||||||
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 6573 | 6573 | 19697 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY9 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 7527 | 7527 | 20039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 9510 | 9510 | 46857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44926 | |||||||||
| 9515 | 9515 | 19958 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 9562 | 9562 | 19696 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY9 | -3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 10575 | 10575 | 20040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
| 10800 | 10800 | 19957 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 10952 | 10952 | 43297 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2000 12:00:00 AM | Permit Number 43066 | ||||||||
| 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 | ||||||||
| 11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11812 | 11812 | 20044 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 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 | |||||||||
| 12896 | 12896 | 19960 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY41 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 12976 | 12976 | 20042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 13223 | 13223 | 33083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 14604 | 14604 | 19885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 14695 | 14695 | 20043 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 16368 | 16368 | 19956 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 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 | ||||||||
| 67142 | 67142 | 118470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981008.92024 | 2112222.55161 | 37.7786579010228 | -122.50930075514499 | (37.7786579010228, -122.509300755145) | |||
| 67642 | 67642 | 118478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981024.51617 | 2111800.84509 | 37.7775009394111 | -122.509215478972 | (37.7775009394111, -122.509215478972) | |||
| 99492 | 99492 | 110751 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | Permit Number 775489 | 5981042.2 | 2112214.0 | 37.778636382962 | -122.509184994454 | (37.778636382962, -122.509184994454) | ||
| 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) | |||
| 83651 | 83651 | 68577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 139 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32471 | 5981217.74443457 | 2111271.39856875 | 37.7760586259822 | -122.508507736704 | (37.7760586259822, -122.508507736704) | ||
| 50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
| 37553 | 37553 | 87825 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981267.84329 | 2112567.4887599996 | 37.7796202589611 | -122.508430668506 | (37.7796202589611, -122.508430668506) | |
| 46301 | 46301 | 87824 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981268.94768 | 2112581.1831099996 | 37.7796579246713 | -122.50842786485799 | (37.7796579246713, -122.508427864858) | |
| 150585 | 150585 | 56095 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 783 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52001 | 5981348.38409 | 2110404.98623 | 37.7736874110676 | -122.507991510924 | (37.7736874110676, -122.507991510924) | |
| 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) | ||
| 162332 | 162332 | 85242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | 1 | Permit Number 49544 | 5981385.546 | 2104841.9152 | 37.7584150182243 | -122.507450124372 | (37.7584150182243, -122.507450124372) | ||
| 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) | ||
| 187658 | 187658 | 92257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 862 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52706 | 5981411.16308 | 2109852.88199 | 37.7721751933845 | -122.50773337462299 | (37.7721751933845, -122.507733374623) | |
| 149511 | 149511 | 34721 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5535 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38376 | 5981434.12386 | 2111625.14448 | 37.7770426583791 | -122.507785493074 | (37.7770426583791, -122.507785493074) | |
| 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) | |||
| 105081 | 105081 | 36131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1579 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/1998 12:00:00 AM | Permit Number 39226 | 5981546.79724008 | 2104343.49116474 | 37.7570559852656 | -122.50685548584299 | (37.7570559852656, -122.506855485843) | |||
| 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) | |||
| 154522 | 154522 | 118420 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5501 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5981593.2087199995 | 2111630.13422 | 37.7770657300516 | -122.507235548964 | (37.7770657300516, -122.507235548964) | |||
| 170734 | 170734 | 67270 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 539 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1992 12:00:00 AM | 3 | Permit Number 30743 | 5981594.696269999 | 2112052.0019099996 | 37.7782241419477 | -122.50726170878299 | (37.7782241419477, -122.507261708783) | |
| 185931 | 185931 | 118627 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981628.0956 | 2112437.91019 | 37.7792856992778 | -122.50717480668301 | (37.7792856992778, -122.507174806683) | |||
| 131729 | 131729 | 34701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52703 | 5981643.1854 | 2112019.5317 | 37.7781378442384 | -122.507091560706 | (37.7781378442384, -122.507091560706) | |
| 148645 | 148645 | 34700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52703 | 5981644.97521 | 2112008.50675 | 37.7781076783894 | -122.507084551143 | (37.7781076783894, -122.507084551143) | |
| 65153 | 65153 | 50405 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 815 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52709 | 5981666.2240699995 | 2110158.20965 | 37.7730285573555 | -122.506873764155 | (37.7730285573555, -122.506873764155) | |
| 31693 | 31693 | 119100 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5981674.98764 | 2109913.6134599997 | 37.772357483762704 | -122.50682530453399 | (37.7723574837627, -122.506825304534) | |||
| 24853 | 24853 | 47834 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 891 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49787 | 5981681.239030001 | 2109702.6053299997 | 37.7717784851525 | -122.50678802713199 | (37.7717784851525, -122.506788027132) | |
| 9777 | 9777 | 88104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1247 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.763238693975296 | -122.50630313344999 | (37.7632386939753, -122.50630313345) | |||
| 72566 | 72566 | 83831 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1249-1249 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 3 | 4x9 | Permit Number 50162 | 5981782.7749 | 2106603.6182 | 37.7632755418665 | -122.50620698388599 | (37.7632755418665, -122.506206983886) | |
| 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) | |||
| 189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
| 56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
| 68693 | 68693 | 118431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | |||
| 131523 | 131523 | 118430 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5400 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5981830.664890001 | 2111695.69394 | 37.7772597209712 | -122.506418991145 | (37.7772597209712, -122.506418991145) | |||
| 170362 | 170362 | 118429 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | |||
| 185018 | 185018 | 118428 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5400 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5981858.846609999 | 2111695.90062 | 37.7772619476301 | -122.50632151854099 | (37.7772619476301, -122.506321518541) | |||
| 43146 | 43146 | 118427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5981873.51616 | 2111696.39703 | 37.7772641742522 | -122.506270809551 | (37.7772641742522, -122.506270809551) | |||
| 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) | ||
| 160579 | 160579 | 68561 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 531 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32451 | 5981904.26903 | 2112120.67838 | 37.7784309363863 | -122.50619589543699 | (37.7784309363863, -122.506195895437) | |
| 168261 | 168261 | 68777 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | 4 | Permit Number 32707 | 5981911.30335 | 2111941.60843 | 37.777939677133205 | -122.506158280277 | (37.7779396771332, -122.506158280277) | |
| 148211 | 148211 | 68564 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32454 | 5981914.34705 | 2111854.14558 | 37.7776997090602 | -122.506141264398 | (37.7776997090602, -122.506141264398) | |
| 147767 | 147767 | 119067 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981914.59302 | 2111829.39054 | 37.7776317534825 | -122.506138577528 | (37.7776317534825, -122.506138577528) | |||
| 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) | ||
| 45509 | 45509 | 68562 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 5 | Permit Number 32452 | 5981948.24889 | 2112111.86912 | 37.7784093377083 | -122.50604310187401 | (37.7784093377083, -122.506043101874) | |
| 33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
| 52139 | 52139 | 118798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 810 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5982020.13723 | 2110219.13712 | 37.7732166816615 | -122.50565407298599 | (37.7732166816615, -122.505654072986) | |||
| 186216 | 186216 | 250997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 415 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982186.75835 | 2112941.64621 | 37.7807016980586 | -122.505279538125 | (37.7807016980586, -122.505279538125) | |||
| 107860 | 107860 | 81964 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 455 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 50002 | 5982191.84204192 | 2112715.55923715 | 37.780081229053 | -122.505245190233 | (37.780081229053, -122.505245190233) | ||
| 30707 | 30707 | 250995 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 453 44th Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982194.00965 | 2112744.27477 | 37.780160200984604 | -122.505239820464 | (37.7801602009846, -122.505239820464) | |||
| 46117 | 46117 | 68549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3 | Permit Number 32436 | 5982217.68828 | 2112054.92779 | 37.7782688503059 | -122.50510680493 | (37.7782688503059, -122.50510680493) | |
| 26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
| 55330 | 55330 | 37078 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.761951943280394 | -122.50380580728 | (37.7619519432804, -122.50380580728) | |
| 171448 | 171448 | 83913 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1659 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50155 | 5982499.5096 | 2103826.5104 | 37.7556925599446 | -122.503522416925 | (37.7556925599446, -122.503522416925) | |
| 34490 | 34490 | 68541 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 6 | Permit Number 32425 | 5982517.9924800005 | 2112299.68917 | 37.778958557712606 | -122.504086094205 | (37.7789585577126, -122.504086094205) | |
| 186975 | 186975 | 119011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982518.7729400005 | 2112266.03771 | 37.778866206576794 | -122.504080901039 | (37.7788662065768, -122.504080901039) | |||
| 181943 | 181943 | 119012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982519.09297 | 2112280.9796700003 | 37.778907251633704 | -122.50408090101801 | (37.7789072516337, -122.504080901018) | |||
| 105625 | 105625 | 68543 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 519 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32427 | 5982523.73467 | 2112217.34809 | 37.7787328109508 | -122.504060129291 | (37.7787328109508, -122.504060129291) | ||
| 183324 | 183324 | 68544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32430 | 5982530.7498 | 2111896.5441900003 | 37.777852390021 | -122.504012093664 | (37.777852390021, -122.504012093664) | |
| 163678 | 163678 | 81982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 563 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49998 | 5982533.65676 | 2111927.12728 | 37.7779365331701 | -122.504004303472 | (37.7779365331701, -122.504004303472) | |
| 54483 | 54483 | 119001 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 623 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982546.8216699995 | 2111525.4630400003 | 37.7768344548721 | -122.503929004913 | (37.7768344548721, -122.503929004913) |
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");