[postgis-tickets] [SCM] postgis.net branch website updated. clarity-final-19-gc535830

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "postgis.net".

The branch, website has been updated
       via  c535830c6eddb68d0be21e088ce45bc8c1b46db0 (commit)
      from  c99bd2d97949b02421b11e543dcad14f5b4041fb (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit c535830c6eddb68d0be21e088ce45bc8c1b46db0
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Thu May 18 13:22:09 2023 -0700

    remove redundant tip

diff --git a/content/documentation/tips/tip_pgadmin_shows_no_data.md b/content/documentation/tips/tip_pgadmin_shows_no_data.md
deleted file mode 100644
index 2cb0df4..0000000
--- a/content/documentation/tips/tip_pgadmin_shows_no_data.md
+++ /dev/null
@@ -1,83 +0,0 @@
----
-title: "pgAdmin shows no data"
-slug: "tip_pgadmin_shows_no_data"
-layout: post
-category: tips
-tags: [newbie,geometry,geography,raster]
-author: Regina Obe
-date: "2013-10-05"
-thumbnail:
-geekdocHidden: true
-geekdocHiddenTocTree: false
-weight: 90
----
-
-Every one or two months, someone asks on the PostGIS users list usually somewhat panicked, *My geometry is missing when I look in pgAdmin III*
-
-This is documented in the PostGIS Frequently Asked questions section of the manual <a href="/docs/manual-dev/PostGIS_FAQ.html#pgadmin_shows_no_data_in_geom" target="_blank">I tried to use PgAdmin to view my geometry column and it is blank, what gives?</a>
-
-Since this question gets asked so much, I thought it best to highlight it again.
-
-Spatial objects can be big things and if your geometry, geography, or raster row field is big enough, pgAdmin is not going to load it
-and will just show an empty field.  This is by design.  There are a couple of ways to verify you really have data and even how big your geometry, geography or raster column is
-
-<!--more-->
-
-**Examples**
-
-
-***Check there is really data.  This will work for anything and will return a count of all objects that have no data in geom column***
-This query will also work for raster, geometry, and geography
-```postgres
-SELECT count(*)
- FROM  mytable
-  WHERE geom IS NULL;
-```
-
-
-**How big are my spatial objects?**
-These next examples may take a while to run depending on how big your table, so proceed with caution.
-
-***How big are my geometries?***
-This will return the max number of points in a geometry column
-
-```postgres
-SELECT Max(ST_NPoints(geom))
-FROM mytable;
-```
-
-***How big are my geographies?***
-Unfortunately geography doesn't have a native <a href="/docs/manual-dev/ST_NPoints.html" target="_blank">```ST_NPoints```</a> function, but you can piggy back on the geometry one.
-
-```postgres
-SELECT Max(
- ST_NPoints(geog::geometry)
- )
-FROM mytable;
-```
-
-***How big are my rasters?***
-A raster column has widthxheight number of pixels in it.  So the below query will give you a sense of how many pixels you've got
-in each row.
-
-```postgres
-SELECT
- Max(ST_Width(rast)) As w
- , Max(ST_Height(rast)) As h
-FROM mytable;
-```
-
-If you loaded your rasters with -C constraint option, you can do the much much faster check of raster_columns.
-raster_columns will only show a blocksize_x and blocksize_y if you applied constraints and all your raster tiles
-are off the same width/height dimensions.
-
-```postgres
-SELECT
- blocksize_x As w
- , blocksize_y As h
-FROM raster_columns
-WHERE r_table_name = 'mytable'
- AND r_raster_column='rast';
-```
-
-

-----------------------------------------------------------------------

Summary of changes:
 .../tips/tip_pgadmin_shows_no_data.md              | 83 ----------------------
 1 file changed, 83 deletions(-)
 delete mode 100644 content/documentation/tips/tip_pgadmin_shows_no_data.md


hooks/post-receive
-- 
postgis.net