Home > database >  With spatial extension of postgresql postgis elements to create space, preview display error opening
With spatial extension of postgresql postgis elements to create space, preview display error opening

Time:10-05

The CREATE TABLE ODpoints (
T_TARGETID integer,
T_START_TIME integer,
T_START_LONGTI double precision,
T_START_LATI double precision,
T_END_TIME integer,
T_END_LONGTI double precision,
T_END_LATI double precision,
YMD_START_TIME character varying,
YMD_END_TIME character varying

)
Generate a ODpoints table, and then create the space elements point
The ALTER TABLE ODpointsADD COLUMN point geometry (point);
The UPDATE ODpointsSET point=st_setsrid (st_makepoint (ODpoints. T_START_LONGTI, ODpoints. T_START_LATI), 4326);
Create good basics of space, open in arccatalog, such errors in a preview
Error opening element class is, coordinate system identifier is invalid [the coordinate systerm identifier is invalid]

Is there a great god can help to give directions, this problem bothering me for a long time, then install the software system is also useless ah

CodePudding user response:

Join in spatial_ref_sys table need to coordinate

CodePudding user response:

The same problems, to ask
  • Related