trees
25 rows where qSpecies_id = 257
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3303 | 68432 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1445 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1993 12:00:00 AM | 9 | Permit Number 32283 | 6006081.5107 | 2118960.68558 | 37.7986055236957 | -122.423043899763 | (37.7986055236957, -122.423043899763) | 13 | 9 | 10 | 28858 | 32 | |
| 14533 | 197224 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1336 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017115.66664 | 2095724.62821 | 37.735420770957 | -122.383243621092 | (37.735420770957, -122.383243621092) | 10 | 3 | 8 | 58 | 1 | |||
| 19892 | 27457 | Permitted Site 7 | Quercus rubra :: Red Oak 257 | 1635 Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6X6 | 6015180.9491452 | 2100942.2926418 | 37.7496402929692 | -122.390297145115 | (37.7496402929692, -122.390297145115) | 10 | 3 | 8 | 58 | 1 | |||
| 49021 | 240344 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 842 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009894.55064 | 2104307.32496 | 37.758585272616 | -122.408815157307 | (37.758585272616, -122.408815157307) | 2 | 4 | 7 | 28859 | 19 | |||
| 54541 | 197223 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1334 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017120.47825 | 2095702.6834 | 37.735360780781 | -122.383225458398 | (37.735360780781, -122.383225458398) | 10 | 3 | 8 | 58 | 1 | |||
| 57190 | 36804 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1385 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39530 | 6015116.7008 | 2090849.9925 | 37.7219253276639 | -122.389814472907 | (37.7219253276639, -122.389814472907) | 10 | 3 | 8 | 58 | 1 | |
| 59497 | 27445 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | |||
| 61834 | 27448 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/2000 12:00:00 AM | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | ||
| 68833 | 27449 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | |||
| 69720 | 247883 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 387 Mayflower St | 4 | Side Yard : Yard | Tree | Private 2 | 12 | 6009924.04752 | 2098397.97998 | 37.7423611710447 | -122.408296348302 | (37.7423611710447, -122.408296348302) | 10 | 7 | 7 | 28859 | 2 | ||||
| 78509 | 199664 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1355 Donner Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015242.779 | 2090748.8863 | 37.7216547008053 | -122.3893715918 | (37.7216547008053, -122.3893715918) | 10 | 3 | 8 | 58 | 1 | |||
| 103198 | 27450 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | |||
| 108703 | 36803 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1385 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 12 | Permit Number 39530 | 6015095.3833 | 2090862.1739 | 37.7219575932003 | -122.389889013193 | (37.7219575932003, -122.389889013193) | 10 | 3 | 8 | 58 | 1 | |
| 116923 | 27456 | Permitted Site 7 | Quercus rubra :: Red Oak 257 | 1635 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6X6 | 6015180.9491452 | 2100942.2926418 | 37.7496402929692 | -122.390297145115 | (37.7496402929692, -122.390297145115) | 10 | 3 | 8 | 58 | 1 | |||
| 141380 | 27451 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | |||
| 141842 | 25581 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1511 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016164.07273 | 2097051.39101 | 37.7390111604396 | -122.386626154792 | (37.7390111604396, -122.386626154792) | 10 | 3 | 8 | 58 | 1 | ||
| 148730 | 27458 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1601 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015171.0309166 | 2101104.0584268 | 37.7500839176591 | -122.390342743888 | (37.7500839176591, -122.390342743888) | 10 | 3 | 8 | 58 | 1 | |||
| 152212 | 27447 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | |||
| 159670 | 36800 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1355 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39528 | 6015213.5435 | 2090772.6402 | 37.7217183034196 | -122.389474310063 | (37.7217183034196, -122.389474310063) | 10 | 3 | 8 | 58 | 1 | ||
| 159795 | 197221 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1339 Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017329.0729 | 2095119.55034 | 37.7337711382089 | -122.382463702063 | (37.7337711382089, -122.382463702063) | 10 | 3 | 8 | 58 | 1 | |||
| 176021 | 87063 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 3598 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49984 | 5997101.07551 | 2116041.83439 | 37.7900802933321 | -122.453907965995 | (37.7900802933321, -122.453907965995) | 11 | 6 | 1 | 54 | 31 | |
| 179659 | 27446 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 | |||
| 180737 | 36799 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1355 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39528 | 6015201.9711 | 2090779.34 | 37.7217360581121 | -122.389514780813 | (37.7217360581121, -122.389514780813) | 10 | 3 | 8 | 58 | 1 | ||
| 186838 | 197222 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1335 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017455.6221 | 2094929.65194 | 37.7332567044238 | -122.38201297442 | (37.7332567044238, -122.38201297442) | 10 | 3 | 8 | 58 | 1 | |||
| 189035 | 27444 | DPW Maintained 1 | Quercus rubra :: Red Oak 257 | 1699X Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | 6015194.057915 | 2100646.786978 | 37.7488296235385 | -122.390231171446 | (37.7488296235385, -122.390231171446) | 10 | 3 | 8 | 58 | 1 |
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) );