trees
720 rows where qCaretaker_id = 5 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194093 | 24686 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.7797664796243 | -122.490106359296 | (37.7797664796243, -122.490106359296) | 11 | 6 | 2 | 55 | 26 | ||
| 194071 | 142062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | 7 | 9 | 11 | 29490 | 41 | |
| 193849 | 5447 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 100 | 6 | 6004926.66778 | 2104747.15947 | 37.7595134404185 | -122.426027663264 | (37.7595134404185, -122.426027663264) | 2 | 4 | 5 | 28862 | 3 | |||
| 193329 | 26307 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/06/1998 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 193276 | 103200 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 193270 | 116150 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
| 193095 | 20228 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1699 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6002579.480222 | 2114044.5496622 | 37.7849088392032 | -122.43481026677 | (37.7849088392032, -122.43481026677) | 13 | 9 | 11 | 29490 | 13 | |||
| 192948 | 20506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1211X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 192864 | 114481 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 45 HOFF ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6006591 | 2106401 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | 8 | 4 | 7 | 28859 | 19 | ||||
| 192765 | 20478 | DPW Maintained 1 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 1203X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 192526 | 27155 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/29/2000 12:00:00 AM | 6 | 3X3 | 6011143.89147 | 2095098.83858 | 37.7333706629228 | -122.403846374205 | (37.7333706629228, -122.403846374205) | 10 | 3 | 8 | 58 | 1 | ||
| 191751 | 115547 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 7 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
| 190987 | 236908 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | Width 3ft | 5997407.84299 | 2106068.89598 | 37.7627147840868 | -122.452126715671 | (37.7627147840868, -122.452126715671) | 15 | 5 | 11 | 29492 | 9 | |||
| 190804 | 29073 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1050X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.7525631 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | 7 | 9 | 11 | 28852 | 41 | ||
| 190768 | 8503 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1950X Geary Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6002386.4460269 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | 13 | 5 | 11 | 29490 | 13 | |||
| 189928 | 8486 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1900X Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | ||
| 189815 | 112130 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 189496 | 255885 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 189458 | 103183 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987454.6857 | 2104156.4641 | 37.7568885966535 | -122.486410289114 | (37.7568885966535, -122.486410289114) | 1 | 8 | 3 | 56 | 35 | |||
| 189327 | 24933 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
| 189312 | 9539 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1100X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004035.7284 | 2112200.9821 | 37.779929432705 | -122.429640587781 | (37.779929432705, -122.429640587781) | 7 | 9 | 11 | 29490 | 41 | ||
| 187889 | 20474 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1203X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 187311 | 7380 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.406004508334 | (37.7783210049209, -122.406004508334) | 14 | 2 | 9 | 28853 | 34 | |||
| 186352 | 255883 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 186227 | 5443 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500X Dolores St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/19/1992 12:00:00 AM | 80 | 6 | 6004908.86181 | 2105038.27798 | 37.7603117767003 | -122.426109970095 | (37.7603117767003, -122.426109970095) | 2 | 4 | 5 | 28862 | 3 | ||
| 186191 | 27152 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | ||
| 185896 | 5462 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.8923427 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | 2 | 4 | 5 | 28862 | 3 | ||
| 185815 | 112651 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
| 185724 | 687 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | 6010636.02258 | 2101844.69134 | 37.7518649312223 | -122.406077308042 | (37.7518649312223, -122.406077308042) | 10 | 4 | 8 | 28859 | 19 | |||
| 185499 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 1820X Palou Ave | : Cutout | Tree | Rec/Park 5 | FUF | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | 10 | 3 | 8 | 58 | 1 | ||||
| 185287 | 12049 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/17/2007 12:00:00 AM | 3 | 3x3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 185059 | 236905 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 13 | Width 3ft | 5997429.83538 | 2105909.93522 | 37.7622795778661 | -122.452039182864 | (37.7622795778661, -122.452039182864) | 15 | 5 | 11 | 29492 | 9 | |||
| 184911 | 103174 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 184860 | 112153 | Undocumented 4 | Casurina stricta :: Beefwood: Drooping She-Oak 173 | 299x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6007772 | 2106483 | 37.7644400562771 | -122.416310015149 | (37.7644400562771, -122.416310015149) | 8 | 4 | 7 | 28859 | 19 | ||||
| 184640 | 5488 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 700X Dolores St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
| 184613 | 116137 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 184156 | 111800 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Sherman St | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010798.82321 | 2110910.53582 | 37.7767667935777 | -122.406152969786 | (37.7767667935777, -122.406152969786) | 14 | 2 | 9 | 28853 | 34 | |||
| 183895 | 103207 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987194.6566 | 2103923.6817 | 37.7562342793419 | -122.487292457342 | (37.7562342793419, -122.487292457342) | 1 | 8 | 3 | 56 | 35 | |||
| 183770 | 115544 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 780 DOUGLASS ST | 4 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 3x3 | 6001139 | 2101871 | 37.7514014062737 | -122.438921147793 | (37.7514014062737, -122.438921147793) | 2 | 4 | 5 | 28862 | 22 | ||||
| 183732 | 9547 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1100X Golden Gate Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
| 183148 | 112154 | Undocumented 4 | Casurina stricta :: Beefwood: Drooping She-Oak 173 | 299x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6007772 | 2106483 | 37.7644400562771 | -122.416310015149 | (37.7644400562771, -122.416310015149) | 8 | 4 | 7 | 28859 | 19 | ||||
| 183044 | 116274 | Undocumented 4 | :: 45 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 182930 | 103178 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 182547 | 103187 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 182372 | 8480 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | |||
| 182181 | 111804 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
| 181967 | 20489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 181281 | 113800 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
| 181190 | 116336 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
| 180958 | 111802 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 55X Sherman St | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 25 | 3x3 | 6010732.9183 | 2110973.0919 | 37.7769348714848 | -122.406385364505 | (37.7769348714848, -122.406385364505) | 14 | 2 | 9 | 28853 | 34 | |||
| 180788 | 88408 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.7942872436256 | -122.411401815264 | (37.7942872436256, -122.411401815264) | 3 | 1 | 10 | 28857 | 21 | |
| 180738 | 25414 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 180626 | 105143 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | DPW for City Agency | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.7763091228737 | -122.424285011933 | (37.7763091228737, -122.424285011933) | 7 | 9 | 11 | 28852 | 10 | ||
| 180537 | 9533 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | 7 | 9 | 11 | 29490 | 41 | |||
| 180509 | 113981 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
| 180214 | 20488 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1204 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 179632 | 9474 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 30 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
| 179164 | 116280 | Undocumented 4 | :: 45 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 178352 | 100036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 178327 | 2809 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1070X California St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 35 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | 5 | 1 | 10 | 28857 | 21 | |||
| 178224 | 18577 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.463636404172 | (37.7143856696584, -122.463636404172) | 9 | 8 | 6 | 64 | 24 | ||
| 177982 | 120888 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.407871127091 | (37.7126351844606, -122.407871127091) | 9 | 7 | 8 | 309 | 39 | |||
| 177664 | 24922 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 176401 | 103204 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 176125 | 8483 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900X Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | |||
| 176118 | 103232 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 176040 | 103192 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 175880 | 9790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 40 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
| 175704 | 115560 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1464 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 9 | 3x3 | 6007697.45646 | 2117180.95447 | 37.7938098789619 | -122.417326013802 | (37.7938098789619, -122.417326013802) | 5 | 1 | 10 | 28858 | 32 | |||
| 175314 | 98425 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
| 175131 | 24926 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2099X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
| 175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
| 174654 | 107472 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1464 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6007706.01713 | 2117181.73808 | 37.7938125121936 | -122.417296448573 | (37.7938125121936, -122.417296448573) | 5 | 1 | 10 | 28858 | 32 | |||
| 174435 | 112129 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 174163 | 8523 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1901 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.437805961288 | (37.7836169980675, -122.437805961288) | 15 | 5 | 11 | 29490 | 41 | |||
| 174144 | 116127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 174092 | 116292 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009504.70132 | 2120333.42493 | 37.8025672995432 | -122.41129555893 | (37.8025672995432, -122.41129555893) | 3 | 1 | 10 | 308 | 23 | |||||
| 173808 | 26301 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 173452 | 20464 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1202X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/05/1997 12:00:00 AM | 3 | 10 | 5984687.1705981 | 2107256.1433532 | 37.7652377447603 | -122.496209934631 | (37.7652377447603, -122.496209934631) | 11 | 6 | 2 | 55 | 8 | ||
| 173288 | 689 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
| 173276 | 9797 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | ||
| 173170 | 98431 | DPW Maintained 1 | Tree(s) :: 17 | 1401X Steiner St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | |||
| 173014 | 236907 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 14 | Width 3ft | 5997416.78118 | 2106000.38977 | 37.7625271953934 | -122.452090858816 | (37.7625271953934, -122.452090858816) | 15 | 5 | 11 | 29492 | 9 | |||
| 172741 | 17725 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X Pierce St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 60 | 3X3 | Permit Number 768629 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |
| 172694 | 20494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 172601 | 26647 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
| 172528 | 116337 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
| 172525 | 116278 | Undocumented 4 | :: 45 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 172455 | 9471 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
| 172414 | 256223 | Property Tree 8 | Schinus molle :: California Pepper 91 | 116X Brewster St | 1 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 6x6 | 6010334 | 2099321 | 37.7449185312124 | -122.406943891675 | (37.7449185312124, -122.406943891675) | 2 | 7 | 7 | 28859 | 2 | ||||
| 172055 | 112127 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 171791 | 20472 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1203X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
| 170740 | 9473 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
| 170473 | 12053 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 169179 | 22613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168 | (37.7813375942673, -122.42509837168) | 7 | 9 | 11 | 28852 | 41 | |||
| 168824 | 25413 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/28/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 168525 | 100786 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 168172 | 12060 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 168152 | 12065 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );