trees
130 rows where qSpecies_id = 135 sorted by YCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23361 | 33811 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 316 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37826 | 6006425.25516212 | 2098022.87661931 | 37.7411346781584 | -122.420367516795 | (37.7411346781584, -122.420367516795) | 2 | 7 | 7 | 28859 | 2 | |||
48045 | 33810 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 316 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/1996 12:00:00 AM | Permit Number 37826 | 6006425.25516212 | 2098022.87661931 | 37.7411346781584 | -122.420367516795 | (37.7411346781584, -122.420367516795) | 2 | 7 | 7 | 28859 | 2 | ||
35457 | 47121 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 81 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45103 | 6006109.36945154 | 2097632.81728263 | 37.7400458571469 | -122.421432043326 | (37.7400458571469, -122.421432043326) | 2 | 7 | 7 | 28859 | 2 | ||
121968 | 47120 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 81 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45103 | 6006109.36945154 | 2097632.81728263 | 37.7400458571469 | -122.421432043326 | (37.7400458571469, -122.421432043326) | 2 | 7 | 7 | 28859 | 2 | ||
106435 | 42469 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 48 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42611 | 5999793.72085734 | 2095526.96261347 | 37.7339055615854 | -122.443117692605 | (37.7339055615854, -122.443117692605) | 9 | 7 | 4 | 63 | 40 | ||
110738 | 96696 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1599X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015060.5348 | 2095438.80494 | 37.7345221731935 | -122.390329076986 | (37.7345221731935, -122.390329076986) | 10 | 3 | 8 | 58 | 1 | |||
183474 | 96697 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1599X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015060.5348 | 2095438.80494 | 37.7345221731935 | -122.390329076986 | (37.7345221731935, -122.390329076986) | 10 | 3 | 8 | 58 | 1 | |||
120522 | 26151 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1500 Oakdale Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
1083 | 94032 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1500 Oakdale Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015583.39088 | 2095096.21149 | 37.733610469696 | -122.388497468614 | (37.733610469696, -122.388497468614) | 10 | 3 | 8 | 58 | 1 | ||||
39054 | 40709 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41688 | 6004184.11835809 | 2094337.00833883 | 37.7308875722611 | -122.427853990581 | (37.7308875722611, -122.427853990581) | 9 | 7 | 6 | 28861 | 5 | ||
17405 | 42004 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
35666 | 42007 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
52579 | 42003 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
57225 | 42008 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
64679 | 42005 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
106159 | 42006 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
106450 | 42002 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 240 Manor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | 9 | 8 | 4 | 59 | 40 | ||
186027 | 42505 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 38 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42619 | 5999722.01782737 | 2093803.77353128 | 37.7291699982135 | -122.443241867584 | (37.7291699982135, -122.443241867584) | 9 | 7 | 4 | 63 | 40 | ||
122099 | 35725 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 190 Dartmouth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
189513 | 35724 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 190 Dartmouth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
127328 | 41985 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 143 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42325 | 5994934.83631929 | 2091867.32624102 | 37.7235788417252 | -122.459651240236 | (37.7235788417252, -122.459651240236) | 9 | 8 | 4 | 28861 | 24 | ||
99104 | 31039 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 743 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34798 | 6002570.79818377 | 2087220.23414259 | 37.7112550964884 | -122.432923252621 | (37.7112550964884, -122.432923252621) | 9 | 7 | 6 | 28861 | 5 | ||
1637 | 35981 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 83 Prospect Stairs Street | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | Permit Number 39135 | |||||||||||||
2610 | 31853 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1263 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35300 | |||||||||||||
5514 | 35799 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39046 | ||||||||||||||
11213 | 35798 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39046 | ||||||||||||||
11617 | 35800 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39046 | ||||||||||||||
12049 | 31854 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1263 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35300 | |||||||||||||
14917 | 35982 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 83 Prospect Stairs Street | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | Permit Number 39135 | |||||||||||||
17496 | 35801 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39046 |
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) );