trees
17 rows where qSpecies_id = 458 sorted by Supervisor Districts
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );