trees
130 rows where qSpecies_id = 135 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
157931 | 34535 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 65 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38244 | 6009619.36143098 | 2098302.27912824 | 37.7420813311149 | -122.409343112846 | (37.7420813311149, -122.409343112846) | 10 | 7 | 7 | 28859 | 2 | ||
174894 | 120647 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 69x Dearborn St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/22/2016 12:00:00 AM | 3 | 3x3 | 6005880 | 2105692 | 37.7621615842697 | -122.422797712098 | (37.7621615842697, -122.422797712098) | 8 | 4 | 5 | 28859 | 19 | ||
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 | ||
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 | ||
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 | |||||||||||||
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 | |||||||||||||
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 |
66314 | 39750 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 87 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41118 | 6003060.76773686 | 2105607.00413324 | 37.7617687350382 | -122.432542281846 | (37.7617687350382, -122.432542281846) | 15 | 4 | 5 | 28862 | 3 | ||
83984 | 97104 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 882 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 2x2 | 6009914 | 2104066 | 37.7579237379711 | -122.408730867443 | (37.7579237379711, -122.408730867443) | 2 | 4 | 7 | 28859 | 19 | |||
114298 | 97103 | Undocumented 4 | Arecastrum romanzoffianum :: Queen Palm 135 | 882 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2007 12:00:00 AM | 14 | 2x2 | 6009914 | 2104066 | 37.7579237379711 | -122.408730867443 | (37.7579237379711, -122.408730867443) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||||
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 | |
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 | ||||
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 | |
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 | |||
100560 | 36030 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 94 Bernal Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39177 | 6009602.87922047 | 2098220.81280992 | 37.7418567188773 | -122.409394355394 | (37.7418567188773, -122.409394355394) | 10 | 7 | 7 | 28859 | 2 | ||
5959 | 36677 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 5 | 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 | |
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 |
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) );