As long as your data is set with a spatial reference identifier of 4326 (WGS 84), the features will display on the OSM layer otherwise they’ll show on a blank canvas. The example, from the “Working with JSON Data” chapter in Practical SQL (code here), shows a selection of earthquakes near Tulsa, Oklahoma. Then click the eye icon in the column header to open the Geometry Viewer and show your shapes plotted on an OpenStreetMap layer: Run a query that contains a spatial data column in the output. Using the Geometry Viewer is straightforward. Instead of exporting data to a spatial analysis product like QGIS, you can get a quick view of it right in pgAdmin. If you’re a PostGIS user, one of the handiest pgAdmin features is its built-in Geometry Viewer. To access this pgAdmin feature, select File > Preferences > Miscellaneous > Themes, then choose Dark. Dark Modeįor those who wish to reduce screen glare, pgAdmin features the addition of a dark theme as of version 4.15. For this description, I’m referencing pgAdmin version 6.0, released in October 2021. They include theme options, a Geometry Viewer, a JSON editor, SQL formatter, and import/export wizard. While writing a new edition of Practical SQL, five cool pgAdmin features and tips caught my eye. PgAdmin, the free, open-source GUI for the PostgreSQL database, has come a long way since version 1.0 released in September 2016.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |