trees
35 rows where SiteOrder = 2 and qLegalStatus_id = 5 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
18353 | 97155 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.95173 | 37.7190672497343 | -122.398087681509 | (37.7190672497343, -122.398087681509) | 10 | 3 | 8 | 58 | 1 | ||
12694 | 262268 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 2 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
3414 | 262418 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
9135 | 262279 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
15881 | 264923 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
16827 | 111314 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | ||||
15368 | 262300 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
6139 | 264669 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 1890 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 770415 | 6004581.61952 | 2097649.26106 | 37.7400047512279 | -122.426715548384 | (37.7400047512279, -122.426715548384) | 2 | 7 | 5 | 63 | 7 | |
10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
15653 | 164229 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991045.42225 | 2098958.21862 | 37.7428242157788 | -122.47361312736 | (37.7428242157788, -122.47361312736) | 1 | 8 | 4 | 29491 | 40 | |
18095 | 260879 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
16663 | 262231 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782723 | 5994180.46761 | 2100058.80006 | 37.7460271985036 | -122.462852932256 | (37.7460271985036, -122.462852932256) | 1 | 8 | 4 | 29491 | 40 | |
5321 | 264860 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 2 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
5719 | 108450 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6014379.30863 | 2103997.39375 | 37.7579844490278 | -122.393283028308 | (37.7579844490278, -122.393283028308) | 10 | 3 | 8 | 28856 | 29 | |||
11247 | 264702 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3x3 | Permit Number 783216 | 6005628.43923 | 2105332.18724 | 37.761159426347 | -122.42364218242 | (37.761159426347, -122.42364218242) | 2 | 4 | 5 | 28859 | 19 | ||
3836 | 261734 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
16603 | 110742 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010595.22782 | 2106018.33058 | 37.7633225306396 | -122.406512454011 | (37.7633225306396, -122.406512454011) | 8 | 4 | 8 | 28859 | 19 | ||
6383 | 228279 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
9006 | 112755 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2038 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 5989157.5 | 2111303.8 | 37.7766123371313 | -122.481044705999 | (37.7766123371313, -122.481044705999) | 11 | 6 | 2 | 55 | 26 | |||
194334 | 265023 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194401 | 265056 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
9912 | 103092 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008422.05981 | 2117808.63756 | 37.7955740826282 | -122.414863256344 | (37.7955740826282, -122.414863256344) | 5 | 1 | 10 | 308 | 21 | |
4024 | 114160 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.434397600465 | (37.7953804657925, -122.434397600465) | 13 | 9 | 1 | 57 | 17 | |
881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
194318 | 264973 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 3135 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 781901 | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |
17749 | 13265 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000636.2224 | 2119294.0135 | 37.7992119752158 | -122.441910200363 | (37.7992119752158, -122.441910200363) | 13 | 9 | 1 | 57 | 17 | |
3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 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) );