trees
8,298 rows where qLegalStatus_id = 4 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103781 | 108605 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1140x CHESTNUT ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6006369.1 | 2120452.7 | 37.8027184407042 | -122.422154803739 | (37.8027184407042, -122.422154803739) | 5 | 9 | 1 | 28858 | 32 | |||||
17203 | 107449 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1130x CHESTNUT ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 60 | 6006351.9 | 2120450.9 | 37.8027125282147 | -122.422214196597 | (37.8027125282147, -122.422214196597) | 5 | 9 | 1 | 28858 | 32 | ||||
64482 | 122824 | Undocumented 4 | Pittosporum spp :: Pittosporum spp 170 | 407x Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 6010366 | 2120356 | 37.8026775529699 | -122.408316614189 | (37.8026775529699, -122.408316614189) | 3 | 1 | 10 | 308 | 23 | |||||
69900 | 254752 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
120504 | 254750 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
167419 | 254751 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
8152 | 116289 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 5 | 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 | |||||
45892 | 116291 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 7 | 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 | |||||
56128 | 116290 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 6 | 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 | |||||
68754 | 116286 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 2 | 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 | |||||
83891 | 116287 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 3 | 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 | |||||
86603 | 116285 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 1 | 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 | |||||
118778 | 116293 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 9 | 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 | |||||
145255 | 116288 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 4 | 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 | |||||
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 | |||||
97400 | 97940 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
144868 | 97942 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
175348 | 97941 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
188461 | 97939 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
45331 | 107372 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 305x GREENWICH ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6011370 | 2120243 | 37.8024234525216 | -122.404834287898 | (37.8024234525216, -122.404834287898) | 3 | 1 | 10 | 308 | 23 | ||||
189272 | 173806 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007805.70004 | 2120292.05671 | 37.8023582786402 | -122.417172035787 | (37.8023582786402, -122.417172035787) | 5 | 1 | 1 | 308 | 32 | ||||
102614 | 127905 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 937 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 16 | Width 6ft | 6007996.96181 | 2120271.7748 | 37.8023133475557 | -122.416508736883 | (37.8023133475557, -122.416508736883) | 5 | 1 | 10 | 308 | 32 | |||
52989 | 121687 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1653 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010440 | 2120221 | 37.8023110197422 | -122.408051009419 | (37.8023110197422, -122.408051009419) | 3 | 1 | 10 | 308 | 23 | ||||
73387 | 113573 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007813 | 2120272 | 37.8023036186348 | -122.417145352251 | (37.8023036186348, -122.417145352251) | 5 | 1 | 10 | 308 | 32 | |||
104120 | 131002 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007919.06293 | 2120264.13988 | 37.8022880028424 | -122.416777764577 | (37.8022880028424, -122.416777764577) | 5 | 1 | 10 | 308 | 32 | ||
102454 | 131001 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.8022806446072 | -122.416822257668 | (37.8022806446072, -122.416822257668) | 5 | 1 | 10 | 308 | 32 | |||
139953 | 143072 | Undocumented 4 | :: 45 | 644 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6009782.327 | 2120221.5354 | 37.8022756451991 | -122.410326926401 | (37.8022756451991, -122.410326926401) | 3 | 1 | 10 | 308 | 23 | |||
172894 | 98358 | Undocumented 4 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 224@Napier Filbert St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6011805 | 2120142 | 37.8021704358049 | -122.403321855362 | (37.8021704358049, -122.403321855362) | 3 | 1 | 10 | 308 | 23 | ||||
466 | 116275 | Undocumented 4 | :: 45 | 700X Greenwich St | 2 | 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 | |||||
40034 | 116284 | Undocumented 4 | :: 45 | 700X Greenwich St | 11 | 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 | |||||
47978 | 116279 | Undocumented 4 | :: 45 | 700X Greenwich St | 6 | 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 | |||||
48387 | 116276 | Undocumented 4 | :: 45 | 700X Greenwich St | 3 | 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 | |||||
94093 | 116283 | Undocumented 4 | :: 45 | 700X Greenwich St | 10 | 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 | |||||
109200 | 116282 | Undocumented 4 | :: 45 | 700X Greenwich St | 9 | 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 | |||||
133404 | 116281 | Undocumented 4 | :: 45 | 700X Greenwich St | 8 | 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 | |||||
166962 | 116277 | Undocumented 4 | :: 45 | 700X Greenwich St | 4 | 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 | |||||
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 | |||||
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 | |||||
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 | |||||
20571 | 95244 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2626 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 10 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
24844 | 95247 | Undocumented 4 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2626 Larkin St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
67455 | 95245 | Undocumented 4 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2626 Larkin St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
107975 | 95243 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 10 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
164939 | 95246 | Undocumented 4 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2626 Larkin St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 767140 | 6006627 | 2120193 | 37.802019913523 | -122.421243885087 | (37.802019913523, -122.421243885087) | 5 | 9 | 1 | 28858 | 32 | |
50112 | 109625 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 312x FILBERT ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 14 | 6011362.9 | 2120079.8 | 37.801974948341 | -122.40484736081 | (37.801974948341, -122.40484736081) | 3 | 1 | 10 | 308 | 23 | ||||
165416 | 116893 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 176 ALHAMBRA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001452 | 2120263 | 37.8019190076456 | -122.439156822678 | (37.8019190076456, -122.439156822678) | 13 | 9 | 1 | 57 | 17 | ||||
9498 | 97930 | Undocumented 4 | Shrub :: Shrub 66 | 1615 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010461.1 | 2120070.1 | 37.801897866839 | -122.40796734514 | (37.801897866839, -122.40796734514) | 3 | 1 | 10 | 308 | 23 | ||||
115066 | 113570 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 901 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
124279 | 113571 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 901 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
177916 | 113574 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
185078 | 113572 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 901 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
147160 | 99960 | Undocumented 4 | Ulmus americana :: American Elm 74 | 279 Filbert St | 1 | Unaccepted Street : Yard | Tree | Private 2 | shared responsibility with 1400 Montgomery | 6011546.2 | 2120046.5 | 37.8018937585678 | -122.40421070766 | (37.8018937585678, -122.40421070766) | 3 | 1 | 10 | 308 | 23 | ||||
34994 | 112672 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500x FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010481 | 2120003 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | 3 | 1 | 10 | 308 | 23 | ||||
54711 | 112674 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500x FILBERT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010481 | 2120003 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | 3 | 1 | 10 | 308 | 23 | ||||
153635 | 112673 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500x FILBERT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010481 | 2120003 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | 3 | 1 | 10 | 308 | 23 | ||||
190860 | 112675 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500x FILBERT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010481 | 2120003 | 37.8017147408613 | -122.407893747059 | (37.8017147408613, -122.407893747059) | 3 | 1 | 10 | 308 | 23 | ||||
90211 | 96976 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 390X Filbert St | 1 | Median : Yard | Tree | Rec/Park 5 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | 3 | 1 | 10 | 308 | 23 | ||||
29140 | 108656 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
61782 | 108657 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
62966 | 108652 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
72090 | 108651 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
77431 | 108649 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
126383 | 108650 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
141871 | 108654 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
148471 | 108655 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
155881 | 108653 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
154778 | 100967 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2655 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006143 | 2119878 | 37.8011277057339 | -122.422896356717 | (37.8011277057339, -122.422896356717) | 13 | 9 | 1 | 28858 | 32 | ||||
95955 | 117473 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
114094 | 117472 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
73246 | 99725 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1195X Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | 5 | 1 | 1 | 28858 | 32 | |||
97677 | 99722 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1195X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | 5 | 1 | 1 | 28858 | 32 | |||
118753 | 99724 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1195X Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | 5 | 1 | 1 | 28858 | 32 | |||
158224 | 99721 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1195X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | 5 | 1 | 1 | 28858 | 32 | |||
166587 | 99723 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1195X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | 5 | 1 | 1 | 28858 | 32 | |||
9792 | 102746 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 801 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009087.2 | 2119736.4 | 37.8009045934233 | -122.412698096408 | (37.8009045934233, -122.412698096408) | 3 | 1 | 10 | 308 | 32 | ||||
97558 | 114475 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1254 MONTGOMERY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011527 | 2119680 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | 3 | 1 | 10 | 308 | 23 | ||||
155511 | 114474 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1254 MONTGOMERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011527 | 2119680 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | 3 | 1 | 10 | 308 | 23 | ||||
79637 | 117471 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 377 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2016 12:00:00 AM | 3 | 3x3 | 6011121 | 2119671 | 37.8008389594099 | -122.405655643253 | (37.8008389594099, -122.405655643253) | 3 | 1 | 10 | 308 | 23 | ||
59777 | 113939 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003181 | 2119826 | 37.8008173514055 | -122.433142433403 | (37.8008173514055, -122.433142433403) | 13 | 9 | 1 | 57 | 17 | |||||
61209 | 105786 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3230 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6x4 | 5999056.8 | 2119897.7 | 37.8007794095396 | -122.447418998501 | (37.8007794095396, -122.447418998501) | 13 | 9 | 1 | 57 | 17 | |||
34132 | 111168 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6003190.19669 | 2119810.74673 | 37.8007759915841 | -122.43310951859 | (37.8007759915841, -122.43310951859) | 13 | 9 | 1 | 57 | 17 | |||
15126 | 121049 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
24703 | 121054 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
37383 | 121052 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
74510 | 121050 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
100503 | 121051 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
160327 | 121053 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
50422 | 121422 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2466 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999524 | 2119846 | 37.8006641419807 | -122.445798577396 | (37.8006641419807, -122.445798577396) | 13 | 9 | 1 | 57 | 17 | ||||
39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
171204 | 129782 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012716.05958 | 2119492.70449 | 37.8004384679276 | -122.400123503796 | (37.8004384679276, -122.400123503796) | 3 | 1 | 10 | 28860 | 6 | |||
81928 | 107454 | Undocumented 4 | Tree(s) :: 17 | 2101 CHESTNUT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001686.4 | 2119715.1 | 37.8004279539124 | -122.438306415372 | (37.8004279539124, -122.438306415372) | 13 | 9 | 1 | 57 | 17 | ||||||
25527 | 117367 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3199X LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003762 | 2119666 | 37.8004109732815 | -122.431120504486 | (37.8004109732815, -122.431120504486) | 13 | 9 | 1 | 57 | 17 | ||||
142759 | 117366 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3199X LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003762 | 2119666 | 37.8004109732815 | -122.431120504486 | (37.8004109732815, -122.431120504486) | 13 | 9 | 1 | 57 | 17 | ||||
160863 | 129781 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012720.0769 | 2119456.93183 | 37.8003404688016 | -122.40010708848 | (37.8003404688016, -122.40010708848) | 3 | 1 | 10 | 28860 | 6 | |||
171029 | 108253 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2300X Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000847 | 2119667 | 37.8002481057388 | -122.441207614896 | (37.8002481057388, -122.441207614896) | 13 | 9 | 1 | 57 | 17 | |||||
24272 | 117475 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
42959 | 117474 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
67334 | 99615 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
85651 | 100050 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 |
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) );