trees

11 rows where Police Districts = 7 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)
5194 187549 DPW Maintained 1 Ficus Spp. :: 101 130 Alpha St 6 Front Yard : Yard Tree Private 2     4     6010899.87279 2088102.00857 37.714145178328 -122.404197749245 (37.714145178328, -122.404197749245) 9 7 8 309 39
9091 218801 DPW Maintained 1 Ficus Spp. :: 101 40 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5999835.96742 2095516.42127 37.7338790262872 -122.442970877111 (37.7338790262872, -122.442970877111) 9 7 4 63 40
12510 176400 DPW Maintained 1 Ficus Spp. :: 101 640 Rolph St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6002836.32134 2087254.29787 37.7113636849491 -122.432007969613 (37.7113636849491, -122.432007969613) 9 7 6 28861 5
27341 224467 DPW Maintained 1 Ficus Spp. :: 101 98 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005848.74864 2099086.12969 37.7440216271089 -122.422436402315 (37.7440216271089, -122.422436402315) 2 7 5 28859 2
34778 176401 DPW Maintained 1 Ficus Spp. :: 101 70 Seville St 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6001944.11467 2087434.6478 37.7118082639075 -122.435104550352 (37.7118082639075, -122.435104550352) 9 7 6 28861 5
67756 225378 DPW Maintained 1 Ficus Spp. :: 101 430 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007552.41754 2095692.96656 37.7348007108828 -122.416305201448 (37.7348007108828, -122.416305201448) 2 7 7 28859 2
99594 218964 DPW Maintained 1 Ficus Spp. :: 101 530 Rockdale Dr 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997978.47661 2097724.68038 37.7398362974137 -122.449551820875 (37.7398362974137, -122.449551820875) 9 7 4 59 40
119708 247640 DPW Maintained 1 Ficus Spp. :: 101 360 Bradford St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   6009458.549 2096552.39897 37.737267528773 -122.40977566383 (37.737267528773, -122.40977566383) 10 7 7 28859 2
132762 187569 DPW Maintained 1 Ficus Spp. :: 101 138 Alpha St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   6010894.99244 2088100.29699 37.7141402059746 -122.404214497313 (37.7141402059746, -122.404214497313) 9 7 8 309 39
157455 176396 DPW Maintained 1 Ficus Spp. :: 101 1212 Naples St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 8ft   6001083.28996 2087401.54083 37.7116684409161 -122.438077422145 (37.7116684409161, -122.438077422145) 9 7 6 28861 5
158423 707 DPW Maintained 1 Ficus Spp. :: 101 1504X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 6x6   6005209.59193 2099572.15952 37.7453200772679 -122.424681031927 (37.7453200772679, -122.424681031927) 2 7 5 63 22

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