trees
13 rows where qSpecies_id = 190 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115527 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 190 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
1518 | 99500 | Permitted Site 7 | Aesculus hippocastanum :: White Horsechestnut 190 | 2698@Divisadero Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000656 | 2117555 | 37.7944382299983 | -122.441716891944 | (37.7944382299983, -122.441716891944) | 13 | 9 | 1 | 57 | 27 | |||||
32173 | 245451 | DPW Maintained 1 | Aesculus hippocastanum :: White Horsechestnut 190 | 2700 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008644.261 | 2106851.8345 | 37.7655018009993 | -122.413319179244 | (37.7655018009993, -122.413319179244) | 8 | 4 | 7 | 28853 | 19 | |||
40709 | 99502 | Permitted Site 7 | Aesculus hippocastanum :: White Horsechestnut 190 | 2698@Divisadero Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000656 | 2117555 | 37.7944382299983 | -122.441716891944 | (37.7944382299983, -122.441716891944) | 13 | 9 | 1 | 57 | 27 | |||||
53063 | 143080 | DPW Maintained 1 | Aesculus hippocastanum :: White Horsechestnut 190 | 439 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010709.7849 | 2120304.4444 | 37.8025552389297 | -122.407123302713 | (37.8025552389297, -122.407123302713) | 3 | 1 | 10 | 308 | 23 | |||
57012 | 220554 | DPW Maintained 1 | Aesculus hippocastanum :: White Horsechestnut 190 | 3145 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6008127.01691 | 2102675.68218 | 37.7540059913019 | -122.4148126317 | (37.7540059913019, -122.4148126317) | 2 | 4 | 7 | 28859 | 19 | |||
58695 | 220553 | DPW Maintained 1 | Aesculus hippocastanum :: White Horsechestnut 190 | 3145 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008090.93117 | 2102673.2685 | 37.7539973362258 | -122.41493725437 | (37.7539973362258, -122.41493725437) | 2 | 4 | 7 | 28859 | 19 | |||
76194 | 99501 | Permitted Site 7 | Aesculus hippocastanum :: White Horsechestnut 190 | 2698@Divisadero Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000656 | 2117555 | 37.7944382299983 | -122.441716891944 | (37.7944382299983, -122.441716891944) | 13 | 9 | 1 | 57 | 27 | |||||
105850 | 220556 | DPW Maintained 1 | Aesculus hippocastanum :: White Horsechestnut 190 | 3145 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008195.30433 | 2102681.0739 | 37.7540246324529 | -122.41457685826 | (37.7540246324529, -122.41457685826) | 2 | 4 | 7 | 28859 | 19 | |||
144542 | 220555 | DPW Maintained 1 | Aesculus hippocastanum :: White Horsechestnut 190 | 3145 23rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008162.12941 | 2102678.11582 | 37.7540146463708 | -122.414691376121 | (37.7540146463708, -122.414691376121) | 2 | 4 | 7 | 28859 | 19 | |||
154139 | 106709 | Undocumented 4 | Aesculus hippocastanum :: White Horsechestnut 190 | 1027 Florida St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2014 12:00:00 AM | 3X3 | Permit Number 772684 | 6009474.8 | 2103180.3 | 37.7554671959872 | -122.410187281194 | (37.7554671959872, -122.410187281194) | 2 | 4 | 7 | 28859 | 19 | |||
164884 | 99503 | Permitted Site 7 | Aesculus hippocastanum :: White Horsechestnut 190 | 2698@Divisadero Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000656 | 2117555 | 37.7944382299983 | -122.441716891944 | (37.7944382299983, -122.441716891944) | 13 | 9 | 1 | 57 | 27 | |||||
176327 | 99504 | Permitted Site 7 | Aesculus hippocastanum :: White Horsechestnut 190 | 2698 VALLEJO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000707 | 2117582 | 37.7945152706116 | -122.441542364689 | (37.7945152706116, -122.441542364689) | 13 | 9 | 1 | 57 | 27 |
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) );