trees
33 rows where Fire Prevention Districts = 7 and qSpecies_id = 97 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
140818 | 65399 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 471 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28247 | 6008612.45505665 | 2113822.69504434 | 37.7846403524021 | -122.41392234969 | (37.7846403524021, -122.41392234969) | 7 | 10 | 9 | 28852 | 36 | ||
6180 | 33653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
132088 | 33651 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
41759 | 30892 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
108948 | 30891 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
179236 | 30890 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
73528 | 59961 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 444 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | Permit Number 19440 | 6005671.77527769 | 2111387.84010103 | 37.7777892453109 | -122.4239229277 | (37.7777892453109, -122.4239229277) | 7 | 9 | 11 | 28852 | 10 | ||
26145 | 258009 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 380 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005531 | 2111189 | 37.7772353303506 | -122.424395772149 | (37.7772353303506, -122.424395772149) | 7 | 9 | 11 | 28852 | 10 | ||||
86490 | 66119 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29179 | 6005470.38749546 | 2110092.46405208 | 37.7742210861409 | -122.424527432779 | (37.7742210861409, -122.424527432779) | 7 | 9 | 11 | 28852 | 10 | ||
36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
118167 | 33695 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | 7 | 9 | 11 | 28852 | 10 | |||
6344 | 33663 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.8782552 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | 7 | 9 | 11 | 28852 | 10 | |||
83608 | 59954 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 559 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | Permit Number 19431 | 6005185.88290556 | 2110921.14903305 | 37.7764803824816 | -122.42557057591 | (37.7764803824816, -122.42557057591) | 7 | 9 | 11 | 28852 | 10 | ||
28013 | 33609 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
143659 | 33610 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
123850 | 33611 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
186946 | 33612 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
40736 | 33615 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
185167 | 33614 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
184502 | 33607 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37719 | 6005021.10976005 | 2110082.43632314 | 37.7741681701238 | -122.426080852286 | (37.7741681701238, -122.426080852286) | 7 | 9 | 11 | 28852 | 10 | |||
131474 | 16900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.7745003644325 | -122.426136940772 | (37.7745003644325, -122.426136940772) | 7 | 9 | 11 | 28852 | 10 | |||
69321 | 16914 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004697.20239 | 2110157.08412 | 37.7743548226588 | -122.427206624104 | (37.7743548226588, -122.427206624104) | 7 | 9 | 11 | 28852 | 10 | |||
148185 | 33613 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.427225555933 | (37.7740225856392, -122.427225555933) | 7 | 9 | 11 | 28852 | 10 | |||
179128 | 66115 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29170 | 6003947.68857827 | 2110748.1234611 | 37.7759352566539 | -122.429841497852 | (37.7759352566539, -122.429841497852) | 7 | 9 | 11 | 29492 | 10 | ||
10493 | 59647 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.7705491626589 | -122.43004409806 | (37.7705491626589, -122.43004409806) | 7 | 9 | 11 | 29492 | 10 | |
77743 | 31350 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.430251629227 | (37.7758829003399, -122.430251629227) | 7 | 9 | 11 | 29492 | 10 | ||
92545 | 66374 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 600 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29498 | 6003626.18476729 | 2110393.01425684 | 37.7749420027203 | -122.430928313262 | (37.7749420027203, -122.430928313262) | 7 | 9 | 11 | 29492 | 10 | ||
78099 | 66375 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 612 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29499 | 6003620.76837837 | 2110432.17499844 | 37.7750492215662 | -122.430949845165 | (37.7750492215662, -122.430949845165) | 7 | 9 | 11 | 29492 | 10 | ||
190656 | 30538 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 614 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34538 | 6003619.86564688 | 2110438.7017887 | 37.7750670913733 | -122.430953433821 | (37.7750670913733, -122.430953433821) | 7 | 9 | 11 | 29492 | 10 | ||||
49673 | 66438 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 650X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1991 12:00:00 AM | Permit Number 29582 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.431018029936 | (37.7753887478808, -122.431018029936) | 7 | 9 | 11 | 29492 | 10 | ||
185038 | 111900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 650X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2016 12:00:00 AM | 3 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.431018029936 | (37.7753887478808, -122.431018029936) | 7 | 9 | 11 | 29492 | 10 |
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) );