trees

35 rows where SiteOrder = 2 and qLegalStatus_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlantType ✖

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