Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116973 | 116973 | 108643 | Undocumented 2 | Tree(s) :: 17 | 315X PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Housing Authority 15 | 3x3 | 6012408.6 | 2118423.0 | 37.7974841688946 | -122.40111223755501 | (37.7974841688946, -122.401112237555) | |||
| 62495 | 62495 | 118286 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 199X JULES AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 3x3 | 5994418.0 | 2091201.0 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | |||
| 80969 | 80969 | 108934 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591001 | (37.7386556931549, -122.42007742591) |
| 112534 | 112534 | 108521 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773668 | 5990944.21476 | 2102008.8699 | 37.751194650539205 | -122.47418561882401 | (37.7511946505392, -122.474185618824) |
| 112977 | 112977 | 118285 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 199X JULES AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 3x3 | 5994418.0 | 2091201.0 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | |||
| 117298 | 117298 | 108904 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.41282871497101 | (37.7361673058735, -122.412828714971) |
| 50491 | 50491 | 107717 | Undocumented 2 | Tree(s) :: 17 | 2400X 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Port 11 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789.0 | 2098909.0 | 37.7423832554664 | -122.49178447783899 | (37.7423832554664, -122.491784477839) |
| 80890 | 80890 | 108255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
| 92163 | 92163 | 108259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
| 97433 | 97433 | 107716 | Undocumented 2 | Tree(s) :: 17 | 2400X 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Port 11 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789.0 | 2098909.0 | 37.7423832554664 | -122.49178447783899 | (37.7423832554664, -122.491784477839) |
| 98097 | 98097 | 108256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
| 105668 | 105668 | 108258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
| 112717 | 112717 | 108257 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
| 120202 | 120202 | 108107 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1990X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Port 11 | 6004838.0 | 2115780.0 | 37.7898019192352 | -122.427120168027 | (37.7898019192352, -122.427120168027) | ||||
| 121707 | 121707 | 108254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1798X Washington St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Port 11 | 2x2 | 6006327.679880001 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | |||
| 136121 | 136121 | 106963 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2728 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Port 11 | 14 | 5999920.02374 | 2118149.14648 | 37.7960276377095 | -122.444306168018 | (37.7960276377095, -122.444306168018) | |||
| 143269 | 143269 | 108106 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1990X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Port 11 | 6004838.0 | 2115780.0 | 37.7898019192352 | -122.427120168027 | (37.7898019192352, -122.427120168027) | ||||
| 44757 | 44757 | 104618 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 8 | 4x4 | Permit Number 770959 | 6012200.3 | 2112763.2826 | 37.7819322989016 | -122.401435053146 | (37.7819322989016, -122.401435053146) | |
| 90733 | 90733 | 104623 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 250 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.40196713530099 | (37.7824643544146, -122.401967135301) | ||
| 95314 | 95314 | 104621 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 266-286X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 4x4 | Permit Number 770959 | 6012142.0 | 2112916.0 | 37.7823483723512 | -122.401647482717 | (37.7823483723512, -122.401647482717) | ||
| 113498 | 113498 | 104624 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 250 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.40196713530099 | (37.7824643544146, -122.401967135301) | ||
| 140020 | 140020 | 104622 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 266-286X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 4x4 | Permit Number 770959 | 6012142.0 | 2112916.0 | 37.7823483723512 | -122.401647482717 | (37.7823483723512, -122.401647482717) | ||
| 145040 | 145040 | 104625 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 250 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.40196713530099 | (37.7824643544146, -122.401967135301) | ||
| 151790 | 151790 | 104620 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 10 | 4x4 | Permit Number 770959 | 6012183.3573 | 2112747.2558 | 37.7818873476901 | -122.401492540712 | (37.7818873476901, -122.401492540712) | |
| 164897 | 164897 | 104619 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | MTA 10 | 7 | 4x4 | Permit Number 770959 | 6012190.226 | 2112753.6665 | 37.781905333235294 | -122.401469228728 | (37.7819053332353, -122.401469228728) | |
| 27975 | 27975 | 107435 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 418 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Dept of Real Estate 9 | 32 | 3x3 | 5990007.15475 | 2112492.97382 | 37.779926833827794 | -122.478192501966 | (37.7799268338278, -122.478192501966) | ||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 4715 | 4715 | 103364 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.79257023366971 | -122.412185363057 | (37.7925702336697, -122.412185363057) | ||
| 5817 | 5817 | 103362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009111.87446 | 2116690.2667799997 | 37.7925420462198 | -122.41239727931601 | (37.7925420462198, -122.412397279316) | ||
| 6038 | 6038 | 103363 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.79255531122121 | -122.412292370693 | (37.7925553112212, -122.412292370693) | ||
| 6622 | 6622 | 103365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009208.54849 | 2116702.7837799997 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | ||
| 79827 | 79827 | 103361 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 83849 | 83849 | 103357 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 88405 | 88405 | 103359 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 89814 | 89814 | 103355 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 91178 | 91178 | 103360 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 120938 | 120938 | 103358 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 139014 | 139014 | 103352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 140230 | 140230 | 103354 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 140679 | 140679 | 103356 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 145238 | 145238 | 103353 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 172264 | 172264 | 116139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 11 | 6009237.30915 | 2116708.0838099997 | 37.7925980056535 | -122.411964529145 | (37.7925980056535, -122.411964529145) | |||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 521 | 521 | 5204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 777 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/21/2016 12:00:00 AM | 3 | 4X4 | 6001528.9942 | 2111019.6475 | 37.7765435284866 | -122.438227828795 | (37.7765435284866, -122.438227828795) | |
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
| 657 | 657 | 5214 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 835 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/09/2001 12:00:00 AM | 3 | 3X3 | 6001489.0793 | 2111327.2763 | 37.7773859294292 | -122.438387950593 | (37.7773859294292, -122.438387950593) | |
| 985 | 985 | 97601 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 855 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001476.9066 | 2111398.2834 | 37.7775802046297 | -122.43843514847099 | (37.7775802046297, -122.438435148471) | ||
| 1065 | 1065 | 24631 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 601 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/03/2013 12:00:00 AM | 3 | 3X3 | 6001596.3507 | 2110541.037 | 37.775233214934104 | -122.43796053363701 | (37.7752332149341, -122.437960533637) | |
| 1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
| 1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 2484 | 2484 | 5197 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 631 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 3X3 | 6001585.1623 | 2110622.5519999997 | 37.7754563984119 | -122.438005076955 | (37.7754563984119, -122.438005076955) | |
| 2929 | 2929 | 28092 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 528 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/12/2001 12:00:00 AM | 3 | 3X3 | 6001704.4418 | 2110256.1887 | 37.774457239071104 | -122.43756621922199 | (37.7744572390711, -122.437566219222) | |
| 3158 | 3158 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | DPW 4 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | |
| 3798 | 3798 | 5199 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 643 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001573.1748 | 2110709.1284 | 37.7756934337528 | -122.43805274745701 | (37.7756934337528, -122.438052747457) | |
| 4425 | 4425 | 97577 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001652.1221 | 2110620.3263 | 37.775454094869296 | -122.43777328811301 | (37.7754540948693, -122.437773288113) | ||
| 4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
| 4588 | 4588 | 200921 | Permitted Site 1 | Tristania conferta :: 79 | 4040 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/18/2008 12:00:00 AM | 5 | Width 0ft | 6015547.5959 | 2097647.2059 | 37.7406129979736 | -122.388799250904 | (37.7406129979736, -122.388799250904) | |
| 5125 | 5125 | 97583 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 748 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001590.7259 | 2111040.5 | 37.776604295001 | -122.438015775508 | (37.776604295001, -122.438015775508) | ||
| 5209 | 5209 | 169218 | Permitted Site 1 | Potential Site :: Potential Site 29 | 824 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006905.3054599995 | 2113639.6299099997 | 37.7840416758297 | -122.419815533287 | (37.7840416758297, -122.419815533287) | ||
| 5210 | 5210 | 83637 | Permitted Site 1 | Tree(s) :: 17 | 840 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/19/2005 12:00:00 AM | 3x3 | 6006834.966315799 | 2113631.30048912 | 37.784014842491395 | -122.420058290383 | (37.7840148424914, -122.420058290383) | ||
| 5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
| 5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5217 | 5217 | 169168 | Permitted Site 1 | Potential Site :: Potential Site 29 | 701 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6007051.56678 | 2113380.55802 | 37.7833385660552 | -122.41929113679599 | (37.7833385660552, -122.419291136796) | ||
| 5218 | 5218 | 169214 | Permitted Site 1 | Potential Site :: Potential Site 29 | 724 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | Width 4ft | 6007369.544319999 | 2113705.88387 | 37.7842497348906 | -122.41821413029301 | (37.7842497348906, -122.418214130293) | ||
| 5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
| 5223 | 5223 | 74484 | Permitted Site 1 | Tree(s) :: 17 | 749 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778449 | 6007035.08305 | 2113498.23336 | 37.783660745502296 | -122.41935651480301 | (37.7836607455023, -122.419356514803) |
| 5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
| 5227 | 5227 | 169217 | Permitted Site 1 | Potential Site :: Potential Site 29 | 800 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006932.37231 | 2113646.73425 | 37.7840627073778 | -122.41972239586501 | (37.7840627073778, -122.419722395865) | ||
| 5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5234 | 5234 | 169170 | Permitted Site 1 | Potential Site :: Potential Site 29 | 750 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006877.9642199995 | 2113290.02776 | 37.7830802133315 | -122.419885308057 | (37.7830802133315, -122.419885308057) | ||
| 5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5238 | 5238 | 169219 | Permitted Site 1 | Potential Site :: Potential Site 29 | 840 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006827.36035 | 2113629.7400599997 | 37.7840101293977 | -122.42008449353001 | (37.7840101293977, -122.42008449353) | ||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5728 | 5728 | 97579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001646.5608 | 2110651.222 | 37.7755386104847 | -122.437794739235 | (37.7755386104847, -122.437794739235) | ||
| 5735 | 5735 | 28095 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 650 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/06/2006 12:00:00 AM | 3 | 3x3 | 6001636.0563 | 2110732.7869 | 37.775761969914896 | -122.437836920035 | (37.7757619699149, -122.437836920035) | |
| 5871 | 5871 | 97602 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 833 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3xe | 6001492.376 | 2111306.2278 | 37.777328323069796 | -122.438375037891 | (37.7773283230698, -122.438375037891) | ||
| 5874 | 5874 | 97590 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 559 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001615.3648 | 2110410.2466 | 37.774875178544995 | -122.437885389718 | (37.774875178545, -122.437885389718) | ||
| 5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
| 6000 | 6000 | 28097 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001567.17 | 2110752.9686 | 37.7758134664372 | -122.438076660597 | (37.7758134664372, -122.438076660597) | ||
| 6072 | 6072 | 24616 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001554.3804 | 2111297.3519 | 37.777307478654706 | -122.438159908991 | (37.7773074786547, -122.438159908991) | |
| 6760 | 6760 | 24628 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 536 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001694.2572 | 2110311.9357 | 37.774609727324204 | -122.437605442785 | (37.7746097273242, -122.437605442785) | |
| 7406 | 7406 | 97595 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x4 | 6001524.4178 | 2111055.242 | 37.7766410017417 | -122.438246210395 | (37.7766410017417, -122.438246210395) | ||
| 7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
| 7792 | 7792 | 97581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001597.3606 | 2110988.4698 | 37.776461810461704 | -122.43798909643101 | (37.7764618104617, -122.437989096431) | ||
| 7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
| 8085 | 8085 | 5202 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X4 | 6001595.2588 | 2111007.3853 | 37.7765136281427 | -122.437997722367 | (37.7765136281427, -122.437997722367) | |
| 8303 | 8303 | 97591 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001649.1323 | 2110166.4258 | 37.7742076278049 | -122.43775111477899 | (37.7742076278049, -122.437751114779) | ||
| 8311 | 8311 | 5206 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 4X4 | 6001519.3329 | 2111090.328 | 37.7767370498578 | -122.438266314655 | (37.7767370498578, -122.438266314655) | |
| 8394 | 8394 | 97584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 818 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001564.5243 | 2111243.3358 | 37.777159740959895 | -122.43812094768101 | (37.7771597409599, -122.438120947681) | ||
| 8431 | 8431 | 97593 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001569.9782 | 2110730.4395 | 37.7757517668907 | -122.438065332169 | (37.7757517668907, -122.438065332169) | |||
| 17572 | 17572 | 5174 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/28/2006 12:00:00 AM | 3 | 3x4 | 6001785.2321 | 2109677.0482 | 37.7728716568906 | -122.437245274575 | (37.7728716568906, -122.437245274575) | |
| 17669 | 17669 | 5170 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 318 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6001801.5136 | 2109559.6859 | 37.7725503347821 | -122.43718055043101 | (37.7725503347821, -122.437180550431) | |
| 18219 | 18219 | 5158 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 275 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001773.6501 | 2109268.6052 | 37.771749515715605 | -122.437256087151 | (37.7717495157156, -122.437256087151) | |
| 18577 | 18577 | 5154 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001780.9624 | 2109220.4101 | 37.771617599631604 | -122.43722734206499 | (37.7716175996316, -122.437227342065) | ||
| 20046 | 20046 | 5155 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 265 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001777.3063 | 2109242.3472 | 37.7716776256193 | -122.43724155970399 | (37.7716776256193, -122.437241559704) | |
| 22018 | 22018 | 24636 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 443 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/17/2014 12:00:00 AM | 3 | 3X4 | 6001673.68932 | 2109984.60324 | 37.773709784823296 | -122.437653143592 | (37.7737097848233, -122.437653143592) | |
| 22149 | 22149 | 16024 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 776129 | 6001188.36813 | 2094689.80455 | 37.731686341545206 | -122.43823603107799 | (37.7316863415452, -122.438236031078) |
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");