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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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 | |||||||||
| 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) | |||
| 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) | |
| 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) | |
| 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 | |||||||||
| 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) | |
| 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) | |
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 3163 | 3163 | 239955 | Permitted Site 1 | Tree(s) :: 17 | 3448 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 50576 | 6006541.34834 | 2105555.1929200003 | 37.761823236687604 | -122.420500644884 | (37.7618232366876, -122.420500644884) | |
| 3178 | 3178 | 48242 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3191 | 3191 | 21648 | DPW Maintained 3 | Tree(s) :: 17 | 1660 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6004632.9541 | 2114713.0403 | 37.7868607185832 | -122.427753554263 | (37.7868607185832, -122.427753554263) | |||
| 3193 | 3193 | 48299 | Permitted Site 1 | Tree(s) :: 17 | 133 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3198 | 3198 | 253367 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | Permit Number 23367 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | |||
| 3227 | 3227 | 48059 | Permitted Site 1 | Tree(s) :: 17 | 230 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3265 | 3265 | 48539 | Permitted Site 1 | Tree(s) :: 17 | 501X Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 7 | Permit Number 780589 | 6015606.3859 | 2106251.46172 | 37.7642417312884 | -122.389196628536 | (37.7642417312884, -122.389196628536) | ||
| 3266 | 3266 | 44618 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3282 | 3282 | 48541 | Permitted Site 1 | Tree(s) :: 17 | 501X Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 10 | Permit Number 780589 | 6015626.164890001 | 2106252.31094 | 37.7642451595212 | -122.389128277346 | (37.7642451595212, -122.389128277346) | ||
| 3285 | 3285 | 44952 | Permitted Site 1 | Tree(s) :: 17 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3290 | 3290 | 184185 | Permitted Site 1 | Tree(s) :: 17 | 1651 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780218 | 5981567.9659 | 2103842.5530000003 | 37.7556817980764 | -122.50674512418001 | (37.7556817980764, -122.50674512418) | |
| 3291 | 3291 | 41799 | Permitted Site 1 | Tree(s) :: 17 | 101 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780552 | 6011423.81805 | 2107722.81991 | 37.7680489940823 | -122.403766558473 | (37.7680489940823, -122.403766558473) |
| 3294 | 3294 | 108946 | Permitted Site 1 | Tree(s) :: 17 | 1639 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780178 | 5981566.1325 | 2103905.1958 | 37.7558536894504 | -122.506756110588 | (37.7558536894504, -122.506756110588) | |
| 3297 | 3297 | 44585 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3309 | 3309 | 202650 | Undocumented 2 | Tree(s) :: 17 | 1737 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780552 | 6011487.99785 | 2107902.18545 | 37.7685450763114 | -122.40355718732201 | (37.7685450763114, -122.403557187322) | |
| 3322 | 3322 | 44559 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3393 | 3393 | 33932 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1997 12:00:00 AM | Permit Number 37893 | |||||||||
| 3408 | 3408 | 44959 | Permitted Site 1 | Tree(s) :: 17 | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3444 | 3444 | 48277 | Permitted Site 1 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3448 | 3448 | 48107 | Permitted Site 1 | Tree(s) :: 17 | 202 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3458 | 3458 | 44636 | Permitted Site 1 | Tree(s) :: 17 | 164 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3543 | 3543 | 44857 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3614 | 3614 | 46882 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2002 12:00:00 AM | Permit Number 44940 | |||||||||
| 3619 | 3619 | 57940 | Permitted Site 1 | Tree(s) :: 17 | 11 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Permit Number 780209 | 5999349.33146 | 2086666.4208799999 | 37.709551202089 | -122.444017643915 | (37.709551202089, -122.444017643915) |
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");