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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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) | |
| 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) | |
| 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 | |||||||||
| 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) | ||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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) | ||
| 3636 | 3636 | 64705 | Permitted Site 1 | Tree(s) :: 17 | 252 Walker Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1988 12:00:00 AM | Permit Number 25649 | ||||||||
| 3649 | 3649 | 253514 | Permitted Site 1 | Tree(s) :: 17 | 128 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | Permit No. 49290 | 5994510.638119999 | 2105337.44986 | 37.760540036372205 | -122.46209399567199 | (37.7605400363722, -122.462093995672) | |||
| 3665 | 3665 | 115481 | Permitted Site 1 | Tree(s) :: 17 | 1277 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779302 | 5987681.0372 | 2106596.6773 | 37.7636019470532 | -122.48580658869 | (37.7636019470532, -122.48580658869) | |
| 3695 | 3695 | 57738 | Permitted Site 1 | Tree(s) :: 17 | 1999 So. Bascom Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | Permit Number 16656 | ||||||||
| 3702 | 3702 | 143025 | Permitted Site 1 | Tree(s) :: 17 | 2147 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51763 | 6008956.6469 | 2120652.8991 | 37.803413743220794 | -122.413214712493 | (37.8034137432208, -122.413214712493) | |
| 3751 | 3751 | 45854 | Permitted Site 1 | Tree(s) :: 17 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3765 | 3765 | 45857 | Permitted Site 1 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3838 | 3838 | 48141 | Permitted Site 1 | Tree(s) :: 17 | 251 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3864 | 3864 | 44703 | Permitted Site 1 | Tree(s) :: 17 | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3875 | 3875 | 48176 | Permitted Site 1 | Tree(s) :: 17 | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3909 | 3909 | 48174 | Permitted Site 1 | Tree(s) :: 17 | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3912 | 3912 | 38150 | Permitted Site 1 | Tree(s) :: 17 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 12:00:00 AM | 3 | Permit Number 780230 | 6010281.37407 | 2093721.8548299999 | 37.7295415331127 | -122.40673134359899 | (37.7295415331127, -122.406731343599) | |
| 3927 | 3927 | 237534 | Permitted Site 1 | Tree(s) :: 17 | 95 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780607 | 6004126.32591 | 2102520.81642 | 37.7533551627335 | -122.42863693913999 | (37.7533551627335, -122.42863693914) | |
| 3963 | 3963 | 237535 | Permitted Site 1 | Tree(s) :: 17 | 95 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780607 | 6004123.30299 | 2102536.9133099997 | 37.7533991899358 | -122.428648540392 | (37.7533991899358, -122.428648540392) | |
| 3965 | 3965 | 253596 | Permitted Site 1 | Tree(s) :: 17 | 198X Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780230 | ||||||
| 4038 | 4038 | 45886 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4053 | 4053 | 45907 | Permitted Site 1 | Tree(s) :: 17 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4084 | 4084 | 45961 | Permitted Site 1 | Tree(s) :: 17 | 162 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4133 | 4133 | 48248 | Permitted Site 1 | Tree(s) :: 17 | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4256 | 4256 | 44534 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4347 | 4347 | 45877 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4378 | 4378 | 45905 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4443 | 4443 | 67752 | Permitted Site 1 | Tree(s) :: 17 | 2281 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | Permit Number 31376 | ||||||||
| 4492 | 4492 | 44688 | Permitted Site 1 | Tree(s) :: 17 | 108 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4519 | 4519 | 46000 | Permitted Site 1 | Tree(s) :: 17 | 118 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4531 | 4531 | 48083 | Permitted Site 1 | Tree(s) :: 17 | 193 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4552 | 4552 | 97357 | Permitted Site 1 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4576 | 4576 | 60252 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/1982 12:00:00 AM | Permit Number 19804 | |||||||||
| 4714 | 4714 | 44605 | Permitted Site 1 | Tree(s) :: 17 | 148 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4740 | 4740 | 124733 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 4741 | 4741 | 48244 | Permitted Site 1 | Tree(s) :: 17 | 122 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 4774 | 4774 | 44595 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4823 | 4823 | 45930 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4831 | 4831 | 44933 | Permitted Site 1 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 4913 | 4913 | 97358 | Permitted Site 1 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4926 | 4926 | 43081 | Permitted Site 1 | Tree(s) :: 17 | 205 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2017 12:00:00 AM | 3 | Permit Number 780320 | 6009005.07972 | 2113286.70602 | 37.783190697721 | -122.41252609371901 | (37.783190697721, -122.412526093719) | ||
| 4991 | 4991 | 35276 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 5018 | 5018 | 44607 | Permitted Site 1 | Tree(s) :: 17 | 171 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5025 | 5025 | 9541 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856000001 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | |
| 5119 | 5119 | 225335 | Permitted Site 1 | Tree(s) :: 17 | 61 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780862 | 6002430.10304 | 2096559.5166 | 37.7368906885412 | -122.43407671607099 | (37.7368906885412, -122.434076716071) | |
| 5121 | 5121 | 45851 | Permitted Site 1 | Tree(s) :: 17 | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5128 | 5128 | 44995 | Permitted Site 1 | Tree(s) :: 17 | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5130 | 5130 | 240879 | Permitted Site 1 | Tree(s) :: 17 | 3659 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780848 | 6005174.01235 | 2105435.79092 | 37.7614182359708 | -122.42522122409201 | (37.7614182359708, -122.425221224092) | |
| 5147 | 5147 | 48270 | Permitted Site 1 | Tree(s) :: 17 | 94 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5154 | 5154 | 253212 | Permitted Site 1 | Tree(s) :: 17 | 15 Liberty St | 2 | Side Yard : Cutout 18 | tree 3 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 5x5 | Permit Number 780777 | 6006173.0 | 2104008.0 | 37.75755424109929 | -122.421664722498 | (37.7575542410993, -122.421664722498) | |
| 5155 | 5155 | 223052 | Permitted Site 1 | Tree(s) :: 17 | 50 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780696 | 6001430.01657 | 2107860.7272200002 | 37.7678642922401 | -122.438343854404 | (37.7678642922401, -122.438343854404) | |
| 5156 | 5156 | 44926 | Permitted Site 1 | Tree(s) :: 17 | 199 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5208 | 5208 | 48263 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 |
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");