trees

12 rows where Neighborhoods (old) = 22 and qSpecies_id = 224

✎ View and edit SQL

This data as json, CSV (advanced)

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)
35244 104763 Undocumented 4 Magnolia spp :: Magnolia 224 51 VICKSBURG ST 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004133.6 2102760.4 37.7540134146385 -122.428628860828 (37.7540134146385, -122.428628860828) 2 4 5 28862 22
43347 53478 Permitted Site 7 Magnolia spp :: Magnolia 224 51 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004118.50395547 2102762.60365408 37.7540186110043 -122.428681223641 (37.7540186110043, -122.428681223641) 2 4 5 28862 22
47827 86711 Permitted Site 7 Magnolia spp :: Magnolia 224 3714 Cesar Chavez St   Sidewalk: Curb side : Cutout Tree Private 2   09/24/2007 12:00:00 AM 6   Permit Number 49697 6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
54455 110680 Undocumented 4 Magnolia spp :: Magnolia 224 162 DUNCAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005508 2099957 37.7463936103079 -122.423676542195 (37.7463936103079, -122.423676542195) 2 7 5 28859 22
70600 85257 Permitted Site 7 Magnolia spp :: Magnolia 224 689 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49556 6001247 2102379 37.7528023963993 -122.438584066967 (37.7528023963993, -122.438584066967) 2 4 5 28862 22
81356 52263 Permitted Site 7 Magnolia spp :: Magnolia 224 40 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48428 6005651.79801021 2099662.26802464 37.7455924596089 -122.423158358307 (37.7455924596089, -122.423158358307) 2 7 5 28859 22
85331 67833 Permitted Site 7 Magnolia spp :: Magnolia 224 469 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/1992 12:00:00 AM   3x3 Permit Number 31495 6002871.84745267 2099449.75945792 37.7448516873624 -122.432755816877 (37.7448516873624, -122.432755816877) 2 7 5 63 22
107038 84073 Permitted Site 7 Magnolia spp :: Magnolia 224 3936 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50418 6003544.24731161 2102468.85848111 37.7531795392658 -122.43064618026 (37.7531795392658, -122.43064618026) 2 4 5 28862 22
160215 115761 Undocumented 4 Magnolia spp :: Magnolia 224 924 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6003074 2102857 37.7542186318325 -122.432300106993 (37.7542186318325, -122.432300106993) 2 4 5 28862 22
168477 112552 Permitted Site 7 Magnolia spp :: Magnolia 224 51 VICKSBURG ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6004133 2102760 37.7540122823763 -122.42863090726 (37.7540122823763, -122.42863090726) 2 4 5 28862 22
170048 53927 Permitted Site 7 Magnolia spp :: Magnolia 224 616-618 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1972 12:00:00 AM     Permit Number 9640 6001839.32774762 2102295.7359044 37.752607450257 -122.436529733585 (37.752607450257, -122.436529733585) 2 4 5 28862 22
178575 96914 Undocumented 4 Magnolia spp :: Magnolia 224 4396X 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM   3x3 Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. 6000641.3 2102303.1 37.7525595190983 -122.440673239158 (37.7525595190983, -122.440673239158) 2 4 5 28862 22

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