trees

11 rows where Police Districts = 2 and qSpecies_id = 91

✎ View and edit SQL

This data as json, CSV (advanced)

Police 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)
4861 40879 Permitted Site 7 Schinus molle :: California Pepper 91 38 Washburn St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1976 12:00:00 AM     Permit Number 41789 6008346.99191908 2110451.53839796 37.775369049965 -122.414602124139 (37.775369049965, -122.414602124139) 8 2 9 28853 34
17498 49624 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 8   Permit Number 46480 6007909.99126 2109730.21129 37.7733638956484 -122.416062720842 (37.7733638956484, -122.416062720842) 8 2 9 28853 19
36540 49625 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM 6   Permit Number 768701 6007969.67353 2109667.22612 37.773194308705 -122.415851810006 (37.773194308705, -122.415851810006) 8 2 9 28853 19
38542 197482 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 1 : Tree Private 2     10 Width 3ft   6007465.83226 2109669.87011 37.7731732303985 -122.417594855315 (37.7731732303985, -122.417594855315) 8 2 9 28853 19
44107 111384 DPW Maintained 1 Schinus molle :: California Pepper 91 340 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x5   6014593.21542 2112428.75748 37.7811469919725 -122.393133189548 (37.7811469919725, -122.393133189548) 6 2 9 28856 6
59453 49620 DPW Maintained 1 Schinus molle :: California Pepper 91 180 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/30/2008 12:00:00 AM 5 3x3 Permit Number 768701 6007925.38179 2109711.75094 37.7733140732115 -122.416008175135 (37.7733140732115, -122.416008175135) 8 2 9 28853 19
63478 42173 DPW Maintained 1 Schinus molle :: California Pepper 91 466 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM 11   Permit Number 42461 6010347.47254 2109513.35928 37.7729052153318 -122.407615799844 (37.7729052153318, -122.407615799844) 14 2 9 28853 34
75526 108931 Undocumented 4 Schinus molle :: California Pepper 91 1099x NATOMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2x2 Permit Number 774500 6007500 2109279 37.772101916333 -122.417448958018 (37.772101916333, -122.417448958018) 8 2 9 28853 19
78357 197485 DPW Maintained 1 Schinus molle :: California Pepper 91 15 Lafayette St 2 : Tree Private 2     13 Width 3ft   6007471.02195 2109700.81958 37.773258502312 -122.417579097413 (37.773258502312, -122.417579097413) 8 2 9 28853 19
90218 197483 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 2 : Tree Private 2     7 Width 3ft   6007475.11808 2109661.30518 37.7731502356402 -122.417562127216 (37.7731502356402, -122.417562127216) 8 2 9 28853 19
181076 197484 DPW Maintained 1 Schinus molle :: California Pepper 91 99 Lafayette St 3 : Tree Private 2     8 Width 3ft   6007489.31465 2109652.98843 37.7731281986314 -122.417512429769 (37.7731281986314, -122.417512429769) 8 2 9 28853 19

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