trees

16 rows where qCareAssistant = "FUF" and qSpecies_id = 182

✎ View and edit SQL

This data as json, CSV (advanced)

qCareAssistant ✖

  • FUF · 16 ✖
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)
8168 38578 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 1539 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 4   Permit Number 40538 6015192.4143 2094984.0689 37.7332808746097 -122.389841369045 (37.7332808746097, -122.389841369045) 10 3 8 58 1
19262 36798 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 1355 Donner Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 6   Permit Number 39528 6015230.5975 2090758.0224 37.7216791113631 -122.389414338057 (37.7216791113631, -122.389414338057) 10 3 8 58 1
31151 63533 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 368 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1987 12:00:00 AM     Permit Number 24146 6006703.62861604 2103973.71687458 37.7574900150011 -122.419827158071 (37.7574900150011, -122.419827158071) 2 4 7 28859 19
60740 36802 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 1365 Donner Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39529 6015184.51378884 2090800.41329061 37.72179295326 -122.389576597698 (37.72179295326, -122.389576597698) 10 3 8 58 1
76903 36801 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 1365 Donner Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39529 6015184.51378884 2090800.41329061 37.72179295326 -122.389576597698 (37.72179295326, -122.389576597698) 10 3 8 58 1
79184 47725 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 85 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604) 8 4 7 28859 19
81764 31802 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 55 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 7   Permit Number 35272 6001924.59605 2107955.77099 37.7681533775015 -122.436639968257 (37.7681533775015, -122.436639968257) 15 5 5 29492 3
107531 46811 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 172 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM     Permit Number 44893 5994497.83320908 2096348.947315 37.7358591414077 -122.461486623647 (37.7358591414077, -122.461486623647) 9 8 4 59 40
119773 36542 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 190 Gates St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39415 6008260.22671845 2097736.01770388 37.7404502589313 -122.414002536769 (37.7404502589313, -122.414002536769) 2 7 7 28859 2
120084 41701 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 34 Natick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42151 6003036.29664011 2095600.66365718 37.734292282497 -122.431912391757 (37.734292282497, -122.431912391757) 2 7 5 63 7
122155 39492 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 3927 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40950 6004349.11347 2100706.94457928 37.7483872992809 -122.427737263904 (37.7483872992809, -122.427737263904) 2 4 5 63 22
128865 37269 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 3720 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/2002 12:00:00 AM     Permit Number 44410 6003590.32041295 2103642.33347016 37.7564042340637 -122.430570577111 (37.7564042340637, -122.430570577111) 2 4 5 28862 3
156754 63534 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 345 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1987 12:00:00 AM     Permit Number 24147 6006748.16886694 2104110.61481304 37.7578684141543 -122.419682832788 (37.7578684141543, -122.419682832788) 2 4 7 28859 19
181346 46812 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 172 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM     Permit Number 44893 5994497.83320908 2096348.947315 37.7358591414077 -122.461486623647 (37.7358591414077, -122.461486623647) 9 8 4 59 40
188175 63790 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 4064 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24476 6003436.69055965 2101294.50423962 37.7499489448753 -122.430934327568 (37.7499489448753, -122.430934327568) 2 4 5 28862 22
193640 55969 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 35 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2000 12:00:00 AM     Permit Number 770524 6007464.012592 2099914.14210495 37.7463861516938 -122.416909822502 (37.7463861516938, -122.416909822502) 2 7 7 28859 2

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