PostgreSQL/PostGIS data to Matlab - How to display

Question

Devinya Herath 2011-6-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9266-postgresql-postgis-data-to-matlab-how-to-display

评论： Ross 2017-1-13

I have successfully connected to a postgreSQL database from matlab and importad a field that contains geometric data (postgreSQL data type of the field is 'geometry'). Here's my code.

curs = exec(conn, 'select location from gps'); setdbprefs('DataReturnFormat','cellarray'); curs = fetch(curs, 10); AA = curs.Data

this gives the following output: [1x1 org.postgresql.util.PGobject]

    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]
    [1x1 org.postgresql.util.PGobject]

The field 'location' contains point features and the postgreSQL data type is geometry. I want to display the actual values. Please tell me a way to do that.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ross 2017-1-13

Obviously really old post, but the easier way it to use SQL to convert the location into x, y and z coordinates in the query.

SELECT ST_X(location_column_name), ST_Y(location_column_name), ST_Z(location_column_name) FROM table_name

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2011-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9266-postgresql-postgis-data-to-matlab-how-to-display#answer_12769

在 MATLAB Online 中打开

It appears to me from the documentation that it would go like this:

numA = length(AA);
Geometries = cell(numA,1);
for Gidx = 1:numA;
  G = AA(Gidx).getGeometry;
  NP = G.numPoints;
  Points = cell(NP,1);
  for PN = 1:NP
    P = G.getPoint(PN);
    Points{PN} = [P.x, P.y, P.z];
  end
  Geometries{Gidx} = Points;
end