02-26-2018 10:27 PM
I tried to create a vector service through Erdas Apollo from a layer in POSTGIS data server having epsg 4326. The data was inserted inside database through GeoMedia Desktop, after connecting through POSTGIS Read Write Data Server connection.
I used Database utilities to insert metadata tables into the database, before connecting the warehouse.
Once the data is inserted using Output to Feature Class in GeoMedia, if I try to publish this layer using Erdas Apollo Data Manager as a vector service, the service doesn't gets created without giving any error.
The geometry tables are mentioned as such in postgis;
-- Column: public.schools.geometry1_spa
-- ALTER TABLE public.schools DROP COLUMN geometry1_spa;
ALTER TABLE public.schools
ADD COLUMN geometry1_spa geometry(GeometryZ,4326);
Is there anything specific that is going wrong..
A connected post;
Solved! Go to Solution.
03-07-2018 04:55 AM
Do you have the issue if you import data into PostGIS using another tool than GeoMedia? Have you tried "PostGIS Shapefile Import/Export Manager" (tool installed when installing PostGIS)
Is there any error generated?
03-09-2018 12:07 AM
Sorry for delayed reply and thanks for joining in the discussion. Yes, when I use, PostGIS Shapefile Import/Export Manager and publish the data through Erdas Apollo it works fine (however the data doesn't works in GeoMedia Desktop), we also worked out using PostGISGDOBin utility.
Data published through GeoMedia Webmap or Erdas Apollo runs fine, after using the tool to insert metadata.
However, whenever we are publishing the Post GIS data after updating the metadata using Database utility tool from Erdas Apollo it fails to create a a service (rather a blank service is created), but if I use GeoMedia webmap to publish the same data..it is successful!
Any suggestion would be helpful.
03-09-2018 02:17 AM
Maybe this is because the APOLLO WFS connector doesn't support the 3D geometry in PostGIS. I need to check that, not sure.
What you can do is to create a view with a 2D geometry (https://postgis.net/docs/ST_Force2D.html) and then retry to create the service.
BTW, is there anything in the log (Tomcat-server.log) when you try to create a service?
03-19-2018 02:28 AM
Sorry for delayed reply..and thanks for the brilliant idea. I have not created a view but added a column and using the following query forced the 3d geometries to 2d, into that and maintained the projection. Now, they are visible using both the geometries, either through erdas apollo or geomedia webmap:
ALTER TABLE public.schools ADD geomtd geometry;
UPDATE public.schools SET geomtd = ST_Force2D(geometry1_spa);