trees
1,011 rows where qLegalStatus_id = 2 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131688 | 198592 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013452.45897 | 2107129.35079 | 37.766532578853 | -122.396708048633 | (37.766532578853, -122.396708048633) | 14 | 3 | 8 | 28856 | 20 | |
139833 | 198581 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013801.3988 | 2107146.90693 | 37.7666001988537 | -122.395502349162 | (37.7666001988537, -122.395502349162) | 14 | 3 | 8 | 28856 | 20 | |
158870 | 198585 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013694.72301 | 2107142.03178 | 37.7665808787261 | -122.395870983078 | (37.7665808787261, -122.395870983078) | 14 | 3 | 8 | 28856 | 20 | |
166195 | 198588 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013599.81261 | 2107136.62549 | 37.766560753709 | -122.396198884879 | (37.766560753709, -122.396198884879) | 14 | 3 | 8 | 28856 | 20 | |
185470 | 198582 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013779.59756 | 2107146.17602 | 37.7665969792947 | -122.395577705173 | (37.7665969792947, -122.395577705173) | 14 | 3 | 8 | 28856 | 20 | |
189573 | 198589 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013524.37895 | 2107133.46335 | 37.76654787361 | -122.396459576758 | (37.76654787361, -122.396459576758) | 14 | 3 | 8 | 28856 | 20 | |
71921 | 256722 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009288 | 2098069 | 37.7414222265504 | -122.410472391962 | (37.7414222265504, -122.410472391962) | 10 | 7 | 7 | 28859 | 2 | |
155799 | 256869 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009287.99434 | 2098069.06568 | 37.7414224065761 | -122.410472416169 | (37.7414224065761, -122.410472416169) | 10 | 7 | 7 | 28859 | 2 | |
22638 | 113651 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
26508 | 113650 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
88035 | 113653 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
121557 | 113652 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
130377 | 113654 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
137539 | 113649 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
12861 | 253706 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
18342 | 253705 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
48832 | 243143 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
100425 | 243144 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
6991 | 112084 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
12720 | 115537 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
40425 | 115540 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
75364 | 115539 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
164265 | 115538 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
185440 | 115536 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
19151 | 242322 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006212.50813 | 2102671.12138 | 37.7538857096745 | -122.421433147433 | (37.7538857096745, -122.421433147433) | 2 | 4 | 5 | 28859 | 19 | |
78499 | 255416 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 |
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) );