trees

21 rows where qCaretaker_id = 7 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Dept of Real Estate · 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)
8874 15149 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
11093 95037 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3224 Pierce St 8 Sidewalk: Property side : Cutout Tree Dept of Real Estate 7     10 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
19070 15154 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 8 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
27832 15155 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
31550 15160 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 14 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
34792 15148 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
39622 15164 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 18 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
45235 15147 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
58538 15152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
67792 15158 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 12 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
68900 15165 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 19 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
92451 15169 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 23 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
103078 15168 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 22 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
110518 15161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 15 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
112808 15167 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 21 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
115831 15162 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 16 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
121554 15163 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 17 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143433 15157 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 11 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143636 15150 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 3x3   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
156055 653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3255X 24th St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     3 4x4   6007260.4251 2102038.7621 37.7522084236972 -122.417764377532 (37.7522084236972, -122.417764377532) 2 4 7 28859 19
185169 15159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 13 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7 Private   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34

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