trees
11 rows where Police Districts = 9 and qSpecies_id = 47 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169833 | 2477 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.7901239554137 | -122.43124522669 | (37.7901239554137, -122.43124522669) | 13 | 9 | 1 | 29490 | 27 | |||
148893 | 42597 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.425158599805 | (37.7919342879744, -122.425158599805) | 13 | 9 | 1 | 28858 | 27 | ||
147419 | 227696 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003774.74871 | 2108065.24722 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | 7 | 9 | 5 | 28862 | 3 | |||
145982 | 227697 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | 15 | 9 | 11 | 29492 | 10 | |||
128589 | 18878 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6003659.52132 | 2115878.15996 | 37.7900047293604 | -122.431204600475 | (37.7900047293604, -122.431204600475) | 13 | 9 | 1 | 29490 | 27 | |||
122863 | 129465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | 13 | 9 | 1 | 28858 | 27 | |||
115683 | 129467 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6006504.31748 | 2119710.78815 | 37.8006889650949 | -122.421634156713 | (37.8006889650949, -122.421634156713) | 13 | 9 | 1 | 28858 | 32 | |||
105151 | 129466 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.7918582853821 | -122.425769315008 | (37.7918582853821, -122.425769315008) | 13 | 9 | 1 | 28858 | 27 | |||
104265 | 129463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.7916643510872 | -122.436174782264 | (37.7916643510872, -122.436174782264) | 13 | 9 | 1 | 29490 | 27 | |||
50220 | 18882 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6003557.0695 | 2115907.13274 | 37.7900784748972 | -122.43156114415 | (37.7900784748972, -122.43156114415) | 13 | 9 | 1 | 29490 | 27 | |||
30568 | 129464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | 13 | 9 | 1 | 28858 | 27 |
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) );