trees
25 rows where Police Districts = 10 and qSpecies_id = 53
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29615 | 120137 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
38715 | 120144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
41773 | 120139 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
50788 | 113510 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008411 | 2113171 | 37.7828396386737 | -122.414573186563 | (37.7828396386737, -122.414573186563) | 7 | 10 | 9 | 28852 | 36 | ||||
55561 | 99240 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6008281 | 2113828 | 37.7846362978531 | -122.415069452341 | (37.7846362978531, -122.415069452341) | 7 | 10 | 9 | 28858 | 36 | |||
59516 | 120135 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
63324 | 120151 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
69451 | 99244 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 570 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11 | 4x4 | 6008204 | 2113818 | 37.784604512923 | -122.41533513918 | (37.784604512923, -122.41533513918) | 7 | 10 | 9 | 28858 | 36 | |||
97171 | 120147 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
101116 | 107368 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660 OFARRELL ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008096 | 2114145 | 37.7854963051764 | -122.415731945695 | (37.7854963051764, -122.415731945695) | 13 | 10 | 9 | 28858 | 36 | ||||||
109217 | 120150 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
119361 | 120152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
119635 | 120148 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
120635 | 120140 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
127461 | 120149 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
129533 | 120143 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
135359 | 120138 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
154035 | 99243 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 570 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 9 | 4x4 | 6008204 | 2113818 | 37.784604512923 | -122.41533513918 | (37.784604512923, -122.41533513918) | 7 | 10 | 9 | 28858 | 36 | |||
168941 | 120136 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
179551 | 120145 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
180679 | 120134 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
182867 | 120141 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
183245 | 120146 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
186477 | 113509 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 318 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008412 | 2113183 | 37.7828726439691 | -122.414570576408 | (37.7828726439691, -122.414570576408) | 7 | 10 | 9 | 28852 | 36 | ||||
186730 | 120142 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 |
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) );