trees

11 rows where SiteOrder = "" and qLegalStatus_id = 9

✎ 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)
99 255073 Private 9 Tree(s) :: 17 173R Glenview Dr   Back Yard : Yard Tree Private 2                              
23696 108446 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 672 05th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773773 5994431.81479 2110948.53978 37.7759420777365 -122.462773673163 (37.7759420777365, -122.462773673163) 11 6 2 54 11
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
65512 108459 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
86075 100243 Private 9 Tree(s) :: 17 1326-1332 Shotwell St   unknown : Yard Tree Private 2           6008043 2100485 37.7479861507453 -122.414948142067 (37.7479861507453, -122.414948142067) 2 7 7 28859 2
99316 108440 Private 9 Magnolia grandiflora :: Southern Magnolia 19 105 Lake St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
108163 104358 Private 9 Maytenus boaria :: Mayten 58 745X GOLDEN GATE AVE   Sidewalk: Curb side : Cutout Tree Private 2     10 3   6005986 2112447 37.7807151749226 -122.422911209833 (37.7807151749226, -122.422911209833) 7 9 11 28852 41
119017 105441 Private 9 Eucalyptus globulus :: Blue Gum 56 425 WAWONA ST   unknown : Yard Tree Private 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
149976 104650 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 346 LAKE ST   Sidewalk: Curb side : Cutout Tree Private 2     28 10x8   5994385.6 2114927.2 37.7868637456835 -122.463222305141 (37.7868637456835, -122.463222305141) 11 6 1 54 11
176299 104400 Private 9 Maytenus boaria :: Mayten 58 755 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5999044 2107976 37.768044800389 -122.446605071221 (37.768044800389, -122.446605071221) 15 5 11 29492 9
187934 108441 Private 9 Magnolia grandiflora :: Southern Magnolia 19 105 Lake St   Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11

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