trees
8 rows where qSiteInfo = "Sidewalk: Curb side : Pot" and qSpecies_id = 145
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22641 | 129809 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6010417.7029 | 2116870.15869 | 37.7931091785103 | -122.407891739714 | (37.7931091785103, -122.407891739714) | 3 | 1 | 10 | 28857 | 4 | |||
41885 | 129807 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6010390.20829 | 2116866.53247 | 37.7930976824694 | -122.407986617304 | (37.7930976824694, -122.407986617304) | 3 | 1 | 10 | 28857 | 4 | |||
62750 | 129804 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6010351.68054 | 2116862.21581 | 37.7930836728157 | -122.408119621635 | (37.7930836728157, -122.408119621635) | 3 | 1 | 10 | 28857 | 4 | |||
84419 | 129806 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6010377.17129 | 2116863.70379 | 37.7930891856797 | -122.408031526727 | (37.7930891856797, -122.408031526727) | 3 | 1 | 10 | 28857 | 4 | |||
109468 | 129802 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6010252.4995 | 2116845.85776 | 37.79303320378 | -122.408461640988 | (37.79303320378, -122.408461640988) | 3 | 1 | 10 | 28857 | 4 | |||
112521 | 129808 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6010404.49438 | 2116867.87948 | 37.7931021808659 | -122.407937281392 | (37.7931021808659, -122.407937281392) | 3 | 1 | 10 | 28857 | 4 | |||
158425 | 129805 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6010365.08882 | 2116862.85785 | 37.793086186442 | -122.408073273289 | (37.793086186442, -122.408073273289) | 3 | 1 | 10 | 28857 | 4 | |||
165029 | 129803 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6010302.01456 | 2116853.58579 | 37.7930571958732 | -122.408290860643 | (37.7930571958732, -122.408290860643) | 3 | 1 | 10 | 28857 | 4 |
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) );