Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 8822 | 8822 | 36564 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 9595 | 9595 | 35817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 10191 | 10191 | 35689 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10366 | 10366 | 46719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 10578 | 10578 | 39903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 10962 | 10962 | 33089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 11036 | 11036 | 36559 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 11116 | 11116 | 34003 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12311 | 12311 | 39902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 12475 | 12475 | 36562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 12686 | 12686 | 35818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 13380 | 13380 | 36560 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13673 | 13673 | 33088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 13881 | 13881 | 35819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 14741 | 14741 | 33082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14773 | 14773 | 46721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15188 | 15188 | 34004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 15368 | 15368 | 33086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15498 | 15498 | 35820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
| 15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15858 | 15858 | 33090 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 16147 | 16147 | 36565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16437 | 16437 | 36563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16615 | 16615 | 46720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 101348 | 101348 | 27884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.4130000002 | 37.5090039879895 | -122.38142014589701 | (37.5090039879895, -122.381420145897) | |||
| 142399 | 142399 | 36233 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5698 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 3x3 | Permit Number 39264 | 5997821.10019036 | 2086869.6666529 | 37.710021971633296 | -122.449314082525 | (37.7100219716333, -122.449314082525) | ||
| 144595 | 144595 | 36235 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5698 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39264 | 5997821.10019036 | 2086869.6666529 | 37.710021971633296 | -122.449314082525 | (37.7100219716333, -122.449314082525) | |||
| 110518 | 110518 | 36243 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 110658 | 110658 | 36242 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 112323 | 112323 | 36244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 116618 | 116618 | 36241 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5694 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39266 | 5997860.0334642 | 2086885.30228194 | 37.710067130450504 | -122.449180647912 | (37.7100671304505, -122.449180647912) | |||
| 143202 | 143202 | 36240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5680 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | Permit Number 39265 | 5997984.77377446 | 2086951.33234778 | 37.7102555679665 | -122.44875427577298 | (37.7102555679665, -122.448754275773) | |||
| 11599 | 11599 | 1188 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3023 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5996633.13731 | 2087220.7977599998 | 37.7109180726785 | -122.453445224323 | (37.7109180726785, -122.453445224323) | |||
| 12008 | 12008 | 1186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3021 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5996654.59932 | 2087233.67855 | 37.7109546705803 | -122.453371976343 | (37.7109546705803, -122.453371976343) | |||
| 22046 | 22046 | 19095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 261 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5994400.34264 | 2087392.3938799999 | 37.7112609940588 | -122.461174661688 | (37.7112609940588, -122.461174661688) | |||
| 99853 | 99853 | 19066 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995202.5823827 | 2087398.1206165 | 37.711322853670104 | -122.45840235248001 | (37.7113228536701, -122.45840235248) | |||
| 12890 | 12890 | 1261 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3833 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X6 | 5992776.62471 | 2087495.32693 | 37.7114500468546 | -122.466794068292 | (37.7114500468546, -122.466794068292) | |||
| 127301 | 127301 | 19081 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 224 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 5994792.47561 | 2087468.61728 | 37.7114928446183 | -122.459824878953 | (37.7114928446183, -122.459824878953) | ||||
| 11773 | 11773 | 109059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1126 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772776 | 6001371.73977 | 2087888.1678900002 | 37.7130210113759 | -122.437115282467 | (37.7130210113759, -122.437115282467) |
| 12326 | 12326 | 113363 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 126 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x6 | Permit Number 776810 | 5991720.20644 | 2088367.09772 | 37.7137826921811 | -122.470508741378 | (37.7137826921811, -122.470508741378) | ||
| 74400 | 74400 | 105470 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 77899 | 77899 | 105477 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 85521 | 85521 | 105467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 89404 | 89404 | 105468 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 90134 | 90134 | 105485 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 92437 | 92437 | 105486 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 92986 | 92986 | 105482 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 98979 | 98979 | 105480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 106191 | 106191 | 105479 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 107323 | 107323 | 105474 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 107452 | 107452 | 105466 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 111563 | 111563 | 105472 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 117705 | 117705 | 105487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 118857 | 118857 | 105469 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 122946 | 122946 | 105471 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 124065 | 124065 | 105476 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 125780 | 125780 | 105481 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 127059 | 127059 | 105484 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 139072 | 139072 | 105478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014874.7 | 2088927.9 | 37.7166342161119 | -122.390516776389 | (37.7166342161119, -122.390516776389) | ||
| 105029 | 105029 | 105483 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014353.8 | 2089169.6 | 37.7172689657855 | -122.39233417718201 | (37.7172689657855, -122.392334177182) | ||
| 109271 | 109271 | 105488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 772170 | 6014353.8 | 2089169.6 | 37.7172689657855 | -122.39233417718201 | (37.7172689657855, -122.392334177182) | |||
| 122296 | 122296 | 105473 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 833 Jamestown Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2014 12:00:00 AM | 3x3 | Permit Number 772170 | 6014353.8 | 2089169.6 | 37.7172689657855 | -122.39233417718201 | (37.7172689657855, -122.392334177182) | ||
| 38675 | 38675 | 54001 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 19 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 12 | Permit Number 9719 | 6010666.13404 | 2089379.87515 | 37.717640876409604 | -122.405095569414 | (37.7176408764096, -122.405095569414) | ||
| 184602 | 184602 | 54000 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 19 | Permit Number 9718 | 6010673.62628 | 2089402.8086700002 | 37.71770426600779 | -122.40507128591001 | (37.7177042660078, -122.40507128591) | ||
| 10459 | 10459 | 1079 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2133 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6000101.3096199995 | 2089802.83807 | 37.718205967213 | -122.441643618974 | (37.718205967213, -122.441643618974) | |||
| 12800 | 12800 | 1083 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2150 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 5999998.5130900005 | 2089822.2609599999 | 37.718253440618504 | -122.44200033506901 | (37.7182534406185, -122.442000335069) | |||
| 10491 | 10491 | 1075 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2119 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6000135.00359 | 2089836.3366200002 | 37.7182998663217 | -122.44152955615299 | (37.7182998663217, -122.441529556153) | ||||
| 13175 | 13175 | 1076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2124 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000057.48494 | 2089881.91046 | 37.7184205850222 | -122.441800773687 | (37.7184205850222, -122.441800773687) | |||
| 10562 | 10562 | 1073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2118 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000085.1139 | 2089908.73955 | 37.7184958258874 | -122.44170719653201 | (37.7184958258874, -122.441707196532) | |||
| 87417 | 87417 | 94437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3711@533 Gonzalez 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2010 12:00:00 AM | 32 | Permit Number 53664 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | ||
| 80722 | 80722 | 1026 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1955X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6000855.2579 | 2090665.6856099998 | 37.7206180798117 | -122.439099353738 | (37.7206180798117, -122.439099353738) | |||
| 10666 | 10666 | 108381 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 204 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773815 | 6001936.176109999 | 2090655.40431 | 37.7206512958141 | -122.435362229505 | (37.7206512958141, -122.435362229505) |
| 96525 | 96525 | 96881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X San Jose Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 102506 | 102506 | 96880 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2011 12:00:00 AM | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | ||||
| 119445 | 119445 | 88345 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 347 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51330 | 6003917.0 | 2091407.0 | 37.7228273068445 | -122.428568687279 | (37.7228273068445, -122.428568687279) | |||
| 109280 | 109280 | 11700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799X Junipero Serra Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 110324 | 110324 | 999 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6001467.99656 | 2092045.3572200001 | 37.724441193017796 | -122.43708004004499 | (37.7244411930178, -122.437080040045) | |||
| 94712 | 94712 | 19110 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1698X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001491.80984 | 2092305.0577099998 | 37.7251556252372 | -122.437016305095 | (37.7251556252372, -122.437016305095) | |||
| 128700 | 128700 | 19111 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1698X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x5 | 6001491.80984 | 2092305.0577099998 | 37.7251556252372 | -122.437016305095 | (37.7251556252372, -122.437016305095) | |||
| 12202 | 12202 | 987 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1642 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6001628.10442 | 2092593.14767 | 37.7259544009542 | -122.436565760724 | (37.7259544009542, -122.436565760724) | |||
| 104163 | 104163 | 86917 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 85 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49879 | 5992371.6 | 2092886.0 | 37.726228139607 | -122.468585900475 | (37.726228139607, -122.468585900475) | |||
| 10669 | 10669 | 983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1616 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6001693.07933 | 2092739.79074 | 37.7263607416377 | -122.43635163751699 | (37.7263607416377, -122.436351637517) | |||
| 11763 | 11763 | 980 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2015 12:00:00 AM | 16 | 3x3 | 6001812.25191 | 2092793.77395 | 37.726515738 | -122.435943525179 | (37.726515738, -122.435943525179) | ||
| 185102 | 185102 | 35062 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 7 | Permit Number 41350 | 6014151.3296 | 2092812.8657 | 37.7272614022518 | -122.393288830363 | (37.7272614022518, -122.393288830363) | ||
| 93739 | 93739 | 35057 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41350 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | |||
| 106100 | 106100 | 35061 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41350 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | |||
| 108680 | 108680 | 35059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41350 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | |||
| 123506 | 123506 | 35060 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41350 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | |||
| 124631 | 124631 | 35058 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38618 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | |||
| 2456 | 2456 | 201598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020624.74965 | 2092745.3424200001 | 37.7274335141325 | -122.370905303063 | (37.7274335141325, -122.370905303063) |
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");