trees

12 rows where SiteOrder = "" and qSpecies_id = 31

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
6695 260396 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
10535 258146 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1048 Folsom St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6010642.12041 2111257.36423 37.7777103373451 -122.406719502289 (37.7777103373451, -122.406719502289) 14 2 9 28853 34
12615 87685 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 118 Virginia Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733) 2 7 7 28859 2
43704 88338 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 315 Paris St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51325 6002541 2091742 37.7236691751532 -122.433349150158 (37.7236691751532, -122.433349150158) 9 7 6 28861 5
57138 104401 Private 9 Ulmus parvifolia :: Chinese Elm 31 727 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999017 2108166 37.768564950056 -122.44671213341 (37.768564950056, -122.44671213341) 15 5 11 29492 9
87095 88329 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 120 London St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51317 6002940 2092960 37.7270361584814 -122.432056812936 (37.7270361584814, -122.432056812936) 9 7 6 28861 5
118552 110612 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 15 MAGELLAN AVE   Sidewalk: Property side : Cutout Tree Private 2   05/12/2015 12:00:00 AM 3 3x3 Permit Number 775412 5994586 2101167 37.7490933856104 -122.461530994698 (37.7490933856104, -122.461530994698) 1 8 4 29491 40
147491 88436 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1631 Folsom St   Sidewalk: Curb side : Cutout Tree Private 2   07/11/2008 12:00:00 AM   3x3 Permit Number 51400 6008146 2108680 37.7704935294513 -122.415171976468 (37.7704935294513, -122.415171976468) 8 2 9 28853 19
148155 107599 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 177 CORBETT AVE   Sidewalk: Curb side : Cutout Tree Private 2           6000269.8 2105595.5 37.7615784812961 -122.442194269292 (37.7615784812961, -122.442194269292) 15 5 5 28862 3
159379 92019 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 129 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2009 12:00:00 AM   3x3 Permit Number 52167 6008096 2112840 37.7819130903868 -122.415639514466 (37.7819130903868, -122.415639514466) 7 10 9 28852 36
170626 88830 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St   Sidewalk: Curb side : Cutout Tree Private 2   09/10/2008 12:00:00 AM   3x3 Permit Number 51714 6015215 2104389 37.7591061085001 -122.390420190559 (37.7591061085001, -122.390420190559) 10 3 8 28856 29
175636 88555 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 609 16th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51500 5990920.3 2111212.9 37.7764650666065 -122.474940092984 (37.7764650666065, -122.474940092984) 11 6 2 54 26

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