Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 1080 | 1080 | 9610 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1388X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/01/2017 01:42:00 PM | 3 | 3X3 | 6002958.1886 | 2112049.4711 | 37.7794523489738 | -122.433357444963 | (37.7794523489738, -122.433357444963) | ||
| 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) | ||
| 2525 | 2525 | 9534 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.42922989330201 | (37.779990692526, -122.429229893302) | |
| 2696 | 2696 | 9611 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1390X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6002925.8908 | 2112046.6002 | 37.7794426338279 | -122.43346897140499 | (37.7794426338279, -122.433468971405) | ||
| 3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
| 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) | |||
| 5025 | 5025 | 9541 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856000001 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 7440 | 7440 | 9542 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
| 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) | |||
| 8706 | 8706 | 9539 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004035.7284 | 2112200.9821 | 37.779929432705 | -122.429640587781 | (37.779929432705, -122.429640587781) | ||
| 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) | |||
| 13832 | 13832 | 27154 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011126.61874 | 2095085.7194599998 | 37.7333336755986 | -122.403905168305 | (37.7333336755986, -122.403905168305) | ||
| 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) | |||
| 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) | |||
| 15856 | 15856 | 27155 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/29/2000 12:00:00 AM | 6 | 3X3 | 6011143.89147 | 2095098.83858 | 37.733370662922795 | -122.403846374205 | (37.7333706629228, -122.403846374205) | ||
| 15973 | 15973 | 22420 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013860.9167 | 2092056.0916 | 37.725167314492104 | -122.39423983281799 | (37.7251673144921, -122.394239832818) | ||
| 16026 | 16026 | 27153 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011109.96837 | 2095074.7045 | 37.7333025005961 | -122.403961958687 | (37.7333025005961, -122.403961958687) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 21616 | 21616 | 25457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | ||
| 21634 | 21634 | 24542 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500X Cortland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/29/1999 12:00:00 AM | 18 | 3X3 | 6007686.223540001 | 2097194.49045 | 37.7389310892969 | -122.41594888193701 | (37.7389310892969, -122.415948881937) | ||
| 21638 | 21638 | 18577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.46363640417201 | (37.7143856696584, -122.463636404172) | ||
| 48375 | 48375 | 17720 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 50090 | 50090 | 13071 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 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) | ||
| 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) | |||
| 77366 | 77366 | 17721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 77594 | 77594 | 8501 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 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) | |||
| 78217 | 78217 | 22401 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 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) | ||
| 78527 | 78527 | 17723 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 78609 | 78609 | 26824 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 78664 | 78664 | 13380 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 78668 | 78668 | 17728 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/20/1992 12:00:00 AM | 70 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | ||
| 78767 | 78767 | 12056 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 79113 | 79113 | 24925 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2099X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/09/1996 12:00:00 AM | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 79265 | 79265 | 26306 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 79428 | 79428 | 8492 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 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) | ||
| 79616 | 79616 | 24935 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 79960 | 79960 | 26313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 80056 | 80056 | 26299 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 80328 | 80328 | 26645 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2199X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | ||
| 80819 | 80819 | 12055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 80827 | 80827 | 8522 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 81054 | 81054 | 2804 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 81488 | 81488 | 13074 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 81506 | 81506 | 26304 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 81892 | 81892 | 26644 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2199X Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | ||
| 81947 | 81947 | 26643 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2199X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | ||
| 82040 | 82040 | 8500 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 82553 | 82553 | 8498 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 82591 | 82591 | 24927 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 83248 | 83248 | 24932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 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) | |||
| 84016 | 84016 | 8521 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | ||
| 85228 | 85228 | 8494 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 85891 | 85891 | 26298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 86895 | 86895 | 13384 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 87002 | 87002 | 8502 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 87286 | 87286 | 8528 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 87999 | 87999 | 9918 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | Permit Number 768908 | 6005198.982724099 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | ||
| 88707 | 88707 | 8482 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 89154 | 89154 | 8481 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 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) | |||
| 89492 | 89492 | 17722 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/25/2008 12:00:00 AM | 3 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | ||
| 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) | ||
| 90660 | 90660 | 8490 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 91375 | 91375 | 13073 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 91603 | 91603 | 24685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6599X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/02/1998 12:00:00 AM | 3 | 3X3 | 5986563.555448 | 2112507.5928897997 | 37.7797664796237 | -122.490106359303 | (37.7797664796237, -122.490106359303) | ||
| 92206 | 92206 | 26303 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) |
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");