trees

17 rows where qSpecies_id = 458

✎ View and edit SQL

This data as json, CSV (advanced)

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)
42372 240506 DPW Maintained 1 Rhus lancea :: African Sumac 458 4754 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5998323.19361 2105683.80957 37.7617098249778 -122.448933116975 (37.7617098249778, -122.448933116975) 15 5 11 29492 9
48315 240504 DPW Maintained 1 Rhus lancea :: African Sumac 458 120 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5997852.79018 2107172.20126 37.7657696587723 -122.450667358834 (37.7657696587723, -122.450667358834) 15 5 11 29492 9
80648 197369 DPW Maintained 1 Rhus lancea :: African Sumac 458 600 Minnesota St 7 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015140.46872 2105562.25205 37.7623234710833 -122.390759948833 (37.7623234710833, -122.390759948833) 10 3 8 28856 29
93505 246940 DPW Maintained 1 Rhus lancea :: African Sumac 458 281 Frederick St 1 : Tree Private 2     9 Width 3ft   5998696.10996 2107592.96793 37.7669732133571 -122.447780802167 (37.7669732133571, -122.447780802167) 15 5 11 29492 9
98461 117104 Undocumented 4 Rhus lancea :: African Sumac 458 50 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012112 2107534 37.7675689576739 -122.401372925553 (37.7675689576739, -122.401372925553) 14 3 8 28856 20
110411 41379 Permitted Site 7 Rhus lancea :: African Sumac 458 461 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2000 12:00:00 AM     Permit Number 42015 6003383.28248512 2102699.89411697 37.7538047881037 -122.431219318415 (37.7538047881037, -122.431219318415) 2 4 5 28862 22
139339 67567 DPW Maintained 1 Rhus lancea :: African Sumac 458 522 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 8   Permit Number 31119 6012945.59755 2104582.14803 37.7595102999921 -122.398282469265 (37.7595102999921, -122.398282469265) 10 3 8 28856 29
140004 117106 Undocumented 4 Rhus lancea :: African Sumac 458 50 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012112 2107534 37.7675689576739 -122.401372925553 (37.7675689576739, -122.401372925553) 14 3 8 28856 20
143120 117105 Undocumented 4 Rhus lancea :: African Sumac 458 50 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012112 2107534 37.7675689576739 -122.401372925553 (37.7675689576739, -122.401372925553) 14 3 8 28856 20
154952 240507 DPW Maintained 1 Rhus lancea :: African Sumac 458 14 Harper St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003651.52706 2098171.21141 37.7413852780042 -122.429968646251 (37.7413852780042, -122.429968646251) 2 7 5 63 7
160110 32420 Permitted Site 7 Rhus lancea :: African Sumac 458 1300 Ortega St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1996 12:00:00 AM     Permit Number 36947 5990009.30581449 2102467.22445118 37.752398967394 -122.477452096473 (37.752398967394, -122.477452096473) 1 8 3 56 35
160394 117107 Undocumented 4 Rhus lancea :: African Sumac 458 50 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012112 2107534 37.7675689576739 -122.401372925553 (37.7675689576739, -122.401372925553) 14 3 8 28856 20
168069 121991 DPW Maintained 1 Rhus lancea :: African Sumac 458 552 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5991294.35777 2111634.57186 37.7776445324771 -122.473676901026 (37.7776445324771, -122.473676901026) 11 6 2 54 26
170671 246909 DPW Maintained 1 Rhus lancea :: African Sumac 458 461 Frederick St 1 : Tree Private 2     9 Width 3ft   5997525.13816 2107428.63384 37.7664549970193 -122.451819132265 (37.7664549970193, -122.451819132265) 15 5 11 29492 9
174400 240505 DPW Maintained 1 Rhus lancea :: African Sumac 458 1360 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5998287.20919 2105695.11153 37.7617387993364 -122.449058386247 (37.7617387993364, -122.449058386247) 15 5 11 29492 9
184660 117103 Undocumented 4 Rhus lancea :: African Sumac 458 50 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012112 2107534 37.7675689576739 -122.401372925553 (37.7675689576739, -122.401372925553) 14 3 8 28856 20
188314 246908 DPW Maintained 1 Rhus lancea :: African Sumac 458 471 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997450.71112 2107418.45059 37.7664227734114 -122.452075825765 (37.7664227734114, -122.452075825765) 15 5 11 29492 9

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