trees
12 rows where qCaretaker_id = 4 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
| 5633 | 76756 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | 1 | 8 | 3 | 56 | 35 | ||
| 7380 | 75048 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003019.45241 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | 9 | 7 | 6 | 28861 | 5 | ||
| 14855 | 75049 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003005.92399 | 2092563.39586 | 37.7259509097926 | -122.431800609333 | (37.7259509097926, -122.431800609333) | 9 | 7 | 6 | 28861 | 5 | ||
| 18509 | 76705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6003030.53484 | 2092605.75448 | 37.7260686121528 | -122.431718554264 | (37.7260686121528, -122.431718554264) | 9 | 7 | 6 | 28861 | 5 | ||
| 23641 | 43313 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.7261197629015 | -122.431680307904 | (37.7261197629015, -122.431680307904) | 9 | 7 | 6 | 28861 | 5 |
| 50176 | 99498 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6002794.02408 | 2092508.79842 | 37.7257889832596 | -122.432529234659 | (37.7257889832596, -122.432529234659) | 9 | 7 | 6 | 28861 | 5 | ||
| 79676 | 75385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 84632 | 77991 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 123128 | 43311 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003068.93568 | 2092663.25214 | 37.7262286645003 | -122.431589908071 | (37.7262286645003, -122.431589908071) | 9 | 7 | 6 | 28861 | 5 |
| 149448 | 43312 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.431640671199 | (37.7261742132654, -122.431640671199) | 9 | 7 | 6 | 28861 | 5 |
| 153384 | 43310 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 150X Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6002773.36898986 | 2092525.07870875 | 37.7258325139415 | -122.432601800105 | (37.7258325139415, -122.432601800105) | 9 | 7 | 6 | 28861 | 5 |
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) );