trees

12 rows where PlotSize = "Width 4ft" and qSpecies_id = 119 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 4ft · 12 ✖
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)
153448 207728 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 3802 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.474661051582 (37.7196901687566, -122.474661051582) 9 8 4 64 40
11577 224121 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 499X Ogden Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452) 2 7 7 28859 2
9830 224122 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 499X Ogden Ave 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6008272.03754 2096094.48518 37.7359436331948 -122.413845611379 (37.7359436331948, -122.413845611379) 2 7 7 28859 2
8877 191703 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1501 Quint St 2 Front Yard : Yard Tree Private 2     7 Width 4ft   6013259.66608 2096346.42133 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818) 10 3 8 58 1
153174 191704 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1501 Quint St 3 Front Yard : Yard Tree Private 2     6 Width 4ft   6013263.69136 2096352.02038 37.7369298387513 -122.396605400918 (37.7369298387513, -122.396605400918) 10 3 8 58 1
163446 224131 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1340 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009255.1331 2101276.97976 37.7502287892492 -122.410812544378 (37.7502287892492, -122.410812544378) 2 4 7 28859 19
70351 224117 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 2818 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009831.98095 2102814.76339 37.7544835286044 -122.408926245167 (37.7544835286044, -122.408926245167) 2 4 7 28859 19
162017 224125 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1745 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6008033.82801 2108179.59599 37.7691132329216 -122.415524547646 (37.7691132329216, -122.415524547646) 8 4 7 28853 19
9793 126563 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1519 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006819.81222 2117673.20836 37.7951120685147 -122.420397705787 (37.7951120685147, -122.420397705787) 13 9 10 28858 32
123058 126564 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1519 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006833.89403 2117675.37487 37.7951188107324 -122.420349134325 (37.7951188107324, -122.420349134325) 13 9 10 28858 32
30972 126565 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1519 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6006864.87455 2117678.32819 37.795128665521 -122.420242146478 (37.795128665521, -122.420242146478) 13 9 10 28858 32
119596 126566 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 1519 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6006877.84584 2117681.84008 37.7951390391788 -122.420197513099 (37.7951390391788, -122.420197513099) 13 9 10 28858 32

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