Database Reference
In-Depth Information
the_geom public.geometry(Point,3857),
latitude character varying,
longitude character varying,
brightness character varying,
scan character varying,
track character varying,
acq_date character varying,
acq_time character varying,
satellite character varying,
confidence character varying,
version character varying,
bright_t31 character varying,
frp character varying
);
7. Now, check the record that should appear in the
geometry_columns
metadata view:
postgis_cookbook=# SELECT
f_geometry_column, coord_dimension, srid,
type FROM geometry_columns WHERE
f_table_name = 'global_24h';
f_geometry_column | coord_dimension |
srid | type
-------------------+-----------------+--------+-------
the_geom | 2 |
3857 | POINT
(1 row)
8. Check how many records have been imported in the table:
postgis_cookbook=# select count(*) from
chp01.global_24h;
count
-------
9190
(1 row)
