trees

13 rows where qSpecies_id = 190

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

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