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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
| 9865 | 9865 | 122387 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779324 | 5994732.0 | 2099337.0 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | |||
| 19410 | 19410 | 42456 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42599 | 5997659.71395367 | 2095289.95204904 | 37.733132877616896 | -122.45047848670099 | (37.7331328776169, -122.450478486701) | ||
| 19500 | 19500 | 68125 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.744400650970604 | -122.42180635131201 | (37.7444006509706, -122.421806351312) | ||
| 20614 | 20614 | 65804 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.47384127538099 | (37.7459566686168, -122.473841275381) | ||
| 42989 | 42989 | 39658 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.45626220721901 | (37.7199614976995, -122.456262207219) | ||
| 51326 | 51326 | 94076 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116.0 | 2095941.0 | 37.734832022473 | -122.45586253488399 | (37.734832022473, -122.455862534884) | ||
| 64063 | 64063 | 122404 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5994085.0 | 2099826.0 | 37.74538248907739 | -122.46316615516001 | (37.7453824890774, -122.46316615516) | ||||
| 69957 | 69957 | 98409 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 55 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||||
| 69960 | 69960 | 68121 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31868 | 6006245.31002458 | 2099503.96919514 | 37.745191282743896 | -122.421094842871 | (37.7451912827439, -122.421094842871) | ||
| 77448 | 77448 | 45122 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 77548 | 77548 | 51448 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | |||
| 77680 | 77680 | 63803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24490 | 6009186.19603238 | 2097034.65488427 | 37.7385764323817 | -122.41075136529899 | (37.7385764323817, -122.410751365299) | ||
| 77698 | 77698 | 68120 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.745340567320106 | -122.42120066595501 | (37.7453405673201, -122.421200665955) | ||
| 77864 | 77864 | 34431 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38175 | 6002613.57489862 | 2096408.07550267 | 37.736485277081705 | -122.433431554421 | (37.7364852770817, -122.433431554421) | ||
| 78195 | 78195 | 47741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1384 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 45524 | 6010066.05430582 | 2101146.00958918 | 37.7499146097647 | -122.40799907978399 | (37.7499146097647, -122.407999079784) | ||
| 78398 | 78398 | 62968 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1136 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | Permit Number 23354 | 6007556.73602589 | 2118875.23289672 | 37.7984540273893 | -122.41793308103901 | (37.7984540273893, -122.417933081039) | ||
| 78925 | 78925 | 69199 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1342 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33247 | 6009509.54623645 | 2101351.16759285 | 37.7504467544428 | -122.409938000531 | (37.7504467544428, -122.409938000531) | ||
| 79272 | 79272 | 41698 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 79811 | 79811 | 62908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23285 | 6007239.73762584 | 2097259.44248715 | 37.7390843209207 | -122.41749722959699 | (37.7390843209207, -122.417497229597) | ||
| 79903 | 79903 | 63792 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4094 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24478 | 6003252.0069667995 | 2101284.19573809 | 37.7499101740217 | -122.43157223645099 | (37.7499101740217, -122.431572236451) | ||
| 80468 | 80468 | 51543 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 47842 | 6006500.80110502 | 2104175.14616456 | 37.7580316646871 | -122.4205429163 | (37.7580316646871, -122.4205429163) | ||
| 80515 | 80515 | 94075 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116.0 | 2095941.0 | 37.734832022473 | -122.45586253488399 | (37.734832022473, -122.455862534884) | ||
| 80996 | 80996 | 116196 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3751 CLAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996888.0 | 2115293.0 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | ||||
| 81114 | 81114 | 41708 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.43519418820401 | (37.7355450223799, -122.435194188204) | ||
| 81479 | 81479 | 94078 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116.0 | 2095941.0 | 37.734832022473 | -122.45586253488399 | (37.734832022473, -122.455862534884) | ||
| 81651 | 81651 | 82780 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3946 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50814 | 6003353.51076321 | 2104798.51931181 | 37.75956542629571 | -122.43147208276001 | (37.7595654262957, -122.43147208276) | ||
| 82108 | 82108 | 102412 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000310.8 | 2109142.0 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | |||||
| 82231 | 82231 | 48500 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1584(REVISED) Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2003 12:00:00 AM | Permit Number 46340 | 5998006.8549345005 | 2108237.90665559 | 37.7687046321234 | -122.45021130824301 | (37.7687046321234, -122.450211308243) | |||
| 82611 | 82611 | 66726 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 416 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31446 | 6003651.13955938 | 2102766.75784402 | 37.754003555820105 | -122.430297777513 | (37.7540035558201, -122.430297777513) | ||
| 82844 | 82844 | 51539 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
| 83006 | 83006 | 68501 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.751535602028206 | -122.46642090906602 | (37.7515356020282, -122.466420909066) | ||
| 83530 | 83530 | 68124 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31872 | 6006189.84017158 | 2099400.84484915 | 37.7449049995041 | -122.421279326768 | (37.7449049995041, -122.421279326768) | ||
| 84031 | 84031 | 40752 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) | ||
| 84074 | 84074 | 66157 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1765 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29228 | 6013882.21689766 | 2094959.68148484 | 37.733141166757896 | -122.39436940843201 | (37.7331411667579, -122.394369408432) | ||
| 84739 | 84739 | 40751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) | ||
| 86251 | 86251 | 39660 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | ||
| 87649 | 87649 | 121661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 88086 | 88086 | 104352 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 304 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | Permit Number 770823 | 6001744.6 | 2103958.8 | 37.757168440961706 | -122.43697636949601 | (37.7571684409617, -122.436976369496) | |||
| 88498 | 88498 | 35377 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38834 | 6011637.61839103 | 2091581.433538 | 37.7237401685956 | -122.401892240977 | (37.7237401685956, -122.401892240977) | ||
| 89767 | 89767 | 51538 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
| 89831 | 89831 | 43002 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 90333 | 90333 | 53193 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.745921466667205 | -122.419059278748 | (37.7459214666672, -122.419059278748) | ||
| 91434 | 91434 | 51948 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48172 | 5996897.19536074 | 2106034.05471344 | 37.7625898542367 | -122.453890338129 | (37.7625898542367, -122.453890338129) | ||||
| 91932 | 91932 | 62709 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1171 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | Permit Number 23049 | 6007422.95308964 | 2118804.22805474 | 37.798251535762205 | -122.418390975112 | (37.7982515357622, -122.418390975112) | ||
| 91943 | 91943 | 60436 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 474 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 20020 | 6003505.36219814 | 2098957.85837164 | 37.743536950172206 | -122.43053014999599 | (37.7435369501722, -122.430530149996) | ||
| 93350 | 93350 | 51537 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
| 93753 | 93753 | 45119 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 94076 | 94076 | 48468 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1409 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/2002 12:00:00 AM | Permit Number 45831 | 6003303.13281599 | 2100036.19716336 | 37.746486359598705 | -122.431306366847 | (37.7464863595987, -122.431306366847) | ||
| 96011 | 96011 | 53145 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1498@ KEITH Underwood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | ||
| 96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 96973 | 96973 | 43489 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.734453664768296 | -122.413002801242 | (37.7344536647683, -122.413002801242) | ||
| 96993 | 96993 | 63825 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 271 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24513 | 6009008.49456519 | 2097079.12708776 | 37.738688578203295 | -122.41136891509899 | (37.7386885782033, -122.411368915099) | ||
| 97036 | 97036 | 47756 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 360St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2002 12:00:00 AM | Permit Number 45536 | 5994029.42937676 | 2099753.03047002 | 37.7451789317369 | -122.463353013703 | (37.7451789317369, -122.463353013703) | |||
| 97044 | 97044 | 68702 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | ||
| 97268 | 97268 | 45125 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 215 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43982 | 6001423.51922816 | 2108204.04749997 | 37.7688065951097 | -122.438390927701 | (37.7688065951097, -122.438390927701) | ||
| 97328 | 97328 | 62145 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 75 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1985 12:00:00 AM | Permit Number 22258 | 6005427.84181989 | 2099597.4165714 | 37.7454017512266 | -122.42392815474899 | (37.7454017512266, -122.423928154749) | ||
| 97694 | 97694 | 63806 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24493 | 6009169.73778237 | 2097426.78712757 | 37.7396522194543 | -122.41083595729299 | (37.7396522194543, -122.410835957293) | ||
| 98472 | 98472 | 68122 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31870 | 6006226.82006776 | 2099469.59440232 | 37.7450958550009 | -122.42115633768 | (37.7450958550009, -122.42115633768) | ||
| 99443 | 99443 | 60142 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | ||
| 99678 | 99678 | 35101 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 774 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38642 | 6001926.16682464 | 2089330.25640032 | 37.71701216685 | -122.435302089615 | (37.71701216685, -122.435302089615) | ||
| 99770 | 99770 | 94077 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116.0 | 2095941.0 | 37.734832022473 | -122.45586253488399 | (37.734832022473, -122.455862534884) | ||
| 99952 | 99952 | 34302 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38090 | 6010338.30191232 | 2101880.05024725 | 37.7519453623814 | -122.407109364623 | (37.7519453623814, -122.407109364623) | ||
| 101018 | 101018 | 33392 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | ||
| 101331 | 101331 | 54097 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1995 12:00:00 AM | Permit Number 9824 | 6000463.76381209 | 2104868.98714017 | 37.759594708041796 | -122.441471294748 | (37.7595947080418, -122.441471294748) | ||
| 102257 | 102257 | 62913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 503 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23293 | 6007737.75654809 | 2096994.92041001 | 37.7383860110425 | -122.41575657686 | (37.7383860110425, -122.41575657686) | ||
| 103091 | 103091 | 62944 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 33 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23326 | 6006898.05353177 | 2097079.16721331 | 37.738570093545796 | -122.41866583942 | (37.7385700935458, -122.41866583942) | ||
| 103775 | 103775 | 62943 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 32 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23325 | 6006886.21663048 | 2097028.33083041 | 37.738429841676 | -122.418703161695 | (37.738429841676, -122.418703161695) | ||
| 104121 | 104121 | 67138 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 453 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 30567 | 6007391.81828007 | 2097290.23033564 | 37.739177413508 | -122.416973583395 | (37.739177413508, -122.416973583395) | ||
| 104124 | 104124 | 61289 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 424 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | Permit Number 21181 | 6007345.32477323 | 2097244.32339637 | 37.7390487477576 | -122.417131085359 | (37.7390487477576, -122.417131085359) | ||
| 104764 | 104764 | 50527 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/2003 12:00:00 AM | Permit Number 47168 | 6001454.91140265 | 2108251.59060829 | 37.7689389222278 | -122.438285751105 | (37.7689389222278, -122.438285751105) | ||
| 105285 | 105285 | 65685 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 265 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28609 | 5995018.52111157 | 2095862.6409490001 | 37.734553819285296 | -122.45965120036101 | (37.7345538192853, -122.459651200361) | ||
| 105369 | 105369 | 62916 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.737909606417496 | -122.415800456905 | (37.7379096064175, -122.415800456905) | ||
| 106193 | 106193 | 47123 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.753887161855104 | -122.47200398758899 | (37.7538871618551, -122.472003987589) | ||
| 106375 | 106375 | 63593 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 24225 | 6005185.44614551 | 2109584.80310454 | 37.7728110766439 | -122.425476960922 | (37.7728110766439, -122.425476960922) | ||
| 106851 | 106851 | 94159 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53536 | 5993712.5 | 2103021.2 | 37.754134227954005 | -122.464686168912 | (37.754134227954, -122.464686168912) | ||
| 107169 | 107169 | 45118 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 107739 | 107739 | 61351 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2435 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33180 | 5983606.72733818 | 2098575.39773775 | 37.741339486665396 | -122.499305352528 | (37.7413394866654, -122.499305352528) | ||
| 107745 | 107745 | 49836 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 572 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/2005 12:00:00 AM | Permit Number 46619 | 6011764.04798466 | 2105724.17808831 | 37.76258017347929 | -122.402449179614 | (37.7625801734793, -122.402449179614) | ||
| 107937 | 107937 | 39659 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.45626220721901 | (37.7199614976995, -122.456262207219) | ||
| 109122 | 109122 | 117509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300x HANOVER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999715.0 | 2086521.0 | 37.7091727618039 | -122.442743399736 | (37.7091727618039, -122.442743399736) | ||||
| 111028 | 111028 | 45121 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 111195 | 111195 | 43490 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 731 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.734453664768296 | -122.413002801242 | (37.7344536647683, -122.413002801242) | ||
| 111681 | 111681 | 81908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50503 | 5991112.7626616 | 2104504.97362674 | 37.7580580577361 | -122.47378484453999 | (37.7580580577361, -122.47378484454) | ||
| 113070 | 113070 | 51536 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
| 113954 | 113954 | 65803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | ||
| 114488 | 114488 | 62940 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 355 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23321 | 6006807.32064873 | 2097065.68374167 | 37.7385279621224 | -122.41897859484399 | (37.7385279621224, -122.418978594844) | ||
| 114576 | 114576 | 61288 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 402 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23284 | 6007176.62571904 | 2097268.48245659 | 37.739105591348704 | -122.417716082945 | (37.7391055913487, -122.417716082945) | ||
| 114879 | 114879 | 31913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2281 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42222 | 5991689.25479737 | 2099914.99470572 | 37.7454885429424 | -122.471456657987 | (37.7454885429424, -122.471456657987) | ||
| 114985 | 114985 | 69148 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2478 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33183 | 5983358.82084368 | 2098279.8149921 | 37.7405133500226 | -122.500140666527 | (37.7405133500226, -122.500140666527) | ||
| 115026 | 115026 | 34301 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38089 | 6010337.06875453 | 2101902.38195398 | 37.7520066112995 | -122.407115203053 | (37.7520066112995, -122.407115203053) | ||
| 115230 | 115230 | 52741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 409@ ALTON Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48790 | 5994026.96721275 | 2101530.61038788 | 37.750059574115895 | -122.46349050523399 | (37.7500595741159, -122.463490505234) | |||
| 115800 | 115800 | 68553 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | ||
| 116961 | 116961 | 68613 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.75205353684021 | -122.474266156198 | (37.7520535368402, -122.474266156198) | ||
| 117825 | 117825 | 41697 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 118047 | 118047 | 87776 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 333 Sussex St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129.0 | 2096659.0 | 37.737089918679 | -122.43858232139401 | (37.737089918679, -122.438582321394) | |||
| 118078 | 118078 | 121664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 118821 | 118821 | 47955 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 59 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2002 12:00:00 AM | Permit Number 45685 | 6001000.20919275 | 2101375.03881203 | 37.7500317183297 | -122.439365554728 | (37.7500317183297, -122.439365554728) | |||
| 118978 | 118978 | 60133 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2012 12:00:00 AM | Permit Number 768747 | 6003532.52706643 | 2096003.65082334 | 37.7354269125656 | -122.43022550454201 | (37.7354269125656, -122.430225504542) | ||
| 119254 | 119254 | 65260 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) |
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");