08-23-2017 05:24 AM - last edited on 11-25-2018 11:17 PM by fcaelen
Hi , just clarification about data for analyzer view in M.App Enterprise.
the case is for POINT layer:
So the data must have one GEOMETRY columns with geometry type in projected CRS and two number columns (each for lon and lat) with nonProjected coordinates.
So there must be duplication of information and different CRS for them.
08-23-2017 05:32 AM
The default approach (using imported vector data from M.App Enterprise is the follwoing:
The geometry column of a point layer is used, just as for other geometry types. NO need for lat/lon columns. Also geographic coordinate systems can be used.
For using an online file:
Please use the Feature Analyzer documentation for more information about it.
08-23-2017 08:27 AM
Hi, I would like tu use M.App Enterprise layer (no online). So what column shoud be set in lat and lot box in analyzer? "GEOMETRY" (that is my oracle view column) or "geometry" that is any aditional column in the analyzer view, or it could be empty?
I'm sorry for this maybe stupid question, I have not found anywhere how to configure it in M.App Enterprise, and all my work ends unsuccessfully. ("Please wait - We're fetching your view data - this will only take a moment"). My data is Oracle view.
08-23-2017 08:36 AM
you don't need to use any column, just the vectorset, select it and then the dataset within it. Have you published the vectorset using ESPG:3857? This is needed for FA.
08-23-2017 08:52 AM
Hi Stefano, yes, I have published vectorset in epsg3857
my cache is:
C:\Program Files\Hexagon\M.App Enterprise\RUMCAJS_TENANT\VectorCache\RESULTS_GEOM_VS\EPSG3857\6
M.App E tile server is on tha same as M.AppE , win2016, postgis mastedDB and tenant DB, data in Oracle, 12.1 64bit client
What an I doing wrong..?
08-23-2017 08:57 AM
are you able to display the vector set in a desktop or standard browser app? can you check the developer console of your browser?
08-23-2017 01:00 PM
I did some simplification of my data...
So I have oracle table with the POINTs of towns . It works well with the feature analyzer and also in Browser application with the map (and legend) only.
I prepared the oracle view from this table. Very simple select of all table columns from the table nothing else. I did INSERT INTO USER_SDO_GEOM_METADATA .... and also geomedia metadata by database utilities. The view work well in geomedia desktop. Ale MAE browser application works well. But Feature analyzer ends with the "Please wait - we are fetching...". I found the issue in the console with one POST query=SELECT FROM VB_OBEC3857&format=csv that returns "ORA-00936: missing expression" .
It is the last item in the Network communication, and it end with status 500.
Could you try oracle views... please
08-23-2017 01:03 PM
one think yet, the size of the vector cache of the oracle table is 290816 B and the size of view is 147456 B. The data should be exactly the same. Maybe it is important, maybe not, I do not know...