Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82994 | 82994 | 113610 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
| 83057 | 83057 | 84957 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 8 Kronquist Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002223.0 | 2100219.0 | 37.7469270204759 | -122.43505441311001 | (37.7469270204759, -122.43505441311) | |||||
| 83101 | 83101 | 88726 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1005 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
| 83392 | 83392 | 34838 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 94 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | |||
| 83542 | 83542 | 44320 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2150 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2008 12:00:00 AM | 3x3 | Permit Number 50059 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.43722376982299 | (37.7847020596058, -122.437223769823) | ||
| 83609 | 83609 | 40488 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1999 12:00:00 AM | 5x5 | Permit Number 41567 | 5995790.34429445 | 2107089.36315796 | 37.76542393643229 | -122.457794878244 | (37.7654239364323, -122.457794878244) | ||
| 83694 | 83694 | 75866 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500X 30TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1989 12:00:00 AM | 3x3 | 5986580.0 | 2112184.0 | 37.7788789460419 | -122.49002566353799 | (37.7788789460419, -122.490025663538) | |||
| 83865 | 83865 | 50612 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 231 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2003 12:00:00 AM | Permit Number 47210 | 6006872.46746704 | 2096756.42071917 | 37.7376824626662 | -122.418731421871 | (37.7376824626662, -122.418731421871) | ||
| 83884 | 83884 | 37193 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1726 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1998 12:00:00 AM | Permit Number 39760 | 5986905.42853407 | 2103505.82529925 | 37.7550700890109 | -122.48826198791599 | (37.7550700890109, -122.488261987916) | ||
| 83903 | 83903 | 44315 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2150 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.43722376982299 | (37.7847020596058, -122.437223769823) | |||
| 84018 | 84018 | 46897 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1364 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44953 | 5992430.5821262 | 2106168.20504671 | 37.762701091794 | -122.46934836440902 | (37.762701091794, -122.469348364409) | ||
| 84348 | 84348 | 37902 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1525 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51452 | 5995814.03079033 | 2094240.32165612 | 37.730145036348404 | -122.45678358123001 | (37.7301450363484, -122.45678358123) | ||
| 84728 | 84728 | 103581 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 55X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.42523482670799 | (37.7711001201992, -122.425234826708) | ||||
| 84743 | 84743 | 116631 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 12 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 84812 | 84812 | 96294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 417 Dewey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/25/2011 12:00:00 AM | 3x3 | Permit Number 57003 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | ||
| 84865 | 84865 | 43182 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 350 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42986 | 6008194.87778355 | 2092383.3879698003 | 37.725749426613206 | -122.413849953332 | (37.7257494266132, -122.413849953332) | ||
| 85052 | 85052 | 43399 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 69 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43142 | 6000382.29662695 | 2101283.84473675 | 37.749746137459795 | -122.441495780576 | (37.7497461374598, -122.441495780576) | ||
| 85435 | 85435 | 43382 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 835 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43130 | 6001926.83234227 | 2101663.46629848 | 37.7508763608447 | -122.436181885123 | (37.7508763608447, -122.436181885123) | ||
| 85464 | 85464 | 114955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 50 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | Permit Number 776076 | 6001248.1 | 2094471.5 | 37.7310903246371 | -122.43801389501199 | (37.7310903246371, -122.438013895012) | |||
| 85550 | 85550 | 39502 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 228 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2006 12:00:00 AM | Permit Number 40958 | 6003674.69321501 | 2101013.31571102 | 37.749190349580296 | -122.430091245883 | (37.7491903495803, -122.430091245883) | ||
| 85617 | 85617 | 43403 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 235 Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43146 | 6000671.31740654 | 2103070.12377068 | 37.7546672900273 | -122.440624445322 | (37.7546672900273, -122.440624445322) | ||
| 85629 | 85629 | 42970 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1150 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42856 | 6008002.86607517 | 2092062.71995679 | 37.7248581553879 | -122.41449104478701 | (37.7248581553879, -122.414491044787) | ||
| 85696 | 85696 | 46748 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | |||
| 86045 | 86045 | 47318 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 807A York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45246 | 6009931.15082206 | 2104513.94838888 | 37.75915466398111 | -122.40870315334 | (37.7591546639811, -122.40870315334) | ||
| 86165 | 86165 | 51454 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 501 Crescent Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2004 12:00:00 AM | Permit Number 47772 | 6007598.88566769 | 2095737.65957423 | 37.7349260410204 | -122.416147708857 | (37.7349260410204, -122.416147708857) | |||
| 86281 | 86281 | 46362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3621 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2002 12:00:00 AM | Permit Number 44600 | 6005453.12692671 | 2105447.54952341 | 37.7614662865278 | -122.42425671824101 | (37.7614662865278, -122.424256718241) | |||
| 86415 | 86415 | 33579 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 169 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37687 | 6007131.89501253 | 2098033.82997093 | 37.7412045483591 | -122.417924980998 | (37.7412045483591, -122.417924980998) | |||
| 86596 | 86596 | 48769 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 21 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | Permit Number 46027 | 6004996.28078575 | 2101620.42759661 | 37.7509320998658 | -122.425564375644 | (37.7509320998658, -122.425564375644) | |||
| 86614 | 86614 | 47532 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 250 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45403 | 6004974.92780724 | 2098453.94495454 | 37.7422364593045 | -122.425412899819 | (37.7422364593045, -122.425412899819) | ||
| 86783 | 86783 | 48615 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 Ulloa St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.45586132044201 | (37.7434052350482, -122.455861320442) | ||
| 86823 | 86823 | 86773 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4259 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49745 | 6000836.0 | 2102862.0 | 37.754105209101894 | -122.44004000726002 | (37.7541052091019, -122.44004000726) | |||
| 87208 | 87208 | 92284 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52732 | 5992529.0 | 2098634.0 | 37.7420198013099 | -122.46845979471901 | (37.7420198013099, -122.468459794719) | ||
| 87215 | 87215 | 55704 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 29 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1973 12:00:00 AM | 3x3 | Permit Number 11722 | 6003817.67189064 | 2108181.69074035 | 37.7688810970006 | -122.43010813341101 | (37.7688810970006, -122.430108133411) | ||
| 87610 | 87610 | 88179 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 435 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.779945319801605 | -122.40459520204399 | (37.7799453198016, -122.404595202044) | ||
| 87687 | 87687 | 48919 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2977 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51550 | 6009053.14086522 | 2102721.98826857 | 37.754185131118895 | -122.411613133185 | (37.7541851311189, -122.411613133185) | ||
| 87757 | 87757 | 84016 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 826 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50436 | 6001873.67916989 | 2101682.75665543 | 37.7509263075182 | -122.436367073892 | (37.7509263075182, -122.436367073892) | ||
| 87846 | 87846 | 50089 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 Lenox Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46820 | 5993639.14545893 | 2099165.59898138 | 37.7435435002865 | -122.464659889376 | (37.7435435002865, -122.464659889376) | |||
| 87937 | 87937 | 38522 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4354 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767257 | 6001582.06164415 | 2101191.52240977 | 37.74956092126371 | -122.43734034216699 | (37.7495609212637, -122.437340342167) | |
| 88097 | 88097 | 122530 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1798x Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003948.0 | 2097778.0 | 37.7403223952484 | -122.42891551918899 | (37.7403223952484, -122.428915519189) | ||||
| 88114 | 88114 | 31049 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34804 | 6002647.46614225 | 2087728.93921016 | 37.712656237769 | -122.43269458445499 | (37.712656237769, -122.432694584455) | ||
| 88165 | 88165 | 56637 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1925 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1986 12:00:00 AM | 6001550.67834342 | 2112841.6674483004 | 37.7815475678078 | -122.438283377738 | (37.7815475678078, -122.438283377738) | |||
| 88174 | 88174 | 46880 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2300 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | Permit Number 44939 | 6006358.85800747 | 2118685.04678939 | 37.797864335812704 | -122.422064597009 | (37.7978643358127, -122.422064597009) | ||
| 88189 | 88189 | 113605 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 88272 | 88272 | 106800 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 443 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6011195.0 | 2112052.0 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | |||||
| 88281 | 88281 | 50353 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.381207599 | 2111605.18300999 | 37.778889595817105 | -122.392829354684 | (37.7788895958171, -122.392829354684) | |||
| 88803 | 88803 | 46340 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3742Oaks St. 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2002 12:00:00 AM | Permit Number 44589 | 6005571.08187894 | 2100828.92807079 | 37.748791285843794 | -122.42352039086 | (37.7487912858438, -122.42352039086) | ||
| 88888 | 88888 | 113602 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
| 89047 | 89047 | 49009 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2031REVISED Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | Permit Number 47203 | 6004221.06826057 | 2115296.78098336 | 37.7884402156292 | -122.429220223223 | (37.7884402156292, -122.429220223223) | |||
| 89058 | 89058 | 56849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1043 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | Permit Number 14083 | 5998828.52357861 | 2106301.56148098 | 37.7634349035124 | -122.447229852767 | (37.7634349035124, -122.447229852767) | |||
| 89093 | 89093 | 116527 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5732 GEARY BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | MTA 6 | DPW for City Agency 2 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 89243 | 89243 | 46747 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | ||
| 89261 | 89261 | 105052 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 501X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.6423299997 | 37.779031128568796 | -122.48680778308001 | (37.7790311285688, -122.48680778308) | ||
| 89486 | 89486 | 41526 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1036 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42066 | 6018440.91849108 | 2095073.89345371 | 37.7337071281629 | -122.378616510061 | (37.7337071281629, -122.378616510061) | |||
| 89598 | 89598 | 67676 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1970 Carroll Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012165.49957843 | 2093485.91293956 | 37.7289989246829 | -122.400201126902 | (37.7289989246829, -122.400201126902) | ||
| 89850 | 89850 | 113613 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
| 89958 | 89958 | 83345 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4122 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50808 | 6002892.76964494 | 2104186.76558185 | 37.7578595731657 | -122.433021845922 | (37.7578595731657, -122.433021845922) | ||
| 89971 | 89971 | 35684 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2010 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | Permit Number 38989 | 6004340.08099372 | 2115739.15382331 | 37.7896615965766 | -122.428840007681 | (37.7896615965766, -122.428840007681) | |||
| 90219 | 90219 | 38708 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1900 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40614 | 6000044.14141087 | 2111300.00488868 | 37.7772287555823 | -122.443384488436 | (37.7772287555823, -122.443384488436) | ||
| 90292 | 90292 | 50277 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 149 Benton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46980 | 6005201.31751977 | 2095053.36403777 | 37.732912017304294 | -122.424388296173 | (37.7329120173043, -122.424388296173) | ||
| 90395 | 90395 | 89347 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 767 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2008 12:00:00 AM | 3x3 | Permit Number 51931 | 6001571.0 | 2099979.0 | 37.746230993789794 | -122.437291783871 | (37.7462309937898, -122.437291783871) | ||
| 90836 | 90836 | 112429 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Arguello Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | 5995478.7 | 2115781.3 | 37.789271784254495 | -122.45950233827601 | (37.7892717842545, -122.459502338276) | |||
| 90881 | 90881 | 57825 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 703-705 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1977 12:00:00 AM | Permit Number 16766 | 6001849.12678995 | 2102031.55551925 | 37.7518826308781 | -122.436476940209 | (37.7518826308781, -122.436476940209) | |||
| 91325 | 91325 | 51231 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1130 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47596 | 5997360.62073029 | 2106430.86661879 | 37.763705958456704 | -122.45231616044599 | (37.7637059584567, -122.452316160446) | ||
| 91799 | 91799 | 31658 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1701 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | Permit Number 35165 | 6006154.62451456 | 2116281.19456011 | 37.7912524403664 | -122.422600394963 | (37.7912524403664, -122.422600394963) | |||
| 91813 | 91813 | 60468 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 153 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20061 | 5996949.68072772 | 2089116.47275902 | 37.716141297807106 | -122.452487894641 | (37.7161412978071, -122.452487894641) | ||
| 92291 | 92291 | 92489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2949 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52860 | 5986907.0 | 2098225.0 | 37.7405704530713 | -122.48786857844601 | (37.7405704530713, -122.487868578446) | |
| 92469 | 92469 | 31344 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 254 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39121 | 6006126.25781902 | 2111278.60753762 | 37.7775149666293 | -122.422342949952 | (37.7775149666293, -122.422342949952) | ||
| 92692 | 92692 | 53963 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1034 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 3x3 | Permit Number 9678 | 5999077.6651474 | 2106402.81511165 | 37.7637271532356 | -122.446375440222 | (37.7637271532356, -122.446375440222) | ||
| 93645 | 93645 | 101318 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 35 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6003166.0 | 2108111.0 | 37.7686500673346 | -122.432357170543 | (37.7686500673346, -122.432357170543) | ||||
| 93839 | 93839 | 34839 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 94 Laussat St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | |||
| 93841 | 93841 | 69080 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1260 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33088 | 5992095.70575845 | 2106866.29459996 | 37.7645985029921 | -122.470557418014 | (37.7645985029921, -122.470557418014) | |
| 93966 | 93966 | 42337 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | Permit Number 42542 | 5999190.04276601 | 2094104.98292203 | 37.729966699864505 | -122.44510258901899 | (37.7299666998645, -122.445102589019) | ||
| 93971 | 93971 | 41269 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 44 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1999 12:00:00 AM | Permit Number 47888 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | ||
| 94468 | 94468 | 52208 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2741 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2005 12:00:00 AM | Permit Number 48392 | 6002435.29628109 | 2096108.68410714 | 37.735653100990795 | -122.43402654359 | (37.7356531009908, -122.43402654359) | |||
| 94550 | 94550 | 94909 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2010 12:00:00 AM | 3x3 | Permit Number 53967 | 6006333.4 | 2113725.5 | 37.7842452193163 | -122.421800223368 | (37.7842452193163, -122.421800223368) | ||
| 94552 | 94552 | 47547 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 42 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45411 | 6004848.5926145 | 2101664.35736028 | 37.751044374772206 | -122.42607822279 | (37.7510443747722, -122.42607822279) | ||
| 94673 | 94673 | 85362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2007 12:00:00 AM | Permit Number 49639 | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |||
| 94739 | 94739 | 85383 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1970 Carroll Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012142.9 | 2093507.8 | 37.72905776185829 | -122.40028079247 | (37.7290577618583, -122.40028079247) | |||
| 94911 | 94911 | 35165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38697 | 6002278.53676 | 2109613.08998269 | 37.7727240736295 | -122.435534302131 | (37.7727240736295, -122.435534302131) | ||
| 95025 | 95025 | 46669 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44798 | 5991496.386577 | 2105807.77483853 | 37.7616574165081 | -122.47255310345 | (37.7616574165081, -122.47255310345) | ||
| 95039 | 95039 | 100179 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2012 12:00:00 AM | 3x3 | 6003851.0 | 2100874.0 | 37.748817804949496 | -122.42947164058 | (37.7488178049495, -122.42947164058) | |||
| 95271 | 95271 | 44314 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2150 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.43722376982299 | (37.7847020596058, -122.437223769823) | |||
| 95361 | 95361 | 85384 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1970 Carroll Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49654 | 6012142.9 | 2093507.8 | 37.72905776185829 | -122.40028079247 | (37.7290577618583, -122.40028079247) | |||
| 95421 | 95421 | 88122 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 901 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493.0 | 2102968.0 | 37.754490450787394 | -122.434317282412 | (37.7544904507874, -122.434317282412) | ||
| 95482 | 95482 | 44316 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2150 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.43722376982299 | (37.7847020596058, -122.437223769823) | |||
| 95542 | 95542 | 44455 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 95792 | 95792 | 51455 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 501 Crescent Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2004 12:00:00 AM | Permit Number 47772 | 6007598.88566769 | 2095737.65957423 | 37.7349260410204 | -122.416147708857 | (37.7349260410204, -122.416147708857) | |||
| 95931 | 95931 | 68899 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4400 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6x6 | Permit Number 32872 | 6001420.14325733 | 2104691.52750308 | 37.7591618858697 | -122.438150951669 | (37.7591618858697, -122.438150951669) | |
| 95967 | 95967 | 110933 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | |||||
| 96163 | 96163 | 50088 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 Lenox Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46820 | 5993639.14545893 | 2099165.59898138 | 37.7435435002865 | -122.464659889376 | (37.7435435002865, -122.464659889376) | |||
| 96186 | 96186 | 103579 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.42541726943199 | (37.772264815602, -122.425417269432) | ||||
| 96300 | 96300 | 42017 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420553999 | (37.728283289236, -122.46489420554) | ||
| 96411 | 96411 | 110932 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | |||||
| 96528 | 96528 | 68858 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 270 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | 7x5 | Permit Number 32821 | 5999625.60484237 | 2094393.46674957 | 37.730783660166395 | -122.443617519141 | (37.7307836601664, -122.443617519141) | |
| 96561 | 96561 | 112293 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 501x 27TH AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3xe | 5987510.0 | 2112219.0 | 37.7790293092803 | -122.486811036923 | (37.7790293092803, -122.486811036923) | ||||
| 96577 | 96577 | 39797 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 96606 | 96606 | 39362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2433 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40917 | 6008235.29946712 | 2104260.15851816 | 37.7583626864034 | -122.41455027836001 | (37.7583626864034, -122.41455027836) | ||
| 96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 96663 | 96663 | 45449 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 191 Corona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 96667 | 96667 | 41086 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1453 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | Permit Number 41837 | 6007800.381467599 | 2110226.65901823 | 37.7747208599359 | -122.41647704978998 | (37.7747208599359, -122.41647704979) |
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");