trees
19 rows where PlotSize = "3X3", qLegalStatus_id = 7 and qSpecies_id = 5
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12701 | 3581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
24686 | 20125 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
40384 | 16481 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
50667 | 2542 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016211.040056 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | 10 | 3 | 8 | 58 | 1 | |||
54072 | 4915 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
62069 | 4912 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
74388 | 16650 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | 15 | 5 | 5 | 28862 | 3 | |||
87736 | 16483 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
95486 | 4922 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
99992 | 16482 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
102749 | 16480 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
112108 | 16517 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
117441 | 16485 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
134226 | 16641 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002897.9493228 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | 15 | 5 | 5 | 28862 | 3 | |||
136547 | 22889 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
143134 | 4923 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
168339 | 2544 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6016440 | 2099034 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | 10 | 3 | 8 | 58 | 1 | |||
188633 | 4914 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
191172 | 16486 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 |
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) );