trees

14 rows where Zip Codes = 28859 and qLegalStatus_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28859 · 7 ✖
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)
11247 264702 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 625 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM   3x3 Permit Number 783216 6005628.43923 2105332.18724 37.761159426347 -122.42364218242 (37.761159426347, -122.42364218242) 2 4 5 28859 19
14075 110744 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010545.16814 2106015.79361 37.7633127639997 -122.406685416098 (37.7633127639997, -122.406685416098) 8 4 8 28859 19
15368 262300 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
16257 225172 Section 806 (d) 5 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 248 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2020 12:00:00 AM 3 4x4 Permit Number 779647 6006535.62128 2098220.14009 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071) 2 7 7 28859 2
16603 110742 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010595.22782 2106018.33058 37.7633225306396 -122.406512454011 (37.7633225306396, -122.406512454011) 8 4 8 28859 19
17154 110741 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010604.54028 2106019.56363 37.7633264372932 -122.406480331995 (37.7633264372932, -122.406480331995) 8 4 8 28859 19
18916 152848 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 160 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2019 12:00:00 AM 3 Width 3ft Permit Number 781252 6006654.74312 2105190.58967 37.7608285109489 -122.420082580673 (37.7608285109489, -122.420082580673) 2 4 7 28859 19

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