19 rows where Supervisor Districts = 10 and qLegalStatus_id = 2

View and edit SQL

Police Districts

  • 9 13
  • 1 6

Supervisor Districts

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)
5412 261620 Planning Code 138.1 required 2 Tree(s) :: 17 1633 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2020 12:00:00 AM 3 3x3   6006860 2117000 37.7932658708928 -122.420210847334 (37.7932658708928, -122.420210847334) 13 9 10 28858 32
20307 253871 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1601 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 3x3 Permit Number 56289 6007037 2116831 37.7928118105792 -122.419586418272 (37.7928118105792, -122.419586418272) 13 9 10 28858 32
25098 257924 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
45019 253872 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1601 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 3x3 Permit Number 56289 6007037 2116831 37.7928118105792 -122.419586418272 (37.7928118105792, -122.419586418272) 13 9 10 28858 32
50619 257922 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
72671 255301 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1238 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2018 12:00:00 AM 3 3x3 Permit Number 777218 6006649 2115006 37.7877789501949 -122.420799295532 (37.7877789501949, -122.420799295532) 13 9 10 28858 21
78246 143041 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 2000 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2017 12:00:00 AM 3 Width 0ft Permit Number 780933 6009568.471 2120534.3867 37.8031226669303 -122.411089086343 (37.8031226669303, -122.411089086343) 3 1 10 308 23
104150 257920 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
129695 116776 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.413648471894 (37.7960980717264, -122.413648471894) 5 1 10 308 21
136966 116777 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008763.52683 2117990.43413 37.7960924320727 -122.413694581941 (37.7960924320727, -122.413694581941) 5 1 10 308 21
156271 253867 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1628 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 Width 3ft Permit Number 56289 6006959.29312 2116755.16361 37.7925992053311 -122.419849904466 (37.7925992053311, -122.419849904466) 13 9 10 28858 32
156329 253868 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1628 Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 Width 3ft Permit Number 56289 6006959.29312 2116755.16361 37.7925992053311 -122.419849904466 (37.7925992053311, -122.419849904466) 13 9 10 28858 32
160601 255300 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1238 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2018 12:00:00 AM 3 3x3 Permit Number 777218 6006649 2115006 37.7877789501949 -122.420799295532 (37.7877789501949, -122.420799295532) 13 9 10 28858 21
171427 116774 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008811.21548 2117995.14613 37.7961080479024 -122.413529902601 (37.7961080479024, -122.413529902601) 5 1 10 308 21
178936 257923 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
179226 253869 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1601 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 3x3 Permit Number 56289 6007037 2116831 37.7928118105792 -122.419586418272 (37.7928118105792, -122.419586418272) 13 9 10 28858 32
186623 257921 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
190292 116775 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008794.04431 2117993.28546 37.7961019747828 -122.413589186808 (37.7961019747828, -122.413589186808) 5 1 10 308 21
190939 13063 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 590 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2017 12:00:00 AM 3 2X2 Permit Number 780933 6009554.3361 2120533.7978 37.803120257284 -122.411137959105 (37.803120257284, -122.411137959105) 3 1 10 308 23

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