trees

24 rows where Fire Prevention Districts = 8 and qSpecies_id = 43 sorted by qLegalStatus_id

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
10339 73455 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 24 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6009841.50181 2111066.87201 37.777142462881 -122.409475680552 (37.777142462881, -122.409475680552) 8 2 9 28853 34
64957 9986 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2007 12:00:00 AM 8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
139804 191035 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 30 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6009859.31671 2111047.24968 37.7770895827422 -122.409412667772 (37.7770895827422, -122.409412667772) 8 2 9 28853 34
161440 9987 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
91288 106921 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 112-118 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6007680.5 2107244.2 37.7665249882726 -122.416680417976 (37.7665249882726, -122.416680417976) 8 4 7 28853 19
5456 38303 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
28860 36076 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2091 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39189 6008123.15826597 2106262.62233667 37.7638546903501 -122.415079851694 (37.7638546903501, -122.415079851694) 8 4 7 28859 19
34131 38301 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
46799 38320 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1810 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40378 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
58172 38315 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
67646 39064 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
71856 36717 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1999 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
95507 36720 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
100539 39065 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
112873 38302 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
131078 31826 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
139708 31829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
151832 36719 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
152141 40299 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2155 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41445 6006883.99939755 2105792.08668164 37.7624929958367 -122.419332354319 (37.7624929958367, -122.419332354319) 8 4 7 28859 19
156451 31830 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
170901 36718 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
172166 36078 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2134 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39191 6008086.14600314 2105996.63644369 37.7631222746353 -122.415189036821 (37.7631222746353, -122.415189036821) 8 4 7 28859 19
172252 31827 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
193933 40300 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2155 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1999 12:00:00 AM     Permit Number 41445 6006883.99939755 2105792.08668164 37.7624929958367 -122.419332354319 (37.7624929958367, -122.419332354319) 8 4 7 28859 19

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