trees
130 rows where qSpecies_id = 135 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46150 | 52321 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4308 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48475 | 6001136.61726657 | 2103347.24100136 | 37.7554546726713 | -122.43903517577 | (37.7554546726713, -122.43903517577) | 2 | 4 | 5 | 28862 | 38 | ||
76167 | 52319 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4308 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48475 | 6001136.61726657 | 2103347.24100136 | 37.7554546726713 | -122.43903517577 | (37.7554546726713, -122.43903517577) | 2 | 4 | 5 | 28862 | 38 | ||
111384 | 52322 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4308 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48475 | 6001136.61726657 | 2103347.24100136 | 37.7554546726713 | -122.43903517577 | (37.7554546726713, -122.43903517577) | 2 | 4 | 5 | 28862 | 38 | ||
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 | ||
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 | ||
57836 | 41810 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
77833 | 41806 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
80558 | 41813 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
106070 | 41811 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
135724 | 41805 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
158357 | 41804 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
182141 | 41803 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 100 Anzavista Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.7796546591332 | -122.443491289074 | (37.7796546591332, -122.443491289074) | 15 | 5 | 1 | 29490 | 16 | ||
4414 | 49854 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
65076 | 49849 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
90866 | 49848 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
96902 | 49855 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
104344 | 49850 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
147883 | 49851 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
154574 | 49853 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
161093 | 49852 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 600@ WOODSIDE Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | 1 | 7 | 4 | 59 | 40 | |||
90073 | 46642 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 38 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2002 12:00:00 AM | Permit Number 44771 | 5995904.25233088 | 2114246.62473666 | 37.7850824383786 | -122.457918884189 | (37.7850824383786, -122.457918884189) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
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 | ||
166407 | 49936 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 2526 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | Permit Number 46695 | 5988331.02491105 | 2098109.84036386 | 37.7403372178988 | -122.482936471841 | (37.7403372178988, -122.482936471841) | 1 | 8 | 3 | 29491 | 35 |
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) );