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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77348 | 77348 | 50549 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 77360 | 77360 | 43354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43105 | 6002331.77416149 | 2104155.95516802 | 37.757743138206 | -122.434959796908 | (37.757743138206, -122.434959796908) | ||
| 77370 | 77370 | 37268 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 77426 | 77426 | 91342 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 77502 | 77502 | 42394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 531 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42554 | 5997433.46765796 | 2095082.84468997 | 37.732551258555105 | -122.451245745641 | (37.7325512585551, -122.451245745641) | ||
| 77516 | 77516 | 63176 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1438 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23713 | 5992757.94867175 | 2105669.22551201 | 37.7613499376947 | -122.468179830058 | (37.7613499376947, -122.468179830058) | ||
| 77549 | 77549 | 36014 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 77553 | 77553 | 64920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2320 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | Permit Number 25948 | 5991486.61980938 | 2099663.95831255 | 37.7447875370964 | -122.47213903609502 | (37.7447875370964, -122.472139036095) | ||
| 77608 | 77608 | 64036 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24793 | 6008741.54974036 | 2096719.77289509 | 37.7376868940515 | -122.41226649546302 | (37.7376868940515, -122.412266495463) | ||
| 77678 | 77678 | 50789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | ||
| 77792 | 77792 | 44459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 700 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2001 12:00:00 AM | Permit Number 43780 | 5992847.73856031 | 2102166.91818183 | 37.751738698088296 | -122.46761457722201 | (37.7517386980883, -122.467614577222) | |||
| 77817 | 77817 | 67647 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1980 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31246 | 6013237.51927358 | 2096157.49523352 | 37.736394256512206 | -122.39668225739901 | (37.7363942565122, -122.396682257399) | ||
| 77887 | 77887 | 38952 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 77910 | 77910 | 50059 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46789 | 6002684.4080652 | 2104459.13376981 | 37.758595609838096 | -122.433761913311 | (37.7585956098381, -122.433761913311) | ||
| 77921 | 77921 | 41587 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2000 12:00:00 AM | Permit Number 42095 | 6000324.11613416 | 2101399.22119137 | 37.750059618615495 | -122.441705249653 | (37.7500596186155, -122.441705249653) | ||
| 77960 | 77960 | 68492 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1863 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32367 | 5993733.23917615 | 2102822.62397698 | 37.7535901848349 | -122.464600030151 | (37.7535901848349, -122.464600030151) | ||
| 78018 | 78018 | 45189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 80 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44032 | 6009648.85827888 | 2099848.14474258 | 37.7463275924044 | -122.409350189836 | (37.7463275924044, -122.409350189836) | ||
| 78047 | 78047 | 107753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | ||||
| 78129 | 78129 | 42789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 426 -28 -30 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546.0 | 2110000.0 | 37.7739149561089 | -122.42771846696199 | (37.7739149561089, -122.427718466962) | ||
| 78150 | 78150 | 64131 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 619 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 24902 | 6002577.32467051 | 2098854.14366792 | 37.743199557291 | -122.433731658795 | (37.743199557291, -122.433731658795) | ||
| 78214 | 78214 | 36247 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Surrey St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
| 78236 | 78236 | 43735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711003 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | ||
| 78275 | 78275 | 61292 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 513 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23291 | 6007551.81435287 | 2097267.45931552 | 37.739123888071205 | -122.41641877514601 | (37.7391238880712, -122.416418775146) | ||
| 78342 | 78342 | 43353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4184 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | ||
| 78396 | 78396 | 52721 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 436 Murray St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 3x3 | Permit Number 48774 | 6006467.29339498 | 2096036.53480915 | 37.7356829947097 | -122.42008123178199 | (37.7356829947097, -122.420081231782) | ||
| 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) | ||
| 78435 | 78435 | 88652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51633 | 6003259.0 | 2109313.0 | 37.7719557379099 | -122.43212133996599 | (37.7719557379099, -122.432121339966) | ||
| 78486 | 78486 | 117170 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 78517 | 78517 | 50077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2662 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46809 | 5991463.01210611 | 2097302.86781432 | 37.7383032204594 | -122.472048604289 | (37.7383032204594, -122.472048604289) | ||
| 78556 | 78556 | 40389 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 78741 | 78741 | 47278 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45225 | 6010323.37047205 | 2103961.60067533 | 37.7576600010286 | -122.40730772564699 | (37.7576600010286, -122.407307725647) | |
| 78748 | 78748 | 39753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 78757 | 78757 | 65245 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1106 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28039 | 6009173.38165211 | 2102703.44295541 | 37.7541409539447 | -122.411195999264 | (37.7541409539447, -122.411195999264) | ||
| 78862 | 78862 | 65551 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 289 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28450 | 5995479.90221927 | 2097471.34821385 | 37.7389974556715 | -122.458172454258 | (37.7389974556715, -122.458172454258) | ||
| 78945 | 78945 | 62503 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 565 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51470 | 6001218.01395454 | 2103057.61257026 | 37.754664054032 | -122.438732928874 | (37.754664054032, -122.438732928874) | ||
| 78957 | 78957 | 49137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 78985 | 78985 | 42571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42653 | 5992105.55983914 | 2095227.71522931 | 37.7326425353626 | -122.469675980927 | (37.7326425353626, -122.469675980927) | |||
| 79015 | 79015 | 32921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
| 79040 | 79040 | 84786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49308 | 5999615.8 | 2105217.4 | 37.76050301831479 | -122.444429006349 | (37.7605030183148, -122.444429006349) | |||
| 79056 | 79056 | 39135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 825 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40814 | 6007381.77493134 | 2102503.74166558 | 37.7534919799027 | -122.417377678845 | (37.7534919799027, -122.417377678845) | ||
| 79137 | 79137 | 63845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24538 | 6008805.48916661 | 2096845.15100597 | 37.7380347427312 | -122.41205428341499 | (37.7380347427312, -122.412054283415) | ||
| 79215 | 79215 | 36343 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | ||
| 79328 | 79328 | 88522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
| 79351 | 79351 | 50276 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46979 | 6004285.87067198 | 2095713.64445309 | 37.734673261546504 | -122.42760025785401 | (37.7346732615465, -122.427600257854) | ||
| 79418 | 79418 | 37690 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 562 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40078 | 6007845.87669797 | 2104655.5935128 | 37.759426574444106 | -122.415925080154 | (37.7594265744441, -122.415925080154) | ||
| 79469 | 79469 | 88223 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2442 Fulton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51219 | 5996404.0 | 2110432.0 | 37.7746371856421 | -122.455914062335 | (37.7746371856421, -122.455914062335) | |||
| 79484 | 79484 | 62930 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 7 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23311 | 6007219.07323891 | 2097777.61404541 | 37.7405059423525 | -122.417605393857 | (37.7405059423525, -122.417605393857) | ||
| 79577 | 79577 | 32850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 743 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2006 12:00:00 AM | Permit Number 37201 | 6001607.63275994 | 2102018.09259502 | 37.751831939335204 | -122.437311094932 | (37.7518319393352, -122.437311094932) | ||
| 79623 | 79623 | 62851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/1986 12:00:00 AM | 6008695.79989615 | 2098007.34632384 | 37.7412197219886 | -122.412515664848 | (37.7412197219886, -122.412515664848) | |||
| 79671 | 79671 | 115684 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 79690 | 79690 | 91341 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 829 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 79778 | 79778 | 63421 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 216 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 24005 | 6008985.00081085 | 2097389.20642275 | 37.7395386707954 | -122.411472046568 | (37.7395386707954, -122.411472046568) | ||
| 79787 | 79787 | 96460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 79803 | 79803 | 43861 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
| 79817 | 79817 | 49121 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46253 | 5995746.37464462 | 2094397.74678667 | 37.730573402709396 | -122.457028858359 | (37.7305734027094, -122.457028858359) | ||
| 79831 | 79831 | 64805 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1425 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25804 | 6003950.13397491 | 2099979.34039052 | 37.7463668898084 | -122.429065055592 | (37.7463668898084, -122.429065055592) | ||
| 80035 | 80035 | 62481 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 77 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22652 | 6000572.53796355 | 2092891.28194987 | 37.726712968457605 | -122.44023614535601 | (37.7267129684576, -122.440236145356) | ||
| 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) | |||
| 80082 | 80082 | 36180 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | Permit Number 39250 | 5996187.56440634 | 2113855.50691306 | 37.7840248062044 | -122.45691042062201 | (37.7840248062044, -122.456910420622) | ||
| 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) | |
| 80110 | 80110 | 63074 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 76 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1997 12:00:00 AM | Permit Number 23552 | 6008300.81447158 | 2098195.91852103 | 37.741715324839795 | -122.41389472446998 | (37.7417153248398, -122.41389472447) | ||
| 80130 | 80130 | 41681 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48 Mars St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42135 | 5999546.48473392 | 2105510.97552161 | 37.761305148712296 | -122.444689836929 | (37.7613051487123, -122.444689836929) | ||
| 80148 | 80148 | 44164 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Sycamore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.762591694443294 | -122.420263998944 | (37.7625916944433, -122.420263998944) | |||
| 80163 | 80163 | 88235 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 329 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51224 | 6000219.0 | 2110006.0 | 37.773685716624705 | -122.44268666247 | (37.7736857166247, -122.44268666247) | |||
| 80198 | 80198 | 84962 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 85 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51457 | 5998153.0 | 2107172.0 | 37.765786285611206 | -122.44962898742901 | (37.7657862856112, -122.449628987429) | ||
| 80278 | 80278 | 42211 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.40260952625201 | (37.7783260063796, -122.402609526252) | ||
| 80303 | 80303 | 42522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42635 | 6000743.4333065 | 2100900.95079718 | 37.748715370273 | -122.44021950385 | (37.748715370273, -122.44021950385) | |||
| 80310 | 80310 | 87949 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Saturn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50971 | 5999927.0 | 2105970.0 | 37.7625872228516 | -122.44340677166201 | (37.7625872228516, -122.443406771662) | ||
| 80354 | 80354 | 67682 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31286 | 6012201.16288031 | 2095460.48706817 | 37.73442268368721 | -122.400216460292 | (37.7344226836872, -122.400216460292) | ||
| 80363 | 80363 | 66372 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 29496 | 6003710.25290475 | 2109797.53880085 | 37.7733117365244 | -122.43059500388901 | (37.7733117365244, -122.430595003889) | ||
| 80435 | 80435 | 110552 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 80471 | 80471 | 36417 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Montecito Ave | 1 | 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) | ||
| 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) | |||
| 80558 | 80558 | 49133 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Valdez Ave | 1 | 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) | |||
| 80652 | 80652 | 33821 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/1985 12:00:00 AM | Permit Number 37837 | 6010417.94927739 | 2089844.96936421 | 37.7189040522027 | -122.40598618211901 | (37.7189040522027, -122.405986182119) | |||
| 80690 | 80690 | 119841 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 80706 | 80706 | 119853 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 401 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 80735 | 80735 | 48847 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 211@ Lake St 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46061 | 5987400.97577089 | 2114545.21286522 | 37.785410070991205 | -122.487359105809 | (37.7854100709912, -122.487359105809) | |||
| 80786 | 80786 | 43582 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1623 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43243 | 6003373.31451853 | 2098789.66014494 | 37.7430676354641 | -122.430974736071 | (37.7430676354641, -122.430974736071) | ||
| 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) | ||
| 80945 | 80945 | 68117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1502 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31863 | 6008003.81348148 | 2099398.89549978 | 37.745001748301 | -122.41500678488501 | (37.745001748301, -122.415006784885) | ||
| 80994 | 80994 | 88228 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | ||
| 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) | ||
| 81105 | 81105 | 33461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 305 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37800 | 6006692.6358567 | 2098010.19766457 | 37.7411149282021 | -122.41944210942499 | (37.7411149282021, -122.419442109425) | |||
| 81224 | 81224 | 43843 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2729 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43465 | 5985530.78244018 | 2096757.50782257 | 37.736460738343204 | -122.49251889363501 | (37.7364607383432, -122.492518893635) | ||
| 81269 | 81269 | 62483 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 80 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22654 | 6000518.46428182 | 2092901.19185659 | 37.7267370999864 | -122.44042378634899 | (37.7267370999864, -122.440423786349) | ||
| 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) | ||
| 81367 | 81367 | 38260 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3153 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40364 | 6007746.96996202 | 2106161.2174207 | 37.763555108568795 | -122.416373793735 | (37.7635551085688, -122.416373793735) | ||
| 81601 | 81601 | 65210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1008 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27196 | 6003122.02248491 | 2102364.94475265 | 37.7528702875206 | -122.432098897252 | (37.7528702875206, -122.432098897252) | ||
| 81889 | 81889 | 119810 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 81960 | 81960 | 43918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43512 | 6010054.31584412 | 2101358.58546395 | 37.7504976389417 | -122.408054661788 | (37.7504976389417, -122.408054661788) | ||
| 82029 | 82029 | 93176 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 82066 | 82066 | 39487 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3723 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40945 | 6004943.29101021 | 2101913.34310631 | 37.7517333836283 | -122.42576846624901 | (37.7517333836283, -122.425768466249) | ||
| 82115 | 82115 | 62934 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 35 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23315 | 6007219.78887781 | 2097624.38086585 | 37.7400852383309 | -122.417592061686 | (37.7400852383309, -122.417592061686) | ||
| 82127 | 82127 | 50540 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 199 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006096.0 | 2099195.0 | 37.744334505185705 | -122.421589192303 | (37.7443345051857, -122.421589192303) | |||
| 82145 | 82145 | 55458 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1322x 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1972 12:00:00 AM | 3x3 | Permit Number 11409 | 5993613.0 | 2106469.0 | 37.7635952548206 | -122.46528068560801 | (37.7635952548206, -122.465280685608) | ||
| 82304 | 82304 | 57252 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4218 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31442 | 6002471.62723771 | 2100655.85764139 | 37.7481406431787 | -122.43422590958099 | (37.7481406431787, -122.434225909581) | ||
| 82342 | 82342 | 63149 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 115 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23679 | 6006308.72972245 | 2098250.05588025 | 37.7417518943702 | -122.420786544899 | (37.7417518943702, -122.420786544899) | ||
| 82428 | 82428 | 50018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46752 | 5992447.36096557 | 2090326.79664317 | 37.7192055701762 | -122.46813791817101 | (37.7192055701762, -122.468137918171) | ||
| 82520 | 82520 | 41833 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1363 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42218 | 5991432.6830161 | 2106147.07297066 | 37.7625853514609 | -122.47279816712098 | (37.7625853514609, -122.472798167121) |
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");