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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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) | ||
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) | |||
59474 | 59474 | 119000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 623 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982547.10807 | 2111503.78055 | 37.776774937935 | -122.503926407866 | (37.776774937935, -122.503926407866) | |||
94759 | 94759 | 47444 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 651 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45354 | 5982550.9590229 | 2111342.50779778 | 37.7763323565324 | -122.503901138971 | (37.7763323565324, -122.503901138971) | |||
121137 | 121137 | 68542 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 514 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32426 | 5982569.023547499 | 2112276.16618805 | 37.7788969713665 | -122.503907817569 | (37.7788969713665, -122.503907817569) | ||
136410 | 136410 | 82431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 650 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52680 | 5982600.56645 | 2111346.95635 | 37.7763474878375 | -122.503729865488 | (37.7763474878375, -122.503729865488) | |
166287 | 166287 | 55604 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 658 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 1 | Permit Number 773340 | 5982601.78539 | 2111293.4380900003 | 37.7762006139918 | -122.50372168450501 | (37.7762006139918, -122.503721684505) | ||
61940 | 61940 | 92237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52681 | 5982614.54862 | 2110914.94505 | 37.7751621329201 | -122.503649497706 | (37.7751621329201, -122.503649497706) | |
54349 | 54349 | 79894 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4119 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2001 12:00:00 AM | 7 | 5982716.5012300005 | 2113074.1195 | 37.78109658773229 | -122.503456745272 | (37.7810965877323, -122.503456745272) | ||
157734 | 157734 | 46392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2474 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 1 | Permit Number 44624 | 5982733.0582 | 2098295.9927 | 37.7405210225717 | -122.502305471655 | (37.7405210225717, -122.502305471655) | |
155742 | 155742 | 40221 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1463 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 4 | Permit Number 41400 | 5982763.9993 | 2105167.6847 | 37.7593905919599 | -122.502707013206 | (37.7593905919599, -122.502707013206) | ||
171943 | 171943 | 184308 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1555 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982786.0012 | 2104528.3348 | 37.7576364108681 | -122.502583598561 | (37.7576364108681, -122.502583598561) | |||
70691 | 70691 | 184573 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1731 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982827.3086 | 2103329.3402 | 37.754346736395995 | -122.502352009826 | (37.754346736396, -122.502352009826) | |||
26539 | 26539 | 184576 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1735 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982829.6776 | 2103308.6964 | 37.75429019350779 | -122.50234228965799 | (37.7542901935078, -122.502342289658) | |||
24589 | 24589 | 184585 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1743 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982830.016 | 2103255.9026 | 37.754145256427606 | -122.50233721253099 | (37.7541452564276, -122.502337212531) | |||
67159 | 67159 | 92236 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 551 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52679 | 5982837.48707 | 2112035.40062 | 37.7782516820937 | -122.502961282193 | (37.7782516820937, -122.502961282193) | |
57130 | 57130 | 92234 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52677 | 5982879.44866 | 2112163.93194 | 37.778607057674996 | -122.50282564106199 | (37.778607057675, -122.502825641062) |
171006 | 171006 | 72283 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 779 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982894.68666 | 2110493.65125 | 37.774021849099704 | -122.502649263154 | (37.7740218490997, -122.502649263154) | ||
30074 | 30074 | 47440 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45351 | 5982914.18523 | 2109947.95579 | 37.7725246733221 | -122.50254141771099 | (37.7725246733221, -122.502541417711) | |
109056 | 109056 | 51769 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982925.7859 | 2104266.232 | 37.7569249636711 | -122.50208077934201 | (37.7569249636711, -122.502080779342) |
40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
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) | ||
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) | ||
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) |
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");