<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<title></title>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
<meta http-equiv="Content-Style-Type" content="text/css"/>
</head>
<body>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"> I loaded a shapefile into my Postgresql/Postgis table. I'm trying to put data in some
records that appear to have no data and eventually delete records with no geometry data.
One problem is that I can't seem to identify records with no geometry data. If I review the
the_geom field for all records, there are several records that seem to be blank. Nothing is
shown in the field when I do a listing of all fields and all records. However, using ST_Npoints
shows, for example, 438 points for the “blank” record and St_IsValidReason says that it is a
Valid Geometry. St_GeometryType says it is ST_MultiString. However, St_AsEWKT for the
record is blank. It doesn't show any coordinates like the other records that do have data in
the the_geom field. St_IsEmpty shows "f" for all records, including the ones that are
apparently empty.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"> So, it seems that the geometry data is missing, but it isn't.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"> How can identify the records with apparently missing geometry data? Thanks for the
advice.</span></font></div>
<div align="left"><font face="Arial" size="2"><span style=" font-size:10pt"><br />
</span></font></div>
<div align="left"> </div>
</body>
</html>