| | |
| | | |
| | | |
| | | |
| | | |
| | | ---------------------------------------------------------------------------------------------- SY1.煤层54表 |
| | | -- drop table public.coal54; |
| | | create table if not exists public.coal54 ( |
| | |
| | | comment on column public.coal54.volume is '体积'; |
| | | comment on column public.coal54.geom is '空间'; |
| | | |
| | | select * from public.coal54 order by gid desc limit 100; |
| | | select count(*) from public.coal54; -- 12701714 |
| | | select a.*, ST_AsText(geom) from public.coal54 a order by gid desc limit 100; |
| | | ---------------------------------------------------------------------------------------------- SY2.煤层2000表 |
| | | -- drop table public.coal2000; |
| | | create table if not exists public.coal2000 ( |