trees
26 rows where Zip Codes = 309 and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
| 2234 | 49760 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 366@ REY Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46555 | 6008968.34582 | 2087920.09571 | 37.7135375657916 | -122.410861035806 | (37.7135375657916, -122.410861035806) | 9 | 7 | 8 | 309 | 39 | |
| 2767 | 49750 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011291.8839 | 2088250.88482 | 37.714575859155 | -122.402853264575 | (37.714575859155, -122.402853264575) | 10 | 7 | 8 | 309 | 39 | |
| 11743 | 50027 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
| 20039 | 50025 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
| 20766 | 84183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 496 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50711 | 6010074.8980178 | 2089472.05898173 | 37.7178609244136 | -122.407145708761 | (37.7178609244136, -122.407145708761) | 10 | 7 | 8 | 309 | 39 | ||
| 35422 | 178378 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Mansell St | 20 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6010770.98545 | 2090436.86466 | 37.7205490141188 | -122.404807517448 | (37.7205490141188, -122.404807517448) | 10 | 7 | 7 | 309 | 28 | |||
| 43998 | 49749 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46548 | 6011339.97378405 | 2088277.54861548 | 37.7146517576713 | -122.402688919521 | (37.7146517576713, -122.402688919521) | 10 | 7 | 8 | 309 | 39 | ||
| 53354 | 49751 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011264.41643 | 2088242.20355 | 37.7145504883813 | -122.402947593582 | (37.7145504883813, -122.402947593582) | 10 | 7 | 8 | 309 | 39 | |
| 57860 | 13384 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 62143 | 2164 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 725X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009812.0626049 | 2090077.874838 | 37.7195096568823 | -122.408096919848 | (37.7195096568823, -122.408096919848) | 9 | 3 | 8 | 309 | 18 | |||
| 67602 | 37789 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2002 12:00:00 AM | 5 | Permit Number 45187 | 6009352.7648 | 2092869.00605 | 37.7271477905118 | -122.409881473561 | (37.7271477905118, -122.409881473561) | 10 | 3 | 7 | 309 | 28 | ||
| 67869 | 43159 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 252 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 7 | Permit Number 46761 | 6006227.85589 | 2092666.05204 | 37.7264148961281 | -122.42066986853 | (37.7264148961281, -122.42066986853) | 9 | 7 | 7 | 309 | 5 | |
| 71884 | 13374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 940 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x10 | 6009133.6559802 | 2090011.862437 | 37.7192903922619 | -122.41043727411 | (37.7192903922619, -122.41043727411) | 9 | 3 | 7 | 309 | 28 | |||
| 73309 | 178390 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 747 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6005444.06932 | 2092330.23568 | 37.725448612348 | -122.423355524742 | (37.725448612348, -122.423355524742) | 9 | 7 | 7 | 309 | 5 | |||
| 74668 | 178379 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010067.80159 | 2089489.05977 | 37.717907207937 | -122.407171435816 | (37.717907207937, -122.407171435816) | 10 | 7 | 8 | 309 | 39 | |||
| 82893 | 178377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010782.26263 | 2090442.44739 | 37.7205649734793 | -122.404768928441 | (37.7205649734793, -122.404768928441) | 10 | 7 | 7 | 309 | 28 | |||
| 93059 | 49752 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 310 Campbell Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 2 | Permit Number 46548 | 6011250.71045 | 2088239.22111 | 37.7145415338455 | -122.402994757601 | (37.7145415338455, -122.402994757601) | 10 | 7 | 8 | 309 | 39 | |
| 108910 | 49653 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | 5 | Permit Number 46506 | 6010094.54091 | 2089412.62479 | 37.71769882961 | -122.407073624648 | (37.71769882961, -122.407073624648) | 9 | 7 | 8 | 309 | 39 | |
| 119057 | 178391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Gaven St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6008930.41728 | 2094862.45857 | 37.7325977064018 | -122.411482306357 | (37.7325977064018, -122.411482306357) | 9 | 3 | 7 | 309 | 28 | |||
| 127547 | 178392 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 29 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010751.14458 | 2093820.65833 | 37.7298390998841 | -122.405114245623 | (37.7298390998841, -122.405114245623) | 10 | 3 | 7 | 309 | 28 | |||
| 138139 | 49755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1143 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46551 | 6011336.45006 | 2089464.63362 | 37.7179110561333 | -122.402784534778 | (37.7179110561333, -122.402784534778) | 10 | 7 | 8 | 309 | 39 | |
| 140060 | 50026 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
| 155941 | 50022 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 736 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3 | Permit Number 46756 | 6009379.93201 | 2091040.43268 | 37.7221284349621 | -122.409658546911 | (37.7221284349621, -122.409658546911) | 9 | 3 | 7 | 309 | 28 | |
| 157025 | 37788 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2003 12:00:00 AM | 5 | Permit Number 46497 | 6009357.10808 | 2092858.09097 | 37.7271180634226 | -122.409865688662 | (37.7271180634226, -122.409865688662) | 10 | 3 | 7 | 309 | 28 | ||
| 182250 | 13373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 930 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X10 | 6009096.55006 | 2089989.80349 | 37.7192277427566 | -122.410563978962 | (37.7192277427566, -122.410563978962) | 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) );