Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| 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 | |||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | |||||||||
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 170429 | 170429 | 178896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 424 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012763.5947 | 2086999.9849599998 | 37.711223202768295 | -122.397678716599 | (37.7112232027683, -122.397678716599) | |||
| 10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
| 10438 | 10438 | 95023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.711484695229295 | -122.404646681546 | (37.7114846952293, -122.404646681546) | |||
| 11165 | 11165 | 95019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485001 | (37.7116804891797, -122.40514245485) | |||
| 11451 | 11451 | 94993 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.711794905553106 | -122.405106866024 | (37.7117949055531, -122.405106866024) | |||
| 164638 | 164638 | 178898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012665.55046 | 2087301.61111 | 37.7120459484316 | -122.398038730507 | (37.7120459484316, -122.398038730507) | |||
| 12883 | 12883 | 26798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.71215348320929 | -122.406360290051 | (37.7121534832093, -122.406360290051) | |||
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 75548 | 75548 | 214421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 447 Head St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5993467.538240001 | 2088847.90842 | 37.715203764018796 | -122.46450425768101 | (37.7152037640188, -122.464504257681) | |||
| 89041 | 89041 | 84214 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 108371 | 108371 | 40473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
| 54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
| 88383 | 88383 | 50723 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
| 58289 | 58289 | 95775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.6643199995 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) |
| 95446 | 95446 | 47355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Ralston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.942845901 | 2090329.99196799 | 37.7191993003756 | -122.46903830903099 | (37.7191993003756, -122.469038309031) | ||
| 78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 141101 | 141101 | 84825 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 845 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.45248583240802 | (37.7198962296133, -122.452485832408) | |||
| 11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
| 92867 | 92867 | 47347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 752 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | ||
| 54864 | 54864 | 178902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.721497357285706 | -122.401224985361 | (37.7214973572857, -122.401224985361) | |||
| 87438 | 87438 | 46637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
| 103451 | 103451 | 45442 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 681 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44769 | 5993403.20841917 | 2091649.07320251 | 37.7228913782095 | -122.464929921893 | (37.7228913782095, -122.464929921893) | ||
| 143059 | 143059 | 45443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 685 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44774 | 5993415.59875518 | 2091668.68191392 | 37.7229459333721 | -122.464888514787 | (37.7229459333721, -122.464888514787) | ||
| 136058 | 136058 | 178931 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000005.37826 | 2091604.23935 | 37.7231467382161 | -122.44210444775801 | (37.7231467382161, -122.442104447758) | |||
| 175403 | 175403 | 178952 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007251.31205 | 2091779.98256 | 37.7240395689419 | -122.41706906129 | (37.7240395689419, -122.41706906129) | |||
| 120338 | 120338 | 45393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 321 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44757 | 5994154.29510802 | 2092092.46668837 | 37.7241521077919 | -122.462365734931 | (37.7241521077919, -122.462365734931) | ||
| 90954 | 90954 | 40399 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41505 | 5995604.87049652 | 2092238.79242045 | 37.7246373060188 | -122.457361926036 | (37.7246373060188, -122.457361926036) | ||
| 93452 | 93452 | 46779 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44870 | 6001525.5890631 | 2092130.31455081 | 37.724677740092 | -122.43688703011601 | (37.724677740092, -122.436887030116) | ||
| 95071 | 95071 | 46636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 128208 | 128208 | 45397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2001 12:00:00 AM | Permit Number 44207 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | |||
| 115757 | 115757 | 40410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 132 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41511 | 5995166.097552099 | 2092475.68358203 | 37.7252625407548 | -122.458895841519 | (37.7252625407548, -122.458895841519) | ||
| 19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 90511 | 90511 | 36385 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
| 80535 | 80535 | 37888 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | |||
| 118253 | 118253 | 49138 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 127980 | 127980 | 43280 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 731 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43050 | 6009363.88058907 | 2092426.70066476 | 37.725933936273606 | -122.409811838204 | (37.7259339362736, -122.409811838204) | ||
| 78556 | 78556 | 40389 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 80073 | 80073 | 99924 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | |||
| 139511 | 139511 | 37876 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 54 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40157 | 5995677.52008025 | 2092900.60911018 | 37.7264586687243 | -122.45715863937099 | (37.7264586687243, -122.457158639371) | ||
| 30525 | 30525 | 36338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.45733685578699 | (37.7264778306363, -122.457336855787) | ||
| 79215 | 79215 | 36343 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | ||
| 80826 | 80826 | 36411 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.45835062173599 | (37.7273922712597, -122.458350621736) | ||
| 145059 | 145059 | 36395 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 799 FAXON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39328 | 5994869.9 | 2093286.2 | 37.7274709926994 | -122.459978448904 | (37.7274709926994, -122.459978448904) | ||
| 110082 | 110082 | 34095 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 598 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37973 | 5995414.64611355 | 2093305.76310855 | 37.7275560235395 | -122.458096686641 | (37.7275560235395, -122.458096686641) | ||
| 95761 | 95761 | 34097 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
| 114922 | 114922 | 51808 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | Permit Number 48055 | 6015124.97012751 | 2092940.21442791 | 37.727665120823495 | -122.38993182362302 | (37.7276651208235, -122.389931823623) | |||
| 129117 | 129117 | 36349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | ||
| 90653 | 90653 | 36351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39311 | 5995654.83604113 | 2093420.72201256 | 37.727885471049 | -122.45727466612 | (37.727885471049, -122.45727466612) | ||
| 113451 | 113451 | 36352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 115 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39312 | 5995603.96545011 | 2093439.4482819 | 37.7279339670328 | -122.457451880091 | (37.7279339670328, -122.457451880091) | ||
| 118303 | 118303 | 36355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 124 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39313 | 5995662.46280301 | 2093510.57347718 | 37.728132619592294 | -122.45725479763 | (37.7281326195923, -122.45725479763) | ||
| 86335 | 86335 | 36357 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39314 | 5995668.43599177 | 2093556.12271173 | 37.728258029890796 | -122.457237441924 | (37.7282580298908, -122.457237441924) | ||
| 124337 | 124337 | 36359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39315 | 5995616.87742593 | 2093562.88394601 | 37.728273633305996 | -122.45741616982401 | (37.728273633306, -122.457416169824) | ||
| 58952 | 58952 | 36362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.45722008615101 | (37.7283834402433, -122.457220086151) | ||
| 110426 | 110426 | 36364 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 137 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39317 | 5995622.8506175 | 2093608.43320198 | 37.728399043684504 | -122.457398814349 | (37.7283990436845, -122.457398814349) | ||
| 93285 | 93285 | 36366 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39318 | 5995680.445182 | 2093645.04501164 | 37.7285028788434 | -122.45720235583299 | (37.7285028788434, -122.457202355833) | ||
| 144876 | 144876 | 36367 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 143 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39319 | 5995629.61458477 | 2093656.01088528 | 37.7285300690508 | -122.457378871767 | (37.7285300690508, -122.457378871767) | ||
| 146623 | 146623 | 178923 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000952.168380001 | 2093553.63725 | 37.7285532510089 | -122.43897122505899 | (37.7285532510089, -122.438971225059) | |||
| 142640 | 142640 | 43249 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 192 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43037 | 6009141.71758319 | 2093391.4256926998 | 37.72857041385571 | -122.410647941299 | (37.7285704138557, -122.410647941299) | ||
| 53597 | 53597 | 42437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 144402 | 144402 | 36370 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 149 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39320 | 5995639.30235658 | 2093700.91704077 | 37.7286539269724 | -122.45734862821999 | (37.7286539269724, -122.45734862822) | ||
| 81284 | 81284 | 36372 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39321 | 5995693.36220348 | 2093704.91985042 | 37.7286680225798 | -122.457162030727 | (37.7286680225798, -122.457162030727) | ||
| 81043 | 81043 | 36374 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 154 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39322 | 5995692.70135689 | 2093744.11562313 | 37.72877560678 | -122.457167149483 | (37.72877560678, -122.457167149483) | ||
| 140962 | 140962 | 36379 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 163 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39324 | 5995635.21078628 | 2093789.09624801 | 37.728895810822294 | -122.45736914968799 | (37.7288958108223, -122.457369149688) | ||
| 98376 | 98376 | 36381 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 169 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39325 | 5995613.8697915 | 2093829.77764032 | 37.729006286331796 | -122.457445868582 | (37.7290062863318, -122.457445868582) | ||
| 108384 | 108384 | 37868 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40154 | 5996172.53384132 | 2093848.71609655 | 37.7290903602157 | -122.45551590429399 | (37.7290903602157, -122.455515904294) | ||
| 112927 | 112927 | 36383 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 170 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39326 | 5995652.80460516 | 2093867.49462776 | 37.729112084398 | -122.45731399630199 | (37.729112084398, -122.457313996302) | ||
| 80096 | 80096 | 31127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 121 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 5.5x4 | Permit Number 34844 | 5998074.93385537 | 2093867.82881443 | 37.729251820430605 | -122.448940561252 | (37.7292518204306, -122.448940561252) | |
| 91776 | 91776 | 36429 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
| 127996 | 127996 | 36316 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 155 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39293 | 5996114.57806126 | 2093980.3628315 | 37.7294485047064 | -122.455725773063 | (37.7294485047064, -122.455725773063) | ||
| 64942 | 64942 | 178939 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004063.80175 | 2093818.77342 | 37.72945780800921 | -122.42823302485701 | (37.7294578080092, -122.428233024857) | |||
| 145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 99267 | 99267 | 30767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084274995 | -122.39177660646999 | (37.729655084275, -122.39177660647) | ||
| 127685 | 127685 | 32170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 2 | 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) | ||
| 94605 | 94605 | 37878 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355121998 | 37.7297645826714 | -122.45354159093701 | (37.7297645826714, -122.453541590937) | ||
| 112053 | 112053 | 37897 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40168 | 5995914.46450113 | 2094101.71045424 | 37.729770209756296 | -122.45642635192 | (37.7297702097563, -122.45642635192) | ||
| 89273 | 89273 | 36428 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39338 | 5996108.64471019 | 2094137.0690645 | 37.729878441846104 | -122.455757608246 | (37.7298784418461, -122.455757608246) | |||
| 154642 | 154642 | 178945 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 202 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004737.15632 | 2094036.7651400003 | 37.730094441687 | -122.42592068260599 | (37.730094441687, -122.425920682606) | |||
| 93419 | 93419 | 49134 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | |||
| 100030 | 100030 | 42586 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 365 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42663 | 5992564.23479625 | 2094368.49404708 | 37.73030982758711 | -122.46802776610001 | (37.7303098275871, -122.4680277661) | ||
| 90702 | 90702 | 89049 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 344 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51788 | 6009769.0 | 2094043.0 | 37.7303946483927 | -122.408525324962 | (37.7303946483927, -122.408525324962) | ||
| 157170 | 157170 | 178964 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 129 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010537.280619999 | 2094115.27956 | 37.7306361096482 | -122.40587434723 | (37.7306361096482, -122.40587434723) | |||
| 94521 | 94521 | 40418 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 151 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | Permit Number 46528 | 5996223.22474594 | 2094448.33281394 | 37.7307396723187 | -122.455383980912 | (37.7307396723187, -122.455383980912) | ||
| 99037 | 99037 | 40421 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 159 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41519 | 5996206.73591336 | 2094479.35177124 | 37.7308238967874 | -122.455443226068 | (37.7308238967874, -122.455443226068) | ||
| 142190 | 142190 | 40423 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 167 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41520 | 5996186.24380378 | 2094512.6253638 | 37.730914082192896 | -122.45551647416 | (37.7309140821929, -122.45551647416) | ||
| 12065 | 12065 | 108545 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) |
| 143164 | 143164 | 40425 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 175 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41521 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.45558972239401 | (37.7310042675093, -122.455589722394) | ||
| 90596 | 90596 | 36418 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39336 | 5996667.86779385 | 2094605.95309618 | 37.7311979628573 | -122.45385816718701 | (37.7311979628573, -122.453858167187) | ||
| 100670 | 100670 | 40531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41582 | 5993353.73347688 | 2094704.41991722 | 37.7312777588569 | -122.46532277558998 | (37.7312777588569, -122.46532277559) | |||
| 37372 | 37372 | 101729 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 90 Rotteck St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003352.201090001 | 2094564.6464200001 | 37.731465517513 | -122.43074630169501 | (37.731465517513, -122.430746301695) | |||
| 119506 | 119506 | 45484 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3036 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44264 | 5990299.6759109 | 2095068.01075494 | 37.732099485445204 | -122.475907639335 | (37.7320994854452, -122.475907639335) | ||
| 179369 | 179369 | 214414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 659 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997734.91386 | 2094962.2515599998 | 37.732237393940395 | -122.45019488919901 | (37.7322373939404, -122.450194889199) | ||||
| 84586 | 84586 | 42417 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42567 | 6000281.10617536 | 2094927.9398224999 | 37.732288562764104 | -122.441389689923 | (37.7322885627641, -122.441389689923) | ||
| 55073 | 55073 | 214457 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001468.0488 | 2094911.62577 | 37.732311314613106 | -122.43728499800699 | (37.7323113146131, -122.437284998007) | |||
| 156388 | 156388 | 214471 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000292.89042 | 2094938.1792099997 | 37.7323173490585 | -122.441349683656 | (37.7323173490585, -122.441349683656) |
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");