trees

10 rows where Neighborhoods (old) = 40, SiteOrder = 2 and qSpecies_id = 5 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: SiteOrder, Neighborhoods (old)

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)
149414 205991 DPW Maintained 1 Ceratonia siliqua :: Carob 5 452 Kenwood Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993388.91946 2093682.37508 37.7284735045328 -122.465126926677 (37.7284735045328, -122.465126926677) 9 8 4 59 40
179167 206017 DPW Maintained 1 Ceratonia siliqua :: Carob 5 59 Hazelwood Ave 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5996580.00391 2094034.75678 37.7296245567167 -122.454120687124 (37.7296245567167, -122.454120687124) 9 7 4 28861 40
38322 206016 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
174999 205996 DPW Maintained 1 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998822.4881 2096514.65172 37.7365620951723 -122.446546561796 (37.7365620951723, -122.446546561796) 9 7 4 59 40
6377 82142 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
21860 206006 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600 Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991049.3393 2097743.54574 37.7394892625221 -122.473511002145 (37.7394892625221, -122.473511002145) 1 8 4 29491 40
111983 206019 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5994816.51833 2099704.78199 37.7450917681756 -122.460627918846 (37.7450917681756, -122.460627918846) 1 8 4 59 40
188809 218314 DPW Maintained 1 Ceratonia siliqua :: Carob 5 437 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5993129.70143 2099920.62697 37.7455872325622 -122.466476271275 (37.7455872325622, -122.466476271275) 1 8 4 29491 40
91647 205994 DPW Maintained 1 Ceratonia siliqua :: Carob 5 334 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5994253.11993 2101023.44894 37.7486800649323 -122.462671676761 (37.7486800649323, -122.462671676761) 1 8 4 29491 40
161171 113383 Undocumented 4 Ceratonia siliqua :: Carob 5 146 CASTENADA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5994461 2101055 37.7487786662853 -122.461955122224 (37.7487786662853, -122.461955122224) 1 8 4 29491 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)
);