trees

28 rows where PlotSize = "3x3" and qSpecies_id = 101

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • 3x3 · 28 ✖
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)
405 113785 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
1942 113791 Undocumented 4 Ficus Spp. :: 101 1152 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
4480 264867 DPW Maintained 1 Ficus Spp. :: 101 2342 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015719 2104683 37.7599413148953 -122.388697626707 (37.7599413148953, -122.388697626707) 10 3 8 28856 29
11426 113463 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
11513 113786 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
16794 261146 Significant Tree 6 Ficus Spp. :: 101 375x Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2020 12:00:00 AM 3 3x3   6014494 2112212 37.780546313007 -122.393461254196 (37.780546313007, -122.393461254196) 6 2 9 28856 6
18212 113784 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
19924 114954 Undocumented 4 Ficus Spp. :: 101 601x OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
34442 113460 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
61683 113459 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
73906 113789 Undocumented 4 Ficus Spp. :: 101 1156 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008031 2101136 37.7497729763299 -122.415035709272 (37.7497729763299, -122.415035709272) 2 4 7 28859 19
83028 6852 DPW Maintained 1 Ficus Spp. :: 101 1595X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/2014 12:00:00 AM 3 3x3   6015511.2548 2098235.70607 37.7422268842679 -122.38896598302 (37.7422268842679, -122.38896598302) 10 3 8 58 1
83047 115110 Undocumented 4 Ficus Spp. :: 101 1500x VALLEJO ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006364 2118351 37.7969474175895 -122.422023061413 (37.7969474175895, -122.422023061413) 13 9 10 28858 32
95857 115108 Undocumented 4 Ficus Spp. :: 101 1500x VALLEJO ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006364 2118351 37.7969474175895 -122.422023061413 (37.7969474175895, -122.422023061413) 13 9 10 28858 32
105600 114223 Undocumented 4 Ficus Spp. :: 101 3756 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004683 2102542 37.7534448164726 -122.426713351505 (37.7534448164726, -122.426713351505) 2 4 5 28862 22
114518 115107 Undocumented 4 Ficus Spp. :: 101 1500x VALLEJO ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006364 2118351 37.7969474175895 -122.422023061413 (37.7969474175895, -122.422023061413) 13 9 10 28858 32
116657 115109 Undocumented 4 Ficus Spp. :: 101 1500x VALLEJO ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006364 2118351 37.7969474175895 -122.422023061413 (37.7969474175895, -122.422023061413) 13 9 10 28858 32
121592 113788 Undocumented 4 Ficus Spp. :: 101 1156 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008031 2101136 37.7497729763299 -122.415035709272 (37.7497729763299, -122.415035709272) 2 4 7 28859 19
123567 116606 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 1 Sidewalk: Property side : Cutout Tree MTA 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
125239 113790 Undocumented 4 Ficus Spp. :: 101 1152 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
135703 113461 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
139019 113462 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
142301 114953 Undocumented 4 Ficus Spp. :: 101 601x OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
145371 116609 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 4 Sidewalk: Property side : Cutout Tree MTA 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
145690 116607 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
147349 113787 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
153596 116608 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 3 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
173844 115019 Undocumented 4 Ficus Spp. :: 101 57 POND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6003214 2106188 37.7633726979345 -122.432053803459 (37.7633726979345, -122.432053803459) 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)
);