trees

27 rows where Fire Prevention Districts = 1 and qSpecies_id = 54 sorted by Location

✎ 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)
42047 97114 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1345 Noriega St 5 Sidewalk: Curb side : Cutout Tree Private 2     7   Permit Number 18860 5989801.9904 2103085.8445 37.7540855022306 -122.478214246151 (37.7540855022306, -122.478214246151) 1 8 3 56 35
140566 184648 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1691 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5983748.1287 2103659.9866 37.7553086603985 -122.49919205979 (37.7553086603985, -122.49919205979) 1 8 3 56 35
179052 182246 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1455 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5985863.116 2105312.6885 37.7599703705151 -122.491999577939 (37.7599703705151, -122.491999577939) 1 8 3 56 35
79297 182039 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1323 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5988935.747 2106319.8798 37.7629149697028 -122.481446720354 (37.7629149697028, -122.481446720354) 1 8 3 56 35
168247 43881 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1245 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2000 12:00:00 AM 3   Permit Number 43494 5981473.1113 2106617.2091 37.7632946239394 -122.507278997702 (37.7632946239394, -122.507278997702) 1 8 3 56 35
46162 183273 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1251 40th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5983646.3542 2106625.2038 37.7634443416971 -122.499763175358 (37.7634443416971, -122.499763175358) 1 8 3 56 35
57146 183272 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1251 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5983645.263 2106639.9345 37.7634847239936 -122.499768038252 (37.7634847239936, -122.499768038252) 1 8 3 56 35
90318 181727 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2755 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5987094.0342 2107004.1542 37.7646865433328 -122.487866760897 (37.7646865433328, -122.487866760897) 1 8 3 56 35
121615 181728 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2755 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987089.3098 2107026.595 37.7647478839827 -122.487884750055 (37.7647478839827, -122.487884750055) 1 8 3 56 35

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