trees
15 rows where qSiteInfo = "Median : Yard" and qSpecies_id = 6
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7686 | 116544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 7 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.7138425996209 | -122.436395723209 | (37.7138425996209, -122.436395723209) | 9 | 7 | 6 | 28861 | 5 | |||
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 29210 | 176917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | 9 | 7 | 6 | 28861 | 5 | ||||
| 44017 | 116540 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 3 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001555.50616 | 2088195.95431 | 37.7138765688354 | -122.436502141754 | (37.7138765688354, -122.436502141754) | 9 | 7 | 6 | 28861 | 5 | |||
| 58866 | 116551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 7 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.436608560332 | (37.713721490625, -122.436608560332) | 9 | 7 | 6 | 28861 | 5 | |||
| 65853 | 116538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 1 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001578.10158 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | 9 | 7 | 6 | 28861 | 5 | |||
| 69235 | 116543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001574.84931 | 2088164.89401 | 37.7137923832878 | -122.43643306305 | (37.7137923832878, -122.43643306305) | 9 | 7 | 6 | 28861 | 5 | |||
| 95040 | 116547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 3 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | 9 | 7 | 6 | 28861 | 5 | |||
| 116664 | 116546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001545.43478 | 2088113.86518 | 37.7136505979649 | -122.436531080144 | (37.7136505979649, -122.436531080144) | 9 | 7 | 6 | 28861 | 5 | |||
| 123255 | 116550 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001534.78323 | 2088160.34451 | 37.7137776146169 | -122.436571220504 | (37.7137776146169, -122.436571220504) | 9 | 7 | 6 | 28861 | 5 | |||
| 138388 | 116548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 4 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001544.87474 | 2088178.15499 | 37.7138270917124 | -122.436537614614 | (37.7138270917124, -122.436537614614) | 9 | 7 | 6 | 28861 | 5 | |||
| 138570 | 116539 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001567.48738 | 2088213.72569 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | 9 | 7 | 6 | 28861 | 5 | |||
| 139455 | 116549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 5 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001562.82912 | 2088145.24079 | 37.7137377368707 | -122.436473203396 | (37.7137377368707, -122.436473203396) | 9 | 7 | 6 | 28861 | 5 | |||
| 144424 | 116545 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 1 | Median : Yard | Tree | DPW 1 | 2 | 3x3 | 6001537.05763 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | 9 | 7 | 6 | 28861 | 5 | |||
| 155326 | 176918 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 9 | Median : Yard | Tree | DPW 1 | 4 | 6001604.80367 | 2088215.91202 | 37.7139341694897 | -122.436333178956 | (37.7139341694897, -122.436333178956) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );