trees

21 rows where PlotSize = "3x3" and qSpecies_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • 3x3 · 21 ✖
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)
3739 261012 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 2 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
6708 256455 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2901 Sunset Blvd 4 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
9009 258692 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100x Whitney Young Cir   Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
12415 258693 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100 Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
18405 261011 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 1 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
18682 91505 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 21 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
42301 87834 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 10 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
53868 91504 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 18 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
72849 91503 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 15 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
83492 116067 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 4150X CLEMENT ST 5 Front Yard : Yard Tree DPW 1   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777818 5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
86234 173745 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
99863 114934 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 10 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
106659 111575 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1x SUNSET BLVD OFF RAMP 7 Median : Cutout Tree DPW 1     5 3x3   5984955 2095624 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577) 1 8 4 64 35
113218 114925 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 3 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
120683 255712 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 618x Mendell St 6 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
125671 91502 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
126819 257966 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 98X Clearfield Dr 1 Side Yard : Yard Tree Private 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
134883 87835 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 11 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
186953 173744 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
192931 173637 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1155 Market St 99 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008672 2111900 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097) 8 2 9 28853 34
193081 173746 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 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)
);