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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1418 | 1418 | 48339 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1455 | 1455 | 184625 | Permitted Site 1 | Tree(s) :: 17 | 1762 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2017 12:00:00 AM | 3 | 4x4 | Permit Number 778834 | 5981059.357000001 | 2103059.0208 | 37.7535004788576 | -122.50844586217698 | (37.7535004788576, -122.508445862177) | |
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1486 | 1486 | 251555 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 1499 | 1499 | 44884 | Permitted Site 1 | Tree(s) :: 17 | 157 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 1501 | 1501 | 251554 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1510 | 1510 | 251552 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1511 | 1511 | 45972 | Permitted Site 1 | Tree(s) :: 17 | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1526 | 1526 | 44588 | Permitted Site 1 | Tree(s) :: 17 | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1532 | 1532 | 44561 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1591 | 1591 | 63351 | Permitted Site 1 | Tree(s) :: 17 | 3020 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780039 | 6000130.91921 | 2115807.05661 | 37.7896089046631 | -122.44340811579501 | (37.7896089046631, -122.443408115795) | |
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 1691 | 1691 | 251656 | Undocumented 2 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | 5999423.0 | 2096089.0 | 37.7354276387403 | -122.44443976141001 | (37.7354276387403, -122.44443976141) | ||||
| 1734 | 1734 | 247340 | Permitted Site 1 | Tree(s) :: 17 | 307 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779988 | 6003225.5695 | 2109437.2242 | 37.7722949315945 | -122.43224585173401 | (37.7722949315945, -122.432245851734) | |
| 1764 | 1764 | 33168 | Permitted Site 1 | Tree(s) :: 17 | 2221 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773963 | 5986287.4 | 2098860.0 | 37.7422778317635 | -122.490057581406 | (37.7422778317635, -122.490057581406) | |
| 1765 | 1765 | 45968 | Permitted Site 1 | Tree(s) :: 17 | 155 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
| 1804 | 1804 | 44554 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1819 | 1819 | 137922 | Undocumented 2 | Tree(s) :: 17 | 1901 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780002 | 6003374.5786 | 2115313.2333 | 37.7884374328961 | -122.432150117212 | (37.7884374328961, -122.432150117212) | |
| 1823 | 1823 | 38862 | Permitted Site 1 | Tree(s) :: 17 | 1551 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779966 | 5989293.07470895 | 2104790.33093507 | 37.7587360109051 | -122.4800989152 | (37.7587360109051, -122.4800989152) | |
| 1860 | 1860 | 251510 | Undocumented 2 | Tree(s) :: 17 | 498X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013725.0 | 2112487.0 | 37.7812586433919 | -122.396140887502 | (37.7812586433919, -122.396140887502) | |
| 1863 | 1863 | 33121 | Permitted Site 1 | Tree(s) :: 17 | 2360 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2017 12:00:00 AM | 3 | Permit Number 780047 | 6001597.15977 | 2119079.49 | 37.7986776600995 | -122.438569654391 | (37.7986776600995, -122.438569654391) | |
| 1864 | 1864 | 44087 | Permitted Site 1 | Tree(s) :: 17 | 500 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013716.56338 | 2112456.73733 | 37.7811750796017 | -122.396167952707 | (37.7811750796017, -122.396167952707) | |
| 1865 | 1865 | 251511 | Undocumented 2 | Tree(s) :: 17 | 498X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013725.0 | 2112487.0 | 37.7812586433919 | -122.396140887502 | (37.7812586433919, -122.396140887502) | |
| 1877 | 1877 | 125609 | Undocumented 2 | Tree(s) :: 17 | 3620 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779927 | 5997454.92356 | 2115432.53824 | 37.7884276100946 | -122.45263969527599 | (37.7884276100946, -122.452639695276) | |
| 1885 | 1885 | 30481 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | Permit Number 147 | |||||||||
| 1934 | 1934 | 252840 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 80 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997842.0 | 2113206.0 | 37.782336294689 | -122.45113984781099 | (37.782336294689, -122.451139847811) | ||||
| 1959 | 1959 | 48104 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1967 | 1967 | 138282 | DPW Maintained 3 | Tree(s) :: 17 | 1202 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6003789.8642 | 2112168.8213 | 37.7798272025121 | -122.430488845982 | (37.7798272025121, -122.430488845982) | |||
| 1972 | 1972 | 252849 | Undocumented 2 | Tree(s) :: 17 | 200 Woodside Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996376.0 | 2100052.0 | 37.7461347404292 | -122.455260624993 | (37.7461347404292, -122.455260624993) | ||||
| 1973 | 1973 | 66343 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | Permit Number 29464 | |||||||||
| 1979 | 1979 | 111294 | Undocumented 2 | Tree(s) :: 17 | 3099X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779770 | 5999406.60634 | 2116314.04213 | 37.79095962162621 | -122.44595063322201 | (37.7909596216262, -122.445950633222) | |
| 2006 | 2006 | 252850 | Undocumented 2 | Tree(s) :: 17 | 2 Hernandez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996271.0 | 2100083.0 | 37.7462138338134 | -122.45562593978599 | (37.7462138338134, -122.455625939786) | ||||
| 2019 | 2019 | 48201 | Permitted Site 1 | Tree(s) :: 17 | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 2023 | 2023 | 35053 | Permitted Site 1 | Tree(s) :: 17 | 700 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 2039 | 2039 | 45572 | Permitted Site 1 | Tree(s) :: 17 | 1951 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2017 12:00:00 AM | 3 | Permit Number 779446 | 5999433.18152 | 2115607.6653299998 | 37.7890216140951 | -122.44580786133999 | (37.7890216140951, -122.44580786134) | |
| 2045 | 2045 | 124757 | Undocumented 2 | Tree(s) :: 17 | 2040 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779873 | 6003680.83051 | 2117635.7933099996 | 37.7948319494745 | -122.431256385468 | (37.7948319494745, -122.431256385468) | |
| 2046 | 2046 | 131756 | Undocumented 2 | Tree(s) :: 17 | 1818 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004733.3748 | 2117781.6991 | 37.795292161346104 | -122.427624834041 | (37.7952921613461, -122.427624834041) | |||
| 2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
| 2053 | 2053 | 124756 | Undocumented 2 | Tree(s) :: 17 | 2040 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779873 | 6003696.79526 | 2117638.17776 | 37.794839401275894 | -122.431201315505 | (37.7948394012759, -122.431201315505) | |
| 2059 | 2059 | 173596 | Significant Tree 6 | Tree(s) :: 17 | 200 Howard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 779179 | 6014439.0 | 2115766.0 | 37.790301726009204 | -122.393900378517 | (37.7903017260092, -122.393900378517) | |||
| 2086 | 2086 | 45988 | Permitted Site 1 | Tree(s) :: 17 | 223 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 2111 | 2111 | 196623 | Undocumented 2 | Tree(s) :: 17 | 147 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780162 | 6012460.77279 | 2114398.06463 | 37.7864355596035 | -122.40064880949 | (37.7864355596035, -122.40064880949) | |
| 2115 | 2115 | 44893 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2154 | 2154 | 45014 | Permitted Site 1 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2165 | 2165 | 126954 | Undocumented 2 | Tree(s) :: 17 | 419 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780142 | 5998133.78034 | 2114953.67276 | 37.7871516456883 | -122.450256437883 | (37.7871516456883, -122.450256437883) | |
| 2169 | 2169 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 2180 | 2180 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026.0 | 2116224.0 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | |
| 2184 | 2184 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 2193 | 2193 | 46043 | Permitted Site 1 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2195 | 2195 | 44993 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2215 | 2215 | 62177 | Permitted Site 1 | Tree(s) :: 17 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | 15 | 3x3 | Permit Number 780357 | 6000151.498869999 | 2091775.04378 | 37.723624054296295 | -122.44161159051599 | (37.7236240542963, -122.441611590516) |
| 2228 | 2228 | 167815 | Undocumented 2 | Tree(s) :: 17 | 282 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | Permit Number 780344 | 6004374.21371 | 2109126.69451 | 37.771507353225395 | -122.42825045191799 | (37.7715073532254, -122.428250451918) | ||
| 2304 | 2304 | 44646 | Permitted Site 1 | Tree(s) :: 17 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 2366 | 2366 | 44966 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2404 | 2404 | 67784 | Permitted Site 1 | Tree(s) :: 17 | 1030 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31421 | ||||||||
| 2434 | 2434 | 48283 | Permitted Site 1 | Tree(s) :: 17 | 93 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 2470 | 2470 | 211684 | Undocumented 2 | Tree(s) :: 17 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 780277 | 5995309.61761 | 2090529.04665 | 37.719925789337296 | -122.458258879737 | (37.7199257893373, -122.458258879737) | ||
| 2476 | 2476 | 212596 | Undocumented 2 | Tree(s) :: 17 | 310 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 780017 | 5994766.80041 | 2090657.2902900001 | 37.7202467087903 | -122.46014448379299 | (37.7202467087903, -122.460144483793) | ||
| 2478 | 2478 | 211685 | Undocumented 2 | Tree(s) :: 17 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 780277 | 5995307.7579 | 2090507.37878 | 37.7198661876486 | -122.458263740606 | (37.7198661876486, -122.458263740606) | ||
| 2479 | 2479 | 251647 | Permitted Site 1 | Tree(s) :: 17 | 690 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780215 | 6007452.0 | 2105652.0 | 37.7621403241605 | -122.417357915219 | (37.7621403241605, -122.417357915219) | |
| 2482 | 2482 | 245639 | Undocumented 2 | Tree(s) :: 17 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007964.74692 | 2102552.0898 | 37.7536575156842 | -122.415365052856 | (37.7536575156842, -122.415365052856) | |||
| 2494 | 2494 | 183346 | Undocumented 2 | Tree(s) :: 17 | 1218 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780189 | 5983062.3107 | 2106821.3399 | 37.7639485863173 | -122.50179767328699 | (37.7639485863173, -122.501797673287) | |
| 2497 | 2497 | 252857 | Undocumented 2 | Tree(s) :: 17 | 124 Persia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 780172 | 6002102.0 | 2091308.0 | 37.7224525933916 | -122.43483567372 | (37.7224525933916, -122.43483567372) | |||
| 2507 | 2507 | 137731 | Permitted Site 1 | Tree(s) :: 17 | 610 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780365 | 6000144.0 | 2111022.0 | 37.7764711190239 | -122.44301907684799 | (37.7764711190239, -122.443019076848) | |
| 2525 | 2525 | 9534 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.42922989330201 | (37.779990692526, -122.429229893302) | |
| 2564 | 2564 | 126730 | Undocumented 2 | Tree(s) :: 17 | 2839 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780358 | 5999405.85549 | 2118032.7905200003 | 37.7956788068866 | -122.44607691062001 | (37.7956788068866, -122.44607691062) | |
| 2571 | 2571 | 253124 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 | ||||||
| 2583 | 2583 | 253127 | Permitted Site 1 | Tree(s) :: 17 | 1639 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780367 | 5982187.14146 | 2103946.19954 | 37.7560028231362 | -122.50461153424999 | (37.7560028231362, -122.50461153425) | |
| 2618 | 2618 | 55203 | Permitted Site 1 | Tree(s) :: 17 | 40 Dalmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1972 12:00:00 AM | Permit Number 11116 | ||||||||
| 2627 | 2627 | 44896 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2630 | 2630 | 44978 | Permitted Site 1 | Tree(s) :: 17 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2644 | 2644 | 124734 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 2658 | 2658 | 18040 | Permitted Site 1 | Tree(s) :: 17 | 2814 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2012 12:00:00 AM | 12 | 3X3 | Permit Number 768742 | 6000432.8759 | 2114826.5316 | 37.7869338528481 | -122.442292960737 | (37.7869338528481, -122.442292960737) | |
| 2673 | 2673 | 46063 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 2711 | 2711 | 236726 | Permitted Site 1 | Tree(s) :: 17 | 1614 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780101 | 6002560.74433 | 2100754.3551 | 37.7484161516874 | -122.433924785525 | (37.7484161516874, -122.433924785525) | |
| 2726 | 2726 | 46033 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2769 | 2769 | 17844 | DPW Maintained 3 | Tree(s) :: 17 | 2064 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780190 | 6004071.9084 | 2115331.7333 | 37.7885277407175 | -122.429738786656 | (37.7885277407175, -122.429738786656) | |
| 2798 | 2798 | 223230 | Permitted Site 1 | Tree(s) :: 17 | 3856 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780428 | 6004041.47078 | 2102494.505 | 37.7532781151154 | -122.42892851016501 | (37.7532781151154, -122.428928510165) | |
| 2816 | 2816 | 253217 | Permitted Site 1 | Tree(s) :: 17 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | 3x3 | 6001651.75029 | 2086494.56012 | 37.7092103839364 | -122.436047813177 | (37.7092103839364, -122.436047813177) | ||
| 2823 | 2823 | 184564 | Undocumented 2 | Tree(s) :: 17 | 4045 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780224 | 5981651.1237 | 2103482.1376 | 37.7546970960302 | -122.50643081650401 | (37.7546970960302, -122.506430816504) | |
| 2830 | 2830 | 86908 | Permitted Site 1 | Tree(s) :: 17 | 65 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780355 | 6001653.18429 | 2120872.6628099997 | 37.80360442595129 | -122.43850433841601 | (37.8036044259513, -122.438504338416) | |
| 2860 | 2860 | 44877 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
| 2887 | 2887 | 209188 | Undocumented 2 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.818630001 | 2098534.27999 | 37.7418782818471 | -122.46051787510599 | (37.7418782818471, -122.460517875106) | |
| 2904 | 2904 | 44678 | Permitted Site 1 | Tree(s) :: 17 | 98 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 2917 | 2917 | 232336 | Permitted Site 1 | Tree(s) :: 17 | 4422 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780411 | 6000473.59133 | 2101711.39463 | 37.750925287192004 | -122.441210752783 | (37.750925287192, -122.441210752783) | |
| 2945 | 2945 | 44998 | Permitted Site 1 | Tree(s) :: 17 | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2960 | 2960 | 44920 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2977 | 2977 | 10292 | DPW Maintained 3 | Tree(s) :: 17 | 488 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x4 | 6003826.4075 | 2109393.9739 | 37.7722102257422 | -122.43016441338301 | (37.7722102257422, -122.430164413383) | |||
| 3027 | 3027 | 45855 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3048 | 3048 | 253287 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.7941400001 | 37.727152059320204 | -122.383990506478 | (37.7271520593202, -122.383990506478) | |
| 3061 | 3061 | 61313 | Permitted Site 1 | Tree(s) :: 17 | 1355 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2017 12:00:00 AM | 3 | Permit Number 780590 | 6011741.38821 | 2102064.0767099997 | 37.752529078769896 | -122.402270200829 | (37.7525290787699, -122.402270200829) | |
| 3070 | 3070 | 116407 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | ||||
| 3090 | 3090 | 44576 | Permitted Site 1 | Tree(s) :: 17 | 140 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3118 | 3118 | 48324 | Permitted Site 1 | Tree(s) :: 17 | 176 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3134 | 3134 | 44852 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 |
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");