On 05/19/2011 10:36 PM, Clay, Bruce wrote:
This is probably a question for the QGis folks but I wanted to check
here first where ther is likely a larger audience.
I create several spatial tables using PostGis and all are visible in
QGis on their own.
When I create a view in PostGis that reaches into a variety of tables
I see the name of the view in QGis but the type is "Waiting" and I get
an error indicating that QGis can not load the data because it is
"unable to determine srid and column shape in <view name>" then it
shows an error <view name>(shape) sql is an invalid layer.
You probably need to create an entry in the geometry_columns table for
this new view. Something like:
INSERT INTO geometry_columns \
(f_table_catalog,f_table_schema,f_table_name,f_geometry_column,srid,type,coord_dimension)
\
VALUES (....);
or even better, use the PostGIS function addgeometrycolumn()
The SQL is used to create the view follows:
CREATE OR REPLACE VIEW mission_data.S1_objects AS
select M1.object_name, M2.center_lat, m2.center_lon, M2.scene_id,
M2.OID,
ST_Transform(M2.shape,4326) as shape from
mission_data.mission_info M1
join mission_data.objects M2 ON M1.object_name = M2.object_name
where M1.mission_name = 'E3 Scenario 1' and M1.list_title = 'Object
List';
and I alos tried a simpler query
CREATE VIEW mission_data.S1_test AS
SELECT OID, ST_Transform(shape,4326) As shape, object_name
FROM mission_data.objects;
but they both gave the same errors
I did search the QGis forum web site but did not find anything clues
or reported issues
Bruce
This mail was received via Mail-SeCure System.
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
This mail was received via Mail-SeCure System.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
