trees

25 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 47 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 12 ✖
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)
174148 186310 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1800 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984966.7705 2102775.9332 37.7529527085207 -122.494912513249 (37.7529527085207, -122.494912513249) 1 8 3 56 35
136029 186000 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1883 47th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5981612.0444 2102288.7145 37.7514179925848 -122.506477461595 (37.7514179925848, -122.506477461595) 1 8 3 56 35
173649 186041 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1900 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     13 Width 0ft   5984992.0482 2102149.6578 37.7512346080754 -122.494778929254 (37.7512346080754, -122.494778929254) 1 8 3 29491 35
160576 186058 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1901 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984794.5256 2102183.7824 37.7513167410032 -122.495464490464 (37.7513167410032, -122.495464490464) 1 8 3 29491 35
165804 186059 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1901 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984803.9529 2102180.8195 37.7513091577006 -122.495431671777 (37.7513091577006, -122.495431671777) 1 8 3 29491 35
117562 217831 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 21 Sidewalk: Property side : Yard Tree Private 2     22     5991381.66969 2095739.82508 37.734006793868 -122.472215938837 (37.734006793868, -122.472215938837) 1 8 4 64 40
27854 185961 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2001 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984861.3455 2101337.8929 37.7489980727428 -122.495171051634 (37.7489980727428, -122.495171051634) 1 8 3 29491 35
80079 129470 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 45 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     10     6008463.14234 2119145.61201 37.7992473914164 -122.414815771241 (37.7992473914164, -122.414815771241) 5 1 10 308 32
50732 253463 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 2 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
70915 253464 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 3 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
150375 253465 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 4 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
159025 253462 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 1 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 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)
);