trees
130 rows where qSpecies_id = 135 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17724 | 36678 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
64745 | 36679 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
100199 | 36676 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
174066 | 36680 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
141302 | 42940 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 90 14TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | |||
179746 | 42938 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 90 14TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | |||
105286 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 135 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout | Tree | Private 2 | 15 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
115607 | 108287 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 1 HENRY ADAMS ST | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
21509 | 120508 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.405208723585 | (37.7715678900614, -122.405208723585) | 14 | 2 | 9 | 28853 | 34 | ||||
36942 | 120509 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.405208723585 | (37.7715678900614, -122.405208723585) | 14 | 2 | 9 | 28853 | 34 | ||||
85203 | 67606 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1996 12:00:00 AM | Permit Number 31179 | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.405208723585 | (37.7715678900614, -122.405208723585) | 14 | 2 | 9 | 28853 | 34 | ||
115994 | 120507 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.405208723585 | (37.7715678900614, -122.405208723585) | 14 | 2 | 9 | 28853 | 34 | ||||
64072 | 120511 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | |
138165 | 120510 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | |
148604 | 120514 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | |
154906 | 120513 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | |
174608 | 120512 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 888 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | |
95519 | 49632 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 63@ HOWARD Kissling St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | Permit Number 46485 | 6008295.13782655 | 2109508.07731358 | 37.7727756153304 | -122.41471471751 | (37.7727756153304, -122.41471471751) | 8 | 2 | 9 | 28853 | 34 | ||
24485 | 50762 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1247 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | Permit Number 53107 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
166864 | 63865 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24568 | 6002960.35246681 | 2111688.65043181 | 37.7784617483317 | -122.433324169044 | (37.7784617483317, -122.433324169044) | 15 | 9 | 11 | 29490 | 41 | ||
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 | ||
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 | |||
107797 | 37513 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 835 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39970 | 6007729.27336023 | 2114396.12651658 | 37.786165215164 | -122.417018514766 | (37.786165215164, -122.417018514766) | 13 | 1 | 9 | 28858 | 36 | ||
160870 | 37512 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 835 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 12 | 3x3 | Permit Number 39970 | 6007729.27336023 | 2114396.12651658 | 37.786165215164 | -122.417018514766 | (37.786165215164, -122.417018514766) | 13 | 1 | 9 | 28858 | 36 |
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) );