trees
15 rows where Fire Prevention Districts = 7, qCareAssistant = "FUF" and qSpecies_id = 95
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15794 | 63736 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 585 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24405 | 6003780.00958588 | 2109683.67127267 | 37.7730030357559 | -122.430345580362 | (37.7730030357559, -122.430345580362) | 7 | 9 | 11 | 29492 | 10 | ||
40120 | 66387 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 576 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29513 | 6003809.30522061 | 2109740.24975223 | 37.7731600457631 | -122.430248280428 | (37.7731600457631, -122.430248280428) | 7 | 9 | 11 | 29492 | 10 | ||
47550 | 63734 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 547 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24403 | 6003953.21225561 | 2109707.77705475 | 37.7730790336555 | -122.429748170749 | (37.7730790336555, -122.429748170749) | 7 | 9 | 11 | 29492 | 10 | ||
49431 | 67556 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 890 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1995 12:00:00 AM | Permit Number 31105 | 6003602.07514471 | 2110752.33262694 | 37.7759272362097 | -122.43103736444 | (37.7759272362097, -122.43103736444) | 7 | 9 | 11 | 29492 | 10 | ||
50956 | 63760 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 540 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24437 | 6003973.39193973 | 2109763.08680608 | 37.7732320433706 | -122.429682312236 | (37.7732320433706, -122.429682312236) | 7 | 9 | 11 | 29492 | 10 | ||
77613 | 66110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29164 | 6005954.05152204 | 2110038.74835026 | 37.7741008978737 | -122.422850531283 | (37.7741008978737, -122.422850531283) | 7 | 9 | 11 | 28852 | 10 | ||
83304 | 63735 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 550 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24404 | 6003927.8122889 | 2109756.74317909 | 37.7732120443049 | -122.429839525756 | (37.7732120443049, -122.429839525756) | 7 | 9 | 11 | 29492 | 10 | ||
99802 | 62274 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 127 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22410 | 6004223.66496449 | 2109215.34758778 | 37.771742253448 | -122.428777529151 | (37.771742253448, -122.428777529151) | 7 | 9 | 11 | 29492 | 10 | ||
104327 | 57698 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 112 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22413 | 6003845.29045586 | 2108813.17790583 | 37.770616571258 | -122.430057656537 | (37.770616571258, -122.430057656537) | 7 | 9 | 11 | 29492 | 10 | ||
121551 | 30727 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
128687 | 62278 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22416 | 6004275.31529715 | 2109405.62927883 | 37.7722676437754 | -122.428612433422 | (37.7722676437754, -122.428612433422) | 7 | 9 | 11 | 28852 | 10 | ||
130596 | 63731 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 510 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24400 | 6004110.13087942 | 2109782.11768526 | 37.7732920393038 | -122.429210671215 | (37.7732920393038, -122.429210671215) | 7 | 9 | 11 | 29492 | 10 | ||
149176 | 63737 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 573 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24406 | 6003834.70515324 | 2109691.28362316 | 37.7730270354143 | -122.43015692487 | (37.7730270354143, -122.43015692487) | 7 | 9 | 11 | 29492 | 10 | ||
166941 | 66373 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 430 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29497 | 6003708.35294884 | 2109810.61822809 | 37.7733475417865 | -122.430602509574 | (37.7733475417865, -122.430602509574) | 7 | 9 | 11 | 29492 | 10 | ||
174388 | 63732 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 529 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24401 | 6004035.25561517 | 2109719.19558167 | 37.7731150315991 | -122.429465186856 | (37.7731150315991, -122.429465186856) | 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) );