Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189143 | 189143 | 137803 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004934.2786 | 2115449.7152 | 37.78890048406579 | -122.42676352221599 | (37.7889004840658, -122.426763522216) | |||
| 189127 | 189127 | 131863 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | |||
| 189061 | 189061 | 210775 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1280 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993026.62735 | 2106720.09282 | 37.7642508567239 | -122.467327005649 | (37.7642508567239, -122.467327005649) | |||
| 189009 | 189009 | 210872 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 371 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5997627.30354 | 2093781.8331900002 | 37.72899008680061 | -122.450481853864 | (37.7289900868006, -122.450481853864) | |||
| 189006 | 189006 | 137842 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800X Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 188898 | 188898 | 131794 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3456 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999255.89477 | 2120717.3179 | 37.8030412345399 | -122.446789058571 | (37.8030412345399, -122.446789058571) | |||
| 188889 | 188889 | 210626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1364 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992425.98915 | 2106184.83469 | 37.76274648698271 | -122.469365460244 | (37.7627464869827, -122.469365460244) | |||
| 188819 | 188819 | 137707 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 709 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000033.9422 | 2111355.7747 | 37.777381303625205 | -122.443423777589 | (37.7773813036252, -122.443423777589) | |||
| 188724 | 188724 | 233803 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 292 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003731.393540001 | 2097927.34077 | 37.740720187986 | -122.429675106625 | (37.740720187986, -122.429675106625) | |||
| 188696 | 188696 | 47494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 219 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 13 | Permit Number 45387 | 6001679.50677 | 2093822.21478 | 37.729332060307996 | -122.43647599576799 | (37.729332060308, -122.436475995768) | |
| 188665 | 188665 | 233699 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1111 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004130.4286400005 | 2102416.0616 | 37.7530677627665 | -122.428615284394 | (37.7530677627665, -122.428615284394) | |||
| 188650 | 188650 | 131952 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 30 Russell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007110.60778 | 2118970.55106 | 37.798690629231 | -122.41948359170901 | (37.798690629231, -122.419483591709) | |||
| 188620 | 188620 | 83763 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 361 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2006 12:00:00 AM | 4 | Permit Number 776681 | 5993691.54318 | 2113064.28499 | 37.781708680288205 | -122.465488178701 | (37.7817086802882, -122.465488178701) | |
| 188553 | 188553 | 246628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009031.72375 | 2099369.08818 | 37.7449776127301 | -122.411450337281 | (37.7449776127301, -122.411450337281) | ||||
| 188548 | 188548 | 233108 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 566 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002275.383280001 | 2099464.47244 | 37.744858239414896 | -122.43481932764799 | (37.7448582394149, -122.434819327648) | |||
| 188518 | 188518 | 232443 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1379 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010363.00865 | 2101291.1462 | 37.7503297444393 | -122.406982420796 | (37.7503297444393, -122.406982420796) | |||
| 188472 | 188472 | 233823 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 20 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006554.923330001 | 2109652.2146799997 | 37.7730734542033 | -122.420744560833 | (37.7730734542033, -122.420744560833) | |||
| 188414 | 188414 | 117859 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 720 40th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5983546.44391 | 2110976.69858 | 37.775386436397795 | -122.50043048190399 | (37.7753864363978, -122.500430481904) | |||
| 188368 | 188368 | 137983 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2281 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003005.4018 | 2115130.8192 | 37.78791563223739 | -122.43341436888299 | (37.7879156322374, -122.433414368883) | |||
| 188336 | 188336 | 232883 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2800 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009514.50062 | 2105024.85439 | 37.7605341511365 | -122.410180205851 | (37.7605341511365, -122.410180205851) | |||
| 188335 | 188335 | 233626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2900 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009171.12912 | 2105477.0682 | 37.7617565744355 | -122.411399723443 | (37.7617565744355, -122.411399723443) | |||
| 188176 | 188176 | 178034 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) | ||||
| 188126 | 188126 | 41204 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | 5 | Permit Number 41910 | 5993962.39394 | 2115424.11607 | 37.7882037522081 | -122.46472258678001 | (37.7882037522081, -122.46472258678) | ||
| 188025 | 188025 | 233083 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 10ft | 6001990.940119999 | 2099392.0216200002 | 37.7446431530538 | -122.435797694723 | (37.7446431530538, -122.435797694723) | |||
| 187985 | 187985 | 177913 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2924 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5990007.1003 | 2095790.68963 | 37.7340668092368 | -122.476971913545 | (37.7340668092368, -122.476971913545) | |||
| 187879 | 187879 | 210707 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 401 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994004.02055 | 2089191.37438 | 37.716177751384 | -122.46267485678601 | (37.716177751384, -122.462674856786) | |||
| 187843 | 187843 | 232906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 190 Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004730.20675 | 2109429.9602799998 | 37.7723601839173 | -122.42704065601801 | (37.7723601839173, -122.427040656018) | |||
| 187711 | 187711 | 131844 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2799 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5999628.80588 | 2118409.7902900004 | 37.796726677146296 | -122.445332584947 | (37.7967266771463, -122.445332584947) | |||
| 187657 | 187657 | 131996 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2526 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007018.30389 | 2120919.94417 | 37.8040379702445 | -122.41994140057501 | (37.8040379702445, -122.419941400575) | |||
| 187629 | 187629 | 233185 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 15 Ashbury Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999562.80267 | 2106914.7513200003 | 37.765160498475204 | -122.44473430466101 | (37.7651604984752, -122.444734304661) | |||
| 187545 | 187545 | 131991 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2423 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007008.853619999 | 2120634.9778 | 37.803254992598 | -122.4199538697 | (37.803254992598, -122.4199538697) | |||
| 187501 | 187501 | 92258 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 891 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52707 | 5981374.1327 | 2109674.4758 | 37.7716831604786 | -122.507848221548 | (37.7716831604786, -122.507848221548) | |
| 187485 | 187485 | 55910 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3646 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1973 12:00:00 AM | 7 | Permit Number 11968 | 5999164.92629 | 2121362.0715400004 | 37.8048063563971 | -122.447150284777 | (37.8048063563971, -122.447150284777) | ||
| 187483 | 187483 | 194179 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 198 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013413.98851 | 2106222.8030000003 | 37.7640412580141 | -122.39677755096201 | (37.7640412580141, -122.396777550962) | |||
| 187409 | 187409 | 71109 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1995 12:00:00 AM | 9 | 6004811.8428 | 2113348.9801 | 37.783125466661296 | -122.42703744955601 | (37.7831254666613, -122.427037449556) | ||
| 187317 | 187317 | 131788 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2398 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001532.9252 | 2118722.97008 | 37.7976950958944 | -122.438766364895 | (37.7976950958944, -122.438766364895) | |||
| 187279 | 187279 | 97785 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 810 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2007 12:00:00 AM | 4 | 3x3 | Permit Number 58240 | 6012450.90324 | 2118910.93566 | 37.79882628295321 | -122.40100015753 | (37.7988262829532, -122.40100015753) | |
| 187228 | 187228 | 210657 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993485.31951 | 2093573.22652 | 37.7281793677659 | -122.46478574638999 | (37.7281793677659, -122.46478574639) | |||
| 187162 | 187162 | 68554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 735 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 777390 | 5982265.00656 | 2110745.36563 | 37.7746759600384 | -122.504846052747 | (37.7746759600384, -122.504846052747) | |
| 187094 | 187094 | 177895 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Cora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009660.88165 | 2087611.8363599998 | 37.7127299566062 | -122.40844564386002 | (37.7127299566062, -122.40844564386) | |||
| 187090 | 187090 | 56052 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 263 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 14 | Permit Number 12456 | 5993047.65364 | 2113722.54317 | 37.783478920578 | -122.467763603232 | (37.783478920578, -122.467763603232) | ||
| 187082 | 187082 | 232950 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 410 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003783.54215 | 2100140.11142 | 37.7467988981531 | -122.429652575025 | (37.7467988981531, -122.429652575025) | |||
| 187069 | 187069 | 232998 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 352 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006971.7087 | 2096006.06975 | 37.735627751704996 | -122.418335109772 | (37.735627751705, -122.418335109772) | |||
| 187032 | 187032 | 91121 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 49 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52011 | 5993923.4735900005 | 2115228.62384 | 37.78766474010129 | -122.46484304100599 | (37.7876647401013, -122.464843041006) | |
| 186946 | 186946 | 62774 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 36 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 6 | Permit Number 23129 | 6000628.75653 | 2093088.58335 | 37.7272579134153 | -122.440055941455 | (37.7272579134153, -122.440055941455) | |
| 186944 | 186944 | 233692 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3926 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004321.37084 | 2101339.1200900003 | 37.7501215369861 | -122.42787823689899 | (37.7501215369861, -122.427878236899) | |||
| 186934 | 186934 | 233088 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 22 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000944.67492 | 2101566.3347400003 | 37.7505538105179 | -122.439571306692 | (37.7505538105179, -122.439571306692) | |||
| 186931 | 186931 | 232435 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1 Church St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6004121.39652 | 2108664.33355 | 37.7702235143292 | -122.42909198802201 | (37.7702235143292, -122.429091988022) | |||
| 186863 | 186863 | 131851 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 5999147.80126 | 2121174.2853 | 37.8042897678153 | -122.447196024289 | (37.8042897678153, -122.447196024289) | |||
| 186850 | 186850 | 131984 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2445 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006962.8063 | 2120946.08648 | 37.8041066235873 | -122.420135310616 | (37.8041066235873, -122.420135310616) | |||
| 186828 | 186828 | 232921 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3893 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004555.54472 | 2101310.9202099997 | 37.7500573514658 | -122.427066441373 | (37.7500573514658, -122.427066441373) | |||
| 186779 | 186779 | 177980 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 171 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6004090.15044 | 2092680.5927400002 | 37.7263341082055 | -122.428060857726 | (37.7263341082055, -122.428060857726) | |||
| 186754 | 186754 | 233079 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001435.52575 | 2100254.1053299997 | 37.7469786654515 | -122.437779936321 | (37.7469786654515, -122.437779936321) | ||||
| 186688 | 186688 | 41762 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1320-1360 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42186 | 6006057.88035 | 2120049.65572 | 37.8015942253485 | -122.423203116657 | (37.8015942253485, -122.423203116657) | |
| 186665 | 186665 | 233093 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 83 Fountain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000377.855330001 | 2101235.40364 | 37.7496128768471 | -122.441507663055 | (37.7496128768471, -122.441507663055) | |||
| 186572 | 186572 | 233769 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 51 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003178.1969099995 | 2108003.59626 | 37.7683558544786 | -122.43230731074199 | (37.7683558544786, -122.432307310742) | |||
| 186535 | 186535 | 47265 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1522 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45206 | 5989024.0272 | 2104940.8762 | 37.759133731330294 | -122.481040417074 | (37.7591337313303, -122.481040417074) | |
| 186497 | 186497 | 131936 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1654 Hyde St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007422.60958 | 2118093.1296900003 | 37.796299018046206 | -122.41834171801099 | (37.7962990180462, -122.418341718011) | |||
| 186360 | 186360 | 233770 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 47 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6003173.70397 | 2108040.8462 | 37.768457878964 | -122.43232551211399 | (37.768457878964, -122.432325512114) | |||
| 186325 | 186325 | 233807 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 122 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004307.63896 | 2097350.49123 | 37.739168903323396 | -122.427641579417 | (37.7391689033234, -122.427641579417) | |||
| 186292 | 186292 | 233096 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4431 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000473.32659 | 2101668.7231099997 | 37.7508081064097 | -122.44120860700501 | (37.7508081064097, -122.441208607005) | |||
| 186177 | 186177 | 210858 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999351.90422 | 2095271.3522 | 37.7331785137649 | -122.444626815895 | (37.7331785137649, -122.444626815895) | ||||
| 186091 | 186091 | 177887 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 154 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010389.20709 | 2087951.35398 | 37.7137029636965 | -122.405952208735 | (37.7137029636965, -122.405952208735) | |||
| 186082 | 186082 | 250468 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 330 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986773.71453 | 2115563.2588299997 | 37.7881687321606 | -122.489604103052 | (37.7881687321606, -122.489604103052) | |||
| 186073 | 186073 | 233637 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.74272486946911 | -122.423117200821 | (37.7427248694691, -122.423117200821) | |||
| 186056 | 186056 | 131852 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3627 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000669.71711 | 2120817.4832900004 | 37.803396926283604 | -122.44190370201099 | (37.8033969262836, -122.441903702011) | |||
| 186045 | 186045 | 232898 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 190 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004751.04399 | 2109279.15685 | 37.771947292552 | -122.426957835644 | (37.771947292552, -122.426957835644) | |||
| 186040 | 186040 | 250888 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 188 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986832.35186 | 2114485.1833200003 | 37.7852120706333 | -122.489321932679 | (37.7852120706333, -122.489321932679) | |||
| 186003 | 186003 | 72299 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 790 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 6 | 6011682.79959 | 2109646.37516 | 37.7733451034182 | -122.403006076485 | (37.7733451034182, -122.403006076485) | ||
| 185998 | 185998 | 232961 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 10 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998954.69213 | 2105425.20137 | 37.7610358460469 | -122.446730418281 | (37.7610358460469, -122.446730418281) | |||
| 185975 | 185975 | 210672 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 992 Waithman Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5996018.88182 | 2098492.62213 | 37.7418325783074 | -122.456382749179 | (37.7418325783074, -122.456382749179) | |||
| 185941 | 185941 | 12641 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 934 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3PL | 5992552.1163800005 | 2114856.32512 | 37.786563348548604 | -122.469560515868 | (37.7865633485486, -122.469560515868) | |||
| 185908 | 185908 | 232874 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 50 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005358.52652 | 2103413.3355900003 | 37.7558754704919 | -122.424439206898 | (37.7558754704919, -122.424439206898) | |||
| 185853 | 185853 | 233037 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 777 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009341.05007 | 2104563.63972 | 37.7592580365599 | -122.410747521583 | (37.7592580365599, -122.410747521583) | |||
| 185814 | 185814 | 131801 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2498 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999407.7322 | 2119814.3331299997 | 37.8005705540491 | -122.446198631166 | (37.8005705540491, -122.446198631166) | |||
| 185761 | 185761 | 52079 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3541 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2005 12:00:00 AM | 5 | Permit Number 48276 | 5987618.79518 | 2111845.06794 | 37.7780089395851 | -122.486407214354 | (37.7780089395851, -122.486407214354) | ||
| 185746 | 185746 | 177885 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 145 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010318.896819999 | 2087650.5759299998 | 37.7128731556567 | -122.406174049896 | (37.7128731556567, -122.406174049896) | |||
| 185739 | 185739 | 177861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 941 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000851.1649 | 2091503.3604099997 | 37.722917912013294 | -122.43917350956801 | (37.7229179120133, -122.439173509568) | |||
| 185707 | 185707 | 232432 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6004078.65513 | 2108269.95494 | 37.7691382268875 | -122.429211704867 | (37.7691382268875, -122.429211704867) | |||
| 185682 | 185682 | 177859 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1601 San Jose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001617.87138 | 2094170.6936700002 | 37.7302854010441 | -122.43671400943701 | (37.7302854010441, -122.436714009437) | ||||
| 185610 | 185610 | 210806 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1525 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995809.9592 | 2094266.1286 | 37.730215662199896 | -122.45679952290001 | (37.7302156621999, -122.4567995229) | |||
| 185532 | 185532 | 233119 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4185 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6002746.18686 | 2100329.0573299997 | 37.747258905869 | -122.433253144832 | (37.747258905869, -122.433253144832) | |||
| 185512 | 185512 | 177974 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6004875.55792 | 2093420.9047400001 | 37.7284112462806 | -122.425398400422 | (37.7284112462806, -122.425398400422) | |||
| 185499 | 185499 | 210857 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999360.350819999 | 2095260.17688 | 37.7331483109495 | -122.444596810892 | (37.7331483109495, -122.444596810892) | ||||
| 185484 | 185484 | 250678 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 738 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986293.8358 | 2114857.16147 | 37.7862019651938 | -122.49121239213301 | (37.7862019651938, -122.491212392133) | |||
| 185460 | 185460 | 233609 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1314 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008041.70047 | 2100435.45897 | 37.7478500491477 | -122.414949129919 | (37.7478500491477, -122.414949129919) | |||
| 185430 | 185430 | 194209 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 443 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011185.40035 | 2112038.41946 | 37.7798853150983 | -122.40489510601999 | (37.7798853150983, -122.40489510602) | |||
| 185378 | 185378 | 111972 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 240 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2015 12:00:00 AM | 1 | 3x3 | 6012967.335940001 | 2095411.30766 | 37.7343303393552 | -122.39756408273998 | (37.7343303393552, -122.39756408274) | ||
| 185169 | 185169 | 232996 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 191 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999157.58061 | 2107656.0221599997 | 37.7671727090922 | -122.446189190087 | (37.7671727090922, -122.446189190087) | |||
| 185137 | 185137 | 233621 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2880 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008926.38138 | 2103933.66638 | 37.757505014151604 | -122.412137128829 | (37.7575050141516, -122.412137128829) | |||
| 185092 | 185092 | 210770 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1407 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994247.24825 | 2105911.89788 | 37.7621021533037 | -122.463046614021 | (37.7621021533037, -122.463046614021) | |||
| 185056 | 185056 | 233005 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 119 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007069.66802 | 2098702.6981200003 | 37.743037608701 | -122.41818754992201 | (37.743037608701, -122.418187549922) | |||
| 185038 | 185038 | 73548 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1707 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 7 | 6000544.9075 | 2114594.6979 | 37.7863036820207 | -122.441888712315 | (37.7863036820207, -122.441888712315) | ||
| 185030 | 185030 | 108987 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3560 Baker St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999200.334980001 | 2121108.96976 | 37.804113430551894 | -122.447009524696 | (37.8041134305519, -122.447009524696) | ||||
| 185016 | 185016 | 210719 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 293 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994040.58934 | 2087749.69636 | 37.712221352204295 | -122.46244394955099 | (37.7122213522043, -122.462443949551) | |||
| 185004 | 185004 | 186299 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985021.1385 | 2102711.497 | 37.7527789669048 | -122.49471975093701 | (37.7527789669048, -122.494719750937) | |||
| 185000 | 185000 | 233610 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009156.0477 | 2103144.9026099998 | 37.7553521307214 | -122.411287128293 | (37.7553521307214, -122.411287128293) | |||
| 184753 | 184753 | 233679 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4061 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003463.150169999 | 2101246.2798099997 | 37.74981803109571 | -122.430839387833 | (37.7498180310957, -122.430839387833) | |||
| 184671 | 184671 | 62098 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 263 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51774 | 6013213.82245 | 2105839.16693 | 37.7629767350191 | -122.39744296474301 | (37.7629767350191, -122.397442964743) | |
| 184618 | 184618 | 210668 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 220 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996107.59871 | 2098932.75932 | 37.743046179246505 | -122.456107811121 | (37.7430461792465, -122.456107811121) |
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");