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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 589 | 589 | 26916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.43486830704398 | (37.783909052953, -122.434868307044) | |||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 1964 | 1964 | 238618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 14 | Width 4ft | 6001078.53558 | 2101746.02342 | 37.751054810249 | -122.439121284114 | (37.751054810249, -122.439121284114) | |||
| 1974 | 1974 | 238616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.43874669133301 | (37.7510729252903, -122.438746691333) | |||
| 1975 | 1975 | 238619 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001066.93276 | 2101745.60422 | 37.7510529990026 | -122.43916137771099 | (37.7510529990026, -122.439161377711) | |||
| 2024 | 2024 | 139198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | Width 0ft | 6001803.3539 | 2113704.6103 | 37.783931357581395 | -122.437471057097 | (37.7839313575814, -122.437471057097) | |||
| 2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
| 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) | |||
| 3904 | 3904 | 4665 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | |||
| 4255 | 4255 | 4659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.800489575353104 | -122.410288343699 | (37.8004895753531, -122.410288343699) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 5555 | 5555 | 8527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002529.8149 | 2113677.2092 | 37.7838973955703 | -122.434955812258 | (37.7838973955703, -122.434955812258) | |||
| 6893 | 6893 | 8489 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002220.6585 | 2113766.2282 | 37.7841242607304 | -122.436031749589 | (37.7841242607304, -122.436031749589) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 7037 | 7037 | 4663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | |||
| 7109 | 7109 | 18519 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.800340927010296 | -122.410812809398 | (37.8003409270103, -122.410812809398) | |||
| 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) | |||
| 7403 | 7403 | 107472 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6007706.0171300005 | 2117181.73808 | 37.793812512193604 | -122.417296448573 | (37.7938125121936, -122.417296448573) | |||
| 7614 | 7614 | 20156 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002897.8994 | 2112109.7603 | 37.7796144675148 | -122.43357032043899 | (37.7796144675148, -122.433570320439) | |||
| 7635 | 7635 | 8487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002304.7836 | 2113777.2973 | 37.7841594324943 | -122.43574149958401 | (37.7841594324943, -122.435741499584) | |||
| 7636 | 7636 | 99241 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6008235.1228 | 2113825.75072 | 37.7846275436788 | -122.415228013286 | (37.7846275436788, -122.415228013286) | |||
| 7647 | 7647 | 99242 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 8 | 4x4 | 6008195.716580001 | 2113819.71845 | 37.7846087658129 | -122.415363918808 | (37.7846087658129, -122.415363918808) | |||
| 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) | |||
| 7827 | 7827 | 9544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6003937.8747 | 2112189.6367 | 37.7798927397998 | -122.429978297745 | (37.7798927397998, -122.429978297745) | |||
| 7851 | 7851 | 4658 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 34 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | |||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
| 8790 | 8790 | 105143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | DPW for City Agency 2 | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.776309122873705 | -122.42428501193301 | (37.7763091228737, -122.424285011933) | ||
| 8794 | 8794 | 8525 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002439.1587 | 2113663.3402 | 37.7838541670365 | -122.43526845642201 | (37.7838541670365, -122.435268456422) | |||
| 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) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 11793 | 11793 | 120892 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Leland Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6009904.76 | 2087542.3079 | 37.7125527002168 | -122.407597819442 | (37.7125527002168, -122.407597819442) | |||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
| 15206 | 15206 | 26133 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | |||
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 15604 | 15604 | 7382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | |||
| 15693 | 15693 | 7378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | |||
| 16764 | 16764 | 7379 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600363998 | (37.7783600402028, -122.40594600364) | |||
| 17375 | 17375 | 24541 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6007668.223019999 | 2097198.66884 | 37.7389415501992 | -122.416011415406 | (37.7389415501992, -122.416011415406) | |||
| 17563 | 17563 | 687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010636.022580001 | 2101844.6913400004 | 37.75186493122229 | -122.40607730804199 | (37.7518649312223, -122.406077308042) | |||
| 17712 | 17712 | 5442 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004907.01705 | 2105068.65381 | 37.7603950772802 | -122.426118512771 | (37.7603950772802, -122.426118512771) | |||
| 18045 | 18045 | 24537 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6007586.10322 | 2097213.8581 | 37.738978639151505 | -122.416296424042 | (37.7389786391515, -122.416296424042) | |||
| 18074 | 18074 | 112652 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
| 18163 | 18163 | 24539 | Landmark tree 9 | Celtis occidentalis :: Common Hackberry 292 | 500X Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6007622.1254900005 | 2097206.54003 | 37.738960570878795 | -122.41617135711999 | (37.7389605708788, -122.41617135712) | |||
| 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) | |||
| 18744 | 18744 | 5437 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 25 | 6 | 6004897.82208 | 2105221.96635 | 37.760815517531206 | -122.426161228775 | (37.7608155175312, -122.426161228775) | |||
| 18991 | 18991 | 5440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004903.17124 | 2105121.8240799997 | 37.7605408528978 | -122.426135598976 | (37.7605408528978, -122.426135598976) | |||
| 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) | |||
| 19884 | 19884 | 5444 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004913.15076 | 2105006.62195 | 37.760225099135795 | -122.426092882994 | (37.7602250991358, -122.426092882994) | |||
| 19899 | 19899 | 24538 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6007606.23219 | 2097211.71423 | 37.7389738844263 | -122.416226675338 | (37.7389738844263, -122.416226675338) | |||
| 19927 | 19927 | 10223 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296966999 | (37.7491888788632, -122.42249296967) | |||
| 20082 | 20082 | 111807 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 20843 | 20843 | 111792 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 20862 | 20862 | 116132 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 20901 | 20901 | 5441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004905.78091 | 2105098.60706 | 37.76047725195271 | -122.426124920443 | (37.7604772519527, -122.426124920443) | |||
| 21449 | 21449 | 24540 | Landmark tree 9 | Celtis occidentalis :: Common Hackberry 292 | 500X Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6007652.968230001 | 2097201.05938 | 37.7389472564055 | -122.416064328819 | (37.7389472564055, -122.416064328819) | |||
| 21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
| 24234 | 24234 | 103219 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987198.2105 | 2103866.2266 | 37.7560767305116 | -122.48727594694401 | (37.7560767305116, -122.487275946944) | |||
| 24419 | 24419 | 20488 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1204 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 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) | ||||
| 26127 | 26127 | 110046 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 6009043.83179 | 2113590.50747 | 37.7840270384566 | -122.412413507572 | (37.7840270384566, -122.412413507572) | ||||
| 27576 | 27576 | 103186 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 28004 | 28004 | 103180 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.757431419068496 | -122.486447346513 | (37.7574314190685, -122.486447346513) | |||
| 30617 | 30617 | 103185 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 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) | |||
| 32170 | 32170 | 111793 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55X Sherman St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6010868.84129 | 2110834.34163 | 37.7765614981606 | -122.405905386452 | (37.7765614981606, -122.405905386452) | |||
| 32299 | 32299 | 103222 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | |||
| 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) | ||||
| 34305 | 34305 | 20466 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 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) | ||||
| 38305 | 38305 | 116138 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.39238857399599 | (37.7262356791342, -122.392388573996) | ||||
| 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) | ||||
| 43434 | 43434 | 103190 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987454.6857 | 2104172.4568 | 37.7569325082599 | -122.486411463243 | (37.7569325082599, -122.486411463243) | |||
| 43485 | 43485 | 20515 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1211X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 43693 | 43693 | 111802 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 25 | 3x3 | 6010732.9183 | 2110973.0919 | 37.7769348714848 | -122.406385364505 | (37.7769348714848, -122.406385364505) | |||
| 44221 | 44221 | 103193 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987467.1245 | 2103820.0255 | 37.755965552668705 | -122.486342572342 | (37.7559655526687, -122.486342572342) | |||
| 45897 | 45897 | 103220 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987192.8796 | 2103980.5446 | 37.756390305765706 | -122.48730277925199 | (37.7563903057657, -122.487302779252) | |||
| 46034 | 46034 | 103206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987202.3567 | 2103753.0931 | 37.7557663384655 | -122.487253298879 | (37.7557663384655, -122.487253298879) | |||
| 46862 | 46862 | 103223 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987183.9948 | 2104224.5811 | 37.7570598454095 | -122.487351430278 | (37.7570598454095, -122.487351430278) | |||
| 48565 | 48565 | 112649 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
| 50158 | 50158 | 20507 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 50310 | 50310 | 103191 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987457.055 | 2104097.8243 | 37.7567277258047 | -122.48639779019199 | (37.7567277258047, -122.486397790192) | |||
| 55860 | 55860 | 111803 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 26 | 3x3 | 6010715.3243 | 2110993.12608 | 37.7769888964448 | -122.40644763986099 | (37.7769888964448, -122.406447639861) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 61312 | 61312 | 103208 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987188.7333 | 2104102.5628 | 37.7567250927297 | -122.487326080643 | (37.7567250927297, -122.487326080643) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 66190 | 66190 | 20482 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 42 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 67560 | 67560 | 117168 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 68744 | 68744 | 103184 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987458.2396 | 2104042.7384 | 37.75657654394 | -122.48638964930001 | (37.75657654394, -122.4863896493) | |||
| 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) | ||||
| 72532 | 72532 | 116318 | Undocumented 2 | :: 54 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) |
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");