I got problem when using the
http://docs.geoserver.org/2.1.3/user/data/sqlview.html SQL View function.
My objective is *to create layer in geoserver from joining 2 tables*.
I have 2 tables, *table_a*:
Table "public.table_a"
Column | Type |
Modifiers
--------------------+------------------------------+------------------------
id | integer |
not null default
name | character varying(30) | not null
remarks | text |
boundary | geography(MultiPolygon,4326) |
*And table_b*:
Table "public.table_b"
Column | Type |
Modifiers
-------------------------+-----------------------+-------------------------------
id | integer | not
null default
sequence | integer | not null
point | geography(Point,4326) |
table_a_id | integer | not null
*Here is the query for the SQL View*:
SELECT
table_a.name, table_a.remarks, table_a.boundary,
table_b.sequence, table_b.point, table_b.table_a_id
FROM
table_a
INNER JOIN table_b ON (table_a.id = table_b.table_a_id)
*And the result*:
Name | Type
-------------------+-----------
table_a.name | String
table_a.remarks | String
table_b.sequence | Integer
table_b.table_a_id | Integer
The problem with the result is the table_a.boundary column and table_b.point
column cannot be display.
The result is different when I tried with Publish function for each table:
http://osgeo-org.1560.n6.nabble.com/file/n4981004/publish.png
*Publish table_a*:
Name | Type
-------------------+-----------
name | String
remarks | String
boundary | MultiPolygon
*Publish table_b*:
Name | Type
-------------------+-----------
sequence | Integer
Point | Point
table_a_id | Integer
*My Question is:*
1. What is the query to create the MultiPolygon data type in GeoServer SQL
View from geography(MultiPolygon) in postgres data type?
2. What is the query to create the Point data type in GeoServer SQL View
from geography(Point) in postgres data type?
/I'm using:
1. PostgreSQL 8.4
2. Postgis-1.5.3 and I find that there is 2 types of geography in there:
1. '$libdir/postgis-1.5', 'geography_from_geometry' (from function
geography(geometry))
2. '$libdir/postgis-1.5', 'geography_enforce_typmod' (from function
geography(geography, integer, boolean))
3. GeoServer-2.1.3/
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Joining-2-tables-to-create-layer-in-Geoserver-with-MultiPolygon-and-Point-data-types-tp4981004.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
