trees

13 rows where Police Districts = 1 and qSpecies_id = 101

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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)
2824 133031 DPW Maintained 1 Ficus Spp. :: 101 899 Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009745.43403 2116066.84146 37.7908658043502 -122.410161098851 (37.7908658043502, -122.410161098851) 5 1 10 28857 21
6787 133029 DPW Maintained 1 Ficus Spp. :: 101 899 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009680.35355 2116058.51937 37.790839305841 -122.410385687447 (37.790839305841, -122.410385687447) 5 1 10 28857 21
9225 133028 DPW Maintained 1 Ficus Spp. :: 101 899 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6009667.91212 2116056.30445 37.7908325267578 -122.410428577933 (37.7908325267578, -122.410428577933) 5 1 10 28857 21
10698 133030 DPW Maintained 1 Ficus Spp. :: 101 899 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009729.40628 2116065.59782 37.7908614912255 -122.410216466534 (37.7908614912255, -122.410216466534) 5 1 10 28857 21
11426 113463 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
26643 126615 DPW Maintained 1 Ficus Spp. :: 101 728 Washington St 2 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6011119.33477 2117657.8785 37.7953113232058 -122.405519543093 (37.7953113232058, -122.405519543093) 3 1 10 28857 4
30356 39213 DPW Maintained 1 Ficus Spp. :: 101 1143 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/1998 12:00:00 AM 5   Permit Number 40857 6008076.21791 2116463.13279 37.7918602198281 -122.415964603882 (37.7918602198281, -122.415964603882) 5 1 10 28858 21
34442 113460 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
61683 113459 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
116092 126614 DPW Maintained 1 Ficus Spp. :: 101 728 Washington St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6011128.85528 2117659.08548 37.7953151696175 -122.40548668546 (37.7953151696175, -122.40548668546) 3 1 10 28857 4
135703 113461 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
139019 113462 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
194037 42829 DPW Maintained 1 Ficus Spp. :: 101 74 Bernard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/2000 12:00:00 AM 8   Permit Number 42766 6008488.5125 2118110.11878 37.7964056092797 -122.414654663105 (37.7964056092797, -122.414654663105) 5 1 10 308 21

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