Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981 | 1981 | 35702 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 5612 | 5612 | 35700 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 7342 | 7342 | 35697 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 8272 | 8272 | 35698 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10284 | 10284 | 35699 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11246 | 11246 | 35705 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11435 | 11435 | 35694 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11560 | 11560 | 35695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11610 | 11610 | 35704 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 12226 | 12226 | 35696 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14850 | 14850 | 35701 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15690 | 15690 | 35690 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15799 | 15799 | 35703 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15958 | 15958 | 35692 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 16152 | 16152 | 35693 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
| 90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
| 160462 | 160462 | 177154 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.725615388036104 | -122.42363641630301 | (37.7256153880361, -122.423636416303) | |||
| 91941 | 91941 | 52992 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1800 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48973 | 6013995.42685531 | 2096291.44248921 | 37.7368042013217 | -122.394071207374 | (37.7368042013217, -122.394071207374) | |||
| 112760 | 112760 | 200367 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 17 | Width 5ft | 6014030.85339 | 2096351.6806400002 | 37.7369715717905 | -122.393952936896 | (37.7369715717905, -122.393952936896) | |||
| 25127 | 25127 | 200366 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014047.106269999 | 2096372.4575200002 | 37.7370295240776 | -122.393898196954 | (37.7370295240776, -122.393898196954) | |||
| 63351 | 63351 | 200365 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6014060.81183 | 2096393.5404700001 | 37.7370881751809 | -122.39385228564801 | (37.7370881751809, -122.393852285648) | |||
| 157215 | 157215 | 200364 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6014077.799769999 | 2096412.7772 | 37.7371419393345 | -122.393794896313 | (37.7371419393345, -122.393794896313) | |||
| 167176 | 167176 | 200363 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6014137.38405 | 2096492.6896799998 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | |||
| 186583 | 186583 | 200362 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.39349559025801 | (37.7374749933851, -122.393495590258) | |||
| 169282 | 169282 | 200361 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.39344438196699 | (37.7375336444497, -122.393444381967) | |||
| 45529 | 45529 | 200360 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6014196.6239 | 2096573.2462900002 | 37.737589156904995 | -122.393395290662 | (37.737589156905, -122.393395290662) | |||
| 46141 | 46141 | 200359 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 5ft | 6014213.143619999 | 2096595.32013 | 37.737650684936796 | -122.393339717964 | (37.7376506849368, -122.393339717964) | |||
| 74895 | 74895 | 200358 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014239.8641 | 2096632.70057 | 37.7377548084229 | -122.393249946754 | (37.7377548084229, -122.393249946754) | |||
| 32103 | 32103 | 38388 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | Permit Number 40446 | 6014255.1081300005 | 2096652.83017 | 37.737810927032704 | -122.39319864851801 | (37.7378109270327, -122.393198648518) | ||
| 57768 | 57768 | 200357 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014316.3111 | 2096732.3588400001 | 37.73803269625021 | -122.392992601233 | (37.7380326962502, -122.392992601233) | |||
| 136918 | 136918 | 200356 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014331.3129900005 | 2096752.73935 | 37.7380894902424 | -122.39294215736601 | (37.7380894902424, -122.392942157366) | |||
| 134636 | 134636 | 200355 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 19 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6014345.08354 | 2096773.3910700001 | 37.7381469605042 | -122.392895989784 | (37.7381469605042, -122.392895989784) | |||
| 164517 | 164517 | 200354 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014359.7983 | 2096791.80766 | 37.7381983459865 | -122.392846401168 | (37.7381983459865, -122.392846401168) | |||
| 133126 | 133126 | 200353 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 17 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6014392.43301 | 2096834.63166 | 37.738317744462 | -122.392736560653 | (37.738317744462, -122.392736560653) | |||
| 57963 | 57963 | 200352 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 16 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6014405.80816 | 2096853.92235 | 37.7383714555731 | -122.392691664697 | (37.7383714555731, -122.392691664697) | |||
| 135542 | 135542 | 200351 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6014421.213330001 | 2096874.8296 | 37.73842971815 | -122.39263986285 | (37.73842971815, -122.39263986285) | |||
| 146537 | 146537 | 200350 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.738755625282394 | -122.39234516490299 | (37.7387556252824, -122.392345164903) | |||
| 31300 | 31300 | 200349 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014526.629869999 | 2097016.7538700001 | 37.738825266977294 | -122.392285304228 | (37.7388252669773, -122.392285304228) | |||
| 40723 | 40723 | 200348 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6014546.28219 | 2097041.8855599998 | 37.738895364638 | -122.39221911232599 | (37.738895364638, -122.392219112326) | |||
| 105063 | 105063 | 200347 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6014556.031830001 | 2097054.78425 | 37.7389313231291 | -122.392186304173 | (37.7389313231291, -122.392186304173) | |||
| 168594 | 168594 | 200346 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | |||
| 83384 | 83384 | 17658 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 87807 | 87807 | 17661 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 104025 | 104025 | 17656 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | ||
| 104908 | 104908 | 17662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 117411 | 117411 | 17659 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 125491 | 125491 | 17660 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 175699 | 175699 | 200345 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014658.54117 | 2097192.95407 | 37.7393164002222 | -122.391841530176 | (37.7393164002222, -122.391841530176) | |||
| 155277 | 155277 | 228844 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007473.725769999 | 2097767.91667 | 37.7404936415809 | -122.416724215363 | (37.7404936415809, -122.416724215363) | |||
| 73201 | 73201 | 228843 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 707 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007452.7290199995 | 2097768.34677 | 37.7404936415683 | -122.416796844595 | (37.7404936415683, -122.416796844595) | |||
| 169758 | 169758 | 208167 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991441.567009999 | 2097783.56953 | 37.7396218639513 | -122.47215777968201 | (37.7396218639513, -122.472157779682) | |||
| 94681 | 94681 | 63072 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1986 12:00:00 AM | Permit Number 23550 | 6007407.20126882 | 2097784.26133742 | 37.740534778558605 | -122.416955389518 | (37.7405347785586, -122.416955389518) | ||
| 72713 | 72713 | 208168 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991441.450619999 | 2097800.63089 | 37.7396687033598 | -122.472159425416 | (37.7396687033598, -122.472159425416) | |||
| 181097 | 181097 | 208169 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991440.6028 | 2097828.1323700002 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | |||
| 151751 | 151751 | 200344 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 40 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015132.05324 | 2097828.30985 | 37.74108723188171 | -122.390248699517 | (37.7410872318817, -122.390248699517) | |||
| 90452 | 90452 | 86806 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | |||
| 93009 | 93009 | 86807 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 700X Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | |||
| 159507 | 159507 | 200343 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 39 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6015141.18947 | 2097840.20057 | 37.741120388109294 | -122.39021794000799 | (37.7411203881093, -122.390217940008) | |||
| 116101 | 116101 | 17647 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 650X Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015137.8127243 | 2097842.4274143996 | 37.7411263152677 | -122.39022977121401 | (37.7411263152677, -122.390229771214) | |||
| 42998 | 42998 | 200342 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 25 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015273.793930001 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | |||
| 76523 | 76523 | 200341 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 24 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015282.07626 | 2098027.6206799997 | 37.74164281866221 | -122.389743887597 | (37.7416428186622, -122.389743887597) | |||
| 72490 | 72490 | 200340 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 23 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.38968320401399 | (37.7417134289277, -122.389683204014) | |||
| 137367 | 137367 | 200339 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6015308.33502 | 2098065.1650799997 | 37.741747363937606 | -122.389655714464 | (37.7417473639376, -122.389655714464) | |||
| 85626 | 85626 | 17642 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 94447 | 94447 | 17645 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 109408 | 109408 | 17643 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 123909 | 123909 | 17641 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 145002 | 145002 | 17644 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 160126 | 160126 | 200338 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 21 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | |||
| 185785 | 185785 | 200337 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015484.2575199995 | 2098301.13552 | 37.742405043569796 | -122.389063899405 | (37.7424050435698, -122.389063899405) | |||
| 166431 | 166431 | 200336 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511002 | (37.7424425848476, -122.38903282511) | |||
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 2256 | 2256 | 200334 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 4 | : 4 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.742565908900204 | -122.388913512973 | (37.7425659089002, -122.388913512973) | ||
| 75743 | 75743 | 17631 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | ||
| 83164 | 83164 | 17638 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 85032 | 85032 | 17636 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 92402 | 92402 | 17639 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 102325 | 102325 | 17634 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 145599 | 145599 | 17635 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 120380 | 120380 | 64146 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24921 | 6002780.16143913 | 2098575.90057442 | 37.7424470739996 | -122.433010428517 | (37.7424470739996, -122.433010428517) | ||
| 32287 | 32287 | 227937 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002968.42227 | 2098587.5279900003 | 37.7424896769594 | -122.43236030960699 | (37.7424896769594, -122.432360309607) | |||
| 46833 | 46833 | 227936 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 167 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6004844.7517 | 2099277.52267 | 37.7444904598682 | -122.42592162061001 | (37.7444904598682, -122.42592162061) | |||
| 24184 | 24184 | 208171 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 158 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994395.10908 | 2099344.18308 | 37.744077400365 | -122.46205892188401 | (37.744077400365, -122.462058921884) | |||
| 53935 | 53935 | 208172 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 154 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994418.094740001 | 2099364.4172099996 | 37.7441342815725 | -122.46198091018499 | (37.7441342815725, -122.461980910185) | |||
| 136849 | 136849 | 208174 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | |||
| 43828 | 43828 | 208173 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.744339434016794 | -122.460502016448 | (37.7443394340168, -122.460502016448) | |||
| 78762 | 78762 | 85037 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 90885 | 90885 | 85038 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 84551 | 84551 | 45668 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 46(REVISED) Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 44364 | 6004865.19751473 | 2101080.41704042 | 37.7494419484142 | -122.425979237767 | (37.7494419484142, -122.425979237767) | ||
| 46581 | 46581 | 228841 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000998.7373 | 2101290.13943 | 37.749798521207204 | -122.439364559745 | (37.7497985212072, -122.439364559745) | |||
| 118847 | 118847 | 108695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 511 Alvarado St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | |
| 129842 | 129842 | 228840 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 104 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004701.59069 | 2103023.11733 | 37.754766903184 | -122.426683319388 | (37.754766903184, -122.426683319388) | |||
| 33596 | 33596 | 227938 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 25 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.51107 | 2103480.2352 | 37.756022715594604 | -122.426674645426 | (37.7560227155946, -122.426674645426) | |||
| 151478 | 151478 | 228845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001290.00365 | 2104097.6707200003 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | |||
| 173137 | 173137 | 227935 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 705 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6008535.61915 | 2104408.30699 | 37.7587863358342 | -122.413522114462 | (37.7587863358342, -122.413522114462) | |||
| 66960 | 66960 | 200333 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 903 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015264.35575 | 2104459.34943 | 37.7593020107061 | -122.39025440841002 | (37.7593020107061, -122.39025440841) | |||
| 15015 | 15015 | 106001 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6015262.44728 | 2104479.57944 | 37.75935745211439 | -122.390262422266 | (37.7593574521144, -122.390262422266) | |||
| 13518 | 13518 | 106002 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015261.96303 | 2104498.62679 | 37.759409725189705 | -122.39026542781299 | (37.7594097251897, -122.390265427813) | |||
| 146016 | 146016 | 108433 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222x Cumberland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004156.2455400005 | 2104544.03717 | 37.758912142621206 | -122.428677685352 | (37.7589121426212, -122.428677685352) |
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");