trees
130 rows where qSpecies_id = 135 sorted by qLegalStatus_id
This data as json, CSV (advanced)
qSiteInfo ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126955 | 42928 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 500 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42831 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||
133325 | 43908 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1090 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2000 12:00:00 AM | Permit Number 43506 | 6010229.84125337 | 2102875.27259753 | 37.7546719517198 | -122.407554599825 | (37.7546719517198, -122.407554599825) | 2 | 4 | 7 | 28859 | 19 | |||
134421 | 42083 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 301 Precita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42392 | 6008452.52473671 | 2100207.10363126 | 37.7472461128688 | -122.413512366427 | (37.7472461128688, -122.413512366427) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
135813 | 43907 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2000 12:00:00 AM | Permit Number 43506 | 6010229.84125337 | 2102875.27259753 | 37.7546719517198 | -122.407554599825 | (37.7546719517198, -122.407554599825) | 2 | 4 | 7 | 28859 | 19 | |||
137847 | 40320 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3498x 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41461 | 6006512.30004445 | 2100871.01023057 | 37.7489599147889 | -122.420268642175 | (37.7489599147889, -122.420268642175) | 2 | 4 | 7 | 28859 | 19 | ||
140793 | 39791 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 50 San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/1999 12:00:00 AM | Permit Number 41142 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.421567620452 | (37.7544443606741, -122.421567620452) | 2 | 4 | 5 | 28859 | 19 | ||
140924 | 35772 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3692 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1998 12:00:00 AM | Permit Number 39030 | 6004971.89537308 | 2105472.67366607 | 37.7615080868858 | -122.425922888595 | (37.7615080868858, -122.425922888595) | 8 | 4 | 5 | 28859 | 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 | |||
141366 | 37974 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1199 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
148886 | 31424 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4220 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | Permit Number 35007 | 6001430.13223279 | 2103389.64483278 | 37.7555877996488 | -122.438023150412 | (37.7555877996488, -122.438023150412) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
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 | ||
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 | ||
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 |
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 | |||
163105 | 35773 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3692 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39030 | 6004971.89537308 | 2105472.67366607 | 37.7615080868858 | -122.425922888595 | (37.7615080868858, -122.425922888595) | 8 | 4 | 5 | 28859 | 19 | ||
165649 | 48501 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1005(REVISED) Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45840 | 6003172.67516889 | 2102390.65351866 | 37.7529437493543 | -122.43192556655 | (37.7529437493543, -122.43192556655) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
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 | ||
171263 | 42049 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 405 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | 2 | 7 | 5 | 63 | 22 | ||
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 | |
176985 | 31427 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 4220 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | Permit Number 35007 | 6001430.13223279 | 2103389.64483278 | 37.7555877996488 | -122.438023150412 | (37.7555877996488, -122.438023150412) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
180921 | 82202 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 3170-3172 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50066 | 6008538.87748807 | 2101576.58279524 | 37.751011244921 | -122.413310594546 | (37.751011244921, -122.413310594546) | 2 | 4 | 7 | 28859 | 19 | |
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 | ||
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 | ||
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 |
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) );