Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40324 | 40324 | 201540 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Innes Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6020451.57641 | 2093498.37325 | 37.729491685489 | -122.37155603899201 | (37.729491685489, -122.371556038992) | ||||
| 47028 | 47028 | 201539 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6020431.263809999 | 2093508.99897 | 37.7295197461253 | -122.37162699728201 | (37.7295197461253, -122.371626997282) | ||||
| 130534 | 130534 | 201524 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 740 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020392.93719 | 2093745.64338 | 37.730167421677606 | -122.371775862971 | (37.7301674216776, -122.371775862971) | ||||
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 73961 | 73961 | 201525 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 740 Earl St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6020363.02265 | 2093708.60357 | 37.730064074283106 | -122.371876721056 | (37.7300640742831, -122.371876721056) | ||||
| 165139 | 165139 | 201526 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 740 Earl St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6020358.69967 | 2093703.87805 | 37.7300508614476 | -122.371891339508 | (37.7300508614476, -122.371891339508) | ||||
| 156492 | 156492 | 201538 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6020320.60238 | 2093595.7564 | 37.7297518872405 | -122.37201557005899 | (37.7297518872405, -122.372015570059) | ||||
| 47385 | 47385 | 201537 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020208.273080001 | 2093682.62725 | 37.729984246855295 | -122.372409919208 | (37.7299842468553, -122.372409919208) | ||||
| 58893 | 58893 | 201536 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020184.941240001 | 2093703.94604 | 37.730041502210895 | -122.372492056066 | (37.7300415022109, -122.372492056066) | ||||
| 86028 | 86028 | 201535 | Undocumented 2 | Juglans californica :: Walnut: Black (s.calif) 407 | 601 Innes Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020117.52711 | 2093745.9964 | 37.730153260063794 | -122.372728027393 | (37.7301532600638, -122.372728027393) | ||||
| 52457 | 52457 | 201534 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020030.3592 | 2093817.11357 | 37.7303437436519 | -122.373034303211 | (37.7303437436519, -122.373034303211) | ||||
| 177662 | 177662 | 201533 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6020026.382119999 | 2093819.59918 | 37.7303503500706 | -122.37304822470301 | (37.7303503500706, -122.373048224703) | ||||
| 150232 | 150232 | 201532 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6020021.83334 | 2093823.70013 | 37.7303613604801 | -122.373064234453 | (37.7303613604801, -122.373064234453) | ||||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 20656 | 20656 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
| 108486 | 108486 | 107550 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X Jennings St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||||
| 142715 | 142715 | 107544 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
| 124630 | 124630 | 107538 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
| 140881 | 140881 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
| 79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 81584 | 81584 | 107564 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 83430 | 83430 | 107562 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 103606 | 103606 | 107561 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 108428 | 108428 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 120274 | 120274 | 107563 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 128143 | 128143 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
| 172222 | 172222 | 201510 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6018594.17439 | 2094891.11142 | 37.73321369166371 | -122.378073969944 | (37.7332136916637, -122.378073969944) | ||||
| 84182 | 84182 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 86272 | 86272 | 104288 | Significant Tree 6 | Tree(s) :: 17 | 137X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 90953 | 90953 | 104290 | Significant Tree 6 | Tree(s) :: 17 | 11X Hare St | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 107391 | 107391 | 104289 | Significant Tree 6 | Tree(s) :: 17 | 10X Hare St | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 108419 | 108419 | 104281 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 3 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 111442 | 111442 | 104286 | Significant Tree 6 | Tree(s) :: 17 | 200X West Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 119692 | 119692 | 104284 | Significant Tree 6 | Tree(s) :: 17 | 45X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 125137 | 125137 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 127056 | 127056 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 129300 | 129300 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 140648 | 140648 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 141507 | 141507 | 104287 | Significant Tree 6 | Tree(s) :: 17 | 119X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
| 79033 | 79033 | 93597 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 80809 | 80809 | 93587 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81098 | 81098 | 93610 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81657 | 81657 | 93601 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81728 | 81728 | 93606 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 89087 | 89087 | 93593 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 89383 | 89383 | 93603 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 91873 | 91873 | 93591 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 94297 | 94297 | 93581 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 95611 | 95611 | 93602 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 98020 | 98020 | 93590 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99163 | 99163 | 93596 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99567 | 99567 | 93609 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99578 | 99578 | 93612 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 100016 | 100016 | 93582 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 103097 | 103097 | 93605 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 107776 | 107776 | 93585 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 108434 | 108434 | 93588 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 110482 | 110482 | 93611 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 110791 | 110791 | 93604 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 112533 | 112533 | 93599 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 116154 | 116154 | 93584 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 116804 | 116804 | 93592 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 117214 | 117214 | 93598 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 118501 | 118501 | 93608 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 118586 | 118586 | 93583 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 122811 | 122811 | 93589 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 124345 | 124345 | 93594 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 127517 | 127517 | 93595 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 129273 | 129273 | 93580 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 139090 | 139090 | 93600 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 141266 | 141266 | 93607 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 142360 | 142360 | 93586 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 129605 | 129605 | 188664 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 501 Amador St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 1ft | 6017799.2263400005 | 2099547.3837200003 | 37.745955042685 | -122.381145981202 | (37.745955042685, -122.381145981202) | |||
| 158739 | 158739 | 188663 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 501 Amador St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 1ft | 6017654.784080001 | 2099538.16845 | 37.745921765085605 | -122.38164480728099 | (37.7459217650856, -122.381644807281) | |||
| 114512 | 114512 | 108201 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 119476 | 119476 | 108200 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 90 Reuel Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774102 | 6017404.09127 | 2096025.6169900002 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | ||||
| 78125 | 78125 | 106567 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.743493385022795 | -122.383634554004 | (37.7434933850228, -122.383634554004) | |||
| 84519 | 84519 | 106568 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.743493385022795 | -122.383634554004 | (37.7434933850228, -122.383634554004) | |||
| 86038 | 86038 | 106569 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.743493385022795 | -122.383634554004 | (37.7434933850228, -122.383634554004) | |||
| 95045 | 95045 | 107166 | DPW Maintained 3 | Acacia spp :: Acacia Spp 176 | 59X PROGRESS ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6016967.0 | 2095036.0 | 37.7335217182981 | -122.383709692997 | (37.7335217182981, -122.383709692997) | ||||
| 38403 | 38403 | 197339 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6016827.1128 | 2099574.92506 | 37.745976956489294 | -122.384509368331 | (37.7459769564893, -122.384509368331) | ||||
| 120839 | 120839 | 113132 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1375 FAIRFAX AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016814.0 | 2097238.0 | 37.7395595104895 | -122.384391976269 | (37.7395595104895, -122.384391976269) | |||||
| 157777 | 157777 | 197340 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6016813.36643 | 2099575.53369 | 37.745977867490204 | -122.384556944272 | (37.7459778674902, -122.384556944272) | ||||
| 185231 | 185231 | 197341 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | ||||
| 103074 | 103074 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.743261569489704 | -122.38540219642401 | (37.7432615694897, -122.385402196424) | |||
| 109878 | 109878 | 103942 | Significant Tree 6 | Tree(s) :: 17 | 1490X Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/25/2013 12:00:00 AM | Permit Number 770233 | 6016485.189069999 | 2097945.03196 | 37.7414826893772 | -122.385578134526 | (37.7414826893772, -122.385578134526) | |||
| 93327 | 93327 | 112843 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1415 EVANS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016481.0 | 2097724.0 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | |||||
| 85142 | 85142 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1435X La Salle Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | ||||
| 107622 | 107622 | 104691 | Significant Tree 6 | Tree(s) :: 17 | 1435X La Salle Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | |||
| 112374 | 112374 | 99106 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400 Evans Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 126121 | 126121 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 150471 | 150471 | 201721 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Lindsay Cir | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6016317.40109 | 2095614.0815400002 | 37.7350730858367 | -122.385995846031 | (37.7350730858367, -122.385995846031) | ||||
| 138465 | 138465 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 Fairfax Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||||
| 31219 | 31219 | 194283 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6016255.79944 | 2100318.37917 | 37.747986718206604 | -122.386536741486 | (37.7479867182066, -122.386536741486) | ||||
| 25107 | 25107 | 191446 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Tulare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6016252.95003 | 2100312.60959 | 37.747970718394704 | -122.386546192477 | (37.7479707183947, -122.386546192477) | ||||
| 54994 | 54994 | 191408 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6016232.34971 | 2100308.61772 | 37.747958617113596 | -122.38661714986 | (37.7479586171136, -122.38661714986) |
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");