查询Geometry
select ST_GeomFromText('Polygon((117.357442 30.231278,119.235188 30.231278,119.235188 32.614617,117.357442 32.614617,117.357442 30.231278))');
设计Geometry字段表
政区表:Geometry=Polygon
drop table if EXISTS aggregate_state;
/***创建政区表***/
create table aggregate_state(
pk_uid serial primary key,
code CHARACTER VARYING(20) NOT NULL,
"name" CHARACTER VARYING(100) NOT NULL,
zoom INTEGER NOT NULL,
geom geometry(Polygon,4326) NOT NULL ,/*geom public.geometry(Polygon,4490),*/
longitude double precision ,
latitude double precision
);
空间业务表:Geometry=Point
drop table if EXISTS aggregate_spatial;
/***创建空间业务表***/
create table aggregate_spatial(
pk_uid serial primary key,
sheng CHARACTER VARYING(20),
shi CHARACTER VARYING(20),
xia