trees

35 rows where SiteOrder = 2 and qLegalStatus_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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                        
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
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
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
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
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
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
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
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
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
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
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
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                    
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);