trees
19 rows where Supervisor Districts = 2 and qSpecies_id = 97
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13355 | 62304 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.453100806219 | (37.7758053966105, -122.453100806219) | 15 | 6 | 2 | 54 | 16 | ||
29118 | 61140 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2132 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20992 | 5997609.15376905 | 2110265.51143343 | 37.7742491458885 | -122.451733203729 | (37.7742491458885, -122.451733203729) | 15 | 5 | 2 | 29492 | 16 | ||
58522 | 98530 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991613.7 | 2110635.6 | 37.7749201175533 | -122.472499350726 | (37.7749201175533, -122.472499350726) | 11 | 6 | 2 | 54 | 26 | ||||
60273 | 60549 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | 11 | 6 | 2 | 55 | 26 | ||
64863 | 60554 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.495269425078 | (37.7783990952425, -122.495269425078) | 11 | 6 | 2 | 55 | 26 | ||
66528 | 115675 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | 11 | 6 | 2 | 55 | 26 | |||||
76352 | 61525 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.473716580773 | (37.7861960776153, -122.473716580773) | 11 | 6 | 2 | 54 | 26 | ||
91227 | 40081 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 22 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41303 | 5996321.69068784 | 2112123.86441597 | 37.7792778762225 | -122.456321143761 | (37.7792778762225, -122.456321143761) | 11 | 6 | 2 | 54 | 16 | ||||
94509 | 63203 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.7807046794697 | -122.496631747831 | (37.7807046794697, -122.496631747831) | 11 | 6 | 2 | 55 | 26 | ||
94913 | 98531 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991613.7 | 2110635.6 | 37.7749201175533 | -122.472499350726 | (37.7749201175533, -122.472499350726) | 11 | 6 | 2 | 54 | 26 | ||||
98172 | 61524 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 5301 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.7842976232811 | -122.474274166868 | (37.7842976232811, -122.474274166868) | 11 | 6 | 2 | 54 | 26 | ||
98278 | 66836 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | 15 | 6 | 2 | 54 | 16 | ||
114874 | 61139 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.7742571277486 | -122.451669915896 | (37.7742571277486, -122.451669915896) | 15 | 5 | 2 | 29492 | 16 | ||
124631 | 67263 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.7780020106611 | -122.508136768544 | (37.7780020106611, -122.508136768544) | 11 | 6 | 2 | 55 | 26 | ||
169413 | 62604 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.7739446322992 | -122.497099617838 | (37.7739446322992, -122.497099617838) | 11 | 6 | 2 | 55 | 26 | ||
172351 | 48492 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | 11 | 6 | 2 | 55 | 26 | ||
176171 | 60542 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 615 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20152 | 5985331.57099648 | 2111677.45152223 | 37.7774151286277 | -122.494307063797 | (37.7774151286277, -122.494307063797) | 11 | 6 | 2 | 55 | 26 | ||
178899 | 61526 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | 11 | 6 | 2 | 54 | 26 | ||
192915 | 66937 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30262 | 5998853.41639727 | 2111835.46191539 | 37.7786310079222 | -122.447542123222 | (37.7786310079222, -122.447542123222) | 15 | 6 | 2 | 54 | 16 |
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) );