Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62207 | 62207 | 178355 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2 Moneta Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997930.01019 | 2088108.42362 | 37.7134295446025 | -122.449026847907 | (37.7134295446025, -122.449026847907) | |||
| 81636 | 81636 | 87743 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 335 Wilde Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50406 | 6011180.9 | 2088940.4 | 37.7164629306199 | -122.403285348147 | (37.7164629306199, -122.403285348147) | |||
| 120880 | 120880 | 211311 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995443.13465 | 2089926.3908400002 | 37.7182787106718 | -122.457753775529 | (37.7182787106718, -122.457753775529) | |||
| 114858 | 114858 | 104308 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2013 12:00:00 AM | 3x3 | Permit Number 770798 | 5995451.6 | 2089938.7 | 37.7183129950309 | -122.45772540476801 | (37.7183129950309, -122.457725404768) | ||
| 47732 | 47732 | 178357 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 700 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009625.93878 | 2090631.7553 | 37.7210200744845 | -122.408779340021 | (37.7210200744845, -122.408779340021) | |||
| 68335 | 68335 | 178356 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 700 Olmstead St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6009662.10656 | 2090649.3043799999 | 37.7210702863525 | -122.40865555551301 | (37.7210702863525, -122.408655555513) | |||
| 68463 | 68463 | 40842 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 736 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1999 12:00:00 AM | 4 | Permit Number 41768 | 6003877.32471 | 2090996.8585299999 | 37.7216989034509 | -122.428676613636 | (37.7216989034509, -122.428676613636) | ||
| 12116 | 12116 | 117434 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 71 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775886 | 6000675.587280001 | 2092024.5104 | 37.7243388786085 | -122.43981779016899 | (37.7243388786085, -122.439817790169) | ||
| 58378 | 58378 | 199989 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | |||
| 182359 | 182359 | 199995 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1094 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6017857.177999999 | 2092387.3649 | 37.7262982485858 | -122.380448036499 | (37.7262982485858, -122.380448036499) | |||
| 24479 | 24479 | 178359 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003629.76511 | 2092456.5835099998 | 37.72569297073721 | -122.42963641778401 | (37.7256929707372, -122.429636417784) | |||
| 160816 | 160816 | 199695 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1350 Underwood Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6015882.1777 | 2092801.0091 | 37.7273248550401 | -122.387304416847 | (37.7273248550401, -122.387304416847) | |||
| 146661 | 146661 | 199688 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2000 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015592.0163 | 2092881.2495 | 37.7275291054366 | -122.388313110838 | (37.7275291054366, -122.388313110838) | |||
| 53738 | 53738 | 199687 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2000 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015600.4454 | 2092895.2979 | 37.7275681466115 | -122.388284951178 | (37.7275681466115, -122.388284951178) | |||
| 148370 | 148370 | 199686 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2000 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015608.757 | 2092907.6605 | 37.7276025523971 | -122.388257080086 | (37.7276025523971, -122.388257080086) | |||
| 132495 | 132495 | 53194 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 1465@ KEITH Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 2 | 3x3 | Permit Number 49131 | 6015294.6422 | 2093162.1043 | 37.7282837944132 | -122.38936074844801 | (37.7282837944132, -122.389360748448) | |
| 76464 | 76464 | 178358 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 54 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004690.167219999 | 2093211.8468799999 | 37.7278267435864 | -122.426024429306 | (37.7278267435864, -122.426024429306) | |||
| 167215 | 167215 | 211318 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 355 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997726.4515 | 2093787.9234799999 | 37.72901248352571 | -122.450139532341 | (37.7290124835257, -122.450139532341) | |||
| 183020 | 183020 | 194534 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 25 Lucy St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014175.87087 | 2093939.45878 | 37.7303561623911 | -122.39328279268 | (37.7303561623911, -122.39328279268) | |||
| 68522 | 68522 | 200624 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1382 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6016324.8756 | 2094912.2277 | 37.7331463494491 | -122.385921096754 | (37.7331463494491, -122.385921096754) | |||
| 67511 | 67511 | 178360 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 114 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009991.862930001 | 2095011.3305799998 | 37.733065957324705 | -122.40782310796001 | (37.7330659573247, -122.40782310796) | |||
| 11409 | 11409 | 52759 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 22 Gaven St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2014 12:00:00 AM | 3 | Permit Number 774111 | 6010286.03762 | 2095339.86575 | 37.7339845095792 | -122.406829209621 | (37.7339845095792, -122.406829209621) | ||
| 50953 | 50953 | 52758 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 22 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 1 | Permit Number 774111 | 6010296.38896 | 2095344.759 | 37.733998524598 | -122.406793766427 | (37.733998524598, -122.406793766427) | ||
| 14996 | 14996 | 29645 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015832.5829 | 2095938.2561 | 37.7359363605469 | -122.38769466166599 | (37.7359363605469, -122.387694661666) | ||
| 15928 | 15928 | 29646 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015803.0705 | 2095958.3496 | 37.7359898984178 | -122.387798100273 | (37.7359898984178, -122.387798100273) | ||
| 16418 | 16418 | 29647 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015782.348999999 | 2095974.6757 | 37.7360335786804 | -122.387870882274 | (37.7360335786804, -122.387870882274) | ||
| 13981 | 13981 | 29648 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015756.6041 | 2095993.5134 | 37.736083876945294 | -122.38796120765 | (37.7360838769453, -122.38796120765) | ||
| 106720 | 106720 | 3871 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1540X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.736092722349895 | -122.38770730809999 | (37.7360927223499, -122.3877073081) | |||
| 123100 | 123100 | 3872 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1540X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2013 12:00:00 AM | 3X3 | 6015830.0749765 | 2095995.2525495 | 37.736092722349895 | -122.38770730809999 | (37.7360927223499, -122.3877073081) | |||
| 13827 | 13827 | 29649 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015738.3943 | 2096009.2115 | 37.73612597190029 | -122.38802526198299 | (37.7361259719003, -122.388025261983) | ||
| 13803 | 13803 | 29650 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015718.9286 | 2096019.8862 | 37.736154203998794 | -122.388093308135 | (37.7361542039988, -122.388093308135) | ||
| 40392 | 40392 | 233380 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 397 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007405.88509 | 2096272.2720299999 | 37.7363831156735 | -122.41685284539801 | (37.7363831156735, -122.416852845398) | |||
| 156011 | 156011 | 233379 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 397 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007387.94989 | 2096274.13101 | 37.7363872111847 | -122.41691498673 | (37.7363872111847, -122.41691498673) | |||
| 53169 | 53169 | 233377 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 514 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007431.42413 | 2096297.49525 | 37.7364538095851 | -122.416766332396 | (37.7364538095851, -122.416766332396) | |||
| 161820 | 161820 | 233378 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 514 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007432.33067 | 2096315.60507 | 37.7365035861596 | -122.416764480695 | (37.7365035861596, -122.416764480695) | |||
| 160009 | 160009 | 233382 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 485 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008169.60603 | 2096545.7269400002 | 37.7371768914874 | -122.414231675074 | (37.7371768914874, -122.414231675074) | |||
| 132896 | 132896 | 233381 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 485 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008152.13666 | 2096545.8865 | 37.7371763483116 | -122.414292086129 | (37.7371763483116, -122.414292086129) | |||
| 81085 | 81085 | 96154 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 482 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200.0 | 2096596.0 | 37.7373166375453 | -122.41413014457399 | (37.7373166375453, -122.414130144574) | |
| 145173 | 145173 | 96153 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 482 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767788 | 6008200.0 | 2096596.0 | 37.7373166375453 | -122.41413014457399 | (37.7373166375453, -122.414130144574) | |
| 155479 | 155479 | 35878 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 50 Elmira St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011145.10995 | 2096599.24748 | 37.7374905363641 | -122.403947710713 | (37.7374905363641, -122.403947710713) | |
| 31582 | 31582 | 194547 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.737886359456205 | -122.381824001685 | (37.7378863594562, -122.381824001685) | |||
| 72746 | 72746 | 233439 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007870.1294599995 | 2096618.1338 | 37.7373588783147 | -122.415272229338 | (37.7373588783147, -122.415272229338) | |||
| 126908 | 126908 | 115370 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 773523 | 6007887.0 | 2096619.6 | 37.7373638523191 | -122.41521400363101 | (37.7373638523191, -122.415214003631) | ||
| 166730 | 166730 | 35881 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 50 Elmira St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011145.59946 | 2096623.30558 | 37.7375566221413 | -122.403947710744 | (37.7375566221413, -122.403947710744) | |
| 156096 | 156096 | 35880 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 50 Elmira St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 7 | Permit Number 39083 | 6011141.46747 | 2096642.9450400001 | 37.7376103170696 | -122.40396337873301 | (37.7376103170696, -122.403963378733) | |
| 146833 | 146833 | 35879 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 50 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 8 | Permit Number 39083 | 6011139.9615 | 2096662.7740900002 | 37.7376646792858 | -122.403969980625 | (37.7376646792858, -122.403969980625) | |
| 104581 | 104581 | 26467 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 300X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2016 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | ||
| 22995 | 22995 | 11883 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 400X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017703.731269999 | 2096843.30561 | 37.73852491679771 | -122.381288201801 | (37.7385249167977, -122.381288201801) | |||
| 108624 | 108624 | 45703 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/2002 12:00:00 AM | Permit Number 44377 | 6014535.62783282 | 2096937.66705225 | 37.7386086105091 | -122.392248663491 | (37.7386086105091, -122.392248663491) | ||
| 58480 | 58480 | 233440 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 228 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008985.91579 | 2097299.4169099997 | 37.7392921796829 | -122.411462541085 | (37.7392921796829, -122.411462541085) | |||
| 21521 | 21521 | 28133 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6x9 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | |||
| 107036 | 107036 | 120537 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 300X EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778832 | 6006696.0 | 2098030.0 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | |
| 126249 | 126249 | 107340 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 300X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773835 | 6006696.0 | 2098030.0 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | |
| 147967 | 147967 | 233438 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 125 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007605.04677 | 2098050.53292 | 37.7412770284006 | -122.416290169252 | (37.7412770284006, -122.416290169252) | |||
| 160172 | 160172 | 247814 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 532 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003126.49354 | 2098351.09832 | 37.7418494576778 | -122.431796869036 | (37.7418494576778, -122.431796869036) | |||
| 126437 | 126437 | 34199 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 200 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1997 12:00:00 AM | Permit Number 38018 | 5994287.68885518 | 2098749.96127524 | 37.7424396309737 | -122.462387263533 | (37.7424396309737, -122.462387263533) | ||
| 85185 | 85185 | 38018 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 26 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.742929532714705 | -122.46804846503001 | (37.7429295327147, -122.46804846503) | ||
| 112452 | 112452 | 38019 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40229 | 5992654.87509513 | 2098962.67617423 | 37.742929532714705 | -122.46804846503001 | (37.7429295327147, -122.46804846503) | ||
| 16986 | 16986 | 22826 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 84 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 02:48:00 PM | 3 | 3x3 | 5999343.3761 | 2099052.93009 | 37.743561341476 | -122.444928046502 | (37.743561341476, -122.444928046502) | ||
| 59051 | 59051 | 233435 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 650 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001680.56547 | 2099436.84867 | 37.7447486021689 | -122.43687411574899 | (37.7447486021689, -122.436874115749) | |||
| 181974 | 181974 | 211312 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.46826285635099 | (37.7446340456409, -122.468262856351) | |||
| 60674 | 60674 | 248106 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010434.28428 | 2099597.55931 | 37.7456835139995 | -122.406616610788 | (37.7456835139995, -122.406616610788) | |||
| 26405 | 26405 | 211313 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992606.241280001 | 2099598.3023200002 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | |||
| 135941 | 135941 | 233375 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1489 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003970.51891 | 2099621.7541 | 37.745386194515795 | -122.428969076773 | (37.7453861945158, -122.428969076773) | |||
| 126717 | 126717 | 45171 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 47 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44018 | 6010456.17942581 | 2099626.75633158 | 37.7457649076199 | -122.40654295731301 | (37.7457649076199, -122.406542957313) | ||
| 168472 | 168472 | 233372 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3265 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009039.47947 | 2099686.6258900003 | 37.74584993622229 | -122.411445948568 | (37.7458499362223, -122.411445948568) | |||
| 104123 | 104123 | 93976 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 3261 Harrison St | : Cutout 24 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036.0 | 2099698.0 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | ||||
| 165169 | 165169 | 233441 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 33 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007530.9568 | 2099766.89279 | 37.7459856034546 | -122.416667906996 | (37.7459856034546, -122.416667906996) | |||
| 188793 | 188793 | 233442 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 95 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007954.1776 | 2099786.14211 | 37.746062251782206 | -122.415205824295 | (37.7460622517822, -122.415205824295) | |||
| 27600 | 27600 | 233376 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 476 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003431.53598 | 2100120.0067 | 37.746723757115205 | -122.430868343305 | (37.7467237571152, -122.430868343305) | |||
| 186029 | 186029 | 233373 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3101 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009080.82321 | 2100470.36587 | 37.748004231619 | -122.411358344739 | (37.748004231619, -122.411358344739) | |||
| 166546 | 166546 | 233374 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3101 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009080.9220900005 | 2100478.86061 | 37.7480275618365 | -122.41135860283701 | (37.7480275618365, -122.411358602837) | |||
| 79978 | 79978 | 108598 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.3865799997 | 37.7482534137383 | -122.41141043143601 | (37.7482534137383, -122.411410431436) |
| 128674 | 128674 | 108597 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.3865799997 | 37.7482534137383 | -122.41141043143601 | (37.7482534137383, -122.411410431436) |
| 30700 | 30700 | 233437 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 4221 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002351.48314 | 2100601.8225 | 37.7479854555773 | -122.43463750001601 | (37.7479854555773, -122.434637500016) | |||
| 56003 | 56003 | 233403 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3071 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009068.28085 | 2100690.5915599996 | 37.748608219004105 | -122.411417271913 | (37.7486082190041, -122.411417271913) | |||
| 24088 | 24088 | 233450 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3050 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009002.96054 | 2100768.18815 | 37.748817618046104 | -122.411648631477 | (37.7488176180461, -122.411648631477) | |||
| 113358 | 113358 | 91737 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 3050 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | |||
| 99954 | 99954 | 63999 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 595 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778275 | 6001356.36107438 | 2100834.50333121 | 37.7485677985315 | -122.438095249236 | (37.7485677985315, -122.438095249236) | |
| 151801 | 151801 | 233404 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2995 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009049.50769 | 2101050.92723 | 37.749596567629794 | -122.41150764387899 | (37.7495965676298, -122.411507643879) | |||
| 33966 | 33966 | 233405 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | |||
| 164338 | 164338 | 233406 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2967 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009040.7619199995 | 2101208.50526 | 37.7500287512299 | -122.411549018972 | (37.7500287512299, -122.411549018972) | |||
| 9361 | 9361 | 91805 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2959 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.2311080005 | 2101235.1434150003 | 37.7501013029605 | -122.41158731707701 | (37.7501013029605, -122.411587317077) | ||
| 9392 | 9392 | 91804 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.2311080005 | 2101235.1434150003 | 37.7501013029605 | -122.41158731707701 | (37.7501013029605, -122.411587317077) | ||
| 146798 | 146798 | 233407 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009039.77718 | 2101237.37153 | 37.7501079563364 | -122.411554463491 | (37.7501079563364, -122.411554463491) | |||
| 140016 | 140016 | 109449 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773467 | 6000399.0 | 2101283.9 | 37.7497472407948 | -122.441438023758 | (37.7497472407948, -122.441438023758) |
| 71043 | 71043 | 233436 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6000375.8348199995 | 2101284.56019 | 37.7497477337837 | -122.441518177039 | (37.7497477337837, -122.441518177039) | |||
| 169975 | 169975 | 233408 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2949 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009035.34127 | 2101297.6623299997 | 37.7502732526072 | -122.41157406239901 | (37.7502732526072, -122.411574062399) | |||
| 95013 | 95013 | 45466 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2211 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2001 12:00:00 AM | Permit Number 44247 | 6011994.00463493 | 2101339.69847182 | 37.750554191549604 | -122.401345703709 | (37.7505541915496, -122.401345703709) | |||
| 56502 | 56502 | 194531 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011908.13677 | 2101346.9263299997 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | |||
| 131936 | 131936 | 233490 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 918 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001888.71802 | 2101354.6064299997 | 37.7500261396126 | -122.43629158619301 | (37.7500261396126, -122.436291586193) | |||
| 66350 | 66350 | 233491 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 590 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001369.26473 | 2101468.92323 | 37.750310498029705 | -122.43809606779101 | (37.7503104980297, -122.438096067791) | |||
| 145294 | 145294 | 91738 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2900x Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008972.238365 | 2101556.992621 | 37.7509817758285 | -122.41181059976101 | (37.7509817758285, -122.411810599761) | |||
| 169949 | 169949 | 233366 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009652.81284 | 2101635.24983 | 37.7512348095611 | -122.409462618807 | (37.7512348095611, -122.409462618807) | |||
| 104732 | 104732 | 51755 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2964 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 771839 | 6009683.01299313 | 2101640.06724055 | 37.7512497292061 | -122.409358522845 | (37.7512497292061, -122.409358522845) | |||
| 9364 | 9364 | 91742 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008961.550736 | 2101748.066686 | 37.75150582289721 | -122.41186105930001 | (37.7515058228972, -122.4118610593) | ||
| 46353 | 46353 | 233451 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008950.63348 | 2101756.58641 | 37.751528603671 | -122.411899414636 | (37.751528603671, -122.411899414636) | |||
| 17597 | 17597 | 26520 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2859 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 1X1 | 6009005.0010400005 | 2101862.3389 | 37.7518220263649 | -122.41171887573299 | (37.7518220263649, -122.411718875733) | |||
| 154536 | 154536 | 233452 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2846 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008941.56896 | 2101881.9081099997 | 37.7518722004517 | -122.411939616143 | (37.7518722004517, -122.411939616143) | |||
| 126859 | 126859 | 91741 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2844 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) |
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");