10 rows where qLegalStatus_id = 8 and qSiteInfo = "Sidewalk: Property side : Yard" sorted by SiteOrder

View and edit SQL

qSiteInfo

  • Sidewalk: Property side : Yard · 10
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)
7701 97237 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave   Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
21821 97236 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 125 Excelsior Ave   Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
39203 97052 Property Tree 8 Pyrus spp :: Pear Tree 281 795 Wisconsin St   Sidewalk: Property side : Yard Tree Private 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
51341 97051 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 795 Wisconsin St   Sidewalk: Property side : Yard Tree Private 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
9668 264919 Property Tree 8 Olea Majestic Beauty :: 183 1833 Page St 1 Sidewalk: Property side : Yard Tree Public Library 12       3x3   5997789 2108763 37.7701339345343 -122.451002717521 (37.7701339345343, -122.451002717521) 15 5 11 29492 9
105992 258053 Property Tree 8 Pinus radiata :: Monterey Pine 15 1651 Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1       Width 5ft   5991822.8552 2096210.84451 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722) 1 8 4 59 40
106561 97238 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
112077 253339 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2019X 24th Ave 1 Sidewalk: Property side : Yard Tree PUC 8       3x3   5988853 2101569 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136) 1 8 3 29491 35
172414 256223 Property Tree 8 Schinus molle :: California Pepper 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree Rec/Park 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2
103773 252839 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 2 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3

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