trees

110 rows where qCaretaker_id = 2 and qSpecies_id = 100

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 10 ✖
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)
177628 93925 Permitted Site 7 Pinus Spp :: Pine Spp 100 3711 19th Ave 2 Sidewalk: Curb side : Yard Tree Private 2           5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
177806 211048 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 24 Sidewalk: Curb side : Yard Tree Private 2     25 Width 3ft   5994800.34548 2099248.4883 37.743837969354 -122.460650781424 (37.743837969354, -122.460650781424) 1 8 4 59 40
177971 200796 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015315.685 2088368.925 37.7151238332906 -122.388953494511 (37.7151238332906, -122.388953494511) 10 3 8 58 1
182249 173897 Undocumented 4 Pinus Spp :: Pine Spp 100 90x Knollview Way 1 Back Yard : Yard Tree Private 2       3x3   5997593 2101480 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281) 1 5 4 63 38
183847 185496 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2400 Sunset Blvd 50 unknown : Yard Tree Private 2     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.494003662835 (37.7416338578085, -122.494003662835) 1 8 3 29491 35
185727 185166 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985143.9825 2097713.2278 37.7390622665176 -122.493926616722 (37.7390622665176, -122.493926616722) 1 8 3 29491 35
192049 234489 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4067 20th St 2 Front Yard : Yard Tree Private 2     12 Width 3ft   6003294.37691 2104155.43702 37.7577963243568 -122.431630684215 (37.7577963243568, -122.431630684215) 2 4 5 28862 3
193255 185171 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2500 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985156.5992 2097759.0465 37.7391888105651 -122.493886370266 (37.7391888105651, -122.493886370266) 1 8 3 29491 35
193417 141493 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2901 TURK BLVD 17 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5996968.2673 2111507.0382 37.7776213292106 -122.45403981827 (37.7776213292106, -122.45403981827) 15 6 2 54 16
193841 211046 DPW Maintained 1 Pinus Spp :: Pine Spp 100 251 Wildwood Way 6 Sidewalk: Curb side : Yard Tree Private 2     19 Width 3ft   5995705.57302 2093291.07499 37.7275324053909 -122.457089894179 (37.7275324053909, -122.457089894179) 9 7 4 28861 40

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