Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18569 | 18569 | 9792 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 96327 | 96327 | 9794 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 26 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 99178 | 99178 | 9800 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | ||
| 105542 | 105542 | 9791 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 110369 | 110369 | 9799 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/30/2006 12:00:00 AM | 30 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | ||
| 114182 | 114182 | 9793 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 117973 | 117973 | 9795 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 26 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 128126 | 128126 | 9796 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 140221 | 140221 | 9790 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 142017 | 142017 | 9797 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | ||
| 90489 | 90489 | 113805 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 990X OSHAUGHNESSY BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x30 | 6000025.0 | 2096199.0 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | ||||
| 109652 | 109652 | 113804 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x30 | 6000025.0 | 2096199.0 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | ||||
| 18684 | 18684 | 109456 | Permitted Site 1 | Tree(s) :: 17 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 85033 | 85033 | 109457 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 951 GILMAN AVE | 43 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 23 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||||
| 115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 19639 | 19639 | 9777 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 83331 | 83331 | 9776 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 106297 | 106297 | 9775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 106561 | 106561 | 9778 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 109810 | 109810 | 9782 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/25/1997 12:00:00 AM | 12 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 114266 | 114266 | 9773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/25/1997 12:00:00 AM | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 117126 | 117126 | 9781 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 123639 | 123639 | 9780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 126377 | 126377 | 9774 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/26/1992 12:00:00 AM | 34 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 129343 | 129343 | 9783 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 51128 | 51128 | 25415 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 99275 | 99275 | 25419 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 106691 | 106691 | 25411 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 110546 | 110546 | 25416 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 112727 | 112727 | 25417 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 116369 | 116369 | 25413 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/28/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 138721 | 138721 | 25414 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 123341 | 123341 | 117622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
| 126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
| 25448 | 25448 | 102374 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | ||||
| 33246 | 33246 | 102378 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | ||||
| 33621 | 33621 | 102375 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983887.37527 | 2110050.4929400003 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | ||||
| 39888 | 39888 | 102373 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983890.730690001 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | ||||
| 69190 | 69190 | 102377 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.49916995510901 | (37.7727119887219, -122.499169955109) | ||||
| 31420 | 31420 | 102369 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.49827212221099 | (37.773005270668, -122.498272122211) | |||
| 38057 | 38057 | 102379 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5984156.57881 | 2110013.67242 | 37.772778039448106 | -122.49824877411999 | (37.7727780394481, -122.49824877412) | ||||
| 123293 | 123293 | 102368 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | |||
| 150039 | 150039 | 102376 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 5984157.512069999 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | ||||
| 156733 | 156733 | 102371 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.68011 | 2110075.48808 | 37.7729475975471 | -122.49826336723801 | (37.7729475975471, -122.498263367238) | |||
| 166717 | 166717 | 102372 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984152.563490001 | 2110057.09296 | 37.7728970243511 | -122.49826587084299 | (37.7728970243511, -122.498265870843) | |||
| 182049 | 182049 | 102370 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.18727 | 2110032.649 | 37.7728299448261 | -122.49826190746201 | (37.7728299448261, -122.498261907462) | |||
| 96202 | 96202 | 112131 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 106111 | 106111 | 112128 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 141984 | 141984 | 112129 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 144403 | 144403 | 112127 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 145495 | 145495 | 112130 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 1593 | 1593 | 9458 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.780549510570204 | -122.424966344778 | (37.7805495105702, -122.424966344778) | ||
| 2279 | 2279 | 9454 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | ||
| 3252 | 3252 | 9455 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005466.2284 | 2112408.648 | 37.7805805276453 | -122.424706623116 | (37.7805805276453, -122.424706623116) | ||
| 3483 | 3483 | 9453 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.42457410603201 | (37.7806020298362, -122.424574106032) | ||
| 3688 | 3688 | 9457 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | |||
| 5378 | 5378 | 9456 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.780573233977705 | -122.424788902821 | (37.7805732339777, -122.424788902821) | ||
| 5863 | 5863 | 9461 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005331.3816 | 2112388.6106 | 37.780517893039395 | -122.425171696602 | (37.7805178930394, -122.425171696602) | ||
| 6101 | 6101 | 9452 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.780605768348295 | -122.424527345883 | (37.7806057683483, -122.424527345883) | ||
| 6304 | 6304 | 9451 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005532.2979 | 2112418.9375 | 37.7806125113537 | -122.424478789137 | (37.7806125113537, -122.424478789137) | ||
| 7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
| 7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
| 7676 | 7676 | 9450 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 6 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.780617614602896 | -122.424439561439 | (37.7806176146029, -122.424439561439) | |||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 52923 | 52923 | 9470 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 76131 | 76131 | 9462 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 77876 | 77876 | 9463 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 78511 | 78511 | 9477 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 79530 | 79530 | 9479 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 89209 | 89209 | 9466 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 89936 | 89936 | 9476 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 93591 | 93591 | 9467 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 95023 | 95023 | 9472 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 99808 | 99808 | 9475 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 102216 | 102216 | 9478 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 107612 | 107612 | 9464 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 116376 | 116376 | 9469 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 116831 | 116831 | 9473 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 123611 | 123611 | 9465 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 125854 | 125854 | 9468 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 143176 | 143176 | 9471 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 144830 | 144830 | 9474 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 85540 | 85540 | 115541 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | |||
| 86577 | 86577 | 115542 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 98385 | 98385 | 115545 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 105415 | 105415 | 115546 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 107914 | 107914 | 115543 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 141166 | 141166 | 115544 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 146308 | 146308 | 115547 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | ||||
| 80868 | 80868 | 116284 | Undocumented 2 | :: 54 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 82559 | 82559 | 116276 | Undocumented 2 | :: 54 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 84777 | 84777 | 116279 | Undocumented 2 | :: 54 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 92470 | 92470 | 116283 | Undocumented 2 | :: 54 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 98757 | 98757 | 116282 | Undocumented 2 | :: 54 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 116105 | 116105 | 116281 | Undocumented 2 | :: 54 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117089 | 117089 | 116277 | Undocumented 2 | :: 54 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) |
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");