trees

14 rows where Neighborhoods (old) = 28 and qCaretaker_id = 4 sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Neighborhoods (old)

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)
16134 106952 Undocumented 4 Tree(s) :: 17 399X SOMERSET ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6009953 2092875 37.7271978698015 -122.407806879765 (37.7271978698015, -122.407806879765) 10 3 7 309 28
72835 253729 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
73519 253732 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
75070 253734 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
82489 253724 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
108286 253726 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
109856 253733 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
127602 253727 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
138444 253731 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
160599 253725 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
163044 106953 Undocumented 4 Tree(s) :: 17 399X SOMERSET ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4           6009953 2092875 37.7271978698015 -122.407806879765 (37.7271978698015, -122.407806879765) 10 3 7 309 28
181086 253730 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
183365 251680 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
190932 253728 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28

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